Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Probability Models

Authors: Sheldon M Ross

12th Edition

0128143460, 9780128143469

More Books

Students also viewed these Mathematics questions

Question

=+a) What time series components do you observe in this series?

Answered: 1 week ago

Question

8. How can an interpreter influence the message?

Answered: 1 week ago