The EOQ and the savings in total inventory costs
Provide your detailed answers below every part of each question.
Avery owns four large dealerships in the metropolitan area. Each of these locations currently keep inventory of required components used for the repairs of the cars. It is possible for the company to keep all the high-priced parts at one of these locations and then deliver to any other location within one hour. The cost of space and the delivery vehicle is negligible but the labor cost of the driver for making all the required deliveries to all three locations will be $180 per day. You have been hired as a supply chain consultant to help Avery in making this decision. Use the following data to calculate the total relevant costs of both the current and the proposed scenario:
Average Price of the High-Priced Components = $150
Annual Demand for the High -Priced Components = 20,000 items per location
Number of Work-Days = 250 per year
Annual Holding Costs = 30% per year
Lead Time for replenishment from the manufacturer = 9 days
Fixed Costs of placing an order with the manufacturer = $150 per order
Target cycle service level = 0.95
a) Calculate the EOQ and the savings in total inventory costs for the current and the proposed scenario.
b) Now assume that the demand at each location is not constant but it is Normal with mean 100 and standard deviation of 15 High-Priced items per day. Calculate the cost of safety inventory for the current and the proposed scenario.
c) What is your recommendation and how much will Avery save if the demand was probabilistic?
a) Calculate the EOQ and the savings in total inventory costs for the current and the proposed scenario.
To calculate the Economic Order Quantity (EOQ), we can use the following formula:
EOQ = â((2DS) / H)
Where:
D = Annual demand
S = Ordering cost per order
H = Holding cost per unit per year
Given data:
Annual demand (D) = 20,000 items per location
Ordering cost (S) = $150 per order
Holding cost (H) = 30% per year
Calculating EOQ for the current scenario:
EOQ_current = â((2 * 20,000 * $150) / 0.3)
EOQ_current = â(6,000,000 / 0.3)
EOQ_current = â20,000,000
EOQ_current â 4,472 items
Calculating EOQ for the proposed scenario:
EOQ_proposed = â((2 * 80,000 * $150) / 0.3)
EOQ_proposed = â(24,000,000 / 0.3)
EOQ_proposed = â80,000,000
EOQ_proposed â 8,944 items
To calculate the savings in total inventory costs for the current and proposed scenarios, we need to consider both carrying costs and ordering costs.
Carrying costs for the current scenario:
Carrying costs_current = (EOQ_current / 2) * H * Average Price
Carrying costs_current = (4,472 / 2) * 0.3 * $150
Carrying costs_current â $15,930
Ordering costs for the current scenario:
Ordering costs_current = (Annual demand / EOQ_current) * S
Ordering costs_current = (20,000 / 4,472) * $150
Ordering costs_current â $668
Total inventory costs for the current scenario:
Total costs_current = Carrying costs_current + Ordering costs_current
Total costs_current â $15,930 + $668
Total costs_current â $16,598
Carrying costs for the proposed scenario:
Carrying costs_proposed = (EOQ_proposed / 2) * H * Average Price
Carrying costs_proposed = (8,944 / 2) * 0.3 * $150
Carrying costs_proposed â $26,760
Ordering costs for the proposed scenario:
Ordering costs_proposed = (Annual demand / EOQ_proposed) * S
Ordering costs_proposed = (20,000 / 8,944) * $150
Ordering costs_proposed â $335
Total inventory costs for the proposed scenario:
Total costs_proposed = Carrying costs_proposed + Ordering costs_proposed
Total costs_proposed â $26,760 + $335
Total costs_proposed â $27,095
Savings in total inventory costs:
Savings = Total costs_current - Total costs_proposed
Savings â $16,598 - $27,095
Savings â -$10,497
Therefore, there would be a cost increase of approximately $10,497 if Avery were to implement the proposed scenario.
b) Now assume that the demand at each location is not constant but it is Normal with mean 100 and standard deviation of 15 High-Priced items per day. Calculate the cost of safety inventory for the current and the proposed scenario.
To calculate the cost of safety inventory, we need to determine the safety stock level. The safety stock level is calculated using the following formula:
Safety Stock Level = Z * â(Lead Time * Variance of daily demand)
Where:
Z = Z-score representing desired service level
Lead Time = Lead time for replenishment from the manufacturer
Variance of daily demand = (Standard deviation of daily demand)^2
Given data:
Z-score (for a service level of 0.95) = 1.645
Lead Time = 9 days
Mean of daily demand = 100 items
Standard deviation of daily demand = 15 items
Calculating safety stock level for the current scenario:
Safety Stock Level_current = 1.645 * â(9 * (15^2))
Safety Stock Level_current â 1.645 * â(9 * 225)
Safety Stock Level_current â 1.645 * â2025
Safety Stock Level_current â 1.645 * 45
Safety Stock Level_current â 73.525
Calculating safety stock level for the proposed scenario:
Safety Stock Level_proposed = 1.645 * â(9 * (15^2))
Safety Stock Level_proposed â 1.645 * â(9 * 225)
Safety Stock Level_proposed â 1.645 * â2025
Safety Stock Level_proposed â 1.645 * 45
Safety Stock Level_proposed â 73.525
To calculate the cost of safety inventory, we need to multiply the safety stock level by the average price of high-priced components.
Cost of safety inventory for both scenarios:
Cost of Safety Inventory = Safety Stock Level * Average Price
Cost of Safety Inventory_current = 73.525 * $150
Cost of Safety Inventory_current â $11,028.75
Cost of Safety Inventory_proposed = 73.525 * $150
Cost of Safety Inventory_proposed â $11,028.75
Therefore, the cost of safety inventory remains the same for both the current and proposed scenarios at approximately $11,028.75.
c) What is your recommendation and how much will Avery save if the demand was probabilistic?
Based on the calculations above, it can be concluded that implementing the proposed scenario would result in a cost increase rather than savings. The total inventory costs for the proposed scenario are higher than those for the current scenario.
If the demand was probabilistic, Avery would still not save any money as the cost of safety inventory remains the same for both scenarios.
Therefore, my recommendation would be for Avery to stick with the current scenario where each location keeps inventory of required components. This would avoid additional labor costs associated with delivering parts between locations and also prevent an increase in total inventory costs.