Waveney DIY Centers (WDC) operates a few dozen stores In the eastern Unlted States. The...
90.2K
Verified Solution
Link Copied!
Question
Accounting
Waveney DIY Centers (WDC) operates a few dozen stores In the eastern Unlted 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 gettling better cost estlmates 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 InItlal thoughts of the managers and the financlal 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). Requlred: a. Use the high-low method to estimate the fixed and varlable portions of store costs based on store revenues. b. The managers in the reglon are Interested In opening a new store with expected revenues of $19.9 million. Assuming the data a cost estimates from the current stores are approprlate for the new store (SE-15), what are the estimated store costs for store SE- c. Managers are also considerIng a "mega-store" with revenues of $31.8 million. What are the estimated store costs for the mega store? Complete this question by entering your answers in the tabs below. 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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Waveney DIY Centers (WDC) operates a few dozen stores In the eastern Unlted 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 gettling better cost estlmates 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 InItlal thoughts of the managers and the financlal 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). Requlred: a. Use the high-low method to estimate the fixed and varlable portions of store costs based on store revenues. b. The managers in the reglon are Interested In opening a new store with expected revenues of $19.9 million. Assuming the data a cost estimates from the current stores are approprlate for the new store (SE-15), what are the estimated store costs for store SE- c. Managers are also considerIng a "mega-store" with revenues of $31.8 million. What are the estimated store costs for the mega store? Complete this question by entering your answers in the tabs below. 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 