Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
3rd Quarter Finance Report
4 Date April 21, 2011 TO: Mayor Fisher & City Council members Jane Howington, City Manager From: Amy Robertson Finance Director City of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 RE: 3rd Qtr Finance Report — FY2011 Year 75% complete Please find attached the printouts reflecting the activity thru April 21, 2011. Expenditures include the payroll period ending April 9th. Most all departments have 23% remaining for payroll which would be correct — 6 payrolls (less 1 day) remain in the fiscal year. Health insurance is booked for April so the reports will reflect 17% remaining. Most of March's bills have been paid as this report includes accounts payable posted today. Please feel free to call with any questions. 758-7755. 04/21/11 CITY OF KALISPELL Page 1 Quarterly Finance Report April 21, 2011 83.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,465,480 4,448,257 1,982,777 45% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 7,761 7,818 57 1% 1000-000-311200-000 PERSONAL PROPERTY TAXES 209,648 250,000 40,352 16% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 28,568 25,000 3,568- -14% 1000-000-322101-000 BEER & LIQUOR LICENSES 1,490 24,381 22,891 94% 1000-000-322300-000 BUSINESS LICENSES 1,206 1,200 6- -1% 1000-000-322500-000 AMUSEMENT LICENSES 300 600 300 50% 1000-000-323012-000 PLANNING FEES 15,520 65,000 49,481 76% 1000-000-323107-000 EXCAV/DEMO/AIR/HOUSE MOVING PERMITS 0 500 500 100% 1000-000-323109-000 SITE REVIEW 6,129 8,500 2,371 28% 1000-000-323300-000 ANIMAL LICENSES 730 900 170 19% 1000-000-335030-000 M.V. TAX - AD VALOREM 1,720 2,100 380 18% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 61,075 58,850 2,225- -4% 1000-000-335110-000 LIVE CARD TABLE PERMIT 3,600 2,650 950- -36% 1000-000-335230-000 HB124 ENTITLEMENT 1,634,814 2,272,379 637,565 28% 1000-000-341020-000 ADMINISTRATIVE CHARGES 434,328 490,321 55,993 11% 1000-000-341022-000 BOND FEES/ADMIN.CHG. 35,000 30,000 5,000- -17% 1000-000-341025-000 CITY COLLECTIONS 851 1,500 649 43% 1000-000-341027-000 BRESNAN FRANCHISE FEES 78,841 152,000 73,159 48% 1000-000-342010-000 POLICE SERVICES 16,555 15,000 1,555- -10% 1000-000-342014-000 RESOURCE OFFICERS 86,000 86,000 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 2,972 10,000 7,028 70% 1000-000-342024-000 EPA GRANT -FIRE DEPT DIRECT REIMB. 0 20,000 20,000 100% 1000-000-342025-000 FIRE ENGINE RESPONSE FEE 50 6,500 6,450 99% 1000-000-343005-000 CENTRAL GARAGE CHARGE 101,309 118,000 16,691 14% 1000-000-351000-000 CITY COURT FINES & FEES 381,850 475,000 93,150 20% 1000-000-351016-000 DUI COURT FINE 3,490 0 3,490- 0% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 24,059 28,000 3,941 14% 1000-000-362010-000 CITY GOLF COURSE LEASE 0 25,000 25,000 100% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 870 3,000 2,130 71% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 5,327 500 4,827- -965% 1000-000-365015-000 CONTRIBUTION FRM KIDSPORT 0 44,000 44,000 100% 1000-000-371010-000 INVESTMENT EARNINGS 25,558 55,000 29,442 54% 1000-000-381050-000 INCEPTION OF LEASE -POLICE CARS 0 80,850 80,850 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 290,000 514,326 224,326 44% TOTAL REVENUE ----------- 5,925,098 ----------- 9,323,132 --------------------- 3,398,034 36% 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 1,400 1,000 400- -40% 1000-400-410530-353 AUDITING 10,000 10,500 500 5% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,891 3,000 109 4% 1000-400-410560-312 POSTAGE 10,671 18,000 7,329 41% 1000-400-410560-320 PRINTING 2,527 5,850 3,323 57% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,788 3,500 712 20% 1000-400-420000-354 CONTRACT 911 CENTER 176,133 352,266 176,133 50% 1000-400-460446-354 KIDSPORT LEASE 42,910 44,000 1,090 2% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-460452-920 CONRAD MANSION BUILDING IMPROVEMENT 2,500 2,500 0 0% 1000-400-510300-000 CONTINGENCY 6,500 28,231 21,731 77% 1000-400-510300-820 LOAN TO PARKING COMMISSION 0 15,000 15,000 100% 1000-400-510310-354 ICMA PLAN FEES 375 500 125 25% 1000-400-510330-513 LIABILITY INSURANCE 236,592 247,000 10,408 4% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 24,749 30,000 5,251 18% 1000-400-510330-517 PROPERTY INSURANCE 36,083 50,000 13,917 28% ----------- SUBTOTAL GEN.GOV'T. 577,719 ----------- 832,947 --------------------- 255,228 31% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 95,154 129,038 28,884 23% 1000-401-410210-153 HEALTH INSURANCE 11,475 13,770 2,295 17% 1000-401-410210-155 RETIREMENT 10,108 13,350 3,242 24% 1000-401-410210-215 COMPUTER SOFTWARE/SUPPLIES 158 300 142 47% 1000-401-410210-229 OTHER SUPPLIES 20 850 830 98% 1000-401-410210-312 NEWSLETTER 0 500 500 100% 1000-401-410210-335 MEMBERSHIP & DUES 940 2,000 1,060 53% 1000-401-410210-345 TELEPHONE & COMMUNICATION 43 400 357 89% 1000-401-410210-373 SCHOOL & TRAVEL 394 1,000 606 61% 1000-401-410210-379 MEETINGS 220 500 280 56% ----------- SUBTOTAL CITY MANAGER 118,512 ----------- 156,708 --------------------- 38,196 24% HUMAN RESOURCES 1000-401-410830-110 SALARIES -PERSONNEL 79,790 103,338 23,548 23% 1000-401-410830-153 HEALTH INSURANCE 12,696 15,236 2,540 17% 1000-401-410830-155 RETIREMENT 5,205 6,700 1,495 22% 1000-401-410830-210 OFFICE SUPPLIES 0 300 300 100% 1000-401-410830-215 COMPUTER SUPPLIES 0 300 300 100% 1000-401-410830-218 SMALL OFFICE EQUIP/FURNITURE 48 200 152 76% 1000-401-410830-229 OTHER SUPPLIES 18 200 182 91% 1000-401-410830-320 PRINTING 0 100 100 100% 1000-401-410830-322 BOOKS 0 150 150 100% 1000-401-410830-335 MEMBERSHIP & DUES 525 400 125- -31% 1000-401-410830-338 RECRUITMENT 1,983 3,500 1,517 43% 1000-401-410830-345 TELEPHONE 20 150 130 87% 1000-401-410830-354 CONTRACT SERVICES (ARBITRATION) 272 100 172- -172% 1000-401-410830-373 SCHOOL & TRAVEL 2,682 3,500 818 23% ----------- SUBTOTAL HUMAN RESOURCES 103,239 ----------- 134,174 --------------------- 30,935 23% Page 2 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- MEDIA SPECIALIST 1000-401-410900-110 MEDIA SPECIALIST -salary 15,092 20,102 5,010 25% 1000-401-410900-153 HEALTH INSURANCE 6,311 8,190 1,879 23% 1000-401-410900-155 RETIREMENT 1,015 1,299 284 22% 1000-401-410900-218 EQUIPMENT 60- 3,000 3,060 102% 1000-401-410900-354 CONTRACT SERVICES 1,750 2,500 750 30% SUBTOTAL MEDIA SPECIALIST ----------- 24,108 ----------- 35,091 --------------------- 10,983 31% MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 48,532 63,162 14,630 23% 1000-402-410100-153 HEALTH INSURANCE 26,450 31,815 5,365 17% 1000-402-410100-155 RETIREMENT 2,240 2,432 192 8% 1000-402-410100-210 OFFICE SUPPLIES 29 100 71 71% 1000-402-410100-335 MEMBERSHIP & DUES 4,267 4,811 544 11% 1000-402-410100-345 TELEPHONE & COMMUNICATION 0 100 100 100% 1000-402-410100-354 CONTRACT SERVICES 25 0 25- 0% 1000-402-410100-373 SCHOOL & TRAVEL 2,974 3,000 26 1% 1000-402-410100-379 MEETINGS 44 300 256 85% SUBTOTAL MAYOR/COUNCIL ----------- 84,561 ----------- 105,720 --------------------- 21,159 20% CITY CLERK 1000-402-410150-110 SALARIES/CITY CLERK 61,720 80,620 18,900 23% 1000-402-410150-121 OVERTIME 212 500 288 58% 1000-402-410150-153 HEALTH INSURANCE 7,778 9,446 1,668 18% 1000-402-410150-155 RETIREMENT 4,031 5,049 1,019 20% 1000-402-410150-210 OFFICE SUPPLIES 99 150 51 34% 1000-402-410150-229 OTHER SUPPLIES 0 50 50 100% 1000-402-410150-335 MEMBERSHIP & DUES 225 275 50 18% 1000-402-410150-345 TELEPHONE & COMMUNICATION 339 400 61 15% 1000-402-410150-352 RECODIFICATION 3,196 3,500 304 9% 1000-402-410150-354 CONTRACT SERVICES 25 25 0 0% SUBTOTAL CITY CLERK ----------- 77,626 ----------- 100,015 --------------------- 22,389 22% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 146,283 191,986 45,703 24% 1000-403-410550-153 HEALTH INSURANCE 26,685 30,604 3,919 13% 1000-403-410550-155 RETIREMENT 9,545 12,431 2,886 23% 1000-403-410550-322 BOOKS 205 300 95 32% 1000-403-410550-335 MEMBERSHIP & DUES 867 1,000 133 13% 1000-403-410550-345 TELEPHONE & COMMUNICATION 0 100 100 100% 1000-403-410550-353 CONTRACT SERVICES 1,241 1,000 241- -24% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 630 1,500 870 58% 1000-403-410550-355 BANK CHARGES & FEES 2,674 3,000 326 11% 1000-403-410550-373 SCHOOL & TRAVEL 490 2,500 2,010 80% SUBTOTAL FINANCE ----------- 188,620 ----------- 244,421 --------------------- 55,801 23% Page 3 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 4 Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 237,282 307,944 70,662 23% 1000-404-411110-153 HEALTH INSURANCE 40,832 48,958 8,126 170 1000-404-411110-155 RETIREMENT 15,479 19,972 4,493 23% 1000-404-411110-210 OFFICE SUPPLIES 343 1,200 857 71% 1000-404-411110-215 COMPUTER SUPPLIES 732 2,000 1,268 63% 1000-404-411110-322 BOOKS, CDs, LEXIS 6,691 7,000 309 4% 1000-404-411110-335 MEMBERSHIP & DUES 1,635 2,500 865 35% 1000-404-411110-345 TELEPHONE & COMMUNICATION 666 1,200 534 44% 1000-404-411110-354 CONTRACT SERVICES 376 5,000 4,624 92% 1000-404-411110-373 SCHOOL & TRAVEL 813 2,000 1,187 59% SUBTOTAL CITY ATTORNEY ----------- 304,850 ---------------------- 397,774 ---------- 92,924 23% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 151,185 198,530 47,345 24% 1000-406-410360-121 OVERTIME 6 250 244 98% 1000-406-410360-153 HEALTH INSURANCE 32,769 38,881 6,112 16% 1000-406-410360-155 RETIREMENT 9,873 12,871 2,998 23% 1000-406-410360-210 OFFICE SUPPLIES 729 1,000 271 27% 1000-406-410360-213 OFFICE EQUIPMENT 2,628 1,000 1,628- -163% 1000-406-410360-215 COMPUTER SUPPLIES 822 1,000 179 18% 1000-406-410360-229 OTHER SUPPLIES 456 1,500 1,044 70% 1000-406-410360-320 PRINTING 271 500 229 46% 1000-406-410360-335 MEMBERSHIP & DUES 240 300 60 20% 1000-406-410360-345 TELEPHONE & COMMUNICATION 886 1,400 514 37% 1000-406-410360-353 SECURITY & TECHNOLOGY 27,914 40,000 12,086 30% 1000-406-410360-354 CONTRACT SERVICES 6,273 5,750 523- -9% 1000-406-410360-373 SCHOOL & TRAVEL 1,768 6,000 4,232 71% 1000-406-410360-394 JURY & WITNESS FEES 3,976 5,750 1,774 31% 1000-406-410360-395 DRUG COURT 343 1,000 657 66% 1000-406-410360-396 DUI COURT INCENTIVES & MISC 603 0 603- 0% SUBTOTAL COURT ---------------------- 240,742 ----------- 315,732 ---------- 74,990 24% DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 13,227 16,919 3,692 22% 1000-410-430100-112 SEVERANCE 1,270 0 1,270- 0% 1000-410-430100-153 HEALTH INSURANCE 2,417 2,901 484 17% 1000-410-430100-155 RETIREMENT 832 1,095 263 24% 1000-410-430100-210 OFFICE SUPPLIES 660 775 115 15% 1000-410-430100-213 SMALL OFFICE EQUIPMENT 640 150 490- -327% 1000-410-430100-215 COMPUTER SUPPLIES 152 300 148 49% 1000-410-430100-216 COMPUTER EQUIPMEMT/SUPPLIES 169 350 181 52% 1000-410-430100-229 OTHER SUPPLIES 199 350 151 43% 1000-410-430100-331 PUBLICATION & FILING FEES 242 300 58 19% 1000-410-430100-335 MEMBERSHIP & DUES 313 350 38 11% 1000-410-430100-345 TELEPHONE & COMMUNICATION 40 1,000 960 96% 1000-410-430100-354 CONTRACT SERVICES 154 150 4- -3% 1000-410-430100-373 SCHOOL & TRAVEL 74 400 326 82% SUBTOTAL ADMINISTRATION ---------------------- 20,390 ----------- 25,040 ---------- 4,650 190 CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 120,717 178,259 57,542 32% 1000-410-431330-112 SALARIES -RETIREMENT 5,379 5,500 121 2% 1000-410-431330-121 OVERTIME 1,664 1,500 164- -11% 1000-410-431330-153 HEALTH INSURANCE 22,218 37,356 15,138 41% 1000-410-431330-155 RETIREMENT 7,915 10,935 3,020 28% 1000-410-431330-210 OFFICE SUPPLIES 393 300 93- -31% 1000-410-431330-215 COMPUTER SUPPLIES 537 800 263 33% 1000-410-431330-218 EQUIPMENT (non -capital) 0 700 700 100% 1000-410-431330-221 SAFETY EQUIP & SUPPLIES 220 250 30 12% 1000-410-431330-229 OTHER SUPPLIES 4,631 3,600 1,031- -29% 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 1000-410-431330-231 GAS & OIL 100,101 122,500 22,399 18% 1000-410-431330-232 MOTOR VEHICLE PARTS. 64,212 76,000 11,788 16% 1000-410-431330-233 TIRES AND RELATED PARTS 20,842 27,000 6,158 23% 1000-410-431330-238 FILTERS & MISC. PARTS 4,009 3,500 509- -15% 1000-410-431330-241 CONSUMABLE TOOLS 23 500 477 95% 1000-410-431330-322 BOOKS 90 150 60 40% 1000-410-431330-341 ELECTRICITY 1,214 1,700 486 29% 1000-410-431330-342 WATER 0 100 100 100% 1000-410-431330-344 NATURAL GAS 5,340 8,000 2,660 33% 1000-410-431330-354 CONTRACT SERVICES 23,013 52,000 28,987 56% 1000-410-431330-362 EQUIPMENT MAINTENANCE 291 250 41- -16% 1000-410-431330-366 BUILDING MAINTENANCE 759 335 424- -127% 1000-410-431330-373 SCHOOL & TRAVEL 0 500 500 100% 1000-410-431330-388 MEDICAL SERVICES 125 350 226 64% SUBTOTAL CENTRAL GARAGE ----------- 383,694 ----------- 532,085 --------------------- 148,391 28% TOTAL PUBLIC WORKS 404,084 557,125 153,041 27% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 48,837 65,147 16,310 25% 1000-412-411230-121 OVERTIME 15 200 185 92% 1000-412-411230-153 HEALTH INSURANCE 11,055 13,295 2,240 17% 1000-412-411230-155 RETIREMENT 3,070 3,976 906 23% 1000-412-411230-224 JANITORIAL SUPPLIES 3,549 5,000 1,451 29% 1000-412-411230-229 OTHER SUPPLIES 134 750 616 82% 1000-412-411230-241 CONSUMABLE TOOLS 0 700 700 100% 1000-412-411230-341 ELECTRICITY 30,500 41,000 10,500 26% 1000-412-411230-344 NATURAL GAS 29,131 43,300 14,169 33% 1000-412-411230-345 TELEPHONE & COMMUNICATION 113 250 138 55% 1000-412-411230-354 CONTRACT SERVICES 6,395 19,000 12,605 66% 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 991 4,500 3,509 78% 1000-412-411230-362 EQUIPMENT MAINTENANCE 1,017 5,000 3,983 80% 1000-412-411230-366 BUILDING MAINTENANCE 11,975 15,500 3,525 23% 1000-412-411230-545 COUNTY LANDFILL 1,950 2,000 50 2% 1000-412-411230-610 BOI 2004 DEBT (HVAC SYS) 15,561 15,561 0 0% 1000-412-411230-620 BOI 2004 INT. (HVAC SYS) 1,348 1,425 77 5% SUBTOTAL CITY HALL ----------- 165,641 ----------- 236,604 --------------------- 70,963 30% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 197,720 257,172 59,452 23% 1000-420-411020-153 HEALTH INSURANCE 45,309 54,388 9,079 17% 1000-420-411020-155 RETIREMENT 12,902 16,671 3,770 23% 1000-420-411020-210 OFFICE SUPPLIES 618 2,000 1,382 69% 1000-420-411020-213 OFFICE EQUIPMENT 120 1,000 880 88% 1000-420-411020-215 COMPUTER SUPPLIES/SOFTWARE 55 4,500 4,445 99% 1000-420-411020-320 PRINTING 64 500 437 87% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 810 2,500 1,690 68% 1000-420-411020-335 MEMBERSHIP/DUES 1,095 1,300 205 16% 1000-420-411020-345 TELEPHONE 588 900 312 35% 1000-420-411020-354 CONTRACT SERVICES 743 1,300 558 43% 1000-420-411020-373 SCHOOL & TRAVEL 1,150 2,000 850 43% TOTAL PLANNING DEPT. ----------- 261,172 ----------- 344,231 --------------------- 83,059 24% Page 5 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 6 Quarterly Finance Report April 21, 2011 83.33% Yr Complete FUND --------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % POLICE DEPARTMENT ----------- ----------- --------------------- 1000-413-420140-110 SALARIES -POLICE 1,333,428 1,782,771 449,343 25% 1000-413-420140-112 SALARIES -SEVERANCE 11,113 0 11,113- 0% 1000-413-420140-114 SALARY -comptime buyout 3,608 6,500 2,892 45% 1000-413-420140-121 OVERTIME 54,898 75,000 20,102 27% 1000-413-420140-123 SPECIAL ASSIGNMENT OVERTIME 4,489 27,500 23,011 84% 1000-413-420140-153 HEALTH INSURANCE 257,685 306,282 48,597 16% 1000-413-420140-155 RETIREMENT 173,090 230,650 57,560 25% 1000-413-420140-210 OFFICE SUPPLIES 1,767 3,500 1,733 50% 1000-413-420140-215 COMPUTER SUPPLIES 5,092 5,500 408 7% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 4,333 10,500 6,167 59% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,742 5,000 2,258 45% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 5,236 7,000 1,764 25% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,827 2,000 173 9% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 2,279 5,000 2,721 54% 1000-413-420140-227 AMMO & RELATED SUPPLIES 6,873 17,000 10,127 60% 1000-413-420140-228 PATROL CAR SUPPLIES 11,935 13,000 1,065 8% 1000-413-420140-229 OTHER SUPPLIES 2,211 3,500 1,289 37% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 513 2,000 1,487 74% 1000-413-420140-231 CRISIS NEGOTIATIONS 361 1,500 1,139 76% 1000-413-420140-235 BIKE PATROL 1,073 1,000 73- -7% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 1,070 1,000 70- -7% 1000-413-420140-320 PRINTING 3,219 5,000 1,781 36% 1000-413-420140-335 MEMBERSHIP & DUES 545 1,250 705 56% 1000-413-420140-345 TELEPHONE & COMMUNICATION 12,429 15,000 2,571 17% 1000-413-420140-354 CONTRACT SERVICES 5,315 7,000 1,685 24% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 5,015 4,000 1,015- -25% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 0 6,500 6,500 100% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,148 2,000 148- -7% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 13,011 20,000 6,989 35% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 747 2,500 1,753 70% 1000-413-420140-373 SCHOOL & TRAVEL 19,543 26,000 6,457 25% 1000-413-420140-375 REGIONAL TRAINING 456 15,000 14,544 97% 1000-413-420140-376 TESTING (REIMBURSED) 2,136 2,000 136- -7% 1000-413-420140-380 TRAINING MATERIALS 1,047 2,000 953 48% 1000-413-420140-388 MEDICAL SERVICES 1,730 4,000 2,270 57% 1000-413-420140-391 TREATMENT 149 500 351 700 1000-413-420140-392 BOARDING PRISONERS 43 1,000 957 96% 1000-413-420140-610 DEBT SERVICE -PRINCIPAL 0 6,000 6,000 100% 1000-413-420140-620 DEBT SERVICE -INTEREST 0 1,200 1,200 100% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 24,250 48,500 24,250 50% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 10,000 20,000 10,000 50% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 5,000 5,000 0 0% 1000-413-420140-944 VEHICLES 80,141 80,850 709 1% 1000-413-420141-110 DETECTIVE -SALARIES 263,180 333,564 70,384 21% 1000-413-420141-121 DETECTIVE -OVERTIME 11,843 20,000 8,158 41% 1000-413-420141-153 HEALTH INSURANCE 43,015 49,574 6,559 13% 1000-413-420141-155 DETECTIVE -RETIREMENT 34,724 44,951 10,227 23% 1000-413-420142-110 RECORDS -SALARIES 67,090 71,499 4,409 6% 1000-413-420142-121 OVERTIME 2,085 7,500 5,415 72% 1000-413-420142-153 HEALTH INSURANCE 14,067 15,690 1,623 10% 1000-413-420142-155 RETIREMENT 3,993 9,984 5,991 60% 1000-413-420142-354 CONTRACT SERVICES records mgmt 8,627 7,520 1,107- -15% 1000-413-420144-110 SRO SALARIES 86,037 108,087 22,050 20% 1000-413-420144-153 HEALTH INSURANCE 12,831 15,432 2,602 17% 1000-413-420144-155 SRO RETIREMENT 10,723 14,411 3,688 26% SUBTOTAL POLICE DEPT. ----------- 2,630,761 ----------- 3,479,715 --------------------- 848,954 24% 04/21/11 FUND FUND -------------------------------- 1000-416-420400-110 1000-416-420400-112 1000-416-420400-113 1000-416-420400-121 1000-416-420400-153 1000-416-420400-155 1000-416-420400-210 1000-416-420400-213 1000-416-420400-215 1000-416-420400-218 1000-416-420400-221 1000-416-420400-224 1000-416-420400-241 1000-416-420400-320 1000-416-420400-322 1000-416-420400-333 1000-416-420400-335 1000-416-420400-341 1000-416-420400-344 1000-416-420400-345 1000-416-420400-354 1000-416-420400-355 1000-416-420400-362 1000-416-420400-366 1000-416-420400-369 1000-416-420400-373 1000-416-420400-379 1000-416-420400-380 1000-416-420400-610 1000-416-420400-620 1000-416-420440-110 1000-416-420440-121 1000-416-420440-153 1000-416-420440-155 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FIRE DEPARTMENT FIRE SUPPRESSION -SALARIES SALARY -SEVERANCE & comptime buyback KELLY DAYS OVERTIME HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES SMALL OFFICE EQUIPMENT COMPUTER SUPPLIES Equipment (Non Capital) SAFETY EQUIP & SUPPLIES JANITORIAL SUPPLIES CONSUMABLE TOOLS/UNIFORMS PRINTING BOOKS SUBSCRIPTIONS MEMBERSHIP & DUES ELECTRICITY -STATION 62 NATURAL GAS -STATION 62 TELEPHONE & COMMUNICATION CONTRACT SERVICES CONTRACT SERVICES - ARBITRATION EQUIPMENT MAINTENANCE BUILDING MAINTENANCE -STATION 62 RADIO EQUIPMENT & MAINT. SCHOOL & TRAVEL MEETINGS TRAINING MATERIALS DEBT RETIREMENT -FIRE TRUCK INTEREST EXPENSE -FIRE TRUCK FIRE PREVENTION -SALARIES OVERTIME HEALTH INSURANCE RETIREMENT SUBTOTAL FIRE DEPT. GRAND TOTAL GENERAL FUND ACTUAL YTD BUDGET REMAINING % ----------------------------------------------- 1,063,141 1,456,971 393,830 27% 3,349 0 3,349- 0% 27,126 0 27,126- 0% 46,985 25,000 21,985- -88% 211,893 236,879 24,986 11% 144,582 189,205 44,623 24% 96 1,350 1,254 93% 300 500 200 40% 39 850 811 95% 7,435 7,500 65 1% 12,601 15,000 2,399 16% 1,178 1,500 322 21% 11,678 15,000 3,322 22% 45 700 656 94% 0 1,000 1,000 100% 116 250 134 54% 672 350 322- -92% 1,579 9,500 7,921 83% 547 10,000 9,453 95% 4,245 8,500 4,255 50% 13,077 8,000 5,077- -63% 7,325 0 7,325- 0% 6,923 6,500 423- -7% 4,804 2,500 2,304- -92% 9,068 10,500 1,432 14% 1,840 2,500 660 26% 271 500 229 46% 7,897 13,300 5,403 41% 53,578 53,578 0 0% 12,426 12,443 17 0% 31,878 33,134 1,256 4% 1,112 0 1,112- 0% 4,890 6,608 1,718 26% 2,047 2,203 156 7% ----------- 1,694,743 ----------- 2,131,821 --------------------- 437,078 21% 6,876,378 9,072,078 2,195,700 24% Page 7 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 8 Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 0 1,200 1,200 100% 2185-000-430300-356 REDEVELOPMENT / CONTRACT SERVICES 1,372 10,110 8,738 86% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 11,624 13,949 2,325 17% 2185-000-430300-820 Transfer -FAA GRANT MATCH 4,890 4,890 0 0% 2185-480-470240-110 SALARIES 13,025 16,590 3,565 21% 2185-480-470240-153 HEALTH INSURANCE 1,587 1,909 322 17% 2185-480-470240-155 RETIREMENT 848 1,077 229 21% 2185-480-470240-354 AVAIL-TVN PROJECT 21,051 21,051 0 0% ----------- TOTAL AIRPORT TIF 54,396 ----------- 70,776 --------------------- 16,380 23% 2188 WESTSIDE TIF 2188-453-430246-952 LOWER SPRING CREEK 0 70,000 70,000 100% 2188-453-430246-953 3 MILE DR ROAD DESIGN 663 55,000 54,337 99% 2188-480-470230-110 SALARIES 8,518 11,060 2,542 23% 2188-480-470230-153 HEALTH INSURANCE 1,032 2,032 1,000 49% 2188-480-470230-155 RETIREMENT 554 718 164 23% 2188-480-470230-353 AUDIT 1,200 1,250 50 4% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 5,785 5,000 785- -16% 2188-480-470230-356 REDEVELOPMENT / CONTRACT SERVICES 138 0 138- 0% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 20,833 25,000 4,167 17% 2188-480-470230-955 CD -REDEVELOPMENT ACTIVITY 34 2,091,138 2,091,104 100% ----------- TOTAL WESTSIDE TIF 38,757 ----------- 2,261,198 --------------------- 2,222,441 98% 2210 PARKS IN LIEU 2210-436-460430-826 TRANSFER TO ISTEA FUND 15,291 30,000 14,709 49% 2210-436-460430-934 CAPITAL IMPROVEMENTS 0 6,000 6,000 100% 2210-436-460430-935 MERIDIAN PARK PLAYGROUND 3,000 5,000 2,000 40% 2210-436-460430-937 WESTVIEW IMPROVEMENTS 675 15,000 14,325 96% ----------- TOTAL PARKS IN LIEU 18,966 ----------- 56,000 --------------------- 37,034 66% ----------- 2215 NEW PARKS & REC. FUND ---------- - ----------- ---------- REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 458,928 845,000 386,072 46% 2215-000-311200-000 PERSONAL PROPERTY TAXES 39,254 38,000 1,254- -3% 2215-000-312000-000 PEN & INTEREST DEL TAXES 2,752 1,000 1,752- -175% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 3,175 5,000 1,825 37% 2215-000-346030-000 SWIMMING POOL FEES 79,432 140,000 60,568 43% 2215-000-346040-000 CONCESSION STAND REVENUE 23,667 32,500 8,833 27% 2215-000-346050-000 Parks Usage Fees 9,802 18,000 8,199 46% 2215-000-346051-000 RECREATION FEES 7,911 9,568 1,657 17% 2215-000-346052-000 SPORTS PROGRAMS 39,352 32,438 6,914- -21% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 3,064 3,500 436 12% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 31,104 24,978 6,126- -25% 2215-000-346055-000 ICE RINK 4,777 20,000 15,223 76% 2215-000-346057-000 YOUTH CAMPS 35,504 83,650 48,146 58% 2215-000-346059-000 PICNIC IN THE PARK 13,030 26,000 12,970 50% 2215-000-371010-000 INVESTMENTS/DONATIONS/MISC.SALES 346 2,000 1,654 83% 2215-000-381050-000 INCEPTION OF LEASE 78,520 85,309 6,789 8% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 40,000 63,000 23,000 37% ----------- TOTAL PARKS & REC REVENUE 870,618 ----------- 1,429,943 ----------- ---------- 559,325 39% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 196,223 259,451 63,228 24% 2215-436-460430-111 SEASONAL SALARIES 25,008 36,988 11,980 32% 2215-436-460430-121 OVERTIME 1,053 1,000 53- -5% 2215-436-460430-153 HEALTH INSURANCE 49,358 62,741 13,383 21% 2215-436-460430-155 RETIREMENT 13,474 18,396 4,922 27% 2215-436-460430-210 OFFICE SUPPLIES 313 1,200 887 74% 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 9 Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % 2215-436-460430-213 SMALL OFFICE EQUIPMENT 0 800 800 100% 2215-436-460430-215 COMPUTER SUPPLIES 68 1,000 933 93% 2215-436-460430-221 SAFETY EQUIPMENT 581 900 319 35% 2215-436-460430-224 JANITORIAL SUPPLIES 1,860 3,000 1,140 38% 2215-436-460430-229 OTHER SUPPLIES 1,511 4,500 2,989 66% 2215-436-460430-241 CONSUMABLE TOOLS/SMALL EQUIPMENT 1,181 1,600 419 26% 2215-436-460430-320 PRINTING 27 256 229 90% 2215-436-460430-333 SUBSCRIPTIONS 207 250 43 17% 2215-436-460430-335 MEMBERSHIP & DUES 145 450 305 68% 2215-436-460430-337 ADVERTISING 0 250 250 100% 2215-436-460430-341 ELECTRICITY 11,705 14,250 2,545 18% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 20,309 20,000 309- -2% 2215-436-460430-344 NATURAL GAS 2,046 3,200 1,154 36% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,312 3,000 1,688 56% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 1,570 1,500 70- -5% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 1,860 6,500 4,640 71% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT MAINTENANCE 434 2,500 2,066 83% 2215-436-460430-364 LANDSCAPING 970 4,000 3,030 76% 2215-436-460430-366 BUILDING MAINTENANCE 6,341 5,500 841- -15% 2215-436-460430-367 VANDALISM REPAIRS 2,172 4,000 1,828 46% 2215-436-460430-373 SCHOOL & TRAVEL 849 1,200 351 29% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 579 550 29- -5% 2215-436-460430-395 EQUIPMENT RENTAL 150 500 350 70% 2215-436-460430-420 METAL PRODUCTS/FENCING 191 1,500 1,309 87% 2215-436-460430-430 WOOD PRODUCTS/PICNIC TABLES 1,915 2,000 85 4% 2215-436-460430-440 IRRIGATION SUPPLIES 1,276 4,000 2,724 68% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 1,068 4,000 2,932 73% TOTAL PARKS EXPENDITURES ---------------------- 345,755 ----------- 472,482 ---------- 126,727 27% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 24,157 30,568 6,411 21% 2215-436-460440-111 SEASONAL SALARIES 30,713 52,101 21,388 41% 2215-436-460440-153 HEALTH INSURANCE 5,514 6,624 1,110 17% 2215-436-460440-155 RETIREMENT 2,616 4,127 1,511 37% 2215-436-460440-221 SAFETY EQUIPMENT 161 175 14 8% 2215-436-460440-229 OTHER SUPPLIES 3,832 16,000 12,168 76% 2215-436-460440-241 CONSUMABLE TOOLS 215 700 485 69% 2215-436-460440-335 MEMBERSHIP & DUES 0 135 135 100% 2215-436-460440-341 ELECTRICITY 67 5,600 5,533 99% 2215-436-460440-345 TELEPHONE & COMMUNICATION 129 350 221 63% 2215-436-460440-354 CONTRACT SERVICES 200 1,000 800 80% 2215-436-460440-362 EQUIPMENT MAINTENANCE 347 500 153 31% 2215-436-460440-364 LANDSCAPING 0 1,000 1,000 100% 2215-436-460440-367 VANDALISM REPAIRS 0 300 300 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-420 METAL PRODUCTS 445 500 55 11% 2215-436-460440-440 IRRIGATION 2,231 3,400 1,169 34% 2215-436-460440-452 SAND & GRAVEL 0 1,000 1,000 100% 2215-436-460440-610 DEBT SERVICE -PRINCIPAL 0 7,000 7,000 100% 2215-436-460440-620 DEBT SERVICE -INTEREST 0 2,000 2,000 100% 2215-436-460440-940 EQUIPMENT 78,520 85,309 6,789 8% ----------- TOTAL ATHLETIC COMPLEX ----------- 149,146 ----------- 218,539 ---------- 69,393 32% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 67,988 89,740 21,752 24% 2215-436-460431-111 SEASONAL SALARIES 6,347 9,530 3,183 33% 2215-436-460431-153 HEALTH INSURANCE 14,966 18,667 3,701 20% 2215-436-460431-155 RETIREMENT 4,240 6,118 1,878 31% 2215-436-460431-210 OFFICE SUPPLIES 211 600 389 65% 2215-436-460431-229 OTHER SUPPLIES 6,708 9,800 3,092 32% 2215-436-460431-320 PRINTING 0 6,000 6,000 100% 2215-436-460431-333 SUBSCRIPTIONS 0 100 100 100% 2215-436-460431-335 MEMBERSHIP & DUES 818 750 68- -9% 2215-436-460431-337 ADVERTISING 0 500 500 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 210 600 390 65% 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING o ---------------------------------------------------------------------------------------------------------------- 2215-436-460431-354 CONTRACT SERVICES 16,968 19,950 2,982 15% 2215-436-460431-355 BANK FEES/CREDIT CARD FEES 1,285 2,500 1,215 49% 2215-436-460431-373 SCHOOL & TRAVEL 548 800 252 32% TOTAL RECREATION ----------- 120,288 ----------- 165,655 --------------------- 45,367 27% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 50,650 66,982 16,332 24% 2215-436-460448-111 SEASONAL SALARIES 54,047 78,658 24,611 31% 2215-436-460448-121 OVERTIME 75 500 425 85% 2215-436-460448-153 HEALTH INSURANCE 14,120 16,952 2,832 17% 2215-436-460448-155 RETIREMENT 3,144 5,244 2,100 40% 2215-436-460448-210 OFFICE SUPPLIES 99 300 201 67% 2215-436-460448-229 OTHER SUPPLIES 1,887 4,050 2,163 53% 2215-436-460448-320 PRINTING 0 300 300 100% 2215-436-460448-335 MEMBERSHIP & DUES 0 100 100 100% 2215-436-460448-337 ADVERTISING 0 300 300 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 0 400 400 100% 2215-436-460448-354 CONTRACT SERVICES 5,959 13,000 7,041 54% 2215-436-460448-355 AFTER SCHOOL PROGRAM 1,368 2,000 632 32% 2215-436-460448-373 SCHOOL & TRAVEL 0 500 500 100% TOTAL YOUTH CAMPS ----------- 131,350 ----------- 189,286 --------------------- 57,936 31% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 121,805 198,314 76,509 39% 2215-437-460445-121 OVERTIME 644 500 144- -29% 2215-437-460445-155 RETIREMENT 347 4,591 4,244 92% 2215-437-460445-210 OFFICE SUPPLIES 397 500 103 21% 2215-437-460445-213 SMALL OFFICE EQUIPMENT 200 200 0 0% 2215-437-460445-221 SAFETY EQUIPMENT/SUPPLIES 161 200 39 20% 2215-437-460445-224 JANITORIAL SUPPLIES 1,564 2,500 936 37% 2215-437-460445-226 CHLORINE/CHEMICALS 15,644 22,405 6,761 30% 2215-437-460445-228 CONCESSION STAND SUPPLIES 12,829 19,000 6,171 32% 2215-437-460445-229 OTHER SUPPLIES 2,478 4,000 1,522 38% 2215-437-460445-241 CONSUMABLE TOOLS 0 400 400 100% 2215-437-460445-320 PRINTING 0 50 50 100% 2215-437-460445-341 ELECTRICITY 5,985 12,500 6,515 52% 2215-437-460445-344 NATURAL GAS 13,732 24,000 10,268 43% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 2,363 1,500 863- -58% 2215-437-460445-354 LICENSES & FEES 1,094 1,300 206 16% 2215-437-460445-362 EQUIPMENT MAINTENANCE 606 4,000 3,394 85% 2215-437-460445-366 BUILDING MAINTENANCE 2,157 2,400 243 10% 2215-437-460445-380 TRAINING MATERIALS 0 250 250 100% TOTAL POOL EXPENDITURES ----------- 182,005 ----------- 298,610 --------------------- 116,605 39% TOTAL PARKS & RECREATION/POOL 928,545 1,344,572 416,027 31% Page 10 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 11 Quarterly Finance Report April 21, 2011 83.33% Yr Complete FUND FUND ---------------------------------------------------------- 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 2230-000-342070-000 COUNTY EMS LEVY 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC 2230-000-371010-000 INTEREST EARNINGS TOTAL AMBULANCE REVENUE AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 2230-440-420730-113 KELLY DAYS 2230-440-420730-121 OVERTIME 2230-440-420730-153 HEALTH INSURANCE 2230-440-420730-155 RETIREMENT 2230-440-420730-210 OFFICE SUPPLIES 2230-440-420730-213 SMALL OFFICE EQUIPMENT 2230-440-420730-215 COMPUTER SUPPLIES 2230-440-420730-218 NON -CAPITAL EQUIPMENT 2230-440-420730-231 GAS AND OIL 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 2230-440-420730-312 POSTAGE 2230-440-420730-320 PRINTING 2230-440-420730-345 TELEPHONE & COMMUNICATION 2230-440-420730-353 AUDITING 2230-440-420730-354 CONTRACT SERVICES/RECERT. 2230-440-420730-359 CC FEES/COLLECTION SERV. 2230-440-420730-362 EQUIPMENT MAINTENANCE 2230-440-420730-369 RADIO MAINTENANCE 2230-440-420730-380 TRAINING MATERIALS 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 2230-440-420730-521 CENTRAL GARAGE TRANSFER 2230-440-420730-522 ADMINISTRATIVE TRANSFER 2230-440-420730-528 DATA PROCESSING TRANSFER 2230-440-420730-943 AMBULANCE TOTAL AMBULANCE FUND 2310 OLD SCHOOL TIF - TECH 2310-480-470210-354 CONTRACT SERVICES - BOND COUNSEL 2310-480-470210-356 FED -EX REIMBURSEMENT 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT TOTAL 2310 OLD SCHOOL TECH TIE 2311 OLD SCHOLL TIF INDUSTRIAL 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT TOTAL 2311 OLD SCHOOL INDUSTR 2372 HEALTH PERMISIVE LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND TOTAL 2372 HEALTH LEVY ACTUAL YTD BUDGET REMAINING 3 520,801 650,000 129,199 20% 42,067 102,000 59,933 59% 4,169 0 4,169- 0% 1,119 500 619- -124% 568,155 752,500 184,345 25% 259,062 405,542 2,185 10,000 4,861 6,000 48,262 78,704 33,997 53,393 820 750 287 200 1,882 2,000 2,198 2,000 4,366 10,000 4,685 5,000 1,108 3,000 442 500 1,496 700 500 500 9,713 8,000 398 500 1,154 3,500 0 2,500 5,766 8,000 8,055 22,500 25,376 35,000 14,036 16,100 7,500 9,000 27,508 33,010 8,908 10,689 0 50,000 474,566 777,088 146,480 36% 7,815 78% 1,139 19% 30,442 39% 19,396 36% 70- -9% 87- -44% 118 6% 198- -10% 5,634 56% 315 6% 1,892 63% 58 12% 796- -114% 0 0% 1,713- -21% 102 20% 2,346 67% 2,500 100% 2,234 28% 14,445 64% 9,624 28% 2,064 13% 1,500 17% 5,502 17% 1,782 17% 50,000 100% 302,522 39% 0 950 950 100% 11,230 11,230 0 0% 28,770 ----------- 28,770 0 0% ----------- 40,000 ----------- 40,950 ---------- 950 20 2,980 ----------- 9,000 6,020 67% ----------- 2,980 ----------- 9,000 ---------- 6,020 67% 330,000 577,326 ---------------------- 330,000 577,326 247,326 43% ------------------ 247,326 43% 04/21/11 CITY OF KALISPELL Page 12 Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 192,389 150,000 42,389- -28% 2394-000-323103-000 PLUMBING PERMITS 12,973 12,000 973- -8% 2394-000-323104-000 MECHANICAL PERMITS 18,454 20,000 1,547 8% 2394-000-323107-000 HOUSE MOVING PERMITS 75 200 125 63% 2394-000-323108-000 PLAN REVIEW FEES 102,359 50,000 52,359- -105% 2394-000-341025-000 MISC. COLLECTIONS/FEES 205 0 205- 0% 2394-000-343380-000 PUBLIC SAFETY BLDG CONTRACT MGMT 0 38,000 38,000 100% 2394-000-371010-000 INVESTMENT EARNINGS 815 100 715- -715% ----------- TOTAL REVENUE 327,268 ----------- 270,300 ----------- ---------- 56,968- -21% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 145,817 162,897 37,080 20% 2394-420-420530-121 OVERTIME 1,811 2,000 189 9% 2394-420-420530-153 HEALTH INSURANCE 27,871 35,160 7,289 21% 2394-420-420530-155 RETIREMENT 9,211 11,299 2,088 18% 2394-420-420530-210 OFFICE SUPPLIES 202 2,000 1,798 90% 2394-420-420530-215 COMPUTER SUPPLIES 154 2,500 2,346 94% 2394-420-420530-229 OTHER SUPPLIES 325 750 425 57% 2394-420-420530-231 GAS & OIL 1,212 2,250 1,038 46% 2394-420-420530-312 POSTAGE 272 600 328 55% 2394-420-420530-320 PRINTING 153 300 147 49% 2394-420-420530-322 BOOKS 3,537 1,500 2,037- -136% 2394-420-420530-323 ST. ED. ASSESSMENTS 916 2,500 1,584 63% 2394-420-420530-331 PUBLICATION & FILING FEES 0 200 200 100% 2394-420-420530-335 MEMBERSHIP & DUES 140 900 760 84% 2394-420-420530-345 TELEPHONE & COMMUNICATION 1,017 1,500 483 32% 2394-420-420530-353 AUDITING 0 3,000 3,000 100% 2394-420-420530-354 CONTRACT SERVICES 625 500 125- -25% 2394-420-420530-355 CONTRACT CHG. ZONING ADMINISTRATION 6,129 0 6,129- 0% 2394-420-420530-366 BUILDING MAINTENANCE 0 800 800 100% 2394-420-420530-373 SCHOOL & TRAVEL 994 2,000 1,006 50% 2394-420-420530-510 PROPERTY INSURANCE 3,864 4,250 386 9% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 250 300 50 17% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 1,667 2,000 333 17% 2394-420-420530-528 DATA PROCESSING TRANSFER 1,113 1,336 223 17% ----------- TOTAL BUILDING DEPT. ----------- 207,281 ----------- 260,542 ---------- 53,261 20% 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 4,137 4,800 663 14% 2399-413-420140-354 IMPACT FEE REVIEW 500 500 0 0% 2399-413-420140-940 POLICE EQUIPMENT 0 20,000 20,000 100% 2399-416-420400-354 IMPACT FEE REVIEW 500 500 0 0% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 25,750 25,750 0 0% 2399-416-420400-620 INTEREST - FIRE TRUCK 9,307 9,190 117- -1% 2399-416-420400-944 FIRE- LADDER TRUCK 75,975 225,000 149,025 66% ----------- TOTAL 2399 IMPACT FEE FUND ----------- 116,170 ----------- 285,740 ---------- 169,570 59% 24.00 LIGHT MAINT. 2400-410-430263-110 SALARIES 29,950 43,656 13,706 31% 2400-410-430263-112 SEVERANCE 1,270 0 1,270- 0% 2400-410-430263-153 HEALTH INSURANCE 7,524 9,329 1,805 19% 2400-410-430263-155 RETIREMENT 1,874 2,688 814 30% 2400-410-430263-244 STREET LIGHT SUPPLIES 7,275 13,000 5,725 44% 2400-410-430263-341 ELECTRICITY 112,709 163,000 50,291 31% 2400-410-430263-360 REPAIR & MAINT SERVICES 3,082 28,000 24,918 89% 2400-410-430263-510 INSURANCE 975 1,000 25 3% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 5,934 7,121 1,187 17% ----------- TOTAL LIGHT MAINT. ----------- 170,594 ----------- 267,794 ---------- 97,200 36% 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 13 Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 20,540 41,000 20,460 50% 2420-421-430234-957 ALLEY PAVING 25,912 25,000 912- -4% 2420-421-430240-231 GAS & OIL 27,669 30,000 2,331 8% 2420-421-430240-344 NATURAL GAS 2,417 3,500 1,083 31% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 2,088 149,663 147,575 99% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 17,000 17,000 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 0 195,000 195,000 100% 2420-421-430240-369 RADIO EQUIPMENT & MAINT. 0 700 700 100% 2420-421-430240-452 GRAVEL 0 3,000 3,000 100% 2420-421-430240-453 MATERIALS; CONTRACT PREP. 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 46,479 50,000 3,521 7% 2420-421-430240-472 ASPHALT 10,471 30,000 19,529 65% 2420-421-430240-473 CRACK SEALING 0 5,000 5,000 100% 2420-421-430240-533 EQUIPMENT RENTAL ----------- 0 5,500 ----------- 5,500 100% TOTAL GAS TAX 135,576 560,363 --------------------- 424,787 76% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 433,585 607,879 174,294 29% 2500-421-430240-112 RETIREMENT -severance 5,923 0 5,923- 0% 2500-421-430240-121 OVERTIME 16,373 30,000 13,627 45% 2500-421-430240-153 HEALTH INSURANCE 104,827 122,708 17,881 15% 2500-421-430240-155 RETIREMENT 28,194 37,403 9,209 25% 2500-421-430240-213 SMALL OFFICE EQUIPMENT 501 500 1- 0% 2500-421-430240-216 COMPUTER EQUIPMEMT 1,065 4,500 3,435 76% 2500-421-430240-218 EQUIPMENT (NON CAPITAL) 90 1,000 910 91% 2500-421-430240-221 SAFETY EQUIPMENT 1,478 1,200 278- -23% 2500-421-430240-224 JANITORIAL SUPPLIES 322 700 378 54% 2500-421-430240-229 OTHER SUPPLIES 1,038 1,200 162 14% 2500-421-430240-231 GAS & OIL 27,935 30,000 2,065 7% 2500-421-430240-241 CONSUMABLE TOOLS 1,625 2,000 375 19% 2500-421-430240-341 ELECTRICITY 1,388 1,200 188- -16% 2500-421-430240-342 WATER/SEWER CHARGES 52 175 123 71% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 733 1,000 267 27% 2500-421-430240-354 CONTRACT SERVICES 5,208 13,000 7,792 60% 2500-421-430240-355 CONTRACT SERV.-AERIAL MAPPING 77 8,000 7,923 99% 2500-421-430240-357 RATE STUDY 0 8,000 8,000 100% 2500-421-430240-358 IMPACT FEE STUDY 0 14,000 14,000 100% 2500-421-430240-362 EQUIP. M.AINT./SUPPLIES 21,824 23,000 1,176 5% 2500-421-430240-366 BUILDING MAINTENANCE 1,503 1,500 3- 0% 2500-421-430240-369 RADIO EQUIPMENT & MAINT. 195 5,000 4,805 96% 2500-421-430240-373 SCHOOL & TRAVEL 447 2,500 2,053 82% 2500-421-430240-388 MEDICAL SERVICES 737 1,300 563 43% 2500-421-430240-510 LIABILITY INSURANCE 82,919 83,000 81 0% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 2,102 16,500 14,398 87% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 55,000 66,000 11,000 17% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 47,284 56,741 9,457 17% 2500-421-430240-528 DATA PROCESSING TRANSFER 8,908 10,689 1,782 17% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 0 16,000 16,000 100% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 312 1,520 1,208 79% 2500-421-430240-840 MACI GRANT MATCH 0 40,000 40,000 100% 2500-421-430240-935 PAVEMENT MAINTENANCE funds 200,376 458,908 258,532 56% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 50,500 55,000 4,500 8% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 31,041 31,041 100% 2500-421-430264-110 TSS - SALARIES 123,400 140,606 17,206 12% 2500-421-430264-112 SEVERANCE SALARIES 22,708 0 22,708- 0% 2500-421-430264-121 OVERTIME 5,808 8,500 2,692 32% 2500-421-430264-153 HEALTH INSURANCE 14,812 17,805 2,993 17% 2500-421-430264-155 RETIREMENT 9,400 8,803 597- -7% 2500-421-430264-216 COMPUTER EQUIP & SOFTWARE 527 1,500 973 65% 2500-421-430264-218 EQUIPMENT(non-capital) 5,760 4,800 960- -20% 2500-421-430264-221 SAFETY EQUIPMENT & SUPPLIES 1,722 500 1,222- -244% 2500-421-430264-224 JANITORIAL SUPPLIES 279 650 371 57% 2500-421-430264-229 OTHER SUPPLIES 302 800 498 62% 2500-421-430264-241 CONSUMABLE TOOLS 491 1,100 609 55% 2500-421-430264-242 STREET SIGNS 40,573 38,000 2,573- -7% 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 14 Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % 2500-421-430264-243 TRAFFIC SIGNALS 8,540 10,000 1,460 15% 2500-421-430264-245 BARRICADE MATERIALS 1,710 4,000 2,290 57% 2500-421-430264-341 ELECTRICITY 5,408 10,000 4,592 46% 2500-421-430264-345 COMMUNICATIONS 522 700 178 25% 2500-421-430264-354 CONTRACT SERVICES 9,606 10,000 394 4% 2500-421-430264-362 EQUIPMENT MAINTENANCE 2,242 1,400 842- -60% 2500-421-430264-366 BUILDING MAINTENANCE 837 1,500 663 44% 2500-421-430264-369 RADIO MAINTENANCE 0 900 900 100% 2500-421-430264-373 SCHOOL & TRAVEL 1,167 2,500 1,333 53% 2500-421-430264-428 PAINT MATERIALS 635 20,000 19,365 97% 2500-421-430264-510 LIABILITY INS.-TSS 3,674 4,050 376 9% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 2,059 2,000 59- -3% 2500-421-430264-532 OFFICE RENT 7,838 7,838 0 0% TOTAL SPEC. ST. MAINT. ----------- 1,372,539 ---------------------- 2,051,116 ---------- 678,577 33% 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 106,850 141,593 34,743 25% 2600-436-460433-121 OVERTIME 647 750 103 14% 2600-436-460433-153 HEALTH INSURANCE 23,684 28,935 5,251 18% 2600-436-460433-155 RETIREMENT 6,781 8,744 1,963 220 2600-436-460433-210 OFFICE SUPPLIES 31 50 19 38% 2600-436-460433-229 OTHER SUPPLIES 170 500 330 66% 2600-436-460433-241 CONSUMABLE TOOLS 841 950 109 11% 2600-436-460433-333 SUBSCRIPTIONS 0 50 50 100% 2600-436-460433-354 CONTRACT SERVICES 2,000 2,500 500 20% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 0 10,000 10,000 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 712 500 212- -42% 2600-436-460433-364 LANDSCAPING & TREES 880 7,000 6,120 87% 2600-436-460433-373 SCHOOL & TRAVEL 237 250 13 5% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 3,570 6,000 2,430 400 2600-436-460433-521 CENTRAL GARAGE TRANSFER 2,083 2,500 417 17% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 6,355 7,626 1,271 17% 2600-436-460433-528 DATA PROCESSING TRANSFER 1,113 1,336 223 17% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 0 2,000 2,000 100°% 2600-436-460433-620 INTEREST EXPENSE 0 215 215 100% 2600-436-460433-940 MACHINERY & EQUIPMENT 21,000 21,000 0 0% TOTAL URBAN FORESTRY ----------- 176,956 ---------------------- 242,499 ---------- 65,543 27% 2602 ARRA FORESTRY GRANT 2602-436-460433-354 CONTRACT SERVICES 24,234 24,561 327 1% TOTAL ARRA FORESTRY GRANT ----------- 24,234 ---------------------- 24,561 ---------- 327 1% 2601 DEVELOPER TREES 2601-436-460435-351 EMPIRE ESTATES ($44,911) 283 9,231 8,948 97% 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 100% 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 1,132 3,244 2,112 65% 2601-436-460435-356 SINOPAH SUBD ($5,790) 0 667 667 100% 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 0 2,863 2,883 100% 2601-436-460435-358 WEST VIEW SURD ($22,680) 0 17,831 17,831 100% 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 2,264 36,020 33,756 94% 2601-436-460435-360 RIVER GLEN SUBD ($3,240) 0 278 278 100% 2601-436-460435-361 VILLAGE GREENS ($3,540) 0 2,514 2,514 100% 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 0 1,538 1,538 100% 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 0 1,390 1,390 100% 2601-436-460435-364 MTN VISTA ESTATES III $17,278.25 0 3,679 3,679 100% 2601-436-460435-365 VILLAGE GREENS $3,540 0 2,797 2,797 100% 2601-436-460435-366 W VIEW ESTATES $20,060 0 10,850 10,850 100% 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 0 4,254 4,254 100% TOTAL 2602 DEVELOPER TREES ----------- 3,679 ---------------------- 101,512 ---------- 97,833 96% 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2825 MAGI GRANT -SWEEPER 2825-421-430240-940 STREET SWEEPER 0 200,000 200,000 100% TOTAL 2825 MACI GRANT ----------- 0 ----------- 200,000 ----------- ---------- 200,000 100% 2880 COM DEV REVOLVING FUND 2880-480-470240-711 IRP LOAN PROGRAM MATCH 0 225,000 225,000 100% TOTAL LOAN REVOLVING ----------- 0 ----------- ----------- ----------- 225,000 ----------- ----------- --------------------- 225,000 --------------------- -------------------- 100% 2886 UDAG FUND 2886-480-470210-110 SALARIES - UDAG 42,980 55,988 13,008 23% 2886-480-470210-153 HEALTH INSURANCE 5,369 6,363 994 16% 2886-480-470210-155 RETIREMENT 2,821 3,618 797 22% 2886-480-470210-210 OFFICE SUPPLIES 261 500 239 48% 2886-480-470210-211 GRANT ADMIN. EXPENSES 342 1,000 658 66% 2886-480-470210-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 2886-480-470210-215 COMPUTER SUPPLIES 0 1,000 1,000 100% 2886-480-470210-218 EQUIPMENT (non -capital) 0 300 300 100% 2886-480-470210-231 GAS & OIL 118 300 182 61% 2886-480-470210-312 POSTAGE 73 300 227 76% 2886-480-470210-320 PRINTING 602 1,500 898 60% 2886-480-470210-331 GRANT ACTIVITIES ADVERTISING 342 1,500 1,158 77% 2886-480-470210-334 MT WEST MEMBERSHIP 500 500 0 0% 2886-480-470210-335 MEMBERSHIP & DUES 480 700 220 31% 2886-480-470210-345 TELEPHONE & COMMUNICATION 128 750 622 83% 2886-480-470210-353 AUDITING 1,200 1,500 300 20% 2886-480-470210-354 CONTRACT SERVICES 50 1,000 950 95% 2886-480-470210-355 PROSPECT DEVELOPMENT 0 3,000 3,000 100% 2886-480-470210-363 OFFICE EQUIP MAINTENANCE 0 500 500 100% 2886-480-470210-373 SCHOOL & TRAVEL 1,121 1,000 121- -12% 2886-480-470210-379 MEETINGS 69 500 431 86% 2886-480-470210-381 TRAINING 192 1,000 808 81% 2886-480-470210-395 CDBG- GROWTH POLICY UPDATE 0 20,000 20,000 100% 2886-480-470210-396 GRANT SERVICES 5,500 25,000 19,500 78% 2886-480-470210-510 PROPERTY & LIABILITY INS. 2,975 3,800 825 22% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 5,559 6,671 1,112 17% 2886-480-470210-528 DATA PROCESSING TRANSFER 5,567 6,680 1,113 17% 2886-480-470210-532 OFFICE RENT 4,703 4,703 0 0% 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 2,500 2,500 100% TOTAL UDAG FUND ----------- 80,951 ----------- 152,373 --------------------- 71,422 47% RURAL DEVELOPMENT REVOLVING 2887-480-470210-110 SALARIES 21,349 27,776 6,427 23% 2887-480-470210-153 HEALTH INSURANCE 2,645 3,182 537 17% 2887-480-470210-155 RETIREMENT 1,389 1,795 406 23% 2887-480-470210-610 DEBT SERVICE/PAIN-L#61-01 17,213 17,213 0 0% 2887-480-470210-620 INTEREST EXPENSE/L461-01 4,861 4,861 0 0% 2887-480-470210-750 REDEVELOPMENT LOANS 34 215,000 214,966 100% TOTAL RURAL DEVELOPMENT ----------- 47,491 ----------- 269,827 --------------------- 222,336 82% 2888 RURAL DEV. #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-02 29,228 29,228 0 0% 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-02 2,610 10,930 8,320 76% 2888-480-470210-750 REDEVELOPMENT LOANS 0 55,772 55,772 100% TOTAL 2888 RURAL DEV. #2 ----------- 31,838 ----------- 95,930 --------------------- 64,092 67% Page 15 83.33% Yr Complete 04/21/11 FUND FUND CITY OF KALISPELL Quarterly Finance Report April 21, 2011 ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- 2944 CDBG-ED FVCC 2944-480-470242-760 TRANING COSTS-FVCC GRT 0 72,000 72,000 100% 2944-480-470242-790 MACHINERY/EQUIPMENT-FVCC GRT 0 6,090 6,090 100% 2944-480-470242-820 ADMIN TRANSFER - to Com Development 0 3,428 3,428 100% ----------- TOTAL 2944 CDBG-ED FVCC 0 ----------- 81,518 --------------------- 81,518 100°% 2945 CDBG-ED FVCC #2 2945-480-470242-780 TRAINING COSTS 0 15,000 15,000 100% 2945-480-470242-790 MACHINERY/EQUIPMENT 0 246,800 246,800 100% 2945-480-470242-820 ADMIN TRANSFER -to Com. Deveolpment 0 12,145 12,145 100% ----------- TOTAL 2945 CDBG-ED FVCC #2 ----------- 0 ----------- 273,945 ----------- --------------------- 273,945 ------------------- 100% 2953 EPA BROWNSFIELD GRANT 2953-480-470210-780 BROWNSFIELD ASSESSMENT GRT EXP. 67,573 396,152 328,579 83% ----------- TOTAL EPA BROWNSFIELD GRANT ----------- 67,573 ----------- 396,152 ----------- --------------------- 328,579 -------------------- 83% ---------- 2954 EPA/BROWNFIELDS PLANNING ----------- --------------------- 2954-480-470210-354 AREA -WIDE PILOT PROGRAM 3,648 175,000 171,352 98% ----------- TOTAL 2954 EPA/BROWNFIELD PLAN 3,648 ----------- 175,000 --------------------- 171,352 98% 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN 15,104 26,998 11,894 44% ----------- TOTAL 2915 STONEGARDEN GRANT ---------- ---------- ----------- 15,104 ---------- ----------- ----------- 26,998 ---------- 11,894 ------------------- -------------------- 44% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 49,825 62,650 12,825 20% 2916-413-420140-121 OVERTIME 4,440 11,000 6,560 60% 2916-413-420140-153 HEALTH INSURANCE 5,290 6,363 1,073 17% 2916-413-420140-155 RETIREMENT 6,563 8,443 1,881 22% 2916-413-420140-210 OFFICE SUPPLIES 0 400 400 100% 2916-413-420140-354 CONTRACT SERVICES 2,023 3,000 977 33% ----------- TOTAL 2916 DRUG ENFORCEMENT ----------- 68,140 ----------- 91,856 ---------- 23,716 26% 2917 COPS TECHNOLOGY GRANT 2917-413-420140-950 SHOOTING FACILITY 0 750,000 750,000 100% TOTAL 2917 COPS TECHNOLOGY GT 0 750,000 750,000 100% 2918 COPS HIRING RECOVERY GT 2918-413-420140-110 SALARIES & PAYROLL COSTS 40,444 49,878 9,434 19% 2918-413-420140-153 HEALTH INSURANCE 11,475 13,770 2,295 17% 2918-413-420140-155 RETIREMENT 5,348 6,722 1,374 20% ----------- TOTAL 2918 COPS HIRING GRANT ----------- 57,267 ----------- 70,370 ---------- 13,103 19% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 1,816 0 1,816- 0% 2919-413-420140-125 DUI TASK FORCE 556 10,000 9,444 94% 2919-413-420140-126 HOLIDAY OT REIMS. 34,272 50,000 15,728 31% 2919-413-420140-127 SCHOOL DIST. OT 11,616 20,000 8,384 42% 2919-413-420140-216 SECURE OUR SCHOOLS GRANT $1,200 1,200 1,200 0 0% 2919-413-420140-218 JAG GRANT- E Tickets Equip/supplies 17,845 17,845 0 0% 2919-413-420140-219 EQUIPMENT: NON - CAPITAL 81 10,000 9,919 99% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 1,200 5,000 3,800 76% 2919-413-420140-221 Bullet Proof Vests 780 10,000 9,220 92% 2919-413-420143-218 JAG GRT 2010-DJ-BX-1015 VIDEO/EQUIP 12,882 19,189 6,307 33% Page 16 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- 2919-413-420143-941 JAG GRT 2010DJBX1015-ELLIPTICAL 7,295 0 7,295- 0% ---------------------- ----------- ---------- TOTAL LAW ENF. GRANT 89,545 143,234 53,689 37% 2920 DOJ-IT UPGRADE SAFETY BLD 2920-480-470210-922 PUBLIC SAFETY BLDG -TECH UPGRADES 30,780 250,000 219,220 88% ------------------------------------------- TOTAL 2920 IT UPGRADE -SAFETY 30,780 250,000 219,220 88% ------------------------------------------ ------------------------------------------ 2921 DRUG COURT GRANT 2921-406-410360-354 DRUG COURT -contract services 46,474 326,262 279,788 86% ------------------------------------------- TOTAL DRUG COURT GRANT 46,474 326,262 279,788 86% ------------------------------------------- 2951 DUI COURT GRANT 2951-406-410360-355 CS-EVAL,P0,LAC/#2011-02-03-02 47,459 112,479 65,020 58% 2951-406-410361-354 CS -EVALUATOR, PO,LAC 2010-18-21-02 10,232 10,788 556 5% ------------------------------------------- TOTAL DUI COURT GRANT 57,691 123,267 65,576 53% ------------------------------------------- 2930 PRESERVE AMERICA GRANT 2930-480-470240-354 PRESERVE AMERICA EXPENSES TOTAL 2930 PRESERVE AMERICA 2927 CULTRUAL ARTS PASSTHRU GT 2927-400-460452-354 HOCKADAY 2927-400-460454-354 GLACIER ORCHESTRA TOTAL 2927 CULTURAL ARTS 2957 FEMA GRANT 2957-416-420400-110 SALARIES 2957-416-420400-121 OVERTIME 2957-416-420400-153 HEALTH INSURANCE 2957-416-420400-155 RETIREMENT 2957-416-420400-218 EQUIPMENT (non capital) 2957-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2957-416-420400-229 HAZMAT REIMB.-MATERIALS 2957-416-420400-373 TRAVEL - REIMBURSABLE 2957-416-420410-125 PASS THRU HAZMAT OT 2957-416-420410-218 PASS THRU HAZMAT EQUIP 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 2957-416-420414-218 AFG EQUIPMENT AND SAFETY($137,000) 2957-416-420414-219 AFG TURNOUT GRT EM1W-2010-FO-03179 TOTAL FEMA GRANT 2975 ISTEA 2975-436-460457-950 WOODLAND CONNECTOR TOTAL ISTEA 2990 STIMULUS- ROADS 2990-421-430240-950 STIMULUS STREET CONSTRUCTION TOTAL 2990 STIMULUS - ROADS 2991 NEIGHBORHOOD STABILIZATIO 0 ----------- 75,000 75,000 ---------- 100% 0 ----------- 75,000 ----------- 75,000 100% 0 5,200 5,200 100% 0 ----------- 3,750 ---------------------- 3,750 ---------- 100% 0 8,950 8,950 100% 207 10,000 9,793 98% 179 15,000 14,821 99% 0 1,564 1,564 100% 467 1,436 969 67% 5,077 34,109 29,032 85% 0 5,480 5,480 100% 0 6,000 6,000 100% 0 20,000 20,000 100% 3,465 20,000 16,535 83% 10,729 31,125 20,396 66% 0 5,000 5,000 100% 123,652 123,246 406- 0% 5,200 5,200 0 0% ---------------------- 148,976 ----------- 278,160 ---------- 129,184 46% 124,110 265,000 140,890 53% ---------------------------------------- 124,110 265,000 140,890 53% 342,796 343,549 753 0% ------------------------------------------- 342,796 343,549 753 0% ----------------------------------------- ------------------------------------------- Page 17 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS 18,672 88,700 70,028 79% TOTAL 2992 NEIGHBORHOOD STABIL ----------- 18,672 ----------- ----------- 88,700 ----------- --------------------- 70,028 --------------------- 79% 2992 ENERGY BLOCK GRANT 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS 18,672 88,700 70,028 79% TOTAL 2992 ENERGY BLOCK GRANT ----------- 18,672 ----------- 88,700 --------------------- 70,028 79% 2993 STIMULUS ENERGY #2 2993-412-411230-925 ENERGY IMPROVEMENTS 5,753 103,000 97,247 94% TOTAL 2993 STIMULUS ENERGY #2 ----------- 5,753 ----------- 103,000 --------------------- 97,247 94% 2995 SAFER GRANT 2995-416-420400-110 SALARIES 70,670 135,000 64,330 48% 2995-416-420400-153 HEALTH INSURANCE 21,989 34,000 12,011 35% 2995-416-420400-155 RETIREMENT 9,672 18,000 8,328 46% TOTAL 2995 SAFER GRANT ----------- 102,331 ----------- 187,000 --------------------- 84,669 45% CAPITAL PROJECT FUNDS 4150 FIRE STATION 461 REMODEL 4150-416-420400-928 FIRE STATION 61 CONSTRUCTION 973,743 1,258,398 284,655 23% TOTAL 4150 FIRE STATION REMODE ----------- 973,743 ----------- ----------- 1,258,398 ----------- --------------------- 284,655 --------------------- 23% 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 942 25,000 24,058 96% TOTAL 4290 WALK & CURB ----------- 942 ----------- 25,000 --------------------- 24,058 96% 4300 FAA NON -PRIMARY ENTITLMNT 4300-430-430310-354 TOWER MITIGATION 0 600,000 600,000 100% TOTAL FAA NP ENTITLEMENT ----------- 0 ----------- 600,000 --------------------- 600,000 100% 4312 FAA PLANNING GRANT 4312-430-430310-940 CAPITAL IMPROVEMENTS 31,825 97,800 65,975 670 TOTAL FAA PLANNING GRANT ----------- 31,825 ----------- 97,800 --------------------- 65,975 67% Page 18 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 19 Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ENTERPRISE FUNDS WATER REVENUE 5210-000-331158-000 STATE BYPASS RELOCATION REIMB. 7,430 0 7,430- 0% 5210-000-343210-000 METERED WATER SALES 1,833,536 2,450,000 616,464 25% 5210-000-343220-000 UNMETERED WATER SALES 9,451 5,000 4,451- -89% 5210-000-343225-000 IMPACT FEES 220,638 220,000 638- 0% 5210-000-343230-000 METER REPLACEMENT FEE 78,347 95,000 16,653 18% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 19,189 12,000 7,189- -60% 5210-000-343270-000 WATER TURN ON FEES 2,375 3,000 625 21% 5210-000-343275-000 TAG FEE 15,840 20,000 4,160 21% 5210-000-371010-000 INVESTMENT EARNINGS 43,283 ----------- 52,500 ----------- 9,217 18% TOTAL WATER REVENUE 2,230,088 ----------- 2,857,500 ---------- 627,412 22% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 527,786 691,214 163,428 24% 5210-447-430550-112 SALARIES -RETIREMENT 11,335 4,400 6,935- -158% 5210-447-430550-121 OVERTIME 23,401 20,500 2,901- -14% 5210-447-430550-153 HEALTH INSURANCE 106,926 150,401 43,475 29% 5210-447-430550-155 RETIREMENT 34,992 42,900 7,908 18% 5210-447-430550-210 OFFICE SUPPLIES 407 450 43 9% 5210-447-430550-213 SMALL OFFICE EQUIPMENT 478 1,000 522 52% 5210-447-430550-214 GIS SUPPLIES 124 3,000 2,876 96% 5210-447-430550-215 COMPUTER SUPPLIES 1,416 3,000 1,584 53% 5210-447-430550-216 COMPUTER EQUIPMEMT 3,467 5,000 1,533 31% 5210-447-430550-218 EQUIPMENT (NON CAPITAL) 9,336 10,200 864 8% 5210-447-430550-221 SAFETY EQUIP & SUPPLIES 6,650 3,700 2,950- -80% 5210-447-430550-224 JANITORIAL SUPPLIES 106 800 694 87% 5210-447-430550-226 CHLORINE & CHEMICALS 22,367 33,000 10,633 32% 5210-447-430550-229 OTHER SUPPLIES 817 1,500 683 46% 5210-447-430550-231 GAS & OIL 22,276 27,000 4,724 17% 5210-447-430550-241 CONSUMABLE TOOLS 979 2,500 1,521 61% 5210-447-430550-312 POSTAGE 1,105 2,500 1,395 56% 5210-447-430550-320 PRINTING 0 2,000 2,000 100% 5210-447-430550-335 MEMBERSHIP & DUES 294 1,200 907 76% 5210-447-430550-336 LICENSES & FEES 15,214 19,000 3,787 20% 5210-447-430550-341 ELECTRICITY 92,104 148,000 55,896 38% 5210-447-430550-342 WATER 131 500 369 74% 5210-447-430550-344 NATURAL GAS 10,068 15,000 4,932 33% 5210-447-430550-345 TELEPHONE & COMMUNICATION 5,208 8,000 2,792 35% 5210-447-430550-349 LAB SERVICES 17,115 25,500 8,385 33% 5210-447-430550-353 AUDITING 2,550 3,000 450 15% 5210-447-430550-354 CONTRACT SERVICES 22,379 60,000 37,621 63% 5210-447-430550-355 CONTRACT SERV.-AERIAL MAPPING 213 3,000 2,787 93% 5210-447-430550-356 WTR RIGHTS UPDATE/WTR MODELING 11,905 25,000 13,096 52% 5210-447-430550-357 RATE STUDY 0 4,500 4,500 100% 5210-447-430550-358 IMPACT FEE REVIEW 3,921 5,000 1,079 22% 5210-447-430550-360 REPAIR & MAINT SERVICES 4,237 7,000 2,763 39% 5210-447-430550-362 EQUIPMENT MAINTENANCE 3,412 4,000 588 15% 5210-447-430550-363 OFFICE EQUIP MAINTENANCE 0 200 200 100% 5210-447-430550-366 BUILDING MAINTENANCE 5,919 17,000 11,081 65% 5210-447-430550-369 RADIO EQUIPMENT & MAINT. 357 2,450 2,093 85% 5210-447-430550-373 SCHOOL & TRAVEL 7,865 5,500 2,365- -43% 5210-447-430550-380 TRAINING MATERIALS 108 500 392 78% 5210-447-430550-388 MEDICAL SERVICES 589 800 211 26% 5210-447-430550-395 RENTAL EQUIPMENT 300 1,500 1,200 80% 5210-447-430550-410 CONSTRUCTION MATERIALS 19,394 30,000 10,606 35% 5210-447-430550-422 HYDRANTS 2,430 26,000 23,570 91% 5210-447-430550-423 MATERIALS FOR MAINS 6,467 11,000 4,533 41% 5210-447-430550-424 MATERIALS -SERVICE LINES 4,650 9,000 4,350 48% 5210-447-430550-425 MATERIALS PUMPS/WELLS 15,690 36,000 20,310 56% 5210-447-430550-510 PROPERTY & LIABILITY INS. 33,829 36,500 2,671 7% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 6,658 4,000 2,658- -66% 5210-447-430550-513 UNINSURED LOSS -GOODWILL 0 7,500 7,500 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 6,250 7,500 1,250 17% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 78,936 94,723 15,787 17% 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 20 Quarterly Finance Report April 21, 2011 83.33% Yr Complete FUND FUND -------------------------------------------------------- 5210-447-430550-528 DATA PROCESSING TRANSFER 5210-447-430550-532 LEASE PAYMENTS 5210-447-430550-810 BAD DEBT EXPENSE 5210-447-430550-935 ARMORY WELL GENERATOR REPLACEMENT 5210-447-430550-940 MACHINERY & EQUIPMENT 5210-447-430550-948 METERS (METER FUNDS) 5210-447-430550-950 WATER MAIN REPLACEMENT -GRAND VIEW 5210-447-430550-951 SECURITY SYSTEM UPGRADES 5210-447-430550-954 93S BYPASS -UTILITY RELOCATE -amended 5210-447-430550-956 UPPER/LOWER INTERCONNECTION 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 5210-447-430555-930 CONTRACT MAIN UPSIZE 5210-447-430555-941 METERS (NEW SERVICES) 5210-447-430555-953 SECTION 36 WELL 5210-447-430560-110 5210-447-430560-153 5210-447-430560-155 5210-447-430560-210 5210-447-430560-218 5210-447-430560-335 5210-447-430560-353 5210-447-430560-354 5210-447-430560-355 5210-447-430560-373 5210-447-430560-522 5210-447-430560-528 5210-447-430560-532 5210-447-490204-610 5210-447-490204-620 5210-447-490204-630 5210-447-490206-610 5210-447-490206-620 5210-447-490250-610 5210-447-490250-620 TOTAL WATER FACILITIES WATER BILLING SALARIES -WATER BILLING HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES EQUIPMENT - NOT CAPITAL MEMBERSHIP & DUES AUDITING CONTRACT SERVICES BILLING COSTS SCHOOL & TRAVEL ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER RENT TOTAL WATER BILLING REVENUE BONDS 2004 BOND PRINCIPAL (HWY93) 2004 BOND INTEREST (HWY93) 2004 BOND FISCAL AGENT FEES 2007 BOND PRIN WRF 3.75% 2007 BOND INT WRF 3.75% SRF 2001 PRINCIPAL 4% SRF 2001 INTEREST 4% TOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE TOTAL DEPRECIATION TOTAL WATER FUND ACTUAL YTD BUDGET REMAINING % ----------------------------------------------- 16,701 20,041 3,340 17% 7,838 7,838 0 0% 0 1,500 1,500 100% 0 60,000 60,000 100% 106,232 105,000 1,232- -1% 53,030 65,000 11,970 18% 159,517 156,000 3,517- -2% 31,286 32,000 714 2% 474 15,000 14,526 97% 0 30,000 30,000 100% 0 395,000 395,000 100% 0 75,000 75,000 100% 50,795 65,000 14,205 22% 27,120 75,000 47,880 64% ----------- 1,605,153 ----------- ----------- 2,726,317 ----------- --------------------- 1,121,164 --------------------- 41% 67,043 91,807 24,764 27% 16,591 18,774 2,183 12% 4,317 5,914 1,597 27% 103 500 397 79% 62 2,500 2,438 98% 228 300 72 24% 1,500 1,500 0 0% 3,361 7,500 4,139 55% 23,747 28,500 4,753 17% 85 1,200 1,115 93% 5,148 6,178 1,030 17% 18,368 22,041 3,674 17% 7,838 7,838 0 0% ----------- 148,391 ----------- ----------- 194,552 ----------- --------------------- 46,161 --------------------- 24% 0 145,000 145,000 100% 46,633 46,635 3 0% 300 300 0 0% 0 179,000 179,000 100% 83,419 83,422 3 0% 0 38,000 38,000 100% 18,560 ----------- 18,560 0 0% 148,911 ----------- ----------- 510,917 ----------- --------------------- 362,006 --------------------- 71% 0 725,000 725,000 100% ----------- 0 ----------- ----------- 725,000 ----------- --------------------- 725,000 --------------------- 100% 1,902,455 4,156,786 2,254,331 54% 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- SEWER REVENUE: 5310-000-331158-000 STATE BYPASS RELOCATION REIMS. 7,430 16,237 8,807 54% 5310-000-343310-000 SEWER SERVICE CHARGES 2,552,334 3,500,000 947,666 27% 5310-000-343330-000 IMPACT FEES (SANITARY) 114,836 100,000 14,836- -15% 5310-000-343335-000 IMPACT FEES (WWTP) 149,051 125,000 24,051- -19% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 16,978 2,000 14,978- -749% 5310-000-371010-000 INVESTMENT EARNINGS 44,174 74,000 29,826 40% TOTAL SEWER REVENUE ----------- 2,884,803 ----------- 3,817,237 --------------------- 932,434 24% EXPENDITURES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 54,656 75,471 20,815 28% 5310-454-430620-153 HEALTH INSURANCE 12,049 14,240 2,191 15% 5310-454-430620-155 RETIREMENT 3,510 4,807 1,297 27% 5310-454-430620-215 OFFICE SUPPLIES/FURNITURE 0 1,000 1,000 100°% 5310-454-430620-218 COMPUTERS/SUPPLIES 253 1,500 1,247 83% 5310-454-430620-335 MEMBERSHIP & DUES 130 300 170 57% 5310-454-430620-353 AUDITING 1,500 1,500 0 0% 5310-454-430620-354 CONTRACT SERVICES 468 7,500 7,032 94% 5310-454-430620-355 BILLING COSTS 26,119 24,000 2,119- -9% 5310-454-430620-373 SCHOOL & TRAVEL 85 1,000 915 92% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 6,028 7,234 1,206 17% 5310-454-430620-528 DATA PROCESSING TRANSFER 18,368 22,041 3,674 17% 5310-454-430620-532 OFFICE RENT 7,838 7,838 0 0% TOTAL SEWER BILLING COSTS ----------- 131,004 ----------- ----------- 168,431 ----------- ----------- ---------- 37,427 --------------------- 22% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 226,196 342,562 116,366 34% 5310-454-430630-112 SALARIES-SEVERANCE/RETIREMENT 25,281 13,900 11,381- -82% 5310-454-430630-121 OVERTIME 5,655 7,000 1,345 19% 5310-454-430630-153 HEALTH INSURANCE 48,083 61,635 13,552 22% 5310-454-430630-155 RETIREMENT 15,920 22,931 7,011 31% 5310-454-430630-210 OFFICE SUPPLIES 108 450 342 76% 5310-454-430630-213 SMALL OFFICE EQUIPMENT 0 250 250 100% 5310-454-430630-214 CIS SUPPLIES 124 1,000 876 88% 5310-454-430630-215 COMPUTER SUPPLIES 18 2,000 1,982 99% 5310-454-430630-216 COMPUTER EQUIPMENT 2,591 2,500 91- -4% 5310-454-430630-218 EQUIPMENT (NON CAPITAL) 987 1,000 13 1% 5310-454-430630-221 SAFETY EQUIP & SUPPLIES 5,053 7,500 2,447 33% 5310-454-430630-224 JANITORIAL SUPPLIES 567 700 133 19% 5310-454-430630-229 OTHER SUPPLIES 328 600 272 45% 5310-454-430630-231 GAS & OIL 6,658 9,500 2,842 30% 5310-454-430630-241 CONSUMABLE TOOLS 459 1,000 541 54% 5310-454-430630-312 POSTAGE 52 500 448 90% 5310-454-430630-336 LICENSES & FEES 0 450 450 100% 5310-454-430630-341 ELECTRICITY 33,761 43,000 9,239 21% 5310-454-430630-342 WATER 59 175 116 66% 5310-454-430630-344 NATURAL GAS 9,964 13,000 3,036 23% 5310-454-430630-345 TELEPHONE & COMMUNICATION 16,040 21,000 4,960 24% 5310-454-430630-353 AUDITING 2,000 2,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 24,123 14,000 10,123- -72% 5310-454-430630-355 CONTRACT SERVICES -AERIAL MAPPING 77 3,000 2,923 97% 5310-454-430630-356 CONSULTANTS 0 7,500 7,500 100% 5310-454-430630-357 RATE STUDY FY09/FACILITY PLAN FY08 0 3,000 3,000 100% 5310-454-430630-358 IMPACT FEE REVIEW 3,921 5,000 1,079 22% 5310-454-430630-362 EQUIPMENT MAINTENANCE 3,438 4,800 1,362 28% 5310-454-430630-366 BUILDING MAINTENANCE 999 1,000 1 0% 5310-454-430630-369 RADIO EQUIPMENT & MAINT. 0 1,000 1,000 100% 5310-454-430630-373 SCHOOL & TRAVEL 1,600 2,000 400 20% 5310-454-430630-388 MEDICAL SERVICES 763 800 38 5% 5310-454-430630-410 CONSTRUCTION MATERIALS 1,823 9,000 7,177 80% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 28,023 12,500 15,523- -124% 5310-454-430630-510 PROPERTY & LIABILITY INS. 50,621 56,000 5,379 10% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 18,763 18,000 763- -4% Page 21 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 22 Quarterly Finance Report April 21, 2011 83.33% Yr Complete FUND FUND -------------------------------------------------------------- 5310-454-430630-521 CENTRAL GARAGE TRANSFER 5310-454-430630-522 ADMINISTRATIVE TRANSFER 5310-454-430630-528 DATA PROCESSING TRANSFER 5310-454-430630-532 OFFICE RENT 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 5310-454-430630-810 BAD DEBT EXPENSE 5310-454-430630-954 93 So. BYPASS -UTILITY RELOCATE TOTAL SANITARY SEWER/COLLECTIO SANITARY SEWER PLANT INVEST $ 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 5310-454-430635-957 GRANDVIEW PUMP STA/GRAVITY MAIN 52% TOTAL SANITARY SEWER PLANT INV 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 TOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE TOTAL DEPRECIATION -SANITARY ACTUAL YTD BUDGET REMAINING % ---------------------------------------------- 2,083 2,500 417 17% 52,812 63,374 10,562 17% 12,248 14,697 2,449 17% 7,838 7,838 0 0% 17,033 25,500 8,467 33% 0 1,000 1,000 100% 158 21,650 21,492 99% ----------- 626,226 ----------- ----------- 828,812 ----------- --------------------- 202,586 --------------------- 24% 0 44,000 44,000 100% 8,028 6,000 2,028- -34% ----------- 8,028 ----------- ----------- 50,000 ----------- --------------------- 41,972 ----------- ---------- 84% 0 63,000 63,000 100% 42,075 42,075 0 0% 0 300 300 100% ----------- 42,075 ----------- ----------- 105,375 ----------- --------------------- 63,300 --------------------- 60% 0 800,000 800,000 100% ----------- 0 ----------- ----------- 800,000 ----------- --------------------- 800,000 ----------- ---------- 100% TOTAL SANITARY SEWER 676,329 ---------- ----------- 1,784,187 ---------- ----------- 1,107,858 ------------------- --------------------- 62% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 267,682 382,859 115,177 30% 5310-455-430640-112 SALARIES -RETIREMENT 11,598 8,800 2,798- -32% 5310-455-430640-121 OVERTIME 15,837 20,000 4,163 21% 5310-455-430640-153 HEALTH INSURANCE 48,061 66,146 18,085 27% 5310-455-430640-155 RETIREMENT 18,209 23,932 5,724 24% 5310-455-430640-210 OFFICE SUPPLIES 768 1,000 232 23% 5310-455-430640-213 SMALL OFFICE EQUIPMENT 695 1,000 305 31% 5310-455-430640-215 COMPUTER SUPPLIES 20 500 480 96% 5310-455-430640-216 COMPUTER EQUIPMENT 660 2,500 1,840 74% 5310-455-430640-221 SAFETY EQUIP & SUPPLIES 884 1,500 616 41% 5310-455-430640-224 JANITORIAL SUPPLIES 91 200 109 55% 5310-455-430640-225 ALUM 10,125 35,000 24,875 71% 5310-455-430640-226 CHLORINE & CHEMICALS 4,816 12,000 7,184 60% 5310-455-430640-229 OTHER SUPPLIES 4,097 5,000 903 18% 5310-455-430640-231 GAS & OIL 6,344 11,000 4,656 42% 5310-455-430640-241 CONSUMABLE TOOLS 819 1,000 181 18% 5310-455-430640-312 POSTAGE 133 400 267 67% 5310-455-430640-335 MEMBERSHIP & DUES 160 800 640 80% 5310-455-430640-336 LICENSES & FEES 6,646 8,000 1,354 17% 5310-455-430640-341 ELECTRICITY 119,165 200,000 80,835 40% 5310-455-430640-342 WATER 3,407 7,500 4,093 55% 5310-455-430640-344 NATURAL GAS 43,065 60,000 16,935 28% 5310-455-430640-345 TELEPHONE & COMMUNICATION 3,107 6,000 2,893 48% 5310-455-430640-353 AUDITING 2,750 2,750 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 85,242 123,000 37,758 31% 5310-455-430640-355 OTHER CONTRACT SERVICES 25,955 38,000 12,045 32% 5310-455-430640-356 CONSULTANTS 15,901 19,000 3,099 16% 5310-455-430640-357 WWTP RATE STUDY 0 5,000 5,000 100% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 5310-455-430640-360 REPAIR & MAINT SERVICES 10,778 15,000 4,222 28% 5310-455-430640-366 BUILDING MAINTENANCE 1,645 2,300 655 28% 5310-455-430640-373 SCHOOL & TRAVEL 5,971 10,000 4,029 40% 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 5310-455-430640-380 TRAINING MATERIALS 441 500 59 12% 5310-455-430640-388 MEDICAL SERVICES 673 500 173- -35% 5310-455-430640-395 RENTAL EQUIPMENT 72 800 728 91% 5310-455-430640-510 PROPERTY & LIABILITY INS. 51,379 52,000 621 1% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 2,917 3,500 583 17% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 87,853 105,424 17,571 17% 5310-455-430640-528 DATA PROCESSING TRANSFER 15,588 18,705 3,118 17% TOTAL WWTP OPERATIONS ----------- 873,554 ----------- 1,266,616 --------------------- 393,062 31% WWTP REPLACEMENT ----------- ----------- --------------------- 5310-455-430645-362 EQUIPMENT MAINTENANCE 45,286 40,000 5,286- -13% 5310-455-430645-940 MACHINERY & EQUIPMENT 14,588 20,000 5,412 27% TOTAL WWTP REPLACEMENT ----------- 59,874 ----------- ----------- 60,000 ----------- --------------------- 126 --------------------- 0% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 87,609 114,033 26,424 23% 5310-455-430646-121 OVERTIME 0 200 200 100% 5310-455-430646-153 HEALTH INSURANCE 13,754 19,226 5,472 28% 5310-455-430646-155 RETIREMENT 5,423 6,997 1,574 23% 5310-455-430646-210 OFFICE SUPPLIES 0 100 100 100% 5310-455-430646-215 COMPUTER SUPPLIES & SUPPORT 35 50 15 30% 5310-455-430646-216 COMPUTER EQUIPMENT 0 1,400 1,400 100% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 5,523 11,000 5,477 50% 5310-455-430646-222 LAB SUPPLIES 6,035 10,000 3,965 40% 5310-455-430646-224 JANITORIAL SUPPLIES 0 50 50 100% 5310-455-430646-229 OTHER SUPPLIES 175 200 25 13% 5310-455-430646-312 POSTAGE & SHIPPING 405 500 95 19% 5310-455-430646-335 MEMBERSHIP & DUES 126 100 26- -26% 5310-455-430646-336 LICENSES & FEES 140 200 60 30% 5310-455-430646-345 TELEPHONE & ALARMS 0 50 50 100% 5310-455-430646-349 LAB SERVICES 8,075 20,000 11,925 60% 5310-455-430646-362 EQUIPMENT MAINTENANCE 1,903 1,300 603- -46% 5310-455-430646-373 SCHOOL & TRAVEL 1,435 2,500 1,065 43% 5310-455-430646-380 TRAINING MATERIALS 0 ----------- 200 200 100% TOTAL WWTP LAB OPERATIONS 130,638 ----------- 188,106 --------------------- 57,468 31% REVENUE BONDS/WWTP 5310-455-490210-610 DEBT-2002 ISSUE -PRINCIPAL 0 230,000 230,000 100% 5310-455-490210-620 DEBT-2002 INTEREST 9,430 9,430 0 0% 5310-455-490210-630 FISCAL AGENT FEES-2002 BONDS 0 300 300 100% TOTAL REVENUE BONDS/WWTP ----------- 9,430 ----------- ----------- 239,730 ----------- --------------------- 230,300 --------------------- 96% SRF LOAN/WWTP 5310-455-490215-610 DEBT SRF 92003-PRINCIPAL 0 261,000 261,000 100% 5310-455-490215-620 DEBT SRF 92003-INTEREST 24,300 24,300 0 0% TOTAL SRF LOAN/WWTP ----------- 24,300 ----------- 285,300 --------------------- 261,000 91% DEBT SERVICE SRF -new constr. ----------- ----------- --------------------- 5310-455-490227-610 SRF 2007G.'WTP PRINCIPAL 0 215,000 215,000 100% 5310-455-490227-620 SRF 2007WWTP INTEREST 511,819 511,820 1 0% SUBTOTAL SRF 2007 ----------- 511,819 ----------- 726,820 --------------------- 215,001 30% TOTAL WWTP DEBT ----------- 545,549 ----------- ----------- 1,251,850 ----------- --------------------- 706,301 --------------------- 56% CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-831 CITY/EVERGREEN RESERVE TRANSFER 0 411,599 411,599 100% TOTAL DEPRECIATION ---------------------- 0 ---------------------- 411,599 ----------- ---------- 411,599 ----------- ---------- 100% Page 23 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- TOTAL WWTP 1,609,615 3,178,171 1,568,556 49% TOTAL BILLING/SANITARY/WWTP 2,416,947 5,130,789 2,713,842 53% Page 24 83.33% Yr Complete 04/21/11 FUND 5349-000-334040-000 5349-000-343033-000 5349-000-343034-000 5349-000-343035-000 5349-000-343370-000 5349-000-363040-000 5349-000-371010-000 5349-453-430246-110 5349-453-430246-112 5349-453-430246-121 5349-453-430246-153 5349-453-430246-155 5349-453-430246-210 5349-453-430246-214 5349-453-430246-215 5349-453-430246-216 5349-453-430246-218 5349-453-430246-221 5349-453-430246-229 5349-453-430246-231 5349-453-430246-241 5349-453-430246-320 5349-453-430246-345 5349-453-430246-353 5349-453-430246-354 5349-453-430246-355 5349-453-430246-356 5349-453-430246-357 5349-453-430246-358 5349-453-430246-359 5349-453-430246-360 5349-453-430246-362 5349-453-430246-371 5349-453-430246-373 5349-453-430246-388 5349-453-430246-410 5349-453-430246-510 5349-453-430246-521 5349-453-430246-522 5349-453-430246-528 5349-453-430246-530 5349-453-430246-532 5349-453-430246-952 5349-453-430246-954 5349-453-430248-958 5349-453-430248-960 5349-453-510400-831 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND ACTUAL YTD BUDGET ----------------------------------------------------------- STORM SEWER REVENUE PETRO TANK RELEASE/MONITORING REIMB 5,079 20,000 IMPACT FEES 109,201 200,000 PERMIT FEES 1,375 1,500 STORM SEWER CHARGES 0 2,500 STORM SEWER ASSESSMENTS (Billed) 819,078 825,000 PEN & INT ON SPEC ASSESS. 6,526 3,500 INTEREST ON INVESTMENTS 19,378 20,000 TOTAL STORM REVENUE 960,637 1,072,500 STORM SEWER SALARIES -STORM SEWER SEVERANCE OVERTIME HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES/EQUIPMENT CIS SUPPLIES COMPUTER SUPPLIES COMPUTER EQUIPMENT EQUIPMENT -NON CAPITAL SAFETY EQUIP & SUPPLIES OTHER SUPPLIES GAS & OIL CONSUMABLE TOOLS PRINTING TELEPHONE & COMMUNICATION AUDITING CONTRACT SERVICE CONTRACT SERV.-AERIAL MAPPING STORMWATER REG COMPLIANCE PROGRAM RATE STUDY IMPACT STUDY CONSULTANTS-TMDL REPAIR & MAINT SERVICES GROUNDWATER MONITORING CURB & GUTTER SCHOOL & TRAVEL MEDICAL SERVICES CONSTRUCTION MATERIALS PROPERTY & LIABILITY INS. CENTRAL GARAGE TRANSFER ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER BNSF LEASE PMT OFFICE RENT STORM DRAIN CORRECTION S MEADOWS SURVEY STILLWATER/WILLOW GLEN CONST STORMWATER FACILITY UPSIZE DEPRECIATION (FUND $40,000) TOTAL STORM 249,386 12,442 4,082 50,443 16,593 169 0 184 599 0 80 36 5,852 522 0 683 500 413 77 5,951 0 10,689 13,194 1,361 9,638 0 2,365 185 237 7,557 2,083 26,631 4,453 5,018 7,838 4,736 5,300 67 0 0 449,367 347,937 4,400 4,500 66,241 22,037 600 2,000 4,000 3,000 1,000 2,500 1,200 10,500 1,000 200 750 600 3,000 3,000 25,500 8,000 7,000 15,000 1,500 26,000 5,000 3,500 250 10,000 8,500 2,500 31,957 5,344 4,200 7,838 100,000 10,000 5,000 30,000 225,000 REMAINING % 14, 921 90,799 125 2,500 5,922 3, 026- 622 111,863 98,551 8,042- 418 15,798 5,444 431 2,000 3,816 2,401 1,000 2,420 1,164 4, 648 478 200 67 100 2,587 2,923 19,549 8,000 3, 689- 1,806 139 16,362 5,000 1,135 65 9,763 943 417 5,326 891 818- 0 95,264 4,700 4,933 30,000 225,000 1,010,554 561,187 75% 45% 8% 100% 1% -86% 3% 10% 28% -183% 9% 24% 25% 72% 100% 95% 80% 100% 97% 97% 44% 48% 100% 9% 17% 86% 97% 77% 100% -53% 12% 9% 63% 100% 32% 26% 98% 11% 17% 17% 17% -19% 0% 95% 47% 99% 100% 100% 56% Page 25 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Page 26 Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING $ SOLID WASTE REVENUE: ------------ --------------------------- 5510-000-343410-000 GARBAGE COLLECTION (Billed) 799,546 771,500 28,046- -4% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 3,904 3,500 404- -12% 5510-000-371010-000 INVESTMENT EARNINGS 3,067 3,500 433 12% TOTAL SOLID WASTE REVENUE ----------- 806,517 ----------- 778,500 --------------------- 28,017- -4% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 244,505 361,733 117,228 32% 5510-460-430840-112 SEVERANCE -RETIREMENT 4,227 0 4,227- 0% 5510-460-430840-121 OVERTIME 2,578 9,500 6,922 73% 5510-460-430840-153 HEALTH INSURANCE 53,903 65,453 11,550 18% 5510-460-430840-155 RETIREMENT 15,443 22,295 6,852 31% 5510-460-430840-213 SMALL OFFICE EQUIPMENT 501 500 1- 0% 5510-460-430840-216 COMPUTER EQUIPMENT 1,070 3,000 1,930 64% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 8,043 25,000 16,957 68% 5510-460-430840-221 SAFETY EQUIP & SUPPLIES 646 1,500 854 57$ 5510-460-430840-224 JANITORIAL SUPPLIES 332 400 68 17% 5510-460-430840-229 OTHER SUPPLIES 628 2,000 1,372 69% 5510-460-430840-231 GAS & OIL 28,899 47,000 18,101 39% 5510-460-430840-241 CONSUMABLE TOOLS 1,890 1,500 390- -26% 5510-460-430840-341 ELECTRICITY 1,347 1,600 253 16% 5510-460-430840-344 NATURAL GAS 2,266 7,000 4,734 68% 5510-460-430840-345 TELEPHONE & COMMUNICATION 338 700 362 52% 5510-460-430840-354 CONTRACT SERVICES 2,181 12,000 9,819 82% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 1,458 2,000 542 27% 5510-460-430840-366 BUILDING MAINTENANCE 116 2,500 2,384 95% 5510-460-430840-369 RADIO EQUIPMENT & MAINT. 1,300 1,700 400 24% 5510-460-430840-373 SCHOOL & TRAVEL 449 2,500 2,051 82% 5510-460-430840-388 MEDICAL SERVICES 263 550 287 52$ 5510-460-430840-510 PROPERTY & LIABILITY INS. 10,008 12,500 2,492 20% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 6,500 6,500 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 21,667 26,000 4,333 17% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 24,996 29,995 4,999 17% 5510-460-430840-528 DATA PROCESSING TRANSFER 7,794 9,353 1,559 17% 5510-460-430840-532 OFFICE RENT 7,838 7,838 0 0% 5510-460-430845-224 JANITORIAL SUPPLIES 68 350 282 80% 5510-460-430845-341 ELECTRICITY 2,518 3,000 482 16% 5510-460-430845-342 WATER 187 350 163 47% 5510-460-430845-344 NATURAL GAS 6,218 9,500 3,282 35% 5510-460-430845-360 REPAIR & MAINT SERVICES 335 1,000 665 67% 5510-460-430845-366 BUILDING MAINTENANCE 281 1,000 719 72% 5510-460-510400-831 DEPRECIATION EXPENSE 0 100,000 100,000 100% TOTAL SOLID WASTE EXPENSE ----------- 454,293 ----------- 777,817 --------------------- 323,524 42% 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------- 5160 AIRPORT ENTERPRISE FUND --------------- 5160-000-343062-000 COMMERCIAL FEES 6,150 7,500 1,350 18% 5160-000-343063-000 TIE DOWN FEES 2,440 4,000 1,560 39% 5160-000-343069-000 HANGER LEASES 9,040 12,000 2,960 25% 5160-000-343071-000 HANGAR SITE LEASES 16,023 15,600 423- -3% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 13,912 16,545 2,633 16% 5160-000-343102-000 GROUND LEASES 11,054 11,054 0 0% 5160-000-343200-000 UTILITY REBATES 0 1,500 1,500 100% 5160-000-343620-000 FUEL TAX 3,425 6,000 2,575 43% 5160-000-371010-000 INVESTMENT EARNINGS 14,507 15,000 493 3% TOTAL AIRPORT REVENUE ----------- 76,551 ----------- 89,199 --------------------- 12,648 14% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 25,999 33,801 7,802 23% 5160-430-430310-111 SEASONAL SALARIES 949 3,267 2,318 71% 5160-430-430310-153 HEALTH INSURANCE 2,437 3,182 745 23% 5160-430-430310-155 RETIREMENT 1,681 2,406 725 30% 5160-430-430310-210 OFFICE SUPPLIES 390 300 90- -30% 5160-430-430310-218 NON -CAPITAL EQUIPMENT 0 750 750 100% 5160-430-430310-335 MEMBERSHIP & DUES 50 150 100 67% 5160-430-430310-341 ELECTRICITY 1,217 1,500 283 19% 5160-430-430310-345 TELEPHONE 600 1,000 400 40% 5160-430-430310-354 CONTRACT SERVICES 1,335 4,500 3,165 70% 5160-430-430310-355 CONTRACT SERVICES -MOWING 0 1,000 1,000 1000 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 8,485 5,000 3,485- -70% 5160-430-430310-357 CONTRACT SERVICES - legal 27,727 0 27,727- 0% 5160-430-430310-360 REPAIRS & MAINTENANCE 949 3,000 2,051 68% 5160-430-430310-362 EQUIPMENT MAINTENANCE 39 1,000 961 96% 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 3,436 2,000 1,436- -72% 5160-430-430310-373 TRAVEL 1,439 1,750 311 18% 5160-430-430310-380 SIGNAGE 200 300 100 33% 5160-430-430310-390 EQUIPMENT RENTAL 1,775 1,500 275- -18% 5160-430-430310-510 PROPERTY INSURANCE 3,838 6,000 2,162 36% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 3,721 4,465 744 17% 5160-430-430310-528 DATA PROCESSING TRANSFER 2,227 2,672 445 17% 5160-430-430310-820 DEPRECIATION 0 100,832 100,832 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 0 115,470 115,470 100% TOTAL AIRPORT OPERATIONS ----------- 88,494 ----------- 295,845 --------------------- 207,351 70% DATA PROCESSING REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 174,937 174,937 0 0% 6030-000-364030-000 SALE OF MISCELLANEOUS 163 300 137 46% 6030-000-371010-000 INVESTMENT EARNINGS 1,297 2,323 1,026 44% 6030-000-393000-000 INTERNAL SERVICES -DATA 121,353 145,624 24,271 17% TOTAL DATA PROCESSING REVENUE ----------- 297,750 ----------- 323,184 --------------------- 25,434 8% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 58,603 73,787 15,184 21% 6030-401-410580-121 OVERTIME 1,825 0 1,825- 0% 6030-401-410580-153 HEALTH INSURANCE 9,668 12,157 2,489 20% 6030-401-410580-155 RETIREMENT 3,923 4,790 867 18% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 491 1,370 879 64% 6030-403-410580-215 COMPUTER SUPPLIES 606 2,600 1,994 77% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 2,119 15,500 13,381 86% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 19,411 25,000 5,589 22% 6030-403-410580-346 SUMMIT NET Tl CONTRACT 2,378 6,816 4,438 65% 6030-403-410580-353 LASER FICHE MAINTENANCE 1,588 1,600 12 1% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 14,213 17,400 3,187 18% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 24,122 38,592 14,470 37% 6030-403-410580-356 ADG-Electronic Time Sheets 0 7,000 7,000 100% 6030-403-410580-357 GRANICUS 6,000 6,000 0 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 5,796 16,649 10,853 65% 6030-403-410580-373 SCHOOL & TRAVEL 79 6,200 6,121 99% 6030-403-410580-510 INSURANCE 1,190 1,350 160 12% 6030-403-410585-229 COPIER,FAX, SUPPLIES 319 6,000 5,681 95% Page 27 83.33% Yr Complete 04/21/11 CITY OF KALISPELL Quarterly Finance Report April 21, 2011 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 47,697 70,000 22,303 32% 6030-403-410585-532 COPIER LEASES 22,985 30,000 7,015 23% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 0 1,370 1,370 100% 6030-405-410588-940 COMPUTERS - 3 switches 28,153 29,171 1,018 3% 6030-405-410588-942 COMPUTERS - CAPITAL OR CONTINGENCY 8,932 13,000 4,068 31% 6030-410-410588-218 COMPUTERS - DPW 2,970 3,320 350 11% 6030-413-410588-218 COMPUTERS - POLICE DEPT 369 9,147 8,778 96% 6030-416-410588-218 COMPUTERS - FIRE 2,481 5,300 2,819 53% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 1,000 1,000 0 0% 6030-436-410588-218 COMPUTERS - PARKS 2,968 3,300 332 10% TOTAL DATA PROCESSING EXPENSE ----------- 269,886 ----------- 413,419 --------------------- 143,533 35% Page 28 83.33% Yr Complete