Third exam - Assignment Example

John 150.0 16,200.00 523.81 16,723.81 523.81 16,000.00 Romeo Co Stachurski 206.0 22,866.00 437.64 23,303.64 0.00 22,608.85 Total 2374.5 281,396.25 11,584.67 292,711.42 9,598.95 269,788.74 Table 1 Table 1 shows the clients of ABC Consulting, the employees who work with the respective clients, the hours that these clients were billed, the reimbursable expenses (costs billed) relating to each worker, the total billed to each client, and the costs and fees collected from the clients to September 2013.

The total hours billed for the month was 2,374.5 hours and the total fees billed excluding reimbursable expenses was $281,396.25. . total hours billed = 254,665.13 ? 2,374.5 $107.25 Table 2 The information in Table 2 indicates that the overall cost per billable hour of operations for the month of September 2013 was $107.25. Effective Billable Hourly Rate per Worker The effective billable hourly rate per worker is found by dividing the fees collected from each client by the hours billed to that particular client.

The effective billable rate for each worker is shown in Table 3. Client Worker Hours Billed Fees Collected ($) Effective billable rate per hour ($) Alpha Co Acevedo 170.0 18,837.37 110.81 Bravo Co Barger 143.5 16,425.01 114.46 Charlie Co Ekundayo 120.0 14,250.00 118.75 Delta Co Fitzgerald 137.0 15,842.40 115.64 Echo Co Fyffe 85.5 12,825.00 150.00 Foxtrot Co Gilbert 112.5 12,150.00 108.00 Golf Co Harmon 98.0 10,780.00 110.00 Hotel Co Hefner 122.0 14,274.00 117.00 India Co Kirchner 150.0 16,560.00 110.40 Juliett Co Madorma 123.5 14,202.50 115.

00 Kilo Co Miller 102.0 11,268.04 110.47 Lima Co Myers 122.5 13,413.75 109.50 Mike Co Pellek 89.5 12,000.00 134.08 November Co Preston 156.0 16,818.71 107.81 Oscar Co Shahbazi 139.0 15,354.20 110.46 Papa Co Smith 147.5 16,178.91 109.69 Quebec Co St. John 150.0 16,000.00 106.67 Romeo Co Stachurski 206.0 22,608.85 109.75 Table 3 The information in Table 3 indicates that a total of six workers – Gilbert, Myers, Preston, Smith, St. John Stachurski exceeded the $110 benchmark. They achieved effective billable rates of $108, $109.5, $107.81, $109.69, $106.67 and $109.

7 per hour respectively, The effective billable rates per hour for September 2013 ranged between $106.67 and $150 and this information suggests that ABC Consulting recovered the company’s overall costs of $107.25 per billable hour on every job except Quebec Co which