Description
Submit the following files:
- 1-RSServRpt-3.xlsx
- 1-VRPay-Oct30.xlsx
- 1-BillingsOct4to8.xlsx
- Analysis document (Microsoft Word)
For your essay:
- Choose any of the assignments for this week to analyze
- Essay length – 200 words
- What insights do you have about the data presented in the spreadsheet? Are there any anomalies or interesting facts you see?
- What kinds of decisions can you make from the data, or what recommendations can you make to improve the business, process, etc. that is presented in the spreadsheet?
- What can be changed to improve the worksheet? Why would your recommendation be an improvement?
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions.
O'Donovan & Sullivan Law Associates
BILLING SUMMARY
OCTOBER 4 TO 8, 2021
File
EP-652
EL-632
CL-501
IN-745
CL-412
IN-801
RE-501
FL-325
CL-412
IN-745
RE-475
CL-521
PL-348
RE-492
EL-632
PL-512
FL-385
CL-450
EP-685
Client
10106
10225
10341
10210
10125
10346
10384
10104
10125
10210
10285
10334
10420
10425
10225
10290
10278
10358
10495
Date
Billing Code Attorney Code
10/4/2021
Amicus#- 3
1
10/5/2021
Amicus#- 5
3
10/6/2021
Amicus#- 1
2
10/7/2021
Amicus#- 6
3
10/8/2021
Amicus#- 1
2
10/8/2021
Amicus#- 6
3
10/8/2021
Amicus#- 4
4
10/4/2021
Amicus#- 2
1
10/4/2021
Amicus#- 1
2
10/5/2021
Amicus#- 6
3
10/5/2021
Amicus#- 4
4
10/6/2021
Amicus#- 1
2
10/6/2021
Amicus#- 7
3
10/6/2021
Amicus#- 4
4
10/7/2021
Amicus#- 5
3
10/7/2021
Amicus#- 7
3
10/7/2021
Amicus#- 2
1
10/8/2021
Amicus#- 1
2
10/8/2021
Amicus#- 3
3
Legal Fees Disbursements Total Due
1,028.50
23.75
1,052.25
1,211.00
37.85
1,248.85
1,143.75
55.24
1,198.99
1,450.00
24.25
1,474.25
1,143.75
38.12
1,181.87
1,425.00
62.18
1,487.18
1,237.50
34.28
1,271.78
2,273.75
95.10
2,368.85
2,493.75
55.40
2,549.15
2,425.00
65.20
2,490.20
3,807.00
48.96
3,855.96
1,518.75
27.85
1,546.60
2,500.00
34.95
2,534.95
2,043.00
38.75
2,081.75
2,300.00
42.15
2,342.15
1,620.00
65.15
1,685.15
2,040.00
85.47
2,125.47
1,762.50
55.24
1,817.74
2,375.00
94.55
2,469.55
Billing Code Table
Code
Area of Practice
1
Corporate
2
Divorce & Separation
3
Wills & Estates
4
Real Estate
5
Employment Litigation
6
Insurance Personal Injury
7
Other
Code
1
2
3
4
Attorney Code Table
Attorney
Marty O'Donovan
Toni Sullivan
Rosa Martinez
Kyle Williams
RSR Computer Services
Service Division Report
Work Order
Number
Date
9/1/2021
65012
9/3/2021
65013
9/7/2021
65014
9/7/2021
65015
9/10/2021
65016
9/13/2021
65017
9/14/2021
65018
9/17/2021
65019
9/17/2021
65020
9/20/2021
65021
9/22/2021
65022
9/22/2021
65023
9/23/2021
65024
9/27/2021
65025
9/28/2021
65026
9/28/2021
65027
9/30/2021
65028
TOTAL SERVICE HOURS BILLED:
September
Hours
Rate
Billed
Code
2 1/4
1
3 1/4
3
2 1/4
1
1 3/4
3
1 1/2
3
2 1/4
1
4 1/4
1
3 3/4
1
1 3/4
2
2
3
1 1/2
3
2 1/4
1
3 1/4
1
3 1/2
3
2 3/4
3
3 1/2
2
4 1/2
1
46 1/4
Extended
Labor
101.25
227.50
101.25
122.50
105.00
101.25
191.25
168.75
105.00
140.00
105.00
101.25
146.25
245.00
192.50
210.00
202.50
2,566.25
Parts
22.50
75.85
28.95
25.75
45.15
55.85
22.50
18.50
75.85
187.50
110.50
35.95
47.66
752.51
Total
Invoice
123.75
303.35
130.20
122.50
130.75
146.40
247.10
191.25
105.00
140.00
123.50
177.10
146.25
432.50
303.00
245.95
250.16
3,318.76
202201082305291_rsrservrpt Sep
Rate Code Chart
Description
Regular
Evening
Weekend
Code
1
2
3
Rate
$ 45.00
$ 60.00
$ 70.00
RSR Computer Services
Service Division Report
Work Order
Number
Date
10/4/2021
65029
10/5/2021
65030
10/7/2021
65031
10/7/2021
65032
10/11/2021
65033
10/12/2021
65034
12/13/2021
65035
10/18/2021
65036
10/18/2021
65037
10/19/2021
65038
10/21/2021
65039
10/22/2021
65040
10/25/2021
65041
10/25/2021
65042
10/27/2021
65043
10/28/2021
65044
10/28/2021
65045
TOTAL SERVICE HOURS BILLED:
October
Hours
Rate
Billed
Code
2 1/4
1
3 1/4
2
2 1/4
1
1 3/4
1
1 1/2
1
2 1/4
3
1 3/4
3
3 3/4
1
1 3/4
2
2
1
1 1/2
2
2 1/4
1
3 1/4
3
3 1/2
1
2 3/4
2
1 1/2
2
4 1/2
3
41 3/4
Extended
Labor
101.25
195.00
101.25
78.75
67.50
157.50
122.50
168.75
105.00
90.00
90.00
101.25
227.50
157.50
165.00
90.00
315.00
2,333.75
Parts
22.50
75.85
28.95
25.75
45.15
56.85
22.50
18.50
75.85
112.50
187.50
110.50
47.66
830.06
Total
Invoice
123.75
270.85
130.20
78.75
93.25
202.65
179.35
191.25
105.00
90.00
108.50
177.10
340.00
345.00
275.50
90.00
362.66
3,163.81
202201082305291_rsrservrpt Oct
Rate Code Chart
Description
Regular
Evening
Weekend
Code
1
2
3
Rate
$ 45.00
$ 60.00
$ 70.00
RSR Computer Services
Service Division Report
Date
11/8/2021
11/8/2021
11/9/2021
11/12/2021
11/15/2021
11/15/2021
11/17/2021
Work Order
Number
65049
65050
65051
65052
65053
65054
65055
November
Hours
Rate
Billed
Code
1 3/4
1
1 1/2
1
2 1/4
3
4 1/4
3
3 3/4
1
1 3/4
2
2
1
Extended
Labor
78.75
67.50
157.50
297.50
168.75
105.00
90.00
Parts
25.75
45.15
55.85
22.50
-
Total
Invoice
78.75
93.25
202.65
353.35
191.25
105.00
90.00
202201082305291_rsrservrpt Nov
Rate Code Chart
Weekend
3
$ 70.00
RSR Computer Services
Service Division Report
Work Order
Number
Date
12/1/2021
65063
12/2/2021
65064
12/6/2021
65065
12/6/2021
65066
12/9/2021
65067
12/10/2021
65068
12/14/2021
65069
12/16/2021
65070
12/16/2021
65071
12/17/2021
65072
12/20/2021
65073
12/21/2021
65074
12/22/2021
65075
12/27/2021
65076
12/27/2021
65077
12/28/2021
65078
12/29/2021
65079
TOTAL SERVICE HOURS BILLED:
December
Hours
Rate
Billed
Code
2 1/4
1
1 1/2
3
2 1/4
1
1 3/4
3
1 1/2
3
2 1/4
1
4 1/4
2
3 3/4
1
1 3/4
2
2
3
1 1/2
3
2 1/4
1
3 1/4
1
3 1/2
3
1 1/2
3
3 1/2
1
4 1/2
1
43 1/4
Extended
Labor
101.25
105.00
101.25
122.50
105.00
101.25
255.00
168.75
105.00
140.00
105.00
101.25
146.25
245.00
105.00
157.50
202.50
2,367.50
Parts
22.50
110.23
28.95
25.75
45.15
55.85
22.50
18.50
75.85
112.50
187.50
75.85
47.66
828.79
Total
Invoice
123.75
215.23
130.20
122.50
130.75
146.40
310.85
191.25
105.00
140.00
123.50
177.10
258.75
432.50
180.85
157.50
250.16
3,196.29
202201082305291_rsrservrpt Dec
Rate Code Chart
Description
Regular
Evening
Weekend
Code
1
2
3
Rate
$ 45.00
$ 60.00
$ 70.00
RSR Computer Services
Service Division Report
Work Order
Number
Date
9/1/2021
RSR-65012
9/3/2021
RSR-65013
9/7/2021
RSR-65014
9/7/2021
RSR-65015
9/10/2021
RSR-65016
9/13/2021
RSR-65017
9/14/2021
RSR-65018
9/17/2021
RSR-65019
9/17/2021
RSR-65020
9/20/2021
RSR-65021
9/22/2021
RSR-65022
9/22/2021
RSR-65023
9/23/2021
RSR-65024
9/27/2021
RSR-65025
9/28/2021
RSR-65026
9/28/2021
RSR-65027
9/30/2021
RSR-65028
TOTAL SERVICE HOURS BILLED:
September
Hours
Rate
Billed
Code
2 1/4 hrs
1
3 1/4 hrs
3
2 1/4 hrs
1
1 3/4 hrs
3
1 1/2 hrs
3
2 1/4 hrs
1
4 1/4 hrs
1
3 3/4 hrs
1
1 3/4 hrs
2
2
hrs
3
1 1/2 hrs
3
2 1/4 hrs
1
3 1/4 hrs
1
3 1/2 hrs
3
2 3/4 hrs
3
3 1/2 hrs
2
4 1/2 hrs
1
46 1/4
Extended
Labor
101.25
227.50
101.25
122.50
105.00
101.25
191.25
168.75
105.00
140.00
105.00
101.25
146.25
245.00
192.50
210.00
202.50
2,566.25
Parts
22.50
75.85
28.95
25.75
45.15
55.85
22.50
18.50
75.85
187.50
110.50
35.95
47.66
752.51
Total
Invoice
123.75
303.35
130.20
122.50
130.75
146.40
247.10
191.25
105.00
140.00
123.50
177.10
146.25
432.50
303.00
245.95
250.16
3,318.76
202201082305301_rsrservrpt_2 Sep
Rate Code Chart
Descript...