Excel 2013 Skills Approach - 3.1
nklum1
-ex2013-skillreview-3-1.xlsxSmith Bill
| Client Bill | |||
| Due Date | |||
| Client Name | Smith | ||
| Staff Members | Hours Billed | Rate | Bill Amount |
| Marshall | ERROR:#N/A | ERROR:#N/A | |
| Stevens | ERROR:#N/A | ERROR:#N/A | |
| Luz | ERROR:#N/A | ERROR:#N/A | |
| Total | ERROR:#N/A | ||
| Payment Plan Option | |||
| # of Months | 6 | ||
| APR | 2% | ||
| Monthy Payment |
Marshall Hours
| Legal Staff Billable Hours Log | |||||||||
| Employee Name | Required billable hours per week: | 35 | |||||||
| Employee Number | 265 | Weekly requirement met? | |||||||
| Billable Rate | |||||||||
| Dates Worked | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Weekly total per client | |
| 1/14/13 | 1/15/13 | 1/16/13 | 1/17/13 | 1/18/13 | 1/19/13 | 1/20/13 | |||
| Clients | |||||||||
| Aturo | 2.00 | 2.50 | 3.50 | 1.00 | 2.00 | 11.00 | |||
| Hudson | 3.50 | 3.50 | 0.50 | 2.25 | 9.75 | ||||
| Proctor | 2.25 | 2.25 | 2.25 | 2.25 | 2.25 | 11.25 | |||
| Smith | 3.50 | 3.50 | 3.50 | 10.50 | |||||
| Total Billable Hours Per Day | 7.75 | 8.25 | 5.75 | 6.25 | 6.75 | 4.25 | 3.50 | ||
| Daily Bill | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Bill Total for Week | $ - 0 | ||||||||
| # of Clients Served Each Day | |||||||||
| Average Daily Billable Hours | |||||||||
| Total Billable Hours for Week | |||||||||
| Lowest Daily Bill this Week | |||||||||
| Highest Daily Bill this Week | |||||||||
Luz Hours
| Legal Staff Billable Hours Log | |||||||||
| Employee Name | Maria Luz | Required billable hours per week: | 35 | ||||||
| Employee Number | 7896 | Weekly requirement met? | yes | ||||||
| Billable Rate | ERROR:#NAME? | ||||||||
| Dates Worked | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Weekly total per client | |
| 1/14/13 | 1/15/13 | 1/16/13 | 1/17/13 | 1/18/13 | 1/19/13 | 1/20/13 | |||
| Clients | |||||||||
| Aturo | 2.00 | 0.50 | 3.50 | 1.00 | 2.00 | 9.00 | |||
| Hudson | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 6.00 | ||
| Proctor | 2.25 | 2.25 | 2.25 | 2.25 | 2.25 | 2.25 | 13.50 | ||
| Smith | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 12.50 | |||
| Total Billable Hours Per Day | 5.25 | 5.75 | 6.25 | 9.25 | 6.75 | 7.75 | - 0 | ||
| Daily Bill | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ||
| Bill Total for Week | ERROR:#NAME? | ||||||||
| # of Clients Served Each Day | 3 | 3 | 4 | 4 | 4 | 4 | 0 | ||
| Average Daily Billable Hours | 5.86 | ||||||||
| Total Billable Hours for Week | 41.00 | ||||||||
| Lowest Daily Bill this Week | ERROR:#NAME? | ||||||||
| Highest Daily Bill this Week | ERROR:#NAME? | ||||||||
Stevens Hours
| Legal Staff Billable Hours Log | |||||||||
| Employee Name | William Stevens | Required billable hours per week: | 35 | ||||||
| Employee Number | 1554 | Weekly requirement met? | no | ||||||
| Billable Rate | ERROR:#NAME? | ||||||||
| Dates Worked | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Weekly total per client | |
| 1/14/13 | 1/15/13 | 1/16/13 | 1/17/13 | 1/18/13 | 1/19/13 | 1/20/13 | |||
| Clients | |||||||||
| Aturo | 2.00 | 1.00 | 0.50 | 1.00 | 4.50 | ||||
| Hudson | 3.50 | 3.50 | 7.00 | ||||||
| Proctor | 2.25 | 2.25 | 2.25 | 2.25 | 2.25 | 11.25 | |||
| Smith | 2.50 | 4.25 | 6.75 | ||||||
| Total Billable Hours Per Day | 7.75 | 5.75 | 2.75 | 5.75 | 7.50 | - 0 | - 0 | ||
| Daily Bill | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ||
| Bill Total for Week | ERROR:#NAME? | ||||||||
| # of Clients Served Each Day | 3 | 3 | 2 | 2 | 3 | 0 | 0 | ||
| Average Daily Billable Hours | 4.21 | ||||||||
| Total Billable Hours for Week | 29.50 | ||||||||
| Lowest Daily Bill this Week | ERROR:#NAME? | ||||||||
| Highest Daily Bill this Week | ERROR:#NAME? | ||||||||
Rates
| Current Hourly Rates | |||
| Employee # | Last Name | First Name | Rate |
| 265 | Marshall | David | $ 50 |
| 1554 | Stevens | William | $ 85 |
| 7896 | Luz | Maria | $ 150 |
| CONFIDENTIAL |
