Loading...

Excel Question

Open Posted By: ahmad8858 Date: 16/10/2020 High School Dissertation & Thesis Writing

details enclosed in attachment

Category: Mathematics & Physics Subjects: Algebra Deadline: 12 Hours Budget: $100 - $150 Pages: 2-3 Pages (Short Assignment)

Attachment 1

2 weeks of sales data

Sales Data 0.2 0.4
Week Sales ($1,000) Naïve MA (3) MA(5) WMA EXPO (a=0.2) EXPO (a=0.4)
1 17
2 19 17 17.00 17.00
3 18 19 17.40 17.80
4 15 18 18.00 17.52 17.88
5 20 15 17.33 16.30 17.02 16.73
6 18 20 17.67 17.80 18.65 17.61 18.04
7 21 18 17.67 18.00 17.95 17.69 18.02
8 22 21 19.67 18.40 19.95 18.35 19.21
9 20 22 20.33 19.20 21.10 19.08 20.33
10 19 20 21.00 20.20 20.45 19.27 20.20
11 18 19 20.33 20.00 19.75 19.21 19.72
12 20 18 19.00 20.00 18.70 18.97 19.03
13 22 20 19.00 19.80 19.45 19.18 19.42
14 18 22 20.00 19.80 20.85 19.74 20.45
15 18 20.00 19.4 19.10 19.39 19.47
Weights
n-3 5%
n-2 15%
n-1 20%
n 60%
Total 100%

Sales Data

Sales ($1,000) 17 19 18 15 20 18 21 22 20 19 18 20 22 18 Naïve 17 19 18 15 20 18 21 22 20 19 18 20 22 18 MA (3) 18 17.333333333333332 17.666666666666668 17.666666666666668 19.666666666666668 20.333333333333332 21 20.333333333333332 19 19 20 20 MA(5) 17.8 18 18.399999999999999 19.2 20.2 20 20 19.8 19.8 19.399999999999999 WMA 16.3 18.649999999999999 17.95 19.95 21.1 20.45 19.75 18.7 19.45 20.85 19.100000000000001 EXPO (a=0.2) 17 17.399999999999999 17.52 17.015999999999998 17.6128 17.690239999999999 18.352191999999999 19.081753599999999 19.26540288 19.212322304000001 18.9698578432 19.17588627456 19.740709019648001 19.392567215718401 EXPO (a=0.4) 17 17.8 17.88 16.727999999999998 18.036799999999999 18.022079999999999 19.213248 20.327948800000001 20.196769280000002 19.718061568 19.0308369408 19.41850216448 20.451101298687998 19.4706607792128