Please do question b, thank you!

The forecasted requirements for a hairdryer and associated MPS are shown below. ITEM: Hair Dryer ORDER POLICY: 60 units QUANTITY ON HAND: 40 units LEAD TIME: 1 week Week 1 2 3 4 5 6 Forecast requirements 15 40 10 20 50 30 Customer orders (booked) 20 25 10 20 0 0 Projected on-hand inventory MPS quantity MPS start a. Please complete the MPS table above. (3 pts.) (In doing so, please use a blank sheet to create an MPS table like the one above and fill out the bottom three rows and upload the completed table back into Canvas). Below is an Inventory Records for one component (Item "B") of hairdryer. Each hairdryer requires THREE units of this component ("B"). ITEM: Component B ORDER POLICY: L4L QUANTITY ON HAND: 100 units LEAD TIME: 2 weeks SAFETY STOCK: 15 units Week 1 2 3 4 5 6 Gross requirements Scheduled receipts 100 Projected on-hand inventory Planned (order) receipts Planned order releases b. Please complete the Inventory Records table above. (3 pts.) (In doing so, again, use a blank sheet to create and complete the Inventory Records table by filling out the four rows: Gross requirements, Projected OH inventory, Planned (order) receipts, and Planned order releases. You may show the two completed tables (MPS and Inventory Records) together in a single sheet and take a picture of it and upload it back into Canvas.) The forecasted requirements for a hairdryer and associated MPS are shown below. ITEM: Hair Dryer ORDER POLICY: 60 units QUANTITY ON HAND: 40 units LEAD TIME: 1 week Week 1 2 3 4 5 6 Forecast requirements 15 40 10 20 50 30 Customer orders (booked) 20 25 10 20 0 0 Projected on-hand inventory MPS quantity MPS start a. Please complete the MPS table above. (3 pts.) (In doing so, please use a blank sheet to create an MPS table like the one above and fill out the bottom three rows and upload the completed table back into Canvas). Below is an Inventory Records for one component (Item "B") of hairdryer. Each hairdryer requires THREE units of this component ("B"). ITEM: Component B ORDER POLICY: L4L QUANTITY ON HAND: 100 units LEAD TIME: 2 weeks SAFETY STOCK: 15 units Week 1 2 3 4 5 6 Gross requirements Scheduled receipts 100 Projected on-hand inventory Planned (order) receipts Planned order releases b. Please complete the Inventory Records table above. (3 pts.) (In doing so, again, use a blank sheet to create and complete the Inventory Records table by filling out the four rows: Gross requirements, Projected OH inventory, Planned (order) receipts, and Planned order releases. You may show the two completed tables (MPS and Inventory Records) together in a single sheet and take a picture of it and upload it back into Canvas.)