Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Turner industries have collected sales data over past few years (as provided in table below). Past sales data: Sales Unit Sales Unit Sales Unit Year
Turner industries have collected sales data over past few years (as provided in table below). Past sales data: Sales Unit Sales Unit Sales Unit Year Quarter (mil $) Price Year Quarter (mil $) Price Year Quarter (mil $) Price 1 1 108 6.25 2 1 1 16 6.75 3 1 123 6.25 2 125 5.5 2 134 6.25 2 142 6.25 3 150 6.75 3 159 7.25 3 168 7.25 4 141 7.5 4 152 7.75 4 165 7 You are being asked to help forecast and think about errors in forecasting. You have carried out some analysis with 3MA, exponential smoothing (alpha = 0.4), trend, and trend and seasonality additive models. Coefficients Coefficients Intercept 117.5 Intercept 134.17 Time (t) 3.5 Time (t) 2.3125 Q1 -30.063 02 -14.375 03 8.6458 Turner industries have collected sales data over past few years (as provided in the image attached). You are tasked to help the manager in forecasting the sales for future. In the partially filled table below fill in the blanks (round up to two decimals).In the partially filled table below fill in the blanks (round up to two decimals). Your Quarter Time (0) Sales 3MA Trend Exp alpha(0.4) SE APE Seasonally adjusted Trend SE APE [additive) 3 3 11 168 138.73 12 165 MSE: 201 375 MAPE MSE: 1.98 MAPE 8.963 0.75 13 158.33 156.27 1 2 14 165 3 15 56.26 4 What suggestions would you give to your manager
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started