Please awesome questions 5-37, 5-38 and 5-40 as they all relate to the same reference. The chart at the very top is the reference for the data of Adriana Corporation (Exercise 5-36)

208 Partil Cost Analysis and Estimation Overhead Costs Labor-Hours Machine-Hours Month 1 2 3 4 5 6 7 8 9 10 11 12 3,625 3,575 3,400 3,700 3,900 3.775 3,700 3,625 3,550 3,975 3,375 3,550 6,775 7.035 7,600 7.265 7.955 7,895 6,950 6,530 7.270 7,725 6.490 8,020 $513,435 518,960 549,575 541,400 581.145 572,320 535.110 510,470 532,195 565,335 503.775 564.210 ar (LO 5-4) 5-37. Methods of Estimating Costs: Scattergraph Prepare a scattergraph based on the overhead and machine-hour data in Exercise 5-36. (LO 5.4) 5-38. Methods of Estimating Costs: Scattergraph Prepare a scattergraph based on the overhead and labor-hour data in Exercise 5-36. 22 WS (LO 5-5) 5-40. Methods of Estimating Costs: Simple Regression Simple regression results from the data of Adriana Corporation (Exercise 5-36) are as follows. Equation: Overhead = $217,610 + ($88.61 x Labor-hours) Statistical data Correlation coefficient. R2.. .610 .372 Required Estimate overhead if the company expects the plant to operate at a monthly average of 3,000 labor hours next year