Question: I need to know what the optimal solution is and how you came up with it. A print out of the optimal solution (i.e., optimal

I need to know what the optimal solution is andI need to know what the optimal solution is and how you came up with it. A print out of the optimal solution (i.e., optimal routing plan) obtained by Excel and a short paragraph describing your findings and what they mean.

I need to know what the optimal solution is and

Contenx Bb 128138 X https://X Bb 131197 X Bb 229194 X Bb Collx Bb 133862 X BD 133862X BB 133862 X M Home x C Interne X C Get Hox + https://leam-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com/5f0000254d1af/13813887X-Blackboard-Expiration=16263288000008 X-Bla. ta vo 1 oft a V Draw Highlight Erase + ID Page view l A Read aloud Northwest General Hospital Northwest General, a large hospital in Providence, Rhode Island, has initiated a new procedure to ensure that patients receive their meals while the food is still as hot as possible. The hospital will continue to prepare the food in its kitchen, but will now deliver it in bulk (not individual servings) to one of three new serving stations in the building. From there, the food will be reheated, meals will be placed on individual trays, loaded onto a cart, and distributed to the various floors and wings of the hospital The three new serving stations are as efficiently located as possible to reach the various hallways in the hospital. The number of trays that each station can serve are shown below: LOCATION CAPACITY (MEALS) Station SA 200 Station 3G 225 Station IS 275 There are six wings to Northwest General that must be served. The number of patients in each follows: WING PATIENTS 1 80 2 120 3 150 4 210 60 5 6 80 The purpose of the new procedure is to increase the temperature of the hot meals that the patient receives. Therefore, the amount of time needed to deliver a tray from a serving station will determine the proper distribution of food from serving station to wing. The table below summarizes the time associated with each possible distribution channel. DISTRIBUTION TIME (minutes) TO Wing 1 Wing 2 Wing 3 Wing 4 Wing 5 Wing 6 FROM 1 Station SA 12 11 8 9 6 6 Station 3G 6 12 7 7 5 8 Station IS 8 9 6 6 7 9 Type here to search O E H # 26 78F AQI 57 8:09 PM 7/14/2021 Contex C North X W find X + BL 13492 X Bb 1381 X BL 13119 X Bb2291 X Bb C X B 13381 X 36 1338 | M Home | Inter X C Inter x C North X https://www.chegg.com/homework-help/questions-and-answersorthwest-general-large-hospital-providence-rhode-island-initiated-new-pr... 0 Ta vo Study Pack = Chegg Study Textbook Solutions Expert Q&A Practice 4** ANOU The optimal solution with the objective value Decision variable xi Wing 1 Wing 2 2 Wing 3 Wing 4 Wing 5 Wing 6 From Station 1 0 55 5 60 80 Station 2 30 0 145 0 0 0 Station 3 0 65 O 210 0 0 Objective value = 4625 (minutes) Hide comments Comments Leave a comment Type here to search O EP 26 82F AO 00 1:17 PM 7/15/2021

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!