Question: A linear programming model has been formulated in a spreadsheet to determine the production levels that would maximize profit. However, only the sensitivity analysis is

A linear programming model has been formulated in a spreadsheet to determine the production levels that would maximize profit. However, only the sensitivity analysis is available (see below):
Variable Cells
Cell : Name : Final Value : Reduced Cost : Objective Coefficient : Allowable Increase : Allowable Decrease.
$B$10 : Production Plates : 300 : 0 : 3.1 : 2.23 : 0.37.
$C$10 : Production Mugs : 0 : -0.46 : 4.75 : 0.46.
$D$10 : Final Reduced : 400 : 0 : 4 : 0.65 : 1.37
Constraints
Cell : Name : Final Value : Shadow Price : Constraint R.H.Side : Allowable Increase : Allowable Decrease.
$E$5 : Molding (minutes ) Used : 2400 : 0.22 : 2400 : 200 : 600.
$E$6 : Finishing (minutes ) Used : 7200 : 0.28 : 7200 : 2400 : 2400.
$E$7 : Clay (ounces ) Used : 2700 : 0 : 3000 : 1E+30.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!