Complete the two MRP calculations in the two tables shown below. For purposes of this problem, follow the rule demonstrated in class-which is that no replenishment order is needed in any period in which the ending inventory quantity is equal to or greater than the specified minimum on-hand quantity for each item. An Excel file will be e-mailed to you with these tables and the other information about the problem in place. You can use the Excel file to enter the correct values in the respective cells. Then replace the Item Description in the spreadsheet with your first and last name, save the Excel file, and submit the Excel file in the link provided here. Item: HB-600 Description: Handlebar Subassembly-Standard Lot Size: Lead Time: Safety Stock: FOQ 200 Units 2 Weeks O Units Week 1 2 3 4 5 6 7 8 Gross Requirements 85 25 60 110 80 100 70 110 Scheduled Receipts 100 Projected On-Hand Inv 20 Planned Receipts Planned Order Releases Item: HB-800 Description: Handlebar Subassembly-Racing Lot Size: Lead Time: Safety Stock: Lot for Lot 3 Weeks 30 Units Week 1 2 3 4 5 6 7 8 Gross Requirements 90 10 140 140 70 30 110 70 Scheduled Receipts 200 Projected On-Hand Inv 70 Planned Receipts Planned Order Releases