Problems:
Excel Solver - linear programming model
London General, a large hospital in London, England, 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:
There are six wings to Northwest General that must be served. The number of patients in each follows:
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.
