In case you want the full case study, you can refer the previous question that I posted.

1) Suppose we want to make the MRP for the month 7 by MA(4) for Pump 32-160 and 0.8 for Pump 32-200.

Year Month Acmal Sale Forecastin MA (3) ). MA (4) MA (5) 1 3 3 4 5 6 250 200 90 150 2021 160 Type 2 Numbert corpions 0 10 Table 1. Bill of Materal for Pump 32-160 Finished Partim Code Part tes 16 0005 21065 HIDE 10-01-09 21-01-05 Imeile 3 10-10-005 226-305 4 10-003658 1016 005 San 220052 Debles 123006-5 Nu 37-150 324160, 12-200 Rebe - 60 mm MAT M169 120 140 170 130 110 Type Number of 32-300 Table 2. Bill of Material for Pump 32-200 Na R Part Fiesbad Part Code Pascade 10-01:05 22012000 310000 2013-000 Impeller 3 10-20-005 S0-003 BE 4 70-003-000 Shan 22-0021 Dahle Na 1 2 3 4 $ 6 12-160, Rebar-6740 16 UNI 1000 3 Table 5. Sales Forecasting 32-200 with the Exponential Smoothing Method Year Months Actual Forecastin Sale 02 05 0.1 -250 200 90 150 2021 210 160 110 1 120 160 10 170 11 180 110 Questions: 1. Suppose we want to make the Material Requirement Planning (MRP) for the month 7 by MA (4) for Pump 32-160 and 0.8 for Pump 32-200. You have all information in the Tables 1-5. Table 3. Inventory/Stock of parts/material in the company's different warehouses Ha Rew Part Files Put Type ber of Code Dart code Care | (Unit RAT Fabr neral pro 1003 FO 15 40 100 10-015-003 POROS TE Spoiler PE 100 2010 10.2009 21-10-05 12200 150 11-000 HOME 30 100 30 10-01 2000 100 70 1320 6 100 21-07-20 ET 100 100 w DICE ES 300 2 55 Table 4. Forecasting-Pump 32-160 with the Moving Average Method Year Month Acmal Sale Forecastin MA (3) ). MA (4) MA (5) 1 3 3 4 5 6 250 200 90 150 2021 160 Type 2 Numbert corpions 0 10 Table 1. Bill of Materal for Pump 32-160 Finished Partim Code Part tes 16 0005 21065 HIDE 10-01-09 21-01-05 Imeile 3 10-10-005 226-305 4 10-003658 1016 005 San 220052 Debles 123006-5 Nu 37-150 324160, 12-200 Rebe - 60 mm MAT M169 120 140 170 130 110 Type Number of 32-300 Table 2. Bill of Material for Pump 32-200 Na R Part Fiesbad Part Code Pascade 10-01:05 22012000 310000 2013-000 Impeller 3 10-20-005 S0-003 BE 4 70-003-000 Shan 22-0021 Dahle Na 1 2 3 4 $ 6 12-160, Rebar-6740 16 UNI 1000 3 Table 5. Sales Forecasting 32-200 with the Exponential Smoothing Method Year Months Actual Forecastin Sale 02 05 0.1 -250 200 90 150 2021 210 160 110 1 120 160 10 170 11 180 110 Questions: 1. Suppose we want to make the Material Requirement Planning (MRP) for the month 7 by MA (4) for Pump 32-160 and 0.8 for Pump 32-200. You have all information in the Tables 1-5. Table 3. Inventory/Stock of parts/material in the company's different warehouses Ha Rew Part Files Put Type ber of Code Dart code Care | (Unit RAT Fabr neral pro 1003 FO 15 40 100 10-015-003 POROS TE Spoiler PE 100 2010 10.2009 21-10-05 12200 150 11-000 HOME 30 100 30 10-01 2000 100 70 1320 6 100 21-07-20 ET 100 100 w DICE ES 300 2 55 Table 4. Forecasting-Pump 32-160 with the Moving Average Method