eBook Show Me How Office 365 Print Item Predetermined Factory Overhead Rate Turbo Shop uses job order costing to determine the cost of performing engine repair work. Estimated costs and expenses for the coming period are as follows: Engine parts Shop direct labor $1,008,300 736,000 Shop and repair equipment depreciation 35,600 Shop supervisor salaries 99,000 Shop property taxes 18,000 Shop supplies 13,800 Advertising expense 20,200 Administrative office salaries 86,700 Administrative office depreciation expense Total costs and expenses 11,100. $2,028,700 The average shop direct labor rate is $23.00 per hour. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine the predetermined shop overhead rate per direct labor hour. Round the answer to nearest whole cent. per direct labor hour B C D 1 Predetermined factory overhead rate 2 Turbo Shop uses job order costing to determine the cost of performing engine repair work. Estimated costs and expenses for the coming period are as follows: 3 DATA 4 Engine parts 5 Shop direct labor 6 Shop and repair equipment depreciation 7 Shop supervisor salaries 8 Shop property taxes 9 Shop supplies 10 Advertising expense 11 Administrative office salaries 12 Administrative office depreciation expense 13 Total costs and expenses 14 15 The average shop direct labor rate per hour 16 17 REQUIRED: $1,008,300 736,000 35,600 99.000 18,000 13,800 20,200 86,700 11,100 $2,028,700 $23.00 18 Determine the predetermined shop overhead rate per direct labor hour 19 20 Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWV2 for grading 21 Estimated shop overhead 22 Estimated activity base o 23 Predetermined shop overhead rate per direct labor hour Formulas 24 25 26 27 70 Data Calculation Mode: Automatic Workbook Statistics