b$.$ Develop a material requirements plan $($MRP$)$ by finishing the attached Excel template $($HW$5\_$P$1($b$)).$ Notice that $200$ carts must be

ready by week $8.$ Use lot$-$for$-$lot.

To help me grade your HW$,$ find the sections of Top, Wheel assemblies, and Seats in your finished MRP Excel. Copy & paste the

sections to the table below $($or take snapshots$).$ No need to upload the Excel sheet. I will grade only these three sections.

Weeks

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

On hand $=240$

LT $=1wk$

Lot size: L$4$L

Saftey Stock $=0$

On hand $=40$

LT $=1$ wk

Lot size: L$4$L

Saftey Stock $=0$

Top

Gross Requirement

Scheduled Receipts

Projected Ending Inventory

Net Requirement

Planned order receipts$-$

Planned order releases

Wheel assemblies $(4)$

Gross Requirement

Scheduled Receipts

Projected Ending Inventory

Net Requirement

Planned order receipts

Planned order releases

Seats $(2)$

On hand $=120$

LT $=2wk$

Lot size: L$4$L

Saftey Stock $=0$

Gross Requirement

Scheduled Receipts

Projected Ending Inventory

Net Requirement

Planned order receipts

Planned order releases