Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello I need help please show all In excel thanks Case: Fields Inc. Case Consider Fields sales data included, it's a time series data on

Hello I need help please show all In excel thanks
image text in transcribed
image text in transcribed
image text in transcribed
Case: Fields Inc. Case Consider Fields sales data included, it's a time series data on quarterly sales values (in $1,000's) of Fields, Inc. for the last 16 years. Suppose we are interested in forecasting next four quarters' sales, please conduct the following procedures: (1). Plot the TS data (use either Excel or Minitab), and identify any patterns embedded; (2). Use Winters' trend and seasonally adjusted exponential smoothing model to predict the sales values, in so doing, use initial values of: Lo=50147, To=0, S.3=0.84073, S-2=0.85307, S.1=0.99135, So=1.31486, and parameters of a 0.3, B=0.1 and y=0.1 (3). Establish a multiple linear regression model for modeling the seasonality and trend patterns identified (using the 4th quarter as the reference season), write down your model estimate. (4). Compare results of two models constructed above, based on criteria of MSE, which model you consider is the best in fitting the data given. Using the best model you identified, provide an overlay plot of observed Fields sales values vs. predicted sales values. (5). Provide a table which contains your forecast of sales for future four quarters (for Year 17th). Year Quarter Quarter 14 16 Time Sales 50147 49325 57948 76781 48617 50898 58517 77691 50862 53028 58849 79660 51640 54119 65681 85175 17 56405 60031 71486 92183 60800 22 64900 23 76997 24103337 25 67279 26 69869 27 81029 28 107192 29 69110 30 76084 31 87160 32 113829 33 73567 79360 97324 136036 37 78071 18 OWNE WNWNWNIONWNWN CONN 2 7 8 35 Sheet 24299 Mignment 00 3 4 C 13 52 54 55 7 57 - 2 1 1 3 4 2 3 4 1 43 96724 44 140586 45 97015 46 103137 47 114402 48 152135 49 101984 50108562 51 121749 52 160499 53 108152 54 114499 55 127292 56 171965 57 115673 58 125995 59 136255 60 169677 61 111905 62 127872 63 145367 64 188635 15 Case: Fields Inc. Case Consider Fields sales data included, it's a time series data on quarterly sales values (in $1,000's) of Fields, Inc. for the last 16 years. Suppose we are interested in forecasting next four quarters' sales, please conduct the following procedures: (1). Plot the TS data (use either Excel or Minitab), and identify any patterns embedded; (2). Use Winters' trend and seasonally adjusted exponential smoothing model to predict the sales values, in so doing, use initial values of: Lo=50147, To=0, S.3=0.84073, S-2=0.85307, S.1=0.99135, So=1.31486, and parameters of a 0.3, B=0.1 and y=0.1 (3). Establish a multiple linear regression model for modeling the seasonality and trend patterns identified (using the 4th quarter as the reference season), write down your model estimate. (4). Compare results of two models constructed above, based on criteria of MSE, which model you consider is the best in fitting the data given. Using the best model you identified, provide an overlay plot of observed Fields sales values vs. predicted sales values. (5). Provide a table which contains your forecast of sales for future four quarters (for Year 17th). Year Quarter Quarter 14 16 Time Sales 50147 49325 57948 76781 48617 50898 58517 77691 50862 53028 58849 79660 51640 54119 65681 85175 17 56405 60031 71486 92183 60800 22 64900 23 76997 24103337 25 67279 26 69869 27 81029 28 107192 29 69110 30 76084 31 87160 32 113829 33 73567 79360 97324 136036 37 78071 18 OWNE WNWNWNIONWNWN CONN 2 7 8 35 Sheet 24299 Mignment 00 3 4 C 13 52 54 55 7 57 - 2 1 1 3 4 2 3 4 1 43 96724 44 140586 45 97015 46 103137 47 114402 48 152135 49 101984 50108562 51 121749 52 160499 53 108152 54 114499 55 127292 56 171965 57 115673 58 125995 59 136255 60 169677 61 111905 62 127872 63 145367 64 188635 15

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

Analysis For Financial Management

Authors: Robert Higgins

6th Edition

0071181172, 9780071181174

More Books

Students also viewed these Finance questions

Question

Move forward 4 seconds.

Answered: 1 week ago

Question

What are the main differences between rigid and flexible pavements?

Answered: 1 week ago

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago