Explore BrainMass

Regression model

I need help answering these questions. Enclosed in the multiple regression model that the questions refer too and also the Table A & B that are referred to in question 2 & 3.

This case involves the decision to locate a new store at one of two candidate sites. The decision will be based on estimates of sales potential.

Problem 1

Use the final regression equation in the last step to predict sales at the two sites under consideration.

Question 1

How would you describe the type of location sites that are likely to have higher sales?

Question 2

A group within the planning department had previously developed a subjective approach in which potential sites are classified according to an assessment of the "competitive type" of the trading zone. Below in table A, the 7 "competitive types" are defined. How good is this classification method at predicting sales? How can you quantify this?

Question 3

Two sites, A and B, are currently under consideration for the next new store opening. Characteristics of the two sites are provided below in table B. Which site would you recommend? Justify you choice and give the best sales forecasts you can. You may use the subjective classifications from question 2 along with any other variables you think will give the best forecast. Give some estimates of the accuracy of the forecasting method you use and any other limitations of the forecasting method.

Question 4

Two of the variables in the data base are under managerial control: the size of the store (square feet of selling area) and the percentage hard goods stocked in the store. Margins on hard goods (house wares, appliances, stationary, drugs) are different from margins on soft goods (clothing, for example). Do either of these factors appear linked to sales? If so, describe the link you observe and the managerial implications.

Questions 5

Technical: After developing your regression model, check to make sure the technical assumptions are satisfied. Comment on any points that would concern you based on the diagnostics.

Table A: Competitive Types

Type: 1 densely populated areas with relatively little direct competition

Type 2: High income areas with little direct competition

Type 3: Locations near major shopping centers

Type 4: Stores in downtown areas of suburbs

Type 5: Stores with competition from discounters, but not from department stores
Type 6: Stores in shopping centers

Type 7: Stores located along the sides of major roads


Solution Summary

The solution provides step by step method for the construction of regression model . Formula for the calculation and Interpretations of the results are also included.