he forecast for each week is $30$ units.

The starting inventory is $12.$

The production lot size is $70($MPS$)$ when the projected on$-$hand inventory is negative.

Calculate the Projected on$-$hand inventory $($POI$)$

Calculate the Available to Promise $($ATP$)$

Given the following Master Schedule:

WeeWeek

CjusCustomer order

$1$

$34$

$2$

$29$

$3$

$28$

$4$

$35$

$5$

$32$

$6$

$33$

$7$

$35$

$8$

$35$

Week

Begining inventory$=12$

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

Forecast

$30$

$30$

$30$

$30$

$30$

$30$

$30$

$30$

Customer Orders

$34$

$29$

$28$

$35$

$32$

$33$

$35$

$35$

Projected On$-$Hand Hand Inventory

$78$

$79$

$81$

$146$

$214$

$281$

$346$

$411$

MPS

$70$

$0$

$0$

$70$

$70$

$70$

$70$

$70$

ATP

$44$

$50$

$53$

$111$

$182$

$248$

$311$

$376$

Note:

The ATP quantities can be presented to the Marketing Department to promise customers the number of units to be manufactured by a specific date.

Formula: Week $1$ ATP $=$ Beginning Inventory $+$ MPS $$ Customer Order

Week $2$ ATP $=$ MPS $$ Customer Order

Week $3$ ATP $=$ MPS $($Wk$3+$ Wk$4)$