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 parts to get the data I don't know how to copy charts and stuff on here sorry Please help me really appreciate it 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) A three month moving average b) A 2 month weighted moving average, with weights of 0 7 on the most recent month and 0 3 on the older month (Robert) c) Exponential smoothing with an alpha value of 0 25 Assume February forecast is January's actual (Robert) d) Compute measures of forecast accuracy to recommend the best forecasting technique to use for the data e) 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 Store Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec A1 $1,996 42 $2,453 43 $2,453 43 $2,693 96 $2,188 84 $2,116 68 $2,886 38 $1,996 42 $2,092 63 $2,838 28 $2,164 79 A2 $6,558 32 $9,181 65 $6,558 32 $9,755 50 $9,263 63 $6,640 30 $7,132 17 $8,197 90 $8,361 86 $7,788 01 $8,197 90 A3 $32,681 64 $34,438 72 $37,952 87 $34,087 30 $30,221 73 $38,304 29 $40,412 78 $33,384 47 $28,113 24 $38,655 71 $40,764 20 A4 $12,277 80 $8,968 13 $9,181 66 $10,249 30 $8,754 61 $10,569 59 $12,064 28 $12,277 80 $11,530 46 $11,423 69 $11,743 99 A5 $11,402 10 $11,526 04 $14,252 63 $11,030 30 $12,641 46 $11,526 04 $14,748 37 $12,641 46 $11,897 85 $11,773 91 $14,128 69 A6 $90 04 $96 34 $75 63 $80 14 $95 44 $103 55 $92 74 $91 84 $102 65 $96 34 $91 84 A7 $3,839 15 $4,223 07 $3,263 28 $3,608 80 $4,568 59 $3,762 37 $3,877 54 $4,491 81 $4,261 46 $3,992 72 $3,109 71 A8 $9,951 27 $8,732 75 $9,342 01 $8,428 12 $8,326 58 $10,255 90 $8,834 29 $10,154 36 $10,458 99 $10,052 82 $10,357 45 A9 $14,228 78 $16,548 68 $14,692 76 $13,919 45 $14,228 78 $13,764 79 $18,249 95 $16,394 02 $12,372 85 $16,239 36 $14,383 44 A10 $17,199 79 $16,829 90 $17,939 57 $17,014 85 $19,234 18 $16,275 07 $22,008 34 $19,419 12 $20,158 90 $21,453 50 $16,644 96

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

Question: 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

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 parts to get the data. I don't know how to copy charts and stuff on here sorry. Please help me really appreciate it.

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) A three month moving average

b) A 2- month weighted moving average, with weights of 0.7 on the most recent month and 0.3 on the older month.(Robert)

c) Exponential smoothing with an alpha value of 0.25. Assume February forecast is January's actual.(Robert)

d) Compute measures of forecast accuracy to recommend the best forecasting technique to use for the data.

e) 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.

Store	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
A1	$1,996.42	$2,453.43	$2,453.43	$2,693.96	$2,188.84	$2,116.68	$2,886.38	$1,996.42	$2,092.63	$2,838.28	$2,164.79	?
A2	$6,558.32	$9,181.65	$6,558.32	$9,755.50	$9,263.63	$6,640.30	$7,132.17	$8,197.90	$8,361.86	$7,788.01	$8,197.90	?
A3	$32,681.64	$34,438.72	$37,952.87	$34,087.30	$30,221.73	$38,304.29	$40,412.78	$33,384.47	$28,113.24	$38,655.71	$40,764.20	?
A4	$12,277.80	$8,968.13	$9,181.66	$10,249.30	$8,754.61	$10,569.59	$12,064.28	$12,277.80	$11,530.46	$11,423.69	$11,743.99	?
A5	$11,402.10	$11,526.04	$14,252.63	$11,030.30	$12,641.46	$11,526.04	$14,748.37	$12,641.46	$11,897.85	$11,773.91	$14,128.69	?
A6	$90.04	$96.34	$75.63	$80.14	$95.44	$103.55	$92.74	$91.84	$102.65	$96.34	$91.84	?
A7	$3,839.15	$4,223.07	$3,263.28	$3,608.80	$4,568.59	$3,762.37	$3,877.54	$4,491.81	$4,261.46	$3,992.72	$3,109.71	?
A8	$9,951.27	$8,732.75	$9,342.01	$8,428.12	$8,326.58	$10,255.90	$8,834.29	$10,154.36	$10,458.99	$10,052.82	$10,357.45	?
A9	$14,228.78	$16,548.68	$14,692.76	$13,919.45	$14,228.78	$13,764.79	$18,249.95	$16,394.02	$12,372.85	$16,239.36	$14,383.44	?
A10	$17,199.79	$16,829.90	$17,939.57	$17,014.85	$19,234.18	$16,275.07	$22,008.34	$19,419.12	$20,158.90	$21,453.50	$16,644.96	?

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 Accounting 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...

please answer Question 3: Coding is part of the data analysis phase in a quantitative study, as we learned in Chapter 13. Coding open-ended responses requires a special approach and unique steps in...

Change from FiFo to UFO In its 2008 financial statements, Seneca foods Corporation reported a change in its inventory method from first-in, first-out (FiFO) to last-in, first-out (UFO). This change...

Answer the question. Part I: Estimate the Value of a College Education. Before we calculate the value of a college education, let's make an estimate. Don't use the chart in the article, think how you...

Please answer question with Microsoft Access ISBN:13-978-0-13-697127-6 1. Please write the answers for the questions. You can use the Internet to research and find answers. It can be assumed that we...

Please answer in at least 2 paragraphs 4. Using the material in "Beyond Hedging," please explain why the London Metals Exchange (LME) developed the North American Special Alloy (Scrap) Aluminum...

The following information relates to three of Montreal's Top and Exclusive private training fitness studios in Downtown. Salim's Fitness, Kardiac and Golden gym For each Fitness Studio calculate the...

please answer the task 10 of part 4 cost and quality management as per the following requirements please give the correct answer ASAP IT project management IT project management subject it an health...

can someone please answer the 2 questions on tne bottom. i already know the calculations. AGAIN I DO NOT NEED THE NUMBERS. i just need the answers to fhe 2 questions on the bottom which is the...

Question 1: After completing MMK365, you are hired to help with data analysis work in a Marketing Insights firm. From the following issues you are asked to identify the ones that can be solved by...

Price level (GDP deflator, 2012100) 113 110 107 100 LAS, Increase in potential GDP brings expansion.... A 17.0 SAS AD greater increase in AD brings inflation... 18.0 LAS, AD 19.5 20.0 20.5 21.0 SAS,...

For companies engaged in direct financing leases (ASPE) or finance leases(IFRS), A.their profits are derived from leasing their inventory at a profit. B.they are generally manufacturers or retail...

In a pure Activity Based Costing system, which of the following would not be assigned to products? A Batch level activities. B Facility level activities. C Process level activities. D groduct level...

The stage in shich multi nstionals set up foreign subsidiaries to hsnlfe sales in one country is the _ _ _ _ _ in developing s global buisness In 2 0 2 0 which companies were considered the bif fivd...

3.63 Consider two groups of students: B1, students who received high scores on tests, and B2, students who received low scores on tests. In group B1, 20% study more than 25 hours per week, and in...

3.62 Consider two groups of students: B1, students who received high scores on tests, and B2, students who received low scores on tests. In group B1, 40% study more than 25 hours per week, and in...

3.61 Consider two groups of students: B1, students who received high scores on tests, and B2, students who received low scores on tests. In group B1, 80% study more than 25 hours per week, and in...