Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Any help is appreciated The following are sales data for 20 periods of a firm and three different forecast methods and associated information. The three

Any help is appreciated

image text in transcribedimage text in transcribed
The following are sales data for 20 periods of a firm and three different forecast methods and associated information. The three method are unknown and are called M1, M2, and M3 respectively. A B C D E F G H J K Forecast M1 Forecast M2 Forecast V13 Time Sales ErrorM1 Error M2 Error M3 44.8 44.8 0 44.8 14 2 58.1 44.8 13.36 58.32 13.76 58.8 -0.69 0.69 3 58.4 48.8 9.62 62.49 8.97 72.08 -13.69 13.69 4 97.7 53.75 43.97 51.6 46.07 89.84 18.16 71.46 26.26 26.26 UT 129.5 71.4 58.13 65.5 64.07 123.07 25.7 BOL 21.54 21.54 110.5 95.21 15.25 34.7 25.77 121.95 12.29 148.77 -38.31 38.31 142.9 112.57 30.31 92.4 50.46 140.29 15.31 134.24 8.64 8.64 8 146.4 127.63 18.73 107.6 38.8 149.13 12.08 155.6 -9.25 9.25 9 174 133.23 40.79 119.2 54.83 170.18 16.56 161.21 12.82 12.82 10 174.6 154.42 20.13 135.6 38.91 178.21 12.3 186.75 -12.19 12.19 11 187.9 164.98 22.88 147.3 40.54 188.65 11.37 190.51 -2.65 2.65 12 201.2 178.81 22.42 159.5 41.76 200.87 11.79 200.02 1.21 1.21 13 204.8 187.88 16.88 172 32.76 207.14 9.03 212.67 -7.9 7.9 14 233.5 197.95 35.54 181.8 51.66 228.3 15.09 216.17 17.33 17.33 15 228.3 213.17 15.1 197.3 30.93 232.8 9.8 243.39 -15.13 15.13 16 246 222.18 23.82 206.6 39.38 244.98 10.99 242.6 3.39 3.39 17 266 235.92 30.08 218.4 47.57 262.99 14.5 255.96 10.03 10.03 18 280.8 246.75 34.01 232.7 48.07 279.78 15.65 277.49 3.28 3.28 19 289.9 264.25 25.68 247.1 42.82 291.58 13.72 295.43 -5.49 5.49 20 288 278.9 9.14 260 28.08 293.22 7.68 305.31 -17.26 17.26 21 286.25 268.4 300.91 27.23 37.76 -0.95 11.95 Method 2 is likely to be? [Press CTRL and "-" to see the whole table by reducing the font size. Press CTRL and "+" to restore the font size]Select one: 0 a. A Simple Exponential Smoothing model with alpha : 0.3 O b. An Adaptive Response Rate Exponential Smoothing (ARRSES) model 0 c. A 4 period Moving Average 0 d. A Simple Exponential Smoothing model with alpha : 0.2 0 e. A 3 period Moving Average

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

Cornerstones Of Financial Accounting

Authors: Jay Rich, Jeff Jones

3rd Edition

1285424409, 978-1285423678

More Books

Students also viewed these Accounting questions

Question

Go, do not wait until I come

Answered: 1 week ago

Question

Make eye contact when talking and listening

Answered: 1 week ago

Question

Do not go, wait until I come

Answered: 1 week ago