HomeMy WebLinkAbout07.14.14 Work Session Packet City of Farmington Mission Statement
430 Third Street Through teamwork and cooperation,
Farmington,MN 55024 the City of Farmington provides quality
services that preserve our proud past and
foster a promising future.
AGENDA
CITY COUNCIL WORKSHOP
July 14, 2014
6:30 p•m•
Conference Room 170
1. CALL TO ORDER
2. APPROVE AGENDA
3. 2015 BUDGET DISCUSSION
4. CITY ADMINISTRATOR UPDATE
5. ADJOURN
PUBLIC INFORMATION STATEMENT
Council workshops are conducted as an informal work session.All discussions shall be considered fact-finding,hypothetical and unofficial
critical thinking exercises,which do not reflect an official public position.
Council work session outcomes should not be construed by the attending public and/or reporting media as the articulation of a formal Ciry policy
position. Only official Council action normally taken at a regularly scheduled Council meeting should be considered as a formal expression of
the City's position on any given matter.
`off RMiy� City of Farmington
��y' 430 Third Street
N Farmington,Minnesota
`tea 651.280.6800•Fax 651.280.6899
q pAO
www.ci.farmington.mn.us
TO: Mayor, Council and City Administrator
FROM: Robin Hanson,Finance Director
SUBJECT: Draft 2015/2016 Non-General Fund Budgets
DATE: July 14,2014
INTRODUCTION:
During your June workshop you reviewed the draft 2015-2016 budgets for the General Fund and
Debt Service Funds. During the July workshop you will review the remaining budgets.
DISCUSSION:
The funds included for review in this packet include the Special Revenue, Capital Projects and
Enterprise Funds.
Special Revenue Funds (Exhibit A)
These funds account for the proceeds of specific revenue sources that are restricted to
expenditure for specific purposes.
EDA—The EDA 2015 budget includes $40,000 in general tax levy dollars for its ongoing
economic development operations and$50,000 in local government aid for the proposed VRC
hotel assessment subsidy.
Also included in the budget is funding related to implementation of the Marketing Plan
completed by Nemer Fieger at the end of 2013. A facilitated review and work session on a new
three-year Strategic Plan for Economic Development is scheduled to occur during the fourth
quarter of 2015.
TIF-City Center—The decertification date for this district is December 31, 2020, although,the
bonds for this TIF district will be fully repaid in 2015. Staff will work with Ehlers to determine
the next steps for this fund,including the impacts, if any, of decertification.
TIF—Eagles -- The decertification date for this district is December 31, 2014. Staff will work
with Ehlers to determine the next steps for this fund.
Police Donations&Forfeitures—The source of revenue for this fund is the sale of assets from
forfeiture proceedings and donations to the K-9 program. The use of forfeiture proceeds is
restricted to DWI enforcement, including training, equipment and personnel. Modest activity is
projected for the next two years.
Park Improvement Fund—The 2015 Requested Park Improvement Fund Budget includes
$40,000 in transfers from the liquor stores and has a planned expenditure of$200,000 for
construction of a new building in North Creek Park that would include the following major
features:
• restrooms for park users
• an open room area that could be used as a warming house for the existing outdoor hockey
and pleasure rinks during the winter and for Departme�rograms and public rentals the
rest of the year
y ; 1
▪ gabled overhang that o serve picnics t��
• storage room for supplies equipment � ��,#'
•
The Parks and Recreation Department currentl.< is a portable w g house from mid-
to be programmed
December to late February. The construction'6 s building would alto � p gr
and used year-round for rentals (picnic and meetipg Park an .Recreationo ams/special
d'',,.�,��3 P��1'P. 'dam�r���
events and as a warming house in the winter. This'bldin .'a,=included in X007 City
Council approved master plan for NO reek Park. ) gf d, it would requfe hiring an
architectural firm to complete the bull,: le ign and o� rs'-a the construction of the building.
The building is envisioned to be appro" " a� :x•300 squar"egp in size at an estimated cost of
$135 square foot to construct,which wo mclue ign and•.construction fees. The remainder
of the cost would be assn 4v1th cons * Ming a ga xoof oni' e end of the building that
would allow access toppnteri of the bu `ling fb id; g a picnic/gathering area outside
under the shelter roof: The Parksand Recreations��<fmmissionrlias reviewed this request and
recommended to staff?iclude t m the 201 quested Park Improvement Fund Budget d
Ice Arena '1 Axena b�'de irt'clu e,s ;$20,0�0�general tax levy operating subsidy.
f,,."- 41* -:\x„,-", vo,,,,,,,„.You -�n to the 2015 b 'diet has a roposed deficit of$18,000+. The deficit relates to the
investmentt�&the following i ens: a o, ,, oint-of-sale system at the ice arena so debit/credit
cards can be aceipted,purch,..r,,;;;?',..,of additiortal skates for their new skate rental program, increased
costs related to 47 mer ice,the.;" urchase and installation of surveillance cameras at the facility
and expansion of -er -fi thro Jj ut the arena to provide public access for guests. The existing
fund balance of$83, o),is sufgroat to absorb the proposed deficit.
{
Capital Project Funds (Exhibit B)
These funds are maintained to account for financial resources segregated for the acquisition or
construction of major capital facilities or purchase of capital equipment. Projects are financed
through the issuance of debt, special assessments,tax levies, dedicated fees and
intergovernmental aids or grants.
Sanitary Sewer Trunk–This fund is used to account for the construction and improvement of
sanitary sewer trunk facilities in the city. There are no planned expenditures for this fund in 2015
or 2016. In 2013 a portion of these funds were used for the Trunk Highway 3 project.
Cable Communications Fund – There are two revenue sources that fund the Cable
Communications Fund—franchise fees and Public, Education and Government Access (PEG)
fees. In 2013, the City collected $234,571 in franchise fees of which $134,571 was allocated to
the cable communications fund and $100,000 was allocated to the general fund. PEG have very
strict legal limitations on their use, therefore, all PEG fees are allocated to the cable
communications fund;they totaled$25,099 for 2013.
The current joint powers operating budget is approximately $184,000 per year. Farmington is
responsible for one quarter of that cost. Included in those costs are staffing, programing,
program production, management of public access bulletin boards, system maintenance and
franchise administration.
,..74
Other expenses include any legal costs associated with;�tlac ble franchise (i.e. — franchise
renewal, audit, and franchise compliance). Addition. _;.' bnington is working with Apple
Valley to develop a"news magazine"that covers both cities ari}.the Cable Communication Fund
will cover any additional costs that may entail.Ala , �' r
The City's projected future capital need,;=$ `fits equipment, f `a-,dic replacements, are
t3' P j p � p' r.�� p
approximately$85,000 over ten years. The Ci fi;share of shared joint peOpys capital equipment
is estimated to be approximately $125,000 over t nyears.1� *refore, Farmigton can expect to _
see approximately$210,000 in capit costs over the co if a ten year franclfse
Road and Bridge/Street Reconstruction u r o new prof' ts,are being added to this fund; it is
in `run-off'. Available funds are first be used su port related bond issues and over time are
factored into the City's Ca ital Improvemen�I't�+,pPlan. ... .,,; pp,ay recal tthe •
activity for this fund is
shown in great detail o t ie�'\ aGllpaper hang in QOiifere ee Rodin 170.
F'
Fire Capital Projects 'lh Fire Capital Projec s and budget includes donations from the Fire
Relief Association and
VI:s fort � CIP.
The 201e:p'endie. includew g 4500 for fii�_ ter=fitness incentives and$60,000 for Brush
•�`��' ,ice`°^' x�;.� ''"�s��.�,�"a",�
Truckilr � a firefighter fitness irigtitive program envisions a$25 reimbursement for any
firefighi lgrt goes to a fl ea§ gym a deist 8 times per month. The individual firefighter would
be responsible',for obtaining sasfactor§'cidcumentation. This information would be reviewed
and compiled hype Fire Reliessociation Secretary and submitted to HR for reimbursement
semi-annually. f t]r�'e Council is terested in supporting this initiative,then staff will draft a
policy and bring it b�ac � o Co `G l�for review and approval.
The 2015 Fire CIP also pl'anfied for two fire chief's vehicles. One of those is being made
available to the Fire department in 2014 through the repurposing of the second SRO vehicle.
The second vehicle is planned to be made available to the fire department in 2016 with the
repurposing of the existing Commercial Inspector vehicle currently in the Police department.
The 2016 expenditures include$2,500 for the continuation of the firefighter fitness incentives,
$310,000 for CIP purchases (Brush Truck 2 and Tender 2), and$35,000 for a Kubota UTV. The
UTV would only be purchased if the net donations received from the Fire Relief Association
were sufficient to cover the purchase price. This piece of equipment is essentially a small truck
which is equipped with tracks for floatation purposes. When needed,it would be towed behind a
brush truck It would be used for fighting grass fires and could be used to assist with snowmobile
crashes,rescue, lost persons, etc.
•
Storm Water Trunk—The 2015 budget includes $300,000 for the potential purchase of right-of-
way for the regional ponding that will be constructed in conjunction with the 195th Street Project.
•
Assuming it makes financial sense at the time,the 2016 transfers line item includes $1,385,000
to be used for the early redemption of the 2005C bonds which are optionally redeemable on
2/1/16. Given the relatively small remaining balance for this bond issue and interest rates ranging
from 3.875% -4.4%it would make more sense to internally finance the refunding of these bonds
and then repay the Storm Water Trunk Fund with debt levy dollars than incurring the costs of
issuance and underwriter's discount associated with a bond re, ing.
This fund could also be the source of the estimated$670 : t finance option four for the
existing pool (i.e. filling-in of existing pool and creatig splash,deck). This would need to be
done through a formal interfund loan process and re ,oid`with debbm dollars, similar to the
arrangement for the new fire engine.
•
a� r.
Recreation Capital Projects Fund—The Rambling t er Cen continues to iraise and
receive donations so im rovements,bit e buildin c `b' co ` leted or a ui m•rti can be
p � g �� p q P
purchased for building operations. Ii#t °lly> he Ramblin• River Center Advisory Board created a
list of items it identified to raise monelOplegFicompretop list of items that have been
completed/purchased over the past 1.5 ys andJ-.ist�of item' yy to be purchased/completed
has been included in the b -e, workshop%p�.cket as�= ' bit F.Asi- , ds are raised and placed
into the Recreation Ca;iit' :1�=Prdj.ects Fund,t ie y dvi i =�Baar i;, • ake recommendations to
staff if it involves th'..purchase equipment tha i portant to:ivfi'operations of the building. If a
building improvementitte .,to be c ipleted in oyes hiring a contractor,the Advisor Board will
make a recommendation" a ie Pars%and Recreat%aCommission, who in turn will make a
err rr
recommend 1o4*Alp City y9 dil`to 4 ,into a. greement with the contractor to complete
the build =iinproveie`iit after?gtes have� e6i olieited and tabulated.
.3*,r ✓rte ;�"
Private Capi,taIProjects Fund 'Y° his fun ;s used to account for engineering and administrative
fees incurredsg t ee city relatedtn�privatefdevelopment projects. These costs are then billed to
the respective developments.
Permanent ImprovemenVRe civifig Fund --This fund has had little activity the past several
years. Staff plans to reviewfhrs fund in detail later this fall to determine whether it should
Y P �;
continue as a separate fund or the remaining assets transferred to another fund.
General Capital Equipment --This is a new fund which will ultimately be used to capture funds
.designated for new equipment purchases. The one exception is equipment purchases for the fire
department from now through 2020 which will be purchased out of the Fire Capital Projects
fund.
For 2015 approximately$85,000 of general tax levy dollars are being transferred into this fund
for the purchase of two new squad cars. In addition$80,000 of LGA funds are being transferred
in to be used for vehicle replacements This fund envisions the discretionary dollars will be
available to Todd Reiten to recommend to Council those instances where it no longer makes
financial sense to repair a vehicle or the City is no longer able to get parts for a vehicle that needs
to be repaired. Council will need to approve the expenditure of these discretionary funds before
disbursement.
The proceeds from the sale of non-forfeiture vehicles will also be captured in this fund to be used
for future vehicle purchases.
Maintenance Fund—Dollars for seal coating,building maintenance,trail maintenance and street
reconstruction are included in this fund. The significant expenditure in 2015 relates to the
planned reconstruction of 195th street. This project will be paid for with bond proceeds which
will be issued in 2015.a for trail maintenance.
$310K for coating, $15K for building
maintenance and$30K aintenance
•
Enterprise Funds (Exhibit C) M rr�>
These funds are established to account for City,oPations that are financed and operated like
private business enterprises. Revenues are gerated primarily through customer charges from
those who utilize the services provided by the activity. Operating expense4e budgeted in
accordance with expected revenues from the operatiohss. Th ty uses enterprii funds to
account for its liquor operations, and solid wasfr `water,water, an ±street light
utility operations.
Liquor Operations—The revenues for s�budge;h"a<vee histori lly been combined into a single
��i/3? J Y dd
liquor sales line item. Fo2O1this line i e .has bee o� . •er br yen down into the three major
sales categories: liquor wine ,,beer. � 44 ,
4•
In addition with the Lo Store Manager no ' ••g one and one-half years' experience with
the two stores staff was ab�to car's ly, review • 'd refine the various expenditure line items
based on ao x`:erience. f a ro po e` ,udgets project the profit before operating transfers as
a% of g 'sales for 2,015 and 20 6 to be approximately 6.1%,which is within striking distance
of the '; s 6.5%target f t,the lic r stores. j�,5f
Sewer—The b dget for this Fund shows a 2rojected deficit for two reasons: 1) a$750,000
expenditure m 2 5 to rebuild thersewer lie near the north-end of town along Pilot Knob. This
project will be dotfe n conjunct on3 with a development in Lakeville just north of the city limits.
and 2)the current rat ruc S iot sufficient to cover both operating costs and depreciation.
Staff plans to complete at i hal ysis later this summer/early fall and come back to you with
proposed sewer rates for 2(:15 and beyond to begin to address this deficit. This analysis will be
similar to the long-term financial plan that was adopted for the Water Fund.
Solid Waste—The one item of note here is that the 2015 budget for professional services is less
than the costs incurred in.2013. The 2015 amounts reflected the anticipated savings as a result of
the new recycling contract recently approved by Council.
Storm Water--The budget for this fund shows a projected deficit. In addition the projected fund
• balance on Exhibit D forecasts a deficit. Staff plans, along with the Sewer Fund mentioned
above,to complete a rate analysis later this summer/early fall and come back to you with
proposed storm water rates for 2015 and beyond to begin to address this deficit. This analysis
will be similar to the long-term financial plan that was adopted for the Water Fund.
Water—The water fund continues to show a projected deficit due to depreciation expense.
However,it is consistent with the long-term financial plan adopted for the Water Fund and the
new fees that became effective January 1,2014 are beginning to compensate for the projected
future deficits attributable to the depreciation expense.
The 2015 budget includes normal operating expenses as well as$15K for SCADA software and
hardware updates and$15K for an Arc Flash study for the well houses.
Streetlights—This fund accounts for the revenues and expenditures related to maintaining the
city's streetlights. There are no unusual items of note for 2015;W016.
ii",
Fund Balance Recap (Exhibit D) %.z7 ,fir,
�'r.te'
The new budget software does not allow for the ance to b�ex' cluded on the budget
sheets. So,included in your packet, as Exhibit Darithe •individu lfjiid balances for the
various funds included in this budget review.g; `ce some of the funds Wave projected
expenditures in excess of revenues and are rel gfon their fund balances 44,sorb the
difference, staff thought this information would 5 , in yo `eyiew and un t''°� landing how
those deficits would be funded. ��, ,�,,to
Other Item—Technology - ,,, f /,r
r �,.f..
The city's Information 71', 31ogy(IT)su. port ands v- tment i i;computer hardware and
software is accounted 4m tte nformatio d chno o I. 4351,0 al ser ice fund and charged back
to the various departiAS throuilPthe IT serylc'es a item.�S'aff thought it may be helpful to •
review the summary ini, ation vd Council s, %ou could see what the overall investment in
information technology enc� pas3,,Pe attaclf,'d,Exhibit E provides a summary for you. •
rY - r;-�4`r'' ''f' fir
BUDGL�''IAWACT •. f
All infor orn is related talks e develi went of the 2015 city budgets.
ACTION REQ;UI STED: 'f%r>.
Provide feedback�Eostaff on the`p}roposed budgets.
Department heads will"'b'ef�njaltt' dance at the work session to answer any questions you may
have or provide additional-in {ght into their proposed budgets.
•sue
Respectfully submitted, Robin Hanson,Finance Director
1 xX;bi t
Special Revenue Funds Budget Summary
2013 Actual,2014 Final,2016 Proposed and 2016 Proposed
December YTD December YTD December YTD December YTD
Company Actual Budget Budget Entry Budget Entry
2013 2014 2015 2016
Revenues
EDA(2000) 132,258 2,050 750 750
TIF-City Center(2050) 129,725 135,000 137,120 2,120
■ TIF-Eagles(2051) 0 14,000 190 190
( .
Police Donations&Forfeitures 2100) 13,415 5,000 j 5,060 5,060
Park Improvement Fund(2300) 86,621 52,8601 33,070 33,857
Ice Arena(2500) 279,692] 285,100 I 289,860 295,360
' Total Revenues 641,710' 494,010] 466,050 337,337
Expenditures
EDA(2000) 68,255 42,013' 42,070 42,459
TIF-City Center(2050) 11,595 9,304 9,304
TIF-
Eagles(2051) 1,657 14,000 0
' Police Donations&Forfeitures(2100) 20,449 6,500 6,500 6,500
Park Improvement Fund(2300) 128,879 80,000 200,000 70,000
Ice Arena(2500) 271,302, 298,450: 328,204 321,912
' Total Expenditures 502,137' 450,267] 586,078 440,871
Transfers
Transfers In 61,380 60,000 150,000 100,000
Transfers Out (155,672) (74,720) 0
Total Transfers (94,292) (14,720) 150,000 100,000
Change in Fund Balance 45,281 29,023 29,972 (3,534)
7/3/2014 12:55:45 PM Page 1 of 1
EDA All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Budget
Account 2013 2014 Entry 2015 Entry 2016
EDA EDA EDA EDA
4000-REVENUE AND EXPENDITURE �'
4001-REVENUES ■
4020-TAX INCREMENT EXCESS 30,690
Property Taxes 30,690
4404-FEDERAL GRANT 54,020
Intergovernmental 54,020
Charges For Services 0 0
4955-INTEREST ON INVESTM ENTS 2,005 2,050 750 750
Investment Income 2,005 2,050 750 750,
5350-MISCELLANEOUS REVENUE 45,543 0
Misc Revenue 45,543 0
Total Revenues $$ 132,258 $2,050 $750 $750
6001-EXPENDITURES
6250-OTHER SUPPLIES&PARTS 42 01
Supplies 42 01
6401-PROFESSIONAL SERVICES 37,300 1,000 10,000 1,000
6403-LEGAL 3,541 2,000 2,000 2,0001
6404-IT SERVICES 3,543 3,600 4,1891
6422-ELECTRIC 215 300 300 300
6426-INSURANCE 0 450 450 450
6450-OUTSIDE PRINTING 0 2,000 2,200 2,000
6460-SUBSCRIPTIONS&DUES 0 3,090 3,090 3,090
6470-TRAINING&SUBSISTANCE 0 4,930, 4,930 4,930
6485-MILEAGE REIMBURSEMENT 0 0
6550-DEVELOPER PAYMENTS 25,520
6570-PROGRAMMING EXPENSE 0 24,500 I 15,500 24,500
7420-OTHER 1,638 200; 0
Other Services 68,213 42,013 42,070 42,459
Capital Outlay 0 0 i ,
Total Exp 68,255 42,013 42,070 42,459
5205-OPERATING TRANSFERS 61,380 40,000; 90,000 40,000'
Transfers In 61,380 40,000: 90,000 40,0001,
7310-OPERATING TRANSFERS 0 0
Transfers Out 0 0
Other Financing Sources 61,380 40,000, 90,000 40,000
- - ----- -- ------------------- -Net Change in Fund Balance $125,383 $37 $48,680 ($1,709)
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
TIF-City Ctr All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
TIF-City Ctr TIF-City Ctr TIF-City Ctr TIF-City Ctr
■ 4000-REVENUE AND EXPENDITURE
4001-REVENUES
4020-TAX INCREMENT EXCESS 0
4025-TAX INCREMENT 129,725 135,000 135,000
Property Taxes 129,7251 135,000 135,000
4955-INTEREST ON INVESTMENTS 2,120 2,120
Investment Income 2,120 2,120
Total Revenues $129,725 $135,000 $137,120 $2,1201
6001-EXPENDITURES
Personnel Services I 0
6401-PROFESSIONAL SERVICES 3,460 4,100 4,100
6403-LEGAL 2,906
6455-LEGAL NOTICES PUBLICATIONS 26 1
6550-DEVELOPER PAYMENTS 5,203 5,204 5,204 I
Other Services 11,595 9,304 9,304
Total Exp 11,5951 9,304 9,304
Transfers In 0
7310-OPERATING 155,411 74,720
Transfers Out 155,411 74,720
Other Financing Sources (155,411) (74,720)
r... Net Change In Fund Balance
g ($37,282) $50,976 $127,816 $2,120
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
TIF-Eagles All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
TIF-Eagles TIF-Eagles TIF-Eagles TIF-Eagles
4000-REVENUE AND EXPENDITURE
4001-REVENUES-- - - - -----—-- - - -
4025-TAX INCREMENT 0 14,000 0
Property Taxes 0 14,000 0
4955-INTEREST ON INVESTMENTS 0 190 190
Investment Income 0 190 190
I' 'Total Revenues $0 $14,000 $190 $190
6001-EXPENDITURES
6401-PROFESSIONAL SERVICES 1,631 2,000 0
6455-LEGAL NOTICES PUBLICATIONS 26 0
6550-DEVELOPER PAYMENTS 12,000 0
Other Services 1,657 14,000 0
Total Exp 1,657 14,000 0
Transfers In 0
7310-OPERATING TRANSFERS 261 0
Transfers Out 261 0
Other Financing Sources (261) 0
1 Net Change in Fund Balance — ($1,918) $0 $190 $190
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Police Forfeitures All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Budget Dec YTD Budget Dec YTD Budget
Object Actual 2013 Entry 2015 Entry 2016
Account Police 2014 Police Police Police
Forfeitures Forfeitures Forfeitures Forfeitures
4000-REVENUE AND EXPENDITURE
4001-REVENUES
4955-INTEREST ON INVESTMENTS 0 60 60
Investment Income 0 60 60
5010-SALES OF ASSETS 8,529 5,000 5,000 5,000
5356-K-9 DONATIONS 4,886
Misc Revenue 13,415 5,000 5,000 5,0001
I' Total Revenues $13,415 $5,000 $5,060 $5,060
� 6001-EXPENDITURES
6220-EQUIP SUPPLIES&PARTS 246 2,500 2,500
6234-VEHICLE LICENSES,TAXES,FEES 83
6250-OTHER SUPPLIES&PARTS 4,052 2,500
Supplies 4,380 2,500 2,500 2,500
6401-PROFESSIONAL SERVICES 3,607 3,000 3,000 3,000
6403-LEGAL 3,392 1,000 1,000 1,000
6406-K-9 EXPENSE 175
Other Services 7,174 4,000 4,000 4,000
6940-VEHICLES 8,895
Capital Outlay 8,895 0
Total Exp 20,449 6,500 6,500 6,500'
Other Financing Sources
1- ______ -Net Change in Fund Balance ($7,034) ($1,500) ($1,440)d ($1,440);
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Park Imp Fd All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Actual Budget Entry Budget Entry
Account 2013 2014 2015 2016
Park Imp Fd Park Imp Fd Park Imp Fd Park Imp Fd
4000-REVENUE AND EXPENDITURE
4001-REVENUES
Intergovernmental 0 0
5045-PARK DEDICATION FEES 0 0
5046-PARK DEVELOPMENT FEES 40,831 20,784,
Charges For Services 40,831 20,784
4110-SPEC ASSESS CURRENT 25,405 10,658 25,000 25,000
4115-DELINQUENT SPECIAL ASSESSME 1,835 291
4120-SPEC ASSESS COUNTY PREPAID 6,745 0
4125-SPEC ASSESS PREPAID TO CITY 210 12,469
4130-SPEC ASSESS PENALTIES/INTERE 433 49
Special Assessments 34,628 23,467 25,000 25,000
4955-INTEREST ON INVESTMENTS 1,208 250 1,770 1,770
4960-GAIN/LOSS INVEST MKT VALUE (1,743) 0
Investment Income (535) 250 1,770 1,770
4975-RENTAL INCOME 9,360 6,300 6,300 7,087
5350-MISCELLANEOUS REVENUE 2,336 0
5355-DONATIONS 0 0
Mlsc Revenue 11,696 6,300, 6,300 7,087
Total Revenues $86,621 $50,801 $33,070 $33,857
6001-EXPENDITURES
Supplies 0 0
6401-PROFESSIONAL SERVICES 5,685 0
6492-ADVERTISING 0 105
7420-OTHER 0 4,959
Other Services 5,685 5,064'
6915-BUILDING&STRUCTURE 25,300 0
7010-CONSTRUCTION CONTRACTS 0 0
7020-OTHER CONSTRUCTION COSTS 97,791 54,867 200,000 70,000
Capital Outlay 123,091 54,867 200,000 70,000
7140-LEGAL&FISCAL FEES 104 80
Debt Service 104 80
Total Exp 128,879 60,011 200,000 70,000
5205-OPERATING TRANSFERS 40,0001 40,000
Transfers In 40,000 40,000
Transfers Out 0 0
Other Financing Sources 0 0 40,000 40,000
- Net Change in Fund Balance ($42,259) ($9,210) ($126,930) $3,857
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Ice Arena All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Ice Arena Ice Arena Ice Arena Ice Arena
4000-REVENUE AND EXPENDITURE
4001-REVENUES
4512-CUSTOMER SERVICES NONTAXAB 0_ _ _ 0
4668-CONCESSIONS 300 300 300 300
4810-ICE RENTAL 243,922 245,000 250,000 255,0001
4815-LESSONS 13,138 16,000 14,000 16,0001
4820-OPEN SKATE 6,087 3,500 5,000 5,000
4822-Skate Rental 8 1,500 1,500 1,500
4830-SKATE SHARPENING. 1,735 1,500 1,500 1,500'
4835-ADVERTISING 4,874 7,000 7,000 6,500
-SKATE SHOW 2,485 3,500 3,500 2,500
4845-MERCHANDISE SOLD 1,055 800 800 800
Charges For Services 273,605 279,100 283,600 289,1001
4955-INTEREST ON INVESTMENTS 260 260'
Investment Income 260 260
5350-MISCELLANEOUS REVENUE 1,163 1,000 1,000 1,000'
5355-DONATIONS 5,000 5,000 5,000 5,000
5370-CASH OVER&SHORT (76)
Mc Revenue 6,087 6,000 6,000 6,0001
Total Revenues $279,692 $285,100 $289,860 $295,360
6001-EXPENDITURES 1
5502-COST OF GOODS SOLD 319 1,400 1,400 1,400
-------- --- -------- --- --
Cost of Good Sold 319 1,400 1,400 1,400
6110-FULL TIME SALARIES 1 87,833 88,550 92,585 95,869
6112-FULL TIME OVERTIME 682 0
6120-PART TIME SALARIES 36,081 39,301 39,891 40,590
6130-COMPENSATORY TIME PAY 1,151 800 800 800,
6135-OTHER PAY 219 1,300 1,300 1,300
6152-FICA/MEDICARE 9,620 9,941 10,295 10,600,
6154-PERA 7,934 6,572 7,101 7,348'
4-_- -_6156-HCSP ---. I
121 200 200 200'1
6158-EMPLOYEE BENEFITS 13,140 10,000 20,000 21,4001
6159-WORKERS COMP 1,616 3,867 4,021 4,1391,
Personnel Services 158,396 160,531 176,193 182,2461
6220-EQUIP SUPPLIES&PARTS 292 12,600 12,000 7,000;
6240-BUILDING SUPPLIES&PARTS 7,988 7,600 7,950 7,950
6250-OTHER SUPPLIES&PARTS 610 750 750 750
6255-LANDSCAPING MATERIALS 175 50 50 50
6272-FUEL 2,207 2,200 2,400 2,800
6290-UNIFORMS&CLOTHING 550 1,200 1,200 1,200 1
Supplies 11,822 24,400 24,350 19,7501
6401-PROFESSIONAL SERVICES 13,696 7,000 9,000 9,000 1
6403-LEGAL 421 0 0 0
6404-IT SERVICES 9,872 7,819 18,311 11,266
6411-TELEPHONE 1 762 1,000 800 800
6412-CELLULAR PHONES 500 500 500
6421-MUNICIPAL SERVICES 3,980 6,000 6,000 6,000,
6422-ELECTRIC 38,876 43,000 44,000 44,000
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 2
•
Ice Arena All Business Unit
2013 Actual,2014 Budget,2016&2016 Proposed Budgets •
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Ice Arena Ice Arena Ice Arena Ice Arena
6423-NATURAL GAS 18,464 21,000 22,000 _22,0001
6426-INSURANCE 4,542 8,000 8,000 8,0001
6450-OUTSIDE PRINTING 0 500 500 5001
6460-SUBSCRIPTIONS&DUES 972 2,100 1,800 1,800
6470-TRAINING&SUBSISTANCE 632 1_,500 2,200 1,5001
6485-MILEAGE REIMBURSEMENT 47 0 0 01
' 6492-ADVERTISING 0 0 0 0
6505-EQUIPMENT REPAIR SERVICE 1,425 5,500 4,500 4,5001
6515-BUILDING REPAIR SERVICE 6,002 3,500 4,150 4,1501
• 6570-PROGRAMMING EXPENSE 1,068 4,700 4,500 4,5001
7420-OTHER 6
Other Services 100,765 112,119 126,261 118,5161
Capital Outlay 0 0
Total Exp 271,302 298,450 328,204 321,912;
5205-OPERATING TRANSFERS 0 20,000 20,000 20,000
Transfers In 0 20,000 20,000 20,000,
Other Financing Sources 0 20,000 20,000 20,0001
t • " Net Change.in Fund Balance $8,390 ' $6,650' ($18,344), ($6,552)
•
•
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 2 of 2
Capital Projects Funds Summary
2013 Actual,2014 Final,2015 Proposed,2016 Proposed
December YTD December YTD December YTD December YTD
Company Actual Budget Budget Entry Budget Entry
2013 2014 2015 2016
Revenues 1
Sanitary Sewer Trunk(3900) 105,031 30,000 34,790 32,290J
Cable Communications Fund(4000) 184,671 115,000 173,210 173,210
Road and Bridge/Street Reconstruction Fund(4100) 626,523 507,200 53,135 49,882 1,
Fire Capital Projects Fund(4300) 51,000 15,090 15,0901
•
Storm Water Trunk(4400) 182,415 10,000 36,270 28,770
Recreation Capital Projects Fund(4500) 21,325 5,140 5,1401
Private Capital Projects(4600) 1 14,806 50,000 21,990 21,990
Permanent Imp Revolving Fund(4900) 28,033 0 560 560
New-Gen'i Cap Equip Fund(5600)
Maintenance Fund(5700) 0 4,180 4,180
Total Revenues 1,213,805, 712,200 344,365 331,112
Expenditures
Sanitary Sewer Trunk 113,409 0
Cable Communications Fund 47,569 330,500 71,000 66,000
Road and Bridge/Street Reconstruction Fund(4100) 1601 0
Fire Capital Projects Fund(4300) 28,248 62,500 347,500
Storm Water Trunk Fund 664 60,000 350,000
Recreation Capital Projects Fund 137,943 7,500 7,500
Private Capital Projects 17,867 50,000 20,000 20,000
Permanent Imp Revolving Fund 410 0
New-Gen'l Cap Equip Fund(5600) 165,707 160,000
Maintenance Fund 204,649 300,000 5,020,000 300,000
Total Expenditures 550,917 740,500 5,696,707 901,000
Transfers
Transfers in 15,638,734 632,579 5,052,707 952,000
Transfers Out (17,486,419) (257,633) (518,633) (2,172,000)
Total Transfers (1,847,685) 374,946 4,534,074 (1,220,000)
Change in Fund Balance (1,184,798) 346,646 (818,268) (1,789,888)
7/3/2014 1:03:55 PM Page 1 of 1
Sanitary Sewer Trunk All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Budget Dec YTD Budget Dec YTD Budget
Object Actual 2013 2014 Sanitary Entry 2015 Entry 2016
Account Sanitary Sewer Trunk Sanitary Sewer Sanitary Sewer
Sewer Trunk - Trunk Trunk
4000-REVENUE AND EXPENDITURE
4001-REVENUES
4335-CITY SEWER ACCESS CHARGE 65,720 20,000 25,000 25,000
Permits 65,720 20,000 25,000 25,000
4470-MET.COUNCIL 23,328
Intergovernmental 23,328
4626-SEWER BENEFIT CHARGE
Charges For Services 0 0
4110-SPEC ASSESS CURRENT 12,408 10,000 7,500 5,000
4115-DELINQUENT SPECIAL ASSESSME 436
4120-SPEC ASSESS COUNTY PREPAID 1,574
4125-SPEC ASSESS PREPAID TO CITY 1,457
4130-SPEC ASSESS PENALTIES/INTERE 107
Special Assessments 15,983 10,000 7,500 5,000
4955-INTEREST ON INVESTMENTS 0 0 2,290 2,290
Investment Income 0 0 2,290 2,290
I 1 Total Revenues;.,
$105,031 $30,000 $34,790 $32,290
6001-EXPENDITURES
6401-PROFESSIONAL SERVICES 1,803
6455-LEGAL NOTICES PUBLICATIONS 157
Other Services 1,960
7010-CONSTRUCTION CONTRACTS 111,415 0
Capital Outlay 111,415 0
7140-LEGAL&FISCAL FEES 34
Debt Service 34
Total Exp 113,409 0
7310-OPERATING TRANSFERS 57,800 0
Transfers Out 57,800 0
Other Financing Sources (57,800) 0
-_Net Change in Fund Balance ($66,178) $30,000 $34,790 $32,290
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Cable Comm All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Cable Comm Cable Comm Cable Comm Cable Comm
4000-REVENUE AND EXPENDITURE 1 1
- -- --
4001-REVENUES
Property Taxes 0 0
Intergovernmental 0
5095-FRANCHISE FEE 184,671 115,000 170,000 170,000
Charges For Services 184,671 115,000 170,000 170,000
4955-INTEREST ON INVESTMENTS 3,210 3,210
Investment Income 3,210 3,2101
Misc Revenue 0
Total Revenues - - $184,671 $115,000 $173,210 - $173,210
6001-EXPENDITURES
6250-O THER SUPPLIES&PARTS 0 500 1,000 1,000
Supplies 0 500 1,000 1,0001,
6401-PROFESSIONAL SERVICES 47,569 330,000 70,000 65,000
Other Services 47,569 330,000 70,000 65,000
Capital Outlay 01
Debt Service 0 0
Total Exp 47,569 330,500 71,000 66,000
Transfers In 0 0
Transfers Out 0 0
Other Financing Sources 0 0
in Fund' $137,103', ($215,500) $102,210 $107,210
Net Change;i Balance
Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Rd&Br Fd(4100) All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Budget Dec YTD Budget Dec YTD Budget
Object Actual 2013 2014 Rd&Br Fd Entry 2015 Rd& Entry 2016 Rd&
Account Rd&Br Fd (4100) Br Fd(4100) Br Fd(4100)
(4100)
4000-REVENUE AND EXPENDITURE
4001-REVENUES
4426-MSA MAINTENANCE 591,1721
4428-MSA CONSTRUCTION 0 I 500,000
Intergovernmental 591,172 500,000
Charges For Services 0 0
4110-SPEC ASSESS CURRENT 18,644 7,200 25,565 22,3121
4115-DELINQUENT SPECIAL ASSESSME 2,384
4120-SPEC ASSESS COUNTY PREPAID 435
4125-SPEC ASSESS PREPAID TO CITY 13,0071
4130-SPEC ASSESS PENALTIES/INTERE 881
Special Assessments 35,351 7,200 25,565 22,312
4955-INTEREST ON INVESTMENTS 0 27,570 27,570
Investment Income 01 27,570 27,570
Refunds&Reimb 0
Misc Revenue 0'
Total Revenues $626,523! $507,200 $53,135 $49,882,
6001-EXPENDITURES
Personnel Services 0
Supplies 0
Other Services 0 0
Capital Outlay 0 0
7140-LEGAL&FISCAL FEES 160
Debt Service 160
Total Exp 160 0
Bond issue 0 0
5205-OPERATING TRANSFERS 390,587 202,000 177,000 102,000
5210-EQUITY TRANSFERS 13,393,689 0
Transfers In 13,784,276', 202,000 177,000 102,0001
7310-OPERATING TRANSFERS 3,827,297 50,000 311,000 117,000
7320-EQUITY TRANSFERS 13,393,689
Transfers Out 17,220,986 50,000 311,000 117,000;
Other Financing Sources (3,436,710) 152,000 (134,000) (15,000)
1 Net Change In Fund Balance ($2,810,348),', $659,200 ($80,865) $34,882
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
FIRE CAPITAL PROJECTS All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Budget Dec YTD Budget Dec YTD Budget
Object Actual 2013 2014 FIRE Entry 2015 FIRE Entry 2016 FIRE
Account FIRE CAPITAL CAPITAL CAPITAL CAPITAL
PROJECTS PROJECTS PROJECTS PROJECTS
4000-REVENUE AND EXPENDITURE
4001-REVENUES
Charges For Services 0
I
4955-INTEREST ON INVESTMENTS _ 0 90 901
Investment Income 0 90 90
5355-DONATIONS 51,000 15,000 15,000
Misc Revenue 51,000 15,000 15,000
TotaI'Revenues $51,000 $15,090 $15,090
6001-EXPENDITURES
6150-BENEFITS 2,500 2,500
Personnel Services 2,500 2,500
6220-EQUIP SUPPLIES&PARTS 1,122
6250-OTHER SUPPLIES&PARTS 984
6290-UNIFORMS&CLOTHING 14,916
Supplies 17,022
6401-PROFESSIONAL SERVICES 3,240
6450-OUTSIDE PRINTING 28
Other Services 3,268
6950-MACHINERY&EQUIP ENT 7,957 60,000 345,000 i
M
Capital Outlay 7,957 60,000 345,000
Total Exp 28,248 62,500 347,500
5205-OPERATING TRANSFERS 55,000 295,000'
1 Transfers In 55,000 295,000i
Transfers Out 0
Other Financing Sources 0 55,000 295,000
t Net Change in Fund Balance $22,752 - $7,590 ($37,410)1
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Storm Water Trunk All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Budget Dec YTD Budget Dec YTD Budget
Object Actual 2013 2014 Storm Entry 2015 Entry 2016
Account Storm Water Water Trunk Storm Water Storm Water
Trunk Trunk Trunk
4000-REVENUE AND EXPENDITURE
4001-REVENUES
4630-STORM WATER MANAGEMENT FEE 0 10,000 7,500
Charges For Services 0 10,000 7,500
4110-SPEC ASSESS CURRENT 68,428 0
4115-DELINQUENT SPECIAL ASSESSME 55,279
4120-SPEC ASSESS COUNTY PREPAID 38,936
4125-SPEC ASSESS PREPAID TO CITY 3,642
4130-SPEC ASSESS PENALTIES/INTERE 16,130
Special Assessments 182,415 0
4955-INTEREST ON INVESTMENTS 0 0 28,770 28,770
Investment Income 0 0 28,770 28,770
I Total Revenues $182,415 $10,000 $36,270 $28,770
6001-EXPENDITURES
6401-PROFESSIONAL SERVICES 10,000
7420-OTHER 0 50,000 0
Other Services 0 60,000 0
6910-LAND 0 300,000
7010-CONSTRUCTION CONTRACTS 0 0 50,000
Capital Outlay 0 0 350,000
7140-LEGAL&FISCAL FEES 664
Debt Service 664
Total Exp 664 60,000 350,000
5205-OPERATING TRANSFERS 0 0
Transfers In 0 0
7310-OPERATING TRANSFERS 207,633 207,633 207,633 2,055,000
Transfers Out 207,633 207,633 207,633 2,055,000
Other Financing Sources (207,633) (207,633) (207,633) (2,055,000)
Net Change In Fund Balance ($25,882) ($257,633) ($521,363) ($2,026,230)1
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Rec Cap Proj All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Rec Cap Proj Rec Cap Proj Rec Cap Proj Rec Cap Pro)
4000-REVENUE AND EXPENDITURE
4001-REVENUES
4955-INTEREST ON INVESTMENTS 140 140
Investment Income 140 140
5355-DONATIONS 21,325 5,000 5,000
Misc Revenue 21,325 5,000 5,000
Total Revenues ' $21,325 = $5,140 $5,140
6001-EXPENDITURES
6220-EQUIP SUPPLIES&PARTS 4,905 2,500 2,500
6240-BUILDING SUPPLIES&PARTS 3,430 2,500 2,500
Supplies 8,335 5,000 5,000
6401-PROFESSIONAL SERVICES 36,129
6492-ADVERTISING 183
6570-PROGRAMMING EXPENSE 4,158 2,500 2,5001
7420-OTHER 24
Other Services 40,493 2,500 2,500
7010-CONSTRUCTION CONTRACTS 22,000 1
7020-OTHER CONSTRUCTION COSTS 67,114 1
Capital Outlay 89,114
Total Exp 137,943 7,500 7,500
Bond issue 0
5205-OPERATING TRANSFERS 40,021
Transfers In 40,021
7310-OPERATING TRANSFERS 21
Transfers Out 21
Other Financing Sources 40,000
Net Change in Fund Balance ($76,618) i ($2,360) ($2,360)
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Priv Cap Proj All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Priv Cap Proj Priv Cap Proj Priv Cap Proj Priv Cap Proj
4000-REVENUE AND EXPENDITURE
4001-REVENUES
4610-ENGINEERING FEES-PROJECTS 13,849 50,000 20,000 20,000 I
Charges For Services 13,849 50,000 20,000 20,000
4110-SPEC ASSESS CURRENT 310
4115-DELINQUENT SPECIAL ASSESSME 318
4125-SPEC ASSESS PREPAID TO CITY 227
4130-SPEC ASSESS PENALTIES/INTERE 102
' Special Assessments 957
4955-INTEREST ON INVESTMENTS 0 1,990 1,9901
Investment Income 0 1,990 1,990!
Misc Revenue 0
Total Revenues $14,806 $50,000 $21,990 $21,990
6001-EXPENDITURES
6110-FULL TIME SALARIES 402
' 6152-FICA/MEDICARE 13
6154-PERA 12
Personnel Services 426
6401-PROFESSIONAL SERVICES 3,801 45,000 17,500 17,500
6403-LEGAL 0 5,000 2,500 2,500
7415-BAD DEBT EXPENSES 13,624
Other Services 17,425 50,000 20,000 20,000
7140-LEGAL&FISCAL FEES 16
Debt Service 16
' Total Exp 17,867 50,000 20,000 20,000
5205-OPERATING TRANSFERS (2,289)
Transfers In (2,289)
Transfers Out 0
Other Financing Sources (2,289)
Net,ChangeIn Fund Balance ($5,350) - $0 $1,990 $1,990
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Perm Imp Rev Fd All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Budget Dec YTD Budget Dec YTD Budget
Object Actual 2013 2014 Perm Imp Entry 2015 Perm Entry 2016 Perm
Account Perm Imp Rev Rev Fd Imp Rev Fd Imp Rev Fd
Fd
4000-REVENUE AND EXPENDITURE
4001-REVENUES
Property Taxes 0
Intergovernmental 0
Charges For Services 0
4110-SPEC ASSESS CURRENT 21,269 0
4115-DELINQUENT SPECIAL ASSESSME __ 148
4120-SPEC ASSESS COUNTY PREPAID 1,302 _
4125-SPEC ASSESS PREPAID TO CITY 248
4130-SPEC ASSESS PENALT IES/INTERE 66
Special Assessments 23,033 0
4955-INTEREST ON INVESTMENTS 560 560
Investment Income 560 560
5350-MISCELLANEOUSREVENUE 5,000
Misc Revenue 5,000
Total-Revenues $28,033 _ $0 $560 $560
6001-EXPENDITURES _
' Personnel Services 0
Supplies 0
Other Services 0 0
Capital Outlay 0
7140-LEGAL&FISCAL FEES 410
Debt Service 410 0
Total Exp 410 0
Transfers In 0 0
Transfers Out 0 0
Other Financing Sources 0 0
n Fund Balance $27,624 $0 $560 $560
Net Ghange i 1
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
GENERAL CAPITAL EQUIPMENT FUND All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Actual 2013 Budget 2014 Budget Budget
Entry 2015 Entry 2016
Object GENERAL GENERAL
Account CAPITAL CAPITAL GENERAL GENERAL
EQUIPMENT EQUIPMENT CAPITAL CAPITAL
FUND FUND EQUIPMENT EQUIPMENT
FUND FUND
4000-REVENUE AND EXPENDITURE
4001-REVENUES
6001-EXPENDITURES
6940-VEHICLES , 165,707 160,000
Capital Outlay 165,707 160,000
Total Exp 165,707 160,000
5205-OPERATING TRANSFERS 165,707 160,000
In 165,707 160,000
Other Financing Sources 165,707 160,000
Net Change in Fund Balance $0 $0
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
Maintenance Fund(formerly Seal Coating) All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Budget Dec YTD Budget Dec YTD Budget
Actual 2013 2014 Entry 2015 Entry 2016
Object Maintenance Maintenance Maintenance Maintenance
Account Fund Fund(formerly Fund(formerly Fund(formerly
(formerly Seal Coating) Seal Coating) Seal Coating)
Seal Coating)
4000-REVENUE AND EXPENDITURE
4001-REVENUES
' 4955-INTEREST ON IN V ESTMENTS 4,180 4,180
Investment Income 4,180 4,180;
_
Total Revenues _- $4,180 $4,180
6.0.01-EXPENDITURES
6401-PROFESSIONAL SERVICES 204,605 300,000 310,000 300,000
6455-LEGAL NOTICES PUBLICATIONS 44
Other Services 204,649 300,000 310,000 300,000
7010-CONSTRUCTION CONTRACTS 4,710,000
i Capital Outlay 4,710,000 1
' Total Exp 204,649 300,000 5,020,000 300,000
Bond Issue 0
5205-OPERATING TRANSFERS 1,856,747 430,579 4,655,000 395,000
Transfers In 1,856,747 430,579 4,655,000 395,0001
Other Financing Sources 1,856,747 430,579 4,655,000 395,000
T Net Change in Fund Balance $1,652,099 $130,579 ($360,820) $99,180
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
.C)(11 ii/ C
Enterprise Funds Budget Summary
2013 Final,2014 Final,2016 Proposed,2016 Proposed
December YTD December YTD December YTD December YTD
Company Actual Budget Budget Entry Budget Entry
2013 2014 2015 2016
Revenues
Liquor Stores,Net of Cost of Goods Sold(6100:6115) 1,143,196 1,077,575 1,156,372 1,178,329
Sewer Operations(6200:6205) 1,897,807 1,795,750 1,803,280 1,803,280
Solid Waste(6300:6302) 2,026,028 1,867,700 1,928,430 1,925,730
Storm Water(6400:6405) 550,904 553,500 556,350 556,350
Water(6500:6508) 1,520,561 1,699,750 1,732,312 1,740,973
Streetlights(6600:6602) 216,719 215,000 216,070 216,070
Total Revenues 7,355,215 7,209,275 7,392,814 7,420,732
Expenditures
Liquor Stores 827,800 912,468 872,022 889,939
Sewer Operations 1,621,061 1,824,550 2,583,724 1,885,091
Solid Waste 1,658,549 1,707,870 1,711,408 2,086,028
Storm Water 501,458 666,338 701,759 749,554
1 Water 1,406,125 1,794,091. 1,538,396 1,486,118
Streetlights 184,834 188,150 196,900 206,400
Total Expenditures 6,199,826 7,093,467 7,604,209 7,303,130
Transfers
Transfers In 130,427 0
Transfers Out (1,495,114) (1,414,119) (1,466,687) (1,317,392)
Total Transfers (1,364,687) (1,414,119) (1,466,687) (1,317,392)
Change in Fund Balance (209,298) (1,298,311) (1,678,082) (1,199,790)
7/3/2014 1:20:51 PM Page 1 of 1
Liquor Operations All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Budget Dec YTD Budget Dec YTD Budget
Object Actual 2013 Entry 2015 Entry 2016
Account Liquor 2014 Liquor Liquor Liquor
Operations Operations Operations Operations
4000-REVENUE AND EXPENDITURE
4001-REVENUES
4955-INTEREST ON INVESTMENTS 01 2,560 2,560
Investment Income 1 0 2,560 2,5601
' 1
• 4751 LIQUOR-AL 86 30 ,560 1, 92
4751- IQ SALES 1,434,864 4,310,300 1,463,560 1,492,832
4752-WINE SALES 605,649 0 - 617,763 630,1181
4753-BEER SALES 2,362,670, _ 0 2,409,923 2,458,121
4754-MISC TAXABLE SALES 69,283' 0 69,000 69,000
4755-MISC NONTAXABLE SALES 46,914' 0 47,000 45,000
. Liquor Sales 4,519,380 4,310,300 4,607,246 4,695,071
5350-MISCELLANEOUS REVENUE 2,000 0 2,000 2,000
5370-CASH OVER&SHORT 72
Misc Revenue 2,072 0 2,000 2,000
, Total Revenues $4,521,452 $4y310,300 $4,611,806 $4,699,631
6001-EXPENDITURES
5502-COST OF GOODS SOLD 3,378,256 3,232,725 3,455,434 3,521,302
Cost of Good Sold 3,378,256 3,232,725 3,455,434 3,521,302
6110-FULL TIME SALARIES 217,258 217,276 228,582 238,424,
6112-FULL TIME OVERTIME 450 2,500 1,800 1,900
6120-PART TIME SALARIES 81,928 77,500 82,000 83,434;
6135-OTHER PAY
6152-FICA/MEDICARE 22,254 22,742 23,898 24,768
6154-PERA 21,146 21,552 23,430 18,024'
6156-HCSP 915 928 1,000 1,000
6157-OPEB EXPENSE 5,168 4,800 5,200 5,200'
6158-EMPLOYEE BENEFITS 27,985 40,000 40,000 42,800
6159-WORKERS COMP 6,564 7,966 8,372 8,678
Personnel Services 383,668 395,264 414,282 424,228
6210-OFFICE SUPPLIES 96 100 100
• 6220-EQUIP SUPPLIES&PARTS 312 0 100 • 100,
6240-BUILDING SUPPLIES&PARTS 13 600 600
6250-OTHER SUPPLIES&PARTS 5,636 19,300 8,000 8,_250
6272-FUEL 0 400 0j
6290-UNIFORMS&CLOTHING 0 800 700 700
• Supplies 6,0581 20,100 9,900 9,750
6401-PROFESSIONAL SERVICES 1 6,183 10,000 9,500 9,500'
6404-IT SERVICES 24,888 19,774 14,870 14,974,
6422-ELECTRIC I 26,882 31,000 29,700 30,700
6423-NATURAL GAS 4,653 8,700 7,900 8,500
• 6426-INSURANCE 12,009 19,825 12,000 13,000'
6450-OUTSIDE PRINTING 1,288 650 650 6501
6460-SUBSCRIPTIONS&DUES 2,805 _ ___ _2,000 2,000 2,000'
6470-TRAINING&SUBSISTANCE 150 2,950 2,950 2,950,
6485-MILEAGE REIMBURSEMENT 0 1,000 1,000 1,400
6492-ADVERTISING 4,031 7,000 7,500 7,8001
6505-EQUIPMENT REPAIR SERVICE 10,869 16,505 17,405 17,600
6515-BUILDING REPAIR SERVICE 0 4,700 3,350 3,350
6545-CREDIT CARD FEES 69,286 70,000 72,500 75,000
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 2
Liquor Operations All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Budget Dec YTD Budget Dec YTD Budget
Object Actual 2013 Entry 2015 Entry 2016
Account Liquor 2014 Liquor Liquor Liquor
Operations Operations Operations Operations
6556-BUILDING RENTAL 243,087 268,000 254,515 260,537
6570-PROGRAMMING EXPENSE 38', 1,000 1,000 1,000'
7420-OTHER 741 10,000 1,000 1,000;
Other Services 406,9101 473,104 437,840 449,961
6950-MACHINERY&EQUIPMENT 10,5351 0
6960-FURNITURE&OFFICE E
------------- ------ -- -------- ---- -- --- --
Capital Outlay 10,535, 0
7055-DEPRECIATION 20,629 24,000 10,000 6,0001
Depreciation 20,629 I 24,000 10,000 6,000I
"----------------
Total Exp 4,206,056 4,145,193 4,327,456 4,411,241
•
7310-OPERATING TRANSFERS 70,000 III 70,016 91,504 93,040
Transfers Out 70,000 70,016 91,504 93,040;
Other Financing Sources (70,000) (70,016)' (91,504) (93,040)
Net Change in Fund Balance $245,3961 $95,091 $192,846 $195,350
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 2 of 2
Sewer All Business Unit
2013 Actual,2014 Budget,2016&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Sewer Sewer Sewer Sewer
4000-REVENUE AND EXPENDITURE
4001-REVENUES _ _
4626-SEWER BENEFIT CHARGE 0 2,000 2,000 2,000'
4835-ADVERTISING 1,213 1,250 1,250 1,250
Charges For Services 1,213 3,250 3,250 3,250
4110-SPEC ASSESS CURRENT (59,693) 5,000 2,500 2,500
4115-DELINQUENT SPECIAL ASSESSME 24,183
4120-SPEC ASSESS COUNTY PREPAID 47,163
4125-SPEC ASSESS PREPAID TO CITY 29,391 0
4130-SPEC ASSESS PENALTIES/INTERE 5,420 0
' Special Assessments 46,464 5,000' 2,500 2,500'
1 4955-INTEREST ON INVESTMENTS 9,064 7,500 7,530 7,530
4960-GAIN/LOSS INVEST MKT VALUE (13,046)
Investment Income (3,983) 7,500 7,530 7,530'
5025-ENTERPRISE SALES 1,803,396 1,780,000 1,790,000 1,790,0001
Enterprise Sales 1,803,396 1,780,000 1,790,000 1,790,000'
5030-SAC CHARGE RETAINER 5,290
5215-CAPITAL CONTRIBUTIONS 45,427
Miss Revenue 50,717
lTotal Revenues $1,897,807 $1,795,750 $1,803,280 $1,803,280]
6001-EXPENDITURES
6110-FULL TIME SALARIES 1,021 0 ,
6112-FULL TIME OVERTIME 2,573 7,706 7,706 7,841
6152-FICA/MEDICARE 262 590 590 600
6154-PERA 260 559 578 588•
6157-OPEB EXPENSE (10,98.0) 2,604
6158-EMPLOYEE BENEFITS 0 0
6159-WORKERS COMP 0 2,170
Personnel Services (6,864) 13,629 8,874 9,029'
6210-OFFICE SUPPLIES 28 96 100 100
6220-EQUIP SUPPLIES&PARTS 5,328 4,500 4,500 4,5001
6230-VEHICLE SUPPLIES&PARTS 550 5,000 5,000 5,000',
6234-VEHICLE LICENSES,TAXES,FEES 0 250 250
6240-BUILDING SUPPLIES&PARTS 1,110 1,750 1,750 1,750
6250-OTHER SUPPLIES&PARTS 7,148 6,200 6,200 6,500
6255-LANDSCAPING MATERIALS 150 150 1501
6272-FUEL 8,406 10,000 10,000 10,5001
6290-UNIFORMS&CLOTHING 1,432 2,000 2,000 2,000;
Supplies 24,003 29,946 29,700 30,750■
6401-PROFESSIONAL SERVICES 14,773 50,000 800,000 50,000'
------------------------ -------- - --- - -- - -- - - - - -- - - -
6402-DATA PROCESSING 8,361 7,500 9,561 9,800
6404-IT SERVICES 42,513 33,639 14,585 11,233'
6412-CELLULAR PHONES 1,426 3,000 3,000 3,000
6421-MUNICIPAL SERVICES 3,239 3,200 3,500 3,9001
6422-ELECTRIC ------ _--_--_ 17,532 18,000 18,500 19,400'
6423-NATURAL GAS 12,476 12,700 13,000 13,650
6426-INSURANCE 26,374 26,500 40,200 44,3001
6430-INSURANCE DEDUCTIBLE 0 10,00.0 10,000 10,0001
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 2
Sewer All Business Unit
•
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Sewer Sewer Sewer Sewer
• 6445-POSTAGE 4,596 6,000 6,000 6,000 1
6450-OUTSIDE PRINTING 3,227 10,000 10,000 10,000■
6460-SUBSCRIPTIONS&DUES 346 500 500 500
6470-TRAINING&SUBSISTANCE 903 2,000 2,000 2,000
• 6480-MEETING EXPENSE 15 50 50
. 6485-MILEAGE REIMBURSEMENT 20 50 50;
6505-EQUIPMENT REPAIR SERVICE 391 5,000 5,000 5,0001
6510-VEHICLE REPAIR SERVICE 8,800 11,000 11,004 11,829
6515-BUILDING REPAIR SERVICE 449 1,650 1,700 1,700
6545-CREDIT CARD FEES 2,000 2,400
6555-RENTAL OF EQUIPMENT 0 500 500 500:
• 6560-CONTRACTUAL SERVICES 0 300 0
' 6565-MCES FEES 870,015 944,486 992,000 1,040,000
7420-OTHER 30
Other Services 1,015,487 1,145,975 1,943,150 1,245,312
6950-MACHINERY&EQUIPMENT 0 45,000 12,000
Capital Outlay 0 45,000 12,000
7055-DEPRECIATION 585,728 590,000 590,000 600,000'
Depreciation 585,728 590,000 590,000 600,000
7110-DEBT PRINCIPAL 0 0
7120-DEBT INTEREST 675 0
7130-FISCAL AGENT FEES 0 ,
' 7140-LEGAL&FISCAL FEES 2,032
Debt Service 2,706 0
Total Exp 1,621,061 1,824,550 2,583,724 1,885,091
5205-OPERATING TRANSFERS 85,000
Transfers In 85,000
7310-OPERATING TRANSFERS 319,361 299,374 307,414 315,814'
Transfers Out 319,361 299,374 307,414 315,814'
Other Financing Sources (234,361) (299,374) (307,414) (315,814)'
Net Change in Fund Balance $42,385 ($328,174) ($1,087,858) ($397,62511
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 2 of 2
Solid Waste All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Solid Waste Solid Waste Solid Waste Solid Waste
4000-REVENUE AND EXPENDITURE
,
4001-REVENUES __
4370-OTHER PERMITS 1,900 1,700 1,700 ,
Permits 1,900 1,700 1,700 1
4460-COUNTY MISCELLANEOUS 19,300 19,000 21,000 21,0001
Intergovernmental 19,300 19,000 21,000 21,0001
4835-ADVERTISING 1,213 1,000 1,000 1
5026-RECYCLING&YARD WASTE SERV 18,240 0
Charges For Services 19,453 1,000 1,000
4955-INTEREST ON INVESTMENTS 1,208 1,000 3,730 3,7301*
4960-GAIN/LOSS INVEST MKT VALUE (1,743)
investment Income (535) 1,000 3,730 3,730
5025-ENTERPRISE SALES 1,929,824 1,845,000 1,900,000 1,900,000
- - ------ ---------- ------------
Enterprise Sales 1,929,824 1,845,000 1,900,000 1,900,0001
_ 5010-SALES OF ASSETS 56,000 1
5015-GAIN/LOSS ON SALE OF ASSET (914)
5355-DONATIONS 1,000 1,000 1,000
--- -------------------------------
Misc Revenue 56,086 1,000 1,000'
( Total Revenues $2,026,028 ' $1,867,700r $1,928,430 $1,925,730 1
6001-EXPENDITURES
6110-FULL TIME SALARIES 262,256 246,875 260,076 269,019:
6112-FULL TIME OVERTIME 2,435 7,800 3,500 3,5001
6130-COMPENSATORY TIME PAY 2,665 4,000 3,500 3,500,
6152-FICA/MEDICARE 20,050 19,789 20,431 21,115
6154-PERA 19,119 _ 18,754 20,031 20,701
6156-HCSP 485 500 525 5251
6157-OPEB EXPENSE 4,684 5,000 5,000 5,000
6158-EMPLOYEE BENEFITS 40,491 50,000 52,250 56,175
6159-WORKERS COMP 17,711 18,987 19,603 20,2601
Personnel Services 369,895 371,705 384,916 399,7951
6210-OFFICE SUPPLIES 128 600 600 600;
6220-EQUIP SUPPLIES&PARTS 420 1,500 1,500 1,5001
6230-VEHICLE SUPPLIES&PARTS 17,534 28,000 28,000 28,0001
, 6234-VEHICLE LICENSES,TAXES,FEES 0 300 0 300
6240-BUILDING SUPPLIES&PARTS 1,089 1,725 1,725 1,700'
6250-OTHER SUPPLIES&PARTS 31,445 35,700 35,700 35,000,
6255-LANDSCAPING MATERIALS 150 150 150
6272-FUEL 57,283 67,000 60,000 65,000'
6290-UNIFORMS&CLOTHING 3,534 4,000 4,000 4,400,
Supplies 111,433 138,975 • 131,675; 136,650
6401-PROFESSIONAL SERVICES 831,059 775,000 775,000 815,000
6402-DATA PROCESSING 8,361 8,268 9,561 9,800 j
6403-LEGAL 508 500 500 6001
1. 6404-IT SERVICES 10,469 10,722 14,101 11,933!
. 6412-CELLULAR PHONES 1,447 2,000 2,000 2,200.
6421-MUNICIPAL SERVICES 2,398 3,000 3,000 3,300
6422-ELECTRIC 10,853 15,000 15,000 15,750'
6423-NATURAL GAS 9,796 12,000 12,000 13,000
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
• Page 1 of 2
Solid Waste All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Solid Waste Solid Waste Solid Waste Solid Waste
6426-INSURANCE 1 17,9631 24,000' 19,155 21,100
6430-INSURANCE DEDUCTIBLE 0 I 10,000 10,000
6445-POSTAGE 4,596 6,000 6,000 5,500
6450-OUTSIDE PRINTING 3,227 10,000 10,000 10,000;
6455-LEGAL NOTICES PUBLICATIONS 116 500 500 500
6460-SUBSCRIPTIONS&DUES 847 1,100 1,100 1,100
6470-TRAINING&SUBSISTANCE 231 1,200 1,000 1,000
6485-MILEAGE REIMBURSEMENT 106 1 400 400 400
6492-ADVERTISING 2,225 2,500 2,500 2,750
6505-EQUIPMENT REPAIR SERVICE 111 4,000 4,000 3,0001
6510-VEHICLE REPAIR SERVICE 66,000, 66,000 70,950
6515-BUILDING REPAIR SERVICE 448 3,000 3,000 2,500:
6545-CREDIT CARD FEES 2,000 2,4001
6560-CONTRACTUAL SERVICES 140,648 I 165,000 170,000 175,000
6570-PROGRAMMING EXPENSE 12,000 13,000 14,300 I
Other Services 1,123,717 1,122,190 1,139,817 1,192,083
6950-MACHINERY&EQUIPMENT 0 0 0 275,000
Capital Outlay 0 0 0 275,000'
7055-DEPRECIATION 53,503 75,000 55,000 82,5001
Depreciation 53,503 75,000 55,000 82,5001
Total Exp 1,658,549 1,707,870 1,711,408 2,086,028
7310-OPERATING TRANSFERS 155,380 116,727 118,827 120,987
Transfers Out 155,380 i 116,727 118,827 120,987
Other Financing Sources (155,380)', (116,727) (118,827) (120,987)
Net Change in Fund Balance $212,100 $43,103 $98,195 ($281,285)
1
Location: Documents\FARMINGTON\Budget 2015-201616 Dept Rev And Exp Detail.
Page 2 of 2
Storm Water All Business Unit
2013 Actual,2014 Budget,2p1Q&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 201e
Storm Water Storm Water Storm Water Storm Water
'' 4moo'REVENUE AND sxPswonuns
r -------------'- -- -- ' - - -- - ' -' '
4001-REVENUES
4637-WATER QUALFY MANAGEMENT F 0 0
400u'ADVERTISING 1.213 1,500 1,500 1,500
| Charges For Services 1,213 1.500 1,500
495»'INTEREST ON INVESTMENTS 4,834 4,000 4,850 ' -----4/8501
4960-GAIN/LOSS INVEST MKT VALUE (6,973) ,
Investment (2,139) 4,000 4,850 �auo|
'
eonn'ENTERPRISE SALES 551.830 548,000 550,000 550,0001
-- '
sn��n�mo/� 551,830 548,000 550,000 ��on|
MI= 0_ �
Total Revenues $550,904 $553,500 $556,350 $556,350
mm1'EXPENDITURES
o11o'FULL TIME SALARIES (520) 4.700
o11n'FULL TIME OVERTIME 377 0 4J00 4,782
|
n1mu'px�Vmsmx�Rs 452 oVo 360 �6/
�
|
6154'psRx 435 341 353 359
s1o7'opsaEXPENSE (12,866) (
o1su'EMPLOYEE BENEFITS 0 2,780 �
s1eo'WORKERS COMP 0 383
|
Personnel Services (12,122) 8,564 5,413 �ao7
mu1o'OFFICE SUPPLIES 28 100 100 100
suuo'EQUIP SUPPLIES uPARTS 1.843 1.000 1.000 1.0001
6230'VEHICLE SUPPLIES&PARTS 4,609 e.800 7,000 7,500�
oou*-VEHICLE LICENSES,TAXES,FEES 0 50 50
omm-BUILDING SUPPLIES mPARTS 282 400 500 500
6250-OTHER SUPPLIES&PARTS 4.000 4,500 4,500 5,000|
oun4'SIGNS&oTnpp|wamx�snw�� �o)
STRIPPING 6255-LANDSCAPING MATERIALS 3,343 5,700 5,700 e,7001
6on2_rusL o.uu* u.7so� 3.500 3,700
auoo'UNIFORMS uCLOTHING 1,432 2,000 2,000 2,000
- -
Supplies 18-701 23,300 24,300 25,550
.
6401-PROFESSIONAL SERVICES 36.682 150,000 150,000 150,000
- _ **02 DATA PROCESSING 8,361 7,500 9,561 -'--9,800
n400'LsoAL o 100 100 100
' __- ---I
�- -'_u4V4-rr SERVICES 3*.959 29,234 14,585 11,233|
o*u1'MuwxxpALnsRv�sa 596 700 750__- --'_ - -'---
m
6422-ELECTRIC . __ 3,728 3,500 u�»» - '--_��40/
,_ --_a42x-NATURAL GAS 2J93 --- 2,600 3,000 3,150
e*ue'INSURANCE 3.114 3,500 5.050 5,500'
6430-INSURANCE DEDUCTIBLE 0 10,000 10,000 1
. u*un'POSTAGE 4,596 5,000 5,000 5,20O'
_
wmo'OUTSIDE PRINTING 3,227 5,000 10,000 10,000 1
6455-LEGAL NOTICES PUBLICATIONS 22 100 100 100
o4so-SUBSCRIPTIONS&DUES 457 500 550 5501
6470-TRAINING&SUBSISTANCE 1.303 1.000 2,000 2,000�
6480-MEETING EX ENSE 15 50 oo
---
6485-MILEAGE REIMBURSEMENT 20 100 100 100
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1oY2
.
Storm Water All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Storm Water Storm Water Storm Water Storm Water
6492-ADVERTISING 79 0 1
6505-EQUIPMENT REPAIR SERVICE 25 1,240 1,200 1,200 1
6510-VEHICLE REPAIR SERVICE 1,000 1,500 1,500 1,614
6515-BUILDING REPAIR SERVICE 1 180 600 600 600
6545-CREDIT CARD FEES 1 2,000 2,400
6560-CONTRACTUAL SERVICES 0 300 0
6570-PROGRAMMING EXPENSE 7,479 50,000 50,000 50,000
7420-OTHER 0
Other Services 110,637 262,474 270,046 268,4971
6950-MACHINERY&EQUIPMENT 32,000 12,000 I
Capital Outlay 0 32,000 12,000
7055-DEPRECIATION 384,242 340,000 390,000 450,000
Depreciation 384,242 340,000 390,000 450,0001
Total Exp 501,458 666,338 701,759 749,554'
7310-OPERATING TRANSFERS 333,764 327,951 337,313 346,961
Transfers Out 333,764 327,951' 337,313 346,9611
Other Financing Sources (333,764) (327,951) (337,313) (346,961)
l' Net Change In Fund Balance ($284,317) ($440,789) ($482,722) ($540,165)
•
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 2 of 2
•
Water All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
• Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Water Water Water Water
4000-REVENUE AND EXPENDITURE
4001-REVENUES Property Taxes 0
4320-WATER PERMITS 9,375 5,000 6,000 6,000'
4350-UTILITY PERMITS 90
Permits 9,465 5,000 6,000' 6,000
Intergovernmental 0
4512-CUSTOMER SERVICES NONTAXAB 41,206 25,000 25,000 25,000
4620-PUBLIC WORKS MISC CHARGES 187
4637-WATER QUALITY MANAGEMENT F 0 5,000 5,000 5,000 i
4640-WATER AVAILABILITY CHARGE 144,600 80,000 80,000 80,000
4644-WATER MAIN TRUNK CHARGE 25 0
-_--_-_-- 4835-ADVERTISING- _- --- ----1,213 1,250 1,200---- -_-1,200
Charges For Services 187,231 ' 111,250 111,200 111,200
4910-CODE VIOLATIONS&ADMIN FINES 3,050 2,500 2,500 2,500
Fines&Forfeitures 3,050 2,500 2,500 2,500
4110-SPEC ASSESS CURRENT (19,110) 7,000 6,500 6,000
4115-DELINQUENT SPECIAL ASSESSME 7,093
4120-SPEC ASSESS COUNTY PREPAID 18,731 5,000 4,500 4,000
. 4125-SPEC ASSESS PREPAID TO CITY 2,210 5,000 3,000 2,500'
-------- -- ---- ---- - - - ---- - -- - ------ -------------- ---------
4130-SPEC ASSESS PENALTIES/INTERE 7,827 1,000 500 500:
' Special Assessments 16,751 18,000 14,500 13,000
4955-INTEREST ON INVESTMENTS 111,021 90,000 46,303 44,019'
4960-GAIN/LOSS INVEST MKT VALUE (144,436)
Investment Income (33,415) 90,000 46,303 44,019
5025-ENTERPRISE SALES 1,162,860 1,348,000 1,366,809 1,370,254'
--- ----------------- -----------
Enterprise Sales 1,162,860 1,348,000 1,366,809 1,370,254
4975-RENTAL INCOME 173,930 125,000 185,000 194,000
5350-MISCELLANEOUS REVENUE 690
Misc Revenue 174,619 125,000 185,000 194,000'
Total Revenues $1,520,561 $1,699,750 $1,732,312 $1,740,973
6001-EXPENDITURES
' 6110-FULL TIME SALARIES (6,383) 0
6112-FULL TIME OVERTIME 2,059 4,155 4,200 4,200
6120-PART TIME SALARIES 975 2,500 4,000 4,700;
' 6130-COMPENSATORY TIME PAY 840 1,000 1,000
6152-FICA/MEDICARE 410 509 704 757'
6154-PERA 295 301 390 390
6156-HCSP 9
6157-OPEB EXPENSE (19,37.6) ,
6158-EMPLOYEE BENEFITS 0 542 667 724
6159-WORKERS COMP 0 0
Personnel Services (21,171) 8,007 10,961 11,771
. 6210-OFFICE SUPPLIES 28 100 100 100'
6220-EQUIP SUPPLIES&PARTS 44,525 54,000 55,000 55,000
6230-VEHICLE SUPPLIES&PARTS 935 1,500 1,800 _ 1,800'
6234-VEHICLE LICENSES,TAXES,FEES 0 50,
6240-BUILDING SUPPLIES&PARTS 1,087 1,750 1,750 1,750
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 2
Water All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Water Water Water Water
6250-OTHER SUPPLIES&PARTS 11,516 I 10,000 12,000 -12,000'
6255-LANDSCAPING MATERIALS 0 150 150 150'
6260-CHEMICALS 148,552 190,000 195,000 195,000.
6272-FUEL I 7,391 6,200 7,500 7,750
6290-UNIFORMS&CLOTHING 1,432 2,000 2,000 2,000
Supplies 215,466 265,700 275,300 275,6001
- -- --- ----- - -- - ---- - -------------- ------------
6401-PROFESSIONAL SERVICES . 98,745 130,000 110,000 110,000 Y
6402-DATA PROCESSING 8,361 I _7,500 9,561 9,8001
6403-LEGAL 44 2,000 2,000 2,000
6404-IT SERVICES 36,959 29,234 20,624 13,633:
6412-CELLULAR PHONES 1,426'I 3,000 3,000 3,0001
6421-MUNICIPAL SERVICES I 3,210 3,200 3,500 3,500',
6422-ELECTRIC _ 139,790 145,000 152,250 160,000
6423-NATURAL GAS 15,8851 16,500 17,500:
, 6426-INSURANCE I 8,6891 9,000 14,000 15,5001 .
6430-INSURANCE DEDUCTIBLE 0 I 10,000 10,000'
6445-POSTAGE 4,5971 10,000 8,000 8,000'
6450-OUTSIDE PRINTING 3,2271 10,000 10,000 10,000
6455-LEGAL NOTICES PUBLICATIONS 0 1,000 500 500 i
6460-SUBSCRIPTIONS&DUES 965 5,000 3,500 3,5001
• 6470-TRAINING&SUBSISTANCE 703'. 2,000 2,000 2,000
6480-MEETING EXPENSE 15 50 50
6485-MILEAGE REIMBURSEMENT 20 200 200 2001
6492-ADVERTISING 762 3,500 3,000 3,000'1
6505-EQUIPMENT REPAIR SERVICE 2,004 31,300 31,000 31,000
6510-VEHICLE REPAIR SERVICE 1,000 1,500 1,500 1,614;
6515-BUILDING REPAIR SERVICE 449', 1,650 1,650 . 1,650
6545-CREDIT CARD FEES
6555-RENTAL OF EQUIPMENT 0 500 500 500
6560-CONTRACTUAL SERVICES 0!1 300 300 300;
6570-PROGRAMMING EXPENSE 6,044 1, 5,500 6,500 6,5001
Other Services 332,89411 415,384 410,135 413,7471
6920-WATER DISTRIBUTION SYSTEM 0
I .
6950-MACHINERY&EQUIPMENT I 220,000 12,000
Capital Outlay 0 220,000 12,000
7055-DEPRECIATION 878,586 885,000 830,000 785,000'
Depreciation 878,58611 885,000 830,000 785,000'
7140-LEGAL&FISCAL FEES 351
Debt Service 351 0 '
Total Exp 1,406,1251! 1,794,091 1,538,396 1,486,1181
■
5205-OPERATING TRANSFERS 0
Transfers In 0
7310-OPERATING TRANSFERS 616,609 600,051 611,629 440,5901
Transfers Out 616,609 600,051 611,629 440,5901
Other Financing Sources (616,609) (600,051) (611,629) (440,590)!
H Net C. lihaa nge In Fund Balance ($502,174)! ($694,392) ($417,713) - ($185,735)
i
Location:Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 2 of 2
Streetlight All Business Unit
2013 Actual,2014 Budget,2015&2016 Proposed Budgets
Dec YTD Dec YTD Dec YTD Dec YTD
Object Actual Budget Budget Entry Budget Entry
Account 2013 2014 2015 2016
Streetlight Streetlight Streetlight Streetlight
4000-REVENUE AND EXPENDITURE
4001-REVENUES
4955-INTEREST ON INVESTMENTS 70 70
Investment Income 70 70
5025-ENTERPRISE SALES 216,719 215,000 216,000 216,000
Enterprise Sales 216,719 215,000 216,000 216,000
il Totalt evenues $216,719 $215,000 $216,070 $216,070
6001-EXPENDITURES
6110-FULL TIME SALARIES 0
Personnel Services 0
6401-PROFESSIONAL SERVICES 0 2,150 2,150 2,000
6422-ELECTRIC 174,371 175,000 183,750 192,900
6505-EQUIPMENT REPAIR SERVICE 10,463 11,000 11,000 11,500
Other Services 184,834 188,150 196,900 206,400
Total Exp 184,834 188,150 196,900 206,400
Other Financing Sources
I Net Change In Fund Balance $31,885 $26,850 $19,170 $9,670
Location: Documents\FARMINGTON\Budget 2015-2016\6 Dept Rev And Exp Detail
Page 1 of 1
G
r
.fl
t
x
W
t0 N C0 00 it eI CO C0 N d' N e-1 .7 00 0 en N 00 0 0 en 00
ei M 01 CO M V) CO 01 00 01 M N CO 01 N en 01 Cr V1 M d' N
e\i N L/) 0 CO UI 01 ' ' N; 00 N 01 0 CO C0 0 ' UI ' ' 01 CD 0 N 0 O
M M i CO tri ei M D7 n O N 00 N N M h` M N 0) ei O
\ M N L/) N 00 01 ei Ln M 01 ei CD CO N 0 0 Ch 01
• N t-I M V) N ei ei N M VD CO O
vi
„� N ei ei M
O
OL. V� in iR in V) in i/). i/} in i/). V). i/} r/). V)• in V? in V)• VA. in V)• V) in VI. in in
N ti:) CO d' co CD N N N ei d' CO O en N M O O CO 00
ei N N N 01 rI 0 N e-I cr 0 01 M 00 V) Ch N d N N M
N 01 it 00 0 CO VI ' ' to CD 01 en en co s-I M ' M ' ' CD N CO V1 N M
M N u1 N I� O n O LA O M CO N 01 Ch N' ei M 0) CO O
\ en N 0 CO - 00 Ln Lf1 Co en 01 e-I CD N N en ei N CO
N N le ei M Cr N ei O n 01 v N
N' M I M
O
a V). Vf V► V? V► An. i/. 1/). in 1/} V). An. V> in in V)• V> V> V)• V> V). in in in in V?
e--) O CO Ch Ch N CO N N N it it 00 0 en e-I ei to N s-I 00
\ tD CO 00 ei N CD ei CO N V) CO 0 N Ch N 0 M d' to 01 CO
ei N CO CD 0 CD 00 I ' N Ch N N CD N V) N ' ei ' ' 00 e-I CD i-I Ch ei
M CO Ch L/) CO 4 00 N a0 CO N 0 Ch e-I N N vi• M 0 Cri ti et Cr e-I
.---- CO ei N en N ei en Ch 0 M 01 N 00 N 0 en t0 v CO
ei en N M M M N 00 00 00 CO en cc
.O N M ei M
a. V). i/). V} in in in V)• V)• V)• in in in in in in in in in in in in V} in in in in
* * * * *
et CD ei CO ei O 0 N 01 01 00 VI V1 M CD CO N en ei Ch 01 0
0 00 VI 00 00 N N ei 1.0 CD CD N en 00 N CO 0 CD N N en 0
CI ei V) CO 01 O N to 01 M Cr N 0 CO 00 ' N Cr it en N 01 01
NV) N V) 01 00' ei' CO N M M Ch O ei 00 M to 01 Ol ' ri N
01 en N N 00 0 V) Cr 00 01 N 01 N N CO N ei CO N en
en ei N N en in N CO 01 00 ei N N M
V1 ei M ri N d
V? in in in in in in in in in in V) in in V? in in in in in in in
* * * * *
M N Ch CO d' en N V) N N N N Cr 00 O Cr O V) N ei M CO
o• O N CO CO ei en r1 r-I CO N in 01 0 N Cr 01 ei O Ch d' CO M
N CD CD 0 CO N N 01 to N N N Ln N ' to N. M to 01 CO en
r N CO M L/) O Ch N N M n N N ei rl d n N' M 00
uL co CO N e-I 0 N 00 01 N N CO M 01 N 4 co M 01 0 M M
M ei N N N to CO 01 N N ei N CO M
d N e-I M e-I N Ch
++ ei
41 in VI. V). VA. V> V> in in in V? in V> V)• VI. i/Y V} i/? V)• in VI. in V)•
Z
U
C V) CO 00 N ei In 01 M 00 to d' 00 CO to 0 01 00 CO en `)
0) C) CO 0 Cr 01 N 01 ei ei N CO in V) 01 00 N Ch e-I en 0 7
�0 N 00 al. CD 0 0 CO CO N O ' ei N O1 M ' tt CO CO N 0 0 UI L
CO N O O N n n M 00 M a 00 n M 00 N 00 0) OS Ch N N v- ++
CO 0 N ei Ch CO Cr M N 00 en LO 01 01 ei CO 00 0 N t6
M
M N M Cr d M Li-) 00 N N e I L O)
C N d' M ei us O -O C
LI ei L6
Vn• in in V> in in i/). in V) in in in in in in in in in in in VT in a) Cr
L.
r- O
,� 00 CO CO ei 01 CO ei 0 N N N V) V I N M ei 01 M vs C u!
O M N 01 01 N N ‘-I 00 00 01 00 Ch 01 CD 0) CO N e-I C) C) Cam)
N Ch 0 00 ei In N N e-I e-I ' en ' N N ' ' Ct CD 0 0 CD 0 H N In
N n 00 00' Ch Ln ei M O N N O e-I CO' CO CO O' CO CO
M Ch ei N N CO ei In O' In CO 0 CO CD l0 N en >. Q
M ei N N N N M CO N M CD CO CO CD 7 w f6
N v N M a-i Ln '- y '
ei
Cl L6
in in in VA. in in VA. VI. VA. VA. in VA. in in in V? in in in in in V} CCU = C) U
LO N •C
d a) O
N H _0 -C C
t_ C szt
-0 Q ` E
ei
7 0 "
.+ O 0 C f m _a y ei
C C O L.L.
±+ C. t6 O M
V- 7 Y C LL Cj C L'" f6 C 4_, C L!)0.L
�F j . 'O in Y ._,cIJ C a. '7 C E co O O
v, C) H U Li y = OL. .O : W C CO f6 0)) \
L C L C O L > Q O z
w C '++ C) in
C) 7 pOp d Dl I�6 N '0 of L E 4 > _ M
C C) y to > v 3 '8 C) OC U V V C L C) d H C) t N
ai V N C f0 H L a-' M f6 C" O C f0 tL O '',it N t co +' O +' ei
c E a v 0 Ia6 o 4-,CU U N L � L 6,° C 3 h °' o
CC u w Y Q m > E `u 3 .Q , a -a E --' aa, o c s m
•3
li 0 LL LL o CU a) CO*' t6 co o L .2 6, a� a) m a� Er a3, o ° `° .F *' Y E cu
U w H H 0 O 0 to V cc L. N a a. cc Z e c � N N N .> N Z L o * E co
CA U W * "O to * In
2015 IT INVESTMENT
a E
ALL 2015
DEPARTMENTS TOTAL
IT Support $ 91,603.00
Computer Apps/Maint. $ (45.80)
Antivirus $ 1,600.00
Autodesk(CAD) $ 12,504.00
Back-up library(Managed Svcs) $ 18,495.00
Card Access $ 2,500.00
Cisco Maint $ 500.50
ESRI-Arcview $ 2,900.00
ImageTrend $ 5,160.00
InDesign/AdobeSuite $ 3,400.00
Internet/WAN $ 15,213.00
Laserfiche $ 8,004.00
Microsoft Licensing(inc.SQL) $ 9,016.00
MaxEnterprise Software(Arena) $ 650.00
Misc.(Supplies,Trng,etc) $ 13,760.00
NovusAgenda $ 8,000.00
Cartograph-Pavement View $ 1,600.00
PCI Compliance Merchant Scans $ 1,101.00
Pictometry $ 1,560.00
SeeClickFix $ 5,000.20
Spyware $ 1,999.80
Video Surveillance Sys $ 8,500.00
VoIP Maint.(1/3 of 3 yr agmt) $ 4,900.50
Website Software/Maintenance $ 32,000.00
Websense $ 1,750.00
Sub Total $ 251,671.20
,Phones:
VoIP Lease(bought in 2013) $ -
Dial Tone/Long Dist. $ 30,030.00
Analog Lines $ 9,778.00
Sub Total $ 39,808.00
ck
Total less Capital Equip $ 291,479.20
;Computer Hardware:
Data Servers $ -
Email/Laserfiche Servers $ -
Switches $ 13,736.00
Video Surveillance Svr/Cameras $ 27,464.00
Wi-Fi Controllers/Receivers $ 5,155.00
Computers/Toughbooks $ 33,600.00
Sub Total $ 79,955.00
Total $ 371,434.20
IT Support Percentages: 100.0%
Misc(Supplies,Trng,etc):
New for 2015 budget:
Website Redesign
NovusAgenda
SeeClickFix
Security Cameras at 1st Street Garage and
Arena(see line 42)
Upgrade/New Wi-Fi Arena/PD
PD Repay IT Loan(see comment)
Exhibit F
4502 Rambling River Center Capital Improvement Fund
Rambling River Center List of Completed Equipment Purchases and Improvements
Improvement/Equipment Item Cost Year
Completed
Banquet Room Acoustic Improvements $5,459 2013
Arts and Crafts Room Concrete Floor Resurfacing Improvement $4,200 2013
Purchase and Install Security Video Cameras in Fitness Room,Banquet Room, $4,256 2013
Oak Street Entrance Hallway and Hallway leading from Banquet Room
PC and Monitor for Security Cameras $1,074 2013
Purchase New Banquet Tables $1,353 2013
Replace arm chairs in Ristow Library and Empire Room sitting area $1,498 2014
Purchase Greeting Card Rack $200 2014
TOTAL $18,040
Rambling River Center Future List of Improvements and Equipment Purchases
Improvement/Equipment Item Estimated Cost Year to be Completed
Oak Street Entry Area Improvements(concrete steps, $16,000 2014(likely to be deferred into
concrete ramp and railings) future given estimated cost)
Oak Street Garage Concrete Driveway Improvement $10,000 2014
Purchase new Treadmill for Fitness Room Equipment $3,500 2014
Additional Lighting Fixtures in Banquet Room $2,400 2015
Expand Fitness Room No year identified yet
Purchase NU Step No year identified yet
Purchase additional recumbent bike No year identified yet
Tile hallway walls four feet up No year identified yet
Purchase and Install Sink in Craft Room No year identified yet
HVAC System Replacement 2025