4.a COVID Expenditures worksheetCity of Scandia
Coronavirus Relief Funds (CRF) Expenditures
Purchase Check
Date Date Dept Vendor Description Amount Justification
3/17/2020 FD Emergency Response Solution faceshields 670.34 PPE
3/17/2020 FD Witmer Public Safety Group faceshields 137.18 PPE
PPE Total 807.52$
MARCH 2020 TOTAL 807.52$
4/21/2020 ADMIN GoToMeeting GoToMeeting monthly fee 30.00$ Telework
4/1/2020 4/21/2020 ADMIN Zoom 16.06$ Telework
3/20/2020 4/21/2020 FD Ian Skarja PPE reimbursement 508.27 PPE
4/1/2020 PW Apothecary's Dughter Hand sanitizer -Apothecary's Daughter 19.96$ Public Health
Telwork total 46.06$
PPE Total 508.27$
Public Health Expense Total 19.96$
APRIL 2020 TOTAL 574.29$
5/19/2020 ADMIN GoToMeeting monthly fee 30.00$ Telework
4/14/2020 5/19/2020 FD Amazon Safety Glasses 2 boxes of 12 37.13$ PPE
4/14/2020 5/19/2020 FD Amazon Safety goggles 10 pk 79.99$ PPE
4/14/2020 5/19/2020 FD Amazon Medicine spoons bult (25)10.98$ PPE
Telwork total 30.00$
PPE Total 128.10$
MAY 2020 TOTAL 158.10$
6/9/2020 PW Jeff Anderson quarantine wages 1,234.00$ Personnel Services
6/16/2020 FD Amazon surgical masks 182.89$ PPE
6/18/2020 ADMIN GoToMeeting monthly fee 30.00$ Telework
6/18/2020 ADMIN Amazon Webcam 39.98$ Telework
6/18/2020 ADMIN Amazon infrared thermometer 84.99$ Public Health
5/5/2020 6/16/2020 PW Amazon Hand sanitizer 156.00$ PPE
Personnel Services 1,234.00$
Telework 69.98$
Public Health 84.99$
PPE 338.89$
JUNE 2020 TOTAL 1,727.86$
Colleen's wages 23.40$ Admin
7/21/2020 ADMIN GoToMeeting monthly fee 30.00$ Telework
5/27/2020 7/21/2020 FD DELL two computers 1,127.52$ Telework
6/23/2020 7/21/2020 FD Amazon Filtered face pieces 2,574.54$ PPE
6/24/2020 7/21/2020 PW Menards Hand sanitizer 19.96$ Public Health
Admin 23.40$
Telework total 1,157.52$
PPE Total 2,574.54$
Public Health Expense Total 19.96$
JULY 2020 TOTAL 3,775.42$
ADMIN Colleen's wages 128.72$ Admin
8/18/2020 ADMIN GoToMeeting monthly fee 30.00$ Telework
7/24/2020 8/18/2020 ADMIN Amazon Webcam 49.99$ Telework
7/6/2020 8/18/2020 FD Amazon mics for computers 29.98$ Telework
7/4/2020 8/18/2020 FD Amazon hand sanitizer 2x25.28 50.56 Public Health
7/6/2020 8/18/2020 FD Amazon mask supply 180.46$ PPE
7/29/2020 8/18/2020 FD Amazon face masks 149.99$ PPE
7/22/2020 8/18/2020 PW Amazon rubber gloves 36.19$ PPE
7/22/2020 8/18/2020 PW Amazon hand sanitizer 24.99$ Public Health
7/22/2020 8/18/2020 PW Amazon particulate respirator piece 107.00$ PPE
7/29/2020 8/18/2020 FD Emergency Response Solution Filtered face pieces 3,057.04$ PPE
City of Scandia
Coronavirus Relief Funds (CRF) Expenditures
Purchase Check
Date Date Dept Vendor Description Amount Justification
Admin 128.72$
Telework total 109.97$
PPE Total 3,530.68$
Public Health Expense Total 75.55$
AUGUST 2020 TOTAL 3,844.92$
ADMIN Colleen's wages 81.92$ Admin
9/15/2020 ADMIN GoToMeeting monthly fee 30.00$ Telework
8/13/2020 9/15/2020 FD Global Industrial Company Disinfectant 219.77$ Public Health
8/12/2020 9/15/2020 FD Global Industrial Company Electric Fogger 432.16$ Public Health
9/4/2020 9/15/2020 COMM CTR Global Industrial Company Electric Fogger 446.04$ Public Health
8/29/2020 9/15/2020 COMM CTR Genie Cleaning Election Day disinfecting 25.00$ Public Health
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
Admin 81.92$
Telework total 96.13$
PPE Total 247.45$
Public Health Expense Total 1,122.97$
SEPTEMBER 2020 TOTAL 1,548.47$
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 10/20/2020 ADMIN Amazon scanner 470.00$ Telework
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 434.99$ PPE
8/26/2020 10/20/2020 PW Amazon face coverings 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 149.90$ Telework
9/18/2020 10/20/2020 ADMIN Amazon LogMeIn subscription 30.00$ Telework
10/14/2020 VISA ADMIN Survey Monkey online survey subscription service 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 84,824.77$ Public Health
Admin 198.94$
Telework total 7,427.95$
PPE Total 900.87$
Public Health Expense Total 100,221.24$
OCTOBER 2020 TOTAL 108,749.00$
ADMIN Colleen's wages -$ 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 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
10/21/2020 11/6/2020 FD Propper International Sales protective equipment 4,201.16$ PPE
11/6/2020 ADMIN Valleyview Builders Service window installation 1,275.00$ Public Health
Admin -$
Telework total 49,983.73$
PPE 4,491.16$
Other 48,950.27$
Public Health Expense Total 3,122.13$
NOVEMBER 2020 TOTAL 106,547.29$
10/5/2020 PW Amazon mouth coverings 21.98$
10/15/2020 ADMIN Survey Monkey survey subscription 900.00$
10/27/2020 ADMIN Dell desktop for AV in community center 1,073.13$
10/15/2020 FD Amazon hand sanitizer 380.00$
10/22/2020 FD Amazon hand sanitizer 394.00$
10/22/2020 FD Amazon surgical masks 290.00$
11/3/2020 ADMIN Ready Access walk up service window 4,230.00$
7,289.11$
20% Deputy & Sargeant's Wages 111,678.05$ confirmed
Fire Chief's wages 3/17/20 to 10/27/20 26,606.10$ estimated
Firefighter's wages March - August 23,750.86$ estimated
162,035.01$
Expenses Incurred yet to be invoiced and paid
City of Scandia
Coronavirus Relief Funds (CRF) Expenditures
Purchase Check
Date Date Dept Vendor Description Amount Justification
Total CARES Act Expenditures 235,021.98$