Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
FY08 Airport Enterprise Fund
07/14/08 08:43:23 FUND: CITY OF KALISPELL MONTH: 6 Page 1 gb702-kl AIRPORT ENTERPRISE G/L TRIAL BALANCE FISCAL YR: 2008 ahr ACCOUNT NUMBER ------------------------------------------------------------------------------------------------------------------------------------ ACCOUNT TITLE BAL FWRD YTD DEBITS YTD CREDITS YTD BALANCE 5160-000-010100-000 CASH, AIRPORT OPERATIONS 90,429.84 163,840.47 164,330.38- 89,939.93 5160-000-010120-000 CASH, CAPITAL RESERVE 25,000.00 5,000.00 .00 30,000.00 5160-000-010130-000 CASH, LAND SALES 193,559.96 .00 56,238.00- 137,321.96 5160-000-012200-000 ACCOUNTS RECEIVABLE 2,134.30 .00 2,134.30- .00 5160-000-018800-000 CIP-MONK PROPERTY 35,570.00 .00 .00 35,570.00 5160-000-018950-000 GENERAL FACILITY 3,288,828.84 .00 .00 3,288,828.84 5160-000-018951-000 DEPRECIATION - GENERAL FACILITY 153,995.09- .00 .00 153,995.09- ** SUB -TOTALS FOR TYPE: A 3,481,527.85 168,840.47 222,702.68- 3,427,665.64 5160-000-020200-000 ACCOUNTS PAYABLE 5,464.54- 128,211.64 138,583.92- 15,836.82- 5160-000-020620-000 PAYROLL PAYABLE 444.00- 16,107.98 17,121.83- 1,457.85- 5160-000-022200-000 REVENUES COLLECTED IN ADVANCE .00 .00 10,419.00- 10,419.00- 5160-000-023900-000 COMPENSATED ABSENCES PAYABLE 2,754.59- .00 .00 2,754.59- ** SUB -TOTALS FOR TYPE: L 8,663.13- 144,319.62 166,124.75- 30,468.26- 5160-000-027200-000 RETAINED EARNINGS 3,472,864.72- .00 .00 3,472,864.72- ** SUB -TOTALS FOR TYPE: Q 3,472,864.72- .00 .00 3,472,864.72- 5160-000-343062-000 COMMERCIAL FEES .00 .00 10,680.00- 10,680.00- 5160-000-343063-000 TIE DOWN FEES .00 .00 4,260.00- 4,260.00- 5160-000-343069-000 HANGER LEASES .00 18,995.90 31,972.65- 12,976.75- 5160-000-343071-000 HANGAR SITE LEASES .00 11,403.00 40,025.86- 28,622.86- 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION .00 .00 16,464.00- 16,464.00- 5160-000-343102-000 GROUND LEASES .00 .00 10,115.68- 10,115.68- 5160-000-343200-000 UTILITY REBATES .00 .00 3,372.78- 3,372.78- 5160-000-343620-000 FUEL TAX .00 .00 4,476.36- 4,476.36- 5160-000-371010-000 INVESTMENT EARNINGS .00 260.25 14,556.64- 14,296.39- ** SUB -TOTALS FOR TYPE: R .00 30,659.15 135,923.97- 105,264.82- 5160-430-430310-110 SALARIES .00 33,340.12 418.00- 32,922.12 5160-430-430310-111 SEASONAL SALARIES .00 147.42 .00 147.42 5160-430-430310-153 HEALTH INSURANCE .00 3,712.89 .00 3,712.89 5160-430-430310-155 RETIREMENT .00 2,101.87 26.00- 2,075.87 5160-430-430310-210 OFFICE SUPPLIES .00 650.03 .00 650.03 5160-430-430310-218 NON -CAPITAL EQUIPMENT .00 3,038.97 .00 3,038.97 5160-430-430310-335 MEMBERSHIP & DUES .00 260.00 .00 260.00 5160-430-430310-341 ELECTRICITY .00 1,249.45 70.45- 1,179.00 5160-430-430310-345 TELEPHONE .00 1,208.25 .00 1,208.25 5160-430-430310-353 CONTRACT SERVICES (FAA REIMB) .00 15,200.00 .00 15,200.00 5160-430-430310-354 CONTRACT SERVICES .00 11,268.90 .00 11,268.90 5160-430-430310-355 CONTRACT SERVICES -MOWING .00 3,133.38 .00 3,133.38 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL .00 3,971.98 .00 3,971.98 5160-430-430310-357 CONTRACT SERVICES (NOT FAA REIMB.) .00 2,248.58 .00 2,248.58 5160-430-430310-360 REPAIRS & MAINTENANCE .00 6,272.59 299.65- 5,972.94 5160-430-430310-362 EQUIPMENT MAINTENANCE .00 655.03 .00 655.03 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS .00 680.00 .00 680.00 5160-430-430310-373 TRAVEL .00 1,584.22 .00 1,584.22 5160-430-430310-380 SIGNAGE .00 219.20 .00 219.20 5160-430-430310-390 EQUIPMENT RENTAL .00 665.00 .00 665.00 5160-430-430310-510 PROPERTY INSURANCE .00 5,854.00 .00 5,854.00 5160-430-430310-522 ADMINISTRATIVE TRANSFER .00 4,288.56 .00 4,288.56 5160-430-430310-528 DATA PROCESSING .00 1,906.08 .00 1,906.08 5160-430-430310-950 CONSTRUCTION IN PROGRESS .00 95,538.32 39,300.32- 56,238.00 5160-430-430310-951 FUEL SYSTEM UPGRADE .00 21,851.74 .00 21,851.74 ** SUB -TOTALS FOR TYPE: X .00 221,046.58 40,114.42- 180,932.16 **** FUND TOTAL **** .00 564,865.82 564,865.82- .00 07/1-1/08 CITY OF KALISPELL Page 1 AIRPORT ENTERPRISE FUND 071108 FUND REVENUE AIRPORT FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------- AIRPORT REVENUE 5160-000-343062-000 COMMERCIAL FEES 10,680 12,000 1,320 11% 5160-000-343063-000 TIE DOWN FEES 4,260 3,000 1,260- -42% 5160-000-343069-000 HANGER LEASES 12,977 12,000 977- -8% 5160-000-343071-000 HANGAR SITE LEASES 28,623 10,000 18,623- -186% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 16,464 17,000 536 3% 5160-000-343102-000 GROUND LEASES 10,116 10,000 116- -1% 5160-000-343200-000 UTILITY REBATES 3,373 3,000 373- -12% 5160-000-343620-000 FUEL TAX 4,476 5,000 524 10% 5160-000-371010-000 INVESTMENT EARNINGS 14,296 25,000 10,704 43% TOTAL REVENUE ---------- 105,265 ---------- 97,000 ---------- 8,265- ------ -9% OPERATING EXPENSES 5160-430-430310-110 SALARIES 32,922 28,609 4,313- -15% 5160-430-430310-111 SEASONAL SALARIES 147 0 147- 0% 5160-430-430310-121 SEASONAL SALARIES 0 3,000 3,000 100% 5160-430-430310-153 HEALTH INSURANCE 3,713 3,800 87 2% 5160-430-430310-155 RETIREMENT 2,076 2,000 76- -4% 5160-430-430310-210 OFFICE SUPPLIES 650 600 50- -8% 5160-430-430310-215 COMPUTER SUPPLIES 0 1,000 1,000 100% 5160-430-430310-218 NON -CAPITAL EQUIPMENT 3,039 5,000 1,961 39% 5160-430-430310-335 MEMBERSHIP & DUES 260 300 40 13% 5160-430-430310-341 ELECTRICITY 1,179 1,800 621 35% 5160-430-430310-345 TELEPHONE 1,208 1,000 208- -21% 5160-430-430310-353 CONTRACT SERVICES (FAA REIMB) 15,200 0 15,200- 0% 5160-430-430310-354 CONTRACT SERVICES 11,269 12,000 731 6% 5160-430-430310-355 CONTRACT SERVICES -MOWING 3,133 4,000 867 22% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 3,972 2,000 1,972- -99% 5160-430-430310-357 CONTRACT SERVICES (NOT FAA REI 2,249 0 2,249- 0% 5160-430-430310-360 REPAIRS & MAINTENANCE 5,973 6,000 27 0% 5160-430-430310-362 EQUIPMENT MAINTENANCE 655 1,000 345 35% 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 680 1,500 820 55% 5160-430-430310-370 MAINTENANCE BY PARKS DEPT. 0 1,500 1,500 100% 5160-430-430310-373 TRAVEL 1,584 2,000 416 21% 5160-430-430310-380 SIGNAGE 219 1,200 981 82% 5160-430-430310-390 EQUIPMENT RENTAL 665 2,500 1,835 73% 5160-430-430310-510 PROPERTY INSURANCE 5,854 7,000 1,146 16% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 4,289 4,289 0 0% 5160-430-430310-528 DATA PROCESSING 1,906 1,906 0 0% 5160-430-430310-820 DEPRECIATION 0 5,000 5,000 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 56,238 193,560 137,322 71% 5160-430-430310-951 FUEL SYSTEM UPGRADE 21,852 0 21,852- 0% TOTAL AIRPORT OPERATIONS -------------------- 180,932 ---------- 292,564 ------ 111.632 38% S 100% Yr Complete S 06/26/08 CITY OF KALISPELL Page 1 AIRPORT ENTERPRISE FUND 062508 FUND REVENUE AIRPORT FUND ACTUAL YTD BUDGET REMAINING ------------------------------------------------------------------------------------------ AIRPORT REVENUE 5160-000-343062-000 COMMERCIAL FEES 10,530 12,000 1,470 12% 5160-000-343063-000 TIE DOWN FEES 4,260 3,000 1,260- -42% 5160-000-343069-000 HANGER LEASES 12,977 12,000 977- -8% 5160-000-343071-000 HANGAR SITE LEASES 39,042 10,000 29,042- -290% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 16,464 17,000 536 3% 5160-000-343102-000 GROUND LEASES 10,116 10,000 116- -1% 5160-000-343200-000 UTILITY REBATES 3,373 3,000 373- -12% 5160-000-343620-000 FUEL TAX 4,476 5,000 524 1096 5160-000-371010-000 INVESTMENT EARNINGS 14,032 25,000 10,968 44% TOTAL REVENUE 115,270 97,000 18,270- -1996 OPERATING EXPENSES 5160-430-430310-110 SALARIES 31,689 28,609 3,080- 5160-430-430310-121 SEASONAL SALARIES 0 3,000 3,000 5160-430-430310-153 HEALTH INSURANCE 3,713 3,800 87 5160-430-430310-155 RETIREMENT 1,999 2,000 1 5160-430-430310-210 OFFICE SUPPLIES 650 600 50- 5160-430-430310-215 COMPUTER SUPPLIES 0 1,000 1,000 5160-430-430310-218 NON -CAPITAL EQUIPMENT 3,039 5,000 1,961 5160-430-430310-335 MEMBERSHIP & DUES 260 300 40 5160-430-430310-341 ELECTRICITY 1,179 1,800 621 5160-430-430310-345 TELEPHONE 985 1,000 15 5160-430-430310-354 CONTRACT SERVICES 9,264 10,000 736 5160-430-430310-355 CONTRACT SERVICES -MOWING 511 4,000 3,490 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 3,972 4,000 28 5160-430-430310-360 REPAIRS & MAINTENANCE 5,973 6,000 27 5160-430-430310-362 EQUIPMENT MAINTENANCE 595 1,000 405 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 680 1,500 820 5160-430-430310-370 MAINTENANCE BY PARKS DEPT. 0 1,500 1,500 5160-430-430310-373 TRAVEL 1,584 2,000 416 5160-430-430310-380 SIGNAGE 219 1,200 981 5160-430-430310-390 EQUIPMENT RENTAL 665 2,500 1,835 5160-430-430310-510 PROPERTY INSURANCE 5,854 7,000 1,146 5160-430-430310-522 ADMINISTRATIVE TRANSFER 4,289 4,289 0 5160-430-430310-528 DATA PROCESSING 1,906 1,906 0 5160-430-430310-820 DEPRECIATION 0 5,000 5,000 5160-430-430310-950 CONSTRUCTION IN PROGRESS 95,538 193,560 98,022 i 100% Yr Complete 100% 2% 0% -8% 100% 39% 13% 35% 2% 7% 87°; 1% 0% 40% 55% 100% 21% 82% 73% 16% 0% 0% 100% 51% TOTAL AIRPORT OPERATIONS 174.563 292,564 118,001 40% LB ® S® - .T ,a- i> ' , 2, 5'ao 5, 0 e0 o 07/M/c8 0c�:45:45 FROM: 07/01/07 CITY OF KALISPELL Page 1 gb705-1s TO: 06/30/08 MONTHLY DEBIT/CREDITS trs DATE BATCH V/C# REFERENCE BEG BAL DEBITS CREDITS END SAL ------------------------------------------------------------------------------------------- ----------------------------- 5160-430-430310-950 CONSTRUCTION IN PROGRESS 12/20/07 19394 84200 Hatfield & Daws;INV:20976;airport-pro Svcs-kgez antenn 15,200.00 ---------------------------------------- 5160-430-430310-950 ** DEC TOTALS ** .00 15,200.00 .00 15,200.00 O1/31/08 19545 2091 Applied Water C;INV:656;Airport-svcs 10/01-12/31/07 2,248.58 ----------------------------------- 5160-430-430310-950 ** JAN TOTALS ** 15,200.00 2,248.58 .00 17,448.58 03/20/08 19697 12364 Robert Peccia &;INV:031308;airport-prof svcs 3/1-3/31/ 44,408.00 03/31/08 19799 12471 Red Eagle Aviat;INV:111407;airport-facility upgrade 21,851.74al ----------------------- `— ------------ ----- 5160-430-430310-950 ** MAR TOTALS ** 17,448.58 66,259.74 .00 83,708.32 04/25/08 19827 0 241A-2008 move 1/2 Peccia bill to 5160 11,830_00 5160-430-430310-950 ** APR TOTALS ** 83,708.32 11,830.00 .00 95,538.32 ------------------------------------------------ ** ACCOUNT TOTALS ** .00 95,538.32 .00 95,538.32 *** GRAND TOTALS *** .00 95,538.32 .00 95,538.32 /A, IN At ° t 1. Hatfield & Dawson, Broadcast Engineers KGEZ Tower Removal $ 15,200 This expenditure should be paid for using Airport TIF funds because it is paving the way for the airport expansion project. 3 9 5. roll '117i I 11:1n $ 3,000 This expenditure should be paid by the Airport TIF because it was for a proposed new entrance to the Airport. Barrie Appraisal & Consulting, LLC, Review appraisal for the Fireplace Store $ 405 This expenditure should be paid by the Airport TIF because it is the review of the above appraisal. Applied Water Consulting, Enviromental Assessment This expenditure should be paid for by the Airport TIF because it is for the above acquisition. 9 This expenditure was for the surveying of city lands for future airport construction and should be paid for by the Airport TIF. RIM This expenditure is for the drafting of a revised Airport Layout Plan and should be paid from Airport TIF funds. 7. Red Eagle Aviation, Upgrade of City owned fuel terminal $ 21,852 This expenditure was to upgrade the credit card refueling apparatus at the airport and is not part of the operational expenses of the airport. Asset purchased by the City was obsolete. 1. Sands Surveyors, Odeggard easement drawings airport entrance. $2,050 This should be paid for by the Airport TIF because it is the proposed new entrance for the airport. 01. Revision of the Airport Tax Increment District, $5,100 3. S & S Camper/ R & R Development Appraisal $12,5(a This should be paid out of the Airport TIF and not from the Airport Enterprise Fund. 4. Thomas Stevens Appraisal, Diamond Aire Appraisal $ 510010 This is an appraisal for the purchase of lands to improve the airport and should be paid out of the Airport TIF, not the Airport Operational Funds. 5. Hatfield & Dawson, Broadcast Engineers KGEZ Tower Removal $18,800 This is the balance on the contract for Consulting Services to relocate the Towers. This project should be paid for from Airport TIF funds not Airport Operational Funds. O8/21/07 CITY OF KALISPELL Page 1 AIRPORT ENTERPRISE FUND 17% Yr Complete FUND REVENUE AIRPORT FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------- AIRPORT REVENUE 5160-000-343062-000 COMMERCIAL FEES 1,650 12,000 10,350 86% y.Cf"''✓ 513�6 5160-000-343063-000 TIE DOWN FEES 780 3,000 2,220 74% 5160-000-343069-000 /. HANGER LEASES `f 21,031 12,000 9,031- -75% j. 5160-000-343071-000 HANGAR SITE LEASES 0 10,000 10,000 100% ids 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 2,744 17,000 14,256 84% �'�L^'" 5160-000-343102-000 GROUND LEASES �' 10,116 10,000 116- -1% 5160-000-343200-000 UTILITY REBATES 0 3,000 3,000 100% n 5160-000-343620-000 FUEL TAX 960 5,000 4,040 81% 5160-000-371010-000 INVESTMENT EARNINGS 0 20,000 20,000 100% TOTAL REVENUE 37,281 92,000 54,719 5996 OPERATING EXPENSES 5160-430-430310-110 SALARIES 2,372 28,609 26,237 92% 5160-430-430310-121 OVERTIME 0 3,000 3,000 100°% -- 5160-430-430310-153 HEALTH INSURANCE 466 3,800 3,334 88% 5160-430-430310-155 RETIREMENT 152 1,000 848 85% 5160-430-430310-210 OFFICE SUPPLIES 3 600 597 100% 5160-430-430310-215 COMPUTER SUPPLIES 0 2,000 2,000 100% 5160-430-430310-218 NON -CAPITAL EQUIPMENT 3,039 5,000 1,961 39% 5160-430-430310-335 MEMBERSHIP & DUES 0 300 300 100% 5160-430-430310-341 ELECTRICITY 70 1,800 1,730 96% 5160-430-430310-345 TELEPHONE 118 1,000 882 88% 5160-430-430310-354 CONTRACT SERVICES 0 10,000 10,000 100% 5160-430-430310-355 CONTRACT SERVICES -MOWING 150 4,000 3,851 96% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 0 4,000 4,000 100% 5160-430-430310-360 REPAIRS & MAINTENANCE 459 6,000 5,541 92% 5160-430-430310-362 EQUIPMENT MAINTENANCE 6 1,000 994 99% 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 0 1,500 1,500 100% 5160-430-430310-370 MAINTENANCE BY PARKS DEPT, 0 1,500 1,500 100% 5160-430-430310-373 TRAVEL 0 2,000 2,000 100% 5160-430-430310-380 SIGNAGE 69 1,200 1,131 94% 5160-430-430310-390 EQUIPMENT RENTAL 0 2,500 2,500 100% 5160-430-430310-510 PROPERTY INSURANCE 1,679 7,000 5,321 76% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 0 4,289 4,289 100% 5160-430-430310-528 DATA PROCESSING 0 1,906 1,906 100% jj JJ 5160-430-430310-532 RENTAL 60 0 60- 0% 5160-430-430310-820 DEPRECIATION 0 5,000 5,000 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 0 193,560 193,560 100% ---------- TOTAL AIRPORT OPERATIONS ---------- 8,644 ---------- 292,564 ------ 283,920 97% S _