Imagine that Casey Hardware is considering moving forward with one of the following three locations as described in Table 3 of the Week 7 Assignment Excel Template.
Table 3 - Store Data
Store # Sales ($000s) Size (000s sq ft) Number of Product Lines Distance (mi)
AA 250 3.0 125 0.6
BB 125 2.3 100 1.1
CC 300 3.9 170 1.2
Perform the necessary calculations in Excel to determine the potential profitability of each of the three locations under consideration based on your multiple regression analysis results from PART B.
Paste your regression equation into the designated area in the Week 7 Assignment Excel Template tab Part C. Use the equation and the data from Table 3 to complete Table 4 - Profitability Calculator. The last column, Overall Projected Profits, should be calculated using the equation.
Identify the location where Casey Hardware should open their next store and explain why in one sentence.