Loading...
2nd Quarter Finance ReportCity of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 Date January 18, 2011 TO: Mayor Fisher & City Council members Jane Howington, City Manager From: Amy Robertson Finance Director RE: 2nd Qtr Finance Report — FY2011 Please find attached the printouts reflecting the activity thru January 18, 2011. By running the report through January 18' the General Fund tax revenue reflects the first half tax receipts which we receive from the County in December and January. As you can see we have collected more than 50% of our projected revenue; 47% remaining. We have about $120, 000 in delinquent taxes down from $280, 000 six months ago. The Outlaw Inn caught up all their delinquent taxes ($60,000 General Fund) and city specials. We continue to carry $100, 000 in protest taxes in the General Fund -protest tax dollars are held by the County. Expenditures include the payroll period ending January 1'. Most all departments have 50% remaining for payroll. Health insurance is booked for January so the reports will reflect 42% remaining as do the transfers posted the first of January. Utility billing includes January billing to date. Water and Sewer billings are generally higher in the first half of the year than the second and both are less than a year ago. FYI- water billed 1" six months of 2010 was $1,541,856 and for 2011 $1,294,697. Sewer billed V 6 months of 2010 was $1,674,038 and for 2011 $1,602,413. Please feel free to call with any questions. 758-7755. 01/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,374,162 4,448,257 2,074,095 47% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 7,761 7,818 57 1& 1000-000-311200-000 PERSONAL PROPERTY TAXES 209,576 250,000 40,424 16% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 21,369 25,000 3,631 15% 1000-000-322101-000 BEER & LIQUOR LICENSES 1,490 24,381 22,891 94% 1000-000-322300-000 BUSINESS LICENSES 810 1,200 390 33% 1000-000-322500-000 AMUSEMENT LICENSES 300 600 300 50% 1000-000-323012-000 PLANNING FEES 12,976 65,000 52,024 80% 1000-000-323107-000 EXCAV/DEMO/AIR/HOUSE MOVING PERMITS 0 500 500 100% 1000-000-323109-000 SITE REVIEW 3,596 8,500 4,904 58% 1000-000-323300-000 ANIMAL LICENSES 560 900 340 38% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 2,100 2,100 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 59,525 58,850 675- -1% 1000-000-335110-000 LIVE CARD TABLE PERMIT 3,600 2,650 950- -36% 1000-000-335230-000 HB124 ENTITLEMENT 1,135,229 2,272,379 1,137,150 50% 1000-000-341020-000 ADMINISTRATIVE CHARGES 300,082 490,321 190,239 39% 1000-000-341022-000 BOND FEES/ADMIN.CHG. 35,000 30,000 5,000- -17% 1000-000-341025-000 CITY COLLECTIONS 327 1,500 1,173 78% 1000-000-341027-000 BRESNAN FRANCHISE FEES 38,674 152,000 113,326 75% 1000-000-342010-000 POLICE SERVICES 9,978 15,000 5,022 33% 1000-000-342014-000 RESOURCE OFFICERS 86,000 86,000 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 2,972 10,000 7,028 70% 1000-000-342024-000 EPA GRANT -FIRE DEPT DIRECT REIMB. 0 20,000 20,000 100% 1000-000-342025-000 FIRE ENGINE RESPONSE FEE 50 6,500 6,450 99% 1000-000-343005-000 CENTRAL GARAGE CHARGE 70,709 118,000 47,291 40% 1000-000-351000-000 CITY COURT FINES & FEES 243,166 475,000 231,834 49% 1000-000-351016-000 DUI COURT FINE 2,310 0 2,310- 0% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 15,649 28,000 12,351 44% 1000-000-362010-000 CITY GOLF COURSE LEASE 0 25,000 25,000 100% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 737 3,000 2,263 75% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 13 500 488 98% 1000-000-365015-000 CONTRIBUTION FRM KIDSPORT 0 44,000 44,000 100% 1000-000-371010-000 INVESTMENT EARNINGS 18,485 55,000 36,515 66% 1000-000-381050-000 INCEPTION OF LEASE -POLICE CARS 0 80,850 80,850 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 0 514,326 514,326 100% TOTAL REVENUE ----------- 4,655,106 ----------- 9,323,132 --------------------- 4,668,026 50% Page 1 58.33% Yr Complete 01/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 965 1,000 35 4% 1000-400-410530-353 AUDITING 10,000 10,500 500 5% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,064 3,000 936 31% 1000-400-410560-312 POSTAGE 2,913 18,000 15,087 84% 1000-400-410560-320 PRINTING 1,521 5,850 4,329 74% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,016 3,500 1,484 42% 1000-400-420000-354 CONTRACT 911 CENTER 0 352,266 352,266 100% 1000-400-460446-354 KIDSPORT LEASE 42,910 44,000 1,090 2% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 3,300 6,600 3,300 50% 1000-400-460452-920 CONRAD MANSION BUILDING IMPROVEMENT 2,500 2,500 0 0% 1000-400-510300-000 CONTINGENCY 6,500 28,231 21,731 77% 1000-400-510300-820 LOAN TO PARKING COMMISSION 0 15,000 15,000 100% 1000-400-510310-354 ICMA PLAN FEES 250 500 250 50% 1000-400-510330-513 LIABILITY INSURANCE 238,877 247,000 8,123 3% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 13,942 30,000 16,058 54% 1000-400-510330-517 PROPERTY INSURANCE 36,083 50,000 13,917 28% ----------- SUBTOTAL GEN.GOV'T. 378,841 ---------------------- 832,947 ---------- 454,106 55% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 62,076 124,038 61,962 50% 1000-401-410210-153 HEALTH INSURANCE 8,032 13,770 5,738 42% 1000-401-410210-155 RETIREMENT 6,599 13,350 6,751 51% 1000-401-410210-215 COMPUTER SOFTWARE/SUPPLIES 158 300 142 47% 1000-401-410210-229 OTHER SUPPLIES 20 850 830 98% 1000-401-410210-312 NEWSLETTER 0 500 500 100% 1000-401-410210-335 MEMBERSHIP & DUES 940 2,000 1,060 53% 1000-401-410210-345 TELEPHONE & COMMUNICATION 43 400 357 89% 1000-401-410210-373 SCHOOL & TRAVEL 394 1,000 606 61% 1000-401-410210-379 MEETINGS 199 500 301 60% ----------- SUBTOTAL CITY MANAGER ----------- 78,462 ----------- 156,708 ---------- 78,246 50% HUMAN RESOURCES 1000-401-410830-110 SALARIES -PERSONNEL 52,149 103,338 51,189 50% 1000-401-410830-153 HEALTH INSURANCE 8,887 15,236 6,349 42% 1000-401-410830-155 RETIREMENT 3,402 6,700 3,298 49% 1000-401-410830-210 OFFICE SUPPLIES 0 300 300 100% 1000-401-410830-215 COMPUTER SUPPLIES 0 300 300 100% 1000-401-410830-218 SMALL OFFICE EQUIP/FURNITURE 0 200 200 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 345 400 55 14% 1000-401-410830-338 RECRUITMENT 1,838 3,500 1,662 47% 1000-401-410830-345 TELEPHONE 20 150 130 87% 1000-401-410830-354 CONTRACT SERVICES (ARBITRATION) 812 100 712- -712% 1000-401-410830-373 SCHOOL & TRAVEL 1,653 3,500 1,848 53% ----------- SUBTOTAL HUMAN RESOURCES ----------- 69,106 ----------- 134,174 ---------- 65,068 49% Page 2 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING $ -------------------------------------------------------------------------------------------------------------- MEDIA SPECIALIST 1000-401-410900-110 MEDIA SPECIALIST -salary 9,910 20,102 10,192 51% 1000-401-410900-153 HEALTH INSURANCE 4,418 8,190 3,772 46% 1000-401-410900-155 RETIREMENT 667 1,299 632 49% 1000-401-410900-218 EQUIPMENT 60- 3,000 3,060 102% 1000-401-410900-354 CONTRACT SERVICES 1,200 2,500 1,300 52% SUBTOTAL MEDIA SPECIALIST ----------- 16,134 ----------- 35,091 ----------- ---------- 18,957 54% MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 31,324 63,162 31,838 50% 1000-402-410100-153 HEALTH INSURANCE 18,515 31,815 13,300 42% 1000-402-410100-155 RETIREMENT 1,444 2,432 988 41% 1000-402-410100-210 OFFICE SUPPLIES 29 100 71 71% 1000-402-410100-335 MEMBERSHIP & DUES 4,267 4,811 544 11% 1000-402-410100-345 TELEPHONE & COMMUNICATION 18 100 82 82% 1000-402-410100-354 CONTRACT SERVICES 25 0 25- 0% 1000-402-410100-373 SCHOOL & TRAVEL 2,974 3,000 26 1% 1000-402-410100-379 MEETINGS 34 300 266 89% SUBTOTAL MAYOR/COUNCIL ----------- 58,629 ----------- 105,720 --------------------- 47,091 45% CITY CLERK 1000-402-410150-110 SALARIES/CITY CLERK 40,971 80,620 39,649 49% 1000-402-410150-121 OVERTIME 117 500 383 77% 1000-402-410150-153 HEALTH INSURANCE 5,445 9,446 4,001 42% 1000-402-410150-155 RETIREMENT 2,674 5,049 2,375 47% 1000-402-410150-210 OFFICE SUPPLIES 43 150 107 71% 1000-402-410150-229 OTHER SUPPLIES 0 50 50 100% 1000-402-410150-335 MEMBERSHIP & DUES 225 275 50 18% 1000-402-410150-345 TELEPHONE & COMMUNICATION 254 400 146 37% 1000-402-410150-352 RECODIFICATION 3,196 3,500 304 9% 1000-402-410150-354 CONTRACT SERVICES 25 25 0 0% SUBTOTAL CITY CLERK ----------- 52,950 ----------- 100,015 --------------------- 47,065 47% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 95,147 191,986 96,839 50% 1000-403-410550-153 HEALTH INSURANCE 18,566 30,604 12,038 39% 1000-403-410550-155 RETIREMENT 6,208 12,431 6,223 50% 1000-403-410550-322 BOOKS 205 300 95 32% 1000-403-410550-335 MEMBERSHIP & DUES 797 1,000 203 20% 1000-403-410550-345 TELEPHONE & COMMUNICATION 4 100 96 96% 1000-403-410550-353 CONTRACT SERVICES 1,190 1,000 190- -19% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 630 1,500 870 58% 1000-403-410550-355 BANK CHARGES & FEES 1,939 3,000 1,06l 35% 1000-403-410550-373 SCHOOL & TRAVEL 305 2,500 2,195 88% SUBTOTAL FINANCE ----------- 124,991 ----------- 244,421 --------------------- 119,430 49% Page 3 58.33% Yr Complete 01/18/11 _fYi)SiP. CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND ACTUAL YTD BUDGET REMAINING % CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 1000-404-411110-153 HEALTH INSURANCE 1000-404-411110-155 RETIREMENT 1000-404-411110-210 OFFICE SUPPLIES 1000-404-411110-215 COMPUTER SUPPLIES 1000-404-411110-322 BOOKS, CDs, LEXIS 1000-404-411110-335 MEMBERSHIP & DUES 1000-404-411110-345 TELEPHONE & COMMUNICATION 1000-404-411110-354 CONTRACT SERVICES 1000-404-411110-373 SCHOOL & TRAVEL SUBTOTAL CITY ATTORNEY MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 1000-406-410360-121 OVERTIME 1000-406-410360-153 HEALTH INSURANCE 1000-406-410360-155 RETIREMENT 1000-406-410360-210 OFFICE SUPPLIES 1000-406-410360-213 OFFICE EQUIPMENT/MAINT. 1000-406-410360-215 COMPUTER SUPPLIES 1000-406-410360-229 OTHER SUPPLIES 1000-406-410360-320 PRINTING 1000-406-410360-335 MEMBERSHIP & DUES 1000-406-410360-345 TELEPHONE & COMMUNICATION 1000-406-410360-353 SECURITY & TECHNOLOGY 1000-406-410360-354 CONTRACT SERVICES 1000-406-410360-373 SCHOOL & TRAVEL 1000-406-410360-394 JURY & WITNESS FEES 1000-406-410360-395 DRUG COURT 1000-406-410360-396 DUI COURT INCENTIVES & MISC SUBTOTAL COURT DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 1000-410-430100-112 SEVERANCE 1000-410-430100-153 HEALTH INSURANCE 1000-410-430100-155 RETIREMENT 1000-410-430100-210 OFFICE SUPPLIES 1000-410-430100-213 SMALL OFFICE EQUIPMENT 1000-410-430100-215 COMPUTER SUPPLIES 1000-410-430100-216 COMPUTER EQUIPMEMT/SUPPLIES 1000-410-430100-229 OTHER SUPPLIES 1000-410-430100-331 PUBLICATION & FILING FEES 1000-410-430100-335 MEMBERSHIP & DUES 1000-410-430100-345 TELEPHONE & COMMUNICATION 1000-410-430100-354 CONTRACT SERVICES 1000-410-430100-373 SCHOOL & TRAVEL SUBTOTAL ADMINISTRATION CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 1000-410-431330-112 SALARIES -RETIREMENT 1000-410-431330-121 OVERTIME 1000-410-431330-153 HEALTH INSURANCE 1000-410-431330-155 RETIREMENT 1000-410-431330-210 OFFICE SUPPLIES 1000-410-431330-215 COMPUTER SUPPLIES 1000-410-431330-218 EQUIPMENT (non -capital) 1000-410-431330-221 SAFETY EQUIP & SUPPLIES 1000-410-431330-229 OTHER SUPPLIES 155,065 307,944 152,879 5O% 28,582 48,958 20,376 42% 10,115 19,972 9,857 49% 199 1,200 1,001 83% 732 2,000 1,268 63% 6,393 7,000 607 9% 480 2,500 2,020 81% 396 1,200 804 67% 376 5,000 4,624 92% 813 2,000 1,187 59% ----------- 203,152 ----------- 397,774 --------------------- 194,622 49% 98,777 198,530 99,753 50% 6 250 244 98% 22,938 38,881 15,943 41% 6,452 12,871 6,419 50% 333 1,000 667 67% 392 1,000 608 61% 33 1,000 967 97% 333 1,500 1,167 78% 102 500 398 80% 200 300 100 33% 572 1,400 828 59% 26,703 40,000 13,297 33% 4,757 5,750 993 17% 1,468 6,000 4,532 76% 5,299 5,750 451 8% 313 1,000 687 69% 296 0 296- Ora ----------- ----------- 168,975 ----------- 315,732 ---------- 146,757 46% 8,649 16,919 8,271 49% 1,270 0 1,270- 0% 1,692 2,901 1,209 42% 538 1,095 557 51% 533 775 242 31% 100 150 50 33% 116 300 184 61% 113 350 237 68% 93 350 257 74% 242 300 58 19% 289 350 62 18% 40 1,000 960 96% 124 150 26 18% 46 400 354 89% ---------------------- 13,845 ----------- 25,040 ---------- 11,195 45% 82,292 178,259 95,967 54% 5,379 5,500 121 2% 1,183 1,500 317 21% 15,553 37,356 21,803 58% 5,503 10,935 5,432 5O% 393 300 93- -31% 37 800 763 95% 0 700 700 100% 220 250 30 12% 3,430 3,600 170 5% Page 4 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Page 5 Quarterly Finance Report As of January 18, 2011 58.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 1000-410-431330-231 GAS & OIL 58,229 122,500 64,271 52% 1000-410-431330-232 MOTOR VEHICLE PARTS. 43,702 76,000 32,298 43% 1000-410-431330-233 TIRES AND RELATED PARTS 14,184 27,000 12,816 47% 1000-410-431330-238 FILTERS & MISC. PARTS 2,727 3,500 773 22% 1000-410-431330-241 CONSUMABLE TOOLS 23 500 477 95% 1000-410-431330-322 BOOKS 90 150 60 40% 1000-410-431330-341 ELECTRICITY 803 1,700 897 53% 1000-410-431330-342 WATER 0 100 100 100% 1000-410-431330-344 NATURAL GAS 1,929 8,000 6,071 76% 1000-410-431330-354 CONTRACT SERVICES 15,333 52,000 36,667 71% 1000-410-431330-362 EQUIPMENT MAINTENANCE 0 250 250 100% 1000-410-431330-366 BUILDING MAINTENANCE 759 335 424- -127% 1000-410-431330-373 SCHOOL & TRAVEL 0 500 500 100% 1000-410-431330-388 MEDICAL SERVICES 50 350 301 86% SUBTOTAL CENTRAL GARAGE ----------- 251,820 ----------- 532,085 --------------------- 280,265 53% TOTAL PUBLIC WORKS 265,665 557,125 291,460 52% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 31,842 65,147 33,305 51% 1000-412-411230-121 OVERTIME 0 200 200 100% 1000-412-411230-153 HEALTH INSURANCE 6,918 13,295 6,377 48% 1000-412-411230-155 RETIREMENT 2,001 3,976 1,975 50% 1000-412-411230-224 JANITORIAL SUPPLIES 2,564 5,000 2,436 49% 1000-412-411230-229 OTHER SUPPLIES 99 750 651 87% 1000-412-411230-241 CONSUMABLE TOOLS 0 700 700 100% 1000-412-411230-341 ELECTRICITY 20,181 41,000 20,819 51% 1000-412-411230-344 NATURAL GAS 14,749 43,300 28,551 66% 1000-412-411230-345 TELEPHONE & COMMUNICATION 48 250 202 81% 1000-412-411230-354 CONTRACT SERVICES 4,721 19,000 14,279 75% 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 0 4,500 4,500 100% 1000-412-411230-362 EQUIPMENT MAINTENANCE 212 5,000 4,788 96% 1000-412-411230-366 BUILDING MAINTENANCE 9,910 15,500 5,590 36% 1000-412-411230-545 COUNTY LANDFILL 1,950 2,000 50 2% 1000-412-411230-610 SOI 2004 DEBT (HVAC SYS) 7,736 15,561 7,825 50% 1000-412-411230-620 BOI 2004 INT. (HVAC SYS) 706 1,425 719 50% SUBTOTAL CITY HALL ---------------------- 103,638 ----------- 236,604 ---------- 132,966 56% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 129,222 257,172 127,950 50% 1000-420-411020-153 HEALTH INSURANCE 31,716 54,388 22,672 42% 1000-420-411020-155 RETIREMENT 8,431 16,671 8,240 49% 1000-420-411020-210 OFFICE SUPPLIES 423 2,000 1,577 79% 1000-420-411020-213 OFFICE EQUIPMENT 120 1,000 880 88% 1000-420-411020-215 COMPUTER SUPPLIES/SOFTWARE 55 4,500 4,445 99% 1000-420-411020-320 PRINTING 64 500 437 87% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 591 2,500 1,909 76% 1000-420-411020-335 MEMBERSHIP/DUES 710 1,300 590 45% 1000-420-411020-345 TELEPHONE 330 900 570 63% 1000-420-411020-354 CONTRACT SERVICES 641 1,300 660 51% 1000-420-411020-373 SCHOOL & TRAVEL 615 2,000 1,385 69% TOTAL PLANNING DEPT. ---------------------- 172,918 ----------- 344,231 ---------- 171,313 50% O1/18/11 CITY OF KALISPELL Page 6 Quarterly Finance Report As of January 18, 2011 58.33% Yr Complete FUND -------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % POLICE DEPARTMENT ----------- ----------- ---------- ----------- -------------------- --------------------- 1000-413-420140-110 SALARIES -POLICE 891,163 1,782,771 891,608 50% 1000-413-420140-114 SALARY -comptime buyout 3,608 6,500 2,892 45% 1000-413-420140-121 OVERTIME 37,557 75,000 37,443 50% 1000-413-420140-123 SPECIAL ASSIGNMENT OVERTIME 4,219 27,500 23,281 85% 1000-413-420140-153 HEALTH INSURANCE 183,208 306,282 123,074 40% 1000-413-420140-155 RETIREMENT 113,986 230,650 116,664 51% 1000-413-420140-210 OFFICE SUPPLIES 1,038 3,500 2,462 70% 1000-413-420140-215 COMPUTER SUPPLIES 2,327 5,500 3,173 58% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 510 10,500 9,990 95% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,526 5,000 2,474 49% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 1,396 7,000 5,604 80% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,827 2,000 173 9% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 1,646 5,000 3,354 67% 1000-413-420140-227 AMMO & RELATED SUPPLIES 5,130 17,000 11,870 70% 1000-413-420140-228 PATROL CAR SUPPLIES 8,478 13,000 4,522 35% 1000-413-420140-229 OTHER SUPPLIES 867 3,500 2,633 75% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 173 2,000 1,827 91% 1000-413-420140-231 CRISIS NEGOTIATIONS 0 1,500 1,500 100% 1000-413-420140-235 BIKE PATROL 289 1,000 711 71% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 164 1,000 836 84% 1000-413-420140-320 PRINTING 2,622 5,000 2,378 48% 1000-413-420140-335 MEMBERSHIP & DUES 235 1,250 1,015 81% 1000-413-420140-345 TELEPHONE & COMMUNICATION 9,021 15,000 5,979 40% 1000-413-420140-354 CONTRACT SERVICES 4,196 7,000 2,804 40% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 2,613 4,000 1,387 35% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 0 6,500 6,500 100% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 1,161 2,000 839 42% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 11,295 20,000 8,705 44% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 620 2,500 1,880 75% 1000-413-420140-373 SCHOOL & TRAVEL 14,108 26,000 11,892 46% 1000-413-420140-375 REGIONAL TRAINING 365 15,000 14,635 98% 1000-413-420140-376 TESTING (REIMBURSED) 1,100 2,000 900 45% 1000-413-420140-380 TRAINING MATERIALS 860 2,000 1,140 57% 1000-413-420140-388 MEDICAL SERVICES 148 4,000 3,852 96% 1000-413-420140-391 TREATMENT 60 500 440 88% 1000-413-420140-392 BOARDING PRISONERS 43 1,000 957 96% 1000-413-420140-610 DEBT SERVICE -PRINCIPAL 0 6,000 6,000 100% 1000-413-420140-620 DEBT SERVICE -INTEREST 0 1,200 1,200 100% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 24,250 48,500 24,250 50% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 10,000 20,000 10,000 50% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 5,000 5,000 0 0% 1000-413-420140-944 VEHICLES 80,141 80,850 709 1% 1000-413-420141-110 DETECTIVE -SALARIES 173,912 333,564 159,652 48% 1000-413-420141-121 DETECTIVE -OVERTIME 5,907 20,000 14,093 70% 1000-413-420141-153 HEALTH INSURANCE 30,110 49,574 19,464 39% 1000-413-420141-155 DETECTIVE -RETIREMENT 22,872 44,951 22,079 49% 1000-413-420142-110 RECORDS -SALARIES 40,291 71,499 31,208 44% 1000-413-420142-121 OVERTIME 1,613 7,500 5,887 79% 1000-413-420142-153 HEALTH INSURANCE 10,218 15,690 5,472 35% 1000-413-420142-155 RETIREMENT 2,612 9,984 7,372 74% 1000-413-420142-354 CONTRACT SERVICES records mgmt 8,627 7,520 1,107- -15% 1000-413-420144-110 SRO SALARIES 57,372 108,087 50,715 47% 1000-413-420144-153 HEALTH INSURANCE 8,981 15,432 6,451 42% 1000-413-420144-155 SRO RETIREMENT 7,178 14,411 7,233 50% SUBTOTAL POLICE DEPT. ----------- 1,797,645 ----------- 3,479,715 --------------------- 1,682,070 48% O1/18/11 CITY OF KALISPELL Page 7 Quarterly Finance Report As of January 18, 2011 58.33% Yr Complete FUND 1000-416-420400-110 1000-416-420400-112 1000-416-420400-113 1000-416-420400-121 1000-416-420400-153 1000-416-420400-155 1000-416-420400-210 1000-416-420400-213 1000-416-420400-215 1000-416-420400-218 1000-416-420400-221 1000-416-420400-224 1000-416-420400-241 1000-416-420400-320 1000-416-420400-322 1000-416-420400-333 1000-416-420400-335 1000-416-420400-341 1000-416-420400-344 1000-416-420400-345 1000-416-420400-354 1000-416-420400-362 1000-416-420400-366 1000-416-420400-369 1000-416-420400-373 1000-416-420400-379 1000-416-420400-380 1000-416-420400-610 1000-416-420400-620 1000-416-420440-110 1000-416-420440-121 1000-416-420440-153 1000-416-420440-155 FUND ------------------------------------ FIRE DEPARTMENT FIRE SUPPRESSION -SALARIES SALARY -SEVERANCE & comptime buyback KELLY DAYS OVERTIME HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES SMALL OFFICE EQUIPMENT COMPUTER SUPPLIES Equipment (Non Capital) SAFETY EQUIP & SUPPLIES JANITORIAL SUPPLIES CONSUMABLE TOOLS/UNIFORMS PRINTING BOOKS SUBSCRIPTIONS MEMBERSHIP & DUES ELECTRICITY -STATION 62 NATURAL GAS -STATION 62 TELEPHONE & COMMUNICATION CONTRACT SERVICES EQUIPMENT MAINTENANCE BUILDING MAINTENANCE -STATION 62 RADIO EQUIPMENT & MAINT. SCHOOL & TRAVEL MEETINGS TRAINING MATERIALS DEBT RETIREMENT -FIRE TRUCK INTEREST EXPENSE -FIRE TRUCK FIRE PREVENTION -SALARIES OVERTIME HEALTH INSURANCE RETIREMENT SUBTOTAL FIRE DEPT. GRAND TOTAL GENERAL FUND ACTUAL YTD ------------------------------------- BUDGET REMAINING % 649,617 1,456,971 807,354 3,349 0 3,349- 15,249 0 15,249- 43,814 25,000 18,814- 148,240 236,879 88,639 88,057 189,205 101,148 44 1,350 1,306 0 500 500 0 850 850 3,072 7,500 4,428 12,560 15,000 2,440 595 1,500 905 5,963 15,000 9,037 8 700 693 0 1,000 1,000 40 250 210 422 350 72- 1,579 9,500 7,921 547 10,000 9,453 2,539 8,500 5,961 4,219 8,000 3,781 6,086 6,500 414 3,284 2,500 784- 5,524 10,500 4,976 1,215 2,500 1,285 196 500 304 7,236 13,300 6,064 26,558 53,578 27,020 6,433 12,443 6,010 20,868 33,134 12,266 116 0 116- 3,874 6,608 2,734 1,302 2,203 901 1,062,607 2,131,821 1,069,214 55% 0% 0% -75% 37% 53% 97% 100% 100% 39% 16% 60% 60% 99% 100% 84% -20% 83% 95% 70% 47% 6% -31% 47% 51% 61% 46% 50% 48% 37% 0% 41% 41% 50% 4,553,712 9,072,078 4,518,366 50% O1/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND 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 REDEVELOPMENT / CONTRACT SERVICES 1,234 15,000 13,766 92% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 8,137 13,949 5,812 42% 2185-480-470240-110 SALARIES 8,586 16,590 8,004 48% 2185-480-470240-153 HEALTH INSURANCE 1,111 1,909 798 42% 2185-480-470240-155 RETIREMENT 559 1,077 518 48% 2185-480-470240-354 AVAIL-TVN PROJECT 0 21,051 21,051 100% ----------- TOTAL AIRPORT TIF 19,627 ----------- 70,776 --------------------- 51,149 72% 2188 WESTSIDE TIF 2188-453-430246-952 LOWER SPRING CREEK 0 70,000 70,000 100% 2188-453-430246-953 3 MILE DR ROAD DESIGN 663 55,000 54,337 99% 2188-480-470230-110 SALARIES 5,559 11,060 5,501 50% 2188-480-470230-153 HEALTH INSURANCE 714 2,032 1,318 65% 2188-480-470230-155 RETIREMENT 362 718 356 50% 2188-480-470230-353 AUDIT 1,200 1,250 50 4% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 5,263 5,000 263- -5% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 14,583 25,000 10,417 42% 2188-480-470230-955 CD -REDEVELOPMENT ACTIVITY 34 2,091,138 2,091,104 100% ----------- TOTAL WESTSIDE TIF 28,378 ----------- 2,261,198 --------------------- 2,232,820 99% 2210 PARKS IN LIEU 2210-436-460430-826 TRANSFER TO ISTEA FUND 3,000 30,000 27,000 90% 2210-436-460430-934 CAPITAL IMPROVEMENTS 0 6,000 6,000 100% 2210-436-460430-935 SUNSET BASKETBALL COURT 3,000 5,000 2,000 40% 2210-436-460430-937 WESTVIEW IMPROVEMENTS 675 15,000 14,325 96% ----------- TOTAL PARKS IN LIEU ---------- 6,675 ----------- 56,000 ----- --------------------- 49,325 ------------- 88% ---------- 2215 NEW PARKS & REC. FUND ------ ----- ------------ -------------------- REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 437,318 845,000 407,682 48% 2215-000-311200-000 PERSONAL PROPERTY TAXES 39,139 38,000 1,139- -3% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,812 1,000 812- -81% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL CRT 1,500 5,000 3,500 70% 2215-000-346030-000 SWIMMING POOL FEES 79,258 140,000 60,742 43% 2215-000-346040-000 CONCESSION STAND REVENUE 23,667 32,500 8,833 27% 2215-000-346050-000 Parks Usage Fees 7,864 18,000 10,137 56% 2215-000-346051-000 RECREATION FEES 3,820 9,568 5,748 60% 2215-000-346052-000 SPORTS PROGRAMS 12,877 32,438 19,561 60% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 970 3,500 2,530 72% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 20,905 24,978 4,074 16% 2215-000-346055-000 ICE RINK 4,575 20,000 15,425 77% 2215-000-346057-000 YOUTH CAMPS 27,702 83,650 55,948 67% 2215-000-346059-000 PICNIC IN THE PARK 5,505 26,000 20,495 79% 2215-000-371010-000 INVESTMENTS/DONATIONS/MISC.SALES 206 2,000 1,794 90% 2215-000-381050-000 INCEPTION OF LEASE 7,300 85,309 78,009 91% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 63,000 63,000 100% ----------- TOTAL PARKS & REC REVENUE 674,418 ----------- 1,429,943 --------------------- 755,525 53% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 127,959 259,451 131,492 51% 2215-436-460430-111 SEASONAL SALARIES 22,683 36,988 14,305 39% 2215-436-460430-121 OVERTIME 52 1,000 948 95% 2215-436-460430-153 HEALTH INSURANCE 35,004 62,741 27,737 44% 2215-436-460430-155 RETIREMENT 8,960 18,396 9,436 51% 2215-436-460430-210 OFFICE SUPPLIES 273 1,200 927 77% 2215-436-460430-213 SMALL OFFICE EQUIPMENT 0 800 B00 100% 2215-436-460430-215 COMPUTER SUPPLIES 68 1,000 933 93% Page 8 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Page 9 Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % 2215-436-460430-221 SAFETY EQUIPMENT 581 900 319 35% 2215-436-460430-224 JANITORIAL SUPPLIES 1,860 3,000 1,140 38% 2215-436-460430-229 OTHER SUPPLIES 1,369 4,500 3,131 70% 2215-436-460430-241 CONSUMABLE TOOLS/SMALL EQUIPMENT 1,068 1,600 532 33% 2215-436-460430-320 PRINTING 27 256 229 90% 2215-436-460430-333 SUBSCRIPTIONS 207 250 43 17% 2215-436-460430-335 MEMBERSHIP & DUES 145 450 305 68% 2215-436-460430-337 ADVERTISING 0 250 250 100% 2215-436-460430-341 ELECTRICITY 8,422 14,250 5,828 41% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 9,867 20,000 10,133 51% 2215-436-460430-344 NATURAL GAS 1,373 3,200 1,827 57% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 830 3,000 2,170 72% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 1,500 1,500 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 2,102 6,500 4,398 68% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT MAINTENANCE 312 2,500 2,188 88% 2215-436-460430-364 LANDSCAPING 853 4,000 3,147 79% 2215-436-460430-366 BUILDING MAINTENANCE 6,341 5,500 841- -15% 2215-436-460430-367 VANDALISM REPAIRS 2,125 4,000 1,876 47% 2215-436-460430-373 SCHOOL & TRAVEL 714 1,200 486 41% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 183 550 367 67% 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 1,564 2,000 436 22% 2215-436-460430-440 IRRIGATION SUPPLIES 1,276 4,000 2,724 68% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 1,068 4,000 2,932 73% TOTAL PARKS EXPENDITURES ----------- 237,285 ---------------------- 472,482 ---------- 235,197 50% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 15,744 30,568 14,824 48% 2215-436-460440-111 SEASONAL SALARIES 24,231 52,101 27,870 53% 2215-436-460440-153 HEALTH INSURANCE 3,860 6,624 2,764 42% 2215-436-460440-155 RETIREMENT 1,657 4,127 2,470 60% 2215-436-460440-221 SAFETY EQUIPMENT 161 175 14 8% 2215-436-460440-229 OTHER SUPPLIES 3,825 16,000 12,175 76% 2215-436-460440-241 CONSUMABLE TOOLS 215 700 485 69% 2215-436-460440-335 MEMBERSHIP & DUES 0 135 135 100% 2215-436-460440-341 ELECTRICITY 0 5,600 5,600 100% 2215-436-460440-345 TELEPHONE & COMMUNICATION 65 350 285 810 2215-436-460440-354 CONTRACT SERVICES 200 1,000 800 80% 2215-436-460440-362 EQUIPMENT MAINTENANCE 317 500 183 37% 2215-436-460440-364 LANDSCAPING 0 1,000 1,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 445 500 55 11% 2215-436-460440-440 IRRIGATION 2,231 3,400 1,169 34% 2215-436-460440-452 SAND & GRAVEL 0 1,000 1,000 100% 2215-436-460440-610 DEBT SERVICE -PRINCIPAL 0 7,000 7,000 100% 2215-436-460440-620 DEBT SERVICE -INTEREST 0 2,000 2,000 100% 2215-436-460440-940 EQUIPMENT 7,300 85,309 78,009 91% ----------- TOTAL ATHLETIC COMPLEX ----------- 60,250 ----------- 218,539 ---------- 158,289 72% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 44,449 89,740 45,291 50% 2215-436-460431-111 SEASONAL SALARIES 4,134 9,530 5,396 57% 2215-436-460431-153 HEALTH INSURANCE 10,476 18,667 8,191 44% 2215-436-460431-155 RETIREMENT 2,771 6,118 3,347 55% 2215-436-460431-210 OFFICE SUPPLIES 211 600 389 65% 2215-436-460431-229 OTHER SUPPLIES 4,189 9,800 5,611 57% 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 35 750 715 95% 2215-436-460431-337 ADVERTISING 0 500 500 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 81 600 519 87% 2215-436-460431-354 CONTRACT SERVICES 15,261 19,950 4,690 24% 2215-436-460431-355 BANK FEES/CREDIT CARD FEES 972 2,500 1,528 61% 58.33% Yr Complete 01/18/11 FUND FUND ---------------------------------------- 2215-436-460431-373 SCHOOL & TRAVEL TOTAL RECREATION CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 ACTUAL YTD BUDGET REMAINING % ----------------------------------------------------------- 302 800 498 62% ------------------------------------------- 82,881 165,655 82,774 50% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 2215-436-460448-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-373 SCHOOL & TRAVEL TOTAL YOUTH CAMPS 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 33,099 66,982 33,883 51% 45,416 78,658 33,242 42% 0 Soo Soo 100% 9,884 16,952 7,068 42% 2,051 5,244 3,193 61% 73 300 227 76% 1,392 4,050 2,658 66% 0 300 300 100% 0 100 100 100% 0 300 300 100% 0 400 400 100% 5,129 13,000 7,871 61% 306 2,000 1,694 85% 0 ----------- 500 Soo 100% 97,350 ----------- 189,286 --------------------- 91,936 49% 120,447 198,314 77,867 39% 644 500 144- -29% 347 4,591 4,244 92% 397 500 103 21% 200 200 0 0% 161 200 39 20% 1,564 2,500 936 37% 15,644 22,405 6,761 30% 12,829 19,000 6,171 32% 2,478 4,000 1,522 38% 0 400 400 100% 0 50 50 100% 4,955 12,500 7,545 60% 13,548 24,000 10,452 44% 702 1,500 798 53% 1,074 1,300 226 17% 606 4,000 3,394 85% 2,157 2,400 243 10% 0 ----------- 250 ----------- 250 100% 177,753 ----------- 298,610 ---------- 120,857 40% 655,520 1,344,572 689,052 51% Page 10 58.33% Yr Complete 01/18/11 FUND FUND CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 ACTUAL YTD BUDGET REMAINING % ------------------------------------------------- 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 2230-000-342070-000 COUNTY EMS LEVY 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC 2230-000-371010-000 INTEREST EARNINGS TOTAL AMBULANCE REVENUE AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 2230-440-420730-113 KELLY DAYS 2230-440-420730-121 OVERTIME 2230-440-420730-153 HEALTH INSURANCE 2230-440-420730-155 RETIREMENT 2230-440-420730-210 OFFICE SUPPLIES 2230-440-420730-213 SMALL OFFICE EQUIPMENT 2230-440-420730-215 COMPUTER SUPPLIES 2230-440-420730-218 NON -CAPITAL EQUIPMENT 2230-440-420730-231 GAS AND OIL 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 2230-440-420730-312 POSTAGE 2230-440-420730-320 PRINTING 2230-440-420730-345 TELEPHONE & COMMUNICATION 2230-440-420730-353 AUDITING 2230-440-420730-354 CONTRACT SERVICES/RECERT. 2230-440-420730-359 CC FEES/COLLECTION SERV. 2230-440-420730-362 EQUIPMENT MAINTENANCE 2230-440-420730-369 RADIO MAINTENANCE 2230-440-420730-380 TRAINING MATERIALS 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 2230-440-420730-521 CENTRAL GARAGE TRANSFER 2230-440-420730-522 ADMINISTRATIVE TRANSFER 2230-440-420730-528 DATA PROCESSING TRANSFER 2230-440-420730-943 AMBULANCE TOTAL AMBULANCE FUND ------------------------------------------- 164,291 650,000 485,709 75% 42,067 102,000 59,933 59% 1,725 0 1,725- 0% 710 -------- 500 210- -42% ----------- 208,793 752,500 --------------------- 543,707 72% 156,464 405,542 2,185 10,000 4,130 6,000 32,946 78,704 20,571 53,393 434 750 287 200 0 2,000 1,610 2,000 2,249 10,000 832 5,000 882 3,000 442 500 986 700 500 500 9,448 8,000 206 500 1,154 3,500 0 2,500 5,687 8,000 6,919 22,500 15,429 35,000 14,036 16,100 5,250 9,000 19,256 33,010 6,235 10,689 0 50,000 308,138 777,088 249,078 61% 7,815 78% 1,870 31% 45,758 58% 32,822 61% 316 42% 87- -44% 2,000 100% 390 20% 7,751 78% 4,168 83% 2,118 71% 58 12% 286- -41% 0 0% 1,448- -18% 294 59% 2,346 67% 2,500 100% 2,313 29% 15,581 69% 19,571 56% 2,064 13% 3,750 42% 13,754 42% 4,454 42% 50,000 100% 468,950 60% 2310 OLD SCHOOL TIF - TECH 2310-480-470210-354 CONTRACT SERVICES - BOND COUNSEL 0 950 950 100% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 15,000 40,000 25,000 63% ------------------------------------------- TOTAL 2310 OLD SCHOOL TECH TIF 15,000 40,950 25,950 63% 2311 OLD SCHOLL TIF INDUSTRIAL 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 0 9,000 9,000 100% ------------------------------------------- TOTAL 2311 OLD SCHOOL INDUSTR. 0 9,000 9,000 100% 2372 HEALTH PERMISIVE LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND 0 577,326 577,326 100% ------------------------------------------- TOTAL 2372 HEALTH LEVY 0 577,326 577,326 100% Page 11 58.33% Yr Complete 01/18/11 CITY OF KALISPELL Page 12 Quarterly Finance Report As of January 18, 2011 58.33% Yr Complete FUND 2394-000-323101-000 2394-000-323103-000 2394-000-323104-000 2394-000-323107-000 2394-000-323108-000 2394-000-341025-000 2394-000-343380-000 2394-000-371010-000 2394-420-420530-110 2394-420-420530-121 2394-420-420530-153 2394-420-420530-155 2394-420-420530-210 2394-420-420530-215 2394-420-420530-229 2394-420-420530-231 2394-420-420530-312 2394-420-420530-320 2394-420-420530-322 2394-420-420530-323 2394-420-420530-331 2394-420-420530-335 2394-420-420530-345 2394-420-420530-353 2394-420-420530-354 2394-420-420530-355 2394-420-420530-366 2394-420-420530-373 2394-420-420530-510 2394-420-420530-521 2394-420-420530-522 2394-420-420530-528 2399-400-420100-522 2399-413-420140-354 2399-413-420140-940 2399-416-420400-354 2399-416-420400-610 2399-416-420400-620 2399-416-420400-944 2400-410-430263-110 2400-410-430263-112 2400-410-430263-153 2400-410-430263-155 2400-410-430263-244 2400-410-430263-341 2400-410-430263-360 2400-410-430263-510 2400-410-430263-522 FUND ---------------------------------- 2394 BUILDING DEPARTMENT REVENUE: BUILDING PERMITS PLUMBING PERMITS MECHANICAL PERMITS HOUSE MOVING PERMITS PLAN REVIEW FEES MISC. COLLECTIONS/FEES PUBLIC SAFETY BLDG CONTRACT MGMT INVESTMENT EARNINGS TOTAL REVENUE BUILDING EXPENDITURES: SALARIES -BUILDING DEPT. OVERTIME HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES COMPUTER SUPPLIES OTHER SUPPLIES GAS & OIL POSTAGE PRINTING BOOKS ST. ED. ASSESSMENTS PUBLICATION & FILING FEES MEMBERSHIP & DUES TELEPHONE & COMMUNICATION AUDITING CONTRACT SERVICES CONTRACT CHG. ZONING ADMINISTRATION BUILDING MAINTENANCE SCHOOL & TRAVEL PROPERTY INSURANCE CENTRAL GARAGE TRANSFER ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER TOTAL BUILDING DEPT. 2399 IMPACT FEE FUND ADMIN CHARGE - IMPACT FEES 5% IMPACT FEE REVIEW POLICE EQUIPMENT IMPACT FEE REVIEW PRINCIPAL - FIRE TRUCK INTEREST - FIRE TRUCK FIRE- LADDER TRUCK TOTAL 2399 IMPACT FEE FUND 2400 LIGHT MAINT. SALARIES SEVERANCE HEALTH INSURANCE RETIREMENT STREET LIGHT SUPPLIES ELECTRICITY REPAIR & MAINT SERVICES INSURANCE ADMINISTRATIVE TRANSFER TOTAL LIGHT MAINT. ACTUAL YTD BUDGET REMAINING % ----------------------------------------------- 120,925 150,000 29,075 19% 9,889 12,000 2,111 18% 15,274 20,000 4,727 24% 75 200 125 63% 63,651 50,000 13,651- -27% 205 0 205- 0% 0 38,000 38,000 100% 500 ----------- 100 400- -400% 210,518 ----------- 270,300 --------------------- 59,782 22% 95,148 182,897 87,749 48% 317 2,000 1,683 84% 19,454 35,160 15,706 45% 5,955 11,299 5,344 47% 38 2,000 1,962 98% 0 2,500 2,500 100% 190 750 560 75% 736 2,250 1,514 67% 178 600 422 70% 128 300 172 57% 2,516 1,500 1,016- -68% 0 2,500 2,500 100% 0 200 200 100% 105 900 795 88% 714 1,500 786 52% 0 3,000 3,000 100% 535 500 35- -7% 3,596 0 3,596- Ors 0 800 800 100% 429 2,000 1,571 79% 3,864 4,250 386 9% 175 300 125 42% 1,167 2,000 833 42% 779 ----------- 1,336 557 42% ----------- 136,025 ----------- 260,542 ---------- 124,517 48% 4,137 4,800 663 14% 500 500 0 O% 0 20,000 20,000 100% 500 500 0 0% 12,750 25,750 13,000 50% 4,819 9,190 4,371 48% 75,975 ----------- 225,000 149,025 66% ----------- 98,682 ----------- 285,740 ---------- 187,058 65% 20,540 43,656 23,116 53% 1,270 0 1,270- 0% 5,267 9,329 4,062 44% 1,281 2,688 1,407 52% 5,835 13,000 7,165 55% 73,595 163,000 89,405 55% 2,797 28,000 25,203 90% 774 1,000 226 23% 4,154 ----------- 7,121 2,967 42% ----------- 115,513 ----------- 267,794 ---------- 152,281 57% 01/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 20,346 41,000 20,654 50% 2420-421-430234-957 ALLEY PAVING 25,912 25,000 912- -4% 2420-421-430240-231 GAS & OIL 16,753 30,000 13,247 44% 2420-421-430240-344 NATURAL GAS 2,702 3,500 798 23% 2420-421-430240-354 CONTRACT SERVICES 2,088 149,663 147,575 99% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 17,000 17,000 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 0 195,000 195,000 100% 2420-421-430240-369 RADIO EQUIPMENT & MAINT. 0 700 700 100% 2420-421-430240-452 GRAVEL 0 3,000 3,000 100% 2420-421-430240-453 MATERIALS; CONTRACT PREP. 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 23,839 50,000 26,161 52% 2420-421-430240-472 ASPHALT 8,353 30,000 21,647 72% 2420-421-430240-473 CRACK SEALING 0 5,000 5,000 100% 2420-421-430240-533 EQUIPMENT RENTAL 0 5,500 5,500 100% TOTAL GAS TAX ----------- 99,993 ----------- 560,363 --------------------- 460,370 82% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 285,854 607,879 322,025 53% 2500-421-430240-112 RETIREMENT -severance 5,923 0 5,923- 0% 2500-421-430240-121 OVERTIME 9,541 30,000 20,459 68% 2500-421-430240-153 HEALTH INSURANCE 78,353 122,708 44,356 36% 2500-421-430240-155 RETIREMENT 18,543 37,403 18,860 50% 2500-421-430240-213 SMALL OFFICE EQUIPMENT 70 500 430 86% 2500-421-430240-216 COMPUTER EQUIPMEMT 1,065 4,500 3,435 76% 2500-421-430240-218 EQUIPMENT (NON CAPITAL) 90 1,000 910 91% 2500-421-430240-221 SAFETY EQUIPMENT 782 1,200 418 35% 2500-421-430240-224 JANITORIAL SUPPLIES 197 700 503 72% 2500-421-430240-229 OTHER SUPPLIES 542 1,200 659 55% 2500-421-430240-231 GAS & OIL 16,973 30,000 13,027 43% 2500-421-430240-241 CONSUMABLE TOOLS 534 2,000 1,466 73% 2500-421-430240-341 ELECTRICITY 654 1,200 546 45% 2500-421-430240-342 WATER/SEWER CHARGES 52 175 123 71% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 463 1,000 537 54% 2500-421-430240-354 CONTRACT SERVICES 3,435 13,000 9,565 74% 2500-421-430240-355 CONTRACT SERV.-AERIAL MAPPING 77 8,000 7,923 99% 2500-421-430240-357 RATE STUDY 0 8,000 8,000 100% 2500-421-430240-358 IMPACT FEE STUDY 0 14,000 14,000 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 12,096 23,000 10,904 47% 2500-421-430240-366 BUILDING MAINTENANCE 101 1,500 1,399 93% 2500-421-430240-369 RADIO EQUIPMENT & MAINT. 195 5,000 4,805 96% 2500-421-430240-373 SCHOOL & TRAVEL 33 2,500 2,467 99% 2500-421-430240-388 MEDICAL SERVICES 479 1,300 821 63% 2500-421-430240-510 LIABILITY INSURANCE 82,919 83,000 81 0% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 16,500 16,500 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 38,500 66,000 27,500 42% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 33,099 56,741 23,642 42% 2500-421-430240-528 DATA PROCESSING TRANSFER 6,235 10,689 4,454 42% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 0 16,000 16,000 100% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 0 1,520 1,520 100% 2500-421-430240-840 MACI GRANT MATCH 0 40,000 40,000 100% 2500-421-430240-935 PAVEMENT MAINTENANCE funds 200,376 458,908 258,532 56% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 17,500 55,000 37,500 68% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 31,041 31,041 100% 2500-421-430264-110 TSS - SALARIES 81,730 140,606 58,876 42% 2500-421-430264-121 OVERTIME 3,822 8,500 4,678 55% 2500-421-430264-153 HEALTH INSURANCE 10,368 17,805 7,437 42% 2500-421-430264-155 RETIREMENT 5,297 8,803 3,506 40% 2500-421-430264-216 COMPUTER EQUIP & SOFTWARE 527 1,500 973 65% 2500-421-430264-218 EQUIPMENT(non-capital) 485 4,800 4,315 90% 2500-421-430264-221 SAFETY EQUIPMENT & SUPPLIES 1,641 500 1,141- -228% 2500-421-430264-224 JANITORIAL SUPPLIES 279 650 371 57% 2500-421-430264-229 OTHER SUPPLIES 162 800 638 80% 2500-421-430264-241 CONSUMABLE TOOLS 478 1,100 622 57% 2500-421-430264-242 STREET SIGNS 27,126 38,000 10,874 29% 2500-421-430264-243 TRAFFIC SIGNALS 942 10,000 9,058 91% Page 13 58.33% Yr Complete 01/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- 2500-421-430264-245 BARRICADE MATERIALS 0 4,000 4,000 100% 2500-421-430264-341 ELECTRICITY 3,413 10,000 6,587 66% 2500-421-430264-345 COMMUNICATIONS 349 700 351 50% 2500-421-430264-354 CONTRACT SERVICES 3,520 10,000 6,480 65% 2500-421-430264-362 EQUIPMENT MAINTENANCE 945 1,400 455 33% 2500-421-430264-366 BUILDING MAINTENANCE 121 1,500 1,379 92% 2500-421-430264-369 RADIO MAINTENANCE 0 900 900 100% 2500-421-430264-373 SCHOOL & TRAVEL 992 2,500 1,508 60% 2500-421-430264-428 PAINT MATERIALS 44 20,000 19,956 100% 2500-421-430264-510 LIABILITY INS.-TSS 3,674 4,050 376 9% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 2,059 2,000 59- -3% 2500-421-430264-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SPEC. ST. MAINT. ----------- 966,573 ----------- 2,051,116 --------------------- 1,084,543 53% 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 69,543 141,593 72,050 51% 2600-436-460433-121 OVERTIME 17 750 733 98% 2600-436-460433-153 HEALTH INSURANCE 16,509 28,935 12,426 43% 2600-436-460433-155 RETIREMENT 4,389 8,744 4,355 50% 2600-436-460433-210 OFFICE SUPPLIES 0 50 50 100% 2600-436-460433-229 OTHER SUPPLIES 93 500 407 81% 2600-436-460433-241 CONSUMABLE TOOLS 466 950 484 51% 2600-436-460433-333 SUBSCRIPTIONS 0 50 50 100% 2600-436-460433-354 CONTRACT SERVICES 2,000 2,500 500 20% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 0 10,000 10,000 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 371 500 129 26% 2600-436-460433-364 LANDSCAPING & TREES 880 7,000 6,120 87% 2600-436-460433-373 SCHOOL & TRAVEL 237 250 13 5% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 3,570 6,000 2,430 40% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 1,458 2,500 1,042 42% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 4,449 7,626 3,178 42% 2600-436-460433-528 DATA PROCESSING TRANSFER 779 1,336 557 42% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 0 2,000 2,000 100% 2600-436-460433-620 INTEREST EXPENSE 0 215 215 100% 2600-436-460433-940 MACHINERY & EQUIPMENT 21,000 21,000 0 0% TOTAL URBAN FORESTRY ----------- 125,763 ----------- 242,499 ----------- ---------- 116,736 48% 2602 ARRA FORESTRY GRANT 2602-436-460433-354 CONTRACT SERVICES 24,234 24,561 327 1% TOTAL ARRA FORESTRY GRANT ----------- 24,234 ----------- 24,561 --------------------- 327 1% 2601 DEVELOPER TREES 2601-436-460435-351 EMPIRE ESTATES ($44,911) 283 9,231 8,948 97% 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 100% 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 1,132 3,244 2,112 65% 2601-436-460435-356 SINOPAH SUBD ($5,790) 0 667 667 100% 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 0 2,883 2,883 100% 2601-436-460435-358 WEST VIEW SUBD ($22,680) 0 17,831 17,831 100% 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 2,264 36,020 33,756 94% 2601-436-460435-360 RIVER GLEN SUED ($3,240) 0 278 278 100% 2601-436-460435-361 VILLAGE GREENS ($3,540) 0 2,514 2,514 100% 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 0 1,538 1,538 100% 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 0 1,390 1,390 100% 2601-436-460435-364 MTN VISTA ESTATES III $17,278.25 0 3,679 3,679 100% 2601-436-460435-365 VILLAGE GREENS $3,540 0 2,797 2,797 100% 2601-436-460435-366 W VIEW ESTATES $20,060 0 10,850 10,850 100% 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 0 4,254 4,254 100% TOTAL 2602 DEVELOPER TREES ---------------------- 3,679 101,512 --------------------- 97,833 96% Page 14 58.33% Yr Complete 01/18/11 CITY OF KALISPELL Page 15 Quarterly Finance Report As of January 18, 2011 58.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2825 MACI GRANT -SWEEPER 2825-421-430240-940 STREET SWEEPER 0 200,000 200,000 100% TOTAL 2825 MACI GRANT ----------- 0 ---------- ----------- ----------- 200,000 ----------- ----------- --------------------- 200,000 ------------------- --------------------- 100% 2880 COM DEV REVOLVING FUND 2880-480-470240-711 IRP LOAN PROGRAM MATCH 34 225,000 224,966 100% TOTAL LOAN REVOLVING ----------- 34 ----------- ----------- ----------- 225,000 ----------- ----------- --------------------- 224,966 --------------------- --------------------- 100% 2886 UDAG FUND 2886-480-470210-110 SALARIES - UDAG 28,129 55,988 27,859 50% 2886-480-470210-153 HEALTH INSURANCE 3,782 6,363 2,581 41% 2886-480-470210-155 RETIREMENT 1,844 3,618 1,774 49% 2886-480-470210-210 OFFICE SUPPLIES 207 500 293 59% 2886-480-470210-211 GRANT ADMIN. EXPENSES 0 1,000 1,000 100% 2886-480-470210-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 2886-480-470210-215 COMPUTER SUPPLIES 0 1,000 1,000 100% 2886-480-470210-218 EQUIPMENT (non -capital) 0 300 300 100% 2886-480-470210-231 GAS & OIL 0 300 300 100% 2886-480-470210-312 POSTAGE 64 300 236 79% 2886-480-470210-320 PRINTING 0 1,500 1,500 100% 2886-480-470210-331 GRANT ACTIVITIES ADVERTISING 0 1,500 1,500 100% 2886-480-470210-334 MT WEST MEMBERSHIP 500 500 0 0% 2886-480-470210-335 MEMBERSHIP & DUES 380 700 320 46% 2886-480-470210-345 TELEPHONE & COMMUNICATION 84 750 666 89s 2886-480-470210-353 AUDITING 1,200 1,500 300 20% 2886-480-470210-354 CONTRACT SERVICES 50 1,000 950 95% 2886-480-470210-355 PROSPECT DEVELOPMENT 0 3,000 3,000 100% 2886-480-470210-363 OFFICE EQUIP MAINTENANCE 0 500 500 100% 2886-480-470210-373 SCHOOL & TRAVEL 1,034 1,000 34- -3% 2886-480-470210-379 MEETINGS 34 500 466 93% 2886-480-470210-381 TRAINING 192 1,000 808 81% 2886-480-470210-395 CDBG- GROWTH POLICY UPDATE 0 20,000 20,000 100% 2886-480-470210-396 GRANT SERVICES 5,500 25,000 19,500 78% 2886-480-470210-510 PROPERTY & LIABILITY INS. 2,975 3,800 825 22% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 3,891 6,671 2,780 42% 2886-480-470210-528 DATA PROCESSING TRANSFER 3,897 6,680 2,783 42% 2886-480-470210-532 OFFICE RENT 2,352 4,703 2,352 50% 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 2,500 2,500 100% TOTAL UDAG FUND ----------- 56,114 ---------- ---------- ----------- 152,373 ---------- ----------- --------------------- 96,259 -------------------- -------------------- 63% RURAL DEVELOPMENT REVOLVING 2887-480-470210-110 SALARIES 13,951 27,776 13,825 50% 2887-480-470210-153 HEALTH INSURANCE 1,852 3,182 1,331 42% 2887-480-470210-155 RETIREMENT 908 1,795 887 49% 2887-480-470210-610 DEBT SERVICE/PAIN-L#61-01 17,213 17,213 0 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 4,861 4,861 0 0% 2887-480-470210-750 REDEVELOPMENT LOANS 34 215,000 214,966 100% TOTAL RURAL DEVELOPMENT ----------- 38,818 ---------- ----------- 269,827 ---------- --------------------- 231,009 -------------------- 86% 2888 RURAL DEV. #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-02 29,228 0 29,228- 0% 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-02 2,610 10,930 8,320 76% 2888-480-470210-750 REDEVELOPMENT LOANS 0 85,000 85,000 100% TOTAL 2888 RURAL DEV. #2 ----------- 31,838 ----------- ----------- 95,930 ---------- --------------------- 64,092 --------------------- 67% 01/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET ------------------------------------------------------------------------------------ 2944 CDBG-ED FVCC 2944-480-470242-780 TRANING COSTS-FVCC GRT 0 2944-480-470242-790 MACHINERY/EQUIPMENT-FVCC GRT 0 2944-480-470242-820 ADMIN TRANSFER - to Com Development 0 ----------- TOTAL 2944 CDBG-ED FVCC -- 0 2945 CDBG-ED FVCC #2 2945-480-470242-780 TRAINING COSTS 0 2945-480-470242-790 MACHINERY/EQUIPMENT 0 2945-480-470242-820 ADMIN TRANSFER -to Com. Deveolpment 0 ----------- TOTAL 2945 CDBG-ED FVCC #2 -- 0 2953 EPA BROWNSFIELD GRANT 2953-480-470210-780 BROWNSFIELD ASSESSMENT GRT EXP TOTAL EPA BROWNSFIELD GRANT 2954 EPA/BROWNFIELDS PLANNING 2954-480-470210-354 AREA -WIDE PILOT PROGRAM TOTAL 2954 EPA/BROWNFIELD PLAN 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN TOTAL 2915 STONEGARDEN GRANT 72,000 6,090 3,428 81,518 REMAINING % ------------------ 72,000 100% 6,090 100% 3,428 100% 81,518 100% 15,000 15,000 100% 246,800 246,800 100% 12,145 12,145 100% 273,945 ---------------- 273,945 100% 15,893 396,152 380,259 96% ----------- 15,893 ----------- 396,152 --------------------- 380,259 96% 0 ----------- 175,000 175,000 100% 0 ----------- 175,000 --------------------- 175,000 100% 9,870 ----------- 26,998 17,128 63% ----------- 9,870 26,998 --------------------- 17,128 63% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 32,804 62,650 29,846 48% 2916-413-420140-121 OVERTIME 2,125 11,000 8,875 81% 2916-413-420140-153 HEALTH INSURANCE 3,703 6,363 2,660 42% 2916-413-420140-155 RETIREMENT 4,298 8,443 4,145 49% 2916-413-420140-210 OFFICE SUPPLIES 0 400 400 100% 2916-413-420140-354 CONTRACT SERVICES 0 3,000 3,000 100% ----------- TOTAL 2916 DRUG ENFORCEMENT 42,930 ----------- 91,856 --------------------- 48,926 53% 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 26,828 49,878 23,050 46% 2918-413-420140-153 HEALTH INSURANCE 8,032 13,770 5,738 42s 2918-413-420140-155 RETIREMENT 3,546 6,722 3,176 47% ----------- TOTAL 2918 COPS HIRING GRANT ----------- 38,406 ----------- 70,370 ---------- 31,964 45% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-125 DUI TASK FORCE 556 10,000 9,444 94% 2919-413-420140-126 HOLIDAY OT REIMB. 11,037 50,000 38,963 78% 2919-413-420140-127 SCHOOL DIST. OT 5,788 20,000 14,212 71% 2919-413-420140-216 SECURE OUR SCHOOLS GRANT $1,200 1,200 1,200 0 0% 2919-413-420140-218 JAG GRANT- E Tickets Equip/supplies 17,845 17,845 0 0% 2919-413-420140-219 EQUIPMENT: NON - CAPITAL 81 10,000 9,919 99% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 1,200 5,000 3,800 76% 2919-413-420140-221 Bullet Proof Vests 780 10,000 9,220 92% 2919-413-420143-218 JAG GRT 2010-DJ-BX-1015 VIDEO/EQUIP ----------- 9,250 ----------- 19,189 ----------- 9,939 ---------- 52% Page 16 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- TOTAL LAW ENF. GRANT 47,738 ----------- ----------- 143,234 ----------- ----------- 95,496 -------------------- --------------------- 67% 2920 DOJ-IT UPGRADE SAFETY BLD 2920-480-470210-922 PUBLIC SAFETY BLDG -TECH UPGRADES 0 250,000 250,000 100% TOTAL 2920 IT UPGRADE -SAFETY ----------- 0 ----------- 250,000 --------------------- 250,000 100% 2921 DRUG COURT GRANT 2921-406-410360-354 DRUG COURT -contract services 30,754 326,262 295,508 91% TOTAL DRUG COURT GRANT ----------- 30,754 ----------- ----------- ----------- 326,262 ----------- ----------- --------------------- 295,508 ----------- ---------- --------------------- 91% 2951 DUI COURT GRANT 2951-406-410360-355 CS-EVAL,P0,LAC/#2011-02-03-02 16,419 112,479 96,060 85% 2951-406-410361-354 CS -EVALUATOR, PO,LAC 2010-18-21-02 10,232 ----------- 10,788 ----------- 556 --------------------- 5% TOTAL DUI COURT GRANT 26,651 ----------- ----------- 123,267 ----------- ----------- 96,616 -------------------- -------------------- 78% 2930 PRESERVE AMERICA GRANT 2930-480-470240-354 PRESERVE AMERICA EXPENSES 0 75,000 75,000 100% TOTAL 2930 PRESERVE AMERICA ----------- 0 ----------- 75,000 --------------------- 75,000 100% 2927 CULTRUAL ARTS PASSTHRU GT 2927-400-460452-354 HOCKADAY 0 5,200 5,200 100% 2927-400-460454-354 GLACIER ORCHESTRA 0 3,750 3,750 100% TOTAL 2927 CULTURAL ARTS ----------- 0 ---------------------- 8,950 ---------- 8,950 100% 2957 FEMA GRANT 2957-416-420400-110 SALARIES 197 10,000 9,803 98% 2957-416-420400-121 OVERTIME 0 15,000 15,000 100% 2957-416-420400-153 HEALTH INSURANCE 0 1,564 1,564 100% 2957-416-420400-155 RETIREMENT 442 1,436 994 69% 2957-416-420400-218 EQUIPMENT (non capital) 5,177 34,109 28,932 85% 2957-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 0 6,000 6,000 100% 2957-416-420400-229 HAZMAT REIMB.-MATERIALS 0 6,000 6,000 100% 2957-416-420400-373 TRAVEL - REIMBURSABLE 0 20,000 20,000 100% 2957-416-420410-125 PASS THRU HAZMAT OT 3,465 20,000 16,535 83% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 6,652 31,125 24,473 79% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 5,000 5,000 100% 2957-416-420414-218 AFG EQUIPMENT AND SAFETY($137,000) 109,156 123,246 14,090 11% TOTAL FEMA GRANT ---------------------- 125,088 ----------- ----------- ----------- 273,480 ---------- ---------- 148,392 ---------- 54% 2975 ISTEA 2975-436-460457-950 WOODLAND CONNECTOR ----------- 124,110 ----------- 265,000 ----------- 140,890 ---------- 53% TOTAL ISTEA 124,110 265,000 140,890 53% 2990 STIMULUS- ROADS 2990-421-430240-950 STIMULUS STREET CONSTRUCTION 342,796 343,549 753 0% ----------- TOTAL 2990 STIMULUS - ROADS ----------- 342,796 ----------- 343,549 ---------- 753 0% 2991 NEIGHBORHOOD STABILIZATIO 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS 17,814 88,700 70,886 80% ----------- TOTAL 2992 NEIGHBORHOOD STABIL ----------- 17,814 ----------- 88,700 ---------- 70,886 80% Page 17 58.33% Yr Complete 01/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 Page 18 58.33% Yr Complete FUND FUND 2992 ENERGY BLOCK GRANT 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS TOTAL 2992 ENERGY BLOCK GRANT 2993 STIMULUS ENERGY #2 2993-412-411230-925 ENERGY IMPROVEMENTS TOTAL 2993 STIMULUS ENERGY #2 2995 SAFER GRANT 2995-416-420400-110 SALARIES 2995-416-420400-153 HEALTH INSURANCE 2995-416-420400-155 RETIREMENT TOTAL 2995 SAFER GRANT CAPITAL PROJECT FUNDS 4150 FIRE STATION #61 REMODEL 4150-416-420400-928 FIRE STATION 61 CONSTRUCTION TOTAL 4150 FIRE STATION REMODE 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 4300 FAA NON -PRIMARY ENTITLMNT 4300-430-430310-354 TOWER MITIGATION TOTAL FAA NP ENTITLEMENT 4312 FAA PLANNING GRANT 4312-430-430310-940 CAPITAL IMPROVEMENTS TOTAL FAA PLANNING GRANT ACTUAL YTD BUDGET REMAINING % 17,814 ----------- 88,700 ----------- 70,886 ----------- 80% 17,814 88,700 ---------- 70,886 80% 4,362 ----------- 103,000 98,638 96% 4,362 ----------- 103,000 --------------------- 98,638 96% 30,898 135,000 104,102 77% 12,565 34,000 21,435 63% 4,187 ----------- 18,000 13,813 77% 47,651 ----------- 187,000 --------------------- 139,349 75% 422,409 ----------- 1,258,398 835,989 66% 422,409 ----------- ----------- 1,258,398 ----------- --------------------- 835,989 --------------------- 66% 897 ----------- 25,000 24,103 96% 897 ---------------------- 25,000 ---------- 24,103 96% 0 ----------- 600,000 600,000 100% 0 ---------------------- 600,000 ---------- 600,000 100% 12,100 ----------- 100,000 ----------- 87,900 88% 12,100 ----------- 100,000 ---------- 87,900 88% O1/18/11 CITY OF KALISPELL Page 19 Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ENTERPRISE FUNDS WATER REVENUE 5210-000-331158-000 STATE BYPASS RELOCATION REIMB. 7,430 0 7,430- 0% 5210-000-343210-000 METERED WATER SALES 1,328,522 2,450,000 1,121,478 46% 5210-000-343220-000 UNMETERED WATER SALES 9,451 5,000 4,451- -89% 5210-000-343225-000 IMPACT FEES 121,059 220,000 98,941 45% 5210-000-343230-000 METER REPLACEMENT FEE 49,779 95,000 45,221 48% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 6,485 12,000 5,515 46% 5210-000-343270-000 WATER TURN ON FEES 1,410 3,000 1,590 53% 5210-000-343275-000 TAG FEE 8,840 20,000 11,160 56% 5210-000-371010-000 INVESTMENT EARNINGS 32,077 52,500 20,423 39% TOTAL WATER REVENUE ----------- 1,565,053 ----------- 2,857,500 --------------------- 1,292,447 45% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 348,050 691,214 343,164 50% 5210-447-430550-112 SALARIES -RETIREMENT 5,212 4,400 812- -18% 5210-447-430550-121 OVERTIME 13,354 20,500 7,146 35% 5210-447-430550-153 HEALTH INSURANCE 70,852 150,401 79,549 53% 5210-447-430550-155 RETIREMENT 22,711 42,900 20,189 47% 5210-447-430550-210 OFFICE SUPPLIES 213 450 237 53% 5210-447-430550-213 SMALL OFFICE EQUIPMENT 0 1,000 1,000 100% 5210-447-430550-214 GIS SUPPLIES 34 3,000 2,966 99% 5210-447-430550-215 COMPUTER SUPPLIES 1,068 3,000 1,932 64% 5210-447-430550-216 COMPUTER EQUIPMEMT 3,467 5,000 1,533 31% 5210-447-430550-218 EQUIPMENT (NON CAPITAL) 9,336 10,200 864 8% 5210-447-430550-221 SAFETY EQUIP & SUPPLIES 2,907 3,700 793 21% 5210-447-430550-224 JANITORIAL SUPPLIES 66 800 734 92% 5210-447-430550-226 CHLORINE & CHEMICALS 16,374 33,000 16,626 50% 5210-447-430550-229 OTHER SUPPLIES 475 1,500 1,025 68% 5210-447-430550-231 GAS & OIL 14,743 27,000 12,257 45% 5210-447-430550-241 CONSUMABLE TOOLS 278 2,500 2,222 89% 5210-447-430550-312 POSTAGE 1,105 2,500 1,395 56% 5210-447-430550-320 PRINTING 0 2,000 2,000 100% 5210-447-430550-335 MEMBERSHIP & DUES 294 1,200 907 76% 5210-447-430550-336 LICENSES & FEES 186 19,000 18,815 99% 5210-447-430550-341 ELECTRICITY 65,250 148,000 82,750 56% 5210-447-430550-342 WATER 131 500 369 74% 5210-447-430550-344 NATURAL GAS 3,943 15,000 11,057 74% 5210-447-430550-345 TELEPHONE & COMMUNICATION 3,306 8,000 4,694 59% 5210-447-430550-349 LAB SERVICES 12,715 25,500 12,785 50% 5210-447-430550-353 AUDITING 2,550 3,000 450 15% 5210-447-430550-354 CONTRACT SERVICES 18,749 60,000 41,251 69% 5210-447-430550-355 CONTRACT SERV.-AERIAL MAPPING 77 3,000 2,923 97% 5210-447-430550-356 WTR RIGHTS UPDATE/WTR MODELING 4,908 25,000 20,092 80% 5210-447-430550-357 RATE STUDY 0 4,500 4,500 100% 5210-447-430550-358 IMPACT FEE REVIEW 3,921 5,000 1,079 22% 5210-447-430550-360 REPAIR & MAINT SERVICES 3,937 7,000 3,063 44% 5210-447-430550-362 EQUIPMENT MAINTENANCE 2,578 4,000 1,422 36% 5210-447-430550-363 OFFICE EQUIP MAINTENANCE 0 200 200 100% 5210-447-430550-366 BUILDING MAINTENANCE 3,747 17,000 13,253 78% 5210-447-430550-369 RADIO EQUIPMENT & MAINT. 0 2,450 2,450 100% 5210-447-430550-373 SCHOOL & TRAVEL 3,483 5,500 2,017 37% 5210-447-430550-380 TRAINING MATERIALS 108 500 392 78% 5210-447-430550-388 MEDICAL SERVICES 511 800 289 36% 5210-447-430550-395 RENTAL EQUIPMENT 300 1,500 1,200 80% 5210-447-430550-410 CONSTRUCTION MATERIALS 13,353 30,000 16,647 55% 5210-447-430550-421 METERS (new services) 15 0 15- 0% 5210-447-430550-422 HYDRANTS 1,647 26,000 24,353 94% 5210-447-430550-423 MATERIALS FOR MAINS 6,467 11,000 4,533 41% 5210-447-430550-424 MATERIALS -SERVICE LINES 4,634 9,000 4,366 49% 5210-447-430550-425 MATERIALS PUMPS/WELLS 6,052 36,000 29,948 83% 5210-447-430550-510 PROPERTY & LIABILITY INS. 33,829 36,500 2,671 7% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 3,538 4,000 462 12% 5210-447-430550-513 UNINSURED LOSS -GOODWILL 0 7,500 7,500 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 4,375 7,500 3,125 42% 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Page 20 Quarterly Finance Report As of January 18, 2011 58.33% Yr Complete FUND FUND -------------------------------------------------------- 5210-447-430550-522 ADMINISTRATIVE TRANSFER 5210-447-430550-528 DATA PROCESSING TRANSFER 5210-447-430550-532 LEASE PAYMENTS 5210-447-430550-810 BAD DEBT EXPENSE 5210-447-430550-935 ARMORY WELL GENERATOR REPLACEMENT 5210-447-430550-940 MACHINERY & EQUIPMENT 5210-447-430550-948 METERS (METER FUNDS) 5210-447-430550-950 WATER MAIN REPLACEMENT -GRAND VIEW 5210-447-430550-951 SECURITY SYSTEM UPGRADES 5210-447-430550-954 93S BYPASS -UTILITY RELOCATE -amended 5210-447-430550-956 UPPER/LOWER INTERCONNECTION 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 5210-447-430555-930 CONTRACT MAIN UPSIZE 5210-447-430555-941 METERS (NEW SERVICES) 5210-447-430555-953 SECTION 36 WELL TOTAL WATER FACILITIES WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 5210-447-430560-153 HEALTH INSURANCE 5210-447-430560-155 RETIREMENT 5210-447-430560-210 OFFICE SUPPLIES 5210-447-430560-218 EQUIPMENT - NOT CAPITAL 5210-447-430560-335 MEMBERSHIP & DUES 5210-447-430560-353 AUDITING 5210-447-430560-354 CONTRACT SERVICES 5210-447-430560-355 BILLING COSTS 5210-447-430560-373 SCHOOL & TRAVEL 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5210-447-430560-528 DATA PROCESSING TRANSFER 5210-447-430560-532 RENT TOTAL WATER BILLING REVENUE BONDS 5210-447-490204-610 2004 BOND PRINCIPAL (HWY93) 5210-447-490204-620 2004 BOND INTEREST (HWY93) 5210-447-490204-630 2004 BOND FISCAL AGENT FEES 5210-447-490206-610 2007 BOND PRIN WRF 3.75% 5210-447-490206-620 2007 BOND INT WRF 3.75% 5210-447-490250-610 SRF 2001 PRINCIPAL 4% 5210-447-490250-620 SRF 2001 INTEREST 4% TOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE TOTAL DEPRECIATION TOTAL WATER FUND ACTUAL YTD BUDGET REMAINING % ------------------------------------------ 55,255 94,723 39,468 11,691 20,041 8,350 3,919 7,838 3,919 0 1,500 1,500 0 60,000 60,000 0 105,000 105,000 28,850 65,000 36,150 159,517 1.56,000 3,517- 0 32,000 32,000 474 15,000 14,526 0 30,000 30,000 0 395,000 395,000 0 75,000 75,000 25,375 65,000 39,625 0 75,000 75,000 999,930 2,726,317 1,726,387 ----------------------------- 43,979 91,807 10,955 18,774 2,828 5,914 63 500 62 2,500 228 300 1,500 1,500 2,286 7,500 15,833 28,500 85 1,200 3,604 6,178 12,857 22,041 3,919 7,838 98,198 194,552 ------- ---------- 0 145,000 46,633 46,635 300 300 0 179,000 83,419 83,422 0 38,000 18,560 18,560 148,911 510,917 ------------------ 47,828 7,819 3,086 437 2,438 72 0 5,214 12, 667 1,115 2,574 9,184 3, 919 96,354 42% 42% 50% 100% 100% 100% 56% -2% 100% 97% 100% 100% 100% 61% 100% 630 52% 42% 52% 87% 98% 24% 0% 70% 44% 93% 42% 42% 50% 611F: 145,000 100% 3 0% 0 0% 179,000 100% 3 0% 38,000 100% 0 0% 362,006 71% ------------------ 0 ----------- 725,000 725,000 100% 0 ----------- ----------- 725,000 ----------- --------------------- 725,000 --------------------- 100% 1,247,039 4,156,786 2,909,747 70% 01/18/11 FUND 5310-000-331158-000 5310-000-343310-000 5310-000-343330-000 5310-000-343335-000 5310-000-343360-000 5310-000-371010-000 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND ------------------------------- SEWER REVENUE: STATE BYPASS RELOCATION REIMB. SEWER SERVICE CHARGES IMPACT FEES (SANITARY) IMPACT FEES (WWTP) INSTALLATION,SALE OF MAT./OTHER INVESTMENT EARNINGS TOTAL SEWER REVENUE ACTUAL YTD BUDGET REMAINING % 7,430 16,237 8,807 54% 1,685,664 3,500,000 1,814,336 52% 80,433 100,000 19,567 20% 102,659 125,000 22,341 18% 16,343 2,000 14,343- -717a 32,558 ----------- 74,000 ----------- 41,442 --------------------- 56% 1,925,087 3,817,237 1,892,150 50% EXPENDITURES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 35,654 75,471 39,817 53% 5310-454-430620-153 HEALTH INSURANCE 8,177 14,240 6,063 43% 5310-454-430620-155 RETIREMENT 2,286 4,807 2,521 52% 5310-454-430620-215 OFFICE SUPPLIES/FURNITURE 0 1,000 1,000 100% 5310-454-430620-218 COMPUTERS/SUPPLIES 253 1,500 1,247 83% 5310-454-430620-335 MEMBERSHIP & DUES 130 300 170 57% 5310-454-430620-353 AUDITING 1,500 1,500 0 0% 5310-454-430620-354 CONTRACT SERVICES 443 7,500 7,058 94% 5310-454-430620-355 BILLING COSTS 17,634 24,000 6,367 27% 5310-454-430620-373 SCHOOL & TRAVEL 85 1,000 915 92% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 4,220 7,234 3,014 42% 5310-454-430620-528 DATA PROCESSING TRANSFER 12,857 22,041 9,184 42% 5310-454-430620-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SEWER BILLING COSTS ---------------------- 87,157 ---------------------- 168,431 ----------- --------------------- 81,274 ---------- 48% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 160,078 342,562 182,484 53% 5310-454-430630-112 SALARIES-SEVERANCE/RETIREMENT 19,158 13,900 5,258- -38% 5310-454-430630-121 OVERTIME 3,064 7,000 3,936 56% 5310-454-430630-153 HEALTH INSURANCE 35,864 61,635 25,771 42% 5310-454-430630-155 RETIREMENT 11,190 22,931 11,741 51% 5310-454-430630-210 OFFICE SUPPLIES 108 450 342 76% 5310-454-430630-213 SMALL OFFICE EQUIPMENT 0 250 250 100% 5310-454-430630-214 GIS SUPPLIES 34 1,000 966 97% 5310-454-430630-215 COMPUTER SUPPLIES 0 2,000 2,000 100% 5310-454-430630-216 COMPUTER EQUIPMEMT 2,591 2,500 91- -4& 5310-454-430630-218 EQUIPMENT (NON CAPITAL) 2,276 1,000 1,276- -128% 5310-454-430630-221 SAFETY EQUIP & SUPPLIES 4,784 7,500 2,716 36% 5310-454-430630-224 JANITORIAL SUPPLIES 518 700 182 26% 5310-454-430630-229 OTHER SUPPLIES 260 600 340 57% 5310-454-430630-231 GAS & OIL 3,588 9,500 5,912 62% 5310-454-430630-241 CONSUMABLE TOOLS 289 1,000 711 71% 5310-454-430630-312 POSTAGE 0 500 500 100% 5310-454-430630-336 LICENSES & FEES 0 450 450 100% 5310-454-430630-341 ELECTRICITY 19,579 43,000 23,421 54% 5310-454-430630-342 WATER 59 175 116 66% 5310-454-430630-344 NATURAL GAS 5,948 13,000 7,052 54% 5310-454-430630-345 TELEPHONE & COMMUNICATION 10,458 21,000 10,542 50% 5310-454-430630-353 AUDITING 2,000 2,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 9,066 14,000 4,934 35% 5310-454-430630-355 CONTRACT SERVICES -AERIAL MAPPING 77 3,000 2,923 97% 5310-454-430630-356 CONSULTANTS 0 7,500 7,500 100% 5310-454-430630-357 RATE STUDY FY09/FACILITY PLAN FY08 0 3,000 3,000 100% 5310-454-430630-358 IMPACT FEE REVIEW 3,921 5,000 1,079 22% 5310-454-430630-362 EQUIPMENT MAINTENANCE 3,259 4,800 1,541 32% 5310-454-430630-366 BUILDING MAINTENANCE 323 1,000 677 68% 5310-454-430630-369 RADIO EQUIPMENT & MAINT. 0 1,000 1,000 100% 5310-454-430630-373 SCHOOL & TRAVEL 1,309 2,000 691 35% 5310-454-430630-388 MEDICAL SERVICES 418 800 383 48% 5310-454-430630-410 CONSTRUCTION MATERIALS 1,655 9,000 7,345 82% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 7,133 12,500 5,367 43% 5310-454-430630-510 PROPERTY & LIABILITY INS. 50,621 56,000 5,379 10% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 947 18,000 17,053 95% Page 21 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- 5310-454-430630-521 CENTRAL GARAGE TRANSFER 1,458 2,500 1,042 42% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 36,968 63,374 26,406 42% 5310-454-430630-528 DATA PROCESSING TRANSFER 8,573 14,697 6,124 42% 5310-454-430630-532 OFFICE RENT 3,919 7,838 3,919 50% 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 10,661 25,500 14,839 58% 5310-454-430630-810 BAD DEBT EXPENSE 0 1,000 1,000 100% 5310-454-430630-954 93 So. BYPASS -UTILITY RELOCATE 158 21,650 21,492 99% ----------- TOTAL SANITARY SEWER/COLLECTIO ----------- 422,312 ----------- 828,812 ----------- --------------------- 406,500 --------------------- 49% SANITARY SEWER PLANT INVEST $ 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 0 44,000 44,000 100% 5310-454-430635-957 GRANDVIEW PUMP STA/GRAVITY MAIN 52% 8,028 6,000 2,028- -34% ----------- TOTAL SANITARY SEWER PLANT INV ----------- 8,028 ----------- 50,000 ----------- --------------------- 41,972 --------------------- 84% REVENUE BONDS/SANITARY 5310-454-490204-610 PRINCIPAL-2004 BONDS(HWY 93 S) 0 63,000 63,000 100% 5310-454-490204-620 INTEREST-2004 BONDS 42,075 42,075 0 0% 5310-454-490204-630 FISCAL AGENT FEES 0 300 300 100% ----------- TOTAL REVENUE BONDS ----------- 42,075 ----------- 105,375 ----------- --------------------- 63,300 --------------------- 60% DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 800,000 800,000 100% ----------- TOTAL DEPRECIATION -SANITARY ----------- 0 ----------- 800,000 ----------- --------------------- 800,000 ----------- ---------- 100% TOTAL SANITARY SEWER 472,415 1,784,187 1,311,772 74% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 177,053 382,859 205,806 54% 5310-455-430640-112 SALARIES -RETIREMENT 5,475 8,800 3,325 38% 5310-455-430640-121 OVERTIME 11,509 20,000 8,491 42% 5310-455-430640-153 HEALTH INSURANCE 34,103 66,146 32,043 48% 5310-455-430640-155 RETIREMENT 11,877 23,932 12,055 50% 5310-455-430640-210 OFFICE SUPPLIES 485 1,000 515 52% 5310-455-430640-213 SMALL OFFICE EQUIPMENT 695 1,000 305 31% 5310-455-430640-215 COMPUTER SUPPLIES 0 500 500 100% 5310-455-430640-216 COMPUTER EQUIPMEMT 530 2,500 1,970 79% 5310-455-430640-221 SAFETY EQUIP & SUPPLIES 236 1,500 1,264 84% 5310-455-430640-224 JANITORIAL SUPPLIES 40 200 160 80% 5310-455-430640-225 ALUM 10,125 35,000 24,875 71% 5310-455-430640-226 CHLORINE & CHEMICALS 4,816 12,000 7,184 60% 5310-455-430640-229 OTHER SUPPLIES 2,445 5,000 2,555 51% 5310-455-430640-231 GAS & OIL 4,312 11,000 6,688 61% 5310-455-430640-241 CONSUMABLE TOOLS 734 1,000 266 27% 5310-455-430640-312 POSTAGE 96 400 304 76% 5310-455-430640-335 MEMBERSHIP & DUES 160 800 640 80% 5310-455-430640-336 LICENSES & FEES 0 8,000 8,000 100% 5310-455-430640-341 ELECTRICITY 78,229 200,000 121,771 61% 5310-455-430640-342 WATER 2,587 7,500 4,913 66% 5310-455-430640-344 NATURAL GAS 19,814 60,000 40,186 67% 5310-455-430640-345 TELEPHONE & COMMUNICATION 1,910 6,000 4,090 68% 5310-455-430640-353 AUDITING 2,750 2,750 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 53,068 123,000 69,932 57% 5310-455-430640-355 OTHER CONTRACT SERVICES 16,542 38,000 21,458 56% 5310-455-430640-356 CONSULTANTS 11,301 19,000 7,699 41% 5310-455-430640-357 WWTP RATE STUDY 0 5,000 5,000 100% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 5310-455-430640-360 REPAIR & MAINT SERVICES 0 15,000 15,000 100% 5310-455-430640-366 BUILDING MAINTENANCE 865 2,300 1,435 62% 5310-455-430640-373 SCHOOL & TRAVEL 5,176 10,000 4,824 48% Page 22 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------------------------------------------------------- 5310-455-430640-380 TRAINING MATERIALS 441 500 59 120 5310-455-430640-388 MEDICAL SERVICES 388 500 112 22% 5310-455-430640-395 RENTAL EQUIPMENT 20 800 781 98% 5310-455-430640-510 PROPERTY & LIABILITY INS. 43,300 52,000 8,700 17% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 2,042 3,500 1,458 42% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 61,497 105,424 43,927 42% 5310-455-430640-528 DATA PROCESSING TRANSFER 10,911 18,705 7,794 42% TOTAL WWTP OPERATIONS ----------- 575,535 ----------- 1,266,616 --------------------- 691,081 55% WWTP REPLACEMENT ----------- ----------- --------------------- 5310-455-430645-362 EQUIPMENT MAINTENANCE 38,339 40,000 1,661 4% 5310-455-430645-940 MACHINERY & EQUIPMENT 14,588 20,000 5,412 27% TOTAL WWTP REPLACEMENT ----------- 52,926 ----------- ----------- 60,000 ----------- --------------------- 7,074 --------------------- 12% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 57,288 114,033 56,745 50% 5310-455-430646-121 OVERTIME 0 200 200 100% 5310-455-430646-153 HEALTH INSURANCE 9,628 19,226 9,598 50% 5310-455-430646-155 RETIREMENT 3,546 6,997 3,451 49% 5310-455-430646-210 OFFICE SUPPLIES 0 100 100 100% 5310-455-430646-215 COMPUTER SUPPLIES & SUPPORT 35 50 15 30% 5310-455-430646-216 COMPUTER EQUIPMENT 0 1,400 1,400 100% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 0 4,000 4,000 100% 5310-455-430646-222 LAB SUPPLIES 3,866 10,000 6,134 61% 5310-455-430646-224 JANITORIAL SUPPLIES 0 50 50 100% 5310-455-430646-229 OTHER SUPPLIES 133 200 67 34% 5310-455-430646-312 POSTAGE & SHIPPING 405 500 95 19% 5310-455-430646-335 MEMBERSHIP & DUES 126 100 26- -26% 5310-455-430646-336 LICENSES & FEES 140 200 60 30% 5310-455-430646-345 TELEPHONE & ALARMS 0 50 50 100% 5310-455-430646-349 LAB SERVICES 4,441 20,000 15,559 78% 5310-455-430646-362 EQUIPMENT MAINTENANCE 910 1,300 390 30% 5310-455-430646-373 SCHOOL & TRAVEL 1,304 2,500 1,196 48% 5310-455-430646-380 TRAINING MATERIALS 0 200 200 100% 5310-455-430646-940 EQUIPMENT 0 ----------- 7,000 7,000 100% TOTAL WWTP LAB OPERATIONS 81,822 ---------------------- 188,106 ---------- 106,284 57% REVENUE BONDS/WWTP 5310-455-490210-610 DEBT-2002 ISSUE -PRINCIPAL 0 230,000 230,000 100% 5310-455-490210-620 DEBT-2002 INTEREST 9,430 9,430 0 0% 5310-455-490210-630 FISCAL AGENT FEES-2002 BONDS 0 300 300 100% TOTAL REVENUE BONDS/WWTP ----------- 9,430 ----------- ---------------------- 239,730 ---------------------- ---------- 230,300 ---------- 96% SRF LOAN/WWTP 5310-455-490215-610 DEBT SRF 92003-PRINCIPAL 0 261,000 261,000 100% 5310-455-490215-620 DEBT SRF 92003-INTEREST 24,300 24,300 0 0% TOTAL SRF LOAN/WWTP ----------- 24,300 ---------------------- 285,300 ---------- 261,000 91% DEBT SERVICE SRF -new constr. ----------- ---------------------- ---------- 5310-455-490227-610 SRF 2007WWTP PRINCIPAL 0 215,000 215,000 100% 5310-455-490227-620 SRF 2007WWTP INTEREST 511,819 511,820 1 0% SUBTOTAL SRF 2007 ----------- 511,819 ---------------------- 726,820 ---------- 215,001 30% TOTAL WWTP DEBT ----------- 545,549 ----------- ---------------------- 1,251,850 ---------------------- ---------- 706,301 ---------- 56% CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-831 CITY/EVERGREEN RESERVE TRANSFER 0 ----------- 411,599 411,599 100% TOTAL DEPRECIATION 0 ---------------------- 411,599 ---------- 411,599 100% Page 23 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- ----------- ---------------------- ---------- TOTAL WWTP 1,255,832 3,178,171 1,922,339 60% --------------------- ---------- ---------- TOTAL BILLING/SANITARY/W7WTP 1,815,404 5,130,789 3,315,385 65% Page 24 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Page 25 Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % STORM SEWER REVENUE 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 5,079 20,000 14,921 75% 5349-000-343033-000 IMPACT FEES 77,297 200,000 122,703 61% 5349-000-343034-000 PERMIT FEES 395 1,500 1,105 74% 5349-000-343035-000 STORM SEWER CHARGES 0 2,500 2,500 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 818,827 825,000 6,173 1% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 4,634 3,500 1,134- -32% 5349-000-371010-000 INTEREST ON INVESTMENTS 13,785 20,000 6,215 31% ----------- TOTAL STORM REVENUE 920,018 ----------- 1,072,500 --------------------- 152,482 14% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 168,367 347,937 179,570 52% 5349-453-430246-112 SEVERANCE 6,319 4,400 1,919- -44% 5349-453-430246-121 OVERTIME 1,980 4,500 2,520 56% 5349-453-430246-153 HEALTH INSURANCE 35,764 66,241 30,477 46% 5349-453-430246-155 RETIREMENT 10,923 22,037 11,114 50% 5349-453-430246-210 OFFICE SUPPLIES/EQUIPMENT 169 600 431 72% 5349-453-430246-214 GIS SUPPLIES 0 2,000 2,000 100% 5349-453-430246-215 COMPUTER SUPPLIES 184 4,000 3,816 95% 5349-453-430246-216 COMPUTER EQUIPMEMT 599 3,000 2,401 80% 5349-453-430246-218 EQUIPMENT -NON CAPITAL 0 1,000 1,000 100% 5349-453-430246-221 SAFETY EQUIP & SUPPLIES 80 2,500 2,420 97% 5349-453-430246-229 OTHER SUPPLIES 36 1,200 1,164 97% 5349-453-430246-231 GAS & OIL 3,548 10,500 6,952 66% 5349-453-430246-241 CONSUMABLE TOOLS 72 1,000 928 93% 5349-453-430246-320 PRINTING 0 200 200 100% 5349-453-430246-345 TELEPHONE & COMMUNICATION 485 750 265 35% 5349-453-430246-353 AUDITING 500 600 100 17% 5349-453-430246-354 CONTRACT SERVICE 294 3,000 2,706 90% 5349-453-430246-355 CONTRACT SERV.-AERIAL MAPPING 77 3,000 2,923 97% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 1,534 25,500 23,966 94% 5349-453-430246-357 RATE STUDY 0 8,000 8,000 100% 5349-453-430246-358 IMPACT STUDY 3,183 7,000 3,818 55% 5349-453-430246-359 CONSULTANTS-TMDL 0 15,000 15,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 170 1,500 1,330 89% 5349-453-430246-362 GROUNDWATER MONITORING 7,139 26,000 18,861 73% 5349-453-430246-371 CURB & GUTTER 0 5,000 5,000 100% 5349-453-430246-373 SCHOOL & TRAVEL 1,483 3,500 2,017 58% 5349-453-430246-388 MEDICAL SERVICES 185 250 65 26% 5349-453-430246-410 CONSTRUCTION MATERIALS 237 10,000 9,763 98% 5349-453-430246-510 PROPERTY & LIABILITY INS. 7,557 8,500 943 11% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 1,458 2,500 1,042 42% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 18,642 31,957 13,315 42% 5349-453-430246-528 DATA PROCESSING TRANSFER 3,117 5,344 2,227 42% 5349-453-430246-530 BNSF LEASE PMT 5,018 4,200 818- -19% 5349-453-430246-532 OFFICE RENT 3,919 7,838 3,919 50% 5349-453-430246-952 STORM DRAIN CORRECTION 4,736 100,000 95,264 95% 5349-453-430246-954 S MEADOWS SURVEY 5,300 10,000 4,700 47% 5349-453-430248-958 STILLWATER/WILLOW GLEN CONST 67 5,000 4,933 99% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 30,000 30,000 100% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 225,000 225,000 100% ----------- TOTAL STORM 293,143 ---------------------- 1,010,554 ---------- 717,411 71% 58.33% Yr Complete O1/18/11 FUND FUND ---------------------------------- 5510-000-343410-000 5510-000-363040-000 5510-000-371010-000 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 SOLID WASTE REVENUE: GARBAGE COLLECTION (Billed) PEN & INT ON SPEC ASSESS. INVESTMENT EARNINGS TOTAL SOLID WASTE REVENUE ACTUAL YTD BUDGET -------------------- 798,052 2,485 1,887 802,424 771,500 3,500 3,500 REMAINING % ---------------------- 26,552- -3% 1,015 29% 1,613 46% ------------------------------- 778,500 23,924- -3% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 160,351 361,733 201,382 56% 5510-460-430840-112 SEVERANCE -RETIREMENT 4,227 0 4,227- 0% 5510-460-430840-121 OVERTIME 2,060 9,500 7,440 78% 5510-460-430840-153 HEALTH INSURANCE 37,825 65,453 27,628 42% 5510-460-430840-155 RETIREMENT 10,151 22,295 12,144 54% 5510-460-430840-213 SMALL OFFICE EQUIPMENT 70 500 430 86% 5510-460-430840-216 COMPUTER EQUIPMENT 1,070 3,000 1,930 64% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 8,043 25,000 16,957 68% 5510-460-430840-221 SAFETY EQUIP & SUPPLIES 252 1,500 1,248 83% 5510-460-430840-224 JANITORIAL SUPPLIES 317 400 83 21% 5510-460-430840-229 OTHER SUPPLIES 446 2,000 1,554 78% 5510-460-430840-231 GAS & OIL 18,674 47,000 28,326 60% 5510-460-430840-241 CONSUMABLE TOOLS 0 1,500 1,500 100% 5510-460-430840-341 ELECTRICITY 782 1,600 818 51% 5510-460-430840-344 NATURAL GAS 554 7,000 6,446 92% 5510-460-430840-345 TELEPHONE & COMMUNICATION 249 700 451 64% 5510-460-430840-354 CONTRACT SERVICES 1,318 12,000 10,682 89% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 888 2,000 1,112 56% 5510-460-430840-366 BUILDING MAINTENANCE 84 2,500 2,416 97% 5510-460-430840-369 RADIO EQUIPMENT & MAINT. 1,300 1,700 400 24% 5510-460-430840-373 SCHOOL & TRAVEL 350 2,500 2,150 86% 5510-460-430840-388 MEDICAL SERVICES 134 550 417 76% 5510-460-430840-510 PROPERTY & LIABILITY INS. 10,008 12,500 2,492 20% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 6,500 6,500 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 15,167 26,000 10,833 42% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 17,497 29,995 12,498 42% 5510-460-430840-528 DATA PROCESSING TRANSFER 5,456 9,353 3,897 42% 5510-460-430840-532 OFFICE RENT 3,919 7,838 3,919 50% 5510-460-430845-224 JANITORIAL SUPPLIES 68 350 282 80% 5510-460-430845-341 ELECTRICITY 1,386 3,000 1,614 54% 5510-460-430845-342 WATER 157 350 193 55% 5510-460-430845-344 NATURAL GAS 433 9,500 9,067 95% 5510-460-430845-360 REPAIR & MAINT SERVICES 210 1,000 790 79% 5510-460-430845-366 BUILDING MAINTENANCE 281 1,000 719 72% 5510-460-510400-831 DEPRECIATION EXPENSE 0 100,000 100,000 100% TOTAL SOLID WASTE EXPENSE ---------------------- 303,729 ----------- 777,817 ---------- 474,088 61% Page 26 58.33% Yr Complete O1/18/11 CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 3,600 7,500 3,900 52% 5160-000-343063-000 TIE DOWN FEES 1,720 4,000 2,280 57% 5160-000-343069-000 HANGER LEASES 4,150 12,000 7,850 65% 5160-000-343071-000 HANGAR SITE LEASES 16,023 15,600 423- -3% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 8,314 16,545 8,231 50% 5160-000-343102-000 GROUND LEASES 11,054 11,054 0 0% 5160-000-343200-000 UTILITY REBATES 0 1,500 1,500 100% 5160-000-343620-000 FUEL TAX 2,765 6,000 3,235 54% 5160-000-371010-000 INVESTMENT EARNINGS 10,426 ----------- 15,000 ----------- 4,574 --------------------- 30% TOTAL AIRPORT REVENUE 58,052 89,199 31,147 35% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 17,030 33,801 16,771 50% 5160-430-430310-111 SEASONAL SALARIES 949 3,267 2,318 71% 5160-430-430310-153 HEALTH INSURANCE 2,486 3,182 696 22% 5160-430-430310-155 RETIREMENT 1,099 2,406 1,307 54% 5160-430-430310-210 OFFICE SUPPLIES 280 300 20 7% 5160-430-430310-218 NON -CAPITAL EQUIPMENT 0 750 750 100% 5160-430-430310-335 MEMBERSHIP & DUES 50 150 100 67% 5160-430-430310-341 ELECTRICITY 768 1,500 732 49% 5160-430-430310-345 TELEPHONE 426 1,000 574 57% 5160-430-430310-354 CONTRACT SERVICES 0 4,500 4,500 100% 5160-430-430310-355 CONTRACT SERVICES -MOWING 0 1,000 1,000 100% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 2,025 5,000 2,975 60% 5160-430-430310-357 CONTRACT SERVICES - legal 22,721 0 22,721- 0% 5160-430-430310-360 REPAIRS & MAINTENANCE 431 3,000 2,569 86% 5160-430-430310-362 EQUIPMENT MAINTENANCE 0 1,000 1,000 100% 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 3,436 2,000 1,436- -72% 5160-430-430310-373 TRAVEL 1,439 1,750 311 18% 5160-430-430310-380 SIGNAGE 0 300 300 100% 5160-430-430310-390 EQUIPMENT RENTAL 1,515 1,500 15- -1% 5160-430-430310-510 PROPERTY INSURANCE 1,068 6,000 4,932 82% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 2,605 4,465 1,860 42% 5160-430-430310-528 DATA PROCESSING TRANSFER 1,559 2,672 1,113 42% 5160-430-430310-820 DEPRECIATION 0 100,832 100,832 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 0 115,470 115,470 100% TOTAL AIRPORT OPERATIONS ---------------------- 59,886 ----------- 295,845 ---------- 235,959 80% DATA PROCESSING REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 87,469 174,937 87,469 50% 6030-000-364030-000 SALE OF MISCELLANEOUS 163 300 137 46% 6030-000-371010-000 INVESTMENT EARNINGS 952 2,323 1,371 59% 6030-000-393000-000 INTERNAL SERVICES -DATA 84,947 ---------------------- 145,624 ----------- 60,677 ---------- 42% TOTAL DATA PROCESSING REVENUE 173,531 323,184 149,653 46% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 38,890 73,787 34,897 47% 6030-401-410580-153 HEALTH INSURANCE 5,925 12,157 6,232 51% 6030-401-410580-155 RETIREMENT 2,532 4,790 2,258 47% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 0 1,370 1,370 100% 6030-403-410580-215 COMPUTER SUPPLIES 606 2,600 1,994 77% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 1,604 15,500 13,896 90% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 14,587 25,000 10,413 42% 6030-403-410580-346 SUMMIT NET T1 CONTRACT 1,799 6,816 5,017 74% 6030-403-410580-353 LASER FICHE MAINTENANCE 1,588 1,600 12 1% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 1,013 17,400 16,387 94% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 23,671 38,592 14,921 39% 6030-403-410580-356 ADG-Electronic Time Sheets 0 7,000 7,000 100% 6030-403-410580-357 GRANICUS 6,000 6,000 0 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 3,630 16,649 13,019 78% 6030-403-410580-373 SCHOOL & TRAVEL 0 6,200 6,200 100% 6030-403-410580-510 INSURANCE 1,190 1,350 160 12% 6030-403-410585-229 COPIER,FAX, SUPPLIES 319 6,000 5,681 95% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 31,973 70,000 38,027 54% Page 27 58.33% Yr Complete O1/18/11 FUND FUND CITY OF KALISPELL Quarterly Finance Report As of January 18, 2011 ACTUAL YTD BUDGET REMAINING g ------------------------------------------------------- 6030-403-410585-532 COPIER LEASES 6030-403-510400-831 DEPRECIATION EXPENSE 6030-404-410588-218 COMPUTERS - ATTORNEYS 6030-405-410588-940 COMPUTERS - 3 switches 6030-405-410588-942 COMPUTERS - CAPITAL OR CONTINGENCY 6030-410-410588-218 COMPUTERS - DPW 6030-413-410588-218 COMPUTERS - POLICE DEPT 6030-416-410588-218 COMPUTERS - FIRE 6030-420-410588-218 COMPUTERS - PLANNING DEPT 6030-436-410588-218 COMPUTERS - PARKS TOTAL DATA PROCESSING EXPENSE ---------------------------------------------- 15,003 30,000 14,997 50% 0 5,000 5,000 100% 0 1,370 1,370 100% 28,153 29,171 1,018 3% 8,932 13,000 4,068 31% 2,970 3,320 350 11% 369 9,147 8,778 96% 1,429 5,300 3,871 73% 1,000 1,000 0 0% 2,968 3,300 332 --------------------- 10% ---------------------- 196,149 413,419 217,270 53% Page 28 58.33% Yr Complete