Loading...
FY1992 Audit Report City;� /R1i��Tl✓/� CITY OF BLAIR, NEBRASKA TABLE OF CONTENTS Page INDEPENDENT AUDITORS' OPINION 1-2 COMBINED STATEMENTS: Combined Balance Sheet - All Fund Types and Account Special Revenue Funds: Groups 3-4 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (Cash Basis) and Combining Schedule of Revenues, Expenditures Actual - All Governmental Fund Types 5 Combined Statement of Revenues, Expenses and Changes in Retained Earnings/Fund Balance - Budget (Cash Individual Statement of Revenues, Basis) and Actual - All Proprietary Fund Types and Similar Trust Funds 6 General Fixed Assets Account Group: and Actual - Street Fund Statement of General Fixed Assets 7 Statement of Changes in General Fixed Assets 8 General Long -Term Debt Account Group: Changes in Fund Balance - Budget Statement of General Obligation Bonds Principal and Interest Requirements by Year of Maturity 9 Statement of Changes in General Long -Term Debt 10 Combined Statement of Cash Flow - All Proprietary Fund Types and Similar Trust Funds 11 NOTES TO FINANCIAL STATEMENTS 12-17 STATEMENTS OF INDIVIDUAL FUNDS: Special Revenue Funds: Combining Balance Sheet 18 Combining Schedule of Revenues, Expenditures and Changes in Fund Balances 19 Individual Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (Cash Basis) and Actual - Street Fund 20 Individual Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (Cash Basis) and Actual - M.I.R.F Fund 21 Enterprise Funds: Combining Balance Sheet 22 Combining Statement of Revenues, Expenses, and Changes in Retained Earnings 23 r Combining Statement of Cash Flow 24 Individual Statement of Revenues and Expenses - Budget (Cash Basis) and Actual - Blair Apartments 25 Individual Statement of Revenues and Expenses - Budget (Cash Basis) and Actual - Water 26-27 Individual Statement of Revenues and Expenses - Budget (Cash Basis) and Actual - Sewer 28 CITY OF BLAIR, NEBRASKA TABLE OF CONTENTS Page SUPPORTING SCHEDULES: Schedule of General Fund Revenues - Budget (Cash Basis) and Actual 29 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Administration Department 30 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Contingency Allowance 31 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Police Department 32 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Cemetery 33 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Fire Department 34 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Park Department 35 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Library 36 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Supervised Recreation 37 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Swimming Pool 38 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Airport 39 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Landfill 40 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Animal Control 41 Compliance Report 42 43-45 Internal Control Report EDWARD W. SCHROEDER CERTIFIED PUBLIC ACCOUNTANT 1904 SOUTH STREET BOX 486 BLAIR, NEBRASKA 68008 Honorable Mayor and Members of the City Council City of Blair, Nebraska Gentlemen: RESIDENCE: (402) 468-5253 OFFICE: (402) 426-4080 November 6, 1992 "Independent Auditor's Report" I have audited the genet;—;tl . put pose financial statements of the City of Blair, Nebraska, and the combining, individual fund, and account group financial statements of the City as of and for the year ended Ju'1y 31, 1992, as listed in the table of contents. These financial. strztemervcs arrP the ref:,ponsib ility of the entity. My responsibility is to express an opinion on these financial statements based on my audit. I conducted my audit in accordance with generally accepted auditing standards and generally accepted government auditing standards. Those standards require that I 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. I believe that my audit provides a reasonable basis for my opinion. As described more fully in Note 1, the budgetary comparisons included in the combined statements of revenues and expenditures are on the basis of cash receipts and expenditures which is different from the accrual basis on which the actual amounts are reported. The budgetary information included for the year ended July 31, 1992, has not been compiled or audited by me and, accordingly, I do not express an opinion or any other form of assurance on it. Management has elected to omit the summaries of significant assumptions and accounting policies required under established guidelines for presentation of prospective financial statements. If the omitted summaries were included in the budgeted information, they might influence the user's conclusions about the city's budgeted information. Accordingly, this budgeted information is not designed for those who are not informed about such matters. Mayor and Members of the City Council November 6, 1992 Page 2 In my opinion, the general purpose financial statements referred to above present fairly, in all material respects, the financial position of the City of Blair, Nebraska, at July 31, 1992, and the results of its operations and the changes in cash flow for its propriety fund types for the year then ended, in conformity with generally accepted accounting principles. Also, in my opinion, the combining, individual fund, and account group financial statements referred to above present fairly, in all material respects, the financial position of each of the individual funds and account groups of the City of Blair, Nebraska, at July 31, 1992, and the results of operations of such funds and the changes in cash flow of the individual proprietary funds for the year then ended, in conformity with generally accepted accounting principles. My examination was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole and on the combining, individual fund, and individual account group financial statements. The accompanying financial information listed as supporting schedules in the table of contents is presented for purposes of additional analysis and is not a required part of the financial statements of the City of Blair, Nebraska. Such information has been subjected to the auditing procedures applied in the examination of the general purpose combining, individual fund, and individual account group financial statements and, in my opinion, is fairly stated in all material respects in relation to the financial statements of each of the respective individual funds and account groups, taken as a whole. Edward W. Schroeder Certified Public Accountant CITY OF BLAIR, NEBRASKA COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS JULY 31, 1992 ASSETS Governmental Fund Types Special Debt Inventory - Prepaid expenses - Restricted assets - cash and investments - at cost - Property - net of accumulated depreciation, where applicable - Amount available in Debt Service for general long-term debt retirement Amount to be provided for retirement of general long-term debt - Contract receivable - OPPD - TOTAL ASSETS $203,038 Proprietary Fund Types General Revenue Service Cash $ 20,657 $ 35,902 $ 56,796 Receivables: - 150,715 - 136,568 Billed user fees - - - Special assessments - - 28,392 Accrued interest 256 575 1,184 Other - _ _ Investments -at cost (unrestricted) 154,000 100,000 228,000 Due from County Treasurer 28,125 - - Inventory - Prepaid expenses - Restricted assets - cash and investments - at cost - Property - net of accumulated depreciation, where applicable - Amount available in Debt Service for general long-term debt retirement Amount to be provided for retirement of general long-term debt - Contract receivable - OPPD - TOTAL ASSETS $203,038 Proprietary Fund Types Account Groups is General General r Fixed Long-term Assets Debt 4,028,736 - 245,815 ® 18,179 - - 4,549,501 - - - - 5 136,477 $314,372 $4,775,653 $ 8,367,119 $ 3,712 $4,028,736 5263,994 See Notes to Financial Statements. -3- General Capital Enterprise Insurance Improvement Funds Fund $ 64,584 $ 154,689 $ - - 150,715 - 136,568 17,868 - - 14,130 - 25,000 471,185 - - 29,292 - - 5,194 - - 743,193 3,712 - 6,780,853 - Account Groups is General General r Fixed Long-term Assets Debt 4,028,736 - 245,815 ® 18,179 - - 4,549,501 - - - - 5 136,477 $314,372 $4,775,653 $ 8,367,119 $ 3,712 $4,028,736 5263,994 See Notes to Financial Statements. -3- CITY OF BLAIR, NEBRASKA COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS JULY 31, 1992 a LIABILITIES Accounts payable Accrued interest Accrued expenses Deposits payable Bonds payable Revenue bonds payable Lease payable Total liabilities Governmental Fund Types Special Debt General Revenue Service $ 58,949 $ 10,201 $ 68,557 40,000 - - 98,949 10,201 68,557 Proprietary Fund Types General Capital Enterprise Insurance Improvement Funds Fund $ - $ 46,317 $ 595 - 42,616 - - 3,439 - - 20,261 2,310,000 2,422,633 595 Account Groups General General Fixed Long-term Assets Debt - 245,000 18,994 263,994 FUND BALANCES Contributed capital - - - - 4,320,934 - - Investment in general fixed assets - - - - - - 4,028,736 Retained earnings - - - - 1,623,552 - - - Fund balance 104,089 126,276 245,815 4,775,653 - 3,117 - Total fund balances 104,089 126,276 245,815 4,775,653 5,944,486 3,117 4,028,736 - TOTAL LIABILITIES AND FUND BALANCES 5203,038 S 136,477 $314,372 $4,775,653 $ 8,367,119 $ 3,712 $4,028,736 5263,994 See Notes to Financial Statements. -4- Special Revenue Fund 360,178 $ 125,450 Variance Favorable Budget Actual (Unfavorable) $ 24,934 $ 26,628 $ 1,694 403,083 354,253 (48,830) 5,900 13,271 7,371 (39,765) 394,152 _ 433,917 10,000 769,738 13,836 729,467 779,738 743,303 (345,821) (349,151) 111,093 115,249 (3,836) 40,271 36,435 (3,330) 4,156 (234,728) (233,902) $ 826 360,178 360,178 $ 125,450 $ 126,276 Capital Improvement Fund Variance Favorable Budget Actual (Unfavorable) 423,730 421,311 (2,419) 423,730 _ 421,311 125,000 121,185 3,815 125,0.00_ 121,185 3,815 298,730 300,126 1,396 69,700 69,700 - (490,775) (490,775) - (122,345) (120,949) $ 1,396_ 4,896,602 4,869,602 $4,774,257 $4 775,653 CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS/FUND BALANCE BUDGET (CASH BASIS) AND ACTUAL ALL PROPRIETARY FUND TYPES AND SIMILAR TRUST FUNDS FOR THE YEAR ENDED JULY 31, 1992 Enterprise Funds Insurance Fund Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) User fees $ 775,000 $ 808,506 $ 33,506 $ - $ - $ - Sale of merchandise 12,000 22,620 10,620 - - - Rental 12,000 12,000 - - - - Insurance contributions - - - 293,856 262,369 (31,487) Other 11,410 30,270 18,860 - 1,343 1,343 Total 810,410 873,396 62,986 293,856 263,712 (30,144) EXPENSES: Personal services 450,160 454,550 (4,390) - - - operating expenses 240,175 216,881 23,294 - - - Materials and supplies 72,335 72,159 176 - - - Construction contracts 151,200 20,105 131,095 - - - Rental expense 650 866 (216) - - - Depreciation - 273,048 (273,048) - - - Payments of insurance benefits - - - 296,336 275,799 20,537 Total 914,520 1,037,609 (123,089) 296,336 275,799 20,537 OPERATING INCOME (LOSS) (104,110) (164,213) (60,103) (2,480) (12,087) (9,607) OTHER REVENUE (EXPENSE): Interest income 89,700 81,653 (8,047) 100 - (100) Interest expense (177,305) (173,690) 3,615 - - - Gain (loss) on fixed assets (171,508) (169,449) 2,059 - - - Operating transfers - in 280,000 311,049 31,049 - - - Operating transfers - out (249,806_) (276,496) (26,690) - - - NET INCOME (LOSS) (333,029) (391,146) L__(58..117) (2,380) (12,087) 1__2_,,.707 RETAINED EARNINGS/FUND BALANCE - July 31, 1991 2,014,698 2,014,698 15,204 15,204 RETAINED EARNINGS/FUND BALANCE - July 31, 1992 $1,681,669 $1,623,552 $ 12,824 S 3,117 See Notes to Financial Statements. -6- CITY OF BLAIR, NEBRASKA STATEMENT OF GENERAL FIXED ASSETS JULY 31, 1992 Land Buildings Vehicles Equipment Total GENERAL FUND: Administration $ 15,000 $ 696,695 $ 13,730 $ 137,256 $ 862,681 Police - - 63,668 54,884 118,552 Cemetery 115,000 18,084 - 15,009 148,093 Fire - - 366,457 48,447 414,904 Park 97,952 358,873 1,250 115,256 573,331 Library 22,500 116,600 - 26,637 165,737 Supervised recreation - 274 - 27,375 27,649 Swimming pool 100,000 237,581 - 165,461 503,042 Airport 32,000 137,069 - 51,377 220,446 Landfill 15,000 6,700 - 82,007 103,707 Animal control - 5,686 13,450 1,744 20,880 SPECIAL REVENUE FUNDS - Street 10,000 55,=90 215,797 385,023023 GGG,310 CAPITALIZED LEASE - - 203,404 Library TOTALS -___._ J407,452 _ 203,404 $1,836,456 5674,352$1,110,476 $4,028,736 See Notes to Financial Statements. -7- r., CITY OF BLAIR, NEBRASKA STATEMENT OF CHANGES IN GENERAL FIXED ASSETS FOR THE YEAR ENDED JULY 31, 1992 Balance July 31, 1991 Additions. Dispositions GENERAL FUND: Administration Police Cemetery Fire Park Library Supervised recreation Swimming pool Airport Landfill Animal control. SPECIAL REVENUE FUNDS - Street CAPITALIZED LEASE - Library TOTALS Balance July 31, 1992 $ 846,844 $ 15,837 $ - $ 862,681 108,280 22,670 (12,398) 118,552 148,093 - - 148,093 288,324 126,580 - 414,904 545,370 27,961 - 573,331 163,551 2,186 - 165,737 21.,139 '7,875 (1,365) 27,649 503,042 - - 503,042 220,446 - - 220,446 103,707 - - 103,707 12,130 13,450 (4,700) 20, 880 669,690 203,404 $3,834,020 21,312 (24,692) 666,310 203,404 5237.871 S(43,155) $4,028,736 See Notes to Financial Statements. -8- Year Ending July 31,__ 1993 1994 1995 1996 1997 1998 1999 2000 CITY OF BLAIR NEBRASKA STATEMENT OF GENERAL OBLIGATION BONDS PRINCIPAL AND INTEREST REQUIREMENTS BY YEAR OF MATURITY JULY 31, 1992 — Principal Requirements $ 65,109 40,534 40,994 22,357 20,000 25,000 25,000 122_6 32_9 Interest Requirements Total $ 24,166 $ 89,275 14,447 54,981 10,264 51,258 6,370 28,727 5,155 25,155 3,826 28,826 2,312 27,312 175 ___2_5_, 7 7 5 67,315 5331,309 See Notes to Financial Statements. -9- STATEMENT OF CHANGES IN GENERAL LONG-TERM DEBT FOR THE YEAR ENDED JULY 31, 1992 «_ 8aa Notes to Financial Statements. «/ -18- alaooe Balance Interest July 31, July 31, Dated Description Rate 1991 Additions Deductions 1992 6/15/88 Various purpose 5.25-6.40% $120,000 $ - $ 45,000 $ 75,000 1/01/91 IBM financing lease 8.06% 23,775 - 4,781 18,994 10/15/91 Fire department bonds 5.00-6.20& - 17O,DOO - 170,800 Stammozmao Iao8 contract 13.80% fi���� - ____8�lL0l� TOTAL LL,51,775 Jj70,000 $, =-41 / 8aa Notes to Financial Statements. «/ -18- CITY OF BLAIR. NEBRASKA COMBINED STATEMENT OF CASH FLOW ALL PROPRIETARY FUND TYPES AND SIMILAR TRUST FUNDS FOR THE YEAR ENDED JULY 31, 1992 General Enterprise Insurance Funds Fund CASH FLOW FROM OPERATIONS: Net operating income (loss) $(164,213) $(12,087) Adjustment to reconcile net restricted assets (9,909) - income to net cash from operations: (173,690) Depreciation 273,048 (3,615) - Decrease in accounts receivable -user fees 7,000 - Decrease (increase) in accounts receivable IN CASH (93,726) 3,712 -other (13,227)_27) 19,872 Decrease in inventory 738 - Increase in prepaid expenses (233) - Increase (decrease) ill accounts payable 1.7,456 595 Decrease in accrued expenses 396 Increase (decrease) in deposits payable X14,710) Net cash provided (used) by operations 106.255 8.380 CASH FLOW FROM INVESTING: Purchase of property (170,349) - Proceeds from sale of: property 151,852 Interest income 81,653 Transfers - net 34,553 - Decrease (increase) in accrued interest receivable 4,856 - Decrease (increase) in due from other funds 4,668 (4,668) Cash from investing 107.233 X4,668) CASH FLOW FROM FINANCING: Reduction of long-term debt (120,000) - Increase in restricted assets (9,909) - Interest expense (173,690) Decrease in accrued interest payable (3,615) - Cash from (used in) financing (307,214) - NET INCREASE (DECREASE) IN CASH (93,726) 3,712 CASH AND CASH EQUIVALENTS - Beginning of the period 719,600 - CASH AND CASH EQUIVALENTS - End of the period $ 625,874 3,712 See Notes to Financial Statements. CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Blair accounts for its financial position and results of operations in accordance with generally accepted accounting principles applicable to governmental units. Accordingly, ' the City uses several funds and account groups which are described below. A. Fund Types and Account Groups: A fund or account group is an accounting entity with a self -balancing set of accounts established to record the financial position and results of operations of a specific governmental activity. The City maintains the following fund types and account groups: Governmental. fund types, that include the General Fund, Special Revenue Funds, and the Debt Service rund, are used to record the general operations of the City; C Proprietary fund types, that are used to account for activities conducted on a fee for service basis in a manner similar to commercial enterprises, provide services to the public (enterprise funds); Fiduciary fund types (trust and insurance funds), that are used to account for assets held by the City as an agent for private individuals or organizations or in trust; ( General fixed assets and general. long-term obligation account groups, that are used to account for property and equipment and long-term obligations of governmental funds. General long-term bonded debt was repaid through the Debt Service Fund. B. Reporting Entity: All significant activities and organizations on which the City exercises oversight responsibility have been included in the City's general purpose financial statements, for the year ended July 31, 1992. The following criteria regarding manifestation of oversight were considered by the City in its evaluation of the City organizations and activities: Financial interdependency -The City is responsible for its debts and is entitled to surpluses. No separate agency receives a financial benefit nor imposes a financial burden on the City. Election of the government authority -The locally elected City Council is exclusively responsible for all public decisions and accountable for the decisions it makes. -12- CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS,_ Continued 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Designation of management -The City Council appoints the City 4 Administrator. The City Administrator hires other members of City management. The activities under the purview of management are within the scope of the reporting entity and management is accountable to the City Council for the activities being managed. Ability to significantly influence operations -The City Council has the statutory authority under the provisions of the Revised Statutes to significantly influence operations. This authority includes, but is not limited to, adoption of the budget, control over all. assets, including facilities and properties, short term borrowing, signing contracts, and developing the programs to be provided. Accountability of fiscal matters -The responsibility and accountability over all funds is vested in the City management. C. Basis of Accounting: All governmental fund types are accounted for using the modified accrual basis of accounting. Their revenues are recognized when earned and expenditures are recognized when incurred except in the case of property tax revenues recognized when received, and in the recording of interest on general obligation bonds only when the coupons mature. The proprietary fund types and similar trust funds are accounted for using the accrual basis whereby revenues are recognized when earned and expenses are recognized when incurred. The City does not apply encumbrance accounting in any of its funds. I`s D. Debt Service Fund: The Debt Service Fund is used to account for the payment of principal and interest on general long-term debt. The primary sources of revenue are property taxes and special assessments. E. Inventory: Inventory is stated at first -out) or market value. used in regard to inventory the lower of cost (first -in, The consumption method is expenditure recognition. CITY OF BLAIR. NEBRASKA NOTES TO FINANCIAL STATEMENTS, Continued 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) F. Property: All fixed assets are recorded at cost or estimated cost, if actual cost is not available. The proprietary and fiduciary fund assets are presented on the respective balance sheets except for the cost of any underground utility lines which are not included in the assets. Depreciation of the assets is computed on a straight-line method over the estimated useful lives of the assets. The range of estimated lives is from five to fifty years. Assets in other than proprietary and fiduciary funds are recorded a:3 expenditures at the time of purchase with the accumulated cost being presented in the general fixed asset group of accounts. Certain improvements such as roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, and lighting systems are not capitalized. No depreciation is provided for assets in the general fixed asset group of accounts. G. Budgetary Basis: The City's legally adopted budget is based on requirements of the State of Nebraska. The budget is prepared and adopted using the cash basis of accounting whereby revenues are budgeted when expected to be received rather than earned and expenditures are budgeted when expected to be disbursed rather than incurred. H. Compensated Absences: The City of Blair does not record accrued compensated absences as they are unmeasurable as of July 31, 1992. I. Investments: The Investments are bank Certificates of Deposits or U.S. Government Securities with no unusual restrictions other than penalty for early withdrawal. All unrestricted investments are short-term. Investments are stated at cost, which approximates market value. All investments are entirely insured or collateralized with U.S. Government Securities and are considered cash equivalents. 1. The City's investments are categorized to give an indication of the level of risk assumed by the City at year end. The City's investments are all category 1 which means that the investments are insured or registered or the securities are held by the City or its agent in the City's name. -14- CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS, Continued 2. RESTRICTED ASSETS Restricted assets consist primarily of cash, certificates of deposit, and government securities. The assets are restricted as follows: t- Enterprise Insurance Funds Funds Bond and interest sinking funds $722,932 $ - Utility deposit funds 20,261 - Reserve for insurance claims - 3,712 r Total restricted assets 743 193 3 71 2 3. LONG-TERM DEBT Water Bonds: 6/15/88 Year Ending July 31, 1993 1994 1995 1996 1997 1998-2014 TOTAL 4. PENSION PLANS 5.15-8.00% Total $2,310,000 Annual Principal Requirements For Water Bonds $ 130,000 135,000 145,000 55,000 55,000 1,790,000 $2,310,_000 The city has two pension plans covering substantially all of its employees. Employees other than policemen are covered by a defined contribution plan. All contributions up to 4% of gross wage in employee contributions and 40 of gross wage in contributions from the City are invested with an investment manager. The employees must have accumulated one year of service to participate in the plan. The plan is a single employer plan with the City maintaining fiduciary responsibility for it. Contributions for the fiscal year ended July 31, 1992, were $55,321 and are expected to remain relatively level from year to year. -15- CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS, Continued 4. PENSION PLANS (Continued) The policemen are covered under a defined benefit plan established by the statutes of the State of Nebraska.Policemen terminating before retirement age receive payment for their contributions to date of termination plus interest accrued and vested portion of the City's contributions based on the statutes of the State of Nebraska. The City has fiduciary responsibility for the plan and it is a single employer plan only. Current year contributions of $35,859 were 12% of gross wages which, compiles with statutory requirements. The City contributed 6% of gross wages and the policemen contributed 6%. The City has no material pension benefit obligations as of January 1, 1990, per Actuarial Report dated November 7, 1990. The City does expect contributions to remain relatively level from year to year. During the year ended July 31, 1984, the City transferred police pension funds to an independent trustee for investment. The trustee will maintain the fund according to state law. This change in pension fund maintenance eliminated the need for the police pension fund. Contributions to the trustee were reported as an expenditure during the year ended July 31, 1992. 5. OTHER ASSET - ELECTRIC PLANT CONTRACT In April 1984, the City of Blair contracted to sell its electrical transmission and distribution generating facilities to the Omaha Public Power District. The terms of the agreement were as follows: Omaha Public Power District agreed to buy the City of Blair facilities for the sum of $5,950,000. The terms of payment shall be $1,000,000 payable at the date of the contract and the balance of $4,950,000 -amortized over thirty years at nine percent interest per annum, with annual payments of $481,815 commenced in April 1985. This contract is unsecured. This contract also provided for the Omaha Public Power District to supply electrical service directly to the City and its residents. The transfer of electrical services was completed on July 31, 1984. 6. LANDFILL CLOSURE ACCRUAL r The City of Blair has approved a plan to close its landfill operations. Anticipated closing and monitoring costs accrued over the remaining life of the landfill required an accrued expense for i the General fund as of July 31, 1992, in the amount of $40,000. -16- CITY OF BLAxRR NEBRASKA NOTES TO FINANCIAL STATEMENTS. Continued 7. ACCOUNTS RECEIVABLE - SPECIAL ASSESSMENTS The City of Blair's special assessments outstanding as of July 31, 1992, are composed of the following: Special assessment principle and current interest $ 6,192 Special assessment available not levied 22,200 Total Special Assessments Receivable 1_11,392 The receivable is secured by tax liens on the property assessed. The City received property in .foreclosure for special assessments in the amount of $120,716 during fiscal year end July 31, 1992. The property was given a zero carry value in the financial statements. 8. LEASE COMMITMENTS The City of Blair has the following lease commitments: Lease Number Lease _Date Terms Annual Amount 97184 3-06-79 Renewed in991 d years $180 97021 6-26-78 Renewed in 1988 for 5 years $180 97295 9-07-79 One year $100 98565 8-01-83 Renewed in 1988 for 5 years $180 9. INSURANCE FUND The City of Blair self -insures certain dental and eye benefits for its employees. Effective July 1, 1991, the City no longer has self-insured medical benefits. Funds were contributed from various funds into the insurance fund for proper allocation. The contributions into the fund for July 31, 1992, were $263,712. Dental and vision benefits are limited and do not create significant risk for the City. -17- -18- CITY OF BLAIR, NEBRASKA COMBINING BALANCE SHEET - SPECIAL REVENUE FUNDS JULY 31, 1992 ASSETS F Street M.I.R.F. w Fund Fund Total CASH SAVINGS $ 15,592 $ 20,310 $ 35,902 INVESTMENTS 100,000 - 100,000 ACCRUED INTEREST RECEIVABLE 4 575 - 575 TOTAL X116,167 S 20,310 $136,477_ Y LIABILITIES AND FUND BALANCES ACCOUNTS PAYABLE $ 10,186 $ 15 $ 10,201 FUND BALANCE 105,981 2095 126,276 TOTAL ,116,167 1 20,310 $136,477 -18- � COMBINING SCHEDULE OF REVENUES, 8X2UNUIcuuEm, AND CHANGES IN FUND BALANCES SPECIAL REVENUE FUNDS �.FOR THE YEAR ENDED JULY 31,1992 o Street M,I.B.F. Fund Fund Total\ REVENUES: Street revenues $354,253 $ - $354,253 - M.I.B.F, ravauoeo - 26,628 26,628 � Interest on investments 13,242 29 13,271 Other revenues Total revenues _�L67-,.£95 --26,.65-� 394,152 ' EXPENDITURES: Salaries 140,975 - 14O,S7S , FICA 10,596 - 18,556 ' Retirement 7,758 - 7,750 Employee tueuraooa 32,495 - 32,495 -` Legal - - - � Engineering 670 - 670 Auditing 1,663 - 1,663 ` Office expenses 158 - 158 Doao 179 - 179 - Utilities 3,687 - 3,687 Talmgboua 706 - 706 , Travel 161 - 161 Training 192 - 192 Insurance 10,909 - 1O,909 ' Maintenance 38,939 - 30,939 Street lighting 82,306 - 82,306 Contingency reserve - - - 600 Car expense 600 - 6 County Treasurer fees 6 - Sand, gravel and rook 8,367 - 8,367 | Gas, diesel and oil 10,237 - 10,237 �! Materials and supplies 2,512 - 2,512 ' Rental 3,434 - 3,424 Capital outlay" Building 5,700 3,386 9,086 Motorized equipment 15,612 18,450 26,062 ^^ Street improvements _359u3 � _�=��_��� Total expenditures _729,46L7 13z�136 743,303 ' REVENUES OVER (UNDER) QXPENDITDBEG` (361,972) 12,821 (349,151) OTHER FINANCING SOURCES (D8Q8), - 115,249 ` Operating transfers - iu 11S,2�9 Operating transfers - out BE\/E0DE8 OVER (D�O�B) ` EXPENDITURES (246,733) 12,821 (233,9O2) « FUND BALANCE (DEFICIT)- ' � » Jull, 31, 1991 352,704 ___-7-.4 360,178 FUND BALANCE - July 31, 1992 x- $1l�5,981 $_20,295 $�L276 ��� -19- CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (CASH BASIS) AND ACTUAL SPECIAL REVENUE FUNDS - STREET FUND FOR THE YEAR ENDED JULY 31 1992 Variance Favorable Budget Actual (Unfavorable) REVENUES: Highway allocation County road tax Motor vehicle pro rata Incentive payment State maintenance agreement Curb and street cutting Sale of rock Equipment rental Interest on investments Reimbursed expenses Sale of street building Total Revenues EXPENDITURES: Salaries FICA Retirement Employee insurance Legal Engineering Auditing Office expense Dues Utilities Telephone Travel Training Insurance Maintenance Street lighting Contingency reserve Car expense County Treasurer fees Sand, gravel, and rock Gas, diesel, and oil Materials and supplies Rental Capital outlay: Buildings Motorized equipment Street improvements Total expenditures REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES): Operating transfers -in Operating transfers -out REVENUES OVER (UNDER) EXPENDITURES FUND BALANCE - JULY 31, 1991 FUND BALANCE - JULY 31, 1992 $ 315,000 $314,507 $ (493) 1,000 566 (434) 3,500 - (3,500) 3,000 3,000 - 14,533 14,532 (1) 500 144 (356) 300 414 114 250 1,581 1,331 5,500 13,242 7,742 30,000 19,509 (10,491) _ 35,000 - (35,000) 408,583. 367,495 (41,088) 160,198 140,975 19,223 12,255 10,556 1,699 6,550 7,750 (1,200) 35,040 32,495 2,545 400 - 400 3,000 670 2,330 1,570 1,663 (93) 200 158 42 200 179 21 5,100 3,687 1,413 1,000 706 294 200 161 39 100 192 (92) 11,600 10,909 691 19,000 30,939 (11,939) 80,000 82,306 (2,306) 3,000 - 3,000 600 600 - - 6 (6) 11,500 8,367 3,133 10,500 10,237 263 3,425 2,512 913 5,000 3,424 1,576 30,000 5,700 24,300 24,000 15,612 8,388 345,300 _359,663 (14,363) 769,738 729,467 40,271 (361,155) (361,972) (817) 111,093 115,249 4,156 -20- (250,062) 352,704 102,642 (246,723) $ 3,339 _352,704 $1051981 CITY OF BLAIR, NEBRASKA_ INDIVIDUAL STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (CASH BASIS) AND ACTUAL SPECIAL REVENUE FUNDS - M.I.R.F. FUND FOR THE YEAR ENDED JULY 31_1992 REVENUES: M.I.R.F. revenues Interest income Total revenue EXPENDITURES: Recycling center REVENUES OVER (UNDER) EXPENDITURES FUND BALANCE - July 31, 1991 FUND BALANCE - July 31, 1992 -21- Variance Favorable Budget Actual (Unfavorable) $ 24,934 $ 26,628 $ 1,694 400 29 (371) 25,334 26,657 1,323 10,000 113,836 ,j3,836) 15,334 12,821 $ (2,513) 7,474 7,474 9 22.808 S 20.295 (This page left blank intentionally) LIABILITIES AND FUND BALANCE Blair Apartments Water Sewer Total CURRENT LIABILITIES: Current portion of long-term debt $ - $ 130,000 $ - $ 130,000 Accounts payable - 30,061 16,256 46,317 Accrued interest - 42,616 - 42,616 Accrued expenses - 3,439 _ - 3,439 Total current liabilities -__- _ 206.L_1 16 -_� 16,.256 222,372 DEPOSITS PAYABLE _- -___20_,._261 - _ 20,261 LONG-TERM DEBT: Revenue bonds payable- - 2,310,000 - 2,310,000 2,310,000 Less current portion above _ - (130,000) - (130,000) Long-term debt -net - 2,180,000 - 2,180,000 Total liabilities - 2,406,377 16,256 2,422,633 FUND BALANCE: Contributed capital - 1,550,100 2,770,834 4,320,934 Retained earnings: Reserved - 743,193 - 743,193 Unreserved - 1,771,155 890`-796) 880,359 Total fund balance - 4,064,448 1,880,038 5,944,486 TOTAL LIABILITIES AND FUND BALANCE S - $6,470 825 $1,896,294 $ 8,367,119 CITY OF BLAIR, NEBRASKA COMBfNING STATEMENT OF REVENUES, EXPENSES 'IND CHANGES IN RETAINED EARNINGS ENTERPRISE FUNDS FOR THE YEAR ENDED JULY 31, 1992 Blair Apartments Water Sewer OPERATING REVENUES: User fees $ - Sale'of merchandise - Rental ' Other Total - EXPENSES: Personal services - Operating expenses - Materials and supplies - Rental expense Construction contracts - Depreciation Total OPERATING INCOME (LOSS) - OTHER REVENUE (EXPENSE): 21,420 Interest income - Interest expense - Gain (Loss) on fixed 23,535 assets (169,449) Operating transfers -in - Operating transfers -out (151,711) NET INCOME (LOSS) (321,160) RETAINED EARNINGS (DEFICIT) 131,196 July 31, 1991 321,160 RETAINED EARNINGS (DEFICIT) 16,603 July 31, 1992 $ - c -23- Total $ 577,164 $ 231,342 $ 808,506 21,420 1,200 22,620 12,000 - 12,000 23,535 6,735 30,270 634,119 239,277 873,396 314,933 139,617 454,550 131,196 85,685 216,881 55,556 16,603 72,159 606 260 866 11,125 8,980 20,105 197,176 75,872 273,048 710,592 327,017 1,037,609 (76,473) (87,740) (164,213) 74,709 6,944 81,653 (173,690) - (173,690) - - (169,449) 311,049 - 311,049 (121,044.) (3,741) (276,496) 14,551 (84,537) (391,146) 2,499,797 (806,259) 2,014,698 $2,514,348 $(890,796) $1,623,552 CITY OF BLAIR, NEBRASKA COMBINING STATEMENT OF CASH FLOW ENTERPRISE FUNDS FOR THE YEAR ENDED JULY 31, 1992 CASH FLOW FROM OPERATIONS: Net operating income (loss) Adjustment to reconcile net income to net cash from operations: Depreciation Decrease (increase) in accounts receivable - user fees Increase in accounts receivable - other Decrease (increase) in inventory Decrease (increase) in prepaid expenses Increase (decrease) in accounts payable Increase (decrease) in accrued expenses Increase (decrease) in deposits payable Net cash provided (used) by operations CASH FLOW FROM INVESTING: Purchase of property Proceeds from sale of property Interest income Transfers - net Decrease (increase) in accrued interest receivable Decrease (increase) in due from other funds Cash flow from (used in) investing CASH FLOW FROM FINANCING: Reduction of long-term debt Decrease (increase) in restricted assets Interest expense Increase (decrease) in accrued interest payable Cash flow from (used in) financing NET INCREASE (DECREASE) IN CASH CASH AND CASH EQUIVALENTS - Beginning of the period CASH AND CASH EQUIVALENTS - End of the period Blair Apartments Water Sewer Total $ - $ (76,473) $ (87,740) $(164,213) - 197,176 75,872 273,048 - 7,334 (334) 7,000 - (6,492) (6,735) (13,227) - 738 - 738 - (88) (145) (233) (154) 9,382 8,228 17,456 - 396 - 396 - (14,710) - (14,710) (154) 117,263 (10,854) 106,255 - (140,899) (29,450) (170,349) 151,852 - - 151,852 - 74,709 6,944 81,653 (151,711) 190,005 (3,741) 34,553 - 4,781 75 4,856 - 4,668 - 4,668 141 133,264 (26,172) 107,233 (120,000) - (120,000) (9,909) - (9,909) (173,690) - (173,690) - (3,615) (307,214) - (307,214) (13) (56,687) (37,026) (93,726) 13 580,069 139,518 719,600 $ 523,382 $102,492 $ 625,874 CITY OF BLA7'R, NEBRASKA INDIVI)UAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND •- BLAIR APARTMENTS FOR THE YEAR ENDED JULY 31, 1992 OTHER REVENUE (EXPENSE) Loss on fixed assets Transfers out NET INCOME (LOSS) Budget $(171,508) (149,806) $(321.314) -25- Variance Favorable Actual (Unfavorable) $(169,449) $ 2,059 (151,711) (1,905_) $(321,160) $ 154 CITY OF BLAIR, NEBRASKA INDIVI UAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - WATER FOR THE YEAR ENDED JULY 31,1992 -26- Variance Favorable Budget Actual (Unfavorable) OPERATING REVENUES: fees $5 40,000 $577,164 $ 37,164 User Sale of merchandise 10,000 21,420 11,420 Forfeited discounts 6,500 6,460 (40) Hydrant rental 12,000 12,000 - Other 4,910 17,075 12,165 Total revenues 573,410 634,119 60,709 EXPENSES; Personal services: 240,819 241,556 (737) Salaries - 17,876 (17,876) FICA Workman's compensation 6, 9,364 136 HAL insurance 41,999292 39,206 2,786 Retirement (city share) 11,149 9,861 1,288 Unemployment compensation 100 70 30 Total 300,560 314,933 (14,373) Operating expenses: 500 777 (277) Legal fees Auditing 1,400 1,463 (63) Consultants/engineering 5,000 5,258 (258) Employee appreciation 900 412 488 Postage 4,800 5,105 (305) Printing and publications 1,050 476 574 Computer programming 1,000 993 7 Schools, travel, and training 1,550 1,043 507 Dues 2,400 2,477 (77) Utilities 90,500 76,558 13,942 Telephone 2,400 2,172 228 Vehicle insurance 575 1,080 (505) Liability insurance Buildings and contents insurance 2,000 4,800 1,466 4,277 534 523 Employee bonds 150 144 6 Radio maintenance 750 210 540 Office equipment maintenance 1,300 513 787 Motorized equipment maintenance 2,750 1,823 927 Building maintenance 4,000 7,270 (3,270) Major maintenance 10,000 8,670 1,330 Contingent reserve 8,000 4,500 3,500 Maintenance agreements 4,200 4,125 75 Car expense 384 384 - 100 Bad accounts 100 150,509 - 131,196 19,313 Total - continued - -26- CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - WATER FOR THE YEAR ENDED JULY 31, 1992 -27- Variance Favorable - continued - Budget Actual (Unfavorable) EXPENSES: Materials and supplies: Office supplies $ 2,300 $ 1,903 $ 397 Janitorial supplies 325 220 105 Stores and supplies 1,500 2,587 (1,087) Chemicals 32,000 36,189 (4,189) Supplies for inventory 8,000 8,537 (537) Gasoline 4,000 2,415 1,585 Clothing allowance 1,000 530 470 Small tools 650 1,742 (1,092) Construction contracts 115,000 11.,125 103,875 Other materials and supplies 5,010 1,4:33 3,577 Total 169,785 66,681 103,104 Rental expense - Office equipment 450 606 - 156) Total expenses 621,304 513,416 107,888 OPERATING INCOME (LOSS) BEFORE DEPRECIATION (47,894) 120,703 168,597 DEPRECIATION - (197,176) (197,176) OPERATING INCOME (LOSS) (47,894) (76,473) (28,579) OTHER REVENUES (EXPENSES): Interest income 83,500 74,709 (8,791) Interest expense (177,305) (173,690) 3,615 Operating transfers - in 280,000 311,049 31,049 Operating transfers - out (100,000) 1121,044) (21,044) NET INCOME (LOSS) $ 38,301 $ 14,551 $(23,750) -27- CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - SEWER FOR THE YEAR ENDED JULY 31 1992 OPERATING REVENUES: User fees Sale of merchandise Total revenues EXPENSES: Personal services: Salaries FICA Workman's compensation H.A.L. insurance Retirement (city share) Unemployment compensation Total Operating expense: Legal Auditing Consulting/engineering Employee appreciation Postage Printing and publication Computer programming School, travel, and training Dues Utilities Telephone Insurance Maintenance Car expense Contingent reserve Total Materials and supplies Construction contracts Rental expense Total expenses OPERATING INCOME (LOSS) BEFORE DEPRECIATION DEPRECIATION OPERATING INCOME (LOSS) OTHER REVENUE (EXPENSE): Interest income State reimbursements -Hwy 75 Transfer - out NET INCOME (LOSS) Budget $235,000 2,000 237,000 115,159 8,810 1,600 16,332 7,599 100 149,600 200 650 1,500 400 2,000 475 400 1,050 1,400 51,500 850 6,925 17,100 216 5,000 89,666 17,550 36,200 200 293,216 (56,216) (56,216) 6,200 $(50,016) -28- Actual $231,342 1,200 _232,542 106,206 7,863 1,459 18,454 5,614 21 139,617 26 665 3,533 242 1,993 226 516 434 1,906 46,982 798 6,742 19,406 216 2,000 85,685 16,603 8,980 260 251,145 (18,603) (75,872) (94,475) 6,944 6,735 (3,741) $(84,537) Variance Favorable (Unfavorable) $ (3,658) (800) (4,458) 8,953 947 141 (2,122) 1,985 79 9983 174 (15) (2,033) 158 7 249 (116) 616 (506) 4,518 52 183 (2,306) 3,000 3,981 947 27,220 (60) 42,071 37,613 (75,872) (38,259) 744 6,735 (3,741} $(34,521) CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND REVENUES BUDGET (CASH BASIS) AND ACTUAL FOR THE YEAR ENDED JULY 31, 1992 -29- Variance Favorable Budget Actual (Unfavorable) REVENUES: Taxes: Property taxes $ 661,541 $ 605,469 $(56,072) Insurance tax 30,500 32,557 2,057 Receipts in lieu of taxes 50,500 49,322 (1,178) Personal property tax relief - 33,150 33,150 State aid 97,500 104,137 6,637 Homestead relief 34,500 31,595 (2,905) Franchise tax 58,200 64,266 6.066 Total 932,741 920.496 (12,245) Licenses and permits: Business licenses 15,550 17,961 2,411 Dog licenses 1,200 2,941 1,742 Permits and fees 8,600 19,887 11,287 Total 25,350 40,790 15,440 Charges for services: Library 7,000 11,293 4,293 Landfill collections 105,500 105,014 (486) Cemetery lots 10,000 11,420 1,420 Grave openings 12,500 16,300 3,800 Swimming pool fees 19,500 15,585 (3,915) Swimming pool lessons 3,500 5,098 1,598 Sales of fireworks 6,800 7,500 700 Building and land leases 5,200 _ 7,580 ?..0 Total 170,000 179,790 9,790 INTEREST INCOME 6,500 11,380 4,880 OTHER REVENUES: 87,000 31,323 (55,677) Grants Gifts 1,600 2,197 597 Police lab fund 1,200 3,303 2,103 County inspector payments 23,055 23,176 121 Other miscellaneous revenue - 21,511 21,511 Total 112,855 81,510 (31,345) TOTAL REVENUES $1,247,446 $1,233,966 $(13,480) -29- CITY OF BLAIR, NEBRASKA SCf3EDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL ADMINISTRATION DEPARTMENT FOR THE YEAR ENDED JULY 31, 199.2 PERSONAL SERVICES: Salaries Social security Employee's insurance Retirement OPERATING EXPENSES: Legal Building inspection Auditing Civil defense Consulting Custodial services Employee appreciation Postage Printing and publications Dues and training Election expense Programming City utilities Telephone Travel expense Insurance and bonds Maintenance Tree stump removal Tobacco licenses Chamber of Commerce Gas and oil County Treasurer's collection fees Miscellaneous SUPPLIES RENTAL EXPENSES - Office equipment CAPITAL OUTLAY Office equipment TOTALS -30- Variance Favorable Budget Actual (Unfavorable) $ 82,890 $ 80,602 $ 2,288 6,400 5,965 435 67,820 60,720 7,100 3,950 2,921 1,029 26,500 22,136 4,364 3,600 3,150 450 875 931 (56) 1,800 1,800 - 400 756 (356) 2,700 2,505 195 1,100 910 190 1,900 1,904 (4) 5,800 7,457 (1,657) 5,900 4,862 1,038 1,500 774 726 1,500 1,845 (345) 2,400 2,243 157 4,100 3,957 143 2,500 1,501 999 4,900 5,592 (692) 4,500 1,869 2,631 13,500 10,699 2,801 850 411 439 7,500 7,700 (200) 1,250 734 516 6,822 6,794 28 100 2,074 (1,974) 3,600 4,089 (489) 900 968 (68) 4,620 2,000 2,620 $272,177 $249,869 $ 22,308 -30- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL CONTINGENCY ALLOWANCE FOR THE YEAR ENDED JULY 3.1, 1992 Variance Favorable Bu4aet Actual (Unfavorable) PARK MOWER - $ 7►875 ANIMAL CONTROL VAN _13,450 TOTAL $20,000 $21,325 S(1,325) -31- CITY OF GLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL POLICE DEPARTMENT FOR THE YEAR ENDED JULY 31, 1992 PERSONAL SERVICES: Salaries Social security Employees' insurance Retirement OPERATING EXPENSES: Legal Auditing Postage Printing and publications Training Telephone Travel Dues Insurance Maintenance Medical exams Miscellaneous SUPPLIES: Office supplies Gas and oil Uniforms Ammunition and range Miscellaneous RENTAL EXPENSE CAPITAL OUTLAY: Office equipment Motor vehicles Radio equipment TOTALS Variance Favorable Budget Actual (Unfavorable) $330,156 $315,226 $14,930 25,256 23,425 1,831 58,160 53,346 4,814 19,300 17,930 1,370 11,500 14,603 (3,103) 875 933 (58) 800 851 (51) 1,000 709 291 3,000 3,219 (219) 4,900 4,017 883 1,000 1,049 (49) 300 390 (90) 8,100 .7,287 813 10,000 9,224 776 400 242 158 300 1,056 (756) 9,923 9,192 731 11,700 12,126 (426) 8,600 7,485 1,115 2,045 2,116 (71) 600 539 61 12,500 17,874 (5,374) 3,800 3,605 195 15,000 14,821 179 5,460 4,241 1,219 $544,675 $525,506 119,169 -32- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL CEMETERY FOR THE YEAR ENDED JULY 31, 1992 PERSONAL SERVICES: Salaries Social security Employees' insurance Retirement OPERATING EXPENSES: Legal Auditing Printing and publications Training Travel Dues Construction Heating fuel Utilities Telephone Insurance Maintenance Miscellaneous SUPPLIES: Operating supplies Gas/Oil/Diesel Uniforms Small tools Sand/Gravel/Rock RENTAL EXPENSE CAPITAL OUTLAY: Motorized equipment TOTALS Variance Favorable Budget Actual (Unfavorable) $36,910 $34,176 $ 2,734 2,825 2,560 265 6,040 5,793 247 1,000 1,081 (81) 120 - 120 75 73 2 220 241 (21) 150 170 (20) 50 4 46 50 80 (30) 2,500 2,561 (61) - 14 (14) 1,650 1,615 35 425 414 11 1,585 1,578 7 3,950 4,034 (84) 1,000 249 751 600 752 (152) 1,600 1,390 210 280 144 136 225 1,214 (989) 700 634 66 9,900 11,375 (1,475) 1,000 1,000 $72,855 $70,152 1_2_,_703 -33- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL FIRE DEPARTMENT FOR THE YEAR ENDED JULY 31,_1992 Variance Favorable Budget Actual (Unfavorable) _ PERSONAL SERVICES $ 5,700 $ 5,185 $ 515 OPERATING EXPENSES: Utilities and telephone 13,475 12,766 709 Insurance 6,900 6,778 122 122 Maintenance 6,400 6,489 (89) Travel 100 - 100 Training 1,000 2,137 (1,137) Miscellaneous 245 206 39 SUPPLIES: -393 Gas and oil 1►800 1,407 Safety equipment 3,500 4,058 7,085 (558) (1,465) Miscellaneous 5,620 HYDRANT RENTAL 12,000 12,000 - " CAPITAL OUTLAY: Specialized equipment 2,000 5,395 (3,395) TOTALS 558,740 5j63,506 $(4,766) CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL PARK DEPARTMENT FOR THE YEAR ENDED JULY 31, 1992 Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $ 41,802 $37,194 $ 4,608 Social security 3,200 2,833 367 Employees' insurance 5,132 3,540 1,592 OPERATING EXPENSES: Travel 125 50 75 Utilities and telephone 3,700 3,321 379 Insurance 1,550 1,721 (171) Maintenance 6,300 6,805 (505) Miscellaneous 385 352 33 SUPPLIES: Gas and oil 1,700 1,705 (5) Small tools 2,110 1,669 441 Miscellaneous 930 683 247 CAPITAL OUTLAY: Pony Park campground 40,000 16,267 23,733 Motorized equipment 5,650 4,510 1,140 Playground equipment 2.000 1,913 87 TOTALS $114,584 $82,563 $ 32,021 -35- CITY OF BLAIR, NEBRASItA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL LIBRARY FOR THE YEAR ENDED JULY 31, 1992 PERSONAL SERVICES: Salaries Social security Employees' insurance Retirement OPERATING EXPENSES: Auditing Postage Dues Printing and publications Utilities Telephone Travel Training Insurance Maintenance Custodial services Repairs SUPPLIES: Supplies Library materials CAPITAL OUTLAY: Office equipment TOTALS -36- Variance Favorable Budget Actual (Unfavorable) $ 69,095 $ 69,098 $ (3) 5,300 5,234 66 11,402 9,717 1,685 2,800 3,147 (347) 260 266 (6) 450 391 59 300 270 30 250 203 47 10,200 8,513 1,687 500 464 36 350 183 167 100 45 55 1,250 1,184 66 4,350 2,412 1,938 2,200 2,144 56 6,500 2,441 4,059 2,600 2,275 325 30,000 31,215 (1,215) 2,700 2,186 514 $150,607 X141,388 $ 9.219 -36- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL SUPERVISED RECREATION FOR THE YEAR ENDED JULY 31,_1992 PERSONAL SERVICES: Salaries Social security Employees' insurance OPERATING EXPENSES% Auditing Professional fees Printing and publications Utilities Telephone Insurance Maintenance Little League and BYSA Golf and basketball SUPPLIES: Gas and oil Recreation supplies CAPITAL OUTLAY: Aluminum bleacher boards TOTALS 500 650 2,000 X26,445 _37- 172 72 j25, 630 328 578 2,000 $ 815 Variance Favorable Budget Actual (Unfavorable) $ 5,010 $ 8,391 $(3,381) 400 642 (242) 370 348 22 65 67 (2) 1,500 - 1,500 50 53 (3) 4,300 4,041 259 250 478 (228) 1,450 1,473 (23) 4,500 4,374 126 5,400 4,500 900 - 1,019 (1,019) 500 650 2,000 X26,445 _37- 172 72 j25, 630 328 578 2,000 $ 815 i SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL SWIMMING PUOI, FOR THE YEAR ENDED JULY 31, 1992 Variance � Favorable 8 ^ (Unfavorable) � PQRG00&L SERVICES: « $23,334 �18 303 , $5,131 Salaries Social security 1,8UO 1,393 407 ' � Employees' insurance � 740 673 68 OPERATING E][9Q0GDG, 1 Auditing � Printing and publications 200 270 199 646 /376> ° Utilities and telephone 4'400 3,986 414 ` Ioeoza��m 925 3 O8D 92G 2 O82 , - 918 � Maintenance State sales tax , 1,000 1,086 (86) Miscellaneous 100 3 97 � SUPPLIES: Chemicals 2,900 4,444 (1"544) ` Small tools 3,000 3'325 (326) Miscellaneous __-__i 538--- . TOTALS' JAZx399 =, $5,243 ^~ � � ` u/ */ / �| m/ / v� , K. -38- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL AIRPORT FOR THE YEAR ENDED JULY 31, 1992 -39- Variance Favorable (Unfavorable) $ 1,646 194 227 (64) {5) (85) 500 87 272 37 1,037 (4) 2,015 6 346 44 (_987) Variance Favorable Budget Acr-ual (Unfavorable) PERSONAL SERVICES: $ 1,550 $ 257 $ 1,293 Salaries Social security 120 16 104 Employees' insurance 236 41 195 OPERATING EXPENSES: 3,900 1 , 386 2,514 Insurance Maintenance 1,0()0 1 1 , 405 (10,405) Engineering - airport study 60,000 32,430 27,570 Utilities 2, 220 1,906 314 Miscellaneous 230 207 23 RENTAL EXPENSE 11000 -- 11000 TOTALS I70, 256 $47 , 648 522.608 -39- Variance Favorable (Unfavorable) $ 1,646 194 227 (64) {5) (85) 500 87 272 37 1,037 (4) 2,015 6 346 44 (_987) EDWARD W. SCHROEDER CERTIFIED PUBLIC ACCOUNTANT 1904 SOUTH STREET BOX 486 BLAIR, NEBRASKA 68008 November 6, 1992 Honorable Mayor and Members of the City Council City of Blair, Nebraska Dear Gentlemen: RESIDENCE: (402) 468-5253 OFFICE: (402) 426-4080 I have audited the general pui-pose financial statements of the City of Blair, Nebraska "or the year ended July 31, 1992, and have issued my report thereon dated November 6, 1992. As part of my examination I have made a study and evaluation of the system of Internal accounting control of the City of Bla.ir,_Nebraska to the extent I considered it necessary to evaluate the system as required by generally accepted auditing standards and GOVERNMENTAL AUDITING STANDARDS. For the purpose of this report, I have classified the significant internal accounting controls in the following categories: Accounting Controls Cycles of the Entities' Activity Treasury or financing Revenue/receipts Purchases/disbursements External financial reporting Financial Statement Captions Cash and cash equivalents Receivables Inventory Property and equipment Payables and accrued liabilities Debt Fund balance amen Administrative Controls General Requirements Political activity Davis -Bacon Act Civil Rights Cash management Federal financial reports Specific Requirements Types of services Eligibility Matching level of effort Reporting Cost allocation Special requirements, if any Mayor and Members of the City Council Page 2 Lccountinq Controls-,..- continued Accounting Applications Billings Receivables Cash receipts Purchasing and receiving Accounts payable Cash disbursements Payroll Inventory control Property and equipment General ledger The purpose of my study and evaluation was to determine the nature, timing, and extent of the auditing procedures necessary for expressing an opinion on the entities financial statements. My study and evaluation was more limited than would be necessary to express an opinion on the sy-.--teiT, of internal accounting control taken as a whole or on any of the categories of controls identified above. . . The management of the City of Blair, Nebraska is responsible for establishing and maintaining a system of internal accounting control. In fulfilling this responsibility, estimates and judgments by management are required to assess the expected benefits and related costs of control procedures. The objectives' of a system are to provide management with reasonable but not absolute assurance that assets are safeguarded against loss from unauthorized use or disposition and that transactions are executed in accordance with management's authorization and recorded properly to prevent the preparation of financial statements in accordance with generally accepted accounting principles. Because of inherent limitations on any system of internal accounting controls errors or irregularities may never the less occur and not be detected. Also, projection of any evaluation of the system to future periods is subject to the risk that procedures may become inadequate because of changes in conditions or that the degree of compliance with the procedures may deteriorate. My study and evaluation made for the limited purpose, described in the first paragraph would not necessarily disclose all material weaknesses in the system. Accordingly, we do not express an opinion on the system of internal accounting control of the City of Blair, Nebraska taken as a whole or on any of the categories of controls identified in the first paragraph. -44- Mayor and Members of the City Council Page 3 However, my study and evaluation disclosed the following conditions that I believe result in more than a relatively low risk the errors and irregularities in amounts that would be material in relation to the financial statements of the City of Blair, Nebraska may occur and not be detected within a timely period. The City of Blair does not have adequate segregation of duties. These conditions were considered in determining the nature, timing, and extent of the audit tests to be applied in my examination of the 1992 financial statements and this report does not affect our report on the financial statements dated November 6, 1992. This report is intended solely for the use of management. and the applicable cognizant agency and should not be used for any other purpose. This restriction is not intended to limit the distribution of this report, which upon acceptance by the cognizant agency is a matter of public record. Edward W. Schroeder Certified Public Accountant -45- °fin 5'n a ®c ° y°� ®� a��Ogg eo o tYi� li� 5 ia� b q C eo a �m > �Lo�S"� �w 5' °o w e m�. en0~C,O� "^a w m m w R e�eq 5'O m 5l7 a o o �, �o g m m R O �� Op O�� O n a �m °� a w 8 en w w® w 't7rov p o w w ® 5 ro ®, 5. a s m < o 0w �A 5 fi w< 5 5 5 `a m ®- ® ,� d m o ° �° �.®� m 5< p. 0 5 gry ZmQ .ro a w $ m � �5 �� 5 `° p 5 0 c .o o .,^a `° EoS�' CL m �. 5 ' e�„® R. m O< a Ex a� o m e c e mo wm m, m m > o�R. o oa ow m �x O R. w m o a O o tri m to ao w o R. ro ro a R. aa -a x. $ g 5 oa" a ,� 3 trig 5'� 5 5 R. b m55w3`°a`°o5.� ,;m�.a Ea'".8w 9'O°g'S�-0 aS. 8=*0 �rn ��•�^� ga '^ °5� n � 5a `°; o-8�"�® �a���W �n� ;� iI a p o. C1 y. E m tr1 R m O m� m �3 x E 5 '� y w f= w E tt9 a o a n 5m mEti 05 .. O x w �< a x S. okp. ro > woo �' x�^SZ m�Z �Za�. ZE z 5 > a O eo'E •v O O a O m `�. O Q° ® nen �. �' °y R .e `�.' »� 5' fn ,6n ti > 9" •�. ""' p 5 ®.. a E w, ® n y�'`a n B qo 5 0 ° Cx �, x � ro a g > er5 n °,t7 `� �° y 5 ®o 5 c"avw m °° yB a 5 ^+ , ;, 5 n R 5 5 Gel.. m m R _ n7�°a.i9' erg Or" a n.�w � x� fD � ® ~ 5 ®fa 5'< o � 0 5'A m w �.A a�O'�'$m rsi p�» m a w ` mw w Spa+� 5 aG 5 �a� a b � 4 v ,fin es:" mw L0 &o R � � tO fi p ¢��•� m � �S"�5'r?",, a �� en 5 x. w w '•. ®.. y m' m x . o g 5� 'Cc� o �' a ro` w W d f° 5 co a„ a o �' m w s °, m m e5 575 >®07d ^ w e� 5 `" ° < r"+ � ® :FE a • R'sa m om . 5 s S a,an a ® ° w w a ,E g 5.i o S 5' < 5 ll >i w :. �� - w �.w n 5 M w. ca .{ R .� . y " C 'e m*» ro �A `o m' R. 5 w n a a' e a o m 5` ..; gR. _ zz ° p w eo cnrm o n to—()O"es m S � oF^ `° o ; �®o • � ° S n C QZ�,d r., d w Q a >Oe, est a ° E' $ N"'S 5 °'S � 5 S � � 5 o `°'cc m aq a p$ > C" a roa a S 5$ g g•<° `� o b 5 E S m w5 5�"'£S m. ®• 5 C,..,e'C,®o a f° m 5r°��•`< "'° L r x �, °° .o x �, ®'"+ & m m nR. a n 5.��a ,a"�w�pC �O`Cj�'® Q �rr9ae °m7o N `� .O R ip`! o S �p �•• E�!] e` a o 5w �< 5 5.e �.� a m ° 5''y`e H > r �y 5. a mtea fi� e) 13. a m A to m n n c M ®w C G _ i� a <3.5° o :3,� x �o y e� xp� $ �o �'m E d.�7dy y Rlw �' a0 ha 5 x� ., a• a4R°5 `c a .. ° > C�+ a' S ��� 5 n> ja S g m S g ®S w Z o m ,,. GGC �® n. �.» M"® m men �rN n `o w'r p �� ayE dtla R 5 ° o� n � x a eo e 5 a5 n� �, < eo 5 5.� �. >tsf® n o G�Nvwaemeno a w ° C7 :.5 .. ww ® S E °' S 5 :,� a ° Q•a x 5 B m ce o to °° m a ° a s owwwv� oo -, m p'C w 'S�.. M• n gg �5-- y t� °a ; - ��SgSw wm5'a 5 S A o' a• wR•<m $ '< ® % 5 d.xo `D •eo m_ �5' o S m t,° ^w r✓S 5 c- '* o S:�m R eo �� y n m aovA�omd„�� w E a� �� ° r GwS rytA�a� g®' ° C we o� $ -w ° fir`! n m o tzf„ p n o a o< w co yz > vain tom x m; s 8 n a bd - x '"' " m m •a m> G A• A o .o w p c "*m ., m n q 5 .a a n 5 $?' Vii` C= t� `> 5 g c' ®� bus s a'xg �' 5'9, n S Pry 5 a • �'w° x.Z�uF- n 5-c 5'c:5 $ o E'e fib: �v° a. a�; S" G>0O0'� 5 eo 8808808888y mw's 5 ®� 5o a : b� �t 5 ? o �? ° C; ` m m $r b MF g m 0 5 eo '] a •- C t�: �r R. rs a? g a -n ®,0 504 o ^� ^e o o E m t0 �j .o — o~ z ^' � •"' ,a o y c ��b B .S��� �n ea°m� „0S�5�Nn oo a 1: °1°a5 cgs °��xn 5 m o m 5x5,5 .. n igo o m �, a �' co e► d o � �' 'b t,7 �. w � a w w t" �'i co p. n eo 9 `O to », � a 09 - w w x 5 m 5' .o .� E 5' .. o a. o~i •e c o a ee 5 .n C o, 5 co w w < m o m m a x t� t' es R �.o 5 0 &0 5 a ee- �' ab 5 no 5 g b R C 5. Cl. an O m j •+ w ° �, m �, p 5 o� ®.. � � � � any � 'ti m � � a° a 5 �`Q•`'e V ®Q °M,aO m �`e �'Ero �' `° � e� �pae f� m� E � mi m o m ° m o 'aa.o x• �, cy w e a•twa t�D@�'C 5°o a 5+" Y1 c,5 :� �, S � ., C 5' r• �, �, � m �: � G 5: ' � °° H. a 6• °:s � c•:; g o ,••�? ,,, 5. �°- a• `� 5' ;c °a+, ro n �' �, ' `� eo a•, M o m o �. 5 T. � � � m oa g �, n. n ° G o � � � � 5+ O G� ny Co a � � S g• w 5 ®®• a m . 5' ® G^ • � � 4-°. � � � w ° ° E ,,y �'S. �y n w5"5a .<g X2..5 5m �'S aR.+� 55°y 5 5w 5°5 C �.0 5 CD ® ` n 5 c� Er K a 2 3 \m 3 7'p g A 5 m >eo O� a S o 5 < mnd Pb rs°'wT b °Mn^ "^ °° C. M w tZI m® a5 a m �]m A 92. SC [ o< Wo Q 5 e9 5 5 5'� R. Cr9 °+ � to �. "r9 �y° I.a $ k! 5' � m• eD C a S91 e .p •, eOi p o®ay oma w m�o �° 5'�aCD RAJ �•CD Lj 7-7 Av- LIE 77 �77 777777777� oupilcate Affidavits of this Publication have been filed in the office of: county court El Clerk of Dist. Court El County Clerk El Sec. State El L-A Washington, County, Kenneth H. Rhoades .... . . . ...... being by me first duly sworn, deposes and says that he is the publisher of THE PILOT -TRIBUNE, a legal weekly newspaper printed and published at Blair, in Washington County, Nebr. and of general circulation in said County and State; that said newspaper has a bona fide circulation of more than 300 copies weekly, in said County; and, has been published in said County for more than 52 successive weeks prior to the first publication of the at- tached notice, that the attached notice was published in said newspaper for _ One - - ---------- - ---- consecutive weeks, being the issues of AqmL-s-t ---- io -9-2---- ff!� 19----------- f Subscrib ---------- Subscribed in my presence and--s*-6rn to before me 18 t August --------- 119-9-2 day 0,11---) -------- ---------------- 65NEPAL NOTAPY-Statj �j &jp PON? Printers Fees For Publishing This Notice .................. $ 97.15 25% discount for minutes -24.29 Preparation of Affidavit and Billing ....................... $ NotaryFees ............................................... $_ 1 Copy....................................................... $ Total ................ g 72.86