Question
Answer in Excel: Consider the data below for the sales of widgets: 1. Using seasonal percentages or seasonal indexes, forecast the sales for each season
Answer in Excel:
Consider the data below for the sales of widgets: 1. Using seasonal percentages or seasonal indexes, forecast the sales for each season in year 4, if the annual widgets sales is predicted to be 1500. 2. Develop a regression equation that captures both the trend and seasonality in this data. Use this equation to forecast the sales for each season in year 4.
| Season | Year 1 | Year 2 | Year 3 |
| Fall | 505 | 240 | 210 |
| Winter | 555 | 460 | 365 |
| Spring | 400 | 310 | 204 |
| Summer | 560 | 450 | 394 |
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
Financial Management In The Sport Industry
Authors: Matthew T Brown, Daniel Rascher, Mark S Nagel, Chad McEvoy
2nd Edition
9781621590118
