Loading...
HomeMy WebLinkAbout1996-03-19 City Council (7)City City of Palo Alto Manager’s Report TO:HONORABLE CITY COUNCIL ATTENTION: FINANCE COMMITTEE FROM:CITY MANAGER DEPARTMENT: ADMINISTRATIVE SERVICES AGENDA DATE: MARCH 19, 1996 CMR:177:96 SUBJECT:1995-96 MIDYEAR FINANCIAL SUMMARY AND BUDGET AMENDMENT ORDINANCE REQUEST: This report transmits six-month results of operations for the 1995-96 fiscal year, for the General Fund and Utilities Funds, and provides updated revenue, expenditure and reserve balance projections. RECOMMENDATIONS: Staffrecommends the City Council adopt the attached Budget Amendment Ordinance, which reflects midyear adjustments to the 1995-96 budgets. POLICY IMPLICATIONS: Adoption of the year-end closing ordinance does not represent a change to existing policies. EXECUTIVE SUMMARY: This report summarizes the financial results for the first six months of fiscal year 1995-96, and updates budget projections for the full fiscal year, with pro forma reserve balances for the General Fund and the Utilities Funds. Also included in this report is a Budget Amendment Ordinance reflecting the associated budget adjustments being requested. The report also includes a schedule of selected Capital Improvement Program expenditures through December 1995. CMR:177:96 Page 1 of 2 FISCAL IMPACT: Adoption of the attached ordinance will allow for certain adjustmems to the fiscal year 1995- 96 budget based on updated projections. ENVIRONMENTAL ASSESSMENT: Adjustments to the fiscal year budget Environmental Quality Act. is not a project for purposes of the California ATTACHMENTS: 1995-96 Midyear Financial Results Budget Amendment Ordinance PREPARED BY:Virginia Harrington, Budget Manager Tony Sandhu, Senior Accountant DEPARTMENT HEAD APPROVAL: Harrison Deputy City Manager, Administrative Services CITY MANAGER APPROVAL: CC: n/a CMR:177:96 Page 2 of 2 1995-96 54 YEAR FINANCIAL RES ,TS EXECUTIVE SUMMARY General Fund The 1995-96 General Fund Adopted Budget included a draw from General Fund Reserves of $. 13 million. Based on financial perfor- mance during the first six months of the fiscal year, the General Fund is anticipated to close the fiscal year with a net operating surplus of $1.8 million. This surplus is primarily due to a substantial increase in sales tax receipts, which is discussed below. Somewhat offsetting the increase in sales tax receipts is a projected shortfall in telephone utility users tax reve- nues, resulting from increased competition among carriers and lower long distance rates. Expenditures in the General Fund are in line with the adopted budget. General Fund Financial Highlights Revenues Adopted Adjusted Projected Difference Actual Budget Budget Budget from 1994-95 1995-96 1995-96 1995-96 Adjusted Budget Taxes $36,008 Service Fees and Permits $7,955 Other Revenues $21,546 Transfers from Other Funds $10,559 Total Revenues $76,068 Plus Encumbrances and Reappropriations Total Revenues! Sources Funds Expenditures Salaries and Benefits All Other Expenses Capital Expenditures Debt Service Total Expenditures NET TO (FROM) RESERVES $36,444 $36,444 $38,221 $1,777 $8,204 $8,204 $8,083 ($121) $23,157 $23,172 $23,247 . $75 $11,749 $11,749 $11,749 $0 $79,554 $79,569 $81,300 $1,731 $3,014 $3,014 $76,068 $79,554 $82,583 $84,314 $1,731 $47,883 $49,953 $50,595 $50,665 $70 $20,918 $24,057 $26,069 $25,702 ($367) $4,742 $4,836 $5,613 $5,613 $0 $944 $835 $836 $546 ($290) $74,487 $79,681 $83,113 $82,526 ($587) $1,581 ($127) ($530) $1,788 $2,318 Utility Funds The Electric Fund’s power purchase costs are significantly below budget as a result of a rate decrease by the City’s main supplier - Western Area Power Adminisn’ation (WAPA) and the availability of low-cost power on the spot market. Gas sales have decreased markedly due to abnormally warm weather this winter. The City’s wholesale purchase costs for natural gas are below the Adopted Budget as a result of lower consumption and a soft spot gas market. These events will cause the Gas Fund Rate Stabilization (RSR) to exceed its maximum limit by year end. A rate reduction may be pro- posed in the 1996-98 budget. The Refuse Fund’s revenue lagged behind original projections as residents and industries continued to reduce their refuse and recycle more. The Refuse Fund RSR is projected to end the fiscal year at $2.8 million. Given the 1995-96 projected refuse reserve balance, and projected 1996-97 increases in SMART Station costs, along with the proposed acquisition of the Los Altos Treatment Plant Site, a proposed rate increase for the Refuse Fund in 1996-97 will be forthcoming. The Wastewater Collection Fund is also antici- pated to exceed its maximum RSR balance due to increased revenues and savings in operating expenditures. A rate reduction may be recom- mended for Wastewater Collection in the 1996-98 budget. The Water Fund shows a modest increase in purchases to reflect higher-than-projected water consumption, due to dry.weather in the second quarter of this fiscal year. Actual revenues and expenditures in the Storm Drainage Fund appear to be on target and no adjustments are proposed at this time. GENERAL FUND REVENUES related travel. City of Palo Alto Sales Tax from Five Largest Business $ Mllion 2.5~ 3Q 934Q 1Q 942Q 3Q 4Q 951Q 20. 30. Sales Tax. Receipts are anticipated to total $16.7 million for the fiscal year, $1.6 million above budget. The economic segments causing this sharp increase in projected revenues are: business services, new auto sales, light indus- try, department stores, restaurants, and furni- ture/appliance. The electronic equipment segment continues to be volatile, moderating overall sales tax gains. Preliminary estimates for next fiscal year indicate a growth rate of about 3.5 percent in sales tax revenue. Property Tax. Based on preliminary informa- tion from the County, property taxes are expected to come in $.07 million above bud- get. The County is projecting an estimated 2.5 percent increase in assessed valuations on secured properties compared to prior year val- uations. This represents a.5 percent increase over the 2.0 percent growth projected in the 1995-96 Adopted Budget. Transient Occupancy Tax. Revenues from the City’s hotel tax are projected to be $.16 million above budget. This increase is fueled by an increase in room rates and a rise in occu- pied room days. In general, the hotel industry has been experiencing an increase in business Telephone Utility Users Tax. By the end of 1995-96, it is projected that telephone utility user tax revenues will fall approximately $.27 million below budget. Revenues from major telephone companies have fallen Significantly compared to the past year. Revenues from the four major companies fell an average $27,000 per month in comparing receipts from July through December 1994-95 to the same period in 1995-96. Company spokepersons confirm weak telephone UUT revenues result from increased competition and lower rates for long distance calls. Other Taxes, Fines and Penalties. Revenue in this category is expected to increase by a net $.05 million by the end of 1995’96. While doc- umentary transfer tax and motor vehicle tax receipts are expected to increase by $.08 mil- lion and $. 10 million, respectively, parking fines are projected to decrease by $. 12 million. Lower mortgage interest rates appear to have stimulated the increase in the documentary transfer tax, while the increase in motor vehi- cle tax receipts reflects a higher sales volume (local and statewide) of new autos. The decrease in parking fine revenue principally results from heightened compliance with the downtown color zone parking ordinance insti- tuted last year. Gas Tax. City gas tax receipts are expected to exceed budget by $. 1 million. With an improved state economy and resulting increases in travel, gas taxes have increased over 1994-95 activity. GENERAL FUND EXPENDITURES Actual year-end expenditures for 1995-96 are projected to be in line with the 1995-96 Adjusted Budget. Consistent with prior years, General Fund departments are expected to show savings in expenditures of approximately $.5 million. These savings will vary by depart- ment .and are therefore not included in the attached Budget Amendment Ordinance, which does reflect other mid-year budget changes. The estimated savings, however, are shown in the General Fund Summary and in the General Fund Reserves schedule below in order to accurately reflect the status of the Gen+ral Fund. Specific issues related to Gen- eral Fund expenditures are discussed below. General Fund Reserves ($ Millions) Actual Adj. Budget Mid Yr.Inc. From 94195 95/96 Proj. Budget Adjusted Reserves 95196 Budget Budget $13.9 Stabilization $13.4 $15.5 $2.1 Streets/.9 .7 ,4 ($.3) Sidewalks Emergencies 5.0 5.0 5.0 Reapp. &4.5 4.5 4.5 Encumb. Inventory &1,7 1.9 1.9 Notes Rec. Total Reserves $26.0 $25.5 $27.3 $1.8 Community Services Department Expenses. Additional salaries of $50,000 need to be added to the Community Service Department budget due to the temporary assignment of an employee in the Police Department to the Community Services Department. This employee is performing project work. In June of 1995, after the 1995-96 Budget was forwarded to Council for approval, Commu- nity Services received a donation from the Palo Alto University Rotary Club for $20,000 to fund the continued operation of the "The Outlet," an after-school program conducted at Jordan and J.L. Stanford Middle Schools. "The Outlet" is an alternative program targeted for students who might not participate in the City’s "Middle School Athletics" program, student.government or other traditional school activities. Fire Department Bad Debt. Fire Depart- ment paramedic bad debt needs to be increased by $38,000 due to higher than anticipated write-offs in the first half of the year. This trend is expected to continue for the remainder of the fiscal year. Police Department Overtime. The Police Department has experienced considerable overtime expense in the first six months of the fiscal year. There are three primary reasons for overtime exceeding budget: vacancies in Com- munications and the need for a minimum num- ber of dispatchers on each shift required additional overtime; secondly, officers on dis- ability in the Field Services area necessitated backfilling with overtime to meet minimum staffing requirements and finally, the recent serial rapist investigation required additional overtime to enhance existing patrol levels and support investigation activities. No adjustment in the Police Department salary budget for 1995-96 is being proposed, how- ever. It is anticipated that the department will have regular salary savings due to vacancies. Under the guidelines of Mission Driven Bud- geting, the department cannot exceed salaries and benefits as a whole. Should the department exceed their salary and benefits budget at year end, an adjustment will be included in the 1995-96 Year End Report. Public Works Contract Expenses. An addi- tional line clearing expense of $75,000 is required due to last winter’s heavy rains which accelerated tree growth. The contract for line clearing is in the Public Works Department Budget and is fully reimbursed by the Electric Fund. Based on final accepted bids for contract work on City medians, parking lots and other facili- ties, contract expenses need to be increased by $19,515. This increase allows for maintenance of current service levels. Firefighters Union Negotiated Salary Changes. For 1995-96, the International Asso- ciation of Firefighters, Local 1319, negotiated to pay their own employee contribution to the Public Employees Retirement System (PERS), and to have their salary base increased corre- spondingly. To appropriately adjust the sala- ries and benefits for the Fire Department to reflect the change in the payment to PERS, retirement expenses in the Employee Benefits Fund and charges to departments from the fund need to be adjusted and salaries will be simultaneously increased. This adjustment does not impact the General Fund Budget Sta- bilization Reserve. Debt Service. Operating transfers from the General Fund need to be adjusted downward by $.3 million to recognize funds remaining with the trustee when Civic Center Improve- ments are completed. These funds were used to pay the debt service in September 1995 and will be used to pay part of the March 1996 payment. UTILITY FUNDS Interest income in individual Utility Funds will vary from original projections. Although the actual yield on pooled investments is only slightly less than forecast, operating variances and delays in capital spending have caused variances from budgeted interest income. Electric Fund Year-to-date Electric Fund revenues are within 1 percent of budget. However, power purchase costs are significantly below budget ($4.0 mil- lion) for the first half of the fiscal year. Based on power purchase costs for the first six months, it is appropriate to reduce the power purchase budget by $8.3 million. A number of factors contributed to this favorable variance: a reduction in WAPA’s rates; receipt of higher- than-projected credits from WAPA for prior years’ payments; and the City’s ability to obtain less costly resources (mainly cheaper hydro power from the Pacific Northwest). The budget for salaries in the Electric Distribu- tion System Operation need to be increased due to a misallocation of salaries between the operating and capital budgets and increased workload in Electric Operations overtime costs resulting from power restoration in Palo Alto and neighboring communities following December’s heavy storms. Due to lower power purchase costs, the Elec- tric Fund’s RSR is projected to be $29.4 mil- lion by year-end, $3.6 million above the Council-approved maximum level. The pro- posed 1996-98 budget will include a request to transfer significant funds from the RSR to the Calaveras Reserve. This allows the Electric Utility to be prepared to compete in a deregu- lated environment and will bring the RSR within the target range. This recommendation will be discussed in greater detail when Council meets as a Committee-of-the-Whole in April to discuss budget issues. Utility Fund Reserves 0 Gas Fund Unseasonably warm weather adversely affected gas sales in the second quarter. Year- to-date sales are $.8 million, or 10 percent, lower than originally forecasted. The warm weather is expected to continue for the remain- ing winter months, resulting in an additional decrease in gas sales. To reflect the year-to- date and projected negative sales variances, a decrease of $1.5 million to the Gas Fund sales budget is needed. Gas purchase costs are 33 percent below bud- get to-date. The demand for gas has decreased with the warm weather. In addition to lower- than-projected commodity purchases, an ongo- ing softness in the natural gas market has resulted in significantly lower prices. The City has negotiated a new contract with its current supplier, Suncor of Canada, which will pro- vide favorable gas prices for the remainder of this fiscal year. Given these factors, the budget for gas purchases should be decreased by $2.6 million. Finally, additional funding of $70,000 is needed in the Gas System Extension Capital Improvement Project to cover cost due to an increase in the volume of new gas service installations. As most of these costs are reim- bursed by the customers, an amendment of $70,000 to the revenues is also recommended to offset ~e additional funding. The Gas Fund RSR balance is projected to be $12.5 million at year end. Since the forecasted RSR balance exceeds the maximum guideline level of $7.6 million, a recommendation for a rate reduction will be included in the proposed 1996-98 budget. Refuse Fund Customer revenues in the Refuse Fund con- tinue to lag behind budgeted targets by 5 per- cent. Palo Alto residents and businesses have been recycling diligently, resulting in a decrease in trash disposed and a lower demand for refuse collection services. As a result, a decrease in budgeted Refuse revenues of $1.0 million is needed. On the expenditure side, the disposal fee paid to PASCO, which is based on actual customer revenues, reflects the sagging demand for refuse services and, at the midyear, is $.01 mil- lion below budget. Even though this translates into a potential savings in expenses, no budget adjustment is prudent at this time because this is a cost that will increase if there is an upswing in Refuse revenues. The year-end Refuse Fund RSR balance is pro- jected at $2.8 million, which is close to Coun- cil’s approved target. With the proposed 1996- 98 budget, an increase in Refuse rates will be needed to fund proposed improvements at the former Los Altos Treatment Plant site and pro- jected increases in SMART Station expenses. Storm Drainage Fund Year-to-date Storm Drainage Fund revenues and expenditures are within 1 percent of bud- get. The increase in the Storm Drainage fee, planned for the 1996-98 budget to fund the bond financing for the next phase of storm sys- tem improvements, will be delayed to 1998- 99. The delay will allow staff to concentrate on completing the 1995 bond-funded projects within the required time frame, thereby avoid- ing arbitrage penalties. In addition, this will allow Council time to review the results of the Storm Drainage punic outreach program. Based on staffs cash flow analysis, the Fund is expected to maintain a positive balance until the next rate increase. Wastewater Collection Fund Revenues in the Wastewater Collection Fund are anticipated to be $.5 million higher than originally budgeted. This is partially due to higher groundwater discharges fees ($.3 mil- lion) because of an increase in the volume of groundwater discharged by local industries. In addition higher-than-projected earnings on the Fund’s investments ($.2 million) are forecast. Savings for contract services of $57,000 are expected due to lower contract costs for emer- gency sewer repairs. The projected year-end RSR balance of $8.1 million will exceed the Council approved max- imum guidelines. The 1996-98 Proposed Bud- get may include a reduction in Wastewater Collection rates. "Subtotal: Administration" and $972,00 for "Total Use of Funds" under the "Column adopted budget 1995-96." Wastewater Treatment Fund Both revenues and expenditures are extremely close to their respective budgets in the first six months of the fiscal year. No adjustments to the budget are required at this time. The Wastewater Treatment’s RSR is projected to remain within approved levels. Water Fund Abnormally dry weather in the second quarter of the fiscal year has contributed to sales that are 3 percent above target. The higher water sales are .partially offset by increased water purchase costs. Actual water consumption in the first six months of the year was 6 percent higher than forecast. Increased consummation requires additional purchases of water. Revenues from new service connection activi- ties were 65 percent above the adopted budget. As a result, an increase of $55,000 to the Capi- tal Improvement Project "Water System Extensions" (Project Number 8013) is required to cover the costs of replacing greater than anticipated numbers of large, obsolete water meters. OTHER ADJUSTMENTS TO THE BUDGET The CDBG fired summary on page 446 of Volume I of the 1995-96 Adopted Budget should be corrected to show $194,000 for ORDINANCE NO. ORDINANCE OF THE COUNCIL OF THE CITY OF PALO ALTO AMENDING THE BUDGET FOR THE FISCAL YEAR 1995-96 TO ADJUST BUDGETED REVENUESAND EXPENDITURES IN ACCORDANCE WITH THE RECOMMENDATIONS IN THE MIDYEAR REPORT WHEREAS, pursuant to the provisions of Section 12 of Article III of the Charter of the City of Palo Alto, the Council on June 19, 1995 did adopt a budget for fisca! year 1995-96; and WHEREAS, after reviewing the current budgeted revenues and expenditures for fiscal year 1995-96, adjustments to the budget are recommended to more accurately reflect year-end projections; and NOW, THEREFORE, the Council of the City of Palo Alto does ORDAIN as fol!ows: $.~CTION i. The sum of One Million Five Hundred Fifty Three Thousand Four Hundred Eighty Five Dollars ($1,553,485) is hereby added to the Budget Stabilization Reserve (BSR) in the General Fund to reflect all revenue and expenditure changes as described in Exhibit "A", which is attached to this ordinance and incorporated herein by this reference. As a result of these changes, the BSR will increase from $13,420,700 to $14,973,700 as of February 29,1996. $..ECTION 2. The sum of Two Hundred Sixty Five Thousand Dollars ($265,000) is hereby reduced from the Streets and Sidewalks Reserve in the General Fund to reflect revenue change as displayed in Exhibit ~A". As a result of this change, the Streets and Sidewalks Reserve will decrease from $706,234 to $441,234 as of February 29,1996. SECTION 3 The sum of One Hundred Thousand Dollars ($i00,000) is hereby added to the budgeted revenue in the Street Improvement Fund as a result of increased gas tax monies from the State, and the fund balance is correspondingly increased as described in Exhibit SECTION 4. The budgeted Operating ~Transfers In in the Debt Service Fund are hereby reduced by the sum of Two Hundred Ninety Thousand Dollars ($290,000), and the fund balance is correspondingly reduced. SECTION 5. The sum of Five Hundred Sixty Thousand Dollars ($560,000) is hereby deleted from the budgeted Emp!oyee Benefits revenue account, and the budgeted Retirement expense account is correspondingly reduced. SECTION 6. The sum of Seven Million Fifty Thousand Dollars ($7,050,000)is hereby added to the budgeted Rate Stabilization Reserve in the Electric Fund to reflect all changes as described in Exhibit "B, attached hereto and incorporated herein by reference. SECTION 7. The sum of One Million Three Hundred Forty Seven Thousand Dollars ($1,347,000) is hereby added to the budgeted Rate Stabilization Reserve in the Gas Fund to reflect all changes as described in Exhibit ~B". SECTION 8. The sum of Nine Hundred Five Thousand Dollars ($905,000) is hereby deleted from the budgeted Rate Stabilization Reserve in the Refuse Fund to reflect all changes as described in Exhibit ~B". SECTION 9. The sum of Five Hundred Thirty Two Thousand Dollars ($532,000) is hereby added to the budgeted Rate Stabilization Reserve in the Wastewater Collection Fund to reflect all changes as described in Exhibit ~B". SECTION i0. The sum of Two Hundred Twenty Two Thousand Dollars ($222,000) is hereby deleted from the budgeted Rate Stabilization Reserve in the Water Fund to reflect all changes as described in Exhibit ~B". SECTION ii. As specified in Section 2.28.080(a) of the Palo Alto Municipal Code, a two-thirds vote of the City Council is required to adopt this ordinance. SECTION 12. The Council of the City of Palo Alto hereby finds that the enactment of this ordinance is not a project under the California Environmental Quality Act and, therefore, no environmental impact assessment is necessary. SECTION i$. As provided in Section 2.04.350 Of the Palo Alto Municipal Code, this ordinance shall become effective upon adoption. INTRODUCED AND PASSED: AYES: NOES: ABSTENTIONS: ABSENT: ATTEST:APPROVED: City Clerk Mayor APPROVED AS TO FORM:City Manager Senior Asst. City Attorney Deputy City Manager, Administrative Services Department EXHIBIT A 1995-1996 Midyear Adjustments General Fund, Special Revenue Fund and Internal Service Fund Activity Object Description Debit Credit Code Code General Fund Revenue 02000000 1180 02513250 1925 02000000 1183 02000000 1203 02000000 1124 02000000 1181 02000000 1188 02000000 1185 03000000 1187 Expenditures 00275550 3813 02513250 3126 02818410 3003 02511111 3127 02000000 4031 02818424 3001 02818394 3001 Changein Reserve 02000000 3822 03000000 3823 Documentary Transfer Tax Electric Line Clearing Motor Vehicle in Lieu Tax Parking Violation Property Tax Sales Tax Sales Tax - County Transient Occupancy Tax Utility Users Tax - Telephone Total General Fund Revenue Bad Debt- Paramedic Electric Line Clearing Hourly Salary -"The Outlet" Program Maintenance Contract Operating Transfers-out Salary Adjustment Salary Adjustment Total General Fund Expenditures Budget Stabilization Reserve Streets and Sidewalks Reserve 121,000 13,000 265,000 399,000 38,000 75,000 20,000 19,515 25,000 25,000 202,515 1,553,485 80,000 75,000 95,000 71,000 1,601,000 208,000 2,130,000 290,000 $290,000 265,000 + + + + + + + + + + + + EXHIBIT A 1995-1996 Midyear Adjustments General Fund, Special Revenue Fund and Internal Service Fund Activity Object Description Debit Credit Code Code SPECIAL REVENUE FUND Street Improvement Fund 31000000 ¯1521 Gas Tax 100,000 31000000 3850 Debt Se~ice Fund 52000000 2011 52000000 3850 INTERNAL SERVICE FUND General Benefits 87000000 1891 87000000 3015 Change in Fund Balance Operating Transfers-in Change in Fund Balance Employee Benefits- Department Charges Retirement- City Share 100,000 290,000 560,000, 290,000 560,000 ÷ + Activity Code Electric Fund 23 000000 23 250220 23 250220 23 230160 23 230160 23 250220 123 250790/8915 Changein Reserve 23 000000 Gas Fund 24 000000 24 000000 24 000000 24 000000 24 000000 24 000000 24 000000 24 230160 24 230160 24 250780/8017 24 250790/8915 Changein Reserve 24 000000 Refuse Fund 25 000000 25 000000 25 000000 25 000000 25 000000 25 000000 Changein Reserve 25 000000 EXHIBIT B 1995-96 Midyear Adjustments Enterprise Funds Objecl Code 1601 3001 3004 3315 3611 3925 3879 3804 1402 1601 1711 1712 1713 1714 1715 3604 3607 3879 3879 3804 1601 !711 1712 1713 1714 1715 3804 Descriptions Interest Income Regular Salaries Overtime Salaries Joint-Agency Debt Service Electric Purchases Electric Line Clearing Arastradero Access Road Project Change to RSR Total Electric Fund Connection Charges Interest Income Sales - Single Family Residential Sales - Multy Family Residential Sales - Commercial Sales - Industrial Sales - Public Facilities Gas Commodity Purchases Gas Transmission Gas Systems Extensions Arastradero Access Road Project Change to RSR Total Gas Fund Interest Income Residential - Single Family Residential - Multi family Commercial Industrial Research Pubic Facilities Change to RSR Total Refuse Fund Debit 95,000 700,000 100,000 262,000 75,000, 7,050,000 Credit 8,277,000 5,000 8,282,000 526,763 164,325 359,365 368,460 81,087 70,000 1,347,000 8,282,000 70,000i 195,000 2,917,000 220,400 134,700 71,000 489,300 84,600 1,000,000 2,551,300 95,700 5,000 2,917,000 95,000 + + + + ÷ 905,000 1,000,000! Activity Object~ Code Code~ WW Collection Fund 27 000000 1601 27 000000 1752 27 250290 3199 27 250790/8915 3879 Changein Reserve 27 000000 3804 Water Fund 22 000000 1402 i22 000000 1601 i22 230160 3602 22 250780/8013 3879 22 250780/8015 3879 22 250790/8915 EXHIBIT B 1995-96 Midyear Adjustments Enterprise Funds Descriptions Interest Income Groundwater Discharge Fee Contract Services Arastradero Access Road Project Change to RSR Total WW Collection Fund Connection Charges interest Income iWater Purchases Water System Extensions Water Meters 3879 Arastradero Access Road Project Change to RSR Total Water Fund Debit 532,000 532,000 Credit 170,000 300,000 57,000 5,000 532,000 Total Enterprise Funds 75,000 152,000 15,000 40,000 55,000 Changein Reserve 22 000000 3804 5,000 222,000 282,000 13,013,000 282,000 13,013,000 ÷ ÷ l.-ZIJJ ~0~0000000000000000000000000~000~000000000000~0~0~000000 ~~0~00~00~~0~00~ I-ZLU 0~’~"0000O~ 000000000000 0 ~ I ~~0~0~00 ~ O0’~-O0~D ~oo t- ._c Ow~ww~w ~wwww Attachment 2 ELECTRIC FUND SUMMARY (ooo’s) REVENUE Electric Sales Other Revenues Reappropriations /Enc TOTAL REVENUE EXPENSES Purchases Other Expenses TOTAL OPERATING EXPENSES Capital E~penses TOTAL EXPENSES TO/(FROM) RESERVES Actual FY 94-95 MIDYEAR Adjusted PROJECTED Budget BUDGET FY 95-96 FY 95-96 DIFFERENCE 63,285 60,021 60,021 0 4,477 5,940 5,845 (95) 5,913 4,935 4,935 0 73,675 70,896 70,801 (95) 30,242 35, 801 27,524 8,277 29,371 27,857 28,994 (1,137) 59,613 63,658 56,518 7,140 10,160 12,348 12,343 5 69,773 76,006 68,861 7,145 3,902 (5,110)1,940 7,050 RESERVES Rate Stabilization Other Reserves Total FY 95-96 APPROVED RSR LEVELS 36,555 22,371 29,421 7,050 16,898 25,972 25,972 0 53,453 48,343 55,393 7,050 Minimum 12,912 12,912 Ta~et 19,368 19,368 Maximum 25,823 25,823 REVENUE Gas Sales Other Revenues Reappropdations /Enc EXPENSES Purchases Other Expenses TOTAL OPERATING EXPENSES Capital Expenses TOTAL EXPENSES TO/(FROM) RESERVES Actual FY 94-95 Attachment 3 GAS FUND SUMMARY (pop’s) MIDYEAR Adjusted PROJECTED Budget BUDGET FY 95-96 FY _95-96 DIFFERENCE 20,193 18,537 17,037 (1,500) 1,122 928 1,193 265 1,865 1,898 1,898 0 23,180 21,363 20,128 (1,235) 8,752 10,304 7,657 2,647 5,735 7,080 7,080 0 14,487 17,384 14,737 2,647 4,677 4,468 4,533 (65) 19,164 21,852 19,270 2,582 4,016 (489)858 1,347 RESERVES Rate Stabilization Other Reserves Total FY 95-96 APPROVED RSR LEVELS 11,623 11,105 12,452 1,347 3,687 3,717 3,717 0 15,310 14,822 16,169 1,347 Minimum 3,803 3,803 Target 5,705 5,705 Maximum 7,606 7,606 REVENUE Customer Revenue Other Revenues Reappropriations / Enc TOTAL REVENUE EXPENSES Payments to PASCO Other Expenses TOTAL OPERATING EXPENSES Capital Expenses TOTAL EXPENSES TO/(FROM) RESERVES RESERVES Rate Stabilization Other Reserves Total FY 95-96 APPROVED RSR LEVELS Actual FY 94-95 17,400 2,147 306 19,853 5,946 13,207 19,153 0 19,153 700 3,752 236 3,988 Minimum Target Maximum Attachment 4 REFUSE FUND (ooo’s) Adjusted Budget FY 95-96 MIDYEAR PROJECTED BUDGET FY95-96 18,111 2,072 458 20,641 6,430 14,432 20,862 5O 20,912 (271) 3,749 354 4,103 17,111 2,167 458 19,736 6,430 14,432 20,862 5O 20,912 (1,176) 2,844 354 3,198 1,810 2,715 3,620 1,810 2,715 3,620 DIFFERENCE (1 ,ooo) 95 0 (905) 0 0 0 0 0 (905) (905) 0 (905) Attachment 5 STORM DRAINAGE FUND (pop’s) REVENUE Customer Revenues Other Revenues 1995 Bond Proceeds Reappropriations / Enc MIDYEAR -Adjusted PROJECTED Actual Budget BUDGET FY 94-95 FY 95-96 FY 95-96 2,102 2,166 2,166 96 109 109 8,358 0 0 1,657 4,464 4,464 DIFFERENCE 0 0 0 0 TOTAL REVENUE EXPENSES Operating Expenses TOTAL OPERATING EXPENSES Capital Expenses Principal Payments TOTAL EXPENSES TO/(FROM) RESERVES 12,213 6,739 6,739 1,627 1,684 1,684 1,627 1,684 1,684 4,785 7,321 7,321 90 260 260 6,502 9,265 9,265 5,711 (2,526)(2,526) 0 0 0 0 0 0 RESERVES Rate Stabilization Total FY 95-96 APPROVED RSR LEVELS 5,633 3,109 3,109 5,633 3,109 3,109 Minimum NA NA Target 500 500 Maximum NA NA 0 0 REVENUE Customer Revenues Other Revenues Reappropriations / Enc TOTAL REVENUE EXPENSES Sewer Treatment Exp. Operating Expenses TOTAL OPERATING EXPENSES Capital Expenses Principal Payments TOTAL EXPENSES TO/(FROM) RESERVES Attachment 6 WASTEWATER COLLECTION FUND (ooo’s) MIDYEAR Adjusted PROJECTED Actual Budget BUDGET FY 94-95 FY 95-96 FY 95-96 DIFFERENCE 9,423 9,667 9,667 0 1,225 867 1,337 470 472 2,908 2,908 0 11,120 13,442 13,912 470 3,348 3,929 3,929 0 1,879 2,055 1,998 57 5,227 5,984 5,927 57 4,426 7,413 7,408 5 146 156 156 0 9,799 13,553 13,491 62 1,321 (111)421 532 RESERVES Rate Stabilization Other Reserves Total FY 95-96 APPROVED RSR LEVELS 7,721 7,592 8,124 532 336 354 354 0 8,057 7,946 8,478 532 Minimum 4,243 4,243 Target 5,137 5,137 Maximum 6,031 6,031 Treatment Revenues Other Revenues Reappropriations /Enc TOTAL REVENUE EXPENSES Operating Expenses TOTAL OPERATING EXPENSES Capital Expenses Principal Payments TOTAL EXPENSES TO/(FROM) RESERVES RESERVES .Rate Stabilization Other Reserves Total FY 95-96 APPROVED RSR LEVELS Attachment 7 WASTEWATER TREATMENT FUND (0O0’s) MIDYEAR Adjusted PROJECTED Actual Budget BUDGET FY 94-95 FY 95-96 FY _95-96 DIFFERENCE 9,337 10,661 10,661 539 512 512 1,904 2,473 2,473 0 0 0 11,780 13,646 13,646 9,372 10,672 10,672 9,372 10,672 10,672 1,834 2,258 2,258 319 339 339 11,525 13,269 13,269 255 377 377 2,667 2,976 2,976 947 1,015 1,015 3,614 3,991 3,991 0 0 0 0 0 0 0 0 Minimum 1,602 !,602 Target 2,403 2,403 Maximum 3,204 3,204 REVENUE Water Sales Other Revenues Reappropriations / Enc TOTAL REVENUE EXPENSES Purchases Other Expenses TOTAL OPERATING EXPENSES Capital Expenses TOTAL EXPENSES TO/(FROM) RESERVES Actual FY 94-95 Attachment 8 WATER FUND SUMMARY(ooo’s) MIDYEAR Adjusted PROJECTED Budget BUDGET FY 95-96 FY 95-96 DIFFERENCE 11,789 12,510 12,510 0 765 884 864 (20) 3,036 3,233 3,233 0 15,590 16,627 16,607 (20) 4,204 4,606 4,758 (152) 6,456 6,546 6,546 0 10,660 11,152 11,304 (152) 4,927 5,401 5,451 (50) 15,587 16,553 16,755 (202) 3 74 (148)(222) RESERVES Rate Stabilization Other Reserves Total FY 95-96 APPROVED RSR LEVELS 6,585 6,604 6,382 (222) 652 707 707 0 7,237 7,311 7,089 (222) Minimum 4,243 4,243 Target 6,365 6,365 Maximum 8,486 8,486