Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The controller for TG Enterprises is trying to determine whether direct labor hours or machine hours is driving the companys overhead cost. He collected the
The controller for TG Enterprises is trying to determine whether direct labor hours or machine hours is driving the companys overhead cost. He collected the following data on the number of direct labor hours, the number of machine hours, and the associated factory overhead cost for the year 2018:
Month January February March April May June July August September October November December Machine Direct Labor Overhead Hours Hours Cost 198 1,810 $17,610 195 1,825 $17,410 197 1,788 $17,735 189 1,713 $16,780 192 1,738 $17,240 185 1,463 $16,635 203 1,938 $17,700 195 1,700 $17,500 198 1,813 $17,775 207 2,100 $18,400 1,938 $16,805 215 2,063 $18,895 192 Required a. Using Excel, run a regression on these data using machine hours as the independent variable. Provide the cost formula for overhead cost. Round fixed and variable costs to the nearest cent. Total cost = $ 0 + ($ 0 x machine hours) b. Using Excel, run a regression on these data using direct labor hours as the independent variable. Provide the cost formula for overhead cost. Round the fixed and variable costs to the nearest cent. Total cost = $ 0 + ($ 0 x direct labor hours) c. What is the R2 for the regression in requirement a? What is the R2 for the regression in requirement b? (Round answers to three decimal places.) a. 0 b. 0 Which independent variable, direct labor hours or machine hours, is a better predictor of factory overhead cost? Direct labor hours Machine hours ited January 2019 machine hours are 212, what is expected factory overhead cost using the cost formula in requirement a? (Note: Round to the nearest dollar.) $ 0
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