Example Of Essay On Sales Forecasting And Budgeting

Type of paper: Essay

Topic: Business, Sales, Forecast, Information, Factor, Sum, Weight

Pages: 1

Words: 275

Published: 2021/02/02

Simple moving average.

In this method data for all the previous years is used with an equal weight of one assigned to each of the data. The summation of the weights for all the years will therefore be 10. The 2010 sales estimate using this method will therefore be:
2010 forecast=900+1400+1750+1900+1700+1500+2000+1950+2250+230010=1765010=1765

The 2010 sales estimate is 1765

Thus the sales forecast for year 2010 using this method is 1765.
3-Year weighted average.
The sum of the weights = 3+2+1 = 6.

Thus using this method the 2010 sales estimate:

2010 forecast=2300×3+2250×2+1950×16=2225

The 2010 sales estimate is 2225.

5- Year weighted average.
The sum of the weights = 5+4+3+2+1 = 15
2010 sales estimate by this method is calculated as
2010 forecast=2300×5+2250×4+1950×3+2000×2+1500×115=2123.33

Thus the 2010 sales estimate using this method is 2123.

3-year exponentially smoothed weighted average.
In this method a smoothing factor α is used to exponentially reduce the data for years 2009,2008 and 2007. If the smoothing factors are taken to be o.3, o.25, 0.2 for years 2009,2008 and 2009 respectively, the 2010 sales estimate can be calculated as follows;
2010 forecast=2300×0.3+0.25×2250+0.2×1950=1642.5

5-year exponentially smoothed weighted average.

In exponential smoothing the data of the previous years is reduced exponentially by some factor. In this case the factors used are o.1, o.15, 0.2, 0.25, and 0.3 with the highest weight given to the latest data.
2010 Forecast=2300×0.3+0.25×2250+0.2×1950+0.15×2000+0.1×1500=2092.5
Most Accurate forecasting method

Cite this page
Choose cite format:
  • APA
  • MLA
  • Harvard
  • Vancouver
  • Chicago
  • ASA
  • IEEE
  • AMA
WePapers. (2021, February, 02) Example Of Essay On Sales Forecasting And Budgeting. Retrieved March 07, 2021, from https://www.wepapers.com/samples/example-of-essay-on-sales-forecasting-and-budgeting/
"Example Of Essay On Sales Forecasting And Budgeting." WePapers, 02 Feb. 2021, https://www.wepapers.com/samples/example-of-essay-on-sales-forecasting-and-budgeting/. Accessed 07 March 2021.
WePapers. 2021. Example Of Essay On Sales Forecasting And Budgeting., viewed March 07 2021, <https://www.wepapers.com/samples/example-of-essay-on-sales-forecasting-and-budgeting/>
WePapers. Example Of Essay On Sales Forecasting And Budgeting. [Internet]. February 2021. [Accessed March 07, 2021]. Available from: https://www.wepapers.com/samples/example-of-essay-on-sales-forecasting-and-budgeting/
"Example Of Essay On Sales Forecasting And Budgeting." WePapers, Feb 02, 2021. Accessed March 07, 2021. https://www.wepapers.com/samples/example-of-essay-on-sales-forecasting-and-budgeting/
WePapers. 2021. "Example Of Essay On Sales Forecasting And Budgeting." Free Essay Examples - WePapers.com. Retrieved March 07, 2021. (https://www.wepapers.com/samples/example-of-essay-on-sales-forecasting-and-budgeting/).
"Example Of Essay On Sales Forecasting And Budgeting," Free Essay Examples - WePapers.com, 02-Feb-2021. [Online]. Available: https://www.wepapers.com/samples/example-of-essay-on-sales-forecasting-and-budgeting/. [Accessed: 07-Mar-2021].
Example Of Essay On Sales Forecasting And Budgeting. Free Essay Examples - WePapers.com. https://www.wepapers.com/samples/example-of-essay-on-sales-forecasting-and-budgeting/. Published Feb 02, 2021. Accessed March 07, 2021.
Copy

Share with friends using:

Please remember that this paper is open-access and other students can use it too.

If you need an original paper created exclusively for you, hire one of our brilliant writers!

GET UNIQUE PAPER
Contact us
Chat now