CPIM Part 1 Formulas

CPIM Part 1 Formulas
Break-Even in Units
(Fixed Cost)/(Price per Unit - Variable Cost per Unit)


Deseasonalized Demand
(Period Average Demand)/(Seasonal Index)


Period Seasonal Index
(Period Average)/(Combined Period Average) (Ex: Quarter Avg / Year Avg)


Moving Average Forecast
(Sum of Demand for Most Recent Set of Periods)/(Number of Periods)


Exponential Smoothing Forecast
(αLast Demand)+((1-α)Last Forecast)


Mean Absolute Deviation (MAD)
(Σ |Actual - Forecast|)/(Number of Periods)


Tracking Signal
(Sum of Forecast Deviations)/(MAD)


Total Production
Total Forecast+Backorders+Ending Inventory-Opening Inventory


Ending Inventory
Prior Period Ending Inv+Production-Demand


Ending Projected Available Balance (PAB)
Beginning PAB + Sched MPS Receipt - Demand


First Period ATP
Beginning Inv-Sum of Cust Orders Before Period Containing First Sched MPS Receipt


ATP For Period Containing MPS
Sched MPS Receipt-Sum of Cust Orders Before Next Period Containing Sched MPS Receipt


Net Requirements
Gross Requirements-Scheduled Receipts-Prior Projected Available


Projected Available
Prior Period Projected Available + Scheduled Receipts + Planned Order Receipts - Gross Requirements