Required Information Exercise 5-44, 5-45, 5-46, 5-47, 5-48, 5-49, and 5-50 (Static) (LO 5-1, 2, 3) [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). Revenues ($800) Costs ($900) Area Store SE-01 (Square Feet) $ 20,545 69,147 $ 15,799 SE-02 15,482 51,417 12,495 SE-03 25,721 83,331 19,210 SE-04 19,389 61,374 15,079 SE-05 19,666 58,509 15,112 SE-06 17,756 67,374 14,099 SE-07 24,505 95,748 18,691 SE-08 12,701 46,098 10,747 SE-09 23,081 78,012 17,453 SE-10 15,830 62,055 12,864 SE-11 20,358 65,601 15,633 SE-12 17,120 72,693 13,797 SE-13 13,674 62,055 11,570 SE-14 22,904 74,466 17,294 Exercise 5-50 (Static) Methods of Estimating Costs: Multiple Regression (LO 5-1, 3) Results from a multiple regression of store costs on revenues and area are as follows. Equation: Store cost $2,298.88 (in thousands) + (60.0 % x Revenues) + ($0.017 x Area) Statistical data Correlation coefficient Adjusted R² 0.999 0.999 Required: The managers in the region are interested in opening a new store with expected revenues of $19 million and expected area of 50,000 square feet. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-19), what are the estimated store costs for store SE-19 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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Rahul 

Required Information
Exercise 5-44, 5-45, 5-46, 5-47, 5-48, 5-49, and 5-50 (Static) (LO 5-1, 2, 3)
[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).
Revenues
($800)
Costs
($900)
Area
Store
SE-01
(Square Feet)
$ 20,545
69,147
$ 15,799
SE-02
15,482
51,417
12,495
SE-03
25,721
83,331
19,210
SE-04
19,389
61,374
15,079
SE-05
19,666
58,509
15,112
SE-06
17,756
67,374
14,099
SE-07
24,505
95,748
18,691
SE-08
12,701
46,098
10,747
SE-09
23,081
78,012
17,453
SE-10
15,830
62,055
12,864
SE-11
20,358
65,601
15,633
SE-12
17,120
72,693
13,797
SE-13
13,674
62,055
11,570
SE-14
22,904
74,466
17,294
Exercise 5-50 (Static) Methods of Estimating Costs: Multiple Regression (LO 5-1, 3)
Results from a multiple regression of store costs on revenues and area are as follows.
Equation:
Store cost $2,298.88 (in thousands) + (60.0 % x Revenues) + ($0.017 x
Area)
Statistical data
Correlation coefficient
Adjusted R²
0.999
0.999
Required:
The managers in the region are interested in opening a new store with expected revenues of $19 million and expected area of 50,000
square feet. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-19), what are the
estimated store costs for store SE-19 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
Transcribed Image Text:Required Information Exercise 5-44, 5-45, 5-46, 5-47, 5-48, 5-49, and 5-50 (Static) (LO 5-1, 2, 3) [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). Revenues ($800) Costs ($900) Area Store SE-01 (Square Feet) $ 20,545 69,147 $ 15,799 SE-02 15,482 51,417 12,495 SE-03 25,721 83,331 19,210 SE-04 19,389 61,374 15,079 SE-05 19,666 58,509 15,112 SE-06 17,756 67,374 14,099 SE-07 24,505 95,748 18,691 SE-08 12,701 46,098 10,747 SE-09 23,081 78,012 17,453 SE-10 15,830 62,055 12,864 SE-11 20,358 65,601 15,633 SE-12 17,120 72,693 13,797 SE-13 13,674 62,055 11,570 SE-14 22,904 74,466 17,294 Exercise 5-50 (Static) Methods of Estimating Costs: Multiple Regression (LO 5-1, 3) Results from a multiple regression of store costs on revenues and area are as follows. Equation: Store cost $2,298.88 (in thousands) + (60.0 % x Revenues) + ($0.017 x Area) Statistical data Correlation coefficient Adjusted R² 0.999 0.999 Required: The managers in the region are interested in opening a new store with expected revenues of $19 million and expected area of 50,000 square feet. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-19), what are the estimated store costs for store SE-19 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
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education