Loading...
HomeMy WebLinkAboutBudget FY 1987-1988• CITY OF LODI • CITY OF LODI • CITY OF LODI • CITY OF LODI • O 1987-1988 RECOMMENDED 0 BUDGET CITY OF LODI CALIFORNIA • • AS SUBMITTED TO THE MAYOR AND CITY COUNCIL BY CITY MANAGER THOMAS A. PETERSON CITY OF LOD1 CITY OF LODI CALIFORNIA CITY COUNCIL EVELYN M. OLSON, MAYOR John R. (Randy) Snider Mayor Pro Tempore David M. Hinchman Member,.City Council James W. Pinkerton, Jr. Member, City Council Fred M. Reid Member, City Council PRINCIPAL ADMINISTRATIVE OFFICERS City Manager.........................Thomas A. Peterson Assistant City Manager...................Jerry L. Glenn Administrative Assistant .... .......... William M. Hinkle City Attorney... _ ... .Ronald M. Stein City.Clerk.............................. Alice M. Reimche Community Development Director... .... James B. Schroeder Community Center Director.............Charlene J. Lange 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 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: 9.450 square miles Population: State Estimate - 1982 .... 36,928 State Estimate - 1983 .... 38,318 State Estimate - 1984 .... 39,475 State Estimate - 1985 .... 41,281 State Estimate - 1986 .... 43,293 State Estimate - 1987 .... 45,794 CITY OF LODI TABLE OF CONTENTS Page CITY MANAGER'S BUDGET MESSAGE . . . . . . . . . . . . . . . . M1 - M37 Page FUND SUMMARIES Total General Budget - Schedule A. . . . . . . . . . 1 General Fund - Schedule B . . . . . . . . . . . . . . . 2 Electric Utility Fund - Schedule C . . . . . . . . . 3 Sewer Utility Fund - Schedule D. . . . . . . . . . . . 4 Water Utility Fund - Schedule E. . . . . . . . . . . . 5 Library Fund - Schedule F. . . . . . . . . . . .. 6 Hutchins Street Square -_Schedule G. . . . . . . . . . 7 Financing Resources - Schedule H . . • . • • • • • • • 9 Special Revenue Funds - Schedule I . . . . . . . . 17 Summary of Operating Budgets by Departments -21 Schedule J . . . . . . . . Dental & Long -Term Disability Insurance Reserves - 57 Schedule K . . . . . . . . . Public Liability Insurance Reserve - Schedule L. . . . 58 Workers' Compensation Insurance Reserve - Schedule M . 59 Wastewater Capital Outlay - Schedule N . . . . . . . . 63 Federal Revenue Sharing - Schedule 0 . . . . . . . . . 64 CITY OF LODI TABLE OF CONTENTS OPERATING BUDGET DETAIL Page Animal Shelter . . . . . . . . . . . . . . 27 Bond Debt Service . . . . . . . . . . . . . 24 Building Inspection. . . . . . . . . . . . 25 City Attorney . . . . . . . . . . . . . . . 24 City Clerk . . . . . . . . . . . . . . . . 23 City Council . . . . . . . . . . . . . . . 23 City Manager . . . . . . . . . . . . . . . 25 Community Development. . . . . . . . . . . 25 Community Center . . . . . . . . . . . . . 41 Community Promotions . . . . . . . . . . . 24 Contingent Fund. . . . . . . . . . . . . 23 Election . . . . . . . . . . . . . . . . . 23 Electric Utility Fund. . . . . . . . . . . 36 Equipment Maintenance. . . . . . . . . . . 32 Finance Department . . . . . . . . . . . . 26 Fire Department . . . . . . . . . . . . . . 28 General Charges. . . . . . . . . . . . 24 Grant Administration . . . . . . . . . . . 25 Hutchins Street Square . . . . . . . . . . 41 Insurance. . . . . . . . . . . . . . . . . 24 Library Fund . . . . . . . . . . . . . . . 35 Personnel. . . . . . . . . . . . . . . . . 25 Police Department . . . . . . . . . . . . . 27 CITY OF LODI TABLE OF CONTENTS Page OPERATING BUDGET DETAIL (continued) Public Works Department . . . . . . . . . . . 27 Recreation & Parks Department . . . . . . . . 32 Refuse Collection . . . . . . . . . . . . . . . 23 Sewer Utility Fund . . . . . . . . . . . . . 39 Special Payments - Administration. . . . . . . 24 Water Utility Fund . . . . . . . . . . . . . 40 OTHER BUDGETS Recommended Equipment Purchases. . . . . . . . 43 Recommended Personnel. . . . . . . . . . 47 Self -Insurance Funds: Dental Insurance. . . . . . . . 61 Long -Term Disability. . . . . 61 Public Liability. . . . . . . . 61 Workers' Compensation 61 Summary of Electric Utility Budgets. . . . . . 55 Summary of Utility Outlay Budget . . . . . . 56 Electric Utility Outlay Budget Detail. . . . 53 rrry nc I Ana BUDGET MESSAGE 1987-88 Introduction . . . . . . . . . . . . . . . . . . . M-1 to M-2 OPERATING REVENUES .-Property. Tax . . . . . . . . . . . . . . . . . . . . M-4 B. Sales Tax. .. ..: . . . . . . . . . . . . . . . . M-5 C. Other Taxes . . . . . . . . . . . . . . . . . . . . . . M-5 D. Licenses,. Fines and Use of Property. . . . . . . . . . M-6 E. Interest . . . . . . . . . . . . . . . . . . . . . M-6 F. Revenue From Other Agencies . . . . . . . . . . . . . . M-6 G. Service Charges . . . . . . . . . . . . . . . . . . . . M-7 I. Revenues From Utility Operations . . . . . . . . . . . M-8 J. Interfund Tranfers . . . . . . . . . . . . . . . . . . M-9 K. Transfers From Reserves. . . . . . . . . . . . . M-9 Contributions From Other Funds . . . . . . M-9 Comparison of Revenues 1986-87 and 1987-88 . . . . . M-10 OPERATING EXPENSES Comparison of Expenses 1986-87 and 1987-88 . . . . . . . . M-11 100 Series'- Personnel Services. M-12 200 Series - Utility, Communications & Transportation. M-23 300 Series - Supplies and Materials. . . . . . . . . . . . M-23 400 Series - Depreciation. . . . . . . . . . . M-23 500 Series - Equipment, Land & Structures. . . . . . . . . M-23 600 Series - Special Payments. . . . . . . . . . .M-24 BUDGET FUNDS Electric Utility Outlay Budget . . . . . . . . . . M-25 General Budget . . . . . . . . . . . . . . . . . . . M-29 General Fund . . . . . . . . . . . . . . . . . . . . M-29 Electric Fund. . . . . . . . . . . . . . . . . . . . . . M-32 SewerFund . . . . . . . . . . . . . . . . . . . . . . . . M-33 Water Fund . . . . . . . . . . . . . . . . . . . . . . . M-34 Library Fund . . . . . . . . . . . . . . . . . . . . . . . M-35 Community Center. . . . . . . . . . . . . . . . . . . . . . M-36 BUDGET SUMMARY . . . . . . . . . . . . . . . . . . . . . . . . M-37 CITY OF LODI CITY OF LODI LODI, CALIFORNIA 1987-88 BUDGET MESSAGE June 1, 1987 To the Honorable Mayor and Members of the City Council Councilmembers: Presented herewith for your information and review is the Operating Budget for fiscal year 1987-88. This is a balanced budget totaling $38,246,365, plus transfers of $3,483,330 to other funds and reserves. This is $2,318,450 over the 1986-87 budget of $35,927,915, an increase of 6.5%. Backing out the annual bulk power purchase, we find the actual increase in the Operating Budget to be $1,800,450 (9.4%). However, it is important to note that this budget contains negotiated compensation adjustments for 19.87-88 for all City employees except -the Fire Department and the Electric Utility Department. Contributing to this increase in the. budget is the recommended addition of 13 new positions over those provided for in last year's budget. In addition, several positions are being funded to a greater extent by the City this year than in 1986-87. This is the result of scheduled reductions in grant assistance for some positions, and the full -year funding of positions added last year which were funded in 1986-87 for less than 12 months because of the standard recruitment process. This budget will allow the City to continue to provide high levels of municipal services and address certain staff deficiencies. The largest group of the recommended new positions is in the Police Department where six additional employees will contribute to that department's response to increased service demands. The budget also provides for the replacement of old equipment as well as for the. purchase of new equipment designed to increase employee efficiency. -M1- CITY OF LODI There remain some unanswered questions at this time in the area of data processing. The Management Information Systems Committee, in recent meetings, has been analyzing a number of departmental requests for both hardware and software. Within the next few months these questions will be resolved and recommendations in this area will then be presented to the City Council. We anticipate these additional expenditures will be comfortably within the City's funding capabilities. This budget message contains comparisons between the budget adopted last year and the budget presented this year. -M2- / ITV ^ff I AMI FINANCING RESOURCES A municipal budget is funded utilizing a number of resources which can be classified into three major categories: OPERATING REVENUES, such as taxes, charges, fees, sales of utilities and subventions from other agencies; TRANSFERS; and RESERVES. This budget is entirely funded from anticipated operating revenues and transfers with no need for the utilization of reserves. As a matter of fact, provisions are made to transfer funds into reserves to ultimately provide for future needs. OPERATING REVENUES The total estimated operating revenues to fund this budget will be $41,629,695, an increase of $3,864,680 from last year's estimate of $37,788,460, a gain of 10.2%. There are a number of reasons for this revenue increase; some anticipated, others pleasant surprises. We expected a significant increase in sewer collection fees as we raised fees last October and project another increase this October. These funds are being placed in a capital account to pay for expansion of the White Slough Water Pollution Control Facility. Increases in property tax and sales tax revenues were much greater than anticipated. As our population grows, we can expect proportionate increases in sales of water and electricity. Accordingly, a 5.5%-6.0% increase in these revenues is projected. Also projected are significant increases in property tax' sales tax, interest income, motor vehicle in -lieu taxes, and..refuse collection income. 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. -M3- I CITY OF NODI A. PROPERTY TAX The City of Lodi receives approximately 21% of each statutory ' property tax dollar collected plus the necessary increment to service bonded debt. The debt is being retired in accordance with a bond redemption ' schedule. Annual estimates for revenue are generally obtained from the Assessor's Office which provides us an anticipated percentage increase. However, that office has no way of anticipating the sales and subsequent reassessment of property or property coming onto the tax rolls during the year. The increased revenue from property tax is one of the unexpected pleasant surprises. Revenues from this source in 1986-87 are being received at , a higher rate than anticipated. We expected to receive in 1986-87 $2,800,000 of General Property Tax levy and $449,070 for debt retirement. We have revised the General Property Tax estimates to $2,927,705. For 1987-88 we are projecting the General Property Tax to be $3,245,000 plus an additional $459,850 for debt retirement. This represents a 14.0% increase over the 1986-87 estimate. Property tax revenue for 1987-88 is estimated at: General Fund $2,665,440 Library Fund 579,560 Sewer Bond Debt 281,255 Other Municipal Bonds 178,595 $3,704,850 This increase is due to increased sales of property in Lodi, a continuation of the in -fill of undeveloped property and the provision that property values are established upon sale of the property rather than in March of each year. We cannot expect continued high annual increases in property tax revenue, as the in -filling is nearing completion and no new residential property is available for development. The potential for growth from new development will be limited to industrial expansion, unless the constraints of Measure A are modified. -M4- L7 PITY AC 1 nno B. SALES TAX REVENUE For the past few years there have been modest changes in sales tax revenue, except in 1983-84. Sales Tax revenues for 1986-87 are estimated to be significantly greater than the budgeted estimate. The following is a five-year history: Budget Year 1981-82 Actual $2,573,368 - 1982-83 Actual $2,692,550 + 4.6% 1983-84 Actual $3,249,117 + 20.6% 1984-85 Actual $3,449,196 + 6.2% 1985-86 Budget estimate $3,560,000 - 1985-86 Actual $3,616,083 + 4.8% 1986-87 Budget estimate $3,560,000 - 1986-87 Revised estimate $4,040,000 + 12.6% 1987-88 Budget estimate $4,343,000 + 7.5% When we prepared the 1986-87 budget estimates we did not anticipate receiving the $3,560,000 estimated for 1985-86, so we projected no growth for the year. We now project that sales tax will be $4,040,000 in 1986-87, which is 12.6% above our estimate. We are projecting a 7.5% increase in actual revenue for 1987-88 or $4,343,000. This is the City's largest single source of unrestricted revenue, and is the most dynamic in responding to the economy. This figure continues to underline the importance of maintaining a healthy retail, service and industrial environment. 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 $335,110. Most of these taxes are not sensitive to the economy and remain rather stable. However, property transfer taxes will grow with increased real estate activity. 1 -M5- CITY OF LODI D. LICENSES, FINES AND USE OF PROPERTY These revenues are obtained from various permit and license fees property rental, court fines and penalties. The total revenue from this source is estimated at $762,135, an increase of $21,690 from last year's estimate. This adjustment is due to increased vehicle code and library fines. E. INTEREST Interest income is a significant revenue resource for the City. However, it is the most volatile. The 1987-88 estimate is $1,068,585. This represents a 4.1% increase in anticipated revenues over the 1986-87 projections of $1,023,350. 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. F. REVENUE FROM OTHER AGENCIES Revenue in this category for 1987-88 is estimated at $1,871,690, an increase of $136,730 over the previous year's estimate of $1,734,960. There are a number of changes in'funding as follows: Increased motor vehicle in lieu fees + $179,520 Traffic Safety Grant - $ 69,635 Increased State Support of Library + $ 3,400 POST - $ 15,000 Business Inventory Tax - $ 23,690 Cigarette Tax + $ 8,870 State Disaster Assistance + $ 35,150 San Joaquin County Recreation Allotment + $ 18,115 We will receive $35,150 as reimbursement for disaster assistance rendered during the flood crisis of February, 1986. -M6- r1ry nr i nn! / VI v• �v V \ Last year the County of San Joaquin notified us we would not be receiving an allotment for recreation purposes. After the budget was adopted, the County appropriated the funds and we expect the same allocation this year. We have not listed grants from the State Office of Criminal Justice as these are now shown as inter -fund transfers. The Traffic Safety Grant funding terminates in January, 1988. Business Inventory Tax Subvention is on a declining schedule starting with the 1984-85 fiscal year as established by the State Legislature. 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 1987-88 is $2,535,325, an increase of $201,935 over last year. The major reason for this is increased revenue from refuse collection fees of $174,410 as a result of growth in business. The increase shown in refuse collection fees are based on present rates and do not make provision for anticipated rate increases or the imposition of additional fees for dumping. We are projecting increases in swimming fees and miscellaneous recreation fees. H. OTHER REVENUES These are miscellaneous revenues from unanticipated sources, such as reimbursements of previously paid bills and insurance policies, and the sale of scrap or salvage material. This revenue source is estimated to be $117.,000 for 1987-88. -M7- rI TV nr 1 r%m I. REVENUES FROM UTILITY OPERATIONS The City operates three utilities: Electric, Water and Sewer. These funds are operated on a enterprise basis with revenues and expenditures listed separate from the General Fund. In presenting the total operating budget for the City, these operations are also included. . Electric Sales The estimated electric sales for 1987-88 total $22,610,000 which is $1,282,300 (6.0%) more than last year's estimate of $21,327,700. This does not represent an increase in rates but rather growth in sales. We do not at this time contemplate an increase in electric rates this fiscal year. . Water Sales and Fees The projected revenue from water sales and fees for 1987-88 is $1,525,870, 5.5% more than last year's figure of $1,445,680, an increase of $80,190. The City Council may wish to consider in the near future the feasibility of increasing water rates to offset the increased costs of providing water service and to provide funds for capital projects. . Sewer Fees The projected income from sewer service fees and sewer connection fees is $2,057,280, a $746,800 (58.4%) increase over last year's revenues. This was expected as we raised fees in October, 1986 and plan to increase fees in October, 1987 to fund anticipated wastewater plant expansion. F7 0 0 1�i n 1] n i7 11 i' E J J. INTERFUND TRANSFERS Monies from other funds are also used to finance the Operating Budget. This year, $415,060 of Gas Tax money, and $105,535 of Transportation Development Act funds will be used for street maintenance purposes. Housing and Urban Development funds totaling $75,365 will be used to fund administration of the Community Development Block Grant program, and to'fund the Building Inspector (Housing). In addition, funding of $102,890 is included which represents the State Funds utilized in funding the Career -Criminal Apprehension Program (C -CAP), $42,890, and Community Crime Resistance Program, $60,000. K. TRANSFERS FROM RESERVES budget. There is no need to make transfers from reserves to fund this CONTRIBUTIONS FROM OTHER FUND RESERVES In order to provide adequate funding for the Operating Budget, it is recommended that $100,000 be transferred from the Hotel/Motel Tax Fund. The amount transferred from the Hotel/Motel Tax Fund represents the 1987-88 estimated revenue from this source. The current financing resources available to meet the Operating Budget, together with comparative 1986-87 estimates, are as follows: (Complete detail on revenue sources is shown in Schedule H.) -M9- Operating Revenues :ITY OF LODI FINANCING RESOURCES 1986-87 1987-88 Difference % Change Property Tax $3,249,070 $3,704,850 + $455,780 + 14.0 Sales Tax 3,560,000 4,343,000 + 783,000 + 21.9 Other Tax 331,210 335,110 + 3,900 - 1.1 Licenses, Fines and Use of Property 740,445 762,135 + 21,690 Interest 1,023,350 1,068,585 + 45,235 Revenues from Other Agencies 1,734,960 1,871,690 + 136,730 Charges for Current Services 2,333,390 2,535,325 + 201,935 Other Revenues 75,805 117,000 + 41,195 Water Sales & Fees 1,445,680 1,525,870 + 80,170 Sewer Charges & Fees 19310,480 2,057,280 + 746,800 Interfund Transfers 656,450 698,850 + 429400 Electric Sales Subtotal $16,460.,760 $19,019,695 + $2,558,935 $21,327,700 $22,610,000 + $1,282,300 Subtotal $37,788,460 $41,629,695 + $3,864,68U Transfer from Reserves $ 62,085 $ -0- - 62,085 + 2.9 + 4.1 + 7.8 + 8.6 + 54.3 + 5.5 + 58.4 + 6.5 + 15.5 - 6.0 + 10.2 Transfers from Other Funds $ 75,000 $ 1009-000 + 25,000 TOTAL RESOURCES $379925,545 $41,729,695 + $ 3,804,150 + 10.0 - M 10 - ^STV AC i An OPERATING EXPENSES The total recommended Operating Budget for 1987-88 is $38,246,365, an increase of 6.5%. The estimated cost of electricity -is $518,000 more than last year. If bulk power purchases are discounted, then the operating expenses increased from $19,222,915 in 1986-87 to $21,023,365 in 1987-88, an increase of 9.4%. An analysis of this budget on a category -by -category basis will help to clarify the reasons for the increase. Series 1986-87 1987-88 Difference % Change 100 - Personnel Services $12,239,580 $13,523,010 + $1,283,430 + 10.5 200 - Utilities & Transportation 1,317,115 1,357,125 + 40,010 + 3.0 300 - Supplies & Services 2,151,520 2,319,095 + 167,578 + 7.8 400 - Depreciation 598,040 667,520 + 69,480 + 11.6 500 - Equipment & Structures 195,875 198,805 + 2,930 + 1.5 600 - Special Payments 2,720,785 2,957,810 + 237,025 + 8.7 Subtotal $19,222,915 $21,023,365 + + 9.4 $1,800,450 Bulk Power Purchase $16,705,000 $17,223,00.0 + $ 518,000 + 3.1 TOTAL $35,927,915 $38,246,365 + $2,318,450 + 6.5 The major causes for the increase in this budget are the addition of new positions, increased cost of goods and services, depreciation of new equipment, a special election, and the addition of a disposal fee at Harney Lane Sanitary Landfill. - M 11 - CITY* OF LODI 100 Series - Personnel Services This budget includes all salary adjustments negotiated for fiscal year 1987-88, except those in the Fire Department and the Electric Utility Department, as well as the associated fringe benefit costs for all City employees. Also budgeted here are the recommended 13 new positions. Of this number, seven are funded in total by the General Fund. The remainder are funded by the City's three utilities - electric, water and sewer - by'the General Fund, and the Gas Tax Fund. The costs of group medical coverage and retirement are also budgeted here. It is anticipated there will not be an increase in these costs this fiscal year. The total in this category in 1986-87 was $12,239,580. The figure for 1987-88 is $13,523,010. This represents an increase of $1,283,430 (10.5%). The new positions requested and the City Manager's recommendations are: PUBLIC WORKS DEPARTMENT Street Supervisor Water/Wastewater Supervisor Water/Wastewater Inspector Laborer Laborer Equipment Serviceworker Funding Recommended Gas Tax 50% Electric Utility 30% General Fund 20% Recommended Sewer Utility Recommended Sewer Utility 75% Water Utility 25% Recommended Gas Tax 80% General Fund 20% Not Recommended Not Recommended - - M 12 - ^ITV AC 1 Affil PARKS AND RECREATION DEPARTMENT Funding Gardener Recommended General Fund Park Patrolman (Part-time) Recommended General Fund POLICE DEPARTMENT Police Officer (3) Recommended General Fund Police Officer (6) Not Recommended - 64% Dispatcher/Matron Recommended General Fund Dispatcher/Jailer Recommended General Fund Community Services Officer Recommended General Fund Administrative Clerk III Not Recommended - 30% FIRE DEPARTMENT Battalion Chief (3) Not Recommended - Fire Inspector Not Recommended - FINANCE DEPARTMENT Data Processing Programmer I Recommended Elec./Water/Sewer Utility 64% General Fund 36% Account Clerk Recommended Electric Utility 30% Water Utility 30% Sewer Utility 30% General Fund 10% Account Clerk Not Recommended - Buyer Not Recommended - COMMUNITY CENTER Administrative Clerk II Recommended General Fund (Part-time) - M 13 - CITY OF LODI Funding for these positions is generally less than a full fiscal year since it will take some time following City Council approval to prepare new class specifications in some cases, to recruit, test and place the new employees. Those full-time positions approved will, of course, be funded for the full twelve months in the 1988-89 budget. In addition to the new positions listed herein, it is recommended that the position of Administrative Assistant in the City Manager's Office be reclassified to Administrative Assistant to the City Manager. This is the position held by Eric Whitaker. This employee has been with the City of Lodi in his present capacity for almost three years and is now performing professional assignments at a level that supports this reclassification. This action will equate this position with that of the existing Administrative Assistant to the City Manager in the Personnel Office. The resulting compensation adjustment is 72% effective July 1, 1987. The two part-time positions recommended for approval are both in the leisure services area. The part-time hours added to the Park Patrol function will provide patrol at Lodi Lake seven days a week during the period from approximately the end of September to the start of the new season the following summer. The primary purpose of this increased patrol is to reduce the amount of vandalism that occurs from time to time when there is no one on site to provide the necessary security. The second part-time position is to provide additional clerical support at Hutchins Street Square. The opening in July, 1987, of the reconstructed Fine Arts Building wi11 result in considerably increased activity at that facility. This position is recommended for funding at two hours per day. Coupled with the present part-time position in the Arts Commission (also two hours per day), this will provide half-time staffing at this new facility. - M 14 - LMM t 11 CITY OF L001 A brief supporting statement for each of the new full-time positions follows: PUBLIC WORKS DEPARTMENT Street Supervisor - This position is recommended to provide additional direction, supervision and coordination of Street Division personnel, and to assist the Street Superintendent in performing routine administrative responsibilities. At the present time, the Street Division has two Street Supervisor positions, each reporting to the Street Superintendent. These two Street Supervisors are responsible for scheduling and overseeing the work of seven crews. During the months of May through September, the Division is usually comprised of nine crews. This is accomplished by reducing the Street Maintenance crew from three positions to two and the hiring of summer help. The supervisors are also responsible for the coordination and scheduling of work with other divisions and departments on a daily basis. It is becoming increasingly difficult, with just two supervisors, to provide adequate supervision to seven to nine crews, each of which may be working in widely dispersed locations. Proper supervision is essential to achieve and maintain optimum productivity and quality work. Improved work methods and advances in equipment have enabled the City to do more work with less people per street mile. For example, in the last approximately 35 years, the number of street maintenance employees has increased 28% (18 to 23) while the number of street miles in the same period have increased 111% (72 to 152). Street miles are emphasized here since that is the primary function of the Street Division. However, it is important to view the overall responsibility of the division where more direction and supervision is required, namely: street maintenance, traffic, storm drain maintenance, sidewalk repair and replacement, and street tree maintenance. - M 15 - f`ITV AC 1 Af11 WATER/WASTEWATER SUPERVISOR This position is recommended to assist in the development, organization of the full-time supervision of an effective preventive maintenance program in the wastewater collection systems. The systems consist of 160 miles of domestic waste lines and 11 miles of industrial waste lines, six lift stations and 1,800+ manholes totaling an estimated value of $82,000,000. The City's recently -revised Sewer Master Plan points to the fact that the City has had no active preventive maintenance program for the last seven to eight years. This has been the result of shifting the activities of the existing two -person crew to meet the demanding needs of new subdivisions, commercial and industrial developments and emergency repairs. The existing staffing simply does not provide for the. planning and implementation of the recommended preventive maintenance program. With the approval of this position, a wastewater preventive maintenance program will be developed that will satisfactorily address the preservation the City's current and future collection systems. Effective and proper preventive maintenance will minimize and delay the need for expensive capital improvements and ensure satisfactory sanitary sewer service for the City's residents. The responsibilities assigned to this position will include the following: Implementation of the recommended sewer maintenance program. . Supervision of the existing two-man sewer maintenance crew and any sewer maintenance contractors. . Augmentation of the sewer maintenance crew whenever work requires a three-man crew (whish is approximately 75 percent of the time'). . Development and maintenance of a formal sewer maintenance record system. . Coordination of sewer maintenance support from other crews in the Water/Wastewater Division. . Communication with the public concerning sewer maintenance activities. . Development of accurate sewer mapping including a manhole numbering system. . Reporting of sewer improvement requirements to the City engineering staff. - M 16 - f' r 11 r. 7 i] n F -ill r 11 CITY OF LODI WATER/WASTEWATER INSPECTOR - This position is a repeat request. It was submitted for inclusion in the 1986-87 budget, but was not recommended for City Council approval. With ever-increasing pressure being brought to bear by both the State and Federal governments in the form of mandates and the need to improve existing programs, the addition of this position is critical. The person appointed to this position will be assigned responsibilities in both the water system and the wastewater system. The staff's analysis reveals that about 1,900 manhours are needed on an annual basis in various water/wastewater programs, many of which cannot be met at all or are not being adequately addressed (one man year equals 1,880 hours). A substantial amount of what work is -being done in these areas is being performed by White Slough Water Pollution Control Facility laboratory personnel. This time has had to be taken from the wastewater sampling and monitoring programs at the treatment plant. Approval of this position will free the laboratory personnel to perform the tasks for which they were hired. Since December, 1986, over 180 manhours have been consumed in the investigation of just three illegal industrial discharges to'the domestic and industrial sewer systems. Additionally, in that same time period, the Water/Wastewater Division has conducted follow-up work and sampling of six City water wells, as a result of reported or confirmed underground fuel spills. Illegal discharges and groundwater contamination problems are increasing every year. There were four such illegal discharges in one day in April of this year. The standards are being increased, and as a result of increased public awareness, the City is now receiving more and more requests for inspections. The person in this position will be conducting the investigations of these kinds of occurrences, thus freeing other personnel to perform their regularly assigned duties. Also, the person in this position will act as a liaison between the Public. Works Department and the City's commercial and industrial customers in all matters relating to water usage (cross connection control, for example), and wastewater and storm water discharges. - M 17 - CITY OF LODI LABORER - This position is recommended in the Street Division to provide for the continuation of the existing Street Preventive Maintenance t Program which has been developed over a period of years to defer costly reconstruction projects. A recent survey of other cities of comparable size to the City of Lodi revealed that the average number of street miles maintained per maintenance worker was 12.6. The City of Lodi is close to ' this figure. To continue the existing level of service on the City's 152 miles of streets,,and to keep pace with the City's sidewalk replacement program, this position should be authorized in this budget. PARKS AND RECREATION DEPARTMENT Gardener - This is one of the seven recommended new positions to be funded in total by the General Fund. In 1976, the Parks Division was staffed with 25 positions. In the wake of Proposition 13, this number was reduced to the point that the City of Lodi had just 20 positions authorized in this division until last year when two laborer positions were added. A portion of this reduction was offset by the utilization of part-time employees. During this period, maintenance program requirements have increased with the addition to the City's park system of approximately 135 acres of new open space areas. These are: Acres Hutchins Street Square 12 Salas Park 21 Beckman Park 16 Wilderness Area 60 English Oaks Common 3 Century Park 2 . Westgate Park (Park West) 10 . Lawrence School softball fields 10 - M 18 - CITY OF LODI This recommended position would be the equivalent of a Park Maintenance Worker III, reporting to the Park Supervisor. The responsibilities to be assigned would include: Upgrading the parks irrigation systems to decrease the amount of hand watering now required. . Programming and repair of automated sprinkler components.' Directing the application of pesticides and herbicides, and filing the required reports on same. There is a need for a qualified, licensed employee to perform this State -required reporting. Implementing a comprehensive pruning program at all City parks, open space and playing field facilities. POLICE DEPARTMENT Police Officer (3) - It is recommended that three new Police Officer positions be authorized with the adoption of this budget. The Chief of Police, at a City Council work study session last' fall, reviewed the department's manpower needs, indicating at that time that additional manpower would be requested in this budget. The request was for nine new Police Officer positions; the recommendation is as noted above. These three new positions are necessary to keep pace with the City's growth (5.72% in 1986) and the resulting increase in calls for service. The recommended new Community Service Officer, discussed herein later, will bring additional relief by freeing Police Officers from some of the more routine, time-consuming tasks which do not require the attention of sworn personnel. While it is true that the City did add three Police Officer positions in the 1985-86 budget funded by an Office of Traffic Safety grant (now funded predominately by the General Fund), there have been no - M 19 - I- ni I A_1 additional Police Officer (patrol) positions otherwise authorized since the adoption of the 1983-84 budget. As the City Council is aware, the three positions added via the grant, work traffic exclusively and as a result do not augment the patrol function. The addition of these three positions still leaves the City somewhat short of the generally accepted standard of 1.5 sworn personnel per thousand population, but does result in a ratio of 1.3 which is certainly approaching the recommended staffing level. Dispatcher/Matron - These two positions were requested by the Police Dispatcher/Jailer Department in last year's budget submittal, but were not recommended for approval. The work load and the ever-increasing complexity of the duties of these positions now justify these additions to the department's work force. The current staffing in this area is six Dispatcher/Matron positions and four Dispatcher/Jailer positions. The sole difference in the class specifications for these positions is that the Dispatcher/Matron processes female prisoners; the Dispatcher/Jailer processes male prisoners. The computerized equipment now utilized in dispatching police units is quite sophisticated. No longer can we rely on Police Officers and others in the department to relieve in the dispatch center. The dispatching now can be handled only by dispatchers because of the highly specialized training they receive. The increasing calls for service has placed a particularly heavy load on this unit. Not only do these personnel dispatch police units, they book and process persons arrested and monitor the detention facility. It is the latter two assignments that take them away from the dispatch center, frequently leaving just one dispatcher to staff this critical function. In the future there may be a need to separate the duties of dispatcher and jailer, requiring a comprehensive review of the organization at that time. =uf'• I J 0 L w J I- nr . --I Community Services Officer - This is one of the seven recommended new positions to be funded by the General Fund. The City Council, in last year's budget authorized the City's first Community Services Officer position and the results have been highly satisfactory. The use of civilian or non -sworn personnel to perform some of the more routine assignments in the Police Department is not a new concept, but it was new to the City of Lodi last year. Councilmembers will recall hearing at various meetings and seminars of the cost benefits of utilizing such personnel in place of sworn law enforcement officers. A Community Services Officer (CSO) can be utilized for numerous assignments in which the powers of arrest are not necessary. Such assignments might include marking and arranging for the removal of abandoned vehicles; issuing citations for handicap parking violations and illegally displayed vehicles for sale; taking reports of routine incidents; directing traffic in unusual circumstances; picking up abandoned bicycles; answering inquiries at the public counter; assisting with neighborhood watch programs; fingerprinting; and many other related duties. At the time of the addition of the City's first CSO position last year, the City also added two more such positions funded by a Crime Prevention grant. The cost of a CSO versus that of a Police Officer is considerably less both in salary and fringe benefits. We should look to expanding the City's civilian police work force in place of sworn personnel wherever possible. FINANCE DEPARTMENT Data Processing Programmer I - Approval of this recommendation will add a second Programmer to the Finance Department's Data Processing Division. The backlog of programming work in this unit continues to increase. The department has identified 660 days (almost three work years) of programming and documentation work to be accomplished to eliminate the backlog in addition to the day-to-day work which is not being kept current. This backlog is in the areas of utility billing, payroll, general accounting, - M 21 - r TV AC 1 nnI accounts payable and miscellaneous categories such as business licenses, equipment costs, personnel and subdivision paybacks. Given the current staffing in this division we are simply unable to keep -pace. Projects are being completed, but since last June, new projects have outpaced finished projects by approximately 10%. If this rate continues, this division's backlog by this time next year will be over 700 work days. Account Clerk - Approval of this position is recommended to provide adequate staffing in the Billing Section of the Finance Department.. This would be the first addition to the clerical staffing in this department since the adoption of the 1979-80 budget. During this period of time, the number of customers served by these employees has increased 34%. Efficient personnel utilization as well as significant advances in computer hardware and software have enabled this department to keep pace with the City's growth to this point, but this new position is now justified. The department has been filling part of the gap with part-time employees, but the heavy work load has resulted in the resignation of three part-time trainees within two weeks of being hired. Actually, approval of this position will result in 'a reduction of part-time costs annually from approximately $19,000 to about $4,000. Thus a substantial portion of the first-year cost of this position is covered as a result of this cut in part-time hours. This position will also result in increased customer service. It is the employees in this section that process requests for new or changed utility services and who handle inquiries regarding billings. These public contacts can sometimes be difficult and it is important that these kinds of customer questions be resolved quickly and as pleasantly as possible. Approximately 90% of the cost of this position will be borne by the electric, water and sewer utilities, with the balance of the cost being charged to the General Fund. -M22- 0 r' 0 f] C 17 r�ry nr nn� 200 Series - Utility, Communication and Transportation The cost of the City's annual bulk power purchase is not included as a 200 Series cost per se. Eliminating the bulk power purchase, the budget expenditures in the 200 Series show an increase of $46,010. The reason for the increase is due to increased costs of meetings, seminars, and the like, two elections requiring additional postage, increased billings in the Finance Department, and an increase in the price of natural gas. 300 Series - Supplies, Materials and Services The cost for goods and services for general operations is budgeted at $2,319,095. This is $167,575 more than last year's budget of $2,151,520, an increase of 7.8%. The increase is due to two elections, moving the audit from a 600 Series Miscellaneous object node to the 300 Series Professional Services object code, showing the full budget for the two criminal justice programs, increased uniform allowances, funds for special counsel, special department purchases and a rise in the cost of goods and services. These increases are offset to some degree by reducing the appropriated amount of police training by $30,000. 400 Series - Depreciation Depreciation expenses this year increased $69,480 from $598,040 to $667,520. Last year the City Council approved $591,375 in new equipment which is now on a depreciation schedule. Of the $667,520 budgeted here, $314,445 will be transferred to the wastewater capital fund for Debt Retirement and replacement of major equipment items at the wastewater treatment facility; $353,075 will be placed in the Equipment Replacement Fund or appropriate capital funds. 500 Series - Equipment, Land and Structures The 500 Series contains equipment and construction contracts needed for ongoing operations. Starting this fiscal year, equipment purchases of $1,000 or less will appear in the Operating Budget rather than the Equipment Replacement Fund. In previous years this figure was $500 or less. The total cost .for this series is $198,805, an increase of $2,930 from last year's budget. The largest increase in this series of accounts is the money used for street maintenance purposes. -M23- CITY OF LODI It should be mentioned, as it was last year, that no Police patrol vehicles are included in this budget. We purchased five vehicles earlier at a favorable price and will place them in service as need demands. It is extremely important to stress the extended vehicle life we are experiencing from the present fleet as a result of our preventive maintenance program. 600 Series - Special Payments The 600 Series covers debt service, refuse collection payments, taxes, and other special payments. The costs of this series is $2,957,810, an increase of $237,025 from last year's budget. Major items in this series are: Refuse Disposal Debt Service: General Obligation Sewer (interest only),, Special Payments: Woodbridge Irrigation District Chamber of Commerce Annual Audit Employee Dinner Employee Service Pins San Joaquin County Safety Council Northern California Power Agency Contingent Fund Developers Refunds $2,166,190 403,710 56,060 5,980 12,000 22,000 4,000 2,000 1,000 25,000 250,000 160,000 Refuse collection costs are projected to increase by $280,570 in 1987-88 due to an increase in customers and the payment to the County of San Joaquin of $2.00 per cubic yard for refuse delivered to the Harney Lane Sanitary Landfill. This increase does not reflect any change in rate, change in service policies or inclusion of industrial waste in the franchise. -M24- CITY OF LORI ELECTRIC UTILITY OUTLAY BUDGET The Electric Utility Outlay budget totals $1,663,155. There are five major components contributing to this total. They are: MCLANE SUBSTATION - Triggered by the General Mills expansion project, the cost of the upgrade of this substation totals $643,800. It involves the installation of a second bank which doubles the capacity of this facility. This expansion project was scheduled for 1990-91 but has been moved up to this fiscal year to provide sufficient capacity for General Mills. ($643,795) SYSTEM IMPROVEMENTS - This will provide for planned system improvements throughout the City. These improvements are designed to increase the electrical capacity, safety and reliability of the City's distribution system. Also included is funding to relocate facilities due to street widening and other City projects. ($301,840) LODI AVENUE UNDERGROUNDING - The costs associated with the undergrounding of existing overhead electric distribution facilities on Lodi Avenue between the Southern Pacific tracks and Ham Lane are budgeted here. This is a two-phase project. Phase One (Hutchins Street to Ham Lane) is scheduled for construction this fiscal year. ($178,605) -M25- CITY OF LODI LINE TRUCK REPLACEMENT - This will replace a 1978 line truck, purchased as an equipment -handling unit. The old unit does not have sufficient lift capacity to handle the new, considerably larger transformers and other equipment now being used. To maximize efficiency, this replacement unit will be a digger-derrick/bucket combination. Replacement of this unit is timely now because major maintenance expenses, based on past experience, are probably in the very near future. ($125,000) 20 -TON CRANE - This budget provides for the purchase of a 20 -ton, rubber tire, mounted crane. The Electric Utility Department's operation has reached sufficient size that such a piece of equipment is necessary. Industrial customer requirements are such that we are now manipulating transformers that weigh up to eight tons. Recent installations of this size are in place at Dart Container Corporation, Pacific Coast Producers, Cottage Bakery's Pastry Express Central Plant, Wallace Computers and California Cushion Company. A transformer of like size will be installed at the Minton Company facility currently under construction. The transformers now in place were installed utilizing rented cranes, available from private crane companies in the area on a scheduled basis. Rental cranes will not work for emergencies, particularly off -hours, should there be a transformer malfunction at one of these key industrial locations or elsewhere in the industrial and commercial communities. Until recently, the department has not been faced with the requirement of working with transformers of such huge weight and dimensions. The reason the 20 -ton capacity is required is that as the need to reach out for the equipment to be lifted is increased, the rated capacity of the crane decreases. For example, to lift 20,000 pounds (the weight of a large transformer) from a point 18 feet from the pivot point of the boom, requires a crane with twice that lifting capacity. The staff has thoroughly s lawt-= L' u r rITV nG t nni researched the alternatives to this acquisition. One, the purchase of used equipment remains a possibility. Other alternatives which have been considered, evaluated and rejected as unacceptable include renting such a crane when an emergency occurs. Crane companies with whom we have been in contact can respond in emergencies if everything falls into place. However, no firm response times can be given. It depends in large part on the availability of equipment and operators. The general consensus is that a six to eight hour delay could be expected at a minimum. With large numbers of employees idled and product either not being processed and/or being damaged by such an extended power outage, this alternate will not suffice. The possibility of borrowing such a piece of equipment from a sister electric utility city, the Sacramento Municipal Utility District, or Pacific Gas & Electric Company is remote, if not out of the question. The prospect of incurring an emergency situation in one's own system while the expensive equipment purchased to quickly respond to such an emergency is "on loan," is a risk that would be impossible to justify. Additionally, this type of equipment is not designed for highway travel. ($175,000) Among the uses for this piece of equipment are:. Installing transformers at the customer's facility. This is currently being done with rental units at $100 per hour with a $400 minimum charge. The Electric Utility Department has already rented such units on four separate occasions this spring. Loading and unloading transformers in the warehouse yard. These units are shipped on flat bed trucks and the purchaser (in this case the City of Lodi) is expected to be able to unload when the truck arrives. At the present time a fork lift and a line truck are used as a "team" to lift the units. The flat bed truck is then eased out and the transformers very carefully lowered to the ground. This is not a recommended material handling process. -M27- CITY OF LODI . Handling and setting large precast, concrete vaults. The department's existing equipment is at, or exceeding rated capacity, when performing these tasks. . Assisting other departments in maintenance and repair operations. In the past, cranes have been rented to lift standby generators. At the White Slough Water Pollution Control Facility, the lifting of large motors has proven to be difficult mainly because of the reach -capacity problem. 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 the funding for them is included in other budgets, or funded from special funds. These budgets are Public Liability and Property Damage (PL & PD) Fund, Workers' Compensation Fund, Equipment Budget, Dental Insurance, and Long -Term Disability Funds. The insurance' budgets are based on our best estimates of expenses, taking into consideration past experience. The detail of the expenditures for the insurance budgets is shown on page 61; the detail for the Utility Outlay Budget is shown on page 53; and the Equipment Budget on pages 43, 44, 45 and 46. -M28- ^ITV f1C i AM OPERATING FUNDS The Operating Budget is divided into a number of separate funds: General, Electric, Water, Sewer, Library, Parking, and 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 G. In order to make a meaningful comparison of operating costs between fiscal 1987-88 and the previous year, the following table lists the cost of bulk power separately. Fund 1986-87 1987-88 Difference % Change General $14,674,860 Electric 1,805,445 Sewer 1,340,230 Water 691,735 Library 669,980 Hutchins Street Square 40,665 $16,163,875 + $1,489,015 + 10.1 1,834,210 + 28,765 + 1.6 1,444,515 + 104,285 + 7.8 734,915 + 43,180 + 6.2 700,880 + 30,900 + 4.6 144,970 + 104,305 + 256.5 Subtotal $19,222,915 $21,023,365 + U ,8UU,45U Bulk Power $16,705,000 $17,223,000 + $ 518,000 TOTAL $35,927,915 $38,246,365 + $2,318,450 -M29- + 9.4 + 3.1 + 6.5 CITY OF LODI General Fund A summary of the General Fund revenues and expenditures is shown _ in Schedule B. General Fund revenues this year are anticipated to be $12,874,390, , an increase of $1,550,080 from last years estimate of $11,324,310. In addition, $514,595 of Gas Tax and Transportation Development Act (TDA) funds are available for street maintenance purposes; $102,890 from the Office of Criminal Justice to fund the C -CAP and CCR programs; $75,365 from the Housing ' and Urban Development grant to fund a Planner and a Building Inspector (Housing). ' General Fund revenues are not sufficient to fund the Operating Budget. This is not new, but a reiteration which underscores the importance of the Utility funds. Therefore, it is recommended that we transfer $1,799,810 from the Electric Fund; $400,000 from the Water Fund; and $100,000 from the , Hotel/Motel Fund. With contributions from these sources, we will be able to fund this year's budget, make necessary transfers to other funds, and set aside ' funds in the Operating Reserve. EXPENDITURE SUMMARY ' General Fund ' Series 1986-87 1987-88 Difference % Change 100 $ 9,917,310 $10,925,750 +$1,008,440 + 10.2 200 635,470 651,585 + 16,115 + 2.5 300 1,387,555 1,490,550 + 102,995 + 7.4 400 234,145 316,475 + 82,330 + 35.2 , 500 125,150 134,370 + 9,220 + 7.4 600 2,375,230 2,645,145 + 269,915 + 11.4 Total $14,674,860 $16,163,875 +$1,489,015 + 10.1 -M30- :ITY OF LODI Included in the personnel portion of this budget are negotiated salary increases for 1987-88, and the recommended addition of positions. The previously mentioned increased postage,. meeting expenses and utility costs account for the increase in the 200 Series. The increase in the 300 Series is due in large measure to the two elections, specialized department material, including .the full cost of the Criminal Justice programs and the general increase in cost of goods and services. Refuse collection costs are projected to be $280,570 more than was budgeted last year. This includes the amount to pay for the franchise refuse collection and the $2.00 per yard dump fee charge. We have transferred from the General Fund to the Community Center Fund the budget for the Community Center Director, the Senior Citizens' Commission, and the Arts Commission and its various budgets. - M 31 - CITY OF LODI Electric Fund Electric Fund revenues are generated by charges for electric energy and connection fees. A summary of the Electric Fund is shown in Schedule C. Series 1986-87 1987-88 Difference % Change 100 $1,095,220 $1,161,970 +$ 66,750 + 6.1 200 31,340 43,165 + 11,825 + 37.7 300 319,425 302,655 - 16,770 - 5.3 400 17,810 17,865 + 55 + .3 500 70,725 63,455 - 7,270 - 10.3 600 270,925 245,100 - 25,825 - 9.5 Subtotal $1,805,445 $1,834,210 +$ 28,765 + 7.3 Purchased Power $16,705,000 $17,223,000 +$ 518,000 + 1.6 TOTAL $18,510.445 $19,057,210 +$ 546,765 + 3.3 Salary increases are not included in this fund. Increases in the 200 Series is due to increased meeting costs, electricity and telephone. We are budgeting $25,000 for NCPA assessments and legal activities this year. This $55,000 reduction from the 1986-87 figure of $80,000 is offset by increases in refunds to developers and increased tax on sales. -M32- r11ry nr i nm / VI v..v✓1 \ 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 street lights, water production, operation of the sanitary sewer plant, and storm drain pumping. It allows the City of Lodi to provide a higher level of service with a smaller increment of property taxes as a part of total revenue than other cities. The Electric Fund will transfer to the General Fund $920,940 for services performed by General Fund activities. A $1,799,810 transfer to the General Fund and $31,475 to the PL & PD Fund are also budgeted. It is recommended $400,000 be transferred to the Rate Stabilization Reserve and $1,000,000 to the Electric Capital Fund. Sewer Fund A summary of the Sewer Fund is shown in Schedule D. Series 1986-87 1987-88 Difference % Change 100 $ 486,135 $ 570,195 +$ 84,060 + 17.3 200 265,185 265,370 + 185 + .1 300 182,215 218,715 + 36,500 + 20.0 400 24,880 15,345 - 9,535 - 38.3 500 -0- 530 + 530 - 600 2,535 3,855 + 1,320 + 52.1 Plant Depreciation $ 313,785 $ 314,445 +$ 660 + .2 Bond Interest $ 65,495 $ 56,060 -$ 10,095 - 15.4 TOTAL $1,340,230 $1,444,515 +$104,285 + 7.8 -M 33 - CITY OF 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 1986-87 is estimated at $2,509,650, which is $766,720 over last years total of $1,742,930. This increase is due in large measure to the fee increase imposed in October; 1986 and another increase to be effective October 1, 1987. The Sewer Fund will be charged $109,535 to fund services provided by the General Fund, as well as transfers of $200,000 to the Sewer Capital Outlay Fund, $15,195 to the PL&PD Fund; and $740,405 to the Wastewater Capital Fund to be used for expansion of the White Slough Water Pollution Control Facility. Water Fund A summary of the Water Fund is shown in Schedule E. Series 1986-87 1987-88 Difference % Change 100 $261,915 $296,685 +$34,770 + 13.3 200 321,500 323,400 + 1,900 + .6 300 100,800 112,375 + 11,575 + 11.5 400 7,420 2,305 - 5,115 - 68.9 600 100 150 50 + 50.0 TOTAL • $691,735 $734,915 +$43,180 + 6.2 -M34- PI TV nc i AM / VI I I VVVu1 \ Water Fund revenues are generated by sales, connection fees, interest and miscellaneous revenues. The revenues for 1987-88 are estimated to be $1,606,200, an increase of $67,390 from the 1986-87 estimate of $1,538,510. The major reasons for this increase is an increase in sales. There is essentially no change.in the overall program of the Water Fund. The partial funding of one position, negotiated salary increases and increased well maintenance costs account for the majority of the increase. The Water Fund will be charged $121,490 to fund services provided by the General Fund. Transfers from the Water Fund will be made to the General Fund, $400,000; Water Capital Fund, $200,000; Water Operating Reserve, $142,200; PL & PD Fund, $7,595. Library Fund A summary of the Library Fund is shown in Schedule F. Series 1986-87 1987-88 Difference % Change 100 $453,120 $471,020 +$ 17,900 + 4.0 200 52,960 50,000 2,960 - 5.6 300 157,400 172,360 + 14,960 + 9.5 600 6,500 7,500 + 1,000 + 15.4 TOTAL $669,980 $700,880 +$ 30,900 + 4.6 The major source of revenue for the Library operation comes from an allocation of property taxes and revenues from other agencies. This year the property tax allocation will be $579,560; California Library Services Act, $33,000; the Public Library Foundation, $36,400; and Business Inventory Tax, $8,465. The Library should end the year in a position to transfer .$21,290 to the Library Operating Reserve. The Library budget provides for the existing level of service. -M 35 - :ITY OF LODI COMMUNITY CENTER The large increase in expenditures is the result of reorganizing various functions under this unit. Previously, the only costs which were budgeted under Hutchins Street Square were for maintenance. The Community Center Director's operations were in the City Manager's budget. The Senior Citizens' Commission and the Arts Commission were in the Parks and Recreation Department's budget. Hutchins Street Square is becoming the hub for more activities and the completion of the Music Building dictates that the operation be placed in a separate budget unit. As programs at this facility increase, we can anticipate additional growth in this budget. The only operating revenue generated here are the rents for the cafeteria. It is expected these will total $9,000 leaving a shortfall of $135,970 to be funded by a transfer from the General Fund. -M36- A summary of this budget is shown in Schedule G. Series 1986-87 1987-88 Difference % Change 100 $25,880 $97,390 + $71,510 + 276.3 200 10,660 23,605 + 12,945 + 121.4 300 4,125 22,440 + 18,315 + 444.0 400 -0- 1,085 + 1,085 - 500 -0- 450 + 450 - TOTAL $40,665 $144,970 +$104,305 + 256.5 The large increase in expenditures is the result of reorganizing various functions under this unit. Previously, the only costs which were budgeted under Hutchins Street Square were for maintenance. The Community Center Director's operations were in the City Manager's budget. The Senior Citizens' Commission and the Arts Commission were in the Parks and Recreation Department's budget. Hutchins Street Square is becoming the hub for more activities and the completion of the Music Building dictates that the operation be placed in a separate budget unit. As programs at this facility increase, we can anticipate additional growth in this budget. The only operating revenue generated here are the rents for the cafeteria. It is expected these will total $9,000 leaving a shortfall of $135,970 to be funded by a transfer from the General Fund. -M36- J CITY OF LODI BUDGET SUMMARY In summary, this budget recognizes deficiencies in the City's operations and attempts to address those issues. This financial plan for 1987-88 has as its main thrust the maintenance of resources to insure that the citizens of this City will continue to receive the high levels of service they deserve. This manifests itself in the addition of a number of new positions in the organization discussed earlier in this message which should meet many of the City's needs in the immediate future. The 1987-88 Operating Budget is balanced and provides for the maintenance of existing levels of service. The department heads presented budgets which were reasonable in light of the growth being experienced by the City of Lodi. Their assistance and the assistance of their respective staffs is acknowledged with appreciation. I am particularly indebted to Finance Director Robert H. Holm and Assistant City Manager Jerry L. Glenn for their major contributions to this effort. We look forward to the opportunity of reviewing this budget with the City Council during the coming weeks. The staff stands ready to answer questions, provide additional input and generally assist in whatever manner necessary in the Council's deliberations on this budget. TAP/JLG:br Respectfully submitted, -M37- Thomas A. Peterson City Manager OPERATING BUDGETS SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES OPERATING REVENUES Property Taxes Other Taxes Licenses, Fines & Rent Interest Revenue from Other Agencies Charges for Current Services Other Revenues Water Sales & Fees Sewer Charges Electrical Sales Inter -Fund Transfers Total $ 3,704,850 4,678,110 762,135 1,068,585 1,871,690 2,535,325 117,000 1,525,870 2,057,280 22,610,000 698,850 —X41,629,695 CONTRIBUTIONS FROM OTHER FUNDS Hotel/Motel Fund $ 100,000 Total $ 100,000 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services Utilities & Transportation Materials & Supplies Depreciation Equipment, .Land & Structures Special Payments Sub -Total Operating Expenses Bulk Power Purchase Total $13,523,010 1,357,125 2,319,095 667,520 198,805 2,957,810 $21,023,365 $17,223,000 38,246,365 CONTRI$UTIONS TO OTHER FUNDS AN£ RESERVES Equipment Fund $ 143,755 Water Operating Reserve 142,200 Water Utility Capital Fund 200,000 General Fund Operating Reserve 310,000 Sewer Operating Reserve 200,000 Wastewater Capital Fund 740,405 Electric Rate Stabilization Reserve 400,000 Library Reserve 21,290 Workers' Compensation Insurance Reserve 40,080 Utility Outlay Reserve 1,000,000 PL & PD Insurance Fund 285,600 Total $ 3,483,330 TOTAL ESTIMATED REQUIREMENTS -1- SCHEDULE A $41,729,695 $41,729,695 e CITY OF LODI GENERAL FUND Schedule B SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES REVENUE Property Taxes $ 2,844,035 Other Taxes 4,678,110 364,270 Licenses and Permits Fines, Forfeits and Penalties 212,500 Revenue from Use of Money & Property 388,325 1,793,825 Revenue from Other Agencies Charges for Current Services 2,535,325 Other Revenue Total 58,000 $12,874,390 INTER -FUND TRANSFERS Criminal Justice - C -CAP $ 42,890 Criminal Justice - CCR 60,000 75,365 Housing and Urban Development Transportation Development Act 105,535 State Gas Tax Total 415,060 $ 698,850 CONTRIBUTIONS FROM OTHER FUNDS AND RESERVES $ 100,000 Hotel -Motel Fund 0 400,08000 Water Utility Fund Electric Utility Fund 1799, $ 2,299,810 Total TOTAL ESTIMATED FINANCING RESOURCES $15,873,050 ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services $10,925,750 Utilities & Transportation . 651,585 1,490,550 Materials & Supplies Depreciation of Equipment 316,475 Equipment, Land & Structures 134,370 245,145 6 Special Payments Sub -Total Operating Expenses , 16,163,875 INTER -FUND TRANSFERS General Fund Charges to Enterprise Fund $ 1,151,965 $15,011,910 Net Operating Expenses CONTRIBUTIONS TO OTHER FUNDS AND RESERVES General Fund Operating Reserve $ 310,000 135,970 Community Center Fund Public Liability Insurance Fund 231,335 .Worker's Compensation 40,080 Equipment Fund 143,755 Total $ 861,140 TOTAL ESTIMATED REQUIREMENTS $15,873,050 -2- [1 L F ELECTRIC UTILITY FUND SCHEDULE C SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES OPERATING REVENUES Sale of Electricity $22,610,000 Total T22,610,000 OTHER INCOME Sale of System - Joint Pole $ 10,000 Sale of Property - Salvage 2,000 Pole Rental (CATV) 12,000 Interest Income 538.,435 Electric Miscellaneous 35,000 Revenue NOC_ 2,000 Total 599,435 TOTAL ESTIMATED FINANCING RESOURCES $23,209,435 ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services $ 1,161,970 Utilities & Transportation 43,165 Materials & Supplies. 302,655 Depreciation of Equipment 17,865 Equipment, Land & Structures 63,455 Special Payments 245,100 Sub -Total Operating Expenses 1,834,210 Bulk Power Purchase $17,223,000 Total $19,057,210 INTER -FUND TRANSFERS General Fund Charges $ 920,940 Total $ 920,940 CONTRIBUTIONS TO OTHER FUNDS AND RESERVES General Fund $ 1,799,810 Rate Stabilization Reserve 400,000 Utility Outlay Reserve 1,000,000 PL & PD Insurance Fund 31,475 Total $ 3,231,285 TOTAL ESTIMATED REQUIREMENTS $23,209,435 - 3 - r- nc I nn. OPERATING BUDGETS SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES OPERATING REVENUES Property Taxes Other Taxes Licenses, Fines & Rent Interest Revenue from Other Agencies Charges for Current Services Other Revenues Water Sales & Fees Sewer Charges Electrical Sales Inter -Fund Transfers Total $ 3,704,850 4,678,110 762,135 1,068,585 1,871,690 2,535,325 117,000 1,525,870 2,057,280 22,610,000 698,850 $41,629,695 CONTRIBUTIONS FROM OTHER FUNDS Hotel/Motel Fund $ 100,000 Total $ 100,000 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services Utilities & Transportation Materials & Supplies Depreciation Equipment, Land & Structures Special Payments Sub -Total Operating Expenses Bulk Power Purchase Total $13,523,010 1,357,125 2,319,095 667,520 198,805 2,957,810 —$21,023,365 $17,223,000 $38,246,365 CONTRIBUTIONS TO OTHER FUNDS`AND RESERVES Equipment Fund $ 143,755 Water Operating Reserve 142,200 Water Utility Capital Fund 200,000 General Fund Operating Reserve 310,000 Sewer Operating Reserve 200,000 Wastewater Capital Fund 740,405 Electric Rate Stabilization Reserve 400,000 Library Reserve 21,290 Workers' Compensation Insurance Reserve 40,080 Utility Outlay Reserve 1,000,000 PL & PD Insurance Fund 285,600 Total $ 3,483,330 TOTAL ESTIMATED REQUIREMENTS - 1 - SCHEDULE A $41,729,695 $41,729,695 e I 1.1- ^r I Ant GENERAL FUND SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES y1411101M Property Taxes $ 2,844,035 Other Taxes 4,678,110 Licenses and Permits 364,270 Fines, Forfeits and Penalties 212,500 Revenue from Use of Money & Property 388,325 Revenue from Other Agencies 1,793,825 Charges for Current Services 2,535,325 Other Revenue 58,000 Total $12,874,390 INTER -FUND TRANSFERS Criminal Justice - C -CAP $ 42,890 Criminal Justice - CCR 60,000 Housing and Urban Development 75,365 Transportation Development Act 105,535 State Gas Tax 415,060 Total $ 698,850 CONTRIBUTIONS FROM OTHER FUNDS AND RESERVES Hotel -Motel Fund $ 100,000 Water Utility Fund 400,000 Electric Utility Fund 1,799,810 Total $ 2,299,810 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Schedule B $15,873,050 Personnel Services $10,925,750 Utilities & Transportation 651,585 Materials & Supplies 1,490,550_ Depreciation of Equipment 316,475 Equipment, Land & Structures 134,370 Special Payments 2,645,145: .Sub -Total Operating Expenses � $16.,163,875 INTER -FUND TRANSFERS General Fund Charges to Enterprise Fund $ 1,151,965 Net Operating Expenses $15,011,910 CONTRIBUTIONS TO OTHER FUNDS AND RESERVES General Fund Operating Reserve $ 310,000 Community Center Fund 135,970 Public Liability Insurance Fund 231,335 .Worker's Compensation 40,080 Equipment Fund 143,755 Total $ 861,140 TOTAL ESTIMATED REQUIREMENTS $15,873,050 - 2 - CITY OF LODI ELECTRIC UTILITY FUND SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES OPERATING REVENUES Sale of Electricity $22,610,000 Total T22,610,000 OTHER INCOME Sale of System - Joint Pole Sale of Property - Salvage Pole Rental (CATV) Interest Income Electric Miscellaneous Revenue NOC Total $ 10,000 2,000 12,000 538.,435 35,000 2,000 T 599,435 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services Utilities & Transportation Materials & Supplies. Depreciation of Equipment Equipment, Land & Structures Special Payments Sub -Total Operating Expenses Bulk Power Purchase Total $ 1,161,970 43,165 302,655 17,865 63,455 245,100 1,834,210 $17,223,000 X19,057,210 INTER -FUND TRANSFERS 940 General Fund Charges $ 920, Total 820,940 CONTRIBUTIONS TO OTHER FUNDS AND RESERVES General Fund $ 1,799,810 Rate Stabilization Reserve 400,000 1,000,000 Utility Outlay Reserve 31,475 PL & PD Insurance Fund Total 3,231,285 TOTAL ESTIMATED REQUIREMENTS -3- SCHEDULE C $23,209,435 $23,209,435 CITY OF LODI SEWER UTILITY FUND SCHEDULE D SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES OPERATING REVENUES Sewer Service Charges $1,507,280 Sewer Connection Fees 550,000 Total $2,057,280 TAXES Property (Bond Redemption) $ 281,255 Total $ 281,255 OTHER INCOME Interest Income $ 106,470 Rental of City Property 60,645 Other Revenue 4,000 Total $ 171,115 TOTAL ESTIMATED FINANCING RESOURCES $2,509,650 ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services $ 570,195 Utilities & Transportation 265,370 Materials & Supplies 218,715 Depreciation of Equipment 15,345 Equipment, Land & Structures 530 Special Payments 3,855 Total $1,074,010 BONDED DEBT SERVICE Special Payments: 1965 Sewer Bond Interest $ 56,060 56,060 Total $ PLANT DEPRECIATION $ 314,445 Total -- 314,445 INTER -FUND TRANSFERS General Fund Charges Total $ 109,535$ 109,535 CONTRIBUTIONS TO OTHER FUNDS & RESERVES Sewer Operating Reserve $ 200,000 Wastewater Capital Outlay 740,405 PL & PD Insurance Fund 15,195 Total $ 955,600 TOTAL ESTIMATED REQUIREMENTS $2,509,650 -4- :ITY OF L001 WATER UTILITY FUND SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES OPERATING REVENUES Water Sales $1,495,870 Water Connection Fees 30,000 Total $1,525,870 OTHER INCOME SCHEDULE E Rent of City Property $ 5,000 Interest Income 72,330 Revenue - NOC 3,000 Total $ 80,330 TOTAL ESTIMATED FINANCING RESOURCES $1.606.200 ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services $ 296,685 Utilities & Transportation 323,400 Materials & Supplies 112,375 Depreciation of Equipment 2,305 Special Payments 150 Total $ 734,915 INTER -FUND TRANSFERS General Fund Charges $ 121,490 Total $ 121,490 CONTRIBUTIONS TO OTHER FUNDS & RESERVES General Fund $ 400,000 Water Operating Reserve 142,200 Water Utility Capital Outlay 200,000 PL & PD Insurance Fund 7,595 Total $ 749,795 TOTAL ESTIMATED REQUIREMENTS $1,606,200 - 5 - CITY OF LODI LIBRARY FUND SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES OPERATING REVENUES Fines, Fees and Gifts Total NON-OPERATING REVENUES Investment Income Donations Total TAXES Property Taxes Total REVENUE FROM OTHER AGENCIES California Library Services Act Public Library Foundation Business Inventory Tax Total $ 44,000 $ 44,000 $ 17,745 3,000 $ 20,745 $579,560 $579,560 $ 33,000 36,400 8,465 $ 77,865 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Personnel Services Utilities & Transportation Materials & Supplies Special Payments Total CONTRIBUTIONS TO RESERVES Library Reserve Total $471,020 50,000 172,360 7,500 $700,880 $ 21,290 $ 21,290 TOTAL ESTIMATED REQUIREMENTS SCHEDULE F $722,170 $722,170 CITY OF LODI HUTCHINS STREET SQUARE SUMMARY OF THE BUDGET 1987-88 ESTIMATED FINANCING RESOURCES OPERATING REVENUE Rent of Property Total CONTRIBUTIONS FROM OTHER FUNDS General Fund Operating Reserve Total $ 9,000 $135,970 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSE Personnel Services $ 97,390 Utilities & Transportation 23,605 Supplies and Materials 22,440 Depreciation 1,085 Equipment, Land & Structures 450 Total TOTAL ESTIMATED REQUIREMENTS - 7 - $ 9,000 $135,970 $144,970 SCHEDULE G $144,970 $144,970 CITY OF LODI GENERAL BUDGET DETAIL OF FINANCING RESOURCES 1987-88 GENERAL FUND PROPERTY TAXES Current Year - Secured Bond Redemption OTHER TAXES 1985-86 1986-87 Actual Estimated Resources Resources SCHEDULE H 1987-88 Estimated Resources $2,104,985 $2,300,000 $2,665,440 176,256 174,295 178,595 Total 2,281,241 2,474,295 $2,844,035 Sales and Use Tax $3,616,083 $3,560,000 $4,343,000 Franchise - Gas 118,526 120,895 93,275 Franchise - Cable TV 58,519 53,965 61,835 Business License Tax 77,776 81,350 85,000 Real Property Transfer - Documentary 72,307 75,000 95,000 Total 3,943,211 $3,891,210 4,678,110 LICENSES AND PERMITS Animal Licenses $ 8,146 $ 8,300 $ 7,700 Bicycle Licenses 2,059 -2,030 2,070 Building Permits 257,476 258,500 258,500 Electric Permits 31,460 30,000 30,000 Mechanical Permits (Gas) 25,638 25,000 25,000 Plumbing Permits 28,365 26,000 26,000 Parking Lot Permits 13,702 15,000 15,000 Total $366,846 364�,8 $364,270 FINES, FORFEITS & PENALTIES Vehicle Code Fines $134,871 $156,000 $156,000 Court Fines 17,254 19,000 20,000 Overparking 29,124 30,000 36,500 Total 181,249 $205,000 212,500 REVENUE FROM USE OF MONEY & PROPERTY Investment Earnings $290,829 $255,000 $333,605 Rent of City Property 62,742 .51,420 53,820 Rent of Carnegie Building 2,405 900 900 Total 355,976 307,320 $388,325 GENERAL BUDGET DETAIL OF FINANCING RESOURCES 1987-88 GENERAL FUND (continued) REVENUE FROM OTHER AGENCIES State Disaster Assistance State Motor Vehicle in Lieu of Taxes State Reimbursement P.O.S.T. State Traffic Safety Grant State Cigarette Taxes State Business Inventory Tax Subvention 77,846 County -Recreation Allotment 18,115 LUSD-Recreation Allotment 4,000 Total 1,585,571 CITY OF LODI 1985-86 Actual Resources $ -0- 1,182,212 .89,001 81,405 132,992 CHARGES FOR CURRENT SERVICES Plan Checking Fees Planning Fees Housing Inspection Fees Animal Shelter Fees Engineering Fees Refuse Collection Concessions - Boats Concessions - Other Swimming Photocopy Charges Recreation - Miscellaneous $ 90,796 7,490 -0- 3,681 135,271 1,975,535 6,624 7,891 25,118 9,113 83,724 Total 2,345,243 OTHER REVENUES Sales of Real & Personal Property $ 19,937 Revenue NOC 67,041 Total 86,978 INTER -FUND TRANSFERS Criminal Justice Grant $ 54,134 Community Crime Resistance Grant -O- Housing and Urban Development 15,022 Gas Tax 347,783 Transportation Development Fund 97,715 Total 514,654 - 10 - 1986-87 Estimated Resources SCHEDULE H 1987-88 Estimated Resources $ -0- $ 35,150 1,310,480 1,490,000 75,000 60,000 85,460 15,825 122,940 131,810 58,385 38,925 -0- 18,115 4,000 4,000 1,656,265 $1,793,825 $ 89,500 7,750 2,500 3,825 55,000 2,039,590 -0- 17,000 017,000 24,325 8,900 85,000 2,333,390 $ 2,000 30,000 32,000 $ 63,365 -0- 63,130 373,080 96,875 596,450 $ 89,500 3,600 -0- 3,225 50,000 2,214,000 10,000 15,000 28,000 9,000 113,000 2,535,325 $ 2,000 56,000 58,000 $ 42,890 60,000 75,365 415,060 105,535 698,850 C L -1 - v 1i 11 CITY OF NODI GENERAL BUDGET DETAIL OF FINANCING RESOURCES 1987-88 1985-86 Actual GENERAL FUND (continued) Resources CONTRIBUTIONS FROM OTHER FUNDS & RESERVES Electric Utility Fund $1,866,470 Water Utility Fund 414,045 Hotel/Motel Fund -0- General Fund Operating Reserve 612,121 Workers' Compensation Ins. Fund 168,166 Total 3,060,802 1986-87 Estimated Resources $2,092,670 529,150 75,000 22,800 -0- 2,719,620 SCHEDULE H 1987-88 Estimated Resources $1,799,810 400,000 100,000 -0- -0- 2,299,810 Sub -Total General Fund $14,721,771 14,580,380 $15,873,050 LESS CONTRIBUTIONS TO OTHER FUNDS Capital Outlay Reserve $ -0- General Fund Operating Reserve 1,066,470 Library Fund 10,906 Community Center Fund 22,740 Public Liability Insurance Fund 284,105 Equipment Fund 129,650 Workers' Compensation Fund -0- Total $1,513,871 $500,000 -0- -0- 31,015 229,130 172,965 75,000 1,008,110 $ -0- 310,000 -0- 135,970 231,335 143,755 40,080 861,140 NET TOTAL GENERAL FUND $13,207,900 $13,572,276 $15,011,910 ELECTRIC UTILITY FUND OPERATING REVENUE - ELECTRIC SALES Domestic - Residential $7,229,647 $7,769,820 $8,068,0.00 Commercial - Small Industrial 3,553,379 3,737,290 4,053,900 Dusk -to -Dawn 38,543 41,450 39,570 Mobile Home Parks 115,087 122,360 124,730 Intermediate Industrial 5,111,695 5,391,745 5,856,900 Large Industrial 3,140,537 3,256,865 3,441,790 City Accounts 950,684 1,008,170 1,025,110 Total $20,139,57Z X1,327,700 $22,610,00 CITY OF LODI GENERAL BUDGET DETAIL OF FINANCING RESOURCES 1987-88 ELECTRIC UTILITY FUND (continued) NON-OPERATING Investment Income Rent of City Property (CATV) Sale of Real & Personal Property Sale of System (Joint Pole) Electric Miscellaneous Revenue NOC Total Sub -Total Electric Utility Fund SCHEDULE H 1985-86 1986-87 1987-88 Actual Estimated Estimate Resources Resources Resources $625,808 $575,410 $538,435 30,395 9,000 12,000 2,073 1,805 2,000 19,544 15,000 10,000 42,835 15,000 35,000 6,529 2,000 2,000 727,184 618,215 599,435 20,866,756 $21,945,915 23,209,435 LESS CONTRIBUTIONS TO OTHER FUNDS Rate Stabilization Reserve $3,013,083 $ 478,600 $ 400,000 General Fund 1,866,470 2,092,670 1,799,810 Electric Utility Outlay Reserve 552,200 50,924 -O- 31,175 1,000,000 31,475 PL & PD Insurance Fund Electric Operating Reserve 1,700,000 -0- -0- Total 7,182,677 $2,602,445 T3,231,285 NET TOTAL ELECTRIC UTILITY FUND 13,684,079 19,343,470 19,978,150 SEWER UTILITY FUND OPERATING Sewer Service Charge - Public $1,040,773 $1,094,300 $1,498,925 Sewer Service Charge - City 6,22 354,033 216,000 550,000 ,100 8,355 Sewer Connections (taps) Total 1,400,928 $1,310,400 $2,057,280 TAXES Property Taxes $275,683 $274,775 $281,255 Total 275,683 $274,7T5 281,255 - 12 - D I LIA -__ nr . -- GENERAL BUDGET DETAIL OF FINANCING RESOURCES 1987-88 SEWER UTILITY FUND (continued) NON-OPERATING Investment Earnings Rental of City Property Sewer Reimbursement Fees Revenue NOC Sale of Real & Personal Property Total Sub -Total Sewer Utility Fund LESS CONTRIBUTIONS TO OTHER FUNDS Sewer Utility - Capital Outlay PL & PD Insurance Fund Sewer Operating Reserve Wastewater Capital Outlay Total NET TOTAL SEWER UTILITY FUND WATER UTILITY FUND OPERATING Water Sales - Public Water Sales - City Water Connection Taps NON-OPERATING 1985-86 1986-87 Actual Estimated Resources Resources $106,913 63,302 18,720 1,206 600 190,741 $ 93,110 60,645 2,000 2,000 -0- 157,755 SCHEDULE H 1987-88 Estimated Resources $106,470 60,645 2,000 2,000 -0- 171,115 1,86.7,352 $1,742,930 $2,509,650 $250,000 24,584 202,367 -0- 476,951 $250,000 15,050 38,185 -0- 303,235 $ -0- 15,195 200,000 740,405 955,600 $1,390,401 1,439,695 $1,554,050 _$1,369,429 $1,410,480 '5,161 5,200 60,487 30,000 Total 1,435,077 1,445,680 Investment Earnings $ 95,05.6 Rent of City Property 18,745 Revenue NOC 6,957 Water Reimbursement Fees 3,075 Total $123,833 CONTRIBUTIONS FROM OTHER FUNDS AND RESERVES Water Utility Operating Reserve Total $ 11,798 $ 84,830 5,000 3,000 -0- 92,830 $1,490,610 5,260 30,000 1,525,870 $ 72,330 5,000 3,000 -0- 80,330 $ -0- Sub-Total Water Utility Fund $1,570,708 $1,538,510 $1,606,200 - 13 - riTv nr 1 nn] GENERAL BUDGET SCHEDULE H DETAIL OF FINANCING RESOURCES 1987-88 1985-86 1986-87 1987-88 Actual Budget Budget WATER UTILITY FUND (continued) Resources Resources Resources LESS CONTRIBUTIONS TO OTHER FUNDS & RESERVES General Fund $414,045 $529,150 $400,000 Water Utility - Capital Outlay 400,000 200,000 200,000 Water Operating Reserve -0- -0- 142,200 PL & PD Insurance Fund 12,292 7,525 7,595 Total T826,337 $736,675 749,795 NET TOTAL WATER UTILITY FUND $744,371 $801,835 $956,405 LIBRARY FUND OPERATING Fines, Fees & Gifts Total $ 34,436 $ 34,000 $ 44,000 NON-OPERATING Investment Earnings $ 24,097 $ 15,000 $ 17,745 Donations 2,950 3,000 3,000 Total 27,047 18,000 20,745 PROPERTY TAXES Total $457,695 $500,000 $579,560 STATE GRANTS Library Services Act $ 35,103 $ 33,000 $ 33,000 Public Library Foundation 32,677 33,000 36,400 Business Inventory Tax Subvention. 16,929 12,695 8,465 Total 84,709 78,695 77,865 CONTRIBUTIONS FROM OTHER FUNDS OR RESERVES Library Operating Reserve $ -0- $ 39,285 $ _O_ General Fund 10,906 -0- -0- Tonal 10,906 39,285 $ -0- Sub-Total Library Fund $614,793 $669,980 $722,170 LESS CONTRIBUTIONS TO OTHER FUNDS OR RESERVES Library Operating Reserve Total $ -0- $ -0- $ 21,290 TOTAL LIBRARY FUND $614,793 $669,980 700,880 - 14 - GENERAL BUDGET DETAIL OF FINANCING RESOURCES 1987-88 'ITYOF 1001 1985-86 Actual Resources WORKERS' COMPENSATION INSURANCE RESERVE Compensation Reimbursements $ 17,351 Inter -Fund Transfers 178,569 Investment Earnings 61,243 Total 257,163 CONTRIBUTIONS FROM OTHER FUNDS OR RESERVES General Fund Operating Reserves Total $ -0- SUB TOTAL WORKERS' COMPENSATION INSURANCE RESERVE LESS CONTRIBUTIONS TO OTHER FUNDS AND RESERVES General Fund Total NET TOTAL WORKERS' COMPENSATION INSURANCE RESERVE COMMUNITY.CENTER FUND OPERATING REVENUE Rent Total CONTRIBUTIONS FROM OTHER FUNDS General Fund General- Fund Operating Reserve Total TOTAL COMMUNITY CENTER FUND 1986-87 Budget Resources $ 12,000 270,805 58,500 341,305 SCHEDULE H 1987-88 Budget Resources $ 20,000 296,980 45,800 362,780 $ 75,000 $ 40,080 257,163 $416,305 $402,860 $168,166 $ -0 $ -0- 88,997 $416,305 $402,860 $ 9,125 . $ 9,650 $ 9,000 $ 22,740 $ -0- $ -0- -0- ' 31,015 135,970 22,740 31,015 $135,9170 31,865 .40,665 $144,970 - 15 - CITY OF LODI SPECIAL REVENUE FUNDS SCHEDULE I CONSTRUCTION FUND REVENUES BOND FUND REVENUES TRUST & AGENCY FUNDS .1987-88 32 GENERAL GAS TAX (2107) State Gas Tax Investment Earnings Total 34 STREETS & HIGHWAYS (2126) State - Street'Maintenance Investment Income Total $380,020 $375,390 1985-86 1986-87 1987-88 Fund Actual Estimated Estimated No. SPECIAL REVENUE FUNDS Resources Resources Resources 12 EQUIPMENT FUND Depreciation Total $188,132 $234,145 $253,055 29 DENTAL & LTD/LI INSURANCE RESERVE INTER FUND TRANSFERS Dental Cost Allocations $ 65,999 $ 70,620 $ 80,090 Long -Term Disability Cost Allocations 68,689 71,430 81,130 Employee Contributions 39,312 33,590 35,775 Contributions - Employee Benefits Fund -0- -0- 3,785 Total $174,000 $175,640 $200,780 30 LIABILITY INSURANCE RESERVE Investment Income $ 36,240 $ 41,760 $ 31,265 Contributions - General Fund 284,105 229,130 231,335 Contributions - Enterprise Fund 87,800 53,750 54,265 Total 408,145 $324,640 $316,865 32 GENERAL GAS TAX (2107) State Gas Tax Investment Earnings Total 34 STREETS & HIGHWAYS (2126) State - Street'Maintenance Investment Income Total $380,020 $375,390 $393,840 8,638 7,800 11,660 388,658 $383,190 405,500 $276,717 $106,500 $ -0- 10,233 10,235 19,435 286,950 $116,735 19,435 51 C -CAP GRANT State Grant Total 81,432 63,365 79,165 52 COMMUNITY CRIME RESISTANCE GRANT State Grant Total -0- -0- 60,000 - 17 - CITY OF LODI SPECIAL REVENUE FUNDS CONSTRUCTION FUND REVENUES BOND FUND REVENUES TRUST AND AGENCY FUNDS 1987-88 Fund No.SPECIAL REVENUE FUNDS (continued) 125 DIAL -A -RIDE 1985-86 1986-87 Actual Estimate Resources Resources SCHEDULE I 1987-88 Estimated Resources Special County Transportation $ 40,000 $143,000 $179,805 Allocation State Transit Assistance 135,909 73,750 36,195 Passenger Fares - Lodi 37,853 37,000 38,000 San Joaquin County Reimbursement - 6,552 5,500 6,000 Woodbridge Investment Earnings 271 -0- -0- Local Transporation Fund - Capita126,000 -0- -0- Total $246,585 $259,250 $260,000- 134 HOTEL/MOTEL TAX Taxes Total 76,250 75,000 $100,000 148 FEDERAL REVENUE SHARING Federal Grants $492,161 $211,200 $ -0- Investment Earnings 85,396 77,185 83,150 Total $577,557 $288.385 83,150 Fund No. CONSTRUCTION FUND REVENUES 16.1 ELECTRIC UTILITY OUTLAY RESERVE Inter -Fund Transfer Total. 30,416 17,810 17,865 16.2 ELECTRIC RATE STABILIZATION RESERVE Investment Earnings Total 17.2 WASTEWATER -CAPITAL RESERVE Inter -Fund Transfer Total 18.1 WATER UTILITY -CAPITAL OUTLAY FUNDS Inter -Fund Transfer Total 336,655 -0- 366,560 351,009 313,785 314,445 12,071 7,420 2,305 21.1 LIBRARY CAPITAL OUTLAY $ Investment Income 19,712 $ 15,000 $ 15,000 Sale Real & Personal Property (1,017) -0- Total 18,695 15,000 15,000 - 18 - C D 11 A rIIry nr i nni SPECIAL REVENUE FUNDS CONSTRUCTION FUND REVENUES BOND FUND REVENUES TRUST & AGENCY FUNDS SCHEDULE I 1987-88 1985-86 1986-87 1987-88 Actual Estimated Estimated Fund Resources Resources Resources No. CONSTRUCTION FUND REVENUES (continued) 33 SELECT SYSTEM GAS TAX (2106) Investment Income $ 58,487 $ 53,140 $ -0- State Gas Taxes 173,109 170,910 181,975 Total $231,596 $224,050 $181,975 44' 1980 STATE PARK BOND ACT Investment Earnings Total 44.1 1984 STATE PARKS BOND ACT State Grant Total 45 45.1 46 47 72 1,033 980 845 -0- 97,000 -0- HUD ENTITLEMENT GRANT Federal Grant Total $126,733 -0- -0- HUD - ENTITLEMENT GRANT County Grant Total 69,892 $309,390 374,570 INDUSTRIAL WAY & BECKMAN DEVELOPMENT Investment Earnings $ 9,678 $ 8,940 $ 8,960 Revenue NOC 3,787 -0- -0- Total 13,465 8,940 8,960 INDUSTRIAL WAY & BECKMAN ROAD DEVELOPMENT #2 FUND Investment Earnings Total SUBDIVISION RESERVES (CITY) Subdivision Fees Total 75 SUBDIVISION FUND - IN TRUST Subdivision Fees Total 836 810 845 217,396 50,000 50,000 822,394 150,000 $100,000 123 MASTER DRAINAGE FUND Acreage Fees $455,087 $150,000 $100,000 Rental of Property -0- -0- 1,215 Total $455,087 150,000 $101,215 124 TRANSPORTATION DEVELOPMENT ACT Local Cash Grants $642,963 $572,735 $562,625 Investment Earnings 33,602 26,485 24,000 Total 676,565 $599,220 $586,625 - 19 - CITY OF LOD1 SPECIAL REVENUE FUNDS SCHEDULE I CONSTRUCTION FUND REVENUES BOND FUND REVENUES TRUST & AGENCY FUNDS 1987-88 1985-86 1986-87 1987-88 Actual Estimated Estimated Resources Resources Resources Fund No.CONSTRUCTION FUND REVENUES (continued) 126 FEDERAL URBAN "D" FUND Grant Revenue Total $776,704 -0- -0- 128 TDA - PEDESTRIAN/BIKE PATH $ 14,023 $ 14,911 $ 15,465 Grants Investment Earnings 308 -0- 505 Total 14,331 14,911 15,970 Fund No. BOND FUND REVENUES 41 BOND INTEREST & REDEMPTION FUND Inter -Fund Transfer Total 457,715 449,070 459,850 48 TURNER CLUFF ASSESSMENT DISTRICT 01 / $251,292 $243,610 $230,075 Property Tax Investment Earnings 29,318 29,090 24,165 Total $280,610 272,700 $254,240 49 DOWNTOWN IMPROVEMENT DISTRICT $ 39,682 $ 49,950 $ 53,835 Property Tax Investment Income 5,203 3,735- 3,720 Total 44,885 53,685 57,555 Fund No.TRUST & AGENCY FUNDS 140 RESERVE FOR COST OF LABOR & MATERIAL $ 20,754 $ 20,000 $ 20,00 0 Plan Checking Fees Police Bail - Other Cities 19,456 20,000 16,000 Recreation Miscellaneous 69,898 70,000 48,120 Miscellaneous Work for Others 61,750 20,000 20,000 EIR Consultant Fees -0- -0- 30,000 Total $171,858 $130,000 134,120 - 20 - CITY OF LODI r-vmv�:m --I --InrEcnmCD -1 -0;amm-0-n-0mnnr)vonnm CDm.oror H O O 00 —0) (D --i O V O O 0) m-0-0 C --O J•0 J•J•m m o 0 m zzc =m -I --1S 0"c+f m = -i -Ina J.v -s J= m I -- � 7c n a a s -s m m n m a . a�� cc+= cots 7r -S m 1 1 1 I 1 a'0 m r raw -s -Sct;Q 00 r Nm'v-oJ. f7=c -1-+•0;a NNUl -i r 3 -0 ;o -P CTI P W -P UIHH = -s -s N O 0) a 0 m 0 = 3 a (n 0) = J. a m mvcnc 00 Ul OO O H CJI 01 00 00 ca c:) O- ,-, cc -•• -n o c+3m m J- QJ c+ (D -+cu -ter V Ul ;a Z - -i C _0 --A c+ c+ c+ (7 C m -+• W = :E: c+ 0 c+ -1 m \ N 01 O w 0 0100 W -I 00 w vm =l< J•J• z z O J•e+0 c< a o < n= n -n N C-) r- n;o m v m : -1 to -1 --=r0 -�•c Pbc=)m P00 H vc cnc:) ma znc+cn ^AA ;a c+32tr 1= (D = 0 0) -•c+z V ;o C 3 --q -I -I m c+ c+-+• O Ulm O Ul O O O Ul O O M O O O a •I sv N m-1 m m -S m 00 N a ;10v _0 -< N P--+ -n = l< l< -� r J• < << to N N az am z C= C.+ V' m m n ca n Z Z O O Z m c+ •1 i 'i c+ -_j Cn -+ �--i m n (n C V V V v-1 C m m O m O Ln N Ln �tv P--4m--Irr- 00 tm P v T --I �-+ a CTI Ul Ul C.+ m < O - Ul I _ NEA f7 0 Z m C+ H b4 H W N H O H N w H H HN Ul Ul .ANCTIH 1D �I W 1."011-V O-PNH H CT O w -P N 1D CO V CD V Ol N 0) V N -P Ul H Ul V 1O 0 1D O HSI O W w V V 1--01OH Ul 0001 1DN 0100 O1 O110 -Ph H Ol V V 0A 01 V V O 10 O N V V W O m H CO V V V V V V V N H W a7 O lO V H 01 01 N O N w O 1D H CT lD N CO CD V Ul CTI UI H O H Ul 00 A V O 01 O M M I I o0 O O O OMMO O O O 1 UlUl CTICTIOUIO O I O I U1 rn rn 1 1 1 O O 1 fol) -{-0+ 4-4l)- 4_ -o -, {-q 4_04 H HU1 N -PA M vNUlwool N 00 N 1:. N w V V V V V O1 H 00 H w H NUl-P000UI CnUlUtO0U1 �T L71 N N H N CO V H O M H m O CSI O V O O N O O H C) c:) 00 1 00 Ul fol) -{-0+ 4-4l)- 4_ -o -, {-q 4_04 H HU1 N -PA M vNUlwool N 00 N 1:. N w V V V V V O1 H 00 H w H NUl-P000UI CnUlUtO0U1 �T L71 tea Ln N N H 00 H 01 W 1 1 Ul 1 1 1 00 b4 V IJ 4::- V 4: -- : --HW H I -- V N N .P N W V H CJI .P N1D-1 1 1 1 I 1 O fol) -{-0+ 4-4l)- 4_ -o -, {-q 4_04 H HU1 N -PA M vNUlwool N 00 N 1:. N w V V V V V O1 H 00 H w H NUl-P000UI CnUlUtO0U1 �T Ea4 tea H N H fJ4 . H H H 01 W W O 00 V V U1 4::- N H H V V N N .P N V V HH CJI .P N1D-1 Ul lD W N N m W 00 V co NNUl N0)01 CTI -P CTI P W -P UIHH N N O OO W C) W m 01 H 00 Ul OO O H CJI 01 00 00 .Ip 00 Y H V 01010-PWH V V V V V Ul V V V V V U,W NU1W W0006 cn H N -P O O O V 01 00 N 01 O w 0 0100 W -I 00 w U1 OUlO O c:) L" Ln C) al 1 I O O OMOCnUl 1 0 1 Ul 4A OUl1D-P0)wH.PU1N H W NH W.PO(lU1 V H N1O V tD-P%NV W WUl00V W Cn01 -P Pbc=)m P00 H N V V V V V H ^AA 10 CO 41 C) 1Q O1•PV -4M W1D-PVlO01U1 V 000 V V coOCncn H N4PO VM4I :-W OlD00N1D1D0-P V Y O Ulm O Ul O O O Ul O O M O O O N m W 00 H H N W -P H H 1 D H Lri H W H O C -+• -I H N N --I H H O lfl 00 -P V 1000 O -1 W W -P H 10 V' t0 Co NNN00N O .P UI- W00100 -PV HH O H ' V V V V V VV V V V V V V V V V V O Ln 4p- W W V 0) Ln W 0 0-4 0 0 1.0 - W. A V 41- P 00 00 tm P -Vu O1VHUl CTI H10000W Ola1Hdp0000 O CTI Ul Ul O O CJI CJl Ul c:)l Ul O— O U1 CTI CTI O O c n O 1 Ul I O H �Y tea H N H fJ4 . 1D O1 w 01 W W O H 4! 01 U1 4::- N H H H V N N .P N i�:- V HH CJI .P N1D-1 01 01-P -Pw W HUl WH W Ul 00 V V V V W V 00 V -P 1,01 V V V V V GnW 4-1-1-000HU1 V O N -P 00 O to 0) V 01 W V O1 V V -P W 01 H .Ip O CJI U1 1 Ul O 01 CTI Ul O 1 Ul O M UI Ul O Ul Ul I I 1 O H �Y tea H N H fJ4 . 1D of W 01 w H O 00 P V 1D Ul Ul W 4::- P w H V V 10 V V V 00 V -IP i�:- V CJI P V w CJI .P V V 00 10 H N N O w Ul w U1 V Ul H w 10 W O Ul C-71 Ul0 1 1 0 U1 0 0 o I 1 0 0 cn Ln 1 0 1 I 1 I I IN, to Ul MV 00 H O -0 �Y N N O -1 N O < O W N 01 H H N H U1 -P. -0. V 10 Ul N V 1D Ul Ul V V Ul 00 01 O V Ol V V V Ui H lO H H V V V V Zn H H O Ul V O O1 O U1 H O -P N O W 01 O 1O W O Ul I o 0 Ul O CTI O O I I L" U1 i I O I 1 Cn O O I Ln H b4 H 64 �� ^ 3 O vI cn co H H H 1D Cn 01 -P o W .P 4�n- U1 N O N H CO w 00-4 00 Ln H H 10 O V V V V V V V V o to Ul 01 -P (.n 0) 1-- w c+ c U11D 01 (n ko H O N Ul 00 lO m 1D W -P Ln O Ln Ul O CTI O Ul 1 1 O Ul O 1 I 1 I I� 1 I— I H F -i -� m kD Z cn N CO fi7 v Ul F ^ N N .P N V V V V A V V V NH V 00Ul10 O OUl1D-P0)wH.PU1N H W NH W.PO(lU1 V H N1O V tD-P%NV W WUl00V W Cn01 -P Pbc=)m P00 H HNv V W-100 V00N-1000O0 W V V V V V V V -4- V V V V V V V V V -P 10 CO 41 C) 1Q O1•PV -4M W1D-PVlO01U1 V 000 CJI V coOCncn H N4PO VM4I :-W OlD00N1D1D0-P m o O. -CTI -O O O O Ulm O Ul O O O Ul O O M O O O N m v - 21 - -0 Ln m O 11 -n 0 n O -1 N O < O m J. n O M m r Cn m sv C >3 C+ 0 it J• O f+ --1 J• Ln O c+ C+ � J. 3 J. 0 m 3 O vI cn a � 1 � O .n 3 O w c+ c m O m f1 O ;a O-5 Q J >J. iu J. H F -i -� m kD Z cn N CO fi7 v 1 OD 0o c v 00 v O c+ -0 m O J. Z 1-1 0 n N J� W 1 C3 m N m v c+ r _a a ccn -1 sL c A O C -+• -I C) cl+ a r3 csum z Z = 0 -1 m 0- c+ Cn y v O 11 -n 0 n O In m m -s r H m u 0 CITY OF LODI CITY OF LODI OPERATING BUDGET 1987-88 Total T 22,097 $ -0- 26,400 10-001.03 100 City Council Personnel Services $ 15,519 1985-86 1986-87 1987-88 CITY COUNCIL AND CITY CLERK Actual Budget Budget 10-001.01 100 City Clerk - Administration Personnel Services $ 69,115 $ 74,555 $ 72,980 200 Utility & Transportation 7,134 18,306 8,240 24,790 6,835 24,750 300 400 Supplies, Materials & Services Depreciation of Equipment 2,218 2,025 3,040 -0- -0- 2,600 26,400 Total 96,773 109,610 107,605 10-001.02 100 Election Personnel Services $ 5,005 $ -0- $ 6,000 200 300 Utility & Supplies, Transportation Materials & Services 2,080 15,012 -0- -0- 2,700 17,700 Total T 22,097 $ -0- 26,400 10-001.03 100 City Council Personnel Services $ 15,519 $ 24,040 $ 24,025 200 Utility & Transportation 16,554 3,658 15,000 3,000 16,000 3,000 300 Supplies, Materials & Services Total T 35,731 42,040 43,025 10-001.04 100 Special Election Personnel Services $ 4,296 $ -0- $ 3,000 200 300 Utility Transportation Supplies, Materials & Services 1,345 12,020 -0- -0- 2,600 26,400 Total 17,661 �- 32,000 Total City Council & City Clerk $172,262 $Ibl,650 209,030 CONTINGENT FUND 10-015.01 Contingent Fund 600 Special Payments Total Contingent Fund $ 42,421 $250,000 $250,000 Total $42,421 250,0 $250,000 42,421 1250,000 250,000 !W*M CITY OF LODI 1987-88 OPERATING BUDGET 1985-86 1986-87 1987-88 GENERAL CHARGES Actual Budget Budget 10-020.01 Refuse Collectionn Co tract = 300 Supplies, Materials & Services$ 12,526 $ 18,980 $ 10,545 600 Special Payments 1,811,560 1,877,185 2,166,190 Total 1,824,086 $1,896,165 $2,176,735 10-020.02 Insurance 200 Utility & Transportation $ -0- $ -0- $ - 500 300 Supplies, Materials & Services 39,716 43,620 48,195 Total T 39,716 43,620 48,695 10-020.05 Special Payments - Administration 100 Personnel Services 73,402 $ 82,060 $ 91,260 200 Utility & Transportation 180 180 180 300 Supplies, Materials & Services 13,588 6,530, 29,985 600 Special Payments 50,594 38,500 16,500 Total 137,764 127,270 137,925 10-020.06 Community Promotion 300 Supplies, Materials & Services $ -0- $ 10,080 $ 10,080 600 Special Payments -0- 15,190 14,040 Total 0- 25,270 24,120 Total General Charges 2,001,566 $2,092,325 $2,387,475 BOND DEBT SERVICE 10-030.01 General Obligation Bond Debt Service 600 Special Payments 176,970 $174,295 $178,595 Total 176,970 $174,295 178,595 Total Bond Debt Service $176,970 $174,295 $178,595 CITY ATTORNEY 10-035.01 Counsel and Legal Services 100 Personnel Services $ 81,279 $102,340 $104,600 200 Utility & Transportation 8,479 8,965 8,575 300 Supplies, Materials & Services 14,603 8,130 11,480 400 Depreciation of Equipment 314 315 515 500. Equipment, Land & Structures 396 -0- -0- Total 105,071 $119,750 125,170 Total City Attorney 105,071 $119,750 $125,170 -24- 1987-88 OPERATING BUDGET 1985-86 CITY MANAGER Actual 10-040.01 City Manager - Administration 11,485 100 Personnel Services $189,522 200 Utility & Transportation 10,941 300 Materials & Services 13,926 400 Depreciation of Equipment 1,006 500 Equipment, Land & Structures -0- Total 215,395 1986-87 1987-88 Budget Budget $201,620 $227,555 11,970 12,850 12,255 11,485 825 1,085 -0- 250 226,670 253,225 10-040.02 Personnel - Administration $163,130 $196,520 200 Utility & Transportation 100 Personnel Services $ 79,738 $ 70,855 $ 72,115 200 Utility & Transportation 5,372 5,020 5,985 300 Supplies, Materials & Services 23,158 23,750 30,000 400 Depreciation of Equipment 79 80 80 500 Equipment, Land & Structures 123 -0- -0- Total 108,470 99,705 108,180 Total City Manager $323,865 $326,375 $361,405 COMMUNITY DEVELOPMENT DEPARTMENT 10-045.01 Planninq - Administration 100 Personnel Services $185,674 $163,130 $196,520 200 Utility & Transportation 10,395 9,840 9,450 300 Supplies, Materials & Services 8,227 10,515 10,935 400 Depreciation of Equipment 1,911 2,065 1,570 Total $206,207 $185,550 T2-18-,4-7-5 10-045.02 Buildinq i -ns Rection 100 Personnel Services $192,530 $1991-945 $204,260 200 Utility & Transportation 5,056 .6,270 6,630 300 Supplies, Materials & Services 26,737 51,145 26,805 400 Depreciation of Equipment 1,550 1,530., 2,260 600 Special Payments 4,26.7 5,000 5,000 Total 230,140 $263,890 244,955 45.0-301.01 Grant Administration 100 Personnel Services $ 32,553 $ 63,220 $ 75,365 Total 32,553 63,220 75,365 Total Community Development $468,900 $512,660 $538,795 - 25 - 1987-88 OPERATING BUDGET FINANCE DEPARTMENT CITY OF LODI 1985-86 1986-87 Actual Budget 10-050.01 100 Administration Personnel Services 138,192 $138 $143,300 200 Utility & Transportation 4,775 16,289966 5,515 17,58990 300 Supplies, Materials & Services 400 Depreciation of Equipment Total 160,159 10-050.02 Purchasing 100 Personnel Services $ 18,172 608 200 Utility & Transportation 300 Supplies, Materials & Services 1,286 500 Equipment, Land & Structures -0- Total T 20,066 10-050.03 Accounting 134,247 100 Personnel Services $ 3,243 200 Utility & Transportation 300 Supplies, Materials & Services 4,508 400 Depreciation of Equipment 32 500 Equipment, Land & Structures 288 Total 142,318 10-050.04 Billin 205,669 100 Personnel Services $ 29,920 200 Utility & Transportation 300 Supplies, Materials & Services 12,848 400 Depreciation of Equipment -0- 500 Equipment, Land & Structures 247 Total 248:684 10-050.05 Collections & Credit 178,401 100 Personnel Services $ 4,817 200 Utility & Transportation 300 Supplies, Materials & Services 15,452 15 400 Depreciation of Equipment 537 500 Equipment, Land & Structures Total 199,222 10-050.06 Data Processing $ 91,026 100 Personnel Services 782 200 Utility & Transportation 300. Supplies, Materials & Services 2,874 400 Depreciation of Equipment 211,408 500 Equipment, Land & Structures -0- 167,300 $100,780 2,790 28,325 7,250 139,145 $142,035 3,515 4,675 150 720 151,095 $215,210 30,980 16,945 -0- -0- 263,135 $188,495 4,795 16,935 575 875 211,675 $103,540 740 38,770 14,920 -0- 1987-88 Budget $170,175 5,380 20,250 1,275 197,080 $131,450 4,200 28,545 3,500 ,167,695 $151,175 3,175 6,350 150 550 161,400 $234,045 35,490 18,545 340 4,310 292,730 $192,390 5,460 16,600 1,155 2,860 218,465 $119,965 770 37,980 16,195 1,485 Total 141,090 157,970 $176,395 -26- 1: G v r: r S I 11A it CITY OF LODI 1987-88 OPERATING BUDGET 1985-86 1986-87 1987-88 Actual Budget Budget FINANCE DEPARTMENT (continued) 10-051.02 Parking Patrol 100 Personnel Services $ 49,690 $ 54,610 $ 57,580 200 Utility & Transportation 594 960 890 300 Supplies, Materials & Services 4,487 5,180 6,140 400 Depreciation of Equipment 1,803 1,230 2,630 Total T 56,574 61,980 67,240 Total Finance Department $968,113 $1,152,300 $1,281,005 POLICE DEPARTMENT 10-101.01 Animal Shelter 100 Personnel Services $ 57,260 200 Utility & Transportation 1,575 300 Supplies, Materials & Services 7,019 500 Equipment, Land & Structures -0- Total 65,854 10-103.01 Police Administration 100 Personnel Services $2,909,384 200 Utility &Transportation 24,593 300 Supplies, Materials & Services 279,292 400 Depreciation of -Equipment 23,628 500 Equipment, Land & Structures 1,024 600 Special Payments 561 Total 3,238,482 10-103.02 C -CAP City Match 100 Personnel Services 200 Utility & Transportation 300 Supplies, Materials & Services Total $ 59,245 1,775 9,350 -0- 70,370 $3,034,575 35,325 327,895 25,545 8,870 -0- 3,432,210 $ -0- $ 15,825 -0- -0- . -0- -0- $ -0-- 15,825 $ 61,145 1,910 9,060 1,165 73,280 $3,561,195 34,940 300,785 41,175 5,970 -0 3,944,065 $ 30,095 500 3,000 33,595 10-104.01 Auxiliary Police 200 Utility & Transportation $ -0- $ 500 $ 500 300 Supplies, Materials & Services 4,137 12,400 9,600 500 Equipment, Land & Structures 1,422 -0- -0- Total 5,559 12,900 10,100 - 27 - CITY OF LODI 1987-88 OPERATING BUDGET 52-103.01 Community Crime Resistance (CCR 100 Personnel 1985-86 1986-87 1987-88 POLICE DEPARTMENT (continued) Actual Budget Budget 51-103.01 Criminal Justice Grant - (C -CAP) 3,450 300 Supplies, 100 Personnel Services $ 49,172 $ 34,165 $ 20,925 200 Utility & Transportation 1,690 3,000 -0- 300 Supplies, Materials & Services 2,767 6,840 21,965 500 Equipment, Land & Structures 505 -0- -0- Total 54,134 44,005 42,890 52-103.01 Community Crime Resistance (CCR 100 Personnel Services $ -0- $ 42,801 $ 30,595 200 Utility & Transportation -0- 3,160 3,450 300 Supplies, Materials & Services -0- 14,109 25,955 500 Equipment, Land & Structures -0- 6,597 -0- 7,990 600 Total $ -0- $ 66,667 $ 60,000 10-103.03 CCR - City Match 100 Personnel Services $ -0- $ -0- $ 15,000 Total $ -0- � -0- 15,000 Total Police Department $3,364,029 $3,641,977 $4,178,930 FIRE DEPARTMENT 10-201.01 Administration 100 Personnel Services $2,013,945 $2,120,500 $2,156,015 200 Utility & Transportation 24,639 27,920 30,530 300 Supplies, Materials & Services 88,107 93,635 109,165 400 Depreciation of'Equipment 13,958 14,605 23,475 500 Equipment, Land & Structures 10,954 14,880 7,990 600 Special Payments 93 165 165 Total 2,151,696 2,271,705 $2,327,340 Total Fire Department $2,151,696 2,271,705 $2,327,340 PUBLIC WORKS DEPARTMENT 10-301.01 Administration 100 Personnel Services $167,442 $174,500 $186,185 200 Utility & Transportation 6,708 6,640 7,415 300 Supplies, Materials & Services 19,098 22,825 24,995 400 Depreciation of Equipment 4,569 4,565 11,775 Total 197,817 $208,530 230,370 28 - 1� C C 7 11 CITY OF LODI 1987-88 OPERATING BUDGET 1985-86 1986-87 PUBLIC WORKS DEPARTMENT (continued) Actual Budget 10-301.02 Labor Overhead 100 Personnel Services 10-302.01 General Enaineerin 1987-88 Budget $ 21,043 $ -0- $ -0- Total T 21,043 � -0- $ -0- 100 Personnel Services $105,654 $134,050 $141,760 200 Utility & Transportation 2,833 3,940 .3,200 300 Supplies, Materials & Services 14,525 9,870 11,580 Total 123,012 $147,860 156,540 10-302.02 Subdivision Engineering 100 Personnel Services $118,985 $140,285 $161,220 300 Supplies, Materials & Services 7,931 8,150 8,150 Total $126,916 $148,435 169,370 10-302.03 Encroachment Permits 100 Personnel Services $ 16,426 $ 32,450 "$ 34,440 300 Supplies, Materials & Services 273 500 1,000 Total T 16,699 32,950 35,440 10-302.04 Traffic Enaineerin 100 Personnel Services $ 55,944 $ 54,085 $ 74,610 200 Utility & Transportation 225 600 600 300 Supplies, Materials & Services 1,538 1,610 1,560 Total 57,707 56,295 76,770 10-351.01 City Building Maintenance 100 Personnel Services $ 86,113 $ 85,880 $ 95,420 200 Utility & Transportation 86,753 86,67.0 .85,965 300 Supplies, Materials & Services 90,611 87,200 97,845 400 Depreciation of Equipment 1,459 1,540 1,380 500 Equipment, Land & Structures 783 -0- -0- Total 265,719 $261,290 280,610 10-501.01 Streets Administration 100 Personnel Services $ 58,282 $ 61,625 $ 64,030 200 Utility & Transportation 1,806 2,525 3,380 300 Supplies, Materials & Services 163,057 167,390 142,485 400 Depreciation of Equipment 2,488 8,955 7,455 500. Equipment, Land & Structures 59 215 -0- 600 Special Payments 669 1,150 1,150 Total 226,361 $241,860 218,500 -29- CITY OF LODI 1987-88 OPERATING BUDGET Curb & Gutter Maintenance $ 3425 $ 17,275 $ 18,735 100 300 Personnel Services Supplies, Materials & Services , 798 1985-86 1986-87 1987-88 PUBLIC WORKS DEPARTMENT (continued) Actual Budget Budget 10-502.01 Streets Engineering - Other $ 12,273 $ 26,450 $ 22,700 100 300 Personnel Services Supplies, Materials & Services -0- _0_ 2,100 Total T 12,273 26,450 24,800 32-502.02 Streets Engineering - Gas Tax $ 6,000 $ 6,000 $ .6,000 100 Personnel Services Total T 6,000 6,000 6,000 10-502.03 Storm System Engineering $ 3,894 $ 16,225 $ 17,215 100 300 Personnel Services Supplies, Materials & Services -0- _0_ 1,380 Total 3,894 16,225 $18,595 124-503.01 Streets Maintenance $ 15,421 $ _0_ $ -0- 100 300 Personnel Services Supplies, Materials & Services 57,475 73,625 71,750 33,785 500 Equipment, Land & Structures 24,460 23,250 Total 97,356 96,875 105,535 32-503.02 100 Streets Maintenance $223,481 $234,600 $271,260 Personnel Services 300 Supplies, Materials & Services 42,835 46,425 47,300 Total 266,316 2819025 318,560 32-503.04 100 Alley Maintenance Personnel Services $ 25,706 $ 27,765 $ 30,185 300 Supplies, Materials & Services 17,093 18,665 19,230 Total T 42,799 46,430 49,415 32-503.05 Curb & Gutter Maintenance $ 3425 $ 17,275 $ 18,735 100 300 Personnel Services Supplies, Materials & Services , 798 1,350 1,350 21,000 500 Equipment, Land & Structures 4,969 21,000 Total 9,192 39,625 41,085 10-503.06 Tree Maintenance Personnel Services $ 55,173 $ 70,505 $ 87,695 100 300. Supplies, Materials & Services 13,498 12,900 13,300 1,095 500 Equipment, Land & Structures 801 Total 69,472 84,285 $102,09U - 30 - A L J A A 1987-88 OPERATING BUDGET CITY OF NODI ITOR I :., PUBLIC WORKS DEPARTMENT (continued) Actual 10-503.07 Street Cleaning Utility & Transportation 100 Personnel Services $103,738 300 Supplies, Materials & Services 23.662 500 Equipment, Land & Structures -0- Total 127,400 10-503.08 Traffic Control Maintenance 100 Personnel Services $ 98,703. 200 Utility & Transportation 23,995 300 Supplies, Materials & Services 48,890 500 Equipment, Land & Structures 6,971 Total T178,559 10-503.09 Storm System Maintenance 100 Personnel Services $ 40,442 200 Utility & Transportation 14,921 300 Supplies, Materials & Services 11,778 500 Equipment, Land & Structures 855 600 Special Payments 6,218 Total T 74,214 10-503.10 Street Light Maintenance 100 Personnel Services $ 29,905 200 Utility & Transportation 193;771 300 Supplies, Materials & Services 1,394 500 Equipment, Land & Structures 21,535 Total $246,605 10-503.15 Emerciencv Flood Control 100 Personnel Services $ 16,887 200 Utility & Transportation 252 300 Supplies, Materials & Services 60,290 500 Equipment, Land & Structures 13,823 Total T 91,252 1986-87 Budget $107,720 24,890 -0- 132,610 $107,940 25,405 47,400 6,440 187,185 $ 44,635 14,495 9,790 -0- 6,225 75,14-5 $ 41,065 202,000 450 25,450 268,965 1987-88 Budget $123,165 47,910 385 171,460 $127,210 25,585 51,565 7,965 212,325 $ 39,885 14,275 21,690 1,000 5,985 82,835 $ 41,075 206,700 450 36,600 284,825 32-503.11 Sidewalk Maintenance 100 Personnel Services $ 22,045 $ -0- $ -0- 300 Supplies, Materials & Services 1,431 -0- -0- Total T 23,476 -0- $- -0- - 31 - I I CITY OF LODI . 1987-88 OPERATING BUDGET 1985-86 1986-87 1987-88 PUBLIC WORKS DEPARTMENT (continued) Actual Budget Budget 10-504.01 100 Parking Lot Maintenance Personnel Services $ 7,387 $ 9,150 $ 9,540 300 Supplies, Materials & Services 2,364 5,105 5,215 500 Equipment, Land & Structures 6,025 -0- -0- Total 15,776 14,255 14,755 10-551.01 100 Equipment Maintenance Personnel Services $ 59,685 $ 53,690 $ 90,275 200 Utility & Transportation 838 1,020 1,080 300 Supplies, Materials & Services 13,009 7,945 12,515 400 Depreciation of Equipment 2,165 2,215 .2,750 Total 75,697 64,870 $106,620 10-551.02 300 Motor Pool Supplies, Materials & Services $ 3,011 $ 4,375 $ 5,565 Total 3,011 4,375 5,565 Total Public Works Department 2,378,566 2,441,540 $F,712,065 EQUIPMENT MAINTENANCE 10-556.01 100 Equipment Maintenance Personnel Services $109,468 $147,945 $129 , 315 300 Supplies, Materials & Services 255,311 247,050 193,880 400 Depreciation of Equipment 138,300 135,405 174,575 Total 503,079 $530,400 497,770 700 Credits $(5059511) $(530,400) $(497,770) Total Equipment Maintenance 2,432 -0- RECREATION AND PARKS -DEPARTMENT - RECREATION DIVISION 10-701.01 100 Administration Personnel Services $ 91,275 $204,805 $222,750 200 Utility & Transportation 14,553 26,507 18,720 28,535 19,450 36,690 300 Supplies, Materials & Services- 2,080 945 4,130 400. Depreciation of Equipment 483 -0- 500 Equipment, Land & Structures Total 134,898 $253,005 283,870 - 32 - 33 CITY OF LODI 1987-88 OPERATING BUDGET 1985-86 1986-87 1987-88 RECREATION DIVISION (continued) Actual Budget Budget 10-702.01 Playgrounds 100 Personnel Services $ 18,642 $ 12,360 $ 14,195 200 Utility & Transportation -0- 150 -0- 300 Supplies, Materials & Services 7,311 7,650 7,200 Total 25,953 20,160 21,395 10-702.02 Basketball 100 Personnel Services $ 36,855 $ 15,060 $ 18,900 300 Supplies, Materials & Services 1,632 5,850 4,660 Total 38,487 20,910 23,560 10-702.03 Miscellaneous Indoor Activities 100 Personnel Services $ 12,477 $ 3,100 $ 3,750 200 Utility & Transportation 3,336 3,545 3,060 300 Supplies, Materials & Services 2,327 3,775 2,300 Total 18,140 10,420 9,110 10-702.04 Lake Park 100 Personnel Services $ 34,143 $ 22,700 $ 15,245 200 Utility & Transportation 347 500 300 300 Supplies, Materials & Services 6,250 6,750 4,250 500 Equipment, Land & Structures -0- -0- 2,290 600 Special Payments 7,159 7,500 7,500 Total 47,899 37,450 29,585 10-702.05 Baseball & Softball Parks 100 Personnel Services $ 68,160 $ 41,590 $ 46,540 200 Utility & Transportation 27,313 20,735 21,050 300 Supplies, Materials & Services 15,563 28,910. 29,270 500 Equipment, Land &_Structures -0- -0- 270 Total $111,036 91,23.5 97,130 10-702.06 Miscellaneous Outdoor Activities 100 Personnel Services $ 32,501 $ 16,810 $ 17,445 200 Utility & Transportation 2,092 2,450 2,340 300 Supplies, Materials & Services 6,024 7,775 9,020 Total 40,617 27,035 28,805 10-702.07 Blakely Pool 100 Personnel Services $ 8,960 $ 10,000 $ 18,485 200 Utility & Transportation 8,887 8,740 8,765 300 Supplies, Materials & Services 1,669 4,350 3,000 ■ Total 19,516 23,090 30,250 33 CITY OF LODI 1987-88 OPERATING BUDGET 1985-86 1986-87 1987-88 RECREATION DIVISION (continued) Actual Budget Budget 10-702.08 100 Lodi High Pool Personnel Services $ 3,749 $ 4,500 $ 5,355 200 300 Utility & Transportation Supplies, Materials & Services 390 525 240 2,000 300 1,700 Total $ 4,664 6,740 7,355 10-702.09 100 Tokay High Pool Personnel Services $ 11,343 $ 12,110 $ 13,485 200 300 Utility & Transportation Supplies, Materials & Services -0- 49,493 100 41,00.0 100 47,800 Total T 60,836 53,210 61,385 Total Recreation Division 502,046 $543,255 $592,445 PARKS DIVISION 10-751.01 100 Parks Administration Personnel Services $ 63,865 $ 63,010 $ 99,145 200 Utility & Transportation 1,069 1,085 2,770 3,50 3,3350 300 Supplies, Materials & Services 1,887 200 500 Equipment, Land & Structures -0- -0- Total T 66,821 66,8 T106,180 10-751.02 100 Parks Overhead Personnel Services $ 10,199 $ -0- $ -0- Total T 10,199 $� -0-' 10-752.01 100 Stadium Maintenance Personnel Services $ 41,576 $ 32,925 $ 33,515 200 Utility & Transportation 6,583 7,620 12,130 8,530 14,320 300 Supplies, Materials & Services 11,643 Total 59,802 52,675 56,365 10-752.02 100 Lodi Lake Park Personnel Services $143,083 $162,570 $182,700 200 Utility & Transpolsa&,on 4,379 11,729 6,105 20,340 6,210 19,860 300 Supplies, Materia Services Total 159,191 $189,015 208,770 -34- 1987-88 OPERATING BUDGET 1985-86 PARKS DIVISION (continued) Actual 10-752.03 Other Parks 100 Personnel Services $348,483 200 Utility & Transportation 23,470 300 Supplies, Materials & Services 53,880 500 Equipment, Land & Structures 10,040 Total 435,873 10-752.08 Carnegie Buildin 1986-87 1987-88 Budget Budget $429,370 26,515 70,490 15,320 541,695 $417,365 28,695 81,770 4,350 532,180 100 Personnel Services $ 3,409 $ 3,125 $ 3,150 200 Utility & Transportation 1,239 1,570 1,600 300 Supplies, Materials & Services 709 2,260 .2,335 Total T 5,357 6,955 7,085 10-753.01 Eauiament Maintenance 100 Personnel Services $ 27,202 $ 30,990 $ 32,375 300 Supplies, Materials & Services 53,630 60,770 62,680 400 Depreciation of Equipment 18,892 14,760 15,965 600 Special Payments 21 20 20 Total T 99,745 106,540 111,040 Total Parks Division $836,988 963;745 $1,0219620 Total Recreation & Parks Department $1,339,034 $1,507,000 $1,614,065 TOTAL GENERAL FUND Less Inter -Fund Transfers NET GENERAL FUND BUDGET LIBRARY FUND 21-801.01 Administration 13,492,493 $14,641,577 $16,163,875 $ 837,753 $ 1,042,590 $ 1,151,965 12,654,740 $13,598,987 $15,011,910 100 Personnel Services $ -0- $453,120 $471,020 200 Utility & Transportation -0- 52,960 50,000 300 Supplies, Materials & Services 640,080 157,400 172,360 600 Special Payments -0- 6,500 7,500 Total Library Fund Total 640,080 $669,980 700,880 - 35 - 640,080 $669,980 $700,880 CITY OF LODI 1987-88 OPERATING BUDGET 1985-86 1986-87 1987-88 ELECTRIC UTILITY FUND Actual Budget Budget 16-022.02 100 Electric Overhead Personnel Services $(19,108) $ -0- $ -0- Total $T-1-9 '1087 $ -0-- -0-- 16-601.01 100 Administration Personnel Services $274,933 $293,410 $325,415 200 300 Utility & Transportation Supplies, Materials & Services 29,443 161,363 22,415 259,855 30,610 225,345 400 Depreciation of Equipment 11,213 17,810 17,8065 500 Equipment, Land & Structures 283,846 270,525 243,900 600 Special Payments Total 763,039 864,015 $843,135 16-601.12 100 Engineering Personnel Services $185,588 $212,470 $252,065 200 Utility & Transportation 1,265 3,587 1,820 4,780 2,785 6,365 300 Supplies, Materials & Services 495 500 Equipment, Land & Structures -0- -0- Total 190,440 219,070 $261,710 16-601.13 100 Warehousing Personnel Services $ 44 696 $ 3,955 $ -0- 200 Utility & Transportation -0- -0- -0- 300 Supplies, Materials & Services 10,653 -0- Total 56,303 3,955 -0- 16-602.02 Customer Service Maintenance $105,287 $133,740 $120,945 100 200 Personnel Services Utility & Transportation 1,749 1,910 2,315 300 Supplies, Materials & Services 4,265 19,358 2,500 7,165 2,250 6,860 500 Equipment, Land & Structures Total 130,659 $145,315 132,370 16-603.02 Dusk -to -Dawn Lighting 161 $ 510 $ 515 100 Personnel Services $ 15 15 300 Supplies, Materials & Services -0- 300 400 500 Equipment, Land & Structures 256 Total 417 825 930 - 36 - CITY OF LODI 1987-88 OPERATING BUDGET 1985-86 1986-87 1987-88 ELECTRIC UTILITY FUND (continued) Actual Budget Budget 16-604.02 Bulk Power Purchase 200 Electricity $14,629,300 $16,705,000 $17,223,000 Total 14,629,300 $16,705,006 $17,223,00 16-604.09 Hazardous Material Handling (PCB) 100 Personnel Services 29,607 $ 35,525 $ 53,840 200 Utility & Transportation -0- 100 100 300 Supplies, Materials & Services 13,540 23,100 29,275 500 Equipment, Land & Structures 3,758 31,050 21,400 600 Special Payments -0- 400 1,200 Total T 46,905 90,175 105,815 16-604.10 System Maintenance - Overhead 100 Personnel Services $ 80,525 $107,460 $108,760 200 Utility & Transportation 493 700 3,050 300 Supplies, Materials & Services 10,249 9,750 17,230 500 Equipment, Land & Structures 22,271 19,920 20,875 Total $113,538 $137,930 $149,915 16-604.11 System Maintenance - Underground 100 Personnel Services $ 36,945 $ 642180 $ 65,015 200 Utility & Transportation -0- -0- 15 300 Supplies, Materials & Services 3,671 3,700 4,350 !� 500 Equipment, Land & Structures 6,926 8,695 8,100 Total 47,542 76,575 .77,480 16-604.12 Substation Maintenance 100 Personnel Services $ 50,807 $ 40,155 $ 39,920 200 Utility & Transportation 347 775 1,025 300 Supplies, Materials & Services 9,440 8,750 - 9,350 500 Equipment, Land & Structures 10,866 2,895 3,875 Total T 71,460 52,575 54,170 16-604.13 Systems Operation 100 Personnel Services $151,627 $147,185 $147,290 200 Utility & Transportation 3,583 3,620 3,265 300 Supplies, Materials & Services 6,106 6,375 7,575 500 Equipment, Land & Structures -0- 300 1,450 Total 161,316 $157,480 159,580 - - -37- CITY OF L001 1987-88 OPERATING BUDGET ELECTRIC UTILITY FUND (continued) Actual 16-604.14 Tree Trimming 100 Personnel Services $ 59,321 300 Supplies, Materials & Services 568 500 Equipment, Land & Structures -0- Total 59,889 1986-87 1987-88 Budget Budget $ 56,630 600 400 57,630 $ 48,205 900 -0- 49,105 Total Electric Utility Fund $16,251,700 $18,510,445 $19,057,210 Inter -Fund Transfers - Other Departments $ 692,638 $ 833,025 $ 920,940 NET ELECTRIC UTILITY FUND 16,944,338 $19,343,470 19,978,150 39 CITY OF LODI (r1987-88 OPERATING BUDGET1985-86 1986-87 1987-88 EWER UTILITY FUND Actual Budget Budget 17-401.01 Administration 100 Personnel Services $ 31,054 $ 28,805 32,475 200 Utility & Transportation 2,635 2,940 2,950 300 Supplies, Materials & Services 64,666 62,305 56,625 400 Depreciation of Equipment 21,407 24,880 15,345 600 Special Payments - 354 100 -0- Total 120 116 $119,030 T-107,395 17-402.02 Engineering 100 Personnel Services $ 1,238 $ 10,715 $ 17,215 200 Utility & Transportation -0- 200 200 300 Supplies, Materials & Services -0- 100 2,460 Total 1,238 11,015 19,875 17-403.01 Plant Maintenance 100 Personnel Services $330,394 $353,325 $390,675 200 Utility & Transportation 248,693 255,345 254,775 300 Supplies, Materials & Services 103,101 111,865 145,515 500 Equipment, Land & Structures -0- -0- 530 600 Special Payments ,3,601 2,435 3,855 Total 685,789 722,970 $795,350 17-404.01 Sanitary System Maintenance 100 Personnel Services $ 71,138 $ 92,390 $128,865 200 Utility & Transportation 4,298 4,195 4,785 300 Supplies, Materials & Services 9,409 7,645 13,815 Total 84,845 $104,230 147,465 177404.02 Industrial System Maintenance 100 Personnel Services $ 527 $ 900 $ 965 200 Utility & Transportation 2,329 2,505 2,660 300 Supplies, Materials & Services 1,517 300 300 Total 4,373 3,705 3,925 17-030.01 Bonded Debt - Interest 600 Special Payments Total $ 74,425 $ 65,495 $ 56,060 17-407.01 Plant Depreciation 400 Depreciation Total $313,785 $313,785 $314,445 Total Sewer Utility Fund 1,284,571 $1,340,230 $1,444,515 Inter -Fund Transfers - Other Departments $ 123,453 $ 99,465 $ 109,535 ■ NET SEWER UTILITY FUND $1,408,024 $1,439,695 $1,554,050 39 -w nc 1 Affil 1987-88 OPERATING BUDGET Total T 66,566 70,5 T 77,770 120-702.10 Tokav Players 100 Personnel Services $ 986 $ -0- $ 1,200 200 Utility & Transportation -0- 1,400 -0- 300 Supplies, Materials & Services 3,166 3,600 2,400 Total T 4,152 5,000 3,600 120-702.11 Lodi Arts Commission 100 Personnel 1985-86 1986-87 1987-88 COMMUNITY CENTER Actual Budget Budget 120-040.03 Administration 300 Supplies, Materials & Services 100 Personnel Services $ 54,184 $ 57,850 $ 62,265 200 Utility & Transportation 5,556 7,140 8,160 300 Supplies, Materials & Services 4,091 4,560 5,810 400 Depreciation of Equipment -0- 1,000 1,085 500 Equipment, Land & Structures 2,735 -0- 1 450 Total T 66,566 70,5 T 77,770 120-702.10 Tokav Players 100 Personnel Services $ 986 $ -0- $ 1,200 200 Utility & Transportation -0- 1,400 -0- 300 Supplies, Materials & Services 3,166 3,600 2,400 Total T 4,152 5,000 3,600 120-702.11 Lodi Arts Commission 100 Personnel Services $ 3,139 $ 3,120 $ 3,165 200 Utility & Transportation 476 740 570 300 Supplies, Materials & Services 1,164 1,960 1,380 500 Equipment, Land & Structures 102 -0- -0- 600 Special Payments 1,482 -0- -0- Total 6,363 5,820 _5,115 120-702.12 Community Band 100 Personnel Services $ 1,181 $ 1,430 $ 1,465 300 Supplies, Materials & Services 514 400 470 Total 1,695 1,830 1,935 120-702.13 Lodi Art Center 200 Utility & Transportation $ 458 $ 500 $ 650 300 Supplies, Materials & Services 1,856 2,500 2,800 Total 2,314 3,00.0 3,450 120-702.14 Youth Drama 100 Personnel Services $ 2,000 $ 2,000 $ 2,000 300 Supplies, Materials & Services 702 500 500 Total 2,702 2,500 2,500 120-704.01 Senior Citizens' Commission 100 Personnel Services $ -0- $ -0- $ 2,600 200 Utility & Transportation -0- 1,020 1,520 300 Supplies, Materials & Services -0- 10,230 2,300 Total $ -0- 11,2 T 6,420 - 41 - CITY OF LODI r19,7-.8 OPERATING BUDGET 1985-86 1986-87 1987-88 COMMUNITY CENTER (continued) Actual Budget Budget 120-752.05 Maintenance 100 Personnel Services $ 18,654 $ 25,880 $ 25,895 200 Utility & Transportation 10,454 10,660 11,505 300 Supplies, Materials & Services 4,178 4,125 6,780 500 Equipment, Land & Structures 95 -0- -0- Total 33,381 40,665 44,180 Total Community Center $117,173 $140,615 $144,970 GRAND TOTAL: OPERATING BUDGETS $32,573,448 $35,994,582 $38,246,365 - 42 - :ITY OF LODI EQUIPMENT PURCHASES 1987-88 Funding Department New Replacement Total Source Community Center Chairs 6,500 EF Chair Cart 1,400 EF Tables - Girls' Gym $ 6,000 EF Table Trucks 1,000 EF Dishwasher $ 3,300 EF Total $14,900 3,300 $18,200 Community Development Sedan $ 8,000 EF Total 8,000 8,000 Electric Utilit Air Compressor $ 800 UOR Disc Drive 3,000 UOR Hot Wire Holders 550 UOR Locker 2,500 UOR Modify Storage 21,500 UOR Radio Equipment 15,000 UOR SCADA Software 3,000 UOR Terminal 2,000 UOR 20 -Ton Crane 175,000 UOR Tools 3,700 UOR Trouble Lights 600 UOR Video Recorder 1,400 UOR Copy Machine $ 4,500 UOR Chairs (3) 900 UOR Cluster Grounds (6) 3,200 UOR Framing Jacks 600 UOR Gas Detector 2,000 UOR Hot Stick Extensions 1,500 UOR Line Truck 125,000 UOR Line Hoses 1,250 UOR Parking Stands 1,500 UOR Sedan 12,000 UOR Gas Detector 2,300 UOR Total $229,050 $154,750 $383,800 - 43 - CITY OF LODI Equipment Purchases 1987-88 Funding Department New Replacement Total Source Finance Auto $ 8,500 EF Currency Counter 3,110 EF Office Equipment 2,880 EF Printer Upgrade 2,670 EF Storage Racks 10,000 EF System Upgrade 17,065 EF Pickup Truck 1,300 $11,000 EF Total $44,225 $11,000 $55,225 Fire 2,100 EF Air System $10,000 EF Flow Meters 3,000 EF Generator 4500 V 2,100 EF Stove $ 600 EF Total $15,100 600 $15,700 Parks Coring Drains Fertilizer Spreader Top Dresser Airless Sprayer Boats Cushman (3) Motor Cycle Riding Mower Sod Cutter Station Wagon Total $ 2,000 EF 800 EF 4,500 EF $ 2,655 EF 13,000 EF 16,500 EF 1,300 EF 1,550 EF 2,100 EF 12,000 EF 7,300 $49,105 56;405 - 44 - 'iii i ��� •� t���\ Equipment Purchases 1987-88 Funding Department New Replacement Total Source Police Ballistic Vests (8) $14,400 EF Camera 2,480 EF Helmets (8) 2,400 EF Power Unit 8,685 EF Printer 5,400 EF Radio 1,800 EF Terminal 1,230 EF Sedans (2) $22,GDO EF Typewriter 800 EF Total $36,395 $22,800 $59,195 Public Works Air Compressor $12,960 EF CAD Terminal 10,200 Note 1 Concrete Saw 1,295 EF Radio Equipment 25,000 Note 3 Vibratory Roller 9,540 EF Copier $ 5,600 EF Diagnostic Analyzer 19,800 EF Distance Meter 21,700 Note 2 Pickup. Truck 14,005 EF Wacker Tamper 2,545 EF Total $58,995 $63,650. $122,645 White Slough Water Pollution Control Facility: Breathing Apparatus $ 1,700 W/W C High Pressure Washer $ 3,655 W/W C Vacuum Pump 1,440 W/W C Total 1,700 5,095 6,795 ------------------------- - Total - Equipment $407,665 $318,300 $725,965 - 45 - PI TV AC 1 Af%l / VI I 1 VI VVYI Equipment Purchases 1987-88 SUMMARY Fund Account Number Amount . E F Equipment Fund (012.0-012.01) $280,510 . S C Sewer Capital (017.1-012.01) 20,920 . W C Water Capital (018.1-012.01) 20,920 . UOR Utility Outlay Reserve (016.1-680.01) 383,800 . W/W C Wastewater Capital (017.2-012.01) 6,795 . TDA SB 325 (124-012.01) 6,510 . S D Storm Drai.ns (123.0-529.29) 6,510 TOTAL 725,965 Note 1: EF 20% WC 40% SC 40% Note 2: TDA 30% SD 30% SC 20% WC 20% Note 3: SC 50% WC 50% -46- CITY OF LODI RECOMMENDED PERSONNEL 1987-88 Authorized Recommended Net 1986-87 1987-88 Change ADMINISTRATION Administrative Assistant 1 0 -1 Administrative Assistant - City Manager 1 2 +1. Administrative Clerk I 1 1 Administrative Clerk II 1 1 Administrative Clerk III 1 1 - Assistant City Manager 1 1 City Attorney 1 1 City Clerk 1 I City Manager 1 1 Community Center Director 1 1 Legal Secretary 1 1 Secretary to the City Manager 1 1 Total 12 12 -0- COMMUNITY DEVELOPMENT. Administrative Clerk III Associate Planner - Building Inspector I Building Inspector II Chief Building Inspector Community Development Director Department Secretary Jr. Planner ELECTRIC UTILITY DEPARTMENT Assistant Utility Director Assistant Electrical Estimator Department Secretary Electrician Electric Meter Repairman Electrical Engineer Electrical Engineering Technician Electrical Estimator Line Foreman Lineman Load Dispatcher Sr. Electrical Technician Sr. Utility Rate Analyst Utility Director Utility Rate Analyst Utility Service Operator Utility Supervisor 1 1 2 2 1 1 3 3 1 1 1 i 1 1. 1 1 Total 11 11 -0- 1 1 1 1 1 1 3 3 1 1 ' 1 1 1 1 2 2 3 3 8 8 1 1 1 1 1 1 1 1 1 1 3 3 1 1 Total 31 31 -0- -47- CITY OF LODI Recommended Personnel 1 3 3 1987-88 Authorized Recommended Net 1 1986-87 1987-88 Change FINANCE DEPARTMENT. 1 1 3 Account Clerk 9 10 +1 Accountant II 1 1 Accounts Collector 2 2 Administrative Clerk II 1 1 Assistant Finance Director 1 1 Buyer/Sr. Storekeeper 1 1 Data Processing Operations Specialist 1 1 Data Processing Programmer I 0 1 +1 Data Processing Programmer II 1 1 Data Processing Supervisor 1 1 Department Secretary 1 1 Field Services Supervisor 1 1 Finance Director 1 1 Meter Reader 4 4 Parking Enforcement Assistant 2 2 Purchasing Officer 1 1 Revenue & Collection Technician 1 1 Sr. Account Clerk 2 .2 Storekeeper 1 1 Total 32 •34 +2 FIRE DEPARTMENT Administrative Clerk III Fire Administrative Officer Fire Captain Fire Chief Fire Engineer Fire Fighter Fire Inspector Fire Shift Supervisor LIBRARY Building Service Worker Childrens Librarian Librarian Librarian II Library Assistant Manager of Adult Services Sr. Library Assistant 1 1 3 3 6 6 1 1 18 18 15 15 1 1 3 3 Total 48 48 -0- 1 1 1 1 1 1 2 2 6 6 1 1 1 1 Total 13 13 -0- 11 11 -1 11 CITY OF LODI Recommended Personnel 1987-88 POLICE DEPARTMENT Administrative Clerk II Administrative Clerk III Administrative Assistant Animal Control Officer Assistant Animal Control Officer Community Services Officer Crime Analyst Department Secretary, Jailer -Dispatcher -Clerk Matron -Dispatcher -Clerk Police Chief Police Captain Police Lieutenant Police Officer Police Technician Police Sergeant PUBLIC WORKS DEPARTMENT Administration Administrative Assistant Administrative Clerk III Department Secretary Public Works Director Engineering Division Assistant City Engineer Associate Civil Engineer Chief Civil .Engineer Engineering Technician II Engineering Technician Supervisor Jr. Civil Engineer - Traffic Public Works Inspector II Authorized Recommended Net 1986-87 1987-88 Change 3 3 1 3 3 1 1 1 1 1 4 -0- 1 1 2 3 4 +1 1 1 3 1 1 1 4 5 +1 6 7 +1 1 1 3 3 4 4 43 46 +3 1 1 8 8 Total 84 . 90 +6 - 49 - 1 1 1 1 1 1 1 1 4 4 -0- 1 1 2 2 1 1 4 4 3 3 1 1 2 2 14 14 -0- CITY OF LODI Recommended Personnel 1987-88 PUBLIC WORKS DEPARTMENT (continued) Building and Equipment Maintenance Building & Equipment Maintenance Superintendent Building Maintenance Worker Equipment Mechanic Supervisor Equipment Service Worker Heavy Equipment Mechanic Sr. Building Maintenance Worker Welder -.Mechanic Street Division Administrative Clerk III Laborer Sr. Tree Trimmer Street Maintenance Worker II Street Maintenance Worker III Street Supervisor Street Superintendent Street Sweeper Operator Tree Trimmer Water and Sewer Division Laborer Laboratory Technician II Plant & Equipment Mechanic Sr. Laboratory Technician Wastewater Plant Operator II Wastewater Treatment Supervisor Water/Wastewater Inspector Vater/Wastewater Worker II Water/Wastewater Worker III Water/Wastewater Supervisor Water/Wastewater Superintendent Total Public Works Authorized Authorized Net 1986-87 1987-88 Change 1 1 1 1 1 1 1 1 3 3 1 1 1 1 . 9 9 -0- 1 1 2 3 +1 1 1 9 9 5 5 2 3 +1 1 1 +1 1 1 2 2 IWIZ 24 26 +2 1 1 2 2 3 3 1 1 5 5 1 1 0 1 +1 5 5 4 4 2 3 +1 1 1 25 27 +2 76 80 +4 J IJ fl I J, u Ll 11 CITY OF LODI Recommended Personnel 1987-88 RECREATION AND PARKS DEPARTMENT Administrative Clerk II Department Secretary Gardener Laborer Light Equipment Mechanic Park Maintenance Worker II Park Maintenance Worker III Park Ranger Park Supervisor Park Superintendent Recreation Supervisor Recreation Superintendent Recreation & Parks Director Sr. Building Maintenance Worker Authorized 1986-87 Recommended Net 1987-88 Change 1 1 I 1 0 1 +1 2 2 I 1 11 11 4 4 1 1 1 1 I 1 2 2 1 I 1 1 1 1 Total 28 29 +1 TOTAL RECOMMENDED PERSONNEL 335 - 51 - 348 +13 CITY OF LODI ELECTRIC UTILITY OUTLAY BUDGET 1987-88 1985-86 1986-87 1987-88 Actual Budget Budget 16.1-650.01 System Expansion 100 Personnel Services $ 4,137 $ 8,925 $ 8,065 300 Supplies, Materials & Services -0- 300 225 500 Equipment, Land & Structures 6,112 12,300 .9,800 Total 10,249 21,5 T 18,090 16.1-650.02 System Improvement 100 100 Personnel Services $ 43,160 $100,410 $112,390 300 Supplies, Materials & Services 489 1,700 2,350 500 Equipment, Land & Structures 104,071 213,500 187,100 $643,795 Total $147,720 $315,610 301,840 16.1-650.03 Service Connections (Customer) 100 Personnel Services $ 24,011 $ 33,255 $ 33,265 300 Supplies, Materials & Services 210 625 625 500 Equipment, Land & Structures 54,423 49,000 49,000 Total T 78,644 82,880 82,890 16.1-650.04 Lighting Construction (Dusk -to --Dawn) 100 Personnel Services 712 $ 1,870 $ 1,875 300 Supplies, Materials & Services -0- 30 30 500 Equipment, Land & Structures 706 1,050 1,050 Total ' 1,418 2,950 T 2,955 16.1-650.11 New Business 100 Personnel Services $ 8,933 $ 24,440 $ 24,445 300 Supplies, Materials & Services 15 200 635 500 Equipment, Land & Structures 26,426 26,100 26,100 Total T 35,374 50,7 T 51,180 16.1-650.23 Substation Construction 100 Personnel Services $ 19,790 $ 17,305 $ 24,345 300 Supplies, Materials & Services 4,026 1,120 .1,150 500 Equipment, Land.& Structures 46,710 26,400 618,300 Total 70,526 44,8 $643,795 - 53 - CITY OF LODI 1987-88 OPERATING BUDGET 1986-87 1987-88 Budget Budget $ -0- $ 39,605 -0- 1,000 -0- 138,000 $ 178,605 $ -0- $ -0- 52,750 383,800 52,7 $383,800 Total Electric Utility Outlay Budget $425,010 $F71,280 1,663,155 - 54 - 1985-86 ELECTRIC UTILITY OUTLAY BUDGET (continued) Actual 16.1-655.06 Lodi Avenue -Underground 100 Personnel Services $ -0- 300 Supplies, Materials & Services -0- 500 Equipment, Land & Structures -0- Total T _-O- 0-16.1-680.01 16.1-680.01 System Equipment Purchases 300 Supplies, Materials & Services $ 21,140 500 Equipment, Land & Structures 59,939 Total T 81,079 1986-87 1987-88 Budget Budget $ -0- $ 39,605 -0- 1,000 -0- 138,000 $ 178,605 $ -0- $ -0- 52,750 383,800 52,7 $383,800 Total Electric Utility Outlay Budget $425,010 $F71,280 1,663,155 - 54 - I-- 4P C:) V1 t0 al O V N ON t7l �1 al to •ITV AC 1 /11'.1 m --i 1 -1 w --i N (n N (n S o c'm A r O O C a1 'S t< C C< << 0) C O O o. m C+ O C+ •--' 1-1 (D N CT N to N N N to O C) Cv C+ (D 7r U'1 (D C+ N C+ C+ S CU T1 C+ C -A-' S i W Y ID fD C+ fD (D Cu 'S 1 0 0 0 N -A W 1--A W V N N O r 1--I co o -z -n O C S c+ 01 O O (D (D !n AC7 a-0 C i p' -+•OJ•C 303—C 1 -5 -S C+ -G Cl (D O = (D I s -p O = cu < w J. to O -•1• -S C (all (D o. •S -1 B (D = m J. (D J. =3 Cu CA = CL W -4 (D CL 'v O J• -1 (D O Z O to 3 :E (D to c+ C 1- 4 C+ C+ CU --q -0 C+ CU 3 -s C+ =' C+ Cv o i J• O r -�• -S S C Cu to c+ Cv to (D (D (D � c+ < O o ► y 00 C +sv -s ►-' J. J. 'S = C) = -0 CD r J. m --1 to a n t0 o = o 0) a Iv c� -S -.0 -� -< V (D N S V o C+ C O O CO J•Co (D to al = -Il 0) N N (D =3 0 0 —a) =' V to Ul c+ (D N V O C1 (D (D C+ 0 00 V 00 Cn O to O o o ul to o u,cl O to O o o to Ul O O o (n 3 A n to V 3 C m 1 1 W Cu -p 1 1 1 1 1 1 I I I Y rl I.J co rn r- 0) In rn Ul C-) N W A al al A W al O Ul N to N W I--1 00 ('i N 1-+ 0:) v kO Ul 00 W O N Ul O C+'a I i 1•-+ V V Y V V V V V CO lfl I 10 N N 1.0 O V 00 In kO 0 41 t.0 V -P 00 1--1 Oo v O 0.0 N I.- of -P, F-1 -A 01 1-+ O O Ln --j O �i (=)I (nO Oul O O cnUlMLn Eft• EA 64 W V O N O 0) a1 a1 1 V V a, 1--1 1-1 tT C) CTI Eft• EA 64 W W O t0 O 00 a1 N rn V o V a, v 1-1 cn C) d-1. N .1`a V1 O O N O V •P O 4A N V al F-+ W 0 Cil I 1 F--1 V 00 al (n iA a1 w 41 cT. Ln N •P Ul V 0 O C.0 N O V 10 T O 1-+ C0 . Y t0 V 00 V 1-1 L71 0 {f) \ O -o t0 N m V N N A d-1. O U'1 { N F•-1 W Y ID W N -A W 1--A W V N N O w W V 0 O V 1 O I NCD O I••-1 I W V al 0 I.-1 CT N 1 -1 V1 O I.- 00 I-+ o Ol CTI Ul Ul O O (.Jl (n O C) cn V F-1 1 Z I-+ <. to W O 0 O N N 00 1-+ IJ ►-' F-+ N 00 N N V to .A V t0 N 0) Ul I I V V V V V V V V to al to to w w N N N W W V to Ul O V CTI Ul W V F--1 Ln al -P. 0 00 V 00 Cn O to O o o ul to o u,cl O to O o o (n Ul O O o (n 3 A V 3 C V 1 1 W Cu -p 1 1 1 1 1 1 I I I Y O s J. co rn r- 0) In rn Ul C-) to 6H 00 ('i N Na O C+'a W 00 O 1•-+ al 1 1 O (D I 1 P -P 00 1--1 Oo •IP -P 00 -A to Ln --j O �i Cl O al C.O ul o to o Ul o O o cn - 55 - \ O -o t0 N m N N A d-1. O U'1 z F•-1 W Y ID V W V V A O 0 O O O O --i N O O - 55 - \ O -o t0 m N A 6�4 O .- z C7 Y ID W C A 0 0 O --i N (D 44 'S J. CD F--1 Ln N V F-1 1 Z I-+ <. to OJ•O O 0 O t0 N 00 1-+ IJ ►-' F-+ N 00 N N W {b Ul Ul V .p O W al 4P C) W .p 1.0 C0 -P V C0 to N 1-1 W V C,0 Y O V N V V V V 1•-1 Ln N 4�-- V to V 00 V V V t,0 W -4 1-+ -P O 1-+ 0 00 V 00 1-+ I--1 . W V I -f W O O O to O o o (n Ul O O o (n - 55 - al Cu N O tG "a O a (D (D n J. -I V of -n O=cc+ O N = (D CD 'i to \ O -o m A .- z C7 W C 0 0 m --i N (D 'S J. CD Ln N (D CD 1 Z I-+ <. to OJ•O O 0 O (D O N (D J t. i C+ N CV -+•. C) C+ -+ O J. to J• 0"a C+ O J. N cam+ N A+ C ( 20 3 A N 3 C W Cu -p O Q T O (D -J s J. m J• (D r- 0) In m C-) 00 ('i -P Cv CCD O C+'a I C O �. -S 00 -1 O (D 00 1 -I 1 -I N W c+ r m c -s a -C o v,C�C o CD 0 0. -1. m O Cl. -O -1 C Cu a (n CD o. I CA C+ al Cu N O tG "a O a (D (D n J. -I V of -n O=cc+ O N = (D CD 'i to CITY OF L001 cis H H N1.11, V V V O I O H 0) 01 W N H O (n- W W N Cn N Cn O O m O Ln O Cn tG O C ((DD (ND cG t< N Q. Q• :E (a -S N N C+ W N p =r < C+ C+ 00 t0 1 cn V W -P V 00 V N � O t0 A a c -P 0 a t0 0) O < c+ N O (D cn O (n , m (D J. J. tp Ln f --i m O -0 O o O O n :=I x O O c O (D n O -0 -O J. (D N O =3 i 11 O n N O O O O' C O N (D < N J• O L3 N i C+- =j O C+ (D C+ C J• (D O 1 'S 0 O O c C+ O -S 0 'S O C+ O � � o n sv CL .. a N p N (D C c+ N N O 1 (D C+ i O N 1 N v (D sv -1 � cD• � N cis H H N1.11, V V V O I O H 0) 01 W N H O (n- W W N Cn N Cn O O m O Ln O Cn N W H Ol 1-' 0*1 W W tp p p H W N 00 t0 1 cn V W -P V 00 V N V W O t0 W O -P -P V 0) t0 0) O 00 Cn to to cn cn O (n , cis H H N1.11, V V V O I O H 0) 01 W N H O (n- W W N Cn N Cn O O m O Ln O Cn H H W H Ol w 0*1 .jam W H Ol H N N H 00 00 w V V Y V V W W 00 00 0) H to X700 l0 H 00 V O V W V H V O V O V H V 00 Cn O O O O Ln O O O O O O O O O O O O H 01 W H Ol w 0*1 W W 00 W H N N 00 V V V Y V V H 00 m V H t0 OO OO O 110 O o 0 to o COn Ul o M - 56 - O -OS N O J 0 C7 O (D (D N 3 s` (v T7 W C+ 0) O (D = —� O 'S CL J. J. (D 0) N N O D r N c 3 3 D O 'n m r m Hni c H V n 1 00C 00 —I H r CITY OF LODI SCHEDULE K DENTAL INSURANCE AND LONG-TERM DISABILITY INSURANCE RESERVE STATEMENT OF RESOURCES AND REQUIREMENTS 1987-88 ESTIMATED FINANCING RESOURCES INTERFUND TRANSFERS Dental Cost Allocations $ 80,090 Long -Term Disability Cost Allocations 81,130 Employees' Contribution 35,775 Total $196,995 CONTRIBUTIONS FROM OTHER FUNDS & RESERVES Employee Benefits Fund Balance $ 3,785 Total $ . 3,785 TOTAL ESTIMATED FINANCING RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Dental Claims $107,635 Dental Claims Administration 20,520 Long -Term Disability Claims 11,000 Long -Term Disability Insurance 61,625 Total TOTAL ESTIMATED REQUIREMENTS Wvm $200,780 $200,780 $200,780 CITY OF LODI PUBLIC LIABILITY INSURANCE RESERVE STATEMENT OF RESOURCES AND REQUIREMENTS 1987-88 ESTIMATED FINANCING RESOURCES INVESTMENT INCOME CONTRIBUTIONS FROM OTHER FUNDS TOTAL ESTIMATED RESOURCES ESTIMATED REQUIREMENTS OPERATING EXPENSES Professional Services Insurance Premiums Claims Travel Materials & Supplies Total INCREASE FUND BALANCE TOTAL ESTIMATED REQUIREMENTS $ 31,265 $285,600 $ 15,745 200,000, 69,055 600 200 $285,600 $ 31,265 $316,865 $316,865 SCHEDULE L CITY OF LODI WORKERS' COMPENSATION INSURANCE RESERVE STATEMENT OF RESOURCES AND REQUIREMENTS 1987-88 ESTIMATED FINANCING RESOURCES COMPENSATION REIMBURSEMENTS $ 20,000 INTER -FUND TRANSFERS $296,980 INVESTMENT EARNINGS $ 45,800 CONTRIBUTIONS FROM OTHER FUNDS $ 40,080 TOTAL ESTIMATED FINANCING RESOURCES $402,860 ESTIMATED REQUIREMENTS OPERATING EXPENSES Premiums - Excess Insurance Disability Payments Medical Services Professional Services Safety Program Travel Materials & Supplies Physical Fitness Programs & Medical Exams Total CONTRIBUTIONS TO OTHER FUNDS Workers' Compensation Operating Reserve Total TOTAL ESTIMATED REQUIREMENTS - 59 - $ 25,000 105,000 174,260 75,000 5,440 600 5,900 11,100 $ 560 $402,800 $ 560 $402,860 SCHEDULE M CITY OF NODI SELF-INSURANCE FUNDS 1987-88 1985-86 1986-87 1987-88 Actual Budget Budget 29-020.02 Dental Insurance 100 Personnel Services $ 93,885 $ 94,655 $107,635 300 Supplies, Materials &-Services 17,835 17,985 20,520 Total 111,720 $112,640 128,155 29-020.03 Lonq-Term Disabilit 100 Personnel Services $ 57,000 $ 57,000 $ 61,625 300 Supplies, Materials & Services 5,245 6,000 11,000 Total 62,245 63,000 72,625 Total Dental & Long -Term Disability Fund Total PUBLIC LIABILITY FUND 30-020.02 PL & PD Insurance 200 Utility & Transportation 300 Supplies, Materials & Services Total 173,965 $175,640 $200,780 $ 495 462,105 462,600 $ 1,000 281,880 $282,8 $ 600 285,000 285,600 Total Public Liability Insurance Fund T462j6OO $282,880 $285,600 Less Inter -Fund Transfers Net Public Liability Insurance Fund WORKERS' COMPENSATION INSURANCE FUND $ 87,800 $ 53,750 $ 54,265 374,800 229,130 $234,180 31-020.02 Workers' Compensation Insurance 100 Personnel Services $194,575 $139,320 $130,000 200 Utility & Transportation 145 625 600 300 Supplies, Materials & Services 233,310 233,700 271,700 Total 428,030 373,645 402,300 Total Workers' Compensation Fund $428,030 373,645 402,300 - 61 - CITY OF LODI .WASTEWATER CAPITAL OUTLAY STATEMENT OF RESOURCES AND REQUIREMENTS 1987-88 ESTIMATED FINANCING INTER -FUND TRANSFER Depreciation Funds: Plant and Equipment Total TOTAL ESTIMATED FINANCING ESTIMATED REQUIREMENTS WASTEWATER EQUIPMENT Breathing Apparatus High Pressure Washer Vacuum Pump Total $314,445 $314,445 $ 1,700 3,655 1,440 $ 8,675 BOND PRINCIPAL $225,195 WASTEWATER CAPITAL RESERVE $ 80,575 TOTAL ESTIMATED REQUIREMENTS $314,445 SCHEDULE N $314,445 - 63 - CITY OF LODI FEDERAL REVENUE SHARING STATEMENT OF RESOURCES AND ALLOCATIONS 1987-88 ESTIMATED FINANCING RESOURCES INVESTMENT EARNINGS $83,150, TOTAL ESTIMATED FINANCING RESOURCES CAPITAL PROJECTS — CITY HALL EXPANSION TOTAL ALLOCATIONS 19s� $ 83,150 $__839150 SCHEDULE 0