Numbers File Edit Insert Table Organize Format Arrange View Share Window Help 114% Account Ac View Zoom Add Category Assessment 2 Part 1 Assessment 2 Part 2 A B C 4 Untitled (cf_assessment2_template 2 copy) + Insert T Table Chart Text Shape Media Comment Assessment 2 Part 3 D E T U Your company provides a variety of delivery services. Management wants to know the volume of a particular delivery that would generate $11,000 per month in operating profits before taxes. The company charges $22 per delivery. The controller's office has estimated overhead costs at $9,900 per month for fixed costs and $12 per delivery for variable costs. You believe that the company should use regression analysis. Your analysis shows the results to be: Monthly overhead=$26,501+$10.70 per Your estimate was based on the following data: Overhead Costs 5 6 Month Number of Deliveries 7 1 $ 159,630.00 12510 8 2 183,990 15060 9 3 142,860 11430 10 4 194,430 15450 11 5 151,890 12180 12 6 150,120 11970 13 7 192,600 15660 14 8 154,080 12630 15 9 141,030 11250 16 10 184,800 15300 17 11 203,490 12780 802222 18 12 183,120 14580 19 13 180,630 14730 21 REQUIRED 23 The company controller is somewhat surprised that your cost estimates are so different from the controller's. You have been asked to recheck your work and see if you can figure out the difference between your results and the controller's results. 24 Regression Statistics Coefficients 25 Multiple R 0.99213093078357 Intercept $ 9,776.56 26 R Square 0.984323783817473 Cost per delivery $ 11.69 27 Adjusted R Square 0.98275616219922 28 Standard Error 2635.65966087896 29 Observations 12 30 2. Write a report that informs management about the correct volume that will generate $11,000 per month in operating profits before taxes. NOV 21 1 "