Reference no: EM13949172
All the data is in the file pamsue.xls, find attached also the Table A & B that is 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. (Attached document called "hints" can be used for this)
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.
Attachment:- hints.doc
Attachment:- pamsue.xls
Attachment:- Table A & B.xls
|
Find the fixed overhead spending and volume variances
: Compute the variable overhead spending and efficiency variances. Compute the fixed overhead spending and volume variances.
|
|
1nf figure converted to 2nf figure
: 1NF figure converted to 2NF figure with a explanation of the steps taken. Once in 2NF, it needs to be converted to 3NF, and explanation of steps taken is needed as well.
|
|
Other country icon: french perfume adopters
: Make a list of recent United States icons that were not mentioned in Chapter 11. (If you were born or grew up in another country, you can make a list of icons from the United States that are sold in that country.)
|
|
Examine the many different types of attacks
: There are many different types of infrastructure attacks. These include, but are not limited to, malware, insertion, buffer overflow, etc. Examine the many different types of attacks and select the two that you believe are the easiest for succes..
|
|
How would you describe the type of location sites
: 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.
|
|
How employees would interact with these devices
: Speculate how employees would interact with these devices and the type of emotional reaction that customers and employees will experience while placing a beverage, appetizer or entrée order
|
|
Explain what the circuit does
: 1. The input to the circuit of Figure P12.76 is a square wave having a period of 2 s, maximum value of 5 V, and minimum value of 0 V. Assume all flip-flops are initially in the RESET state.
|
|
Create a view named customeraddresses
: Write a SELECT statement that returns these columns from the CustomerAddresses view that you created in exercise 1: CustomerID, LastName, FirstName, BillLine1.
|
|
What is the irr of this project
: What is the NPV of this project, if the discount rate is 8.6%? Should the firm accept this project? What is the IRR of this project? Should the firm accept this project?
|