Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and wants to estimate overhead costs accurately to plan its operations and its financial needs. Interviews with plant personnel and studies reported in trade publications suggest that overhead in this industry tends to vary with labor hours. A member of the controller's staff proposed that the behavior pattern of these overhead costs be determined to improve cost estimation. Another staff member suggested that a good starting place for determining cost behavior patterns is to analyze historical data. Following this suggestion, monthly data were gathered on labor-hours and overhead costs for the past two years. No major changes in operations occurred over this period of time. The data are shown in the following table, Month 1 2 5 6 7 9 10 13 12 Labor Hours Overhead Costs 251,590 $2,741,420 238,490 2,375,330 192,500 2,400,250 271,400 2,590,810 323,900 3,071,920 290,990 2,613,270 271,400 2,480,360 251,610 2,745,660 221,950 2,521,450 343,550 3.47,810 185.990 2,252,440 231, 9:40 2,550,700 382,560 3,683,820 176,400 3,404,890 290,980 3,016,600 395,00 3,638,440 356,610 3,554,000 323,810 3,191,720 389,415 3,481,320 117.240 2,219,620 343,500 >,495,530 136,530 9,207,60 382,870 3,680, 710 376,10 3,636,750 15 16 17 13 19 20 21 22 24 Required: o. Use the high low estimation method to estimate the overhead cost behavior (fixed and variable portions components of cost) for the Lucas plant c. Using Excel, compute regression coefficients to describe the overhead cost equation d. Use the results of your regression analysis to develop an estimate of overhead costs assuming 380,000 labor hours will be worked next month, Complete this question by entering your answers in the tabs below. Required A Required Required D Use the high-low estimation method to estimate the overhead cost behavior (fixed and variable portions components of cost) for the Lucas plant. (Round variable cost per unit to 2 decimal places) O cons por LH Labor hours FMSA Required