Using the data provided in the Data Task B worksheet, complete the flexible budget for T&K Solutions Advisory Service using the proforma in Schedule 2

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 Overhead Costs Overhead Cost Pool: Cost (activity) driver Total Expected Activity Facility related Technical Support Administrative Client Travel Advertising 96,000 24,000 160,000 82,000 48,000 Floor Space # of IT requests Billable hours Km's travelled # clients 380 sqm 136 requests 14,130 billable hours 2320 km 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