Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
3rd Quarter Finance Report
City of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 Date: April 14, 2010 TO: Mayor Fisher and City Council members Jane Howington, City Manager From: Amy Robertson Finance Director RE: 3rd Qtr Finance Report - FY2010 Please find attached a printout reflecting activity for the 3rd quarter of the fiscal year. This report reflects payroll thru March 27`h and the first run of claims paid yesterday, posted to March 31 '. Page 1 —General Fund Revenue Pages 2-27 provide expenditures with revenues for some funds. Police severance, Fire severance and Parks severance were unexpected and not budgeted. Those shortfalls will be absorbed by the vacancies. Funds Presentation Notes: The expenditure budgets follow in fund number order, General fund first. Debt service funds and funds with no activity are not presented. In the Enterprise funds (water, sewer, garbage, and airport) debt service payments are made December 31 st and June 30`h but accrued July V therefore the printout reflects those expenses. Depreciation expense will not be posted until after fiscal year end when the capital outlay accounts are closed out to asset accounts on the balance sheet. The utility fund line items for M & O should be reviewed individually. The wwtp budgeted depreciation amount is the amount we set aside, 1/12 per month, in the cash replacement account shared with Evergreen. It is not an expense but only a reservation of cash and will not appear on the budget print out as an expense. This is true of all amounts reserved for replacement or payment of compensated absences. When preparing the budget we present debt service, replacement and depreciation accounts to show the flow of cash, these numbers appear on this report to reconcile with the budget book. Enterprise fund revenue is the amount billed, not collected. Storm Sewer and Solid Waste revenue is the amount billed on the tax notices by the County. These funds use full accrual accounting. For Non- Enterprise Funds such as Street Maintenance, Lighting and Forestry revenue for assessments is the amount collected to date. Accounting for governmental funds is basically on a cash basis unlike the Enterprise funds. Please call if you have questions — 758-7755 04/14/10 CITY OF KALISPELL Quarterly Finance Report FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,230,598 4,226,561 1,995,963 47% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 1,559 0 1,559- 0% 1000-000-311200-000 PERSONAL PROPERTY TAXES 249,289 244,319 4,970- -2% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 15,832 25,000 9,168 37% 1000-000-322101-000 BEER & LIQUOR LICENSES 300 26,381 26,081 99% 1000-000-322300-000 BUSINESS LICENSES 758 1,200 442 37% 1000-000-322500-000 AMUSEMENT LICENSES 300 600 300 50% 1000-000-323012-000 PLANNING FEES 58,152 75,000 16,849 22% / 1000-000-323107-000 EXCAV/DEMO/AIR/HOUSE MOVING PERMITS 340 500 160 32% 1000-000-323109-000 SITE REVIEW 7,272 30,000 22,728 76% 1000-000-323111-000 ZONING FEES 16,363 65,000 48,637 75% 1000-000-323300-000 ANIMAL LICENSES 670 1,200 530 44% 1000-000-334017-000 911 REIMBURSEMENT/Dispatch 0 3,000 3,000 100% 1000-000-335030-000 M.V. TAX - AD VALOREM 1,990 1,844 146- -8% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 54,975 60,325 5,350 9% 1000-000-335077-000 LIVE KENO & BINGO TAX 0 1,100 1,100 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 2,500 2,500 0 0% 1000-000-335230-000 HB124 ENTITLEMENT 1,664,127 2,270,106 605,979 27% 1000-000-341020-000 ADMINISTRATIVE CHARGES 377,213 492,998 115,785 23% 1000-000-341022-000 BOND FEES/ADMIN.CHG. 0 15,500 15,500 100% 1000-000-341025-000 CITY COLLECTIONS 24,173 1,500 22,673- -1512% 1000-000-341027-000 BRESNAN FRANCHISE FEES 75,078 155,000 79,922 52% 1000-000-342010-000 POLICE SERVICES 9,510 20,000 10,490 52% 1000-000-342014-000 RESOURCE OFFICERS 86,000 86,000 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 12,867 15,000 2,133 14% 1000-000-342023-000 FIRE PREVENTION PROGRAM FEES 16,969 17,000 31 0% 1000-000-342024-000 EPA GRANT -FIRE DEPT DIRECT REIMB. 0 50,000 50,000 100% 1000-000-342025-000 FIRE ENGINE RESPONSE FEE 6,370 5,000 1,370- -27% 1000-000-343005-000 CENTRAL GARAGE CHARGE 89,347 118,000 28,653 24% 1000-000-351000-000 CITY COURT FINES & FEES 284,943 471,000 186,057 40% 1000-000-351015-000 KPD DRUG FINES 794 4,000 3,206 80% 1000-000-351016-000 DUI COURT FINE 1,750 1,000 750- -75% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 17,650 21,000 3,350 16% 1000-000-362010-000 CITY GOLF COURSE LEASE 0 25,471 25,471 100% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 1,464 0 1,464- 0% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 179 3,500 3,321 95% 1000-000-365001-000 KMTC NON-PROFIT DONATIONS 190 0 190- 0% 1000-000-365015-000 CONTRIBUTION FRM KIDSPORT 0 42,000 42,000 100% 1000-000-365018-000 BANDSHELL CONTRIBUTIONS 2,926 0 2,926- 0% 1000-000-371010-000 INVESTMENT EARNINGS 37,039 85,000 47,961 56% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 268,000 516,615 248,615 48% TOTAL REVENUE ----------- 5,617,487 ----------- 9,180,220 --------------------- 3,562,733 39% Page 1 75.00% Yr Complete 04/14/10 CITY OF KALISPELL Page 2 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 965 1,000 35 4% 1000-400-410530-353 AUDITING 13,925 14,275 350 2% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1,591 3,000 1,409 47% 1000-400-410560-312 POSTAGE 9,754 20,000 10,246 51% 1000-400-410560-320 PRINTING 7,057 6,500 557- -9% 1000-400-410600-354 ELECTIONS 6,444 9,000 2,556 28% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1,293 5,000 3,707 74% 1000-400-460446-354 KIDSPORT LEASE 42,275 42,000 275- -1% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 0 32,660 32,660 100% 1000-400-510310-354 ICMA PLAN FEES 375 500 125 25% 1000-400-510330-513 LIABILITY INSURANCE 221,618 223,425 1,807 1% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 10,648 32,000 21,352 67% 1000-400-510330-517 PROPERTY INSURANCE 47,847 48,000 153 0% SUBTOTAL GEN.GOV'T. ----------- 370,392 ----------- 443,960 ----------- ---------- 73,568 17% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 84,773 117,303 32,530 28% 1000-401-410210-153 HEALTH INSURANCE 8,802 12,104 3,302 27% 1000-401-410210-155 RETIREMENT 5,233 7,637 2,404 31% 1000-401-410210-210 OFFICE SUPPLIES 86 100 14 14% 1000-401-410210-215 COMPUTER SOFTWARE/SUPPLIES 0 300 300 100% 1000-401-410210-218 OFFICE FURNITURE 0 500 500 100% 1000-401-410210-229 OTHER SUPPLIES 262 600 338 56% 1000-401-410210-312 NEWSLETTER 0 500 500 100% 1000-401-410210-322 BOOKS 180 150 30- -20% 1000-401-410210-335 MEMBERSHIP & DUES 985 2,100 1,115 53% 1000-401-410210-338 MOVING EXPENSES 15,516 20,000 4,484 22% 1000-401-410210-345 TELEPHONE & COMMUNICATION 26 1,000 974 97% 1000-401-410210-373 SCHOOL & TRAVEL 385 1,800 1,415 79% 1000-401-410210-379 MEETINGS 104 0 104- 0% SUBTOTAL CITY MANAGER ----------- 116,350 ----------- 164,094 --------------------- 47,744 29% HUMAN RESOURCES 1000-401-410830-110 SALARIES -PERSONNEL 76,343 103,338 26,995 26% 1000-401-410830-153 HEALTH INSURANCE 11,065 13,490 2,425 18% 1000-401-410830-155 RETIREMENT 4,974 6,696 1,722 26% 1000-401-410830-210 OFFICE SUPPLIES 64 350 286 82% 1000-401-410830-215 COMPUTER SUPPLIES 91 350 259 74% 1000-401-410830-218 SMALL OFFICE EQUIP/FURNITURE 0 250 250 100% 1000-401-410830-229 OTHER SUPPLIES 0 200 200 100% 1000-401-410830-241 SMALL OFFICE EQUIPMENT 59 0 59- 0% 1000-401-410830-320 PRINTING 0 100 100 100% 1000-401-410830-322 BOOKS 0 150 150 100% 1000-401-410830-335 MEMBERSHIP & DUES 540 400 140- -35% 1000-401-410830-338 RECRUITMENT/NEGOTIATIONS 2,209 3,500 1,291 37% 1000-401-410830-345 TELEPHONE 53 150 97 65% 1000-401-410830-354 CONTRACT SERVICES 100 100 0 0% 1000-401-410830-373 SCHOOL & TRAVEL 2,529 3,500 971 28% SUBTOTAL HUMAN RESOURCES ----------- 98,027 ----------- 132,574 --------------------- 34,547 26% 04/14/10 CITY OF KALISPELL Page 3 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ----------------------------------------------------------------------------------------------------------- MEDIA SPECIALIST 1000-401-410900-110 MEDIA SPECIALIST -salary 14,402 20,102 5,700 28% 1000-401-410900-153 HEALTH INSURANCE 6,407 7,689 1,282 17% 1000-401-410900-155 RETIREMENT 967 1,299 332 26% 1000-401-410900-218 EQUIPMENT 1,008 1,000 8- -1% 1000-401-410900-354 CONTRACT SERVICES 1,750 2,500 750 30% SUBTOTAL MEDIA SPECIALIST ----------- 24,534 ----------- 32,590 ----------- ---------- 8,056 25% MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 45,983 63,162 17,179 27% 1000-402-410100-153 HEALTH INSURANCE 25,250 30,300 5,050 17% 1000-402-410100-155 RETIREMENT 1,907 2,015 108 5% 1000-402-410100-210 Office Supplies 7 100 93 93% 1000-402-410100-335 MEMBERSHIP & DUES 5,756 6,300 544 9% 1000-402-410100-345 TELEPHONE & COMMUNICATION 7 100 93 93% 1000-402-410100-373 SCHOOL & TRAVEL 1,488 3,000 1,512 50% 1000-402-410100-379 MEETINGS 162 300 138 46% SUBTOTAL MAYOR/COUNCIL ----------- 80,560 ----------- 105,277 --------------------- 24,717 23% CITY CLERK 1000-402-410150-110 SALARIES/CITY CLERK 56,451 77,026 20,575 27% 1000-402-410150-121 OVERTIME 205 500 295 59% 1000-402-410150-153 HEALTH INSURANCE 7,430 9,002 1,573 17% 1000-402-410150-155 RETIREMENT 3,671 4,978 1,307 26% 1000-402-410150-210 OFFICE SUPPLIES 89 150 61 41% 1000-402-410150-229 OTHER SUPPLIES 0 50 50 100% 1000-402-410150-335 MEMBERSHIP & DUES 215 275 60 22% 1000-402-410150-345 TELEPHONE & COMMUNICATION 286 400 114 29% 1000-402-410150-352 RECODIFICATION 1,801 3,500 1,699 49% 1000-402-410150-354 CONTRACT SERVICES 0 25 25 100% SUBTOTAL CITY CLERK ----------- 70,147 ----------- 95,906 --------------------- 25,759 27% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 141,579 191,986 50,407 26% 1000-403-410550-121 OVERTIME 94 0 94- 0% 1000-403-410550-153 HEALTH INSURANCE 25,446 30,627 5,181 17% 1000-403-410550-155 RETIREMENT 9,231 12,430 3,199 26% 1000-403-410550-322 BOOKS 254 250 4- -1% 1000-403-410550-335 MEMBERSHIP & DUES 786 1,000 214 21% 1000-403-410550-345 TELEPHONE & COMMUNICATION 44 100 56 56% 1000-403-410550-353 CONTRACT SERVICES 153 470 317 67% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 1,060 1,500 440 29% 1000-403-410550-355 BANK CHARGES & FEES 1,388 4,500 3,112 69% 1000-403-410550-373 SCHOOL & TRAVEL 1,407 2,000 593 30% SUBTOTAL FINANCE ----------- 181,442 ----------- 244,863 --------------------- 63,421 26% 04/14/10 CITY OF KALISPELL Quarterly Finance Report FUND -------------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 226,962 307,944 80,982 26% 1000-404-411110-153 HEALTH INSURANCE 39,098 46,832 7,734 17% 1000-404-411110-155 RETIREMENT 14,795 19,972 5,177 26% 1000-404-411110-210 OFFICE SUPPLIES 554 1,200 646 54% 1000-404-411110-215 COMPUTER SUPPLIES 2,232 1,500 732- -49% 1000-404-411110-322 BOOKS, CDs, LEXIS 3,623 7,000 3,377 48% 1000-404-411110-335 MEMBERSHIP & DUES 1,710 2,500 790 32% 1000-404-411110-345 TELEPHONE & COMMUNICATION 542 1,200 658 55% 1000-404-411110-354 CONTRACT SERVICES 55 5,000 4,945 99% 1000-404-411110-373 SCHOOL & TRAVEL 546 2,525 1,979 78% SUBTOTAL CITY ATTORNEY ----------- 290,118 ----------- 395,673 ----------- 105,555 ---------- 27% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 145,106 199,353 54,247 27% 1000-406-410360-121 OVERTIME 41 0 41- 0% 1000-406-410360-153 HEALTH INSURANCE 29,753 33,977 4,224 12% 1000-406-410360-155 RETIREMENT 9,472 12,908 3,436 27% 1000-406-410360-210 OFFICE SUPPLIES 2,111 1,000 1,111- -111% 1000-406-410360-213 OFFICE EQUIPMENT/MAINT. 1,656 1,000 656- -66% 1000-406-410360-215 COMPUTER SUPPLIES 663 1,000 337 34% 1000-406-410360-229 OTHER SUPPLIES 61 1,500 1,439 96% 1000-406-410360-320 PRINTING 209 500 291 58% 1000-406-410360-322 BOOKS 1,205 1,250 45 4% 1000-406-410360-335 MEMBERSHIP & DUES 200 300 100 33% 1000-406-410360-345 TELEPHONE & COMMUNICATION 2,554 1,400 1,154- -82% 1000-406-410360-353 SECURITY & TECHNOLOGY 1,645 34,750 33,105 95% 1000-406-410360-354 CONTRACT SERVICES 10,084 5,750 4,334- -75% 1000-406-410360-373 SCHOOL & TRAVEL 2,769 6,000 3,231 54% 1000-406-410360-394 JURY & WITNESS FEES 6,690 4,500 2,190- -49% 1000-406-410360-395 DRUG COURT 0 1,000 1,000 100% 1000-406-410360-396 DUI COURT 1,960 0 1,960- 0% SUBTOTAL COURT ----------- 216,179 ----------- 306,188 ----------- 90,009 ---------- 29% DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 8,004 11,624 3,620 31% 1000-410-430100-153 HEALTH INSURANCE 1,358 1,990 632 32% 1000-410-430100-155 RETIREMENT 518 800 282 35% 1000-410-430100-210 OFFICE SUPPLIES 514 675 161 24% 1000-410-430100-213 SMALL OFFICE EQUIPMENT 119 150 31 21% 1000-410-430100-215 COMPUTER SUPPLIES 18 250 232 93% 1000-410-430100-216 COMPUTER EQUIPMEMT/SUPPLIES 767 350 417- -119% 1000-410-430100-229 OTHER SUPPLIES 344 350 6 2% 1000-410-430100-331 PUBLICATION & FILING FEES 246 300 54 18% 1000-410-430100-335 MEMBERSHIP & DUES 603 350 253- -72% 1000-410-430100-345 TELEPHONE & COMMUNICATION 29 1,000 971 97% 1000-410-430100-354 CONTRACT SERVICES 482 150 332- -221% 1000-410-430100-373 SCHOOL & TRAVEL 79 400 321 80% SUBTOTAL ADMINISTRATION ----------- 13,081 ----------- 18,389 ----------- 5,308 ---------- 29% CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 94,020 151,549 57,529 38% 1000-410-431330-121 OVERTIME 1,191 1,500 309 21% 1000-410-431330-153 HEALTH INSURANCE 21,220 29,106 7,886 27% 1000-410-431330-155 RETIREMENT 5,897 9,297 3,400 37% 1000-410-431330-210 OFFICE SUPPLIES 65 300 235 78% 1000-410-431330-215 COMPUTER SUPPLIES 45 800 755 94% 1000-410-431330-218 EQUIPMENT (non -capital) 120 850 730 86% 1000-410-431330-221 SAFETY EQUIP & SUPPLIES 223 150 73- -49% 1000-410-431330-229 OTHER SUPPLIES 4,125 3,500 625- -18% 1000-410-431330-231 GAS & OIL 75,897 122,500 46,603 38% Page 4 75.00% Yr Complete 04/14/10 CITY OF KALISPELL Quarterly Finance Report FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- 1000-410-431330-232 MOTOR VEHICLE PARTS. 62,557 64,000 1,443 2% 1000-410-431330-233 TIRES AND RELATED PARTS 18,560 27,000 8,440 31% 1000-410-431330-238 FILTERS & MISC. PARTS 2,751 3,500 749 21% 1000-410-431330-241 CONSUMABLE TOOLS 473 500 27 5% 1000-410-431330-322 BOOKS 405 150 255- -170% 1000-410-431330-341 ELECTRICITY 1,219 1,700 481 28% 1000-410-431330-342 WATER ill 100 11- -11% 1000-410-431330-344 NATURAL GAS 5,141 9,000 3,859 43% 1000-410-431330-354 CONTRACT SERVICES 48,715 49,600 885 2% 1000-410-431330-362 EQUIPMENT MAINTENANCE 56 250 194 78% 1000-410-431330-366 BUILDING MAINTENANCE 196 335 139 42% 1000-410-431330-373 SCHOOL & TRAVEL 0 600 600 100% 1000-410-431330-388 MEDICAL, SERVICES 130 375 246 65% SUBTOTAL CENTRAL GARAGE ----------- 343,116 ----------- 476,662 --------------------- 133,546 28% TOTAL PUBLIC WORKS 356,197 495,051 138,854 28% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 29,371 40,877 11,506 28% 1000-412-411230-121 OVERTIME 0 200 200 100% 1000-412-411230-153 HEALTH INSURANCE 7,211 8,653 1,443 17% 1000-412-411230-155 RETIREMENT 1,818 2,494 676 27% 1000-412-411230-224 JANITORIAL SUPPLIES 3,766 5,000 1,234 25% 1000-412-411230-229 OTHER SUPPLIES 212 750 538 72% 1000-412-411230-241 CONSUMABLE TOOLS 327 800 473 59% 1000-412-411230-341 ELECTRICITY 28,399 41,000 12,601 31% 1000-412-411230-342 WATER 2,595 4,500 1,905 42% 1000-412-411230-344 NATURAL GAS 24,706 43,300 18,594 43% 1000-412-411230-345 TELEPHONE & COMMUNICATION 159 250 91 36% 1000-412-411230-354 CONTRACT SERVICES 13,673 19,000 5,327 28% 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 1,105 4,500 3,395 75% 1000-412-411230-362 EQUIPMENT MAINTENANCE 3,005 5,000 1,995 40% 1000-412-411230-366 BUILDING MAINTENANCE 4,660 25,178 20,518 81% 1000-412-411230-532 RENT -NEW CITY HALL 97,500 97,500 0 0% 1000-412-411230-545 COUNTY LANDFILL 1,756 2,000 244 12% 1000-412-411230-610 BOI 2004 DEBT (HVAC SYS) 15,150 15,150 0 0% 1000-412-411230-620 BOI 2004 INT. (HVAC SYS) 2,742 2,400 342- -14% SUBTOTAL CITY HALL ----------- 238,154 ----------- 318,552 --------------------- 80,398 25% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 188,761 261,253 72,492 28% 1000-420-411020-153 HEALTH INSURANCE 43,118 52,073 8,955 17% 1000-420-411020-155 RETIREMENT 12,308 16,938 4,630 27% 1000-420-411020-210 OFFICE SUPPLIES 727 2,500 1,773 71% 1000-420-411020-213 OFFICE EQUIPMENT 0 2,000 2,000 100% 1000-420-411020-215 COMPUTER SUPPLIES/SOFTWARE 3,182 5,000 1,818 36% 1000-420-411020-320 PRINTING 0 500 500 100% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 793 4,000 3,207 80% 1000-420-411020-335 MEMBERSHIP/DUES 980 1,300 320 25% 1000-420-411020-345 TELEPHONE 624 900 276 31% 1000-420-411020-354 CONTRACT SERVICES 490 1,350 860 64% 1000-420-411020-373 SCHOOL & TRAVEL 1,953 3,500 1,547 44% TOTAL PLANNING DEPT. ---------------------- 2,295,036 3,086,042 --------------------- 791,006 26% Page 5 75.00% Yr Complete 04/14/10 CITY OF KALISPELL Page 6 Quarterly Finance Report 75.00% Yr Complete FUND -------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % POLICE DEPARTMENT ----------- ----- --- ---------- ----- ---- ------------------- ---------- ----- 1000-413-420140-110 SALARIES -POLICE 1,197,029 1,752,605 555,576 32% 1000-413-420140-112 SALARIES -SEVERANCE 20,958 0 20,958- OAS 1000-413-420140-114 SALARY -comptime buyout 5,747 6,500 753 12% 1000-413-420140-121 OVERTIME 59,483 75,000 15,517 21% 1000-413-420140-123 SPECIAL ASSIGNMENT OVERTIME 2,303 27,500 25,197 92% 1000-413-420140-153 HEALTH INSURANCE 237,352 304,105 66,753 22% 1000-413-420140-155 RETIREMENT 148,730 230,721 81,991 36% 1000-413-420140-210 OFFICE SUPPLIES 2,534 3,000 466 16% 1000-413-420140-215 COMPUTER SUPPLIES 6,134 5,500 634- -12% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 2,344 4,000 1,656 41% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 3,814 5,000 1,186 24% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 2,768 7,000 4,232 60% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,342 2,000 658 33% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 311 5,000 4,689 94% 1000-413-420140-227 AMMO & RELATED SUPPLIES 13,445 15,000 1,555 10% 1000-413-420140-228 PATROL CAR SUPPLIES 7,492 13,000 5,508 42% 1000-413-420140-229 OTHER SUPPLIES 3,370 3,500 130 4% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 1,982 2,000 18 1% 1000-413-420140-231 CRISIS NEGOTIATIONS 867 1,500 633 42% 1000-413-420140-235 BIKE PATROL 365 1,000 635 64% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 0 2,000 2,000 100% 1000-413-420140-320 PRINTING 4,756 5,000 244 5% 1000-413-420140-335 MEMBERSHIP & DUES 980 1,000 20 2% 1000-413-420140-345 TELEPHONE & COMMUNICATION 11,719 15,000 3,281 22% 1000-413-420140-354 CONTRACT SERVICES 3,937 8,000 4,063 51% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 2,680 3,000 320 11% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,083 2,000 83- -4% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 16,350 21,500 5,150 24% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,030 2,500 1,470 59% 1000-413-420140-373 SCHOOL & TRAVEL 24,884 26,000 1,116 4% 1000-413-420140-375 REGIONAL TRAINING 9,435 15,000 5,565 37% 1000-413-420140-376 TESTING (REIMBURSED) 415 2,000 1,585 79% 1000-413-420140-380 TRAINING MATERIALS 983 2,000 1,017 51% 1000-413-420140-388 MEDICAL SERVICES 1,821 8,000 6,179 77% 1000-413-420140-391 TREATMENT 123 500 377 75% 1000-413-420140-392 BOARDING PRISONERS 0 1,000 1,000 100% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 26,730 49,000 22,270 45% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 0 20,000 20,000 100% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 8,000 8,000 0 Ors 1000-413-420141-110 DETECTIVE -SALARIES 238,679 327,330 88,651 27% 1000-413-420141-121 DETECTIVE -OVERTIME 10,122 20,000 9,878 49% 1000-413-420141-153 HEALTH INSURANCE 42,401 54,325 11,924 22% 1000-413-420141-155 DETECTIVE -RETIREMENT 30,866 44,111 13,245 30% 1000-413-420142-110 DISPATCH -SALARIES 228,560 349,487 120,927 35% 1000-413-420142-121 DISPATCH -OVERTIME 9,557 15,000 5,443 36% 1000-413-420142-153 HEALTH INSURANCE 53,738 73,140 19,402 27% 1000-413-420142-155 DISPATCH -RETIREMENT 15,465 22,586 7,121 32% 1000-413-420142-215 COMPUTER SUPPLIES 1,402 1,700 298 1B% 1000-413-420142-234 UNIFORMS 1,374 1,800 426 24% 1000-413-420142-373 SCHOOL & TRAVEL (reimb. 911) 291 6,000 5,709 95% 1000-413-420144-110 SRO SALARIES 82,530 107,306 24,776 23% 1000-413-420144-153 HEALTH INSURANCE 12,261 14,713 2,453 17% 1000-413-420144-155 SRO RETIREMENT 10,636 14,306 3,670 26% 1000-413-420145-354 SHELTER/ANIMAL:VET TREATMENT 150 6,500 6,351 98% SUBTOTAL POLICE DEPT. ----------- 2,572,327 ----------- 3,713,735 --------------------- 1,141,408 31% 04/14/10 CITY OF KALISPELL Quarterly Finance Report FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- FIRE DEPARTMENT 1000-416-420400-110 FIRE SUPPRESSION -SALARIES 1,008,327 1,520,431 512,104 34% 1000-416-420400-112 SALARY -SEVERANCE & comptime buyback 42,460 2,500 39,960- -1598% 1000-416-420400-113 KELLY DAYS 21,529 40,000 18,471 46% 1000-416-420400-121 OVERTIME 24,732 19,153 5,579- -29% 1000-416-420400-153 HEALTH INSURANCE 205,490 242,475 36,985 15% 1000-416-420400-155 RETIREMENT 143,568 206,254 62,686 30% 1000-416-420400-210 OFFICE SUPPLIES 288 850 562 66% 1000-416-420400-213 SMALL OFFICE EQUIPMENT 946 200 746- -373% 1000-416-420400-215 COMPUTER SUPPLIES 85 500 415 83% 1000-416-420400-218 Equipment (Non Capital) 3,380 5,000 1,620 32% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 7,112 11,000 3,888 35% 1000-416-420400-224 JANITORIAL SUPPLIES 703 700 3- 0% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 5,406 10,000 4,594 46% 1000-416-420400-320 PRINTING 70 200 130 65% 1000-416-420400-345 TELEPHONE & COMMUNICATION 4,123 6,000 1,877 31% 1000-416-420400-354 CONTRACT SERVICES 874 5,000 4,126 83% 1000-416-420400-358 MT. F/F TESTING CONSORTIUM 0 1,000 1,000 100% 1000-416-420400-362 EQUIPMENT MAINTENANCE 3,420 5,000 1,580 32% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,576 15,500 13,924 90% 1000-416-420400-373 SCHOOL & TRAVEL 295 1,500 1,205 80% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 51,550 51,550 0 0% 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 16,473 16,475 2 0% 1000-416-420440-110 FIRE PREVENTION -SALARIES 43,097 70,890 27,793 39% 1000-416-420440-153 HEALTH INSURANCE 9,201 13,186 3,985 30% 1000-416-420440-155 RETIREMENT 5,260 9,574 4,314 45% 1000-416-420440-210 OFFICE SUPPLIES 547 500 47- -9% 1000-416-420440-241 CONSUMABLE TOOLS/UNIFORMS 1,522 1,000 522- -52% 1000-416-420440-314 PRIVATE HYDRANT RENTAL 0 5,500 5,500 100% 1000-416-420440-320 PRINTING 366 500 134 27% 1000-416-420440-322 BOOKS 105 500 395 79% 1000-416-420440-333 SUBSCRIPTION/FIRE CODES 217 500 283 57% 1000-416-420440-335 MEMBERSHIP/DUES 424 250 174- -70% 1000-416-420440-345 TELEPHONE/COMMUNICATIONS 2,149 2,500 351 14% 1000-416-420440-354 CONTRACT SERVICES 1,704 1,000 704- -70% 1000-416-420440-373 SCHOOL & TRAVEL 958 1,000 42 4% 1000-416-420440-379 MEETINGS 24 500 476 95% 1000-416-420440-380 TRAINING MATERIALS 65 500 435 87% 1000-416-420465-322 BOOKS 0 500 500 100% 1000-416-420465-380 TRAINING MATERIALS 589 2,000 1,411 71% 1000-416-420470-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 1000-416-420470-218 EQUIPMENT (NOT CAPITAL) 1,885 2,500 615 25% 1000-416-420470-224 JANITORIAL SUPPLIES 672 750 78 10% 1000-416-420470-241 CONSUMABLE TOOLS 210 400 190 48% 1000-416-420470-341 ELECTRICITY 6,724 10,000 3,276 33% 1000-416-420470-342 WATER 1,635 2,800 1,165 42% 1000-416-420470-344 NATURAL GAS 6,893 15,000 8,107 54% 1000-416-420470-354 CONTRACT SERVICES 967 2,000 1,033 52% 1000-416-420470-362 EQUIPMENT MAINTENANCE 1,273 1,500 227 15% 1000-416-420470-366 BUILDING MAINTENANCE 1,662 ----------- 1,500 162- -11% SUBTOTAL FIRE DEPT. 1,630,553 ----------- 2,308,338 --------------------- 677,785 29% GRAND TOTAL GENERAL FUND 4,202,881 6,022,073 1,819,193 30% Page 7 75.00% Yr Complete 04/14/10 CITY OF KALISPELL Page 8 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------------------------------------------------------------------- SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 750 1,200 450 38% 2185-000-430300-356 PROFESSIONAL SERVICES 7,844 15,000 7,156 48% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 10,166 13,554 3,389 25% 2185-000-430300-840 REDEVELOPMENT CONTIGENCY 400 800,000 799,600 100% 2185-436-460430-218 LAKER'S BALLFIELD IMPROVEMENTS 2,305 10,000 7,695 77% 2185-436-460430-934 BEGG PARK IMPROVEMENTS 344 42,142 41,798 99% 2185-480-470240-110 SALARIES 29,354 49,113 19,759 40% 2185-480-470240-153 HEALTH INSURANCE 2,980 5,143 2,164 42% 2185-480-470240-155 RETIREMENT 1,911 3,188 1,277 40% TOTAL AIRPORT TIF ----------- 56,052 ----------- 939,340 --------------------- 883,288 94% 2188 WESTSIDE TIF 2188-436-460430-930 GREENBRIAR PARK IMPROVEMENTS 13,849 18,180 4,331 24% 2188-453-430246-950 GLENWOOD DR STORMDRAIN CONST 67,876 135,000 67,124 50% 2188-453-430246-951 PAVING 21,460 30,000 8,540 28% 2188-453-430246-952 LOWER SPRING CREEK 3,846 40,000 36,154 90% 2168-453-430246-953 3 MILE DR ROAD DESIGN 92,452 146,926 54,474 37% 2188-453-430246-955 US 93 BYPASS CONST 140 225,884 225,744 100% 2188-480-470230-110 SALARIES 4,440 8,500 4,060 48% 2188-480-470230-153 HEALTH INSURANCE 530 1,000 470 47% 2188-480-470230-155 RETIREMENT 289 500 211 42% 2188-480-470230-353 AUDIT 375 750 375 50% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 300 5,000 4,700 94% 2188-480-470230-356 REDEVELOPMENT APPRAISALS 1,326 25,000 23,674 95% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 18,750 25,000 6,250 25% 2188-480-470230-955 CD -REDEVELOPMENT ACTIVITY 425 1,500,000 1,499,575 100% TOTAL WESTSIDE TIF ----------- 226,058 ----------- 2,161,740 ----------- ---------- 1,935,682 90% 2210 PARKS IN LIEU 2210-436-460430-826 TRANSFER TO ISTEA FUND 0 30,000 30,000 100% 2210-436-460430-934 CAPITAL IMPROVEMENTS 0 5,000 5,000 100% 2210-436-460430-935 SUNSET BASKETBALL COURT 0 5,500 5,500 100% 2210-436-460430-937 WESTVIEW IMPROVEMENTS 0 17,500 17,500 100% TOTAL PARKS IN LIEU ----------- 0 ----------- 58,000 --------------------- 58,000 100% 2215-NEW PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 441,507 850,000 408,493 48% 2215-000-312000-000 PEN & INTEREST DEL TAXES 413 0 413- 0% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 3,275 5,000 1,725 35% 2215-000-346030-000 SWIMMING POOL FEES 85,300 160,000 74,700 47% 2215-000-346040-000 CONCESSION STAND REVENUE 22,455 35,000 12,545 36% 2215-000-346050-000 Parks Usage Fees 11,843 18,000 6,157 34% 2215-000-346051-000 RECREATION FEES 5,510 15,000 9,490 63% 2215-000-346052-000 SPORTS PROGRAMS 32,107 40,000 7,893 20% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 3,670 3,000 670- -22% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 20,311 33,500 13,1B9 39% 2215-000-346055-000 ICE RINK 10,221 25,000 14,779 59% 2215-000-346057-000 YOUTH CAMPS 18,181 85,000 66,819 79% 2215-000-346059-000 PICNIC IN THE PARK 9,668 33,000 23,332 71% 2215-000-365010-000 DONATION/FERTILIZER 600 0 600- 0% 2215-000-371010-000 INVESTMENT EARNINGS 35 0 35- 0% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 60,000 60,000 0 0% TOTAL PARKS & REC REVENUE ----------- 725,097 ----------- 1,362,500 --------------------- 637,403 47% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 175,935 263,573 87,638 33% 2215-436-460430-111 SEASONAL SALARIES 13,642 30,546 16,904 55% 04/14/10 CITY OF KALISPELL Page 9 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % •-------------------------------------------------------------------------------------------------------- 2215-436-460430-112 SEVERANCE 12,091 0 12,091- 0% 2215-436-460430-121 OVERTIME 256 1,500 1,244 83% 2215-436-460430-153 HEALTH INSURANCE 45,064 54,803 9,739 18% 2215-436-460430-155 RETIREMENT 12,951 18,364 5,413 29% 2215-436-460430-210 OFFICE SUPPLIES 466 1,200 734 61% 2215-436-460430-213 SMALL OFFICE EQUIPMENT 0 B00 800 100% 2215-436-460430-215 COMPUTER SUPPLIES 67 1,000 933 93% 2215-436-460430-221 SAFETY EQUIPMENT 90 950 860 91% 2215-436-460430-224 JANITORIAL SUPPLIES 1,619 3,000 1,381 46% 2215-436-460430-229 OTHER SUPPLIES 1,439 6,000 4,561 76% 2215-436-460430-241 CONSUMABLE TOOLS/SMALL EQUIPMENT 1,350 1,600 250 16% 2215-436-460430-320 PRINTING 0 456 456 100% 2215-436-460430-333 SUBSCRIPTIONS 209 250 41 16% 2215-436-460430-335 MEMBERSHIP & DUES 155 450 295 66% 2215-436-460430-337 ADVERTISING 0 500 500 100% 2215-436-460430-341 ELECTRICITY 12,732 14,250 1,518 11% 2215-436-460430-342 WATER/SEWER 0 400 400 100% 2215-436-460430-344 NATURAL GAS 2,321 3,200 879 27% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 2,158 3,000 842 28% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 1,500 5,000 3,500 70% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 0 3,000 3,000 100% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT MAINTENANCE 271 1,500 1,229 82% 2215-436-460430-364 LANDSCAPING 36 3,000 2,964 99% 2215-436-460430-366 BUILDING MAINTENANCE 8 4,000 3,992 100% 2215-436-460430-367 VANDALISM REPAIRS 1,159 4,000 2,841 71% 2215-436-460430-373 SCHOOL & TRAVEL 1,140 1,200 60 5% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 235 550 316 57% 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 METAL PRODUCTS/FENCING 0 1,500 1,500 100% 2215-436-460430-430 WOOD PRODUCTS/PICNIC TABLES 537 2,000 1,463 73% 2215-436-460430-440 IRRIGATION SUPPLIES 470 4,000 3,530 88% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 0 4,000 4,000 100% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 17,025 17,027 2 0% 2215-436-460430-620 DEBT SERVICE INTEREST 412 413 1 0% TOTAL PARKS EXPENDITURES ----------- 305,340 ----------- 459,032 ----------- ---------- 153,692 33% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 33,945 46,179 12,234 26% 2215-436-460440-111 SEASONAL SALARIES 25,140 43,360 18,220 42% 2215-436-460440-153 HEALTH INSURANCE 11,003 13,204 2,201 17% 2215-436-460440-155 RETIREMENT 3,342 3,641 299 8% 2215-436-460440-221 SAFETY EQUIPMENT 0 175 175 100% 2215-436-460440-229 OTHER SUPPLIES 2,231 16,900 14,669 87% 2215-436-460440-241 CONSUMABLE TOOLS 0 700 700 100% 2215-436-460440-335 MEMBERSHIP & DUES 0 135 135 100% 2215-436-460440-341 ELECTRICITY 0 3,413 3,413 100% 2215-436-460440-345 TELEPHONE & COMMUNICATION 242 350 108 31% 2215-436-460440-354 CONTRACT SERVICES 65 1,000 935 94% 2215-436-460440-362 EQUIPMENT MAINTENANCE 298 500 202 40% 2215-436-460440-364 LANDSCAPING 0 2,000 2,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 0 500 500 100% 2215-436-460440-440 IRRIGATION 2,678 3,000 322 11% 2215-436-460440-452 SAND & GRAVEL 268 1,200 932 78% TOTAL ATHLETIC COMPLEX ----------- 79,213 ----------- 136,707 ----------- ---------- 57,494 42% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 64,886 88,750 23,864 27% 2215-436-460431-111 SEASONAL SALARIES 9,781 13,704 3,923 29% 2215-436-460431-121 OVERTIME 0 500 500 100% 2215-436-460431-153 HEALTH INSURANCE 14,337 17,204 2,867 17% 2215-436-460431-155 RETIREMENT 8,697 5,475 3,222- -59% 2215-436-460431-210 OFFICE SUPPLIES 452 600 148 25% 2215-436-460431-229 OTHER SUPPLIES 5,617 10,000 4,383 44% 04/14/10 CITY OF KALISPELL Quarterly Finance Report FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- 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 135 300 165 55% 2215-436-460431-337 ADVERTISING 0 500 500 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 780 1,300 520 40% 2215-436-460431-354 CONTRACT SERVICES 17,311 25,000 7,689 31% 2215-436-460431-355 BANK FEES/CREDIT CARD FEES 881 2,500 1,619 65% 2215-436-460431-373 SCHOOL & TRAVEL 731 1,200 469 39% TOTAL RECREATION ----------- 123,609 ----------- 173,133 ----------- ---------- 49,524 29% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 48,049 65,238 17,189 26% 2215-436-460448-111 SEASONAL SALARIES 51,321 88,749 37,428 42% 2215-436-460448-121 OVERTIME 0 500 500 100% 2215-436-460448-153 HEALTH INSURANCE 13,528 16,234 2,706 17% 2215-436-460448-155 RETIREMENT 3,358 5,244 1,886 36% 2215-436-460448-210 OFFICE SUPPLIES 0 500 500 100% 2215-436-460448-229 OTHER SUPPLIES 818 6,000 5,182 86% 2215-436-460448-320 PRINTING 0 300 300 100% 2215-436-460448-335 MEMBERSHIP & DUES 0 300 300 100% 2215-436-460448-337 ADVERTISING 0 300 300 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 0 600 600 100% 2215-436-460446-354 CONTRACT SERVICES 10,572 13,000 2,428 19% 2215-436-460448-355 AFTER SCHOOL PROGRAM 1,116 4,000 2,884 72% 2215-436-460448-366 BUILDING MAINTENANCE 225 5,000 4,775 96% 2215-436-460448-373 SCHOOL & TRAVEL 153 1,000 847 85% TOTAL YOUTH CAMPS ----------- 129,139 ----------- 206,965 ----------- ---------- 77,826 38% ICE RINK EXPENDITURES 2215-436-460450-111 SEASONAL SALARIES 5,210 15,349 10,139 66% 2215-436-460450-155 RETIREMENT 321 716 395 55% 2215-436-460450-210 OFFICE SUPPLIES 0 50 50 100% 2215-436-460450-229 OTHER SUPPLIES 0 300 300 100% 2215-436-460450-341 CONSUMABLE TOOLS 0 5,600 5,600 100% 2215-436-460450-343 UTILITIES 21,689 20,000 1,689- -8% 2215-436-460450-362 EQUIPMENT MAINTENANCE 0 2,600 2,600 100% TOTAL ICE RINK ----------- 27,220 ----------- 44,615 --------------------- 17,395 39% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 121,727 201,359 79,632 40% 2215-437-460445-121 OVERTIME 890 500 390- -78% 2215-437-460445-155 RETIREMENT 1,335 1,266 69- -5% 2215-437-460445-210 OFFICE SUPPLIES 172 500 328 66% 2215-437-460445-213 SMALL OFFICE EQUIPMENT 16 200 184 92% 2215-437-460445-221 SAFETY EQUIPMENT/SUPPLIES 0 200 200 100% 2215-437-460445-224 JANITORIAL SUPPLIES 581 2,500 1,919 77% 2215-437-460445-226 CHLORINE/CHEMICALS 17,688 16,500 1,188- -7% 2215-437-460445-228 CONCESSION STAND SUPPLIES 14,640 18,500 3,860 21% 2215-437-460445-229 OTHER SUPPLIES 1,315 4,500 3,185 71% 2215-437-460445-241 CONSUMABLE TOOLS 144 400 256 64% 2215-437-460445-320 PRINTING 0 50 50 100% 2215-437-460445-341 ELECTRICITY 7,380 12,500 5,120 41% 2215-437-460445-344 NATURAL GAS 14,218 28,000 13,782 49% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,012 1,500 488 33% 2215-437-460445-354 LICENSES & FEES 683 1,300 617 47% 2215-437-460445-362 EQUIPMENT MAINTENANCE 1,769 4,000 2,231 56% 2215-437-460445-366 BUILDING MAINTENANCE 518 1,500 982 65% 2215-437-460445-380 TRAINING MATERIALS 0 250 250 100% TOTAL POOL EXPENDITURES ---------------------- 184,088 295,525 --------------------- 111,437 38% TOTAL PARKS & RECREATION/POOL 848,609 1,315,977 467,368 36% Page 10 75.00% Yr Complete 04/14/10 CITY OF KALISPELL Page 11 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------------------------------------------------------------------- 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 487,046 765,000 277,954 36% 2230-000-342052-000 OUT OF CITY SURCHARGE 190 0 190- 0% 2230-000-342070-000 COUNTY EMS LEVY 44,170 90,000 45,830 51% 2230-000-371010-000 INTEREST EARNINGS 182 0 182- 0% TOTAL AMBULANCE REVENUE ----------- 531,588 ----------- 855,000 --------------------- 323,412 38% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 264,376 475,779 211,403 44% 2230-440-420730-113 KELLY DAYS 3,599 10,000 6,401 64% 2230-440-420730-121 OVERTIME 5,322 6,038 716 12% 2230-440-420730-153 HEALTH INSURANCE 52,989 79,149 26,160 33% 2230-440-420730-155 RETIREMENT 33,924 60,444 26,520 44% 2230-440-420730-210 OFFICE SUPPLIES 330 1,000 670 67% 2230-440-420730-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 2230-440-420730-215 COMPUTER SUPPLIES 450 2,000 1,550 77% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 1,875 2,000 125 6% 2230-440-420730-231 GAS AND OIL 5,441 10,000 4,559 46% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 673 5,000 4,327 87% 2230-440-420730-312 POSTAGE 1,504 3,000 1,496 50% 2230-440-420730-320 PRINTING 65 500 435 87% 2230-440-420730-345 TELEPHONE & COMMUNICATION 399 700 301 43% 2230-440-420730-353 AUDITING 625 500 125- -25% 2230-440-420730-354 CONTRACT SERVICES/RECERT. 2,229 8,000 5,771 72% 2230-440-420730-358 MT FF TESTING CONSORTIUM 0 500 500 100% 2230-440-420730-359 CC FEES/COLLECTION SERV. 1,036 500 536- -107% 2230-440-420730-362 EQUIPMENT MAINTENANCE 3,060 3,500 440 13% 2230-440-420730-369 RADIO MAINTENANCE 169 2,500 2,331 93% 2230-440-420730-380 TRAINING MATERIALS 1,492 3,000 1,508 50% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 2,937 5,000 2,063 41% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 32,905 38,000 5,095 13% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 13,703 17,134 3,432 20% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 6,000 8,000 2,000 25% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 27,059 36,078 9,020 25% 2230-440-420730-528 DATA PROCESSING TRANSFER 8,359 11,145 2,786 25% 2230-440-420730-940 EQUIPMENT 0 7,500 7,500 100% 2230-440-420730-943 AMBULANCE 0 ----------- 30,000 30,000 100% TOTAL AMBULANCE FUND 470,521 ----------- 827,167 --------------------- 356,646 43% 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 115,790 150,000 34,210 23% 2394-000-323103-000 PLUMBING PERMITS 9,863 22,500 12,637 56% 2394-000-323104-000 MECHANICAL PERMITS 17,472 30,000 12,528 42% 2394-000-323107-000 HOUSE MOVING PERMITS 300 100 200- -200% 2394-000-323108-000 PLAN REVIEW FEES 45,047 120,000 74,953 62% 2394-000-371010-000 INVESTMENT EARNINGS 369 2,000 1,631 82% TOTAL REVENUE ----------- 188,841 ----------- 324,600 --------------------- 135,759 42% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 177,215 253,056 75,841 30% 2394-420-420530-112 SALARIES -SEVERANCE 0 2,500 2,500 100% 2394-420-420530-121 OVERTIME 810 2,000 1,190 60% 2394-420-420530-153 HEALTH INSURANCE 37,737 44,987 7,250 16% 2394-420-420530-155 RETIREMENT 11,143 15,993 4,850 30% 2394-420-420530-210 OFFICE SUPPLIES 324 2,000 1,676 84% 2394-420-420530-215 COMPUTER SUPPLIES 144- 3,500 3,644 104% 2394-420-420530-229 OTHER SUPPLIES 657 2,250 1,593 71% 2394-420-420530-231 GAS & OIL 1,078 2,500 1,422 57% 2394-420-420530-312 POSTAGE 341 600 259 43% 2394-420-420530-320 PRINTING 117 300 183 61% 2394-420-420530-322 BOOKS 1,930 2,250 320 14% 2394-420-420530-323 ST. ED. ASSESSMENTS 723 2,500 1,777 71% 04/14/10 CITY OF KALISPELL Page 12 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ------------------------------------------------------------------------------------------------------------- 2394-420-420530-331 PUBLICATION & FILING FEES 0 200 200 100% 2394-420-420530-335 MEMBERSHIP & DUES 30- 900 930 103% 2394-420-420530-345 TELEPHONE & COMMUNICATION 916 1,500 584 39% 2394-420-420530-353 AUDITING 0 3,000 3,000 100% 2394-420-420530-354 CONTRACT SERVICES 923 500 423- -85% 2394-420-420530-366 BUILDING MAINTENANCE 18 800 782 98% 2394-420-420530-373 SCHOOL & TRAVEL 1,357 5,000 3,643 73% 2394-420-420530-510 PROPERTY INSURANCE 6,947 8,800 1,853 21% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 450 600 150 25% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 9,265 12,353 3,088 25% 2394-420-420530-528 DATA PROCESSING TRANSFER 3,134 4,179 1,045 ---------- 25% TOTAL BUILDING DEPT. ----------- 254,911 ----------- ----------- ----------- 372,26E ----------- ---------- ----------- 117,357 --------------------- ------------------- 32% 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 7,100 7,100 0 0% 2399-413-420140-354 IMPACT FEE REVIEW 0 500 500 100% 2399-413-420140-940 POLICE EQUIPMENT 0 20,000 20,000 100% 2399-416-420400-354 IMPACT FEE REVIEW 0 500 500 100% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 24,750 24,750 0 0% 2399-416-420400-620 INTEREST - FIRE TRUCK 10,395 10,310 85- -1% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 165,000 165,000 100% TOTAL 2399 IMPACT FEE FUND ----------- 42,245 ----------- 228,160 --------------------- 185,915 81% 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 18,357 30,182 11,825 39% 2400-410-430263-153 HEALTH INSURANCE 5,143 7,922 2,779 35% 2400-410-430263-155 RETIREMENT 1,143 1,833 690 38% 2400-410-430263-244 STREET LIGHT SUPPLIES 4,199 13,000 8,801 68% 2400-410-430263-341 ELECTRICITY 109,688 145,000 35,312 24% 2400-410-430263-360 REPAIR & MAINT SERVICES 6,307 28,000 21,693 77% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 5,758 7,677 1,919 25% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 0 14,000 14,000 100% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 228 560 332 59% TOTAL LIGHT MAINT. ----------- 150,823 ----------- 248,174 ----------- ---------- 97,351 39% 2420 GAS TAX ----------- ----------- -------------------�- 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 27,785 44,000 16,215 37% 2420-421-430234-957 ALLEY PAVING 25,330 25,000 330- -1% 2420-421-430240-231 GAS & OIL 16,674 35,000 18,326 52% 2420-421-430240-344 NATURAL GAS 4,645 2,500 2,145- -86% 2420-421-430240-354 CONTRACT SERVICES 50,338 100,000 49,663 50% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 17,000 17,000 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 155,024 250,000 94,976 38% 2420-421-430240-369 RADIO EQUIPMENT & MAINT. 0 700 700 100% 2420-421-430240-452 GRAVEL 116 4,000 3,884 97% 2420-421-430240-453 MATERIALS; CONTRACT PREP. 325 5,000 4,675 94% 2420-421-430240-471 DE-ICER/ROAD OIL 37,935 50,000 12,065 24% 2420-421-430240-472 ASPHALT 13,642 25,000 11,358 45% 2420-421-430240-473 CRACK SEALING 4,412 5,000 588 12% 2420-421-430240-533 EQUIPMENT RENTAL 252 ----------- 5,500 5,248 ---------- 95% TOTAL GAS TAX 336,478 ----------- ---------- ----------- 568,700 ----------- ---------- ----------- 232,222 --------------------- -------------------- 41% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 395,164 574,524 179,360 31% 2500-421-430240-112 RETIREMENT -severance 4,588 0 4,588- 0% 2500-421-430240-121 OVERTIME 17,541 30,000 12,459 42% 2500-421-430240-153 HEALTH INSURANCE 89,443 109,112 19,669 18% 2500-421-430240-155 RETIREMENT 25,925 35,243 9,318 26% 2500-421-430240-213 SMALL OFFICE EQUIPMENT 0 500 500 100% 2500-421-430240-216 COMPUTER EQUIPMEMT 1,624 1,850 226 12% 2500-421-430240-218 EQUIPMENT (NON CAPITAL) 440 1,000 560 56% 2500-421-430240-221 SAFETY EQUIPMENT 1,070 1,000 70- -7% 04/14/10 CITY OF KALISPELL Page 13 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------------------------------------------------------------------- 2500-421-430240-224 JANITORIAL SUPPLIES 444 700 256 37% 2500-421-430240-229 OTHER SUPPLIES 659 1,200 541 45% 2500-421-430240-231 GAS & OIL 17,071 40,000 22,929 57% 2500-421-430240-241 CONSUMABLE TOOLS 709 2,000 1,291 65% 2500-421-430240-341 ELECTRICITY 907 700 207- -30% 2500-421-430240-342 WATER/SEWER CHARGES ill 150 39 26% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 728 1,200 472 39% 2500-421-430240-354 CONTRACT SERVICES 8,449 13,000 4,551 35% 2500-421-430240-355 CONTRACT SERV.-AERIAL MAPPING 127 13,000 12,873 99% 2500-421-430240-357 RATE STUDY 12,025 22,500 10,475 47% 2500-421-430240-358 IMPACT FEE STUDY 0 7,000 7,000 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 23,220 22,000 1,220- -6% 2500-421-430240-366 BUILDING MAINTENANCE 561 1,500 939 63% 2500-421-430240-369 RADIO EQUIPMENT & MAINT. 607 5,000 4,393 88% 2500-421-430240-373 SCHOOL & TRAVEL 966 3,500 2,534 72% 2500-421-430240-388 MEDICAL SERVICES 1,280 900 380- -42% 2500-421-430240-510 LIABILITY INSURANCE 65,037 66,000 963 1% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 2,096 16,500 14,404 87% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 47,250 63,000 15,750 25% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 37,754 50,339 12,585 25% 2500-421-430240-528 DATA PROCESSING TRANSFER 8,359 11,145 2,786 25% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 780 12,727 11,947 94% 2500-421-430240-840 MACI GRANT MATCH 29,563 30,000 437 1% 2500-421-430240-935 PAVEMENT MAINTENANCE funds 347,049 585,988 238,940 41% 2500-421-430240-940 MACHINERY & EQUIPMENT 400 170,000 169,600 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 57,777 70,000 12,223 17% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 6,296 37,337 31,041 83% 2500-421-430264-110 TSS - SALARIES 101,422 140,245 38,823 28% 2500-421-430264-121 OVERTIME 6,557 8,000 1,443 18% 2500-421-430264-153 HEALTH INSURANCE 14,142 19,722 5,580 28% 2500-421-430264-155 RETIREMENT 6,666 8,781 2,115 24% 2500-421-430264-216 COMPUTER EQUIP & SOFTWARE 257 1,500 1,243 83% 2500-421-430264-218 EQUIPMENT(non-capital) 2,914 3,600 686 19% 2500-421-430264-221 SAFETY EQUIPMENT & SUPPLIES 196 500 304 61% 2500-421-430264-224 JANITORIAL SUPPLIES 630 650 20 3% 2500-421-430264-229 OTHER SUPPLIES 373 800 427 53% 2500-421-430264-241 CONSUMABLE TOOLS 937 1,100 163 15% 2500-421-430264-242 STREET SIGNS 32,003 35,000 2,997 9% 2500-421-430264-243 TRAFFIC SIGNALS 331 10,000 9,669 97% 2500-421-430264-245 BARRICADE MATERIALS 2,328 4,000 1,672 42% 2500-421-430264-341 ELECTRICITY 6,336 11,000 4,664 42% 2500-421-430264-345 COMMUNICATIONS 525 800 276 34% 2500-421-430264-354 CONTRACT SERVICES 5,905 10,000 4,095 41% 2500-421-430264-362 EQUIPMENT MAINTENANCE 836 1,400 564 40% 2500-421-430264-366 BUILDING MAINTENANCE 1,275 1,500 225 15% 2500-421-430264-369 RADIO MAINTENANCE 0 900 900 100% 2500-421-430264-373 SCHOOL & TRAVEL 1,222 3,500 2,278 65% 2500-421-430264-428 PAINT MATERIALS 3,631 25,000 21,369 85% 2500-421-430264-510 LIABILITY INS.-TSS 5,205 5,775 570 10% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 1,917 1,000 917- -92% 2500-421-430264-532 OFFICE RENT 7,838 7,838 0 0% TOTAL SPEC. ST. MAINT. ----------- 1,409,465 ----------- 2,303,226 --------------------- 893,761 39% 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 88,021 131,520 43,499 33% 2600-436-460433-112 SEVERANCE 4,030 0 4,030- 0% 2600-436-460433-121 OVERTIME 78 750 672 90% 2600-436-460433-153 HEALTH INSURANCE 18,017 25,066 7,049 28% 2600-436-460433-155 RETIREMENT 5,738 8,236 2,498 30% 2600-436-460433-210 OFFICE SUPPLIES 0 50 50 100% 2600-436-460433-229 OTHER SUPPLIES 106 500 394 79% 2600-436-460433-241 CONSUMABLE TOOLS 272 450 178 40% 2600-436-460433-333 SUBSCRIPTIONS 15 50 35 70% 2600-436-460433-354 CONTRACT SERVICES 0 1,500 1,500 100% 2600-436-460433-357 FORESTRY GRANT 2,084 5,225 3,141 60% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 0 10,000 10,000 100% 04/14/10 CITY OF KALISPELL Page 14 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % 2600-436-460433-362 EQUIPMENT MAINTENANCE 271 500 229 46% 2600-436-460433-364 LANDSCAPING & TREES 2,185 7,000 4,815 69% 2600-436-460433-373 SCHOOL & TRAVEL 0 250 250 100% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 4,192 4,945 753 15% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 1,875 2,500 625 25% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 5,110 6,613 1,703 25% 2600-436-460433-528 DATA PROCESSING TRANSFER 1,045 1,393 348 25% TOTAL URBAN FORESTRY ----------- 133,040 ----------- 206,748 ----------- ---------- 73,708 36% 2602 ARRA FORESTRY GRANT 2602-436-460433-354 CONTRACT SERVICES 62,490 93,500 31,011 33% TOTAL ARRA FORESTRY GRANT ----------- 62,490 ----------- 93,500 --------------------- 31,011 33% 2880 COM DEV REVOLVING FUND 2880-480-470240-708 REDEVELOPMENT FUNDS -DISTRIBUTION 25,776 25,776 0 0% 2880-480-470240-711 IRP LOAN PROGRAM MATCH 11 150,000 149,989 100% 2880-480-470240-720 EAGLE TRANSIT 0 15,000 15,000 100% TOTAL LOAN REVOLVING ----------- 25,787 ----------- ----------- ----------- 190,776 ----------- ---------- ----------- ---------- 164,989 -------------------- -------------------- 86% 2886 UDAG FUND 2886-480-470210-110 SALARIES - UDAG 45,738 95,074 49,336 52% 2886-480-470210-153 HEALTH INSURANCE 5,580 11,769 6,189 53% 2886-480-470210-155 RETIREMENT 2,979 6,619 3,640 55% 2886-480-470210-210 OFFICE SUPPLIES 56 500 444 89% 2886-480-470210-211 GRANT ADMIN. EXPENSES 1 1,000 999 100% 2886-480-470210-212 PROJECT EXPENSES 1 0 1- 0% 2886-480-470210-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 2886-480-470210-215 COMPUTER SUPPLIES 563 1,000 438 44% 2886-480-470210-218 EQUIPMENT (non -capital) 0 300 300 100% 2886-480-470210-231 GAS & OIL 77 300 223 74% 2886-480-470210-312 POSTAGE 149 300 151 50% 2886-480-470210-320 PRINTING 440 6,000 5,560 93% 2886-480-470210-331 GRANT ACTIVITIES ADVERTISING 941 335 606- -181% 2886-480-470210-334 MT WEST MEMBERSHIP 0 500 500 100% 2886-480-470210-335 MEMBERSHIP & DUES 1,149 700 449- -64% 2886-480-470210-345 TELEPHONE & COMMUNICATION 157 750 593 79% 2886-480-470210-353 AUDITING 1,875 1,500 375- -25% 2886-480-470210-354 CONTRACT SERVICES 0 1,000 1,000 100% 2886-480-470210-355 PROSPECT DEVELOPMENT 0 3,000 3,000 100% 2886-480-470210-363 OFFICE EQUIP MAINTENANCE 0 100 100 100% 2886-480-470210-373 SCHOOL & TRAVEL 778 3,000 2,222 74% 2886-480-470210-379 MEETINGS 125 300 375 75% 2886-480-470210-381 TRAINING 150 1,500 1,350 90% 2886-480-470210-396 STUDIES/SURVEYS 0 25,000 25,000 100% 2886-480-470210-510 PROPERTY & LIABILITY INS. 2,660 4,200 1,540 37% 2886-480-470210-521 CENTRAL GARAGE TRANSFER 375 500 125 25% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 7,838 10,451 2,613 25% 2886-480-470210-528 DATA PROCESSING TRANSFER 6,269 8,359 2,090 25% 2886-480-470210-532 OFFICE RENT 4,703 4,703 0 0% 2886-480-470210-710 LAND TRUST DONATION 9,000 18,000 9,000 50% 2886-480-470210-711 HISTORIC PRESERVATION PROJECT 17,500 19,000 1,500 8% 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 2,500 2,500 100% TOTAL UDAG FUND ---------------------- 109,103 ----------- 228,660 ---------- 119,557 52% 04/14/10 CITY OF KALISPELL Page 15 Quarterly Finance Report 75.00% Yr Complete FUND FUND RURAL DEVELOPMENT REVOLVING 2887-460-470210-110 SALARIES 2887-480-470210-153 HEALTH INSURANCE 2887-480-470210-155 RETIREMENT 2887-480-470210-610 DEBT SERVICE/PAIN-L461-01 2887-480-470210-620 INTEREST EXPENSE/L#61-01 2887-480-470210-750 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT ACTUAL YTD BUDGET 21,687 38,307 3,283 6,060 1,411 2,476 16,975 17,046 5,099 5,029 46 150,000 48,501 218,918 ----------------- ----------------- REMAINING % ------------------- 16,620 43% 2,778 46% 1,065 43% 71 0% 70- -1% 149,954 100% 170,417 78% ------------------ 2888 RURAL DEV. #2 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-02 2,575 2,575 0 0% 2888-480-470210-750 REDEVELOPMENT LOANS 121 45,000 44,879 100% TOTAL 2888 RURAL DEV. #2 ----------- 2,696 ----------- 47,575 --------------------- 44,879 94% 2944 CDBG-ED FVCC 2944-480-470242-355 ADMIN CHARGE 0 3,428 3,428 100% 2944-480-470242-780 TRANING COSTS-FVCC GRT 0 72,000 72,000 100% 2944-480-470242-790 MACHINERY/EQUIPMENT-FVCC GRT 0 6,090 6,090 100% ----------- TOTAL 2944 CDBG-ED FVCC 0 ----------- 81,518 --------------------- 81,518 100% 2953 EPA BROWNSFIELD GRANT 2953-480-470210-780 SITE ASSESSMENT GRANT EXPENSE 3,306 400,000 396,694 99% ----------- TOTAL EPA BROWNSFIELD GRANT 3,306 ----------- 400,000 --------------------- 396,694 99% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 23,522 49,387 25,865 52% 2916-413-420140-121 OVERTIME 3,609 11,000 7,391 67% 2916-413-420140-153 HEALTH INSURANCE 2,525 13,204 10,679 81% 2916-413-420140-155 RETIREMENT 3,128 6,655 3,527 53% 2916-413-420140-210 OFFICE SUPPLIES 0 400 400 100% 2916-413-420140-354 CONTRACT SERVICES 673 4,000 3,327 83% ----------- TOTAL 2916 DRUG ENFORCEMENT ----------- 33,457 ----------- 84,646 ---------- 51,189 60% 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 3,292 51,388 48,096 94% 2918-413-420140-153 HEALTH INSURANCE 505 13,204 12,699 96% 2918-413-420140-155 RETIREMENT 446 6,655 6,209 93% ----------- TOTAL 2918 COPS HIRING GRANT ----------- 4,243 ----------- 71,247 ---------- 67,004 94% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - DISPATCH 4,092 4,000 92- -2% 2919-413-420140-121 OVERTIME - DISPATCH 3,343 0 3,343- 0% 2919-413-420140-125 DUI TASK FORCE 3,809 10,000 6,191 62% 2919-413-420140-126 HOLIDAY OT REIMB. 41,016 40,000 1,016- -3% 2919-413-420140-127 SCHOOL DIST. OT 14,626 20,000 5,374 27% 2919-413-420140-155 RETIREMENT 6,325 4,000 2,325- -58% 2919-413-420140-218 JAG GRANT- E Tickets Equip/supplies 17,750 37,095 19,346 52% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 635 5,000 4,365 87% 2919-413-420140-221 RIFLES FOR SWAT TEAM 13,092 5,600 7,492- -134% 2919-413-420140-944 VEHICLES ----------- 32,449 ----------- 35,500 ----------- 3,051 ---------- 9% 04/14/10 CITY OF KALISPELL Page 16 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- TOTAL LAW ENF. GRANT 137,137 161,195 24,058 15% 2921 DRUG COURT GRANT 2921-406-410360-354 DRUG COURT -contract services 6,756 348,473 341,717 98% TOTAL DRUG COURT GRANT ----------- 6,756 ----------- ----------- ----------- 348,473 ----------- ---------- --------------------- 341,717 -------------------- -------------------- 98% 2950 DOM. VIOLENCE COMPLIANCE 2950-406-410360-354 DOMESTIC VIOLENCE GT-contract serv. 5,335 23,317 17,982 77% TOTAL DOM. VIOLENCE COMPLIANCE ----------- 5,335 ----------- ----------- ----------- 23,317 ----------- ----------- --------------------- 17,982 --------------------- --------------------- 77% 2951 DUI COURT GRANT 2951-406-410360-354 CS-EVAL,PO,LAC,TEST 2009-16-21-02 34,593 64,823 30,230 47% 2951-406-410360-373 SCHOOL & TRAVEL-TRNING GRT 9,260 9,260 0 0% 2951-406-410361-354 CS -EVALUATOR, PO,LAC 2010-18-21-02 44,197 ----------- 105,000 ----------- 60,803 ---------- 58% TOTAL DUI COURT GRANT 88,050 179,083 ----------- 91,033 51% 2957 FEMA GRANT 2957-416-420400-110 SALARIES 137 10,000 9,863 99% 2957-416-420400-121 OVERTIME 0 15,000 15,000 100% 2957-416-420400-153 HEALTH INSURANCE 0 1,564 1,564 100% 2957-416-420400-155 RETIREMENT 294 1,436 1,142 80% 2957-416-420400-218 EQUIPMENT (non capital) 13,450 19,768 6,318 32% 2957-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 4,669 6,000 1,331 22% 2957-416-420400-229 HAZMAT REIMB.-MATERIALS 0 6,000 6,000 100% 2957-416-420400-373 TRAVEL - REIMBURSABLE 0 20,000 20,000 100% 2957-416-420410-125 PASS THRU HAZMAT OT 2,367 20,000 17,633 88% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 3,130 31,125 27,995 90% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 3,706 5,000 1,294 26% 2957-416-420413-940 AFG REGIONAL CAD SYSTEM 911,049 915,876 4,827 1% 2957-416-420414-218 AFG EQUIPMENT AND SAFETY($137,000) 0 120,000 120,000 100% 2957-416-420415-940 HERITAGE PROGRAM GRANT (carryover) 5,460 8,207 2,747 33% 2957-416-420420-126 WILDLAND FIRE OT 0 130,000 130,000 100% TOTAL FEMA GRANT ----------- 944,262 ----------- 1,309,976 --------------------- 365,714 28% 2975 ISTEA 2975-436-460457-950 WOODLAND CONNECTOR 98,334 299,000 200,666 67% TOTAL ISTEA ----------- 98,334 ----------- ----------- ----------- 299,000 ----------- ---------- ----------- ---------- 200,666 ------------------- -------------------- 67% 2990 STIMULUS- ROADS 2990-421-430240-950 STIMULUS STREET CONSTRUCTION 0 342,000 342,000 100% TOTAL 2990 STIMULUS - ROADS ----------- 0 ----------- 342,000 --------------------- 342,000 100% 2992 ENERGY BLOCK GRANT 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS 8,000 96,700 88,700 92% TOTAL 2992 ENERGY BLOCK GRANT ----------- 8,000 ----------- ----------- ----------- 96,700 ----------- ----------- --------------------- 88,700 -------------------- -------------------- 92% 04/14/10 CITY OF KALISPELL Page 17 Quarterly Finance Report 75.00% Yr Complete FUND FUND ---------------------------------------------------- CAPITAL PROJECT FUNDS 4185 AIRPORT TIF BOND/LAND 4185-000-430300-354 BOND ISSUE COSTS 4185-000-430300-950 LAND ACQUISITION TOTAL 4185 AIRPORT TIF BOND/LD 4300 FAA NON -PRIMARY ENTITLMNT 4300-430-430310-354 TOWER MITIGATION TOTAL FAA NP ENTITLEMENT 4310 FAA LAND ACQUISITION 4310-430-430310-910 AIRPORT LAND ACQUISITION 4310-430-430310-940 AIRPORT CAPITAL IMPROVEMENTS TOTAL FAA LAND ACQ. ACTUAL YTD BUDGET REMAINING % ---------------------------------------------- 0 30,000 30,000 100% 0 1,970,000 1,970,000 100% ----------- 0 ----------- 2,000,000 --------------------- 2,000,000 100% 0 ----------- 600,000 600,000 100% 0 ----------- 600,000 --------------------- 600,000 100% 0 1,492,755 1,492,755 100% 0 ----------- 1,381,804 1,381,804 100% 0 ----------- 2,874,559 --------------------- 2,874,559 100% 04/14/10 CITY OF KALISPELL Page 18 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------------------------------------------------------------------- ENTERPRISE FUNDS WATER REVENUE 5210-000-331158-000 STATE BYPASS RELOCATION REIMB. 0 230,154 230,154 100% 5210-000-343210-000 METERED WATER SALES 2,018,391 2,400,000 381,609 16% 5210-000-343220-000 UNMETERED WATER SALES 18,119 4,000 14,119- -353% 5210-000-343225-000 IMPACT FEES 169,300 300,000 130,700 44% 5210-000-343230-000 METER REPLACEMENT FEE 72,889 90,000 17,111 19% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 12,302 25,000 12,698 51% 5210-000-343265-000 LATECOMER ADMIN FEES 2,323 4,000 1,677 42% 5210-000-343270-000 WATER TURN ON FEES 2,805 3,000 195 7% 5210-000-343275-000 TAG FEE 14,940 18,000 3,060 17% 5210-000-371010-000 INVESTMENT EARNINGS 50,113 90,000 39,887 44% TOTAL WATER REVENUE ----------- 2,361,182 ----------- 3,164,154 --------------------- 802,972 25% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 499,618 717,372 217,754 30% 5210-447-430550-121 OVERTIME 13,794 20,500 6,706 33% 5210-447-430550-153 HEALTH INSURANCE 106,268 156,754 50,486 32% 5210-447-430550-155 RETIREMENT 32,093 45,079 12,986 29% 5210-447-430550-210 OFFICE SUPPLIES 377 400 23 6% 5210-447-430550-213 SMALL OFFICE EQUIPMENT 0 1,000 1,000 100% 5210-447-430550-214 GIS SUPPLIES 196 5,000 4,804 96% 5210-447-430550-215 COMPUTER SUPPLIES 4,162 3,000 1,162- -39% 5210-447-430550-216 COMPUTER EQUIPMEMT 4,727 5,000 273 5% 5210-447-430550-218 EQUIPMENT (NON CAPITAL) 4,763 8,475 3,712 44% 5210-447-430550-221 SAFETY EQUIP & SUPPLIES 715 2,500 1,785 71% 5210-447-430550-224 JANITORIAL SUPPLIES 545 800 255 32% 5210-447-430550-226 CHLORINE & CHEMICALS 19,454 25,000 5,546 22% 5210-447-430550-229 OTHER SUPPLIES 858 1,500 642 43% 5210-447-430550-231 GAS & OIL 15,781 38,000 22,219 58% 5210-447-430550-241 CONSUMABLE TOOLS 2,317 2,500 183 7% 5210-447-430550-312. POSTAGE 273 2,500 2,227 89% 5210-447-430550-320 PRINTING 3,912 2,000 1,912- -96% 5210-447-430550-335 MEMBERSHIP & DUES 769 1,200 431 36% 5210-447-430550-336 LICENSES & FEES 16,082 19,000 2,919 15% 5210-447-430550-341 ELECTRICITY 107,983 142,000 34,017 24% 5210-447-430550-342 WATER 206 500 294 59% 5210-447-430550-344 NATURAL GAS 7,966 16,000 8,034 50% 5210-447-430550-345 TELEPHONE & COMMUNICATION 6,009 8,000 1,991 25% 5210-447-430550-349 LAB SERVICES 16,187 35,500 19,313 54% 5210-447-430550-353 AUDITING 3,000 3,000 0 0% 5210-447-430550-354 CONTRACT SERVICES 22,969 65,000 42,031 65% 5210-447-430550-355 CONTRACT SERV.-AERIAL MAPPING 302 3,000 2,698 90% 5210-447-430550-356 WTR RIGHTS UPDATE/WTR MODELING 5,965 35,000 29,035 83% 5210-447-430550-357 RATE STUDY 5,349 10,000 4,651 47% 5210-447-430550-358 IMPACT FEE REVIEW 1,193 5,000 3,807 76% 5210-447-430550-360 REPAIR & MAINT SERVICES 34 7,000 6,966 100% 5210-447-430550-362 EQUIPMENT MAINTENANCE 1,595 4,000 2,405 60% 5210-447-430550-363 OFFICE EQUIP MAINTENANCE 0 200 200 100% 5210-447-430550-366 BUILDING MAINTENANCE 4,989 20,000 15,011 75% 5210-447-430550-369 RADIO EQUIPMENT & MAINT. 0 2,450 2,450 100% 5210-447-430550-373 SCHOOL & TRAVEL 3,874 6,500 2,626 40s 5210-447-430550-380 TRAINING MATERIALS 0 500 500 100% 5210-447-430550-388 MEDICAL SERVICES 461 800 340 42% 5210-447-430550-395 RENTAL EQUIPMENT 0 1,500 1,500 100% 5210-447-430550-410 CONSTRUCTION MATERIALS 8,936 30,000 21,064 70% 5210-447-430550-422 HYDRANTS 577 34,000 33,423 98% 5210-447-430550-423 MATERIALS FOR MAINS 2,449 12,000 9,551 80% 5210-447-430550-424 MATERIALS -SERVICE LINES 6,043 8,000 1,957 24% 5210-447-430550-425 MATERIALS PUMPS/WELLS 20,634 36,000 15,366 43% 5210-447-430550-510 PROPERTY & LIABILITY INS. 36,169 38,000 1,831 5% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 6,266 4,000 2,266- -57% 5210-447-430550-513 UNINSURED LOSS -GOODWILL 0 7,500 7,500 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 6,375 8,500 2,125 25% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 67,617 90,156 22,539 25% 04/14/10 CITY OF KALISPELL Page 19 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------------------------------------------------------------------- 5210-447-430550-528 DATA PROCESSING TRANSFER 15,673 20,897 5,224 25% 5210-447-430550-532 LEASE PAYMENTS 7,838 7,838 0 0% 5210-447-430550-810 BAD DEBT EXPENSE 0 1,500 1,500 100% 5210-447-430550-940 MACHINERY & EQUIPMENT 5,999 55,000 49,001 89% 5210-447-430550-948 METERS (METER FUNDS) 63,364 105,000 41,636 40% 5210-447-430550-950 WATER MAIN REPLACEMENT -GRAND VIEW 69,818 156,000 86,182 55% 5210-447-430550-951 SECURITY SYSTEM UPGRADES 0 32,000 32,000 100% 5210-447-430550-954 93S BYPASS -UTILITY RELOCATE -amended 37,278 337,432 300,154 89% 5210-447-430550-956 UPPER/LOWER INTERCONNECTION 31,122 40,000 8,878 22% 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 0 335,000 335,000 100% 5210-447-430550-961 UPSIZE MAIN-E AZ & 1ST AVE EN 0 195,000 195,000 100% 5210-447-430550-962 UPSIZE MAIN -1ST AVE E&IDAHO 1,703 35,000 33,297 95% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 100,000 100,000 100% 5210-447-430555-941 METERS (NEW SERVICES) 54,535 65,000 10,465 16% 5210-447-430555-953 SECTION 36 WELL 0 75,000 75,000 100% TOTAL WATER FACILITIES ----------- 1,357,180 ----------- ----------- 3,252,353 ----------- --------------------- 1,895,173 ----------- ---------- 58% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 65,154 91,459 26,305 29% 5210-447-430560-153 HEALTH INSURANCE 14,945 23,486 8,541 36% 5210-447-430560-155 RETIREMENT 4,263 5,891 1,628 28% 5210-447-430560-210 OFFICE SUPPLIES 113 500 387 77% 5210-447-430560-218 EQUIPMENT - NOT CAPITAL 151 3,000 2,849 95% 5210-447-430560-335 MEMBERSHIP & DUES 158 350 193 55% 5210-447-430560-353 AUDITING 1,875 1,500 375- -25% 5210-447-430560-354 CONTRACT SERVICES 3,536 7,500 3,964 53% 5210-447-430560-355 BILLING COSTS 21,731 25,000 3,269 13% 5210-447-430560-373 SCHOOL & TRAVEL 567 1,200 633 53% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 4,630 6,173 1,543 25% 5210-447-430560-528 DATA PROCESSING TRANSFER 17,173 22,897 5,724 25% 5210-447-430560-532 RENT 7,838 7,838 0 0% TOTAL WATER BILLING ----------- 142,133 ----------- ----------- 196,794 ----------- --------------------- 54,661 ----------- ---------- 28% REVENUE BONDS 5210-447-490204-610 2004 BOND PRINCIPAL (HWY93) 0 140,000 140,000 100% 5210-447-490204-620 2004 BOND INTEREST (HWY93) 51,533 51,535 3 0% 5210-447-490204-630 2004 BOND FISCAL AGENT FEES 300 350 50 14% 5210-447-490206-610 2007 BOND PRIN WRF 3.75% 0 173,000 173,000 100% 5210-447-490206-620 2007 BOND INT WRF 3.75% 89,963 89,970 8 0% 5210-447-490206-630 2007 BOND ISSUE COSTS 0 700 700 100% 5210-447-490250-610 SRF 2001 PRINCIPAL 4% 0 36,000 36,000 100% 5210-447-490250-620 SRF 2001 INTEREST 4% 20,320 20,350 30 0% TOTAL REVENUE BONDS ----------- 162,115 ----------- ----------- 511,905 ----------- --------------------- 349,790 --------------------- 68% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 700,000 700,000 100% ----------- TOTAL DEPRECIATION ----------- 0 ----------- 700,000 ----------- --------------------- 700,000 --------------------- 100% TOTAL WATER FUND 1,661,428 4,661,052 2,999,624 64% 04/14/10 FUND 5310-000-331158-000 5310-000-343310-000 5310-000-343330-000 5310-000-343335-000 5310-000-343360-000 5310-000-343365-000 5310-000-371010-000 CITY OF KALISPELL Quarterly Finance Report FUND ------------------------------- SEWER REVENUE: STATE BYPASS RELOCATION REIMB. SEWER SERVICE CHARGES IMPACT FEES (SANITARY) IMPACT FEES (WWTP) INSTALLATION,SALE OF MAT./OTHER LATECOMER ADMIN FEES INVESTMENT EARNINGS TOTAL SEWER REVENUE ACTUAL YTD BUDGET REMAINING % 0 217,431 217,431 100% 2,532,690 3,450,000 917,310 27% 83,012 175,000 91,988 53% 110,213 246,000 135,787 55% 640 1,000 360 36% 258 850 592 70% 66,991 165,000 98,009 59% ----------- 2,793,805 ----------- ---------- ----------- 4,255,281 ---------- ----------- --------------------- 1,461,476 -------------------- ------------------- 34% EXPENDITURES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 49,496 75,236 25,740 34% 5310-454-430620-153 HEALTH INSURANCE 11,340 17,935 6,595 37% 5310-454-430620-155 RETIREMENT 3,131 4,792 1,661 35% 5310-454-430620-215 OFFICE SUPPLIES/FURNITURE 108 1,000 892 89% 5310-454-430620-218 COMPUTERS/SUPPLIES 151 1,500 1,349 90% 5310-454-430620-335 MEMBERSHIP & DUES 315 300 15- -5% 5310-454-430620-353 AUDITING 1,875 1,500 375- -25% 5310-454-430620-354 CONTRACT SERVICES 1,060 7,500 6,440 86% 5310-454-430620-355 BILLING COSTS 23,999 24,000 1 0% 5310-454-430620-373 SCHOOL & TRAVEL 555 1,000 446 45% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5,163 6,884 1,721 25% 5310-454-430620-528 DATA PROCESSING TRANSFER 17,173 22,897 5,724 25% 5310-454-430620-532 OFFICE RENT 7,838 7,838 0 0% TOTAL SEWER BILLING COSTS ---------------------- 122,203 ----------- ----------- ----------- 172,382 ----------- ---------- 50,179 ---------- 29% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 261,790 364,781 102,991 28% 5310-454-430630-121 OVERTIME 5,016 6,500 1,484 23% 5310-454-430630-153 HEALTH INSURANCE 53,729 68,379 14,650 21% 5310-454-430630-155 RETIREMENT 16,754 22,597 5,843 26% 5310-454-430630-210 OFFICE SUPPLIES 301 450 149 33% 5310-454-430630-213 SMALL OFFICE EQUIPMENT 0 500 500 100% 5310-454-430630-214 GIS SUPPLIES 61 2,000 1,939 97% 5310-454-430630-215 COMPUTER SUPPLIES 2,275 2,000 275- -14% 5310-454-430630-216 COMPUTER EQUIPMEMT 2,589 2,500 89- -4% 5310-454-430630-218 EQUIPMENT (NON CAPITAL) 34- 5,500 5,534 101% 5310-454-430630-221 SAFETY EQUIP & SUPPLIES 1,314 900 414- -46% 5310-454-430630-224 JANITORIAL SUPPLIES 585 600 15 2% 5310-454-430630-229 OTHER SUPPLIES 318 800 482 60% 5310-454-430630-231 GAS & OIL 5,911 14,500 8,589 59% 5310-454-430630-241 CONSUMABLE TOOLS 726 1,200 474 40% 5310-454-430630-312 POSTAGE 77 750 673 90% 5310-454-430630-336 LICENSES & FEES 40 450 410 91% 5310-454-430630-341 ELECTRICITY 29,921 36,000 6,079 17% 5310-454-430630-342 WATER 141 175 34 19% 5310-454-430630-344 NATURAL GAS 10,041 12,500 2,459 20% 5310-454-430630-345 TELEPHONE & COMMUNICATION 16,253 20,500 4,247 21% 5310-454-430630-353 AUDITING 2,000 2,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 8,732 22,100 13,368 60% 5310-454-430630-355 CONTRACT SERVICES -AERIAL MAPPING 0 3,000 3,000 100% 5310-454-430630-356 CONSULTANTS 0 15,000 15,000 100% 5310-454-430630-357 RATE STUDY FY09/FACILITY PLAN FY08 6,697 12,500 5,803 46% 5310-454-430630-358 IMPACT FEE REVIEW 1,193 5,000 3,807 76% 5310-454-430630-362 EQUIPMENT MAINTENANCE 2,675 7,800 5,125 66% 5310-454-430630-366 BUILDING MAINTENANCE 1,630 1,000 630- -63% 5310-454-430630-369 RADIO EQUIPMENT & MAINT. 0 1,000 1,000 100% 5310-454-430630-373 SCHOOL & TRAVEL 2,249 3,000 751 25% 5310-454-430630-388 MEDICAL SERVICES 663 800 138 17% 5310-454-430630-410 CONSTRUCTION MATERIALS 5,856 10,000 4,144 41% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 5,850 14,500 8,650 60% 5310-454-430630-510 PROPERTY & LIABILITY INS. 25,027 28,500 3,473 12% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 15,519 18,000 2,481 14% Page 20 75.00% Yr Complete 04/14/10 CITY OF KALISPELL Page 21 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------------------------------------------------------------------- 5310-454-430630-521 CENTRAL GARAGE TRANSFER 2,250 3,000 750 25% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 41,078 54,771 13,693 25% 5310-454-430630-528 DATA PROCESSING TRANSFER 11,494 15,325 3,831 25% 5310-454-430630-532 OFFICE RENT 7,838 7,83E 0 0% 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 15,450 25,000 9,550 38% 5310-454-430630-810 BAD DEBT EXPENSE 0 945 945 100% 5310-454-430630-954 93S BYPASS -UTILITY RELOCATE -amended 17,554 303,308 285,754 94% TOTAL SANITARY SEWER/COLLECTIO ----------- 581,564 ----------- ----------- 1,117,969 ----------- --------------------- 536,405 --------------------- 48% SANITARY SEWER REPLACEMENT $ 5310-454-430633-952 MANHOLE REHAB 10,000 10,000 0 0% 5310-454-430633-956 REPLACE PUMPS-COTTONWD LIFT ST.#28 0 20,000 20,000 100% 5310-454-430633-960 REPLACEMENT PUMP FOR LS #10 0 10,000 10,000 100% TOTAL REPLACEMENT $ ----------- 10,000 ----------- ----------- 40,000 ----------- ----------- ---------- 30,000 --------------------- 75% SANITARY SEWER PLANT INVEST $ 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 0 75,832 75,832 100% 5310-454-430635-957 GRANDVIEW PUMP STA/GRAVITY MAIN 52% 400,316 500,000 99,684 20% TOTAL SANITARY SEWER PLANT INV ----------- 400,316 ----------- ----------- 575,832 ----------- --------------------- 175,516 --------------------- 30% REVENUE BONDS/SANITARY 5310-454-490204-610 PRINCIPAL-2004 BONDS(HWY 93 S) 0 61,000 61,000 100% 5310-454-490204-620 INTEREST-2004 BONDS 44,400 44,400 0 0% 5310-454-490204-630 FISCAL AGENT FEES 0 300 300 100% TOTAL REVENUE BONDS ----------- 44,400 ----------- ----------- 105,700 ----------- --------------------- 61,300 --------------------- 58% DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 ----------- 500,000 500,000 100% TOTAL DEPRECIATION -SANITARY 0 ----------- ----------- 500,000 ----------- --------------------- 500,000 --------------------- 100% TOTAL SANITARY SEWER 1,036,280 2,339,501 1,303,221 56% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 279,097 400,679 121,582 30% 5310-455-430640-121 OVERTIME 13,459 20,000 6,541 33% 5310-455-430640-153 HEALTH INSURANCE 54,095 68,415 14,320 21% 5310-455-430640-155 RETIREMENT 18,316 24,751 6,435 26% 5310-455-430640-210 OFFICE SUPPLIES 891 1,000 109 11% 5310-455-430640-213 SMALL OFFICE EQUIPMENT 828 500 328- -66% 5310-455-430640-215 COMPUTER SUPPLIES 536 500 36- -7% 5310-455-430640-216 COMPUTER EQUIPMEMT 936 1,500 564 38% 5310-455-430640-221 SAFETY EQUIP & SUPPLIES 717 2,500 1,783 71% 5310-455-430640-222 LABORATORY SUPPLIES 944 0 944- 0% 5310-455-430640-224 JANITORIAL SUPPLIES 0 250 250 100% 5310-455-430640-225 ALUM 4,902 70,000 65,098 93% 5310-455-430640-226 CHLORINE & CHEMICALS 7,736 12,500 4,764 38% 5310-455-430640-229 OTHER SUPPLIES 4,031 4,000 31- -1% 5310-455-430640-231 GAS & OIL 7,856 14,000 6,144 44% 5310-455-430640-241 CONSUMABLE TOOLS 94B 1,000 52 5% 5310-455-430640-312 POSTAGE 194 500 306 61% 5310-455-430640-335 MEMBERSHIP & DUES 285 1,200 915 76% 5310-455-430640-336 LICENSES & FEES 6,373 7,500 1,127 15% 5310-455-430640-341 ELECTRICITY 129,397 235,000 105,603 45% 5310-455-430640-342 WATER 3,589 8,500 4,911 58% 5310-455-430640-344 NATURAL GAS 38,659 65,000 26,341 41% 5310-455-430640-345 TELEPHONE & COMMUNICATION 3,871 6,000 2,129 35% 5310-455-430640-353 AUDITING 2,750 2,750 0 0% 04/14/10 CITY OF KALISPELL Page 22 Quarterly Finance Report 75.00% Yr Complete FUND FUND ---------------------------------------------- 5310-455-430640-354 CONTRACT -GLACIER GOLD 5310-455-430640-355 OTHER CONTRACT SERVICES 5310-455-430640-356 CONSULTANTS 5310-455-430640-357 WWTP RATE STUDY 5310-455-430640-358 CONSULTANT-TMDL 5310-455-430640-360 REPAIR & MAINT SERVICES 5310-455-430640-366 BUILDING MAINTENANCE 5310-455-430640-373 SCHOOL & TRAVEL 5310-455-430640-380 TRAINING MATERIALS 5310-455-430640-388 MEDICAL SERVICES 5310-455-430640-395 RENTAL EQUIPMENT 5310-455-430640-510 PROPERTY & LIABILITY INS 5310-455-430640-521 CENTRAL GARAGE TRANSFER 5310-455-430640-522 ADMINISTRATIVE TRANSFER 5310-455-430640-528 DATA PROCESSING TRANSFER TOTAL WWTP OPERATIONS WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 5310-455-430645-940 MACHINERY & EQUIPMENT TOTAL WWTP REPLACEMENT WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 5310-455-430646-121 OVERTIME 5310-455-430646-153 HEALTH INSURANCE 5310-455-430646-155 RETIREMENT 5310-455-430646-210 OFFICE SUPPLIES 5310-455-430646-215 COMPUTER SUPPLIES & SUPPORT 5310-455-430646-218 NON -CAPITAL EQUIPMENT 5310-455-430646-222 LAB SUPPLIES 5310-455-430646-224 JANITORIAL SUPPLIES 5310-455-430646-229 OTHER SUPPLIES 5310-455-430646-312 POSTAGE & SHIPPING 5310-455-430646-335 MEMBERSHIP & DUES 5310-455-430646-336 LICENSES & FEES 5310-455-430646-345 TELEPHONE & ALARMS 5310-455-430646-349 LAB SERVICES 5310-455-430646-362 EQUIPMENT MAINTENANCE 5310-455-430646-373 SCHOOL & TRAVEL 5310-455-430646-380 TRAINING MATERIALS TOTAL WWTP LAB OPERATIONS REVENUE BONDS/WWTP 5310-455-490210-610 DEBT-2002 ISSUE -PRINCIPAL 5310-455-490210-620 DEBT-2002 INTEREST 5310-455-490210-630 FISCAL AGENT FEES-2002 BONDS TOTAL REVENUE BONDS/WWTP SRF LOAN/WWTP 5310-455-490215-610 DEBT SRF 92003-PRINCIPAL 5310-455-490215-620 DEBT SRF 92003-INTEREST TOTAL SRF LOAN/WWTP DEBT SERVICE SRF -new constr. 5310-455-490227-610 SRF 2007WWTP PRINCIPAL 5310-455-490227-620 SRF 2007WWTP INTEREST SUBTOTAL SRF 2007 TOTAL WWTP DEBT ACTUAL YTD BUDGET REMAINING % ----------------------------------------------- 85,474 130,000 44,526 34% 21,716 45,000 23,284 52% 5,183 25,000 19,817 79% 6,697 12,500 5,803 46% 0 25,000 25,000 100% 0 15,000 15,000 100% 1,691 2,500 809 32% 3,815 14,000 10,185 73% 82 500 419 84% 392 700 308 44% 75 1,000 925 93% 46,941 56,500 9,559 17% 3,000 4,000 1,000 25% 71,421 95,228 23,807 25% 14,628 ----------- 19,504 4,876 25% 841,526 ----------- ----------- 1,394,477 ----------- --------------------- 552,951 --------------------- 40% 39,200 60,000 20,800 35% 16,617 ----------- 73,000 56,383 77% 55,818 ----------- ----------- 133,000 ----------- --------------------- 77,182 --------------------- 58% 94,082 126,206 32,124 25% 0 300 300 100% 14,752 21,295 6,543 31% 5,869 7,795 1,926 25% 0 100 100 100% 0 50 50 100% 5,224 5,400 176 3% 6,557 7,500 943 13% 0 50 50 100% 56 200 144 72% 0 1,200 1,200 100% 0 100 100 100% 0 200 200 100% 0 50 50 100% 14,175 20,000 5,825 29% 558 1,500 942 63% 1,282 4,000 2,718 68% 0 ----------- 200 200 100% 142,556 ----------- 196,146 --------------------- 53,590 27% 0 220,000 220,000 100% 18,230 18,230 0 0% 0 ----------- 300 300 100% 18,230 ----------- ----------- 238,530 ----------- --------------------- 220,300 --------------------- 92% 0 250,000 250,000 100% 34,400 34,400 0 0% 34,400 --------- ----------- 284,400 ----------- --------------------- 250,000 ----------- ---------- 88% 0 207,000 207,000 100% 519,638 -------- 520,000 363 0% 519,638 ----------- 727,000 --------------------- 207,363 29% -------- 572,268 ----------- 1,249,930 --------------------- 677,663 54% 04/14/10 CITY OF KALISPELL Page 23 Quarterly Finance Report 75.00% Yr Complete FUND FUND ------------------------------------------------ DEPRECIATION 5310-455-510400-831 DEPRECIATION EXPENSE TOTAL DEPRECIATION TOTAL WWTP TOTAL BILLING/SANITARY/WWTP ACTUAL YTD ----------------------------------------------- ----------- BUDGET REMAINING % 0 ----------- ----------- 419,375 --------------------- 419,375 100% 0 ----------- ----------- 419,375 ----------- --------------------- 419,375 --------------------- 100% 1,612,167 3,392,928 1,780,761 52% ----------- 2,770,651 ----------- 5,904,811 --------------------- 3,134,160 53% 04/14/10 CITY OF KALISPELL Page 24 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ----------------------------------------------------------------------------------------------------------- STORM SEWER REVENUE 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 22,304 5,000 17,304- -346% 5349-000-343033-000 IMPACT FEES 212,869 200,000 12,869- -6% 5349-000-343034-000 PERMIT FEES 1,980 1,800 180- -10% 5349-000-343035-000 STORM SEWER CHARGES 965 1,000 35 4% 5349-000-343370-000 STORM SEWER ASSESSMENTS 804,193 800,000 4,193- -1% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,542 2,500 42- -2% 5349-000-365000-000 DONATIONS 1,000 0 1,000- 0% 5349-000-371010-000 INTEREST ON INVESTMENTS 19,664 30,000 10,336 34% TOTAL STORM REVENUE ----------- 1,065,517 ---------- ----------- ----------- 1,040,300 ----------- ----------- --------------------- 25,217- --------------------- ------------------- -2% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 240,233 342,098 101,865 30% 5349-453-430246-121 OVERTIME 2,457 4,500 2,043 45% 5349-453-430246-153 HEALTH INSURANCE 47,393 65,457 18,064 28% 5349-453-430246-155 RETIREMENT 15,371 21,412 6,041 28% 5349-453-430246-210 OFFICE SUPPLIES/EQUIPMENT 235 1,200 965 80% 5349-453-430246-214 GIS SUPPLIES 86 3,000 2,914 97% 5349-453-430246-215 COMPUTER SUPPLIES 4,736 4,000 736- -18% 5349-453-430246-216 COMPUTER EQUIPMEMT 2,999 3,000 1 0% 5349-453-430246-218 EQUIPMENT -NON CAPITAL 1,257 2,200 943 43% 5349-453-430246-221 SAFETY EQUIP & SUPPLIES 170 1,000 830 83% 5349-453-430246-229 OTHER SUPPLIES 557 1,200 643 54% 5349-453-430246-231 GAS & OIL 5,814 13,500 7,686 57% 5349-453-430246-241 CONSUMABLE TOOLS 0 1,000 1,000 100% 5349-453-430246-320 PRINTING 0 200 200 100% 5349-453-430246-345 TELEPHONE & COMMUNICATION 556 700 144 21% 5349-453-430246-353 AUDITING 600 600 0 0% 5349-453-430246-354 CONTRACT SERVICE 4,260 2,000 2,260- -113% 5349-453-430246-355 CONTRACT SERV.-AERIAL MAPPING 0 3,000 3,000 100% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 10,770 12,500 1,730 14% 5349-453-430246-357 RATE STUDY 12,025 22,500 10,475 47% 5349-453-430246-358 IMPACT STUDY 0 5,000 5,000 100% 5349-453-430246-359 CONSULTANTS-TMDL 0 25,000 25,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 1,850 1,200 650- -54% 5349-453-430246-362 GROUNDWATER MONITORING 14,988 27,000 12,012 44% 5349-453-430246-371 CURB & GUTTER 7,504 5,000 2,504- -50% 5349-453-430246-373 SCHOOL & TRAVEL 2,238 4,500 2,262 50% 5349-453-430246-388 MEDICAL SERVICES 0 250 250 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 105 10,000 9,895 99% 5349-453-430246-510 PROPERTY & LIABILITY INS. 9,282 10,000 718 7% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 1,875 2,500 625 25% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 24,636 32,848 8,212 25% 5349-453-430246-528 DATA PROCESSING TRANSFER 4,180 5,573 1,393 25% 5349-453-430246-530 BNSF LEASE PMT 1,600 4,200 2,600 62% 5349-453-430246-532 OFFICE RENT 11,357 7,838 3,519- -45% 5349-453-430246-952 STORM DRAIN CORRECTION 15,000 132,518 117,518 89% 5349-453-430246-954 S MEADOWS SURVEY 0 10,000 10,000 100% 5349-453-430246-958 STILLWTR/WILLOW GLEN CONST 73,433 80,000 6,567 8% 5349-453-430248-958 STILLWATER/WILLOW GLEN CONST 246,000 380,000 134,000 35% 5349-453-430248-959 SE STORM DRAIN IMP. PH I 162,414 170,000 7,586 4% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 30,000 30,000 100% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 225,000 225,000 100% ----------- TOTAL STORM 925,981 ----------- 1,673,494 --------------------- 747,513 45% 04/14/10 CITY OF KALISPELL Page 25 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION 760,685 750,000 10,685- -1% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 3,063 3,500 437 12% 5510-000-371010-000 INVESTMENT EARNINGS 1,752 3,500 1,748 50% TOTAL SOLID WASTE REVENUE ----------- 765,500 ----------- 757,000 --------------------- 8,500- -1% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 262,796 381,964 119,168 31% 5510-460-430840-121 OVERTIME 2,929 9,500 6,571 69% 5510-460-430840-153 HEALTH INSURANCE 53,953 68,729 14,776 22% 5510-460-430840-155 RETIREMENT 16,622 23,609 6,987 30% 5510-460-430840-213 SMALL OFFICE EQUIPMENT 40 500 460 92% 5510-460-430840-216 COMPUTER EQUIPMEMT 354 2,500 2,146 86% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 4,206 25,000 20,795 83% 5510-460-430840-221 SAFETY EQUIP & SUPPLIES 566 1,500 934 62% 5510-460-430840-224 JANITORIAL SUPPLIES 207 400 193 48% 5510-460-430840-229 OTHER SUPPLIES 726 2,000 1,274 64% 5510-460-430840-231 GAS & OIL 24,055 47,800 23,745 50% 5510-460-430840-241 CONSUMABLE TOOLS 22 1,500 1,478 99% 5510-460-430840-341 ELECTRICITY 1,230 1,600 370 23% 5510-460-430840-344 NATURAL GAS 1,270 8,000 6,730 84% 5510-460-430840-345 TELEPHONE & COMMUNICATION 469 700 231 33% 5510-460-430840-354 CONTRACT SERVICES 9,117 12,000 2,883 24% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 3,926 4,750 824 17% 5510-460-430840-366 BUILDING MAINTENANCE 1,397 2,500 1,103 44% 5510-460-430840-369 RADIO EQUIPMENT & MAINT. 695 1,700 1,005 59% 5510-460-430840-373 SCHOOL & TRAVEL 523 3,500 2,978 85% 5510-460-430840-388 MEDICAL SERVICES 392 550 159 29% 5510-460-430840-510 PROPERTY & LIABILITY INS. 13,749 14,500 751 5% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 6,500 6,500 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 19,500 26,000 6,500 25% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 23,012 30,683 7,671 25% 5510-460-430840-528 DATA PROCESSING TRANSFER 8,359 11,145 2,786 25% 5510-460-430840-532 OFFICE RENT 7,838 7,838 0 0% 5510-460-430845-224 JANITORIAL SUPPLIES 0 350 350 100% 5510-460-430845-341 ELECTRICITY 2,427 2,500 73 3% 5510-460-430845-342 WATER 259 350 91 26% 5510-460-430845-344 NATURAL GAS 3,464 9,500 6,036 64% 5510-460-430845-360 REPAIR & MAINT SERVICES 474 1,000 526 53% 5510-460-430845-366 BUILDING MAINTENANCE 863 1,000 137 14% 5510-460-510400-831 DEPRECIATION EXPENSE 0 100,000 100,000 100% TOTAL SOLID WASTE EXPENSE ----------- 465,439 ----------- 811,668 --------------------- 346,229 43% 04/14/10 CITY OF KALISPELL Page 26 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % --------------------------------------------------------------------------------------------------------- 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 6,915 11,000 4,085 37% 5160-000-343063-000 TIE DOWN FEES 2,190 4,000 1,810 45% 5160-000-343069-000 HANGER LEASES 8,053 12,000 3,948 33% 5160-000-343071-000 HANGAR SITE LEASES 15,556 18,600 3,044 16% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 12,348 16,500 4,152 25% 5160-000-343102-000 GROUND LEASES 10,732 10,450 282- -3% 5160-000-343200-000 UTILITY REBATES 0 3,000 3,000 100% 5160-000-343620-000 FUEL TAX 3,834 6,000 2,166 36% 5160-000-371010-000 INVESTMENT EARNINGS 8,322 8,500 178 2% TOTAL AIRPORT REVENUE ----------- 67,949 ----------- 90,050 --------------------- 22,101 25% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 27,017 33,797 6,780 20a 5160-430-430310-111 SEASONAL SALARIES 0 3,267 3,267 100% 5160-430-430310-153 HEALTH INSURANCE 2,778 3,030 253 8% 5160-430-430310-155 RETIREMENT 1,754 2,406 652 27% 5160-430-430310-210 OFFICE SUPPLIES 339 300 39- -13% 5160-430-430310-218 NON -CAPITAL EQUIPMENT 468 1,000 532 53% 5160-430-430310-335 MEMBERSHIP & DUES 100 250 150 60% 5160-430-430310-341 ELECTRICITY 915 1,500 585 39% 5160-430-430310-345 TELEPHONE 671 1,000 329 33% 5160-430-430310-354 CONTRACT SERVICES 0 7,500 7,500 100% 5160-430-430310-355 CONTRACT SERVICES -MOWING 0 2,000 2,000 100% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 3,165 5,000 1,835 37% 5160-430-430310-360 REPAIRS & MAINTENANCE 2,000 4,000 2,000 50% 5160-430-430310-362 EQUIPMENT MAINTENANCE 400 1,000 600 600 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 268 2,000 1,732 87% 5160-430-430310-373 TRAVEL 1,241 2,000 759 38% 5160-430-430310-380 SIGNAGE 284 500 216 43% 5160-430-430310-390 EQUIPMENT RENTAL 940 1,500 560 37% 5160-430-430310-510 PROPERTY INSURANCE 6,167 6,870 703 10% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 6,098 8,130 2,033 25% 5160-430-430310-528 DATA PROCESSING TRANSFER 2,250 3,000 750 25% 5160-430-430310-820 DEPRECIATION 0 86,602 86,602 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 4,400 115,470 111,070 96% TOTAL AIRPORT OPERATIONS ----------- 61,253 ----------- 292,122 --------------------- 230,B69 79% DATA PROCESSING REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 150,000 150,000 0 0% 6030-000-364030-000 SALE OF MISCELLANEOUS 231 500 269 54% 6030-000-371010-000 INVESTMENT EARNINGS 2,167 2,000 167- -8% 6030-000-393000-000 INTERNAL SERVICES -DATA 118,094 ----------- 161,425 ----------- 43,331 ----------- 27% TOTAL DATA PROCESSING REVENUE 270,492 313,925 ---------- 43,433 14% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 54,310 73,786 19,476 26% 6030-401-410580-153 HEALTH INSURANCE 7,478 9,702 2,224 23% 6030-401-410580-155 RETIREMENT 3,540 4,790 1,250 26% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 2,045 3,000 955 32% 6030-403-410580-215 COMPUTER SUPPLIES 2,482 3,700 1,218 33% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 12,557 11,000 1,557- -14% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 1,513 24,000 22,487 94% 6030-403-410580-346 SUMMIT NET T1 CONTRACT 2,352 5,000 2,648 53% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,160 3,500 340 10% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 6,600 7,000 400 6% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 15,908 28,850 12,942 45% 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 8,300 12,000 3,700 31% 6030-403-410580-373 SCHOOL & TRAVEL 3,209 6,200 2,991 48% 6030-403-410580-510 INSURANCE 1,497 1,675 178 11% 6030-403-410585-229 COPIER,FAX, SUPPLIES 0 5,500 5,500 100% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 46,823 70,000 23,177 33% 6030-403-410585-532 COPIER LEASES 21,937 28,500 6,563 23% 04/14/10 CITY OF KALISPELL Page 27 Quarterly Finance Report 75.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ------------------------------------------------------------------------------------------------------- 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 1,501 1,500 1- 0% 6030-405-410588-218 COMPUTERS - NON CAPITAL CONTINGENCY 0 5,000 5,000 100% 6030-405-410588-940 COMPUTERS - 3 switches 0 18,000 18,000 100% 6030-410-410588-218 COMPUTERS - DPW 2,108 3,300 1,192 36% 6030-413-410588-218 COMPUTERS - POLICE DEPT 2,976 5,000 2,024 40% 6030-416-410588-218 COMPUTERS - FIRE 0 5,500 5,500 100% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 0 1,500 1,500 100% 6030-436-410588-218 COMPUTERS - PARKS 1,940 2,000 60 3% 6030-480-410588-218 COMMUNITY DEVELOPMENT 500 500 0 0% TOTAL DATA PROCESSING EXPENSE ----------- 208,738 ----------- 363,503 ----------- ---------- 154,765 43%