person cash into Year 1 Year 2 Year 3 Salvage value (sold at end of year 3) 20,640 30,000 10,000 4,000 Determine the Internal Rate of return of this project (write your answer in percentage round up to two decimal points. For eg a rate of 835 percent should be written as 8 359) QUESTION 29 Lecouteur Corporation Regression is Lecouvreur Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs Discussions with the plant supervisor suggest that overhead sooms to vary with labor hours, machine-hours, or both. The following data were collected from fast year's operations Month 1 2 3 4 5 Labor-Hours 735 720 685 730 780 750 740 730 710 800 680 720 Machine Hours 1,354 1,409 1,518 1,453 1.585 1.572 1,393 1 309 1,463 1,541 1,292 1.618 Overhead Costs $ 102,785 103,798 109 931 108,370 116 214 114 545 107,011 102,035 108.374 113.156 103,384 117,076 9 10 11 12 Use Excel to compute regression coefficients to estimate the overhead cost equation (To make things easier, the data have already been entered into the spreadsheet above.) What is the estimate of monthly fixed overhead costs if labor-hours are assumed to be the driver of overhead costs? (Round answer to the nearest dollar) Chap 9 applications Open | | | | | | | | Chap applications O 1 person cash into Year 1 Year 2 Year 3 Salvage value (sold at end of year 3) 20,640 30,000 10,000 4,000 Determine the Internal Rate of return of this project (write your answer in percentage round up to two decimal points. For eg a rate of 835 percent should be written as 8 359) QUESTION 29 Lecouteur Corporation Regression is Lecouvreur Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs Discussions with the plant supervisor suggest that overhead sooms to vary with labor hours, machine-hours, or both. The following data were collected from fast year's operations Month 1 2 3 4 5 Labor-Hours 735 720 685 730 780 750 740 730 710 800 680 720 Machine Hours 1,354 1,409 1,518 1,453 1.585 1.572 1,393 1 309 1,463 1,541 1,292 1.618 Overhead Costs $ 102,785 103,798 109 931 108,370 116 214 114 545 107,011 102,035 108.374 113.156 103,384 117,076 9 10 11 12 Use Excel to compute regression coefficients to estimate the overhead cost equation (To make things easier, the data have already been entered into the spreadsheet above.) What is the estimate of monthly fixed overhead costs if labor-hours are assumed to be the driver of overhead costs? (Round answer to the nearest dollar) Chap 9 applications Open | | | | | | | | Chap applications O 1
