CO5: Investigate forecast performance utilizing
spreadsheet techniques.
This week you will use an excel spreadsheet to analyze
forecasting performance. Your company produces and
distributes two lines of Consumer External Hard Drives: 1
Terabyte drives (1 Tb) and 5 Terabyte Drives (5 Tb). The
unit sales levels and forecasts for the last two previous
years are in the table below. For this exercise, You have
been asked to calculate the Forecast error, Forecast
Percentage, Mean percentage Error (MPE) and Mean
Absolute Percentage Error (MAPE) for (a) each type of
terabyte (b) each year, and (c) for each two-year period.
The concepts, equations, and examples for how to
calculate these forecasting effectiveness are covered in
your textbook on pages 107 – 114. Finally, for each set of
problems you will provide insight into the sales trends,
and forecasting effectiveness with a written summary of
your findings.
OK
Okoth
Academic Expert · EssayPanel
Expert academic writer and education specialist helping students in the UK, USA, and Australia achieve their best results across all subjects.
Need help with your own assignment?
Our expert writers can help you apply everything you've just read — to your actual assignment, brief, and marking criteria.
Get Expert Help Now →← Previous
For this assessment, you will create a plan for a Training Needs Assessment, but will not actually conduct the TNA. To create your plan for your TNA: Identify the Business need: Identify the business problem and desired results
Next →
Polling has become a very common practice of assessing the public’s viewpoint. It seems as if there’s a poll for everything! But how valid are these polls? And how difficult is it to truly assess public opinion?