Loading...
1st Quarter Financial Report10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 1 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete ACCOUNT NUMBER FUND ACTUAL YTD BUDGET REMAINING % REMAINING IG/L (ACCOUNT NUMBER DESC. (FINAL GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 330,734 5,036,907 4,706,173 93% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 23,500 23,500 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 106,338 88,093 18,245- -21% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 11,087 10,500 587- -6% 1000-000-322101-000 BEER & LIQUOR LICENSES 0 30,000 30,000 100% 1000-000-322300-000 BUSINESS LICENSES 156 1,300 1,144 88% 1000-000-323012-000 PLANNING FEES 11,295 20,000 8,705 44% 1000-000-323109-000 SITE REVIEW 3,253 12,000 8,747 73% 1000-000-323200-000 PARADE PERMITS 600 500 100- -20% 1000-000-323300-000 ANIMAL LICENSES 711 1,500 789 53% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 750 750 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 0 60,000 60,000 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 3,000 3,000 100% 1000-000-335230-000 HB124 ENTITLEMENT 644,392 2,630,289 1,985,897 76% 1000-000-341020-000 ADMINISTRATIVE CHARGES 131,701 538,505 406,804 76% 1000-000-341021-000 GRANT ADMIN FEES 0 10,000 10,000 100% 1000-000-341025-000 CITY COLLECTIONS 3,352 7,500 4,148 55% 1000-000-342010-000 POLICE SERVICES 2,984 30,000 27,016 90% 1000-000-342014-000 RESOURCE OFFICERS 95,500 95,500 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 11,550 10,000 1,550- -16% 1000-000-343018-000 PARKING PERMITS METERS, BOOT REMOVE 28,755 104,000 75,245 72% 1000-000-351000-000 CITY COURT FINES & FEES 86,199 535,000 448,801 84% 1000-000-351016-000 DUI COURT FINE 50 0 50- 0% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 5,454 30,000 24,546 82% 1000-000-351035-000 PARKING FINES 8,759 40,000 31,241 78% 1000-000-362010-000 CITY GOLF COURSE LEASE 0 16,500 16,500 100% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 24,714 10,000 14,714- -147% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 0 11,000 11,000 100% 1000-000-365015-000 CONTRIBUTION FRM KIDSPORT 0 4,100 4,100 100% 1000-000-365018-000 BANDSHELL CONTRIBUTIONS 150 500 350 70% 1000-000-371010-000 INVESTMENT EARNINGS 2,816 10,000 7,184 72% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 166,250 665,000 498,750 75% TOTAL GENERAL FUND REVENUE 1,676,801 10,035,944 8,359,143 83% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 2 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD (FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 0 1,400 1,400 100% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 0 14,250 14,250 100% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 367 4,000 3,633 91% 1000-400-410560-312 POSTAGE 1,302 20,000 18,698 93% 1000-400-410560-320 PRINTING & ENVELOPES 427 4,500 4,073 91% 1000-400-410600-354 ELECTIONS 0 6,000 6,000 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 399 2,500 2,101 84% 1000-400-420000-354 CONTRACT 911 CENTER 116,550 466,200 349,650 75% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 350 350 100% 1000-400-460446-354 KIDSPORT LEASE 0 4,100 4,100 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 997 30,000 29,003 97% 1000-400-510310-354 ICMA PLAN FEES 125 500 375 75% 1000-400-510330-513 LIABILITY INSURANCE 110,169 107,525 2,644- -2% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 27,392 30,000 2,608 9% 1000-400-510330-517 PROPERTY INSURANCE 46,218 46,500 282 1% SUBTOTAL GEN.GOV'T. 303,945 759,425 455,480 60% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 1000-401-410210-121 OTHER - MOVING REIMBURSEMENT 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-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 28,458 130,592 102,134 78% 2,310 5,755 3,445 60% 2,543 19,701 17,158 87% 3,005 13,733 10,728 78% 0 300 300 100% 0 500 500 100% 110 880 770 88% 2,865 7,500 4,635 62% 30 3,300 3,270 99% 39,321 182,261 142,940 78% 26,408 118,076 91,668 78% 2,836 17,028 14,192 83% 1,988 8,820 6,832 77% 121 600 479 80% 1,086 7,200 6,114 85% 80 1,000 920 92% 185 3,500 3,315 95% 32,704 156,224 123,520 79% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 3 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD I FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 13,869 63,054 49,185 78% 1000-402-410100-153 HEALTH INSURANCE 6,545 35,700 29,155 82% 1000-402-410100-155 RETIREMENT 498 1,928 1,430 74% 1000-402-410100-210 OFFICE SUPPLIES 33 100 67 67% 1000-402-410100-335 MT LEAGUE OF CITIES 500 5,000 4,500 90% 1000-402-410100-354 CONTRACT SERVICES 0 2,260 2,260 100% 1000-402-410100-373 DUES & TRAINING 5,978 6,000 22 0% 1000-402-410100-379 MEETINGS 96 8,100 8,004 99% SUBTOTAL MAYOR/COUNCIL 27,519 122,142 94,623 77% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 19,565 98,340 78,775 80% 1000-402-410150-112 SEVERANCE 0 8,500 8,500 100% 1000-402-410150-121 OVERTIME 109 500 391 78% 1000-402-410150-153 HEALTH INSURANCE 1,464 17,374 15,910 92% 1000-402-410150-155 RETIREMENT 1,478 7,423 5,945 80% 1000-402-410150-210 OFFICE SUPPLIES 0 100 100 100% 1000-402-410150-345 TELEPHONE & COMMUNICATION 42 300 258 86% 1000-402-410150-352 CODIFICATION 1,593 3,700 2,107 57% 1000-402-410150-354 CONTRACT SERVICES 0 25 25 100% 1000-402-410150-373 DUES & TRAINING 100 2,500 2,400 96% SUBTOTAL CITY CLERK 24,351 138,762 114,411 82% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 44,818 201,362 156,544 78% 1000-403-410550-153 HEALTH INSURANCE 5,535 33,630 28,095 84% 1000-403-410550-155 RETIREMENT 3,369 15,058 11,689 78% 1000-403-410550-322 BOOKS 0 500 500 100% 1000-403-410550-353 CONTRACT SERVICES 0 5,000 5,000 100% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 0 1,500 1,500 100% 1000-403-410550-355 BANK CHARGES & FEES 759 3,500 2,741 78% 1000-403-410550-373 DUES & TRAINING 100 6,000 5,900 98% SUBTOTAL FINANCE 54,582 266,550 211,968 80% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 4 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD I FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 76,648 341,132 264,484 78% 1000-404-411110-153 HEALTH INSURANCE 8,263 52,110 43,847 84% 1000-404-411110-155 RETIREMENT 5,770 25,600 19,830 77% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 177 2,500 2,323 93% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 3,299 8,000 4,701 59% 1000-404-411110-345 TELEPHONE & COMMUNICATION 114 1,000 886 89% 1000-404-411110-354 CONTRACT SERVICES 0 1,500 1,500 100% 1000-404-411110-373 DUES & TRAINING 2,494 4,700 2,206 47% SUBTOTAL CITY ATTORNEY 96,765 436,542 339,777 78% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 48,984 221,257 172,273 78% 1000-406-410360-121 OVERTIME 254 0 254- 0% 1000-406-410360-153 HEALTH INSURANCE 6,613 39,696 33,083 83% 1000-406-410360-155 RETIREMENT 3,702 16,430 12,728 77% 1000-406-410360-210 SUPPLIES 937 4,500 3,563 79% 1000-406-410360-320 PRINTING/BOOKS 112 1,500 1,388 93% 1000-406-410360-345 TELEPHONE & COMMUNICATION 0 1,400 1,400 100% 1000-406-410360-353 SECURITY & TECHNOLOGY 135 40,000 39,865 100% 1000-406-410360-354 CONTRACT SERVICES 609 5,750 5,141 89% 1000-406-410360-373 DUES & TRAINING 26 6,300 6,274 100% 1000-406-410360-394 JURY & WITNESS FEES 943 5,750 4,807 84% SUBTOTAL COURT 62,315 342,583 280,268 82% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 3,768 17,604 13,836 79% 1000-410-430100-153 HEALTH INSURANCE 425 3,263 2,838 87% 1000-410-430100-155 RETIREMENT 281 1,292 1,011 78% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 2,074 6,500 4,426 68% 1000-410-430100-231 GAS 238 2,500 2,262 90% 1000-410-430100-345 TELEPHONE & COMMUNICATION 43 285 242 85% 1000-410-430100-354 CONTRACT SERVICES 0 850 850 100% 1000-410-430100-373 DUES & TRAINING 407 1,300 893 69% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 1,482 5,928 4,446 75% SUBTOTAL PUBLIC WORKS ADMIN 8,719 39,522 30,803 78% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 13,710 64,735 51,025 79% 1000-412-411230-153 HEALTH INSURANCE 2,238 15,084 12,846 85% 1000-412-411230-155 RETIREMENT 992 4,645 3,653 79% 1000-412-411230-220 SECURITY CAMERA -CITY HALL 0 800 800 100% 1000-412-411230-224 JANITORIAL SUPPLIES 377 5,500 5,123 93% 1000-412-411230-241 TOOLS & SUPPLIES 0 1,500 1,500 100% 1000-412-411230-341 ELECTRICITY 9,232 45,000 35,768 79% 1000-412-411230-344 NATURAL GAS 751 35,000 34,249 98% 1000-412-411230-345 TELEPHONE & COMMUNICATION 15 250 235 94% 1000-412-411230-354 CONTRACT SERVICES 3,370 8,500 5,130 60% 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 14,274 17,300 3,026 17% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 5 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FU(ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 360 4,500 4,140 92% 1000-412-411230-362 EQUIPMENT MAINTENANCE 0 5,000 5,000 100% 1000-412-411230-366 BUILDING MAINTENANCE 10,331 38,000 27,669 73% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 0 3,900 3,900 100% 1000-412-411230-610 BOI 2004 DEBT (HVAC SYS) 8,175 8,175 0 0% 1000-412-411230-620 BOI 2004 INT. (HVAC SYS) 41 102 61 60% SUBTOTAL CITY HALL 63,865 257,991 194,126 75% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 58,956 263,106 204,150 78% 1000-420-411020-153 HEALTH INSURANCE 9,128 54,792 45,664 83% 1000-420-411020-155 RETIREMENT 4,444 19,654 15,210 77% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 2,272 7,000 4,728 68% 1000-420-411020-231 GAS 43 400 357 89% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 289 2,700 2,411 89% 1000-420-411020-345 TELEPHONE 116 900 784 87% 1000-420-411020-354 CONTRACT SERVICES 0 1,000 1,000 100% 1000-420-411020-373 DUES & TRAINING 495 4,400 3,905 89% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 327 1,294 967 75% SUBTOTAL PLANNING DEPT. 76,070 355,246 279,176 79% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 8,854 44,693 35,839 80% 1000-480-470210-153 HEALTH INSURANCE 744 7,636 6,892 90% 1000-480-470210-155 RETIREMENT 667 3,414 2,747 80% 1000-480-470210-210 OFFICE SUPPLIES 0 2,000 2,000 100% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 2,000 2,000 100% 1000-480-470210-312 POSTAGE & PRINTING 43 2,200 2,157 98% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 101 750 649 87% 1000-480-470210-354 CONTRACT SERVICES 0 2,000 2,000 100% 1000-480-470210-373 DUES & TRAINING 0 3,000 3,000 100% 1000-480-470210-379 MEETINGS 0 500 500 100% SUBTOTAL COMMUNITY DEVELOPMENT 10,909 68,693 57,784 84% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 6 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD (FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 458,392 1,968,945 1,510,553 77% 1000-413-420140-112 SALARIES -SEVERANCE 9,528 10,000 472 5% 1000-413-420140-114 SALARY -comptime buyout 0 5,000 5,000 100% 1000-413-420140-121 OVERTIME (REG & AET OT) 18,619 75,000 56,381 75% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 0 25,000 25,000 100% 1000-413-420140-153 HEALTH INSURANCE 59,030 362,940 303,910 84% 1000-413-420140-155 RETIREMENT 57,545 256,952 199,407 78% 1000-413-420140-210 OFFICE SUPPLIES 517 3,500 2,983 85% 1000-413-420140-215 COMPUTER SUPPLIES 1,332 5,500 4,168 76% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 0 20,500 20,500 100% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 560 4,000 3,440 86% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 854 7,000 6,146 88% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 0 2,000 2,000 100% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 0 4,000 4,000 100% 1000-413-420140-227 AMMO & RELATED SUPPLIES 0 19,000 19,000 100% 1000-413-420140-228 PATROL CAR SUPPLIES 3,054 13,000 9,946 77% 1000-413-420140-229 OTHER SUPPLIES 1,158 3,500 2,342 67% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 140- 1,000 1,140 114% 1000-413-420140-231 GAS 17,009 95,000 77,991 82% 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 0 1,500 1,500 100% 1000-413-420140-320 PRINTING 1,578 5,000 3,422 68% 1000-413-420140-345 TELEPHONE & COMMUNICATION 1,799 15,500 13,701 88% 1000-413-420140-354 CONTRACT SERVICES 1,864 6,000 4,136 69% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 692 9,000 8,308 92% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 83 3,000 2,917 97% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 438 2,000 1,562 78% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 6,512 12,000 5,488 46% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 104 2,500 2,396 96% 1000-413-420140-373 DUES & TRAINING 9,699 30,000 20,301 68% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 8,736 5,000 3,736- -75% 1000-413-420140-380 TRAINING MATERIALS 0 2,000 2,000 100% 1000-413-420140-388 MEDICAL SERVICES 130 2,500 2,370 95% 1000-413-420140-392 BOARDING/TREATING PRISONERS 402 2,500 2,098 84% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 22,648 90,592 67,944 75% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 11,250 45,000 33,750 75% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 875 3,500 2,625 75% 1000-413-420140-944 VEHICLES 0 118,202 118,202 100% SUBTOTAL POLICE DEPT. 694,266 3,240,131 2,545,865 79% DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 1000-413-420141-121 DETECTIVE -OVERTIME 1000-413-420141-153 HEALTH INSURANCE 1000-413-420141-155 DETECTIVE -RETIREMENT TOTAL DETECTIVES RECORDS 1000-413-420142-110 SALARIES -RECORDS DIVISION 1000-413-420142-121 OVERTIME 1000-413-420142-153 HEALTH INSURANCE 65,003 341,633 276,630 81% 4,586 15,000 10,414 69% 6,537 61,572 55,035 89% 8,345 45,892 37,547 82% 84,471 464,097 379,626 82% 26,029 104,751 78,722 75% 1,349 7,500 6,151 82% 3,570 22,420 18,850 84% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 7 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete ACCOUNT NUMBER FU ACTUAL YTD BUDGET REMAINING % REMAINING IG/L (ACCOUNT NUMBER DESC. IFINAL 1000-413-420142-155 RETIREMENT 2,046 7,189 5,143 72% TOTAL RECORDS 32,994 141,860 108,866 77% RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 26,942 121,605 94,663 78% 1000-413-420144-153 HEALTH INSURANCE 3,387 18,292 14,905 81% 1000-413-420144-155 SRO RETIREMENT 3,380 16,337 12,957 79% TOTAL RESOURCE OFFICERS 33,709 156,234 122,525 78% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 10,966 46,555 35,589 76% 1000-413-420145-121 OVERTIME 12 500 488 98% 1000-413-420145-153 HEALTH INSURANCE 2,035 15,264 13,229 87% 1000-413-420145-155 RETIREMENT 755 3,472 2,717 78% SUBTOTAL ANIMAL CONTROL 13,768 65,791 52,023 79% PARKING 1000-413-420147-110 PARKINGS -SALARIES 19,233 82,351 63,118 77% 1000-413-420147-153 HEALTH INSURANCE 4,434 26,616 22,182 83% 1000-413-420147-155 RETIREMENT 1,385 6,139 4,754 77% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 271 4,000 3,729 93% 1000-413-420147-354 CONTRACTED SERVICES 41 2,000 1,959 98% 1000-413-420147-362 LOT MAINT 207 10,000 9,793 98% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 100% 1000-413-420147-550 LOT LEASE PAYMENTS 351 1,500 1,149 77% SUBTOTAL PARKING 25,922 150,106 124,184 83% SUBTOTAL POLICE DEPT. 885,131 4,218,219 3,333,088 79% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 8 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete ACCOUNT NUMBER FUND ACTUAL YTD BUDGET REMAINING % REMAINING IG/L (ACCOUNT NUMBER DESC. (FINAL FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 338,634 1,509,530 1,170,896 78% 1000-416-420400-114 COMPTIME BUYOUT 0 5,000 5,000 100% 1000-416-420400-115 OUT OF RANK PAY 2,667 11,978 9,311 78% 1000-416-420400-121 OVERTIME 39,669 40,000 331 1% 1000-416-420400-153 HEALTH INSURANCE 45,177 268,422 223,245 83% 1000-416-420400-155 RETIREMENT 45,518 202,694 157,176 78% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 594 2,700 2,106 78% 1000-416-420400-218 Equipment (Non Capital) 44 21,500 21,456 100% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 6,845 15,000 8,155 54% 1000-416-420400-224 JANITORIAL SUPPLIES 973 2,500 1,527 61% 1000-416-420400-231 GAS 2,520 17,325 14,805 85% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 4,280 15,000 10,720 71% 1000-416-420400-320 PRINTING 0 700 700 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 0 1,250 1,250 100% 1000-416-420400-345 TELEPHONE & COMMUNICATION 719 8,500 7,781 92% 1000-416-420400-354 CONTRACT SERVICES 2,600 7,500 4,900 65% 1000-416-420400-362 EQUIPMENT MAINTENANCE 2,949 5,500 2,551 46% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 589 5,000 4,411 88% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 684 6,000 5,316 89% 1000-416-420400-373 DUES & TRAINING 6,296 10,000 3,704 37% 1000-416-420400-388 FIREFIGHTER PHYSICALS 0 22,500 22,500 100% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 7,915 31,658 23,743 75% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 31,029 62,600 31,571 50% 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 2,831 5,402 2,571 48% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 77,500 310,000 232,500 75% 1000-416-420400-940 CAPITAL EQUIPMENT - VEHICLES 28,869 32,000 3,131 10% 1000-416-420440-110 SALARIES -FIRE PREVENTION 10,344 44,993 34,649 77% 1000-416-420440-121 OVERTIME 1,251 0 1,251- 0% 1000-416-420440-153 HEALTH INSURANCE 1,233 6,811 5,578 82% 1000-416-420440-155 RETIREMENT 832 3,243 2,411 74% SUBTOTAL FIRE DEPT, 662,561 2,675,306 2,012,745 75% GRAND TOTAL GENERAL FUND 2,348,758 10,019,466 7,670,708 77% ------------------------------------------------- 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 9 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 0 1,600 1,600 100% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 2,162 8,646 6,484 75% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 750,000 750,000 100% 2185-480-470240-110 SALARIES 2,799 19,719 16,920 86% 2185-480-470240-153 HEALTH INSURANCE 268 4,579 4,311 94% 2185-480-470240-155 RETIREMENT 211 1,474 1,263 86% 2185-480-470240-345 TELEPHONE & COMMUNICATION 8 48 40 83% TOTAL AIRPORT TIF 5,447 ------------ 786,066 ------------- 780,619 ------------ ------------ 99% 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 6,981 38,544 31,563 82% 2188-480-470230-153 HEALTH INSURANCE 625 6,871 6,246 91% 2188-480-470230-155 RETIREMENT 526 2,869 2,343 82% 2188-480-470230-353 AUDIT 0 2,000 2,000 100% 2188-480-470230-356 CONTRACT SERVICES/BOND ISSUE COSTS 45 0 45- 0% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 780 3,120 2,340 75% 2188-480-470230-710 LOAN REVOLVING FUNDS 0 1,500,000 1,500,000 100% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 0 1,000,000 1,000,000 100% 2188-480-470230-840 TRANSFER TO DEBT SERVICE 8,000 32,000 24,000 75% TOTAL WESTSIDE TIF 16,957 2,585,404 2,568,447 99% OLD SCHOOL TIFS 2310-480-470210-354 CONTRACT SERVICES - BOND COUNSEL 0 1,000 1,000 100% 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 12,500 12,500 100% 2310-480-470210-356 FED -EX REIMBURSEMENT 0 10,500 10,500 100% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 7,500 30,000 22,500 75% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 500 2,000 1,500 75% TOTAL OLD SCHOOL TIFS 8,000 56,000 48,000 86% 2927 ARTS GRANTS 2927-400-460454-354 GLACIER ORCHESTRA 0 10,634 10,634 100% 2927-400-460456-354 NW MT HISTORICAL SOCIETY 0 12,263 12,263 100% TOTAL ARTS GRANTS 0 ------------ 22,897 ------------- 22,897 ------------ ------------ 100% PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND 183,750 735,000 551,250 75% TOTAL PERMISSIVE HEALTH LEVY 183,750 ------------ 735,000 ------------- 551,250 ------------------------ 75% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 10 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD I FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2399-400-420100-522 2399-413-420140-354 2399-413-420140-940 2399-416-420400-354 2399-416-420400-610 2399-416-420400-620 2399-416-420400-940 2399 PUBLIC SAFETY IMPACT FEES ADMIN CHARGE - IMPACT FEES 5% IMPACT FEE REVIEW POLICE EQUIPMENT IMPACT FEE REVIEW PRINCIPAL - FIRE TRUCK INTEREST - FIRE TRUCK FIRE DEPT. EQUIPMENT TOTAL PUBLIC SAFETY IMPACT FEE 0 4,500 4,500 100% 0 500 500 100% 0 50,000 50,000 100% 0 500 500 100% 15,000 30,250 15,250 50% 2,588 4,789 2,201 46% 0 400,000 400,000 100% 17,588 490,539 472,951 96% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 11 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete ACCOUNT NUMBER FUND ACTUAL YTD BUDGET REMAINING % REMAINING IG/L (ACCOUNT NUMBER DESC. (FINAL 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 14,017 860,000 845,983 98% 2215-000-311200-000 PERSONAL PROPERTY TAXES 18,086 25,000 6,914 28% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,993 2,000 7 0% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 0 10,000 10,000 100% 2215-000-346030-000 SWIMMING POOL FEES 95,904 140,000 44,096 32% 2215-000-346040-000 CONCESSION STAND REVENUE 27,545 34,000 6,455 19% 2215-000-346050-000 PARKS USAGE FEES 7,997 18,500 10,503 57% 2215-000-346051-000 RECREATION FEES 1,197 10,000 8,803 88% 2215-000-346052-000 SPORTS PROGRAMS 9,833 42,000 32,167 77% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 129 3,000 2,871 96% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 10,273 59,000 48,727 83% 2215-000-346055-000 ICE RINK 0 21,000 21,000 100% 2215-000-346056-000 KIDSPORT USAGE 72 1,000 928 93% 2215-000-346057-000 YOUTH CAMPS 1,037 140,000 138,963 99% 2215-000-346059-000 PICNIC IN THE PARK 8,375 36,000 27,625 77% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS/DONATIONS/MISC.SALES 365 1,500 1,135 76% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 17,500 70,000 52,500 75% TOTAL PARKS & REC REVENUE 214,324 ------------------------- 1,493,000 1,278,676 ------------ 86% ------------ PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 64,120 293,884 229,764 78% 2215-436-460430-111 SEASONAL SALARIES 28,745 62,696 33,951 54% 2215-436-460430-121 OVERTIME 34 750 716 95% 2215-436-460430-153 HEALTH INSURANCE 10,703 65,610 54,907 84% 2215-436-460430-155 RETIREMENT 6,146 25,784 19,638 76% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 76 1,700 1,624 96% 2215-436-460430-224 JANITORIAL SUPPLIES 1,290 4,100 2,810 69% 2215-436-460430-229 OTHER SUPPLIES 1,323 5,000 3,677 74% 2215-436-460430-231 GAS 4,283 17,000 12,717 75% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 588 4,000 3,412 85% 2215-436-460430-320 PRINTING & ADVERTISING 0 500 500 100% 2215-436-460430-341 ELECTRICITY 3,731 15,700 11,969 76% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 21,000 21,000 100% 2215-436-460430-344 NATURAL GAS 81 3,000 2,919 97% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 216 2,500 2,284 91% 2215-436-460430-351 TENNIS COURT REHABILITATION 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 800 2,000 1,200 60% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 5,841 10,000 4,159 42% 2215-436-460430-356 CONSULTANTS 0 700 700 100% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 3,000 3,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 887 8,000 7,113 89% 2215-436-460430-364 LANDSCAPING 270 5,400 5,131 95% 2215-436-460430-367 VANDALISM REPAIRS 1,366 4,500 3,134 70% 2215-436-460430-373 DUES & TRAINING 2,550 6,000 3,450 58% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 700 700 100% 2215-436-460430-395 EQUIPMENT RENTAL 0 200 200 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 3,000 3,000 100% 2215-436-460430-440 IRRIGATION SUPPLIES 1,499 8,500 7,001 82% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 1,019 3,000 1,981 66% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 12 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET I REMAINING % REMAINING 2215-436-460430-521 CENTRAL GARAGE TRANSFER 11,338 45,351 34,013 75% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 5,150 10,377 5,227 506 2215-436-460430-620 DEBT SERVICE INTEREST 194 469 275 59% 2215-436-460430-941 PLAYGROUND EQUIP - (LAWRENCE PARK) 0 12,000 12,000 100% 2215-436-460430-942 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% SUBTOTAL PARKS EXPENDITURES 152,250 655,421 503,171 77% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 13,253 60,382 47,129 78% 2215-436-460440-111 SEASONAL SALARIES 16,725 47,184 30,459 65% 2215-436-460440-153 HEALTH INSURANCE 2,339 18,382 16,043 87% 2215-436-460440-155 RETIREMENT 1,832 6,168 4,336 70% 2215-436-460440-221 SAFETY EQUIPMENT 0 500 500 100% 2215-436-460440-229 OTHER SUPPLIES 3,748 17,500 13,752 79% 2215-436-460440-231 GAS 4,634 9,700 5,066 52% 2215-436-460440-241 CONSUMABLE TOOLS 645 2,000 1,355 68% 2215-436-460440-341 ELECTRICITY 2,727 8,200 5,473 67% 2215-436-460440-345 TELEPHONE & COMMUNICATION 13 200 187 94% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 13 700 687 98% 2215-436-460440-364 LANDSCAPING 0 400 400 100% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 0 500 500 100% 2215-436-460440-395 RENTAL EQUIPMENT 142 150 8 5% 2215-436-460440-420 METAL PRODUCTS 0 400 400 100% 2215-436-460440-440 IRRIGATION 2,009 4,100 2,091 51% 2215-436-460440-452 SAND & GRAVEL 0 2,700 2,700 100% 2215-436-460440-610 DEBT SERVICE -PRINCIPAL 7,227 14,241 7,014 49% 2215-436-460440-620 DEBT SERVICE -INTEREST 145 645 500 78% SUBTOTAL ATHLETIC COMPLEX 55,451 195,552 140,101 72% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 20,512 92,455 71,943 78% 2215-436-460431-111 SEASONAL SALARIES 5,113 11,593 6,480 56% 2215-436-460431-153 HEALTH INSURANCE 3,743 22,961 19,218 84% 2215-436-460431-155 RETIREMENT 1,550 7,719 6,169 80% 2215-436-460431-218 DONATED SUPPLIES 0 1,500 1,500 100% 2215-436-460431-229 MISC. SUPPLIES 1,334 11,465 10,131 88% 2215-436-460431-231 GAS 192 750 558 74% 2215-436-460431-320 PRINTING & ADVERTISING 0 10,500 10,500 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 40 240 200 83% 2215-436-460431-354 CONTRACT SERVICES 16,375 20,360 3,985 20% 2215-436-460431-355 On Line Registration 31 0 31- 0% 2215-436-460431-357 MUSIC FRANCHISE FEES 0 1,000 1,000 100% 2215-436-460431-373 DUES & TRAINING 177 600 423 71% SUBTOTAL RECREATION 49,066 181,143 132,077 73% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 15,672 70,515 54,843 78% 2215-436-460448-111 SEASONAL SALARIES 56,932 119,950 63,018 53% 2215-436-460448-121 OVERTIME 0 500 500 100% 2215-436-460448-153 HEALTH INSURANCE 2,635 21,435 18,800 88% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 13 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD (FINAL BUDGET I REMAINING % REMAINING 2215-436-460448-155 RETIREMENT 1,140 7,089 5,949 84% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 0 600 600 100% 2215-436-460448-229 MISC. SUPPLIES 2,254 3,800 1,546 41% 2215-436-460448-231 GAS 0 750 750 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 150 150 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 26 350 324 92% 2215-436-460448-354 CONTRACT SERVICES 9,800 18,700 8,900 48% 2215-436-460448-355 AFTER SCHOOL PROGRAM 108 5,000 4,892 98% 2215-436-460448-356 BANK FEES/CC CHARGES 892 3,200 2,308 72% 2215-436-460448-373 DUES & TRAINING 0 600 600 100% SUBTOTAL YOUTH CAMPS 89,462 252,639 163,177 65% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 115,693 199,979 84,286 42% 2215-437-460445-121 OVERTIME 0 1,200 1,200 100% 2215-437-460445-155 RETIREMENT 430 11500 1,070 71% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 242 600 358 60% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 945 3,000 2,055 69% 2215-437-460445-226 CHLORINE/CHEMICALS 15,001 27,700 12,699 46% 2215-437-460445-228 CONCESSION STAND SUPPLIES 12,582 19,000 6,418 34% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 1,476 5,500 4,024 73% 2215-437-460445-341 ELECTRICITY 3,492 10,000 6,508 65% 2215-437-460445-344 NATURAL GAS 18,034 25,000 6,966 28% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 177 1,500 1,323 88% 2215-437-460445-354 LICENSES & FEES 228 1,300 1,072 82% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 4,358 8,700 4,342 50% 2215-437-460445-380 TRAINING MATERIALS 245 800 555 69% SUBTOTAL POOL EXPENDITURES 172,903 305,779 132,876 43% TOTAL PARKS & RECREATION/POOL 519,132 1,590,534 1,071,402 67% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 14 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD (FINAL BUDGET REMAINING % REMAINING FORESTRY & DEVELOPER TREES 2600-436-460433-110 SALARIES -URBAN FORESTRY 20,271 95,648 75,377 79% 2600-436-460433-111 SEASONAL SERVICES 0 8,013 8,013 100% 2600-436-460433-121 OVERTIME 0 300 300 100% 2600-436-460433-153 HEALTH INSURANCE 2,877 21,118 18,241 86% 2600-436-460433-155 RETIREMENT 1,481 6,940 5,459 79% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 0 550 550 100% 2600-436-460433-231 GAS 43 2,500 2,457 98% 2600-436-460433-241 CONSUMABLE TOOLS 0 2,000 2,000 100% 2600-436-460433-354 CONTRACT SERVICES 0 12,500 12,500 100% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 1,442 2,500 1,058 42% 2600-436-460433-362 EQUIPMENT MAINTENANCE 0 650 650 100% 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 1,924 2,344 420 18% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 1,816 7,264 5,448 75% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 2,351 9,403 7,052 75% 2600-436-460433-528 DATA PROCESSING TRANSFER 716 2,858 2,142 75% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 4,124 8,172 4,048 50% 2600-436-460433-620 INTEREST EXPENSE 123 309 186 60% TOTAL URBAN FORESTRY 2601-436-460430-350 ADMIN 5% 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-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) 2601-436-460435-368 NORTHLAND SUBD PHASE 4 TOTAL DEVELOPER TREES 2210 PARKS IN LIEU 2210-436-460430-826 TRANSFER TO TRAILS FUND- 93 N / 3 M TOTAL PARKS IN LIEU 2975 TRAILS 2975-436-460457-951 HWY93 NORTH TRAIL TOTAL TRAILS 37,167 ------------ ------------- 191,369 154,202 ------------ ------------ 81% 0 185 185 100% 0 8,653 8,653 100% 0 4,336 4,336 100% 295 661 366 55% 0 667 667 100% 0 2,253 2,253 100% 0 17,536 17,536 100% 590 27,669 27,079 98% 295 278 17- -6% 0 2,219 2,219 100% 0 948 948 100% 0 1,390 1,390 100% 0 1,429 1,429 100% 0 2,797 2,797 100% 885 9,375 8,490 91% 0 3,074 3,074 100% 0 8,812 8,812 100% 2,065 92,282 90,217 98% 0 9,388 9,388 100% 0 ------------ ------------- 9,388 9,388 ------------ ------------ 100% 3,750 127,920 124,170 97% 3,750 ------------ ------------- 127,920 124,170 ------------ ------------ 97% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 15 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 167,842 605,000 437,158 72% 2230-000-342070-000 COUNTY EMS LEVY 0 100,000 100,000 100% 2230-000-371010-000 INTEREST EARNINGS 1 0 1- 0% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 77,500 310,000 232,500 75% TOTAL AMBULANCE REVENUE 245,344 1,015,000 769,656 76% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 120,601 572,610 452,009 79% 2230-440-420730-114 COMPTIME BUYBACK 0 3,000 3,000 100% 2230-440-420730-115 OUT OF RANK PAY 164 1,000 836 84% 2230-440-420730-121 OVERTIME 13,567 22,147 8,580 39% 2230-440-420730-153 HEALTH INSURANCE 20,282 135,834 115,552 85% 2230-440-420730-155 RETIREMENT 15,883 75,963 60,080 79% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 322 1,000 678 68% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 9 19,500 19,491 100% 2230-440-420730-231 GAS & OIL 1,758 7,560 5,802 77% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 0 6,000 6,000 100% 2230-440-420730-312 POSTAGE/PRINTING 115 2,000 1,885 94% 2230-440-420730-345 TELEPHONE & COMMUNICATION 143 700 557 80% 2230-440-420730-354 PARAMEDIC RECERTIFICATION 2,619 11,800 9,181 78% 2230-440-420730-355 911 CENTER CONTRIBUTION 8,156 32,623 24,467 75% 2230-440-420730-359 AUDIT/CC OTHER FEES 339 1,400 1,061 76% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 0 7,000 7,000 100% 2230-440-420730-373 DUES & TRAINING 179 5,000 4,821 96% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 8,652 39,300 30,648 78% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 5,737 7,000 1,263 18% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 3,684 14,735 11,051 75% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 7,585 30,340 22,755 75% 2230-440-420730-528 DATA PROCESSING TRANSFER 2,866 11,432 8,566 75% TOTAL AMBULANCE EXPENDITURES 212,661 1,010,444 797,783 79% FIRE & HAZMAT GRANTS 2956-416-420400-218 EQUIPMENT (NON CAPITAL) 80 0 80- 0% 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 0 6,000 6,000 100% 2956-416-420414-219 FIRE PREVENTION GRT FY15 0 13,000 13,000 100% TOTAL FIRE GRANTS 80 ------------ 19,000 ------------- 18,920 ------------ ------------ 100% 2957-416-420400-155 RETIREMENT 76 2,500 2,424 97% 2957-416-420410-125 PASS THRU HAZMAT OT 600 19,365 18,765 97% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 747 27,345 26,598 97% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 6,100 6,100 100% TOTAL HAZMAT GRANTS 1,423 55,310 53,887 97% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 16 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD I FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 95,276 250,000 154,724 62% 2394-000-323103-000 PLUMBING PERMITS 5,314 13,000 7,686 59% 2394-000-323104-000 MECHANICAL PERMITS 10,482 54,000 43,519 81% 2394-000-323107-000 HOUSE MOVING PERMITS 0 100 100 100% 2394-000-323108-000 PLAN REVIEW FEES 38,609 50,000 11,391 23% 2394-000-371010-000 INVESTMENT EARNINGS 726 2,000 1,274 64% TOTAL REVENUE 150,407 369,100 218,693 59% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 53,603 283,870 230,267 81% 2394-420-420530-121 OVERTIME 2,683 3,500 817 23% 2394-420-420530-153 HEALTH INSURANCE 6,660 58,264 51,604 89% 2394-420-420530-155 RETIREMENT 4,091 20,314 16,223 80% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 68 25,000 24,932 100% 2394-420-420530-231 GAS & OIL 539 3,000 2,461 82% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 0 1,750 1,750 100% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 2,500 2,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 408 2,500 2,092 84% 2394-420-420530-353 AUDITING 0 3,500 3,500 100% 2394-420-420530-354 CONTRACT SERVICES 0 1,300 1,300 100% 2394-420-420530-373 DUES & TRAINING 940 4,000 3,060 77% 2394-420-420530-510 PROPERTY INSURANCE 4,755 6,000 1,245 21% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 397 1,587 1,190 75% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 3,175 12,701 9,526 75% 2394-420-420530-528 DATA PROCESSING TRANSFER 2,149 4,790 2,641 55% 2394-420-420530-930 WEB BASED SOFTWARE PACKAGE 12,990 35,000 22,010 63% TOTAL BUILDING DEPT. 92,458 ------------ ------------- 469,576 377,118 ------------ ------------ 80% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 17 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD I FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 16,674 73,796 57,122 77% 2400-410-430263-153 HEALTH INSURANCE 1,655 11,455 9,800 86% 2400-410-430263-155 RETIREMENT 1,193 5,264 4,071 77% 2400-410-430263-244 STREET LIGHT SUPPLIES 1,306 15,000 13,694 91% 2400-410-430263-341 ELECTRICITY 29,694 165,000 135,306 82% 2400-410-430263-360 REPAIR & MAINT SERVICES 354 12,000 11,646 97% 2400-410-430263-510 INSURANCE 891 1,085 194 18% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 2,693 10,773 8,080 75% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 10,692 21,430 10,738 50% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 431 816 385 47% TOTAL LIGHT MAINT. 65,583 316,619 251,036 79% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 0 40,000 40,000 100% 2420-421-430234-957 ALLEY PAVING 0 25,000 25,000 100% 2420-421-430240-231 GAS & OIL 6,979 40,000 33,021 83% 2420-421-430240-344 NATURAL GAS 79 4,000 3,921 98% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 53,513 120,000 66,487 55% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 1,500 11500 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 169,339 200,000 30,661 15% 2420-421-430240-452 GRAVEL 94 2,500 2,406 96% 2420-421-430240-453 EQUIPMENT RENTAL 10,500 21,750 11,250 52% 2420-421-430240-471 DE-ICER/ROAD OIL 3,734 40,000 36,266 91% 2420-421-430240-472 ASPHALT 3,671 31,500 27,829 88% 2420-421-430240-473 CRACK SEALING 0 14,500 14,500 100% TOTAL GAS TAX 247,909 ------------ ------------- 540,750 292,841 ------------ ------------ 54% 2825 MAGI GRANT 2825-421-430240-940 FLUSH TRUCK / SWEEPER 0 376,000 376,000 100% TOTAL MACI GRANT 0 376,000 376,000 100% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 18 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete ACCOUNT NUMBER FUND ACTUAL YTD BUDGET REMAINING % REMAINING IG/L (ACCOUNT NUMBER DESC. (FINAL 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 144,767 636,776 492,009 77% 2500-421-430240-121 OVERTIME 176 25,000 24,824 99% 2500-421-430240-153 HEALTH INSURANCE 20,759 148,088 127,329 86% 2500-421-430240-155 RETIREMENT 10,371 45,235 34,864 77% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 1,583 9,000 7,417 82% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 333 6,000 5,667 94% 2500-421-430240-220 OTHER SUPPLIES 587 4,100 3,513 86% 2500-421-430240-231 GAS & OIL 7,231 42,000 34,769 83% 2500-421-430240-341 ELECTRICITY 294 1,450 1,156 80% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 294 1,500 1,206 80% 2500-421-430240-354 CONTRACT SERVICES 393 15,000 14,607 97% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 4,060 28,000 23,940 86% 2500-421-430240-366 BUILDING MAINTENANCE 0 3,000 3,000 100% 2500-421-430240-373 DUES & TRAINING 0 5,500 5,500 100% 2500-421-430240-388 MEDICAL SERVICES 285 1,500 1,215 81% 2500-421-430240-510 LIABILITY INSURANCE 20,011 23,051 3,040 13% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 44,135 176,541 132,406 75% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 19,782 79,129 59,347 75% 2500-421-430240-528 DATA PROCESSING TRANSFER 2,149 8,574 6,425 75% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 42,055 115,182 73,127 63% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 1,541 5,846 4,305 74% 2500-421-430240-941 DUMP TRUCKS - INCEPTION OF LOAN 0 5,000 5,000 100% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 139,023 383,729 244,706 64% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 63,938 296,070 232,133 78% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 518 38,328 37,810 99% 2500-421-430264-110 TSS - SALARIES 26,284 115,213 88,929 77% 2500-421-430264-121 OVERTIME 537 9,500 8,963 94% 2500-421-430264-153 HEALTH INSURANCE 2,380 15,280 12,900 84% 2500-421-430264-155 RETIREMENT 1,890 8,119 6,229 77% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 128 1,500 1,372 91% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 213 6,700 6,487 97% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 1,039 3,500 2,461 70% 2500-421-430264-242 STREET SIGNS 6,128 40,000 33,872 85% 2500-421-430264-243 TRAFFIC SIGNALS 930 19,000 18,070 95% 2500-421-430264-245 BARRICADE MATERIALS 100- 5,000 5,100 102% 2500-421-430264-341 ELECTRICITY 230 3,500 3,270 93% 2500-421-430264-345 COMMUNICATIONS 212 750 538 72% 2500-421-430264-354 CONTRACT SERVICES 764 10,000 9,236 92% 2500-421-430264-362 EQUIPMENT MAINTENANCE 181 3,000 2,819 94% 2500-421-430264-366 BUILDING MAINTENANCE 65 2,000 1,935 97% 2500-421-430264-373 DUES & TRAINING 1,384 5,500 4,116 75% 2500-421-430264-428 PAINT MATERIALS 2,172 8,000 5,828 73% 2500-421-430264-510 LIABILITY INS.-TSS 2,450 2,736 286 10% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,500 2,500 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 2,170 8,679 6,509 75% 2500-421-430264-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SPEC. ST. MAINT. 577,262 2,391,914 1,814,652 76% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 19 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,370 1,370 100% 2880-480-470210-711 REDEVELOPMENT 10,000 350,000 340,000 970-. TOTAL LOAN REVOLVING 10,000 351,370 341,370 97% 2881 CD LOAN REV. #2 2881-480-470210-353 AUDITING 0 1,000 1,000 100% 2881-480-470210-711 REDEVELOPMENT 0 100,000 100,000 100% TOTAL 2881 CD REV. #2 ------------ 0 ------------- 101,000 101,000 ------------ ------------ 100% 2886 CD MISC. 2886-480-470210-210 OFFICE SUPPLIES 0 900 900 100% 2886-480-470210-355 CDBG SENIOR CENTER 0 30,000 30,000 100% 2886-480-470210-396 GRANT SERVICES 9,634 25,000 15,366 61% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 0 2,000 2,000 100% 2886-480-470210-528 DATA PROCESSING TRANSFER 716 2,858 2,142 75% 2886-480-470210-532 OFFICE RENT 588 1,175 588 50% 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 200,000 200,000 100% TOTAL CD MISC. ------------ 10,938 ------------- 261,933 250,995 ------------------------ 96% 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 5,000 5,000 100% 2887-480-470210-750 REDEVELOPMENT LOANS 10 75,000 74,990 100% TOTAL RURAL DEVELOPMENT #1 10 98,000 97,990 100% 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 0 8,050 8,050 100% 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-03 0 2,200 2,200 100% 2888-480-470210-750 REDEVELOPMENT LOANS 0 50,000 50,000 100% TOTAL RURAL DEVELOPMENT #2 0 60,250 60,250 100% 2930 PRESERVE AMERICA GRANT 2930-480-470240-354 CONT SERV-NPS PRESERVE AMERICA 7,251 7,251 0- 0% TOTAL PRESERVE AMERICA GRNT ------------ 7,251 ------------- 7,251 0- ------------ ------------ 0% 2945 CDBG-ED FVCC #2 2945-480-470242-790 MACHINERY/EQUIPMENT-CDBG-ED-13-01 0 92,687 92,687 100% 2945-480-470242-820 ADMIN TRANSFER -to Com. Development 0 8,658 8,658 100% TOTAL 2945 CDBG-ED FVCC #2 ------------ 0 ------------- 101,345 101,345 ------------------------ 100% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 20 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD I FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 2955-480-470210-352 PERSONNEL -PETROLEUM 2955-480-470210-353 FRINGES -PETROLEUM 2955-480-470210-354 CONTRACTED SERVICES-PETROLUEM 2955-480-470210-373 TRAVEL -PETROLEUM 2955-480-470210-720 LOANS -PETROLEUM 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 2955-480-470215-352 PERSONNEL -HAZARDOUS SUBSTANCES 2955-480-470215-353 FRINGES -HAZARDOUS SUBSTANCES 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 2955-480-470215-720 LOANS -HAZARDOUS SUBSTANCES TOTAL BROWNFIELDS LOAN REV. 0 908 908 100% 0 15,703 15,703 100% 0 4,494 4,494 100% 0 53,011 53,011 100% 0 835 835 100% 0 100,000 100,000 100% 0 2,458 2,458 100% 0 46,602 46,602 100% 0 13,782 13,782 100% 195 569,546 569,351 100% 0 1,251 1,251 100% 0 60,000 60,000 100% 195 ------------ ------------- 868,590 868,395 ------------ ------------ 100% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 21 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD I FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN 2915-413-420140-218 SMALL EQUIP - STONEGARDEN TOTAL 2915 STONEGARDEN GRANT 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 2916-413-420140-121 OVERTIME 2916-413-420140-153 HEALTH INSURANCE 2916-413-420140-155 RETIREMENT 2916-413-420140-354 CONTRACT SERVICES 2919-413-420140-110 2919-413-420140-125 2919-413-420140-126 2919-413-420140-127 2919-413-420140-218 2919-413-420140-220 2919-413-420140-221 2919-413-420140-940 TOTAL 2916 DRUG ENFORCEMENT 2919 LAW ENFORCEMENT GRANT SALARIES - BENEFITS DUI TASK FORCE HOLIDAY OT REIMB (STEP GRT) SCHOOL DIST. OT JAG GRT/RADIOS/2013-DJ-BX-0803 EQUIPMENT -FUNDED BY DONATIONS Bullet Proof Vests EQUIPMENT (SRT CAMERA) TOTAL LAW ENF. GRANT 0 8,875 8,875 100% 0 8,875 8,875 100% 0 17,750 17,750 100% 14,305 62,519 48,214 77% 1,166 6,000 4,834 81% 2,543 15,264 12,721 83% 1,818 8,399 6,581 78% 1,362 5,200 3,838 74% 21,195 97,382 76,187 78% 747 41,602 40,855 98% 0 8,000 8,000 100% 8,067 38,800 30,733 79% 2,732 20,000 17,268 86% 0 25,562 25,562 100% 0 2,500 2,500 100% 853 43,600 42,747 98% 0 14,000 14,000 100% 12,398 194,064 181,666 94% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA gb8501_pg.php/Job No: 92526 1ST QUARTER FY15 FINANCIAL REPORT Page 22 of 33 USER: RGW 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD I FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CAPITAL PROJECT FUNDS 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 25,000 25,000 100% TOTAL 4290 WALK & CURB 0 25,000 25,000 100% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 23 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete ACCOUNT NUMBER FUND ACTUAL YTD BUDGET REMAINING % REMAINING IG/L (ACCOUNT NUMBER DESC. (FINAL ENTERPRISE FUNDS WATER REVENUE 5210-000-343210-000 METERED WATER SALES 1,045,507 2,800,000 1,754,493 63% 5210-000-343225-000 IMPACT FEES 79,002 266,000 186,998 70% 5210-000-343230-000 METER REPLACEMENT FEE 26,922 95,000 68,078 72% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 1,068 30,000 28,932 96% 5210-000-343270-000 WATER TURN ON FEES 630 2,500 1,870 75% 5210-000-343275-000 TAG FEE 4,180 7,500 3,320 44% 5210-000-343365-000 LATECOMER ADMIN FEE 0 14,000 14,000 100% 5210-000-371010-000 INVESTMENT EARNINGS 7,709 25,000 17,291 69% TOTAL WATER REVENUE 1,165,018 3,240,000 2,074,982 64% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 152,409 692,001 539,592 78% 5210-447-430550-111 SEASONAL SALARIES 687 5,000 4,313 86% 5210-447-430550-121 OVERTIME 4,684 20,000 15,316 77% 5210-447-430550-153 HEALTH INSURANCE 20,219 143,485 123,266 86% 5210-447-430550-155 RETIREMENT 11,235 49,146 37,911 77% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 2,284 11,000 8,716 79% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 1,053 8,500 7,447 88% 5210-447-430550-226 CHLORINE & CHEMICALS 11,169 38,000 26,831 71% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 225 4,500 4,275 95% 5210-447-430550-231 GAS & OIL 6,047 36,000 29,953 83% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 0 4,000 4,000 100% 5210-447-430550-336 LICENSES & FEES 50 18,000 17,950 100% 5210-447-430550-341 ELECTRICITY 32,636 139,000 106,364 77% 5210-447-430550-344 NATURAL GAS 487 13,000 12,513 96% 5210-447-430550-345 TELEPHONE & COMMUNICATION 1,323 9,000 7,677 85% 5210-447-430550-349 LAB SERVICES 2,568 22,000 19,432 88% 5210-447-430550-353 AUDITING 0 5,000 5,000 100% 5210-447-430550-354 CONTRACT SERVICES 3,402 55,000 51,598 94% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 5,091 25,000 19,909 80% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 5,529 15,000 9,471 63% 5210-447-430550-366 BUILDING MAINTENANCE 0 12,000 12,000 100% 5210-447-430550-373 DUES & TRAINING 193 9,000 8,807 98% 5210-447-430550-388 MEDICAL SERVICES 85 800 715 89% 5210-447-430550-410 CONSTRUCTION MATERIALS 7,753 35,000 27,247 78% 5210-447-430550-422 HYDRANTS 3,143 6,000 2,857 48% 5210-447-430550-423 MATERIALS FOR MAINS 4,497 10,000 5,503 55% 5210-447-430550-424 MATERIALS -SERVICE LINES 7,946 14,000 6,054 43% 5210-447-430550-425 MATERIALS PUMPS/WELLS 656 45,000 44,344 99% 5210-447-430550-510 PROPERTY & LIABILITY INS. 23,144 30,000 6,856 23% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 145 15,000 14,855 99% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 3,562 14,248 10,686 75% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 26,140 104,561 78,421 75% 5210-447-430550-528 DATA PROCESSING TRANSFER 5,731 22,864 17,133 75% 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 3,919 9,000 5,081 56% 5210-447-430550-935 ARMORY WELL SHEEPHERDERS TANK MIXER 0 20,000 20,000 100% 5210-447-430550-936 Noffsinger Spring Generator 0 90,000 90,000 100% 5210-447-430550-937 Sheepherder Res. SCADA Backup PWR 0 15,851 15,851 100% 5210-447-430550-938 Lower Zone Reservoir Improvements 0 60,000 60,000 100% 5210-447-430550-947 US 93N. UTILITY RELOCATE 0 27,343 27,343 100% 5210-447-430550-948 METERS (METER FUNDS) 010125 0 120,000 120,000 100% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 24 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET I REMAINING % REMAINING 5210-447-430550-950 4TH AVE EN MAIN REPLACEMENT 439,471 798,620 359,149 45% 5210-447-430550-951 SECURITY SCADA UPGRADES 0 15,000 15,000 100% 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 0 174,000 174,000 100% 5210-447-430550-967 2ND AVE WN MAIN REPLC FROM MT TO WA 0 275,000 275,000 100% 5210-447-430550-968 DEPOT WELL REVITALIZATION 0 15,000 15,000 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 75,000 75,000 100% 5210-447-430555-941 METERS (NEW SERVICES)010120 0 35,600 35,600 100% SUBTOTAL WATER FACILITIES 787,484 3,361,519 2,574,035 77% 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 BOND PRIN-HWY 93 S WTR-2004 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 5210-447-490206-610 PRIN-MTR&WELL WRF7104 1.25%;WRF8114 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25%;WRF8114 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2%/IDAHO&MAI 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN SUBTOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 17,721 88,558 70,837 80% 1,997 24,590 22,593 92% 1,316 6,527 5,211 80% 17 2,000 1,983 99% 0 2,020 2,020 100% 0 1,500 1,500 100% 3,946 35,000 31,054 89% 25 1,500 1,475 98% 1,878 7,511 5,633 75% 5,731 22,864 17,133 75% 3,919 7,838 3,919 50% 36,550 199,908 163,358 82% 0 60,000 60,000 100% 34,275 34,275 0 0% 350 300 50- -17% 0 258,000 258,000 100% 27,904 27,905 1 0% 0 46,000 46,000 100% 6,070 6,070 0 0% 68,599 432,550 363,951 84% 0 840,000 840,000 100% 0 840,000 840,000 100% 892,633 4,833,977 3,941,344 82% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 25 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-343310-000 SEWER SERVICE CHARGES 1,184,660 4,200,000 3,015,341 72% 5310-000-343330-000 IMPACT FEES (SANITARY) 73,518 160,000 86,482 54% 5310-000-343335-000 IMPACT FEES (WWTP) 96,088 220,000 123,912 56% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 953 5,000 4,047 81% 5310-000-371010-000 INVESTMENT EARNINGS 10,531 33,500 22,969 69% TOTAL SEWER REVENUE 1,365,750 4,618,500 3,252,750 70% SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 15,408 72,402 56,994 79% 5310-454-430620-153 HEALTH INSURANCE 1,700 18,916 17,216 91% 5310-454-430620-155 RETIREMENT 1,143 5,324 4,181 79% 5310-454-430620-215 OFFICE SUPPLIES/computers 20 2,000 1,980 99% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 4,850 4,850 100% 5310-454-430620-355 BILLING COSTS 3,983 35,000 31,017 89% 5310-454-430620-373 DUES & TRAINING 25 1,500 1,475 98% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 1,669 6,677 5,008 75% 5310-454-430620-528 DATA PROCESSING TRANSFER 5,731 22,864 17,133 75% 5310-454-430620-532 OFFICE RENT 3,919 7,838 3,919 50% SUBTOTAL SEWER BILLING COSTS 33,599 177,371 143,772 81% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 54,683 267,495 212,812 80% 5310-454-430630-121 OVERTIME 48 5,500 5,452 99% 5310-454-430630-153 HEALTH INSURANCE 8,602 56,777 48,175 85% 5310-454-430630-155 RETIREMENT 3,949 17,852 13,903 78% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 1,770 9,200 7,430 81% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 196 6,500 6,304 97% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 269 2,000 1,731 87% 5310-454-430630-231 GAS & OIL 3,125 11,500 8,375 73% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 400 400 100% 5310-454-430630-341 ELECTRICITY 6,850 54,500 47,650 87% 5310-454-430630-344 NATURAL GAS 1,923 14,500 12,577 87% 5310-454-430630-345 TELEPHONE & COMMUNICATION 2,720 23,000 20,280 88% 5310-454-430630-353 AUDITING 0 3,000 3,000 100% 5310-454-430630-354 CONTRACT SERVICES 502 24,000 23,498 98% 5310-454-430630-356 CONSULTANTS 0 8,000 8,000 100% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 717 5,000 4,283 86% 5310-454-430630-373 DUES & TRAINING 0 3,000 3,000 100% 5310-454-430630-388 MEDICAL SERVICES 0 800 800 100% 5310-454-430630-410 CONSTRUCTION MATERIALS 1,442 9,000 7,558 84% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 914 50,000 49,086 98% 5310-454-430630-510 PROPERTY & LIABILITY INS. 58,207 67,891 9,684 14% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 4,967 20,000 15,033 75% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 1,822 7,288 5,466 75% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 14,801 29,205 14,404 49% 5310-454-430630-528 DATA PROCESSING TRANSFER 2,866 11,432 8,566 75% 5310-454-430630-532 OFFICE RENT 3,919 7,838 3,919 50% 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 0 30,000 30,000 100% 5310-454-430630-920 Install Lift Station Enclosure 0 23,000 23,000 100% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 26 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET I REMAINING % REMAINING 5310-454-430630-947 HWY 93 N BYPASS UTILITY RELOCATE DE 0 2,067 2,067 100% 5310-454-430630-950 BACKUP GENERATOR FOR LS # 11 0 22,259 22,259 100% 5310-454-430630-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 91,559 107,000 15,441 14% 5310-454-430630-952 PETERSON SCHOOL ALLEY REPLACEMENT 0 119,000 119,000 100% 5310-454-430630-953 BY-PASS PUMP GRANDVIEW LIFT STATION 0 62,500 62,500 100% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 20,000 20,000 100% 5310-454-430630-959 2ND ALLEY E REPLACEMENT 0 140,000 140,000 100% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 1,110 50,000 48,890 98% SUBTOTAL SEWER COLLECTION 266,961 1,291,504 1,024,543 79% IMPACT FEES 5310-454-430635-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 5310-454-430635-957 GRANDVIEW PUMP STA/GRAVITY MAIN 52% 5310-454-430635-958 SPRING CREEK INTERCEPTOR DESIGN SUBTOTAL IMPACT FEE EXPENSE REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION -SANITARY SUBTOTAL SANITARY SEWER WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 5310-455-430640-111 SEASONAL SALARIES 5310-455-430640-121 OVERTIME 5310-455-430640-153 HEALTH INSURANCE 5310-455-430640-155 RETIREMENT 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 5310-455-430640-225 ALUM 5310-455-430640-226 CHLORINE & CHEMICALS 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 5310-455-430640-231 GAS & OIL 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 5310-455-430640-336 LICENSES & FEES 5310-455-430640-341 ELECTRICITY 5310-455-430640-342 WATER 5310-455-430640-344 NATURAL GAS 47,435 208,000 160,565 77% 0 247,640 247,640 100% 13,269 145,000 131,731 91% 37,068 405,000 367,932 91% 97,771 1,005,640 907,869 90% 0 78,000 78,000 100% 18,889 18,889 0 0% 0 300 300 100% 18,889 97,189 78,300 81% 0 820,000 820,000 100% 0 820,000 820,000 100% 383,621 3,214,333 2,830,712 88% 78,536 384,625 306,089 80% 687 5,000 4,313 86% 4,807 21,500 16,693 78% 10,267 65,237 54,970 84% 6,028 26,065 20,037 77% 1,500 10,000 8,500 85% 293 2,700 2,407 89% 0 20,000 20,000 100% 1,104 16,000 14,896 93% 741 7,000 6,259 89% 3,079 18,500 15,421 83% 36 350 314 90% 0 11,000 11,000 100% 29,437 172,000 142,563 83% 737 6,150 5,413 88% 2,758 55,000 52,242 95% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 27 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD (FINAL BUDGET I REMAINING % REMAINING 5310-455-430640-345 TELEPHONE & COMMUNICATION 494 5,000 4,506 90% 5310-455-430640-353 AUDITING 0 4,000 4,000 100% 5310-455-430640-354 CONTRACT -GLACIER GOLD 22,501 124,000 101,499 82% 5310-455-430640-355 OTHER CONTRACT SERVICES 6,549 30,000 23,451 78% 5310-455-430640-356 CONSULTANTS 4,974 95,000 90,026 95% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 5310-455-430640-360 MISC. MAINT SERVICES 3,410 30,000 26,590 89% 5310-455-430640-366 BUILDING MAINTENANCE 370 30,000 29,630 99% 5310-455-430640-373 DUES & TRAINING 1,890 7,500 5,610 75% 5310-455-430640-388 MEDICAL SERVICES 0 600 600 100% 5310-455-430640-510 PROPERTY & LIABILITY INS. 37,695 38,320 625 2% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 4,380 17,519 13,139 75% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 29,159 116,638 87,479 75% 5310-455-430640-528 DATA PROCESSING TRANSFER 4,298 17,148 12,850 75% 5310-455-430640-920 BUILDINGS 348 59,000 58,652 99% 5310-455-430640-940 MACHINERY & EQUIPMENT 0 60,000 60,000 100% SUBTOTAL WWTP OPERATIONS 256,079 1,470,852 1,214,773 83% WWTP BONDED PROJECT 5310-455-430644-935 WWTP- REPLACEMENT (10125) SUBTOTAL WWTP BONDED WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST 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 DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% SUBTOTAL DEBT SERVICE - WWTP CITY/EVERGREEN REQUIREMENTS: 4,570 45,000 40,430 90% 4,570 45,000 40,430 90% 5,179 100,000 94,821 95% 316,528 615,610 299,082 49% 0 238,000 238,000 100% 321,707 953,610 631,903 66% 27,425 134,177 106,752 80% 4,434 28,108 23,674 84% 1,976 8,891 6,915 78% 1,195 4,500 3,305 73% 1,415 2,500 1,085 43% 1,028 7,500 6,472 86% 4,017 20,000 15,983 80% 700 4,000 3,300 83% 640 2,700 2,060 76% 42,830 212,376 169,546 80% 0 761,000 761,000 100% 251,235 251,235 0 0% 0 48,000 48,000 100% 36,330 36,330 0 0% 287,565 1,096,565 809,000 74% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 28 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete ACCOUNT NUMBER FUND ACTUAL YTD BUDGET REMAINING % REMAINING IG/L (ACCOUNT NUMBER DESC. IFINAL I 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 912,750 5,615,002 4,702,252 84% TOTAL BILLING/SANITARY/WWTP 1,329,969 9,006,706 7,676,737 85% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 29 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING STORM SEWER REVENUE 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 2,765 2,500 265- -11% 5349-000-343033-000 IMPACT FEES 36,457 150,000 113,543 76% 5349-000-343034-000 PERMIT FEES 150 0 150- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 0 830,000 830,000 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 581 2,000 1,419 71% 5349-000-371010-000 INTEREST ON INVESTMENTS 3,760 8,000 4,240 53% TOTAL STORM REVENUE 43,714 993,500 949,786 96% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 74,763 350,378 275,615 79% 5349-453-430246-121 OVERTIME 48 4,000 3,952 99% 5349-453-430246-153 HEALTH INSURANCE 10,871 71,561 60,690 85% 5349-453-430246-155 RETIREMENT 5,426 25,139 19,713 78% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 4,197 10,100 5,903 58% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 0 3,500 3,500 100% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 52 2,200 2,148 98% 5349-453-430246-231 GAS & OIL 3,094 11,500 8,406 73% 5349-453-430246-345 TELEPHONE & COMMUNICATION 88 800 712 89% 5349-453-430246-353 AUDITING 0 2,340 2,340 100% 5349-453-430246-354 CONTRACT SERVICE 423 6,000 5,577 93% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 0 25,000 25,000 100% 5349-453-430246-357 IMPACT FEE UPDATE 0 7,500 7,500 100% 5349-453-430246-358 CONSULTANTS 0 7,000 7,000 100% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 15,000 15,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 909 2,500 1,591 64% 5349-453-430246-362 GROUNDWATER MONITORING 0 10,000 10,000 100% 5349-453-430246-371 CURB & GUTTER 0 7,000 7,000 100% 5349-453-430246-373 DUES & TRAINING 0 3,500 3,500 100% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 0 10,000 10,000 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 4,464 7,982 3,518 44% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 1,822 7,287 5,465 75% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 8,588 34,352 25,764 75% 5349-453-430246-528 DATA PROCESSING TRANSFER 2,149 8,574 6,425 75% 5349-453-430246-530 BNSF LEASE PMT 0 5,700 5,700 100% 5349-453-430246-532 OFFICE RENT 3,919 7,838 3,919 50% 5349-453-430246-840 MACI GRANT MATCH (SWEEPER) 0 42,264 42,264 100% 5349-453-430246-951 9TH ST E STORMWATER IMPRV 143,028 200,000 56,972 28% 5349-453-430246-952 STORM DRAIN CORRECTION 10,380 100,000 89,620 90% 5349-453-430246-953 WILLOWS CORRECTION 186 82,977 82,791 100% 5349-453-430246-954 S MEADOWS PHASE 3 0 300,000 300,000 100% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 186,000 186,000 100% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 130,000 130,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 5,500 5,500 100% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 100% TOTAL STORM 274,407 1,978,592 1,704,185 86% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 30 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 0 920,000 920,000 100% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 2,329 20,000 17,671 88% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 736 2,500 1,764 71% 5510-000-371010-000 INVESTMENT EARNINGS 1,139 3,000 1,861 62% 5510-000-381050-000 INCEPTION OF LEASE 0 200,000 200,000 100% TOTAL SOLID WASTE REVENUE 4,204 ------------ 1,145,500 ------------- 1,141,296 ------------ 100% ------------ SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 88,257 401,583 313,326 78% 5510-460-430840-121 OVERTIME 969 5,500 4,531 82% 5510-460-430840-153 HEALTH INSURANCE 14,070 85,694 71,624 84% 5510-460-430840-155 RETIREMENT 6,383 28,541 22,158 78% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 0 9,500 9,500 100% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 0 35,000 35,000 100% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 462 5,500 5,038 92% 5510-460-430840-231 GAS & OIL 10,703 59,000 48,297 82% 5510-460-430840-341 ELECTRICITY 165 1,900 1,735 91% 5510-460-430840-344 NATURAL GAS 100 4,200 4,100 98% 5510-460-430840-345 TELEPHONE & COMMUNICATION 57 850 793 93% 5510-460-430840-354 CONTRACT SERVICES 286 9,000 8,714 97% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 260 5,700 5,440 95% 5510-460-430840-366 BUILDING MAINTENANCE 0 2,500 2,500 100% 5510-460-430840-373 DUES & TRAINING 0 3,500 3,500 100% 5510-460-430840-388 MEDICAL SERVICES 330 650 320 49% 5510-460-430840-510 PROPERTY & LIABILITY INS. 9,218 10,600 1,382 13% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 6,500 6,500 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 14,947 59,786 44,839 75% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 8,371 33,484 25,113 75% 5510-460-430840-528 DATA PROCESSING TRANSFER 2,149 8,574 6,425 75% 5510-460-430840-532 OFFICE RENT 3,919 7,838 3,919 50% 5510-460-430840-610 DEBT SERVICE PRINCIPAL 0 20,000 20,000 100% 5510-460-430840-620 DEBT SERVICE INTEREST 0 2,000 2,000 100% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 0 25,000 25,000 100% 5510-460-430840-944 VEHICLES (Replacement $) 838 123,381 122,543 99% 5510-460-430845-224 JANITORIAL SUPPLIES 0 250 250 100% 5510-460-430845-341 ELECTRICITY 346 4,000 3,654 91% 5510-460-430845-342 WATER 33 500 467 93% 5510-460-430845-344 NATURAL GAS 79 6,500 6,421 99% 5510-460-430845-360 REPAIR & MAINT SERVICES 33 3,500 3,467 99% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% TOTAL SOLID WASTE EXPENSE 161,973 ------------ 1,120,531 ------------- 958,558 ------------ ------------ 86% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 31 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 3,823 10,000 6,177 62% 5160-000-343069-000 HANGER LEASES 3,000 11,000 8,000 73% 5160-000-343071-000 HANGAR SITE LEASES 18,034 17,510 524- -3% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 4,455 17,734 13,279 75% 5160-000-343102-000 GROUND LEASES 12,441 12,078 363- -3% 5160-000-343620-000 FUEL TAX 1,972 5,000 3,028 61% 5160-000-365010-000 MISC REVENUE 2,044 0 2,044- 0% 5160-000-371010-000 INVESTMENT EARNINGS 197 500 303 61% TOTAL AIRPORT REVENUE 5160 AIRPORT EXPENSES 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-356 CONTRACT SERVICES -SNOW REMOVAL 5160-430-430310-362 REPAIR & MAINTENANCE 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 TOTAL AIRPORT EXPENSES 45,965 73,822 27,857 38% 0 1,000 1,000 100% 253 1,500 1,247 83% 0 180 180 100% 6,000 36,000 30,000 83% 0 5,000 5,000 100% 444 2,000 1,556 78% 70 2,500 2,430 97% 423 13,000 12,577 97% 1,367 5,469 4,102 75% 358 1,429 1,071 75% 0 97,918 97,918 100% 8,916 ------------------------- 165,996 157,080 ------------------------ 95% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 32 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete 'L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 35,000 70,000 35,000 50% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 0 170,000 170,000 100% 6030-000-364030-000 SALE OF MISCELLANEOUS 0 100 100 100% 6030-000-371010-000 INVESTMENT EARNINGS 214 1,000 786 79% 6030-000-393000-000 INTERNAL SERVICES -DATA 39,044 155,763 116,719 75% TOTAL INFORMATION TECH REVENUE 74,258 ------------ 396,863 ------------- 322,605 ------------ 81% ------------ INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 30,765 140,566 109,801 78% 6030-401-410580-121 OVERTIME 0 2,500 2,500 100% 6030-401-410580-153 HEALTH INSURANCE 4,655 32,454 27,799 86% 6030-401-410580-155 RETIREMENT 2,333 10,538 8,205 78% 6030-403-410580-215 COMPUTER SUPPLIES 422 2,400 1,978 82% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 1,875 16,907 15,032 89% 6030-403-410580-325 WEBSITE 193 3,000 2,807 94% 6030-403-410580-345 PAGER/PHONE 0 2,245 2,245 100% 6030-403-410580-346 SUMMITNET & ISPS 534 6,638 6,104 92% 6030-403-410580-353 LASER FICHE MAINTENANCE 4,032 4,200 168 4% 6030-403-410580-354 MAINTENANCE CONTRACTS 16,518 30,435 13,917 46% 6030-403-410580-355 LICENSES 1,493 15,300 13,807 90% 6030-403-410580-357 GRANICUS 3,300 7,200 3,900 54% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 1,437 10,000 8,563 86% 6030-403-410580-373 DUES & TRAINING 50 5,950 5,900 99% 6030-403-410580-510 INSURANCE 1,817 1,778 39- -2% 6030-403-410583-218 TV -Video Equipment & programming 15- 3,950 3,965 100% 6030-403-410583-354 TV -Video Contract Services 400 2,500 2,100 84% 6030-403-410585-229 COPIER,FAX, SUPPLIES 0 23,000 23,000 100% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 3,984 80,000 76,016 95% 6030-403-410585-532 COPIER LEASES 4,709 20,000 15,291 76% 6030-403-410585-942 Servers - capital contingency 14,831 38,500 23,669 61% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-405-410588-940 COMPUTERS - SWITCHES 12,244 0 12,244- 0% 6030-410-410588-218 COMPUTERS - DPW 0 2,725 2,725 100% 6030-413-410588-218 COMPUTERS - POLICE DEPT 0 15,755 15,755 100% 6030-416-410580-940 FIRE DEPT. COMPUTERS 0 27,244 27,244 100% 6030-416-410588-218 COMPUTERS - FIRE 0 5,065 5,065 100% 6030-436-410588-218 COMPUTERS - PARKS 0 5,310 5,310 100% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 900 900 100% TOTAL INFORMATION TECH EXPENSE 105,576 522,060 416,484 80% 10.15.2014 15:28 THE CITY OF KALISPELL, MONTANA Page 33 of 33 gb8501_pg.php/Job No: 92526 USER: RGW 1ST QUARTER FY15 FINANCIAL REPORT 25.00 % Yr Complete IG/L ACCOUNT NUMBER FUND (ACCOUNT NUMBER DESC. ACTUAL YTD IFINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 122,690 489,770 367,080 75% 6010-000-371010-000 INVESTMENT EARNINGS 6 200 194 97% TOTAL CENTRAL GARAGE REVENUE 122,696 489,970 367,274 751 CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 36,647 161,690 125,043 77% 6010-410-431330-121 OVERTIME 827 2,000 1,173 59% 6010-410-431330-153 HEALTH INSURANCE 4,271 27,132 22,861 84% 6010-410-431330-155 RETIREMENT 2,525 11,383 8,858 78% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 3,951 7,250 3,299 46% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 1,590 7,500 5,910 79% 6010-410-431330-230 OIL 5,540 25,000 19,460 78% 6010-410-431330-231 GAS 137 3,000 2,863 95% 6010-410-431330-232 VEHICLE PARTS 21,869 91,000 69,131 76% 6010-410-431330-233 TIRES 2,752 35,000 32,248 92% 6010-410-431330-238 FILTERS 5- 7,700 7,705 100% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 0 2,000 2,000 100% 6010-410-431330-341 ELECTRICITY 264 1,900 1,636 86% 6010-410-431330-344 NATURAL GAS 123 7,400 7,277 98% 6010-410-431330-354 CONTRACT SERVICES 2,544 31,000 28,456 92% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 1,016 2,000 984 49% 6010-410-431330-373 DUES & TRAINING 2,460 6,200 3,740 60% 6010-410-431330-388 MEDICAL SERVICES 0 300 300 100% 6010-410-431330-510 INSURANCE 2,347 3,000 653 22% 6010-410-431330-528 INFORMATION TECH TRANSFER 1,433 5,716 4,283 75% 6010-410-431330-944 VEHICLE -SERVICE TRUCK 37,000 45,000 8,000 18% TOTAL CENTRAL GARAGE EXPENSES 127,290 483,171 355,881 74%