Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
3rd Quarter Finance Report
- - MONTAI\'A Date April 12, 2012 TO: Mayor Fisher & City Council Members 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: 3nd Qtr Finance Report — FY2012 (July totals thru March 2012) Please find attached the printouts reflecting the activity for 3/4ths of the fiscal year 2012. This printout reflects payroll earned thru March 23, 2012. All funds are included with the exception of the debt service funds; Westside TIF construction 4188 was added. REVENUE: General Fund revenue reflects taxes collected thru March 15th. The County is holding $172,816 in protested city taxes. Most of the protested taxes are centrally assessed properties — utility companies. Remember when looking at revenue printouts — a negative remaining number means we have exceeded our expectation. Ex. Pg 12 Building Fund revenue (due to the hospital construction) has exceeded all budget estimates. EXPENDITURES: General Fund expenditures reflect 72% spent —some expenditures such as liability and property insurance are paid during the first quarter for the entire year. This will be a very tight year end budget. The total General Fund budget reflects an increase in appropriations due to '/2 year of Parking appropriations being added to the police budget. A change in reporting requirements for health insurance premiums requires that the city paid portion be reflected on the W-2s for calendar year 2012. This change will force us to recognize the expenditure thru the payroll program in advance. Health insurance is posted for 10 months. Payroll remaining should reflect 27-28% due to timing of pay periods. CASH REPORT: included at the end of the budget printout is the March 31' cash report and detail for your information. Grant funds are generally reimbursements and will reflect negative balances until reimbursed. Please feel free to call with any questions. 758-7755. 04/12/12 CITY OF KALISPELL Page 1 Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,638,759 4,681,906 2,043,147 44% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 8,068 15,520 7,452 48% 1000-000-311200-000 PERSONAL PROPERTY TAXES 210,095 208,000 2,095- -1% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 24,113 35,000 10,887 31% 1000-000-322101-000 BEER & LIQUOR LICENSES 300 24,000 23,700 99% 1000-000-322300-000 BUSINESS LICENSES 1,126 1,100 26- -2% 1000-000-322500-000 AMUSEMENT LICENSES 300 350 50 14% 1000-000-323012-000 PLANNING FEES 11,142 40,000 28,858 72% 1000-000-323107-000 EXCAV/DEMO/AIR/HOUSE MOVING PERMITS 0 500 500 100% 1000-000-323109-000 SITE REVIEW 6,035 9,500 3,465 36% 1000-000-323200-000 PARADE PERMITS 550 2,000 1,450 73% 1000-000-323300-000 ANIMAL LICENSES 761 900 139 15% 1000-000-335030-000 M.V. TAX - AD VALOREM 845 1,720 875 51% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 55,850 61,075 5,225 9% 1000-000-335110-000 LIVE CARD TABLE PERMIT 3,200 3,600 400 11% 1000-000-335230-000 HB124 ENTITLEMENT 1,634,814 2,272,379 637,565 28% 1000-000-341020-000 ADMINISTRATIVE CHARGES 384,137 512,000 127,863 25% 1000-000-341021-000 GRANT ADMIN FEES 37,793 43,000 5,207 12% 1000-000-341025-000 CITY COLLECTIONS 17,865 1,000 16,865- -1687% 1000-000-341026-000 LEAGUE OF CITIES CONFERENCE 2,500 0 2,500- 0% 1000-000-341027-000 BRESNAN FRANCHISE FEES 77,672 157,000 79,328 51% 1000-000-342010-000 POLICE SERVICES 16,883 15,000 1,883- -13% 1000-000-342014-000 RESOURCE OFFICERS 86,000 86,000 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 750 10,000 9,250 93% 1000-000-343005-000 CENTRAL GARAGE CHARGE 91,350 121,800 30,450 25% 1000-000-343018-000 PARKING PERMITS METERS, BOOT REMOVE 23,308 0 23,308- 0% 1000-000-351000-000 CITY COURT FINES & FEES 319,144 500,000 180,856 36% 1000-000-351016-000 DUI COURT FINE 135 3,500 3,365 96% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 15,452 32,000 16,548 52% 1000-000-351035-000 PARKING FINES 13,373 0 13,373- 0% 1000-000-362010-000 CITY GOLF COURSE LEASE 0 25,000 25,000 100% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 7,717 3,000 4,717- -157% 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 3,000 3,000 0 0% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 824 100 724- -724% 1000-000-365001-000 KMTC NON-PROFIT DONATIONS 50 0 50- 0% 1000-000-365015-000 CONTRIBUTION FRM KIDSPORT 0 44,000 44,000 100% 1000-000-365018-000 BANDSHELL CONTRIBUTIONS 200 0 200- 0% 1000-000-371010-000 INVESTMENT EARNINGS 15,959 35,000 19,041 54% 1000-000-371050-000 LOAN REPAY - KPC 0 2,855 2,855 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 342,150 599,209 257,059 43% TOTAL REVENUE ----------- 6,052,218 ----------- 9,551,014 --------------------- 3,498,796 37% 75.00% Yr Complete 04/12/12 FUND 1000-400-410530-331 1000-400-410530-353 1000-400-410530-354 1000-400-410560-210 1000-400-410560-312 1000-400-410560-320 1000-400-410600-354 1000-400-410900-331 1000-400-420000-354 1000-400-420000-356 1000-400-460446-354 1000-400-460446-355 1000-400-460452-355 1000-400-460452-366 1000-400-510300-000 1000-400-510310-354 1000-400-510330-513 1000-400-510330-516 1000-400-510330-517 1000-401-410210-110 1000-401-410210-153 1000-401-410210-155 1000-401-410210-210 1000-401-410210-312 1000-401-410210-338 1000-401-410210-345 1000-401-410210-373 1000-401-410210-379 1000-401-410830-110 1000-401-410830-153 1000-401-410830-155 1000-401-410830-210 1000-401-410830-338 1000-401-410830-354 1000-401-410830-373 FUND CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 ACTUAL YTD BUDGET ---------------------------------- GENERAL FUND - EXPENDITURES GENERAL GOV'T. ANNUAL REPORT FILING FEES AUDITING OPEB EXPENSE PURCHASING/OFFICE SUPPLIES POSTAGE PRINTING ELECTIONS RECORDS ADMIN./FILING FEES CONTRACT 911 CENTER SMITH VALLEY FIRE LEVY REIMB. KIDSPORT LEASE PARADE -SERVICE ORG. REIMB. EAGLE TRANSIT CONTRIBUTION HOCKADAY MAINTENANCE CONTINGENCY ICMA PLAN FEES LIABILITY INSURANCE UNINSURED LOSS -PROPERTY/LIABILITY PROPERTY INSURANCE SUBTOTAL GEN.GOV'T. CITY MANAGER SALARIES -CITY MANAGER'S OFFICE HEALTH INSURANCE RETIREMENT COMPUTER SOFTWARE/SUPPLIES NEWSLETTER/BOOKS RECRUITMENT TELEPHONE & COMMUNICATION DUES & TRAINING MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES SALARIES-HR DEPT. HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES RECRUITMENT CONTRACT SERVICES DUES & TRAINING SUBTOTAL HUMAN RESOURCES REMAINING % 1,400 1,435 35 2% 10,000 10,500 500 5% 6,000 6,000 0 0% 2,234 3,000 766 26% 7,630 16,000 8,370 52% 4,852 6,000 1,148 19% 14,965 10,000 4,965- -50% 1,220 3,500 2,280 65% 214,368 428,736 214,368 50% 308 300 8- -3% 43,553 44,000 447 1% 0 2,000 2,000 100% 15,000 15,000 0 0% 6,600 6,600 0 0% 569 14,992 14,423 96% 500 500 0 0% 213,145 213,155 10 0% 13,885 30,000 16,115 54% 41,812 42,000 188 0% ----------- 598,042 ---------------------- 853,718 ---------- 255,676 30% 75,524 117,832 42,308 36% 9,346 14,956 5,610 38% 7,654 12,766 5,112 40% 0 800 800 100% 124 500 376 75% 4,626 6,000 1,374 23% 100 400 300 75% 1,007 2,500 1,493 60% 504 600 96 16% ---------------------- 98,884 ----------- 156,354 ---------- 57,470 37% 77,515 108,242 30,727 28% 13,844 16,667 2,823 17% 5,060 7,030 1,970 28% 248 400 152 38% 811 3,500 2,689 77% 2,285 4,000 1,715 43% 1,920 ----------- 3,900 1,980 51% ----------- 101,682 ----------- 143,739 ---------- 42,057 29% Page 2 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 Page 3 75.00% Yr Complete FUND FUND MEDIA SPECIALIST 1000-401-410900-110 SALARIES -MEDIA SPECIALS 1000-401-410900-153 HEALTH INSURANCE 1000-401-410900-155 RETIREMENT 1000-401-410900-218 EQUIPMENT 1000-401-410900-354 CONTRACT SERVICES SUBTOTAL MEDIA SPECIALI MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 1000-402-410100-153 HEALTH INSURANCE 1000-402-410100-155 RETIREMENT 1000-402-410100-210 OFFICE SUPPLIES 1000-402-410100-335 MT LEAGUE OF CITIES 1000-402-410100-354 CONTRACT SERVICES 1000-402-410100-373 DUES & TRAINING 1000-402-410100-379 MEETINGS SUBTOTAL MAYOR/COUNCIL CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 1000-402-410150-121 OVERTIME 1000-402-410150-153 HEALTH INSURANCE 1000-402-410150-155 RETIREMENT 1000-402-410150-210 OFFICE SUPPLIES 1000-402-410150-345 TELEPHONE & COMMUNICATI 1000-402-410150-352 RECODIFICATION 1000-402-410150-354 CONTRACT SERVICES 1000-402-410150-373 DUES & TRAINING SUBTOTAL CITY CLERK FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 1000-403-410550-153 HEALTH INSURANCE 1000-403-410550-155 RETIREMENT 1000-403-410550-322 BOOKS 1000-403-410550-345 TELEPHONE & COMMUNICATI 1000-403-410550-353 CONTRACT SERVICES 1000-403-410550-354 CONTRACT -GRIZZLY SECURI 1000-403-410550-355 BANK CHARGES & FEES 1000-403-410550-373 DUES & TRAINING SUBTOTAL FINANCE ACTUAL YTD ----------------------------------------------------------- ON ON TY BUDGET REMAINING % ST 16,197 23,532 7,335 31% 7,051 8,200 1,149 14% 1,089 1,522 433 28% 1,997 2,000 3 0% 1,700 2,500 800 32% ----------- ST 28,034 ----------- 37,754 --------------------- 9,720 26% 45,503 63,056 17,553 28% 22,040 27,936 5,896 21% 2,198 2,432 234 10% 32 50 18 37% 5,978 6,000 22 0% 25 100 75 75% 120 3,000 2,880 96% 277 ----------- 300 24 8% 76,172 ----------- 102,874 --------------------- 26,702 26% 59,775 84,389 24,614 29% 546 500 46- -9% 8,285 10,357 2,072 20% 3,924 5,459 1,535 28% 34 100 66 66% 254 450 196 44% 2,857 3,500 643 18% 0 25 25 100% 1,068 1,275 207 16% ----------- 76,743 ----------- 106,055 --------------------- 29,312 28% 149,193 208,160 58,967 28% 29,459 35,449 5,990 17% 9,750 13,522 3,772 28% 215 300 85 28% 0 100 100 100% 1,173 1,500 327 22% 541 1,500 959 64% 2,346 3,500 1,154 33% 2,721 ----------- 3,500 779 22% 195,398 ----------- 267,531 --------------------- 72,133 27% 04/12/12 FUND FUND ---------------------------------- 1000-404-411110-110 1000-404-411110-153 1000-404-411110-155 1000-404-411110-210 1000-404-411110-322 1000-404-411110-345 1000-404-411110-354 1000-404-411110-373 1000-406-410360-110 1000-406-410360-153 1000-406-410360-155 1000-406-410360-210 1000-406-410360-229 1000-406-410360-320 1000-406-410360-345 1000-406-410360-353 1000-406-410360-354 1000-406-410360-373 1000-406-410360-394 1000-406-410360-395 1000-406-410360-396 1000-406-410360-826 1000-410-430100-110 1000-410-430100-112 1000-410-430100-153 1000-410-430100-155 1000-410-430100-210 1000-410-430100-345 1000-410-430100-354 1000-410-430100-373 1000-410-431330-110 1000-410-431330-121 1000-410-431330-153 1000-410-431330-155 1000-410-431330-210 1000-410-431330-229 1000-410-431330-231 1000-410-431330-232 1000-410-431330-233 1000-410-431330-238 1000-410-431330-241 1000-410-431330-341 1000-410-431330-344 1000-410-431330-354 1000-410-431330-355 1000-410-431330-362 1000-410-431330-373 1000-410-431330-388 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 CITY ATTORNEY SALARIES -CITY ATTORNEY'S HEALTH INSURANCE RETIREMENT OFFICE/COMPUTER SUPPLIES LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS TELEPHONE & COMMUNICATION CONTRACT SERVICES DUES & TRAINING SUBTOTAL CITY ATTORNEY MUNICIPAL COURT SALARIES -COURT HEALTH INSURANCE RETIREMENT SUPPLIES KM TREATMENT COURT INCENTIVES PRINTING/BOOKS TELEPHONE & COMMUNICATION SECURITY & TECHNOLOGY CONTRACT SERVICES DUES & TRAINING JURY & WITNESS FEES DRUG COURT DUI COURT INCENTIVES & MISC TFR TO 2951/DUI COURT GRT SUBTOTAL COURT DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION SALARIES -PUBLIC WORKS SEVERANCE HEALTH INSURANCE RETIREMENT COMPUTER/OFFICE SUPPLIES TELEPHONE & COMMUNICATION CONTRACT SERVICES DUES & TRAINING SUBTOTAL ADMINISTRATION CENTRAL GARAGE SALARIES -CENTRAL GARAGE OVERTIME HEALTH INSURANCE RETIREMENT OFFICE/COMPUTER SUPPLIES NON -CAPITAL & SAFETY EQUIPMENT GAS & OIL MOTOR VEHICLE PARTS. TIRES AND RELATED PARTS FILTERS & MISC. PARTS CONSUMABLE TOOLS/BOOKS ELECTRICITY NATURAL GAS CONTRACT SERVICES CONTRACT SERVICES -FLEET SERVICES BUILDINGS & EQUIPMENT MAINTENANCE DUES & TRAINING MEDICAL SERVICES SUBTOTAL CENTRAL GARAGE TOTAL PUBLIC WORKS ACTUAL YTD ----------------------------------------------- BUDGET REMAINING % 227,383 313,787 86,404 28% 43,744 53,367 9,623 18% 14,860 20,381 5,521 27% 569 3,200 2,631 82% 7,225 7,000 225- -3% 482 1,200 718 60% 130 5,000 4,870 97% 3,976 ----------- 4,500 524 12% 298,369 ----------- 408,435 --------------------- 110,066 27% 145,045 198,727 53,682 27% 38,915 46,818 7,903 17% 9,487 12,884 3,397 26% 3,714 4,500 786 17% 50 0 50- 0% 443 500 57 11% 639 1,400 761 54% 6,734 55,000 48,266 88% 2,438 5,750 3,312 58% 1,272 6,300 5,028 80% 5,047 5,750 703 12% 750 11,500 10,750 93% 454 500 46 9% 853 1,000 147 15% ----------- 215,840 ----------- 350,629 --------------------- 134,789 38% 12,477 17,430 4,953 28% 0 2,000 2,000 100% 2,674 3,755 1,081 29% 815 1,129 314 28% 810 2,025 1,215 60% 183 200 17 8% 822 750 72- -10% 595 ----------- 1,150 555 48% 18,376 ----------- 28,439 --------------------- 10,063 35% 107,904 150,825 42,921 28% 845 1,700 855 50% 24,258 31,170 6,912 22% 6,763 9,252 2,489 27% 376 1,200 824 69% 6,107 5,550 557- -10% 95,861 135,500 39,639 29% 72,211 79,000 6,789 9% 25,934 27,000 1,066 4% 4,998 3,700 1,298- -35% 1,262 650 612- -94% 1,059 1,700 641 38% 4,895 7,600 2,705 36% 21,678 52,000 30,322 58% 0 25,000 25,000 100% 1,339 1,250 89- -7% 790 500 290- -58% 233 ----------- 250 ----------- 18 7% 376,513 533,847 --------------------- 157,334 29% 394,889 562,286 167,397 30% Page 4 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Page 5 Quarterly Finance Report MARCH 31, 2012 75.00% Yr Complete FUND ---------------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 45,095 64,123 19,028 300 1000-412-411230-121 OVERTIME 100 200 100 50% 1000-412-411230-153 HEALTH INSURANCE 10,684 13,130 2,446 19% 1000-412-411230-155 RETIREMENT 2,858 4,010 1,152 29% 1000-412-411230-218 EQUIPMENT/FURNACE 7,500 7,500 0 0% 1000-412-411230-220 SECURITY CAMERA -CITY HALL 7,955 8,000 45 1% 1000-412-411230-224 JANITORIAL SUPPLIES 3,987 5,200 1,213 23% 1000-412-411230-241 TOOLS & SUPPLIES 924 1,450 526 36% 1000-412-411230-341 ELECTRICITY 30,576 45,000 14,424 32% 1000-412-411230-344 NATURAL GAS 23,031 40,000 16,969 42% 1000-412-411230-345 TELEPHONE & COMMUNICATION 94 250 156 62% 1000-412-411230-354 CONTRACT SERVICES 23,639 23,000 639- -3% 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 1,034 4,500 3,466 77% 1000-412-411230-362 EQUIPMENT MAINTENANCE 3,801 5,000 1,199 24% 1000-412-411230-366 BUILDING MAINTENANCE 16,690 19,300 2,610 14% 1000-412-411230-545 COUNTY LANDFILL 2,931 2,000 931- -47% 1000-412-411230-610 BOI 2004 DEBT (HVAC SYS) 15,984 15,985 1 0% 1000-412-411230-620 BOI 2004 INT. (HVAC SYS) 1,042 1,120 78 7% SUBTOTAL CITY HALL ----------- 197,925 ----------- 259,768 --------------------- 61,843 24% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 173,447 238,939 65,492 27% 1000-420-411020-153 HEALTH INSURANCE 41,557 53,669 12,112 23% 1000-420-411020-155 RETIREMENT 11,337 15,517 4,180 27% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 3,890 7,500 3,610 48% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,070 2,700 1,630 60% 1000-420-411020-345 TELEPHONE 521 900 379 42% 1000-420-411020-354 CONTRACT SERVICES 916 1,600 684 43% 1000-420-411020-373 DUES & TRAINING 2,874 ----------- 3,300 426 13% TOTAL PLANNING DEPT. 235,611 ----------- 324,125 ----------- ---------- 88,514 27% 04/12/12 CITY OF KALISPELL Page 6 Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING $ POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 1,284,418 1,769,544 485,126 27% 1000-413-420140-112 SALARIES -SEVERANCE 15,538 5,000 10,538- -211% 1000-413-420140-114 SALARY -comptime buyout 6,604 4,000 2,604- -65% 1000-413-420140-121 OVERTIME (REG & AFT OT) 55,489 70,000 14,511 21% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 2,693 25,000 22,307 89% 1000-413-420140-153 HEALTH INSURANCE 282,073 335,000 52,927 16% 1000-413-420140-155 RETIREMENT 168,196 233,756 65,560 28% 1000-413-420140-210 OFFICE SUPPLIES 3,074 3,500 426 12% 1000-413-420140-215 COMPUTER SUPPLIES 3,159 5,500 2,341 43% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 8,355 10,500 2,145 20% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 4,990 4,000 990- -25% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 1,763 7,000 5,237 75% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 28 2,000 1,972 99% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 4,110 4,000 110- -3% 1000-413-420140-227 AMMO & RELATED SUPPLIES 11,506 17,000 5,494 32% 1000-413-420140-228 PATROL CAR SUPPLIES 10,454 13,000 2,546 20% 1000-413-420140-229 OTHER SUPPLIES 2,178 3,500 1,322 38% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 589 1,000 411 41% 1000-413-420140-234 CRISIS NEGOTIATIONS 1,156 1,500 344 23% 1000-413-420140-235 BIKE PATROL 30 1,000 970 97% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 330 1,000 670 67% 1000-413-420140-320 PRINTING 2,568 5,000 2,432 49% 1000-413-420140-345 TELEPHONE & COMMUNICATION 11,306 15,500 4,194 27% 1000-413-420140-354 CONTRACT SERVICES 4,120 6,000 1,880 31% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 6,681 4,500 2,181- -48% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 0 4,000 4,000 100% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 165 2,000 1,835 92% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 5,471 20,000 14,529 73% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 3,031 2,500 531- -21% 1000-413-420140-373 DUES & TRAINING 15,662 27,250 11,588 43% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 3,353 12,000 8,647 72% 1000-413-420140-380 TRAINING MATERIALS 269 2,000 1,731 87% 1000-413-420140-388 MEDICAL SERVICES 291 3,500 3,209 92% 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,038 1,500 462 31% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 42,900 57,200 14,300 25% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 20,000 20,000 0 0% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 5,000 5,000 0 0% 1000-413-420140-944 VEHICLES 74,913 75,000 87 0$ 1000-413-420141-110 SALARIES -DETECTIVES 241,262 332,428 91,166 27% 1000-413-420141-121 DETECTIVE -OVERTIME 12,346 15,000 2,654 18% 1000-413-420141-153 HEALTH INSURANCE 46,785 56,346 9,561 17% 1000-413-420141-155 DETECTIVE -RETIREMENT 32,417 44,902 12,485 28% 1000-413-420142-110 SALARIES -RECORDS DIVISION 75,024 102,927 27,903 27% 1000-413-420142-121 OVERTIME 251 7,500 7,249 97% 1000-413-420142-153 HEALTH INSURANCE 7,540 13,968 6,428 46% 1000-413-420142-155 RETIREMENT 4,297 5,615 1,318 23% 1000-413-420144-110 SALARIES -SRO 83,736 117,630 33,894 29% 1000-413-420144-153 HEALTH INSURANCE 15,911 21,940 6,029 27% 1000-413-420144-155 SRO RETIREMENT 10,153 15,759 5,606 36% 1000-413-420145-110 ANIMAL CONTROL -SALARIES 17,006 30,000 12,994 43% 1000-413-420145-121 OVERTIME 42 300 258 86% 1000-413-420145-153 HEALTH INSURANCE 1,649 6,956 5,307 76% 1000-413-420145-155 RETIREMENT 1,061 1,900 839 44% 1000-413-420147-110 PARKINGS -SALARIES 16,090 35,000 18,910 54% 1000-413-420147-153 HEALTH INSURANCE 6,188 12,500 6,312 50% 1000-413-420147-155 RETIREMENT 1,036 2,250 1,214 54% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 2,245 2,000 245- -12% 1000-413-420147-312 POSTAGE 263 500 237 47% 1000-413-420147-354 CONTRACTED SERVICES 196 1,000 804 80% 1000-413-420147-362 LOT MAINT 0 3,000 3,000 100% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 5,937 5,000 937- -19% 1000-413-420147-550 LOT LEASE PAYMENTS 418 675 257 38% SUBTOTAL POLICE DEPT. ----------- 2,645,349 ---------------------- 3,614,846 ---------- 969,497 27% 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Page 7 Quarterly Finance Report MARCH 31, 2012 75.00% Yr Complete FUND 1000-416-420400-110 1000-416-420400-112 1000-416-420400-114 1000-416-420400-115 1000-416-420400-121 1000-416-420400-153 1000-416-420400-155 1000-416-420400-210 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-345 1000-416-420400-354 1000-416-420400-362 1000-416-420400-366 1000-416-420400-369 1000-416-420400-373 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 ACTUAL YTD BUDGET FIRE DEPARTMENT SALARIES -FIRE SUPPRESSION SALARY -SEVERANCE COMPTIME BUYOUT OUT OF RANK PAY OVERTIME HEALTH INSURANCE RETIREMENT OFFICE/COMPUTER SUPPLIES Equipment (Non Capital) SAFETY EQUIP & SUPPLIES JANITORIAL SUPPLIES CONSUMABLE TOOLS/UNIFORMS PRINTING SUBSCRIPTIONS/PUBLICATIONS/MATERIAL TELEPHONE & COMMUNICATION CONTRACT SERVICES EQUIPMENT MAINTENANCE BUILDING MAINTENANCE -STATION 62 RADIO EQUIPMENT & MAINT. DUES & TRAINING DEBT RETIREMENT -FIRE TRUCK INTEREST EXPENSE -FIRE TRUCK SALARIES -FIRE PREVENTION OVERTIME HEALTH INSURANCE RETIREMENT SUBTOTAL FIRE DEPT. GRAND TOTAL GENERAL FUND REMAINING % 941,756 1,369,945 428,189 31% 7,173 10,000 2,827 28% 2,442 5,000 2,558 51% 7,686 6,978 708- -10% 31,155 32,000 845 3% 213,462 270,825 57,363 21% 127,588 187,677 60,089 32% 618 2,700 2,082 77% 6,269 7,500 1,231 16% 15,118 15,000 118- -1% 1,485 1,500 15 1% 11,558 15,000 3,442 23% 134 700 566 81% 80 1,250 1,170 94% 3,479 8,500 5,021 59% 7,960 8,000 40 1% 5,320 6,500 1,180 18% 8,727 2,500 6,227- -249% 7,929 10,500 2,571 24% 5,193 16,650 11,457 69% 55,896 55,896 0 0% 10,946 10,875 71- -1% 29,568 38,414 8,846 23% 392 500 108 22% 4,389 7,238 2,849 39% 1,877 ----------- 2,514 637 25% 1,508,201 ----------- 2,094,162 --------------------- 585,961 28% 6,671,138 9,282,276 2,611,138 28% 04/12/12 FUND FUND ----------------------------------------------- SPECIAL REVENUE FUNDS: CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 ACTUAL YTD BUDGET ------------------------------- 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 2185-000-430300-356 REDEVELOPMENT / CONTRACT SERVICES 2185-000-430300-522 ADMINISTRATIVE TRANSFER 2185-000-430300-840 REDEVELOPMENT ACTIVITY 2185-480-470240-110 SALARIES 2185-480-470240-153 HEALTH INSURANCE 2185-480-470240-155 RETIREMENT TOTAL AIRPORT TIF 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 2188-480-470230-153 HEALTH INSURANCE 2188-480-470230-155 RETIREMENT 2188-480-470230-353 AUDIT 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 2188-480-470230-356 CONTRACT SERVICES/BOND ISSUE COSTS 2188-480-470230-522 ADMINISTRATIVE TRANSFER 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 2188-480-470230-840 TRANSFER TO DEBT SERVICE TOTAL WESTSIDE TIF 2210 PARKS IN LIEU 2210-436-460430-826 TRANSFER TO ISTEA FUND 2210-436-460430-934 CAPITAL IMPROVEMENTS 2210-436-460430-936 LAWRENCE PARK IMPROVEMENTS 2210-436-460430-937 WESTVIEW IMPROVEMENTS TOTAL PARKS IN LIEU 2215 NEW PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 2215-000-311200-000 PERSONAL PROPERTY TAXES 2215-000-312000-000 PEN & INTEREST DEL TAXES 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 2215-000-346030-000 SWIMMING POOL FEES 2215-000-346040-000 CONCESSION STAND REVENUE 2215-000-346050-000 Parks Usage Fees 2215-000-346051-000 RECREATION FEES 2215-000-346052-000 SPORTS PROGRAMS 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 2215-000-346054-000 AFTER SCHOOL PROGRAMS 2215-000-346055-000 ICE RINK 2215-000-346057-000 YOUTH CAMPS 2215-000-346059-000 PICNIC IN THE PARK 2215-000-365010-000 ROUND UP FOR SAFETY GRANT 2215-000-371010-000 INVESTMENTS/DONATIONS/MISC.SALES 2215-000-381060-000 HEALTH INSURANCE TRANSFER TOTAL PARKS & REC REVENUE PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 2215-436-460430-111 SEASONAL SALARIES 2215-436-460430-121 OVERTIME 2215-436-460430-153 HEALTH INSURANCE 2215-436-460430-155 RETIREMENT 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2215-436-460430-224 JANITORIAL SUPPLIES 2215-436-460430-229 OTHER SUPPLIES REMAINING % 0 1,200 1,200 100% 1,263 10,000 8,737 87% 8,844 11,792 2,948 25% 0 1,000,000 1,000,000 100°% 14,563 18,218 3,655 20% 2,105 2,305 200 9% 949 1,185 236 20% ----------- 27,725 ----------- 1,044,700 --------------------- 1,016,975 97% 15,526 19,016 3,490 18% 2,305 2,553 248 10% 1,013 1,237 224 18% 1,200 1,250 50 4% 5,000 5,000 0 0% 18,200 40,000 21,800 55% 12,821 17,094 4,274 25% 465,000 2,461,604 1,996,604 81% 0 ----------- 6,000 ----------- 6,000 100% 521,064 2,553,754 --------------------- 2,032,690 80% 17,435 20,672 3,237 16s 0 5,000 5,000 100% 0 12,000 12,000 100% 0 --------- 15,000 ----------- 15,000 ----------- 100% 17,435 52,672 ---------- 35,237 67% 480,979 893,205 412,226 46% 39,550 39,200 350- -1% 3,421 2,500 921- -37% 2,600 5,000 2,400 48% 92,017 140,000 47,983 34% 26,691 32,500 5,809 18% 9,398 19,000 9,602 51% 9,384 10,000 616 6% 35,879 40,800 4,922 12% 1,541 3,500 1,959 56% 37,820 32,580 5,240- -16% 15,951 21,000 5,049 24% 39,139 78,000 38,861 50% 16,878 26,000 9,122 35% 1,740 1,740 0 0% 2,025 1,850 175- -9% 40,850 -------- 65,000 ----------- 24,150 37% 855,864 ----------- 1,411,875 ---------- 556,011 39% 181,212 261,049 79,837 31% 29,131 36,855 7,724 21% 484 1,000 516 52% 51,474 63,399 11,925 19% 12,323 18,539 6,216 34% 847 2,100 1,253 60% 2,256 3,500 1,244 36% 2,424 4,500 2,076 46% Page 8 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Page 9 Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,602 2,500 898 36% 2215-436-460430-320 PRINTING & ADVERTISING 213 506 293 58% 2215-436-460430-341 ELECTRICITY 7,437 14,250 6,813 48% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 16,278 21,000 4,722 22% 2215-436-460430-344 NATURAL GAS 1,901 3,200 1,299 41% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,574 2,500 926 37% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 1,500 1,500 0 0% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 2,877 5,000 2,123 42% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 4,908 8,000 3,092 39% 2215-436-460430-364 LANDSCAPING 839 5,000 4,161 83% 2215-436-460430-367 VANDALISM REPAIRS 2,731 4,000 1,269 32% 2215-436-460430-373 DUES & TRAINING 1,280 2,700 1,420 53% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 552 600 48 8% 2215-436-460430-395 EQUIPMENT RENTAL 175 500 325 65% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 76 1,050 974 93% 2215-436-460430-440 IRRIGATION SUPPLIES 6,759 9,000 2,241 25% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 260 4,000 3,740 94% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 1,379 1,380 1 0% 2215-436-460430-620 DEBT SERVICE INTEREST 149 150 1 1% 2215-436-460430-920 EQUIPMENT 17,411 17,000 411- -2% TOTAL PARKS EXPENDITURES ----------- 350,053 ---------------------- 496,278 ---------- 146,225 29% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 22,993 32,111 9,118 28% 2215-436-460440-111 SEASONAL SALARIES 26,948 52,045 25,097 48% 2215-436-460440-153 HEALTH INSURANCE 7,723 9,395 1,672 18% 2215-436-460440-155 RETIREMENT 2,340 4,158 1,818 44% 2215-436-460440-221 SAFETY EQUIPMENT 88 875 787 90s 2215-436-460440-229 OTHER SUPPLIES 3,947 17,500 13,553 77% 2215-436-460440-341 ELECTRICITY 5,436 5,600 164 3% 2215-436-460440-345 TELEPHONE & COMMUNICATION 122 300 178 59% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 854 700 154- -22% 2215-436-460440-367 VANDALISM REPAIRS 770 300 470- -157% 2215-436-460440-373 DUES & TRAINING 60 135 75 56% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-440 IRRIGATION 1,668 3,400 1,732 51% 2215-436-460440-452 SAND & GRAVEL 676 1,000 324 32% 2215-436-460440-610 DEBT SERVICE -PRINCIPAL 13,763 13,763 0 0% 2215-436-460440-620 DEBT SERVICE -INTEREST 1,256 1,257 1 0% 2215-436-460440-920 CAPITAL IMPROVEMENTS (fencing) 6,350 6,350 0 0% ----------- TOTAL ATHLETIC COMPLEX ----------- 94,993 ----------- 150,039 ---------- 55,046 37% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 62,004 89,823 27,819 31% 2215-436-460431-111 SEASONAL SALARIES 5,734 9,761 4,027 41% 2215-436-460431-153 HEALTH INSURANCE 16,257 19,659 3,402 17% 2215-436-460431-155 RETIREMENT 4,057 6,158 2,101 34% 2215-436-460431-218 DONATED SUPPLIES (donation FYll) 2,011 2,025 14 1% 2215-436-460431-229 MISC. SUPPLIES 6,188 9,625 3,437 36% 2215-436-460431-320 PRINTING & ADVERTISING 206 6,300 6,094 97% 2215-436-460431-345 TELEPHONE & COMMUNICATION 476 600 124 21% 2215-436-460431-354 CONTRACT SERVICES 14,669 19,450 4,781 25% 2215-436-460431-373 DUES & TRAINING 913 1,650 737 45% ----------- TOTAL RECREATION ----------- 112,515 ----------- 165,051 ---------- 52,536 32% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 47,250 67,605 20,355 30% 2215-436-460448-111 SEASONAL SALARIES 60,880 74,692 13,812 18% 2215-436-460448-121 OVERTIME 17 500 483 97% 2215-436-460448-153 HEALTH INSURANCE 15,335 18,548 3,213 17% 2215-436-460448-155 RETIREMENT 2,984 5,662 2,678 47% 2215-436-460448-229 MISC. SUPPLIES 1,836 3,850 2,014 52% 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Page 10 Quarterly Finance Report MARCH 31, 2012 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2215-436-460448-320 PRINTING & ADVERTISING 149 450 301 67% 2215-436-460448-345 TELEPHONE & COMMUNICATION 0 400 400 100% 2215-436-460448-354 CONTRACT SERVICES 7,919 12,600 4,681 37% 2215-436-460448-355 AFTER SCHOOL PROGRAM 664 2,500 1,836 73% 2215-436-460448-356 BANK FEES/CC CHARGES 1,751 2,500 749 30% 2215-436-460448-366 BLDG IMPROVEMENTS(Roundup 4 Safety) 0 1,740 1,740 100% 2215-436-460448-373 DUES & TRAINING 178 600 422 70% TOTAL YOUTH CAMPS ----------- 138,964 ----------- 191,647 --------------------- 52,683 27% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 125,229 197,479 72,250 37% 2215-437-460445-121 OVERTIME 949 900 49- -5% 2215-437-460445-155 RETIREMENT 604 2,058 1,454 71% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 202 700 498 71% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,043 3,200 2,157 67% 2215-437-460445-226 CHLORINE/CHEMICALS 15,307 23,000 7,693 33% 2215-437-460445-228 CONCESSION STAND SUPPLIES 9,452 19,000 9,548 50% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 3,431 4,400 969 22% 2215-437-460445-341 ELECTRICITY 5,503 12,500 6,997 56% 2215-437-460445-344 NATURAL GAS 18,275 24,000 5,725 24% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 637 1,500 863 58% 2215-437-460445-354 LICENSES & FEES 731 1,300 569 44% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 2,580 8,200 5,620 69% 2215-437-460445-380 TRAINING MATERIALS 0 250 250 100% TOTAL POOL EXPENDITURES ----------- 183,942 ----------- 298,487 --------------------- 114,545 38% TOTAL PARKS & RECREATION/POOL 880,467 1,301,502 421,035 32% 04/12/12 FUND FUND CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 ACTUAL YTD BUDGET ------------------------------------------------- 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-112 SEVERANCE 2230-440-420730-114 COMPTIME BUYBACK 2230-440-420730-115 OUT OF RANK PAY 2230-440-420730-121 OVERTIME 2230-440-420730-153 HEALTH INSURANCE 2230-440-420730-155 RETIREMENT 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 2230-440-420730-218 NON -CAPITAL EQUIPMENT 2230-440-420730-231 GAS & OIL 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 2230-440-420730-312 POSTAGE/PRINTING 2230-440-420730-345 TELEPHONE & COMMUNICATION 2230-440-420730-354 PARAMEDIC RECERTIFICATION 2230-440-420730-355 911 CENTER CONTRIBUTION 2230-440-420730-359 AUDIT/CC OTHER FEES 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 2230-440-420730-373 DUES & TRAINING 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 TOTAL AMBULANCE FUND 2310 OLD SCHOOL TIF - TECH 2310-480-470210-354 CONTRACT SERVICES - BOND COUNSEL 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 2310-480-470210-356 FED -EX REIMBURSEMENT 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT TOTAL 2310 OLD SCHOOL TECH TIF 2311 OLD SCHOLL TIF INDUSTRIAL 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT TOTAL 2311 OLD SCHOOL INDUSTR. 2372 HEALTH PERMISIVE LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND TOTAL 2372 HEALTH LEVY REMAINING % 423,725 605,000 181,275 30% 43,510 85,000 41,490 49% ill 200 89 45% 584 800 216 27% ----------- 467,930 ----------- 691,000 --------------------- 223,070 32% 259,359 397,702 138,343 35% 7,173 7,500 327 4% 0 3,000 3,000 100% 0 1,647 1,647 100% 7,346 12,000 4,654 39% 63,276 81,892 18,616 23% 35,231 56,373 21,142 38% 1,247 3,500 2,253 64% 2,049 2,500 451 18% 4,311 7,000 2,689 38% 4,009 7,500 3,491 47% 798 3,500 2,702 77% 731 700 31- -4% 8,139 12,000 3,861 32% 15,000 30,000 15,000 50% 927 1,400 473 34% 7,959 8,000 41 1% 1,298 8,000 6,702 84% 5,365 22,500 17,135 76% 27,147 35,000 7,853 22% 9,785 16,100 6,315 39% 7,125 9,500 2,375 25% 17,295 23,060 5,765 25% 8,012 ----------- 10,683 2,671 25% ----------- 493,580 ----------- 761,057 ---------- 267,477 35% 0 1,000 1,000 100% 12,713 12,713 0 0% 10,908 10,910 2 0% 25,000 ----------- 40,000 15,000 38% ----------- 48,621 ----------- 64,623 ---------- 16,002 25% 7,000 18,000 11,000 61% ---------------------- 7,000 ----------- 18,000 ---------- 11,000 61% 383,000 ----------- 648,147 265,147 41% ----------- 383,000 ----------- 648,147 ---------- 265,147 41% Page 11 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------- 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 220,307 190,000 30,307- -16% 2394-000-323103-000 PLUMBING PERMITS 9,449 15,000 5,551 37% 2394-000-323104-000 MECHANICAL PERMITS 14,229 22,000 7,771 35% 2394-000-323107-000 HOUSE MOVING PERMITS 0 200 200 100% 2394-000-323108-000 PLAN REVIEW FEES 114,287 60,000 54,287- -90% 2394-000-371010-000 INVESTMENT EARNINGS 1,221 1,000 221- -22% TOTAL REVENUE ----------- 359,493 ----------- 288,200 --------------------- 71,293- -25% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 156,706 215,510 58,804 27% 2394-420-420530-121 OVERTIME 244 3,000 2,756 92% 2394-420-420530-153 HEALTH INSURANCE 35,205 43,492 8,287 19% 2394-420-420530-155 RETIREMENT 10,163 13,409 3,246 24% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 1,806 4,750 2,944 62% 2394-420-420530-231 GAS & OIL 1,400 2,250 850 38% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 450 2,600 2,150 83% 2394-420-420530-323 ST. ED. ASSESSMENTS 498 2,500 2,002 80% 2394-420-420530-345 TELEPHONE & COMMUNICATION 949 1,500 551 37% 2394-420-420530-353 AUDITING 3,500 3,500 0 0% 2394-420-420530-354 CONTRACT SERVICES 837 1,300 463 36% 2394-420-420530-373 DUES & TRAINING 613 3,400 2,787 82% 2394-420-420530-510 PROPERTY INSURANCE 4,090 4,100 10 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 225 300 75 25% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 7,675 10,324 2,649 260 2394-420-420530-528 DATA PROCESSING TRANSFER 3,134 4,179 1,045 25% TOTAL BUILDING DEPT. ----------- 227,494 ----------- 316,114 --------------------- 88,620 28% 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 5,000 5,000 0 0% 2399-413-420140-940 POLICE EQUIPMENT 0 40,000 40,000 100% 2399-416-420400-354 IMPACT FEE REVIEW 88 150 62 41% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 27,000 27,000 0 0% 2399-416-420400-620 INTEREST - FIRE TRUCK 8,375 8,387 12 0% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 200,000 200,000 100% TOTAL 2399 IMPACT FEE FUND ---------------------- 40,463 ----------- 280,537 ---------- 240,074 86% 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 2400-410-430263-153 HEALTH INSURANCE 2400-410-430263-155 RETIREMENT 2400-410-430263-244 STREET LIGHT SUPPLIES 2400-410-430263-341 ELECTRICITY 2400-410-430263-360 REPAIR & MAINT SERVICES 2400-410-430263-510 INSURANCE 2400-410-430263-522 ADMINISTRATIVE TRANSFER 26,631 38,477 5,996 9,295 1,690 2,372 10,624 13,000 102,727 163,000 5,997 28,000 872 975 5,702 7,603 TOTAL LIGHT MAINT. 160,239 262,722 11,846 31% 3,299 35% 682 29% 2,376 18% 60,273 37% 22,003 79% 103 11% 1,901 25% --------------------- 102,483 39% Page 12 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Page 13 Quarterly Finance Report MARCH 31, 2012 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 33,468 35,000 1,532 4% 2420-421-430234-957 ALLEY PAVING 30,742 45,000 14,258 32% 2420-421-430240-231 GAS & OIL 22,530 35,000 12,470 36% 2420-421-430240-344 NATURAL GAS 0 3,500 3,500 100% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 47,156 247,575 200,419 81% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 10,000 10,000 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 30,952 132,407 101,455 77% 2420-421-430240-369 RADIO EQUIPMENT & MAINT. 1,000 700 300- -43% 2420-421-430240-452 GRAVEL 564 3,000 2,436 81% 2420-421-430240-453 MATERIALS; CONTRACT PREP. 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 28,462 45,000 16,538 37% 2420-421-430240-472 ASPHALT 15,191 30,000 14,809 49% 2420-421-430240-473 CRACK SEALING 5,000 5,000 0 0% 2420-421-430240-533 EQUIPMENT RENTAL 0 5,500 5,500 100% ----------- TOTAL GAS TAX 215,064 ----------- 602,682 --------------------- 387,618 64% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 391,169 583,985 192,817 33% 2500-421-430240-112 RETIREMENT -severance 9,929 8,500 1,429- -17% 2500-421-430240-121 OVERTIME 3,412 30,000 26,588 89% 2500-421-430240-153 HEALTH INSURANCE 118,992 155,620 36,628 24% 2500-421-430240-155 RETIREMENT 25,334 36,388 11,054 30% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 2,992 5,000 2,008 40% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 2,450 2,200 250- -11% 2500-421-430240-220 OTHER SUPPLIES 4,224 3,900 324- -80 2500-421-430240-231 GAS & OIL 22,682 40,000 17,318 43% 2500-421-430240-341 ELECTRICITY 717 1,400 683 49% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 741 1,000 259 26% 2500-421-430240-354 CONTRACT SERVICES 9,886 12,500 2,614 21% 2500-421-430240-355 CONTRACT SERV.-AERIAL MAPPING 0 5,000 5,000 100% 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 23,348 28,000 4,652 17% 2500-421-430240-366 BUILDING MAINTENANCE 3,761 1,500 2,261- -151% 2500-421-430240-373 DUES & TRAINING 2,465 2,500 35 1% 2500-421-430240-388 MEDICAL SERVICES 1,101 1,100 1- 0% 2500-421-430240-510 LIABILITY INSURANCE 78,797 85,000 6,203 7% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 52 10,000 9,949 99% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 49,500 66,000 16,500 25% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 48,530 64,707 16,177 25% 2500-421-430240-528 DATA PROCESSING TRANSFER 8,017 10,689 2,672 25% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 0 33,200 33,200 100% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 200 2,285 2,085 91% 2500-421-430240-720 IMPACT FEE REIMBURSEMENTS 144,072 144,072 0 0% 2500-421-430240-840 MACI GRANT MATCH 0 40,000 40,000 100% 2500-421-430240-940 MACHINERY & EQUIPMENT 46,058 172,000 125,942 73% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 99,023 450,000 350,977 78% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 13,675 10,000 3,675- -37% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 31,041 31,041 1000 2500-421-430264-110 TSS - SALARIES 93,796 140,306 46,511 33% 2500-421-430264-121 OVERTIME 6,515 8,500 1,985 23% 2500-421-430264-153 HEALTH INSURANCE 14,513 19,524 5,011 26% 2500-421-430264-155 RETIREMENT 6,223 B,862 2,639 30% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 355 1,500 1,145 76% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 7,961 8,600 639 7% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 2,210 2,250 40 2% 2500-421-430264-242 STREET SIGNS 31,645 40,000 8,355 21% 2500-421-430264-243 TRAFFIC SIGNALS 6,758 10,000 3,242 32% 2500-421-430264-245 BARRICADE MATERIALS 200- 4,500 4,700 104% 2500-421-430264-341 ELECTRICITY 3,820 9,000 5,180 58% 2500-421-430264-345 COMMUNICATIONS 515 700 185 26% 2500-421-430264-354 CONTRACT SERVICES 18,439 10,000 8,439- -84% 2500-421-430264-362 EQUIPMENT MAINTENANCE 1,974 2,500 526 21% 2500-421-430264-366 BUILDING MAINTENANCE 4,655 1,500 3,155- -210% 2500-421-430264-373 DUES & TRAINING 2,566 2,500 66- -3& 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING $ ---------------------------------------------------------------------------------------------------------------- 2500-421-430264-428 PAINT MATERIALS 4,445 15,000 10,555 70% 2500-421-430264-510 LIABILITY INS.-TSS 3,749 3,800 51 1$ 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,400 2,400 100% 2500-421-430264-532 OFFICE RENT 7,838 7,838 0 0% TOTAL SPEC. ST. MAINT. ----------- 1,328,902 ----------- 2,358,867 --------------------- 1,029,965 44% 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 100,664 149,472 48,808 33% 2600-436-460433-121 OVERTIME 196 750 554 74% 2600-436-460433-153 HEALTH INSURANCE 27,485 33,893 6,408 19% 2600-436-460433-155 RETIREMENT 6,408 9,258 2,850 31% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 274 550 276 50% 2600-436-460433-241 CONSUMABLE TOOLS 348 950 602 63% 2600-436-460433-354 CONTRACT SERVICES 0 500 500 100% 2600-436-460433-357 FORESTRY GRANT 0 3,890 3,890 100% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 6,670 14,000 7,330 52% 2600-436-460433-362 EQUIPMENT MAINTENANCE 396 1,800 1,404 78% 2600-436-460433-364 LANDSCAPING & TREES 4,735 7,500 2,765 37% 2600-436-460433-373 DUES & TRAINING 250 300 50 17% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 3,489 4,000 511 13% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 2,250 3,000 750 25% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 4,969 6,625 1,656 25% 2600-436-460433-528 DATA PROCESSING TRANSFER 1,002 1,336 334 25% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 4,136 4,136 0 0% 2600-436-460433-620 INTEREST EXPENSE 447 447 0 0% TOTAL URBAN FORESTRY ----------- 163,719 ----------- 242,407 --------------------- 78,688 32% 2601 DEVELOPER TREES 2601-436-460435-351 EMPIRE ESTATES ($44,911) 0 8,948 8,948 100% 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 100% 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 566 2,112 1,546 73% 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,547 33,756 31,209 92% 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,113 ----------- 97,833 --------------------- 94,720 97% Page 14 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 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 41,062 56,230 15,168 27% 2886-480-470210-153 HEALTH INSURANCE 5,800 6,984 1,184 17% 2886-480-470210-155 RETIREMENT 2,687 3,638 951 26% 2886-480-470210-210 OFFICE SUPPLIES 881 2,500 1,619 65% 2886-480-470210-211 GRANT ADMIN. & PROJ. EXPENSES 35 3,000 2,965 99% 2886-480-470210-312 POSTAGE & PRINTING 825 1,150 325 28% 2886-480-470210-334 MT WEST MEMBERSHIP 0 500 500 100% 2886-480-470210-345 TELEPHONE & COMMUNICATION 321 250 71- -28% 2886-480-470210-353 AUDITING 1,200 1,800 600 33% 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-373 DUES & TRAINING 2,652 3,800 1,148 30% 2886-480-470210-379 MEETINGS 475 500 25 5% 2886-480-470210-395 CDBG- GROWTH POLICY UPDATE 0 20,000 20,000 100% 2886-480-470210-396 GRANT SERVICES 3,220 25,000 21,780 87% 2886-480-470210-510 PROPERTY & LIABILITY INS. 2,896 3,000 104 3% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 4,238 5,651 1,413 25% 2886-480-470210-528 DATA PROCESSING TRANSFER 5,010 6,680 1,670 25% 2886-480-470210-532 OFFICE RENT 4,703 4,703 0 0% 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 2,500 2,500 100% TOTAL UDAG FUND ----------- 76,055 ----------- 151,886 --------------------- 75,831 50% RURAL DEVELOPMENT REVOLVING 2887-480-470210-110 SALARIES 15,045 18,868 3,823 20% 2887-480-470210-153 HEALTH INSURANCE 2,169 2,675 506 19% 2887-480-470210-155 RETIREMENT 981 1,221 240 20% 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 17,385 17,386 1 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 4,689 4,689 0 0% 2887-480-470210-750 REDEVELOPMENT LOANS 162,651 ----------- 200,000 37,349 19% TOTAL RURAL DEVELOPMENT 202,920 ----------- 244,839 --------------------- 41,920 17% 2888 RURAL DEV. #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 7,990 7,731 259- -3% 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-03 2,035 2,283 248 11% 2888-480-470210-750 REDEVELOPMENT LOANS 27 85,000 84,973 100% TOTAL 2888 RURAL DEV. #2 ----------- 10,052 ----------- 95,014 --------------------- 84,962 89% 2945 CDBG-ED FVCC #2 2945-480-470242-780 TRAINING COSTS 0 15,000 15,000 100% 2945-480-470242-790 MACHINERY/EQUIPMENT 0 246,800 246,800 100% 2945-480-470242-820 ADMIN TRANSFER -to Com. Deveolpment 0 12,145 12,145 100% TOTAL 2945 CDBG-ED FVCC 42 ---------------------- 0 273,945 --------------------- 273,945 100% 2953 EPA BROWNSFIELD GRANT 2953-480-470210-229 SUPPLIES -PETROLEUM 0 452 452 100% 2953-480-470210-352 SALARIES -PETROLEUM 743 13,347 12,604 94% 2953-480-470210-353 BENEFITS -PETROLEUM 334 1,341 1,007 75% Page 15 75.00% Yr Complete 04/12/12 FUND FUND CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 ACTUAL YTD BUDGET ----------------------------------------------------------------- 2953-480-470210-354 CONTRACTED SERV-PETROLEUM 2953-480-470210-373 TRAVEL -PETROLEUM 2953-480-470210-780 BRWNSFLD ASSESS/PETROLEUM 2953-480-470210-781 BRWNSFLD ASSESS/HAZARDOUS SUBSTANCE 2953-480-470215-229 SUPPLIES -HAZARDOUS SUBST 2953-480-470215-352 SALARIES -HAZARDOUS SUBST 2953-480-470215-353 BENEFITS -HAZARDOUS SUBST 2953-480-470215-354 CONTRACTED SERV-HAZARDOUS SUBST 2953-480-470215-373 TRAVEL -HAZARDOUS SUBST TOTAL EPA BROWNSFIELD GRANT 2954 EPA/BROWNFIELDS PLANNING 2954-480-470210-229 SUPPLIES-AWP GRT 2954-480-470210-352 SALARIES-AWP GRT 2954-480-470210-353 BENEFITS-AWP GRT 2954-480-470210-354 CONTRACTED SERVICES-AWP GRT 2954-480-470210-373 TRAVEL-AWP GRT TOTAL 2954 EPA/BROWNFIELD PLAN REMAINING % ---------------------------------------------- 1,238 133,534 132,297 99% 0 653 653 100% 11,827 11,827 0 0% 53,708 53,708 0 0% 0 297 297 100% 442 10,459 10,017 96% 199 1,223 1,024 84% 4,054 37,863 33,809 89% 0 ----------- 3,355 3,355 100% ----------- 72,544 268,059 --------------------- 195,515 73% 0 2,279 2,279 100% 3,266 48,925 45,659 93% 1,705 13,548 11,843 87% 22,099 84,120 62,021 74% 533 0 533- 0% 27,603 148,872 121,269 81% 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN 6,102 7,743 1,641 21% TOTAL 2915 STONEGARDEN GRANT ----------- 6,102 ----------- 7,743 --------------------- 1,641 21% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 46,941 63,051 16,110 26% 2916-413-420140-121 OVERTIME 6,407 9,000 2,593 29% 2916-413-420140-153 HEALTH INSURANCE 5,800 6,984 1,184 17% 2916-413-420140-155 RETIREMENT 6,192 8,530 2,338 27% 2916-413-420140-210 OFFICE SUPPLIES 0 400 400 100% 2916-413-420140-354 CONTRACT SERVICES 3,336 3,000 336- -11% ----------- TOTAL 2916 DRUG ENFORCEMENT 68,675 ----------- 90,965 --------------------- 22,290 25% 2917 COPS TECHNOLOGY GRANT 2917-413-420140-950 SHOOTING FACILITY/2009CKWX0478 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 2918-413-420140-153 HEALTH INSURANCE 2918-413-420140-155 RETIREMENT TOTAL 2918 COPS HIRING GRANT 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 2919-413-420140-125 DUI TASK FORCE 2919-413-420140-126 HOLIDAY OT REIMB. 2919-413-420140-127 SCHOOL DIST. OT 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 2919-413-420140-221 Bullet Proof Vests TOTAL LAW ENF. GRANT 39,037 50,329 11,292 22% 12,435 14,956 2,521 17% 5,158 ----------- 6,809 1,651 24% ----------- 56,630 ----------- 72,094 ---------- 15,464 21% 577 1,030 453 44% 2,035 8,000 5,965 75% 19,873 50,000 30,127 60% 11,973 20,000 8,027 40% 0 2,500 2,500 100% 4,995 ---------------------- 10,000 5,005 50% 39,452 ----------- 91,530 ---------- 52,078 57% 2920 DOS -IT UPGRADE SAFETY BLD 2920-480-470210-922 PUBLIC SAFETY BLDG -TECH UPGRADES 187,816 216,257 28,441 13% ------------------------------------------- TOTAL 2920 IT UPGRADE -SAFETY 187,816 216,257 28,441 13% Page 16 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- 2921 DRUG COURT GRANT ---------- --------------------- ----------- 2921-406-410360-354 DRUG COURT -contract services 44,267 265,993 221,726 83% TOTAL DRUG COURT GRANT ----------- 44,267 ----------- 265,993 --------------------- 221,726 83% 2951 DUI COURT GRANT 2951-406-410360-355 CS-EVAL,P0,LAC/##2011-02-03-02 16,983 46,078 29,095 63% 2951-406-410360-396 DUI CRT INCENTIVES 528 0 528- 0% 2951-406-410361-354 CS-EVAL,PO,LAC CTS-106006 34,311 97,000 62,689 ---------- 65% TOTAL DUI COURT GRANT ----------- 51,823 ----------- 143,078 ----------- 91,255 64% 2930 PRESERVE AMERICA GRANT 2930-480-470240-218 EQUIPMENT-NPS PRESERVE AMERICA GRT 3,275 4,000 725 18% 2930-480-470240-352 SALARIES-NPS PRESERVE AMERICA GRT 117 4,490 4,373 97% 2930-480-470240-353 BENEFITS-NPS PRESERVE AMERICA GRT 51 1,924 1,873 97% 2930-480-470240-354 CONT SERV-NPS PRESERVE AMERICA 15,966 58,909 42,943 73% TOTAL 2930 PRESERVE AMERICA ----------- 19,410 ----------- ----------- 69,323 ----------- --------------------- 49,913 -------------------- 72% 2927 CULTRUAL ARTS PASSTHRU GT 2927-400-460452-354 HOCKADAY 3,132 9,000 5,868 65% 2927-400-460454-354 GLACIER ORCHESTRA 6,162 13,000 6,838 53% 2927-400-460456-354 NW MT HISTORICAL SOCIETY 2,370 5,000 2,630 53% ----------- TOTAL 2927 CULTURAL ARTS ----------- ---------- 11,664 ----------- 27,000 ---------- ----------- --------------------- 15,336 --------------------- -------------------- 57% 2957 FEMA GRANT 2957-416-420400-110 SALARIES 0 10,000 10,000 100% 2957-416-420400-121 OT-RESPONSE HAZMAT 0 15,000 15,000 100% 2957-416-420400-153 HEALTH INSURANCE 0 1,564 1,564 100% 2957-416-420400-155 RETIREMENT 285 1,436 1,151 80% 2957-416-420400-218 EQUIPMENT (non capital) 8,806 8,350 456- -5% 2957-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 1,331 6,000 4,669 78% 2957-416-420400-229 RESPONSE HAZMAT-MATERIALS 0 6,000 6,000 100% 2957-416-420400-373 RESPONSE HAZMAT-TRAVEL 0 20,000 20,000 100% 2957-416-420410-125 PASS THRU HAZMAT OT 2,238 20,000 17,762 89% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 32,674 56,200 23,526 42% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 961 5,000 4,039 81% 2957-416-420414-218 AFG-FIRE PREV MAT-EMW2010FP00286 6,388 6,380 8- 0% ----------- TOTAL FEMA GRANT ----------- 52,683 155,930 --------------------- 103,247 66% 2958 FEMA -GOLF COURSE PROD. 2958-420-431200-354 CONTRACT SERVICES 327,555 424,970 97,415 23% ----------- TOTAL 2958 FEMA - GOLF PROD. ----------- ----------- ----------- 327,555 ----------- ----------- ----------- 424,970 ----------- ----------- ---------- 97,415 ---------- --------- 23% 2975 ISTEA 2975-436-460457-950 WOODLAND CONNECTOR 137,557 126,000 11,557- -9% 2975-436-460457-951 HWY93 NORTH TRAIL 0 30,000 30,000 100% ----------- TOTAL ISTEA ----------- 137,557 ----------- 156,000 ---------- 18,443 12% 2991 NEIGHBORHOOD STABILIZATIO 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS 64,656 64,656 0 0% ----------- TOTAL 2992 NEIGHBORHOOD STABIL ----------- 64,656 ----------- 64,656 ---------- 0 0% Page 17 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 FUND -------------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % 2992 ENERGY BLOCK GRANT ----------- ----------- --------------------- 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS 64,656 64,656 0 0% TOTAL 2992 ENERGY BLOCK GRANT ----------- 64,656 ----------- 64,656 ----------- ---------- 0 0% 2993 STIMULUS ENERGY #2 2993-412-411230-925 ENERGY IMPROVEMENTS 75,345 92,023 16,678 180 TOTAL 2993 STIMULUS ENERGY #2 ----------- 75,345 ----------- 92,023 --------------------- 16,678 18% 2995 SAFER GRANT 2995-416-420400-110 SALARIES 83,852 153,942 70,090 46% 2995-416-420400-153 HEALTH INSURANCE 29,041 42,023 12,982 31% 2995-416-420400-155 RETIREMENT 11,344 20,898 9,554 46% TOTAL 2995 SAFER GRANT ----------- 124,236 ----------- 216,863 --------------------- 92,627 43% CAPITAL PROJECT FUNDS ----------- ---- ------- --------------_______ 4150 FIRE STATION #61 REMODEL 4150-416-420400-928 FIRE STATION 61 CONSTRUCTION 3,109 10,608 7,500 71% TOTAL 4150 FIRE STATION REMODE ----------- 3,109 ----------- ----------- 10,608 ----------- ----------- ---------- 7,500 --------------------- 71% 4188 WESTSIDE TIF CAPITAL PROD 4188-421-430240-354 MERIDIAN ROAD TRAFFIC IMPROVEMENTS 11,000 300,000 289,000 96% 4188-447-430550-952 COLORADO ST. WATER MAIN EXTENSION 965 200,000 199,035 100% TOTAL 4188 WESTSIDE TIF PROD ----------- 11,965 ----------- 500,000 --------------------- 488,035 98% 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 5,792 25,000 19,208 77% TOTAL 4290 WALK & CURB ----------- 5,792 ----------- 25,000 --------------------- 19,208 77% 4300 FAA NON -PRIMARY ENTITLMNT 4300-430-430310-354 TOWER MITIGATION 0 600,000 600,000 100% TOTAL FAA NP ENTITLEMENT ----------- 0 ----------- 600,000 --------------------- 600,000 100% 4312 FAA PLANNING GRANT 4312-430-430310-940 CAPITAL IMPROVEMENTS 41,600 65,975 24,375 37% TOTAL FAA PLANNING GRANT ----------- 41,600 ----------- 65,975 --------------------- 24,375 37% Page 18 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Page 19 Quarterly Finance Report MARCH 31, 2012 75.00% Yr Complete FUND 5210-000-343210-000 5210-000-343220-000 5210-000-343225-000 5210-000-343230-000 5210-000-343260-000 5210-000-343265-000 5210-000-343270-000 5210-000-343275-000 5210-000-371010-000 5210-447-430550-110 5210-447-430550-112 5210-447-430550-121 5210-447-430550-153 5210-447-430550-155 5210-447-430550-210 5210-447-430550-218 5210-447-430550-226 5210-447-430550-229 5210-447-430550-231 5210-447-430550-312 5210-447-430550-336 5210-447-430550-341 5210-447-430550-344 5210-447-430550-345 5210-447-430550-349 5210-447-430550-353 5210-447-430550-354 5210-447-430550-356 5210-447-430550-362 5210-447-430550-366 5210-447-430550-373 5210-447-430550-388 5210-447-430550-410 5210-447-430550-422 5210-447-430550-423 5210-447-430550-424 5210-447-430550-425 5210-447-430550-510 5210-447-430550-512 5210-447-430550-513 5210-447-430550-521 5210-447-430550-522 5210-447-430550-528 5210-447-430550-532 5210-447-430550-935 5210-447-430550-940 5210-447-430550-944 5210-447-430550-948 5210-447-430550-951 5210-447-430550-956 5210-447-430550-958 5210-447-430550-963 5210-447-430550-964 5210-447-430550-965 5210-447-430555-930 5210-447-430555-941 5210-447-430555-953 FUND ------------------------------------ ENTERPRISE FUNDS WATER REVENUE METERED WATER SALES UNMETERED WATER SALES IMPACT FEES METER REPLACEMENT FEE INSTALL/SALE OF MAT./TOWER RENT/OTH IMPACT ADMIN FEES WATER TURN ON FEES TAG FEE INVESTMENT EARNINGS TOTAL WATER REVENUE WATER FACILITIES SALARIES -WATER SALARIES -RETIREMENT OVERTIME HEALTH INSURANCE RETIREMENT OFFICE & COMPUTER SUPPLIES NON CAP & SAFETY EQUIP/SUPPLIES CHLORINE & CHEMICALS JANITORIAL/OTHER SUPPLIES GAS & OIL POSTAGE & PRINTING/ADVERTISING LICENSES & FEES ELECTRICITY NATURAL GAS TELEPHONE & COMMUNICATION LAB SERVICES AUDITING CONTRACT SERVICES CONSULTANTS-WTR RIGHTS/MODELING EQUIP REPAIRS/MAINT/RENTAL BUILDING MAINTENANCE DUES & TRAINING MEDICAL SERVICES CONSTRUCTION MATERIALS HYDRANTS MATERIALS FOR MAINS MATERIALS -SERVICE LINES MATERIALS PUMPS/WELLS PROPERTY & LIABILITY INS. UNINSURED LOSS -DEDUCTIBLE UNINSURED LOSS -GOODWILL CENTRAL GARAGE TRANSFER ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER LEASE PAYMENTS (City Hall rent) ARMORY WELL GENERATOR REPLACEMENT MACHINERY & EQUIPMENT METER MAINTENANCE VEHICLE METERS (METER FUNDS) 010125 SECURITY SYSTEM UPGRADES UPPER/LOWER INTERCONNECTION FOUR (4) LOOPED PROJECTS ABANDON 2" H2O LINE 2ND AVE WN H2O LINE REPLACE E AZ H2O LINE UPSIZE CONTRACT MAIN UPSIZE METERS (NEW SERVICES)010120 SECTION 36 WELL TOTAL WATER FACILITIES ACTUAL YTD BUDGET REMAINING % 1,876,682 2,203,000 326,318 15% 3,561 5,000 1,439 29% 104,405 225,000 120,595 54% 74,225 95,000 20,775 22% 8,497 12,000 3,503 29% 0 13,000 13,000 100% 2,015 3,000 985 33% 13,900 20,000 6,100 31% 32,129 55,000 22,871 42% ----------- 2,115,415 ----------- 2,631,000 --------------------- 515,585 20% 442,965 662,555 219,590 33% 6,192 7,000 808 12% 15,009 20,000 4,991 25% 106,901 146,924 40,023 27% 29,176 41,289 12,113 29% 3,658 12,450 8,792 71% 10,495 19,500 9,005 46% 23,600 38,000 14,400 38% 2,008 4,800 2,792 58% 21,297 29,000 7,703 27% 330 4,500 4,170 93% 14,936 19,000 4,064 21% 88,633 143,000 54,367 38% 9,524 13,000 3,476 27% 5,945 8,000 2,055 26% 8,715 25,500 16,785 66% 2,500 3,000 500 17% 37,303 70,000 32,697 47% 903 25,000 24,097 96% 10,677 14,950 4,273 29% 6,985 17,000 10,015 59°% 6,271 7,200 929 13% 606 700 94 13% 20,158 30,000 9,842 33% 8,666 15,000 6,334 42% 5,044 11,000 5,956 54% 6,649 9,000 2,351 26% 3,713 36,000 32,287 90% 33,193 34,500 1,307 4% 2,427 11,500 9,073 79% 0 7,500 7,500 100% 6,000 8,000 2,000 25% 68,389 91,185 22,796 25% 15,031 20,041 5,010 25% 7,838 7,838 0 0% 0 90,000 90,000 100% 0 45,000 45,000 100% 24,156 25,000 844 3% 53,295 75,000 21,705 29% 3,364 40,000 36,636 92% 29,515 30,000 485 2% 0 411,800 411,800 100% 0 45,000 45,000 100% 0 248,000 248,000 100% 0 195,000 195,000 100% 0 50,000 50,000 100% 53,075 65,000 11,925 18% 2,157 ---------- 46,000 43,844 95% 1,197,300 ---------- ----------- 2,979,732 ----------- --------------------- 1,782,432 --------------------- 60% 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING $ ------------------------------------------------------------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 5210-447-430560-112 SEVERANCE/RETIREMENT 5210-447-430560-153 HEALTH INSURANCE 5210-447-430560-155 RETIREMENT 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 5210-447-430560-353 AUDITING 5210-447-430560-354 CONTRACT SERVICES 5210-447-430560-355 BILLING COSTS 5210-447-43OS60-373 DUES & TRAINING 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 2001 SRF INTEREST 4% TOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE TOTAL DEPRECIATION TOTAL WATER FUND 64,497 89,596 25,099 2,386 0 2,386- 20,345 25,283 4,938 4,235 5,823 1,589 1,435 3,225 1,790 1,500 1,500 0 2,028 5,000 2,972 23,534 27,775 4,241 1,234 1,500 266 5,221 6,961 1,740 16,531 22,041 5,510 7,838 7,838 0 ---------------------- 150,783 ---------------------- ----------- 196,542 ----------- - 45,759 - 28% 0% 20% 27% 56% 0% 59% 15% 18% 25°% 25% 0% 23% 0 55,000 55,000 100% 41,195 41,195 0 0% 300 300 0 0% 0 186,000 186,000 100% 76,651 76,651 0 0% 0 39,000 39,000 100% 17,340 ----------- 17,340 0 0% 135,486 ----------- ----------- 415,486 ----------- --------------------- 280,000 --------------------- 67% 0 ----------- 825,000 825,000 100% 0 ----------- ----------- 825,000 ----------- --------------------- 825,000 --------------------- 100% 1,483,569 4,416,760 2,933,191 66% Page 20 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Page 21 Quarterly Finance Report MARCH 31, 2012 75.00% Yr Complete FUND FUND ------------------------------------------------------------- SEWER REVENUE: 5310-000-343310-000 SEWER SERVICE CHARGES 5310-000-343330-000 IMPACT FEES (SANITARY) 5310-000-343335-000 IMPACT FEES (WWTP) 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 5310-000-371010-000 INVESTMENT EARNINGS 5310-454-430620-110 5310-454-430620-112 5310-454-430620-153 5310-454-430620-155 5310-454-430620-215 5310-454-430620-353 5310-454-430620-355 5310-454-430620-373 5310-454-430620-522 5310-454-430620-528 5310-454-430620-532 5310-454-430630-110 5310-454-430630-112 5310-454-430630-121 5310-454-430630-153 5310-454-430630-155 5310-454-430630-210 5310-454-430630-218 5310-454-430630-229 5310-454-430630-231 5310-454-430630-312 5310-454-430630-341 5310-454-430630-342 5310-454-430630-344 5310-454-430630-345 5310-454-430630-353 5310-454-430630-354 5310-454-430630-356 5310-454-430630-362 5310-454-430630-373 5310-454-430630-388 5310-454-430630-410 5310-454-430630-425 5310-454-430630-510 5310-454-430630-512 5310-454-430630-521 5310-454-430630-522 5310-454-430630-528 5310-454-430630-532 5310-454-430630-535 TOTAL SEWER REVENUE EXPENDITURES: SEWER BILLING COSTS SALARIES -SEWER BILLING SEVERANCE/RETIREMENT HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES/computers AUDITING/OTHER CONTRACT SERVICES BILLING COSTS DUES & TRAINING ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER OFFICE RENT TOTAL SEWER BILLING COSTS SANITARY SEWER/COLLECTION SALARIES -SANITARY SEWER SALARIES-SEVERANCE/RETIREMENT OVERTIME HEALTH INSURANCE RETIREMENT OFFICE/COMPUTER SUPPLIES/EQUIP NON CAP/SAFETY EQUIP & SUPPLIES JANITORIAL/OTHER SUPPLIES GAS & OIL POSTAGE, PRINTING & ADVERTISING ELECTRICITY WATER NATURAL GAS TELEPHONE & COMMUNICATION AUDITING CONTRACT SERVICES CONSULTANTS BLDGS/EQUIPMENT MAINTENANCE DUES & TRAINING MEDICAL SERVICES CONSTRUCTION MATERIALS MATERIALS PUMPS/LIFT ST. PROPERTY & LIABILITY INS. UNINSURED LOSS -DEDUCTIBLE CENTRAL GARAGE TRANSFER ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER OFFICE RENT TRANSPORTATION CHGS/TRUMBULL CRK TOTAL SANITARY SEWER/COLLECTIO SANITARY SEWER PLANT INVEST $ 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE TOTAL SANITARY SEWER PLANT INV REVENUE BONDS/SANITARY ACTUAL YTD BUDGET REMAINING % ----------------------------------------------- 2,822,483 3,730,000 907,517 24% 63,056 118,497 55,441 47% 85,029 158,142 73,113 46% 13,697 2,000 11, 697- -585% 36,407 ----------- 65,000 28,593 44% 3,020,673 ----------- 4,073,639 --------------------- 1,052,966 26% 53,125 73,305 20,180 28% 2,386 0 2,386- 0% 14,186 16,805 2,619 16% 3,492 4,685 1,193 25% 1,379 2,225 846 38% 2,500 4,000 1,500 38% 24,127 30,775 6,648 22% 403 1,400 997 71% 4,352 5,803 1,451 25% 16,531 22,041 5,510 25% 7,838 ----------- 7,838 0 0% 130,320 ----------- ----------- 168,877 ----------- --------------------- 38,557 --------------------- 23% 137, 264 267,961 130,697 49% 4,618 5,000 382 8% 1,841 7,500 5,659 75% 37,322 62,496 25,174 40% 9,096 16,839 7,743 46% 2,461 6,200 3,739 60% 2,327 8,500 6,173 73% 828 2,300 1,472 64% 5,711 9,500 3,789 40% 114 300 186 62% 30,483 43,000 12,517 29% 0 175 175 100% 9,652 13,000 3,348 26% 15,806 21,700 5,894 27% 2,000 2,000 0 0% 15,919 26,000 10,081 39% 0 7,500 7,500 100% 2,182 6,800 4,618 68% 1,294 2,500 1,206 48% 384 850 467 55% 1,330 9,000 7,670 85% 18,246 15,000 3,246- -22% 65,059 67,000 1,941 3% 5,095 18,000 12,905 72% 1,875 2,500 625 25% 47,678 63,571 15,893 25% 11,023 14,697 3,674 25% 7,838 7,838 0 0% 0 ----------- 25,500 25,500 100% 437,446 ----------- ----------- 733,227 ----------- --------------------- 295,781 --------------------- 40% 0 ----------- 45,000 45,000 100% 0 ----------- ----------- 45,000 ----------- --------------------- 45,000 --------------------- 100% 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 5310-454-490204-610 PRINCIPAL-2004 BONDS(HWY 93 S) 0 66,000 66,000 100% 5310-454-490204-620 INTEREST-2004 BONDS 39,694 39,695 1 0% 5310-454-490204-630 FISCAL AGENT FEES 0 300 300 100% TOTAL REVENUE BONDS ----------- 39,694 ----------- ----------- 105,995 ----------- --------------------- 66,301 --------------------- 63% DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 815,000 815,000 100% TOTAL DEPRECIATION -SANITARY ----------- 0 ----------- ----------- 815,000 ----------- --------------------- 815,000 ----------- ---------- 100% TOTAL SANITARY SEWER 477,139 1,699,222 1,222,083 72% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 241,364 361,807 120,443 33% 5310-455-430640-112 SALARIES -RETIREMENT 1,078 0 1,078- 0% 5310-455-430640-121 OVERTIME 13,858 21,000 7,142 34% 5310-455-430640-153 HEALTH INSURANCE 48,057 65,761 17,704 27% 5310-455-430640-155 RETIREMENT 16,098 22,469 6,371 28% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 419 5,000 4,581 92% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 1,755 2,500 745 30% 5310-455-430640-225 ALUM 0 30,000 30,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 9,717 12,000 2,283 19% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 3,836 6,500 2,664 41% 5310-455-430640-231 GAS & OIL 10,703 11,000 297 3% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 223 300 77 26% 5310-455-430640-336 LICENSES & FEES 8,751 10,000 1,249 12% 5310-455-430640-341 ELECTRICITY 104,974 170,000 65,026 38% 5310-455-430640-342 WATER 3,807 6,500 2,693 41% 5310-455-430640-344 NATURAL GAS 41,881 55,000 13,119 24% 5310-455-430640-345 TELEPHONE & COMMUNICATION 3,529 5,500 1,971 36% 5310-455-430640-353 AUDITING 2,750 2,750 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 82,179 123,000 40,821 33% 5310-455-430640-355 OTHER CONTRACT SERVICES 22,648 38,000 15,352 40% 5310-455-430640-356 CONSULTANTS 1,445 25,000 23,555 94% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 5310-455-430640-360 MISC. MAINT SERVICES 6,546 18,000 11,454 64% 5310-455-430640-366 BUILDING MAINTENANCE 1,603 2,300 697 30% 5310-455-430640-373 DUES & TRAINING 2,090 9,100 7,010 77% 5310-455-430640-388 MEDICAL SERVICES 196 550 354 64% 5310-455-430640-510 PROPERTY & LIABILITY INS. 41,680 42,500 820 2% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 3,000 4,000 1,000 25% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 91,949 122,598 30,650 25% 5310-455-430640-528 DATA PROCESSING TRANSFER 14,029 18,705 4,676 25% 5310-455-430640-940 MACHINERY & EQUIPMENT 2,150 30,000 27,850 930 TOTAL WWTP OPERATIONS ----------- 782,315 ----------- ----------- 1,236,840 --------------------- 454,525 37% WWTP REPLACEMENT ----------- ----------- ---------- 5310-455-430645-362 EQUIPMENT MAINTENANCE 33,380 80,000 46,621 58% 5310-455-430645-940 MACHINERY & EQUIPMENT 28,089 ----------- 173,500 145,411 84% TOTAL WWTP REPLACEMENT 61,469 ----------- ----------- 253,500 ----------- --------------------- 192,031 --------------------- 76% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 83,127 113,243 30,116 27% 5310-455-430646-153 HEALTH INSURANCE 15,029 18,095 3,066 17% 5310-455-430646-155 RETIREMENT 5,188 6,997 1,809 26% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 466 1,850 1,384 75% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 616 3,000 2,384 79% 5310-455-430646-222 LAB SUPPLIES 5,644 9,000 3,356 37% 5310-455-430646-312 POSTAGE & SHIPPING 0 500 500 100% 5310-455-430646-349 LAB SERVICES 7,736 20,000 12,264 61% 5310-455-430646-362 EQUIPMENT MAINTENANCE 944 4,500 3,556 79% Page 22 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING $ ----------- 5310-455-430646-373 ------------------------------------------------------------------------ DUES & TRAINING 277 2,700 2,423 900 TOTAL WWTP LAB OPERATIONS ----------- 119,027 ----------- 179,885 --------------------- 60,858 34% SRF LOAN/WWTP 5310-455-490215-610 DEBT SRF 92003-PRINCIPAL 0 271,000 271,000 100% 5310-455-490215-620 DEBT SRF 92003-INTEREST 13,760 13,760 0 0% TOTAL SRF LOAN/WWTP ----------- 13,760 ----------- 284,760 --------------------- 271,000 95% DEBT SERVICE SRF -new constr. ----------- ----------- --------------------- 5310-455-490227-610 SRF 2007WWTP PRINCIPAL 0 460,000 460,000 100% 5310-455-490227-620 SRF 2007WWTP INTEREST 501,975 501,975 0 0`§ SUBTOTAL SRF 2007 ----------- 501,975 ----------- 961,975 --------------------- 460,000 48% TOTAL WWTP DEBT ----------- 515,735 ----------- ----------- 1,246,735 ----------- --------------------- 731,000 --------------------- 59% CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-831 CITY/EVERGREEN RESERVE TRANSFER 0 1,836,599 1,836,599 100% TOTAL DEPRECIATION ----------- 0 ----------- ----------- 1,836,599 ----------- --------------------- 1,836,599 --------------------- 100% TOTAL WWTP 1,478,545 4,753,559 3,275,014 69% TOTAL BILLING/SANITARY/WWTP 2,086,004 6,621,658 4,535,654 69% Page 23 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Page 24 Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % STORM SEWER REVENUE 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 2,416 0 2,416- 0% 5349-000-343033-000 IMPACT FEES 38,450 105,000 66,550 63% 5349-000-343034-000 PERMIT FEES 1,340 1,200 140- -12% 5349-000-343035-000 STORM SEWER CHARGES 0 300 300 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 822,433 820,000 2,433- 0% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 4,101 7,500 3,399 45% 5349-000-371010-000 INTEREST ON INVESTMENTS 19,807 22,000 2,193 10% ----------- TOTAL STORM REVENUE 888,547 ----------- 956,000 --------------------- 67,453 7% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 205,824 333,163 127,339 38% 5349-453-430246-112 SEVERANCE 4,619 7,000 2,381 34% 5349-453-430246-121 OVERTIME 1,676 5,000 3,324 66% 5349-453-430246-153 HEALTH INSURANCE 48,981 75,239 26,258 35% 5349-453-430246-155 RETIREMENT 13,490 21,041 7,551 360 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 7,526 9,100 1,574 17% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 2,031 3,500 1,469 42% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 2,575 2,200 375- -17% 5349-453-430246-231 GAS & OIL 5,660 10,500 4,840 46% 5349-453-430246-345 TELEPHONE & COMMUNICATION 723 850 127 15% 5349-453-430246-353 AUDITING 550 600 50 8% 5349-453-430246-354 CONTRACT SERVICE 1,600 6,200 4,600 74% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 5,083 20,000 14,917 75% 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 5,169 15,000 9,831 66% 5349-453-430246-360 REPAIR & MAINT SERVICES 1,016 1,500 484 32% 5349-453-430246-362 GROUNDWATER MONITORING 6,095 25,000 18,905 76% 5349-453-430246-371 CURB & GUTTER 510 5,000 4,490 90% 5349-453-430246-373 DUES & TRAINING 1,266 3,500 2,234 64% 5349-453-430246-388 MEDICAL SERVICES 0 250 250 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 1,933 10,000 8,067 81% 5349-453-430246-510 PROPERTY & LIABILITY INS. 12,307 8,500 3,807- -45% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 1,875 2,500 625 25% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 22,782 30,376 7,594 25% 5349-453-430246-528 DATA PROCESSING TRANSFER 4,008 5,344 1,336 25% 5349-453-430246-530 BNSF LEASE PMT 4,902 5,200 298 6% 5349-453-430246-532 OFFICE RENT 7,838 7,838 0 0% 5349-453-430246-952 STORM DRAIN CORRECTION 2,563 100,000 97,437 97% 5349-453-430246-954 S MEADOWS SURVEY 31,532 304,700 273,168 90% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 30,000 30,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 45,000 45,000 100% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 260,000 260,000 100% ----------- TOTAL STORM 404,133 ----------- ----------- 1,369,101 ---------- 964,968 70% 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 811,286 800,000 11,286- -1% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 27,543 8,000 19,543- -244% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 5,470 3,500 1,970- -56% 5510-000-365000-000 FEC- LIGHTING REBATE 2,390 0 2,390- 0% 5510-000-371010-000 INVESTMENT EARNINGS 3,834 ----------- 3,500 334- -10% TOTAL SOLID WASTE REVENUE 850,522 ----------- 815,000 --------------------- 35,522- -4% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 215,046 351,409 136,363 39% 5510-460-430840-112 SEVERANCE -RETIREMENT 0 5,500 5,500 100% 5510-460-430840-121 OVERTIME 1,750 7,500 5,750 77% 5510-460-430840-153 HEALTH INSURANCE 44,417 74,749 30,332 41% 5510-460-430840-155 RETIREMENT 13,619 21,804 8,185 38% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,054 3,500 2,446 70% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 20,642 20,000 642- -3% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 1,078 5,500 4,422 80% 5510-460-430840-231 GAS & OIL 31,100 50,000 18,900 38% 5510-460-430840-341 ELECTRICITY 920 1,700 780 46% 5510-460-430840-344 NATURAL GAS 2,994 4,000 1,006 25% 5510-460-430840-345 TELEPHONE & COMMUNICATION 442 700 258 37% 5510-460-430840-354 CONTRACT SERVICES 5,160 12,000 6,840 57% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 1,217 5,700 4,483 79% 5510-460-430840-366 BUILDING MAINTENANCE 3,099 2,500 599- -24% 5510-460-430840-373 DUES & TRAINING 1,836 2,500 664 27% 5510-460-430840-388 MEDICAL SERVICES 426 500 75 15% 5510-460-430840-510 PROPERTY & LIABILITY INS. 10,036 12,500 2,464 20% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 230 6,500 6,270 96% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 19,500 26,000 6,500 25% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 22,376 29,835 7,459 25% 5510-460-430840-528 DATA PROCESSING TRANSFER 7,015 9,353 2,338 25% 5510-460-430840-532 OFFICE RENT 7,838 7,838 0 0% 5510-460-430840-944 VEHICLES (Replacement $) 230,384 260,000 29,616 11% 5510-460-430845-224 JANITORIAL SUPPLIES 0 350 350 100% 5510-460-430845-341 ELECTRICITY 2,297 3,200 903 28% 5510-460-430845-342 WATER 438 350 88- -25% 5510-460-430845-344 NATURAL GAS 7,517 8,500 983 12% 5510-460-430845-360 REPAIR & MAINT SERVICES 464 2,500 2,036 81% 5510-460-510400-831 DEPRECIATION EXPENSE 0 125,000 125,000 100% TOTAL SOLID WASTE EXPENSE ----------- 652,893 ----------- 1,061,488 --------------------- 408,595 38% Page 25 75.00% Yr Complete 04/12/12 CITY OF KALISPELL Page 26 Quarterly Finance Report MARCH 31, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 7,215 7,200 15- 0% 5160-000-343063-000 TIE DOWN FEES 1,980 3,500 1,520 43% 5160-000-343069-000 HANGER LEASES 11,885 12,000 115 1% 5160-000-343071-000 HANGAR SITE LEASES 16,503 15,600 903- -6% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 12,763 17,000 4,237 25% 5160-000-343102-000 GROUND LEASES 11,385 11,385 0 0% 5160-000-343620-000 FUEL TAX 3,719 5,500 1,781 32% 5160-000-371010-000 INVESTMENT EARNINGS 11,778 16,500 4,722 29% ----------- TOTAL AIRPORT REVENUE 77,228 ----------- 88,685 --------------------- 11,457 13% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 26,035 33,744 7,709 23% 5160-430-430310-111 SEASONAL SALARIES 1,261 3,262 2,002 61% 5160-430-430310-153 HEALTH INSURANCE 2,842 4,586 1,744 38% 5160-430-430310-155 RETIREMENT 1,699 2,406 707 29% 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 353 1,150 797 69% 5160-430-430310-341 ELECTRICITY 1,086 1,500 414 28% 5160-430-430310-345 TELEPHONE 526 1,000 474 47% 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 1,588 5,800 4,212 73% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL, 1,500 6,000 4,500 75% 5160-430-430310-357 CONTRACT SERVICES - legal 3,718 10,000 6,282 63% 5160-430-430310-362 REPAIR & MAINTENANCE 1,444 4,000 2,556 64% 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 0 2,000 2,000 100% 5160-430-430310-373 DUES & TRAINING 701 1,900 1,199 63% 5160-430-430310-390 EQUIPMENT RENTAL 1,490 2,000 510 26% 5160-430-430310-510 PROPERTY INSURANCE 3,816 5,000 1,184 24% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 2,117 2,823 706 25% 5160-430-430310-528 DATA PROCESSING TRANSFER 2,004 2,672 668 25% 5160-430-430310-820 DEPRECIATION 0 100,832 100,832 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 0 63,010 63,010 1000 ----------- TOTAL AIRPORT OPERATIONS ----------- 52,179 ----------- 253,685 ---------- 201,506 79% DATA PROCESSING REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 174,937 174,937 0 0% 6030-000-341020-000 ADMIN CHARGES -GRANTS 5,715 0 5,715- 0% 6030-000-364030-000 SALE OF MISCELLANEOUS 139 200 61 31% 6030-000-371010-000 INVESTMENT EARNINGS 991 1,500 509 34% 6030-000-393000-000 INTERNAL SERVICES -DATA ----------- 111,345 148,461 37,116 25% TOTAL DATA PROCESSING REVENUE ----------- 293,127 ----------- 325,098 ---------- 31,971 10% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 61,453 96,524 35,071 36% 6030-401-410580-153 HEALTH INSURANCE 11,501 21,940 10,440 48% 6030-401-410580-155 RETIREMENT 4,014 6,267 2,253 36% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 1,096 3,777 2,681 71% 6030-403-410580-215 COMPUTER SUPPLIES 1,587 2,850 1,263 44% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 7,299 12,060 4,761 39% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 2,221 12,550 10,329 82% 6030-403-410580-346 SUMMIT NET Tl CONTRACT 1,393 5,196 3,803 73% 6030-403-410580-353 LASER FICHE MAINTENANCE 1,558 1,600 42 3% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 4,425 4,400 25- -1% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 14,330 28,759 14,429 50% 6030-403-410580-357 GRANICUS 5,940 6,000 60 1% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 8,836 16,440 7,604 46% 6030-403-410580-373 DUES & TRAINING 3,527 5,200 1,673 32% 6030-403-410580-510 INSURANCE 1,163 1,350 187 14% 6030-403-410585-229 COPIER,FAX, SUPPLIES 503 5,000 4,497 90% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 47,088 70,000 22,912 33% 6030-403-410585-532 COPIER LEASES 24,395 32,000 7,605 24% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 1,209 3,162 1,953 62% 6030-405-410588-218 COMPUTERS - FIBER AND INSTALLATION 4,334 6,500 2,166 33% 6030-405-410588-940 COMPUTERS - SWITCHES 0 7,500 7,500 100% 6030-405-410588-942 COMPUTERS - CAPITAL OR CONTINGENCY 0 10,000 10,000 100% 75.00% Yr Complete 04/12/12 FUND FUND CITY OF KALISPELL Quarterly Finance Report MARCH 31, 2012 ACTUAL YTD BUDGET REMAINING % -------------------------------------------------- 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 ---------------------------------------------- 2,596 4,510 1,914 42% 3,261 9,355 6,094 65% 204 4,005 3,801 95% 0 2,135 2,135 100% 828 3,052 2,224 73% ----------- 214,759 ---------------------- 387,132 ---------- 172,373 45% Page 27 75.00% Yr Complete 04/13/12 CITY OF KALISPELL Page 1 MARCH 31, 2012 CASH ACCT # CASH ACCT LABEL M/E CASH -------------------------------------------------------------------- 1000-000-010100-000 CASH, GENERAL FUND OPERATIONS 311,651.43 1000-000-010102-000 CASH, PETTY CASH 1,280.00 1000-000-010105-000 CASH, DESIGNATED PARKING SPACE 23,541.98 1000-000-010107-000 CASH, DESIGNATED:CAPITAL EQUIP 101,905.92 1000-000-010109-000 CASH, DESIGNATED BANDSHELL 12,725.94 2185-000-010100-000 CASH, AIRPORT TAX INCREMENT 1,530,284.14 2188-000-010100-000 CASH, WESTSIDE TAX INCREMENT 2,053,565.99 2210-000-010100-000 CASH, PARKS IN LIEU OF 37,372.20 2215-000-010100-000 CASH, PARKS & RECREATION 180,320.89 2215-000-010103-000 CASH, PETTY CASH 2O0.00 2215-000-010107-000 CASH, DESIGNATED CAPITAL 15,404.64 2230-000-010100-000 CASH, AMBULANCE 63,733.53 2310-000-010100-000 CASH, OLD SCHOOL TIF/TECH 5,383.81 2311-000-010100-000 CASH, OLD SCHOOL TIF/INDUSTRIA 4,511.97 2372-000-010100-000 CASH, HEALTH INS. 12,685.82 2394-000-010100-000 CASH, BUILDING DEPT. 281,979.28 2399-000-010100-000 CASH, ADMIN FEES 275.62 2399-000-010172-000 CASH, POLICE IMPACT FEES 37,961.26 2399-000-010173-000 CASH, FIRE IMPACT FEES 194,058.69 2400-000-010100-000 CASH, LIGHT MAINTENANCE 126,284.63 2420-000-010100-000 CASH, GAS TAX STREET DEPT. 409,230.00 2500-000-010100-000 CASH, SPECIAL STREET MAINTENAN 682,912.30 2500-000-010106-000 CASH, DESIGNATED 3 MILE (T.D.& 11,420.00 2500-000-010107-000 CASH, STREET DESIGNATED EQUIPM 15,473.94 2500-000-010108-000 CASH, S & C REPAIR ACCOUNT 36,097.87 2500-000-010109-000 CASH, STREET FOR PAVEMENT REPL 170,752.58 2600-000-010100-000 CASH, URBAN FORESTRY 30,383.57 2601-000-010100-000 CASH, DEVELOPER TREES 94,720.68 2700-000-010100-000 CASH, BUSINESS IMPROVMENT DIST 126,208.81 2880-000-010100-000 CASH, COMMUNITY DEV.LOAN REVOL 344,771.57 2880-000-010162-000 CASH, INVESTMENT S & C 47,986.40 2886-000-010100-000 CASH, UDAG OPERATING 300,347.93 2887-000-010100-000 CASH, RURAL DEV. LOAN REVOLVIN 51,927.89 2887-000-010140-000 CASH, 61-01 LOAN LOSS RESERVE 14,292.26 2888-000-010100-000 CASH, RURAL DEV LOAN REVOLVING 124,643.80 2888-000-010140-000 CASH, LOAN LOSS RESERVE 9,339.90 2916-000-010100-000 CASH, DRUG ENFORCEMENT GRANT 4,237.70- 2918-000-010100-000 CASH, COPS CHRP HIRING GRT 17,201.22- 2918-000-010130-000 CASH, COPS designated for 4th 45,000.00 2919-000-010100-000 CASH, LAW ENF. GRANTS 10,622.36- 2920-000-010100-000 CASH, BUR OF JUSTICE -IT UPGRA 35,374.75- 2921-000-010100-000 CASH, DRUG COURT GRANT 4,883.84- 2930-000-010100-000 CASH, PRESERVE AMERICA GRANT 16,134.52- 2951-000-010100-000 CASH, KAL DUI COURT GRANT 5,356.25- 2953-000-010100-000 CASH, EPA BROWNFIELDS GRANT 7,009.66- 2954-000-010100-000 CASH, BROWNFIELDS AREAWIDE PLA 13,260.78- 2955-000-010100-000 CASH, BROWNFIELDS REVOLVING LO 239.38- 2957-000-010100-000 CASH, FIRE GRANTS 38,897.60 2958-000-010100-000 CASH, FEMA GOLF COURSE GRANT 118,614.98 2975-000-010100-000 CASH, CTEP (ISTEA) 2,179.03 2993-000-010100-000 CASH, ENERGY E & C BLOCK GRANT 11,973.74- 2995-000-010100-000 CASH, SAFER GRANT 15,513.42- 3010-000-010100-000 CASH, G.O.BOND 2002-POOL 126,761.02 3162-000-010100-000 CASH, G.O.BOND FIRE HALL 147,575.18 3170-000-010100-000 CASH, CITY HALL DEBT SERVICE 318.22 3185-000-010100-000 CASH, AIRPORT TIF BONDS 275,937.00 3185-000-010130-000 CASH, AIRPORT TIF BOND RESERVE 184,875.00 3500-000-010100-000 CASH, SID REVOLVING FUND 261,823.76 3604-000-010100-000 CASH, 2004 SIDEWALK & CURB 3,896.92 3605-000-010100-000 CASH, 2005 SIDEWALK & CURB 1,160.21 3607-000-010100-000 CASH, 2007 SIDEWALK & CURB 1,227.78 3608-000-010100-000 CASH, 2008 SIDEWALK & CURB 684.88 3609-000-010100-000 CASH, 2009 SIDEWALK & CURB 826.09 3610-000-010100-000 CASH, 2010 SIDEWALK & CURB 53.59 3643-000-010100-000 CASH, SID 343 41,014.77 3643-000-010130-000 CASH, SID 343 BOND RESERVE 79,075.00 3644-000-010100-000 CASH, SID 344 125,230.69 3644-000-010130-000 CASH, SID 344 BOND RESERVE 226,000.00 04/13/12 CITY OF KALISPELL MARCH 31, 2012 CASH ACCT m CASH ACCT LABEL M/E CASH -------------------------------------------------------------------- 4188-000-010100-000 CASH, WESTSIDE TIF CAP PROJ 488,280.00 4312-000-010100-000 CASH, FAA PLANNING GRT 418.24 5160-000-010100-000 CASH, AIRPORT OPERATIONS 100,098.59 5160-000-010120-000 CASH, DESIGNATED CAPITAL IMPRO 45,000.00 5160-000-010130-000 CASH, AIRPORT LAND SALE FUNDS 69,292.17 5210-000-010100-000 CASH, WATER OPERATIONS 2,823,846.31 5210-000-010102-000 CASH, WATER PETTY CASH 400.00 5210-000-010120-000 CASH, WATER IMPACT FEES 396,614.17 5210-000-010125-000 CASH, WATER METER REPLACEMENT 287,582.25 5210-000-010127-000 CASH, CAPITAL & EMERGENCY($400 370,000.00 5210-000-010130-000 CASH, BOND RESERVE (ALL WTR BO 460,119.00 5210-000-010194-000 CASH, 2004 HWY 93 S 4% S & I 51,548.75 5210-000-010195-000 CASH, 2007B 3.75% WTR TANK S & 19,229.65 5210-000-010196-000 CASH, 2007A 3.75% METERS/HYD S 46,570.35 5210-000-010199-000 CASH, 2001 SRF LOAN 4% S & I 14,395.00 5310-000-010100-000 CASH, SEWER & WWTP OPERATIONS 467,933.19 5310-000-010103-000 CASH, PETTY CASH-WWTP 150.00 5310-000-010123-000 CASH, IMPACT FEES -SANITARY SEW 1,802,568.78 5310-000-010124-000 CASH, IMPACT FEES - WWTP 261,005.45 5310-000-010125-000 CASH, CITY/EVERGREEN-WWTP 920,364.10 5310-000-010130-000 CASH, BOND RESERVE -ALL SWR BON 1,332,469.00 5310-000-010135-000 CASH, OPERATING RESERVE 190,000.00 5310-000-010192-000 CASH, 1992 SRF S & I 4.0% WWT 71,350.00 5310-000-010193-000 CASH, 2004 SRF S & 1 3.75%(93 26,114.04 5310-000-010197-000 CASH, 2007 SRF WWTP S & I 3.75 268,618.72 5349-000-010100-000 CASH, STORM SEWER OPERATING 1,314,479.91 5349-000-010120-000 CASH, STORM IMPACT FEES 610,684.96 5349-000-010122-000 CASH, CAPITAL RESERVE ($140,00 140,000.00 5349-000-010127-000 CASH, EMERGENCY RESERVE ($25,0 25,000.00 5349-000-010190-000 CASH, STORM EQUIPMENT REPLACEM 200,000.00 5349-000-010193-000 CASH, STORM DESIGNATED CAPITAL 365,842.91 5510-000-010100-000 CASH, SOLID WASTE OPERATING 357,056.39 5510-000-010120-000 CASH, SOLID WASTE REPLACEMENT 134,797.73 6030-000-010100-000 CASH, DATA PROCESSING OPERATIO 164,535.75 6030-000-010120-000 CASH, DATA EQUIP REPLACEMENT 28,586.65 7855-000-010100-000 CASH, TBID 877.94 7910-000-010100-000 CASH, PAYROLL CLEARING 276,541.12 7940-000-010100-000 CASH, PERFORMANCE BONDS 18,125.00 GRAND TOTAL CASH 23,155,477.46 Page 2