Answer:
a. $231,000
b. 2,450 units
Step-by-step explanation:
a. On average, how many dollars of pipeline inventory will be in transit to each distribution center?
This is the inventory level that has to be in transit every 2 weeks in order to meet average demand. This can be calculated as follows:
Pipeline inventory = Number of distribution centers * Price per unit * Average weekly demand * Average delivery lead time = 5 * $330 * 70 * 2 = $231,000.
Therefore, the dollars of pipeline inventory that will be in transit to each distribution center is $231,000.
b. How much total inventory (cycle, safety, and pipeline) does Prince hold for all five distribution centers?
Inventory in hand = Average shipment size * Number of distribution centers = 350 * 5 = 1,750
Safety inventory = Number of distribution centers * Average weekly demand * Average delivery lead time = 5 * 70 * 2 = 700
Note: Safety inventory is the inventory held in the store for the purpose of meeting rise in demand or for overcoming delay in supply.
Inventory cycle = Inventory in hand - safety inventory = 1,750 - 700 = 1,050
Pipeline inventory = Number of distribution centers * Average weekly demand * Average delivery lead time = 5 * 70 * 2 = 700
Total inventory held = Inventory cycle + Safety inventory + Pipeline inventory = 1,050 + 700 + 700 = 2,450 units.
Therefore, the total inventory (cycle, safety, and pipeline) Prince holds for all five distribution centers is 2,450 units.