Q3: Seasonality Analysis: Demand Month 2020 2021 January 1150 1250 2022 2023 1270 1120 February 1250...

Transcribed Image Text:

Q3: Seasonality Analysis: Demand Month 2020 2021 January 1150 1250 2022 2023 1270 1120 February 1250 1400 1550 1350 March 1150 1200 1300 1370 April 1400 1450 1500 1105 May 1110 1250 1600 1350 June 1300 1500 1450 1270 July 2510 2950 2870 2650 August 2950 3800 3060 3115 September 2300 2900 3500 2700 October 1100 1500 1400 1450 November 1430 1700 1750 1550 December 1350 1900 1750 1470 Total 19,000 22,800 23,000 20,500 Given the following table that reflects the monthly demand for the Sea Ranch Pizza sold per month at PRIMO's branches. You have (3 Marks) been asked to create a seasonality index analysis to forecast the monthly sales using the results of the Exponential Smoothing Forecasts you got in your analysis for Question 2 for the year 2024. Q3: Seasonality Analysis: Demand Month 2020 2021 January 1150 1250 2022 2023 1270 1120 February 1250 1400 1550 1350 March 1150 1200 1300 1370 April 1400 1450 1500 1105 May 1110 1250 1600 1350 June 1300 1500 1450 1270 July 2510 2950 2870 2650 August 2950 3800 3060 3115 September 2300 2900 3500 2700 October 1100 1500 1400 1450 November 1430 1700 1750 1550 December 1350 1900 1750 1470 Total 19,000 22,800 23,000 20,500 Given the following table that reflects the monthly demand for the Sea Ranch Pizza sold per month at PRIMO's branches. You have (3 Marks) been asked to create a seasonality index analysis to forecast the monthly sales using the results of the Exponential Smoothing Forecasts you got in your analysis for Question 2 for the year 2024.