Up Time Magazine - December 2008/January 2009 - (Page 45) How Much Do Squirrel Stores Cost? The following example demonstrates the inventory effect of squirrel stores. For this example let’s consider a part that is used weekly and therefore has an average demand of 1 unit per week. This type of part is a major target for squirrel stores as holding them reduces the number of trips to the storeroom. Let’s compare two situations: 1. No Squirrel Store: The item is removed from the storeroom as needed – 1 per week. 2. Squirrel Store: The item is removed two at a time with movement every two weeks. The demand data for these two situations is shown in Figure 1. Usage Data from Official Store Week 1 2 3 4 5 6 7 No Squirrel Store 1 1 1 1 1 1 1 and so on Squirrel Store 2 0 2 0 2 0 2 Figure 3: Demand Profile with Squirrel Store (Data projected over one year) 30 25 20 15 10 5 0 0 1 2 It is a surprise to most people when they see that when you hold inventory in a squirrel store the Reorder Point in your official store can be MORE THAN DOUBLE the Reorder Point without the squirrel store. This result then means that the average level of inventory held in your official store, if you allow a squirrel store, is 264% greater than the average holding without the squirrel store (see Figure 5). This is not due to the items held in the squirrel store but due to the Induced Demand Volatility (IDV) that the squirrel store creates in your official store. The IDV changes the calculation of safety stock in the above formula and this is why you hold too much inventory. Scenario 2: Over ride the calculation and manually set your reorder point to 4 for both scenarios. Figure 5: Comparison of Average Inventory Now, one way to calculate the inventory needs in this situation is by using a Gaussian distribution. This approach is familiar to most people as it can be represented by the formula: Reorder Point = (Usage rate x lead time) + safety stock Alternatively: RP = (D x LT) + csf x MAD x Sqrt(LT) 10 Figure 1 The demand profile for these two different demand patterns is shown in Figures 2 & 3. It is clear from these two figures that, while in each case the average is one demand per week, the demand profile is not just different, it is completely opposite. Figure 2: Demand Profile without Squirrel Store (Data projected over one year) Where, RP = reorder point 8 D = average demand per week (for 6 our example this is 1 per week) LT = Lead time in weeks (let’s 4 assume 4 weeks) 2 csf = customer service factor (or availability factor) – here we 0 will use a csf of 2.56, this assumes a 98% availability. MAD = Mean Average Deviation – a measure of demand variation. In this example, with no squirrel store this is 0 (there is no variation) and with the squirrel store the MAD is 1. Sqrt = square root % 264 ase e Incr 9.1 2.5 No Squirrel Store With Squirrel Store Results Scenario 1: Using the above formula and data, Figure 4 shows the results for this scenario. Measure Reorder Point Avg Inventory No Squirrel Store 4 2.5 Squirrel Store 10 9.1 60 50 40 30 20 10 0 0 1 2 Let’s now assume that you understand the impact of the IDV on your calculation and decide to manually set the reorder level for both situations to 4, knowing that you only ever use 4 items during the lead time for supply. In this case the average inventory holding reduces to 3.5 items (including the items held in the squirrel store). This is still 40% higher than the situation without the squirrel store! Do you still think that squirrel stores don’t cost much? Figure 4 www.uptimemagazine.com 45 http://www.uptimemagazine.com
For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.