The Van Horne Company manufactures air conditioners that are sold to five large retail customers around the
Question:
The Van Horne Company manufactures air conditioners that are sold to five large retail customers around the country. Van Horne is evaluating its manufacturing and logistics strategy to ensure that it is operating as efficiently as possible. The company can produce air conditioners at six plants and stock these units in any of four different warehouses. The cost of manufacturing and shipping a unit between each plant and warehouse is summarized in the following table along with the fixed operating cost and monthly capacity for operating each plant:
Similarly, the per-unit cost of shipping units from each warehouse to each customer is given in the following table, along with the monthly fixed cost of operating each warehouse:
The monthly demand from each customer is summarized below:
a. Considering all of the costs and demands tabulated above, what is the minimum monthly operating cost for Van Horne’s supply chain?
b. Which plants and warehouses should Van Horne operate to meet demand in the most cost-effective manner?
Step by Step Answer:
Management Science The Art Of Modeling With Spreadsheets
ISBN: 1301
4th Edition
Authors: Stephen G. Powell, Kenneth R. Baker