The Britts & Straggon company manufactures small engines at three different plants. From the plants, the engines are transported to two different warehouse facilities before being distributed to three wholesale distributors. The per unit manufacturing cost at each plant is shown in the following table in addition to the minimum required and maximum available daily production capacities.

The unit cost of transporting engines from each plant to each warehouse is shown below.

The unit cost of shipping engines from each warehouse to each distributor is shown in the following table along with the daily demand for each distributor.

Each warehouse can process up to 500 engines per day.
a. Draw a network flow model to represent this problem.
b. Implement your model in Excel and solve it.
c. What is the optimalsolution?

Transcribed Image Text:

Minimum Required Production Maximum Production Capacity 400 300 600 Manufacturing 9 Plant Cost $13 $15 $12 150 150 150 Plant Warehouse 1 Warehouse 2 2 $5 Warehouse istributor 1 Distributor 2Distributor 3 $6 $3 300 $4 $5 600 $3 $2 100 Demand