HomeMy WebLinkAbout5F 2018 3rd Quarter Financial Report
4646 Dakota Street SE
Prior Lake, MN 55372
CITY COUNCIL AGENDA REPORT
MEETING DATE: NOVEMBER 5, 2018
AGENDA #: 5F
PREPARED BY: DANIELLE AMIRA, ACCOUNTANT
PRESENTER: CATHY ERICKSON, FINANCE DIRECTOR
AGENDA ITEM: CONSIDER APPROVAL OF THE PRELIMINARY 3rd QUARTER 2018
FINANCIAL REPORTS
DISCUSSION: Introduction
Staff has prepared preliminary summary financial reports (attached) as of
September 30th 2018, 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 through third quarter
2018. 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, 2018 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 26, 2018
TO: Prior Lake City Council
FROM: Cathy Erickson, Finance Director
RE: Financial Report dated 9/30/2018
The financial reports presented as part of this agenda item reflect activity during the third
quarter of 2018. The significant issues identified at this time are summarized below.
General Fund Summary
Key points for 2018:
• Preliminary financial information reflects expenditures exceeding revenues by
$1,011,866; This is expected since the primary funding source 2nd half property tax
revenue will be received in December.
• Development related permit and plan check fees are approximately $300k higher than
last year as the city received permits and fees for Summit Preserve 2nd addition, Havens
Ridge South, and Trillium Cover 2nd addition.
• Development related permit and plan check fees are ahead of budget by approximately
$172,000. Through September, the city had permits for 57 townhomes, which is twice
as many as planned. Single family permits are tracking to come in at about 105 for the
year, as planned.
• Expenditures are slightly higher than the same period in 2017 due to staffing limitations
requiring overtime, additional seasonal/temporary staff and expenditures related to park
maintenance.
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. First half property taxes have been collected
and are comparable to the prior year.
2018 building permits were budgeted at 105 for single family and 30 for townhomes. Revenues
associated with building permits and plan check fees are approximately $300k higher than in the
3rd quarter 2017. The following table provides a breakdown of the third quarter activity by year.
Year Single
Family
Townhomes Commercial /
Industrial
Other
Permits
Total Change
from PY
2018 85 57 25 1786 1208 3%
2017 58 0 24 1091 1173 (25%)
2016 82 4 14 1458 1560 (6%)
2015 86 10 35 1527 1658 10%
2014 83 4 29 1386 1502
The second half payments were received for Municipal State Aid and the township fire
agreements.
Second quarter Franchise fees collected in July and September are included in this report. Third
quarter fees are recorded in October. Fees collected are comparable to last year at this time.
Page 3
Project engineering fees are currently at 63% of its annual budget. Staff has historically used a
percentage of construction costs for estimating engineering time. As the outstanding projects
move forward, engineering costs charged to the projects will increase.
Recreation revenues (including Park admission fees and facility rental) are slightly lower than
the 3rd quarter of 2017, primarily due to the decrease in studio/pavilion rentals and Recreation
program fees.
Interest earnings are at 113% of its budget. The report also reflects a $80k decrease in the fair
value of the securities. As rates increased, the market value of the existing securities has
decreased. This is a paper loss; no actual loss is realized because the City holds the securities
until maturity.
Third quarter miscellaneous revenue includes the developer agreement fees for the Summit
Preserve 2nd addition, Havens Ridge South, and Trillium Cove 2nd addition.
General Fund Expenditures/Transfers
General Fund expenditures/transfers for 2018 represents 71% of the $13,285,324 amended
budget. The level of expenditures (as a percent of budget) is higher than the same period in
2017. Some key points related to expenditures/transfers are:
• Parks Expenditures are up compared to the same time in 2017, mainly due to an
increase in seasonal temporary staff.
• Expenditures in public safety are higher as compared to the third quarter of 2017 mainly
due to police overtime to provide coverage for open staff positions due to turnover.
Additionally, two police officers were hired in late 2017. As a reminder, the SMSC
increased the payment in lieu of taxes for the Drug Task Force officer and police
coverage in 2018. The total 2018 annual support from the SMSC is $510,000.
• Fuel expenditures are ahead of budget due to snow heavy winter and additional park
maintenance.
• The Council approved a transfer and budget amendment for a $300,000 transfer to the
EDA Fund to facilitate economic development initiatives identified in the EDA business
plan.
• The Council approved a transfer and budget amendment for a $148,000 transfer to the
PIR fund for the 2018 Mill & Overlay Project.
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
153% of the budget.
Scheduled bond payments were made on the 1st and 15th of June. Other bond payments will be
due on the 1st and 15th of December.
Cable Fund
Franchise are now reported in the General Fund. PEG Access Fees are at 58% of budget.
Expenditures in the third quarter include technology upgrades, including Council Chambers
Production Equipment replacement.
Capital Park Fund
Page 4
Park Dedication Fees were received for the Gens Farm Addition in the third quarter of 2018.
The Parks Comprehensive Master plan expenditures are approximately $11,300. Interest
earnings are at 137% of the budget which is higher than in 2017.
Revolving Equipment Fund
Property taxes, the primary funding source, are received in June, December and January (final
tax settlement). Interest earnings are at 130% of the budget. The change in the fair value of the
securities is adjusted against interest earnings and is allocated to each fund based on cash
balances.
Approved Plow replacement and Extrication Equipment for the new fire engine purchases have
taken place in the third quarter of 2018. Vehicle and equipment purchases were approved at
council meetings earlier in the year.
Facilities Management Fund
2018 project expenditures for Fire Station #1 have been completed in the third quarter. The
receipt of bond proceeds has also occurred
Permanent Improvement Revolving Fund
2018 overlay project expenditures and the receipt of bond proceeds occurred in the third
quarter.
Water Fund
The financial report for the Water Fund reflects four billing cycles. Consumption increased
slightly from 2017. Water revenues are about 56% of the 2018 budget.
Bond proceeds have been received for the bond capital improvement projects.
Operating expenditures and transfers are higher than 2017. 2018 includes expenditures for the
AMRS replacement and transfers to support the Woodside/Huron and Franklin street water
infrastructure replacements per resolution 18-057.
Sewer Fund
The financial report for the Sewer Fund reflects four billing cycles. Consumption increased
slightly from 2017. Sewer revenues are at 61% of the budget and slightly higher compared to
first quarter 2017. The estimated level of discharge is reevaluated annually in conjunction with
the preparation of the Capital Improvement Program.
Bond proceeds have been received for the bond capital improvement projects.
Operating expenditures and transfers are higher than 2017. 2018 includes expenditures for the
AMRS replacement and transfers to support the Woodside/Huron and Franklin street sewer
infrastructure replacements per resolution 18-057.
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 higher than 2017 at 71% of the
budget.
Operational expenditures are higher than third quarter 2017, mainly due to WCA (Wetland
Conservation Act) site reviews which is then reimbursed by the developer/property owner.
Operational budgetary transfers for third quarter are reflected in the report including the
Woodside/Huron and Franklin street stormwater infrastructure replacements per resolution 18-
057.
Page 5
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. Expenditures are at 90% budget,
mainly due to $31k for business subsidy forgivable loan to PLate on Main.
If you have any questions regarding these financial reports, please contact me at 952.447.9842.
City of Prior Lake
General Fund Summary
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Taxes 8,006,734 8,006,734 4,408,956 (3,597,778) 55%4,224,213 184,743
Licenses and Permits 607,798 607,798 765,142 157,344 126%532,862 232,280
Intergovernmental 1,675,986 1,675,986 1,140,272 (535,714) 68%1,497,914 (357,642)
Charges for Services 1,702,315 1,702,315 1,462,944 (239,372) 86%1,337,599 125,345
Fines and Forfeitures - - 1,448 1,448 n/a 513 935
Interest (losses) on investments 86,000 86,000 835 (85,165) 1%48,911 (48,076)
Other 226,945 226,945 301,155 74,210 133%254,000 47,155
Transfers in 443,000 443,000 332,250 (110,750) 75%322,500 9,750
Total Revenues 12,748,778 12,748,778 8,413,002 (4,335,776) 66%8,218,512 194,490
Expenditures
General Government 2,844,193 2,898,749 2,073,817 824,932 72%2,166,304 92,487
Public Safety 5,733,489 5,748,489 3,981,758 1,766,731 69%3,608,798 (372,961)
Public Works 2,063,803 2,060,129 1,406,388 653,741 68%1,316,766 (89,622)
Culture and Recreation 1,898,731 1,902,405 1,471,296 431,110 77%1,316,804 (154,492)
Transfer to other funds 227,552 675,552 491,609 183,943 73%369,600 (122,009)
Contingent Reserve - - - - n/a - -
Total Expenditures 12,767,768 13,285,324 9,424,868 3,860,456 71%8,778,272 (646,596)
Net Change (18,990) (536,546) (1,011,866) (559,759)
COMPARATIVE
City of Prior Lake
General Fund Revenues
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive ( Negative)USED 9/30/2017 Positive (Negative)
Taxes
101 31010.00 Current Property Taxes - General Purpos 7,116,875 7,116,875 3,916,221 (3,200,654) 55%3,771,191 145,030
101 31040.00 Delinquent Property Taxes - General Purp - - 23,782 23,782 n/a 38,506 (14,724)
101 31040.00 Fiscal Disparities 889,859 889,859 468,953 (420,906) 53%414,516 54,437
101 33423.00 Market Value Credit Aid - - - - n/a - -
Taxes 8,006,734 8,006,734 4,408,956 (3,597,778) 55%4,224,213 184,743
Licenses and Permits
101 32100.00 Business Licenses 900 900 600 (300) 67%900 (300)
101 32110.00 Liquor Licenses 74,790 74,790 77,115 2,325 103%70,865 6,250
101 32160.00 Refuse Haulers 4,150 4,150 4,790 640 115%4,400 390
101 32170.00 Outdoor Concert Permits - - - - n/a - -
101 32180.00 Cigarette Licenses 2,500 2,500 2,250 (250) 90%2,250 -
101 32210.00 Building Permits 421,498 421,498 501,213 79,715 119%359,214 142,000
101 32211.00 Retainage Forfeiture - - 1,500 1,500 n/a - 1,500
101 32215.00 Mechanical Permits 47,408 47,408 84,966 37,558 179%39,028 45,937
101 32230.00 Plumbing Permits 39,983 39,983 66,985 27,002 168%37,368 29,617
101 32231.00 Sewer/Water Inspection 6,994 6,994 10,856 3,862 155%10,133 723
101 32232.00 Plumbing Registrations 1,200 1,200 1,228 28 102%800 428
101 32240.00 Animal Licenses 3,750 3,750 3,860 110 103%3,750 110
101 32260.00 Burning Permits 2,625 2,625 3,310 685 126%2,430 880
101 32270.00 Short-term Rental Fee 2,000 2,000 1,020 (980) 51%800 220
101 32175.00 Public Private Gathering Permit - - 750 750 n/a 575 175
101 32190.00 Community Event Application - - 4,700 4,700 n/a 350 4,350
Licenses and Permits 607,798 607,798 765,142 157,344 126%532,862 232,280
Intergovernmental
101 33160.10 Fed Aids/Grants - Operating Grants - - - - n/a - -
101 33160.11 Fed Aids/Grants - Operating Police 17,850 17,850 2,352 (15,498) 13%4,745 (2,393)
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,600 10,600 23,925 13,325 226%7,948 15,977
101 33416.02 State Police Aid-Ins Prem 192,000 192,000 - (192,000) 0%202,935 (202,935)
101 33417.00 State Aid - Fire Training 7,000 7,000 12,579 5,579 180%12,435 144
101 33418.00 State Road & Bridge Aid 325,213 325,213 338,589 13,376 104%301,569 37,020
101 33420.00 State Fire Aid-Ins. Prem.215,000 215,000 2,000 (213,000) 1%216,182 (214,182)
101 33422.10 State Aids/Grants - Operating Grants - - - - n/a - -
102 33422.11 State Aids/Grants - Operating Police 3,850 3,850 2,959 (891) 77%- 2,959
101 33610.11 County Aids/Grants - Operating Police - - 27,856 27,856 n/a - 27,856
101 33620.00 Township Fire & Resc Aid 297,775 297,775 296,559 (1,216) 100%298,076 (1,517)
101 33621.00 Liaison Aid 48,793 48,793 - (48,793) 0%48,072 (48,072)
100 33630.00 Metro Council Grants - - - - n/a - -
101 33631.00 Payment in Lieu of Taxes 510,000 510,000 427,500 (82,500) 84%400,000 27,500
101 33700.11 Miscellaneous Grants - Operating Police 36,000 36,000 - (36,000) 0%- -
101 33700.23 Miscellaneous Grants - Capital Parks - - - - n/a - -
Intergovernmental 1,675,986 1,675,986 1,140,272 (535,714) 68%1,497,914 (357,642)
Charges for Services
101 31810.00 Franchise Taxes 615,000 615,000 314,679 (300,321) 51%310,623 4,057
101 34103.00 Zoning & Subdivision Fees 20,650 20,650 33,215 12,565 161%46,746 (13,531)
101 34104.00 Plan Check Fees 255,028 255,028 279,139 24,111 109%195,267 83,872
101 34105.00 Sale of Maps/Publications - Reports 1,000 1,000 480 (520) 48%315 165
101 34107.00 Assessment Searches - Reports 400 400 415 15 104%100 315
101 34109.00 Project Admin/Eng Fees 236,000 236,000 149,830 (86,170) 63%217,341 (67,511)
101 34203.00 Accident/Warrant Reports - Reports 200 200 103 (97) 52%110 (7)
101 34304.00 PEG Access Fees - - - - n/a - -
101 34731.00 Softball Fees 13,000 13,000 14,237 1,237 110%14,573 (336)
101 34735.00 Recreation Program Fees 47,000 47,000 42,109 (4,891) 90%50,367 (8,258)
101 34735.01 Recreation Program Fees Regular - - 10,615 10,615 n/a - 10,615
101 34740.00 Concessions - Park Fees - - 822 822 n/a 1,074 (252)
101 34760.01 Facility Rental - Regular 74,941 74,941 44,828 (30,113) 60%55,773 (10,945)
101 34761.00 Studio/Pavilion Rental 18,000 18,000 19,498 1,498 108%23,459 (3,961)
101 34762.00 Park Shelter Rental 42,500 42,500 49,778 7,278 117%36,688 13,090
101 34763.13 Facility Usage Fee (not taxable)3,000 3,000 - (3,000) 0%- -
101 34765.01 Tower Leases 277,596 277,596 283,862 6,266 102%281,252 2,611
101 34780.00 Park Admission Fees 39,000 39,000 34,948 (4,052) 90%20,866 14,083
101 34783.00 City Contract Services 59,000 59,000 159,496 100,496 270%60,551 98,945
101 36220.16 Prof Services Fee Deposit Bldg Inspectio - - 24,888 24,888 n/a 22,495 2,393
Charges for Services 1,702,315 1,702,315 1,462,944 (239,372) 86%1,337,599 125,345
Fines and Forfeitures
101 35101.00 County Court Fines - - 1,000 1,000 n/a 100 900
101 35104.00 Prosecution Restitution - - 448 448 n/a 413 35
Fines and Forfeitures - - 1,448 1,448 n/a 513 935
COMPARATIVE
City of Prior Lake
General Fund Revenues
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive ( Negative)USED 9/30/2017 Positive (Negative)
COMPARATIVE
Interest (losses) on investments
101 36210.00 Interest Earnings 86,000 86,000 97,362 11,362 113%63,481 33,882
101 36215.00 Amortization - Premium/Discount - - (16,334) (16,334) n/a - (16,334)
101 36225.00 Unrealized Inv.Gain(Loss)- - (80,194) (80,194) n/a (14,570) (65,624)
Interest (losses) on investments 86,000 86,000 835 (85,165) 1%48,911 (48,076)
Other Miscellaneous Revenues
101 36101.00 City Assess. Collection - - - - n/a 17,482 (17,482)
101 36102.00 County Assess. Collection 2,500 2,500 1,979 (521) 79%2,128 (149)
101 36211.00 Developer Agreements 195,000 195,000 253,104 58,104 130%202,328 50,776
101 36212.00 Miscellaneous Revenue 29,445 29,445 23,527 (5,918) 80%21,940 1,587
101 36230.00 Contributions & Donations - - 19,401 19,401 n/a 6,682 12,719
101 39102.00 Sale of Property - - 3,145 3,145 n/a 3,440 (295)
Other Miscellaneous Revenues 226,945 226,945 301,155 74,210 133%254,000 47,155
Other financing sources
101 39310.00 G.O. Bond Proceeds - - - - n/a - -
101 39203.00 Transfer from Other Funds 443,000 443,000 332,250 (110,750) 75%322,500 9,750
Other financing sources 443,000 443,000 332,250 (110,750) 75%322,500 9,750
Total Revenues 12,748,778 12,748,778 8,413,002 (4,335,776) 66%8,218,512 194,490
City of Prior Lake
General Fund Expenditures
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance from
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Function: General Government
41110.00 MAYOR & COUNCIL 58,196 58,196 44,411 13,785 76%50,383 5,971
41130.00 ORDINANCE 7,500 7,500 4,874 2,626 65%5,478 603
41320.00 ADMINISTRATION 428,305 436,970 310,108 126,862 71%312,986 2,878
41330.00 BOARDS & COMMISSIONS 10,689 10,689 6,739 3,950 63%7,998 1,258
41410.00 ELECTIONS 23,984 23,984 13,903 10,081 58%- (13,903)
41520.00 FINANCE 464,052 464,052 319,223 144,829 69%306,015 (13,208)
41530.00 ACCOUNTING - - (4) 4 n/a - 4
41540.00 INTERNAL AUDITING 30,700 30,700 33,190 (2,490) 108%31,240 (1,950)
41550.00 ASSESSING 194,700 194,700 192,400 2,300 99%185,000 (7,400)
41610.00 LEGAL 212,000 212,000 120,711 91,289 57%149,235 28,524
41820.00 HUMAN RESOURCES 184,443 202,443 120,211 82,232 59%151,994 31,784
41830.00 COMMUNICATIONS 124,717 124,717 84,202 40,515 68%85,608 1,406
41910.00 COMMUNITY DEVELOPMENT 326,475 326,475 224,150 102,325 69%260,712 36,563
41920.00 INFORMATION TECHNOLOGY 317,145 345,036 247,078 97,958 72%261,067 13,988
41940.00 FACILITIES - CITY HALL 461,287 461,287 352,621 108,666 76%358,588 5,967
Total - Function General Government 2,844,193 2,898,749 2,073,817 824,932 72%2,166,304 92,487
Function: Public Safety
42100.00 POLICE 4,172,825 4,172,825 2,992,493 1,180,332 72%2,684,076 (308,417)
42200.00 FIRE 929,460 944,460 501,722 442,738 53%447,018 (54,705)
42400.00 BUILDING INSPECTION 593,926 593,926 461,074 132,852 78%450,935 (10,139)
42500.00 EMERGENCY MANAGEMENT 10,830 10,830 8,869 1,961 82%9,168 299
42700.00 ANIMAL CONTROL 26,448 26,448 17,600 8,848 67%17,600 -
Total - Function Public Safety 5,733,489 5,748,489 3,981,758 1,766,731 69%3,608,798 (372,961)
Function: Public Works
43050.00 ENGINEERING 466,739 463,065 263,256 199,809 57%282,373 19,117
43100.00 STREET 1,175,385 1,175,385 883,635 291,750 75%720,265 (163,370)
43400.00 CENTRAL GARAGE 421,679 421,679 259,496 162,183 62%314,128 54,632
Total - Function Public Works 2,063,803 2,060,129 1,406,388 653,741 68%1,316,766 (89,622)
Function: Culture and Recreation
45100.00 RECREATION 427,696 427,696 353,031 74,665 83%310,796 (42,235)
45200.00 PARKS 1,407,937 1,411,611 1,084,076 327,536 77%966,094 (117,982)
45500.00 LIBRARIES 63,098 63,098 34,189 28,909 54%39,914 5,725
46100.00 NATURAL RESOURCES - - - - n/a - -
Total - Function Culture and Recreation 1,898,731 1,902,405 1,471,296 431,110 77%1,316,804 (154,492)
00000.00 Transfer to Other Funds 227,552 675,552 491,609 183,943 73%369,600 (122,009)
Function: Contingent Reserve
49999.00 CONTINGENT RESERVE - - - - n/a - -
Total - Function Contingent Reserve - - - - n/a - -
Total Expenditures 12,767,768 13,285,324 9,424,868 3,860,456 71%8,778,272 (646,596)
COMPARATIVE
City of Prior Lake
Debt Service Funds
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Property Taxes
Current Property Taxes 3,142,620 3,142,620 1,739,390 (1,403,230) 55%1,354,085 385,304
Special Assessments
City Assess. Collections - - 407,260 407,260 n/a 710,103 (302,843)
County Assess. Collection 586,355 586,355 - (586,355) 0%- -
Interest (losses) on investments
Interest Earnings 30,491 30,491 46,643 16,152 153%101,688 (55,044)
Unrealized Inv.Gain(Loss)- - (31,364) (31,364) n/a (65,634) 34,269
Miscellaneous Revenues
Miscellaneous Revenues - - - - n/a - -
Other Financing Sources
Transfer from Other Funds 870,365 870,365 133,895 (736,470) 15%272,556 (138,661)
Bond Proceeds - - - - n/a - -
Total Revenues 4,629,831 4,629,831 2,295,824 (2,334,007) 50%2,372,799 (76,974)
Expenditures
Debt Service
Principal 3,953,016 3,953,016 128,328 3,824,688 3%275,651 147,323
Interest and Other 938,256 938,256 493,046 445,210 53%840,780 347,734
Bond Issuance Costs 4,728 4,728 - 4,728 0%- -
Bond Discount/Premium - - - - n/a - -
Total Expenditures 4,896,000 4,896,000 621,374 4,274,626 13%1,116,432 495,058
Net Change (266,169) (266,169) 1,674,450 1,256,367
COMPARATIVE
City of Prior Lake
Cable Fund
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Franchise Taxes
210-41340.00.31810.00 Franchise Taxes - - - - n/a - -
Charges for Services
210-41340.00-34304.00 PEG Access Fees 32,000 32,000 18,549 (13,451) 58%20,991 (2,442)
Interest (losses) on investments
210-41340.00-36210.00 Interest Earnings - - 1,399 1,399 n/a 289 1,111
210-41340.00-36225.00 Unrealized Inv. Gain (Loss)- - (1,031) (1,031) n/a (90) (941)
Total Revenues 32,000 32,000 18,917 (13,083) 59%21,190 (2,272)
Expenditures
Current Expenditures
210-41340.00-52400.20 Small Equipment - Technology - - 4,607 (4,607) n/a - 4,607
Capital Outlay
210-41340.00-55530.00 Infrastructure - - - - n/a - -
210-41340.00-55570.00 Machinery and Equipment 80,000 80,000 60,530 19,470 76%- 60,530
Total Expenditures 80,000 80,000 65,137 14,863 81%- 65,137
Net Change (48,000) (48,000) (46,220) 21,190
COMPARATIVE
City of Prior Lake
Capital Park Fund
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Charges for Services
225-45200.00-34760.01 Facility Rental - Regular 24,000 24,000 14,000 (10,000) 58%18,000 (4,000)
225-45200.00-34791.00 Dedication Fees 405,000 405,000 393,750 (11,250) 97%416,308 (22,558)
Charges for Services 429,000 429,000 407,750 (21,250) 95%434,308 (26,558)
Interest (losses) on investments
225-00000.00-36210.00 Interest Earnings 17,000 17,000 23,364 6,364 137%10,306 13,058
225-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (17,712) (17,712) n/a (2,503) (15,210)
Interest (losses) on investments 17,000 17,000 5,652 (11,348) 33%7,803 (2,151)
Contributions and donations
225-00000.00-36230.00 Contributions & Donations - - 6,375 6,375 n/a 5,675 700
Contributions and donations - - 6,375 6,375 n/a 5,675 700
Total Revenues 446,000 446,000 419,777 (26,223) 94%447,786 (28,009)
Expenditures
54320.00 Miscellaneous 3,700 3,700 2,830 870 76%- (2,830)
59203.00 Transfers to Other Funds - - - - n/a 21,052 21,052
53100.80 Professional Services-General - - 15,025 (15,025) n/a - (15,025)
55530.00 Infrastructure - - 7,583 (7,583) n/a 25,049 17,466
Total Expenditures 3,700 3,700 25,438 (21,738) 688%46,101 20,663
Net Change 442,300 442,300 394,339 401,685
COMPARATIVE
City of Prior Lake
Revolving Equipment Fund
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Taxes
410-00000.00-31010.00 Current Property Taxes 550,000 550,000 304,577 (245,423) 55%192,972 111,605
Taxes 550,000 550,000 304,577 (245,423) 55%192,972 111,605
Intergovernmental
410-00000.00-33422.10 State Aids/Grants - Operating Grants 30,000 30,000 - (30,000) 0%- -
410-00000.00-33633.20 Watershed Dist Grants/Aid-Capital Grants - - 10,000 10,000 n/a - 10,000
Intergovernmental 30,000 30,000 10,000 (20,000) - - 10,000
Interest (losses) on investments
410-00000.00-36210.00 Interest Earnings 6,000 6,000 7,772 1,772 130%5,851 1,922
410-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (4,602) (4,602) n/a (1,290) (3,312)
Interest (losses) on investments 6,000 6,000 3,170 (2,830) 53%4,560 (1,390)
Sale of assets
410-00000.00-39102.00 Sale of Property - - 19,435 19,435 n/a - 19,435
Sale of assets - - 19,435 19,435 n/a - 19,435
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 155,000 155,000 116,250 (38,750) 75%255,750 (139,500)
Transfers in 155,000 155,000 116,250 (38,750) 75%255,750 (139,500)
OTHER FINANCING SOURCES
Debt Issued
410-00000.00-39310.00 G.O. Bond Proceeds 665,000 665,000 605,000 (60,000) 91%- 605,000
Premium on debt issued
410-43100.00-55110.00 Projects - Bond Discount/Premium - - - - n/a - -
665,000 665,000 605,000 (60,000) 91%- 605,000
Total Revenues 1,418,000 1,418,000 1,058,432 (359,568) 75%453,282 605,149
Expenditures
Public Safety
Police
410-42100.00-55550.00 Vehicles 191,690 191,690 133,212 58,478 69%101,657 (31,555)
410-42100.00-55570.00 Machinery & Equipment 46,350 46,350 - 46,350 0%- -
410-42100.06-54350.00 Agency Forfeit Proceeds - - - - n/a - -
Fire
410-42200.00-55070.00 Projects - Bond Issuance Costs - - 8,129 (8,129) n/a - (8,129)
410-42200.00-55110.00 Projects - Bond Discount/Premium - - (69,562) 69,562 n/a - 69,562
410-42200.00-55550.00 Vehicles 678,770 678,770 58,381 620,389 9%- (58,381)
410-42200.00-55570.00 Machinery & Equipment - - - - n/a - -
Total Public Safety 916,810 916,810 130,161 786,649 14%101,657 (28,504)
Public Works
Street
410-43100.00-55550.00 Vehicles - - - - n/a 228 228
410-43100.00-55570.00 Machinery & Equipment - - - - n/a 12,374 12,374
Central Garage
410-43400.00-55550.00 Vehicles 20,000 20,000 13,478 6,522 67%19,999 6,521
Total Public Works 20,000 20,000 13,478 6,522 67%32,601 19,124
Culture and Recreation/Parks
410-45200.00-55550.00 Vehicles 218,154 218,154 27,947 190,207 13%110,650 82,703
410-45200.00-55570.00 Machinery and Equipment 18,849 18,849 3,711 15,138 20%73,157 69,446
Total Culture & Recreation 237,003 237,003 31,658 205,345 13%183,807 152,150
Water
410-49400.00-55550.00 Vehicles - - - - n/a - -
410-49400.00-55570.00 Machinery and Equipment 10,094 10,094 10,464 (370) 104%- (10,464)
Water Quality
410-49420.00-55550.00 Vehicles 210,120 210,120 192,404 17,716 92%- (192,404)
Sewer
410-49450.00-55550.00 Vehicles - - - - n/a 366,453 366,453
Total Utility 220,214 220,214 202,869 17,345 92%366,453 163,584
OTHER FINANCING USES
Interest and Other
410-43100.00-55070.00 Projects - Bond Issuance Costs - - - - n/a - -
Transfers out
410-80000.00-59203.00 Transfers to Other Funds - - - - n/a - -
- - - - n/a - -
Total Expenditures 1,394,027 1,394,027 378,165 1,015,862 27%684,519 306,354
Net Change 23,973 23,973 680,266 (231,237)
COMPARATIVE
City of Prior Lake
Facilities Management Fund
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Interest (losses) on investments
440-00000.00-36210.00 Interest Earnings 5,400 5,400 7,381 1,981 137%7,185 196
440-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (6,116) (6,116) n/a (1,685) (4,431)
Interest (losses) on investments 5,400 5,400 1,265 (4,135) 23%5,501 (4,236)
Transfers in
440-00000.00-39203.00 Transfer from Other Funds 58,350 58,350 43,763 (14,588) 75%42,488 1,275
Transfers in 58,350 58,350 43,763 (14,588) 75%42,488 1,275
Debt Issued
440-00000.00-39310.00 G.O. Bond Proceeds 620,000 620,000 - (620,000) 0%370,000 (370,000)
440-42200.00-39310.00 G.O. Bond Proceeds-FIRE - - 560,000 560,000 n/a - 560,000
Debt Issued 620,000 620,000 560,000 (60,000) 90%370,000 (190,000)
Total Revenues 683,750 683,750 605,027 (78,723) 88%417,988 (192,961)
Expenditures
Function: General Government
00000.00 Transfers to Other Funds - - - - n/a 10,307 10,307
41940-55050.00 Projects Professional Svcs- FACILITIES - CITY HALL - - 10,048 (10,048) n/a - (10,048)
41940-55570.00 Machinery & Equipment-FACILITIES - CITY HALL - - - - n/a 10,690 10,690
41960.00 GESP - - - - n/a - -
Total - Function General Government - - 10,048 (10,048) n/a 20,997 10,949
Function: Public Safety
42100-55520.00 Building & Building Improvements-POLICE 8,000 8,000 - 8,000 0%- -
42100-55570.00 Machinery and Equipment-POLICE - - - - n/a 10,690 10,690
42200-55070.00 Projects-Bond Inssuance Costs-FIRE - - 7,524 (7,524) n/a - (7,524)
42200-55520.00 Projects-Publication-FIRE - - 229 (229) n/a - (229)
42200-55520.00 Building & Building Improvements-FIRE 843,204 843,204 74,499 768,705 9%9,505 (64,994)
42200-55570.00 Machinery & Equipment-FIRE - - 317,757 (317,757) n/a - (317,757)
42200-55110.00 Bond Discount/Premium-STREET - - (69,643) 69,643 n/a - 69,643
43100-55070.00 Machinery & Equipment-STREET - 7,472
43100-55110.00 Bond Discount/Premium-STREET - (9,913)
Total - Function Public Safety 851,204 851,204 330,366 520,838 39%17,754 (312,612)
Function: Culture and Recreation
45100.00 RECREATION - - - - n/a - -
45500.00 LIBRARIES - 79,961 - 79,961 0%- -
Total - Function Culture and Recreation - 79,961 - 79,961 0%- -
Function: Water
49400.00 Building & Building Improvements 22,500 22,500 21,995 505 98%341,503 319,508
Total - Function Culture and Recreation 22,500 22,500 21,995 505 98%341,503 319,508
Total Expenditures 873,704 953,665 362,409 591,256 38%380,254 17,845
Net Change (189,954) (269,915) 242,618 37,734
COMPARATIVE
City of Prior Lake
Permanent Improvement Revolving Fund
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Special Assessments
450-00000.00-36101.00 City Assess. Collections - - 5,760 5,760 n/a 960 4,800
450-00000.00-36102.00 County Assess. Collection 83,314 83,314 24,169 (59,145) 29%- 24,169
83,314 83,314 29,929 (53,385) 36%960 28,969
Interest (losses) on investments
450-00000.00-36210.00 Interest Earnings 1,538 1,538 5,383 3,845 350%957 4,427
450-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (3,462) (3,462) n/a (299) (3,163)
Interest (losses) on investments 1,538 1,538 1,922 384 125%658 1,264
Transfers in
450-00000.00-39203.00 Transfer from Other Funds - 148,000 148,000 - 100%120,000 28,000
Transfers in - 148,000 148,000 - 100%120,000 28,000
Debt Issued
450-00000.00-39310.00-PIR17-000001 G.O. Bond Proceeds - - - - n/a 355,000 (355,000)
450-00000.00-39310.00-PIR18-000001 G.O. Bond Proceeds - - 490,000 490,000 n/a - 490,000
450-00000.00-39310.00 G.O. Bond Proceeds 600,000 600,000 - (600,000) 0%- -
Debt Issued 600,000 600,000 490,000 (110,000) 82%355,000 (135,000)
Total Revenues 684,852 832,852 669,851 (163,001) 80%476,618 (76,767)
Expenditures
Function: Public Works
450-43100.00-54010.01 STREET 650,000 650,000 623,378 26,622 96%- (623,378)
450-43100.00-55070.00-PIR17-000001 Projects - Bond Issuance Costs - - - - n/a 7,169 7,169
450-43100.00-55070.00-PIR18-000001 Projects - Bond Issuance Costs - - 6,584 (6,584) n/a - (6,584)
450-43100.00-55110.00-PIR17-000001 Projects - Bond Discount/Premium - - - - n/a (9,601) (9,601)
450-43100.00-55110.00-PIR18-000001 Projects - Bond Discount/Premium - - (34,493) 34,493 n/a - 34,493
450-43100.00-55530.00-PIR17-000001 Infrastructure - - - - n/a 377,020 377,020
Total - Function Public Works 650,000 650,000 595,468 54,532 92%374,587 (220,881)
OTHER FINANCING USES
Transfers out
450-80000.00-59203.00 Transfers to Other Funds 75,374 75,374 6,824 68,550 9%- (6,824)
Total Expenditures 725,374 725,374 602,292 123,082 83%374,587 (227,705)
Net Change (40,522) 107,478 67,559 102,030
COMPARATIVE
City of Prior Lake
Water Fund
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Water Charges
601-49400.00-37100.00 Utility Receipts - Water 3,691,044 3,691,044 2,057,127 (1,633,917) 56%2,154,686 (97,560)
601-49400.00-37160.00 Penalties - - 14,814 14,814 n/a 12,406 2,407
Water Charges 3,691,044 3,691,044 2,071,940 (1,619,104) 56%2,167,092 (95,152)
Capital Facility charges
601-49400.00-37110.00 Capital Facility Revenue 268,680 268,680 174,861 (93,819) 65%173,292 1,569
Capital Facility charges 268,680 268,680 174,861 (93,819) 65%173,292 1,569
Meter Sales
601-49400.00-37170.00 Water Meter Sales 82,750 82,750 77,579 (5,172) 94%37,572 40,006
601-49400.00-37175.00 Pressure Reducers 32,700 32,700 23,718 (8,982) 73%10,344 13,374
601-49400.00-37180.00 Frost Plates - - - - n/a - -
Meter Sales 115,450 115,450 101,297 (14,153) 88%47,916 53,380
Intergovernmental
601-00000.00-33422.15 State Aids/Grants - Operating Public Wor - - - - n/a 2,770 (2,770)
601-00000.00-33422.25 State Aids/Grants - Capital Public Works - - - - n/a 500 (500)
Intergovernmental - - - - n/a 3,270 (3,270)
Interest (losses) on investments
601-00000.00-36210.00 Interest Earnings 35,900 35,900 44,759 8,859 125%29,460 15,299
601-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (33,993) (33,993) n/a (6,072) (27,921)
Interest (losses) on investments 35,900 35,900 10,766 (25,134) 30%23,388 (12,622)
Miscellaneous Revenues
601-00000.00-36212.00 Miscellaneous Revenue - - 9,120 9,120 n/a 7,690 1,430
601-00000.00-36102.00 County Assess Collection - - 26,874 26,874 n/a 78 26,797
601-00000.00-36231.00 PERA Pension Contributions - - - - n/a - -
601-49400.00-37190.00 Miscellaneous Revenue Adj - - 19 19 n/a 91 (72)
601-00000.00-37901.00 Contribution (Other Fund)- - - - n/a - -
601-00000.00-37902.00 Contribution (Developers)- - - - n/a - -
Miscellaneous Revenues - - 36,013 36,013 n/a 7,859 28,154
Transfers in
39203.00 Transfer from Other Funds 1,500,000 1,500,000 - (1,500,000) 0%- -
1,500,000 1,500,000 - (1,500,000) 0%- -
Sale of Assets
601-00000.00-39102.00 Sale of Property - - 1,185 1,185 n/a - 1,185
- - 1,185 1,185 n/a - 1,185
Debt Issued
601-00000.00-39310.00 G.O. Bond Proceeds 1,180,000 1,180,000 - (1,180,000) 0%- -
601-49400.00-39310.00-CAP18-000001 G.O. Bond Proceeds - - 1,320,000 1,320,000 n/a - 1,320,000
Debt Issued 1,180,000 1,180,000 1,320,000 140,000 112%- (1,320,000)
Total Revenues 6,791,074 6,791,074 3,716,062 (3,075,012) 55%2,422,817 (1,346,755)
Expenditures
Function: General Government
00000.00 Transfers to Other Funds 845,545 845,545 1,091,543 (245,998) 129%1,647,843 556,300
41520.00 FINANCE 82,682 82,682 66,572 16,110 81%59,703 (6,868)
Total - Function General Government 928,227 928,227 1,158,115 (229,888) 125%1,707,546 549,431
Function: Water
49400.00 WATER 5,731,297 5,732,570 1,950,778 3,781,793 34%1,239,141 (711,636)
601-49400.00-55070.00-CAP18-000001 Bond issuance Costs - - 17,736 (17,736) n/a - (17,736)
601-49400.00-55110.00-CAP18-000001 Projects - Bond Discount/Premium - - (167,618) 167,618 n/a - 167,618
Total - Function Water 5,731,297 5,732,570 1,800,896 3,764,057 31%1,239,141 (729,372)
Function: Sewer
601-49450.00-55530.00 SEWER - - 195 (195) n/a - (195)
Total - Function Sewer - - 195 (195) n/a - (195)
Total Expenditures 6,659,524 6,660,797 2,959,206 3,533,974 44%2,946,688 (180,135)
Net Change 131,550 130,277 756,856 (523,870)
COMPARATIVE
City of Prior Lake
Sewer Fund
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Sewer Charges
604-49450.00-37102.00 Utility Receipts - Sewer 1,664,040 1,664,040 1,013,774 (650,266) 61%937,388 76,386
604-49450.00-37104.00 Utility Recpt-Sewer MCES 1,511,220 1,511,220 917,818 (593,402) 61%892,735 25,082
Sewer Charges 3,175,260 3,175,260 1,931,592 (1,243,668) 61%1,830,124 101,468
Capital Facility charges
604-49450.00-37110.00 Capital Facility Revenue 268,680 268,680 174,866 (93,814) 65%173,297 1,568
Capital Facility charges 268,680 268,680 174,866 (93,814) 65%173,297 1,568
Water Charges
604-49450.00-37160.00 Penalties 10,000 10,000 17,146 7,146 171%12,780 4,366
Water Charges 10,000 10,000 17,146 7,146 171%12,780 4,366
Intergovernmental
604-00000.00-33422.25 State Aids/Grants - Capital Public Works - - - - n/a - -
Intergovernmental - - - - n/a - -
Interest (losses) on investments
604-00000.00-36210.00 Interest Earnings 18,500 18,500 19,792 1,292 107%15,810 3,982
604-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (13,533) (13,533) n/a (3,035) (10,497)
Interest (losses) on investments 18,500 18,500 6,260 (12,240) 34%12,775 (6,516)
Miscellaneous Revenues
604-00000.00-36212.00 Miscellaneous Revenue - - - - n/a - -
604-00000.00-36231.00 PERA Pension Contributions - - - - n/a - -
604-00000.00-37901.00 Contribution (Other Fund)- - - - n/a 372,114 (372,114)
604-00000.00-37902.00 Contribution (Developers)- - - - n/a - -
Miscellaneous Revenues - - - - n/a 372,114 (372,114)
Debt Issued
604-00000.00-39310.00 G.O. Bond Proceeds 1,400,000 1,400,000 1,320,000 (80,000) 94%- 1,320,000
Debt Issued 1,400,000 1,400,000 1,320,000 (80,000) 94%- (1,320,000)
Sale of Property
604-00000.00-39310.00 Sale of Property - - 1,185 1,185 n/a - 1,185
Sale of Property - - 1,185 1,185 n/a - (1,185)
Transfers in
39203.00 Transfer from Other Funds - - - - n/a - -
- - - - n/a - -
Total Revenues 4,872,440 4,872,440 3,451,048 (1,421,392) 71%2,401,090 (1,592,411)
Expenditures
Function: General Government
00000.00 Transfers to Other Funds 271,109 271,109 1,049,256 (778,147) 387%1,144,085 94,829
41520.00 FINANCE 82,682 82,682 66,013 16,669 80%58,320 (7,693)
Total - Function General Government 353,791 353,791 1,115,269 (761,478) 315%1,202,405 87,136
Function: Sewer
49450.00 SEWER 4,389,176 4,418,451 1,900,332 2,518,119 43%1,626,128 (274,204)
49450.00 Interest and Other - - 17,736 (17,736) n/a - (17,736)
49450.00 Premium on debt issued - - (167,618) 167,618 n/a - 167,618
Total - Function Sewer 4,389,176 4,418,451 1,750,451 2,668,001 40%1,626,128 (124,322)
Total Expenditures 4,742,967 4,772,242 2,865,719 1,906,523 60%2,828,533 (37,186)
Net Change 129,473 100,198 585,329 (427,443)
COMPARATIVE
City of Prior Lake
Water Quality Fund
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance from
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Storm Water Charges
602-49420.00-37120.00 Storm Water Revenue 916,326 916,326 653,518 (262,808) 71%599,803 53,715
Storm Water Charges 916,326 916,326 653,518 (262,808) 71%599,803 53,715
Water Charges
602-49420.00-37160.00 Penalties - - 2,980 2,980 n/a 2,591 389
Water Charges - - 2,980 2,980 n/a 2,591 389
Intergovernmental
602-00000.00-33160.10 Fed Aids/Grants - - - - n/a - -
602-00000.00-33422.10 State Aids/Grants - - - - n/a 1,379 (1,379)
602-49420.00-33610.20 County-City Aids/Grants - - - - n/a - -
602-49420.00-33633.00 Watershed Dist Grants/Aid - 130,000 130,000 - 100%- 130,000
602-49420.00-32250.00 Wetland Application Fee - - 750 750 n/a - 750
Intergovernmental - 130,000 130,750 750 101%1,379 129,371
Interest (losses) on investments
602-00000.00-36210.00 Interest Earnings 12,000 12,000 12,853 853 107%10,526 2,328
602-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (11,353) (11,353) n/a (2,255) (9,098)
Interest (losses) on investments 12,000 12,000 1,500 (10,500) 13%8,271 (6,771)
Transfers in
602-00000.00-39203.00 Transfer from Other Funds - - - - n/a 42,093 (42,093)
Transfers in - - - - n/a 42,093 (42,093)
Miscellaneous Revenues
602-00000.00-36212.00 Miscellaneous Revenue - - - - n/a 120 (120)
602-00000.00-36231.00 PERA Pension Contributions - - - - n/a - -
602-00000.00-37901.00 Contribution (Other Fund)- - - - n/a - -
Miscellaneous Revenues - - - - n/a 120 (120)
Total Revenues 928,326 1,058,326 788,749 (269,577) 75%654,258 134,492
Expenditures
Function: General Government
00000.00 Transfers to Other Funds 77,000 77,000 405,581 (328,581) 527%434,965 29,384
Total - Function General Government 77,000 77,000 405,581 (328,581) 527%434,965 29,384
Function: Water Quality
49420.00 WATER QUALITY 921,669 1,254,420 737,574 516,846 59%353,081 (384,493)
Total - Function Water Quality 921,669 1,254,420 737,574 516,846 59%353,081 (384,493)
Total Expenditures 998,669 1,331,420 1,143,155 188,265 86%788,046 (355,109)
Net Change (70,343) (273,094) (354,406) (133,788)
COMPARATIVE
City of Prior Lake
Economic Development Authority Special Revenue Fund
As of 9/30/2018
(Preliminary & Unaudited)
Variance from Variance from
2018 2018 2018 Amended Budget - % BDGT Actual from 2017
Budget Amended Actual Positive (Negative)USED 9/30/2017 Positive (Negative)
Revenues
Taxes
240-00000.00-31010.00 Current Property Taxes 140,000 140,000 77,024 (62,976) 55%71,957 5,067
240-00000.00-33423.00 Market Value Credit Aid - - - - n/a - -
Taxes 140,000 140,000 77,024 (62,976) 55%71,957 5,067
Intergovernmental
240-46500.00-33610.14 County-City Aids/Grants - Operating EDA - - - - n/a - -
Intergovernmental - - - - n/a - -
Charges for Services
240-46503.00-34760.02 Facility Rental - EDA 7,820 7,820 6,196 (1,624) 79%6,043 154
Charges for Services 7,820 7,820 6,196 (1,624) 79%6,043 154
Interest (losses) on investments
240-00000.00-36210.00 Interest Earnings 2,700 2,700 5,840 3,140 216%2,069 3,772
240-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (3,538) (3,538) n/a (458) (3,080)
Interest (losses) on investments 2,700 2,700 2,303 (397) 85%1,611 (692)
Transfers In
240-00000.00-39203.00 Transfer from Other Funds - 300,000 300,000 - 100%- 300,000
Transfers In - 300,000 300,000 - 100%- (300,000)
Total Revenues 150,520 450,520 385,523 (64,997) 86%79,610 305,913
Expenditures
Function: Economic Development
46500.00 ECONOMIC DEVELOPMENT 145,777 145,777 137,294 8,483 94%69,820 (67,474)
46503.00 TECH VILLAGE INCUBATOR 7,820 7,820 819 7,001 10%1,139 320
Total Expenditures 153,597 153,597 138,112 15,485 90%70,959 (67,154)
Net Change (3,077) 296,923 247,411 8,652
COMPARATIVE