Your company is preparing an estimate of its production costs for the coming period. The controller estimates that direct materials costs are $30 per unit and that direct labor costs are $20 per hour. Estimating overhead, which is applied on the basis of direct labor costs, is difficult The controller's office estimated overhead costs at $3,700 for fixed costs and $14 per unit for variable costs. Your colleague, Lance, who graduated from a rival school, has already done the analysis and reports the "correct" cost equation as follows. Overhead $10,548+ $16.06 per unit Lance also reports that the correlation coefficient for the regression is 0.82 and says, "With 82% of the variation in overhead explained by the equation, it certainly should be adopted as the best basis for estimating costs. When asked for the data used to generate the regression, Lance produces the following Month Overhead Unit Production 1 $57,101 3,040 2 60,689 3,250 3 77,278 4,180 A 56,633 3,010 5 81,400 3,410 6 72,364 3,920 7 63,763 3,340 8 73,791 4,020 9 77,655 4,130 10 60,187 3,200 11 61,588 3,370 12 73,986 4,090 13 73,234 3,090 The company controller is somewhat surprised that the cost estimates are so different. You have therefore been assigned to check Lance's equation. You accept the assignment with glee. Required: Prepare a scattergraph relating overhead cost to the number of units produced. Instructions: 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. Interpretation of Regression Results-Simple Regression $85,000- $80,000- $75,000- Overhead Cost $70,000- $65,000- $60,000- $55,000- Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 $50,000- 2.800 3,000 3,200 3,400 3,600 3,800 4.000 4,200 4,400 Month 7 Unit Production reset Removing any outliers identified in the scattergraph, use Excel to perform a new regression analysis. (Round "Intercept" value to 5 decimal places and "Unit Production" to 7 decimal places.) Coefficients Intercept Unit production What is the cost equation with the new results? (Round variable costs per unit to 2 decimal places.) Overhead cost Units