ORDER N0.28884 PROPOSED 2005 BUDGET FOR KERR EMERGENCY 9-1-1 NETWORK. Came to be heard this the 25th day of October 2004 with a motion made by Commissioner Baldwin seconded by Commissioner Letz. The Court unanimously approved by a vote of 3-1-0 the 2005 Budget for Kerr Emergency 9-1-1 Network.. - a ~~~~ COMMISSIONERS' COURT AGENDA REQUEST PLEASE FURNISH ONE ORIGINAL AND NINE COPIES OF THIS REQUEST AND DOCUMENTS TO BE REVIEWED BY THE COURT. MADE BY: ~ ~ LL t- trR~.(~ ~ IJ ~ OFFICE: ~ ~~~~ t2 ~ j ( l MEETING DATE: ~~ C}C' T- ~.[.G t~ TIME PREFERRED: ~1 '• i SUBJECT: (PLEASE BE SPECIFIC '~l0 ~ J U L ~ ~-`~ ~~ ~ ~-C ~~ ~~~. EXECUTIVE SESSION REQUESTED: (PLEASE STATE REASON) NAME OF PERSON ADDRESSING THE COURT: ~ ~ L L R'a ~"~f'~'(~-1 t.~ ~- ESTIMATED LENGTH OF PRESENTATION: ~ S r~ ~ ~v-~ 5 IF PERSONNEL MATTER -NAME OF EMPLOYEE: 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: 5:00 P.M. previous Tuesday. THIS REQUEST RECEIVED BY: THIS REQUEST RECEIVED ON: @ All Agenda Requests will be screened by the County Judge's Office to determine if adequate information has been prepazed for the Court's formal consideration and action at time of Court Meetings. Your cooperation will be appreciated and contribute towards you request being addressed at the earliest opportunity. See Agenda Request Rules Adopted by Commissioners' Court. -a- Kerr County JudgelCommissioners' Court /~ ~~\1 ~'1 V~ From: "kerr911" ,l err Q ~ To: ~Y. ?004 Sent: Tuesday, October 05, 2004 1:36 PM -_ Subject: Re: Budget ~\ Ms. Mitchell: For clarification, is this request is being made on behalf of the court based upon a motion and a vote, or on behalf of Mr. Nicholson as an individual. ~ ` In either case, our office will be happy to provide the requested information with the appropriate open records request forms completed. Thank you, April Crooks Office Managers Origins! Message--- From: Kerr County Judge/Commissioners' Court Date: Monday, October 04, 2004 2:24:36 PM , ; To: Bill Amerine Subject: Budget Mr. Amerine: Commissioner Nicholson has asked me to contact Kerr 911and let you know that when you send your budget to the Commissioners' Court you also provide the previous three years budgets and the last~hree audits. Thank you, Kathy Mitchell a IncrediMvi/- Emnil has finally evolved -Click Here 10/5/2004 Kerr Emergeacy ~ ~`~ g~=-t Network Subject: Proposed 2005 Budget 1. 200 Payroll expenses Kerr Emergency 9-1-1 Network Administrative Offices 87 Coronado Drive, STE 100 Kerrville, Tezas 78028 (830) 792-5911 October 7, 2004 a. 210: Salaries. Salaries were not increased in the 2005 budget. For this year only vacation increases are proposed across the board for all employees instead of salary increases. Vesting one week vacation translates to an effective hourly increase of 1.92%. Overall this line item decreased from 136,493.00 budgeted in 2004 to 131,800.00 proposed in 2005. A personnel change; the termination of a regulaz part-time employee is the only factor in this decrease. Our current salary levels have our 9-1-1 staff salaries in the bottom 12% of all Texas 911 districts. b. 211: Overtime Wages. Decreased from 4,000.00 budgeted in 2004 to 2,028.00 (translates to 160 overtime hours) proposed in 2005. The amount proposed will be sufficient to cover 2005 overtime contingencies. c. 212: Payroll Taxes: A small decrease reflected in the 2005 budget based on the overall salary overhead mentioned above. d. 213: Medical Insurance Expenses: A small increase (3.5%) is reflected in the 2005 budget. (Source: KCAD/TAC). e. 214: TCDRS Expense Company (Retirement Plan/Benefit): A small decrease reflected in the 2005 budget based on part-time staff change mentioned above. f. 215: TCDRS SDB Expense Company (Survivor's Death Benefit): Line item added in mid-2004. This is survivor's death benefit for all employees. The amount is the total expense for all employees for 2005. g. 220: Contract Labor: A small decrease from 2,000 budgeted in 2004 to 1,760.00 (translates into 160 contract labor hours) proposed in 2005. h. 226: Texas Workforce Commission (Unemployment Insurance). No Change i. 230: Excess vacation payout. New line item for 2005. Line item allows for excess vacation payout at the end of 2005 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-year. 2. 300 Operations (PSAP) a. 310: Communications Ops. This line item is based on a standing contract between the City of Kerrville and Kerr 9-1-1 for the administration/operation of 9-1-1 call taking. This contract gives full functionaUadministrative authority to the city for 9-1-1 call taking and dispatch procedures. These monies pays for floor-space lease for PSAP equipment, dispatcher training and to marginally off- set the salaries of two 9-1-1 call-takers. The City of Kerrville has indicated that they will not be seeking an increase in 2005. b. 350: Service Provider Charges: No Change. This line item addresses all telephony cost associated with the 9-1-1 PSAP operation. c. 355: Language Line: Based on per-use-charges. No change in proposed 2005 budget. d. 380: Intrado -Phase two wireless: Line item for 2004 not expended. The 2004 allocated amount rolled over (part of a $40,000.00 funds transfer) to PSAP capital replacement fund. The new amount for 2005 is based on the monthly recurring service charges (MItC) for six months of Phase II capability in 2005. 3. 400 Direct Services a. 410: Office Supplies: Based on usage trends this line item has been decreased from 3,500.00 budgeted in 2004 to 2,500.00 proposed in 2005. b. 412: Office Equipment and Repairs: Based on 2004 usage trends and relative newness of most CPU's, servers, printers, plotters, and copiers this line item has been decreased from 3,000.00 budgeted in 2004 to 2,500.00 proposed in 2004. c. 420: Liability Insurance: Slight decrease anticipated -actual cost will not be available until we accomplish a new liability assessment for 2005. d. 430: Professional Development: An increase from 1,500.00 in 2004 to 3,000.00 in 2005. Forecasted usage; System Administrator training for 2 staff members, GIS and 911 conferences, and book-keeping refreshers for secretary/receptionist. e. 440: Rent: Substantial decrease from 21,372.00 in 2004 to 15,000.00 in 2005. We are letting our current lease lapse and moving to a smaller space more suited to our staff size and functional needs. f. 445: Utilities: Substantial decrease anticipated, from 7,500.00 budgeted in 2004 to 5,000.00 proposed in 2005. Based on our anticipated move to a small office space in 2005. g. 450: Professional Fees: No change. Items included in this line-item are legal, audit, and CPA fees. h. 460: Postage & Delivery: Slight increase ($100) based on 2004 usage. i. 470: Vehicle Expense: Increase from 250.00 budgeted in 2004 to 500.00 proposed in 2005. Factors include a significant increase in vehicle usage. j. 476: Vehicle Insurance: No Change. k. 480: Office Maintenance & Repairs: Slight increase from 2,500.00 budgeted in 2004 to 3,000.00 proposed in 2005. Based on moving related costs early in 2005. 1. 490: Bank Service Charges: No Change. 4. 500 Miscellaneous a. 510: Awards & Honorariums. No Change. b. 520; Dues & Subscriptions. Increased from 250.00 budgeted in 2004 to 400.00 in 2005. Added expenses from PC-Antivirus subscriptions and notary costs. c. 530: Public Education: Increased from 500.00 budgeted in 2004 to 1,500.00 proposed in 2005. d. 540: Local Meetings: No Change. e. 550: Telecommunications: No Change. Costs associated with KPD, SO, Kerr County, DPS and Kerr 9-1-1 administrative telephony services. f. 560: Sundry: Increase from 1,000.00 budgeted in 2004 to 2,500.00 proposed in 2005. Anticipated office move expenses. 5. 600: Discretionary Communications: Re-titled line item for 2005. a. 610: VFD Pager Services. No Change. b. 620: VFD Radio Repeater Services. No Change. 6. 700: PSAP Equipment Replacement: New Line Item for 2005. a. 710: Monthly operating funds transfers to capital funds account. New item to build cash reserves for PSAP equipment upgrade in 2006. 7. Net Income 2005: 365,000.00 based on a conservative increase of 2.8% over 2004's income. Capital Considerations: Other than interest-growth, no anticipated changes to our capital CD. PSAP upgrade has been delay by board vote until early 2006. Capital cash account grew by $40,000 in 2004 from nominal interest and the transfer of excess operating funds. Additionally this package includes a 2005 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. The expense planned include a Mapped ALI application for the PSAP, Intrado engineering costs (NRC) associated with phase two wireless, PSAP maintenance costs, office equipment replacement, sign material costs, and moving expenses. Accomplishments in 2004: 1. County wide addressing effort completed (citizens still need to do their part, i.e., appropriate signage.) Total 2003-2004 costs to 9-1-1 public funds $259,463.70 2. PSAP refurbishment to extend useful life unti12006. Total 2004 cost to 9-1-1 public funds $2,500.00. 3. Implemented Fixed Assets Tracking and Accountability program (none existed prior to 2004.) 4. Implemented new accounting and audit processes as required by federal and state law. 5. Continued efforts to cut costs and save funds toward capital improvements for the 9-1-1 Network. Vision for 2005: 1. Phase two wireless 9-1-1 capability for the major providers of wireless services in Kerr County. 2. Complete Kerr 9-1-1 MSAG, establish ESNs in PSAP and distribute MSAG to LECs. 3. Mapped ALI capability for the PSAP. 4. VoIP 9-1-1 service (Time Warner/AT&T) 5. Continued 9-1-1 sign sales. 6. Enhanced 9-1-1 public education. Conclusions & Recommendations: 1. The 2005 proposal is anon-deficit balanced budget. There should be a nominal $1,638.58 surplus at the end of 2005 based on the revenue growth projection of 2.8%. 2. This budget more than adequately addresses the expected operating needs of our district and it includes much needed technical upgrades towards phase 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. From 2003 through the end of 2004, over $70,000.00 has been set aside with another $30,000.00 projected in 2005 to be set aside for network upgrades. 4. Approve budget as proposed. Respectfully submitted by, .~~~~ Bill Amerine Executive Director, Kerr Emergency 9-1-1 Network Kerr Emergency 911 Network 2005 Opr. Budget Worksheet DRAFT 2005 Budget Worksheet. 200 • Payroll Expense Total 200 • Payroll Expense 300.Operations (PSAP) 210 • Salary 211 •Overtime Wages 212 • Payroll Taxes 213 • Medical Insurance Expense 214 •TCDRS Expense Company 218 -TCDRS SDB Expense Company 220 • Contract Labor 225 • Texas Workforce Commission 230 -Excess Vacation Payout 2~D4"Approved 2006 Proposed Delka ! Change 136,493.00 131,800.00 (4693.00) x.44% 4,000.00 2,080.00 (1920.00} -48.00% 10,935.00 10,600.00 (335.00) -3.06% 18,975.00 19.650.72 675.72 3.56% 9,700.00 9,226.00 (474.00) -4.89% 369.04 197.70 (171.34) X6.43% 2,000,00 1,760.00 (240.00) -12.00% 500.00 500.00 0.00 0.00% 0.00 1,082.00 182,972.04 176,896.42 (6075.62) -3.32% 310 • Communications Operations 36,000.00 36,000.00 0 0.00% 350 • Service Provider Charges 28,800.00 28,800.00 0 0.00% 355 • Language Line 500.00 500.00 0 0.00% 370 • PSAP Repairs & Maintenance 500.00 4.000.00 3500.00 700.00% 380 - Intrado -Phase II Wireless 18,600.00 12,400.00 (6200.00} -33.33% Total 300.Operations (PSAP) 84,400.00 81,700.00 (2700.00} -3.20% 400 • Direct Services Total 400 • Direct Services 500 • Miscellaneous Tota1500 • Miscellaneous 410.Office Supplies 3,500.00 2,500.00 (1000.00) -28.57% 412.Office Equipment E. Repairs 3,000.00 2,500.00 (500.00) -16.67% 420 • Liability Insurance 4,000.00 4,000.00 0.00 0.00% 430 • Professional Development 1,500.00 3.000.00 1500.00 100.00% 440 • Rent 21,372.00 15,000.00 (6372.00) -29.81 % 4as • utilises 7,SOO.oo s,ooo.oo (2soo.oo> ~i.33% 450 • Professional Fees 9,000.00 9,000.00 0.00 0.00% 460 • Postage b Delivery 400.00 500.00 100.00 25.00% 470 • Vehicle Expense 250.00 500.00 250.00 100.00% 476 • Vehicle Insurance 375.00 375.00 0.00 0.00% 480.Office Maintenance ~ Repairs 2,500.00 3.040.00 500.00 20.00% 490 • Bank Service Charges 40.00 40.00 0.00 0.00% 53,437.00 45,415.00 (8022.00) -15.01 % 510 • Awards 8~ Honorariums 100.00 100.00 0.00 0.00% 520 • Dues 8 Subscriptions 250.00 gQQ QQ 150.00 60.00% 530 • Public Education d~ Advertising 500.00 ?.500.00 1000.00 200.00% 540 • Local Meetings 250.00 250.00 0.00 0.00% 550 • Telecommunications 10,000.00 10,000.00 0.00 0.00% 560•Sundry 1,000.00 2.500.00 1,500.00 150.00% 570 -Texas 811 Alliance Meetings 0.00 1,200.00 1200.00 12,100.00 15,950.00 3850.00 31.82% Kerr Emergency 911 Network . ' 2005 Opr. Budget Worksheet DRAFT 600 -Discretionary Communications 610 • YFD Pager Service 820 • VFD Radio Repeater Service Total 600 -Discretionary Communications 700 - PSAP Equipment Repacement Account 710 -Monthly OF to CF Transfer Total 700 - PSAP Equipment Repacement Account Annual Budget Totals Net Income Projected Budget Increase 2004 to 2005 Projected Budget SurplusiDeficit 2004 to 2005 3,500.00 3,500.00 0.00 0.00% 9,900.00 9,900.00 0.00 0.00% 13,400.00 13,400.00 0.00 0.00% 0.00 30.000.00 30000.00 0.00 30,000.00 12.000.00 3as,3os.oa 363,361.42 ~7os2.3e a.s2% 355, X30.00 365,000.00 ss7o.oo 2.7s% 17,052.38 (1,638.58 Vesting one Week Uacat~tt in=leu-of.COLA increase equa#~s<.to 1.82°~ sala~rry increase • April & Ellen go to Four Weeks ' Bill 8 Amanda go to Three weeks Kerr Emergency 911 Network 2005 Cap. Budget Worksheet DRAFT 2005 `Budget"Worksheet (Capital Cash 703`&367) Capital Expenses -800 Total Capital Expense - 800 Capital Income - 900 Total Capital Income - 900 200'5 Proposed Comments Three Mapped ALI 801 - Ma ALI PPS workstations and software. MIS Package. Hardware/SOftWare $25,000.00 Warrantee/Support. 802 -Phase II Wireless Intrado/Engineering Fee $18,500.00 NRc 6000 blanks and 20 rolls 803 -Sign Materials $23,100.00 of vinyl Est. Researching service contract vs. garaMeed 804 - PSAP Service Contract $2,500.00 rate schedule. 805 -Office Automation $1,500.00 replace/update two CPUs If move occurs after first 806 -Moving Expense $4,000.00 of year ;74,600.00 901 -Sign Sales (Recovery) $20,700.00 90% Recovery (PIS 902 -Equipment Replacement 31,000 per month Fund Transfers $30,000.00 budgeted OfficeIPSAP Surplus 903 -Surplus Equipmenrt Sales $2,500.00 Asserts 2005 Starting Capital Balance 2005 Net Capital Expenses 2005 Net Capital Income Projected End-of-2005 Capital Balance $53,200.00 $123,500.00 $74,600.00 $s3,2ao.oo $102,100.00 . 10!15!04 -"err Emergency 911 Network-200`' Budget vs. Actual • January through December 2001 Jan -Dec '01 Budget S Over Budget Ordinary IncomelExpense Income 100•Revenues 101 • Local 911 Service 228,449.15 105 • Wireless Emergency Income 106,942.97 120•Interestlncome 11,572.91 130 • Miscellaneous Revenue 157.00 140 • Reimbursements 6.00 Total 100 • Revenues 347,128.03 Total Income 347,128.03 Expense 200 • Payroll Expense 210 • Salary 122,604.26 122,465.00 139.26 211 • Overtime Wages 0.00 3,770.00 -3,770.00 212 • Payroll Taxes 9,594.00 9,925.00 -331.00 213 • Medical Insurance Expense 18,125.85 17,773.00 352.85 214 • TCDRS Expense Company 13,420.37 13,471.00 -50.63 220 • Contract Labor 18,480.89 26,000.00 -7,519.11 Total 200 • Payroll Expense 182,225.37 193,404.00 -11,178.63 300 • Operations (PSAP) 310 • Communications Operations 36,000.00 36,000.00 0.00 350 • Service Provider Charges 27,380.04 32,000.00 -4,619.96 355 • Language Line 600.00 600.00 0.00 360 • VFD Pager Service 3,213.00 4,200.00 -987.00 365 • Radio Repeater Service 9,900.00 6,000.00 3,900.00 370 •PSAP Repairs 8 Maintenance 521.80 800.00 -278.20 Total 300 • Operations (PSAP) 77,614.84 79,600.00 -1,985.16 400 • Direct Services 410 • Office Supplies 3,528.87 3,500.00 28.87 412 • Office Equipment 8 Repairs 5,426.76 5,520.00 -93.24 413 • Plotter Extended Warranty 0.00 936.00 -936.00 420 • Liability Insurance 2,955.50 2,900.00 55.50 425 • Texas Workforce Commission 1,058.40 1,750.00 -691.60 430 • Professional Development 301.22 2,000.00 -1,698.78 440 • Rent 7,635.00 7,740.00 -105.00 445 • Utilities 1,522.04 2,400.00 -877.96 450 • Professional Fees 13,886.84 7,000.00 6,886.84 480 • Postage & Delivery 2,365.88 1,600.00 765.88 470 • Vehicle Expense 5,166.11 7,200.00 -2,033.89 475 • Vehicle Lease 8,975.60 8,976.00 -0.40 476 • Vehicle Insurance 776.00 1,200.00 -424.00 480 • Office Maintenance & Repairs 3,044.20 3,300.00 -255.80 Total 400 • Direct Services 56,642.42 56,022.00 620.42 Page 1 of 2 - 1on5iaa `"err Emergency 911 Network-200'' Budget vs. Actual January through December 2001 Jan -Dec '01 Budget 5 Over Budget 500 • Miscellaneous 510 • Awards & Honorariums 0.00 200.00 -200.00 520 • Dues 8 Subscriptions 972.11 550.00 422.11 530 • Public Education 8 Advertising 409.92 600.00 -190.08 540 • Local Meetings 550.98 800.00 -249.02 550 • Telecommunications 8,639.94 8,800.00 -160.06 560 • Sundry 692.57 2,000.00 -1,307.43 Total 500 • Miscellaneous 11,265.52 12,950.00 -1,684.48 600 • Capital Expenses 605 • Furniture 610 • Computer Equipment 615 • Vehicle Radio 620 • Filemaker Pro Software 625 • Network Printer 630 • VFD Pagers (Comfort & Harper) 640 • Computer Workstations 8 Server Total 600 • Capital Expenses Total Expense Net Ordinary Income Net Income 1,859.87 259.98 761.50 699.75 504.95 392.00 3,923.00 8,401.05 336,149.20 341,976.00 -5,826.80 10,978.83 -341,976.00 352,954.83 10,978.83 -341,976.00 352,954.83 Page 2 of 2 10!15104 ~ Kerr Emergency 9-1-1 Network Profit & Loss Budget vs. Actual January through December 2002 Jan -Dec 02 Budget S Over Budget ~~ Ordinary Income/Expense Income 100•Revenues 101 • Local 911 Service 231,043.57 105 • Wireless Emergency Income 109,434.05 120 • Interest Income 5,042.78 130 • Miscellaneous Revenue 380.82 Total 100 • Revenues 345,901.22 Total Income 345,901.22 Expense 200 • Payroll Expense 210 • Salary 131,123.55 126,139.00 4,984.55 211 • Overtime Wages 0.00 3,883.00 -3,883.00 212 • Payroll Taxes 10,814.66 9,947.00 867.66 213 • Medical Insurance Expense 19,294.33 18,884.00 410.33 214 • TCDRS Expense Company 9,587.37 8,830.00 757.37 220 • Contract Labor 11,364.22 24,000.00 -12,635.78 6560 • Payroll Expenses Vacation Pay 9,324.00 Total 200 • Payroll Expense 191,508.13 191,683.00 -174.87 300 • Operations (PSAP) 310 • Communications Operations 36,000.00 36,000.00 0.00 320 •PSAP Equip. Extended Warranty 0.00 2,000.00 -2,000.00 350 • Service Provider Charges 28,767.76 32,000.00 -3,232.24 355 • Language Line 413.80 600.00 -186.20 360 • VFD Pager Service 3,344.25 3,800.00 -455.75 365 • Radio Repeater Service 9,900.00 9,900.00 0.00 370 •PSAP Repairs 8 Maintenance 1,220.41 800.00 420.41 Total 300 • Operations (PSAP) 79,646.22 85,100.00 -5,453.78 400 • Direct Services 410 • Office Supplies 3,289.81 4,700.00 -1,410.19 412 • Office Equipment 8 Repairs 7,577.31 5,800.00 1,777.31 413 • Plotter Extended Warranty 936.00 936.00 0.00 420 • Liability Insurance 3,223.35 3,100.00 123.35 425 • Texas Workforce Commission 167.54 1,200.00 -1,032.46 430 • Professional Development 227.87 2,000.00 -1,772.13 440 • Rent 27,045.00 8,100.00 18,945.00 445 • Utilities 3,591.35 2,640.00 951.35 450 • Professional Fees 10,948.86 7,000.00 3,948.86 460 • Postage 8 Delivery 193.12 4,080.00 -3,886.88 470 • Vehicle Expense 4,219.87 7,200.00 -2,980.13 476 • Vehicle Insurance 439.41 1,000.00 -560.59 480 • Office Maintenance 8 Repairs 4,487.94 3,300.00 1,187.94 490 • Bank Service Charges 0.00 40.00 -40.00 Total 400 • Direct Services 66,347.43 51,096.00 15,251.43 Page 1 of 2 1a15ro4 '~ Kerr Emergency 9-1-1 Network Frofit & Loss Budget vs. Actua~ January through December 2002 500 • Miscellaneous 510 • Awards 8 Honorariums 520 • Dues 8 Subscriptions 530 • Public Education 8 Advertising 540 • Local Meetings 550 • Telecommunications 560 • Sundry Total 500 • Miscellaneous 600 • Capital Expenses 605 • Office Furniture 610 • GIS Software 620 • Radio Equipment 630 • Projector 640 • Computer Workstations 8 Server 645 • Map Info Mapping Software 650 • Gateway Laptop Computer 660 • HP Design Jet Mapping Plotter Total 600 • Capital Expenses Total Expense Net Ordinary Income Net Income Jan -Dec 02 Budget $ Over Budget ~~ 100.00 200.00 -100.00 664.43 625.00 39.43 2,434.11 600.00 1,834.11 944.67 600.00 344.67 10,644.92 9,400.00 1,244.92 1,305.87 2,000.00 -694.13 1 13,425.00 2,669.00 396.99 1,413.25 864.65 2,295.00 0.00 529.60 1,988.00 6,016.00 13,503.49 367,099.27 341,304.00 25,795.27 -21,198.05 -341,304.00 320,105.95 -21,198.05 -341,304.00 320,105.95 Page 2 of 2 10115104 ~ Kerr Emergency 9-1-1 Network ~~ !-rofit & Loss Budget vs. Actual January through December 2003 Jan -Dec 03 Budget 3 Over Budget ~~ Ordinary Income/Expense Income 100• Revenues 101 • Local 911 Service 235,003.92 105 • Wireless Emergency Income 121,452.17 120•Interestincome 3,200.69 130 • Miscellaneous Revenue 50.87 Total 100 • Revenues 359,707.65 Total Income 359,707.65 Expense 200 • Payroll Expense 210 • Salary 131,468.55 144,480.53 -13,011.98 211 • Overtime Wages 6,449.05 4,981.00 1,468.05 212•PayrollTaxes 11,091.83 11,214.00 -122.17 213 • Medical Insurance Expense 17,697.63 20,000.00 -2,302.37 214 • TCDRS Expense Company 9,414.41 9,913.00 -498.59 220 • Contract Labor 8,109.50 8,000.00 109.50 Total 200 • Payroll Expense 184,230.97 198,588.53 -14,357.56 300 • Operations (PSAP) 310 • Communications Operations 36,000.00 36,000.00 0.00 320 •PSAP Equip. Extended Warranty 0.00 2,000.00 -2,000.00 350 • Service Provider Charges 23,121.95 28,800.00 -5,678.05 355 • Language Line 248.33 500.00 -251.67 360 • VFD Pager Service 3,378.00 3,800.00 -422.00 365 • Radio Repeater Service 9,900.00 9,900.00 0.00 370 •PSAP Repairs & Maintenance 101.38 800.00 -698.62 Total 300 • Operations (PSAP) 72,749.66 81,800.00 -9,050.34 400 • Direct Services 410 • Office Supplies 2,798.35 4,900.00 -2,101.65 412 • Office Equipment & Repairs 2,494.89 5,800.00 -3,305.11 420 • Liability Insurance 3,905.76 3,300.00 605.76 425 • Texas Workforce Commission 405.16 400.00 5.16 430 • Professional Development 195.00 2,000.00 -1,805.00 440 • Rent 29,474.27 32,375.00 -2,900.73 445 • Utilities 4,221.70 4,435.00 -213.30 450 • Professional Fees 11,500.53 11,400.00 100.53 460 • Postage 8~ Delivery 755.38 400.00 355.38 470 • Vehicle Expense 237.35 1,500.00 -1,262.65 476 • Vehicle Insurance 495.00 600.00 -105.00 480 • Office Maintenance & Repairs 2,797.69 3,795.00 -997.31 490 • Bank Service Charges 0.00 40.00 -40.00 Total 400 • Direct Services 5 7 -11,663.92 Page 1 of 2 1a15ro4 ° Kerr Emergency 9-1-1 Network "~" Nrofit & Loss Budget vs. Actual January through December 2003 500 • Miscellaneous 510 • Awards & Honorariums 520 • Dues & Subscriptions 530 • Public Education 8~ Advertising 540 • Local Meetings 550 • Telecommunications 560 • Sundry Total 500 • Miscellaneous 600 • Capital Expenses 615 • Cannon ImageClass D660 Copier 625 • Cisco Server / Firewall 635 • Dell Computer (Data Tech) 655 • Address Signs 665 • SBC Wireless Tariff Total 600 • Capital Expenses Total Expense Net Ordinary Income Net Income Jan -Dec 03 Budget S Over Budget 33.52 200.00 -166.48 334.67 740.00 -405.33 556.70 1,000.00 -443.30 64.22 900.00 -835.78 8,264.44 9,400.00 -1,135.56 362.17 2,000.00 -1,637.83 9,615.72 14,240.00 -4,624.28 599.99 722.50 670.07 4,751.80 9, 538.29 16,282.65 342,160.08 365,573.53 -23,413.45 17, -365,573.53 383,121.10 17,547.57 -365,573.53 383,121.10 Page 2 of 2