2. Master Production Scheduling & Material Requirements Planning. Given the following Bill of Material, complete the assigned tasks: Hierarchy Bill of Material for Part A (1 unit) B B (2 units) C (1 unit) D (2 units) Summarized Bill of Material for Part A Level 01 01 02 Part Number B C D Quantity 2 1 2 Unit of Measure Each Each Each A) Complete the Master Production Schedule for the finished goods Part A. On Hand = 30 units Lead time = 1 week Order Quantity = 100 units Safety Stock = 0 units 1 SO Week 2 3 70 90 4 60 Forecast Customer Orders Projected Available Balance 30 Available-to-Promise Master Production Schedule In what week(s) will there be a Master Production Schedule requirement for Part A? B) Complete the Material Requirements Plan for Part C (part number C). (Hint: Remember to use the Master Production Schedule for Part A and the Bill of Material to determine the Gross Requirements) On Hand = 80 units Order Quantity - 100 units Lead time 1 week Safety Stock = O units Week 3 1 2 4 30 Gross Requirements Scheduled receipts Projected Available Balance 80 Net Requirements Planned order receipt Planned order release In what week(s) will there be a planned order release for Part C? C) Complete the Material Requirements Plan for Part D (part number D). (Hint: Remember to use the Material Requirements Plan releases for Part C and the Bill of Material to determine the Gross Requirements) On Hand 50 units Order Quantity = 200 units Lead time = 1 week Safety Stock = 10 units Week 4 1 3 50 Gross Requirements Scheduled receipts Projected Available Balance Net Requirements Planned order receipt Planned order release In what week(s) will there be a planned order release for Part D? D) Now that you have demonstrated the linkage between the Master Production Schedule and the Material Requirements Plan, explain the major risk(s) in changing the forecast in Week 3 of the Master Production Schedule during the demand time fence