Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

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 Revenues ($000) Area (Square Feet) Costs ($000) SE-01 $ 21,245 69,847 $ 16,499 SE-02 16,182 52,117 13,195 SE-03 26,421 84,031 19,910 SE-04 20,089 68,074 15,779 SE-05 20,366 59,209 15,812 SE-06 18,456 68,074 14,799 SE-07 25,205 96,448 19,391 SE-08 13,401 46,798 11,447 SE-09 23,781 78,712 18,153 SE-10 16,530 62,755 13,564 SE-11 21,058 66,301 16,333 SE-12 17,820 73,393 14,497 SE-13 14,374 62,755 12,270 SE-14 23,604 75,166 17,994 Required: Use the high-low method to estimate the fixed and variable portions of store costs based on store revenues. The managers in the region are interested in opening a new store with expected revenues of $19.7 million. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-15), what are the estimated store costs for store SE-15? Managers are also considering a mega-store with revenues of $31.4 million. What are the estimated store costs for the mega store? Use the high-low method to estimate the fixed and variable portions of store costs based on store revenues. Note: Round variable cost percentage answer to 1 decimal place. Enter Fixed cost answer in thousands of dollars rounded to 2 decimal places. Variable cost % Fixed cost he managers in the region are interested in opening a new store with expected revenues of $19.7 million. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-15), what are the estimated store costs for store SE-15? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places. Show less Store costs Managers are also considering a mega-store with revenues of $31.4 million. What are the estimated store costs for the mega store? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places. Store costs

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Leading The Internal Audit Function

Authors: Lynn Fountain

1st Edition

0367568004, 9780367568009

More Books

Students also viewed these Accounting questions

Question

Do you suggest Lisa use a PEO? Why?

Answered: 1 week ago