Answered step by step
Verified Expert Solution
Question
1 Approved Answer
7 points for the model. 5 points for OPL. 3 points for a readable solution that is presentable to the CEO. Format: Solution OPL code
7 points for the model. 5 points for OPL. 3 points for a readable solution that is presentable to the CEO. Format: Solution OPL code including script file and output if used. You work for a pet food maker. You make 6 types of pet food and the relevant information is given in the table. There are 9 products that go into each product and the nutritional information and cost are also given. You can assume that anything that you produce is sold. You have a capacity of only being able to produce 800 tons a day. To keep your foot in the market place, you must buy at least 10 tons of every ingredient. Given all of this information what should the company do? Min/Max Min Min/max Min Min/max Revenue Calories Vitamins Protein meat to produce Per percent in tons Ton (2000 lbs) Generic 700/720 250 60/100 10% 50/100 4000 Budget 600-800 260 30/70 15% 200/400 5000 Puppy 875-975 90/140 40% 50/100 10000 Elite 745-755 350 100/130 50% 30/60 12000 Adult 550-650 300 40/70 30% 200/500 7000 Veterinary 860-940 350 120/130 75% 10/20 30000 - 300 Ingredients 250 Chicken Lamb Beef Pork Corn Soybeans Straw/hay Wheat Sorghum Cost per Maximum Vitamins Protein ton Tons 1b lb available 1700 40 110 1300 50 400 140 2000 100 450 150 1500 70 300 130 700 150 200 20 800 170 190 40 100 300 100 5 600 200 170 25 900 100 180 35 7 points for the model. 5 points for OPL. 3 points for a readable solution that is presentable to the CEO. Format: Solution OPL code including script file and output if used. You work for a pet food maker. You make 6 types of pet food and the relevant information is given in the table. There are 9 products that go into each product and the nutritional information and cost are also given. You can assume that anything that you produce is sold. You have a capacity of only being able to produce 800 tons a day. To keep your foot in the market place, you must buy at least 10 tons of every ingredient. Given all of this information what should the company do? Min/Max Min Min/max Min Min/max Revenue Calories Vitamins Protein meat to produce Per percent in tons Ton (2000 lbs) Generic 700/720 250 60/100 10% 50/100 4000 Budget 600-800 260 30/70 15% 200/400 5000 Puppy 875-975 90/140 40% 50/100 10000 Elite 745-755 350 100/130 50% 30/60 12000 Adult 550-650 300 40/70 30% 200/500 7000 Veterinary 860-940 350 120/130 75% 10/20 30000 - 300 Ingredients 250 Chicken Lamb Beef Pork Corn Soybeans Straw/hay Wheat Sorghum Cost per Maximum Vitamins Protein ton Tons 1b lb available 1700 40 110 1300 50 400 140 2000 100 450 150 1500 70 300 130 700 150 200 20 800 170 190 40 100 300 100 5 600 200 170 25 900 100 180 35
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started