Question: Solve LP problems via Excel Solver. Report your answers in detail, and submit an Excel worksheet on Canvas. Question 1 is one of in-class exercises

Solve LP problems via Excel Solver. Report yourSolve LP problems via Excel Solver. Report your

Solve LP problems via Excel Solver. Report your answers in detail, and submit an Excel worksheet on Canvas. Question 1 is one of in-class exercises Question 2 is one of problems from Homework 4 Question 3 is new. Thus, please also submit a paper-based formulation as well. 1. My diet requires that all the food I eat come from one of the four basic food groups (chocolate cake, ice cream, soda, and cheesecake). At present, the following four foods are available for consumption: brownies, chocolate ice cream, cola, and pineapple cheesecake. Each brownie costs 50, each scoop of chocolate ice cream costs 20, each bottle of cola costs 30, and each piece of pineapple cheesecake costs 80. Each day, I must ingest at least 500 calories, 6 oz. of chocolate, 10 oz. of sugar, and 8 oz. of fat. The nutritional content per unit of each food is shown in Table 1. Formulate a LP model that can be used to satisfy my daily nutritional requirements at minimum cost. [25 points) Chocolate (oz.) Sugar (oz.) Fat (oz.) Table 1. Nutrition Values for Diet Type of Food Calories Brownie 400 Chocolate ice cream (1 scoop) Cola (1 bottle) 150 Pineapple cheesecake (1 piece) 500 200 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!