(b) A Business entity has gone global with its Operations. The entity realizes that there is...

 

Transcribed Image Text:

(b) A Business entity has gone global with its Operations. The entity realizes that there is Seasonal Demand Variations (SDV) on its competitive Product for each year. The Company seeks assistance from you as an Operations Forecasting Manager on how best to deal with the SDV with the following historical performance data; Month Jar February March April May June July August September October November December THREE YEAR PRODUCT DEMAND Year 1 8,000 7,000 8,000 9,000 13,300 11,100 10,000 8,800 8,500 7,700 7,500 8,200 Year 2 8,500 8,500 9,300 9,500 V -12,500 11,500 10,200 10,200 9,000 7,800 8,200 7,800 Year 3 10,500 8,500 8,200 11,500 13,100 12,000 11,300 11,000 9,500 8,500 8,300 8,000 ) (1) Calculate the Seasonal Index for each month [5 Marks] (ii) With the Monthly Seasonal Indexes (MSI) calculated in (i), Determine the Seasonal Forecast for Year Four (4) and plot the graph of Demand-Forecast Seasonal Trends for the Four (4) years [5 Marks] (b) A Business entity has gone global with its Operations. The entity realizes that there is Seasonal Demand Variations (SDV) on its competitive Product for each year. The Company seeks assistance from you as an Operations Forecasting Manager on how best to deal with the SDV with the following historical performance data; Month Jar February March April May June July August September October November December THREE YEAR PRODUCT DEMAND Year 1 8,000 7,000 8,000 9,000 13,300 11,100 10,000 8,800 8,500 7,700 7,500 8,200 Year 2 8,500 8,500 9,300 9,500 V -12,500 11,500 10,200 10,200 9,000 7,800 8,200 7,800 Year 3 10,500 8,500 8,200 11,500 13,100 12,000 11,300 11,000 9,500 8,500 8,300 8,000 ) (1) Calculate the Seasonal Index for each month [5 Marks] (ii) With the Monthly Seasonal Indexes (MSI) calculated in (i), Determine the Seasonal Forecast for Year Four (4) and plot the graph of Demand-Forecast Seasonal Trends for the Four (4) years [5 Marks]