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.

Back to 5.6 Production planning

Status
HL onlyAO2, AO4
Worked example
Wrenhurst Cycles' gear sets, a fictional example

Section 01: How to use it

  1. Set the plan. The suggested reorder level is the buffer plus average demand during the lead time; use it or set your own.

  2. Enter demand for each week, or set every week at once, and choose how many weeks to run.

  3. Make one order arrive late, or switch the delay off, and watch where the buffer is used and where stock runs out.

  4. 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

Source: Simulated data HL only

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.

Your changes are kept in this browser, on this device only.

The plan
Suggested: 625, the buffer plus average demand during the lead time.
A late delivery

Orders are numbered in the order they are placed, as on the chart.

Demand, week by week
4 to 26. New weeks copy the last one.
What stock costs

Simulated: a gear set costs about $30, and holding one for a year costs about a tenth of that, $3, or $0.06 a week. Each order costs $96 to place and deliver. A gear set short means a bike not built, and $200 is the contribution of one bike in the notes on production planning.

This is the worked example. With JavaScript on, you can change the plan, the demand and the late delivery, and the chart and figures follow.

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.
Stock control chart: the plan week by weekStock over 16 weeks, starting at 1,000 gear sets. Orders of 800 gear sets are placed at the reorder level of 600 gear sets and arrive after 2 weeks, except order 2, which arrives 1 weeks late. The buffer is 200 gear sets. 4 orders are placed. The lowest stock is 0 gear sets. Stock runs out in week 9, and 150 gear sets of demand cannot be met. Weekly demand ranges from 200 gear sets to 250 gear sets.02505007501,0001,250Stock-outMaximum 1,000Reorder level 600Buffer 2001234Order 2 arrives 1 week lateStock (gear sets)Demand each week4000012345678910111213141516WeeksGold: abovethe averageOutlined: stock-out
Chart Stock week by week (dark line), with the maximum, the reorder level (dashed blue) and the buffer (green). Each numbered blue mark is an order being placed; stock-outs are shaded and labelled. Below, demand each week. Simulated teaching data.

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
11,0002002000800
28002002000600order placed
36002002000400
440020020008001,000delivery
51,0002002000800
68002002000600order placed
76002502500350
83502502500100below the buffer
9100250100150800800delivery; stock-out
108002502500550order placed
115502002000350
123502002000800950delivery
139502002000750
147502002000550order placed
155502002000350
163502002000800950delivery

What the plan costs over the weeks shown

Cost How it is worked out Amount
Holdingaverage stock 540.9 × 16 weeks × $0.06$519.30
Ordering4 orders × $96.00$384.00
Running out150 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