How do I calculate the MRP, Purchase Plan, and Capacity plan given the information provided?

O AutoSave OFF A S U = Term Project Schedule STUDENT Home Page Layout Formulas Data Review View Share Comments C22 A Insert x B Draw fx D C E H I J K L M N O P Q R F G Aggregate Plan Beginning Inventory Sales (units) 2 24 Safety Stock BOM On-Hand MPS & MRP Material Type Finished ZX3 Handles Coils Raw Boxes Raw Raw 3 12 2 2,994 3,002 487 Lead Timel Cost Months $3,495.00 $ 11.51 $ 137.50 $ 23.95 2 Lot Size 550 1,200 880 100 98.0% 97.0% 95.0% 60.0% 5,300 2,500 675 1,500 Amount 300617 400753 350 577 8020 Human Resources 33 beginning headcount in January Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Actual Committed Orders Orders 4,885 4,904 5,104 5,082 5,190 5,223 5,003 5,960 6,620 6,101 6,455 6,998 6.700 8.225 7.750 5.900 5,575 4,200 740 100 Finance / Accounting $ 645 Regular production costs $ 790 Overtime production costs $ 945 Subcontractor production costs $ 1,750 to hire or layoff one employee $ 775 Carrying costs $ 550 Backlog costs Operations 210 Monthly Zx3 production per employee - Targeted inventory in December 2018 Schedule Overtime prior to Subcontractors 3,700 9.940 8,825 2,250 Forecast Parameters (if needed) Data F orecast Aggregate MPS MRP Purchase Plan Capacity + Data Review View Share Co Home B3 Insert 4 x B Draw fx C Page Layout Formulas =YEAR(Forecast!A18) D E F G H I J K L M N O P Q R Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2 Material Requirements Plan 2019 Jan Feb Demand ZX3 Gross Requirements Scheduled Receipts Projected On-Hand (at beginning af period) Net Requirements Planned Order Receipts Planned Order Releases Scheduled Receipts Projected On-Hand (al beginning of period) Net Requirements Planned Order Receipts Planned Order Releases Coils Gross Requirements Scheduled Receipts Projected On-Hand (at beginning af period) Net Requirements Planned Order Receipts Planned Order Releases Boxes Grass Requirements Scheduled Receipts Proiected On Hand (a beginning af period) Net Requirements Planned Order Receipts Planned Order Releases Data Forecast Aggregate MPS MRP Purchase Plan Capacity + Purchase Plan 2019! Item Month Quantity Cost 2 Capacity Plan 2019 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 5 Capacity Regular Total Production 27 Analysis: O AutoSave OFF A S U = Term Project Schedule STUDENT Home Page Layout Formulas Data Review View Share Comments C22 A Insert x B Draw fx D C E H I J K L M N O P Q R F G Aggregate Plan Beginning Inventory Sales (units) 2 24 Safety Stock BOM On-Hand MPS & MRP Material Type Finished ZX3 Handles Coils Raw Boxes Raw Raw 3 12 2 2,994 3,002 487 Lead Timel Cost Months $3,495.00 $ 11.51 $ 137.50 $ 23.95 2 Lot Size 550 1,200 880 100 98.0% 97.0% 95.0% 60.0% 5,300 2,500 675 1,500 Amount 300617 400753 350 577 8020 Human Resources 33 beginning headcount in January Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Actual Committed Orders Orders 4,885 4,904 5,104 5,082 5,190 5,223 5,003 5,960 6,620 6,101 6,455 6,998 6.700 8.225 7.750 5.900 5,575 4,200 740 100 Finance / Accounting $ 645 Regular production costs $ 790 Overtime production costs $ 945 Subcontractor production costs $ 1,750 to hire or layoff one employee $ 775 Carrying costs $ 550 Backlog costs Operations 210 Monthly Zx3 production per employee - Targeted inventory in December 2018 Schedule Overtime prior to Subcontractors 3,700 9.940 8,825 2,250 Forecast Parameters (if needed) Data F orecast Aggregate MPS MRP Purchase Plan Capacity + Data Review View Share Co Home B3 Insert 4 x B Draw fx C Page Layout Formulas =YEAR(Forecast!A18) D E F G H I J K L M N O P Q R Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2 Material Requirements Plan 2019 Jan Feb Demand ZX3 Gross Requirements Scheduled Receipts Projected On-Hand (at beginning af period) Net Requirements Planned Order Receipts Planned Order Releases Scheduled Receipts Projected On-Hand (al beginning of period) Net Requirements Planned Order Receipts Planned Order Releases Coils Gross Requirements Scheduled Receipts Projected On-Hand (at beginning af period) Net Requirements Planned Order Receipts Planned Order Releases Boxes Grass Requirements Scheduled Receipts Proiected On Hand (a beginning af period) Net Requirements Planned Order Receipts Planned Order Releases Data Forecast Aggregate MPS MRP Purchase Plan Capacity + Purchase Plan 2019! Item Month Quantity Cost 2 Capacity Plan 2019 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 5 Capacity Regular Total Production 27 Analysis