MPS Planner — Whole Bird Weight Grades

single-line master plan · 5 days → 12 weeks → months · SAP MRP handoff

–
Demand fill (6 mo)
–
Shortage (birds)
–
Peak bucket load
–
Line utilisation
–
Projected end stock
–
Planned tonnage

Master production schedule — total birds per bucket (editable; Suggest fills it, you own it)

Line capacity: 125,000/day · weekly ×5 working days · monthly ×22
PLANNED OUTPUT MIX →
INPUT MIX · yield % →
The mix converts each line-bucket total into weight grades for the balance below — set it from your grading history. Sum 100%.

Demand — orders + forecast, birds per grade per bucket (editable — type your real numbers)

Set up fills every cell from the schedule above: production × grade mix % − opening stock, and the stock is eaten period by period — where a grade's stock covers the whole period the cell reads 0 and what is left of the stock carries into the next one. Type over anything afterwards; the figures are yours.

Projected available balance by grade — stock + cumulative supply − cumulative demand

Balance: covered shortage building ahead / surplus no demand

History — closed days, archived as the plan rolls

Demo-grade planning model: a single-line MPS over telescoping buckets (5 daily · 12 weekly · monthly to 6 months), lot-for-lot suggestion with build-ahead capacity smoothing, one planned grade mix. Production build adds per-bucket mixes, lot sizing, safety stock, freezer aging and firm/time-fence zones. An EvoApps demo by Oaksoft / EvoEdge.