11. Internal Service Fundsi
i
i
i
i4i
1
i
I
�N%--TERNAL SERVICE FUNDS
Page Fund Dept
1-3 6010 Central Garage $ 492,563
4-6 6030 Information Technology $ 660,597
Total Internal Service Funds $ 1,153,160
r
CENTRAL GARAGE
ACCOUNT # 6010-410
PURPOSE OF THIS DEPARTMENT:
The Central Garage provides an internal customer service response for the proper maintenance and service
of the city's fleet of vehicles and equipment.
DEPARTMENT PERSONNEL: (3 FTE)
I Mechanic Supervisor
2 Mechanics
GOALS OF THIS DEPARTMENT:
1. Provide cost effective and efficient operation for fleet maintenance services.
INTENDED OUTCOMES FROM BUDGET EXPENDITURES
The FYI 8 Central Garage budget represent a plan to increase services for the internal repair and maintenance
operations of the municipal fleet. Mechanics continue to utilize scanning programs, and knowledge obtained
in training courses to perform internal services, preventive maintenance, and repairs.
CENTRAL GARAGE
FUND: 60 10 1
PROJECTED REVENUE AND FUND SUMMARY
BEGINNING CASH
10100 CASH: operating
Total Cash (beginning of year)
REVENUES
342050 Fees for Services
364030 Misc.
371010 Investment Earnings
Total Available
EXPENSES
Personal Services
M&O
Capital Outlay
Total Expense
ENDING CASH
Operating cash available
ACTUAL
BUDGET
ACTUAL
BUDGET
FY15/16
FY16/17
FY16/17
FY17/18
$25,197
$56,146
$56,146
$81,107
$25,197
$56,146
$56,146
$81)107
$464,491
$454
$288
$510,000
$0
$200
$510,000
$1,087
$741
$495,000
$0
$200
$490,430
$566,346
$567,974
$576,307
$196,118
$238,166
$0
$212,878
$264,942
$26,000
$207,581
$253,782
$25,504
$216,071
$266,492
$10,000
$434,284
1
$503,820
$486,867
$492,563
$56,146
$62,526
$81,107
$83,744
1
CENTRAL GARAGE
FUND: 6010-410-431330
EXPENSE DETAIL
Personal Services: FTE'S
110 Salaries and Payroll Costs
I -) I
Overtime
153 Health Insurance
155 Retirement
Subtotal
Maintenance & Operations:
2I0 Office Supplies, Computers & Software
229 Equipment (Non Capital);Safety Equip, other Supplies
230 Oil
231 Gas
232 Motor Vehicle Parts
233 Tires
238 Filters
241 Consumable Tools, Books
341 Electricity
344 Natural Gas
354 Contract Services -Repairs
362 Equipment Maint., Radios, Building Maint.
373 Dues & Training
388 Medical Services
510 Insurance
528 Information Tech. Transfer
Subtotal
Capital Outlay
921 4 Post Service Lift
944 Machinery & Equipment
Total
ACTUAL
FY15/16
BUDGET
FY16/17
ACTUAL
FY16/17
BUDGET
FY17/18
3
3
3
3
$150,416
$160,046
$155,927
$162,760
$ 1 fi34
$2,500
$2,288
$2,500
$33,336
$38,827
$38,047
$38,931
$10,732
$11,505
$11,319
$11,880
$196,118
$212,878
$207,581
$2 [6,071
$11488
$10,000
$8,406
$10,000
$12,310
$12,700
$9,694
$10,700
$14,947
$25,000
$17,323
$251)000
$2,525
$3,000
$612
$2,500
$112,940
$108,000
$124,154
$112,000
$37,978
$38,000
$40,780
$41,000
$8,080
$7,700
$8,191
$8,500
$601
$2,000
$2,062
$2,000
$1,656
$1,950
$1,593
$1,950
$3,241
$7,000
$4,238
$6,000
$16,076
$30,000
$21,010
$26,000
$1,827
$2,000
$370
$2,000
$3,511
$6,200
$5,298
$6,200
$100
$300
$423
$300
$2,511
$2,750
$1,286
$4,000
$8,375
$8,342
$8,342
$8,342
$238,166
$2641)942
$253,782
$266,492
$0
$26,000
$25,504
$0
$0
$0
$0
$10,000
$0
$26,000
$25,504
$10,000
$434,284
$503,820
$486,867
$492,563
F1~ ND: 6010-410-431330
FY 2018 BUDGET HIGHLIGHTS
Line ifem DetaH: CENTRAL GARAGE
210 Office/Computers & Software - $12,000
This line item covers costs to meet the computer replacement schedule, annual software needs, and includes funds W Upgrade cabling.
switches, and fiber for the network at the City shops.
232 Motor Vehicle Parts - $112,000
Reduced contract services $4,000 and increased motor vehicle parts $4,000 since we are doing more repairs in-house.
233 Tires - $41,000
Increase is due to an anticipated increase of 7% to 8% in tire costs in the next year and to meet replacement needs.
373 Dues & Training - $6,200
It is necessary to travel out of state for specialized training for the City's fire apparatus, large construction equipment, sweepers,
and vac -trucks.
Capital Outlay
944 Diagnostic Tool Kit - $10,000
This diagnostic tool scans for codes, clears codes, and bidirectional control of modules.
Includes troubleshooting, testing and repair information for our medium/heavy duty trucks.
In the last year we've incurred out of house costs to have codes cleared, towing to
problem, Kalispell, Spokane, and Missoula shops diagnostics and repairs. This tool will give
Mechanics tool to make the repair in-house and clear the code.
3
IN -FORMATION TECHNOLOGY
ACCOUNT # 6030
PURPOSE OF THIS DEPARTMENT:
Information technology provides technology systems to City staff for their respective provision of services
to the City of Kalispell. Additionally, the IT department provides a means to distribute public information
through IT services such as the City website, broadcast of public meetings, email and the electronic
document repository.
DEPARTMENT PERSONNEL: I Information Technology Director; I Information
Technology Support Specialist; .55 Media Specialist
GOALS OF THIS DEPARTMENT:
1. Maintain computer systems for the provision of municipal services.
2. Maintain external communication systems for the dissemination of information to the public.
INTENDED OUTCOMES FROM BUDGET EXPENDITURES:
The server environment will utilize technology to increase server availablity and reduce recovery
time during server failure.
Replace computers based on a 4 year replacement schedule. Repurpose the old computers for other
staff using new hard drives and a fresh operating system build. Deploy 65 computers, servers and
tablets from a combination of new and repurposed equipment.
Continue the effort to increase the newtork traffic connections between downtown City offices with
switch upgrades and reuse the existing newtork cabling.
INFORMATION TECHNOLOGY FUND
FUND: 6030-403-410580;410585
PROJECTED REVENUE AND FUND SUMMARY
BEGINNING CASH
10100 CASH: Operating
10120 Cash, Replacement account
REVENUES
393000 Charge for service -other Funds
335230 Entitlement general Fund share)
341027 Charter Franchise Fees moved from General)
371010 Interest
364030 Misc./ sale
Total Revenue
Total Available
EXPENSES
Information Technology
Equipment
Equipment from Replacement $
Depreciation/Replacement reserve
Total expenses
add back depreciation/other ppd
ENDING CASH
10100 CASH: Operating
10120 Cash, Replacement account
Total Cash
ACTUAL
BUDGET
ACTUAL
BUDGET
FY15/16
FY16/17
FY16/17
FY17/18
$
127,546
$
167,018
$
167,018
$
1731J339
$
14,112
$
4.1112
$
4,112
$
9,112
$
141,658
$
171,i30
$
17 1, 130
$
182,451
$
232,404
$
235,655
$
2355655
$
2357655
$
155,000
$
20500
$
205,000
$
205100
$
173,833
$
175,000
$
169,539
$
173,000
$
950
$
1,000
$
1,623
$
1,100
$
36
$
-
$
63
$
-
$
562,223
$
616,655
$
611,880
$
614,755
$
7037881
$
7875785
$
783,010
$
7971)206
$
438,114
$
517,039
$
464,594
$
526,368
$
79,637
$
145,824
$
1357965
$
12911,230
$
151)000
$
-
$
-
$
-
$
5,000
$
5,000
$
5,000
$
5,000
$
5371-751
$
667,862
$
6051)559
$
660,597
$
5,000
$
5,000
$
51000
$
9,300
$
167,018
$
115,810
$
173,339
$
127,497
$
4,112
$
9,112
$
9,112
$
141%112
$
171,130
$
1.24,923
$
182,451
$
141,609
C!
INFORMATION TECHNOLOGY FUND
FUND: 6030-403-410580;410585
EXPENSES DETAIL
401-410580
Personal Services: FTE's
110
Salaries & payroll costs
121
Overtime
153
Health
155
Retirement
Subtotal
403-410580
Maint. & operations:
215
Office Supplies, Ship & Recycle
218
Equipment -(non capital)
325
Website & Social Media
345
Telephones - Cellular
346
SumunitNet & Internet Service Providers
353
Laseffiche maintenance contract
354
Contracted Labor
355
Software & Licenses
356
Support/Maintenance Contracts
357
AV Capture All Meeting Streaming
358
Hosted Office 365 E-mail & Email Services
373
Train i ng/sch ool/i-nembersh i ps
510
Insurance
403-410583
218
TV -Video Equipment & programming
354
TV -Video Contract Services
403-410585
Copiers, Fax, Office machines, Phones
229
Supplies (leased equip. supplies, paper, etc.)
345
Phone - Centrex
532
Copier Leases (5)
Subtotal
ACTUAL
BUDGET
ACTUAL
BUDGET
FYI 5/16
FY16/17
FY16/17
FY17/18
$
$
$
$
2.55
159,647
138
40,879
12,312
$
$
$
2.55
167,379
15000
445317
12.,653
$
$
$
$
2.55
164,357
1,116
4411227
12,909
$
$
$
$
2.55
1711350
100
44,701
13)115
$
212,976
225,350
222,609
$
230,168
$
1,413
$
2400
$
972
$
2:400
$
181)624
$
18,963
$
17,660
$
24,000
$
21891
$
16,000
$
2,922
$
15,700
$
1,369
$
2500
$
2:5178
$
2,550
$
51332
8,468
$
10,3109
14,000
$
3432
35500
$
3,432
3,500
$
351798
$
8;P860
.1 01>342
500
$
14,706
$
21,110
18')452
$
18,850
$
1,860
$
47550
49,785
$
44,000
$
71800
$
6,690
$
7,400
500
$
6,853
$
21,235
$
6,396
20,622
$
3,518
$
800
$
4:370
$
8100
$
1,706
$
1,778
$
819
$
3,000
$ 12,465 $ 12N0 $ 2,280 $ 19,500
$ 11250 $ $ - $ -
$ 12,679 $ 19,552 $ 12,604 $ 19,490
75,961 $ 76100 $ 76,631 $ 7800
17,481 $ 16,182 155233 12,588
$ 225,138 $ 291,688 $ 241,985 $ 296,200
6
INFORMATION TECHNOLOGY FUND
FUND: 6030-403-410580;410585
EXPENSE DETAIL
ACTUAL
BUDGET
ACTUAL
BUDGET
FY15/16
FY16/17
FY16/17
FYI 7/18
405-410588 Equipment: DEPT.
940 Network Equipment Capital $
403-410585
942 Servers -capital $
4xx-410588
218 Police Dept. (413) $
354 Police - Hosted server (413)
218 Park's Dept, (436)
218 Public Works (410)
218 Attorneys (404)
218 Fire Department (416)
218 MGRIHR/Mayor/Clerk/F-inance-3 (401)
218 Community Economic & Development (480)
218 Planning & Zoning (420) $
Subtotal $
403-510400
831 Depreciation / Replacement reserve $
Total
$ 495200 $ 475440 $ 22,200
3611862 $ 23,500 $ 25422 $ 331)000
26,608
$
28,360
$
2%233
371)760
269
$
2,000
$
11)087
1,200
11)944
$
5,165
$
511034
4,885
27175
$
2,175
$
2,345
$
5,381
41251
$
4,964
33,553
$
4,100
9,389
$
16,752
91454
$
81)164
4,186
$
500
$
85
$
6,100
2,233
$
21155
$
-
25315
6,720
$
M-053
12,312
4,125
94,637
$
145,824
$
135,965
$
129,230
5,000
$
500
$
500
$
511000
537351 $ 6671)862 $ 605,559 $ 660)597
no