Loading...
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$