Please help complete the following table, and it is going to be about 12 tables... thanks!

You have just received an order for 60 units of Product X. for shipment at the start of week 7. Some information about Product X is as follows: Item X A B D E F Lead Time (Weeks) 1 2 2 1 2 2 1 On Hand Components 10 A, B(3), C(2) 15 E(2), D(2) 15 D(3), F(2) 5 E(3), D(2) 10 30 20 Order Size 20 15 10 20 20 (a) Develop the product structure tree. (6) Develop the material requirements plan for all components. (C) If maximum production capacity of part E is limited to 200 units per week. Revise the planned-order releases for weeks 1-4 so that the maximum limit is not exceeded in any period, keeping in mind an objective of minimizing carrying costs. The quantities need not be equal in every period. Note that the gross requirements for E will remain the same. However, quantities in some of the other rows will change. Determine the new cell values for those rows. 1 2 3 4 5 6 7 8 Item Item Period Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order release Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order release Gross requirements Scheduled receipts Projected on hand Net requirements Item