solve using excel solver, you know what you're doing though. :D

9. Recall the TJ Inc.'s problem (Chapter 2. Problem 28). Letting W = jars of Western Foods Salsa M = jars of Mexico City Salsa leads to the formulation: Max 1W + 1.25M s.l. 5W + 7M s 4480 Whole tomatoes 3W + IM S 2080 Tomato sauce 2W + 2M S 1600 Tomato paste WM0 FIGURE 3.15 THE SOLUTION FOR THE TJ INC'S PROBLEM 860.00000 Optimal objective Value = Variable Reduced Cost Value 560.00000 240.00000 W M 0.00000 0.00000 Constraint Slack/Surplus Dual Value 1 2 3 0.00000 160.00000 0.00000 0.12500 0.00000 0.18750 Objective Coefficient Variable Allowable Increase Allowable Decrease W M 1.00000 1.25000 0.25000 0.15000 0.10714 0.25000 Constraint RHS Value Allowable Increase Allowable Decrease 1 2 3 4480.00000 2080.00000 1600.00000 1120.00000 Infinite 40.00000 160.00000 160.00000 320.00000 The computer solution is shown in Figure 3.15. a. What is the optimal solution, and what are the optimal production quantities? b. Specify the objective function ranges, c. What are the dual values for cach constraint? Interpret cach. d. Identify each of the right-hand-side ranges