Forecast Analysis for Performance Lawn Equipment
Not what you're looking for?
An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers (units sales) and tractors ( unit sales) in each marketing region in the Excel (using exponential smoothing and linear plots) forecast should be a year out so you will be forecasting for 2015.
Develop forecasting models for these data and Prepare a report of your results with appropriate charts and output from Excel.
Purchase this Solution
Solution Summary
The Solution forecasts sales for the sample company, Performance Lawn Equipment.
Solution Preview
Please see the attached file for the fully formatted Solution.
Mower Forecast for 12 months using Exponential Smoothing
Month NA SA Europe Pacific China World
Jan-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Feb-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Mar-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Apr-15 5210.545 296.948 507.793 231.773 3.399 6250.457
May-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Jun-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Jul-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Aug-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Sep-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Oct-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Nov-15 5210.545 296.948 507.793 231.773 3.399 6250.457
Dec-15 5210.545 296.948 507.793 231.773 3.399 6250.457
MSE 1895660.571 1033.359 86748.871 118.277 10.711 2586135.003
MAD 1305.461 27.450 239.488 9.301 1.181 1529.342
MAPE 18.370 9.690 28.270 5.475 22.381 17.805
Mower Forecast for 12 months using linear model
Month NA SA Europe Pacific China World
Jan-15 7,731.3 237.3 1,362.2 111.6 -2.7 9,439.8
Feb-15 7,724.9 238.9 1,355.0 113.6 -2.5 9,429.9
Mar-15 7,718.5 240.4 1,347.8 ...
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.