Purchase Solution

Forecast the sales for the home improvements market - Mexico

Not what you're looking for?

Ask Custom Question

Forecast the sales for the home improvements market for Mexico City for 2007 using expenditures per household as the explanatory (independent) variable in a linear regression analysis. Graph the actual and forecasted data. See attached for data.

Select another possible explanatory variable, in addition to expenditures per household that could be used to forecast annual sales for the home improvement market in Mexico City. Discuss why this variable may be a good predictor of sales and where you could obtain data on this variable. Then using at least nine years of such data (predicted if necessary), calculate a second linear regression equation using your selected variable.
Year Population
2000 99,927
2001 101,247
2002 102,480
2003 103,718
2004 104,960
2005 106,203
2006 107,450
2007 108,701

See attached file for full problem description.

Attachments
Purchase this Solution
Solution Summary

Demonstrates how to work with actual data to make sales forecast.

Solution Preview

See the attached file for complete solution. The text here may not be copied exactly as some of the symbols / tables may not print. Thanks

Year Home improvement sales Expenditures per household Population Forecast using HI Expenditure Forecast Using ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Company Overview Milestone

    Also, Home Depot sales installations services through its in-home sales program, which includes roofing, siding products, windows, furnaces and central air systems.

  • Marketing

    283960 Able Corp: 4 direct economic indices used to forecast sales, environmental analyses There are four direct general economic indices that are used to forecast the sales of the PEPT (Portable Electric Power Tools) industry in which Able Corporation

  • Supply chain and location planning

    Yes, it should be in proximity to the customers to improve customer satisfaction. 4. Can the sales forecast process be improved? If so, how?

  • Supply chain and location planning recommendations

    Sales forecast can also be improved by improving supply chain management.

  • Wal-Mart's low-priced retailing to the Mexican environment

    International revenue soared 30% to $77.1 billion, accounting for 22% of Wal-Mart's sales, in the fiscal year ended Jan. 31. Wal-Mex profits are forecast to grow 20% to $1.3 billion this year.

  • Supply chain and location planning

    Yes, it should be in proximity to the customers to improve customer satisfaction. 4. Can the sales forecast process be improved? If so, how?

  • Ratio analysis for Home Depot

    (d) At the current market price of $50 per share, what growth rate for residual operating income does the market forecast for the future?

  • globalization

    As AMS is also into sales of electrical transformers, so joint venture will help in making the sales of products easily in the local market.

  • Evaluate Home Depot Budget

    The Home Depot was the world's largest retailer of home improvement products particularly in the United States Canada, and Mexico in terms of net sales in the year 2009 (Home Depot, 2010).

View More Related Solutions