Solution: An electronic retail company recorded the quarterly sales of TV sets for the past 4 years. The data is recorded in table 4 below. Year Sales (1000s)


Question:

An electronic retail company recorded the quarterly sales of TV sets for the past 4 years. The data is recorded in table 4 below.

Year Sales (1000s)
Quarter 1 Quarter 2 Quarter 3 Quarter 4
1 4.8 4.1 6.0 6.5
2 5.8 5.2 6.8 7.4
3 6.0 5.6 7.5 7.8
4 6.3 5.9 8.0 8.4
  1. Calculate the seasonal relative for each quarter.
  2. Using the seasonal relatives, deseasonalize the sales value presented in table 2.
  3. Using a trend line equation for the deseasonalized values Tt = 5.101 + 0.148 * t, forecast the sales expected in quarters 1 and 2 of the 5th year.
  4. Reseasonalize these two forecasts to re-capture the seasonal component.

Price: $2.99
Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in