Supply Chain · Planning
Planning that starts from your own data. Issue history becomes a forecast. The forecast is balanced against stock and open orders. Work orders peg net requirements. Long-lead items show their commit date. It is planning for procurement, not a full APS, and it says so.
Five steps, each one a page, each one fed by the movement ledger.
Know the stock
Stock on hand, projected stock and ageing are read from the movement ledger. Every receipt, issue and transfer is a posting, so the balance is never a typed number.
Forecast
Per item, the issue history is projected forward with a moving average. The consumption trend shows whether usage is rising or falling.
Balance
S&OP Balance sets projected monthly demand against on-hand and on-order. Months of coverage per item; short-cover items are flagged.
Net the requirement
Demand-pegged MRP explodes active work-order BOMs into gross demand, subtracts on-hand and on-order, and pegs the net to its work order.
Commit in time
The Long-Lead Planner shows when to place the order to avoid a line stoppage. The need-by date on the requisition line carries it into procurement.
One ledger and one set of work orders feed every planning view.
A per-item forecast built from the issue history. The next months are projected with a moving average and the consumption trend is shown beside it. No model to tune and no spreadsheet to maintain; the forecast moves as issues are posted.
Projected monthly demand against stock on hand and quantity on order. Months of coverage per item makes the picture plain: enough, tight, or short before the next receipt lands. Short-cover items are flagged for the buyer.
Net material requirements pegged to active work-order demand. Gross demand is BOM-exploded from the work orders, then on-hand and on-order are subtracted. Each net requirement points at the work order that needs it, so a shortage names the job it would stop.
Long-lead items and when to commit. The planner compares lead time with the time left and shows the date by which the order must be placed to avoid a line stoppage. Need-by dates on requisition lines are where that commitment enters procurement.
Stock on hand, projected stock and ageing all come from the movement ledger. Because planning reads the same postings as the stores pages, the forecast, the balance and the stock list never disagree.
The calculations stay the same; the words follow your organisation.
Forecast
Run rate · consumption plan · demand plan
Coverage
Months of stock · days of supply · DOS
Net requirement
Shortage · to-buy quantity · MRP shortfall
Post your movements and open work orders. Forecast, balance, MRP and the long-lead planner fill in from there.