Grawburg Inc. maintains a call center to take orders, answer questions, and handle complaints. The costs of the call center for a number of recent months are listed below:

Calls Taken Call Center Cost : April 7560 $ 81,960 May 7529 $ 81,773 June 7570 $ 82,025 July 7568 $ 81,997 August 7535 $ 81,816 September 7549 $ 81,895 October 7592 $ 82,156 November 7579 $ 82,092

Management believes that the cost of the call center is a mixed cost that depends on the number of calls taken. The excel least squares regression output is as follows:

Using the output above identify the following:

1. What is the measure of goodness of fit? (round to 2 decimal place)

2. What is the variable cost per unit based on the regression equation? (round to 2 decimal place) $

3. What is the fixed cost portion of Inspection Costs? (round to 2 decimal place) $

4. Cost equation for Inspection Costs (in the linear equation format) Y= Estimated Inspection costs when 973 units are produced (round to nearest whole dollar) $

SUMMARY OUTPUT Regression Statistics MultipleR R Square Adjusted R Square Standard Error Observations 0.998198 0.996399 0.995799 8.52932 ANOVA MS nificance F Regression Residual Total 1 120783120783 1660.264 1.46E-08 6 436.4958 72.7493 7 121219.5 coefficientandard Err t Stat P-value Lower 95%Upper 95%ower 95.09 pper 95.0% 35914.19 1130.169 31.77772 6.45E-08 33148.76 38679.61 33148.76 38679.61 6.091077 0.149488 40.74633 1.46E-08 5.725293 6.45686 5.725293 6.45686 X Variable 1