In preparing the MRP example Phil planned to use the worksheets shown and to make the following assumptions:

$1.$ Twenty two gear boxes are on hand at the beginning of Week $1,$ and eight gear boxes are currently on order to be delivered at the start of Week $2.$

$2.$ Forty five input shafts are on hand at the start of Week $1,$ and $25$ are scheduled for delivery at the beginning of Week $2.$ a$.$ Initially, assume that Phil wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using lot$-$for$-$lot $($L$4$L$).($Leave no cells blank $-$ be certain to enter $"0"$ wherever required.$)$

Gear Box Requirements