Scribd
Upload
14 views1 page

Demand Forecasting Template Data

The document presents a monthly demand forecast with actual values, moving averages, and exponential smoothing errors for each month from January to December. It includes calculations for moving averages and Mean Absolute Deviation (MAD) with an alpha of 0.1. The data shows a trend of increasing demand over the year.

Uploaded by

pushpeshsharma31
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
14 views1 page

Demand Forecasting Template Data

The document presents a monthly demand forecast with actual values, moving averages, and exponential smoothing errors for each month from January to December. It includes calculations for moving averages and Mean Absolute Deviation (MAD) with an alpha of 0.1. The data shows a trend of increasing demand over the year.

Uploaded by

pushpeshsharma31
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Time Period

Actual
Moving
Demand
Exponential
Average (3 Smoothing
periods) Error
(alpha=0.1)
(MAD)
Jan 100 100 0
Feb 110 101 9
Mar 105 105 101.4 3.6
Apr 120 111.6667 103.26 16.74
May 130 118.3333 105.934 24.066
Jun 125 125 107.8406 17.1594
Jul 135 130 110.5565 24.44346
Aug 140 133.3333 113.5009 26.49911
Sep 150 141.6667 117.1508 32.8492
Oct 160 150 121.4357 38.56428
Nov 170 160 126.2921 43.70785
Dec 180 170 131.6629 48.33707

You might also like