Operations Research - Transportation

WPC has 4 assembly plants in Europe. They are located in Leipzig, Nancy, Liege & Tilburg. The engines used by these plants are produced in th United States, shipped to harbors in Amsterdam, Antwerp and Le Havre and are sent to the plants for assembly.

WPC must decide how many engines to send from each harbor to each plant. The engines are transported by common carrier, and charges are on a per engine basis.

The tables below give the Demand, Supply & transportation costs for the engines.

Provide your recommendations in a memo to the SPC's transportation director. Provide support documents from STORM (mywordsolution excel).

Demand for Diesel Engines

PLANT NO. ENGINES REQUIRED

Leipzig 400

Nancy 900

Liege 200

Tilburg 500

Supply of Diesel Engines

HARBOR NO. OF ENGINES Available

Amsterdam 500

Antwerp 700

Le Havre 800

Cost To Transport an Engine Harbor to plant

TO PLANT

FROM HARBOR Leipzig Nancy Liege Tilburg

Amsterdam 120 130 41 62

Antwerp 61 40 100 110

Le Harve 102.50 90 122 42