Please help. I need help answering this question. Please show step by step. I have missed this problem twice. It is for MGMT 5330.

A bicycle is assembled using three components, as shown in the Bill of Materials below. The company wants to ship 180 units at the beginning of week 4, 250 units at the beginning of week 6, and 250 units at the beginning of week 7. Receipts of 180 wheels are scheduled at the beginning of week 2. There are 90 tire rims on hand. There are 45 frames on hand. Lead times (in weeks) for all items are shown in the following table. In addition, there are no safety stock requirements for this example Production needs the materials at least one week in advance Quantit Lead Bicycle y Time 1-300 1 week 301- 2 Wheel ( 2 ) Tire rims(2) Frame ( 1) 600 weeks 601- 3 5000 weeks Beg. Master Day Inv. 2 3 4 5 6 7 Schedul Quantity 180 250 250 Beg. Bicycle Inv. Gross requirements Scheduled receipts Projected available Net requirement receipts releases Beg. Wheels Inv. Gross requirements Scheduled receipts Projected available Net requirements Planned-order Planned-order Beg. Tire rims Inv. 2 3 Gross requirements Scheduled receipts Projected available Net requirements Planned-order Planned-order Beg. Frame Inv. 2 3 4 5 6 Gross requirements Scheduled receipts Projected available Net requirements Planned-order Planned-order