Using the data provided in Data Task B worksheet, prepare a comparison of the 2019 overhead cost allocation under the existing costing system (a firm-wide overhead rate) with an ABC system. Using the proforma in Schedule 4 calculate the total amount of overhead that would be allocated to each service using (a) the current single overhead rate method and (b) an activity based costing method. You will need to complete your calculations in the worksheet provided Calculations for Schedule 4.

DATA FOR TASK B: 2018 BUDGETED DATA FOR THEADVISORY SERVICE Budgeted billable hours Cha 5000 hours of billable work rge out rate per hourS Professional labour $ Variable overhead $ Fixed overhead $ per billable hour 95.00 per billable hour 60,000 142,000 see 'overhead' note below Overhead costs: Budgeted Variable and Fixed overhead rates are determined by dividing the budgeted (fixed or variable)overhead by the budgeted billable hours. This rate is used to apply overhead to each job as it is performed and eventually billed to the client. 2018 ACTUAL COSTS FOR THE ADVISORY SERVICE Actual billable hours 5900 Charge out rate per hour S 210.00 per hour Actual professional hours worked 6000 97.00 per hour Actual professional hours paid$ Actual variable overhead$ Actual fixed overheads $ 56,000 162,000 ADDITIONAL DATA COLLECTED ON OVERHEAD COSTS FOR ABC CALCULATIONS 2019 Budgeted Overhead costs for T&K Solutions have been assigned to the following activity related cost pools: Budgeted Overhe ad costs Overhead Cost Pool: Facility related Technical Support Administrative Client Travel Advertising Overhead 96,000 24,000 160,000 82,000 48,000 Cost (activity) driver Total Expected Activity 380 sqm 136 requests Floor Space # of IT requests Billable hours Km's travelled # clients 14,130 billable hours 2320 knm 200 clients Bookkeeping 1,830 Advi Expected usage by division Billable hours Floor Space # IT requests Km's travelled # clients 5,600 130 46 330 73 6,700 195 75 1,910 108 15 80 19