You have recently been assigned to the production planning department within your company.? Your firm makes large blades for powe
You have recently been assigned to the production planning department within your company. Your firm makes large blades for power generation windmills. The windmills are mostly used in the western part of the country and take about a week to build.
Your boss has provided you with the monthly demand for blades from the last year and asked that you produce a forecast for January so that he can work with the material planning and scheduling department to make sure that the required materials are on hand and schedule the workers hours.
By the end of the week, your boss has asked you to produce a professional video presentation with all of the needed data so that he can brief his boss on your findings.
Using the data provided, produce forecasting models using the following:
Questions to be addressed
- While the MAD can be used to determine which forecasting method is the most accurate, normally, the MAPE is a better measure. So, compare the MAPE of the three methods and determine which is the best model (e.g. the most accurate).
- Base on the chosen model, what should you recommend to your boss as the forecasted demand for January?
- Produce a line chart that shows all three of the forecast and the actual demand.
- Review the chart and the data. Do you think that the forecasts have given you an accurate result? Do you notice any trends in the data that could affect the January forecast? If so, what would you recommend to your boss?
Forecasting Models
- Simple Moving Average (on a 4 month moving average)
- Weighted Moving Average (4 month moving average with weights = 0.4, 0.3, 0.2. 0.1)
- Exponential Smoothing (α = 0.3) (assume forecast for January is the same as the actual demand)Simple Moving Average (on a 4 month moving average)
- Weighted Moving Average (4 month moving average with weights = 0.4, 0.3, 0.2. 0.1)
- Exponential Smoothing (α = 0.3) (assume forecast for January is the same as the actual demand)
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.