Question

2 2018 BUDGETED DATA FOR THE ADVISORY SERVICE Budgeted billable hours 5000 hours of billable work Charge out rate per hour S Professional labour $ Variable overhead $ Fixed overhead $ 95. 60,000 142,000 210.00 per billable hour 00 per billable hour see 'overhead' note below 8 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 opply overhead to each job as it is performed and eventually billed to the client. 2 2018 ACTUAL COSTS FOR THE ADVISORY SERVICE Actual billable hours 5900 Cha rgeout rate per hourS 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 0 1 ADDITIONAL DATA COLLECTED ON OVERHEAD COSTS FOR ABC CALCULATIONS 2 2019 Budgeted Overhead costs for T&K Solutions have been assigned to the following activity related cost pools: Budgeted Overhead Costs Overhead Cost Pool: Cost (activity) driver Total Expected Activity 380 sqm Facility related Technical Support Administrative Client Travel Advertising 96,000 24,000 160,000 82,000 48,000 Floor Space # of IT request Billable hours Km's travelled # clients 136 requests 14,130 billable hours 2320 km 200 clients Expected usage by division Billable hours Floor Space # IT requests Km's travelled # clients Bookkeeping 1,830 Advi 5,600 130 46 330 73 15 80 19 6,700 195 75 1,910 108 6

shedule 3

Answer 1

Total hrs Existing overhead allocation Budgeted hours Total overhead Predetermined ohd rate Overhead allocated(hrs rate) Tax Book keeping 1,830.00 Advis 5,600.00 6,700.00 14,130.00 410,000.00 29.02 ($410,000/14,130) 162,491.15 53,099.79194,409.06 410,000.00 Activity based costing allocation of overhead costs Activit service Cost service Activit Cost Cost driver Total cost driver Cost per cost dri Tax Book keeping Advis Tax Book keeping Advis Facility related Technical Support Administrative Client Travel Advertisin Total $ 96,000.00 Floor space 380 sqm $ 24,000.00 IT requests 136 requests $ $160,000.00 Billable hrs14130 hrs $ 82,000.00 Kms travelled 2320 km $ 48,000.00 Clients 252.63 176.47 130.00 46.00 11.32 5,600.00 35.34 330.00 73.00 55.00195.00 32,842.11 8,117.65 1,830.00 6,700.00 63,411.18 80.00 1,910.00 11,663.79 19.00 108.00 17,520.00 133,554.73 13,894.74 49,263.16 2,647.06 13,235.29 20,721.87 75,866.95 2,827.59 67,508.62 4,560.00 25,920.00 44,651.25 231,794.02 15.00 75.00 200 clients 240.00 410,000.00