Loading...
1st Quarter Financial Report10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 1 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 105,133 4,900,000 4,794,867 98% 1000-000-311105-000 PILT-GL MANOR, TRES ST PL, ACCESSIB 0 20,635 20,635 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 162,631 175,000 12,369 7% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 7,821 30,000 22,179 74% 1000-000-312510-000 LOAN REPAYMENT - EMPLOYEES 0 1,200 1,200 100% 1000-000-322101-000 BEER & LIQUOR LICENSES 2,952 25,000 22,048 88% 1000-000-322300-000 BUSINESS LICENSES 78 1,225 1,147 94% 1000-000-322500-000 AMUSEMENT LICENSES 0 350 350 100% 1000-000-323012-000 PLANNING FEES 4,932 20,000 15,068 75% 1000-000-323107-000 EXCAV/DEMO/AIR/HOUSE MOVING PERMITS 0 500 500 100% 1000-000-323109-000 SITE REVIEW 0 9,500 9,500 100% 1000-000-323200-000 PARADE PERMITS 200 750 550 73% 1000-000-323300-000 ANIMAL LICENSES 664 1,000 337 34% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,330 1,330 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 0 56,550 56,550 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 3,200 3,200 100% 1000-000-335230-000 HB124 ENTITLEMENT 561,860 2,361,950 1,800,090 76% 1000-000-341020-000 ADMINISTRATIVE CHARGES 125,494 512,000 386,506 75% 1000-000-341021-000 GRANT ADMIN FEES 6,565 15,000 8,435 56% 1000-000-341025-000 CITY COLLECTIONS 775 1,200 425 35% 1000-000-341026-000 LEAGUE OF CITIES CONFERENCE 5,250 2,500 2,750- -110% 1000-000-341027-000 BRESNAN FRANCHISE FEES 2,893 0 2,893- 0% 1000-000-342010-000 POLICE SERVICES 4,694 21,500 16,806 78% 1000-000-342014-000 RESOURCE OFFICERS 0 86,000 86,000 100% 1000-000-342016-000 KPD REGIONAL TRAINING 0 5,000 5,000 100% 1000-000-343005-000 CENTRAL GARAGE CHARGE 32,825 131,300 98,475 75% 1000-000-343018-000 PARKING PERMITS METERS, BOOT REMOVE 25,236 80,000 54,764 68% 1000-000-351000-000 CITY COURT FINES & FEES 95,423 500,000 404,577 81% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 4,955 25,000 20,045 80% 1000-000-351035-000 PARKING FINES 9,627 52,000 42,373 81% 1000-000-362010-000 CITY GOLF COURSE LEASE 0 25,000 25,000 100% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 1,058 7,500 6,442 86% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 2,100 1,500 600- -40% 1000-000-365015-000 CONTRIBUTION FRM KIDSPORT 0 44,000 44,000 100% 1000-000-365018-000 BANDSHELL CONTRIBUTIONS 346 0 346- 0% 1000-000-371010-000 INVESTMENT EARNINGS 2,441 20,000 17,559 88% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 67,500 660,239 592,739 90% TOTAL GENERAL FUND REVENUE 1,233,452 9,797,929 8,564,477 87% ------------------------------------------------ ------------------------------------------------ 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 2 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 0 1,435 1,435 100% 1000-400-410530-353 AUDITING 0 10,500 10,500 100% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 718 3,500 2,782 80% 1000-400-410560-312 POSTAGE 2,293 14,500 12,207 84% 1000-400-410560-320 PRINTING & ENVELOPES 942 7,000 6,058 87% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 395 3,500 3,105 89% 1000-400-411850-379 LEAGUE OF CITIES CONFERENCE 9,803 15,000 5,197 35% 1000-400-420000-354 CONTRACT 911 CENTER 0 437,311 437,311 100% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 350 350 100% 1000-400-460446-353 KIDSPORTS PERM. EASEMENT 4,117 4,117 1 0% 1000-400-460446-354 KIDSPORT LEASE 0 44,000 44,000 100% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-000 CONTINGENCY 0 30,000 30,000 100% 1000-400-510310-354 ICMA PLAN FEES 500 500 0 0% 1000-400-510330-513 LIABILITY INSURANCE 210,768 225,000 14,232 6% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 1,058 30,000 28,942 96% 1000-400-510330-517 PROPERTY INSURANCE 50,817 45,000 5,817- -13% SUBTOTAL GEN.GOV'T. ------------ 281,411 ------------ 893,313 ------------ 611,902 ------------ 69% 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-210 COMPUTER SOFTWARE/SUPPLIES 1000-401-410210-312 NEWSLETTER/BOOKS 1000-401-410210-338 RECRUITMENT 1000-401-410210-345 TELEPHONE & COMMUNICATION 1000-401-410210-373 DUES & TRAINING 1000-401-410210-379 MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 1000-401-410830-153 HEALTH INSURANCE 1000-401-410830-155 RETIREMENT 1000-401-410830-210 OFFICE SUPPLIES 1000-401-410830-338 RECRUITMENT/RELOCATION 1000-401-410830-354 CONTRACT SERVICES 1000-401-410830-373 DUES & TRAINING SUBTOTAL HUMAN RESOURCES 27,825 122,294 94,469 77% 3,330 19,711 16,381 83% 2,908 12,915 10,007 77% 0 300 300 100% 0 500 500 100% 0 10,000 10,000 100% 80 480 400 83% 1,799 6,000 4,201 70% 0 500 500 100% ------------ 35,942 ------------ 172,700 ------------------------ 136,758 79% 25,386 111,534 86,148 77% 4,342 17,502 13,160 75% 1,657 7,242 5,585 77% 75 400 325 81% 506 3,500 2,994 86% 80 4,000 3,920 98% 552 3,900 3,348 86% ------------ 32,599 ------------ 148,078 ------------------------ 115,479 78% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 3 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 14,343 62,994 48,651 77% 1000-402-410100-153 HEALTH INSURANCE 9,120 36,540 27,420 75% 1000-402-410100-155 RETIREMENT 764 3,266 2,502 77% 1000-402-410100-335 MT LEAGUE OF CITIES 800 1,000 200 20% 1000-402-410100-354 CONTRACT SERVICES 0 100 100 1000-0 1000-402-410100-373 DUES & TRAINING 5,978 5,978 0- 00-0 1000-402-410100-379 MEETINGS 0 500 500 1000-0 SUBTOTAL MAYOR/COUNCIL ------------ 31,005 ------------ 110,378 ------------ ------------ 79,373 72% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 18,811 82,619 63,808 77% 1000-402-410150-121 OVERTIME 91 500 409 82% 1000-402-410150-153 HEALTH INSURANCE 2,557 10,837 8,280 76% 1000-402-410150-155 RETIREMENT 1,231 5,346 4,115 77% 1000-402-410150-210 OFFICE SUPPLIES 81 100 19 190-0 1000-402-410150-345 TELEPHONE & COMMUNICATION 170 450 280 62% 1000-402-410150-352 RECODIFICATION 2,885 3,500 615 180-0 1000-402-410150-354 CONTRACT SERVICES 0 25 25 1000-0 1000-402-410150-373 DUES & TRAINING 100 300 200 67% SUBTOTAL CITY CLERK ------------ 25,926 ------------ 103,677 ------------------------ 77,751 75% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 45,653 190,440 144,787 76% 1000-403-410550-153 HEALTH INSURANCE 9,022 36,992 27,970 76% 1000-403-410550-155 RETIREMENT 2,975 12,377 9,402 76% 1000-403-410550-322 BOOKS 0 300 300 1000-0 1000-403-410550-353 CONTRACT SERVICES 154 1,600 1,446 900-0 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 600 1,500 900 60% 1000-403-410550-355 BANK CHARGES & FEES 801 3,500 2,699 77% 1000-403-410550-373 DUES & TRAINING 150 5,000 4,850 97% SUBTOTAL FINANCE ------------ 59,355 ------------ 251,709 ------------------------ 192,354 76% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 4 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 73,648 320,797 247,149 77% 1000-404-411110-153 HEALTH INSURANCE 13,893 55,691 41,798 75% 1000-404-411110-155 RETIREMENT 4,810 20,849 16,039 77% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 49 3,200 3,151 980-0 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 3,421 7,000 3,579 51% 1000-404-411110-345 TELEPHONE & COMMUNICATION 237 1,200 963 800-0 1000-404-411110-354 CONTRACT SERVICES 231 5,000 4,769 95% 1000-404-411110-373 DUES & TRAINING 2,689 4,500 1,811 40% SUBTOTAL CITY ATTORNEY ------------ 98,976 ------------ 418,237 ------------------------ 319,261 76% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 46,481 205,305 158,824 77% 1000-406-410360-153 HEALTH INSURANCE 12,189 48,840 36,651 75% 1000-406-410360-155 RETIREMENT 3,037 13,316 10,279 77% 1000-406-410360-210 SUPPLIES 1,268 4,500 3,232 72% 1000-406-410360-320 PRINTING/BOOKS 254 500 246 49% 1000-406-410360-345 TELEPHONE & COMMUNICATION 348 1,400 1,052 75% 1000-406-410360-353 SECURITY & TECHNOLOGY 3,754 40,000 36,246 910-0 1000-406-410360-354 CONTRACT SERVICES 832 5,750 4,918 86% 1000-406-410360-373 DUES & TRAINING 2,213 6,300 4,087 65% 1000-406-410360-394 JURY & WITNESS FEES 1,372 5,750 4,378 76% 1000-406-410360-395 DRUG COURT 0 11,500 11,500 1000-0 1000-406-410360-396 DUI COURT INCENTIVES & MISC 0 1,500 1,500 1000-0 SUBTOTAL COURT ------------ 71,748 ------------ 344,661 ------------ ------------ 272,913 79% DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 3,882 17,740 13,858 78% 1000-410-430100-153 HEALTH INSURANCE 1,009 3,845 2,836 74% 1000-410-430100-155 RETIREMENT 250 1,248 998 800-0 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 96 4,025 3,929 980-0 1000-410-430100-345 TELEPHONE & COMMUNICATION 53 200 147 73% 1000-410-430100-354 CONTRACT SERVICES 193 850 657 77% 1000-410-430100-373 DUES & TRAINING 150 1,150 1,000 87% SUBTOTAL ADMINISTRATION ------------ 5,634 ------------ 29,058 ------------------------ 23,424 810-0 CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 36,584 152,379 115,795 76% 1000-410-431330-121 OVERTIME 65 2,000 1,935 97% 1000-410-431330-153 HEALTH INSURANCE 7,613 31,516 23,903 76% 1000-410-431330-155 RETIREMENT 2,257 9,348 7,091 76% 1000-410-431330-210 OFFICE/COMPUTER SUPPLIES 0 1,200 1,200 1000-0 1000-410-431330-229 NON -CAPITAL & SAFETY EQUIPMENT 1,483 10,603 9,120 86% 1000-410-431330-231 GAS & OIL 29,546 156,500 126,954 810-0 1000-410-431330-232 MOTOR VEHICLE PARTS. 13,905 93,000 79,095 85% 1000-410-431330-233 TIRES AND RELATED PARTS 2,578 32,075 29,497 92% 1000-410-431330-238 FILTERS & MISC. PARTS 994 6,700 5,706 85% 1000-410-431330-241 CONSUMABLE TOOLS/BOOKS 0 1,500 1,500 1000-0 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 5 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 1000-410-431330-341 ELECTRICITY 280 1,700 1,420 84% 1000-410-431330-344 NATURAL GAS 128 7,400 7,272 98% 1000-410-431330-354 CONTRACT SERVICES 5,725 35,000 29,275 84% 1000-410-431330-362 BUILDINGS & EQUIPMENT MAINTENANCE 1,717 2,550 833 33% 1000-410-431330-373 DUES & TRAINING 35 1,200 1,165 97% 1000-410-431330-388 MEDICAL SERVICES 50 275 226 82% SUBTOTAL CENTRAL GARAGE ------------ 102,960 ------------ 544,946 ------------ ------------ 441,986 81% SUBTOTAL PUBLIC WORKS ------------ 108,594 ------------ 574,004 ------------------------ 465,410 81% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 14,736 58,429 43,693 75% 1000-412-411230-121 OVERTIME 26 250 225 90% 1000-412-411230-153 HEALTH INSURANCE 3,718 14,130 10,412 74% 1000-412-411230-155 RETIREMENT 928 3,612 2,684 74% 1000-412-411230-220 SECURITY CAMERA -CITY HALL 0 5,000 5,000 100% 1000-412-411230-224 JANITORIAL SUPPLIES 359 5,200 4,841 93% 1000-412-411230-241 TOOLS & SUPPLIES 288 1,450 1,162 80% 1000-412-411230-341 ELECTRICITY 8,428 45,000 36,572 81% 1000-412-411230-344 NATURAL GAS 906 40,000 39,094 98% 1000-412-411230-345 TELEPHONE & COMMUNICATION 0 250 250 100% 1000-412-411230-354 CONTRACT SERVICES 2,497 23,000 20,503 89% 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 0 4,500 4,500 100% 1000-412-411230-362 EQUIPMENT MAINTENANCE 247 5,000 4,753 95% 1000-412-411230-366 BUILDING MAINTENANCE 9,570 17,300 7,730 45% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 61 3,400 3,339 98% 1000-412-411230-610 BOI 2004 DEBT (HVAC SYS) 8,157 16,420 8,263 50% 1000-412-411230-620 BOI 2004 INT. (HVAC SYS) 258 467 209 45% 1000-412-411230-920 Public Safety Bldg - painting 0 16,000 16,000 100% SUBTOTAL CITY HALL ------------ 50,179 ------------ 259,408 ------------------------ 209,229 81% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 56,132 244,400 188,268 77% 1000-420-411020-153 HEALTH INSURANCE 12,970 55,944 42,974 77% 1000-420-411020-155 RETIREMENT 3,667 15,883 12,216 77% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 19 7,500 7,481 100% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 189 2,700 2,511 93% 1000-420-411020-345 TELEPHONE 270 900 630 70% 1000-420-411020-354 CONTRACT SERVICES 544 1,600 1,056 66% 1000-420-411020-373 DUES & TRAINING 480 3,300 2,820 85% SUBTOTAL PLANNING DEPT. ------------ 74,272 ------------ 332,227 ------------------------ 257,955 78% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 6 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 428,650 1,815,535 1,386,885 76% 1000-413-420140-112 SALARIES -SEVERANCE 31,693 32,000 307 1% 1000-413-420140-114 SALARY -comptime buyout 22,647 15,000 7,647- -51% 1000-413-420140-121 OVERTIME (REG & AET OT) 20,197 70,000 49,803 71% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 0 25,000 25,000 100% 1000-413-420140-153 HEALTH INSURANCE 87,004 370,563 283,559 77% 1000-413-420140-155 RETIREMENT 52,767 235,584 182,817 78% 1000-413-420140-210 OFFICE SUPPLIES 320 3,500 3,180 91% 1000-413-420140-215 COMPUTER SUPPLIES 663 5,500 4,837 88% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 2,409 10,500 8,091 77% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 392 4,000 3,608 90% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 490 7,000 6,510 93% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 448 2,000 1,552 78% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 340 4,000 3,660 92% 1000-413-420140-227 AMMO & RELATED SUPPLIES 340 17,000 16,660 98% 1000-413-420140-228 PATROL CAR SUPPLIES 1,099 13,000 11,901 92% 1000-413-420140-229 OTHER SUPPLIES 397 3,500 3,103 89% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 396 1,000 604 60% 1000-413-420140-234 CRISIS NEGOTIATIONS 0 1,500 1,500 100% 1000-413-420140-235 BIKE PATROL 0 1,000 1,000 100% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 295 1,000 705 70% 1000-413-420140-320 PRINTING 1,209 5,000 3,791 76% 1000-413-420140-345 TELEPHONE & COMMUNICATION 2,152 15,500 13,348 86% 1000-413-420140-354 CONTRACT SERVICES 64 6,000 5,936 99% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 3,214 8,000 4,786 60% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 0 4,000 4,000 100% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 490 2,000 1,510 75% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 2,852 20,000 17,148 86% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 252 2,500 2,248 90% 1000-413-420140-373 DUES & TRAINING 3,847 27,250 23,403 86% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 0 5,000 5,000 100% 1000-413-420140-380 TRAINING MATERIALS 0 2,000 2,000 100% 1000-413-420140-388 MEDICAL SERVICES 0 3,500 3,500 100% 1000-413-420140-392 BOARDING/TREATING PRISONERS 512 1,500 989 66% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 0 55,000 55,000 100% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 0 20,000 20,000 100% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 0 5,000 5,000 100% 1000-413-420140-944 VEHICLES 0 87,000 87,000 100% 1000-413-420141-110 SALARIES -DETECTIVES 81,589 344,535 262,946 76% 1000-413-420141-121 DETECTIVE -OVERTIME 3,856 15,000 11,144 74% 1000-413-420141-153 HEALTH INSURANCE 13,889 55,808 41,919 75% 1000-413-420141-155 DETECTIVE -RETIREMENT 10,725 46,495 35,770 77% 1000-413-420142-110 SALARIES -RECORDS DIVISION 26,902 104,142 77,240 74% 1000-413-420142-121 OVERTIME 0 7,500 7,500 100% 1000-413-420142-153 HEALTH INSURANCE 3,648 14,600 10,952 75% 1000-413-420142-155 RETIREMENT 1,434 5,650 4,216 75% 1000-413-420144-110 SALARIES -SRO 28,003 124,909 96,906 78% 1000-413-420144-153 HEALTH INSURANCE 5,108 22,855 17,747 78% 1000-413-420144-155 SRO RETIREMENT 3,047 16,375 13,328 81% 1000-413-420145-110 ANIMAL CONTROL -SALARIES 11,062 43,680 32,618 75% 1000-413-420145-121 OVERTIME 43 0 43- 0% 1000-413-420145-153 HEALTH INSURANCE 2,589 10,360 7,771 75% 1000-413-420145-155 RETIREMENT 692 2,821 2,129 75% 1000-413-420147-110 PARKINGS -SALARIES 17,186 70,372 53,186 76% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 7 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 1000-413-420147-153 HEALTH INSURANCE 6,783 25,915 19,132 74% 1000-413-420147-155 RETIREMENT 1,101 4,546 3,445 76% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 323 4,000 3,677 92% 1000-413-420147-312 POSTAGE 300 1,000 700 70% 1000-413-420147-354 CONTRACTED SERVICES 35 1,000 965 97% 1000-413-420147-362 LOT MAINT 3,582 6,500 2,918 45% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 6,000 6,000 100% 1000-413-420147-550 LOT LEASE PAYMENTS 358 1,350 992 73% SUBTOTAL POLICE DEPT. 887,392 3,842,845 2,955,453 77% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 8 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 331,593 1,538,837 1,207,244 78% 1000-416-420400-114 COMPTIME BUYOUT 0 5,000 5,000 100% 1000-416-420400-115 OUT OF RANK PAY 2,718 11,978 9,260 77% 1000-416-420400-121 OVERTIME 13,924 38,150 24,226 64% 1000-416-420400-153 HEALTH INSURANCE 65,275 301,638 236,363 78% 1000-416-420400-155 RETIREMENT 44,800 207,444 162,644 78% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 1,116 2,700 1,584 59% 1000-416-420400-218 Equipment (Non Capital) 1,145 7,500 6,355 85% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 5,024 15,000 9,976 67% 1000-416-420400-224 JANITORIAL SUPPLIES 966 2,500 1,534 61% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 2,617 15,000 12,383 83% 1000-416-420400-320 PRINTING 42 700 658 94% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 1,298 1,250 48- -4% 1000-416-420400-345 TELEPHONE & COMMUNICATION 831 8,500 7,669 90% 1000-416-420400-354 CONTRACT SERVICES 50 8,000 7,950 99% 1000-416-420400-362 EQUIPMENT MAINTENANCE 510 5,500 4,990 91% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 1,739 2,500 761 30% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,140 6,500 5,360 82% 1000-416-420400-373 DUES & TRAINING 661 10,000 9,339 93% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 28,871 56,500 27,629 49% 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 4,434 10,118 5,684 56% 1000-416-420440-110 SALARIES -FIRE PREVENTION 9,347 38,890 29,543 76% 1000-416-420440-121 OVERTIME 90 0 90- 0% 1000-416-420440-153 HEALTH INSURANCE 1,889 7,552 5,663 75% 1000-416-420440-155 RETIREMENT 590 2,538 1,948 77% SUBTOTAL FIRE DEPT. 520,673 2,304,295 1,783,622 77% GRAND TOTAL GENERAL FUND 2,278,073 9,755,532 7,477,459 77% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 9 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 2185-000-430300-356 REDEVELOPMENT / CONTRACT SERVICES 2185-000-430300-522 ADMINISTRATIVE TRANSFER 2185-000-430300-820 Transfer -FAA GRANT MATCH 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-710 Loan Revolving Funds 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-937 WESTVIEW IMPROVEMENTS TOTAL PARKS IN LIEU 0 1,200 1,200 1000-0 0 10,000 10,000 1000-0 2,334 9,335 7,001 75% 0 5,000 5,000 1000-0 0 100,000 100,000 1000-0 0 19,073 19,073 1000-0 0 2,530 2,530 1000-0 0 1,240 1,240 1000-0 ------------ 2,334 ------------ ------------ ------------ 148,378 ------------ ------------ ------------------------ 146,044 ------------------------ ------------------------ 980-0 4,343 37,691 33,348 880-0 602 6,079 5,477 900-0 285 2,451 2,166 880-0 0 1,250 1,250 1000-0 5,000 5,000 0 00-0 40 2,000 1,960 980-0 444 1,776 1,332 75% 0 500,000 500,000 1000-0 0 100,000 100,000 1000-0 32,000 ------------ 32,000 ------------ 0 ------------------------ 00-0 42,713 ------------ ------------ 688,247 ------------ ------------ 645,534 ------------------------ ------------------------ 94% 0 17,600 17,600 1000-0 2,239 ------------ 10,000 ------------ 7,761 ------------------------ 78% 2,239 ------------ ------------ 27,600 ------------ ------------ 25,361 ------------------------ ------------------------ 92% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 10 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 19,077 840,000 820,923 98% 2215-000-311200-000 PERSONAL PROPERTY TAXES 29,502 30,000 498 2% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,399 3,500 2,101 60% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 0 5,000 5,000 100% 2215-000-346030-000 SWIMMING POOL FEES 102,853 140,000 37,147 27% 2215-000-346040-000 CONCESSION STAND REVENUE 27,868 32,500 4,632 14% 2215-000-346050-000 Parks Usage Fees 5,954 17,000 11,046 65% 2215-000-346051-000 RECREATION FEES 1,813 10,000 8,187 82% 2215-000-346052-000 SPORTS PROGRAMS 12,297 40,000 27,703 69% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 298 2,000 1,702 85% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 7,740 45,000 37,260 83% 2215-000-346055-000 ICE RINK 0 21,000 21,000 100% 2215-000-346057-000 YOUTH CAMPS 36,399 87,000 50,601 58% 2215-000-346059-000 PICNIC IN THE PARK 9,257 26,000 16,743 64% 2215-000-365010-000 ROUND UP FOR SAFETY GRANT 150 1,800 1,650 92% 2215-000-371010-000 INVESTMENTS/DONATIONS/MISC.SALES 651 0 651- 0% 2215-000-381050-000 INCEPTION OF LEASE 0 45,000 45,000 100% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 7,500 68,000 60,500 89% TOTAL PARKS & REC REVENUE ------------ 262,758 ------------ ------------ ------------ 1,413,800 ------------ ------------ ------------ ------------ 1,151,042 ------------------------ ------------------------ 81% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 63,688 274,988 211,300 77% 2215-436-460430-111 SEASONAL SALARIES 25,072 48,756 23,684 49% 2215-436-460430-121 OVERTIME 278 1,000 722 72% 2215-436-460430-153 HEALTH INSURANCE 15,840 68,808 52,968 77% 2215-436-460430-155 RETIREMENT 4,923 20,409 15,486 76% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 554 2,100 1,546 74% 2215-436-460430-224 JANITORIAL SUPPLIES 1,280 3,500 2,220 63% 2215-436-460430-229 OTHER SUPPLIES 949 4,500 3,551 79% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 42 2,500 2,458 98% 2215-436-460430-320 PRINTING & ADVERTISING 0 500 500 100% 2215-436-460430-341 ELECTRICITY 2,407 14,250 11,843 83% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 380 21,000 20,620 98% 2215-436-460430-344 NATURAL GAS 109 3,200 3,091 97% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 533 2,500 1,967 79% 2215-436-460430-351 Tennis Court Rehabilitaion 0 2,500 2,500 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,500 2,500 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 90 5,000 4,910 98% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 2,712 8,500 5,788 68% 2215-436-460430-364 LANDSCAPING 61 5,000 4,939 99% 2215-436-460430-367 VANDALISM REPAIRS 857 4,000 3,143 79% 2215-436-460430-373 DUES & TRAINING 890 2,700 1,810 67% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 700 700 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 3,500 3,500 100% 2215-436-460430-440 IRRIGATION SUPPLIES 2,524 9,000 6,476 72% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 280 4,000 3,720 93% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 691 1,388 697 50% 2215-436-460430-620 DEBT SERVICE INTEREST 35 1,455 1,420 98% 2215-436-460430-920 EQUIPMENT 0 10,000 10,000 100% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 11 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 2215-436-460430-940 Capital Equipment SUBTOTAL PARKS EXPENDITURES 16,000 ------------ 140,198 45,000 ------------ 574,754 29,000 64% ------------------------ 434,556 76% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 2215-436-460440-111 SEASONAL SALARIES 2215-436-460440-153 HEALTH INSURANCE 2215-436-460440-155 RETIREMENT 2215-436-460440-221 SAFETY EQUIPMENT 2215-436-460440-229 OTHER SUPPLIES 2215-436-460440-341 ELECTRICITY 2215-436-460440-345 TELEPHONE & COMMUNICATION 2215-436-460440-354 CONTRACT SERVICES 2215-436-460440-362 EQUIPMENT MAINTENANCE 2215-436-460440-364 LANDSCAPING 2215-436-460440-367 VANDALISM REPAIRS 2215-436-460440-373 DUES & TRAINING 2215-436-460440-395 RENTAL EQUIPMENT 2215-436-460440-420 METAL PRODUCTS 2215-436-460440-440 IRRIGATION 2215-436-460440-452 SAND & GRAVEL 2215-436-460440-610 DEBT SERVICE -PRINCIPAL 2215-436-460440-620 DEBT SERVICE -INTEREST 2215-436-460440-940 EQUIPMENT SUBTOTAL ATHLETIC COMPLEX 11,307 50,160 38,853 77% 18,813 43,256 24,443 57% 3,031 17,484 14,453 83% 1,466 4,406 2,941 67% 0 875 875 100% 4,105 16,000 11,895 74% 3,103 7,000 3,897 56% 0 300 300 100% 378 2,000 1,623 81% 458 700 242 35% 90 500 410 82% 0 500 500 100% 0 135 135 100% 0 150 150 100% 0 2,900 2,900 100% 1,535 3,000 1,465 49% 303 1,100 797 72% 6,952 13,975 7,023 50% 357 675 318 47% 0 14,500 14,500 100% ------------ 51,898 ------------ 179,616 ------------------------ 127,718 71% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 20,054 88,080 68,026 77% 2215-436-460431-111 SEASONAL SALARIES 2,482 13,633 11,151 82% 2215-436-460431-153 HEALTH INSURANCE 5,625 22,538 16,913 75% 2215-436-460431-155 RETIREMENT 1,315 6,528 5,213 80% 2215-436-460431-218 DONATED SUPPLIES (donation FY11) 0 1,400 1,400 100% 2215-436-460431-229 MISC. SUPPLIES 1,606 10,000 8,394 84% 2215-436-460431-320 PRINTING & ADVERTISING 0 6,300 6,300 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 60 240 180 75% 2215-436-460431-354 CONTRACT SERVICES 14,842 18,000 3,158 18% 2215-436-460431-355 On Line Registration 0 3,000 3,000 100% 2215-436-460431-373 DUES & TRAINING 205 700 495 71% SUBTOTAL RECREATION ------------ 46,189 ------------ 170,419 ------------------------ 124,230 73% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 15,147 65,971 50,824 77% 2215-436-460448-111 SEASONAL SALARIES 53,890 98,340 44,450 45% 2215-436-460448-121 OVERTIME 0 250 250 100% 2215-436-460448-153 HEALTH INSURANCE 5,335 21,378 16,043 75% 2215-436-460448-155 RETIREMENT 955 5,640 4,685 83% 2215-436-460448-229 MISC. SUPPLIES 1,988 3,850 1,862 48% 2215-436-460448-320 PRINTING & ADVERTISING 58 350 292 83% 2215-436-460448-345 TELEPHONE & COMMUNICATION 0 200 200 100% 2215-436-460448-354 CONTRACT SERVICES 9,016 11,800 2,784 24% 2215-436-460448-355 AFTER SCHOOL PROGRAM 53 3,850 3,797 99% 2215-436-460448-356 BANK FEES/CC CHARGES 934 2,500 1,566 63% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 12 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 2215-436-460448-373 DUES & TRAINING 0 400 400 1000-0 SUBTOTAL YOUTH CAMPS ------ - - - - -- 87,377 ------ - - - - -- 214,529 ------ - - - - ---- 127,152 ---- - - - - - - 59% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 134,453 198,139 63,686 32% 2215-437-460445-121 OVERTIME 1,534 1,200 334- -28% 2215-437-460445-155 RETIREMENT 842 1,000 158 16% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 0 900 900 1000-0 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,844 3,200 1,356 42% 2215-437-460445-226 CHLORINE/CHEMICALS 17,175 23,500 6,325 27% 2215-437-460445-228 CONCESSION STAND SUPPLIES 11,279 19,000 7,721 41% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 878 4,400 3,522 800-0 2215-437-460445-341 ELECTRICITY 3,634 12,500 8,866 71% 2215-437-460445-344 NATURAL GAS 12,694 26,000 13,306 51% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,669 1,500 169- -110-0 2215-437-460445-354 LICENSES & FEES 530 3,300 2,770 84% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 930 8,200 7,270 890-0 2215-437-460445-380 TRAINING MATERIALS 0 500 500 1000-0 SUBTOTAL POOL EXPENDITURES ------------ 187,461 ------------ ------------ 303,339 ------------ ------------ ------------ 115,878 ------------------------ 38% TOTAL PARKS & RECREATION/POOL 513,123 ------------ ------------ 1,442,657 ------------ ------------ 929,534 ------------------------ ------------------------ 64% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 13 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 131,126 605,000 473,874 78% 2230-000-342070-000 COUNTY EMS LEVY 0 85,000 85,000 100% 2230-000-371010-000 INTEREST EARNINGS 57 1,000 943 94% TOTAL AMBULANCE REVENUE ------------ 131,184 ------------ ------------ ------------ 691,000 ------------ ------------ ------------ 559,816 ------------ ------------ ------------ 81% ------------ ------------ AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 86,252 371,169 284,917 77% 2230-440-420730-114 COMPTIME BUYBACK 0 3,000 3,000 100% 2230-440-420730-121 OVERTIME 2,188 19,147 16,959 89% 2230-440-420730-153 HEALTH INSURANCE 19,755 82,025 62,270 76% 2230-440-420730-155 RETIREMENT 11,281 48,915 37,634 77% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 328 1,000 672 67% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 113 2,500 2,387 95% 2230-440-420730-231 GAS & OIL 1,623 7,000 5,377 77% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 6 6,000 5,994 100% 2230-440-420730-312 POSTAGE/PRINTING 150 3,500 3,350 96% 2230-440-420730-345 TELEPHONE & COMMUNICATION 458 700 242 35% 2230-440-420730-354 PARAMEDIC RECERTIFICATION 20 7,000 6,980 100% 2230-440-420730-355 911 CENTER CONTRIBUTION 0 30,600 30,600 100% 2230-440-420730-359 AUDIT/CC OTHER FEES 243 1,400 1,157 83% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 126 7,000 6,874 98% 2230-440-420730-373 DUES & TRAINING 850 5,000 4,150 83% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 5,529 22,500 16,971 75% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 8,658 35,000 26,342 75% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 8,051 9,900 1,849 19% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 2,375 9,500 7,125 75% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 6,691 26,762 20,071 75% 2230-440-420730-528 DATA PROCESSING TRANSFER 2,665 11,287 8,622 76% TOTAL AMBULANCE EXPENDITURES ------------ 157,361 ------------ ------------ ------------ 710,905 ------------ ------------ ------------------------ 553,544 ------------------------ ------------------------ 78% 2310 OLD SCHOOL TIF - TECH 2310-480-470210-354 CONTRACT SERVICES - BOND COUNSEL 0 1,000 1,000 100% 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 12,340 12,340 100% 2310-480-470210-356 FED -EX REIMBURSEMENT 0 10,588 10,588 100% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 0 30,000 30,000 100% TOTAL 2310 OLD SCHOOL TECH TIF ------------ 0 ------------ ------------ ------------ 53,928 ------------ ------------ ------------------------ 53,928 ------------------------ ------------------------ 100% 2311 OLD SCHOOL TIF INDUSTRIAL 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 0 12,661 12,661 100% TOTAL 2311 OLD SCHOOL INDUSTR. ------------ 0 ------------ ------------ ------------ 12,661 ------------ ------------ ------------------------ 12,661 ------------------------ ------------------------ 100% 2372 HEALTH PERMISIVE LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND 75,000 728,239 653,239 90% TOTAL 2372 HEALTH LEVY ------------ 75,000 ------------ 728,239 ------------------------ 653,239 90% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 14 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING ------------------------------------------------ ------------------------------------------------ 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 30,201 200,000 169,799 85% 2394-000-323103-000 PLUMBING PERMITS 1,815 15,000 13,185 88% 2394-000-323104-000 MECHANICAL PERMITS 3,180 22,000 18,820 86% 2394-000-323107-000 HOUSE MOVING PERMITS 0 200 200 1000-0 2394-000-323108-000 PLAN REVIEW FEES 7,126 60,000 52,874 880-0 2394-000-371010-000 INVESTMENT EARNINGS 636 1,000 364 36% TOTAL REVENUE ------------ 42,958 ------------ ------------ ------------ 298,200 ------------ ------------ ------------------------ 255,242 ------------------------ ------------------------ 86% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 49,494 219,652 170,158 77% 2394-420-420530-121 OVERTIME 135 3,500 3,365 96% 2394-420-420530-153 HEALTH INSURANCE 11,042 49,155 38,113 78% 2394-420-420530-155 RETIREMENT 3,127 13,561 10,434 77% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 73 4,750 4,677 980-0 2394-420-420530-231 GAS & OIL 444 2,250 1,806 800-0 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 0 2,600 2,600 1000-0 2394-420-420530-323 ST. ED. ASSESSMENTS 0 2,500 2,500 1000-0 2394-420-420530-345 TELEPHONE & COMMUNICATION 426 1,500 1,074 72% 2394-420-420530-353 AUDITING 0 500 500 1000-0 2394-420-420530-354 CONTRACT SERVICES 544 1,300 756 58% 2394-420-420530-373 DUES & TRAINING 300 3,400 3,100 910-0 2394-420-420530-510 PROPERTY INSURANCE 4,087 4,100 13 00-0 2394-420-420530-521 CENTRAL GARAGE TRANSFER 325 1,300 975 75% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 2,298 9,194 6,896 75% 2394-420-420530-528 DATA PROCESSING TRANSFER 1,167 4,414 3,247 74% 2394-420-420530-930 Web based software package 0 20,000 20,000 1000-0 TOTAL BUILDING DEPT. ------------ 73,462 ------------ ------------ ------------ 343,676 ------------ ------------ ------------ ------------ 270,214 ------------------------ ------------------------ 79% 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 0 3,000 3,000 1000-0 2399-413-420140-354 IMPACT FEE REVIEW 0 500 500 1000 2399-413-420140-940 POLICE EQUIPMENT 0 40,000 40,000 1000 2399-416-420400-354 IMPACT FEE REVIEW 0 500 500 1000 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 14,000 28,250 14,250 50% 2399-416-420400-620 INTEREST - FIRE TRUCK 3,750 7,080 3,330 47% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 200,000 200,000 1000 TOTAL 2399 IMPACT FEE FUND ------------ 17,750 ------------ ------------ ------------ 279,330 ------------ ------------ ------------------------ 261,580 ------------------------ ------------------------ 94% 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 9,000 38,893 29,893 77% 2400-410-430263-153 HEALTH INSURANCE 1,884 9,696 7,812 810 2400-410-430263-155 RETIREMENT 567 2,391 1,824 76% 2400-410-430263-244 STREET LIGHT SUPPLIES 1,302 16,000 14,698 92% 2400-410-430263-341 ELECTRICITY 24,431 163,000 138,569 85% 2400-410-430263-360 REPAIR & MAINT SERVICES 3,110 20,000 16,890 84% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 15 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 2400-410-430263-510 INSURANCE 883 1,075 192 18% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 2,191 8,763 6,572 75% 2400-410-430263-940 BOOM TRUCK 0 115,000 115,000 100% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 0 12,000 12,000 100% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 0 718 718 100% TOTAL LIGHT MAINT. ------------ 43,368 ------------ ------------ ------------ 387,536 ------------ ------------ ------------ ------------ 344,168 ------------------------ ------------------------ 89% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 17,245 36,500 19,255 53% 2420-421-430234-957 ALLEY PAVING 40,720 45,000 4,280 10% 2420-421-430240-231 GAS & OIL 4,499 38,000 33,501 88% 2420-421-430240-344 NATURAL GAS 0 3,500 3,500 100% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 22,761 300,400 277,640 92% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 7,500 7,500 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 101,455 211,255 109,800 52% 2420-421-430240-369 RADIO EQUIPMENT & MAINT. 0 700 700 100% 2420-421-430240-452 GRAVEL 1,744 3,000 1,256 42% 2420-421-430240-453 MATERIALS; CONTRACT PREP. 0 3,000 3,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 3,440 47,000 43,560 93% 2420-421-430240-472 ASPHALT 12,768 30,000 17,232 57% 2420-421-430240-473 CRACK SEALING 0 7,000 7,000 100% TOTAL GAS TAX ------------ 204,632 ------------ ------------ ------------ 732,855 ------------ ------------ ------------------------ 528,223 ------------------------ ------------------------ 72% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 16 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 128,451 570,667 442,216 77% 2500-421-430240-112 RETIREMENT -severance 0 25,000 25,000 100% 2500-421-430240-121 OVERTIME 311 30,000 29,689 99% 2500-421-430240-153 HEALTH INSURANCE 33,933 157,384 123,451 78% 2500-421-430240-155 RETIREMENT 8,011 35,393 27,382 77% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 580 5,000 4,420 88% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 354 10,200 9,846 97% 2500-421-430240-220 OTHER SUPPLIES 174 4,100 3,926 96% 2500-421-430240-231 GAS & OIL 4,560 42,000 37,440 89% 2500-421-430240-341 ELECTRICITY 129 1,400 1,271 91% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 280 1,000 720 72% 2500-421-430240-354 CONTRACT SERVICES 618 15,000 14,382 96% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 928 28,000 27,072 97% 2500-421-430240-366 BUILDING MAINTENANCE 970 4,000 3,030 76% 2500-421-430240-373 DUES & TRAINING 987 3,500 2,513 72% 2500-421-430240-388 MEDICAL SERVICES 0 1,100 1,100 100% 2500-421-430240-510 LIABILITY INSURANCE 81,010 87,000 5,990 7% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 17,500 70,000 52,500 75% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 16,855 67,420 50,565 75% 2500-421-430240-528 DATA PROCESSING TRANSFER 3,046 12,182 9,136 75% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 4,513 46,119 41,606 90% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 400 0 400- 0% 2500-421-430240-840 MAGI GRANT MATCH 0 75,000 75,000 100% 2500-421-430240-940 MACHINERY & EQUIPMENT 0 195,000 195,000 100% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 149,827 530,000 380,173 72% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 9,189 31,041 21,852 70% 2500-421-430264-110 TSS - SALARIES 30,189 132,645 102,456 77% 2500-421-430264-121 OVERTIME 2,661 9,500 6,839 72% 2500-421-430264-153 HEALTH INSURANCE 4,560 18,270 13,710 75% 2500-421-430264-155 RETIREMENT 2,018 8,902 6,884 77% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 134 1,500 1,366 91% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,017 4,500 3,483 77% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 334 3,500 3,166 90% 2500-421-430264-242 STREET SIGNS 12,085 44,000 31,915 73% 2500-421-430264-243 TRAFFIC SIGNALS 610 33,500 32,890 98% 2500-421-430264-245 BARRICADE MATERIALS 0 4,700 4,700 100% 2500-421-430264-341 ELECTRICITY 331 8,500 8,169 96% 2500-421-430264-345 COMMUNICATIONS 121 750 629 84% 2500-421-430264-354 CONTRACT SERVICES 240 15,000 14,760 98% 2500-421-430264-362 EQUIPMENT MAINTENANCE 0 3,000 3,000 100% 2500-421-430264-366 BUILDING MAINTENANCE 0 2,000 2,000 100% 2500-421-430264-373 DUES & TRAINING 988 4,000 3,012 75% 2500-421-430264-428 PAINT MATERIALS 26 9,000 8,974 100% 2500-421-430264-510 LIABILITY INS.-TSS 3,766 4,200 434 10% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,500 2,500 100% 2500-421-430264-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SPEC. ST. MAINT. 525,625 2,375,311 1,849,686 78% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 17 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 25,185 147,097 121,912 83% 2600-436-460433-121 OVERTIME 107 500 393 79% 2600-436-460433-153 HEALTH INSURANCE 6,621 42,252 35,631 84% 2600-436-460433-155 RETIREMENT 1,606 9,204 7,598 83% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 14 550 536 98% 2600-436-460433-241 CONSUMABLE TOOLS 0 1,450 1,450 100% 2600-436-460433-354 CONTRACT SERVICES 325 500 175 35% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 650 4,500 3,850 86% 2600-436-460433-362 EQUIPMENT MAINTENANCE 60 500 440 88% 2600-436-460433-364 LANDSCAPING & TREES 0 7,500 7,500 100% 2600-436-460433-373 DUES & TRAINING 0 800 800 100% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 3,766 3,500 266- -8% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 750 3,000 2,250 75% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 2,174 8,610 6,436 75% 2600-436-460433-528 DATA PROCESSING TRANSFER 373 1,411 1,038 74% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 2,072 4,450 2,378 53% 2600-436-460433-620 INTEREST EXPENSE 106 200 94 47% 2600-436-460433-940 MACHINERY & EQUIPMENT 0 20,000 20,000 100% TOTAL URBAN FORESTRY 43,809 256,024 212,215 83% ----------------------------------------------- ----------------------------------------------- 2601 DEVELOPER TREES 2601-436-460435-351 EMPIRE ESTATES ($44,911) 2601-436-460435-352 APPLEWAY ($4,564) 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 2601-436-460435-354 CONTRACT SERVICES 2601-436-460435-356 SINOPAH SUBD ($5,790) 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 2601-436-460435-358 WEST VIEW SUBD ($22,680) 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 2601-436-460435-360 RIVER GLEN SUBD ($3,240) 2601-436-460435-361 VILLAGE GREENS ($3,540) 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 2601-436-460435-364 MTN VISTA ESTATES III $17,278.25 2601-436-460435-365 VILLAGE GREENS $3,540 2601-436-460435-366 W VIEW ESTATES $20,060 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) TOTAL 2601 DEVELOPER TREES 2825 MAGI GRANT -SWEEPER 2825-421-430240-940 STREET SWEEPER TOTAL 2825 MAGI GRANT 295 8,948 8,653 97% 0 4,336 4,336 100% 0 1,546 1,546 100% 0 185 185 100% 0 667 667 100% 0 2,883 2,883 100% 295 17,831 17,536 98% 295 31,209 30,914 99% 0 278 278 100% 0 2,514 2,514 100% 0 1,538 1,538 100% 0 1,390 1,390 100% 0 3,679 3,679 100% 0 2,797 2,797 100% 0 10,850 10,850 100% 0 4,254 4,254 100% ------------ 885 ------------ ------------ ------------ 94,905 ------------ ------------ ------------------------ 94,020 ------------------------ ------------------------ 99% 0 574,373 574,373 100% ------------ 0 ------------ ------------ ------------ 574,373 ------------ ------------ ------------------------ 574,373 ------------------------ ------------------------ 100% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 18 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470240-711 IRP LOAN PROGRAM MATCH 0 350,000 350,000 100% ------------------------------------------------ TOTAL LOAN REVOLVING 0 350,000 350,000 100% ------------------------------------------------ ------------------------------------------------ 2886 CD OPERATIONS FUND 2886-480-470210-110 SALARIES - UDAG 8,836 57,933 49,097 85% 2886-480-470210-153 HEALTH INSURANCE 1,222 7,634 6,412 84% 2886-480-470210-155 RETIREMENT 579 3,734 3,155 85% 2886-480-470210-210 OFFICE SUPPLIES 2 1,500 1,498 100% 2886-480-470210-211 GRANT ADMIN. & PROJ. EXPENSES 0 2,000 2,000 100% 2886-480-470210-312 POSTAGE & PRINTING 22 2,000 1,978 99% 2886-480-470210-334 MT WEST MEMBERSHIP 500 500 0 0% 2886-480-470210-345 TELEPHONE & COMMUNICATION 91 400 309 77% 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-373 DUES & TRAINING 770 3,800 3,030 80% 2886-480-470210-379 MEETINGS 100 500 400 80% 2886-480-470210-395 CDBG- GROWTH POLICY UPDATE 1,084 2,845 1,761 62% 2886-480-470210-396 GRANT SERVICES 0 25,000 25,000 100% 2886-480-470210-510 PROPERTY & LIABILITY INS. 2,354 3,000 646 22% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 990 3,961 2,971 75% 2886-480-470210-528 DATA PROCESSING TRANSFER 761 3,046 2,285 75% 2886-480-470210-532 OFFICE RENT 1,175 2,350 1,175 50% 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 50,000 50,000 100% TOTAL CD OPERATIONS FUND ------------ 18,485 ------------ ------------ ------------ 175,703 ------------ ------------ ------------------------ 157,218 ------------------------ ------------------------ 89% 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 0 18,000 18,000 100% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 4,600 4,600 100% 2887-480-470210-750 REDEVELOPMENT LOANS 34,667 75,000 40,333 54% TOTAL RURAL DEVELOPMENT #1 ------------ 34,667 ------------ ------------ ------------ 97,600 ------------ ------------ ------------------------ 62,933 ------------------------ ------------------------ 64% 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 2888-480-470210-750 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #2 2945 CDBG-ED FVCC #2 2945-480-470242-790 MACHINERY/EQUIPMENT 2945-480-470242-820 ADMIN TRANSFER -to Com. Development TOTAL 2945 CDBG-ED FVCC #2 0 10,250 10,250 100% 0 100,000 100,000 100% ------------------------------------------------ 0 110,250 110,250 100% ------------------------------------------------ ------------------------------------------------ 0 60,727 60,727 100% 0 5,392 5,392 100% ------------------------------------------------ 0 66,119 66,119 100% ------------------------------------------------ ------------------------------------------------ 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 19 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2953 EPA BROWNSFIELD GRANT 2953-480-470210-352 SALARIES -PETROLEUM 146 30,000 29,854 100% 2953-480-470210-353 BENEFITS -PETROLEUM 65 10,000 9,935 99% 2953-480-470210-354 CONTRACTED SERV-PETROLEUM 661 82,620 81,959 99% 2953-480-470215-352 SALARIES -HAZARDOUS SUBST 107 25,000 24,893 100% 2953-480-470215-353 BENEFITS -HAZARDOUS SUBST 48 15,000 14,952 100% 2953-480-470215-354 CONTRACTED SERV-HAZARDOUS SUBST 0 7,899 7,899 100% TOTAL EPA BROWNSFIELD GRANT ------------ 1,028 ------------ ------------ ------------ 170,519 ------------ ------------ ------------ 169,491 ------------ ------------ ------------ 99% ------------ ------------ 2954 EPA/BROWNFIELDS PLANNING 2954-480-470210-229 SUPPLIES-AWP GRT 15 1,000 985 98% 2954-480-470210-352 SALARIES-AWP GRT 5,850 30,000 24,150 81% 2954-480-470210-353 BENEFITS-AWP GRT 2,898 10,000 7,102 71% 2954-480-470210-354 CONTRACTED SERVICES-AWP GRT 13,299 75,186 61,887 82% 2954-480-470210-373 TRAVEL-AWP GRT 739 5,000 4,261 85% TOTAL 2954 EPA/BROWNFIELD PLAN ------------ 22,802 ------------ ------------ ------------ 121,186 ------------ ------------ ------------------------ 98,384 ------------------------ ------------------------ 81% 2955 BROWNFIELD LOAN REVOLVING 2955-480-470210-229 SUPPLIES -PETROLEUM 0 950 950 100% 2955-480-470210-352 PERSONNEL -PETROLEUM 0 16,942 16,942 100% 2955-480-470210-353 FRINGES -PETROLEUM 0 5,050 5,050 100% 2955-480-470210-354 CONTRACTED SERVICES-PETROLUEM 0 234,790 234,790 100% 2955-480-470210-373 TRAVEL -PETROLEUM 0 1,900 1,900 100% 2955-480-470210-720 LOANS -PETROLEUM 0 40,000 40,000 100% 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 0 2,500 2,500 100% 2955-480-470215-352 PERSONNEL -HAZARDOUS SUBSTANCES 0 47,780 47,780 100% 2955-480-470215-353 FRINGES -HAZARDOUS SUBSTANCES 0 14,306 14,306 100% 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 0 572,600 572,600 100% 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 0 2,500 2,500 100% 2955-480-470215-720 LOANS -HAZARDOUS SUBSTANCES 0 ------------ 60,000 ------------ 60,000 ------------------------ 100% TOTAL BROWNFIELDS REVOLVING 0 ------------ ------------ 999,318 ------------ ------------ 999,318 ------------------------ ------------------------ 100% 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN 0 8,875 8,875 100% 2915-413-420140-218 SMALL EQUIP - STONEGARDEN 0 8,875 8,875 100% TOTAL 2915 STONEGARDEN GRANT ------------ 0 ------------ ------------ ------------ 17,750 ------------ ------------ ------------------------ 17,750 ------------------------ ------------------------ 100% 2916 DRUG ENFOREEMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 13,297 55,580 42,283 76% 2916-413-420140-121 OVERTIME 1,144 6,000 4,856 81% 2916-413-420140-153 HEALTH INSURANCE 1,657 10,098 8,441 84% 2916-413-420140-155 RETIREMENT 1,692 7,475 5,783 77% 2916-413-420140-354 CONTRACT SERVICES 1,201 5,200 3,999 77% TOTAL 2916 DRUG ENFORCEMENT ------------ 18,990 ------------ ------------ ------------ 84,353 ------------ ------------ ------------------------ 65,363 ------------------------ ------------------------ 77% 2917 COPS TECHNOLOGY GRANT 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 20 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 2917-413-420140-950 SHOOTING FACILITY/2009CKWX0478 TOTAL 2917 COPS TECHNOLOGY GT 0 ------------ 0 ------------ ------------ 750,000 ------------ 750,000 ------------ ------------ 750,000 100% ------------------------ 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 (STEP GRT) 2919-413-420140-127 SCHOOL DIST. OT 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 2919-413-420140-221 Bullet Proof Vests 2919-413-420140-940 EQUIPMENT (Radio Grant) TOTAL LAW ENF. GRANT 2921 DRUG COURT GRANT 2921-406-410360-354 DRUG COURT -contract services TOTAL DRUG COURT GRANT 2951 DUI COURT GRANT 2951-406-410360-354 CS-EVAL,P0,LAC-CTS106687 2951-406-410360-396 DUI CRT INCENTIVES 2951-406-410361-354 CS-EVAL,PO,LAC CTS-106006 TOTAL DUI COURT GRANT 2930 PRESERVE AMERICA GRANT 2930-480-470240-354 CONT SERV-NPS PRESERVE AMERICA TOTAL 2930 PRESERVE AMERICA 2927 CULTRUAL ARTS PASSTHRU GT 2927-400-460452-354 HOCKADAY 2927-400-460454-354 GLACIER ORCHESTRA 2927-400-460456-354 NW MT HISTORICAL SOCIETY TOTAL 2927 CULTURAL ARTS 2957 FIRE GRANTS 12,532 51,963 39,431 76% 3,888 15,555 11,667 75% 1,647 6,987 5,340 76% ------------ 18,067 ------------ ------------ ------------------------ 74,505 ------------------------ ------------------------ ------------ 56,438 ------------ ------------ 76% 736 1,200 464 39% 225 8,000 7,775 97% 8,153 48,800 40,647 83% 2,922 20,000 17,078 85% 0 2,500 2,500 100% 0 10,000 10,000 100% 15,737 16,360 623 4% ------------ 27,773 ------------ ------------ ------------------------ 106,860 ------------------------ ------------------------ ------------ 79,087 ------------ ------------ 74% 15,455 211,667 196,212 93% ------------ 15,455 ------------ ------------ ------------ 211,667 ------------ ------------ ------------------------ 196,212 ------------------------ ------------------------ 93% 0 130,462 130,462 100% 571 2,000 1,429 71% 16,817 37,955 21,138 56% ------------ 17,387 ------------ ------------ ------------ 170,417 ------------ ------------ ------------------------ 153,030 ------------------------ ------------------------ 90% 250 29,514 29,264 99% ------------ 250 ------------ ------------ ------------ 29,514 ------------ ------------ ------------------------ 29,264 ------------------------ ------------------------ 99% 0 4,500 4,500 100% 0 6,500 6,500 100% 0 2,500 2,500 100% ------------ 0 ------------ ------------ ------------ 13,500 ------------ ------------ ------------------------ 13,500 ------------------------ ------------------------ 100% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 21 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 2957-416-420400-155 RETIREMENT 118 0 118- 0% 2957-416-420400-218 EQUIPMENT (non capital) 0 4,523 4,523 100% 2957-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 0 6,000 6,000 100% 2957-416-420410-125 PASS THRU HAZMAT OT 974 20,000 19,026 95% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 565 55,054 54,489 99% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 5,000 5,000 100% 2957-416-420414-218 AFG-FIRE PREV MAT-EMW2010FP00286 0 155,000 155,000 100% TOTAL FIRE GRANTS 1,657 245,577 243,920 99% ----------------------------------------------- ----------------------------------------------- 2975 ISTEA 2975-436-460457-951 HWY93 NORTH TRAIL TOTAL ISTEA 2991 NSP GRANT 2991-480-470210-354 CONTRACT SERVICES-NSP #1 2991-480-470210-355 CONTRACT SERVICES NSP#3 TOTAL 2991 NSP GRANT 2995 SAFER GRANT 2995-416-420400-110 SALARIES 2995-416-420400-153 HEALTH INSURANCE 2995-416-420400-155 RETIREMENT TOTAL 2995 SAFER GRANT CAPITAL PROJECT FUNDS 4150 FIRE STATION #61 REMODEL 4150-416-420400-928 FIRE STATION 61 CONSTRUCTION TOTAL 4150 FIRE STATION REMODE 4188 WESTSIDE TIF CAPITAL PROD 4188-421-430240-354 MERIDIAN ROAD TRAFFIC IMPROVEMENTS 4188-447-430550-952 COLORADO ST. WATER MAIN EXTENSION TOTAL 4188 WESTSIDE TIF PROD 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 0 ------------ 146,780 ------------ 146,780 ------------------------ 100% 0 ------------ ------------ 146,780 ------------ ------------ 146,780 ------------------------ ------------------------ 100% 0 90,351 90,351 100% 0 ------------ 1,500,000 ------------ 1,500,000 ------------------------ 100% 0 ------------ ------------ 1,590,351 ------------ ------------ 1,590,351 ------------------------ ------------------------ 100% 34,413 90,000 55,587 62% 10,670 25,000 14,330 57% 4,679 12,204 7,525 62% ------------ 49,762 ------------ ------------ ------------ 127,204 ------------ ------------ ------------------------ 77,442 ------------------------ ------------------------ 61% 0 7,500 7,500 100% ------------ 0 ------------ ------------ ------------ 7,500 ------------ ------------ ------------------------ 7,500 ------------------------ ------------------------ 100% 13,629 190,324 176,695 93% 129,568 129,568 0 0% ------------ 143,197 ------------ ------------ ------------ 319,892 ------------ ------------ ------------------------ 176,695 ------------------------ ------------------------ 55% 3,792 ------------ 25,000 ------------ 21,208 ------------------------ 85% 3,792 ------------ ------------ 25,000 ------------ ------------ 21,208 ------------------------ ------------------------ 85% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 22 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 4345 "WILLOWS" STORM PROJECT 4345-453-430246-950 THE WILLOWS PROJECT 0 392,556 392,556 100% ------------------------------------------------ TOTAL "WILLOWS" PROJECT 0 392,556 392,556 100% ------------------------------------------------ ------------------------------------------------ 4312 FAA PLANNING GRANT 4312-430-430310-354 ENVIRONMENTAL ASSESSMENT 4312-430-430310-940 CAPITAL IMPROVEMENTS TOTAL FAA PLANNING GRANT 0 45,000 45,000 100% 0 258 258 100% ------------------------------------------------ 0 45,258 45,258 100% ------------------------------------------------ ------------------------------------------------ 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 23 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING ENTERPRISE FUNDS WATER REVENUE 5210-000-343210-000 METERED WATER SALES 943,513 2,600,000 1,656,487 64% 5210-000-343220-000 UNMETERED WATER SALES 927 4,000 3,073 77% 5210-000-343225-000 IMPACT FEES 50,900 225,000 174,100 77% 5210-000-343230-000 METER REPLACEMENT FEE 26,010 95,000 68,990 73% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 5,823 24,000 18,177 76% 5210-000-343265-000 IMPACT ADMIN FEES 0 13,000 13,000 100% 5210-000-343270-000 WATER TURN ON FEES 570 2,500 1,930 77% 5210-000-343275-000 TAG FEE 3,480 9,500 6,020 63% 5210-000-343365-000 LATECOMER ADMIN FEE 24 0 24- 0% 5210-000-371010-000 INVESTMENT EARNINGS 8,596 50,000 41,404 83% TOTAL WATER REVENUE 1,039,845 ------------ ------------ 3,023,000 ------------ ------------ 1,983,155 ------------------------ ------------------------ 66% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 137,092 664,243 527,151 79% 5210-447-430550-111 SEASONAL SALARIES 2,219 5,000 2,781 56% 5210-447-430550-112 SALARIES -RETIREMENT 0 35,000 35,000 100% 5210-447-430550-121 OVERTIME 3,745 20,000 16,255 81% 5210-447-430550-153 HEALTH INSURANCE 32,449 155,841 123,392 79% 5210-447-430550-155 RETIREMENT 8,747 44,321 35,574 80% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 1,371 10,000 8,629 86% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 605 9,500 8,896 94% 5210-447-430550-226 CHLORINE & CHEMICALS 13,870 38,000 24,130 64% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 474 4,800 4,326 90% 5210-447-430550-231 GAS & OIL 4,934 35,000 30,066 86% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 0 4,500 4,500 100% 5210-447-430550-336 LICENSES & FEES 190 19,000 18,810 99% 5210-447-430550-341 ELECTRICITY 30,483 143,000 112,517 79% 5210-447-430550-344 NATURAL GAS 404 13,000 12,596 97% 5210-447-430550-345 TELEPHONE & COMMUNICATION 1,092 8,000 6,908 86% 5210-447-430550-349 LAB SERVICES 2,980 22,500 19,520 87% 5210-447-430550-353 AUDITING 0 3,000 3,000 100% 5210-447-430550-354 CONTRACT SERVICES 1,539 55,000 53,461 97% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 2,254 25,000 22,746 91% 5210-447-430550-357 PLANS/STUDIES/REVIEWS 0 6,500 6,500 100% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 393 14,950 14,557 97% 5210-447-430550-366 BUILDING MAINTENANCE 15 17,000 16,985 100% 5210-447-430550-373 DUES & TRAINING 349 9,200 8,851 96% 5210-447-430550-388 MEDICAL SERVICES 50 700 651 93% 5210-447-430550-410 CONSTRUCTION MATERIALS 14,707 32,000 17,293 54% 5210-447-430550-411 Meter Pit - Materials 0 6,500 6,500 100% 5210-447-430550-422 HYDRANTS 4,891 10,000 5,109 51% 5210-447-430550-423 MATERIALS FOR MAINS 1,119 11,000 9,881 90% 5210-447-430550-424 MATERIALS -SERVICE LINES 4,713 11,000 6,287 57% 5210-447-430550-425 MATERIALS PUMPS/WELLS 1,077 30,000 28,923 96% 5210-447-430550-510 PROPERTY & LIABILITY INS. 33,367 36,500 3,133 9% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 0 24,000 24,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 2,000 8,000 6,000 75% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 24,206 96,825 72,619 75% 5210-447-430550-528 DATA PROCESSING TRANSFER 6,091 21,172 15,081 71% 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 3,919 7,838 3,919 50% 5210-447-430550-935 ARMORY WELL GENERATOR REPLACEMENT 0 90,000 90,000 100% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 24 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 5210-447-430550-936 Noffsinger Spring Generator 0 90,000 90,000 100% 5210-447-430550-937 Sheepherder Res. SCADA Backup PWR 0 16,000 16,000 100% 5210-447-430550-938 Lower Zone Reservoir Improvements 0 120,000 120,000 100% 5210-447-430550-940 MACHINERY & EQUIPMENT 6,245 76,500 70,255 92% 5210-447-430550-941 0 0 34,000 34,000 100% 5210-447-430550-948 METERS (METER FUNDS) 010125 13,175 130,000 116,825 90% 5210-447-430550-951 SECURITY SYSTEM UPGRADES 63 25,861 25,798 100% 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 748 165,000 164,252 100% 5210-447-430550-962 UPSIZE MAIN -1ST AVE E&IDAHO 0 311,900 311,900 100% 5210-447-430550-963 ABANDON 2" H2O LINE 0 45,000 45,000 100% 5210-447-430550-964 2ND AVE WN H2O LINE REPLACE 0 248,000 248,000 100% 5210-447-430550-965 E AZ H2O LINE UPSIZE 0 195,000 195,000 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 50,000 50,000 100% 5210-447-430555-941 METERS (NEW SERVICES)010120 11,455 65,000 53,545 82% 5210-447-430555-953 SECTION 36 WELL 0 43,000 43,000 100% SUBTOTAL WATER FACILITIES 373,028 3,363,151 2,990,123 89% ----------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 5210-447-430560-153 HEALTH INSURANCE 5210-447-430560-155 RETIREMENT 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 5210-447-430560-353 AUDITING 5210-447-430560-354 CONTRACT SERVICES 5210-447-430560-355 BILLING COSTS 5210-447-430560-373 DUES & TRAINING 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5210-447-430560-528 DATA PROCESSING TRANSFER 5210-447-430560-532 RENT SUBTOTAL 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 INT 2012 REFI WRF 1.25& MTR/HYDRANT 5210-447-490206-630 FISCAL AGENT FEES 5210-447-490250-610 SRF 2001 PRINCIPAL 4% 5210-447-490250-620 2001 SRF INTEREST 4% SUBTOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 14,494 82,942 68,448 83% 3,028 22,343 19,315 86% 930 5,481 4,551 83% 37 3,000 2,963 99% 0 1,500 1,500 100% 869 4,000 3,131 78% 7,223 35,000 27,777 79% 0 1,500 1,500 100% 1,776 7,103 5,327 75% 6,091 24,365 18,274 75% 3,919 7,838 3,919 50% ------------ 38,367 ------------ ------------ 195,072 ------------ ------------------------ 156,705 ------------------------ 80% 0 55,000 55,000 100% 38,995 38,995 0 0% 300 300 0 0% 0 232,000 232,000 100% 41,443 65,994 24,551 37% 2,250 2,250 0 0% 0 41,000 41,000 100% 9,184 15,520 6,336 41% ------------ 92,172 ------------ ------------ 451,059 ------------ ------------------------ 358,887 ------------------------ 80% 0 840,000 840,000 100% ------------ 0 ------------ ------------ 840,000 ------------ ------------------------ 840,000 ------------------------ 100% 503,567 4,849,282 4,345,715 90% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 25 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 26 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING SEWER REVENUE: 5310-000-343310-000 SEWER SERVICE CHARGES 1,128,616 4,115,000 2,986,384 73% 5310-000-343330-000 IMPACT FEES (SANITARY) 46,194 92,000 45,806 50% 5310-000-343335-000 IMPACT FEES (WWTP) 62,295 124,000 61,705 50% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 375 2,000 1,625 81% 5310-000-343365-000 LATECOMER ADMIN FEES 16 0 16- 0% 5310-000-371010-000 INVESTMENT EARNINGS 9,812 45,000 35,188 78% TOTAL SEWER REVENUE 1,247,308 ------------ ------------ 4,378,000 ------------ ------------ 3,130,692 ------------------------ ------------------------ 72% SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 12,625 67,647 55,022 81% 5310-454-430620-153 HEALTH INSURANCE 3,029 20,675 17,646 85% 5310-454-430620-155 RETIREMENT 809 4,329 3,520 81% 5310-454-430620-215 OFFICE SUPPLIES/computers 37 3,000 2,963 99% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 4,000 4,000 100% 5310-454-430620-355 BILLING COSTS 8,091 35,000 26,909 77% 5310-454-430620-373 DUES & TRAINING 0 1,500 1,500 100% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 1,593 6,373 4,780 75% 5310-454-430620-528 DATA PROCESSING TRANSFER 6,091 24,365 18,274 75% 5310-454-430620-532 OFFICE RENT 3,919 7,838 3,919 50% SUBTOTAL SEWER BILLING COSTS ------------ 36,194 ------------ ------------ 174,727 ------------ ------------------------ 138,533 ------------------------ 79% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 48,520 233,868 185,348 79% 5310-454-430630-112 SALARIES-SEVERANCE/RETIREMENT 0 2,500 2,500 100% 5310-454-430630-121 OVERTIME 213 7,500 7,287 97% 5310-454-430630-153 HEALTH INSURANCE 12,412 53,882 41,470 77% 5310-454-430630-155 RETIREMENT 3,053 14,593 11,540 79% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 639 6,200 5,561 90% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 289 9,500 9,211 97% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 114 2,000 1,886 94% 5310-454-430630-231 GAS & OIL 1,536 9,500 7,964 84% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 139 300 161 54% 5310-454-430630-341 ELECTRICITY 6,554 48,500 41,946 86% 5310-454-430630-344 NATURAL GAS 1,747 13,500 11,753 87% 5310-454-430630-345 TELEPHONE & COMMUNICATION 1,998 21,700 19,702 91% 5310-454-430630-353 AUDITING 0 2,000 2,000 100% 5310-454-430630-354 CONTRACT SERVICES 1,580 21,000 19,420 92% 5310-454-430630-356 CONSULTANTS 0 7,500 7,500 100% 5310-454-430630-357 IMPACT FEE REVIEW/STUDY 0 6,500 6,500 100% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 149 6,800 6,651 98% 5310-454-430630-373 DUES & TRAINING 100 2,500 2,400 96% 5310-454-430630-388 MEDICAL SERVICES 99 800 701 88% 5310-454-430630-410 CONSTRUCTION MATERIALS 2,296 9,000 6,704 74% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 2,709 20,000 17,291 86% 5310-454-430630-510 PROPERTY & LIABILITY INS. 82,706 73,700 9,006- -12% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 594 16,000 15,406 96% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 625 2,500 1,875 75% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 15,383 61,533 46,150 75% 5310-454-430630-528 DATA PROCESSING TRANSFER 4,188 16,751 12,563 75% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 27 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 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-920 Install Lift Station Enclosure 0 6,500 6,500 100% 5310-454-430630-954 93 So. BYPASS -UTILITY RELOCATE 0 15,000 15,000 100% 5310-454-430630-960 Manhole Rehab./Swr Main Replacement 0 15,000 15,000 100% SUBTOTAL SEWER COLLECTION ------------ 191,561 ------------ ------------ 739,965 ------------ ------------ 548,405 ------------ ------------ 74% ------------ IMPACT FEES 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE SUBTOTAL IMPACT FEE EXPENSE REVENUE BONDS/SANITARY 5310-454-490204-610 PRINCIPAL-2004 BONDS(HWY 93 S) 5310-454-490204-620 INTEREST-2004 BONDS 5310-454-490204-630 FISCAL AGENT FEES SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION -SANITARY SUBTOTAL SANITARY SEWER 0 245,000 245,000 100% ------------ 0 ------------ ------------ 245,000 ------------ ------------------------ 245,000 ------------------------ 100% 0 69,000 69,000 100% 24,767 37,200 12,433 33% 0 300 300 100% ------------ 24,767 ------------ ------------ 106,500 ------------ ------------------------ 81,733 ------------------------ 77% 0 820,000 820,000 100% ------------ 0 ------------ ------------ 820,000 ------------ ------------------------ 820,000 ------------------------ 100% 216,327 ------------ 1,911,465 ------------ 1,695,138 ------------------------ 89% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 75,103 346,972 271,869 78% 5310-455-430640-111 SEASONAL SALARIES 2,219 5,000 2,782 56% 5310-455-430640-121 OVERTIME 3,844 21,000 17,156 82% 5310-455-430640-153 HEALTH INSURANCE 14,716 61,570 46,854 76% 5310-455-430640-155 RETIREMENT 4,938 21,473 16,535 77% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 0 5,000 5,000 100% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 789 2,500 1,711 68% 5310-455-430640-225 ALUM 0 25,000 25,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 0 12,000 12,000 100% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 1,125 7,000 5,875 84% 5310-455-430640-231 GAS & OIL 2,173 15,000 12,827 86% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 0 350 350 100% 5310-455-430640-336 LICENSES & FEES 144 11,000 10,857 99% 5310-455-430640-341 ELECTRICITY 26,036 170,000 143,964 85% 5310-455-430640-342 WATER 1,175 6,000 4,825 80% 5310-455-430640-344 NATURAL GAS 2,679 55,000 52,321 95% 5310-455-430640-345 TELEPHONE & COMMUNICATION 471 5,500 5,029 91% 5310-455-430640-353 AUDITING 0 2,750 2,750 100% 5310-455-430640-354 CONTRACT -GLACIER GOLD 21,050 118,000 96,950 82% 5310-455-430640-355 OTHER CONTRACT SERVICES 135 30,000 29,865 100% 5310-455-430640-356 CONSULTANTS 1,030 35,000 33,970 97% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 28 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 5310-455-430640-360 MISC. MAINT SERVICES 2,824 28,000 25,176 90% 5310-455-430640-366 BUILDING MAINTENANCE 370 3,000 2,630 88% 5310-455-430640-373 DUES & TRAINING 609 8,500 7,891 93% 5310-455-430640-388 MEDICAL SERVICES 278 550 273 50% 5310-455-430640-510 PROPERTY & LIABILITY INS. 43,575 46,750 3,175 7% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 1,375 5,500 4,125 75% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 31,684 126,734 95,050 75% 5310-455-430640-528 DATA PROCESSING TRANSFER 5,225 20,899 15,674 75% 5310-455-430640-920 BUILDINGS 0 110,000 110,000 100% SUBTOTAL WWTP OPERATIONS 243,565 1,321,048 1,077,483 82% ----------------------------------------------- WWTP BONDED PROJECT 5310-455-430644-935 WWTP - BONDED PROJECT SUBTOTAL WWTP BONDED WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 5310-455-430645-933 Solids Dewatering Design & Constru 5310-455-430645-940 MACHINERY & EQUIPMENT 5310-455-430646-110 5310-455-430646-153 5310-455-430646-155 5310-455-430646-210 5310-455-430646-218 5310-455-430646-222 5310-455-430646-349 5310-455-430646-362 5310-455-430646-373 SUBTOTAL WWTP REPLACEMENT WWTP LAB OPERATIONS SALARIES-WWTP LAB HEALTH INSURANCE RETIREMENT COMPUTER/OTHER SUPPLIES NON -CAPITAL EQUIPMENT LAB SUPPLIES LAB SERVICES EQUIPMENT MAINTENANCE DUES & TRAINING SUBTOTAL WWTP LAB OPERATIONS SRF LOAN/WWTP 5310-455-490215-610 DEBT SRF Loan 1991-PRINCIPAL 5310-455-490215-620 DEBT SRF LOAN 1991-INTEREST SUBTOTAL SRF LOAN/WWTP DEBT SERVICE 2007 SRF 5310-455-490227-610 SRF 2007WWTP PRINCIPAL 5310-455-490227-620 SRF 2007WWTP INTEREST 5310-455-490227-630 FISCAL AGENT FEES SUBTOTAL SRF 2007 SUBTOTAL WWTP DEBT 0 865,000 865,000 100% ------------ 0 ------------ ------------ 865,000 ------------ ------------------------ 865,000 ------------------------ 100% 681 70,000 69,319 99% 0 560,000 560,000 100% 5,660 101,948 96,288 94% ------------ 6,342 ------------ ------------ 731,948 ------------ ------------------------ 725,606 ------------------------ 99% 26,846 115,328 88,482 77% 4,719 18,912 14,193 75% 1,670 7,147 5,477 77% 161 7,350 7,189 98% 55 3,000 2,945 98% 1,069 7,500 6,431 86% 2,561 20,000 17,440 87% 482 3,500 3,018 86% 180 2,700 2,520 93% ------------ 37,742 ------------ 185,437 ------------------------ 147,695 80% 0 140,000 140,000 100% 0 2,800 2,800 100% ------------ 0 ------------ ------------ 142,800 ------------ ------------------------ 142,800 ------------------------ 100% 0 470,000 470,000 100% 317,291 471,788 154,497 33% 12,750 ------------ 12,750 ------------ 0 ------------------------ 0% 330,041 ------------ 954,538 ------------ 624,497 ------------------------ 65% 330,041 ------------ 1,097,338 ------------ 767,297 ------------------------ 70% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 29 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 0 411,599 411,599 100% 5310-455-510400-831 DEPRECIATION EXPENSE 0 1,425,000 1,425,000 100% SUTOTAL WWTP DEPRECIATION/REPL ------------ 0 ------------ ------------ 1,836,599 ------------ ------------------------ 1,836,599 100% ------------------------ SUBTOTAL WWTP 617,690 ------------ 6,037,370 ------------ 5,419,680 ------------------------ 90% TOTAL BILLING/SANITARY/WWTP 870,211 ------------ ------------ 8,123,562 ------------ ------------ 7,253,351 ------------------------ ------------------------ 89% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 30 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING STORM SEWER REVENUE 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 7,488 2,415 5,073- -210% 5349-000-343033-000 IMPACT FEES 19,057 52,500 33,443 64% 5349-000-343034-000 PERMIT FEES 315 0 315- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 420 420 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 0 820,000 820,000 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,957 5,000 3,043 61% 5349-000-371010-000 INTEREST ON INVESTMENTS 5,421 22,000 16,579 75% TOTAL STORM REVENUE 34,238 902,335 868,097 96% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 63,015 324,215 261,200 81% 5349-453-430246-112 SEVERANCE 0 2,500 2,500 100% 5349-453-430246-121 OVERTIME 240 5,000 4,760 95% 5349-453-430246-153 HEALTH INSURANCE 15,263 70,795 55,532 78% 5349-453-430246-155 RETIREMENT 3,977 20,441 16,464 81% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 1,421 9,100 7,679 84% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 0 3,500 3,500 100% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 35 2,200 2,165 98% 5349-453-430246-231 GAS & OIL 1,559 10,500 8,941 85% 5349-453-430246-345 TELEPHONE & COMMUNICATION 44 950 906 95% 5349-453-430246-353 AUDITING 0 600 600 100% 5349-453-430246-354 CONTRACT SERVICE 438 6,200 5,762 93% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 0 30,000 30,000 100% 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 587 1,500 913 61% 5349-453-430246-362 GROUNDWATER MONITORING 0 17,000 17,000 100% 5349-453-430246-371 CURB & GUTTER 0 5,000 5,000 100% 5349-453-430246-373 DUES & TRAINING 380 3,500 3,120 89% 5349-453-430246-388 MEDICAL SERVICES 0 200 200 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 1,067 10,000 8,933 89% 5349-453-430246-510 PROPERTY & LIABILITY INS. 7,345 13,500 6,155 46% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 750 3,000 2,250 75% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 8,176 32,704 24,528 75% 5349-453-430246-528 DATA PROCESSING TRANSFER 1,492 5,969 4,477 75% 5349-453-430246-530 BNSF LEASE PMT 0 5,200 5,200 100% 5349-453-430246-532 OFFICE RENT 3,919 7,838 3,919 50% 5349-453-430246-941 UTILITY ASSET MANAGEMENT PROGRAM 0 38,738 38,738 100% 5349-453-430246-944 VEHICLES 0 123,500 123,500 100% 5349-453-430246-952 STORM DRAIN CORRECTION 8,581 100,000 91,419 91% 5349-453-430246-954 S MEADOWS SURVEY 8,325 706,125 697,800 99% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 30,000 30,000 100% 5349-453-430249-944 Vacuum Jet Truck - 62% 0 201,500 201,500 100% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 100% TOTAL STORM ------------ 126,615 ------------ ------------ ------------ 2,106,275 ------------ ------------ ------------------------ 1,979,660 ------------------------ ------------------------ 94% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 31 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 46- 843,000 843,046 100% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 2,060 15,000 12,940 86% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 2,515 5,500 2,985 54% 5510-000-371010-000 INVESTMENT EARNINGS 1,207 5,000 3,793 76% TOTAL SOLID WASTE REVENUE ------------ 5,736 ------------ ------------ ------------ 868,500 ------------ ------------ ------------ 862,764 ------------ ------------ ------------ 99% ------------ ------------ SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 77,409 355,935 278,526 78% 5510-460-430840-112 SEVERANCE -RETIREMENT 0 12,500 12,500 100% 5510-460-430840-121 OVERTIME 1,484 5,000 3,516 70% 5510-460-430840-153 HEALTH INSURANCE 19,897 85,902 66,005 77% 5510-460-430840-155 RETIREMENT 4,914 22,084 17,170 78% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 18 3,500 3,482 99% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 0 20,000 20,000 100% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 218 5,500 5,282 96% 5510-460-430840-231 GAS & OIL 9,001 50,000 40,999 82% 5510-460-430840-341 ELECTRICITY 159 1,700 1,541 91% 5510-460-430840-344 NATURAL GAS 80 4,000 3,920 98% 5510-460-430840-345 TELEPHONE & COMMUNICATION 94 700 606 87% 5510-460-430840-354 CONTRACT SERVICES 935 12,000 11,065 92% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 2,795 5,700 2,905 51% 5510-460-430840-366 BUILDING MAINTENANCE 0 2,500 2,500 100% 5510-460-430840-373 DUES & TRAINING 690 2,500 1,810 72% 5510-460-430840-388 MEDICAL SERVICES 50 500 451 90% 5510-460-430840-510 PROPERTY & LIABILITY INS. 13,666 12,500 1,166- -9% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 6,500 6,500 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 7,125 28,500 21,375 75% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 6,938 27,753 20,815 75% 5510-460-430840-528 DATA PROCESSING TRANSFER 1,904 7,614 5,711 75% 5510-460-430840-532 OFFICE RENT 3,919 7,838 3,919 50% 5510-460-430840-940 EQUIPMENT 0 45,000 45,000 100% 5510-460-430845-224 JANITORIAL SUPPLIES 0 200 200 100% 5510-460-430845-341 ELECTRICITY 433 3,200 2,767 86% 5510-460-430845-342 WATER 157 500 343 69% 5510-460-430845-344 NATURAL GAS 131 8,500 8,369 98% 5510-460-430845-360 REPAIR & MAINT SERVICES 442 2,500 2,058 82% 5510-460-510400-831 DEPRECIATION EXPENSE 0 ------------ 150,000 ------------ 150,000 ------------------------ 100% TOTAL SOLID WASTE EXPENSE 152,459 ------------ ------------ 890,626 ------------ ------------ 738,167 ------------------------ ------------------------ 83% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 32 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 2,700 9,400 6,700 71% 5160-000-343063-000 TIE DOWN FEES 770 3,500 2,730 78% 5160-000-343069-000 HANGER LEASES 3,000 12,000 9,000 75% 5160-000-343071-000 HANGAR SITE LEASES 16,999 16,500 499- -3% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 4,282 17,340 13,058 75% 5160-000-343102-000 GROUND LEASES 11,727 11,726 1- -0% 5160-000-343620-000 FUEL TAX 2,331 5,500 3,169 58% 5160-000-371010-000 INVESTMENT EARNINGS 361 3,000 2,639 88% TOTAL AIRPORT REVENUE ------------ ------------ 42,169 78,966 ------------ ------------ 36,797 ------------------------ ------------------------ 47% 5160 AIRPORT EXPENSES 5160-430-430310-110 SALARIES 5,477 35,108 29,631 84% 5160-430-430310-111 SEASONAL SALARIES 1,035 3,258 2,223 68% 5160-430-430310-153 HEALTH INSURANCE 1,411 7,308 5,897 81% 5160-430-430310-155 RETIREMENT 421 2,497 2,076 83% 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 18 1,150 1,132 98% 5160-430-430310-341 ELECTRICITY 242 1,500 1,258 84% 5160-430-430310-345 TELEPHONE 136 850 714 84% 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 0 4,000 4,000 100% 5160-430-430310-355 ELECTION 0 10,000 10,000 100% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 0 6,000 6,000 100% 5160-430-430310-357 CONTRACT SERVICES - legal 5,204 10,000 4,796 48% 5160-430-430310-362 REPAIR & MAINTENANCE 335 3,000 2,665 89% 5160-430-430310-373 DUES & TRAINING 50 500 450 90% 5160-430-430310-390 EQUIPMENT RENTAL 1,053 2,000 947 47% 5160-430-430310-510 PROPERTY INSURANCE 1,364 4,000 2,636 66% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 1,100 4,398 3,299 75% 5160-430-430310-528 DATA PROCESSING TRANSFER 746 2,822 2,076 74% 5160-430-430310-820 DEPRECIATION 0 100,832 100,832 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 0 43,010 43,010 100% ------------ TOTAL AIRPORT EXPENSES ------------ ------------ 18,592 ------------ 242,233 ------------ ------------ ------------------------ 223,641 ------------------------ ------------------------ 92% 10.26.2012 16:05 THE CITY OF KALISPELL, MONTANA Page 33 of 33 gb8501_pg.php/Job No: 47076 USER: RGW 1ST QUARTER FINANCE REPORT - FY2013 25.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING DATA PROCESSING REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 42,500 85,000 42,500 50% 6030-000-341027-000 Bresnan/Optimun Franch. Fees 0 157,000 157,000 100% 6030-000-364030-000 SALE OF MISCELLANEOUS 235 100 135- -135% 6030-000-371010-000 INVESTMENT EARNINGS 175 1,200 1,025 85% 6030-000-393000-000 INTERNAL SERVICES -DATA 39,840 189,340 149,500 79% TOTAL DATA PROCESSING REVENUE ------------ 82,750 ------------ ------------ ------------ 432,640 ------------ ------------ ------------ 349,890 ------------ ------------ ------------ 81% ------------ ------------ DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 32,625 140,220 107,595 77% 6030-401-410580-121 OVERTIME 0 5,000 5,000 100% 6030-401-410580-153 HEALTH INSURANCE 6,703 26,988 20,285 75% 6030-401-410580-155 RETIREMENT 2,139 9,086 6,947 76% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 1,177 1,500 323 22% 6030-403-410580-215 COMPUTER SUPPLIES 324 3,230 2,906 90% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 1,940 13,973 12,033 86% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 605 1,450 845 58% 6030-403-410580-346 SUMMIT NET T1 CONTRACT 737 7,520 6,783 90% 6030-403-410580-353 LASER FICHE MAINTENANCE 6,234 3,234 3,000- -93% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 0 2,400 2,400 100% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 6,387 45,602 39,215 86% 6030-403-410580-357 GRANICUS 0 6,000 6,000 100% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 1,968 30,300 28,332 94% 6030-403-410580-373 DUES & TRAINING 0 6,000 6,000 100% 6030-403-410580-510 INSURANCE 2,648 1,350 1,298- -96% 6030-403-410583-218 TV -Video Equipment & programming 1,429 2,000 571 29% 6030-403-410583-354 TV -Video Contract Services 400 2,500 2,100 84% 6030-403-410585-229 COPIER,FAX, SUPPLIES 0 5,000 5,000 100% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 9,656 70,000 60,344 86% 6030-403-410585-532 COPIER LEASES 5,145 32,000 26,855 84% 6030-403-410585-942 Servers - capital contingency 0 18,000 18,000 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 3,302 3,640 338 9% 6030-410-410588-218 COMPUTERS - DPW 0 4,500 4,500 100% 6030-413-410588-218 COMPUTERS - POLICE DEPT 3,674 6,400 2,726 43% 6030-416-410588-218 COMPUTERS - FIRE 1,333 3,000 1,667 56% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 1,143 4,040 2,897 72% 6030-436-410588-218 COMPUTERS - PARKS 2,312 4,500 2,188 49% TOTAL DATA PROCESSING EXPENSE ------------ 91,880 ------------ ------------ ------------ 464,433 ------------ ------------ ------------------------ 372,553 ------------------------ ------------------------ 80%