Excel

profileQueenQuanna
EX2019-SkillReview-3-12.xlsx
Home>Education homework help>Excel

Smith Bill

Client Bill
Due Date
Client Name Smith
Staff Members Hours Billed Rate Bill Amount
Lutz ERROR:#N/A ERROR:#N/A
Marshall ERROR:#N/A ERROR:#N/A
Stevens ERROR:#N/A ERROR:#N/A
Total ERROR:#N/A
Payment Plan Option
# of Months 9
APR 3%
Monthy Payment

Lutz Hours

Legal Staff Billable Hours Log
Employee Name Maria Lutz 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
10/17/19 10/18/19 10/19/19 10/20/19 10/21/19 10/22/19 10/23/19
Clients
Aturo 1.50 0.50 3.00 2.00 2.50 9.50
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.00 2.00 2.00 2.00 2.00 10.00
Total Billable Hours Per Day 4.75 5.25 5.75 8.25 7.25 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.57
Total Billable Hours for Week 39.00
Lowest Daily Bill this Week ERROR:#NAME?
Highest Daily Bill this Week ERROR:#NAME?

Marshall Hours

Legal Staff Billable Hours Log
Employee Name Required billable hours per week: 35
Employee Number 272 Weekly requirement met?
Billable Rate
Dates Worked Mon Tue Wed Thu Fri Sat Sun Weekly total per client
10/17/19 10/18/19 10/19/19 10/20/19 10/21/19 10/22/19 10/23/19
Clients
Aturo 2.50 3.00 2.00 3.50 1.00 12.00
Hudson 3.00 3.50 1.00 2.00 9.50
Proctor 2.50 2.25 1.50 2.25 2.50 11.00
Smith 3.00 3.00 3.00 9.00
Total Billable Hours Per Day 8.00 8.75 4.50 5.25 9.00 3.00 3.00
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

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
10/17/19 10/18/19 10/19/19 10/20/19 10/21/19 10/22/19 10/23/19
Clients
Aturo 1.00 1.00 1.00 1.00 4.00
Hudson 3.50 3.50 7.00
Proctor 2.50 2.50 2.50 2.50 2.50 12.50
Smith 3.00 4.00 7.00
Total Billable Hours Per Day 7.00 6.50 3.50 6.00 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.36
Total Billable Hours for Week 30.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
7896 Lutz Maria $ 150
272 Marshall David $ 80
1554 Stevens William $ 100
CONFIDENTIAL