TABLE 6–11 Actual Sales Data Solution to Problem 6 W1 = 3 W2 = 5 W3 = 9 Actual Sales Forecast Weighted Moving Average Absolute Time Period ($00) Deviation 445 478 525 660 570 600 632 648 690 725 1 2 162.94 18.18 11.47 30.24 4. 497.06 588.18 588.53 601.76 611.65 634.82 667.41 701.12 732.06 36.35 55.18 10 11 12 57.59 48.88 750 Sum 420.82 in MAD = 52.60

Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter6: Applications Of The Derivative
Section6.CR: Chapter 6 Review
Problem 33CR
icon
Related questions
Question

Using the data in Table 6–11, calculate a 3-month moving average forecast
for month 12.

TABLE 6–11 Actual Sales Data
Solution to Problem 6
W1 = 3
W2 = 5
W3 = 9
Actual Sales
Forecast Weighted
Moving Average
Absolute
Time Period
($00)
Deviation
445
478
525
660
570
600
632
648
690
725
1
2
162.94
18.18
11.47
30.24
4.
497.06
588.18
588.53
601.76
611.65
634.82
667.41
701.12
732.06
36.35
55.18
10
11
12
57.59
48.88
750
Sum
420.82
in
MAD =
52.60
Transcribed Image Text:TABLE 6–11 Actual Sales Data Solution to Problem 6 W1 = 3 W2 = 5 W3 = 9 Actual Sales Forecast Weighted Moving Average Absolute Time Period ($00) Deviation 445 478 525 660 570 600 632 648 690 725 1 2 162.94 18.18 11.47 30.24 4. 497.06 588.18 588.53 601.76 611.65 634.82 667.41 701.12 732.06 36.35 55.18 10 11 12 57.59 48.88 750 Sum 420.82 in MAD = 52.60
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Time Series Analyses, Forecasting Methods, and Indices
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill