Answered step by step
Verified Expert Solution
Question
1 Approved Answer
if you could show how to do it on a Excel spreadsheet that would be best. please include formulas Here are the actual tabulated demands
if you could show how to do it on a Excel spreadsheet that would be best. please include formulas
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period a) Forecast April through September using a three-month moving average b) Use a simple exponential smoothing with an alpha of 0.6 to estimate demands for May through September. (assume the forecasted demand for April was 150) c) Calculate MAD, MSE, and MAPE for (a) and (b) d) Base on your answers in c), which do you think is a better forecasting methodStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started