Loading...
2nd Quarter Finance ReportMONT4NA JLJ Date: January 19, 2010 TO: Mayor Fisher and City Council members Jane Howington, City Manager From: Amy Robertson Finance Director RE: 2nd Qtr Finance Report - FY2010 City of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 Please find attached a printout reflecting activity for the 2nd quarter of the fiscal year. This report was run as of today so that it captures the January tax receipts which are the payments for the November taxes collected and disbursed Dec. 15th and Jan. 15th. By including part of January we reflect the payroll of January 8th which was for the pay period ending January 2nd and the first run of accounts payable checks for December bills were processed January 1 lth. By using this date it better reflects the activity for the period but it does include some January expenses such as health insurance. Page 1 —General Fund Revenue: tax collections show 48% remaining (52% collected) -last year at this time we were 47% remaining, (53% collected). Personal Property taxes were delayed by the County (should have been booked in June) and are reflected here. City collections are up due to the one time dividend from Flathead Electric of $12,917 and a downtown TIF distribution of $8,203 from a loan payoff. Court revenue is down as are interest earnings. Many revenues are seasonal, golf course lease, Kidsport reimbursement, planning fees, etc. 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 31st and June 30h but accrued July lit 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 O1/19/10 CITY OF KALISPELL Page 1 Quarterly Finance Report As of January 19th 2010 58.33% Yr Complete FUND 1000-000-311100-000 1000-000-311200-000 1000-000-312000-000 1000-000-322101-000 1000-000-322300-000 1000-000-322500-000 1000-000-323012-000 1000-000-323107-000 1000-000-323109-000 1000-000-323111-000 1000-000-323300-000 1000-000-334017-000 1000-000-335030-000 1000-000-335076-000 1000-000-335077-000 1000-000-335110-000 1000-000-335230-000 1000-000-341020-000 1000-000-341022-000 1000-000-341025-000 1000-000-341027-000 1000-000-342010-000 1000-000-342014-000 1000-000-342016-000 1000-000-342023-000 1000-000-342024-000 1000-000-342025-000 1000-000-343005-000 1000-000-351000-000 1000-000-351015-000 1000-000-351016-000 1000-000-351017-000 1000-000-362010-000 1000-000-364030-000 1000-000-365001-000 1000-000-365015-000 1000-000-365018-000 1000-000-371010-000 1000-000-381060-000 f01i11i�7 ------------------------------------ GENERAL FUND - REVENUE REAL PROPERTY TAXES PERSONAL PROPERTY TAXES PEN & INTEREST DEL. TAXES BEER & LIQUOR LICENSES BUSINESS LICENSES AMUSEMENT LICENSES PLANNING FEES EXCAV/DEMO/AIR/HOUSE MOVING PERMITS SITE REVIEW ZONING FEES ANIMAL LICENSES 911 REIMBURSEMENT/Dispatch M.V. TAX - AD VALOREM ST VIDEO -LIC FEE AND TAX DIST LIVE KENO & BINGO TAX LIVE CARD TABLE PERMIT HB124 ENTITLEMENT ADMINISTRATIVE CHARGES BOND FEES/ADMIN.CHG. CITY COLLECTIONS BRESNAN FRANCHISE FEES POLICE SERVICES RESOURCE OFFICERS KPD REGIONAL TRAINING FIRE PREVENTION PROGRAM FEES EPA GRANT -FIRE DEPT DIRECT REIMB. FIRE ENGINE RESPONSE FEE CENTRAL GARAGE CHARGE CITY COURT FINES & FEES KPD DRUG FINES DUI COURT FINE COURT SECURITY & TECHNOLOGY FEE CITY GOLF COURSE LEASE SALE OF MISCELLANEOUS/AUCTION KMTC NON-PROFIT DONATIONS CONTRIBUTION FRM KIDSPORT BANDSHELL CONTRIBUTIONS INVESTMENT EARNINGS OPERATING TRANSFER- FUND 2372 TOTAL REVENUE ACTUAL YTD BUDGET REMAINING % ---------------------------------------------- 2,207,649 4,226,561 2,018,912 48% 245,445 244,319 1,126- 0% 10,459 25,000 14,541 58% 0 26,381 26,381 100% 80 1,200 1,120 93% 300 600 300 50% 31,849 75,000 43,151 58% 340 500 160 32% 7,272 30,000 22,728 76% 16,363 65,000 48,637 75% 445 1,200 755 63% 0 3,000 3,000 100% 0 1,844 1,844 100% 54,300 60,325 6,025 10% 0 1,100 1,100 100% 2,500 2,500 0 0% 1,059,418 2,270,106 1,210,688 53% 287,583 492,998 205,415 42% 0 15,500 15,500 100% 22,227 1,500 20,727- -1382% 37,154 155,000 117,846 76% 6,651 20,000 13,349 67% 86,000 86,000 0 0% 4,944 15,000 10,056 67% 16,969 17,000 31 0% 0 50,000 50,000 100% 6,360 5,000 1,360- -27% 69,581 118,000 48,419 41% 219,248 471,000 251,752 53% 794 4,000 3,206 80% 1,390 1,000 390- -39% 13,267 21,000 7,733 37% 0 25,471 25,471 100% 179 3,500 3,321 95% 20 0 20- 0% 0 42,000 42,000 100% 2,926 0 2,926- 0% 30,543 85,000 54,457 64% 268,000 516,615 248,615 48% ----------- 4,710,255 ----------- ----------- 9,180,220 ----------- ----------- 4,469,965 ------------ ---------- 49% ---------- O1/19/10 CITY OF KALISPELL Page 2 Quarterly Finance Report As of January 19th 2010 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 2,200 10,500 8,300 79% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 958 3,000 2,042 68% 1000-400-410560-312 POSTAGE 7,773 20,000 12,227 61% 1000-400-410560-320 PRINTING 3,307 3,500 193 6% 1000-400-410600-354 ELECTIONS 6,444 9,000 2,556 28% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 630 5,000 4,370 87% 1000-400-460446-354 KIDSPORT LEASE 0 42,000 42,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 0 40,000 40,000 100% 1000-400-510310-354 ICMA PLAN FEES 250 500 250 50% 1000-400-510330-513 LIABILITY INSURANCE 223,116 230,200 7,084 3% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 10,519 32,000 21,481 67% 1000-400-510330-517 PROPERTY INSURANCE 47,847 48,000 153 0% SUBTOTAL GEN.GOV'T. 310,608 451,300 - -- ---------- 140,692 31% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 56,458 117,303 60,845 52% 1000-401-410210-153 HEALTH INSURANCE 5,502 12,104 6,602 55% 1000-401-410210-155 RETIREMENT 3,386 7,637 4,251 56% 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 0 150 150 100% 1000-401-410210-335 MEMBERSHIP & DUES 985 2,100 1,115 53% 1000-401-410210-338 MOVING EXPENSES 14,016 20,000 5,984 30% 1000-401-410210-345 TELEPHONE & COMMUNICATION 25 1,000 975 98% 1000-401-410210-373 SCHOOL & TRAVEL 385 1,800 1,415 79% 1000-401-410210-379 MEETINGS 44 0 44- 0% SUBTOTAL CITY MANAGER - 81,147 - - ---------------- 164,094 ---------- 82,947 51% HUMAN RESOURCES 1000-401-410830-110 SALARIES -PERSONNEL 52,614 103,338 50,724 49% 1000-401-410830-153 HEALTH INSURANCE 7,427 11,115 3,688 33% 1000-401-410830-155 RETIREMENT 3,428 6,696 3,268 49% 1000-401-410830-210 OFFICE SUPPLIES 0 350 350 100% 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-320 PRINTING 0 100 100 100% 1000-401-410830-322 BOOKS 0 150 150 100% 1000-401-410830-335 MEMBERSHIP & DUES 280 400 120 30% 1000-401-410830-338 RECRUITMENT/NEGOTIATIONS 1,269 3,500 2,231 64% 1000-401-410830-345 TELEPHONE 38 150 112 75% 1000-401-410830-354 CONTRACT SERVICES 0 100 100 100% 1000-401-410830-373 SCHOOL & TRAVEL 2,376 3,500 1,124 32% ----------- SUBTOTAL HUMAN RESOURCES ----------- 67,523 ----------- 130,199 ---------- 62,676 48% 58.33% Yr Complete 01/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % MEDIA SPECIALIST 1000-401-410900-110 MEDIA SPECIALIST -salary 9,942 20,102 10,160 51% 1000-401-410900-153 HEALTH INSURANCE 4,485 6,084 1,599 26% 1000-401-410900-155 RETIREMENT 668 1,299 631 49% 1000-401-410900-218 EQUIPMENT 206 1,000 794 79% 1000-401-410900-354 CONTRACT SERVICES 1,100 2,500 1,400 56% SUBTOTAL MEDIA SPECIALIST 16,400 30,985 14,585 47% MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 31,532 63,162 31,630 50% 1000-402-410100-153 HEALTH INSURANCE 17,675 30,300 12,625 42% 1000-402-410100-155 RETIREMENT 1,240 2,015 775 38% 1000-402-410100-210 Office Supplies 0 100 100 100% 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,023 3,000 1,977 66% 1000-402-410100-379 MEETINGS 162 300 138 46% SUBTOTAL MAYOR/COUNCIL ----------- 57,395 ---------------------- 105,277 ---------- 47,882 45% CITY CLERK 1000-402-410150-110 SALARIES/CITY CLERK 38,886 77,026 38,140 50% 1000-402-410150-121 OVERTIME 0 500 500 100% 1000-402-410150-153 HEALTH INSURANCE 5,201 9,002 3,801 42% 1000-402-410150-155 RETIREMENT 2,520 4,978 2,458 49% 1000-402-410150-210 OFFICE SUPPLIES 57 150 93 62% 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 201 400 199 50% 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 ---------------------- 48,881 ----------- 95,906 ---------- 47,025 49% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 97,694 191,986 94,292 49% 1000-403-410550-121 OVERTIME 94 0 94- 0% 1000-403-410550-153 HEALTH INSURANCE 17,676 29,262 11,586 40% 1000-403-410550-155 RETIREMENT 6,372 12,430 6,058 49% 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 30 100 70 70% 1000-403-410550-353 CONTRACT SERVICES 102 470 368 78% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 795 1,500 705 47% 1000-403-410550-355 BANK CHARGES & FEES 1,098 4,500 3,402 76% 1000-403-410550-373 SCHOOL & TRAVEL 728 2,000 1,272 64% SUBTOTAL FINANCE ---------------------- 125,627 ----------- 243,498 ---------- 117,871 48% Page 3 58.33% Yr Complete 01/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET ------------------------------------------------------------------------------ CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 1000-404-411110-153 HEALTH INSURANCE 1000-404-411110-155 RETIREMENT 1000-404-411110-210 OFFICE SUPPLIES 1000-404-411110-215 COMPUTER SUPPLIES 1000-404-411110-322 BOOKS, CDs, LEXIS 1000-404-411110-335 MEMBERSHIP & DUES 1000-404-411110-345 TELEPHONE & COMMUNICATION 1000-404-411110-354 CONTRACT SERVICES 1000-404-411110-373 SCHOOL & TRAVEL SUBTOTAL CITY ATTORNEY MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 1000-406-410360-121 OVERTIME 1000-406-410360-153 HEALTH INSURANCE 1000-406-410360-155 RETIREMENT 1000-406-410360-210 OFFICE SUPPLIES 1000-406-410360-213 OFFICE EQUIPMENT/MAINT. 1000-406-410360-215 COMPUTER SUPPLIES 1000-406-410360-229 OTHER SUPPLIES 1000-406-410360-320 PRINTING 1000-406-410360-322 BOOKS 1000-406-410360-335 MEMBERSHIP & DUES 1000-406-410360-345 TELEPHONE & COMMUNICATION 1000-406-410360-353 SECURITY & TECHNOLOGY 1000-406-410360-354 CONTRACT SERVICES 1000-406-410360-373 SCHOOL & TRAVEL 1000-406-410360-394 JURY & WITNESS FEES 1000-406-410360-395 DRUG COURT SUBTOTAL COURT DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 1000-410-430100-153 HEALTH INSURANCE 1000-410-430100-155 RETIREMENT 1000-410-430100-210 OFFICE SUPPLIES 1000-410-430100-213 SMALL OFFICE EQUIPMENT 1000-410-430100-215 COMPUTER SUPPLIES 1000-410-430100-216 COMPUTER EQUIPMEMT/SUPPLIES 1000-410-430100-229 OTHER SUPPLIES 1000-410-430100-331 PUBLICATION & FILING FEES 1000-410-430100-335 MEMBERSHIP & DUES 1000-410-430100-345 TELEPHONE & COMMUNICATION 1000-410-430100-354 CONTRACT SERVICES 1000-410-430100-373 SCHOOL & TRAVEL SUBTOTAL ADMINISTRATION CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 1000-410-431330-121 OVERTIME 1000-410-431330-153 HEALTH INSURANCE 1000-410-431330-155 RETIREMENT 1000-410-431330-210 OFFICE SUPPLIES 1000-410-431330-215 COMPUTER SUPPLIES 1000-410-431330-218 EQUIPMENT (non -capital) 1000-410-431330-221 SAFETY EQUIP & SUPPLIES 1000-410-431330-229 OTHER SUPPLIES 1000-410-431330-231 GAS & OIL 1000-410-431330-232 MOTOR VEHICLE PARTS. REMAINING % -------------- 156,338 307,944 151,606 49% 27,368 46,832 19,464 42% 10,192 19,972 9,780 49% 424 1,200 776 65% 1,596 1,500 96- -6% 3,256 7,000 3,744 53% 555 2,500 1,945 78% 360 1,200 840 70% 55 5,000 4,945 99% 546 2,525 1,979 78% ----------- 200,690 ---------------------- 395,673 ---------- 194,983 49% 99,691 199,353 99,662 50% 41 0 41- 0% 21,332 33,977 12,645 37% 6,509 12,908 6,399 50% 1,794 1,000 794- -79% 1,656 1,000 656- -66% 663 1,000 337 34% 33 1,500 1,467 98% 209 500 291 58% 1,205 1,250 45 4% 200 300 100 33% 2,020 1,400 620- -44% 935 34,750 33,815 97% 6,655 5,750 905- -16% 2,150 6,000 3,850 64% 5,083 4,500 583- -13% 0 ---------------------- 1,000 ----------- 1,000 ---------- 100% 150,175 306,188 156,013 51% 5,467 11,624 6,157 53% 951 1,990 1,039 52% 352 800 448 56% 477 675 198 29% 0 150 150 100% 18 250 232 93% 0 350 350 100% 143 350 207 59% 222 300 78 26% 603 350 253- -72% 29 1,000 971 97% 451 150 301- -201% 79 400 321 80% ---------------------- 8,792 ----------- 18,389 ---------- 9,597 52% 71,284 151,549 80,265 53% 901 1,500 599 40% 14,854 29,106 14,252 49% 4,472 9,297 4,825 52% 20 300 280 93% 10 800 790 99% 120 850 730 86% 113 150 37 25% 2,464 3,500 1,036 30% 49,426 122,500 73,074 60% 48,366 64,000 15,634 24% Page 4 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Page 5 Quarterly Finance Report As of January 19th 2010 58.33% Yr Complete FUND 1000-410-431330-233 1000-410-431330-238 1000-410-431330-241 1000-410-431330-322 1000-410-431330-341 1000-410-431330-342 1000-410-431330-344 1000-410-431330-354 1000-410-431330-362 1000-410-431330-366 1000-410-431330-373 1000-410-431330-388 1000-412-411230-110 1000-412-411230-121 1000-412-411230-153 1000-412-411230-155 1000-412-411230-224 1000-412-411230-229 1000-412-411230-241 1000-412-411230-341 1000-412-411230-342 1000-412-411230-344 1000-412-411230-345 1000-412-411230-354 1000-412-411230-361 1000-412-411230-362 1000-412-411230-366 1000-412-411230-532 1000-412-411230-545 1000-412-411230-610 1000-412-411230-620 1000-420-411020-110 1000-420-411020-153 1000-420-411020-155 1000-420-411020-210 1000-420-411020-213 1000-420-411020-215 1000-420-411020-320 1000-420-411020-331 1000-420-411020-335 1000-420-411020-345 1000-420-411020-354 1000-420-411020-373 FUND ------------------------------ TIRES AND RELATED PARTS FILTERS & MISC. PARTS CONSUMABLE TOOLS BOOKS ELECTRICITY WATER NATURAL GAS CONTRACT SERVICES EQUIPMENT MAINTENANCE BUILDING MAINTENANCE SCHOOL & TRAVEL MEDICAL SERVICES SUBTOTAL CENTRAL GARAGE TOTAL PUBLIC WORKS CITY HALL MAINT. SALARIES -CITY HALL OVERTIME HEALTH INSURANCE RETIREMENT JANITORIAL SUPPLIES OTHER SUPPLIES CONSUMABLE TOOLS ELECTRICITY WATER NATURAL GAS TELEPHONE & COMMUNICATION CONTRACT SERVICES ANNUAL MAINTENANCE CONTRACT EQUIPMENT MAINTENANCE BUILDING MAINTENANCE RENT -NEW CITY HALL COUNTY LANDFILL BOI 2004 DEBT (HVAC SYS) BOI 2004 INT. (HVAC SYS) SUBTOTAL CITY HALL 420 PLANNING DEPARTMENT SALARIES -PLANNING & ZONING HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES OFFICE EQUIPMENT COMPUTER SUPPLIES/SOFTWARE PRINTING PUBLICATION/FILING FEES/BOOKS MEMBERSHIP/DUES TELEPHONE CONTRACT SERVICES SCHOOL & TRAVEL TOTAL PLANNING DEPT. ACTUAL YTD BUDGET ------------------ 16,342 27,000 1,983 3,500 141 500 0 150 794 1,700 75 100 2,179 9,000 32,762 49,600 56 250 196 335 0 600 80 375 246, 639 476, 662 255,431 495,051 REMAINING % ------------------ 10,658 39% 1,517 43% 359 72% 150 100% 906 53% 25 25% 6,821 76% 16,838 34% 194 78% 139 42% 600 100% 295 79% 230,023 48% 239,620 48% 20,240 40,877 20,637 50% 0 200 200 100% 5,047 8, 653 3,606 42% 1,253 2,494 1,241 50% 2,479 5,000 2,521 50% 156 750 594 79% 148 800 652 82% 20,049 41,000 20,951 51% 2,498 4,500 2,002 45% 13,098 43,300 30,202 70% 106 250 144 58% 10,509 19,000 8,491 45% 0 4,500 4,500 100% 2,802 5,000 2,198 44% 2,306 25,178 22,872 91% 48,750 97,500 48,750 50% 1,756 2,000 244 12% 7,533 15,150 7,617 50% 1,421 2,400 979 41% 140,150 318,552 178,402 56% 129,991 261,253 131,262 50% 30,100 52,073 21,973 42% 8,477 16,938 8,461 50% 572 2,500 1,928 77% 0 2,000 2,000 100% 2,968 5,000 2,032 41% 0 500 500 100% 614 4,000 3,386 85% 485 1,300 815 63% 423 900 477 53% 509 1,350 841 62% 946 ----------- 3,500 2,554 ----------- ---------- 73% 1,629,111 ----------- 3,088,037 1,458,926 47% O1/19/10 CITY OF KALISPELL Page 6 Quarterly Finance Report As of January 19th 2010 58.33% Yr Complete FUND 1000-413-420140-110 1000-413-420140-112 1000-413-420140-114 1000-413-420140-121 1000-413-420140-123 1000-413-420140-153 1000-413-420140-155 1000-413-420140-210 1000-413-420140-215 1000-413-420140-218 1000-413-420140-220 1000-413-420140-221 1000-413-420140-225 1000-413-420140-226 1000-413-420140-227 1000-413-420140-228 1000-413-420140-229 1000-413-420140-230 1000-413-420140-231 1000-413-420140-235 1000-413-420140-237 1000-413-420140-320 1000-413-420140-335 1000-413-420140-345 1000-413-420140-354 1000-413-420140-357 1000-413-420140-363 1000-413-420140-365 1000-413-420140-369 1000-413-420140-373 1000-413-420140-375 1000-413-420140-376 1000-413-420140-380 1000-413-420140-388 1000-413-420140-391 1000-413-420140-392 1000-413-420140-827 1000-413-420140-828 1000-413-420140-829 1000-413-420141-110 1000-413-420141-121 1000-413-420141-153 1000-413-420141-155 1000-413-420142-110 1000-413-420142-121 1000-413-420142-153 1000-413-420142-155 1000-413-420142-215 1000-413-420142-234 1000-413-420142-373 1000-413-420144-110 1000-413-420144-153 1000-413-420144-155 1000-413-420145-354 FUND POLICE DEPARTMENT SALARIES -POLICE SALARIES -SEVERANCE SALARY -comptime buyout OVERTIME SPECIAL ASSIGNMENT OVERTIME HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES COMPUTER SUPPLIES EQUIPMENT (NON CAPITAL) INVESTIGATIVE SUPPLIES SAFETY EQUIP & SUPPLIES MAJOR CASE UNIT SUPPLIES SRT SUPPORT/SUPPLIES AMMO & RELATED SUPPLIES PATROL CAR SUPPLIES OTHER SUPPLIES CRIME PREVENTION SUPPLIES CRISIS NEGOTIATIONS BIKE PATROL RESERVE PROGRAM SUPPLIES PRINTING MEMBERSHIP & DUES TELEPHONE & COMMUNICATION CONTRACT SERVICES FORENSIC ANALYSIS/PATHOLOGY OFFICE EQUIP MAINTENANCE SOFTWARE-MAINT. & LISC. RADIO EQUIPMENT & MAINT. SCHOOL & TRAVEL REGIONAL TRAINING TESTING (REIMBURSED) TRAINING MATERIALS MEDICAL SERVICES TREATMENT BOARDING PRISONERS TRANSFER TO 2916 DRUG GRANT TRANSFER TO 2918 COPS HIRING GRANT TRANSFER TO 2919 BLOCK GRANT DETECTIVE -SALARIES DETECTIVE -OVERTIME HEALTH INSURANCE DETECTIVE -RETIREMENT DISPATCH -SALARIES DISPATCH -OVERTIME HEALTH INSURANCE DISPATCH -RETIREMENT COMPUTER SUPPLIES UNIFORMS SCHOOL & TRAVEL (reimb. 911) SRO SALARIES HEALTH INSURANCE SRO RETIREMENT SHELTER/ANIMAL:VET TREATMENT SUBTOTAL POLICE DEPT ACTUAL YTD ----------------------------------------------- BUDGET REMAINING % 814,062 1,732,605 938,543 54% 16,427 0 16,427- 0% 5,747 6,500 753 12% 41,090 75,000 33,910 45% 1,354 27,500 26,146 95% 163,753 304,105 140,352 46% 101,840 230,721 128,881 56% 1,927 3,000 1,073 36% 2,148 5,500 3,352 61% 1,128 4,000 2,872 72% 1,619 5,000 3,381 68% 955 7,000 6,045 86% 95 2,000 1,905 95% 311 5,000 4,689 94% 4,414 15,000 10,586 71% 4,611 13,000 8,389 65% 2,571 3,500 929 27% 1,982 2,000 18 1 % 867 1,500 633 42% 365 1,000 635 64% 0 2,000 2,000 100% 3,076 5,000 1,924 38% 260 1,000 740 74% 8,718 15,000 6,282 42% 1,509 8,000 6,491 81% 2,144 3,000 856 29% 1,963 2,000 37 2% 16,254 21,500 5,246 24% 964 2,500 1,536 61% 16,943 26,000 9,057 35% 525 15,000 14,476 97% 182 2,000 1,818 91% 983 2,000 1,017 51% 1,558 8,000 6,442 81% 82 500 418 84% 0 1,000 1,000 100% 0 49,000 49,000 100% 0 20,000 20,000 100% 0 8,000 8,000 100% 164,572 327,330 162,758 50% 7,380 20,000 12,620 63% 30,050 54,325 24,275 45°% 21,550 44,111 22,561 51% 158,587 349,487 190,900 55% 7,250 15,000 7,750 52% 37,616 73,140 35,524 49% 10,773 22,586 11,813 52% 869 1,700 831 49% 925 1,800 875 49% 291 6,000 5,709 95% 56,908 107,306 50,398 47% 8,582 14,713 6,131 42°% 7,386 14,306 6,920 48% 0 6,500 6,500 ---------- 100% ----------- 1,735,164 ----------- 3,713,735 ----------- 1,978,571 53% O1/19/10 CITY OF KALISPELL Page 7 Quarterly Finance Report As of January 19th 2010 58.33% Yr Complete 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-345 1000-416-420400-354 1000-416-420400-358 1000-416-420400-362 1000-416-420400-369 1000-416-420400-373 1000-416-420400-610 1000-416-420400-620 1000-416-420440-110 1000-416-420440-153 1000-416-420440-155 1000-416-420440-210 1000-416-420440-241 1000-416-420440-314 1000-416-420440-320 1000-416-420440-322 1000-416-420440-333 1000-416-420440-335 1000-416-420440-345 1000-416-420440-354 1000-416-420440-373 1000-416-420440-379 1000-416-420440-380 1000-416-420465-322 1000-416-420465-380 1000-416-420470-213 1000-416-420470-218 1000-416-420470-224 1000-416-420470-241 1000-416-420470-341 1000-416-420470-342 1000-416-420470-344 1000-416-420470-354 1000-416-420470-362 1000-416-420470-366 FUND ------------------------------------ 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 TELEPHONE & COMMUNICATION CONTRACT SERVICES MT. F/F TESTING CONSORTIUM EQUIPMENT MAINTENANCE RADIO EQUIPMENT & MAINT. SCHOOL & TRAVEL DEBT RETIREMENT -FIRE TRUCK INTEREST EXPENSE -FIRE TRUCK FIRE PREVENTION -SALARIES HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES CONSUMABLE TOOLS/UNIFORMS PRIVATE HYDRANT RENTAL PRINTING BOOKS SUBSCRIPTION/FIRE CODES MEMBERSHIP/DUES TELEPHONE/COMMUNICATIONS CONTRACT SERVICES SCHOOL & TRAVEL MEETINGS TRAINING MATERIALS BOOKS TRAINING MATERIALS SMALL OFFICE EQUIPMENT EQUIPMENT (NOT CAPITAL) JANITORIAL SUPPLIES CONSUMABLE TOOLS ELECTRICITY WATER NATURAL GAS CONTRACT SERVICES EQUIPMENT MAINTENANCE BUILDING MAINTENANCE SUBTOTAL FIRE DEPT. GRAND TOTAL GENERAL FUND ACTUAL YTD BUDGET REMAINING o 665,563 1,520,431 854,868 56% 41,086 2,500 38,586- -1543% 15,518 40,000 24,482 61% 7,189 19,153 11,964 62% 139,546 242,475 102,929 42% 96,058 206,254 110,196 53% 288 850 562 66% 946 200 746- -373% 8 500 492 98% 1,477 5,000 3,523 70% 5,660 11,000 5,340 49% 479 700 221 32% 2,356 10,000 7,644 76% 48 200 152 76% 3,212 6,000 2,788 46% 527 5,000 4,474 89% 0 1,000 1,000 100% 2,151 5,000 2,849 57% 719 15,500 14,781 95% 212 1,500 1,288 86% 25,553 51,550 25,997 50% 8,528 16,475 7,947 48% 35,940 70,890 34,950 49% 7,702 13,186 5,484 42% 4,813 9,574 4,761 50% 390 500 110 22% 1,085 1,000 85- -8% 0 5,500 5,500 100% 366 500 134 27% 15 500 485 97% 217 500 283 57% 94 250 156 63% 1,502 2,500 998 40% 1,653 1,000 653- -65% 958 1,000 42 4% 0 500 500 100% 0 500 500 100% 0 500 500 100% 589 2,000 1,411 71% 0 200 200 100% 276 2,500 2,224 89% 550 750 200 27% 210 400 190 48% 4,482 10,000 5,518 55% 1,373 2,800 1,427 51% 3,363 15,000 11,637 78% 946 2,000 1,054 53% 529 1,500 971 65% 1,631 1,500 131- -9% ----------- 1,085,806 ----------- 2,308,338 --------------------- 1,222,533 53% 2,820,970 6,022,073 3,201,103 53% O1/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 250 1,200 950 79% 2185-000-430300-356 PROFESSIONAL SERVICES 1,209 15,000 13,791 92% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 7,907 13,554 5,648 42% 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 75 42,142 42,067 100% 2185-480-470240-110 SALARIES 19,059 49,113 30,054 61% 2185-480-470240-153 HEALTH INSURANCE 1,919 5,143 3,224 63% 2185-480-470240-155 RETIREMENT 1,241 3,188 1,947 61% TOTAL AIRPORT TIF ----------- 34,365 ----------- 939,340 ----------- ---------- 904,975 96% 2188 WESTSIDE TIF 2188-436-460430-930 GREENBRIAR PARK IMPROVEMENTS 13,099 18,180 5,081 28% 2188-453-430246-950 CONSTRUCTION/MERIDIAN ROAD 67,876 135,000 67,124 50% 2188-453-430246-951 STREET OVERLAYS 21,460 30,000 8,540 28°% 2188-453-430246-952 LOWER SPRING CREEK 3,846 40,000 36,154 90% 2188-453-430246-953 3 MILE DR ROAD DESIGN 68,505 146,926 78,421 53% 2188-453-430246-955 DPW -REDEVELOPMENT ACTIVITY 140 225,884 225,744 100% 2188-480-470230-110 SALARIES 2,537 8,500 5,963 70% 2188-480-470230-153 HEALTH INSURANCE 303 1,000 697 70% 2188-480-470230-155 RETIREMENT 165 500 335 67% 2188-480-470230-353 AUDIT 125 750 625 83% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 0 5,000 5,000 100% 2188-480-470230-356 REDEVELOPMENT APPRAISALS 701 25,000 24,299 97% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 14,583 25,000 10,417 42% 2188-480-470230-955 CD -REDEVELOPMENT ACTIVITY 425 1,500,000 1,499,575 100% TOTAL WESTSIDE TIF ----------- 193,766 ----------- 2,161,740 --------------------- 1,967,974 91% 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 392,755 850,000 457,245 54% 2215-000-312000-000 PEN & INTEREST DEL TAXES 122 0 122- 0% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 1,500 5,000 3,500 70% 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 9,703 18,000 8,297 46°% 2215-000-346051-000 RECREATION FEES 2,124 15,000 12,876 86% 2215-000-346052-000 SPORTS PROGRAMS 9,900 40,000 30,100 75% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 899 3,000 2,101 70% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 14,137 33,500 19,363 58% 2215-000-346055-000 ICE RINK 0 25,000 25,000 100% 2215-000-346057-000 YOUTH CAMPS 14,581 85,000 70,419 83% 2215-000-346059-000 PICNIC IN THE PARK 7,498 33,000 25,502 77% 2215-000-365010-000 DONATION/FERTILIZER 600 0 600- 0% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 60,000 60,000 0 0% TOTAL PARKS & REC REVENUE 621,575 1,362,500 740,925 54% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 124,684 263,573 138,889 53% 2215-436-460430-111 SEASONAL SALARIES 13,642 30,546 16,904 55% 2215-436-460430-112 SEVERANCE 12,091 0 12,091- 0% Page 8 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Page 9 Quarterly Finance Report As of January 19th 2010 58.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % - 2215-436-460430-121 --------- ------------------------------ OVERTIME 224 ------------ 1,500 1,276 ------- 85% 2215-436-460430-153 HEALTH INSURANCE 33,637 54,803 21,166 39% 2215-436-460430-155 RETIREMENT 9,566 18,364 8,798 48% 2215-436-460430-210 OFFICE SUPPLIES 466 1,200 734 61% 2215-436-460430-213 SMALL OFFICE EQUIPMENT 0 800 800 100% 2215-436-460430-215 COMPUTER SUPPLIES 67 1,000 933 93% 2215-436-460430-221 SAFETY EQUIPMENT 60 950 890 94% 2215-436-460430-224 JANITORIAL SUPPLIES 1,619 3,000 1,381 46% 2215-436-460430-229 OTHER SUPPLIES 792 6,000 5,208 87% 2215-436-460430-241 CONSUMABLE TOOLS/SMALL EQUIPMENT 222 1,600 1,378 86% 2215-436-460430-320 PRINTING 0 456 456 100% 2215-436-460430-333 SUBSCRIPTIONS 209 250 41 16% 2215-436-460430-335 MEMBERSHIP & DUES 55 450 395 88% 2215-436-460430-337 ADVERTISING 0 500 500 100% 2215-436-460430-341 ELECTRICITY 10,408 14,250 3,842 27% 2215-436-460430-342 WATER/SEWER 0 400 400 100% 2215-436-460430-344 NATURAL GAS 1,301 3,200 1,899 59% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,381 3,000 1,619 54% 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 148 1,500 1,352 90% 2215-436-460430-364 LANDSCAPING 0 3,000 3,000 100% 2215-436-460430-366 BUILDING MAINTENANCE 8 4,000 3,992 100% 2215-436-460430-367 VANDALISM REPAIRS 1,070 4,000 2,930 73% 2215-436-460430-373 SCHOOL & TRAVEL 1,140 1,200 60 5% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 95 550 455 83% 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 0 2,000 2,000 100% 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 8,611 17,027 8,416 49% 2215-436-460430-620 DEBT SERVICE INTEREST 274 413 139 34% TOTAL PARKS EXPENDITURES 223,743 459,032 235,289 51% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 23,391 46,179 22,788 49% 2215-436-460440-111 SEASONAL SALARIES 25,140 43,360 18,220 42% 2215-436-460440-153 HEALTH INSURANCE 7,702 13,204 5,502 42% 2215-436-460440-155 RETIREMENT 2,687 3,641 954 26% 2215-436-460440-221 SAFETY EQUIPMENT 0 175 175 100% 2215-436-460440-229 OTHER SUPPLIES 2,218 16,900 14,682 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 153 350 197 56% 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 1,298 3,000 1,702 57% 2215-436-460440-452 SAND & GRAVEL 78 1,200 1,122 93% TOTAL ATHLETIC COMPLEX 63,031 136,707 73,676 54% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 44,705 88,750 44,045 50% 2215-436-460431-111 SEASONAL SALARIES 8,029 13,704 5,675 41% 2215-436-460431-121 OVERTIME 0 500 500 100% 2215-436-460431-153 HEALTH INSURANCE 10,036 17,204 7,168 42% 2215-436-460431-155 RETIREMENT 2,781 5,475 2,694 49% 2215-436-460431-210 OFFICE SUPPLIES 452 600 148 25% 2215-436-460431-229 OTHER SUPPLIES 3,129 10,000 6,871 69% 2215-436-460431-320 PRINTING 0 6,000 6,000 100% 01/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ------------------------------------------------------------ 2215-436-460431-333 SUBSCRIPTIONS 0 ------------------------ 100 100 100% 2215-436-460431-335 MEMBERSHIP & DUES 0 300 300 100% 2215-436-460431-337 ADVERTISING 0 500 500 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 532 1,300 768 59% 2215-436-460431-354 CONTRACT SERVICES 15,316 25,000 9,684 39% 2215-436-460431-355 BANK FEES/CREDIT CARD FEES 643 2,500 1,857 74% 2215-436-460431-373 SCHOOL & TRAVEL 440 1,200 760 63% TOTAL RECREATION 86,063 173,133 87,070 50% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 33,096 65,238 32,142 49% 2215-436-460448-111 SEASONAL SALARIES 46,730 88,749 42,019 47% 2215-436-460448-121 OVERTIME 0 500 500 100% 2215-436-460448-153 HEALTH INSURANCE 9,470 16,234 6,764 42% 2215-436-460448-155 RETIREMENT 2,050 5,244 3,194 61°% 2215-436-460448-210 OFFICE SUPPLIES 0 500 500 100% 2215-436-460448-229 OTHER SUPPLIES 770 6,000 5,230 87% 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-460448-354 CONTRACT SERVICES 10,368 13,000 2,632 20% 2215-436-460448-355 AFTER SCHOOL PROGRAM 523 4,000 3,477 87% 2215-436-460448-366 BUILDING MAINTENANCE 0 5,000 5,000 100% 2215-436-460448-373 SCHOOL & TRAVEL 7 1,000 993 99% TOTAL YOUTH CAMPS 103,013 206,965 103,952 50% ICE RINK EXPENDITURES 2215-436-460450-111 SEASONAL SALARIES 0 15,349 15,349 100% 2215-436-460450-155 RETIREMENT 0 716 716 100% 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 3,367 20,000 16,633 83% 2215-436-460450-362 EQUIPMENT MAINTENANCE 0 2,600 2,600 100% TOTAL ICE RINK ----------- 3,367 ----------- 44,615 ----------- ---------- 41,248 92% 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 0 400 400 100% 2215-437-460445-320 PRINTING 0 50 50 100% 2215-437-460445-341 ELECTRICITY 6,026 12,500 6,474 52% 2215-437-460445-344 NATURAL GAS 14,036 28,000 13,964 50% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 487 1,500 1,013 68% 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 516 1,500 982 65% 2215-437-460445-380 TRAINING MATERIALS 0 250 250 100% TOTAL POOL EXPENDITURES 181,884 295,525 113,641 38% TOTAL PARKS & RECREATION/POOL 661,100 1,315,977 654,877 50% Page 10 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 267,710 765,000 497,290 65% 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 56 0 56- 0% TOTAL AMBULANCE REVENUE ---------------------- 312,126 855,000 --------------------- 542,874 63% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 198,678 475,779 277,101 58% 2230-440-420730-113 KELLY DAYS 2,830 10,000 7,170 72% 2230-440-420730-121 OVERTIME 2,256 6,038 3,782 63% 2230-440-420730-153 HEALTH INSURANCE 41,501 79,149 37,648 48% 2230-440-420730-155 RETIREMENT 25,438 60,444 35,006 58% 2230-440-420730-210 OFFICE SUPPLIES 0 1,000 1,000 100% 2230-440-420730-213 SMALL OFFICE EQUIPMENT 0 200 200 100% 2230-440-420730-215 COMPUTER SUPPLIES 198 2,000 1,802 90% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 548 2,000 1,452 73% 2230-440-420730-231 GAS AND OIL 3,760 10,000 6,240 62% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 0 5,000 5,000 100% 2230-440-420730-312 POSTAGE 1,205 3,000 1,795 60% 2230-440-420730-320 PRINTING 0 500 500 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 287 700 413 59% 2230-440-420730-353 AUDITING 125 500 375 75% 2230-440-420730-354 CONTRACT SERVICES/RECERT. 1,222 8,000 6,778 85% 2230-440-420730-358 MT FF TESTING CONSORTIUM 0 500 500 100% 2230-440-420730-359 CC FEES/COLLECTION SERV. 845 500 345- -69% 2230-440-420730-362 EQUIPMENT MAINTENANCE 1,786 3,500 1,714 49% 2230-440-420730-369 RADIO MAINTENANCE 0 2,500 2,500 100% 2230-440-420730-380 TRAINING MATERIALS 200- 3,000 3,200 107% 2230-440-420130-388 EXP. TESTING/IMMUNIZATION 200 5,000 4,800 96% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 21,761 38,000 16,239 43% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 13,703 17,134 3,432 20% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 4,667 8,000 3,333 42% 2230-440-420730-522 ADMIN. TRANSFER 21,046 36,078 15,033 42% 2230-440-420730-528 DATA PROC. TRANSFER 6,501 11,145 4,644 42% 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 ----------- 348,356 ----------- 827,167 ---------- 478,811 58% 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 98,773 150,000 51,227 34% 2394-000-323103-000 PLUMBING PERMITS 7,459 22,500 15,041 67% 2394-000-323104-000 MECHANICAL PERMITS 14,034 30,000 15,966 53% 2394-000-323107-000 HOUSE MOVING PERMITS 200 100 100- -100% 2394-000-323108-000 PLAN REVIEW FEES 42,240 120,000 77,760 65% 2394-000-371010-000 INVESTMENT EARNINGS 337 2,000 1,663 83% TOTAL REVENUE 163,043 324,600 161,557 50% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 126,882 253,056 126,174 50% 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 27,547 44,987 17,440 39% 2394-420-420530-155 RETIREMENT 7,992 15,993 6,001 50% 2394-420-420530-210 OFFICE SUPPLIES 183 2,000 1,817 91% 2394-420-420530-215 COMPUTER SUPPLIES 166- 3,500 3,666 105% 2394-420-420530-229 OTHER SUPPLIES 514 2,250 1,736 77% 2394-420-420530-231 GAS & OIL 765 2,500 1,735 69% 2394-420-420530-312 POSTAGE 317 600 283 47% 2394-420-420530-320 PRINTING 15 300 286 95% 2394-420-420530-322 BOOKS 59 2,250 2,191 97% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 2,500 2,500 100% Page 11 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Page 12 Quarterly Finance Report As of January 19th 2010 58.33% 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 641 1,500 859 57% 2394-420-420530-353 AUDITING 0 3,000 3,000 100% 2394-420-420530-354 CONTRACT SERVICES 500 500 0 0% 2394-420-420530-366 BUILDING MAINTENANCE 0 800 800 100% 2394-420-420530-373 SCHOOL & TRAVEL 565 5,000 4,435 89% 2394-420-420530-510 PROPERTY INSURANCE 6,947 8,800 1,853 21% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 350 600 250 42% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 7,206 12,353 5,147 42% 2394-420-420530-528 DATA PROCESSING TRANSFER 2,438 4,179 1,741 42% TOTAL BUILDING DEPT. ---- 183,534 ---------- 372,268 ------ ---------- 188,734 51% 2399 IMPACT FEE FUND 2399-400-420100-355 5% ADMIN CHARGE 0 7,100 7,100 100% 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 12,250 24,750 12,500 51% 2399-416-420400-620 INTEREST - FIRE TRUCK 5,406 10,310 4,904 48% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 165,000 165,000 100% TOTAL 2399 IMPACT FEE FUND ----------- 17,656 ----------- 228,160 --------------------- 210,504 92% 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 12,646 30,182 17,536 58% 2400-410-430263-153 HEALTH INSURANCE 3,600 7,922 4,322 55% 2400-410-430263-155 RETIREMENT 787 1,833 1,046 57% 2400-410-430263-244 STREET LIGHT SUPPLIES 3,281 13,000 9,719 75% 2400-410-430263-341 ELECTRICITY 72,534 145,000 72,466 50% 2400-410-430263-360 REPAIR & MAINT SERVICES 859 28,000 27,141 97% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 4,478 7,677 3,199 42% 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. 98,414 248,174 149,760 60% 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 10,250 35,000 24,750 71% 2420-421-430240-344 NATURAL GAS 1,698 2,500 802 32% 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 154,859 250,000 95,141 38% 2420-421-430240-369 RADIO EQUIPMENT & MAINT. 0 700 700 100% 2420-421-430240-452 GRAVEL 55 4,000 3,945 99% 2420-421-430240-453 MATERIALS; CONTRACT PREP. 325 5,000 4,675 94% 2420-421-430240-471 DE-ICER/ROAD OIL 21,964 50,000 28,036 56% 2420-421-430240-472 ASPHALT 13,642 25,000 11,358 45% 2420-421-430240-473 CRACK SEALING 150 5,000 4,850 97% 2420-421-430240-533 EQUIPMENT RENTAL 252 5,500 5,248 95% TOTAL GAS TAX --- 306,648 ----------- 568,700 ----------- ---------- 262,052 46% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 267,375 574,524 307,149 53% 2500-421-430240-121 OVERTIME 11,596 30,000 18,404 61% 2500-421-430240-153 HEALTH INSURANCE 62,595 109,112 46,517 43% 2500-421-430240-155 RETIREMENT 17,339 35,243 17,904 51% 2500-421-430240-213 SMALL OFFICE EQUIPMENT 0 500 500 100% 2500-421-430240-216 COMPUTER EQUIPMEMT 124 1,850 1,726 93% 2500-421-430240-218 EQUIPMENT (NON CAPITAL) 0 1,000 1,000 100% 2500-421-430240-221 SAFETY EQUIPMENT 413 1,000 587 59% 2500-421-430240-224 JANITORIAL SUPPLIES 377 700 323 46% O1/19/10 CITY OF KALISPELL Page 13 Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % 2500-421-430240-229 OTHER SUPPLIES 556 1,200 644 54% 2500-421-430240-231 GAS & OIL 10,367 40,000 29,633 74% 2500-421-430240-241 CONSUMABLE TOOLS 563 2,000 1,437 72% 2500-421-430240-341 ELECTRICITY 512 700 188 27% 2500-421-430240-342 WATER/SEWER CHARGES 75 150 75 50% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 475 1,200 725 60% 2500-421-430240-354 CONTRACT SERVICES 7,650 13,000 5,350 41% 2500-421-430240-355 CONTRACT SERV.-AERIAL MAPPING 127 13,000 12,873 99°% 2500-421-430240-357 RATE STUDY 8,017 22,500 14,483 64% 2500-421-430240-358 IMPACT FEE STUDY 0 7,000 7,000 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 15,775 22,000 6,225 28% 2500-421-430240-366 BUILDING MAINTENANCE 335 1,500 1,165 78% 2500-421-430240-369 RADIO EQUIPMENT & MAINT. 145 5,000 4,855 97% 2500-421-430240-373 SCHOOL & TRAVEL 420 3,500 3,080 88% 2500-421-430240-388 MEDICAL SERVICES 1,155 900 255- -28% 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 36,750 63,000 26,250 42% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 29,364 50,339 20,975 42% 2500-421-430240-528 DATA PROCESSING TRANSFER 6,501 11,145 4,644 42% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 0 12,500 12,500 100% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 780 227 553- -244% 2500-421-430240-840 MAGI 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 0 170,000 170,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 37,877 70,000 32,123 46% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 6,296 37,337 31,041 83°% 2500-421-430264-110 TSS - SALARIES 70,326 140,245 69,919 50% 2500-421-430264-121 OVERTIME 5,198 8,000 2,802 35% 2500-421-430264-153 HEALTH INSURANCE 9,900 19,722 9,822 50% 2500-421-430264-155 RETIREMENT 4,663 8,781 4,118 47°% 2500-421-430264-216 COMPUTER EQUIP & SOFTWARE 227 1,500 1,273 85% 2500-421-430264-218 EQUIPMENT(non-capital) 280 3,600 3,320 92% 2500-421-430264-221 SAFETY EQUIPMENT & SUPPLIES 109 500 391 78% 2500-421-430264-224 JANITORIAL SUPPLIES 341 650 309 48% 2500-421-430264-229 OTHER SUPPLIES 305 800 495 62% 2500-421-430264-241 CONSUMABLE TOOLS 83 1,100 1,017 92% 2500-421-430264-242 STREET SIGNS 18,869 35,000 16,131 46% 2500-421-430264-243 TRAFFIC SIGNALS 187 10,000 9,813 98% 2500-421-430264-245 BARRICADE MATERIALS 483 4,000 3,517 88% 2500-421-430264-341 ELECTRICITY 4,117 11,000 6,883 63% 2500-421-430264-345 COMMUNICATIONS 330 800 470 59% 2500-421-430264-354 CONTRACT SERVICES 5,872 10,000 4,128 41% 2500-421-430264-362 EQUIPMENT MAINTENANCE 517 1,400 883 63% 2500-421-430264-366 BUILDING MAINTENANCE 692 1,500 808 54% 2500-421-430264-369 RADIO MAINTENANCE 0 900 900 100% 2500-421-430264-373 SCHOOL & TRAVEL 187 3,500 3,313 95% 2500-421-430264-428 PAINT MATERIALS 2,058 25,000 22,942 92% 2500-421-430264-510 LIABILITY INS.-TSS 5,205 5,775 570 10% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 1,413 1,000 413- -41% 2500-421-430264-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SPEC. ST. MAINT. 1,102,583 2,303,226 1,200,643 52% 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 62,169 131,520 69,351 53% 2600-436-460433-112 SEVERANCE 4,030 0 4,030- 0% 2600-436-460433-121 OVERTIME 72 750 678 90% 2600-436-460433-153 HEALTH INSURANCE 12,812 25,066 12,254 49% 2600-436-460433-155 RETIREMENT 4,028 8,236 4,208 51% 2600-436-460433-210 OFFICE SUPPLIES 0 50 50 100% 2600-436-460433-229 OTHER SUPPLIES 54 500 447 89% 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% 58.33% Yr Complete O1/19/10 FUND FUND CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 ACTUAL YTD BUDGET REMAINING % ------------------------------------------------------------ 2600-436-460433-362 EQUIPMENT MAINTENANCE 2600-436-460433-364 LANDSCAPING & TREES 2600-436-460433-373 SCHOOL & TRAVEL 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 2600-436-460433-521 CENTRAL GARAGE TRANSFER 2600-436-460433-522 ADMIN. TRANSFER 2600-436-460433-528 DATA PROCESSING TRANSFER TOTAL URBAN FORESTRY 2602 ARRA FORESTRY GRANT 2602-436-460433-354 CONTRACT SERVICES TOTAL ARRA FORESTRY GRANT 2880 COM DEV REVOLVING FUND 2880-480-470240-708 REDEVELOPMENT FUNDS -DISTRIBUTION 2880-480-470240-711 IRP LOAN PROGRAM MATCH 2880-480-470240-720 EAGLE TRANSIT TOTAL LOAN REVOLVING 2886 UDAG FUND 2886-480-470210-110 SALARIES - UDAG 2886-480-470210-153 HEALTH INSURANCE 2886-480-470210-155 RETIREMENT 2886-480-470210-210 OFFICE SUPPLIES 2886-480-470210-211 GRANT ADMIN. EXPENSES 2886-480-470210-212 PROJECT EXPENSES 2886-480-470210-213 SMALL OFFICE EQUIPMENT 2886-480-470210-215 COMPUTER SUPPLIES 2886-480-470210-218 EQUIPMENT (non -capital) 2886-480-470210-231 GAS & OIL 2886-480-470210-312 POSTAGE 2886-480-470210-320 PRINTING 2886-480-470210-331 GRANT ACTIVITIES ADVERTISING 2886-480-470210-334 MT WEST MEMBERSHIP 2886-480-470210-335 MEMBERSHIP & DUES 2886-480-470210-345 TELEPHONE & COMMUNICATION 2886-480-470210-353 AUDITING 2886-480-470210-354 CONTRACT SERVICES 2886-480-470210-355 PROSPECT DEVELOPMENT 2886-480-470210-363 OFFICE EQUIP MAINTENANCE 2886-480-470210-373 SCHOOL & TRAVEL 2886-480-470210-379 MEETINGS 2886-480-470210-381 TRAINING 2886-480-470210-396 STUDIES/SURVEYS 2886-480-470210-510 PROPERTY & LIABILITY INS. 2886-480-470210-521 CENTRAL GARAGE TRANSFER 2886-480-470210-522 ADMINISTRATIVE TRANSFER 2886-480-470210-528 DATA PROCESSING TRANSFER 2886-480-470210-532 OFFICE RENT 2886-480-470210-710 LAND TRUST DONATION 2886-480-470210-711 HISTORIC PRESERVATION PROJECT 2886-480-470210-790 COMM. DEV. ACTIVITIES TOTAL UDAG FUND ------------------------------------------------ 23 500 477 95% 3,885 7,000 3,115 45% 0 250 250 100% 4,192 4,945 753 15% 1,458 2,500 1,042 42% 3,974 6,813 2,839 42% 813 1,393 580 42% 99,881 206,748 106,867 52% 73 93,500 93,428 100% 73 93,500 93,428 100% 25,776 25,776 11 150,000 0 ---------------------- 15,000 25,787 190,776 30,996 3,838 2,019 0 1 1 0 540 0 77 64 440 511 0 549 131 375 0 0 0 778 80 0 4,000 2,660 292 6,096 4,876 2,352 9,000 2,000 0 71,674 95,074 11,769 6, 619 500 1,000 0 200 1,000 300 300 300 6,000 335 500 700 750 1,500 1,000 3,000 100 3,000 500 1,500 25,000 4,200 500 10,451 8,359 4,703 18,000 19,000 2,500 228,660 0 0% 149,989 100% 15,000 100°% ------------------ 164,989 86% 64,078 67% 7, 931 67% 4,600 70% 500 100% 999 100% 1- 0% 200 100% 461 46% 300 100% 223 74% 236 79% 5,560 93°% 176- -53% 500 100% 151 22% 619 83% 1,125 75% 1,000 100% 3,000 100% 100 100% 2,222 74% 420 84% 1,500 100% 21,000 84% 1,540 37% 208 42% 4,355 42% 3,483 42% 2,352 50% 9,000 50% 17,000 89% 2,500 100% 156,986 69% Page 14 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- RURAL DEVELOPMENT REVOLVING 2887-480-470210-110 SALARIES 15,345 38,307 22,962 60% 2887-480-470210-153 HEALTH INSURANCE 2,525 6,060 3,535 58% 2887-480-470210-155 RETIREMENT 999 2,476 1,477 60% 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 16,975 17,046 71 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 5,099 5,029 70- -1% 2887-480-470210-750 REDEVELOPMENT LOANS 46 150,000 149,954 100% ----------- TOTAL RURAL DEVELOPMENT ----------- ------ 40,989 ----- ----------- 218,918 ------- ---- ----------- --------------------- 177,929 --------------------- --------------------- 81% 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 0 45,000 45,000 --------------------- 100% ----------- TOTAL 2888 RURAL DEV. #2 ----------- ----------- 2,575 ----------- 47,575 ----------- ----------- 45,000 -------- ------------ ------------------- 95% 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,234 400,000 396,766 99% TOTAL EPA BROWNSFIELD GRANT 3,234 400,000 396,766 99% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 9,276 49,387 40,111 81% 2916-413-420140-121 OVERTIME 1,361 11,000 9,639 88% 2916-413-420140-153 HEALTH INSURANCE 1,010 13,204 12,194 92% 2916-413-420140-155 RETIREMENT 1,282 6,655 5,373 81% 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 13,602 84,646 71,044 84% 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 0 51,388 51,388 100% 2918-413-420140-153 HEALTH INSURANCE 0 13,204 13,204 100% 2918-413-420140-155 RETIREMENT 0 6,655 6,655 100% ----------- TOTAL 2918 COPS HIRING GRANT --------- 0 ----------- 71,247 ----------- --------------------- 71,247 -------------------- 100% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - DISPATCH 2,517 4,000 1,483 37% 2919-413-420140-121 OVERTIME - DISPATCH 1,161 0 1,161- 0% 2919-413-420140-125 DUI TASK FORCE 3,809 10,000 6,191 62% 2919-413-420140-126 HOLIDAY OT REIMB. 26,486 40,000 13,514 34% 2919-413-420140-127 SCHOOL DIST. OT 7,254 20,000 12,746 64% 2919-413-420140-155 RETIREMENT 3,866 4,000 134 3% 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,363 87% 2919-413-420140-221 RIFLES FOR SWAT TEAM 0 5,600 5,600 100% 2919-413-420140-944 VEHICLES ----------- 32,449 35,500 ----------- 3,051 --------------------- 9% Page 15 58.33% Yr Complete 01/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- TOTAL LAW ENF. GRANT 95,927 161,195 65,268 40% ------------------------------------------ ------------------------------------------- 2921 DRUG COURT GRANT 2921-406-410360-354 DRUG COURT -contract services 292 348,473 348,181 100% TOTAL DRUG COURT GRANT 292 348,473 348,181 100% 2950 DOM. VIOLENCE COMPLIANCE 2950-406-410360-354 DOMESTIC VIOLENCE GT-contract serv. 4,635 10,363 5,728 55% ------------------------------------------- TOTAL DOM. VIOLENCE COMPLIANCE 4,635 10,363 5,728 55% 2931 DUI COURT GRANT 2951-406-410360-354 CONT SERV-EVALUATOR, PO, LAC 47,355 28,964 18,391- -64% 2951-406-410360-355 CONT SERV/DRUG & ALCOHOL TESTING 164 35,859 35,695 100% 2951-406-410360-373 SCHOOL & TRAVEL 9,472 8,000 1,472- -18% TOTAL DUI COURT GRANT 56,991 72,823 15,832 22% 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 EQUIPMENT 2957-416-420400-229 HAZMAT REIMB.-MATERIALS 2957-416-420400-354 HAZ TECH TRN GRT/HMEP&CERCLA 34,000 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-420413-940 AFG REGIONAL CAD SYSTEM 2957-416-420414-218 AFG EQUIPMENT AND SAFETY 2957-416-420415-940 HERITAGE PROGRAM GRANT 2957-416-420420-126 WILDLAND FIRE OT 2957-416-420450-940 MDOT GRANT RADIOS 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 2992 ENERGY BLOCK GRANT 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS TOTAL 2992 ENERGY BLOCK GRANT 137 10,000 9,863 99% 0 15,000 15,000 100% 0 1,564 1,564 100% 294 1,436 1,142 80% 9,550 45,812 36,262 79% 4,669 6,000 1,331 22% 0 6,000 6,000 100% 0 30,000 30,000 100% 0 20,000 20,000 100% 2,367 20,000 17,633 88% 2,097 31,125 29,028 93% 17- 5,000 5,017 100% 787,315 915,876 12B,561 14% 0 120,000 120,000 100% 5,460 8,207 2,747 33% 0 130,000 130,000 100% 0 30,000 30,000 100% ----------- 811,872 ---------- ----------- 1,396,020 ---------- --------------------- 584,148 -------------------- 42% 97,846 299,000 201,154 67% 97,846 299,000 201,154 67% 0 342,000 342,000 100% ----------- 0 ----------- ----------- 342,000 ---------- 342,000 100% 5,926 ----------- 96,700 ---------------------- 90,774 ---------- 94% 5,926 96,700 90,774 94% Page 16 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- CAPITAL PROJECT FUNDS 4185 AIRPORT TIF BOND/LAND 4185-000-430300-354 BOND ISSUE COSTS 0 30,000 30,000 100% 4185-000-430300-950 LAND ACQUISITION 0 1,970,000 1,970,000 100% TOTAL 4185 AIRPORT TIF BOND/LD ----------- 0 ----------- 2,000,000 --------------------- 2,000,000 100% 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% 4310 FAA LAND ACQUISITION 4310-430-430310-910 AIRPORT LAND ACQUISITION 0 1,492,755 1,492,755 100% 4310-430-430310-940 AIRPORT CAPITAL IMPROVEMENTS 0 1,381,804 1,381,804 100% TOTAL FAA LAND ACQ. ----------- 0 ----------- 2,874,559 ----------- ---------- 2,874,559 100% Page 17 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Page 18 Quarterly Finance Report As of January 19th 2010 58.33% 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 1,601,387 2,400,000 798,613 33% 5210-000-343220-000 UNMETERED WATER SALES 18,119 4,000 14,119- -353% 5210-000-343225-000 IMPACT FEES 147,170 300,000 152,830 51% 5210-000-343230-000 METER REPLACEMENT FEE 51,003 90,000 38,997 43% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 10,923 25,000 14,077 56% 5210-000-343265-000 LATECOMER ADMIN FEES 2,323 4,000 1,677 42% 5210-000-343270-000 WATER TURN ON FEES 2,115 3,000 885 30% 5210-000-343275-000 TAG FEE 9,260 18,000 8,740 49% 5210-000-371010-000 INVESTMENT EARNINGS 39,284 90,000 50,716 56% TOTAL WATER REVENUE ----------- 1,881,584 ----------- 3,164,154 --------------------- 1,282,570 41% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 343,715 717,372 373,657 52% 5210-447-430550-121 OVERTIME 9,176 20,500 11,324 55% 5210-447-430550-153 HEALTH INSURANCE 75,395 156,754 81,359 52% 5210-447-430550-155 RETIREMENT 22,031 45,079 23,048 51% 5210-447-430550-210 OFFICE SUPPLIES 333 400 67 17% 5210-447-430550-213 SMALL OFFICE EQUIPMENT 0 1,000 1,000 100% 5210-447-430550-214 GIS SUPPLIES 13 5,000 4,987 100% 5210-447-430550-215 COMPUTER SUPPLIES 4,162 3,000 1,162- -39% 5210-447-430550-216 COMPUTER EQUIPMEMT 3,114 5,000 1,886 38% 5210-447-430550-218 EQUIPMENT (NON CAPITAL) 3,868 8,475 4,607 54% 5210-447-430550-221 SAFETY EQUIP & SUPPLIES 524 2,500 1,976 79% 5210-447-430550-224 JANITORIAL SUPPLIES 388 800 412 51% 5210-447-430550-226 CHLORINE & CHEMICALS 14,136 25,000 10,864 43% 5210-447-430550-229 OTHER SUPPLIES 758 1,500 742 49% 5210-447-430550-231 GAS & OIL 10,962 38,000 27,038 71% 5210-447-430550-241 CONSUMABLE TOOLS 1,916 2,500 584 23% 5210-447-430550-312 POSTAGE 272 2,500 2,228 89% 5210-447-430550-320 PRINTING 3,912 2,000 1,912- -96% 5210-447-430550-335 MEMBERSHIP & DUES 427 1,200 773 64% 5210-447-430550-336 LICENSES & FEES 104 19,000 18,897 99% 5210-447-430550-341 ELECTRICITY 80,795 142,000 61,205 43% 5210-447-430550-342 WATER 158 500 342 68% 5210-447-430550-344 NATURAL GAS 3,639 16,000 12,361 77% 5210-447-430550-345 TELEPHONE & COMMUNICATION 3,931 8,000 4,069 51% 5210-447-430550-349 LAB SERVICES 6,881 35,500 28,619 81% 5210-447-430550-353 AUDITING 750 3,000 2,250 75% 5210-447-430550-354 CONTRACT SERVICES 20,809 65,000 44,191 68% 5210-447-430550-355 CONTRACT SERV.-AERIAL MAPPING 165 3,000 2,835 95% 5210-447-430550-356 WTR RIGHTS UPDATE/WTRSHED CONTROL P 5,965 35,000 29,035 83% 5210-447-430550-357 RATE STUDY 3,566 10,000 6,434 64% 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 820 4,000 3,180 80% 5210-447-430550-363 OFFICE EQUIP MAINTENANCE 0 200 200 100% 5210-447-430550-366 BUILDING MAINTENANCE 1,181 20,000 18,819 94% 5210-447-430550-369 RADIO EQUIPMENT & MAINT. 0 2,450 2,450 100% 5210-447-430550-373 SCHOOL & TRAVEL 1,374 6,500 5,126 79% 5210-447-430550-380 TRAINING MATERIALS 0 500 500 100% 5210-447-430550-388 MEDICAL SERVICES 362 800 439 55% 5210-447-430550-395 RENTAL EQUIPMENT 0 1,500 1,500 100% 5210-447-430550-410 CONSTRUCTION MATERIALS 5,933 30,000 24,067 80% 5210-447-430550-422 HYDRANTS 500 34,000 33,500 99% 5210-447-430550-423 MATERIALS FOR MAINS 2,449 12,000 9,551 80% 5210-447-430550-424 MATERIALS -SERVICE LINES 6,006 8,000 1,994 23% 5210-447-430550-425 MATERIALS PUMPS/LIFT ST. 16,778 36,000 19,222 53% 5210-447-430550-510 PROPERTY & LIABILITY INS. 36,169 38,000 1,831 5% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 751 4,000 3,249 81% 5210-447-430550-513 UNINSURED LOSS -GOODWILL 0 7,500 7,500 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 4,958 8,500 3,542 42% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 52,591 90,156 37,565 42% O1/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % 5210-447-430550-528 ---------------------------------------------------------------------- DATA PROCESSING TRANSFER 12,190 20,897 8,707 42% 5210-447-430550-532 LEASE PAYMENTS 3,919 7,838 3,919 50% 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) 38,462 105,000 66,538 63% 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 0 35,000 35,000 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 100,000 100,000 100% 5210-447-430555-941 METERS (NEW SERVICES) 32,826 65,000 32,174 50% 5210-447-430555-953 SECTION 36 WELL 0 75,000 75,000 100% TOTAL WATER FACILITIES ----------- 984,574 ----------- ----------- 3,252,353 ----------- --------------------- 2,267,779 --------------------- 70% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 36,607 91,459 54,852 60% 3210-447-430560-153 HEALTH INSURANCE 7,938 23,486 15,548 66% 5210-447-430560-155 RETIREMENT 2,354 5,891 3,537 60% 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 375 1,500 1,125 75% 5210-447-430560-354 CONTRACT SERVICES 2,270 7,500 5,230 70% 5210-447-430560-355 BILLING COSTS 14,939 25,000 10,061 40% 5210-447-430560-373 SCHOOL & TRAVEL 410 1,200 790 66% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 3,601 6,173 2,572 42% 5210-447-430560-528 DATA PROCESSING TRANSFER 13,357 22,897 9,540 42% 5210-447-430560-532 RENT 3,919 7,838 3,919 50% TOTAh WATER BILLING 86,191 196,794 110,603 56% 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,232,880 4,661,052 3,428,172 74% Page 19 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Page 20 Quarterly Finance Report As of January 19th 2010 58.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- SEWER REVENUE: 5310-000-331158-000 STATE BYPASS RELOCATION REIMB. 0 217,431 217,431 100% 5310-000-343310-000 SEWER SERVICE CHARGES 1,802,739 3,450,000 1,647,261 48% 5310-000-343330-000 IMPACT FEES (SANITARY) 69,480 175,000 105,520 60% 5310-000-343335-000 IMPACT FEES (WWTP) 93,690 246,000 152,310 62% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 550 1,000 450 45% 5310-000-343365-000 LATECOMER ADMIN FEES 258 850 592 70% 5310-000-371010-000 INVESTMENT EARNINGS 54,270 165,000 110,730 67% TOTAL SEWER REVENUE ----------- 2,020,987 ----------- 4,255,281 --------------------- 2,234,294 53% EXPENDITURES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 44,810 75,236 30,426 40% 5310-454-430620-153 HEALTH INSURANCE 10,462 17,935 7,473 42% 5310-454-430620-155 RETIREMENT 2,892 4,792 1,900 40% 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 375 1,500 1,125 75% 5310-454-430620-354 CONTRACT SERVICES 398 7,500 7,103 95% 5310-454-430620-355 BILLING COSTS 16,604 24,000 7,396 31% 5310-454-430620-373 SCHOOL & TRAVEL 403 1,000 598 60% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 4,016 6,884 2,868 42% 5310-454-430620-528 DATA PROCESSING TRANSFER 13,357 22,897 9,540 42% 5310-454-430620-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SEWER BILLING COSTS ----------- 97,808 ----------- ----------- 172,382 ----------- --------------------- 74,574 --------------------- 43% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 178,831 364,781 185,950 51% 5310-454-430630-121 OVERTIME 3,592 6,500 2,908 45% 5310-454-430630-153 HEALTH INSURANCE 37,178 68,379 31,201 46% 5310-454-430630-155 RETIREMENT 11,457 22,597 11,140 49% 5310-454-430630-210 OFFICE SUPPLIES 122 450 328 73% 5310-454-430630-213 SMALL OFFICE EQUIPMENT 0 500 500 100% 5310-454-430630-214 CIS SUPPLIES 13 2,000 1,987 99% 5310-454-430630-215 COMPUTER SUPPLIES 1,700 2,000 300 15% 5310-454-430630-216 COMPUTER EQUIPMEMT 28- 2,500 2,528 101% 5310-454-430630-218 EQUIPMENT (NON CAPITAL) 34- 5,500 5,534 101% 5310-454-430630-221 SAFETY EQUIP & SUPPLIES 823 900 77 9% 5310-454-430630-224 JANITORIAL SUPPLIES 270 600 330 55% 5310-454-430630-229 OTHER SUPPLIES 285 800 515 64% 5310-454-430630-231 GAS & OIL 3,858 14,500 10,642 73% 5310-454-430630-241 CONSUMABLE TOOLS 580 1,200 620 52% 5310-454-430630-312 POSTAGE 64 750 666 89% 5310-454-430630-336 LICENSES & FEES 30 450 420 93% 5310-454-430630-341 ELECTRICITY 18,743 36,000 17,257 48% 5310-454-430630-342 WATER 89 175 86 49% 5310-454-430630-344 NATURAL GAS 6,173 12,500 6,327 51% 5310-454-430630-345 TELEPHONE & COMMUNICATION 10,740 20,500 9,760 48% 5310-454-430630-353 AUDITING 500 2,000 1,500 75% 5310-454-430630-354 CONTRACT SERVICES 7,767 22,100 14,333 65% 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 4,465 12,500 8,035 64% 5310-454-430630-358 IMPACT FEE REVIEW 1,193 5,000 3,807 76% 5310-454-430630-362 EQUIPMENT MAINTENANCE 2,439 7,800 5,361 69% 5310-454-430630-366 BUILDING MAINTENANCE 268 1,000 732 73% 5310-454-430630-369 RADIO EQUIPMENT & MAINT. 0 1,000 1,000 100% 5310-454-430630-373 SCHOOL & TRAVEL 715 3,000 2,285 76% 5310-454-430630-388 MEDICAL SERVICES 373 800 427 53% 5310-454-430630-410 CONSTRUCTION MATERIALS 5,746 10,000 4,254 43% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 5,091 14,500 9,409 65% 5310-454-430630-510 PROPERTY & LIABILITY INS. 25,027 28,500 3,473 12% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 15,244 18,000 2,756 15% O1/19/10 CITY OF KALISPELL Page 21 Quarterly Finance Report As of January 19th 2010 58.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------- 5310-454-430630-521 CENTRAL GARAGE TRANSFER 1,750 3,000 1,250 - 42% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 31,950 54,771 22,821 42% 5310-454-430630-528 DATA PROCESSING TRANSFER 8,940 15,325 6,385 42% 5310-454-430630-532 OFFICE RENT 3,919 7,838 3,919 50% 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 5,870 25,000 19,130 77% 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 ----------- 413,316 -------- - 1,117,969 ----------- ---- 704,653 --------------------- 63% 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% 371,048 500,000 128,952 26% ----------- TOTAL SANITARY SEWER PLANT INV 371,048 ----------- 575,832 --------------------- 204,784 36% 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 838,764 2,339,501 1,500,737 64% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 192,876 400,679 207,803 52% 5310-455-430640-121 OVERTIME 9,601 20,000 10,399 52% 5310-455-430640-153 HEALTH INSURANCE 37,867 68,415 30,549 45% 5310-455-430640-155 RETIREMENT 12,676 24,751 12,075 49% 5310-455-430640-210 OFFICE SUPPLIES 839 1,000 161 16% 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 89 1,500 1,411 94% 5310-455-430640-221 SAFETY EQUIP & SUPPLIES 36 2,500 2,464 99% 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 0 12,500 12,500 100% 5310-455-430640-229 OTHER SUPPLIES 2,998 4,000 1,002 25% 5310-455-430640-231 GAS & OIL 3,180 14,000 10,820 77% 5310-455-430640-241 CONSUMABLE TOOLS 829 1,000 171 17% 5310-455-430640-312 POSTAGE 97 500 403 81% 5310-455-430640-335 MEMBERSHIP & DUES 285 1,200 915 76% 5310-455-430640-336 LICENSES & FEES 363 7,500 7,137 95% 5310-455-430640-341 ELECTRICITY 88,014 235,000 146,986 63% 5310-455-430640-342 WATER 2,856 8,500 5,644 66% 5310-455-430640-344 NATURAL GAS 17,237 65,000 47,763 73% 5310-455-430640-345 TELEPHONE & COMMUNICATION 2,598 6,000 3,402 57% 5310-455-430640-353 AUDITING 625 2,750 2,125 77% 01/19/10 FUND FUND CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 ACTUAL YTD BUDGET REMAINING % ------------------------ 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 ------------------------------------------- 55,436 130,000 74,564 57% 13,337 45,000 31,663 70% 2,928 25,000 22,072 88% 4,465 12,500 8,035 64% 0 25,000 25,000 100% 0 15,000 15,000 100% 1,381 2,500 1,119 45% 3,665 14,000 10,335 74% 0 500 500 100% 128 700 572 82% 0 1,000 1,000 100% 46,941 56,500 9,559 17% 2,333 4, 000 1,667 42% 55,550 95,228 39,678 42% 11,377 19,504 8,127 42% 577,817 1,394,477 816,660 59% 11,064 60,000 48,936 82% 16,617 73,000 56,383 77% 27,681 133,000 105,319 79% 64,743 126,206 61,463 49% 0 300 300 100% 10,326 21,295 10,969 52% 4,044 7,795 3,751 48% 0 100 100 100% 0 50 50 100% 5,224 5,400 176 3% 3,718 7,500 3,782 50% 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% 10,823 20,000 9,178 46% 558 1,500 942 63% 1,098 4,000 2,903 73% 0 200 200 100% 100,590 196,146 95,556 49% 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% Page 22 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Page 23 Quarterly Finance Report As of January 19th 2010 56.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- ------------------------------------------- DEPRECIATION 5310-455-510400-831 DEPRECIATION EXPENSE 0 419,375 419,375 100% ----------- ----------- ----------- ---------- TOTAL DEPRECIATION 0 419,375 419,375 100% ------------------------------------------- TOTAL WWTP 1,278,356 3,392,928 2,114,572 62% TOTAL BILLING/SANITARY/WWTP 2,214,928 5,904,811 3,689,883 62% O1/19/10 CITY OF KALISPELL Page 24 Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % STORM SEWER REVENUE 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 14,787 5,000 9,787- -196% 5349-000-343033-000 IMPACT FEES 200,538 200,000 538- 0°% 5349-000-343034-000 PERMIT FEES 660 1,800 1,140 63% 5349-000-343035-000 STORM SEWER CHARGES 984- 1,000 1,984 198% 5349-000-343370-000 STORM SEWER ASSESSMENTS 804,582 800,000 4,582- -1% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,120 2,500 380 15% 5349-000-371010-000 INTEREST ON INVESTMENTS 15,393 30,000 14,607 49% TOTAL STORM REVENUE ----------- 1,037,096 ----------- ----------- 1,040,300 ----------- --------------------- 3,204 ----------- ---------- 0°% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 165,604 342,098 176,494 52% 5349-453-430246-121 OVERTIME 1,975 4,500 2,525 56% 5349-453-430246-153 HEALTH INSURANCE 33,016 65,457 32,441 50% 5349-453-430246-155 RETIREMENT 10,619 21,412 10,793 50% 5349-453-430246-210 OFFICE SUPPLIES/EQUIPMENT 24 1,200 1,176 98% 5349-453-430246-214 GIS SUPPLIES 13 3,000 2,987 100% 5349-453-430246-215 COMPUTER SUPPLIES 4,161 4,000 161- -4% 5349-453-430246-216 COMPUTER EQUIPMENT 2,770 3,000 230 8% 5349-453-430246-218 EQUIPMENT -NON CAPITAL 621 2,200 1,579 72% 5349-453-430246-221 SAFETY EQUIP & SUPPLIES 130 1,000 870 87% 5349-453-430246-229 OTHER SUPPLIES 48 1,200 1,152 96% 5349-453-430246-231 GAS & OIL 3,800 13,500 9,700 72% 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 405 700 295 42% 5349-453-430246-353 AUDITING 150 600 450 75% 5349-453-430246-354 CONTRACT SERVICE 3,581 2,000 1,581- -79% 5349-453-430246-355 CONTRACT SERV.-AERIAL MAPPING 0 3,000 3,000 100% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 6,090 12,500 6,410 51% 5349-453-430246-357 RATE STUDY 8,017 22,500 14,483 64% 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 865 1,200 335 28% 5349-453-430246-362 GROUNDWATER MONITORING 13,706 27,000 13,294 49% 5349-453-430246-371 CURB & GUTTER 7,504 5,000 2,504- -50% 5349-453-430246-373 SCHOOL & TRAVEL 890 4,500 3,610 80% 5349-453-430246-388 MEDICAL SERVICES 0 250 250 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 41 10,000 9,959 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 9,282 10,000 718 7% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 1,458 2,500 1,042 42% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 19,161 32,848 13,687 42% 5349-453-430246-528 DATA PROCESSING TRANSFER 3,251 5,373 2,322 42% 5349-453-430246-530 BNSF LEASE PMT 1,600 4,200 2,600 62% 5349-453-430246-532 LEASE PAYMENTS 7,438 7,838 400 5% 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,386 80,000 6,614 8% 5349-453-430248-958 STILLWATER/WILLOW GLEN CONST 245,737 380,000 134,263 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 ----------- 802,756 ---------------------- 1,673,494 ---------- 870,738 52% 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION 758,110 750,000 8,110- -1% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,941 3,500 1,559 45% 5510-000-371010-000 INVESTMENT EARNINGS 1,098 3,500 2,402 69% TOTAL SOLID WASTE REVENUE 761,148 ----------- 757,000 ----------- 4,148- --------------------- -1% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 179,374 381,964 202,590 53% 5510-460-430840-121 OVERTIME 2,168 9,500 7,332 77% 5510-460-430840-153 HEALTH INSURANCE 37,767 68,729 30,962 45% 5510-460-430840-155 RETIREMENT 11,357 23,609 12,252 52% 5510-460-430840-213 SMALL OFFICE EQUIPMENT 40 500 460 92% 5510-460-430840-216 COMPUTER EQUIPMEMT 40 2,500 2,460 98% 5510-460-430840-218 EQUIPMENT -NOT CAPITAL 0 25,000 25,000 100% 5510-460-430840-221 SAFETY EQUIP & SUPPLIES 336 1,500 1,164 78% 5510-460-430840-224 JANITORIAL SUPPLIES 156 400 244 61% 5510-460-430840-229 OTHER SUPPLIES 426 2,000 1,574 79% 5510-460-430840-231 GAS & OIL 15,986 47,800 31,814 67% 5510-460-430840-241 CONSUMABLE TOOLS 14 1,500 1,486 99% 5510-460-430840-341 ELECTRICITY 681 1,600 919 57% 5510-460-430840-344 NATURAL GAS 534 8,000 7,466 93% 5510-460-430840-345 TELEPHONE & COMMUNICATION 312 700 388 55% 5510-460-430840-354 CONTRACT SERVICES 8,363 12,000 3,637 30% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 3,696 4,750 1,054 22% 5510-460-430840-366 BUILDING MAINTENANCE 412 2,500 2,088 84% 5510-460-430840-369 RADIO EQUIPMENT & MAINT. 0 1,700 1,700 100% 5510-460-430840-373 SCHOOL & TRAVEL 168 3,500 3,333 95% 5510-460-430840-388 MEDICAL SERVICES 293 550 258 47% 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 15,167 26,000 10,833 42% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 17,898 30,683 12,785 42% 5510-460-430840-528 DATA PROCESSING TRANSFER 6,501 11,145 4,644 42% 5510-460-430840-532 OFFICE RENT 3,919 7,838 3,919 50% 5510-460-430845-224 JANITORIAL SUPPLIES 0 350 350 100% 5510-460-430845-341 ELECTRICITY 1,479 2,500 1,021 41% 5510-460-430845-342 WATER 176 350 174 50% 5510-460-430845-344 NATURAL GAS 2,027 9,500 7,473 79% 5510-460-430845-360 REPAIR & MAINT SERVICES 351 1,000 649 65% 5510-460-430845-366 BUILDING MAINTENANCE 372 1,000 628 63% 5510-460-510400-831 DEPRECIATION EXPENSE 0 100,000 100,000 100% TOTAL SOLID WASTE EXPENSE 323,762 ----------- ---------- --- 811,668 ----------- ----------- ----------- ---------- 487,906 -------------- -------------------- 60% ------ Page 25 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Quarterly Finance Report As of January 19th 2010 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 5,250 11,000 5,750 52% 5160-000-343063-000 TIE DOWN FEES 1,870 4,000 2,130 53% 5160-000-343069-000 HANGER LEASES 6,053 12,000 5,948 50% 5160-000-343071-000 HANGAR SITE LEASES 15,556 18,600 3,044 16% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 8,232 16,500 8,268 50% 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,324 6,000 2,676 45% 5160-000-371010-000 INVESTMENT EARNINGS 5,506 8,500 2,994 35% TOTAL AIRPORT REVENUE ----------- 56,522 ----------- 90,050 --------------------- 33,528 37% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 19,231 33,797 14,566 43% 5160-430-430310-111 SEASONAL SALARIES 0 3,267 3,267 100% 5160-430-430310-153 HEALTH INSURANCE 2,020 3,030 1,010 33% 5160-430-430310-155 RETIREMENT 1,248 2,406 1,158 48% 5160-430-430310-210 OFFICE SUPPLIES 199 300 101 34% 5160-430-430310-218 NON -CAPITAL EQUIPMENT 270 1,000 730 73% 5160-430-430310-335 MEMBERSHIP & DUES 0 250 250 100% 5160-430-430310-341 ELECTRICITY 584 1,500 916 61% 5160-430-430310-345 TELEPHONE 466 1,000 534 53% 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 0 5,000 5,000 100% 5160-430-430310-360 REPAIRS & MAINTENANCE 678 4,000 3,322 83% 5160-430-430310-362 EQUIPMENT MAINTENANCE 35 1,000 965 96% 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 268 2,000 1,732 87% 5160-430-430310-373 TRAVEL 1,106 2,000 894 45% 5160-430-430310-380 SIGNAGE 284 500 216 43% 5160-430-430310-390 EQUIPMENT RENTAL 810 1,500 690 46% 5160-430-430310-510 PROPERTY INSURANCE 1,992 6,870 4,878 71% 3160-430-430310-522 ADMINISTRATIVE TRANSFER 4,743 8,130 3,388 42% 5160-430-430310-528 DATA PROCESSING 1,750 3,000 1,250 42% 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 40,083 292,122 252,039 86% 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 1,687 2,000 313 16% 6030-000-393000-000 INTERNAL SERVICES -DATA 91,851 161,425 69,574 43% TOTAL DATA PROCESSING REVENUE ----------- 243,769 ----------- 313,925 ----------- ---------- 70,156 22% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 37,418 73,786 36,368 49% 6030-401-410580-153 HEALTH INSURANCE 5,052 9,702 4,650 48% 6030-401-410580-155 RETIREMENT 2,439 4,790 2,351 49% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 208 3,000 2,792 93% 6030-403-410580-215 COMPUTER SUPPLIES 334 3,700 3,366 91% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 9,321 11,000 1,679 15% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 936 24,000 23,064 96% 6030-403-410580-346 SUMMIT NET T1 CONTRACT 1,424 5,000 3,576 72% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,160 3,500 340 10% 6030-403-410580-354 MAINTENANCE CONTRACTS 4,400 6,000 1,600 27% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 10,570 28,850 18,280 63% 6030-403-410580-357 GRANICUS 6,000 13,000 7,000 54% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 2,624 12,000 9,376 78% 6030-403-410580-373 SCHOOL & TRAVEL 900 6,200 5,300 85% 6030-403-410580-510 INSURANCE 1,497 1,675 178 11% 6030-403-410585-229 COPIER,FAX, SUPPLIES 0 6,500 6,500 100% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 31,365 70,000 38,635 55% 6030-403-410585-332 COPIER LEASES 11,933 28,500 16,567 38% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% Page 26 58.33% Yr Complete O1/19/10 CITY OF KALISPELL Page 27 Quarterly Finance Report As of January 19th 2010 58.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 6030-404-410588-218 COMPUTERS - ATTORNEYS 1,197 1,500 303 20% 6030-405-410588-218 COMPUTERS - NON CAPITAL CONTINGENCY 0 5,000 5,000 100% 6030-405-410588-940 COMPUTERS - SERVER / NETWORK ROUTER 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 0 5,000 5,000 100% 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 0 2,000 2,000 100% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 500 500 100% TOTAL DATA ----------- PROCESSING EXPENSE 132,886 ----------- 363,503 --------------------- 230,617 63%