please include formulas and steps
The polishing department of Taylor Manufacturing Company operated during April 2016 with the following manufacturing overhead cost budget based on 5,000 hours of monthly productive capacity: Taylor Manufacturing Company Polishing Department Overhead Budget (5,000 Hours) For the Month of April 2016 Variable costs Factory supplies Indirect labor Utilities Patent royalties on secret process 100,000 152,000 68,000 296,000 Total variable overhead 616,000 Fixed costs: Supervisory salaries Depreciation on factory equipment Factory taxes Factory insurance Utilities (base charge) 160,000 144,000 48,000 32.000 80,000 464,000 Total fixed overhead $1,080,000 Total manufacturing overhead The polishing department was operated for 4,700 hours during April and incurred the following manufacturing overhead costs Factory supplies Indirect labor Utilities (usage factor) Utilities (base factor) Patent royalties Supervisory salaries Depreciation on factory equipment Factory taxes Factory insurance Total manufacturing overhead incurred $1,095,046 597,570 136,210 82.800 96,000 280,466 169,000 144,000 57,000 32,000 Using a flexible budgeting approach, prepare a performance report for the polishing department for April 2016, comparing actual overhead costs with budgeted overhead costs for 4,700 hours. Separate overhead costs into variable and fixed components and show the amounts of any variances between actual and budgeted amounts. Do not use negative signs with your answers below. Do not round until your final answer. Round answers to nearest whole number, if applicable. Select either U for Unfavorable or F for Favorable using the drop down box next to each of your variance answers. Taylor Manufacturing Company Polishing Department Performance Report- Manufacturing Overhead For the Month Ended April 30, 2016 Budget (4,700 hours) Actual Costs Variable costs: Factory supplies 97,520 92,000 5.520 Indirect labor 136,160 139,840 3.680 F 82,800 62,560 20,240 u Utilities 280,466 272,320 8,096 Patent royalties Total 596,896 566,720 30.176U variable overhead Fixed costs: Supervisory salaries 0 Depreciation on equipment Factory taxes Factory insurance Utilities Utilities Total fixed overhead Total overhead costs 0