197 The controller for TG Enterprises is trying to determine whether direct labor hours or machine hours is driving the company's 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 Machine Direct Labor Overhead Month Hours Hours Cost January 199 1810 $17.610 February 195 1.825 572410 M 1.788 $17.735 April 10 1,212 51.700 May 1,738 $17.240 June TE 1.463 STS 203 1.338 51.700 August 105 1.700 $17.500 September TO $17.725 October 202 2.100 SR400 November 192 5160S December 215 11 Required Using Excel, una 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 cos x machine hours) b. Using Excel. una regression on these data using direct labor hours as the independent variable 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 costs +($ x direct labor hours) c. What is the R for the regression in requirement a? What is the R for the regression in requirement b? (Round answers to three decimal places.) a. . Which independent variable, direct labor hours or machine hours, is a better predictor of factory overhead cost? d. Assuming that expected 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)