The WoofWoof Store specializes in food products for dogs and

The WoofWoof Store specializes in food products for dogs and other household pets. In developing a new puppy food, company nutrionists have specificied that the mixture must contain at least 16% protein, 13% fat, 12% vitamin and no more than 15% fiber. The percentages of each nutrient in the available ingredients, along with their cost per pound, are shown in the following table.

What is mixture that will have the minimum cost per pound and meet the stated nutrional requirement?

Write the equations in a WORD document. .

Take a screenshot of SOLVER before you run it

Nutrient	Beef	Pork	Corn	Fame	rice	chicken
Protein %	16.9	12	8.5	15.4	8.5	18
Fat %	26	4.1	3.8	6.3	3.8	17.9
Vitamin %	19	10.2	4.7	3.7	4.2	23
Fiber	29	8.3	2.7	2.4	2.7	28.8
Cost $/lb	0.22	0.19	0.10	0.10	0.07	0.20

Solution

Mix 1 2 2 2 2 1 Beef Pork Corn Fame rice chicken Countt Avg 16.9 24 17 30.8 17 18 6 20.61667 TRUE 26 8.2 7.6 12.6 7.6 17.9 6 13.31667 TRUE 19 20.4 9.4 7.4 8.4 23 6 14.6 TRUE 29 16.6 5.4 4.8 5.4 28.8 6 15 TRUE 0.22 0.38 0.2 0.2 0.14 0.2 6 0.223333