Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.
QUESTION
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)
Sample Solutions
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.
Get sample solution
Order Now
Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.
Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.
Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.
Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida