Question
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 | $ 20,745 | 69,347 | $ 15,999 |
SE-02 | 15,682 | 51,617 | 12,695 |
SE-03 | 25,921 | 83,531 | 19,410 |
SE-04 | 19,589 | 67,574 | 15,279 |
SE-05 | 19,866 | 58,709 | 15,312 |
SE-06 | 17,956 | 67,574 | 14,299 |
SE-07 | 24,705 | 95,948 | 18,891 |
SE-08 | 12,901 | 46,298 | 10,947 |
SE-09 | 23,281 | 78,212 | 17,653 |
SE-10 | 16,030 | 62,255 | 13,064 |
SE-11 | 20,558 | 65,801 | 15,833 |
SE-12 | 17,320 | 72,893 | 13,997 |
SE-13 | 13,874 | 62,255 | 11,770 |
SE-14 | 23,104 | 74,666 | 17,494 |
Required:
Prepare a scattergraph based on the store cost and revenue data.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started