Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Proli Footwear Inc An Audit And Fraud Simulation For Team-Based Student Learning

Authors: Patricia Poli, Richard Proctor

2nd Edition

0615455492, 978-0615455495

More Books

Students also viewed these Accounting questions