60.1K

Verified Solution

Link Copied!

Question 2 options:

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:

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

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

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

Cost equation for Inspection Costs (in the linear equation format)

Estimated Inspection costs when 973 units are produced (round to nearest whole dollar)

SUMMARY OUTPUT Regression Statistics Multiple R 0.998198 R Square 0.996399 Adjusted R Square 0.995799 Standard Error 8.52932 Observations 8 ANOVA df SS Regression Residual Total 1 120783 6 436.4958 7 121219.5 MS F gnificance F 120783 1660.264 1.46E-08 72.7493 Intercept X Variable 1 Coefficientsandard Err t Stat P-value Lower 95%Upper 95%ower 95.0%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

Answer & Explanation Solved by verified expert

See Answer