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