COVID Expenditures worksheetCity of Scandia
Coronavirus Relief Funds (CRF) Expenditures
Purchase
Date
4/1/2020
3/20/2020
4/1/2020
4/14/2020
4/14/2020
4/14/2020
5/5/2020
5/27/2020
6/23/2020
6/24/2020
7/24/2020
7/6/2020
7/4/2020
7/6/2020
7/29/2020
7/22/2020
7/22/2020
7/22/2020
7/29/2020
8/13/2020
8/12/2020
9/4/2020
8/29/2020
7/29/2020
8/25/2020
8/25/2020
8/28/2020
9/11/2020
10/15/2020
10/9/2020
9/8/2020
9/2/2020
9/14/2020
8/26/2020
9/10/2020
8/31/2020
9/18/2020
10/14/2020
9/30/2020
10/9/2020
8/11/2020
10/27/2020
10/26/2020
10/26/2020
10/15/2020
10/22/2020
10/22/2020
10/21/2020
10/5/2020
10/15/2020
10/27/2020
10/15/2020
10/22/2020
10/22/2020
11/3/2020
Check
Date
3/17/2020
3/17/2020
4/21/2020
4/21/2020
4/21/2020
5/19/2020
5/19/2020
5/19/2020
5/19/2020
6/9/2020
6/16/2020
6/18/2020
6/18/2020
6/18/2020
6/16/2020
7/21/2020
7/21/2020
7/21/2020
7/21/2020
8/18/2020
8/18/2020
8/18/2020
8/18/2020
8/18/2020
8/18/2020
8/18/2020
8/18/2020
8/18/2020
8/18/2020
9/15/2020
9/15/2020
9/15/2020
9/15/2020
9/15/2020
9/15/2020
9/15/2020
9/15/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
VISA
VISA
10/20/2020
11/6/2020
11/6/2020
11/6/2020
11/6/2020
11/6/2020
Dept
FD
FD
ADMIN
ADMIN
FD
PW
ADMIN
FD
FD
FD
PW
FD
ADMIN
ADMIN
ADMIN
PW
ADMIN
FD
FD
PW
ADMIN
ADMIN
ADMIN
FD
FD
FD
FD
PW
PW
PW
FD
ADMIN
ADMIN
FD
FD
COMM CTR
COMM CTR
FD
FD
FD
ADMIN
ADMIN
FD
FD
PW
ADMIN
FD
FD
PW
FD
ADMIN
ADMIN
ADMIN
PW
ADMIN
ADMIN
FD
Admin
FD
FD/PW
FD
FD
FD
FD
ADMIN
PW
ADMIN
ADMIN
FD
FD
FD
ADMIN
ADMIN
Vendor
Emergency Response Solution
Witmer Public Safety Group
GoToMeeting
Ian Skarja
Apothecary's Dughter
Amazon
Amazon
Amazon
Jeff Anderson
Amazon
Amazon
Amazon
Amazon
DELL
Amazon
Menards
APRIL - JULY TOTAL
Amazon
Amazon
Amazon
Amazon
Amazon
Amazon
Amazon
Amazon
Emergency Response Solution
Global Industrial Company
Global Industrial Company
Global Industrial Company
Amazon
Amazon
Amazon
Dell
Jefferson Fire & Safety
BDS Laundry Systems
Menards
Amazon
Amazon
Amazon
Amazon
Amazon
Amazon
Amazon
Survey Monkey
Amazon
EMI Audio
Dell
Dell
Twin City Hardware
Twin City Hardware
Amazon
Amazon
Amazon
Propper International Sales
Valleyview Builders
Expenses Incurred yet to be invoiced and paid
Amazon
Survey Monkey
Dell
Amazon
Amazon
Amazon
Ready Access
OPG3
Description
faceshields
faceshields
PPE Total
MARCH 2020 TOTAL
GoToMeeting monthly fee
Zoom
PPE reimbursement
Hand sanitizer -Apothecary's Daughter
Telwork total
PPE Total
Public Health Expense Total
APRIL 2020 TOTAL
GoToMeeting monthly fee
Safety Glasses 2 boxes of 12
Safety goggles 10 pk
Medicine spoons bult (25)
Telwork total
PPE Total
MAY 2020 TOTAL
quarantine wages
surgical masks
GoToMeeting monthly fee
Webcam
infrared thermometer
Hand sanitizer
Personnel Services
Telework
Public Health
PPE
JUNE 2020 TOTAL
Colleen's wages
GoToMeeting monthly fee
two computers
Filtered face pieces
Hand sanitizer
Admin
Telework total
PPE Total
Public Health Expense Total
JULY 2020 TOTAL
Admin
Personnel Services
Telework total
PPE Total
Public Health Expense Total
AMOUNT PUT IN JULY TOTAL
Colleen's wages
GoToMeeting monthly fee
Webcam
mics for computers
hand sanitizer 2x25.28
mask supply
face masks
rubber gloves
hand sanitizer
particulate respirator piece
Filtered face pieces
Admin
Telework total
PPE Total
Public Health Expense Total
AUGUST 2020 TOTAL
Colleen's wages
GoToMeeting monthly fee
Disinfectant
Electric Fogger
Electric Fogger
Medpride Yellow Impervious Isolation Gowns
Headset with microphone
Webcam
Admin
Telework total
PPE Total
Public Health Expense Total
SEPTEMBER 2020 TOTAL
Colleen's wages
5 Council Laptops; 1 Staff laptop
Gear Dryer
washing machine
sanitizing clothes
scanner
half facepiece reusable respirator
surgical face masks
face coverings
webcam
Zoom subscription
LogMeIn subscription
online survey subscription service
hand sanitizing wipes
Community Center AV system
Admin
Telework total
PPE Total
Public Health Expense Total
OCTOBER 2020 TOTAL
Colleen's wages
Laptop & accessories
Desktop for Hall AV system
Access Control System for Fire Station
Video Surveillance System PW & FD
hand sanitizer
hand sanitizer
surgical masks
protective equipment
Service window installation
Admin
Telework total
PPE
Other
Public Health Expense Total
NOVEMBER 2020 TOTAL
mouth coverings
survey subscription
desktop for AV in community center
hand sanitizer
hand sanitizer
surgical masks
walk up service window
Laserfiche Self Hosted Subscription
20% Deputy & Sargeant's Wages
Fire Chief's wages 3/17/20 to 10/27/20
Firefighter's wages March - August
Total CARES Act Expenditures
Amount
670.34
137.18
807.52
807.52
30
16.06
508.27
19.96
46.06
508.27
19.96
574.29
30
37.13
79.99
10.98
30
128.1
158.1
1234
182.89
30
39.98
84.99
156
1234
69.98
84.99
338.89
1727.86
23.4044
30
1127.52
2574.54
19.96
23.4044
1157.52
2574.54
19.96
3775.4244
23.4044
1234
1303.56
3549.8
39.92
6150.6844
128.7243
30
49.99
29.98
50.56
180.46
149.99
36.19
24.99
107
3057.04
128.7243
109.97
3530.68
75.55
3844.9243
81.9155
30
219.77
432.16
446.04
247.45
32.99
33.14
81.9155
96.13
247.45
1122.97
1548.4655
198.9376
5838.06
7814.95
7469
58.56
470
431.9
434.99
33.98
39.99
149.9
30
900
53.96
84824.77
198.9376
7427.95
900.87
100221.24
108748.9976
0
1033.46
1073.13
16046.15
32904.12
380
394
290
4201.16
1275
0
49983.73
4491.16
48950.27
3122.13
106547.29
21.98
900
1073.13
380
394
290
4230
6700
13989.11
111678.05
26606.1
23750.86
162035.01
241721.9818
Justification
PPE
PPE
Telework
Telework
PPE
Public Health
Telework
PPE
PPE
PPE
Personnel Services
PPE
Telework
Telework
Public Health
PPE
Admin
Telework
Telework
PPE
Public Health
Admin
Telework
Telework
Telework
Public Health
PPE
PPE
PPE
Public Health
PPE
PPE
Admin
Telework
Public Health
Public Health
Public Health
PPE
Telework
Telework
Admin
Telework
Public Health
Public Health
Public Health
Telework
PPE
PPE
PPE
Telework
Telework
Telework
Telework
Public Health
Public Health
Admin
Telework
Public Health
Telework
Telework
Public Health
Public Health
PPE
PPE
Public Health
confirmed
estimated
estimated
BDS Code
101-42200-217
101-42200-217
101-41000-309
101-41000-309
101-42200-209
101-43000-217
101-41000-309
101-42200-209
101-42200-209
101-42200-209
101-43000-101
101-42200-209
101-41000-309
101-41000-570
101-41000-210
101-43000-217
101-41000-101
101-41000-309
101-42200-570
101-42200-240
101-43000-217
101-41000-101
101-41000-309
101-41000-570
101-42200-210
101-42200-209
101-42200-209
101-42200-209
101-43000-210
101-43000-210
101-43000-210
101-42200-240
101-41000-101
101-41000-309
101-42200-211
101-42200-211
101-45180-210
101-42200-209
101-42200-223
101-42200-223
101-41000-101
101-41000-570
101-42200-217
101-42200-560
101-43000-210
101-41000-570
101-42200-209
101-42200-209
101-43000-217
101-42200-570
101-41000-309
101-41000-309
101-41000-309
101-43000-217
401-48000-520
101-41000-101
101-42200-570
101-41000-570
42200/43000-570
42200/43000-570
101-42200-210
101-42200-211
101-42200-217
101-42200-217
203-46200-520
101-43000-217
101-45000-319
203-46200-570
101-42200-211
101-42200-211
101-42200-209
203-46200-520
101-42100-318
101-42200-101
101-42200-101
101-41000-101
101-41000-309
101-41000-570
101-42100-101
101-42200-101
101-42200-209
101-42200-211
101-42200-217
101-42200-560
101-42200-570
101-43000-101
101-43000-210
101-43000-217
101-43000-570
101-45000-319
101-45180-210
101-45180-401
401-48000-520
203-46200-520
203-46200-570
432.9818
1275.96
7471.16
111678.05
50356.96
2604.61
1819.93
13507.63
7469
51151.24
1234
226.74
305.84
900
446.04
84824.77
5505
1073.13
342283.0418
-241721.9818
100561.06
25
Genie Cleaning
Elections
Election Day disinfecting
25
Public Health
101-45180-401
7/23/2020
8/5/2020
7/24/2020
8/18/2020
8/18/2020
8/18/2020
ELECTIONS
ELECTIONS
ELECTIONS
Election Systems & Software
Election Systems & Software
Walmart
Check-in protective shields
Check-in protective shields
sanitizers, cleaners-Elections
270.67
812.03
22.3
PPE
PPE
Public Health
101-41410-210
101-41410-210
101-41410-210
FIRE DEPT CARES ACT EXPENDITURES 2020
Purchase
Date
3/20/2020
4/14/2020
4/14/2020
4/14/2020
5/27/2020
6/23/2020
7/6/2020
7/4/2020
7/6/2020
7/29/2020
7/29/2020
8/12/2020
8/13/2020
7/29/2020
9/11/2020
10/15/2020
9/2/2020
9/14/2020
9/10/2020
8/11/2020
10/26/2020
10/26/2020
10/27/2020
10/15/2020
10/22/2020
10/22/2020
Check
Date
3/17/2020
3/17/2020
4/21/2020
5/19/2020
5/19/2020
5/19/2020
6/16/2020
7/21/2020
7/21/2020
8/18/2020
8/18/2020
8/18/2020
8/18/2020
8/18/2020
9/15/2020
9/15/2020
9/15/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
10/20/2020
11/6/2020
11/6/2020
11/6/2020
11/6/2020
Dept
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD
FD/PW/CC
FD/PW
FD
FD
FD
FD
Vendor
Emergency Response Solution
Witmer Public Safety Group
Ian Skarja
Amazon
Amazon
Amazon
DELL
Amazon
Amazon
Amazon
Amazon
Amazon
Emergency Response Solution
Global Industrial Company
Global Industrial Company
Amazon
Jefferson Fire & Safety
BDS Laundry Systems
Amazon
Amazon
Amazon
Dell
Twin City Hardware
Twin City Hardware
Propper International Sales
Amazon
Amazon
Amazon
Description
faceshields
faceshields
PPE reimbursement
Safety Glasses 2 boxes of 12
Safety goggles 10 pk
Medicine spoons bult (25)
surgical masks
two computers
Filtered face pieces
mics for computers
hand sanitizer 2x25.28
mask supply
face masks
Filtered face pieces
Electric Fogger
Disinfectant
Medpride Yellow Impervious Isolation Gowns
Gear Dryer
washing machine
half facepiece reusable respirator
surgical face masks
webcam
Laptop & accessories
Access Control System for Fire Station
Video Surveillance System PW & FD
Extrication Suits- 7
hand sanitizer
hand sanitizer
surgical masks
Amount
670.34
137.18
508.27
37.13
79.99
10.98
182.89
1127.52
2574.54
29.98
50.56
180.46
149.99
3057.04
432.16
219.77
247.45
7814.95
7469
431.9
434.99
39.99
1033.46
16046.15
32904.12
3142.83
380
394
290
Justification
PPE
PPE
PPE
PPE
PPE
PPE
PPE
Telework
PPE
Telework
Public Health
PPE
PPE
PPE
Public Health
Public Health
PPE
Public Health
Public Health
PPE
PPE
Telework
Telework
Other
Other
PPE
BDS Code
101-42200-217
101-42200-217
101-42200-209
101-42200-209
101-42200-209
101-42200-209
101-42200-209
101-42200-570
101-42200-240
101-42200-210
101-42200-209
101-42200-209
101-42200-209
101-42200-240
101-42200-211
101-42200-211
101-42200-209
101-42200-217
101-42200-560
101-42200-209
101-42200-209
101-42200-570
101-42200-570
42200/43000-570
42200/43000-570
101-42200-217
101-42200-211
101-42200-211
101-42200-209
Check
Date
6/8/2020
7/27/2020
7/31/2020
8/11/2020
8/14/2020
8/17/2020
8/21/2020
8/24/2020
9/29/2020
9/29/2020
9/29/2020
10/1/2020
10/1/2020
10/7/2020
10/27/2020
10/27/2020
10/27/2020
10/27/2020
10/27/2020
10/30/2020
Dept
PW
ADMIN
Vendor
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
City of Scandia
19472.48
Description
Payroll for Anderson quarantine
Colleen's time for AV upgrade & reporting
email & discussion with vendors
email & discussion with vendors
preparing expenditure report
Meeting w/Mayor, Admin, Colleen
Meeting w/Paul, Steve, Ken, Colleen
email & discussion with vendors
email & discussion with vendors
updated expenditures worksheet
email & discussion with vendors; drafting report for Council meeting 10/7
preparing MMB reporting form
updating expenditure worksheet
preparing new MMB reporting form
present AV upgraded to Council
CARES Act education - webinar
updating expenditure worksheet
coordinating technology order
preparing MMB reporting form
preparing Staff report for Council
updating expenditure worksheet
Total Wage Package 2020
70324.16
Clerk's Election COVID Prep
832
Hours
0.5
0.5
2
1
1
1
0.5
1
2
0.5
0.5
0.5
0.5
1
2
0.5
0.5
1.5
1.5
Hours
2080
0
23.4044
Amount
1234
11.7022
11.7022
23.4044230769231
46.8088
23.4044
23.4044
23.4044
11.7022
128.724326923077
23.4044
46.8088
11.7022
81.9154807692308
11.7022
11.7022
11.7022
0
23.4044
46.8088
11.7022
11.7022
35.1066
35.1066
198.937596153846
Rate
33.8097
0
BDS Code
101-43000-101
101-41000-101
101-41000-101
101-41000-101
101-41000-101