Answered step by step
Verified Expert Solution
Question
1 Approved Answer
HW assist for stats class Use the following data to answer Questions 27 - 28. Past period Demand June 45 July 55 Aug. 57 Sept.
HW assist for stats class
Use the following data to answer Questions 27 - 28.
Past period | Demand | |||
June | 45 | |||
July | 55 | |||
Aug. | 57 | |||
Sept. | 48 | |||
Oct. | 50 |
- Compute a weighted moving average forecast for November. Use the following weights: 0.5 for Oct., 0.2 for Sept., and 0.3 for August.
- Compute an exponential smoothing forecast for November. Assume forecast for September is 46.5, and use a smoothing constant equal to 0.6.
Use the following data to answer Questions 29 - 30.
Actual Value | Forecast Value | |||
45 | 44 | |||
55 | 56 | |||
57 | 52 | |||
48 | 50 | |||
50 | 48 |
- Calculate MAD
- Calculate MSE
- Demand for 5 weeks of jobs at a carpet-cleaning business is shown below. Use linear regression to create a trend equation for this time-series.
Week (X) | Demand (Y) | ||||
1 | 55 | ||||
2 | 60 | ||||
3 | 41 | ||||
4 | 35 | ||||
5 | 20 |
The trend equation is:
Week | Monday | Tuesday | Wednesday | Thursday | Friday |
1 | 8 | 15 | 25 | 13 | 2 |
2 | 12 | 25 | 34 | 17 | 7 |
- Compute and report Wednesday's Seasonal Factor.
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