USE EXCEL ONLY!!!!!!!!! NO MATLAB OR LINDO!!!!!!!! PLEASE.

Part A: Determine the combination of ingredients that minimizes calories but meets all nutritional requirements. i. Formulate the problem as a linear program with an objective function and all constraints. ii. Determine the optimal solution for the linear program using any software you want. Include a copy of the code file in the report. iii. What is the cost of the low calorie salad? Part B: Veronica realizes that it is also important to minimize the cost associated with the new salad. Unfortunately some of the ingredients can be expensive. Determine the combination of ingredients that minimizes cost. i. Formulate the problem as a linear program with an objective function and all constraints. ii. Determine the optimal solution for the linear program using any software you want. Include a copy of the code file in the report. iii. How many calories are in the low cost salad? calories but meets certain nutritional requirements. A salad is any combination of the following ingredients: Tomato, Lettuce, Spinach, Carrot, Smoked Tofu, Sunflower Seeds, Chickpeas, Oil. . Each salad must contain: At least 15 grams of protein At least 2 and at most 8 grams of fat At least 4 grams of carbohydrates At most 200 milligrams of sodium At least 40% leafy greens (lettuce and spinach) by mass. . Sodium Cost The nutritional contents of these ingredients (per 100 grams) and cost are Ingredient Energy Protein Fat Carbohydrate (cal) (grams) (grams) (grams) Tomato 21 0.85 0.33 4.64 (mg) (100g) 9.00 $1.00 Lettuce 16 1.62 0.20 2.37 28.00 $0.75 Spinach 40 2.86 0.39 3.63 65.00 $0.50 Carrot 41 0.93 0.24 9.58 69.00 $0.50 585 23.4 48.7 15.00 3.80 $0.45 Sunflower Seeds Smoked Tofu 120 16.00 5.00 3.00 120.00 $2.15 Chickpeas 164 9.00 2.6 27.0 78.00 $0.95 Oil 884 0 100.00 0 0 $2.00