Network Optimization SCM/Ops Question

Apr 27th, 2015
Price: $10 USD

Question description

PROTRAC is a manufacturer of diesel engines that has four assembly plants in Europe. They are located in Leipzig (Germany), Nancy (France), Liege (Belgium) and Tilburg (Netherlands). The engines parts come in kits from the United States for final assembly in Europe. The engines are shipped from the US to three ports: in Amsterdam (Netherlands), Antwerp (Belgium) and Le Havre (France). Upon arrival at the destination port, engines are shipped to the production plants.

Screen Shot 2015-04-27 at 7.23.38 PM.png

Demand at each Plant

Plant:      Leipzig     Nancy     Liege    Tilburg      Total

# engines 400           900         200        500         2000

PROTRAC negotiated contracts for a set maximum volume at each port:

Max Supply of Engines 

Port:      Amsterdam     Antwerp      Le Havre     Total

# engines     500              700              800          2000

The engines are transported by common carrier and charges are on a per-engine basis.

Cost to Transport an Engine from Port to Production Plant

  1. 1)  PROTRAC must decide how many engines to send from each harbor to each plant. Using solver in Excel determine the solution that would minimize cost for PROTRAC.

  2. 2)  Realizing that they may need more flexibility in their network, PROTRAC negotiated with a fourth port located in Rotterdam. The shipping costs from Rotterdam are included below. They can ship up to 300 engines through Rotterdam, on top of the capacity already available at of other ports. Would this solution save money for PROTRAC? If so, how much? If not, how much more expensive is it?

    Screen Shot 2015-04-27 at 7.23.02 PM.png

Conduct your computations in Excel using Solver. Please answer and question 1 and 2 into two separate worksheets. Submit your Excel file. 

Tutor Answer

(Top Tutor) Kelvin B
School: Duke University

Studypool has helped 1,244,100 students

Review from student
" Outstanding Job!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1825 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors