





Lots of Zeroes: Digging Deeper into Managing Intermittent DemandIn the first installment on this topic of this blog, we talked a lot about the challenges of intermittent demand. Now, we need to turn to the nuts and bolts of creating a demand estimate in the face of intermittent demand. Looking at the why The demand estimate has three primary purposes, including the delivery of:
For the purposes of this discussion, we will focus on the second purpose, acquisition. We will continue to use the intermittent demand example from the first blog. The probability of getting a nonzero demand value on any given day is 20%, the probability of zero demand is 80% (=100%20%). If there is demand, the possible values are 1, 2, or 3 (with equal probability). The average demand on nonzero days is 2 (=(1+2+3)/3=6/3). The average demand per day is 0.4 (=0x(0.8) + 2x(0.2)= 0 + 0.4). Getting down to math Table 01 has an alternative, and very helpful, way to capture the probability of demand.
Row 4 (demand of 001) tells us the probability demand for any given day of one is 6.6667% (Column 2), the probability that demand of one or less is 86.7% (Column 3). The probability demand is greater than one on a given day is 13.3% (Column 4). Our product is cherry butter pecan (CBP) 1/2 gallons of ice cream, where the lead time to replenish inventory is overnight. (Of course, it is as applicable to the electronic component or product of your choice.) An inventory replenishment request is made at the end of the day and the inventory arrives at the start of next day. If I reorder 10 units at the end of day one, then the 10 units will arrive at start of day two, and available to sell. The key questions are:
For simplicity we will assume the cost to reorder is zero, the cost to hold inventory is $1 per day, the revenue for each sale is $3, the probability the new order arrives on time is 100%, the shelf life of a unit of CHP is 100 days, and the limit on storage space is 100 units. If a customer comes to the store to purchase CBP and there is no CPB (stockout), the order (sale) is lost forever. Since reorder cost is 0 and the reorder lead time is overnight, the critical question is how much inventory to hold at the start of each day, which is a question of managing the risk of a lost sale versus holding cost. Making big decisions How much to hold in inventory at the start of the day? We know the minimum demand each day is 0 and the maximum demand for a day is 3. The options are 0, 1, 2, and 3. If my target inventory level for CBP is 0, then I am essentially not selling this product – so this option is eliminated. What about holding a single unit? What is the probability I will meet all demand for this day? If demand is 0 or 1, then all demand is met. If demand is 2 or 3, then sales are lost. What is the probability I will have inventory left at the end of the day? If demand is 0, I will have one unit left. If demand is 1, 2, or 3 I will have no inventory left. What is the revenue and costs for having one unit in inventory and demand is 0
Table 02 summarizes the business outcome for each demand and starting inventory combination for five key metrics: ending inventory, unmet demand, revenue, holding cost, and net position.
We still need to make a decision on how much inventory to hold. Assume the two key metrics are unmet demand (client satisfaction) and ending inventory (business target of ice cream freshness). Next, we can create a risk profile for each inventory option for each key metric. Table 03 has the probability of an unmet demand level for each starting inventory level. Table 04 has the probability of each ending inventory level for each possible starting inventory decision. Figures 01 displays the information in Table 03 graphically making clear the nonlinear nature of the relationship between starting inventory and unmet demand.
The decision maker simply selects a starting inventory level based on their risk preference for unmet demand and ending inventory level. The tables have all of the options. It’s clear that there is no “free lunch.” More starting inventory more chance of higher ending inventory, but a lower chance of unmet demand. For example, a starting inventory level of one has about a 13.4% chance of some unmet demand, but no chance of ending levels greater than pme. If the decision maker selects a starting inventory level of 2, the chance of unmet demand drops to 6.67%, but now has an 80% chance of an ending inventory level greater than 1. In practice, a front end is built to support the business decisions and display the risks and costs. Observe, we have generated all of the core components (options, consequences, and risk or probability) to make a key inventory replenishment decision without ever generating a detailed demand forecast. The decision maker identified freshness as a business objective. One question the decision maker might ask is when there is one new unit of CBP in inventory, what is the chance this unit will go unsold for three days. We know the chances that it will go unsold for one day is 80%, since the probability of zero demand on any given day is 80%. This risk can be calculated using standard methods. The probability of zero demand for three successive days is 51.2%. If there are two new units of CBP in inventory, what is the chance at least one will go unsold for three days, this is 64%. Again, a critical risk decision can be assessed without ever generating a daily demand estimate. Summary Demand with lots of zeroes requires special attention and expertise. There are two major types: structural and intermittent. Intermittent implies the pattern of zeroes is random and requires special attention. The information presented about attempts to make clear the key to success is changing your orientation from detailed estimates to incorporating risk tradeoffs which is in align with the origins of forecasting (p. 95 Against the Gods, the Remarkable Story of Risk by Peter Bernstein). Of course the business tradeoffs are more complicated than this example, organizations that have adopted this approach have seen significant benefits.

More Blogs from Ken Fordyce
The past few years have made artificial intelligence a favorite buzzword. However, the technology has to evolve in a few ways to be hugely helpful to the supply chain.
By understanding the basics of intermittent demand, and following a few guidelines, it’s possible to manage the issue of shifting demand.
Identifying agents of change and understanding real optimization are the two critical factors in improving organizational responsiveness.
More than just a buzz word, analytics can be a critical part of sales and operations planningand can be a real boon to the supply chain.
EBN Dialogue / LIVE CHAT
EBN Dialogue enables you to participate in live chats with notable leaders and luminaries. Open to the entire EBN community of electronics supply chain experts, these conversations see ideas shared, comments made, and questions asked and answered in real time. Listed below are upcoming and archived chats. Stay tuned and join in!
Archived Dialogues
Live Chat 01/15: CPOs ReShape Their Business Roles
Increasingly chief procurement officers (CPOs) are reshaping their organizational role to focus on creating results far beyond cost controls. A new IBM survey explores how. Live Chat 11/12: Examining the Cyberthreat to Supply Chains
The number of cyberattacks is on the rise and hackers are targeting the supply chain. Drew Smith, founder and CEO of InfoArmor, will be on hand to discuss the reality of today's threat landscape and what to do about it. 

 

