Your task is to complete the MPS plans for both end items and to create material requirements plans (MRP) forany 5 items in the BOM.
First complete all of the information in the MPS plans.
Then, using the MRP forms supplied in the spreadsheets. Fill in all appropriate data (lot size, ordering rule, etc).
Do not make any changes to the format/layout of the spreadsheet. This is one place in industry where creativity in presenting data is not appreciated since many of the cells in the forms are normally linked, and changes can lead to significant errors in the results.