HomeMy WebLinkAboutAdmin Services 2006 Budget ADMINISTRATIVE SERVICES
Overview of
2006 Budget
Board Presentation 8-25-2005
".
-,GEM
What we ill be covering
• System Overview
• Organization Chart
• Administrative Services Expenditure Detail
• -Year Capital Plan
» Problems we' re having
• Overall Summary
District Data Chart 1
Electric Customers
13,000-
12,000
10,000 9,000
8,000
7,000-
Coatonneecount 6000 r
5,000-
4,000
3,000 1
2,000 1,000
w
0 I
1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005
Year
w
�d
d;
. f
District Data Chart 2
Water Customers
12,000-
11,000
10,000-
9.000 4' v
i
8,000
7,000
"i Guatpmer Count 6,000
5,000
1
a,000 � s
3,000
2,000
1,000
0
1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005
Year
d
a
District Data Chart 3
Electric Revenue
-.
$18,000,000
$17.0AL
00.000
$16,OOQ000 -�
$15,000,000
$14,000,000
$13,000,000 ___... ..._.
$11,000.000 t/ _.—_.. ._—._.... ........_
$10,000,000 -Y
Revenue $9,000,0o0
$8,000,000
$7,000,000
$6,000,000
$5,000,000
$4'000,000 -
$3,000,000 -
$2,000,000
$1,000,000
i
$0
1995 1996 1997 1998 1999 2000 2001 2002 2003 2004
Year
• 11/ 111
too I I
I I ill
t,t 111
lit FI1
Its 1,1
111 ,11
,1. 111
..,..
/11 It 11 it Ii�
4
i I
i
,
t 1 I g
i I i
i I N
1 m
I 1
� 1
I
I
1
� F
1
I
f
NORM
S S S S S S S S S S S S g S
O O O O O O O S O O O O S S O
S � Sog8gog6g6oggg
O S o 0
O to sO� h O N O 0 O
a
k
4
District Data Chart 6
District Employees
70
ss
65
60 _. _ 58 _.... .._ 58 _....
55
55
50
45 _.. ..... �.: __.._ __.. , .....
40 ... ....... _.... _.... __._
35
30 .____. ...... _._.. _
25 .... ----_ __. _i ...... ..... .....
20 -__.. _..._ ...... _. .......
15 .... !..... _...... .........
10
0
2001 2002 2003 2004 2005
Year
Admin Services Staffing
18 ...... _um _ wamm..wv.
17
16 ----. __--. _... -_--. __. __.._ .---_ --_-. 15
15 _---. ...... --___ _. 14 ----. ......... ---14.
14
13
12
11 _---.
;E rapt oy00 10
Gaunt
5 ........ -.___ ..._. __-_. ..-.-.. ........
3
p ........._._. ____. .... ..-. ....._ '..
0
2001 2002 2003 2004 2005
Year
Admin Services — Organization Chart
AdMin seniices
€ amager
ane `• AResourcetor CQUe ions ^ EE
Supervisor Coordinator
Network ; Humv1 Customer emces Metcr Manager
.. crJira .ftrr ..,
St=nior
AccountartU Customer Service'sF�cetc,�. kr�elysf Clork 3 ft�ade; (T
Accounting Wmk Cizder
siupervis03 Accounting
supc,,Msor
wori C CkGP'
speCfel➢ ? ( }
Yh
Administrative Services Expenditure
Detail — Electric & Water — page 1
Budget # Budget Budget
2005 2006
Meter Operations (586.001684.3) $40,307 $41,516
This account is utilized by the meter readers to charge their time for performing meter connects, disconnects and
service transfers. It is also used for investigating customer high bill complaints.
Customer Installation Operations (587,00) $33,371 $34,372
This account is used to charge G0165 inspections for the electric department as well as investigation of energy
diversion.
Maintenance of Distribution Lines (593.00) $ 7,881 $8,117
This account is used to charge labor and expenses relating to power outages. For the most part the office staff
charges their labor here when they are answering calls for power outages.
Customer Account Supervision (901.00) $17,325 $17,845
This account is used by me to charge the time I supervise the customer services group.
,
Administrative
nta
page 2
Budget # Budget Budget
2005 2006
Meter Reading Expense (902.00) $93,477 $96,281
This account is used to charge meter reading expenses which includes the meter reader labor and overheads, the
hardware and software that supports the meter readers; it also includes their clothing allowance, uniform expenses,
vehicle expenses and training.
Customer Records and Collections (903.00) $748,752 $771,215
This account includes the major expenses involved in serving our customers. Included are answering and directing phone
calls, answering customer questions, customer account setup expenses, taking and processing customer payments,
creating connect, disconnect and transfer paperwork for the crews, creating and reviewing bills, expenses relating to the
printing and mailing of the bills by NISC, account collections expenses, remittance and lockbox expenses, standby billing
expenses, billing software and hardware support , maintenance and upgrade expenses, billing equipment maintenance
expenses, printed billing and collection forms, billing postage and billing and customer service staff training.
Provision for Bad Debts (904.00) $ 17,000 $17,510
This account represents the amount of bad debts that we have during a year. We estimate the amount monthly (.0015
times the amount billed for the month) and we adjust it annually after the actual bad debts have been determined for the
yea r.
Administrative
i it
page 3
Budget # Budget Budget
2005 2006
Admin & General Expense (920A0) $596,592 $614,490
This account includes most of the labor for the department except meter reading and customer account related
expenses. It includes almost all of my time, banking related expenses, all accounting done in the department including
all budget related work, accounts payable, payroll, construction accounting, opening the mail, human resources, and
insurance related labor.
Office Supplies and Expenses (921.00) $285,850 $294,425
This account includes all of the expenses that we pay related to the administration and general expense labor. It
includes bank charges, answering service charges, phone charges, computer and network operating expenses,
software maintenance and support expenses related to our IVUE system, general postage expenses, personnel related
expenses, printed forms and material, office equipment leases and equipment maintenance expenses.
Outside Services Employed (923.00) $ 95,000 $97,850
This account gets charged with any professional services hired from the outside such as audit or accounting
services, trust services for our certificates of participation and community facilities districts and arbitrage calculation
services for the same.
p 'V
Administrative Services Detail
page 4
Budget # Budget Budget
2005 2006
Insurance Expense (924.00) $416,509 $429,004
This account is charged with the annual insurance premiums including property & liability, umbrella liability, directors &
officers, difference in conditions, boiler & machinery. The expense is reduced slightly by the amount associated with
insuring the District's vehicle fleet and inventory. These costs are included in the vehicle & warehouse inventory
overheads.
Injuries and Damages (Safety) (925.00) $ 16,789 $17,293
This account is charged with costs associated with safety training, Department of Transportation Drug & Alcohol training,
worker's compensation expenses for department employees who have been injured and safety related equipment.
Total 2005 2006
$21368,853 $2,4397919
a
w �
5,.Year Capital Plan
2006 2007 2008 2009 2010
• Misc Office Equipment $10,000 $10,300 $10,609 $10,927 $11,255
• Personal Computers/
Servers/Hardware 30,000 30,900 150,000 32,782 33,765
+ Phone System 70,000 3,500 3,605 3,713 3,825
• New Meter Reader Vehicle 23,000 - - -
s Replace Postage Machine 5,000 -
Upgrade Meter Reading
Handheld Devices - 10,000 - - -
Total $138,000 $54,700 $164,214 $47,422 $48,845
v
I{ ^
d 5
Problems
�► New development-streamline process; prevent hiring
ore staff which will cost developers more
+r Improve outsourced after hours customer call handling-
better customer communications during outages
�► Broken & non-registering meters-increase resources,
increase water revenue
Upgrade internal telecommunications system-improve
efficiency and system reliability
Full time network manager—increase efficiency, quicker
response to network and personal computer problems
. Staffing-increased cost of housing is making it very
difficult to attract qualified applicants; losing good
employees; many employees moving out of Truckee
Q
overall Summary
.► Growth trends
• Impact of growth, permeates everything we do
.► Reviewed department activity and budget numbers 2005 & rough
estimate for 2006
Reviewed the department's 5 year capital budget
«► Need to address problems:
1 ) Streamline work order billings to developers and
customers
2) Need to improve outsourced after hours answering service
3) Need to fix water meter problems
4) Need to upgrade our phone equipment
5) Need for full time network manager
6) Need to address our ability to hire and retain well qualified staff
High Level Sum, mart' of Department Responsibilities:
Custoi ner :Service
Meter ReadMg
Billing
Remittance Processing
Collections
New Construcflon,-Residentia� Services
New Construction-Multi Ser,.Jce/Clornmercial Sewices
'VIVork Order Accounting
r-";xed Asset Tracking
Standby Billie gs
Budgeting
Genera� Ledg-ar Accounting
Cash Management
Accounts Payable
FlaVroll!
Lean Managernen,
Assessment District Management
CFD Annual Assessr'nent Manaaernent
insurance
Human Resources
Manage cuswa er se;vice portion of power & water outages
Network Managlement
Electric Customers
1995 9,517 #
1996 9,828
1997 10,129
1998 10,190
1999 10,534
2000 10,827
z
2001 11,441
2002 11,697
2003 12,083
2004 12,211 28%increase from 1995
2005 12,430
Water Customers
1995 6,550
1996 6,793
1997 6,990
1998 7,223
1999 7,516
2000 7,679
2001 9,325
2002 10,896
2003 11,205
2004 11,503 75% increase from 1995
2005 11,738
Electric Revenue
1995 8,876,478
1996 9,318,737
1997 9,382,641
1998 9,060,192
1999 9,357,297
2000 9,717,384
2001 11,058,027
2002 14,744,827
2003 16,271,880
2004 17,824,288 100%increase from 1995
Water Revenue
1995 3581,566
1996 3,961,252
1997 3,917,393
1998 4,002,116
1999 4,064,373
2000 4,578,962
2001 5,047,758
2002 6,358,639
2003 7,284,704
2004 8,031,714 124% increase from 1995
Debt
1995 13,950,918
1996 19,281,262
1997 16,987,976
1998 17,588,864
1999 18,262,641
2000 17,814,568
2001 23,244,740
2002 29,516,528
2003 66,079,731
2004 78,393,703 461%increase from 1995
2 %
OLAD
Debt Debt Debt Debt Debt
i
1995 13950918 01996 95�:915
2_
1997 16,987.915 0 0 y 16 937,s975
i998 17.588,864 6 G _ 9 17,588,864
999 8.26 ,641 0 0 y 18,262,641
2960 '.814,568 n 0 9 17�814,563
2 u1 "6 G G 6,080,000 0 � 23,244,749
26 2 1t3,6S5.52 1 t} n 9,721,000 4 29,516,528
1,E*55,5j4 9,955,000 2�'i,7 J.r`.a 56.f7i9,7'„'i
260" +I,SbE' u58 i,57I,710d 8,929,961 7i.3£76,906 78,396,703