Prepare an MRP following the example explained in class . The MRP will need to describe the planning for at least 8 weeks, for the manufacture of electric car, 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:using excel.

1 23 4 56 7 8 Element X-... Week Gross Requirement Scheduled receipt Projected on hand Projected net requirement Planned order release