6. Finley Heaters Inc. is a mid-sized manufacturer of residential water
heaters. Sales have grown during the last several years, and the
company's production capacity needs to be increased. The company's
management wonders if ‘national housing starts’ might be a good
indicator of the company's sales:
Finley Heaters
National
"
Housing Starts Annual Sales
Year (millions) (millions)
1 6.2 57
2 5.1 59
3 6.5 65
4 7.9 78
5 6.3 72
6 7.4 80
7 7.0 86
A) Develop a simple linear regression analysis between Finley Heaters'
sales and national housing starts.
Forecast Finley Heaters' sales for the next two years. The National Home
Builders Association estimates that
‘National housing starts’ will be 7.1 million and 8.0 million for
the next two years.
B) What percentage of variation in Finley Heaters' sales is explained by
national housing starts?
C) Would you recommend that Finley Heaters management use the forecast
from Part a to plan facility
expansion? Why or why not? What could be done to improve the forecast?
Business Homework Solutions
#11508
Develop a simple linear regression analysis between Finley Heaters' sales and national housing starts. What percentage of variation in Finley Heaters' sales is explained by national housing starts? Would you recommend that Finley Heaters management use the forecast from Part a to plan facility expansion?
6. Finley Heaters Inc. is a mid-sized manufacturer of residential water heaters. Sales have grown during the last several years, and the company's production capacity needs to be increased. The company's management wonders if 'national housing starts' might be a good indicator of the company's sales:
"
National Housing Starts Annual Sales
Year (millions) (millions)
1 6.2 57
2 5.1 59
3 6.5 65
4 7.9 78
5 6.3 72
6 7.4 80
7 7 86
A) Develop a simple linear regression analysis between Finley Heaters' sales and national housing starts. Forecast Finley Heaters' sales for the next two years. The National Home Builders Association estimates that 'National housing starts' will be 7.1 million and 8.0 million for the next two years.
B) What percentage of variation in Finley Heaters' sales is explained by national housing starts?
C) Would you recommend that Finley Heaters management use the forecast from Part a to plan facility expansion? Why or why not? What could be done to improve the forecast?
see attached problem.
Uses regression analysis to forecast Finley Heaters' sales using national housing starts as the independent variable.
What is this?
By OTA - Overall OTA Rating
Parool Agarwal, CA (IP) - 4.9/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
- Plain text response
- Attached file(s):
- 11508-Statistics.xls
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Carpet City wants to develop a means to forecast its carpet sales. The store manager believes that the store's sales are directly related to the number of new housing starts in town. - Carpet City wants to develop a means to forecast its carpet sales. The store manager believes that the store's sales are directly related to the number of new housing starts in town. The manager has g ...
- Forecasting: Regression - Using Excel, solve the following: Carpet City wants to develop a means to forecast its carpet sales. The store manager believes that the store's sales are directly related to the number of new hou ...
- Forecast using simple linear regression - This problem has to be done in Excel. Prepare a forecast, using simple linear regression, for each quarter of the next year from the following past 2 years' quarterly sales information. Quarter ...
- a) Perform a linear regression that relates bar sales to guests (not to time). b) If the forecast is for 20 guests next week, what are the sales expected to be? - The following data relate the sales figures of the bar in Marty and Polly Starr's small bed-and-breakfast inn in Marathon, Florida, to the number of guests registered that week: Week Guests Bar Sa ...
- Using the index (1985=100) on housing starts in the United States per year - Using the index (1985=100) on housing starts in the United States per year from 1986 to 1997 given in the table below, forecast the index for 1998 a three-year and a five year moving average. Which of ...
