9.e2 COVID Expenditure Update 11-13-20Staff Report
Date of Meeting: November 13, 2020
To: City Council
From: Colleen Firkus
Re: CARES Act Expenditures Update
Background: On November 4, 2020, the City Council approved expenditures of $241,721.98 for
CARES Act grant reimbursement and directed staff to apply any balance of the $311,080
received to public safety wages. The staff report included estimated public safety wages of
$114,916.95.
Proposal Details: Attached is an updated spreadsheet with documented, unbudgeted
expenditures and public safety employee wages that meet the guidelines for CARES Act
reimbursement. Public Safety wages have been confirmed at $79,838.24. The previous amount
for the deputy was overstated due to a calculation error and the fire department amount
increased due to another payroll on November 10.
Fiscal Impact: Total expenses incurred to be reimbursed to date are $279,992.00. Unused
CARES Act funds of $31,088.00 must be returned to Washington County by November 20, 2020.
Recommendation: Approve expenditures to date and refund of balance to the County.
City of Scandia
Coronavirus Relief Funds (CRF) Expenditures
Purchase Check
Date Date Dept Vendor Description Amount Justiffatfon
312712020 FD Emergency Response Solution faceshieids 670.34 PPE
3/17/2020 FD Witmer Public Safety Group faceshlelds 137.18 PPE
$ 807.52 PPETotal
S 807.52 MARCH 2020 TOTAL
4/21/2020 ADMIN
4/1/2020 4/21/2020 ADMIN
3/20/2020 4/21/2020 FD
4/1/2020 PW
5/19/2020 ADMIN
4/14/2020 5/19/2020 FD
4/14/2020 5/19/2020 FD
4/14/2020 5/19/2020 FD
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
6/9/2020 PW
6/16/2020 FD
6/18/2020 ADMIN
6/18/2020 ADMIN
6/18/2020 ADMIN
6/16/2020 PW
7/21/2020 ADMIN
7/21/2020 FD
7/21/2020 FD
7/21/2020 PW
ADMIN
8/18/2020 ADMIN
8/18/2020 ADMIN
8/18/2020 FD
8/18/2020 FD
8/18/2020 FD
8/18/2020 FD
8/18/2020 PW
8/18/2020 PW
8/18/2020 PW
8/18/2020 FD
GoToMeeting GoToMeeting monthly fee
Zoom
Ian Skarja PPE reimbursement
Apothecary's Dughter Hand sanitizer-Apothecary's Daughter
Totals
GoToMeeting monthly fee
Amazon Safety Glassa%2 boxe%of 12
Amazon Safety goggles 10 pk
Amazon Medicine spoons bult (25)
Totals
JeffAnderson
quarantine wages
Amazon
surgical masks
Amazon
GoToMeeting monthly fee
Amazon
Webcam
Amazon
Infrared thermometer
Amazon
Hand sanitizer
Amazon
Totals
Colleen's wages
GoToMeeting monthly fee
DELL two computers
Amazon Filtered face pieces
Menards Hand sanitizer
Totals
APRIL -JULY TOTAL
Colleen's wages
GoToMeeting monthly fee
Amazon Webcam
Amazon
mics for computers
Amazon
hand sanitizer 2x25,28
Amazon
masksupply
Amazon
face masks
Amazon
rubber gloves
Amazon
hand sanitizer
Amazon
particulate respirator piece
Emergency Response Solution
Filtered face pieces
JUNE 2020 TOTAL
Totals
$ 30.00 Telework
5 16,06 Telework
508.27 PPE
$ 19.96 Public Health
$ 374.29
50.56
$ 46,06
Telworktotal
$ 508.27
PPETotal
$ 19.96
Public Heahh Expense Total
$ 57UD
APR11.2020 TOTAL
$ 30,00 Telework
$ 37,13 PPE
5 79.99 PPE
5 30,99 PPE
$ 158.10
$ 30.00 Telwork total
$ 128.10 PPETotal
$ 158.10 MAY 2020 TOTAL
5 1,234.00 Personnel Services
5 182.89 PPE
5
3000 Telework
$ 39.98 Telework
S 84.99 Public Health
$ 156.00 PPE
$ 1,727.86
50.56
$
1,234.00
Personnel Services
$
69.98
Telework
$
64.99
Public Health
$
338.69
PPE
$
1,727.86
JUNE 2020 TOTAL
$
23.40 Admin
$.
30.00 Telework
$
1,127.52 Telework
$
2,574.54 PPE
$
19.96 Public Health
$ 7,041,19
50.56
$ 23.40
Admin
Admin
Peng noel Services
$ 1,303.56
Teleworktotal
$ 4,357,32
N3,77S.42
PPETotal
Public Hoalth Expcnse Total
PPE
PuMe Health Expense Total
PPE
JULY 2020 TOTAL
$ 7,041,19
50.56
$ 23.40
Admin
$ 1,234 DO
Peng noel Services
$ 1,303.56
Telework total
$ 4,357,32
PPETotal
$ 124.91
Public Hoalth Expcnse Total
I $ 7,043.19 (AMOUNT PUT IN JULY TOTAL I
$ 128.72 Admin
$ 30.00 Telework
$ 49.99 Telework
$ 29.98 Telework
50.56
Public Health
$ 180.46
PPE
$ 149,99
PPE
$ 36.19
PPE
$ 24.99
Public Health
$ 107.00
PPE
5 3,057.04
PPE
S 3,844.92
$ 128.72
Adrnbr
$ 109.97
7elework total
$ 3,530.68
PPETotal
$ 75.55 1
Public Health Expense Total
$ 3,844.92 JAU04T 2020 TOTAL
City of Scandia
Coronavirus
Relief Funds (CRF) Expenditures
Purchase
Check
Date
Date Dept
Vendor
Description
Amount Justification
ADMIN
Colleen's wages
$
81.92 Admin
9/15/2020 ADMIN
GoToMeeting monthly fee
S
30.00 Telework
8/13/2020
9/15/2020 FD
Global Industrial Company
Disinfectant
S
219.77 Public Health
8/12/2020
9/15/2020 FD
Global Industrial Company
Electric Fogger
3
432.16 Public Health
9/4/2020
9/15/2020 COMM CTR
Global Industrial Company
Electric Fogger
S
446.04 Public Health
8/29/2020
7/29/2020
9/15/2020 FD
Amazon
Medpride yellow Impervious Isolation Gowns
$
247.45 PPE
8/25/2020
9/15/2020 FD
Amazon
Headset with microphone
$
32.99 Telework
8/25/2020
9/15/2020 FD
Amazon
Webcam
$
33.14 Telework
Totals
S
81.92
Admin
Teleworktotal
$
247.49
PPE Total
$
1,097.97
Public Health Expense Total
$
1,523.47
SEPTEMBER 202➢ TOTAL
ADMIN
Colleen's wages
$
198,94 Admin
8/28/2020
10/20/2020 ADMIN
Dell
5 Council Laptops; 1 Staff laptop
$
5,838.06 Telework
9/11/2020
10/20/2020 FD
Jefferson Fire & Safety
Gear Dryer
$
7,814,95 Public Health
10/15/2020
10/20/2020 FD
BDS Laundry Systems
washing machine
$
7,469.00 Public Health
10/9/2020
10/20/2020 PW
Menards
sanitizing clothes
$
58-56 Public Health
9/8/2020
9/2/2020
10/20/2020 FD
Amazon
half facepiece reusable respirator
$
431-90 PPE
9/14/2020
10/20/2020 FD
Amazon
surgical face masks
S
434.99 PPE
8/26/2020
10/20/2020 PW
Amazon
face coverings
5
33.98 PPE
9/10/2020
10/20/2020 FD
Amazon
webcam
$
39.99 Telework
8/31/2020
10/20/2020 ADMIN
Amazon
Zoom subscription
S
149.90 Telework
9/18/2020
10/20/2020 ADMIN
Amazon
LogMeln subscription
S
30.00 Telework
10/14/2020 VISA ADMIN
Survey Monkey
online survey subscription service
S
900.00 Telework
9/30/2020 VISA PW
Amazon
hand sanitizing wipes
$
53.96 Public Health
10/9/2020
10/20/2020 ADMIN
EMI Audio
Community Center AV system
S
84,B24.77 Public Health
Totals
Admin
Telework total
g108,Z7!940
PPETotal
Public Health Expense Total
OCTOBER 2020 TOTAL
ADMIN
Colleen's wages
$234-04 Admin
8/11/2020
11/6/2020 FD
Dell
Laptop & accessories
$
1,033.46 Telework
10/27/2020
Admin
Dell
Desktop for Hall AV system
$
1,073.13 Public Health
10/26/2020
11/6/2020 FD
Twin City Hardware
Access Control System for Fire Station
$
16,046.15 Telework
10/26/2020
11/6/2020 FD/PW
Twin City Hardware
Video Surveillance System PW & FD
$
32,904.12 Telework
10/15/2020
FD
Amazon
hand sanitizer
$
3B0.D0 Public Hoahh
10/22/2020
FD
Amazon
hand sanitizer
$
394.00 Public Health
10/22/2020
FD
Amazon
surgical masks
$
290-00 PPE
10/21/2020
11/6/2020 FD
Propper International Sales
protective equipment
$
4,201.16 PPE
11/6/2020 ADMIN
Valleyvlew Builders
Service window installation
$
1,275-00 Public Health
10/6/2020
PW
Office Max
PW headset
$
1499 Telework
10/5/2020
PW
Amazon
mouth coverings
$
ZL98 PPE
10/15/2020
ADMIN
Survey Monkey
survey subscription
$
900.00 Public Health
10/27/2020
ADMIN
Dell
desktop for AV in community center
$
1,073.13 Public Health
10/15/2020
FD
Amazon
hand sanitizer
$
380.00 Public Health
10/22/2020
FD
Amazon
hand sanitizer
$
394.00 Public Health
10/22/2020
FD
Amazon
surgical masks
$
290.00 PPE
11/3/2020
ADMIN
Ready Access
walk up service window
$
4,230.00 Public Health
ADMIN
OPG3
Laserfiche Self Hosted Subscription
$
6,700.00 Public Health
11/12/2020
11/13/2020 FD
Emergency Medical Products Hand soap, Disinfectant, Ambu Inspiratory Filter $
371.76 Public Health
11/12/2020
11/13/2020 FD
Global Industrial
Air filters, Facepieces
$
694.83 PPE
11/12/2020
FD
Amazon
hand sanitizer
$
139.99 Public Health
FD
Amazon
RCA to HDMI converter
$
14.99 Telework
FD
Amazon
surgical masks
$
435.00 PPE
FD
Amazon
disinfecting wipes
$
299.50 Public Health
11/13/2020
FD
Amazon
surgical masks
$
4,785.00 PPE
11/13/2020
FD
Amazon
disposable isolation gowns
$
551.96 PPE
11/13/2020
FD
Amazon
Thermometer
$
29.98 Public Health
11/13/2020
FD
Amazon
hand sanitizer
5
305.00 Public Health
Total November Expenditures
$75,469.17
$
23404
Budgeted Personnell
S
50,013.71
Telework total
$
11,269.93
PPE
$
17,945.49
Puhllc Health Expense Total
$
79,463-17
NOVEMBER 2020 T0TAL
20% Deputy & Sargeant's Wages
$
18,613.01 Public Safety Employees
Fire Chief's wages 3/17/20 to 11/10/20
$
28,313.96 Public Safety Employees
Firefighter's wages March- September
$
32,91127 Public Safety Employees
Total Public Safety Expenditures
$ 79,838.24
TOTAL CARES ACT EXPENDITURES
$ 279,99240
CARES ACT GRANT
$ 311,080.00
REM38UR$ETO COUNTY
6
31,D(t8.00