• Formulate the mix problem for each product separately. What are the minimum cost solutions?
• Would the formulation differ if all three products were included together?
• Solve the combined problem. then add the 80-ton meat meal constraint and solve again.
• What would Smith's options be if he could purchase as much meat meal as needed at $365 per ton?

Discussion questions to address once you have used Solver for the assigned problems above:

1. Does the optimization provide any information that would be helpful in planning ingredient purchases?
2. How might the feed formulator incorporate ingredient inventories into the formulation problem?

 

TOTAL COST 186,887 PIG GROWER CAGE LAYER PIG SUPPLEMENT COST USAGE COST 2$ $ 32,611 COST $94,019 60,257 Tons Variables Corn Barley Soya Meal Meat Meal Lime Cost Tons Tons Used Availability 127 298.2 12.2 365.4 675.8 145 0.0 0.0 0.0 0.0 23.7 136.9 168.2 314 35.9 77.4 339 32.8 69.7 65.7 80 25 0.0 0.0 41.3 41.3 Dical 405 0.0 0.0 0.0 0.0 Required CONSTRAINTS Demand ME Poultry ME Swine Protein Calcium Phosphates Lysine Methionine Rqd/ton Produced Rd/ton Required Produced Rqd/ton Required Produced 400 367 120 106 600 550 O 240,761 1,199,693 1,200,000 6,000 335 2,675 1,605,000 1,200,000 6,000 300 1,605,000 1,651,508 10,270 2280 3,000 2,500 300,000 300,000 4,800 10,200 2280 15 40 4,800 684 17 0.75 5.5 660 3.8 0.6 240 240 2.5 300 300 0.7 420 420 0.61 244 267 240 275 0.68 408 506 0.2 80 105 0.45 54 62 0.28 168 168 Meth&Cystine Tryptophane 0.3 120 191 0.8 96 125 0.48 288 314 0.1 40 60 0.25 30 38 0.15 90 102 A B C E F G NUTRIENT MAKEUP Barley SoyaMeal 2,530 3,485 48.4 Corn Meat Meal Lime Dical ME Poultry ME Swine Protein Calcium Phosphates Lysine Methionine Meth&Cystine 3,500 3,325 2,865 2,870 1,984 2,540 50.9 8.7 10 0.02 0.06 0.3 9.7 39 16.5 0.33 0.28 0 2 0.69 4.02 21 0.35 3.2 2.82 0.2 0.15 0.7 0.62 0.33 0.32 1.44 1.24