***** Please Show all work (if done in excel please dont just post screenshots)*****

.. 14.10 a) Given the product structure and master production schedule (Figure 14.12 below), develop a gross requirements plan for all items. b) Given the preceding product structure, master production schedule, and inventory status (Figure 14.12), develop a net materials requirements (planned order release) for all items. Px Master Production Schedule for X1 PERIOD 7 8 Gross requirements 50 9 11 Subassembly X1 10 20 12 100 B10 B22 LEAD TIME ITEM LEAD TIME ON HAND A1) EW) Ciz D1) ITEM X1 B1 B2 A1 1 2 2 1 ON HAND 50 20 20 5 D E 1 1 3 0 0 10 Ez Figure 14.12 Information for Problem 14.10