Smart Inventory Solutions. Phillip Slater
for any demand event, a variable number of items may be required (for example 3 one time, 2 the next time, 5 the next time), then a Gaussian (or normal) model would be more appropriate. Without understanding both the level and variability in demand, you cannot select the most appropriate method of review.
Frequency of Demand
If the item in question has infrequent demand (sometimes referred to as slow moving), then there will most likely be insufficient data to use a Gaussian model. Again, a Poisson model will be most appropriate. Conversely, high levels of demand will lend themselves to a Gaussian model.
A word of warning: be sure to understand the demand pattern over as long a period as possible. As we saw previously, demand data in a short time frame can be misleading.
Probability and Impact of a Stockout
Strictly speaking the probability and impact of a stockout are two characteristics, but here they are treated as one decision variable because they actually give each other context and are often misused.
The probability/impact decision is often used by practitioners as a reason (or excuse) for overstocking their inventory. The argument that is most often used is that the impact of a stockout is so costly that it overrides any consideration of the cost of the items stocked. This is especially so in industries where the cost of operational downtime is high. However, stocking more than might be needed based on physical limits or probability is pointless and a waste of money. (See also the section in Chapter 5: When is Critical Really Critical?) In terms of calculating the ROP, the probability/impact decision affects the service factor component of the calculation. It is, in effect, a risk decision.
Using a Gaussian model, the service factor is a part of the safety stock calculation (see Figure 2-4) and the values can readily be looked up in widely published tables. Figure 2-5 shows a sample calculation of the ROP using a Gaussian model.
Using a Poisson model (Figure 2-6), there is no explicit service factor and the risk element is accounted for in the probability part of the model. Here’s how that works. The Poisson function calculates the probability of a certain level of demand over a period of time. If you set that quantity as your ROP, then the probability can be treated as your service factor. Your risk of a stockout is 100 minus the probability of that level of demand.
So, if you look at Figure 2-6, the probability of 7 or fewer demands is 96.4%. Therefore, the risk of a stockout, if you have a reorder point of 7, that is — the risk that there will be more than 7 demands during the lead time for restocking — is:
100 − 94.9 = 5.1%.
The major issue though with the probability/impact decision is the Service Factor Trap. The service factor is the percent of time that the storeroom can supply the required item when it is needed. So a theoretical service factor of, say, 97% sounds high, but in reality for engineering materials and spares, this may not be acceptable.
First, if measured across the entire inventory, no one will care about the 97% figure if the 3% includes critical parts and your plant is shut for a week while they get air-freighted in!
Second, you can have a high overall service level and still be significantly overstocked in individual items, meaning that you have still spent money on items that are not needed.
This is the Service Factor Trap. It can be misleading in terms of the inventory being able to fulfill its actual requirements and in terms of how efficiently money has been invested in inventory. Sweeping statements relating to service factors are convenient and reassuring, but add no real value to the practice of materials and inventory management.
The impact characteristic also depends upon where are you located. Consider a situation where a machine will not run without a specific part. Without doubt, this part would be considered critical and the impact of a stockout significant. However, if you are in an urban center with lots of suppliers close by you, may be able to convince one to hold the part for you and then get the required part delivered within an acceptable time frame – for instance while you remove the failed part. However, if you are located in a remote area where delivery takes days, then the stockout has more significant implications. Both situations have the same probability of failure and at one level the same impact — that level is the plant stops. However, the real impact is different if the full materials management cycle is taken into account. The one size fits all solutions that get rolled out to every situation do not bring the required results.
Location, culture, operating mode, financial status, reliability, and risk tolerance are all things that need to be taken into consideration when determining the ROP.
Figure 2-4: The Normal or Gaussian Distribution
Notes:
1. This calculation uses a Mean Average Deviation (MAD) rather than a Standard Deviation. MAD is a simplified way of determining the deviation and is calculated by determining the average value by which demand deviates from the mean, in absolute terms.
2. The Customer Service Factor is based on a MAD scale, not the Standard Deviation of a Normal curve.
Figure 2-5: Example ROP Calculation
Figure 2-6: The Poisson Distribution
Determining the Re-Order Quantity (ROQ)
The other key decision for materials and spares inventory management is to calculate the Reorder Quantity (ROQ). The ROQ is usually not so highly discussed as the ROP but it has as much, if not more, impact on the quantity of inventory that is held. This is because the point at which a company actually commits to holding inventory and tying up working capital is when the items are ordered. The classic formula for calculating the ‘economic’ ROQ is as follows:
Where:
Order Cost = the company internal cost for processing requisitions, issuing purchase orders and receiving deliveries.
Demand Rate = the expected demand over a year.
Item Cost = the purchase cost of the item, including delivery costs.
Holding Cost = the financial charge for holding inventory (see Chapter 3: The Financial Impact of Inventory).
Although simple in concept, there are some complications in practice.
1.The order cost is crucial to the calculation.
Of the four variables in the calculation, this is the least simple to determine because there is no set rate. The actual order cost will be different for every company and is dependent upon internal company efficiency, local pay rates, and so on. To calculate the order cost, some companies use an Activity Based Costing approach; some just use an estimate such as $100 per order. Note that it is a mistake to use a simplistic calculation such as the total cost of the purchasing and stores departments divided by the number of orders placed because this assumes 100% capacity utilization. No matter which approach you choose, the key is to understand the impact of an error in this value. From the formula you can see that the ROQ varies directly with the square root of the order cost. So, if your estimate of