Supply chain network evaluation for products A and B that are produced in various regional manufacturing facilities of the same company. You have a team supporting your evaluation of procurement, transportation, warehousing costs, and review of sales data to complete your presentation.

1. Regions 1 and 2 have increased their capacity with equipment upgrades allowing them to run lower-cost higher batch sizes.
2. Regions 3,4 and 5 had new suppliers contracted, offering bulk delivery at more competitive costs.
3. In Regions 2,3 and 4 we have added new customers increasing demand for our product.

3. Some of the information was missing but you can provide assumptions to support your statement, using what was available in the report in Excel, and below:

• In Regions 1 and 2 supplies are normally delivering materials twice per month due to transportation challenges and warehouse lacking staff to receive and in the rest of the regions it is delivered daily due to broader transportation availability, bulk supplies available, and contracts with high-efficiency 3PL allowing flexibility with materials volumes.
• Regions 4 and 5 are located in transportation hubs where we have lots of options for transportation and back-haul and saving on inbound as well as outbound.
• 3PLs are used to manage materials movement and storage for all regions other than Regions 1 and 2 where warehouses are owned by the plant and are part of the main assets, with costs provided in the report.
• Plants in Regions 3, 4, and 5 can accommodate bulk materials delivery at very competitive costs due to proximity to rail as well bulk materials supply.
• Customer mix varies within each region, breakdown is provided by customer sales volume as A, B, C.
• The product mix between A and B is provided by region.
• Product high-level Bill Of Materials is provided and is standard across all plants.
• Manufacturing costs are provided together with current batch sizes.

After this review, you have to present it to the board in order to influence the decision and to proceed with an overall supply chain network optimization project that should bring efficiency and overall lower costs to the company.

In your presentation you need to present informed decisions on the next few points and questions :

1. Evaluate required investments in capacity increase. Which region requires an increase in capacity and why.
2. Total costs (as available in the report), by region-how, do you need to change product mix (between A and B) in order to optimize costs.
3. Warehousing capabilities and costs. What changes are needed based on transportation and warehousing costs and efficiency in order to provide the best total costs of logistics?
4. 
5. 
6.    

Transcribed Image Text:

N19 Jx A 1 1. Procurement 2 Procurement costs-inbound transportation. Incoterms EXW 3 Inbound transportation cost, per 1000 kg or per 1000 pc 4 Raw material-dry mixes, per 1000 kg 5 Raw material -liquid bulk, per 1000 kg 6 Raw material-liquid in 20 litre containers, per 1000 kg 7 Packaging, per 1000 pc 8 9 Procurement costs-purchase price. Incoterms EXW supplier 10 Purchase Price, per 1000 kg or per 1000 pc 11 Raw material-dry mixes, per 1000 kg 12 Raw material -liquid bulk, per 1000 kg 13 Raw material-liquid in 20 I containers, per 1000 kg 14 Packaging, per 1000 pieces 15 16 2. Manufacturing 17 2.1 Manufacturing cost Per EACH Product A 18 2.1.1. Standard batch size for manufacturing volume (units): 19 20 2.2 Manufacturing cost Per EACH Product B 21 2.2.1 Standard batch size for manufacturing volume (units): 22 Region 1 $ $ Ś B $ $ Region 1 $ $ 150.00 $ N/A 150.00 $ 150.00 $ Region 1 $ Region 2 Region 3 150.00 $ N/A 150.00 150.00 $ Region 2 0.70 $ 250,000 0.76 $ 500,000 D Region 2 Region 3 750.00 $ 800.00 $ N/A N/A 840.00 $ 812.00 650.00 $ 700.00 $ $ 0.27 $ 200,000 N/A Region 3 0.25 $ 500,000 Region 4 Region 5 50.00 $ 45.00 $ 60.00 $26 $22 $28 50.00 $ E 0.95 $ 10,000 N/A 45.00 1.03 $ 250,000 $ Region 4 Region 5 420.00 $ 420.00 $ 400.00 600.00 $ 580.00 $ N/A N/A 390.00 $ 420.00 $ 610.00 N/A 420.00 F N/A Region 4 Region 5 1.05 $ 5,000 1.13 $ 100,000 60.00 0.98 10,000 1.06 150,000 G H I Product A liquid dry mix packaging J Product B liquid dry mix packaging K in order to produce 1000 pc required 700 kg 300 kg 1000 EACH L 470 kg 530 kg 1000 EACH M U N19 Jx A 1 1. Procurement 2 Procurement costs-inbound transportation. Incoterms EXW 3 Inbound transportation cost, per 1000 kg or per 1000 pc 4 Raw material-dry mixes, per 1000 kg 5 Raw material -liquid bulk, per 1000 kg 6 Raw material-liquid in 20 litre containers, per 1000 kg 7 Packaging, per 1000 pc 8 9 Procurement costs-purchase price. Incoterms EXW supplier 10 Purchase Price, per 1000 kg or per 1000 pc 11 Raw material-dry mixes, per 1000 kg 12 Raw material -liquid bulk, per 1000 kg 13 Raw material-liquid in 20 I containers, per 1000 kg 14 Packaging, per 1000 pieces 15 16 2. Manufacturing 17 2.1 Manufacturing cost Per EACH Product A 18 2.1.1. Standard batch size for manufacturing volume (units): 19 20 2.2 Manufacturing cost Per EACH Product B 21 2.2.1 Standard batch size for manufacturing volume (units): 22 Region 1 $ $ Ś B $ $ Region 1 $ $ 150.00 $ N/A 150.00 $ 150.00 $ Region 1 $ Region 2 Region 3 150.00 $ N/A 150.00 150.00 $ Region 2 0.70 $ 250,000 0.76 $ 500,000 D Region 2 Region 3 750.00 $ 800.00 $ N/A N/A 840.00 $ 812.00 650.00 $ 700.00 $ $ 0.27 $ 200,000 N/A Region 3 0.25 $ 500,000 Region 4 Region 5 50.00 $ 45.00 $ 60.00 $26 $22 $28 50.00 $ E 0.95 $ 10,000 N/A 45.00 1.03 $ 250,000 $ Region 4 Region 5 420.00 $ 420.00 $ 400.00 600.00 $ 580.00 $ N/A N/A 390.00 $ 420.00 $ 610.00 N/A 420.00 F N/A Region 4 Region 5 1.05 $ 5,000 1.13 $ 100,000 60.00 0.98 10,000 1.06 150,000 G H I Product A liquid dry mix packaging J Product B liquid dry mix packaging K in order to produce 1000 pc required 700 kg 300 kg 1000 EACH L 470 kg 530 kg 1000 EACH M U

Answer rating: 100% (QA)

To present an informed decision on the key points and questions for the supply chain network optimization project to the board consider the following ... View the full answer