Maurices Pump Manufacturing Company

Provide written linear model and excel formulation using solver for each question:

5-17

Maurice’s Pump Manufacturing Company Currently maintains plants in Atlanta and Tulsa that supply major distribution centers in Los Angeles and New York. Because of an expanding demand, Maurice has decided to open a third plant and has narrowed the choice to one to the two cities- New Orleans or Houston. The pertinent information is listed in excel file under tab 5-17. Note that the costs and capacity listed for New Orleans and Houston are proposed/ anticipated.

5-22

A supply chain consists of three plants (A,B, and C) three distributors, (J,K, and L) and three stores (X,Y, and Z). The relevant supply, demand, and unti shipping cost information are given in the attached excel sheet under tab 5-22. Set up and solve the transshipment model to minimize total shipping costs.

5-25

Cindy Jefferson, hospital administrator at Anderson Hospital must appoint head nurses to four newly established departments: urology, cardiology, orthopedics, and pediatrics. Believing in the decision model in tab 5-25 in the excel sheet, Cindy has interviewed four nurses, Morris, Richards, Cook and Morgan and developed an index scale ranging from 0 to 100 to be used in the assignment. An index of 0 implies the nurse would be a perfect fit to the task. A value close to 100 on the other hand implies that the nurse is not suited to head that unit.  Which nurse should be assigned to each unit.