Question

In: Accounting

Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at...

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
101 $4,100 $4,214
102 2,227 2,894
103 5,738 5,181
104 3,982 3,998
105 2,914 3,676
106 4,023 3,319
107 6,894 5,029
108 1,779 2,374
109 5,416 4,688
110 3,228 2,959
111 3,886 4,179
112 4,690 3,200
113 3,552 2,556
114 4,817 4,655
115 2,124 2,986

Required:

a. Use the high-low method to estimate the fixed and variable portions of store costs based on revenues.
b. Managers estimate that one of the proposed stores will have revenues of $2.5 million. What are the estimated monthly overhead costs, assuming no inflation?
c. Managers are also considering a “mega-store” with revenues of $10 million. What are the estimated monthly overhead costs, assuming no inflation?

Solutions

Expert Solution

Please note for question 2 and 3it is not mentioned whether revenue is on year or monthly basis

It is assumed it is annual sales.


Related Solutions

Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at...
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. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at...
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 101 $4,250 $4,439 102 2,377 3,194 103 5,963 5,406 104 4,282 4,373...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at...
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. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at...
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. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following...
The Cotton Mill is an upscale chain of women's clothing stores, located in the southwestern United...
The Cotton Mill is an upscale chain of women's clothing stores, located in the southwestern United States. Do to recent success, The Cotton Mill's top management is planning to expand by locating new stores in other regions of the country. The director of planning has been asked to study the relationship between yearly sales and the store size. As part of the study, the director selects a sample of 25 stores and determines the size of the store in square...
2. the cotton mill is an upscale chain of women’s clothing stores. Located in the southwestern...
2. the cotton mill is an upscale chain of women’s clothing stores. Located in the southwestern united states. Do to recent success, the cotton mill’s top management is planning to expand by locating new stores in other regions of the country. The director of planning has been asked to study the relationship between yearly sales and the store size. As part of the study, the director selects sample of 25 stores and determines the size of the store in square...
CASE: HAROLD DAVIS and ENID DAVIS, Plaintiffs-Appellants, v. UNITED STATES OF AMERICA, Defendant-Appellee UNITED STATES COURT...
CASE: HAROLD DAVIS and ENID DAVIS, Plaintiffs-Appellants, v. UNITED STATES OF AMERICA, Defendant-Appellee UNITED STATES COURT OF APPEALS FOR THE NINTH CIRCUIT 861 F.2d 558 November 14, 1988 Plaintiff-appellants Harold and Enid Davis claimed charitable deductions under IRC section 170 for funds they sent to their two sons for their support while they served as full-time unpaid missionaries for the Church of Jesus Christ of LatterDay-Saints at the New York City Mission and at the New Zealand/Cook Islands Mission. These...
Boyle Company makes fine jewelry that it sells to department stores throughout the United States. Boyle...
Boyle Company makes fine jewelry that it sells to department stores throughout the United States. Boyle is trying to decide which of the two bracelets to manufacture. Cost data pertaining to the two choices follow: Bracelet A Bracelet B Cost of materials per unit $ 10 $ 20 Cost of labor per unit 15 15 Advertising cost per year 5,000 3,000 Annual depreciation on existing equipment 5,000 4,000 Required Identify the fixed costs and determine the amount of fixed cost...
Rundle Company makes fine jewelry that it sells to department stores throughout the United States. Rundle...
Rundle Company makes fine jewelry that it sells to department stores throughout the United States. Rundle is trying to decide which of the two bracelets to manufacture. Cost data pertaining to the two choices follow: Bracelet A Bracelet B Cost of materials per unit $ 25 $ 49 Cost of labor per unit 38 38 Advertising cost per year 8,100 6,400 Annual depreciation on existing equipment 6,300 4,700 Required Identify the fixed costs and determine the amount of fixed cost...
Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The...
Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The company maintains a large sales force whose job it is to call on existing customers as well as look for new business. The national sales manager is investigating the relationship between the number of sales calls made and the miles driven by the sales representative. Also, do the sales representatives who drive the most miles and make the most calls necessarily earn the most...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT