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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • Suppose that the time (in hours) that Irene spends on an untimed final exam follows an...
    asked 8 minutes ago
  • The following sample observations were randomly selected. (Round intermediate calculations and final answers to 2 decimal...
    asked 21 minutes ago
  • what type of graph is best suitable for data obtained from customer ratings. The ratings are...
    asked 24 minutes ago
  • Determine the cumulative 15-year 18 kip ESAL’s in the design lane for 2-lane highway for the...
    asked 32 minutes ago
  • Q: Dr.Grimace, the evil dentist, is trying to find out if his patients suffer from periodontal...
    asked 32 minutes ago
  • After collecting data on 19283 dogs, you find that male vallhunds have an average weight of...
    asked 34 minutes ago
  • Research Target Corporation and assess your satisfaction with the company you researched and make recommendations about...
    asked 35 minutes ago
  • Evidence suggests that 70% of FSU students like turtles. Suppose we randomly sampled 15 FSU students....
    asked 35 minutes ago
  • Ulrich challenges the appropriateness of the nearly universal symbolism of the spinning wheel as the marker...
    asked 36 minutes ago
  • Differential Equations: Please try to computer type, if not possible be clear and organize. Thank you...
    asked 36 minutes ago
  • In your opinion, what are the three (3) most important benefits an employer can give to...
    asked 41 minutes ago
  • In a test of the effectiveness of garlic for lowering​ cholesterol, 81 subjects were treated with...
    asked 44 minutes ago