The managers in the region are interested in opening a new store with expected revenues of $22.5 million. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-17), what are the estimated store costs for store SE-17 using the results from this regression? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places. Store cost

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Hardev

!
Required information
[The following information applies to the questions displayed below.]
Waveney DIY Centers (WDC) operates a few dozen stores in the eastern United States. The stores are popular with home
remodelers, contractors, and do-it-yourself customers. The managers at Waveney are interested in understanding what
drives costs as well as getting better cost estimates when planning new stores. The area manager for the Southeast
Region is interested in new data analysis approaches to management and offered to run a test using data from the 14
stores in the region.
The initial thoughts of the managers and the financial analysts in the region were that two primary factors drove store
costs: store area (square footage) and revenue. The following data were collected from the most recent year of operations
(revenues and costs in thousands of dollars).
Store
SE-01
SE-02
SE-03
SE-04
SE-05
SE-06
SE-07
SE-08
SE-09
SE-10
SE-11
SE-12
SE-13
SE-14
Revenues
($000)
$ 21,245
16, 182
26,421
20,089
20,366
18,456
25,205
13,401
23,781
16,530
21, 058
17,820
14,374
23,604
Area
(Square Feet)
Store cost
69,847
52,117
84,031
68,074
59,209
68,074
96,448
46,798
78,712
62, 755
66,301
73,393
62,755
75, 166
Costs
($000)
$16,499
13,195
19,910
15,779
15,812
14,799
19,391
11,447
18,153
13,564
16,333
14,497
12,270
17,994
Results from a regression of store costs on revenues are as follows.
Equation:
Store costs = $2,941.22 (in thousands) + (71.6 % × Revenue)
Statistical data
Correlation coefficient
0.999
0.998
R²
Required:
The managers in the region are interested in opening a new store with expected revenues of $22.5 million. Assuming the data and
cost estimates from the current stores are appropriate for the new store (SE-17), what are the estimated store costs for store SE-17
using the results from this regression?
Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places.
Transcribed Image Text:! Required information [The following information applies to the questions displayed below.] Waveney DIY Centers (WDC) operates a few dozen stores in the eastern United States. The stores are popular with home remodelers, contractors, and do-it-yourself customers. The managers at Waveney are interested in understanding what drives costs as well as getting better cost estimates when planning new stores. The area manager for the Southeast Region is interested in new data analysis approaches to management and offered to run a test using data from the 14 stores in the region. The initial thoughts of the managers and the financial analysts in the region were that two primary factors drove store costs: store area (square footage) and revenue. The following data were collected from the most recent year of operations (revenues and costs in thousands of dollars). Store SE-01 SE-02 SE-03 SE-04 SE-05 SE-06 SE-07 SE-08 SE-09 SE-10 SE-11 SE-12 SE-13 SE-14 Revenues ($000) $ 21,245 16, 182 26,421 20,089 20,366 18,456 25,205 13,401 23,781 16,530 21, 058 17,820 14,374 23,604 Area (Square Feet) Store cost 69,847 52,117 84,031 68,074 59,209 68,074 96,448 46,798 78,712 62, 755 66,301 73,393 62,755 75, 166 Costs ($000) $16,499 13,195 19,910 15,779 15,812 14,799 19,391 11,447 18,153 13,564 16,333 14,497 12,270 17,994 Results from a regression of store costs on revenues are as follows. Equation: Store costs = $2,941.22 (in thousands) + (71.6 % × Revenue) Statistical data Correlation coefficient 0.999 0.998 R² Required: The managers in the region are interested in opening a new store with expected revenues of $22.5 million. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-17), what are the estimated store costs for store SE-17 using the results from this regression? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman