this is operational research. Use SIMPLEX METHOD TO SOLVE. KINDLY HELP

Edit File View Format H Excel Insert Tools Data Window AutoSave OFF Insert Draw Formulas Data View Home Page Layout Review IMS Paste v v X Cut Calibri (Body) 11 ' [Copy B I U MA Format A2 fx D E F 1 DIET OPTIMIZATION CHALLENGE 2 3 Consider the problem of diet optimization. There are four different twpes of food: 4 Brownies, Ice Cream, Cola, and Cheese Cake. The nutrition values and cost per unit are 5 in the table below B C G H 6 7 Brownies Ice Cream Cola Cheese Cake 8 Calories 400 200 150 500 9 Chocolat 3 2 0 0 10 Sugar 2 2 4 4 11 Fat 2 4 1 5 12 13 Brownies Ice Cream Cola Cheese Cake 14 Cost ($) $ 0.50 $ 0.20 $ 0.30$ 0.80 15 16 The objective is to find a minimum-cost diet while keeping the following 17 requirements: 18 Types of food should have at least 500 calories 19 Types of food should have at least 6 grams of chocolate 20 Types of food should have at least 10 grams of sugar 21 Types of food should have at least 8 grams of fat 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 LEGOPOLIS LEGO-Step1 LEGO-Step 2 I FG Sten Paste insert $ % ) 78 -48 Delete Merge & Center Format Conditional Format Cel Formatting as Table Styles Format BIU Xfx P28 E 1 F 1 D K B L N C M D P R w 5 v 16 17 As an expression (How Is your goal determine?) As expression (How Is your goal determine . 18 19 20 21 Express constraints in terms of decision variables 22 23 What are the decision variables? 24 in words (What information is used to determine your objective function?) 25 26 27 28 29 30 As variables 31 32 34 15 36 37 39 40 41 42 43 45 16 Paste B TU a.A- Merge & Center $ % ) Lb Copy Format x Cond Form N2 c D E G H K M N 0 P . INSTRUCTIONS Have 1 students share screen in breakout room so evesyone in team can colaborate Use alt+enter (Windows) or Control+Option+Enter / Control+Command+Enter (mac) to move to a new line in the submission boxes Share completed sheet with all team members 10 11 DECISION VARIABLES 12 13 14 15 OBJECTIVE FUNCTION 16 17 18 19 20 21 CONSTRAINTS 22 23 24 25 26 27 28 29 30 31