The URL can be used to link to this page

FY1993 Audit Report CityITY OF BLAIR, NEBRASKA JULY 31� 1993 CITY OF BLAIR, NEBRASKA TABLE OF CONTENTS Page INDEPENDENT AUDITORS' OPINION 1-2 COMBINED STATEMENTS: Balance Sheet Combined Balance Sheet - All Fund Types and Account 26 Groups 3-4 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (Cash Basis) and in Fund Balances Actual - All Governmental Fund Types 5 Combined Statement of Revenues, Expenses and Changes Statement of Revenues, in Retained Earnings/Fund Balance - Budget (Cash Basis) and Actual - All Proprietary Fund Types and in Fund Balance - Budget Similar Trust Funds 6 General Fixed Assets Account Group: Statement of General. Fixed Assets 7 Statement of Changes in General Fixed Assets 8 General Long -Term Debt Account Group: Changes Statement of General. Obligation Bonds Principal (Cash Basis) and Interest Requirements by Year of Maturity C) Statement of Changes in General Long -Term Debt 10 Combined Statement of Cash Flow - All Proprietary Fund Types and Similar Trust Funds 11 Comparative Combined Balance Sheets - General and Special Revenue Funds 12 Comparative Combined Balance Sheets - Debt Service and Capital. Improvement Funds .13 Comparative Combined Balance Sheets - Enterprise and General Insurance Funds 14 Comparative Combined Balance Sheets - General Fixed Assets and General Long -Term Debt 15 Comparative Combined Statement of Revenues, Expenditures And Changes in Fund Balances - General and Special Revenue Funds 16 Comparative Combined Statement of Revenues, Expenditures And Changes in Fund Balances - Debt Services and Capitol Improvements Funds 17 Comparative Combined Statement of Revenues, Expenditures And Changes in Retained EArnings/Fund Balances - Enterprise and Insurance Funds 18 NOTES TO FINANCIAL STATEMENTS 1.9-25 STATEMENTS OF INDIVIDUAL FUNDS: SPECIAL REVENUE FUNDS: Combining Balance Sheet 26 Combining Schedule of Revenues, Expenditures and Changes in Fund Balances 27 Individual Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (Cash Basis) and Actual - Street Fund 28 Individual Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (Cash Basis) and Actual - M.I.R.F Fund 29 CITY OF jQAIR,, NEBRASK M ASKA A TABLE -OF_C9NTBNTS Pa -9 -Pm Individual Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (Cash Basis) and Actual - Development Fund 30 ENTERPRISE FUNDS: Combining Balance Sheet 31 Combining Statement of Revenues, Expenses, and Changes in Retained Earnings 32 Combining Statement of Cash Flow 33 Individual Statement of Revenues and Expenses - Budget (Cash Basis) and Actual - Water 34-35 Individual Statement of Revenues and Expenses - Budget (Cash Basis) and Actual Sewer 36 SUPPORTTUG SCHEDULES: Schedule of General Fund Revenues Budget (Cash Basis) and Actual 37 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Administration Department 38 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Contingency Allowance 39 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Police Department 40 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Cemetery 41 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Fire Department 42 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Park Department 43 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Library 44 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Supervised Recreation 45 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Swimming Pool 46 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Airport 47 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Landfill 48 Schedule of General Fund Expenditures - Budget (Cash Basis) and Actual - Animal Control 49 Report on Schedule of Federal Financial Assistance 50 Schedule of Federal Financial Assistance 51 Compliance Report - General Purpose 52 Internal Control Report - General Purpose 53-55 Compliance Report - Specific Requirements 56 Compliance Report - General Requirements 57 Internal CaMrol Report - Federal Financial Assistance 58-60 Honorable Mayor and Members of the City Council City of Blair, Nebraska Gentlemen: July 7, 1994 "Independent Auditor's Report" I have audited the general purpose 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 July 31, 1992, and 1993, as listed in the table of contents. These financial statements are the responsibility 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 GOVERNMENT AUDITING STANDARDS, issued by the comptroller General of the United States, and the provisions of the Office of Management and Budget Circular A-128, " Audits of State and Local Governments," 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, 1993, has not been compiled or audited by me and, accordingly, T 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 estab.lished guidelines for presentation of prospective financial statements. If tj),e amitted sLIIIIIq a_rl--is were included in the budgeted Mayor and Members of the City Council July 7, 1994 Page, 2 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. 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 1993, and the results of its operations and the changes in cash flow for its propriety fund types for the years 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 1993, and the results of operations of such funds and the (,Ibanges in cash flow of the individual proprietary funds for the years then ended, in confo:rmity 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 a CITY OF BLAIR, "_EBRASKZ'-_ COMBINED BALANCE SHEET - ALL FUND TYPES ANU ACCOUNT UROUPS P Amount available in Debt Servics for general 2ong-term debt retiremenz. Amount to be provided for retirement of general long-terw debt 194, GK� Contract receivable - OPPE) 4 7 7 TOTAL ASSETS j534 968 _7 71S 283 '0' 122 - QJ78,016 - i 9 7 9 ;4�114_ 226 JISS,85 See Notes to Financial Statements. -3- Gensial Genera]'', Fixed Long-teil Proprietar'; Fund 4 2 2 4 2 2 6 Special Debt Capital General Goneral Revenun service 1 mo r ov� ZIEW E insurance -n -W Cash $277,396 $ $114,572 42,283 $ 102,019 Receivables; Billed user fees - - 152 r 355 special assessments - - 168,000 Accrued interest. 3,232 394 - 134,091 13,206 Othe-- 12,000 47,215 632 investments -at cost (unrestricted) 202,500 - -- 25,000 360,095 Due from County Trea5ursr 39,202, 1,557 - - inventory -- - - 29,644 Prepaid expenses - - - 4,631 Restricted assets "' cash and invest ents - at cosf,_ - 221,391 - e3a,586 19 9V,3 Property - net of accumulated depreciaticn where applicable - - - 6,612,115 P Amount available in Debt Servics for general 2ong-term debt retiremenz. Amount to be provided for retirement of general long-terw debt 194, GK� Contract receivable - OPPE) 4 7 7 TOTAL ASSETS j534 968 _7 71S 283 '0' 122 - QJ78,016 - i 9 7 9 ;4�114_ 226 JISS,85 See Notes to Financial Statements. -3- Gensial Genera]'', Fixed Long-teil A a s 4 2 2 4 2 2 6 P Amount available in Debt Servics for general 2ong-term debt retiremenz. Amount to be provided for retirement of general long-terw debt 194, GK� Contract receivable - OPPE) 4 7 7 TOTAL ASSETS j534 968 _7 71S 283 '0' 122 - QJ78,016 - i 9 7 9 ;4�114_ 226 JISS,85 See Notes to Financial Statements. -3- see Notes to Financial statemenns, -4- CITY OF BLAIRn NEBIRASK A to ._NE BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUPS IT 11 Proprietary F u n d, GavernmIntal Fund Typosm V, p e s Types A ocount- jvgj2j__ General General Special Debt Capital G ei, i. e r a I Fixed Long-te,- General Revenue servic C 1 -Y .2 LLLCL, z e _yr, En Enherwrise insurance Assets Dwbk- Accounts payable Accrued $220,630 89,363 $ - SS,S14 596 interest - - 7,40-9 28,73S Accrued expenses Deposits Registered warranW,24,461 272,521 Bands payable - Revenue hands payabis V5,000 Lease payable 2,420,000 Total liabilities13.8 OEM 5, _39,363 19 7 5 C 9 6 Contributed capita! investment in general fixed assets 4,320,934 Retained earnings 4,224,226 Fund balance - reserved S31,331 179,637 Fund balance - unreserveC 3i4,338 19 , a a Total fund balances 314,338 _416 I 4,578,916 15 2 6 .2 19 3 WE, V _12 21 6_ TOTAL LIABILITIES AND FUND BALANCES 1_19,1?9 14�221,221 11SP pwl see Notes to Financial statemenns, -4- EXPENDITURES: Administration Contingency alloWance Police Departmew Cemetery Fire Departmen' Parks Department Library Supervised recreation Swimming pool Airport Landfill, Landfill closing accrual Animal control fund Capital outla%' Strect- DebL service, Difes. tzict construction Redemption of bonds Bond interest Total expenditures REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USESP Operating transfers - in Oparating transfers - Out Debt C 1 T Y W B L A T 2 , N E Variance 2 0, STATEMENT OY REVENUES, EXPENDITURES, (Unfaygrably) $279,349 COMEINED 539, 510 531,316 866 a 4 r! AND CHING29 AN FUND BALANCE 3C5'3�ls 7,17f� BUDSET (CAW BASIS) AND ACTUAL S7,350 aO,172 ALL GOVERNMENTAL FUMD TYPEE TW NEAR ENDED jULY 31?9 (150) Variancz� Favorab!G 131,550 1005SO 26,962 Actual jupfivorall1e) EEVENU22: i47,209 986,932 4,395 Taxcs and special assessmanQ; 161,516 9S2,537 30,240 Street revenues 3,272 Licenses and permit��. 37 937 35,070 o9,562 14,492 Charges for services 33,S15 210,640 212,09S A A 1111- 0 0 0 6,841 UA'' interest income-, 12,935 108,207 Bond procee&. 100,000 41,330 105,600 40,497 92,643 833 Other revenuc,,,3 Total rcvenuw� 200,000 i99,506 1,324,890 1.346.809 EXPENDITURES: Administration Contingency alloWance Police Departmew Cemetery Fire Departmen' Parks Department Library Supervised recreation Swimming pool Airport Landfill, Landfill closing accrual Animal control fund Capital outla%' Strect- DebL service, Difes. tzict construction Redemption of bonds Bond interest Total expenditures REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USESP Operating transfers - in Oparating transfers - Out Debt 259 724 1 '5 Variance 2 0, Pavorable Budget Actual 20,000 (Unfaygrably) $279,349 1274,S51C,(4,998) 539, 510 531,316 866 a 4 r! 2 5 0 0 0 3C5'3�ls 7,17f� 275,102 259 724 1 '5 2 0, 0 0 - 20,000 539, 510 531,316 a, 1 q-, 7,17f� S7,350 aO,172 S1,240 (150) 131,550 1005SO 26,962 i47,209 14,307 161,516 30,240 26,96S 3,272 ;3,586 37 937 6,049 33,S15 , 25, 472 0,343 95,272 12,935 108,207 100,000 41,330 105,600 40,497 (5,500) 833 200,000 i99,506 4 296,000 274,699 21,301 64,920 65,144 (224) 5 ;15S ,W) 139,620 (287 443 (293,96S) (6,520) 259,814156 199 70,200 52,307 Q3 i too REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES (81,592) FUTD BALANCE - july 31. 1992 104soqq 1? 314 .332-, FUND BALANCE - WY 31, 1993 See Notes to Financial Statements, -5- 1191j4I 017,20) (2?1036) j (20413) EXPENSES - Personal serviceE Operating expenses Materials and oupplies Construction contracts, Rental expense Depreciatic-c Payment of inzurance bonolits Total GPERATING WCOME (LCSs) OTHER REVENUE (EXPEPSE). int3rest incoma Gnterest expense Bond refunding costs Operating transfers - in Operating transfers - ouL NET iNCOM9 (LOSS) RETAINED EARNINGS/PUND BALANCE july 31, 3992 RETAINED EARVINGS/FUND nALANCE july 21, 1993 074, C20, 220,900 152, 50C 6 2 1,523,552 5,253 ) w, 35s) 12 , 220 6 5 , 3 5 C-,-, (716) (276 655) (264,614) Variance Favorable judget Actu'a-1, (Unfavorable) 240,3SO A 0 , U 0 U 16,266 2,15.086 '7 CITY OF LAIR. WFORRA COMBINED STATEMENT OP REVENUES, EXPENSES AND CHANGES 1N EETAINED EARNINGS/FUND BALANCE BUDWT (CASH BASIS) AND ACTUAL ALL PROPRIETARY PUND TYPES AND SIMILAR TRUST FUNDS D 01 i Onterprise Funds Variance Favorable Mae! Actual unflylarable) OPERATING REVENUES: User fees 838,500 S01,2SS (37,212) Sale of mewhandise 11,000 16,875 5,S75 Rentai 12,000 12,000 insurance contyibutions - other i n Total 872, 11Q 243 048 ___12S,762) EXPENSES - Personal serviceE Operating expenses Materials and oupplies Construction contracts, Rental expense Depreciatic-c Payment of inzurance bonolits Total GPERATING WCOME (LCSs) OTHER REVENUE (EXPEPSE). int3rest incoma Gnterest expense Bond refunding costs Operating transfers - in Operating transfers - ouL NET iNCOM9 (LOSS) RETAINED EARNINGS/PUND BALANCE july 31, 3992 RETAINED EARVINGS/FUND nALANCE july 21, 1993 074, C20, 220,900 152, 50C 6 2 1,523,552 5,253 ) w, 35s) 12 , 220 6 5 , 3 5 C-,-, (716) (276 655) (264,614) Variance Favorable judget Actu'a-1, (Unfavorable) 240,3SO A 0 , U 0 U 16,266 2,15.086 '7 CITY OF BLAIR, NEBRASKA STATEMENT OF GENERAL FIXED ASSETS JULY| 1993 ------ Land Vehicles Total ' ==== E_---_-_ 8EIVERAI. FUND: Administration $ 15,000 $ 696,695 13,730 _138,440 $ 863,865 Police - - 64,579 58,857 123,436 Cemetery 115,000 18,084 14,553 15,857 163,494 Fire - - 565,963 49,5I2 515,475 Park 97,952 358,873 14,035 143,102 813,962 LibIary 22,500 1I6,600 - 23,396 167,396 Supervised, recreation - 274 - 27,375 27/649 Gwi�mirlg pool 100,000 237,581 - 185,461 503,042 Airport - - - - - Landfill 15,000 6,700 - 82/007 103/707 Animal control - 5,686 13,450 2,558 31,702 SPECIAL B8V800E FUNDS - Street 10,000 206,274 225,797 385,033 817,094 CAPITALIZED LEASE - Library _----�--- ' _-- - 203,404 TOTALS U75�4!�Z 1,850, 171 15102^117� see not-- s to F ioancial 8tgmezzta. -7- CITY OF BLAIR,__NEBRASKA STATEMENT OF CHANGES IN GENERAL FIXED ASSETS FOR THE YEAR ENDED JULY 31,.1993 Balance Balance July 31, July 31, 1992 Additions Dispositions 1993 GENERAL FUND: Administration Police Cemetery Fire Park Library Supervised recreation Swimming pool Airport Landfill Animal control SPECIAL REVENUE FUNDS -- Street CAPITALIZED LEASE Library TOTALS $ 862,681 1,184 $ 863,865 1.18,552 18,490 13,606 123,436 148,093 19,126 3,725 163,494 414,904 200,571 - 615,475 573,331 44,231 3,600 613,962 165,737 1,659 - 167,396 27,649 27,649 503,042 - 503,042 220,446 220,446 - 103,707 - 103,707 20,880 822 21,702 666,310 150,784 817,094 __ 203,-404 - - - 203,404 1,4,028,736 $436,867 1241 37_i 14 224 _,_226 See flot*e s �'-X F attic4al Statements. ffm Year Ending July 31, _ 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, 1993 Principal Reauirements $ 40,534 40,994 22,323 20,000 25,000 25,000 2-5,000 $198,851. Interest Requirements 14,447 10,264 6,370 5,155 3,826 2,312 775 43,149 See Notes to Financial Statements. -9- Total $ 54,981 51,258 28,693 25,155 28,826 27,312 25,775 �$242,000 CITY OF BLAIR, NEBRASKA STATE14ENT OF CHANGES IN GENERAL LONG-TERM DEBT FOR THE YEAR ENDED JULY 31, 1a943_____ See Notes to Financial Statements. -10- Balance Balance Interest July 31, July 31, Dated Description Rate 1992 Additions Deductions 1993 6/15/88 Various purpose 5.25-6.40% $ 75,000 $ $ 45,000 $ 30.,000 1/01/91 IBM financing lease 8.06% 18,994 5,143 13,851 10/15/91 Fire department bonds 5.00-6.20% L70,000 15_,_000 155,000 TOTAL $263,994 "5JI43 '_198,851 See Notes to Financial Statements. -10- CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF CASH FLOW ALL PROPRIETARY FUND TYPES AND SIMILAR TRUST FUNDS FOR THE YEAR ENDED JULY 31, 1993 CASH FLOW FROM INVESTING: Purchase of property (107,917) Interest income 58,661 Transfers - net (181,633) Decrease (increase) in accrued interest receivable 4,662 Cash from (used by) investing (226,227) CASH FLOW FROM FINANCING: Proceeds from long-term debt 185,000 - Reduction of long-term debt (75,000) - Decrease (increase) in restricted assets 309,607 - Interest expense (139,305) - Bond refunding costs (188,530) - Increase (decrease) in accrued interest payable __CL3_, 878 Cash from (used in) financing __77_,8_94 NET INCREASE (DECREASE) IN CASH (163,760) 16,267 CASH AND CASH EQUIVALENTS - Beginning of the period 625,874 3712 CASH AND CASH EQUIVALENTS - End of the period t_A62,11_14 19,9-7-9 See Notes to Financial Statements. -11- General Enterprise Insurance Funds Funds CASH FLOW FROM OPERATIONS: Net operating income (loss) $(341,414) $ 16,266 Adjustment to reconcile net income to net cash from operations: Depreciation 276,655 - Decrease (increase) in accounts receivable -user fees (11,640) - Decrease (increase) in accounts receivable -other 13,498 - Decrease (increase) in inventory (352) - Decrease (increase) in prepaid expenses 563 - Increase (decrease) in accounts payable 42,497 1 Decrease in accrued expenses 566 - Increase (decrease) in deposits payable 4,200 - Net cash provided (used) by operations (15_!42. _7) 16,267 CASH FLOW FROM INVESTING: Purchase of property (107,917) Interest income 58,661 Transfers - net (181,633) Decrease (increase) in accrued interest receivable 4,662 Cash from (used by) investing (226,227) CASH FLOW FROM FINANCING: Proceeds from long-term debt 185,000 - Reduction of long-term debt (75,000) - Decrease (increase) in restricted assets 309,607 - Interest expense (139,305) - Bond refunding costs (188,530) - Increase (decrease) in accrued interest payable __CL3_, 878 Cash from (used in) financing __77_,8_94 NET INCREASE (DECREASE) IN CASH (163,760) 16,267 CASH AND CASH EQUIVALENTS - Beginning of the period 625,874 3712 CASH AND CASH EQUIVALENTS - End of the period t_A62,11_14 19,9-7-9 See Notes to Financial Statements. -11- CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED BALANCE SHEETS GENERAL AND SPECIAL REVENUE FUNDS FOR THE YEARS ENDED JULY 31, 1992 AND 1993 LIABILITIES SPECIAL GENERAL REVENUE $220,630 FUNDS FUNDS Accrued expenses 1992 1993 1992 1993 ASSETS Total Liabilities 98,949_220,630 Cash $ 20,657 $277,396 $ - $ - Receivables: Accrued interest 256 3,233 5715 394 Other - 12,000 47,215 Investments - at cost - - Total Fund Balances (unrestricted) 154,000 202,500 - Due from County Treasurer 28,125 39,839 - Restricted assets - cash and AND FUND BALANCES investments - at cost - - 135,902 21 391 TOTAL ASSETS JZQ 3 038 $534_,968 113677_ X269,000 LIABILITIES Accounts payable 58,949 $220,630 $ 10,201 $ 89,363 Accrued expenses 40,000 -- Total Liabilities 98,949_220,630 __10,201__ 89,363 FUND BALANCES Fund balance - reserved - - 126,276 179,637 Fund balance - unreserved 104,089 314338 -- - - - - Total Fund Balances 104,089 314,338 126,276 1.79,637 TOTAL LIABILITIES AND FUND BALANCES $203,038 $_534_,96�8 $1.36,477 $2691000 See Notes to Financial Statements. -12- CITY OF BItAIR, NEBRASKA COMPARATIVE COMBINED BALANCE SHEETS DEBT SERVICE AND CAPITAL IMPROVEMENT FUNDS FOR THE YEARS ENDED JULY 31, 1992 AND 1993 ASSETS Cash Receivables: Special assessments Accrued interest Investments - at cost (unrestricted) Due from County Treasurer Contract receivable - OPPD TOTAL ASSETS LIABILITIES Accounts payable Accrued interest Registered warrants Total Liabilities DEBT SERVICE FUNDS 1992 1993 $ 56,796 $114,572 28,392 168,000 1,184 - 228,000 - - 1,557 $314,372 $284,129 68,557 $ - - 7,449 - - 272,521 68,557 279,970 CAPITAL IMPROVEMENT FUNDS 1992 1993 64,584 $ 42,283 136.,568 134,491 25,000 25,000 4,549,501 4,477,142 14,775,653 _$4,678,916 FUND BALANCES Fund balance - unreserved 245,815 4,159 _4,779,6_53 678 TOTAL LIABILITIES AND FUND BALANCES $314,37_ $284,129 ",775,653 14,678,91.6 See Notes to Financial Statements. -13- CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED BALANCE SHEETS ENTERPRISE AND GENERAL INSURANCE FUNDS FOR THE YEARS ENDED JULY 31, 1992 AND 1993 ASSETS Cash Receivables: Billed user fees Accrued interest Other Investments - at cost (unrestricted) Inventory Prepaid expenses Restricted assets - cash and investments - at cost Property - net of accumulated depreciation, where applicable TOTAL ASSETS LIABILITIES Accounts payable Accrued interest Accrued expenses Deposits payable Revenue bonds payable Total Liabilities FUND BALANCES Contributed capital. Retained earnings Fund balance - reserved Total Fund Balances TOTAL LIABILITIES T AND FUND BALANCES ENTERPRISE FUNDS 1992 1993 GENERAL INSURANCE FUNDS 1992 1.993 154,689 102,019 150,715 162,355 17,868 13,206 14,130 632 471,185 360,095 29,292 29,644 5,194 4,631 743,193 433,586 3,712 19,979 _61780,853 6,612,115 --- _.%8,367 119 $ 3 j9-,-979 46,317 $ 88,814 42,616 28,738 3,439 4,005 20,261 24,461 2,310,000 2,420,000 2,422,633 - 2,566,018 595 595 0 596 4,320,934 4,320,934 1,623,552 831,331 - -- 117 19,383 51944e486 5,152,265 3,11? 19,383 -$i -,357 119 �718 , 283 3 712 -$-_1-9 979 See Notes to Financial Statements. --14- CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED BALANCE SHEETS GENERAL FIXED ASSETS AND GENERAL LONG-TERM DEBT FOR THE YEARS ENDED JULY 31, 19921' AND 1993 GENERAL GENERAL FIXED LONG-TERM ASSETS DEBT 1992 1993 1993 __1992 ASSETS Property net of accumulated depreciation, where applicable $4,028,736 $4,224,2126 $ $ - Amount available in Debt Service for general long-term debt retirement 245,815 41,159 Amount to be provided for retirement of general long-term debt 18,179 191,_6_92 TOTAL ASSETS 14,028,736 $4,224,226 1263,994 $198,851 LIABILITIES Bonds payable $245,000 $185,000 Lease payable 9 9 4 13-, 8 51 Total Liabilities 4 198,851 FUND BALANCES Investment in general fixed assets _0.23,736 _41_224L226 TOTAL LIABILITIES AND FUND BALANCES 1�4,028,736 14.224,2_Z6 $263a94 a198,851 See Notes to Financial Statements. -15- CITY OF' BLAIR, NEBRASKA COMPARATIVE COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES GENERAL AND SPECIAL REVENUE FUNDS FOR THE YEARS ENDED JULY 31, 1992 AND 1993 GENERAL FUNDS 1992 1993 REVENUES Taxes and special assessments $ 920,496 986,932 Street revenues - - Licenses and permits 40,790 49,562 Charges for services 179,790 212,098 Interest income 11,380 6,841 Other revenues 81,5 0 1,K / 6 -- Total revenues -1 2331,346,809 EXPENDITURES Administration Contingency allowance Police Department Cemetery Fire Department Parks Department Library Supervised recreation Swimming pool Airport Landfill Landfill closing accrual Animal control M.I.R.F. fund Capital outlay Street Total expenditures REVENUES OVER (UNDER) EXPENDITURES 249,869 259,724 21,325 - 525,506 525, 506 531,316 70,152 80,172 63,506 61,240 82,563 1.04,588 141,388 1.47,209 25,630 26,968 37,156 37,537 47,648 25,472 57,530 95,272 40,000 105,600 39,338 40,497 1, 4 0_1 _,6 11 1 ,51 5 -5 9 5 (167,645) (168,786) OTHER FINANCING SOURCES (USES): Operating transfers - in 222,687 416,013 Operating transfers - out ('8,007) (36,_973) REVENUES AND OTHER FINANCIAL SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES FUND BALANCE - BEGINNING FUND BALANCE - ENDING (22,965) 210,249 127.,054 - 1041-089 $ -j--0-4-,-089 14_,338 See Notes to Financial Statements SPECIAL REVENUE FUNDS 1'992 1993 26,628 354,2453 13,271. 39 152 1.3,836 729,467 743,303, (349,151) (182,043) 115,249 235,404 (233,902) 53,361 360,178 _126,276- _$126,2'76 6 ., 2 7 6- _$126,2 6 $179,637 CITY OF I R 4 E B RAS, K A COMPARATIVE COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES DEBT SERVICES AND CAPITOL IMPROVEMENTS FUNDS . FOR THE YEARS ENDED JULY 31, 1992 AND 1993 DEBT SERVICE FUNDS 1992 1993 REVENUES 151,815 Taxes and special assessments 831,046 Interest income 7,999 Bond proceeds 1701000 Total revenues 2611045 115,655 EXPENDITURES 13 0,16 0 Administration 4,744 Capital outlay - Debt service: District construction 78,850 Special assessment Foreclosure 120/716 Redemption of bonds 57,781 Bond interest 9,89L Total expenditures 271,982 REVENUES OVER (UNDER) EXPENDITURES (1.0,937) OTHER FINANCING SOURCES (USES): Operating transfers - in 151,815 Operating transfers - out (25,223) REVENUES AND OTHER FINANCIAL SOURCES OVER (UNDER) EXPENDITURES AND OTHER IUSES 115,655 FUND BALANCE - BEGINNING 13 0,16 0 FUND BALANCE - ENDING 5 $274, 351 866 _275_217 2,212 199,506 274,699 65,144 — 27 ,-§ 19 569,180 (293,963) 52,;30°; CAPITAL IMPROVEMENT FUNDS 1.992, 421,311 993 409 103 9 4 21 , 3 1, A 0 1 4 ---,1.0 3 121,185 20,725 121.185 20,725 300,126 388,378 69, 700 2 , 5 0 to -L4 9 0 , 7 7 5 (487,615) (241,656) (120,949) (96,737) 245,815 4,896,--602 $ 4 -, 7 7 5_,_ 6 �33 �4, 15 9 $.4,775,653 See Notes to Financial Statements CITY OF BLAIR, NE-BRASK.A COMPARATIVE COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN RETAINED EARNINGS/FUND BALANCES ENTERPRISE AND INSURANCE FUNDS FOR THE YEARS ENDED JULY 31, 1992 AND 1093 ENTERPRISE INSURANCE FUNDS FUNDS 1992 1993 1992 1.993 OPERATING REVENUES: User fees $ 808,506 $ 801,288 Sale of merchandise 22,620 16,875 Rental 12,000 12,000 Insurance contributions - - 262,369 246,444 Other 30,270 1.3 ,1.85 1, 343 Total 873,396 843,348 263,712 246,444 EXPENSES: Personal services 454,550 479,873 - - Operating expenses 216,881 22-7,258 - - Materials and supplies 72,159 112,430 - - Construction contracts 20,105 87,150 - - Rental expense 866 1,396 - - Depreciation 273,048 276,655 - - Payments of insurance benefits -- --- - 275,799 230,178 Total 037 _,6 0 184,762 I j 75.799 27 - _2 230 ,178 � OPERATING INCOME (LOSS) (164,213) (341,414) (12,087) 16,266 OTHER REVENUE (EXPENSE Interest Income 81,653 58,661 Interest expense (173,690) (139,305) Bond refunding costs (188,530) Gain (loss) on fixed assets (169,449) - Operating transfers - in 311,049 68,911 Operating transfers - out _276,496) _0,5 -14 NET INCOME (LOSS) (391,146) (792,221) (12,087) 16,266 k % RETAINED EARNINGS/FUND BALANCE July 31, 1992 2,014 1,62 3, 5 15, 2 0 4, ---- 3,117 RETAINED EARNINGS/FUND BALANCE July 31, 1993 $1,fi23, 55:4 �19,383 See Notes to Financial Statements CITY OF BLAI _U_ TF _BLAIR,_NEBRhS1V11 NOTES TO FjNANCjA0_0TlTEMEiN 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 Ancyant Gruupg.: 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 Fund, are used to record the general operations of the City; 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 account groups, that are equipment and long-term General long-term bonded Service Fund. B. Freeport_ inq_EntitY: and general long-term obligation used to account for property and obligations of governmental funds. debt was repaid through the Debt 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, 1993. 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 agGncy receives a financial benefit no 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. -19- CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEME R71S optiriued SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Designation of management -The City Council appoints the City 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 rriatters-The responsibility aind 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 on any of its funds. 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 -20- the lower of cost (first -in, The consumption method is expenditure recognition. CITY OF BLAIR, NE-BRASKA NOTES TO FINANCIAL STATEMENTS, Continued 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) F 2Iq��rop t 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 as 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_Rasis: 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, and 1993. I. Investments: The Investments are bank Certificates of Deposit 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 indication year end. means that securities name. investments are categorized to give an of the level of risk assumed by the City at The City's investments are all category 1, which the investments are insured or registered. The are held by the City or its agent in the City's --21- CITY OF BLATR, NEBRASKA NOTES TO FTNANCIA1STATEMENTS,_Cantinuesd 2. RESTRICTED ASSETS 175,000 1995 180,000 Restricted assets consist of cash, certificates 90,00) of deposit, and government securities. The assets are restricted as follows: 199093 Special Enterprise Insurance Revenue Fund Funds_ Streetfunds $100,000 $ M.I.R.F funds 77,329 Development funds 44,062 Bond and Interest sinking fund - 409,125 Utility deposit fund 24,461 Reserve for insurance claims __19,979 Total restricted assets 1433,58l 1_19,979 1992 Special Enterprise Insurance Rev nue Fund Funds -- Funds -- Street funds $115,592 $ $ M.I.R.F funds 20,310 Bond and interest sinking fund - 722,932 Utility deposit fuK 20,261 Reserve for insurance claims - 3 Total restricted assets 110',002 743.193 13,7,112 3. LONG-TERM DEBT Total Water Bonds: 11/1/92 3.2-6.3% $2,420,000 Annual Principal Requirements For Water Bonds Year Ending July 31, 1994 175,000 1995 180,000 1996 95,000 1.997 90,00) 1998 80,000 1999-2014 TOTAL 1� -22-- CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS, c9,n,tAn1J1_e_d 3. LONG-TERM DEBT (continued The City of Blair secured the November 1, 1992 water bonds by pledging $20,000 of annual M.I.R.F. receipts to the payment of the bonds through July 31, 1999. The issuance of the November 1, 1992 bonds provided funds for the defeasance of an June 15, 1988 issue callable May 1, 1994. The amount defessed was $2,310,000. The economic gain of the refinance was $430,648. The funds necessary for defeasement have been placed in non=accessible trust accounts. 4. PENSION PLANS The city has two pension plans covering substantially all 2 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 and 1993, were $55,321 and $56,916 respectively. Contributions 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. Policemen -terminating before retirement age receive payment for their contributions to date of termination plus interest accrued and the 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. Contributions of $35,859 for 1992 and $35,186 for 1993, were 12% of gross wages which compiles with statutory requirements. The City contributed 6 percent of gross wages and the policemen contributed 6 percent. The City has no material pension benefit obligations as of January 1, 1990, per Actuarial Report dated November 7, 1.990. 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 and 1993. 2PAM CITY OF-BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS, continued 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 commencing 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 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 the General fund as of July 31, 1992 and 1993, in the amount of $40,000 and $145,600 respectively. 7. ACCOUNTS RECE-iVABLE - SPECIAL ASSESSMENTS The City of Blair's special assessments outstanding as of July 31, 1992 and 1993, are composed of the following: Special assessment current interest Special assessments principle and available not levied 1992 $ 6,192 22,200 1993 $168,000 Total Special Assessments Receivable $,_ 28_392 X168,000 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 ended July 31, 1992. The property was given a zero carrying value in the financial statements. CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS, Cjpntjnued 0 LEASE COMMITMENTS The City of Blair has the following lease commitments: Lease Number Lease Date Terms Annual Amount 97184 3-06-79 Renewed in 1991 for 5 years $180 97021 6-26-78 Renewed in 1988 for 5 years $180 97295 9-07-79 One year $100 98565 8-01-083 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 and 1993, were $263,712 and $246,444 respectively. Dental and vision benefits are limited and do not create significant risk for the City. 10. SUBSEQUENT EVENT. The City of Blair authorized the issuance of Economic Development Fund Sales Tax Revenue Bonds in the amount of $600,000 for the purpose of funding the Blair Economic Development Program. The City pledged future sales tax receipts for payment of the principal and interest. This issuance was passed October 12, 1993 -25- CITY OF' BLAIR, NEBRASKA. COMBINING BALANCE SHEET - SPECIAL REVENUE FNDS IT U L y 31 , 19 9 3 Street Fund CASH SAVINGS $ - INVESTMENTS 100,000 SALES TAX RECEIVABLE - ACCRUED INTEREST RECEIVABLE 394 TOTAL $100,394 ASSETS M. I , R . F. —Fund $ 77,329 $ 77,32.9 LIABILITIES AND FUND BALANCES ACCOUNTS PAYABLE $ 61,594 $ 27,769 FUND BALANCE 38,800 --.--49,560 TOTAL $100,394 �_ 77,329_ Development Fund_ $ 44,062 47,215 7 91.1.2_ :? `7 91 2217 Total $121,391 100,000 47,215 394 t?Ao nnn $ 89,363 179,637 _'269000 CITY OF BLAIR_, NEELRjkSKA COMBINING SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES SPECIAL REVENUE FUNDS FOR THE YEAR ENDED JULY 31,1293 --- -27- Street M.I.R.F. Development Fund Fund Fund Total REVENUES: Street revenues $378,128 $ - $ $378,128 M.I.R.F. revenues - 26,478 26,478 Interest on investments 6,210 1,331 7,541 Sales and use tax - - - 94,100 94.,100 Total revenues 384,338 94,100 506 ?47 EXPENDITURES: Salaries 169,195 - - 169,195 FICA 12,197 - - 12,197 Retirement -7,603 - - 7,603 Employee insurance 31,665 - - 31,665 Legal. - - - - Engineering - - Auditing 1,713 - 1,713 Office expenses 208 - 1108 Dues 313 - 313 Utilities 5,126 5,14,)6 Telephone 629 629' Travel 25 25 Training - - Insurance 10,176 - 10,176 Maintenance 27,250 - 27,250 Street lighting 80,424 - 80,424 Contingency reserve - - - Car expense 610 - - 610 Collection fees 3 - 2,823 2,826 Sand, gravel and rock 14,411 - - 14,411 Gas, diesel and oil 12,002 - - 12,002 Materials and supplies a ,-),-09 - - 2,909 Rental 605 - - 605 Capital outlay: Building 20,604 130,180 150,784 Motorized equipment - - - Street improvements 157,619 - 157,619 Total expenditures 555,287 _130 -1.80 2,823 688,290 REVENUES OVER (UNDER) EXPENDITURES (170,949) (102,3711) 91,277 (182,043) OTHER FINANCING SOURCES (USES): Operating transfers - in 103,768 131,636 -- 235,404 Operating transfers - out - - - REVENUES OVER (UNDER) EXPENDITURES (67,181) 29,265 91,277 53,361 FUND BALANCE (DEFICIT) - July 31, 1992 105,981 201295 ---- 126,276 FUND BALANCE - July 31, 1993 1-3-8 --��-0-0 $ �49 , 5 6 0 ..... %1-L2 17- $179,637 -27- CITY OF INDIVIDUAL STATEMENT OF REVENUES, BUDGET (CASH BASIS) AND ACTUAL FOR THE BLAIR, NEBRASKA EXPENDITURES AND CHANGES SPECIAL REVENUE FUNDS - ENDED JULY 31,_ 1993 IN FUND BALANCE STREET FUND -YEAR Var'Lance Favorable Budget Actual (Unfavorable) REVENUES: Highway allocation 310,000 $322,110 $ 12,110 County road tax 200 282 82 Motor vehicle pro -rata 3,600 (3,600) Incentive payment 3,000 3,000 State maintenance agreement 14,532 14,532 - Curb and street cutting 500 96 (404) Sale of rock 300 1,934 1,634 Equipment rental 1 000 1,529 529 Interest on investments 8,000 6,210 (1,790) Reimbursed expenses - -34,645 34,645 Total Revenues 341,132 38438 - 43,206 EXPENDITURES: Salaries 171,170 169,195 1,975 FICA 13,095 12,197 898 Retirement 7,500 7,603 (103) Employee insurance 33,350 31,665 1,685 Legal 300 - 300 Engineering 3,000 - 3,000 Auditing 1,700 1,713 (13) Office expense 200 208 (8) Dues 200 313 (113) Utilities 4,800 5,126 (326) Telephone 900 629 271 -Travel 200 25 175 Training 200 - 200 Insurance 11,600 10,176 1,424 Maintenance 18,900 27,250 (8,350) Street lighting 80,000 80,424 (424) Contingency reserve 3,000 - 3,000 Car expense 600 610 (10) County Treasurer frees - 3 (3) Sand, gravel, and rock 11,000 14,411 (3,411) Gas, diesel, and oil 10,500 12,002 (1,502) Materials and supplies 3,225 2,909 316 Rental 5,000 605 4,395 Capital outlay: Buildings 25,000 20,604 4,396 Equipment 750 - 750 Street improvements 121,500 157,619. (36,119) Total expenditures 527,690 555_,287_ (27,591) REVENUES OVER (UNDER) EXPENDITURES (186,558) (170,949) .15,609 OTHER FINANCING SOURCES (USES): Operating transfers -in 133,500 103,763 (29,732) Operating transfers -out - - - REVENUES OVER (UNDER) EXPENDITURES (53,058) (67,181) $(14_L123) FUND BALANCE - JULY 31, 1992 105,981 _1051.981 FUND BALANCE - JULY 31, 1.993 1 52,923 $ 38,8Q0 IrWom 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, 1993 REVENUES:- M.I.R.F. revenues Interest income Total revenue EXPENDITURES: Street building REVENUES OVER (UNDER) EXPENDITURES BEFORE TRANSFERS TRANSFER IN REVENUES OVER (UNDER) EXPENDITURES FUND BALANCE - July 31, 1992 FUND BALANCE - July 31, 1993 -29- Variance Favorable Rqdgelt Actual (Vrifavorable ) $ 26,600 $ 26,478 $ (122) 100 1,331, 1,231 2 6,_7_0 0 _?7,- 9 1,109 -1 3. —5, - 00 0- ( 1C18 0 --Z.4-AL, 2 -Q (128,300) (102,371) 25,929 110,000, 1_31,636 21,636 _ (18,300) 29,265 47,565 _20., 295 ----20,29.5 : 1-995 $ 49,560 CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (CASH BASIS) AND ACTUAL SPECIAL REVENUE FUNDS - DEVELOPMENT FUND FOR THE YEAR ENDED JULY 31, 1993 - REVENUES: Sales tax Use tax Total revenue EXPENDITURES: L ColleCt4 State on fees REVENUES OVER (UNDER) EXPENDITURES FUND BALANCE - July 31, 1992 FUND BALANCE - july 31, 1993 -30- 9 LL14-9 e,t Variance Favorable Actual U-n-JEA—Vorab-i—e $ 92,248 92,248 1,852 1852 100 94,100 --f-2 823) 91,277 ---91 ,277 $ -$ ---91 , 217 CITY OF BLAIR, NEBRASKA COMETNING BALANCE SHEET - ENTERPRISE FUNDS JULY 31, 1993 ASSETS PROPERTY: Plant in service Water Sewer Total CURRENT ASSETS: Accumulated Cash $ 33,218 68,801 $ 102,019 Accounts receivable _x,34__-,7_) Property - net user fees 107,523 54,832 162,355 Accounts receivable 4 7 other 632 - 632 Accrued interest receivable 13,206 - 13,206 Investments 360,095 - 360,095 Inventory 29,644 - 29,644 Prepaid expenses 2,689 - 1,942 —_ 4,6_31 Total current assets 125,575 672,582 ___547,007 RESTRICTED ASSETS: Meter deposit cash and investments 24,461 - 24,461 -Bond and interest sinking fund cash and investments 409,125 409 Total restricted assets 433,586 X33-, 58, 6 ) PROPERTY: Plant in service 7,405,296 3,556,010 10,961,306 Accumulated depreciation _L2_,_51 4_, 5 f _x,34__-,7_) Property - net _4,890, lata _1_-,7721_,_5 7 2 6,612,11-5 TOTAL ASSETS 4 7 7j_8_,_ 2 8 3 CITY 0-F B 3LAIR, IKA JiEDRAS INTNG STATEMENT OF REVENUES, EXPENSES COM�l-Q� AND CHANGES IN RETAINED EARNIN(-3S ENTERPRISE 17UNDS FOR THE YEAR ENDED JULY 31, 199.3 OPERATING REVENUES: User fees Sale of merchandise Rental Other ToCal EXPENSES: Personal services Operating expenses Materials and supplies Rental expense Construction contracts Depreciation Total OPERATING INCOME (LOSS) OTHER REVENUE (EXPENSE): Interest income Interest expense Bond refunding costs Operating transfers -in Operating transfers-o-LI't NET INCOME (LOSS) RETAINED EARNINGS (DEFICIT) July 31, 3.992 RETAINED EARNINGS (DEFICIT) July 31, .1.993 Water Sewer Total 538,307 $ 262,981 801,288 13,994 2,881 16,87/5 1.2,000 - 12,000 13,185 13,185 _-5 77.,_486 265,362 843,348 323,612 J-56,261 479,873 146,220 81,038 227,258 90,923 21,50'1 1A2,430 893 503 1,396 67,441 19,709 37,150 L99,742 76 x 913 276,655 828,831 8-4.,-7-62 (251.,345) (90,069) (341,414) 54,650 4101i 58,661 (139,305) (139,305) (1.88,530)188,530,) 68,911 68,911 ___C2 4 302) 5 0 54 4, 1704,8631 ) (87,360\ (792,221) 0,514,348 -6, 1,623,552 _1890 —.8 UAU x_978 ,156 31 , 33 1 -32- CITE F A-1-1—NEBRASKA COMBINING STATEMENT OF CASH FLOW ENTERPRISE FUNDS FOR�_g_yUi _j_ J U L23_L,1_9_93 w4tUx Sewer 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 Decrease (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 Interest income Transfers -- net Decrease (increase) in accrued interest receivable Cash flow from (used in) investing CASH FLOW FROM FINANCING: Proceeds from long-term debt Reduction of long-term debt Decrease (increase) in restricted assets Interest expense Bond refunding costs 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 -33- Total $(251,345) $ (90,069) $(341.,414) 199,742 76,913 276,655 4,489 (16,129) (11,640) 6,763 6,735 13,498 (352) - (35 2) 507 56 563 4,484 38,013 42,497 566 - 566 4 200 — ;---- 4,2_00 30,946 ---1.5 519 __J,1 5 _4 2 7 (55,827) (52,090) (107,917) 54,650 4,011 58,661 (180,331) (1,302) (181,633) 4,491 171 662 ___Ll 7 7-,-07.7)9 21.a) X26 , 22-7.) 185,000 185,000 (75,000) (75,000) 309,607 309,607 (139,305) (139,305) (188,530) (1.88,530) (1.3,878) (13,878) 7 -L8_94 7 894 (130,069) (33,6191) (163,760) 523,382 102 492 625,874 393313 $ 462,114 CITY OF BLAIR, NEBRAOI(A t�_o INDI'VTDUAL STATEME"ITT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - WATER FOR THE YEAR ENDED J1JLy.__1L 1_�._93 Variance Favorable Budqet Actual (Unfavorable) OPERATING REVENUES: User fees $600,500438,307 $(62,193) Sale of merchandise 1.0,000 13,0194 3,994 Forfeited discounts 6,200 7,629 1,429 Hydrant rental 12,000 12,000 - Other -.4-410 ___E) , 5 5 6_ 11 _14_6 Total revenues 633,110 _€177,_,486 --X55,62) EXPENSES. Personal services: Salaries 245,813 251,4715 (5,662) FICA 18,805 18,129 676 Workman's compensation 6,600 5,789 811 HAL insurance 39,210 38,216 994 Retirement (city share) 10,1,99 9,856 343 Unemployment compensation 70 147 (7 7 Total 320,697 323,61-9, 2 5 Operating expenses: Legal fees 400 - 400 Auditing 1,500 1,507 (7) Consultants/engineering 8,500 8,407 93 Employee appreciation 9010 39 861 Postage 4,800 4,536 264 Printing and publications 1,050 402 648 Computer programming 1,000 1,020 (20) Schools, travel, and training 1.,60€9 7-55 445 Dues 2,-1y510 2j751 Utilities 72,500 85,759 (13,259) Telephone 2,400 2,313 87 Vehicle insurance 1,10a 692 408 Liability insurance 1. , 7€ CIO 1,634 66 Buildings and cont -tints, insurance 4,500 3,540 960 Employee bonds 150 _L 6 Radio maintenance 600 573 27 Office equipment maintenance 1,000 650 350 Motorized equipment mail-Itenance 2,600 1,594 1,006 Building maintenance 4,000 8,343 (4,343) Major maintenance 10,000 12,489 (2,489) Contingent reserve 4,000 4,000 Chamber of Commerce 4,500 4,500 -- Maintenance agreements Maintenance 4,200 3,402 798 Car expense 384 390 (6) Bad accounts 100380 _'280) Total 136,234 146,220 - continued - -34- CITY OF BLAIR , NE BRASNA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - WATER FOR THE YEAR ENDEDJULY31, 1993--- - continued - EXPENSES: Materials and supplies: Office supplies Janitorial supplies Stores and supplies Chemicals Supplies for inventory Gasoline Clothing allowance Small tools Construction contracts Other materials and supplies Total Rental expense - Office equipment Total expenses OPERATING INCOME (LOSS) BEFORE DEPRECIATION DEPRECIATION OPERATING INCOME (LOSS) OTHER REVENUES (EXPENSES): Interest income Interest expense Bond refunding costs Operating transfers - in Operating transfers - out NET INCOME (LOSS) -35- X9,824$6704861) 0861) $(764,685) Variance Favorable Budgyt Actual (Unfavorable) 1,600 $ 2,219 $ (619) 300 289 11 2,500 2,317 183 32,000 41,210 (9,210) 7,500 11,112 (3,612) 3,500 2,417 1,083 1,000 741 259 800 1,272 (472) 110,000 67,441 42,559 29,41 29,346 j 4 188 _aO 246 _, 480 — (413) 646,021 16,932 _629,089 (12,911) (51,603) (33,692) 99 742) __— __I, 119j,742) (12,911) (251,345) (238,434) 68,200 54,650 (13,550) (170,465) (139,305) 31,160 - (188,530) (188,530) 290,000 681911 (221,089) 115_L000 ) X49 , 242 jj3+1.242) X9,824$6704861) 0861) $(764,685) CITY OF - BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET (CASH BASIS) AND ACTUAL ENTERPRISE FUND - SEWER FOR THE YEAR ENDED JULY 31,1993 Variance Favorable Budget Actual. (lJnfavorable-) OPERATING REVENUES: User fees $238,000 $262,981 $ 24,981 Sale of merchandise 1,000 2,881 1,881 Total revenues 239,000 265jj�62 26,862 EXPENSES: Personal services: Salaries 118,090 120,797 (2,707) FICA 9,034 8,614 420 Workman's compensation 1,600 2,133 (533) H.A.L. insurance 18,450 1.8,753 (303) Retirement (city share) 6,699 5,943 756 Unemployment compensation 50 21 29 Total -92--3 _Aa 6_,2.61. 2,338) Operating expense: Legal 200 - 200 Auditing 700 685 15 Consulting/engineering 2,300 623 1,677 Employee appreciation 400 22 378 Postage 2,000 11,907 93 Printing and publication 400 152 248 Computer programming 400 971 (571) School, travel and training 1,050 390 660 Dues 1,750 1,887 (137) Utilities 45,000 47,329 (2,329) Telephone 800 918 (118) Insurance 6,950 5,621 1,329 Maintenance 16,500 18,31.7 (1,817) Chamber of Commerce 2,000 2,000 Car expense 216 216 Contingent reserve 00Q - - ---- ----4-1.000 Total 84,666 81,038 Materials and supplies 21,600 21,507 93 Construction contracts 42,500 19,709 22.,791 Rental expense 200 503 -----(303) Total expenses 302 279101-8 23,871 OPERATING INCOME (LOSS) BEFORE DEPRECIATION (63,889) (13,156) 50,733 DEPRECIATION__--- �13 OPERATING INCOME (LOSS) (60,889) (90,069) (26,180) OTHER REVENUE (EXPENSE): Interest income 3,200 4,011 811 Transfer - out - 3 -,_ 2 NET INCOME (LOSS) 6 8 9 _L8 7 -, -3 60.) -16671) 36 CITY,OF-BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND REVENUES BUDGET (CASE BASIS) AND ACTUAL FOR THE 'YEAR ENDED JULY 31, 1993 REVENUES: Taxes: Property taxes Interest on taxes Insurance tax Receipts in lieu of taxes Personal property tax relief State aid Motor vehicle pro -rate Homestead relief Franchise tax Total Licenses and permits: Business licenses Dog licenses Permits and fees Total Charges for services: Library Landfill collections Cemetery lots Grave openings Swir,,-,m-'Lr,g pool fees Swimming pool lessons Sales of fireworks Building and land leases Total INTEREST !NCOME OTHER REVENUES: Grant -airport Grant -park Gifts Police lab fund County inspector payments Other miscellaneous revenue Total. Du jg_t 677,219 30,500 50,500 30,000 104,118 32,000 58,200 5 7 16,600 2,400 __j_6_,070 35,0'70 8,440 140,500 10,400 16,200 1-9,500 3,500 7,000 5100 4,10 640 ____ 4, 00.0 22,000 37,500 1,600 1,800 25,743 4,000 92,643 Actual 66-1,057 6,132 37 , 018 46,453 17,088 3.03,885 / 2 ,985 33,163 73,151 __ 986,932 20,640 3,126 2,796 49-4-562- I 11,043 139,492 15,360 14,895 13,251 4,035 10,050 ___,9 212,_098 61,84'n 19,086 086 30,000 3,644 21., 8 3 5 23 424 -1 ,387 --91_, 376 TOTAL REVENUES ,324,890 3 -37- Variance Favorable (Ynfavorabl-I� $(10,162) 6,132 6,518 (4,047) (12,912) (233) 2,985 1,163 14,951 4 395 4,040 726 ___ 9,7_25 14,492 2,603 (1,008) 4,960 (1,305) (6,249) 535 3 3 , 050 _._._;1,128) _ �_� 5 __11jt2q)5 8 841 (2,91.4) (7,500) 2,044 1,035 (2,319) 8,337 -U,261-7) .1 21,919 CITYOFBLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL ADMINISTRATION DEPARTMENT FOR THE YEAR ENDED JULY 31,1993 Variance Favorable R-Uag-el Actual (I[n faLvo r ab i_g) PERSONAL SERVICES: Salaries $ 85,060 87,143 $ (2,083) Social security 6,400 6,205 195 Employee's insurance 58,030 63,362 (5,3321) Retirement 3,850 4,027 (177) OPERATING EXPENSES: Legal 25,500 23,438 2,062 Building inspection 3,600 3,626 (26) Auditing 950 959 (9) CiV.J.4 1 defense 1,800 1,800 -- Consulting 7,000 1,839 5,161 Custodial services 2,900 2,700 200 Employee appreciation 1,100 233 867 Postage 1,900 2,31-114 (424) Printing and publications 6,500 5,746 754 Dues and training 6,000 6,312 (312) Election expense 1,500 1,750 (250) -Programm: i.ng 1,500 335 1,165 City utilities 2,400 2,420 (20) Telephone 4,100 3,899 201 Travel expense 2,500 1;302 1,198 Insurance and bonds 5,700 4,676 1,024 Maintenance 4,300 2,305 1,995 Tree stump removal 13,500 9,989 3,511 Tobacco licenses 850 405 445 Chamber of Commerce 8,000 7,500 500 Gas and oil 750 856 (106) County Treasurer's collection fees 6,772 7,064 (292) Miscellaneous Soo 981 (481) SUPPLIES 3,700 3,976 (276) RENTAL EXPENSES - Office equipment 900 1,368(468) CAPITAL OUTLAY Office equipment 7,540 1 3c3 1 6 356 TOTALSM�-,9124 �5,102 15,378_ __ _1 _1-, CONTINGENT RESERVE TOTAL CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES 11 BUDGET (ClkSH BASIS) AND ACTUAij CONTINGENCY ALLOWANCE FOR THE YEAR ENDED JULY 31 ,..__1393 B1 Lc -1- g g t 129-10-0 -39- $20, )00 Variance Favorable Actual (y_favorable ) 12-0,000 X20,000 CITY OF BLAIR, NEBRA"KA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL POLICE DEPARTMENT FOR THE YEAR ENDED _jULY_ 31 SUP -PLIES.- Supplies 1' 11,900 10,797 Variance Gas and oil 11,100 8,622 Favorable Uniforms Budget Actual (Unfavorable) PERSONAL SERVICES: 3,300 1,983 1,317 Salaries $320,280 $325,443 $(5,163) Social -security 24,100 23,497 603 Employees' insurance 53,430 53,633 (203) Retirement 18,900 171,593 1,307 OPERATING EXPENSES: 15,0()0 14,518 482 Legal 1-5,500 12,398 3,102 Auditing 950 959 (9) Postage 750 663 87 Printing and publications 900 2,005 (1,105) Training 2,800 1,278 1,522 Telephone 4,500 4,131 369 Travel 1,200 818 382 Dues 450 225 225 Insurance 7,750 6,869 881 Maintenance 9,250 11,602 (2,352) Medical exams 5,900 3,950 1,950 Miscellaneous 1,700 1,647 53 SUP -PLIES.- Supplies 1' 11,900 10,797 1 '103 Gas and oil 11,100 8,622 2,478 Uniforms 7,900 6,927 973 Ammunition and range 3,300 1,983 1,317 Miscellaneous - - RENTAL EXPENSE 18,000 171,785 215 CAPITAL OUTLAY: Office equipment 800 760 40 Motor vehicles 15,0()0 14,518 482 Firearms 1,200 1,119 81. Radio equipment 1,950 094 (144) TOTALS 3_p $ 8,194 -40- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL CEMETERY FOR THE YEAR ENDED JULY -31, 1993 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 w= Variance Favorable Budget Actual (Unfavorable) $39,600 $38,103 $ 1,497 2,920 2,534 386 5.,940 6,293 (353) 960 195 765 50 23 27 75 55 20 220 1206 94 150 50 100 50 11 39 90 50 40 1,700 1,870 (170) 20 - 20 1,700 1,843 (143) 425 426 (1) 1,650 1,270 380 4,300 4,166 134 - 25 ( 25 ) 625 531 94 1,500 1,634 (1134) 250 152 98 225 1,640 (1,415) 600 724 (124) 11,000 10,325 675 13,300 _ 81125 _ 5,174 $87,350 $80,172. $ 7,178 w= CITY OF BLAIR NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL FIRE DEPARTMENT FOR THE YEAR ENDED JULY ,31, 1993 PERSONAL SERVICES OPERATING EXPENSES: Utilities and telephone Insurance Maintenance Travel Training Miscellaneous SUPPLIES: Gas and oil Safety equipment Miscellaneous HYDRANT RENTAL CAPITAL OUTLAY: Specialized equipment TOTALS Budget $ 5,600 13,200 7,500 6,500 100 1,000 270 1,800 3,500 3,120 12,000 6,500 $61,090 -42- Variance Favorable Actual (Unfavorable) $ 3,906 $ 1,694 16,136 6,125 10,086 1,601 3,396 3,956 12,000 1,065 $61,240 (2,936) 1,375 (3,586) 100 (1,589) (110) 199 104 (836) 5,435 $ (150) CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL PARK DEPARTMENT FOR THE YEAR ENDED JULY ,31_. 1993 PERSONAL SERVICES: Salaries Social security Employees' insurance OPERATING EXPENSES: Engineer Travel Utilities and telephone Insurance Maintenance Miscellaneous SUPPLIES: Gas and oil Small tools Miscellaneous CAPITAL OUTLAY: Pony Park campground Park equipment Playground equipment TOTALS -43- Variance Favorable Budget Actual (Unfavorable) 45,060 $ 41,721 $ 3,339 3,440 3,012 428 2,920 4,032 (1,112) 4,000 4,415 (415) 125 26 99 3,500 3,627 (127) 1,795 1,351 444 6,700 8,761 (2,061) 465 1,012 (547) 1,700 1,435 265 210 418 (208) 885 272 613 45,000 21,814 23,186 13,750 10,260 3,490 2,000 2 (432) $131 550 104 —, 58 8 26,962 -43- CITY OF BLAIR, Q _N_ERASKA_R_ SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL LIBRARY FOR THE YEAR ENDED JULY 31, 1993 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 $ 75,700 5,791 10,860 2,480 Actual 74,711 5,449 11,152 3,232 Variance Favorable (Unfavorable) $ 989 342 (292) (752) 285 274 11 450 379 71 300 265 35 250 186 64 9,800 9,408 392 700 480 220 350 56 294 100 105 (5) 1,250 966 284 4,500 3,647 853 2,200 2,107 93 10,000 - 1-0,000 2,500 2,105 395 31,500 31,027 473 2,500 1,660 840 ,516 n6l 7 -$ 14 9 114 307 -44- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL SUPERVISED RECREATION FOR THE YEAR ENDED JULY 31, 1993 PERSONAL SERVICES: Salaries Social security Employees' insurance OPERATING EXPENSES: Auditing Professional fees Printing and publications Utilities Telephone Insurance Maintenance Little League and BYSA Golf, Basketball, and Wrestling SUPPLIES: -Gas and oil Recreation supplies CAPITAL OUTLAY: Aluminum bleacher boards TOTALS -45- Variance Favorable Budget Actual (Unfavorable) $ 9,335 $ 7,650 $ 1,685 71.5 499 216 600 446 154 70 69 1 800 - 800 50 60 (10) 4,000 3,557 443 250 379 (129) 1,520 1,962 (442) 4,400 3,755 645 4,500 6,000 (1,500) 1,050 2,388 (1,338) 200 179 21 750 24 726 2_,000 — 2000 $30,240 X26,968 $ 3,2_121 -45- CITY OF-BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL SWIMMING POOL FOR THE YEAR ENDED JULY 31, 1993 -46- Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $25,036 $22,027 $3,009 Social security 1,915 1,386 529 Employees' insurance 740 603 137 OPERATING EXPENSES: Auditing 210 206 4 Printing and publications 520 660 (140) Utilities and telephone 4,000 3,671 329 Insurance 950 716 234 Maintenance 4,500 3,640 860 State sales tax 1,000 982 18 Miscellaneous 100 - 100 SUPPLIES: Chemicals 3,200 2,575 625 Small tools - - Miscellaneous 1,415 1,071 344 TOTALS $43,586 X37 61 049 -46- CITY OF BLAI.R, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL AIRPORT FOR THE YEAR ENDED JULY 31., 1993 -47- Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $ 1,200 $ 393 $ 807 Social security 100 29 71 Employees' insurance 160 106 54 OPERATING EXPENSES: Insurance 2,900 1,444 1,456 Maintenance 1,000 787 213 Engineering - airport study 25,000 17,655 7,345 Airport authority lease prorate - 2,700 (2,700) Utilities 2,220 2,051 169 Miscellaneous 1,235 307 928 RENTAL EXPENSE - TOTALS _$13, 815` _2 5 472 _343 -47- CITY 0 F -RL A I R -,- N E B -9, Nl-K—A SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL LANDFILL FOR 'THE YEAR ENDEDJULY31, 1993 -,---- Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $ 31,992 $ 30,987 1,005 Social security 2,450 2,246 204 Employees' insurance 4,830 5,550 (720) Retirement 1,200 1,162 38 OPERATING EXPENSES: Auditing 150 137 13 Printing and publication 300 221. 79 Testing 34,000 18,249 15,751 Travel 200 109 91 State landfill fee 121,000 15,422 (3,422) Utilities and telephone 1,800 1,049 751 Insurance 1,460 1,1.60 300 Maintenance 8,100 14,020 (5,920) SUPPLIES: Chemicals 250 264 (14) Gas, diesel, and oil 4,500 2,738 1,762 Uniforms 250 234 16 Sand, gravel, and rock 750 705 45 - Miscellaneous 50 107 (57) RENTAL EXPENSE 3,925 912 3,013 TOTALS X108,207. _9 5, 2 _27_2 $ 12,935 -48- CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET (CASH BASIS) AND ACTUAL ANIMAL CONTROL FOR THE YEAR ENDED JULY 31,--1993 PERSONAL SERVICES: Salaries Social security Employees' insurance Retirement OPERATING EXPENSES: Legal Auditing Printing and publications Travel Training Veterinary expense Utilities and telephone ,Insurance Maintenance Miscellaneous SUPPLIES: Gas and oil Dog license & supplies Uniforms Miscellaneous CAPITAL OUTLAY - equipment TOTALS -49- Variance Favorable Budget Actual (Unfavorable) $19,840 $21,479 $(1,639) 1,520 1,541 (21) 4,985 5,118 (133) 700 938 (238) 500 480 20 70 55 15 100 256 (156) 250 210 40 250 90 160 1,000 1,301 (301) 3,020 3,632 (612) 445 296 149 4,200 1,363 2,837 50 - 50 1,100 848 252 1,700 1,686 14 500 382 118 1,100 --8 2"2 278 41,33 30 14-0-1-452 833 j 'I July 7, 1994 Honorable Mayor and Members of the City Council City of Blair, Nebraska Dear Gentlemen: 5 2 E: I have audited the general purpose financial statements of the City of flair, Nebraska, as of and for the year ended July 31, 1993, and have issued my report thereon dated July 7, 1994. These general purpose financial statements atements are the responsibility of the City of Blair, Nebraska, management. My responsib.4 L lity is to express an opinion on these general purpose financial statements based on my audit. I conducted my audit in accordance with generally accepted auditing standards and GOVERNMENT AUDITING STANDARDS issued by the Comptroller General of ilh_e_di�ited States, and the provisions of Office of Management and Budget Circular A-128, "Audits of State and Local Governments." Those standards and OMB Circular A-128 require that I plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose 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. My audit was conducted for the purpose of forming an opinion on the general purpose financial statements of the City of Blair, Nebraska taken as a whole. The accompanying schedule of federal financial assistance is presented for purposes of additional analysis and, is not a required part of the general purpose financial statements. The information in that schedule has been subject -ed to the auditing procedures applied in the audit of the general purpose financial statements and, in my opinion, is fairly presented in all material respects in relz;tion to the general purpose financial statements taken as a whole. Edward W. Schroeder Certified Public Accountant -SO- SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE CITY OF BLAIR FOR THE, YEAR ENDED JULY 31, 1993 PROGRAM TITLE CFDA NUMBER GRANT GRANTORS NUMBER AMOUNT Land and Water Conservation CFDA #15-916 #31-00840 $20,000 Federal Aviation Administration #31-0088-01 54,000 Totals $74,000 BALANCE 7-31-92 -0- 14-19 ___t, 419. ) REVENUE 19 -51- REVENUE RECOGNIZED EXPENSE BALANCE INCURRED 7-31-93 $20,000 $20,000 $ -0- 18,074 0- 18,074 111,6 5 5 -0- 1,38 ,074 $ ,469 -0- July 7, 1994 Honorable Mayor and Members the City Council City of Blair, Nebraska Gentlemen: I have audited the general purpose financial statements of the City of Blair, Nebrask-a, as of and of the year ended July 31, 1993, and have issued my report thereon dated July 7, 1994. I conducted my audit in accordance with generally accepted auditing standards, GOVERNMENT AUDITING STANDARDS, issued by Comptroller General of the United States, and the provisions of Office of Management and Budget Circular A-128. "Audits of State and Local Governments." those standards and OMB Circular. A-128 require that I plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. Compliance with laws, regulations, contracts, and grants . applicable to the City of Blair is the responsibility of the City of Blair's management. As part of obtaining reasonable assurance about whether the financial statements are free of material misstatement, I performed tests of the City's compliance with certain provisions of laws, regulations, contracts, and grants. However, the objective of my audit of the financial statements was not to provide an opinion on overall compliance with such provisions. Accordingly, I do not express such an opinion. The results of my tests indicate 'that, with respect to the items tested, the City of Blair complied, in all material respects, with the provisions referred to in the preceding paragraph. With respect to items not tested, nothing came to my attention that caused me to believe that the City of Blair had not complied, in all material respects, with those provisions. This report is intended for the information of management and the Blair City Council. However, this report is a matter of public record and its distribution is not limited. Edward W. Schroeder Certified Public Accountant -7)9- Honorable Mayor and Members of the City Council City of Blair, Nebraska Gentlemen: July 7, 1994 I have audited the general purpose financial statements of the City of Blair, Nebraska, as of and for the year ended July 31, 1993, and have issued my report thereon dated July 7, 1994. I conducted my audit in accordance with generally accepted auditing standards, GOVERNMENT AUDITING STANDARDS, issued by the Comptroller General of the United States, and the provisions of Office of Management and Budget Circular A-128, "Audits of State and Local Governments." Those standards and OMB Circular A-128 require that I plan and perform -the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. In planning and performing my audit of the general purpose financial statements of the City of Blair for the year ended July 31, 1993, 1 considered it s internal control structure in order to determine my auditing procedures for the purpose of expressing my opinion on the general purpose financial statements and not to provide assurance on the internal control structure. The management of the City of Blair is responsible for establishing and maintaining an internal control structure. In fulfilling this responsibility, estimates and judgments by management are required to assess the expected benefits and related costs of internal control structure policies and procedures. The objectives of an internal control structure are to provide management with reasonable, but not absolute, assurance that assets are safeguarded against loss from Unauthorized use of disposition, and that transactions are executed in accordance with management's authorization and recorded properly to permit the preparation of financial statements in accordance with generally accepted accounting principles. Because of inherent limitations in any internal control structure, errors or irregularities may nevertheless occur and not be detected. Also, projection of any evaluation of the structure to future periods is subject to the risk that procedures may become inadequate because of changes in conditions or that the effectiveness of the design and operation of policies and procedures may deteriorate. - rl.". 3 - Page 2 For the purpose of this report. I have classified the significant internal control structure policies and procedures 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 Payable and accrued liabilities Debt Fund balance Accounting Applications Billings Receivables Cash receipts Purchasing and receiving Accounts payable .Cash disbursements Payroll Administrative Controls. General Requirements Political activity Davis -Bacon Act Civil Rights Cash management Federal financial reports Specific Requirements Types or services Eligibility Matching level of effort Reporting Cost allocation. Special requirements, if any For all of the control categories listed above, I obtained. an understanding of the design of relevant polices and procedures and whether they have been place in operation, and I assessed control risk. I noted certain matters involving the internal control structure and its operation that I consider to be reportable conditions under standards established by the American Institute of Certified Public Accountants. Reportable conditions involve matters coming 'to my attention relating to significant deficiencies in the design or operation of the internal control structure that, in my judgment, could adversely affect the entity's ability to record, process, summarize. and report financial data consistent with the assertions of management in the general purpose financial statements. The City of Blair does not have adequate separation of duties. -54- Page 3 A material weakness is a reportable condition in which the design or operation of one or more of the internal control structure elements does not reduce to a relatively low level 'the risk that errors or irregularities in amounts that would. be material in relation to the general purpose financial statements being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. My consideration of the internal control structure would not necessarily disclose all matters in the internal control structure that might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are considered to be material weaknesses as defined above. However, I believe none of the reportable conditions described above is a material weakness. This report isintendedfor the information of management and the Blair City Council. However, this report is a matter of public record and its distribution is not limited.__, Edward W. Schroeder Certified Public Accountant -55- u July 7, 1994 Honorable Mayor and Members of the City Council City of Blair, Nebraska Gentlemen: I have audited the financial statements of the City of Blair, Nebraska, as of and for the year ended July 31, 1993, and have issued my report thereon dated July 7, 1994. In connection with my audit of *the 1993 general purpose financial statements of 'the City of Blair and Pith fl.ly consideration of 'the City of Blair control structure used to administer federal financial assistance programs, as required by Office of Management and Budge Circular A-128, "Audits of State and Local Government," I selected certain transactions applicable to certain nonmajor federal financial assistance programs for the year ended July 31, 1993. As required by OMB Circular A-128, I have performed auditing procedures to test compliance with the requirements governing types of services allowed or unallowed, eligibility, and other specific reqttirements that are applicable to those transactions. My procedures were substantially less in scope than an audit, the objective of which is the expression of an opinion on the City of objective Flair's compliance with these requirements. Accordingly, I do not express such an opinion. .With resiDect to the items tested, the results of those procedures disclosed no material instances of noncompliance with the requirements listed in the preceding paragraph. With respect to items not tested, nothing came to my attention that caused me to believe that the City of Blair had not complied, in all material respects, with those requirements. This report is intended for the information of management and the Blair City Council. However, this report is a matter of public record and it--, distribution is not limited.. Edward W. Schroeder Certified Public Accountant -56- Honorable Mayor and Members of the City Council City of Blair, Nebraska Gentlemen: 4 c i July 7, 1994 i have audited the financial statements of the City of Blair, Blair, Nebraska, as of and for the year ended July 31, 1993, and have issued my report thereon dated July 7, 1994. I have applied procedures to test the City of Blair's compliance with the following requirements applicable to its federal financial assistance programs, which are identified in the Schedule of Federal Financial Assistance, for the year ended July 31, 1993: Political activity Davis -Bacon Act Civil rights Cash management Relocation assistance and real property acquisition Federal financial reports Allowable costs/cost principles Drug-free Workplace Act Administrative requirements My procedures were limited to the applicable procedures described in the office of Management and Budgets "Compliance Supplement for Single Audits of State and Local Governments." My procedures were substantially less in scope than an audit, the objective of which is the expression of an opinion of the City of Blair's compliance with the requirements listed in the preceding paragraph. Accordingly, I do riot express a such an opinion. With respect to the items tested, the results of those procedures disclosed no material instances of noncompliance with the requirements listed in. the second paragraph of this report. With respect to items not testes, nothing came to my attention that caused me to believe that the City of Blair had riot complied, in all. material respects, with those requirements. This report is intended for the information of management and the Blair City Council. However, this report is a matter of public record and its distribution is not limited"... Edward W. Schroeder Certified Public Accountant -57- July 7, 1994 F!, Honorable Mayor and Members of the City Council City of Blair, Nebraska Gentlemen: R" , S� D N I have audited the general purpose financial statements of the City of Blair, Nebraska, as of and for the year ended July 31, 1993, and have issued my report thereon dated July 7, 1994. I conduct -ed my audit in accordance with generally accepted auditing standards, GOVERNMENT AUDITING STANDARDS, issued by the ,Comptroller General of 'the United States, and the provisions of Office of Management and Budget Circular A-128, "Audits of State and Local Governments." Those standards and OMB Circular A-128 require that I plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. in planning and performing my audit of the general purpose financial statements of the City of Blair for the year ended July 31, 1993, 1 considered it s internal control structure in order to determine my auditing procedures for the purpose of expressing my opinion on the City of Blair's general purpose financial statements and to report on the internal control structure in accordance with OMB Circular A-128. This report addresses my consideration of internal structure policies and procedures relevant to compliance with requirements applicable to federal financtal. assistance programs. I have addressed internal control structure policies and procedures relevant to my audit of the general purpose financial statements in a separate report dated July 7, 1994, The oftanagei-ptent of the City of Blair is responsible for establishing and maintaining an internal control structure, in fulfilling this responsibility, estimates and judgments by management are required to assess the expected benefits and related costs of internal control structure policies and procedures. The objectives of an internal control structure are to provide management with reasonable, but not absolute, assurance that assets are safeguarded against loss from unauthorized use of disposition, and that- transactions are executed in accordance with management's authorization and recorded properly to permit the preparation of financial statements in accordance with generally accepted accounting principles, and that federal financial assistance Programs are managed in compliance with applicable laws and regulations. Because of inhereiat limitations in any internal cont-rol. structure, error's,, irregularities, or instances of noncompliance may nevertheless occur and not be detected. -53- Page 2 Also, projection of any evaluation of the structure to future periods is subject to the risk that procedures may become inadequate because of changes in conditions or that the effectiveness of the design and operation of policies and procedures may deteriorate. For the purpose of this report. I have classified the significant internal control structure policies and procedures in the following categories: Accountina 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 Payable and accrued liabilities Debt Fund balance Accounting Applications Billings Receivables Cash receipts Purchasing and receiving Accounts payable Cash disbursements Payroll Administrative Controls General Requirements Political activity Davis -Bacon Act Civil Rights Cash management Federal financial reports Specific Requirements Types or services Eligibility Matching level of effort Reporting Cost allocation Special requirements., if any For all of the internal control structure categories listed above, I obtained an understanding of the design of relevant polices and procedures and whether they have been place in operation, and I assessed control risk. During the year ended July 31, 1993, the City of Blair had no major federal financial assistance programs and expended 100% of its total federal financial assistance under the following nonmajor federal financial assistance programs: Land and Water Conservation National Aviation Administration I per -formed tests of controls, as required by OMB Circular A-128, to evaluate the effectiveness of the design and operation on internal control structure policies and procedures that I have considered relevant to preventing or detecting material noncompliance with specific requirements, general requirements, _59- Page 3 and requirements governing claims for advances and reimbursements and amounts claimed or used for matching that are applicable to the aforementioned nonmajor programs. My procedures were less in scope than would be necessary to render an opinion on these internal control structure policies and procedures. Accordingly, I do not express such an opinion. I noted certain matters involving the internal control structure and its operation that I consider to be reportable conditions under standards established by the American institute of Certified Public Accountants. Reportable conditions involve matters -coming to my attention relating to significant deficiencies in the design or operation of the internal control structure that, in my judgment, could adversely affect the City of Blair's ability to administer federal financial assistance programs in accordance with applicable laws and regulations. The City of Blair does not have adequate separation of duties. A material weakness is a reportable condition in which the design or operation of one or more of the internal control structure elements does not reduce to a relatively low level. the risk that noncompliance with laws and regulation that would be material to a federal financial assistance program may occur and not be detected within a timely period by employees in -the normal course of performing their assigned functions. My consideration of the internal control structure policies and procedures used in administering federal financial assistance would not necessarily disclose all matters in the internal control structure that might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are considered to be material weaknesses as defined above. However, I believe none of the reportable conditions described above is a material weakness. This report is intended for the information of management and the Blair City Council— However, this report is a matter of public record and its distribution is not limited. Edward W. Schroeder Certified Public Accountant May 12, 1994 E. Benjamin Nelson Governor Rodney Storm, City Administrator City of Blair 218 So. 16th Street Blair, NE 68008 Subject: Audit Reports City of Blair, Nebraska July 31, 1992 and July 31, 1993 Dear Mr. Storm: DEPARTMENT OF AERONAUTICS Kim J. Stevens Director We have received the State Auditor's response to your audit reports for the years ended July 31, 1992 and July 31, 1993. Please find enclosed three copies of the letter showing the State Auditor's comments regarding the reports. We are asking that you submit one copy of this letter to your CPA, Edward W. Schroeder, for his information when preparing the next audit report for the City/Airport Authority. We also would like you to forward one copy of the letter to the new Airport Authority so they are aware of the situation. You should also keep a copy of the letter in the City's audit file for future reference. We are not asking the City of Blair to re -do these audit reports to meet the reporting elements required by the Single Audit Act and OMB Circular A-128 this year; however, we would like to advise the City and the new Airport Authority of the requirements when future audits are prepared. Following are excerpts from OMB Circular A-128 which establishes audit requirements for state and local governments that receive Federal aid: 1. Policy: The Single Audit Act requires the following: a. State or local governments that receive $100,000 or more a year in Federal financial assistance shall have an audit made in accordance with this Circular. b. State or local governments that receive between $25,000 and $100,000 a year shall have an audit made in accordance with this Circular, or in accordance with Federal laws and regulations governing the programs they participate in. MAIN OFFICE General Aviation Building Lincoln Municipal Airport P.O. Box 82088 Lincoln, Nebraska 68501-2088 (402) 471-2371 NAV -AIDS OFFICE Kearney Municipal Airport RR 1, Box 122A Kearney, Nebraska 68847 (308) 234-8696 An Equal Opportunity/Affirmative Action Employer Printed with soy ink on recycled paper Rodney Storm May 12, 1994 Page Two C. State or local governments that receive less than $25,000 a year shall be exempt from compliance with the Act and other Federal audit requirements. These state and local governments shall be governed by audit requirements prescribed by State or local law or regulation. This office appreciates your review of this matter so that future audits for the City/Airport Authority of Blair are performed in accordance with the Single Audit Act. If you have any questions, please contact this office or the State Auditor's office. Sincerely, DEPARTMENT OF AERONAUTICS Billie N. Frost Deputy Director bjm enclosures STATE OF NEBRASKA John Breslow State Auditor Billie Frost, Deputy Director Department of Aeronautics P.O. Box 82088 Lincoln, NE 68501-2088 Dear Ms. Frost: Auditor of Public Accounts May 10, 1994 Suite 2303 State Capitol Lincoln, NE 68509 402-471-2111 FAX 402-471-3301 Per your request and our agreement, reviews of the subrecipient audit reports submitted to you for the City of Blair for the fiscal years ended July 31, 1992 and 1993, were performed. The reports do not contain the reporting elements required by the Single Audit Act and OMB Circular A-128. The reports do not include the internal control and compliance reports required for a single audit, schedules of federal financial assistance, or any other indications that the audit was performed in accordance with the necessary federal standards. Due to these deficiencies, a detailed review of these reports was not performed by our office. During a cursory review of the reports we were unable to determine any specific identification of receipt of any federal funds by the City or of any funds directly from your Department. The Schedules of General Fund Expenditures for the Airport Department do show expenses for "engineering - airport study" which could relate to your funding. $32,430 was spent in 1992 per the page 39 schedule of that report and $17,655 in 1.993 per the page 47 schedule of that report. If these are determined to be pass-through federal funds and the revenue for each year is consistent with the expenditures indicated, the City would not have a single audit requirement for 1993 unless other federal funds were received. The Department will need to determine the specific details regarding the federal funds received and the audit requirements applicable to the City for these fiscal years to assure that proper and sufficient audit reports have been issued and provided to the Department. If you have any questions or need further assistance, please do not hesitate to contact this office. Sincerely, Ron Carlson Subdivision Review Coordinator RC:kk Prints with soy ink on recycled paper