Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the following data are the sales of mattress during the last 3 years Period Sales 1 3500 2 4000 3 3000 4 3850
For the following data are the sales of mattress during the last 3 years Period Sales 1 3500 2 4000 3 3000 4 3850 5 6000 6 5750 7 7000 8 6000 9 10000 10 12000 11 14000 12 9000 13 3010 14 4000 15 3000 16 5000 17 6000 18 9000 19 3000 20 8000 21 10000 22 14000 23 14000 24 10000 1. Use simple moving with N=2,3 to forecast the demand, which is the best according to MAD & MSE? 2. Use exponential weighted moving average with (with a 0.1) to forecast the demand for previous 3 years given that F(1) is 3200, What is the sales at Period 25 3. Use regression analysis tool to fit a line to your data and write the line equation, what is the forecast for sales for at Period 25.
Step 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