Loading...
HomeMy WebLinkAbout13-Water Department CITY OF SAN BERN.DINO - REQUEST ~ I I I "I C- CtNCIL ACTION From: Cheryl Flowers Assistant General Manager Water Department February 2, 1995 Subject: 1993-94 Annual Audit of the Water Department's Water, Sewer and Geothermal Funds Dept: Date: Synopsis of Previous Council action: .~DI4H!. n'PJ.~fJ 2 FEe 9;. !1 2; Recommended motion: That the 1993-94 annual audit of the Water Department's Water, Sewer and Geothermal Funds be received and filed. ') ( ~o:t:." Signature Conu~~non: Cheryl Flowers/Paul Harmon Supporting daU atUched: Audit Reports Phone: 384-5393/384-5184 Ward: N/A FUNDING REQUIREMENTS: Amount: N/A Source: (Acct. No.) N/A (Acct. DescriPtion) N/A Finance: N/A Council Notes: 75-0262 ~ /;Zt? h~ Agenda Item No~_1 ~ CITY OF SAN BER~DINO - REQUEST F. COUNCIL ACTION STAFF REPORT The firm of Soren + McAdam + Bartells has completed the 1993-94 Annual Audit of the Water Department's Water, Sewer and Geothermal Funds. These reports were presented to and accepted by the Board of Water Commissioners on January 24, 1995. Staff has been directed to transmit to the Mayor and Common Council the 1993-94 Annual Audit of the Water Deprtment's Water, Sewer and Geothermal Funds as a "receive and file" item. . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Financial Statements And Supplementary Information With Independent Auditors' Report For the Years Ended June 30,1994 and 1993 _.-,,-- S B M SOREN. McADAM. BARTELLS CERTIFIED PUBLIC ACCOUNTANTS, INC. I I ,,! I' \ ,#~~ -fS" II II . . TABLE OF CONTENTS Independent Auditors' Report Page I Financial Statements BwmreS~ 3 Statements of Operations 5 Statements of Changes in Fund Equity 6 Statements of Cash Flows 8 Notes to Financiw Statements 10 Supplementary Information Independent Auditors' Report on Supplementary Information 25 Schedule of Federal Finmciw Assistanre 26 Schedule of Property, Plmt, Equipment md Water Rights md Accumulated Depreciation 27 Bond Schedule - General Obligation Waterworks Bond, Series C 35 Certificates of Participation Schedule - West End Water Development, Treatment md Conservation Joint Powers Authority 36 Schedule of Direct Plmt Production Expenses 37 Schedule of Direct Expenses of Other Plmt Facilities 38 Schedule of Water Production md Purchased Cost 39 Schedule of Sundry Statistical Data 41 Schedule of Water System Demographics 43 Schedule of Distribution System Expenses 44 Schedule of Overhead Swaries md Related Costs 45 Schedule of General Administrative md Overhead Expenses 46 Schedule of Insurmre Coverage 47 II III . 5MB . AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS PRIVATE COMPANIES PRACTICE SECTION SOREN . McADAM. BARTELLS CERTIFIED PUBLIC ACCOUNTANTS. INC. THOMAS E. AHERN. C.P.A. BRUCE J. BARTELLS. C.P.A. GARY L. CHRISTENSON, C.P.A. CHARLES P. COPELAND. C.P.A. RHEE ELIKER. C.P.A. WING K. LAU. C.P.A. DOUGLAS R. McADAM. C.P.A. JESSIE C. POWELL. C.P.A. JAMES L. SOREN. C.P.A. KIRK G. STITT. C.P.A. DAVID P. TUTTLE. C.P.A. MEMBERS ASSOCIATED REGIONAL ACCOUNTING FIRMS (ARAF) INDEPENDENT AUDITORS' REPORT Board of Water Commissioners Municipal Water Department Water Utility Enterprise Fund City of San Bernardino, California We have audited the accompanying financial statements of the Municipal Water Department - Water Utility Enterprise Fund of the City of San Bernardino, California as of and for the year ended June 30, 1994. These financial statements are the responsibility of the Municipal Water Department's management. Our responsibility is to express an opinion on these financial statements based on our audit. We did not audit the financial statements of the West End Water Development, Treatment and Conservation Joint Powers Authority that has been consolidated with the Municipal Water Department - Water Utility Enterprise Fund. 'Ibis represents 2 percent and .4 percent, respectively, of the assets and total revenue of the Municipal Water Department - Water Utility Enterprise Fund for the year ended June 30, 1994. That portion was audited by other auditors whose report has been furnished to US, and our opinion, insofar as it relates to the amounts included for West End Water Development, Tr~tment and Conservation Joint Powers Authority, is based solely on the report of the other auditors. The financial statem~s of the Munidpal Water Department - Water Utility Enterprise Fund as of and for the year ended June 30, 1993 were audited by other auditors whose opinion dated October 18, 1993 expressed an unqualified opinion on those statements. As discussed in Note 2 to the financial statements, the Department has restated its 1993 financial statements during the current year to reflect a correction of an error in the recording of revenue earned from utility services provided, but not yet billed, and the recording of an allowance for uncollectible accounts receivable in conformity with generally accepted accounting principles. The other auditors reported on the 1993 financial statements before restatement. We conducted our audit in accordance with generally accepted auditing standards. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. As discussed in Note I, the financial statements present only the Municipal Water Department - Water Utility Enterprise Fund and are not intended to present fairly, in all material respects, the financial position of City of San Bernardino, California, and the results of its operations and cash flows of its proprietary fund types, in conformity with generally accepted accounting principles. -1- 2068 Orange Tree Lane. Su;te100 . Post Office Box 8010 . RedIand.. CA 92375-1210 . (909) 798-2222 . (909) 824-5110 . FAX (909) 79B-9772 II III . . In our opinion, based on our audit and the report of other auditors, the 1994 financial statements referred to above present fairly, in all material respects, the financial position of the Municipal Water Department - Water Utility Enterprise Fund of the City of San Bernardino, California as of June 30, 1994, and the results of its operations and its cash flows for the year then ended, in conformity with generally accepted accounting principles. We also audited the adjustments described in Note 2 that were applied to restate the 1993 financial statements. In our opinion, such adjustments are appropriate and have been properly applied. Our audit was conducted for the purpose of forming an opinion on the financial statements taken as a whole. The supplementary information shown on pages 2S through 47 is presented for purposes of additional analysis and is not a required part of the financial statements. The supplementary information, except for management-supplied data on pages 41 through 43 on which we express no opinion, was subjected to the auditing procedures applied in the audit of the financial statements and, in our opinion and the report of other auditors, is fairly stated, in all material respects, in relation to the financial statements taken as a whole. October 31, 1994 SOREN . McADAM . BARTELLS Certified Public Accountants, Inc. ~C~ By: Jessie C. Powell, CPA . -2- II III . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Balance Sheets June 30. 1994 1993 ASSETS Current assets Cash and cash equivalents Equity in pooled cash and investments Accounts receivable Note receivable Inventory Prepaid expenses $ 68.610 3.598.058 4.224.572 79.834 1.114.367 115.736 $ 55.109 2.743.062 4.120.317 79.834 1.095.968 113.816 Total current assets 9.201.177 8.208.106 26.526 44.008 1.692.980 1,492.488 281.298 1.613.318 896.992 17.669 2.915.465 3.149.814 78.246.039 73.013.720 25.366.461 23.323.285 52.879.578 49.690.435 1.485 .278 4.313.518 54.364.856 54.003.953 79.834 326.790 344.073 2.878 6.742 102.909 112.159 432.577 542.808 $66.914.075 $65 .904.~81 Restricted assets Cash and cash equivalents (WEJPA) Equity in pooled cash and investments Cash with fiscal agent Investments with fiscal agent Taxes receivable Total restricted assets Property, plant, equipment and water rights Property. plant. equipment and water rights Less acclIm'Ilated depreciation and amortization Construction in progress Total property. plant. equipment and water rights (net) Other assets Long-term note receivable - related party Idle assets Issuance costs of notes payable. net of accumulated amortization Issuance costs of certificates of participation. net of accumulated amortization Total other assets Total assets The accompanying notes are an integral part of these jinancial statements. -3- . June 30. LIABILITIES AND FUND EQUITY Current liabilities Current portion of DOtes payable Current portion of obligation under capital lease Accounts payable Related parties payable Other accrued liabilities Accrued compensation Deposits for performance bonds and other charges subject to refund Consumer deposits, advance payments and credit available Deferred revenue Total current liabilities Current liabilities payable from restricted assets Current portion of certificates of participation Accrued interest payable Consumer deposits Total current liabilities payable from restricted assets Long-term debt Accrued compensation Obligations under capital lease Notes payable Certificates of participation Bonds payable Less current portion Total long-term debt Total liabilities Fund equity Contributed capital Retained earnings Total liabilities and fund equity -4- -I 1 r TTI . 1994 1993 $ 65,417 $ 102,125 123,517 118,632 490,462 773,259 797,143 683,526 10,454 9,210 676,009 638,234 6,212 12,796 256,546 177,077 4.173 4.173 2.429.933 2.519.032 539,181 507,494 176,554 184,934 555.148 491.520 1.270.883 1.183.948 540,866 488,749 228,427 344,810 65,417 167,542 10,124,019 10,631,512 150.000 150.000 11,108,729 11,782,613 (728.115) (728.251) 10.380.614 11.054.362 14.081.430 14.757.342 32,994,434 30,822,174 19.838.211 20.325.165 52.832.645 51.147.339 $66.914.075 $65.904.681 II III . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Statements of Operations For the Years Ended June 30. 1994 1993 $12.681.372 $12.467.508 169.576 164.052 48.034 40.191 323.669 265.522 72.123 149.327 13.294.774 13.086.600 54.517 40.736 67.578 65.635 670.391 659,418 605.866 576.008 106.881 78.675 14.800.007 14.507.072 Operating revenues Water sales Metered consumers Fire service Contractors Municipal Other agencies Service charges Hydrogeneration Administration charges Contracted services Other Total operating revenues Operating expenses Costs of water Production Purchased water. delivery charges and assessments Other plant facilities 2.464.675 2.469.815 156.930 18.556 656.027 552.239 3.277.632 3.040.610 1.584.923 1.365.113 3,495.889 2.894.547 3.691.859 3.706.089 577.726 562.396 2.268.328 2.204.985 14.896.357 13.773.740 (96.3501 733.332 449.784 424.650 33.198 389 (82.948) (95,455) (777.524) (882,418) (13.114) (13.930) 85 .564 (390.604) (481.200) $ (486.954) $ 252.132 Distribution system Overhead salaries and related costs General administrative and overhead Costs of contracted services Depreciation Total operating expenses Operating income (loss) Nonoperating revenue (expense) Interest income Propeny taxes Loss on capital assets and inventory items Interest expense Amortization of issuance costs Grant revenue Total nonoperating revenue (expense) Net income (loss) The accompanying notes are an integral parr of these financial statements. -5- 1fT!1 . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Statements of Changes in Fund Equity For the Years Ended June 30, 1994 and 1993 1994 Contributed Retained Caoital Earninl!S Total Fund equity balance, beginning of year, as previously stated $30.887.406 $19,534,743 $50.422,149 Prior period adjustments (65.232) 790.422 725.190 Balance. beginning of year. as restated 30.822.174 20.325.165 51.147.339 Add nonoperating credits and adjustments Charges to property owners for capital purposes Service connections 219,817 219.817 Main extensions 363,499 363,499 Acquisition of service 578.150 578.150 Other 58,378 58,378 Grants from government agencies Capital improvements 952.416 952.416 2.172.260 2.172.260 Net income (loss) (486.954) (486.954) Balance. end of year $32.994.434 $19.838.;l11 $52.832.645 The accompanying notes are an integral part of these financial statements. -6- 'I III . . 1993 Contributed Retained Caoital Earninl!S Total $27.597.130 $19.277.261 $46.874.391 795.772 795.772 27 .597 .130 20.073.033 47 .670.163 255.612 168.899 1.029.032 107.875 255.612 168.899 1.029.032 107.875 1.663.626 3.225.044 252.132 1.663.626 3.225.044 252.132 $30.822.174 $20.325.165 $51.147.339 -7- . II 1"11 . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Statements of Cash Flows For the Years Ended June 30. Cash flows from operating activities Operating income (loss) Adjustments to reconcile net income to net cash provided by operating activities Depreciation and amortization Uncollectible accounts charged off (Increase) decrease in Accounts receivable Inventory Prepaid expenses Increase (decrease) in Accounts payable Related parties payables Contracts payable Other accrued liabilities Deposits for performance bonds and other charges Consumer deposits, advance payments and credit available Accrued vacation and sick leave Net cash provided by operating activities Cash flows from capital and related financing activities Acquisitions of property, plant and equipment Charges to property owners for capital purposes Grant proceeds from government agencies Payments received on notes receivable Principal payments on notes payable Principal payments under capital lease Principal payments on certificates of participation Property taxes received Interest paid Net cash used in capital and related financing activities -8- 1994 1993 $ (96,350) $ 733,332 2,268,328 2,204,985 79,431 69,189 (236,584) (476,916) (18,399) 138,459 (1,920) 484,708 (282,797) 339,617 113,617 92,509 (135,809) 1,244 6,274 (6,584) (458) 143,097 (46,894) 89.892 109.365 2.052.975 3.518.361 (2,671,232) (5,743,305) 1,139,921 1,561,418 1,080,891 1,518,082 79,834 163,666 (102,125) (96,238) (116,383) (124,488) (523,873) (493,057) 15,529 389 (769 .524) (883.612) (1.866.962) (4.097 .145) II III . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Statements of Cash Flows Cash and cash equivalents at end of year 1994 1993 $ (896.992) 430.466 S 322.793 (466 .526) 322.793 (280.513) (255.991) 5.947.985 6.203.976 $ 5.667.472 $5.947.985 For the Years Ended June 30. Cash flows from investing activities Purchase of investments Interest received Net cash provided by (used in) investing activities Net decrease in cash and cash equivalents Cash and cash equivalents at beginning of year Noncash transactions During the year ended June 30. 1994. developers contributed mains and gates at a recorded value of $79.923. The accompanying notes are an integral part of these financial statements. -9- TTTfT . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 1. Summary of Significant Accounting Policies The City of San Bernardino Municipal Water Department (a component unit of the City of San Bernardino) was formed in 1904 under the Charter of the City of San Bernardino. The Department is governed by a Board of Water Commissioners who are appointed by the Mayor of the City of San Bernardino. The Charter gives the Board of Water Commissioners semiautonomous authority to govern the Department independent of the City Council. The City of San Bernardino Municipal Water Department operates three enterprise funds: the Water Utility Enterprise Fund, the Sewer Utility Fund and the Geothermal Utility Enterprise Fund. In addition, the Water Utility Enterprise Fund provides administrative services and contracted services to the Sewer and Geothermal Utility Enterprise Funds. The accounting policies of the Water Utility Enterprise Fund conform to generally accepted accounting principles (GAAP) as applicable to governments. A summary of the more significant accounting policies of the Water Utility Enterprise Fund follows: Reporting Entity As required by generally accepted accounting principles, these financial statements present the Water Utility Enterprise Fund and its component unit, an entity for which the Fund is considered to be financially accountable. The component unit, although a legally separate entity, is in substance part of the Fund's operations and, therefore, data from this unit is combined with data of the Fund. Complete financial statements for the componet unit may be obtained from the Municipal Water Department. West End Water Develooment. Treatment and Conservation Joint Powers Authoritv On August IS, 1990, the City of San Bernardino joined the West End Water Development, Trelltment and Conservation Joint Powers Authority (WEJPA) as a financing vehicle for construction of water facilities. In accordance with the joint powers agreement, title to the WEJP A constructed water facilities will automatically vest with the Municipal Water Department in the Water Utility Enterprise Fund upon repayment of the certificates of participation issued to fund the construction. The WEJP A is governed by a separate board consisting of a three-member commission consisting of one representative from each agency's governing body. These financial statements include only the activity of the Water Utility Enterprise Fund and its component unit. -10- . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 1. Summary of Significant Accounting Policies (Continued) Fund Accounting The accounts of the Fund are organized and operated on the basis of a fund. A fund is an independent fiscal and accounting entity with a self-balancing set of accounts. Fund accounting segregates funds according to their intP.11t1ed purpose and uses them to aid management in demonstrating compliance with finance-related legal and contractual provisions. The Fund's financial statements include only the proprietary fund type and its enterprise fund. Enterprise Funds are used to account for those operations that are financed and operated in a mann.... similar to private business or where the board has decided that the determination of revenues earned, costs incurred and/or net income is necessary for management accountability. Basis of Accounting Proprietary funds are accounted for on the flow of economic resources measurement focus and use the accrual basis of accounting. Under this method. revenues are recorded when earned and expenses are recorded at the time liabilities are incurred. The Fund applies all applicable F ASB pronouncements in accounting and reporting for its proprietary operation. Cash and Investments Cash for the Fund is pooled with the Department and the City of San Bernardino for investment purposes in order to maximize interest earnings. Such earnings are credited to the various funds within the City of San Bernardino based upon average monthly cash balances. The investment policies and the associated risk factors as they relate to the Fund are included in the City's Comprehensive Annual Financial Report. For the purpose of the statement of cash flows. cash and cash equivalents include all highly liquid investments (including restricted assets) with a maturity of three months or less when purchased. Cash and cash equivalents are presented on the balance sheet as cash and cash equivalents. equity in pooled cash and investments and cash with fiscal agent. In addition, the Fund has monies and investments held by trustees or fiscal agents pledged to the pa~nt or security of certificates of participation. which are presented on the balance sheet as cash with fiscal agent and investments with fiscal agent. Receivables Receivables are shown net of an allowance for uncollectibles; the allowance is based on management's estimate. -11- . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 1. Summary of Significant Accounting Policies (Continued) Inventories Inventories are valued at the lower of cost, using the average-cost method, or market. Issuance Costs and Discount lssuaoce costs and discount for notes payable and certificates of participation are being amortized using the straight-line method over the term of the related note or certificate. Property, Plant, Equipment and Water Rights Property, plant and equipment are recorded at cost. Major outlays for capital assets and improvements are capitalized as projects are constructed. Interest incurred during the construction phase is reflected in the capitalized value of the asset constructed, net of interest earned on the invested proceeds over the same period, if any. Overhead costs are capitalized at the rate of 17 percent of direct construction cost and are reflected in the capitalized value of the asset constructed. Depreciation has been provided for using the straight-line method over the estimated useful lives of the related assets which vary from 5 to 50 years. Equipment leased under capital leases is recorded at cost and amortization has been provided for using the straight-line method over the estimated useful life of eight years. Amortization is included in depreciation expense. Water company stock is stated at cost, which approximates market value. Idle Assets Idle assets consist of water wells, pumping plants and reservoirs not in production. Compensated Absences Employees gain a vested right to accumulated unpaid vacation based on years of service but cannot accumulate more than two years of accrued vacation. Once each fiscal year, employees with at least three weeks of accrued vacation have the option of receiving payment at their regular rate of pay for one week of accumulated unpaid vacation. Employees' vacation benefits are recognized as a liability of the Fund. -12- . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 1. Summary of Significant Accounting Policies (Continued) Sick leave is accumulated without limit for each employee at the rate of 3.7 hours per pay period. Leave with pay is provided when employees are absent for health reasons and employees are entitled to 25 percent of accumulated sick leave with five-years of service and a minimum of 480 hours of accumulated sick leave. Upon retirement or death. employees are entitled to 50 percent accumulated sick leave up to a maximum of 960 hours. Accrued sick leave benefits are recognized as a liability of the Fund. Fund Equity Contributed capital represents equity acquired through capital grants and capital contributions from developers. customers or other funds. 2. Prior Period Adjustment Retained Earnings 1be financial statements for 1993 have been restated to correct errors in the recording of revenue earned from utility services provided. but not yet billed. and the recording of an allowance for doubtful accounts as required by generally accepted accounting principles. 1be effect of the restatement was to decrease net income for 1993 by $5.530. Retained earnings at the beginning of 1993 has also been adjusted for the effects of the restatement on prior years by an increase of $795.772. 3. Cash and Investments Cash and Cash Equivalents As of June 30. 1994 and 1993. the carrying amount of the cash and cash equivalents was $95.136 and $99.117 and the bank balance was $67.341 and $40.982. respectively. The bank balance is covered by federal depository insurance (FDIC). -13- I I 111 . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 3. Cash and Investments (Continued) Cash and Investments with Fiscal Agent The Department has monies held by trustees or fiscal agents pledged to the payment or security of certificates of participation. 1he California Government Code provides that these monies. in the absence of specific statutory provisions governing the issuance of certificates. may be invested in accordance with the ordinance. resolutions or indentures specifying the types of investments its trustees or fiscal agents make. At June 30. 1994 and 1993. cash and investments with fiscal agent in the amount of $1.178.290 and $1.613.318. respectively. were covered by collateral held by the government's agent in the government's name. 4. Accounts Receivable Accounts receivables at June 30. 1994 and 1993 consisted of the following: 1994 1993 Less Net Less Net Amount Allowance Receivable Amount Allowance Receivable Consumer $3.030.747 $185,272 $2.845,475 $2.584.312 $123,290 $2.461.022 Related parties 1.109.523 1.109,523 1,240,873 1.240,873 Grant funding 120,239 120.239 248,714 248,714 Other 188.105 38.770 149.335 198.056 28.348 169.708 $4.448.614 $224.042 $4.224.572 $4.271.955 $151.638 $4.120,317 5. Note Receivable Note receivable at June 30. 1994 and 1993 consisted of the following: 1994 1993 City of San Bernardino Development Department Interest rate: None Repayment provision: $79.834 annual installments Balances Less current portion $ 79,834 (79.834) $159,668 (79.834) Long-term portion $ $79.834 -14- II II' . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 6. Property, Plant, Equipment and Water Rights A summary of property. plant. equipment and water rights as of June 30 follows: 1994 1993 Sundry lands. rights-of-way. service areas and easements $ 2.368.402 $ 2.307,493 Water rights. wells. pumping plants. reservoirs. etc. 27.146.695 24.602.127 Distribution systems 42.431.774 40.462.496 Shops. office and store yards 1.094.227 695.865 Tools and equipment 1.578.163 1.587.534 Automobiles and trucks 1.705.189 1.619.726 Office leasehold improvements 55.409 47.322 Office and engineering equipment 1.395.569 1.247.793 "E" Street property 54.202 54.202 Radio and interoffice communications equipment 215.009 200.346 Telemetering systems and equipment 65.348 57.052 Miscellaneous capital items 136.052 131.764 78.246.039 73.013.720 Less accumulated depreciation and amortization 25.366.461 23.323.285 52.879.578 49.690.435 Construction in progress 1.485 .278 4.313.518 Total property. plant. equipment and water rights (net) $54.364.856 $54.003.953 Details of construction in progress as of June 30 follow: 1994 1993 19th Street GAC plant $2.009.279 WEJP A water facilities 100.000 Rehabilitation yard facilities 368.749 Devils Canyon filter plant 330.134 19th Street boostinglblending station $ 333.609 Devils Canyon filter plant survey 140.659 Other miscellaneous projects 1.011.010 1.505.356 Totals $1 ,485 .278 $4.313.518 -15- II II: . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 7. Capital Leases The Fund has entered into lease agreements for various pieces of equipment. All leases qualify as capital leases for accounting purposes and. therefore. have been recorded at the present value of the future minimum lease payments as of the date of their inception. The following is an analysis of equipment leased under capital lease obligations as of June 30: June 30. 1994 1993 Equipment. automobiles and trucks Less accumulated amortization $611.806 336.692 $275.114 $655.493 253.396 $402.097 Amortization charged to depreciation expense for the years ended June 30. 1994 and 1993 amounted to $100.391 and $106.m. respectively. The following is a schedule of the future minimum lease payments WIder these capita1lease obligations and the present value of the net minimum lease payments at June 30. 1994: For the year ended June 30. 1995 1996 1997 $139.469 103.464 6.705 Present value of future minimum lease payments Less current portion 249.638 21.211 228.427 123.517 $104.910 Total minimum lease payments Less amount representing interest Long-term portion of obligations under capital leases -16- . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 8. Long-Term Debt The following is a summary of changes in long-term debt obligations for the year ended June 30, 1994: Balance Balance Julv 1. 1993 Additions Reductions June 30. 1994 Accrued compensation $ 488,749 $52,117 $ 540,866 Capital lease obligations 344,810 $116,383 228,427 Notes payable 167,542 102,125 65,417 Certificates of participation 10,631,512 507,493 10,124,019 Bonds payable 150.000 150.000 $11.782.613 $52.117 $726.001 $11.108.729 The following is a description of long-term debt as of June 30: 1994 1993 Notes payable East Valley Water District Interest rate: 7.5% Repayment provisions: Monthly principal and interest payments of $7,498 through March I, 1995 Balances $65,417 $147,124 Herbert B. Wessel Interest rate: 4% Repayment provisions: Annual principal payments of $20,418 through March I, 1994; interest paid at maturity Balance Less current portion 65,417 65.417 20.418 167,542 102.125 Long-term portion $ - $ 65.417 -17- I 1 r lli . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 8. Long-Tenn Debt (Continued) Annual Interest Issue Maturity Original Principal Rates Date Date Amount Installments Outstandin2 June 30, 1994 1993 Certificates of participation 1990 Water facilities 6.1% 1991 to 7.0% 2005 $11,461,581 $493,057 to $1,232,643 $10.124.019 $10.631.512 Bonds payable South San Bernardino Water District Waterworks Bonds, Series C 7.75% 1988 2013 $150,000 $150,000 $150.000 $150.000 The requirements to amortize notes payable and certificates of participation subsequent to June 30, 1994 are as follows: June 30. PrinciDal Interest Notes payable 1995 $65.417 $2.061 Certificates of participation 1995 $ 539,181 $ 686,123 1996 570,910 650,835 1997 633,541 609,835 1998 665,416 565,105 1999 728,193 516,539 Thereafter 6.986.778 1.861.199 $10.124,019 $4,889.636 Total $67.478 $ 1,225,304 1.221,745 1.243,376 1.230,521 1.244,732 8.847.917 $15.013.655 The bonds payable are due in 2013 and the Fund is required to establish a sinking fund. The balance of the sinking fund and future debt service requirements as of June 30, 1994 follows: 1958 Series C Bonds Accumulated sinking fund at 6-30-94 $150.000 (10.000) $140.000 Future sinking fund requirements -18- -I II 111 . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 8. Long-Term Debt (Continued) Sinking Fund June 30. Reouirement Interest Total 1995 $ 5,000 $ 11,625 $ 16,625 1996 5,000 11,625 16,625 1997 5,000 11,625 16,625 1998 5,000 11,625 16,625 1999 5,000 11,625 16,625 Thereafter 115.000 104.625 219.625 $140.000 $162.750 $302.750 9. Operating Leases The Fund leases office space from the City of San Bernardino and equipment under a noncancellable operating lease terminating in 2002. The following is a schedule of minimum lease payments as of June 30, 1994: Office SDace EauiDment Total For the year ending June 30. 1995 1996 1997 1998 1999 Thereafter $ 161,259 161,259 161,259 161,259 161,259 443.462 $12.556 1,046 $ 173,815 162.305 161.259 161,259 161,259 443.462 $1.263.359 $1.249.757 $13.602 Rental expense for the years ended June 30, 1994 and 1993 amounted to $169,084 and $168,038, respectively. 10. Defined Benefit Pension Plan The Water Department (Water Utility Enterprise and Sewer Utility), as a component unit of the City of San Bernardino, contributes to the California Public Employees' Retirement System (PERS), an agent multiple-employer public employee retirement system that acts as a common investment and administrative agent for participating public entities within the State of California. -19- I I II . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 10. Defined Benefit Pension Plan (Continued) The City of San Bernardino is the contracting agent with PERS. and the participants' accounts are not segregated for the Department. Contributions are made in accordance with the actuarially determined employer requirements. Complete information on the funding status. actuarially determined contributions and trend information is included in the City's Comprehensive Annual Financial Report. The following condensed information applies to the total employees' accounts for the City of San Bernardino as a whole. Total unfunded pension benefit obligation applicable to employees was $9.210.320 at June 30. 1993 as follows: Pension benefit obligation Retirees and beneficiaries currently receiving benefits and terminated employees not yet receiving benefits Current employees Accumulated employees' contributions including allocated investment earnings Employer-financed vested Employer-financed nonvested $122.346.489 50.845.043 60.578.439 2.431.715 Total pension benefit obligation 236.201.686 Net assets available for benefits. at cost (market value is $263.082.993) 226.991.366 Unfunded pension benefit obligation $ 9.210.320 The Department's payroll for employees covered by PERS for the year ended June 30, 1994 was $8,143.780. which was 95 percent of the Departtnent's payroll and for the year ended June 30, 1993 was $7,610.534, which was 88 percent of the Department's payroll. II. Postretirement Health Care Benefits In addition to the pension benefits described in Note 10. the Department provides postretirement health care benefits to all employees who retire from the Department on or after attaining age 55 with a minimum of IS years of service. Currently, eight Water Utility Enterprise Fund retirees meet those eligibility requirements. The Department pays monthly contributions for health insurance premiums up to $150 per month per retiree. The Department also pays $16 per month per retiree to PERS for administrative costs of this program. Expenditures for monthly premiums are recognized as incurred. During the years ended June 30, 1994 and 1993, expenditures of $15.848 and $11.530. respectively. were recognized for postretirement health care benefits for the Water Utility Enterprise Fund. -20- I I 1'1 . . MUNIClPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 12. Related Party Transactions Following is a summary of transactions and balances with the City of San Bernardino, its various departments and the Sewer and Geothermal Utility Enterprise Funds: June 30. 1994 1993 Income City of San Bernardino Revenue from water charges $ 335,924 $ 354,868 Administrative charges - refuse 121,139 119,274 Repairs and maintenance 2,195 4,536 Relocation of services and mains 8,760 121,943 Reimbursement - consulting services 7,436 7,314 Interest income 383,315 348,363 Miscellaneous income 1,228 466 Redevelopment Agency Reimbursement - consulting services 7,436 7,314 Retrofit installation 50,800 26,321 Repairs and maintenance 147 New services installation 203,730 49,483 Sewer Utility Enterprise Fund Administration charges 484,400 464,185 Cost reimbursement 50,664 118,162 Water services 35,215 8,553 Computer charges 35,753 30,048 Geothermal Utility Enterprise Fund Administration charges 19,665 18,889 Equipment rental 12,167 5,215 Labor benefits 22.709 17.974 Total income $1.782.683 $1. 702.908 -21- -UTrTl- . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 12. Related Party Transactions (Continued) 1994 June 30. 1993 Expenses City of San Bernardino Street - cut charges $ 22,294 $ 27,003 Street collection - west side 1,114 1,047 Radio maintenance 955 3,432 Workers' compensation program 127,063 102,417 Loss prevention program 26,518 30,441 Printing services 6,395 10,268 Warehouse purchases 5,588 2,009 City Hall rent 156,528 156,528 Telephone charges 79,283 140,492 Miscellaneous repairs 407 1,816 Refuse disposal service 10,024 12,946 Employee assistance program 7,707 3,830 Civil Service 31,050 31,500 Property tax assessments 27,466 Rideshare coordination 2,130 Permits and engineering services 8,506 1,673 Miscellaneous 345 1,407 Redevelopment Agency Reimbursement - consulting services 6,000 10,500 Sewer Utility Enterprise Fund Purchases 2,714 5,918 Miscellaneous 155 20 Total expenses $492.646 $573.298 -22- II" . . MUNIClPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 12. Related Party Transactions (Continued) June 30. Receivables City of San Bernardino Parks and Recreation Finance Department Refuse Department Public Services Public Works Redevelopment Agency Sewer Utility Enterprise Fund Geothermal Utility Enterprise Fund 1994 1993 Note receivable from City of San Bernardino Redevelopment Agency - five annual receipts to $79,834 starting June 30, 1991 $ 75 $ 149,033 113,128 81,932 10,687 98.680 106,605 23,289 233,272 202,407 609.926 721.361 1,109,523 1.240.872 79.834 159.668 $1.189.357 $1.400.540 Total receivables Payables Due to the City of San Bernardino Finance Department _ various terms for repayment $796,437 Due to the City of San Bernardino Sewer Utility Enterprise Fund _ various terms for repayment 706 $680,570 2.956 Total payables $797 .143 $683.526 The Fund collects and transmits to the City of San Bernardino 10 percent of collections on gross water sales. exclusive of sales to the City. Collections submitted to the City are as follows: 1994 1993 $1.380.223 $1.401.473 -23- - I II'" . . MUNIClPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Notes to Financial Statements 13. Commitments and Contingencies Federal and State Grants Amounts received or receivable from grant agencies are subject to audit and adjustment by grantor agencies, principally the federal and state governments. Any disa110wed claims including amounts already collected, may constitute a liability of the Fund. The amount, if any, of expenditures which may be disa110wed by the grantor cannot be determined at this time although the Fund expects such amounts, if any, to be immaterial. Litigation The Municipal Water Department is a defendant in various lawsuits. Although the outcome of these lawsuits is not presently determinable, it is the opinion of the Department's counsel that resolution of these matters will not have a material adverse effect on the financial condition of the Water Utility Enterprise Fund. Risk Management The Fund is exposed to various risks of loss related to torts; theft of. damage to and destruction of assets; errors and omissions and natura1 disasters for which the Municipal Water Department carries commercial insurance coverage for the Water Utility Enterprise Fund. In addition. the Municipal Water DepartmeIlt, in conjunction with the City of San Bernardino. established a limited risk management program for workers' compensation. Premiums are paid on behalf of the Water Utility Enterprise Fund by the Municipal Water Department to pay claims and administrative costs. Commitments Commitments in the form of signed contracts for costs to complete on construction projects or other improvements amounted to $3,200.377 at June 30. 1994. -24- II II . . SUPPLEMENTARY INFORMATION II II . 5MB . AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS PRIVATE COMPANIES PRACTICE SECTION SOREN . McADAM. BARTELLS CERTIFIED PUBLIC ACCOUNTANTS. INC. THOMAS E. AHERN, C.P.A. BRUCE J. BARTELLS. C.P.A. GARY L. CHRISTENSON. C.P.A. CHARLES P. COPELAND. C.P.A. RHEE EUKER. C.P.A. WING K. LAU. C.P.A. DOUGLAS R. McADAM, C.P.A. JESSIE C. POWEll. C.P.A. JAMES L. SOREN. C.P.A. KIRK G. STITT, C.P.A. DAVID P. TUTTLE. C.P.A. MEMBERS ASSOCIATED REGIONAl ACCOUNTING FIRMS (ARAF) INDEPENDENT AUDITORS' REPORT ON SUPPLEMENTARY INFORMATION Board of Water Commissioners Municipal Water Department Water Utility Enterprise Fund City of San Bernardino. California We have audited the financial statements of the Municipal Water Department - Water Utility Enterprise Fund of the City of San Bernardino, California as of and for the year ended June 30. 1994 and have issued our report thereon dated October 31. 1994. These financial statements are the responsibility of the Municipal Water Department's management. Our responsibility is to express an opinion on these financial stateme$ based on our audit. We did not audit the financial statements of the West End Water Development. Treatment and Conservation Joint Powers Authority that has been consolidated with the Municipal Water Department - Water Utility Enterprise Fund. This represents 2 percent and .4 percent, respectively, of the assets and total revenue of the Municipal Water Department - Water Utility Enterprise Fund for the year ended June 30. 1994. That portion was audited by other auditors whose report has been furnished to us. and our opinion, insofar as it relates to the amounts included for the West End Water Development. Treatment and Conservation Joint Powers Authority. is based solely on the report of the other auditors. We conducted our audit in accordance with generally accepted auditing standards. Government Auditing Stondards issued by the Comptroller General of the United States and Office of Management and Budget Circular A-128, Audits of State and Local Governments. Those standards and OMB Circular A-128 require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes examining. on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management. as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. Our audit was conducted for the purpose of forming an opinion on the financial statements as a whole. The supplementary financial and statistical information on pages 26 through 47, including the Schedule of Federal Financial Assistance. is presented for purposes of additional analysis and is not a required part of the financial statements. The supplementary information, except for management supplied data on pages 41 through 43. on which we express no opinion. was subjected to the auditing procedures applied in the audit of the financial statements and, in our opinion and the repon of other auditors, is fairly stated in all material respects in relation to the financial statements taken as a whole. October 31, 1994 SOREN . McADAM . BARTELLS Certified Public Accountants, Inc. B~~~ -25- 2068 Orange T= Lane, Suite 100 . Post Office Box 8010 . Redlancb, CA 92375-1210 . (909)798-2222 . (909) 824-5110 . FAX (909) 798-9n2 . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Federal Financial Assistance For the Year Ended June 30. 1994 Federal Grantor Pass-Through Grantor Prol!ram Title ProgramJ Award Amount Catalog of Federal Domestic Assistance Number Pass-Through Grantor's Number u.s. Department of HUD Pass-through from the County of San Bernardino Rehabilitation of Delman Heights Rehabilitation of Cardiff Farms Center for Individuals with Disabilities 14.218 B-94-MC-06-oS39 $338.000 67,256 14.218 B-94-MC-06-oS39 B-94-MC-06-oS39 60.800 14.218 $%6.0S6 -26- II II Reimbursable Exoenditures $298.237 67.256 60.800 $426.293 - I II II. . . MuNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Property, Plant, Equipment and Water Rights and Accumulated Depreciation For the Year Ended June 30. 1994 Prooertv. Plant. EauiDment and Water Ril!hts Balance Balance Julv 1. 1993 Additions Retirements June 30. 1994 Sundry lands, rights-of-way, service areas and easements $ 2.307 .493 $24.069.909 $ 2.368.402 Water rights, wells, pumping plants, reservoirs, etc. Devils Canyon residence 28,589 28.589 Antil plant 674,084 30,308 $ 5,000 699.392 Baseline and California plant 74,995 119.091 194,086 Cajon Pass well/intake 166,864 3.898 170,762 Cajon Blvd. plant 1,139,117 2 1,139,119 Cajon Blvd. hydrogeneration plant 164,728 164.728 Daley Canyon reservoir 246,922 4,158 4,959 246,121 Del Rosa reservoir #1 and pumping facilities 55,922 55.922 Del Rosa reservoir #2 32,631 32,631 Del Rosa reservoir #3 730,946 730,946 Del Rosa booster station 103,796 103,796 Devils Canyon filter plant/chlorination reservoir #1 764,834 7,732 772,566 Devils Canyon reservoir #2 - college tank 188.748 188.748 Devils Canyon well #1 boosters 173,698 I 173,699 Devils Canyon well #2 100.037 17.686 117,723 Devils Canyon well #3 190,201 190,201 Devore reservoir 516,875 2.856 5,248 514.483 Devore hydrogeneration station 333,122 333,122 Mount Vernon assets 251,450 37.189 288,639 Electric Drive reservoir and pumping facility 95.819 43.875 3,721 135.973 Ellena Bros. well 100.049 100,049 Foothill booster station 165,889 165,889 40th Street well 402,241 402,241 Gilbert Street plant 125,512 5.810 499 130,823 Kenwood well 376.756 376,756 -27- II II . . Accumulated DeDreciation Balaoce Julv 1. 1993 DeDreciation Retirements Balance June 30. 1994 Net Book Value June 30. 1994 $ 2.368.402 $ 10.421 $ 897 $ 11.318 17.271 223.052 23.265 $ 1.300 245.017 454.375 36.718 4.487 41,205 152.881 41.109 2.229 43.338 127,424 299.506 31.386 330.892 808.227 24.779 3.313 28.092 136.636 96.520 6,257 1,240 101.537 144.584 39,771 1.248 41,019 14.903 22,518 701 23.219 9,412 157.129 15,708 172.837 558,109 30.823 4.506 35,329 68,467 257.115 22.666 279,781 492.785 95,327 4,691 100,018 88,730 81.263 6,220 87,483 86.216 83,303 2.252 85,555 32.168 30,796 4.571 35,367 154.834 101.522 10,629 984 111,167 403,316 19.986 6,662 26,648 306,474 3,428 1,791 5,219 283,420 77,489 3,129 3,610 77,008 58,965 22.122 2,285 24,407 75,642 10,833 7,222 18,055 147,834 11,632 11,632 23,264 378,977 57,325 3,722 61.047 69.776 22,715 22,715 354,041 -28- . . MUNICIPAL WATER-DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Property, Plant, Equipment and Water Rights and Accumulated Depreciation For the Year Ended June 30, 1994 Water rights, wells, pumping plants, reservoirs, etc. (Continued) LeRoy Street well and pumping station Lynwood plant Lytle Creek plant Mallory plant Meyers Canyon reservoir Meyers Canyon pumping station Mill and "D" Street plant Newmark plant Newmark stripping towers 19th Street plant 19th Street GAC plant North "E" Street (25th and "E" Streets) Olive and Garner Street well Palm Avenue reservoirs #1 and #2 Palm Avenue hydrogeneration plant Perris Hill plant Ridgeview reservoir Ridgeview booster station San Bernardino Heights mountain reservoirs #1 and #2 Seventh Street plant Shandin Hills plant #1 Shandin Hills plant #2 Sierra Way plant 17th Street GAC plant 16th Street plant Sycamore Canyon reservoirs #1 and #2 Sycamore Canyon reservoir station #1 Sycamore Canyon reservoir station #2 Sycamore Canyon reservoir stations #3 and #4 10th and "J" Street well 30th and Mt. View plant 1 1 r ,1' Prooertv. Plant. EouiDment and Water Ril!hts Balance Balance Julv 1. 1993 Additions Retirements June 30. 1994 $ 181,717 118,881 1,847.327 80.654 1,873.763 46.633 89.931 1.506.099 950.951 190.416 107.696 516,172 797.581 235.487 750.686 36.191 25.805 150.888 279.693 63,727 349,684 449,977 1,047,697 57.131 2,000.072 12.118 12,461 311.034 576.211 246.205 -29- $ 83,910 1 $ 4,816 4,434 7.208 9.393 165.942 2.013.764 2.856 18,890 42.116 4,467 5,450 29,116 21.299 4.514 5.379 7,365 5.934 2.239 4.654 4,434 $ 181.717 197.975 1,842,894 80.654 1.871.578 46.633 89,931 1,506.099 950.951 314.242 2.013,764 106.085 529.612 797.581 235.487 775.288 57.490 20,426 158.253 285.627 63,727 347,489 454,631 1,047.697 57.131 2,000,072 12,118 12,461 311.034 576,211 246,205 II II . . Accumulated Depreciation Net Book Balance Balance Value Julv 1. 1993 Depreciation Retirements June 30. 1994 June 30. 1994 $ 21,852 $ 6,582 $ 28,434 $ 153.283 56,437 6,899 $ 4.654 58.682 139.293 758,842 50,954 809.796 1,033,098 48.224 2.658 50.882 29.772 85.982 39,015 1.240 123.757 1.747.821 26,414 2,018 28.432 18.201 29.167 3,059 32.226 57,705 809.948 33,483 843.431 662,668 185.749 48.013 233.762 717,189 94,335 6,292 14,202 86.425 227.817 48.707 48.707 1,965,057 64.188 3.624 838 66.974 39.111 24.900 17,138 327 41.711 487.901 183.593 17,403 200.996 596.585 75.355 9,420 84,775 150.712 453.357 16,432 1,411 468.378 306.910 17.879 2.377 20.256 37.234 6,496 1.513 1.345 6.664 13.762 76,743 3,436 80.179 78.074 72.446 8.268 80,714 204,913 17.367 4.818 22,185 41,542 26,493 11.931 1,128 37,296 310,193 70.568 12,796 83,364 371,267 240,058 46,151 286,209 761,488 36,245 1,255 37,500 19,631 149.370 40,956 190,326 1,809,746 10,292 93 10,385 1,733 6,917 333 7,250 5,211 18,662 12,441 31,103 279,931 27.589 18,393 45,982 530,229 106.738 7,960 114,698 131,507 -30- . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Property, Plant, Equipment and Water Rights and Accumulated Depreciation For the Year Ended June 30. 1994 Prooertv. Plant. EauiDment and Water Ril!hts Bman~ BmaD~ Julv 1. 1993 Additions Retirements June 30. 1994 Water rights, wells, pumping plaDts, reservoirs, etc. (Continued) 27th and Acacia Street plant 23rd and "E" Street pumping station Vin~nt plant Waterman Avenue plant Waterman Avenue stripping towers Ground water monitoring wells Permanent water rights - W.S.B.C.W.D. Water stock - Del Rosa Mutual Water Company Distribution systems Mains Gates Fire hydrants Meters - general Service connections Shops, offi~ aDd store yards Second and "D" Street property South San Bernardino shop and yard Tools and equipment Automobiles aDd trucks Offi~ leasehold improvements $ 108.715 79.036 42.722 584.400 1.649,702 8.582 6.447 $ 13,214 5.810 24.602.127 2.648.998 27,398.060 2,786.487 1.785.409 2.700,275 5.792.265 40.462.496 1,323,705 143,543 174.435 86,132 464.508 2.192.323 644.950 50.915 695.865 411.009 411.009 1.587.534 43.414 1.619.726 139.957 47.322 8.087 -31- $104.430 33,600 1,403 20 134.102 53.920 223.045 12,647 12.647 52.785 54.494 $ 108,715 79,036 42,722 597.614 1.649,702 8.582 6.447 5.810 27 .146.695 28,688.165 2,928.627 1.959,824 2,652.305 6.202.853 42.431.774 1.043,312 50.915 1.094.227 1.578.163 1.705.189 55.409 II II . . Accumulated DeDreciation Net Book Balance Balance Value Julv 1. 1993 DeDreciation Retirements June 30. 1994 June 30. 1994 $ 61,654 $ 3,198 $ 64.852 $ 43,863 45,253 2.222 47.475 31,561 20.335 900 21.235 21,487 223.005 13.759 236.764 360.850 261,021 84,079 345,100 1,304.602 3.081 343 3,424 5,158 6.447 5.810 6.251.042 793.103 $ 32.279 7.0ll.866 20.134.829 8.958.320 560.528 2.216 9.516.632 19.171,533 676,764 57.137 30 733.871 2,194.756 421.022 37,452 19 458.455 1,501.369 2,142,738 2oo,9ll 74,036 2.269,613 382,692 2.002.200 161.687 18.155 2.145.732 4.057.121 14.201.044 1.017.715 94.456 15.124.303 27.307.471 310,510 32,484 ll,008 331,986 7ll.326 25.217 1.250 26 .467 24.448 335.727 33.734 ll.008 358.453 735.774 815.836 ll1.411 22.509 904.738 673.425 1.020.651 165.801 46.786 1.139.666 565 .523 15.968 2.930 18.898 36.511 -32- -- I II II' . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Property, Plant, Equipment and Water Rights and Accumulated Depreciation For the Year Ended June 30, 1994 Property. Plant. EauiDment and Water Ril!hts Balance Balance J u1v 1. 1993 Additions Retirements June 30. 1994 Office and engineering equipment General office equipment $ 397,344 $ 20,636 $ 2.757 $ 415,223 Computer equipment 850.449 129.897 980.346 1.247.793 150.533 2.757 1.395 .569 "E" Street property 54.202 54.202 Radio and interoffice communications systems 200.346 15.419 756 215.009 Telemarketing systems and equipment 57 .052 8.296 65.348 Miscellaneous capital items 131.764 4.288 136.052 Totals $73.013.720 $5,683.233 $450,914 $78,246.039 -33- - I I II! . . Accumulated Deoreciation Net Book Balance Balance Value Julv 1. 1993 Deoreciation Retirements June 30. 1994 June 30. 1994 $ 188,971 $ 30.125 $ 736 $ 218.360 $ 196.863 287.316 73.372 360.688 619.658 476.287 103.497 736 579.048 816.521 35.884 34 35.918 18.284 117.737 15.727 95 133.369 81.640 48.987 2.450 51.437 13.911 4.122 4.643 8.765 127.287 $23.323.285 $2.251.045 $207 .869 $25.366.461 $52.879 ,578 -34- I I II . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Bond Schedule. General Obligation Waterworks Bond, Series C For the Year Ended June 30. 1994 Sinking Fund Interest Date Reauirement Interest Total Rate 9-1-1994 $ 5.812 $ 5.812 7.75% 3-1-1995 $ 5,000 5,812 10,812 7.75 9-1-1995 5,812 5,812 7.75 3-1-1996 5,000 5.812 10,812 7.75 9-1-1996 5.812 5,812 7.75 3-1-1997 5,000 5.812 10,812 7.75 9-1-1997 5.812 5.812 7.75 3-1-1998 5,000 5.812 10.812 7.75 9-1-1998 5.812 5,812 7.75 3-1-1999 5,000 5,812 10.812 7.75 9-1-1999 5,812 5.812 7.75 3-1-2000 5,000 5,812 10,812 7.75 9-1-2000 5,812 5.812 7.75 3-1-2001 5,000 5,812 10,812 7.75 9-1-2001 5,812 5,812 7.75 3-1-2002 5,000 5,812 10,812 7.75 9-1-2002 5,812 5,812 7.75 3-1-2003 5,000 5.812 10,812 7.75 9-1-2003 5.812 5,812 7.75 3-1-2004 5,000 5.812 10,812 7.75 9-1-2004 5,812 5,812 7.75 3-1-2005 5.000 5.812 10,812 7.75 9-1-2005 5.812 5.812 7.75 3-1-2006 10,000 5.812 15.812 7.75 9-1-2006 5,812 5.812 7.75 3-1-2007 10.000 5,812 15.812 7.75 9-1-2007 5,812 5.812 7.75 3-1-2008 10.000 5,812 15.812 7.75 9-1-2008 5,812 5,812 7.75 3-1-2009 10,000 5,812 15,812 7.75 9-1-2009 5,812 5,812 7.75 3-1-2010 10,000 5,812 15,812 7.75 9-1-2010 5.812 5,812 7.75 3-1-2011 10,000 5,812 15,812 7.75 9-1-2011 5.812 5,812 7.75 3-1-2012 10,000 5,812 15,812 7.75 9-1-2012 5.812 5,812 7.75 3-1-2013 15.000 5.812 20.812 7.75 140,000 220,856 360.856 Amount in sinking fund at 6-30-94 10.000 10.000 $150,000 $220,856 $370,856 -35- II II' . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Certificates of Participation Schedule. West End Water Development, Treatment and Conservation Joint Powers Authority June 30. 1994 Interest Date Due Princioal Interest Total Rate 10-1-1994 $ 539.181 $ 353,106 $ 892.287 6.50% 4-1-1995 335,079 335,079 6.50 10-1-1995 570.910 335,079 905,989 6.60 4-1-1996 315.757 315,757 6.60 10-1-1996 633.541 315.757 949.298 6.70 4-1-1997 294.078 294.078 6.70 10-1-1997 665,416 294.078 959.494 6.80 4-1-1998 271.027 271.027 6.80 10-1-1998 728,193 271.027 999 .220 6.90 4-1-1999 245,512 245.512 6.90 10-1-1999 791.066 245,512 1,036,578 6.90 4-1-2000 217,870 217,870 6.90 10-1-2000 854.037 217,870 1.071,907 7.00 4-1-2001 187.670 187.670 7.00 10-1-2001 917.106 187.670 1,104.776 7.00 4-1-2002 155,313 155.313 7.00 10-1-2002 980,271 155,313 1,135.584 7.00 4-1-2003 120,799 120.799 7.00 10-1-2003 1.074,388 120,799 1,195.187 7.00 4-1-2004 83,049 83.049 7.00 10-1-2004 1.137.797 83,049 1,220.846 7.00 4-1-2005 43,142 43.142 7.00 10-1-2005 1.232.113 43.142 1.275 .255 7.00 $10.124.019 $4.891.698 $15.015.717 -36- II 11 . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Direct Plant Production Expenses For the Year Ended June 30, 1994 Materials and AD 1993.94 199Z-93 Increase Salaries Power SUDDUes Others Total Total (Decrease) Perris Hill $ 14,078 $ 32,460 $ 1,352 $ 824 $ 48,714 $ 48,904 $ (190) Sierra Way (and 16th Street) 7,641 218,311 (427) 1,596 227,121 256,531 (29,410) Anti! pumping 33,055 160,791 1,764 2,132 197,742 109,541 88,201 Waterman Avenue pumping 12,860 172,674 2,573 3,357 191,464 289,585 (98,121) Mill and "0" Street 4,364 37,792 1,210 43,366 46,865 (3,499) Lytle Creek 37,172 93,289 12,761 30,927 174,149 142,394 31,755 Seccombe well - 7th Street plants 4,198 72,382 3,049 60 79,689 85,292 (5,603) Cajon Pass and Vincent plant 6,280 34,694 1,512 4 42,490 37,612 4,878 "E" Street plant (23rd and 2nd Streets) 4,844 54 331 5,229 4,221 1,008 Devils Canyon 58,589 126,516 1,880 7,939 194,924 159,120 35,804 Newmark 15,260 155,253 5,270 533 176,316 325,338 (149,022) 19th Street 23,068 169,409 4,292 69,515 266,284 15,544 250,740 Gilbert. Street 14,799 21,697 2,135 12,586 51,217 24,067 27,150 Lynwood 12,806 66,101 11,692 3,886 94,485 77,301 17,184 27th Street 2,488 958 1 3,447 29,409 (25,962) Baseline and California plant 4,688 19,938 491 25,117 1,885 23,232 Ellena Bros. well 81 81 18,672 (18,591) Cajon Boulevard 14,771 142,723 3,374 2,623 163,491 100,489 63,002 MaUory weD and reservoir 3,783 11,329 40 1,053 16,205 14,142 2,063 30th and Mt. View 2,749 130,655 8,118 1,474 142,996 135,028 7,968 Olive and Garner well 4,209 96,974 1,538 12,371 115,092 178,416 (63,324) LeRoy Street well 4,090 33,541 15 9 37,655 118,377 (80,722) lOth and "J" Street 3,921 76,665 763 280 81,629 157,767 (76,138) Kenwood well 3,875 64,260 412 198 68,745 65,175 3,570 40th Street well 2.131 14.570 263 63 17.027 28.140 (11.113) Totals $295.800 $1.953.036 $63,198 $152,641 $2,464.675 $2,469.815 $ (5.140) -37- r---- II 11 . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Direct Expenses of Other Plant Facilities For the Year Ended June 30. 1994 Materials Outside and Service 1993-94 1992-93 Increase Salaries Power SunnDes and Otber Total Total fDecrease) Chlorination through production facilities $ 1.777 $22.336 $ 24.113 $ 25.064 $ (951) Sycamore Canyon reservoir 4.168 $ 19 1.505 5.692 6.399 (707) Sycamore Canyon pumping station #1 1.647 $ 301 565 2.513 1.904 609 Sycamore Canyon pumping station #2 1.830 309 1.849 3.988 1.922 2.066 Del Rosa reservoir # I 3.946 8.846 113 12.905 14.906 (2.001) Del Rosa reservoir #2 8.407 3.122 11.529 6.017 5.512 Del Rosa reservoir #3 9.097 1.800 1.068 11.965 7.771 4.194 QuaiI and Daley Canyon reservoir 8.844 158 21 9.023 6.816 2.207 Electric Drive reservoir 11.690 39.127 4.079 4.166 59.062 58,477 585 San Bernardino Heights reservoir 5.337 5.337 1.391 3.946 Shandin Hills reservoir #1 4.549 2.191 495 4.575 11.810 5.916 5.894 Shandin Hills reservoir #2 4.664 5.227 495 220 10.606 10.174 432 40th and Harrison pumping station 66 66 120 (54) Ridgeview pumping station 2.373 3.065 22 5.460 7.463 (2.003) Meyers Canyon reservoir 12.999 12.679 2.972 2,433 31.083 25.568 5.515 Ridgeview reservoir 3.355 (11) 3.344 2.241 1.103 Palm A venue reservoir 5.487 768 675 6.930 3.509 3,421 Devore reservoir 4,407 1.953 93 6.453 2.751 3.702 Newmark stripping towers 10.723 7.788 88.974 1.995 109.480 80.580 28.900 Waterman stripping towers 11,452 13,462 67.357 1,417 93.688 88.310 5.378 Del Rosa booster station 5.652 24,477 885 110 31.124 26.431 4.693 Delmann Heights system 561 14 575 1.602 (1.027) 17th Street GAC plant 10,068 99.128 2.100 111,296 108.092 3.204 Acacia Street well 311 13 3.461 3.785 579 3,206 Devils Canyon College 40.222 705 (71) 40,856 35,093 5.763 Sycamore booster stations #3 and #4 1,670 7,323 412 9,405 (9.752) 19.157 Foothill booster station 4.291 28,765 22 33,078 32,047 1.031 South San Bernardino system 861 861 848 13 $180.454 $153.560 $275,873 $46.140 $656.027 $552.239 $103.788 -38- II II . . - MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE Schedule of Water Production and Purchased Cost For the Year Ended June 30, 1994 Purchased Water. Per 1,000 Amount Cubic Feet Produced Water Per 1,000 Amount Cubic Feet Summary of total water production and purchased cost Total production. purchases and supplemental Direct plant production expense Direct expense of other plant facilities Cost of purchased water (including assessments) 114.969,600 1.752.688.700 656,027 Total expense before depreciation $120.000 $120.000 36.930 1.04375 $3.157.632 1.80159 Depreciation of plant facilities Totals Summary of costs per acre foot Acre feet 2,639.338 40.236.193 Cost per acre foot before depreciation $45.47 $78.48 Cost per acre foot (including depreciation of plant facilities) .Note: Includes water purchased and water produced on a substitute extraction basis. -39- . 1993-94 Total Water Per 1,000 Amount Cubic Feet 1992.93 Total Water Per 1,000 Amount Cubic Feet 1,867,658,300 1,837,940,400 $2,464,675 $2,469,815 656,027 552,239 156.930 18.556 3,277,632 1.75494 3,040,610 1.65436 793.103 .42465 803.970 .43743 $4.070.735 2.17959 $3.844,580 2.09179 42,192.415 42,192.415 $77.68 $72.07 $96.48 $91.12 -40. . II II . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Sundry Statistical Data For the Year Ended June 3D, 1994 1993.94 1992-93 Direct Production Cost Per Cost Per Plant in 1,000 Percent 1,000 Percent Exuenses Cubic Feet. Cubic Feet Production Cubic Feet Production Perris Hill $ 48,714 29,805,300 $1.6344 1. 70% $2.5616 1.07% Sierra Way (and 16th Street) 227,121 155,636,900 1.4593 8.88 1.2664 11.38 Antil pumping 197,742 73,317,200 2.6971 4.18 5.9057 1.04 Waterman A venue pumping 191,464 79,189,400 2.4178 4.52 1.8659 8.72 Mill and "D" Streets 43,366 23,157,100 1.8727 1.32 1. 7985 1.46 Lytle Creek 174,149 62,383,100 2.7916 3.56 3.2625 2.45 Seccombe well - 7th Street plants 79,689 140,632,000(1) .5666 8.02 1.5897 3.01 Cajon Pass and Vicent plant 42,490 98,572,200 .4311 5.62 .3601 5.87 "E" Street plant (23rd and 2nd Streets) 5,229 Devil's Canyon 194,924 121,258,501 1.6075 6.92 .9659 9.26 Newmark 176,316 173,007,339(2) 1.0191 9.87 1.2582 14.53 19th Street 266,284 89,640,700 2.9706 5.11 Gilbert Street 51,217 26,451,100 1. 9363 1.51 4.6765 .29 Lynwood 94,485 72,098,600 1.3105 4.11 3.0828 1.41 27th Street 3,447 2.9871 .55 Baseline and California plant 25,117 25,665,300 .9786 1.46 Ellena Bros. well 81 18,605,160(3) .0044 1.06 2.1906 .48 Cajon #1, #2 and #3 163,491 151,083,500 1.0821 8.62 1.0322 5.47 Mallory well and reservoir 16,205 5,736,100 2.8251 .33 2.4243 .33 30th and Mt. View 142,996 103,165,400 1.3861 5.89 1.5875 4.79 Olive and Garner well 115,092 80,857,900 1.4234 4.61 1.4173 7.07 LeRoy Street well 37,655 19,324,000 1. 9486 1.10 1.3348 4.98 10th and "J" Street 81,629 44,761,200 1.8237 2.55 1.505 5.89 Kenwood well 68,745 154,721,600 .4443 8.83 .3825 9.57 40th Street well 17.027 3.619.100 4.7048 .21 4.204 .38 Totals $2.464.675 1.752.688.700 $1.4062 100.00% $1.3877 100.00% .Note: The above production figures include amounts produced on a substitute extraction basis as follows: (I) 66,511,060 (2) 11,627,199 (3) 18.605.160 96.743.419 Total cubic feet -41- . 1991.92 1990-91 Cost Per Cost Per 1,000 Percent 1,000 Percent Cubic Feet Production Cubic Feet Production $1. 9529 2.49% $2.5329 1.34% 1.6537 9.04 1.4226 6.48 3.0759 3.97 1.2799 18.41 2.2608 9.34 3.1771 5.40 2.3495 1.52 1.8397 1.85 4.9054 1.98 2.6574 4.37 1.4478 5.02 1.0054 11.80 .6727 8.83 .5504 6.53 2.6454 .82 3.4625 .86 1.4906 7.35 1.0594 9.42 1.5236 10.52 1.1432 10.85 4.3092 1.86 1.5506 3.48 4.5083 .20 1.6742 2.36 2.3116 1.50 1.4418 1.39 1.5990 2.10 2.9814 .84 .7252 1.07 2.1731 1.31 1.6126 4.02 1.3811 4.13 6.2662 .33 2.4755 .30 1.5538 5.89 1.4310 7.36 1.1575 5.45 1.5320 2.74 1.2502 1.41 1.1808 11.33 1.1020 .11 .3772 2.59 1.9267 .04 $1.6811 100.00% $1.4490 100.00% -42- II '1 . . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Water System Demographics For the Year Ended June 30, 1994 Julv 1. 1993 Physical changes in water utility system Miles of main in service Gate valves in system Fire hydrants in system Water meters in use 541.2388 13,596 3,983 43,515 Water utilization (shown in eubic feet) Domestic metered services Municipal services (partially estimated) East Valley Water - exchange agreement Water reclamation plant Irrigation water - A VMW Edison - wash lines Loss and other factors 1993-94 - 3.72% 1992-93 - 5.31 % Totals Added Removed 8.3780 214 92 3,533 2.4085 28 35 3,170 1993-94 1,654,533,500 93,392,145 42,329,822 7,517,400 426,700 1.203 1,798,200,770 69,457,530 1.867 .658.300 -43- II II June 30. 1994 547.2083 13,782 4,040 43,878 1992-93 1,640,588,900 81,090,725 15,708,607 2,587,300 439,400 14.037 1,740,428,969 97.511.431 1.837.940.400 . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Distribution System Expenses For the Years Ended June 30. 1994 $ 271,126 250,354 410,988 217,384 65,066 281,625 88.380 Meter repair and maintP.nance Distribution system repairs Service connection maintenance Tools and equipment maintenance Automobile and truck maintenance Store yard, shop and yard security expense Unallocated distribution system and other II 11 1993 $ 229,941 199,192 248.775 132,234 169,638 288.740 96.593 $1.584.923 $1.365.113 -44- . II II' . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Overhead Salaries and Related Costs For the Years Ended .June 30. Board of Water Conunissioners General manager and assistant General office Engineering office, planning department and field supervision Cross-connection program (including related expenses) Vacations Sick leave, holidays, nonproductive, recruitment and other time Collections, inspection and meter reading (including related expenses) Absorption of department overhead -45- 1994 1993 $ 800 $ 832 165,736 164,078 1.346.304 1.291.342 753.708 675.806 13.657 16.351 380.100 347.865 701,465 710.577 496.267 468.339 (362.148) (780.643) $3,495.889 $2.894.547 . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of General Administrative and Overhead Expenses For the Years Ended .Tune 30. 1994 $ 387,175 156,528 191,874 1,995 464,241 127,063 7,982 49,755 148,754 39,999 149,570 5,871 1,896 2,858 Office supplies, expenses and postage Office rent Data processing expense Advertising Insurance (general) Workers' compensation and self-insurance Noninsurable accidents and vandalism losses Uniform and laundry Legal, engineering and other professional fees Audit fees Bacterial determination and water quality control Taxes Communication system expense Engineering and telemetering supplies and expense Employer contribution to employee health, life and unemployment insurance City Employees' Retirement Fuod Stores inventory adjustment Uncollectible accounts Miscellaneous gardening supplies Miscellaneous charges 842,961 877,347 3,072 79,431 4,752 148.735 ru- 11--1TI 1993 $ 385,892 156,528 177,833 870 471,625 102,417 16,143 49,639 210,686 38,729 129,926 32,988 4,356 29,984 835,779 839,056 (14,093) 69,189 5,000 163.542 $3.691.859 $3.706.089 -46- II II! . . MUNICIPAL WATER DEPARTMENT CITY OF SAN BERNARDINO WATER UTILITY ENTERPRISE FUND Schedule of Insurance Coverage Insurance coverage for the Municipal Water Department - Water. Sewer and Geothermal Utility Enterprise Funds at June 30. 1994 is summarized below: Rollins Hudig Hall - multiple insurance companies and policies. all-risk property coverage - April 30. 1994 to April 30. 1995 Per occurrence limit. excluding earthquake and flood Sub-limit for earthquake and flood Insurance Company of North America. Policy #GPPD28567078. general liability. personal injury liability and commercial automobile coverage - September 30, 1993 to September 30. 1994 General and personal injury General aggregate limit Products/completed operations aggregate limit Personal and advertising injury limit Fire damage limit Automobile Liability insurance per accident Medical limit Uninsured motorist $100,000.000 $50,000.000 $2.000.000 $2,000.000 $1,000,000 $50,000 $1.000,000 $5,000 $60,000 Hartford Fire Insurance Company Policy #KUOOOO260, primary commercial umbrella liability policy - September 30. 1993 to September 30. 1994 Per occurrence limit General aggregate limit CNA Insurance Companies. Policy #RDXI27452988, excess third- party liability coverage - September 30, 1993 to September 30. 1994 Per occurrence limit General aggregate limit Hartford Accident and Indemnity Company. Policy #MBOBD0528. burglary and robbery coverage - March 15, 1993 to March 15. 1996 Inside of premises Outside of premises Hartford Accident and Indemnity Company. Policies #86S1OO551258. #86S1OO569048. #60140801, #60140802 and #60140803, public official bonds, members of the board. each Hartford Accident and Indemnity Company. Policy #72PEBCB7807. public employees' blanket bond - March 15. 1994 to March 15, 1995 $10.000,000 $10.000.000 $5.000,000 $5.000,000 $23.000 $3.000 $1.000 $15.000 The Department is self.insured as to workers' compensation liability and material damage to rolling stock. -47.