City of Mesquite, Texas Fiscal Year 2014 – 2015 Annual Budget
This budget will raise more revenue from property taxes than last year’s budget by an amount of $1,410,000, 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 $118,430.
Record Vote of the Governing Body Mayor John Monaco Mayor Pro Tem Al Forsythe Deputy Mayor Pro Tem Greg Noschese Councilmember Bruce Archer Councilmember Bill Porter Councilmember Shirley Roberts Councilmember Dennis Tarpley
Aye Aye Aye Aye Aye Aye Aye
Municipal Property Tax Rates Per $100 Valuation
Last Year’s Property Tax Rate This Year’s Property Tax Rate This Year’s Effective Tax Rate This Year’s Effective Operating Tax Rate This Year’s Rollback Tax Rate This Year’s Debt Rate Total Municipal Debt Obligation
.6400000 .6400000 .6178802 .6189445 .6663896 .1778034 $121,960,000
The above is required by Section 102.007, Local Government Code, as amended by Senate Bill 656 of the 83rd Texas Legislature, effective September 1, 2013.
City of Mesquite Adopted Budget/Combined Summary Fiscal Year 2014-15
Fund Type
Beginning Balances 10/1/2014
Revenues/ Transfers In
Appropriations/ Transfers Out
Ending Balances 9/30/2015
$16,409,778 10,316,900 488,605 79,093 $27,294,376
$101,222,681 53,201,644 3,329,886 1,991,016 $159,745,227
$101,216,384 52,390,955 3,311,105 1,939,327 $158,857,771
$16,416,075 11,127,589 507,386 130,782 $28,181,832
$465,693 2,194,520 270,000 221,120 418,213 $3,569,546
$11,717,182 8,158,280 270,000 491,427 0 $20,636,889
$12,073,944 8,071,135 0 497,578 13,586 $20,656,243
$108,931 2,281,665 540,000 214,969 404,627 $3,550,192
$15,437,839 2,355,078 $17,792,917
$15,177,280 2,182,436 $17,359,716
$202,924 5,144,811 129,281 301,682 1,014,344 438,850 195,429 174,157 $7,601,478
$1,125,200 756,000 965,000 911,721 11,589,903 272,200 10,156,000 90,200 $25,866,224
$1,125,200 217,800 970,000 911,721 11,580,641 77,000 9,863,658 73,825 $24,819,845
$202,924 5,683,011 124,281 301,682 1,023,606 634,050 487,771 190,532 $8,647,857
$1,620,622 0 1,084,947 127,980 22,680 $2,856,229
$409,842 278,404 3,377,336 300,300 188,400 $4,554,282
$1,487,842 278,404 3,461,386 350,000 130,000 $5,707,632
$542,622 0 1,000,897 78,280 81,080 $1,702,879
($28,021,317)
($30,146,317)
$200,574,222
$197,254,890
Operating Funds General Fund Water and Sewer Fund Drainage Utility District Fund Airport Fund Total Operating Funds Debt Service/Reserve Funds General Obligation Debt Service Fund Water and Sewer Revenue Debt Service Fund Water and Sewer Revenue Reserve Fund Drainage Utility District Revenue Debt Service Fund Drainage Utility District Revenue Reserve Fund Total Debt Service/Reserve Funds Internal Service Funds Group Medical Insurance Fund General Liability Insurance Fund Total Internal Service Funds
($674,892) 274,079 ($400,813)
($414,333) 446,721 $32,388
Special Revenue Funds Hotel Occupancy Tax Fund Confiscated Seizure Fund 911 Service Fee Fund Community Development Block Grant Program Fund Housing Choice Voucher Program Fund Public, Educational and Government Access Fund 4B Quality of Life Corporation Fund Municipal Court Technology Fund Total Special Revenue Funds Capital Project Funds Capital Project Reserve Fund Rodeo City Tax Increment Financing District Fund Towne Center Tax Increment Financing District Fund Impact Fee Fund Conference Center Capital Replacement Fund Total Capital Project Funds Less: Interfund Transfers Total All Funds
$40,920,816
1
$42,115,148
City of Mesquite Adopted Budget/General Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Revenues: General Property Taxes Gross Receipts Taxes City Sales Taxes Licenses and Permits Fines and Forfeitures Interest Income Charges for Current Service Other Revenues Intergovernmental Revenues Transfers In Total Revenues
$35,138,217 7,537,785 29,071,617 1,166,932 3,927,995 35,916 13,017,504 837,793 513,035 7,885,460 $99,132,254
$35,130,000 7,901,000 28,637,000 1,276,000 3,600,000 50,000 13,395,000 1,144,700 560,455 5,565,000 $97,259,155
$35,180,000 8,020,000 29,945,000 1,258,300 3,825,000 40,000 12,974,700 1,131,157 781,755 5,545,000 $98,700,912
$36,590,000 8,052,000 30,205,000 1,265,450 3,825,000 40,000 13,910,700 1,246,000 558,531 5,530,000 $101,222,681
$1,410,000 32,000 260,000 7,150 0 0 936,000 114,843 (223,224) (15,000) $2,521,769
Operating Expenditures: General Government Housing and Community Services Fire Service Police Service Public Works Community Development Library Services Parks and Recreation Other Expenditures Transfers Out Total Expenditures
$9,800,592 1,779,708 23,113,774 30,139,234 12,693,381 2,619,446 1,873,424 2,749,214 3,696,029 10,300,000 $98,764,802
$9,873,833 1,886,366 23,542,681 30,177,360 11,301,515 2,776,816 1,958,793 3,535,933 2,856,000 9,339,505 $97,248,802
$10,033,340 2,107,343 23,660,862 30,440,167 11,680,269 2,631,876 1,886,251 3,111,024 3,245,972 10,100,000 $98,897,104
$10,202,531 1,711,114 24,112,134 30,243,415 11,675,457 2,796,794 1,949,287 4,438,720 4,586,932 9,500,000 $101,216,384
$169,191 (396,229) 451,272 (196,752) (4,812) 164,918 63,036 1,327,696 1,340,960 (600,000) $2,319,280
$367,452
$10,353
($196,192)
$6,297
Unassigned Beginning Fund Balance $16,026,024 Change in Unassigned Fund Balance 434,082 Change in Nonspendable/Assigned Fund Balance 0 Unassigned Ending Fund Balance $16,460,106
$16,460,106 10,353 0 $16,470,459
$16,460,106 (196,192) 145,864 $16,409,778
$16,409,778 6,297 0 $16,416,075
Excess (Deficiency) Revenues Over Expenditures
Nonspendable/Assigned Fund Balance Total Fund Balance Expenditures as % of Unassigned Balance
Variance
$202,489 ($50,328) 202,489 (145,864) $6,297
$945,864
$945,864
$800,000
$800,000
$0
$17,405,970
$17,416,323
$17,209,778
$17,216,075
$6,297
16.67%
16.94%
2
16.59%
16.22%
City of Mesquite Adopted General Fund Revenues Fiscal Year 2014-15 Revenue Source General Property Tax Current Taxes Delinquent Taxes Interest and Penalties Total General Property Tax
Gross Receipts Electrical Gas Telephone Cable TV Bingo Commercial Sanitation Taxi Franchise Total Gross Receipts
Sales Tax General Sales Tax Mixed Beverage Sales Tax Total Sales Tax
Licenses and Permits Building Permits Electrical Permits Plumbing Permits Health Permits Mechanical Permits Sign Permits Inspection Fees Food Handlers and Manager Fees Liquid Waste Permits Apartment Licenses Plan Review Fees Dog Licenses Other Miscellaneous Licenses Certificate of Occupancy Contractor Registration Fire Sprinkler Permits Miscellaneous Fire Permits Police Alarm Permits Public Pool Operator Permit Other Miscellaneous Permits Total Licenses and Permits
Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
$34,491,581 319,655 326,981 $35,138,217
$34,490,000 300,000 340,000 $35,130,000
$34,490,000 350,000 340,000 $35,180,000
$35,900,000 350,000 340,000 $36,590,000
$1,410,000 0 0 $1,410,000
$3,993,515 965,682 519,062 1,310,268 37,392 709,866 2,000 $7,537,785
$4,125,000 850,000 550,000 1,325,000 35,000 1,015,000 1,000 $7,901,000
$4,125,000 1,030,000 520,000 1,350,000 35,000 960,000 0 $8,020,000
$4,130,000 1,050,000 515,000 1,360,000 35,000 961,000 1,000 $8,052,000
$28,872,752 198,865 $29,071,617
$28,442,000 195,000 $28,637,000
$29,700,000 245,000 $29,945,000
$29,950,000 255,000 $30,205,000
$282,123 22,785 65,165 157,575 26,745 46,200 15,021 59,713 8,590 129,951 57,066 5,736 2,350 36,125 135,300 11,133 11,731 61,965 17,220 14,438 $1,166,932
$350,000 30,000 80,000 155,000 30,000 50,000 25,000 60,000 9,000 127,000 55,000 5,500 2,500 50,000 140,000 10,000 10,000 55,000 18,000 14,000 $1,276,000
$350,000 25,000 70,000 160,000 30,000 45,000 20,000 65,000 9,000 129,000 55,000 5,800 2,500 40,000 140,000 10,000 15,000 55,000 18,000 14,000 $1,258,300
$350,000 25,000 70,000 160,000 30,000 45,000 20,000 65,000 9,000 130,000 55,000 5,800 2,500 45,000 145,000 10,000 10,000 55,000 18,150 15,000 $1,265,450
3
$5,000 20,000 (5,000) 10,000 0 1,000 1,000 $32,000
$250,000 10,000 $260,000
$0 0 0 0 0 0 0 0 0 1,000 0 0 0 5,000 5,000 0 (5,000) 0 150 1,000 $7,150
City of Mesquite Adopted General Fund Revenues Fiscal Year 2014-15 Revenue Source Fines and Forfeitures Traffic Fines Criminal Fines City Ordinances Arrest Fee Child Safety Fee Uniform Traffic Act Fee Municipal Court Building Security Court Time Payment Fee Total Fines and Forfeitures
Interest Income Interest on Investments Market Gain on Investments Total Interest Income
Charges for Current Services MISD Tax Appropriations Board of Adjustment Fees Grass and Weed Charges Amusement Fees Compost Materials Charges Other Miscellaneous Revenues Public Health Program Charges Animal Adoption Fee Ambulance Fees Pound Fees Accident Reports Miscellaneous Public Safety Revenues False Alarm Fees Abandoned Vehicle Notification Waste Collection and Disposal Public Works Inspection Fees Engineering Development Fees Library Fees Photocopy Charges MTED Transportation Fares Pavilion Reservations Reservations Concessions Registration Fees Athletic Field Reservations User Fees Athletic Fees Recreation Special Events Day Camp Fees Tennis Admissions and Reservations Instructor Fees
Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
$3,040,013 527,204 50,187 123,118 12,031 55,400 74,597 45,445 $3,927,995
$2,950,000 300,000 75,000 110,000 10,000 50,000 65,000 40,000 $3,600,000
$3,100,000 400,000 50,000 110,000 10,000 50,000 65,000 40,000 $3,825,000
$3,100,000 400,000 50,000 110,000 10,000 50,000 65,000 40,000 $3,825,000
$0 0 0 0 0 0 0 0 $0
$50,000 0 $50,000
$40,000 0 $40,000
$40,000 0 $40,000
$0 0 $0
$300,000 5,000 400,000 5,000 200,000 10,000 30,000 100,000 1,900,000 25,000 10,000 140,000 25,000 13,000 7,400,000 50,000 60,000 50,000 20,000 15,000 30,000 200,000 11,000 95,000 15,000 110,000 143,000 75,000 45,000 30,000 530,000
$375,000 5,000 320,000 3,700 230,000 10,000 30,000 100,000 2,100,000 20,000 10,000 160,000 25,000 13,000 7,418,000 75,000 60,000 50,000 20,000 15,000 30,000 200,000 11,000 95,000 15,000 110,000 140,000 41,000 45,000 30,000 585,000
$385,000 5,000 350,000 3,700 245,000 10,000 30,000 110,000 2,100,000 20,000 10,000 160,000 25,000 13,000 7,420,000 75,000 60,000 50,000 20,000 15,000 30,000 200,000 11,000 95,000 15,000 110,000 140,000 70,000 45,000 30,000 600,000
$10,000 0 30,000 0 15,000 0 0 10,000 0 0 0 0 0 0 2,000 0 0 0 0 0 0 0 0 0 0 0 0 29,000 0 0 15,000
$43,109 (7,193) $35,916
$376,302 5,850 338,262 3,657 202,157 7,850 29,712 100,741 2,114,327 18,654 9,863 180,913 24,897 12,840 7,407,532 50,135 43,590 46,825 21,914 15,365 29,194 207,886 8,000 81,756 19,090 104,469 139,173 78,635 45,686 29,769 585,061
4
Variance
City of Mesquite Adopted General Fund Revenues Fiscal Year 2014-15 Actual 2012-13 $7,606 7,639 342,626 5,960 313,568 $13,017,504
Adopted 2013-14 $10,000 7,000 375,000 11,000 950,000 $13,395,000
Amended 2013-14 $10,000 7,000 350,000 11,000 255,000 $12,974,700
Adopted 2014-15 $10,000 7,000 350,000 11,000 1,080,000 $13,910,700
Variance $0 0 0 0 825,000 $936,000
Other Revenues Service Charges on Returned Checks Auctions Planning and Zoning Fees Garbage Bags Lease and Rent Income Sale of Compost Material Prior Year Expenditures Recyclable Items Sale Festival Miscellaneous Blue Bag Program Total Other Revenues
$15,115 155,839 33,286 77,127 91,165 94,392 89,306 45,108 201,730 15,401 19,324 $837,793
$20,000 325,000 50,000 85,000 94,700 150,000 50,000 50,000 280,000 20,000 20,000 $1,144,700
$15,000 325,000 40,000 80,000 94,700 260,000 50,000 50,000 176,457 20,000 20,000 $1,131,157
$15,000 325,000 40,000 80,000 96,000 270,000 50,000 50,000 280,000 20,000 20,000 $1,246,000
$0 0 0 0 1,300 10,000 0 0 103,543 0 0 $114,843
Intergovernmental Revenues State Grant Federal Grant Total Intergovernmental Revenues
$137,955 375,080 $513,035
$142,455 418,000 $560,455
$142,455 639,300 $781,755
$61,368 497,163 $558,531
($81,087) (142,137) ($223,224)
$15,460 990,000 2,330,000 4,550,000 $7,885,460
$25,000 990,000 0 4,550,000 $5,565,000
$15,000 980,000 0 4,550,000 $5,545,000
$0 980,000 0 4,550,000 $5,530,000
($15,000) 0 0 0 ($15,000)
$99,132,254
$97,259,155
$98,700,912
$101,222,681
Revenue Source Tennis Shop Sales Tennis Lessons Swimming Pool Charges Miscellaneous Charges for Services Golf Course Fees Total Charges for Current Services
Transfers In Interest GO Bond Funds Special Revenue Funds Capital Projects Fund Water and Sewer Fund Total Transfers In Total General Fund Revenues
5
$2,521,769
City of Mesquite Adopted General Fund Expenditures Fiscal Year 2014-15 Governmental Activity General Government City Council City Manager Economic Development Communications and Marketing Mesquite Arts Center Building Services City Secretary City Attorney Human Resources Administration Risk Management Finance Administration Accounting Purchasing Warehouse Transportation Pool Printshop/Mailroom Central Copy Tax Office Municipal Court Information Technology Telecommunications Budget Office LESS: Work Order Credits Risk Management Services Information Technology Central Copy Transportation Pool Total General Government
Housing and Community Services Administration Animal Services Public Health Clinic MTED/STAR Transit Volunteer Services Total Housing and Community Services
Fire Service Administration Operations Emergency Medical Services Fire Prevention Training Emergency Management Total Fire Service
Actual 2012-13
Adopted 2013-14
$116,582 1,057,792 149,052 257,654 119,771 2,410,608 322,574 769,672 954,063 236,362 599,116 478,632 321,185 201,277 26,243 238,671 107,652 611,181 872,530 1,467,444 162,488 106,646
$113,668 1,038,871 105,136 251,166 119,914 2,417,296 366,230 849,924 926,255 250,030 497,787 502,631 389,324 204,632 2,572 239,340 141,423 622,320 884,925 1,903,204 214,539 69,880
(236,506) (1,467,444) (73,670) (8,983) $9,800,592
(250,030) (1,903,204) (78,000) (6,000) $9,873,833
(255,000) (1,895,578) (75,000) (7,000) $10,033,340
(277,436) (2,072,572) (78,970) (6,000) $10,202,531
(22,436) (176,994) (3,970) 1,000 $169,191
$179,916 781,962 98,167 668,012 51,651 $1,779,708
$179,675 722,839 91,639 847,610 44,603 $1,886,366
$181,984 760,927 62,219 1,057,610 44,603 $2,107,343
$181,015 751,959 95,785 637,425 44,930 $1,711,114
($969) (8,968) 33,566 (420,185) 327 ($396,229)
$1,154,130 18,776,980 1,125,581 1,123,979 789,642 143,462 $23,113,774
$1,107,273 19,637,096 1,054,793 1,160,033 383,366 200,120 $23,542,681
$1,116,225 19,266,325 1,134,761 1,143,326 804,417 195,808 $23,660,862
$1,143,341 20,092,163 1,078,589 1,177,995 405,236 214,810 $24,112,134
$27,116 825,838 (56,172) 34,669 (399,181) 19,002 $451,272
6
Amended 2013-14 $114,619 1,042,501 100,558 291,040 143,647 2,607,588 366,240 845,437 926,255 255,000 497,787 495,017 332,702 204,691 2,772 239,340 108,720 622,320 884,925 1,895,578 214,539 74,642
Adopted 2014-15 $119,330 1,049,250 125,549 278,473 121,346 2,466,166 376,682 886,933 947,851 277,436 521,300 504,969 375,542 207,206 3,270 237,090 140,290 626,833 1,006,886 2,072,572 220,183 72,352
Variance $4,711 6,749 24,991 (12,567) (22,301) (141,422) 10,442 41,496 21,596 22,436 23,513 9,952 42,840 2,515 498 (2,250) 31,570 4,513 121,961 176,994 5,644 (2,290)
City of Mesquite Adopted General Fund Expenditures Fiscal Year 2014-15 Governmental Activity Police Service Administration Patrol and Traffic Division Criminal Investigations School Resource Officers Technical Services Staff Support Services LESS: Work Order Credits Patrol and Traffic Criminal Investigations School Resource Officers Total Police Service
Public Works Administration Traffic Engineering Street Lighting Engineering Solid Waste Collection Compost Facility Operations Street Maintenance Equipment Services LESS: Work Order Credits Traffic Engineering Engineering Street Maintenance Equipment Services Total Public Works
Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
$956,195 15,318,092 5,909,326 2,028,177 6,108,489 1,187,726
$926,448 15,129,432 5,885,198 1,996,800 6,379,540 1,272,493
$942,077 15,179,938 5,935,006 2,106,757 6,369,607 1,331,785
$940,710 15,278,273 5,788,403 1,964,100 6,386,986 1,278,694
($1,367) 98,335 (146,603) (142,657) 17,379 (53,091)
(371,263) (19,836) (977,672) $30,139,234
(397,551) (22,000) (993,000) $30,177,360
(380,003) (30,000) (1,015,000) $30,440,167
(397,551) (36,200) (960,000) $30,243,415
(17,548) (6,200) 55,000 ($196,752)
$292,518 1,091,950 1,320,659 496,557 5,645,642 564,143 2,967,943 5,358,412 (186,830) (589,900) (22,778) (4,244,935) $12,693,381
$238,421 1,071,966 1,296,846 462,929 5,012,186 436,119 2,738,120 5,208,736 (189,328) (614,480) (50,000) (4,310,000) $11,301,515
$243,921 1,111,705 1,324,914 418,816 5,323,664 512,262 2,616,939 5,290,051 (199,986) (614,480) (50,000) (4,297,537) $11,680,269
$293,973 1,074,232 1,334,663 457,530 5,276,019 474,968 2,568,762 5,401,310 (188,000) (616,000) (50,000) (4,352,000) $11,675,457
Variance
$50,052 (37,473) 9,749 38,714 (47,645) (37,294) (48,177) 111,259 11,986 (1,520) 0 (54,463) ($4,812)
Community Development Administration Building Inspection Environmental Code Licensing and Compliance Repair and Demolition Planning and Zoning Historical Preservation LESS: Work Order Credits Historical Preservation Total Community Development
$262,746 972,396 653,774 356,703 3,751 305,876 99,938
$270,085 932,888 761,720 410,716 0 333,310 103,835
$270,085 917,381 625,302 430,272 17,234 303,505 103,835
$269,763 981,697 736,673 408,061 25,000 307,180 104,158
(35,738) $2,619,446
(35,738) $2,776,816
(35,738) $2,631,876
(35,738) $2,796,794
0 $164,918
Library Services Administration North Branch Central Branch Total Library Services
$719,836 535,105 618,483 $1,873,424
$738,083 571,847 648,863 $1,958,793
$708,100 543,623 634,528 $1,886,251
$720,039 576,527 652,721 $1,949,287
$11,939 32,904 18,193 $63,036
7
($322) 64,316 111,371 (22,211) 7,766 3,675 323
City of Mesquite Adopted General Fund Expenditures Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Governmental Activity Parks and Recreation Administration Park Operations Tennis Center Golf Course Recreation Administration Festival Special Events Florence Community Center Lakeside Activity Center Shaw Gymnasium Goodbar Activity Center Athletic Programs Evans Community Center Scott Dunford Community Center Westlake House Rutherford Community Center Day Camp Thompson School Gymnasium Achziger Program RASP Program Senior Program Summer Camp Program City Lake Pool Town East Pool Vanston Pool Marlins Swim Team Total Parks and Recreation Expenditures LESS: Work Order Credits Park Facilities and Operations - 4B Town East Pool - MISD Florence Community Center - MISD Total Parks and Recreation
$572,158 3,214,392 91,021 827,436 762,523 450,186 94,173 208,915 14,993 54,606 182,183 454,146 412,986 276,387 6,741 437,189 47,448 82,958 34,331 0 0 0 188,011 128,314 127,039 18,377 8,686,513
$569,884 3,199,403 139,926 919,684 768,151 370,969 72,500 184,329 17,325 43,406 164,565 442,783 374,002 185,015 8,000 381,944 35,121 75,376 39,925 0 0 0 177,221 124,347 145,101 22,956 8,461,933
$569,884 3,199,403 126,926 1,002,718 765,757 398,980 77,380 232,872 14,925 56,107 159,507 500,007 412,270 311,886 8,017 395,165 44,926 73,667 36,504 0 0 0 151,540 120,281 152,809 22,956 8,834,487
$562,259 3,300,946 99,061 1,062,396 1,326,006 370,969 75,625 112,590 18,295 11,915 22,897 476,549 241,994 115,508 7,500 107,697 27,322 2,470 0 83,956 227,772 27,565 191,983 115,244 140,110 28,091 8,756,720
(5,937,299) 0 0 $2,749,214
(4,862,000) (39,000) (25,000) $3,535,933
(5,601,463) (85,000) (37,000) $3,111,024
(4,255,000) (45,000) (18,000) $4,438,720
1,346,463 40,000 19,000 $1,327,696
Other Expenditures Insurance Reserves Public Safety Equipment Total Other Expenditures
$1,451,377 1,131,259 1,113,393 $3,696,029
$1,400,000 694,000 762,000 $2,856,000
$1,470,000 795,500 980,472 $3,245,972
$1,510,600 2,921,332 155,000 $4,586,932
$40,600 2,125,832 (825,472) $1,340,960
Other Financing Uses Transfer Out - General Liability Fund Transfer Out - Capital Projects Reserve Fund Transfer Out - Group Medical Insurance Fund Transfer Out - Debt Service Fund Total Other Financing Uses
$300,000 0 0 10,000,000 $10,300,000
$0 0 0 9,339,505 $9,339,505
$0 0 500,000 9,600,000 $10,100,000
$0 0 0 9,500,000 $9,500,000
$0 0 (500,000) (100,000) ($600,000)
Total General Fund Expenditures
$98,764,802
$97,248,802
$98,897,104
$101,216,384
8
Variance ($7,625) 101,543 (27,865) 59,678 560,249 (28,011) (1,755) (120,282) 3,370 (44,192) (136,610) (23,458) (170,276) (196,378) (517) (287,468) (17,604) (71,197) (36,504) 83,956 227,772 27,565 40,443 (5,037) (12,699) 5,135 (77,767)
$2,319,280
City of Mesquite Adopted Budget/Water and Sewer Operating Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Water Sales Water Taps and Connections Penalty Income Collection/Charged off Bills Sale of Bulk Water Reconnect Fees Sewer Service Lower East Fork Sewer Line Sewer Backflow Inspections Utility Service Transfer Interest Income Market Gain on Investments Miscellaneous Total Revenues
$23,827,455 16,333 634,586 28,114 589,648 228,782 18,186,398 1,240,691 59,975 3,420 21,378 (12,816) 42,811 $44,866,775
$28,300,000 10,000 650,000 25,000 500,000 200,000 19,550,000 1,232,164 55,000 3,000 20,000 0 45,000 $50,590,164
$25,093,000 10,000 650,000 25,000 500,000 200,000 19,450,000 1,376,028 55,000 3,000 20,000 0 160,000 $47,542,028
$28,018,718 10,000 650,000 25,000 500,000 200,000 22,146,825 1,253,101 55,000 3,000 20,000 0 320,000 $53,201,644
$2,925,718 0 0 0 0 0 2,696,825 (122,927) 0 0 0 0 160,000 $5,659,616
Operating Expenditures: Administration Water and Sewer Accounting Water and Sewer Engineering Water Production Meter Services Water Distribution Wastewater Collection Wastewater Treatment NTMWD-East Fork Sewer Line Reconstruction Crew Other Expenditures Transfer Out - Insurance Transfer Out - General Fund Transfer Out - Debt Service Reserves Total Expenditures
$400,430 2,825,525 538,512 14,460,880 1,031,573 1,685,334 1,484,238 6,291,454 1,268,791 1,007,872 132,949 1,385,100 4,550,000 8,932,913 256,679 $46,252,250
$434,542 3,430,385 568,945 16,994,950 1,145,487 1,763,324 1,795,616 7,291,076 1,224,886 1,056,326 81,440 1,405,000 4,550,000 8,854,444 330,000 $50,926,421
$446,525 3,363,180 513,216 16,945,374 1,170,487 1,764,485 1,853,621 6,291,076 1,376,028 1,140,632 373,440 1,405,000 4,550,000 8,543,723 330,000 $50,066,787
$398,495 3,741,834 578,730 18,502,058 1,139,064 1,880,909 1,634,755 6,964,631 1,253,101 834,878 396,500 1,405,000 4,550,000 8,809,000 302,000 $52,390,955
($48,030) 378,654 65,514 1,556,684 (31,423) 116,424 (218,866) 673,555 (122,927) (305,754) 23,060 0 0 265,277 (28,000) $2,324,168
Excess (Deficiency) Revenues Over Expenditures
($1,385,475)
Working Capital, October 1
$14,227,134
$12,841,659
$12,841,659
$10,316,900
Working Capital, September 30
$12,841,659
$12,505,402
$10,316,900
$11,127,589
($336,257)
9
($2,524,759)
$810,689
$3,335,448 ($2,524,759) $810,689
City of Mesquite Adopted Budget/Drainage Utility District Operating Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Interest Income Market Gain on Investments Residential Drainage Fees Commercial Drainage Fees Transfer In - DUD Revenue Reserve Total Revenues
$1,738 (868) 1,306,140 862,827 66,943 $2,236,780
$1,200 0 1,522,500 1,211,000 29,973 $2,764,673
$1,200 0 1,510,000 1,180,000 29,973 $2,721,173
$1,300 0 1,750,000 1,565,000 13,586 $3,329,886
$100 0 240,000 385,000 (16,387) $608,713
Expenditures TPDES Permit Program Operatons Street Sweeping Program Transfer Out - Debt Service Transfer Out - DUD Capital Projects Total Expenditures
$434,581 216,189 678,512 600,000 $1,929,282
$533,088 192,067 512,680 1,544,318 $2,782,153
$533,088 208,446 512,680 1,545,000 $2,799,214
$506,918 187,760 491,427 2,125,000 $3,311,105
($26,170) (20,686) (21,253) 580,000 $511,891
Excess (Deficiency) Revenues Over Expenditures
$307,498
($17,480)
($78,041)
$18,781
$96,822
Working Capital, October 1
$259,148
$566,646
$566,646
$488,605
($78,041)
Working Capital, September 30
$566,646
$549,166
$488,605
$507,386
$18,781
10
City of Mesquite Adopted Budget/Airport Operating Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Revenues: Hangar Rentals Tie Downs Fuel Sales Oil Sales Airport Lease Receipts Airport Tenant Utility Receipts Airport Pilot Supplies Other Revenues Transfer In - Capital Projects Reserve Total Revenues
$430,049 8,559 1,503,337 3,770 18,207 8,809 6,839 12,626 150,000 $2,142,196
$493,182 7,500 1,066,500 4,500 21,183 5,000 15,000 50,000 76,887 $1,739,752
$493,182 7,500 1,066,500 4,500 21,183 5,000 15,000 50,000 76,887 $1,739,752
$484,216 7,500 1,400,140 4,500 22,660 7,000 15,000 50,000 0 $1,991,016
($8,966) 0 333,640 0 1,477 2,000 0 0 (76,887) $251,264
Operating Expenditures: Personal Services Supplies Contractual Services Capital Outlay Transfer Out - Debt Service Total Expenditures
$341,248 1,240,662 258,970 0 199,804 $2,040,684
$386,855 887,667 261,766 10,900 199,804 $1,746,992
$386,855 887,667 261,766 10,826 199,804 $1,746,918
$373,952 1,063,017 277,554 25,000 199,804 $1,939,327
($12,903) 175,350 15,788 14,174 0 $192,409
Excess (Deficiency) Revenues Over Expenditures
$101,512
($7,240)
($7,166)
$51,689
$58,855
Working Capital, October 1
($15,253)
$86,259
$86,259
$79,093
($7,166)
$86,259
$79,019
$79,093
$130,782
$51,689
Working Capital, September 30
11
Variance
City of Mesquite Adopted Budget/General Obligation Bond Debt Service Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Revenues: Transfer In - Hotel Occupancy Tax Fund Transfer In - Impact Fee Fund Transfer In - Capital Projects Reserve Fund Transfer In - Capital Projects Fund Transfer In - General Fund Transfer In - Water and Sewer Fund Transfer In - 4B Sales Tax Fund Transfer In - Airport Operating Fund Total Revenues
$58,000 200,000 450,000 0 9,400,000 478,728 0 199,804 $10,786,532
$58,000 225,000 550,000 114,036 9,339,505 432,682 0 199,804 $10,919,027
$58,000 225,000 550,000 221,731 9,600,000 432,682 0 199,804 $11,287,217
$0 350,000 880,000 0 9,500,000 650,720 136,658 199,804 $11,717,182
($58,000) 125,000 330,000 (221,731) (100,000) 218,038 136,658 0 $429,965
Expenditures: Principal Interest Fiscal Agent Fees Total Expenditures
$5,880,000 4,829,589 (5,250) $10,704,339
$6,145,000 4,764,027 4,000 $10,913,027
$6,255,000 4,698,260 6,750 $10,960,010
$7,385,000 4,683,944 5,000 $12,073,944
$1,130,000 (14,316) (1,750) $1,113,934
Variance
Excess (Deficiency) Revenues Over Expenditures
$82,193
$6,000
$327,207
($356,762)
($683,969)
Fund Balance, October 1
$56,293
$138,486
$138,486
$465,693
$327,207
$138,486
$144,486
$465,693
$108,931
($356,762)
Fund Balance, September 30
12
City of Mesquite Adopted Budget/Water and Sewer Revenue Bond Debt Service Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Revenues: Transfer In - W&S Operating Transfer In - W&S Capital Projects Total Revenues
$8,390,000 0 $8,390,000
$8,421,762 0 $8,421,762
$8,111,041 0 $8,111,041
$8,158,280 0 $8,158,280
$47,239 0 $47,239
Expenditures: Principal Interest Fiscal Agent Fees Total Expenditures
$5,435,000 2,863,793 3,850 $8,302,643
$5,470,000 2,904,555 2,000 $8,376,555
$5,470,000 2,803,811 3,750 $8,277,561
$5,275,000 2,792,385 3,750 $8,071,135
($195,000) (11,426) 0 ($206,426)
$87,357
$45,207
Fund Balance, October 1
$2,273,683
$2,361,040
$2,361,040
$2,194,520
($166,520)
Fund Balance, September 30
$2,361,040
$2,406,247
$2,194,520
$2,281,665
$87,145
Excess (Deficiency) Revenues Over Expenditures
13
($166,520)
$87,145
Variance
$253,665
City of Mesquite Adopted Budget/Drainage Utility District Revenue Bond Debt Service Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Transfer In - DUD Operating Fund Total Revenues
$678,512 $678,512
$512,680 $512,680
$512,680 $512,680
$491,427 $491,427
($21,253) ($21,253)
Expenditures: Principal Interest Fiscal Agent Fees Total Expenditures
$615,000 101,953 500 $717,453
$435,000 91,900 500 $527,400
$435,000 91,900 500 $527,400
$415,000 82,078 500 $497,578
($20,000) (9,822) 0 ($29,822)
Excess (Deficiency) Revenues Over Expenditures
($38,941)
($14,720)
($14,720)
Fund Balance, October 1
$274,781
$235,840
$235,840
$221,120
($14,720)
Fund Balance, September 30
$235,840
$221,120
$221,120
$214,969
($6,151)
14
($6,151)
$8,569
City of Mesquite Adopted Budget/Water and Sewer Revenue Reserve Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: W&S Revenue Bond Sale Proceeds Total Revenues
$0 $0
$900,000 $900,000
$270,000 $270,000
$270,000 $270,000
$0 $0
Expenditures: Transfer Out - Debt Service Total Expenditures
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
Excess (Deficiency) Revenues Over Expenditures
$0
$900,000
$270,000
$270,000
$0
Fund Balance, October 1
$0
$0
$0
$270,000
$270,000
Fund Balance, September 30
$0
$900,000
$270,000
$540,000
$270,000
15
City of Mesquite Adopted Budget/Drainage Utility District Revenue Reserve Fund Fiscal Year 2014-15 Actual 2012-13 Revenues: DUD Revenue Bond Sale Proceeds Total Revenues
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
$0 $0
$0 $0
$0 $0
$0 $0
$66,943 $66,943
$29,973 $29,973
$29,973 $29,973
$13,586 $13,586
($16,387) ($16,387)
Excess (Deficiency) Revenues Over Expenditures
($66,943)
($29,973)
($29,973)
($13,586)
$16,387
Fund Balance, October 1
$515,129
$448,186
$448,186
$418,213
($29,973)
Fund Balance, September 30
$448,186
$418,213
$418,213
$404,627
($13,586)
Expenditures: Transfer Out - DUD Operating Total Expenditures
16
$0 $0
City of Mesquite Adopted Budget/Group Medical Insurance Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Interest Income Market Gain on Investments Transfer In - General Fund Employer Contributions Employee Contributions Life Insurance Premiums Sup. Life Insurance Premiums Dental Insurance Premiums Long-term Disability Premiums Health Insurance Surcharges Critical Care Premiums COBRA Medical Ins. Contributions Health Clinic Copays Health Clinic Pharmacy Copays Retirees Medical Ins. Contributions Health Claims Reimbursements Total Revenues
$2,766 (681) 0 8,883,414 1,930,154 78,427 228,310 649,053 74,711 42,273 84,791 26,353 36,359 360,660 1,310,698 270,710 $13,977,998
$2,000 0 0 9,440,000 1,944,500 77,000 220,000 630,000 72,000 30,000 82,000 30,000 30,000 354,000 1,392,475 144,000 $14,447,975
$1,000 0 500,000 9,466,039 1,943,500 77,000 220,000 630,000 72,000 30,000 82,000 30,000 30,000 354,000 1,392,475 144,000 $14,972,014
$800 0 0 10,066,039 2,177,000 77,000 220,000 630,000 72,000 30,000 82,000 30,000 30,000 354,000 1,500,000 169,000 $15,437,839
($200) 0 (500,000) 600,000 233,500 0 0 0 0 0 0 0 0 0 107,525 25,000 $465,825
Expenditures: Health Claims - PPO Plan ICMA Medical Pharmaceutical Transfer Health Clinic Pharmaceutical Administrative Fee - Medical Health Claims - HSA Plan HSA Contributions Health Clinic Operating Stop Loss Coverage Premium Medicare Supplement Premiums Health Claims - Vision Dental Premiums - Managed Care Dental Premiums - Indemnity Life Insurance Premiums Reserve Funding Claims Professional Services Miscellaneous Employee Assistance Program Employee Wellness Program Critical Care Premiums Long-term Disability Premiums Total Expenditures
$6,371,164 1,900 864,089 1,927,227 484,964 977,306 272,900 492,308 329,318 807,060 70,137 71,818 583,322 306,461 13,800 60,093 18,875 26,802 32,536 84,790 74,682 $13,871,552
$6,700,000 3,200 710,000 2,100,000 470,000 1,260,000 270,000 520,000 356,000 840,000 72,000 70,500 580,000 300,100 0 75,000 17,500 26,500 125,145 74,000 72,000 $14,641,945
$7,770,000 3,200 903,000 2,100,000 470,000 1,304,000 300,000 520,000 356,000 840,000 72,000 70,500 580,000 300,100 0 75,000 17,500 26,500 125,145 74,000 72,000 $15,978,945
$7,065,000 1,900 870,000 2,100,000 490,000 1,240,000 270,000 520,000 374,000 885,360 0 70,500 580,000 300,100 0 75,000 17,650 26,500 145,270 74,000 72,000 $15,177,280
($705,000) (1,300) (33,000) 0 20,000 (64,000) (30,000) 0 18,000 45,360 (72,000) 0 0 0 0 0 150 0 20,125 0 0 ($801,665)
Excess (Deficiency) Revenues Over Expenditures
$106,446
($193,970)
Fund Balance, October 1
$225,593
$332,039
Fund Balance, September 30
$332,039
$138,069
17
($1,006,931)
$260,559
$1,267,490
$332,039
($674,892)
($1,006,931)
($674,892)
($414,333)
$260,559
City of Mesquite Adopted Budget/General Liability Insurance Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Revenues: Interest Income Market Gain on Investments Transfer In - Water and Sewer Fund Transfer In - General Fund Workers' Compensation Contributions Other Revenue Total Revenues
$2,123 (563) 1,385,100 300,000 581,086 22,763 $2,290,509
$1,500 0 1,405,000 0 881,846 25,000 $2,313,346
$1,500 0 1,405,000 0 883,294 25,000 $2,314,794
$1,500 0 1,405,000 0 923,578 25,000 $2,355,078
$0 0 0 0 40,284 0 $40,284
Expenditures: Personal Services Legal Services/Court Costs Consulting Services Insurance Premiums General Liability Claims Reserve Funding Claims Workers' Compensation Claims Other Expenditures Total Expenditures
$259,233 231,247 9,163 612,703 219,765 (19,578) 719,004 52,410 $2,083,947
$290,030 250,000 10,000 600,000 200,000 0 750,000 30,000 $2,130,030
$295,000 175,000 10,000 650,000 225,000 0 725,000 30,000 $2,110,000
$317,436 200,000 10,000 650,000 250,000 0 725,000 30,000 $2,182,436
$22,436 25,000 0 0 25,000 0 0 0 $72,436
$206,562
$183,316
$204,794
$172,642
($32,152)
($137,277)
$69,285
$69,285
$274,079
$204,794
$69,285
$252,601
$274,079
$446,721
$172,642
Excess (Deficiency) Revenues Over Expenditures Fund Balance, October 1 Fund Balance, September 30
18
Adopted 2014-15
Variance
City of Mesquite Adopted Budget/Hotel Occupancy Tax Fund Fiscal Year 2014-15 Actual 2012-13 Revenues: Interest Income Market Gain on Investments Hotel Occupancy Tax Total Revenues
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
$298 (61) 1,040,185 $1,040,422
$200 0 975,000 $975,200
$200 0 1,100,000 $1,100,200
$200 0 1,125,000 $1,125,200
$0 0 25,000 $25,000
Expenditures: Convention and Visitors Bureau Mesquite Arts Council, Inc. Historic Mesquite, Inc. Keep Mesquite Beautiful, Inc. Other Expenditures Transfer Out - Debt Service Transfer Out - Conference Center Conference Center Marketing Total Expenditures
$359,063 115,977 115,977 22,000 122,818 58,000 0 114,172 $908,007
$425,830 106,457 106,457 22,000 141,456 58,000 0 115,000 $975,200
$480,000 120,000 120,000 22,000 151,456 58,000 0 130,000 $1,081,456
$488,000 122,000 122,000 22,000 178,200 0 58,000 135,000 $1,125,200
$8,000 2,000 2,000 0 26,744 (58,000) 58,000 5,000 $43,744
Excess (Deficiency) Revenues Over Expenditures
$132,415
$0
$18,744
$0
($18,744)
$51,765
$184,180
$184,180
$202,924
$18,744
$184,180
$184,180
$202,924
$202,924
$0
Fund Balance, October 1 Fund Balance, September 30
19
City of Mesquite Adopted Budget/Confiscated Seizure Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Interest Income Market Gain on Investments Auction Revenue Court Awarded Proceeds Total Revenues
$9,214 (2,413) 108,016 897,324 $1,012,141
$10,000 0 0 750,000 $760,000
$6,500 0 0 750,000 $756,500
$6,000 0 0 750,000 $756,000
($500) 0 0 0 ($500)
Expenditures: Supplies Contractual Capital Outlay Total Expenditures
$192,698 84,529 754,828 $1,032,055
$90,000 127,800 0 $217,800
$389,527 128,900 96,380 $614,807
$91,000 126,800 0 $217,800
($298,527) (2,100) (96,380) ($397,007)
$542,200
$141,693
$538,200
$396,507
Excess (Deficiency) Revenues Over Expenditures
($19,914)
Fund Balance, October 1
$5,023,032
$5,003,118
$5,003,118
$5,144,811
$141,693
Fund Balance, September 30
$5,003,118
$5,545,318
$5,144,811
$5,683,011
$538,200
20
City of Mesquite Adopted Budget/911 Service Fee Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Revenues: 911 Phone Charges Wireless 911 Phone Charges Total Revenues
$298,586 667,012 $965,598
$320,000 680,000 $1,000,000
$290,000 675,000 $965,000
$285,000 680,000 $965,000
($5,000) 5,000 $0
Expenditures: Contractual Services Capital Outlay Transfer Out - General Fund Total Expenditures
$137,593 0 840,000 $977,593
$150,000 0 840,000 $990,000
$139,250 10,750 830,000 $980,000
$140,000 0 830,000 $970,000
$750 (10,750) 0 ($10,000)
Excess (Deficiency) Revenues Over Expenditures
($11,995)
$10,000
($15,000)
Fund Balance, October 1
$156,276
$144,281
$144,281
$129,281
($15,000)
Fund Balance, September 30
$144,281
$154,281
$129,281
$124,281
($5,000)
21
Amended 2013-14
Adopted 2014-15
($5,000)
Variance
$10,000
City of Mesquite Adopted Budget/Community Development Block Grant Program Fund Fiscal Year 2014-15 Actual 2012-13 Revenues: Intergovernmental-Entitlement Other Revenues Total Revenues
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
$1,243,109 0 $1,243,109
$923,667 100,000 $1,023,667
$923,667 52,849 $976,516
$911,721 0 $911,721
($11,946) (52,849) ($64,795)
Expenditures: 2014-15 Projects Administration Comprehensive Planning Code Enforcement Housing Rehabilitation Problem Oriented Policing Program Mission East Dallas County Health Ministries New Beginnings Center Mesquite Social Services Sharing Life Outreach Program Neighborhood Economic Development Neighborhood Development Program Total 2014-15 Projects
$0 0 0 0 0 0 0 0 0 0 0 $0
$0 0 0 0 0 0 0 0 0 0 0 $0
$0 0 0 0 0 0 0 0 0 0 0 $0
$79,294 103,046 195,094 202,213 96,719 9,000 12,000 9,000 9,000 30,000 166,355 $911,721
$79,294 103,046 195,094 202,213 96,719 9,000 12,000 9,000 9,000 30,000 166,355 $911,721
Expenditures: 2013-14 Projects Administration Comprehensive Planning Code Enforcement Housing Rehabilitation Problem Oriented Policing Program Mission East Dallas County Health Ministries New Beginnings Center Mesquite Social Services Sharing Life Outreach Program Neighborhood Economic Development Neighborhood Development Program Neighborhood Stabilization Program Total 2013-14 Projects
$0 0 0 0 0 0 0 0 0 0 0 0 $0
$81,980 101,753 168,191 250,162 96,719 5,000 15,000 8,000 8,000 30,000 158,862 52,849 $976,516
$81,980 101,753 168,191 250,162 96,719 5,000 15,000 8,000 8,000 30,000 158,862 52,849 $976,516
$0 0 0 0 0 0 0 0 0 0 0 0 $0
Expenditures: 2012-13 Projects Administration Comprehensive Planning Code Enforcement Housing Rehabilitation Problem Oriented Policing Program Mission East Dallas County Health Ministries New Beginnings Center Mesquite Social Services Sharing Life Outreach Program Neighborhood Development Program Neighborhood Stabilization Program Total 2012-13 Projects
$77,640 71,186 183,814 61,273 96,719 2,500 20,000 2,500 2,500 171,052 329,983 $1,019,167
$0 0 0 0 0 0 0 0 0 0 0 $0
$0 0 0 0 0 0 0 0 0 0 0 $0
$0 0 0 0 0 0 0 0 0 0 0 $0
$1,019,167
$976,516
$976,516
$911,721
$223,942
$47,151
$0
$0
$0
$77,740
$301,682
$301,682
$301,682
$0
$301,682
$348,833
$301,682
$301,682
$0
Total Expenditures - All Program Years Excess (Deficiency) Revenues Over Expenditures Fund Balance, October 1 Fund Balance, September 30
22
($81,980) (101,753) (168,191) (250,162) (96,719) (5,000) (15,000) (8,000) (8,000) (30,000) (158,862) (52,849) ($976,516)
$0 0 0 0 0 0 0 0 0 0 0 $0 ($64,795)
City of Mesquite Adopted Budget/Housing Choice Voucher Program Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Interest Income Market Gain on Investments Intergovernmental - Section 8 Voucher Total Revenues
$818 (278) 11,611,911 $11,612,451
$1,000 0 10,600,428 $10,601,428
$600 0 11,472,111 $11,472,711
$600 0 11,589,303 $11,589,903
$0 0 117,192 $117,192
Expenditures: Housing Choice Voucher Program Transfer Out - General Fund Total Expenditures
$11,722,209 150,000 $11,872,209
$11,577,325 150,000 $11,727,325
$11,411,018 150,000 $11,561,018
$11,430,641 150,000 $11,580,641
$19,623 0 $19,623
$9,262
$97,569
Excess (Deficiency) Revenues Over Expenditures
($259,758)
Fund Balance, October 1
$1,362,409
Fund Balance, September 30
$1,102,651
($1,125,897) $1,102,651 ($23,246)
23
($88,307) $1,102,651
$1,014,344
($88,307)
$1,014,344
$1,023,606
$9,262
City of Mesquite Adopted Budget/Public, Educational and Government Access Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Interest Income Cable TV PEG Fees Total Revenues
$152 327,495 $327,647
$0 265,000 $265,000
$200 208,460 $208,660
$200 272,000 $272,200
$0 63,540 $63,540
Expenditures: Contractual Services Capital Outlay Total Expenditures
$72,000 19,590 $91,590
$80,000 50,000 $130,000
$80,000 90,000 $170,000
$52,000 25,000 $77,000
($28,000) (65,000) ($93,000)
Excess (Deficiency) Revenues Over Expenditures
$236,057
$135,000
$38,660
$195,200
$156,540
Fund Balance, October 1
$164,133
$400,190
$400,190
$438,850
$38,660
Fund Balance, September 30
$400,190
$535,190
$438,850
$634,050
$195,200
24
City of Mesquite Adopted Budget/Mesquite Quality of Life Corporation Fund Fiscal Year 2014-15 Actual 2012-13 Revenues: Interest Income Market Gain on Investments Contributions Grants Revenue Bond Proceeds Special Use Sales Tax Total Revenues Expenditures: Transportation Improvements Public Safety Improvements Parks and Recreation Improvements Administration Transfer Out - Debt Service Total Expenditures Excess (Deficiency) Revenues Over Expenditures
$8,508 (2,078) 110,717 104,957 0 9,624,251 $9,846,355
$626,439 188,413 9,566,958 50,000 0 $10,431,810
($585,455)
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
$10,000 0 0 162,000 2,000,000 9,480,000 $11,652,000
$7,000 0 14,158 2,617,157 0 9,900,000 $12,538,315
$8,000 0 0 165,000 0 9,983,000 $10,156,000
$1,000 0 (14,158) (2,452,157) 0 83,000 ($2,382,315)
$3,378,000 193,000 8,122,000 100,000 0 $11,793,000
$6,038,603 732,612 11,169,220 100,000 0 $18,040,435
$1,990,000 32,000 7,555,000 150,000 136,658 $9,863,658
($4,048,603) (700,612) (3,614,220) 50,000 136,658 ($4,128,174)
($141,000)
($5,502,120)
$292,342
$1,745,859
Fund Balance, October 1
$6,283,004
$5,697,549
$5,697,549
$195,429
($5,502,120)
Fund Balance, September 30
$5,697,549
$5,556,549
$195,429
$487,771
($3,756,261)
25
City of Mesquite Adopted Budget/Municipal Court Technology Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Interest Income Market Gain on Investments Municipal Court Technology Fee Total Revenues
$229 (179) 99,504 $99,554
$200 0 90,000 $90,200
$200 0 90,000 $90,200
$200 0 90,000 $90,200
Expenditures: Contractual Services Capital Outlay Total Expenditures
$43,035 2,734 $45,769
$51,525 13,055 $64,580
$71,025 13,055 $84,080
$73,825 0 $73,825
$2,800 (13,055) ($10,255)
Excess (Deficiency) Revenues Over Expenditures
$53,785
$25,620
$6,120
$16,375
$10,255
Fund Balance, October 1
$114,252
$168,037
$168,037
$174,157
$6,120
Fund Balance, September 30
$168,037
$193,657
$174,157
$190,532
$16,375
26
$0 0 0 $0
City of Mesquite Adopted Budget/Capital Project Reserve Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Transfer In - General Fund Transfer In - Capital Projects Other Revenue Interest Income Market Gain on Investments Total Revenues
$600,000 329,035 127,781 0 (706) $1,056,110
$0 348,234 60,000 1,500 0 $409,734
$0 362,297 392,921 3,500 500 $759,218
$0 347,842 60,000 2,000 0 $409,842
$0 (14,455) (332,921) (1,500) (500) ($349,376)
Expenditures: Transfer Out - Debt Service Transfer Out - Airport Operating Fund Property Demolition Air Traffic Control Tower Hudson Property Acquisition Miscellaneous Airport Improvement Developer Participation - Camelot Communications Tower Total Expenditures
$450,000 150,000 22,000 188,827 0 189,988 189,035 47,697 $1,237,547
$550,000 76,887 0 0 0 0 218,234 0 $845,121
$550,000 76,887 0 0 12,500 0 222,297 175,628 $1,037,312
$880,000 0 0 0 400,000 0 207,842 0 $1,487,842
$330,000 (76,887) 0 0 387,500 0 (14,455) (175,628) $450,530
($1,078,000)
($799,906)
Excess (Deficiency) Revenues Over Expenditures
($181,437)
($435,387)
($278,094)
Fund Balance, October 1
$2,080,153
$1,898,716
$1,898,716
$1,620,622
($278,094)
Fund Balance, September 30
$1,898,716
$1,463,329
$1,620,622
$542,622
($1,078,000)
27
City of Mesquite Adopted Budget/Rodeo City Tax Increment Financing District Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: City of Mesquite Mesquite Independent School District Total Revenues
$68,536 188,730 $257,266
$70,592 194,392 $264,984
$72,007 198,288 $270,295
$74,167 204,237 $278,404
$2,160 5,949 $8,109
Expenditures: Contractual Services Transfer Out - Capital Projects Reserve Fund Total Expenditures
$58,231 199,035 $257,266
$46,750 218,234 $264,984
$38,000 232,297 $270,297
$60,562 217,842 $278,404
$22,562 (14,455) $8,107
Excess (Deficiency) Revenues Over Expenditures
$0
$0
($2)
$0
$2
Fund Balance, October 1
$2
$2
$2
$0
($2)
Fund Balance, September 30
$2
$2
$0
$0
$0
28
City of Mesquite Adopted Budget/Towne Centre Tax Increment Financing District Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Revenues: City of Mesquite Mesquite Independent School District Total Revenues
$733,963 2,021,150 $2,755,113
$752,312 2,171,346 $2,923,658
$877,779 2,417,183 $3,294,962
$899,723 2,477,613 $3,377,336
Expenditures: Contractual Services Capital Outlay Debt Service - LBJ Project Transfer Out - Capital Projects Reserve Total Expenditures
$709,143 445,683 601,798 130,000 $1,886,624
$1,064,242 900,000 601,798 130,000 $2,696,040
$1,316,105 4,991,743 601,798 130,000 $7,039,646
$634,588 2,095,000 601,798 130,000 $3,461,386
$868,489
$227,618
Fund Balance, October 1
$3,961,142
$4,829,631
$4,829,631
$1,084,947
($3,744,684)
Fund Balance, September 30
$4,829,631
$5,057,249
$1,084,947
$1,000,897
($84,050)
Excess (Deficiency) Revenues Over Expenditures
29
($3,744,684)
($84,050)
Variance $21,944 60,430 $82,374
($681,517) (2,896,743) 0 0 ($3,578,260)
$3,660,634
City of Mesquite Adopted Budget/Impact Fee Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Contributions - Roadway Impact Fees Interest Income Total Revenues
$205,650 346 $205,996
$250,000 300 $250,300
$250,000 300 $250,300
$300,000 300 $300,300
$50,000 0 $50,000
Expenditures: Transfer Out - Debt Service Total Expenditures
$200,019 $200,019
$225,000 $225,000
$225,000 $225,000
$350,000 $350,000
$125,000 $125,000
Excess (Deficiency) Revenues Over Expenditures
$5,977
$25,300
$25,300
($49,700)
($75,000)
$96,703
$102,680
$102,680
$127,980
$25,300
$102,680
$127,980
$127,980
$78,280
($49,700)
Fund Balance, October 1 Fund Balance, September 30
30
City of Mesquite Adopted Budget/Conference Center Capital Replacement Reserve Fund Fiscal Year 2014-15 Actual 2012-13
Adopted 2013-14
Amended 2013-14
Adopted 2014-15
Variance
Revenues: Room Rental Proceeds Interest Income Transfer - In Hotel Occupancy Tax Fund Total Revenues
$117,450 356 0 $117,806
$120,975 300 0 $121,275
$126,343 300 0 $126,643
$130,100 300 58,000 $188,400
$3,757 0 58,000 $61,757
Expenditures: Contractual Services Capital Outlay Total Expenditures
$4,095 176,481 $180,576
$50,000 75,000 $125,000
$50,000 75,000 $125,000
$45,000 85,000 $130,000
($5,000) 10,000 $5,000
Excess (Deficiency) Revenues Over Expenditures
($62,770)
($3,725)
$1,643
$58,400
$56,757
Fund Balance, October 1
$83,807
$21,037
$21,037
$22,680
$1,643
Fund Balance, September 30
$21,037
$17,312
$22,680
$81,080
$58,400
31
