WILL GIVE THUMBS UP, please provide excel functions in writing. someone posted and did it wrong so reposting

. Question 1) [15 points] Dallas Stars hockey team wants to hire a dietitian in order to develop new meal plans for its players during the next NHL season. The dietitian responsibility is to attempt to determine a nutritious menu for the team. The team managers and coaches have set the following nutritional guidelines for each serving: Between 1,500 and 2,000 calories At least 20 but no more than 60 g of fat At least 40 g of carbohydrates At least 30 g of protein At least 5 mg of iron No more than 30 mg of cholesterol . The dietitian needs to select the menu from seven basic food items, as follows, with the nutritional contribution per pound and the cost as given: Fat Calories Iron (per lb.) (mg/lb.) 520 4.4 Protein (g/lb.) Carbohydrate (g/lb.) Cholesterol (mg/lb.) Cost ($/lb.) (g/lb.) Chicken 17 30 180 0.8 | Fish 500 3.3 85 5 90 3.7 Ground beef 860 0.3 82 0 75 350 2.3 Dried beans 600 3.4 10 30 3 0 0.9 Lettuce 50 0.5 6 0 0 0 0.75 Potatoes 460 2.2 10 70 0 0 0.4 Milk (2%) 240 0.2 16 22 10 20 0.83 The management wants to select a menu to meet the nutritional guidelines while minimizing the total cost per serving. a) Formulate a linear programming model for this problem (The mathematical model can be either typed or handwritten. Do not put the mathematical model inside the excel file). b) Solve the model by using the computer (Please submit the excel file containing the solution and the solver configuration along with the report) and report the optimal solution and objective function in your report. c) If a serving of each of the food items (other than milk) was limited to no more than a half- pound, what effect would this have on the solution? (Justify your answer)