ANNUAL BUDGET FISCAL YEAR 2019-2020
celina-tx.gov
City of Celina Table of Contents Truth-In-Taxation Statement .............................................................................................................................. 1 All Funds Summary.............................................................................................................................................. 2 Governmental Funds General Fund General Fund – Revenue & Expenditure Summary ....................................................................................... 5 General Fund – Revenues .......................................................................................................................... 7 General Fund – Expenditures ..................................................................................................................... 8 General Fund Departments GIS Department .................................................................................................................................... 11 Facilities Department ............................................................................................................................ 12 IT Department ....................................................................................................................................... 13 Finance Department ............................................................................................................................. 14 Library Department............................................................................................................................... 15 City Secretary Department ................................................................................................................... 16 Development Services Department ...................................................................................................... 17 Administration Department.................................................................................................................. 18 Municipal Court Department ................................................................................................................ 19 Fire & EMS Department ........................................................................................................................ 20 Street Department ................................................................................................................................ 21 Police Department ................................................................................................................................ 22 Parks & Recreation Department ........................................................................................................... 23 Community Relations Department ....................................................................................................... 24 Engineering Department....................................................................................................................... 25 Human Resources Department............................................................................................................. 26 Special Revenue Funds Special Revenue Funds – Revenue & Expenditure Summary...................................................................... 27 Parks Fee Fund - Revenue & Expenditure Summary................................................................................ 28 Main Street Fund - Revenue & Expenditure Summary ............................................................................ 29 Vehicle & Equipment Replacement Fund (VERF) – Summary.................................................................. 30 Court Security Fund - Revenue & Expenditure Summary ........................................................................ 31 Court Technology Fund - Revenue & Expenditure Summary .................................................................. 32 Capital Acquisition Fund - Revenue & Expenditure Summary ................................................................. 33 Road Impact Fee Fund – Revenue & Expenditure Summary ................................................................... 34 Road Capital Recovery Fee Fund - Revenue & Expenditure Summary .................................................... 35 Technology Fund - Revenue & Expenditure Summary ............................................................................ 36 Integrity Fund - Revenue & Expenditure Summary ................................................................................. 37 Debt Service Funds Debt Service Fund – Revenue & Expenditure Summary ............................................................................. 38 Proprietary Funds Proprietary Funds – Revenue & Expense Summary ....................................................................................... 40 Water-Wastewater Fund Water-Wastewater Fund – Revenue & Expense Summary......................................................................... 41 Water-Wastewater Fund – Revenues ...................................................................................................... 43 Water-Wastewater Fund – Expenses ....................................................................................................... 44 Water-Wastewater Fund Departments Non-Departmental ................................................................................................................................ 47 Water Distribution Department ........................................................................................................... 48
City of Celina Table of Contents Wastewater Collection Department ..................................................................................................... 49 Utility Billing Department ..................................................................................................................... 50 Trash & Recycling Department ............................................................................................................. 51 Debt Service .......................................................................................................................................... 52 Drainage Fund – Revenue & Expense Summary............................................................................................. 53 Utility Impact Fee Fund – Revenue & Expense Summary .............................................................................. 54 Water Capital Recovery Fee Fund – Revenue & Expense Summary .............................................................. 55 Wastewater Capital Recovery Fee Fund – Revenue & Expense Summary..................................................... 56 Bond Funds Capital Improvement Program Summary ....................................................................................................... 57 Bond Funds – Revenue & Expenditure Summary ........................................................................................... 60 2012 Bond Fund – Revenue & Expenditure Summary ................................................................................ 61 2014 Bond Fund – Revenue & Expenditure Summary ................................................................................ 62 2015 Bond Fund – Revenue & Expenditure Summary ................................................................................ 63 2016 Bond Fund – Revenue & Expenditure Summary ................................................................................ 64 2017 Bond Fund – Revenue & Expenditure Summary ................................................................................ 65 2018 Bond Fund – Revenue & Expenditure Summary ................................................................................ 66 2019 Bond Fund – Revenue & Expenditure Summary ................................................................................ 67 Economic Development Funds Economic Development Corporation – Rev & Expenditure Summary ........................................................... 68 Community Development Corporation – Rev & Expenditure Summary ........................................................ 70
City of Celina Fiscal Year 2019-2020 Budget Cover Page This budget will raise more revenue from property taxes than last year's budget by an amount of $401,672, which is a 4.09 percent increase from last year's budget. The property tax revenue to be raised from new property added to the tax roll this year is $1,451,323. The members of the governing body voted on the budget as follows: FOR:
Justin Steiner, Wayne Nabors, Andy Hopkins, Carmen Roberts, Mindy Koehne, Chad Anderson
AGAINST: PRESENT and not voting: Mayor Sean Terry ABSENT:
Property Tax Rate Comparison Property Tax Rate: Effective Tax Rate: Effective Maintenance & Operations Tax Rate: Rollback Tax Rate: Debt Rate:
2019-2020 $0.645000/100 $0.633998/100 $0.378862/100 $0.600487/100 $0.191317/100
2018-2019 $0.645000/100 $0.623353/100 $0.407236/100 $0.699398/100 $0.259584/100
Total debt obligation for City of Celina secured by property taxes: $43,935,000
2 14,677,751 $ 4,317,280 $ 4,913,081 9,230,361
Revenue Over/(Under) Expenditur $
Beginning Fund Balance Ending Fund Balance
Total Total Expenditures
$
8,430,516 1,240,538 439,520 555,279 433,183 920,794 2,113,923 543,998 -
18,995,031 $
$
Total Revenues
Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities UTRWD Delivery & Collection Cost Miscellaneous Capital Transfers Debt Service
9,723,723 $ 6,482,423 77,695 264,387 1,142,012 1,304,791
9,230,361 10,313,792
1,083,431 $
19,483,808 $
12,300,490 1,226,430 498,770 579,053 433,018 1,573,412 2,872,635 -
20,567,240 $
10,693,644 $ 7,130,514 1,025,187 40,600 409,350 504,945 763,000
Governmental Funds Estimated 2018-2019
$
Actual 2017-2018
Fines & Fees Taxes Charges for Servcies Grants Contributions & Donations Interest Income Other Revenues Transfers
City of Celina All Fund Summary
10,313,792 10,478,350
164,557 $
21,456,373 $
13,816,925 1,397,589 612,588 371,213 497,200 1,576,502 2,782,019 402,337 -
21,620,930 $
9,415,883 $ 8,764,938 1,076,384 66,549 359,300 580,600 1,357,276
Adopted 2019-2020
1,369,342 1,813,530
444,188 $
2,344,126 $
2,344,126
2,788,314 $
1,813,530 2,420,740
607,210 $
3,737,204 $
3,737,204
4,344,414 $
- $ 4,059,414 85,000 200,000
Debt Service Funds Estimated 2018-2019
- $ 2,555,174 33,140 200,000
Actual 2017-2018
2,420,740 1,875,835
(544,905)
5,130,921
5,130,921
4,586,016
3,448,479 40,000 1,097,537
Adopted 2019-2020
3 2,800,630 $
Revenue Over/(Under) Expenditur $
Beginning Fund Balance Ending Fund Balance
9,009,427 11,810,057
12,703,352 $
Total Total Expenditures
$
1,143,915 922,665 892,742 330,057 259,099 2,800,093 1,763,594 430,617 746,734 3,413,836
15,503,982 $
$
Total Revenues
Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities UTRWD Delivery & Collection Cost Miscellaneous Capital Transfers Debt Service
4,538,923 $ 10,202,125 208,579 554,355 -
11,810,057 11,997,406
187,349 $
16,219,001 $
1,451,148 1,102,993 895,876 304,102 248,830 3,966,573 1,520,864 1,200,797 838,754 4,689,064
16,406,350 $
5,044,350 $ 10,590,000 390,000 382,000 -
Proprietary Funds Estimated 2018-2019
$
Actual 2017-2018
Fines & Fees Taxes Charges for Servcies Grants Contributions & Donations Interest Income Other Revenues Transfers
City of Celina All Fund Summary
11,997,406 12,697,569
700,164 $
19,976,861 $
1,746,512 1,292,034 832,890 277,500 275,000 4,494,817 342,835 486,027 3,728,127 6,501,119
20,677,025 $
5,273,756 11,595,000 364,000 564,269 2,880,000
Adopted 2019-2020
102,027,831 90,698,263
(11,329,568) $
90,698,263 51,106,858
(39,591,405) $
40,585,405 $
-
11,524,347 $
40,585,405
994,000 $
994,000 -
Bond Funds Estimated 2018-2019
11,524,347
194,779 $
194,779 -
Actual 2017-2018
51,106,858 17,448,500
(33,658,358)
34,282,358
-
34,282,358
624,000
624,000 -
Adopted 2019-2020
4
Beginning Fund Balance Ending Fund Balance
822,461 1,388,212
565,751 $
Total Total Expenditures
Revenue Over/(Under) Expenditur $
333,374 5,162 2,275 1,833 3,674 46,629 200,000 -
1,158,698 $
1,388,212 1,900,621
512,409 $
777,191 $
212,620 17,000 8,000 1,500 3,194 94,877 360,000 80,000
1,289,600 $
1,245,000 30,600 14,000 -
EDC & CDC Funds Estimated 2018-2019
592,947 $
$
1,146,290 12,408 -
Actual 2017-2018
$
Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities UTRWD Delivery & Collection Cost Miscellaneous Capital Transfers Debt Service
Total Revenues
Fines & Fees Taxes Charges for Servcies Grants Contributions & Donations Interest Income Other Revenues Transfers
City of Celina All Fund Summary
1,900,621 1,608,787
(291,834) $
1,705,734 $
218,398 22,000 5,000 1,500 134,487 1,204,349 120,000
1,413,900 $
- $ 1,369,500 15,000 15,000 14,400 -
Adopted 2019-2020
118,142,142 114,940,423
(3,201,719) $
41,842,523 $
9,907,805 2,168,365 1,334,537 887,169 695,956 2,800,093 2,731,017 14,068,887 1,490,732 5,757,962
38,640,804 $
14,262,646 $ 10,183,887 10,202,125 77,695 713,293 1,696,367 1,504,791
Actual 2017-2018
114,940,423 77,739,417
(37,201,006) $
80,802,609 $
13,964,258 2,346,423 1,402,646 884,655 685,042 3,966,573 3,189,153 44,658,837 1,198,754 8,506,268
43,601,604 $
15,737,994 $ 12,434,928 10,590,000 1,025,187 40,600 1,908,950 900,945 963,000
Total Funds Estimated 2018-2019
77,739,417 44,109,041
(33,630,376)
82,552,248
15,781,835 2,711,623 1,450,478 648,713 773,700 4,494,817 2,053,824 37,550,404 5,334,813 11,752,040
48,921,871
14,689,639 13,582,917 11,595,000 1,091,384 66,549 1,402,300 1,159,269 5,334,813
Adopted 2019-2020
Governmental Funds
City of Celina General Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Fines & Fees Taxes Grants Contributions & Donations Interest Income Other Revenues Transfers
$
Total Revenues Expenditures GIS Facilities Management Information Technology Finance Library City Secretary Planning & Development Services Administration Municipal Court Fire & EMS Streets Police Parks Commnity Relations Engineering Human Resources Total Expenditures
7,194,151 $ 6,482,423 77,695 142,170 411,987 527,000
Amended Budget 2018-2019 6,619,950 $ 6,968,280 1,100,529 61,730 165,000 330,450 763,000
Estimated 2018-2019 7,074,600 $ 7,130,514 1,025,187 40,600 250,000 316,745 763,000
Adopted 2019-2020 7,005,183 8,764,938 1,076,384 66,549 245,000 333,600 719,812
14,835,426
16,008,939
16,600,646
18,211,466
82,745 87,131 137,976 230,091 403,576 1,729,041 1,301,773 172,610 2,531,486 1,138,644 2,583,781 862,479 270,913 821,399 -
131,281 392,754 601,915 900,297 275,150 221,945 2,048,345 1,036,359 234,851 4,685,424 1,270,769 3,265,614 1,053,734 390,728 1,111,301 274,835
125,625 338,832 534,262 857,237 252,175 157,753 1,908,377 1,008,364 179,379 4,139,019 948,007 3,091,499 981,516 380,595 1,092,280 251,839
138,088 329,799 670,088 951,816 272,884 156,493 2,035,264 1,202,868 185,817 4,700,974 1,211,278 3,368,396 1,220,286 280,939 1,173,634 265,354
12,353,645
17,895,302
16,246,759
18,163,978
Revenue Over/(Under) Expenditures
$
2,481,781 $
(1,886,363) $
353,886 $
47,488
Beginning Fund Balance Ending Fund Balance
$ $
277,073 $ 2,758,854 $
2,758,854 $ 872,491 $
2,758,854 $ 3,112,740 $
3,112,740 3,160,228
Fund Balance Policy 25%
37%
5
15%
30%
27%
City of Celina General Fund - Revenue & Expenditure Summary Revenue & Expenditure Summary 20,000,000 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 -
Actual 2017-2018
Amended Budget 2018-2019 Total Revenues
Estimated 2018-2019
Adopted 2019-2020
Total Expenditures
Fund Balance 20,000,000
$3,160,228
$3,112,740
18,000,000
$3,200,000 $3,100,000
16,000,000 14,000,000
$3,000,000
12,000,000
$2,900,000
10,000,000 8,000,000
$2,758,854
$2,800,000
6,000,000
$2,700,000
4,000,000 2,000,000 -
$2,600,000 $12,353,645
$16,246,759
$18,163,978
Actual 2017-2018
Estimated 2018-2019
Adopted 2019-2020
Total Expenditures
6
Ending Fund Balance
$2,500,000
City of Celina General Fund - Revenues Amended Budget 2018-2019
Actual 2017-2018 Revenues Fines & Fees Taxes Grants Contributions & Donations Interest Income Other Revenues Transfers
$
7,194,151 $ 6,482,423 77,695 142,170 411,987 527,000
6,619,950 $ 6,968,280 1,100,529 61,730 165,000 330,450 763,000
Estimated 2018-2019 7,074,600 $ 7,130,514 1,025,187 40,600 250,000 316,745 763,000
Adopted 2019-2020 7,005,183 8,764,938 1,076,384 66,549 245,000 333,600 719,812
$ 14,835,426 $ 16,008,939 $ 16,600,646 $ 18,211,466
Total General Fund Revenues
General Fund Revenues $20,000,000 $15,000,000 $10,000,000 $5,000,000 $-
Fines & Fees
Contributions & Donations 0%
Actual 2017-2018 Taxes
Grants
Amended Budget 2018-2019 Contributions & Donations
Other Revenues Interest Income 2% 1%
Estimated 2018-2019 Interest Income
Adopted 2019-2020 Other Revenues
Transfers
Other Revenues
Transfers
Revenues Transfers 4%
Grants 6%
Fines & Fees 39% Taxes 48%
Fines & Fees
Taxes
Grants
Contributions & Donations
7
Interest Income
City of Celina General Fund - Expenditures Amended Budget 2018-2019
Actual 2017-2018 Expenditures GIS Facilities Management Information Technology Finance Library City Secretary Planning & Development Services Administration Municipal Court Fire & EMS Streets Police Parks Commnity Relations Engineering Human Resources Total General Fund Expenditures
$
82,745 $ 87,131 137,976 230,091 403,576 1,729,041 1,301,773 172,610 2,531,486 1,138,644 2,583,781 862,479 270,913 821,399 -
Estimated 2018-2019
131,281 $ 392,754 601,915 900,297 275,150 221,945 2,048,345 1,036,359 234,851 4,685,424 1,270,769 3,265,614 1,053,734 390,728 1,111,301 274,835
Adopted 2019-2020
125,625 $ 338,832 534,262 857,237 252,175 157,753 1,908,377 1,008,364 179,379 4,139,019 948,007 3,091,499 981,516 380,595 1,092,280 251,839
$ 12,353,645 $ 17,895,302 $ 16,246,759 $ 18,163,978
Expenditures $20,000,000 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $-
Actual 2017-2018
GIS Finance Planning & Development Services Fire & EMS Parks Human Resources
138,088 329,799 670,088 951,816 272,884 156,493 2,035,264 1,202,868 185,817 4,700,974 1,211,278 3,368,396 1,220,286 280,939 1,173,634 265,354
Amended Budget 2018-2019 Facilities Management Library Administration Streets Commnity Relations
8
Estimated 2018-2019
Adopted 2019-2020 Information Technology City Secretary Municipal Court Police Engineering
City of Celina General Fund - Expenditures Actual 2017-2018 Expenditures Fire & EMS Police Planning & Development Services Parks Streets Engineering Finance Administration Information Technology Facilities Management Commnity Relations Library Human Resources Municipal Court City Secretary GIS
20.49% 20.92% 14.00% 6.98% 9.22% 6.65% 0.00% 10.54% 1.12% 0.71% 2.19% 1.86% 0.00% 1.40% 3.27% 0.67% 100.00%
Expenditures
Human Resources 1% Commnity Relations 2% Parks
Amended Budget 2018-2019
Engineering 6%
Facilities Management GIS 2% 1%
7%
Police 19%
Estimated 2018-2019
26.18% 18.25% 11.45% 5.89% 7.10% 6.21% 5.03% 5.79% 3.36% 2.19% 2.18% 1.54% 1.54% 1.31% 1.24% 0.73% 100.00%
25.48% 19.03% 11.75% 6.04% 5.84% 6.72% 5.28% 6.21% 3.29% 2.09% 2.34% 1.55% 1.55% 1.10% 0.97% 0.77% 100.00%
GIS Finance Planning & Development Services Fire & EMS Parks
Fire & EMS 26%
Facilities Management Library Administration Streets Commnity Relations
9
25.88% 18.54% 11.20% 6.72% 6.67% 6.46% 5.24% 6.62% 3.69% 1.82% 1.55% 1.50% 1.46% 1.02% 0.86% 0.76% 100.00%
Information Technology 4%
Finance 5%
Library 2% City Secretary 1%
Administration 7% Streets 7%
Adopted 2019-2020
Planning & Development Services 11%
Municipal Court 1%
Information Technology City Secretary Municipal Court Police Engineering
City of Celina General Fund - Expenditures
Actual 2017-2018 Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Transfer Capital Total General Fund Expenditures
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
$
8,428,706 $ 12,643,337 $ 12,296,905 $ 13,811,325 1,240,538 1,535,093 1,221,430 1,392,589 437,860 602,689 465,379 555,588 554,675 728,372 578,838 370,998 430,864 443,542 430,318 494,500 695,395 1,283,362 1,210,138 1,107,502 543,998 585,156 402,337 21,609 73,751 43,751 29,139 $ 12,353,645 $ 17,895,302 $ 16,246,759 $ 18,163,978
Expenditures Miscellaneous Maintenance Materials & Supplies
Utilities
Transfer
Capital
Legal & Professional Services
Personnel
Personnel Maintenance Transfer
Legal & Professional Services Utilities Capital
10
Materials & Supplies Miscellaneous
City of Celina General Fund - GIS Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total GIS Department
Estimated 2018-2019
Adopted 2019-2020
$
57,421 $ 6,575 18,749 -
93,081 $ 30,300 5,000 2,900 -
94,775 $ 25,270 5,550 30 -
107,763 24,775 5,550 -
$
82,745 $
131,281 $
125,625 $
138,088
Personnel GIS Manager
1
1
1
1
Total Personnel
1
1
1
1
GIS Department $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
11
City of Celina General Fund - Facilities Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Facilities Department
Estimated 2018-2019
Adopted 2019-2020
$
50,894 $ 238 35,744 51 204 -
80,479 $ 125,400 21,000 3,500 116,375 46,000
83,302 $ 125,400 11,000 3,500 99,630 16,000
85,465 114,651 10,000 3,500 114,000 2,183 -
$
87,131 $
392,754 $
338,832 $
329,799
Personnel Facilities Maintenance Supervisor
1
1
1
1
Total Personnel
1
1
1
1
Facilities Department $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
12
City of Celina General Fund - IT Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total IT Department
Estimated 2018-2019
Adopted 2019-2020
$
67,105 $ 11,860 58,413 410 188 -
314,505 $ 10,000 14,000 260,000 3,160 250 -
318,260 $ 10,052 200,000 5,700 250 -
193,391 7,500 207,500 242,000 19,697 -
$
137,976 $
601,915 $
534,262 $
670,088
Personnel CTO IT Manager IT Helpdesk Technician
0 1 0
1 1 0
0 1 1
0 1 1
Total Personnel
1
2
2
2
IT Department $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
13
City of Celina General Fund - Finance Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Finance Department
Estimated 2018-2019
Adopted 2019-2020
$
-
$
563,340 $ 44,500 19,569 4,500 268,388 -
551,698 $ 44,500 15,500 4,500 241,039 -
806,603 53,750 17,400 281,204 -
$
-
$
900,297 $
857,237 $
1,158,957
Personnel Finance Director Accounting Manager Senior Accountant Payroll & Benefit Accountant Accounting Technician Purchasing Manager
1 1 0 0 1 0
1 1 1 1 2 1
1 1 1 1 2 1
1 0 1 1 2 1
Total Personnel
3
7
7
6
Finance Department $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
14
City of Celina General Fund - Library Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Library Department
Estimated 2018-2019
Adopted 2019-2020
$
179,758 $ 3,038 9,495 4,392 8,785 3,014 21,609
228,203 $ 9,070 5,676 4,450 27,751
210,224 $ 5,350 5,100 3,750 27,751
237,545 2,450 3,750 29,139
$
230,091 $
275,150 $
252,175 $
272,884
Personnel Director of Library Youth Librarian Part Time Library Assistant
1 1 3
1 1 3
1 1 3
1 1 3
Total Personnel
5
5
5
5
Library Department $250,000 $200,000 $150,000 $100,000 $50,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
15
City of Celina General Fund - City Secretary Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures
Estimated 2018-2019
Adopted 2019-2020
Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital
$
306,733 $ 38,349 14,613 12,346 7,727 23,808 -
170,045 $ 7,200 10,250 6,150 28,300 -
121,146 $ 7,200 1,650 5,779 21,978 -
127,993 7,200 1,500 19,800 -
Total City Secretary Department
$
403,576 $
221,945 $
157,753 $
156,493
Personnel City Secretary Assistant City Secretary Human Resources Director Human Resources Generalist
1 1 1 1
1 1 0 0
1 1 0 0
1 1 0 0
Total Personnel
4
2
2
2
City Secretary Department $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
16
City of Celina General Fund - Development Services Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Development Services Department
Estimated 2018-2019
Adopted 2019-2020
$
1,145,362 $ 348,990 58,460 40,307 34,900 101,022 -
1,551,845 $ 270,000 48,700 26,000 35,500 116,300 -
1,536,673 $ 124,950 43,700 26,500 32,554 144,000 -
1,739,161 112,000 14,000 23,000 147,103 -
$
1,729,041 $
2,048,345 $
1,908,377 $
2,035,264
Personnel Director of Development Services Development Coordinator Planning Manager Planner Plans Examiner Planning Technician Community Servcies Manager Permit Technician Code/Health Inspector Chief Building Inspector Building Official Building Inpsector Total Personnel
1 1 1 1 1 1 1 2 1 1 1 4
1 1 1 1 1 1 1 2 1 1 1 7
1 1 1 1 1 1 1 2 1 1 1 7
1 1 1 1 1 1 1 2 1 1 1 7
16
19
19
19
Development Services Department $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
17
City of Celina General Fund - Administration Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Administration Department
Estimated 2018-2019
Adopted 2019-2020
$
769,352 $ 251,759 20,825 20,602 30,930 208,305 -
661,232 $ 185,000 20,200 5,000 22,200 142,727 -
630,338 $ 205,000 9,000 1,746 21,880 140,400 -
692,057 185,000 6,000 1,500 111,170 -
$
1,301,773 $
1,036,359 $
1,008,364 $
995,727
Personnel City Manager Assistant City Manager - Chief Financial Officer Director of Administration Director of Government Affairs Finance Director Accounting Manager Accounting Technician Assistant to City Manager Management Assistant
1 0 0 0 1 1 1 0 0
1 0 1 1 0 0 0 1 1
1 0 1 1 0 0 0 1 1
1 1 1 1 0 0 0 1 1
Total Personnel
4
5
5
6
Administration Department $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
18
City of Celina General Fund - Municipal Court Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Municipal Court Department
Estimated 2018-2019
Adopted 2019-2020
$
124,465 $ 26,950 5,138 4,934 7,199 3,924 -
151,440 $ 35,280 35,250 4,031 8,850 -
128,319 $ 35,280 4,000 3,430 8,350 -
139,687 35,280 4,000 6,850 -
$
172,610 $
234,851 $
179,379 $
185,817
Personnel Court Administrator Court Clerk
1 1
1 2
1 2
1 2
Total Personnel
2
3
3
3
Municipal Court Department $160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
19
City of Celina General Fund - Fire & EMS Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures
Estimated 2018-2019
Adopted 2019-2020
Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital
$
2,026,001 $ 58,970 88,830 154,692 61,550 141,443 -
4,026,133 $ 54,000 131,150 145,500 41,500 287,141 -
3,663,176 $ 49,000 113,300 130,600 48,700 134,243 -
4,261,600 43,000 79,043 127,796 189,534 -
Total Fire & EMS Department
$
2,531,486 $
4,685,424 $
4,139,019 $
4,700,974
Personnel Fire Chief Assistant Fire Chief EMS Division Chief Captain Driver Paramedic
1 1 1 4 0 17
1 1 1 4 0 35
1 1 1 4 0 34
1 1 1 7 6 24
Total Personnel
24
42
41
40
Fire & EMS Department $4,500,000 $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
20
City of Celina General Fund - Street Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Street Department
Estimated 2018-2019
Adopted 2019-2020
$
481,942 $ 225,805 44,158 93,687 178,387 114,665 -
523,157 $ 375,100 44,500 49,000 155,600 123,412 -
515,250 $ 195,100 44,500 44,175 141,950 7,032 -
507,103 442,781 33,000 41,500 138,500 48,394 -
$
1,138,644 $
1,270,769 $
948,007 $
1,211,278
Personnel Director of Public Works Administrative Assistant Street Superintendent Crew Leader Equipment Operator
1 1 1 2 2
1 1 1 2 2
1 1 1 2 2
1 1 1 2 2
Total Personnel
7
7
7
7
Street Department $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
21
City of Celina General Fund - Police Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Police Department
Estimated 2018-2019
Adopted 2019-2020
$
1,996,958 $ 98,613 68,384 111,342 38,036 270,448 -
2,525,255 $ 101,613 102,000 141,332 25,150 370,264 -
2,661,852 $ 112,500 76,385 102,027 35,451 103,284 -
2,875,494 134,427 52,020 99,352 207,103 -
$
2,583,781 $
3,265,614 $
3,091,499 $
3,368,396
Personnel Police Chief Assistant Police Chief Public Safety Officer Lieutenant Sergeant Patrol Officer
1 1 1 1 4 13
1 1 1 1 4 19
1 1 1 1 4 19
1 1 1 1 5 19
Total Personnel
21
27
27
28
Police Department $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
22
City of Celina General Fund - Parks Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Parks Department
Estimated 2018-2019
Adopted 2019-2020
$
422,864 $ 85,324 60,001 33,303 25,689 235,298 -
569,234 $ 120,000 88,950 60,000 5,000 210,550 -
576,999 $ 120,000 87,250 36,000 5,064 156,203 -
662,712 120,000 85,250 40,000 312,324 -
$
862,479 $
1,053,734 $
981,516 $
1,220,286
Personnel Parks Director Assistatnt Parks Director Special Events Coordinator Crew Leader Chemical Technician Irrigation Technician Maintenance Worker
1 1 0 1 1 1 3
1 1 0 1 1 1 3
1 1 1 1 1 1 3
1 1 1 1 1 1 3
Total Personnel
8
8
9
9
Parks Department $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
23
City of Celina General Fund - Community Relations Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Community Relations Department
Estimated 2018-2019
Adopted 2019-2020
$
165,775 $ 910 323 295 103,610 -
179,278 $ 3,750 1,550 206,150 -
180,398 $ 2,772 3,400 194,025 -
189,139 9,150 82,650 -
$
270,913 $
390,728 $
380,595 $
280,939
Personnel Downtown Development Manager Community Relations Manager
1 1
1 1
1 1
1 1
Total Personnel
2
2
2
2
Community Relations Department $250,000 $200,000 $150,000 $100,000 $50,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
24
City of Celina General Fund - Engineering Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures
Estimated 2018-2019
Adopted 2019-2020
Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital
$
634,076 $ 102,502 12,867 20,283 18,003 33,668 -
807,369 $ 207,000 12,000 32,040 13,820 39,072 -
822,000 $ 202,500 8,200 28,740 13,820 17,020 -
975,857 137,000 4,000 28,800 27,977 -
Total Engineering Department
$
821,399 $
1,111,301 $
1,092,280 $
1,173,634
Personnel Director of Engineering Assistant Director of Engineering Civil Engineer Engineer In Training Construction Manager Construction Inspector Management Analyst
1 1 1 1 1 2 0
1 1 1 1 1 2 0
1 1 1 1 1 3 0
1 1 1 1 1 4 1
Total Personnel
7
7
8
10
Engineering Department $1,000,000 $800,000 $600,000 $400,000 $200,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
25
City of Celina General Fund - Human Resources Department Amended Budget 2018-2019
Actual 2017-2018
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Total Human Resources Department
Estimated 2018-2019
Adopted 2019-2020
$
-
$
198,741 $ 12,000 1,000 3,330 59,764 -
202,495 $ 7,450 3,330 38,564 -
209,754 5,500 50,100 -
$
-
$
274,835 $
251,839 $
265,354
Personnel Human Resources Director Human Resources Generalist
0 0
1 1
1 1
1 1
Total Personnel
0
2
2
2
Human Resources Department $250,000 $200,000 $150,000 $100,000 $50,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
26
City of Celina Special Revenue Funds - Revenue & Expenditure Summary Actual 2017-2018 Revenues Fines & Fees Interest Income Other Revenue Transfers
$
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
2,529,572 $ 122,217 730,025 777,791
1,582,500 $ 83,650 155,000 820,892
3,619,044 $ 159,350 188,200 -
2,410,700 114,300 247,000 637,464
Total Revenues
4,159,605
2,642,042
3,966,594
3,409,464
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Expense Capital Transfers Debt Service
1,810 1,660 604 2,319 225,399 2,092,314 -
3,585 1,750 215 2,700 83,900 1,872,235 -
3,585 5,000 33,391 215 2,700 363,274 2,828,884 -
5,600 5,000 57,000 215 2,700 469,000 2,752,880 -
Total Expenditures
2,324,106
1,964,385
3,237,049
3,292,395
Revenue Over/(Under) Expenditures
$
1,835,499 $
677,657 $
729,545 $
117,069
Beginning Fund Balance Ending Fund Balance
$ $
4,636,008 $ 6,471,507 $
6,471,507 $ 7,149,164 $
6,471,507 $ 7,201,052 $
7,201,052 7,318,121
27
City of Celina Park Fees Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Park Fees Interest Income Wells North Revenue Recognition Ownsby Revenue Recognition
$
Total Revenues
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
1,441,125 $ 62,078 -
1,000,000 $ 50,000 -
1,202,500 $ 80,000 780,875 249,969
1,050,000 50,000 -
1,503,203
1,050,000
2,313,344
1,100,000
250,000 15,000 20,500 30,000 30,000 500,000
1,600,000 -
Expenditures Old Celina Park Bobcat Trail Wilson Creek Park NE Regional Park 1 Park Master Plan Traditions Trail Capital Transfer (Debt Service Fund)
886,533 -
-
Total Expenditures
886,533
-
-
845,500
1,600,000
Revenue Over/(Under) Expenditures
$
616,670 $
1,050,000 $
1,467,844 $
(500,000)
Beginning Fund Balance Ending Fund Balance
$ $
367,177 $ 983,847 $
983,847 $ 2,033,847 $
983,847 $ 2,451,691 $
2,451,691 1,951,691
28
City of Celina Main Street Fund - Revenue & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Contributions & Donations Grants Interest Income Transfers
$
Estimated 2018-2019
Adopted 2019-2020
67,000 $ 150 -
67,000 $ 150 -
67,000 $ 150 -
97,000 30,000 150 -
Total Revenues
67,150
67,150
67,150
127,150
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital
1,810 1,660 604 2,319 52,892 -
3,585 1,750 215 2,700 83,900 -
3,585 1,750 215 2,700 58,900 -
5,600 2,000 215 2,700 94,000 -
Total Expenditures
59,285
92,150
67,150
104,515
Revenue Over/(Under) Expenditures
$
7,865 $
(25,000) $
-
$
22,635
Beginning Fund Balance Ending Fund Balance
$ $
23,646 $ 31,511 $
31,511 $ 6,511 $
31,511 $ 31,511 $
31,511 54,146
Revenue & Expenditure Summary 140,000 120,000 100,000 80,000 60,000 40,000 20,000 -
Actual 2017-2018
Amended Budget 2018-2019 Total Revenues
29
Estimated 2018-2019 Total Expenditures
Adopted 2019-2020
City of Celina Vehicle & Equipment Replacement Fund - Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Interest Income Other Revenue Transfer General fund Transfer Water Fund
$
15,573 $ 663,025 543,997 233,794 1,456,389
Total Revenues Expenditures IT Server Streets Trailer Ford F150 EC Police 3 Tahoe Interceptor Parks Top Dresser Vac & Verticutter 7 Gang 7 Gang Pull Behind Reel Mower Toro Workman Sand Pro 3/4 Ton Irrigation Truck Water Dump Truck 3/4 Ton Truck Truck Wastewater Backhoe 1/2 Ton Truck Pipehunter Jetter
-
Adopted 2019-2020
8,500 $ 585,156 235,736
29,000 $ -
15,000 402,337 235,127
829,392
29,000
652,464
-
-
7,425
27,124 -
35,000
35,000
54,678
217,500 72,500
217,500 72,500
28,000 40,000 5,000 45,000 -
28,000 40,000 5,000 45,000 -
38,000 51,000 22,000 20,000 45,000
55,000 -
55,000 -
22,000
125,000 30,000 125,000
125,000 30,000 125,000
778,000
778,000
115,883 197,685
Total Expenditures
Estimated 2018-2019
35,000 -
240,425
Revenue Over/(Under) Expenditures
$
1,258,704 $
51,392 $
(749,000) $
412,039
Beginning Fund Balance Ending Fund Balance
$ $
810,925 $ 2,069,629 $
2,069,629 $ 2,121,021 $
2,069,629 $ 1,320,629 $
1,320,629 1,732,668
30
City of Celina Court Security Fund - Revenue & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Fines & Fees Interest Income
$
Total Revenues
Estimated 2018-2019
2,829 $ -
-
2,829
-
$
Adopted 2019-2020
2,500 $ -
2,500 -
2,500
2,500
Expenditures Miscellaneous Expenses
-
-
-
-
Total Expenditures
-
-
-
-
Revenue Over/(Under) Expenditures
$
2,829 $
-
$
2,500 $
2,500
Beginning Fund Balance Ending Fund Balance
$ $
59,404 $ 62,233 $
62,233 $ 62,233 $
62,233 $ 64,733 $
64,733 67,233
31
City of Celina Court Technology Fund - Revenue & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Fines & Fees Interest Income
$
Total Revenues
Estimated 2018-2019
Adopted 2019-2020
3,775 $ -
2,500 $ -
3,200 $ -
3,200 100
3,775
2,500
3,200
3,300
Expenditures Materials & Supplies
-
-
16,585
27,500
Total Expenditures
-
-
16,585
27,500
Revenue Over/(Under) Expenditures
$
3,775 $
2,500 $
(13,385) $
(24,200)
Beginning Fund Balance Ending Fund Balance
$ $
58,606 $ 62,381 $
62,381 $ 64,881 $
62,381 $ 48,996 $
48,996 24,796
32
City of Celina Capital Acquisition Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Transfer from General Fund Interest Income
$
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
- $ 35,514
- $ 15,000
- $ 15,000
14,550
35,514
15,000
15,000
14,550
Expenditures Skid Steer Bucket Truck Medic Medic Supplies Radios Body Cams Tasers Ticket Writer Emergency Signal Watch Guard Administration Vehicle Vehicles Development Services Bunker Gear Court Case Management Laserfische Ford F-150 for Fire Department Fuel Trailer for Streets Material Bin Cover for Streets Department CID Vehicle for Police New Police Vehicles Incode 10 Migration Smart Irrigation - Parks COG Monuments Computer Replacement Downtown Master Plan Comprehensive Plan Downtown Zoning Plan Roadway Preliminary Study
85,213 58,864 420,843 35,179 31,584 3,200 4,259 3,121 10,710 11,003 17,250 135,930 16,484 16,165 35,457 77,706 19,310 -
136,000 33,000 45,250 15,000 16,000 55,000 217,500 23,000 10,915 150,000 -
136,000 33,000 45,250 15,000 16,000 55,000 217,500 23,000 10,915 150,000 -
34,955 50,000 7,500 45,000 100,000 75,000 100,000
Total Expenditures
982,278
701,665
701,665
412,455
Total Revenues
Revenue Over/(Under) Expenditures
$
(946,764) $
(686,665) $
(686,665) $
(397,905)
Beginning Fund Balance Ending Fund Balance
$ $
3,029,039 $ 2,082,275 $
2,082,275 $ 1,395,610 $
2,082,275 $ 1,395,610 $
1,395,610 997,705
33
City of Celina Road Impact Fee Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Road Impact Fees Interest Income
$
Total Revenues Expenditures Miscellaneous Expenditures Hillwood Residential Rebates Wells Road Pavement Design Analysis
Total Expenditures
Estimated 2018-2019
725,843 $ 7,318
-
733,161
700,000 23,000
-
723,000
723,000
25,379 147,128 172,507
-
42,667 234,760 10,000 5,798 293,225
50,000 300,000 25,000 375,000
-
$
429,775 $
348,000
847,865 $ 847,865 $
847,865 $ 1,277,640 $
1,277,640 1,625,640
$
560,654 $
Beginning Fund Balance Ending Fund Balance
$ $
287,211 $ 847,865 $
$
Adopted 2019-2020
700,000 $ 23,000
Revenue Over/(Under) Expenditures
34
Amended Budget 2018-2019
City of Celina Road Capital Recovery Fee Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Road Capital Recovery Fee Interest Income
$
Total Revenues Expenditures Miscellaneous Expense Lilyana Wells Road R15 Glendenning Parkway CR 55 R17 Traffic Signals - Preston R18 Wells Road CR 84 R22 Parvom Road - FM 1385 to Legacy R23 Pavement Design Analysis R24 Preston Road Lighting R25 Legacy - Clear Creek to Carey R26 Legacy - Carey to FM 428 Preliminary Roadway Studies Creeks of Legacy - Doe Branch Bridge Total Expenditures
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
317,500 $ 1,573
580,000 $ 10,000
625,000 $ 10,000
625,000 10,000
319,073
590,000
635,000
635,000
25,818 25,818
138,070 45,000 15,000 46,500 83,000 50,000 15,000 392,570
11,149 138,070 45,000 11,149 15,000 46,500 83,000 50,000 15,000 100,000 514,868
100,000 400,000 500,000
Revenue Over/(Under) Expenditures
$
293,255 $
197,430 $
120,132 $
135,000
Beginning Fund Balance Ending Fund Balance
$ $
- $ 293,255 $
293,255 $ 490,685 $
293,255 $ 413,387 $
413,387 548,387
35
City of Celina Technology Fund - Revenue & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Fines & Fees Interest Income
$
Total Revenues
Estimated 2018-2019
38,500 $ 11
-
38,511
$
Adopted 2019-2020
55,000 $ 900
30,000 500
-
55,900
30,500
Expenditures Legal & Professional Services Materials & Supplies
-
-
5,000 15,056
5,000 27,500
Total Expenditures
-
-
20,056
32,500
Revenue Over/(Under) Expenditures
$
38,511 $
-
$
35,844 $
(2,000)
Beginning Fund Balance Ending Fund Balance
$ $
- $ 38,511 $
38,511 $ 38,511 $
38,511 $ 74,355 $
74,355 72,355
36
City of Celina Integrity Fund - Revenue & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Other Revenue Interest Income
$
-
$
Estimated 2018-2019
Adopted 2019-2020
88,000 $ -
121,200 $ 1,300
120,000 1,000
88,000
122,500
121,000
Total Revenues
-
Expenditures Legal & Professional Services Miscellaneous Expense Capital
-
-
-
-
Total Expenditures
-
-
-
-
Revenue Over/(Under) Expenditures
$
-
$
88,000 $
122,500 $
121,000
Beginning Fund Balance Ending Fund Balance
$ $
-
$ $
- $ 88,000 $
- $ 122,500 $
122,500 243,500
37
Debt Service Funds
City of Celina Debt Service Fund - Revenue & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Taxes Interest Income Transfers CDC
$
2,555,174 $ 33,140
3,360,240 $ 25,000
Estimated 2018-2019 4,059,414 $ 85,000
Adopted 2019-2020 3,448,479 40,000
200,000
200,000
200,000
1,097,537
Total Revenues
2,788,314
3,585,240
4,344,414
4,586,016
Expenditures Debt Service - Principal Debt Service - Interest
1,436,110 908,016
3,288,122 -
1,955,000 1,782,204
2,790,000 2,340,921
Total Expenditures
2,344,126
3,288,122
3,737,204
5,130,921
Revenue Over/(Under) Expenditures
$
444,188 $
297,118 $
607,210 $
(544,905)
Beginning Fund Balance Ending Fund Balance
$ $
1,369,342 $ 1,813,530 $
1,813,530 $ 2,110,648 $
1,813,530 $ 2,420,740 $
2,420,740 1,875,835
Fund Balance Policy 20%
77%
64%
65%
Revenue & Expenditure Summary 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 -
Actual 2017-2018
Amended Budget 2018-2019 Total Revenues
38
Estimated 2018-2019 Total Expenditures
Adopted 2019-2020
37%
City of Celina Debt Service Fund - Revenue & Expenditure Summary Fund Balance $3,000,000
6,000,000 $2,420,740
5,000,000 4,000,000
$2,500,000 $1,875,835
$1,813,530
$2,000,000
3,000,000
$1,500,000
2,000,000
$1,000,000
1,000,000
$500,000
-
$2,344,126
$3,737,204
$5,130,921
Actual 2017-2018
Estimated 2018-2019
Adopted 2019-2020
Total Expenditures
39
Ending Fund Balance
$-
Proprietary Funds
City of Celina Proprietary Funds - Revenue & Expense Summary Actual 2017-2018 Revenues Fines & Fees Interest Income Charges for Services Other Revenues Transfers
$
Total Revenues Expenses Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities UTRWD Delivery & Collection Cost Miscellaneous Capital Transfers Debt Service Total Expenses
4,538,923 $ 208,579 10,202,125 554,355 -
Amended Budget 2018-2019 2,867,325 $ 127,000 9,521,997 511,722 -
Estimated 2018-2019
Adopted 2019-2020
5,044,350 $ 390,000 10,590,000 382,000 -
5,273,756 364,000 11,595,000 564,269 2,880,000
15,503,982
13,028,044
16,406,350
20,677,025
1,143,915 922,665 892,742 330,057 259,099 2,800,093 1,763,594 430,617 746,734 3,413,836
1,496,750 730,775 854,390 272,000 317,240 4,009,935 304,475 86,000 838,754 3,413,836
1,451,148 1,102,993 895,876 304,102 248,830 3,966,573 1,520,864 1,200,797 838,754 4,689,064
1,746,512 1,292,034 832,890 277,500 275,000 4,494,817 342,835 486,027 3,728,127 6,501,119
12,703,352
12,324,155
16,219,001
19,976,861
Revenue Over/(Under) Expenses
$
2,800,630 $
Beginning Fund Balance Ending Fund Balance
$ 9,009,427 $ 11,810,057 $ 11,810,057 $ 11,997,406 $ 11,810,057 $ 12,513,946 $ 11,997,406 $ 12,697,569
40
703,889 $
187,349 $
700,164
City of Celina Water-Wastewater Fund - Revenue & Expense Summary Actual 2017-2018 Revenues Fines & Fees Interest Income Water Sales Wastewater Sales Garbage Billing Other Revenues Transfers
$
Total Revenues Expenses Non Departmental Water Distribution Wastewater Collection Utility Billing Trash and Recycling Water-Wastewater Debt Service UTRWD Debt Service Total Expenses
2,073,208 $ 115,504 6,437,153 3,077,772 687,200 554,355 -
Amended Budget 2018-2019 2,217,325 $ 123,750 6,094,939 2,783,280 643,778 511,722 -
Estimated 2018-2019 2,007,150 $ 200,000 6,150,000 3,600,000 840,000 382,000 -
Adopted 2019-2020 2,160,200 175,000 6,765,000 3,960,000 870,000 564,269 2,880,000
12,945,192
12,374,794
13,179,150
17,374,469
527,000 4,296,036 1,605,894 208,312 617,144 2,231,473 1,182,363
603,000 5,181,803 2,084,614 305,127 690,775 2,231,473 1,182,363
603,000 5,385,384 2,126,234 294,298 751,849 3,506,701 1,182,363
613,000 6,009,748 2,211,678 323,466 827,034 5,426,399 1,074,720
10,668,222
12,279,155
13,849,829
16,486,045
Revenue Over/(Under) Expenses
$
2,276,970 $
95,639 $
(670,679) $
888,424
Beginning Fund Balance Ending Fund Balance
$ $
2,082,385 $ 4,359,355 $
4,359,355 $ 4,454,994 $
4,359,355 $ 3,688,676 $
3,688,676 4,577,100
Fund Balance Policy 33%
60%
41
50%
40%
46%
City of Celina Water-Wastewater Fund - Revenue & Expense Summary Revenue & Expense Summary 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 -
Actual 2017-2018
Amended Budget 2018-2019 Total Revenues
Estimated 2018-2019
Adopted 2019-2020
Total Expenses
Fund Balance 18,000,000 16,000,000
$4,577,100
$4,359,355
$4,500,000 $3,688,676
14,000,000
$4,000,000 $3,500,000
12,000,000
$3,000,000
10,000,000
$2,500,000
8,000,000
$2,000,000
6,000,000
$1,500,000
4,000,000 2,000,000 -
$5,000,000
$1,000,000 $10,668,222
$13,849,829
$16,486,045
Actual 2017-2018
Estimated 2018-2019
Adopted 2019-2020
Total Expenses
Ending Fund Balance
42
$500,000 $-
City of Celina Water-Wastewater Fund - Revenues Amended Budget 2018-2019
Actual 2017-2018 Revenues Fines & Fees Interest Income Water Sales Wastewater Sales Garbage Billing Other Revenues Transfers
$
2,073,208 $ 115,504 6,437,153 3,077,772 687,200 554,355 -
2,217,325 $ 123,750 6,094,939 2,783,280 643,778 511,722 -
Estimated 2018-2019 2,007,150 $ 200,000 6,150,000 3,600,000 840,000 382,000 -
Adopted 2019-2020 2,160,200 175,000 6,765,000 3,960,000 870,000 564,269 2,880,000
$ 12,945,192 $ 12,374,794 $ 13,179,150 $ 17,374,469
Total General Fund Revenues
Water-Wastewater Fund Revenues $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $-
Fines & Fees
Actual 2017-2018 Interest Income
Amended Budget 2018-2019 Water Sales
Estimated 2018-2019
Wastewater Sales
Adopted 2019-2020
Garbage Billing
Other Revenues
Transfers
Revenues Fines & Fees 12%
Other Revenues 3%
Transfers 17%
Garbage Billing 5%
Wastewater Sales 23%
Fines & Fees
Interest Income
Water Sales
Interest Income 1%
Water Sales 39%
Wastewater Sales
43
Garbage Billing
Other Revenues
Transfers
City of Celina Water-Wastewater Fund - Expenses Amended Budget 2018-2019
Actual 2017-2018 Expenses Non Departmental Water Distribution Wastewater Collection Trash and Recycling Utility Billing Water-Wastewater Debt Service UTRWD Debt Service
$
527,000 $ 4,296,036 1,605,894 617,144 208,312 2,231,473 1,182,363
Estimated 2018-2019
603,000 $ 5,181,803 2,084,614 690,775 305,127 2,231,473 1,182,363
603,000 $ 5,385,384 2,126,234 751,849 294,298 3,506,701 1,182,363
Adopted 2019-2020 613,000 6,009,748 2,211,678 827,034 323,466 5,426,399 1,074,720
$ 10,668,222 $ 12,279,155 $ 13,849,829 $ 16,486,045
Total Expenses
Expenses $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $-
Actual 2017-2018
Non Departmental Trash and Recycling UTRWD Debt Service
Amended Budget 2018-2019 Water Distribution Utility Billing
44
Estimated 2018-2019
Adopted 2019-2020 Wastewater Collection Water-Wastewater Debt Service
City of Celina Water-Wastewater Fund - Expenses Actual 2017-2018 Expenses Water Distribution Water-Wastewater Debt Service Wastewater Collection UTRWD Debt Service Trash and Recycling Non Departmental Utility Billing
Amended Budget 2018-2019
40.27% 20.92% 15.05% 11.08% 5.78% 4.94% 1.95% 100.00%
42.20% 18.17% 16.98% 9.63% 5.63% 4.91% 2.48% 100.00%
Estimated 2018-2019 38.88% 25.32% 15.35% 8.54% 5.43% 4.35% 2.12% 100.00%
Adopted 2019-2020 36.45% 32.92% 13.42% 6.52% 5.02% 3.72% 1.96% 100.00%
Expenses UTRWD Debt Service 7%
Non Departmental 4%
Water Distribution 36%
Water-Wastewater Debt Service 33%
Wastewater Collection 13%
Utility Billing 2% Trash and Recycling 5% Non Departmental Trash and Recycling UTRWD Debt Service
Water Distribution Utility Billing
45
Wastewater Collection Water-Wastewater Debt Service
City of Celina Water-Wastewater Fund - Expenses Actual 2017-2018 Expenses Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities UTRWD Delivery & Collection Cost Miscellaneous Capital Transfers Debt Service Total Expenses
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
$
1,143,915 $ 1,496,750 $ 1,451,148 $ 1,686,723 916,465 730,775 1,102,993 1,292,034 892,742 854,390 895,876 832,890 330,057 272,000 304,102 277,500 259,099 317,240 248,830 275,000 2,800,093 4,009,935 3,966,573 4,494,817 165,281 259,475 266,489 277,835 86,000 86,000 746,734 838,754 838,754 848,127 3,413,836 3,413,836 4,689,064 6,501,119 $ 10,668,222 $ 12,279,155 $ 13,849,829 $ 16,486,045
Expenses Legal & Professional Services
Personnel
Materials & Supplies
Debt Service
Maintenance Utilities
UTRWD Delivery & Collection Cost
Transfers
Capital Miscellaneous Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
UTRWD Delivery & Collection Cost
Miscellaneous
Capital
Transfers
Debt Service
46
City of Celina Water-Wastewater Fund - Non-Departmental Actual 2017-2018
Expenses
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Transfers
$
527,000 $
603,000 $
603,000 $
613,000
Total Non-Departmental
$
527,000 $
603,000 $
603,000 $
613,000
Non-Departmental $620,000 $600,000 $580,000 $560,000 $540,000 $520,000 $500,000 $480,000
Actual 2017-2018
Amended Budget Estimated 2018-2019 2018-2019 Transfers
47
Adopted 2019-2020
City of Celina Water-Wastewater Fund - Water Distribution Department Amended Budget 2018-2019
Actual 2017-2018
Expenses
Estimated 2018-2019
Adopted 2019-2020
Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities UTRWD Delivery Miscellaneous Capital
$
741,151 $ 67,285 736,943 163,445 196,135 2,226,264 164,813 -
877,806 $ 30,000 722,000 130,500 227,500 2,939,935 203,062 51,000
864,499 $ 320,000 723,000 156,500 165,600 2,896,573 208,212 51,000
970,634 290,000 715,000 130,500 210,000 3,472,106 221,508 -
Total Water Distribution Department
$
4,296,036 $
5,181,803 $
5,385,384 $
6,009,748
Personnel Assistant Director of Public Works Water Supervisor Crew Leader Equipment Operator Utility Worker Meter Technician Utility Locator Total Personnel
0 1 3 2 4 3 1
0 1 3 2 4 3 1
1 0 3 2 4 3 1
1 0 3 2 4 3 1
14
14
14
14
Water Distribution Department $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
UTRWD Delivery
Miscellaneous
Capital
48
City of Celina Water-Wastewater Fund - Wastewater Collection Department Amended Budget 2018-2019
Actual 2017-2018
Expenses
Estimated 2018-2019
Adopted 2019-2020
Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities UTRWD Collection Miscellaneous Capital
$
302,798 $ 232,036 151,818 152,363 51,955 573,829 141,095 -
456,577 $ 10,000 121,100 141,500 76,000 1,070,000 174,437 35,000
430,085 $ 31,144 165,186 147,602 72,300 1,070,000 174,917 35,000
531,303 175,000 115,000 147,000 65,000 1,022,711 155,664 -
Total Wastewater Collection Department
$
1,605,894 $
2,084,614 $
2,126,234 $
2,211,678
Personnel Water Supervisor Wastewater Treatment Plat Operator Crew Leader Equipment Operator Utility Worker Wastewater Technician
1 1 1 1 3 1
1 1 1 1 3 1
1 1 1 1 3 1
1 1 1 1 3 1
Total Personnel
8
8
8
8
Wastewater Collection Department $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
UTRWD Collection
Miscellaneous
Capital
49
City of Celina Water-Wastewater Fund - Utility Billing Department Amended Budget 2018-2019
Actual 2017-2018
Expenses
Estimated 2018-2019
Adopted 2019-2020
Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital
$
99,966 $ 3,981 14,249 11,009 79,107 -
162,367 $ 11,290 13,740 117,730 -
156,564 $ 7,690 10,930 119,114 -
184,786 2,890 135,790 -
Total Utility Billing Department
$
208,312 $
305,127 $
294,298 $
323,466
Personnel Utility Billing Supervisor Utility Billing Clerk
0 2
1 2
1 2
1 2
Total Personnel
2
3
3
3
Utility Billing Department $200,000 $150,000 $100,000 $50,000 $-
Actual 2017-2018
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Personnel
Legal & Professional Services
Materials & Supplies
Maintenance
Utilities
Miscellaneous
Capital
50
City of Celina Water-Wastewater Fund - Trash & Recycling Department Actual 2017-2018
Expenses
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Trash & Recycling Services
$
617,144 $
690,775 $
751,849 $
827,034
Total Trash & Recycling Department
$
617,144 $
690,775 $
751,849 $
827,034
Trash & Recycling Department $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $-
Actual 2017-2018
Amended Budget Estimated 2018-2019 2018-2019 Trash & Recycling Services
51
Adopted 2019-2020
City of Celina Water-Wastewater Fund - Debt Service Actual 2017-2018
Expenses
Amended Budget 2018-2019
Estimated 2018-2019
Adopted 2019-2020
Debt Service
$
3,413,836 $
3,413,836 $
4,689,064 $
6,501,119
Total Debt Service
$
3,413,836 $
3,413,836 $
4,689,064 $
6,501,119
Debt Service $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $-
Actual 2017-2018
Amended Budget Estimated 2018-2019 2018-2019 Debt Service
52
Adopted 2019-2020
City of Celina Drainage Fund - Revenue & Expense Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Storm Water Fees Interest Income
$
Estimated 2018-2019
Adopted 2019-2020
408,011 $ 3,175
400,000 $ 3,000
450,000 $ 6,000
510,000 5,000
Total Revenues
411,186
403,000
456,000
515,000
Expenses Personnel Miscellaneous Expense Capital Transfer Debt Service
3,504 376,970 -
45,000 -
45,000 219,080 -
59,789 45,000 176,027 120,000 -
Total Expenses
380,474
45,000
264,080
400,816
Revenue Over/(Under) Expenses
$
30,712 $
358,000 $
191,920 $
114,184
Beginning Fund Balance Ending Fund Balance
$ $
318,288 $ 349,000 $
349,000 $ 707,000 $
349,000 $ 540,920 $
540,920 655,104
Fund Balance
9960%
15%
30%
Revenue & Expense Summary 600,000 500,000 400,000 300,000 200,000 100,000 -
Actual 2017-2018
Amended Budget 2018-2019 Total Revenues
53
Estimated 2018-2019 Total Expenses
Adopted 2019-2020
27%
City of Celina Utility Impact Fee Fund - Revenue & Expense Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Water Impact Fees Wastewater Impact Fees Interest Income
Estimated 2018-2019
Adopted 2019-2020
862,470 435,234 86,076
-
756,000 772,200 162,000
816,480 833,976 162,000
Total Revenues
1,383,780
-
1,690,200
1,812,456
Expenses Legal & Professional Services Miscellaneous Expense LFC Land Company Land Acquisition S18 Preston Road Sewer W15 Oklahoma Water Line - Water W18 Preston Road - Water W22 CR 53 Waterline Improvements S09 Cambridge Crossing Sewer Upsizing
6,200 18,409 1,576,400 53,647 -
-
9,375 1,200,000 32,500 287,517 31,500 472,950 -
20,000 310,000
-
Transfer (Water Fund - Debt Service)
Total Expenses
-
1,654,656
-
Revenue Over/(Under) Expenses
$
(270,876) $
Beginning Fund Balance Ending Fund Balance
$ $
6,608,754 $ 6,337,878 $
54
-
2,400,000
2,033,842
2,730,000
$
(343,642) $
(917,544)
6,337,878 $ 6,337,878 $
6,337,878 $ 5,994,236 $
5,994,236 5,076,692
City of Celina Water Capital Recovery Fee Fund - Revenue & Expense Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Water Capital Recovery Fee Interest Income
$
Total Revenues
Estimated 2018-2019
Adopted 2019-2020
380,000 $ 1,760
250,000 $ 250
525,800 $ 12,000
473,220 12,000
381,760
250,250
537,800
485,220
Expenses Miscellaneous Expense W16 Frontier Parkway - Preston to Coit W21 NTMWD Connection
-
-
21,250 50,000
-
Total Expenses
-
-
71,250
-
Revenue Over/(Under) Expenses
$
381,760 $
250,250 $
466,550 $
485,220
Beginning Fund Balance Ending Fund Balance
$ $
- $ 381,760 $
381,760 $ 632,010 $
381,760 $ 848,310 $
848,310 1,333,530
55
City of Celina Wastewater Capital Recovery Fee Fund - Revenue & Expense Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Wastewater Capital Recovery Fee Interest Income
$
Total Revenues
Estimated 2018-2019
380,000 $ 2,064
-
382,064
-
$
Adopted 2019-2020
533,200 $ 10,000
479,880 10,000
543,200
489,880
Expenses Miscellaneous Expense Transfer (Water Fund for Debt Service)
-
-
-
360,000
Total Expenses
-
-
-
360,000
-
$
543,200 $
129,880
382,064 $ 382,064 $
382,064 $ 925,264 $
925,264 1,055,144
Revenue Over/(Under) Expenses
$
382,064 $
Beginning Fund Balance Ending Fund Balance
$ $
- $ 382,064 $
56
Bond Funds
57
B15 B16 B17 B18 B19 B20 F09 F10 F11 F13 R12 R13 R15 R17 R19 R20 R21 R22 R23 R24 R25 R26 R27 R## R$$ P05 P07
Downtown Parking Lot Annex Renovations City Hall Renovations EDC Renovations Downtown Development Law Enforcement Center Fire Station NO 2 Ladder Truck Fire Station NO 3 Fire Truck Susnset Blvd CR83/Ownsby Glendenning Parkway Preston Traffic Signal Kentucky Street Reconstruction Colorado Street Reconstruction 1461 Bridge Parvin Road Pavement Design Analysis Preston Road Lighting Legacy - Clear Creek to Carey Road Legacy - Carey Road to FM 428 Alignment 2019 Street Improvements Choate Parkway Punk Carter Parkway Old Celina Park Bobcat Trail
$
61,268 $ 1,515,990 315,922 713,965 551,999 11,000 2,423,212 1,422,934 280,593 787,132 296,791 437,646 121,600 21,724 70,876 237,684 15,257 45,394 2,460 29,482 9,000 458,880 327,785 14,347
Expense Through 2018-2019
City of Celina Capital Improvement Program Summary
350,000 $ 4,673,845 209,078 886,035 948,001 1,489,000 447,788 27,066 81,245 212,868 255,269 434,570 80,204 23,276 300,000 1,200,000 1,000,000 99,744 1,106 500,000 20,518 6,000 73,795 50,000 50,000 13,322,215 653
2019-2020 368,732 $ 1,800,000 229,124 1,178,316 4,000,000 1,000,000 1,580,540 500,000 50,000 1,000,000
2020-2021 36,000 $ 12,000,000 750,000 2,900,000 4,000,000 5,000,000 1,000,000
2021-2022
240,000 $ 450,000 1,500,000 4,000,000 4,000,000 1,000,000 210,000 11,000,000
2022-2023
1,056,000 6,189,835 14,775,000 1,600,000 1,500,000 3,000,000 2,871,000 1,450,000 1,111,838 1,000,000 552,060 3,772,216 201,804 45,000 600,000 2,616,000 5,000,000 9,115,001 46,500 6,083,000 5,050,000 1,015,000 532,675 550,000 310,000 13,650,000 13,015,000
Total Project Funding
58
S05 S06 S07 S08
W05 W09 W11 W12 W14 W15 W16 W17 W18 W19 W20 W21 W22 W23
2MGD Elevated Storage Tank DC Ranch Celina Rd/Downtown Pump Station DT Evelated Storage CRPS Improvement Oklahoma Water Line Frontier Parkway - Preston to Coit CPRS to DTPS Transmission Line Preston Water Line - Ownsby to Frontier Kentucky Water Line Colorado Water Line Connection to NTMWD CR53 Water Line Improvements Ground Storage Tank Decommission Morgan Lakes Facilities SCADA 289 Water Lines Settler's Ridge Water Lines Pressure Plane Improvements Water Line & ROW Downtown Water Improvements Downtown WWTP Downtown Sewer Rehabilitation DT WWTP Upgrade SE Sector Sewer
Total General Government
P08 Wilson Creek Park P09 NE Regional Park P10 Park Master Plan
4,512,361 932,705 6,391,463 470,244 2,163,055 297,387 3,875 12,051,903 131,520 7,875 23,382 29,153 1,199,948 314,215 5,663,590 1,566,500
13,590 20,000 15,479 10,222,009
City of Celina Capital Improvement Program Summary
1,179,289 251,189 1,238 24,756 1,500,000 19,413 17,375 4,000,000 500,000 372,125 850,000 26,618 443,798 500,000 612,000 547,000 275,000 122,068 300,052 170,785 4,000,000 1,265,353
6,910 1,610,000 14,521 28,373,707 588,244 1,389,915 1,499,980 7,500,000 145,000 250,000 5,340,000 3,281,000 4,636,410 -
11,706,712 3,308,000 -
25,686,000 145,000 4,000,000 4,000,000 -
22,400,000
5,691,650 1,183,894 6,392,701 495,000 4,251,299 316,800 21,250 17,441,818 2,131,500 380,000 850,000 50,000 472,951 8,000,000 290,000 250,000 4,612,000 3,308,000 5,887,000 3,556,000 4,122,068 1,500,000 485,000 14,300,000 2,831,853
20,500 1,630,000 30,000 98,388,428
59
D06 D08 D11 D20
S18 S19 S20 S##
* Includes Future Bond Issues
Quality of Life Projects Service Delivery Projects Infrastructure Projects
Total Capital Improvement*
Preston Rd Sewer Kentucky Sewer Line Colorado Sewer Line Collin College Sewer Line WWTP Design & Construction 289 Sewer Lines I&I Improvements WW Lines Downtown WW Improvements 3488 Preston Hills Circle Elm, CR8 & Preston Hills Drainage Design Manual Colorado Street Drainage Total Business Type $ 391,201 8,084,015 37,761,845
46,237,061 $
42,025 7,075 8,950 175,046 22,781 36,015,052
City of Celina Capital Improvement Program Summary
14,954,299 9,324,926 24,447,261
48,726,486 $
120,000 36,050 123,051 7,219 1,400,000 20,352,779
440,475 337,925 350,000 60,000 500,000
1,000,000 2,168,732 38,795,529
41,964,261 $
540,000 3,000,000 2,087,000 30,257,549
1,000,000 12,786,000 24,208,000
37,994,000 $
12,308,000
6,000,000 3,000,000 -
11,000,000 2,190,000 24,355,000
37,545,000 $
15,145,000
7,000,000 -
28,345,500 34,553,673 147,480,635
210,379,808
120,000 45,000 298,097 30,000 1,400,000 111,991,380
482,500 345,000 350,000 600,000 16,000,000 3,000,000 500,000
City of Celina Bond Funds - Revenue & Expenditure Summary Actual 2017-2018 Revenues Interest Income
$
Amended Budget 2018-2019
Estimated 2018-2019
194,779 $
-
994,000 $
624,000
194,779
-
994,000
624,000
Expenditures Captial Improvement Programs
11,524,347
-
40,585,405
34,282,358
Total Expenditures
11,524,347
-
40,585,405
34,282,358
Revenue Over/(Under) Expenditures
$ (11,329,568) $
-
Beginning Fund Balance Ending Fund Balance
$ 102,027,831 $ 90,698,263 $ 90,698,263 $ 51,106,858 $ 90,698,263 $ 90,698,263 $ 51,106,858 $ 17,448,500
Total Revenues
60
$
Adopted 2019-2020
$ (39,591,405) $ (33,658,358)
City of Celina 2012 Bond Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Interest Income
$
Amended Budget 2018-2019
Estimated 2018-2019
12,047 $
-
Total Revenues
12,047
-
Expenditures Transfers (Captial Improvement Programs)
30,414
-
-
-
Total Expenditures
30,414
-
-
-
Revenue Over/(Under) Expenditures
$
(18,367) $
Beginning Fund Balance Ending Fund Balance
$ $
902,713 $ 884,346 $
61
-
$
Adopted 2019-2020
20,000 $
10,000
20,000
10,000
$
20,000 $
10,000
884,346 $ 884,346 $
884,346 $ 904,346 $
904,346 914,346
City of Celina 2014 Bond Fund - Revenue & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Interest Income
$
Total Revenues
Estimated 2018-2019
11,850 $
-
11,850
$
Adopted 2019-2020
19,000 $
2,000
-
19,000
2,000
Expenditures Transfers (Captial Improvement Programs)
-
-
225,000
275,000
Total Expenditures
-
-
225,000
275,000
-
Revenue Over/(Under) Expenditures
$
11,850 $
Beginning Fund Balance Ending Fund Balance
$ $
697,889 $ 709,739 $
62
$
(206,000) $
(273,000)
709,739 $ 709,739 $
709,739 $ 503,739 $
503,739 230,739
City of Celina 2015 Bond Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Interest Income
$
Amended Budget 2018-2019
Estimated 2018-2019
12,320 $
-
12,320
Expenditures Transfers (Captial Improvement Programs)
Total Expenditures
Total Revenues
17,000 $
5,000
-
17,000
5,000
394,158
-
60,000
171,853
394,158
-
60,000
171,853
Revenue Over/(Under) Expenditures
$
(381,838) $
Beginning Fund Balance Ending Fund Balance
$ $
1,164,186 $ 782,348 $
63
-
$
Adopted 2019-2020
$
(43,000) $
(166,853)
782,348 $ 782,348 $
782,348 $ 739,348 $
739,348 572,495
City of Celina 2016 Bond Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Interest Income
$
Amended Budget 2018-2019
Estimated 2018-2019
59,161 $
-
60,000 $
2,000
59,161
-
60,000
2,000
Expenditures Transfers (Captial Improvement Programs)
1,598,776
-
2,256,554
26,570
Total Expenditures
1,598,776
-
2,256,554
26,570
Total Revenues
Revenue Over/(Under) Expenditures
$
(1,539,615) $
Beginning Fund Balance Ending Fund Balance
$ $
3,789,003 $ 2,249,388 $
64
-
$
Adopted 2019-2020
$
(2,196,554) $
(24,570)
2,249,388 $ 2,249,388 $
2,249,388 $ 52,834 $
52,834 28,264
City of Celina 2017 Bond Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Interest Income
$
Amended Budget 2018-2019
Estimated 2018-2019
45,826 $
-
48,000 $
5,000
45,826
-
48,000
5,000
Expenditures Transfers (Captial Improvement Programs)
3,106,689
-
2,156,048
322,660
Total Expenditures
3,106,689
-
2,156,048
322,660
Total Revenues
Revenue Over/(Under) Expenditures
$
(3,060,863) $
Beginning Fund Balance Ending Fund Balance
$ $
5,987,721 $ 2,926,858 $
65
-
$
Adopted 2019-2020
$
(2,108,048) $
(317,660)
2,926,858 $ 2,926,858 $
2,926,858 $ 818,810 $
818,810 501,150
City of Celina 2018 Bond Fund - Revenue & Expenditure Summary Actual 2017-2018 Revenues Interest Income
$
Amended Budget 2018-2019
Estimated 2018-2019
53,575 $
-
800,000 $
200,000
53,575
-
800,000
200,000
Expenditures Transfers (Captial Improvement Programs)
6,394,310
-
28,887,803
17,133,275
Total Expenditures
6,394,310
-
28,887,803
17,133,275
Total Revenues
(6,340,735) $
Revenue Over/(Under) Expenditures
$
Beginning Fund Balance Ending Fund Balance
$ 53,383,319 $ 47,042,584 $ 47,042,584 $ 18,954,781 $ 47,042,584 $ 47,042,584 $ 18,954,781 $ 2,021,506
66
-
$
Adopted 2019-2020
$ (28,087,803) $ (16,933,275)
City of Celina 2019 Bond Fund - Revenue & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Interest Income
$
-
$
Estimated 2018-2019 -
$
Adopted 2019-2020
30,000 $
400,000
Total Revenues
-
-
30,000
400,000
Expenditures Transfers (Captial Improvement Programs)
-
-
7,000,000
16,353,000
Total Expenditures
-
-
7,000,000
16,353,000
Revenue Over/(Under) Expenditures
$
-
Beginning Fund Balance Ending Fund Balance
$ 36,103,000 $ 36,103,000 $ 36,103,000 $ 29,133,000 $ 36,103,000 $ 36,103,000 $ 29,133,000 $ 13,180,000
67
$
-
$
(6,970,000) $ (15,953,000)
Economic Development Funds
City of Celina Economic Development Corporation - Rev & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Taxes Grants Interest Income Other Revenues
$
Estimated 2018-2019
Adopted 2019-2020
573,145 $ 1,950 -
602,500 $ 5,000 -
622,500 $ 10,600 14,000
684,750 15,000 5,000 14,400
Total Revenues
575,095
607,500
647,100
719,150
Expenditures Personnel Legal & Professional Services Materials & Supplies Maintenance Utilities Miscellaneous Capital Transfer Debt Service
333,374 5,162 2,275 1,833 3,674 46,629 -
207,244 17,000 8,000 1,500 4,950 72,437 160,000 80,000
212,620 17,000 8,000 1,500 3,194 94,877 160,000 80,000
218,398 22,000 5,000 1,500 134,487 106,812 120,000
Total Expenditures
392,947
551,131
577,191
608,197
Revenue Over/(Under) Expenditures
$
182,148 $
56,369 $
69,909 $
110,953
Beginning Fund Balance Ending Fund Balance
$ $
277,073 $ 459,221 $
459,221 $ 515,590 $
459,221 $ 529,130 $
529,130 640,083
Revenue & Expenditure Summary 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 -
Actual 2017-2018
Amended Budget 2018-2019 Total Revenues
68
Estimated 2018-2019 Total Expenditures
Adopted 2019-2020
City of Celina Economic Development Corporation - Rev & Expenditure Summary Fund Balance 700,000
$640,083
600,000
$600,000
$529,130 $459,221
500,000
$700,000
$500,000
400,000
$400,000
300,000
$300,000
200,000
$200,000
100,000
$100,000
-
$392,947
$577,191
$608,197
Actual 2017-2018
Estimated 2018-2019
Adopted 2019-2020
Total Expenditures
$-
Ending Fund Balance
Expenditures
Debt Service Personnel Transfer
Miscellaneous Capital
Personnel Maintenance Capital
Legal & Professional Services Utilities Transfer
69
Legal & Professional Services Materials & Supplies Maintenance Utilities Materials & Supplies Miscellaneous Debt Service
City of Celina Community Development Corporation - Rev & Expenditure Summary Amended Budget 2018-2019
Actual 2017-2018 Revenues Taxes Interest Income
$
Estimated 2018-2019
Adopted 2019-2020
573,145 $ 10,458
602,500 $ 5,000
622,500 $ 20,000
684,750 10,000
Total Revenues
583,603
607,500
642,500
694,750
Expenditures Transfer
200,000
-
200,000
1,097,537
Total Expenditures
200,000
-
200,000
1,097,537
Revenue Over/(Under) Expenditures
$
383,603 $
607,500 $
442,500 $
(402,787)
Beginning Fund Balance Ending Fund Balance
$ $
545,388 $ 928,991 $
928,991 $ 1,536,491 $
928,991 $ 1,371,491 $
1,371,491 968,704
Revenue & Expenditure Summary 1,200,000 1,000,000 800,000 600,000 400,000 200,000 -
Actual 2017-2018
Amended Budget 2018-2019 Total Revenues
70
Estimated 2018-2019 Total Expenditures
Adopted 2019-2020