Finally, prepare an MRP following the example explained in class $($you can find the excel file under week $9$ of our class Moodle site to help you as a guide$).$ The MRP will need to describe the planning for at least $8$ weeks, for the manufacture of your product, whose bill of materials has at least $4$ components. The MRP will need to contain a Materials Master File, and one MRP table for each of the components of the bill of materials, which will contain all the fields in the following example table:

$\backslash$table$[[$Element X$-...,,,,,,,,],[$Week$,1,2,3,4,5,6,7,8],[$Gross Requirement$],[$Scheduled receipt$],[$Projected on hand$],[$Projected net requirement$],[$Planned order release,,,,,,,,$]]$