Question: Please include formulation, model spreadsheet and answer A pet hotel makes dog food by mixing three grain products to obtain a balanced diet. The data

Please include formulation, model spreadsheet and answer

Please include formulation, model spreadsheet and

A pet hotel makes dog food by mixing three grain products to obtain a balanced diet. The data for the three products are shown in the following table: GRAIN PRODUCT COST PER POUND ($) PROTEIN (%) CARBOHYDRATE (%) FAT (%) A B 0.45 0.38 0.27 62 55 36 5 10 20 3 2 1 The manager wants to make sure that each of the dogs consumes at least 8 ounces protein and 1 ounce of carbohydrate, and no more than 0.5 ounces of fat each day. Develop a linear optimization model to determine how much of each grain product should be used in the dog food in order to minimize the cost. Solve it by Excel's solver. (16 ounces = 1 pound)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!