12. Internal Service FundsINTERNAL SERVICE FUNDS
Page Fund Dept
1-3 6010 Central Garage $ 4541790
4-6 6030 Information Technology $ 5265969
Total Internal Service Funds $ 9811)759
� CENTRAL GARAGE
ACCOUNT # 6010-410
PURPOSE OF THIS DEPARTMENT: Why does this department exist?
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)
1 Mechanic Supervisor
2 Mechanics
GOALS OF THIS DEPARTMENT: What are the departmental goals that support the purpose?
1. Provide cost effective and efficient operation for fleet maintenance services.
INTENDED OUTCOMES FROM BUDGET EXPENDITURES
The FY2014 Central Garage budget represent a plan to continue the internal repair and maintenance
operation of the municipal fleet. Additional expenditures are being proposed in the Capital Plan to provide
needed maintenance of the facility to improve parts storage and sanitation conditions. This year's budget
also provides for the transition of this operation to an internal service fund in order to appropriately allocate
and track expenditures across departments.
CENTRAL GARAGE
FUND: 60I0
PROJECTED REVENUE AND FUND SUMMARY
Internal Service
BUDGET
FY13/14
BEGINNING CASH
10100 CASH: operating $0
Total Cash (beginning of year) $0
nUwL7U%TTTUQ
342050 Fees for Services $454,790
Total Available $454.790
EXPENSES
Personal Services $191,040
M & O $225,750
Capital Outlay $387000
Total Expense $454,790
U W"'FMI" r A Q u
Operating cash available $0
1
CENTRAL GARAGE
FUND: 6010-410-431330
EXPENDITURE DETAIL
Personal Services: FTE'S
110 Salaries and payroll costs
112 Severance
121 Overtime
153 Health Insurance
155 Retirement
Subtotal
Maintenance & Operations:
210 Office supplies, computer supplies
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
Subtotal
Capital Outlay
920 Building Remodel
Total
General Fund
BUDGET
1...__..FY12/13
General Fund
ACTUAL
FY 12/13
Internal Service
BUDGET
FY 1.3114
3
3
3
$1521)379
$1461378
$151,850
$0
$0
$0
$2,000
$2,353
$2,000
$31,516
$305130
$27,840
$9,348
$9,167
$9,350
$1951243
$188,027
$191,040
$1,200
$783
$ I ,200
$10,603
$9,793
$9,500
$156,500
$166,696
$27,000
$0
$0
$3,000
$93,000
$78,889
$91,000
$32,075
$32,551
$351000
$6,700
$7,472
$71700
$1,500
$1,579
$2,000
$1,700
$1,740
$1,900
$75400
$6,946
$75400
$35,000
$221568
$31,000
$2,550
$1,905
$21,000
$1,200
$143248
$2,700.
$275
$275
$350
$0
$0
$4,000
$349,703
$332,445
$225,750
$0
$0
$38,000
$0
$0
$38,000
$544,946 $5205472 $454,790
2
CENTRAL GARAGE
FUND: 6010-410-431330
FY 2014 BUDGET HIGHLIGHTS
Line Item Detail: CENTRAL GARAGE
229 Equipment (Non Capital), Safety Equip., Other Supplies - $9,500 (reduced $1,100)
$4,300 - Diagnostic Scan Tool for Auto/lLight Truck $1,000 - Flammable Storage Cabinets
$1,350 - Dump Bed Safety Stands
233 Tires - $35,000
Increased tires $2,925 to reflect actual costs.
373 Dues & Training - $2,700
$1,500 increase for ASE certification for two mechanics and Supervisor training for one mechanic.
920 Building Remodel - $38,000
Remodel restroom and current office/storage area into a two floor facility, utilizing the same square footage of area for a parts room with
sufficient shelving which allows for better control and organization of parts inventory. This is a high priority item, the current restroom facilit}
is unsuitable for use and the storage area is inadequate.
2014 BUDGET CONSTRAINTS - UNFUNDED Capital Outlay:
Vehicles - $40,000 UNFUNDED
Used Service Truck w/Crane - Replacing a 1987 service truck with no crane. Shop currently has no lifting capabilities, using a
backhoe with chains as a crane.
3
INFORMATION TECHNOLOGY
ACCOUNT # 6030
PURPOSE OF THIS DEPARTMENT: why does this department exist?
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: one Information Technology Director; one part-time Information
Technology Support Specialist; .55 Media Specialist; 0.1 City Clerk
GOALS OF THIS DEPARTMENT: what are the departmental goals that support the purpose?
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 department's 2014 budget contains computer and server replacements for staff on a four year
replacement schedule.
The FY 14 budget provides for a backup solution to permit the IT staff to facilitate quicker backup
and restore processes, thereby granting staff greater response time to the data needed to provide City
services if an issue is encountered.
This years budget also provides for improvements in the Audio Video system by providing for a
dedicated air conditioner in the equipment room, which is subject to high temperatures and
equipment damage.
INFORMATION TECHNOLOGY FUND
FUND: 6030-403-410580;4 t 0585
PROJECTED REVENUE AND FUND SUMMARY
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
FY12/13
I FY12/13
FY13/14
BEGINNING CASH
10100
CASH: Operating
$
751221
$
57,868
$
57,868
$ 521)527
10120
Cash, Replacement account
$
28,587
$
33,587
$
331587
$ 381)587
$
103,808
$
911)455
$
91,455
$ 911114
REVENUES
393000
Charge for service -other Funds
$
148,461
$
189,340
$
159,361
$ 191,174
335230
Entitlement (General Fund share)
$
174,937
$
85,000
$
851000
$ 1751)000
341021
Grant Administration
$
5,715
$
-
$
-
$ -
341027
Bresnan/Optimun Franchise Fees (moved from General)
$
157,000
$
176,562
$ 165,000
371010
Interest
$
11)428
$
1,200
$
11440
$ 15,200
364030
Misc./ sale
$
138
$
100
$
235
$ 250
14130
Prepaid maint.l Comp. Abs.
$
-
Total Revenue
$
330,679
$
432,640
$
4221598
$ 532,624
Total Available
$
4345487
$
524,095
$
514,053
$ 6231>738
EXPENDITURES
Data Processing
$
291,729
$
413,853
$
382,974
$ 451,679
Equipment
$
51,303
$
45,580
$
39,965
$ 70,290
Equipment from Replacement $
Depreciation/Replacement reserve
$
51)000
$
51)000
$
5,000
$ 5,000
Total expenses
$
3481)032
$
4641P433
$
4271939
$ 526,969
add back depreciation cash
$
5,000
$
5,000
$
5,000
$ 5,000
ENDING CASH
10100
CASH: Operating
$
57,868
$
26,075
$
52,527
$ 58,182
10120
Cash, Replacement account
$
33,587
$
38,587
$
38,587
$ 431)587
Total Cash
$
91,455
$
64,662
$
91,114
$ 101,769
4
INFORMATION TECHNOLOGY FUND
FUND: 6030-403-410580;410585
EXPENDITURE DETAIL
401
Computer & TV Media Specialist
410580
Personal Services: FTE's
110
Salaries & payroll costs
121
Overtime, Call Outs
153
Health
155
Retirement
Subtotal
403
Maint. & operations:
215
Computer, Office Supplies, Ship & Recycle
218
Equipment -(non capital)
325
Website hosting & Gateway fees
345
Telephones - Cell, Pager, Aircard
346
SummitNet & State of MT ISP
353
LaserFiche maint. contract & licensing
354
Maintenance - contracts & warranties
355
Software & Licenses
357
Granicus streaming
356
A.DG- Electronic Timesheet
358
Hosted Exchange E-mail & Email Services
373
Training/school/memberships
510
Insurance
410583-218
TV -Video Equipment & programming
410583-354
TV -Video Contract Services
410585
Copiers, Fax, office machines, phones
229
Supplies (leased equip. supplies, paper, etc.)
532
Copier Rentals (8)
345
Phone -leased lines (moved from General)
Subtotal
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
FY12/13
FY12/13
FY13/14
$
$
$
$
1.55
911147
104
14,529
5,959
$
$
$
$
2.28
140,220
5,000
26,988
%086
$
$
$
$
2.28
1391002
-
28,174
9,151
$
$
$
$
2.28
143,483
5,000
27,962
%423
$
1111739
$
181,294
$
176,327
$
185,869
$
2,952
$
3,230
$
1,374
$
2,370
$
9,963
$
13,973
$
13,113
$
15,550
$
3,176
$
14)450
$
25415
$
25200
$
-
$
-
$
11139
$
2,600
$
31)429
$
7,520
$
7,854
$
6,400
$
1,558
$
3,234
$
3,574
$
31P300
$
415425
$
2,400
$
1,331
$
371)420
$
29,467
$
4502
$
47,596
$
54,350
$
5,940
$
600
$
6,000
$
600
$
11,905
$
30,300
$
14,415
$
9,530
$
31,922
$
6,000
$
15113
$
5,100
$
1,163
$
1,350
$
2,648
$
3,300
$
-
$
2,000
$
17998
$
7,500
$
-
$
2,500
$
21)430
$
2,500
$
3,563
$
500
$
3,306
$
12,690
$
321P407
$
32,000
$
31,992
$
25,000
$
66,120
$
70,000
$
64,349
$
70,000
$
179,990
$
232,559
$
206,647
$
265,810
INFORMATION TECHNOLOGY FUND
FUND: 6030-403-410580;410585
EXPENDITURE DETAIL
410588
Equipment: DEPT.
940
Network Equipment Capital/switches
410585-942
Servers -capital
218
Network Fiber installation & equipment
218
Police Dept. (413)
218
Park's Dept. (436)
218
Public Works (410)
218
Attorneys (406)
218
Fire Department (416)
218
MGR -OIHR -0 (401) Mayor -O/Clerk - 1
218
Planning & Zoning (420)
Subtotal
510400
831 Depreciation 1 Replacement reserve
Total
ACTUAL
BUDGET
ACTUAL
BUDGET
FY11/12
IFY12/13
FY12/13
I FY13/14
$ 5,767
$
-
$
-
$
7,800
$ 9,642
$
BOO
$
8,599
$
235000
$ 4,334
$
-
$
-
$
-
$ 10,234
$
6,400
$
6,228
$
20,280
$ 4,122
$
4,500
$
4,150
$
4,500
$ 4,510
$
4,500
$
4,222
$
3,490
$ 3,265
$
31)640
$
3,688
$
21P200
$ 3,998
$
300
$
35083
$
41)880
$ 3,570
$
1,500
$
1,419
$
25200
$ 1,861
$
4,040
$
81576
$
1,940
$ 51,303
$
45,580
$
39,965
$
70,290
$ 51P000
$
51)000
$
5,000
$
5,000
$ 348,032
$
464,433
$
427,939
$
526,969
11