Question

Leads to the formulation: Please show sensitivity report

a. What is the optimal solution, and what are the optimal production quantities?

b. Specify the objective coefficient ranges.

c. What are the shadow prices for each constraint? Interpret each.

d. Identify each of the right-hand-side ranges

Max s.t. 1W 1.25M

5W+ 7M < 4480 Whole tomatoes

3W+1M<2080 tomato sauce

2w+2m<1600 tomato paste

Please show all work using excel and solver , I need to see how you got the formulas breakdown to put into excel from the numbers above

Thanks

Answer 1

Answer:

a.         Optimal solution calls for the production of 560 jars of Western Foods Salsa and 240 jars of Mexico City Salsa; profit is $860.

b.

Variable	Objective Coefficient Range
Western Foods Salsa	0.893 to 1.250
Mexico City Salsa	1.000 to 1.400

c.

Constraint	Dual Value	Interpretation
1	0.125	One more ounce of whole tomatoes will increase profits by $0.125
2	0.000	Additional ounces of tomato sauce will not improve profits; slack of 160 ounces.
3	0.187	One more ounce of tomato paste will increase profits by $0.187

d.

Constraint	Right-Hand-Side Range
1	4320 to 5600
2	1920 to No Upper Limit
3	1280 to 1640