The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie's Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost. Month July August September October November December January February March April May June July August September October November December January February March April May June Maintenance and Repair Cost (9000) Revenues ($000) $2.11 $55.00 3.08 49.00 2.60 45.00 2.01 61.00 2.10 73.00 0.94 101.00 2.92 41.00 2.96 47.00 2.82 57.00 2.78 59.00 1.84 63.00 1.58 75.00 2.40 69.00 1.82 63.00 2.37 71.00 2.18 73.00 1.23 83.00 0.56 113.00 2.38 57.00 2.08 59.00 1.49 79.00 1.75 83.00 1.75 69.00 1.45 65.00 Required: Using Excel, estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable. (Negative amounts should be indicated by a minus sign. Round "Multiple R. R Square and Standard CHA Tarimal minne AFARS DU Adorimin Using Excel, estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable (Negative amounts should be indicated by a minus sign. Round "Multiple R, R Square and Standard Error" to 7 decimal places, "Intercept and Revenues" to 4 decimal places.) Regression Statistics Multiple R R Square Standard Error Observations Coefficients Intercept Revenues 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 1 2 3 4 5 Labor-Hours Machine-Hours Overhead Costs 3,625 6,775 $513,435 3,575 7,035 518,960 3,400 7,600 549,575 3.700 7,265 541,400 3,900 7,955 581,145 3,775 7,895 572,320 3,700 6,950 535, 110 3,625 6,530 510, 470 3,550 7,270 532,195 3,975 7,725 565,335 3,375 6,490 503, 775 3,550 8,020 564,210 7 8 9 10 11 12 Required: a. Use the high-low method to estimate the fixed and variable portions of overhead costs based on machine-hours. b. Managers expect the plant to operate at a monthly average of 7,500 machine hours next year. What are the estimated monthly overhead costs, assuming no inflation? Complete this question by entering your answers in the tabs below. Required A Required B Required A Required B Use the high-low method to estimate the fixed and variable portions of overhead costs based on machine-hours. (Round "Variable cost" answer to 2 decimal places.) Variable cost (per machine hour) Fixed cost Required A Required B Managers expect the plant to operate at a monthly average of 7,500 machine-hours next year. What are the estimated monthly overhead costs, assuming no Inflation? Overhead costs
