Forecast 2

Forecast 2 - 9 877 783.85 93.15 10 693 811.80-118.80 11 841...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Year Demand 1 518 2 651 3 708 4 921 5 775 6 810 7 856 8 792 9 877 10 693 11 841 12 1009 13 902 14 1103 0 2 4 0 200 400 600 800 1000 1200 f(x) = 26.91x + R² = 0.57
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 6 8 10 12 14 16 + 616.49 Demand Demand Linear Regression for Demand
Background image of page 2
Year Demand 3 Period Moving Average Forecast Error Absolute Error 1 518 2 651 3 708 4 921 625.67 295.33 295.33 5 775 760.00 15.00 15.00 6 810 801.33 8.67 8.67 7 856 835.33 20.67 20.67 8 792 813.67 -21.67 21.67 9 877 819.33 57.67 57.67 10 693 841.67 -148.67 148.67 11 841 787.33 53.67 53.67 12 1009 803.67 205.33 205.33 13 902 847.67 54.33 54.33 14 1103 917.33 185.67 185.67 Forecast 1004.67 MAD 96.97
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
5-Period Moving Average Forecast Error Absolute Error 714.60 95.40 95.40 773.00 83.00 83.00 814.00 -22.00 22.00 830.80 46.20 46.20 822.00 -129.00 129.00 805.60 35.40 35.40 811.80 197.20 197.20 842.40 59.60 59.60 864.40 238.60 238.60 909.60 100.71
Background image of page 4
Year Demand Error 1 518 2 651 518.00 133.00 3 708 557.90 150.10 4 921 602.93 318.07 5 775 698.35 76.65 6 810 721.35 88.65 7 856 747.94 108.06 8 792 780.36 11.64
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 9 877 783.85 93.15 10 693 811.80-118.80 11 841 776.16 64.84 12 1009 795.61 213.39 13 902 859.63 42.37 14 1103 872.34 230.66 Forecast 941.54 MAD Exponentially Smoothed Moving Average Forecast, =0.30 Absolute Error 133.00 150.10 318.07 76.65 88.65 108.06 11.64 93.15 118.80 64.84 213.39 42.37 230.66 126.88 Year Demand Weighted Moving Average Forecast Error Absolute Error 1 518 2 651 3 708 4 921 587.8 333.2 333.2 5 775 732.3 42.7 42.7 6 810 713.3 96.7 96.7 7 856 744.2 111.8 111.8 8 792 745 47 47 9 877 729.2 147.8 147.8 10 693 768.1-75.1 75.1 11 841 680.3 160.7 160.7 12 1009 734.5 274.5 274.5 13 902 811.3 90.7 90.7 14 1103 821 282 282 Forecast 933.7 MAD 151.11...
View Full Document

Page1 / 7

Forecast 2 - 9 877 783.85 93.15 10 693 811.80-118.80 11 841...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online