Loading...
HomeMy WebLinkAboutBudget FY 1991-1992CITY OF LODl CITY OF LODl CITY OF LODI CITY OF LODl 07: 7 l.991 - 1992 BUDGET CITY OF LODI CALIFORNIA AS APPROVED BY THE MAYOR AND CITY COUNCIL /- CITY c7F LODl CITY OF LODI CALIFORNIA 1991 -92 CITY COUNCIL DAVID M. HINCHMAN MAY OR JAMES W. PINKERTON, JR. JACK A. SIEGLOCK Mayor Pro Tempore Member, City Council PHILLIP A. PENNINO JOHN R. (RANDY) SNIDER Member, City Council Member, Ci ty Counci 1 COUNCIL APPOINTEES City Manager ......................... Thomas A. Peterson City Attorney ............................. Bob W. McNatt City Clerk ............................. Alice M. Reimche ADMINISTRATIVE OFFICERS Administrative Assistants Kirk J. Evans to the City Manager ................. Janet S. Keeter Assistant City Manager ................... Jerry L. Glenn Comnunity Center Director ............. Charlene J. lange Community Development Director ....... James B. Schroeder Electric Utility Director ................. Henry J. Rice Finance Director/Treasurer ............... Robert H. Holm Fire Chief .............................. Larry F. Hughes Librarian .......................... Leonard L. Lachendro Parks and Recreation Director.... ..Ronald W. Williamson Personnel Director. ................... Joanne M. Narloch Police Chief .......................... Floyd A. Williams Public Works Director .................... Jack L. Ronsko STATISTICS AND INFORMATION The City of Lodi was incorporated under the General Laws of the State of California on December 6, 1906. Area: 10.70 square miles . State Estimate . 1987 .... 45,794 State Estimate 1988.. .48,042 mate - 1982.. .36,928 State Estimate - 1983 .... 38,318 . . State Estimate . 1984 .... 39,475 State Estimate 1989.. ..49,221 State Estimate . 1985 .... 41,281 Federal Census - 1990 .... 50,328 State Estimate - 1986 .... 43,293 State Estimate - 1991 .... 52,539 . ORG4NIZAlION CHART ELECTORATE I I 1 I I I I I I I I I ! I t-----’ I I I 4A I I I I I 1 1 I DEPARTMEKIS oPERAT~HC COUHUN 11 V OEVELOPMENT ELECTRIC PUBL 1 c ’ ’ COUWNI TV POL ICE FIRE FlVAHCE UlILITV CEN~ER PARKS AN0 LIBRARV F4ECREAlION DIRECTOR OIRECTOR CHIEF 3 IRE: TOR 01 RECT CR OIRECTOR OIRECTOA CHIEF TABLE OF CONTENTS FUND SUMMARIES !I I! i; i: Total General Budget - Schedule A. . . . . . . . . . . 1 General Fund - Schedule B. . . . . . . . . . . . . . . 2 Electric Utility Fund - Schedule C . . . . . . . . . . 3 Sewer Utility Fund - Schedule 0. . . . . . . . . . . . 4 lj I ,a I I Water Utility Fund - Schedule E. . . . . . . . . . . . 5 Library Fund - Schedule F. . . . . . . . . . . . . . . 6 Community Center - Schedule G. . . . . . . . . . . . . 7 Financing Resources - Schedule H . . . . . . . . . . . 9 Special Revenue Funds - Schedule I . . . . . . . . . . 17 Summary of Operating Budgets by Departments - I Schedule J . . . . . . . . . . 23 Schedule K . . . . . . . . . . 65 Public Liability Insurance Reserve - Schedule L. . . . 66 Workers' Compensation Insurance Reserve - Schedule M . 67 Wastewater Capital Outlay - Schedule N . . . . . . . . 71 Chiropractic Self-Insurance Fund - Schedule 0. . . . . 73 Dental & Long-Term Disability Insurance Reserves - I I i Page CITY MANAGER'S BUDGET MESSAGE. . . . . . . . . . . . . . . . M 1 - M 30 *’.: ! C7TY OF LOU7 Ij 11 TABLE OF CONTENTS 1991-92 BUDGET OPERATING BUDGET DETAIL (continued) Page Public Works Department ........... 31 Refuse Collection. .............. 26 Risk Management. ............... 27 Sewer Utility Fund .............. 43 Special Payments - Administration. ...... 26 Water Utility Fund .............. 45 i/ OTHER BUDGETS Equipment Purchases. ............. 49 City of Lodi Personnel ............ 53 Self-Insurance Funds:. ............ 65 -73 Chi roprac tic Dental Insurance Long-Term Di sabi 1 i ty Medical Public Liability Risk Management Workers’ Compensation Summary of Electric Utility Budgets. ..... 62 Summary of Utility Outlay Budget ....... 63 Electric Utility Outlay Budget Detail. .... 59 iii TABLE OF CONTENTS BUDGET MESSAGE 1991-92 Introduction . . . . . . . . . . . . . . . . . . . . . M-1 to M-3 OPERATING REVENUES A. Property Tax . . . . . . . . . . . . . . . . . . . . . M-6 B. Sales Tax Revenue. . . . . . . . . . . . . . . . . . . M-6 C. Other Taxes. . . . . . . . . . . . . . . . . . . . . . M-7 D. Licenses, Fines and Use of Property. . . . . . . . . . M-7 E. Interest ....................... M-8 F. Revenue From Other Agencies. . . . . . . . . . . . . . M-8 G. Service Charges. . . . . . . . . . . . . . . . . . . . M-9 H. Other Revenues . . . . . . . . . . . . . . . . . . . . M-9 I. Revenues From Utility Operations . . . . . . . . . . . M-9 J. Interfund Transfers. . . . . . . . . . . . . . . . . . M-10 I CONTRIBUTIONS FROM OTHER FUND RESERVES. . . . . . . . . . . . . M-10 I OPERATING EXPENSES 100 Series - Personnel Services. . . . *. . . . . . . . . . M-12 200 Series - Utility, Communications & Transportation. . . M-12 300 Series - Supplies and Materials. . . . . . . . . . . . M-13 400 Series - Depreciation. . . . . . . . . . . . . . . . . M-13 500 Series - Equipment, Land & Structures. . . . . . . . . M-14 600 Series - Special Payments. . . . . . . . . . . . . . . M-14 BUDGET FUNDS General Fund. . .. . .. ... ... .. ........ M-17 Electric Fund. . . . . . . . . . . . . . . . . . . . . . . M-21 Sewer Fund . . . . . . . . . . . . . . . . . . . . . . . . M-23 Water Fund . . . . . . . . . . . . . . . . . . . . . . . . M-25 Library Fund. . . . . . .. .. . .. .. ... .. .. .M-26 Community Center . . . . . . . . . . . . . . . . . . . . . M-27 BUDGET SUMMARY . . . . . . . . . . . . . . . . . . . . . . . . M-29 I iv CITY C'F LUV1 \ 1991 - 1992 CLASSIFICATIONS OF EXPENDITURE ACCOUNTS ,-- /- C7T1' CF LOD7 CLASSIFICATIONS OF EXPENDITURE ACCOUNTS Personnel Services 10 1 102 103 111 112 113 114 115 121 122 123 124 125 126 127 198 Salaries and Wages Educational Incentive Administrative Leave Compensation Insurance Medical Insurance Dental Insurance Vision Care Medicare Insurance Service Contribution PERS Social Security Payments Deferred Compensation LTD/ L I Unemployment Insurance Temporary Di sabi 7 i ty Permanent Di sabi 1 i ty Overhead Workers' Compensation Workers' Compensation Utilities & Communications 201 Postage 202 Telephone & Telegraph 211 Electricity 212 Gas 213 Water 214 Sewer 215 Refuse Suppl i es, Materi a1 s and Services 301 302 303 304 305 306 307 308 309 310 311 3 12 313 3 14 3 15 316 Printing, Binding and Duplicating Photocopying Advertising Laundry and Drycleaning Uniforms Safety Equipment Office Supplies Books and Periodicals Memberships and Dues Uncol 1 ecti bl e Accounts Expense Coll ecti on Agency Fees Bank Service Charges Data Processing Software Business Expense Conference Expense Au tomobi 1 e A1 1 owance 32 1 3 22 323 324 325 326 330 331 332 333 334 335 336 34 1 342 343 344 3 45 350 351 3 52 353 354 355 356 357 358 359 360 361 362 363 365 399 Rental of Land and Facilities Rental of Equipment Professional Services Purchased Transportation - Purchased Transportation - Purchased Transportation-Taxis Repairs to Communication Repairs to Machinery & Equipment Repairs of Office Equipment Repairs to Auto Equipment Repairs to Buildings Sublet Service Contracts Car Wash Fire Insurance Surety Bonds PL & PD Insurance Travel Insurance City Rental Insurance Fees Tires and Tubes Motor Vehicle Fuel and Lube Special Department Materials Janitorial Supplies Photo Supplies General Suppl ies Medical Supplies Care of Prisoners Training and Education Small Tools and Equipment Overtime Meals Employee Relations Laboratory Suppl ies Employees' Physical Examinations POST Reimbursement Suppl ies, Materials & Services NOC Lod i Woodbri dge Equ i pmen t Depreciation 400 Depreciation / CTTY OF LODT / i '1 \ !' CLASSIFICATIONS OF EXPENDITURE ACCOUNTS I ri /I I I! '\ 11 Equipment, Land and Structures Speci a1 Payments 501 502 503 5 04 505 506 507 508 509 510 511 512 5 13 514 515 517 519 520 521 522 523 524 525 526 527 528 529 530 53 1 Office Equipment Household Equipment Auto Equipment Heavy Equipment Fire Fighting Equipment Traffic Signal Equipment Street Lighting Equipment Sewer and Disposal Plant Equipment Shop Equipment Recreation Equipment Transformers Meters Wire Poles and Pole Line Hardware Data Processing Hardware Communication Equipment 0 the r Eq u i pmen t Other Contracts 621 Donations 622 Taxes 623 Refunds 624 Bond Interest 625 Bond Redemption 699 Special Payments NOC Credi ts (CR) 700 Interfund Transfers 711 Workers' Compensation 712 Medical Insurance 713 Dental Insurance 721 PERS 723 Deferred Compensation 724 LTD/LI Acquisition of Land 725 Unemployment Insurance Rights of Way 732 Repairs to Office Equipment Easements 735 Vehicle Maintenance Costs Buildings 736 Motor Pool Vehicle Rental Other Structures Streets Curbs, Gutters and Sidewalks Sani tary Sewer Lines Water Well Lines Underground Lines and Hardware Storm Drains 19 9 1 -. 19'9 2 CITY MANAGER'S BUDGET MESSAGE / C7TY OF IUD1 CITY OF LODI LODI, CALIFORNIA 1991-92 BUDGET MESSAGE June 30, 1991 To the Honorable Mayor and Members of the City Counci Councilmembers: Presented herewith is the adopted Operating Budget for fiscal year 1991-92. This is a balanced budget totaling $59,308,950, plus transfers of $2,711,155 to other funds and reserves. This is $4,523,855 more than the 1990-91 budget of 554,785,095, an increase of 8.3%. Contributing to this increase are salary adjustments granted last year; a projected 10% increase in medical costs; a 10% increase in dental costs; a 10% increase in workers' compensation; an approximate 22% increase in pension costs; mandatory Social Security coverage for all part-time employees; and increased cost of electricity. This budget will allow the City to continue to provide the existing level of municipal services. To accomplish this within the revenue constraints the City faces, there are no new positions recommended. In addition, there are severe reductions in conference expense and training. Department heads have been instructed to "make do" with present level of funding for supplies and materials. -M1- /- CITY C‘F LOV7 ? The budget also provides for the replacement of equipment as we17 as the purchase of a limited amount of necessary new equipment, but sets aside no funds for capital expenditures. This budget is noteworthy not because of what is included, but what is not included and how the budget is funded. There are no new positions, limited new equipment, reductions in reserves and no dollars allocated to General Fund Capital projects. This budget is balanced with City Council-approved increases in water rates equal to the increased costs from the 1990-91 budget (5% effective August 1); the Transit Occupancy Tax (3% effective September 1); and an increase in November in electric rates in an amount sufficient to generate an additional 7% in revenues. The City suffered a shortfall in sales tax revenue of $435,000 in 1990-91. The C’ity did not receive in 1990-91 what it received in 1989-90, let alone the 7% growth projected. This lowers the base for 1991-92 by the 5435,000 shortfall. The State of California last year partially balanced its budget by withholding certain revenues from counties and authorizing counties to charge cities for collecting property tax. The County of San Joaquin had no choice, and thus held back $121,000 of 1990-91 property tax money from the City. The Governor’s budget includes a continuation of this into 1991-92 fiscal year. In 1991-92 that cost will be $127,555. Also, the Public Employees Retirement System Board of Administration changed the non-economi c actuarial assumptions effecting pension rates. These assumptions result in a projected increase in pension costs of approxi ma tel y $198,000. -M2- I emP 540 Additionally, the Federal Government has mandated that all oyees not covered by a pension plan be covered by Social Security. This adds 000 to $50,000 in additional costs. When these are totaled, the City finds itself with over $900,000 fewer dollars with which to operate in 1991-92 than would norma ly be expected. Loss of Sales Tax Base $435,000 Loss of Motor Vehicle in Lieu 135,000 Costs to Collect Property Tax 127,555 Increased Pension Costs 198,000 Mandated Social Security Coverage 40,000 $935,555 -------- -------- These numbers graphically quantify the fiscal plight of the City The City can take no comfort in the fact that other public agencies are of Lodi. facing the same or worse conditions. The City has balanced this year's budget and if we spend the next year taking actions to broaden our revenue base, we may be able to continue to provide a high level of service in ensuing years. If significant actions are not taken we run the risk of falling into the pattern of many cities in California; reducing staff and curtailing services. FINANCING RESOURCES The City of Lodi's budget is funded utilizing three resources which are: OPERATING REVENUES, such as taxes, charges, fees, sales of utilities and subventions from other agencies; INTERFUND TRANSFERS; and CONTRIBUTIONS FROM OTHER FUNDS. The funding resources for this budget total $62,020,105, $5,084,705 more than last year's estimate of $56,935,400. This represents an increase of 8.9%. If the charges for utility services were eliminated from these figures we will operate on $417,735 fewer dollars than we projected for 1990-91. OPERATING REVENUES The total estimated operating revenues to fund this budget are $59,649,825, $5,625,540 more than last year. However, of the $5,625,540 increase, $5,459,440 is from utility charges. This means that revenues other than utilities increased only $166,100. This makes funding a budget an extremely trying experience. Last year the City Council was advised that sales tax continues to grow at a rate greater than inflation. Instead of growing, the City's sales tax revenue in 1990-91 actually declined from 1989-90. We are projecting in 1991-92 less sales tax revenue than we originally projected for 1990-91. -M4- I CTTY OF LOVl The current financing resources available to meet the Operating Budget, together with comparative 1991-92 estimates, are as follows: (complete detail on revenue sources is depicted in Schedule H) FINANCING RESOURCES % REVENUE SOURCE 1990-91 1991-92 Difference Change OPERATING REVENUE Property Tax Sales T~X $ 4,715,895 9 5,222,440 $506,545 5,405,680 5,318,060 [87,620] 0 ther Tax 419,080 461,870 -42 , 790- Permits & Licenses 315,850 232 , 500 [83,350] Fines 285,500 327,220 41 , 720 Use of Property 274,650 372 , 200 97 , 550 Interest 1,415,985 1,120,500 [295,485] Revenues from Other Agencies 2,303,100 2,187,410 [115,690] Charges for Current Services 4,132,170 4,151,810 19,640 Other Revenues 186,000 226,000 40,000 Sub-Total $19,453,910 $19,620,010 $166,100 ----------- ----------- --------- UTILITY REVENUE Water Sales & Fees $ 2,588,935 $ 2,771,935 $ 183,000 Sewer Charges 8 Fees, 2,911,000 3,028,700 117,700 Electric Sales 29,070,440 34,229,180 5,158,740 Subtotal $34,570,375 $40,029,815 $5,459,440 ----------- ----------- ---------- ----------- ----------- ---------- TRANSFERS Interfund Transfers $ 927,990 $ 1,076,060 $ 148,070 Transfers from Other Funds $ 1,983,125 1,294,220 [688,905] -M5- i .. ,. 'i ,. j: I / CITY OF LOV4 In order to better explain these revenue adjustments, a source by source analysis is presented which will give a more accurate portrayal of the City's revenue status. A. PROPERTY TAX The City of Lodi receives approximately 21% of each statutory property tax dollar collected by the County of San Joaquin, plus the necessary increment to service voter-approved bonded debt. Bonded debt is being retired in accordance with a bond redemption schedule. Annual estimates for revenue are generally obtained from the County Assessor's Office which provides an anticipated percentage increase. However, that office has no way of anticipating the sales and subsequent reassessment of property or property brought onto the tax rolls during the year. For 1991-92 staff projects the General Property Tax to be $4,872,445, plus an additional $349,995 for debt retirement for a total of $5,222,440. This represents a 10.7% increase over the 1991-92 estimate. Property tax revenue for 1991-92 is estimated at: General Fund $4,041,710 Library Fund 830,735 Sewer Bond Debt 175,915 Other Municipal Bonds 174,080 ---------- $5,222,440 ------_--_ ---_-__-__ -M6- /- CTTY OF LUDT B. SALES TAX REVENUE Sales Tax revenue for 1991-92 is estimated to be $5,318,060, a decrease of $87,620 from last year's estimate. As stated earlier, in 1990-91 we are projecting a shortfall of $435,000 of our estimate. Sales and use tax is the most dynamic revenue source in responding to the economy. It is unfortunate that the City's greatest single source of revenue is so volatile. When the economy goes bad the demand for City services continues, but the revenues decline. C. OTHER TAXES These revenues are derived from other taxes: real estate transfer transactions, business license tax, and franchise fees. This source of revenue totals $461,870. Nost of these taxes are not sensitive to the economy and remain rather stable. However, property transfer tax revenues grow or decline with real estate activity. 0. LICENSES, FINES AND USE OF PROPERTY These revenues are obtained from various perm t and license fees, property rental, court fines and penalties. The total revenue from this source is estimated at $931,920, an increase of $63,920 from last year's estimate. Because we group a number of revenue sources here a further breakdown is in order. Licenses and Permits We are expecting a reduction of $83,000 in building permits. This is due to moratoriums on building activity. This is a conservative estimate. If the General Plan is adopted early in the fiscal year new construction could begin late in the fiscal year and generate a significant amount of revenue this year. We can expect a major increase in building activity in the foreseeable future. Fines, Forfeitures and Penal ties We are expecting an increase of $41,720 from the 1990-91 estimates. This increase is due to increased fines levied by the court. -M7- Revenue From Use of Property We are projecting an increase of $47,550 in rent of City property. This increase is due to the addition of property on Elm Street which is now rented, increased usage of City buildings and additional acreage and renegotiated leases at the White Slough Water Pollution Control Plant. E. INTEREST Interest income is a significant revenue resource. However, it is even more volatile than sales tax. The 1991-92 estimate is $1,120,500. This represents a 20.9% decrease in anticipated revenues over the 1990-91 projections of $1,415,985. This estimate is predicated on receiving all projected revenues in a timely manner. If interest rates drop significantly, if other revenues do not materialize, or cash balances decline, this source of revenue could be dramatically reduced. The major reason for this decrease is a reduction in interest rates. F. REVENUE FROM OTHER AGENCIES Revenue in this category for 1991-92 is estimated at $2,187,410, a decrease of $115,690 over the previous year's estimate of $2,303,100. We will receive $18,500 less in Motor Vehicle in Lieu Fees than estimated in 1990-91. As noted earlier, the State will be reducing the City's allocation by 7% to assist the County in balancing its budget. We have transferred the funds ($40,000) received from the Lodi Unified School District for joint use of facilities to another category of revenue and asset forfeitures are now held in a separate fund not to be used for general operating revenue. State funding for Library services is estimated to be $26,260 less in 1991-92 than in the previous year. -M8- G. SERVICE CHARGES These are the fees and charges the City receives for direct services provided. It includes all recreation fees, planning and engineering fees, and refuse collection fees. The total amount of these charges anticipated in 1991-92 is $4,151,810, an increase of $19,640 over last year. Last year we projected a 3.0% growth in refuse collection which failed to materialize and we are expecting a decline of plan checking fees. This may be conservative and increased revenues could begin to materialize late in the fiscal year. We are now placing parking revenues at Lodi Lake in a separate fund. H. OTHER REVENUES These are misce laneous revenues from unanticipated sources, such as reimbursements of previously paid bills, the sale of scrap or salvage material, and photocopies and reimbursements of State mandated costs. This revenue source is estimated to be $226,000 for 1991-92. I. REVENUES FROM UTILITY OPERATIONS The City operates three utilities: Electric, Water, and Sewer. These funds are operated on an enterprise basis with revenues and expenditures listed separate from the General Fund. In presenting the total operating budget, these operations are included. . Electric Sales The estimated electric sales for 1991-92 total $34,229,180 which is $5,158,740 (17.7%) more than last year's estimate of $29,070,440. This increase is due to a projected 7% rate increase in November and increased sales. . Water Sales and Fees The projected revenue from water sales and fees for 1991-92 is $2,771,935, 7.1% more than last year's figure of $2,588,935, an increase of $18,3000. This budget provides for a 5.0% anticipated rate adjustment in fiscal year 1991-92. That increase will capture the additional costs of providing service from last year. -M9- ? ': 1: I i .-- :: CTTY OF LOV'I /' fees is $3,028,700, an increase of year. This increase is based on actua . Sewer Fees The projected income from sewer service fees and sewer connection $117,700 (4.0%) from last revenues collected. J. INTERFUND TRANSFERS Monies from other funds are also used to finance the Operating Budget. This year, $467,780 of Gas Tax money, and $235,220 of Transportation Development Act funds will be used for street maintenance purposes. Housing and Urban Development funds totaling $52,660 wi 11 be used to fund administration of the Community Development Block Grant program, and to fund the Building Inspector (Housing) position. Included as interfund transfers is $141,230 which represents the anticipated revenue from the refuse surcharge to be used for reimbursement to the contract refuse hauler for the State surcharge on waste disposal sites and administration of the requirements of Senate Bill 198. Camp Hutchins is established as a separate fund. Therefore, the revenues from that fund are shown as a transfer in the amount of $91,415. The risk management function will be funded from the Public Liability and Property Damage Fund and Workers' Compensa ti on Fund. CONTRIBUTIONS FROM OTHER FUND RESERVES In order to provide adequate funding for the Operating Budget, $243,000 will be transferred from the Hotel/Motel Tax Fund. The amount transferred from the Hotel/Motel Tax Fund represents the 1991-92 estimated revenue from this source plus an increase in the Transit Occupancy Tax rate from 6% to 9%. In order to transfer $3,000,000 from the Electric Fund to the General Fund, it is necessary to transfer $1,030,000 from the Electric Fund Operating Reserve to the Electric Fund. Additionally, this budget provides for the transfer of $792,000 from the Water Fund to the General Fund, and a $385,000 transfer from the Wastewater Fund to the General Fund. -M10- / C7TY CF LOVI OPERATING EXPENSES As previously noted, the total Operating Budget for 1991-92 is The estimated cost of electricity is $2,072,000 $59,308,950, an increase of 8.3%. more than last year. An analysis of this budget on a category-by-category basis will help to clarify the reasons for the increases. Series % 1990-91 1991-92 Difference Change 100 - Personnel Services $18,155,820 200 - Utilities & Transportation 1,743,865 300 - Supplies & Services 3,506,295 400 - Depreciation 955,065 500 - Equipment & Structures 357,735 600 - Special Payments 5,256,315 Subtotal $29,975,095 Bulk Power Purchase $24,810,000 TOTAL EXPENSES $54,785,095 $19,952 , 175 1,930,295 3,841,205 901,000 320,115 5,482,160 $32,426,950 $26,882,000 $59,308,950 $1,796,355 186,430 334,910 [54,065] [37 , 6201 225,845 $2,451,855 $2,072,000 $4,523,855 + 9.9 + 10.7 + 9.6 - 5.7 - 10.5 + 4.3 + 8.2 + 8.4 + 8.3 -M11- ,. !' I! 1 /-- CTTY L'F LOUT I I I 11 iI 11 100 Series - Personnel Services This budget includes salary increases granted last year including significant adjustments in the salaries of a number of mid-management positions. i Included are those salary adjustments previously committed for July 1, 1991. It , does not include funds for any negotiated salary increases for this fiscal year. This budget includes no new positions. This does not mean new positions were not requested and justified, but with the fiscal problems facing the City, no new positions are recommended. This budget includes $1,796,355 more for Personal Services than last year. This increase is the result of salary adjustments granted after the budget was adopted last year. In addition, as previously mentioned, we are projecting a 10% increase in medical, dental, and workers' compensation costs. We have been notified by the Board of Administration of the Public Employees Retirement System that pension costs will increase approximately $198,000. The federal government has mandated that all employees not covered by a retirement plan must be covered with social security effective July 1, 1991. This requirement increases budgeted costs for 1991-92 by over $40,000. 200 Series - Utilities and Communications The estimate for 1990-91 was $26,553,865. In 1991-92 it is $28,812,295, an increase of $2,258,430 or 7.8%. Of the $2,258,430, $2,072,000 is due to increased cost of electricity. A 16% increase is projected for postage. We have included projected increases in the cost of other utilities. I -M12- ii I CTTY OF LOV7 3 300 Series - Supplies, Materials and Services at $3,841,205. This is $334,910 (9.6%) more than last year's budget of 11 $3,506,295. // The cost for goods and services for general operations is budgeted There are a number of items causing this increase, some of the more significant are as follows: Maintenance of Park Equipment $34,875 $11,000 Maintenance Contracts at Hutchins Street Square $39,330 Refinishing Floor Hutchins Street Square Lease purchase fire truck $39,000 Tree trimming 926,400 Lease purchase Police computer $60,500 The, rema additional costs of goods nder of the increases are based on usage and the and services utilized by the City. 400 Series - Depreciation Depreciation expenses this year decreased $54,065, from $955,065 to $901,000. Of the $901,000 budgeted here, $331,400 will be transferred to the Wastewater Capital Fund for Debt Retirement and replacement of major equipment items at the wastewater treatment facility; $569,600 will be placed in the Equipment Replacement Fund or appropriate capital funds. j! 1; !i , -M13- 500 Series - Equipment, Land and Structures The 500 Series contains equipment and construction contracts needed for ongoing operations. The total cost for this series is $320,115, a decrease of 437,620 from last year's budget. Most of the costs in this series are small items of equipment costing less than $1,000 such as calculators, desks, chairs, and park maintenance equipment. Also budgeted here are: . $159,300 . $21,000 . $16,100 traffic signal equipment . $38,050 . $14,400 . $50,000 slurry seal street work maintenance equipment for electric system maintenance curb and sidewalk replacement equipment street 1 ighting equipment remodeling Police Department offices 600 Series - Special Payments The 600 Series covers debt service, refuse collection payments, taxes, and other special payments. The costs of this series is $5,482,160, an increase of $225,845 from last year's budget. A substantial portion of this increase is due to the charge San Joaquin County tax, $127,555. Major items in this series are: Business Council Chamber of Commerce Collection of Property Tax Contingent Fund Debt Service: General Obligation Sewer ( interest only) Developers Refunds Donation to the Arts Commission Fireworks Mobile Home Park Distribution Northern California Power Agency Refuse Disposal levies for collecting property $ 15,000 $ 25,000 $ 127,555 $ 300,000 $ 174,080 $ 741,725 $ 210,000 $ 33,925 5 8,000 $ 47,125 $ 182,900 $3,370,000 Tax (Department energy surcharge) $ 72,220 -M14- Other Budgets In addition to the Operating Budget, there are five additional budgets which are necessary for the overall operation of the City. These budgets are not shown as part of the Operating Budget as funding is included in other budgets, or funded from special funds. Fund , Di sa b based These budgets are Public Liability and Property Damage (PL & PO) Workers’ Compensation Fund, Equipment Budget, Dental Insurance and Long-Term lity Funds and Medical Insurance Self Insurance Fund. The insurance budgets are based on best estimates of expenses on past experience. The detail of the expenditures for the insurance budgets is shown on pages 69-70; the detail for the Utility Outlay Budget is shown on pages 59-61; and the Equipment Budget on pages 49-52. OPERATING FUNDS The Operating Budget is divided into the following funds: . General . Electric . Water . Sewer . Library . Community Center Each of these funds has its own revenue and expenditure plan. The total Operating Budget is summarized in Schedule A. Each of the operating funds is presented with its appropriate revenues and expenditures in Schedules B through ti. -M15- j! I i 1 1 j 1 , 1 f I CTTY OF LOD7 In order to make a meaningful comparison of operating costs between fiscal 1991-92 the previous year, the following table lists the cost of bulk power separately. I Fund 1990-91 1991-92 Difference Change Genera 1 Electric Sewer Water Library Communi ty Center Subtotal Bulk Power TOTAL OPERATING FUNDS $21,932 , 580 2,979,520 2,677,880 1,094,955 898,720 391,440 $23,725,080 3,279,980 2,760,700 1,203,630 988,945 468,615 $1,792,500 300,460 82,820 108,675 90 , 225 77,175 + 8.2 + 10.0 + 3.1 + 9.9 + 10.0 + 19.7 $29,975,095 $24,810,000 ~ $32,426,950 $26,882,000 $2,451,855 $2,072,000 + 8.2 + 8.4 $54,785,095 $59,308,950 - $4,523,855 -M16- ~- + 8.3 General Fund A summary of the General Fund revenues and expenditures is shown in Schedule 5. General Fund revenues this year are anticipated to show an increase of only 1.6% ($17,356,070), an increase of $267,755 from last year's estimate of $17,088,315. In addition, $703,010 of Gas Tax and Transportation Development Act (TDA) funds are available for street maintenance purposes; $52,660 from the Housing and Urban Development Grant to fund a planner position; and a portion of Building Inspector's salary. General Fund revenues are not sufficient to fund the Operating Budget. This is not the first time this has been said. The present revenue structure will not fund the General Fund without transfers from the utility funds and a restructuring of revenue schedules. This budget provides for the transfer to the General Fund of $3,000,000 from the Electric Fund; $792,000 from the Water Fund; $385,000 from the Sewer Fund; and $200,000 from the Hotel/Motel Fund. Contributions from these sources will be able to fund this year's budget, and make transfers to other funds. EXPENDITURE SUMMARY General Fund Series Change I 1990- 9 1 1991-92 Difference 100 - Personnel Services $14,443,490 $15,774,280 $1,330,790 + 9.2 200 - Utilities & Transportation 782,785 907,685 124,900 + 16.0 300 - Supplies & Services 2,011,565 2,304,455 292,890 + 14.6 400 - Depreciation 537,330 461,700 [75,630] - 14.1 500 - Equipment & Structures 183,390 155,700 [27,690] - 15.1 600 - Special Payments 3,974,020 4,121,260 147,240 + 3.7 TOTAL $21,932,580 $23,725,080 $1,792,500 + 8.2 -M17- 9 C7TY OF LOVl A few general statements will summarize most of the changes in department budgets. The department budgets do not include any service enhancements. In most cases increased work loads will be absorbed by existing staff. We have factored in known cost increases such as postage and electricity. Department heads have been directed to forego specific annual conferences and have therefore reduced budgets accordingly. We have also reduced training money considerably. This is not good policy; however, we feel we can do this for one year and have no long-term repercussions. We will look to restore these funds in subsequent budgets. Department heads are most aware of this year's budget constraints and will conduct their operations accordingly. Included in all the budgets are salary increases granted after last year's budget was adopted including those that were scheduled to be received in July of 1991. Also, we have anticipated a 10% increase in medical insurance premiums, dental costs, and workers' compensation costs; social security coverage for all part-time employees; and an approximate 22% increase in pension costs. These factors are the reason for an approximate 9% increase in the personal services accounts. The following comments will explain any significant program change or cost increases. City Counci 1 -Ci ty C1 erk Two significant changes in these budgets are the addition of a City newsletter and the municipal election. The newsletter is budgeted for $36,000 for six issues. A portion of this cost is being absorbed by the Enterprise funds. We have reduced department budgets which had funds budgeted for City-wide notification of events or notices. One-half the cost of the November 1992 election is included in this year's budget as much of that work is done before July 1, 1992. That cost is $13,125. General Charges We have added 10% of the time of an Administrative Assistant to the Refuse Surcharge account. We are spending at least four hours per week implementing the requirements of Senate Bill 939 which requires managing and reducing our solid waste stream. Also included is the State-mandated costs for solid waste disposal. -M18- In addition, included in General Charges is the cost to the General Fund for County collection of property taxes, 4105,845. Also included in this budget is a $25,000 allocation to the Lodi District Chamber of Commerce and a $15,000 allocation to the San Joaquin Partnership (Business Council - Vision 2000) program designed to bring increased jobs to this County. Police Department There is little change in programs included in the Police Department budget. Included in the budget is $60,500 as the first year cost to replace and upgrade the computer systems used for records management and computer-aided dispatch. In 1990-91 fiscal year the Lodi Unified School District (LUSD) funded 1.4 police officer positions. This was one full-time police officer for the Drug Suppression Program and 40% of a police officer's salary for a Truancy Prevention Program. We have been told by the LUSD that they will only be able to fund one police officer this year and are writing a grant to reflect that this position will devote 75% of its time to drug suppression and 25% to truancy. The City has included these positions in this budget. We are not recommending the reduction in staff of the Police Department and recommend the position remain in the Detective Bureau. Fire Department The most noteworthy item included in this budget is the replacement of a 1969 Van Pelt fire engine. The cost of this engine will be approximately $200,000. It is recommended that this be funded on a lease-purchase. If we place an order for this piece of equipment in the fall or winter of 1991, we will not receive it until the 1992-93 fiscal year. However, we cannot place the order unless we have the funds appropriated. We will not spend the $40,000 budgeted, which helps the cash flow problem, unti 1 1992-93. \\ -M19- I CTTY OF LODI n-, We have also included some additional funding for utilities and maintenance of the new Fire Prevention Office at 231 W. Elm Street. Public Works This budget is much like last year's expanded programs included. n that there are no new or The previously mentioned salary and related costs account for $165,000 of the $279,000 increase in the Public Works budget. Increased cost of electricity for buildings, traffic control, street lights and storm system account for over $80,000 of the balance of the increase. Recreation The Recreation budget has increased due to growth in programs and the demand for services. Most of these demands are being offset by projected increases in fees. Because so much of the department budget is part-time salaries, the reason for a major portion of the costs are those directly accountable to the increased Social Security tax. The rental boat program has been moved from the Parks budget to the Recreation budget and the fireworks have been moved from the Recreation budget to the Parks budget. These changes place budget activities under the division manager responsible for the activity. Parks The Parks budget is not unlike last year's budget with the exception of the cost of repair parts for mowers and tractors and the cost of repairs of Park maintenance vehicles. Included is an additional $10,000 in Park Ranger time to provide relief for a permanent employee who is off on a long-term illness, and $4,000 for materials to be used in the rehabilitation of the former Lodi Lake snack bar for use as an interpretative center to serve visitors to Lodi Lake and the Nature Area. -M20- I CITY CF LODT Electric Fund Electric Fund revenues are generated by charges for electric energy. A summary of the Electric Fund is shown in Schedule C. % Series 1990-9 1 1991-92 Difference Change 100 - Personnel Services $ 1,568,350 200 - Utility & Transportation 38,295 300 - Supplies & Services 630 , 620 400 - Depreciation 60,800 500 - Equipment & Structures 170,845 600 - Special Payments 510,610 $ 1,810,390 37,975 681,470 75,600 159,300 515,245 $ 242,040 [3201 50,850 14,800 [ 11 , 545 -J 4 , 635 + 15.4 - .8 + 8.1 + 24.4 - 6.8 + .9 Subtotal $ 2,979,520 $ 3,279,980 $ 300,460 + 10.1 Purchased Power $24,810,000 TOTAL $27,789,520 $26,882,000 $2,072,000 + 8.4 $30,161,980 $2,372,460 + 8.5 -M21- This Electric Fund budget is $2,372,460 more than last year. However, $2,072,000 is addi ti onal power costs . The remai ni ng $300,460 represents a 10.1% increase over last year's operating budget. The changes contemplated in this budget are the shifting of manhours from capital projects to maintenance and operation and the addition of three months per year of contract tree trimming. This budget contemplates an increase in rates in November that will generate 7% more revenue than the present schedule. This rate increase places the electric system on a sound financial footing which will allow reserves to be maintained in the Rate Stabilization Fund and provide for necessary transfers to the General Fund and the Utility Outlay Reserve. Last year's budget stated that "in order to keep this fund (electric) on a sound economic footing it is planned to decrease the usage of reserve funds and adjust rates until revenue collections adequately cover the cost of power and other expenses." This rate increase is in line with that statement. The benefits of the City's municipally owned electric utility system bear repeating. These are: . City of Lodi residents pay less for electricity than those living in the surrounding area and in other cities. . The City experiences lower costs for electricity for streetlights and a1 1 other municipal uses, excluding enterprise operati ons. . It allows the City of Lodi to provide a higher level of service than other cities with a smaller increment of property taxes as a part of total revenue. The Electric Fund will transfer to the General Fund $1,358,625 for services performed by General Fund activities. In addition to the $3,000,000 transfer to the General Fund, there is a $39,215 transfer to the Public Liability & Property Damage Fund. This budget provides for a transfer to the Utility Outlay Reserve of over $1,100,000. A complete analysis of projected revenue requirements and expected revenue collections will be provided to the City Council as part of the November rate adjustment process. Sewer Fund A summary of the Sewer Fund is shown in Schedule D. % Series 1990-91 1991-92 Difference Change 100 - Personnel Services $ 200 - Utilities & Transportation 300 - Supplies & Services 400 - Depreciation 500 - Equipment & Structures 600 - Special Payments Plant Depreciation $ Bond Interest $ 949,755 $ 999,190 288,800 323,235 349 255 317,880 31,200 24 , 400 -0- 1,320 5,400 21,550 316,735 331,400 736 , 735 741,725 TOTAL $2,677,880 $2,760,700 $ 49,435 34,435 [31,375] c 6 ¶ 800 I 1,320 16 , 150 14,665 4,990 $82,320 + 5.2 + 11.9 - 9.0 - 21.8 + 100.0 + 299.1 + 4.6 + .7 + 3.1 -M23- I CTTY C'F LODI Sewer Fund revenues are generated by sewer charges and connection fees, property tax override for bond redemption, interest on funds and other miscellaneous revenues. Total operating revenue for fiscal 1991-92 is estimated at $3,028,700, which is $117,700 more than last year's total of $2,911,000. The operating expenses of the Sewer Utility Budget are $63,165 more than last year. Salary and fringe benefit costs are increased $49,435 due to increased medical, dental and pension costs. A portion of these additional costs are offset by transferring 30% of the Assistant Water/Wastewater Superintendent's time and reallocating other time from the Wastewater Fund to the Water Fund. The cost of electricity is $32,000 more than last year. Repairs to vehicles is expected to be less than was projected for 1990-91. Depreciation of equipment decreased $6,800. Plant depreciation increased $14,665 and Debt Service increased $4,990. Last year saw the passage of Senate Bill 1845 (Bay Area Protection and Toxic Cleanup). That bill requires payment to the State for toxic clean-up. The sewer charge is based on the type of treatment plant. The storm drain increment is based on population. Lodi's cost for this program will be $15,950. The Sewer Fund will be charged $152,225 to fund services Provided by the General Fund, as well as transfers of $19,810 to the Public Liabi 1 i tylProperty Damage Fund, and $338,680 to the Wastewater Capital Fund and $385,000 to the General Fund. -M24- I CTTY OF LOUT / Water Fund A summary of the Water Fund is shown in Schedule E. Series % Change 1990-91 1991-92 Difference 100 - Personnel Services $ 358,565 S 455,075 $96,510 + 26.9 200 - Utilities & Transportation 498,185 526,380 28,195 + 5.6 300 - Supplies & Services 227,405 197,910 [29,495] - 12.9 500 - Equipment & Structures -0- 1,320 1,320 + 100.0 400 - Depreciation 7,900 7,200 [7001 - 8.9 600 - Special Payments 2,900 15,745 12,845 + 442.9 TOTAL $1,094,955 91,203,630 $108,675 + 9.9 Water Fund revenues are generated by sales, connection fees, interest and miscellaneous revenues. The revenues for 1991-92 are estimated to be $2,771,935 an increase of $183,000 from the 1990-91 estimate of $2,588,935. The reason for this increase is a 5% increase in rates. This will be the first increase in two years and will recapture the additional costs of providing service. The Water Fund will be charged $174,175 to fund services provided by the General Fund. Transfers from the Water Fund will be made to the General Fund, $792,000; Water Capital, $727,430; Public Liability/Property Damager Fund, $9,200. Funds transferred to Water Capital will be included in the Capital Improvement budget and to make an installment payment of the Water Fund's loan from the Electric Department's Rate Stabilization Fund. -M25- /- CZTY c7F LODT \ The major increases in the Water Fund budget are last year's salary increases , increased costs of medical and dental insurance; higher pension costs; step increases previously authorized mid-year; and additional part-time help in the Water Conservation program. The cost of electricity to produce water is $41,400 more than last year's projections due to increased costs from the Electric Utility. Senate Bill 1806, a new mandate, requires a 5.50 fee annually from each water service to be paid to the Department of Health Services for operating costs of the Office of Drinking Water. Librarv Fund A summary of the Library Fund is shown in Schedule F. Series 1990-91 1991-92 Difference Change ~ ~~ 100 - Personnel Services $6 17 , 060 $663,905 $46,845 + 7.6 200 - Utilities & Communications 50,850 58,600 7,750 + 15.2 300 - Supplies & Services 222 , 160 233 , 730 11,570 + 5.2 600 - Special Payments 8 , 650 32,710 24 , 060 + 278.2 TOTAL $898 , 720 $988,945 $90,225 + 10.0 / < CTTY OF LOUT The major source of revenue from the Library operation is the result of an allocation of property taxes and revenues from other agencies. This year the property tax allocation will be $830,735; California Library Services Act, $28,000; and the Public Library Foundation, $19,240. In order to fund the Library a transfer of $21,220 from the Library Operating Reserve is necessary. There is a projected increase in sales tax expenditures of $2,300 due to increased costs of books, and an increase in the sales tax rate from 6.0% to 6.5%. The Library budget also includes the cost of collecting the property tax, $21,710. Community Center Fund A summary of this budget is shown in Schedule G. Series 1990-91 1991-92 Difference Change 100 - Personnel Services $218,600 $249,335 $30,735 200 - Utilities & Transportation 84 , 950 76,420 [8,5301 300 - Supplies & Services 65 , 290 105,760 40,470 400 - Depreciation 1,100 7 00 ~4001 500 - Equipment & Structures 3,500 2,475 UY0251 600 - Special Payments 18,000 33,925 15,925 TOTAL $391,440 $468,615 $77,175 + 14.1 - 10.0 + 62.0 - 36.4 - 29.3 + 88.5 + 19.8 -M27- Hutchins Street Square has become the center of increased activities. As programs at this facility increase, we can anticipate additional growth in this budget. The Senior Citizens' Center is completed and operating. The only operational revenue generated here is rental income and swimming fees. It is expected these will total $59,000, leaving a shortfall of $409,615 to be funded by a transfer from the General Fund. Included in the Community Center budget are the costs of administration and maintenance, the cost of operating the Senior Citizens' Center and all of the programs sponsored by the Arts Commission. This budget contains funding in the amount of $33,925 to be administered by the Arts Commission to enhance varied cultural activities in the community. This is $5,740 more than the City Council authorized last year. We now have a full year of operations of the Senior Citizens Center behind us and have a better idea of the costs involved. Maintenance contracts alone for the entire complex now tot-a1 $39,000 per year. Funds are included to resurface the hardwood floors in the Multi-Purpose Building and North Hall and to paint the cafeteria area. -M28- I ~ I I ! I i I I I I I I i i I BUDGET SUMMARY While this budget is balanced, the effort to reach this position has been extreme. It has been the most difficult budget to assemble in my nearly 30 years in local government./This City is faced with a financing structure that is not keeping pace with the ever increasing costs of goods and services. The impact of this present inadequate revenue base is compounded by the actions of the State of California, which has - reallocated to counties certain revenues that heretofore have been directed to cities. 1 Previous budget messages have advised that deficiencies were identified and met. This statement cannot be made this year. While there are no recommended reductions in services or personnel, department heads have been directed to spread resources a little thinner to reduce the revenue/expenditure gap brought on by inflation and population growth. We must use the next 10 months to review service levels and make appropriate modifications as well as reviewing and attempting to restructure the City's revenue base. What is clear is that the existing revenue base is no longer sufficient to support the City's existing level of service. -M29- The department heads were advised at the start of the budget process that 1991-92 would be a lean year, and they responded in a truly professional manner. New positions and equipment needs were identified and justified, but the funding sources simply do not exist this year. Their assistance and the assistance of their staffs is acknowledged with appreciation. I am again particularly indebted to Assistant City Manager Jerry L. Glenn and Finance Director Robert H. Holm for their major contributions. Mr. Holm will be retiring from the City of Lodi one week into the fiscal year. He leaves having devoted 17 years of distinguished service to this City in the complex field of fiscal management and his departure will be keenly felt by the entire City staff. A special expression of appreciation goes to Ms. Diana White-Messing, Assistant Finance Director, whose attention to detail and research capabilities, were of considerable help. Finally, the production of this document was again under the direction of Barbara Reed, Secretary to the City Manager, and her significant role in this effort is likewise acknowledged. Respectfully submitted, Thomas A. Peterson City Manager TAP/JLG:br -M30- 1991 - 1992 OPERATING BUDGET CITY OF LODI CALIFORNIA OPERATING BUDGETS SUMMARY OF THE BUDGET 1991-92 ESTIMATED FINANCING RESOURCES OPERATING REVENUES Property Taxes Sales Tax Other Taxes Licenses, Fines & Rent Interest Revenue from Other Agencies Charges for Current Services 0 ther Revenues Water Sales & Fees Sewer Charges Electrical Sales Total INTERFUND TRANSFERS $ 5,222,440 5,3 18,060 461,870 931,920 1 , 120,500 2,187,410 4,151,810 226,000 2,771,935 3,028,700 34,229,180 $59,649,825 4 1,076,060 \ CONTRIBUTIONS FROM OTHER FUNDS AND RESERVES Hotel /Motel Fund $ 243,000 Electric Operating Reserve 1,030,000 Library Operating Reserve 21,220 Total S 1,294,220 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services 919,952,175 Utilities & Transportation 1,930,295 Materials & Suppl ies 3,841,205 Depreciation of Equipment 901,000 Equipment, Land & Structures 320,115 Special Payments 5,482,160 Sub-Total Ooeratins Exoenses $32,426,950 -. Bulk Power Pukhase Total CONTRIBUTIONS TO OTHER FUNDS AND RESERVES Water Capital $ 727,430 General Fund Operating Reserve 176,045 Wastewater Capital Fund 338,680 Uti 1 i ty Outlay Reserve 1,174,360 PL & PD Insurance Fund 268 , 225 Camp Hutchins 26,415 Total $ 2,711,155 TOTAL ESTIMATED REQUIREMENTS -1- SCHEDULE A GENERAL FUND SCHEDULE B SUMMARY OF THE BUDGET 1991-92 ESTIMATED FINANCING RESOURCES REVENUE Property Taxes $4,215,790 Sales Tax 5,318,060 Other Taxes 461,870 Licenses and Permits 232,500 Fines, Forfeits and Penalties 278 , 220 Revenue from Use of Money & Property 457,650 Revenue from Other Agencies 2 , 140 , 170 Charges for Current Services 4,123,810 0 ther Revenue Total J=&%+WM TRANSFERS 3 -/&.or-’looAsset Seizure 3 - oao.or-’lao Ref u s e S u r c h a r ge - s;a,vsY,YWousing and Urban Devel opment 2%0- Transportation Development Act b- State Gas Tax a- Camp Hu tchi ns 0-o~a.03 Publ ic Liabil i ty Insurance Fund ,j-oyt,.o3 Workers’ Compensation Fund Total 128,000 $17,356,070 235,230 467 , 780 91,415/ 27,285 .. 54,650 $ 1,076,0609 CONTRIBUTIONS FROM OTHER FUNDS AND RESERVES J3Y Hotel/Motel Fund $ 243,000- 18 Water Utility Fund 792,000* 17 Sewer Util i ty Fund 385,000- Electric Uti 1 i ty Fund -” 3,000,000 $ 4,420,000 fb Total $22,852 , 130 --_________ ----------_ TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS 0 PER AT IN G EXP ENS ES Personnel Services $15,774,280 Utilities & Transportation 907,685 Materi a1 s & Suppl ies 2,304,455 Depreciation of Equipment 461,700 155,700 4,121,260 Equipment, Land & Structures Special Payments $23,725,08 Q Sub-Total Operating Expenses INTER-FUND TRANSFERS General Fund Charges to Enterprise Fund Net Operating Expenses CONTRIBUTIONS TO OTHER FUNDS AND RESERVES i0 -LY4General Fund Operating Reserve $ 176,045’ 1x0 Community Center Fund 409,6 15- 30 ’ 200,000 a3. Camp Hutchins 26,415 Total $ 812,075 Publ ic Liabi 1 i ty Insurance Fund TOTAL ESTIMATED REQUIREMENTS $22,852,130 ------____- -------____ -2- / / C7TY OF LOVZ I SCHEDULE C ELECTRIC UTILITY FUND SUMMARY OF THE BUDGET 1991-92 ESTIMATED FINANCING RESOURCES OPtRATING REVENUES Sale of Electricity $34,229 , 180 Total $34,229,180 OTHER INCOME Sale of System - Joint Pole B 10,000 Pole Rental (CATV) 20 , 000 Sale of Property - Salvage 3,000 Interest Income 372,000 Electric Miscellaneous 40 , 000 Revenue NOC 5,000 Capacity Charge 25 ;OOO Total $ 475,000 PRIOR YEARS REVENUES $ 1,030,000 $35,734,180 ------_---- --_-------- TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services $1,810 ,390% Materials & Supplies 681,470 Depreciation of Equipment 75,600 Equipment, Land & Structures 159,300 Special Payments 515,245 Sub-Total Operating Expenses $ 3,279,980 Bulk Power Purchase $26,882,000 Total $30,161,980 Utilities & Transportation 37,975 INTER- FUND TRANSFERS lolo General Fund Charges $1,358,625 To ta 1 $ 1,358,6251 CONTRIBUTIONS TO OTHER FUNDS AND RESERVES 10 General Fund $3,000,000 -, 30 PL & PD Insurance Fund 39,215- Utility Outlay Reserve 1 , 174 , 360’ Total $ 4,213,575 TOTAL ESTIMATED REQUIREMENTS -3- SEWER UTILITY FUND SUMMARY OF THE BUDGET 1991-92 ESTIMATED FINANCING RESOURCES DPERATING REVENUES Sewer Service Charges $2,728 , 700 Sewer Connection Fees 300 , 000 Total 5 3,028,700 TAXES Property (Bond Redemption) $ 175,915 Total $ 175,915 OTHER INCOME $ 278,250 169,550 Interest Income Rental of City Property Sewer Reimbursement Fees 1,000 0 ther Revenue 1,000 Sewer Tap Fees 2,000 Total - $ 451,800 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services $ 999,190 Utilities & Transportation 323 , 235 Materials & Supplies 317,880 Depreciation of Equipment 24,400 Equipment, Land & Structures 1,320 Special Payments 21,550 Total $ 1,687,575 BONDED DEBT SERVICE Special Payments $ 741,725 Total $ 741,725 PLANT DEPRECIATION $ 331,400 Total $ 331,400 INTER-FUND TRANSFERS I General Fund Charges $ 152,225 Total 5 152,225 CONTRIBUTIONS TO OTHER FUNDS & RESERVES Wastewater Capital Outlay $ 338,680' PL & PD Insurance Fund 19,810 h General Fund 385,000- - 4 743,490 Total TOTAL ESTIMATED REQUIREMENTS SCHEDULE D -4- c C7TY OF LODI SCHEDULE E WATER UTILITY FUND SUMMARY OF THE BUDGET 1991-92 ESTIFlATED FINANCING RESOURCES OPERATING REVENUES Water Sales Water Connect i on Fees $2,731,935 40.000 OTHER INCOME Rent of City Property Interest I ncorne Revenue - NOC Total $ 30,000 94 , 500 10,000 To ta 1 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services Uti 1 i ties & Transportation Materials i3 Supplies Depreciation of Equipment Equipment, Land & Structures Special Payments Total INTER-FUND TRANSFERS $ 455,075 526 , 380 197,910 7,200 1,320 15.745 $2,771 , 935 S 134,500 $1,203,630 General Fund Charges $ 174,175’ Total $ 174,175 CONTRIBUTIONS TO OTHER FUNDS & RESERVES General Fund $ 792,000- Water Capital 727,430 ’ PL & PD Insurance Fund 9,200- Total $1,528,630 TOTAL ESTIMATED REQUIREMENTS -5- SCHEDULE F ~ ,I LIBRARY FUND SUMMARY OF THE BUDGET 1991-92 ESTIMATED FINANCING RESOURCES OPERATING REVENUES Fines, Fees and Gifts To ta 1 NON-OPERATING REVENUES Investment Income Donations TAXES Property Taxes Total Total REVENUE FROM OTHER AGENCIES California Library Services Act Public Library Foundation Total CONTRIBUTIONS FROM LIBRARY OPERATING RESERVE Total TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services Uti 1 i ties & Transportation Materials & Supplies Special Payments Total TOTAL ESTIMATED REQUIREMENTS $ 49,000 .$ 49,000 ’ $ 39,750 ’ 1,000 ’ $ 40,750 $830,735 $830,735 $ 28,000 19; 240 $ 47,240 1 $ 21,220 1 $ 21,220 $663,905 58,600 233 , 730 1 32,710 9 988,945 ESTIMATED FINANCING RESOURCES OPERATING REVENUE Rent of Property Swimming Fees CONTRIBUTIONS FROM OTHER FUNDS General Fund SCHEDULE G COMMUNITY CENTER SUMMARY OF THE BUDGET 1991-92 $ 31,000 ’ 28,000 1 To ta 1 9409.615 \\ Total TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSE Personnel Services Utilities and Transportation Supplies and Materials Deprec i a t i on Equipment, Land & Structures Special Payments Tota 1 TOTAL ESTIMATED REQUIREMENTS $249,335 76,420 105,760 700 2,475 33,925 $ 59,000 $409,615 $468,615 ’ .-- CTTY OF LOP7 /' PROPERTY TAXES Current Year - Secured $3 , 500 , 187 Bond Redemption 185,99 1 Tota 1 $3,686,178 OTHER TAXES Sales and Use Tax $4,969,746 Franchise - Gas 111,768 Franchise - Cable TV 92,065 Business License Tax 95,558 Real Property Transfer - Documentary 112,085 Total $5,386,981 Franchise - Electric 5,759 LICENSES AND PERMITS Animal Licenses $ 8,247 Bicycle Licenses 1,420 Building Permits 256,009 Electric Permits 39,147 Mechanical Permits (Gas ) 19,409 Plumbing Permits 22,981 Parking Lot Permits 17,350 Total FINES, FORFEITS & PENALTIES Vehicle Code Fines $183 , 948 Court Fines 16,888 Overparking 27,911 Total 9228,747 REVENUE FROM USE OF MONEY & PROPERTY Investment Earnings $482,730 Rent of City Property 60,259 LUSD-Joint Use Agreement -0- Total 3542,989 -9- $3,616,620 177,865 '$3,794,485 $5,405,680 117,360 96,370 6,625 97,535 101,190 $5,824,760 $ 8,100 1,500 200,000 40,000 20,500 28,000 17,750 $315,850 $190,000 17 , 500 29,000 5236,500 $405,950 45,000 40,000 $490,950 $4,041,710 174 , 080 $4,215,790 $5,318,060 142,650 107,870 7,470 95,880 108,000 35,7/9,930 $ 8,500 ' 1,500 154 , 125 24,660 12,330 14 , 385 17,000 9232,500 $218,400 25,560 34 , 260 9278,220 $336 , 000 81,650 40,000 $457,650 GENERAL BUDGET 1991-92 DETAIL OF FINANCING RESOURCES GENERAL FUND (continued) REVENUE FROM OTHER AGENCIES State Motor Vehicle in State Reimbursement P.O.S.T. State Cigarette Taxes County-Recreation A1 lotment County-CRACNET LUSD-Recreation A1 lotment DOJ Asset Forfeiture State Reimbursement - Drug Suppression Grant LUSD-Reimbursement Drug Suppression Grant LUSD-Truancy Reimbursement State Traffic Safety Grant- Lieu of Taxes Engineering Total CHARGES FOR CURRENT SERVICES Plan Checking Fees P1 anning Fees Animal Shelter Fees Engineering Fees Refuse Collection Concessions - Boats Concessions - Other Swimning Photocopy Charges Recreation - Miscellaneous SCHEGULE H 199 1-92 1990-91 Actual Estimated Es ti mated Resources Resources Resources 1989-90 $1,745,955 $1,858,500 $1,840,000 80,357 70 , 000 70,000 105 , 690 84 , 685 87,225 17,409 17,410 - 0- 56 , 320 60,830 4,000 4,000 -0- ' 9,763 36,000 -0- 17,410 .' 25 , 172 8,325 -0- 9,060 54 , 360 45,460 -0- -0- 19,245 1,833 -0- -0- $1,999,239 52,189,600 $2,140,170 5 130,080 3,910 3,835 42 , 078 3,602,648 12,892 14,114 33 , 768 12,603 198.540 $ 110,000 3,500 3,500 20,000 3,715 , 170 13,000 15,000 35,000 14,000 180,000 $ 88,690 4,000 3,500 75,000 3,663 , 120 10 , 000 15,000 42,000 9,500 213,000 Lake Fees - Capital Improvements 23 ;690 23,000 -0- Total $4,078,158 $4,132,170 84,123,810 OTHER REVENUES Sales of Real & Personal Property $ 19,826 $ 4,000 b 8,000 Revenue NOC 140 , 587 100,000 120,000 Donations 2,220 -0- -0- Total $162,633$104,0008128,000 ~ - . -. ,r--- r- -:,- - lo - GENERAL BUDGET 1991-92 DETAIL OF FINANCING RESOURCES GENERAL FUND (continued) SCHEDULE H 1989-90 1990-91 1991-92 Actual Estimated Estimated Resources Resources Resources INTERFUND TRANSFERS Housing and Urban Development $ Gas Tax Transportation Devel oprnent Fund Refuse Surcharge Camp Hutchins PL & PD Fund Workers' Compensation Fund Asset Seizure 20,343 411,600 126,563 54,395 95,022 -0- -0- -0- $ 50,225 $ 533,270 120,285 62,000 107,160 55,050 -0- -0- 52,660 467,780 235,230 141,230 91,415 27,285 54,650 5,810 Total 707,923 $ 927,990 's1,076,060 CONTRIBUTIONS FROM OTHER FUNDS & RESERVES Electric Utility Fund 51,704,730 $2,325,635 $3,000,000 Water Utility Fund 511,280 750,000 792,000 % Sewer Fund 59,615 203,200 385,000 >I Hotel/Motel Fund 145,000 156,715 200 , 0009 Total $2,420,625 '93,435,550 '$ 4,377,000 Sub-Total General Fund $19,578,036 $21,451,855 $22,809,130 LESS CONTRIBUTIONS TO OTHER FUNDS Capital Out1 ay Reserve $ 154,400 $ 200,000 $ -0- General Fund Operating Reserve 209,076 181,025 230,830 Community Center Fund 258,920 330,000 409,615 Pub1 ic Liabi 1 i ty Insurance Fund 292,095 242,095 200,000 Equipment Fund 142,580 109,905 Camp Hutchins 19,910 57,160 26,415 Total $1,076,981 $1,120,185 866,860 -0- - 11 - i .. /- I CITY C'F LOCI \ GENERAL BUDGET 1991-92 DETAIL OF FINANCING RESOURCES SCHEDULE H 1989-90 1990-91 1991-92 Actual Estimated Estimate Resources Resources Resources ELECTRIC UTILITY FUND OPERATING REVENUE - ELECTRIC SALES Domestic - Residential $ 9,789,985 $10,813,335 $12,781,830 Comnercial - Small Industrial 3,372,151 3,690,200 4,586,565 Dusk-to-Dawn 37,491 39,535 44,690 Mobile Home Parks 165,285 198 , 260 247,400 Commercial, Large 6,840,934 7,239,410 8,007,275 Industrial, Small 5,856,093 6,587,945 851,970 -0- -0- 1,898,595 5,094,935 Indus tri a1 , Medium City Accounts 1,064,809 501 , 755 715 , 920 Industrial, Large -0- -0- Total '327,126,748 $29,070,440 '934,229,180 ' NON-OPERATING Investment Income $572,323 $512,725 $372,000 . Sale of Real & Personal Property 6,884 3,000 3,000 Electric Miscel laneous 49,394 40,000 40,000 Revenue NOC 2,803 10,000 5,000 Capacity Charge 6,559 -0- 25,000 . Rent of City Property (CATV) 13,472 20,000 20 , 000 Sale of System (Joint Pole) 48,515 10,000 10,000 To ta 1 b699,950 $595,725 mFgm' PRIOR YEAR'S REVENUE $ -0- $ -0- $1,030,000 CONTRIBUTIONS FROM OTHER RESERVES Rate Stabilization Fund S400,000$ $ 1,776,300 $ -0- Sub-Total Electric Uti 1 i ty Fund $28,226,698 $31,442,465 $35,734,180 LESS CONTRIBUTIONS TO OTHER FUNDS General Fund $1,704,730 $2,325,635 $3,000,000 PL & PD Insurance Fund 35,050 39,215 Utility Outlay Reserve -0- 1,174,360 Total $1,704,730 $$ $4,213,575 - 12 - GENERAL BUDGET 1991-92 DETAIL OF FINANCING RESOURCES SEWER UTILITY FUND OP ERAT I NG Sewer Service Sewer Service Sewer Connect Charge - Publi Charge - City ons (taps) Tota TAXES Property Taxe Total NON-OP ERATI NG Investment Earnings Rental of City Property Sewer Reimbursement Fees Revenue NOC Sewer Tap Fees Sale of Real & Personal Property Total Sub-Total Sewer Utility Fund SCHEDULE H 1989-90 1990-91 1991-92 Ac tua 1 Es t irna ted Estimated Resources Resources Resources LESS CONTRIBUTIONS TO OTHER FUNDS PL & PD Insurance Fund Wastewater Capital Outlay General Fund Total NET TOTAL SEWER UTILITY FUND $2 , 140,820 10,071 656,848 $2,807,739 $ 189,142 3 189,142 $ 353,284 127 , 041 2,621 4,332 17,635 1,063 $ 505,976 $2,600,000 11,000 300,000 32,911,000 $ 178,030 3 178,030 .$ 320,975 128,210 1,000 1,000 2,000 -0- $ 453,185 $2,717,000 11,700 300,000 $3,028,700 $ 175,915 $ 175,915 $ 278,250 169,550 1,000 1,000 2 , 000 -0- 3 451,800 $3,502,857 $3,542,215 $3,656,415 ' $ 152,243 $ 17,525 $ 19,810 500,300 500 , 000 340,000 59,615 203,200 385 , 000 712,158 '5 720,725 '$ 744,810 $2,790,699 $2,821,490 $2,911,605 - 13 - GENERAL BUDGET 1991-92 DETAIL OF FINANCING RESOURCES WATER UTILITY FUND OPERATING Water Sales - Public Water Sales - City Water Connection Taps NON-OPERATING Investment Earnings Rent of City Property Revenue NOC Total Total CONTRIBUTIONS FROM OTHER RESERVES Water Operating Reserves Sub-Total Water Uti 1 i ty Fund 1989-90 1990-9 1 1991 -92 Actual Estimated Estimated Resources Resources Resources $2,488,720 $2,555,635 $2,721,935 41,804 22,500 40,000 $2,541,175 $2,588,935 $2,771,935 10,651 10,800 10,000 $ 137,944 $ 130,985 $ 94,500 51,517 20,000 30,000 10,841 13,000 10,000 5 200,302 $ 163,985 5 134,5001 $ -0- $ 50,110 $ -0- $2,741,477 $2,803,030 $2 ,906,435 General Fund 'Water Utility - Capital Outlay PL '& PD Insurance Fund Total SCHEDULE H LESS CONTRIBUTIONS TO OTHER FUNDS & RESERVES NET TOTAL WATER UTILITY FUND $- 511,280 $ 750,000 $ 792,000 1,014,530 785,000 728,750 8,035 9,200 $1,525,810 81,543,035 $1,529,950 3 1,215,667 $1,259,995 $1,376,485 - 14 - GENERAL BUDGET 1991-92 DETAIL OF FINANCING RESOURCES LIBRARY FUND OPERATING Fines, Fees & Gifts Total NON-OPERATING Investment Earnings Donations Total PROPERTY TAXES Total STATE GRANTS Library Services Act Pub1 ic Library Foundation Total CONTRIBUTIONS FROM OTHER FUNDS Rate Stabilization Fund Library Operating Reserve Total Sub-Total Library Fund LESS CONTRIBUTIONS TO OTHER FUNDS OR RESERVES Library Operating Reserve Total TOTAL LIBRARY FUND SCHEDULE H 1989-90 1990-91 1991-92 Actual Estimated Estimated Resources Resources Resources - 15 - $ 53,129 $ 64,264 ’ 1,480 9 65,744 $719,448 $ 34,215 39 , 504 m $ 32,000 -0- -!nmm $ 49,000 4 45,350 2,000 4 743,380 $ 34,000 39,500 $73,500 $ -0- -0- --o- $ 49,000 ’ S 39,750 1,000 -mXm/ $830,735 J $ 28,000 19 , 240 “$47,240’ $ -0- 21,220 $944 , 040 $913,230 $988,945 $ 53,990 $214,510 9 -0- 353,990 s214,510 9 -0- I. !* I! GENERAL BUDGET 1991-92 DETAIL OF FINANCING RESOURCES SCHEDULE H 1989-90 1990-91 1991-92 Actual Estimated Estimated Resources Resources Resources COMMUNITY CENTER OPERATING REVENUE Rent Swim Fees $ 17,540 $ 61,440 $ 31,000 -0- -0- 28,000 Total $ 17,540 $ 61,440 $ 59,000 ’ CONTRIBUTIONS FROM OTHER FUNDS AND RESERVES General Fund Operating Reserve $258,920 $330,000 $409,615 Total $258,920 $330,000 $409,6 15 TOTAL COMMUNITY CENTER - 16 - $276,460 $391,440 $468,6 15 I CTTY OF LOVl /’ SPECIAL REVENUE FUNDS SCHEDULE I CONSTRUCTION FUND REVENUES BOND FUND REVENUES TRUST & AGENCY FUNDS 1991- 92 1989-9 0 1990-91 1991-92 Actual Estimated Estimated Resources Resources Resources 12 EQUIPMENT FUND Depreciation $381,058 $433,450 $338,200 Contributions from General Fund 109,905 -0- . Total $381,058 4543,355 $338,200 13 REFUSE SURCHARGE FUND Collections 5 61,292 $ 62,000 $124 , 000 ’ Total $ 61,292 S 62,000 $124,000 / 16.1 ELECTRIC UTILITY OUTLAY RESERVE Inter-Fund Transfer Total $141,837 $ 60,000 $ 75,600 ’a Total $141,837 9 60,000 $ 75,600 16.2 ELECTRIC RATE STABILIZATION RESERVE Investment Earnings $580,838 $502,595 $150,000 Revenue NOC 92,866 -0- -0- Total $673,704 $502,595 $150,000 17.1 SEWER CAPITAL Interfund Transfer $ 50,523 $ -0- $ -0- Total $ 50,523 s -0- 9 -0- 17.2 WASTEWATER CAPITAL RESERVE $3 16,735 $331,400 ’ Inter-Fund Transfer $ 26,550 Investment 720,183 -0- -0- Sale of Real & Personal Property 2,658 -0- -0- Revenue NOC 10,000 -0- -0- Total $759,391 $316,735 $331,400 - 17 - FUNDS AND REVENUES SCHEDULE I 1991-92 1989-90 1990-91 1991-92 Actual Estimated Estimated Resources Resources Resources 18.1 WATER UTILITY-CAPITAL OUTLAY FUNDS Inter-Fund Transfer $ 25,086 $ 7,900 $ 7,200' Contribution from Water Utility Fund -0- 785,000 735,950 Total $ 25,086 $792,900 $743 , 150 21.1 LIBRARY CAPITAL OUTLAY Investment Income $ 19,895 $ 15,000 $ 15,000 Total $ 19,895 $ 15,000 $ 15,000' 22 CAMP HUTCHINS Fees $ 47,727 $ 50,000 $ 65,OOOA To ta 1 .$ 47,727 5 50,000 $ 65,000' 28 MEDICAL INSURANCE RESERVE INTERFUND TRANSFERS Medical Cost A1 locations $427 , 283 $480,400 4 23,580 Retirees Participant Payments 17,824 24,000 -0- Medical Dependent 864 -0- -0- Cobra Participant 2,152 -0- -0- Total $448,123 $504,400 $ 23,580 J --.---.. 29 DENTAL & LTD/LI INSURANCE RESERVE INTER-FUND TRANSFERS Dental Cost Allocations $269,993 $140,600 $173,360 ' Long-Term Disability Cost A1 1 ocati ons -0- 75,200 89,585' Employee Contributions -0- 18,0002 e3s COBRA Participant Payments 3,669 4 , 000 1,800 Medical Dependent 66 -0- -0- $290 , 165 Total $273,728 $237,800 30 LIABILITY INSURANCE RESERVE Investment Income .$ 63,192 8 59,000 $ 49,500' Contributions - General Fund -0- 242,095 200,000 Contributions - Enterprise Fund -0- 60,610 68 , 225 Reimbursements -0- 70,000 -0- Revenue NOC 43 -0- -0- Total $ 63,235 $431,705 $317,725 - 18 - FUNDS AND REVENUES SCHEDULE I 1991-92 1989-90 1990-91 1991-92 Ac tua 1 Estimated Estimated Resources Resources Resources 31 WORKERS' COMPENSATION INSURANCE RESERVE Compensation Reimbursements I nter-Fund Transfers Investment Earnings Revenue NOC Total SUB TOTAL WORKERS' COMPENSATION INSURANCE RESERVE CONTRIBUTIONS TO OTHER RESERVES Workers' Compensation Insurance Reserve Total NET TOTAL WORKERS' COMPENSATION INSURANCE RESERVE 32 GENERAL GAS TAX (2107) State Gas Tax Investment Earnings To ta 1 33 SELECT SYSTEM GAS TAX (2106) Investment Income State Gas Taxes Total 36 GAS TAX - 2105 Investment Income State Gas Tax Total 41 BOND INTEREST & REDEMPTION FUND Inter-Fund Transfer Total - 19 - $ 35,914 $ 30,000 $ 35,000 75,056 71,990 55,500 8 , 195 -0 - -0- 381,580 410 , 000 450,450 - $500,745 $511,990 9540,950 I $500,745 $511,990 4540,950 4 73,305 $ 96,870 $181,150 $ 73,305 $ 96,870 $181 , 150 3427,440 $415,120 $359,800 $454 , 119 $448,500 $455 , 660 32,952 29 , 500 15,000 $487 , 07 1 $478,000 $470,660 ' $ 30,852 $ 25,095 $ 24,750 209,083 216,000 210,280 $239,935 $241,095 S235,030 9 -0- $ -0- 9 1,500 -0- -0- 225,390 4 -0- 9 -0- $226 -890" $353,698 $356 , 120 $349,730 $353,698 5356,120 $349 , 730 ' FUNDS AND REVENUES 1991-92 44.1 1984 STATE PARKS BOND ACT Investment Earnings SCHEDULE I 1989-90 1990-91 1991-92 Ac tua7 Estimated Estimated Resources Resources Resources $ 409 $ 220 $ -0- Total 9 409 $ 220 $ -0- 44.3 1988 STATE PARK BOND ACT 45 46 47 48 Investment Earni ngs $ -0- $ -0- S 750 Total $ -0 - $ -0- 5 / HUD - ENTITLEMENT GRANT Federal Grant '$278,020 $344,640 $400,230 Total $278,020 $344,640 $400,230 INDUSTRIAL WAY & BECKMAN DEVELOPMENT Investment Earni ngs Revenue-NOC Total INDUSTRIAL WAY & BECKMAN ROAD DEVELOPMENT #2 FUND Investment Earnings Total TURNERjCLUFF ASSESSMENT DISTRICT Property Tax Investment Earnings To ta 48.2 TURNER/CLUFF I nves tmen t Special Assess Tota 49 DOWNTOWN IMPROVEMENT DISTRICT Property Tax Investment Income Total 72 SUBDIVISION RESERVES (CITY) Subdivision Fees Total $ 14,778 $ 13,210 S 11,250 1,500 -0- -0- $ 16,278 S 13,210 5 11,250' $ 1,236 $ 1,320 5 750 1,236 $ 1,320 s 750 #1 $ -0- $128,065 s -0- 6,160 5,065 6,000 S 6-160 S133.130 b 6.000 $ 14,359 $ -0- $ 10,500 136,438 -0- 126,415 $150,797 $ -0- $136,915 $ 49,135 S 53,650 $ 51,265 3,050 2,420 2,250 '$ 52,185 $ 56,070 5 53,515/ $ 20,952 $ 20,000 a 2,000 3 20,952 .$ 20,000 5 2,000' - 20 - I /f ClTY CF LORD7 i FUNDS AND REVENUES 1991-92 SCHEDULE I 75 SUBDIVISION FUND - IN TRUST Subdivision Fees To ta j 1989-90 1990-91 199 1-92 Actual Estimated Estimated 1 Resources Resources Resources I $335,590 $150,000 $150,000 ' 3335.590 $150 .OOO S 150.000 120.2 HUTCHINS STREET SQUARE-HOLZ BEQUEST Investment $ 50,599 $ -0- $ -0- Donation 235 , 357 -0- -0- Total $285,956 $ -0- s -0- 123 MASTER DRAINAGE FUND Acreage Fees Rent of Property Total $ 49,364 $ 50,000 4 -0- , 3,165 -0- -0- 3 52.529 $ 50.000 9 -0- 123.1 MASTER STORM DRAIN (AB 1600) Acreage Fees Investment Income To ta 1 124 TRANSPORTATION DEVELOPMENT ACT Local Cash Grants Investment Earnings Total $ 69,137 $ 50,000 $150,000 13,729 10 , 565 15,750 s 82,866 4 60,565 $165,750 $668,285 $669,240 $623,510 49,314 27,300 18,750 $717,599 $6 96 , 540 $642,260 125 DIAL-A-RIDE Special County Transportation A1 1 ocation $300 , 300 $353,140 $418,740 State Transit Assistance 4 , 927 -0- - 0- Passenger Fares - Lodi 39,312 41,000 43,750 San Joaquin County Reimbursement - Woodbridge 11,076 7,310 18,990 Investment Earnings 112 1,320 -0- Sale of Real & Personal Property 29,759 -0- -0- Total '3385,486 $402,770 $481,480 J - 21 - \ I .. ! ., I FUNDS AND REVENUES 199 1-92 SCHEDULE I 1989-90 1990-91 1991-92 Ac tua 1 Estimated Estimated Resources Resources Resources 128 TDA - PEDESTRIAN/BIKE PATH Grants $ 19,305 $ 21,300 $ 21,715 Investment. Earnings 182 1,540 -0- Total 134 HOTEL/MOTEL TAX Taxes $ 19,487 $ 22 ,840 5 21,715 ’ J -9144,039 $156,715 $200,000 y3, 608 Total $144,039 6 156 , 715 $200,000 ’ $ 7,000 140 RESERVE FOR COST OF LABOR & MATERIAL Plan Checking Fees $ 10,055 Miscellaneous Work for Others Police Bail - Other Cities 757 * 1,000 1,000 20,254 14,000 20,000 EIR Consulting Fees 46,610 20,000 2,000 Total $ 77,676 B 42 ,000 B 33 ,000 J 148 FEDERAL REVENUE SHARING Investment Earnings $ 6,760 $ -0- $ -0- Total 8 6,760 $ -0- $ -0- - 22 - I N w I ____ ~ ___- ___'-, SUMMARY OF OPERATING BUDGETS BY DEPARTMENTS SCHEDULE J \'\ 1991-92 Utilities Suppl ies Equipment, Inter Personnel and Trans- and Deprecia- Land and Special Fund Services portati on Ma teri a1 s tion Structures Payments Transfers TOTAL Seri es : 100 200 300 400 500 600 700 $ 17,050 $ 87,770 $ 3,300 - - $ [76,570] $ 191,785 Contingencies - - - - - $ 300,000 - 300,000 General Charges 152,910 305 139,675 - - 3,623,595 - 3,916,485 Debt Service - - - - - 174,080 - 174,080 City Attorney 135,855 2,000 26,370 800 - - [49,505] 115,520 City Manager 550,990 7,805 74,665 1,500 - - [ 168,3051 466,655 Community Development 560,595 5,840 79,605 1,800 - 4,000 651,840 Pol ice 5,587,835 39,890 623,960 42,000 2,965 - - 6,296,650 Fire 2,721,715 30,355 283,670 21,200 1,840 435 - 3,059,215 Equipment Maintenance 341,975 1,580 370,975 287,800- - 3,195 - 1,005,525 0 Equip.Maint.-Credits - - [ 1,002,275] - - - - [1,002,275] 7 Recreation 814,520 61,250 198,795 7,800 2,630 - - 1,084,995 'c Parks 1,066,335 67,695 334,290 35,100 5,350 . 8,000 - 1,516,770 % GENERAL FUND Council/City Clerk $ 160,235 Finance 1,665,255 78,305 225,115 15,300 $ 1,320 - [1,303,995] 681,300 Pub1 ic Works 2,016,060 595,610 861,840 45,100 - 141,595 7,955 [86,650] 3,581,510 r- 0 2 TOTAL GENERAL FUND $15,774,280 $907,685 $2,304,455 $461,700 $155,700 $4,121,26O$Ll,685,025] $22 ,040,055 OTHER FUNDS Electric Utility $ 1,810,390 $26,919,975 $ 681,470 $ 75,600 $159,300 $ 515,245 $1,358,625 $31,520,605' Sewer Uti 1 i ty 999,190 323,235 317,880 355,800 1,320 763,275 152,225 2,912,925 526,380 197,910 7,200 1,320 15,745 174,175 1,377,805 - - - 988,945 Water Utility 455,075 L i brary 663,905 58,600 233 , 730 32,710 TOTAL OTHER FUNDS $ 4,177,895 $27,904,610 $1,536,750 $439,300 $164,415 $1,360,900 $1,685,025 $37,268,895 Comniuni ty Center 249,335 76,420 105,760 700 2,475 33,925 - 468,615 TOTAL OPERATING BUDGETS $19,952,175 $28,812,295 $3,841,205 $901,000 $320,115 $5,482,160 - $59,308,950 I1 / / CTTY OF LOP7 CITY OF LODI OPERATING BUDGET 1991-92 10-001.01 100 200 300 400 600 10-001.02 100 200 300 10-001.03 100 300 500 10-001 -07 2 00 300 City Clerk - Administration Personnel Services $ 92,947 Utilities & Communications 3,841 Suppl ies , Materials & Services 35,721 3,291 34 Depreciation of Equipment Special Payments Total $135,834 El ec ti on Personnel Services 819 Utilities and Communications -0- Supplies, Materials & Services 1,228 Total 42,047 -rvices 24 , 077 Supplies, Materials & Services 26,364 Equipment, Land & Structures 3 , 749 Total Communi ty Information Utilities and Communications $ -0- SUPP Tota ies, Materials & Services -0- 'm $ 95,050 $103,390 4,070 3,800 39,575 33,975 3 , 300 . , -. 3,300 -0- - ,. -0- ' $141,995 ' 5144,465- ' $ 6,580 250 13,750 6,295 $ 12,000 500 $ 44,205 $ 50,265 24 , 500 27 , 500 -0- -0- $ -0- $ 13,000 -0- 23,000 3-0- CONTINGENT FUND 10-015.01 Conti ngent Fund 300 Supplies, Material's & Services $ 18,323 $300 , 000 $300 , 000 Total 4 18,323 3300,000$300,000 Total Contingent Fund - 25 - ,- / CTTY QF LOUT \ 1991-92 OPERATIFiG BUDGET GENERAL CHARGES 1989-90 1990-91 1991-92 Actual Budget Budget 10-020.01 300 600 13-020 -01 100 300 600 10-020.02 300 10-020.05 100 200 300 600 10-020.06 200 300 600 Refuse Collection Contract SuDDlies,Materials & Services $ 44,067 Special Payments 3,2861041 Total $3,330,108 Refuse Surcharge Personnel Services $ -0- Suppl ies, Materials & Services Special Payments 54,395 -0- To ta 1 Insurance Supplies, Materials & Services $ 3,815 Total $3,815 Special Payments - Administration Personnel Services $ 96,097 U ti 1 i ti es & Commu n i cat i on s 302 Supplies, Materials & Services 52,919 Speci a1 Payments -0- Total 8149,318 Community Promotion Utilities & Communications $ 335 Supplies, Materials & Services 13,974 Special Payments 23,245 Total m $ 18,000 3,385,460 $3,403,466 9 -0- 22,000 40 , 000 -62,ooo $ 22,650 'n7Jm $121,000 315 46,620 -0- 5167,935 $ -0- 17,000 46,000 $63,ooo $ 17,900 3,370,000 $3,387,900 S 5,910 27,570 107,750 m' $ 25,020 $251020 $147,000 305 49,885 105,845 $303,035 $ -0- 19,300 40,000 BOND DEBT SERVICE 10-030.01 General Obligation Bond Debt Service 600 Special Payments ., $174,465 $177,865 $174,080 Total 8174,465~ $177,865 8174,080 i! ll - 26 - 1991-92 OPERATING BUDGET CITY ATTORNEY 1989-90 1990-91 1991-92 Ac tua 1 Budget Budget 10-035.01 Counsel and Legal Services 100 Personnel Services $104 , 420 $120,670 $135,855 200 Utilities & Communications 1,027 1,850 2,000 300 Supplies, Materials & Services 15,219 19,795 26 , 370 400 Depreciation of Equipment 711 800 800 Total 8121,377 5143,115 '8165,025 CITY MANAGER 10-040.01 100 200 300 400 500 10-040.02 100 200 300 400 500 30-040.03 100 300 500 31-040.03 100 300 City Manager - Administration Personnel Services $280,494 Utilities & Communications 1,952 Materials & Services 20,006 Depreciation of Equipment 1 , 193 Equipment, Land & Structures 1,863 Total 9305,508 Personnel - Administration Personnel Services $155,911 Utilities & Communications 5,081 Supplies, Materials & Services 46,387 Depreciation of Equipment 319 Equipment, Land & Structures 205 Total 9207,903 Risk Management Personnel Services $ -0- Suppl ies , Materials & Services Equipment, Land & Structures -0- -0- Total Risk Management Personnel Services $ -0- Supplies, Materials & Services -0- Total Total City Manager - 27 - $ -0- $269,085 2,230 30,695 1,200 600 $303,810 $166 , 905 5,405 50 , 550 400 -0- $223,260 $ 50,280 2,070 2,700 ~m $ -0- -0- m $291,935 2,305 31,815 800 -0- 4326,855 $178,620 5,500 41,350 700 -0- 9226,170 $ 26,785 500 -0- $27,285 $ 53,650 1,000 -54,650 1991-92 OPERATING BUDGET 1989-90 1990-91 1991-92 Ac tua 1 Budget Budget COMMUNITY DEVELOPMENT DEPARTMENT 10-045.01 Planning - Administration 100 Personnel Services 200 Uti 1 i ties & Communications 300 400 Depreciation of Equipment 500 Equipment, Land & Structures Supplies , Materials & Services Total 10-045.02 Building Inspection 100 Personnel Services 200 Uti 1 i ties & Communications 300 Supplies, Materials & Services 400 Depreciation of Equipment 500 Equipment, Land & Structures 600 Special Payments Total v6.b &-301.02 HUD Fair Housing 100 Personnel Services $209,809 2,305 133,959 796 $346,869 $260,448 2,615 45,667 900 536 3,411 S313,5f7 $ -0- $224,580 2,985 23,810 2,600 600 8254,575 $269,745 2,740 44,905 900 -0- 6,000 ?zn-zn 4 -0- Total L7 100 Personnel Services 45J'-301.03 Code Enforcement $ -0- $ -0- Total b 45 .X-301.01 Grant Adminis trati on 100 Personnel Services Total Total Communi ty Development FINANCE DEPARTMENT 10-050.01 Admi ni strati on 100 Personnel Services. 200 Utilities & Communications 9 20,343 nmn $ 50,225 'nlm3 $225,720 2,800 28,925 800 -0- 3258,245 $282,215 3,040 50 , 680 1,000 -0 - 4 , 000 5340,935~ 4 4,735 54,735 ./ $ 17,195 'm J $ 30,730 my $172 , 198 $182 , 505 $212,260 1.444 1.780 1 , 830 Supplies, Materials & Services 201268 18 345 20,045 2,100 300 500 Equipment, Land & Structures 740 3 75 -0- 400 Depreciation of Equipment 2 , 508 2,400 Total 9197,158 $205,405 $236,235 - 28 - / CTTY C'F LODT 1991-92 OPERATING BUDGET FINANCE DEPARTMENT (continued) 10-050.02 100 200 300 400 500 10-050.03 100 200 300 400 500 10-050.04 100 200 300 4 00 500 10-050.05 100 2 00 300 40 0 500 10-050 -06 100 200 300 400 500 -se rv i ces 1989-90 1990-91 1991-92 Actual Budget Budget $182,431 Utilities & Communications 7,607 Supplies, Materials & Services 18,636 Depreci at i on of Equi pmen t 3 , 262 Equipment, Land & Structures 1,937 Total 5213,873 -Services S 187.609 Utilities & Communications ' 31205 Supplies, Materials & Services 9 , 587 Depreciation of Equipment 235 Equipment, Land & Structures 2,069 Total $202,705 Bi 11 ing Personnel Services 9270,591 U t i 1 i ti es & Commun i cat i on s 39,251 Supplies, Materials & Services 17,670 Equipment, Land & Structures 247 Depreciation of Equipment -0- Total 8327,759 Coll ections & Credit Personnel Services $257,010 Utilities & Communications 5,373 Supplies, Materials & Services 21,003 Depreciation of Equipment 473 Equipment, Land & Structures 211 Total 9284,070 Data Processing Personnel Services $172,776 Utilities & Communications 905 Suppl ies , Materials & Services 21,837 Depreciation of Equipment 17,879 Equipment, Land & Structures 1 , 546 Total 9214,944- $197,655 8,330 27,690 5 , 200 1,750 $240,625 $233,835 3,780 12,045 1,600 1,530 5252,790 $298 , 120 44 , 085 41 , 790 300 1,095 5385,390 $282,055 5,830 24,865 800 2 , 720 5316 , 270 $252,005 80 5 85,915 5,300 1 , 900 $345,925 $2 18 , 955 8,480 29,555 3,300 -0- 9260,290 $270,320 4,150 22,455 1,600 1 , 320 $299,845 $311,335 55,275 25,615 -0- -0- $392,225 9 289 , 020 6,910 28,400 600 -0- 9- $291,310 805 91,490 5,700 -0- 9389,305 - 29 - I 1991-92 OPERATING BUDGET 1989-90 1990-91 1991-92 FINANCE DEPARTMENT (continued) Actual Budget Budget 10-051.02 Parkin Patrol $ 55,776 $ 66,150 $ 72,055 56 1 855 855 100 Mi ces 200 Utilities & Communications 300 Supplies, Materials & Services 6,663 7,010 7,555 400 Depreciation of Equipment 2,334 2,400 2,000 Total $65,334 976,415 VEmz POLICE DEPARTMENT 10-101.01 100 200 300 500 10-103.01 100 200 300 400 500 23- 103.01 200 10-103.05 100 300 10-103.06 100 300 Animal She1 ter Personnel Services $ 66,911 Utilities & Communications 2,269 Supplies, Materials & Services 11,250 Equipment, Land & Structures 270 Total m Pol ice Admi ni strati on Personnel Services $4,534,152 Utilities & Communications 23,845 Supplies, Materials & Services 523,467 Depreciation of Equipment 50 , 586 Equipment, Land & Structures 13,409 Total $5,145,459 Asset Seizure Uti 1 i ties & Communications $ -0- Total Drug Suppression Program - Grant Personnel Services $ 30,903 Supplies, Materials & Services 13,901 Total Drug Suppression Program - City Match Personnel Services $ 25,137 Supplies, Materials & Services 13,882 Total $-mm $ 71,875 9 75,355 2,545 2,750 20,180 11,145 710 -0- $4,833,550 $5,271,635 30 , 135 31,330 503,695 605,615 51,600 42 , 000 14 , 725 2,965 35,433,705 $5,953,545 $ -0- 9 5,810 $ 8,325 $120,455 90 1,200 TTJi5- $103 , 190 $ -0- 1,200 9104,390- 37 - 30 - 1991-92 OPERATING BUDGET POLICE DEPARTMENT (continued) 1989- 90 1990-91 1991-92 Actual Budget Budget 10- 103.07 100 300 10- 104.01 300 CRACN E T Personnel Services $ -0- $111,440 $120,390 Supplies, Materials & Services - 0- 1,200 1,200 To ta 1 'V s112,640 $121,590 Auxiliary Police Supplies, Materials & Services 4 3,538 $ 6,200 $ 4,800 Total m rn-m $4,800 FIRE DEPARTMENT 10-201.01 Administration 100 Personnel Services $2,540,175 200 Utilities & Communications 26,412 300 Supplies, Materials & Services 150 400 Depreciation of Equipment 917 500 Equipment, Land & Structures 699 600 Special Payments 310 10-201.02 Weed Abatement 3 00 Suppl i es Total $2,758,663 $ 300 Total 9 300 $2,519,065 26,590 235,030 31,500 4,860 310 42,817,355 $ 1,700 7 1s $2,721,* 30,355 280,670 21,200 1,840 435 $3,056,215 $ 3,000 83,ooo PUBLIC WORKS DEPARTMENT 10-301.01 Administration 100 Personnel Services $181,621 200 Utilities & Communications 3.130 300 Supplies, Materials & Services 29;578 400 Depreciation of Equipment 30,917 500 Equipment, Land & Structures 6 74 600 Special Payments -0- Total $245,920 - 31 - $192,075 3,685 39 , 500 37 , 150 450 -0- 9272,860 $212,285 3,735 36,730 36 , 000 -0- 80 8288,830 1991-92 OPERATING BUDGET 1989-90 1990-91 1991-92 PUBLIC WORKS DEPARTMENT (continued) Actual Budget Budget 10-302.01 100 200 300 10-302 -02 100 300 10-302.03 100 300 10-302.04 100 300 10-351.01 100 200 300 400 500 600 10-501.01 100 200 300 400 500 600 General Engineering Personnel Services $168 , 342 Utilities & Communications 3,206 Supplies, Materials & Services 13,847 Total 9185,395 Subdivision Engineering Personnel Services $ 97,434 Supplies, Materials & Services ~151 To ta 1 $ 97,219 Encroachment Permits Personnel Services $ 49,213 Supplies, Materials & Services 19 Total g' Traffic Engineering Personnel Services $ 70,289 Supplies, Materials & Services 3,428 Total $73,717 City Building Maintenance Personnel Services $ 100,910 Utilities & Communications 117,554 Suppl ies , Materials & Services 133,881 Depreciation of Equipment 15 , 740 Equipment, Land & Structures 987 Special Payments 4,388 Total 8373,460 Streets Admi ni strati on Personnel Services $ 89,772 Utilities & Communications 46 , 968 Supplies, Materials & Services 254,325 Depreciation of Equipment 5,856 Special Payments 1,603 Equipment, Land & Structures 379 To ta 1 5398,903 $200,140 3,520 18 , 070 5221,730 $115,770 3,450 $119,220 $ 55,610 200 $ 91,670 4,220 rn $106,465 121,885 172,260 6 , 100 925 -0- $407,635 $100 , 165 62 , 100 275 , 295 12,000 -0- 2,635 9452,195- $203,205 3,520 15,910 5222,635 $129,420 9 , 100 3138,520 S 67,030 100 $67,130 $ 85,260 3,775 nLTp75 $118,440 158 , 195 158,510 1,300 14,400 -0- '$450,845 $114,010 62 , 145 279,830 7,800 7 15 2,000 9466,500 - 32 - 1991-92 OPERATING BUDGET 1989-90 1990-91 1991-92 PUBLIC WORKS DEPARTMENT (continued ) Actual Budget Budget 10-502.01 100 300 32-502.02 100 10-502.03 100 300 124-503.01 100 300 500 32-503.02 100 300 32-503.04 100 300 32-503.05 100 300 500 10-503.06 100 300 500 Streets Engineering - Other Personnel Services $ 6,814 Supplies, Materials & Services 2,501 Streets Engineering - Other Personnel Services $ 6,814 Supplies, Materials & Services 2;501 Total m Streets Engineering - Gas Tax Personnel Services $ 6,000 Total .6,oOo Storm System Engineering Personnel Services $ 2,935 Supplies, Materials & Services 1,540 Total ~m Streets Maintenance Personnel Services $ -0- Supplies, Materials & Services 81,543 Equipment, Land & Structures 45,020 Total 4 126,563 Streets Maintenance Personnel Services $257,075 Supplies, Materials & Services 27,507 Total A1 1 ey Maintenance Personnel Services 6 22,384 Supplies, Materials & Services 11,062 Total m Curb & Gutter Maintenance Personnel Services 9 38,058 Supplies, Materials & Service 964 Equipment, Land & Structures 19,009 Total $ 58,031 Tree Maintenance Personnel Services 9114.712 Supplies, Materials & Services 12,125 Equipment, Land 8. Structures 754 To ta 1 $127,591 - 33 - $ 27,370 3,180 $ 7,500 4 7,500 $ 13,890 2,360 9 -0- 70,285 50,000 S 120,285 $353,220 56,075 4409,295 $ 26,295 14,250 $40,545 $ 37,475 950 21,000 $ 59,425 $130,165 18,055 1,330 $149,550 $ 33,045 1,200 rn S 7,500 -0 il $ 16,200 900 $ 17,100 I I* !I $ 40,980 144,250 50,000 $235,230 $301,480 -0- 3301,480 - $ 25,415 14,500 $ 45,905 950 21,000 $137,430 17,755 880 '9156,065 1991-92 OPERATING BUDGET 1989-90 1990-91 1991-92 PUBLIC WORKS DEPARTMENT (continued) Actual Budget Budget 10-503.07 Street Cleaning 100 Personnel Services $129,455 200 Utilities & Communications 9,015 300 Supplies, Materials & Services 33,669 400 Depreciation of Equipment 32,005 600 Special Payment 6,174 500 Equipment, Land & Structures -0 - To ta 1 s210,318 10-503.08 Traffic Control Maintenance 100 Personnel Services $111,013 300 Supplies, Materials & Services 43,577 500 Equipment, Land & Structures 9 , 186 Total s163,776 32-503.08 Traffic Control Maintenance 200 Utilities & Communications $ 29,541 500 Equipment, Land & Structures -0- Total m 10-503.09 Storm System Maintenance 100 Personnel Services $ 66,681 200 Utilities & Communications 14,547 300 Supplies, Materials & Services 11,563 500 Equipment, Land & Structures 156 6 00 Special Payments 5,939 To ta 1 $98,886 10-503.10 Street Light Maintenance 100 Personnel Services $ 33,429 200 Utilities & Communications 228,327 300 Supplies, Materials & Services 5,091 500 Equipment, Land & Structures 39,341 Total 9306,188 10-504.01 Parking Lot Maintenance 100 Personnel Services $ 13,106 300 Supplies, Materials & Services 5,564 To ta 1 m $139,705 -0- 83,710 -0- 400 -0- $223,815 $134,305 57,135 10,375 $201,815 4 34,715 -0- $34,715 $ 76,105 15,100 15,025 -0- 5 , 950 $112,180 S 29,580 262,700 400 38 , 300 $ 14,165 5,230 $191395 $163,930 -0- 85,480 -0- 450 -0- .$249,860 $167,690 57,800 9 , 600 9235,090 $ 44,530 6,500 '$51,030' ' $101,200 18,485 14,625 -0- 5,875 $140 , 185 $ 29,570 305,000 400 38,050 s373,020; 6 16,065 6,680 $22,745 I( I' I: I. !, :I ji - 34- ,- 1991-92 OPERATING BUDGET PUBLIC WORKS DEPARTMENT (continu 10-551.02 Motor Pool 300 !I 11 i/ I 1989-90 1990-91 1991-92 I Ac tua 1 Budget Budget I Supplies, Materials & Services 4 8,237 Total 58,237 $ 7,515 $ 13,345 /I $ 7,515 $13,345 10-551.01 100 200 300 400 5 00 600 700 10-556.01 100 300 400 700 i Equipment Maintenance - Administration Personnel Services 9 116,468 5 136,455 Utilities & Communications 1,332 1,490 1,580 Supplies, Materials & Services 27,679 $146,680 ’ ‘I 26,115 32,905 !I Depreciation of Equipment 4,256 5,900 4,400 :, Equipment, Land & Structures Special Payments Credits Total Equipment Maintenance Personnel Services Supplies, Materials & Services Depreciation of Equipment Credits Tota 1 -0- -0- 859 $150 , 594 $143,849 278,028 342,014 -0- $763,891 2,050 800 [ 172,8101 4 -0- $207,310 282,920 327,680 [817,910] 3 -0- -0- 3,195 [ 188,7601.” $ -0- $195,295 338,070 2 83,400 [813,515] -- Total Equipment Maintenance $914,485 9 -0- $ 3,250 PARKS AND RECREATION DEPARTMENT RECREATION DIVISION 10-701.01 Administration 100 Personnel Services $267,051 S273,OZO $342,455 300 Suppl ies, Materials & Services 49,866 82,075 92,725 400 Depreciation of Equipment 4,539 7,100 7,800 500 Equipment, Land & Structures 8,875 4,000 2 , 330 200 Utilities & Communications 17,783 26,000 11,100 600 Special Payments 14 -0- -0- Total 5348,128 $392,195 3456,410 - 35- I CTTY QF LOD'I '/ \ 1991-92 OPERATING BUDGET 1989-90 1990-91 1991-92 Actual Budget Budget RECREATION DIVISION (continued) 10-702.01 100 300 10-702.02 100 300 10-702 -03 100 200 300 500 10-702.04 100 200 3 00 600 10-702.05 100 200 300 600 10-702.06 100 200 300 5 29,258 8,203 mervi ces Supplies, Materials & Services To ta 1 rn Basketball Personnel Services $ 18,361 Supplies, Materials & Services 12,231 To ta 1 3ziim? Miscellaneous Indoor Activities Personnel Services 9 4.592 utii i ties & communications 1 ;032 Suppl ies, Materials & Services 19,059 Equipment, Land & Structures 242 Total '-r-mE Recreation - Lake Park Personnel Services $ 22,470 Utilities & Communications 324 Supplies, Materials & Services 7 38 Special Payments 10,084 To ta 1 m Baseball & Softball Personnel Services $ 73,570 Utilities & Communications 24,905 Supplies, Materials & Services 9 , 982 Special Payments 1,792 Total 8110,249 Miscellaneous Outdoor Activities Personnel Services $ 34,215 Utilities & Communications 3,025 Supplies, Materials & Services 9,343 Total $ 46,583 - 36- $ 51,250 9,100 nxmo $ -0- -0 - 7 $ -0- -0- -0- -0- $ -0- $ -0- -0- -0- -0- m 9 -0- -0- -0- -0- ~V $ -0- -0- -0- $ -0- $ 64,720 7,640 5- $ -0- -0- $7 $ -0- -0- -0- -0- 3-0- $ -0- -0- -0- -0- $-O- $ -0- -0- -0- -0- n $ -0- -0- -0- m ,. 4: ., !i 1991-92 OPERATING BUDGET 1989-90 1990-91 1991-92 RECREATION DIVISION (continued) Actual Budget Budget 10-702.07 100 200 300 500 10-702.08 200 300 10-702.09 300 22-702.15 100 200 300 500 10-702.30 100 300 10-702.02 100 300 500 10-702.03 100 200 300 500 $ 33,145 17,535 1,527 Wrvices Utilities & Communications Suppl ies, Materials & Services Equipment, Land & Structures -0- Total ~nmr Lodi High [ool Uti ities Communications $ 173 -- Supplies, Materials & Services 64 To ta 1 5 237 Tokay High Pool Supplies, Materials & Services $ 29,172 Total E%%i%Zv ices $ 73.143 Utilities & Communications 735 Supplies, Materials & Services 20,891 Equipment, Land & Structures 253 Total Recreation Mi scel 1 aneous Personnel Services $ 50,532 Supplies, Materials & Services 9,499 Total rn Youth-Teen Sports Personnel Services $ -0- Supplies, Materials & Services -0- Equipment, Land & Structures -0- Total m Miscellaneous Indoor/Outdoor Activities Personnel Services $ -0- Utilities & Communications -0- Supplies, Materials & Services -0- Equipment, Land & Structures -0- Total B-0- - 37- 4 -0- -0- - 0- -0- $ -0- $ -0- -0- 9 -0- $ -0- $ -0- S 82,260 1,000 23,000 900 $mTJm 9 -0- -0- --o- $ 71,480 9,700 -0- nTJm $ 8,515 1,700 12,300 -0- 322,515 $ -0- -0- -0- -0- m $ -0- -0- 7 $ -0- -0- $ 77,045 600 14,150 - 0- -91,795 $ -0- -0- m 78,255 9,900 3 00 -88,455 $ 7,890 1,250 5,000 -0- $14,140 1991-92 OPERATING BUDGET 1989-90 1990-91 1991-92 RECREATION DIVISION (continued) Actual Budget Budget 10-702.04 100 200 300 600 10-702.05 100 200 300 600 10-702.06 100 200 300 Aquatics Personnel Services 6 -0- Utilities & Communications -0- Supplies, Materials & Services -0 - Special Payments -0 - Total T mrvi ces 9 -0- Utilities & Communications -0- Supplies, Materials & Services -0- Special Payments -0- To ta 1 m Speci a1 ty C1 asses Personnel Services $ -0- Uti 1 i ties & Communications -0- Supplies, Materials & Services -0- Total $ -0- $ 89,570 17 , 150 35,450 -0- 5142,170 $ 60,705 29,700 18,030 9,000 s117,435 $ 39,945 -0- 2,800 9v2,745 $ 99,400 19,000 34 , 200 -0- 5152,600 $ 86,560 29 , 300 31,180 -0- s147,040 $ 58,195 -0- 4,000 nzn5 Total Recreation Division $868,223 9965,750 51,084,995 PARKS DIVISION 10-751.01 100 200 300 400 500 10-752.01 100 200 300 500 Parks Adrni n i strati on Personnel Services $150,450 $210,375 $229,095 Utilities & Communications ' 21952 3,295 4,015 Supplies, Materials & Services 17,681 14,085 11,705 Depreciation of Equipment -0- -0- 8,400 Equipment, Land & Structures 11,766 445 -0- Total $182,849 $228,200 5- Stadium Maintenance Personnel Services $ 44,953 $ 37,545 $ 36,520 Utilities & Communications 3,371 4,200 4,045 Supplies, Materials & Services 5,862 10,925 13,850 Equipment, Land & Structures -0- 11,000 -0- Total '$54,186 '63,670 -54,415 - 38- 1991-92 OPERATING BUDGET PARKS DIVISION (continued) 10-752.02 100 200 300 500 600 10-752.03 100 200 300 400 500 10-752.08 100 300 10-753.0 1 100 200 300 400 500 600 Lodi Lake Park Personnel Services 1989-90 1990-91 1991-92 Actual Budget Budget $181,185 Utilities & Communications 5,672 Supplies, Materials & Services 34,855 Equipment, Land & Structures 1 , 107 Special Payments -0- Total 9222,819 Other Parks Personnel Services $461 , 684 Utilities & Communications 37,858 Supplies, Materials & Services 116,210 Equipment, Land & Structures 9,464 Depreciation of Equipment -0- Total $625,216 $ -0- -0- mrvices Suppl ies , Materials & Services To ta 1 --o- Equipment Maintenance Personnel Services 4 40,443 Utilities & Communications 392 Supplies, Materials & Services 96,502 Depreciation of Equipment 31,037 Equipment, Land & Structures 6,106 Special Payments 200 Tota 1 $174,680 $130,415 7,140 36,300 600 -0- ~9174,455 4503,435 42,285 140,515 -0- 6,000 9692,235 $ 69,925 6,535 rn 4 36,100 290 79,395 31 , 100 2,050 -0- $148,935 $130 , 085 6,825 32 , 150 500 8,000 -8177,560 $541,315 52,235 143,015 200 450 9737,215 $ 87,250 16,350 $103,6oO $ 42,070 575 117,220 26,500 4,400 -0- $190,765 Total Parks Division $1,259,750 41,383,955 $1,516,770 Less Inter-Fund Transfers [$2,382,035] [$1,600,910] [$1,685,025] 1991-92 OPERATING BUDGET LIBRARY FUND 1989-90 1990-91 1991-92 Actual Budget Budget 21-801.01 Adrnini s tra ti on 100 Personnel Services $538,321 $617,060 $663,905 200 Uti 1 ities & Communications 47,337 50,850 58,600 233 , 730 300 Supplies, Materials & Services 194,836 600 Special Payments 7,673 8,650 32,710 222 , 160 Total $788,167 8898,7209988,945 Total Library Fund - 40 - 1991-92 OPERATING BUDGET ELECTRIC UTILITY FUND 1989-90 1990-91 1991-92 Actual Budget Budget 16-601.01 100 200 300 400 500 600 16-601.12 100 200 300 500 16-602.02 100 200 300 500 16-603.02 100 300 500 16-604.02 200 16-604.09 100 2 00 300 500 600 Adm i n i s t r a ti on Personnel Services $ 426,848 Utilities & Communications 19 , 990 Supplies, Materials & Services 380,889 Depreciation of Equipment 56,058 Equipment, Land & Structures 7,270 Special Payments 515,041 Total $1,406,096 $349 , 304 1,930 mervi ces Utilities & Communications Supplies, Materials & Services 7,261 Equipment, Land & Structures 1,930 * Total 9360,425 Customer Service Maintenance Personnel Services $146,119 Utilities & Communications 1,304 Supplies, Materials & Services 4,012 Equipment, Land & Structures 18,049 To ta 1 $169,484 Dusk-to-Dawn Lighting Personnel Services $ 206 Equipment, Land & Structures 47 1 Supplies, Materials & Services -0- Total -677 Bulk Power Purchase Electricity $21,176 , 189 Total $21 , 176 , 189 Hazardous Material Hand1 ing (PCB) Personnel Services $ 19,679 Utilities & Communications 2 Supplies, Materials & Services 19,704 Equipment, Land & Structures 28,445 Special Payments 1,956 Total 'W $ 462,420 $599,255 29,235 27,660 370,325 378,655 60,800 75,600 3,900 2,250 507,610 512,245 41,434,290 $1,595,665 $381,245 $378,475 2,365 2,365 9,005 7,825 2,230 1,550 $394,845 9390,215 $158,445 $167,730 1,620 1,620 6,150 4,700 32,565 26 , 300 $198,780 'm $ 295 $ 295 15 - 0- 400 400 $ 710 n $24,810,000 $26,882,000 $24,810,000 $26,882,000 $ 37,495 $ 37,680 100 100 28 , 025 32 , 725 40,400 40,800 3,000 3,000 j109,020 '9114,305 - 41 - I I' CITY CF LODI 1991-92 OPERATING BUDGET 1989- 90 1990 - 9 1 1991 -92 ELECTRIC UTILITY FUND (continued) Actual Budget Budget 16-604.10 100 200 300 500 16-604.11 100 300 500 16-604.12 100 200 300 500 16-604.13 100 200 300 500 16-604.14 100 300 System Maintenance - Overhead Personnel Services $224,462 Utilities & Communications 46 Supplies, Materials & Services 24,569 Equipment, Land & Structures 69 , 970 Total $319,047 System Maintenance - Underground Personnel Services $ 61,739 Supplies, Materials & Services 8,036 Equipment, Land & Structures 21,748 Total $' Substation Maintenance Personnel Services $ 79.989 Utilities & Communications 29 Supplies, Materials & Services 28,293 Equipment, Land & Structures 29 , 264 To ta 1 9137,575 Sys terns Opera ti on Personnel Services 8172,719 Utilities & Communications 4 ;860 Supplies, Materials & Services 9 , 602 Equipment , Land & Structures 983 Total $188,164 mv i ces $ 9,759 Suppl i es , Materi a1 s i?t Servi ces 133,539 To ta 1 8143,298 $165,065 200 47,200 60,000 $272,465 $ 78,030 9,050 19,700 $106,780 $ 95,590 100 27,930 9,950 $133,570 $180,685 4,675 11,620 1,700 $198,680 $ 9,080 121,300 $130,380 S 165,160 200 58,300 48 , zoo 5211,860 S 90,665 9,700 21,700 9122,065 $131,650 100 40,880 7 , 250 5179,880 $230 , 525 5,930 11,085 750 $ 8,955 147,700 $156,655 Total Electric Utility fund $24 , 062,264 $2 7,789,520 $30,161,986 Inter-Fund Transfers - Other Departments $1,150,790 $1,292,260 $1,358,625 - 42 - 1991-92 OPERATING BUDGET SEWER UTILITY FUND 1989-90 1990-91 1991-92 Actual Budaet Budaet 17-401.01 100 200 300 400 5 00 600 17-402.02 100 300 17-403.01 100 200 300 600 17-404.01 100 200 300 500 17-404.02 100 200 300 17-030.01 600 Admi ni s tra ti on Personnel Services $ 41,670 Uti 1 i ties & Communications ' 11389 Supplies, Materials & Services 82,269 Depreciation of Equipment 17 , 225 Equipment, Land & Structures 2,489 Special Payments 238 Total $145,280 me rv i c e s $ 11,211 Supplies, Materials & Services 2,948 Tota 1 'm Plant Maintenance Personnel Services $482,033 Utilities & Communications 269,837 Supplies, Materials & Services 164,463 Special Payments 3,740 Tota 1 $920,073 Sanitary System Maintenance Personnel Services $153,091 Utilities & Communications 6,047 Supplies, Materials & Services 20,857 Equipment, Land & Structures 78 Tota 1 $180,073 Industrial System Maintenance Personnel Services $ 2,508 Utilities & Communications 2 , 223 Supplies, Materials & Services 169 Total $4,900 Bond Debt - Interest Special Payments $768,647 Total $768,647 $ 72,730 1,620 156,045 31,500 -0- 1,950 '9263,845 $ 17,240 3,960 $ 21,200 $ 605,280 277,280 164 , 950 3,450 513TFjBJ $251,035 7 , 545 24,000 -0- '8282,580 $ 3,470 2 , 355 300 m $736,735 9736,735 $ 67,465 1,700 137,175 24,400 -0- 650 8231,390 $ 19,930 1,350 '$-z-pG $ 669,720 309,555 166,015 20,900 $1 Y 166,190 $238 , 505 9,365 13,040 1,320 ~9262,230 $ 3,570 2,615 300 $741,725 8741,725 - 43- 1991-92 OPERATING BUDGET SEWER UTILITY FUND (conti nued) 17-407.01 Plant Depreciation 400 Deprec i at i on 1989 - 90 1990-91 1991-92 Actual Budget Budget $ 21,393 $ 316,435 $ 331,400 Total -$ 21,393 $ 316,435 -$ 331,400 Total Sewer Utility Fund $2,054,528 $2,677,880 $2,760,700 Inter-Fund Transfers - Other Departments $ 150,298 $ 143,610 $ 152,225 NET SEWER UTILITY FUND - 44- I/ :I [I i ! i I I I I I I 'I !I I' i, ., I- 1991-92 OPERATING BUDGET WATER UTILITY FUND 18-451.01 100 200 300 400 500 600 18-451.03 100 200 300 500 600 18-45 1.05 300 18-452.01 100 300 18-453.01 100 200 ' 300 600 18-453.02 100 200 300 Administration Personnel Services 1989-90 1990-91 1991-92 Actual Budget Budget $ 41,533 Uti 1 i ties & Communications ' 11485 Supplies, Materials & Services 66,286 Depreciation of Equipment 7,514 Equipment, Land & Structures 1,637 Special Payments 313 Total '$118,768 Water Conservation Program Personnel Services ' $ 27,830 Utilities & Communications 209 Supplies, Materials & Services 4,478 Equipment, Land & Structures 337 Speci a1 Payments 200 Total -33,054 Public Facilities Plannin Supplies, Materials & Ser:ices $ 12,428 Total mervices 812,428 $ 17,064 Supplies, Materials & Services 3,265 Total $20,329 Production Personnel Services $135,823 Uti 1 i ties & Communications 377,420 Supplies, Materials & Services 93,639 Special Payments 31 To ta 1 9606,913 DBCP Moni tori nq Personnel Services $ 680 ~ ~- Utilities & Conminications 3,052 Supplies, Materials & Services 8,764 Total .$12,496 $ 69,730 4,650 88,350 7,900 -0- 2,650 9173,280 $ 30,180 325 2,850 -0- 200 m $ -0- m 4 18,690 4,360 $23,050 $10 1 , 870 477,210 87,545 50 $666,675 $ 12,140 16,000 19,000 347,140 $ 97,095 1,700 71,980 7,200 -0- 14,700 9192,675 $ 45,950 550 4,925 -0- 500 m $ -0- m f 29,940 1,550 miJa $123,735 522,130 77,455 545 '8723,865 $ 27,185 2,000 16,900 $46,085 - 45- /;= CTTY L'F LUD'I 1 \ 1991-92 OPERATING BUDGET 1989- 90 1990-91 1991-92 WATER UTILITY FUND (continued) Ac tua 1 Budget Budget 18-454.01 Distribution 100 Personnel Services $182,468 $119 , 395 $120,390 300 Supplies, Materials & Services 27,024 23,200 23,000 500 Equipment, Land & Structures 78 -0- 1,320 Total s209,570 5142,595- 18-455.01 Fire H drants 100 &vices $ 5,722 $ 6,560 $ 10,780 300 Supplies, Materials & Services 236 2 , 100 2,100 To ta 1 m mm Total Water Uti 1 i ty Fund $1,019,516 $1,094,955 $1,203,630 Inter-Fund Transfers - Other Departments $ 154,628 5 165,035 $ 174,175 NET WATER UTILITY FUND - 46- 1991-92 OPERATING BUDGET COMMUNITY CENTER 120-040.03 100 200 300 400 500 120-702.10 200 300 120-702.11 100 200 300 600 120-702.12 100 300 120-702.13 200 300 120-702.14 100 300 Administration Personnel Services 1989-90 1990-91 1991-92 Ac tua 1 Budget Budget 9 85.064 Utilities & Communications 4;359 Supplies, Materials & Services 14,391 Equipment, Land & Structures 2,057 Depreciation of Equipment 973 Total $106,844 Momu n i ca ti on s 9 1.762 Supplies, Materials & Services 21951 To ta 1 FT7n Lodi Arts Commission Personnel Services S 4,263 Utilities & Communications 613 Supplies, Materials & Services 1,907 S pec i a 1 Paymen t s - 0- Total m Community Band Personne Services 9 1,042 Suppl ies , Material s & Services 560 Total 5m Lodi Art Center Uti 1 ities & Communications $ 625 Supplies, Materials & Services 850 Total 41,475 Youth Drama Personnel Services $ 2,000 Supplies , Materials & Services 490 Total $ 2,490 - 47- $ 92,620 6,100 14,960 1 , 100 2,270 5117,050 5 3,080 3,000 5 6,080 5 4,090 900 4,180 18 , 000 m $ 1,105 500 5 1,605 s -0- -0- $ -0- s 2,000 500 $ 2,500 8 99,670 5,500 16,610 700 1,200 -9123,680 8 -0- -0- rn 9 4,200 570 6,320 33,925 Txm 9 -0- -0- --o- 9 -0- '7 $ -0- -0- 'V - 0- 1991-92 OPERATING BUDGET 1991-92 1989-90 1990-91 COMMUNITY CENTER (continued) Actual Budget Budget 120-704.01 Senior Citizens' Commission 100 Personnel Services $ 17,236 $ 57,110 .$ 68,590 2 00 Utilities & Communications 2,560 3,170 3.500 300 Supplies, Materials & Services 3,567 4; 550 5 ; 950 500 Equipment, Land & Structures 1,355 -0- To ta 1 524,718 $64,830' n&m 120-752.05 Maintenance 100 Personnel Services $ 48,421 $ 61,675 $ 76,875 35,490 71,700 66,850 200 Utilities & Communications 300 Supplies, Materials & Services 34,914 37,600 76,880 500 Equipment, Land & Structures 1,359 1,230 1,275 To ta 1 Total Community Center GRAND TOTAL: OPERATING BUDGETS $120 , 184 $172 , 205 5221,880 $48,072,837 $54,785,095 $59,261,185 - 48- I ? CTTY OF LOOT EQUIPMENT PURCHASES 1991-92 City Manager Copier $2,000 12.0-013.39 Word Processing Terminal $1,300 12.0-013.40 92,000 51,300 $3,300 Community Center Copier Tables & chairs $ 2,000 11,085 $4,125 12.0-013.41 12.0-013.42 $13,085 54,125 $17,210 Community Development Department Personal Computers (5) $26 , 200 12.0-013.43 Pickups (3) $37,975 12.0-013.44 $26 , 200 $37,975 $64,175 Electric Utility Department Airbrush $ 1,250 Battery Analyzer Computer (lap top) Personal Computers (2) Welder - TIG Air Compressor Compression Tools Hydraulic Pump Pickup 11,500 6,500 8,500 7,000 16.1-680.44 16.1-680.43 16.1-680.42 16.1-680.41 16.1-680.40 $20,000 16.1-680.39 4,800 16.1-680.38 4,000 16.1-680.37 15,000 16.1-680.36 $34,750 $43,800 - 49 - 1 EQUIPMENT PURCHASES 1991-92 New Rep1 acement Total Account Number .. ,. // 'I .I I i /j /j /i /I I , Finance Department Air Conditioninq for Van Personal Computer Warehouse Racking Storage Racks Pri n ter Sedan Termi nal Fi re Department Sedan Engine $ 1,000 6,045 2,985 4,400 $ 1,250 8,000 1,300 12.0-013.45 12.0-013.46 16.1-680.45 16.1-680.46 12.0-013.47 12.0-013.48 12.0-013.49 $14,430 $10 , 550 $24,980 $15,000 - 12.0-013.50 Note 1 $15,000 $15,000 Parks and Recreation Department Sprinkler System Control $2,355 12.0-013.51 $2,355 $2,355 Police Department Mobile Records File Radios (2) Light Bars ( Motorcycles Photocopier Pol ice Cars (3) Radar Guns (3) Sedans (2) Van Voice Logging Recorder $11,275 4,420 $12,000 15,885 24,920 45 , 000 3,195 17,000 14,620 11,925 12.0-013.52 12.0-013.53 12.0-013.54 12.0-013.55 12.0-013.56 12.0-013.72 12.0-013.70 12.0-013.57 12 .O-013.58 12.0-013.59 $15,695 $144,545 $160,240 - 50 - EQUIPMENT PURCHASES 1991-92 Public Works Department Bar 90 Test Analyzer (smog check) Fi 1 e Cabinets Loader/ Bac kh oe Local Area Network System Welding Exhaust System Cab & Chassis One-Ton Compressor Dump Truck Generator Leaf Rake Roller and Trailer Sedan $ 20,725 12.0-013.60 3,380 45,200 30,000 4,525 $ 22,100 4,580 51,340 15,840 6,250 28,355 13,000 12 .O-013.61' Note 2 124.0-012.06 12.0-013.62 12.0-013.71 12.0-013.63 12.0-013.64 12.0-013.65 12.0-013.66 12.0-013.67 12.0-013.68 $103,830 $141,465 $245,295 Water/Wastewater: Water Detection Equipment $4,200 Compressor and Pnuematic Tools $ 16,700 Pnuematic Sump Pump 1,230 Van with TV Inspection Equipment 158,150 Wacker Tamper 2,240 18.1012.29 Note 3 Note 4 17.1012.34 Note 5 $4,200 $178,320 $182,520 White Slough Door Opener Clarifier Repairs Laboratory Van $1,175 17.2-012.08 $27,000 17,575 17.2-012.09 17.2-012.10 $1,175 $44,575 $45,750 TOTAL EQUIPMENT PURCHASES $217,720 $621,655 $839,375 - 51 - EQUIPMENT PURCHASES 1991-92 SUMMARY Fund Amount Equipment Fund (new) (12.0) Equipment Fund (replacement) (12.0) Sewer Capital (17.1) Water Capital (18.1) Utility Outlay Reserve (16.1) Gas Tax (32.0) Wastewater Capital Outlay (17.2) Transportation Development Act (124) TOTA $102,510 ’ 354,960’ 175,735 ’ 21,785 , 85,935 ’ 7,500 J 45,750 45,200 $839,375 -------- -------- .................................................................................. Note 1 Purchase price $200,000 Lease purchase Note 2 $7,500 17.1-013.69 7,500 18.1-013.69 7,500 32-013.69 7,500 12.0-013.69 Note 3 $8,350 17.1-012.36 8,350 18.1-012.36 Note 4 $ 615 17.1-012.37 615 18-1-012.37 Note 5 $1,120 17.1-012.38 1,120 18.1-012.38 - 52 - Authorized Authorized Net 1990-91 1991-92 Change ADMINISTRATION Administrative Assistant to the City Manager 2 Administrative C1 erk 1/1 I 2 Assistant City Manager 1 City Attorney 1 City Clerk 1 City Manager 1 Community Center Director 1 Deputy City C1 erk 1 Legal Secretary 1 Personnel Analyst 1/11 1 Personnel Director 1 Personnel Technician 2 Secretary to the City Manager 1 Senior Services Coordinator 1 COMMUNITY DEVELOPMENT DEPARTMENT 2 2 1 1 1 1 1 1 1 1 1 2 1 1 Total 17 17 -0- Administrative Clerk I11 Building Inspector 1/11 Chief Building Inspector Community Development Director Department Secretary Jr./Assistant/Associate Planner Sr. Building Inspector Sr. Planner 8V Total 11 11 -0- - 53 - i I / CTTY c7F LODT City of Lodi Personnel 1991-92 Authorized Authorized Net Change 1991-92 1990-91 ELECTRIC UTILITY DEPARTMENT Administrative Clerk 1/11 1 Assistant Electric Utility Director 1 Department Secre ta ry Electric Apparatus Mechanic Electric Data TechlRelief Operator Electric Foreman/Forewoman Electric Lineman/Linewoman Electric Meter Technician Electric Systems Supervisor Electric Troubleshooter Electric Utility Director Electric Utility Rate Analyst ,Electric Utility Superintendent Electric Utility Supervisor Electrical Engineer Electrical Engineer-Standards El ectri ca 1 Estimator El ec tri ca 1 Estimator Assistant Electrical Technician Electrician Manager - Rates and Resources Metering Electrician Sr. Electric Utility Rate Analyst Utility Operations Supervisor Util i ty Service Operator 1/1 I 1 1 1 3 7 1 1 3 1 1 1 1 1 1 3 1 2 2 1 1 1 1 3 1 1 1 1 1 3 7 1 1 3 1 1 1 1 1 1 3 1 2 2 1 1 1 1 1 Total 41 41 -0- - 54 - 1 CITY OF lOV1 City of Lodi Personnel 1991- 92 Authorized Authorized Net 1990-91 1991-92 Change FINANCE DEPARTMENT Account Clerk Accountant 1/11 Accounts Collector Assistant Finance Director Buyer Data Processing Manager Data Processing Operations Specialist Data Processing Programmer/Analyst 1/11 Department Secretary Field Services Supervisor Finance Director Meter Reader Parking Enforcement Assistant Purchasing Assistant Purchasing Officer Revenue/Collection Technician Sr. Account Clerk Sr. Programmer Analyst Sr . Store keeper/Buyer Storekeeper 6... - %&?j FIRE DEPARTMENT Administrative Clerk 111 Fi re Admi nis trati ve Officer Fire Battalion Chief Fire Captain Fire Chief Fi refighter I/Il/Fi re Engineer Fire Inspector LIBRARY Building Service Worker Children's Librarian Librarian Librarian 1/11 Library Assistant Manager of Adult Services Sr. Library Assistant 12 2 2 1 1 1 1 2 1 1 1 4 2 1 1 1 2 2 1 1 12 2 2 1 1 1 1 2 1 1 1 4 2 1 1 1 2 2 1 1 Total 40 40 -0- 2 3 3 -20 1 30 1 1 Total 49 49 -0- Total 15 15 -0- - 55 - J City of Lodi Personnel 1991-92 Authorized Authorized Net 1990-91 1991-92 Change PARKS AND RECREATION DEPARTMENT Administrative Clerk 1/11 2 Department Secretary 1 Laborer/Park Maintenance Worker 1/11 13 Park Maintenance Worker I11 Park Ranger 1/11 Park Supervisor Parks Superintendent Recreation and Parks Director Recreation Supervisor Recreation Superintendent Sr. Building Maintenance Worker Sr. Park Ranger Welder-Mechanic POLICE DEPARTMENT Administrative Assistant Animal Control Officer Assistant Animal Control Officer Communi ty Services Officer Crime Analyst Department Secretary Di spa tcher-Jai 1 er/Matron Police Chief Pol ice Captain Police Lieutenant 6 1 2 1 1 3 1 1 1 1 2 1 13 2 i 3 1 1 1 1 7 I , -- Total 34 1 1 I 7 1 1 15 1 3 4 1y7 Police Officer Trainee II/Police Officer 52 52 Police Records Clerk 1/11 4 4Y Pol ice Records Clerk I11 4 4- Police Sergeant 9 9.2. Sep i ce/s Di v i s i on Su perv i sor 1 lq Total 105 105 -0- - 56 - I /- C7TY OF LODT City of Lodi Personnel 1991-92 Authorized Authorized Net 1990-9 1 1991-92 Change PUBLIC WORKS DEPARTMENT Admi n i strati on Administrative Assistant Administrative C1 erk 1/1 I Department Secretary Pub1 ic Works Director Engineering Division Assistant City Engineer Engineering Assistant Engineering Technician 1/11 Engineering Technician Supervisor Jr./Assistant/Associate Civil Engineer Sr. Civil Engineer Sr. Engineering Technician Public Works Inspector 1/11 1 1 1 1 1 1 1 1 4 4 -0- 15 15 -0- Buildina and EauiDrnent Maintenance Building & Equipment Maintenance Building Maintenance Worker Equipment Maintenance Supervisor Equipment Parts Coordinator Equipment Service Worker Heavy Equipment Mechanic Lead Equipment Mechanic Sr. Building Maintenance Worker We1 der-Mechanic Superintendent - 57 - 0- f C7TY QF LORI ,/ '\ City of Lodi Personnel 1991-92 Authorized Authorized Net 1990-91 1991-92 Change PUBLIC WORKS DEPARTMENT - continued Streets Division Administrative Clerk I1 Administrative Clerk I11 Assistant Street Superintendent Sr. Tree Trimmer Laborer/Maintenance Worker 1/11 Street Maintenance Worker I11 Street Supervisor Street Superintendent Street Sweeper Operator Tree Trimmer 1 1 1 1 14 6 2 1 1 2 1 1 1 1 14 6 2 1 1 2 Chief Wastewater P1 ant Operator Laboratory Technician 1/11 Plant & Equipment Mechanic Laboratory Services Supervisor Laborer/Maintenance Worker 1/11 Water/Wastewater Plant Operator 1/11 Wastewater Treatment Supervisor Wa ter/Was tewa ter Inspector Water/Wastewater Maintenance Worker I11 Water/Was tewa ter Supervisor Water/Wastewater Superintendent Total Public Works 11 I' It 'I Water/Wastewater Division Assistant Water/Wastewater SuDerintendent 1 TOTAL AUTHORIZED PERSONNEL - 58 - 30 30 -0- 1 2 4 1 9 5 1 2 5 3 1 1 1 2 4 1 9 5 1 2 5 3 1 35 35 -0 - 1 -0- ELECTRIC UTILITY OUTLAY BUDGET 1991-92 1989-90 1990-91 1991-92 Actual Budget Budget 16.1-650.02 System Improvement 100 Personnel Services 9158.158 .~ ,- 300 Supplies, Materials & Services 7,213 500 Equipment, Land & Structures' 184,872 Total 8350,243 16.1-650.03 Service Connections (Customer) 100 Personnel Services - S 17.599 300 Supplies, Materials & Services 1 ;625 500 Equipment, Land & Structures 43,251 To ta 1 16.1-650.04 Lighting Construction (Dusk-to-Dawn) 100 Personnel Services $ 668 300 Supplies, Materials & Services -0- 500 Equipment, Land & Structures 505 Total rn 16.1-650.11 New Business 100 Personnel Services $l -0- 300 Supplies, Materials & Services -0- 500 Equipment, Land & Structures -0- Total 7 16.1-650.23 Substation Construction 100 Personnel Services $ 5,153 300 Suppl i es, Materi a1 s & Servi ces 452 500 Equipment, Land & Structures 77.456 Total $ 83,061 16.1-650.37 Industrial Substation - E.I.R. 300 Supplies, Materials & Services $ 43,207 Total $245,095 8 , 200 173,400 $426 , 695 S 23,185 1,250 36,000 n 4 1,035 30 1,050 5 2,115 $ 7,400 200 7,000 $14,600 $145,765 21,650 452 , 150 $619,565 4 -0- 9 -0- $272,705 10,200 151,400 $434,305 .$ 11,825 950 24,000 936,775 $ 1,025 -0- 1,000 32,025 $ -0- -0- -0- $3 $ 79,800 5,600 182,300 9267,700 $ -0- r-=r - 59 - 1991-92 OPERATING BUDGET 1989-90 1990-91 1991-92 ELECTRIC UTILITY OUTLAY BUDGET (continued) Actual Budget Budget 16.1-650.38 Industrial Substation - Site Acquisition 100 Personnel Services $ 1,197 300 6,850 500 Equipment, Land & Structures 301 , 130 Suppl ies , Ma teri a1 s & Services 600 Special Payments 974 Total 16.1-650.39 Industrial Substation - Off-Site Engineer & Improvements 100 Personnei Services $ 1,723 300 Supplies, Materials & Services 12,516 500 Equipment, Land & Structures 455 Total 16.1-650.40 I ndustri a1 Substation - Design, System Analysis 100 Personnel Services $ 306 200 Utilities & Communications 98 300 Supplies, Materials & Services 531,426 500 Equipment, Land & Structures 868 Total 9532,698 16.1-650.41 Industrial Substation - Construction 300 Supplies, Material & Services $ 9,930 500 Equipment, Land & Structures 3,874,635 Total $3,884,565 16.1-650.42 Industrial Substation - 60KV Lines 100 Personnel Services $ 7,666 500 Equipment, Land & Structures 82 , 959 300 Supplies, Materials & Services 79 Total 16.1-650.43 Industrial Substation - 60KV Lines 300 Supplies, Materials & Services $ 4,255 500 Equipment, Land & Structures 490,000 Total 6494,255 5 -0- -0- -0 - -0- m $ -0- -0 - -0 - .r $ -0- -0- -0- -0 - m $ -0- -0- $ -0- $ 69,550 600 77,400 $147,550 $ -0- -0- $ -0- $ -0- -0 - -0- -0- $-O- $ -0- -0- -0- 7 $ -0- -0 - -0 - -0- '$7 $ -0- -0- .m $ -0- -0- -0- m 8 -0- -0- m - 60 - 2 CZTY C'F 1991-92 Operating Budget 1989-90 1990-91 1991-92 Actual Budget Budget LITY OUTLAY BUDGET (continued ELECTRIC UT 16.1-650.45 100 300 5 00 Industrial Substation-12KV Lines Personnel $ -0- $ -0- $ 46,700 2 , 200 69,500 Supplies, Materials & Services Equipment, Land & Structures -0- -0- -0- -0- '9118,400 Total 9 -0- 16.1-655.06 100 300 500 Lodi Avenue Underground Personnel Services Supplies, Materials & Services Equipment, Land & Structures $ 4,483 15 1 1,851 $ -0- -0- -0- $ -0- -0- - 0- Total 16.1-680.01 100 500 System Equipment Purchases Personnel Services Equipment, Land & Structures $ 1,399 317,907 5 -0- 157,255 9319,306 $157,255 Total Total Electr lity Out ay Budget '36,193,01/ ¶¶ 5 937,155 c Ut +-I - 61- II II II I1 CITY C'F LOP1 I1 -1 I C I I- I 0 1 I- I I II II II m II L H ii L aJ II aJu+ II c, t mo II c3eo It ULL ah II L v, t- w CY 3 n m > I- -1 - II *I-- II L II aJ II v,!- II W II CY I1 n II 3 I1 m II I1 a I1 z II - If c LnLnom Ln 0 moom Wdmm 0 W IDComm WNmW m .Inn n 00, 0_00,Cu_'D_ " 4 64 Ill1 I 1 Ill1 N m 4 m 64 0000 0 0 000 -moo 0 0 omm Nmmd -a- 0 0 WIII I I Ill1 m h te mm0 LONO WWh *In ah* h m te Ln 0 oolno N 0 oa3coo h N hmoh om0 00 00 WWN 00 Om hNl-4 Ln N 64 'D,m,'D, I l-4 N I dor I a 7 m c, 0 t- I 3 v, n 0 0 N a3 W w te 0, 00, I I 1 I I 0 0 0, "0, N a3 W N e+ I aJ m a r W L 3 a L aJ 5 n Y 3 c m Ln 0 W 0 N Ln 4 m 6=t 0. n m N W a3 Ln n m 4 - m d N Ln d m * 0 0 m m m 4 * n I 0 0 W Ln h te I m h m cn W te n 4 In h Q', cn 4 m W N - 0 cn c3 0 n .) 4 co, 4 +f, 0, c aaJ Lrn wu a3 om - a c, 0 I- Ln Ln h h m cn 64 n I I 0 m h n co I 0 m m Q n 4 cf, I ln Ln 0 n N 4 d tt, I. :: \ - 63 - I / CTTY QF LODl -I 0 -I D I- m r m c, -I 0 c E r! I- -I 4 0 c 4 r > 4 - c 0 0 m -I II II II II 6+ II P II w II N II " II 0 II Ln II ul II II II II II II II II II II II II II #i II r II Q3 II " II a II ul II 0 It II II II II II II II II II II * II Ln II 0 II cn II u II U II ul II 0 II II II II II II II II II II II * II Lo II w II u II " II u II Ln II ul II II II v, k v) rt ID 3 n m IT U 3 ID 3 rt -0 IT 7 n 3 P, v) ID v) A. I I U Q3 vl cn 0 " U 03 ul ul 0 " H 3 t v) rt n 2. DJ v, t 0- VI rt Pl rt 0 3 w N I x < r =I ID v) A. A. P m U 0 0 " N N 0 0 " Q, a ul 0 0 U w w 03 P 0 0 u v, t 0- v) rt P, rt 0 3 m 0 =1 v) rt 7 t c) rl. 0 3 A. A. v a 03 0 0 " vl cn 0 0 r w 03 N W 0 0 " N m v U 0 0 u I- A. Lo J rt 3 Lo m 0 3 v) rt 1 IT c) A. r;: 0 3 h u c v) 77 1 r? 0 I D BJ 5 v w " 0 N Ln I w " 0 0 0 Iu 0 N ul " Cn ID 7 < n ID m 0 S =I ID 0 rt 0 3 v) A. A. - m c v) rt 0 2 7 v) v w w " (33 Iu ul a ul 0 N P 0 0 0 " w m U U vl " Cn 2 rt ID 3 3 U 7 0 < ID 3 ID 3 rt v) u v, ID m In 2. .. 43+ N v N U 0 ul " tf, w 0 " N 0 0 tff w u, w P 0 0 " w P w P W 0 ul 4 0 -4 D I- Ln c z 3 D A < 0 -n \ - 64 - /- ++ CTTY L'F LOD7 SCHEDULE K EST I - DENTAL INSURANCE AND LONG-TERM DISABILITY INSURANCE RESERVE STATEMENT Of RESOURCES AND REQUIREMENTS 1991-92 TED FINANCING RESOURCES INTERFUND TRANSFERS Dental Cost Allocations $173,360 Long-Term Disability Cost Allocations 89,585 Employees' Contribution 25,420 COBRA Participant Payments 1,800 To ta 1 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REOUIREMENTS OPERATING EXPENSES Dental Claims Dental Claims Administration Long-Term Disability Claims Total CONTRIBUTIONS TO OTHER FUNDS Self-Insured Reserve Total TOTAL ESTIMATED REQUIREMENTS $165,650 ',' 33,130's 10,000; $ 81,385 iK 9290.165 .~ , $208,780 81,385 - 65 - / / CTJY OF LODT \ 3" PUBLIC LIABILITY INSURANCE RESERVE STATEMENT OF RESOURCES AND REQUIREMENTS 1991-92 ESTIMATED FINANCING RESOURCES CONTRIBUTIONS FROM OTHER FUNDS REIMBURSEMENTS INTEREST TOTAL ESTIMATED RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Professional Services Insurance Premi ums Claims Expenses Tota CS Total - (1) SELF-INSURED RESERVE TOTAL ESTIMATED REQUIREMENTS $268,225 $ 70,000 .$ 49,500 $ 42,600 122,500 75,000 1,000 $241,100 $ 27,285 $ 27,2850 $119,340 \J, I, :I I I' SCHEDULE L (1) To pay 1/3 of Risk Management Fund (30-040.03) - 66 - WORKERS' COMPENSATION INSURANCE RESERVE STATEMENT OF RESOURCES AND REQUIREMENTS 1991-92 I I t f MEDICAL INSURANCE FUND 28.020.02 Medical Insurance 100 Personnel Services 300 Supplies, Materials & Services 600 Special Payment Total Total Medical Fund DENTAL & LONG-TERM DISABILITY FUND 29-020.02 Dental Insurance 100 Personnel Services 300 Suppl ies, Materials & Services 600 Special Payment Total 29-020.03 Long-Term Disability 100 Personnel Services 300 Supplies, Materials 600 Special Payments & Services Total Total Dental & Long-Term Di sabi 1 i ty Fund Total 1989-90 1990-91 1991-92 Actual Budget Budget '$174,158 $ 64,000 $ -0- 247,471 372,600 13,000 56,868 -0- -0- $478,497 $436,600 5 13,000 $ 25,580 $ -0- $ -0- 121,159 162,600 198,780 13,220 -0- -0- 9159,959 $iKmm %198,780 $87,477 $ -0- $ 32,500 14,052 15,000 10,000 20,509 -0- -0- ~T-iTJm~ $281,997 $177,600 - 69 - / /I C7TY OF LOU7 Sel f-Insurance Funds 1991-92 PUBLIC LIABILITY FUND 1989-90 1990- 9 1 1991-92 Ac tua 1 Budget Budget 30-020.02 PL !I PD Insurance 300 Supplies, Materials & Services $462,873 $206,000 $241,100 6 00 Special Payments 397,943 -0- -0- Total $860,816 $206,000 3- Total Public Liability Insurance Fund '$860,816 $206,000 $241,100 Less Inter-Fund Transfers - Enterprise Funds Total $[98,098] $ -0- $ -0- WORKERS' COMPENSATION INSURANCE FUND 31-020.02 Workers' Compensation Insurance 100 Personnel Services $233,285 $153,215 $133,800 3 00 Supplies, Materials & Services 288 , 903 261,355 232,000 5 00 Equipment, Land & Structures 457 350 550 Total 8522,689 $415,120 $366,350 200 Utilities & Transportation 44 200 -0- Less Credit $[ 182,0751 $ -0- $ -0- $340,6 14 $415,120 $366,350 .................................. .................................. Total Workers' Compensation Fund -A \ - /u - ,- /- CTTY C'F LODT WASTEWATER CAPITAL OUTLAY STATEMENT OF RESOURCES AND REQUIREMENTS 1991-92 ESTIMATED FINANCING INTER-FUND TRANSFERS Plant and Equipment Depreciation Sewer Fund Total TOTAL ESTIMATED FINANCING ESTIMATED REQUIREMENTS BOND PRINCIPAL EQUIPMENT WASTEWATER CAPITAL RESERVE - $331,400 I! 338,680 *7 ' CL $670 , 080 $257,950 * $ 45,750 -L m 9366.380 $7 .r TOTAL ESTIMATED REQUIREMENTS $670 - 71 - I. /' P' i /-- I CTTY OF LODl $1 SCHEDULE 0 CHIROPRACTIC SELF-INSURANCE FUND 1991-92 STATEMENT OF RESOURCES AND REQUIREMENTS EST I MAT ED F I NANC I NG RESOURCES I NTERFUND TRANSFERS Cost Allocations $23,580 Tota 1 $23,580 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REOUI REMENTS OPERATING EXPENSES Chiropractic Payments Total CONTRIBUTIONS TO OTHER FUNDS Self-Insured Reserve Total TOTAL ESTIMATED REQUIREMENTS $13,000 $13,000 - $10,580 t 9 10,580 \ - 73 -