KOOL Foods is a Bottled water company that is in operations since 2012. It is supplying 19L bottled water to various households and offices in the city. Operation Manager at KOOL foods done forecasting on the exponential smoothing method the results are as under

Now your task is to bulid an aggregate plan based on that forecast. justify the strategy opt out of chase strategy, level scheduling, Mixed strategy and use the right technique and justify for developing aggregate plan out of graphical techniques, mathematical approaches.

For Costs you can consider them randomly. i.e you can assign random values

Month Demand May 584 June 610 July 655 Aug 747 Sept 862 Oct 913 Nov 963 Here the forecast is made from the second period, that is the month of June. Djune = 610 ; Forecast for June is taken as Demand for May; Fjune = Dmay = 584 ; n = 5 for December month forecast a = 2/5+1 = 0.33 Fjuly = a x Djune + (1 - a)x Fjune = (0.33 x 610 ) + (0.67 x 584) = 592.58 Faug = 0.33 x Djuly + 0.67 x Fjuly = 0.33 x 655 +0.67 x 592.58 = 613.18 Fsept = 0.33 x 747 +0.67 x 613.18 = 657.34 Foct = 0.33 x 862 +0.67 x 657.34 = 724.57 Fnov = 0.33 x 913 + 0.67 x 724.57 = 786.75 Finally, Fdec = 0.33 x 963 + 0.67 x 786.75 = 844.91 ~ 845 Therefore, Forecast for month of December is 845 Month Demand May 584 June 610 July 655 Aug 747 Sept 862 Oct 913 Nov 963 Here the forecast is made from the second period, that is the month of June. Djune = 610 ; Forecast for June is taken as Demand for May; Fjune = Dmay = 584 ; n = 5 for December month forecast a = 2/5+1 = 0.33 Fjuly = a x Djune + (1 - a)x Fjune = (0.33 x 610 ) + (0.67 x 584) = 592.58 Faug = 0.33 x Djuly + 0.67 x Fjuly = 0.33 x 655 +0.67 x 592.58 = 613.18 Fsept = 0.33 x 747 +0.67 x 613.18 = 657.34 Foct = 0.33 x 862 +0.67 x 657.34 = 724.57 Fnov = 0.33 x 913 + 0.67 x 724.57 = 786.75 Finally, Fdec = 0.33 x 963 + 0.67 x 786.75 = 844.91 ~ 845 Therefore, Forecast for month of December is 845