Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Rikki Bake, the controller for XYZ Incorporated, suspects that factory overhead costs are driven by the number of machine hours used. Using Excel, Ms. Bake
Rikki Bake, the controller for XYZ Incorporated, suspects that factory overhead costs are driven by the number of machine hours used. Using Excel, Ms. Bake input twelve months of historical data for total factory overhead costs and machine hours used. The summary output information is provided below. Use the output information provided to develop a cost formula for overhead cost.
SUMMARY OUTPUT 4 5 Regression Statistics Multiple R 0.963809718 R Square 0.928929173 Adjusted R Square 0.92182209 Standard Error 56.42709871 Observations 12 8 10 ANOVA SS MS F Significance F 130.7047086 4.6008E-07 12 Regression Residual Total 1 10 416166.0753 31840.17469 448006.25 416166.0753 3184.017469 14 11 15 Coefficients Standard Error Stat P-value Lower 95% Upper 95% Lower 95% Upper 95% 17 Intercept Machine Hours $970.12 415.4592475 36.1383.160962926 2.335045169 1 1.432616 0.0416902 4.6008E-07 44.41521808 29.09501101 1895.816999 43.18113962 44.41521808 1895.816999 29.0950110143.18113962 Complete the formula below. Round answers to two decimal places. Overhead Cost = $ x machine hours) +($Step 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