vi X v fx Instructions: Develop an Excel spreadsheet models for problem 2.23 on page 59 (textbook 1) on this worksheet, and run Excel Solver to obtain optimal solutions, Yo H A2 E F G B C D 1 Problem 1: Page 59 Problem 2.23 Instructions: Develop an Excel spreadsheet models for problem 2.23 on page 59 (textbook 1) on this worksheet, and run Excel Solver to obtain optimal solutions. Your model should be well organized with blue 2 boxes (data), red boxes (decision variables), and black boxes (objective function values) 3 4 5 6 7 8 9 10 11 12 Problem 1 Problem 2 Problem 3-Model | Problem 3-Sensitivity Repo ... + Ready 74OF Q Search 68 4 0 6/12/20 11:06 Mostly cloudy hp . . . . . . . . . . . . . . . . 10 4- 4+ 144 710 - 11 DDI insert prt s del a # % & A 6 7 8 O - backspace W F R T Y U O L A S D F H K L enter X pause C V ? B N M T shift alt alt ctrle. Use the graphical method by hand to solve this model 2.23. Dwight is an elementary school teacher who also raises pigs for supplemental income. He is trying to decide what to feed his pigs. He is considering using a combination of pig feeds available from local suppliers. He would like to feed the pigs at minimum cost while also making sure each pig receives an adequate supply of calories and vitamins. The cost, calorie content, and vitamin content of each feed is given in the table below. Contents Feed Type A Feed Type B Calories (per pound) 800 1,000 Vitamins (per pound) 140 units 70 units Cost (per pound) $0.40 $0.80 Each pig requires at least 8,000 calories per day and at least 700 units of vitamins. A further constraint is that no more than 1/3 of the diet (by weight) can consist of Feed Type A, since it contains an ingredient that is toxic if consumed in too large a quantity. a. Identify verbally the decisions to be made, the constraints on these decisions, and the overall measure of performance for the decisions. b. Convert these verbal descriptions of the constraints and the measure of performance into quantitative expressions in terms of the data and decisions. c. Formulate and solve a linear programming model for this problem on a spreadsheet. d. Formulate this same model algebraically. 2.24. Reconsider the Profit & Gambit Co. problem described in Section 2.7. Suppose that the estimated data given in Table 2.2 now have been changed as shown in the table that accompanies this problem. a. Formulate and solve a linear programming model on a spreadsheet for this revised version of the problem. . Formulate this same model algebraically. 59 7 622 Q Search 6/ hp . . 9 10 11 12 insert prt sc 8 + & backspace 6 7 8 9