Intermittent Demand Forecasting. John E. Boylan
So, in this case, the cycle service level and the unit fill rate are not measurable. On the other hand, the ready rate,
These general considerations now need to be addressed in the light of inventory control for intermittent demand items. Such items are generally far more prevalent at wholesalers, especially where a wide range of stocks is held, including SKUs with very slow demand rates. In retailing, intermittent items are becoming more common, as discussed in Chapter 1, but are still less prevalent than in wholesaling. Demand on retailers, from individual customers, is generally for much smaller quantities than demand on wholesalers. This means that demand on retailers for slow‐moving items tends to be intermittent rather than lumpy (see Chapter 1). For such items, the fill rate and the ready rate may be identical (Axsäter 2015) or the latter may act as an approximation to the former.
In summary, both the
3.4.4 Choice of Service Level Measure
The choice between the
1 Place an emergency order on the supplier for all the units of the item that have not been satisfied. The supplier is requested to satisfy this order in a shorter lead time than normal, to mitigate the poor service provided to the client(s).
2 Advise the client(s) to wait until the next replenishment order is due to arrive, after the usual lead time has elapsed. When the order arrives, the backorders will be released, subject to sufficient stock having arrived.
On the other hand, if the customer is not prepared to wait for the SKU to come back into stock (as is common in retailing), then there are two possible outcomes:
1 Sales of a substitute product.
2 A complete lost sale, with no substitute items sold.
In the backorder case, for the first course of action, there will usually be an additional price to be paid to the supplier for expediting the goods in a shorter time than normal. If this additional price is fixed, and not proportional to the number of units short, then the
For the second course of action in the backorder case, there is no expediting cost for the organisation, but there is a potential cost in terms of loss of goodwill. This also applies if the customer is not prepared to wait, although the loss may be mitigated if the customer is prepared to buy a substitute product. It was mentioned earlier that loss of goodwill is very difficult to quantify. However, a fixed cost does not seem appropriate. It is surely worse to be short by four units, with two client orders for two units not being satisfied, than to be short by one unit for one client. Instead, a cost that is proportional to the fraction of unsatisfied demand seems more suitable, as reflected by the
If the customer is not prepared to wait and does not purchase a substitute product then, in addition to the indirect cost of loss of goodwill, there is also a direct cost of loss of profit to take into consideration. Again, a cost that is proportional to the fraction of unfilled demand seems appropriate, making the
3.4.5 Summary
In this section, we have seen that, although there may be real costs associated with inventory holdings and shortages, they can be very difficult to measure reliably. For this reason, we have advocated a service level measure approach at the SKU level.
We have found that both the cycle service level (
There is a link between the cost‐driven approach and the service‐driven approach. If the main costs are in expediting orders, then the cycle service level is a better reflection of the costs. On the other hand, if the main costs are in loss of immediate profit or loss of goodwill, then the fill rate is a more appropriate measure.
3.5 Calculating Cycle Service Levels
If we decide to proceed with a cycle service level (CSL) measure at SKU level, then we need to be able to assess the CSL implications of alternative OUT levels. The calculation of CSLs depends on the probabilities of demand over the protection interval and so, before going further, we start this section with a discussion on demand probabilities.
Table 3.2 Distribution of demand over one week.
Demand | Probability |
---|---|
0 | 0.5 |
1 | 0.3 |
2 | 0.2 |
3 or more | 0.0 |
3.5.1 Distribution of Demand Over One Time Period
A ‘demand distribution’ assigns a probability to each of the possible values of demand over a specified period of time. An example of a distribution of demand for an SKU over one week is shown in Table 3.2. The distribution assigns a probability of 0.5 to 0, indicating that the SKU is intermittent and we expect 50% of future weeks to contain no demand, and similarly assigns probabilities of 0.3 and 0.2 to demands of one and two units, respectively. According to this distribution, there will never be demand for three or more units over a period of one week, as the probability