using excel

using excel solver

3. Joe Montana loves steaks and potatoes. Therefore, he has decided to go on a steady diet of only these two foods (plus some liquids and vitamin supplements) for all of his meals. Joe realizes that this isn't the healthiest diet, so he wants to make sure the eats the right quantities of the two foods to satisfy some key daily nutritional requirements. He has obtained the nutritional and cost information shown in the table. Nutrient Grams per Serving Daily Steak Potatoes Requirement Carbohydrates 5 > SO Protein 20 > 40 Fat 15 Cost per Serving S3 15 5 2 C60 S8 a). Formulate a linear programming model for this problem statement b). What is the optimum solution for weekly production? C). What are the limiting resources