VIPSolutions logo ✨ VIPSolutions

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)

This is AI generated Response.
Asked by: Test User 100071
Created at: 2025-04-29 10:20:12

Final Answer:

Rendered Raw Text
Did you like this answer?
Absolutely! Let's **formulate a general mathematical model** to compare the **Direct Shipping** and **Milk Run** strategies as applied in the numerical example above. We’ll define variables, write down the cost components, and show how to express the total cost for each strategy. --- ## 1. **Define Parameters and Variables** Let: - \( S \): Number of stores - \( P \): Number of supply sources (suppliers) - \( D \): Annual demand per store (units/year) - \( Q \): Batch size per shipment to each store (units) - \( C_t \): Trucking cost per load (per truck, per trip) - \( C_d \): Delivery cost per store (per store, per trip) - \( H \): Holding cost per unit per year - \( K \): Truck capacity (units) - \( n \): Number of stores visited per truck in a milk run Derived: - \( N_{ship} \): Number of shipments per year from each supplier to each store \( = D/Q \) - \( N_{inv} \): Average inventory per store per product \( = Q/2 \) --- ## 2. **Direct Shipment Model** Each truck delivers directly from a supplier to a store. Each shipment fills up to truck capacity. ### a. **Number of Shipments per Year** \[ N_{ship,\,direct} = \frac{D}{Q} \] Where \( Q = K \) (full truckload to each store). ### b. **Annual Trucking Cost** Each shipment incurs one truck cost and one delivery cost per store: \[ \text{Annual Trucking Cost}_{direct} = N_{ship,\,direct} \times (C_t + C_d) \times P \times S \] ### c. **Annual Inventory Cost** \[ \text{Inventory per store per product} = \frac{Q}{2} \] \[ \text{Annual Inventory Cost}_{direct} = \frac{Q}{2} \times H \times P \times S \] ### d. **Total Annual Cost** \[ \text{Total Cost}_{direct} = \text{Annual Trucking Cost}_{direct} + \text{Annual Inventory Cost}_{direct} \] --- ## 3. **Milk Run Model** Each truck visits multiple stores on one trip. Each store receives a smaller shipment. ### a. **Number of Shipments per Year** Batch size per store: \[ Q_{milk} = \frac{K}{n} \] Number of shipments per year from each supplier to each store: \[ N_{ship,\,milk} = \frac{D}{Q_{milk}} = \frac{D \cdot n}{K} \] ### b. **Transportation Cost per Store per Shipment** Each truck serves \( n \) stores, so per store: \[ \text{Transp. Cost per store per shipment} = \frac{C_t}{n} + C_d \] ### c. **Annual Trucking Cost** \[ \text{Annual Trucking Cost}_{milk} = N_{ship,\,milk} \times \left( \frac{C_t}{n} + C_d \right) \times P \times S \] ### d. **Annual Inventory Cost** \[ \text{Average inventory per store per product} = \frac{Q_{milk}}{2} \] \[ \text{Annual Inventory Cost}_{milk} = \frac{Q_{milk}}{2} \times H \times P \times S \] ### e. **Total Annual Cost** \[ \text{Total Cost}_{milk} = \text{Annual Trucking Cost}_{milk} + \text{Annual Inventory Cost}_{milk} \] --- ## 4. **Summary Table** | Strategy | Shipments/yr | Batch size per store | Transp. Cost/shipment | Inventory/store | Annual Trucking Cost | Annual Inventory Cost | Total Cost | |---------------|--------------|---------------------|----------------------|-----------------|---------------------|----------------------|------------| | Direct | \( D/K \) | \( K \) | \( C_t + C_d \) | \( K/2 \) | \( (D/K) \cdot (C_t+C_d) \cdot P \cdot S \) | \( (K/2) \cdot H \cdot P \cdot S \) | sum | | Milk run | \( D/(K/n) \) | \( K/n \) | \( C_t/n + C_d \) | \( (K/n)/2 \) | \( (Dn/K) \cdot (C_t/n + C_d) \cdot P \cdot S \) | \( (K/2n) \cdot H \cdot P \cdot S \) | sum | --- ## 5. **General Mathematical Model** **Direct:** \[ \boxed{ \text{Total Cost}_{direct} = \frac{D}{K} \cdot (C_t + C_d) \cdot P \cdot S + \frac{K}{2} \cdot H \cdot P \cdot S } \] **Milk run:** \[ \boxed{ \text{Total Cost}_{milk} = \frac{D \cdot n}{K} \cdot \left( \frac{C_t}{n} + C_d \right) \cdot P \cdot S + \frac{K}{2n} \cdot H \cdot P \cdot S } \] Where: - \( K \): truck capacity - \( n \): number of stores per milk run (divides \( K \) evenly) --- ## 6. **How to Use the Model** - Plug in the values for \( D, K, n, C_t, C_d, H, P, S \) for your scenario. - Calculate both total costs. - The strategy with the **lower total cost** is preferred. --- ### **Step-by-Step Explanation Summary** 1. **Define variables and parameters.** 2. **For each strategy, write equations for:** - Number of shipments per year - Trucking cost per shipment and per year - Inventory holding cost per year - Total cost per year 3. **Summarize in equations** for comparison. 4. **Plug in numbers** for specific cases as in your example. --- **This model helps you analyze and choose between Direct and Milk Run based on cost components and operational variables.**

📢 Instructions:

  • Ask anything relatd to above question only.
  • For new Question goto :

Study Help, Fast Answers

VIPSolutions focuses on clear, step‑by‑step explanations so you can learn quickly. Whether you need an AI‑generated walkthrough or a short hint to get unstuck, each solution is organized for fast reading and easy review later.

Search similar questions, compare approaches, and bookmark the best answers for revision. Our goal is simple: quick, reliable study help that feels natural—not noisy.