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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditing Assurance Services and Ethics in Australia an Integrated Approach
Authors: Alvin A Arens, Peter J. Best, Greg Shailer, Brenton Fiedler
9th edition
978-1442539365, 1442539364
