Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are Interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year's operations (revenues and costs In thousands of dollars). Costs $4,214 2,894 5,181 3,998 3,676 3,319 5,029 2,374 4,688 2,959 4,179 3,200 2,556 4,655 Store Revenues $4, 100 2,227 5,738 3,982 2,914 4,023 6,894 1,779 5,416 3,228 3,886 4,690 3,552 4,817 101 102 103 104 105 106 107 108 109 110 111 112 113 114

Financial Reporting, Financial Statement Analysis and Valuation
8th Edition
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Chapter10: Forecasting Financial Statement
Section: Chapter Questions
Problem 9PC: The Home Depot is a leading specialty retailer of hardware and home improvement products and is the...
icon
Related questions
Question

hello I was looking to get help with this

Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are
considering expanding by opening new stores and are interested in estimating costs in potential new locations. They
believe that costs are driven in large part by store volume measured by revenue. The following data were collected from
last year's operations (revenues and costs In thousands of dollars).
Store
Revenues
Costs
$4,100
2,227
5,738
3,982
2,914
4,023
6,894
1,779
5,416
3,228
3,886
4,690
101
$4,214
2,894
5,181
3,998
3,676
3,319
5,029
2,374
4,688
2,959
4,179
3, 200
2,556
4,655
2,986
102
103
104
105
106
107
108
109
110
111
112
113
3,552
4,817
2,124
114
115
Simple regression results from the data of Davis Stores are as follows.
Equation:
Store costs = $1,604.40 + (Revenue x 53.6%)
Statistical data
Correlation coefficient
0.835
R2
0.698
Requlred:
a. Estimate store costs for a store with revenue of $2.5 million.
b. What percentage of the variation in store costs is explained by the independent variable?
Complete this question by entering your answers in the tabs below.
Required A
Required B
Estimate store costs for a store with revenue of $2.5 million. (Enter the answer in thousands of dollars. Round your answer to
2 decimal places.)
Store cost
Transcribed Image Text:Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year's operations (revenues and costs In thousands of dollars). Store Revenues Costs $4,100 2,227 5,738 3,982 2,914 4,023 6,894 1,779 5,416 3,228 3,886 4,690 101 $4,214 2,894 5,181 3,998 3,676 3,319 5,029 2,374 4,688 2,959 4,179 3, 200 2,556 4,655 2,986 102 103 104 105 106 107 108 109 110 111 112 113 3,552 4,817 2,124 114 115 Simple regression results from the data of Davis Stores are as follows. Equation: Store costs = $1,604.40 + (Revenue x 53.6%) Statistical data Correlation coefficient 0.835 R2 0.698 Requlred: a. Estimate store costs for a store with revenue of $2.5 million. b. What percentage of the variation in store costs is explained by the independent variable? Complete this question by entering your answers in the tabs below. Required A Required B Estimate store costs for a store with revenue of $2.5 million. (Enter the answer in thousands of dollars. Round your answer to 2 decimal places.) Store cost
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Planning
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub