The WoofWoof Store specializes in food products for dogs and other household pet
ID: 406587 • Letter: T
Question
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.20Explanation / Answer
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
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.