Question
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
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.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