HomeMy WebLinkAbout5J 2017 Preliminary Year-End Financial Report
4646 Dakota Street SE
Prior Lake, MN 55372
CITY COUNCIL AGENDA REPORT
MEETING DATE: APRIL 16, 2018
AGENDA #: 5J
PREPARED BY: DANIELLE AMIRA ACCOUNTANT
PRESENTER: CATHY ERICKSON, FINANCE DIRECTOR
AGENDA ITEM: PRESENTATION OF THE PRELIMINARY YEAR-END 2017
FINANCIAL REPORTS
DISCUSSION: Introduction
Staff has prepared preliminary summary financial reports (attached) as of
December 31, 2017, for the following funds:
• General Fund
• Debt Service Funds
• Capital Park Fund
• Revolving Equipment Fund
• Revolving Park Equipment Fund
• Facilities Management Fund
• Water Fund
• Sewer Fund
• Water Quality Fund
• Economic Development Authority Special Revenue Fund
The reports reflect revenue and expenditure activity during 2017. 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 accept the
December 31, 2017 Financial Report as submitted.
2. Motion and second to remove this item from the consent agenda for
additional discussion.
RECOMMENDED
MOTION:
Alternative 1.
Page 2
MEMORANDUM
DATE: April 16, 2018
TO: Prior Lake City Council
FROM: Cathy Erickson, Finance Director
RE: Financial Report dated 12/31/2017
This report provides a summary of 12/31/17 financial results for the City of Prior Lake.
Information is provided for the General Fund, Debt Service Funds, Capital Park Fund, Revolving
Equipment Fund, Revolving Parks Equipment Fund, Facilities Management Fund, Water,
Sewer, and Storm Water Funds, and the EDA. Some highlights for the year are summarized
below.
General Fund Summary
Key points for 2017:
• Preliminary financial information reflects revenues exceeding expenditures by $191,875.
• General Fund reserve balance, before 2018 budget amendments, is projected at $6.9M
as of 12/31/2017 which is equal to a 54% reserve balance.
The 2017 original budget was approved with an anticipated use of reserve of $50,000. The
budget was subsequently amended to reflect a use of fund balance reserves of $777k for the
following items:
• $156k – Carryforward of 2016 budget items as the work plan shifted from 2016 to 2017
(Ponds Park lighting, Lords St. bridge maintenance, etc.)
• $39k – Use of reserves for the 2040 vision update and community survey.
• $100k – Increase severance compensation fund funding due to increase in employee
retirements/resignations.
• $120k – Transfer to the PIR Fund for street overlay. Funding was previously budgeted
in the General Fund, but now the street overlay activity is accounted for in the PIR fund.
• $312k – Final contract costs for the TH13/150th St. street project.
General Fund Revenues
Total revenues are $13,400,804 thru 12/31/17 or 105% of the annual amount budgeted. This
compares to $12,997,948 or 101.6% collected in 2016. Preliminary reports show that General
Fund actual revenues exceeded the 2017 budget by $679,926.
The following table highlights the revenue categories that comprise the $680k favorable
variance to budget:
Revenue Category Revenues to Budget
Favorable/(Unfavorable)
Property Taxes $ (52,000)
Licenses and Permits 237,000
Intergovernmental 115,000
Charges for Services (including franchise taxes) 191,000
Interest (loss) on Investments (38,000)
Fines and Forfeitures 2,000
Miscellaneous Revenue 225,000
Estimated Total Revenues Exceeding Budget $ 680,000
Taxes
Page 3
Property tax revenue totaled $8,158,560 or 60.8% of the total revenue received in 2017. In
2016 property tax revenue comprised 63.7% of total revenues. Current tax collections were at
99.7% compared to 99.5% in 2016. Delinquent collections totaled $43,300 which is about
36.8% lower than 2016. Fiscal Disparities revenue was about $77,000 less than budgeted due
to tax petition valuation adjustment for years 2013-2016 for Jeffers Pond Foundation.
Licenses and Permits
License and Permit revenue consists of building permit and fees and other permits. Building
permits and fees are the largest sources of revenue in this category with a budget of $486,275.
As of 12/31/17, $712,087 or 146% of the amount budgeted for building permits has been
collected. Building permit and fees are $70,560 higher than last year. The value of building
permits issued increased from $77.5 million in 2016 to $80.7 million in 2017. The increase in
both permit revenue and value is due to the construction of the Lakeridge and Pike Lake Marsh
apartments. The following chart shows building permit activity and average values for years
2010 through 2017.
2010 2011 2012 2013 2014 2015 2016 2017
Permits
Issued:
Single Family 94 80 122 149 118 112 108 80
Townhomes 0 26 52 39 8 10 4 20
MF Units 3 (222 units) 5 (218 units)
Commercial/
Industrial
2 0 2 5 5 10 4 11
Miscellaneous 1,528 1,778 2,115 2,099 1,935 2,063 1,904 1,012
Total Permits 1,624 1,884 2,291 2,292 2,066 2,195 2,022 1,123
Average
Value:
Single Family $267,298 $282,400 $347,000 $344,000 $317,000 $331,000 $344,000 $326,000
Townhomes $ 0 $142,615 $174,000 $187,000 $138,000 $183,000 $169,000 $182,000
MF Units $129,000 $159,000
Commercial/
Industrial
$280,000 $ 0 $547,000 $186,000 $17,000 $374,000 $1,405,000 $1,221,227
Intergovernmental Revenue
Intergovernmental revenue for 2017 totaled $1,657,988 which is $76,235 more than 2016. The
SMSC increased their contribution from $430,000 in 2016 to $510,000 in 2017, the $70,000
increase is funding for an additional Drug Task Force Officer for years 2017-2019.
Fire Relief Association Aid is comparable to 2016. The Police Pension Aid increased by $14,820
for an additional Officer.
Charges for Services
Charges for Services revenue for 2017 are $219,613 or 13% higher than 2016 due to 1) Plan
check fees for Lakeridge and Pike Lake Marsh apartments - $99k, 2) an increase in city
contracted services, primarily for police overtime at the SMSC -$58k, 3) additional tower lease
revenue of $14k, and 4) Zoning and Subdivision fees are $34k higher than budget due to the
additional plats and application fees than planned due to the Summit Preserve and Trillium
Cove developments.
Recreation revenues (including Park admission fees and facility rental) are $10k higher than
budget, primarily for program fees.
Other Revenue
Interest earnings are $6k over budget. In previous years the market was at historically low
rates, however the return on the City’s portfolio is finally increasing. The report also reflects a
Page 4
$45k decrease in the fair value of the securities. As rates increase, the market value of the
lower yielding securities has decreased. This is a paper loss; no actual gain/loss is realized
because the City holds the securities until maturity.
Miscellaneous revenues were above budget by $225k. This is primarily due to increase in
developer agreement revenue for Summit Preserve, Trillium Cove, and Haven’s Ridge ($215k)
and contributions/donations ($9k).
General Fund Expenditures
General Fund expenditures of $13,208,929 equal 98% of the amended budget amounts.
General categories vary in how they are impacted from employee turnover, insurance, utilities,
fuel, equipment repairs, ability to complete capital projects etc.
Many factors impact expenditures. Employee turnover and delays in filling open positions in
some of the departments including Finance, Community Development, Police and Volunteer
Firefighters has allowed for savings in those areas. The savings is not only due to positions
being open for an extended period but also, when finally filled, the compensation package is
typically lower for the new employee. However, overtime in some of these same departments
was over budget to account for these open positions.
Major areas within the 2017 budget that were under budget include the following:
• Fuel – Budgeted for a higher rate and higher fuel use. Less snow events in 2016/2017
season resulted in lower fuel use.
• Repairs & Maintenance – Less general repairs then expected/in relation to prior year
costs and EAB treatment costs lower than anticipated.
• Street Maintenance – With the shifting of the street overlay project to the PIR Fund a
budget transfer was done to help fund the 2017 project. Staff recommends that the
remaining street maintenance balance also be transferred for the 2018 overlay project.
• Small Equipment – Less spending in some departments to offset staff overtime costs.
• Building Maintenance – More repairs than anticipated
• Professional Services – Contract for Public Works Director in professional services vs
payroll and 2040 comprehensive plan costs.
The following table highlights the variances expected in personnel, current expenditures and
capital outlay:
Expenditure Category Estimated Expenditures
Compared to Budget*
Favorable/(Unfavorable)
Subtotals by
Category
Personnel:
Savings from Employee Turnover, Hiring Delays,
etc.
$168,000
Part-time/Seasonal Wages 50,000
Other Wages (Election Judges, Paid On-Call Fire) 27,000
Health Insurance Savings 14,000
Workers Comp Insurance 27,000
Overtime (128,000)
Total Personnel $ 158,000
Current Expenditures:
Fuel 77,000
Uniforms 13,000
Repair & Maintenance Supplies 33,000
Small Equipment 22,000
Page 5
Maintenance Agreements - Street 56,000
Maintenance Agreements – Buildings (12,000)
Legal / Prosecution Fees (17,000)
Professional Services (38,000)
Other 2,000
Total Current Expenditures 136,000
Capital Outlay Expenditures:
Machinery & Equipment 7,000
Furniture & Office Equipment (1,000)
Infrastructure (10,000)
Total Capital Outlay Expenditures (4,000)
Other (Transfers Out) (1,000)
Total Expenditures $ 289,000
*positive = budget savings; negative = expenditure exceeds budget
General Fund Reserves
In 2018, several budget amendments and additional expenditures have been approved by the
Council, which will reduce that reserve down to approximately 52%. Those items include
Laserfiche and Cartegraph software purchases and firefighter turnout gear. A transfer of funds
to the PIR Fund for street overlay is also reflected in the use of reserves. This transfer will be
brought to the Council for approval at the April 16 meeting.
Debt Service Funds
Property taxes and special assessments are received in June, December and January (final tax
settlement). Several prepayments have been received for special assessments. Interest
earnings are at 436% of budget due to funds held in escrow to refund the 2007A water
treatment plant bonds which were redeemed in 2017.
Scheduled bond payments were made in June and December.
Cable Fund
2017 activity included revenue from cable franchise companies of $37k. Every 3 years the City
does a franchise fee audit for Mediacom and Integra to ensure they are paying what they should
based on customer accounts. Machinery and Equipment expenditures included the 1st phase of
the Council Chambers equipment replacement.
Capital Park Fund
Park Dedication Fees of $577,500 were received for the Pike Lake Marsh, Summit Preserve &
Haven Ridge projects. Interest earned during the year total $16,629, or 185% of budget.
2017 Infrastructure expenditures include Eaglebrook Park playground improvements and a
basketball court at Enclave Park.
Revolving Equipment Fund
Property taxes, the primary funding source, were received in June, December and January (final
tax settlement) totaling $375,905. Interest earned during the year total $7,457 or 70% of budget.
Equipment purchases totaled $890,371 which is less than the budget by $44,973.
Facilities Management Fund
Revenue for this fund comes primarily from Transfers In (Water and Storm Water), Interest, and
bond proceeds. Interest earned during the year totaled $10,303 or 206% of budget. In 2017
debt was issued for the Maintenance Center roof totaling $370,000.
Page 6
Water Fund
The financial report for the Water Fund reflects six billing cycles. Operating revenue totaled
$3,793,719 which is an increase of $119,620 or 3.2% from 2016. Water usage increased from
703.6 million gallons to 709.1 million gallons. Revenue increased due to an increase in the
rates and increased consumption. During 2017, rates were increased from $4.40 to $4.53 for
the base rate and from $6.06 to $6.25 for the rate above 25,000 gallons per billing cycle.
Total operating expenses were $2,621,449 which is 127.3% of the $2,058,359 budgeted and
$127,909 more than 2016. Water Meters and Repair and Maintenance Supplies were below
budget in total by $149,000. Water purchases from the SMSC decreased from $297,700 in
2016 to $268,440 in 2017.
Capital expenses this year total $77,361 compared to $115,926 in 2016. Projects for 2017
included the Summit Preserve Booster Station.
Authorized expenditures for the 2017 Reconstruction, Summit Preserve, and AMRS
Replacement are reflected in the capital improvements. The status of the capital improvement
costs is shown below:
Water Improvement
Projects
CIP Ref Budget Actual Comments
Water Treatment Facility
Equipment Replacement
CIP #14 $103,000 $0 Project Deferred
Cartegraph Upgrade CIP #25 18,891 0 Project Deferred
Total $121,891 $0
Infrastructure Projects CIP Ref Budget Actual Comments
CSAH 83 CIP #10 $10,000 $0 Substantially Complete
Franklin Trail CIP #10 510,000 334,138
Cates/Albany CIP #10 574,500 388,071
Balsam/Sunrise CIP #10 400,000 330,047
Sycamore CIP #10 310,000 162,958
Summit Preserve Booster Station CIP #14 250,000 77,361
AMRS Replacement CIP #11 850,000 0 Project Deferred
Total $2,904,500 $1,292,575
Sewer Fund
The financial report for the Sewer Fund reflects six billing cycles. Operating revenue totaled
$3,090,773 which is an increase of $349,195 or 12.7% over 2016. Consumption decreased
from 532.6 million gallons to 521.6 million gallons. Sales increased due to the rate increase and
due to the increase in sewer use. During 2017, rates were increased from $2.52 to $2.69 for the
City and from $2.22 to $2.57 for the MCES.
Total operating expenses were $2,771,146, which is 67.1% of the $4,124,133 budgeted and
$559,867 more than 2016. Disposal charges are the largest expense totaling $1,390,443. The
monthly payment to the Metropolitan Council Environmental Services is $115,870 which is a
5.0% increase over from last year.
Authorized expenditures for 2017 Street Reconstruction projects are reflected in the capital
improvements. The status of the capital improvement costs is shown below:
Sewer Improvement Projects CIP
Ref
Budget Actual Comments
Sewer System Equipment
Replacement
CIP#19 $60,589 $0 Project Deferred
Cartegraph Upgrade CIP#25 18,891 0 Project Deferred
Total $79,480 $0
Page 7
Street Reconstruction Projects CIP
Ref
Budget Actual Comments
Franklin Trail CIP#10 $330,000 $385,910
Cates/Albany CIP#10 185,000 71,636
Balsam/Sunrise CIP#10 210,000 259,762
Sycamore CIP#10 50,000 16,387
AMRS Replacement CIP#11 850,000 0 Project Deferred
Total $1,625,000 $733,695
Storm Water Fund
The financial report for the Water Quality Fund reflects six billing cycles. Storm water revenue
totaled $925,988 which is an increase of $5,860 or .6% over 2016. This is due primarily to a
rate increase from $13.20 to $13.93. The City had one grant-related projects in 2017. The Mn
Pollution Control Agency gave the City $5,400 for the Stormwater BMP Performance
Assessment. Storm Water revenues are based on flat rates per billing cycle.
Total operating expenses were $633,560 which is 48.4% of the $1,307,206 budgeted and
$34,588 more than 2016.
The status of the capital improvement costs is shown below:
Storm Sewer
Improvement Projects
CIP Ref Budget Actual Comments
Stormwater Infrastructure
Maintenance
CIP #20 $60,000 $3,200
Pond Maintenance & Retrofit CIP #21 300,000 49,793 2017 and 2018 project
Total $360,000 $52,993
Street Reconstruction Projects CIP Ref Budget Actual Comments
Contract BMP Maintenance CIP #22 $25,000 $20,052
Franklin Trail CIP #10 115,842 73,283
Cates/Albany CIP #10 121,259 183,225
Balsam/Sunrise CIP #10 100,007 62,922
Sycamore CIP #10 34,309 54,374
Total $756,417 $393,856
Economic Development Authority Special Revenue Fund
Funding for the EDA comes primarily from property taxes (93%) and facility rental payments
from the Technology Village Business Incubator.
Revenues of $149,174 exceeded expenditures of $98,497 by $50,677. Personnel,
commissioner per diems, professional services and Technology Village Business Incubator
expenditures comprise the majority of the expenditures.
C
i
t
y
o
f
P
r
i
o
r
L
a
k
e
G
e
n
e
r
a
l
F
u
n
d
S
u
m
m
a
r
y
A
s
o
f
1
2
/
3
1
/
2
0
1
7
(
P
r
e
l
i
m
i
n
a
r
y
&
U
n
a
u
d
i
t
e
d
)
Va
r
i
a
n
c
e
f
r
o
m
Variance
20
1
7
20
1
7
20
1
7
Am
e
n
d
e
d
B
u
d
g
e
t
-
%
B
D
G
T
Ac
t
u
a
l
from 2016
Bu
d
g
e
t
Am
e
n
d
e
d
Ac
t
u
a
l
Po
s
i
t
i
v
e
(
N
e
g
a
t
i
v
e
)
US
E
D
12
/
3
1
/
2
0
1
6
Positive (Negative)
Re
v
e
n
u
e
s
Ta
x
e
s
8,
2
1
0
,
8
1
2
8,
2
1
0
,
8
1
2
8,
1
5
8
,
5
6
0
(5
2
,
2
5
2
)
99
%
8,271,183
(112,623)
Li
c
e
n
s
e
s
a
n
d
P
e
r
m
i
t
s
58
3
,
2
2
0
58
3
,
2
2
0
82
0
,
4
3
3
23
7
,
2
1
3
14
1
%
751,824
68,609
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
1,
5
4
2
,
7
3
5
1,
5
4
2
,
7
3
5
1,
6
5
7
,
9
8
8
11
5
,
2
5
3
10
7
%
1,581,752
76,236
Ch
a
r
g
e
s
f
o
r
S
e
r
v
i
c
e
s
1,
7
7
6
,
3
1
1
1,
7
7
6
,
3
1
1
1,
9
6
7
,
1
4
5
19
0
,
8
3
4
11
1
%
1,747,532
219,613
Fi
n
e
s
a
n
d
F
o
r
f
e
i
t
u
r
e
s
-
-
2,
2
5
0
2,
2
5
0
n/
a
4,743
(2,493)
In
t
e
r
e
s
t
(
l
o
s
s
e
s
)
o
n
i
n
v
e
s
t
m
e
n
t
s
85
,
7
5
0
85
,
7
5
0
47
,
0
1
4
(3
8
,
7
3
6
)
55
%
97,036
(50,022)
Ot
h
e
r
92
,
0
5
0
92
,
0
5
0
31
7
,
4
1
4
22
5
,
3
6
4
34
5
%
161,238
156,176
Tr
a
n
s
f
e
r
s
i
n
73
0
,
0
0
0
43
0
,
0
0
0
43
0
,
0
0
0
-
10
0
%
362,640
67,360
To
t
a
l
R
e
v
e
n
u
e
s
13
,
0
2
0
,
8
7
8
1
2
,
7
2
0
,
8
7
8
1
3
,
4
0
0
,
8
0
4
6
7
9
,
9
2
6
1
0
5
%
1
2
,
9
7
7
,
9
4
8
4
2
2
,
8
5
6
Ex
p
e
n
d
i
t
u
r
e
s
Ge
n
e
r
a
l
G
o
v
e
r
n
m
e
n
t
2,
8
2
3
,
0
0
1
2,
8
9
2
,
5
2
1
2,
8
4
6
,
8
8
1
45
,
6
4
0
98
%
2,611,138
(235,743)
Pu
b
l
i
c
S
a
f
e
t
y
5,
3
1
2
,
4
5
4
5,
3
2
6
,
4
5
4
5,
2
3
3
,
8
4
0
92
,
6
1
4
98
%
5,035,155
(198,685)
Pu
b
l
i
c
W
o
r
k
s
2,
1
8
3
,
5
8
0
1,
9
0
9
,
3
5
0
1,
7
9
8
,
9
2
1
11
0
,
4
2
9
94
%
1,875,531
76,610
Cu
l
t
u
r
e
a
n
d
R
e
c
r
e
a
t
i
o
n
1,
7
3
3
,
8
2
4
1,
7
3
3
,
8
2
4
1,
6
8
7
,
5
5
0
46
,
2
7
4
97
%
1,736,734
49,184
Tr
a
n
s
f
e
r
t
o
o
t
h
e
r
f
u
n
d
s
1,
0
1
8
,
0
1
9
1,
6
3
5
,
5
2
5
1,
6
3
6
,
1
2
1
(5
9
6
)
10
0
%
1,159,226
(476,895)
Co
n
t
i
n
g
e
n
t
R
e
s
e
r
v
e
-
-
5,
6
1
6
(5
,
6
1
6
)
n/
a
-
(5,616)
To
t
a
l
E
x
p
e
n
d
i
t
u
r
e
s
13
,
0
7
0
,
8
7
8
13
,
4
9
7
,
6
7
4
13
,
2
0
8
,
9
2
9
28
8
,
7
4
5
98
%
12
,
4
1
7
,
7
8
4
(791,145)
Ne
t
C
h
a
n
g
e
(5
0
,
0
0
0
)
(7
7
6
,
7
9
6
)
19
1
,
8
7
5
560,164
COMPARATIVE
City of Prior Lake
General Fund Revenues
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive ( Negative)USED 12/31/2016 Positive (Negative)
Taxes
101 31010.00 Current Property Taxes - General Purpos 7,397,541 7,397,541 7,377,894 (19,647) 100%7,443,665 (65,771)
101 31040.00 Delinquent Property Taxes - General Purp - - 43,300 43,300 n/a 68,478 (25,178)
101 31040.00 Fiscal Disparities 813,271 813,271 736,541 (76,730) 91%758,247 (21,706)
101 33423.00 Market Value Credit Aid - - 825 825 n/a 793 32
Taxes 8,210,812 8,210,812 8,158,560 (52,252) 99%8,271,183 (112,623)
Licenses and Permits
101 32100.00 Business Licenses 800 800 1,200 400 150%900 300
101 32110.00 Liquor Licenses 73,290 73,290 75,840 2,550 103%77,115 (1,275)
101 32160.00 Refuse Haulers 3,450 3,450 4,400 950 128%3,450 950
101 32170.00 Outdoor Concert Permits 1,150 1,150 - (1,150) 0%3,150 (3,150)
101 32180.00 Cigarette Licenses 2,500 2,500 2,500 - 100%2,750 (250)
101 32210.00 Building Permits 398,420 398,420 602,394 203,974 151%536,650 65,744
101 32211.00 Retainage Forfeiture - - - - n/a 6,332 (6,332)
101 32215.00 Mechanical Permits 45,165 45,165 55,931 10,766 124%52,889 3,042
101 32230.00 Plumbing Permits 42,690 42,690 53,762 11,072 126%51,988 1,774
101 32231.00 Sewer/Water Inspection 6,180 6,180 12,611 6,431 204%7,415 5,196
101 32232.00 Plumbing Registrations 1,200 1,200 800 (400) 67%675 125
101 32240.00 Animal Licenses 3,750 3,750 4,045 295 108%3,635 410
101 32260.00 Burning Permits 2,625 2,625 3,000 375 114%2,675 325
101 32270.00 Short-term Rental Fee 2,000 2,000 3,000 1,000 150%2,200 800
101 32175.00 Public Private Gathering Permit - - 600 600 n/a - 600
101 32190.00 Community Event Application - - 350 350 n/a - 350
Licenses and Permits 583,220 583,220 820,433 237,213 141%751,824 68,609
Intergovernmental
101 33160.10 Fed Aids/Grants - Operating Grants - - - - n/a (2,197) 2,197
101 33160.11 Fed Aids/Grants - Operating Police 18,000 18,000 8,458 (9,542) 47%19,342 (10,884)
101 33401.00 Local Government Aid 15,180 15,180 11,905 (3,275) 78%11,905 -
101 33416.01 State Aid - Police Train 7,800 7,800 7,948 148 102%6,253 1,695
101 33416.02 State Police Aid-Ins Prem 175,000 175,000 202,935 27,935 116%188,115 14,820
101 33417.00 State Aid - Fire Training 7,000 7,000 12,435 5,435 178%8,910 3,525
101 33418.00 State Road & Bridge Aid 316,827 316,827 335,077 18,250 106%325,213 9,864
101 33420.00 State Fire Aid-Ins. Prem.206,000 206,000 216,182 10,182 105%214,891 1,291
101 33422.11 State Aids/Grants - Operating Police - - 900 900 n/a 5,122 (4,222)
101 33610.11 County-City Aids/Grants - Operating Police - - 6,000 6,000 n/a - 6,000
101 33620.00 Township Fire & Resc Aid 311,068 311,068 298,076 (12,992) 96%311,068 (12,992)
101 33621.00 Liaison Aid 45,860 45,860 48,072 2,212 105%47,130 942
101 33630.00 Metro Council Grants - - - - n/a 16,000 (16,000)
101 33631.00 Payment in Lieu of Taxes 440,000 440,000 510,000 70,000 116%430,000 80,000
Intergovernmental 1,542,735 1,542,735 1,657,988 115,253 107%1,581,752 76,236
Charges for Services
101 31810.00 Franchise Taxes 603,000 603,000 620,469 17,469 103%615,028 5,441
101 34103.00 Zoning & Subdivision Fees 20,650 20,650 55,064 34,414 267%28,529 26,535
101 34104.00 Plan Check Fees 243,474 243,474 342,541 99,067 141%310,435 32,106
101 34105.00 Sale of Maps/Publications - Reports 1,000 1,000 320 (680) 32%984 (664)
101 34107.00 Assessment Searches - Reports 400 400 300 (100) 75%560 (260)
101 34109.00 Project Admin/Eng Fees 343,000 343,000 309,324 (33,676) 90%179,912 129,412
101 34203.00 Accident/Warrant Reports - Reports - - 492 492 n/a 118 374
101 34304.00 PEG Access Fees 32,000 32,000 - (32,000) 0%32,227 (32,227)
101 34731.00 Softball Fees 11,000 11,000 14,573 3,573 132%13,152 1,421
101 34735.00 Recreation Program Fees 47,000 47,000 60,195 13,195 128%50,310 9,885
101 34740.00 Concessions - Park Fees - - 1,074 1,074 n/a 72 1,002
101 34760.01 Facility Rental - Regular 74,021 74,021 74,454 433 101%119,722 (45,268)
101 34761.00 Studio/Pavilion Rental 15,000 15,000 25,733 10,733 172%18,181 7,552
101 34762.00 Park Shelter Rental 42,500 42,500 36,677 (5,823) 86%18,483 18,194
101 34763.13 Facility Usage Fee (not taxable)15,300 15,300 300 (15,000) 2%- 300
101 34765.01 Tower Leases 267,966 267,966 282,189 14,223 105%246,883 35,306
101 34780.00 Park Admission Fees 18,000 18,000 20,746 2,746 115%23,594 (2,848)
101 34783.00 City Contract Services 42,000 42,000 99,612 57,612 237%56,415 43,197
101 36220.16 Prof Services Fee Deposit Bldg Inspectio - - 23,082 23,082 n/a 32,927 (9,845)
Charges for Services 1,776,311 1,776,311 1,967,145 190,834 111%1,747,532 219,613
Fines and Forfeitures
101 35101.00 County Court Fines - - 1,700 1,700 n/a 500 1,200
101 35104.00 Prosecution Restitution - - 550 550 n/a 4,243 (3,693)
Fines and Forfeitures - - 2,250 2,250 n/a 4,743 (2,493)
COMPARATIVE
City of Prior Lake
General Fund Revenues
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive ( Negative)USED 12/31/2016 Positive (Negative)
COMPARATIVE
Interest (losses) on investments
101 36210.00 Interest Earnings 85,750 85,750 91,836 6,086 107%87,195 4,641
101 36225.00 Unrealized Inv.Gain(Loss)- - (44,822) (44,822) n/a 9,841 (54,663)
Interest (losses) on investments 85,750 85,750 47,014 (38,736) 55%97,036 (50,022)
Other Miscellaneous Revenues
101 36101.00 City Assess. Collection - - 1,859 1,859 n/a - 1,859
101 36102.00 County Assess. Collection 2,500 2,500 (12,519) (15,019) -501%9,363 (21,882)
101 36211.00 Developer Agreements 60,000 60,000 275,310 215,310 459%76,261 199,049
101 36212.00 Miscellaneous Revenue 29,550 29,550 39,132 9,582 132%39,436 (304)
101 36230.00 Contributions & Donations - - 9,992 9,992 n/a 26,049 (16,057)
101 39102.00 Sale of Property - - 3,640 3,640 n/a 10,129 (6,489)
Other Miscellaneous Revenues 92,050 92,050 317,414 225,364 345%161,238 156,176
Other financing sources
101 39310.00 G.O. Bond Proceeds 300,000 - - - n/a - -
101 39203.00 Transfer from Other Funds 430,000 430,000 430,000 - 100%362,640 67,360
Other financing sources 730,000 430,000 430,000 - 100%362,640 67,360
Total Revenues 13,020,878 12,720,878 13,400,804 679,926 105%12,977,948 422,856
City of Prior Lake
General Fund Expenditures
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance from
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Function: General Government
41110.00 MAYOR & COUNCIL 58,193 58,193 68,445 (10,252) 118%57,181 (11,264)
41130.00 ORDINANCE 7,500 7,500 7,533 (33) 100%7,329 (204)
41320.00 ADMINISTRATION 409,228 419,728 436,766 (17,038) 104%416,488 (20,278)
41330.00 BOARDS & COMMISSIONS 10,689 10,689 11,227 (538) 105%10,370 (857)
41410.00 ELECTIONS - - - - n/a 16,982 16,982
41520.00 FINANCE 459,966 459,966 413,277 46,689 90%428,723 15,446
41530.00 ACCOUNTING - - - - n/a 249 249
41540.00 INTERNAL AUDITING 28,150 28,150 31,240 (3,090) 111%31,733 493
41550.00 ASSESSING 187,250 187,250 187,378 (128) 100%169,608 (17,770)
41610.00 LEGAL 200,000 200,000 217,039 (17,039) 109%147,402 (69,637)
41820.00 HUMAN RESOURCES 163,605 191,625 193,252 (1,627) 101%152,009 (41,243)
41830.00 COMMUNICATIONS 119,708 119,708 114,787 4,921 96%106,368 (8,419)
41910.00 COMMUNITY DEVELOPMENT 347,273 347,273 336,899 10,374 97%323,725 (13,174)
41920.00 INFORMATION TECHNOLOGY 345,585 373,585 348,954 24,631 93%306,791 (42,163)
41940.00 FACILITIES - CITY HALL 485,854 488,854 480,084 8,770 98%436,180 (43,904)
Total - Function General Government 2,823,001 2,892,521 2,846,881 45,640 98%2,611,138 (235,743)
Function: Public Safety
42100.00 POLICE 3,730,730 3,744,730 3,742,452 2,278 100%3,520,535 (221,917)
42200.00 FIRE 905,149 905,149 845,669 59,480 93%895,150 49,481
42400.00 BUILDING INSPECTION 638,325 638,325 608,073 30,252 95%583,831 (24,242)
42500.00 EMERGENCY MANAGEMENT 11,802 11,802 11,246 556 95%9,639 (1,607)
42700.00 ANIMAL CONTROL 26,448 26,448 26,400 48 100%26,000 (400)
Total - Function Public Safety 5,312,454 5,326,454 5,233,840 92,614 98%5,035,155 (198,685)
Function: Public Works
43050.00 ENGINEERING 385,272 385,272 379,994 5,278 99%340,644 (39,350)
43100.00 STREET 1,393,754 1,119,524 1,002,601 116,923 90%1,173,602 171,001
43400.00 CENTRAL GARAGE 404,554 404,554 416,326 (11,772) 103%361,285 (55,041)
Total - Function Public Works 2,183,580 1,909,350 1,798,921 110,429 94%1,875,531 76,610
Function: Culture and Recreation
45100.00 RECREATION 388,352 388,352 390,707 (2,355) 101%384,720 (5,987)
45200.00 PARKS 1,292,709 1,292,709 1,237,422 55,287 96%1,310,574 73,152
45500.00 LIBRARIES 52,763 52,763 59,421 (6,658) 113%41,291 (18,130)
46100.00 NATURAL RESOURCES - - - - n/a 149 149
Total - Function Culture and Recreation 1,733,824 1,733,824 1,687,550 46,274 97%1,736,734 49,184
00000.00 Transfer to Other Funds 1,018,019 1,635,525 1,636,121 (596) 100%1,159,226 (476,895)
Function: Contingent Reserve
49999.00 CONTINGENT RESERVE - - 5,616 (5,616) n/a - (5,616)
Total - Function Contingent Reserve - - 5,616 (5,616) n/a - (5,616)
Total Expenditures 13,070,878 13,497,674 13,208,929 288,745 98%12,417,784 (791,145)
COMPARATIVE
City of Prior Lake
Debt Service Funds
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Revenues
Property Taxes
Current Property Taxes 2,628,937 2,628,937 2,637,724 8,787 100% 2,350,538 287,186
Special Assessments
City Assess. Collections - - 804,984 804,984 n/a 403,480 401,504
County Assess. Collection 457,517 457,517 408,982 (48,535) 89% 429,280 (20,298)
Interest (losses) on investments
Interest Earnings 40,117 40,117 175,012 134,895 436% 147,178 27,834
Unrealized Inv.Gain(Loss) - - (87,015) (87,015) n/a (41,639) (45,376)
Miscellaneous Revenues
Miscellaneous Revenues - - (7,440) (7,440) n/a 4,053 11,493
Other Financing Sources
Transfer from Other Funds 1,613,635 1,613,635 1,731,544 117,909 107% 1,946,309 (214,765)
Bond Proceeds - - - - n/a 1,656,086 (1,656,086)
Total Revenues 4,740,206 4,740,206 5,663,791 923,585 119%6,895,285 (1,208,508)
Expenditures
Debt Service
Principal 3,987,634 3,987,634 3,987,634 - 100% 3,792,365 (195,269)
Interest and Other 1,031,684 1,031,860 1,201,078 (169,218) 116% 1,281,096 80,018
Refunded Bond Escrow Pmts - - 6,790,000 (6,790,000) n/a - (6,790,000)
Bond Issuance Costs - - - - n/a 44,155 44,155
Bond Discount/Premium - - - - n/a (70,270) (70,270)
Transfers to Other Funds - - 433,528 (433,528) n/a - (433,528)
Total Expenditures 5,019,318 5,019,494 12,412,240 (7,392,746) 247%5,047,346 (6,931,366)
Net Change (279,112) (279,288) (6,748,449) 1,847,939
COMPARATIVE
City of Prior Lake
Cable Fund
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Revenues
Franchise Taxes
210-41340.00.31810.00 Franchise Taxes - - - - n/a 44,754 (44,754)
Charges for Services
210-41340.00-34304.00 PEG Access Fees 37,133 37,133 36,815 (318) 99%6,296 30,519
Interest (losses) on investments
210-41340.00-36210.00 Interest Earnings - - 856 856 n/a - 856
210-41340.00-36225.00 Unrealized Inv.Gain(Loss)- - (723) (723) n/a - (723)
Total Revenues 37,133 37,133 36,948 (185) 100%51,050 (14,102)
Expenditures
Current Expenditures
210-41340.00-52400.20 Small Equipment - Technology 11,250 11,250 41 11,209 0%5,248 (5,207)
Capital Outlay
210-41340.00-55570.00 Machinery and Equipment - 49,506 57,480 (7,974) 116%- 57,480
Total Expenditures 11,250 60,756 57,521 3,235 95%5,248 52,273
Net Change 25,883 (23,623) (20,573) 45,802
COMPARATIVE
City of Prior Lake
Capital Park Fund
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Revenues
Charges for Services
225-45200.00-34760.01 Facility Rental - Regular 24,000 24,000 24,000 - 100% 23,950 50
225-45200.00-34791.00 Dedication Fees 405,000 405,000 603,808 198,808 149% 790,150 (186,342)
Charges for Services 429,000 429,000 627,808 198,808 146% 814,100 (186,292)
Interest (losses) on investments
225-00000.00-36210.00 Interest Earnings 9,000 9,000 16,629 7,629 185% 9,965 6,664
225-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (9,539) (9,539) n/a (1,921) (7,618)
Interest (losses) on investments 9,000 9,000 7,090 (1,910) 79%8,044 (954)
Contributions and donations
225-00000.00-36230.00 Contributions & Donations - - 5,930 5,930 n/a 6,610 (680)
Contributions and donations - - 5,930 5,930 n/a 6,610 (680)
Total Revenues 438,000 438,000 640,828 202,828 146%828,754 (187,926)
Expenditures
54320.00 Miscellaneous - - - - n/a 3,712 3,712
59203.00 Transfers to Other Funds - - 21,052 (21,052) n/a - (21,052)
53100.80 Professional Services-General - - - - n/a 9,147 9,147
55530.00 Infrastructure - - 86,719 (86,719) n/a 483,399 396,680
Total Expenditures - - 107,771 (107,771) n/a 496,258 384,775
Net Change 438,000 438,000 533,057 332,496
COMPARATIVE
City of Prior Lake
Revolving Equipment Fund
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Revenues
Taxes
410-00000.00-31010.00 Current Property Taxes 375,000 375,000 375,905 905 100% 326,039 49,866
Taxes 375,000 375,000 375,905 905 100% 326,039 49,866
Interest (losses) on investments
410-00000.00-36210.00 Interest Earnings 10,594 10,594 7,457 (3,137) 70% 11,334 (3,877)
410-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (3,070) (3,070) n/a 702 (3,772)
Interest (losses) on investments 10,594 10,594 4,387 (6,207) 41% 12,036 (7,649)
Transfers in
410-00000.00-39203.00 Transfer from Other Funds 341,000 341,000 341,000 - 100% 141,000 200,000
Transfers in 341,000 341,000 341,000 - 100% 141,000 200,000
OTHER FINANCING SOURCES
Debt Issued
410-00000.00-39310.00 G.O. Bond Proceeds - - - - n/a 410,000 (410,000)
- - - - n/a 410,000 (410,000)
Total Revenues 726,594 726,594 721,292 (5,302) 99%889,075 (167,783)
Expenditures
Public Safety
Police
410-42100.00-55550.00 Vehicles 124,700 124,700 101,657 23,043 82% 92,186 (9,471)
Fire
410-42200.00-55550.00 Vehicles - - - - n/a 441 441
Total Public Safety 124,700 124,700 101,657 23,043 82% 92,627 (9,030)
Public Works
Street
410-43100.00-55070.00 Projects - Bond Issuance Costs - - - - n/a 11,039 11,039
410-43100.00-55110.00 Projects - Bond Discount/Premium - - - - n/a (16,305) (16,305)
410-43100.00-55550.00 Vehicles 213,210 213,210 199,355 13,855 94% 424,121 224,766
410-43100.00-55570.00 Machinery & Equipment 11,124 11,124 12,374 (1,250) 111% 41,024 28,650
Central Garage
410-43400.00-55550.00 Vehicles 20,000 20,000 19,999 1 100% 20,044 45
Total Public Works 244,334 244,334 231,728 12,606 95% 479,923 248,195
Culture and Recreation
410-45200.00-55550.00 Vehicles 32,960 95,600 110,650 (15,050) 116% 201,288 90,638
410-45200.00-55570.00 Machinery and Equipment 59,225 59,225 73,157 (13,932) 124% 237,355 164,198
Total Culture & Recreation 92,185 154,825 183,807 (28,982) 119% 438,643 254,836
Water
410-49400.00-55550.00 Vehicles 4,635 4,635 - 4,635 0%- -
Sewer
410-49450.00-55550.00 Vehicles 406,850 406,850 373,178 33,672 92%- (373,178)
Total Utility 411,485 411,485 373,178 38,307 91%- (373,178)
OTHER FINANCING USES
Transfers out
410-80000.00-59203.00 Transfers to Other Funds - - - - n/a 148,021 148,021
- - - - n/a 148,021 148,021
Total Expenditures 872,704 935,344 890,371 44,973 95%1,159,214 268,843
Net Change (146,110) (208,750) (169,079) (270,139)
COMPARATIVE
City of Prior Lake
Facilities Management Fund
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Revenues
Interest (losses) on investments
440-00000.00-36210.00 Interest Earnings 5,000 5,000 10,303 5,303 206%9,939 364
440-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (5,157) (5,157) n/a 85 (5,242)
Interest (losses) on investments 5,000 5,000 5,146 146 103%10,024 (4,878)
Transfers in
440-00000.00-39203.00 Transfer from Other Funds 56,650 56,650 56,650 - 100%55,000 1,650
Transfers in 56,650 56,650 56,650 - 100%55,000 1,650
Debt Issued
440-00000.00-39310.00 G.O. Bond Proceeds 620,000 620,000 370,000 (250,000) 60%- 370,000
Debt Issued 620,000 620,000 370,000 (250,000) 60%- (370,000)
Total Revenues 681,650 681,650 431,796 (249,854) 63%65,024 (373,228)
Expenditures
Function: General Government
41940.00 FACILITIES-CITY HALL - - 10,690 (10,690) n/a - (10,690)
- - 10,690 (10,690) n/a - (10,690)
Function: General Government
00000.00 Transfers to Other Funds 20,614 83,829 83,829 - 100%45,614 (38,215)
41960.00 GESP - - - - n/a 257,313 257,313
Total - Function General Government 20,614 83,829 83,829 - 100%302,927 219,098
Function: Public Safety
42200.00 FIRE 17,484 17,484 9,505 7,979 54%- (9,505)
42100.00 POLICE - - 21,475 (21,475) n/a - (21,475)
Total - Function Public Safety 17,484 17,484 30,980 (13,496) 177%- (30,980)
Function: Streets
55070.00 Projects - Bond Issuance Costs - - 7,472 (7,472) n/a - (7,472)
55110.00 Projects - Bond Discount/Premium - - (9,913) 9,913 n/a - 9,913
Total - Function Streets - - (2,441) 2,441 n/a - 2,441
Function: Culture and Recreation
45500.00 LIBRARIES 79,961 79,961 - 79,961 0%- -
Total - Function Culture and Recreation 79,961 79,961 - 79,961 0%- -
Function: Water
49400.00 Building & Building Improvements 114,081 734,081 478,870 255,211 65%1,140 (477,730)
Total - Function Culture and Recreation 114,081 734,081 478,870 255,211 65%1,140 (477,730)
Total Expenditures 232,140 915,355 601,928 313,427 66%304,067 (287,171)
Net Change 449,510 (233,705) (170,132) (239,043)
COMPARATIVE
City of Prior Lake
Water Fund
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Revenues
Water Charges
601-49400.00-37100.00 Utility Receipts - Water 3,740,806 3,740,806 3,435,639 (305,167) 92%3,312,562 123,077
601-49400.00-37160.00 Penalties 11,000 11,000 18,496 7,496 168%16,685 1,811
Water Charges 3,751,806 3,751,806 3,454,135 (297,671) 92%3,329,247 124,888
Capital Facility charges
601-49400.00-37110.00 Capital Facility Revenue 264,540 264,540 260,147 (4,393) 98%256,984 3,163
Capital Facility charges 264,540 264,540 260,147 (4,393) 98%256,984 3,163
Meter Sales
601-49400.00-37170.00 Water Meter Sales 73,150 73,150 62,134 (11,016) 85%66,758 (4,624)
601-49400.00-37175.00 Pressure Reducers 26,700 26,700 17,303 (9,397) 65%21,103 (3,800)
601-49400.00-37180.00 Frost Plates - - - - n/a 7 (7)
Meter Sales 99,850 99,850 79,437 (20,413) 80%87,868 (8,431)
Interest (losses) on investments
601-00000.00-36210.00 Interest Earnings 40,000 40,000 42,100 2,100 105%37,738 4,362
601-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (20,589) (20,589) n/a (2,522) (18,067)
Interest (losses) on investments 40,000 40,000 21,511 (18,489) 54%35,216 (13,705)
Miscellaneous Revenues
601-00000.00-36212.00 Miscellaneous Revenue - - 10,219 10,219 n/a 6,488 3,731
601-00000.00-36102.00 County Assess Collection - - 2,378 2,378 n/a 993 1,385
601-00000.00-36231.00 PERA Pension Contributions - - 193 193 n/a 2,622 (2,429)
601-49400.00-37190.00 Miscellaneous Revenue Adj - - 95 95 n/a 37 58
601-00000.00-37901.00 Contribution (Other Fund)- - 2,590,740 2,590,740 n/a 1,774,662 816,078
601-00000.00-37902.00 Contribution (Developers)- - 145,449 145,449 n/a 778,674 (633,225)
Miscellaneous Revenues - - 2,749,074 2,749,074 n/a 2,563,476 185,598
Intergovernmental
33422.15 State Aids/Grants-Operating Public Works - - 2,770 2,770 n/a 3,333 (563)
33610.10 County-City Aids/Grants-Operating Grants - - 500 500 n/a 10,000 (9,500)
- - 3,270 3,270 0%13,333 (10,063)
Transfers in
39203.00 Transfer from Other Funds 250,000 250,000 250,000 - 100%24,871 225,129
250,000 250,000 250,000 - 100%24,871 225,129
Debt Issued
601-00000.00-39310.00 G.O. Bond Proceeds 850,000 850,000 - (850,000) 0%- -
Debt Issued 850,000 850,000 - (850,000) 0%- -
Total Revenues 5,256,196 5,256,196 6,817,574 1,558,108 130%6,310,995 516,642
Expenditures
Function: General Government
00000.00 Transfers to Other Funds 941,147 941,147 2,151,421 (1,210,274) 229%1,742,896 (408,525)
41520.00 FINANCE 86,977 86,977 79,520 7,457 91%85,361 5,841
Total - Function General Government 1,028,124 1,028,124 2,230,941 (1,202,817) 217%1,828,257 (402,684)
Function: Water
49400.00 WATER 1,971,382 1,971,382 2,541,929 (570,547) 129%2,408,179 (133,750)
49400.00 Capital Outlay 3,026,391 3,044,426 - 3,044,426 0%- -
Total - Function Water 4,997,773 5,015,808 2,541,929 2,473,879 51%2,408,179 (133,750)
Total Expenditures 6,025,897 6,043,932 4,772,870 1,271,062 79%4,236,436 (536,434)
Net Change (769,701) (787,736) 2,044,704 2,074,559
COMPARATIVE
City of Prior Lake
Sewer Fund
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Revenues
Sewer Charges
604-49450.00-37102.00 Utility Receipts - Sewer 1,452,600 1,452,600 1,453,443 843 100%1,293,164 160,279
604-49450.00-37104.00 Utility Recpt-Sewer MCES 1,387,800 1,387,800 1,358,520 (29,280) 98%1,177,048 181,472
Sewer Charges 2,840,400 2,840,400 2,811,963 (28,437) 99%2,470,212 341,751
Capital Facility charges
604-49450.00-37110.00 Capital Facility Revenue 260,130 260,130 260,156 26 100%256,994 3,162
Capital Facility charges 260,130 260,130 260,156 26 100%256,994 3,162
Water Charges
604-49450.00-37160.00 Penalties 9,000 9,000 18,654 9,654 207%14,372 4,282
Water Charges 9,000 9,000 18,654 9,654 207%14,372 4,282
Intergovernmental
604-00000.00-33422.25 State Aids/Grants - Capital Public Works - - - - n/a 57,280 (57,280)
Intergovernmental - - - - n/a 57,280 (57,280)
Interest (losses) on investments
604-00000.00-36210.00 Interest Earnings 22,810 22,810 20,709 (2,101) 91%20,708 1
604-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (8,352) (8,352) n/a (235) (8,117)
Interest (losses) on investments 22,810 22,810 12,357 (10,453) 54%20,473 (8,116)
Miscellaneous Revenues
604-00000.00-36212.00 Miscellaneous Revenue - - - - n/a 3,181 (3,181)
604-00000.00-36231.00 PERA Pension Contributions - - 161 161 n/a 2,185 (2,024)
604-00000.00-37901.00 Contribution (Other Fund)- - 3,619,544 3,619,544 n/a 1,046,156 2,573,388
604-00000.00-37902.00 Contribution (Developers)- - 133,351 133,351 n/a 699,055 (565,704)
Miscellaneous Revenues - - 3,753,056 3,753,056 n/a 1,750,577 2,002,479
Debt Issued
604-00000.00-39310.00 G.O. Bond Proceeds 850,000 850,000 - (850,000) 0%- -
Debt Issued 850,000 850,000 - (850,000) 0%- -
Transfers in
39203.00 Transfer from Other Funds - - - - n/a 92,312 (92,312)
- - - - n/a 92,312 (92,312)
Total Revenues 3,982,340 3,982,340 6,856,186 2,873,846 172%4,662,220 2,193,966
Expenditures
Function: General Government
00000.00 Transfers to Other Funds 355,300 355,300 1,232,910 (877,610) 347%631,004 (601,906)
41520.00 FINANCE 86,977 86,977 78,129 8,848 90%85,372 7,243
Total - Function General Government 442,277 442,277 1,311,039 (868,762) 296%716,376 (594,663)
Function: Sewer
49450.00 SEWER 4,019,121 4,037,156 2,693,017 1,344,139 67%2,549,934 (143,083)
Total - Function Sewer 4,019,121 4,037,156 2,693,017 1,344,139 67%2,549,934 (143,083)
Total Expenditures 4,461,398 4,479,433 4,004,056 475,377 89%3,266,310 (737,746)
Net Change (479,058) (497,093) 2,852,130 1,395,910
COMPARATIVE
City of Prior Lake
Water Quality Fund
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance from
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Revenues
Storm Water Charges
602-49420.00-37120.00 Storm Water Revenue 876,921 876,921 922,304 45,383 105%916,881 5,423
Storm Water Charges 876,921 876,921 922,304 45,383 105%916,881 5,423
Water Charges
602-49420.00-37160.00 Penalties - - 3,684 3,684 n/a 3,247 437
Water Charges - - 3,684 3,684 n/a 3,247 437
Intergovernmental
602-00000.00-33422.10 State Aids/Grants 34,790 34,790 5,407 (29,383) 16%- 5,407
Intergovernmental 34,790 34,790 5,407 (29,383) 16%- 5,407
Interest (losses) on investments
602-00000.00-36210.00 Interest Earnings 8,080 8,080 14,872 6,792 184%12,471 2,401
602-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (7,060) (7,060) n/a (2,219) (4,841)
Interest (losses) on investments 8,080 8,080 7,812 (268) 97%10,252 (2,440)
Miscellaneous Revenues
602-00000.00-36212.00 Miscellaneous Revenue - - 120 120 n/a 120 -
602-00000.00-36231.00 PERA Pension Contributions - - 80 80 n/a 1,092 (1,012)
602-00000.00-37901.00 Contribution (Other Funds)- - 323,553 323,553 n/a - 323,553
602-00000.00-37902.00 Contribution (Developers)- - 19,600 19,600 n/a 62,261 (42,661)
Miscellaneous Revenues - - 343,353 343,353 n/a 63,473 279,880
Transfers In
602-00000.00-39203.00 Transfers from other funds - - 42,093 42,093 n/a - 42,093
Transfers In - - 42,093 42,093 n/a - 42,093
Total Revenues 919,791 919,791 1,324,653 404,862 144%993,853 330,800
Expenditures
Function: General Government
00000.00 Transfers to Other Funds 81,000 81,000 455,215 (374,215) 562%167,768 (287,447)
Total - Function General Government 81,000 81,000 455,215 (374,215) 562%167,768 (287,447)
Function: Water Quality
49420.00 WATER QUALITY 550,789 550,789 613,508 (62,719) 111%591,593 (21,915)
49420.00 Capital Outlay Water 756,417 756,417 20,052 736,365 3%7,377 (12,675)
Total - Function Water Quality 1,307,206 1,307,206 633,560 673,646 48%598,970 (34,590)
Total Expenditures 1,388,206 1,388,206 1,088,775 299,431 78%766,738 (322,037)
Net Change (468,415) (468,415) 235,878 227,115
COMPARATIVE
City of Prior Lake
Economic Development Authority Special Revenue Fund
As of 12/31/2017
(Preliminary & Unaudited)
Variance from Variance from
2017 2017 2017 Amended Budget - % BDGT Actual from 2016
Budget Amended Actual Positive (Negative)USED 12/31/2016 Positive (Negative)
Revenues
Taxes
240-00000.00-31010.00 Current Property Taxes 140,000 140,000 139,358 (642) 100%155,069 (15,711)
Taxes 140,000 140,000 139,358 (642) 100%155,069 (15,711)
Intergovernmental
240-46500.00-33610.14 County-City Aids/Grants - Operating EDA - - - - n/a 7,278 (7,278)
Intergovernmental - - - - n/a 7,278 (7,278)
Charges for Services
240-46503.00-34760.02 Facility Rental - EDA 8,500 8,500 8,293 (207) 98%6,340 1,953
Charges for Services 8,500 8,500 8,293 (207) 98%6,340 1,953
Interest (losses) on investments
240-00000.00-36210.00 Interest Earnings 2,500 2,500 3,093 593 124%2,209 884
240-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (1,570) (1,570) n/a (311) (1,259)
Interest (losses) on investments 2,500 2,500 1,523 (977) 61%1,898 375
Total Revenues 151,000 151,000 149,174 (1,826) 99%170,585 (21,411)
Expenditures
Function: Economic Development
46500.00 ECONOMIC DEVELOPMENT 151,325 151,325 97,161 54,164 64%142,336 45,175
46503.00 TECH VILLAGE INCUBATOR 9,500 9,500 1,336 8,164 14%8,831 7,495
Total Expenditures 160,825 160,825 98,497 62,328 61%151,167 52,670
Net Change (9,825) (9,825) 50,677 19,418
COMPARATIVE