120% Paragraph Bryles AbbceDete AaBbcode A AaBbCd AaBBCD Aa Bb AaBbc Normal Na Spating Heading 1 Heading 2 Tale Subtith Sul 12 Use Excel to solve the below problems. 1. Construct an exponential forecasting calculator to find (a) forecasted demand using exponential forecasting (b) forecasting error (c) MAD and (d) forecasted demand in month 8. Month Sales 1 1257 2. 2478 3 2500 4 3100 5 6 3055 7 2986 2. Prepare the aggregate plan using level strategy for the given data by completing Table 2. State if there is any concerns in the proposed plan. Table 1: 3125 Dec-2020 4000 6.5 Jan-2021 6000 Month Demand Productive hours/worker/day Paid straight hrs/day Feb-2021 5000 AED 150 AED 20/unit Materials required. 15 hrs/unit Holding costs per month AED 5/unit AED 2/unit Marginal cost of stock aut per mo 0 0 AED 2/unit Marginal cost of stock- out per mo. Labor required 0.5 hrs/unit Beginning inventory 300 units Pald straight hrs/day 8hours I Table 2: Days/mo Hrs/worker/mo Units/worker S/worker Demand Beg. Inv. Net reg. Workers Production Ending Inventory Surplus Shortage Material cost Labour cost Stockout cost Holding cost Total cost 3. Prepare MPS based on below table (B=300): Period 1 Forecast 1000 Customer orders 50 ATP MPS 2 2050 10 3 1470 100 120% Paragraph Bryles AbbceDete AaBbcode A AaBbCd AaBBCD Aa Bb AaBbc Normal Na Spating Heading 1 Heading 2 Tale Subtith Sul 12 Use Excel to solve the below problems. 1. Construct an exponential forecasting calculator to find (a) forecasted demand using exponential forecasting (b) forecasting error (c) MAD and (d) forecasted demand in month 8. Month Sales 1 1257 2. 2478 3 2500 4 3100 5 6 3055 7 2986 2. Prepare the aggregate plan using level strategy for the given data by completing Table 2. State if there is any concerns in the proposed plan. Table 1: 3125 Dec-2020 4000 6.5 Jan-2021 6000 Month Demand Productive hours/worker/day Paid straight hrs/day Feb-2021 5000 AED 150 AED 20/unit Materials required. 15 hrs/unit Holding costs per month AED 5/unit AED 2/unit Marginal cost of stock aut per mo 0 0 AED 2/unit Marginal cost of stock- out per mo. Labor required 0.5 hrs/unit Beginning inventory 300 units Pald straight hrs/day 8hours I Table 2: Days/mo Hrs/worker/mo Units/worker S/worker Demand Beg. Inv. Net reg. Workers Production Ending Inventory Surplus Shortage Material cost Labour cost Stockout cost Holding cost Total cost 3. Prepare MPS based on below table (B=300): Period 1 Forecast 1000 Customer orders 50 ATP MPS 2 2050 10 3 1470 100