Apron Outfitters is a manufacturer of aprons, jackets, and vests for a variety of occupations, including golf caddies, chefs, and carpenters. Assume that Apron Outfitters needs to schedule shipments of aprons from its three manufacturing plants to its four warehouses. The company has generated the following model using Excel’s Solver Add-In. Using the model results, answer the following questions:

a. What is the goal of the model?

b. What is the total cost of the recommended shipping model?

c. How does total capacity compare to demand?

d. How many units need to be shipped from Plant 1 to Warehouse 3?

e. How much does cost need to change for Plant 2 to ship to Warehouse 3?

Transcribed Image Text:

Network Transportation Problem Cost per unit delivery Plant 1 Plant 2 Plant 3 Recommend Shipping Model Plant 1 Plant 2 Plant 3 Received Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 2.69 2.44 2.02 Demand. 1250 1250 3.40 3.12 4.32 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Ship 450 0 689 250 200 1300 0 600 0 0 >= 1300 1300 >= 3.09 5.08 4.51 TotalCost $ 9,704.42 $ 2,909.84 $ 4,051.39 $ 689 689 X= 2.45 5.67 3.21 2,129.50 $ DO 0 0 250 250 613.69 1389 <= 1500 <= 600 <= 3489 Total Capacity 2000 1500 600 4100 Tulal