1. Business
  2. Operations Management
  3. please solve using excel and solver addon to solve following...

Question: please solve using excel and solver addon to solve following...

Question details

PLEASE SOLVE USING EXCEL AND SOLVER ADD-ON TO SOLVE FOLLOWING TRANSPORTATION LP PROBLEM. PLEASE SHOW STEP-BY-STEP INSTRUCTIONS AND INCLUDE SCREEN SHOT OF THE SOLVER ANSWER REPORT. THANK YOU.

11. Montefiore Hospital in New Rochelle, New York has initiated a new procedure for ensuring 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 stations in the building. From there, the food will be reheated, meals will be placed on individual trays, loaded onto a car, 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: LocationCapacity (Meals) Station 5A200 Station 3G Station 1S 225 275 There are six wings to Montefiore Hospital that must be served. The number of patients in each wing is as follows: Wing 2 3 4 80 120 150 210 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 appropriate distribution of food from serving station to wing.

The table below summarizes the time associated with each possible distribution channel Distribution time (minutes) TO Wing1 Wing2Wing 8 Wing4 Wing 5Wing 6 Station 5A Station 3G Station 1S 12 12 8 8 6 6 7 What is your recommendation for handling the distribution of trays from the three serving stations?

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution