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