Finance Committee

CITY OF VERONA FINANCE COMMITTEE MONDAY, OCTOBER 14. 2019- 6:15 P.M. VERONA CITY CENTER - Conference Room 0110 111 LINCOLN STREET AGENDA 1. Call to order. 2. Roll call 3. Public Comment 4. Discussion and Possible Action re: Recommended Approval of the September 30, 2019 Finance Committee Minutes 5. Discussion and Possible Action re: Resolution R-19-041 Approving the Fee Schedule for 2020 6. Discussion and Possible Action re: Updates on the 2020 Budget 7. Discussion and Possible Action re: City Investment Report-September 2019 8. Discussion and Possible Action re: Revenue and Expenditure Summary Report-September 2019 9. Discussion and Possible Action re: Possible Reimbursement of the TID error in 2018 10. Discussion and Possible Action re: Payment of Bills 11. Adjournment. Chairperson Chad Kemp POSTED: Verona City Hall Verona Public Library Miller's Market City Web Page at www. ci. verona. wi. us 10/11/2019 Notice is hereby given that a quorum of the members of the City Council or other standing committees of the City Council may be present at the meeting of the Finance Committee to gather information about a subject over which they have decision-making responsibility. The City Council and any other standing committees will not take formal action at this meeting IF YOU NEED AN INTERPRETER, MATERIALS IN ALTERNATIVE FORMATS, OR OTHER ACCOMMODATION TO ACCESS THE MEETINGS, PLEASE CONTACT THE CITY CLERK AT 845- 6495 AT LEAST 48 HOURS PRECEDING THE MEETING. EVERY REASONABLE EFFORT WILL BE MADE TO ACCOMMODATE YOUR REQUEST.  City of Verona Finance Committee City Hall - 111 Lincoln Street Verona, WI 53593-1520 MINUTES FINANCE COMMITTEE SEPTEMBER 30, 2019 The meeting was called to order by Chairperson Chad Kemp at 6: 17 p.m. in Conference Room DllO Roll Call: Chairperson Chad Kemp, Alder Kate Cronin and Alder Christine Posey were present Also present: City Administrator Adam Sayre, Finance Director Brian Lamers, Public Works Director Theran Jacobson and Jim Ferolie from Verona Press Public Comment: None Discussion and Possible Action regarding approval of September 23. 2019 Finance Committee minutes: Motion was made by Kemp, seconded by Cronin to approve the September 23, 2019 Finance Committee minutes with no changes noted. Motion carried 3-0. Discussion and Possible Action regarding Updates on the 2020 Budget: Lamers went through the changes that were talked about during last Finance Committee meeting including the elimination of the Economic Development Manager position and other changes came to $115,755, which reduced the $222,000 debt for pavement rehabilitation program with the remainder to be taken out of the capital revolving fund of $80,000 for the public works facility and the remainder out of city center facilities. The Committee asked what the Personnel Committee recommended regarding the Economic Development Manager position. Sayre stated that it was discussed and recommended with a vote of 3-0 to eliminate the position. The Committee asked Public Works Director Theran Jacobson about the Mark Drive and East View/Elm Street improvement projects. Jacobson stated that the fund of $32,000 and $25,000 for those projects is the engineering and design that is done a year ahead of time which is needed to determine the cost of the project for the following year. Posey asked about the replacement schedule for the equipment at the Public Works Department. Jacobson stated the plows are typically 15 years, loaders are on a 5 year replacement but under a trade in plan which is a better cost for the City, the mini excavator about 6 years, street sweeper with a 10 year plan and other equipment varies. Lamers went over the estimated mill rate before TIF would be going from $5.5689 to an estimated $5.5988, but stated we are waiting for the assessed value from the Department of Revenue. Lamers stated the final rate with TIF will not be determined until the other taxing entities get us their levy amounts, but should go down with the correction of the assessment error in the prior year. www.ci.verona.wi.us Lamers asked the Committee if once we get any other information such as General Transportation Aid that Administration make the determination on how to adjust the budget, which would most likely be through the Contingency or adjusting the Capital Revolving funds. Administration will communicate the changes made to the Committee at the next Finance Committee meeting. Adjournment: Motion was made by Cronin, seconded by Posey, to adjourn the Finance Committee Meeting at 6:37 p.m. Motion carried 3-0. Respectfully submitted, Brian Lamers CPA Finance Director www.ci.verona.wi.us  CITY OF VERONA RESOLUTION NO. R-19-041 A RESOLUTION AMENDING THE CITY FEE SCHEDULE WHEREAS, Section 3-6-1 of the Code of Ordinances of the City of Verona was created to establish a schedule of fees that apply to the issuance of licenses, permits, registrations and other such activities as may be determined by the City Council; and WHEREAS, the City Fee Schedule shall be amended from time-to-time by action of the City Council and shall be attached to this Section by reference; and WHEREAS, a review of the current fees schedule resulted in a change to some fees in order to cover associated expenses; NOW, THEREFORE, BE IT RESOLVED by the Common Council of the City of Verona as follows: 1. That the attached City Fee Schedule is hereby approved and authorized. 2. That the attached City Fee Schedule shall become effective and shall be implemented as of January 1, 2020. Adopted this 14th day of October, 2019. CITY OF VERONA BY: Luke Diaz, Mayor SEAL ATTEST: Ellen Clark, Clerk  CITY OF VERONA Fee Schedule AJC Number Fee Category 2019 2020 AOMIN AND PUBLIC RECORDS Insufficient Funds Returned Check Fee Bank Charge Bank Charge Room Tax 7.00% 7.00% 100-46901 Tax/Special Assessment Searches $35.00 $35.00 100-46901 Tax/Special Assessment Searches (expedited) $60,00 $60.00 Photo Copies-Documents $0.25 $0.25 Copies On Digital Storage Devices(CD,DVD) $3.00 $3.00 PUBLIC SAFETY Civil Process-Service of Process Fee $30.00 $30,00 Civil Process-Travel Fee IRS Rate IRS Rate PUBLIC WORKS Driveway Permit Fee $5.00 $5.00 LICENSING AND REGULATION 100-44110 Class A Liquor Retailer's License $500 $500 100-44110 Class A - Fermented Malt Beverage $300 $300 100-44111 Class B Liquor Retailer's License $500 $500 100-44111 Class B - Fermented Malt Beverage $100 $100 100-44111 Reserve Class B $10,000 $10,000 100-44111 Temporary Class B Fermented Malt Beverage $10 $10 100-44111 Temporary Class B Wine License $10 $10 100-44111 Class C Wine License $100 $100 100-44111 Provisional Retail License $15 $15 100-44112 Operator's License-Provisional $10 $10 100-44112 Operator's License-Annual $30 $33 100-44112 Operator's License-2 year $50 $53 100-44113 Cigarette License $100 $100 100-44114 Amusement Device Licenses $100 $100 204-44120 Cable TV Franchise License 5.00% 5.00% 100-44115 Transient Merchant-Direct Sellers Registration Fee $25 $25 100-44115 Transient Merchant-Solicitors $25 $25 Permit Fee for Street Use $25 $25 Permit Required for Nonmetallic Mining $50 $50 Blasting and/or Rock Crushing $100 $100 100-44910 Special Event Permit $143 $143 100-44910 Special Event Permit- Non-profit $43 $43 Fees- Pawnbroker. Secondhand Article and Jewelry $210 $210 Fees- Pawnbroker, Secondhand Article and Jewelry $27.50 $27.50 Fees- Pawnbroker, Secondhand Article and Jewelry $30 $30 Fees- Pawnbroker, Secondhand Article and Jewelry $165 $165 Chicken License $20 $20 Late Fee $5 $5 100-44210 Dog License $20 $25 100-44210 Neutered or Spayed $15 $20 100-44211 Late Fee $5 $5 MOTOR VEHICLES AND TRAFFIC 100-44220 Bike Licenses $5 $5 Snowmobile Renter's License $15 $15 Newstand Permit Fee $25 $25 AJC Number PLANNING & DEVELOPMENT FEES 2019 2020 Land Division 100-44410 Certified Survey Maps $150 + $100/lot $150 + $100/lot 100-44410 Preliminary Plat $300+$50/lot $300+$50/lot 100-44410 Final Plat $300+$25/lot $300+$25/lot Planned Deveto�ment Dlst.rict 100-44416 Concept Plan $300 $300 100-44416 General Development Plan $300 $300 100-44416 Precise Implementation Plan $300 $300 Zoning 100-44413 Conditional Use Permit $300 $300 100-44415 Site Plan Review $300 $300 100-44412 Zoning Map & Regulation Amendments $300 $300 100-44411 Variances/Appeals $300 $300 Miscellaneous 100-44417 Annexation Fee $300 + Taxes $300 + Taxes A/C Number RECREATION 2019 2020 100-46751 Little League Fees $45-$65 $45-$65 100-46752 Adult Softball Fees $100 $100 100-46753 Volleyball Fees $360 $380 100-46754 Soccer Fees $35 -$55 $37 -$55 100-46755 Men's Basketball $575 $595 100-46756 Youth Basketball $30 -$82 $30 -$82 100-46757 Tennis $54 -$69 $54 -$69 100-46758 Rhapsody Classes $30 -$200 N/A 100-46759 Instructional Softball Fees $90 -$105 $90 -$105 100-46760 Swimming Fees $2 -$5 $2 -$5 100-46761 Other Recreation N/A N/A 100-46762 Park Reservations $40 -$60 $50 -$100 100-46763 Hometown USA Concession Stand Various Various 100-46764 Golf Fees $60-$70 N/A 100-46765 Playground Program $122-$142 $135-$155 100-46766 Baseball Field Reservation Fee $20 -$100 $20 -$150 100-46767 Amusement Ticket Fee Various 100-46768 Flag Football $65-$85 $65-$95 100-46769 Instructional Basebll $45-$60 $45 -$60 100-46770 Dance Lessons $114 -$134 $114 -$140 100-46771 Canoeing/kayaking $130 -$150 $130 -$150 100-46773 Adult Yoga $50 -$150 $50 -$150 100-46772 Babysitting Clinic $93 -$108 $93 -$108 100-46774 Youth Camp Soccer $90 -$159 $90 -$159 100-46776 Instructional Soccer $45 -$60 $45 -$60 100-46777 Instr Lacrosse $45 -$60 $45 -$60 100-46778 Instr Volleyball $45 -$60 $45 -$60 100-46780 Youth Volleyball $60 -$75 $60 -$75 Field Usage Fees Resident Teams* Community Park, Veteran's Park and Stampfl Monday-Friday $45 $45 Weekend $60 $60 Night Games add $20 add$20 No-prep Games add$20 add $20 Non-Resident Teams Community Park, Veteran's Park and Stampfl Monday-Friday $100 $100 Weekend $125 $125 Night Games add $20 add$20 No-prep Games add $25 add$25 Tournament Teams Community Park, Veteran's Park and Stampfl Practice Usage $25 $25 Game Usage $125 $125 • A resident team shall have over 50% of its roster made up of City of Verona residents I Prices include up to 5 bags of Diamond Dry if field is wet. Additional bags will be available at a cost of$10 per bag I I A/C Number CEMETERY 2019 2020 206-46540 Burial Lots $800 $800 206-46540 Transfer of Title $25 $25 206-46540 Replacement Deeds $25 $25 206-46540 Staking for Burials $75 $75 206-46540 Staking for Monuments $60 $60 A/C Number BUILDING INSPECTION 2019 2020 New Construction and Addition Permits Building Fees Building Permit Fees shall be the sum of: All Groups Base Fee $50 $50 Group 1: Fee per Square foot of all areas $0.08/sq.ft $0.08/sq.ft Group 2: Fee per Square foot of all areas $0.10/sq.ft $0.10/sq.fl Group 3: Fee per Square foot of all areas $0.08/sq.ft $0.08/sq.fl Electrical Fees Electrical Permit Fees shall be the sum of: All Groups Base Fee $50 $50 Group 1: Fee per Square foot of all areas $0.05/sq.fl $0.05/sq.ft Group 2: Fee per Square foot of all areas $0.06/sq.ft $0.06/sq.fl Group 3: Fee per Square foot of all areas $0.02/sq.ft $0.02/sq.fl Plumbing Fees Plumbing Permit Fees shall be the sum of: All Groups Base Fee $50 $50 Group 1: Fee per Square foot of all areas $0.05/sq.ft $0.05/sq.ft Group 2: Fee per Square foot of all areas $0.06/sq.ft $0,06/sq.ft Group 3: Fee per Square foot of all areas $0.02/sq.ft $0.02/sq.ft HVAC Fees HVAC Permit Fees shall be the sum of: All Groups Base Fee $50 $50 Group 1: Fee per Square foot of all areas $0.05/sq.tt $0.05/sq.ft Group 2: Fee per Square foot of all areas $0.06/sq.ft $0.06/sq.fl Group 3: Fee per Square foot of all areas $0.02/sq.ft $0.02/sq.fl Erosion Control Fees Group 1: $100 per unit for 1-4 units $100 $100 Group 1: $50 per units 5+ $50 $50 Group 2 and 3: $50 per 1,000 Square feet of all areas $50/1,000 sq.ft $50/1,000 sq.ft Ear1y S1ai1 Permit Group 1 $150 $150 Group 2 and 3 $250 $250 Driveway Opening Group 1 $50 $50 Group 2 and 3 $100 $100 Wisconsin Stale Seal 1 and 2 family only $35 $35 Street Tree Fee Per Lot (New construction only) $325 $325 Park Development Fee Per Bedroom (new construction Group 1 only) $300 $300 Library Impact Fee Single Family Per Unit (New construction only) $540 $540 Multi Family Per Unit (New construction only) $371 $371 Police Impact Fee Single Family Per Unit (New construction only) $413 $413 Multi Family Per Unit (New construction only) $368 $368 $1.4094/$1,000 of total project $1.4094/$1,000 of total project cost Non-Residential cost of fracation thereof of fracation thereof Fire Impact Fee Single Family Per Unit $310 $310 Multi Family Per Unit (New construction only) $213 $213 $2.10 per $1 ,000 total project $2.10 per $1,000 total project cost or Non-Residential cost or fraction thereof fraction thereof Water Impact Fee 5/8" & 3/4" $324 $324 1" $610 $810 1-1/2" $1,620 $1,620 2" $2,592 $2,592 3" $4,860 $4,860 4" $8,100 $8,100 Sewer Connection Fees 5/8" & 3/4" $551 $551 1" $1,377 $1,377 1-1/2" $2,754 $2,754 2" $4,407 $4,407 3" $8,262 $8,262 4" $13,771 $13,771 A/C Number BUILDING INSPECTION 2019 2020 Alteration and Repair Permits Building Fees Building permit fees shall be the greater of: Base fee - $50 or: Group 1 $.08 per square foot of all areas Group 2 $.10 per square foot of all areas Group 3 $.06 per square foot - first 10,000 square feet of all areas Electrical Fees Electrical permit fees shall be the greater of: Base fee - $50 or: Group 1 $.05 per square foot of all areas Group 2 $.06 per square foot of all areas Group 3 $.02 per square foot of all areas Plumbing Fees Plumbing permit fees shall be the greater of: Base fee - $50 or: Group 1 $.05 per square foot of all areas Group 2 $.06 per square foot of all areas Group 3 $.02 per square foot of all areas HeatingNenlilating/Air Conditioning Fees HeatingNentilating/Air Conditioning fees shall be the greater of: Base fee - $50 or: Group 1 $.05 per square foot of all areas Group 2 $.06 per square foot of all areas Group 3 $.02 per square foot of all areas Miscelaneous Fees Failure to Obtain an Required Certificate of Occupancy Prior to Occupancy Group 1 $100 $100 Group 2 and 3 $200 $200 Flat Rate Project Permits Deck Permit $100/unit $100/unit Roof Replacement Permit (One & Two Family) $50 $50 All Other Roof Replacement Permit $100 $100 Siding/SoffiUFascia Permit $50 $50 Windows/Doors Permit $50 $50 Water Heater Permit (per unit) $50 $50 Water Treatment Device Permit (per unit) $50 $50 Residential Furnace Permit $50 $50 Residential A/C Permit $50 plus $50 if new install $50 plus $50 if new install Above Ground Swimming Pool Permit $100 $100 Below Ground Swimming Pool Permit $150 $150 Fence Permit $50 $50 Residential Electrical Service Permit $50 $50 Moving of Building/Structures Permit $150 $150 Demolition Permit (per Building) $150 $150 Sign Permit $50 base plus $1.00/sq.ft $50 base plus $1.00/sq.ft Minimim Permit Fee $50 $50 Special Inspections $50/hr $50/hr (Ate Number I BUILDING INSPECTION I 2019 I 2020 Commercial Plan Review Fees Fire Fire Fire Fire Building Fees Bulldln!I HVAC Alarm Sueeression Buildin!I HVAC Alarm Sueeression Area < 2500 Square Feet $260 $160 $130 $130 $260 $160 $130 $130 Area 2501 - 5000 Square Feet $330 $220 $160 $160 $330 $220 $160 $160 Area 5001 - 10,000 Square Feet $550 $260 $315 $315 $550 $260 $315 $315 Area 10,001 - 20,000 Square Feet $750 $400 $620 $620 $750 $400 $620 $620 Area 20,001 - 30,000 Square Feet $1,100 $540 $925 $925 $1,100 $540 $925 $925 Area 30,001 - 40,000 Square Feet $1,500 $830 $1,240 • $1,240 $1,500 $830 $1,240 $1,240 Area 40,001 - 50,000 Square Feet $2,000 $1,100 $1,555 $1,555 $2,000 $1,100 $1,555 $1,555 Area 50,001 - 75,000 Square Feet $2,700 $1,500 $1,880 $1,880 $2,700 $1,500 $1,880 $1,880 Area 75,001 - 100,000 Square Feet $3,400 $2,100 $2,210 $2,210 $3,400 $2,100 $2,210 $2,210 Area 100,001 - 200,000 Square Feet $5,600 $2,700 $2,580 $2,580 $5,600 $2,700 $2,580 $2,580 Area 200,001 - 300,000 Square Feet $9,900 $6,300 $3,030 $3,030 $9,900 $6,300 $3,030 $3,030 Area 300,001 - 400,000 Square Feet $15,000 $9,200 $3,480 $3,480 $15,000 $9,200 $3,480 $3,480 Area 400,001 - 500,000 Square Feet $18,500 $12,000 $3,930 $3,930 $18,500 $12,000 $3,930 $3,930 Area> 500,000 Square Feet $20,000 $13,500 $4,310 $4,310 $20,000 $13,500 $4,310 $4,310  City of Verona Investments September 30, 2019 BANK/BROKER ACCOUNT NAME DUE DATE RATE BALANCE Aug 31, 2019 BALANCE Sept 30, 2019 DANA Inv/Schwab Fed Farm Cr-Agency Security 12/26/2019 1.400% 598,914.00 599,106.00 DANA Inv/Schwab FFCB NTS 6/8/2020 1.520% 548,713.00 548,713.00 DANA Inv/Schwab FHLB-Agency Security 6/26/2020 1.630% 498,490.00 498,410.00 DANA Inv/Schwab FHLB BOND 2/24/2021 1.800% 423,763.25 423,682.50 DANA Inv/Schwab Federal Home Ln 4/30/2021 3.000% 500,730.00 500,450.00 DANA Inv/Schwab FHLB BOND 10/6/2021 1.540% 470,321.25 469,898.50 DANA Inv/Schwab Federal Home Ln 4/27/2020 1.750% 500,020.00 500,000.00 DANA Inv/Schwab Federal Home Ln 7/10/2020 1.650% 499,395.00 498,945.00 DANA Inv/Schwab FHLMC MED TERM NTS 7/2412020 1.850% 572,838.00 572,631.00 DANA Inv/Schwab Federal Home Ln 11/27/2020 1.700% 595,980.00 595,860.00 DANA Inv/Schwab Federal Home Ln 4/27/2021 2.000% 500,035.00 499,900.00 DANA Inv/Schwab FHLMC MED TERM NTS 8/25/2021 1.600% 670,092.75 669,606.75 DANA Inv/Schwab Federal Home Ln 1/20/2021 2.000% 498,255.00 498,390.00 DANA Inv/Schwab FNMA NTS 12127/2019 1.400% 324,798.50 324,701.00 DANA Inv/Schwab Federal Home Ln 6/29/2021 2.000% 497,170.00 497,135.00 DANA Inv/Schwab FHLMC MED TERM NTS 8/17/2021 1.750% 743,047.50 742,860.00 DANA Inv/Schwab FHLMC MED TERM NTS STEP 9130/2021 1.500% 749,182.50 749,362.50 DANA Inv/Schwab Federal Home Ln 8/3/2021 2.250% 499,010.00 498,965.00 DANA Inv/Schwab FHLMC 840778-Mortgage 7/1/2042 4.674% 254,412.29 248,658.11 DANA Inv/Schwab FMLMC 840244-Mortgage 5/1/2043 4.563% 135,755.86 132,962.41 DANA Inv/Schwab FMLMC 840594-Mortgage 11/1/2043 4.035% 147,064.87 146,612.72 DANA Inv/Schwab FMLMC 840798-Mortgage 10/1/2044 4.170% 206,489.61 201,935.68 DANA Inv/Schwab FMLMC 849504-Mortgage 10/1/2044 3.273% 258,954.29 225,082.75 DANA Inv/Schwab FHLMC 640551-Mortgage 3/1/2045 4.252% 167,584.83 153,311.46 DANA Inv/Schwab FHLMC 840752-Mortgage 12/1/2045 4.426% 206,202.17 201,829.40 DANA Inv/Schwab FHLMC 840912-Mortgage 3/1/2046 2.994% 370,480.33 348,542.06 DANA Inv/Schwab FHLMC 640931-Mortgage 11/1/2046 2.564% 864,416.85 840,363.52 DANA Inv/Schwab FHLMC 840978-Mortgage 5/1/1948 2.469% 977,736.34 968,687.34 DANA Inv/Schwab FNMA PL BM1554-Mortgage 6/1/2042 4.721% 160,150.03 151,408.08 DANA Inv/Schwab FNMA PL BM010B7-Mortgage 12/1/2043 4.461% 115,680.24 106,495.97 DANA Inv/Schwab FHLMC BM4041·Mortgage 5/1/2044 4.400% 244,737.21 237,514.63 DANA Inv/Schwab FNMA PL BM1433-Mortgage 7/1/2044 4.448% 146,596.92 142,945.67 DANA Inv/Schwab FNMA PL BM1433-Mortgage 4/1/2047 2.234% 666,260.20 648,147.98 DANA Inv/Schwab FNMA PL BM6101-Mortgage 8/1/2047 2.637% 1,019,063.00 995,570.28 DANA Inv/Schwab GNMA 784807-Mortgage 8/20/1949 2.500% 859,562.50 DANA Inv/Schwab FHLMC 840910-Mortgage 7/1/2043 4.617% 530,346.10 504,693.65 DANA Inv/Schwab Small Business Loan 2/25/2025 5.329% 407,148.88 400,507.21 DANA Inv/Schwab Small Business Loan 1/25/2028 3.900% 305,540.56 302,364.55 DANA Inv/Schwab Small Business Loan 11/25/2042 4.000% 396,474.10 381,356.31 DANA Inv/Schwab Small Business Loan 1/25/2043 3.500% 521,253.37 519,703.82 DANA Inv/Schwab National Australia BK/NY 1/20/2023 3.000% 413,264.00 410,220.00 DANA Inv/Schwab Berkshire Hathaway 1/20/2023 2.750% 391,526.40 390,073.80 DANA Inv/Schwab Westpac Banking Corp 1/20/2023 3.650% 343,872.75 342,085.25 DANA Inv/Schwab US Bank 1/20/2023 3.400% 263,220.00 261,927.50 DANA Inv/Schwab Alphabet Inc 2/25/2024 3.375% 389,684.95 388,867.35 DANA Inv/Schwab Apple Inc 5/11/2024 2.850% 416,116.00 414,596.00 DANA Inv/Schwab Money Market NA 1.860% 810,897.06 345,551.34 LGIP 01 GENERAL NA 2.180% 11,769,938.34 9,810,511.24 LGIP 02 Cemetery Fund NA 2.180% 288,016.33 288,531.84 State Bank of Cross Plains MMI INVESTMENT ACCOUNT NA 2.590% 3,788,042.57 3,716,192.16 Capitol Bank PUBLIC FUNDS ACCOUNT NA 2.470% 2,666,345.99 2,671,373.33 Total Investments 1s 39,333,027.191 $ 37,446,702.16 j • These investments are Mortgages, they will go down each month as Principal is paid and will be reinvested again. 10/07/2019 03:18 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 1/9 User: brian.lamers DB: Verona PERIOD ENDING 09/30/2019 YTD BALANCE ACTIVITY FOR AVAILABLE 2019 09/30/2019 MONTH 09/30/2019 BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET NORMAL (ABNORMAL) INCREASE (DECREASE) NORMAL (ABNORMAL) USED Fund 100 - GENERAL 00000 9,322,772.00 8,361,654.50 82,964.20 961,117.50 89.69 TOTAL REVENUES 9,322,772.00 8,361,654.50 82,964.20 961,117.50 89.69 00000 1,205,000.00 1,103,528.44 200.00 101,471.56 91.58 51100 - COUNCIL 144,424.00 92,032.72 4,200.08 52,391.28 63.72 51200 - MUNICIPAL COURT 106,227.00 73,554.77 5,119.59 32,672.23 69.24 51400 - ADMINISTRATION 958,279.00 673,550.39 84,962.84 284,728.61 70.29 51600 - BUILDINGS AND GROUNDS 98,220.00 56,871.24 8,153.65 41,348.76 57.90 52101 - POLICE ADMINISTRATION 867,139.00 533,601.96 60,605.16 333,537.04 61.54 52102 - POLICE FIELD OPERATIONS 1,862,903.00 1,154,301.86 136,307.95 708,601.14 61.96 52103 - POLICE CRIMINAL INVESTIGATION 413,080.00 275,021.95 30,668.41 138,058.05 66.58 52104 - POLICE BUSINESS OFFICE 232,615.00 177,318.48 15,500.90 55,296.52 76.23 52105 - POLICE SUPPORT SERVICES 379,182.00 275,427.13 20,962.14 103,754.87 72.64 52400 - BUILDING INSPECTOR 276,138.00 188,756.17 21,727.35 87,381.83 68.36 52900 - EMERGENCY PREPAREDNESS 10,700.00 16,536.11 0.00 (5,836.11) 154.54 53100 - PUBLIC WORKS 1,553,191.00 1,133,516.21 133,783.36 419,674.79 72.98 53300 0.00 0.00 0.00 0.00 0.00 55200 - PARKS 658,145.00 469,260.14 53,186.57 188,884.86 71.30 55300 - RECREATION 309,680.00 270,470.65 25,525.34 39,209.35 87.34 56400 0.00 0.00 0.00 0.00 0.00 56900 - PLANNING 247,849.00 123,801.13 6,118.05 124,047.87 49.95 -- TOTAL EXPENDITURES 9,322,772.00 6,617,549.35 607,021.39 2,705,222.65 70.98 Fund 100 - GENERAL: TOTAL REVENUES 9,322,772.00 8,361,654.50 82,964.20 961,117.50 89.69 TOTAL EXPENDITURES 9,322,772.00 6,617,549.35 607,021.39 2,705,222.65 70.98 NET OF REVENUES & EXPENDITURES 0.00 1,744,105.15 (524,057.19) (1,744,105.15) 100.00 Fund 200 - LIBRARY 00000 2,244,612.00 2,251,639.54 18,230.17 (7,027.54) 100.31 TOTAL REVENUES 2,244,612.00 2,251,639.54 18,230.17 (7,027.54) 100.31 00000 2,255,952.00 1,796,435.79 148,616.25 459,516.21 79.63 TOTAL EXPENDITURES 2,255,952.00 1,796,435.79 148,616.25 459,516.21 79.63 Fund 200 - LIBRARY: TOTAL REVENUES 2,244,612.00 2,251,639.54 18,230.17 (7,027.54) 100.31 TOTAL EXPENDITURES 2,255,952.00 1,796,435.79 148,616.25 459,516.21 79.63 NET OF REVENUES & EXPENDITURES (11,340.00) 455,203.75 (130,386.08) (466,543.75) 4,014.14 Fund 201 - SENIOR CENTER 00000 535,207.00 526,890.71 1,034.25 8,316.29 98.45 TOTAL REVENUES 535,207.00 526,890.71 1,034.25 8,316.29 98.45 10/07/2019 03:18 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 2/9 User: brian.laro.ers DB: Verona PERIOD ENDING 09/30/2019 YTD BALANCE ACTIVITY FOR AVAILABLE 2019 09/30/2019 MONTH 09/30/2019 BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET NORMAL {ABNORMAL) INCREASE {DECREASE) NORMAL {ABNORMAL) USED Fund 201 - SENIOR CENTER 00000 535,207.00 300,956.83 29,833.40 234,250.17 56.23 TOTAL EXPENDITURES 535,207.00 300,956.83 29,833.40 234,250.17 56.23 Fund 201 - SENIOR CENTER: TOTAL REVENUES 535,207.00 526,890.71 1,034.25 8,316.29 98.45 TOTAL EXPENDITURES 535,207.00 300,956.83 29,833.40 234,250.17 56.23 NET OF REVENUES & EXPENDITURES 0.00 225,933.88 {28,799.15) {225,933.88) 100.00 Fund 202 - FIRE DEPARTMENT 00000 1,690,736.00 1,682,246.54 0.00 8,489.46 99.50 TOTAL REVENUES 1,690,736.00 1,682,246.54 0.00 8,489.46 99.50 00000 1,690,736.00 999,687.97 114,217.44 691,048.03 59.13 TOTAL EXPENDITURES 1,690,736.00 999,687.97 114,217.44 691,048.03 59.13 Fund 202 - FIRE DEPARTMENT: TOTAL REVENUES 1,690,736.00 1,682,246.54 0.00 8,489.46 99.50 TOTAL EXPENDITURES 1,690,736.00 999,687.97 114,217.44 691,048.03 59.13 NET OF REVENUES & EXPENDITURES 0.00 682,558.57 (114,217.44) (682,558.57) 100.00 Fund 203 - REFUSE AND RECYCLING 00000 721,748.00 719,542.40 14,378.90 2,205.60 99.69 TOTAL REVENUES 721,748.00 719,542.40 14,378.90 2,205.60 99.69 00000 729,649.00 450,696.27 53,262.38 278,952.73 61.77 TOTAL EXPENDITURES 729,649.00 450,696.27 53,262.38 278,952.73 61.77 Fund 203 - REFUSE AND RECYCLING: TOTAL REVENUES 721,748.00 719,542.40 14,378.90 2,205.60 99.69 TOTAL EXPENDITURES 729,649.00 450,696.27 53,262.38 278,952.73 61.77 NET OF REVENUES & EXPENDITURES (7,901.00) 268,846.13 (38,883.48) (276,747.13) 3,402.68 Fund 204 - CABLE FRANCHISE 00000 140,000.00 74,277.10 0.00 65,722.90 53.06 TOTAL REVENUES 140,000.00 74,277.10 0.00 65,722.90 53.06 00000 94,775.00 60,816.07 4,992.92 33,958.93 64.17 10/07/2019 03:18 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 3/9 User: brian.lamers DB: Verona PERIOD ENDING 09/30/2019 YTD BALANCE ACTIVITY FOR AVAILABLE 2019 09/30/2019 MONTH 09/30/2019 BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET NORMAL (ABNORMAL) INCREASE (DECREASE) NORMAL (ABNORMAL) USED Fund 204 - CABLE FRANCHISE TOTAL EXPENDITURES 94,775.00 60,816.07 4,992.92 33,958.93 64.17 Fund 204 - CABLE FRANCHISE: TOTAL REVENUES 140,000.00 74,277.10 0.00 65,722.90 53.06 TOTAL EXPENDITURES 94,775.00 60,816.07 4,992.92 33,958.93 64.17 NET OF REVENUES & EXPENDITURES 45,225.00 13,461.03 (4,992.92) 31,763.97 29. 76 Fund 205 - FORESTRY 00000 29,000.00 28,300.00 1,625.00 700.00 97.59 TOTAL REVENUES 29,000.00 28,300.00 1,625.00 700.00 97.59 00000 34,000.00 33,066.23 3,500.00 933.77 97.25 TOTAL EXPENDITURES 34,000.00 33,066.23 3,500.00 933.77 97.25 Fund 205 - FORESTRY: TOTAL REVENUES 29,000.00 28,300.00 1,625.00 700.00 97.59 TOTAL EXPENDITURES 34,000.00 33,066.23 3,500.00 933.77 97.25 NET OF REVENUES & EXPENDITURES (5,000.00) (4,766.23) (1,875.00) (233.77) 95.32 Fund 206 - CEMETERY 00000 19,160.00 21,344.13 1,505.51 (2,184.13) 111.40 TOTAL REVENUES 19,160.00 21,344.13 1,505.51 (2,184.13) 111.40 00000 13,200.00 8,938.23 922.54 4,261.77 67. 71 TOTAL EXPENDITURES 13,200.00 8,938.23 922.54 4,261.77 67.71 Fund 206 - CEMETERY: TOTAL REVENUES 19,160.00 21,344.13 1,505.51 (2,184.13) 111.40 TOTAL EXPENDITURES 13,200.00 8,938.23 922.54 4,261.77 67.71 NET OF REVENUES & EXPENDITURES 5,960.00 12,405.90 582.97 (6,445.90) 208.15 Fund 207 - SPECIAL ACCOUNTS 00000 638,279.00 1,143,779.77 44,747.45 (505,500.77) 179.20 TOTAL REVENUES 638,279.00 1,143,779.77 44,747.45 (505,500.77) 179.20 00000 0.00 532,499.62 0.00 (532,499.62) 100.00 51100 - COUNCIL 0.00 0.00 0.00 0.00 0.00 52101 - POLICE ADMINISTRATION 0.00 0.00 0.00 0.00 0.00 52102 - POLICE FIELD OPERATIONS 0.00 809.19 0.00 (809.19) 100.00 52103 - POLICE CRIMINAL INVESTIGATION 0.00 9,532.73 436.08 (9,532.73) 100.00 52105 - POLICE SUPPORT SERVICES 0.00 31.62 0.00 (31.62) 100.00 10/07/2019 03:18 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 4/9 User: brian.lamers DB: Verona PERIOD ENDING 09/30/2019 YTD BALANCE ACTIVITY FOR AVAILABLE 2019 09/30/2019 MONTH 09/30/2019 BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET NORMAL (ABNORMAL) INCREASE (DECREASE) NORMAL (ABNORMAL) USED Fund 207 - SPECIAL ACCOUNTS 52200 - FIRE DEPARTMENT 121,001.00 25,840.80 0.00 95,160.20 21.36 52300 - AMBULANCE 517,278.00 469,820.92 0.00 47,457.08 90.83 54600 - SENIOR CENTER 0.00 0.00 0.00 0.00 0.00 55110 - LIBRARY 0.00 1,492.30 0.00 (1,492.30) 100.00 TOTAL EXPENDITURES 638,279.00 1,040,027.18 436.08 (401,748.18) 162.94 Fund 207 - SPECIAL ACCOUNTS: TOTAL REVENUES 638,279.00 1,143,779.77 44,747.45 (505,500.77) 179.20 TOTAL EXPENDITURES 638,279.00 1,040,027.18 436.08 (401,748.18) 162.94 NET OF REVENUES & EXPENDITURES 0.00 103,752.59 44,311.37 (103,752.59) 100.00 Fund 208 - ECONOMIC DEVELOPMENT 00000 3,225.00 1,943.40 253.54 1,281.60 60.26 TOTAL REVENUES 3,225.00 1,943.40 253.54 1,281.60 60.26 00000 0.00 0.00 0.00 0.00 0.00 -- TOTAL EXPENDITURES 0.00 0.00 0.00 0.00 0.00 Fund 208 - ECONOMIC DEVELOPMENT: TOTAL REVENUES 3,225.00 1,943.40 253.54 1,281.60 60.26 TOTAL EXPENDITURES -- 0.00 0.00 0.00 0.00 0.00 NET OF REVENUES & EXPENDITURES 3,225.00 1,943.40 253.54 1,281.60 60.26 Fund 209 - IMPACT FEES 00000 0.00 908,189.83 11,262.00 (908,189.83) 100.00 TOTAL REVENUES 0.00 908,189.83 11,262.00 (908,189.83) 100.00 00000 0.00 410,000.00 0.00 (410,000.00) 100.00 TOTAL EXPENDITURES 0.00 410,000.00 0.00 (410,000.00) 100.00 Fund 209 - IMPACT FEES: TOTAL REVENUES 0.00 908,189.83 11,262.00 (908,189.83) 100.00 TOTAL EXPENDITURES -- 0.00 410,000.00 0.00 (410,000.00) 100.00 NET OF REVENUES & EXPENDITURES 0.00 498,189.83 11,262.00 (498,189.83) 100.00 Fund 300 - DEBT SERVICE 00000 4,952,831.00 5,078,225.05 0.00 (125,394.05) 102.53 TOTAL REVENUES 4,952,831.00 5,078,225.05 0.00 (125,394.05) 102.53 10/07/2019 03:18 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 5/9 User: brian.lamers DB: Verona PERIOD ENDING 09/30/2019 YTD BALANCE ACTIVITY FOR AVAILABLE 2019 09/30/2019 MONTH 09/30/2019 BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET NORMAL (ABNORMAL) INCREASE (DECREASE) NORMAL (ABNORMAL) USED Fund 300 - DEBT SERVICE 00000 5,114,077.00 4,756,904.12 42,883.75 357,172.88 93.02 TOTAL EXPENDITURES 5,114,077.00 4,756,904.12 42,883.75 357,172.88 93.02 Fund 300 - DEBT SERVICE: TOTAL REVENUES 4,952,831.00 5,078,225.05 0.00 (125,394.05) 102.53 TOTAL EXPENDITURES 5,114,077.00 4,756,904.12 42,883.75 357,172.88 93.02 NET OF REVENUES & EXPENDITURES (161,246.00) 321,320.93 (42,883.75) (482,566.93) 199.27 Fund 400 - CAPITAL IMPROVEMENT 00000 5,042,170.00 4,291,835.08 16,738.91 750,334.92 85.12 TOTAL REVENUES 5,042,170.00 4,291,835.08 16,738.91 750,334.92 85.12 00000 32,205.00 92,955.47 0.00 (60,750.47) 288.64 51400 - ADMINISTRATION 0.00 0.00 0.00 0.00 0.00 51600 - BUILDINGS AND GROUNDS 0.00 0.00 0.00 0.00 0.00 52101 - POLICE ADMINISTRATION 75,450.00 0.00 0.00 75,450.00 0.00 52200 - FIRE DEPARTMENT 1,471,485.00 6,647.00 0.00 1,464,838.00 0.45 52300 - AMBULANCE 147,030.00 147,426.71 0.00 (396.71) 100.27 53100 - PUBLIC WORKS 2,895,000.00 6,131,762.93 517,277.58 (3,236,762.93) 211.81 54600 - SENIOR CENTER 62,000.00 31,000.00 0.00 31,000.00 50.00 55110 - LIBRARY 0.00 0.00 0.00 0.00 0.00 55111 - LIBRARY (OLD) 0.00 13,166.99 1,039.05 (13,166.99) 100.00 55200 - PARKS 390,000.00 1,502,320.44 28,395.20 (1,112,320.44) 385.21 56900 - PLANNING 0.00 0.00 0.00 0.00 0.00 --- TOTAL EXPENDITURES 5,073,170.00 7,925,279.54 546,711.83 (2,852,109.54) 156.22 Fund 400 - CAPITAL IMPROVEMENT: TOTAL REVENUES 5,042,170.00 4,291,835.08 16,738.91 750,334.92 85.12 TOTAL EXPENDITURES 5,073,170.00 7,925,279.54 546,711.83 (2,852,109.54) 156.22 NET OF REVENUES & EXPENDITURES (31,000.00) (3,633,444.46) (529,972.92) 3,602,444.46 11,720.7 Fund 401 - CAPITAL REVOLVING FUNDS 00000 510,000.00 602,467.41 3,344.00 (92,467.41) 118.13 TOTAL REVENUES 510,000.00 602,467.41 3,344.00 (92,467.41) 118.13 51400 - ADMINISTRATION 0.00 0.00 0.00 0.00 0.00 52101 - POLICE ADMINISTRATION 103,118.00 109,826.43 0.00 (6,708.43) 106.51 52200 - FIRE DEPARTMENT 0.00 0.00 0.00 0.00 0.00 52300 - AMBULANCE 0.00 0.00 0.00 0.00 0.00 53100 - PUBLIC WORKS 157,750.00 11,456.75 0.00 146,293.25 7.26 54600 - SENIOR CENTER 0.00 28,844.00 4,320.00 (28,844.00) 100.00 55200 - PARKS 55,000.00 48,735.00 0.00 6,265.00 88.61 TOTAL EXPENDITURES 315,868.00 198,862.18 4,320.00 117,005.82 62.96 10/07/2019 03:18 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 6/9 User: brian.lamers DB: Verona PERIOD ENDING 09/30/2019 YTD BALANCE ACTIVITY FOR AVAILABLE 2019 09/30/2019 MONTH 09/30/2019 BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET NORMAL (ABNORMAL) INCREASE (DECREASE) NORMAL (ABNORMAL) USED Fund 401 - CAPITAL REVOLVING FUNDS Fund 401 - CAPITAL REVOLVING FUNDS: TOTAL REVENUES 510,000.00 602,467.41 3,344.00 (92,467.41) 118.13 TOTAL EXPENDITURES 315,868.00 198,862.18 4,320.00 117,005.82 62.96 NET OF REVENUES & EXPENDITURES 194,132.00 403,605.23 (976.00) (209,473.23) 207.90 Fund 404 - TIF 4 00000 697,685.00 701,418.01 281.00 (3,733.01) 100.54 TOTAL REVENUES 697,685.00 701,418.01 281.00 (3,733.01) 100.54 00000 636,425.00 609,419.51 4,677.50 27,005.49 95.76 TOTAL EXPENDITURES 636,425.00 609,419.51 4,677.50 27,005.49 95.76 Fund 404 - TIF 4: TOTAL REVENUES 697,685.00 701,418.01 281.00 (3,733.01) 100.54 TOTAL EXPENDITURES 636,425.00 609,419.51 4,677.50 27,005.49 95.76 NET OF REVENUES & EXPENDITURES 61,260.00 91,998.50 (4,396.50) (30,738.50) 150.18 Fund 406 - TIF 6 00000 2,087,105.00 2,139,183.94 4,209.00 (52,078.94) 102.50 TOTAL REVENUES 2,087,105.00 2,139,183.94 4,209.00 (52,078.94) 102.50 00000 3,925,605.00 1,951,724.13 72,848.82 1,973,880.87 49.72 TOTAL EXPENDITURES 3,925,605.00 1,951,724.13 72,848.82 1,973,880.87 49.72 Fund 406 - TIF 6: TOTAL REVENUES 2,087,105.00 2,139,183.94 4,209.00 (52,078.94) 102.50 TOTAL EXPENDITURES 3,925,605.00 1,951,724.13 72,848.82 1,973,880.87 49.72 NET OF REVENUES & EXPENDITURES (1,838,500.00) 187,459.81 (68,639.82) (2,025,959.81) 10.20 Fund 408 - TIF 8 00000 1,082,544.00 1,082,544.05 0.00 (0.05) 100.00 TOTAL REVENUES 1,082,544.00 1,082,544.05 0.00 (0.05) 100.00 00000 1,000.00 1,131.39 0.00 (131.39) 113.14 TOTAL EXPENDITURES 1,000.00 1,131.39 0.00 (131.39) 113.14 Fund 408 - TIF 8: 10/07/2019 03:18 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 7/9 User: brian.lamers DB: Verona PERIOD ENDING 09/30/2019 YTD BALANCE ACTIVITY FOR AVAILABLE 2019 09/30/2019 MONTH 09/30/2019 BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET NORMAL (ABNORMAL) INCREASE (DECREASE) NORMAL (ABNORMAL) USED Fund 408 - TIF 8 TOTAL REVENUES 1,082,544.00 1,082,544.05 0.00 (0.05) 100.00 TOTAL EXPENDITURES 1,000.00 1,131.39 0.00 (131.39) 113.14 NET OF REVENUES & EXPENDITURES 1,081,544.00 1,081,412.66 0.00 131.34 99.99 Fund 409 - TIF 9 00000 3,939.00 3,939.45 0.00 (0.45) 100.01 -- TOTAL REVENUES 3,939.00 3,939.45 0.00 (0.45) 100.01 00000 1,458,810.00 9,181.39 0.00 1,449,628.61 0.63 TOTAL EXPENDITURES 1,458,810.00 9,181.39 0.00 1,449,628.61 0.63 Fund 409 - TIF 9: TOTAL REVENUES 3,939.00 3,939.45 0.00 (0.45) 100.01 TOTAL EXPENDITURES 1,458,810.00 9,181.39 0.00 1,449,628.61 0.63 NET OF REVENUES & EXPENDITURES (1,454,871.00) (5,241.94) 0.00 (1,449,629.06) 0.36 Fund 410 - TIF 10 00000 0.00 0.00 0.00 0.00 0.00 -- TOTAL REVENUES 0.00 0.00 0.00 0.00 0.00 00000 0.00 0.00 0.00 0.00 0.00 TOTAL EXPENDITURES 0.00 0.00 0.00 0.00 0.00 Fund 410 - TIF 10: TOTAL REVENUES 0.00 0.00 0.00 0.00 0.00 TOTAL EXPENDITURES NET OF REVENUES & EXPENDITURES -- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund 450 - LT ACCOUNT GROUP 00000 0.00 0.00 0.00 0.00 0.00 TOTAL EXPENDITURES 0.00 0.00 0.00 0.00 0.00 Fund 450 - LT ACCOUNT GROUP: TOTAL REVENUES 0.00 0.00 o.oo 0.00 0.00 TOTAL EXPENDITURES -- 0.00 0.00 0.00 0.00 0.00 NET OF REVENUES & EXPENDITURES 0.00 0.00 0.00 0.00 0.00 Fund 500 - INSURANCE FUND 00000 0.00 257,985.00 0.00 (257,985.00) 100.00 10/07/2019 03:18 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 8/9 User: brian.lamers DB: Verona PERIOD ENDING 09/30/2019 YTD BALANCE ACTIVITY FOR AVAILABLE 2019 09/30/2019 MONTH 09/30/2019 BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET NORMAL (ABNORMAL) INCREASE (DECREASE) NORMAL (ABNORMAL) USED Fund 500 - INSURANCE FUND TOTAL REVENUES 0.00 257,985.00 0.00 (257,985.00) 100.00 00000 0.00 267,986.00 30,581.00 (267,986.00) 100.00 - TOTAL EXPENDITURES 0.00 267,986.00 30,581.00 (267,986.00) 100.00 Fund 500 - INSURANCE FUND: TOTAL REVENUES 0.00 257,985.00 0.00 (257,985.00) 100.00 TOTAL EXPENDITURES NET OF REVENUES & EXPENDITURES -- 0.00 0.00 267,986.00 (10,001.00) 30,581.00 (30,581.00) (267,986.00) 10,001.00 100.00 100.00 Fund 600 - WATER UTILITY 00000 2,229,100.00 1,656,235.85 401,347.42 572,864.15 74.30 TOTAL REVENUES 2,229,100.00 1,656,235.85 401,347.42 572,864.15 74.30 00000 1,219,409.00 818,303.73 2,972.50 401,105.27 67.11 57400 - WATER OTHER OPERTING 0.00 484,858.32 306,851.00 (484,858.32) 100.00 57620 - PUMPING 232,121.00 113,917.73 13,398.28 118,203.27 49.08 57640 - WATER TREATMENT 110,725.00 39,573.23 5,123.18 71,151.77 35.74 57660 - T & D-SUPERVISION & ENG 0.00 49,494.74 4,697.06 (49,494.74) 100.00 57662 - T & D-LINES EXPENSE 0.00 3,130.95 198.90 (3,130.95) 100.00 57672 - T & D-MAINT OF RESERVOIRS & STANDPIPES 106,500.00 117,027.28 1,732.54 (10,527.28) 109.88 57673 - T & D-MAINT OF MAINS 75,000.00 71,296.00 939.47 3,704.00 95.06 57675 - T & D-MAINT OF SERVICES 17,500.00 39,430.98 4,900.81 (21,930.98) 225.32 57676 - T & D-MAINT OF METERS 29,000.00 59,814.14 3,651.79 (30,814.14) 206.26 57677 - T & D-MAINT OF HYDRANTS 6,000.00 5,022.89 1,849.53 977.11 83.71 57901 - CUSTOMER ACCTS EXP-METER READING 25,126.00 9,953.23 1,090.73 15,172.77 39.61 57903 - CUSTOMER ACCTS EXP-RECORDS & COLLECTIONS 19,216.00 21,522.34 2,531.81 (2,306.34) 112.00 57920 - ADMINISTRATION/GENERAL EXP 1,315,666.00 156,875.80 16,049.28 1,158,790.20 11.92 TOTAL EXPENDITURES 3,156,263.00 1,990,221.36 365,986.88 1, H,6,041.64 63.06 Fund 600 - WATER UTILITY: TOTAL REVENUES 2,229,100.00 1,656,235.85 401,347.42 572,864.15 74.30 TOTAL EXPENDITURES 3,156,263.00 1,990,221.36 365,986.88 1,166,041.64 63.06 NET OF REVENUES & EXPENDITURES (927,163.00) (333,985.51) 35,360.54 (593,177.49) 36. 02 Fund 601 - SEWER UTILITY 00000 2,421,000.00 1,742,861.35 564,090.87 678,138.65 71.99 TOTAL REVENUES 2,421,000.00 1,742,861.35 564,090.87 678,138.65 71.99 00000 2,717,916.00 1,624,828.78 63,477.57 1,093,087.22 59.78 TOTAL EXPENDITURES 2,717,916.00 1,624,828.78 63,477.57 1,093,087.22 59.78 10/07/2019 03:18 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 9/9 User: brian.lamers DB: Verona PERIOD ENDING 09/30/2019 YTD BALANCE ACTIVITY FOR AVAILABLE 2019 09/30/2019 MONTH 09/30/2019 BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET NORMAL (ABNORMAL) INCREASE (DECREASE) NORMAL (ABNORMAL) USED Fund 601 - SEWER UTILITY Fund 601 - SEWER UTILITY: TOTAL REVENUES 2,421,000.00 1,742,861.35 564,090.87 678,138.65 71.99 TOTAL EXPENDITURES 2,717,916.00 1,624,828.78 63,477.57 1,093,087.22 59.78 NET OF REVENUES & EXPENDITURES (296,916.00) 118,032.57 500,613.30 (414,948.57) 39.75 Fund 602 - STORM WATER 00000 901,300.00 538,655.99 171,267.85 362,644.01 59.76 TOTAL REVENUES 901,300.00 538,655.99 171,267.85 362,644.01 59.76 00000 1,078,543.00 364,572.39 45,663.31 713,970.61 33.80 TOTAL EXPENDITURES 1,078,543.00 364,572.39 45,663.31 713,970.61 33.80 Fund 602 - STORM WATER: TOTAL REVENUES 901,300.00 538,655.99 171,267.85 362,644.01 59.76 TOTAL EXPENDITURES 1,078,543.00 364,572.39 45,663.31 713,970.61 33.80 NET OF REVENUES & EXPENDITURES (177,243.00) 174,083.60 125,604.54 (351,326.60) 98.22 TOTAL REVENUES - ALL FUNDS 35,272,413.00 33,815,159.10 1,337,280.07 1,457,253.90 95.87 TOTAL EXPENDITURES - ALL FUNDS 38,792,247.00 31,418,284.71 2,139,953.06 7,373,962.29 80.99 NET OF REVENUES & EXPENDITURES (3,519,834.00) 2,396,874.39 (802,672.99) (5,916,708.39) 68.10