Question
A local moving company has collected data on the number of moves made over the past three years. Moving is highly seasonal, so the owner/operator
A local moving company has collected data on the number of moves made over the past three years. Moving is highly seasonal, so the owner/operator decides to apply the multiplicative seasonal method to forecast the number of customers for the coming year. Using some other forecasting method, he has arrived at forecast of 212 for total sales for the next year. The following tables provides related information. Please find the missing information.
Quarter | Year 1 | Year 2 | Year 3 | Year 4 | Forecast |
1 | 24 | 31 | 37 | 40 | |
2 | 44 | 49 | 49 | 52 | A |
3 | 49 | 59 | 59 | 62 | |
4 | 34 | 44 | 44 | 47 | |
Total | 151 | 183 | 189 | 201 | |
Average | 37.75 | 45.75 | 47.25 | 50.25 |
Quarter | Seasonal Indices | Average | |||
Year 1 | Year 2 | Year 3 | Year 4 | ||
1 | 0.64 | 0.68 | 0.78 | 0.8 | 0.72 |
2 | 1.17 | 1.07 | 1.04 | 1.03 | 1.08 |
3 | 1.3 | 1.29 | 1.25 | 1.23 | C |
4 | B | 0.96 | 0.93 | 0.94 |
What is the Forecast amount for A.
Group of answer choices
a) 33.00 to 34.00
b) 67.00 to 68.00
c) 56.50 t o57.50
d) 53.80 to 54.20
e) None of these answers are correct
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