06. Public WorksSPECIAL REVENUE FUNDS
Page
Fund
Dept PUBLIC WORKS
14-16
2400
Light Maintenance
$
421,739
17-18
2420
Gas Tax
$
745,500
19-23
2500
Street Maintenance
$
2,4941203
24
2825
MAGI Grant
$
650,000
Total
$
4,311,442
LIGHT MAINTENANCE
ACCOUNT # 2400-410
PURPOSE OF THIS DEPARTMENT: why does this department exist?
Light Maintenance funds are utilized by the Traffics Signs and Signals Division to provide visibility that
promotes safe and efficient use of.street facilities.
DEPARTMENT PERSONNEL: (1.25 FTE)
.05 Budget Resource Manager
.20 Assessments Coordinator
I Light Maintenance
GOALS OF THIS DEPARTMENT: what are the departmental goals that support the purpose?
Achieve lighting standards and promote light replacements with longer lasting and more efficient lighting
systems.
INTENDED OUTCOMES FROM BUDGET EXPENDITURES
The FYI 4 budget presents the continuation of the rehabilitation of downtown decorative light system to
promote efficient lighting systems and amore pleasing downtown environment.
LIGHT MAINTENANCE
FiTND:2400-410-430263
PROJECTED REVENUE AND FUND SUMMARY
MARY
BEGINNING CASH
10100 CASH:
REVENUES
363010 Maintenance Assessments
363040 Penalty & Interest
364030 Misc.
381050 Inception of Loan
371010 Interest Earnings
TOTAL AVAILABLE
EXPENDITURES
10100 CASH:
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
FY12/13
FY12/13
FY13/14
$150,829
$160,503
$160,503
$152,664
$233,535
$1,665
$1,000
$0
$1,342
$236,000
$1,500
$0
$115,000
$1,200
$236,730
$1,406
$5,888
$0
$1,028
$271,400
$1,500
$0
$98,000
$900
$237,542
$353,700
$245,052
$371,800
$388,371
$514,203
$405,555
$524,464
$227,868
$387,536
$252,891
$421,739
$160,503
$126,667
$152,664
$102,725
14
LIGHT MAINTENANCE
FUND: 2400-410-430263
Personal Services:
110
Salaries
112
Salaries - Severance
153
Health insurance
155
Retirement
Subtotal
Materials and Services:
244
Lighting Supplies
341
Electricity
360
Repair & Maint Services
510
Liability Insurance & Uninsured Loss
522
Administrative Transfer
Subtotal
Capital Outlay
940
Machinery & Equipment
Subtotal
Debt. Service: loan repayment
Principal -5 year -final pymt 2019
Interest -1.00%V
Total Debt
Total
EXPENDITURE DETAIL
ACTUAL
FI'11/12
BUDGET
FY12/13
ACTUAL
FY12/13
BUDGET
FY13/14
FTE'S 0.80
0.75
0.75
1.25
$36,678
$38,893
$38,402
$61,370
$0
$0
$0
$0
$7,198
$9,696
$8,071
$11,761
$2,327
$2,391
$2,434
$3,854
$46,203
$50,980
$48,907
$76,986
$14,575
$16,000
$17,025
$18,000
$151,064
$163,000
$160,006
$171,000
$7,552
$20,000
$15,883
$20,000
$872
$1,075
$2,160
$1,600
$7,603
$8,763
$8,763
$8,440
$181,666
$208,838
$203,837
$219,040
$0
$115,000
$147
$101,275
$0
$115,000
$147
$101,275
$0
$12,000
$0
$23,000
$0
$718
$0
$1,438
$0
$12,718
$0
$24,438
$227,868 $387,536 $252,891 $421,739
15
LIGHT MAINTENANCE
FUND: 24 00-410- 4 3 02 6 3
FY 2014 BUDGET HIGHLIGHTS
Line Item Detail: LIGHT MAINTENANCE
110 Salaries
Moved .50 salary from TsslSpecial Street Fund to reflect where actual time is spent.
341 Electricity - $171,000 (increased $8,000)
The City has seen an increase of 2% in electrical costs from additional lights that have been added to the system.
An additional 4% increase has been added for an anticipated electrical rate increase in July, 2013.
360 Repair & Maint Services - $20,000
As funds allow we anticipate rebuilding approximately (6) of the City's 5 globe downtown decorative lights each year.
The rebuild significantly reduces electrical costs and the electrical load on the underground wiring. There are 85,
5 globe decorative lights, installed approximately 13 years ago. The rebuild includes sandblasting and powder coating
the bases, installing new sockets, hardware, and wiring. The bulbs will also be converted from an incandescent 40 watt
bulb with a life of 10,000 hours to an LED 13 watt bulb with a life cycle of 100,000 hours.
Each rebuild cost approximately $750.
Capital Outlay:
940 Machinery & Equipment - CARRYOVER $98,000 (Financed 5 yr); New Appropriation $3,275
$98,000 Replacing 18 yr old boom truck.
$1,275 - Large Format Document Scanner & Plotter. Replaces current plotter that the electronic components
are starting to fail. The scanner would allow drawings of Public Works system improvements to be scanned into the network
server for rapid retrieval, will also reduce space needed for storage.
Cost shared between/Street, Sewer, Storm, Water, Light Maint, Solid Waste --Total Cost $25,500
$2,000 - Survey Grade Global Positioning System (GPS). Current GPS system is over 12 yrs old and is no
longer functioning. The GPS system will be used to support the new Asset Management System for Water, Sewer, Street, and Storm
systems, and to identify GPS location of City's 500 plus lights, and to support right of way and routing of Solid Waste services.
Cost shared between/Street, Sewer, Storm, Water, Light Maint, Solid Waste -- Total Cost $40,000
16
GAS TAX
ACCOUNT # 2420-421
PURPOSE OF THIS DEPARTMENT: Why does this department exist?
The city receives annual gas tax revenue allocations based on population and street and alley mileage to be
used for construction, reconstruction, maintenance and repair of streets, right of ways and alleys.
GOADS OF THIS DEPARTMENT: What are the departmental goals that support the purpose?
Provide a right of way infrastructure construction program that includes reconstruction, maintenance and
repair of streets, sidewalks, and alleys.
INTENDED OUTCOMES FROM BUDGET EXPENDITURES
The FYI 4 budget reflects the continuation of the pavement marking, overlay, chip seal, and sidewalk
replacement programs, which promotes safe travel and longevity of the road and pedestrian systems. This
year's budget also presents a shift in operations from contracting out milling services to performing this
activity in-house with rented equipment. This should provide for more flexibility in the program of work
and better coordination between the milling and asphalt scheduling.
GAS TAX
FUND: 2420-421-430240
PROJECTED REVENUE AND FUND SUMMARY
BEGINNING CASH
10100 Cash
REVENUE
335040 Gas Tax Apportionment
371010 Interest
Total Revenue
Total Available
EXPENDITURES
Street Department
Cash
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
FY12/13
FY12/13
FY13/14
$344,885
$464,352
$464,352
$422,595
$3611P157
$4,703
$366,904
$4,000
$360,650
$31250
$36000
$2,000
$3651)860
$370,904
$363,900
$362,000
$710,745
$8351256
$828,252
$784,595
$2465393
$732,855
$405,657
$745,500
$464,352
$102,401
$422,595
$39,095
17
GAS TAX
FUND: 2420-421-430240
EXPENDITURE DETAIL
430240
Materials and Services -Streets
231
Gas & Gil
344
Natural Gas
354
Contract Services -Striping
360
Contract - Snow Remove, Constr. Support, Repair
368
Overlays & Chipseals
369
Radio Maintenance
452
Gravel
453
Equipment Rental
471
De-lcerlRoad Gil
472
Asphalt
473
Crack Sealing Material
Subtotal
430234
Sidewalks 1 Alleys:
956
Sidewalk Construction
957
Alley Paving
Subtotal
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
FY12/13
FY12/13
FY13/14
$33,389
$38,000
$29,698
$38,000
$0
$3,500
$3,676
$3,500
$47,343
$300,400
$98,949
$200,000
$269
$7,500
$0
$3,500
$30,952
$201,455
$101,622
$309,800
$1,000
$700
$0
$700
$677
$3,000
$2,206
$3,000
$0
$3,000
$0
$18,000
$31,902
$47,000
$38,813
$47,000
$19,874
$30,000
$31,515
$30,000
$8,694
$7,000
$14,260
$7,000
$174,099
$641,555
$320,739
$660,500
$37,093
$36,500
$35,613
$40,000
$35,200
$54,800
$49,305
$45,000
$72,293
$91,300
$84,918
$85,000
Total $246,393 $732,855 $405,657 $745,500
FY 2014 BUDGET HIGHLIGHTS
Line Item Detail:
354 Contract Services/Striping City Streets - Carryover $200,000
368 Overlay & Chipseals - $309,800 - Carryover Over $109,800 - New Appropriation $200,000
453 Equipment Rental - $18,000
Increased $15,000 for the rental of an asphalt zipper for one month. Having the asphalt zipper available for a one month
period will significantly increase productivity, reducing overall costs.
956 Sidewalk Replacement - New Appropriation $40,000
$40,000 -- To be used for a matching program to assist homeowners with replacing bad sidewalks.
957 Alley Paving - New Appropriation $45,000
Pave approximately 10-12 alleys a year and overlay existing alleys with remaining funds.
18
SPECIAL STREET MAINTENANCE
ACCOUNT # 2500-421
PURPOSE OF THIS DEPARTMENT: why does this department exist?
To construct and maintain surface transportation, signals, and traffic controls that supports economic
viability and promote clean, safe, and drivable travel during all seasons.
DEPARTMENT PERSONNEL: (14.25 FTE)
.20 Public Works Director/City Engineer
.25 Senior Civil Engineer
.15 Budget Resource Manager
.25 Construction Manager
.15 Administrative Coordinator
.25 Project Manager
.50 Road and Fleet Superintendent
.20 Assessment Coordinator
.20 Administrative Assistant
.25 Engineering Tech1GISIIT Support
.10 General Laborer
5.75 Special Street Maintenance operators
1 Special Street Maintenance Supervisor
1 Traffic Signs and Signals Maintenance Supervisor
1 Traffic Signs and Signals Maintenance Technical
GOALS OF THIS DEPARTMENT: What are the departmental goals that support the purpose?
1. To maintain city streets in a clean, safe and drivable condition during all seasons.
2. To provide the safe and orderly travel through proper designed and maintained signage and
markings.
INTENDED OUTCOMES FROM BUDGET EXPENDITURES
The FYI 4 budget reflects the continuation of the pavement marring, overlay, chip seal, and sidewalk
replacement programs, which promote safe travel and longevity of the road system. Expenditures are
being proposed for street maintenance equipment replacement and purchase to increase reliability,
lower maintenance costs, and enhance cross -season functionality. The Traffic, Signs, and Signal budget
provides for operational upgrades to aging traffic light control units to ensure State compatibility and
the continuation of the compliance with sign reflectivity standards.
SPECIAL STREET MAINTENANCE
eucJD: zsoo-aziasozao
PROJECTED REVENUE AND FUND SUMMARY
ACTUAL
BUDGET
ACTUAL
BUDGET
FY 11I12
FY 12/13
FY 12/13
FY 13114
BEGINNING CASH
10100
CASH: Operating
$767,070
$856,958
$856,958
$855,121
10120
Cash, Transportation Impact Fees
$103,535
$0
$0
$0
10107
Cash, Designated Equip. Replacement
$155474
$36,799
$36,799
$71,799
10108
Cash, Designated S & C repair
$47,517
$47,517
$47,517
$38,328
10109
Cash, Designated Pavement Replacement
$170,753
$217,062
$217,062
$288,738
Total Cash
$1,104,349
$1,158,336
$1,158,336
$1,253,986
REVENUE
343010
Transportation impact fees
$36,918
$0
$0
$0
343012
Public Works Charges
$575
$17000
$4,563
$1,000
363010
Maintenance Assessments
$1,451,853
$1,420,000
$1,443,219
$1,428,500
-designated for pavement replacement
$2805000
$280,000
$280,000
$280,000
-designated for equipment replacement
$355000
$351)000
$35,000
$2001)000
363040
Penalty & Interest
$12,648
$12,500
$10,324
$121)500
364030
Sale of Misc./auction
$3,934
$1,200
$111,194
$1,200
371010
Investment
$9,315
$9,000
$6,862
$55000
381050
Inception of Loan
$170,793
$195,000
$174,698
$20000
Total Revenue
$2,001,036
$1,953,700
$1,965,860
$27128,200
Total Available
$3,105,3 85
$3,112,036
$3,124,196
$3,382,186
EXPENDITURES
Street Department/TSS
$15555,611
$1,814,270
$1,652,697
$1,853,688
Capital Equip. Replacement
$13,675
$0
$0
$49,925
S & C Repair funds
$0
$317,041
$9,189
$21,852
Refund Transportation Impact Fees
$144,072
$0
$0
$0
Pavement Replacement program
$233,691
$530,000
$208,324
$5%338
Total Expenditures
$11)947,049
$2,375,311
$11)870,210
$2,4941)203
ENDING CASH
10100
Cash, OPERATING
$856,958
$681,388
$855,121
$649,633
10107
Cash, Designated Equip. Replacement
$36,799
$717799
$71,799
$221,874
10108
Cash, Designated S & C repair
$47,517
$16,476
$38,328
$16,476
10109
Cash, Designated Pavement Replacement
$217,062
($32,938)
$288,738
$0
Total
$1,158,336
$736,725
$1,253,986
$887,983
19
SPECIAL STREET MAINTENANCE
FUND: 2500-421-430240
EXPENDITURE DETAIL
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
FY12/13
FY12/13
FY13/14
STREET DIVISION
Personal Services: FTE's
12.35
12.35
12.35
12.25
110
Salaries and payroll costs
$527,159
$570,667
$565,943
$602,099
112
Severance
$19,830
$25,000
$24,431
$0
121
Overtime
$4,160
$30,000
$7,734
$25,000
153
Health Insurance
$136,126
$157,384
$152,092
$145,978
155
Retirement
$34,049
$35,393
$36,385
$37,440
Subtotal
$721,324
$818,444
$786,585
$810,518
Materials and Services:
210
Computer Equipment/Software/Supplies
$3,519
$5,000
$4,182
$5,000
218
Equipment /safety equipment & supplies
$3,467
$10,200
$9,082
$6,000
220
Other supplies, Janitorial, consumable tools
$4,527
$4,100
$1,618
$4,100
231
Gas & Oil
$33,762
$42,000
$30,192
$42,000
341
Electric
$1,173
$1,400
$93 6
$1,400
345
Telephone
$1,092
$1,000
$1,475
$1,000
354
Contract Services
$12,131
$15,000
$7,534
$15,480
357
Rate Study
$3,066
$0
$0
$0
362
Equipment Maint. parts & supplies, includes radios
$30,588
$28,000
$16,125
$28,000
366
Building Maint.
$3,813
$4,000
$1,324
$3,000
373
Dues & Training
$3,081
$3,500
$3,596
$5,500
388
Medical services/drug test
$1,423
$1,100
$750
$1,100
510
Property & Liability Insurance
$78,797
$87,000
$81,010
$89,804
512
Uninsured Loss -deductible
$52
$10,000
$8,894
$10,000
521
Central Garage Transfer
$66,000
$70,000
$70,000
$171,740
522
Administrative Transfer
$64,707
$67,420
$67,420
$71,524
528
Information Tech. Transfer
$10,689
$12,182
$12,182
$14,899
Subtotal
$321,887
$361,902
$316,320
$470,547
610/620 Debt Service -Principal & Interest
$16,200
$46,119
$24,182
$96,459
720
Transportation Impact Fee Reimbursement
$144,072
$0
$0
$0
20
SPECIAL STREET MAINTENANCE
FUND: 2500-421-430240
EXPENDITURE DETAIL-con't.
Capital Outlay:
840
MAGI Grant Match
940
Machinery & Equipment
941
Dump Trucks - Inception of Loan
Subtotal
430244
354
Pavement Maintenance funds
430245
Replacement Funds:
940
Machinery & Equipment
Subtotal
430248
Sidewalk & Curb Repair funds
354
contract services (carryover)
Total
430264 TRAFFIC SIGN & SIGNALS
Personal Services:
110 Salaries
112 Salaries - Severance
121 Overtime
153 Health Insurance
155 Retirement
Subtotal
Maintenance & Operations:
210 Computer EquipmenUSoftware/supplies
218 Equipment /safety equipment & supplies
220 Other supplies, Janitorial, consumable tools
242 Street Signs
243 Traffic Signals
245 Barricade Materials
341 Electricity
345 Tele. & Communications
FTE's
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
FY12/13
FY12/13
FY13/14
$40,000
$75,000
$75,000
$0
$177,43 6
$195,000
$174,69 8
$0
$200,000
$217,436
$270,000
$249,698
$200,000
$233,691
$530,000
$208,324
$568,738
$13,675
$0
$0
$39,825
$13,675
$0
$0
$39,825
$0
$31,041
$9,189
$21,852
$196689285
$2,057,506
$1,594,298
$2,207,939
2.5
2.5
2.5
2.0
$128,3 81
$132,645
$131,751
$109,945
$0
$0
$0
$0
$8,483
$9,500
$9,234
$9,500
$17,413
$18,270
$19,447
$15,347
$8,486
$8,902
$8,703
$6,784
$162,763
$169,317
$169,135
$141,575
$385
$1,500
$1,956
$1,500
$9,052
$4,500
$5,500
$6,700
$3,386
$3,500
$4,409
$3,500
$35,590
$44,000
$37,257
$46,000
$13,593
$33,500
$22,919
$19,000
$4455
$4,700
$4,806
$4,500
$4,499
$8,500
$2,062
$5,500
$713
$750
$742
$750
21
SPECIAL STREET MAINTENANCE
FUND: 2500-421-430240; 430264
EXPENDITURE DETAIL -con't.
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
FY12/13
FY12/13
FY13/14
Maintenance & Operations: Cont.
354
Contract Services $18,602
$15,000
$1,522
$10,000
362
Equipment Maintenance Parts, includes radios $2,155
$3,000
$5,001
$3,000
366
Building Maintenance $4,920
$2,000
$704
$2,000
373
School & Travel $2,619
$4,000
$4,081
$5,500
428
Paint Materials $4,445
$9,000
$4,174
$5,000
510
Property & Liability Insurance $3,749
$4,200
$3,766
$3,170
512
Uninsured Loss -deductible property $0
$2,500
$40
$2,500
521
Central Garage Transfer
$8,131
532
Office Rent $7,838
$7,838
$7,838
$7,838
Subtotal $116,001
$148,488
$106,777
$134,589
430245
Replacement Funds:
940
Machinery & Equipment $0
$0
$0
$10,100
Subtotal $0
$0
$0
$10,100
Total $2789764
$317,805
$275,912
$286,264
Grand Total - Streets & TSS $1,9471049
$2,3759311
$1,8709210
$2,4949203
FY 2014 BUDGET HIGHLIGHTS
Line Item Detail: Street Division
218
Equipment - Non Capital - $3,0001 Safety Equipment & Supplies $3,000
$3,000 Truck Tarps
Capital Outlay: Financed 5 yr
941
Dump Trucks - $200,000
(2) Used 12 yard Dump Trucks. Replacing a 1988 dump truck and a 1991 dump truck. Trucks are utilized year round for
hauling asphalt and gravel, and for snow removal.
ASSESSMENT RATES
Current rates
vacant land .013442 90% non-residential .0209
residential .013442 100% commercial .0209
22
SPECIAL STREET MAINTENANCE
FUND: 2500-421-430240
FY 2014 BUDGET HIGHLIGHTS
430244 Capital Outlay: Pavement Replacement (10109)
354 Pavement Maintenance funds - $568,738 Carryover $288,738 New Appropriation $280,000
GASB 34 rules now require accounting for the value of public infrastructure so that adequate steps may be taken to ensure the
on going costs of operation, maintenance and replacement of these facilities may be adequately budgeted. The FY 2007/08
budget included a 10% rate increase that is reflected in this line item. The funds derived are reserved solely for pavement
maintenance and replacement of existing streets.
430245 Capital Outlay: Equipment Replacement (10107)
940 Machinery & Equipment - $39,825
$3,825 - Large Format Document Scanner & Plotter. Replaces current plotter that the electronic components
are starting to fail. The scanner would allow drawings of Public Works system improvements to be scanned into the network
server for rapid retrieval, will also reduce space needed for storage.
Cost shared between/Street, Sewer, Storm, Water, Light Maint, Solid Waste -Total Cost $25,500
$6,000 - Survey Grade Global Positioning System (GPS). Current GPS system is over 12 yrs old and is n❑
longer functioning. The GPS system will be used to support the new Asset Management System for Water, Sewer, Street, and Storm
systems, and to identify GPS location of City's 500 plus lights, and to support right of way and routing of Solid Waste services.
Cost shared between/Street, Sewer, Storm, Water, Light Maint, Solid Waste - Total Cost $40,000
$30,000 Sander Comb❑ Unit
The City is applying for a MAGI grant for two combo sander, deicer units to be installed on the two 12 yard dump trucks proposed
for purchase in this fund. There is a chance we will only get one unit through the MACI grant, so funds have been included in this
line item to purchase one sander comb❑ unit if we we fail to receive the MACI funding.
Line Item Retail: Traffic Signs & Signals
243 Traffic Signals - $19,000 (reduced $1.4,500)
$9,000 - Upgrade six of the 35+ year old conflict monitor units on the city owned signals so they are compatible
with the new State standard controller.
$10,000 -- Misc maintenance/repairs/replacement parts, etc.
430245 Capital Outlay: Equipment Replacement (1.0107)
940 Machinery & Equipment - $10,100
$10,100 - Heavy Duty Flatbed Trailer with Hydraulic Lift
W
MT. AIR & CONGESTION GRANT
FUND: 2825 ... STREET....421.... FCTNCTION....430240
PROJECTED REVENUE AND FUND SUMMARY
BEGINNING CASH
CASH: Operating
REVENUES
331055 MAGI Grant for Sweepers/Flush Trks
383012 Transfer from Street Maintenance (match)
FY 11112 Sweeper CARRYOVER
FY 12/13 -
FY 14 Combo Units/Sweeper - from Storm (match)
Total Revenue
TOTAL AVAILABLE
EXPENDITURES
940 CAPITAL EQUIPMENT -
ENDING CASH
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
FY12/13
FY12/13
FY13/14
$0
$40,000
$40,000
$83,736
$0
$40,000
$0
$0
$459,373
$0
$75,000
$0
$174,350
$0
$75,000
$0
$524,000
$0
$0
$42,264
$40,000
$534,373
$249,350
$566,264
$40,000
$574,373
$289,350
$650,000
$0
$574,373
$205,614
$650,000
CASH: Operating $40,000 $0 $83,736 $0
FY2014 BUDGET HIGHLIGHTS
The Montana Air and Congestion Initiative (MAGI) provides funds for equipment purchases which are utilized to benefit air quality in the State. The FY1204
budget reflects participating with the MACI grant program on the purchase of a street sweeper and two combination sanding/deicing units which would
provide increased efficiency in the respective operations. The Special Street fund includes full funding to purchase one combo sander deicer unit if only one
unit is approved in the grant request.
An appropriation of $75,000 was budgeted in FY 12/13 for a MACI grant request for a new Flush Truck with a 3,000 gallon tank and underbody plow, and
another new sweeper. There is a chance we will only receive one item, priority would be to replace our current 1995 flush truck which is very poor condition.
The FY 12113 grant request is expected to be awarded in late August of 2013.
Total FY 13 estimated cost of Flush Truck: $163,600; estimated cost of FY 13 Sweeper: $215,000.
Total FY 14 estimated cost of two Combo Sander, Deicer units is $56,400; estimated cost of the FY14 Sweeper: $215,000.
24