CITY OF COLUMBUS 2014-2015 BUDGET BUDGET SUMMARY WORKSHEETS
1-2 1-6 1-2 1-6
2015 2015 2014 2014
Condensed Budget Summary Worksheet Budget Summary Worksheet Condensed Budget Summary Worksheet Budget Summary Worksheet
CITY OF COLUMBUS, NEBRASKA CONDENSED BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2015
TOTAL GENERAL FUNDS
9/30/2011 BALANCE 5,911,538
---------------ACTUAL--------------DISBURSEMENTS RECEIPTS 14,571,136 14,730,171
9/30/2012 BALANCE 6,070,573
-------------ACTUAL------------RECEIPTS DISBURSEMENTS 14,035,382 13,530,358
9/30/2013 BALANCE 6,575,597
TOTAL SPECIAL REVENUES
5,868,701
7,831,431
6,352,736
7,347,396
7,556,705
6,387,189
8,516,912
TOTAL CAPITAL PROJECTS
151,208
3,289,142
2,496,085
944,264
1,851,703
1,929,459
866,508
TOTAL DEBT SERVICE FUNDS
1,177,015
1,318,877
1,014,423
1,481,469
1,243,415
1,244,183
1,480,701
TOTAL ENTERPRISE FUNDS
8,437,572
17,701,445
17,790,038
8,348,979
12,651,284
11,465,940
9,534,323
TOTAL INTERNAL SERVICE FUND
821,145
2,414,047
2,671,149
564,043
2,791,601
1,768,464
1,587,180
TOTAL TRUST & AGENCY FUNDS
1,400,361
261,764
108,344
1,553,781
254,247
134,816
1,673,211
23,767,540
47,546,877
45,003,912
26,310,504
40,384,338
36,460,409
30,234,433
GRAND TOTAL ALL FUNDS
Page 1 of 2
CITY OF COLUMBUS, NEBRASKA CONDENSED BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2015
TOTAL GENERAL FUNDS
9/30/2013 BALANCE 6,575,597
-----ACTUAL AND ESTIMATED----DISBURSEMENTS RECEIPTS 13,564,411 13,935,943
PROJECTED 9/30/2014 BALANCE 6,947,129
------PROPOSED BUDGET-----RECEIPTS DISBURSEMENTS 15,712,680 15,737,810
PROJECTED 9/30/2015 BALANCE 6,921,999
TOTAL SPECIAL REVENUES
8,516,912
8,712,635
9,210,795
8,018,752
6,711,062
10,161,725
4,568,089
TOTAL CAPITAL PROJECTS
866,508
11,917,565
6,146,250
6,637,823
16,097,420
20,543,800
2,191,443
TOTAL DEBT SERVICE FUNDS
1,480,701
2,416,340
2,194,155
1,702,886
2,348,600
2,521,555
1,529,931
TOTAL ENTERPRISE FUNDS
9,534,323
18,073,795
18,017,895
9,590,223
18,002,620
19,927,645
7,665,198
TOTAL INTERNAL SERVICE FUND
1,587,180
2,752,000
2,204,000
2,135,180
2,752,000
2,752,000
2,135,180
TOTAL TRUST & AGENCY FUNDS
1,673,211
143,100
89,100
1,727,211
220,900
106,000
1,842,111
30,234,433
57,951,378
51,426,606
36,759,205
61,845,282
71,750,535
26,853,952
GRAND TOTAL ALL FUNDS
Page 2 of 2
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2015
General Fund General Administration Columbus Area Transit Senior Center City Admin Office Finance City Clerk Mayor/City Council Human Resources Police Animal Control Fire Rescue Volunteer Fire Department Library Literacy Cemetery Community Development Parks Pawnee Plunge Aquatic Center Pool Van Berg Quail Run Platte County Library Service Perpetual Care TOTAL GENERAL FUNDS
9/30/2011 BALANCE 5,899,394
---------------ACTUAL--------------RECEIPTS DISBURSEMENTS
9/30/2012 BALANCE 6,057,056
-------------ACTUAL------------RECEIPTS DISBURSEMENTS 10,459,451 216,568 129,406
87,132
1,406,440 245,028 210,839 191,715 270,855 285,898 54,174 102,519 3,979,305 171,679 659,380 1,081,768 52,936 907,467
-24,218 36,362
56,140 172,888 542,894 463,743 807,586 72,708 472,106 91,734 7,155
191,671 182,202 2,329,632 463,743 807,586 225,890 652,892 97,336 180
-29,820 43,337
71,911 186,300 641,335 406,159 427,940 91,217 420,306 113,436 29,516
119,085 189,929 1,323,336 406,159 427,940 270,464 655,826 103,522
5,911,538
14,730,171
14,571,136
6,070,573
14,035,382
13,530,358
10,910,490 221,186 124,737
142,217 52,378 143,585 361,491
Page 1 of 6
129,460 55,216 161,009 401,912 94,240
9/30/2013 BALANCE 6,522,650
1,045,860 256,324 247,316 210,288 278,764 248,805 55,949 104,331 4,104,089 170,525 1,392,246 883,006 66,281 970,313
-19,906 72,853 6,575,597
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2015
Streets/Engineering Streets Engineering Airport Sales Tax E911 E911 Wireless EC-911 Equipment Sharing Housing Rehab & Loans Housing Rehab & Loans New Neighborhoods Economic Development Reuse Progress and Jobs Growth Keno TOTAL SPECIAL REVENUES Capital Projects Community Redevl Auth Village Add Shopping Cntr HyVee Slumberland Ramada-Columbus Hobby Lobby TOTAL CAPITAL PROJECTS Debt Service Old Assessments Taxes/1 nterest Assessments Not Bonded Flood Control Bonds 2004 VPB/2009 GO Refunding Water Park Bonds 2008 Various Purpose Bonds 2011 Various Purpose Bonds 2012 Variuos Purpose Bonds 2014 Assessments Not Bonded TOTAL DEBT SERVICE FUNDS
9/30/2011 BALANCE 533,708
---------------ACTUAL--------------RECEIPTS DISBURSEMENTS
-125,883 3,527,726 23,169 30,861
3,043,235 91,852 1,457,689 1,512,310 182,765 63,100
2,407,108 461,694 975,433 802,332 176,975 9,483
21,845
72,502
72,311
9/30/2012 BALANCE 799,993
356,373 4,237,705 28,959 84,477 0 22,036
275,751 905,806 675,717 5,868,701
605,294 352,899 449,785 7,831,431
630,498 407,789 409,112 6,352,736
250,547 850,916 716,389 7,347,396
-354,783 505,990
2,516,874
1,657,821
504,271 439,993
418,475 353,793
389,535 448,047 682
3,289,142
2,496,085
151,208 1,177,015
1,177,015
944,264
-------------ACTUAL------------RECEIPTS DISBURSEMENTS 3,070,118 91,253 1,015,091 1,970,134 159,268 101,440
2,555,966 438,501 854,634 1 ,551 ,210 144,836 64,070
158,129 4,016 150,603 356,136 480,517 7,556,705
159,611 27,941 115,561 54,859 420,000 6,387,189
1,306,281
1,515,630
472,379 68,492 4,552
390,020 3,098 6,378 14,334
1,851,703
1,929,459
1,481,469 200,000 723 625,563 128,870
207,902 674 619,030 59,349
200,000 674 619,030 126,995
60,154 236,742 114,678
42,770 16,498
15,880 219,844 120,736
41,958 141,734 113,793
1,318,877
1,014,423
1,243,415
1,244,183
Page 2 of 6
516,830 4,656,629 43,391 121,847 0 -3,371
285,589 1,152,193 776,906 8,516,912 294,922 571,586
866,508 1,480,701
212,155 723 625,563 68,863
1,481,469
9/30/2013 BALANCE 966,898
1,480,701
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2015 9/30/2011 BALANCE Utility Service Sanitary Sewer Wastewater Treatment Facility Sewer System Construction Water Water Superfund Project Loup Distribution Solid Waste Division Transfer Station Recycle Center TOTAL ENTERPRISE FUNDS
---------------ACTUAL--------------RECEIPTS DISBURSEMENTS
-------------ACTUAL------------RECEIPTS DISBURSEMENTS
1,080,769
1 '102,430 5,488,836 5,601
3,193,335 2,322,763
7,459,384 433,613 2,976,791
7,370,238 461,378 3,023,068
8,437,572
1,387,932 -50,712 17,701,445
1,333,638 85,618 17,790,038
Health Insurance TOTAL INTERNAL SERVICE FUND
821,145 821,145
2,414,047 2,414,047
2,671,149 2,671,149
Police Pension Fire Pension Aviation Field Licenses to Schools Library Foundation Library Endowment Gerrard Park Trust TOTAL TRUST & AGENCY FUNDS
43,209 33,959 0 0 57,673 1,130,365 135,156 1 ,400,361
32,531 22,475
23,389 22,482
13,920 18,204 171,194 3,440 261,764
23,767,540
47,546,877
1,449,308 2,033,153
3,726,320 420,900 3,337,870
2,802,990 396,644 3,000,000
8,348,979
1,403,007 18,314 12,651,284
1,773,302 10,543 11,465,940
564,043 564,043
2,791,601 2,791,601
1,768,464 1,768,464
3,097,349 257,463
9/30/2013 BALANCE 1,343,181
3,693,092 51,781 3,913,398
3,852,017
3,143,626 339,499
9/30/2012 BALANCE
4,860,984
3,435,219 -105,061
9,534,323
1 ,587,180 1 ,587,180
24,162 22,541
23,389 22,482
13,920 20,639 24,235 3,680 108,344
52,351 33,952 0 0 55,239 1,277,323 134,916 1,553,781
14,203 22,426 171,412 -497 254,247
14,203 46,779 24,169 3,794 134,816
53,124 34,011 0 0 30,885 1,424,566 130,625 1,673,211
45,003,912
26,310,504
40,384,338
36,460,409
30,234,433
Page 3 of6
General Fund General Administration Columbus Area Transit Senior Center City Admin Office Finance City Clerk Mayor/City Council Human Resources Police Animal Control Fire Rescue Volunteer Fire Department Library Literacy Cemetery Community Development Parks Pawnee Plunge Aquatic Center Pool Van Berg Quail Run Platte County Library Service Perpetual Care TOTAL GENERAL FUNDS
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2015 PROJECTED -----ACTUAL AND ESTIMATED----9/30/14 9/30/2013 ------PROPOSED BUDGET-----BALANCE BALANCE RECEIPTS DISBURSEMENTS RECEIPTS DISBURSEMENTS 6,898,787 6,522,650 10,244,475 11,617,350 1,375,532 1 '137,395 273,100 338,000 463,100 569,425 161,500 11,400 110,200 226,035 236,750 290,825 300,200 316,506 312,970 87,715 87,085 97,070 99,500 4,460,450 115,630 4,263,800 114,450 183,125 50,000 201,560 49,960 1,136,925 690,500 189,700 210,000 449,120 970,950 488,200 1,004,550 61,650 84,750 1,220,750 82,700 1,558,640 83,838
-19,906 72,853
63,500 200,175 621,750 424,000 564,525 77,600 462,120 104,650 400
158,565 212,600 1,151,670 424,000 564,525 227,215 670,990 109,655
6,575,597
13,935,943
13,564,411
Page 4 of 6
-24,911 73,253
64,500 200,475 663,250 640,325 446,050 77,600 469,180 125,100 400
142,990 203,150 1,431 '1 00 640,325 446,050 237,358 986,530 111 '140
6,947,129
15,712,680
15,737,810
PROJECTED 9/30/15 BALANCE 6,859,297
-10,951 73,653 0 6,921,999
Streets/Engineering Streets Engineering Airport Sales Tax E911 E911 Wireless EC-911 Equipment Sharing Housing Rehab & Loans Housing Rehab & Loans New Neighborhoods Economic Development Reuse Progress and Jobs Growth Keno TOTAL SPECIAL REVENUES Capital Projects Community Redevl Auth Village Add Shopping Cntr HyVee Slum berland Ramada-Columbus Hobby Lobby TOTAL CAPITAL PROJECTS Debt Service Old Assessments Taxes/Interest Assessments Not Bonded Flood Control Bonds 2004 VPB/2009 GO Refunding Water Park Bonds 2008 Various Purpose Bonds 2011 Various Purpose Bonds 2012 Variuos Purpose Bonds 2014 Assessments Not Bonded TOTAL DEBT SERVICE FUNDS
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2015 PROJECTED 9/30/2013 -----ACTUAL AND ESTIMATED----9/30/14 ------PROPOSED BUDGET-----RECEIPTS DISBURSEMENTS BALANCE BALANCE RECEIPTS DISBURSEMENTS 966,898 1,188,010 3,074,200 2,497,750 3,191,200 2,979,400 109,462 464,800 91,462 529,925 516,830 359,700 261,280 615,250 441,500 375,525 4,656,629 1,922,025 2,385,850 4,192,804 399,750 3,092,500 43,391 137,638 182,805 -1,776 127,400 120,875 121,847 94,900 -18,253 235,000 73,800 98,500 0 1,044,400 1,043,600 800 180,200 180,000 -3,371 -42,371 100,000 100,000 150,000 150,000 426,000 465,000 155,000 95,000 285,589 564,560 554,610 295,539 1,050,000 1,050,000 1, 152,193 399,750 550,000 1,001,943 360,750 1,000,000 480,000 786,806 776,906 470,100 490,000 490,000 8,516,912 8,712,635 9,210,795 8,018,752 6,711,062 10,161,725 294,922 571,586
866,508
10,601,215
4,814,100
390,150 43,000 373,200 510,000
390,150 43,000 377,500 516,500 5,000 6,146,250
11,917,565
1,480,701
1,480,701
6,082,037 555,786
6,637,823
15,175,620
19,620,000
390,100 47,700 25,000 25,000 434,000 16,097,420
390,100 47,700 20,000 25,000 441,000 20,543,800
1,702,886 196,500 630 1,248,850 51,000 319,710 26,000 140,000 317,500 116,150 2,416,340
276,790 200,000 630 1,248,850 129,710 33,250 45,960 140,515 118,450 2,194,155
Page 5 of6
1,702,886
PROJECTED 9/30/15 BALANCE 961,347
681,225 1,500,054 4,749 -42,953 1,000 17,629
295,539 362,693 786,806 4,568,089 1,637,657 553,786
2,191,443 1,529,931
696,500 620 677,400 46,500 740,580 10,000 48,000 115,000 14,000 2,348,600
677,400 620 677,400 126,930 737,680 44,760 138,890 117,875 2,521,555
1,529,931
- - - - - - -
-------------------------,
- - - - ยท --
9/30/2013 BALANCE Utility Service Sanitary Sewer Wastewater Treatment Facility Sewer System Construction Water Water Superfund Project Loup Distribution Solid Waste Division Transfer Station Recycle Center TOTAL ENTERPRISE FUNDS
Health Insurance TOTAL INTERNAL SERVICE FUND Police Pension Fire Pension Aviation Field Licenses to Schools Library Foundation Library Endowment Gerrard Park Trust TOTAL TRUST & AGENCY FUNDS
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2015 PROJECTED -----ACTUAL AND ESTIMATED----9/30/14 ------PROPOSED BUDGET-----RECEIPTS DISBURSEMENTS BALANCE RECEIPTS DISBURSEMENTS
1,343,181
1,396,116 4,195,310 1,000
1,674,925 2,468,450
3,457,335 390,000 3,549,000
3,089,170 390,225 5,682,000
6,449,150 32,000 18,073,795
4,709,025 4,100 18,017,895
9,534,323
1,587,180 1,587,180
2,752,000 2,752,000
1,457,316 4,578,570 4,200,000
2,089,920 6,627,450
3,531,600 400,000 3,675,000
4,218,150 398,775 3,675,000
1,617,450
2,918,350
9,590,223
18,002,620
19,927,645
7,665,198
2,204,000 2,204,000
2,135,180 2,135,180
2,752,000 2,752,000
2,752,000 2,752,000
2,135,180 2,135,180
8,300 22,500
8,400 22,500
14,600 101,000 72,000 2,500 220,900
14,600 48,000 10,000 2,500 106,000
53,024 34,011 0 0 75,885 1,548,566 130,625 1,842,111
61,845,282
71,750,535
26,853,952
4,860,984
3,435,219 -105,061
PROJECTED 9/30/15 BALANCE
5,228,924
1,302,219 1,662,964
53,124 34,011 0 0 30,885 1,424,566 130,625 1,673,211
23,500 22,500
23,500 22,500
14,600 8,000 72,000 2,500 143,100
14,600 16,000 10,000 2,500 89,100
53,124 34,011 0 0 22,885 1,486,566 130,625 1,727,211
30,234,433
57,951,378
51,426,606
36,759,205
Page 6 of 6
4,543,599
1,302,219 362,064
CITY OF COLUMBUS, NEBRASKA CONDENSED BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2014
TOTAL GENERAL FUNDS
9/30/2010 BALANCE 5,439,361
---------------ACTUAL--------------RECEIPTS DISBURSEMENTS 12,809,437 12,337,260
9/30/2011 BALANCE 5,911,538
-------------ACTUAL------------RECEIPTS DISBURSEMENTS 14,730,171 14,571,136
9/30/2012 BALANCE 6,070,573
TOTAL SPECIAL REVENUES
4,880,828
6,845,346
5,857,473
5,868,701
7,831,431
6,352,736
7,347,396
TOTAL CAPITAL PROJECTS
75,031
4,968,822
4,892,645
151,208
3,289,142
2,496,085
944,264
TOTAL DEBT SERVICE FUNDS
2,307,504
1,971,619
3,102,108
1,177,015
1,318,877
1,014,423
1,481,469
TOTAL ENTERPRISE FUNDS
9,490,305
21,796,804
22,849,537
8,437,572
17,701,445
17,790,038
8,348,979
TOTAL INTERNAL SERVICE FUND
571,654
2,322,899
2,073,407
821 '145
2,414,047
2,671 '149
564,043
TOTAL TRUST & AGENCY FUNDS
1,393,234
102,492
95,365
1,400,361
261,764
108,344
1,553,781
24,157,918
50,817,417
51,207,795
23,767,540
47,546,877
45,003,912
26,310,504
GRANDTOTALALLFUNDS
Page 1 of 2
CITY OF COLUMBUS, NEBRASKA CONDENSED BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2014
TOTAL GENERAL FUNDS
9/30/2012 BALANCE 6,070,573
-----ACTUAL AND ESTIMATED----RECEIPTS DISBURSEMENTS 13,983,536 13,784,846
PROJECTED 9/30/2013 BALANCE 6,269,263
------PROPOSED BUDGET-----RECEIPTS DISBURSEMENTS 15,399,440 15,167,941
PROJECTED 9/30/2014 BALANCE 6,500,762
TOTAL SPECIAL REVENUES
7,347,396
6,794,263
6,865,142
7,276,517
7,164,950
11,005,730
3,435,737
TOTAL CAPITAL PROJECTS
944,264
3,251,210
3,161,650
1,033,824
11,790,630
11,968,050
856,404
TOTAL DEBT SERVICE FUNDS
1,481,469
1,244,200
1,244,205
1,481,464
1,280,800
1,310,935
1,451,329
TOTAL ENTERPRISE FUNDS
8,348,979
12,198,803
11,734,765
8,813,017
17,708,450
18,580,008
7,941,459
TOTAL INTERNAL SERVICE FUND
564,043
2,766,000
2,379,000
951,043
2,770,000
2,770,000
951,043
TOTAL TRUST & AGENCY FUNDS
1,553,781
167,965
98,365
1,623,381
142,100
81' 100
1,684,381
26,310,504
40,405,977
39,267,973
27,448,508
56,256,370
60,883,764
22,821 '114
GRANDTOTALALLFUNDS
Page 2 of 2
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2014
General Fund General Administration Columbus Area Transit Senior Center City Admin Office Finance City Clerk Mayor/City Council Human Resources Police Animal Control Fire Rescue Volunteer Fire Department Library Literacy Cemetery Community Development Parks Pawnee Plunge Aquatic Center Pool Van Berg Quail Run Platte County Library Service Perpetual Care TOTAL GENERAL FUNDS
9/30/2010 BALANCE 5,423,401
---------------ACTUAL--------------RECEIPTS DISBURSEMENTS
9/30/2011 BALANCE 5,899,394
-------------ACTUAL------------RECEIPTS DISBURSEMENTS
9/30/2012 BALANCE 6,057,056
10,910,490 221 '186 124,737
84,796
940,731 213,391 232,540 192,144 271,395 266,170 64,902 100,641 3,977,421 185,970 522,237 826,571 64,132 930,128
87,132
1,406,440 245,028 210,839 191,715 270,855 285,898 54,174 102,519 3,979,305 171,679 659,380 1,081,768 52,936 907,467
-24,257 40,217
61,426 176,598 575,982 568,934 390,470 68,071 407,919 100,033 537
132,105 188,193 1,301,998 568,934 390,470 208,699 654,101 99,994 4,393
-24,218 36,362
56,140 172,888 542,894 463,743 807,586 72,708 472,106 91,734 7,155
191,671 182,202 2,329,632 463,743 807,586 225,890 652,892 97,336 180
-29,820 43,337
5,439,361
12,809,437
12,337,260
5,911,538
14,730,171
14,571,136
6,070,573
9,425,763 192,995 135,665
145,158 43,405 94,669 337,015
Page 1 of 6
142,217 52,378 143,585 361,491
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2014
Streets/Engineering Streets Engineering Airport Sales Tax E911 E911 Wireless Housing Rehab & Loans Housing Rehab & Loans New Neighborhoods Economic Development Reuse Progress and Jobs Growth Keno TOTAL SPECIAL REVENUES Capital Projects Community Redevl Auth Village Add Shopping Cntr HyVee Slumberland Ramada-Columbus TOTAL CAPITAL PROJECTS Debt Service Old Assessments Taxes/Interest 2005 GO Refunding Bonds Assessments Not Bonded Flood Control Bonds 2002 Various Purpose Refunding 2004 VPB/2009 GO Refunding Water Park Bonds 2008 Various Purpose Bonds 2011 Various Purpose Bonds 2012 Variuos Purpose Bonds TOTAL DEBT SERVICE FUNDS
9/30/2010 BALANCE 380,557
---------------ACTUAL--------------RECEIPTS DISBURSEMENTS
337,130 2,514,393 18,514 -2,469 5,279
2,794,460 100,679 558,671 2,059,082 178,500 54,945 196,396
2,374,153 367,835 1,021,684 1,045,750 173,845 21,614 179,830
266,934 744,824 615,666 4,880,828
171,955 312,605 418,051 6,845,346
-395,662 470,693
75,031
-------------ACTUAL------------RECEIPTS DISBURSEMENTS
9/30/2012 BALANCE 799,993
-125,883 3,527,726 23,169 30,861 21,845
3,043,235 91,852 1,457,689 1,512,310 182,765 63,100 72,502
2,407,108 461,694 975,433 802,332 176,975 9,483 72,311
356,373 4,237,705 28,959 84,477 22,036
163,138 151,623 358,000 5,857,473
275,751 905,806 675,717 5,868,701
605,294 352,899 449,785 7,831,431
630,498 407,789 409,112 6,352,736
250,547 850,916 716,389 7,347,396
4,485,100
4,444,220
(354,783) 505,990
2,516,874
1,657,821
504,271 439,993
416,655 67,067
390,492 44,028 13,905
418,475 353,793
389,535 448,047 682
4,968,822
4,892,645
3,289,142
2,496,085
151,208
214,947 295,525 1,956 620,423 50,206 74,482 536,804 87,508 89,768 1 ,971 ,619
199,000 336,693 1,956 620,423 52,250 125,410 1,454,349 43,583 268,445 1,177,015
944,264 1,481,469
1,177,015
2,307,504
2,307,504
9/30/2011 BALANCE 533,708
212,155
200,000
723 625,563
723 625,563
68,863
128,870
60,154 236,742 114,678 1,318,877
42,770 16,498 1,014,423
1,481,469
-----------
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2014 9/30/2010 BALANCE Utility Service Sanitary Sewer Wastewater Treatment Facility Sewer System Construction Water Water Superfund Project Loup Distribution Solid Waste Division Transfer Station Recycle Center TOTAL ENTERPRISE FUNDS
---------------ACTUAL--------------RECEIPTS DISBURSEMENTS
2,720,836
9,490,305
-------------ACTUAL------------RECEIPTS DISBURSEMENTS
1,702,566 11,788,956
5,005,121 360,578 2,855,847
4,922,215 369,204 2,650,000
1,491 ,371 210,771 21,796,804
1,315,355 101,241 22,849,537
2,322,899 2,322,899
2,073,407 2,073,407
5,488,836 5,601
3,193,335 2,322,763
7,459,384 433,613 2,976,791
7,370,238 461,378 3,023,068
8,437,572
1,387,932 -50,712 17,701,445
1,333,638 85,618 17,790,038
8,348,979
821,145 821,145
2,414,047 2,414,047
2,671,149 2,671,149
564,043 564,043
3,852,017
Health Insurance TOTAL INTERNAL SERVICE FUND
571,654 571,654
Police Pension Fire Pension Aviation Field Licenses to Schools Library Foundation Library Endowment Gerrard Park Trust TOTAL TRUST & AGENCY FUNDS
31,816 34,015 0 0 54,381 1,134,178 138,845 1,393,234
43,977 22,426
32,584 22,482
14,193 8,351 11,620 1,925 102,492
24,157,918
50,817,417
9/30/2012 BALANCE 1,080,769
1 '1 02,430 3,626,346 8,246,770
3,777,737
2,937,779 53,953
9/30/2011 BALANCE
3,143,626 339,499
3,913,398
3,097,349 257,463
32,531 22,475
23,389 22,482
14,193 5,058 15,433 5,614 95,365
43,209 33,959 0 0 57,673 1 '130,365 135,156 1,400,361
13,920 18,204 171,194 3,440 261,764
13,920 20,639 24,235 3,680 108,344
52,351 33,952 0 0 55,239 1,277,323 134,916 1,553,781
51,207,795
23,767,540
47,546,877
45,003,912
26,310,504
Page 3 of6
General Fund General Administration Columbus Area Transit Senior Center City Admin Office Finance City Clerk Mayor/City Council Human Resources Police Animal Control Fire Rescue Volunteer Fire Department Library Literacy Cemetery Community Development Parks Pawnee Plunge Aquatic Center Pool Van Berg Quail Run Platte County Library Service Perpetual Care TOTAL GENERAL FUNDS
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2014 PROJECTED -----ACTUAL AND ESTIMATED----9/30/2012 9/30/13 ------PROPOSED BUDGET-----BALANCE RECEIPTS DISBURSEMENTS BALANCE RECEIPTS DISBURSEMENTS 6,057,056 6,257,101 10,291,678 1,047,725 11,284,828 1,395,265 230,200 251,445 294,600 349,300 131,900 261,470 120,000 212,725 229,535 280,350 294,975 243,650 317,150 59,540 89,090 106,435 97,170 124,925 4,183,925 4,400,000 124,830 184,155 51,520 190,297 50,700 144,900 1,387,356 248,550 812,730 880,756 368,922 468,450 975,942 64,811 78,425 1,005,300 91,888 88,200 1,598,280
-29,820 43,337
67,000 190,750 637,060 483,800 456,138 76,440 533,300 102,715 400
121,285 197,150 1,340,880 483,800 456,138 274,900 630,438 104,470
6,070,573
13,983,536
13,784,846
Page 4 of 6
-31,575 43,737
62,000 194,850 688,100 526,475 642,500 77,567 542,570 104,620 600
162,510 213,375 1,635,350 526,475 642,500 242,032 692,102 111 ,580
6,269,263
15,399,440
15,167,941
PROJECTED 9/30/14 BALANCE 6,494,960
-38,535 44,337 0 6,500,762
Streets/Engineering Streets Engineering Airport Sales Tax E911 E911 Wireless Housing Rehab & Loans Housing Rehab & Loans New Neighborhoods Economic Development Reuse Progress and Jobs Growth Keno TOTAL SPECIAL REVENUES Capital Projects Community Redevl Auth Village Add Shopping Cntr HyVee Slumberland Ramada-Columbus TOTAL CAPITAL PROJECTS Debt Service Old Assessments Taxes/1 nterest 2005 GO Refunding Bonds Assessments Not Bonded Flood Control Bonds 2002 Various Purpose Refunding 2004 VPB/2009 GO Refunding Water Park Bonds 2008 Various Purpose Bonds 2011 Various Purpose Bonds 2012 Variuos Purpose Bonds TOTAL DEBT SERVICE FUNDS
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2014 PROJECTED 9/30/2012 -----ACTUAL AND ESTIMATED----9/30/13 ------PROPOSED BUDGET-----BALANCE RECEIPTS DISBURSEMENTS BALANCE RECEIPTS DISBURSEMENTS 894,568 799,993 3,075,800 2,573,675 3,225,100 2,718,375 93,450 501,000 113,750 538,500 191,216 723,600 888,757 391,100 329,380 356,373 4,237,705 1,507,218 1,904,030 3,840,893 256,365 3,265,670 168,600 158,650 38,909 162,500 188,885 28,959 110,447 84,477 91,900 65,930 80,700 232,820 22,036 -1,469 175,000 104,495 104,000 175,485 9,000 33,000 706,000 676,000 250,547 161,100 280,647 1,224,200 1,411,100 191,200 1,154,916 850,916 359,000 55,000 359,750 1,000,000 470,000 420,000 766,389 470,000 470,000 716,389 7,276,517 7,347,396 6,794,263 6,865,142 7,164,950 11,005,730 504,271 439,993
944,264
1,933,110
2,197,500
390,000 43,100 370,000 515,000 3,251,210
390,050 43,100 321,000 210,000 3,161,650
1,033,824
11,322,630
11,195,000
390,000 48,000 30,000
390,050 48,000 30,000 305,000 11,968,050
11,790,630
1,481,464
1,481,469
1,481,469
239,881 793,943
252,936 831,588 12,524 -41,673 29,016
93,747 514,666 766,389 3,435,737 367,511 488,893
856,404 1,451,329
196,500
200,000
196,500
200,000
670 619,030
670 619,030
630 625,670
630 625,670
57,000
126,995
16,000 230,000 125,000 1,244,200
41,960 141,750 113,800 1,244,205
50,000 50,000 14,000 26,500 317,500 1,280,800
129,710 50,000 45,960 140,515 118,450 1,310,935
1,481,464
PROJECTED 9/30/14 BALANCE 976,543
1,451,329
9/30/2012 BALANCE Utility Service Sanitary Sewer Wastewater Treatment Facility Sewer System Construction Water Water Superfund Project Loup Distribution Solid Waste Division Transfer Station Recycle Center TOTAL ENTERPRISE FUNDS
CITY OF COLUMBUS, NEBRASKA BUDGET SUMMARY WORKSHEET FOR THE BUDGET YEAR ENDED SEPTEMBER 30, 2014 PROJECTED -----ACTUAL AND ESTIMATED----9/30/13 ------PROPOSED BUDGET-----DISBURSEMENTS BALANCE RECEIPTS RECEIPTS DISBURSEMENTS 1,277,494
1,080,769 3,607,000 50,900
1,439,255 2,021,920
3,484,453 409,000 3,220,000
2,894,200 415,700 3,000,000
8,348,979
1,403,750 23,700 12,198,803
1,952,730 10,960 11,734,765
Health Insurance TOTAL INTERNAL SERVICE FUND
564,043 564,043
2,766,000 2,766,000
Police Pension Fire Pension Aviation Field Licenses to Schools Library Foundation Library Endowment Gerrard Park Trust TOTAL TRUST & AGENCY FUNDS
52,351 33,952 0 0 55,239 1,277,323 134,916 1,553,781 26,310,504
292,946 4,091,000
2,214,800 2,860,748
3,468,000 415,000 3,320,000
3,765,065 415,345 3,320,000
6,414,450
6,004,050
8,813,017
17,708,450
18,580,008
7,941,459
2,379,000 2,379,000
951,043 951,043
2,770,000 2,770,000
2,770,000 2,770,000
951,043 951,043
24,100 22,500
23,500 22,500
23,500 22,500
23,500 22,500
14,365 6,000 97,000 4,000 167,965
14,365 24,000 10,000 4,000 98,365
52,951 33,952 0 0 37,239 1,364,323 134,916 1,623,381
14,600 5,500 72,000 4,000 142,100
14,600 6,500 10,000 4,000 81 '1 00
52,951 33,952 0 0 36,239 1,426,323 134,916 1,684,381
40,405,977
39,267,973
27,448,508
56,256,370
60,883,764
22,821,114
3,913,398
3,097,349 257,463
PROJECTED 9/30/14 BALANCE
4,496,951
Page 6 of6
3,317,349 -278,777
4,199,541
3,317,349 131,623