Operation Management – Forecasting Question

Please use excel and let me know about the formulas used. Thank you!!!!
Sales data for two years are as follows. Data are aggregated with two months of sales in each "period."
MONTHS SALES MONTHS SALES January"??February 101 January"??February 114 March"??April 102 March"??April 111 May"??June 149 May"??June 158 July"??August 171 July"??August 170 September"??October 125 September"??October 118 November"??December 99 November"??December 107
a.
Plot the data. Instructions: 1. Use the line tool (Sales) to draw the sales for each period. 2. To earn full credit for this graph you must plot all required points, beginning with the first unit. 3. To enter exact coordinates, double click on the point and enter the values of x and y.
b.
Fit a simple linear regression model to the sales data. (Round your answers to 3 decimal places.)
Y = + t
c-1.
In addition to the regression model, determine multiplicative seasonal index factors. A full cycle is assumed to be a full year. (Round your answers to 3 decimal places.)
Months Seasonal Index January"??February March"??April May"??June July"??August September"??October November"??December
c-2.
Fit a regression model to the deseasonalized sales data. (Round your answers to 3 decimal places.)
Y = + t
d.
Using the results from parts b and c, prepare a forecast for the next year. (Round your answers to 3 decimal places.)
Months Regression Forecast Without Seasonality Considerations Seasonal
Forecast January"??February March"??April May"??June July"??August September"??October November"??December
The post Operation Management – Forecasting Question appeared first on Class Assignments Help.
Operation Management – Forecasting Question was first posted on October 12, 2022 at 11:26 am.©2019 "Class Assignments Help". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at [email protected]