1. The John-Duo Corporation (JDC) produces and markets an automotive theft-deterrent product, which stocks it various warehouses throughout the country. Recently, its market research group compiled a forecast indicating that a significant increase in demand will occur in the near future. The company decides to satisfy this demand by constructing new plants. JDC already has two plants in Baltimore and Milwaukee and has no desire to relocate or close this facilities.

After a thorough search, the company identified three candidate sites and corresponding capacities.

1. Determine the most economical way of redesigning the supply chain network.

1. 2. If there is a capacity expansion possibility for only one of the existing facilities or candidate facilities have an additional 250,000 unit capacity for an additional fixed cost $250K, which facility should obtain this capacity expansion? How does this expansion change the network design from part a? PLEASE SHOW EXCEL SHEET WITH FORMULAS!
2. 

Table Window Help 100% Thu 11:21 AM Q E Word File Edit View Insert Format Tools AutoSave OF AE SU 58 - Home Insert Draw Design Layout References Prestige Plastics Corporation Grammarly Acrobat Tell me Mailings Review View Share Comments | Plants Baltimore Milwaukee OKC Wichita Dayton Warehouses Demand Points) Seattle Derwer 30 2.50 2.50 JOU 4.00 4.00 20 5.00 St. Louis 330 2.50 2.00 3.00 3.00 Atlanta 4.00 3.00 250 250 3.50 INYC 5.00 4.00 200 3.03 2.50 Fixed Cost Capacities Detroit K 5.50 500 600.000.00 4.50 950 500 000.00 KUO 650.000.00 2.50 400 450000.00 4.00 450 400.000.00 175,000 Bernd d 325,000 200,00 100,000 200.000 275.000 Alana 4.00 3.00 Detroit 5.50 Warehouses (Demand Points |Baatile Denver 4.00 3.50 2.50 2.50 3.50 3.50 4.00 4.00 4.50 5.02 Plants Baltimore Milwaukee OKC Wichita Dayton St. Louis 3.50 250 250 3.00 3.00 NYC 5.00 4.00 9.00 9.00 2.50 Fibed Cost Capacities finess 500 600,000.00 350 500 000 00 con 550,000.00 400 450,000.00 450 400,000.00 2.50 3.50 3.50 2.50 4.00 Demand 325,000 200,000 150.00 200,000 275.00 175,000 Baltimore Extra-Baltimore Milwaukee Extra- MW OKC Extra-OKC Wichita Extra- Wichita Dayton Extre-Dayton 400 2.50 2.50 3.50 3.50 4.00 4.00 3.50 3.50 2.53 2.53 3.50 3.50 4.00 4.00 5.00 5.00 350 250 250 250 250 9.00 3.00 300 3.00 4.00 401 3.00 3.00 2.50 2.50 2.50 2.50 3.50 3.50 5.00 500 4.00 4.00 300 9.00 9.00 3.00 2.50 250 5.50 5.50 4.50 4.50 3.50 3.50 2.50 2.50 4.00 4.00 500 250 950 250 600 250 400 250 450 250 800,000.00 250,000.00 500 000 250,000.00 550,000.00 250,000.00 450,000.00 250,000.00 400,000 250,000.00 2.50 Page 2 of 2 Englisn (United States Focus + 125% Table Window Help 100% Thu 11:21 AM Q E Word File Edit View Insert Format Tools AutoSave OF AE SU 58 - Home Insert Draw Design Layout References Prestige Plastics Corporation Grammarly Acrobat Tell me Mailings Review View Share Comments | Plants Baltimore Milwaukee OKC Wichita Dayton Warehouses Demand Points) Seattle Derwer 30 2.50 2.50 JOU 4.00 4.00 20 5.00 St. Louis 330 2.50 2.00 3.00 3.00 Atlanta 4.00 3.00 250 250 3.50 INYC 5.00 4.00 200 3.03 2.50 Fixed Cost Capacities Detroit K 5.50 500 600.000.00 4.50 950 500 000.00 KUO 650.000.00 2.50 400 450000.00 4.00 450 400.000.00 175,000 Bernd d 325,000 200,00 100,000 200.000 275.000 Alana 4.00 3.00 Detroit 5.50 Warehouses (Demand Points |Baatile Denver 4.00 3.50 2.50 2.50 3.50 3.50 4.00 4.00 4.50 5.02 Plants Baltimore Milwaukee OKC Wichita Dayton St. Louis 3.50 250 250 3.00 3.00 NYC 5.00 4.00 9.00 9.00 2.50 Fibed Cost Capacities finess 500 600,000.00 350 500 000 00 con 550,000.00 400 450,000.00 450 400,000.00 2.50 3.50 3.50 2.50 4.00 Demand 325,000 200,000 150.00 200,000 275.00 175,000 Baltimore Extra-Baltimore Milwaukee Extra- MW OKC Extra-OKC Wichita Extra- Wichita Dayton Extre-Dayton 400 2.50 2.50 3.50 3.50 4.00 4.00 3.50 3.50 2.53 2.53 3.50 3.50 4.00 4.00 5.00 5.00 350 250 250 250 250 9.00 3.00 300 3.00 4.00 401 3.00 3.00 2.50 2.50 2.50 2.50 3.50 3.50 5.00 500 4.00 4.00 300 9.00 9.00 3.00 2.50 250 5.50 5.50 4.50 4.50 3.50 3.50 2.50 2.50 4.00 4.00 500 250 950 250 600 250 400 250 450 250 800,000.00 250,000.00 500 000 250,000.00 550,000.00 250,000.00 450,000.00 250,000.00 400,000 250,000.00 2.50 Page 2 of 2 Englisn (United States Focus + 125%