LEARNING ASSIGNMENT 7 Your task is to make both master production plan for end product A and material requirements calculations for parts B, C, D and E. Forv Bill of material (BOM) Please notice the following: - The required amountumber of items is presented in brackets e.g. (2). - Lead time of two weeks means that if the scheduled receipt is on week 5 the order has to be released on week 3. - Safety stock refers to a preferred level of inventory. The starting inventory (=on hand) is not necessary the same in the beginning of planning period. - On hand inventory refers to the inventory level in the beginning of the planning period (in this case week 1). - Lot size refers to the planning technique for that particular item. o L4L means lot-for-lot/chase sales technique. o FOQ refers to fixed order quantity e.g. 100 or multiple (200,300,400.. Task 7a Make the MPS calculation for end product A following the information given in bill of material (BOM). Apply the below table template Task 7b Make the MRP calculation for parts B, C, D and E following the information given in bill of material (BOM). Apply the below table template Return your task either as a spreadsheet (i.e. Excel file) calculation or as a PDF-file where you have marked formulas for each column