Operations Floor: Simulator
Stock control simulator
A stock control chart is a plan: when to reorder, how much, and how much to keep in reserve. Set the plan, enter demand week by week, make a delivery late, and the simulator runs the weeks, draws the chart, flags every stock-out and puts a price on holding stock, ordering it and running out of it.
Section 01: How to use it
-
Set the plan. The suggested reorder level is the buffer plus average demand during the lead time; use it or set your own.
-
Enter demand for each week, or set every week at once, and choose how many weeks to run.
-
Make one order arrive late, or switch the delay off, and watch where the buffer is used and where stock runs out.
-
Read the figures, the chart, the week-by-week table and the costs. Your plan is kept on this device; download it as JSON or CSV, open a saved plan, or print it.
Where it sits in the course. Subtopic 5.6, Production planning (guide, pp. 34 to 35), is HL only. It names stock control charts based on lead time, buffer stock, reorder level and reorder quantity (AO2 and AO4), and the difference between just in time and just in case (AO3). The guide gives no formula for the reorder level or the maximum stock, so the standard forms of the notes on production planning are used. The costs go beyond the syllabus, to make the trade-off visible.
Simulator
Wrenhurst Cycles' gear sets, a fictional example
The plan is the one in the notes on production planning: Wrenhurst uses about 200 gear sets a week, reorders 800 when stock falls to 600, keeps a buffer of 200 and waits two weeks for each delivery. Here a busy spell lifts demand to 250 a week in weeks 7 to 10, and the second order arrives a week late. Every figure is simulated.
The tool could not start in this browser. Everything below is the worked example as it was prepared, with its results.
How the plan runs
- Reorder level
- 600suggested 625: buffer + average demand × lead time
- Maximum stock
- 1,000buffer + reorder quantity
- Lowest stock
- 0stock runs out
- Weeks with a stock-out
- 1week 9
- Demand not met
- 150gear sets, of 3,400 in all
- Demand met from stock
- 95.6%
- Orders placed
- 4
- Average stock
- 540.9gear sets
Check the plan
- The reorder level is below the buffer plus average demand during the lead time, so an average order cycle dips into the buffer.
Reading. Orders of 800 gear sets are placed when stock falls to 600 gear sets; 4 orders are placed in 16 weeks, and stock averages 540.9 gear sets. Stock runs out in week 9: 150 gear sets of demand cannot be met (4.4% of the total), costing $30,000 at $200.00 each.
Implication. A larger buffer, a higher reorder level for the busy weeks, a larger reorder quantity or a supplier with a shorter or more reliable lead time would protect production. The buffer covers about 0.9 weeks of average demand. Each remedy raises the cost of holding stock, which is the trade-off between just in case and just in time.
The plan week by week
| Week | Start | Demand | Met | Not met | Delivered | End | Note |
|---|---|---|---|---|---|---|---|
| 1 | 1,000 | 200 | 200 | 0 | 800 | ||
| 2 | 800 | 200 | 200 | 0 | 600 | order placed | |
| 3 | 600 | 200 | 200 | 0 | 400 | ||
| 4 | 400 | 200 | 200 | 0 | 800 | 1,000 | delivery |
| 5 | 1,000 | 200 | 200 | 0 | 800 | ||
| 6 | 800 | 200 | 200 | 0 | 600 | order placed | |
| 7 | 600 | 250 | 250 | 0 | 350 | ||
| 8 | 350 | 250 | 250 | 0 | 100 | below the buffer | |
| 9 | 100 | 250 | 100 | 150 | 800 | 800 | delivery; stock-out |
| 10 | 800 | 250 | 250 | 0 | 550 | order placed | |
| 11 | 550 | 200 | 200 | 0 | 350 | ||
| 12 | 350 | 200 | 200 | 0 | 800 | 950 | delivery |
| 13 | 950 | 200 | 200 | 0 | 750 | ||
| 14 | 750 | 200 | 200 | 0 | 550 | order placed | |
| 15 | 550 | 200 | 200 | 0 | 350 | ||
| 16 | 350 | 200 | 200 | 0 | 800 | 950 | delivery |
What the plan costs over the weeks shown
| Cost | How it is worked out | Amount |
|---|---|---|
| Holding | average stock 540.9 × 16 weeks × $0.06 | $519.30 |
| Ordering | 4 orders × $96.00 | $384.00 |
| Running out | 150 units short × $200.00 | $30,000.00 |
| Total | $30,903.30 |
A bigger buffer raises the cost of holding stock and cuts the cost of running out. Just in time pushes one way, just in case the other.
Section 02: What it leaves out
Every model simplifies. Say so in an answer, and say what else you would want to know.
- Each week's demand is used at a steady rate through the week and is known in advance. Real demand varies by the day and is uncertain.
- Only one order is open at a time, every delivery is complete and arrives at once, and there is one item. A real business manages thousands of items, often with software.
- Demand that cannot be met is counted as lost, at the cost entered. In practice some customers wait and some leave for good.
- The costs are simple illustrations: a holding cost per unit per week, a fixed cost per order and a cost per unit short. Real holding costs include the cash tied up, storage, insurance and the risk of stock perishing or going out of date.
- The reorder level and maximum stock formulas are standard forms that the guide does not give, so show your method in an answer.
Section 03: Read and practise next
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/operations-floor/stock-control/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.