HomeMy WebLinkAbout03.12.12 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
March 12, 2012
6:30 p•m•
1. CALL TO ORDER
2. APPROVE AGENDA
3. FIRE TRUCK FINANCING/PURCHASING OPTIONS
4. 2013 BUDGET GOALS
5. CITY ADMINISTRATOR UPDATE
6. 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 City 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.
i�`i`�`��i �iyc�► City of Farmington
'z. 430 Third Street
4�GOp � Farmington, Minnesota
A P�m��,� 651.280.6800•Fax 651.280.6899
www.ci.farmington.mn.us
TO: Mayor, Councilmembers and City Administrator
FROM: Teresa Walters, Finance Director
John Powers, Fire Marshall
SUBJECT: Fire Truck Financing/Purchasing Options
DATE: March 12, 2012
BACKGROUND:
At the February 13, 2012 Work session, Council was presented with the Fire Department's
capital equipment needs. The current rescue truck is 26 years old and in need of replacement.
This vehicle is used for fire and medical calls. The new vehicle would provide more versatility
since it would be equipped with both fire and rescue equipment. This would also assist us in
lowering our Insurance Services Office (ISO) rating and provide necessary National Fire
Protection Association (NFPA) requirements. The council reviewed the options of purchasing
new, used or a demo. It was decided that we would look at new or demo vehicles.
DISCUSSION:
The City has a couple options available for financing the Recue Fire Truck depending upon
which truck is chosen by the Council (new, demo, or Houston-Galveston Consortium
Agreement). The options below are estimates. We will not know the true cost until after the
bids are received. We anticipate spending between $555,000 and $600,000 for the truck. We are
also looking at the possibility of trading in or selling our current truck. We anticipate receiving
$10,000 - $20,000 for the old truck. This is not factored into the analysis below because the
price of the new vehicle could also fluctuate.
Financing Options:
1. Bond: With this option the rates are approximately 1.5%. In addition to this, we would
also have to pay approximately $40,000 in issuance costs for the Financial Advisor, Bond
Council, Rating agency, County Auditor, etc.
2. Borrow from the Water Fund: For years, the Water Board has planned for emergencies,
future development, and replacement of assets. Because of this planning, the Water
Board is able to pay cash for these expenditures which reduces the total cost of these
projects by eliminating unnecessary interest payments. Funds controlled by the Water
Board are held in reserves earning interest at a very nominal rate. The Water Board has
reviewed their needs over the next 5 years, and has determined that internal borrowing
1
between the Water Fund and the General Fund would not have a detrimental effect on the
Board's ability to fund water projects for the next 5 years.
Impact to the Water Fund:
a. Current investment rates on a five year CD are 1.15% to 1.65%. We can only invest
$250,000 with any one entity. Therefore the investment would need to be broken out:
Total Water Fund
Amount Interest Revenue
Invested Rate Term Over Term
$100,000 1.15% 5 $5,750
240,000 1.40% 5 16,800
240,000 1.65% 5 19,800
$580,000 $42,350
The Water Fund would receive approximately $42,350 if we invested $580,000 in CD's
for 5 years. This is an estimate as rates have continued to drop on a daily basis.
b. If the water fund loaned the City money,the impact to the water fund would be:
Total Water Fund
Interest Revenue
Amount received Over
Invested Rate Term Term
$580,000 3% 5 $53,228
This is an approximate total of $53,228 in interest revenue earned through internal
borrowing, a difference of $10,878 when compared to investing in CD's (Provided the
rates stay the same).
Purchasing Options
1. Bond(This adds $40,000 to the price)
Other Amount Total Total
Purchase Fees Financed Annual Interest Amount
Price Rate Term Payment Paid Paid over
Over five years
Term
New $580,000 $40,000 620,000 1.5% 5 $129,636 $28,177 $648,177
Fire * years
Truck
Demo $573,000 $40,000 613,000 1.5% 5 $128,172 $27,859 $640,859
Truck * years
HGAC $555,000 $41,000 596,000 1.5% 5 $124,617 $27,086 $623,086
Truck * years
2
*The estimates used for the three different options were obtained by talking to different
manufacturers. They are hesitant to give specific costs without having truck
specifications but we are comfortable that these numbers are in the ballpark for the three
different truck options. Specific costs will be determined once we go out for bid. At that
point if costs are too high we will have a chance to pare down the truck options.
a. If we purchased a new fire truck we would have it built to our specifications. This
would take approximately 6-9 months. The purchase price would be approximately
$580,000.
b. If we purchased a demo truck, we would save $7,000. The truck would also be
custom made for us; we would authorize the company to use it as a demo for six
months. This would delay receipt of our purchase for over a year. The cost would
be approximately $573,000.
c. Houston Galveston agreement consortium (HGAC) is a pre-bid consortium that we
can join for $1,000. The cost to purchase a truck would be approximately $555,000.
However, we would not have a custom truck. It would have to meet at least 75% of
our specifications, but could be as much as 100%. We may lose the ability to choose
the manufacturer,type of tires, etc.
As a unit of local government, HGACBuy strives to make the governmental
procurement process more efficient by establishing competitively priced contracts
for goods and services, and providing the customer service necessary to help its
members achieve their procurement goals. All contracts available to participating
members of HGACBuy have been awarded by virtue of a public competitive
procurement process compliant with state statutes.
If we join the HGAC for a $1,000 fee, we will also have the opportunity to save
money on turnout gear and other needed items within the Fire department, Police,
Public works, IT, etc.
2. Borrow from the Water Fund
Other Amount Total Total
Purchase Fees Financed Annual Interest Amount
Price Rate Term Payment Paid Paid over
Over five years
Term
New $580,000 N/A 580,000 3% 5 126,646 $53,228 $633,228
Fire years
Truck
Demo $573,000 N/A 573,000 3% 5 125,117 $52,586 $625,586
Truck years
HGAC $555,000 $1,000 556,000 3% 5 121,405 $51,026 $607,026
Truck years
3
Benefits of the Water Fund Financing Option:
a. Although the interest rate is higher for internal financing compared to bonding, the actual
cost of financing is lower for internal borrowing since we do not have to pay issuance
costs.
Internal
Financing(Water
Bonding Fund) Savings
New Fire Truck $648,177 $633,228 $14,949
Demo Truck $640,859 $625,586 $15,273
HGAC Truck $623,086 $607,026 $16,060
b. If the water fund loaned the City $580,000 at 3%, the total interest would be higher than
investing in CD's. Payments would be made once per year over the next five years, with
interest revenue ranging from$3,700 to $17,400 (recorded in the water fund)each year.
Impact to the City
Annual debt payments would be made through a levy increase. Assuming the tax capacity
remains the same, a resident with an average home value of $200,000 will see an increase in
their property taxes ranging from $18.30 or 1.27% to $19.50 or 1.36%, depending upon the
option chosen.
Legal Authority
Interfund loans are not prohibited by the State Auditor. The arrangement would need to be
approved by Council through a resolution. The resolution shall contain the exact amount of the
loan, the funds involved, the purpose of the loan, the specific source of funds for repayment, the
schedule for repayment and the interest rate involved. The amount owed would be made public on
our annual financial statements and within the notes to the financial statements. Verification of
payments would be made through our annual audit. In addition to this, our City attorney would
write up a contract binding the City to pay the water fund for the loan. The contract would be
signed by both the Mayor and the President of the Water Board.
Budget Impact
Financing (for the purchase of a Fire Truck) through the Water fund would save the City
approximately $15,000. A greater benefit is that the interest would go to the Water Fund rather
than to investors. This means a greater savings to the taxpayer since they will not only see the
$15,000 savings on the financing option, but they will also benefit because the City will retain
approximately $53,000 that can be used for future needs rather than collecting $68,000 from our
taxpayers and sending that money to companies and investors who do not contribute to the tax
revenue collected by the City. Therefore, by choosing the Water Fund Financing option, the
overall benefit to the taxpayers is approximately $68,000.
4
Recommendation
The Fire Department Truck Committee recommends moving forward with the HGAC Truck
option. This option has the lowest cost and gets the city basically the same truck we would get if
we went out for bid ourselves. This truck will have a 20+year lifespan.
City staff recommends using the Water Fund loan option to purchase the truck. The Water
Board has blessed this approach and there are benefits to both the City and the Water Board in
going down this route. If the City Council selects this option we will formalize the loan through
both a City Council resolution and an approved agreement between both parties.
If you have any questions or need additional information before the work session please let us
know. Thank you for your time on this important matter.
5
&Ale%4i i' , City of Farmington
430 Third Street
Farmington,Minnesota
\\€(6,,,,, 651.280.6800•Fax 651.280.6899
" w�`e o 651. www ci.farmington.mn.us
TO: Mayor and Councilmembers
FROM: David J.McKnight,City Administrator
SUBJECT: 2013 Budget Goals
DATE: March 12,2012
INTRODUCTION
The March 12,2012 work session will be your first opportunity to discuss and set goals for the
2013/2014 city budget and tax levy. At the work session I will go over my proposal to fill the
gap of one time funding that was used in 2012 to reduce the tax levy and review some larger
scale items that will impact the 2013/2014 budget. The majority of the time will be allotted for
the five of you to discuss your goals for the next budget.
DISCUSSION
Attached to this memo is a chart that shows my proposal to fill the gap of one time money used
in 2012 to reduce the tax levy. If you recall,the City Council decided to use$367,258 in one-
time dollars to reduce the tax levy for 2012. To avoid starting out in the red for 2013 we must
reduce the budget by that same amount for 2013. To achieve this I proposed cutting the
following from the 2013 budget at this point.
1. Elimination of the one-time use of dollars in the 2012 budget to cover the EDA debt.
($175,000)
2. Elimination of the one-time use of dollars in the 2012 budget to cover the park/recreation
debt. ($120,000)
3. Elimination of the Community Development position that took place in 2012. ($50,000)
4. Reduction of the$140,000 reserve line item created in 2012. ($30,000)
These four reductions total$375,000 and cover the gap created with the use of one-time funding
in 2012. It also assumes that future use of fiscal disparities dollars will not be used for anything
other than how we have used it prior to 2012. We will discuss this issue at the April 2012 work
session.
The attached information also includes some significant factors that I see impacting the
2013/2014 budget process. I put these out there now for no other reason than to keep you aware
of them.
The majority of the work session time will be spent with you starting discussions on your goals
for the 2013/2014 work session.
If time allows I wanted to go over the summary format of the budget that I plan on using with
you this year. I have included the information in your packet for you to review but it is much
easier to understand when I explain it to you. The information includes six summary pages and
examples of department budgets from legislative control,administration,police patrol, ice arena
and the liquor stores. I will explain all of these at the work session and see what level of detail
you will be comfortable with during the budget process.
BUDGET I PACT
None.
ACTION REQUESTED
Discuss City Council goals for the 2013/2014 budget.
Respectfully submitted,
David J. McKnight
City Administrator
City of Farmington
2013 Budget
The 2012 budget used $367,258 in one time dollars to maintain the tax levy at the 2011 level.
The use of one-time dollars for ongoing expenditures creates a gap in the 2013 budget of
$367,258. In addition to the gap that exists, there are other factors in play that will impact the
2013 budget as well. This summary will hopefully explain how that gap is filled and what some
of the other factors influencing the 2013 budget include at this point.
Reserve Reduction,
$30,000
Community
Development
Change,$50,000 , i
xa
lx 2012 EDA DEBT,
$175,000
lx 2012 PR DEBT,
$120,000
400
Total $375,000
What Lies Ahead for 2013 and Beyond
The 2013 budget, like all other years, will include a number of challenges for the city to deal
with. Some of the challenges/needs that we are aware of today include:
✓ Street Projects $400,000-$800,000
✓ Vehicles/Equipment $330,000-$630,000
✓ Ice Arena Deficit $275,000
✓ Fire Truck Payment $140,000
✓ Economic Development Funding $50,000
✓ Delinquent Tax Levy $75,000
✓ Fuel Costs $15,000
✓ Revenue Shortages $?
✓ Liquor Store Funding Future $?
✓ HR/Contract Costs $?
✓ Department Requests $?
✓ Levy Limits Likely Returning
✓ Economy and Taxpayer Attitude
CITY OF FARMINGTON
2013 BUDGET BREAKDOWN
BUDGET AND TAX LEVY SUMMARY
EXPENDITURES 2012 2013 %CHANGE 2014 %CHANGE
ADMINISTRATION $1,037,848 $0 -100.00% $0 #DIV/0I
HR/IT $248,329 $0 -100.00% $0 #DIV/0!
FINANCE $425,357 $0 -100.00% $0 #DIV/0I
POLICE $3,877,398 $0 -100.00% $0 #DIV/0I
FIRE $836,930 $0 -100.00% $0 #DIV/01
ENGINEERING $890,922 $0 -100.00% $0 #DIV/0I
MUNICIPAL SERVICES $800,891 $0 -100.00% $0 #DIV/0I
PARKS/RECREATION $1,201,890 $0 -100.00% $0 #DIV/0I
TRANSFERS(PLAN) $695,000 $0 -100.00% $0 #DIV/0I
TOTAL EXPENDITURES $10,014,565 $0 -100.00% $0 #DIV/0I
REVENUES 2012 2013 %CHANGE 2014 %CHANGE
LICENSES/PERMITS $431,455 $0 -100.00% $0 #DIV/0I
FINES/FORFEITURES $70,000 $0 -100.00% $0 #DIV/01
INTEREST $80,000 $0 -100.00% $0 #DIV/0I
INTERGOVERNMENTAL $405,590 $0 -100.00% $0 #DIV/0I
CHARGES FOR SERVICES $617,649 $0 -100.00% $0 #DIV/0I
MISCELLANEOUS $79,007 $0 -100.00% $0 #DIV/0I
TOTAL REVENUES $1,683,701 $0 -100.00% $0 #DIV/0I
TRANSFER REVENUES
FUND REVENUES $350,035 $0 -100.00% $0 #DIV/01
GENERAL FUND BUDGET $10,014,565 $0 -100.00% $0 #DIV/0I
GENERAL FUND REVENUES - $1,683,701 - $0 -100.00% $0 #DIV/01
TRANSFERS OUT - $350,035 - $0 -100.00% $0 #DIV/0I
FISCAL DISPARITIES - $2,016,261 - $0 -100.00% #DIV/0I
SUB TOTAL $5,964,568 $0 -100.00% $0 #DIV/0I
DEBT + $2,598,414 + $0 -100.00% + $0 #DIV/01
AG CREDIT + $3,000 + $0 -100.00% + $0 #DIV/01
RESERVE + $0 + $0 #DIV/01 + $0 #DIV/0I
ICE ARENA LEVY + $0 + $2 #DIV/OI + $2 #DIV/0I
NET TAX LEVY $8,565,982 $0 $0
-100.00% #DIV/0I
-$8,565,982 $0
3/7/2y12
CITY OF FARMINGTON
2013 BUDGET BREAKDOWN
EXPENDITURES SUMMARY
ADMINISTRATION 2012 2013 2014
LEGISLATIVE CONTROL $76,802 $0 -100.00% $0 #DIV/0I
HISTORICAL PRESERVATION $7,480 $0 -100.00% $0 #DIV/0I
ADMINISTRATION $611,761 $0 -100.00% $0 #DIV/01
ELECTIONS $22,123 $0 -100.00% $0 #DIV/0I
COMMUNICATIONS $83,080 $0 -100.00% $0 #DIV/0!
CITY HALL $140,714 $0 -100.00% $0 #DIV/0I
COMMUNITY DEVELOPMENT $95,888 $0 -100.00% $0 #DIV/0I
TOTAL ADMINISTRATION $1,037,848 $0 -100.00% $0 #DIV/0I
HUMAN RESOURCES/IT 2012 0 2014
HUMAN RESOURCES $248,329 $0 -100.00% $0 #DIV/01
TOTAL HR/IT $248,329 $0 -100.00% $0 #DIV/0!
FINANCE 2012 2013 2014
ACCOUNTING $298,107 $0 -100.00% $0 #DIV/0I
RISK MANAGEMENT $127,250 $0 -100.00% $0 #DIV/0!
TOTAL FINANCE $425,357 $0 -100.00% $0 #DIV/0!
POLICE 2012 2013 2014
ADMINISTRATION $795,355 $0 -100.00% $0 #DIV/01
PATROL $2,308,911 $0 -100.00% $0 #DIV/0I
INVESTIGATIONS $761,157 $0 -100.00% $0 #DIV/0I
EMERGENCY MANAGEMENT $11,975 $0 -100.00% $0 #DIV/0!
TOTAL POLICE $3,877,398 $0 -100.00% $0 #DIV/0I
FIRE 2012 2013 2014
FIRE $790,259 $0 -100.00% $0 #DIV/0!
RESCUE $46,671 $0 -100.00% $0 #DIV/0I
TOTAL FIRE $836,930 $0 -100.00% $0 #DIV/0I
ENGINEERING 2012 2013 2014
ENGINEERING $248,097 $0 -100.00% $0 #DIV/01
PLANNING $247,412 $0 -100.00% $0 #DIV/01
BUILDING INSPECTIONS $298,365 $0 -100.00% $0 #DIV/0I
NATURAL RESOURCES $97,048 $0 -100.00% $0 #DIV/0I
TOTAL ENGINEERING $890,922 $0 -100.00% $0 #DIV/0!
2
MUNICIPAL SERVICES 2012 2013 2014
STREETS $576,036 $0 -100.00% $0 #DIV/0!
SNOW REMOVAL $224,855 $0 -100.00% $0 #DIV/0I
TOTAL MUNICIPAL SERVICES $800,891 $0 -100.00% $0 #DIV/0!
PARKS AND RECREATION 2012 2013 2013
PARK MAINTENANCE $553,396 $0 -100.00% $0 #DIV/01
RAMBLING RIVER CENTER $159,420 $0 -100.00% $0 #DIV/0!
ADMINISTRATION $249,686 $0 -100.00% $0 #DIV/0!
RECREATION PROGRAMS $116,850 $0 -100.00% $0 #DIV/01
POOL $122,538 $0 -100.00% $0 #DIV/01
TOTAL PARKS AND RECREATION $1,201,890 $0 -100.00% $0 #DIV/O!
TOTAL EXEPENDITURES $9,319,565 $0 -100.00% $0 #DIV/0!
TRANSFERS 2012 2013 2014
RECREATION $120,000 $0 -100.00% $0 #DIV/01
SEAL COATING $350,000 $0 -100.00% $0 #DIV/OI
EDA DEFICIT $175,000 $0 -100.00% $0 #DIV/0!
EDA OPERATIONS $50,000 $0 -100.00% $0 #DIV/0!
TOTAL TRANSFERS $695,000 $0 -100.00% $0 #DIV/0!
GRAND TOTAL EXPENDITURES $10,014,565 $0 -100.00% $0 #DIV/0I
3
CITY OF FARMINGTON
2013 BUDGET BREAKDOWN
REVENUE SUMMARY
REVENUES 2012 2013 2014
LICENSES/PERMITS $431,455 $0 -100.00% $0 #DIV/01
FINES/FORFEITURES $70,000 $0 -100.00% $0 #DIV/01
INTEREST $80,000 $0 -100.00% $0 #DIV/01
INTERGOVERNMENTAL $405,590 $0 -100.00% $0 #DIV/0!
CHARGES FOR SERVICES $617,649 $0 -100.00% $0 #DIV/0I
MISCELLANEOUS $79,007 $0 -100.00% $0 #DIV/0I
TOTAL OPERATING REVENUE $1,683,701 $0 -100.00% $0 #DIV/0!
TRANSFERS 2012 2013 2014
LIQOUR OPERATIONS $70,007 $0 0.00% $0 #DIV/0I
SEWER $70,007 $0 0.00% $0 #DIV/01
STORM WATER $70,007 $0 0.00% $0 #DIV/0!
REFUSE $70,007 $0 0.00% $0 #DIV/0!
WATER $70,007 $0 0.00% $0 #DIV/01
TOTAL TRANSFERS IN $350,035 $0 -100.00% $0 #DIV/0!
TOTAL REVENUES $2,033,736 $0 -100.00% $0 #DIV/0!
4
CITY OF FARMINGTON
2013 BUDGET BREAKDOWN
REVENUES SUMMARY
ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATI
• ' LICENSES/PERMITS 2011 12/2011 2012 1/2012 2013 2014
LIQUOR LICENSES $16,000 $24,850 155.31% $16,000 $6,675 41.72% $0 $0
BEER LICENSES $2,000 $3,075 153.75% $2,000 $1,800 90.00% $0 $0
CLUB LICENSES $900 $300 33.33% $900 $300 33.33% $0 $0
ANIMAL LICENSES $9,755 $1,178 12.08% $9,755 $1,337 13.71% $0 $0
ARCADE LICENSES $0 $690 #DIV/01 $0 $760 #DIV/01 $0 $0
MASSAGE LICENSES $1,000 $550 55.00% $1,000 $250 25.00% $0 $0
GAMBLING LICENSES/PERMITS $1,000 $300 30.00% $1,000 $100 10.00% $0 $0
OTHER LICENSES $1,500 $1,400 93.33% $1,500 $2,675 178.33% $0 $0
TOTAL LICENSES/PERMITS $32,155 $32,343 100.58% $32,155 $13,897 43.22% $0 $0
ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATE
PERMITS 2011 12/2011 2012 1/2012 2013 2014
BUILDING PERMITS $340,000 $345,880 101.73% $340,000 $4,934 1.45% $0 $0
REINSPECTION FEES $300 $465 155.00% $300 $0 0.00% $0 $0
PLUMBING/HEATING PERMITS $35,000 $44,920 128.34% $35,000 $437 1.25% $0 $0
SEWER PERMITS $10,000 $4,560 45.60% $10,000 $150 1.50% $0 $0
ELECTRIC PERMITS $0 $20,646 #DIV/0I $0 $859 #DIV/OI $0 $0
ISTS PERMIT $0 $700 #DIV/0I $0 $60 #DIV/01 $0 $0
COUNTY SEPTIC FEE PERMIT $0 $40 #DIV/01 $0 -$40 #DIV/01 $0 $0
UTILITY PERMITS $3,000 $5,835 194.50% $3,000 $0 0.00% $0 $0
STREET BREAKING PERMITS $0 $210 #DIV/0I $0 $0 #DIV/01 $0 $0
SIGN PERMITS $1,000 $570 57.00% $1,000 $80 8.00% $0 $0
BURNING PERMITS $5,000 $4,330 86.60% $5,000 $180 3.60% $0 $0
OTHER PERMITS $5,000 $9,565 191.30% $5,000 $260 5.20% $0 $0
TOTAL PERMITS $399,300 $437,721 109.62% $399,300 $6,920 1.73% $0 $0
ADOPTED THR:•UGH APPR:•'VED THROUGH REQUESTED ESTIMATE[
FINES AND F•RFEITURES 2011 12/2011 2012 1/2012 2013 2014
FINES $70,000 $78,460 112.09% $70,000 $575 0.82% $0 $0
TOTAL FINES/FORFEITURES $70,000 $78,460 112.09% $70,000 $575 0.82% $0 $0
ADOPTED THR1 UGH APPROVED THROUGH REQUESTED ESTIMATE
INTERGOVERNMENTAL 2011 12/2011 2012 1/2012 2013 2014
STATE AID-MAINTENANCE $163,140 $173,857 106.57% $163,140 $96,503 59.15% $0 $0
STATE AID-POLICE $154,000 $165,749 107.63% $154,000 $0 0.00% $0 $0
STATE AID-POST TRAINING $9,000 $23,493 261.03% $9,000 $0 0.00% $0 $0
STATE AID-FIRE $73,000 $87,709 120.15% $73,000 $0 0.00% . $0 $0
OTHER-STATE GRANT $0 $13,350 #DIV/0! $0 $0 #DIV/0I $0 $0
5
OTHER-DAKOTA COUNTY $5,250 $16,038 305.49% $5,250 $0 0.00% $0 $0
OTHER $1,200 $2,209 184.08% $1,200 $0 0.00% $0 $0
TOTAL INTERGOVERNMENTAL $405,590 $482,405 118.94% $405,590 $96,503 23.79% $0 - $0
•
• ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATE
CHARGES FOR SERVICES 2011 12/2011 2012 1/2012 2013 2014
CUSTOMER SERVICE FEES $1,000 $559 55.90% $1,000 $67 6.70% $0 $0
ZONING/SUBDIVISION FEES $3,000 $3,825 127.50% $3,000 $200 6.67% $0 $0
PRE PLAT ADMIN FEES $5,000 $750 15.00% $5,000 $0 0.00% $0 $0
FIRE TOWNSHIP FEES $170,000 $187,077 110.05% $145,000 $0 0.00% $0 $0
ISD 192 SRO FEES $205,377 $232,269 113.09% $171,148 $125 0.07% $0 $0
EROSION/SEDIMENT CONTROL $12,000 $10,400 86.67% $12,000 $200 1.67% $0 $0
GIS FEES $2,000 $220 11.00% $2,000 $0 0.00% $0 $0
PUBLIC WORKS CHARGES $0 $3,434 #DIV/01 $0 $0 #DIV/0I $0 $0
RECREATION PROGRAM FEES $103,675 $96,036 92.63% $122,675 $2,173 1.77% $0 $0
POOL ADMISSIONS $38,000 $36,520 96.11% $39,000 $0 0.00% $0 $0
SWIN LESSON FEES $18,000 $16,885 93.81% $18,500 $0 0.00% $0 $0
POOL CONCESSIONS $11,000 $9,208 83.71% $11,000 $0 0.00% $0 $0
RRC MEMBERSHIP FEES $8,500 $0 0.00% $8,500 $3,115 36.65% $0 $0
RECREATION ADVERTISING $2,200 $1,950 88.64% $2,200 $0 0.00% $0 $0
SALE OF ASSETTS $1,626 $0 0.00% $1,626 $0 0.00% $0 $0
FRANCHISE FEES $75,000 $75,000 100.00% $75,000 $0 0.00% $0 $0
TOTAL CHARGES FOR SERVICE $656,378 $674,133 102.70% $617,649 $5,880 0.95% $0 $0
ADOPTED THROUGH APPR•NEID TIIRtUGH REQUESTED ESTIMATE[
MISCELLANEOUS 2011 12/2011 2012 1/2012 2013 2014
INVESTMENT INCOME $200,000 $135,600 67.80% $80,000 $4,872 6.09% $0 $0
DONATIONS $0 $5,520 #DIV/01 $26,000 $0 0.00% $0 $0
RENTALS $7,000 $18,225 260.36% $18,500 $1,630 8.81% $0 $0
MISCELLANEOUS $62,000 $7,058 11.38% $34,507 $0 0.00% $0 $0
TOTAL MISCELLANEOUS $269,000 $166,403 61.86% $159,007 $6,502 4.09% $0 $0
ADOPTED THROUGH APP' •-VED TNR•'UGH REQUESTED ESTI', ATED
TRANSFERS 2011 12/2011 2012 1/2012 2013 2014
LIQUOR OPERATIONS $70,007 $70,007 100.00% $70,007 $0 '0.00% $0 $0
SEWER $70,007 $70,007 100.00% $70,007 $0 0.00% $0 $0
STORM WATER $70,007 $70,007 100.00% $70,007 $0 0.00% $0 $0
REFUSE $70,007 $70,007 100.00% $70,007 $o 0.00% $0 $0
WATER $70,007 $70,007 100.00% $70,007 $0 0.00% $0 $0
TOTAL TRANSFERS $350,035 $350,035 100.00% $350,035 $0 0.00% $0 $0
TOTAL REVENUES $2,182,458 $2,221,500 101.79% $2,033,736 $130,277 6.41% $0
$0
6
CITY OF FARMINGTON
2013 BUDGET
ADMINISTRATION-LEGISLATIVE CONTROL
ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED
PERSONNEL 2011 12/2011 % 2012 1/2012 % 2013 2014
6120 SALARIES-PT $36,120 $36,120 100.00% $36,120 $3,010 8.33% $0 $0
6152 FICA/MEDICARE $2,763 $2,763 100.00% $2,763 $230 8.32% $0 $0
6154 PERA $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0
6158 EMPLOYEE BENEFITS $69 $69 100.00% $69 $5 7.25% $0 $0
TOTAL PERSONNEL $38,952 $38,952 100.00% $38,952 $3,245 8.33% $0 $0
OTHER SERVICES
6403 LEGAL $25,000 $15,185 60.74% $22,000 $0 0.00% $0 $0
6460 DUES/SUBSCRIPTIONS $12,515 $14,757 117.91% $14,665 $0 0.00% $0 $0
6470 TRAINING/SUBSISTANCE $985 $1,408 142.94% $985 $220 22.34% $0 $0
6485 MILEAGE $200 $265 132.50% $200 $41 20.50% $0 $0
TOTAL OTHER SERVICES $38,700 $31,615 81.69% $37,850 $261 0.69% $0 $0
TOTAL BUDGET $77,652 $70,567 90.88% $76,802 $3,506 4.56% $0 $0
3/7/2012 -, Legislative Control
CITY OF FARMINGTON
2013 BUDGET
ADMINISTRATION-CITY ADMINISTRATOR
ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED
PERSONNEL 2011 12/2011 % 2012 1/2012 % 2013 2014
6110 SALARIES-FT $266,677 $298,008 111.75% $251,564 $14,779 5.87% $0 $0
6112 SALARIES-OT $1,375 $0 0.00% $0 $0 #DIV/0I $0 $0
6120 SALARIES-PT $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0
6152 FICA/MEDICARE $20,506 $22,481 109.63% $19,245 $1,154 6.00% $0 $0
6154 PERA $19,434 $19,615 100.93% $18,238 $1,071 5.87% $0 $0
6156 HCSP $0 $35 #DIV/0I $0 $26 #DIV/0I $0 $0
6158. EMPLOYEE BENEFITS $95,762 $47,789 49.90% $76,326 $6,221 8.15% $0 $0
6159 WORKERS COMPENSATION $0 $0 #DIV/01 $0 $143 #DIV/0I $0 $0
TOTAL PERSONNEL $403,754 $387,928 96.08% $365,373 $23,394 6.40% $0 $0
SUPPLIES
6210 OFFICE SUPPLIES $27,000 $15,784 58.46% $20,000 $536 2.68% $0 $0
6220 EQUIPMENT SUPPLIES $3,000 $0 0.00% $2,500 $0 0.00% $0 $0 ,
TOTAL SUPPLIES $30,000 $15,784 52.61% $22,500 $536 2.38% $0 $0
OTHER SERVICES
6401 PROFESSIONAL SERVICES $5,700 $3,623 63.56% $5,700 $500 8.77% $0 $0
6403 LEGAL $11,250 $20,375 181.11% $11,000 $0 0.00% $0 $0 .
6404 IT SERVICES $7,185 $7,185 100.00% $8,156 $679 8.33% $0 $0
6412 CELLULAR TELEPHONES $840 $405 48.21% $540 $45 8.33% $0 $0
6455 LEGAL PUBLICATION $1,500 $498 33.20% $1,000 $0 0.00% $0 $0
6460 DUES/SUBSCRIPTIONS $2,755 $289 10.49% $1,500 $35 2.33% $0 $0
6470 TRAINING/SUBSISTANCE $3,160 $1,139 36.04% $2,000 $0 0.00% $0 $0
6480 MEETING EXPENSE $0 $35 #DIV/0I $0 $0 #DIV/0I $0 $0
6485 MILEAGE $2,500 $737 29.48% $1,600 $31 1.94% $0 $0
6492 ADVERTISING $0 $84 #DIV/0I $0 $0 #DIV/0I $0 $0
6505 EQUIPMENT REPAIR $20,920 $18,283 87.39% $18,500 $0 0.00% $0 $0
6555 EQUIPMENT RENTAL $32,700 $33,120 101.28% $32,700 $405 1.24% $0 $0
7420 MISCELLANEOUS $0 $0 #DIV/0I $141,192 $0 0.00% $0 $0
TOTAL OTHER SERVICES $88,510 $85,773 96.91% $223,888 $1,695 0.76% $0 $0
TOTAL BUDGET $522,264 $489,485 93.72% $611,761 $25,625 4.19% $0 $0
3/7/2012 8 City Administrator
CITY OF FARMINGTON
2013 BUDGET
1051
POLICE-PATROL
ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED
PERSONNEL 2011 12/2011 % 2012 1/2012 % 2013 2014
6110 SALARIES-FT $1,239,503 $1,219,727 98.40% $1,278,409 $77,341 6.05% $0 $0
6112 SALARIES-OT $88,312 $85,050 96.31% $79,475 $2,267 2.85% $0 $0
6120 SALARIES-PT $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0
6130 COMP TIME PAY $0 $38,962 #DIV/0I $0 $1,671 #DIV/0I $0 $0
6135 OTHER PAY $0 $0 #DIV/01 $0 $0 #DIV/01 $0 $0
6152 FICA/MEDICARE $19,253 $19,273 100.10% $19,689 $1,094 5.56% $0 $0
6154 PERA • $191,206 $193,498 101.20% $195,535 $11,086 5.67% $0 • $0
6156 HCSP $0 $0 #DIV/01 $0 $0 #DIV/01 $0 , $0
6158 EMPLOYEE BENEFITS $236,845 $243,199 102.68% $199,360 $13,379 6.71% $0 $0 _
6159 WORKERS COMP $0 $0 #DIV/0! $0 $4,165 #DIV/0I $0 $0
TOTAL PERSONNEL $1,775,119 $1,799,709 101.39% $1,772,468 $111,003 -93.74% $0 $0
SUPPLIES
6210 OFFICE SUPPLIES $1,000 $576 57.60% $500 $0 0.00% $0 $0
6220 EQUIPMENT SUPPLIES $5,300 $5,786 109.17% $6,800 $2,606 3832% $0 $0
6230 VEHICLE SUPPLIES/PARTS $13,500 $19,120 141.63% $13,500 $406 3.01% $0 $0
6234 VEHICLE LICENSES $1,000 $56 5.60% $1,000 $0 0.00% $0 $0
6250 OTHER SUPPLIES $12,300 $8,199 66.66% $14,300 $842 5.89% $0 $0
6272 FUEL $70,000 $75,365 107.66% $73,000 $0 0.00% $0 $0
6290 UNIFORMS $13,000 $22,836 175.66% $13,000 $11,391 87.62% $0 $0
TOTAL SUPPLIES $116,100 $131,938 113.64% $122,111 $15,245 12.49% $0 $0
OTHER SERVICES
6401 PROFESSIONAL SERVICES $1,650 $160 9.70% $1,650 $0 0.00% $0 $0
6402 DATA PROCESSING $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0
6403 LEGAL $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0
6404 IT SERVICES $34,493 $34,493 100.00% $45,023 $3,751 8.33% $0 $0
6406 K9 EXPENSES $0 $1,153 #DIV/01 $500 $0 0.00% $0 $0
6411 TELEPHONE $2,900 $1,080 37.24% $2,900 $0 0.00% $0 $0
6412 CELLULAR TELEPHONES $15,200 $15,031 98.89% $15,200 $1,127 7.41% $0 $0
6421 MUNICIPAL SERVICES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0
6422 ELECTRIC $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0
6423 NATURAL GAS $0 $0 #DIV/0I $0 $0 #DIV/OI $0 $0
6445 POSTAGE $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0
6455 OUTSIDE PRINTING $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0
6460 DUES/SUBSCRIPTIONS $5,200 $4,085 78.56% $7,200 $5,000 69.44% $0 $0
6470 TRAINING/SUBSISTANCE $15,000 $11,205 74.70% $18,000 $361 2.01% $0 $0
3/7/2012 9 Police-Patrol
6485 MILEAGE $750 $468 62.40% $750 $0 0.00% $0 $0
6505 EQUIPMENT REPAIR $1,000 $95 9.50% $1,000 $0 0.00% $0 $0
6510 VEHICLE MAINTANANCE $56,650 $60,096 106.08% $55,000 $4,583 8.33% $0 $0
6515 BUILDING REPAIR $0 $95 #DIV/01 $0 $0 #DIV/0I $0 $0
6560 CONTRACTED SERVICES $212,550 $196,660 92.52% $213,120 $7,817 3.67% $0 $0
TOTAL OTHER SERVICES $345,393 $324,621 93.99% $360,343 $22,639 6.28% $0 $0
CAPITAL OUTLAY
6940 VEHICLES $54,000 $49,801 92.22% $54,000 $0 0.00% $0 $0
TOTAL CAPITAL OUTLAY $54,000 $49,801 • 92.22% $54,000 $0 0.00% $0 $0
TOTAL BUDGET $2,290,612 $2,306,069 100.67% $2,308,911 $148,887 6.45% $0 $0
•
3/7/2012 1 0 Police-Patrol
CITY OF FARMINGTON
2013 BUDGET
ICE ARENA
. REVENUES APPROVED THROUGH APPROVED THROUGH REQUESTED ESTIMATE[
2011 12/2011 % 2012 1/2012 % 2013 2014
4825 ADMISSIONS $15,000 $730 4.87% $15,000 $0 0.00% $0 $0
4820 OPEN SKATING $5,000 $4,116 82.32% $2,500 $706 28.24% $0 $0
4810 ICE RENTAL $250,000 $255,936 102.37% $255,000 $0 0.00% $0 $0
5010 MERCHANDISE SALES $0 $840 #DIV/OI $800 $73 9.13% $0 $0
4830 SKATE SHARPENING $4,000 $2,075 51.88% $2,500 $413 16.52% $0 $0
4668 CONCESSIONS $4,700 $489 10.40% $1,000 $0 0.00% $0 $0
4815 INSTRUCTION $17,000 $15,189 89.35% $17,000 $4,480 26.35% $0 $0
4835 ADVERTISING $9,000 $6,171 68.57% $9,500 $0 0.00% $0 $0
4840 SKATE SHOW $4,500 $4,158 92.40% $4,500 $0 0.00% $0 $0
4512 SUMMER ACTIVITIES $500 $531 106.20% $500 $0 0.00% $0 $0
5350 MISCELLANEOUS $0 $1,431 #DIV/01 $0 $0 #DIV/0I $0 $0
TOTAL REVENUE $309,71 M $291,666 94.18% $308,300 $5,672 1.84% $0 $0
EXPENSES .
6100 PERSONAL SERVICES $175,115 $198,517 113.36% $176,800 $9,889 5.59% $0 $0
6200 SUPPLIES $17,350 $10,542 60.76% $14,450 $2,141 14.82% $0 $0
6400 OTHER SERVICES/CHARGES $112,682 $97,422 86.46% $110,506 $8,921 8.07% $0 $0
6900 CAPITAL OUTLAY $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0
TOTAL EXPENSES $305,147 $306,481 100.5,% $301,756 $20,951 6.94% $0 $0
INCOME(LOSS)BEFORE $4,553 -$14,815 -325.39% $6,544 -$15,279 -233.48% $0 $0
TRANSFERS
3/7/2012 1 1 Ice Arenda Budd
CITY OF FARMINGTON
2013 BUDGET _
ICE ARENA
A)%OPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED
PERSONNEL 2011 12/2011 o 2012 1/2012 % 2013 2014
6110 SALARIES-FT $101,441 $102,494 101.04% $94,860 $3,541 3.73% $0 $0
6112 SALARIES-OT $2,725 $963 35.34% $0 $0 #DIV/0I $0 $0
6120 SALARIES-PT $19,910 $37,340 187.54% $37,390 $3,172 8.48% $0 $0
6130 COMP TIME $0 $824 #DIV/0I $0 $0 #DIV/0I $0 $0
6135 OTHER PAY $0 $1,270 #DIV/0I $0 $109 #DIV/0I $0 $0
6152 FICA/MEDICARE $9,492 $10,174 107.18% $10,117 $516 5.10% $0 $0
6154 PERA $7,552 $10,837 143.50% $7,530 $353 4.69% $0 $0
6156 HCSP $0 $68 #DIV/0I $0 $0 #DIV/0I $0 $0
6158 EMPLOYEE BENEFITS $33,995 $34,547 101.62% $26,903 $2,198 8.17% $0 $0
TOTAL PE'',ONNEL $175,115 $198,517 113.36% $176,800 $9,119 5.59% $0 $0
SUPPLIES
5502 COST OF GOODS SOLD $1,400 $1,164 83.14% $1,400 $1,535 109.64% $0 $0
6220 EQUIPMENT/SUPPLIES $6,800 $3,038 44.68% _ $1,600 $35 2.19% $0 $0
6240 BUILDING SUPPLIES $5,100 $2,558 50.16% $7,600 $168 2.21% $0 $0
6250 OTHER SUPPLIES $750 $554 73.87% $750 $15 2.00% $0 $0
6255 LANDSCAPE MATERIALS $200 $302 151.00% $0 $0 #DIV/0I $0 $0
6272 FUEL $2,000 $1,759 87.95% $2,000 $263 13.15% $0 $0
6290 UNIFORMS $1,100 $1,167 106.09% $1,100 $125 11.36% $0 $0
TOTAL SUPPLIES $17,350 $10,542 60.76% $14,450 $2,141 14.82% $0 $0
OTHER SERVICES
6401 PROFESSIONAL SERVICES $6,000 $8,249 137.48% $6,000 $74 1.23% $0 $0
6404 IT SERVICES $2,587 $2,587 100.00% $2,936 $244 8.31% $0 $0
6411 TELEPHONE $625 $831 132.96% $1,000 $151 15.10% $0 $0
6412 CELLULAR TELEPHONES $1,000 $0 0.00% $500 $0 0.00% $0 $0
6421 MUNICIPAL SERVICES $7,000 $4,453 63.61% $7,000 $1,454 20.77% _ $0 $0
6422 ELECTRICAL $43,000 $38,356 89.20% $45,000 $3,517 7.82% $0 $0
6423 NATURAL GAS $22,800 $15,041 65.97% $23,000 $2,650 11.52% $0 $0
6426 INSURANCE $8,000 $8,000 100.00% $8,000 $666 8.33% $0 $0
6445 POSTAGE $0 $0 #DIV/0I $0 $0 #DIV/OI $0 $0
6450 OUTSIDE PRINTING $500 - $115 23.00% $500 $0 0.00% $0 $0
6460 DUES/SUBSCRIPTIONS $3,095 $1,146 37.03% $3,020 $145 4.80% $0 $0
6470 TRAINING/SUBSTINANCE $1,450 $959 66.14% $1,500 $0 0.00% $0 $0
6485 MILEAGE $0 $234 #DIV/01 $0 $0 #DIV/0I $0 $0
6492 ADVERTISING $0 $195 #DIV/0I $0 $0 #DIV/OI $0 $0
6505 EQUIPMENT MAINT. $8,750 $4,133 47.23% $4,750 $20 0.42% $0 $0
3/7/2012 1 2 Ice Arenda Bi
6510 VEHICLE REPAIR $0 $0 #DIV/01 $0 $0 #DIV/0I . $0 $0
6515 BUILDING MAINT. $4,800 $1,897 39.52% $3,300 $0 0.00% $0 $0
6545 CREDIT CARD FEES $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0
6555 EQUIPMENT RENTAL $0 $5,597 #DIV/0I $0 $0 #DIV/0I $0 $0
6556 BUILDING RENT $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0
6570 PROGRAM EXPENSE $3,075 $5,611 182.47% $4,000 $0 0.00% $0 $0
7420 MISCELLANEOUS $0 $18 #DIV/OI $0 $0 #DIV/0I $0 $0
TOTAL OTHER SERVICES $112,682 $97,422 86.46% $110,506 $8,921 8.07% $0 $0
TOTAL BUDGET $305,147 $306,481 100.44% $301,756 $20,951 6.94% $0 $0
•
•
•
3/7/2012 1 3 Ice Arenda Bt
;CITY OF FARMINGTON
12013 BUDGET
UQOUR STORE SUMMARY -
• 'REVENUES APPROVED THROUGH APPROVED THROUGH REQUESTED ESTIMATE
2011 12/2011 % 2012 1/2012 % 2013 2014
4750 SALES DOWNTOWN $2,000,000 $1,858,022 92.90% $1,880,000 $116,340 6.19% $0 $0
4750 SALES PILOT KNOB $2,439,250 $2,336,901 95.80% $2,390,000 $148,432 6.21% $0 $0
,5502 COST OF GOOD SOW -$3,418,223 -$3,167,685 92.67% -$3,287,900 -$207,750 6.32% $0 $0
I
I
I GROSS PROFIT $1,021,027 $1,027,238 100.61% $982,100 $57,022 5.81% $0 $0
;4955 INVESTMENT INCOME $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0
.5350 MISCELLANEOUS $2,000 $4,556 227.80% $2,000 $0 0.00% $0 $0
I
TOTAL OTHER REVENUE $2,000 $4,556 227.80% $2,000 $0 0.00% $0 $0
1
TOTAL REVENUE $1,023,027 $1,031,794 100.86% $9:-,100 $57,022 5.79% $0 $0
EXPENSES
6100 PERSONAL SERVICES $397,888 $395,215 99.33% $393,148 $21,540 5.48% $0 $0
16200 SUPPLIES $15,100 $6,185 40.96% $15,100 $7,385 48.91% $0 $0
6400 OTHER SERVICES/CHARGES $528,297 $503,107 95.23% $470,203 $9,727 2.07% $0 $0.
16900 CAPITAL OUTLAY $0 $0 #DIV/01 $0 $0 #DIV/01 $0 $0
I
TOTAL EXPENSES $941,285 $904,507 96.09% $878,451 $38,652 4.40% $0 $0
1
INCOME(LOSS)BEFORE $81,742 $127,287 155.72% $105,649 $18,370 17.39% $0 $0
TRANSFERS
TRANSFERS
7310 GENERAL FUND -$70,007 -$70,007 100.00% -$70,007 -$5,834 8.33% $0 $0
7310 SWIMMING POOL -$20,000 -$20,000 100.00% -$20,000 $0 0.00% $0 $0
TOTAL TRANSFERS -$90,1 J 7 -$90,007 100.00% -$90,007 -$5,834 6.48% $0 $0
INCOME(LOSS)AFTER -$8,265 $37,280 -451.06% $15,642 $12,536 80.14% „ $0
TRANSFERS
TOTAL EXPENSES $1,031,292 $994,514 96.43% $968,458 $44,486 4.59% $0 $0
LESS DEPRECIATION $40,000 $21,192 52.98% $40,000 $40,000 100.00% $0 $0
TOTAL NET EXPENSES $1,071,292 $1,015,706 94.81% $1,008,458 $84,486 8.38% $0 $0
3/7/2012 14 Liquor Store BudE
NET INCOME(LOSS) -$48,265 $16,088 -33.33% -$24,358 -$27,464 112.75% $0 $0
3/7/2012 15 Liquor Store Budgets
CITY OF FARMINGTON
2013 BUDGET
LIQUOR STORE-DOWNTOWN
ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED
PERSONNEL 2011 12/2011 % 2012 1/2012 % 2013 2014
6110 SALARIES-FT $108,323 $114,173 105.40% $109,212 $5,851 5.36%. $0 $0
6112 SALARIES-OT $3,000 $275 9.17% $3,000 $0 0.00% $0 $0
6120 SALARIES-PT $41,000 $37,237 90.82% $41,410 $1,396 3.37% $0 $0
6152 FICA/MEDICARE $11,653 $11,717 100.55% $11,752 $563 4.79% $0 $0
6154 PERA $11,044 $10,764 97.46% $11,138 $525 4.71% $0 $0
6156 HCSP $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0
6157 OPEB $0 $2,241 #DIV/01 $0 $0 #DIV/0I $0 $0
6158 EMPLOYEE BENEFITS $23,924 $24,191 101.12% $20,062 $1,672 8.33% $0 $0
TOTAL PERSONNEL $198,944 $200,598 100.83% $196,574 $10,007 -94.91% $0 $0
SUPPLIES
6210 OFFICE SUPPLIES $0 $80 #DIV/0I $0 $0 #DIV/0I $0 $0
6250 OTHER SUPPLIES $7,150 $2,493 34.87% $7,150 $127 1.78% $0 $0
6272 FUEL $0 $12 #DIV/0! $0 $0 #DIV/0! $0 $0
6290 UNIFORMS $400 $168 42.00% $400 $0 0.00% $0 $0
TOTAL SUPPLIES $7,550 $2,753 36.46% $7,550 $127 1.68% $0 $0
OTHER SERVICES
6401 PROFESSIONAL SERVICES $3,585 $6,836 190.68% $3,585 $0 0.00% $0 $0
6404 IT SERVICES $8,911 $8,911 100.00% $10,114 $842 8.33% $0 $0
6422 ELECTRICAL $14,000 $13,723 98.02% $14,000 $636 4.54% $0 $0 _
6423 NATURAL GAS $3,100 $1,531 49.39% $3,100 $0 0.00% $0 $0
6426 INSURANCE $6,825 $6,825 100.00% $6,825 $568 8.32% $0 $0
6445 POSTAGE $0 $74 #DIV/0I $0 $0 #DIV/0I $0 $0
6450 OUTSIDE PRINTING $325 $80 24.62% $325 $0 0.00% $0 $0
6460 DUES/SUBSCRIPTIONS $1,900 $1,398 73.58% $1,900 $322 16.95% $0 $0
6470 TRAINING/SUBSTINANCE $1,800 $137 7.61% $1,800 $0 0.00% $0 $0
6485 MILEAGE $400 $29 7.25% $400 . $0 0.00% $0 $0
6492 ADVERTISING $3,500 $1,360 38.86% $3,500 $0 0.00% $0 $0
6505 EQUIPMENT MAINT. $6,750 $7,313 108.34% $7,250 $210 2.90% $0 $0
6510 VEHICLE REPAIR $0 $220 #DIV/01 $0 $0 #DIV/01 $0 $0
6515 BUILDING MAINT. $2,350 $1,236 52.60% $2,350 $0 0.00% $0 $0
6545 CREDIT CARD FEES $33,000 $26,839 81.33% $33,000 $2,079 6.30% $0 $0
6556 BUILDING RENT $155,000 $163,095 105.22% $165,000 $0 0.00% $0 $0
6570 PROGRAM EXPENSE $500 $28 5.60% $500 $0 0.00% $0 $0
7420 MISCELLANEOUS $500 $0 0.00% $500 $0 0.00% $0 $0
3/7/2012 1 6 Liquor Store Budgets 2
TOTAL OTHER SERVICES $242,446 $239,635 98.84% $254,149 $4,657 1.83% $0 $0
TOTAL BUDGET $448,940 $442,986 98.67% $458,273 $14,791 3.23% $0 $0
3/7/2012 1 7 Liquor Store Budgets 2
CITY OF FARMINGTON
2013 BUDGET
LIQUOR STORE-PILOT KNOB
ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED
PERSONNEL 2011 12/2011 % 2012 1/2012 % 2013 2014
6110 SALARIES-FT $108,323 $108,709 100.36% $109,212 $6,810 6.24% $0 $0
6112 SALARIES-OT $3,000 $276 9.20% $3,000 $0 0.00% $0 $0
6120 SALARIES-PT $41,000 $37,086 90.45% $41,410 $1,699 4.10% $0 $0
6152 FICA/MEDICARE $11,653 $10,922 93.73% $11,752 $667 5.68% $0 $0
6154 PERA $11,044 $10,073 91.21% $11,138 $617 5.54% $0 $0
6156 HCSP $0 $902 #DIV/0! $0 $53 #DIV/01 $0 $0
6157 OPEB $0 $2,241 #DIV/0I $0 $0 #DIV/0I $0 $0
6158 EMPLOYEE BENEFITS $23,924 $24,408 102.02% $20,062 $1,687 8.41% $0 $0
TOTAL PERSONNEL $198,944 $194,617 97.83% $196,574 $11,533 5.87% $0 $0
SUPPLIES
6210 OFFICE SUPPLIES $0 $80 #DIV/0! $0 $0 #DIV/0I $0 $0
6220 EQUIPMENT SUPPLIES $0 $0 #DIV/01 $0 $7,046 #DIV/0! $0 $0 ,
6250 OTHER SUPPLIES $7,150 $3,340 46.71% $7,150 $212 2.97% $0 $0
6272 FUEL $0 $12 #DIV/01 $0 $0 #DIV/0! $0 $0
6290 UNIFORMS $400 $0 0.00% $400 $0 0.00% $0 $0
TOTAL SUPPLIES $7,550 $3,432 45.46% $7,550 $7,258 96.13% $0 $0
OTHER SERVICES
6401 PROFESSIONAL SERVICES $3,585 $3,856 107.56% $3,585 $0 0.00% $0 $0
6404 IT SERVICES $8,911 $8,911 100.00% $10,114 $842 8.33% $0 $0
6422 ELECTRICAL $16,000 $14,990 93.69% $16,000 $0 0.00% $0 $0
6423 NATURAL GAS $3,500 $2,398 68.51% $3,500 $393 11.23% $0 $0
6426 INSURANCE $6,825 $6,825 100.00% $6,825 $569 8.34% $0 $0
6445 POSTAGE $0 $74 #DIV/0I $0 $0 #DIV/01 $0 $0
6450 OUTSIDE PRINTING $325 $80 24.62% $325 $0 0.00% $0 $0
6460 DUES/SUBSCRIPTIONS $0 $1,398 #DIV/01 $0 $0 #DIV/0I $0 $0
6470 TRAINING/SUBSTINANCE $1,500 $137 9.13% $1,500 $0 0.00% $0 $0
6485 MILEAGE $400 $29 7.25% $400 $0 0.00% $0 $0
6492 ADVERTISING $3,500 $1,334 38.11% $3,500 $20 0.57% $0 $0
6505 EQUIPMENT MAINT. $9,455 $10,250 108.41% $9,455 $210 2.22% $0 $0
6515 BUILDING MAINT. $2,350 $4,309 183.36% $2,350 $0 0.00% $0 $0
6545 CREDIT CARD FEES $38,000 $40,024 105.33% $38,000 $3,036 7.99% $0 $0
6556 BUILDING RENT $191,000 $168,829 88.39% $120,000 $0 0.00% $0 $0
6570 PROGRAM EXPENSE $500 $28 5.60% $500 $0 0.00% $0 $0
7420 MISCELLANEOUS $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0
3/7/2012 1 8 Liquor Store Budgets 2
TOTAL OTHER SERVICES $285,851 $263,472 92.17'% $216,054 $5,070 2.35% $0 $0
TOTAL BUDGET $492,345 $461,521 93.74% $420,178 $23,861 5.68% $0 $0
•
3/7/2012 1 9 Liquor Store Budgets 2
I, 00 v m
N 00 00 to
U R n 00 01
CI 0• 011 -1 N r00-I
ri R N N
in in. in. in.
N N 01 I.
01 0 N N
'p0> In 11O 0 000 m Cr N 01 In u1 N
I I I u1 M 'D t 00 u1 00 'O ri N N O M
In O. ii, N N N
to tD N N in
M N 1/ �tip 03 01 m 00 to O tmo< D r-I M I. r1 a-1 -4
i/• 1/). ii.
(N 01 O
N M O I�J O 01 tD N
D M N 000 01
O▪D H O
in. in. in
I.L. LL �' O r-I ri u1
4., N N -I N
L Q cr M ri o
>. C / 2 rn ti°D v
▪•, v> v> in vI CO ty
OC cr N d' O Ln
U CD
1:17/
D_ 00 0 01
LI• L) i?
/ O in O O
0: - co M 00
Q t0 t0 R N
/ in M in in
/ N N 00
00 00
N
I: N M
LL ,-4 0 r-I a-1
r-; a 4 4
in. in- in. in
1-I ri 0 0 01
01 ct M Cr LID
QN dm' M M
- N ck LO N N
ri r-I e-I' r-1 a-I
1/1 in t/). i/} in
00 01 0 1-I N
0 0 0 0 0 LO? 0 0 O 0 0 0 0 0
0 0 0 0 0 0 0 0 O o O O O O 00 O Hilt
Ln N N ri i 1 in t!). 1
awl spry