What is the optimal value

Assignment Help Operation Management

Reference no: EM131799015

Ames Manufacturing Plant produces two different replacement parts for dishwashers. During a normal shift, they have 7 hours of time available on their main fabrication machine.

The machine will process 40 of Part X in an hour and 25 of Part Y. Each Part X requires .5 hours to assemble and each Part Y requires .4 hours.

Ames has 64 hours if labor available on this line each shift. The painting booth can handle 40 parts per hour and can be used a max of 6 hours per shift. Ames has a $45 profit margin for Part X and $40 for Part Y. Below you can see the spreadsheet model with the optimal profit maximizing production plan and the sensitivity analysis. Answer the questions based on this output.

Time is in hours
Machining: Part X:.03 Part Y:.04. Available:7
Labor: Part X:.5 Part Y:.4 Available:64
Painting: Part X:.03 Part Y:.03 Available:6
Unit Profit: Part X:$45 Part Y:$40

Production Plan: Part X:0. Part Y:160

LHS RHS
Machining: 6.4 <= 7
Labor: 64<= 64
Painting: 4<= 6

Total Profit: 6400

Adjustable Cells

Cell. Name
$B$19 Production Plan Part X
Final Value: 0
Reduced Cost: -5
Objective Coefficient: 45
Allowable Increase: 5
Allowable Decrease: 1E+30

Cell: $C$10
Name: Production Plan Part Y
Final Value: 160
Reduced Cost: 0
Objective Coefficient: 40
Allowable Increase: 1E+30
Allowable Decrease: 4

Constraints

Cell: $B$13
Name: Machining LHS
Final Value: 6.4
Shadow Price: 0
Constraint RHS: 7
Allowable Increase: 1E+30
Allowable Decrease:.6

Cell: $B$14
Name: Labor LHS
Final Value:64
Shadow Price: 100
Constraint RHS: 64
Allowable Increase:6
Allowable Decrease: 64

Cell: $B$15
Name: Painting LHS
Final Value: 4
Shadow Price: 0
Constraint RHS: 6
Allowable Increase: 1E+30
Allowable Decrease: 2

A) What is the optimal solution?

B) What is the optimal value?

C) At what minimum Unit Profit would Ames consider manufacturing Part X?

D) The materials requirements for Part Y changed increasing its cost of production by $2 per unit. What impact will this have on the production plan and profit?

E) The materials requirements for Part Y changed increasing its cost of production by $5 per unit. What impact will Thai have on the production plan and profit?

Please explain

Reference no: EM131799015

Questions Cloud

Make stockholders equity section of patterson balance sheet : Prepare the stockholders' equity section of Patterson's balance sheet (in thousands). How can Patterson have a larger balance of treasury stock

How did the american federation of labor ideology differ : How did the American Federation of Labor(AFL) ideology differ from the Industrial Workers of the World(IWW) and how did ideologies affect the structure.

Analyze the some of the ethical issues that nike is facing : From Nike's standpoint, is this a fair assessment of their ethical standards? Analyze the some of the ethical issues that Nike is facing in the case.

Treatments produced the data : A random sample of five observations from three treatments produced the following data:

What is the optimal value : The materials requirements for Part Y changed increasing its cost of production by $2 per unit. What impact will this have on the production plan and profit?

Random sampling from four treatments : Random sampling from four treatments produced the following data:

Investigate a quality improvement organization : Investigate a quality improvement organization to determine its potential applicability in healthcare improvement

Why is accounting important in your career and personal life : Why is Accounting important in your career and personal life, so it costs me a one-time fee of $40 to use Groupon for each new customer

How does analyzing strategic management cases help : How does analyzing strategic management cases help develop the ability to differentiate, speculate, and integrate when evaluating complex business problems?

User Account

All Pages