Use data in worksheet Time Series Plot the data for each store Develop a sales forecast for each of the 10 stores for the month of December, using A three month moving average A 2 month weighted moving average, with weights of 0 7 on the most recent month and 0 3 on the older month Exponential smoothing with an alpha value of 0 25 Assume February forecast is Januarys actual Compute measures of forecast accuracy to recommend the best forecasting technique to use for the data Rank the 10 stores based on the forecasts you made with the technique that you determined (in the above step) to be the best forecasting method I NEED A 3 MOTH MOVING AVERAGE A 2 MONTH WEIGHTED MOVING AVERAGE EXPONENTIAL SMOOTHIN WITH ALPA VALUE 25 Store Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec A1 $11,801 75 $11,801 75 $9,766 96 $10,072 18 $8,647 83 $12,208 70 $9,665 22 $9,461 75 $10,479 14 $8,953 05 $9,054 79 A2 $7,076 54 $6,480 62 $6,033 68 $7,672 46 $7,300 01 $7,151 03 $6,853 07 $8,491 85 $7,746 95 $7,300 01 $7,300 01 A3 $19,992 55 $19,107 92 $16,277 12 $15,215 57 $15,392 49 $16,277 12 $19,107 92 $20,700 25 $18,046 37 $19,107 92 $15,038 64 A4 $13,929 10 $10,562 90 $9,750 37 $12,884 41 $9,402 14 $9,634 29 $12,071 88 $12,304 03 $10,446 82 $10,911 13 $13,464 79 A5 $36,436 19 $26,112 60 $28,845 32 $33,096 20 $28,238 05 $28,845 32 $27,327 14 $33,703 47 $36,132 55 $32,792 57 $31,578 03 A6 $14,428 95 $14,111 83 $13,794 71 $17,758 71 $17,917 27 $15,221 75 $12,684 79 $13,636 15 $13,794 71 $12,843 35 $17,917 27 A7 $17,056 90 $16,757 65 $16,907 27 $15,111 81 $16,009 54 $14,363 70 $16,308 79 $16,907 27 $14,513 32 $16,907 27 $16,009 54 A8 $15,277 15 $14,071 06 $12,060 91 $15,009 13 $13,669 03 $16,081 21 $11,926 90 $11,122 84 $15,545 17 $11,792 89 $10,854 82 A9 $2,629 69 $3,229 95 $3,315 70 $2,343 86 $2,486 77 $3,401 45 $3,058 45 $3,144 20 $2,886 94 $2,772 61 $3,287 11 A10 $30,525 84 $26,743 88 $31,336 26 $30,255 70 $27,554 30 $24,042 48 $31,066 12 $31,336 26 $27,284 16 $23,772 34 $23,772 34

The Answer is in the image, click to view ...

Question: Use data in worksheet Time Series. Plot the data for each store. Develop a sales forecast for each of the 10 stores for the month

Use data in worksheet Time Series. Plot the data for each store.
Develop a sales forecast for each of the 10 stores for the month of December, using:

A three month moving average
A 2- month weighted moving average, with weights of 0.7 on the most recent month and 0.3 on the older month.
Exponential smoothing with an alpha value of 0.25. Assume February forecast is Januarys actual.
Compute measures of forecast accuracy to recommend the best forecasting technique to use for the data.
Rank the 10 stores based on the forecasts you made with the technique that you determined (in the above step) to be the best forecasting method.

I NEED A 3 MOTH MOVING AVERAGE

A 2 MONTH WEIGHTED MOVING AVERAGE

EXPONENTIAL SMOOTHIN WITH ALPA VALUE .25

Store

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

$11,801.75

$9,766.96

$10,072.18

$8,647.83

$12,208.70

$9,665.22

$9,461.75

$10,479.14

$8,953.05

$9,054.79

$7,076.54

$6,480.62

$6,033.68

$7,672.46

$7,300.01

$7,151.03

$6,853.07

