Loading...
2nd Quarter Financial ReportTHE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 1 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,245,435 4,900,000 2,654,565 54% 1000-000-311105-000 PILT-GL MANOR, TRES ST PL, ACCESSIB 11,700 20,635 8,935 43% 1000-000-311200-000 PERSONAL PROPERTY TAXES 165,659 175,000 9,341 5% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 11,039 30,000 18,961 63% 1000-000-322101-000 BEER & LIQUOR LICENSES 3,285 25,000 21,715 87% 1000-000-322300-000 BUSINESS LICENSES 821 1,225 404 33% 1000-000-322500-000 AMUSEMENT LICENSES 0 350 350 100% 1000-000-323012-000 PLANNING FEES 7,004 20,000 12,996 65% 1000-000-323107-000 EXCAV/DEMO/AIR/HOUSE MOVING PERMITS 0 500 500 100% 1000-000-323109-000 SITE REVIEW 5,104 9,500 4,396 46% 1000-000-323200-000 PARADE PERMITS 300 750 450 60% 1000-000-323300-000 ANIMAL LICENSES 1,060 1,000 60- -6% 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 58,201 56,550 1,651- -3% 1000-000-335110-000 LIVE CARD TABLE PERMIT 2,650 3,200 550 17% 1000-000-335230-000 HB124 ENTITLEMENT 1,217,413 2,361,950 1,144,537 48% 1000-000-341020-000 ADMINISTRATIVE CHARGES 250,988 512,000 261,012 51% 1000-000-341021-000 GRANT ADMIN FEES 7,722 15,000 7,278 49% 1000-000-341025-000 CITY COLLECTIONS 5,800 1,200 4,600- -383% 1000-000-341026-000 LEAGUE OF CITIES CONFERENCE 6,548 2,500 4,048- -162% 1000-000-341027-000 BRESNAN FRANCHISE FEES (to 6030 FY1 2,893 0 2,893- 0% 1000-000-342010-000 POLICE SERVICES 10,788 21,500 10,712 50% 1000-000-342014-000 RESOURCE OFFICERS 86,000 86,000 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 925 5,000 4,075 82% 1000-000-342020-000 FIRE CHG.SPEC.EVENTS/INSTRUCTOR CHG 25 0 25- 0% 1000-000-342025-000 FIRE ENGINE RESPONSE FEE 150 0 150- 0% 1000-000-343005-000 CENTRAL GARAGE CHARGE 65,707 131,300 65,593 50% 1000-000-343018-000 PARKING PERMITS METERS, BOOT REMOVE 40,072 80,000 39,928 50% 1000-000-351000-000 CITY COURT FINES & FEES 198,153 500,000 301,847 60% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 11,527 25,000 13,473 54% 1000-000-351035-000 PARKING FINES 18,303 52,000 33,697 65% 1000-000-362010-000 CITY GOLF COURSE LEASE 0 25,000 25,000 100% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 6,024 7,500 1,476 20% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 3,589 1,500 2,089- -139% 1000-000-365015-000 CONTRIBUTION FRM KIDSPORT 0 44,000 44,000 100% 1000-000-365018-000 BANDSHELL CONTRIBUTIONS 363 0 363- 0% 1000-000-371010-000 INVESTMENT EARNINGS 5,280 20,000 14,720 74% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 342,500 660,239 317,739 48% TOTAL GENERAL FUND REVENUE 4,793,028 9,796,729 5,003,701 51% ------------------------------------------------ ------------------------------------------------ THE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 2 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 965 1,435 470 33% 1000-400-410530-353 AUDITING 10,000 10,500 500 5% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,318 3,500 1,182 34% 1000-400-410560-312 POSTAGE 7,970 14,500 6,530 45% 1000-400-410560-320 PRINTING & ENVELOPES 2,187 7,000 4,813 69% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 627 3,500 2,873 82% 1000-400-411850-379 LEAGUE OF CITIES CONFERENCE 20,529 15,000 5,529- -37% 1000-400-420000-354 CONTRACT 911 CENTER 218,655 437,311 218,656 50% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 323 350 27 8% 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 7,024 30,000 22,976 77% 1000-400-510330-517 PROPERTY INSURANCE 50,817 45,000 5,817- -13% SUBTOTAL GEN.GOV'T. ------------ 536,800 ------------ 893,313 ------------ 356,513 ------------ 40% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 60,497 122,294 61,797 51% 1000-401-410210-153 HEALTH INSURANCE 9,990 19,711 9,721 49% 1000-401-410210-155 RETIREMENT 6,301 12,915 6,614 51% 1000-401-410210-210 COMPUTER SOFTWARE/SUPPLIES 0 300 300 100% 1000-401-410210-312 NEWSLETTER/BOOKS 0 500 500 100% 1000-401-410210-338 RECRUITMENT 0 10,000 10,000 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 240 480 240 50% 1000-401-410210-373 DUES & TRAINING 3,962 6,000 2,038 34% 1000-401-410210-379 MEETINGS 203 500 297 59% SUBTOTAL CITY MANAGER ------------ 81,192 ------------------------ 172,700 ------------ 91,508 53% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 54,997 111,534 56,537 51% 1000-401-410830-153 HEALTH INSURANCE 10,132 17,502 7,370 42% 1000-401-410830-155 RETIREMENT 3,590 7,242 3,652 50% 1000-401-410830-210 OFFICE SUPPLIES 75 400 325 81% 1000-401-410830-338 RECRUITMENT/RELOCATION 2,686 3,500 814 23% 1000-401-410830-354 CONTRACT SERVICES 240 4,000 3,760 94% 1000-401-410830-373 DUES & TRAINING 763 3,900 3,137 80% SUBTOTAL HUMAN RESOURCES ------------ 72,483 ------------------------ 148,078 ------------ 75,595 51% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 3 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 30,689 62,994 32,305 51% 1000-402-410100-153 HEALTH INSURANCE 21,280 36,540 15,260 42% 1000-402-410100-155 RETIREMENT 1,523 3,266 1,743 53% 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,878 5,978 100 2% 1000-402-410100-379 MEETINGS 0 500 500 1000-0 SUBTOTAL MAYOR/COUNCIL ------------ 60,170 ------------ 110,378 ------------ ------------ 50,208 45% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 40,734 82,619 41,885 51% 1000-402-410150-121 OVERTIME 91 500 409 82% 1000-402-410150-153 HEALTH INSURANCE 5,885 10,837 4,952 46% 1000-402-410150-155 RETIREMENT 2,659 5,346 2,687 50% 1000-402-410150-210 OFFICE SUPPLIES 81 100 19 190-0 1000-402-410150-345 TELEPHONE & COMMUNICATION 556 450 106- -24% 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 150 300 150 50% SUBTOTAL CITY CLERK ------------ 53,042 ------------ 103,677 ------------------------ 50,635 49% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 92,443 190,440 97,997 51% 1000-403-410550-153 HEALTH INSURANCE 19,600 36,992 17,392 47% 1000-403-410550-155 RETIREMENT 6,025 12,377 6,352 51% 1000-403-410550-322 BOOKS 166 300 134 45% 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 1,293 3,500 2,207 63% 1000-403-410550-373 DUES & TRAINING 516 5,000 4,484 900-0 SUBTOTAL FINANCE ------------ 120,796 ------------ 251,709 ------------ ------------ 130,913 52% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 4 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 159,507 320,797 161,290 50% 1000-404-411110-153 HEALTH INSURANCE 32,458 55,691 23,233 42% 1000-404-411110-155 RETIREMENT 10,421 20,849 10,428 50% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 1,172 3,200 2,028 63% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 5,800 7,000 1,200 17% 1000-404-411110-345 TELEPHONE & COMMUNICATION 424 1,200 776 65% 1000-404-411110-354 CONTRACT SERVICES 610 5,000 4,390 880-0 1000-404-411110-373 DUES & TRAINING 2,689 4,500 1,811 40% SUBTOTAL CITY ATTORNEY ------------ 213,081 ------------ 418,237 ------------------------ 205,156 49% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 101,544 205,305 103,761 51% 1000-406-410360-121 OVERTIME 128 0 128- 00-0 1000-406-410360-153 HEALTH INSURANCE 28,441 48,840 20,399 42% 1000-406-410360-155 RETIREMENT 6,644 13,316 6,672 50% 1000-406-410360-210 SUPPLIES 1,719 4,500 2,781 62% 1000-406-410360-320 PRINTING/BOOKS 496 500 4 10-0 1000-406-410360-345 TELEPHONE & COMMUNICATION 559 1,400 841 60% 1000-406-410360-353 SECURITY & TECHNOLOGY 5,852 40,000 34,148 85% 1000-406-410360-354 CONTRACT SERVICES 1,382 5,750 4,368 76% 1000-406-410360-373 DUES & TRAINING 3,452 6,300 2,848 45% 1000-406-410360-394 JURY & WITNESS FEES 2,071 5,750 3,679 64% 1000-406-410360-395 DRUG COURT 1,440 11,500 10,060 87% 1000-406-410360-396 DUI COURT INCENTIVES & MISC 0 1,500 1,500 1000-0 SUBTOTAL COURT ------------ 153,729 ------------ 344,661 ------------ ------------ 190,932 55% DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 7,645 17,740 10,095 57% 1000-410-430100-153 HEALTH INSURANCE 1,924 3,845 1,921 50% 1000-410-430100-155 RETIREMENT 494 1,248 754 60% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 555 4,025 3,470 86% 1000-410-430100-345 TELEPHONE & COMMUNICATION 139 200 61 31% 1000-410-430100-354 CONTRACT SERVICES 304 850 547 64% 1000-410-430100-373 DUES & TRAINING 456 1,150 694 60% SUBTOTAL ADMINISTRATION ------------ 11,517 ------------ 29,058 ------------------------ 17,541 60% CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 76,412 152,379 75,967 50% 1000-410-431330-121 OVERTIME 972 2,000 1,028 51% 1000-410-431330-153 HEALTH INSURANCE 16,800 31,516 14,716 47% 1000-410-431330-155 RETIREMENT 4,730 9,348 4,618 49% 1000-410-431330-210 OFFICE/COMPUTER SUPPLIES 38 1,200 1,162 97% 1000-410-431330-229 NON -CAPITAL & SAFETY EQUIPMENT 7,253 10,603 3,350 32% 1000-410-431330-231 GAS & OIL 76,795 156,500 79,705 51% 1000-410-431330-232 MOTOR VEHICLE PARTS. 38,639 93,000 54,362 58% 1000-410-431330-233 TIRES AND RELATED PARTS 9,589 32,075 22,486 70% 1000-410-431330-238 FILTERS & MISC. PARTS 2,645 6,700 4,055 61% 1000-410-431330-241 CONSUMABLE TOOLS/BOOKS 0 1,500 1,500 1000-0 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 5 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 1000-410-431330-341 ELECTRICITY 701 1,700 999 59% 1000-410-431330-344 NATURAL GAS 1,171 7,400 6,229 84% 1000-410-431330-354 CONTRACT SERVICES 10,023 35,000 24,977 71% 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 ------------ 247,569 ------------ 544,946 ------------ ------------ 297,377 55% SUBTOTAL PUBLIC WORKS ------------ 259,085 ------------ 574,004 ------------------------ 314,919 55% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 30,333 58,429 28,096 48% 1000-412-411230-121 OVERTIME 45 250 205 82% 1000-412-411230-153 HEALTH INSURANCE 8,418 14,130 5,712 40% 1000-412-411230-155 RETIREMENT 1,907 3,612 1,705 47% 1000-412-411230-220 SECURITY CAMERA -CITY HALL 0 5,000 5,000 100% 1000-412-411230-224 JANITORIAL SUPPLIES 1,112 5,200 4,088 79% 1000-412-411230-241 TOOLS & SUPPLIES 716 1,450 734 51% 1000-412-411230-341 ELECTRICITY 19,493 45,000 25,507 57% 1000-412-411230-344 NATURAL GAS 5,949 40,000 34,051 85% 1000-412-411230-345 TELEPHONE & COMMUNICATION 0 250 250 100% 1000-412-411230-354 CONTRACT SERVICES 5,360 23,000 17,640 77% 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 0 4,500 4,500 100% 1000-412-411230-362 EQUIPMENT MAINTENANCE 2,441 5,000 2,559 51% 1000-412-411230-366 BUILDING MAINTENANCE 12,609 17,300 4,691 27% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 2,842 3,400 558 16% 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 ------------ 99,639 ------------ 259,408 ------------------------ 159,769 62% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 121,528 244,400 122,872 50% 1000-420-411020-153 HEALTH INSURANCE 30,263 55,944 25,681 46% 1000-420-411020-155 RETIREMENT 7,942 15,883 7,941 50% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 194 7,500 7,306 97% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 299 2,700 2,401 89% 1000-420-411020-345 TELEPHONE 455 900 445 49% 1000-420-411020-354 CONTRACT SERVICES 680 1,600 920 57% 1000-420-411020-373 DUES & TRAINING 846 3,300 2,454 74% SUBTOTAL PLANNING DEPT. ------------ 162,208 ------------ 332,227 ------------------------ 170,019 51% THE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 6 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 913,851 1,815,535 901,684 50% 1000-413-420140-112 SALARIES -SEVERANCE 31,693 32,000 307 1% 1000-413-420140-114 SALARY -comptime buyout 29,933 15,000 14,933- -100% 1000-413-420140-121 OVERTIME (REG & AET OT) 34,704 70,000 35,296 50% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 1,389 25,000 23,611 94% 1000-413-420140-153 HEALTH INSURANCE 203,355 370,563 167,208 45% 1000-413-420140-155 RETIREMENT 115,435 235,584 120,149 51% 1000-413-420140-210 OFFICE SUPPLIES 1,202 3,500 2,298 66% 1000-413-420140-215 COMPUTER SUPPLIES 1,984 5,500 3,516 64% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 2,647 10,500 7,853 75% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,794 4,000 1,206 30% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 1,261 7,000 5,739 82% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 757 2,000 1,243 62% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 592 4,000 3,408 85% 1000-413-420140-227 AMMO & RELATED SUPPLIES 13,436 17,000 3,564 21% 1000-413-420140-228 PATROL CAR SUPPLIES 4,115 13,000 8,885 68% 1000-413-420140-229 OTHER SUPPLIES 860 3,500 2,640 75% 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,909 5,000 3,091 62% 1000-413-420140-345 TELEPHONE & COMMUNICATION 6,222 15,500 9,278 60% 1000-413-420140-354 CONTRACT SERVICES 552 6,000 5,448 91% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 5,780 8,000 2,221 28% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 0 4,000 4,000 100% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 1,055 2,000 945 47% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 2,852 20,000 17,148 86% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,351 2,500 1,149 46% 1000-413-420140-373 DUES & TRAINING 7,896 27,250 19,354 71% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 11 5,000 4,989 100% 1000-413-420140-380 TRAINING MATERIALS 193 2,000 1,808 90% 1000-413-420140-388 MEDICAL SERVICES 747 3,500 2,753 79% 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,163 1,500 338 23% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 30,000 55,000 25,000 45% 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 72,683 87,000 14,317 16% 1000-413-420141-110 SALARIES -DETECTIVES 172,362 344,535 172,173 50% 1000-413-420141-121 DETECTIVE -OVERTIME 6,698 15,000 8,302 55% 1000-413-420141-153 HEALTH INSURANCE 31,212 55,808 24,596 44% 1000-413-420141-155 DETECTIVE -RETIREMENT 22,651 46,495 23,844 51% 1000-413-420142-110 SALARIES -RECORDS DIVISION 55,926 104,142 48,216 46% 1000-413-420142-121 OVERTIME 623 7,500 6,877 92% 1000-413-420142-153 HEALTH INSURANCE 8,512 14,600 6,088 42% 1000-413-420142-155 RETIREMENT 3,172 5,650 2,478 44% 1000-413-420144-110 SALARIES -SRO 57,897 124,909 67,012 54% 1000-413-420144-153 HEALTH INSURANCE 10,537 22,855 12,318 54% 1000-413-420144-155 SRO RETIREMENT 6,740 16,375 9,635 59% 1000-413-420145-110 ANIMAL CONTROL -SALARIES 23,423 43,680 20,257 46% 1000-413-420145-121 OVERTIME 86 0 86- 0% 1000-413-420145-153 HEALTH INSURANCE 6,041 10,360 4,319 42% 1000-413-420145-155 RETIREMENT 1,466 2,821 1,355 48% 1000-413-420147-110 PARKINGS -SALARIES 36,710 70,372 33,662 48% 1000-413-420147-153 HEALTH INSURANCE 15,826 25,915 10,089 39% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 7 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 1000-413-420147-155 RETIREMENT 2,352 4,546 2,194 48% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,616 4,000 2,384 60% 1000-413-420147-312 POSTAGE 0- 1,000 1,000 100% 1000-413-420147-354 CONTRACTED SERVICES 156 1,000 844 84% 1000-413-420147-362 LOT MAINT 4,157 6,500 2,343 36% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 368 6,000 5,632 94% 1000-413-420147-550 LOT LEASE PAYMENTS 714 1,350 636 47% SUBTOTAL POLICE DEPT. 1,987,359 3,842,845 1,855,486 48% THE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 8 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 666,360 1,538,837 872,477 57% 1000-416-420400-114 COMPTIME BUYOUT 3,702 5,000 1,298 26% 1000-416-420400-115 OUT OF RANK PAY 4,910 11,978 7,068 59% 1000-416-420400-121 OVERTIME 34,740 38,150 3,410 9% 1000-416-420400-153 HEALTH INSURANCE 133,501 301,638 168,137 56% 1000-416-420400-155 RETIREMENT 90,007 207,444 117,437 57% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 1,897 2,700 803 30% 1000-416-420400-218 Equipment (Non Capital) 1,957 7,500 5,543 74% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 7,716 15,000 7,284 49% 1000-416-420400-224 JANITORIAL SUPPLIES 1,623 2,500 877 35% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 15,245 15,000 245- -2% 1000-416-420400-320 PRINTING 46 700 654 93% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 1,298 1,250 48- -4% 1000-416-420400-345 TELEPHONE & COMMUNICATION 1,866 8,500 6,634 78% 1000-416-420400-354 CONTRACT SERVICES 7,500 8,000 500 6% 1000-416-420400-362 EQUIPMENT MAINTENANCE 1,082 5,500 4,418 80% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 2,648 2,500 148- -6% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 3,187 6,500 3,313 51% 1000-416-420400-373 DUES & TRAINING 7,502 10,000 2,498 25% 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 20,495 38,890 18,395 47% 1000-416-420440-121 OVERTIME 290 0 290- 0% 1000-416-420440-153 HEALTH INSURANCE 4,407 7,552 3,145 42% 1000-416-420440-155 RETIREMENT 1,299 2,538 1,239 49% SUBTOTAL FIRE DEPT. 1,046,582 2,304,295 1,257,713 55% GRAND TOTAL GENERAL FUND 4,846,166 9,755,532 4,909,366 50% ------------------------------------------------ ------------------------------------------------ 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 9 of 32 USER: RGW 50.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 1,200 1,200 0 0% 951 10,000 9,049 90% 4,668 9,335 4,667 50% 0 5,000 5,000 1000-0 4,893 100,000 95,107 95% 0 19,073 19,073 1000-0 0 2,530 2,530 1000-0 0 ------------ 1,240 ------------ 1,240 ------------------------ 1000-0 11,712 ------------ ------------ 148,378 ------------ ------------ 136,666 ------------------------ ------------------------ 92% 9,410 37,691 28,281 75% 1,404 6,079 4,675 77% 618 2,451 1,834 75% 1,250 1,250 0 00-0 5,000 5,000 0 00-0 486 2,000 1,514 76% 888 1,776 888 50% 0 500,000 500,000 1000-0 0 100,000 100,000 1000-0 32,000 32,000 0 00-0 ------------ 51,056 ------------ ------------ ------------ 688,247 ------------ ------------ ------------------------ 637,191 ------------------------ ------------------------ 93% 16,600 17,600 1,000 6% 10,939 10,000 939- -90-0 ------------ 27,539 ------------ ------------ ------------ 27,600 ------------ ------------ ------------------------ 61 ------------------------ ------------------------ 00-0 THE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 10 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 382,178 840,000 457,822 55% 2215-000-311200-000 PERSONAL PROPERTY TAXES 30,052 30,000 52- -0% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,987 3,500 1,513 43% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 1,600 5,000 3,400 68% 2215-000-346030-000 SWIMMING POOL FEES 102,157 140,000 37,843 27% 2215-000-346040-000 CONCESSION STAND REVENUE 27,868 32,500 4,632 14% 2215-000-346050-000 Parks Usage Fees 6,695 17,000 10,305 61% 2215-000-346051-000 RECREATION FEES 3,389 10,000 6,611 66% 2215-000-346052-000 SPORTS PROGRAMS 12,817 40,000 27,183 68% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 809 2,000 1,191 60% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 22,844 45,000 22,156 49% 2215-000-346055-000 ICE RINK 7,142 21,000 13,858 66% 2215-000-346057-000 YOUTH CAMPS 40,333 87,000 46,667 54% 2215-000-346059-000 PICNIC IN THE PARK 11,387 26,000 14,613 56% 2215-000-365010-000 DONATIONS/SALE OF MISC 1,649 1,800 151 8% 2215-000-371010-000 INVESTMENTS 742 0 742- 0% 2215-000-381050-000 INCEPTION OF LEASE 0 45,000 45,000 100% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 32,500 68,000 35,500 52% TOTAL PARKS & REC REVENUE 686,149 ------------ ------------ 1,413,800 ------------ ------------ 727,651 ----------------------- ----------------------- 51% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 137,652 274,988 137,336 50% 2215-436-460430-111 SEASONAL SALARIES 27,946 48,756 20,810 43% 2215-436-460430-121 OVERTIME 364 1,000 636 64% 2215-436-460430-153 HEALTH INSURANCE 34,972 68,808 33,836 49% 2215-436-460430-155 RETIREMENT 9,697 20,409 10,712 52% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 733 2,100 1,367 65% 2215-436-460430-224 JANITORIAL SUPPLIES 1,839 3,500 1,662 47% 2215-436-460430-229 OTHER SUPPLIES 1,492 4,500 3,008 67% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 417 2,500 2,083 83% 2215-436-460430-320 PRINTING & ADVERTISING 30 500 470 94% 2215-436-460430-341 ELECTRICITY 4,703 14,250 9,547 67% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 8,418 21,000 12,582 60% 2215-436-460430-344 NATURAL GAS 434 3,200 2,766 86% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,379 2,500 1,121 45% 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. 1,029 5,000 3,971 79% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 3,904 8,500 4,596 54% 2215-436-460430-364 LANDSCAPING 61 5,000 4,939 99% 2215-436-460430-367 VANDALISM REPAIRS 1,033 4,000 2,967 74% 2215-436-460430-373 DUES & TRAINING 3,546 2,700 846- -31% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 124 700 576 82% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 3,500 3,500 100% 2215-436-460430-440 IRRIGATION SUPPLIES 5,651 9,000 3,349 37% 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% 2215-436-460430-940 Capital Equipment 16,000 45,000 29,000 64% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 11 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % SUBTOTAL PARKS EXPENDITURES ------------ ------------ 262,431 574,754 ------------ ------------ 312,323 54% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 24,304 50,160 25,856 52% 2215-436-460440-111 SEASONAL SALARIES 22,921 43,256 20,335 47% 2215-436-460440-153 HEALTH INSURANCE 7,481 17,484 10,003 57% 2215-436-460440-155 RETIREMENT 2,532 4,406 1,874 43% 2215-436-460440-221 SAFETY EQUIPMENT 48 875 827 95% 2215-436-460440-229 OTHER SUPPLIES 5,523 16,000 10,477 65% 2215-436-460440-341 ELECTRICITY 5,086 7,000 1,914 27% 2215-436-460440-345 TELEPHONE & COMMUNICATION 0 300 300 1000-0 2215-436-460440-354 CONTRACT SERVICES 378 2,000 1,623 810-0 2215-436-460440-362 EQUIPMENT MAINTENANCE 664 700 36 5% 2215-436-460440-364 LANDSCAPING 90 500 410 82% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 1000-0 2215-436-460440-373 DUES & TRAINING 0 135 135 1000-0 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 1000-0 2215-436-460440-420 METAL PRODUCTS 0 2,900 2,900 1000-0 2215-436-460440-440 IRRIGATION 1,826 3,000 1,174 39% 2215-436-460440-452 SAND & GRAVEL 303 1,100 797 72% 2215-436-460440-610 DEBT SERVICE -PRINCIPAL 6,952 13,975 7,023 50% 2215-436-460440-620 DEBT SERVICE -INTEREST 357 675 318 47% 2215-436-460440-940 EQUIPMENT 0 14,500 14,500 1000-0 SUBTOTAL ATHLETIC COMPLEX ------------ ------------ 78,465 179,616 ------------ ------------ 101,151 56% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 43,452 88,080 44,628 51% 2215-436-460431-111 SEASONAL SALARIES 3,813 13,633 9,820 72% 2215-436-460431-153 HEALTH INSURANCE 13,124 22,538 9,414 42% 2215-436-460431-155 RETIREMENT 2,848 6,528 3,680 56% 2215-436-460431-218 DONATED SUPPLIES (donation FY11) 0 1,400 1,400 1000-0 2215-436-460431-229 MISC. SUPPLIES 3,698 10,000 6,302 63% 2215-436-460431-320 PRINTING & ADVERTISING 0 6,300 6,300 1000-0 2215-436-460431-345 TELEPHONE & COMMUNICATION 140 240 100 42% 2215-436-460431-354 CONTRACT SERVICES 14,868 18,000 3,132 17% 2215-436-460431-355 On Line Registration 0 3,000 3,000 1000-0 2215-436-460431-373 DUES & TRAINING 611 700 89 13% SUBTOTAL RECREATION ------------------------ 82,555 170,419 ------------------------ 87,864 52% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 32,777 65,971 33,194 50% 2215-436-460448-111 SEASONAL SALARIES 71,764 98,340 26,576 27% 2215-436-460448-121 OVERTIME 0 250 250 1000-0 2215-436-460448-153 HEALTH INSURANCE 12,449 21,378 8,929 42% 2215-436-460448-155 RETIREMENT 2,070 5,640 3,570 63% 2215-436-460448-229 MISC. SUPPLIES 2,895 3,850 955 25% 2215-436-460448-320 PRINTING & ADVERTISING 58 350 292 83% 2215-436-460448-345 TELEPHONE & COMMUNICATION 0 200 200 1000-0 2215-436-460448-354 CONTRACT SERVICES 9,700 11,800 2,100 180-0 2215-436-460448-355 AFTER SCHOOL PROGRAM 918 3,850 2,932 76% 2215-436-460448-356 BANK FEES/CC CHARGES 1,033 2,500 1,467 59% 2215-436-460448-373 DUES & TRAINING 0 ------------------------ 400 400 ------------------------ 1000-0 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 12 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % SUBTOTAL YOUTH CAMPS 133,664 214,529 80,865 38% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 136,533 198,139 61,606 31% 2215-437-460445-121 OVERTIME 1,534 1,200 334- -28% 2215-437-460445-155 RETIREMENT 849 1,000 151 15% 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,289 23,500 6,211 26% 2215-437-460445-228 CONCESSION STAND SUPPLIES 11,293 19,000 7,707 41% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 3,372 4,400 1,028 23% 2215-437-460445-341 ELECTRICITY 5,091 12,500 7,409 59% 2215-437-460445-344 NATURAL GAS 15,168 26,000 10,832 42% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 2,683 1,500 1,183- -79% 2215-437-460445-354 LICENSES & FEES 1,151 3,300 2,149 65% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 15,598 8,200 7,398- -900-0 2215-437-460445-380 TRAINING MATERIALS 0 500 500 1000-0 SUBTOTAL POOL EXPENDITURES ------------ 212,404 ------------ ------------ 303,339 ------------ ------------ ------------ 90,935 ------------------------ 30% TOTAL PARKS & RECREATION/POOL 769,518 1,442,657 673,139 47% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 13 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 300,759 605,000 304,241 50% 2230-000-342070-000 COUNTY EMS LEVY 55,968 85,000 29,032 34% 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC 1,205 0 1,205- 0% 2230-000-371010-000 INTEREST EARNINGS 78 1,000 922 92% TOTAL AMBULANCE REVENUE ------------ 358,010 ------------ ------------ ------------ 691,000 ------------ ------------ ------------ 332,990 ------------ ------------ ------------ 48% ------------ ------------ AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 176,746 371,169 194,423 52% 2230-440-420730-114 COMPTIME BUYBACK 797 3,000 2,203 73% 2230-440-420730-121 OVERTIME 6,561 19,147 12,586 66% 2230-440-420730-153 HEALTH INSURANCE 40,540 82,025 41,485 51% 2230-440-420730-155 RETIREMENT 23,029 48,915 25,886 53% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 346 1,000 654 65% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 454 2,500 2,046 82% 2230-440-420730-231 GAS & OIL 3,879 7,000 3,121 45% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 2,285 6,000 3,715 62% 2230-440-420730-312 POSTAGE/PRINTING 260 3,500 3,240 93% 2230-440-420730-345 TELEPHONE & COMMUNICATION 658 700 42 6% 2230-440-420730-354 PARAMEDIC RECERTIFICATION 1,240 7,000 5,760 82% 2230-440-420730-355 911 CENTER CONTRIBUTION 15,300 30,600 15,300 50% 2230-440-420730-359 AUDIT/CC OTHER FEES 891 1,400 509 36% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 1,126 7,000 5,874 84% 2230-440-420730-373 DUES & TRAINING 981 5,000 4,019 80% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 6,431 22,500 16,069 71% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 19,668 35,000 15,332 44% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 8,051 9,900 1,849 19% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 4,750 9,500 4,750 50% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 13,381 26,762 13,381 50% 2230-440-420730-528 DATA PROCESSING TRANSFER 5,330 11,287 5,957 53% TOTAL AMBULANCE EXPENDITURES ------------ 332,706 ------------ ------------ ------------ 710,905 ------------ ------------ ------------------------ 378,199 ------------------------ ------------------------ 53% 2310 OLD SCHOOL TIF - TECH 2310-480-470210-354 CONTRACT SERVICES - BOND COUNSEL 143 1,000 858 86% 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 ------------ 143 ------------ ------------ ------------ 53,928 ------------ ------------ ------------------------ 53,786 ------------------------ ------------------------ 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 375,000 728,239 353,239 49% TOTAL 2372 HEALTH LEVY ------------ 375,000 ------------ 728,239 ------------------------ 353,239 49% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 14 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING ------------------------------------------------ ------------------------------------------------ 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 70,302 200,000 129,698 65% 2394-000-323103-000 PLUMBING PERMITS 6,116 15,000 8,884 59% 2394-000-323104-000 MECHANICAL PERMITS 6,977 22,000 15,024 68% 2394-000-323107-000 HOUSE MOVING PERMITS 0 200 200 1000-0 2394-000-323108-000 PLAN REVIEW FEES 14,965 60,000 45,035 75% 2394-000-371010-000 INVESTMENT EARNINGS 1,362 1,000 362- -36% TOTAL REVENUE ------------ 99,721 ------------ ------------ ------------ 298,200 ------------ ------------ ------------------------ 198,479 ------------------------ ------------------------ 67% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 107,574 219,652 112,078 51% 2394-420-420530-121 OVERTIME 435 3,500 3,065 880-0 2394-420-420530-153 HEALTH INSURANCE 25,764 49,155 23,391 48% 2394-420-420530-155 RETIREMENT 6,807 13,561 6,754 50% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 12,460 4,750 7,710- -162% 2394-420-420530-231 GAS & OIL 790 2,250 1,460 65% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 297 2,600 2,304 890-0 2394-420-420530-323 ST. ED. ASSESSMENTS 0 2,500 2,500 1000-0 2394-420-420530-345 TELEPHONE & COMMUNICATION 1,213 1,500 287 190-0 2394-420-420530-353 AUDITING 0 500 500 1000-0 2394-420-420530-354 CONTRACT SERVICES 680 1,300 620 48% 2394-420-420530-373 DUES & TRAINING 784 3,400 2,616 77% 2394-420-420530-510 PROPERTY INSURANCE 4,087 4,100 13 00-0 2394-420-420530-521 CENTRAL GARAGE TRANSFER 650 1,300 650 50% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 4,597 9,194 4,597 50% 2394-420-420530-528 DATA PROCESSING TRANSFER 2,334 4,414 2,080 47% 2394-420-420530-930 Web based software package 4,660 20,000 15,340 77% TOTAL BUILDING DEPT. ------------ 173,131 ------------ ------------ ------------ 343,676 ------------ ------------ ------------------------ 170,545 ------------------------ ------------------------ 50% 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 19,221 38,893 19,672 51% 2400-410-430263-153 HEALTH INSURANCE 4,396 9,696 5,300 55% 2400-410-430263-155 RETIREMENT 1,212 2,391 1,179 49% 2400-410-430263-244 STREET LIGHT SUPPLIES 11,795 16,000 4,205 26% 2400-410-430263-341 ELECTRICITY 64,884 163,000 98,116 60% 2400-410-430263-360 REPAIR & MAINT SERVICES 7,281 20,000 12,719 64% 2400-410-430263-510 INSURANCE 883 1,075 192 180 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 15 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 2400-410-430263-522 ADMINISTRATIVE TRANSFER 4,382 8,763 4,381 50% 2400-410-430263-940 BOOM TRUCK 147 115,000 114,853 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. ------------ 114,201 ------------ ------------ ------------ 387,536 ------------ ------------ ------------ ------------ 273,335 ------------------------ ------------------------ 71% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 33,380 36,500 3,120 9% 2420-421-430234-957 ALLEY PAVING 49,305 45,000 4,305- -10% 2420-421-430240-231 GAS & OIL 12,571 38,000 25,429 67% 2420-421-430240-344 NATURAL GAS 0 3,500 3,500 100% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 97,881 300,400 202,519 67% 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 19,574 47,000 27,426 58% 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 ------------ 328,677 ------------ ------------ ------------ 732,855 ------------ ------------ ------------------------ 404,178 ------------------------ ------------------------ 55% THE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 16 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 281,713 570,667 288,954 51% 2500-421-430240-112 RETIREMENT -severance 24,431 25,000 569 2% 2500-421-430240-121 OVERTIME 6,722 30,000 23,278 78% 2500-421-430240-153 HEALTH INSURANCE 79,369 157,384 78,015 50% 2500-421-430240-155 RETIREMENT 18,427 35,393 16,966 48% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 631 5,000 4,369 87% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,435 10,200 8,765 86% 2500-421-430240-220 OTHER SUPPLIES 488 4,100 3,612 88% 2500-421-430240-231 GAS & OIL 12,688 42,000 29,312 70% 2500-421-430240-341 ELECTRICITY 376 1,400 1,024 73% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 604 1,000 396 40% 2500-421-430240-354 CONTRACT SERVICES 2,283 15,000 12,717 85% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 3,338 28,000 24,662 88% 2500-421-430240-366 BUILDING MAINTENANCE 1,065 4,000 2,935 73% 2500-421-430240-373 DUES & TRAINING 1,468 3,500 2,032 58% 2500-421-430240-388 MEDICAL SERVICES 150 1,100 950 86% 2500-421-430240-510 LIABILITY INSURANCE 81,010 87,000 5,990 7% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 4,385 10,000 5,615 56% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 35,000 70,000 35,000 50% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 33,710 67,420 33,710 50% 2500-421-430240-528 DATA PROCESSING TRANSFER 6,091 12,182 6,091 50% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 4,513 41,975 37,462 89% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 400 4,144 3,744 90% 2500-421-430240-840 MAGI GRANT MATCH 0 75,000 75,000 100% 2500-421-430240-940 MACHINERY & EQUIPMENT 168 195,000 194,832 100% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 194,859 530,000 335,141 63% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 9,189 31,041 21,852 70% 2500-421-430264-110 TSS - SALARIES 65,113 132,645 67,532 51% 2500-421-430264-121 OVERTIME 4,403 9,500 5,097 54% 2500-421-430264-153 HEALTH INSURANCE 10,640 18,270 7,630 42% 2500-421-430264-155 RETIREMENT 4,270 8,902 4,632 52% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 221 1,500 1,279 85% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 2,080 4,500 2,420 54% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 2,128 3,500 1,372 39% 2500-421-430264-242 STREET SIGNS 24,335 44,000 19,665 45% 2500-421-430264-243 TRAFFIC SIGNALS 7,204 33,500 26,296 79% 2500-421-430264-245 BARRICADE MATERIALS 0 4,700 4,700 100% 2500-421-430264-341 ELECTRICITY 841 8,500 7,659 90% 2500-421-430264-345 COMMUNICATIONS 320 750 430 57% 2500-421-430264-354 CONTRACT SERVICES 1,002 15,000 13,998 93% 2500-421-430264-362 EQUIPMENT MAINTENANCE 439 3,000 2,561 85% 2500-421-430264-366 BUILDING MAINTENANCE 0 2,000 2,000 100% 2500-421-430264-373 DUES & TRAINING 1,822 4,000 2,178 54% 2500-421-430264-428 PAINT MATERIALS 381 9,000 8,619 96% 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. 937,396 2,375,311 1,437,915 61% ------------------------------------------------ ------------------------------------------------ THE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 17 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 57,038 147,097 90,059 61% 2600-436-460433-121 OVERTIME 134 500 366 73% 2600-436-460433-153 HEALTH INSURANCE 15,509 42,252 26,743 63% 2600-436-460433-155 RETIREMENT 3,627 9,204 5,577 61% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 34 550 516 94% 2600-436-460433-241 CONSUMABLE TOOLS 1,349 1,450 101 7% 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 555 7,500 6,945 93% 2600-436-460433-373 DUES & TRAINING 195 800 605 76% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 3,766 3,500 266- -8% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 1,500 3,000 1,500 50% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 4,349 8,610 4,262 49% 2600-436-460433-528 DATA PROCESSING TRANSFER 746 1,411 665 47% 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 92,014 ------------ ------------ 256,024 ------------ ------------ 164,010 ------------------------ ------------------------ 64% 2601 DEVELOPER TREES 2601-436-460435-351 EMPIRE ESTATES ($44,911) 295 8,948 8,653 97% 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 100% 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 0 1,546 1,546 100% 2601-436-460435-354 CONTRACT SERVICES 0 185 185 100% 2601-436-460435-356 SINOPAH SUBD ($5,790) 0 667 667 100% 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 335 2,883 2,548 88% 2601-436-460435-358 WEST VIEW SUBD ($22,680) 295 17,831 17,536 98% 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 295 31,209 30,914 99% 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 2601 DEVELOPER TREES 1,220 ------------ ------------ 94,905 ------------ ------------ 93,685 ------------------------ ------------------------ 99% 2825 MAGI GRANT -SWEEPER 2825-421-430240-940 STREET SWEEPER 27,379 574,373 546,994 95% TOTAL 2825 MAGI GRANT 27,379 574,373 546,994 95% ------------------------------------------------ ------------------------------------------------ 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 18 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470240-711 IRP LOAN PROGRAM MATCH 17 350,000 349,983 100% ------------------------------------------------ TOTAL LOAN REVOLVING 17 350,000 349,983 100% ------------------------------------------------ ------------------------------------------------ 2886 CD OPERATIONS FUND 2886-480-470210-110 SALARIES - UDAG 19,135 57,933 38,798 67% 2886-480-470210-153 HEALTH INSURANCE 2,852 7,634 4,782 63% 2886-480-470210-155 RETIREMENT 1,254 3,734 2,480 66% 2886-480-470210-210 OFFICE SUPPLIES 1,558 1,500 58- -4% 2886-480-470210-211 GRANT ADMIN. & PROJ. EXPENSES 0 2,000 2,000 100% 2886-480-470210-312 POSTAGE & PRINTING 55 2,000 1,945 97% 2886-480-470210-334 MT WEST MEMBERSHIP 500 500 0 0% 2886-480-470210-345 TELEPHONE & COMMUNICATION 222 400 178 44% 2886-480-470210-353 AUDITING 1,500 1,500 0 0% 2886-480-470210-354 CONTRACT SERVICES 216 1,000 784 78% 2886-480-470210-355 PROSPECT DEVELOPMENT 0 3,000 3,000 100% 2886-480-470210-373 DUES & TRAINING 1,465 3,800 2,335 61% 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 1,980 3,961 1,981 50% 2886-480-470210-528 DATA PROCESSING TRANSFER 1,523 3,046 1,523 50% 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 ------------ ------------ 36,972 ------------ 175,703 ------------ ------------ ------------------------ 138,731 ------------------------ ------------------------ 79% 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 17,559 18,000 441 2% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 4,515 4,600 85 2% 2887-480-470210-750 REDEVELOPMENT LOANS 34,742 75,000 40,258 54% ------------ TOTAL RURAL DEVELOPMENT #1 ------------ ------------ 56,816 ------------ 97,600 ------------ ------------ ------------------------ 40,784 ------------------------ ------------------------ 42% 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 7,826 8,050 224 3% 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-03 2,199 2,200 1 0% 2888-480-470210-750 REDEVELOPMENT LOANS 0 100,000 100,000 100% ------------ TOTAL RURAL DEVELOPMENT #2 ------------ ------------ 10,025 ------------ 110,250 ------------ ------------ ------------------------ 100,225 ------------------------ ------------------------ 91% 2945 CDBG-ED FVCC #2 2945-480-470242-790 MACHINERY/EQUIPMENT 60,727 60,727 0- 0% 2945-480-470242-820 ADMIN TRANSFER -to Com. Development 1,157 5,392 4,235 79% ------------ TOTAL 2945 CDBG-ED FVCC #2 ------------ ------------ 61,884 ------------ 66,119 ------------ ------------ ------------------------ 4,235 ------------------------ ------------------------ 6% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 19 of 32 USER: RGW 50.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 374 1,000 626 63% 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 20,001 75,186 55,185 73% 2954-480-470210-373 TRAVEL-AWP GRT 739 5,000 4,261 85% TOTAL 2954 EPA/BROWNFIELD PLAN ------------ 29,862 ------------ ------------ ------------ 121,186 ------------ ------------ ------------------------ 91,324 ------------------------ ------------------------ 75% 2955 BROWNFIELD LOAN REVOLVING 2955-480-470210-229 SUPPLIES -PETROLEUM 42 950 908 96% 2955-480-470210-352 PERSONNEL -PETROLEUM 223 16,942 16,719 99% 2955-480-470210-353 FRINGES -PETROLEUM 98 5,050 4,952 98% 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 42 2,500 2,458 98% 2955-480-470215-352 PERSONNEL -HAZARDOUS SUBSTANCES 223 47,780 47,557 100% 2955-480-470215-353 FRINGES -HAZARDOUS SUBSTANCES 98 14,306 14,208 99% 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 ------------ 726 ------------ ------------ ------------ 999,318 ------------ ------------ ------------------------ 998,592 ------------------------ ------------------------ 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 28,406 55,580 27,174 49% 2916-413-420140-121 OVERTIME 2,001 6,000 3,999 67% 2916-413-420140-153 HEALTH INSURANCE 3,950 10,098 6,148 61% 2916-413-420140-155 RETIREMENT 3,592 7,475 3,883 52% 2916-413-420140-354 CONTRACT SERVICES 2,401 5,200 2,799 54% TOTAL 2916 DRUG ENFORCEMENT ------------ 40,350 ------------ ------------ ------------ 84,353 ------------ ------------ ------------------------ 44,003 ------------------------ ------------------------ 52% 2917 COPS TECHNOLOGY GRANT 2917-413-420140-950 SHOOTING FACILITY/2009CKWX0478 0 750,000 750,000 100% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 20 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % TOTAL 2917 COPS TECHNOLOGY GT ------------ ------------ 0 ------------------------ ------------------------ 750,000 ------------ ------------ 750,000 ------------------------ ------------------------ 1000-0 2918 COPS HIRING RECOVERY GT 2918-413-420140-110 SALARIES & PAYROLL COSTS 26,469 51,963 25,494 49% 2918-413-420140-153 HEALTH INSURANCE 9,072 15,555 6,483 42% 2918-413-420140-155 RETIREMENT 3,532 6,987 3,455 49% TOTAL 2918 COPS HIRING GRANT ------------------------ 39,073 ------------------------ ------------------------ 74,505 ------------------------ 35,432 ------------------------ ------------------------ 48% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 1,346 1,200 146- -12% 2919-413-420140-125 DUI TASK FORCE 458 8,000 7,542 94% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 12,195 48,800 36,605 75% 2919-413-420140-127 SCHOOL DIST. OT 8,011 20,000 11,989 60% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 0 2,500 2,500 1000-0 2919-413-420140-221 Bullet Proof Vests 0 10,000 10,000 1000-0 2919-413-420140-940 EQUIPMENT (Radio Grant) 16,438 16,360 78- -00-0 TOTAL LAW ENF. GRANT ------------ ------------ 38,448 ------------------------ ------------------------ 106,860 ------------ ------------ 68,412 ------------------------ ------------------------ 64% 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 2957-416-420400-155 RETIREMENT 2957-416-420400-218 EQUIPMENT (non capital) 16,091 211,667 195,576 92% ------------ 16,091 ------------ ------------ ------------ 211,667 ------------ ------------ ------------------------ 195,576 ------------------------ ------------------------ 92% 22,315 130,462 108,147 83% 677 2,000 1,323 66% 30,392 37,955 7,563 20% ------------ 53,384 ------------ ------------ ------------ 170,417 ------------ ------------ ------------------------ 117,033 ------------------------ ------------------------ 69% 250 29,514 29,264 990-0 ------------ 250 ------------ ------------ ------------ 29,514 ------------ ------------ ------------------------ 29,264 ------------------------ ------------------------ 990-0 0 4,500 4,500 1000-0 0 6,500 6,500 1000-0 0 2,500 2,500 1000-0 ------------ 0 ------------ ------------ ------------ 13,500 ------------ ------------ ------------------------ 13,500 ------------------------ ------------------------ 1000-0 405 0 405- 00-0 0 4,523 4,523 1000-0 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 21 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 2957-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 0 6,000 6,000 100% 2957-416-420410-125 PASS THRU HAZMAT OT 3,322 20,000 16,678 83% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 1,370 55,054 53,684 98% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 5,000 5,000 100% 2957-416-420414-218 AFG-FIRE PREV MAT-EMW2010FP00286 46 155,000 154,954 100% TOTAL FIRE GRANTS ------------ 5,143 ------------ ------------ ------------ 245,577 ------------ ------------ ------------ 240,434 ------------ ------------ ------------ 98% ------------ ------------ 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 4345 "WILLOWS" STORM PROJECT 4345-453-430246-950 THE WILLOWS PROJECT 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% 70,734 90,000 19,266 21% 21,341 25,000 3,659 15% 9,589 12,204 2,615 21% ------------ 101,664 ------------ ------------ ------------ 127,204 ------------ ------------ ------------------------ 25,540 ------------------------ ------------------------ 20% 7,123 7,500 377 5% ------------ 7,123 ------------ ------------ ------------ 7,500 ------------ ------------ ------------------------ 377 ------------------------ ------------------------ 5% 209,435 190,324 19,111- -10% 109,568 129,568 20,000 15% ------------ 319,003 ------------ ------------ ------------ 319,892 ------------ ------------ ------------------------ 889 ------------------------ ------------------------ 0% 3,792 25,000 21,208 85% ------------ 3,792 ------------ ------------ ------------ 25,000 ------------ ------------ ------------------------ 21,208 ------------------------ ------------------------ 85% 0 ------------ 392,556 ------------ 392,556 ------------------------ 100% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 22 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % TOTAL "WILLOWS" PROJECT 0 ------------------------ ------------------------ 392,556 392,556 ------------------------ ------------------------ 1000-0 4312 FAA PLANNING GRANT 4312-430-430310-354 ENVIRONMENTAL ASSESSMENT 0 45,000 45,000 1000-0 4312-430-430310-940 CAPITAL IMPROVEMENTS 4,675 258 4,417- -1,712% TOTAL FAA PLANNING GRANT ------------------------ 4,675 ------------------------ ------------------------ 45,258 ------------------------ 40,583 ------------------------ ------------------------ 900 THE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 23 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING ENTERPRISE FUNDS WATER REVENUE 5210-000-343210-000 METERED WATER SALES 1,590,939 2,600,000 1,009,061 39% 5210-000-343220-000 UNMETERED WATER SALES 8,694 4,000 4,694- -117% 5210-000-343225-000 IMPACT FEES 101,800 225,000 123,200 55% 5210-000-343230-000 METER REPLACEMENT FEE 48,648 95,000 46,352 49% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 13,847 24,000 10,153 42% 5210-000-343265-000 IMPACT ADMIN FEES 0 13,000 13,000 100% 5210-000-343270-000 WATER TURN ON FEES 1,115 2,500 1,385 55% 5210-000-343275-000 TAG FEE 8,280 9,500 1,220 13% 5210-000-343365-000 LATECOMER ADMIN FEE 24 0 24- 0% 5210-000-371010-000 INVESTMENT EARNINGS 19,565 50,000 30,435 61% TOTAL WATER REVENUE 1,792,912 ------------ ------------ 3,023,000 ------------ ------------ 1,230,088 ----------------------- ----------------------- 41% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 299,902 664,243 364,341 55% 5210-447-430550-111 SEASONAL SALARIES 2,219 5,000 2,781 56% 5210-447-430550-112 SALARIES -RETIREMENT 3,665 35,000 31,335 90% 5210-447-430550-121 OVERTIME 7,456 20,000 12,544 63% 5210-447-430550-153 HEALTH INSURANCE 74,658 155,841 81,183 52% 5210-447-430550-155 RETIREMENT 19,126 44,321 25,195 57% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 5,578 10,000 4,422 44% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 2,741 9,500 6,759 71% 5210-447-430550-226 CHLORINE & CHEMICALS 19,295 38,000 18,705 49% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 1,654 4,800 3,146 66% 5210-447-430550-231 GAS & OIL 15,554 35,000 19,446 56% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 57 4,500 4,443 99% 5210-447-430550-336 LICENSES & FEES 190 19,000 18,810 99% 5210-447-430550-341 ELECTRICITY 62,306 143,000 80,694 56% 5210-447-430550-344 NATURAL GAS 2,349 13,000 10,651 82% 5210-447-430550-345 TELEPHONE & COMMUNICATION 3,606 8,000 4,394 55% 5210-447-430550-349 LAB SERVICES 5,715 22,500 16,785 75% 5210-447-430550-353 AUDITING 3,000 3,000 0 0% 5210-447-430550-354 CONTRACT SERVICES 12,965 55,000 42,035 76% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 8,464 25,000 16,536 66% 5210-447-430550-357 PLANS/STUDIES/REVIEWS 5,646 6,500 854 13% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 6,143 14,950 8,807 59% 5210-447-430550-366 BUILDING MAINTENANCE 66 17,000 16,934 100% 5210-447-430550-373 DUES & TRAINING 2,638 9,200 6,562 71% 5210-447-430550-388 MEDICAL SERVICES 125 700 576 82% 5210-447-430550-410 CONSTRUCTION MATERIALS 20,907 32,000 11,093 35% 5210-447-430550-411 Meter Pit - Materials 0 6,500 6,500 100% 5210-447-430550-422 HYDRANTS 5,434 10,000 4,567 46% 5210-447-430550-423 MATERIALS FOR MAINS 3,425 11,000 7,575 69% 5210-447-430550-424 MATERIALS -SERVICE LINES 7,273 11,000 3,727 34% 5210-447-430550-425 MATERIALS PUMPS/WELLS 3,349 30,000 26,651 89% 5210-447-430550-510 PROPERTY & LIABILITY INS. 33,367 36,500 3,133 9% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 15,000 24,000 9,000 38% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 4,000 8,000 4,000 50% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 48,412 96,825 48,413 50% 5210-447-430550-528 DATA PROCESSING TRANSFER 12,182 21,172 8,990 42% 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 4,323 7,838 3,515 45% 5210-447-430550-935 ARMORY WELL GENERATOR REPLACEMENT 62,058 90,000 27,942 31% 5210-447-430550-936 Noffsinger Spring Generator 0 90,000 90,000 100% THE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 24 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 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 13,994 76,500 62,506 82% 5210-447-430550-941 UTILITY ASSET MGMT PROGRAM 32,003 34,000 1,998 6% 5210-447-430550-948 METERS (METER FUNDS) 010125 43,550 130,000 86,450 67% 5210-447-430550-951 SECURITY SYSTEM UPGRADES 63 25,861 25,798 100% 5210-447-430550-958 1ST AVE EN WATER MAIN 211,887 340,000 128,113 38% 5210-447-430550-962 S WOODLAND WTR SYS IMPROVEMENTS 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 COLORADO WATER MAIN 20,000 20,000 0 0% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 50,000 50,000 100% 5210-447-430555-941 METERS (NEW SERVICES)010120 21,630 65,000 43,370 67% 5210-447-430555-953 SECTION 36 WELL 0 43,000 43,000 100% SUBTOTAL WATER FACILITIES 1,127,974 3,363,151 2,235,177 66% ----------------------------------------------- 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 37,769 82,942 45,173 54% 9,245 22,343 13,098 59% 2,434 5,481 3,047 56% 141 3,000 2,859 95% 1,500 1,500 0 0% 1,073 4,000 2,927 73% 13,606 35,000 21,394 61% 258 1,500 1,243 83% 3,551 7,103 3,552 50% 12,182 24,365 12,183 50% 3,919 7,838 3,919 50% ------------ 85,678 ------------ ------------ 195,072 ------------ ------------------------ 109,394 ------------------------ 56% 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% 1,305,824 ------------ ------------ 4,849,282 ------------ ------------ 3,543,458 ------------------------ ------------------------ 73% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 25 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING SEWER REVENUE: 5310-000-343310-000 SEWER SERVICE CHARGES 2,114,948 4,115,000 2,000,052 49% 5310-000-343330-000 IMPACT FEES (SANITARY) 95,399 92,000 3,399- -4% 5310-000-343335-000 IMPACT FEES (WWTP) 128,646 124,000 4,646- -4% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 7,222 2,000 5,222- -261% 5310-000-343365-000 LATECOMER ADMIN FEES 16 0 16- 0% 5310-000-371010-000 INVESTMENT EARNINGS 22,578 45,000 22,422 50% TOTAL SEWER REVENUE 2,368,810 ------------ ------------ 4,378,000 ------------ ------------ 2,009,190 ------------------------ ------------------------ 46% SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 32,261 67,647 35,386 52% 5310-454-430620-153 HEALTH INSURANCE 7,316 20,675 13,359 65% 5310-454-430620-155 RETIREMENT 2,075 4,329 2,254 52% 5310-454-430620-215 OFFICE SUPPLIES/computers 141 3,000 2,859 95% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 1,500 4,000 2,500 63% 5310-454-430620-355 BILLING COSTS 14,678 35,000 20,322 58% 5310-454-430620-373 DUES & TRAINING 0 1,500 1,500 100% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 3,186 6,373 3,187 50% 5310-454-430620-528 DATA PROCESSING TRANSFER 12,182 24,365 12,183 50% 5310-454-430620-532 OFFICE RENT 3,919 7,838 3,919 50% SUBTOTAL SEWER BILLING COSTS ------------ 77,259 ------------ ------------ 174,727 ------------ ------------------------ 97,468 ------------------------ 56% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 106,495 233,868 127,373 54% 5310-454-430630-112 SALARIES-SEVERANCE/RETIREMENT 1,038 2,500 1,462 58% 5310-454-430630-121 OVERTIME 585 7,500 6,915 92% 5310-454-430630-153 HEALTH INSURANCE 30,138 53,882 23,744 44% 5310-454-430630-155 RETIREMENT 6,725 14,593 7,868 54% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2,278 6,200 3,922 63% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 1,159 9,500 8,341 88% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 357 2,000 1,643 82% 5310-454-430630-231 GAS & OIL 3,857 9,500 5,643 59% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 139 300 161 54% 5310-454-430630-341 ELECTRICITY 17,595 48,500 30,905 64% 5310-454-430630-344 NATURAL GAS 4,779 13,500 8,721 65% 5310-454-430630-345 TELEPHONE & COMMUNICATION 9,295 21,700 12,405 57% 5310-454-430630-353 AUDITING 2,000 2,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 5,617 21,000 15,383 73% 5310-454-430630-356 CONSULTANTS 0 7,500 7,500 100% 5310-454-430630-357 IMPACT FEE REVIEW/STUDY 5,646 6,500 854 13% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 350 6,800 6,450 95% 5310-454-430630-373 DUES & TRAINING 490 2,500 2,011 80% 5310-454-430630-388 MEDICAL SERVICES 99 800 701 88% 5310-454-430630-410 CONSTRUCTION MATERIALS 3,412 9,000 5,588 62% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 11,744 20,000 8,256 41% 5310-454-430630-510 PROPERTY & LIABILITY INS. 82,706 73,700 9,006- -12% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 1,203 16,000 14,797 92% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 1,250 2,500 1,250 50% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 30,767 61,533 30,767 50% 5310-454-430630-528 DATA PROCESSING TRANSFER 8,375 16,751 8,376 50% 5310-454-430630-532 OFFICE RENT 3,919 7,838 3,919 50% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 26 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 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 ------------ 342,016 ------------ ------------ 739,965 ------------ ------------ 397,949 ------------ ------------ 54% ------------ 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% 366,783 ------------ 1,911,465 ------------ 1,544,682 ------------------------ 81% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 164,883 346,972 182,089 52% 5310-455-430640-111 SEASONAL SALARIES 2,219 5,000 2,782 56% 5310-455-430640-121 OVERTIME 9,245 21,000 11,755 56% 5310-455-430640-153 HEALTH INSURANCE 34,855 61,570 26,715 43% 5310-455-430640-155 RETIREMENT 10,899 21,473 10,574 49% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2,218 5,000 2,782 56% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 1,079 2,500 1,421 57% 5310-455-430640-225 ALUM 0 25,000 25,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 9,390 12,000 2,610 22% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 2,454 7,000 4,546 65% 5310-455-430640-231 GAS & OIL 3,608 15,000 11,392 76% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 85 350 265 76% 5310-455-430640-336 LICENSES & FEES 187 11,000 10,814 98% 5310-455-430640-341 ELECTRICITY 64,532 170,000 105,468 62% 5310-455-430640-342 WATER 2,289 6,000 3,711 62% 5310-455-430640-344 NATURAL GAS 9,472 55,000 45,528 83% 5310-455-430640-345 TELEPHONE & COMMUNICATION 1,984 5,500 3,516 64% 5310-455-430640-353 AUDITING 2,500 2,750 250 9% 5310-455-430640-354 CONTRACT -GLACIER GOLD 53,264 118,000 64,736 55% 5310-455-430640-355 OTHER CONTRACT SERVICES 12,872 30,000 17,128 57% 5310-455-430640-356 CONSULTANTS 1,030 35,000 33,970 97% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 5310-455-430640-360 MISC. MAINT SERVICES 6,249 28,000 21,751 78% 5310-455-430640-366 BUILDING MAINTENANCE 925 3,000 2,075 69% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 27 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 5310-455-430640-373 DUES & TRAINING 2,338 8,500 6,162 73% 5310-455-430640-388 MEDICAL SERVICES 362 550 189 34% 5310-455-430640-510 PROPERTY & LIABILITY INS. 43,575 46,750 3,175 7% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 2,750 5,500 2,750 50% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 63,367 126,734 63,367 50% 5310-455-430640-528 DATA PROCESSING TRANSFER 10,449 20,899 10,450 50% 5310-455-430640-920 BUILDINGS 0 110,000 110,000 100% SUBTOTAL WWTP OPERATIONS 519,080 1,321,048 801,968 61% ----------------------------------------------- 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 SUBTOTAL WWTP REPLACEMENT WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 5310-455-430646-153 HEALTH INSURANCE 5310-455-430646-155 RETIREMENT 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 5310-455-430646-218 NON -CAPITAL EQUIPMENT 5310-455-430646-222 LAB SUPPLIES 5310-455-430646-349 LAB SERVICES 5310-455-430646-362 EQUIPMENT MAINTENANCE 5310-455-430646-373 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 5310-455-490227-610 5310-455-490227-620 5310-455-490227-630 SUBTOTAL SRF LOAN/WWTP DEBT SERVICE 2007 SRF SRF 2007WWTP PRINCIPAL SRF 2007WWTP INTEREST FISCAL AGENT FEES SUBTOTAL SRF 2007 SUBTOTAL WWTP DEBT CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 5310-455-510400-831 DEPRECIATION EXPENSE 0 865,000 865,000 100% ------------ 0 ------------ ------------ 865,000 ------------ ------------------------ 865,000 ------------------------ 100% 3,989 70,000 66,011 94% 0 560,000 560,000 100% 55,694 101,948 46,254 45% ------------ 59,683 ------------ ------------ 731,948 ------------ ------------------------ 672,265 ------------------------ 92% 58,159 115,328 57,169 50% 11,010 18,912 7,902 42% 3,619 7,147 3,528 49% 304 7,350 7,046 96% 336 3,000 2,664 89% 3,686 7,500 3,814 51% 4,281 20,000 15,720 79% 1,370 3,500 2,130 61% 680 2,700 2,020 75% ------------ 83,445 ------------ 185,437 ------------------------ 101,992 55% 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% 0 411,599 411,599 100% 0 1,425,000 1,425,000 100% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 28 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ------------------------------------------------ SUTOTAL WWTP DEPRECIATION/REPL 0 1,836,599 1,836,599 1000-0 ------------ ------------ ------------ ------------ SUBTOTAL WWTP 992,249 6,037,370 5,045,121 84% ------------------------------------------------ TOTAL BILLING/SANITARY/WWTP 1,436,290 8,123,562 6,687,272 82% ------------------------------------------------ ------------------------------------------------ 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 29 of 32 USER: RGW 50.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 69,502 52,500 17,002- -32% 5349-000-343034-000 PERMIT FEES 405 0 405- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 420 420 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 821,519 820,000 1,519- -0% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,903 5,000 2,097 42% 5349-000-371010-000 INTEREST ON INVESTMENTS 10,626 22,000 11,374 52% TOTAL STORM REVENUE 912,442 ------------ ------------ 902,335 ------------ ------------ 10,107- ------------------------ ------------------------ -1% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 144,420 324,215 179,795 55% 5349-453-430246-112 SEVERANCE 1,038 2,500 1,462 58% 5349-453-430246-121 OVERTIME 833 5,000 4,167 83% 5349-453-430246-153 HEALTH INSURANCE 37,880 70,795 32,915 46% 5349-453-430246-155 RETIREMENT 9,145 20,441 11,296 55% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 3,761 9,100 5,339 59% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 308 3,500 3,192 91% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 35 2,200 2,165 98% 5349-453-430246-231 GAS & OIL 3,880 10,500 6,620 63% 5349-453-430246-345 TELEPHONE & COMMUNICATION 162 950 788 83% 5349-453-430246-353 AUDITING 600 600 0 0% 5349-453-430246-354 CONTRACT SERVICE 438 6,200 5,762 93% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 632 30,000 29,369 98% 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 627 3,500 2,873 82% 5349-453-430246-388 MEDICAL SERVICES 0 200 200 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 1,216 10,000 8,784 88% 5349-453-430246-510 PROPERTY & LIABILITY INS. 7,345 13,500 6,155 46% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 1,500 3,000 1,500 50% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 16,352 32,704 16,352 50% 5349-453-430246-528 DATA PROCESSING TRANSFER 2,985 5,969 2,984 50% 5349-453-430246-530 BNSF LEASE PMT 5,066 5,200 134 3% 5349-453-430246-532 OFFICE RENT 3,919 7,838 3,919 50% 5349-453-430246-941 UTILITY ASSET MANAGEMENT PROGRAM 11,803 38,738 26,936 70% 5349-453-430246-944 VEHICLES 0 123,500 123,500 100% 5349-453-430246-952 STORM DRAIN CORRECTION 33,148 100,000 66,852 67% 5349-453-430246-953 WILLOWS CORRECTION 0 156,000 156,000 100% 5349-453-430246-954 S MEADOWS SURVEY 686,062 706,125 20,063 3% 5349-453-430248-953 WILLOWS UPSIZE 0 44,000 44,000 100% 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 ------------ 973,742 ------------ ------------ ------------ 2,306,275 ------------ ------------ ------------------------ 1,332,533 ------------------------ ------------------------ 58% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 30 of 32 USER: RGW 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 871,608 843,000 28,608- -3% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 19,472 15,000 4,472- -30% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 3,514 5,500 1,986 36% 5510-000-371010-000 INVESTMENT EARNINGS 2,764 5,000 2,236 45% TOTAL SOLID WASTE REVENUE ------------ 897,358 ------------ ------------ ------------ 868,500 ------------ ------------ ------------ 28,858- ------------ ------------ ------------ -3% ------------ ------------ SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 164,307 355,935 191,628 54% 5510-460-430840-112 SEVERANCE -RETIREMENT 18,689 12,500 6,189- -50% 5510-460-430840-121 OVERTIME 2,545 5,000 2,455 49% 5510-460-430840-153 HEALTH INSURANCE 47,754 85,902 38,148 44% 5510-460-430840-155 RETIREMENT 10,783 22,084 11,301 51% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,210 3,500 2,290 65% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 2,820 20,000 17,180 86% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 708 5,500 4,792 87% 5510-460-430840-231 GAS & OIL 17,070 50,000 32,930 66% 5510-460-430840-341 ELECTRICITY 490 1,700 1,210 71% 5510-460-430840-344 NATURAL GAS 547 4,000 3,453 86% 5510-460-430840-345 TELEPHONE & COMMUNICATION 358 700 342 49% 5510-460-430840-354 CONTRACT SERVICES 5,070 12,000 6,930 58% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 3,808 5,700 1,892 33% 5510-460-430840-366 BUILDING MAINTENANCE 0 2,500 2,500 100% 5510-460-430840-373 DUES & TRAINING 1,166 2,500 1,335 53% 5510-460-430840-388 MEDICAL SERVICES 354 500 146 29% 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 14,250 28,500 14,250 50% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 13,876 27,753 13,877 50% 5510-460-430840-528 DATA PROCESSING TRANSFER 3,807 7,614 3,807 50% 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 1,354 3,200 1,846 58% 5510-460-430845-342 WATER 263 500 237 47% 5510-460-430845-344 NATURAL GAS 1,190 8,500 7,310 86% 5510-460-430845-360 REPAIR & MAINT SERVICES 3,158 2,500 658- -26% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% TOTAL SOLID WASTE EXPENSE ------------ 333,160 ------------ ------------ ------------ 890,626 ------------ ------------ ------------------------ 557,466 ------------------------ ------------------------ 63% THE CITY OF KALISPELL, MONTANA 01.23.2013 15:38 Page 31 of 32 gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT USER: RGw 50.00 % Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 5,565 9,400 3,835 41% 5160-000-343063-000 TIE DOWN FEES 1,051 3,500 2,449 70% 5160-000-343069-000 HANGER LEASES 6,000 12,000 6,000 50% 5160-000-343071-000 HANGAR SITE LEASES 16,999 16,500 499- -3% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 8,650 17,340 8,690 50% 5160-000-343102-000 GROUND LEASES 11,727 11,726 1- -0% 5160-000-343620-000 FUEL TAX 3,855 5,500 1,645 30% 5160-000-371010-000 INVESTMENT EARNINGS 802 3,000 2,198 73% TOTAL AIRPORT REVENUE ------------ 54,648 ------------ ------------ ------------ 78,966 ------------ ------------ ------------ 24,318 ------------ ------------ ------------ 31% ------------ ------------ 5160 AIRPORT EXPENSES 5160-430-430310-110 SALARIES 5160-430-430310-111 SEASONAL SALARIES 5160-430-430310-153 HEALTH INSURANCE 5160-430-430310-155 RETIREMENT 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 5160-430-430310-341 ELECTRICITY 5160-430-430310-345 TELEPHONE 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 5160-430-430310-355 ELECTION 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 5160-430-430310-357 CONTRACT SERVICES - legal 5160-430-430310-362 REPAIR & MAINTENANCE 5160-430-430310-373 DUES & TRAINING 5160-430-430310-390 EQUIPMENT RENTAL 5160-430-430310-510 PROPERTY INSURANCE 5160-430-430310-522 ADMINISTRATIVE TRANSFER 5160-430-430310-528 DATA PROCESSING TRANSFER 5160-430-430310-820 DEPRECIATION 5160-430-430310-950 CONSTRUCTION IN PROGRESS TOTAL AIRPORT EXPENSES 14,857 35,108 20,251 58% 1,035 3,258 2,223 68% 3,843 7,308 3,465 47% 1,032 2,497 1,465 59% 285 1,150 865 75% 656 1,500 844 56% 379 850 471 55% 2,658 4,000 1,342 34% 0 10,000 10,000 100% 580 6,000 5,420 90% 7,745 10,000 2,255 23% 488 3,000 2,512 84% 50 500 450 90% 1,628 2,000 372 19% 1,364 4,000 2,636 66% 2,199 4,398 2,199 50% 1,492 2,822 1,330 47% 0 100,832 100,832 100% 0 43,010 43,010 100% ------------ 40,291 ------------ ------------ ------------ 242,233 ------------ ------------ ------------------------ 201,942 ------------------------ ------------------------ 83% 01.23.2013 15:38 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 53358 JULY THRU DECEMBER 2012 FINANCE REPORT Page 32 of 32 USER: RGW 50.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 1,307 1,200 107- -9% 6030-000-393000-000 INTERNAL SERVICES -DATA 79,680 189,340 109,660 58% TOTAL DATA PROCESSING REVENUE ------------ 123,722 ------------ ------------ ------------ 432,640 ------------ ------------ ------------ 308,918 ------------ ------------ ------------ 71% ------------ ------------ DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 70,552 140,220 69,668 50% 6030-401-410580-121 OVERTIME 0 5,000 5,000 100% 6030-401-410580-153 HEALTH INSURANCE 15,680 26,988 11,308 42% 6030-401-410580-155 RETIREMENT 4,626 9,086 4,460 49% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 1,660 1,500 160- -11% 6030-403-410580-215 COMPUTER SUPPLIES 1,192 3,230 2,038 63% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 4,536 13,973 9,437 68% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 1,248 1,450 202 14% 6030-403-410580-346 SUMMIT NET T1 CONTRACT 2,733 7,520 4,787 64% 6030-403-410580-353 LASER FICHE MAINTENANCE 6,574 3,234 3,340- -103% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 0 2,400 2,400 100% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 21,761 45,602 23,841 52% 6030-403-410580-357 GRANICUS 0 6,000 6,000 100% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 8,430 30,300 21,870 72% 6030-403-410580-373 DUES & TRAINING 821 6,000 5,179 86% 6030-403-410580-510 INSURANCE 2,648 1,350 1,298- -96% 6030-403-410583-218 TV -Video Equipment & programming 2,013 2,000 13- -1% 6030-403-410583-354 TV -Video Contract Services 1,000 2,500 1,500 60% 6030-403-410585-229 COPIER,FAX, SUPPLIES 0 5,000 5,000 100% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 30,676 70,000 39,324 56% 6030-403-410585-532 COPIER LEASES 13,170 32,000 18,830 59% 6030-403-410585-942 Servers - capital contingency 8,599 18,000 9,401 52% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 4,018 3,640 378- -10% 6030-410-410588-218 COMPUTERS - DPW 2,323 4,500 2,177 48% 6030-413-410588-218 COMPUTERS - POLICE DEPT 5,710 6,400 690 11% 6030-416-410588-218 COMPUTERS - FIRE 1,993 3,000 1,007 34% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 4,318 4,040 278- -7% 6030-436-410588-218 COMPUTERS - PARKS 3,631 4,500 869 19% TOTAL DATA PROCESSING EXPENSE ------------ 219,912 ------------ ------------ ------------ 464,433 ------------ ------------ ------------------------ 244,521 ------------------------ ------------------------ 53%