Material Requirements Planning Assignment

The following table lists the components needed to assemble an end item, lead times $($in weeks$),$ quantities on hand, and scheduled receipts. Compete an MRP schedules sufficient to produce Item A in quantities of $20$ in week two, $10$ in week four, $20$ in week six, $5$ in week seven, $35$ in week nine, and $10$ in week ten. Assume all components can be ordered on a lot$-$for$-$lot basis except Item $C,$ which has a fixed lot size of $50($can be ordered in multiples of $50$ if needed$).$

$\backslash$table$[[$Item$,$Lead Time,Amount on Hand,Scheduled Receipts,Lot Sizing$],[$A$,2,25,,$Lot$-$for$-$Lot$],[$B$,2,22,25$ in week #$3,$Lot$-$for$-$Lot$],[$C$,1,4,50$ in week #$1,50$ Fixed$],[$D$,2,27,,$Lot$-$for$-$Lot$],[$E$,2,15,,$Lot$-$for$-$Lot$]]$

MasterSchedule foGrossrequrementsOn handScheduled receiptsMWeekNetrequrenmentsPlanned order receiptsOuantityYPlanned order releasesGrOSS TequirementsOn handScheduled receiptsNetreqrementsPlanned order teceiptsPlanned order releasesGrOSS requirementsOn handScheduied receiptsNet requirementsPlanned order receiptsGroS#Planned order releasesOn handScheduied nenpr#Net sequisPlanned ordetPlannedo$1$det HeBegIny$4$BegInyWeekWeekBeg$1234566$Meek$567891010124$S $6910$