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). 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 reglon are interested in opening a new store with expected area of 50,000 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 35,000 square feet. What are the gestimated store costs for the average concept store? Results from a regression of store costs on store area are as follows. Equation: Store costs =$3,025.02 (in thousands) +($0.176 Area) Statistical data Correlation coefficient R2 0.863 0.745 Required: The managers in the region are interested in opening a new store with expected area of 50,000 square feet. Assuming the cata and cost estimates from the current stores are appropriate for the new store (SE-18), what are the estimated store costs for store SE-18 using the results from this regression? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places. Results from a multiple regression of store costs on revenues and area are as follows. Equation: Store cost =$2,298,88( in thousands )+(60.08 Revenues )+($0.027 Area) Statistical data Correlation coefficient Adjusted R2 0.999 e. 999 Required: The managers in the region are interested in opening a new store with expected revenues of $19 million and expected area of 50,000 square feet. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-19), what are the estimated store costs for store SE-19 using the results from this regression? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places