Selecting a Transportation Network ( Direct / milk run) Question : •Eight stores, four supply sources •Truck capacity = 40,000 units •Cost $1,000 per load, $100 per delivery •Holding cost = $0.20/year numerical solution Annual sales = 960,000/store Direct shipping Batch size shipped from each supplier to each store = 40,000 units Number of shipments/yr from each supplier to each store = 960,000/40,000 = 24 Annual trucking cost for direct network = 24 x 1,100 x 4 x 8 = $844,800 Average inventory at each store for each product = 40,000/2 = 20,000 units Annual inventory cost for direct network = 20,000 x 0.2 x 4 x 8 = $128,000 Total annual cost of direct network = $844,800 + $128,000 = $972,800 Annual sales = 960,000/store Milk runs Batch size shipped from each supplier to each store = 40,000/2 = 20,000 units Number of shipments/yr from each supplier to each store = 960,000/20,000 = 48 Transportation cost per shipment per store (two stores/truck) = 1,000/2 + 100 = $600 Annual trucking cost for direct network = 48 x 600 x 4 x 8 = $921,600 Average inventory at each store for each product = 20,000/2 = 10,000 units Annual inventory cost for direct network = 10,000 x 0.2 x 4 x 8 = $64,000 Total annual cost of direct network = $921,600 + $64,000 = $985,600 Annual sales = 120,000/store Direct shipping Batch size shipped from each supplier to each store = 40,000 units Number of shipments/yr from each supplier to each store = 120,000/40,000 = 3 Annual trucking cost for direct network = 3 x 1,100 x 4 x 8 = $105,600 Average inventory at each store for each product = 40,000/2 = 20,000 units Annual inventory cost for direct network = 20,000 x 0.2 x 4 x 8 = $128,000 Total annual cost of direct network = $105,600 + $128,000 = $233,600 Annual sales = 120,000/store Milk runs Batch size shipped from each supplier to each store = 40,000/4 = 10,000 units Number of shipments/yr from each supplier to each store = 120,000/10,000 = 12 Transportation cost per shipment per store (two stores/truck) = 1,000/4 + 100 = $350 Annual trucking cost for direct network = 12 x 350 x 4 x 8 = $134,400 Average inventory at each store for each product = 10,000/2 = 5,000 units Annual inventory cost for direct network = 5,000 x 0.2 x 4 x 8 = $32,000 Total annual cost of direct network = $134,400 + $32,000 = $166,400 in the last lecture, we did a numerical analysis for a comparison between the direct shipment strategy with the milk run. The question is whether you can formulate a mathematical model for this comparison. (step by step answer and explanation)
Question:
Selecting a Transportation Network ( Direct / milk run) Question : •Eight stores, four supply sources •Truck capacity = 40,000 units •Cost $1,000 per load, $100 per delivery •Holding cost = $0.20/year numerical solution Annual sales = 960,000/store Direct shipping Batch size shipped from each supplier to each store = 40,000 units Number of shipments/yr from each supplier to each store = 960,000/40,000 = 24 Annual trucking cost for direct network = 24 x 1,100 x 4 x 8 = $844,800 Average inventory at each store for each product = 40,000/2 = 20,000 units Annual inventory cost for direct network = 20,000 x 0.2 x 4 x 8 = $128,000 Total annual cost of direct network = $844,800 + $128,000 = $972,800 Annual sales = 960,000/store Milk runs Batch size shipped from each supplier to each store = 40,000/2 = 20,000 units Number of shipments/yr from each supplier to each store = 960,000/20,000 = 48 Transportation cost per shipment per store (two stores/truck) = 1,000/2 + 100 = $600 Annual trucking cost for direct network = 48 x 600 x 4 x 8 = $921,600 Average inventory at each store for each product = 20,000/2 = 10,000 units Annual inventory cost for direct network = 10,000 x 0.2 x 4 x 8 = $64,000 Total annual cost of direct network = $921,600 + $64,000 = $985,600 Annual sales = 120,000/store Direct shipping Batch size shipped from each supplier to each store = 40,000 units Number of shipments/yr from each supplier to each store = 120,000/40,000 = 3 Annual trucking cost for direct network = 3 x 1,100 x 4 x 8 = $105,600 Average inventory at each store for each product = 40,000/2 = 20,000 units Annual inventory cost for direct network = 20,000 x 0.2 x 4 x 8 = $128,000 Total annual cost of direct network = $105,600 + $128,000 = $233,600 Annual sales = 120,000/store Milk runs Batch size shipped from each supplier to each store = 40,000/4 = 10,000 units Number of shipments/yr from each supplier to each store = 120,000/10,000 = 12 Transportation cost per shipment per store (two stores/truck) = 1,000/4 + 100 = $350 Annual trucking cost for direct network = 12 x 350 x 4 x 8 = $134,400 Average inventory at each store for each product = 10,000/2 = 5,000 units Annual inventory cost for direct network = 5,000 x 0.2 x 4 x 8 = $32,000 Total annual cost of direct network = $134,400 + $32,000 = $166,400 in the last lecture, we did a numerical analysis for a comparison between the direct shipment strategy with the milk run. The question is whether you can formulate a mathematical model for this comparison. (step by step answer and explanation)
Asked by: Test User 100071
Created at: 2025-04-29 10:20:12
Final Answer:
📢 Instructions:
- Ask anything relatd to above question only.
- For new Question goto :
VIPSolutions