Based on the information in the box, conduct MRP $($Material Requirements Planning$)$ under Lot$-$for$-$Lot policy and insert your answers for A and $B$ in the MRP table.

Note: Please use the MRP sheet attached$($MRP exam template$\_$Single template.xlsx darr $)$ to answer the questions

Each shutter consists of $3$ slatted wood sections and $2$ frames

A firm that produces wood shutters has received two orders: one for $130$ shutters $($week $5)$ and one for $210$ shutters $($week $9)$

The wood sections are made by the firm, and fabrication takes $2$ weeks

The frames are ordered, and lead time is $1$ week

Assembly of the shutters requires $1$ week

There is a scheduled receipt of $75$ wood sections in $($i$.$e$.,$ at the beginning of$)$ week $1.$

$\backslash$table$[[$Week Number,$1,2,3,4,5,6,7,8,9,],[$Quantity$,,,,,,,,,]]$

$\backslash$table$[[$Shutter$,$Gross requirements,$0,0,0,,,,,$WM$,],[,$Scheduled receipts,,$-,,,,-,,$H$,],[$Quantity $=,$Projected on hand,,$,,,$H$,,,,],[LT=,$Net requirements,N$,,,$m$,,||,,14,],[$Lot Size $=,$Planned$-$order receipts,,,,,,,,$h,],[$On hand $=,$Planned$-$order releases,,MI$,$HI$,MM,M1,,H_{1H},$In$,$Find A & B