Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
SP November 16, 1993
,----, o ~) :J o ,1'\ CITY of ANDOVER special city council Meeting - November 16, 1993 1. Call to Order - 6:30 P.M. 2. Administrator/Engineer position 3. Water, Sewer & Central Equipment Fund Budgets 4. spacial Needs Analysis/City Hall & Public Works 5. 6. Adjournment CITY OF ANDOVER " REQUEST FOR COUNCIL ACTION DATE November 16, 1993 AGENDA SECTION NQ Discussion ORIGINATING DEPARTMENT APPROVED Administration FOR AGENDA ITEM 1\0. Administrator/Engineer Position Daryl E. sulander~~ B~)~ Acting Administrator C'f'f, Ol.. DISCUSSION The City Council is requested to discuss the options available to the City now that Jim's sick leave and vacation have expired. '-) MOTION BY: SECOND BY: \ ,~, TO: CITY OF ANDOVER REQUEST FOR COUNCIL ACTION November 16, 1993 DATE AGENDA t\O. SECTION ORIGINATING DEPARTMENT Discussion Items Finance APPROVED FOR AGENDA ITEM t\O. 1994 Proposed P.I.R. Fund, Water Fund, Sewer Fund, LRRWMO Fund and Central Equipment Fund Operating Budget Discussion Daryl E. sulander~ Finance Director/ Acting Administrator ~/ .,3. REQUEST The City Council is requested to review, discuss and provide revisions to the proposed 1994 operating budgets for P.I.R. Fund, water Fund, Sewer Fund, Lower Rum River Water Management Organization Fund and the Central Equipment Fund. REVIEW DOCUMENTS OF THE ADMINISTRATOR'S STAFF REPORT , ) 1. P.I.R. Fund Revenue and Expenditure Worksheets Schedule of Requested Equipment Authorizations 2. Water Fund Revenue and Expenditure Worksheets Schedule of Equipment Requests 3. Sewer Fund Revenue and Expenditure Worksheets Schedule of Equipment Requests 4. L.R.R.W.M.O. Fund Revenue and Expenditure Worksheets 5. Central Equipment Fund Revenue and Expenditure Worksheets Schedule of Rental Charges By Department Schedule of Equipment Requests MOTION BY: SECOND BY: '- TO: o ~J , , o 1994 proposed Budgets Administrator's staff Report Each department has submitted their requests for funding 1994 operations to maintain the current service level. These requests realize an increased service population. We have already reviewed and adopted a proposed 1994 General Fund budget. The proposed budgets included in this review are the remainder of the city's operating budgets. These budgets provide and record specific activities and services financed by user fees, fund reserves or dedicated taxes from special tax districts. First, the P.I.R. Fund proposed budget is presented as the funding source for a variety of equipment purchases removed from the 1994 General Fund departmental requests at earlier budget review meetings. These equipment requests are additions to the existing city equipment stock, not replacements. The second budget section is the Water Fund. The Water Fund proposed 1994 budget has been prepared based on increasing water delivery demands of our rapidly growing user base within the urban water service delivery area. The revenue projections are based on maintaining the 1993 user fees and rate structure. The third budget section is the Sewer Fund. The Sewer Fund proposed 1994 budget has been prepared based on increasing service demands of our rapidly growing user base within the urban sewer service area. Like the Water Fund, the projections are based on maintaining the 1993 user fees and rate structure. The fourth budget section is the Lower Rum River Watershed Management Organization 1994 ,proposed budget. The 1994 budget is proposed at the same level as the 1993 budget. The city's contributing share of the Watershed's operating budget remains the same at $5,460, and personnel charges from our Engineering Department will also remain at 1993 levels for 1994. The fifth and final budget section for review is the central Equipment Fund 1994 proposed :budget. The departmental rental charges used to fund the equipment operations have increased from $143,948 in 1993, to the proposed $166,770 for 1994. The two main reasons for this increase are; 1) funding the mechanic hired in 1993 for twelve months as opposed to the ten months in 1993, and 2) increasing maintenance requirements due to more equipment and the aging of our existing equipment. The majority of the departmental rental charges have been authorized within the proposed 1994 General Fund budget. The remaining rental charges are within the Water and Sewer Fund budgets. A schedule of the departmental charges is included in section 5 for your review. () SECTION 1 PERMANENT ~J IMPROVEMENT REVOL VING FUND (P.I.R) ;~ \ / " BRC FINNJCIAL SYSTEM 11/06/93 16:36:58 ~, IMPROV, REVOLV, FUND ..j Revenue Budget Worksheet CITY OF NJDOVER GL7A lR-V04.09 PAGE f..- 1 ---------------------ACTUAL DOLlARS--------------------- --------------------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 11-30-1993 '93 REV BUDGET 1994 PROPOSED 1994 REVISICN 501,36101 ASSMT, PRIN, COll, BY CITY 23,683,32 501,36102 ASSMT. INT, COll, BY CITY 1,822,51 501. 3 61 03 ASSMTS, COLl, BY COUNTY-CU 69,650,78 501,36104 ASSMTS, COll, BY C~JNTY-DE 1,617.46 501.36210 INTEREST EARNED 9,466.28 501.36260 RE FUNDS NJD Rm\BURSE~\EtJTS 0.00 501,39201 TRNJSFERS FRa>\ OTHER FUNDS 570,857.20 501.39202 RESIDUAL EQUITY TRNJSFER I 0,00 501,39301 PRO:, FROM ISSUANCE OF L-T 0,00 22,386,84 85,387,86 30,132,76 1,624,16 4,450,08 2,448.48 59,380,80 54,751. 73 25,090,62 2,465,)7 3,511,11 665,14 59,461,59 42,680,99 20,786,43 0.00 2,918.43 0,00 0,00 0.00 11,401.06 71,634,17 0.00 0,00 0,00 0.00 0,00 PERM, IMPROV, REVOlV, FUND TOTAL 677,097,55 216,953,33 193,706.20 \/ " 91,124,49 26,675.00 37,135,00 *------------* 0,00 *------------* *------------* 45,000.00 95,000,00 *------------* 0,00 *------------* *------------* 30,000.00 30,000,00 *------------* 0,00 *------------* *------------* 0,00 *------------* *------------* 0,00 *------------* *------------* 0,00 *------------* *------------* 101,675,00 162,135.00 0,00 BRC FINNICIAL SYSTEM 11/06/93 16:43:49 Expenditure Bud~let I!or-ksheet CITY OF mDOVER GL7A1R-V04,09 PAGE e:- 1 '~, IMPROV, REVOLV, Fl~D J ---------------------ACTUAl VJlLfRS--------------------- --------------------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 11-30-1993 '93 REV BlVGET 1994 PROPOSED 1994 REVISICN CAPITAL IMPROVEMENT ACCC~NT CAPIT AL OUTLAy,."""""" 501.49200,510 lAND 0,00 0,00 0,00 0,00 0,00 *------------* *------------* 501.49200,520 BUILDINGS 0,00 4,678,15 22,804,53 0,00 0.00 *------------* *------------* 501 ,49200,530 I~.IF'ROVEMENTS 0.00 5,869.00 4,545,00 0,00 0,00 37,000,00 *------------* 501.49200.560 FURNITURE 0,00 0.00 0.00 0,00 0,00 *------------* *------------* 501.49200,570 OFfICE EQUIPMENT 0.00 0,00 0,00 0,00 0,00 11,715,00 *------------* 501.49200,580 ECilJI PMENT 0,00 4,418.43 80,516,04 50,342,78 64,000.00 113,420,00 *------------* 501 ,49200,620 FISCAL AGENT FEES 0,00 150.00 0,00 0,00 0.00 *------------* *------------* 501.49200,723 T~mSFER TO IMf'R, UNFHt 0.00 0,00 68,721. 78 0,00 0,00 *------------* *------------* CAPITAL OUTLAy..........,... TOTAL 0,00 15,115,58 176,587.35 50,342,78 64,000,00 162,135,00 0,00 ,~TAL IMPROVEMENT ACCOUNT 0,00 15,115,58 176,587.35 50,342,78 64,000,00 162,135.00 0,00 TOT AL ;' BRC FINNJCIAL SYSTEM 11/06/93 16:43:49 .~, IMPROV. REVCtV. FUND .J Expenditure Budget ~orksheet CITY OF mOOVER GL7A1R-V04.09 PAGE E- 2 ---------------------ACTUAL DOLLARS--------------------- --------------------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 11-30-1993 193 REV BUDGET 1994 PROPOSED 1994 REVISIal PLGLIC IMPROVEMENT ACCOUNT 501,49250.301 P~OFESSIC\'jAL SERVICES 501,49250,303 CONSULTING ENGINEER-GENERA 501.49250.304 ATTORNEY 501,49250.351 PUBLISHING 501.49250,406 CONTRACTUAL SERVICES 501.49250,510 LAND 501.49250.810 REFUNDS/REIMBURSEMENTS PUBLIC IMPROVEMENT ACCOUNT TOT AL PERM, IMPROV, REVOLV. FUND TOTAL \ ,-----) \ I ) 0.00 0,00 0,00 0,00 0,00 0.00 0,00 1,807,64 400,00 0,00 0,00 0,00 0,00 0.00 0,00 0,00 0,00 0,00 0,00 0,00 0.00 0,00 0,00 0,00 0,00 0,00 0,00 15,175,00 400,00 0,00 0.00 16.982,64 400,00 15,115.58 176,581,35 67,325,42 0,00 *------------* *------------* 3,000,00 *------------* *------------* 0,00 *------------* *------------* 0,00 *------------* *------------* 19,500.00 *------------* *------------* 0,00 *------------* *------------* 15,115,00 *------------* *------------* 31,615,00 0.00 0,00 101.675,00 162.135,00 0,00 c- \ '_I .' "- \,J '~ Department Fire Data Processing city Hall Bldg. 1994 CAPITAL OUTLAY REQUESTS Request Description washer/Dryer for Station 3 Floor Scrubber Share All Station A 4 Bottle Cascade Set for U-1 Commercial Dryer Refurbish Truck E-6 Laser Printer upgrade/Expand Telephone System Public Works Bldg. Lights/vent Impr. Floor/Vent/Sheetrock Public Works Garage Streets Parks 4X4 Tractor & Mower Seeding/Shaping Machine TOTAL 1994 PIR Fund $800 $2,000 $3,400 $2,220 $55,000 $5,000 $11,715 $26,000 $11,000 $35,000 $10,000 $162,135 C) SECTION 2 WATER () FUND C) ~ ".",1;. / r \ ) FINANCIAL SYSTEM ',,/06/93 12: 13 :25 Revenue Budget Worksheet CITY OF ANDOVER GL7A lR-V04.09 PAGE ~ - 1 WATER FUND ---------------------ACTUAL DOLLARS--------------------- --------------------BLOGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BUDGET 1994 PROPOSED 1994 REVISICN ~------------ ------------- ------------- -------------- -------------- -------------- --------------- 601,36110 CERTIFIED BILLS 0,00 0,00 0,00 0,00 0,00 *------------* *------------* 601.36210 INTEREST EARNED 18,053,48 22,108,51 15,809,32 6,904,64 14,000,00 14,000,00 *------------* 601,36260 REFUNDS N~D REIMBURSEMENTS 1,582,37 1,008,00 2,886,59 3,016,61 0,00 *------------* *------------* 601.37110 ,"~TER SALES-GENERAL CUSTOM 182,691.45 205,848,01 274,892,73 221,398,51 314,710,00 325,000,00 *------------* 601.37140 WATER-DISCajNECT/RECONNECT 155,00 113,00 0.00 0,00 0,00 *------------* *------------* 601.37150 WATER PERMIT FEES 10,750,00 11,400,00 20,700.00 19,100,00 12,000,00 18,000,00 *------------* 601. 3 7152 OTHER FEES - WATER 0.00 152,00 285.00 945,00 0,00 *------------* *------------* 601,37160 PENALTIES - WATER 5,080,87 5,239,02 5,954,40 4,147,21 6,000,00 7,000.00 *------------* 601.37170 _,HYDRANT RENTALS 0,00 0,00 0,00 65,00 0,00 *------------* *------------* )37171 METE RS 26\ 185,00 29,473.00 11,199,12 44,510,00 28,800,00 42,000.00 *------------* WATER FtND TOTAL 244\498,17 275,341. 54 331\727,16 300,086,97 375,510,00 406,000,00 0,00 ) ~ FINNJCIAL SYSTEM CITY OF NJDOVE F " _/06/93 12: 16: 12 Expenditure Budget Worksheet GL7A1R-V04,09 PAGE f.1 WATER FUND ---------------------ACTUAL DOLLARS--------------------- --------------------BLOGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 193 REV BLOGET 1994 PROPOSED 1994 REVISICN ------------- ------------- ------------- -------------- -------------- -------------- --------------- SOURCE, STORAGE & TREATMENT SUPPLIES NJD ~\<\TERIAlS...... 601.49400,201 GENERAL OFFICE SUPPLIES 46,72 0,00 369,30 47.62 500,00 500,00 *------------* 601.49400,210 OPERATING SUPPLIES 1,002,01 573,24 412,28 818,85 1,600,00 1,600,00 *------------* 601.49400,216 CHE~lICftl S 10,132,33 8,810,51 14,524.69 11,793,72 18,000.00 20,000,00 *------------* 601.49400,227 REPAIR/MAINT SUPPLIES-SYST 462,10 1,821.07 2,471.40 559.22 3,000,00 3,000,00 *------------* SUPPLIES NJD MATERIALS""" TOTAL 11,643,16 11,204,82 17,777.67 13,219.41 23,100.00 25,100.00 0,00 PURCHASED SERVICES"".,.,., 601,49400,301 PkOFESSIalAL SERVICES 0.00 0,00 1,835,00 0,00 2,000.00 2,000.00 *------------* 601.49400,315 , )'ROFESSIUlAL SERVICE -LAS. 209,00 531. 28 168,00 122.00 7,500.00 1,000,00 *------------* uul,49400,321 TELEF'Ha~E 503,28 584,20 28,45 24,90 2,200,00 2,200,00 *------------* 601.49400,360 INSURANCE 5,568,39 6,078.64 380,00 1,939,00 1,939.00 2,150,00 *------------* 601.49400,381 ELECTRIC 8,174,37 10,012,04 25,246,13 19,590.97 25,000,00 25,000.00 *------------* 601,49400,383 NATURAL GAS 655,29 666,42 423.45 576,38 750,00 1,200,00 *------------* 601,49400.386 WATER PERMIT - DNR 0,00 0.00 804,00 0,00 0,00 1,000,00 *------------* PURCHASED SERVICES.......... TOTAL 15,110,33 17,872,58 28,885,03 22,253,25 39,389,00 34,550,00 0,00 0111ER SERVICES N~D CHARGES" 601.49400,401 REPAIR/MAINT, LABOR-GENERA 0,00 170,03 2,287,18 1,407,00 3,500,00 3,500,00 *------------* 601,49400,402 REPAIR/MAINT, LABOR - BLDG 598,34 611.50 17.74 600,81 2,000,00 2,000,00 *------------* 601.49400,403 REPAIR/~~INT LABOR-WELL/PU 0,00 412,00 401,38 20,000,00 20,000,00 25,000,00 *------------* 601 ,49400.404 REPAIR/MAINT, LA80R - IMPR 0,00 0,00 0,00 307.61 1,500,00 3,000.00 *------------* 601,49400,406 CONTRACTUAL SERVICES 0.00 0,00 0,00 0,00 0,00 *------------* *------------* .<01,,49400,433 JUES/REGISTRATIONS 663,00 844,00 551,14 388,00 1,000.00 1,000.00 *------------* 0111ER SERVICES AND CHARGES" TOT AL 1,261.34 2,037,53 3,257.44 22,703,42 28,000.00 34.500.00 0.00 ~ FINN~CIAL SYSTEM ',,/06/93 12: 16: 12 Expenditure Budget Worksheet CITY OF mDOVE ~ GL7A1R-V04,09 PAGE E.2 \lATER FUND ---------------------ACTUAL DOLLARS--------------------- --------------------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BUDGET 1994 PROPOSED 1994 REVI5IaJ SOURCE, STORAGE & TREATMENT CAPITAL OUTLAy,..,.,.,...... 601.49400,580 EqUIP~1ENT 0,00 0,00 0,00 0,00 0,00 *------------* *------------* 601,49400,582 CAPITAL ~~INTENANCE RESERV 0,00 0,00 0,00 0.00 25,000.00 25,000,00 *------------* CAPITAL OUTLAy.............. TOT AL 0,00 0,00 0,00 0,00 25,000,00 25,000,00 0.00 SOURCE, STORAGE & TREATMENT TOTAL 28,014,83 31,114,93 49,920,14 58,176,08 115,489,00 119,150,00 0,00 ) '-/ , ) I FINANCIAL SYSTEM CITY OF ANDOVE~ " , ,/06/93 12: 16: 12 Expenditur'e Budget Worksheet GL7A1R-V04,09 PAGE ~. 3 WATER FUND ---------------------ACTUAL ~JLLARS--------------------- --------------------BUDGETS------------------- 12- 31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BUDGET 1994 PROPOSED 1994 REVISICN ------------- ------------- ------------- -------------- -------------- -------------- --------------- DISTRIBUTION m~:ONAL SERVICES"",.,.", 601.49430,101 SALARIES - REGULAR H1PLOYE 36,414,17 42,518,58 59,602,62 54,430,38 44,010,00 62,570,00 *------------* 601,49430.121 PERA 1,576,20 1,853.28 2,351.83 2,195,31 1,538,00 2,810,00 *------------* 601.49430.122 SSA (FICA) 2,691.56 2,648,49 3,668,72 3,496,75 2,717,00 3,885,00 *------------* 601,49430.125 ~:EDICARE 9,83 619,55 857.93 817,74 635,00 910.00 *------------* 601,49430,131 HEAL TH INSURNKE 1,531.22 2,599,10 3,933,45 4,008,75 4,920,00 5,900,00 *------------* 601,49430.133 LIFE INSURNKE 23,64 26.09 33,51 33,27 34,00 50,00 *------------* PERSONAL SERVICES"""".,. TOT AL 42,247,22 50,265,09 70,448,06 64,982,20 53,85/1.00 76,125,00 0,00 oll~PLIES AND M<\TERIALS...... \49430.201 / GENERAL OFFICE SUPPLIES 26,86 0.00 27 ,16 237,61 150,00 300,00 *------------* 601.49430,210 OPERATING SUPPLIES 4,086.76 3,416,18 3,606.40 3,599,51 6,000.00 6,000,00 *------------* 601,49430,212 GAS - VEHICLE 636,63 530.83 534,05 0,00 0.00 *------------* *------------* 601,49430,214 METER REPAIR SUPPLIES 0,00 535,96 273.26 24,18 2,000,00 2,000,00 *------------* 601,49430,218 DIESEL FUEL 0,00 0.00 0,00 0,00 0,00 *------------* *------------* 601.49430,219 HYDRNH REPAIR SUPPLIES 255,30 0.00 381.52 753,90 1,000,00 1,000,00 *------------* 601,49430.220 REPAIR/MAINT,SUPPLIES-GEN, 2,245,79 3,749,06 2,605,81 849,45 5,000,00 5,000,00 *------------* 601,49430,221 REPAIR/MAINT, SUPPLIES-VEH 1,040,94 1,066,23 ',437,80 0,00 0,00 *------------* *------------* 601,49430,224 REPAIR/MAINT SUPPLIES-STRE 0.00 0,00 0,00 0,00 2,000,00 5,000,00 *------------* 601.49430,227 REPAIR/~lAINT SUPPLIES-SYST 63,63 90.84 906,30 633,21 1,000,00 2,000,00 *------------* SUPPLIES ANO M<\TERIALS...,,' TOTAL 8,355,91 9,389,10 9,772,30 6,097,86 17,150.00 21,300,00 0,00 PURCHASED SERVICES".""", 601,49430,303 -SONSULTING ENGINEER-GENERA 22,00 0,00 0,00 0,00 500.00 500,00 *------------* , ),49430,314 GOPHER STATE ONE CALL 1,232,75 294.89 720,40 523, 13 1,750,00 1,750,00 *------------* 601.49430,321 TELEPHCNE 0.00 0.00 292,55 90.36 500.00 500.00 *------------* ._~ FINNJCIAL SYSTEM '- _:06/93 12:16:12 Expenditure Bud'~et Worksheet CITY OF NmOVE~ GL7A1R-V04,09 PAGE (- 4 \lATER FUND ---------------------ACTUAL DOLLARS--------------------- --------------------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BUDGET 1994 PROPOSED 1994 REVISICN ------------- ------------- -------.----- -------------- -------------- -------------- --------------- DISTRIBUTION PURCHASED SERVICES...,."", 601.49430.322 POST AGE 0,00 357.75 3,57 18.70 500,00 500,00 *------------* 601.49430,351 PU[lISHING 54,67 22 ,50 234,30 48,80 200,00 300,00 *------------* 601.49430,360 INSURANCE 0,00 0,00 1,796,00 1,494,00 1,491,,00 1,700.00 *------------* PURCHASED SERVICES"""",. TOTAL 1 ,309,42 675,14 3,046,82 2,174.99 4,944.00 5,250,00 0,00 OTHER SERVICES AND CHARGES,. 601,49430,401 REPAIR/MAINT, LABOR-GENERA 34,95 1,203,50 617 ,53 100,00 1,600.00 1,600,00 *------------* 601.49430,403 REPAIR/MAINT LABOR - STREE 0,00 375 .00 0,00 0,00 1,000,00 1,000,00 *------------* 601,49430,405 REPAIR/MAINT, LABOR-VEHICL 454,80 784,95 1,348.90 0,00 0,00 *------------* *------------* '\ .49430 ,407 \~METERS - LABOR 0,00 0,00 51.12 372,75 400.00 400,00 *------------* 601.49430,408 HYORNHS - LABOR 0,00 0.00 0.00 0,00 1,000.00 1,000,00 *------------* 601.49430.410 RENT ALS 0,00 331.00 355,92 0.00 700,00 700,00 *------------* 601.49430,415 RENTAL OF CITY EQUIP 0,00 0,00 0.00 4,031,50 5,375,00 8,000,00 *------------* 601.49430.420 DEPRECIATlCN 134,581.35 153,174,89 8,452.64 0,00 0,00 *------------* *------------* 601.49430.433 DUES/REGISTRATIONS 422,50 298,34 632,68 299,00 500,00 600,00 *------------* OTHER SERVICES AND CHARGES" TOTAL 135,493,60 156,167.68 11,458,79 4,803,25 10,575.00 13,300,00 0,00 CAPITAL OUTLAy,............, 601.49430.560 FURNITURE 0,00 0.00 0,00 0,00 500.00 500,00 *------------* 601,49430,580 [QUI P~\ENT 0,00 0.00 7,488.95 18,417,80 22,752,00 15,750.00 *------------* 601.49430,581 ~\ETE RS /HORNS 21,661. 76 21,929,77 1,434,53 40,276,63 37,400,00 37,400,00 *------------* CAP IT AL OUTLAy..,.........., TOTAL 21,661.76 21,929,77 8,923,48 58,694,43 60,652,00 53,650,00 0,00 DISTRIBUTION " TOTAL 209,067,91 238,426,78 103,649.45 136,752,73 147,175,00 169,625,00 0.00 , ) " FIN.ANCIAL SYSTEM CITY OF NmOVE~ \., ./06/93 12: 16: 12 Expenditure Budget Worksheet GL7A1R-V04,09 PAGE c-5 \lATER FUND ---------------------ACTUAL DOLLARS--------------------- --------------------BLOGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BL~GET 1994 PROPOSED 1994 REVISICN ------------- ------------- ------------- -------------- -------------- -------------- --------------- \lATER ADMINISTRATION PER~:CNAL SERVICES.........., 601,49440,101 SALARIES - REGULfR E~fLOVE 18,941.95 24,674,03 29,374 ,45 24,333,41 32,675,00 35,000,00 *------------* 601.49440,121 PERA 858,51 1,023.68 1,290,63 1,090,24 1,464,00 1,570,00 *------------* 601,49440,122 ::SA (FlCA) 1,433,70 1,381. 24 1,760,24 1,469,68 2,026,00 2,170.00 *------------* 601,49440.125 ~\EDICARE 0,00 331.50 421.11 343.64 474,00 510,00 *------------* 601.49440,131 HEAL TH INSURNlCE 1,446,77 2,009.15 2,369,38 2,074.48 2,625,00 3,150.00 *------------* 601.49440.133 LIfE INSURNlCE 20,26 15.10 17 ,22 14,23 18,00 25,00 *------------* PERSONAL SERVICES""""", TOTAL 22,701.19 29,434.70 35,233,03 29,325,68 39,282,00 42,425.00 0,00 .cIIPPlIES NW MATERIALS...... .. \ '---' ,4 9440,201 500.00 *------------* GENERAL OFFICE SUPPLIES 697.44 405,37 423,83 256.07 500,00 601.49440,210 OPERATING SUPPLIES 3,00 0,00 218,99 63,08 500,00 500,00 *------------* 601.49440.220 REPAIR/MAINT,SUPPLIES-GEN, 0,00 0,00 49,87 85,20 100,00 200.00 *------------* SUPPLIES AND MATERIALS""" TOTAL 7 00 ,44 405,37 692,69 404.35 1,100.00 1,200,00 0,00 PURCHASED SERVICES".,.,.", 601.49440.301 PROFESSIalAL SERVICES 0,00 1,233,00 1,625,00 2,001.11 5,000.00 5,000,00 *------------* 601.49440.303 CONSULTING ENGINEER-GENERA 0.00 63,47 0,00 0,00 200,00 200.00 *------------* 601.49440,322 PO:,:T AGE 774,36 898.63 1,208,67 1,270,09 1,500,00 1,500,00 *------------* 601.49440.330 lRNJSPORTATICN 11.94 1. 93 213.95 30,70 200,00 200,00 *------------* 601.49440,351 PUBL ISHING 60,72 196.69 18,65 48,80 600,00 600,00 *------------* 601.49440,352 PRINTING 0.00 0,00 0,00 0,00 100,00 100,00 *------------* 601,49440,353 PUBLICATIONS 0,00 0,00 0,00 0,00 500,00 500.00 *------------* 601.49440,360 , INSURANCE 423,68 454.4 8 1,480,00 826,00 826,00 900,00 *------------* " _),49440,386 ~~TER QUALITV FEE 0.00 0,00 4,480.00 7,336,00 10,420,00 12,500.00 *------------* PURCHASED SERVICES,."",." TOlAL 1,270.70 2,848,20 9,026.27 11,512,70 19,346,00 21,500.00 0.00 -1 FINN1CIAL SYSTEM t06/93 12:16:12 Expenditure Budget Worksheet CITY OF mDOVEf GL7A lR-V04 .09 PAGE f. € \lATER FUND ---------------------ACTUAL DOLLARS--------------------- --------------------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BUDGET 1994 PROPOSED 1994 REVISICN ------------- ------------- ------------- -------------- .------------- -------------- -------------.- \lATER ADMINISTRATION OTHER SERVICES mD CHARGES" 601,49440,401 REPAIR/MAINT, LAGOR-GENERA 29,54 44,94 60.03 132.07 200,00 300,00 *------------* 601,49440.406 CWTRACTUAL SERVICES 0,00 214,50 129,00 149,00 1,000,00 1,000,00 *------------* 601.49440.410 RENTALS 0.00 0,00 0,00 0,00 450,00 450,00 *------------* 601,49440,433 DUES/REGISTRATIONS 60,00 80,00 332.50 192,50 500,00 500.00 *------------* 601,49440.442 ~lE^LS/Lc(;GING 0,00 0.00 139,62 0,00 300,00 300,00 *------------* 601 ,49440.499 CONTINGENCY 0.00 0,00 0,00 0,00 23,868,00 20,000,00 *------------* OTHER SERVICES NJD CHARGES,. TOTAL 89,54 339,44 661.15 473.57 26,318,00 22,550.00 0,00 CAP IT AL OUTLAy,..,.......... \49440,560 --jruRNITURE 0,00 0,00 167,50 0,00 500,00 550,00 *------------* 601.49440,570 OFFICE E~~JlPIOT 0,00 0,00 5,136.00 6,306,30 6,300.00 9,000.00 *------------* 601.49440,712 TR/tJSFER-CERT OF INDEBT FU 0,00 0.00 0,00 0,00 0,00 *------------* *------------* 601.49440,720 TRNmER TO COI,IPUTER RESER 0,00 0,00 0,00 0.00 20,000.00 20,000,00 *------------* 601.49440,727 TRmSFER TO OTHER FUNDS 0,00 0,00 20,000,00 0,00 0,00 *------------* *------------* CAP HAL OUTLAy.............. TOT AL 0,00 0,00 25,303.50 6,306.30 26,800,00 29,550,00 0.00 \lATER ADMINISTRATION TOTAL 24,761.87 33,027,71 70,916,64 48,022.60 112,846,00 117 ,225.00 0.00 \lATER FUND TOTAL 261,844,61 302,569.42 224,486,23 242,951.41 375,510,00 406,000,00 0,00 \ , '- / C) o ''\ V 1994 WATER Department Administration Request Description Furniture Work Station for Secretary Office Equipment Copier 1/2 of Phone System Distribution Equipment 1/2 of 6" Water & Sewer Pump 4 Cylinder 1,100 GPM 1/2 of Hyd. Jack Hammer New Generator Automatic Valve Exercising Machine 150 Hydrant Markers Meters and Horns/Includes 40 Replacement Meters Estimated Amount $500 $6,000 $3,000 $5,000 $1,250 $1,500 $5,000 $3,000 $15,750 $43,000 ! !~J SECTION 3 SEWER ~ FUND o , ; " FINANCIAL SYSTEM , , . ./06/93 12: 13 :25 Revenue Eudget Worksheet CITY OF ANDOVER GL7A1R-V04,09 PAGE p.- SEilER FUND ---------------------ACTUAL ~JLLARS--------------------- --------------------EUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BUDGET 1994 PROPOSED 1994 REVISIa~ 602,36103 ASSMTS. CaLL, EY COUNTY-CU 0,00 0,00 8,838,75 0,00 0.00 *------------* *------------* 602.36110 CERTIFIED BILLS 20,073,71 11,945,19 26,460,32 10,199,17 18,000,00 18,000,00 *------------* 602,36210 INTEREST EARNED 380,06- 5,169.98 5,794,13 3.417 , 59 4,500,00 6,000.00 *------------* 602,36260 REFUNDS tND REIM8URSHIENTS 0,00 5,093,00 766,01 38,10 0,00 *------------* *------------* 602,37210 SEWER CHGS,-GENERAL CUSTa~ 306,168,64 339,228.16 384,373 ,31 367,095,75 460,400,00 534,800,00 *------------* 602,37240 SEWER GIGS, - OTHER CUSTC'b1 0,00 0,00 0,00 0,00 0.00 *------------* *------------* 602,37260 PENALTIES - SEWER 7,364,24 9,083,16 8,410.38 7,996,78 10,500,00 10,500,00 *------------* 602,39204 TRms FRC'b1 SEilER CCNN, CHG 30,500.00 30,500,00 30,500.00 0,00 30,500,00 30,500,00 *------------* SFIIER FUND ,~ TOTAL 363,726,53 401,019,49 465,142,90 388,747,39 523,900.00 599,800.00 0,00 'I , ) , ~ FINNjCIAL SYSTEM CITY OF NJCoOVE R '-, '/06/93 12: 16: 12 Expenditure 8udget Worksheet GL7A1R-V04,09 PAGE 1'- 8 SEilER FUND ---------------------ACTUAL ~JLLARS--------------------- --------------------8UOGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BUDGET 1994 PROPOSED 1994 REVISICN ------------- ------------- ------------- -------------- -------------- -------------- --------------- COLLECTION PE~~;()NAL SERVICES.,.",..", 6D2 .49450.101 SALARIES - REGULAR H1PLOYE 11,517,76 12,854,71 7,558,91 14,517,43 37,679,00 48,665,OD *------------* 602,49450.121 FHA 459.44 582,92 330,41 532,10 1,259,00 2,180.00 *------------* 602.49450,122 SSA (FICA) 784.44 807,73 458.16 1,036,30 2,324,00 3,020.00 *------------* 602,49450,125 ~:[DICARE 10 ,31 188,91 107,29 242,35 546,00 100.00 *------------* 602,49450.131 HEAL TH INSURANCE 963.11 959,82 812,71 1,298,04 3,210,00 5,650,00 *------------* 602,49450,133 LIFE INSURANCE 16,42 9,13 5,51 9,69 22 .00 25,00 *------------* PERSONAL SERVICES..,........ TOTAL 13,151.54 15,403,88 9,213,11 11,635,91 45,040.00 60,240.00 0,00 SIIPPLIES Nm f.lA TERIALS.. .... . \49450,210 '--/Qf'ERAJING SUPPLIES 198,22 1,359,82 707.55 684,71 900,00 1,200,00 *------------* 602,49450,212 GAS - VEHICLE 954,95 803,31 801.08 0,00 0,00 *------------* *------------* 602.49450.218 DIESEL FUEL 319,58 450,40 455,98 0,00 0,00 *------------* *------------* 602,49450,220 REPAIR/MAItrr,SUPPLIES-GEN, 1,217.63 2,021.96 263.42 1,538.23 1,200.00 2,000,00 *------------* 602,49450,221 REPAIR/MAINT, SUPPLIES-VEH 612,48 2,455,68 651,49 0,00 0,00 *------------* *------------* 602.49450,224 REPAIR/MAINT SUPPLIES-STRE 214,08 133,96 1,676,98 209,01 2,000,00 2,000,00 *------------* 602,49450.240 SM/1lL TOOL S 156.05 217 ,98 0,00 0,00 400,00 500,00 *------------* SUPPLIES AND f.lATERIALS"",. TOTAL 4,332,99 1,443.11 4,556,50 2,431. 95 4,500,00 5,100,00 0.00 PURCHASEO SERVICES,.,.,.,.,. 602.49450,303 COI~SULTING ENGINEER-GENERA 498,52- 520,52 0,00 0,00 200.00 200,00 *------------* 602.49450.314 GOPHER STATE ONE CALL 1,232,15 294,90 120,39 523,12 1,150,00 1,150,00 *------------* 602.49450,316 CONTRACTUAL SEilER SYSm1 1,012,50 4,450,00 0,00 280,00 5,000,00 5,000.00 *------------* 602,49450.321 'TtLEPHCNE 0,00 0.00 0.00 0,00 110,00 110,00 *------------* '_!,49450 ,360 INSURANCE 841 ,36 950,71 2,225.00 136,00 136.00 800,00 *------------* 602,49450,381 ELECTRIC 0,00 0.00 51,50 201.55 0.00 500.00 *------------* : ) FINNICIAL SYSTEt~ CITY OF NmOVE ~ '__/06/93 12: 16: 12 Expenditure Budget Worksheet GL7A1R-V04,09 PAGE f- 9 SEilER FUND ---------------------ACTUAL ~JLLARS--------------------- --------------------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 193 REV BillGET 1994 PROPOSED 1994 REVISICN ------------- ------------- ----.-------- --------.----- ------.-.----- ----.-.------- ---------.----- COLLECTION PU~CHASED SERVICES""""" 602.49450,385 METROP, WASTE CWTROL CO~N 212,664,41 223,752,18 248,244,00 280,140,00 336,168,00 362,880.00 *------------* PURCHASEO SERVICES."""", 10ll.L 215,258,50 229,968.37 251,2ll0,89 281,880,67 343,964,00 371,240,00 0.00 OTHER SERVICES N~D CHARGES.. 602,49450,401 REPAIR/MAINT, LABOR-GENERA 1,849,25 4,473,55 77 8.4 5 1,301.54 5,000,00 5,000.00 *------------* 602,49450,403 REPAJR/MAINT LABOR - STREE 242,50 0,00 634,00 0,00 400,00 400,00 *------------* 602,49450,404 RLPAIR/MAINT, LABOR - IMf'R 731.50 2,000,00 594.01 190,00 2,000,00 2,000,00 *------------* 602,49450.405 REPAIR/MAINT, LABOR-VEHICL 0,00 1,378,16 1,276,00 0,00 0,00 *------------* *------------* 602,49450,410 RLNl ALS 0,00 109,80 118.64 18,43 970,00 970,00 *------------* . \49450.415 '~RENTAL OF CITY EC~IP 0,00 0.00 0,00 5,610,00 7,480.00 10,000.00 *------------* 602.49450,420 DE PR[CrATIa~ 190,015,44 195,438,60 199,449,89 0,00 0.00 *------------* *------------* 602,49450.433 DUf ~;jREGISTRATIONS 377 ,50 240,00 85,00 290.00 550,00 550,00 *------------* 602.49450,499 COrJTINGENCY 0,00 0.00 0,00 0,00 0.00 2,000,00 *------------* OTHER SERVICES mD CHARGES" lOIn 193,222,19 203,640,11 202,935,99 7,409,97 16,400,00 20,920,00 0,00 CAP IT AL OUT LA Y , .. .. .. .. .. .. , 602.49450,580 H~UIP~1ENT 0,00 25,50 0,00 17 ,435, 59 26,229,00 35,550,00 *------------* 602.49450,582 CAPITAL MAINTENANCE RESERV 0,00 0,00 0,00 0,00 0.00 10,000.00 *------------* CAP IT AL OUTLAy....,........, TOTAL 0.00 25,50 0,00 17,435,59 26,229,00 45,550,00 0,00 COLLECTION TOTAL 426,565,22 456,480,97 468,007,09 326,794,09 436,133,00 503,650,00 0.00 . ) ,~ . I FINNlCIAL SYSTEM CITY OF NJDOVER '--. ,j06/93 12: 16:12 Expenditure Budget Worksheet GL7A1R-V04,09 PAGE e.10 SEilER FUND ---------------------ACTUAL ~JLLARS--------------------- --------------------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BLOGET 1994 PROPOSED 1994 REVISICN ~------------ ------------- ------------- -------------- -------------- -------------- .-------------- SEilER ADMINISTRATION PERSONAL SERVICES""""". 602.49490,101 SALARIES - REGULAR EMPLOYE 14,031.94 20,004,33 22,074,30 23,945,86 32,675,00 35,000,00 *------------* 602.49490.121 F'ERA 641. 60 814,68 952,59 1,072,80 1,464,00 1,570,00 *------------* 602,49490.122 SSA (FICA) 1,101.60 1,091.88 1,292,57 ',445,75 2,026,00 2,170.00 *------------* 602,49490,125 ~\EDICARE 0,00 263,88 311. 56 338,08 474,00 510,00 *------------* 602.49490,131 HEAL TH INSURNKE 1,344,05 1,711.79 1,906,83 1,995,83 2,625,00 3,150,00 *------------* 602,49490.133 LIFE INSURNKE 19.50 12,93 13 .92 13,63 18,00 25.00 *------------* PERSONAL SERVICES..,....,.., TOTAL 17,138.69 23,899,49 26,551.77 28,811.95 39,282,00 42,425,00 0.00 SUPPLIES Nm MA.TERIALS...... \49490.201 '- ./GENERAL OFfICE SUPPLIES 510.33 721,69 625,17 518,38 1,100,00 1,100,00 *------------* 602,49490.210 OPERATING SUPPLIES 0.00 0.00 0.00 0,00 200,00 200.00 *------------* 602,49490,220 REPAIR/MAINT,SUPPLIES-GEN, 0,00 0.00 0,00 0,00 100.00 100,00 *------------* SUPPLIES AND MA.TERIALS, "". TOTAL 510.33 721.69 625,17 518.38 1,400,00 1,400,00 0.00 PURCHASED SERVICES.."",." 602,49490.301 PROFESSIa~Al. SERVICES 0,00 1,234,00 1,625,00 2,001. 11 2,000,00 4,000,00 *------------* 602.49490,303 CONSULTING ENGINEER-GENERA 0.00 63,47 0.00 0,00 200,00 200,00 *------------* 602,49490.322 POST AG E 1,485.43 1,363,83 1,438,24 1,570,35 2,000,00 2,000,00 *------------* 602,49490,330 TRN1SPORTATIa~ 7.14 10,32 259.56 30,70 600.00 600.00 *------------* 602.49490,351 PUBLISHING 35,00 22,50 5,91 97,60 50,00 400.00 *------------* 602.49490,352 PRINTING 0.00 0,00 0,00 0.00 150,00 150.00 *------------* 602,49490,353 PUBLICATIONS 0,00 0,00 0,00 0.00 50,00 100,00 *------------* 602,49490,360 , .INSURANCE 242,10 291,38 0,00 460,00 460,00 500,00 *------------* ,_ ..,.CHASED SERVICES.......... TOTAL 1,769,67 2,985,50 3,328,71 4,159,76 5,510,00 7,950,00 0,00 . \ FINANCIAL SYSTEM '-_f06/93 12: 16: 12 Expenditure Budget Worksheet CITY OF mCOVEF GL7A lR-V04.09 PAGE IS 11 SEilER FUND ---------------------ACTUAL DOLLARS--------------------- --------------------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 193 REV BLOGET 1994 PROPOSED 1994 REVISICN -------.----- ------------- ------------- -------------- -------------- -------------- --------------- SEilER ADMINISTRATION OTHER SERVICES P~D CHARGES,. 602.49490,401 REPAIR/MAINT, LABOR-GENERA 56,81 86,43 60.03 58.48 200,00 300.00 *------------* 602,49490,406 CONTRACTI.lAL SERVICES 0.00 214,50 643.50 0.00 1,000,00 1,000,00 *------------* 602.49490,410 RENT ALS 0,00 0,00 0,00 0,00 0,00 *------------* *------------* 602.49490.433 DUES/REGISTRATIONS 60,00 14.00 92,50 192,50 300.00 300,00 *------------* 602.49490,442 ~'E AL S/LODGING 0,00 0,00 0.00 0.00 100.00 100,00 *------------* 602,49490,499 CONTINGENCY 0.00 0,00 0,00 0,00 745,00 1,445,00 *------------* OTHER SERVICES />NO CHARGES" lUlt.L 116,81 314.93 796,03 250.98 2,345.00 3,145,00 0,00 _ r ~P IT AL OUTLAy,..,.,.""... \ ., ;.49490.5CO - FURNITURE 0.00 0,00 167,50 0.00 600,00 600,00 *------------* 602.49490,570 OFf ICE EQUIP~lENT 0,00 0,00 224,70 1,000,00 1,000.00 3,000,00 *------------* 602.49490,712 TRfNSFER-CERT OF INDEST FU 0,00 37,630,00 37,630,00 0,00 37,630.00 37,630.00 *------------* 602.49490,727 TRtNSFER TO OTHER FUNDS 0,00 0.00 10,000,00 0.00 0,00 *------------* *------------* CAPITAL OUTLAy.............. TOTAL 0,00 37,630,00 48,022,20 1,000.00 39,230,00 41,230,00 0,00 SEilER ADMINISTRATION TOTAL 19,535,50 65,551,61 79,323.88 34,741.07 87,767,00 96,150,00 0.00 SEilER FUND TOTAL 446,468.83 522,032,58 547,330,97 361,535.16 523,900,00 599,800,00 0,00 j i:J ~) ,- " ,--) 1994 SEWER Department Administration Request Description Furniture Estimated Amount Work Station for Secretary $600 Office Equipment 1/2 of phone System Transfer-Cert. of Indept. Fund Collection Equipment 3/4 Ton 4X4 Pickup 1/2 of 6" Water & Sewer pump 2 Portable Radios Backup pump for Lift Station 1/2 Hyd. Jack Hammer TOTAL $3,000 $37,630 $25,000 $5,000 $1,800 $2,500 $1,250 $35,550 ~.J SECTION 4 LOWER RUM () RIVER WATER MANAGEMENT ORGANIZATION FUND (~.R.It.~.~.().) :--J ,. '. , BRC FINNJCIAL SYSTEM 11/06/93 16:08:52 Revenue Budget lIor-ksheet cm OF ANDOVER GL7A1R-V04,09 PAGE f..- 1 - '~R RUM RIVER \lATER MGMT o ---------------------ACTUAL ~JLLARS--------------------- ------------~-------BUDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 11-30-1993 193 REV BL~GET 1994 PROPOSED 1994 REVISlaJ ------------- ------------- ------------- -------------- -------------- -------------- --------------- 226,31010 CURRENT AD VALOREM TAXES 0,00 0,00 226.31020 DELINQUENT AD VALOREM TAXE 0,00 0.00 226,31040 fI~:AL DISPARITIES 0,00 0.00 226,33402 HO~\ESTEAD AND ~,G. CREDIT A 0,00 0,00 226,33425 EQUALIZATIal AID 0,00 0.00 226,36210 INTEREST EARNED 418,82 1,240,95 LOWER RUM RIVER \lATER MGMT TOTAL 418,82 1,240.95 u - '. \--..-/) 8.994.00 9,386,00 *------------* 0,00 5,381.30 0,00 49,32 0,00 *------------* *------------* 0,00 767,61 2.841.00 2.841,00 *------------* 0,00 1,743,12 3,470.00 3,470,00 *------------* 0,00 198,02 392.00 *------------* *------------* 590,21- 15,82 200.00 200,00 *------------* 590,27- 8,155,19 15,897,00 15.897,00 0,00 '\ BRC FINANCIAL SYSTEM 11/06/93 16:39:51 Expenditure Budget Worksheet CITY OF ANDOVH GL1A1R-V04,09 PAGE E'1 -SR RUM RIVER \lATER ~lGMT '-J ---------------------ACTUAL DOLLARS--------------------- --------------------BLOGETS------------------- 12-31-1990 12-31-1991 12-31-1992 11-30-1993 '93 REV BLOGET 1994 PROPOSED 1994 REVISIal ------------- ------------- ------------- -------------- -------------- -------------- .-------------- ENGINEERING PERSONAL SERVICES""""", 226,42000,101 SALARIES - REGULAR nlPLOYE 0.00 0,00 0.00 B.14B,1B B,645.00 B,639,OO *------------* 226,42000,121 PERA 0,00 0,00 0.00 365,06 3B1,OO 3B1,OO *------------* 226.42000,122 S5A (F leA) 0,00 0,00 0,00 529.01 535,00 535.00 *------------* 226,42000.125 ~~DICARE 0,00 0,00 0,00 123,19 125.00 125.00 *------------* 226.42000,131 HEAL TH IN5URNKE 0,00 0,00 0,00 360,31 540.00 546,00 *------------* 226,42000,133 LIFE IN5URNKE 0.00 0.00 0,00 3,16 5,00 5,00 *------------* 226,42000,201 GENERAL CHICE SUPPLIES 0,00 0.00 0,00 106,50 0,00 *------------* *------------* 226.42000,210 OPERATING SUPPLIES 0,00 0,00 0,00 13 1. 96 200.00 200,00 *------------* 226,42000,454 LOItER RU~1 RIVER 0,00 0,00 0.00 5,304,16 5,460,00 5,460,00 *------------* , ~)ONAL SERVICES.." ,." ." 0,00 0,00 0.00 15,073,33 15,B91,OO 15,891,00 0,00 TOTAL ENGINEERING TOTAL 0,00 0,00 0,00 15,073,33 15,897,00 15,897.00 0.00 LOWER RUM RIVER WATER MGMT TOTAL 0,00 0,00 0,00 15,013,33 15,B91.00 15,B91,OO 0,00 ,-J .~) SECTION 5 CENTRAL CJ EQUIPMENT FUND Q BRC FINNJCIAL SYSTEM 11/06/93 15:17:41 , 'TRAL EQUIPMENT FUND 'J Revenue Budget Worksheet CITY OF NmOVE~ GL7A lR-V04 ,09 PAGE 1'-' 1 ---------------------ACTUAL COjLLARS--------------------- --------------------Bl~GETS------------------- 12-31-1990 12-31-1991 12-31-1992 11-30-1993 '93 REV BlOGET 1994 PROPOSED 1994 REVISIal ------------- ------------- ------------- -------------- .------------- -------------- --------------- 702,36210 INTE RE ST EARNED 702,36260 REFUNDS N1D REIfillURSEMENTS 702,38400 EQUIPMENT RENTALS 702,39201 TRNlSFERS FROM OTHER FUNDS 702,39400 USE OF WORKING CAPITAL CENTRAL E~rlJIPMENT FUND TOTAL \ ,,--) ,_ J 0,00 0.00 0,00 0.00 0.00 0,00 0,00 0,00 0.00 0,00 0,00 0.00 0,00 0,00 0,00 50,000,00 0,00 50,000,00 1,153.57 0,00 107,961. 00 0,00 0,00 109,114,57 2,000.00 2,000,00 *------------* 0,00 *------------* *------------* 143,948,00 166,770,00 *------------* 0,00 *------------* *------------* 10,000,00 *------------* *------------* 155,948,00 168,770,00 0,00 - 's FINNjCIAL SYSTEM CITY OF mDOVER " ~ (/06/93 12:25:24 Expenditure Budget Worksheet GL7A1R-V04,09 PAGE ~- 1 GENERAL FUND ---------------------ACTUAL vJLLARS--------------------- --------------------BUDGETS------------------- 12- 31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BUDGET DEPT REQUEST 1994 PROPOSED ------------- ------------- ------------- -------------- -------------- -------------- -.------------- ADMINISTRATION OTHER SERVICES NjD CHARGES., 101.41430,415 RENTAL OF CITY EQUIP 0,00 0.00 0,00 0,00 0.00 ',000,00 ',000,00 OTHER SERVICES N1D CHARGES" TOTAL 0,00 0,00 0.00 0.00 0,00 1,000,00 1,000,00 ADMINISTRATION TOTAL 0.00 0,00 0,00 0,00 0,00 1,000,00 1,000,00 FINANCIAL ADMINISTRATI0I1 OTHER SERVICES NID CHARGES., 101.41530,415 RENTAL OF CITY EQUIP 0,00 0.00 0,00 0,00 0.00 ',000,00 1,000,00 OTHER SERVICES AND CHARGES,. TOTAL 0.00 0,00 0,00 0,00 0,00 ',000,00 1,000,00 FINANCIAL ADMINISTRATION TOTAL 0.00 0,00 0,00 0,00 0,00 1,000,00 1,000,00 \'r~AljNING N1D ZONING OlHER SERVICES A~D CHARGES" '01.41910.415 RENTAL OF CITY EQUIP 0,00 0.00 0.00 0.00 0.00 3,000,00 1,000,00 OTHER SERVICES N1D CHARGES,. TOTAL 0,00 0,00 0,00 0,00 0,00 3,000,00 1,000,00 PLANNING N1D ZONING TOTAL 0,00 0,00 0,00 0,00 0,00 3,000,00 1,000.00 ENGINEERING OTHER SERVICES AND CHARGES., 101.42000.415 RENTAL OF CITY EQUIP 0,00 0.00 0,00 945,00 1,260,00 ',400,00 1,400,00 OTHER SERVICES AND CHARGES" TOTAL 0,00 0,00 0,00 945,00 1,260,00 1,400.00 1,400,00 ENGINEERING TOTAL 0,00 0.00 0,00 945,00 1,260,00 1,400,00 ',400,00 FIRE PROTECTICN OTHER SERVICES f~D CHARGES., 101.42200,415 RENTAL OF CITY EQUIP 0,00 0,00 0,00 31,920.00 42,560,00 53,770.00 53,770,00 OTHER SERVICES N1D 01ARGES, , TOT AL 0.00 0,00 0,00 31,920,00 42,560,00 53,770,00 53,770,00 . - '~E PROTECTICN "- ) TOTAL 0,00 0.00 0.00 31,920,00 42,560,00 53,770.00 53,770,00 _ ) FIN/>NCIAL SYSTEM CITY OF ANDOVER " '/06/93 12: 25 :24 Expenditure Budget Worksheet GL7A1R-V04,09 PAGE 0- 2 GENERAL FUND ---------------------ACTUAL DOLLARS--------------------- --------------------Bl~GETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BLOGET DEPT RE~~JEST 1994 PROPOSED ------------- ------------- ------------- -------------- -------------- -------------- --------------- RESCUE SERVICE OTHER SERVICES N1D CHfRGES,, 101.42270,415 RENTAL OF CITY E~JIP 0.00 0,00 0,00 5,025,00 6,700,00 *------------* *------------* OTHER SERVICES AND CHARGES,. TOTAL 0.00 0,00 0,00 5,025,00 6,700,00 0,00 0,00 RESCUE SERVICE TOTAL 0,00 0,00 0.00 5,025,00 6,700,00 0,00 0,00 PROTECTIVE INSPECTION OTHER SERVICES NJD CHARGES., 101,42400.415 RENTAL OF CITY E~JIP 0,00 0,00 0.00 3,318.50 4,425,00 5,000.00 5,000.00 OTHER SERVICES N1D CHARGES" TOT AL 0.00 0,00 0,00 3,318.50 4,425.00 5,000.00 5,000,00 PROTECTIVE INSPECTION TOTAL 0.00 0,00 0.00 3,318,50 4,425.00 5,000.00 5,000.00 " , <ETS AJ1D HIGHWAYS - / OTHER SERVICES AND CHARGES., 101,43100,415 RENTAL OF CITY EQUIP 0,00 0.00 0,00 18,787,00 25,050,00 27,550.00 27,550.00 OTHER SERVICES N1D CHARGES" T01ft 0.00 0,00 0,00 18,787.00 25,050,00 27,550.00 27,550,00 STREETS AND HIGHWAYS TOTAL 0,00 0.00 0,00 18,781,00 25,050,00 27,550,00 21,550,00 SNOW />ND ICE REMJVAL OTHER SERVICES N1D CHARGES., 101.43125.415 RENTAL OF CITY EG~IP 0,00 0,00 0,00 23,152,00 30,870.00 34,000.00 34,000,00 OTHER SERVICES AND O,ARGES.. TOTAL 0,00 0,00 0.00 23,152,00 30,870,00 34,000,00 34,000,00 SNOW />ND ICE REMJVAL TOT AL 0,00 0,00 0,00 23,152.00 30,810.00 34,000.00 34,000,00 STORM SEllERS OTHER SERVICES AND CHARGES., 101.43150,415 RENTAL OF CITY EQUIP 0,00 0.00 0,00 1,913,50 2,551,00 2,800,00 2,650,OC 01l1ER SERVICES AND CHARGES., TOTAL 0,00 0.00 0,00 1,913,50 2,551.00 2,800,00 2,650.0C STORM SEllERS "J TOTAL 0,00 0,00 0,00 1,913,50 2,551.00 2,800,00 2,650.0C " FIN~NCIAL SYSTEM \'~(\J6/93 12:25:24 GENERAL FUND Expenditure Budget Worksheet CITY OF mCOVER GL7A 1R-V04.09 PAGE 1;- 3 ---------------------ACTUAL OOLLARS--------------------- --------------------BlOGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 193 REV BUDGET OEPT REQUEST 1994 PROPOSED ------------- .------------ ------------- -------------- -------------- -------------- --------------- STREET SIGNS OTHER SERVICES !>NO CHARGES" 101.43170,415 RENTAL OF CITY EQUIP OlljER SERVICES !>NO CHARGES" TOTAL STREET SIGNS TOTAL PARK ANO RECREATI~l OTHER SERVICES NJO CH~RGES., 101.45200.415 RENTAL OF CITY EQUIP OTHER SERVICES NlO CHARGES,. TOTAL PARK NlO RECREATI~J TOTAL "- , /0 PRESERVATION & MAINT, (JIHER SERVICES !>NO CHARGES.. 101.46102.415 RENTAL OF CITY E~~IP OTHER SERVICES ANO CHARGES" TOTAL TREE PRESERVATICN & MAINT, TOT AL WEED CCmROL OTHER SERVICES ~NO CH~.RGES., 101.46103,415 RENTAL OF CITY EQUIP OmER SERVICES mo CHARGES., TOTAL WEED CONTROL TOTAL RECYCLING OTHER SERVICES !>NO CHARGES" 101.46140.415 RENTAL OF CITY E~JIP OmER SERVICES NJO CHARGES,. TOTAL RECYCLING "0 GENERAL mm TW,L 101AL 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0.00 0,00 0,00 0,00 0.00 0,00 0,00 0,00 0,00 0.00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0.00 0,00 0,00 0,00 0.00 0,00 0,00 0,00 0,00 0,00 0.00 0,00 0.00 0,00 0.00 0,00 0,00 0.00 0.00 0.00 0,00 0,00 0,00 0.00 736.00 736,00 736,00 11,963,00 11,963,00 11,963,00 242.50 242.50 242,50 242,00 242,00 242,00 75,00 75,00 75,00 98,319,50 982,00 982,00 982.00 15,950,00 15,950,00 15,950,00 323 .00 323,00 323.00 322.00 322,00 322,00 100.00 100,00 100,00 131,093.00 3,600,00 3,600,00 3,600,00 17 ,500 ,00 17 ,500,00 17,500,00 350.00 350.00 350.00 3 50,00 350,00 350,00 200,00 200.00 200,00 151,520.00 3,000,00 3,000,00 3,000,00 17,500,00 17,500,00 17,500.00 350.00 350,00 350,00 350,00 350.00 350,00 200,00 200,OC 200,OC 148,770,O( . '~FINANCIAL SYSTEM '-, (/06/93 12:25:24 Expenditure Budget Worksheet CITY OF ANC'JVER GL7A1R-V04,09 PAGE D,4 \lATER FUND ---------------------ACTUAL ~JLLARS--------------------- --------------------BL~GETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV SL~GET DEPT REQUEST 1994 PROPOSED ------------- ------------- ------------- -------------- -------------- -------------- --------------- D ISTR IS UTION OTHER SERVICES HID CHARGES" 601.49430,415 RENTAL OF CITY EG.~IP 0,00 0,00 0,00 4,031.50 5,375,00 *______nn__* 8,000.00 OTIjER SERVICES AND CHARGES., TOU.L 0,00 0,00 0,00 4,031.50 5,375,00 0,00 8,000,00 DISTRIBUTION TOTAL 0,00 0,00 0,00 4,031. 50 5,375,00 0,00 8,000,00 \lATER F LNG TOTAL 0,00 0,00 0,00 4,031. 50 5,375.00 0.00 8,000,00 ~J , ,---) . '; FINANCIAL SYSTEM ", ,/06/93 12:25:24 Expenditure Budget Worksheet CITY OF NmOVEI GL1A 1R-V04 ,09 PAGE '!l- ~ SEWER FUND ---------------------ACTUAL ~JLLARS--------------------- --------------------BUDGETS------------------. 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BL~GET DEPT RE~~EST 1994 PROPOSED _____________ _____________ _____________ ______________ ._____________ ______________ --------______0 COLLECTION OTHER SERVICES N1D CHARGES., 602.49450,415 RENTAL OF CITY EQUIP 0,00 0,00 0.00 5,610,00 7,480,00 *------------* 10,000,00 OTHER SERVICES N1D 01ARGES,. TOTAL 0,00 0,00 0.00 5,610,00 7,480.00 0,00 10,000,00 COLLECTION TOTAL 0,00 0,00 0,00 5,610,00 7,480,00 0.00 10,000.00 SEWER FUND TOTAL 0,00 0,00 0.00 5,610,00 7,480,00 0,00 10,000,00 \ ,~ ~_J , -J FINANCIAL SYSTEM ',,/06/93 12:25:24 Expenditure Budget Worksheet CITY OF ANDOVER GL7A 1R-V04 ,09 PAGE) - 6 ---------------------ACTUAL DOLLARS--------------------- --------------------BLOGETS------------------- 12-31-1990 12-31-1991 12-31-1992 10-31-1993 '93 REV BUDGET DEPT RE~JE5T 1994 PROPOSED ------------- ------------- .------------ .------------- -------------- .------------- --------------- GRNW TOTAL 0,00 0,00 0,00 101,961,00 143,948,00 151,520.00 166,110,00 TOTAL NUMBER OF RECORDS PRINTED 11 : .) ~ ~'--) BRC FINN1CIAL SYSTEM CITY OF N1DOVE R 11/06/93 15: 15:56 Expenditure Budget Worksheet GL1A lR-V04.09 PAGE f-1 - 'TRAL EQUIPMENT FUNO " ) ---------------------ACTUAL DOLLARS--------------------- --------------------BLOGETS------------------- 12-31-1990 12-31-1991 12-31-1992 11-30-1993 '93 REV BLOGET 1994 PROPOSED 1994 REVISICtl ~------------ ------------- ------------- -------------- -------------- -------------- --------------- EQUIPMENT MAINTENANCE PERSONAL SERVICES......,.... 102.49950,101 SALARIES - REGULAR EMPLOYE 0,00 0,00 0,00 21,215,91 26,168,00 33,645,00 *------------* 102,49950,121 PERA 0.00 0,00 0,00 934,33 1,029.00 1,510.00 *------------* 102.49950,122 SSA (FICA) 0,00 0,00 0.00 1.405,36 1,424,00 2,090,00 *------------* 102,49950,125 ~\[ OICARE 0,00 0,00 0.00 328,10 333,00 490,00 *------------* 102,49950,131 HEAL TH INSURN1CE 0,00 0,00 0,00 2.351.06 2,150,00 3,800.00 *------------* 102,49950.133 LIFE INSURN1CE 0,00 0,00 0,00 15,30 18.00 25,00 *------------* PERSONAL SERVICES".,.,..", TOTAL 0.00 0,00 0,00 26,256,12 31,122,00 41.560.00 0,00 SUPPLIES AND MATERIALS",.., 102,49950,201 GENERAL OFFICE SUPPLIES 0,00 0.00 0,00 19.65 0.00 100,00 *------------* . '\49950,210 '-lof'ERATING SUPPLIES 0.00 0,00 0,00 3.299,53 3.600,00 2,600,00 *------------* 102,49950,212 GAS - VEHICLE 0.00 0,00 0.00 2,654,35 10.426,00 11.000.00 *------------* 102.49950,218 DIESEL FUEL 0,00 0,00 0,00 6.690,55 15.120,00 16,500,00 *------------* 102,49950,220 REPAIR/MAINT,SUPPLIES-GEN, 0,00 0.00 0,00 491,51 600.00 *------------* *------------* 102,49950,221 REPAIR/MAI~n, SUPPLIES-VEH 0,00 0,00 0,00 30,385,42 44.291.00 45,000.00 *------------* 102.49950,240 S~\AL L TOOL S 0,00 0,00 0,00 1,421.89 1,500,00 '.000,00 *------------* SUPPLIES N1D MATERIALS. ."., TOTAL 0.00 0,00 0,00 44,968,96 16,131,00 16,200,00 0,00 PURCHASED SERVICES""",." 102,49950,360 INSURANCE 0,00 0.00 0,00 15,409.00 11,180,00 18.500.00 *------------* PURCHASED SERVICES,.,.."", TOT AL 0.00 0.00 0,00 15.409,00 11,180,00 18,500,00 0,00 OTHER SERVICES N1D CHARGES,. 102,49950,401 REPAIR/MAINT, LABOR-GENERA 0,00 0,00 0,00 51. 50 0,00 *------------* *------------* 102.49950.405 , ~EPAIR/MAHH, LABOR-VEHICL 0.00 0,00 0,00 15,305,15 16,100,00 16,100,00 *____________1 . ) \.~,/.49950 ,406 CONTRACTUAL SERVICES 0,00 0,00 0,00 350,00 500.00 500,00 *____________1 BRC FINN1CIAl SYSTEM 11/06/93 15:15:56 'TRAl EQUIPMENT FUND , ) EQUIPMENT MAINTENNJCE OTHER SERVICES #lD CHARGES,. 102,49950.409 INSPECTIONS/EMISSIC~S TEST 102.49950,410 RENTALS 102.49950.433 OUES/REGISTRATIONS 102,49950.499 CONTINGENCY OTHER SERVICES NJD CHARGES,. TOTAL CAPITAL OUTLAy"".....,..., 102,49950,530 mPROVEMENTS 102.49950.580 EQUI P~\HH CAP IT Al OUTLAy,............, TOTAl EQUIPMENT MAINTENNH '\ . ) ,~ TOTAL CENTRAL EQUIPMENT FUND TOT Al ", , ) -...J Expenditur-e Budget Worksheet CITY OF N100VER GL1A1R-V04,09 PAGE f_2 ---------------------ACTUAl DOllARS--------------------- --------------------6UDGETS------------------- 12-31-1990 12-31-1991 12-31-1992 11-30-1993 '93 REV BUDGET 1994 PROPOSED 1994 REVISION ------------- ------------- ------------- .------------- .------------- -------------- --------------- 0,00 0,00 0,00 72. 00 100,00 100,00 *------------* 0.00 0.00 0,00 0,00 0,00 *------------* *------------* 0,00 0,00 0,00 55,00 100,00 100,00 *------------* 0,00 0.00 0,00 0,00 13,509,00 *------------* *------------* 0,00 0,00 0,00 15,833,65 30,309.00 16,800,00 0,00 0.00 0.00 0,00 0,00 0,00 *------------* *------------* 0,00 0.00 0,00 0.00 0,00 15,110.00 *------------* 0,00 0,00 0.00 0,00 0,00 15,110,00 0,00 0,00 0,00 0,00 102,468,33 155,948,00 168,110,00 0,00 0,00 0.00 0,00 102,468.33 155,948.00 168,110.00 0.00 (J , -~ ) 1994 CENTRAL EQUIPMENT Department Request Description Estimated Amount Maintenance Improvements Inside/Outside Oil Drain To Outside Tank $500 Pneumatic Grease Unit $2,000 $2,500 Equipment Transmission Jack $500 2 Ton Floor Jack $100 10 Ton Bottle Jack $60 Battery & starter Draw Tester $2,000 Bushing Driver Set $300 $400 $3,000 $2,300 $50 $1,000 $6,000 Wheel Dolly Misc. Hand Tools Wire Feed Welder Car Ramps Gauge Test Set 5 Ton Trailer Hoist TOTAL $15,710 I /-" :", ) CITY OF ANDOVER REQUEST FOR COUNCIL ACTION - DATE N'n'uArnh~.... 1 e;. . Hlln AGENDA r--n SEClION ORIGINATING DEPARTMENT Administration APPROVED FOR AGENDA ITEM 1\0. Authorize spacial Needs Analysis Consultant Search Daryl E. sUlande~ 8Y~~ Acting Administrator ~~ 4. REQUEST The Andover City council is requested to approve the solicitation of a consultant to conduct a needs analysis for the proposed expansion of the City Hall and Public Works facilities. BACKGROUND ..~' The public Works open house July 22nd provided an opportunity for the Council to view the City equipment and Public Works buildings. The presentation outlined proposed improvements to the Public works garage and the equipment building. The $37,000.00 request for improvements to both buildings were removed from the proposed 1994 General Fund budget due to fiscal constraints. These improvements do not increase the actual size of either building. Expansion of both the storage and office areas needs to be planned to adequately house and maintain the City's maintenance equipment fleet. The City Hall building is also at capacity. The ad hoc committee for City Hall expansion met on Thursday, October 28th to discuss the staffing, office and storage needs for the next five to ten years. Architectural style was not discussed, but construction options were. It was decided to return to the full Council with a request f6r soliciting professional services to conduct a needs analysis. /'- MOTION BY: SECOND BY: ,---.. \..../ TO: