Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
1st Quarter Finance Report
City of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 - • Telephone (406) 758-7000 Fax - (406) 758-7758 MONTANA Date: September 30, 2009 TO: Mayor Kennedy and City Council members Jane Howington, City Manager From: Amy Robertson Finance Director RE: 1 st Qtr Finance Report - FY2010 Please find attached a printout reflecting activity for the 1 ' quarter of the fiscal year. General Fund revenue is slow. Personal Property taxes were delayed by the County (should have been booked in June) and are reflected here. Planning fees reflect a $28,000 Wal-Mart receipt. Interest rates continue to drop. This printout includes payroll thru September 25th and claims paid the 12th of October and posted for September (Oct. health premiums were posted in September). Police severance and fire severance were unexpected and not budgeted. Those shortfalls will be absorbed by the vacancies. Funds Presentation Notes: The expenditure budgets follow in fund number order, General fund first. Debt service funds and funds with no activity are not presented. In the Enterprise funds (water, sewer, garbage, and airport) debt service payments are made December 31st and June 30th but accrued July 1'. Depreciation expense will not be posted until after fiscal year end when the capital outlay accounts are closed out to asset accounts on the balance sheet. The utility fund line items for M & O should be reviewed individually. The wwtp budgeted depreciation amount is the amount we set aside, 1/12 per month, in the cash replacement account shared with Evergreen. It is not an expense but only a reservation of cash and will not appear on the budget print out as an expense. This is true of all amounts reserved for replacement or payment of compensated absences. When preparing the budget we present debt service, replacement and depreciation accounts to show the flow of cash, these numbers appear on this report to reconcile with the budget book. Enterprise fund revenue is the amount billed, not collected. Storm Sewer and Solid Waste revenue is the amount billed on the tax notices by the County. The tax and assessment receivables will be booked at the end of this month. For non- enterprise funds such as Street Maintenance, Lighting and Forestry revenue for assessments is the amount collected to date. Accounting for governmental funds is basically on a cash basis unlike the Enterprise funds which are full accrual. Please call if you have questions -W- 758-7755 10/14/09 CITY OF KALISPELL Page 1 Quarterly Finance Report 25% Yr Complete FUND 1000-000-311100-000 1000-000-311200-000 1000-000-312000-000 1000-000-322101-000 1000-000-322300-000 1000-000-322500-000 1000-000-323012-000 1000-000-323107-000 1000-000-3231G9-000 1000-000-323111-000 1000-000-323300-000 1000-000-334017-000 1000-000-335030-000 1000-000-335076-000 1000-000-335077-000 1000-000-335230-000 1000-000-341020-000 1000-000-341022-000 1000-000-341025-000 1000-000-341027-000 1000-000-342010-000 1000-000-342014-000 1000-000-342016-000 1000-000-342023-000 1000-000-342024-000 1000-000-342025-000 1000-000-343005-000 1000-000-351000-000 1000-000-351015-000 1000-000-351016-000 1000-000-351017-000 1000-000-362010-000 1000-000-364030-000 1000-000-365015-000 1000-000-365018-000 1000-000-371010-000 1000-000-381060-000 FUND GENERAL FUND - REVENUE REAL PROPERTY TAXES PERSONAL PROPERTY TAXES PEN & INTEREST DEL. TAXES BEER & LIQUOR LICENSES BUSINESS LICENSES AMUSEMENT LICENSES PLANNING FEES EXCAV/DEMO/AIR/HOUSE MOVING PERMITS SITE REVIEW ZONING FEES ANIMAL LICENSES 911 REIMBURSEMENT/Dispatch M.V. TAX - AD VALOREM ST VIDEO -LIC FEE AND TAX DIST LIVE KENO & BINGO TAX HB124 ENTITLEMENT ADMINISTRATIVE CHARGES BOND FEES/ADMIN.CHG. CITY COLLECTIONS BRESNAN FRANCHISE FEES POLICE SERVICES RESOURCE OFFICERS KPD REGIONAL TRAINING FIRE PREVENTION PROGRAM FEES EPA GRANT -FIRE DEPT DIRECT REIMB, FIRE ENGINE RESPONSE FEE CENTRAL GARAGE CHARGE CITY COURT FINES & FEES KPD DRUG FINES DUI COURT FINE COURT SECURITY & TECHNOLOGY FEE CITY GOLF COURSE LEASE SALE OF MISCELLANEOUS/AUCTION CONTRIBUTION FRM KIDSPORT BANDSHELL CONTRIBUTIONS INVESTMENT EARNINGS OPERATING TRANSFER- FUND 2372 TOTAL REVENUE ACTUAL YTD BUDGET REMAINING % 90,702 4,229,980 4,139,278 98% 164,738 244,300 79,562 33% 4,662 21,600 16,938 78% 0 26,381 26,381 100% 80 1,200 1,120 93% 300 600 300 50% 29,139 75,000 45,861 61% 265 500 235 47% 7,272 30,000 22,728 76% 16,363 65,000 48,637 75% 257 1,200 943 79% 0 3,000 3,000 100% 0 1,844 1,844 100% 0 60,325 60,325 100% 0 3,600 3,600 100% 454,709 2,270,106 1,815,397 80% 123,250 492,998 369,748 75% 0 15,500 15,500 100% 150 1,500 1,350 90% 0 155,000 155,000 100% 3,267 20,000 16,733 8496 0 86,000 86,000 100% 1,500 15,000 13,500 90% 16,969 17,000 31 0% 0 50,000 50,000 100% 4,610 5,000 390 8% 29,801 118,000 88,199 75% 74,647 471,000 396,353 84% 656 4,000 3,344 B4% 610 11000 390 39% 4,491 21,000 16,509 79% 0 25,471 25,471 100% 50 3,500 3,450 99% 0 42,000 42,000 100% 2,926 0 2,926- 0% 15,633 85,000 69,367 82% 0 ----------- 516,615 516,615 100% 1,047,049 ----------- 9,180,220 --------------------- B,133,172 89% 10/14/09 CITY OF KALISPELL Page 2 Quarterly Finance Report 25% Yr Complete FOND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL, REPORT FILING FEES 0 1,000 1,000 100% 1000-400-410530-353 AUDITING 0 10,500 10,500 100% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 281 3,000 2,719 91% 1000-400-410560-312 POSTAGE 3,462 20,000 16,538 83% 1000-400-410560-320 PRINTING 2,537 3,500 963 28% 1000-400-410600-354 ELECTIONS 0 9,000 9,000 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 368 5,000 4,632 93% 1000-400-460446-354 KIDSPORT LEASE 0 42,000 42,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-COO CONTINGENCY 0 40,000 40,000 100% 1000-400-510310-354 ICMA PLAN FEES 125 500 375 75% 1000-400-510330-513 LIABILITY INSURANCE 223,116 230,200 7,084 3% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 8,294 32,000 23,706 74% 1000-400-510330-517 PROPERTY INSURANCE 47,847 48,000 153 0% SUBTOTAL GEN.GOV'T. ----------- 286,029 ----------- 451,300 --------------------- 165,271 37% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 23,451 117,303 93,852 80% 1000-401-410210-153 HEALTH INSURANCE 2,201 12,104 9,903 82% 1000-401-410210-155 RETIREMENT 1,234 7,637 6,403 84% 1000-401-410210-210 OFFICE SUPPLIES 86 100 14 14% 1000-401-410210-215 COMPUTER SOFTWARE/SUPPLIES 0 300 300 100% 1000-4G1-410210-218 OFFICE FURNITURE 0 500 500 100% 1000-401-410210-229 OTHER SUPPLIES 231 600 369 62% 1000-401-410210-312 NEWSLETTER 0 500 500 100% 1000-401-410210-322 BOOKS 0 150 150 100% 1000-401-410210-335 MEMBERSHIP & DUES 40 2,100 2,060 98% 1000-401-410210-33H MOVING EXPENSES 289 20,000 19,711 99% 1000-401-410210-345 TELEPHONE & COMMUNICATION 24 1,000 976 98% 1000-401-410210-373 SCHOOL & TRAVEL 100 1,800 1,700 94% SUBTOTAL CITY MANAGER ----------- 27,656 ----------- 164,094 `---------- ---------- 136,438 83% HUMAN RESOURCES 1000-401-410830-110 SALARIES -PERSONNEL 24,457 103,338 78,381 76% 1000-401-410830-153 HEALTH INSURANCE 3,637 9,090 5,453 60% 1000-401-410830-155 RETIREMENT 1,624 6,696 5,072 76% 1000-401-410830-210 OFFICE SUPPLIES 0 350 350 100% 1000-401-410830-215 COMPUTER SUPPLIES 91 350 259 74% 1000-401-410830-218 SMALL OFFICE EQUIP/FURNITURE 0 250 250 100% 1000-401-410830-229 OTHER SUPPLIES 0 200 200 100% 1000-401-410830-320 PRINTING 0 100 100 100% 1000-401-410830-322 BOOKS 0 150 150 100% 1000-401-410830-335 MEMBERSHIP & DUES 160 400 240 60% 1000-401-410830-338 RECRUITMENTMEGOTIATIONS 400 3,500 3,100 89% 1000-401-410830-345 TELEPHONE 26 150 124 83% 1000-401-410830-354 CONTRACT SERVICES 0 100 100 100% 1000-401-410830-373 SCHOOL & TRAVEL 1,549 3,500 1,951 56% SUBTOTAL HUMAN RESOURCES ----------- 32,443 ------------ 128,174 --------------------- 95,731 75% 10/14/09 CITY OF KALISPELL Page 3 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------- `---------------------------------------------------- MEDIA SPECIALIST 1000-401-410900-110 MEDIA SPECIALIST -salary 4,713 20,102 15,389 77$ 1000-401-410900-153 HEALTH INSURANCE 2,563 6,114 3,551 58% 1000-401-410900-155 RETIREMENT 317 1,299 982 76% 1000-401-410900-218 EQUIPMENT 206 1,000 794 79% 1000-401-410900-354 CONTRACT SERVICES 450 2,500 2,050 82% SUBTOTAL MEDIA SPECIALIST ----------- 8,246 ----------- 31,015 --------------------- 22,767 73% MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 15,048 63,162 48,114 76% 1000-402-410100-153 HEALTH INSURANCE 10,100 30,300 20,200 67% 1000-402-410100-155 RETIREMENT 593 2,015 1,422 71% 1000-402-410100-210 Office Supplies 0 100 100 100% 1000-402-410100-335 MEMBERSHIP & DUES 4,267 6,300 2,033 32% 1000-402-410100-345 TELEPHONE & COMMUNICATION 6 100 94 94% 1000-402-410100-373 SCHOOL & TRAVEL 200 3,000 2,800 93% 1000-402-410100-379 MEETINGS 0 300 300 100% SUBTOTAL MAYOR/COUNCIL ----------- 30,213 ----------- 105,277 ----------- ---------- 75,064 71% CITY CLERK 1000-402-410150-110 SALARIES/CITY CLERK 18,415 77,026 58,611 76% 1000-402-410150-121 OVERTIME 0 500 500 100% 1000-402-410150-153 HEALTH INSURANCE 2,972 9,002 6,030 67% 1000-402-410150-155 RETIREMENT 1,194 4,978 3,785 76% 1000-402-410150-210 OFFICE SUPPLIES 57 150 93 62% 1000-402-410150-229 OTHER SUPPLIES 0 50 50 100W 1000-402-410150-335 MEMBERSHIP & DUES 50 275 225 82% 1000-402-410150-345 TELEPHONE & COMMUNICATION 82 400 318 80% 1000-402-410150-352 RECODIFICATION 1,801 3,500 1,699 49% 1000-402-410150-354 CONTRACT SERVICES 0 25 25 100% SUBTOTAL CITY CLERK ----------- 24,570 ----------- 95,906 --------------------- 71,336 74% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 46,494 191,986 145,492 76% 1000-403-410550-121 OVERTIME 73 0 73- 09. 1000-403-410550-153 HEALTH INSURANCE 9,754 29,262 19,508 67% 1000-403-410550-155 RETIREMENT 3,035 12,430 9,395 76% 1000-403-410550-322 BOOKS 0 250 250 100% 1000-403-410550-335 MEMBERSHIP & DUES 279 1,000 721 72% 1000-403-410550-345 TELEPHONE & COMMUNICATION 13 100 87 87% 1000-403-410550-353 CONTRACT SERVICES 51 470 419 89% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 795 1,500 705 47% 1000-403-410550-355 BANK CHARGES & FEES 619 4,500 3,881 86% 1000-403-410550-373 SCHOOL & TRAVEL 586 2,000 1,414 71% SUBTOTAL FINANCE ----------- 61,698 ----------- 243,498 --------------------- 181,800 75% 10/14/09 CITY OF KALISPELL Quarterly Finance Report FOND _"-------------------------------------..__-----------------------------------------__------------------------- FUND ACTUAL YTD BUDGET REMAINING % CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY-S 74,036 307,944 233,908 76% 1000-404-411110-153 HEALTH INSURANCE 15,639 46,832 31,193 67% 1000-404-411110-155 RETIREMENT 4,828 19,972 15,144 76% 1000-404-411110-210 OFFICE SUPPLIES 152 1,200 1,048 87% 1000-404-411110-215 COMPUTER SUPPLIES 676 1,500 824 55% 1000-404-411110-322 BOOKS, CDs, LE%IS 2,188 7,000 4,812 69% 1000-404-411110-335 MEMBERSHIP & DUES 460 2,500 2,020 81% 1000-404-411110-345 TELEPHONE & COMMUNICATION 179 1,200 1,021 85% 1000-404-411110-354 CONTRACT SERVICES 0 5,000 5,000 100% 1000-404-411110-373 SCHOOL & TRAVEL 100 2,525 2,425 96% SUBTOTAL CITY ATTORNEY ----------- 98,278 ----------- 395,673 --------------------- 297,395 75% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 47,211 199,353 152,142 76% 1000-406-410360-121 OVERTIME 41 0 41- 0% 1000-406-410360-153 HEALTH INSURANCE 12,190 33,977 21,787 64% 1000-406-410360-155 RETIREMENT 3,084 12,908 9,824 76% 1000-406-410360-210 OFFICE SUPPLIES 830 1,000 170 17% 1000-406-410360-213 OFFICE EQUIPMENT/MAINT. 932 1,000 68 7% 1000-406-410360-215 COMPUTER SUPPLIES 345 1,000 655 66% 1000-406-410360-229 OTHER SUPPLIES 20 1,500 1,480 99% 1000-406-410360-320 PRINTING 140 500 360 72% 1000-406-410360-322 BOOKS 1,205 1,250 45 4% 1000-406-410360-335 MEMBERSHIP & DUES 200 300 100 33% 1000-406--410360-345 TELEPHONE & COMMUNICATION 913 1,400 487 35% 1000-406-410360-353 SECURITY & TECHNOLOGY 711 34,750 34,039 98% 1000-406-410360-354 CONTRACT SERVICES 3,191 5,750 2,559 45% 1000-406-410360-373 SCHOOL & TRAVEL 963 6,000 5,037 84% 1000-406-410360-394 JURY & WITNESS FEES 2,502 4,500 1,998 44% 1000-406-410360-395 DRUG COURT 0 1,000 1,000 100% SUBTOTAL COURT ----------- 74,477 ----------- 306,188 ------------------__-- 231,711 76% DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 2,553 11,624 9,071 78% 1000-410-430100-153 HEALTH INSURANCE 543 1,990 1,447 73% 1000-410-430100-155 RETIREMENT 166 B00 634 79% 1000-410-430100-210 OFFICE SUPPLIES 368 675 307 45% 1000-410-430100-213 SMALL OFFICE EQUIPMENT 0 150 150 100% 1000-410-430100-215 COMPUTER SUPPLIES 0 250 250 100% 1000-410-430100-216 COMPUTER EQUIPMEMT/SUPPLIES 0 350 350 100% 1000-410-430100-229 OTHER SUPPLIES 42 350 308 88% 1000-410-430100-331 PUBLICATION & FILING FEES 120 300 180 60% 1000-410-430100-335 MEMBERSHIP & DUES 0 350 350 100% 1000-410-430100-345 TELEPHONE & COMMUNICATION 0 I,000 1,000 100% 1000-410-430100-354 CONTRACT SERVICES 421 150 271- -180% 1000-410-430100-373 SCHOOL & TRAVEL 40 400 360 90% SUBTOTAL ADMINISTRATION ----------- 4,253 ----------- 18,389 -------------..__----- 14,136 77% CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 40,413 151,549 111,136 73% 1000-410-431330-121 OVERTIME 15 1,500 1,485 99% 1000-410-431330-153 HEALTH INSURANCE 6,488 29,106 20,618 71% 1000-410-431330-155 RETIREMENT 2,506 9,297 6,791 73% 1000-410-431330-210 OFFICE SUPPLIES 20 300 280 93% 1000-410-431330-215 COMPUTER SUPPLIES 1,500 800 700- -88% 1000-410-431330-218 EQUIPMENT (nor, -capital} 120 850 730 86% 1000-410-431330-221 SAFETY EQUIP & SUPPLIES 113 150 37 25% 1000-410-431330-229 OTHER SUPPLIES 1,185 3,500 2,315 66% 1000-410-431330-231 GAS & OIL 25,565 122,500 96,935 79% 1000-410-431330-232 MOTOR VEHICLE PARTS. 19,959 64,000 44,041 69% Page 4 25% Yr Complete 10/14/09 CITY OF KALISPELL Page 5 Quarterly Finance Report 25W Yr Complete FUND FUND 1000-410-431330-233 TIRES AND RELATED PARTS 1000-410-431330-238 FILTERS & MISC. PARTS 1000-410-431330-241 CONSUMABLE TOOLS 1000-410-431330-322 BOOKS 1000-410-431330-341 ELECTRICITY 1000-410-431330-342 WATER 1000-410-431330-344 NATURAL GAS 1000-410-431330-354 CONTRACT SERVICES 1000-410-431330-362 EQUIPMENT MAINTENANCE 1000-410-431330-366 BUILDING MAINTENANCE 1000-410-431330-373 SCHOOL & TRAVEL 1000-410-431330-388 MEDICAL SERVICES SUBTOTAL CENTRAL GARAGE TOTAL PUBLIC WORKS CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 1000-412-411230-121 OVERTIME 1000-412-411230-153 HEALTH INSURANCE 1000-412-411230-155 RETIREMENT 1000-412-411230-224 JANITORIAL SUPPLIES 1000-412-411230-229 OTHER SUPPLIES 1000-412-411230-241 CONSUMABLE TOOLS 1000-412-411230-341 ELECTRICITY 1000-412-411230-342 WATER 1000-412-411230-344 NATURAL GAS 1000-412-411230-345 TELEPHONE & COMMUNICATION 1000-412-411230-354 CONTRACT SERVICES 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 1000-412-411230-362 EQUIPMENT MAINTENANCE 1000-412-411230-366 BUILDING MAINTENANCE 1000-412-411230-532 RENT -NEW CITY HALL 1000-412-411230-545 COUNTY LANDFILL 1000-412-411230-610 BOI 2004 DEBT (RVAC SYS) 1000-412-411230-620 DOI 2004 INT. (HVAC SYS) SUBTOTAL CITY HALL 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 1000-420-411020-153 HEALTH INSURANCE 1000-420-411020-155 RETIREMENT 1000-420-411020-210 OFFICE SUPPLIES 1000-420-411020-213 OFFICE EQUIPMENT 1000-420-411020-215 COMPUTER SUPPLIES/SOFTWARE 1000-420-411020-320 PRINTING 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1000-420-411020-335 MEMBERSHIP/DUES 1000-420-411020-345 TELEPHONE 1000-420-411020-354 CONTRACT SERVICES 1000-420-411020-373 SCHOOL & TRAVEL TOTAL PLANNING DEPT. ACTUAL YTD BUDGET REMAINING 8 ----------------------------------------------- 4,063 27,000 22,937 85% 926 3,500 2,574 74% 141 500 359 72% 0 150 150 100% 363 1,700 1,337 79% 36 100 64 64% 279 9,000 8,721 97% 15,837 49,600 33,763 6H96 16 250 234 94% 40 335 295 88% 0 600 600 1008 80 375 295 79% ----------- 121,666 ----------- 476,662 --------------------- 354,996 74% 125,919 495,051 369,132 7591 9,586 40,877 31,291 77% 0 200 200 100% 2,884 8,653 5,769 67% 593 2,494 1,901 76% 1,348 5,000 3,652 73% 67 750 684 91% 68 800 732 92% 11,297 41,000 29,703 72% 697 4,500 3,813 85% 2,671 43,300 40,629 94% 55 250 195 78% 551 19,000 18,449 97% 0 4,500 4,500 100% 960 5,000 4,040 81% 1,528 25,178 23,650 94% 48,750 97,500 48,750 50% 0 2,000 2,000 100% 7,533 15,150 7,617 50% 1,421 2,400 979 41% ----------- 89,999 ----------- 318,552 --------------------- 228,553 72% 61,432 261,253 199,821 76% 17,082 52,073 34,991 6796 4,007 16,938 12,931 7696 413 2,500 2,087 83% 0 2,000 2,000 100% 2,968 5, 000 2,032 41% 0 500 50G 100% 363 4,000 3,637 91% 415 1,300 885 68% 238 900 662 74% 266 1,350 1,084 80% 425 ----------- 3,500 3,075 88% 947,140 ----------- 3,086,042 --------------------- 2,138,902 69% 10/14/09 CITY OF KALISPELL Quarterly Finance Report FUND -------------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 391,359 1,752,605 1,361,246 78% 1000-413-420140-112 SALARIES -SEVERANCE 16,427 0 16,427- 0% 1000-413-420140-114 SALARY -comptime buyout 0 6,500 6,500 100% 1000-413-420140-121 OVERTIME 20,943 75,000 54,057 72% 1000-413-420140-123 SPECIAL ASSIGNMENT OVERTIME 561 27,500 26,939 98% I000-413-420140-153 HEALTH INSURANCE 93,387 304,105 210,718 69% 1000-413-420140-155 RETIREMENT 49,094 230,721 181,627 79% 1000-413-420140-210 OFFICE SUPPLIES 743 3,000 2,257 75% 1000-413-420140-215 COMPUTER SUPPLIES 597 5,500 4,903 89% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 926 4,000 3,074 77% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 1,402 5,000 3,598 72% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 415 7,000 6,585 94% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 95 2,000 1,905 95% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 301 5,000 4,699 94% 1000-413-420140-227 AMMO & RELATED SUPPLIES 1,393 15,000 13,607 91% 1000-413-420140-228 PATROL CAR SUPPLIES 1,362 13,000 11,638 90% 1000-413-420140-229 OTHER SUPPLIES 929 3,500 2,571 73% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 301 2,000 1,699 95% 1000-413-420140-231 CRISIS NEGOTIATIONS 867 1,500 633 42% 1000-413-420140-235 BIKE PATROL 365 1,000 635 64% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 0 2,000 2,000 i0096 1000-413-420140-320 PRINTING 1,804 5,000 3,196 64% 1000-413-420140-335 MEMBERSHIP & DUES 105 1,000 895 90% 1000-413-420140-345 TELEPHONE & COMMUNICATION 3,219 15,000 11,781 79% 1000-413-420140-354 CONTRACT SERVICES 1,062 8,000 6,938 87% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 536 3,000 2,464 82% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 844 2,000 1,156 58% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 14,288 21,500 7,212 34% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 69 2,500 2,431 97% 1000-413-420140-373 SCHOOL & TRAVEL 10,521 26,000 15,479 60% 1000-413-420140-375 REGIONAL TRAINING 210 15,000 14,790 99% 1000-413-420140-380 TRAINING MATERIALS 745 2,000 1,255 63% 1000-413-420140-388 MEDICAL SERVICES 455 8,000 7,545 94% 1000-413-420140-391 TREATMENT 82 500 418 84% 1000-413-420140-392 BOARDING PRISONERS 0 1,000 1,000 100% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 0 49,000 49,000 100% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 0 20,000 20,000 100% 1000-413-420140-829 TRANSFER TO 2919 BLACK GRANT 0 10,000 10,000 100% 1000-413-42GI41-110 DETECTIVE -SALARIES 79,638 327,330 247,692 76% 1000-413-420141-121 DETECTIVE -OVERTIME 4,610 20,000 15,390 77% 1000-413-420141-153 HEALTH INSURANCE 17,698 54,325 36,627 67% 1000-413-420141-155 DETECTIVE -RETIREMENT 10,316 44,111 33,795 77% 1000-413-420142-110 DISPATCH -SALARIES 74,283 349,487 275,204 79% 1000-413-420142-121 DISPATCH -OVERTIME 3,083 15,000 11,917 79% 1000-413-420142-153 HEALTH INSURANCE 21,495 73,140 51,645 71% 1000-413-420142-155 DISPATCH -RETIREMENT 5,019 22,586 17,567 78% 1000-413-420142-215 COMPUTER SUPPLIES 0 1,700 1,700 100% 1000-413-420142-234 UNIFORMS 532 1,800 1,268 70% 1000-413-420142-373 SCHOOL & TRAVEL (reimb. 911) 120 6,000 5,880 98% 1000-413-420144-110 SRO SALARIES 27,265 107,306 80,041 75% 1000-413-420144-153 HEALTH INSURANCE 4,904 14,713 9,809 67% 1000-413-420144-155 SRO RETIREMENT 3,550 14,306 10,756 75% 1000-413-420145-354 SHELTER/ANIMAL:VET TREATMENT 0 6,500 6,500 100% SUBTOTAL POLICE DEPT. ----------- 867,920 ----------- 3,713,735 --------------------- 2,845,815 77% Page 6 25% Yr Complete 10/14/09 CITY OF KALISPELL Page 7 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- FIRE DEPARTMENT 1000-416-420400-110 FIRE SUPPRESSION -SALARIES 343,424 1,520,431 1,177,007 77% 1000-416-420400-112 SALARIES -SEVERANCE 19,441 2,500 16,941- -678% 1000-416-420400-113 KELLY DAYS 4,724 40,000 35,276 88% 1000-416-420400-121 OVERTIME 1,576 19,153 17,577 92% 1000-416-420400-153 HEALTH INSURANCE 80,579 242,475 161,896 67% 1000-416-420400-155 RETIREMENT 49,077 206,254 157,177 76% 1000-416-420400-210 OFFICE SUPPLIES 99 850 751 88% 1000-416-420400-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 1000-416-420400-215 COMPUTER SUPPLIES 8 500 492 98% 1000-416-420400-218 Equipment (Non Capital) 259 5,000 4,741 95% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 5,708 11,000 5,292 48% 1000-416-420400-224 JANITORIAL SUPPLIES 207 700 493 71% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 1,946 10,000 8,054 81% 1000-416-420400-320 PRINTING 39 200 161 B1% 1000-416-420400-345 TELEPHONE & COMMUNICATION 1,855 6,000 4,145 69% 1000-416-420400-354 CONTRACT SERVICES 407 5,000 4,594 92% 1000-416-420400-358 MT. F/F TESTING CONSORTIUM 0 1,000 1,000 loot 1000-416-420400-362 EQUIPMENT MAINTENANCE 1,016 5,000 3,984 80% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 636 15,500 14,864 96% 1000-416-420400-373 SCHOOL & TRAVEL 99 1,500 1,401 93% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 25,553 51,550 25,997 50% 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 8,528 16,475 7,947 48% 1000-416-420440-110 FIRE PREVENTION -SALARIES 17,023 70,890 53,867 76% 1000-416-420440-153 HEALTH INSURANCE 4,401 13,186 8,785 67% 1000-416-420440-155 RETIREMENT 2,311 9,574 7,263 76% 1000-416-420440-210 OFFICE SUPPLIES 178 500 322 64% 1000-416-420440-241 CONSUMABLE TOOLS/UNIFORMS 999 1,000 1 0% 1000-416-420440-314 PRIVATE HYDRANT RENTAL 0 5,500 5,500 100% 1000-416-420440-320 PRINTING 366 500 134 27% 1000-416-420440-322 BOOKS 0 500 500 10096 1000-416-420440-333 SUBSCRIPTION/FIRE CODES 55 500 445 89% 1000-416-420440-335 MEMBERSHIP/DUES 0 250 250 100% 1000-416-420440-345 TELEPHONE/COMMUNICATIONS 389 2,500 2,111 84% 1000-416-420440-354 CONTRACT SERVICES 178 1,000 823 82% 1000-416-420440-373 SCHOOL 6 TRAVEL 0 1,000 1,000 100% 1000-416-420440-379 MEETINGS 0 500 500 100% 1000-416-420440-380 TRAINING MATERIALS 0 500 500 100% 1000-416-420465-322 BOOKS 0 500 500 100% 1000-416-420465-380 TRAINING MATERIALS 589 2,000 1,411 71% 1000-416-420470-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 1000-416-420470-218 EQUIPMENT (NOT CAPITAL} 276 2,500 2,224 89% 1000-416-420470-224 JANITORIAL SUPPLIES 510 750 240 32% 1000-416-420470-241 CONSUMABLE TOOLS 210 400 190 48% 1000-416-420470-341 ELECTRICITY 2,254 10,000 7,746 77% 1000-416-420470-342 WATER 690 2,800 2,110 75% 1000-416-420470-344 NATURAL GAS 306 15,000 14,694 98% 1000-416-420470-354 CONTRACT SERVICES 730 2,000 1,270 63% 1000-416-420470-362 EQUIPMENT MAINTENANCE 529 1,500 971 65% 1000-416-420470-366 BUILDING MAINTENANCE 188 1,500 1,313 88% SUBTOTAL FIRE DEPT_ ----------- 577,361 ----------- 2,308,338 --------------------- 1,730,977 75% GRAND TOTAL GENERAL FUND 1,445,281 6,022,073 4,576,792 76% 10/14/09 CITY OF KALISPELL Page 8 Quarterly Finance Report 25% Yr Complete FOND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------- SPECIAL REVENUE FUNDS. 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 0 1,200 1,200 100% 2185-000-430300-356 PROFESSIONAL SERVICES 105 15,000 14,895 99% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 3,389 13,554 10,166 75% 2185-000-430300-840 REDEVELOPMENT CONTIGENCY 0 800,000 800,000 10096 2185-436-460430-218 LAKER'S BALLFIELD IMPROVEMENTS 0 10,000 10,000 100% 2185-436-460430-934 BEGG PARK IMPROVEMENTS 75 42,142 42,067 100% 2185-4HO-470240-110 SALARIES 7,096 49,113 42,017 86% 2185-480-470240-153 HEALTH INSURANCE 859 5,143 4,285 83% 2185-480-470240-155 RETIREMENT 462 3,188 2,726 86% TOTAL, AIRPORT TIF ----------- 11,995 ----------- 939,340 --------------------- 927,355 99% 2188 WESTSIDE TIF 2180-436-460430-930 GREENBRIAR PARK IMPROVEMENTS 0 18,180 18,180 100% 2188-453-430246-950 CONSTRUCTION/MERIDIAN ROAD 67,876 135,000 67,124 50% 2188-453-430246-951 STREET OVERLAYS 21,460 30,000 8,540 28% 2188-453-430246-952 LOWER SPRING CREEK 0 40,000 40,000 100% 2188-453-430246-953 3 MILE DR ROAD DESIGN 20,977 146,926 125,949 86% 2188-453-430246-955 DPW -REDEVELOPMENT ACTIVITY 0 225,884 225,884 100% 2188-480-470230-110 SALARIES 317 8,500 8,183 96% 2188-480-470230-153 HEALTH INSURANCE 76 1,000 924 92% 2188-480-470230-155 RETIREMENT 21 500 479 96% 2188-480-470230-353 AUDIT 0 750 750 100% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 0 5,000 5,000 100% 2188-480-470230-356 REDEVELOPMENT APPRAISALS 0 25,000 25,000 100% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 6,250 25,000 18,750 75% 2188-480-470230-955 CD -REDEVELOPMENT ACTIVITY 0 1,500,000 1,500,000 100% ------------- TOTAL WESTSI➢E TIF 116,977 ----------- 2,161,740 --------------------- 2,044,763 95% 2210 PARKS IN LIEU 2210-436-460430-826 TRANSFER TO ISTEA FUND 0 30,000 30,000 100% 2210-436-460430-934 CAPITAL IMPROVEMENTS 0 5,000 5,000 100% 2210-436-460430-935 SUNSET BASKETBALL COURT 0 5,500 5,500 100% 2210-436-460430-937 WESTVIEW IMPROVEMENTS ----------- 0 17,500 ----------- 17,500 100% TOTAL PARKS IN LIEU 0 58,000 --------------------- 58,000 100% 2215 NEW PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 0 842,000 842,000 100% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 0 5,000 5,000 100% 2215-000-346030-000 SWIMMING POOL FEES 85,266 160,000 74,734 47% 2215-000-346040-000 CONCESSION STAND REVENUE 22,455 35,000 12,545 36% 2215-000-346050-000 Parks Usage Fees 8,788 18,000 9,212 51% 2215-000-346051-000 RECREATION FEES 1,022 15,000 13,978 93% 2215-000-346052-000 SPORTS PROGRAMS 71289 40,000 32,711 82% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 462 3,000 2,538 85% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 5,282 33,500 28,218 84% 2215-000-346055-000 ICE RINK 0 25,000 25,000 100% 2215-000-346057-000 YOUTH CAMPS 12,840 85,000 72,160 85% 2215-000-346059-000 PICNIC IN THE PARK 6,475 33,000 26,525 80% 2215-000-365010-000 DONATION/FERTILIZER 600 0 600- 0% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 60,000 60,000 100% ----------- TOTAL PARKS & REC REVENUE 150,479 ----------- 1,354,500 --------------------- 1,204,021 89% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 59,544 263,573 204,029 77% 2215-436-460430-111 SEASONAL SALARIES 12,002 30,546 18,544 61% 2215-436-460430-121 OVERTIME 133 1,500 1,367 91% 2215-436-460430-153 HEALTH INSURANCE 19,876 54,803 34,927 64% 10/14/09 CITY OF KALISPELL Page 9 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- 2215-436-460430-155 RETIREMENT 4,487 1B,364 13,877 7694 2215-436-460430-210 OFFICE SUPPLIES 130 1,200 1,070 89% 2215-436-460430-213 SMALL OFFICE EQUIPMENT 0 800 800 100% 2215-436-460430-215 COMPUTER SUPPLIES 44 1,000 956 96% 2215-436-460430-221 SAFETY EQUIPMENT 60 950 890 94% 2215-436-460430-224 JANITORIAL SUPPLIES 1,529 3,000 1,471 49% 2215-436-460430-229 OTHER SUPPLIES 345 6,000 5,655 94% 2215-436-460430-241 CONSUMABLE TOOLS/SMALL EQUIPMENT 35 1,600 1,565 98% 2215-436-460430-320 PRINTING 0 456 456 100% 2215-436-460430-333 SUBSCRIPTIONS 209 250 41 16% 2215-436-460430-335 MEMBERSHIP & DUES 55 450 395 88% 2215-436-460430-337 ADVERTISING 0 500 500 100% 2215-436-460430-341 ELECTRICITY 7,529 14,250 6,721 47% 2215-436-460430-342 WATER/SEWER 0 400 400 100% 2215-436-460430-344 NATURAL GAS 176 3,200 3,024 95% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 844 3,000 2,156 72% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 5,000 5,000 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 0 3,000 3,000 100% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT MAINTENANCE 144 1,500 1,356 90% 2215-436-460430-364 LANDSCAPING 0 3,000 3,000 100% 2215-436-460430-366 BUILDING MAINTENANCE 8 4,000 3,992 100% 2215-436-460430-367 VANDALISM REPAIRS 151 4,000 3,849 96% 2215-436-460430-373 SCHOOL & TRAVEL 390 1,200 810 68% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 95 550 455 83% 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 METAL PRODUCTS/FENCING 0 1,500 1,500 100% 2215-436-460430-430 WOOD PRODUCTS/PICNIC TABLES 0 2,000 2,000 100% 2215-436-460430-440 IRRIGATION SUPPLIES 453 4,000 3,547 89% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 0 4,000 4,000 100% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 8,611 17,027 8,416 49% 2215-436-460430-620 DEBT SERVICE INTEREST 274 413 139 34% TOTAL PARKS EXPENDITURES ----------- 117,127 ----------- 459,032 --------------------- 341,905 74% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 11,079 46,179 35,100 76% 2215-436-460440-111 SEASONAL SALARIES 18,503 43,360 24,857 57% 2215-436-460440-153 HEALTH INSURANCE 4,401 13,204 8,803 67% 2215-436-460440-155 RETIREMENT 1,514 3,641 2,127 58% 2215-436-460440-221 SAFETY EQUIPMENT 0 175 175 100% 2215-436-460440-229 OTHER SUPPLIES 1,975 16,900 14,925 8B% 2215-436-460440-241 CONSUMABLE TOOLS 0 700 700 100% 2215-436-460440-335 MEMBERSHIP & DUES 0 135 135 100% 2215-436-460440-341 ELECTRICITY 0 3,413 3,413 100% 2215-436-460440-345 TELEPHONE & COMMUNICATION 92 350 258 74% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 140 500 360 72% 2215-436-460440-364 LANDSCAPING 0 2,000 2,000 100% 2215-436-460440-367 VANDALISM REPAIRS 0 300 300 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-420 METAL PRODUCTS 0 500 500 100% 2215-436-460440-440 IRRIGATION 1,278 3,000 1,722 57% 2215-436-460440-452 SAND & GRAVEL 7B ----------- 1,200 1,122 93% TOTAL ATHLETIC COMPLEX 39,061 ----------- 136,707 --------------------- 97,646 71% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 21,156 88,750 67,594 76% 2215-436-460431-111 SEASONAL SALARIES 7,160 13,704 6,544 48% 2215-436-460431-121 OVERTIME 0 500 500 100% 2215-436-460431-153 HEALTH INSURANCE 5,735 17,204 11,469 67% 2215-436-460431-155 RETIREMENT 1,316 5,475 4,159 76% 2215-436-460431-210 OFFICE SUPPLIES 130 600 470 78% 2215-436-460431-229 OTHER SUPPLIES 2,033 10,000 7,967 80% 2215-436-460431-320 PRINTING 0 6,000 6,000 100% 2215-436-460431-333 SUBSCRIPTIONS 0 100 100 100% 2215-436-460431-335 MEMBERSHIP & DUES 0 300 300 100% 10/14/09 CITY OF KALISPELL Page 10 Quarterly Finance Report 25% Yr Complete FUND FUND ------------------------- 2215-436-460431-337 ADVERTISING 2215-436-460431-345 TELEPHONE & COMMUNICATION 2215-436-460431-354 CONTRACT SERVICES 2215-436-460431-355 BANK FEES/CREDIT CARD FEES 2215-436-460431-373 SCHOOL & TRAVEL TOTAL RECREATION YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 2215-436-46044B-111 SEASONAL SALARIES 2215-436-460448-121 OVERTIME 2215-436-460448-153 HEALTH INSURANCE 2215-436-460448-155 RETIREMENT 2215-436-460448-210 OFFICE SUPPLIES 2215-436-460448-229 OTHER SUPPLIES 2215-436-460448-320 PRINTING 2215-436-460448-335 MEMBERSHIP & DUES 2215-436-460448-337 ADVERTISING 2215-436-460448-345 TELEPHONE & COMMUNICATION 2215-436-460448-354 CONTRACT SERVICES 2215-436-460448-355 AFTER SCHOOL PROGRAM 2215-436-460448-366 BUILDING MAINTENANCE 2215-436-460448-373 SCHOOL & TRAVEL TOTAL YOUTH CAMPS ICE RINK EXPENDITURES 2215-436-460450-111 SEASONAL SALPRIES 2215-436-460450-155 RETIREMENT 2215-436-460450-210 OFFICE SUPPLIES 2215-436-460450-229 OTHER SUPPLIES 2215-436-460450-341 CONSUMABLE TOOLS 2215-436-460450-343 UTILITIES 2215-436-460450-362 EQUIPMENT MAINTENANCE TOTAL ICE RINK POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 2215-437-460445-121 OVERTIME 2215-437-460445-155 RETIREMENT 2215-437-460445-210 OFFICE SUPPLIES 2215-437-460445-213 SMALL OFFICE EQUIPMENT 2215-437-460445-221 SAFETY EQUIPMENT/SUPPLIES 2215-437-460445-224 JANITORIAL SUPPLIES 2215-437-460445-226 CHLORINE/CHEMICALS 2215-437-460445-228 CONCESSION STAND SUPPLIES 2215-437-460445-229 OTHER SUPPLIES 2215-437-460445-241 CONSUMABLE TOOLS 2215-437-460445-320 PRINTING 2215-437-460445-341 ELECTRICITY 2215-437-460445-344 NATURAL GAS 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 2215-437-460445-354 LICENSES & FEES 2215-437-460445-362 EQUIPMENT MAINTENANCE 2215-437-460445-366 BUILDING MAINTENANCE 2215-437-460445-380 TRAINING MATERIALS TOTAL POOL EXPENDITURES TOTAL PARKS & RECREATION/POOL ACTUAL YTD BUDGET REMAINING % ----------------------------------------------- 0 500 500 100% 317 1,300 983 76% 14,825 25,000 10,175 41% 448 2,500 2,052 82% 247 1,200 953 79P6 ----------- 53,366 ----------- 173,133 --------------------- 119,767 69% 15,664 65,238 49,574 76% 39,932 68,749 48,817 55% 0 500 50D 100% 5,411 16,234 10,823 67% 971 5,244 4,273 81% 0 500 500 100% 735 6,000 5,265 88% 0 300 300 100% 0 300 300 100% 0 300 300 100% 0 600 600 100% 9,826 13,000 3,175 24% 301 4,000 3,699 92% 0 5,000 5,000 100% 0 ----------- 1,000 1,000 100% 72,839 ----------- 206,965 --------------------- 134,126 65% 0 15,349 15,349 100% 0 716 716 100% 0 50 50 100% 0 300 300 1009d 0 5,600 5,600 100% 0 20,000 20,000 100% 0 ------------- 2,600 2,600 100% 0 ----------- 44,615 --------------------- 44,615 100% 121,491 201,359 79,868 40% 890 500 390- -78% 1,327 1,266 61- -5% 172 500 328 66% 16 200 184 92% 0 200 200 100% 581 2,500 1,919 7796 17,588 16,500 1,188- -7% 14,640 18,500 3,960 21% 1,267 4,500 3,233 72% 0 400 400 100% 0 50 50 100% 4,673 12,500 7,827 6396 13,846 28,000 14,154 51% 247 1,500 1,253 84% 93 1,300 £,207 93% 1,305 4,000 2,695 67% 518 1,500 982 65% 0 ----------- 250 250 100% 178,755 ----------- 295,525 --------------------- 116,770 40% 461,148 1,315,977 854,829 65% 10/14/09 CITY OF KALISPELL Page 11 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -----------------------------------------------------------------------------------------------__-------- 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 68,068 765,000 696,932 91% 2230-000-342052-000 OUT OF CITY SURCHARGE 190 0 190- 0% 2230-000-342070-000 COUNTY EMS LEVY 0 90,000 90,000 100% TOTAL AMBULANCE REVENUE ----------- 68,258 ----------- 855,000 --------------------- 786,742 92% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 108,700 475,779 367,079 77% 2230-440-420730-113 KELLY DAYS 1,181 10,000 8,819 88% 2230-440-420730-121 OVERTIME 394 6,038 5,644 93% 2230-440-420730-153 HEALTH INSURANCE 25,917 79,149 53,232 67% 2230-440-420730-155 RETIREMENT 13,955 60,444 46,489 77% 2230-440-420730-210 OFFICE SUPPLIES 0 1,000 1,000 100% 2230-440-420730-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 2230-440-420730-215 COMPUTER SUPPLIES 198 2,000 1,802 90% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 36 2,000 1,964 98% 2230-440-420730-231 GAS AND OIL 1,990 10,000 8,010 80% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 0 5,000 5,000 100% 2230-440--420730-312 POSTAGE 705 3,000 2,295 77% 2230-440-420730-320 PRINTING 0 500 500 I00% 2230-440-420730-345 TELEPHONE & COMMUNICATION 277 700 423 60% 2230-440-420730-353 AUDITING 0 500 500 100% 2230-440-420730-354 CONTRACT SERVICES/RECERT. 531 8,000 7,469 93% 2230-440-420730-358 MT FF TESTING CONSORTIUM 0 500 500 100% 2230-440-420730-359 CC FEES/COLLECTION SERV. 196 500 304 61% 2230-440-420730-362 EQUIPMENT MAINTENANCE 82 3,500 3,418 98% 2230-440-420730-369 RADIO MAINTENANCE 0 2,500 2,500 100% 2230-440-420730-380 TRAINING MATERIALS 0 3,000 3,000 100% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 175 5,000 4,825 97% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 10,659 38,000 27,341 72% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 13,703 17,134 3,432 20% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 2,000 8,000 6,000 75% 2230-440-420730-522 ADMIN. TRANSFER 9,020 36,078 27,059 75% 2230--440-420730-528 DATA PROC. TRANSFER 2,786 11,145 8,359 75% 2230-440-420730-940 EQUIPMENT 0 7,500 7,500 100% 2230-440-420730-943 AMBULANCE 0 30,000 30,000 100% TOTAL AMBULANCE FUND ----------- 192,505 ----------- 827,167 ------------ ---------- 634,662 77% 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101--000 BUILDING PERMITS 36,898 150,000 113,102 75% 2394-000-323103-000 PLUMBING PERMITS 4,006 22,500 18,494 82% 2394-000-323104-000 MECHANICAL PERMITS 6,129 30,000 23,872 80% 2394-000-323107-000 HOUSE MOVING PERMITS 200 100 100- -100% 2394-000-323108-000 PLAN REVIEW FEES 7,780 120,000 112,220 94% 2394-000-371010-000 INVESTMENT EARNINGS 61 1,000 939 94% TOTAL REVENUE ----------- 55,074 ----------- 323,600 --------------------- 268,526 83% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 60,112 253,056 192,944 76% 2394-420-420530-112 SALARIES -SEVERANCE 0 2,500 2,500 100% 2394-420-420530-121 OVERTIME 318 2,000 1,682 84% 2394-420-420530-153 HEALTH INSURANCE 15,859 44,987 29,128 65% 2394-420-420530-155 RETIREMENT 3,784 15,993 12,209 76% 2394-420-420530-210 OFFICE SUPPLIES 0 2,000 2,000 100% 2394-420-420530-215 COMPUTER SUPPLIES 243- 3,500 3,743 107% 2394-420-420530-229 OTHER SUPPLIES 166 2,250 2,084 93% 2394-420-420530-231 GAS & OIL 308 2,500 2,192 88% 2394-420-420530-312 POSTAGE 1B2 600 418 70% 2394-420-420530-320 PRINTING 0 300 300 100% 2394-420-420530-322 BOOKS 59 2,250 2,191 97% 2394-420-420530-323 ST. £D. ASSESSMENTS 0 2,500 2,500 100% 2394-420-420530-331 PUBLICATION & FILING FEES 0 200 200 100% 10/14/09 CITY OF KALISPELL Quarterly Finance Report FUND FUND ACTUAL YTD BUDGET REMAINING % ------------------------------------------`------------------------------------------------------------------- 2394-420-420530-335 MEMBERSHIP fi DUES 100- 900 1,000 111% 2394-420-420530-345 TELEPHONE & COMMUNICATION 264 1,500 1,236 82% 2394-420-420530-353 AUDITING 0 3,000 3,000 100% 2394-420-420530-354 CONTRACT SERVICES 140 500 360 72% 2394-420-420530-366 BUILDING MAINTENANCE 0 800 800 100% 2394-420-420530-373 SCHOOL & TRAVEL 372 5,000 4,628 93% 2394-420-420530-510 PROPERTY INSURANCE 6,947 8,800 1,853 21% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 150 600 450 73% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 3,088 12,353 9,265 75% 2394-420-420530-528 DATA PROCESSING TRANSFER 1,045 4,179 3,134 75% TOTAL BUILDING DEPT. ----------- 92,451 ----------- 372,268 ----------- ----------- 279,817 75% 2399 IMPACT FEE FUND 2399-400-420100-355 5% ADMIN CHARGE 0 7,100 7,100 100% 2399-413-420140-354 IMPACT FEE REVIEW 0 500 500 100% 2399-413-420140-940 POLICE EQUIPMENT 0 20,000 20,000 100% 2399-416-420400-354 IMPACT FEE REVIEW 0 500 500 100% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 12,250 24,750 12,500 51% 2399-416-420400-620 INTEREST - FIRE TRUCK 5,406 10,310 4,904 48% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 165,000 165,000 100% TOTAL 2399 IMPACT FEE FUND ---------- - 17,656 ----------- 228,160 ----------- ---"------- 210,504 92% 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 6,092 30,182 24,090 80% 2400-410-430263-153 HEALTH INSURANCE 2,057 7,922 5,865 74% 2400-410-430263-155 RETIREMENT 379 1,833 1,454 79% 2400-410-430263-244 STREET LIGHT SUPPLIES 895 13,000 12,105 93% 2400-410-430263-341 ELECTRICITY 35,313 145,000 109,687 76% 2400-410-430263-360 REPAIR & MAINT SERVICES 235 28,000 27,765 99% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 1,919 7,677 5,758 75% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 0 14,000 14,000 100% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 0 560 560 100% TOTAL LIGHT MAINT. `---------- 46,890 ----------- 248,174 ----------- ---------- 201,284 81% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 23,849 44,000 20,151 46% 2420-421-430234-957 ALLEY PAVING 25,245 25,000 245- -1% 2420-421-430240-231 GAS & OIL 4,484 35,000 30,516 87% 2420-421-430240-344 NATURAL GAS 0 2,500 2,500 100% 2420-421-430240-354 CONTRACT SERVICES 50,000 100,000 50,000 50% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 17,000 17,000 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 154,859 250,000 95,141 38% 2420-421-430240-369 RADIO EQUIPMENT & MAINT. 0 700 700 100% 2420-421-430240-452 GRAVEL 0 4,000 4,000 100% 2420-421-430240-453 MATERIALS; CONTRACT PREP. 295 5,000 4,705 94% 2420-421-430240-471 DE-ICER/ROAD OIL 3,045 50,000 46,955 94% 2420-421-430240-472 ASPHALT 10,1135 25,000 14,815 59% 2420-421-430240-473 CRACK SEALING 150 5,000 4,850 97% 2420-421-430240-533 EQUIPMENT RENTAL 252 5,500 5,246 95% TOTAL GAS TAX ----------- 272,364 ----------- 568,700 --------------------- 296,336 52% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 124,780 574,524 449,744 78% 2500-421-430240-121 OVERTIME 4,031 30,000 25,969 87% 2500-421-430240-153 HEALTH INSURANCE 35,153 109,112 73,959 68% 2500-421-430240-155 RETIREMENT 8,007 35,243 27,236 77% 2500-421-430240-213 SMALL OFFICE EQUIPMENT 0 500 500 100% 2500-421-430240-216 COMPUTER EQUIPMEMT 0 1,850 1,850 100% 2500-421-430240-218 EQUIPMENT (NON CAPITAL) 0 1,000 1,000 100% 2500-421-430240-221 SAFETY EQUIPMENT 290 1,000 710 71% 2500-421-430240-224 JANITORIAL SUPPLIES 260 700 440 63% 2500-421-430240-229 OTHER SUPPLIES 247 1,200 953 79% Page 12 25% Yr Complete 10/14/09 CITY OF KALISPELL Page 13 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % --- -___-..--------------------------------------..__-------------------------------------------------------------- 2500-421-430240-231 GAS & OIL 4,484 40,000 35,516 89% 2500-421-430240-241 CONSUMABLE TOOLS 368 2,000 1,632 82% 2500-421-430240-341 ELECTRICITY 334 700 366 52% 2500-421-430240-342 WATER/SEWER CHARGES 36 150 114 76% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 237 1,200 963 80% 2500-421-430240-354 CONTRACT SERVICES 5,235 13,000 7,765 60% 2500-421-430240-355 CONTRACT SERV.-AERIAL MAPPING 127 13,000 12,873 99% 2500-421-430240-357 RATE STUDY 0 22,500 22,500 100% 2500-421-430240-358 IMPACT FEE STUDY 0 7,000 7,000 100% 2500-421-430240-362 EQUIP. MATNT./SUPPLIES 5,662 22,000 16,338 74% 2500-421-430240-366 BUILDING MAINTENANCE 25 1,500 1,475 98% 2500-421-430240-369 RADIO EQUIPMENT & MAINT. 145 5,000 4,855 97% 2500-421-430240-373 SCHOOL & TRAVEL 244 3,500 3,256 93% 2500-421-430240-388 MEDICAL SERVICES 303 900 590 66% 2500-421-430240-510 LIABILITY INSURANCE 65,037 66,000 963 1% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 2,096 16,500 14,404 87% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 15,750 63,000 47,250 75% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 12,585 50,339 37,754 75% 2500-421-430240-528 DATA PROCESSING TRANSFER 2,786 11,145 8,359 75% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 0 12,500 12,500 100% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 0 227 227 100% 2500-421-430240-840 MACI GRANT MATCH 0 30,000 30,000 100% 2500-421-430240-935 PAVEMENT MAINTENANCE funds 319,328 585,988 266,660 46% 2500-421-430240-940 MACHINERY & EQUIPMENT 0 170,000 170,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 15,000 70,000 55,000 79% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 6,296 37,337 31,041 83% 2500-421-430264-110 TSS - SALARIES 33,777 140,245 106,468 76% 2500-421-430264-121 OVERTIME 3,750 8,000 4,250 53% 2500-421-430264-153 HEALTH INSURANCE 5,657 19,722 14,065 71% 2500-421-430264-155 RETIREMENT 2,317 8,781 6,464 74% 2500-421-430264-216 COMPUTER EQUIP & SOFTWARE 107 1,500 1,393 93% 2500-421-430264-218 EQUIPMENT{non-capital} 0 3,600 3,600 100% 2500-421-430264-221 SAFETY EQUIPMENT & SUPPLIES 109 500 391 78% 2500-421-430264-224 JANITORIAL SUPPLIES 156 650 494 76% 2500-421-430264-229 OTHER SUPPLIES 214 800 586 73% 2500-421-430264-241 CONSUMABLE TOOLS 83 1,100 1,017 92% 2500-421-430264-242 STREET SIGNS 8,084 35,000 26,916 77% 2500-421-430264-243 TRAFFIC SIGNALS 0 10,000 10,000 100% 2500-421-430264-245 BARRICADE MATERIALS 483 4,000 3,517 88% 2500-421--430264-341 ELECTRICITY 1,887 11,000 9,113 83% 2500-421-430264-345 COMMUNICATIONS 173 800 627 78% 2500-421-430264-354 CONTRACT SERVICES 5,848 10,000 4,152 42% 2500-421-430264-362 EQUIPMENT MAINTENANCE 216 1,400 1,184 85% 2500-421-430264-366 BUILDING MAINTENANCE 549 1,500 951 63% 2500-421-430264-369 RADIO MAINTENANCE 0 900 900 100% 2500-421-430264-373 SCHOOL & TRAVEL 0 3,500 3,500 100% 2500-421-430264-428 PAINT MATERIALS 2,058 25,000 22,942 92% 2500-421-430264-51G LIABILITY INS.-TSS 5,205 5,775 570 10% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 1,000 1,OD0 100% 25GO-421-430264-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SPEC. ST. MAINT. ----------- 703,437 ----------- 2,303,226 ----------- -------_-- 1,599,789 69% 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 31,014 131,520 100,506 76% 2600-436-460433-121 OVERTIME 33 750 717 96% 2600-436-460433-153 HEALTH INSURANCE 7,546 25,066 17,520 70% 2600-436-460433-155 RETIREMENT 1,807 8,236 6,429 78% 2600-436-460433-210 OFFICE SUPPLIES 0 50 50 100% 2600-436-460433-229 OTHER SUPPLIES 9 500 491 98% 26OG-436-460433-241 CONSUMABLE TOOLS 0 450 450 100% 2600-436-460433-333 SUBSCRIPTIONS 0 50 50 100% 2600-436-460433-354 CONTRACT SERVICES 0 1,500 1,500 100% 2600-436-460433-357 FORESTRY GRANT 2,084 5,225 3,141 60% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 0 10,000 10,000 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 3 500 497 99% 2600-436-460433-364 LANDSCAPING & TREES 9,262 7,000 2,262- -32% 10/14/09 CITY OF KALISPELL Page 14 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- 2600-436-460433-373 SCHOOL & TRAVEL 0 250 250 100% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 4,192 4,945 753 15% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 625 2,500 1,875 75% 2600-436-460433-522 ADMIN. TRANSFER 1,703 6,813 5,110 75% 2600-436-460433-528 DATA PROCESSING TRANSFER 34B 1,393 1,045 75% TOTAL URBAN FORESTRY ----------- 58,627 ----------- 206,748 ---------------------- 148,121 72% 2880 COM DEV REVOLVING FUND 2880-480-470240-708 REDEVELOPMENT FUNDS -DISTRIBUTION 25,776 25,776 0 0% 2880-480-470240-711 IRP LOAN PROGRAM MATCH 11 150,000 149,989 100% 2880-480-470240-720 EAGLE TRANSIT 0 15,000 15,000 i00% TOTAL LOAN REVOLVING ----------- 25,787 ----------- 190,776 --------------------- 164,989 86% 2886 UDAG FUND 2886-480-470210-110 SALARIES - UDAG 13,798 94,669 80,871 85% 2886-480-47G210-153 HEALTH INSURANCE 2,096 12,662 10,566 83% 2886-480-470210-155 RETIREMENT 899 6,131 5,232 85% 2886-480-470210-210 OFFICE SUPPLIES 0 500 500 100% 2886-480-470210-211 GRANT ADMIN. EXPENSES 1 1,000 999 100% 2886-460-470210-212 PROJECT EXPENSES 65- 0 65 0% 2886-480-470210-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 2886-480-470210-215 COMPUTER SUPPLIES 245 1,000 755 76% 2886-480--470210-218 EQUIPMENT (non -capital} 0 300 300 100% 2886-480-470210-231 GAS & OIL 77 300 223 74% 2886-480-470210-312 POSTAGE 11 300 289 96% 2886-480-470210-320 PRINTING 440 6,000 5,560 93% 2886-480-470210-331 GRANT ACTIVITIES ADVERTISING 256 335 79 24% 2886-480-470210-334 MT WEST MEMBERSHIP 0 500 500 100% 2886-480-470210-335 MEMBERSHIP & DUES 0 700 700 100% 2886-480-470210-345 TELEPHONE & COMMUNICATION 74 750 676 90% 2886-480-470210-353 AUDITING 0 1,500 1,500 100% 2886-480-470210-354 CONTRACT SERVICES 0 1,000 1,000 I00% 2686-480-470210-355 PROSPECT DEVELOPMENT 0 3,000 3,000 100% 2B86-480-470210-363 OFFICE EQUIP MAINTENANCE 0 100 100 100% 2886-480-470210-373 SCHOOL & TRAVEL 753 3,000 2,248 75% 2886-480-470210-379 MEETINGS 80 500 420 84% 2886-480-470210-381 TRAINING 0 1,500 1,500 100% 2886-480-470210-396 STUDIES/SURVEYS 2,000 25,000 23,OG0 92% 2886-480-470210-510 PROPERTY & LIABILITY INS. 2,660 4,200 1,540 37% 2886-480-470210-521 CENTRAL GARAGE TRANSFER 125 500 375 75% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 2,613 10,451 7,838 75% 2886-480-470210-528 DATA PROCESSING TRANSFER 2,090 8,359 6,269 75% 2886-480-470210-532 OFFICE RENT 2,352 4,703 2,352 50% 2886-480-470210-710 LAND TRUST DONATION 0 18,000 18,000 100% 2886-480-470210-711 HISTORIC PRESERVATION PROJECT 1,000 19,000 18,000 95% 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 2,500 2,500 100% TOTAL UDAG FUND ----------- 31,502 ----------- 228,660 --------------------- 197,158 86% 10/14/09 CITY OF KALISPELL Page 15 Quarterly Finance Report 25% Yr Complete FUND FUND RURAL DEVELOPMENT REVOLVING 2887-480-470210-110 SALARIES 2887-480-470210-153 HEALTH INSURANCE 2887-480-470210-155 RETIREMENT 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 2887-480-470210-620 INTEREST EXPENSE/L#61-01 2887-480-470210-750 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT ACTUAL YTD BUDGET REMAINING % 7,946 38,307 30,361 79% 1,76B 6,060 4,293 71% 517 2,476 1,959 79% 0 17,046 17,046 100% 0 5,029 5,029 100% 39 ---------------------- 150,000 149,961 100% 10,269 218,91E --------------------- 208,649 95$ 2888 RURAL DEV. #2 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-02 0 2,575 2,575 100% 2888-4BO-470210-750 REDEVELOPMENT LOANS 0 45,000 45,000 100% ----------- TOTAL 2888 RURAL DEV. #2 0 ----------w-- 47,575 --------------------- 47,575 100% 2944 CDBG-ED FVCC 2944-480-470242-355 ADMIN CHARGE 0 3,42B 3,428 100% 2944-480-470242-780 TRANING COSTS-FVCC GRT 0 72,000 72,000 100% 2944-480-470242-790 MACHINERY/EQUIPMENT-FVCC GRT 0 6,090 6,090 100% ----------- TOTAL 2944 CDBG-ED FVCC 0 ----------- 81,518 --------------------- 81,518 100% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 0 58,162 58,162 100% 2916-413-420140-121 OVERTIME 0 11,000 11,000 100% 2916--413-420140-153 HEALTH INSURANCE 0 13,204 13,204 100% 2916-413-420140-155 RETIREMENT 0 7,838 7,838 1008 2916-413-420140-210 OFFICE SUPPLIES 0 400 400 100% 2916-413-420140-354 CONTRACT SERVICES 0 4,000 4,000 100% ----------- TOTAL 2916 DRUG ENFORCEMENT 0 ---------------------- 94,604 ---------- 94,604 100% 2917 COPS TECHNOLOGY GRANT 2917-413-420140-950 SHOOTING FACILITY 0 750,000 750,000 100% ----------- TOTAL 2917 COPS TECHNOLOGY GT ----------- 0 ----------- 750,000 ---------- 750,000 100% 2918 COPS HIRING RECOVERY GT 2918-413-420140-110 SALARIES & PAYROLL COSTS 0 51,388 51,388 100% 2918-413-420140-153 HEALTH INSURANCE 0 13,204 13,204 100% 2918-413-420140-155 RETIREMENT 0 6,655 6,655 100% ----------- TOTAL 2918 COPS HIRING GRANT ----------- 0 ------------ 71,247 ---------- 71,247 100% 2919 LAW ENFORCEMENT GRANT 2919--413-420140-110 SALARIES - DISPATCH 1,014 4,000 2,986 75% 2919-413-420140-125 DUI TASK FORCE 2,828 10,000 7,172 72% 2919-413-420140-126 HOLIDAY OT REIMB. 11,235 40,000 28,765 72% 2919-413-420140-127 SCHOOL DIST. OT 3,521 20,000 16,479 82% 2919-413-420140-155 RETIREMENT 1,690 4,000 2,310 58% 2919-413-420140-218 JAG GRANT- E Tickets Equip/supplies 0 37,095 37,095 100% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 635 5,000 4,365 97% 2919-413-420140-221 RIFLES FOR SWAT TEAM 0 5,600 5,600 100% 2919-413-420140-944 VEHICLES 0 35,500 35,500 100% ----------- TOTAL LAW ENF, GRANT ----------- 20,923 ----------- 161,195 ---------- 140,272 87% 2957 FEMA GRANT 2957-416-420400-110 SALARIES 120 10,000 9,880 99% 2957-416-420400-121 OVERTIME 0 15,000 15,000 100% 2957-416-420400-153 HEALTH INSURANCE 0 1,564 1,564 100% 10/14/09 CITY OF KALISPELL Quarterly Finance Report Page 16 25% Yr Complete FUND FUND --------------------------------------------------------- 2957-416-420400-155 RETIREMENT 2957-416-420400-218 EQUIPMENT (non capital) 2957-416-420400-221 SAFETY EQUIPMENT 2957-416-420400-229 HAZMAT REIMB.-MATERIALS 2957-416-420400-354 HAZ TECH TRN GRT/HMEP&CERCLA 34,000 2957-416-420400-373 TRAVEL - REIMBURSABLE 2957-416-420410-125 PASS THRU HAZMAT OT 2957-416-420410-218 PASS THRU HAZMAT EQUIP 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 2957-416-420413-940 AEG REGIONAL CAD SYSTEM 2957-416-420414-218 AEG EQUIPMENT AND SAFETY 2957-416-420415-940 HERITAGE PROGRAM GRANT 2957-416-420420-126 WILDLAND FIRE OT 2957-416-420450-940 MDOT GRANT RADIOS TOTAL FEMA GRANT 2975 ISTEA 2975-436-460457-950 WOODLAND CONNECTOR TOTAL ISTEA 2990 STIMULUS- ROADS 2990-421-430240-950 STIMULUS STREET CONSTRUCTION TOTAL 2990 STIMULUS - ROADS 2992 ENERGY BLOCK GRANT 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS TOTAL 2992 ENERGY BLOCK GRANT CAPITAL PROJECT FUNDS 4185 AIRPORT TIE BOND/LAND 4185-000-430300-354 BOND ISSUE COSTS 4185-000-430300-950 LAND ACQUISITION TOTAL 4185 AIRPORT TIF BOND/LD 4300 FAA NON -PRIMARY ENTITLMNT 4300-430-430310-354 TOWER MITIGATION TOTAL FAA NP ENTITLEMENT 4310 FAA LAND ACQUISITION 4310-430-430310-910 AIRPORT LAND ACQUISITION 4310-430-430310-940 AIRPORT CAPITAL IMPROVEMENTS TOTAL FAA LAND ACQ. ACTUAL YTD BUDGET 256 1,436 9,550 45,812 4,669 6,000 0 6,000 0 30,000 0 20,000 2,078 20,000 1,177 31,125 96 5,000 676,862 915,876 0 120,000 5,460 8,207 0 130,000 0 30,000 700,268 1,396,020 8,518 299,000 8,518 299,000 REMAINING % 1,180 82% 36,262 79% 1,331 22% 6,000 100% 30,000 100% 20,000 100% 17,922 90% 29,948 96% 4,904 98% 239,014 26% 120,000 100% 2,747 33% 130,000 100% 30,000 100% 695,752 50% 290,462 97% ------------------ 290,482 97% 0 ----------- 342,000 342,000 100% 0 ----------- 342,000 ---------------------- 342,000 100% 0 ----------- 96,700 96,700 100% 0 ----------- 96,700 ----------- ---------- 96,700 100% 0 30,000 30,000 100% 0 ----------- 1,970,000 ----------- 1,970,000 100% 0 2,000,000 --------------------- 2,000,000 100% 0 600,000 600,000 100% ----------- 0 ----------- 600,000 ---------------------- 600,000 100% 0 1,492,755 1,492,755 100% 0 ------------ 1,381,804 1,381,804 1005 0 ----------- 2,874,559 --------------------- 2,874,559 100% 10/14/09 CITY OF KALISPELL Quarterly Finance Report FUND FUND ACTUAL YTD BUDGET REMAINING % -----------------------------------------------------------------------------------------___------------------ ENTERPRISE FUNDS WATER REVENUE 5210-000-343210-000 METERED WATER SALES 994,363 2,400,000 1,405,637 59% 5210-000-343220-000 UNMETERED WATER SALES 1,587 4,000 2,413 60% 5210-000-343225-000 IMPACT FEES 74,139 300,000 225,861 75% 5210-000-343230-000 METER REPLACEMENT FEE 25,569 90,000 64,431 72% 5210-000-343260-000 INSTALL/SALE OF MAT./'POWER RENT/OTH 7,221 25,000 17,779 71% 5210-000-343270-000 WATER TURN ON FEES 1,125 3,000 1,875 63% 5210-000-343275-000 TAG FEE 4,120 18,000 13,880 77% 521G-000-371010-000 INVESTMENT EARNINGS 10,222 ----------- 90,000 79,778 89% TOTAL WATER REVENUE 1,118,346 ----------- 2,930,000 --------------------- 1,811,654 62% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 168,548 717,372 548,824 77% 5210-447-430550-121 OVERTIME 4,054 20,500 16,446 80% 5210-447-430550-153 HEALTH INSURANCE 46,328 156,754 110,426 70% 5210-447-430550-155 RETIREMENT 10,776 45,079 34,303 76% 5210-447-430550-210 OFFICE SUPPLIES 146 400 254 63% 5210-447-430550-213 SMALL OFFICE EQUIPMENT 0 1,000 1,000 100% 5210-447-430550-214 GIS SUPPLIES 13 5,000 4,987 100% 5210-447-430550-215 COMPUTER SUPPLIES 4,162 3,000 1,162- -39% 5210-447-430550-216 COMPUTER EQUIPMENT 139 5,000 4,861 97% 5210-447-430550-218 EQUIPMENT (NON CAPITAL) 468 8,475 8,007 94% 5210-447-430550-221 SAFETY EQUIP & SUPPLIES 260 2,500 2,240 90% 5210-447-430550-224 JANITORIAL SUPPLIES 190 800 610 76% 5210-447-430550-226 CHLORINE & CHEMICALS 8,036 25,000 16,965 68% 5210-447-430550-229 OTHER SUPPLIES 499 1,500 1,001 67% 5210-447-430550-231 GAS & OIL 5,475 38,000 32,525 86% 5210-447-430550-241 CONSUMABLE TOOLS 1,037 2,500 1,463 59% 521G-447-430550-312 POSTAGE 179 2,500 2,321 93% 5210-447-430550-320 PRINTING 3,912 2,000 1,912- -96% 5210-447-430550-335 MEMBERSHIP & DUES 220 1,200 980 82% 5210-447-430550-336 LICENSES & FEES 53 19,000 18,947 100% 5210-447-430550-341 ELECTRICITY 51,301 142,000 90,699 64% 5210-447-430550-342 WATER 48 500 452 90% 5210-447-430550-344 NATURAL GAS 437 16,000 15,563 97% 5210-447-430550-345 TELEPHONE & COMMUNICATION 1,987 8,000 6,013 75% 5210-447-430550-349 LAB SERVICES 3,701 35,500 31,793 90% 5210-447-430550-353 AUDITING 0 3,000 3,000 100% 5210-447-430550-354 CONTRACT SERVICES 13,895 65,000 51,105 79% 5210-447-430550-355 CONTRACT SERV.-AERIAL MAPPING 0 3,000 3,000 100% 5210-447-430550-356 WTR RIGHTS UPDATE/WTRSHED CONTROL P 3,557 35,000 31,443 90% 5210-447-430550-357 RATE STUDY 0 10,000 10,000 100% 5210-447-430550-358 IMPACT FEE REVIEW 0 5,000 5,000 100% 5210-447-430550-360 REPAIR & MAINT SERVICES 0 7,000 7,000 100% 5210-447-430550-362 EQUIPMENT MAINTENANCE 415 4,000 3,585 90% 5210-447-430550-363 OFFICE EQUIP MAINTENANCE 0 200 200 100% 5210-447-430550-366 BUILDING MAINTENANCE 630 20,000 19,370 97% 5210-447-430550-369 RADIO EQUIPMENT & MAINT. 0 2,450 2,450 100% 5210-447-430550-373 SCHOOL & TRAVEL 1,104 6,500 5,396 83% 5210-447-430550-380 TRAINING MATERIALS 0 500 500 100% 5210-447-430550-388 MEDICAL SERVICES 123 800 673 85% 5210-447-430550-395 RENTAL EQUIPMENT 0 1,500 1,500 10G% 5210-447-430550-410 CONSTRUCTION MATERIALS 3,594 30,000 26,406 88% 521G-447-430550-422 HYDRANTS 78 34,000 33,922 100% 5210-447-430550-423 MATERIALS FOR MAINS 201 12,000 11,799 98% 5210-447-430550-424 MATERIALS -SERVICE LINES 2,832 8,000 5,168 65% 5210-447-430550-425 MATERIALS PUMPS/LIFT ST. 3,809 36,000 32,191 89% 5210-447-430550-510 PROPERTY & LIABILITY INS. 36,169 38,000 1,831 5% 5210-447-430550-512 UNINSURED LOSS-➢EDUCTIBLE 288- 4,000 4,268 10794 5210-447-430550-513 UNINSURED LOSS -GOODWILL 0 7,500 7,500 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 2,125 8,500 6,375 75% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 22,539 90,156 67,617 75% 5210-447-430550-528 DATA PROCESSING TRANSFER 5,224 20,897 15,673 75% 5210-447-430550-532 LEASE PAYMENTS 3,919 7,B38 3,919 50% Page 17 25% Yr Complete 10/14/09 CITY OF KALISPELL Page 18 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 5210-447-430550-810 BAD DEBT EXPENSE 0 1,500 1,500 100% 5210-447-430550-940 MACHINERY & EQUIPMENT 0 55,000 55,000 100% 5210-447-430550-948 METERS (METER FUNDS) 28,086 105,000 76,914 73% 5210-447-430550-950 11TH ST E WATER MAIN 0 156,000 156,000 IGO% 5210-447-430550-951 SECURITY SYSTEM UPGRADES 0 32,000 32,000 100% 5210-447-430550-954 US 93 S BYPASS -UTILITY RELOCATE 21,816 30,560 8,744 29% 5210-447-430550-956 UPPER/LOWER INTERCONNECTION 31,122 40,000 8,878 22% 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 0 335,000 335,000 100% 5210-447-430550-961 UPSIZE MAIN-E AZ & 1ST AVE EN 0 195,000 195,000 100% 5210-447-430550-962 UPSIZE MAIN -1ST AVE E&IDAHO 0 35,000 35,000 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 100,000 100,000 100% 5210-447-430555-941 METERS (NEW SERVICES) 27,751 65,000 37,249 57% 5210-447-430555-953 SECTION 36 WELL 0 ----------- 75,OOO 75,000 100% TOTAL WATER FACILITIES 520,674 ----------- ----------- 2,945,481 ----------- --------------------- 2,424,807 ----------- ---------- 82% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 17,407 91,459 74,052 81% 5210-447-430560-153 HEALTH INSURANCE 4,536 23,486 18,950 81% 5210-447-430560-155 RETIREMENT 1,120 5,891 4,771 BI% 5210-447-430560-210 OFFICE SUPPLIES 5 50O 495 99% 5210-447-430560-218 EQUIPMENT - NOT CAPITAL 71 3,000 2,929 98% 5210-447-430560-335 MEMBERSHIP & DUES 38 350 313 89% 5210-447-430560-353 AUDITING 0 1,500 1,500 100% 5210-447-430560-354 CONTRACT SERVICES 1,726 7,500 5,774 77% 5210--447-430560-355 BILLING COSTS 6,952 25,000 18,048 72% 5210-447-430560-373 SCHOOL & TRAVEL 336 1,200 864 72% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 1,543 6,173 4,630 75% 5210-447-430560-528 DATA PROCESSING TRANSFER 5,724 22,897 17,173 75% 5210-447-430560-532 RENT 3,919 ----------- 7,838 3,919 50% TOTAL WATER BILLING 43,377 ----------- ----------- 196,794 ----------- ----------- ---------- 153,417 --------------------- 76% REVENUE BONDS 5210-447-490204-610 2004 BOND PRINCIPAL (HWY93) 0 140,000 140,000 100% 5210-447-490204-620 2004 BOND INTEREST (HWY93) 51,533 51,535 3 Oak 5210-447-490204-630 2004 BOND FISCAL AGENT FEES 300 350 50 10 5210-447-490206-610 2007 BOND PRIN WRF 3.75% 0 173,000 173,000 100% 5210-447-490206-620 2007 BOND INT WRF 3.75% 89,963 89,970 8 0% 5210-447-490206-630 2007 BOND ISSUE COSTS 0 700 700 100% 5210-447-490250-610 SRF 2001 PRINCIPAL 4% 0 36,000 36,000 100% 5210-447-490250-620 SRF 2001 INTEREST 4% 20,320 20,350 30 0% TOTAL REVENUE BONDS ----------- 162,115 ----------- 511,905 --------------------- 349,790 689; DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 ----------- 700,000 700,000 100� TOTAL DEPRECIATION 0 ----------- 700,000 ----------- ---------- 700,000 100% TOTAL WATER FUND 726,166 4,354,180 3,628,014 83% 10/14/09 CITY OF KALISPELL Page 19 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % '------------------------------------------------------------------------------`------------------------- SEWER REVENUE: 5310-000-343310-000 SEWER SERVICE CHARGES 905,640 3,450,000 2,544,360 74% 5310-000-343330-000 IMPACT FEES (SANITARY) 39,005 175,000 135,995 78% 5310-000-343335-000 IMPACT FEES (WWTP) 52,596 246,000 193,404 79% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 137 1,000 863 86% 5310-000-343365-000 LATECOMER ADMIN FEES 0 850 850 100% 5310-000-371010-000 INVESTMENT EARNINGS 17,384 165,000 147,616 89% TOTAL SEWER REVENUE ----------- 1,014,763 ----------- 4,037,850 ----------- ---------- 3,023,087 75% EXPENDITURES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 21,266 75,236 53,970 72% 5310-454-430620-153 HEALTH INSURANCE 5,978 17,935 11,957 67% 5310-454-430620-155 RETIREMENT 1,373 4,792 3,419 71% 5310-454-430620-215 OFFICE SUPPLIES/FURNITURE 0 1,000 1,000 100% 5310-454-430620-218 COMPUTERS/SUPPLIES 71 1,500 1,429 95% 5310-454-430620-335 MEMBERSHIP & DUES 38 300 263 88% 5310-454-430620-353 AUDITING 0 1,500 1,500 100% 5310-454-430620-354 CONTRACT SERVICES 398 7,500 7,103 95% 5310-454-430620-355 BILLING COSTS 8,229 24,000 15,771 66% 5310-454-430620-373 SCHOOL & TRAVEL 335 1,000 665 67% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 1,721 6,884 5,163 75% 5310-454-430620-528 DATA PROCESSING TRANSFER 5,724 22,897 17,173 75% 5310-454-430620-532 OFFICE RENT 3,919 ----------- 7,838 3,919 50% TOTAL SEWER BILLING COSTS 49,051 ----------- 172,382 --------------------- 123,331 72% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 82,597 364,781 282,184 77% 5310-454-430630-121 OVERTIME 1,616 6,500 4,884 75% 5310-454-430630-153 HEALTH INSURANCE 20,754 68,379 47,625 70% 5310-454-430630-155 RETIREMENT 5,290 22,597 17,307 77% 5310-454-430630-210 OFFICE SUPPLIES 35 450 415 92% 5310-454-430630-213 SMALL OFFICE EQUIPMENT 0 500 500 100% 5310-454-430630-214 GIS SUPPLIES 13 2,000 1,987 99% 5310-454-430630-215 COMPUTER SUPPLIES 1,700 2,000 300 15% 5310-454-430630-216 COMPUTER EQUIPMEMT 0 2,500 2,500 100% 5310-454-430630-218 EQUIPMENT (NON CAPITAL) 0 5,500 5,500 100% 5310-454-430630-221 SAFETY EQUIP & SUPPLIES 604 900 296 33% 5310-454-430630-224 JANITORIAL SUPPLIES 193 600 407 68% 5310-454-430630-229 OTHER SUPPLIES 140 800 660 82% 5310-454-430630-231 GAS & OIL 1,833 14,500 12,667 87% 5310-454-430630-241 CONSUMABLE TOOLS 533 1,200 667 56% 5310-454-430630-312 POSTAGE 0 750 750 100% 5310-454-430630-336 LICENSES & FEES 0 450 450 100% 5310-454-430630-341 ELECTRICITY 8,222 36,000 27,778 77% 5310-454-430630-342 WATER 40 175 135 77% 5310-454-430630-344 NATURAL GAS 2,563 12,500 9,937 79% 5310-454-430630-345 TELEPHONE & COMMUNICATION 5,373 20,500 15,127 74% 5310-454-430630-353 AUDITING 0 2,000 2,000 100% 5310-454-430630-354 CONTRACT SERVICES 4,324 22,100 17,776 80% 5310-454-430630-355 CONTRACT SERVICES -AERIAL MAPPING 0 3,000 3,000 100% 5310-454-430630-356 CONSULTANTS 0 15,000 15,000 100% 5310-454-430630-357 RATE STUDY FY09/FACILITY PLAN FY08 0 12,500 12,500 100% 5310-454-430630-358 IMPACT FEE REVIEW 0 5,000 5,000 100% 5310-454-430630-362 EQUIPMENT MAINTENANCE 1,097 7,BOO 6,703 86% 5310-454-430630-366 BUILDING MAINTENANCE 0 1,000 1,000 100% 5310-454-430630-369 RADIO EQUIPMENT & MAINT. 0 1,000 1,000 100% 5310-454-430630-373 SCHOOL & TRAVEL 357 3,000 2,644 88% 5310-454-430630-388 MEDICAL SERVICES 139 800 661 83% 5310-454-430630-410 CONSTRUCTION MATERIALS 5,197 10,000 4,803 4B% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 2,657 14,500 11,843 82% 5310-454-430630-510 PROPERTY & LIABILITY INS. 25,027 28,500 3,473 12% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 2,749 18,000 15,251 85% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 750 3,000 2,250 75% 10/14/09 CITY OF KALISPELL Page 20 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -----------------------------------------------------------------------'--------------------------------- 5310-454-430630-522 ADMINISTRATIVE TRANSFER 13,693 54,771 41,078 75it 5310-454-430630-528 DATA PROCESSING TRANSFER 3,831 15,325 11,494 75% 5310-454-430630-532 OFFICE RENT 3,919 7,838 3,919 50% 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 3,927 25,000 21,073 84% 5310-454-430630-810 BAD DEBT EXPENSE 0 945 945 100% 5310-454-430630-940 MACHINERY & EQUIPMENT 34- 0 34 0% 5310-454-430630-954 US 93 S BYPASS -UTILITY RELOCATE 9,802 13,400 3,598 27% TOTAL SANITARY SEWER/COLLECTIO ----------- 206,942 ----------- ----------- 828,061 ----------- --------------------- 619,119 --------------------- 75% SANITARY SEWER REPLACEMENT $ 5310-454-430633-952 MANHOLE REHAB 10,000 10,000 0 0% 5310-454-430633-956 REPLACE PUMPS-COTTONWD LIFT ST.#28 0 20,000 20,000 100% 5310-454-430633-960 REPLACEMENT PUMP FOR IS 410 0 10,000 10,000 100% TOTAL REPLACEMENT $ ----------- 10,000 ------------ ----------- 40,000 ----------- --------------------- 30,000 ---------------------- 75% SANITARY SEWER PLANT INVEST $ 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 0 75,832 75,832 100% 5310-454-430635-957 GRANDVIEW PUMP STA/GRAVITY MAIN 52% 232,501 500,000 367,499 74% TOTAL SANITARY SEWER PLANT INV ----------- 132,501 ----------- 575,832 --------------------- 443,331 77% REVENUE BONDS/SANITARY 5310-454-490204-610 PRINCIPAL-2004 BONDS)HWY 93 S) 0 61,000 61,000 100% 5310-454-490204-620 INTEREST-2004 BONDS 44,400 44,400 0 0% 5310-454-490204-630 FISCAL AGENT FEES 0 300 300 100% TOTAL REVENUE BONDS ----------- 44,400 ----------- ----------- 105,700 ----------- --------------------- 61,300 --------------------- 58% DEPRECIATION-SANITARY SEWER 5310-454-510400--831 DEPRECIATION EXPENSE 0 ----------- 500,000 500,000 100% TOTAL DEPRECIATION -SANITARY 0 ----------- 500,000 ----------- ---------- 500,000 100% TOTAL SANITARY SEWER 395,844 2,049,593 1,653,749 81% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 90,855 400,679 309,824 77% 5310-455-430640-121 OVERTIME 4,385 20,000 15,615 78% 5310-455-430640-153 HEALTH INSURANCE 21,638 68,415 46,777 68% 5310-455-430640-155 RETIREMENT 5,964 24,751 18,787 76% 5310-455-430640-210 OFFICE SUPPLIES 484 1,000 516 521 5310-455-430640-213 SMALL OFFICE EQUIPMENT 828 500 328- -66% 5310-455-430640-215 COMPUTER SUPPLIES 344 500 156 31% 5310-455-430640-216 COMPUTER EQUIPMEMT 0 1,500 1,500 100% 5310-455-430640-221 SAFETY EQUIP & SUPPLIES 0 2,500 2,500 100% 5310-455-430640-222 LABORATORY SUPPLIES 944 0 944- 0% 5310-455-430640-224 JANITORIAL SUPPLIES 0 250 250 100% 5310-455-430640-225 ALUM 4,902 70,000 65,098 93% 5310-455-430640-226 CHLORINE & CHEMICALS 0 12,500 12,500 100% 5310-455-430640-229 OTHER SUPPLIES 1,487 4,000 2,513 63% 5310-455-430640-231 GAS & OIL 1,866 14,000 12,134 87% 5310-455-430640-241 CONSUMABLE TOOLS 225 1,000 775 77% 5310-455-430640-312 POSTAGE 64 500 436 87% 5310-455-430640-335 MEMBERSHIP & DUES 250 1,200 950 79% 5310-455-430640-336 LICENSES & FEES 363 7,500 7,137 95% 5310-455-430640-341 ELECTRICITY 45,138 235,000 189,862 81% 5310-455-430640-342 WATER 858 8,500 7,642 90% 5310-455-430640-344 NATURAL GAS 1,134 65,000 63,866 98% 5310-455-430640-345 TELEPHONE & COMMUNICATION 1,241 6,000 4,759 79% 5310-455-430640-353 AUDITING 0 2,750 2,750 100% 10/14/09 CITY OF KALISPELL Page 21 Quarterly Finance Report 25% Yr Complete FUND FUND 5310-455-430640-354 CONTRACT -GLACIER GOLD 5310-455-430640-355 OTHER CONTRACT SERVICES 5310-455-430640-356 CONSULTANTS 5310-455-430640-357 WWTP RATE STUDY 5310-455-430640-358 CONSULTANT-TMDL 5310-455-430640-360 REPAIR & MAINT SERVICES 5310-455-430640-366 BUILDING MAINTENANCE 5310-455-430640-373 SCHOOL & TRAVEL 5310-455-430640-380 TRAINING MATERIALS 5310-455-430640-388 MEDICAL SERVICES 5310-455-430640-395 RENTAL EQUIPMENT 5310-455-430640-510 PROPERTY & LIABILITY INS 5310-455-430640-521 CENTRAL GARAGE TRANSFER 5310-455-430640-522 ADMINISTRATIVE TRANSFER 5310-455-430640-528 DATA PROCESSING TRANSFER TOTAL WWTP OPERATIONS WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 5310-455-430645-940 MACHINERY & EQUIPMENT TOTAL WWTP REPLACEMENT WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 5310-455-430646-121 OVERTIME 5310-455-430646-153 HEALTH INSURANCE 5310-455-430646-155 RETIREMENT 5310-455-430646-210 OFFICE SUPPLIES 5310-455-430646-215 COMPUTER SUPPLIES & SUPPORT 5310-455-430646-218 NON -CAPITAL EQUIPMENT 5310-455-430646-222 LAB SUPPLIES 5310-455-430646-224 JANITORIAL SUPPLIES 5310-455-430646-229 OTHER SUPPLIES 5310-455-430646-312 POSTAGE & SHIPPING 5310-455-430646-335 MEMBERSHIP & DUES 5310-455-430646-336 LICENSES & FEES 5310-455-430646-345 TELEPHONE & ALARMS 5310-455-430646-349 LAB SERVICES 5310-455-430646-362 EQUIPMENT MAINTENANCE 5310-455-430646-373 SCHOOL & TRAVEL 5310-455-430646-380 TRAINING MATERIALS TOTAL WWTP LAB OPERATIONS REVENUE BONDS/WWTP 5310-455-490210-610 DEBT-2002 ISSUE -PRINCIPAL 5310-455-490210-620 DEBT-2002 INTEREST 5310-455-490210-630 FISCAL AGENT FEES-2002 BONDS TOTAL REVENUE BONDS/WWTP SRF LOAN/WWTP 5310-455-490215-610 DEBT SRF 92003-PRINCIPAL 5310-455-490215-620 DEBT SRF 92003-INTEREST TOTAL SRF LOAN/WWTP DEBT SERVICE SRF -new constr. 5310-455-490227-610 SRF 2007WWTP PRINCIPAL 5310-455-490227-620 SRF 2007WWTP INTEREST SUBTOTAL SRF 2007 TOTAL WWTP DEBT ACTUAL YTD BUDGET REMAINING B 27,620 130,000 102,380 79% 7,305 45,000 37,695 84% 1,173 25,000 23,827 95% 0 12,500 12,500 100% 0 25,000 25,000 100% 0 15,000 15,000 100% 650 2,500 1,850 74% 2,066 14,000 11,934 85% 0 500 500 100% 48 700 653 93% 0 1,000 1,000 100% 46,941 56,500 9,559 17% 1,000 4,000 3,000 75% 23,807 95,228 71,421 75% 4,876 ----------- 19,504 14,628 75% 298,457 ----------- ----------- 1,394,477 ----------- --------------------- 1,096,020 --------------------- 79% 7,804 60,000 52,196 87% 0 ----------- 73,000 ----------- 73,000 100% 7,804 ------------ 133,000 ----------- --------------------- 125,196 --------------------- 94% 30,513 126,206 95,693 76% 0 300 300 100% 5,901 21,295 15,394 72% 1,916 7,795 5,979 75% 0 100 100 100% 0 50 50 100% 5,224 5,400 176 3% 3,097 7,500 4,403 59% 0 50 50 100% 0 200 200 100% 0 1,200 1,200 100% 0 100 100 100% 0 200 200 100W 0 50 50 100% 8,193 20,000 11,808 59% 558 1,500 942 63% 615 4,000 3,385 85% 0 ---------- 200 200 100% 56,016 ----------- 196,146 --------------------- 140,130 71% 0 220,000 220,000 100% 18,230 18,230 0 0% 0 ----------- 300 300 100% 18,230 ----------- ----------- 238,530 ----------- --------------------- 220,300 --------------------- 92% 0 250,000 250,000 100% 34,400 ----------- 34,400 0 0% 34,400 ----------- ----------- 284,400 ----------- --------------------- 250,000 --------------------- 88% 0 207,000 207,000 100% 519,638 520,000 363 0% ----------- 519,638 ----------- ----------- 727,000 --------------------- 207,363 29% 572,268 ----------- 1,249,930 --------------------- 677,663 54% 10/14/09 CITY OF KALISPELL Quarterly Finance Report Page 22 25� Yr Complete I4gj-,T] FOND ACTUAL YTD BUDGET REMAINING % DEPRECIATION 5310-455-510400-831 ➢EPRECIATION EXPENSE TOTAL DEPRECIATION TOTAL, WWTP TOTAL BILLING/SANITARY/WWTP ---'-------- 0 ----------- ---------- 419,375 --------------------- 419,375 100% 0 ----------- ----------- 419,375 ----------- ------------------_-- 419,375 --------------------- 100% 934,544 3,392,928 2,458,384 72% 1,379,439 5,614,903 4,235,464 75% 10/14/09 CITY OF KALISPELL Quarterly Finance Report FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- STORM SEWER REVENUE 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 11,217 5,000 6,217- -124% 5349-000-343033-000 IMPACT FEES 138,100 200,000 61,900 31% 5349-000-343034-000 PERMIT FEES 255 1,800 1,545 86% 5349-000-343035-000 STORM SEWER CHARGES 965 1,000 35 4% 5349-000-343370-000 STORM SEWER ASSESSMENTS 0 775,000 775,000 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 939 2,500 1,561 62% 5349-000-371010-000 INTEREST ON INVESTMENTS 4,429 30,000 25,571 851% TOTAL STORM REVENUE ----------- 155,906 ----------- 1,015,300 ----------- ---------- 859,394 8596 STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 76,195 342,098 265,903 78% 5349-453-430246-121 OVERTIME 957 4,500 3,543 79% 5349-453-430246-153 HEALTH INSURANCE 18,375 65,457 47,082 72% 5349-453-430246-155 RETIREMENT 4,892 21,412 16,520 77% 5349-453-430246-210 OFFICE SUPPLIES/EQUIPMENT 0 1,200 1,200 100% 5349-453-430246-214 GIS SUPPLIES 13 3,000 2,987 100% 5349-453-430246-215 COMPUTER SUPPLIES 4,161 4,000 161- -4% 5349-453-430246-215 COMPUTER EQUIPMEMT 0 3,000 3,000 100% 5349-453-430246-218 EQUIPMENT -NON CAPITAL 0 2,200 2,200 100% 5349-453-430246-221 SAFETY EQUIP & SUPPLIES 109 1,000 891 89% 5349-453-430246--229 OTHER SUPPLIES 42 1,200 1,158 97% 5349-453-430246-231 GAS & OIL 1,833 13,500 11,667 86% 5349-453-430246-241 CONSUMABLE TOOLS 0 1,000 1,000 100% 5349-453-430246-320 PRINTING 0 200 200 100% 5349-453-430246-345 TELEPHONE & COMMUNICATION 203 700 497 71% 5349-453-430246-353 AUDITING 0 600 600 100% 5349-453-430246-354 CONTRACT SERVICE 2,451 2,000 451- -23% 5349-453-430246-355 CONTRACT SERV.-AERIAL MAPPING 0 3,000 3,000 100% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 149 12,500 12,351 99% 5349-453-430246-357 RATE STUDY 0 22,500 22,500 100% 5349-453-430246-358 IMPACT STUDY 0 5,000 5,000 100% 5349-453-430246-359 CONSULTANTS-TMDL 0 25,000 25,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 385 1,200 815 68% 5349-453-430246--362 GROUNDWATER MONITORING 9,139 27,000 17,861 66% 5349-453-430246-371 CURB & GUTTER 1,164 5,000 3,836 77% 5349-453-430246-373 SCHOOL & TRAVEL 356 4,500 4,145 92% 5349-453-430246-388 MEDICAL SERVICES 0 250 250 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 34 10,000 9,966 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 9,282 10,000 718 7% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 625 2,500 1,875 75% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 8,212 32,848 24,636 75% 5349-453-430246.528 DATA PROCESSING TRANSFER 1,393 5,573 4,180 75% 5349-453-430246-530 BNSF LEASE PMT 0 4,200 4,200 100% 5349-453-430246--532 LEASE PAYMENTS 7,019 7,838 819 1096 5349-453-430246-952 STORM DRAIN CORRECTION 15,000 132,518 117,515 89% 5349-453-430246-954 S MEADOWS SURVEY 0 10,000 10,000 100% 5349-453-430246-958 STILLWTR/WILLOW GLEN CONST 44,830 80,000 35,170 44% 5349-453-430248-958 STILLWATER/WILLOW GLEN CONST 106,319 380,000 273,601 72% 5349-453-430248-959 SE STORM DRAIN IMP. PH I 162,414 170,000 7,586 4% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 30,000 30,000 10096 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 225,000 225,000 100% TOTAL STORM ----------- 475,552 ----------- 1,673,494 ----------- ------------ 1,197,942 72% Page 23 25% Yr Complete 10/14/09 FUND 5510-000-343410-000 5510-000-363040-000 5510-000-371010-000 5510-460-430840-110 5510-460-430840-121 5510-460-430840-153 5510-460-430840-155 5510-460-430840-213 5510-460-430840-216 5510-460-430840-218 5510-460-430840-221 5510-460-430840-224 5510-460-430840-229 5510-460-430840-231 5510-460-430840-241 5510-460-430940-341 5510-460-430840-344 5510-460-430840-345 5510-460-430640-354 5510-460-430840-362 5510-460-430840-366 5510-460-430840-369 5510-460-430840-373 5510-460-430840-388 5510-460-430840-510 5510-460-430940-512 5510-460-430840-521 5510-460-430840-522 5510-460-430840-528 5510-460-430840-532 5510-460-430845-224 5510-460-430845-341 5510-460-430845-342 5510-460-43GB45-344 5510-460-430845-360 5510-460-430845-366 5510-460-510400-831 CITY OF KALISPEI,L Quarterly Finance Report FUND -- SOLID WASTE REVENUE: GARBAGE COLLECTION PEN & INT ON SPEC ASSESS. INVESTMENT EARNINGS TOTAL SOLID WASTE REVENUE SOLID WASTE EXPENSES: SALARIES -SOLID WASTE OVERTIME HEALTH INSURANCE RETIREMENT SMALL OFFICE EQUIPMENT COMPUTER EQUIPMEMT EQUIPMENT -NOT CAPITAL SAFETY EQUIP & SUPPLIES JANITORIAL SUPPLIES OTHER SUPPLIES GAS & OIL CONSUMABLE TOOLS ELECTRICITY NATURAL GAS TELEPHONE & COMMUNICATION CONTRACT SERVICES EQUIPMENT MINT & SUPPLIES BUILDING MAINTENANCE RADIO EQUIPMENT & MAINT. SCHOOL & TRAVEL MEDICAL SERVICES PROPERTY & LIABILITY INS. UNINSURED LOSS -DEDUCTIBLE CENTRAL GARAGE TRANSFER ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER OFFICE RENT JANITORIAL SUPPLIES ELECTRICITY WATER NATURAL GAS REPAIR & MAINT SERVICES BUILDING MAINTENANCE DEPRECIATION EXPENSE TOTAL SOLID WASTE EXPENSE ACTUAL YTD BUDGET REMAINING % 81 775,000 774,919 100% 860 3,500 2,640 75% 380 3,500 3,120 89% --------- 1,322 ------------ 782,000 --------------------- 780,679 100% 86,023 381,964 295,941 77% 265 9,500 9,235 97% 21,581 68,729 47,148 69% 5,398 23,609 18,211 77% 40 500 460 92% 0 2,500 2,500 100% 0 25,000 25,000 100% 246 1,500 1,254 84% 156 400 244 61% 192 2,000 1,808 90% 7,663 47,800 39,937 84% 14 1,500 1,486 99% 232 1,600 1,368 B5% 69 8,000 7,931 9996 157 700 543 78% 1,335 12,000 10,665 89% 128 4,750 4,622 97% 96 2,500 2,404 96% 0 1,700 1,700 100% 156 3,500 3,345 96% 75 550 475 86% 13,749 14,500 751 5% 0 6,500 6,500 100% 6,500 26,000 19,500 75% 7,671 30,683 23,012 75% 2,786 11,145 8,359 75% 3,919 7,838 3,919 50% 0 350 350 100% 593 2,500 1,907 76% B3 350 267 76% 142 9,500 9,358 99% 0 1,000 1,000 100% 0 1,000 1,000 100% 0 100,000 100,000 100% --------------`---- 159,469 ----------- 811,668 ---------- 652,199 80% Page 24 25% Yr Complete 10/14/09 CITY OF KALISPELL Page 25 Quarterly Finance Report 25% Yr Complete FUND FUND ACTUAL YTD BODGET REMAINING % -------------------------------------------------------------------------------------------------------- 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-DOO COMMERCIAL FEES 2,550 11,000 8,450 77% 5160-000-343063-000 TIE DOWN FEES 650 4,000 3,350 84% 5160-000-343069-000 HANGER LEASES 3,053 12,000 8,946 75% 5160-000-343071-000 HANGAR SITE LEASES 15,556 18,600 3,044 16% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 4,116 16,500 12,384 75% 5160-000-343102-000 GROUND LEASES 10,732 10,450 282- -3% 5160-000-343200-000 UTILITY REBATES 0 3,000 3,000 100% 5160-000-343620-000 FUEL TAX 1,740 6,000 4,260 71% 5160-000-371010-000 INVESTMENT EARNINGS 1,204 8,500 7,296 86% TOTAL AIRPORT REVENUE ----------- 39,600 ----------- 90,050 --------------------- 50,450 56% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 10,202 33,797 23,595 70% 5160-430-430310-111 SEASONAL SALARIES 0 3,267 3,267 100% 5160-430-430310-153 HEALTH INSURANCE 1,263 3,030 1,768 58% 5160-430-430310-155 RETIREMENT 662 2,406 1,744 73% 5160-430-430310-210 OFFICE SUPPLIES 199 300 101 34% 5160-430-430310-218 NON -CAPITAL EQUIPMENT 73 1,000 927 93% 5160-430-430310-335 MEMBERSHIP 6 DUES 0 250 250 100% 5160-430-430310-341 ELECTRICITY 233 1,500 1,267 85% 5160-430-430310-345 TELEPHONE 260 1,000 740 74% 5160-430-430310-354 CONTRACT SERVICES 0 7,500 7,500 100% 5160-430-430310-355 CONTRACT SERVICES -MOWING 0 2,000 2,000 100% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 0 5,000 5,000 100% 5160-430-430310-360 REPAIRS & MAINTENANCE 67B 4,000 3,322 83% 5160-430-430310-362 EQUIPMENT MAINTENANCE 35 I,0f10 965 96% 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 135 2,000 1,865 93% 5160-430-430310-373 TRAVEL 655 2,000 1,345 67% 5160-430-430310-380 SIGNAGE 284 500 216 43% 5160-430-430310-390 EQUIPMENT RENTAL 550 1,500 950 63% 5160-430-430310-510 PROPERTY INSURANCE 1,992 6,870 4,878 71% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 2,033 8,130 6,098 75% 5160-430-430310-52B DATA PROCESSING 750 3,000 2,250 75% 5160-430-430310-820 DEPRECIATION 0 86,602 86,602 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 4,400 115,470 111,070 96% TOTAL AIRPORT OPERATIONS ----------- 24,401 ----------- 292,122 --------------------- 267,721 92% DATA PROCESSING REVENUE 6030-000--335230-000 HB 124 ENTITLEMENT 150,000 150,000 0 0% 6030-000-364030-000 SALE OF MISCELLANEOUS 0 500 500 100% 6030-000-371010-000 INVESTMENT EARNINGS 267 2,000 1,733 87% 6030-000-393000-000 INTERNAL SERVICES -DATA 39,365 161,425 122,060 76% TOTAL DATA PROCESSING REVENUE ----------- 189,631 ----------- 313,925 --------------------- 124,294 40% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 17,753 73,786 56,033 76% 6030-401-410580-153 HEALTH INSURANCE 2,627 9,702 7,075 73% 6030-401-410580-155 RETIREMENT 1,157 4,790 3,633 76% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 208 3,000 2,792 93% 6030-403-410580-215 COMPUTER SUPPLIES 154 3,700 3,546 96% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 8,846 11,000 2,154 20% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 381 24,000 23,619 98% 6030-403-410580-346 SUMMIT NET T1 CONTRACT 769 5,000 4,231 85% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,160 3,500 340 10% 6030-403-410580-354 MAINTENANCE CONTRACTS 4,400 6,000 1,600 27% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 3,771 28,850 25,079 87% 6030--403-410580-357 revised budget-GRANICUS 6 mo. 3,000 13,000 10,000 77% 6G30-403-410580-373 SCHOOL & TRAVEL 0 6,200 6,200 100% 6030-403-410580-510 INSURANCE 1,497 1,675 178 11% 6030-403-410585-229 COPIER,FAX, SUPPLIES 0 6,500 6,500 100% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 15,602 70,000 54,398 78% 6030-403-410585-532 COPIER LEASES 6,752 28,500 21,748 76% 6030-403-410588-218 FINANCE 308 0 308- 0% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 10/14/09 CITY OF KALISPELL Page 26 Quarterly Finance Report 25W Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ------------------------------------------------------------------------------------------------------- 6030-404-410588-218 COMPUTERS - ATTORNEYS 0 1,500 1,500 100% 6030-405-410588-218 COMPUTERS - NON CAPITAL CONTINGENCY 0 5,000 5,000 100% 6030-405-410588-940 COMPUTERS - SERVER / NETWORK ROUTER 0 30,000 30,000 100% 6030-410-410588-218 COMPUTERS - DPW 0 3,300 3,300 100% 6030-413-410588-218 COMPUTERS - POLICE DEPT 0 5,ODO 5,000 100% 6030-416-410588-218 COMPUTERS - FIRE 0 5,500 5,500 100% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 0 1,500 1,500 100% 6030-436-410588-218 COMPUTERS - PARKS 0 2,000 2,000 100% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 500 500 1008 TOTAL DATA PROCESSING EXPENSE ----------- 70,386 ----------- 363,503 ----------- ---------- 293,117 81%