Res 178-87 10/6/1987RESOLUTION NO. /7 --1
RESOLUTION APPROVING THE PROPOSED BUDGET
FOR THE WICHITA COUNTY 9-1-1 COMMUNICATIONS
DISTRICT FOR THE PERIOD FROM OCTOBER 1, 1987
THROUGH SEPTEMBER 30, 1988
WHEREAS, the City of Wichita Falls is a participating
jurisdiction in the Wichita County 9-1-1 Communications District;
and
WHEREAS, the proposed budget of the District for FY1987-1988
has been presented to the City and found to be reasonable and
appropriate,
NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE
CITY OF WICHITA FALLS, TEXAS, THAT:
The proposed budget for the Wichita County 9-1-1
Communications District, a copy of which is attached to and made
a part hereof, is hereby approved.
PASSED AND APPROVED this the 6th • • y .f October, 1 •87.
i.
11C4/..r
MAYOR
ATTEST:
City Clerk
BUDGET
FISCAL YEAR 1987 - 1988
WICHITA COUNTY 9-1-1 COMMUNICATIONS DISTRICT
3% SURCHARGE 4% SURCHARGE** 5% SURCHARGE**
INCOME 253,404.72 3022,'474.37 355,326.14
EXPENSE 126,900.00 126,900.00 126,900.00
SURPLUS FY 88 126,504.72 175,574.37 228,426.14
INTEREST 4,464.98 5,533.16 6,683.66
SURPLUS FUNDS 130,969.70 181,107.53 235,109.80
CARRYOVER FUNDS, 1987 25,000.00 25,000.00 25,000.00
INTEREST 1,622.50 1,622.50 1,622.50
SURPLUS AS OF 9-30-88 157,592.20 207,730.03 261,732.30
PROJECTED REVENUE TO MAR, 1989 105,585.30 140,635.05 178,386.30
PROJECTED EXPENSES TO MARCH, 1989
ASSUMING 5% RATE OF INFLATION 55,518.75 55,518.75 55,518.75
SURPLUS FUNDS TO MARCH, 1989 50,066.55 85,116.30 122,867.55
SURPLUS FY, 1988 157,592.20 207,730.03 261,732.30
INTEREST, 5 MO. 4,024.89 5,651.22 7,120.34
161,617.09 213,381.25 268,852.64
SURPLUS, FY 89 50,066.55 85,116.30 122,867.55
INTEREST 5 MONTHS 817.23 1,389.34 2,005.54
MONIES AVAILABLE, MARCH 1989 212,500.87 299,886.89 393,725.73
MONIES NEEDED FOR CUTOVER 403,407.95 403,407.95 403,407.95
SHORTAGE 3190,907.08) 3103,521.061 9,682.22)
IT WILL TAKE FIVE (5) MONTHS FOR ANY RATE INCREASED CASH FLOW TO REACH THE 9-1-1 DISTRICT
THESE FIGURES ARE BASED ON 5 MONTHS AT 3% AND 1 MONTHS AT THE NEW PERCENT CHARGE
EXPENSES
FISCAL YEAR 1988
OCTOBER 1, 1387 - SEPTEMBER 30, 1988
PERSONNEL SERVICES
Director 29,000.00
Database Manager (5/mo. @ $15,250 $6,355.00
7/mo. C+ $16,500 $9,625.00
Secretary 8,000.00
52,980.00
TAXES & BENEFITS
FICA (7.15%) 3,790.00
Workman's Comp 500.00
Retirement (7%) 3,710.00
Health & Life Ins.4,000.00
12,000.00
MATERIALS & SUPPLIES
Office Supplies 3,600.00
Printing 1,000.00
Postage 1,500.00
Advertising 300.00
Maps & Materials 1,000.00
CAD Software Update 650.00
8,050.00
FURNITURE & EQUIPMENT
Furniture 3,000.00
Equipment 3,500.00
Copier (Lease/Purchase) 1,815.00
ti 3.9% Interest)
8,315.00
SERVICES
Legal 9,000.00
Accounting 1,200.00
Audit 500.00
Extended Warranties:
Computer 700.00
Tektronix 4132 2,870.00
Tektronix 4111 2,000.00
HP 7595-A 600.00
Copier 460.00
17,330.00
OFFICE
Lease 7,000.00
Telephone 1,500.00
Liability & Casualty 500.00
9,000.00
TRAVEL & AUTO ALLOWANCE
Auto Allowance 5,500.00
Convention & Conference 2,000.00
Travel 3,000.00
10,500.00
DUES & MEMBERSHIPS
Professional 350.00
Subscriptions S Misc. 150.00
500.00
CONTENGENCIES 8,225.00
TOTAL BUDGET 126,900.00
NON-RECURRING COSTS EQUIPMENT AND LINES DIRECTLY
NETWORK, TRUNKING ASSOCIATED WITH PUBLIC SAFETY ANSWERING POINTS
SWITCHING
DATA BASE MANAGEMENT SYSTEM
AUTOMATIC NUMBER IDENTIFICATION
AUTOMATIC LOCATION IDENTIFICATION
SELECTIVE ROUTING
NON-RECURRING MONTHLY NON-RECURRING MONTHLY
SOUTHWESTERN BELL TELEPHONE COMPANY $154,924.80 6,918.40 118802.25 4528.65
GENERAL TELEPHONE 13,080.90 284.36
CONTEL 13,500.00 486.00
SANTA ROSA 4,600.00 285.00
ELECTRA 63,500.00 486.00 35,000.00 909.25
TOTALS 249,605.70 8,459.76 153,802.25 5,437.90
TOTAL NON-RECURRING 403,407.95
TOTAL RECURRING 13,897.66
NOTE; SWBT HAS SIGNED CONTRACT
GTE - LETTER OF ESTIMATED COSTS
CONTEL - LETTER OF ESTIMATED COSTS
3% SURCHARGE - PROJECTIONS TO MARCH, 1989 CUTOVER
CARRYOVER FUNDS, 1987 25,000.00 MONTHLY SURPLUS (ESTIMATE)10,542.06
INTEREST, 12 MONTH $1,622.50 INTEREST 12 MO 684.18 $11,226.24
11 MO 626.07 $11,168.13
10 MO 573.59 $11,115.65
26,622.50 9 MO 515.48 $11,057.54
8 MO 459.24 $11,001.30
7 MO 401.14 $10,943.20
6 MO 344.90 $10,886.96
5 MO' 286.79 $10,828.85
4 MO 228.68 $10,770.74
3 MO. 172.45 $10,714.51
2 MO 114.34 $10,656.40
1 MO. 58.11 $10,600.17
4,464.98 $130,969.70
SURPLUS FUNDS AS OF SEPTEMBER 30, 1988 157,592.20
PROJECTED REVENUE TO MAR 105,585.30
PROJECTED EXPENSES TO MARCH, 1989
ASSUMING 5% RATE OF INFLATION 55,518.75
50,066.55
SURPLUS PER MONTH 10,013.31
SURPLUS FY, 1988 147,948,42
INTEREST - 5 MO 4,024.89
151,973.31
FIVE MONTHS, FY 1989 50,883.78 MONTHLY SURPLUS (ESTIMATE)10,013.31
INTEREST - 5 MO 817.23 5 MO 272.41 $10,285.72
4 MO 217.21 $10,230.52
3 MO 163.80 $10,177.11
MONIES AVAILABLE, MARCH, 1989 203,674.31 2 MO 108.61 $10,121.92
1 MO 55.19 $10,068.50
MONIES NEEDED 403,407.95
50,883.78
SHORTAGE 199,733.64)
4% SURCHARGE - PROJECTIONS TO MARCH, 1989 CUTOVER
CARRYOVER FUNDS, 1987 25,000.00 MONTHLY SURPLUS (ESTIMATE)10,542.06
INTEREST, 12 MONTH $1,622.50 INTEREST 12 MO 684.18 $11,226.24
11 MO 626.07 $11,168.13
10 MO 573.59 $11,115.65
26,622.50 9 M 515.48 $11,057.54
8 MO 459.24 $11,001.30
MONTHLY SURPLUS (ESTIMATE)17,552.01
7 MO 667.87 $18,219.88
6 MO 574.24 $18,126.25
5 MO 477.50 $18,029.51
4 MD 380.75 $17,932.76
3 MO 287.12 $17,839.13
2 MO 190.37 $17,742.38
1 MO 96.75 $17,648.76
5,533.16 $181,107.53
SURPLUS FUNDS AS OF SEPTEMBER 30, 1988 207,730.03
PROJECTED REVENUE TO MAR 140,635.05
PROJECTED EXPENSES TO MARCH, 1989
ASSUMING 5% RATE OF INFLATION 55,518.75
85,116.30
SURPLUS PER MONTH 17,023.26
SURPLUS FY, 1988 207,730.03
INTEREST - 5 MO 5,651.22
213,381.26
FIVE MONTHS, FY 1989 85,116.30 MONTHLY SURPLUS (ESTIMATE)17,023.26
INTEREST - 5 MO 1,389.34 5 MO 463.11 $17,486.37
4 MO 369.28 $17,392.54
3 MD 278.47 $17,301.73
MONIES AVAILABLE, MARCH, 1989 299,886.89 2 MO 184.64 $17,207.90
1 MO 93.83 $17,117.09
MONIES NEEDED 403,407.95
86,505.64
SHORTAGE 103,521.06)
5% SURCHARGE - PROJECTIONS TO MARCH, 1989 CUTOVER
CARRYOVER FUNDS, 1987 25,000.00 MONTHLY SURPLUS (ESTIMATE)10,542.06 105,585.30
INTEREST, 12 MONTH $1,622.50 INTEREST 12 MO 684.18 $11,226.24 $52,875.00
11 MD 626.07 $11,168.13 $10,542.06
10 MO 573.59 $11,115.65
26,622.50 9 MO 515.48 $11,057.54
8 MO 459.24 $11,001.30
MONTHLY SURPLUS (ESTIMATE)25,102.26 249,740.82
7 MO 955.17 $26,057.43 $74,025.00
6 MO 821.26 $25,923.52 $25,102.26
5 MO 682.90 $25,785.16
4 MO 544.53 $25,646.79
3 MO 410.63 $25,512.89
2 MO 272.27 $25,374.53
1 MO 138.37 $25,240.63
235,109.80
SURPLUS FUNDS AS OF SEPTEMBER 30, 1988 261,732.30
PROJECTED REVENUE TO MAR 178,386.30
PROJECTED EXPENSES TO MARCH, 1989
ASSUMING 5% RATE OF INFLATION 55,518.75
122,867.55
SURPLUS PER MONTH 24,573.51
SURPLUS FY, 1988 261,732.30
INTEREST - 5 MO 7,120.34
268,852.64
FIVE MONTHS, FY 1989 122,867.55 MONTHLY SURPLUS (ESTIMATE)24,573.51
INTEREST - 5 MO 2,005.54 5 MO 668.51 $25,242.02
4 MO 533.06 $25,106.57
3 MO 401.98 $24,975.49
MONIES AVAILABLE, MARCH, 1989 393,725.73 2 MO 266.53 $24,840.04
1 MO 135.45 $24,708.96
MONIES NEEDED 403,407.95
124,873.09
SHORTAGE 9,682.22)