Loading...
FINANCE COMMITTE Packet 10252022CITY OF MUSKEGO FINANCE COMMITTEE AGENDA 10/25/2022 5:50 PM Muskego City Hall, W182 S8200 Racine Avenue CALL TO ORDER PLEDGE OF ALLEGIANCE ROLL CALL PUBLIC MEETING NOTICE APPROVAL OF MINUTES NEW BUSINESS 4e C21 of SKEGO Recommend Approval of Amendment to the Municipal Ordinance Deposit and Forfeiture Schedule Regarding Use of Cigarettes, Nicotine, Tobacco, and Vapor Products CCR2022.095-Amend Ord D&F Schedule.docx Recommend Approval of Dedication of Public Improvements for MK/S-EP, LLC (Mallard Reserve) Finance Memo - MKS-EP LLC Public Infrastructure Dedication.docx Muskego-Dedication of Public Improvements Mallard Reserve Final KAH.docx Recommend Approval for a Letter of Intent to Purchase a Vactor Truck (2023 Capital Item) Finance Memo - 2023 Capital Item - Vactor Truck Letter of Intent to Purchase.docx 2023 Vactor quote - BEC Brown.pdf 2023 Vactor quote - MacQueen Equipment.pdf Recommend Approval of Letter of Credit Reduction for MK/S-EP, LLC Finance Memo - MKS-EP LLC LOC reduction.docx LOC 1-Mal lard ReserveM N P. pdf VOUCHER APPROVAL Utility Vouchers - $424,059.85 General Fund Vouchers - $510,178.68 Wire Transfers for Payroll/Invoice Transmittals - $369,059.25 Vouchers - Total Sheet.pdf Vouchers - Alpha Report.pdf FINANCE DIRECTOR'S REPORT Quarterly Report FD Report - COW 10-25-22.pdf COMMUNICATIONS AND ANY OTHER BUSINESS AS AUTHORIZED BY LAW ADJOURNMENT NOTICE IT IS POSSIBLE THAT MEMBERS OF AND POSSIBLY A QUORUM OF MEMBERS OF OTHER GOVERNMENTAL BODIES OF THE MUNICIPALITY MAY BE IN ATTENDANCE AT THE ABOVE -STATED MEETING TO GATHER INFORMATION; NO ACTION WILL BE TAKEN BY ANY GOVERNMENTAL BODY AT THE ABOVE -STATED MEETING OTHER THAN THE GOVERNMENTAL BODY SPECIFICALLY REFERRED TO ABOVE IN THIS NOTICE. ALSO, UPON REASONABLE NOTICE, EFFORTS WILL BE MADE TO ACCOMMODATE THE NEEDS OF DISABLED INDIVIDUALS THROUGH APPROPRIATE AIDS AND SERVICES. FOR ADDITIONAL INFORMATION OR TO REQUEST THIS SERVICE, CONTACT MUSKEGO CITY HALL, (262) 679-4100. COMMON COUNCIL — CITY OF MUSKEGO RESOLUTION #095-2022 APPROVAL OF AMENDMENT TO THE MUNICIPAL ORDINANCE DEPOSIT AND FORFEITURE SCHEDULE REGARDING USE OF CIGARETTES, NICOTINE, TOBACCO, AND VAPOR PRODUCTS WHEREAS, Section 263-23(E) of the City of Muskego Code of Ordinances contains a restriction for the purchase or possession of vapor products by person under 18 years of age; and WHEREAS, Section 263-23(F) of the City of Muskego Code of Ordinances contains a prohibition on the possession of cigarettes, nicotine products, tobacco products, and vapor products by students in school buildings or upon school property; and WHEREAS, The forfeiture contained within the Municipal Ordinance Deposit Forfeiture Schedule for violations of the above referenced ordinance sections is currently set at the amount of $155.50; and WHEREAS, in consultation with the Municipal Judge, Muskego-Norway School District Administration, the City Attorney, the Chief of Police, and the School Resource Officers, it was determined that the current forfeitures are not meeting the proper needs of the school district and the community at large; and WHEREAS, In accordance with Section 18-3 of the Municipal Code, Judge Lisa Warwick is authorized to establish and submit to the Common Council for approval a schedule of deposits for violations of City ordinances; and WHEREAS, Judge Warwick, in consultation with the above -named parties and in reviewing ordinance forfeitures of other municipalities, has determined that a more appropriate and effective forfeiture amount for said violations referenced herein be set at $565.00; and WHEREAS, the Finance Committee has reviewed the proposed change and recommends approval to the Common Council. NOW, THEREFORE, BE IT RESOLVED That the Common Council of the City of Muskego upon the recommendation of the Finance Committee, does hereby approve an amendment to the forfeiture amount for the violations as referenced herein be set at $565.00. BE IT FURTHER RESOLVED That the Municipal Ordinance Deposit and Forfeiture Schedule be amended accordingly and posted pursuant to Section 18-3(C) of the Municipal Code of Ordinances. DATED THIS 25th DAY OF OCTOBER 2022. SPONSORED BY: FINANCE COMMITTEE This is to certify that this is a true and accurate copy of Resolution #Oxx-2022, which was adopted by the Common Council of the City of Muskego. Clerk -Treasurer 10/22cmc 3 �„�iSKEGO Reports and Presentations to Finance Committee and Common Council To: Finance Committee & Common Council From: Scott Kroeger Department: Public Works and Development Subject: Dedication of Public Improvements MK/S-EP, LLC Date: October 25, 2022 MK/S-EP, LLC entered into a Developer's Agreement with the City for the development on Priegel Drive (Madyson Court) just west of Durham Drive. The development is at a point for public dedication. Key Issues for Consideration: Attachments 1. N/A Recommendation for Action by Committee and/or Council: Approval of dedication of public improvements for MK/S-EP, LLC development. Date of Committee Action: Finance Committee October 25, 2022 Planned Date of Council Action (if required): October 25, 2022 Total $ Needed: N/A Fiscal Note(s): N/A $ Budgeted: $0.00 Expenditure Account(s) to Be Used: # N/A (3/2019) 4 COMMON COUNCIL — CITY OF MUSKEGO RESOLUTION # -2022 DEDICATION OF PUBLIC IMPROVEMENTS FOR MALLARD RESERVE WHEREAS MALLARD RESERVE, hereafter called "DEVELOPER" has constructed public improvements in and around MALLARD RESERVE site; including all sanitary sewer facilities, storm sewer facilities, water distribution, and roadway pavement, including any and all equipment and appurtenances which may in any way be a part thereof or pertain to, in and for MALLARD RESERVE; and WHEREAS, the DEVELOPER has completed the construction and installation of the following improvements: Sanitary Sewer 371 VF at $310.00/Each of 48" Sanitary Manhole $115,010.00 300 LF at $30.00/LF of 2-Inch PVC Sanitary Sewer $9,000.00 5,056 LF at $99.00/LF of 8-Inch PVC Sanitary Sewer $500,544.00 2,245 LF at $95.00/LF of 6-Inch PVC Sanitary Lateral $213,275.00 Total — Sanitary Sewer $837,829.00 Water Main 5,233 LF at $89.00/LF of 8-Inch PVC Water Main $465,737.00 14 Each at $4,870.00/Each of Hydrant Assembly w/ Valve Box $68,180.00 175 LF at $100.00/LF of 6" PVC Hydrant Lead $17,500.00 19 Each at $1,800.00/Each of 8-Inch Gate Valve $34,200.00 2,167 LF at $75.00/LF of 1.25-inch HDPE Water Service $162,525.00 Total — Water Main $748,142.00 Storm Sewer 811 LF at $105.00/LF of 36-Inch RCP Storm Sewer $85,155.00 336 LF at $85.00/LF of 30-Inch RCP Storm Sewer $28,560.00 597 LF at $80.00/LF of 24-Inch RCP Storm Sewer $47,760.00 530 LF at $62.00/LF of 18-Inch RCP Storm Sewer $32,860.00 1118 LF at $40.00/LF of 15-Inch RCP Storm Sewer (includes culverts) $44,720.00 292 LF at $44.00/LF of 12-Inch RCP Storm Sewer $12,848.00 2,684 LF at $34.00/LF of 6-Inch PVC Storm Drain $91,256.00 4i 61 Each at $650.00/Each of Storm Cleanouts 9 Each at $1,300.00/Each of Storm End Sections 6 Each at $2,000.00/Each of Field Inlets 22 Each at $3,200.00/Each of Storm Manholes 34 Each at $2,300.00/Each of Storm Catch Basin/Manholes Total — Storm Sewer Paving 10,240 SY at $9.50/SY of Aggregate Base Course (8" depth) 6,581 LF at $15.60/LF of 30" Mountable Curb and Gutter 10,240 SY at $16.50/SY of 4-Inch Binder Asphalt Course $39,650.00 $11,700.00 $12,000.00 $70,400.00 $78,200.00 $555,109.00 $97,280.00 $102,663.60 $168,960.00 1,699 SY at $28.75/SY of Priegel Dr. 4-Inch Binder and 2-Inch Surface Asphalt Course $48,846.25 195 LF at $106.87/LF of Pathway (Asphalt, Stone Base, Concrete Pad) $20,840.00 Total — Paving (Not including Final Lift of Asphalt) $438,589.85 and appurtenances (collectively called "IMPROVEMENTS") in accordance with the provision of Chapter 392 of the Municipal Code of the City of Muskego, hereafter called the "CITY", and the City Engineer has certified the systems' acceptability; and WHEREAS, it is the Developer's intent to, without charge to the CITY, unconditionally give, grant, convey and fully dedicate the IMPROVEMENTS to the CITY, free and clear of all encumbrances, and together with mains, conduits, pipes, plants, machinery, equipment and appurtenances which relate directly to the utilization of such IMPROVEMENTS; and WHEREAS, the DEVELOPER shall guarantee the public improvements to be dedicated against any defects due to faulty materials or workmanship which appear within a period of one (1) year from the date of dedication and shall pay for any damages resulting therefrom to the CITY property and shall indemnify the CITY against any claims, suits, or liabilities brought against the CITY at any time arising out of the alleged defects or other failure of this guarantee; and NOW, THEREFORE, BE IT RESOLVED That the Common Council of the City of Muskego, upon the recommendation of the Finance Committee, does hereby accept dedication and acceptance of the public improvements in and for MALLARD RESERVE Development. DATED THIS DAY OF 92022 SPONORED BY: FINANCE COMMITTEE 6 This is to certify that this is a true and accurate copy of Resolution # -2022 which was adopted by the Common Council of the City of Muskego. Sharon Mueller, City Clerk -Treasurer 7 . \ % I �� C4 W 1VIUSKEGO Reports and Presentations to Finance Committee and Common Council To: Finance Committee & Common Council From: Scott Kroeger Department: Public Works and Development Subject: 2023 Capital Item — Vactor Truck Letter of Intent to Purchase Date: October, 25, 2022 The Utilities Department viewed and tested Jet/Vac sewer cleaning machines from 4 different vendors. We solicited quotes from the 2 preferred machines. Both vendors indicated supply chain issues with obtaining vehicle chassis for these machines. The quotes are below. 1. MacQueen Equipment -_ $511,303.00 2. BEC Brown = $539,619.00 Utilities is requesting a letter of intent to purchase a Vactor truck from MacQueen Equipment for the price of $511,303.00 minus the trade in of our current Vactor truck of $65,000 for a total of $446,303.00. This item is in the 2023 Sewer Utility Capital Budget with a budget of $500,000 Key Issues for Consideration: Attachments 1. MacQueen Vactor Quote 2. BEC Brown Vactor Quote Recommendation for Action by Committee and/or Council: Approve the Finance Department of writing a letter of intent to MacQueen Equipment for the purchase of the Vactor Truck Date of Committee Action: October 25, 2022 Planned Date of Council Action (if required): October 25, 2022 Total $ Needed: N/A Fiscal Note(s): N/A $ Budgeted: Accounts and budget below= $500,000 Expenditure Account(s) to Be Used: # 601.00.00.00.1922 { 2 5»mm- mm®2 o \M\f �O$>2 zr m< z V0C) $\�\m /«>z\ 50200 �mgHE mj ja\ §%ƒ/f agwmU) m \q-0/ m• n f$\m 0 2Mrn® Hm- m-<m 2/(D»_ m c c O m I \0Xm �qa3 z x m > 0000 f�$� 7�§z 4Mm.- n;umn /�\/ </>§ co (n r-�-0C >0q g/$I > \%q \ rn 9 a a �n :j _ ct \ )m ■■ § � k � rn 2�� k72\9 »••0)oo \\\/\ �\//f ]&ZR _&#$] {,JxrD ] ®// \ 2 \ D x � (D � rD m � T N U1 N = 9 err �^..1�^�Z�CNyTLJ� Wp^����u,�L7 D.., aomT=rrrrrrArrW��� �2Zm� DrCDNn� moo l71 ��Qm2QQ2Om�Qm��2mp�DC�[7 C7-'wCn' n�cn y� 7 `C Mom'-'�07fl_.W�.-....J.��. cPOO�p mmmmmmrmo ..00_omr➢p7°°'�V+O �niowoi@°`GCCK rDx ti'@°Ooo`GO 7mmCc0o = n�C 3 3 nroi�aio Nd3.�.2.C]6�W oo oo��4r�000QQQmfl��Dc nl+c �n 7�v .p.�nmio d�^y,aa3maQ is (l�omoao �n� 3vw-nCioc3��0 7 l0� .N OC - - - =vrN @X�^ T7omn�DOtl CC]cw �D;. r'p QC2�P�bN 7 v-a bN�7CN3p d�cp60mniD n�37tn.mm U am —@ N �xx Xxtn 3m� N%rcacm „ 2 �� ntv to _�.� �i73 c c tn� �p CSC.. t7tp C .y vtrp aryiar"upc xR? o�mArn°Tao °o o7vo�7owom3 y��a 7v� ��o�@c �fl mina-TQ .r+f Jo off. @Crnm��T��� +-- �m �076�',tnC�m7vn7c-No3Cnonxx art�`°4FN i�R°�� 3�a0 ro�o..�NmOCcs��' ro�O�aQmrom� n"`�v �°;o�mnoc3mNm 0�0 7Ktpc m O ym2N'O r, @p ,r�D@000 nr.� in cv fD �tn7 @O-6� c-n~..n�70 cC�c7@cT—..3m O7Cri,� Sn L. ^fU lDa � NfD SQ C��n@2G.0 011, rD ea.vvD m3 o-CN c„�mpo n37n@ T OQ' FAO �{ °'C Cr-r p°IC 10 m @ �m 3j 7 �n n 7ronR.n amo7@ po7v v 7'n7n rororo ao 7��F �oou moo ��@=��o� 0 7°moo7n na�a °3 @3�33 -R7 G5c O° , o@_. _. n � ',O r 0 Kooxxa m �.-mm7v2v tnn fly- m prom @3 on @@..@ dm v �7'7N n07c 1�J1��"7'jN^ �'1an77 G7 Nro(DJc'7C CNOOOA� p-�j ��t0� Nn�^J �N�n �nw OO„mtCv r7+�C Q" nv�N_�rt•N� D 'Zi sZ tv Ntn N.roart Qwm� me -ice 7a �n NCCNrr 7R.� - - in a--'— m -nOO @ to n G jX@ �1a@ T'6r iyC C`C 1prol= O p� p �Q ��CIC �.euneD ri pa rva 3,- of0m3.7 rpi a'om� �* -0Ox- �� o.��,aoNn .� a'�`c..� 3R n'oav c3o :ES � 3 7� 3 to G. N 7 7 ar prttnXx7' n.m.. Ev m m n 3 T m @ .Z1 In M T T to O -' 7 �. @ W .a N ro [;1 ' 7 ]c �-p 7 O en o a ?. 0 Z '� R. _ 3 [pt7p o o w @" to v 7 Q ?. D °1 j z a 7 �p @N a Sl n O �n NC 7 j ry7 T N < @ to ° a ° �' o CO. Fc x C° - 3 d "p N C m m 3 3 n 7 m@ fD 3 O - n n ro a N i O a K f N D p Ox to a 7 7 �� ro ? T .7, rmo ° @ n c p n A tv o •* m {_ 7 d a o a a 7 7 Z @ rc T Qm W p ;0 @ m 3 rru ro @ x ID n O A 12 _�loll awba �O � N W 3 Cm [li � OC d �Rix fTl ID ID Q D V z "-b �' tr,3 N J !B D C r7 ro n d rD 4i rD J rJ 10 MnQueen Equipment _ . MACQUEEN . MACQUEEN N60 WI-5835 Xohler Lane M�eQudian EgUIpMent EQUIPMENT E M E R'G''E N C Y Menomonee Falls, wt 53051 1125 70 Street E St Paul, MN S5106 262-252-4744 . 800-252-4799 651-545-5726.800-832-6417 Ship to: CITY bF MUSKEGO Vil$9 58235 MERCURY DRIVE MLTSKEGO WZ 53.150 Ynvoice ro: CITY OF MUSKEGO-SEWER UTILITY W185 S8.Z35 mercury Dr .Attn: Renee Muskego WI 53150 Branch 02-:MENOM FALLS W1 Date Time Page 1:o/la.J2'd2z 8:22:47 (o) 1 Account No Phone No 3nv No .Q.3 MUSKEdO] EO.U892 Ship Via Pi:,rctiase Order VERBAL Tax ID NO Salesperson TYLER GAGE 142 EQUIPMENT INVOICE DescriptibrZ Amount Stock #: C044548 Serial. #: 511303.00 New VA . 210 0 PD. 12 YD V;ACTOR 21001. S.TANbAkb FEATTJRRS 4$" x 22 v x 2411 Curb Side Aluniiilum Toolbox Aluminum Fenders Mud Flaps Electric/Hydraulic Four Way BooRl Color Coded Sealed Electrical System Int:uitouch Electronic Package Double Acting Dump Haist= Cylinder Handgun -.Assembly w./3:5' x 1./2" Hose w/Quick Disconnects' 3" Y-Strainer at Water P' Inlet. Ex --Ten Steel Cylindrical -Debris Tank Flexible Kose Guide (3) Nozzles with Carbide Inserts w/Rack Suction Tube Storage - 4 Pipe 1" Nozzle Pipe 10' Leader Hose Flat Rear Door w/Hydraulic Locks Dual Stainless Steel Float Shut. Off. Debris Body vacuum Relief System Debris Delle.ctor plate 6:.04 Dump Height Additional Water Tank Sight Guage Liquid Float;Level 1ndi.cator Bopni Transport P[ist 'Storage Boom out of. Position .1ridicator/A7 arm Body out of Posi,tipn Indicator/Alarm 31, Y-Strainer 4 Water :Pump Performance Package II, Water Relief Valve Microstkainer Prior 'to Blower Midship Handgun Coupling fteceived't3y Date 'VlsItU-sOntin c www, macqu0engroup. corn .............. - -..__ _.. _......_..._.............. ........ _._._..._......... .......,....,.................. ....... .._.�...�..._.___..._w.---._ 11 MacQueen Equipment ��� F ray MACQVEEN MACQUEEN N60 W15835 Kohler Lane MaCQuech Equipment EQ U f. PM ENT E.M E R G E N CY Menomonee Falls, W1 53051 St 5 thi5tr e.F t 55106 262-252-474'$ 800-252 4799 Paul,m_645<5726 .800-63216417 5hipToc CITY OF MUSKEGO W189' S8235 MERCURY DRIVE MUSKEGO W.S .5315-0 Xnv_ bica To. CITY OF XUSKEGO�SEWRi UTILITY W189 S8235 Mercury Dr Att:rn: Renee Muskego:W2 53150 Branch d2 - MENOM FALLS WI Date Time ENO 10/18./2022 6:22:47 (0) 14 Account No Rhone No- Inv No 9.3 MUSKE001 E00892 Ship Via Purchase Order VERBAL Tax ID No i Salesperson F_ TYLER GAGE 142 E.QUYPMENT INVOICE Descr.ipt.ion Amount New SONETTCS APX377-$H.APX377-BH. HEADSET d04.05,51 New SONETICS APX,377-BH APX377-SH HEADSET C.0405,52 New SONETICS SCH30.5. 5--USER COWUB (WITH.0040.553 Nev1 SONETTCS 8ON-CC5 5 USER CHARGING .CASE .0040554 Ttad4 Ins Stock #.: C.0414.24 -Serial 4: 09-10V-I193 65,000.0.0- Make: VA Made..: 2i10P-16 2009 VACTOR 2100 PLUS PD (TG) Subtotal: 44.5303,00. TOTAL DUR! 44.53.03,.00 QUOTED PRICES ARE BASED ON CURRENT COSTS AND THEREFORE SUBJECT TO CHANGE WITH WRITTEN NOTICE TO ACCOUNT YOR PRICING CHANGES BEYOND SELLER'S CONTROL. K Received Date VisitUsOnline ww..w> MaCqueeng:.ro.Up. c.om �„�iSKEGO Reports and Presentations to Finance Committee and Common Council To: Finance Committee & Common Council From: Scott Kroeger Department: Public Works and Development Subject: Reduction of LOC for MK/S-EP, LLC Date: October 25, 2022 MK/S-EP, LLC entered into a Development Agreement with the City for the development on Priegel Drive (Mallard Reserve) just west of Durham Drive. A large majority of work associated with public infrastructure has been completed. The recommendation is to reduce the LOC to be reduced by $2,407,781.18. The LOC would be reduced from $3,853,894.00 to $19446,112.82. Key Issues for Consideration: Attachments 1. Cost Breakdown Review for MK/S-EP, LLC LOC Reduction Recommendation for Action by Committee and/or Council: Approve MK/S-EP, LLC LOC to be reduced by $2,407,781.18. The LOC would be reduced from $3,853,894.00 to $1,446,112.82. Date of Committee Action: Finance Committee October 25, 2022 Planned Date of Council Action (if required): October 25, 2022 Total $ Needed: N/A Fiscal Note(s): N/A $ Budgeted: $0.00 Expenditure Account(s) to Be Used: # N/A (3/2019) 13 COST BREAKDOWN Mallard Reserve Development March 29, 2022 Proposed Cost LOC Red No.1 ADJ. BAL. #1 ROAD CONSTRUCTION a. Stone/Binder Lifts of Asphalt/Curb & Gutter $ 435,109.85 $ 435,109.85 b. Final Lift of Asphalt (including final inlet adjustments) $ 115,980.00 $ 115,980.00 c. Recreational Trail or Sidewalk $ - $ - d. Other (Misc. Removals) $ 5,590.00 $ 5,590.00 e. Engineering Inspections (estimate only) $ 44,534.39 $ 44,534.39 $ 601,214.24 $0.00 $ 601,214.24 #2 SITE GRADING/LANDSCAPING/RESTORATION a. Erosion control $ 24,679.95 $17,620.00 $ 7,059.95 b. Site Grading $ 190,870.00 $15,572.20 $ 175,297.80 c. Landscaping (street trees, prairie) $ - $ - d. Site Restoration (topsoil/seed or sod as required) $ 80,681.35 $ 80,681.35 e. Clear and Grub Site $ - $ - f. Engineering Inspections (estimate only) $ 23,698.50 $ 23,698.50 $ 319,929.80 $33,192.20 $286,737.60 #4 SANITARY SEWER SYSTEM a. Mains & Manholes $ 615,653.00 $554,087.70 $ 61,565.30 b. Laterals $ 179,265.00 $161,338.50 $ 17,926.50 c. Pumping station & Generator $ - $ - d. Force main $ 9,120.00 $8,208.00 $ 912.00 e. Grinder pumps &chamber-indiv dwelling $ - $ - f. Engineering Inspections (estimate only) $ 64,323.04 $57,823.04 $ 6,500.00 g. Other (Cleaning By Contractor & TV by City) $ - $ - $ 868,361.04 $781,457.24 $86,903.80 #5 WATER MAIN SYSTEM a. Mains, valves & manholes $ 505,881.00 $455,292.90 $ 50,588.10 b. Hydrants, valves & leads $ 86,380.00 $77,742.00 $ 8,638.00 c. Water services $ 133,275.00 $119,947.50 $ 13,327.50 d. Well & pumphouse $ - $ - e. Engineering Inspections (estimate only) $ 58,042.88 $52,042.88 $ 6,000.00 f. Other $ - $ - $ 783,578.88 $705,025.28 $78,553.60 #6 STORM SEWER SYSTEM a. Mains & manholes $ 408,770.00 $327,016.00 $ 81,754.00 b. Inlets $ 12,000.00 $9,600.00 $ 2,400.00 c. Laterals + Sump Lines $ 124,650.00 $99,720.00 $ 24,930.00 d. Headwalls/discharge structures $ 18,000.00 $14,400.00 $ 3,600.00 e. Engineering Inspections (estimate only) $ 45,073.60 $36,073.60 $ 9,000.00 f. Other $ - $ 608,493.60 $486,809.60 $121,684.00 #7 SPECIAL/MISC IMPROVEMENTS a. Street lights ( WE Energies Lights) $ 5,000.78 $ 5,000.78 b. Street signs $ - c. Other- Retaining Wall $ - $ 5,000.78 $0.00 $5,000.78 #8 FEES a. City administration $ - b. Engineering Design and Admin and Testing $ 5,000.00 $ 5,000.00 C. Engineering -As builts for underground (by City consultant) $ 10,000.00 $ 10,000.00 d. Engineering- Survey & Grading As-builtss $ 10,000.00 $ 10,000.00 e. Legal $ - f. Other $ - $ 25,000.00 $0.00 $ 25,000.00 TOTAL PROJECT ESTIMATE $ 3,211,578.34 $2,006,484.32 $ 1,205,094.02 120 % = LETTER OF CREDIT AMOUNT $ 3,853,894.00 $ 2,407,781.18 $ 1,446,112.82 LOC Remaining LOC Reduction with the 20% 14 Council Date Total Vouchers All Funds Utility Vouchers (Approve Separately) Water Vouchers $ 11,752.77 Water Wire Transfers Total Water $ 11,752.77 Sewer Vouchers 412,307.08 Sewer Wire Transfers October 25, 2022 $ 934,238.53 Total Voucher Approval Total Sewer $ 412,307.08 Net Total Utility Vouchers $ 424,059.85 #1 -Utility Voucher Approval Tax Vouchers - Refunds & Tax Settlements (Approve Separately) Tax Vouchers $ Tax Void Checks Total Tax Vouchers Total General Fund Vouchers (Approve Separately) General Fund Vouchers $ 510,178.68 Total General Fund Vouchers #2 - Tax Voucher Approval $ 510,178.68 #3 - General Voucher Approval Big Muskego Lake Vouchers $ Development Fund Vouchers $ Wire transfers (Approve Separately): Debt Service $ Payroll/Invoice Transmittals $ Void Checks Since Last Report Check Amount Total Total $ - Total 369,059.25 #4 - Wire Transfers Approval Check # Amount 15 CITY OF MUSKEGO Report Criteria: Detail report. Invoices with totals above $0 included. Paid and unpaid invoices included. [Report]. Description = {<>} "1099 adjustment" Invoice Number SegNo Type ABT MAILCOM 43412 4 Invoice 43412 3 Invoice 43412 2 Invoice 43412 1 Invoice Total ABT MAILCOM: ALL TRAFFIC SOLUTIONS INC. sin034347 1 Invoice sin034405 2 Invoice sin034405 1 Invoice Total ALL TRAFFIC SOLUTIONS INC.: ALSCO 042511 (AUG- 1 Invoice 042610/SEP 22 1 Invoice 042610/SEP 22 2 Invoice 042612/AUG-S 1 Invoice Total ALSCO: AMAZON CAPITAL SERVICES 11 p3mnpf3vy7 1 Invoice 13Y3-6H96-9Y 1 Invoice 14xw4v9vgxpw 1 Invoice 1CKN-4R6K-Y 1 Invoice 1 f71 x4kwhyg9 1 Invoice 1g6cfdrtyphg 1 Invoice 1h7pk919vl9j 1 Invoice 1J7D-KMN6-M 1 Invoice 1KKL-RDTN-F 1 Invoice 1LLG-6XQG-V 1 Invoice 1 MLQ-NYTG-1 1 Invoice 1nkyxgxj74xk 1 Invoice 1 NYV-D4GH-7 1 Invoice Total AMAZON CAPITAL SERVICES: ASSOCIATED BAG COMPANY G390114 1 Invoice Total ASSOCIATED BAG COMPANY: Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 1 Oct 21, 2022 01:51 PM Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number 3RD QTR UTILITY BILLS 10/07/2022 11/07/2022 2,102.18 1022 605.55.09.03.5710 3RD QTR UTILITY BILLS 10/07/2022 11/07/2022 2,102.18 1022 601.61.63.42.5701 3RD QTR UTILITY BILLS 10/07/2022 11/07/2022 1,051.09 1022 205.03.30.00.5704 3RD QTR UTILITY BILLS 10/07/2022 11/07/2022 1,051.09 1022 205.03.00.00.6056 6,306.54 SPEED SIGN BATTERIES 10/04/2022 11/04/2022 1,700.00 1022 100.02.20.01.5722 SPEED SIGNS 10/11/2022 11/11/2022 5,065.00 1022 100.04.51.03.5743 SPEED SIGNS 10/11/2022 11/11/2022 2.000.00 1022 100.02.20.01.5405 MONTHLY CHARGES AUG/SEP 22 09/30/2022 MONTHLY CHARGES AUG/SEP 22 09/30/2022 MONTHLY CHARGES AUG/SEP 22 09/30/2022 MONTHLY CHARGES AUG/SEP 22 09/30/2022 8,765.00 10/30/2022 609.84 922 100.04.51.07.5704 10/30/2022 1,352.74 1022 605.56.09.21.5835 10/30/2022 1,352.75 1022 601.61.61.12.5702 10/30/2022 1.116.37 922 100.04.51.07.5704 KITCHEN SUPPLIES 10/06/2022 11/05/2022 139.24 1022 100.02.20.01.5704 PRINT 10/10/2022 11/09/2022 57.62 1022 100.05.71.01.5711 ELECTRIC STAPLER CLERICAL 10/13/2022 11/12/2022 15.02 1022 100.02.20.01.5701 ELECTRONIC MATERIALS -AMAN 10/15/2022 11/14/2022 176.33 1022 100.05.71.03.5711 CABLE ADAPTERS 09/28/2022 10/28/2022 29.91 1022 100.01.14.00.5701 WHITE OUT CLERICAL 10/16/2022 11/15/2022 22.50 1022 100.02.20.01.5701 USB FLASH DRIVES 10/16/2022 11/15/2022 44.59 1022 100.01.14.00.5701 NOV CRAFTERNOON 10/10/2022 11/09/2022 119.39 1022 100.05.71.00.6062 BOOK SALE LABELS 10/05/2022 11/04/2022 87.45 1022 100.05.71.00.5752 AV 10/10/2022 11/09/2022 25.37 1022 100.05.71.02.5711 INNOVATIVE GRANT - VR 10/16/2022 11/15/2022 39.98 1022 100.05.71.00.5740 TOURNIQUETS 10/04/2022 10/03/2022 324.75 1022 100.02.20.01.5722 PROGRAMMING - GOLF HOLES 10/18/2022 11/18/2022 49.88 1022 100.05.71.00.6062 3 MIL CLEAR CAN LINERS 10/04/2022 11/04/2022 1.832.95 1022 100.04.51.11.5415 1,832.95 AT&T 262679561410 1 Invoice MONTHLY-CENTREX LINES 10/01/2022 10/24/2022 219.16 1022 100.01.06.00.5601 2938103708 1 Invoice MONTHLHY CHARGES 10/07/2022 11/06/2022 376.20 1022 100.01.06.00.5601 3754282700 1 Invoice MONTHLY PRI-PD & CITY HALL 09/19/2022 10/19/2022 45.21 1022 100.01.06.00.5601 99137743707 1 Invoice MONTHLY AT&T CHARGES 10/07/2022 11/06/2022 497.84 1022 100.01.06.00.5601 16 CITY OF MUSKEGO Invoice Number SegNo Type Total AT&T BAKER & TAYLOR COMPANY 2037037454 1 Invoice 2037042839 1 Invoice 2037044648 1 Invoice 2037050993 1 Invoice 2037053907 1 Invoice 2037056008 1 Invoice 2037062533 1 Invoice 20370625334 1 Invoice 2037065492 1 Invoice 2037073402 1 Invoice Total BAKER & TAYLOR COMPANY: BAKER & TAYLOR ENTERTAINMENT H62587160 1 Invoice H62587161 1 Invoice H62656000 1 Invoice H62703130 1 Invoice H62703131 1 Invoice Total BAKER & TAYLOR ENTERTAINMENT: BAYCOM INC 41108 1 Invoice equipinv 03973 1 Invoice EQ U I P I N V0399 1 Invoice PB2731 1 Invoice Total BAYCOM INC: BOBCAT PLUS, INC. IB19379 1 Invoice Total BOBCAT PLUS, INC.: BUILDING SERVICE INC. 162351 1 Invoice Total BUILDING SERVICE INC.: CARDMEMBER SERVICE 0042skISEPT2 2 Invoice 0042skISEPT2 1 Invoice 0067blosept 2 Invoice 0067blosept 1 Invoice 0067blosept 3 Invoice 0083TZSEPT2 1 Invoice 0286jwS E PT22 1 Invoice 1472LMSEPT2 3 Invoice 1472LMSEPT2 4 Invoice 1472LMSEPT2 5 Invoice 1472LMSEPT2 1 Invoice 1472LMSEPT2 2 Invoice 2229rbSe pt22 1 Invoice Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 2 Oct 21, 2022 01:51 PM Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number PRINT 09/27/2022 10/27/2022 403.99 1022 100.05.71.01.5711 PRINT 09/28/2022 10/28/2022 334.27 1022 100.05.71.01.5711 PRINT 09/28/2022 10/28/2022 779.13 1022 100.05.71.01.5711 PRINT 10/03/2022 11/03/2022 627.10 1022 100.05.71.01.5711 PRINT 10/03/2022 11/03/2022 151.13 1022 100.05.71.01.5711 PRINT 10/04/2022 11 /04/2022 1,255.12 1022 100.05.71.01.5711 PRINT 10/06/2022 11/06/2022 383.40 1022 100.05.71.01.5711 PRINT 10/07/2022 11/07/2022 479.91 1022 100.05.71.01.5711 PRINT 10/07/2022 11 /07/2022 102.92 1022 100.05.71.01.5711 PRINT 10/11/2022 11/11/2022 532.81 1022 100.05.71.01.5711 5,049.78 AV 10/05/2022 11 /05/2022 31.48 1022 100.05.71.02.5711 AV 10/05/2022 11 /05/2022 142.45 1022 100.05.71.02.5711 AV 10/11 /2022 11/11/2022 213.70 1022 100.05.71.02.5711 AV 10/12/2022 11 /12/2022 14.98 1022 100.05.71.02.5711 AV 10/12/2022 11/11/2022 27.33 1022 100.05.71.02.5711 PARK ARTHUR CAMERA 10/06/2022 FOBS 09/12/2022 REPLACE LOCATOR LAPTOP/UTIL 09/29/2022 PARK CAMERAS-MANCHESTER/S 10114/2022 SKID AND TOOLCAT PARTS 10/13/2022 10/25/2022 1,473.00 1022 410.08.90.14.6523 10/25/2022 613.00 1022 100.01.14.00.5701 10/25/2022 2,842.00 1022 100.07.01.06.6502 11/15/2022 16.686.50 1022 410.08.90.14.6523 21,614.50 11/13/2022 555.56 1022 100.04.51.07.5405 50% DEPOSIT - 3 6FT TABLE & 14 10/07/2022 10/17/2022 3,231.93 1022 410.08.90.71.6511 3,231.93 RADWELL RELAYS FOR SCRUBBE 09/28/2022 10/24/2022 14.70 922 601.61.61.16.5426 WATER SAMPLES - POSTAGE 09/28/2022 10/24/2022 83.55 922 605.56.09.23.5865 IT -PHOENIX CONFERENCE 10/19/2022 10/19/2022 617.15 1022 100.01.14.00.5303 PD-PHOENIX CON.-FONS 10/19/2022 10/19/2022 213.08 1022 100.02.20.01.5303 CERT RENEWAL .COM 10/19/2022 10/19/2022 20.17 1022 100.01.14.00.5507 VIDEO FEED 09/28/2022 10/24/2022 20.00 1022 215.06.00.00.5704 LEXIS NEXIS 09/28/2022 10/24/2022 316.00 1022 100.01.05.00.5506 SIGHT LENSCOVER 09/28/2022 10/24/2022 91.35 1022 100.02.20.01.5722 K9 MUZZEL LUKA 09/28/2022 10/24/2022 24.13 1022 100.02.20.01.5722 HARNASS LUKA 09/28/2022 10/24/2022 61.16 1022 100.02.20.01.5722 SIGHT LENSCOVER 09/28/2022 10/24/2022 91.35 1022 100.02.20.01.5722 FUR 09/28/2022 10/24/2022 2,829.00 1022 410.08.91.20.6519 GAS, MISC 09/28/2022 10/24/2022 645.88 922 100.04.51.04.5744 17 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 3 Report dates: 10/13/2022-10/25/2022 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number 2965ATSEPT2 1 Invoice HAND SANITIZER 09/28/2022 10/24/2022 32.70 1022 100.06.18.01.5704 3469blaSept22 1 Invoice 08/29/22-09/28/22 BUSINESS INTE 09/28/2022 10/24/2022 109.98 1022 100.05.71.00.5505 3469blaSept22 2 Invoice WAUKESHA FREEMAN - 1YR SUB 09/28/2022 10/24/2022 264.00 1022 100.05.71.01.5711 3469blaSept22 3 Invoice ADIRONDACK CHAIRS & DISPLAY 09/28/2022 10/24/2022 1,578.95 1022 410.08.90.71.6511 3905ahSept22 1 Invoice LIB CARD MO PROMO 09/28/2022 10/24/2022 13.20 1022 100.05.71.00.6062 3905ahSept22 2 Invoice TEEN FOL 09/28/2022 10/24/2022 23.67 1022 100.05.71.00.5752 3913abSept22 1 Invoice FOL KIDS - RETURN 09/28/2022 10/24/2022 15.52- 1022 100.05.71.00.5752 3913abSept22 3 Invoice KIDS PASSIVE PROGRAMMING 09/28/2022 10/24/2022 47.15 1022 100.05.71.00.6062 3913abSept22 2 Invoice FOL KIDS 09/28/2022 10/24/2022 15.60 1022 100.05.71.00.5752 3921tdsept22 3 Invoice GREGG KLANN PICKLEBALL TOU 09/28/2022 10/24/2022 84.94 1022 100.05.72.13.5702 3921tdsept22 1 Invoice RED CROSS BABYSITTING CERTI 09/28/2022 10/24/2022 195.00 1022 100.05.72.14.5730 3921tdsept22 2 Invoice PRESCHOOL CLASS SCISSORS 09/28/2022 10/24/2022 41.94 1022 100.05.72.16.5702 5731SKRSEPT 2 Invoice SOLID WASTE TRANSPORTER LIC 09/28/2022 10/24/2022 751.74 1022 205.03.30.00.5704 5731SKRSEPT 1 Invoice APWA MEMBERSHIP RENEWAL 09/28/2022 10/24/2022 237.00 1022 100.04.19.00.5305 6353LWSEPT2 2 Invoice CLERK'S CONFERENCE HOTEL S 09/28/2022 10/24/2022 24.00 1022 100.01.08.00.5303 6353LWSEPT2 3 Invoice LAPTOP TRAVEL CASE 09/28/2022 10/24/2022 21.80 1022 100.01.08.00.5701 6353LWSEPT2 1 Invoice CLERK'S CONFERENCE MEAL 09/28/2022 10/24/2022 15.62 1022 100.01.08.00.5303 6904cssept22 11 Invoice GAS DARE CLASS JEFFERSON C 09/29/2022 10/24/2022 70.43 1022 100.02.20.01.5301 6904cssept22 9 Invoice BAYMONT DARE JS 09/29/2022 10/24/2022 101.18 1022 100.02.20.01.5301 6904cssept22 3 Invoice GAS DARE CLASS JEFFERSON C 09/29/2022 10/24/2022 67.55 1022 100.02.20.01.5301 6904cssept22 4 Invoice GAENSLEN SCIT UNIFORM 09/29/2022 10/24/2022 18.89 1022 100.02.20.01.5151 6904cssept22 8 Invoice BAYMONT DARE JS 09/29/2022 10/24/2022 101.18 1022 100.02.20.01.5301 6904cssept22 7 Invoice GAS DARE JEFFERSON CO, MO 09/29/2022 10/24/2022 73.10 1022 100.02.20.01.5301 6904cssept22 2 Invoice CELLBRITE CLASS BECK 09/29/2022 10/24/2022 1,295.00 1022 100.02.20.01.5303 6904cssept22 5 Invoice BAYMONT DARE CK 09/29/2022 10/24/2022 101.18 1022 100.02.20.01.5301 6904cssept22 12 Invoice GAS DARE CLASS JEFFERSON C 09/29/2022 10/24/2022 28.15 1022 100.02.20.01.5301 6904cssept22 10 Invoice PRIORITY DISPATCH ECKERMAN 09/29/2022 10/24/2022 365.00 1022 100.02.20.01.5301 6904cssept22 1 Invoice HELMETS RETURNED WHEEL/SP 09/29/2022 10/24/2022 209.97- 1022 100.02.20.01.5722 6904cssept22 6 Invoice BAYMONT DARE CK 09/29/2022 10/24/2022 101.18 1022 100.02.20.01.5301 7106aksept22 4 Invoice CA INTOX NIGHT 09/29/2022 10/24/2022 32.82 1022 100.02.20.01.5721 7106aksept22 3 Invoice GAENSLEN BREACHING TOOL PO 09/29/2022 10/24/2022 91.99 1022 100.02.20.01.5151 7106aksept22 5 Invoice KUSTOM SIGNAL TUNING FORKS 09/29/2022 10/24/2022 132.00 1022 100.02.20.01.5405 7106aksept22 1 Invoice SPIT MASKS 09/29/2022 10/24/2022 143.24 1022 100.02.20.01.5722 7106aksept22 2 Invoice CA BINDERS 09/29/2022 10/24/2022 66.06 1022 100.02.20.01.5721 7547GWSEPT 2 Invoice GE APPLIANCES 09/28/2022 10/24/2022 115.45 1022 100.02.20.01.5415 7547GWSEPT 3 Invoice CITY HALL SUPPLIES 09/28/2022 10/24/2022 129.00 1022 100.01.06.00.5704 7547GWSEPT 6 Invoice MR LOCK 09/28/2022 10/24/2022 33.39 1022 100.01.09.00.5415 7547GWSEPT 5 Invoice POLICE MAINT 09/28/2022 10/24/2022 9.45 1022 100.02.20.01.5415 7547GWSEPT 4 Invoice CITY HALL SUPPLIES 09/28/2022 10/24/2022 10.47 1022 100.01.06.00.5704 7547GWSEPT 7 Invoice VEHICLE MANIT 09/28/2022 10/24/2022 27.69 1022 100.01.09.00.5405 7547GWSEPT 1 Invoice VENDING 09/28/2022 10/24/2022 16.78 1022 100.01.06.00.5702 8312swsept22 3 Invoice EMD PROQA SASHA 09/29/2022 10/24/2022 550.00 1022 100.02.20.01.5301 8312swsept22 5 Invoice EMD CLASS ECKERMANN 09/29/2022 10/24/2022 365.00 1022 100.02.20.01.5301 8312swsept22 4 Invoice EMD CLASS ONDRICKA 09/29/2022 10/24/2022 365.00 1022 100.02.20.01.5301 8312swsept22 2 Invoice PELOCK NTOA CONF. 09/29/2022 10/24/2022 269.00 1022 100.02.20.01.5303 8312swsept22 1 Invoice PRISONER FOOD IR #22-17086 09/29/2022 10/24/2022 17.93 1022 100.02.20.01.5722 9960smSEPT2 1 Invoice CIVIC CONF LODGING (SM, JM) 09/28/2022 10/24/2022 352.52 1022 100.01.03.00.5303 9960smSEPT2 3 Invoice CIVIC CONF MEALS (JM, SM, JK) 09/28/2022 10/24/2022 52.09 1022 601.61.63.42.6056 9960smSEPT2 2 Invoice CIVIC CONF MEALS (JM, SM, JK) 09/28/2022 10/24/2022 80.15 1022 100.01.03.00.5303 9960smSEPT2 4 Invoice CIVIC CONF MEALS (JM, SM, JK) 09/28/2022 10/24/2022 28.05 1022 605.56.09.21.5303 Total CARDMEMBER SERVICE: 13,470.24 CDW GOVERNMENT, INC cg94814 1 Invoice SURFACE W/WINDOWS 11- START 09/09/2022 10/09/2022 221.64 1022 100.07.01.06.6502 Total CDW GOVERNMENT. INC: 221.64 18 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 4 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number CHAPPELL SPORTS 22061 1 Invoice LITTLE BUCKS SHIRTS 10/04/2022 11/04/2022 178.50 1022 100.05.72.13.5702 22064 1 Invoice GREGG KLANN TOURNAMENT SH 10/06/2022 11/06/2022 91.50 1022 100.05.72.13.5702 Total CHAPPELL SPORTS: COLUMBIA PIPE MILWAUKEE 2716357 S1 1 Invoice PIONEER LIFT STATION 10/07/2022 Total COLUMBIA PIPE MILWAUKEE: COMPLETE OFFICE OF WIS 18521 1 Invoice ELECTION SUPPLIES 10/06/2022 21733 1 Invoice ELECTION SUPPLIES 10/11/2022 Total COMPLETE OFFICE OF WIS: CRETEX SPECIALTY PRODUCTS 039448 1 Invoice SEWER SUPPLIES 09/23/2022 Total CRETEX SPECIALTY PRODUCTS: DIVERSIFIED BENEFIT SERV INC. 364615 1 Invoice HRA HEALTH REIMBURSEMENT 10/05/2022 Total DIVERSIFIED BENEFIT SERV INC.: DORNER COMPANY 502595 1 Invoice SEWER SUPPLIES 09/22/2022 Total DORNER COMPANY: EAGLE MEDIA, INC. 135456 1 Invoice CA POLOS 10/04/2022 135524 1 Invoice EAGLE MEDIA 10/04/2022 Total EAGLE MEDIA, INC.: EBSCO INFORMATION SERVICES 2205711 1 Invoice DISCONTINUED PUBLICATION CR 04/13/2022 2301519 1 Invoice PUBLICATION RATE ADJUSTMENT 10/13/2022 Total EBSCO INFORMATION SERVICES: ELECTION SOURCE 22-5763 1 Invoice THERMAL PAPER ROLL FOR DS-2 10/06/2022 Total ELECTION SOURCE: ELLIOTT'S ACE HARDWARE 601005/SEPT2 4 Invoice CH MAINT 09/30/2022 601005/SEPT2 3 Invoice LIB MAINT 09/30/2022 601005/SEPT2 2 Invoice AGATE LIFT STATION 09/30/2022 601005/SEPT2 6 Invoice SEWER CLEANOUT CAPS 09/30/2022 601005/SEPT2 5 Invoice DUCK TAPE 09/30/2022 601005/SEPT2 7 Invoice FLEX COUPLING 09/30/2022 601005/SEPT2 1 Invoice FESTIVAL GROUNDS . SETTLEME 09/30/2022 11/07/2022 95.35 1022 601.61.61.16.5411 95.35 11/05/2022 36.75 1022 100.01.03.00.5704 11/10/2022 281.98 1022 100.01.03.00.5704 10/23/2022 1,440.87 922 601.61.61.16.5427 1,440.87 11/05/2022 420.87 1022 100.01.06.00.5203 420.87 10/22/2022 1,554.45 922 601.61.61.16.5411 1,554.45 10/14/2022 287.82 1022 100.02.20.01.5721 11 /03/2022 234.89 1022 100.02.20.10.5151 522.71 05/13/2022 21.47- 1022 100.05.71.01.5711 11/13/2022 26.99 1022 100.05.71.01.5711 5.52 11/06/2022 90.64 1022 100.01.03.00.5704 90.64 10/31/2022 65.18 1022 100.01.09.00.5415 10/31/2022 31.48 1022 100.05.71.00.5415 10/31/2022 3.23 1022 601.61.61.15.5415 10/31/2022 25.71 1022 601.61.61.16.5427 10/31/2022 7.19 1022 100.04.51.07.5704 10/31/2022 24.27 1022 100.04.51.04.5744 10/31/2022 43.58 1022 100.04.51.11.5415 19 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 5 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number Total ELLIOTT'S ACE HARDWARE: 200.64 EMERGENCY LIGHTING & ELECTRONICS 210822 1 Invoice DRONE CAR EQUIPMENT 10/13/2022 11/12/2022 1,400.00 1022 100.07.20.01.6501 210838 1 Invoice SQUAD 5 LIGHTS/GUN LOCK REP 10/18/2022 11/17/2022 190.00 1022 100.02.20.01.5405 Total EMERGENCY LIGHTING & ELECTRONICS: 1,590.00 ENERGENECS INC. 0044650-IN 1 Invoice PIONEER L/S GRINDER PUMP 09/29/2022 10/29/2022 3,554.75 922 601.61.61.16.5411 Total ENERGENECS INC.: 3,554.75 FASTENAL COMPANY WIMUK94564 1 Invoice 233 WHTSHEETCCRAG 09/29/2022 10/29/2022 61.81 1022 100.04.51.11.5415 Total FASTENAL COMPANY: 61.81 FERGUSON WATERWORKS #1476 0364326 1 Invoice METERS 09/23/2022 10/23/2022 4,530.84 922 605.54.06.53.5702 Total FERGUSON WATERWORKS #1476: 4,530.84 FINDAWAY WORLD LLC 407969 1 Invoice AV 10/07/2022 11/07/2022 67.99 1022 100.05.71.02.5711 Total FINDAWAY WORLD LLC: 67.99 FRANKLIN AGGREGATES INC. 1821848 1 Invoice 116.90 3/4" TB 08/25/2022 10/25/2022 1,455.47 1022 100.04.51.02.5741 1824531 1 Invoice 1 1/4 CABC 09/02/2022 10/02/2022 224.62 922 100.04.51.02.5741 1831951 1 Invoice 63.33 COMMERCIAL #1 STONE 10/06/2022 10/25/2022 1,000.61 1022 100.04.51.02.5741 Total FRANKLIN AGGREGATES INC.: 2,680.70 FRANKLIN, CITY OF 05596.00-OCT 1 Invoice 12442 TC - 3RD QTR 2022 09/30/2022 10/27/2022 24.67 1022 601.61.63.43.5801 09024.00-OCT 1 Invoice 12466 TC - 3RD QTR 2022 09/30/2022 10/27/2022 24.67 1022 601.61.63.43.5801 Total FRANKLIN, CITY OF: 49.34 GAIL BARTZ LEVIN 5487 1 Invoice CLASS INSTRUCTION PUNCH PAS 10/12/2022 11/12/2022 595.00 1022 100.05.72.13.5110 Total GAIL BARTZ LEVIN: 595.00 GALLS, LLC -DBA RED THE UNIFORM TAILOR bc1716561 1 Invoice BECK UNIFORMS 09/26/2022 10/27/2022 85.99 1022 100.02.20.01.5151 bc1719375 1 Invoice SIMUNCAK UNIFORMS 09/28/2022 10/29/2022 28.71 1022 100.02.20.01.5151 bc1720099 1 Invoice FOX UNIFORMS/K9 UNIFORMS 08/29/2022 10/30/2022 649.73 1022 100.02.20.01.5151 Total GALLS, LLC -DBA RED THE UNIFORM TAILOR: 764.43 GAMETIME INC 102947-01-10 1 Invoice VETERANS PLAYGROUND LARGE 09/27/2022 11/01/2022 157,848.60 1022 202.08.94.74.6576 20 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 6 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number Total GAMETIME INC: 157,848.60 GGLEAGUES INV-0188 1 Invoice E-SPORTS LEAGUE PAYMENT FAL 10/11/2022 11/10/2022 28.00 1022 100.05.72.18.5110 INV-0225 1 Invoice ESPORTS LEAGUES SUMMER 10/17/2022 11/16/2022 14.00 1022 100.05.72.18.5110 Total GG LEAGUES: 42.00 GLEASON REDI MIX 316835 1 Invoice 6 BAG AIR, LOAD, FUEL CHARGE 10/04/2022 11/04/2022 395.50 1022 100.04.51.04.5744 316878 1 Invoice 6 BAG AIR 10/05/2022 11/05/2022 387.00 1022 100.04.51.04.5744 Total GLEASON REDI MIX: 782.50 GOODLAND PROPERTY SERVICES 317 2 Invoice PARKARTHUR 10/19/2022 11/03/2022 6,500.00 1022 202.08.94.74.6530 317 3 Invoice TOWN HALL 10/19/2022 11/03/2022 6,000.00 1022 202.08.94.74.6538 317 1 Invoice LIONS PARK 10/19/2022 11/03/2022 5,000.00 1022 202.08.94.74.6581 Total GOODLAND PROPERTY SERVICES: 17,500.00 GREENFIELD POLICE DEPT. 21384 1 Invoice WARRANT- RIVERA, FAITH ELISE 09/03/2022 10/25/2022 716.00 1022 100.01.08.00.4272 Total GREENFIELD POLICE DEPT.: 716.00 HARTLING TRUCKING LLC 362 1 Invoice STONE TO DPW 09/26/2022 10/26/2022 214.14 922 100.04.51.02.5741 Total HARTLNG TRUCKING LLC: 214.14 HAWKINS INC. 6295992 1 Invoice NOZZLE - CHEMICAL FEED 09/09/2022 10/09/2022 194.83 922 605.53.06.31.5750 Total HAWKINS INC.: 194.83 HEARTLAND BUSINESS SYSTEMS 525266-h 1 Invoice MONTHLY-365.GOV O6/15/2022 07/15/2022 109.47 1022 100.01.14.00.5507 546819-h 1 Invoice MONTHLY-365.GOV 09/13/2022 10/13/2022 512.00 1022 100.01.14.00.5507 Total HEARTLAND BUSINESS SYSTEMS: 621.47 HILLER FORD INC 1150291 2 Invoice TRUCK #27 RADIO - CORE 09/30/2022 10/30/2022 300.00- 922 605.56.09.33.5735 1150291 1 Invoice TRUCK #27 RADIO 09/30/2022 10/30/2022 548.62 922 605.56.09.33.5735 Total HILLER FORD INC: 248.62 HUMPHREY SERVICE PARTS 1283386 1 Invoice 3" WHEEL 10/06/2022 11/06/2022 44.98 1022 100.04.51.07.5405 Total HUMPHREY SERVICE PARTS: 44.98 HYDRO EXCAVATORS II LLC HY-OCT22 1 Invoice REFUND OVERPAYMENT 10/14/2022 10/25/2022 25.13 1022 001.00.00.00.1008 21 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 7 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number Total HYDRO EXCAVATORS II LLC: 25.13 HYDROCORP 0067619-IN 1 Invoice MCC 2 YRS - JUNE 2022 06/30/2022 07/30/2022 829.00 1022 605.56.09.23.5815 Total HYDROCORP: 829.00 IDI in393723 1 Invoice REVERSE LOOKUP 09/30/2022 09/30/2022 142.00 1022 100.02.20.01.5722 Total IDI: 142.00 IMPACT ACQUISTIONS LLC 2725854 5 Invoice PD-BASE RATE (10/11/22-1/10/23); 10/11/2022 11/10/2022 583.16 1022 100.02.20.01.5410 2725854 4 Invoice CT -BASE RATE (10/11/22-1/10123); 10/11/2022 11/10/2022 533.39 1022 100.01.08.00.5504 2725854 3 Invoice MAYOR/LAW-BASE RATE (10/11/22 10/11/2022 11/10/2022 515.48 1022 100.01.05.00.5506 2725854 2 Invoice REC-BASE RATE (10/11/22-1/10/23) 10/11/2022 11/10/2022 559.44 1022 100.05.72.10.5401 2725854 1 Invoice FIN -BASE RATE (10/11/22-1/10/23); 10/11/2022 11/10/2022 673.94 1022 100.01.03.00.5410 2725854 6 Invoice COMDEV-BASE RATE (10/11/22-1/1 10/11/2022 11/10/2022 549.24 1022 100.06.18.01.5410 2725854 7 Invoice LIB -BASE RATE (10/11/22-1/10/23); 10/11/2022 11/10/2022 586.57 1022 100.05.71.00.5401 2739091 1 Invoice STAPLES FOR COPIER 10/18/2022 11/17/2022 76.00 1022 100.01.06.00.5704 Total IMPACT ACQUISTIONS LLC: 4,077.22 JAMES IMAGING SYSTEMS INC 1244698 2 Invoice COPIER CHARGES - 2/19-3/18/21 10/19/2022 11/19/2022 23.53 1022 605.56.09.21.5401 1244698 1 Invoice COPIER CHARGES 10/19/22 - 11/1 10/19/2022 11/19/2022 47.07 1022 100.04.51.01.5701 1244698 3 Invoice COPIER CHARGES - 2/19-3/18/21 10/19/2022 11/19/2022 23.53 1022 601.61.63.42.5701 Total JAMES IMAGING SYSTEMS INC: 94.13 JANWING INC- MILW REGION MIL10220625 1 Invoice JUL 22 - AUG 22 FRI CLEANINGS 10/04/2022 10/04/2022 1,350.00 1022 100.05.71.00.5835 Total JANI-KING INC- MILW REGION: 1,350.00 JERRY WILLKOMM INC. 413283 1 Invoice ARMORALL 09/26/2022 10/26/2022 90.96 922 100.04.51.07.5405 Total JERRY WILLKOMM INC.: 90.96 JOERS, STACI oct182022 1 Invoice CLASS INSTRUCTION COOKING IT 10/20/2022 11/18/2022 160.00 1022 100.05.72.18.5110 Total JOERS, STACI: 160.00 KELSEY HUGHES HU-OCT22 1 Invoice REFUND CREDIT 10/14/2022 10/25/2022 3.30 1022 001.00.00.00.1005 Total KELSEY HUGHES: 3.30 KIESLER'S POLICE SUPPLY INC IN200153 1 Invoice NEUMANN GUN 09/29/2022 10/29/2022 511.00 1022 100.02.20.01.5226 Total KIESLER'S POLICE SUPPLY INC: 511.00 22 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 8 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number KONE, INC. 96233363 1 Invoice ELEVATOR MAINT 10012022-12312 10/01/2022 10/31/2022 492.90 1022 100.02.20.01.5415 Total KONE, INC.: 492.90 KUJAWA ENTERPRISES INC. 136232 1 Invoice 10 22 PLANT MAINTENANCE 10/01/2022 11/01/2022 61.00 1022 100.05.71.00.5415 Total KUJAWA ENTERPRISES INC.: 61.00 LANGUAGE LINE SERVICES, INC. 10647524 1 Invoice LANGUAGE LINE SERVICES 09/30/2022 10/30/2022 2.88 1022 100.02.20.01.5722 Total LANGUAGE LINE SERVICES, INC.: 2.88 LANNON STONE PRODUCTS 1341185 1 Invoice RIP RAP MEDIUM AND LIGHT 08/20/2022 10/25/2022 1,559.54 922 100.04.51.02.5741 Total LANNON STONE PRODUCTS: 1,559.54 LAWRENCE KRUEZER KR-OCT22 1 Invoice REFUND CREDIT 10/14/2022 10/25/2022 1,532.28 1022 001.00.00.00.1005 Total LAWRENCE KRUEZER: 1,532.28 LEGACY LANDSCAPING LLC 225564 1 Invoice REMOVE EXISTING PLANTING AN 09/29/2022 10/29/2022 12,958.50 922 216.08.00.00.6503 225566 1 Invoice S79W16132 BAY LN PLACE REBUI 09/29/2022 10/29/2022 1,536.00 922 216.08.00.00.6503 Total LEGACY LANDSCAPING LLC: 14,494.50 LIBERTY PRINTING 10455 1 Invoice BUSINESS CARDS - 5 FOR DPW 10/18/2022 11/02/2022 200.00 1022 100.04.51.01.5701 Total LIBERTY PRINTING: 200.00 LWMMI LE102522 1 Invoice LOSS & DEFENSE 10/05/2022 11/05/2022 6,209.81 1022 100.01.06.00.6108 Total LWMMI: 6,209.81 LYNCH &ASSOCIATES 11845 1 Invoice 2022 BAY LANE STAKING 09/30/2022 10/30/2022 498.13 1022 601.48.00.00.4150 Total LYNCH &ASSOCIATES: 498.13 LYNCH TRUCK CENTER 250934 1 Invoice STRAPS 08/23/2022 10/25/2022 97.22 1022 100.04.51.07.5405 Total LYNCH TRUCK CENTER: 97.22 MARCO TECHNOLOGIES LLC inv10383256 1 Invoice PHONE HELP 09/21/2022 10/21/2022 280.00 1022 100.01.14.00.5840 INV10438080 1 Invoice PHONE SERVICES 10/06/2022 10/21/2022 3,000.00 1022 100.01.14.00.5840 Total MARCO TECHNOLOGIES LLC: 3.280.00 23 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 9 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number MASTER'S TOUCH LLC, THE MA102522 1 Invoice 2022 TAX BILLS 10/18/2022 10/25/2022 4.679.10 1022 100.01.03.00.5801 Total MASTER'S TOUCH LLC, THE: MENARDS 28483 1 Invoice 1/2X4'X8'ACRE PANEL 09/27/2022 28754 1 Invoice FENCE POSTS, PAINT, PAINT TRA 10/03/2022 Total MENARDS: MERGENT INC 1673021180 1 Invoice 10/1/22-9/30/23 HARRIS DIRECOT 10/05/2022 Total MERGENT INC: MICROMARKETING LLC 900572 1 Invoice AV 09/27/2022 Total MICROMARKETING LLC: MIDWEST TAPE 502615770 1 Invoice HOOPLA USAGE 08/22 09/01/2022 502749890 1 Invoice AV 09/30/2022 502749891 1 Invoice AV 09/30/2022 502756839 1 Invoice HOOPLA USAGE 09/22 10/01/2022 502781479 1 Invoice AV 10/07/2022 502782470 1 Invoice AV 10/07/2022 Total MIDWESTTAPE: MILW MET. SEWERAGE DISTRICT 233-22 1 Invoice JUL-SEPT 2022 10/14/2022 Total MILW MET. SEWERAGE DISTRICT: MRA-THE MANAGEMENT ASSC 00422301 1 Invoice HR SERVICES - SEPT 22 (62) 10/0612022 Total MRA-THE MANAGEMENTASSC: MUSKEGO CONCRETE CONST. INC 10-5-22 1 Invoice 16' CURB & GUTTER @WALGREE 10/05/2022 Total MUSKEGO CONCRETE CONST. INC: NELSON SYSTEMS INCORPORATED p102174 1 Invoice ANNUAL PHILLIPS DICT. SOFTWA 10/13/2022 Total NELSON SYSTEMS INCORPORATED: NORD CONSTRUCTION LLC 491-22 1 Invoice LIONS PARK PLAYGROUND WOR 10/12/2022 495-22 1 Invoice DENOON PARK 10/18/2022 496-22 1 Invoice JENSEN PARK 10/18/2022 Total NORD CONSTRUCTION LLC: 4,679.10 10/27/2022 730.02 922 100.04.51.04.5744 11 /03/2022 1,309.79 1022 100.04.51.04.5744 2,039.81 11 /05/2022 403.00 1022 100.05.71.01.5711 403.00 10/27/2022 40.00 1022 100.05.71.02.5711 40.00 09/30/2022 498.31 1022 100.05.71.03.5711 10/30/2022 151.20 1022 100.05.71.02.5711 10/30/2022 223.95 1022 100.05.71.02.5711 10/31/2022 442.22 1022 100.05.71.03.5711 11 /07/2022 347.91 1022 100.05.71.02.5711 11 /07/2022 149.69 1022 100.05.71.02.5711 1,813.28 11/14/2022 362,952.93 1022 601.61.61.03.6072 11/05/2022 5,890.00 1022 100.01.01.00.5820 5,890.00 11 /05/2022 1,500.00 1022 605.54.06.51.5702 1,500.00 11 /30/2022 739.52 1022 100.02.20.01.5504 11/12/2022 8,080.00 1022 202.08.94.74.6581 11/02/2022 8,790.00 1022 202.08.94.74.6571 11/02/2022 7,004.00 1022 202.08.94.74.6577 23,874.00 24 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 10 Report dates: 10/13/2022-10/25/2022 Oct 21, 2022 01:51PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number OLSONS OUTDOOR POWER 187377 1 Invoice HELMET, CHAPS, SAWS 10/18/2022 11/17/2022 461.95 1022 215.06.00.00.5704 187489 1 Invoice PARKS - MOWER 10/20/2022 11/20/2022 60.00 1022 100.04.51.08.5415 Total OLSONS OUTDOOR POWER: 521.95 O'REILLY AUTOMOTIVE INC. 3853-327004 1 Invoice SQUAD 12 10/10/2022 11/10/2022 47.49 1022 100.02.20.01.5405 3853-327127 1 Invoice 2016 CHEVY TAHOE BRAKES 10/12/2022 11/12/2022 183.27 1022 100.01.09.00.5405 Total O'REILLYAUTOMOTIVE INC.: 230.76 PAYNE & DOLAN OF WISCONSIN 1834013 1 Invoice 8.64 LT 12.5MM 10/13/2022 11/12/2022 652.76 1022 100.04.51.02.5740 Total PAYNE & DOLAN OF WISCONSIN: 652.76 PERRILL 258459 1 Invoice ROW WEB APPS 10/01/2022 10/31/2022 85.00 1022 100.04.19.00.4348 Total PERRILL: 85.00 POSTMASTER OF MUSKEGO P0101122 1 Invoice 4TH QTR CITY NEWSLETTER MAI 10/13/2022 10/13/2022 1,956.61 1022 100.01.06.00.5710 Total POSTMASTER OF MUSKEGO: 1,956.61 PROHEALTH CARE 10001672399 1 Invoice BLOOD DRAWS 10/01/2022 10/30/2022 36.05 1022 100.02.20.01.5722 Total PROHEALTH CARE: 36.05 R.S. PAINT & TOOLS LLC 159074 1 Invoice BUNDLES 4' HARDWOOD LATH 10/11/2022 11/11/2022 255.42 1022 100.04.51.04.5744 Total R.S. PAINT & TOOLS LLC: 255.42 RINDERLE TIRE INC. 145646 1 Invoice JOHN DEERE'S 09/27/2022 10/27/2022 192.00 922 100.04.51.11.5735 Total RINDERLE TIRE INC.: 192.00 RUNDLE-SPENCE S3034094.001 1 Invoice SHOP SUPPLIES 06/23/2022 10/25/2022 4.79 1022 601.61.61.15.5415 Total RUNDLE-SPENCE: 4.79 SAFEWAY PEST MANAGEMENT INC. 694545 1 Invoice PEST CONTROL -OLD PD 10/17/2022 11/17/2022 38.00 1022 100.02.20.01.5415 694547 1 Invoice PEST CONTROL- CH 10/12/2022 11/12/2022 40.00 1022 100.01.09.00.5415 695600 1 Invoice PEST CONTROL NEW PD 10/12/2022 11/12/2022 45.00 1022 100.02.20.01.5415 Total SAFEWAY PEST MANAGEMENT INC.: 123.00 SCHULTZ RESORT ROD & GUN CLUB LTD 205 1 Invoice CLASS INSTRUCTION -ARCHERY 10/10/2022 11/10/2022 305.00 1022 100.05.72.13.5110 25 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 11 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number Total SCHULTZ RESORT ROD & GUN CLUB LTD: 305.00 SECURIAN FINANCIAL GROUP, INC. 002832L/NOV2 1 Invoice LIFE INS PREMIUMS 10/14/2022 10/25/2022 2,665.99 1022 100.00.00.00.2207 Total SECURIAN FINANCIAL GROUP, INC.: 2,665.99 SEGAL CONSULTING SE102522 1 Invoice HEALTH INS QUOTE - ETF 10/13/2022 10/13/2022 3,000.00 1022 100.01.06.00.5704 Total SEGAL CONSULTING: 3,000.00 SHERWIN -WILLIAMS CO. 6291-6 1 Invoice ROAD PAINT 09/29/2022 10/29/2022 1,688.50 1022 100.04.51.02.5742 Total SHERWIN-WILLIAMS CO.: 1,688.50 SOUTHEAST SURVEY, LLC 2046 1 Invoice CORNERS OF W162S7936 BAY LA 10/05/2022 10/05/2022 400.00 1022 601.48.00.00.4150 Total SOUTHEAST SURVEY, LLC: 400.00 SPECTRUM 014608809242 1 Invoice CITY FIBER CONNECTION 09/24/2022 10/11/2022 1,668.60 1022 100.01.14.00.5507 015213609232 1 Invoice PD 911/TV 09/23/2022 10/22/2022 216.77 1022 100.02.20.01.5604 015280510062 1 Invoice MOORELAND CONNECITON 10/06/2022 10/23/2022 119.98 1022 100.04.51.11.5415 Total SPECTRUM: 2,005.35 TESS CORNERS VOL FIRE DEPT 3RD QRT REVI 1 Invoice 3RD QUARTER REVIEWS 0701202 10/18/2022 10/18/2022 595.00 1022 100.02.21.00.5850 JUL-SEPT22 1 Invoice QUARTERLY CONTRACT PAYMEN 10/17/2022 11/12/2022 137,012.75 1022 100.02.21.00.5850 Total TESS CORNERS VOL FIRE DEPT. 137,607.75 THE HAPPY MOWER 2535 1 Invoice LAWN MOWING/WEEDS 10/01/2022 10/31/2022 7,250.00 1022 100.04.51.11.5820 2535 3 Invoice MEDIANS/BLVDS 10/01/2022 10/31/2022 1,416.00 1022 100.05.71.00.5415 2535 2 Invoice MEDIANS/BLVDS 10/01/2022 10/31/2022 9,000.67 1022 100.01.06.00.5820 2536 2 Invoice PD LANDSCAPE 10/01/2022 10/31/2022 575.00 1022 100.02.20.01.5415 2536 1 Invoice CITY HALL LANDSCAPE 10/01/2022 10/31/2022 1,666.66 1022 100.01.09.00.5415 Total THE HAPPY MOWER: 19,908.33 TIAA BANK 9187143 1 Invoice STAFF PRINTER LEASE 11/1/22-11/ 10/10/2022 10/30/2022 336.55 1022 100.05.71.00.5401 Total TIAA BANK: 336.55 TOWN OF NORWAY TN-SEIPT22 1 Invoice 3RD QTR 2022 10/14/2022 10/25/2022 38,023.99 1022 601.61.61.10.6068 Total TOWN OF NORWAY: 38,023.99 TOWN SQUARE PUBLICATIONS 230373 1 Invoice CHAMBER PUBLICATION 10/03/2022 11/02/2022 1,500.00 1022 100.06.18.01.5804 26 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 12 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number Total TOWN SQUARE PUBLICATIONS: 1,500.00 US ALLIANCE FIRE PROTECTION 1046-FO89490 1 Invoice SEP 22 ANNUAL DRY SPRINKLER 1 10/07/2022 10/07/2022 490.00 1022 100.05.71.00.5415 10464089491 1 Invoice SEPT 22 SPRINKLER INSPECTION 10/07/2022 11/07/2022 410.00 1022 100.02.20.01.5415 1046-FO89492 1 Invoice SEPT 22 SPRINKLER INSPECTION 10/07/2022 11/07/2022 410.00 1022 100.02.20.01.5415 Total US ALLIANCE FIRE PROTECTION: 1,310.00 US CELLULAR 0535226690 2 Invoice MONTHLY CHARGE - WATER SCA 09/28/2022 10/23/2022 125.50 1022 605.56.09.21.5607 0535226690 4 Invoice MONTHLY CHARGE - IS 09/28/2022 10/23/2022 33.00 1022 100.01.14.00.5601 0535226690 1 Invoice MONTHLY CHARGE-PD 09/28/2022 10/23/2022 265.68 1022 100.02.20.01.5604 0535226690 3 Invoice MONTHLY CHARGE - SEWER SCA 09/28/2022 10/23/2022 125.50 1022 601.61.63.42.5606 0535226690 7 Invoice MONTHLY CHARGE - REC 09/28/2022 10/23/2022 10.00 1022 100.05.72.10.5601 0535226690 5 Invoice MONTHLY CHARGE - FINANCE 09/28/2022 10/23/2022 30.00 1022 100.01.03.00.5601 0535226690 6 Invoice MONTHLY CHARGE - DPW 09/28/2022 10/23/2022 139.50 1022 100.04.51.01.5605 Total US CELLULAR: 729.18 USA BLUE BOOK 129808 1 Invoice LIQUIFRAM FLOUROFILM 10/03/2022 11/03/2022 571.23 1022 605.53.06.32.5702 Total USA BLUE BOOK: 571.23 VERIZON WIRELESS 9917813169 1 Invoice PD MONTHLY CELL 10/10/2022 11/02/2022 1,321.41 1022 100.02.20.01.5604 Total VERIZON WIRELESS: 1,321.41 VIEW, THE 2198.984.019.0 1 Invoice DOUBLE PAYMENT OF UTILITY BIL 10/17/2022 10/25/2022 114.68 1022 001.00.00.00.1005 2198.984.020.3 1 Invoice REFUND CREDIT 10/18/2022 10/25/2022 4.47 1022 001.00.00.00.1005 Total VIEW, THE: 119.15 WAUKESHA COUNTY 21456 1 Invoice BOND-BRIAN JOHN RENNER (21-1 10/15/2022 11/15/2022 500.00 1022 100.01.08.00.4272 Total WAUKESHA COUNTY: 500.00 WAUKESHA LIME & STONE 1822291 1 Invoice 1 1/4 CABC 08/25/2022 09/24/2022 1,232.40 922 100.04.51.02.5741 1822292 1 Invoice 1 114 CABC 08/25/2022 09/24/2022 1,945.74 922 100.04.51.02.5741 Total WAUKESHA LIME & STONE: 3,178.14 WE ENERGIES 4318832595 1 Invoice STREET LIGHTING (00120) 10/07/2022 10/31/2022 5,913.07 1022 100.04.51.06.5910 4322244322 1 Invoice PARKS DEPARTMENT (00123) 10/11/2022 11/02/2022 981.94 1022 100.04.51.11.5910 4324006148 1 Invoice VETERANS MEMORIAL PARK (000 10/12/2022 11/03/2022 137.75 1022 100.04.51.11.5910 Total WE ENERGIES: 7,032.76 WELDERS SUPPLY COMPANY 10314981 1 Invoice MONTHLY ACETYLENE 09/30/2022 10/30/2022 6.65 1022 100.04.51.07.5405 27 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Report dates: 10/13/2022-10/25/2022 Page: 13 Oct 21, 2022 01:51 PM Invoice Number SegNo Type Description Invoice Date Payment Due Date Total Cost GL Period GLAccount Number Total WELDERS SUPPLY COMPANY: WESTERN CULVERT & SUPPLY INC 067054 1 Invoice 24"X20" CMPA 09/30/2022 067157 1 Invoice CULVERTSUPPLIES 10/17/2022 Total WESTERN CULVERT & SUPPLY INC: WIND LAKE AUTO PARTS SEPT 22 STMT 1 Invoice UT SHOP 09/30/2022 SEPT 22 STMT 2 Invoice UT VEHICLE MAINT 09/30/2022 SEPT 22 STMT 3 Invoice DPW SHOP 09/30/2022 Total WIND LAKE AUTO PARTS: WISC DEPT OF JUSTICE - CIB L6806T/SEPT2 1 Invoice BACKGROUND CHECKS 09/30/2022 Total WISC DEPT OF JUSTICE - CIB: ZUERN BUILDING PRODUCTS INC 417712-INV 1 Invoice 2X12-10' ROUGH HARDWOOD 09/21/2022 Total ZUERN BUILDING PRODUCTS INC: Grand Totals: Report Criteria: Detail report. Invoices with totals above $0 included. Paid and unpaid invoices included. [Report]. Description = {—) "1099 adjustment" 6.65 10/30/2022 862.00 922 100.04.51.04.5745 11 /17/2022 1,266.90 1022 100.04.51.04.5745 2,128.90 10/30/2022 32.79 922 601.61.61.15.5415 10/30/2022 162.70 922 605.56.09.33.5735 10/30/2022 458.18 922 100.04.51.07.5405 653.67 10/30/2022 49.00 1022 100.01.06.00.6002 10/21/2022 288.00 922 100.04.51.04.5744 288.00 934,238.53 28 J" USKE V V Sharon Mueller Finance & Administration Director Finance & AdxninistYation Dgxulment Finance & A tion Depmtnent QLuxterly Report October 251, 2022, Finance Committee Meeting Major Projects and Activities being worked on within the Finance & Administration Department: Elections — At the local level, voter turnout for the August 9d' Partisan Primary Election was 45.42%. As voters have begun returning to the polling places, staff sought out alternative polling places to ease congestion. As authorized by Council on September 13d', the polling locations will be as follows: ➢ Lake Point Church - District 1 ➢ Muskego Public Library - District 2 ➢ Fox River Church - Districts 3 and 5 ➢ Muskego City Hall - Districts 4, 6 & 7 The upcoming 2022 Elections and offices on the ballot will include the following: • November 8th Fall General — Governor and Lieutenant; U.S. Senator; U.S. Representative to Congress; State Senator seats (odd -numbered districts); State Representative; State Treasurer; and Secretary of State 2021 Tax Roll/Rates/Bills — Final Settlement with Waukesha County was reconciled and balanced on August 19d' 2022 Audit (Operating, Special Revenue, Capital, BML, Sewer & Water Utility) — The preliminary audit is scheduled to begin December 12d' —13d', with the final audit fieldwork scheduled for May I' — May 5d', 2023. Budgets — The 2023 Public Hearing and budget adoption for City Operating & Debt Service, Special Revenue, Capital & Utilities is scheduled to take place at the October 25d' Common Council meeting and to set the City tax levy and tax rate. Investments — The Federal Reserve raised its short-term interest rates by three-quarters of a percentage point in July and another three-quarters in September bringing the rate to 3.00% to 3.25% currently. The rates are projected to be lifted by another 1.25 points before the year is over, allowing for the City's savings yields to rise over the 4d' quarter and into 2023. Payroll/Benefit Administration — • Staff has been working with the interim human resource coordinator on various benefit administration priorities since May; and will continue to do so until a permanent position is in place. • 3rd Quarter Federal and State payroll tax reports were reconciled and submitted to the IRS and DOR on October 6d'. Other Projects —Continued progression in the collaboration with the Interim Human Resource Coordinator and IT Director to review various HR systems, modules and workflows to aid in onboarding and recruitment. OVER a 29 FINANCE & ADMIN. DIRECTOR'S REPORT 10/25/22 PAGE 2 3rd Quarter General Fund Operating Results — See attached and below. The attached worksheets recap the City's General Fund operating results for the third quarter ending September 30d', 2022. As reported, year-to-date expenditures are under budget by 26.57%, which is well within the 25% benchmark. Compared to the prior year, third quarter net revenues over expenditures results reflect an increase of $289,756 and is due in part to the increase in property taxes and collections of licenses and permits; as well as the rise of short-term interest rates as noted above. As compared to the budget, revenue results typically include significant variances within each category either because of economic factors or the timing of funds received and will become more proportionate with the budget by the 3rd and 4d' quarters. The expenditures also vary due to seasonal events or the timing of transactions such as with recreational program activity, hydrant rental, vehicle replacements and road program costs. Current projections still indicate positive year-end results. As in prior years, please note the `Miscellaneous' revenue category will reflect a transfer in the 0' quarter to allocate interest earning to various special revenue and capital funds. Should you have any questions, please email or contact me at (262) 679-5622. Thank you. 2 30 Budget Actual Over/(Under) % Over/(Under) $11,446,330 $11,436,501 -$9,829 -0.09% - • • - $2,216,872 $1,489,8671 -$727,0051 32.79% • ' - $723,670 1 $691,4181 -$32,252 -4.46% • - • '- $335,000 1 $231,5401 -$103,4601 30.88% ' • • - • $602,248 1 $529,5901 -$72,6581 12.06% - •• •- • $246,250 1 $121,8431 -$124,407 50.52% -• $196,675 $169,071 -$27,604 14.04% • • • $501,000 $38,4141 -$462,586 92.33% - • - • . $326,750 1 $68,8331 -$257,918 -78.93% $16,594,795 1 $14,777,078 1 ($1,817,717)1-10.95% ■ Intergovernmental ■ Licenses and Permits ■ Fines, Forfeits and Penalties ■ Public Charges for Services ■ Intergov. Charges for Services ■ Miscellaneous ■ Other Financing Sources ■ Interdepartmental 31 General Government Common Council/Mayor Finance & Administration Assessor Attorney Non -Departmental Municipal Court Building Maintenance Information Technology Bank Service Charges Budget $261,620 Actual $171,314 Over/(Under) -$90,306 Over/(Under) -34.52% $551,534 $383,837 -$167,697 -30.41% $107,500 $72,370 -$35,130 -32.68% $132,377 $92,393 -$39,984 -30.20% $644,115 $636,362 -$7,753 -1.20% $192,658 $122,440 -$70,218 -36.45% $213,1941 $172,152 -$41,042 -19.250% $465,3251 $327,386 -$137,938 -29.64% 1 $6,5001 $2,574,823 $9,4321 $1,987,687 $2,9321 -$587,136 45.11% -22.800/6 Total Police - Sworn Officers Police - Dispatch & Clerical Volunteer Fire Non -Departmental Building Inspection Tota I Engineering Public Work Budget• d • $5,588,934 $4,133,168 -$1,455,767 -26.05% $838,457 $590,898 -$247,559 -29.53% $898,334 $411,973 -$486,361 -54.14% $23,956 $23,456 -$500 -2.09% $305,117 $247,352 -$57,765 -18.93% $7,654,7981 $5,406,8471-$2,247,952-29.37% 156,9231 $109,792-$47,131-30.03% 938,1661 $2,206,2931-$731,874-24.91% 195.0891 $2,316.084 4779,005-25.17% Planning, Conservation & Development $448,1151 $320,442-$127,673-28.49% Total $448,1151 $320,442-$127,673-28.49% 'Capital Outlay -Operations Computer Replacements Mobile Devices Social Media Archive Police Vehicle Replacements Road Program Public Works Vehicle Replacements Contingency Trf to Comp Abs from GF Budget $18,000 Actual $16,631 Over/(Under) -$1,369 % Over/(Under) -7.60% $10,000 $3,836 -$6,164 -61.64% $5,200 $5,280 $80 1.54% $0 $0 $0 #DIV/0! $725,000 $646,756 -$78,244 -10.79% $0 $0 $0 #DIV/0! $83,000 $0 -$83,000 -100.00% 1 $50,0001 $50,000 $0 0.00% Total $891,200 $722,504 -$168,696 -18.93% Total Expenditures Budget Actual Over/(under) % Over/(under) FM General Government Public Safety Health & Human Services Public Works Culture, Recreation & Education 13Conservation & Development ■Capital Outlay -Operations I% $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 �\o� P a`�o JeN Qec era JF Q Oe O acN q} wad ac�o� \0 1�e a G oyes (�a�`a ■Budget ■Actual 32 Total Revenues $14,777,078 $14,262,218 $514,860 Total Expenditures $12,185,406 $11,960,303 $225,103 • �MM- 'Ir$2,301,915 $289,756 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $ 6, 000, 000 $4,000,000 $ 2, 000, 000 $0 2022 2021 33