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.
2. If there is a capacity expansion possibility foronly oneof theexisting facilities or candidate facilitieshave 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!

Word File Edit View Insert Format Tools Table Window Help 100% 27 Thu 11:21 AM Q AutoSave OFF Prestige Plastics Corporation Home Insert Draw Design Layout References Mailings Review View Grammarly Acrobat Tell me LE Share Comments Warehouses (Demand Points) Fixed Cost Capacities Plants Seattle Denver St. Louis Atlanta NYC Detroit fi (in $1000) Ki Existing Baltimore 4.00 3.50 3.50 4.00 5.00 5.50 500 600,000.00 Milwaukee 2.50 2.50 2.50 1.00 4.0 4.50 350 00,000.00 OKC 3.50 3 50 2.50 2.50 3.0 3.50 600 550,000.00 Candidate Wichita 4.00 4.00 3.00 2.50 3.00 2.50 400 450,000.00 Dayton 4.50 5.00 3.00 3 50 2.50 4 OC 450 100,000.00 Demand d) 325,000 200,000 150,000 200,000 275,000 175,000 Warehouses (Demand Points Fixed Cost Capacities Plants Seattle Denver St. Louis Atlanta NYC Detroit fi (in $1000) Baltimore 4.00 3.5 3.50 4.0 5.00 5.50 500 600,000.00 Milwaukee 2.50 2.50 2.50 3.00 4.00 4.50 350 500,000.00 OKC 3.50 3.50 2.50 2.50 3.00 3.50 600 550,000.00 Wichita 4.00 4.00 3.00 2.50 3.00 2.50 400 450,000.00 Dayton 4.50 5.00 3.00 3.50 2.50 4.00 450 400,000.00 Demand dj 325,000 200,000 150,000 200,000 275,000 175,000 Baltimore 4.00 3.50 3.50 4.00 5.00 5.50 500 600,000.00 Extra-Baltimore 4.00 3.50 3.50 4.00 5.00 5.50 250 250,000.00 Milwaukee 2.50 2.50 2.50 3.00 4.00 4.50 350 500,000.00 Extra-MW 2.50 2.50 2 50 3.00 4.00 4.50 250 250,000.00 OKC 3.50 3.50 2.50 2.50 3.00 3.50 600 550,000.00 Extra-OKC 3.50 3.50 2.50 2.50 3.00 3.50 250 250,000.00 Wichita 4.00 4.00 3.00 2.50 3.00 2.50 400 450,000.00 Extra-Wichita 4.00 4.00 3.00 2.50 3.00 2.50 250 250,000.00 Dayton 4.50 5.00 3.00 3.50 2.50 4.00 450 400,000.00 Extra-Dayton 4.50 5.00 3.00 3.50 2.50 4.00 250 250,000.00 Page 2 of 2 0 words English (United States) Focus E + 125%