Loading...
HomeMy WebLinkAbout05(D) - Preliminary Year-End 2019 Financial Reports Report City of Prior Lake General Fund Summary As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Taxes 8,380,973 8,380,973 8,367,850 (13,123) 100%7,988,125 379,725 Licenses and Permits 642,118 642,118 992,096 349,978 155%994,613 (2,517) Intergovernmental 1,861,819 1,861,819 1,925,225 63,406 103%1,835,750 89,475 Charges for Services 1,716,170 1,716,170 1,832,895 116,725 107%1,987,982 (155,087) Fines and Forfeitures - - 996 996 n/a 1,448 (452) Interest (losses) on investments 87,400 87,400 260,433 173,033 298%54,716 205,717 Other 192,739 192,739 204,305 11,566 106%333,653 (129,348) Transfers in 456,300 456,300 456,300 - 100%443,000 13,300 Total Revenues 13,337,519 13,337,519 14,040,101 702,582 105%13,639,287 400,814 Expenditures General Government 3,035,892 3,067,131 3,081,990 (14,859) 100%2,815,389 (266,602) Public Safety 6,158,109 6,205,080 6,082,647 122,433 98%5,746,524 (336,122) Public Works 2,060,778 2,066,295 1,961,664 104,631 95%1,882,970 (78,694) Culture and Recreation 1,964,771 1,981,103 1,889,266 91,837 95%1,850,588 (38,678) Transfer to other funds 334,769 334,769 334,769 - 100%819,651 484,882 Contingent Reserve - - - - n/a - - Total Expenditures 13,554,319 13,654,378 13,350,336 304,042 98%13,115,121 (235,214) Net Change (216,800) (316,859) 689,765 524,166 COMPARATIVE City of Prior Lake General Fund Revenues As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive ( Negative)USED 12/31/2018 Positive (Negative) Taxes 101 31010.00 Current Property Taxes - General Purpos 7,460,524 7,460,524 7,422,107 (38,417) 99%7,075,018 347,089 101 31020.00 Delinquent Property Taxes - General Purp - - 42,681 23,782 n/a 37,448 5,232 101 31040.00 Fiscal Disparities 920,449 920,449 902,101 (18,348) 98%874,720 27,381 101 33423.00 Market Value Credit Aid - - 962 962 n/a 940 22 Taxes 8,380,973 8,380,973 8,367,850 (13,123) 100%7,988,125 379,725 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,615 (2,175) 97%77,115 (4,500) 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 746,713 300,215 167%692,661 54,052 101 32211.00 Retainage Forfeiture - - - - n/a 1,500 (1,500) 101 32215.00 Mechanical Permits 50,833 50,833 81,038 30,205 159%107,559 (26,520) 101 32230.00 Plumbing Permits 42,658 42,658 55,793 13,135 131%80,686 (24,893) 101 32231.00 Sewer/Water Inspection 7,399 7,399 13,007 5,608 176%14,339 (1,332) 101 32232.00 Plumbing Registrations 1,200 1,200 1,880 680 157%1,438 442 101 32240.00 Animal Licenses 3,750 3,750 4,520 770 121%4,170 350 101 32260.00 Burning Permits 4,000 4,000 3,840 3,000 96%4,070 (230) 101 32270.00 Short-term Rental Fee 3,000 3,000 3,485 485 116%2,455 1,030 101 32175.00 Public Private Gathering Permit 240 240 630 390 263%780 (150) 101 32190.00 Community Event Application 100 100 500 400 500%200 300 Licenses and Permits 642,118 642,118 992,096 349,978 155%994,613 (2,517) Intergovernmental 101 33160.11 Fed Aids/Grants - Operating Police 17,000 17,000 1,821 (15,179) 11%7,504 (5,683) 101 33401.00 Local Government Aid 11,905 11,905 11,905 - 100%11,905 - 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 228,988 13,988 107%217,502 11,486 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 378,807 1,598 100%376,210 2,597 101 33420.00 State Fire Aid-Ins. Prem.220,000 220,000 236,651 16,651 108%225,610 11,041 102 33422.11 State Aids/Grants - Operating Police 3,000 3,000 4,406 1,406 147%2,959 1,447 101 33610.11 County Aids/Grants - Operating Police - - 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 52,680 2,911 106%48,793 3,887 101 33631.00 Payment in Lieu of Taxes 600,000 600,000 600,000 - 100%570,000 30,000 101 33700.11 Miscellaneous Grants - Operating Police 36,000 36,000 33,346 (2,654) 93%42,204 (8,858) Intergovernmental 1,861,819 1,861,819 1,925,225 63,406 103%1,835,750 89,475 Charges for Services 101 31810.00 Franchise Taxes 615,000 615,000 639,783 24,783 104%630,932 8,850 101 34103.00 Zoning & Subdivision Fees 20,857 20,857 32,104 11,247 154%39,712 (7,609) 101 34104.00 Plan Check Fees 277,528 277,528 382,837 105,309 138%390,827 (7,990) 101 34105.00 Sale of Maps/Publications - Reports 1,000 1,000 837 (163) 84%510 327 101 34107.00 Assessment Searches - Reports 400 400 675 275 169%490 185 101 34109.00 Project Admin/Eng Fees 263,000 263,000 63,948 (199,052) 24%199,189 (135,242) 101 34203.00 Accident/Warrant Reports - Reports 200 200 90 (110) 45%143 (53) 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 42,863 (4,137) 91%42,409 454 101 34735.01 Recreation Program Fees Regular 6,000 6,000 22,427 16,427 374%12,311 10,116 101 34740.00 Concessions - Park Fees 300 300 - (300) 0%822 (822) 101 34760.01 Facility Rental - Regular 35,418 35,418 36,336 918 103%52,217 (15,881) 101 34761.00 Studio/Pavilion Rental 24,000 24,000 20,274 (3,726) 84%19,848 425 101 34762.00 Park Shelter Rental 42,500 42,500 56,145 13,645 132%54,242 1,903 101 34763.13 Facility Usage Fee (not taxable)3,000 3,000 1,200 (1,800) 40%- 1,200 101 34765.01 Tower Leases 291,967 291,967 312,116 20,149 107%290,462 21,653 101 34780.00 Park Admission Fees 24,000 24,000 24,548 548 102%34,861 (10,314) 101 34783.00 City Contract Services 50,000 50,000 177,577 127,577 355%168,925 8,652 101 36220.16 Prof Services Fee Deposit Bldg Inspectio - - 9,342 9,342 n/a 35,841 (26,499) Charges for Services 1,716,170 1,716,170 1,832,895 116,725 107%1,987,982 (155,087) Fines and Forfeitures 101 35101.00 County Court Fines - - - - n/a 1,000 (1,000) 101 35104.00 Prosecution Restitution - - 996 996 n/a 448 548 Fines and Forfeitures - - 996 996 n/a 1,448 (452) Interest (losses) on investments 101 36210.00 Interest Earnings 87,400 87,400 160,461 73,061 184%133,312 27,148 101 36215.00 Amortization - Premium/Discount - - (8,690) (8,690) n/a (20,302) 11,612 101 36225.00 Unrealized Inv.Gain(Loss)- - 116,516 116,516 n/a (58,293) 174,809 101 36226.00 Realized Inv.Gain(Loss)- - (7,853) (7,853) n/a - (7,853) Interest (losses) on investments 87,400 87,400 260,433 173,033 298%54,716 205,717 Other Miscellaneous Revenues 101 36101.00 City Assess. Collection - - 519 519 n/a (2,518) 3,037 101 36102.00 County Assess. Collection 5,000 5,000 (379) (5,379) -8%7,209 (7,589) 101 36211.00 Developer Agreements 158,000 158,000 119,021 (38,979) 75%260,975 (141,954) 101 36212.00 Miscellaneous Revenue 29,739 29,739 56,864 27,125 191%39,285 17,580 101 36230.00 Contributions & Donations - - 18,403 18,403 n/a 25,380 (6,977) 101 39102.00 Sale of Property - - 9,877 9,877 n/a 3,323 6,555 Other Miscellaneous Revenues 192,739 192,739 204,305 11,566 106%333,653 (129,348) Other financing sources 101 39203.00 Transfer from Other Funds 456,300 456,300 456,300 - 100%443,000 13,300 Other financing sources 456,300 456,300 456,300 - 100%443,000 13,300 Total Revenues 13,337,519 13,337,519 14,040,101 702,582 105%13,639,287 400,814 COMPARATIVE City of Prior Lake General Fund Expenditures As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance from 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Function: General Government 41110.00 MAYOR & COUNCIL 71,866 71,866 70,144 1,722 98%63,173 (6,971) 41130.00 ORDINANCE 7,500 7,500 4,025 3,475 54%7,091 3,066 41320.00 ADMINISTRATION 436,935 437,985 529,001 (91,016) 121%442,163 (86,838) 41330.00 BOARDS & COMMISSIONS 11,765 11,765 8,720 3,045 74%9,811 1,092 41400.00 CITY CLERK 60,550 60,860 83,980 (23,120) 138%- (83,980) 41410.00 ELECTIONS - - - - n/a 20,558 20,558 41520.00 FINANCE 480,310 487,805 480,576 7,229 99%446,862 (33,714) 41540.00 INTERNAL AUDITING 31,300 31,300 37,564 (6,264) 120%30,615 (6,949) 41550.00 ASSESSING 202,600 202,600 202,418 182 100%194,716 (7,702) 41610.00 LEGAL 200,000 200,000 152,275 47,725 76%162,462 10,188 41820.00 HUMAN RESOURCES 188,830 189,450 187,117 2,333 99%194,356 7,239 41830.00 COMMUNICATIONS 128,297 128,607 126,563 2,044 98%116,934 (9,629) 41910.00 COMMUNITY DEVELOPMENT 348,365 349,694 328,191 21,503 94%329,122 932 41920.00 INFORMATION TECHNOLOGY 394,650 414,035 402,446 11,589 97%344,208 (58,238) 41940.00 FACILITIES - CITY HALL 472,924 473,664 468,972 4,692 99%453,316 (15,656) Total - Function General Government 3,035,892 3,067,131 3,081,990 (14,859) 100%2,815,389 (266,602) Function: Public Safety 42100.00 POLICE 4,586,881 4,631,101 4,505,684 125,417 97%4,172,589 (333,095) 42200.00 FIRE 932,896 933,636 944,350 (10,714) 101%960,918 16,568 42400.00 BUILDING INSPECTION 599,949 601,960 594,465 7,495 99%577,534 (16,931) 42500.00 EMERGENCY MANAGEMENT 11,935 11,935 9,947 1,988 83%9,083 (864) 42700.00 ANIMAL CONTROL 26,448 26,448 28,200 (1,752) 107%26,400 (1,800) Total - Function Public Safety 6,158,109 6,205,080 6,082,647 122,433 98%5,746,524 (336,122) Function: Public Works 43050.00 ENGINEERING 373,844 375,304 348,294 27,010 93%351,133 2,838 43100.00 STREET 1,226,903 1,229,480 1,200,526 28,954 98%1,130,272 (70,254) 43400.00 CENTRAL GARAGE 460,031 461,511 412,844 48,667 89%401,565 (11,279) Total - Function Public Works 2,060,778 2,066,295 1,961,664 104,631 95%1,882,970 (78,694) Function: Culture and Recreation 45100.00 RECREATION 416,675 398,525 433,568 (35,043) 109%435,613 2,045 45200.00 PARKS 1,481,141 1,515,623 1,393,652 121,971 92%1,366,193 (27,458) 45500.00 LIBRARIES 66,955 66,955 62,046 4,909 93%48,781 (13,265) Total - Function Culture and Recreation 1,964,771 1,981,103 1,889,266 91,837 95%1,850,588 (38,678) 00000.00 Transfer to Other Funds 334,769 334,769 334,769 - 100%819,651 484,882 Function: Contingent Reserve 49999.00 CONTINGENT RESERVE - - - - n/a - - Total - Function Contingent Reserve - - - - n/a - - Total Expenditures 13,554,319 13,654,378 13,350,336 304,042 98%13,115,121 (235,214) COMPARATIVE City of Prior Lake Expenditures- Payroll Wages Only As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance from 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) GENERAL FUND Function: General Government 41110.00 MAYOR & COUNCIL 48,216 48,216 48,216 - 100%39,180 (9,036) 41320.00 ADMINISTRATION 279,108 279,108 360,809 (81,701) 129%282,494 (78,315) 41330.00 BOARDS & COMMISSIONS 10,000 10,000 8,100 1,900 81%8,900 800 41400.00 CITY CLERK FUNCTIONS 46,058 46,058 65,529 (19,471) 142%- (65,529) 41410.00 ELECTIONS - - - - n/a 18,043 18,043 41520.00 FINANCE 357,827 357,827 362,334 (4,507) 101%336,905 (25,430) 41820.00 HUMAN RESOURCES 117,024 117,024 124,346 (7,322) 106%114,751 (9,595) 41830.00 COMMUNICATIONS 83,189 83,189 84,254 (1,065) 101%78,990 (5,264) 41910.00 COMMUNITY DEVELOPMENT 228,629 228,629 231,581 (2,952) 101%224,263 (7,318) 41920.00 INFORMATION TECHNOLOGY 118,162 118,162 119,372 (1,210) 101%115,847 (3,525) 41940.00 FACILITIES - CITY HALL 61,434 61,434 66,965 (5,531) 109%64,337 (2,628) Total - Function General Government 1,349,647 1,349,647 1,471,507 (121,860) 109%1,283,710 (187,797) Function: Public Safety 42100.00 POLICE 3,090,997 3,110,197 3,088,601 21,596 99%2,947,665 (140,936) 42200.00 FIRE 328,855 328,855 327,064 1,791 99%331,068 4,004 42400.00 BUILDING INSPECTION 420,164 420,164 446,837 (26,673) 106%429,955 (16,882) Total - Function Public Safety 3,840,016 3,859,216 3,862,502 (3,286) 100%3,708,688 (153,814) Function: Public Works 43050.00 ENGINEERING 233,208 233,208 238,456 (5,248) 102%221,401 (17,055) 43100.00 STREET 314,132 314,132 299,150 14,982 95%292,533 (6,617) 43400.00 CENTRAL GARAGE 170,418 170,418 165,188 5,230 97%153,327 (11,860) Total - Function Public Works 717,758 717,758 702,794 14,964 98%667,262 (35,532) Function: Culture and Recreation 45100.00 RECREATION 237,601 218,401 240,106 (21,705) 110%257,627 17,521 45200.00 PARKS 775,214 775,214 751,535 23,679 97%790,327 38,792 Total - Function Culture and Recreation 1,012,815 993,615 991,641 1,974 100%1,047,954 56,313 General Fund Payroll Only Expenditures Total 6,920,236 6,920,236 7,028,444 (108,208) 102%6,707,615 (320,830) EDA FUND Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 97,587 97,587 101,801 (4,214) 104%94,992 (6,809) EDA Fund Payroll Only Expenditures Total 97,587 97,587 101,801 (4,214) 104%94,992 (6,809) WATER FUND Function: Water 41520.00 Finance 53,089 53,089 50,741 2,348 96%42,386 (8,355) 49400.00 Water 496,447 496,447 535,166 (38,719) 108%483,212 (51,954) Water Fund Payroll Only Expenditures Total 549,536 549,536 585,907 (36,371) 107%525,598 (60,309) SEWER FUND Function: Sewer 41520.00 Finance 50,564 50,564 50,737 (173) 100%42,382 (8,354) 49450.00 Sewer 477,722 477,722 486,016 (8,294) 102%446,533 (39,483) Sewer Fund Payroll Only Expenditures Total 528,286 528,286 536,753 (8,467) 102%488,915 (47,837) STORM WATER FUND Function: Storm Water 49420.00 Water Quality 225,752 225,752 243,968 (18,216) 108%218,369 (25,599) Storm Water Fund Payroll Only Expenditures Total 225,752 225,752 243,968 (18,216) 108%218,369 (25,599) City-Wide Total Payroll Expenditures 8,321,397 8,321,397 8,496,873 (175,476) 102%8,035,489 (461,384) COMPARATIVE City of Prior Lake Debt Service Funds As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Property Taxes Current Property Taxes 3,262,770 3,262,770 3,262,770 - 100%3,139,950 122,820 Special Assessments City Assess. Collections - - 194,959 194,959 n/a 457,725 (262,765) County Assess. Collection 646,901 646,901 504,953 (141,948) 78%539,559 (34,607) Interest (losses) on investments Interest Earnings 33,703 33,703 85,607 51,904 254%68,289 17,318 Unrealized Inv.Gain(Loss)- - 61,319 61,319 n/a (24,323) 85,642 Miscellaneous Revenues Miscellaneous Revenues - - - - n/a - - Other Financing Sources Transfer from Other Funds 1,131,409 1,131,409 1,345,090 213,681 119%1,171,696 173,394 Total Revenues 5,074,783 5,074,783 5,454,698 379,915 107%5,352,896 101,802 Expenditures Debt Service Principal 4,193,512 4,193,512 4,193,512 (0) 100%3,953,016 (240,496) Interest and Other 1,146,472 1,146,472 1,146,470 2 100%938,255 (208,215) Bond Issuance Costs 5,343 5,343 6,090 (747) 114%6,340 250 Refunded Assessment Pmts - - 13,573 (13,573) n/a - (13,573) Transfers to Other Funds 135,000 135,000 148,164 (13,164) 110%58,024 (90,140) Total Expenditures 5,480,327 5,480,327 5,507,809 (27,482) 101%4,955,635 (552,174) Net Change (405,544) (405,544) (53,111) 397,261 COMPARATIVE City of Prior Lake Cable Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Charges for Services 210-41340.00-34304.00 PEG Access Fees 37,133 37,133 28,901 (8,232) 78%36,081 (7,181) Interest (losses) on investments 210-41340.00-36210.00 Interest Earnings - - 1,648 1,648 n/a 1,698 (50) 210-41340.00-36225.00 Unrealized Inv. Gain (Loss)- - 1,201 1,201 n/a (878) 2,079 Total Revenues 37,133 37,133 31,749 (5,384) 86%36,901 (5,152) 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 20,020 (5,020) 133%60,530 40,511 Total Expenditures 17,805 17,805 20,262 (2,457) 114%65,137 44,875 Net Change 19,328 19,328 11,487 (28,236) COMPARATIVE City of Prior Lake Capital Park Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Charges for Services 225-45200.00-34760.01 Facility Rental - Regular 24,000 24,000 18,700 (5,300) 78%20,300 (1,600) 225-45200.00-34791.00 Dedication Fees 450,000 450,000 290,490 (159,510) 65%486,426 (195,936) Charges for Services 474,000 474,000 309,190 (164,810) 65%506,726 (197,536) Intergovernmental 225-45200.00-33700.20 Miscellaneous - Capital Grants - - 100,000 100,000 n/a - 100,000 Intergovernmental - - 100,000 100,000 n/a - 100,000 Interest (losses) on investments 225-00000.00-36210.00 Interest Earnings 24,000 24,000 41,144 17,144 171%33,034 8,110 225-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 29,813 29,813 n/a (13,090) 42,903 Interest (losses) on investments 24,000 24,000 70,956 46,956 296%19,944 51,012 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 484,346 (13,654) 97%533,045 (48,699) Expenditures 54320.00 Miscellaneous - - 917 (917) n/a 7,545 6,628 53810.00 Utilities - Electric - - 156 (156) n/a - (156) 59203.00 Transfers to Other Funds - - - - n/a - - 53100.80 Professional Services-General 50,000 50,000 48,662 1,339 97%49,420 759 55530.00 Infrastructure 420,000 420,000 454,461 (34,461) 108%7,953 (446,508) Total Expenditures 470,000 470,000 504,195 (34,195) 107%64,918 (439,277) Net Change 28,000 28,000 (19,849) 468,127 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Taxes 410-00000.00-31010.00 Current Property Taxes 600,000 600,000 599,619 (381) 100%549,823 49,796 Taxes 600,000 600,000 599,619 (381) 100%549,823 49,796 Intergovernmental 410-00000.00-33422.10 State Aids/Grants - Operating Grants - - - - n/a - - 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 24,453 16,678 315%16,224 8,228 410-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 14,566 14,566 n/a (2,484) 17,050 Interest (losses) on investments 7,775 7,775 39,019 31,244 502%13,740 25,278 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%7,195 (7,195) Other 12,000 12,000 - (12,000) 0%7,195 (7,195) Transfers in 410-00000.00-39203.00 Transfer from Other Funds 217,600 217,600 160,000 (57,600) 74%155,000 5,000 Transfers in 217,600 217,600 160,000 (57,600) 74%155,000 5,000 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 1,061,698 (24,637) 98%1,429,755 (368,057) Expenditures Public Safety Police 410-42100.00-55550.00 Vehicles 99,725 99,725 128,718 (28,993) 129%133,212 4,495 410-42100.00-55570.00 Machinery & Equipment 108,099 154,449 58,374 96,075 38%- (58,374) 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 613,780 614,294 (514) 100%300,897 (313,397) Building Inspection 410-42400.00-55550.00 Vehicles 59,410 59,410 30,539 - 51%- (30,539) Total Public Safety 516,194 927,364 837,781 60,713 90%442,239 (395,542) 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 91,963 7,133 93%- (91,963) Central Garage 410-43400.00-55550.00 Vehicles 20,000 20,000 18,739 1,261 94%21,118 2,379 Total Public Works 442,882 442,882 197,078 245,804 44%21,118 (175,959) Culture and Recreation/Parks 410-45200.00-55550.00 Vehicles - - - - n/a 232,057 232,057 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%235,768 144,933 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 191,303 191,303 Total Utility 66,519 66,519 55,549 10,970 84%201,768 146,219 Total Expenditures 1,149,336 1,560,506 1,181,242 350,393 76%900,892 (280,350) Net Change (63,001) (474,171) (119,544) 528,862 COMPARATIVE City of Prior Lake Revolving Park Equipment Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Taxes 430-00000.00-31010.00 Current Property Taxes 289,292 289,292 289,269 (23) 100%238,477 50,792 Taxes 289,292 289,292 289,269 (23) 100%238,477 50,792 Interest (losses) on investments 430-00000.00-36210.00 Interest Earnings 7,310 7,310 18,323 11,013 251%12,305 6,019 430-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 13,084 13,084 n/a (4,764) 17,847 Interest (losses) on investments 7,310 7,310 31,407 24,097 430%7,541 23,866 Other 430-45200.00-36230.00 Contributions & Donations - - - - n/a 10,000 (10,000) Other - - - - n/a 10,000 (10,000) Total Revenues 296,602 296,602 320,676 24,074 108%256,018 64,658 Expenditures Culture and Recreation/Parks 430-45200.00-55530.00 Infrastructure 289,292 355,292 158,797 196,495 45%54,134 (104,663) Total Culture & Recreation 289,292 355,292 158,797 196,495 45%54,134 (104,663) Total Expenditures 289,292 355,292 158,797 196,495 45%54,134 (104,663) Net Change 7,310 (58,690) 161,879 201,885 COMPARATIVE City of Prior Lake Facilities Management Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Interest (losses) on investments 440-00000.00-36210.00 Interest Earnings 4,763 4,763 10,242 5,479 215%10,357 (115) 440-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 7,363 7,363 n/a (4,312) 11,676 Interest (losses) on investments 4,763 4,763 17,606 12,843 370%6,044 11,561 Transfers in 440-00000.00-39203.00 Transfer from Other Funds 94,927 94,927 94,927 - 100%58,350 36,577 Transfers in 94,927 94,927 94,927 - 100%58,350 36,577 Debt Issued 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) Total Revenues 99,690 99,690 112,533 12,843 113%694,037 (511,862) Expenditures Function: General Government 41940-55050.00 Projects Professional Svcs- FACILITIES - CITY HALL - - 10,349 (10,349) n/a 10,048 (301) Total - Function General Government - - 10,349 (10,349) n/a 10,048 (301) Function: Public Safety 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%422,908 422,908 42200-55570.00 Machinery & Equipment-FIRE - - - - n/a 320,456 320,456 Total - Function Public Safety 67,998 67,998 - 67,998 0%751,118 751,118 Function: Culture and Recreation 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 23,096 17,156 Total - Function Culture and Recreation - - 5,940 (5,940) n/a 23,096 17,156 Total Expenditures 89,963 149,963 48,926 101,037 33%784,262 735,335 Net Change 9,727 (50,273) 63,606 (90,224) COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Taxes 450-00000.00-31010.00 Property Taxes - General Purpose 95,000 95,000 94,862 (138) 100%- 94,862 Taxes 95,000 95,000 94,862 (138) 100%- 94,862 Special Assessments 450-00000.00-36101.00 City Assess. Collections 230,089 230,089 251,576 21,487 109%223,401 28,175 450-00000.00-36102.00 County Assess. Collection - - 108,607 108,607 n/a 46,575 62,033 230,089 230,089 360,184 130,095 157%269,976 90,208 Interest (losses) on investments 450-00000.00-36210.00 Interest Earnings 4,231 4,231 12,482 8,251 295%8,055 4,427 450-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 9,276 9,276 n/a (2,069) 11,345 Interest (losses) on investments 4,231 4,231 21,758 17,527 514%5,986 15,772 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 G.O. Bond Proceeds 490,000 490,000 400,000 (90,000) 82%490,000 (90,000) Debt Issued 490,000 490,000 400,000 (90,000) 82%490,000 (90,000) OTHER FINANCING SOURCES 450-43100.00-39315.00 Projects - Bond Premium - - 48,709 (48,709) n/a - (48,709) Total Revenues 819,320 819,320 925,512 8,775 113%913,961 (85,867) Expenditures Function: Public Works 450-43100.00-54010.01 STREET 700,000 700,000 664,954 35,046 95%623,378 (41,576) 450-43100.00-55070.00-PIR18-000001 Projects - Bond Issuance Costs - - - - n/a 6,584 6,584 450-43100.00-55070.00-PIR19-000001 Projects - Bond Issuance Costs - - 10,894 (10,894) n/a - (10,894) 450-43100.00-55110.00-PIR18-000001 Projects - Bond Discount/Premium - - - - n/a (34,493) (34,493) Total - Function Public Works 700,000 700,000 675,848 24,152 97%595,468 (80,379) OTHER FINANCING USES Transfers out 450-80000.00-59203.00 Transfers to Other Funds 186,933 186,933 186,933 - 100%75,374 (111,559) Total Expenditures 886,933 886,933 862,781 24,152 97%670,842 (191,938) Net Change (67,613) (67,613) 62,731 243,119 COMPARATIVE City of Prior Lake Water Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Operating Revenue Water Charges 601-49400.00-37100.00 Utility Receipts - Water 3,799,222 3,799,222 3,319,356 (479,866) 87%3,535,919 (216,563) 601-49400.00-37160.00 Penalties - - 19,340 19,340 n/a 22,108 (2,768) 3,799,222 3,799,222 3,338,695 (460,527) 88%3,558,026 (219,331) Capital Facility charges 601-49400.00-37110.00 Capital Facility Revenue 272,280 272,280 280,532 8,252 103%263,705 16,828 272,280 272,280 280,532 8,252 103%263,705 16,828 Meter Sales 601-49400.00-37170.00 Water Meter Sales 74,350 74,350 124,163 49,813 167%106,138 18,025 601-49400.00-37175.00 Pressure Reducers 27,300 27,300 29,149 1,849 107%31,826 (2,677) 101,650 101,650 153,312 51,662 151%137,964 15,348 Total Operating Revenue 4,173,152 4,173,152 3,772,540 (400,612) 90%3,959,695 (187,155) Non-Operating Revenue Intergovernmental 601-494.00-33610.10 County-City Aids/Grants-Operations - - 573 573 n/a 500 73 - - 573 573 n/a 500 73 Interest (losses) on investments 601-00000.00-36210.00 Interest Earnings 37,250 37,250 106,415 69,165 286%74,954 31,461 601-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 77,662 77,662 n/a (16,238) 93,900 37,250 37,250 184,078 146,828 494%58,716 125,362 Miscellaneous Revenues 601-00000.00-36212.00 Miscellaneous Revenue - - 18,166 18,166 n/a 11,938 6,228 601-00000.00-36102.00 County Assess Collection - - 6,614 6,614 n/a 54,401 (47,787) 601-00000.00-36231.00 PERA Pension Contributions - - 1,010 1,010 n/a 3,333 (2,323) 601-49400.00-37185.00 AMRS Brass Recycling - - 19,815 19,815 n/a 7,983 11,832 601-49400.00-37190.00 Miscellaneous Revenue Adj - - (34) (34) n/a 27 (61) - - 45,571 45,571 - 77,683 (32,112) Total Non-Operating Revenue 37,250 37,250 230,221 192,971 618%136,899 93,322 Total Revenues 4,210,402 4,210,402 4,002,761 (207,641) 95%4,096,594 (93,834) Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 94,075 94,385 93,084 1,301 99%98,023 4,939 49400.00 Water 1,941,435 1,944,109 1,992,409 (48,300) 102%1,773,554 (218,855) 2,035,510 2,038,494 2,085,493 (46,999) 102%1,871,577 (213,916) Depreciation 49400.00 Water - - 888,449 804,126 (84,322) - - 888,449 (888,449) n/a 804,126 (84,322) Principal 49400.00 Water 105,000 105,000 - 105,000 0%- - 105,000 105,000 - 105,000 0%- - Interest & other 49400.00 Water 78,200 78,200 56,031 22,169 72%42,173 (13,858) 78,200 78,200 56,031 22,169 72%42,173 (13,858) Capital improvements 55530.00 Infrastructure 2,000,000 2,480,830 2,359,901 120,929 95%3,456 (2,356,445) 55570.00 Machinery and equipment 142,826 144,163 10,158 134,005 7%- (10,158) 55580.00 Software - 17,553 - 17,553 0%- - 2,142,826 2,642,546 2,370,059 272,487 90%3,456 (2,366,603) 57000.00 Loss on Disposal of Assets - - 3,000 (3,000) n/a - (3,000) Total - Function Sewer - - 3,000 (3,000) n/a - (3,000) 55700.00 Contra Capital Outlay - - (2,360,036) 2,360,036 n/a - 2,360,036 Total Expenditures 4,361,536 4,864,240 3,042,996 1,821,244 2,721,332 (321,664) 29.2% Other Financing Sources Contribution of assets 601-00000.00-37901.00 Contribution (Other Fund)- - 2,537,191 2,537,191 n/a 2,691,005 (153,814) 601-00000.00-37902.00 Contribution (Developers)- - 285,509 285,509 n/a 507,943 (222,434) - - 2,822,700 2,822,700 n/a 3,198,948 (376,248) Transfers in 39203.00 Transfer from Other Funds 1,900,000 1,900,000 1,873,151 (26,849) 99%2,608,474 (735,323) 1,900,000 1,900,000 1,873,151 (26,849) 99%2,608,474 (735,323) 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-39315.00 Projects - Bond Premium - - 16,762 16,762 n/a - 16,762 - - 16,762 16,762 n/a - (16,762) Total Other Financing Sources 1,900,000 1,900,000 4,712,612 2,812,612 60%5,808,606 (1,129,517) Other Financing Uses 59203.00 Transfers to other funds 895,495 895,495 995,495 (100,000) 1,622,445 626,950 Total Other Financing Uses 895,495 895,495 995,495 (100,000) 1,622,445 626,950 Net Change 853,371 350,667 4,676,882 883,727 5,561,423 (1,528,637) COMPARATIVE City of Prior Lake Sewer Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Sewer Charges 604-49450.00-37102.00 Utility Receipts - Sewer 1,932,978 1,932,978 1,823,095 (109,883) 94%1,576,644 246,452 604-49450.00-37104.00 Utility Recpt-Sewer MCES 1,601,700 1,601,700 1,493,306 (108,394) 93%1,405,830 87,475 604-49450.00-37160.00 Penalties 15,000 15,000 25,090 10,090 167%24,340 749 3,549,678 3,549,678 3,341,490 (208,188) 94%3,006,814 334,676 Capital Facility charges 604-49450.00-37110.00 Capital Facility Revenue 272,280 272,280 280,542 8,262 103%263,712 16,830 272,280 272,280 280,542 8,262 103%263,712 16,830 Total Operating Revenue 3,821,958 3,821,958 3,622,033 (199,925) 95%3,270,527 351,506 Non-Operating Revenue Interest (losses) on investments 604-00000.00-36210.00 Interest Earnings 18,800 18,800 41,187 22,387 219%33,833 7,355 604-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 27,640 27,640 n/a (9,270) 36,910 18,800 18,800 68,827 50,027 366%24,563 44,265 Miscellaneous Revenues 604-00000.00-36102.00 County Assess. Collections - - (3,734) (3,734) n/a - (3,734) 604-00000.00-36212.00 Miscellaneous Revenue - - 934 934 n/a - 934 604-00000.00-36231.00 PERA Pension Contributions - - 954 954 n/a 2,778 (1,824) - - (1,846) (1,846) n/a 2,778 (4,624) Total Non-Operating Revenue 18,800 18,800 66,982 48,182 356%27,341 39,641 Total Revenue 3,840,758 3,840,758 3,689,014 (151,744) 96%3,297,868 391,147 Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 91,341 91,651 92,948 (1,297) 101%97,405 4,457 49450.00 Sewer 2,564,890 2,568,132 2,552,036 16,096 99%2,278,724 (273,312) 2,656,231 2,659,783 2,644,984 14,799 99%2,376,129 (268,855) Depreciation 49400.00 Sewer - - 563,826 511,909 (51,917) - - 563,826 (563,826) n/a 511,909 (51,917) Principal 49450.00 Sewer 105,000 105,000 - 105,000 0%- - 105,000 105,000 - 105,000 0%- - Interest & other 49450.00 Sewer 78,200 78,200 56,031 22,169 72%42,173 (13,858) 78,200 78,200 56,031 22,169 72%42,173 (13,858) Capital improvements 55530.00 Infrastructure 400,000 880,830 418,886 461,944 48%4,459 (414,427) 55570.00 Machinery and equipment 81,832 83,169 73,011 10,158 88%- (73,011) 55580.00 Software - 17,553 - 17,553 0%- - 481,832 981,552 491,897 489,655 50%4,459 (487,438) 55700.00 Contra Capital Outlay - - (418,886) 418,886 n/a - 418,886 Total Expenditures 3,321,263 3,824,535 3,337,852 486,683 2,934,670 (403,182) Other Financing Sources Contribution of assets 604-00000.00-37901.00 Contribution (Other Fund)- - 1,709,980 1,709,980 n/a 576,051 1,133,929 604-00000.00-37902.00 Contribution (Developers)- - 310,986 310,986 n/a 487,277 (176,291) - - 2,020,966 2,020,966 n/a 1,063,328 957,638 Debt Issued 604-00000.00-39315.00 Projects - Bond Premium - - 16,762 16,762 n/a - 16,762 - - 16,762 16,762 n/a - 16,762 Sale of Property 604-00000.00-39310.00 Sale of Property - - - - n/a 1,185 (1,185) Transfers in 39203.00 Transfer from Other Funds - - 306,280 306,280 n/a 17,434 288,845 - - 306,280 306,280 n/a 17,434 288,845 Total Other Financing Sources - - 2,344,007 2,344,007 n/a 1,081,947 1,262,060 Other Financing Uses 59203.00 Transfers to other funds 277,147 277,147 527,147 (250,000) 190%1,117,033 589,886 Total Other Financing Uses 277,147 277,147 527,147 (250,000) 190%1,117,033 589,886 Total Expenditures 3,044,116 3,547,388 5,154,712 3,080,690 145%2,899,583 268,992 Net Change 242,348 (260,924) 2,168,023 1,955,580 328,112 1,466,503 COMPARATIVE City of Prior Lake Water Quality Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Storm Water Charges 602-49420.00-37120.00 Storm Water Revenue 978,674 978,674 1,055,564 76,890 108%982,174 73,390 602-49420.00-32250.00 Wetland Application Fee - - 750 750 n/a 900 (150) 978,674 978,674 1,056,314 77,640 108%983,074 73,240 Water Charges 602-49420.00-37160.00 Penalties - - 3,979 3,979 n/a 4,164 (186) - - 3,979 3,979 n/a 4,164 (186) Total Operating Revenue 978,674 978,674 1,060,292 81,618 108%987,238 73,054 Non-Operating Revenue Intergovernmental 602-00000.00-33422.10 State Aids/Grants - - - - n/a 5,002 (5,002) 602-49420.00-33633.00 Watershed Dist Grants/Aid - - - - n/a 130,000 (130,000) - - - - n/a 135,002 (135,002) Interest (losses) on investments 602-00000.00-36210.00 Interest Earnings 11,690 11,690 22,661 10,971 194%16,688 5,973 602-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 14,736 14,736 n/a (9,288) 24,024 11,690 11,690 37,397 25,707 320%7,400 29,997 Miscellaneous Revenues 602-00000.00-36212.00 Miscellaneous Revenue - - 12,327 12,327 n/a - 12,327 602-00000.00-36231.00 PERA Pension Contributions - - 387 387 n/a 1,389 (1,002) - - 12,714 12,714 n/a 1,389 11,325 Total Non-Operating Revenue 11,690 11,690 50,110 38,420 429%143,791 (93,680) Total Revenues 990,364 990,364 1,110,403 120,039 112%1,131,029 (20,626) Total Expenditures Personnel and current expenditures (excluding depreciation) 49420.00 Water Quality 532,642 534,022 442,244 91,778 83%453,726 11,482 532,642 534,022 442,244 91,778 83%453,726 11,482 Depreciation 49400.00 Water Quality - - 134,427 121,889 (12,538) - - 134,427 (134,427) n/a 121,889 (12,538) Capital improvements 55530.00 Infrastructure 385,000 385,000 106,551 278,449 28%24,412 (82,139) 385,000 385,000 106,551 278,449 28%24,412 (82,139) 55700.00 Contra Capital Outlay - - (71,569) 71,569 n/a - 71,569 Total Expenditures 917,642 919,022 611,653 307,369 67%600,027 (11,626) Other Financing Sources Contribution of assets 602-00000.00-37901.00 Contribution (Other Fund)- - 335,892 335,892 n/a 361,550 (25,658) 602-00000.00-37902.00 Contribution (Developers)- - 17,600 17,600 n/a 66,473 (48,873) - - 353,492 353,492 n/a 428,023 (74,531) Transfers in 602-00000.00-39203.00 Transfer from Other Funds - - 267,517 267,517 n/a 143,612 123,905 - - 267,517 267,517 n/a 143,612 123,905 Total Other Financing Sources - - 621,009 621,009 n/a 571,635 49,374 Other Financing Uses Total Other Financing Sources 59203.00 Transfers to other funds 83,860 83,860 126,760 (42,900) 151%480,666 353,906 Total Other Financing Uses 83,860 83,860 126,760 (42,900) 151%480,666 353,906 Net Change (11,138) (12,518) 992,999 476,578 621,971 (313,532) COMPARATIVE City of Prior Lake Economic Development Authority Special Revenue Fund As of 12/31/2019 (Preliminary & Unaudited) Variance from Variance 2019 2019 2019 Amended Budget - % BDGT Actual from 2018 Budget Amended Actual Positive (Negative)USED 12/31/2018 Positive (Negative) Revenues Taxes 240-00000.00-31010.00 Current Property Taxes 150,000 150,000 149,698 (302) 100%139,511 10,187 Taxes 150,000 150,000 149,698 (302) 100%139,511 10,187 Charges for Services 240-46503.00-34760.02 Facility Rental - EDA 7,820 7,820 10,120 2,300 129%8,018 2,103 Charges for Services 7,820 7,820 10,120 2,300 129%8,018 2,103 Interest (losses) on investments 240-00000.00-36210.00 Interest Earnings 3,300 3,300 11,306 8,006 343%8,544 2,762 240-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 8,289 8,289 n/a (2,163) 10,453 Interest (losses) on investments 3,300 3,300 19,595 16,295 594%6,380 (13,215) Contributions and Donations 240-00000.00-36230.00 Contributions and Donations - - 8,600 8,600 n/a - 8,600 Contributions and Donations - - 8,600 8,600 n/a - (8,600) 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) Total Revenues 161,120 161,120 188,013 26,893 117%453,909 (265,896) Expenditures Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 145,467 191,887 167,478 24,409 87%145,491 (21,987) 46503.00 TECH VILLAGE INCUBATOR 4,350 4,350 4,076 274 94%4,362 286 Total Expenditures 149,817 196,237 171,554 24,683 87%149,853 (21,701) Net Change 11,303 (35,117) 16,459 304,056 COMPARATIVE