Question: AutoSave OFF Lesson3_XLOptimization_c @ES Page Layout Formulas Home Insert Draw Data Review View Tell me X Calibri (Body) V 11 2bWrap Text General A Av

AutoSave OFF Lesson3_XLOptimization_c @ES Page
AutoSave OFF Lesson3_XLOptimization_c @ES Page Layout Formulas Home Insert Draw Data Review View Tell me X Calibri (Body) V 11 2bWrap Text General A Av ibil III H% Paste B IV Merge & Center $ % ) MIT 128 M 1 Question 1: You manage the cost of a meal for a shelter. You have three menu items to serve chicken, carrot and potato. You must meet minimum nutritional requirements for the meal while managing cost: Chicken Carrot Potato Cost S/kg $8.25 $2.85 $3.75 Calories cal/kg 1430 410 1990 Fiber /kg 5.0 37.0 28.0 Protein g/kg 170 9 29 You are to decide how many kg of chicken, carrots and potato to serve to minimize the cost to the shelter You are constrained by each meal must provide a minimum of 650 calories, 15 grams of fiber and 35 grams of protein, Each meal must include at least 0.05 kg of each item What is the cost? Use Solver to to optimize this related set of equations This is a linear programming/optimization problem. Follow the pattern of solution shown in the lesson to solve this problem, 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

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!