# Question

The Move-It Company has two plants producing forklift trucks that then are shipped to three distribution centers. The production costs are the same at the two plants, and the cost of shipping for each truck is shown for each combination of plant and distribution center:

A total of 60 forklift trucks are produced and shipped per week. Each plant can produce and ship any amount up to a maximum of 50 trucks per week, so there is considerable flexibility on how to divide the total production between the two plants so as to reduce shipping costs. However, each distribution center must receive exactly 20 trucks per week.

Management’s objective is to determine how many forklift trucks should be produced at each plant, and then what the overall shipping pattern should be to minimize total shipping cost.

(a) Formulate this problem as a transportation problem by constructing the appropriate parameter table.

(b) Display the transportation problem on an Excel spreadsheet.

A total of 60 forklift trucks are produced and shipped per week. Each plant can produce and ship any amount up to a maximum of 50 trucks per week, so there is considerable flexibility on how to divide the total production between the two plants so as to reduce shipping costs. However, each distribution center must receive exactly 20 trucks per week.

Management’s objective is to determine how many forklift trucks should be produced at each plant, and then what the overall shipping pattern should be to minimize total shipping cost.

(a) Formulate this problem as a transportation problem by constructing the appropriate parameter table.

(b) Display the transportation problem on an Excel spreadsheet.

## Answer to relevant Questions

Redo Prob. 9.1-7 when any distribution center may receive any quantity between 10 and 30 forklift trucks per week in order to further reduce total shipping cost, provided only that the total shipped to all three distribution ...For the network shown below, use the augmenting path algorithm described in Sec. 10.5 to find the flow pattern giving the maximum flow from the source to the sink, given that the arc capacity from node i to node j is the ...Reconsider the maximum flow problem shown in Prob. 10.5- 6. Formulate this problem as a minimum cost flow problem, including adding the arc A → F. Use F–bar = 20. Reconsider the minimum cost flow problem formulated in Prob. 10.6-3. The 21st Century Studios is about to begin the production of its most important (and most expensive) movie of the year. The movie’s producer, Dusty Hoffmer, has decided to use PERT/CPM to help plan and control this key ...Post your question

0