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$:

MonthMachine

HoursDirect Labor

HoursOverhead

CostJanuary$1981,810$$$17,610$February$1951,825$$$17,410$March$1971,788$$$17,735$April$1891,713$$$16,780$May$1921,738$$$17,240$June$1851,463$$$16,635$July$2031,938$$$17,700$August$1951,700$$$17,500$September$1981,813$$$17,775$October$2072,100$$$18,400$November$1921,938$$$16,805$December$2152,063$$$18,895$

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.