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,445	70,047	$ 16,699
SE-02	16,382	52,317	13,395
SE-03	26,621	84,231	20,110
SE-04	20,289	68,274	15,979
SE-05	20,566	59,409	16,012
SE-06	18,656	68,274	14,999
SE-07	25,405	96,648	19,591
SE-08	13,601	46,998	11,647
SE-09	23,981	78,912	18,353
SE-10	16,730	62,955	13,764
SE-11	21,258	66,501	16,533
SE-12	18,020	73,593	14,697
SE-13	14,574	62,955	12,470
SE-14	23,804	75,366	18,194

Required:

1. Use the high-low method to estimate the fixed and variable portions of store costs based on store area.
2. The managers in the region are interested in opening a new store with expected area of 54,500 square feet. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-16), what are the estimated store costs for store SE-16?
3. Managers are also considering a concept store focused on downtown home and condo owners. These stores would have a much smaller area and carry a narrower range of products. The managers envision such stores being an average of 39,500 square feet. What are the estimated store costs for the average concept store?

Required information [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). Managers are also considering a concept store focused on downtown home and condo owners. These stores would have a much smaller area and carry a narrower range of products. The managers envision such stores being an average of 39,500 square feet. What are the estimated store costs for the average concept store? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places. Show less A a. Use the high-low method to estimate the fixed and variable portions of store costs based on store area. b. The managers in the region are interested in opening a new store with expected area of 54,500 square feet. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-16), what are the estimated store costs for store SE 16 ? c. Managers are also considering a concept store focused on downtown home and condo owners. These stores would have a much smaller area and carry a narrower range of products. The managers envision such stores being an average of 39,500 square feet. What are the estimated store costs for the average concept 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 area. Note: Round variable cost answer to 2 decimal places. Enter Fixed cost answer in thousands of dollars rounded to 2 decimal places. The managers in the region are interested in opening a new store with expected area of 54,500 square feet. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-16), what are the estimated store costs for store SE-16? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places. Show less A