need question 1 and 2. all info is given.

please workout on excel for part 1. thank you

A Drer Example Breathtakers, a health and fitness center, operates a morning fitness program for senior citizens. The program includes aerobic exercise, either swimming or step exercise, followed by a healthy breakfast in the dining room. Breathtakers' dietitian wants to develop a breakfast that will be high in calories, calcium, protein, and fiber, which are especially important to senior citizens, but low in fat and cholesterol. She also wants to minimize cost. She has selected the following possible food items, whose individual nutrient contributions and cost information are shown in the following table. The dietitian wants the breakfast to include at least 420 calories, 5 milligrams of iron, 400 milligrams of calcium, 20 grams of protein, and 12 grams of fiber. Furthermore, she wants to limit fat to no more than 20 grams and cholesterol to 30 milligrams. The dietitian wants the breakfast to include at least 420 calories, 5 milligrams of iron, 400 milligrams of calcium, 20 grams of protein, and 12 grams of fiber. Furthermore, she wants to limit fat to no more than 20 grams and cholesterol to 30 milligrams. Let Xi - cups of bran cereal x2 - cups of dry cereal x3 = cups of oatmeal X4 - cups of oat bran Xs - e68s X6 - slices of bacon x = oranges Xx = cups of milk X cups of orange juice X10 = slices of wheat toast Breakfast Food Calories Protein Cost Fiber Iron (mg) 6 4 2 3 1 3 4 5 Bran cereal (cup) Dry cereal (cup) Oatmeal (cup) Oat bran (cup) Egs Bacon (slice) Orange Milk - 2% Orange juice (cup) Wheat toast (slice) Fat Cholesterol (mg) 0 0 2 0 2 0 2 0 5 270 3 8 0 12 0 0 1 0 90 110 100 90 75 35 65 100 120 65 Calcium (mg) 20 48 12 8 30 0 52 250 3 26 5 2 3 4 0 0 1 S0.18 0.22 0.10 0.12 0.10 0.09 0.40 0.16 0.50 0.07 7 2 1 9 1 0 1 0 ol Olom 1 Focus A Diet Example 2020 10 View References Mailings Tell me ut Review Table Design Layout Aalbcode Abedie AaBbCcDc ABCDE AaE Normal No Spacing Heading 1 Heading 2 A Aa A 21 APA EEE Milk -2% 100 Orange juice (cup) 120 Wheat toast (slice) 65 0.16 4 0 1 12 0 0 0 0 1 250 3 26 9 1 3 0 0 3 0.50 0.07 Min 0.18x+ 0.22x+ 0.10+ 0.124+ 0.10+ 0.09x + 0.40+ 0.16x+ 0.50x + 0.07 st. 90x 65x+ 120x+ 100x + 110x100x3+ 2x 90x4+ 2x+ 2x+ 35x+ 3x+ Bx 12 75x+ 5x+ 2704 1x 30x 7x 4x 48x 4x2 2x 20 3. 5xi 2x 120 5x 3x 3x4 8x4 6x4 4x4 652 420 Min. amt of calories 1xos 20 Max. amt of fat s 30 Max amt of cholesterol 1x25 Min amt of iron 2602 400 Min amt of calcium 3x 220 Min amt of protein 3x12 Min amt of fiber 20 Non-negativity 1x 52x 1x 1xy 250 9x 3x 1x Answer the following questions 1. Input the linear programming formulation into Microsoft Excel to generate the computer solution. Upload your Microsoft Excel solution (not a PDF or Picture) so that it can be re-run by the grader. Due Date: Sunday, October 11th by 11:59pm Decision Variables: Let Xi indicate the aty of breakfast food (l) in the breakfast, where i - 1 bran cereal, 2 dry cereal, 3 oatmeal, 4 oat bran, 5 egg, 6 bacon, 7 orange, 8 mik 9 orange juice, 10 wheat toast Objective function Minimize Z-0.18x1 +0.2222 +0.123 +0.1244 +0.15 0.09x6+0.4x7 +0.16x305x9 +0.07x10 SL Constraints 90x1 + 110x2100x3 90x4 + 755 +35x665x7 100x8120x9 +65x10 420 (calories) -(0) Ox1 +232 +233 2x4+5x5 + 3x6 +0x76x8 +0x91x1020_fut)--(2) Oxt + 0x20x3 + 0x4 + 27035 + 8x6 +0x7 + 12,8 +0x9 +0x10 30 (cholesterol) ---(3) 6x142 +233 +34 + 1x5 +0x6+1x70x80x9 + 1x10 >=5_tron)-4) 20x148X2 + 123 +4+30x50x652x7 250x83x26x10 >400_[calcium) - (5) 3x1 + x2 + 5x3 + 6x4 +75 +226 +1x7981x93x10 > 20_protest) (6) 5x1 +232 +3.3. 4x40x50x6+1x7 + 0x8 +0x9 + 3x10 > 12 (ber) --- (?) x1, x2, 3, 5, 6, 7, 8, 10> Cronegativity constraint) AL AaBbccdee Aabbcc de AaBbCcDc AaBbCcDdEx Heading 1 Heading 2 Normal No Spacing 2 Compute the chart on the next page to be submitted as a managerial report. Note that you will need to translate the allowable increase and decrease into the exact upper and lower limits. Due Date: Sunday, October 11th by 11:59pm Optimal z-value Variable Value Reduced Costs Constraint Slack/Surplus Dual Prices Bran cereal Dry cereal Oatmeal Oat bran Egg Bacon Orange Milk Orange Juice Wheat toast 1 (Min amt of calories 2 (Max amt of fat) 3 Max amt of cholesterol) 4 (Min amt. of iron) 5 (Min. amt. of calcium) 6 Min. amt of protein 7 Min. amt. of fiber) Current Value Upper Limit Range of Optimality Variable Lower Limit Bran cereal Dry cereal Oatmeal Oat bran Egs Bacon Orange Milk Orange Juice Wheat toast Range of Feasibility Lower Limit Current Value Upper Limit Constraint 1 (Min amt of calories) 2. Max amt of fat 3 Max amt of cholesterol) 4 (Min amt, of iron) 5 (Min amt. of calcium 6 Min. amt of protein) 7 Min. amt of fiber)