Excel (Create Q4 Model)

4. (15 points) You work for a major supplier of paper products (paper towels, tissues. TP, etc.). You deliver your production of a mix of paper products in pallets from each of three production facilities to meet the needs at four distribution centers. There is a currently a critical need for pallets of your paper products at the distribution centers. In a normal market you have been supplying the distribution center needs based on a minimum cost model. However, now you want to minimize the total time for your deliveries so you need to determine the best solution to do so. You developed the table below with delivery times (in hours) for shipping a pallet of paper products from each production facility to each distribution center: Production Facility Charleston Savannah Wilmington Demand Atlanta 8 14 10 700 Retail Distribution Center St. Louis Dallas New York 52 80 50 70 95 66 62 86 58 500 1500 2000 Supply 2000 1000 1000 Use the 04 tab in you Excel file to solve this model What would the optimal shipments be? Complete the table below Ship? units From Hours Total