Question

The following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle....

The following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle. Sales also exhibit seasonal variations.

Ft = 52 − 4.2t + 3.2t 2
  

where
Ft = Unit sales
t = 0 at the first quarter of last year

Quarter Relative
1 1.00
2 1.00
3 .50
4 1.50


Using the information given, prepare a forecast of sales for each quarter of next year (not this year), and the first quarter of the year following that. (Round intermediate calculations and final answers to 2 decimal places.)

Quarter Forecast
1
2
3
4
1

Homework Answers

Answer #1
Quarter Forecast
1 223.2
2 273.4
3 165
4 589.5
1 462.4
Quarter I 2 3 4 5
t 8 9 10 11 12
Ft 223.2 273.4 330 393 462.4
Relative 1.00 1.00 .50 1.50 1.00
Forecast 223.2 273.4 165 589.5 462.4

Ft at t = 8

= 52 − 4.2t + 3.2t 2

= 52 - 4.2 * 8 + 3.2 *8 ^ 2

= 223.2

Ft at t = 9

= 52 − 4.2t + 3.2t 2

= 52 - 4.2 * 9 + 3.2 *9^2

= 273.4

Ft at t = 10

= 52 − 4.2t + 3.2t 2

= 52 - 4.2 * 10 + 3.2 * 10^2

= 330

Ft at t = 11

= 52 − 4.2t + 3.2t 2

= 52 - 4.2 * 11 + 3.2 * 11 ^ 2

= 393

Ft at t = 12

= 52 − 4.2t + 3.2t 2

= 52 - 4.2 * 12 + 3.2 * 12^2

= 462.4

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Problem 3-12 The following equation summarizes the trend portion of quarterly sales of condominiums over a...
Problem 3-12 The following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle. Sales also exhibit seasonal variations. Ft = 62 − 5.2t + 4.2t 2    where Ft = Unit sales t = 0 at the first quarter of last year Quarter Relative 1 1.15 2 1.00 3 .65 4 1.30 Using the information given, prepare a forecast of sales for each quarter of next year (not this year), and the first quarter of...
The following table shows the past two years of quarterly sales information. Assume that there are...
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES QUARTER SALES 1 218 5 162 2 238 6 190 3 209 7 156 4 176 8 141 Use regression and seasonal indexes to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.) The following table shows the...
The following table shows the past two years of quarterly sales information. Assume that there are...
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 1 161 2 190 3 145 4 133 5 210 6 235 7 205 8 185 Use time series decomposition to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.) Quarter Forecast 9 10 11 12
Find the seasonalized forecast for Q2 of 2017.The sales trend has been modeled as: Sales =...
Find the seasonalized forecast for Q2 of 2017.The sales trend has been modeled as: Sales = 2 * t + 200, where t= time in quarters, beginning in Q1 2014. Seasonality for the four quarterly periods is given in the table below. Quarter Seasonal Factor Quarter #1 1.2000 Quarter #2 1.41 Quarter #3 0.5000 Quarter #4
Exhibit 4. The numbers of copies of a college textbook sold quarterly over the past three...
Exhibit 4. The numbers of copies of a college textbook sold quarterly over the past three years are:          Year Quarter Sales t Qtr2 Qtr3 Qtr4 1 1 1690 1 0 0 0 1 2 940 2 1 0 0 1 3 2625 3 0 1 0 1 4 2400 4 0 0 1 2 1 1760 5 0 0 0 2 2 990 6 1 0 0 2 3 2800 7 0 1 0 2 4 2510 8 0...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 50 42 52 3 59 61 54 4 78 81 72 (a) Construct a time series plot.    What type of pattern exists in the data? The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. The time series plot shows a trend pattern, but there is also a seasonal pattern in the data.     The...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 48 40 50 3 59 61 54 4 78 81 72 (a) Construct a time series plot. What type of pattern exists in the data? a)The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. b)The time series plot shows a horizontal pattern with no seasonal pattern present.     c)The time series plot shows a trend...
Six years of quarterly data of a seasonally adjusted series are used to estimate a linear...
Six years of quarterly data of a seasonally adjusted series are used to estimate a linear trend model as Tˆt = 164.90 + 1.09t. In addition, quarterly seasonal indices are calculated as Sˆ1 = 0.88, Sˆ2 = 0.94, Sˆ3 = 1.16, and Sˆ4 = 1.12. a-1. Interpret the first quarterly index. In other words, what is the value of the series in the first quarter as compared to the average? 12% below 12% above 88% above 88% below a-2. Interpret...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 49 41 51 3 57 59 52 4 78 81 72 (a) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects in the data: x1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise. = _____?______ (b) Compute the quarterly forecasts for...
2. A consulting firm estimates the quarterly sales (in millions of dollars) of a Regional Airlines...
2. A consulting firm estimates the quarterly sales (in millions of dollars) of a Regional Airlines called “U Fly”, by the following significant model: E(Sales) = 300.5 + 2.37(T) - 4.6Q1 - 6.8Q3 + 8.65Q4 Where E(Sales) is the average sales for each quarter (in millions of dollars), T is a time index defined as 1, 2, 3, …………,20, and 20 represents the first quarter of 2020, Q1 = 1 when in the first quarter, 0 otherwise, Q3 =1 when...