Problem #$1$

Jenny Malone works for the Columbus based Cummins Diesel Engine company. Jenny works in the production scheduling department and she is developing an MRP planning schedule for Item J$.$ Please assist Jenny by developing the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. The lead time is one week. $($Leave no cells blank $-$ be certain to enter $"0"$ in all open cells as required.$)$

WEEK NUMBER

ITEM J $012345$

Gross requirements $664161$

On hand $44$

Net requirements

Planned order receipt

Planned order release

Period $12345$

Item J

LT $=1$

Q $=$ L$4$L Gross requirements $664161$

Scheduled receipts

$0$

$0$

$0$

$0$

$0$

Projected available balance

$44$

$0$

$0$

$0$

$0$

Net requirements

$0$

$22$

$0$

$41$

$61$

Planned order receipts

$0$

$22$

$0$

$41$

$61$

Planned order releases

$22$

$0$

$66$

$82$

$0$