How the data reaches each team
Three inputs pass through one calculation path, and each team receives only the sheet it acts on. Select any box to see what it holds and which process steps and rules govern it.
Grey boxes are inputs, blue-violet boxes are calculations, and steel boxes are outputs handed to a team.
Which team does what, and what it passes on
The output of one function becomes the input of the next. Sourcing decides who to buy from and at what rate; purchase decides how much and when. Select a team to see its inputs, outputs and the rules it owns.
RMCP process steps
The monthly RM, CP and packing-material calculation as walked through on 29 September 2026, from BOM download to the daily production mix.
Operating rules for planning and procurement
29 rules from the four meetings of 30 September 2026. Filter by theme or by the team that has to supply information.
Planning calculators
Each calculator applies a formula from the documents. Change any value and the result updates immediately.
Plan quantity per FG
Rule 1: total demand − (opening stock + FG green level)
BOM explosion
Step 9: BOM quantity per 1,000 × plan quantity ÷ 1,000
MTS / MTO lot planner
Steps 12–14: EBQ lots, extra pieces per lot and manpower
Purchase netting and stock status
Step 10 and Rules 2, 23, 25: order only what stock, open POs and green level don’t cover
Order-by date
Rules 3 and 5: work back from the date material is needed
Vendor comparison
Rule 14 and sourcing: three formal quotes, scored on rate, quality and timeliness
Action tracker
Follow-up actions and open points from both documents. Select a status to move it from Open to In progress to Done. Progress is saved in this browser.
Operating rules follow-ups
From the 30 September meetings
Process steps follow-ups
From the 29 September meeting
Points to confirm: operating rules
Tick once settled
Points to confirm: process steps
Tick once settled