HomeMy WebLinkAbout5G 2019 3rd Quarter Financial Report
4646 Dakota Street SE
Prior Lake, MN 55372
CITY COUNCIL AGENDA REPORT
MEETING DATE: NOVEMBER 4TH 2019
AGENDA #: 5G
PREPARED BY: DANIELLE AMIRA, ACCOUNTANT
PRESENTER: CATHY ERICKSON, FINANCE DIRECTOR
AGENDA ITEM: CONSIDER APPROVAL OF THE PRELIMINARY 3rd QUARTER 2019
FINANCIAL REPORTS
GOAL AREA
AND
OBJECTIVE:
High-Value City Services
1. Establish financial stability for all funds.
DISCUSSION: Introduction
Staff has prepared preliminary summary financial reports (attached) as of
September 30th, 2019, for the following funds:
• General Fund
• Debt Service Funds
• Cable Fund
• Capital Park Fund
• Revolving Equipment Fund
• Facilities Management Fund
• Permanent Improvement Revolving Fund
• Water Fund
• Sewer Fund
• Water Quality Fund
• Economic Development Authority Special Revenue Fund
The reports reflect revenue and expenditure activity during third quarter
2019. The reports are preliminary, unaudited and may change. The
attached memorandum provides a summary of the significant issues.
As requested by the City Council, comparative information has been
included for the same period of the prior year.
If council members have questions, please feel free to contact me at
952-447-9842 for more information.
ALTERNATIVES: 1. Motion and second as part of the consent agenda to approve the
September 30th, 2019 Financial Report as submitted.
2. Motion and second to remove the Financial Report from the consent
agenda for additional discussion.
RECOMMENDED
MOTION:
Alternative 1.
Page 2
MEMORANDUM
DATE: October 18, 2019
TO: Prior Lake City Council
FROM: Cathy Erickson, Finance Director
RE: Financial Report dated 09/30/2019
The financial reports presented as part of this agenda item reflect activity during the third
quarter of 2019. The significant issues identified at this time are summarized below.
General Fund Summary
Key points for 2019 in comparison to budget:
• Preliminary financial information reflects expenditures exceeding revenues by $921,112
This is expected since the primary funding source is property tax revenue. The 1st half is
received in June and the 2nd half in December.
• Licenses and Permits are 120% of budget through the first half of the year. The primary
driver is building permit revenue. Staff has budgeted 135 single family and town home
building permits. We are currently at 154 permits or 114% of budget. Through
September we are ahead of the 2018 single family home starts through 3rd quarter 2019
(154 in 2019 as compared to 142 in 2018). We are currently ahead of budget for
building permit and plan check fees by $144k. Staff is conservatively estimating that we
will add another 26 building permits in the 4th quarter for a total of 180 permits for the
year. If 180 single family home permits are issued in 2019, this would generate
additional building permit and plan check fees of about $257k above our full year budget.
• Charges for Services are at 77% of budget through the third quarter. The 2019 Project
Admin/Eng. Fee budget anticipated that engineering staff time would be used for 1)
internal engineering on construction projects and on 2) construction observation on
development projects. Due to the timing of projects and overlap of development
projects, it was necessary to use consultants for the construction observation for
development projects. Based on this, staff estimates a $200k shortfall in Project
Admin/Engineer Fees as compared to budget.
• Miscellaneous Revenue is at 89% of budget and lower than 2018 by $129k. Through
the third quarter we have not received as many development agreements and final plats
as anticipated.
• Expenditures are 68% of budget through the third quarter of the year. Police personnel
expenditures are favorable to budget due to the timing of a Police Sergeant retirement
and hiring of the new Commander position. Fire personnel expenditures are also
favorable to budget due to staffing/open paid on call firefighter positions. Administration
expenditures in 2019 include six months of staffing costs for former City Manager Boyles
concurrent with the new City Manager costs. This expenditure was planned to be
funded from reserves. The contract with the former City Manager Frank Boyles ended
September 1st 2019.
• Public Works expenditures include snow/ice management costs from the 1st quarter of
2019 when we experienced significant snow events. Parks expenditures are favorable
to budget through the 3rd quarter due to the timing of significant trail maintenance
expenditures under a cooperative agreement with Scott County. The work and payment
are anticipated for completion in 2020.
• Community Development is at 64% budget primarily due to savings in professional
services for the Comp Plan. Additionally, Administration has some savings in
professional services, as they budget $10k each year for the Community Survey which is
conducted every two years and usually costs around $20k.
Key points for 2019 in comparison to the prior year:
Page 3
• Licenses and Permits are more than the same period in 2018 by $9k. Mainly due to
building permit revenue.
• Charges for Services are lower than in this same period in 2018 by about $140k. Of this
total variance, Project Admin/Eng Fees and City Contract Services are lower than the
same period in 2018 by about $102,000 and $22,000 respectively. The 2019 Project
Admin/Eng. Fee budget is down due to only two construction projects in 2019 compared
to four projects in 2018 and consultants used for construction observation for
development projects, due to the timing of the projects. City Contract Services are down
mainly due to the 2018 Police Services for the Superbowl events at Mystic Lake Casino.
• Miscellaneous Revenue is lower than 2018 by about $128,000. This is primarily due to
less revenue for development administration fees through the 3rd quarter of 2019 as
compared to the prior year. In 2018 the larger developments included Haven Ridge
South, Maple Park Shore Acres and Friendship Church and Trillium Cove.
• Expenditures are higher than the same period in 2018 due to 1) Additional staff positions
in Administration and Police departments 2) our snow and ice management
expenditures are up in 2019 by $70,000 due to the number of Snow related events in
February, March & April requiring fuel and supplies.
General Fund Revenues
Property taxes are received in June, December and January. Revenue from taxes are
recognized on a cash basis for the General Fund. Therefore, tax revenues collected in June are
reflected in this financial report.
Building permits (single family and townhomes) were budgeted at 135 for 2019. As of
September 30, we have exceeded the single family and townhome total budget for the year.
We have collected $971k or 118% of the amount budgeted for building permits and plan check
fees. Revenues associated with building permits and plan check fees are approximately
$28,000 higher than in the third quarter 2018. The following table provides a breakdown of the
third quarter YTD activity by year.
Year Single
Family
Townhomes Commercial /
Industrial
Other
Permits
Total Change
from PY
2019 105 49 2 1640 1796 (8%)
2018 85 57 1 1,810 1953 66%
2017 58 0 24 1091 1173 (25%)
2016 82 4 14 1458 1560 (6%)
2015 86 10 35 1527 1658
The second half payments were received for Municipal State Aid and the township fire
agreements.
Second quarter Franchise fees collected in July are included in this report. Third quarter fees
are recorded in October. Fees collected are comparable to last year at this time.
Project engineering fees are currently at 18% of its annual budget. As mentioned above, the
2019 Project Admin/Eng. Fee budget anticipated that engineering staff time would be used for
1) internal engineering on construction projects and on 2) construction observation on
development projects. Some of the engineering work was done by a consultant vs internally,
and staff work that was to begin in the summer was delayed due to the Highway 13/21
construction project. Based on this, staff estimates a $200k shortfall in Project Admin/Engineer
Fees as compared to budget.
Recreation revenues (including Park admission fees and facility rental) are lower than the
second quarter of 2018, by about $33k primarily due to the decrease in facility rentals due to
tearing down the flowers naturally building and adult league fees as a result of fewer softball
Page 4
leagues. Additionally, parking meter revenue for the current quarter is recorded in the following
quarter as a result of timing/when we receive the revenue from the vendor. Parking revenue for
2019 with the parking meter equipment in place is anticipated to be on budget, around $24k.
Interest earnings are at 138% of budget. The report also reflects a $123k increase in the fair
value of the securities. As rates decreased, the market value of the existing securities has
increased. This is a paper gain; no actual gain is realized because the City holds the securities
until maturity.
Third quarter miscellaneous revenue includes the developer agreement fees of approximately
$113k for Haven Ridge 3rd Addition and Towering Woods.
General Fund Expenditures/Transfers
General Fund expenditures for 2019 represents 68% of the $13,619,154 amended budget. The
level of expenditures (as a percent of budget) are higher than the same period in 2018. Some
key points related to expenditures for the third quarter of 2019 are:
• Police Expenditures are up compared to the same time in 2018, mainly due the addition
of an additional Police officer. Additionally new uniforms costs for new police officers,
the Police Chief and the two new CSO’s. As a reminder, the SMSC provides a quarterly
payment to the City to support the Police dept.. The payment from the SMSC
September YTD is $450,000.
• Administration expenditures in 2019 include staffing costs for the two former City
Managers and the current City Manager. The contract with the former City Manager
Frank Boyles ended September 1st 2019.
• Public Works & Parks expenditures are higher than 2018 due to the number of Snow
related events in February, March & April requiring staff overtime, equipment use, fuel
and supplies. Additionally summer expenses of Asphalt for street patching.
• Recreation Seasonal Temporary staff is over budget by $23k but will be offset by budget
savings on other lines, primarily operating supplies and professional services.
Additionally, we exceeded revenues in Park Shelter Rental and we received about $10k
in sponsorships.
At this point in the year, there are no other significant variances to report. Costs associated with
street, park maintenance and recreation programs are incurred during the summer and fall.
Debt Service Funds
Property taxes and special assessments are received in June, December and January (final tax
settlement). Prepayments have been received for special assessments. Interest earnings are at
192% of the budget.
Scheduled bond payments (interest) were made on the 15th of June. Other bond payments
(principal and interest) will be due on the 15th of December.
Cable Fund
Second quarter PEG access fees collected in July are included in this report. Expenditures are
at 1% of budget. There are planned technology upgrades that will be included in future quarters.
Capital Park Fund
Park Dedication Fees are at 70% of budget. Expenditures include payments for construction
of the Highway 13 trail gap between Five Hawks and Anna Trail, work on the County Rd 21 trail
project and work on the Parks Comprehensive Master plan.
Revolving Equipment Fund
Property taxes, the primary funding source, are received in June, December and January (final
tax settlement).
Page 5
Vehicle and equipment purchases were approved at council meetings earlier in the year.
Completed purchases as of the third quarter include fire engine final payment (originally ordered
in 2018), Fire water tanker chassis, Building department truck, Police department speed sign
trailer, street department trucks and parks department mower.
Facilities Management Fund
Revenues are 87% of the 2019 budget. The Library re-roof was completed and is reflected in
this report.
Permanent Improvement Revolving Fund
Revenues are 72% of the 2019 budget. The approved 2019 street overlay project is complete,
and expenditures are reflected in this report.
Water Fund
The financial report for the Water Fund reflects four billing cycles. YTD consumption has
decreased from 2018 primarily due to a wet Spring/Summer. Water revenues are about 46% of
the 2019 budget which is lower than the same period in 2018. Water Meter Sales are up due to
the AMRS Project.
Operating expenditures and transfers are higher than 2018 mainly due to the ongoing water
meter replacement project and the Beehive software implementation. In addition, the City has
also incurred expenditures for the 2019 Raw Watermain Project as part of the SMSC new water
treatment plant.
Sewer Fund
The financial report for the Sewer Fund reflects four billing cycles. Consumption increased
slightly from 2018. Sewer revenues are at 51% of the budget and slightly higher compared to
third quarter 2018 due to a 2019 rate increase and elimination of the summer sewer rate lock for
the April 1 billing period. The estimated level of wastewater discharge is reevaluated annually in
conjunction with the preparation of the Capital Improvement Program.
Operating expenditures and transfers for 2018 are at 61% of the approved budget. They are
higher than in third quarter of 2018 mainly due to the ongoing water meter replacement project
and the Beehive software implementation.
Water Quality Fund
The financial report for the Water Quality Fund reflects four billing cycles. Water Quality
revenues are based on flat rates per billing cycle. Revenues are slightly higher than 2018 at
59% of the budget primarily due to the 2019 rate increase.
Operational expenditures and transfers are lower than the third quarter 2018 at 47% of budget.
Stormwater Outlet Improvement expenditures totaled $60k in 2019. Also about $6k in
engineering for Hidden View Pond clean out.
Economic Development Authority Special Revenue Fund
Property taxes are received in June, December and January (final tax settlement).
Facility rental payments have been received for the Technology Village Business Incubator.
Personnel, commissioner per diems, professional services and Technology Village Business
Incubator expenditures comprise most of the expenditures and are at 84% of budget as of the
third quarter end.
City of Prior Lake
General Fund Summary
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 9/30/2018 Positive (Negative)
Revenues
Taxes 8,380,973 8,380,973 4,357,465 (4,023,508) 52%4,408,956 (51,491)
Licenses and Permits 642,118 642,118 774,995 132,877 121%765,142 9,853
Intergovernmental 1,861,819 1,861,819 1,202,495 (659,324) 65%1,140,272 62,223
Charges for Services 1,716,170 1,716,170 1,322,439 (393,731) 77%1,462,895 (140,456)
Fines and Forfeitures - - 962 962 n/a 1,448 (486)
Interest (losses) on investments 87,400 87,400 223,019 135,619 255%835 222,185
Other 192,739 192,739 172,281 (20,458) 89%301,155 (128,874)
Transfers in 456,300 456,300 342,225 (114,075) 75%332,250 9,975
Total Revenues 13,337,519 13,337,519 8,395,882 (4,941,637) 63%8,412,954 (17,072)
Expenditures
General Government 3,035,892 3,060,177 2,319,016 741,161 76%2,020,434 (298,583)
Public Safety 6,158,109 6,187,799 4,082,995 2,104,804 66%3,831,233 (251,762)
Public Works 2,060,778 2,060,778 1,411,923 648,855 69%1,362,630 (49,293)
Culture and Recreation 1,964,771 1,975,631 1,360,850 614,781 69%1,455,202 94,352
Transfer to other funds 334,769 334,769 142,209 192,560 42%491,609 349,400
Total Expenditures 13,554,319 13,619,154 9,316,993 4,302,161 68%9,161,107 (155,886)
Net Change (216,800) (281,635) (921,112) (748,153)
COMPARATIVE
City of Prior Lake
General Fund Revenues
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive ( Negative)USED 9/30/2018 Positive (Negative)
Taxes
101 31010.00 Current Property Taxes - General Purpose 7,460,524 7,460,524 3,835,789 (3,624,735) 51%3,916,221 (80,432)
101 31020.00 Delinquent Property Taxes - General Purp - - 30,402 23,782 n/a 23,782 6,621
101 31040.00 Fiscal Disparities 920,449 920,449 491,274 (429,175) 53%468,953 22,321
101 33423.00 Market Value Credit Aid - - - - n/a - -
Taxes 8,380,973 8,380,973 4,357,465 (4,023,508) 52%4,408,956 (51,491)
Licenses and Permits
101 32100.00 Business Licenses 900 900 945 45 105%600 345
101 32110.00 Liquor Licenses 74,790 74,790 72,540 (2,250) 97%77,115 (4,575)
101 32160.00 Refuse Haulers 4,500 4,500 4,835 335 107%4,790 45
101 32180.00 Cigarette Licenses 2,250 2,250 2,295 45 102%2,250 45
101 32210.00 Building Permits 446,498 446,498 567,255 120,757 127%501,213 66,041
101 32211.00 Retainage Forfeiture - - - - n/a 1,500 (1,500)
101 32215.00 Mechanical Permits 50,833 50,833 63,151 12,318 124%84,966 (21,815)
101 32230.00 Plumbing Permits 42,658 42,658 41,386 (1,272) 97%66,985 (25,599)
101 32231.00 Sewer/Water Inspection 7,399 7,399 10,179 2,780 138%10,856 (677)
101 32232.00 Plumbing Registrations 1,200 1,200 1,790 590 149%1,228 562
101 32240.00 Animal Licenses 3,750 3,750 4,390 640 117%3,860 530
101 32260.00 Burning Permits 4,000 4,000 3,080 3,000 77%3,310 (230)
101 32270.00 Short-term Rental Fee 3,000 3,000 2,050 (950) 68%1,020 1,030
101 32175.00 Public Private Gathering Permit 240 240 600 360 250%750 (150)
101 32190.00 Community Event Application 100 100 500 400 500%4,700 (4,200)
Licenses and Permits 642,118 642,118 774,995 132,877 121%765,142 9,853
COMPARATIVE
City of Prior Lake
General Fund Revenues
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive ( Negative)USED 9/30/2018 Positive (Negative)
COMPARATIVE
Intergovernmental
101 33160.11 Fed Aids/Grants - Operating Police 17,000 17,000 4,444 (12,556) 26%2,352 2,092
101 33401.00 Local Government Aid 11,905 11,905 5,953 (5,953) 50%5,953 -
101 33416.01 State Aid - Police Train 10,800 10,800 24,854 14,054 230%23,925 929
101 33416.02 State Police Aid-Ins Prem 215,000 215,000 - (215,000) 0%- -
101 33417.00 State Aid - Fire Training 7,000 7,000 36,631 29,631 523%12,579 24,052
101 33418.00 State Road & Bridge Aid 377,209 377,209 340,926 (36,283) 90%338,589 2,337
101 33420.00 State Fire Aid-Ins. Prem.220,000 220,000 4,000 (216,000) 2%2,000 2,000
102 33422.11 State Aids/Grants - Operating Police 3,000 3,000 900 (2,100) 30%2,959 (2,059)
101 33610.11 County Aids/Grants - Operating Police - - - - n/a 27,856 (27,856)
101 33610.10 County Aids/Grants - Operating Grant - - 1,000 1,000 n/a - 1,000
101 33620.00 Township Fire & Resc Aid 314,136 314,136 314,136 - 100%296,559 17,577
101 33621.00 Liaison Aid 49,769 49,769 - (49,769) 0%- -
100 33630.00 Metro Council Grants - - - - n/a - -
101 33631.00 Payment in Lieu of Taxes 600,000 600,000 450,000 (150,000) 75%427,500 22,500
101 33700.11 Miscellaneous Grants - Operating Police 36,000 36,000 19,651 (16,349) 55%- 19,651
Intergovernmental 1,861,819 1,861,819 1,202,495 (659,324) 65%1,140,272 62,223
Charges for Services
101 31810.00 Franchise Taxes 615,000 615,000 318,045 (296,955) 52%312,552 5,493
101 34103.00 Zoning & Subdivision Fees 20,857 20,857 23,535 2,678 113%33,215 (9,680)
101 34104.00 Plan Check Fees 277,528 277,528 289,383 11,855 104%279,139 10,243
101 34105.00 Sale of Maps/Publications - Reports 1,000 1,000 837 (163) 84%480 357
101 34107.00 Assessment Searches - Reports 400 400 550 150 138%415 135
101 34109.00 Project Admin/Eng Fees 263,000 263,000 47,961 (215,039) 18%149,830 (101,869)
101 34203.00 Accident/Warrant Reports - Reports 200 200 75 (125) 38%103 (28)
101 34731.00 Adult League Fees 14,000 14,000 9,794 (4,206) 70%14,237 (4,443)
101 34735.00 Recreation Program Fees 47,000 47,000 40,241 (6,759) 86%42,109 (1,868)
101 34735.01 Recreation Program Fees Regular 6,000 6,000 15,424 9,424 257%10,615 4,809
101 34740.00 Concessions - Park Fees 300 300 - (300) 0%822 (822)
101 34760.01 Facility Rental - Regular 35,418 35,418 26,303 (9,115) 74%44,828 (18,525)
101 34761.00 Studio/Pavilion Rental 24,000 24,000 17,888 (6,112) 75%19,498 (1,610)
101 34762.00 Park Shelter Rental 42,500 45,500 54,480 8,980 120%49,778 4,702
101 34763.13 Facility Usage Fee (not taxable)3,000 - 1,200 1,200 n/a - 1,200
101 34765.01 Tower Leases 291,967 291,967 310,692 18,725 106%283,862 26,830
101 34780.00 Park Admission Fees 24,000 24,000 18,738 (5,262) 78%34,948 (16,211)
101 34783.00 City Contract Services 50,000 50,000 137,951 87,951 276%159,496 (21,545)
City of Prior Lake
General Fund Revenues
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive ( Negative)USED 9/30/2018 Positive (Negative)
COMPARATIVE
101 36220.16 Prof Services Fee Deposit Bldg. Inspection - - 9,342 9,342 n/a 26,967 (17,625)
Charges for Services 1,716,170 1,716,170 1,322,439 (393,731) 77%1,462,895 (140,456)
Fines and Forfeitures
101 35101.00 County Court Fines - - - - n/a 1,000 (1,000)
101 35104.00 Prosecution Restitution - - 962 962 n/a 448 514
Fines and Forfeitures - - 962 962 n/a 1,448 (486)
Interest (losses) on investments
101 36210.00 Interest Earnings 87,400 87,400 120,858 33,458 138%97,362 23,496
101 36215.00 Amortization - Premium/Discount - - (12,964) (12,964) n/a (16,334) 3,370
101 36226.00 Realized Inv Gain/(Loss)- - (7,853) (7,853) n/a - (7,853)
101 36225.00 Unrealized Inv.Gain(Loss)- - 122,978 122,978 n/a (80,194) 203,172
Interest (losses) on investments 87,400 87,400 223,019 135,619 255%835 222,185
Other Miscellaneous Revenues
101 36101.00 City Assess. Collection - - - - n/a - -
101 36102.00 County Assess. Collection 5,000 5,000 2,008 (2,992) 40%1,979 29
101 36211.00 Developer Agreements 158,000 158,000 113,021 (44,979) 72%253,104 (140,083)
101 36212.00 Miscellaneous Revenue 29,739 29,739 39,141 9,402 132%23,527 15,614
101 36230.00 Contributions & Donations - - 12,719 12,719 n/a 19,401 (6,681)
101 39102.00 Sale of Property - - 5,391 5,391 n/a 3,145 2,247
Other Miscellaneous Revenues 192,739 192,739 172,281 (20,458) 89%301,155 (128,874)
Other financing sources
101 39203.00 Transfer from Other Funds 456,300 456,300 342,225 (114,075) 75%332,250 9,975
Other financing sources 456,300 456,300 342,225 (114,075) 75%332,250 9,975
Total Revenues 13,337,519 13,337,519 8,395,882 (4,941,637) 63%8,412,954 (17,072)
City of Prior Lake
General Fund Expenditures
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance from
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Function: General Government
41110.00 MAYOR & COUNCIL 71,866 71,866 50,512 21,354 70%44,411 (6,101)
41130.00 ORDINANCE 7,500 7,500 2,908 4,592 39%4,874 1,967
41320.00 ADMINISTRATION 436,935 436,935 408,644 28,291 94%303,092 (105,552)
41330.00 BOARDS & COMMISSIONS 11,765 11,765 6,459 5,306 55%6,739 280
41400.00 CITY CLERK FUNCTIONS 60,550 60,550 50,830 9,721 84%- (50,830)
41410.00 ELECTIONS - - 403 (403) n/a 13,903 13,500
41520.00 FINANCE 480,310 485,705 342,797 142,908 71%308,661 (34,136)
41540.00 INTERNAL AUDITING 31,300 31,300 34,864 (3,564) 111%30,190 (4,674)
41550.00 ASSESSING 202,600 202,600 200,100 2,500 99%192,400 (7,700)
41610.00 LEGAL 200,000 200,000 104,962 95,038 52%120,711 15,749
41820.00 HUMAN RESOURCES 188,830 188,830 131,369 57,461 70%117,402 (13,966)
41830.00 COMMUNICATIONS 128,297 128,297 90,074 38,223 70%82,282 (7,792)
41910.00 COMMUNITY DEVELOPMENT 348,365 348,365 222,271 126,094 64%216,528 (5,743)
41920.00 INFORMATION TECHNOLOGY 394,650 413,540 325,267 88,273 79%244,720 (80,547)
41940.00 FACILITIES - CITY HALL 472,924 472,924 347,556 125,368 73%334,519 (13,037)
Total - Function General Government 3,035,892 3,060,177 2,319,016 741,161 76%2,020,434 (298,583)
Function: Public Safety
42100.00 POLICE 4,586,881 4,616,571 3,161,646 1,454,925 68%2,892,737 (268,909)
42200.00 FIRE 932,896 932,896 474,749 458,147 51%498,942 24,193
42400.00 BUILDING INSPECTION 599,949 599,949 418,221 181,728 70%413,085 (5,136)
42500.00 EMERGENCY MANAGEMENT 11,935 11,935 9,779 2,156 82%8,869 (910)
42700.00 ANIMAL CONTROL 26,448 26,448 18,600 7,848 70%17,600 (1,000)
Total - Function Public Safety 6,158,109 6,187,799 4,082,995 2,104,804 66%3,831,233 (251,762)
Function: Public Works
43050.00 ENGINEERING 373,844 373,844 239,683 134,161 64%247,595 7,913
43100.00 STREET 1,226,903 1,226,903 896,674 330,229 73%859,458 (37,216)
43400.00 CENTRAL GARAGE 460,031 460,031 275,566 184,465 60%255,576 (19,990)
Total - Function Public Works 2,060,778 2,060,778 1,411,923 648,855 69%1,362,630 (49,293)
Function: Culture and Recreation
45100.00 RECREATION 416,675 397,475 316,793 80,682 80%347,819 31,026
45200.00 PARKS 1,481,141 1,511,201 993,181 518,020 66%1,073,194 80,013
45500.00 LIBRARIES 66,955 66,955 50,876 16,079 76%34,189 (16,687)
Total - Function Culture and Recreation 1,964,771 1,975,631 1,360,850 614,781 69%1,455,202 94,352
00000.00 Transfer to Other Funds 334,769 334,769 142,209 192,560 42%491,609 349,400
Total Expenditures 13,554,319 13,619,154 9,316,993 4,302,161 68%9,161,107 (155,886)
COMPARATIVE
City of Prior Lake
Debt Service Funds
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Property Taxes
Current Property Taxes 3,262,770 3,262,770 1,689,839 (1,572,931) 52%1,739,390 (49,551)
Special Assessments
City Assess. Collections - - 84,140 84,140 n/a 113,925 (29,786)
County Assess. Collection 646,901 646,901 248,993 (397,908) 38%293,335 (44,342)
Interest (losses) on investments
Interest Earnings 33,703 33,703 64,774 31,071 192%46,644 18,130
Unrealized Inv.Gain(Loss)- - 63,980 63,980 n/a (31,364) 95,344
Other Financing Sources
Transfer from Other Funds 1,131,409 1,131,409 141,580 (989,830) 13%379,134 (237,555)
Total Revenues 5,074,783 5,074,783 2,293,304 (2,781,479) 45%2,541,064 (247,759)
Expenditures
Debt Service
Principal 4,193,512 4,193,512 131,062 4,062,450 3%128,328 (2,734)
Interest and Other 1,146,472 1,146,472 615,591 530,881 54%491,056 (124,535)
Bond Issuance Costs 5,343 5,343 1,245 4,098 23%1,990 745
Transfers to Other Funds 135,000 135,000 - 135,000 0%2,419 2,419
Total Expenditures 5,480,327 5,480,327 747,898 4,732,429 14%623,793 (124,105)
Net Change (405,544) (405,544) 1,545,407 1,917,270
COMPARATIVE
City of Prior Lake
Cable Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Charges for Services
210-41340.00-34304.00 PEG Access Fees 37,133 37,133 14,737 (22,396) 40%20,677 (5,939)
Interest (losses) on investments
210-41340.00-36210.00 Interest Earnings - - 1,278 1,278 n/a 1,399 (122)
210-41340.00-36225.00 Unrealized Inv. Gain (Loss)- - 1,255 1,255 n/a (1,031) 2,287
Total Revenues 37,133 37,133 17,270 (19,863) 47%21,045 (3,774)
Expenditures
Current Expenditures
210-41340.00-52400.20 Small Equipment - Technology 2,295 2,295 243 2,052 11%4,607 4,364
210-41340.00-54020.00 Software Service Contract 510 510 - 510 0%- -
Capital Outlay
210-41340.00-55570.00 Machinery and Equipment 15,000 15,000 - 15,000 0%60,530 60,530
Total Expenditures 17,805 17,805 243 17,562 1%65,137 64,895
Net Change 19,328 19,328 17,028 (44,093)
COMPARATIVE
City of Prior Lake
Capital Park Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Charges for Services
225-45200.00-34760.01 Facility Rental - Regular 24,000 24,000 14,700 (9,300) 61%14,000 700
225-45200.00-34791.00 Dedication Fees 450,000 450,000 315,000 (135,000) 70%393,750 (78,750)
Charges for Services 474,000 474,000 329,700 (144,300) 70%407,750 (78,050)
Interest (losses) on investments
225-00000.00-36210.00 Interest Earnings 24,000 24,000 31,350 7,350 131%23,364 7,986
225-00000.00-36225.00 Unrealized Inv.Gain(Loss)- 31,258 31,258 n/a (17,713) 48,971
Interest (losses) on investments 24,000 24,000 62,608 38,608 261%5,652 56,957
Contributions and donations
225-00000.00-36230.00 Contributions & Donations - - 4,200 4,200 n/a 6,375 (2,175)
Contributions and donations - - 4,200 4,200 n/a 6,375 (2,175)
Total Revenues 498,000 498,000 396,508 (101,492) 80%419,777 (23,268)
Expenditures
54320.00 Miscellaneous - - 395 (395) n/a 2,830 2,435
53100.80 Professional Services-General 50,000 50,000 33,678 16,323 67%15,025 (18,653)
55020.00 Projects-Engineering - - 22,336 (22,336) n/a - (22,336)
55530.00 Infrastructure 420,000 420,000 192,457 227,543 46%7,583 (184,874)
Total Expenditures 470,000 470,000 248,866 221,134 53%25,438 (223,428)
Net Change 28,000 28,000 147,642 394,339
COMPARATIVE
City of Prior Lake
Revolving Equipment Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Taxes
410-00000.00-31010.00 Current Property Taxes 600,000 600,000 310,552 (289,448) 52%304,577 5,975
Taxes 600,000 600,000 310,552 (289,448) 52%304,577 5,975
Intergovernmental
410-00000.00-33633.20 Watershed Dist Grants/Aid-Capital Grants - - - - n/a 10,000 (10,000)
Intergovernmental - - - - - 10,000 (10,000)
Interest (losses) on investments
410-00000.00-36210.00 Interest Earnings 7,775 7,775 19,903 12,128 256%7,772 12,131
410-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 15,177 15,177 n/a (4,602) 19,780
Interest (losses) on investments 7,775 7,775 35,080 27,305 451%3,170 31,910
Sale of assets
410-00000.00-39102.00 Sale of Property - - 8,020 8,020 n/a 19,435 (11,415)
Sale of assets - - 8,020 8,020 n/a 19,435 (11,415)
Other
410-42100.06-39104.00 Forfeiture Property Sales 12,000 12,000 - (12,000) 0%- -
Other 12,000 12,000 - (12,000) 0%- -
Transfers in
410-00000.00-39203.00 Transfer from Other Funds 217,600 217,600 120,000 (97,600) 55%116,250 3,750
Transfers in 217,600 217,600 120,000 (97,600) 55%116,250 3,750
OTHER FINANCING SOURCES
Debt Issued
410-00000.00-39310.00 G.O. Bond Proceeds 248,960 248,960 215,000 (33,960) 86%605,000 (390,000)
Premium on debt issued
410-43100.00-55110.00 Projects - Bond Discount/Premium - - 40,040 40,040 n/a 69,562 (29,522)
248,960 248,960 255,040 6,080 102%674,562 (419,522)
Total Revenues 1,086,335 1,086,335 728,692 (357,643) 67%1,127,994 (399,302)
Expenditures
Public Safety
Police
410-42100.00-55550.00 Vehicles 99,725 99,725 11,362 88,363 11%133,212 121,850
410-42100.00-55570.00 Machinery & Equipment 108,099 154,449 9,574 144,875 6%- (9,574)
COMPARATIVE
City of Prior Lake
Revolving Equipment Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
COMPARATIVE
Fire
410-42200.00-55070.00 Projects - Bond Issuance Costs - - 5,856 (5,856) n/a 8,129 2,273
410-42200.00-55550.00 Vehicles 248,960 248,960 467,508 (218,548) 188%58,381 (409,127)
410-42200.00-55570.00 Machinery & Equipment - 364,820 - 364,820 0%- -
Building Inspection
410-42100.00-55550.00 Vehicles 59,410 59,410 30,539 28,871 51%- (30,539)
410-42100.00-55570.00 Machinery & Equipment - - - - n/a - -
Total Public Safety 516,194 927,364 524,839 402,525 57%199,723 (325,117)
Public Works
Street
410-43100.00-55550.00 Vehicles 323,786 323,786 86,376 237,410 27%- (86,376)
410-43100.00-55570.00 Machinery & Equipment 99,096 99,096 737 98,359 1%- (737)
Central Garage
410-43400.00-55550.00 Vehicles 20,000 20,000 18,739 1,261 94%13,478 (5,261)
Total Public Works 442,882 442,882 105,852 337,030 24%13,478 (92,374)
Culture and Recreation/Parks
410-45200.00-55550.00 Vehicles - - - - n/a 27,947 27,947
410-45200.00-55570.00 Machinery and Equipment 123,741 123,741 90,835 32,906 73%3,711 (87,124)
Total Culture & Recreation 123,741 123,741 90,835 32,906 73%31,658 (59,177)
Water
410-49400.00-55570.00 Machinery and Equipment 66,519 66,519 55,549 10,970 84%10,464 (45,085)
Water Quality
410-49420.00-55550.00 Vehicles - - - - n/a 192,404 192,404
Sewer
410-49450.00-55550.00 Vehicles - - - - n/a - -
Total Utility 66,519 66,519 55,549 10,970 84%202,869 147,320
Total Expenditures 1,149,336 1,560,506 777,075 783,431 50%447,727 (329,348)
Net Change (63,001) (474,171) (48,383) 680,266
City of Prior Lake
Facilities Management Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Interest (losses) on investments
440-00000.00-36210.00 Interest Earnings 4,763 4,763 7,735 2,972 162%7,381 354
440-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 7,739 7,739 n/a (6,116) 13,856
Interest (losses) on investments 4,763 4,763 15,474 10,711 325%1,265 14,209
Transfers in
440-00000.00-39203.00 Transfer from Other Funds 94,927 94,927 71,195 (23,732) 75%43,763 27,433
Transfers in 94,927 94,927 71,195 (23,732) 75%43,763 27,433
Debt Issued
440-00000.00-39310.00 G.O. Bond Proceeds - - - - n/a - -
440-42200.00-39310.00 G.O. Bond Proceeds-FIRE - - - - n/a 560,000 (560,000)
440-42200.00-39315.00 Projects-Bond Premium - - - - n/a 69,643
Debt Issued - - - - n/a 629,643 (560,000)
Energy Lease Issued
440-00000.00-39335.00 Lease Proceeds - - - - n/a - -
Energy Lease Issued - - - - n/a - -
Total Revenues 99,690 99,690 86,669 (13,021) 87%674,670 (518,358)
Expenditures
Function: General Government
00000.00 Transfers to Other Funds - - - - n/a - -
41940-55050.00 Projects Professional Svcs- FACILITIES - CITY HALL - - 10,349 (10,349) n/a 10,048 (301)
41940-55570.00 Machinery & Equipment-FACILITIES - CITY HALL - - - - n/a - -
41960.00 GESP - - - - n/a - -
Total - Function General Government - - 10,349 (10,349) n/a 10,048 (301)
Function: Public Safety
42100-55520.00 Building & Building Improvements-POLICE - - - - n/a - -
42100-55570.00 Machinery and Equipment-POLICE - - - - n/a - -
42200-55070.00 Projects-Bond Inssuance Costs-FIRE - - - - n/a 7,524 7,524
42200-55520.00 Projects-Publication-FIRE - - - - n/a 229 229
42200-55520.00 Building & Building Improvements-FIRE 67,998 67,998 - 67,998 0%74,499 74,499
42200-55570.00 Machinery & Equipment-FIRE - - - - n/a 317,757 317,757
42200-55110.00 Bond Discount/Premium-STREET - - - - n/a - -
43100-55070.00 Machinery & Equipment-STREET - - - - n/a - -
43100-55110.00 Bond Discount/Premium-STREET - - - - n/a - -
Total - Function Public Safety 67,998 67,998 - 67,998 0%400,009 400,009
Function: Public Works
43400.00 CENTRAL GARAGE - - - - n/a - -
Total - Function Public Works - - - - n/a - -
Function: Culture and Recreation
45100.00 RECREATION - - - - n/a - -
45500.00 LIBRARIES 21,965 81,965 32,637 49,328 40%- (32,637)
Total - Function Culture and Recreation 21,965 81,965 32,637 49,328 40%- (32,637)
Function: Water
49400.00 Building & Building Improvements - - 5,940 (5,940) n/a 21,995 16,055
49400-80000.00 Transfers to Other Funds - - - - n/a - -
Total - Function Culture and Recreation - - 5,940 (5,940) n/a 21,995 16,055
Total Expenditures 89,963 149,963 48,926 101,037 33%432,052 383,126
Net Change 9,727 (50,273) 37,743 242,619
COMPARATIVE
City of Prior Lake
Permanent Improvement Revolving Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Taxes/Special Assessments
450-00000.00-31010.00 Current Property Taxes 95,000 95,000 49,130 (45,870) 52%- 49,130
450-00000.00-36101.00 City Assess. Collections 230,089 230,089 17,184 (212,905) 7%5,760 11,424
450-00000.00-36102.00 County Assess. Collection - - 54,227 54,227 n/a 24,169 30,058
325,089 325,089 120,541 (204,548) 37%29,929 90,612
Interest (losses) on investments
450-00000.00-36210.00 Interest Earnings 4,231 4,231 9,331 5,100 221%5,383 3,947
450-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 9,744 9,744 n/a (3,462) 13,206
Interest (losses) on investments 4,231 4,231 19,075 14,844 451%1,922 17,153
Transfers in
450-00000.00-39203.00 Transfer from Other Funds - - - - n/a 148,000 (148,000)
Transfers in - - - - n/a 148,000 (148,000)
Debt Issued
450-00000.00-39310.00-PIR17-000001 G.O. Bond Proceeds - - - - n/a - -
450-00000.00-39310.00-PIR18-000001 G.O. Bond Proceeds - - - - n/a 490,000 (490,000)
450-00000.00-39310.00-PIR19-000001 G.O. Bond Proceeds 490,000 490,000 400,000 (90,000) 82%- 400,000
450-43100.00-39315.00-PIR19-000001 Projects-Bond Premium - - 48,709 48,709 n/a 34,493 14,216
Debt Issued 490,000 490,000 448,709 (41,291) 92%524,493 (75,784)
Total Revenues 819,320 819,320 588,325 (230,995) 72%704,344 (116,019)
Expenditures
Function: General Government
00000.00 Transfers to Other Funds - - - - n/a - -
41940.00 FACILITIES - CITY HALL - - - - n/a - -
41960.00 GESP - - - - n/a - -
Total - Function General Government - - - - n/a - -
Function: Public Safety
42100.00 POLICE - - - - n/a - -
42200.00 FIRE - - - - n/a - -
Total - Function Public Safety - - - - n/a - -
Function: Public Works
450-43100.00-54010.01 STREET 700,000 700,000 - - 0%- -
450-43100.00-55070.00-PIR17-000001 Projects - Bond Issuance Costs - - - - n/a - -
450-43100.00-55070.00-PIR18-000001 Projects - Bond Issuance Costs - - - - n/a - -
450-43100.00-55070.00-PIR19-000001 Projects - Bond Issuance Costs - - 10,894 (10,894) n/a - (10,894)
450-43100.00-55070.00 Projects - Bond Issuance Costs - - - - n/a 6,584 6,584
450-43100.00-55110.00-PIR17-000001 Projects - Bond Discount/Premium - - - - n/a - -
450-43100.00-55110.00-PIR18-000001 Projects - Bond Discount/Premium - - - - n/a - -
450-43100.00-55530.00-PIR17-000001 Infrastructure - - 664,954 (664,954) n/a 623,378 (41,576)
Total - Function Public Works 700,000 700,000 675,848 24,152 97%629,962 (45,886)
Function: Culture and Recreation
45100.00 RECREATION - - - - n/a - -
45500.00 LIBRARIES - - - - n/a - -
Total - Function Culture and Recreation - - - - n/a - -
Function: Water
49400.00 Building & Building Improvements - - - - n/a - -
Total - Function Culture and Recreation - - - - n/a - -
OTHER FINANCING USES
Transfers out
450-80000.00-59203.00 Transfers to Other Funds 186,933 186,933 19,233 167,700 10%6,824 (12,409)
Total Expenditures 886,933 886,933 695,081 191,852 78%636,786 (58,295)
Net Change (67,613) (67,613) (106,756) 67,558
COMPARATIVE
City of Prior Lake
Water Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Water Charges
601-49400.00-37100.00 Utility Receipts - Water 3,799,222 3,799,222 1,732,241 (2,066,981) 46%1,765,884 (33,643)
601-49400.00-37160.00 Penalties - - 13,262 13,262 n/a 14,814 (1,552)
3,799,222 3,799,222 1,745,503 (2,053,719) 46%1,780,697 (35,194)
Capital Facility charges
601-49400.00-37110.00 Capital Facility Revenue 272,280 272,280 159,465 (112,815) 59%156,227 3,239
272,280 272,280 159,465 (112,815) 59%156,227 3,239
Meter Sales
601-49400.00-37170.00 Water Meter Sales 74,350.00 74,350.00 98,009.91 23,660 132%77,579 20,431
601-49400.00-37175.00 Pressure Reducers 27,300.00 27,300.00 22,761.20 (4,539) 83%23,718 (957)
601-49400.00-37185.00 AMRS Brass Recycling - - 16,684 16,684 n/a - 16,684
101,650 101,650 137,455 35,805 135%101,297 36,159
Intergovernmental
601-00000.00-33422.15 State Aids/Grants - Operating Public Wor - - - - n/a - -
601-00000.00-33422.25 State Aids/Grants - Capital Public Works - - - - n/a - -
601-494.00-33610.10 County-City Aids/Grants-Operations - - 573 573 n/a - 573
601-00000.00-33633.00 Watershed Dist Grants/Aid - - - - n/a - -
- - 573 573 n/a - 573
Interest (losses) on investments
601-00000.00-36210.00 Interest Earnings 37,250 37,250 79,224 41,974 213%44,759 34,464
601-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 81,985 81,985 n/a (33,993) 115,978
37,250 37,250 161,208 123,958 433%10,766 150,442
Miscellaneous Revenues
601-00000.00-36212.00 Miscellaneous Revenue - - 13,995 13,995 n/a 9,120 4,875
601-00000.00-36102.00 County Assess Collection - - 34,252 34,252 n/a 26,874 7,377
601-49400.00-37190.00 Miscellaneous Revenue Adj - - (36) (36) n/a 19 12
- - 48,211 48,211 n/a 36,013 12,264
Contribution of assets
601-00000.00-37901.00 Contribution (Other Fund)- - - - n/a 31,565 (31,565)
601-00000.00-37902.00 Contribution (Developers)- - - - n/a - -
- - - - n/a 31,565 (31,565)
Transfers in
39203.00 Transfer from Other Funds 1,900,000 1,900,000 - (1,900,000) 0%16,751 (16,751)
1,900,000 1,900,000 - (1,900,000) 0%16,751 (16,751)
COMPARATIVE
City of Prior Lake
Water Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
COMPARATIVE
Sale of Assets
601-00000.00-39102.00 Sale of Property - - - - n/a 1,185 (1,185)
- - - - n/a 1,185 (1,185)
Debt Issued
601-00000.00-39310.00 G.O. Bond Proceeds - - - - n/a 1,320,000 (1,320,000)
601-49400.00-39310.00 G.O. Bond Proceeds - - - - n/a - -
60149400.0039315.00 Bond Premium - - - - n/a 167,618 (167,618)
- - - - n/a 1,487,618 1,487,618
Total Revenues 6,110,402 6,110,402 2,252,415 (3,857,987) 37%3,622,118 1,605,599
Operating Expenditures
Personnel and current expenditures
41520.00 Finance 94,075 94,075 66,126 27,949 70%66,639 513
49400.00 Water 1,941,435 1,941,435 1,345,595 595,840 69%1,264,258 (81,337)
2,035,510 2,035,510 1,411,721 623,789 69%1,330,897 (80,825)
Principal, Interest & other
601-47000.00-56010.00-CAP18-000001 Water 105,000 105,000 - 105,000 0%- -
601-47000.00-56110.00-CAP18-000001 Water 78,200 78,200 48,875 29,325 63%- (48,875)
183,200 183,200 48,875 134,325 27%- (48,875)
Capital improvements
55530.00 Infrastructure 2,000,000 2,480,830 863,887 1,616,943 35%719,635 (144,252)
55570.00 Machinery and equipment 142,826 161,716 10,158 151,558 6%- (10,158)
2,142,826 2,642,546 874,045 1,768,501 33%719,635 (154,410)
59203.00 Transfers to other funds 895,495 895,495 342,803 552,693 38%1,091,543 748,741
Debt/Bonds
601-49400.00-55070.00 Water - - - - n/a 17,736 17,736
Total - Function Sewer - - - - n/a 17,736 17,736
Total Expenditures 5,257,031 5,756,751 2,677,444 3,079,307 47%3,159,811 482,367
Net Change 853,371 353,651 (425,029) 462,307
City of Prior Lake
Sewer Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Sewer Charges
604-49450.00-37102.00 Utility Receipts - Sewer 1,932,978 1,932,978 806,565 (1,126,413) 42%686,483 120,083
604-49450.00-37104.00 Utility Recpt-Sewer MCES 1,601,700 1,601,700 984,776 (616,924) 61%917,818 66,959
3,534,678 3,534,678 1,791,342 (1,743,336) 51%1,604,300 187,041
Capital Facility charges
604-49450.00-37110.00 Capital Facility Revenue 272,280 272,280 159,471 (112,809) 59%156,231 3,240
272,280 272,280 159,471 (112,809) 59%156,231 3,240
Water Charges
604-49450.00-37160.00 Penalties 15,000 15,000 18,274 3,274 122%17,146 1,127
15,000 15,000 18,274 3,274 122%17,146 1,127
Interest (losses) on investments
604-00000.00-36210.00 Interest Earnings 18,800 18,800 31,051 12,251 165%19,793 11,258
604-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 29,147 29,147 n/a (13,533) 42,680
604-00000.00-36212.00 Miscellaneous Revenue - - 934 934 n/a - 934
18,800 18,800 61,132 42,332 325%6,260 54,872
Miscellaneous Revenues
604-00000.00-36212.00 Miscellaneous Revenue - - - - n/a - -
604-00000.00-36231.00 PERA Pension Contributions - - - - n/a - -
- - - - n/a - -
Contribution of assets
604-00000.00-37901.00 Contribution (Other Fund)- - - - n/a - -
604-00000.00-37902.00 Contribution (Developers)- - - - n/a - -
- - - - n/a - -
Debt Issued
604-00000.00-39310.00 G.O. Bond Proceeds - - - - n/a 1,320,000 (1,320,000)
- - - - n/a 1,320,000 (1,320,000)
Other Financing Sources
604-49450.00-39315.00 Bond Premium - - - - n/a 167,618 (167,618)
- - - - n/a 167,618 (167,618)
Sale of Property
604-00000.00-39310.00 Sale of Property - - - - n/a 1,185 (1,185)
- - - - n/a 1,185 1,185
Transfers in
COMPARATIVE
City of Prior Lake
Sewer Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
COMPARATIVE
39203.00 Transfer from Other Funds - - - - n/a 17,434 (17,434)
- - - - n/a 17,434 (17,434)
Total Revenues 3,840,758 3,840,758 2,030,218 (1,810,540) 53%3,290,174 (1,089,969)
Operating Expenditures
Personnel and current expenditures
41520.00 Finance 91,341 91,341 65,997 25,344 72%66,080 83
49450.00 Sewer 2,564,890 2,564,890 1,803,608 761,282 70%1,698,654 (104,954)
2,656,231 2,656,231 1,869,604 786,627 70%1,764,734 (104,870)
Principal, Interest & other
604-49450.00-55070.00-CAP18-000001 Sewer-Bond Issuance - - - - n/a 17,736 17,736
604-47000.00-56010.00-CAP18-000001 Sewer 105,000 105,000 - 105,000 0%- -
604-47000.00-56110.00-CAP18-000001 Sewer 78,200 78,200 48,875 29,325 63%- (48,875)
183,200 183,200 48,875 134,325 27%17,736 (31,139)
City of Prior Lake
Sewer Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
COMPARATIVE
Capital improvements
55530.00 Infrastructure 400,000 880,830 321,306 559,524 36%212,017 (109,289)
55570.00 Machinery and equipment 81,832 100,722 39,086 61,636 39%(92,079) (131,166)
481,832 981,552 360,392 621,160 37%119,937 (240,455)
59203.00 Transfers to other funds 277,147 277,147 207,860 69,287 75%1,049,256 841,396
Total Expenditures 3,598,410 4,098,130 2,486,732 1,611,398 61%2,951,663 464,931
Net Change 242,348 (257,372) (456,514) 338,511
City of Prior Lake
Water Quality Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Storm Water Charges
602-49420.00-37120.00 Storm Water Revenue 978,674 978,674 575,813 (402,861) 59%543,369 32,444
978,674 978,674 575,813 (402,861) 59%543,369 32,444
Water Charges
602-49420.00-37160.00 Penalties - - 2,868 2,868 n/a 2,980 (112)
- - 2,868 2,868 n/a 2,980 (112)
Intergovernmental
602-00000.00-33160.10 Fed Aids/Grants - - - - n/a - -
602-00000.00-33422.10 State Aids/Grants - - - - n/a - -
602-49420.00-33610.20 County-City Aids/Grants - - - - n/a - -
602-49420.00-33633.00 Watershed Dist Grants/Aid - - - - n/a 130,000 (130,000)
602-49420.00-32250.00 Wetland Application Fee - - 450 450 n/a 750 (300)
- - 450 450 n/a 130,750 (130,300)
Interest (losses) on investments
602-00000.00-36210.00 Interest Earnings 11,690 11,690 15,994 4,304 137%12,853 3,140
602-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 15,796 15,796 n/a (11,353) 27,149
11,690 11,690 31,790 20,100 272%1,500 30,289
Contribution of assets
602-00000.00-37901.00 Contribution (Other Fund)- - - - n/a 191,303 (191,303)
602-00000.00-37902.00 Contribution (Developers)- - - - n/a - -
- - - - n/a 191,303 (191,303)
Total Revenues 990,364 990,364 610,921 (379,443) 62%869,903 (258,982)
COMPARATIVE
Operating Expenditures
Personnel and current expenditures
49420.00 Sewer 532,642 532,642 318,517 214,125 60%332,093 13,576
532,642 532,642 318,517 214,125 60%332,093 13,576
Capital improvements
55040.00 ROW & property acquisition - - - - n/a - -
55530.00 Infrastructure 385,000 385,000 90,278 294,722 23%401,560 311,282
385,000 385,000 90,278 294,722 23%401,560 311,282
59203.00 Transfers to other funds 83,860 83,860 62,895 20,965 75%405,581 342,686
Total Expenditures 1,001,502 1,001,502 471,690 529,812 47%1,139,233 667,543
Net Change (11,138) (11,138) 139,231 (269,330)
City of Prior Lake
Economic Development Authority Special Revenue Fund
As of 09/30/2019
(Preliminary & Unaudited)
Variance from Variance
2019 2019 2019 Amended Budget - % BDGT Actual from 2018
Budget Amended Actual Positive (Negative)USED 09/30/2018 Positive (Negative)
Revenues
Taxes
240-00000.00-31010.00 Current Property Taxes 150,000 150,000 77,715 (72,285) 52%77,024 691
240-00000.00-33423.00 Market Value Credit Aid - - - - n/a - -
Taxes 150,000 150,000 77,715 (72,285) 52%77,024 691
Intergovernmental
240-46500.00-33610.14 County-City Aids/Grants - Operating EDA - - - - n/a - -
Intergovernmental - - - - n/a - -
Charges for Services
240-00000.00-34111.00 Administrative Charges - - - - n/a - -
240-46503.00-34760.02 Facility Rental - EDA 7,820 7,820 7,369 (451) 94%6,196 1,173
Charges for Services 7,820 7,820 7,369 (451) 94%6,196 1,173
Interest (losses) on investments/Misc Revenue
240-00000.00-36210.00 Interest Earnings 3,300 3,300 8,622 5,322 261%5,840 2,781
240-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 8,702 8,702 n/a (3,538) 12,240
240-00000.00-36230.00 Contributions & Donations - - 2,500 2,500 n/a - 2,500
Interest (losses) on investments/Misc Revenue 3,300 3,300 19,824 16,524 601%2,303 (17,521)
Transfers In
240-00000.00-39203.00 Transfer from Other Funds - - - - n/a 300,000 (300,000)
Transfers In - - - - n/a 300,000 300,000
Transfers in
240-00000.00-39203.00 Transfer from Other Funds - - - - n/a - -
Transfers in - - - - n/a - -
Total Revenues 161,120 161,120 104,908 (56,212) 65%385,523 (280,615)
Expenditures
Function: Economic Development
46500.00 ECONOMIC DEVELOPMENT 145,467 145,467 124,070 21,397 85%105,363 (18,707)
46503.00 TECH VILLAGE INCUBATOR 4,350 4,350 1,429 2,921 33%819 (610)
46500.00 Capital Outlay - - - - n/a (1,000) (1,000)
Total Expenditures 149,817 149,817 125,499 24,318 84%105,182 (20,317)
Net Change 11,303 11,303 (20,591) 280,341
COMPARATIVE