Question: 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?
- 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:
- Does the optimization provide any information that would be helpful in planning ingredient purchases?
- How might the feed formulator incorporate ingredient inventories into the formulation problem?
$ 186,887 TOTAL COST USAGE CAGE LAYER PIG SUPPLEMENT COST $32,61 PIG GROWER COST $94,019 COST 60,257 Tons Availabilit Used Tons Tons Cost Variables 675.8 365.4 12.2 298 Corn 145 Barley 136.9 Soya Meal Meat Meal Lime 80 168.2 339 405 Dical CONSTRAINTS Rad/ton Required Produced Rad/ton Required Produced Rqd/ton Required Produced 550 106 120 600 400 Demand 0 240,761 2,675 1,605,000 1,605,000 0 1,651,508 10,270 2280 420 506 0 1,199,693 ME Poultry 2,500 300,000 300,000 4,800 4,800 684 300 3,000 1,200,000 1,200,000 6,000 300 240 ME Swine 17 10,200 2280 420 408 6,000 Protein 660 335 Calcium 300 240 240 Phosphates Lysine 275 267 105 191 244 168 168 Methionine 125 288 120 Meth&Cystine Tryptophane 0.15 38 0.25 NUTRIENT MAKEUP Dical Lime Meat Meal Barley SoyaMeal 2,865 2,870 Corn 1,984 2,540 2,530 ME Poultry ME Swine 3,500 3,485 3,325 Protein 0.02 Calcium 21 Phosphates Lysine Methionine 2.82 0 Meth&Cystine $ 186,887 TOTAL COST USAGE CAGE LAYER PIG SUPPLEMENT COST $32,61 PIG GROWER COST $94,019 COST 60,257 Tons Availabilit Used Tons Tons Cost Variables 675.8 365.4 12.2 298 Corn 145 Barley 136.9 Soya Meal Meat Meal Lime 80 168.2 339 405 Dical CONSTRAINTS Rad/ton Required Produced Rad/ton Required Produced Rqd/ton Required Produced 550 106 120 600 400 Demand 0 240,761 2,675 1,605,000 1,605,000 0 1,651,508 10,270 2280 420 506 0 1,199,693 ME Poultry 2,500 300,000 300,000 4,800 4,800 684 300 3,000 1,200,000 1,200,000 6,000 300 240 ME Swine 17 10,200 2280 420 408 6,000 Protein 660 335 Calcium 300 240 240 Phosphates Lysine 275 267 105 191 244 168 168 Methionine 125 288 120 Meth&Cystine Tryptophane 0.15 38 0.25 NUTRIENT MAKEUP Dical Lime Meat Meal Barley SoyaMeal 2,865 2,870 Corn 1,984 2,540 2,530 ME Poultry ME Swine 3,500 3,485 3,325 Protein 0.02 Calcium 21 Phosphates Lysine Methionine 2.82 0 Meth&Cystine
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help