please include data for the spreadsheet. include data , decision variables , and objective function values

3.4-8. 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. 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 one-third of the diet (by weight) can consist of Feed Type A, since it contains an ingredient which is toxic if consumed in too large a quantity. (a) Formulate a linear programming model for this problem. D (b) Use the graphical method to solve this model. What is the resulting daily cost per pig? 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 boxes (data), red boxes (decision variables), and black boxes (objective function values)