Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Solve LP problems Via Excel Solver. Report your answers in detail. and submit an Excel worksheet on Canvas. Question 1 is one of inclass exercises
Solve LP problems Via Excel Solver. Report your answers in detail. and submit an Excel worksheet on Canvas. Question 1 is one of inclass 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. 1 must ingest at least 500 calories. 6 oz. of chocolate, [0 oz. of sugar. and 8 oz. of fat. The nutritional content per unit of each food is shown in Table l. Formulate a LP model that can be used to satisfy my daily nutritional requirements at minimum cost. [25 points] Table 1. Nutrition Values for Diet Txpe of Food Calories Chocolate (on) Sugar (01.) Fat (1):.) Brownie 400 3 2 2 Chocolate ice cream (1 scoop) 200 2 2 4 Cola (1 bottle) 150 0 4 1 Pineapple cheesecake (1 piece) 500 0 4 5 2. A hospital employs volunteers to staff the reception desk between 8 am and 10 pm. The stafng level required per time period is shown below: Time window Minimum alt needed Sam10am 4 10amnoon 6 noon2pm 8 2pm4pm 6 4pm6pm 4 6pm8pm 6 8 8pm 10pm The volunteers are willing to begin their shifts at any hour from 8 am to 8 pm, except noon or 6 pm. Each volunteer works three consecutive hours except for those starting at 8 pm, who work two hours. Even though the volunteers donate their time, the hospital wants to use the minimum total number of volunteers. Formulate an LP determine the number of volunteers that should work in each shift. [25 points]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started