Question: Interpreting Regression Output Rikki Bake, the controller for XYZ Incorporated, suspects that factory overhead costs are driven by the number of machine hours used. Using


Interpreting Regression Output 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. H o G 1 SUMMARY OUTPUT Regression Statistics Multi 0.06.2018 5 RSD 002800173 6 Add 0.92162200 7 Standard 0.427 # Ovation 12 . 10 ANOVA 11 ss MS 12 Region . 4161660760 4161660753 19 Ful 10 1140.17400 16.017460 1 To 11 44800625 15 Coefficients Standard Error 11 Intercept 8070.12 415.4500475 2.336045160 10 Machine Hours 3.1000000 11:482016 Significance F 4. ONE OF 1307047 value GOCO 4.color Lower 14.4151 100001101 Upper Lower 180 16000 44.4152100 4310113022000601101 Upwo 18061 1:100000 Complete the formula below. Round answers to two decimal places. Overhead Cost = $ x machine hours) +($ Check Previous Save Answers Next
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
