Question
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
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) Y=
Estimated Inspection costs when 973 units are produced (round to nearest whole dollar) $
SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.998198 0.996399 0.995799 8.52932 ANOVA df gnificance F MS F Regression Residual Total 1 120783 120783 1660.264 1.46E-08 6 436.4958 72.7493 7 121219.5 Intercept X Variable 1 coefficientandard Err tstat P-value Lower 95%Upper 95%ower 95.09 pper 95.0% 35914.19 1130.169 31.77772 6.45E-08 33148.7638679.61 33148.76 38679.61 6.091077 0.149488 40.74633 1.46E-08 5.7252936.45686 5.725293 6.45686Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started