Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
1st Quarter Finance Report
MONTANA _ Date October 22, 2010 TO: Mayor Fisher & City Council members Jane Howington, City Manager From: Amy Robertson Finance Director City of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 RE: V Qtr Finance Report — FY2011 (July — Sept 2010) Please find attached the printouts reflecting the activity for the V quarter of the fiscal year 2011. Since the September payroll was posted October l' I ran the printout thru the current date. This will catch September bills paid in October as well payroll thru October 9t''. This report has been updated to include new funds such as Safer Grant and Fire Hall Remodel Grant funds. All funds are included with the exception of the debt service funds, G. O. bonds, Walk & Curb and SID's. REVENUE: General Fund revenue has little activity as taxes will not be received until December. The tax receivables have been booked - for Enterprise funds, storm and solid waste, assessments are reflected as revenue when billed —pages 25 & 26 and not when collected. Street maintenance, Forestry and Lighting assessments will only be reflected when received (cash basis) -receivables are booked, offset by deferred revenue. We issued our first Impact fees with financing to The Villas. Impact fee revenue recognition is going to be reflected similar to special assessments. The full amount of the impact fee 100% will be booked in the Water, Sewer, WWTP and Storm funds as revenue with 20% going to cash and 80% to accounts receivable. The impact fees financed for police, fire and transportation will be booked as receivable and deferred revenue with no revenue recognition until collected. For this project the impact fee receivable for police is $49.92 financed over 5 years; fire $1,092 and transportation $355.20. It is unlikely that the County will give us six more lines on the tax bill so we will have to track each receipt by assessor number making a bit more work for the treasurer. The first payment will be November 2011 V half and May 2012 2" d half with interest calculated thru May 2012. EXPENDITURES: at this point in the year the salary remaining % is about 72%. Some seasonal salaries would be the exception- parks and recreation. Health insurance is paid in advance so 66% remaining. Please feel free to call with any questions. 758-7755. 10/22/10 CITY OF KALISPELL Page 1 Quarterly Finance Report OCTOBER 22, 2010 33.33% Yr Complete FUND 1000-000-311100-000 1000-000-311105-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-323109-000 1000-000-323300-000 1000-000-335030-000 1000-000-335076-000 1000-000-335110-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-342024-000 1000-000-342025-000 1000-000-343005-000 1000-000-351000-000 1000-000-351016-000 1000-000-351017-000 1000-000-362010-000 1000-000-362015-000 1000-000-364030-000 1000-000-365015-000 1000-000-371010-000 1000-000-381050-000 1000-000-381060-000 FUND ------------------------------------ GENERAL FUND - REVENUE REAL PROPERTY TAXES PILT-GL MANOR & TRESURE ST PLAZA PERSONAL PROPERTY TAXES PEN & INTEREST DEL. TAXES BEER & LIQUOR LICENSES BUSINESS LICENSES AMUSEMENT LICENSES PLANNING FEES EXCAV/DEMO/AIR/HOUSE MOVING PERMITS SITE REVIEW ANIMAL LICENSES M.V. TAX - AD VALOREM ST VIDEO -LIC FEE AND TAX DIST LIVE CARD TABLE PERMIT HB124 ENTITLEMENT ADMINISTRATIVE CHARGES BOND FEES/ADMIN.CHG. CITY COLLECTIONS BRESNAN FRANCHISE FEES POLICE SERVICES RESOURCE OFFICERS KPD REGIONAL TRAINING EPA GRANT -FIRE DEPT DIRECT REIMB. FIRE ENGINE RESPONSE FEE CENTRAL GARAGE CHARGE CITY COURT FINES & FEES DUI COURT FINE COURT SECURITY & TECHNOLOGY FEE CITY GOLF COURSE LEASE INSURANCE REIMBURSEMENTS SALE OF MISCELLANEOUS/AUCTION CONTRIBUTION FRM KIDSPORT INVESTMENT EARNINGS INCEPTION OF LEASE -POLICE CARS OPERATING TRANSFER- FUND 2372 TOTAL REVENUE ACTUAL YTD ----------------------------------------------- BUDGET REMAINING % 93,397 4,448,257 4,354,860 98% 0 7,818 7,818 100% 191,794 250,000 58,206 23% 9,208 25,000 15,792 63% 1,490 24,381 22,891 94% 225 1,200 975 81% 300 600 300 50% 6,992 65,000 58,008 89% 0 500 500 100% 0 8,500 8,500 100% 355 900 545 61% 0 2,100 2,100 100% 0 58,850 58,850 100% 0 2,650 2,650 100% 499,584 2,272,379 1,772,795 78% 168,419 490,321 321,902 66% 0 30,000 30,000 100% 198 1,500 1,302 87% 0 152,000 152,000 100% 5,391 15,000 9,609 64% 86,000 86,000 0 O a 756 10,000 9,244 92% 0 20,000 20,000 100% 30 6,500 6,470 100% 39,933 118,000 78,067 66% 134,479 475,000 340,521 72% 1,290 0 1,290- 0% 8,456 28,000 19,544 70% 0 25,000 25,000 100% 486 3,000 2,514 84% 13 500 488 98% 0 44,000 44,000 100% 8,518 55,000 46,482 85% 0 80,850 80,850 100% 0 ----------- 514,326 514,326 100% 1,257,314 ----------- 9,323,132 --------------------- 8,065,818 87% 10/22/10 FUND FUND CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 ACTUAL YTD BUDGET ------------------------------------------------------------------- GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 1000-400-410530-353 AUDITING 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1000-400-410560-312 POSTAGE 1000-400-410560-320 PRINTING 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1000-400-420000-354 CONTRACT 911 CENTER 1000-400-460446-354 KIDSPORT LEASE 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 1000-400-460452-366 HOCKADAY MAINTENANCE 1000-400-460452-920 CONRAD MANSION BUILDING IMPROVEMENT 1000-400-510300-000 CONTINGENCY 1000-400-510300-820 LOAN TO PARKING COMMISSION 1000-400-510310-354 ICMA PLAN FEES 1000-400-510330-513 LIABILITY INSURANCE 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 1000-400-510330-517 PROPERTY INSURANCE SUBTOTAL GEN.GOV'T. CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 1000-401-410210-153 HEALTH INSURANCE 1000-401-410210-155 RETIREMENT 1000-401-410210-215 COMPUTER SOFTWARE/SUPPLIES 1000-401-410210-229 OTHER SUPPLIES 1000-401-410210-312 NEWSLETTER 1000-401-410210-335 MEMBERSHIP & DUES 1000-401-410210-345 TELEPHONE & COMMUNICATION 1000-401-410210-373 SCHOOL & TRAVEL 1000-401-410210-379 MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES 1000-401-410830-110 SALARIES -PERSONNEL 1000-401-410830-153 HEALTH INSURANCE 1000-401-410830-155 RETIREMENT 1000-401-410830-210 OFFICE SUPPLIES 1000-401-410830-215 COMPUTER SUPPLIES 1000-401-410830-218 SMALL OFFICE EQUIP/FURNITURE 1000-401-410830-229 OTHER SUPPLIES 1000-401-410830-320 PRINTING 1000-401-410830-322 BOOKS 1000-401-410830-335 MEMBERSHIP & DUES 1000-401-410830-338 RECRUITMENT/NEGOTIATIONS 1000-401-410830-345 TELEPHONE 1000-401-410830-354 CONTRACT SERVICES 1000-401-410830-373 SCHOOL & TRAVEL SUBTOTAL HUMAN RESOURCES REMAINING % 0 1,000 1,000 100% 640 10,500 9,860 94% 1,434 3,000 1,566 52% 1,730 18,000 16,270 90% 1,308 5,850 4,542 78% 1,028 3,500 2,472 71% 0 352,266 352,266 100% 0 44,000 44,000 100% 0 15,000 15,000 100% 0 6,600 6,600 100% 2,500 2,500 0 0% 6,500 28,231 21,731 77% 0 15,000 15,000 100% 125 500 375 75% 238,877 247,000 8,123 3% 2,090 30,000 27,910 93% 36,083 50,000 13,917 28% 292,316 832,947 540,631 65% 33,945 124,038 90,093 73% 4,590 13,770 9,180 67% 3,599 13,350 9,751 73% 158 300 142 47% 20 850 830 98% 0 500 500 100% 0 2,000 2,000 100% 0 400 400 100% 100 1,000 900 90% 74 S00 426 85% ------------------- 42,486 ----------- 156,708 ---------- 114,222 73% 28,438 103,338 74,900 72% 5,078 15,236 10,158 67% 1,855 6,700 4,845 72% 0 300 300 100% 0 300 300 100% 0 200 200 100% 0 200 200 100% 0 100 100 100% 0 150 150 100% 260 400 140 35% 1,464 3,500 2,036 58% 14 150 136 91% 0 100 100 100% 57 3,500 3,443 98% ------------------- 37,166 ----------- 134,174 ---------- 97,008 72% Page 2 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- MEDIA SPECIALIST 1000-401-410900-110 MEDIA SPECIALIST -salary 5,339 20,102 14,763 73% 1000-401-410900-153 HEALTH INSURANCE 2,524 8,190 5,666 69% 1000-401-410900-155 RETIREMENT 359 1,299 940 72% 1000-401-410900-218 EQUIPMENT 15- 3,000 3,015 101% 1000-401-410900-354 CONTRACT SERVICES 450 2,500 2,050 82% SUBTOTAL MEDIA SPECIALIST ----------- 8,657 ----------- 35,091 --------------------- 26,434 75% MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 17,615 63,162 45,547 72% 1000-402-410100-153 HEALTH INSURANCE 10,580 31,815 21,235 67% 1000-402-410100-155 RETIREMENT 814 2,432 1,618 67% 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-373 SCHOOL & TRAVEL 2,168 3,000 832 28% 1000-402-410100-379 MEETINGS 0 300 300 100% SUBTOTAL MAYOR/COUNCIL ----------- 35,491 ----------- 105,720 --------------------- 70,229 66% CITY CLERK 1000-402-410150-110 SALARIES/CITY CLERK 23,188 80,620 57,432 71% 1000-402-410150-121 OVERTIME 117 500 383 77% 1000-402-410150-153 HEALTH INSURANCE 3,111 9,446 6,335 67% 1000-402-410150-155 RETIREMENT 1,517 5,049 3,532 70% 1000-402-410150-210 OFFICE SUPPLIES 19 150 131 87% 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 92 400 308 77% 1000-402-410150-352 RECODIFICATION 3,076 3,500 424 12% 1000-402-410150-354 CONTRACT SERVICES 0 25 25 100% SUBTOTAL CITY CLERK ----------- 31,346 ----------- 100,015 --------------------- 68,669 69% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 51,208 191,986 140,778 73% 1000-403-410550-153 HEALTH INSURANCE 10,448 30,604 20,156 66% 1000-403-410550-155 RETIREMENT 3,341 12,431 9,090 73% 1000-403-410550-322 BOOKS 0 300 300 100% 1000-403-410550-335 MEMBERSHIP & DUES 307 1,000 693 69% 1000-403-410550-345 TELEPHONE & COMMUNICATION 7 100 93 93% 1000-403-410550-353 CONTRACT SERVICES 595 1,000 405 41% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 300 1,500 1,200 80% 1000-403-410550-355 BANK CHARGES & FEES 760 3,000 2,240 75% 1000-403-410550-373 SCHOOL & TRAVEL 0 2,500 2,500 100% SUBTOTAL FINANCE ----------- 66,966 ----------- 244,421 ----------- ---------- 177,455 73% Page 3 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 84,569 307,944 223,375 73% 1000-404-411110-153 HEALTH INSURANCE 16,333 48,958 32,625 67% 1000-404-411110-155 RETIREMENT 5,517 19,972 14,455 72% 1000-404-411110-210 OFFICE SUPPLIES 169 1,200 1,031 86% 1000-404-411110-215 COMPUTER SUPPLIES 338 2,000 1,662 83% 1000-404-411110-322 BOOKS, CDs, LEXIS 5,395 7,000 1,605 23% 1000-404-411110-335 MEMBERSHIP & DUES 480 2,500 2,020 81% 1000-404-411110-345 TELEPHONE & COMMUNICATION 164 1,200 1,036 86% 1000-404-411110-354 CONTRACT SERVICES 196 5,000 4,804 96% 1000-404-411110-373 SCHOOL & TRAVEL 100 2,000 1,900 95% SUBTOTAL CITY ATTORNEY ----------- 113,262 ----------- 397,774 --------------------- 284,512 72% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 53,807 198,530 144,723 73% 1000-406-410360-121 OVERTIME 6 250 244 98% 1000-406-410360-153 HEALTH INSURANCE 13,108 38,881 25,773 66% 1000-406-410360-155 RETIREMENT 3,515 12,871 9,356 73% 1000-406-410360-210 OFFICE SUPPLIES 210 1,000 790 79% 1000-406-410360-213 OFFICE EQUIPMENT/MAINT. 108 1,000 893 89% 1000-406-410360-215 COMPUTER SUPPLIES 0 1,000 1,000 100% 1000-406-410360-229 OTHER SUPPLIES 297 1,500 1,203 80% 1000-406-410360-320 PRINTING 0 500 500 100% 1000-406-410360-335 MEMBERSHIP & DUES 200 300 100 33% 1000-406-410360-345 TELEPHONE & COMMUNICATION 159 1,400 1,241 89% 1000-406-410360-353 SECURITY & TECHNOLOGY 2,042 40,000 37,958 95% 1000-406-410360-354 CONTRACT SERVICES 2,480 5,750 3,270 57% 1000-406-410360-373 SCHOOL & TRAVEL 550 6,000 5,450 91% 1000-406-410360-394 JURY & WITNESS FEES 1,889 5,750 3,861 67% 1000-406-410360-395 DRUG COURT 117 1,000 883 88% 1000-406-410360-396 DUI COURT INCENTIVES & MISC 140 0 140- 0% SUBTOTAL COURT ---------------------- 78,629 ----------- 315,732 ---------- 237,103 75% DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 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 4,577 16,919 12,342 73% 967 2,901 1,934 67% 291 1,095 804 73% 240 775 535 69% 100 150 50 33% 0 300 300 100% 0 350 350 100% 47 350 303 87% 242 300 58 19% 0 350 350 100% 0 1,000 1,000 100% 33 150 117 78% 35 ----------- 400 365 91% ----------- 6,533 ----------- 25,040 ---------- 18,507 74% CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 48,577 178,259 129,682 73% 1000-410-431330-112 SALARIES -RETIREMENT 5,379 5,500 121 2% 1000-410-431330-121 OVERTIME 442 1,500 1,058 71% 1000-410-431330-153 HEALTH INSURANCE 9,416 37,356 27,940 75% 1000-410-431330-155 RETIREMENT 3,368 10,935 7,567 69% 1000-410-431330-210 OFFICE SUPPLIES 393 300 93- -31% 1000-410-431330-215 COMPUTER SUPPLIES 0 800 800 100% 1000-410-431330-218 EQUIPMENT (non -capital) 0 700 700 100% 1000-410-431330-221 SAFETY EQUIP & SUPPLIES 202 250 48 19% 1000-410-431330-229 OTHER SUPPLIES 2,077 3,600 1,523 42% 1000-410-431330-231 GAS & OIL 33,247 122,500 89,253 73% Page 4 33.33% Yr Complete 10/22/10 FUND FUND CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------- 1000-410-431330-232 MOTOR VEHICLE PARTS. 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-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-545 COUNTY LANDFILL 1000-412-411230-610 BOI 2004 DEBT (HVAC SYS) 1000-412-411230-620 BOI 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. ------------------------------------------- 24,261 76,000 51,739 68% 4,482 27,000 22,518 83% 1,325 3,500 2,175 62% 0 500 500 100% 0 150 150 100% 403 1,700 1,297 76% 52 100 48 48% 229 8,000 7,771 97% 13,315 52,000 38,685 74% 0 250 250 100% 284 335 51 15% 0 500 500 100% 50 350 301 86% -------- 147,503 ----------- 532,085 --------------------- 384,582 72% 154,035 557,125 403,090 72% 17,213 65,147 47,934 74% 0 200 200 100% 3,942 13,295 9,353 70% 1,082 3,976 2,894 73% 1,227 5,000 3,773 75% 22 750 728 97% 0 700 700 100% 10,063 41,000 30,937 75% 3,524 43,300 39,776 92% 32 250 218 87% 4,051 19,000 14,949 79% 0 4,500 4,500 100% 84 5,000 4,916 98% 3,527 15,500 11,973 77% 0 2,000 2,000 100% 7,736 15,561 7,825 50% 706 1,425 719 50% ------------------- 53,209 236,604 --------------------- 183,395 78% 70,412 257,172 186,760 73% 18,124 54,388 36,264 67% 4,595 16,671 12,076 72% 350 2,000 1,650 82% 0 1,000 1,000 100% 0 4,500 4,500 100% 0 500 500 100% 250 2,500 2,250 90% 90 1,300 1,210 93% 135 900 765 85% 430 1,300 871 67% 515 2,000 1,485 74% ------------------- 94,900 ----------- 344,231 ---------- 249,331 72% Page 5 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Page 6 Quarterly Finance Report OCTOBER 22, 2010 33.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 496,700 1,782,771 1,286,071 72% 1000-413-420140-114 SALARY -comptime buyout 0 6,500 6,500 100% 1000-413-420140-121 OVERTIME 19,343 75,000 55,657 74% 1000-413-420140-123 SPECIAL ASSIGNMENT OVERTIME 1,593 27,500 25,907 94% 1000-413-420140-153 HEALTH INSURANCE 106,913 306,282 199,369 65% 1000-413-420140-155 RETIREMENT 63,774 230,650 166,876 72% 1000-413-420140-210 OFFICE SUPPLIES 498 3,500 3,002 86% 1000-413-420140-215 COMPUTER SUPPLIES 1,403 5,500 4,097 75% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 0 10,500 10,500 100% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 1,322 5,000 3,678 74% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 80 7,000 6,920 99% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 60 2,000 1,940 97% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 1,323 5,000 3,677 74% 1000-413-420140-227 AMMO & RELATED SUPPLIES 5,116 17,000 11,884 70% 1000-413-420140-228 PATROL CAR SUPPLIES 1,034 13,000 11,966 92% 1000-413-420140-229 OTHER SUPPLIES 172 3,500 3,328 95% 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 34 1,000 966 97% 1000-413-420140-320 PRINTING 817 5,000 4,183 84% 1000-413-420140-335 MEMBERSHIP & DUES 120 1,250 1,130 90% 1000-413-420140-345 TELEPHONE & COMMUNICATION 3,174 15,000 11,826 79% 1000-413-420140-354 CONTRACT SERVICES 2,785 7,000 4,215 60% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 1,802 4,000 2,199 55% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 0 6,500 6,500 100% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 1,051 2,000 949 47% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 6,963 20,000 13,037 65% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 103 2,500 2,397 96% 1000-413-420140-373 SCHOOL & TRAVEL 8,242 26,000 17,758 68% 1000-413-420140-375 REGIONAL TRAINING 240 15,000 14,760 98% 1000-413-420140-376 TESTING (REIMBURSED) 0 2,000 2,000 100% 1000-413-420140-380 TRAINING MATERIALS 0 2,000 2,000 100% 1000-413-420140-388 MEDICAL SERVICES 148 4,000 3,852 96% 1000-413-420140-391 TREATMENT 17 500 483 97% 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 0 48,500 48,500 100% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 0 20,000 20,000 100% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 0 5,000 5,000 100% 1000-413-420140-944 VEHICLES 0 80,850 80,850 100% 1000-413-420141-110 DETECTIVE -SALARIES 95,846 333,564 237,718 71% 1000-413-420141-121 DETECTIVE -OVERTIME 3,628 20,000 16,372 82% 1000-413-420141-153 HEALTH INSURANCE 17,206 49,574 32,368 65% 1000-413-420141-155 DETECTIVE-RETIREMIENT 12,567 44,951 32,384 72% 1000-413-420142-110 RECORDS -SALARIES 18,778 71,499 52,721 74% 1000-413-420142-121 OVERTIME 1,327 7,500 6,173 82% 1000-413-420142-153 HEALTH INSURANCE 6,369 15,690 9,321 59% 1000-413-420142-155 RETIREMENT 1,293 9,984 8,691 87% 1000-413-420142-354 911 CONTRACT SERVICES 4,531 7,520 2,989 40% 1000-413-420144-110 SRO SALARIES 32,246 108,087 75,841 70% 1000-413-420144-153 HEALTH INSURANCE 5,132 15,432 10,300 67% 1000-413-420144-155 SRO RETIREMENT 3,993 14,411 10,418 72% SUBTOTAL POLICE DEPT. ----------- 928,249 ----------- 3,479,715 --------------------- 2,551,466 73% 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % FIRE DEPARTMENT 1000-416-420400-110 FIRE SUPPRESSION -SALARIES 333,917 1,456,971 1,123,054 77% 1000-416-420400-113 KELLY DAYS 7,056 0 7,056- 0% 1000-416-420400-121 OVERTIME 17,525 25,000 7,475 30% 1000-416-420400-153 HEALTH INSURANCE 85,248 236,879 151,631 64% 1000-416-420400-155 RETIREMENT 44,971 189,205 144,234 76% 1000-416-420400-210 OFFICE SUPPLIES 0 1,350 1,350 100% 1000-416-420400-213 SMALL OFFICE EQUIPMENT 0 500 500 100% 1000-416-420400-215 COMPUTER SUPPLIES 0 850 850 100% 1000-416-420400-218 Equipment (Non Capital) 2,292 7,500 5,208 69% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 2,440 15,000 12,560 84% 1000-416-420400-224 JANITORIAL SUPPLIES 595 1,500 905 60% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 4,022 15,000 10,978 73% 1000-416-420400-320 PRINTING 0 700 700 100% 1000-416-420400-322 BOOKS 0 1,000 1,000 100% 1000-416-420400-333 SUBSCRIPTIONS 0 250 250 100% 1000-416-420400-335 MEMBERSHIP & DUES 399 350 49- -14% 1000-416-420400-341 ELECTRICITY -STATION 62 1,579 9,500 7,921 83% 1000-416-420400-344 NATURAL GAS -STATION 62 547 10,000 9,453 95% 1000-416-420400-345 TELEPHONE & COMMUNICATION 997 8,500 7,503 88% 1000-416-420400-354 CONTRACT SERVICES 2,192 8,000 5,808 73% 1000-416-420400-362 EQUIPMENT MAINTENANCE 4,236 6,500 2,264 35% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 161 2,500 2,339 94% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,231 10,500 9,269 88% 1000-416-420400-373 SCHOOL & TRAVEL 246 2,500 2,254 90% 1000-416-420400-379 MEETINGS 143 500 357 71% 1000-416-420400-380 TRAINING MATERIALS 7,142 13,300 6,158 46% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 26,558 53,578 27,020 50% 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 6,433 12,443 6,010 48% 1000-416-420440-110 FIRE PREVENTION -SALARIES 11,375 33,134 21,760 66% 1000-416-420440-153 HEALTH INSURANCE 2,280 6,608 4,328 66% 1000-416-420440-155 RETIREMENT 706 2,203 1,497 68% SUBTOTAL FIRE DEPT. ----------- 564,291 ----------- 2,131,821 --------------------- 1,567,530 74% GRAND TOTAL GENERAL FUND 2,501,004 9,072,078 6,571,074 72% Page 7 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Page 8 Quarterly Finance Report OCTOBER 22, 2010 33.33% Yr Complete 2185-000-430300-353 2185-000-430300-356 2185-000-430300-522 2185-480-470240-110 2185-480-470240-153 2185-480-470240-155 2188-453-430246-952 2188-453-430246-953 2188-480-470230-110 2188-480-470230-153 2188-480-470230-155 2188-480-470230-353 2188-480-470230-354 2188-480-470230-522 2188-480-470230-955 FUND ---------------------- SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF AUDITING REDEVELOPMENT / CONTRACT SERVICES ADMINISTRATIVE TRANSFER SALARIES HEALTH INSURANCE RETIREMENT TOTAL AIRPORT TIF 2188 WESTSIDE TIF LOWER SPRING CREEK 3 MILE DR ROAD DESIGN SALARIES HEALTH INSURANCE RETIREMENT AUDIT TO PORT/GATEWAY W. BLDG MAINT ADMINISTRATIVE TRANSFER CD -REDEVELOPMENT ACTIVITY TOTAL WESTSIDE TIF ACTUAL YTD BUDGET REMAINING % 0 1,200 1,200 100% 0 15,000 15,000 100% 4,650 13,949 9,299 67% 4,781 16,590 11,809 71% 635 1,909 1,274 67% 311 1,077 766 71% ---------------------- 10,377 ----------- 49,725 ---------- 39,348 79% 0 70,000 0 55,000 3,023 11,060 397 2,032 197 718 0 1,250 0 5,000 8,333 25,000 0 2,091,138 ----------- 11,949 ----------- 2,261,198 70,000 100% 55,000 100% 8,037 73% 1,635 80% 521 73% 1,250 100% 5,000 100% 16,667 67% 2,091,138 100% 2,249,249 99% 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 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 3,675 ----------- 56,000 --------------------- 52,325 93% ----------- 2215 NEW PARKS & REC. FUND ----------- ----------- ---------- REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 12,555 845,000 832,445 99% 2215-000-311200-000 PERSONAL PROPERTY TAXES 35,758 38,000 2,242 6% 2215-000-312000-000 PEN & INTEREST DEL TAXES 764 1,000 236 24% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 0 5,000 5,000 100% 2215-000-346030-000 SWIMMING POOL FEES 78,597 140,000 61,403 44% 2215-000-346040-000 CONCESSION STAND REVENUE 23,667 32,500 8,833 27% 2215-000-346050-000 Parks Usage Fees 7,253 18,000 10,747 60% 2215-000-346051-000 RECREATION FEES 2,241 9,568 7,327 77% 2215-000-346052-000 SPORTS PROGRAMS 11,570 32,438 20,868 64% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 518 3,500 2,982 85% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 9,880 24,978 15,099 60% 2215-000-346055-000 ICE RINK 0 20,000 20,000 100% 2215-000-346057-000 YOUTH CAMPS 23,654 83,650 59,996 72% 2215-000-346059-000 PICNIC IN THE PARK 4,965 26,000 21,035 81% 2215-000-371010-000 INVESTMENTS/DONATIONS/MISC.SALES 114 2,000 1,886 94% 2215-000-381050-000 INCEPTION OF LEASE 0 85,309 85,309 100% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 63,000 63,000 100% ----------- TOTAL PARKS & REC REVENUE 211,535 ----------- 1,429,943 --------------------- 1,218,408 85% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 69,561 259,451 189,890 73% 2215-436-460430-111 SEASONAL SALARIES 22,101 36,988 14,887 40% 2215-436-460430-121 OVERTIME 0 1,000 1,000 100% 2215-436-460430-153 HEALTH INSURANCE 20,862 62,741 41,879 67% 2215-436-460430-155 RETIREMENT 5,065 18,396 13,331 72% 2215-436-460430-210 OFFICE SUPPLIES 146 1,200 1,054 88% 2215-436-460430-213 SMALL OFFICE EQUIPMENT 0 800 800 100% 2215-436-460430-215 COMPUTER SUPPLIES 0 1,000 1,000 100% 2215-436-460430-221 SAFETY EQUIPMENT 205 900 695 77% 10/22/10 CITY OF KALISPELL Page 9 Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % 2215-436-460430-224 JANITORIAL SUPPLIES 1,369 3,000 1,631 54% 2215-436-460430-229 OTHER SUPPLIES 679 4,500 3,821 85% 2215-436-460430-241 CONSUMABLE TOOLS/SMALL EQUIPMENT 964 1,600 636 40% 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 6,326 14,250 7,924 56% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 120 20,000 19,880 99% 2215-436-460430-344 NATURAL GAS 194 3,200 3,006 94% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 280 3,000 2,720 91% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 1,500 1,500 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 0 6,500 6,500 100% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT MAINTENANCE 264 2,500 2,236 89% 2215-436-460430-364 LANDSCAPING 45 4,000 3,955 99% 2215-436-460430-366 BUILDING MAINTENANCE 437 5,500 5,063 92% 2215-436-460430-367 VANDALISM REPAIRS 87 4,000 3,913 98% 2215-436-460430-373 SCHOOL & TRAVEL 400 1,200 800 67% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 134 550 417 76% 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 285 2,000 1,715 86% 2215-436-460430-440 IRRIGATION SUPPLIES 1,183 4,000 2,817 70% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 972 4,000 3,029 76% ----------- TOTAL PARKS EXPENDITURES 132,060 ----------- 472,482 --------------------- 340,422 72% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 8,527 30,568 22,041 72% 2215-436-460440-111 SEASONAL SALARIES 22,094 52,101 30,007 58% 2215-436-460440-153 HEALTH INSURANCE 2,205 6,624 4,419 67% 2215-436-460440-155 RETIREMENT 1,106 4,127 3,021 73% 2215-436-460440-221 SAFETY EQUIPMENT 161 175 14 8% 2215-436-460440-229 OTHER SUPPLIES 3,262 16,000 12,738 80% 2215-436-460440-241 CONSUMABLE TOOLS 180 700 520 74% 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 33 350 317 91% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 287 500 213 43% 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 0 85,309 85,309 100% ----------- TOTAL ATHLETIC COMPLEX ----------- 40,531 ----------- 218,539 ---------- 178,008 81% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 24,215 89,740 65,525 73% 2215-436-460431-111 SEASONAL SALARIES 2,890 9,530 6,640 70% 2215-436-460431-153 HEALTH INSURANCE 5,986 18,667 12,681 68% 2215-436-460431-155 RETIREMENT 1,509 6,118 4,609 75% 2215-436-460431-210 OFFICE SUPPLIES 49 600 551 92% 2215-436-460431-229 OTHER SUPPLIES 2,544 9,800 7,256 74% 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 750 750 100% 2215-436-460431-337 ADVERTISING 0 500 500 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 65 600 535 89% 2215-436-460431-354 CONTRACT SERVICES 13,154 19,950 6,796 34% 2215-436-460431-355 BANK FEES/CREDIT CARD FEES 664 2,500 1,836 73% 2215-436-460431-373 SCHOOL & TRAVEL 0 800 800 100% 33.33% Yr Complete 10/22/10 FUND CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------------------------------------------------------------- ------------------------------------------- TOTAL RECREATION 51,077 165,655 114,578 69% 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 17,950 66,982 49,032 73% 35,986 78,658 42,672 54 0 0 500 500 100% 5,648 16,952 11,304 67% 1,113 5,244 4,131 79% 29 300 271 90% 1,338 4,050 2,712 67% 0 300 300 100% 0 100 100 100s 0 300 300 100% 0 400 400 100% 3,749 13,000 9,251 71% 88 2,000 1,912 96% 0 500 500 100% ----------- 65,900 ----------- 189,286 --------------------- 123,386 65% 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% 3,961 12,500 8,539 68% 13,362 24,000 10,638 44% 466 1,500 1,034 69% 418 1,300 882 68% 579 4,000 3,421 86% 2,008 2,400 392 16% 0 ----------- 250 250 100% 175,506 ---------------------- 298,610 ---------- 123,104 41% 465,074 1,344,572 879,498 65% Page 10 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING ---------------------------------------------------------------------------------------------------------------- 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 150,889 650,000 499,111 77% 2230-000-342070-000 COUNTY EMS LEVY 0 102,000 102,000 100% 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC 900 0 900- 0% 2230-000-371010-000 INTEREST EARNINGS 406 500 94 19% TOTAL AMBULANCE REVENUE ----------- 152,195 ----------- 752,500 --------------------- 600,305 80% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 78,785 405,542 326,757 81% 2230-440-420730-113 KELLY DAYS 1,724 10,000 8,276 83% 2230-440-420730-121 OVERTIME 1,334 6,000 4,666 78% 2230-440-420730-153 HEALTH INSURANCE 17,630 78,704 61,074 78% 2230-440-420730-155 RETIREMENT 10,412 53,393 42,981 81% 2230-440-420730-210 OFFICE SUPPLIES 59 750 691 92% 2230-440-420730-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 2230-440-420730-215 COMPUTER SUPPLIES 0 2,000 2,000 100% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 997 2,000 1,003 50% 2230-440-420730-231 GAS AND OIL 1,280 10,000 8,720 87% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 679 5,000 4,321 86% 2230-440-420730-312 POSTAGE 445 3,000 2,555 85% 2230-440-420730-320 PRINTING 0 500 500 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 615 700 85 12% 2230-440-420730-353 AUDITING 0 500 500 100% 2230-440-420730-354 CONTRACT SERVICES/RECERT. 5,206 8,000 2,794 35% 2230-440-420730-359 CC FEES/COLLECTION SERV. 117 500 383 77% 2230-440-420730-362 EQUIPMENT MAINTENANCE 1,124 3,500 2,376 68% 2230-440-420730-369 RADIO MAINTENANCE 0 2,500 2,500 100% 2230-440-420730-380 TRAINING MATERIALS 54 8,000 7,946 99% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 6,267 22,500 16,233 72% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 8,200 35,000 26,800 77% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 14,036 16,100 2,064 13% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 3,000 9,000 6,000 67% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 11,003 33,010 22,007 67% 2230-440-420730-528 DATA PROCESSING TRANSFER 3,563 10,689 7,126 67% 2230-440-420730-943 AMBULANCE 0 50,000 50,000 100% TOTAL AMBULANCE FUND ----------- 166,531 ----------- 777,088 --------------------- 610,557 79% 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 0 40,000 40,000 100% TOTAL 2310 OLD SCHOOL TECH TIF ----------- 0 ----------- ----------- 40,950 ----------- --------------------- 40,950 -------------------- 100% 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 33.33% Yr Complete 10/22/10 FUND FUND CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 ACTUAL YTD BUDGET REMAINING % ----------------------------------------------------- 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 2394-000-323103-000 PLUMBING PERMITS 2394-000-323104-000 MECHANICAL PERMITS 2394-000-323107-000 HOUSE MOVING PERMITS 2394-000-323108-000 PLAN REVIEW FEES 2394-000-341025-000 MISC. COLLECTIONS/FEES 2394-000-343380-000 PUBLIC SAFETY BLDG CONTRACT MGMT 2394-000-371010-000 INVESTMENT EARNINGS TOTAL REVENUE BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 2394-420-420530-121 OVERTIME 2394-420-420530-153 HEALTH INSURANCE 2394-420-420530-155 RETIREMENT 2394-420-420530-210 OFFICE SUPPLIES 2394-420-420530-215 COMPUTER SUPPLIES 2394-420-420530-229 OTHER SUPPLIES 2394-420-420530-231 GAS & OIL 2394-420-420530-312 POSTAGE 2394-420-420530-320 PRINTING 2394-420-420530-322 BOOKS 2394-420-420530-323 ST. ED. ASSESSMENTS 2394-420-420530-331 PUBLICATION & FILING FEES 2394-420-420530-335 MEMBERSHIP & DUES 2394-420-420530-345 TELEPHONE & COMMUNICATION 2394-420-420530-353 AUDITING 2394-420-420530-354 CONTRACT SERVICES 2394-420-420530-366 BUILDING MAINTENANCE 2394-420-420530-373 SCHOOL & TRAVEL 2394-420-420530-510 PROPERTY INSURANCE 2394-420-420530-521 CENTRAL GARAGE TRANSFER 2394-420-420530-522 ADMINISTRATIVE TRANSFER 2394-420-420530-528 DATA PROCESSING TRANSFER TOTAL BUILDING DEPT. 74,309 150,000 75,691 50% 7,195 12,000 4,805 40% 9,155 20,000 10,846 54% 75 200 125 63% 37,200 50,000 12,800 26% 136 0 136- 0% 0 38,000 38,000 100% 170 100 70- -70% ---------------------- 128,239 270,300 --------------------- 142,061 53% 51,597 182,897 131,300 72% 0 2,000 2,000 100% 11,148 35,160 24,012 68% 3,219 11,299 8,080 72% 15 2,000 1,985 99% 0 2,500 2,500 100% 17 750 733 98% 289 2,250 1,961 87% 162 600 438 73% 128 300 172 57% 333 1,500 1,167 78% 0 2,500 2,500 100% 0 200 200 100% 105 900 795 88% 282 1,500 1,218 81% 0 3,000 3,000 100% 390 500 110 22% 0 800 800 100% 249 2,000 1,751 88% 3,864 4,250 386 9% 100 300 200 67% 667 2,000 1,333 67% 445 1,336 891 67% 73,011 260,542 187,531 72% 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 0 4,800 4,800 100% 2399-413-420140-354 IMPACT FEE REVIEW 500 500 0 0% 2399-413-420140-940 POLICE EQUIPMENT 0 20,000 20,000 100% 2399-416-420400-354 IMPACT FEE REVIEW 500 500 0 0% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 12,750 25,750 13,000 50% 2399-416-420400-620 INTEREST - FIRE TRUCK 4,819 9,190 4,371 48% 2399-416-420400-944 FIRE- LADDER TRUCK 37,475 225,000 187,525 83% TOTAL 2399 IMPACT FEE FUND ---------------------- 56,045 ----------- 285,740 ---------- 229,695 80% 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 10,924 43,656 32,732 75% 2400-410-430263-153 HEALTH INSURANCE 3,010 9,329 6,319 68% 2400-410-430263-155 RETIREMENT 688 2,688 2,000 74% 2400-410-430263-244 STREET LIGHT SUPPLIES 818 13,000 12,182 94% 2400-410-430263-341 ELECTRICITY 34,803 163,000 128,197 79% 2400-410-430263-360 REPAIR & MAINT SERVICES 724 28,000 27,276 97% 2400-410-430263-510 INSURANCE 774 1,000 226 23% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 2,374 7,121 4,747 67% TOTAL LIGHT MAINT. ----------- ----------- 54,114 ----------- 267,794 ---------- 213,680 80% Page 12 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Page 13 Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 14,380 41,000 26,620 65% 2420-421-430234-957 ALLEY PAVING 25,912 25,000 912- -4% 2420-421-430240-231 GAS & OIL 5,175 30,000 24,825 83% 2420-421-430240-344 NATURAL GAS 291 3,500 3,209 92% 2420-421-430240-354 CONTRACT SERVICES 338 149,663 149,326 100% 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 5,118 50,000 44,882 90% 2420-421-430240-472 ASPHALT 8,237 30,000 21,763 73% 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 59,450 ----------- 560,363 --------------------- 500,913 89% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 152,190 607,879 455,689 75% 2500-421-430240-121 OVERTIME 874 30,000 29,126 97% 2500-421-430240-153 HEALTH INSURANCE 44,153 122,708 78,555 64% 2500-421-430240-155 RETIREMENT 9,564 37,403 27,839 74% 2500-421-430240-213 SMALL OFFICE EQUIPMENT 0 500 500 100% 2500-421-430240-216 COMPUTER EQUIPMENT 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 611 1,200 589 49% 2500-421-430240-224 JANITORIAL SUPPLIES 9 700 691 99% 2500-421-430240-229 OTHER SUPPLIES 375 1,200 825 69% 2500-421-430240-231 GAS & OIL 5,175 30,000 24,825 83% 2500-421-430240-241 CONSUMABLE TOOLS 317 2,000 1,683 84% 2500-421-430240-341 ELECTRICITY 231 1,200 969 81% 2500-421-430240-342 WATER/SEWER CHARGES 52 175 123 71; 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 183 1,000 817 82% 2500-421-430240-354 CONTRACT SERVICES 907 13,000 12,093 93% 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 2,117 23,000 20,883 91% 2500-421-430240-366 BUILDING MAINTENANCE 0 1,500 1,500 100% 2500-421-430240-369 RADIO EQUIPMENT & MAINT. 0 5,000 5,000 100% 2500-421-430240-373 SCHOOL & TRAVEL 33 2,500 2,467 99% 2500-421-430240-388 MEDICAL SERVICES 134 1,300 1,167 90% 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 22,000 66,000 44,000 67% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 18,914 56,741 37,827 67% 2500-421-430240-528 DATA PROCESSING TRANSFER 3,563 10,689 7,126 67% 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 120,882 458,908 338,026 74% 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 44,205 140,606 96,401 69% 2500-421-430264-121 OVERTIME 2,507 8,500 5,993 71% 2500-421-430264-153 HEALTH INSURANCE 5,925 17,805 11,880 67% 2500-421-430264-155 RETIREMENT 2,889 8,803 5,914 67% 2500-421-430264-216 COMPUTER EQUIP & SOFTWARE 46 1,500 1,454 97% 2500-421-430264-218 EQUIPMENT(non-capital) 485 4,800 4,315 90% 2500-421-430264-221 SAFETY EQUIPMENT & SUPPLIES 1,393 500 893- -179% 2500-421-430264-224 JANITORIAL SUPPLIES 140 650 511 79% 2500-421-430264-229 OTHER SUPPLIES 70 800 730 91% 2500-421-430264-241 CONSUMABLE TOOLS 419 1,100 681 62% 2500-421-430264-242 STREET SIGNS 15,981 38,000 22,019 58% 2500-421-430264-243 TRAFFIC SIGNALS 942 10,000 9,058 91% 2500-421-430264-245 BARRICADE MATERIALS 0 4,000 4,000 100% 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Page 14 Quarterly Finance Report OCTOBER 22, 2010 33.33% Yr Complete FUND FUND ----------------------------------------------- 2500-421-430264-341 ELECTRICITY 2500-421-430264-345 COMMUNICATIONS 2500-421-430264-354 CONTRACT SERVICES 2500-421-430264-362 EQUIPMENT MAINTENANCE 2500-421-430264-366 BUILDING MAINTENANCE 2500-421-430264-369 RADIO MAINTENANCE 2500-421-430264-373 SCHOOL & TRAVEL 2500-421-430264-428 PAINT MATERIALS 2500-421-430264-510 LIABILITY INS.-TSS 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 2500-421-430264-532 OFFICE RENT 2600-436-460433-110 2600-436-460433-121 2600-436-460433-153 2600-436-460433-155 2600-436-460433-210 2600-436-460433-229 2600-436-460433-241 2600-436-460433-333 2600-436-460433-354 2600-436-460433-358 2600-436-460433-362 2600-436-460433-364 2600-436-460433-373 2600-436-460433-510 2600-436-460433-521 2600-436-460433-522 2600-436-460433-528 2600-436-460433-610 2600-436-460433-620 2600-436-460433-940 TOTAL SPEC. ST. MAINT. 2600 URBAN FORESTRY FUND SALARIES -URBAN FORESTRY OVERTIME HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES OTHER SUPPLIES CONSUMABLE TOOLS SUBSCRIPTIONS CONTRACT SERVICES DUTCH ELM DISEASE/tree disposal EQUIPMENT MAINTENANCE LANDSCAPING & TREES SCHOOL & TRAVEL LIABILITY & PROPERTY INSURANCE CENTRAL GARAGE TRANSFER ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER DEBT SERVICE PRINCIPAL INTEREST EXPENSE MACHINERY & EQUIPMENT TOTAL URBAN FORESTRY ACTUAL YTD BUDGET 1,442 10,000 145 700 3,381 10,000 775 1,400 0 1,500 0 900 442 2,500 0 20,000 3,674 4,050 0 2,000 3,919 ----------- 7,838 572,712 ----------- 2,051,116 37, 667 0 9,333 2,377 0 34 412 0 0 0 316 691 0 3,570 833 2,542 445 0 0 18,101 76,322 141,593 750 28,935 8,744 50 500 950 50 1,500 10,000 500 7,000 250 6,000 2,500 7,626 1,336 2,000 215 21,000 241,499 REMAINING % --------------------- 8,558 86% 555 79% 6,619 66% 625 45% 1,500 100% 900 100% 2,058 82% 20,000 100% 376 9% 2,000 100% 3,919 50% 1,478,404 72% 103,926 750 19,602 6,367 50 466 538 50 1,500 10,000 184 6,310 250 2,430 1,667 5,084 891 2,000 215 2,899 165,177 68% 73% 100% 68% 73% 100% 93% 57% 100% 100% 100% 37% 90% 100% 40% 67% 67% 67% 100% 100% 14% 2602 ARRA FORESTRY GRANT 2602-436-460433-354 CONTRACT SERVICES 18,284 24,561 6,277 26% ----------- TOTAL ARRA FORESTRY GRANT 18,284 ----------- ----------- 24,561 ---------- 6,277 26% 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 SUBD ($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% 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 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 0 225,000 225,000 100% TOTAL LOAN REVOLVING ----------- 0 ----------- 225,000 --------------------- 225,000 100% 2886 UDAG FUND 2886-480-470210-110 SALARIES - UDAG 15,392 55,988 40,596 73% 2886-480-470210-153 HEALTH INSURANCE 2,195 6,363 4,168 66% 2886-480-470210-155 RETIREMENT 1,009 3,618 2,609 72% 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 20 300 280 93% 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 0 500 500 100% 2886-480-470210-335 MEMBERSHIP & DUES 380 700 320 46% 2886-480-470210-345 TELEPHONE & COMMUNICATION 36 750 714 95% 2886-480-470210-353 AUDITING 0 1,500 1,500 100% 2886-480-470210-354 CONTRACT SERVICES 0 1,000 1,000 100% 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 312 1,000 688 69% 2886-480-470210-379 MEETINGS 0 500 500 100% 2886-480-470210-381 TRAINING 192 1,000 808 81% 2886-480-470210-396 STUDIES/SURVEYS 3,000 25,000 22,000 88% 2886-480-470210-510 PROPERTY & LIABILITY INS. 2,975 3,800 825 22% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 2,224 6,671 4,447 67% 2886-480-470210-528 DATA PROCESSING TRANSFER 2,227 6,680 4,453 67% 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 ----------- 32,519 ----------- 132,373 --------------------- 99,854 75% RURAL DEVELOPMENT REVOLVING 2887-480-470210-110 SALARIES 7,609 27,776 20,167 73% 2887-480-470210-153 HEALTH INSURANCE 1,058 3,182 2,124 67% 2887-480-470210-155 RETIREMENT 495 1,795 1,300 72% 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 0 17,213 17,213 100% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 4,861 4,861 100% 2887-480-470210-750 REDEVELOPMENT LOANS 0 215,000 215,000 100% TOTAL RURAL DEVELOPMENT ----------- 9,163 ----------- 269,827 --------------------- 260,664 97% 2888 RURAL DEV. #2 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-02 0 10,930 10,930 100% 2888-480-470210-750 REDEVELOPMENT LOANS 0 85,000 85,000 100% TOTAL 2888 RURAL DEV. #2 ----------- 0 ----------- 95,930 --------------------- 95,930 100% Page 15 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2944 CDBG-ED FVCC 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% 2944-480-470242-820 ADMIN TRANSFER - to Com Development 0 3,428 3,428 100% TOTAL 2944 CDBG-ED FVCC ----------- 0 ----------- 81,518 ----------- ---------- 81,518 100% 2944 CDBG-ED FVCC #2 >, ----------- D-7t , ----------- --------------------- TOTAL 2946 CDBG-ED FVCC #2 0 0 0 0% 2953 EPA BROWNSFIELD GRANT 2953-480-470210-780 SITE ASSESSMENT GRANT EXPENSE 9,199 ----------- 396,152 386,953 98% TOTAL EPA BROWNSFIELD GRANT 9,199 ----------- 396,152 --------------------- 386,953 98% 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN 5,562 26,998 21,436 79s TOTAL 2915 STONEGARDEN GRANT ----------- 5,562 ----------- 26,998 --------------------- 21,436 79% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 17,955 62,650 44,695 71% 2916-413-420140-121 OVERTIME 1,089 11,000 9,911 90% 2916-413-420140-153 HEALTH INSURANCE 2,116 6,363 4,247 67% 2916-413-420140-155 RETIREMENT 2,357 8,443 6,086 72% 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 ----------- 23,517 ----------- 91,856 --------------------- 68,339 74% 2917 COPS TECHNOLOGY GRANT 2917-413-420140-950 SHOOTING FACILITY TOTAL 2917 COPS TECHNOLOGY GT 2918 COPS HIRING RECOVERY GT 2918-413-420140-110 SALARIES & PAYROLL COSTS 2918-413-420140-153 HEALTH INSURANCE 2918-413-420140-155 RETIREMENT TOTAL 2918 COPS HIRING GRANT 0 750,000 750,000 100% ---------------------------------- 0 750,000 750,000 100% 14,767 49,878 35,111 70% 4,590 13,770 9,180 67% 1,956 ----------- 6,722 4,766 71% ----------- 21,313 ----------- 70,370 ---------- 49,057 70% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 929 2,000 1,071 54% 2919-413-420140-125 DUI TASK FORCE 556 10,000 9,444 94% 2919-413-420140-126 HOLIDAY OT REIMB. 10,349 38,000 27,651 73% 2919-413-420140-127 SCHOOL DIST. OT 3,812 20,000 16,188 81% 2919-413-420140-218 JAG GRANT- E Tickets Equip/supplies 14,377 17,845 3,468 19% 2919-413-420140-219 EQUIPMENT: NON - CAPITAL 0 10,000 10,000 100% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 0 5,000 5,000 100% 2919-413-420140-221 Bullet Proof Vests 780 10,000 9,220 92% 2919-413-420143-218 JAG GET 2010-DJ-BX-1015 VIDEO/EQUIP 0 19,189 19,189 100% ----------- TOTAL LAW ENF. GRANT ----------- 30,804 ----------- 132,034 ---------- 101,230 77% 2921 DRUG COURT GRANT 2921-406-410360-354 DRUG COURT -contract services 10,793 326,262 315,469 97% ----------- TOTAL DRUG COURT GRANT ----------- 10,793 ----------- 326,262 ---------- 315,469 97% Page 16 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- 2951 DUI COURT GRANT 2951-406-410360-355 CONTRACT SERVICES - DRUG & ALCOHOL 0 31,436 31,436 100% 2951-406-410361-354 CS -EVALUATOR, PO,LAC 2010-18-21-02 27,193 10,788 16,405- -152% ------------------------------------------- TOTAL DUI COURT GRANT 27,193 42,224 15,031 36% 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 151 10,000 9,849 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 346 1,436 1,090 76% 2957-416-420400-218 EQUIPMENT (non capital) 0 34,109 34,109 100% 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 2,669 20,000 17,332 87% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 4,476 31,125 26,649 86% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 5,000 5,000 100% 2957-416-420414-218 AFG EQUIPMENT AND SAFETY($137,000) 52,489 123,246 70,757 57% ------------------------------------------- TOTAL FEMA GRANT 60,131 273,480 213,349 78% 2975 ISTEA 2975-436-460457-950 WOODLAND CONNECTOR 19,027 265,000 245,973 93% ------------------------------------------- TOTAL ISTEA 19,027 265,000 245,973 93% 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 13,737 88,700 74,963 85% ------------------------------------------- TOTAL 2992 NEIGHBORHOOD STABIL 13,737 88,700 74,963 85% ------------------------------------------- 2992 ENERGY BLOCK GRANT 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS 13,737 88,700 74,963 85% ------------------------------------------- TOTAL 2992 ENERGY BLOCK GRANT 13,737 88,700 74,963 85% 2993 STIMULUS ENERGY #2 2993-412-411230-925 ENERGY IMPROVEMENTS 0 103,000 103,000 100% ------------------------------------------- TOTAL 2993 STIMULUS ENERGY #2 0 103,000 103,000 100% 2995 SAFER GRANT 2995-416-420400-110 SALARIES 2995-416-420400-153 HEALTH INSURANCE 2995-416-420400-155 RETIREMENT TOTAL 2995 SAFER GRANT 5,018 135,000 129,982 96% 3,141 34,000 30,859 91% 683 18,000 17,317 96% ------------------------------------------- 8,842 187,000 178,158 95% Page 17 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET ---------------------------------------------------------------------------------- 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 REMAINING % -------------- 66,246 1,258,398 1,192,152 95% ------------------------------------------- 66,246 1,258,398 1,192,152 95% 0 25,000 25,000 100% ------------------------------------------- 0 25,000 25,000 100% 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% Page 18 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Page 19 Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ENTERPRISE FUNDS WATER REVENUE 5210-000-343210-000 METERED WATER SALES 927,137 2,450,000 1,522,863 62% 5210-000-343220-000 UNMETERED WATER SALES 2,436 5,000 2,564 51% 5210-000-343225-000 IMPACT FEES 100,698 220,000 119,302 54% 5210-000-343230-000 METER REPLACEMENT FEE 27,960 95,000 67,040 71% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 1,065 12,000 10,935 91% 5210-000-343270-000 WATER TURN ON FEES 1,095 3,000 1,905 64% 5210-000-343275-000 TAG FEE 7,320 20,000 12,680 63% 5210-000-371010-000 INVESTMENT EARNINGS 14,701 52,500 37,799 72% TOTAL WATER REVENUE ----------- 1,082,412 ----------- 2,857,500 --------------------- 1,775,088 62% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 188,350 691,214 502,864 73% 5210-447-430550-112 SALARIES -RETIREMENT 0 4,400 4,400 100% 5210-447-430550-121 OVERTIME 4,570 20,500 15,930 78% 5210-447-430550-153 HEALTH INSURANCE 40,010 150,401 110,391 73% 5210-447-430550-155 RETIREMENT 12,100 42,900 30,800 72% 5210-447-430550-210 OFFICE SUPPLIES 54 450 396 88% 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 989 3,000 2,011 67% 5210-447-430550-216 COMPUTER EQUIPMEMT 1,276 5,000 3,724 74% 5210-447-430550-218 EQUIPMENT (NON CAPITAL) 4,930 10,200 5,270 52% 5210-447-430550-221 SAFETY EQUIP & SUPPLIES 1,910 3,700 1,790 48% 5210-447-430550-224 JANITORIAL SUPPLIES 30 800 770 96% 5210-447-430550-226 CHLORINE & CHEMICALS 4,275 33,000 28,725 87% 5210-447-430550-229 OTHER SUPPLIES 195 1,500 1,305 87% 5210-447-430550-231 GAS & OIL 4,896 27,000 22,104 82% 5210-447-430550-241 CONSUMABLE TOOLS 66 2,500 2,434 97% 5210-447-430550-312 POSTAGE 1,077 2,500 1,423 57% 5210-447-430550-320 PRINTING 0 2,000 2,000 100% 5210-447-430550-335 MEMBERSHIP & DUES 125 1,200 1,075 90% 5210-447-430550-336 LICENSES & FEES 46 19,000 18,955 100% 5210-447-430550-341 ELECTRICITY 41,708 148,000 106,292 72% 5210-447-430550-342 WATER 41 500 459 92% 5210-447-430550-344 NATURAL GAS 623 15,000 14,377 96% 5210-447-430550-345 TELEPHONE & COMMUNICATION 1,855 8,000 6,145 77% 5210-447-430550-349 LAB SERVICES 5,621 25,500 19,879 78% 5210-447-430550-353 AUDITING 0 3,000 3,000 100% 5210-447-430550-354 CONTRACT SERVICES 10,320 60,000 49,680 83% 5210-447-430550-355 CONTRACT SERV.-AERIAL MAPPING 77 3,000 2,923 97% 5210-447-430550-356 WTR RIGHTS UPDATE/WTR MODELING 3,844 25,000 21,156 85% 5210-447-430550-357 RATE STUDY 0 4,500 4,500 100% 5210-447-430550-358 IMPACT FEE REVIEW 2,620 5,000 2,380 48% 5210-447-430550-360 REPAIR & MAINT SERVICES 3,937 7,000 3,063 44% 5210-447-430550-362 EQUIPMENT MAINTENANCE 1,917 4,000 2,083 52% 5210-447-430550-363 OFFICE EQUIP MAINTENANCE 0 200 200 100% 5210-447-430550-366 BUILDING MAINTENANCE 1,293 17,000 15,707 92% 5210-447-430550-369 RADIO EQUIPMENT & MAINT. 0 2,450 2,450 100% 5210-447-430550-373 SCHOOL & TRAVEL 2,260 5,500 3,240 59% 5210-447-430550-380 TRAINING MATERIALS 108 500 392 78% 5210-447-430550-388 MEDICAL SERVICES 50 800 751 94% 5210-447-430550-395 RENTAL EQUIPMENT 0 1,500 1,500 100% 5210-447-430550-410 CONSTRUCTION MATERIALS 7,917 30,000 22,083 74% 5210-447-430550-422 HYDRANTS 0 26,000 26,000 100% 5210-447-430550-423 MATERIALS FOR MAINS 756 11,000 10,244 93% 5210-447-430550-424 MATERIALS -SERVICE LINES 2,609 9,000 6,391 71% 5210-447-430550-425 MATERIALS PUMPS/WELLS 769 36,000 35,231 98% 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 2,500 7,500 5,000 67% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 31,574 94,723 63,149 67% 5210-447-430550-528 DATA PROCESSING TRANSFER 6,680 20,041 13,361 67% 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- 5210-447-430550-532 LEASE PAYMENTS 3,919 7,838 3,919 50% 5210-447-430550-810 BAD DEBT EXPENSE 0 1,500 1,500 100% 5210-447-430550-935 ARMORY WELL GENERATOR REPLACEMENT 0 60,000 60,000 100% 5210-447-430550-940 MACHINERY & EQUIPMENT 0 105,000 105,000 100% 5210-447-430550-948 METERS (METER FUNDS) 655 65,000 64,345 99% 5210-447-430550-950 WATER MAIN REPLACEMENT -GRAND VIEW 4,788 156,000 151,212 97% 5210-447-430550-951 SECURITY SYSTEM UPGRADES 0 32,000 32,000 100% 5210-447-430550-954 93S BYPASS -UTILITY RELOCATE -amended 0 15,000 15,000 100% 5210-447-430550-956 UPPER/LOWER INTERCONNECTION 0 30,000 30,000 100% 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 0 395,000 395,000 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 75,000 75,000 100% 5210-447-430555-941 METERS (NEW SERVICES) 55 65,000 64,945 100% 5210-447-430555-953 SECTION 36 WELL 0 75,000 75,000 100% ----------- TOTAL WATER FACILITIES ----------- 440,795 ----------- 2,726,317 ----------- --------------------- 2,285,522 ----------- ---------- 84% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 23,985 91,807 67,822 74% 5210-447-430560-153 HEALTH INSURANCE 6,060 18,774 12,714 68% 5210-447-430560-155 RETIREMENT 1,547 5,914 4,367 74% 5210-447-430560-210 OFFICE SUPPLIES 33 500 467 93% 5210-447-430560-218 EQUIPMENT - NOT CAPITAL 62 2,500 2,438 98% 5210-447-430560-335 MEMBERSHIP & DUES 25 300 275 92% 5210-447-430560-353 AUDITING 0 1,500 1,500 100% 5210-447-430560-354 CONTRACT SERVICES 1,804 7,500 5,696 76% 5210-447-430560-355 BILLING COSTS 6,731 28,500 21,769 76% 5210-447-430560-373 SCHOOL & TRAVEL 0 1,200 1,200 100% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 2,059 6,178 4,119 67% 5210-447-430560-528 DATA PROCESSING TRANSFER 7,347 22,041 14,694 67% 5210-447-430560-532 RENT 3,919 7,838 3,919 50% ----------- TOTAL WATER BILLING ----------- 53,573 ----------- 194,552 ----------- --------------------- 140,979 --------------------- 72% REVENUE BONDS 5210-447-490204-610 2004 BOND PRINCIPAL (HWY93) 0 145,000 145,000 100% 5210-447-490204-620 2004 BOND INTEREST (HWY93) 46,633 46,635 3 0% 5210-447-490204-630 2004 BOND FISCAL AGENT FEES 300 300 0 0% 5210-447-490206-610 2007 BOND PRIN WRF 3.75% 0 179,000 179,000 100% 5210-447-490206-620 2007 BOND INT WRF 3.75% 83,419 83,422 3 0% 5210-447-490250-610 SRF 2001 PRINCIPAL 4% 0 38,000 38,000 100% 5210-447-490250-620 SRF 2001 INTEREST 4% 18,560 18,560 0 0% ----------- TOTAL REVENUE BONDS ----------- 148,911 ----------- 510,917 ----------- --------------------- 362,006 --------------------- 71% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 725,000 725,000 100% ----------- TOTAL DEPRECIATION ----------- 0 ----------- 725,000 ----------- --------------------- 725,000 ----------- ---------- 100% TOTAL WATER FUND 643,278 4,156,786 3,513,508 85% Page 20 33.33% Yr Complete 10/22/10 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 OCTOBER 22, 2010 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 0 16,237 992,979 3,500,000 70,364 100,000 89,082 125,000 380 2,000 15,607 74,000 1,168,412 3,817,237 REMAINING % 16,237 100% 2,507,021 72% 29,636 30% 35,918 29% 1,620 81% 58,393 79% -2_648_825= 69g __===_= EXPENDITURES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 19,158 75,471 56,313 75% 5310-454-430620-153 HEALTH INSURANCE 4,552 14,240 9,688 68% 5310-454-430620-155 RETIREMENT 1,232 4,807 3,575 74% 5310-454-430620-215 OFFICE SUPPLIES/FURNITURE 0 1,000 1,000 100% 5310-454-430620-218 COMPUTERS/SUPPLIES 62 1,500 1,438 96% 5310-454-430620-335 MEMBERSHIP & DUES 25 300 275 92% 5310-454-430620-353 AUDITING 0 1,500 1,500 100% 5310-454-430620-354 CONTRACT SERVICES 349 7,500 7,152 95% 5310-454-430620-355 BILLING COSTS 8,082 24,000 15,918 66% 5310-454-430620-373 SCHOOL & TRAVEL 0 1,000 1,000 100% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 2,411 7,234 4,823 67% 5310-454-430620-528 DATA PROCESSING TRANSFER 7,347 22,041 14,694 67% 5310-454-430620-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SEWER BILLING COSTS ---------------------- 47,137 ---------------------- 168,431 ----------- --------------------- 121,294 ---------- 72% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 95,597 342,562 246,965 72% 5310-454-430630-112 SALARIES-SEVERANCE/RETIREMENT 0 13,900 13,900 100% 5310-454-430630-121 OVERTIME 2,241 7,000 4,759 68% 5310-454-430630-153 HEALTH INSURANCE 22,123 61,635 39,512 64% 5310-454-430630-155 RETIREMENT 6,154 22,931 16,777 73% 5310-454-430630-210 OFFICE SUPPLIES 37 450 413 92% 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 400 2,500 2,100 84% 5310-454-430630-218 EQUIPMENT (NON CAPITAL) 355 1,000 645 65% 5310-454-430630-221 SAFETY EQUIP & SUPPLIES 440 7,500 7,060 94% 5310-454-430630-224 JANITORIAL SUPPLIES 286 700 414 59% 5310-454-430630-229 OTHER SUPPLIES 169 600 431 72% 5310-454-430630-231 GAS & OIL 1,846 9,500 7,654 81% 5310-454-430630-241 CONSUMABLE TOOLS 177 1,000 823 82% 5310-454-430630-312 POSTAGE 0 500 500 100% 5310-454-430630-336 LICENSES & FEES 0 450 450 100% 5310-454-430630-341 ELECTRICITY 8,443 43,000 34,557 80% 5310-454-430630-342 WATER 55 175 120 68% 5310-454-430630-344 NATURAL GAS 2,626 13,000 10,374 80% 5310-454-430630-345 TELEPHONE & COMMUNICATION 5,241 21,000 15,759 75% 5310-454-430630-353 AUDITING 0 2,000 2,000 100% 5310-454-430630-354 CONTRACT SERVICES 6,829 14,000 7,171 51% 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 2,620 5,000 2,380 48% 5310-454-430630-362 EQUIPMENT MAINTENANCE 577 4,800 4,223 88% 5310-454-430630-366 BUILDING MAINTENANCE 30 1,000 970 97% 5310-454-430630-369 RADIO EQUIPMENT & MAINT. 0 1,000 1,000 100% 5310-454-430630-373 SCHOOL & TRAVEL 1,055 2,000 945 47% 5310-454-430630-388 MEDICAL SERVICES 305 800 496 62% 5310-454-430630-410 CONSTRUCTION MATERIALS 1,597 9,000 7,403 82% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 815 12,500 11,685 93% 5310-454-430630-510 PROPERTY & LIABILITY INS. 50,621 56,000 5,379 10% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 671 18,000 17,329 96% Page 21 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- 5310-454-430630-521 CENTRAL GARAGE TRANSFER 833 2,500 1,667 67% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 21,125 63,374 42,249 67% 5310-454-430630-528 DATA PROCESSING TRANSFER 4,899 14,697 9,798 67% 5310-454-430630-532 OFFICE RENT 3,919 7,838 3,919 50% 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 0 25,500 25,500 100% 5310-454-430630-810 BAD DEBT EXPENSE 0 1,000 1,000 100% 5310-454-430630-954 93 So. BYPASS -UTILITY RELOCATE 0 21,650 21,650 100% TOTAL SANITARY SEWER/COLLECTIO ----------- 242,198 ----------- ----------- 828,812 ----------- --------------------- 586,614 --------------------- 71% 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 292,301 1,784,187 1,491,886 84% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 94,632 382,859 288,227 75% 5310-455-430640-112 SALARIES -RETIREMENT 0 8,800 8,800 100% 5310-455-430640-121 OVERTIME 6,148 20,000 13,852 69% 5310-455-430640-153 HEALTH INSURANCE 19,659 66,146 46,487 70% 5310-455-430640-155 RETIREMENT 6,314 23,932 17,618 74% 5310-455-430640-210 OFFICE SUPPLIES 119 1,000 881 88% 5310-455-430640-213 SMALL OFFICE EQUIPMENT 0 1,000 1,000 100% 5310-455-430640-215 COMPUTER SUPPLIES 0 500 500 100% 5310-455-430640-216 COMPUTER EQUIPMENT 130 2,500 2,370 95% 5310-455-430640-221 SAFETY EQUIP & SUPPLIES 134 1,500 1,366 91% 5310-455-430640-222 LABORATORY SUPPLIES 177 0 177- 0% 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 1,151 5,000 3,849 77% 5310-455-430640-231 GAS & OIL 1,323 11,000 9,677 88% 5310-455-430640-241 CONSUMABLE TOOLS 423 1,000 577 58% 5310-455-430640-312 POSTAGE 47 400 353 88% 5310-455-430640-335 MEMBERSHIP & DUES 125 800 675 84% 5310-455-430640-336 LICENSES & FEES 0 8,000 8,000 100% 5310-455-430640-341 ELECTRICITY 40,136 200,000 159,864 80% 5310-455-430640-342 WATER 940 7,500 6,560 87% 5310-455-430640-344 NATURAL GAS 6,811 60,000 53,189 89% 5310-455-430640-345 TELEPHONE & COMMUNICATION 1,198 6,000 4,802 80% 5310-455-430640-353 AUDITING 0 2,750 2,750 100% 5310-455-430640-354 CONTRACT -GLACIER GOLD 26,672 123,000 96,328 78% 5310-455-430640-355 OTHER CONTRACT SERVICES 6,461 38,000 31,539 83% 5310-455-430640-356 CONSULTANTS 5,707 19,000 13,293 70% 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 370 2,300 1,930 84% Page 22 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 5310-455-430640-373 SCHOOL & TRAVEL 4,046 10,000 5,954 60% 5310-455-430640-380 TRAINING MATERIALS 245 500 255 51% 5310-455-430640-388 MEDICAL SERVICES 99 500 401 80% 5310-455-430640-395 RENTAL EQUIPMENT 0 800 800 100% 5310-455-430640-510 PROPERTY & LIABILITY INS. 43,300 52,000 8,700 17% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 1,167 3,500 2,333 67% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 35,141 105,424 70,283 67% 5310-455-430640-528 DATA PROCESSING TRANSFER 6,235 18,705 12,470 67% 5310-455-430640-940 MACHINERY & EQUIPMENT 2,622 0 2,622- 0% TOTAL WWTP OPERATIONS ----------- 326,511 ----------- 1,266,616 --------------------- 940,105 74% WWTP REPLACEMENT ----------- ----------- --------------------- 5310-455-430645-362 EQUIPMENT MAINTENANCE 22,552 40,000 17,448 44% 5310-455-430645-940 MACHINERY & EQUIPMENT 11,966 20,000 8,034 40% TOTAL WWTP REPLACEMENT ----------- 34,518 ----------- ----------- 60,000 ----------- --------------------- 25,482 --------------------- 42% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 31,298 114,033 82,735 73% 5310-455-430646-121 OVERTIME 0 200 200 100% 5310-455-430646-153 HEALTH INSURANCE 5,502 19,226 13,724 71% 5310-455-430646-155 RETIREMENT 1,938 6,997 5,059 72% 5310-455-430646-210 OFFICE SUPPLIES 0 100 100 100% 5310-455-430646-215 COMPUTER SUPPLIES & SUPPORT 0 50 50 100% 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 1,395 10,000 8,605 86% 5310-455-430646-224 JANITORIAL SUPPLIES 0 50 50 100% 5310-455-430646-229 OTHER SUPPLIES 56 200 144 72% 5310-455-430646-312 POSTAGE & SHIPPING 405 500 95 19% 5310-455-430646-335 MEMBERSHIP & DUES 0 100 100 100% 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 2,585 20,000 17,415 87% 5310-455-430646-362 EQUIPMENT MAINTENANCE 6,253 1,300 4,953- -381% 5310-455-430646-373 SCHOOL & TRAVEL 387 2,500 2,113 85% 5310-455-430646-380 TRAINING MATERIALS 0 200 200 100% 5310-455-430646-940 EQUIPMENT 0 7,000 7,000 100% TOTAL MITP LAB OPERATIONS ----------- 49,958 ----------- 188,106 --------------------- 138,148 73% 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% Page 23 33.33% Yr Complete 10/22/10 FUND FUND --------------------------------------- TOTAL DEPRECIATION TOTAL WWTP CITY OF KALISPELL Quarterly Finance Report OCTOBER 22, 2010 ACTUAL YTD BUDGET REMAINING % ----------------------------------------------------------- --------------------------------- ---------- 0 411,599 411,599 100% ------------------------------------------- 956,536 3,178,171 2,221,635 70% TOTAL BILLING/SANITARY/WWTP 1,295,974 5,130,789 3,834,815 75% Page 24 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Page 25 Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % STORM SEWER REVENUE 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 2,260 20,000 17,740 89% 5349-000-343033-000 IMPACT FEES 66,139 200,000 133,861 67% 5349-000-343034-000 PERMIT FEES 300 1,500 1,200 80% 5349-000-343035-000 STORM SEWER CHARGES 0 2,500 2,500 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS 819,373 825,000 5,628 1% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,406 3,500 2,094 60% 5349-000-371010-000 INTEREST ON INVESTMENTS 6,345 20,000 13,655 68% ----------- TOTAL STORM REVENUE 895,822 ----------- 1,072,500 --------------------- 176,678 16% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 91,447 347,937 256,490 74% 5349-453-430246-112 SEVERANCE 0 4,400 4,400 100% 5349-453-430246-121 OVERTIME 533 4,500 3,967 88% 5349-453-430246-153 HEALTH INSURANCE 20,621 66,241 45,620 69% 5349-453-430246-155 RETIREMENT 5,840 22,037 16,197 74% 5349-453-430246-210 OFFICE SUPPLIES/EQUIPMENT 95 600 505 84% 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 0 3,000 3,000 100% 5349-453-430246-218 EQUIPMENT -NON CAPITAL 0 1,000 1,000 100% 5349-453-430246-221 SAFETY EQUIP & SUPPLIES 0 2,500 2,500 100% 5349-453-430246-229 OTHER SUPPLIES 24 1,200 1,176 98% 5349-453-430246-231 GAS & OIL 1,846 10,500 8,654 82% 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 197 750 553 74% 5349-453-430246-353 AUDITING 0 600 600 100% 5349-453-430246-354 CONTRACT SERVICE 82 3,000 2,918 97% 5349-453-430246-355 CONTRACT SERV.-AERIAL MAPPING 77 3,000 2,923 97% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 781 25,500 24,719 97% 5349-453-430246-357 RATE STUDY 0 8,000 8,000 100% 5349-453-430246-358 IMPACT STUDY 0 7,000 7,000 100% 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 3,652 26,000 22,348 86% 5349-453-430246-371 CURB & GUTTER 0 5,000 5,000 100% 5349-453-430246-373 SCHOOL & TRAVEL 1,077 3,500 2,423 69% 5349-453-430246-388 MEDICAL SERVICES 110 250 140 56% 5349-453-430246-410 CONSTRUCTION MATERIALS 0 10,000 10,000 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 7,557 8,500 943 11% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 833 2,500 1,667 67% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 10,652 31,957 21,305 67% 5349-453-430246-528 DATA PROCESSING TRANSFER 1,781 5,344 3,563 67% 5349-453-430246-530 BNSF LEASE PMT 0 4,200 4,200 100% 5349-453-430246-532 OFFICE RENT 3,919 7,838 3,919 50% 5349-453-430246-952 STORM DRAIN CORRECTION 0 100,000 100,000 100% 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 156,920 ---------------------- 1,010,554 ---------- 853,634 84% 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Page 26 Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION 788,549 771,500 17,049- -2% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,327 3,500 2,173 62% 5510-000-371010-000 INVESTMENT EARNINGS 945 3,500 2,555 73% TOTAL SOLID WASTE REVENUE ----------- 790,820 ----------- 778,500 --------------------- 12,320- -2% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 86,008 361,733 275,725 76% 5510-460-430840-121 OVERTIME 775 9,500 8,725 92% 5510-460-430840-153 HEALTH INSURANCE 21,467 65,453 43,986 67% 5510-460-430840-155 RETIREMENT 5,432 22,295 16,863 76% 5510-460-430840-213 SMALL OFFICE EQUIPMENT 0 500 500 100% 5510-460-430840-216 COMPUTER EQUIPMEMT 71 3,000 2,929 98% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 8,043 25,000 16,957 68% 5510-460-430840-221 SAFETY EQUIP & SUPPLIES 195 1,500 1,305 87% 5510-460-430840-224 JANITORIAL SUPPLIES 220 400 180 45% 5510-460-430840-229 OTHER SUPPLIES 236 2,000 1,764 88% 5510-460-430840-231 GAS & OIL 8,796 47,000 38,204 81% 5510-460-430840-241 CONSUMABLE TOOLS 0 1,500 1,500 100% 5510-460-430840-341 ELECTRICITY 278 1,600 1,322 83% 5510-460-430840-344 NATURAL GAS 81 7,000 6,919 99% 5510-460-430840-345 TELEPHONE & COMMUNICATION 141 700 559 80% 5510-460-430840-354 CONTRACT SERVICES 352 12,000 11,648 97% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 86 2,000 1,914 96% 5510-460-430840-366 BUILDING MAINTENANCE 0 2,500 2,500 100% 5510-460-430840-369 RADIO EQUIPMENT & MAINT. 0 1,700 1,700 100% 5510-460-430840-373 SCHOOL & TRAVEL 350 2,500 2,150 86% 5510-460-430840-388 MEDICAL SERVICES 84 550 466 85% 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 8,667 26,000 17,333 67% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 9,998 29,995 19,997 67% 5510-460-430840-528 DATA PROCESSING TRANSFER 3,118 9,353 6,235 67% 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 536 3,000 2,464 82% 5510-460-430845-342 WATER 63 350 287 82% 5510-460-430845-344 NATURAL GAS 0 9,500 9,500 100% 5510-460-430845-360 REPAIR & MAINT SERVICES 210 1,000 790 79% 5510-460-430845-366 BUILDING MAINTENANCE 0 1,000 1,000 100% 5510-460-510400-B31 DEPRECIATION EXPENSE 0 100,000 100,000 100% TOTAL SOLID WASTE EXPENSE ---------------------- 169,202 ----------- 777,817 ---------- 608,615 78% 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Page 27 Quarterly Finance Report OCTOBER 22, 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 2,400 7,500 5,100 68% 5160-000-343063-000 TIE DOWN FEES 1,060 4,000 2,940 74% 5160-000-343069-000 HANGER LEASES 2,000 12,000 10,000 83% 5160-000-343071-000 HANGAR SITE LEASES 16,673 15,600 1,073- -7% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 5,488 16,545 11,057 67% 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,045 6,000 3,955 66% 5160-000-371010-000 INVESTMENT EARNINGS 4,208 ----------- 15,000 ----------- 10,792 72% TOTAL AIRPORT REVENUE 44,927 89,199 ----------- ---------- 44,272 50% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 9,349 33,801 24,452 72% 5160-430-430310-111 SEASONAL SALARIES 949 3,267 2,318 71% 5160-430-430310-153 HEALTH INSURANCE 1,375 3,182 1,807 57% 5160-430-430310-155 RETIREMENT 599 2,406 1,807 75% 5160-430-430310-210 OFFICE SUPPLIES 42 300 258 86% 5160-430-430310-218 NON -CAPITAL EQUIPMENT 0 750 750 100% 5160-430-430310-335 MEMBERSHIP & DUES 0 150 150 100% 5160-430-430310-341 ELECTRICITY 337 1,500 1,163 78% 5160-430-430310-345 TELEPHONE 133 1,000 867 87% 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 0 5,000 5,000 100% 5160-430-430310-357 CONTRACT SERVICES - legal 12,115 0 12,115- 0% 5160-430-430310-360 REPAIRS & MAINTENANCE 279 3,000 2,721 91% 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 889 1,750 861 49% 5160-430-430310-380 SIGNAGE 0 300 300 100% 5160-430-430310-390 EQUIPMENT RENTAL 1,320 1,500 180 12% 5160-430-430310-510 PROPERTY INSURANCE 1,068 6,000 4,932 82% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 1,488 4,465 2,977 67% 5160-430-430310-528 DATA PROCESSING TRANSFER 891 2,672 1,781 67% 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 ---------------------- 34,272 ----------- 295,845 ---------- 261,573 88% DATA PROCESSING REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 87,469 174,937 87,469 50% 6030-000-364030-000 SALE OF MISCELLANEOUS 0 300 300 1000 6030-000-371010-000 INVESTMENT EARNINGS 399 2,323 1,924 83% 6030-000-393000-000 INTERNAL SERVICES -DATA 48,541 145,624 97,083 67% TOTAL DATA PROCESSING REVENUE ---------------------- 136,409 ----------- 323,184 ---------- 186,775 58% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 20,492 73,787 53,295 72% 6030-401-410580-153 HEALTH INSURANCE 3,386 12,157 8,771 72% 6030-401-410580-155 RETIREMENT 1,336 4,790 3,454 72% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 0 1,370 1,370 100% 6030-403-410580-215 COMPUTER SUPPLIES 189 2,600 2,411 93% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 69 15,500 15,431 100% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 9,467 25,000 15,533 62% 6030-403-410580-346 SUMMIT NET Tl CONTRACT 746 6,816 6,070 89% 6030-403-410580-353 LASER FICHE MAINTENANCE 1,588 1,600 12 1% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 0 17,400 17,400 100% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 16,121 38,592 22,471 58% 6030-403-410580-356 ADG-Electronic Time Sheets 0 7,000 7,000 100% 6030-403-410580-357 GRANICUS 3,000 6,000 3,000 50% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 1,353 16,649 15,296 92% 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 61 6,000 5,939 99% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 15,333 70,000 54,667 78% 33.33% Yr Complete 10/22/10 CITY OF KALISPELL Page 28 Quarterly Finance Report OCTOBER 22, 2010 33.33% Yr Complete FUND --------------------- 6030-403-410585-532 6030-403-510400-831 6030-404-410588-218 6030-405-410588-940 6030-405-410588-942 6030-410-410588-218 6030-413-410588-218 6030-416-410588-218 6030-420-410588-218 6030-436-410588-218 FUND COPIER LEASES DEPRECIATION EXPENSE COMPUTERS - ATTORNEYS COMPUTERS - 3 switches COMPUTERS - CAPITAL OR CONTINGENCY COMPUTERS - DPW COMPUTERS - POLICE DEPT COMPUTERS - FIRE COMPUTERS - PLANNING DEPT COMPUTERS - PARKS TOTAL DATA PROCESSING EXPENSE ACTUAL YTD BUDGET REMAINING % ---------------------------------------------- 5,451 30,000 24,549 82% 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% 1,500 3,320 1,820 55% 369 9,147 8,778 96% 116 5,300 5,184 98% 1,000 1,000 0 0% 0 3,300 3,300 100% ----------- 119,850 ----------- 413,419 --------------------- 293,569 71%