Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last year's operations: Month Labor-Hours 11 123456789022 3,600 Machine-Hours 6,700 Overhead Costs $ 513,500 3,500 7,100 518,500 3,400 7,700 549,000 3,700 7,200 541,000 3,900 7,900 581,000 3,800 7,800 572,000 3,700 6,900 535,000 3,600 6,500 510,000 3,500 7,200 532,000 4,000 7,800 565,000 3,300 6,400 503,000 3,500 8,100 564,000 Required: Prepare a scattergraph based on the overhead and machine-hour data. 1. Click on a point to the right of the graph. 2. Click within the graph to place the point. 3. To enter exact coordinates, click on the point and then click on the processing wheel symbol and then enter the exact coordinates in the dialog box that pops up. 4. Click OK. Required: Prepare a scattergraph based on the overhead and machine-hour data. 1. Click on a point to the right of the graph. 2. Click within the graph to place the point. 3. To enter exact coordinates, click on the point and then click on the processing wheel symbol and then enter the exact coordinates in the dialog box that pops up. 4. Click OK. Methods of Estimating Costs-Scattergraph Adriana Corporation 600000 590000- 580000- 570000- 560000- 550000 540000 530000 Overhead costs 520000 510000 500000- 6300 6500 6700 6900 7100 7300 7500 7700 7900 8100 8300 Machine-Hours reset Month 1 Month 2 O Month 3 Month 4 Month 5 O Month 6 Month 7