Examples for business, study, careers, love, and more...
Examples :: Excel Templates :: Example of Moving Average Sales Forecast

Example of Moving Average Sales Forecast


Moving Average Sales Forecast Template


Year/Month Monthly Sales 3 Month Average 6 Month Average 1 Year Average Accumulative Sales Total
2010          
January 1,100.00       1,100.00
February 2,200.00       3,300.00
March 3,300.00       6,600.00
April 4,400.00 2,200.00     11,000.00
May 5,500.00 3,300.00     16,500.00
June 6,600.00 4,400.00     23,100.00
July 7,700.00 5,500.00 4,400.00   30,800.00
August 8,800.00 6,600.00 5,500.00   39,600.00
September 9,900.00 7,700.00 6,600.00   49,500.00
October 11,100.00 8,800.00 7,714.29   60,600.00
November 12,000.00 9,933.33 8,800.00   72,600.00
December 13,000.00 11,000.00 9,871.43   85,600.00
Monthly Totals 85,600.00       85,600.00
2011          
January 1,100.00 12,033.33 10,416.67 7,133.33 1,100.00
February 2,200.00 8,700.00 9,316.67 7,133.33 3,300.00
March 3,300.00 5,433.33 8,216.67 7,133.33 6,600.00
April 4,400.00 2,200.00 7,116.67 7,133.33 11,000.00
May 5,500.00 3,300.00 6,000.00 7,133.33 16,500.00
June 6,600.00 4,400.00 4,916.67 7,133.33 23,100.00
July 7,700.00 5,500.00 3,850.00 7,133.33 30,800.00
August 8,800.00 6,600.00 4,950.00 7,133.33 39,600.00
September 9,900.00 7,700.00 6,050.00 7,133.33 49,500.00
October 11,100.00 8,800.00 7,150.00 7,133.33 60,600.00
November 12,000.00 9,933.33 8,266.67 7,133.33 72,600.00
December 13,000.00 11,000.00 9,350.00 7,133.33 85,600.00
Monthly Totals 85,600.00 85,600.00 85,600.00 85,600.00 85,600.00



Notes on Moving Average Sales Forecast Example

This Moving Average Sales template calculates average sales based on past monthly sales.
Averages are calculated based on 3,6 and 12 months sales information.
To calculate averages, fill in the Monthly Sales Column.

Disclaimer: Examplesof.com makes every effort to ensure the functional integrity of all downloadable materials posted on the site. The information, methodologies and processes contained in these materials are provided according to built-in software and formulas. We are unable to guarantee that these materials will necessarily be suitable for individual purposes. We are unable to guarantee that these materials will necessarily be free of functional issues which may affect their performance. Important: These materials are offered for purchase and use in good faith in "as is" condition. Full disclaimer is here disclaimer

Limited Use Policy : These templates provided by ExamplesOf.com, may be downloaded and customized for your personal or company use only. You may download copies, make archival copies and customize the template to be distributed and used within your company. This template or any document produced from this template may NOT be sold, redistributed, or uploaded to the internet for distribution.EULA

Download Excel Version of Moving Average Sales Forecast Example
Download Example Moving Average Sales Forecast Excel Template