ORDER NO. 29945 2007 KERR EMERGENCY 911 NETWORK BUDGET Came to be heard this the 25th day of September, 2006, with a motion made by Commissioner Nicholson, seconded by Commissioner Letz. The Court unanimously approved by vote of 4-0-0 to: Approve the 2007 Kerr Emergency 911 Network Budget as submitted. (~ a COMMISSIONERS' COURT AGENDA REOUEST a~ / / 5 PLEASE FURNISH ONE ORIGINAL AND TEN COPIES OF THIS REQUEST AND DOCUMENTS TO BE REVIEWED BY THE COURT. MADE BY: William E. Amerine MEETING DATE: 25 September 2006 OFFICE: Kerr Emergency 911 Network TIME PREFERRED: 9:15 a.m. SUBJECT: 2007 Kerr Emergency 911 Network Budget Presentation/Approval EXECUTNE SESSION REQUESTED: (PLEASE STATE REASON) No NAME OF PERSON ADDRESSING THE COURT: William E. Amerine, Executive Director Ken Emergency 911 Network ESTIMATED LENGTH OF PRESENTATION: 15 Minutes IF PERSONNEL MATTER -NAME OF EMPLOYEE: N/A Time for submitting this request for Court to assure that the matter is posted in accordance with Title 5, Chapter 551 and 552, Government Code, is as follows: Meeting scheduled for Mondays: THIS REQUEST RECENED BY: THIS REQUEST RECEIVED ON: 5:00 P.M. previous Tuesday. All Agenda Requests will be screened by the County Judge's Office to determine if adequate information has been prepared for the Court's formal consideration and action at time of Court Meetings. Your cooperation will be appreciated and contribute towards your request being addressed at the earliest opportunity. See Agenda Request Rules Adopted by Commissioners' Court. Subject: Proposed 2007 Budget August 31, 2006 1. Net Income 2007: $339,783.00 based on an overall decrease of 6.7% over 2006's income. The decrease in revenue can be attributed to our proposed 9-1-1 surchazge reduction (6 to 5.25%) and a reduction in traditional wireline telephone customers. 2. 200 Payroll expenses a. 210: Salaries. Salaries received COLA increases averaging 2.57% in the 2007 budget. The office manager and GIS/address coordinator will receive salary increases. Executive Director has opted to receive an additional week of paid vacation instead of a COLA increase to his salary. Overall this line item decreased from $110,800.00 budgeted in 2006 to ._ $97,300.00 proposed in 2007. The GIS/address coordinator is only funded for the first six months of 2007. This is the largest contributing factor in this decrease. b. 211: Overtime Wages. Decreased from $1,410.00 budgeted in 2006 to $1,000.00 (translates to less than 60 overtime hours) proposed in 2007. Based 2006 work- load experience and 2007 work-load projections, the amount proposed will be sufficient to cover 2007 overtime contingencies. c. 212: Payroll Taxes: A small decrease reflected in the 2007 budget based on the overall salary overhead mentioned above. d. 213: Medical Insurance Expenses: Overall decrease in this line item: Two and one half FTEs vs. three FTEs. A twenty percent increase in medical insurance premiums is factored into the 2007 figures. e. 214: TCDRS Expense Company (Retirement Plan/Benefit): A small decrease reflected in the 2007 budget based on staff change mentioned above. 215: TCDRS OTLI (Optional Term Life Insurance Benefit): This is an optional term life insurance benefit for all employees. The amount is the total expense for all employees for 2007. g. 220: Contract Labor: A small decrease from $1,150.00 budgeted in 2006 to °"' $920.00 (translates into 80 contract labor hours) proposed in 2007. h. 225: Texas Workforce Commission (Unemployment Insurance). Decreased to reflect actual costs from past budgets. i. 230: Excess vacation payout. Line item allows for excess vacation payout at the end of 2007 if and only if the district's workload prevents employees from using their allotted vacation time. This is a contingency item. District policy will typically manage vacation so that it is used and not banked year-to-yeaz. 3. 300 Operations (PSAP) a. 310: PSAP Floor Space Lease. This line item was called "Communications Ops" and was based on a standing contract between the City of Kerrville and Kerr 9-1- 1. This contract was renegotiated in 2006 to cover floor space lease and utility reimbursement only (Item decreased from $18,000.00 in 2006 to $6,000.00 in 2007.) b. 315: 9-1-1 Call Taker Training: New line item for 2007. This line item allocates $9,000.00 for all associated 9-1-1 call taker training. Dispatcher training will be funded as requested and required to certify new dispatchers. c. 320: Wireless Phase I. We have not implement Phase One in 2006 as planned. Therefore this line item is carried over from 2006. Expected provider charges from Sprint, Nextel, Verizon, Cellular One and Five Star Wireless. All five «~-- carriers use a different cost recovery methodology for determining this charge. Pending significant technology advances and until which time the FCC & CSEC change funding methods for this service, Kerr 9-1-1 can expect to have this annual overhead each yeaz beyond 2007. d. 325: Wueless Phase I Trunks. New line item for 2007. This expense was unbundled from line item 320 to better show provider cost recovery expenses versus Phase I circuit expenses. e. 330: Wireless Phase II. We have not implement Phase Two in 2006 as planned. Therefore this line item is carried over from 2006. Administratively moved from 2005 budget line item 380: Intrudo -Phase II Wireless. All current wireless carrier one-time non-recurring Phase II fees have already been paid. This fee covers a phase II service contract with Intrado. This amount includes a monthly reoccurring fee of $1,000.00. f. 340: Windstream DB/MSAG Tariff. Valor/Windstream did not implement this tariff in 2006 as expected however they have filed and received approval for this tariff from the PUC. This tariff will cover the DB/MSAG validation service Valor/Windstream performs on their data prior to sending it to our local PSAP database. The monthly recurring fee is based on a 6.6 cent charge per active "9-1-1 capable" phone line. g. 350: PSAP Trunk Charges. This line item was called "Service Provider Chazges" in previous budgets. The line item name change better reflects what these expenses are. Decreased to better reflect actual costs from past budgets. This line item addresses all telephony cost associated with the 9-1-1 PSAP operation. h. 355: Language Line. Based on per-use-charges. No change in proposed 2007 budget. i. 360: Pager Service. This line items covers the expense for 2 administrative 24x7x365 PSAP support pagers used by Ken 9-1-1 staff members. 370: PSAP Repairs & Maintenance. No change. Most, if not all, PSAP repairs will be covered under the warrantees associated with our new PSAP equipment. 4. 400 Direct Services a. 410: Office Supplies: Based on usage trends this line item has been decreased by $2,000.00 for 2007. b. 412: Office Equipment and Repairs: No change. c. 420: Liability Insurance: Based on actual premiums paid in 2006 this line item has decreased by $1,000.00 in 2007. d. 430: Professional Development: A decrease from $1,500.00 to $1,000.00 in 2007. Forecasted usage; System Administrator training for 1 staff member, ENP training, and book-keeping refreshers for office manager. e. 440: Rent: Three percent increase forecasted. f. 450: Professional Fees: A small decrease for 2007. Items included in this line- item are legal, audit, accounting & CPA fees. g. 460: Postage & Delivery: Based on usage trends this line item has been decreased by $250.00 for 2007. h. 470: Mileage Reimbursement: Was "Vehicle Expenses" in previous budgets. This line item is used to reimburse employees for mileage when they use their private vehicles for Kerr 9-1-1 business. i. 490: Bank Service Charges: No Change. 5. 500 Miscellaneous a. 510: Awards & Honorariums. No change. b. 520: Dues & Subscriptions. Slight increase in 2007. c. 530: Public Education & Advertising: Slight decrease in 2007. d. 550: Telecommunications: No change. Costs associated with KPD, SO, Kerr County, DPS and Kerr 9-1-1 administrative telephony services. e. 560: Sundry: No change. f. 570: Texas 9-1-1 Alliance Meetings: A slight increase in 2007. 6. 600: Discretionary Communications: a. 610: VFD Pager Services. No change. b. 620: VF'D Radio Repeater Services. No Change. 7, 700: PSAP Equipment Replacement: «- a. 710: Monthly operating funds transfers to capital funds account. Intent: Build cash reserves for PSAP equipment upgrade in 2011. Capital Considerations: The capital cash account will have a balance in excess of $195,000.00 at the end of 2006 from nominal interest, scheduled PSAP Equipment Replacement transfers and excess operating fund transfers. Final PSAP upgrade costs came in 2.8% under budget. Additionally this package includes a 2007 capital budget for your review and approval. This budget includes all income and expenses associated with this account. The primary source of revenue is from "planned" operating funds transfers, 9-1-1 sign sales cost-recovery, and surplus equipment disposal. 9-1-1 Emergency Service Fee: The Texas Health and Safety Code -Chapter 772.314 (d): The board shall set the amount of the fee each year as part of the amzual budget. For the 2007 budget, Kerr 9-1-1 has propose a reduction of current 9-1-1 Emergency Service Fee to 5.25% of the basic rate for phone service. This 9-1-1 surcharge change reduces Kerr 9-1-1 rate-payer's tax liability by 12.5% or $26,754.71. This reduction is required by the Texas Health and Safety Code 772.314 (e): In imposing the fee, the board shall attempt to match the district's revenue to its operating expenditures and to provide reasonable reserves for contingencies and for the purchase and installation of 9-I-1 emergency service equipment. If the revenue generated by the fee exceeds the amount of money needed to fund the district, the board by resolution shall reduce the rate of the fee to an amount adequate to fund the district or suspend the imposition of the fee. Accomplishments in 2006: 1. PSAP Upgrade (all CPE, UPS, telephony equipment and software). Total cost to 9-1-1 public funds $192,231.62. -° 2. Established interlocal agreements with all service jurisdictions for the maintenance of the physical addressing system. 3. Accomplished all perquisite tasks necessary to initiate PHASE I & II Enhanced Wireless 9-1-1 Service. 4. Accomplished all perquisite tasks necessary to provide basic 9-1-1 capability to non- traditional telephony users (Vo1P telephone service). 5. Continued efforts to cut costs and save funds toward capital improvements for the 9-1-1 Network. Vision for 2007: i. Complete Ken 9-1-1 MSAG, landline and wireless ESNs for PSAP and distribute MSAG to LECs. 2. Complete Wireless Phase I Rc II Upgrades. 3. Enhanced current Mapped ALI capability. 4. Enhance 9-1-1 WEB Site Convent. 5. Continued 9-1-1 sign sales. 6. Enhanced 9-1-1 public education. Conclusions & Recommendations: The 2007 proposal is anon-deficit balanced budget that reduces citizens' 9-1-1 surcharge (TA7~ rate by 12.5%. 2. This budget more than adequately addresses the expected operating needs of our district and allows for all cost as we progress towards phase I & II wireless compliance. 3. Our district's vision and public-funds stewardship is based firmly in the state and local government codes, guided by conservative spending and liberal savings policies. 4. Approve budget as proposed. Respectfully submitted by, ~,~,L ~-e~v_2/~,~~~e- Bill Amerine Executive Director, Kerr Emergency 9-1-1 Network Kerr Emergency 911 Network 2007 Opr. Budget -Proposed 100- 101-Local811 Service 225,700.00 230,038.49 187,283.00 (42755.49) -18.59% 135,455.00 138, 052.77 140,000.00 1947.23 1.41 0.00 0.00 1,000.00 3,845.00 3,918.82 11,500.00 7581.18 193.48°k 0.00 0.00 0.00 0.00 365,000.00 372,010.08 339,783.00 (32227.08) -8.66% 0.00 365,000.00 372,010.08 339,783.00 (32227.08) -8.66% Total 100 • Revenue 200 • Payroll Expense 105-Wireless Emergency Income 110 - VoIP Service Fees 120-Interest Income 130 -Misc. Revenue 140 -Reimbursements 0812005 District Vehicle Sale 1012005 Surplus Properly Sale 210 • Salary 211 •OverOme Wages 212 • Payroll Taxes 213 • Medical Insurance Expense 214 •TCDRS Expense Company 215 -TCDRS ORI 220 • Contract Labor 225 • Texas Workforce Commission 230 -Excess Vacation Payout 235 -Prorated Hourly Salary Increase Total 200 • Payroll Expense 300 •Operetions (PSAP) 310 •PSAP Floor Space Lease 315 - 911 Calt Taker Training 320 -Wireless Phase I 131,800.00 110,800.00 (13500.00) -12.18% 2,080.00 1,410.00 (410.00) -29.08°~ 10,600.00 8,747.00 (1065.74) -12.18°!° 19,650.72 15,421.32 (1285.14) -8.33°h 9,226.00 7,707.35 (896.35) -11.63°~ 197.70 296.55 (111.68) -37.66% 1,760.00 1,150.00 (230.00) -20.00°k 500.00 500.00 (150.00) -30.00% 1,082.00 500.00 0.00 0.00% 0.00 176,896.42 146,532.21 (17648.91) -12.04% 36,000.00 18,000.00 (12000.00) -66.67% 0.00 0.00 54,000.00 0.00 0.00% 8/31/2006 Tota1300 • Operations (PSAP) 400 • Direct Services Total 400 • Direct Services 500 • Miscellaneous Tota1500 • Miscellaneous 600 -Discretionary Communications Kerr Emergency 911 Network 2007 Opr. Budget -Proposed 325 -Wireless Phase 1 Trunks 330 -Wireless Phase II - Intredo 340 - Windstream DBlMSAG Tariff 350 - PSAP Truck Charges 355 • Language Line 360 -Pager Service 370 • PSAP Repairs 8 Maintenance 410.OfOce Supplies 412.Office Equipment & Repairs 420 • Liability Insurance 430 • Professional Development 440 • Rent 460 • Professional Fees 460 • Postage & Delivery 470 • Mileage Reimbursement 480 • Bank Service Charges 510 • Awards & Honorariums 520 • Dues & Subscrfptions 530 • Public Education & Advertising 550 • Telecommunications 560•Sundry 570 -Texas 911 Alliance Meetings 610 • VFD Pager Service 620 • VPD Radio Repeater Service 8/31l2n~6 1 0.00 12,400.00 0.00 28,800.00 500.00 32.00 81,732.00 2,500.00 2,500.00 4,000.00 3,000.00 15,000.00 9,000.00 500.00 500.00 40.00 37,040.00 100.00 400.00 1,500.00 10,000.00 2,500.00 1,200.00 15,7D0.00 3,500.00 24,000.00 12,000.00 28,800.00 500.00 32.00 1,000.00 138,332.00 3,000.00 1,500.00 4,000.00 1,500.00 17,304.00 10,000.flO 750.00 0.00 38,094.00 100.00 40000 3,830.00 1,000.00 1,500.00 16,830.00 (12000.00) -50.00% 5700.00 47.50% (4800.00) -16.67% 0.00 0.00% 292.00 912.50°~ 0.00 0.00% (9808.D0) -7.09% (2000.00) X6.67% 0.00 0.00% (1000.OOJ -25.00° (500.00) -33.33° 781.00 4.51% (1000.00) -10.00% (250.00) -33.33% 500.00 0.00 0.00% (3469.00) -9.11 % 0.00 0.00% 100.00 25.00°~ (1830.00) -47.78°h 0.00 0.00% 0.00 0.00% 440.00 29.33% (1290.00) -7.86% Kerr Emergency 91~~ o~se o.~ o.oo°b 2007 OPr• gadget' `~ 8131120 E Capital Expenses - 800 Total Capital Expense - 800 Capital Income - 900 Total Capital Income -900 Kart Emergency 911 Network 2007 Cap. Budget Worksheet Proposed 801 - NRC's for Phase One Wireless 803 -Office Computer Upgrade 804 -Sign Materials 901 -Sign Sales (Recovery) 902 -Equipment Replacement Fund Trensf®rs 903 -Surplus Equipment Sales 2007 Starting Capital Balance (Est.) 2007 Net Capitat Expenses 2007 Net Capital Income Projected End-of-2007 Capital Balance $15,500.00 $10,000.00 $2,500.00 $28,000.00 $2,000.00 $20,000.00 $500.00 522,500.00 $196,154.77 528,000.00 522,500.00 $190,654.77 Non-Retuning Charges for setting up Phase I Wireless Service Upgrade Office Workstations and Server Sgn Blanks and Vmyl 90Wo Recovery tt is likely vre'll trensfer additional surplus opereting funds before EOY. OfficeIPSAP Surplus Assests i i