Given the information in Exhibit 13.15 and a budget of $5,000,000, what is the most that...

Transcribed Image Text:

Given the information in Exhibit 13.15 and a budget of $5,000,000, what is the most that Loyola Machining can pay for each manufactured unit? Assume one year is 250 working days and the order size is 6,500 units. Use the Total Supply Chain Cost Excel template for your analysis. EXHIBIT 13.15 Supply Chain Costs for Loyola Machining Price per Unit (P) Oversight Cost per Unit (0) 50.31 Annual Demand (D) 1 Total Supply Chain Cost Analysis 2 Enter the data only in the yellow cells. 3 The template is designed for up to five suppliers. 4 5 Supplier 6 7 10 11 32 13 14 15 16 17 18 19 20 21 22 23 24 Procurement cost/unit. P Management oversight cost/unit, O Unit transportation cost Ct Order cost/order, C. Holding cost per unit, C. Lead time, L Transport Cost per Unit (C) 8 Copyright © 2017 Cengage Learning Not for commercial use. Annual Demand, D Order Quantity, Q Average number of orders/year (D/Q) Average daily demand (D/250) Total procurement cost Total management oversight cost Total annual transportation cost Annual order cost Annual holding cost Average annual pipeline inventory cost Total supply chain costs Japanese $7.65 50.55 $0.60 5625.00 $1.35 00 400000 40000 $10.00 1600.00 $3,000,000.00 $220,000.00 $240,000.00 56.350.00 Order Cost (C) Mexican $7.60 50.65 $0.35 $400.00 $1.35 45 $3,040,000,00 $260.000.00 $140,000.00 54,000.00 522XXX1.00 $27.000.00 $129.000.00 502.200.00 53682.850.00 $1,568,2000.08 D Chinese $7.00 $1.25 50.75 $850.00 $1.35 120 $2,800,000.00 $500,000,00 $300,000.00 $8,500.00 $27,000.00 5259,200.00 $3,894,700.00 Cost to Store One Unit One Year (C₂) 19.00 E F Oder Lead Time in Days (4) 20 G Given the information in Exhibit 13.15 and a budget of $5,000,000, what is the most that Loyola Machining can pay for each manufactured unit? Assume one year is 250 working days and the order size is 6,500 units. Use the Total Supply Chain Cost Excel template for your analysis. EXHIBIT 13.15 Supply Chain Costs for Loyola Machining Price per Unit (P) Oversight Cost per Unit (0) 50.31 Annual Demand (D) 1 Total Supply Chain Cost Analysis 2 Enter the data only in the yellow cells. 3 The template is designed for up to five suppliers. 4 5 Supplier 6 7 10 11 32 13 14 15 16 17 18 19 20 21 22 23 24 Procurement cost/unit. P Management oversight cost/unit, O Unit transportation cost Ct Order cost/order, C. Holding cost per unit, C. Lead time, L Transport Cost per Unit (C) 8 Copyright © 2017 Cengage Learning Not for commercial use. Annual Demand, D Order Quantity, Q Average number of orders/year (D/Q) Average daily demand (D/250) Total procurement cost Total management oversight cost Total annual transportation cost Annual order cost Annual holding cost Average annual pipeline inventory cost Total supply chain costs Japanese $7.65 50.55 $0.60 5625.00 $1.35 00 400000 40000 $10.00 1600.00 $3,000,000.00 $220,000.00 $240,000.00 56.350.00 Order Cost (C) Mexican $7.60 50.65 $0.35 $400.00 $1.35 45 $3,040,000,00 $260.000.00 $140,000.00 54,000.00 522XXX1.00 $27.000.00 $129.000.00 502.200.00 53682.850.00 $1,568,2000.08 D Chinese $7.00 $1.25 50.75 $850.00 $1.35 120 $2,800,000.00 $500,000,00 $300,000.00 $8,500.00 $27,000.00 5259,200.00 $3,894,700.00 Cost to Store One Unit One Year (C₂) 19.00 E F Oder Lead Time in Days (4) 20 G

Answer rating: 100% (QA)

The most that Loyola Machining can pay for each manufactured unit is 760 This is calculated using th... View the full answer