$8,491.85

$7,746.95

$7,300.01

$19,992.55

$19,107.92

$16,277.12

$15,215.57

$15,392.49

$16,277.12

$19,107.92

$20,700.25

$18,046.37

$19,107.92

$15,038.64

$13,929.10

$10,562.90

$9,750.37

$12,884.41

$9,402.14

$9,634.29

$12,071.88

$12,304.03

$10,446.82

$10,911.13

$13,464.79

$36,436.19

$26,112.60

$28,845.32

$33,096.20

$28,238.05

$28,845.32

$27,327.14

$33,703.47

$36,132.55

$32,792.57

$31,578.03

$14,428.95

$14,111.83

$13,794.71

$17,758.71

$17,917.27

$15,221.75

$12,684.79

$13,636.15

$13,794.71

$12,843.35

$17,917.27

$17,056.90

$16,757.65

$16,907.27

$15,111.81

$16,009.54

$14,363.70

$16,308.79

$16,907.27

$14,513.32

$16,907.27

$16,009.54

$15,277.15

$14,071.06

$12,060.91

$15,009.13

$13,669.03

$16,081.21

$11,926.90

$11,122.84

$15,545.17

$11,792.89

$10,854.82

$2,629.69

$3,229.95

$3,315.70

$2,343.86

$2,486.77

$3,401.45

$3,058.45

$3,144.20

$2,886.94

$2,772.61

$3,287.11

A10

$30,525.84

$26,743.88

$31,336.26

$30,255.70

$27,554.30

$24,042.48

$31,066.12

$31,336.26

$27,284.16

$23,772.34

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please answer this for me!! The part I need to know answers for and how to do (explain steps as much as you can please so I can remake it to learn) are parts D and E but think you need to do other...

Case Analysis: Grande Provence Estate - The Restaurant Grande Provence Estate - The Restaurant is on Grande Provence Heritage Wine Estate, a resort community in Franschhoek, Western Cape. The...

there is no information missing South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new york. Although the firm has been in business for only five...

Project 1B: Data Visualizations with NYC Real Estate Data Need Help - Please show step by step. Tableau - Froject 1.0 Part B_v2019.1 File Dats Worksheet Deshboard Story Analysis Mop Format Server...

2. 3. Corporate triple A bond interest rates for 12 consecutive months are as follows: 9.8 10.5 9.9 9.7 9.6 9.5 9.3 9.4 9.6 9.8 9.7 9.6 S. 6. (a) Choose the correct time series plot. Monthly Interest...

Problem 2.1: Forecasting monthly sales at the restaurant "Au Canard Truff" The restaurant "Au Canard Truff" opened over seven years ago in Sarlat, a town in the Prigord region in the South West of...

Problem 2.1 (35 marks): Forecasting monthly sales at the restaurant "Au Canard Truff" The restaurant "Au Canard Truff" opened over seven years ago in Sarlat, a town in the Prigord region in the South...

1 Use data in Worksheet Q1-9 to answer questions 1 to 9. The data is for a sample of dealerships and was collected for the second week of August 2016. Which variables are qualitative? A. New Car...

Q1 Q2 a) Construct a time series plot and use one sentence to describe what type of paller exists in the data? Atower Year Expense (%) 2003 139 2004 12.2 2005 2006 2007 Period (0) 1 2 3 4 s 6 7 10,5...

Calculating and interpreting profitability and risk ratios in a time-series setting Target Corporation, headquartered in the United States, operates retails chains under two store concepts: Target...

Calculate the missing amounts. Net sales Cost of goods sold Gross profit from sales Operating expenses Profit (loss) a $ 213,000 $ 168,000 $ 78,000 43,000 111,000 93,000 94,000 (30,000) (4,500) d...

California requires electronic payments if taxpayers either make an estimated tax or extension payment over $ 2 0 , 0 0 0 or file an original return with a tax liability over $ 8 0 , 0 0 0 ....

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...