Planning for new manufacturing facility

Assignment Help Operation Management

Reference no: EM131305872

PJ Shops is planning to expand its facilities. Currently they are planning for a new manufacturing facility in Lyman. The shop they have purchased for this expansion has 50,000 square feet of useable space. The budget for the expansion project is 10,000,000. Management is attempting to allocate this space among four departments. Historical trends are shown in the following table:

Profit (sqft) Invest (sqft) Min. Size Max. Size

Grind 40.00 120 10,000 25,000

Broach 30.00 240 20,000 35,000

Mill 25.00 150 5,000 10,000

Assemble 15.00 50 2,000 10,000

Additionally, the Grind department cannot be more than 15% larger than the Broach department

Requirement 1: provide your profit-maximizing LP formulations (state the objective function and constraints)

Requirement 2: provide the Excel Solver solution in a screen capture for the problem.

Reference no: EM131305872

Questions Cloud

How can online retailers form strong relationships : How can online retailers form strong relationships with customers that are technology adverse?

Do you agree with the proposed policy solutions : State your position on the issue. Do you agree with the proposed policy solutions? Why or why not? Recommend your own policy solution, if you do not agree with any of the proposed policy alternatives.

Sample size formulas for nonprobability samples : Which of the following statements is true of sample size formulas for nonprobability samples? In which stage of the sampling plan will random-digit dialing probably be considered?

What product have you purchased from this brand : What product(s) have you purchased from this brand?Why did you purchase this product?What made you interested in buying this product compared to a competitor?What would you do to influence other consumers to purchase from this brand's product line?

Planning for new manufacturing facility : PJ Shops is planning to expand its facilities. Currently they are planning for a new manufacturing facility in Lyman. The shop they have purchased for this expansion has 50,000 square feet of useable space. Additionally, the Grind department cannot b..

Who are the stakeholders involved in the policy topic : How does the policy topic affect society? Who are the stakeholders (directly or indirectly) involved in the policy topic? What are the key questions or controversies associated with the policy topic?

Why each type of information may be important to the person : Choose one category and provide examples of the types of information the person would be interested in. Explain why each type of information may be important to the person.

Take as law enforcement official in gangs area of operation : Finally outline what steps, based on this week's studies, you would take as a law enforcement official in the gang's area of operation to control the gang you chose.

Evaluate 2 proposed alternatives regarding the insulin pump : Based on both your quantitative analysis and non quantitative issues identify which alternative should be selected and support your decision.

User Account

All Pages