2. Prepare the aggregate plan using chase strategy for the given data by completing Table 2. State if there is any concerns in the proposed plan. The company works six days a week (Friday is holiday) Table 1: Month Dec-2020 Jan-2021 Feb-2021 Demand 4000 6000 5000 Productive 6.5 hours/worker/day Paid straight hrs/day AED 150 AED 20/unit Materials required Holding costs per AED 10/unit month Marginal cost of stock AED 3/unit out per mo. 0.75 hrs/unit 400 units 8 Labor required Beginning inventory Workers in Nov 2020 Table 2: Days/mo Hrs/worker/mo Units/worker $/worker Demand Beg. inv. Net req. Required workers Production Workers Ending inventory Hire Fire Material cost Labour cost Hire cost Fire cost Total cost 3. Prepare MPS based on below table (MPS= 900, BI= 300): Period 1 2 Forecast 5000 3050 Customer orders 150 1000 ATP MPS Projected available 3 2470 500 2. Prepare the aggregate plan using chase strategy for the given data by completing Table 2. State if there is any concerns in the proposed plan. The company works six days a week (Friday is holiday) Table 1: Month Dec-2020 Jan-2021 Feb-2021 Demand 4000 6000 5000 Productive 6.5 hours/worker/day Paid straight hrs/day AED 150 AED 20/unit Materials required Holding costs per AED 10/unit month Marginal cost of stock AED 3/unit out per mo. 0.75 hrs/unit 400 units 8 Labor required Beginning inventory Workers in Nov 2020 Table 2: Days/mo Hrs/worker/mo Units/worker $/worker Demand Beg. inv. Net req. Required workers Production Workers Ending inventory Hire Fire Material cost Labour cost Hire cost Fire cost Total cost 3. Prepare MPS based on below table (MPS= 900, BI= 300): Period 1 2 Forecast 5000 3050 Customer orders 150 1000 ATP MPS Projected available 3 2470 500