03.27.18 Town Council Regular Meeting PacketPage 1 of 3
]
Prosper is a place where everyone matters.
1. Call to Order/Roll Call.
2. Invocation, Pledge of Allegiance and Pledge to the Texas Flag.
3. Announcements of recent and upcoming events.
4. Presentations.
• Presentation of a street sign recognizing the Prosper High School Volleyball Team as
the 2017 UIL State Champions. (RB)
• Presentation of a TRAPS Promotes Quality of Life Initiative award to members of the
Parks and Recreation Division by the Texas Recreation and Park Society. (PN)
5. CONSENT AGENDA:
(Items placed on the Consent Agenda are considered routine in nature and non-
controversial. The Consent Agenda can be acted upon in one motion. Items may be
removed from the Consent Agenda by the request of Council Members or staff.)
5a. Consider and act upon minutes from the following Town Council meeting. (RB)
• Regular Meeting – March 13, 2018
5b. Receive the January Financial Report. (KN)
5c. Consider and act upon an ordinance adopting the provisions of Article 103.0031
of the Texas Code of Criminal Procedure, imposing a collection fee of thirty percent
(30%) to defray the costs of collections on delinquent fines, fees, and costs
imposed by the Prosper Municipal Court. (KN)
5d. Consider and act upon an ordinance repealing Ordinance No. 01-34 relating to the
ad valorem taxation of leased motor vehicles not used for the production of income,
as defined in Section 11.252 of the Texas Tax Code. (CS)
5e. Consider and act upon an ordinance repealing Section 1.05.034 of the Town of
Prosper “Interjurisdictional Program” of Article 1.05, “Emergency Management,” of
Chapter 1, “General Provisions,” of the Code of Ordinances, removing Prosper
from the Collin County Emergency Management Program. (KB)
5f. Consider and act upon authorizing the Town Manager to execute a Property
Exchange Agreement between Prosper Villages at Legacy LLC, and the Town of
Prosper, Texas, related to an exchange of property at the Parks at Legacy
subdivision. (DR)
AGENDA
Meeting of the Prosper Town Council
Prosper Municipal Chambers
108 W. Broadway, Prosper, Texas
Tuesday, January 23, 2018
6:00 p.m.
AGENDA
Meeting of the Prosper Town Council
Prosper Municipal Chambers
108 W. Broadway, Prosper, Texas
Tuesday, March 27, 2018
6:00 p.m.
Page 2 of 3
5g. Consider and act upon an ordinance rezoning a portion of Planned Development-
65-Single Family Residential/Commercial (PD-65-SF/C), to facilitate the
development of an Automobile Dealership (Chrysler, Dodge, Jeep, Ram), on 16.6±
acres, located on the north side of US 380, 875± feet east of Legacy Drive. (Z17-
0016). (AG)
5h. Consider and act upon an ordinance amending Chapter 3 of the Zoning Ordinance
regarding Definitions. (Z17-0020). (JW)
5i. Consider and act upon whether to direct staff to submit a written notice of appeal
on behalf of the Town Council to the Development Services Department, pursuant
to Chapter 4, Section 1.5(C)(7) and 1.6(B)(7) of the Town’s Zoning Ordinance,
regarding action taken by the Planning & Zoning Commission on any Site Plan or
Preliminary Site Plan. (AG)
6. CITIZEN COMMENTS:
The public is invited to address the Council on any topic. However, the Council is unable
to discuss or take action on any topic not listed on this agenda. Please complete a “Public
Meeting Appearance Card” and present it to the Town Secretary prior to the meeting.
REGULAR AGENDA:
If you wish to address the Council during the regular agenda portion of the meeting, please
fill out a “Public Meeting Appearance Card” and present it to the Town Secretary prior to
the meeting. Citizens wishing to address the Council for items listed as public hearings
will be recognized by the Mayor. Those wishing to speak on a non-public hearing related
item will be recognized on a case-by-case basis, at the discretion of the Mayor and Town
Council.
PUBLIC HEARINGS:
7. Conduct a Public Hearing, and consider and act upon an ordinance for a Specific Use
Permit (SUP) for a Utility Distribution/Transmission Facility (Brazos Electric), on 8.9±
acres, located on the east side of FM 1385, 2,700± feet south of Parvin Road. The
property is zoned Agricultural (A). (S17-0004). (AG)
8. Conduct a Public Hearing, and consider and act upon a request for a Variance to the Sign
Ordinance, regarding a wall sign for Texas Health Resources located at 1970 W .
University Drive. (V18-0003). (AG)
DEPARTMENT ITEMS:
9. Consider and act upon a resolution accepting the Independent Audit Report and
Comprehensive Annual Financial Report (CAFR) for the Fiscal Year Ended September
30, 2017, as presented by a representative of McConnell & Jones, LLP., Certified Public
Accountants. (KN)
10. Consider and act upon awarding Bid No. 2018-57-B to Archer Western Construction, LLC,
related to construction services for the Custer Road Pump Station Expansion Project; and
authorizing the Town Manager to execute a construction agreement for same. (HW)
Page 3 of 3
11. EXECUTIVE SESSION:
Recess into Closed Session in compliance with Section 551.001 et seq. Texas
Government Code, as authorized by the Texas Open Meetings Act, to deliberate
regarding:
11a. Section 551.087 – To discuss and consider economic development incentives.
11b. Section 551.072 – To discuss and consider purchase, exchange, lease or value of
real property for municipal purposes and all matters incident and related thereto.
11c. Section 551.074 – To discuss and review the Town Manager’s performance
evaluation.
12. Reconvene in Regular Session and take any action necessary as a result of the Closed
Session.
13. Possibly direct Town staff to schedule topic(s) for discussion at a future meeting.
14. Adjourn.
CERTIFICATION
I, the undersigned authority, do hereby certify that this Notice of Meeting was posted at Prosper Town Hall,
located at 121 W. Broadway Street, Prosper, Texas 75078, a place convenient and readily accessible to
the general public at all times, and said Notice was posted by 5:00 p.m., on Friday, March 23, 2018, and
remained so posted at least 72 hours before said meeting was convened.
_______________________________ _________________________
Robyn Battle, Town Secretary Date Notice Removed
Pursuant to Section 551.071 of the Texas Government Code, the Town Council reserves the right to consult
in closed session with its attorney and to receive legal advice regarding any item listed on this agenda.
NOTICE
Pursuant to Town of Prosper Ordinance No. 13-63, all speakers other than Town of Prosper staff are limited
to three (3) minutes per person, per item, which may be extended for an additional two (2) minutes with
approval of a majority vote of the Town Council.
NOTICE OF ASSISTANCE AT PUBLIC MEETINGS: The Prosper Town Council meetings are wheelchair
accessible. For special services or assistance, please contact the Town Secretary’s Office at (972) 569-
1011 at least 48 hours prior to the meeting time.
Page 1 of 7
]
Prosper is a place where everyone matters.
1.Call to Order/Roll Call.
The meeting was called to order 6:00 p.m.
Council Members Present:
Mayor Ray Smith
Mayor Pro-Tem Curry Vogelsang, Jr.
Deputy Mayor Pro-Tem Jason Dixon
Councilmember Michael Korbuly
Councilmember Meigs Miller
Councilmember Jeff Hodges
Council Members Absent:
Councilmember Kenneth Dugger
Staff Members Present:
Harlan Jefferson, Town Manager
Robyn Battle, Town Secretary/Public Information Officer
Terrence Welch, Town Attorney
Hulon Webb, Executive Director of Development and Community Services
John Webb, Development Services Director
Alex Glushko, Planning Manager
Dudley Raymond, Parks and Recreation Director
Michael Bulla, CIP Project Manager
Frank Jaromin, Public Works Director
Tristan Cisco, Water Education Coordinator
Chuck Springer, Executive Director of Administrative Services
Kelly Neal, Finance Director
Doug Kowalski, Police Chief
2.Invocation, Pledge of Allegiance and Pledge to the Texas Flag.
Pastor Ben Lacey of Prestonwood Baptist Church led the invocation. The Pledge of
Allegiance and the Pledge to the Texas Flag were recited.
3.Announcements of recent and upcoming events.
Councilmember Hodges read the following announcements:
Traffic on Northbound Dallas Parkway has been reduced to one lane north of US 380
while road construction is underway. Eastbound US 380 will also be reduced to one lane
MINUTES
Meeting of the Prosper Town Council
Prosper Municipal Chambers
108 W. Broadway Street
Prosper, TX 75078
Tuesday, March 13, 2018
Item 5a
Page 2 of 7
from 8:00 p.m. - 5:00 a.m. for the next two weeks as the bridge beams are installed for
the new overpass at Preston Road. Residents are encouraged to use caution and find
alternate routes to minimize delays.
The 7th Annual Prosper Spring Clean Up will be held on Saturday, March 24, from 8:00
a.m. - noon. The drop-off zone will be located along Craig Road in front of Rucker
Elementary. Prosper residents may drop off unwanted items such as scrap lumber,
appliances, old eyeglasses, and other household items. For more information, please visit
the Town website.
Prosper residents age 50 and over are invited to the annual Mayor’s Coffee on
Wednesday, April 18, at Prosper Fire Station No. 2. Please RSVP to Julie Shivers in the
Parks and Recreation Department.
Registration is now open for Prosper’s Spring recreation programs, including tennis,
soccer, and archery. Sign up at www.ProsperParksandRec.org.
4. Presentations.
• Presentation of a Proclamation declaring March 18, 2018, as Jim Spradley Day,
in honor of Mr. Spradley’s 40 years of service as Postmaster of the Prosper Post
Office. (RB)
Jim Spradley was present to receive the Proclamation.
• Public Works Release/Renew/Recycle Presentation. (TC)
Water Education Coordinator Tristan Cisco briefed the Council on the
Release/Renew/Recycle program initiated by the Public Works Division to encourage
the public to empty plastic water bottles before disposing of them in recycle bins. The
Public Works Division sponsored an art contest at Prosper High School and selected
the winning art pieces to be used to decorate recycling containers for the program.
5. CONSENT AGENDA:
(Items placed on the Consent Agenda are considered routine in nature and non-
controversial. The Consent Agenda can be acted upon in one motion. Items may
be removed from the Consent Agenda by the request of Council Members or staff.)
5a. Consider and act upon minutes from the following Town Council meeting.
(RB)
• Regular Meeting – February 27, 2018
5b. Consider and act upon authorizing the Town Manager to execute an Advance
Funding Agreement for a Project Using Funds Held in the State Highway 121
Subaccount for the On-System Improvements between the Texas
Department of Transportation and the Town of Prosper, Texas, related to the
West Prosper Roads project. (HW)
5c. Consider and action upon Ordinance No. 18-16 approving a tariff authorizing
an annual rate review (RRM) mechanism settlement between the Atmos
Item 5a
Page 3 of 7
Cities Steering Committee and Atmos Energy Corporation regarding the
Company’s 2017 rates set by the settlement as a substitution for the annual
interim rate adjustment process defined by section 104.301 of the Texas
Utilities Code. (KN)
5d. Consider and act upon ratifying an expenditure to Barbosa A. Construction,
Inc., related to emergency construction services for the Parvin Road Culvert
Reconstruction project; and authorizing the Town Manager to execute a
construction agreement for same. (FJ)
Deputy Mayor Pro-Tem Dixon made a motion and Councilmember Hodges
seconded the motion to approve all items on the Consent Agenda. The motion
was approved by a vote of 6-0.
6. CITIZEN COMMENTS:
The public is invited to address the Council on any topic. However, the Council is
unable to discuss or take action on any topic not listed on this agenda. Please
complete a “Public Meeting Appearance Card” and present it to the Town Secretary
prior to the meeting.
There were no Citizen Comments.
REGULAR AGENDA:
If you wish to address the Council during the regular agenda portion of the meeting,
please fill out a “Public Meeting Appearance Card” and present it to the Town
Secretary prior to the meeting. Citizens wishing to address the Council for items
listed as public hearings will be recognized by the Mayor. Those wishing to speak
on a non-public hearing related item will be recognized on a case-by-case basis, at
the discretion of the Mayor and Town Council.
PUBLIC HEARINGS:
7. Conduct a Public Hearing, and consider and act upon an ordinance for a Specific
Use Permit (SUP) for a Utility Distribution/Transmission Facility (Brazos Electric),
on 8.9± acres, located on the east side of FM 1385, 2,700± feet south of Parvin Road.
The property is zoned Agricultural (A). (S17-0004). (AG)
Planning Manager Alex Glushko presented this item before the Town Council. The
applicant has requested the item be tabled until the March 27, 2018, Town Council
meeting.
Mayor Pro-Tem Vogelsang made a motion and Deputy Mayor Pro-Tem Dixon seconded
the motion to table Item 7 to the March 27, 2018, Town Council meeting. The motion was
approved by a vote of 6-0.
8. Conduct a Public Hearing, and consider and act upon a request for a Variance to
the Sign Ordinance, regarding construction screening, for Windsong Ranch Crystal
Lagoon, located on the northeast corner of Windsong Parkway and Pepper Grass
Lane. (V18-0002). (AG)
Item 5a
Page 4 of 7
Planning Manager Alex Glushko presented this item before the Town Council. This
request is for a Variance to the Sign Ordinance to allow for an alternate construction
screening for the Windsong Ranch ‘Crystal Lagoon’ amenity. The developer of the Crystal
Lagoon is proposing mesh construction screening which includes digitally printed pictures
and renderings of the proposed project, along with signage related to the development.
The Town’s Sign Ordinance currently does not address this type of signage; therefore, the
applicant is requesting Council consider a Variance to allow for the proposed construction
screening signage.
Daniel Zarate, representing the sign contractor, was present to answer questions from the
Council and presented sample sign material for the Council to view. He confirmed the sign
materials will resist fading for up to five years.
David Blom, representing the landowner for the project, estimated the project would be
completed in May 2019.
Mayor Smith opened the Public Hearing.
With no one speaking, Mayor Smith closed the Public Hearing.
Deputy Mayor Pro-Tem Dixon made a motion and Councilmember Korbuly seconded the
motion to approve a Variance to the Sign Ordinance, regarding construction screening,
for Windsong Ranch Crystal Lagoon, located on the northeast corner of Windsong
Parkway and Pepper Grass Lane; further, the fence shall be removed at the time of the
issuance of a Certificate of Occupancy or building final, whichever occurs first. The motion
was approved by a vote of 6-0.
9. Conduct a Public Hearing, and consider and act upon an ordinance for a Special
Purpose Sign District for Westfork Crossing, located on the northwest corner of US
380 and Gee Road. (MD18-0001). (AG)
Planning Manager Alex Glushko presented this item before the Town Council. The
purpose of this request is to establish the location and style of monument and unified
development signs within the Westfork Crossing development. The applicant is seeking
one deviation to the standards of the Sign Ordinance, which is to eliminate the one-foot
setback required for the three proposed unified development signs along US 380, to create
less of an encroachment into the City of Irving’s waterline easement.
Tommy Reynolds, representing United Commercial Development, the applicant, was
present to answer question from the Town Council.
Mayor Smith opened the Public Hearing.
With no one speaking, Mayor Smith closed the Public Hearing.
Councilmember Korbuly made a motion and Councilmember Hodges seconded the
motion to approve Ordinance No. 18-17 for a Special Purpose Sign District for Westfork
Crossing, located on the northwest corner of US 380 and Gee Road. The motion was
approved by a vote of 6-0.
Item 5a
Page 5 of 7
DEPARTMENT ITEMS:
10. Consider and act upon a resolution appointing a member of the Prosper Town
Council to the North Central Texas Regional 9-1-1 Emergency Communications
District Board of Managers. (RB)
Town Secretary/PIO Robyn Battle presented this item before the Town Council. In April
2016, the Town Council approved Resolution 16-28 authorizing the creation of the North
Central Texas Regional 9-1-1 Emergency Communications District (RECD).
Implementation of a RECD allows funds collected through the 50-cent fee on the phone
bills of residents in the district to be retained by the district to be used for regional 9-1-1
system administration. Under the current system, the funds are collected by the state,
and then redistributed to the region at the direction of the state legislature. Implementation
of the RECD allows for regional control of this revenue. NCTCOG’s 9-1-1 Regional
Advisory Committee has drafted proposed bylaws for the RECD, and has requested all of
the participating entities appoint a representative to the Board of Managers. The Board
will convene its first meeting once all entities have appointed a representative.
After discussion, Councilmember Korbuly made a motion and Mayor Pro-Tem Vogelsang
seconded the motion to approve Resolution No. 18-18 appointing Jeff Hodges to the North
Central Texas Regional 9-1-1 Emergency Communications District Board of Managers.
The motion was approved by a vote of 6-0.
11. Consider and act upon awarding Bid No. 2018-54-B to Pavecon Public Works, L.P.,
related to construction services for the Frontier Parkway Reconstruction DNT to
BNSF Railroad project; and authorizing the Town Manager to execute a
construction agreement for same. (FJ)
Public Works Director Frank Jaromin presented this item before the Town Council. The
scope of this contract includes removal and replacement of existing asphalt paving,
installation of cement treated sub-base and installation of thermoplastic pavement
markings. The contractor will replace twelve (12) feet of pavement on approximately 3,400
square feet of the eastbound lane from CR 50 to just past the east entrance into Frontier
Park. Public Works has discussed the reconstruction of the north side of Frontier Parkway
with the City of Celina; however, monies are not available for replacing the westbound
lane at this time. Town staff was directed to contact Light Farms to determine their
willingness to fund the reconstruction of the north side of Frontier Parkway.
After discussion, Councilmember Korbuly made a motion and Councilmember Hodges
seconded the motion to award Bid No. 2018-54-B to Pavecon Public Works, L.P., related
to construction services for the Frontier Parkway Reconstruction DNT to BNSF Railroad
project; and authorize the Town Manager to execute a construction agreement for same.
The motion was approved by a vote of 6-0.
12. Discussion on proposed amendments to the Zoning Ordinance regarding Home
Occupation standards. (AG)
Planning Manager Alex Glushko presented this item before the Town Council. Mr.
Glushko reviewed the current provisions in the Town’s Zoning Ordinance regarding home
occupations. Town staff recommended several amendments to the ordinance related to
the impact of home occupations on residential neighborhoods, standards regarding home
Item 5a
Page 6 of 7
day care facilities, and community homes. A proposed ordinance will be brought forward
for Council consideration at a future Town Council meeting. No further action was taken.
13. EXECUTIVE SESSION:
Recess into Closed Session in compliance with Section 551.001 et seq. Texas
Government Code, as authorized by the Texas Open Meetings Act, to deliberate
regarding:
13a. Section 551.087 – To discuss and consider economic development
incentives.
13b. Section 551.072 – To discuss and consider purchase, exchange, lease or
value of real property for municipal purposes and all matters incident and
related thereto.
13c. Section 551.074 – To discuss and review the Town Manager’s performance
evaluation.
The Town Council recessed into Executive Session at 7:11 p.m.
14. Reconvene in Regular Session and take any action necessary as a result of the
Closed Session.
The Town Council reconvened the Regular Session at 8:10 p.m. No action was taken as
a result of Executive Session.
15. Possibly direct Town staff to schedule topic(s) for discussion at a future meeting.
• Christmas Festival location (DR)
Parks and Recreation Director Dudley Raymond discussed options for the location of
the 2018 Prosper Christmas Festival. Town Council expressed a preference to hold
the festival downtown, adjacent to the new Town Hall facility.
• Christmas Decorations (DR)
Parks and Recreation Director Dudley Raymond briefed the Council on options for
Christmas decorations in the downtown area and along major thoroughfares. Council
directed staff to move forward with acquiring decorations for the new Town Hall and
Main Street, but to postpone decorations for Broadway and Preston Road.
• Frontier Park North contingencies (DR)
Parks and Recreation Director Dudley Raymond updated the Council on the
contingency funds that have not yet been allocated for the Frontier Park North project,
and provided options for those funds. Town staff was directed to use the funds for
scoreboards and picnic tables, and to acquire plastic recycle bins instead of metal
bins.
Item 5a
Page 7 of 7
• Amend Zoning Ordinance Regarding Definitions (JW)
Development Services Director John Webb informed the Council that an ordinance
will be brought forward at the next Town Council meeting to amend definitions in the
Zoning Ordinance that were inadvertently omitted on the last ordinance amendment.
16. Adjourn.
The meeting was adjourned at 8:32 p.m., on Tuesday, March 13, 2018.
These minutes approved on the 27th day of March 2018.
APPROVED:
Ray Smith, Mayor
ATTEST:
Robyn Battle, Town Secretary
Item 5a
Prosper is a place where everyone matters.
MONTHLY FINANCIAL REPORT
as of January 31, 2018
Budgetary Basis
Prepared by
Finance Department
3/27/2018
Item 5b
TOWN OF PROSPER, TEXAS
MONTHLY FINANCIAL REPORT
JANUARY 2018
Table of Contents
Dashboard Charts 1 ‐ 3
General Fund 4
Water‐Sewer Fund 5
Debt Service Fund 6
Vehicle and Equipment Replacement Fund 7
Storm Drainage Utility Fund 8
Park Dedication and Improvement Fund 9
TIRZ #1 ‐ Blue Star Fund 10
TIRZ #2 ‐ Matthews Southwest 11
Water Impact Fees Fund 12
Wastewater Impact Fees Fund 13
Thoroughfare Impact Fees Fund 14
Special Revenue Fund 15
Capital Projects Fund‐General 16
Capital Projects Fund‐Water/Sewer 17
Detail All Funds 18
Item 5b
First quarter of sales tax receipts ‐ compared to FY 2017 shows a significant increase. This is due to
the retail sales segment which increased 49% from last year. New businesses Dicks's, Lowe's and
Kroger, have greatly increased captured revenue for the Town. We also saw a substainial growth
from Amazon.com which signifies more citizens or more spending in Prosper.
$‐ $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000
Total Budget
YTD Budget
YTD Actual
Building Permit Revenues
0
100,000
200,000
300,000
400,000
500,000
600,000
700,000
Oct Nov Dec Jan Feb Mar Apr May June July Aug Sept
Town of Prosper, Texas
Sales Tax Revenue by Month
FY 14/15 FY15/16 FY 16/17 FY 17/18
1
Item 5b
$29.429
$9.810
$7.483
$25.857
$8.619
$15.466
$‐ $5 $10 $15 $20 $25 $30 $35
Total Budget
YTD Budget
YTD Actual
In Millions
General Fund Revenues and Expenditures
Revenues Expenditures
$18.561
$6.187
$4.472
$16.816
$5.605
$5.271
$‐ $2 $4 $6 $8 $10 $12 $14 $16 $18 $20
Total Budget
YTD Budget
YTD Actual
In Millions
Water‐Sewer Fund Revenues and Expenditures
Revenues Expenditures
2
Item 5b
Prosper is a place where everyone matters.
GENERAL FUND AT A GLANCE
%% Year
Passed
Resources 33.33%
Revenues 60.10%
Other Resources-Beginning Fund Balance 100.00%
Uses 33.33%
Expenditures 26.63%
Ending Fund Balance 100.00%
Resources Over (Under) Uses
UTILITY FUNDS AT A GLANCE
%% Year
Passed
Resources 33.33%
Revenues 31.21%
Other Resources-Beginning Fund Balance 100.00%
Uses 33.33%
Expenditures 23.75%
Ending Fund Balance 100.00%
Resources Over (Under) Uses
OTHER MAJOR IMPACT FEE FUNDS AT A GLANCE
%% Year
Passed
Resources 33.33%
Revenues 26.47%
Other Resources-Beginning Fund Balance 100.00%
Uses 33.33%
Expenditures 5.49%
Ending Fund Balance 100.00%
Resources Over (Under) Uses $0 $8,882,956
$17,643,306 $967,938
$6,982,878 $6,982,878
$10,598,218 $2,805,806
$14,027,966 $14,027,966
$0 $2,669,811
Category Budget YTD Actual
$19,159,210 $4,550,316
$8,808,993 $8,808,993
$17,354,743 $5,415,660
$10,613,460 $10,613,460
$0
Category Budget YTD Actual
$4,976,258$4,976,258
$7,836,787$29,428,640
$11,276,111
Category Budget YTD Actual
$25,857,091
$8,547,807
$15,541,349
$8,547,807
Town of Prosper
Monthly Financial Report FY 2017/2018
Through the Month Ended January 2018
Unaudited - Intended for Management Purposes Only
The following is a summary of the Town's financial results for operating funds. This information is
summarized from financial statements for the monthly period that ended January 2018.
3
Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%GENERAL FUNDOriginal Budget Amended Current YearCurrent YearCurrent RemainingPrior YearChange fromBudget Adjustment Budget YTD Actuals Encumbrances Budget Balance YTD PercentNote YTD Actuals Prior YearREVENUESProperty Taxes 12,203,683$ ‐$ 12,203,683$ 10,818,304$ ‐$ 1,385,379$ 89%1 8,823,899$ 23%Sales Taxes 6,142,420 ‐ 6,142,420 1,919,036 ‐ 4,223,384 31%2 1,545,020 24%Franchise Fees 1,105,090 ‐ 1,105,090 204,335 ‐ 900,755 18%3 96,403 112%Building Permits 2,747,700 ‐ 2,747,700 1,262,736 ‐ 1,484,964 46%805,456 57%Other Licenses, Fees & Permits1,108,097 ‐ 1,108,097 595,878 ‐ 512,219 54%335,507 78%Charges for Services 406,133 ‐ 406,133 133,883 ‐ 272,250 33%4 102,528 31%Fines & Warrants 419,580 ‐ 419,580 159,894 ‐ 259,686 38%123,922 29%Intergovernmental Revenue (Grants) ‐ ‐ ‐ 1,932 ‐ (1,932) 3,577 Investment Income 147,930 ‐ 147,930 50,378 ‐ 97,552 34%36,562 38%Transfers In 896,634 ‐ 896,634 298,878 ‐ 597,756 33%363,722 ‐18%Miscellaneous 545,024 ‐ 545,024 53,243 ‐ 491,781 10%5 29,667 79%Park Fees 134,800 ‐ 134,800 42,852 ‐ 91,949 32%6 27,213 57% Total Revenues25,857,091$ ‐$ 25,857,091$ 15,541,349$ ‐$ 10,315,742$ 60%12,293,476$ 26%EXPENDITURESAdministration 5,651,869$ 5,000$ 5,656,869$ 1,238,844$ 313,908$ 4,104,117$ 27%1,219,477$ 2%Police 4,758,772 227,668 4,986,440 1,437,652 134,316 3,414,472 32%1,068,166 35%Fire/EMS 6,278,631 ‐ 6,278,631 1,990,933 62,351 4,225,348 33%1,299,752 53%Public Works 4,135,913 409,565 4,545,478 1,034,041 30,530 3,480,908 23%939,689 10%Community Services 3,959,067 239,195 4,198,262 1,119,400 152,950 2,925,913 30%628,351 78%Development Services 2,666,840 3,500 2,670,340 728,484 347,479 1,594,377 40%7 757,307 ‐4%Engineering 1,010,269 82,350 1,092,619 287,434 61,572 743,613 32%248,878 15% Total Expenses 28,461,361$ 967,279$ 29,428,640$ 7,836,787$ 1,103,106$ 20,488,747$ 30%6,161,621$ 27%REVENUE OVER (UNDER) EXPENDITURES (2,604,270)$ (967,279)$ (3,571,549)$ 7,704,562$ 6,131,855$ Beginning Fund Balance October 1‐Unassigned/Unrestricted 8,547,807$ 8,547,807$ 10,028,374$ Ending Fund Balance 4,976,258$ 16,252,369$ 16,160,229$ Notes1234567Park fees are for field reservations and as the weather improves this revenue category will increase accordingly.Development Services has encumbered funds for professional services and contracted services allotted for the entire year.The Town has collected 89.48% of current tax year levy through Janaury.Property taxes are billed in October and the majority of collections occur December through February.Miscellaneous revenue are for receipt of funds that are not classified to a specific area. Finance is not concerned with the receipts received to date.Sales tax is still coming in strong every month. January collections represent a 33.52% increase from the prior year's January collection.Franchise use fees are collected quarterly and annually. The first quarterly payment for most franchise fees was received in January.Charges for services are in line as some receipts are paid annually.4Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%WATER‐SEWER FUNDOriginal Budget Amended Current YearCurrent YearCurrent RemainingPrior YearChange fromBudget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD PercentNote YTD Actual Prior YearREVENUESWater Charges for Services10,250,224$ 47,489$ 10,297,713$ 2,635,531$ ‐$ 7,662,182$ 26%1 2,089,923$ 26%Sewer Charges for Services4,970,539 ‐ 4,970,539 1,503,923 ‐ 3,466,616 30%1 1,161,509 29%Sanitation Charges for Services1,149,760 ‐ 1,149,760 359,433 ‐ 790,327 31%1 419,082 ‐14%Licenses, Fees & Permits 108,706 ‐ 108,706 38,148 ‐ 70,558 35%31,588 21%Water Penalties1,850 ‐ 1,850 375 ‐ 1,475 20%1 425 ‐12%Utility Billing Penalties 99,225 ‐ 99,225 38,203 ‐ 61,022 39%35,829 7%Investment Income 71,421 ‐ 71,421 26,855 ‐ 44,566 38%22,674 18%Other117,178 ‐ 117,178 668,079 ‐ (550,901) 570%43,557 1434% Total Revenues 16,768,903$ 47,489$ 16,816,392$ 5,270,547$ ‐$ 11,545,845$ 31%3,804,588$ 39%EXPENDITURESAdministration 3,993,280$ 4,353$ 3,997,633$ 466,256$ (3,500)$ 3,534,877$ 12%965,606$ ‐52%Debt Service 2,973,872 ‐ 2,973,872 ‐ 2,973,872 ‐ 100%2 1,284,251 Water Purchases 4,153,586 47,489 4,201,075 1,400,353 ‐ 2,800,722$ 33%1,133,330 Public Works 6,895,211 492,847 7,388,058 2,605,132 188,325 4,594,601 38%3 1,599,015 63% Total Expenses 18,015,949$ 544,689$ 18,560,638$ 4,471,741$ 3,158,697$ 10,930,200$ 41%4,982,201$ ‐10%REVENUE OVER (UNDER) EXPENDITURES (1,247,046)$ (497,200)$ (1,744,246)$ 798,806$ (1,177,613)$ Beginning Working Capital October 1 10,638,969 10,638,969 9,110,072 Ending Working Capital 8,894,723$ 11,437,775$ 7,932,459$ Notes1Water, Sewer and Sanitation charges are in line for the four months of billing. Rate increases are reflected.2Debt service is encumbered for the entire budget. Principal and interest payments are paid in January and August.3Average MonthlyAverage CumulativeOctober10.0% 10.0%Jan‐18 Jan‐17Growth % November 7.7% 17.7%WATER SEWER WATER SEWER Change December 5.1% 22.8%# of Accts Residential7,033 6,363 6,263 5,606 12.87% January 4.4% 27.2%# of Accts Commercial293 220 243 160 27.30% February4.6%31.8%Consumption‐Residential52,157,710 42,170,403 50,328,05036,061,9559.19%March4.7%36.5%Consumption‐Commercial8,440,000 3,957,030 10,564,3503,432,080 ‐11.43%April6.6%43.1%Average Residential Water Consumption7,4168,036‐7.71%May7.1%50.2%Billed ($) Residential$350,955.88$310,817.91June8.4%58.6%Billed ($) Commercial$69,767.42$80,786.48July12.0% 70.6% Total Billed ($) $420,723.30 $364,651.11 $391,604.39$273,594.2118.07%August15.0% 85.6%September14.4% 100.0%rate change reflected in November billingPublic Works has purchased or encumbered funds for capital projects budgeted for the year along with annual contracts.5Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%DEBT SERVICE FUNDOriginal Budget Amended Current Year Current Year Current RemainingPrior YearChange fromBudget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD ActualPrior YearREVENUESProperty Taxes‐Delinquent141,463$ ‐$ 141,463$ 15,666$ ‐$ 125,797$ 11%1 216,881$ ‐93%Property Taxes‐Current 4,810,042 ‐ 4,810,042 4,473,051 ‐ 336,991 93%1 3,465,968 29%Taxes‐Penalties35,520 ‐ 35,520 3,969 ‐ 31,551 11%1 41,310 ‐90%Interest Income 36,000 ‐ 36,000 13,709 ‐ 22,291 38%7,201 90%Total Revenues 5,023,025$ ‐$ 5,023,025$ 4,506,394$ ‐$ 516,631$ 90%3,731,359$ 21%EXPENDITURESProfessional Services8,400$ ‐$ 8,400$ ‐$ ‐$ 8,400$ ‐$ 2008 CO Bond Payment 558,000 ‐ 558,000 ‐ 558,000 ‐ 100%2 558,225 2010 Tax Note Payment ‐ ‐ ‐ ‐ ‐ ‐ 368,376 2011 Refunding Bond Payment 117,000 ‐ 117,000 ‐ 117,000 ‐ 100%2 117,371 2012 GO Bond Payment 175,000 ‐ 175,000 ‐ 175,000 ‐ 100%2‐ 2013 GO Refunding Bond 155,000 ‐ 155,000 ‐ 155,000 ‐ 100%2 65,600 Bond Administrative Fees 7,650 ‐ 7,650 800 ‐ 6,850 10%2,000 ‐60%2014 GO Bond Payment 255,000 ‐ 255,000 ‐ 255,000 ‐ 100%2 58,421 2015 GO Bond Payment 170,000 ‐ 170,000 ‐ 170,000 ‐ 100%2 352,764 2015 CO Bond Payment 60,000 ‐ 60,000 ‐ 60,000 ‐ 100%2 217,700 2016 GO Debt Payment 374,100 ‐ 374,100 ‐ 374,100 ‐ 100%2502,115 2016 CO Debt Payment115,000 ‐ 115,000 ‐ 115,000 ‐ 100%2394,055 2017 CO Debt Payment575,000 ‐ 575,000 ‐ 575,000 ‐ 100%2‐ Bond Interest Expense2,148,158 ‐ 2,148,158 ‐ 2,148,158 ‐ 100%2‐ Total Expenditures4,718,308$ ‐$ 4,718,308$ 800$ 4,702,258$ 15,250$ 100%2,636,627$ 329578%REVENUE OVER (UNDER) EXPENDITURES304,717$ ‐$ 304,717$ 4,505,594$ 1,094,732$ Beginning Fund Balance October 12,147,247 2,147,247 1,841,724 Ending Fund Balance Current Month2,452,157$ 6,653,034$ 2,936,456$ Notes12 Debt service is encumbered for the entire year. Principal and interest are paid in January and August.Property taxes are billed in October and the majority of collections occur December through February.The Town has collected 89.48% of current tax year levy through Janaury.6Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%VEHICLE AND EQUIPMENT REPLACEMENT FUNDOriginal Budget Amended Current YearCurrent YearCurrent RemainingPrior Year Change fromBudget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior YearREVENUESCharges for Services ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ 166,927$ ‐100%Other Reimbursements20,000 ‐ 20,000 ‐ ‐ 20,000 0%1‐ Interest Income 15,000 ‐ 15,000 6,130 ‐ 8,870 41%5,064 Transfers In1,069,091 ‐ 1,069,091 354,825 ‐ 714,266 33%‐ Total Revenue 1,104,091$ ‐$ 1,104,091$ 360,955$ ‐$ 743,136$ 33%171,991$ 110%EXPENDITURESVehicle Replacement 335,433$ ‐$ 335,433$ 35,280$ 231,678$ 68,475$ 80%278,400$ Equipment Replacement48,800 ‐ 48,800 9,425 ‐ 39,375 0%‐ Technology Replacement94,700 ‐ 94,700 79,589 ‐ 15,111 84%2438 Total Expenditures478,933$ ‐$ 478,933$ 124,293$ 231,678$ 122,961$ 74%78,838$ REVENUE OVER (UNDER) EXPENDITURES625,158$ ‐$ 625,158$ 236,662$ 93,153$ Beginning Fund Balance October 11,710,537 1,710,537 1,677,754 Ending Fund Balance Current Month2,335,695$ 1,947,199$ 1,770,907$ Notes1 Auction revenues and insurance reimbursements are placed in the Other Reimbursements accountas they occur. 2Funds have been expended or encumbered for this year's replacement vehicles and technology.7Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%STORM DRAINAGE UTILITY FUNDOriginal Budget Amended Current YearCurrent YearCurrent RemainingPrior Year Change fromBudget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior YearREVENUES 45‐4Storm Drainage Utility Fee528,351$ ‐$ 528,351$ 143,018$ ‐$ 385,333$ 27%1 97,408$ 47% 45‐4Interest Income10,000 ‐ 10,000 2,094 ‐ 7,906 21%23,654 ‐43%Other Revenue‐ ‐ ‐ ‐ ‐ ‐ ‐ Total Revenue538,351$ ‐$ 538,351$ 145,113$ ‐$ 393,238$ 27%101,063$ 44%EXPENDITURESPersonnel Services 150,649$ ‐$ 150,649$ 29,781$ ‐$ 120,868$ 20%43,696$ ‐32%Debt Service291,545 ‐ 291,545 ‐ 291,545 ‐ 100%3 179,258 45‐7Operating Expenditures20,700 4,250 24,950 4,984 ‐ 19,966 20%1,125 343%Transfers Out 131,428 ‐ 131,428 43,809 ‐ 87,619 33%38,522 14% Total Expenses594,322$ 4,250$ 598,572$ 78,575$ 291,545$ 228,452$ 62%262,600$ ‐70%REVENUE OVER (UNDER) EXPENDITURES(55,971)$ (4,250)$ (60,221)$ 66,538$ (161,537)$ Beginning Working Capital October 1(25,509) (25,509) 143,413 Ending Working Capital Current Month(85,730)$ 41,029$ (18,124)$ Note1Storm drainage fees are in line for billing. Rate increases are reflected.23Interest income is recorded when received. The Town has unrealized gain on interest. Budget projections are higher than actuals.Debt service is encumbered for the entire budget. Principal and interest payments are paid in January and August.8Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%PARK DEDICATION AND IMPROVEMENT FUNDSOriginal Budget Amended Current YearCurrent YearCurrent RemainingPrior Year Change fromBudget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior YearREVENUES 60‐4Park Dedication‐Fees 370,718$ ‐$ 370,718$ ‐$ ‐$ 370,718$ 0%227,401$ ‐100% 60‐4Park Improvements 1,298,000 ‐ 1,298,000 ‐ ‐ 1,298,000 0%113,330 ‐100%Contributions/Grants‐ ‐ ‐ 36,310 ‐ (36,310) 3‐ 60‐4Interest‐Park Dedication 10,000 ‐ 10,000 6,968 ‐ 3,032 70%2,793 149% 60‐4Interest‐Park Improvements 8,000 ‐ 8,000 5,281 ‐ 2,719 66%2,521 109% Total Revenue1,686,718$ ‐$ 1,686,718$ 48,559$ ‐$ 1,638,159$ 3%346,045$ ‐86%EXPENDITURES 60‐5Miscellaneous Expense‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Professional Services‐Park Ded‐ ‐ ‐ ‐ ‐ ‐ ‐ 60‐5Professional Services‐Park Imp‐ ‐ ‐ ‐ ‐ ‐ ‐ Developer Reimbursement‐Park Imp ‐ ‐ ‐ ‐ ‐ ‐ ‐ 60‐6Capital Exp‐Park Imp570,000 803,985 1,373,985 277,704 594,031 502,250 63%1 102,925 60‐6Capital Exp‐Park Ded1,160,000 440,658 1,600,658 6,700 453,308 1,140,650 29%2‐ Transfers Out ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total Expenses1,730,000$ 1,244,642$ 2,974,642$ 284,404$ 1,047,338$ 1,642,900$ 45%102,925$ 176%REVENUE OVER (UNDER) EXPENDITURES(43,282)$ (1,244,642)$ (1,287,924)$ (235,845)$ 243,120$ Beginning Fund Balance October 13,683,496 3,683,496 2,148,564 Ending Fund Balance Current Month2,395,572$ 3,447,651$ 2,391,684$ Notes1 Frontier Park North Field Improvements ‐ design and CMAR services and encumbrance for contract. 2 Frontier Park North Field Improvements ‐ CMAR services and encumbrance for contract. 3FY 2016‐2017 Town of Prosper received the following grant funds:Grant proceeds from Texas Parks & Wildlife $413,325 for Frontier Park North project.Grant proceeds from Collin County $167,802 for Frontier Park North project.FY 2017‐2018 Town of Prosper received the following grant funds:Grant proceeds from Texas Parks & Wildlife $36,310 for Frontier Park North project.9Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%TIRZ #1 ‐ BLUE STAROriginal Budget Amended Current Year Current Remaining Prior Year Change fromBudget Adjustment Budget YTD Actual Budget Balance YTD PercentNoteYTD Actual Prior YearREVENUESImpact Fee Revenue:Water Impact Fees 19,105$ ‐$ 19,105$ ‐$ 19,105$ 0%‐$ Wastewater Impact Fees 14,110 ‐ 14,110 ‐ 14,110$ 0%‐ East Thoroughfare Impact Fees 332,938 ‐ 332,938 ‐ 332,938$ 0%‐ Property Taxes ‐ Town (Current) 212,036 ‐ 212,036 ‐ 212,036$ 0%‐ Property Taxes ‐ Town (Rollback) ‐ ‐ ‐ ‐ ‐$ ‐ Property Taxes ‐ County (Current) 84,975 ‐ 84,975 ‐ 84,975$ 0%‐ Sales Taxes ‐ Town 365,000 ‐ 365,000 20,791 344,209$ 6%‐ Sales Taxes ‐ EDC203,792 ‐ 203,792 17,412 186,380$ 9%‐ Investment Income 20,000 ‐ 20,000 639 19,361$ 3%‐ Other Revenue‐ ‐ ‐ ‐ ‐$ Total Revenue1,251,956$ ‐$ 1,251,956$ 38,842$ 1,213,114$ 3%‐$ EXPENDITURESProfessional Services ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Developer Rebate 1,245,915 ‐ 1,245,915 ‐ 1,245,915 0%‐ Transfers Out ‐ ‐ ‐ ‐ ‐ Total Expenses 1,245,915$ ‐$ 1,245,915$ ‐$ 1,245,915$ 0%‐$ REVENUE OVER (UNDER) EXPENDITURES 6,041$ 38,842$ ‐$ Beginning Fund Balance October 1 187,499 187,499 (7,500) Ending Fund Balance Current Month 193,540$ 226,341$ (7,500)$ NoteBreakout of Rollback Taxes for all receiving entities:This was reported and collected in Tax Roll 2016Collin CountyCollin CollegeProsper ISD Town of ProsperTotal Annual2010 26,367.03 9,481.15 179,076.09 57,128.58 245,685.82 2011 25,008.06 8,992.48 174,014.48 54,184.15 237,191.11 2012 23,633.32 8,498.06 164,448.53 51,205.53 224,152.12 2013 21,708.96 7,645.48 152,648.25 47,531.19 207,824.92 2014 25,225.28 8,797.72 179,260.51 55,817.65 243,875.88 Total By Entity121,942.65 43,414.89 849,447.86 265,867.10 1,158,729.85 10Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%TIRZ #2 ‐ MATTHEWS SOUTHWESTOriginal Budget Amended Current YearPrior Year Change fromBudget Adjustment BudgetYTD Actual YTD Percent Note YTD Actual Prior YearREVENUESImpact Fee Revenue:West Thoroughfare Impact Fees206,190$ ‐$ 206,190$ ‐$ 0%‐$ Property Taxes ‐ Town (Current)‐ ‐ ‐ ‐ ‐ Property Taxes ‐ Town (Rollback)‐ ‐ ‐ ‐ ‐ Property Taxes ‐ County (Current)‐ ‐ ‐ ‐ ‐ Sales Taxes ‐ Town‐ ‐ ‐ 4 Sales Taxes ‐ EDC‐ ‐ ‐ 4 Investment Income‐ ‐ ‐ 84 ‐ Total Revenue206,190$ ‐$ 206,190$ 93$ 0%‐$ EXPENDITURESProfessional Services‐$ ‐$ ‐$ ‐$ ‐$ Developer Rebate206,978 ‐ 206,978 ‐ 0%‐ Transfers Out‐ ‐ ‐ ‐ ‐ Total Expenditures206,978$ ‐$ 206,978$ ‐$ 0%‐$ REVENUE OVER (UNDER) EXPENDITURES(788)$ 93$ ‐$ Beginning Fund Balance October 125,477 25,477 ‐ Ending Fund Balance Current Month24,689$ 25,570$ ‐$ 11Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%WATER IMPACT FEES FUNDCurrent Year Current Year Current YearProjectProject Original Budget Amended Current Year Current Year Current Remaining Prior Years BudgetSTATUS OF Budget Budget Adjustment BudgetActual Encumbrances Budget Balance Expenditure BalancePROJECTREVENUESImpact Fees Water3,584,000$ ‐$ 3,584,000$ 1,194,242$ Interest ‐ Water40,000 ‐ 40,000 15,422 Total Revenues3,624,000$ ‐$ 3,624,000$ 1,209,664$ EXPENDITURESDeveloper ReimbursementsTVG Westside Utility Developer Reimb975,000$ 975,000$ ‐$ 975,000$ 74,100 ‐$ 900,900$ 900,900$ Parks at Legacy Developer Reimb 25,000 25,000 ‐ 25,000 ‐ 25,000 25,000 Prosper Partners Developer Reimb 129,750 129,750 ‐ 129,750 ‐ ‐ 129,750 129,750 PISD High School Developer Reimb 89,525 89,525 ‐ 89,525 ‐ ‐ 89,525 89,525 Prosper Lakes Developer Reimb 97,500 97,500 ‐ 97,500 ‐ ‐ 97,500 97,500 Star Trail Developer Reimb 292,500 292,500 ‐ 292,500 292,500 292,500 TVG Windsong Developer Reimb 100,000 100,000 ‐ 100,000 ‐ 100,000 100,000 Total Developer Reimbursements 1,709,275$ 1,709,275$ ‐$ 1,709,275$ 74,100$ ‐$ 1,635,175$ ‐$ 1,635,175$ Capital ExpendituresImpact Fee Study 67,473$ 9,637$ ‐$ 9,637$ ‐$ ‐$ 9,637$ 57,836$ 9,637$ Prosper Trail EST 4,403,300 1,044,171 ‐ 1,044,171 40,500 70,200 933,471 3,394,643 897,957 Construction substantially completeLower Pressure Plane Pump Station Design 127,081 ‐ ‐ ‐ ‐ ‐ ‐ 138,416 (11,335) County Line Elevated Storage 565,700 240,450 278,789 519,239 52,382 228,507 238,350 44,361 240,450 Design 70% complete ‐ construction start date: Summer 201824" WL Connector County Line EST3,029,850 2,232,850 ‐ 2,232,850 133,864 590,071 1,508,916 189,376 2,116,540 Design 70% complete ‐ construction start date: Summer 2018Custer Road Pump Station Expansion134,100 134,100 ‐ 134,100 12,126 88,050 33,924 37,124 (3,200) Design 70% complete ‐ construction start date: Summer 201842" Lovers Lane Transmission Line925,590 33,118 4,346 37,464 ‐ 4,346 33,118 892,472 28,772 Construction completeLower Pressure Plane Easements1,487,150 1,487,150 ‐ 1,487,150 ‐ ‐ 1,487,150 ‐ 1,487,150 Total Projects10,740,244$ 5,181,476$ 283,134$ 5,464,610$ 238,871$ 981,173$ 4,244,566$ 4,608,014$ 4,912,186$ Total Expenditures12,449,519$ 6,890,751$ 283,134$ 7,173,885$ 312,971$ 981,173$ 5,879,741$ 4,608,014$ 6,547,361$ REVENUE OVER (UNDER) EXPENDITURES(3,549,885)$ 896,692$ Beginning Fund Balance October 13,704,070 3,704,070 Ending Fund Balance Current Month154,185$ 4,600,762$ 12Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%WASTEWATER IMPACT FEES FUNDCurrent Year Current Year Current YearProjectProject Original Budget Amended Current Year Current Year Current Remaining Prior Years BudgetSTATUS OF Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure BalancePROJECTREVENUESImpact Fees Wastewater 600,000$ ‐$ 600,000$ 193,578$ Interest ‐ Wastewater 10,000 ‐ 10,000 3,891 Upper Trinity Equity Fee ‐ ‐ ‐ 77,000 Total Revenues 610,000$ ‐$ 610,000$ 274,469$ EXPENDITURESDeveloper ReimbursementsLaCima Developer Reimb 10,000$ 10,000$ ‐$ 10,000$ ‐$ ‐$ 10,000$ ‐$ 10,000$ TVG Westside Utility Developer Reimb 170,750 170,750 ‐ 170,750 ‐ ‐ 170,750 ‐ 170,750 Prosper Partners Utility Developer Reimb 34,150 34,150 ‐ 34,150 ‐ ‐ 34,150 ‐ 34,150 Frontier Estates Developer Reimb 51,225 51,225 ‐ 51,225 ‐ ‐ 51,225 ‐ 51,225 Brookhollow Developer Reimb 5,000 5,000 ‐ 5,000 ‐ 5,000 ‐ 5,000 TVG Windsong Developer Reimb 68,300 68,300 ‐ 68,300 ‐ ‐ 68,300 ‐ 68,300 All Storage Developer Reimb 15,000 15,000 15,000 Total Developer Reimbursements 354,425$ 354,425$ ‐$ 354,425$ ‐$ ‐$ 339,425$ ‐$ 339,425$ Capital ExpendituresPublic Works Interceptor1,045,000 227,598 85,672 227,598 72,892 12,781 141,926 817,402 141,926 Construction completeTotal Projects1,045,000$ 227,598$ 85,672$ 227,598$ 72,892$ 12,781$ 141,926$ 817,402$ 141,926$ Total Expenditures1,399,425$ 582,023$ 85,672$ 582,023$ 72,892$ 12,781$ 481,351$ 817,402$ 481,351$ REVENUE OVER (UNDER) EXPENDITURES27,977$ 201,578$ Beginning Fund Balance October 11,017,459 1,017,459 Ending Fund Balance Current Month1,045,436$ 1,219,037$ 13Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018Expected Year to Date Percent 33.33%THOROUGHFARE IMPACT FEES FUNDCurrent YearCurrent YearCurrent YearProjectProject Original Budget Amended Current YearCurrent YearCurrent Remaining Prior Years BudgetSTATUS OF Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure BalancePROJECTREVENUES East Thoroughfare Impact Fees 2,785,000$ ‐$ 2,785,000$ 694,135$ West Thoroughfare Impact Fees1,850,000 ‐ 1,850,000 558,570 Interest‐East Thoroughfare Impact Fees35,000 ‐ 35,000 17,580 Interest‐West Thoroughfare Impact Fees 7,500 ‐ 7,500 2,830 Total Revenues4,677,500$ ‐$ 4,677,500$ 1,273,115$ EXPENDITURESEastImpact Fee Reimbursement Lakes of LaCima 300,000 ‐ ‐ ‐ ‐ ‐ ‐ 199,029 100,971 Frontier Pkwy BNSF Overpass3,680,000 3,680,000 ‐ 3,680,000 ‐ ‐ 3,680,000 ‐ 3,680,000 Planning stage‐all parties agreed to shared contributionProsper Trail (Kroger ‐ Coit) 305,000 3,000,000 (3,000,000) ‐ 44,137 ‐ (44,137) 260,863 ‐ Design 99% complete‐construction start Winter 2018Prosper Trail (Coit ‐ Custer)610,000 ‐ 426,582 426,582 46,381 337,096 43,105 226,522 ‐ Design 30% complete‐field survey 100% completeCoit Road (First ‐ Frontier)689,900 ‐ 350,156 350,156 99,279 250,877 ‐ 339,744 ‐ Design 60% completeFirst St. DNT‐Coleman‐EAST585,000 193,805 ‐ 193,805 (241) ‐ 194,046 391,195 194,047 Design 70% completeFM2478 ROW (US380‐FM1461)80,000 80,000 ‐ 80,000 80,000 ‐ ‐ ‐ ‐ Agreement with TxDOTTotal East9,249,900$ 6,953,805$ (2,223,262)$ 4,730,543$ 269,556$ 587,973$ 3,873,014$ 1,446,806$ 6,945,565$ WestTVG Developer Reimb 1,000,000 ‐ 1,000,000 1,000,000 ‐ ‐ 1,000,000 ‐ 1,000,000 Parks at Legacy Developer Reimb 250,000 ‐ 250,000 250,000 ‐ ‐ 250,000 ‐ 250,000 Star Trail Developer Reimb 400,000 400,000 400,000 ‐ ‐ 400,000 ‐ 400,000 275,000 198,040 75,000 273,040 ‐ 249,686 23,354 1,960 23,354 First St. DNT‐Coleman‐EAST465,672 125,072 ‐ 125,072 28,116 ‐ 96,957 340,600$ 96,957 Design 70% completeTotal West2,390,672$ 723,112$ 1,325,000$ 2,048,112$ 28,116$ 249,686$ 1,770,311$ 342,560$ 1,770,311$ Total Expenditures11,640,572$ 7,676,917$ (898,262)$ 6,778,655$ 297,672$ 837,659$ 5,643,325$ 1,789,366$ 8,715,876$ REVENUE OVER (UNDER) EXPENDITURES(2,101,155)$ 975,443$ Beginning Fund Balance October 15,488,841 5,488,841 Ending Fund Balance Current Month3,387,686$ 6,464,284$ Cook Lane (First ‐ End)14Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTDecember 31, 2017Expected Year to Date Percent 25%SPECIAL REVENUE FUNDSOriginal Budget Amended Current Year Current Year Current RemainingPrior Year Change fromBudget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Obligated Prior YearPolice Donation Revenue 15,000$ ‐$ 15,000$ 6,522$ ‐$ 8,478$ 43%6,496$ 0%Police Grant ‐ ‐ ‐ ‐ ‐ ‐ ‐ Fire Donation Revenue 14,000 ‐ 14,000 4,446 ‐ 9,554 32%4,590 ‐3%Child Safety Revenue 5,000 ‐ 5,000 341 ‐ 4,659 7%370 Court Security Revenue 7,700 ‐ 7,700 3,073 ‐ 4,627 40%‐ Court Technology Revenue 10,395 ‐ 10,395 4,098 ‐ 6,297 39%‐ LEOSE Revenue 2,000 ‐ 2,000 ‐ ‐ 2,000 ‐ Library Grant ‐ ‐ ‐ ‐ ‐ ‐ ‐ Interest Income 2,765 ‐ 2,765 1,077 ‐ 1,688 39%‐ Tree Mitigation Revenue ‐ ‐ ‐ 27,475 ‐ (27,475) ‐ Cash Seizure/Forfeiture‐ ‐ ‐ ‐ ‐ ‐ ‐ Donations ‐ ITTCC1,000 ‐ 1,000 ‐ ‐ 1,000 ‐ Transfer In‐ ‐ ‐ ‐ ‐ ‐ ‐ Total Revenue57,860$ ‐$ 57,860$ 47,032$ ‐$ 10,828$ 81%11,456$ 311%EXPENDITURESLEOSE Expenditure‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Court Technology Expense ‐ ‐ ‐ ‐ ‐ ‐ ‐ Court Security Expense 10,099 ‐ 10,099 2,350 ‐ 7,749 23%‐ Police Donation Expense10,000 ‐ 10,000 2,800 ‐ 7,200 28%5,604 Fire Donation Expense5,000 36,618 41,618 30,230 ‐ 11,388 88 Child Safety Expense 5,000 ‐ 5,000 1,054 ‐ 3,946 21%‐ Tree Mitigation Expense10,000 ‐ 10,000 ‐ ‐ 10,000 0%‐ Library Grant Expense‐ ‐ ‐ ‐ ‐ ‐ ‐ Police Seizure Expense5,000 ‐ 5,000 400 3,000 1,600 68%92 Total Expenses45,099$ 36,618$ 81,717$ 36,835$ 3,000$ 41,882$ 45%5,783$ REVENUE OVER (UNDER) EXPENDITURES12,761$ (36,618)$ (23,857)$ 10,198$ 5,673$ Beginning Fund Balance October 11,715,850$ 1,715,850$ 1,143,867$ Ending Fund Balance Current Month1,691,993$ 1,726,048$ 1,149,540$ 15Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTJanuary 31, 2018CAPITAL PROJECTS FUND‐GENERALCurrent Year Current Year Current YearProjectProject Original Budget Amended Current Year Current Year Current Remaining Prior Years BudgetSTATUS OF Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure BalancePROJECTREVENUESGrants‐$ ‐$ ‐$ ‐$ Contributions/Interlocal Revenue ‐ ‐ ‐ ‐ Bond Proceeds 18,535,000 ‐ 18,535,000 ‐ Interest 125,000 ‐ 125,000 29,331 Interest‐2004 Bond 2,000 ‐ 2,000 734 Interest‐2006 Bond 1,600 ‐ 1,600 1,130 Interest‐2008 Bond 1,000 ‐ 1,000 299 Interest‐2012 GO Bond 1,000 ‐ 1,000 392 Interest‐2015 Bond 25,000 ‐ 25,000 8,403 Interest‐2016 Bond 20,000 ‐ 20,000 3,489 Interest‐2017 Bond 25,000 25,000 6,489 Transfers In‐Impact Fee Funds 920,000 ‐ 920,000 306,667 Transfers In‐Bond Funds ‐ ‐ ‐ 3,133,406 Total Revenues19,655,600$ ‐$ 19,655,600$ 3,490,340$ EXPENDITURESDowntown Enhancements 1,850,000 1,702,400 411,959 2,114,359 4,000 25,000 2,085,359 126,600 1,694,400 Design 95% complete‐construction start date: Winter 2018West Prosper Roads 12,781,000 4,886,842 4,886,842 4,909 4,872,833 9,100 7,644,159 259,100 Phase 1‐Construction complete‐ ‐ Phase 2‐design 98% complete; construction start date: Summar 2018Phase 3‐design 90% complete; construction start date: Fall 2018Prosper Trail (Kroger to Coit)3,965,000 702,022 ‐ 702,022 53,829 20,415 627,778 272,978 3,922,778 Design 99% complete‐construction start date: Winter 2018First Street (DNT to Coleman)1,076,000 361,212 133,461 361,212 15,286 133,461 212,465 571,177 356,076 Design 70% completeOld Town Streets 2015 (Broadway,Fifth, McKinley)1,000,000 1,000,000 ‐ 1,000,000 98,825 56,175 845,000 ‐ 845,000 Design survey, preliminary plans 30% complete and survey 90% completeMain Street (First ‐ Broadway) 625,000 150 442,067 442,217 26,132 389,427 26,658 182,783 36 Construction 31% completeEighth Street (Church‐PISD) 260,000 260,000 ‐ 260,000 ‐ ‐ 260,000 ‐ 260,000 Project moved to 2020‐2025Church Street (First‐PISD) 750,000 ‐ ‐ ‐ ‐ ‐ ‐ 684,360 65,640 Project completeField Street (First‐Broadway) 250,000 250,000 ‐ 250,000 ‐ ‐ 250,000 ‐ 250,000 Project moved to 2020‐2025Parvin Road (Good Hope‐FM1385) 270,000 270,000 ‐ 270,000 ‐ ‐ 270,000 ‐ 270,000 Project moved to 2020‐2025Pasewark (Preston‐Hickory) 400,000 400,000 ‐ 400,000 ‐ ‐ 400,000 ‐ 400,000 Project moved to 2020‐2025Parvin (Broadway‐Eighth) 515,000 126,021 (117,001) 9,020 9,020 ‐ ‐ 379,960 126,021 Construction complete‐remaining funds moved to Downtown EnhancementsSixth Street (Coleman‐Church)430,000 177,702 (54,277) 123,426 123,426 ‐ ‐ 128,873 177,702 Construction complete‐remaining funds moved to Downtown EnhancementsThird Street (Church‐Lane)320,000 87,236 137,929 225,165 225,165 ‐ ‐ 7,600 87,236 Construction complete‐remaining funds moved to Downtown EnhancementsTown Hall Infrastructure Improvements1,337,550 206,607 703,672 910,279 185,965 502,907 221,407 615,628 33,050 Construction 78% completeWindsong Ranch, Phase I (Acacia Parkway)1,022,782 1,022,782 ‐ 1,022,782 184,062 685,219 153,501 3,769 149,732 Construction 40% completeWindsong Ranch, Phase 2 1,630,000 ‐ 1,630,000 1,630,000 907,255 12,700 710,045 ‐ 710,045 Construction 40% completeFithth Street (Coleman ‐ Church)375,000 375,000 ‐ 375,000 ‐ ‐ 375,000 ‐ 375,000 Third Street (Main ‐ Coleman)250,000 250,000 ‐ 250,000 ‐ ‐ 250,000 ‐ 250,000 Total Street Projects29,412,332$ 7,191,132$ 8,174,652$ 15,232,322$ 1,837,873$ 6,698,137$ 6,696,312$ 10,617,885$ 10,231,815$ Decorative Monument Street Signs150,000 34,514 ‐ 34,514 ‐ ‐ 34,514 115,486 34,514 Substantial completion scheduled March 31, 2018Coit Rd & Prosper Trail ‐ traffic signal230,000 220,000 ‐ 220,000 35,378 169,468 15,154 ‐ 15,154 Construction 95% completeTotal Traffic Projects380,000$ 254,514$ ‐$ 254,514$ 35,378$ 169,468$ 49,668$ 115,486$ 49,669$ Frontier Park ‐ North Field Improvements10,684,705$ 495,090$ 2,404,301$ 2,899,391$ 2,315,628$ 88,673$ 495,090$ 7,161,424$ 1,118,980$ Construction substantially completeTotal Park Projects10,684,705$ 495,090$ 2,404,301$ 2,899,391$ 2,315,628$ 88,673$ 495,090$ 7,161,424$ 1,118,980$ Town Hall Professional Services2,241,540 200,000 161,575 361,575 104,698 52,183 204,695 2,095,680 (11,021) Town Hall Multipurpose Facility19,989,691 385,500 9,124,285 9,509,785 2,761,597 6,502,259 245,929 10,479,906 245,929 Construction 78% completeTown Hall ‐ FF&E1,362,000 1,362,000 ‐ 1,362,000 215,380 362,463 784,157 2,335 781,822 Library furniture approved Jan 2018; Admin FF&E to Council Feb 13, 2018Windsong FS Apparatus1,078,000 ‐ 281,089 281,089 262,982 ‐ 18,107 804,082 10,936 CompletePublic Safety Complex, Phase 11,000,000 1,000,000 ‐ 1,000,000 ‐ ‐ 1,000,000 ‐ 1,000,000 Parks and Public Works Complex900,000 900,000 ‐ 900,000 ‐ ‐ 900,000 ‐ 900,000 Total Facility Projects26,571,231$ 3,847,500$ 9,566,949$ 13,414,449$ 3,344,656$ 6,916,905$ 3,152,888$ 13,382,003$ 2,927,666$ Transfer Out ‐ GF‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Total Expenditures67,048,268$ 11,788,236$ 20,145,901$ 31,800,676$ 7,533,534$ 13,873,183$ 10,393,958$ 31,276,798$ 14,328,130$ REVENUE OVER (UNDER) EXPENDITURES(12,145,076)$ (4,043,195)$ Beginning Fund Balance October 112,223,073 12,223,073 Ending Fund Balance Current Month77,997$ 8,179,878$ 16Item 5b
TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORTDecember 31, 2017CAPITAL PROJECTS FUND‐WATER/SEWERCurrent Year Current Year Current YearProjectProject Original Budget Amended Current Year Current Year Current Remaining Prior Year BudgetSTATUS OF Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure BalancePROJECTNoteREVENUESInterest Income 30,000$ ‐$ 30,000$ 6,688$ Interest‐2016 Bond 3,500 3,500 1,606 Interest‐2017 Bond 4,000 4,000 3,021 Bond Proceeds 11,150,000 ‐ 11,150,000 ‐ Transfers In‐ ‐ ‐ 488,738 Total Revenues11,187,500$ ‐$ 11,187,500$ 500,053$ EXPENDITURESPRV's at BNSF Railroad 582,000$ 434,215$ ‐$ 434,215$ ‐$ ‐$ 434,215$ 147,785$ 434,215$ Pre‐ConstructionLower Pressure Plane Pump Station Design 1,435,100 1,325,503 ‐ 1,325,503 ‐ 39,286 1,286,217 109,597 1,286,217 Construction complete for Lovers Lane; design 70% completeProsper Trail EST Construction 517,300 25,981 9,650 35,631 ‐ 9,650 25,981 481,669 25,981 Construction substantially complete FishTrap EST (South) 5,415,000 5,415,000 ‐ 5,415,000 ‐ ‐ 5,415,000 ‐ 5,415,000 Water Supply Line Phase 1 9,694,479 9,694,479 ‐ 9,694,479 ‐ ‐ 9,694,479 ‐ 9,694,479 Design 50% complete; construction start date: Summer 2018Water Supply Line Phase 1 Easement Costs 1,941,500 1,941,500 ‐ 1,941,500 ‐ ‐ 1,941,500 ‐ 1,941,500 Design 50% complete; construction start date: Summer 2018Total Water Projects19,585,379$ 18,836,678$ 9,650$ 18,846,328$ ‐$ 48,936$ 18,797,392$ 739,050$ 18,797,393$ Old Town Drainage 500,000 448,800 12,460 461,260 ‐ 12,460 448,800 38,740 448,800 Design 95% complete‐construction start date: Summer 2018Coleman Rd Drainage 300,000 279,150 3,350 282,500 ‐ 3,350 279,150 17,500 279,150 Old Town Land Drainage Land Acq 925,000 285,654 185,000 470,654 454,189 10,000 6,465 79,297 381,514 Old Town Drainage Broadway Design & Construction 575,000 200,000 (175,000) 25,000 ‐ ‐ 25,000 ‐ 575,000 Old Town Drainage Trunk Main 600,000 ‐ (64,983) 1,235 ‐ 1,235 ‐ 598,765 ‐ Construction completeOld Town Drainage‐First and Main 800,000 118,985 153,820 272,805 140,000 13,820 118,985 441,177 205,003 Amberwood Farms Drainage 32,000 32,000 ‐ 32,000 ‐ ‐ 32,000 ‐ 32,000 Project on holdOld Town Drainage Fifth Street Trunk Main 400,000 400,000 ‐ 400,000 ‐ ‐ 400,000 ‐ 400,000 Total Drainage Projects4,132,000$ 1,764,589$ 114,647$ 1,945,454$ 594,189$ 40,865$ 1,310,400$ 1,175,478$ 2,321,468$ Transfer out615,739 Total Expenses23,717,379$ 20,601,267$ 124,297$ 20,791,782$ 1,209,928$ 89,801$ 20,107,792$ 1,914,528$ 21,118,860$ (9,604,282)$ (709,875)$ Beginning Working Capital October 118,679,114 18,679,114 Ending Working Capital Current Month9,074,832$ 17,969,239$ 17Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐4035‐10‐00 3% Construction Fee‐ 505,330.00 ‐ 505,330.00 ‐ 386,043.80 76.39 ‐ 119,286.20 100‐4061‐10‐00 Notary Fees‐ 200.00 ‐ 200.00 ‐ 62.00 ‐ 16.00 31.00 ‐ 138.00 100‐4105‐10‐00 Property Taxes ‐Delinquent‐ 135,952.00 ‐ 135,952.00 ‐ 30,059.41 ‐ 20,509.57 22.11 ‐ 105,892.59 100‐4110‐10‐00 Property Taxes ‐Current‐ 12,017,913.00 ‐ 12,017,913.00 ‐ 10,779,311.83 ‐ 3,736,513.06 89.69 ‐ 1,238,601.17 100‐4115‐10‐00 Taxes ‐Penalties‐ 49,818.00 ‐ 49,818.00 ‐ 8,932.41 ‐ 4,923.88 17.93 ‐ 40,885.59 100‐4120‐10‐00 Sales Taxes‐ 6,142,420.00 ‐ 6,142,420.00 ‐ 1,919,036.08 ‐ 454,433.05 31.24 ‐ 4,223,383.92 100‐4130‐10‐00 Sales Tax‐Mixed Beverage‐ 23,414.00 ‐ 23,414.00 ‐ 9,059.69 ‐ 9,059.69 38.69 ‐ 14,354.31 100‐4140‐10‐00 Franchise Taxes ‐ Electric‐ 505,324.00 ‐ 505,324.00 ‐ 107,850.37 ‐ 107,850.37 21.34 ‐ 397,473.63 100‐4150‐10‐00 Franchise Taxes ‐ Telephone‐ 193,576.00 ‐ 193,576.00 ‐ 784.16 ‐ 470.59 0.41 ‐ 192,791.84 100‐4160‐10‐00 Franchise Taxes ‐ Gas‐ 102,138.00 ‐ 102,138.00 ‐ 102,138.00 100‐4170‐10‐00 Franchise Taxes ‐ Road Usage‐ 38,000.00 ‐ 38,000.00 ‐ 10,263.07 ‐ 10,063.76 27.01 ‐ 27,736.93 100‐4185‐10‐00 Franchise Fee ‐ W/S Fund‐ 225,539.00 ‐ 225,539.00 ‐ 225,539.00 100‐4190‐10‐00 Franchise Fee‐Cable‐ 40,513.00 ‐ 40,513.00 ‐ 10,257.38 ‐ 10,257.38 25.32 ‐ 30,255.62 100‐4200‐10‐00 T‐Mobile Fees‐ 51,489.00 ‐ 51,489.00 ‐ 11,535.00 ‐ 2,883.75 22.40 ‐ 39,954.00 100‐4201‐10‐00 Tierone Converged Network‐ 18,000.00 ‐ 18,000.00 ‐ 6,000.00 ‐ 1,500.00 33.33 ‐ 12,000.00 100‐4202‐10‐00 NTTA Tag Sales‐ 150.00 ‐ 150.00 ‐ 85.00 ‐ 30.00 56.67 ‐ 65.00 100‐4205‐10‐00 Blue Wireless Fees (Panaband)‐ 25,888.00 ‐ 25,888.00 ‐ 9,125.24 ‐ 2,281.31 35.25 ‐ 16,762.76 100‐4206‐10‐00 Verizon Antenna Lease‐ 32,200.00 ‐ 32,200.00 ‐ 32,200.00 100‐4218‐10‐00 Administrative Fees‐EDC‐ 15,000.00 ‐ 15,000.00 ‐ 5,000.00 ‐ 1,250.00 33.33 ‐ 10,000.00 100‐4230‐10‐00 Other Permits‐ 1,165.00 ‐ 1,165.00 ‐ 870.00 ‐ 810.00 74.68 ‐ 295.00 100‐4610‐10‐00 Interest Income‐ 147,930.00 ‐ 147,930.00 ‐ 50,378.22 ‐ 9,720.59 34.06 ‐ 97,551.78 100‐4910‐10‐00 Other Revenue‐ 475,000.00 ‐ 475,000.00 ‐ 8,073.91 ‐ 6,424.32 1.70 ‐ 466,926.09 100‐4995‐10‐00 Transfer In/Out‐ 896,634.00 ‐ 896,634.00 ‐ 298,878.00 ‐ 74,719.50 33.33 ‐ 597,756.00 100‐4410‐10‐07 Court Fines‐ 419,580.00 ‐ 419,580.00 ‐ 159,893.72 ‐ 35,358.75 38.11 ‐ 259,686.28 100‐4930‐10‐99 Insurance Proceeds‐ 7,009.22 ‐ 147.20 7,009.22 100‐4060‐20‐01 NSF Fees‐ 25.00 25.00 100‐4230‐20‐01 Other Permits‐ 1,512.00 ‐ 1,512.00 ‐ 125.00 ‐ 50.00 8.27 ‐ 1,387.00 100‐4440‐20‐01 Accident Reports‐ 967.00 ‐ 967.00 ‐ 348.00 ‐ 117.00 35.99 ‐ 619.00 100‐4450‐20‐01 Alarm Fee‐ 48,135.00 ‐ 48,135.00 ‐ 17,016.00 ‐ 6,480.00 35.35 ‐ 31,119.00 100‐4510‐20‐01 Grants‐ 1,931.61 1,931.61 100‐4530‐20‐01 Contributions 175.05 ‐ 175.05 100‐4910‐20‐01 Other Revenue‐ 2,000.00 ‐ 2,000.00 ‐ 2,430.00 ‐ 712.50 121.50 430.00 100‐4310‐30‐01 Charges for Services‐ 278,156.00 ‐ 278,156.00 ‐ 107,059.55 ‐ 34,430.34 38.49 ‐ 171,096.45 100‐4411‐30‐01 CC Fire Assoc‐ 500.00 ‐ 500.00 ‐ 158.29 31.66 ‐ 341.71 100‐4315‐30‐05 Fire Review/Inspect Fees‐ 93,268.00 ‐ 93,268.00 ‐ 9,700.00 ‐ 2,725.00 10.40 ‐ 83,568.00 100‐4017‐40‐01 Contractor Registration Fee‐ 65,000.00 ‐ 65,000.00 ‐ 33,800.00 ‐ 17,700.00 52.00 ‐ 31,200.00 100‐4060‐40‐01 NSF Fees‐ 3.00 3.00 100‐4210‐40‐01 Building Permits‐ 2,747,700.00 ‐ 2,747,700.00 ‐ 1,262,735.98 ‐ 346,840.72 45.96 ‐ 1,484,964.02 100‐4230‐40‐01 Other Permits‐ 200,000.00 ‐ 200,000.00 ‐ 65,328.70 ‐ 17,868.50 32.66 ‐ 134,671.30 100‐4240‐40‐01 Plumb/Elect/Mech Permits‐ 45,000.00 ‐ 45,000.00 ‐ 12,690.00 ‐ 3,180.00 28.20 ‐ 32,310.00 100‐4242‐40‐01 Re‐inspection Fees‐ 45,000.00 ‐ 45,000.00 ‐ 20,650.00 ‐ 5,025.00 45.89 ‐ 24,350.00 100‐4910‐40‐01 Other Revenue‐ 18,000.00 ‐ 18,000.00 ‐ 11,598.10 ‐ 2,989.35 64.43 ‐ 6,401.90 100‐4245‐40‐02 Health Inspections‐ 17,720.00 ‐ 17,720.00 ‐ 10,475.00 ‐ 3,425.00 59.11 ‐ 7,245.00 18Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐4910‐40‐02 Other Revenue‐ 2,000.00 ‐ 2,000.00 ‐ 2,000.00 100‐4220‐40‐03 Zoning Application Fees‐ 20,000.00 ‐ 20,000.00 ‐ 16,144.94 ‐ 360.00 80.73 ‐ 3,855.06 100‐4225‐40‐03 Development Application Fees‐ 50,000.00 ‐ 50,000.00 ‐ 17,687.00 ‐ 6,302.00 35.37 ‐ 32,313.00 100‐4910‐40‐03 Other Revenue‐ 8,000.00 ‐ 8,000.00 ‐ 1,350.00 16.88 ‐ 6,650.00 100‐4910‐50‐01 Other Revenue‐ 15,000.00 ‐ 15,000.00 ‐ 12,420.00 82.80 ‐ 2,580.00 100‐4056‐60‐00 Field Rental Fees‐ 74,800.00 ‐ 74,800.00 ‐ 19,977.50 ‐ 80.00 26.71 ‐ 54,822.50 100‐4057‐60‐00 Pavilion User Fees‐ 4,000.00 ‐ 4,000.00 ‐ 440.00 ‐ 145.00 11.00 ‐ 3,560.00 100‐4058‐60‐00 Park Program Fees‐ 44,000.00 ‐ 44,000.00 ‐ 7,114.00 ‐ 3,482.00 16.17 ‐ 36,886.00 100‐4721‐60‐00 Prosper Christmas Donations‐ 12,000.00 ‐ 12,000.00 ‐ 15,320.00 127.67 3,320.00 100‐4725‐60‐00 Fishing Derby Sponsorships‐ 650.00 ‐ 650.00 650.00 100‐4063‐60‐05 Lost Fees‐ 200.00 ‐ 200.00 ‐ 36.97 18.49 ‐ 163.03 100‐4064‐60‐05 Printing/Copying Fees‐ 50.00 ‐ 50.00 ‐ 16.70 ‐ 2.10 33.40 ‐ 33.30 100‐4065‐60‐05 Book Fines‐ 660.00 ‐ 660.00 ‐ 602.68 ‐ 238.80 91.32 ‐ 57.32 100‐4910‐60‐05 Other Revenue‐ 250.00 ‐ 250.00 ‐ 1.36 0.54 ‐ 248.64 100‐5110‐10‐01 Salaries & Wages 72,591.00 117,745.00 190,336.00 24,504.20 8,240.36 12.87 165,831.80 100‐5140‐10‐01 Salaries ‐ Longevity Pay 275.00 275.00 275.00 100.00 100‐5143‐10‐01 Cell Phone Allowance 675.00 675.00 675.00 100‐5145‐10‐01 Social Security Expense 4,518.00 7,342.00 11,860.00 1,512.73 505.01 12.76 10,347.27 100‐5150‐10‐01 Medicare Expense 1,057.00 1,717.00 2,774.00 353.79 118.11 12.75 2,420.21 100‐5155‐10‐01 SUTA Expense 171.00 9.00 180.00 180.00 100‐5160‐10‐01 Health Insurance 6,796.00 4,518.00 11,314.00 2,808.56 1,264.64 24.82 8,505.44 100‐5165‐10‐01 Dental Insurance 434.00 297.00 731.00 157.12 39.28 21.49 573.88 100‐5170‐10‐01 Life Insurance/AD&D 113.00 36.00 149.00 37.52 9.38 25.18 111.48 100‐5175‐10‐01 Liability (TML)/Workers' Comp 71.00 225.00 296.00 47.39 15.73 16.01 248.61 100‐5180‐10‐01 TMRS Expense 10,172.00 15,940.00 26,112.00 3,362.16 1,120.22 12.88 22,749.84 100‐5185‐10‐01 Long/Short Term Disability 134.00 225.00 359.00 46.56 15.66 12.97 312.44 100‐5186‐10‐01 WELLE‐Wellness Prog Reimb Empl 600.00 480.00 1,080.00 156.64 39.16 14.50 923.36 100‐5190‐10‐01 Contract Labor 100.00 100.00 45.00 45.00 55.00 100‐5210‐10‐01 Office Supplies 1,200.00 1,200.00 66.38 5.53 1,133.62 100‐5212‐10‐01 Building Supplies 700.00 700.00 314.02 44.86 385.98 100‐5220‐10‐01 Office Equipment 650.00 650.00 650.00 100‐5230‐10‐01 Dues,Fees,& Subscriptions 6,220.00 6,220.00 3,056.87 536.00 49.15 3,163.13 100‐5240‐10‐01 Postage and Delivery 100.00 100.00 2.32 2.32 97.68 100‐5250‐10‐01 Publications 400.00 400.00 400.00 100‐5280‐10‐01 Printing and Reproduction 150.00 150.00 161.37 161.37 107.58 ‐ 11.37 100‐5330‐10‐01 Copier Expense 250.00 250.00 48.97 13.42 19.59 201.03 100‐5340‐10‐01 Building Repairs 300.00 300.00 300.00 100‐5350‐10‐01 Vehicle Expense 102.00 102.00 ‐ 102.00 100‐5410‐10‐01 Professional Services 292,313.00 292,313.00 81,392.21 20,165.00 210,920.79 27.84 100‐5430‐10‐01 Legal Fees 72,450.00 72,450.00 13,589.78 3,667.81 18.76 58,860.22 100‐5480‐10‐01 Contracted Services 9,755.00 9,755.00 3,272.30 792.08 33.55 6,482.70 100‐5523‐10‐01 Water/Sewer Charges 183.00 183.00 99.36 41.40 54.30 83.64 100‐5524‐10‐01 Gas 500.00 500.00 227.78 11.23 45.56 272.22 19Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5525‐10‐01 Electricity 7,250.00 7,250.00 1,548.53 ‐ 3,524.14 21.36 5,701.47 100‐5526‐10‐01 Data Network 725.00 725.00 151.96 75.98 20.96 573.04 100‐5530‐10‐01 Travel 250.00 250.00 21.49 8.60 228.51 100‐5533‐10‐01 Mileage Expense 200.00 200.00 200.00 100‐5536‐10‐01 Training/Seminars 200.00 200.00 200.00 100‐7145‐10‐01 Transfer to VERF 623.00 623.00 207.68 51.92 33.34 415.32 100‐5110‐10‐02 Salaries & Wages 196,973.00 ‐ 6,938.00 190,035.00 48,385.49 13,894.51 25.46 141,649.51 100‐5115‐10‐02 Salaries ‐ Overtime 3,565.00 3,565.00 58.41 1.64 3,506.59 100‐5140‐10‐02 Salaries ‐ Longevity Pay 270.00 270.00 270.00 100.00 100‐5143‐10‐02 Cell Phone Allowance 1,080.00 1,080.00 300.00 75.00 27.78 780.00 100‐5145‐10‐02 Social Security Expense 12,517.00 ‐ 447.00 12,070.00 3,007.82 847.58 24.92 9,062.18 100‐5150‐10‐02 Medicare Expense 2,928.00 ‐ 104.00 2,824.00 703.43 198.22 24.91 2,120.57 100‐5155‐10‐02 SUTA Expense 855.00 ‐ 53.00 802.00 802.00 100‐5160‐10‐02 Health Insurance 12,048.00 ‐ 927.00 11,121.00 470.84 470.84 4.23 10,650.16 100‐5165‐10‐02 Dental Insurance 792.00 ‐ 61.00 731.00 71.44 9.77 659.56 100‐5170‐10‐02 Life Insurance/AD&D 318.00 ‐ 7.00 311.00 117.85 34.27 37.89 193.15 100‐5175‐10‐02 Liability (TML)/Workers' Comp 337.00 ‐ 18.00 319.00 92.50 26.41 29.00 226.50 100‐5180‐10‐02 TMRS Expense 27,308.00 ‐ 928.00 26,380.00 6,366.50 1,879.92 24.13 20,013.50 100‐5185‐10‐02 Long/Short Term Disability 367.00 ‐ 13.00 354.00 68.25 20.48 19.28 285.75 100‐5186‐10‐02 WELLE‐Wellness Prog Reimb Empl 1,200.00 ‐ 92.00 1,108.00 1,108.00 100‐5193‐10‐02 Records Retention 2,275.00 2,275.00 217.50 9.56 2,057.50 100‐5210‐10‐02 Office Supplies 2,900.00 2,900.00 483.00 22.48 16.66 2,417.00 100‐5212‐10‐02 Building Supplies 1,000.00 1,000.00 328.95 14.95 32.90 671.05 100‐5220‐10‐02 Office Equipment 1,600.00 1,600.00 209.98 209.98 13.12 1,390.02 100‐5230‐10‐02 Dues,Fees,& Subscriptions 895.00 895.00 777.61 440.36 86.88 117.39 100‐5240‐10‐02 Postage and Delivery 200.00 200.00 19.92 1.19 9.96 180.08 100‐5280‐10‐02 Printing and Reproduction 700.00 700.00 700.00 100‐5310‐10‐02 Rental Expense 6,350.00 6,350.00 2,365.80 1,113.88 37.26 3,984.20 100‐5330‐10‐02 Copier Expense 1,800.00 1,800.00 382.19 102.56 21.23 1,417.81 100‐5340‐10‐02 Building Repairs 700.00 700.00 700.00 100‐5430‐10‐02 Legal Fees 35,600.00 35,600.00 6,093.68 677.19 17.12 29,506.32 100‐5435‐10‐02 Legal Notices/Filings 6,800.00 6,800.00 1,895.55 27.88 4,904.45 100‐5460‐10‐02 Election Expense 9,691.00 9,691.00 22.43 0.23 9,668.57 100‐5480‐10‐02 Contracted Services 13,375.00 13,375.00 12,595.00 7,220.00 ‐ 3,220.00 94.17 4,000.00 100‐5520‐10‐02 Telephones 870.00 870.00 143.65 35.95 16.51 726.35 100‐5523‐10‐02 Water/Sewer Charges 228.00 228.00 87.30 32.13 38.29 140.70 100‐5526‐10‐02 Data Network 460.00 460.00 151.96 75.98 33.04 308.04 100‐5530‐10‐02 Travel 6,100.00 6,100.00 452.93 7.43 5,647.07 100‐5533‐10‐02 Mileage Expense 1,125.00 1,125.00 1,125.00 100‐5536‐10‐02 Training/Seminars 3,200.00 3,200.00 290.00 290.00 9.06 2,910.00 100‐5538‐10‐02 Council/Public Official Expnse 24,000.00 24,000.00 7,808.48 3,390.12 32.54 16,191.52 100‐5600‐10‐02 Special Events 4,500.00 4,500.00 625.35 176.43 13.90 3,874.65 100‐7145‐10‐02 Transfer to VERF 3,157.00 3,157.00 1,052.32 263.08 33.33 2,104.68 20Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5110‐10‐03 Salaries & Wages 513,758.00 513,758.00 145,387.96 35,904.76 28.30 368,370.04 100‐5115‐10‐03 Salaries ‐ Overtime 30.08 ‐ 30.08 100‐5126‐10‐03 Salaries‐Vacation Buy‐Out 4,645.00 4,645.00 2,537.84 54.64 2,107.16 100‐5140‐10‐03 Salaries ‐ Longevity Pay 730.00 730.00 620.00 84.93 110.00 100‐5145‐10‐03 Social Security Expense 32,187.00 32,187.00 8,375.05 2,105.53 26.02 23,811.95 100‐5150‐10‐03 Medicare Expense 7,528.00 7,528.00 2,052.80 492.42 27.27 5,475.20 100‐5155‐10‐03 SUTA Expense 1,197.00 1,197.00 1,197.00 100‐5160‐10‐03 Health Insurance 44,537.00 44,537.00 19,458.30 8,988.96 43.69 25,078.70 100‐5165‐10‐03 Dental Insurance 2,480.00 2,480.00 778.40 192.50 31.39 1,701.60 100‐5170‐10‐03 Life Insurance/AD&D 700.00 700.00 188.91 43.71 26.99 511.09 100‐5175‐10‐03 Liability (TML)/Workers' Comp 525.00 525.00 283.24 68.38 53.95 241.76 100‐5180‐10‐03 TMRS Expense 72,380.00 72,380.00 20,091.71 4,869.98 27.76 52,288.29 100‐5185‐10‐03 Long/Short Term Disability 949.00 949.00 273.98 65.96 28.87 675.02 100‐5186‐10‐03 WELLE‐Wellness Prog Reimb Empl 2,700.00 2,700.00 506.64 89.16 18.76 2,193.36 100‐5210‐10‐03 Office Supplies 4,000.00 4,000.00 1,216.74 30.42 2,783.26 100‐5212‐10‐03 Building Supplies 2,500.00 2,500.00 1,527.47 61.10 972.53 100‐5220‐10‐03 Office Equipment 3,130.00 3,130.00 1,105.38 35.32 2,024.62 100‐5230‐10‐03 Dues,Fees,& Subscriptions 6,633.00 6,633.00 1,094.75 370.00 16.51 5,538.25 100‐5240‐10‐03 Postage and Delivery 1,800.00 1,800.00 760.96 391.13 42.28 1,039.04 100‐5280‐10‐03 Printing and Reproduction 150.00 150.00 72.40 48.27 77.60 100‐5290‐10‐03 Other Charges and Services 600.00 600.00 94.94 58.79 15.82 505.06 100‐5310‐10‐03 Rental Expense 28,100.00 28,100.00 7,955.00 1,567.60 4,702.80 28.31 15,442.20 100‐5330‐10‐03 Copier Expense 1,800.00 1,800.00 555.88 187.42 30.88 1,244.12 100‐5340‐10‐03 Building Repairs 250.00 250.00 18.00 7.20 232.00 100‐5410‐10‐03 Professional Services 8,744.00 5,000.00 13,744.00 6,592.03 47.96 7,151.97 100‐5412‐10‐03 Audit Fees 39,560.00 39,560.00 13,000.00 25,150.00 32.86 1,410.00 100‐5414‐10‐03 Appraisal/Tax Fees 113,444.00 113,444.00 36,522.84 32.20 76,921.16 100‐5418‐10‐03 IT Fees 49,100.00 49,100.00 30,936.20 17,020.00 ‐ 17,020.00 63.01 35,183.80 100‐5419‐10‐03 IT Licenses 10,000.00 10,000.00 7,500.00 75.00 2,500.00 100‐5430‐10‐03 Legal Fees 7,750.00 7,750.00 1,482.00 361.00 19.12 6,268.00 100‐5435‐10‐03 Legal Notices/Filings 75.00 75.00 163.20 217.60 ‐ 88.20 100‐5480‐10‐03 Contracted Services 8,890.00 8,890.00 3,052.30 779.21 34.33 5,837.70 100‐5520‐10‐03 Telephones 1,865.00 1,865.00 395.18 98.90 21.19 1,469.82 100‐5523‐10‐03 Water/Sewer Charges 409.00 409.00 109.00 32.42 26.65 300.00 100‐5525‐10‐03 Electricity 7,000.00 7,000.00 2,661.32 614.16 38.02 4,338.68 100‐5530‐10‐03 Travel 8,500.00 8,500.00 3,173.94 37.34 5,326.06 100‐5533‐10‐03 Mileage Expense 1,505.00 1,505.00 788.88 56.80 52.42 716.12 100‐5536‐10‐03 Training/Seminars 6,290.00 6,290.00 2,964.00 929.00 47.12 3,326.00 100‐7145‐10‐03 Transfer to VERF 1,819.00 1,819.00 606.32 151.58 33.33 1,212.68 100‐5110‐10‐04 Salaries & Wages 226,568.00 ‐ 39,865.60 186,702.40 50,992.61 13,854.86 27.31 135,709.79 100‐5126‐10‐04 Salaries‐Vacation Buy‐Out 5,599.00 ‐ 4,349.00 1,250.00 1,250.00 100‐5140‐10‐04 Salaries ‐ Longevity Pay 295.00 ‐ 265.00 30.00 30.00 100‐5145‐10‐04 Social Security Expense 14,871.00 ‐ 2,824.00 12,047.00 3,144.18 851.94 26.10 8,902.82 21Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5150‐10‐04 Medicare Expense 3,479.00 ‐ 661.00 2,818.00 735.34 199.25 26.09 2,082.66 100‐5155‐10‐04 SUTA Expense 513.00 ‐ 171.00 342.00 342.00 100‐5160‐10‐04 Health Insurance 24,335.00 ‐ 11,339.00 12,996.00 470.84 470.84 3.62 12,525.16 100‐5165‐10‐04 Dental Insurance 1,350.00 ‐ 636.00 714.00 157.12 39.28 22.01 556.88 100‐5170‐10‐04 Life Insurance/AD&D 288.00 ‐ 48.00 240.00 37.52 9.38 15.63 202.48 100‐5175‐10‐04 Liability (TML)/Workers' Comp 13,223.00 ‐ 91.00 13,132.00 96.95 26.38 0.74 13,035.05 100‐5180‐10‐04 TMRS Expense 33,221.00 ‐ 7,029.00 26,192.00 2,698.88 679.88 10.30 23,493.12 100‐5185‐10‐04 Long/Short Term Disability 1,926.00 ‐ 87.00 1,839.00 38.00 9.50 2.07 1,801.00 100‐5186‐10‐04 WELLE‐Wellness Prog Reimb Empl 1,800.00 ‐ 600.00 1,200.00 25.00 25.00 2.08 1,175.00 100‐5191‐10‐04 Hiring Cost 23,200.00 23,200.00 7,360.70 981.94 31.73 15,839.30 100‐5210‐10‐04 Office Supplies 2,710.00 2,710.00 65.00 2.40 2,645.00 100‐5220‐10‐04 Office Equipment 11,000.00 11,000.00 11,000.00 100‐5230‐10‐04 Dues,Fees,& Subscriptions 5,530.00 5,530.00 621.75 57.00 11.24 4,908.25 100‐5240‐10‐04 Postage and Delivery 382.00 382.00 3.39 0.46 0.89 378.61 100‐5250‐10‐04 Publications 500.00 500.00 500.00 100‐5280‐10‐04 Printing and Reproduction 2,000.00 2,000.00 2,000.00 100‐5330‐10‐04 Copier Expense 1,160.00 1,160.00 581.92 188.47 50.17 578.08 100‐5410‐10‐04 Professional Services 41,000.00 ‐ 3,500.00 37,500.00 10,000.00 26.67 27,500.00 100‐5419‐10‐04 IT Licenses 4,285.00 4,285.00 4,285.00 100‐5430‐10‐04 Legal Fees 10,000.00 10,000.00 950.00 361.00 9.50 9,050.00 100‐5435‐10‐04 Legal Notices/Filings 91.20 ‐ 91.20 100‐5480‐10‐04 Contracted Services 952.60 600.00 ‐ 952.60 100‐5520‐10‐04 Telephones 1,020.00 1,020.00 ‐ 34.61 1.60 ‐ 3.39 1,054.61 100‐5523‐10‐04 Water/Sewer Charges 142.00 142.00 37.92 11.28 26.70 104.08 100‐5526‐10‐04 Data Network 480.00 480.00 151.96 75.98 31.66 328.04 100‐5530‐10‐04 Travel 4,600.00 ‐ 3,090.00 1,510.00 1,510.00 100‐5533‐10‐04 Mileage Expense 1,000.00 1,000.00 1,000.00 100‐5536‐10‐04 Training/Seminars 5,700.00 5,700.00 3,420.00 60.00 2,280.00 100‐5600‐10‐04 Special Events 10,000.00 10,000.00 270.23 2.70 9,729.77 100‐7145‐10‐04 Transfer to VERF 731.00 731.00 243.68 60.92 33.34 487.32 100‐5110‐10‐05 Salaries & Wages 195,853.00 195,853.00 58,799.86 14,919.46 30.02 137,053.14 100‐5115‐10‐05 Salaries ‐ Overtime 1,760.00 1,760.00 537.53 30.54 1,222.47 100‐5140‐10‐05 Salaries ‐ Longevity Pay 190.00 190.00 190.00 100.00 100‐5143‐10‐05 Cell Phone Allowance 2,760.00 2,760.00 920.00 230.00 33.33 1,840.00 100‐5145‐10‐05 Social Security Expense 12,436.00 12,436.00 3,434.38 848.06 27.62 9,001.62 100‐5150‐10‐05 Medicare Expense 2,909.00 2,909.00 803.20 198.33 27.61 2,105.80 100‐5155‐10‐05 SUTA Expense 342.00 342.00 342.00 100‐5160‐10‐05 Health Insurance 21,656.00 21,656.00 9,012.20 3,973.40 41.62 12,643.80 100‐5165‐10‐05 Dental Insurance 996.00 996.00 330.54 81.60 33.19 665.46 100‐5170‐10‐05 Life Insurance/AD&D 270.00 270.00 89.76 22.44 33.24 180.24 100‐5175‐10‐05 Liability (TML)/Workers' Comp 194.00 194.00 113.24 28.43 58.37 80.76 100‐5180‐10‐05 TMRS Expense 27,999.00 27,999.00 8,048.31 2,023.90 28.75 19,950.69 100‐5185‐10‐05 Long/Short Term Disability 362.00 362.00 111.75 28.35 30.87 250.25 22Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5186‐10‐05 WELLE‐Wellness Prog Reimb Empl 600.00 600.00 189.16 39.16 31.53 410.84 100‐5210‐10‐05 Office Supplies 500.00 500.00 28.52 5.70 471.48 100‐5212‐10‐05 Building Supplies 500.00 500.00 52.99 10.60 447.01 100‐5220‐10‐05 Office Equipment 1,000.00 1,000.00 993.34 64.34 99.33 6.66 100‐5225‐10‐05 Computer Hardware 31,778.00 31,778.00 3,175.97 ‐ 2.89 9.99 28,602.03 100‐5230‐10‐05 Dues,Fees,& Subscriptions 500.00 500.00 150.00 30.00 350.00 100‐5240‐10‐05 Postage and Delivery 300.00 300.00 22.48 7.49 277.52 100‐5280‐10‐05 Printing and Reproduction 200.00 200.00 200.00 100‐5290‐10‐05 Other Charges and Services 200.00 200.00 200.00 100‐5330‐10‐05 Copier Expense 60,000.00 60,000.00 9,332.26 2,326.16 23,189.30 15.55 27,478.44 100‐5400‐10‐05 Uniform Expense 800.00 800.00 800.00 100‐5410‐10‐05 Professional Services 23,310.00 ‐ 23,310.00 100‐5418‐10‐05 IT Fees 34,765.00 34,765.00 11,124.66 5,144.87 2,900.00 32.00 20,740.34 100‐5419‐10‐05 IT Licenses 42,860.00 42,860.00 14,200.62 28,659.38 100‐5430‐10‐05 Legal Fees 1,500.00 1,500.00 342.00 22.80 1,158.00 100‐5480‐10‐05 Contracted Services 16,728.00 10,800.00 27,528.00 19,789.00 735.00 71.89 7,739.00 100‐5520‐10‐05 Telephones 33,000.00 33,000.00 13,064.06 3,166.56 39.59 19,935.94 100‐5523‐10‐05 Water/Sewer Charges 133.00 133.00 35.54 10.57 26.72 97.46 100‐5526‐10‐05 Data Network 48,000.00 ‐ 10,800.00 37,200.00 12,915.22 3,378.79 34.72 24,284.78 100‐5530‐10‐05 Travel 5,000.00 5,000.00 5,000.00 100‐5533‐10‐05 Mileage Expense 1,500.00 1,500.00 102.40 6.83 1,397.60 100‐5536‐10‐05 Training/Seminars 5,000.00 5,000.00 813.60 662.40 16.27 4,186.40 100‐5620‐10‐05 Tools & Equipment 1,000.00 1,000.00 84.97 8.50 915.03 100‐5630‐10‐05 Safety Equipment 500.00 500.00 500.00 100‐6125‐10‐05 Capital Expense‐Technology 143,862.00 23,310.00 167,172.00 67,167.08 40.18 100,004.92 100‐7145‐10‐05 Transfer to VERF 16,884.00 16,884.00 5,628.00 1,407.00 33.33 11,256.00 100‐5110‐10‐07 Salaries & Wages 163,069.00 ‐ 8,653.00 154,416.00 36,091.12 7,146.21 23.37 118,324.88 100‐5115‐10‐07 Salaries ‐ Overtime 270.00 270.00 6.51 2.41 263.49 100‐5126‐10‐07 Salaries‐Vacation Buy‐Out 3,521.00 3,521.00 1,760.16 49.99 1,760.84 100‐5128‐10‐07 Language Pay 2,400.00 2,400.00 600.00 200.00 25.00 1,800.00 100‐5140‐10‐07 Salaries ‐ Longevity Pay 335.00 335.00 335.00 100.00 100‐5145‐10‐07 Social Security Expense 10,366.00 ‐ 553.00 9,813.00 2,257.84 421.84 23.01 7,555.16 100‐5150‐10‐07 Medicare Expense 2,425.00 ‐ 129.00 2,296.00 528.05 98.66 23.00 1,767.95 100‐5155‐10‐07 SUTA Expense 513.00 ‐ 20.00 493.00 493.00 100‐5160‐10‐07 Health Insurance 26,052.00 ‐ 1,156.00 24,896.00 4,232.08 671.84 17.00 20,663.92 100‐5165‐10‐07 Dental Insurance 1,188.00 ‐ 49.00 1,139.00 225.28 38.46 19.78 913.72 100‐5170‐10‐07 Life Insurance/AD&D 261.00 ‐ 13.00 248.00 60.97 9.38 24.59 187.03 100‐5175‐10‐07 Liability (TML)/Workers' Comp 198.00 ‐ 4.00 194.00 72.57 13.58 37.41 121.43 100‐5180‐10‐07 TMRS Expense 23,182.00 ‐ 1,087.00 22,095.00 5,145.75 966.88 23.29 16,949.25 100‐5185‐10‐07 Long/Short Term Disability 304.00 ‐ 8.00 296.00 68.58 13.58 23.17 227.42 100‐5186‐10‐07 WELLE‐Wellness Prog Reimb Empl 450.00 450.00 450.00 100‐5210‐10‐07 Office Supplies 1,850.00 1,850.00 1,272.44 132.18 68.78 577.56 100‐5212‐10‐07 Building Supplies 2,800.00 2,800.00 432.29 14.76 15.44 2,367.71 23Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5220‐10‐07 Office Equipment 4,640.00 4,640.00 1,294.38 27.90 3,345.62 100‐5230‐10‐07 Dues,Fees,& Subscriptions 290.00 290.00 40.00 40.00 13.79 250.00 100‐5240‐10‐07 Postage and Delivery 1,400.00 1,400.00 847.92 158.45 60.57 552.08 100‐5250‐10‐07 Publications 100.00 100.00 70.08 70.08 29.92 100‐5280‐10‐07 Printing and Reproduction 700.00 700.00 318.70 45.53 381.30 100‐5290‐10‐07 Other Charges and Services 200.00 200.00 200.00 100‐5310‐10‐07 Rental Expense 38,660.00 38,660.00 15,276.40 6,063.76 15,159.40 39.52 8,224.20 100‐5320‐10‐07 Repairs & Maintenance 500.00 500.00 485.00 230.00 425.00 97.00 ‐ 410.00 100‐5330‐10‐07 Copier Expense 1,850.00 1,850.00 702.17 153.21 37.96 1,147.83 100‐5400‐10‐07 Uniform Expense 150.00 150.00 150.00 100‐5418‐10‐07 IT Fees 6,100.00 6,100.00 4,515.41 74.02 1,584.59 100‐5419‐10‐07 IT Licenses 2,169.00 2,169.00 2,169.00 100‐5420‐10‐07 Municipal Court/Judge Fees 29,200.00 29,200.00 5,400.00 1,800.00 18.49 23,800.00 100‐5425‐10‐07 State Fines Expense 1,800.00 1,800.00 488.53 139.58 27.14 1,311.47 100‐5430‐10‐07 Legal Fees 31,200.00 31,200.00 7,107.00 2,763.00 22.78 24,093.00 100‐5480‐10‐07 Contracted Services 4,800.00 4,800.00 1,595.00 455.00 33.23 3,205.00 100‐5524‐10‐07 Gas 750.00 750.00 282.40 115.02 37.65 467.60 100‐5525‐10‐07 Electricity 1,500.00 1,500.00 399.43 ‐ 223.34 26.63 1,100.57 100‐5530‐10‐07 Travel 900.00 900.00 584.60 64.96 315.40 100‐5533‐10‐07 Mileage Expense 800.00 800.00 476.15 59.52 323.85 100‐5536‐10‐07 Training/Seminars 900.00 900.00 900.00 100‐7145‐10‐07 Transfer to VERF 746.00 746.00 248.68 62.17 33.34 497.32 100‐5145‐10‐99 Social Security Expense 112.39 112.39 ‐ 112.39 100‐5150‐10‐99 Medicare Expense 26.28 26.28 ‐ 26.28 100‐5170‐10‐99 Life Insurance/ADD 2.97 2.97 ‐ 2.97 100‐5175‐10‐99 Liability (TML)/Worker's Comp 3.44 3.44 ‐ 3.44 100‐5176‐10‐99 TML Prop. & Liab. Insurance 115,000.00 115,000.00 126,433.64 109.94 ‐ 11,433.64 100‐5180‐10‐99 TMRS Expense 245.26 245.26 ‐ 245.26 100‐5305‐10‐99 Chapt 380 Program Grant Exp 355,720.00 355,720.00 14,795.64 10,426.74 4.16 340,924.36 100‐5306‐10‐99 Developer Rollback Incentives 61,615.00 61,615.00 34,914.08 56.67 26,700.92 100‐5350‐10‐99 Vehicle Expense 1,000.00 1,000.00 296.04 29.60 703.96 100‐5352‐10‐99 Fuel 2,000.00 2,000.00 88.45 27.60 4.42 1,911.55 100‐5353‐10‐99 Oil/Grease/Inspections 1,000.00 1,000.00 1,000.00 100‐5410‐10‐99 Professional Services 85,625.00 ‐ 46,125.00 39,500.00 9,756.14 1,500.00 13,500.00 24.70 16,243.86 100‐5415‐10‐99 Tuition Reimbursement 33,200.00 33,200.00 8,471.03 6,443.44 25.52 24,728.97 100‐5480‐10‐99 Contracted Services 40,000.00 40,000.00 18,000.00 9,000.00 24,000.00 45.00 ‐ 2,000.00 100‐5600‐10‐99 Special Events 10,000.00 10,000.00 8,295.55 2,128.36 82.96 1,704.45 100‐5930‐10‐99 Damage Claims Expense 53,124.85 10,523.66 ‐ 53,124.85 100‐6410‐10‐99 Land Acquisition‐ROW 1,464,000.00 1,464,000.00 1,464,000.00 100‐7000‐10‐99 Contingency 50,000.00 ‐ 18,290.40 31,709.60 31,709.60 100‐7145‐10‐99 Transfer to VERF 6,372.00 6,372.00 2,124.00 531.00 33.33 4,248.00 100‐5110‐20‐01 Salaries & Wages 2,056,968.00 93,132.00 2,150,100.00 638,645.79 162,642.28 29.70 1,511,454.21 100‐5115‐20‐01 Salaries ‐ Overtime 98,090.00 2,700.00 100,790.00 33,418.60 3,908.16 33.16 67,371.40 24Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5126‐20‐01 Salaries‐Vacation Buy‐Out 16,116.00 16,116.00 11,838.40 73.46 4,277.60 100‐5127‐20‐01 Salaries‐Certification Pay 31,500.00 900.00 32,400.00 10,487.91 2,563.71 32.37 21,912.09 100‐5140‐20‐01 Salaries ‐ Longevity Pay 6,740.00 6,740.00 6,250.00 425.00 92.73 490.00 100‐5143‐20‐01 Cell Phone Allowance 1,380.00 1,380.00 460.00 115.00 33.33 920.00 100‐5145‐20‐01 Social Security Expense 137,070.00 5,997.00 143,067.00 38,258.89 10,071.54 26.74 104,808.11 100‐5150‐20‐01 Medicare Expense 32,057.00 1,403.00 33,460.00 9,791.16 2,355.44 29.26 23,668.84 100‐5155‐20‐01 SUTA Expense 4,617.00 18.00 4,635.00 4,635.00 100‐5160‐20‐01 Health Insurance 195,371.00 9,036.00 204,407.00 68,088.31 28,351.34 33.31 136,318.69 100‐5165‐20‐01 Dental Insurance 11,057.00 594.00 11,651.00 2,995.55 767.04 25.71 8,655.45 100‐5170‐20‐01 Life Insurance/AD&D 9,902.00 205.00 10,107.00 2,991.59 743.99 29.60 7,115.41 100‐5175‐20‐01 Liability (TML)/Workers' Comp 71,063.00 1,797.00 72,860.00 12,301.35 2,999.17 16.88 60,558.65 100‐5180‐20‐01 TMRS Expense 308,484.00 12,943.00 321,427.00 94,478.66 22,947.34 29.39 226,948.34 100‐5185‐20‐01 Long/Short Term Disability 3,815.00 184.00 3,999.00 1,151.16 288.30 28.79 2,847.84 100‐5186‐20‐01 WELLE‐Wellness Prog Reimb Empl 4,050.00 1,200.00 5,250.00 399.12 64.16 7.60 4,850.88 100‐5191‐20‐01 Hiring Cost 383.00 1,050.00 1,433.00 55.00 33.00 3.84 1,378.00 100‐5192‐20‐01 Physical & Psychological 1,575.00 1,575.00 1,575.00 100‐5210‐20‐01 Office Supplies 8,300.00 400.00 8,700.00 1,440.65 100.18 16.56 7,259.35 100‐5212‐20‐01 Building Supplies 2,400.00 2,400.00 314.02 13.08 2,085.98 100‐5214‐20‐01 Tactical Supplies 118,084.00 4,636.00 122,720.00 13,116.36 8,746.59 21,859.43 10.69 87,744.21 100‐5215‐20‐01 Ammunition 28,395.00 2,184.00 30,579.00 418.71 20,671.76 1.37 9,488.53 100‐5220‐20‐01 Office Equipment 6,075.00 6,075.00 1,105.38 18.20 4,969.62 100‐5230‐20‐01 Dues,Fees,& Subscriptions 9,700.00 9,700.00 550.55 84.23 5.68 9,149.45 100‐5240‐20‐01 Postage and Delivery 775.00 775.00 317.32 77.46 40.95 457.68 100‐5265‐20‐01 Promotional Expense 500.00 500.00 185.00 37.00 315.00 100‐5280‐20‐01 Printing and Reproduction 600.00 600.00 472.94 78.82 127.06 100‐5310‐20‐01 Rental Expense 4,410.00 4,410.00 2,360.81 1,228.30 53.53 2,049.19 100‐5320‐20‐01 Repairs & Maintenance 1,000.00 1,000.00 282.38 60.00 28.24 717.62 100‐5330‐20‐01 Copier Expense 2,163.00 2,163.00 459.00 174.27 21.22 1,704.00 100‐5335‐20‐01 Radio/Video Repairs 500.00 500.00 500.00 100‐5340‐20‐01 Building Repairs 1,500.00 1,500.00 575.76 575.76 38.38 924.24 100‐5350‐20‐01 Vehicle Expense 68,000.00 68,000.00 18,654.39 7,250.84 27.43 49,345.61 100‐5352‐20‐01 Fuel 61,798.00 61,798.00 21,798.32 5,840.10 35.27 39,999.68 100‐5353‐20‐01 Oil/Grease/Inspections 26.50 26.50 ‐ 26.50 100‐5400‐20‐01 Uniform Expense 46,389.00 6,566.00 52,955.00 6,174.13 2,937.56 11.66 46,780.87 100‐5410‐20‐01 Professional Services 5,118.26 5,118.26 1,148.00 3,970.26 22.43 100‐5418‐20‐01 IT Fees 3,500.00 3,500.00 1,089.75 31.14 2,410.25 100‐5419‐20‐01 IT Licenses 1,000.00 1,000.00 1,000.00 100‐5430‐20‐01 Legal Fees 10,500.00 10,500.00 6,190.14 1,539.00 58.95 4,309.86 100‐5435‐20‐01 Legal Notices/Filings 150.00 150.00 150.00 100‐5480‐20‐01 Contracted Services 51,401.00 51,401.00 20,051.31 817.09 39.01 31,349.69 100‐5520‐20‐01 Telephones 6,366.00 6,366.00 1,152.33 177.29 18.10 5,213.67 100‐5523‐20‐01 Water/Sewer Charges 1,800.00 1,800.00 256.66 106.94 14.26 1,543.34 100‐5524‐20‐01 Gas 800.00 800.00 800.00 25Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5525‐20‐01 Electricity 17,229.00 17,229.00 4,020.35 1,833.19 23.34 13,208.65 100‐5526‐20‐01 Data Network 7,425.00 7,425.00 2,887.24 1,443.62 38.89 4,537.76 100‐5530‐20‐01 Travel 2,500.00 2,500.00 1,655.53 1,213.71 66.22 844.47 100‐5533‐20‐01 Mileage Expense 300.00 300.00 578.87 192.96 ‐ 278.87 100‐5536‐20‐01 Training/Seminars 22,466.00 1,000.00 23,466.00 10,553.54 2,042.33 44.97 12,912.46 100‐5600‐20‐01 Special Events 2,000.00 2,000.00 80.17 62.86 4.01 1,919.83 100‐5620‐20‐01 TOOLS & EQUIPMENT 10,290.00 10,290.00 6,035.98 4,254.02 100‐5630‐20‐01 Safety Equipment 16,800.00 15,000.00 31,800.00 18,893.98 3,098.02 5,781.50 59.42 7,124.52 100‐6160‐20‐01 Capital Expense‐Vehicles 6,125.00 61,605.00 67,730.00 67,730.00 100‐7145‐20‐01 Transfer to VERF 303,024.00 303,024.00 101,008.00 25,252.00 33.33 202,016.00 100‐5110‐20‐05 Salaries & Wages 446,399.00 446,399.00 122,391.77 29,075.70 27.42 324,007.23 100‐5115‐20‐05 Salaries ‐ Overtime 82,335.00 82,335.00 11,761.39 2,121.90 14.29 70,573.61 100‐5126‐20‐05 Salaries‐Vacation Buy‐Out 3,306.00 3,306.00 1,175.60 35.56 2,130.40 100‐5127‐20‐05 Salaries‐Certification Pay 15,420.00 15,420.00 4,079.76 1,019.94 26.46 11,340.24 100‐5140‐20‐05 Salaries ‐ Longevity Pay 2,315.00 2,315.00 1,715.00 74.08 600.00 100‐5145‐20‐05 Social Security Expense 35,053.00 35,053.00 8,299.66 1,875.86 23.68 26,753.34 100‐5150‐20‐05 Medicare Expense 8,199.00 8,199.00 1,941.06 438.71 23.67 6,257.94 100‐5155‐20‐05 SUTA Expense 1,539.00 1,539.00 1,539.00 100‐5160‐20‐05 Health Insurance 54,607.00 54,607.00 21,006.08 7,848.28 38.47 33,600.92 100‐5165‐20‐05 Dental Insurance 4,041.00 4,041.00 1,230.46 302.50 30.45 2,810.54 100‐5170‐20‐05 Life Insurance/AD&D 1,014.00 1,014.00 304.85 75.04 30.06 709.15 100‐5175‐20‐05 Liability (TML)/Workers' Comp 445.00 445.00 261.79 59.87 58.83 183.21 100‐5180‐20‐05 TMRS Expense 78,419.00 78,419.00 19,093.15 4,359.03 24.35 59,325.85 100‐5185‐20‐05 Long/Short Term Disability 806.00 806.00 227.30 52.91 28.20 578.70 100‐5186‐20‐05 WELLE‐Wellness Prog Reimb Empl 3,600.00 3,600.00 559.96 15.55 3,040.04 100‐5210‐20‐05 Office Supplies 4,079.00 4,079.00 1,034.35 549.10 25.36 3,044.65 100‐5212‐20‐05 Building Supplies 1,500.00 1,500.00 1,500.00 100‐5220‐20‐05 Office Equipment 1,200.00 1,200.00 1,200.00 100‐5230‐20‐05 Dues,Fees,& Subscriptions 1,260.00 1,260.00 148.00 31.50 11.75 1,112.00 100‐5240‐20‐05 Postage and Delivery 100.00 100.00 38.60 38.60 61.40 100‐5280‐20‐05 Printing and Reproduction 100.00 100.00 36.04 36.04 36.04 63.96 100‐5330‐20‐05 Copier Expense 600.00 600.00 138.49 48.73 23.08 461.51 100‐5340‐20‐05 Building Repairs 3,000.00 3,000.00 3,000.00 100‐5400‐20‐05 Uniform Expense 1,000.00 1,000.00 1,000.00 100‐5430‐20‐05 Legal Fees 250.00 250.00 250.00 100‐5480‐20‐05 Contracted Services 186,858.00 186,858.00 71,302.29 75,997.56 38.16 39,558.15 100‐5520‐20‐05 Telephones 700.00 700.00 247.99 62.08 35.43 452.01 100‐5523‐20‐05 Water/Sewer Charges 488.00 488.00 264.91 110.38 54.29 223.09 100‐5524‐20‐05 Gas 1,000.00 1,000.00 386.71 95.83 38.67 613.29 100‐5526‐20‐05 Data Network 735.00 735.00 735.00 100‐5530‐20‐05 Travel 1,000.00 1,000.00 1,000.00 100‐5533‐20‐05 Mileage Expense 176.92 ‐ 176.92 100‐5536‐20‐05 Training/Seminars 1,500.00 1,500.00 100.00 6.67 1,400.00 26Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5600‐20‐05 Special Events 500.00 500.00 500.00 100‐7145‐20‐05 Transfer to VERF 901.00 901.00 300.32 75.08 33.33 600.68 100‐5110‐30‐01 Salaries & Wages 3,120,450.00 3,120,450.00 887,736.92 250,991.24 28.45 2,232,713.08 100‐5115‐30‐01 Salaries ‐ Overtime 392,728.00 392,728.00 140,890.07 34,230.88 35.88 251,837.93 100‐5116‐30‐01 Salaries ‐ FLSA Overtime 78,109.00 78,109.00 16,319.91 4,854.20 20.89 61,789.09 100‐5126‐30‐01 Salaries‐Vacation Buy‐Out 6,395.00 6,395.00 3,964.76 62.00 2,430.24 100‐5127‐30‐01 Salaries‐Certification Pay 39,160.00 39,160.00 10,992.11 3,097.10 28.07 28,167.89 100‐5140‐30‐01 Salaries ‐ Longevity Pay 11,930.00 11,930.00 10,455.00 87.64 1,475.00 100‐5143‐30‐01 Cell Phone Allowance 5,400.00 5,400.00 1,600.00 400.00 29.63 3,800.00 100‐5145‐30‐01 Social Security Expense 225,972.00 225,972.00 62,804.79 17,145.93 27.79 163,167.21 100‐5150‐30‐01 Medicare Expense 52,849.00 52,849.00 14,781.49 4,009.95 27.97 38,067.51 100‐5155‐30‐01 SUTA Expense 9,405.00 9,405.00 9,405.00 100‐5160‐30‐01 Health Insurance 301,006.00 301,006.00 116,153.62 54,466.80 38.59 184,852.38 100‐5165‐30‐01 Dental Insurance 16,342.00 16,342.00 4,850.56 1,486.48 29.68 11,491.44 100‐5170‐30‐01 Life Insurance/AD&D 13,017.00 13,017.00 4,197.91 1,195.87 32.25 8,819.09 100‐5171‐30‐01 Life Insurance‐Supplemental 8,000.00 8,000.00 8,045.00 100.56 ‐ 45.00 100‐5175‐30‐01 Liability (TML)/Workers' Comp 89,480.00 89,480.00 14,296.89 3,952.92 15.98 75,183.11 100‐5180‐30‐01 TMRS Expense 482,550.00 482,550.00 139,029.52 38,037.13 28.81 343,520.48 100‐5185‐30‐01 Long/Short Term Disability 5,472.00 5,472.00 1,501.47 429.06 27.44 3,970.53 100‐5186‐30‐01 WELLE‐Wellness Prog Reimb Empl 9,600.00 9,600.00 1,565.72 645.80 16.31 8,034.28 100‐5191‐30‐01 Hiring Cost 1,000.00 1,000.00 909.50 90.95 90.50 100‐5194‐30‐01 FD Annual Phy & Screening 37,742.00 37,742.00 5,788.50 3,272.00 15.34 31,953.50 100‐5210‐30‐01 Office Supplies 10,418.00 10,418.00 2,417.51 413.51 23.21 8,000.49 100‐5212‐30‐01 Building Supplies 12,000.00 12,000.00 5,645.07 2,634.74 47.04 6,354.93 100‐5220‐30‐01 Office Equipment 3,200.00 3,200.00 3,432.80 249.83 107.28 ‐ 232.80 100‐5230‐30‐01 Dues,Fees,& Subscriptions 8,677.00 8,677.00 4,795.54 822.25 55.27 3,881.46 100‐5240‐30‐01 Postage and Delivery 250.00 250.00 198.24 125.17 79.30 51.76 100‐5250‐30‐01 Publications 700.00 700.00 700.00 100‐5280‐30‐01 Printing and Reproduction 1,900.00 1,900.00 199.41 199.41 10.50 1,700.59 100‐5290‐30‐01 Other Charges and Services 2,500.00 2,500.00 755.22 405.22 30.21 1,744.78 100‐5320‐30‐01 Repairs & Maintenance 18,000.00 18,000.00 4,756.57 534.00 26.43 13,243.43 100‐5330‐30‐01 Copier Expense 3,613.00 3,613.00 1,136.09 635.71 31.45 2,476.91 100‐5335‐30‐01 Radio/Video Equip. and Repairs 27,500.00 27,500.00 909.00 669.00 3.31 26,591.00 100‐5340‐30‐01 Building Repairs 55,817.00 55,817.00 34,171.88 442.30 61.22 21,645.12 100‐5350‐30‐01 Vehicle Expense 44,000.00 44,000.00 19,219.74 7,408.09 43.68 24,780.26 100‐5352‐30‐01 Fuel 20,000.00 20,000.00 9,214.65 2,879.81 46.07 10,785.35 100‐5353‐30‐01 Oil/Grease/Inspections 1,000.00 1,000.00 231.83 28.50 23.18 768.17 100‐5400‐30‐01 Uniform Expense 43,000.00 43,000.00 850.80 24,149.20 1.98 18,000.00 100‐5418‐30‐01 IT Fees 2,000.00 2,000.00 174.58 8.73 1,825.42 100‐5430‐30‐01 Legal Fees 2,000.00 2,000.00 7,007.66 38.00 350.38 ‐ 5,007.66 100‐5440‐30‐01 EMS 131,857.00 131,857.00 58,599.21 19,042.03 37,243.43 44.44 36,014.36 100‐5445‐30‐01 Emergency Management 28,000.00 28,000.00 21,716.41 77.56 6,283.59 100‐5480‐30‐01 Contracted Services 10,170.00 10,170.00 2,779.75 165.95 27.33 7,390.25 27Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5520‐30‐01 Telephones 1,525.00 1,525.00 753.28 190.64 49.40 771.72 100‐5523‐30‐01 Water/Sewer Charges 7,643.00 7,643.00 4,976.97 634.64 65.12 2,666.03 100‐5524‐30‐01 Gas 13,000.00 13,000.00 1,791.90 974.08 13.78 11,208.10 100‐5525‐30‐01 Electricity 50,000.00 50,000.00 9,943.76 ‐ 51.93 19.89 40,056.24 100‐5526‐30‐01 Data Network 9,176.00 9,176.00 3,732.49 1,357.84 40.68 5,443.51 100‐5530‐30‐01 Travel 6,500.00 6,500.00 2,905.63 1,538.89 44.70 3,594.37 100‐5533‐30‐01 Mileage Expense 1,500.00 1,500.00 558.78 35.97 37.25 941.22 100‐5536‐30‐01 Training/Seminars 29,536.00 29,536.00 7,718.75 ‐ 220.05 26.13 21,817.25 100‐5610‐30‐01 Fire Fighting Equipment 20,000.00 20,000.00 2,156.63 120.00 10.78 17,843.37 100‐5620‐30‐01 Tools & Equipment 320.00 320.00 338.51 ‐ 57.96 105.78 ‐ 18.51 100‐5630‐30‐01 Safety Equipment 99,561.00 99,561.00 45,919.30 4,872.04 46.12 53,641.70 100‐6140‐30‐01 Capital Expense‐Equipment 82,300.00 82,300.00 90,080.58 17,792.54 957.87 109.45 ‐ 8,738.45 100‐7145‐30‐01 Transfer to VERF 291,085.00 291,085.00 97,028.32 24,257.08 33.33 194,056.68 100‐5110‐30‐05 Salaries & Wages 188,489.00 188,489.00 61,422.65 18,153.96 32.59 127,066.35 100‐5115‐30‐05 Salaries ‐ Overtime 22,904.00 22,904.00 4,095.52 1,682.64 17.88 18,808.48 100‐5140‐30‐05 Salaries ‐ Longevity Pay 875.00 875.00 810.00 92.57 65.00 100‐5143‐30‐05 Cell Phone Allowance 1,800.00 1,800.00 600.00 150.00 33.33 1,200.00 100‐5145‐30‐05 Social Security Expense 13,272.00 13,272.00 3,832.24 1,160.77 28.88 9,439.76 100‐5150‐30‐05 Medicare Expense 3,105.00 3,105.00 896.25 271.48 28.87 2,208.75 100‐5155‐30‐05 SUTA Expense 342.00 342.00 342.00 100‐5160‐30‐05 Health Insurance 17,166.00 17,166.00 5,721.68 1,430.42 33.33 11,444.32 100‐5165‐30‐05 Dental Insurance 958.00 958.00 319.28 79.82 33.33 638.72 100‐5170‐30‐05 Life Insurance/AD&D 751.00 751.00 256.79 66.29 34.19 494.21 100‐5175‐30‐05 Liability (TML)/Workers' Comp 4,240.00 4,240.00 753.15 230.87 17.76 3,486.85 100‐5180‐30‐05 TMRS Expense 29,884.00 29,884.00 8,975.37 2,697.42 30.03 20,908.63 100‐5185‐30‐05 Long/Short Term Disability 348.00 348.00 116.02 34.49 33.34 231.98 100‐5186‐30‐05 WELLE‐Wellness Prog Reimb Empl 600.00 600.00 250.00 100.00 41.67 350.00 100‐5191‐30‐05 Hiring Cost 2,300.00 2,300.00 2,300.00 100‐5193‐30‐05 Records Retention 250.00 250.00 250.00 100‐5194‐30‐05 FD Annual Phy & Screening 1,614.00 1,614.00 1,614.00 100‐5210‐30‐05 Office Supplies 250.00 250.00 65.19 26.08 184.81 100‐5215‐30‐05 Ammunition 1,250.00 1,250.00 1,250.00 100‐5220‐30‐05 Office Equipment 300.00 300.00 159.98 53.33 140.02 100‐5230‐30‐05 Dues,Fees,& Subscriptions 350.00 350.00 350.00 100‐5240‐30‐05 Postage and Delivery 60.00 60.00 60.00 100‐5250‐30‐05 Publications 550.00 550.00 550.00 100‐5280‐30‐05 Printing and Reproduction 500.00 500.00 500.00 100‐5295‐30‐05 Public Education/Fire Prevent 4,000.00 4,000.00 1,799.00 50.00 44.98 2,201.00 100‐5335‐30‐05 Radio/Video Equip. and Repairs 500.00 500.00 500.00 100‐5350‐30‐05 Vehicle Expense 2,300.00 2,300.00 1,598.33 1,514.93 69.49 701.67 100‐5352‐30‐05 Fuel 4,000.00 4,000.00 628.62 171.08 15.72 3,371.38 100‐5353‐30‐05 Oil/Grease/Inspections 750.00 750.00 750.00 100‐5400‐30‐05 Uniform Expense 2,050.00 2,050.00 2,050.00 28Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5430‐30‐05 Legal Fees 2,500.00 2,500.00 2,500.00 100‐5480‐30‐05 Contracted Services 2,150.00 2,150.00 2,150.00 100‐5526‐30‐05 Data Network 1,365.00 1,365.00 455.88 227.94 33.40 909.12 100‐5530‐30‐05 Travel 1,200.00 1,200.00 1,200.00 100‐5533‐30‐05 Mileage Expense 750.00 750.00 750.00 100‐5536‐30‐05 Training/Seminars 4,700.00 4,700.00 1,223.00 250.00 26.02 3,477.00 100‐5620‐30‐05 Tools & Equipment 450.00 450.00 156.58 156.58 34.80 293.42 100‐5630‐30‐05 Safety Equipment 6,450.00 6,450.00 2,145.69 2,145.69 33.27 4,304.31 100‐7145‐30‐05 Transfer to VERF 7,953.00 7,953.00 2,651.00 662.75 33.33 5,302.00 100‐5110‐40‐01 Salaries & Wages 848,934.00 848,934.00 244,319.21 61,703.76 28.78 604,614.79 100‐5115‐40‐01 Salaries ‐ Overtime 7,500.00 7,500.00 4,590.74 17.89 61.21 2,909.26 100‐5140‐40‐01 Salaries ‐ Longevity Pay 2,855.00 2,855.00 3,635.00 805.00 127.32 ‐ 780.00 100‐5143‐40‐01 Cell Phone Allowance 3,420.00 3,420.00 1,140.00 285.00 33.33 2,280.00 100‐5145‐40‐01 Social Security Expense 53,644.00 53,644.00 14,404.86 3,577.71 26.85 39,239.14 100‐5150‐40‐01 Medicare Expense 12,547.00 12,547.00 3,368.89 836.73 26.85 9,178.11 100‐5155‐40‐01 SUTA Expense 2,394.00 2,394.00 2,394.00 100‐5160‐40‐01 Health Insurance 94,471.00 94,471.00 31,357.22 9,054.98 33.19 63,113.78 100‐5165‐40‐01 Dental Insurance 5,378.00 5,378.00 1,690.36 395.50 31.43 3,687.64 100‐5170‐40‐01 Life Insurance/AD&D 1,483.00 1,483.00 483.07 117.25 32.57 999.93 100‐5175‐40‐01 Liability (TML)/Workers' Comp 3,159.00 3,159.00 921.59 230.39 29.17 2,237.41 100‐5180‐40‐01 TMRS Expense 120,612.00 120,612.00 34,039.72 8,463.24 28.22 86,572.28 100‐5185‐40‐01 Long/Short Term Disability 1,568.00 1,568.00 464.28 117.24 29.61 1,103.72 100‐5186‐40‐01 WELLE‐Wellness Prog Reimb Empl 300.00 300.00 25.00 25.00 8.33 275.00 100‐5210‐40‐01 Office Supplies 7,050.00 7,050.00 414.77 5.88 6,635.23 100‐5212‐40‐01 Building Supplies 3,500.00 3,500.00 1,053.02 161.26 30.09 2,446.98 100‐5220‐40‐01 Office Equipment 6,430.00 6,430.00 1,193.31 18.56 5,236.69 100‐5230‐40‐01 Dues,Fees,& Subscriptions 2,200.00 2,200.00 235.00 335.00 10.68 1,965.00 100‐5240‐40‐01 Postage and Delivery 50.00 50.00 1.26 2.52 48.74 100‐5250‐40‐01 Publications 2,775.00 2,775.00 950.56 950.56 34.25 1,824.44 100‐5280‐40‐01 Printing and Reproduction 1,000.00 1,000.00 60.63 6.06 939.37 100‐5290‐40‐01 Other Charges and Services 65.60 65.60 ‐ 65.60 100‐5310‐40‐01 Rental Expense 3,406.00 3,406.00 1,431.00 294.15 1,975.00 42.01 100‐5330‐40‐01 Copier Expense 1,767.00 1,767.00 426.19 135.30 24.12 1,340.81 100‐5340‐40‐01 Building Repairs 5,000.00 5,000.00 1,883.20 1,299.95 37.66 3,116.80 100‐5350‐40‐01 Vehicle Expense 3,500.00 3,500.00 1,303.00 433.00 37.23 2,197.00 100‐5352‐40‐01 Fuel 6,000.00 6,000.00 2,482.14 587.45 41.37 3,517.86 100‐5353‐40‐01 Oil/Grease/Inspections 1,160.00 1,160.00 376.54 57.00 32.46 783.46 100‐5400‐40‐01 Uniform Expense 3,250.00 3,250.00 50.28 1.55 3,199.72 100‐5410‐40‐01 Professional Services 271,000.00 3,500.00 274,500.00 20,230.18 233,269.82 7.37 21,000.00 100‐5418‐40‐01 IT Fees 33,060.00 33,060.00 34,760.00 500.00 105.14 ‐ 2,200.00 100‐5419‐40‐01 IT Licenses 870.00 870.00 870.00 100‐5430‐40‐01 Legal Fees 500.00 500.00 500.00 100‐5465‐40‐01 Public Relations 500.00 500.00 225.49 225.49 45.10 274.51 29Item 5b
Account DescriptionCurrent Current Currrent Current Current Encumbrances Percent YTD CurrentYearYearYearYTDMonth%RemainingAdopted Budget Amendment Amended Budget Actual ActualBudget100‐5475‐40‐01 Credit Card Fees 18,000.00 18,000.00 3,742.89 990.15 20.79 14,257.11 100‐5480‐40‐01 Contracted Services 4,440.00 4,440.00 1,660.19 960.19 37.39 2,779.81 100‐5523‐40‐01 Water/Sewer Charges 387.00 387.00 135.93 37.56 35.12 251.07 100‐5525‐40‐01 Electricity 6,500.00 6,500.00 1,901.22 811.98 29.25 4,598.78 100‐5526‐40‐01 Data Network 3,648.00 3,648.00 1,215.68 607.84 33.33 2,432.32 100‐5530‐40‐01 Travel 4,858.00 4,858.00 317.97 ‐ 111.34 6.55 4,540.03 100‐5533‐40‐01 Mileage Expense 2,050.00 2,050.00 65.27 3.18 1,984.73 100‐5536‐40‐01 Training/Seminars 10,990.00 10,990.00 2,334.01 482.26 21.24 8,655.99 100‐5620‐40‐01 Tools & Equipment 1,000.00 1,000.00 1,000.00 100‐5630‐40‐01 Safety Equipment 1,500.00 1,500.00 1,500.00 100‐5640‐40‐01 Signs & Hardware 4,561.00 4,561.00 354.15 7.77 4,206.85 100‐7145‐40‐01 Transfer to VERF 29,053.00 29,053.00 9,684.32 2,421.08 33.33 19,368.68 100‐5110‐40‐02 Salaries & Wages 85,103.00 85,103.00 16,501.60 4,156.00 19.39 68,601.40 100‐5115‐40‐02 Salaries ‐ Overtime 400.00 400.00 400.00 100‐5140‐40‐02 Salaries ‐ Longevity Pay 450.00 450.00 445.00 98.89 5.00 100‐5143‐40‐02 Cell Phone Allowance 450.00 450.00 450.00 100‐5145‐40‐02 Social Security Expense 5,358.00 5,358.00 917.53 224.38 17.12 4,440.47 100‐5150‐40‐02 Medicare Expense 1,254.00 1,254.00 214.59 52.48 17.11 1,039.41 100‐5155‐40‐02 SUTA Expense 342.00 342.00 342.00 100‐5160‐40‐02 Health Insurance 12,628.00 12,628.00 3,205.28 801.32 25.38 9,422.72 100‐5165‐40‐02 Dental Insurance 653.00 653.00 151.60 37.90 23.22 501.40 100‐5170‐40‐02 Life Insurance/AD&D 137.00 137.00 37.52 9.38 27.39 99.48 100‐5175‐40‐02 Liability (TML)/Workers' Comp 395.00 395.00 71.16 17.45 18.02 323.84 100‐5180‐40‐02 TMRS Expense 11,910.00 11,910.00 2,283.93 562.31 19.18 9,626.07 100‐5185‐40‐02 Long/Short Term Disability 160.00 160.00 31.36 7.90 19.60 128.64 100‐5186‐40‐02 WELLE‐Wellness Prog Reimb Empl 300.00 300.00 300.00 100‐5210‐40‐02 Office Supplies 900.00 900.00 14.99 1.67 885.01 100‐5220‐40‐02 Office Equipment 3,455.00 3,455.00 378.00 10.94 3,077.00 100‐5230‐40‐02 Dues,Fees,& Subscriptions 520.00 520.00 465.00 465.00 89.42 55.00 100‐5240‐40‐02 Postage and Delivery 750.00 750.00 245.90 210.89 32.79 504.10 100‐5280‐40‐02 Printing and Reproduction 310.00 310.00 310.00 100‐5350‐40‐02 Vehicle Expense 1,320.00 1,320.00 1,320.00 100‐5352‐40‐02 Fuel 1,080.00 1,080.00 285.78 77.13 26.46 794.22 100‐5353‐40‐02 Oil/Grease/Inspections 225.00 225.00 225.00 100‐5400‐40‐02 Uniform Expense 450.00 450.00 450.00 100‐5430‐40‐02 Legal Fees 1,000.00 1,000.00 437.00 76.00 43.70 563.00 100‐5435‐40‐02 Legal Notices/Filings 250.00 250.00 250.00 100‐5480‐40‐02 Contracted Services 115,430.00 115,430.00 50,513.50 22,946.75 70,243.50 43.76 ‐ 5,327.00 100‐5520‐40‐02 Telephones 510.00 510.00 104.34 26.13 20.46 405.66 100‐5523‐40‐02 Water/Sewer Charges 30.00 30.00 10.60 2.93 35.33 19.40 100‐5526‐40‐02 Data Network 456.00 456.00 151.96 75.98 33.33 304.04 100‐5530‐40‐02 Travel 1,540.00 1,540.00 1,540.00 100‐5533‐40‐02 Mileage Expense 250.00 250.00 250.00 30Item 5b