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 are given in the table below.

CONTENTS. FEED TYPE A. FEED TYPE B

Calories(per pound) 800 1,000

Vitamin(per pound) 140 units 70 units

Cost(per pound) $0.40 $0.80

C. Formulate and solve a linear programming model for this problem on a spreadsheet.

If you are able to solve this can you also explain how you did it on the Excel solver and the formulas.