New Exercise Bank Content Qu$.05-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 New Exercise Bank Content Qu$.05-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.

Click here for the Excel Data File

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 $\frac{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.

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

a$.$ Determine the quantities of Feed A and Feed $B$ to feed the pigs.

Note: Round your answers to $2$ decimal places.

b$.$ Determine the total cost.

Note: Do not round intermediate calculations. Round your answer to $2$ decimal places.

Total cost

per poundeach

feed is given in the table below.

Click here for the Excel Data File

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 $\frac{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.

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

a$.$ Determine the quantities of Feed A and Feed $B$ to feed the pigs.

Note: Round your answers to $2$ decimal places.

b$.$ Determine the total cost.

Note: Do not round intermediate calculations. Round your answer to $2$ decimal places.

Total cost

per pound