Excel Homework
axedberfex2013-skillreview-3-1.xlsx
Smith 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 |