The URL can be used to link to this page

FY1983 Audit Report CityCITY OF BLAIR, NEBRASKA =Y 31, 1983 CITY OF BLAIR, NEBRASKA TABLE OF CONTENTS AUDITORS' OPINION COMBINED STATEMENTS: Combined Balance Sheet - All Fund Types and Account Groups Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (Cash Basis) and Actual - All Governmental Fund TvQes 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 General Fixed Assets Account Group: Statement of General Fixed Assets Statement of Changes in General Fixed Assets General Long-term Debt Account Group: Statement of General Obligation Bonds Principal and Interest Requirements by Year of Maturity Statement of Changes in General Long-term Debt Combined Statement of Changes in Financial Position - All Proprietary Fund Types and Similar Trust Funds NOTES TO FINANCIAL STATEMENTS STATEMENTS OF INDIVIDUAL FUNDS: Special Revenue Funds: , Combining Balance Sheet Combining Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget (Cash Basis) and Actual Enterprise Funds: Combining Balance Sheet Combining Statement of Revenues, Expenses and Changes in Retained Earnings Combining Statement of Changes in Financial Position Individual Statement of Revenues and Expenses - Budget (Cash Basis) and Actual - Blair Apartments Individual Statement of Revenues and Expenses - Budget (Cash Basis) and Actual - Electric Individual Statement of Revenues and Expenses - Budget (Cash Basis) and Actual - Water Individual Statement of Revenues and Expenses - Budget (Cash Basis) and Actual - Sewer SUPPORTING SCHEDULES: Schedule of General Basis)and Actual Schedule of General Basis) and Actual Fund Revenues - Budget (Cash Fund Expenditures - Budget (Cash - Administration Department Page 1 2-3 4 5 8 9 10 11-14 15 16-17 18-19 20 21-22 23 24-25 26 27 28 29-30 CITY OF BLAIR, NEBRASKA TABLE OF CONTENTS ..- SUPPORTING SCHEDULES (Continued): Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Police Department 31 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Cemetery 32 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Fire Department 33 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Park Department 34 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Library 35 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Supervised Recreation 36 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Swimming Pool 37 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Airport 38 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Landfill 39 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Animal Control 40 car" D ,n, . P. = -7p L November 7, 1983 u Honorable Mavor and Members of the City Council City of Blair, Nebraska Gentlemen: We have examined the combined financial statements of the City of Blair, Nebraska as of and for the year ended July 31, 1983 as listed in the foregoing table of contents. Our exami- nation was made in accordance with generally accepted auditing standards and, accordingly, included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. 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. In our opinion, except for the omission of accrual basis budgetary comparisons required by generally accepted accounting principles, the financial statements listed in the aforementioned table of contents present fairly the financial position of the City of Blair at July 31, 1983, and the results of its opera- tions, changes in fund balance for all fund types and changes in financial position for all proprietary fund types for the year then ended, in conformity with generally accepted accounting principles applied on a consistent basis. Our examination was made for the purpose of forming an opinion on the combined financial statements taken as a whole. The statements of individual funds and supporting schedules listed in the foregoing table of contents are presented for the purpose of additional analysis and are not a required part of the auditing procedures applied in the examination of the basic financial statements and, in our opinion, are fairly stated in all material respects in relation to the basic financial statements taken as a whole. BUESING DeSMET & ASSOCIATES CITY OF BLAIR, NEBRASKA COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS JULY 31, 1983 ASSETS C,ash Receivables: Billed user fees (net of allowance for doubtful accounts of $4,000) Special assessments From OPPD Accrued interest Other Investments - at cost (unrestricted) Due from County Treasurer Inventory Prepaid expenses Cash value of police pension life insurance Restricted assets - cash and investments - at cost Property - net of accumulated depreciation, where applicable Amount available in Debt Service Funds Amount to be provided for retire- ment of general long-term debt TOTAL ASSETS Proprietary Fiduciary Fund Fund Account Groups GoverDmental Fund Types __ Types Types General General Special Debt Enterprise Police Insurance Fixed Long-term General Revfmue Service Fgds P-eDsiorn_ Fund Assets Debt $101,770 $ 67,946 $ 34,230 $ 327,942 $ 2,138 $12,801 - - - 703,768 - - - - 714,650 - - - 25,891 - - 4,400 - - 24,250 2,250 - 13,922 - - 184,000 130,000 35,000 913,000 50,000 - 16,121 1,642 7,459 - - - - - - 121,451 - - - - - 8,836 - - 10,480 - - - - - - - - 880,204 - - - - - 10,315,650 - - $2,838,355 $769,676 _ _ - - - - - 105.581 316771 199 _588 $791,339 $13.334.914 154388 X12,801 $2,881355 8 5257 See Notes to Financial Statements. -2- CITY OF BLAIR, NEBRASKA COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS JULY 31, 1983 LIABILITIES Accounts payable Accrued interest Accrued expenses Registered warrants Deposits payable General obligation bonds payable Revenue bonds payable Lease payable Land contract payable Total liabilities Governmental Fund Types Special Debt General Revenue Service $ 19,927 $ 8,378 - - $ 3,280 6,041 - - - - 18,383 25,968 8,378 21,663 FUND BALANCES Proprietary Fiduciary Fund Fund Account Groups TyDes Type General General Enterprise Police Insurance Fixed Long-term Fund L_ Pensi_orL_ Fund Asseta Debt $ 279:,228 40,133 10,584 444181 59,200 - $690,000 5,139,636 - - 113,257 - 72,000 _ 5, 962 815,257 Contributed capital - - - 4,394:,167 Investment in general fixed assets - - - - $2,838,355 - Retained earnings - - - 3,367,785 - - Fund balance 290,803 191,210769,676 - $54,388 112 -,801 - Total fund balances 290,803 191,210 769,676 7,767.,952 54,388 12,801 2,8381355 - TOTAL LIABILITIES AND FUND BALANCES $316,771 $199,588 $7911339 13 133A,914554,388 $12,801 $21838,355 5875,257 See Notes to Financial Statements. -3- CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND BALANCE BUDGET (CASH BASIS) AND ACTUAL ALL GOVERNMENTAL FUND TYPES FOR THE YEAR ENDED JULY 31, 1983 General Fund Special Ree Funds Debt Service Fund Variance Variance Variance Favorable Favorable Favorable Budget A.ctuA (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES: Taxes and special assessments $ 664,506 $657,945 $( 6,561) $ 69,973 $ 72,121 $ 2,148 Street revenues - - - $279,629 $282,801 $ 3,172 - - - Licenses and permits 16,625 22,646 6,021 - - - - - - Charges for services 71,280 96,532 25,252 - - - - - - Revenue sharing funds - - - 51,625 47,164 ( 4,461) - - - Interest income 20,000 40,376 20,376 9,700 9,284 ( 416) 6,000 4,701 ( 11299) Other revenues 70,650 16,329 (54,321) 66.300 3,973 (62,327) - 17,852 17,852 Total revenues 843,061 833,828 ( 9,233) 407,254 343,222 (64,032) 75,973 94.674 _ 18,701 EXPENDITURES: Administration 271,364 177,774 93,590 - - - 330 1,126 ( 796) Contingency allowance 65,000 24,496 40,504 - - - - - - Police Department 359,621 335,179 24,442 - - - - - - Cemetery 110,285 44,125 66,160 - - - - - - Fire Department 133,026 34,920 98,106 - - - - - - Parks Department 54,635 46,371 8,264 - - - - - - Library 105,888 99,919 5,969 - - - - - - Supervised recreation 48,928 38,571 10,357 - - - - - - Swimming pool 36,397 31,721 4,676 - - - - - - Airport 6,220 2,621 3,599 - - - - - - Landfill 69,973 34,201 35,772 - - - - - - Animal control 26,298 22,271 4,027 - - - - - - Revenue sharing projects - - - 90,148 51,118 39,030 - - - Street - - - 502,336 322,529 179,807 - - - Debt service: Redemption of bonds - - - - - - 70,000 78,000 ( 8,000) Bond and warrant interest - - - - - - 34,051 58,117 (24,066) Computer and land purchases - - - - - - - 135,665 (135,665) Total expenditures 1,287,635 892,169 395,466 592,484 373 647 218,837 104,381 272,908 (168,527) REVENUES OVER (UNDER) EXPENDITURES (444,574) (58,341) 386,233 5185,230) (30,425) 154,805 (28,408) (178,234) (149,826) OTHER FINANCING SOURCES (USES): Bond and land contract proceeds - - - - - - 191,669 275,000 83,331 Operating transfers - in 28,558 - (28,558) - 1,957 1,957 - 77,290 77,290 Operating transfers - out - (13,027) �(13,027) - - - - (12,008) (12,008) REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES (416,016) (71,368) $344,648 (185,230) (28,468) 15 762 163,261 162,048 $( 1,213) FUND BALANCE - July 31, 1982 362,171 362,171 219,678 219.678 607,628 607,628 FUND BALANCE (DEFICIT) - July 31, 1983 $( 53,845) $290,803 $ 34,448 1191,210 5770,889 $769,676 See Notes to Financial Statments. -4- 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, 1983 Enterprise Funds Police Pension Fund Insurance Fund Variance Variance Variance Favorable Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) OPERATING REVENUES: User fees Sale of capacity Sale of merchandise Extensions Rental Pension collections Insurance contributions Other Total revenues OPERATING EXPENSES: Purchased power Production Distribution Customer accounts Administration Pension refunds Employee insurance expense Depreciation Total expenses OPERATING INCOME (LOSS) OTHER REVENUE (EXPENSE): Interest income Interest expense Transfers - in Transfers - out NET INCOME (LOSS) RETAINED EARNINGS/FUND BALANCE - July 31, 1982 RETAINED EARNINGS/FUND BALANCE - July 31, 1983 $2,988,400 304,350 9,000 30,000 41,922 32,550 3,406,222 1,867,000 459,035 170,975 53,100 444,250 2,994,360 411,862 121,100 (298,518) ( 28,558) 205,886 3,240,797 $3,138,147 308,177 15,690 30,856 47,597 35,833 3,576,300 1,747,135 430,289 150,968 45,622 356,208 554,570 3,284,792 291,508 217,171 (327,478) 225 ( 54,438) 126,988 3,240,797 $3,446,683 $3,3671785 See Notes to Financial Statements. -5- $149,747 3,827 6,690 856 5,675 3,283 170,078 119,865 28,746 20,007 7,478 88,042 (554,570) (290,432) (120,354) 96,071 (28,960) 225 (25,880) $(78,898) $ 12,197 $ 9,926 $(2,271) 12,197 9,926 (2,271) 79,992 79,992 (671795) 4,200 27,589 52,403 27,589 52,403 (17,663) 50,132 7,123 2,923 (63,595) (10,540) $53,055 64,928 $ 1,333 64,928 $ 54,388 $ - $23,172 $23,172 23,172 23,172 - 10,371 10,371 12,801 (10,371) (10,371) 12,801 12,801 $12,801 _ 12,801 CITY OF GLAIR, NEBRASKA STATEMENT OF GENERAL FIXED ASSETS JULY 31, 1983 Land Buildings Vehicles Eguipment GENERAL FUND: Administration $ 15,000 $ 598,655 $ 5,698 Police - - 46,826 Cemetery 115,000 - 3,500 Fire - - 71,512 Park 97,952 201,957 4,350 Library 22,500 116,600 - Supervised recreation - 274 1,800 Swimming pool 100,000 218,531 - Airport 32,000 136,816 - Landfill 15,000 6,700 - Animal control - - 2,650 SPECIAL REVENUE FUNDS: Street 10,000 40,400 191,284 Revenue sharing - 28,773 - CAPITALIZED LEASE - Library - 203,404 - TOTALS $407,452 $1.552,110 53271620 See Notes to Financial Statements. $ 69,119 31,210 4,242 6,158 24,776 567 17,200 163,789 3,443 772 71,660 158,237 Total $ 688,472 78,036 122,742 77,670 329,035 139,667 19,274 482,320 172,259 21,700 3,422 313,344 187,010 - 203,404 $551,173 $2,838,,355 CITY OF BLAIR, NEBRASKA STATEMENT OF CHANGES IN GENERAL FIXED ASSETS FOR THE YEAR ENDED -JULY -31,1983 Balance Balance July 31, July 31, 1982 Additions Dispositions 1983 GENERAL FUND: Administration Police Cemetery Fire Park Library Supervised recreation Swimming pool Airport Landfill Animal control SPECIAL REVENUE FUNDS: Street Revenue sharing CAPITALIZED LEASE - Library TOTALS $ 654,633 $ 33,839 $ 688,472 72,522 11,647 $6,133 78,036 7,329 116,667 1,254 122,742 76,630 1,040 - 77,670 321,684 8,701 1,350 329,035 139,520 147 - 139,667 12,883 6,391 - 19,274 482,320 - - 482,320 172,259 - - 172,259 21,700 - - 21,700 3,155 267 - 3,422 308,176 5,168 - 313,344 136,629 50,381 - 187,010 203,404 - - 203,404 $2,61 -,-aA4 1234,248 $8,737 See Notes to Financial Statements. -7- $2,838,355 CITY OF BLAIR NEBRASKA STATEMENT OF GENERAL OBLIGATION BONDS PRINCIPAL AND INTEREST REQUIREMENTS BY YEAR OF MATURITY JULY 31, 1983 Year Ending Principal Interest July 31, Requiremants Requirements Total 1984 $ 75,000 $ 48,698 $123,698 1985 100,000 44,273 144,273 1986 100,000 35,493 135,493 1987 110,000 30,014 140,014 1988 70,000 23,466 93,466 1989 75,000 18,298 93,298 1990 50,000 13,710 63,710 1991 55,000 9,460 64,460 1992 25,000 4,680 29,680 1993 30$000 2,580 32,580 TOTALS 8690,00_0 $230,672 $920,672 See Notes to Financial Statements. CITY OF BL NEBU See Notes to Financial Statements, M STATEMENT OF CHANGES IN GENERAL LONG-TERM DEBT _FO1_TH1�_YEA_9_ENDED JULY 31. 1983 Balance Balance July 31, July 31, RatedRaled DescriDtio_U 198.2 Addition. Deductions 1983 6/1/77 Various purpose bond issue $195,000 $35,000 $160,000 12/15/78 Various purpose bond issue 170,000 20,000 150,000 5/1/80 Various purpose bond issue 200,000 15,000 185,000 6/15/83 Various purpose bond issue - _ 195,000 - 1953000 Total bond obligations 565,000 195,000 70,000 690,000 Capitalized lease 120,542 7,285 113,257 Stemmerman land contract - __803000 _ 8,000 __723000 TOTAL1585-.5421275-,000 S�85s285 X875,257 See Notes to Financial Statements, M CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION ALL PROPRIETARY FUND TYPES AND SIMILAR TRUST FUNDS FOR THE YEAR ENDED JULY 31, 1983 Enterprise Police Insurance Funds Pension Fund SOURCES OF WORKING CAPITAL: Working capital provided by operations: Net income (loss) $126,988 $(10,541) $12,801 Add items not requiring a current use of working capital - depreciation 554,570 - - Total 681,558 (10,541) 12,801 Increase in.deposits payable 7,016 - - Total sources of working capital 688,574 (10,541) 12,801 USES OF WORKING CAPITAL: Additions to property - net 122,553 Bond retirement 196,364 Increase in restricted assets 19,362 Increase in current portion of long-term debt 37,932 Total uses of working capital 376,211 INCREASE (DECREASE) IN WORKING CAPITAL X312,363 $(10541) $12,801 CHANGES IN WORKING CAPITAL COMPONENTS: Increase (decrease) in current assets: Cash $120,434 $( 3,515) $12,801 Accounts receivable - user fees 121,592 Accounts receivable - OPPD 1,502 Accounts receivable - other 12,196 Accrued interest receivable 7,175 594 Investments (84,440) ( 7,620) Inventory ( 1,057) Prepaid expenses ( 1`505) Total 175,897 (10,541) 12.801 Decrease (increase) in current liabilities: Current portion of long-term debt (37,932) Accounts payable (47,313) Accrued interest 26,837 Accrued expenses ( 41074) Registered warrants 197,908 Due to County Treasurer 1,.040 Total 136,466 - - INCREASE (DECREASE) IN WORKING CAPITAL $3121363 $(10.541) $12,801 See Notes to Financial Statements. -10- CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES A. 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 recog- nized 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, B. 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. C. Inventory: Inventory is stated at first -out) or market value, finished goods. D. Property: the lower of cost (first -in, All the inventory is 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 include -d 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 all other funds are recorded as expen- ditures 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, -11- CITY OF BLAIR. NEBRASKA NOTES TO FINANCIAL STATEMENTS, Continued 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) E. 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. 2. RESTRICTED ASSETS Restricted assets consist primarily of cash, certificates of deposit and savings accounts. The assets are restricted as follows: Held in trust per bond requirements $223,510 Bond and interest sinking funds 599,466 Utility deposit funds 57.228 Total restricted assets $880.204 3. LONG-TERM DEBT The City entered into an agreement with the City of Blair Library Building Corporation on October 1, 1975 to lease a library building which was constructed by the Building Corporation with proceeds from the sale of bonds. The City is required to make payments under the terms of the lease in amounts equal to the interest and bond principal payments of the bonds issued by the Building Corporation. At the end of the lease term title to the building will be conveyed to the City. The transaction has been treated as a purchase with the present value of the remaining lease payments recorded as a liability in the general long-term debt group of accounts. General long-term debt, excluding bonds, consists of the following: Lease payable 10/1/75 6.00-7.00% Land contract payable 9/1/82 12% -12- Current Amount Portion $113,25313-...-000 $ 72,000 $8,000 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS, Continued 3. LONG-TERM DEBT, Continued Proprietary fund long-term debt consists of the following: Current Amount Portion Electric 1/1/72 4.30.4.60% $ 230,000 $ 70,000 4/1/80 7.00-7.50% 600,000 35,000 Totals $ 830,000 $105,000 Water 4/15/80 8.00-10.80% $ 790,000 $ 45,000 7/15/80 5.00% 3,344,630 32,932 Totals $4,134,636 $ 77,932 Sewer 11/15/74 5.20-6.00% $ 175,000 $ 20,000 4. PENSION PLANS 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 required including 3% of gross wage in employee contributions and 3% of gross wage in contributions from the City are invested with the Travelers Insurance Company. The employees must have accumulated two years 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, 1983 were $17,267 and are expected to remain relatively level from year to year. The policemen are covered under a defined benefit plan established by the statutes of the State of Nebraska. Current expenditures are made to policemen terminating before retirement age for their contributions to date of termination only. The City has fiduciary responsibility for the plan and it is a single employer plan only. Current year contri- butions of $9,926 were 6% of gross wage which complies with statutory requirements. At September 1, 1980 an actuarial study reflected an overfunding in the plan of 172%. However, the City expects the contributions to remain relatively level from year to year. -13- CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS, Continued 5. INSURANCE FUND The City employees can participate in the City's group health insurance. The policies provide that the first $12,500 of employee medical expenses be self-insured. The City deposits money on employees' behalf to the insurance fund to build adequate funds to self -insure for the first $12,500 and also pay the premiums for the insurance that covers claims over this amount. The insurance fund is an accounting of these deposits and the City has a fiduciary responsibility for the maintenance of the funds. 6. PURCHASED POWER AND CAPACITY SALES AGREEMENT In April 1977 the Board of Public Works entered into two contracts with the Omaha Public Power District. Under the terms of the agreements, the Board is restricted to selling the capacity of the existing electrical generating facilities only to Omaha Public Power District at an established contractual rate. The Board continues to own the existing facilities and provides the personnel to operate them but must operate them only when and as specified by the Omaha Public Power District and is required to purchase all of its electric power requirements from the Omaha Public Power District. The term of the agreements is five years and is automatically renewable unless canceled by either party with three years advance notice. -14- CITY OF BLAIR, NEBRASKA COMBINING BALANCE SHEET - SPECIAL REVENUE FUNDS JULY 31. 1983 -15- Revenue Street Sharing Fund Fund Total CASH SAVINGS $ 60,972 $ 6,974 $ 67,946 INVESTMENTS 100,000 30,000 130,000 DUE FROM COUNTY TREASURER 1,642 - 1,642 TOTAL �162-,-614 136,974 $199,588 LIABILITIES AND FUND BALANCES ACCOUNTS PAYABLE $ 7,864 $ 514 $ 8,378 FUND BALANCE 154.750 36,460 191.210 TOTAL162 614 $36,974 $199,588 -15- CITY OF BLAIR, NEBRASKA COMBINING SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET (CASH BASIS) AND ACTUAL SPECIAL REVENUE FUNDS FOR THE YEAR ENDED JULY 31, 1983 Street Fund Revenue Sharing Fund Total Variance Variance Variance Favorable Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES: Revenue sharing funds $51,625 $47,164 $(4,461) $ 51,625 $ 47,164 $( 4,461) Highway allocation $227,910 $223,561 $( 4,349) 227,910 223,561 ( 4,349) County road tax 35,000 47,496 12,496 35,000 47,496 12,496 Motor vehicle pro rata 3,000 - ( 3,000) 3,000 - ( 3,000) Incentive payment 3,000 3,000 - 3,000 3,000 - State maintenance agreement 9,219 8,453 ( 766) 9,219 8,453 ( 766) Sale of rock 1,500 291 ( 1,209) 1,500 291 ( 1,209) Interest on investments 9,000 71447 ( 11553) 700 1,837 1,137 9,700 9,284 { 416) Miscellaneous 66,300 3,973 (62,327) 66,300 3.973 (62,327) Total revenues 354,929 294,221 (60,708) 52,325 49.001 (3,324) 407,254 343,222 (64,032) EXPENDITURES: Salaries 114,020 98,100 15,920 114,020 98,100 15,920 FICA 7,639 6,575 1,064 7,639 6,575 1,064 Retirement 3,421 11886 1,535 3,421 1,886 1,535 Employee insurance 17,067 15,501 1,566 17,067 15,501 1,566 Engineering 12,000 14,215 ( 2,215) 12,000 14,215 ( 2,215) Auditing 937 917 20 450 595 ( 145) 1,387 1,512 ( 125) Dues 175 42 133 150 142 8 325 184 141 Utilities 8,082 7,398 684 8,082 7,398 684 Telephone 340 339 1 340 339 1 Travel 300 277 23 300 277 23 Insurance 5,949 3,084 2,865 5,949 3,084 2,865 Maintenance 17,611 20,126 { 2,515) 17,611 20,126 ( 2,515) Contingency reserve 2,000 1,840 160 2,000 1,840 160 Collection fees to County Treasurer - 475 ( 475) 475 ( 475) Sand, gravel and rock 8,000 11,211 ( 3,211) 8,000 11,211 ( 3,211) Gas, diesel and oil 15,025 14,336 689 15,025 14,336 689 Materials and supplies 9,980 8,217 1,763 9,980 8,217 1,763 Uniforms 1,400 10,109 291 1,400 11109 291 Rental 6,000 3,211 2,789 6,000 3,211 2,789 Capital outlay: Tennis courts 26,548 1,681 24,867 26,548 1,681 24,867 Fire department pacers 15,000 13,502 1,498 15,000 13,502 1,498 Land, buildings and other 59,390 - 59,390 59,390 - 59,390 Airport overlay 48,000 35,198 12,802 48,000 35,198 12,802 Water and sewer storm lines 60,000 4,118 55,882 60,000 4,118 55,882 Motorized equipment 5,000 5,168 ( 168) 5,000 5,168 ( 168) Street improvements 148,000 104,384 --43-,-616 - - - 148,000 104,384 43,616 Total expenditures 502,336 322,529 179,807 90,148 51,118 39,030 592,484 373,647 218,837 REVENUES OVER (UNDER) EXPENDITURES - Totals carried forward (147,407) (281308) 199,L099 (37,823)(2,117) 35,706 (185,230) (30,425) 154,805 -16- I CITY OF BLAIR, NEBRASKA COMBINING SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET (CASH BASIS) AND ACTUAL SPECIAL REVENUE FUNDS FOR THE YEAR ENDED JULY 31, 1983 Street Fund Revenue Searing Fund Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget REVENUES OVER (UNDER) EXPENDITURES - Totals brought forward OTHER FINANCING SOURCES (USES) - Operating transfers -in REVENUES OVER (UNDER) EXPENDITURES FUND BALANCE (DEFICIT) - July 31, 1982 FUND BALANCE - July 31, 1983 $(147,407) $(28,308) $119,099 $(37,823) $(2,117) $35,706 1,957 1,957 Variance Favorable Act (Unfavorable) $(185,230) $(30,425) $154,805 1,957 1,957 (147,407) (26,351) $121,056 (37,823) (2,117) $35,706 (185,230) (28,468) $156.762 181,101 181,101 $ 33.694 $154.750 -17- 38,577 38,577 $ 754 $$336,460 219,,678 219,678 $ 34,448 $191.210 CITY OF BLAIR, NEBRASKA COMBINING BALANCE SHEET - ENTERPRISE FUNDS JULY 31, 1983 ASSET Blair Apartmen Electric Water Sewer Total CURRENT ASSETS: Cash $ 15,045 $ 217,870 $ 47,391 $ 47,636 $ 327,942 Accounts receivable - 5,621,960 6,762,667 3,257,611 15,642,238 user fees - 535,559 136,018 36,191 707,768 Less allowance for 10,833 7,583 3,250 26,237 doubtful accounts - ( 4,000) - - ( 4,000) Accounts receivable- 6,456 11,291 12,560 30,307 OPPD - 25,891 - - 25,891 Accounts receivable - other - 8,174 5,748 - 13,922 Accrued interest receivable - 8,903 11,711 3,636 24,250 Investments 20,000 468,400 222,600 202,000 913,000 Inventory - 90,734 29,944 773 121,451 Prepaid expenses - 6,,645 1,291 900 8,836 Total current assets 35,045 1,,358,176 454,703 291,136 2,1391060 RESTRICTED ASSETS: Cash and investment held in trust - Meter deposit cash and investments - Bond and interest sinking fund cash and investments - Cash at County Treasurer's for bond reserve - Senior and junior lien bond reserves - Total restricted assets - PROPERTY: Land Plant in service Buildings Equipment Accumulated depreciation Construction in progress Property -net TOTAL ASSETS 223,510 - - 223,510 57,228 - - 57,228 171,144 - 57,127 228,271 9,221 - - 9,221 - 361,,974 - 361,974 461,103 361,974 57,127 880,204 15,000 - - - 15,000 - 5,621,960 6,762,667 3,257,611 15,642,238 416,795 - - - 416,795 4,571 10,833 7,583 3,250 26,237 (43,508) (4,083,875) (687,809) (999,735) (5,814,927) - 6,456 11,291 12,560 30,307 392,858 1,5553374 6,093,732 2,273,686 10,315,650 J427,903 $3,374,653 $61910,409 $2,6211949 ,$13,334,914 2 ITY OF BLAIR, NEBRASKA COMBINING BALANCE SHEET - ENTERPRISE FUNDS JULY 31, 1983 _ LONG-TERM DEBT: Revenue bonds payable-unmatured Less current portion above Long-term debt - net Total liabilities FUND BALANCE: - 830,000 LIABITITIE,9 AND FUND BALANCE - 105 000 - 77,932 2 0_r 000 Blair - 725,000 410564704 A ar meDts Electric water Seas. Total CURRENT LIABILITIES: ___9,490 1,205,561 4,171,764 186,147 5,572.,962 Current portion of long-term debt $ 105,000 $ 77,932 $ 20,000 $ 202,932 Accounts payable $ 7,850 255,708 9,386 6,284 279,228 Accrued interest - 16,721 21,307 2,105 40,133 Accrued expenses - 10,584 - - 10,584 Registered warrants - 34.988 ______x,435 2.758 44,181 Total current liabilities ZT850 4238001 �_115�060 ____1,147 511,058 DEPOSITS PAYABLE 1,640_ 57,560 - - 59,200 LONG-TERM DEBT: Revenue bonds payable-unmatured Less current portion above Long-term debt - net Total liabilities FUND BALANCE: - 830,000 4,134,636 175,000 5,139,636 - 105 000 - 77,932 2 0_r 000 202,932 - 725,000 410564704 155,000 4,936,E ___9,490 1,205,561 4,171,764 186,147 5,572.,962 Contributed capital - 73,233 1,550,100 21770,834 4,394,167 Retained earnings 418,413 2.095 859 1,188.545 (335032) 33571785 Total fund balance 418.413 2,169,092 2,7$,645 2 45 802 7, 61,952 TOTAL LIABILITIES AND FUND BALANCE $427,903 _�3 ,3741653 $6.910,409 $2,621,949 $13.334,914 -19- _CjMY___QFBEAD R_ ,_3DMEA COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS ENTERPRISE FUNDS FOR THE YEARENDED .S7iT.I�.Y__31-1983 Blair A-oartmeDt� Electric W4Ler 3ewer OPERATING REVENUES: User fees Sale of capacity Sale of merchandise Extensions Rental Other Total OPERATING EXPENSES: Purchased power Production Distribution Customer accounts Administration Depreciation Total OPERATING INCOME (LOSS) $2,282,462 $ 630,961 $ 224,724 OTHER REVENUE (EXPENSE): Interest income 2,865 Interest expense - Transfers -in - Transfers -out (261923.) 95,643 66,358) 225 NET INCOME (LOSS) (31,383) 270,109 Total, $3,138,147 308,177 15,690 30,856 47,597 _351833 _315761300 1,747,135 430,289 150,968 45,622 356,208 5541570 _312841792 291,508 89,108 29,555 217,171 ( 250,454) ( 10,666) ( 327,478) - - 225 _______225) 21-.2.9-9) x_541438.) ( 43,097) ( 68,641) 126,988 RETAINED EARNINGS (DEFICIT) -July 31, 1982 _44.93.796 _11825.1750 _11.2311642 _12661391) _332401797 RETAINED EARNINGS (DEFICIT) -July 31, 1983 84183413 X23 0 9 53 85 9 X11.1881545 x_3353032) X313671785 -20- 308,177 - - 9,826 5,864 24,480 6,376 $ 47,597 - - 9 _16 786_ 16.3843 13545 ______65 483256_216418731_6603044 _ 2263269 1,747,135 111,204 208,859 110,226 100,069 45,003 5,896 26,653 18,969 - 44,247 186,779 89,939 35,243 11x334_ 2.293292_ 1781800. 1351144 __551,5.81 _21.4011132 ___54.11570 __2861509 ( 7,325) 240,599 118,474 ( 60,240) OTHER REVENUE (EXPENSE): Interest income 2,865 Interest expense - Transfers -in - Transfers -out (261923.) 95,643 66,358) 225 NET INCOME (LOSS) (31,383) 270,109 Total, $3,138,147 308,177 15,690 30,856 47,597 _351833 _315761300 1,747,135 430,289 150,968 45,622 356,208 5541570 _312841792 291,508 89,108 29,555 217,171 ( 250,454) ( 10,666) ( 327,478) - - 225 _______225) 21-.2.9-9) x_541438.) ( 43,097) ( 68,641) 126,988 RETAINED EARNINGS (DEFICIT) -July 31, 1982 _44.93.796 _11825.1750 _11.2311642 _12661391) _332401797 RETAINED EARNINGS (DEFICIT) -July 31, 1983 84183413 X23 0 9 53 85 9 X11.1881545 x_3353032) X313671785 -20- CITY OF BLAIR, NEBRASKA COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION ENTERPRISE FUNDS FOR THE YEAR ENDED JULY 31, 1983 Blair Apartments Electric Water Sewer T to SOURCES OF WORKING CAPITAL: Additions to property Working capital provided by net - 69,206 operations: 15,904 122,553 Net income (loss) $(31,383) $270,109 Add items not requiring 196,364 Increase in current a current use of $( 9,609) $( 1,648) working capital - portion of long-term depreciation 11,334 229,292 Total (20,049) 499,401 Increase in deposits 37,932 Increase in restricted payable 60 6,956 Total sources of assets - (36,936) working capital (19,989) 506,357 $(43,097) $(68,641) $126,988 178,800 135,144 554,570 135,703 66,503 681,558 7,016 135,703 66,503 688,574 USES OF WORKING CAPITAL: Additions to property net - 69,206 37,443 15,904 122,553 Bond retirement - 100,000 76,364 20,000 196,364 Increase in current $135,412 $( 9,609) $( 1,648) $120,434 portion of long-term debt - 5,000 32,932 - 37,932 Increase in restricted 1,502 - - 1,502 assets - (36,936) 57,318 ( 1,020) 19,362 Total uses of working capital - 1371270 204,057 34,884 376,211 INCREASE (DECREASE) IN WORKING CAPITAL $(19,989) .$369,087 $(68,354) J-11,619 $3121363 CHANGES IN WORKING CAPITAL COMPONENTS: Increase (decrease) in current assets: Cash $( 3,721) $135,412 $( 9,609) $( 1,648) $120,434 Accounts receivable - user fees - 74,835 46,188 569 121,592 Accounts receivable-OPPD 1,502 - - 1,502 Accrued receivable -other 7,448 5,400 ( 652) 12,196 Accrued interest receivable 3,317 900 2,958 7,175 Investments (10,240) 145,300 (254,500) 35,000 (84,440) Inventory - ( 635) ( 422) - ( 1,057) Prepaid expenses - 1 696) ( 363) ( 446) ( 11505) Total -carried forward (13,961) 366,483 (212,406) 35,781 175,897 -21- CITY OF BLAIR, NEBRASKA COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION -22- ENTERPRISE FUNDS FOR THE YEAR ENDED JULY 311 1983 Blair Apartments Electric Water Sewer Total Total -brought forward $(131961) $3661483 $(212,406) $ 35,781 $175,897 CHANGE IN WORKING CAPITAL COMPONENTS: Decrease (increase) in current liabilities: Current portion of long-term debt ( 5,000) (32,932) (37,932) Accounts payable ( 6,028) (42,466) 3,849 ( 2,668) (47,313) Accrued interest - 18,627 7,986 224 26,837 Accrued expenses - ( 4,074) ( 4,074) Registered warrants - 35,517 165,149 ( 2,758) 197,908 Due to County Treasurer _ 1,040 1,040 Total ( 6,028) 2,604 144,052 ( 4,162) 136,466 INCREASE IN WORKING CAPITAL $(19=989) $369,087 $(68,354) $ 31,619 ,$312,363 -22- CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - BLAIR APARTMENTS FOR THE YEAR ENDED JULY 31, 1983 -23- Variance Favorable Budget Actu (Unfavorable) OPERATING REVENUES: Rental $ 41,922 $ 47,597 $ 5,675 Other 1,050 659 ( 391) Total revenues 42,972 48,256 5,284 OPERATING EXPENSES: Salaries 16,314 14,496 1,818 Social security 1,093 971 122 Employee insurance 1,361 1,881 ( 520) Utilities 13,070 11,196 1,874 Insurance 1,597 801 796 Maintenance 15,100 14,430 670 Contingency reserve 2,000 2 1,998 Other 785 29 756 MATERIALS AND SUPPLIES 2,275 441 1,834 CAPITAL OUTLAY: Equipment 2,000 - 2,000 Construction contracts 9.000 - 9000 Total operating expenses 64,595 44,247 201348 OPERATING INCOME BEFORE DEPRECIATION (21,623) 4,009 25,632 DEPRECIATION - (11,334) (11,334) OPERATING INCOME (LOSS) (21,623) ( 7,325) 14,298 OTHER REVENUE (EXPENSE): Interest income 2,100 2,865 765 Transfers - out (28,558) (26,923) 1,635 NET INCOME (LOSS) $(48,081) $(31,383) $16,698 -23- CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - ELECTRIC FOR THE YEAR ENDED JULY 31, 1983 OPERATING REVENUES: User fees Sale of capacity Sale of merchandise Extensions Other Total revenues EXPENSES: Purchased power Production: Salaries Repairs and maintenance Supplies Utilities Other Total Distribution: Salaries Supplies Vehicle expense Cost of store sold Building rent Other Total Customer accounts: Salaries Bad debt expense Other Total Administration: Salaries Social security Employee benefits Insurance Street light expense Utilities Professional fees Programming Equipment rental Office expense Other Payroll overhead capitalized Total Total expenses OPERATING INCOME BEFORE DEPRECIATION (Carried forward) Budget $2,163,100 304,350 4,500 30,000 13,500 2,515,450 1,867,000 116,000 5,000 5,000 1,875 1,000 128,875 70,500 16,500 7,700 3,000 6,400 1.900 106,000 21,000 7,000 3,100 31,100 47,000 18,000 38,500 21,000 42,000 3,300 15,000 7,500 6,200 7,750 5,550 211,800 21344,775 $ 170,675 -24- Actual $2,282,462 308,177 9,826 24,480 16,786 2,641731 Variance Favorable (Unfavorable) $119,362 3,827 5,326 ( 5,520) 3.286 126,281 1,747,135 119,865 103,946 4,524 2,203 251 280 111,204 67,848 14,983 7,137 2,535 5,277 2,289 100,069 19,412 6,573 668 26,653 46,396 15,935 35,748 13,236 43,596 2,879 31,023 5,066 1,769 5,333 5,201 ( 19,403) 186,779 21171,840 12,054 476 2,797 1,624 720 17,671 2,652 1,517 563 465 1,123 ( 389) 5,931 1,588 427 2,432 4,447 604 2,065 2,752 7,764 { 1,596) 421 (16,023) 2,434 4,431 2,417 349 19,403 25,021 172,935 $ 469,891 $299,216 CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - ELECTRIC FOR THE YEAR ENDED JULY 31, 1983 -25- Variance Favorable Budget Actual (Unfavorable) OPERATING INCOME BEFORE DEPRECIATION (Brought forward) $ 170,675 $ 469,891 $299,216 DEPRECIATION - ( 229,292) (229,292) OPERATING INCOME 170,675 240,599 69,924 OTHER REVENUE (EXPENSE): Interest income 50,000 95,643 45,643 Interest expense ( 47,338) ( 66,358) (19,020) Transfers - in - 225 225 NET INCOME $ 173,337 $ 270,109 $ 96,772 -25- CITY OF BLAIR. NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - WATER FOR THE YEAR ENDED JULY 31, 1983 OTHER REVENUES (EXPENSE): Interest income 50,000 89,108 39,108 Interest expense (241,080) (250,454) ( 9,374) Transfers - out - _1_225) �225 ) NET INCOME (LOSS) $ 18,700 1113.097) 1(61,797) -26- Variance Favorable Budget Actual, (Unfavorable) OPERATING REVENUES: User fees $580,000 $630,961 $ 50,961 Sale of merchandise 4,500 5,864 1,364 Extensions - 6,376 6,376 Other 15.5-0-0 16,843 _ 343 Total revenues 601,000 660,044 591044 EXPENSES: Production: Salaries 80,000 79,410 590 Chemicals and lime 40,000 35,614 4,386 Utilities 75,000 80,863 ( 5,863) Other 15.300 12,972 21328 Total 2101300 _2081859 11441 Distribution: Salaries 36,500 31,310 5,190 Supplies 4,500 3,064 1,436 Vehicle expense 7,500 5,335 2,165 Cost of store sold 4,000 3,631 369 Other 1,600 1,663 63) Total 541100 45.003 9,097 Customer accounts: Salaries 21,000 18,667 2,333 Other 1,.0.00 ___302 698 Total --1,2000 181969 3,031 Administration: Salaries 32,900 32,478 422 Social security 12,000 10,857 1,143 Employee benefits 27,000 28,446 ( 1,446) Insurance 5,880 4,083 1,797 Utilities 3,900 3,312 588 Professional fees 5,750 3,939 1,811 Programming 4,000 3,528 472 Equipment rental 4,340 1,238 3,102 Office expense 6,000 4,283 1,717 Other 3,050 2,209 841 Payroll overhead capitalized - X4.434) 4.434 Total 1041820 89.939 14,881 Total expenses 291 20 2621770 1281450 OPERATING INCOME BEFORE DEPRECIATION 209,780 297,274 87,494 DEPRECIATION - (178,800) (178,800) OPERATING INCOME 209,780 118,474 (91,306) OTHER REVENUES (EXPENSE): Interest income 50,000 89,108 39,108 Interest expense (241,080) (250,454) ( 9,374) Transfers - out - _1_225) �225 ) NET INCOME (LOSS) $ 18,700 1113.097) 1(61,797) -26- CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - SEWER FOR THE YEAR ENDED JULY -31, 1983 -27- Variance Favorable Budget Actual (Unfavorable) OPERATING REVENUES: User fees $245,300 $224,724 $( 20,576) Other 1,500 1,545 45 Total revenues 246,800 226,269 ( 20,531) EXPENSES: Production: Salaries 54,000 55,001 ( 11001) Repairs and maintenance 9,360 4,574 4,786 Chemicals 7,000 50,780 1,220 Supplies 3,000 2,482 518 Utilities 46,000 41,667 4,333 Other 500 722 ( 222) Total 119,860 110,226 9,634 Distribution: Salaries 5,000 2,391 2,609 Supplies 150 549 ( 399) Vehicle expense 3,500 2,683 817 Other 2.225 273 1,952 Total -10,875 __x,896 ____-4-93-9 Administration: Salaries 14,100 13,921 179 Social security 5,000 4,780 220 Employee benefits 9,300 6,528 2,772 Insurance 5,270 3,362 1,908 Utilities 1,295 1,190 105 Professional fees 19,500 1,323 18,177 Programming 3,000 1,512 1,488 Equipment rental 1,900 531 1,369 Office expense 2,350 1,496 854 Other 1,320 600 720 Total 63,035 35,243 _27,792 Total expenses 193,770 151,365 42,405 OPERATING INCOME BEFORE DEPRECIATION 53,030 74,904 21,874 DEPRECIATION - (135,144) (135,144) OPERATING INCOME (LOSS) 53,030 (60,240) (113,270) OTHER REVENUE (EXPENSE): Interest income 19,000 29,555 10,555 Interest expense (10,100) (10,666) ( 566) Transfers - out - (27,290) ( 27290) NET INCOME (LOSS) $ 61,930 68,641) $(130,571) -27- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND REVENUES BUDGET (CASH BASIS) AND ACTUAL FOR THE YEAR ENDED JULY 31, 1983 Moz Variance Favorable Budget Actual (Unfavorable) REVENUES: Taxes and special assessments: Property taxes $470,768 $450,588 $(20,180) Insurance tax 23,311 26,058 2,747 Receipts in lieu of taxes 4,600 5,637 1,037 State aid 98,827 81,795 (17,032) Motor vehicle pro rata - 2,454 2,454 Homestead relief 22,000 32,592 10,592 Franchise tax 45,000 58,821 13,821 Total 664,506 657,945 ( 6,561) Licenses and permits: Business licenses 6,000 9,608 3,608 Dog licenses 3,000 2,050 { 950) Licenses and fines 7,625 10,988 3,363 Total 16,625 22,646 6,021 Charges for services: Library 3,000 5,341 2,341 Landfill collections 20,000 32,608 12,608 Cemetery lots 5,500 4,825 ( 675) Grave openings 9,500 10,825 1,325 Swimming pool fees 12,000 16,220 4,220 Swimming pool lessons 2,500 2,611 111 Sale of fireworks 14,000 13,391 ( 609) Building and land leases 1,780 6,876 5,096 Rental 3,000 3,835 835 Total 71,280 96,532 25,252 INTEREST INCOME 20,000 40,376 20376 OTHER REVENUES: Federal grant -tennis courts 66,000 - (66,000) State grant - CETA 800 - ( 800) Police lab fund 1,100 2,931 1,831 Employee insurance withheld 2,700 2,745 45 Other revenues 50 10,653 10,603 Total 70,650 16,329 (54,321) TOTAL REVENUES $843,061 $833,828 $( 9,233) Moz CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL CONTINGENCY ALLOWANCE FOR THE YEAR ENDED JULY 31, 1983 HONORS' BANQUET CIVIL DEFENSE DIRECTOR SALARY SALARY INCREASES: General fund Street fund Blair Apartment fund LIBRARY BUILDING MAINTENANCE PROFESSIONAL FEES - Police LOT 14 WERNERS ADDITION RIGHT-OF-WAY CAPITAL OUTLAY: Radio equipment - Fire Department *Budgeted in total only -30- Variance Favorable Budset Act (Unfavorable) * $ 598 6,300 $65,000 8,966 658 213 4,232 1,330 1,800 399 $24,496 $40,504 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL POLICE DEPARTMENT FOR THE YEAR ENDED JULY 31, 1983 PERSONAL SERVICES: Salaries Social security Employees' insurance Retirement OPERATING EXPENSES: Legal Auditing Postage Printing and publications Training Telephone Travel Insurance Maintenance Miscellaneous SUPPLIES: Office supplies Gas and oil Uniforms Miscellaneous RENTAL EXPENSE CAPITAL OUTLAY: Office equipment Motor vehicles Radio equipment TOTALS -31- Variance Favorable Budget Actual (Unfavorable) $205,690 $195,936 $ 9,754 13,621 13,043 578 28,293 24,848 3,445 7,632 5,609 2,023 8,500 15,022 (6,522) 1,034 1,553 ( 519) 225 32 193 560 515 45 300 130 170 3,500 3,340 160 11000 495 505 6,990 4,438 2,552 11,550 7,031 4,519 428 861 ( 433) 1,250 1,855 ( 605) 16,243 11,669 4,574 6,070 5,331 739 3,585 2,906 679 32,300 28,918 3,382 850 748 102 10,000 10,599 ( 599) - 300 f 300) $359,621 5335,179 $24,442 -31- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL CEMETERY FOR THE YEAR ENDED JULY 31, 1983 -32- Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $ 23,200 $20,205 $ 2,995 Social security 1,554 1,354 200 Employees' insurance 2,865 2,818 47 Retirement 566 606 ( 40) OPERATING EXPENSES: Auditing 282 391 ( 109) Utilities 1,115 1,018 97 Insurance 626 303 323 Maintenance 3,200 1,972 1,228 Miscellaneous 375 135 240 SUPPLIES 2,652 2,469 183 RENTAL EXPENSE 9,500 7,125 2,375 CAPITAL OUTLAY: Equipment 3,350 2,668 682 Land 61000 3.061 57,939 TOTALS $110r285 X44,125-66160 -32- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL FIRE DEPARTMENT FOR THE YEAR ENDED JULY 31, 1983 PERSONAL SERVICES OPERATING EXPENSES: Travel Training Utilities Insurance Maintenance Miscellaneous SUPPLIES: Gas and oil Safety equipment Fire equipment Miscellaneous HYDRANT RENTAL CAPITAL OUTLAY: Radio equipment Specialized equipment TOTALS Variance Favorable Budget Actual (Unfavorable) $ 2,007 $ 1,877 $ 130 700 500 10,995 3,394 6, 900 245 1,650 3,000 1,500 135 12,000 500 89,500 $133,026 -33- 700 133 9,485 2,060 2,013 161 1,540 4,037 240 34 12,000 640 $34,920 367 1,510 1,334 4,887 84 110 (1,037) 1,260 101 ( 140) 89,500 $98,106 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL PARK DEPARTMENT FOR THE YEAR ENDED JULY 31, 1983 -34- Variance Favorable Budget Actu (Unfavorable) PERSONAL SERVICES: Salaries $26,563 $22,799 $3,764 Social security 1,680 1,427 253 Employees' insurance 2,789 2,323 466 Unemployment compensation 55 40 15 Retirement 420 - 420 OPERATING EXPENSES: Auditing 188 261 ( 73) Utilities 3,488 2,484 1,004 Insurance 1,117 581 536 Maintenance 5,400 5,743 { 343) Miscellaneous 375 115 260 SUPPLIES: Gas and oil 1,932 1,415 517 Miscellaneous 878 482 396 CAPITAL OUTLAY: Motorized equipment 6,250 5,380 870 Playground equipment 3,500 3,321 179 TOTALS $54,635 846,371 881264 -34- CITY QF BLAIR. NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL LIBRARY FOR THE YEAR ENDED JULY 31, 1983 -35- Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $ 38,620 $38,290 $ 330 Social security 2,588 2,565 23 Employees' insurance 3,720 2,667 1,053 Retirement 885 709 176 OPERATING EXPENSES: Auditing 328 444 ( 116) Postage 475 505 ( 30) Other office expense 636 441 195 Utilities 11,200 7,748 3,452 Telephone 326 377 ( 51) Insurance 1,270 556 714 Maintenance 3,415 3,361 54 Custodial contract 2,365 2,010 355 SUPPLIES: Supplies 1,490 1,381 109 Library materials 19,000 18,898 102 LEASE PAYMENTS 19,320 19,820 ( 500) CAPITAL OUTLAY - Office equipment 250 147 103 TOTALS 1105-888 199,919 $5,969 -35- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL SUPERVISED RECREATION FOR THE YEAR ENDED JULY 31, 1983 -36- Variance Favorable Budget Actual (unfavorable) PERSONAL SERVICES: Salaries $15,590 $11,685 $ 3,905 Social security 1,045 814 231 Employees' insurance 205 237 ( 32) OPERATING EXPENSES: Auditing 234 314 ( 80) Printing and publications 200 361 ( 161) Utilities 5,000 3,021 1,979 Telephone 405 213 192 Insurance 761 402 359 Maintenance 6,000 4,278 1,722 Little League program 1,500 1,500 - SUPPLIES: Gas and oil 863 654 209 Recreation supplies 1,500 1,696 ( 196) Fireworks 9,500 7,005 2,495 CAPITAL OUTLAY: Bleacher boards 5,525 6,391 ( 866) Motorized equipment 600 - 600 TOTALS $48,928 $38,571 $10,357 -36- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL SWIMMING POOL FOR THE YEAR ENDED JULY 31, 1983 PERSONAL SERVICES: Salaries Social security Employees' insurance OPERATING EXPENSES: Auditing Utilities Insurance Maintenance Miscellaneous SUPPLIES AND REPAIRS: Chemicals Miscellaneous CAPITAL OUTLAY - Small equipment TOTALS -37- Budget $23,822 1,566 414 328 3,420 758 1,505 546 2,760 775 503 36 39 Variance Favorable Actual (Unfavorable) $18,552 $5,270 1,135 431 461 ( 47) 444 ( 116) 4,264 ( 844) 364 394 3,026 (1,521) 738 ( 192) 1,707 1,053 1,030 ( 255) 503 831.721 X4,676 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL AIRPORT FOR THE YEAR ENDED JULY 31, 1983 PERSONAL SERVICES: Salaries Social security Employees' insurance OPERATING EXPENSES: Utilities Insurance Maintenance Miscellaneous CAPITAL OUTLAY - Motorized equipment TOTALS Variance Favorable Budget Actual ( n ayoxable) $ 700 $ 315 $ 385 47 21 26 28 - 28 620 550 70 1,013 720 293 2,500 1,001 1,499 312 14 298 1.000 - 11000 6 220 121621 X31 599 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL LANDFILL FOR THE YEAR ENDED JULY 31, 1983 -39- Variance Favorable Budg t Actual (Unfavorable) PERSONAL SERVICES: Salaries $19,862 $18,329 $ 1,533 Social security 11331 1,228 103 Employees' insurance 2,420 1,734 686 OPERATING EXPENSES: Auditing 187 29 158 Telephone 285 268 17 Utilities 469 323 146 Insurance 475 - 475 Maintenance 6,300 6,150 150 Miscellaneous 260 203 57 SUPPLIES: Gas, diesel and oil 4,209 4,290 ( 81) Miscellaneous 1,009 957 52 RENTAL EXPENSE 3,166 690 2,476 CAPITAL OUTLAY - Heavy and specialized equipment _30-,000 - _30000 TOTALS $69,973 $34,201 X35,772 -39- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL ANIMAL CONTROL FOR THE YEAR ENDED JULY 31, 1983 SUPPLIES: Gas and oil 425 136 Variance Chemicals 150 89 Favorable Uniforms Budget Actual (Unfavorable) Miscellaneous PERSONAL SERVICES: 627 278 CAPITAL OUTLAY - Equipment Salaries $15,250 $14,361 $ 889 Social security 1,022 955 67 Employees' insurance 2,943 2,266 677 OPERATING EXPENSES: Utilities 1,594 1,918 ( 324) Insurance 355 33 322 Maintenance 1,525 785 740 Miscellaneous 879 372 507 SUPPLIES: Gas and oil 425 136 289 Chemicals 150 89 61 Uniforms 550 462 88 Miscellaneous 905 627 278 CAPITAL OUTLAY - Equipment 700 267 433 TOTALS $26,298 $22,271 $4,027 -40- S November 15, 1983 "Honorable Mayor and Members of the City Council City of Blair Blair, Nebraska 68008 Gentlemen: In connection with our examination of the financial state- ments of the various funds and account groups of the City of Blair as of July 31, 1983, we have made a review of accounting procedures and internal control. While the primary objective of such a review is to afford us a basis of determining the scope of our audit procedures, it nevertheless presents us with an opportunity to submit, for management's consideration, suggestions for changes in procedures which, in our opinion, would strengthen internal control or contribute to the improve- ment of operating efficiency. The comments in this letter are based upon observations made in the course of such review. The review was not designed for the purpose of expressing an opinion on internal accounting control, and it would not necessarily disclose all weaknesses in the system. The matters discussed herein were considered during our examination of the above-mentioned financial statements, and they did not modify the opinion expressed in our report on those financial statements. However, we offer for your review the suggestions, as noted on the following pages and our proposed solution thereto. Please indicate in the "Action Taken" column of the letter, what corrective measures the City intends to implement with regard to each comment, and return an annotated copy of the letter to us. If you have any questions regarding these or any other matters, please feel free to contact us. Sincerely, BUESING DeSMET & ASSOCIATES F Dean DeSmet SECTION A MATERIAL WEAKNESSES IN INTERNAL ACCOUNTING CONTROLS (MATTERS REQUIRING CORRECTIVE ACTION) NONE - (Considering the fact that this review was not designed for the purpose of expressing an opinion on internal accounting control as explained in paragraph two of or letter) -1- SECTION B OTHER CONSTRUCTIVE SUGGESTIONS FOR IMPROVEMENT OF OPERATIONAL EFFICIENCY AND INTERNAL ACCOUNTING CONTROL RECONCIIIATION OF COMPUTER ACCOUNTS _ACTION TAKEN The implementation of the computerized accounting system for the City is complete. The system provides for double entry accounting and provides reports needed by the City. The accounting personnel must rely on these records and be able to support them. Monthly reconciliation of computer balances are needed in order for the accounting personnel to completely rely upon these computer balances. These reconciliations are simply a comparison of an outside record such as a bank statement or an internally prepared subsidiary record to the general computer control balance. These reconciliations are not being completed for all the necessary computer accounts. We recommend that the City review its reconciliation procedures and modify them so that computer balances are adjusted monthly so that the detail and computer balance agree. We have provided the specific computer accounts that need this reconciliation to the City Administrator and the City Clerk and we understand that steps are being taken to correct the above problems at the date of this letter. -2- TAX RECEIPTS ACTION TAKEN The Washington County Treasurer's office collects the tax revenues for the City of Blair and then each month pays them to the City. The receipts are accompanied by a letter indicating the type of taxes collected for the month. This letter, however, does not give adequate detail as to which fund, e.g. general, debt service, etc., to which receipts apply. Without further contacting the County Treasurer, this makes an accurate accounting of County receipts by fund impossible. We suggest that the City Clerk request the County Treasurer to provide a letter with all receipts that itemizes all receipts by fund. We understand this also has been acted on as of the date of this letter. WORD IN PROCESS ADJUSTMENTS The City of Blair does certain projects for customers through its utility department for a fee. A work order is completed for each project with all the necessary material and overhead charges accumulated. When the project is completed and the charges are billed to the customer an accounting adjustment is necessary to move the accumulated charges out of the work in process account. Presently, the charges are adjusted out of the work in process account to the plant in service account where they are depreciated over a 25 to 40 year life. We later remove these entries from the "plant in service" account by way of an audit adjustment. We recommend that the charges be adjusted to a cost of goods sold account rather than the asset account to provide a better matching of project sales and project costs in the period sold. -3- SECTION C APPENDIX - OBJECTIVE OF INTERNAL ACCOUNTING CONTROL The objective of internal accounting control is to provide reasonable, but not absolute, assurance as to the safeguarding of assets against loss from unauthorized use or disposition, and the reliability of financial records for preparing financial state- ments and maintaining accountability for assets. The concept of reasonable assurance recognizes that the cost of a system of internal accounting control should not exceed the benefits derived and also recognizes that the evaluation of these factors necessarily requires estimates and judgments by management. There are inherent limitations that should be recognized in considering the potential effectiveness of any system of internal accounting control. In the performance of most control procedures, errors can result from misunderstanding of instructions, mistakes of judgment, carelessness, or other personal factors. Control procedures whose effectiveness depends upon segregation of duties can be circumvented by collusion. Similarly, control procedures can be circumvented intentionally by management either with respect to the execution and recording of transactions or with respect to the estimates and judgments required in the preparation of financial statements. Further, projection of any evaluation of internal accounting control to future periods is subject to the risk that the procedures may become inadequate because of changes in conditions and that the degree of compliance with the procedures may deteriorate. -4-