Loading...
4th Quarter Finance ReportCity of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 Date: July 30, 2010 TO: Mayor Fisher and City Council members Jane Howington, City Manager From: Amy Robertson Finance Director RE: 4th Qtr Finance Report - FY2010 Please find attached a printout reflecting activity for the 4th quarter of the fiscal year. This report includes claims paid to date, however, some June bills are still outstanding. Payroll is complete. Page 1 —General Fund Revenue: We have $92,000 in protested taxes (held by the County), an increase of $70,000 from the prior year balance. We also have $198,445 in 2009 delinquent real estate taxes which is about 4% of billed. Total delinquent real estate taxes are $286,856 which is only $3,000 more than prior year delinquent receivables. Pages 2-27 provide expenditures. No funds were over budget which is why we did not have any year end budget amendments this year. 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. The Enterprise funds (water, sewer/storm, garbage, and airport) use full accrual accounting. Debt service payments are made December 31 st and June 30`h. The Principal payments were made June 30`h and posted directly to the Balance Sheet bonds payable liability account. Depreciation expense has not been posted. Depreciation will be calculated when all bills are paid and the capital accounts (900's) are closed to the asset accounts on the Balance Sheet. This report is provided now because once those accounts are closed this report will not reflect any expenditure for capital or construction in the Enterprise funds. The Construction in Progress account will be closed to the asset account for the new Wastewater Treatment Plant. The staff is analyzing the expenses to determine the depreciable life on the various parts — infrastructure, pumps, etc. The public works department must also provide finance with information on developer or county contributions which we need to book. — probably not much this year. The utility fund line items for M & O should be reviewed individually. One item, the amount of money designated for the City/Evergreen replacement account is not an expense but only a reservation of cash an entry will not appear on the budget print out as an expense. This is true of all amounts reserved for replacement. 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. Compensated absences have been booked as of June 30`h. This calculation increases or decreases salary line items in the Enterprise funds to reflect the ongoing liability for vacation and of sick leave owed employees (entry does not affect cash). 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 which are on the more traditional business type accounting. Please call if you have questions — 758-7755 07/30/10 CITY OF KALISPELL Page 1 Quarterly Finance Report June 30, 2010 as of July 30th 100.00% Yr Complete FUND 1000-000-311100-000 1000-000-311105-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-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-342020-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-362015-000 1000-000-364030-000 1000-000-365000-000 1000-000-365001-000 1000-000-365015-000 1000-000-365018-000 1000-000-371010-000 1000-000-381060-000 FUND ------------------------------------ GENERAL FUND - REVENUE REAL PROPERTY TAXES PILT-GL MANOR & TRESURE ST PLAZA 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 CARD TABLE PERMIT HB124 ENTITLEMENT ADMINISTRATIVE CHARGES BOND FEES/ADMIN.CHG. CITY COLLECTIONS BRESNAN FRANCHISE FEES POLICE SERVICES RESOURCE OFFICERS KPD REGIONAL TRAINING FIRE CHG.SPEC.EVENTS/INSTRUCTOR CHG 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 INSURANCE REIMBURSEMENTS SALE OF MISCELLANEOUS/AUCTION DONATIONS KMTC NON-PROFIT DONATIONS CONTRIBUTION FRM KIDSPORT BANDSHELL CONTRIBUTIONS INVESTMENT EARNINGS OPERATING TRANSFER- FUND 2372 TOTAL REVENUE ACTUAL YTD BUDGET REMAINING % 4,168,867 4,226,561 57,694 1% 3,119 0 3,119- 0% 251,077 244,319 6,758- -3% 25,951 25,000 951- -4% 24,594 26,381 1,787 7% 986 1,200 214 18% 350 600 250 42% 62,985 75,000 12,015 16% 340 500 160 32% 7,272 30,000 22,728 76% 16,363 65,000 48,637 75% 975 1,200 225 19% 627 3,000 2,373 79% 2,156 1,844 312- -17% 55,625 60,325 4,700 8% 2,650 3,600 950 26% 2,268,835 2,270,106 1,271 0% 500,463 492,998 7,465- -2% 0 15,500 15,500 100% 28,096 1,500 26,596- -1773% 152,447 155,000 2,553 2% 13,287 20,000 6,713 34% 86,000 86,000 0 0% 14,241 15,000 759 5% 756 0 756- 0% 16,969 17,000 31 0% 0 50,000 50,000 100% 6,650 5,000 1,650- -33% 118,800 118,000 800- -1% 464,594 471,000 6,406 1% 794 4,000 3,206 80% 3,210 1,000 2,210- -221% 28,529 21,000 7,529- -36% 24,843 25,471 628 2% 8,069 0 8,069- 0% 2,365 3,500 1,135 32% 100 0 100- 0% 290 0 290- 0% 42,275 42,000 275- -1% 2,926 0 2, 926- 0% 54,639 85,000 30,361 36% 516,615 516,615 0 0% ----------- 8,979,732 ---------------------- 9,180,220 ---------- 200,488 2% 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th 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,926 3,000 1,074 36% 1000-400-410560-312 POSTAGE 11,559 20,000 8,441 42% 1000-400-410560-320 PRINTING 7,072 6,500 572- -9% 1000-400-410600-354 ELECTIONS 6,444 9,000 2,556 28% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,175 5,000 2,825 57% 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 500 500 0 0% 1000-400-510330-513 LIABILITY INSURANCE 221,618 223,425 1,807 lea 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 15,951 32,000 16,049 50% 1000-400-510330-517 PROPERTY INSURANCE 47,847 48,000 153 0% SUBTOTAL GEN.GOV'T. ----------- 378,857 ----------- 443,960 --------------------- 65,103 15% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 116,830 112,303 4,527- A -4% 1000-401-410210-153 HEALTH INSURANCE 11,003 12,104 1,101 9% 1000-401-410210-155 RETIREMENT 12,092 12,637 545 4% 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 277 600 323 54% 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 399 1,800 1,401 78% 1000-401-410210-379 MEETINGS 249 0 249- 0% SUBTOTAL CITY MANAGER ----------- 157,641 ----------- 164,094 --------------------- 6,453 4% HUMAN RESOURCES 1000-401-410830-110 SALARIES -PERSONNEL 103,195 103,303 108 0% 1000-401-410830-153 HEALTH INSURANCE 13,491 13,495 4 0% 1000-401-410830-155 RETIREMENT 6,726 6,726 0 0% 1000-401-410830-210 OFFICE SUPPLIES 185 350 165 47% 1000-401-410830-215 COMPUTER SUPPLIES 91 350 259 74% 1000-401-410830-218 SMALL OFFICE EQUIP/FURNITURE 59 250 191 76% 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 540 400 140- -35% 1000-401-410830-338 RECRUITMENT/NEGOTIATIONS 2,920 3,500 580 17% 1000-401-410830-345 TELEPHONE 60 150 90 60% 1000-401-410830-354 CONTRACT SERVICES 100 100 0 0% 1000-401-410830-373 SCHOOL & TRAVEL 2,768 3,500 732 21% SUBTOTAL HUMAN RESOURCES ----------- 130,135 ----------- 132,574 --------------------- 2,439 2% Page 2 100.00% Yr Complete 07/30/10 FUND FUND CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th ACTUAL YTD BUDGET REMAINING % MEDIA SPECIALIST 1000-401-410900-110 MEDIA SPECIALIST -salary 1000-401-410900-153 HEALTH INSURANCE 1000-401-410900-155 RETIREMENT 1000-401-410900-218 EQUIPMENT 1000-401-410900-354 CONTRACT SERVICES SUBTOTAL MEDIA SPECIALIST MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 1000-402-410100-153 HEALTH INSURANCE 1000-402-410100-155 RETIREMENT 1000-402-410100-210 Office Supplies 1000-402-410100-335 MEMBERSHIP & DUES 1000-402-410100-345 TELEPHONE & COMMUNICATION 1000-402-410100-373 SCHOOL & TRAVEL 1000-402-410100-379 MEETINGS SUBTOTAL MAYOR/COUNCIL CITY CLERK 1000-402-410150-110 SALARIES/CITY CLERK 1000-402-410150-121 OVERTIME 1000-402-410150-153 HEALTH INSURANCE 1000-402-410150-155 RETIREMENT 1000-402-410150-210 OFFICE SUPPLIES 1000-402-410150-229 OTHER SUPPLIES 1000-402-410150-335 MEMBERSHIP & DUES 1000-402-410150-345 TELEPHONE & COMMUNICATION 1000-402-410150-352 RECODIFICATION 1000-402-410150-354 CONTRACT SERVICES SUBTOTAL CITY CLERK FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 1000-403-410550-121 OVERTIME 1000-403-410550-153 HEALTH INSURANCE 1000-403-410550-155 RETIREMENT 1000-403-410550-322 BOOKS 1000-403-410550-335 MEMBERSHIP & DUES 1000-403-410550-345 TELEPHONE & COMMUNICATION 1000-403-410550-353 CONTRACT SERVICES 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 1000-403-410550-355 BANK CHARGES & FEES 1000-403-410550-373 SCHOOL & TRAVEL SUBTOTAL FINANCE ------------------------------------------ 19,468 20,082 614 3% 7,688 7,689 1 0% 1,308 1,309 1 0% 1,008 1,010 2 0% 2,600 2,500 100- -4% ------------------ 32,072 ----------- 32,590 ---------- 518 2% 62,040 62,527 30,300 30,300 2,647 2,650 7 100 5,756 6,300 7 100 1,488 3,000 162 300 102,407 105,277 487 1% 0 0% 3 0% 93 93% 544 9% 93 93% 1,512 50% 138 46% 2,870 3% 76,328 76,926 598 1% 513 550 37 7% 8,915 9,002 87 1% 4,982 5,028 46 1% 89 150 61 41% 0 50 50 100% 215 275 60 22% 409 400 9- -2% 3,401 3,500 99 3% 0 25 25 100% -------- 94,851 ---------------------- 95,906 ---------- 1,055 1% 191,207 191,836 629 0% 94 100 6 6% 30,627 30,627 0 0% 12,471 12,480 9 0% 254 250 4- -1% 921 1,000 79 8% 55 100 45 45% 295 470 175 37% 1,060 1,500 440 29% 1,780 3,500 1,720 49% 2,116 3,000 884 29% ------------------- 240,878 ----------- 244,863 ---------- 3,985 2% Page 3 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------- CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 306,795 307,794 999 0% 1000-404-411110-153 HEALTH INSURANCE 46,917 46,932 15 0% 1000-404-411110-155 RETIREMENT 20,006 19,922 84- 0% 1000-404-411110-210 OFFICE SUPPLIES 654 1,200 546 45% 1000-404-411110-215 COMPUTER SUPPLIES 2,232 1,500 732- -49% 1000-404-411110-322 BOOKS, CDs, LEXIS 4,508 7,000 2,492 36% 1000-404-411110-335 MEMBERSHIP & DUES 1,710 2,500 790 32% 1000-404-411110-345 TELEPHONE & COMMUNICATION 873 1,200 327 27% 1000-404-411110-354 CONTRACT SERVICES 2,609 5,000 2,391 48% 1000-404-411110-373 SCHOOL & TRAVEL 1,158 2,525 1,367 54% SUBTOTAL CITY ATTORNEY ----------- 387,463 ---------------------- 395,573 ---------- 8,110 2% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 194,271 197,203 2,932 1% 1000-406-410360-121 OVERTIME 76 100 24 24% 1000-406-410360-153 HEALTH INSURANCE 36,023 36,027 4 0% 1000-406-410360-155 RETIREMENT 12,669 12,908 239 2& 1000-406-410360-210 OFFICE SUPPLIES 2,392 1,000 1,392- -139% 1000-406-410360-213 OFFICE EQUIPMENT/MAINT. 1,656 1,000 656- -66% 1000-406-410360-215 COMPUTER SUPPLIES 763 1,000 237 24% 1000-406-410360-229 OTHER SUPPLIES 859 1,500 641 43% 1000-406-410360-320 PRINTING 393 500 107 21% 1000-406-410360-322 BOOKS 1,322 1,250 72- -6% 1000-406-410360-335 MEMBERSHIP & DUES 215 300 85 28% 1000-406-410360-345 TELEPHONE & COMMUNICATION 1,449 1,400 49- -3% 1000-406-410360-353 SECURITY & TECHNOLOGY 5,174 34,750 29,576 85% 1000-406-410360-354 CONTRACT SERVICES 11,542 5,750 5,792- -101% 1000-406-410360-373 SCHOOL & TRAVEL 3,528 6,000 2,472 41% 1000-406-410360-394 JURY & WITNESS FEES 9,092 4,500 4,592- -102% 1000-406-410360-395 DRUG COURT 0 1,000 1,000 100% 1000-406-410360-396 DUI COURT 2,270 0 2,270- 0% SUBTOTAL COURT ---------------------- 283,693 ----------- 306,188 ---------- 22,495 7% DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 10,787 11,624 837 7% 1000-410-430100-153 HEALTH INSURANCE 1,630 1,990 360 18% 1000-410-430100-155 RETIREMENT 697 800 103 13%' 1000-410-430100-210 OFFICE SUPPLIES 548 675 127 19% 1000-410-430100-213 SMALL OFFICE EQUIPMENT 119 150 31 21% 1000-410-430100-215 COMPUTER SUPPLIES 408 250 158- -63% 1000-410-430100-216 COMPUTER EQUIPMEMT/SUPPLIES 767 350 417- -119% 1000-410-430100-229 OTHER SUPPLIES 366 350 16- -5% 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 122 150 28 18% 1000-410-430100-373 SCHOOL & TRAVEL 79 400 321 80% SUBTOTAL ADMINISTRATION ---------------------- 16,402 ----------- 18,389 ---------- 1,987 11% CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 131,615 131,899 284 0% 1000-410-431330-121 OVERTIME 1,643 1,650 7 0% 1000-410-431330-153 HEALTH INSURANCE 25,464 29,106 3,642 13% 1000-410-431330-155 RETIREMENT 8,251 9,297 1,046 11% 1000-410-431330-210 OFFICE SUPPLIES 114 300 186 62% 1000-410-431330-215 COMPUTER SUPPLIES 159 800 641 80% 1000-410-431330-218 EQUIPMENT (non -capital) 256 850 594 70% 1000-410-431330-221 SAFETY EQUIP & SUPPLIES 2,377 150 2,227- -1485% 1000-410-431330-229 OTHER SUPPLIES 5,451 3,500 1,951- -56% 1000-410-431330-231 GAS & OIL 110,140 122,500 12,360 10% Page 4 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 1000-410-431330-232 MOTOR VEHICLE PARTS. 78,639 64,000 14,639- -23% 1000-410-431330-233 TIRES AND RELATED PARTS 22,307 27,000 4,693 17% 1000-410-431330-238 FILTERS & MISC. PARTS 3,714 3,500 214- -6% 1000-410-431330-241 CONSUMABLE TOOLS 485 500 15 3% 1000-410-431330-322 BOOKS 405 150 255- -170% 1000-410-431330-341 ELECTRICITY 1,637 1,700 63 4% 1000-410-431330-342 WATER 164 100 64- -64% 1000-410-431330-344 NATURAL GAS 6,224 9,000 2,776 31% 1000-410-431330-354 CONTRACT SERVICES 64,903 69,100 4,197 6% 1000-410-431330-362 EQUIPMENT MAINTENANCE 117 250 133 53% 1000-410-431330-366 BUILDING MAINTENANCE 382 335 47- -14% 1000-410-431330-373 SCHOOL & TRAVEL 255 600 345 58% 1000-410-431330-388 MEDICAL SERVICES 130 375 246 65% SUBTOTAL CENTRAL GARAGE ----------- 464,829 ----------- 476,662 --------------------- 11,833 2% TOTAL PUBLIC WORKS 481,230 495,051 13,821 3% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 39,718 40,877 1,159 3% 1000-412-411230-121 OVERTIME 0 200 200 100% 1000-412-411230-153 HEALTH INSURANCE 8,653 8,653 0 0% 1000-412-411230-155 RETIREMENT 2,459 2,494 35 1% 1000-412-411230-224 JANITORIAL SUPPLIES 5,108 5,000 108- -2% 1000-412-411230-229 OTHER SUPPLIES 474 750 276 37% 1000-412-411230-241 CONSUMABLE TOOLS 327 800 473 59% 1000-412-411230-341 ELECTRICITY 37,746 41,000 3,254 8% 1000-412-411230-342 WATER 2,693 4,500 1,807 40% 1000-412-411230-344 NATURAL GAS 30,293 43,300 13,007 30% 1000-412-411230-345 TELEPHONE & COMMUNICATION 236 250 14 5% 1000-412-411230-354 CONTRACT SERVICES 14,326 19,000 4,674 25% 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 1,105 4,500 3,395 75% 1000-412-411230-362 EQUIPMENT MAINTENANCE 3,441 5,000 1,559 31% 1000-412-411230-366 BUILDING MAINTENANCE 6,911 25,178 18,267 73% 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 ----------- 270,637 ----------- 318,552 --------------------- 47,915 15% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 255,310 261,253 5,943 2% 1000-420-411020-153 HEALTH INSURANCE 51,797 52,073 276 1% 1000-420-411020-155 RETIREMENT 16,652 16,938 286 2% 1000-420-411020-210 OFFICE SUPPLIES 645 2,500 1,855 74% 1000-420-411020-213 OFFICE EQUIPMENT 0 2,000 2,000 100% 1000-420-411020-215 COMPUTER SUPPLIES/SOFTWARE 3,587 5,000 1,413 28% 1000-420-411020-320 PRINTING 0 500 500 100% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,028 4,000 2,972 74% 1000-420-411020-335 MEMBERSHIP/DUES 1,195 1,300 105 8% 1000-420-411020-345 TELEPHONE 870 900 30 3% 1000-420-411020-354 CONTRACT SERVICES 620 1,350 731 54% 1000-420-411020-373 SCHOOL & TRAVEL 1,953 3,500 1,547 44% TOTAL PLANNING DEPT. ----------- 2,893,522 ----------- 3,085,942 --------------------- 192,420 6% Page 5 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND -------------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % POLICE DEPARTMENT ----------- --------------------- ----------- 1000-413-420140-110 SALARIES -POLICE 1,626,197 1,728,055 101,858 6% 1000-413-420140-112 SALARIES -SEVERANCE 20,958 21,000 42 0% 1000-413-420140-114 SALARY -comptime buyout 5,883 6,500 617 10% 1000-413-420140-121 OVERTIME 79,501 80,000 499 1% 1000-413-420140-123 SPECIAL ASSIGNMENT OVERTIME 19,820 22,500 2,680 12% 1000-413-420140-153 HEALTH INSURANCE 287,091 304,105 17,014 6% 1000-413-420140-155 RETIREMENT 209,953 230,721 20,768 9% 1000-413-420140-210 OFFICE SUPPLIES 2,881 3,000 119 4% 1000-413-420140-215 COMPUTER SUPPLIES 5,581 5,500 81- -1% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 3,467 4,000 533 13% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 5,160 5,000 160- -3% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 6,927 7,000 73 1% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,342 2,000 658 33% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 2,605 5,000 2,395 48% 1000-413-420140-227 AMMO & RELATED SUPPLIES 14,871 15,000 129 1% 1000-413-420140-228 PATROL CAR SUPPLIES 13,834 13,000 834- -6% 1000-413-420140-229 OTHER SUPPLIES 3,625 3,500 125- -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 199 2,000 1,801 90% 1000-413-420140-320 PRINTING 4,932 5,000 68 1% 1000-413-420140-335 MEMBERSHIP & DUES 980 1,000 20 2% 1000-413-420140-345 TELEPHONE & COMMUNICATION 15,086 15,000 86- -1% 1000-413-420140-354 CONTRACT SERVICES 4,623 8,000 3,377 42% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 3,881 3,000 881- -29% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,490 2,000 490- -24% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 18,042 21,500 3,458 16% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 2,004 2,500 496 20% 1000-413-420140-373 SCHOOL & TRAVEL 29,870 26,000 3,870- -15% 1000-413-420140-375 REGIONAL TRAINING 10,561 15,000 4,439 30% 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 3,237 8,000 4,763 60% 1000-413-420140-391 TREATMENT 251 500 250 50% 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 5,000 20,000 15,000 75% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 8,000 8,000 0 0% 1000-413-420141-110 DETECTIVE -SALARIES 309,350 327,330 17,980 5% 1000-413-420141-121 DETECTIVE -OVERTIME 11,373 20,000 8,627 43% 1000-413-420141-153 HEALTH INSURANCE 47,937 54,325 6,388 12% 1000-413-420141-155 DETECTIVE -RETIREMENT 40,023 44,111 4,088 9% 1000-413-420142-110 DISPATCH -SALARIES 311,687 349,487 37,800 11% 1000-413-420142-121 DISPATCH -OVERTIME 14,175 15,000 825 6% 1000-413-420142-153 HEALTH INSURANCE 64,485 73,140 8,655 12% 1000-413-420142-155 DISPATCH -RETIREMENT 21,125 22,586 1,461 6% 1000-413-420142-215 COMPUTER SUPPLIES 1,402 1,700 298 18% 1000-413-420142-234 UNIFORMS 1,641 1,800 159 9% 1000-413-420142-373 SCHOOL & TRAVEL (reimb. 911) 918 6,000 5,082 85% 1000-413-420144-110 SRO SALARIES 110,752 110,806 54 0% 1000-413-420144-153 HEALTH INSURANCE 14,713 14,713 0 0% 1000-413-420144-155 SRO RETIREMENT 14,332 14,356 24 0% 1000-413-420145-354 SHELTER/ANIMAL:VET TREATMENT 150 6,500 6,351 98% SUBTOTAL POLICE DEPT. ----------- 3,414,256 ----------- 3,713,735 --------------------- 299,479 8% Page 6 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Page 7 Quarterly Finance Report June 30, 2010 as of July 30th 100.00% Yr Complete FUND FUND FIRE DEPARTMENT 1000-416-420400-110 FIRE SUPPRESSION -SALARIES 1000-416-420400-112 SALARY -SEVERANCE & comptime buyback 1000-416-420400-113 KELLY DAYS 1000-416-420400-121 OVERTIME 1000-416-420400-153 HEALTH INSURANCE 1000-416-420400-155 RETIREMENT 1000-416-420400-210 OFFICE SUPPLIES 1000-416-420400-213 SMALL OFFICE EQUIPMENT 1000-416-420400-215 COMPUTER SUPPLIES 1000-416-420400-218 Equipment (Non Capital) 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 1000-416-420400-224 JANITORIAL SUPPLIES 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 1000-416-420400-320 PRINTING 1000-416-420400-345 TELEPHONE & COMMUNICATION 1000-416-420400-354 CONTRACT SERVICES 1000-416-420400-358 MT. F/F TESTING CONSORTIUM 1000-416-420400-362 EQUIPMENT MAINTENANCE 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1000-416-420400-373 SCHOOL & TRAVEL 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 1000-416-420440-110 FIRE PREVENTION -SALARIES 1000-416-420440-153 HEALTH INSURANCE 1000-416-420440-155 RETIREMENT 1000-416-420440-210 OFFICE SUPPLIES 1000-416-420440-241 CONSUMABLE TOOLS/UNIFORMS 1000-416-420440-314 PRIVATE HYDRANT RENTAL 1000-416-420440-320 PRINTING 1000-416-420440-322 BOOKS 1000-416-420440-333 SUBSCRIPTION/FIRE CODES 1000-416-420440-335 MEMBERSHIP/DUES 1000-416-420440-345 TELEPHONE/COMMUNICATIONS 1000-416-420440-354 CONTRACT SERVICES 1000-416-420440-373 SCHOOL & TRAVEL 1000-416-420440-379 MEETINGS 1000-416-420440-380 TRAINING MATERIALS 1000-416-420465-322 BOOKS 1000-416-420465-380 TRAINING MATERIALS 1000-416-420470-213 SMALL OFFICE EQUIPMENT 1000-416-420470-218 EQUIPMENT (NOT CAPITAL) 1000-416-420470-224 JANITORIAL SUPPLIES 1000-416-420470-241 CONSUMABLE TOOLS 1000-416-420470-341 ELECTRICITY 1000-416-420470-342 WATER 1000-416-420470-344 NATURAL GAS 1000-416-420470-354 CONTRACT SERVICES 1000-416-420470-362 EQUIPMENT MAINTENANCE 1000-416-420470-366 BUILDING MAINTENANCE SUBTOTAL FIRE DEPT. ACTUAL YTD BUDGET REMAINING % 1,440,621 1,440,731 110 0% 59,264 59,500 236 0% 34,469 40,000 5,531 14% 37,844 38,153 309 1& 246,134 246,175 41 Ors 203,957 206,254 2,297 1% 358 850 492 58% 946 200 746- -373% 85 500 415 83% 3,913 5,000 1,087 22% 8,434 11,000 2,566 23% 703 700 3- 0% 7,782 10,000 2,218 22% 92 200 108 54% 4,965 6,000 1,035 17% 874 5,000 4,126 83% 800 1,000 200 20% 4,612 5,000 388 8% 15,330 15,500 170 1% 882 1,500 618 41% 51,550 51,550 0 0% 16,473 16,475 2 0% 70,001 70,890 889 1% 12,199 13,186 987 7% 7,032 9,574 2,542 27% 547 500 47- -9% 1,522 1,000 522- -52% 0 5,500 5,500 100% 366 500 134 27`& 152 500 348 70% 217 500 283 57% 424 250 174- -70% 3,117 2,500 617- -25% 1,755 1,000 755- -76% 1,168 1,000 168- -17% 139 500 361 72% 464 500 36 7% 0 500 500 100% 1,242 2,000 759 38% 18 200 182 91% 1,961 2,500 539 22% 792 750 42- -6% 210 400 190 48% 8,348 10,000 1,652 17% 2,184 2,800 616 22% 8,404 15,000 6,596 44% 1,029 2,000 971 49% 1,340 1,500 160 11% 4,084 1,500 2,584- -172% ----------- 2,268,802 ---------------------- 2,308,338 ---------- 39,536 2% GRAND TOTAL GENERAL FUND 5,683,058 6,022,073 339,015 6% 07/30/10 FUND --------------------- 2185-000-430300-353 2185-000-430300-356 2185-000-430300-522 2185-000-430300-840 2185-436-460430-218 2185-436-460430-934 2185-480-470240-110 2185-480-470240-153 2185-480-470240-155 2188-436-460430-930 2188-453-430246-950 2188-453-430246-951 2188-453-430246-952 2188-453-430246-953 2188-453-430246-955 2188-480-470230-110 2188-480-470230-153 2188-480-470230-155 2188-480-470230-353 2188-480-470230-354 2188-480-470230-356 2188-480-470230-522 2188-480-470230-955 2210-436-460430-826 2210-436-460430-934 2210-436-460430-935 2210-436-460430-937 2215-000-311100-000 2215-000-311200-000 2215-000-312000-000 2215-000-334110-000 2215-000-346030-000 2215-000-346040-000 2215-000-346050-000 2215-000-346051-000 2215-000-346052-000 2215-000-346053-000 2215-000-346054-000 2215-000-346055-000 2215-000-346057-000 2215-000-346059-000 2215-000-364030-000 2215-000-365010-000 2215-000-371010-000 2215-000-381060-000 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND ------------------------ SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF AUDITING REDEVELOPMENT / CONTRACT SERVICES ADMINISTRATIVE TRANSFER REDEVELOPMENT CONTIGENCY LAKER'S BALLFIELD IMPROVEMENTS BEGG PARK IMPROVEMENTS SALARIES HEALTH INSURANCE RETIREMENT TOTAL AIRPORT TIF 2188 WESTSIDE TIF GREENBRIAR PARK IMPROVEMENTS GLENWOOD DR STORMDRAIN CONST PAVING LOWER SPRING CREEK 3 MILE DR ROAD DESIGN US 93 BYPASS CONST SALARIES HEALTH INSURANCE RETIREMENT AUDIT TO PORT/GATEWAY W. BLDG MAINT. REDEVELOPMENT / CONTRACT SERVICES ADMINISTRATIVE TRANSFER CD -REDEVELOPMENT ACTIVITY TOTAL WESTSIDE TIF 2210 PARKS IN LIEU TRANSFER TO ISTEA FUND CAPITAL IMPROVEMENTS SUNSET BASKETBALL COURT WESTVIEW IMPROVEMENTS TOTAL PARKS IN LIEU 2215 NEW PARKS & REC. FUND REVENUE: REAL PROPERTY TAXES PERSONAL PROPERTY TAXES PEN & INTEREST DEL TAXES DEPT PUBLIC HEALTH AFTER SCHOOL GRT SWIMMING POOL FEES CONCESSION STAND REVENUE Parks Usage Fees RECREATION FEES SPORTS PROGRAMS SCHOLARSHIPS (DONATIONS) AFTER SCHOOL PROGRAMS ICE RINK YOUTH CAMPS PICNIC IN THE PARK MISC REV/RESTITU,INS,AUCTION DONATION/FERTILIZER INVESTMENT EARNINGS HEALTH INSURANCE TRANSFER TOTAL PARKS & REC REVENUE PARKS & REC. EXPENDITURES PARKS DEPARTMENT: ACTUAL YTD BUDGET REMAINING % 750 1,200 450 38% 17,302 15,000 2,302- -15% 13,554 13,554 0 0% 0 800,000 800,000 100% 7,446 10,000 2,554 26% 41,673 42,142 469 1% 43,536 49,113 5,577 11% 3,939 5,143 1,204 23% 3,112 3,188 76 2% ----------- 131,312 ----------- 939,340 --------------------- 808,028 86% 18,099 18,180 81 0% 68,204 135,000 66,796 49% 29,517 30,000 483 2% 3,846 40,000 36,154 90% 92,917 146,926 54,009 37% 126,296 225,884 99,588 44% 6,596 8,500 1,904 22% 682 1,000 318 32% 429 500 71 14% 375 750 375 50% 5,300 5,000 300- -6% 3,747 25,000 21,253 85% 25,000 25,000 0 0% 0 ----------- 1,500,000 ----------- 1,500,000 ----------- 100% 381,007 2,161,740 ---------- 1,780,733 82% 0 30,000 30,000 100% 0 5,000 5,000 100% 0 5,500 5,500 100% 20,000 17,500 2,500- -14% ----------- 20,000 ----------- 58,000 --------------------- 38,000 66% 802,686 850,000 47,314 6% 173 0 173- 0% 878 0 878- 0% 5,000 5,000 0 0% 127,733 160,000 32,267 20% 31,456 35,000 3,544 10% 19,993 18,000 1,993- -11% 9,895 15,000 5,105 34% 40,019 40,000 19- 0% 4,415 3,000 1,415- -47% 25,848 33,500 7,652 23% 10,221 25,000 14,779 59% 62,246 85,000 22,754 27% 26,764 33,000 6,236 19% 1,483 0 1,483- 0% 600 0 600- 0% 175 0 175- OAS 60,000 ----------- 60,000 0 0% 1,229,586 ----------- 1,362,500 --------------------- 132,914 10% Page 8 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2215-436-460430-110 SALARIES -PARKS 236,308 263,573 27,265 10% 2215-436-460430-111 SEASONAL SALARIES 23,919 30,546 6,627 22% 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 54,096 54,803 707 1% 2215-436-460430-155 RETIREMENT 17,953 18,364 411 2% 2215-436-460430-210 OFFICE SUPPLIES 649 1,200 551 46% 2215-436-460430-213 SMALL OFFICE EQUIPMENT 0 800 800 100% 2215-436-460430-215 COMPUTER SUPPLIES 203 1,000 797 80% 2215-436-460430-221 SAFETY EQUIPMENT 365 950 585 62% 2215-436-460430-224 JANITORIAL SUPPLIES 2,309 3,000 691 23% 2215-436-460430-229 OTHER SUPPLIES 2,331 6,000 3,669 61% 2215-436-460430-241 CONSUMABLE TOOLS/SMALL EQUIPMENT 1,390 1,600 210 13% 2215-436-460430-320 PRINTING 0 456 456 100% 2215-436-460430-333 SUBSCRIPTIONS 209 250 41 16% 2215-436-460430-335 MEMBERSHIP & DUES 355 450 95 21% 2215-436-460430-337 ADVERTISING 45 500 455 91% 2215-436-460430-341 ELECTRICITY 14,437 14,250 187- -1% 2215-436-460430-342 WATER/SEWER 0 400 400 100% 2215-436-460430-344 NATURAL GAS 3,130 3,200 70 2% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 2,954 3,000 46 2% 2215-436-460430-353 CONTRACT SERVICES 22 0 22- 0% 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 624 1,500 877 58% 2215-436-460430-364 LANDSCAPING 3,380 3,000 380- -13% 2215-436-460430-366 BUILDING MAINTENANCE 59 4,000 3,941 99% 2215-436-460430-367 VANDALISM REPAIRS 2,501 4,000 1,499 37% 2215-436-460430-373 SCHOOL & TRAVEL 1,140 1,200 60 5% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 284 550 266 48% 2215-436-460430-395 EQUIPMENT RENTAL 40 500 460 92% 2215-436-460430-420 METAL PRODUCTS/FENCING 440- 1,500 1,940 129% 2215-436-460430-430 WOOD PRODUCTS/PICNIC TABLES 537 2,000 1,463 73% 2215-436-460430-440 IRRIGATION SUPPLIES 2,329 4,000 1,671 42% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 475 4,000 3,525 88% 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 ----------- 402,889 ----------- 459,032 --------------------- 56,143 12% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 45,902 46,179 277 1% 2215-436-460440-111 SEASONAL SALARIES 43,664 43,360 304- -1% 2215-436-460440-153 HEALTH INSURANCE 13,204 13,204 0 0% 2215-436-460440-155 RETIREMENT 3,620 3,641 21 1% 2215-436-460440-221 SAFETY EQUIPMENT 0 175 175 100% 2215-436-460440-229 OTHER SUPPLIES 14,555 16,900 2,345 14% 2215-436-460440-241 CONSUMABLE TOOLS 360 700 340 49% 2215-436-460440-335 MEMBERSHIP & DUES 0 135 135 100% 2215-436-460440-341 ELECTRICITY 3,000 3,413 413 12% 2215-436-460440-345 TELEPHONE & COMMUNICATION 331 350 19 5& 2215-436-460440-354 CONTRACT SERVICES 831 1,000 169 17% 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,888 3,000 112 4% 2215-436-460440-452 SAND & GRAVEL 268 1,200 932 78% TOTAL ATHLETIC COMPLEX ----------- 128,922 ----------- 136,707 --------------------- 7,785 6% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 87,789 88,750 961 1% 2215-436-460431-111 SEASONAL SALARIES 11,629 13,704 2,075 15% 2215-436-460431-121 OVERTIME 0 500 500 100% 2215-436-460431-153 HEALTH INSURANCE 17,204 17,204 0 0% Page 9 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Page 10 Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % 2215-436-460431-155 RETIREMENT 10,123 5,475 4,648- -85% 2215-436-460431-210 OFFICE SUPPLIES 522 600 78 13% 2215-436-460431-229 OTHER SUPPLIES 9,782 10,000 218 2% 2215-436-460431-320 PRINTING 5,837 6,000 163 3% 2215-436-460431-333 SUBSCRIPTIONS 0 100 100 100% 2215-436-460431-335 MEMBERSHIP & DUES 270 300 30 10% 2215-436-460431-337 ADVERTISING 150 500 350 70% 2215-436-460431-345 TELEPHONE & COMMUNICATION 972 1,300 328 25% 2215-436-460431-354 CONTRACT SERVICES 18,796 25,000 6,204 25% 2215-436-460431-355 BANK FEES/CREDIT CARD FEES 1,568 2,500 932 37% 2215-436-460431-373 SCHOOL & TRAVEL 831 ----------- 1,200 369 31% TOTAL RECREATION 165,473 ----------- 173,133 --------------------- 7,660 4% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 65,003 65,238 235 0% 2215-436-460448-111 SEASONAL SALARIES 68,992 88,749 19,757 22% 2215-436-460448-121 OVERTIME 0 500 500 100% 2215-436-460448-153 HEALTH INSURANCE 16,234 16,234 0 0% 2215-436-460448-155 RETIREMENT 4,409 5,244 835 16% 2215-436-460448-210 OFFICE SUPPLIES 164 500 336 67% 2215-436-460448-229 OTHER SUPPLIES 2,229 6,000 3,771 63% 2215-436-460448-320 PRINTING 126 300 174 58% 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 13,043 13,000 43- 0% 2215-436-460448-355 AFTER SCHOOL PROGRAM 1,754 4,000 2,246 56% 2215-436-460448-366 BUILDING MAINTENANCE 225 5,000 4,775 96% 2215-436-460448-373 SCHOOL & TRAVEL 790 1,000 210 21% TOTAL YOUTH CAMPS ----------- 172,968 ----------- 206,965 --------------------- 33,998 16% 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-229 OTHER SUPPLIES 0 350 350 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 178,645 201,359 22,714 11% 2215-437-460445-121 OVERTIME 907 500 407- -81% 2215-437-460445-155 RETIREMENT 1,798 1,266 532- -42% 2215-437-460445-210 OFFICE SUPPLIES 254 500 246 49% 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 2,272 2,500 228 9% 2215-437-460445-226 CHLORINE/CHEMICALS 21,984 16,500 5,484- -33% 2215-437-460445-228 CONCESSION STAND SUPPLIES 18,208 18,500 292 2% 2215-437-460445-229 OTHER SUPPLIES 4,447 4,500 53 1% 2215-437-460445-241 CONSUMABLE TOOLS 334 400 66 17% 2215-437-460445-320 PRINTING 0 50 50 100% 2215-437-460445-341 ELECTRICITY 9,510 12,500 2,990 24% 2215-437-460445-344 NATURAL GAS 17,053 28,000 10,947 39% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,252 1,500 248 17% 2215-437-460445-354 LICENSES & FEES 1,030 1,300 270 21% 2215-437-460445-362 EQUIPMENT MAINTENANCE 3,770 4,000 230 6% 2215-437-460445-366 BUILDING MAINTENANCE 1,172 1,500 328 22% 2215-437-460445-380 TRAINING MATERIALS 247 250 3 1% TOTAL POOL EXPENDITURES ----------- 262,900 ---------------------- 295,525 ---------- 32,625 11% TOTAL PARKS & RECREATION/POOL 1,160,370 1,315,977 155,607 12% 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Page 11 Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 627,472 765,000 137,528 18% 2230-000-342052-000 OUT OF CITY SURCHARGE 190 0 190- 0% 2230-000-342070-000 COUNTY EMS LEVY 95,967 90,000 5,967- -7% 2230-000-371010-000 INTEREST EARNINGS 624 0 624- 0% TOTAL AMBULANCE REVENUE ----------- 724,253 ----------- 855,000 --------------------- 130,747 15% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 350,779 475,779 125,000 26% 2230-440-420730-113 KELLY DAYS 4,060 10,000 5,940 59% 2230-440-420730-121 OVERTIME 6,199 6,038 161- -3% 2230-440-420730-153 HEALTH INSURANCE 61,748 79,149 17,401 22% 2230-440-420730-155 RETIREMENT 44,915 60,444 15,529 26% 2230-440-420730-210 OFFICE SUPPLIES 536 1,000 464 46% 2230-440-420730-213 SMALL OFFICE EQUIPMENT 475 200 275- -137% 2230-440-420730-215 COMPUTER SUPPLIES 459 2,000 1,541 77% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 1,875 2,000 125 6% 2230-440-420730-231 GAS AND OIL 6,881 10,000 3,119 31% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 3,143 5,000 1,857 37% 2230-440-420730-312 POSTAGE 1,987 3,000 1,013 34% 2230-440-420730-320 PRINTING 295 500 205 41% 2230-440-420730-345 TELEPHONE & COMMUNICATION 923 700 223- -32% 2230-440-420730-353 AUDITING 625 500 125- -25% 2230-440-420730-354 CONTRACT SERVICES/RECERT. 5,243 8,000 2,757 34% 2230-440-420730-358 MT FF TESTING CONSORTIUM 0 500 500 100% 2230-440-420730-359 CC FEES/COLLECTION SERV. 1,293 500 793- -159% 2230-440-420730-362 EQUIPMENT MAINTENANCE 3,751 3,500 251- -7% 2230-440-420730-369 RADIO MAINTENANCE 436 2,500 2,064 83% 2230-440-420730-380 TRAINING MATERIALS 2,120 3,000 880 29% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 5,393 5,000 393- -8% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 40,192 38,000 2,192- -6% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 13,703 17,134 3,432 20% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 8,000 8,000 0 0% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 36,078 36,078 0 0% 2230-440-420730-528 DATA PROCESSING TRANSFER 11,145 11,145 0 0% 2230-440-420730-940 EQUIPMENT 0 7,500 7,500 100% 2230-440-420730-943 AMBULANCE 0 30,000 30,000 100% 2230-440-420730-944 VEHICLES 7,500 0 7,500- 0% TOTAL AMBULANCE FUND ---------------------- 619,753 ----------- 827,167 ---------- 207,414 25% 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 175,470 150,000 25,470- -17% 2394-000-323103-000 PLUMBING PERMITS 14,188 22,500 8,312 37% 2394-000-323104-000 MECHANICAL PERMITS 21,665 30,000 8,336 28% 2394-000-323107-000 HOUSE MOVING PERMITS 600 100 500- -500% 2394-000-323108-000 PLAN REVIEW FEES 57,808 120,000 62,192 52% 2394-000-343380-000 PUBLIC SAFETY BLDG CONTRACT MGMT 195 0 195- 0% 2394-000-371010-000 INVESTMENT EARNINGS 490 2,000 1,510 76% TOTAL REVENUE ---------------------- 270,415 ----------- 324,600 ---------- 54,185 17% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 213,114 253,056 39,942 16% 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 42,026 44,987 2,961 7% 2394-420-420530-155 RETIREMENT 13,392 15,993 2,601 16% 2394-420-420530-210 OFFICE SUPPLIES 946 2,000 1,054 53% 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,807 2,500 693 28% 2394-420-420530-312 POSTAGE 543 600 57 9% 2394-420-420530-320 PRINTING 117 300 183 61% 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Page 12 Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % 2394-420-420530-322 BOOKS 2,554 2,250 304- -14% 2394-420-420530-323 ST. ED. ASSESSMENTS 723 2,500 1,777 71% 2394-420-420530-331 PUBLICATION & FILING FEES 0 200 200 100% 2394-420-420530-335 MEMBERSHIP & DUES 255 900 645 72% 2394-420-420530-345 TELEPHONE & COMMUNICATION 1,223 1,500 277 18% 2394-420-420530-353 AUDITING 0 3,000 3,000 100% 2394-420-420530-354 CONTRACT SERVICES 1,082 500 582- -116% 2394-420-420530-366 BUILDING MAINTENANCE 18 800 782 98% 2394-420-420530-373 SCHOOL & TRAVEL 1,578 5,000 3,422 68% 2394-420-420530-510 PROPERTY INSURANCE 6,947 8,800 1,853 21% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 600 600 0 0% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 12,353 12,353 0 0% 2394-420-420530-528 DATA PROCESSING TRANSFER 4,179 4,179 0 0% TOTAL BUILDING DEPT. ----------- 304,779 ----------- 372,268 --------------------- 67,489 18% 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 500 500 0 0% 2399-413-420140-940 POLICE EQUIPMENT 0 20,000 20,000 100% 2399-416-420400-354 IMPACT FEE REVIEW 500 500 0 0% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 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 ----------- 43,245 ----------- 228,160 --------------------- 184,915 81% 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 25,456 30,182 4,726 16% 2400-410-430263-153 HEALTH INSURANCE 6,171 7,922 1,751 22% 2400-410-430263-155 RETIREMENT 1,580 1,833 253 14% 2400-410-430263-244 STREET LIGHT SUPPLIES 6,468 13,000 6,532 50% 2400-410-430263-341 ELECTRICITY 145,426 145,000 426- 0% 2400-410-430263-360 REPAIR & MAINT SERVICES 10,928 28,000 17,072 61% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 7,677 7,677 0 0% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 0 14,000 14,000 100% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 341 560 219 39% TOTAL LIGHT MAINT. ---------------------- 204,048 ----------- 248,174 ---------- 44,126 18% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 30,035 44,000 13,965 32% 2420-421-430234-957 ALLEY PAVING 25,330 25,000 330- -1% 2420-421-430240-231 GAS & OIL 22,224 35,000 12,776 37% 2420-421-430240-344 NATURAL GAS 6,817 2,500 4,317- -173% 2420-421-430240-354 CONTRACT SERVICES 50,338 100,000 49,663 50% 2420-421-430240-360 REPAIR & MAINT SERVICES 1,520 17,000 15,480 91% 2420-421-430240-368 OVERLAY/CHIPSEALS 250,000 250,000 0 0% 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. 1,245 5,000 3,755 75% 2420-421-430240-471 DE-ICER/ROAD OIL 37,935 50,000 12,065 24% 2420-421-430240-472 ASPHALT 32,019 25,000 7,019- -28% 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 ---------------------- 462,243 ----------- 568,700 ---------- 106,457 19% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 537,563 574,524 36,961 6% 2500-421-430240-112 RETIREMENT -severance 4,588 0 4,588- 0% 2500-421-430240-121 OVERTIME 19,808 30,000 10,192 34% 2500-421-430240-153 HEALTH INSURANCE 107,860 109,112 1,252 1% 2500-421-430240-155 RETIREMENT 34,921 35,243 322 1% 2500-421-430240-213 SMALL OFFICE EQUIPMENT 230 500 270 54% 2500-421-430240-216 COMPUTER EQUIPMENT 2,646 1,850 796- -43% 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Page 13 Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % 2500-421-430240-218 EQUIPMENT (NON CAPITAL) 440 1,000 560 56% 2500-421-430240-221 SAFETY EQUIPMENT 1,811 1,000 811- -81% 2500-421-430240-224 JANITORIAL SUPPLIES 727 700 27- -4% 2500-421-430240-229 OTHER SUPPLIES 1,244 1,200 44- -4% 2500-421-430240-231 GAS & OIL 22,776 40,000 17,224 43% 2500-421-430240-241 CONSUMABLE TOOLS 1,913 2,000 87 4% 2500-421-430240-341 ELECTRICITY 1,222 700 522- -75% 2500-421-430240-342 WATER/SEWER CHARGES 164 150 14- -9% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 954 1,200 246 20% 2500-421-430240-354 CONTRACT SERVICES 8,933 13,000 4,067 31% 2500-421-430240-355 CONTRACT SERV.-AERIAL MAPPING 127 13,000 12,873 99% 2500-421-430240-357 RATE STUDY 16,034 22,500 6,466 29% 2500-421-430240-358 IMPACT FEE STUDY 0 7,000 7,000 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 23,551 22,000 1,551- -7% 2500-421-430240-366 BUILDING MAINTENANCE 1,163 1,500 337 22% 2500-421-430240-369 RADIO EQUIPMENT & MAINT. 5,550 5,000 550- -11% 2500-421-430240-373 SCHOOL & TRAVEL 1,081 3,500 2,419 69% 2500-421-430240-388 MEDICAL SERVICES 1,602 900 702- -78% 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 63,000 63,000 0 0% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 50,339 50,339 0 0% 2500-421-430240-528 DATA PROCESSING TRANSFER 11,145 11,145 0 0% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 1,430 12,727 11,297 89% 2500-421-430240-840 MACI GRANT MATCH 29,563 30,000 437 1% 2500-421-430240-935 PAVEMENT MAINTENANCE funds 407,080 585,988 178,908 31% 2500-421-430240-940 MACHINERY & EQUIPMENT 0 170,000 170,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 70,177 70,000 177- 0% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 6,296 37,337 31,041 83% 2500-421-430264-110 TSS - SALARIES 137,547 140,245 2,698 2% 2500-421-430264-121 OVERTIME 9,025 8,000 1,025- -13% 2500-421-430264-153 HEALTH INSURANCE 16,971 19,722 2,751 14% 2500-421-430264-155 RETIREMENT 9,045 8,781 264- -3% 2500-421-430264-216 COMPUTER EQUIP & SOFTWARE 257 1,500 1,243 83% 2500-421-430264-218 EQUIPMENT(non-capital) 3,602 3,600 2- 0% 2500-421-430264-221 SAFETY EQUIPMENT & SUPPLIES 704 500 204- -41% 2500-421-430264-224 JANITORIAL SUPPLIES 630 650 20 3% 2500-421-430264-229 OTHER SUPPLIES 410 800 390 49% 2500-421-430264-241 CONSUMABLE TOOLS 1,431 1,100 331- -30% 2500-421-430264-242 STREET SIGNS 39,252 35,000 4,252- -12% 2500-421-430264-243 TRAFFIC SIGNALS 1,656 10,000 8,344 83% 2500-421-430264-245 BARRICADE MATERIALS 4,646 4,000 646- -16% 2500-421-430264-341 ELECTRICITY 7,888 11,000 3,112 28% 2500-421-430264-345 COMMUNICATIONS 719 800 81 10% 2500-421-430264-354 CONTRACT SERVICES 5,963 10,000 4,037 40% 2500-421-430264-362 EQUIPMENT MAINTENANCE 1,603 1,400 203- -15% 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,434 3,500 2,066 59% 2500-421-430264-428 PAINT MATERIALS 6,412 25,000 18,588 74% 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,768,502 ---------------------- 2,303,226 ---------- 534,724 23% 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 119,502 131,520 12,018 9% 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 21,487 25,066 3,579 14% 2600-436-460433-155 RETIREMENT 7,726 8,236 510 6% 2600-436-460433-210 OFFICE SUPPLIES 0 50 50 100% 2600-436-460433-229 OTHER SUPPLIES 422 500 78 16% 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 481 1,500 1,019 68% 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 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% 2600-436-460433-362 EQUIPMENT MAINTENANCE 271 500 229 46% 2600-436-460433-364 LANDSCAPING & TREES 6,816 7,000 184 3% 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 2,500 2,500 0 0% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 6,813 6,813 0 0% 2600-436-460433-528 DATA PROCESSING TRANSFER 1,393 1,393 0 0% TOTAL URBAN FORESTRY ----------- 178,082 ----------- 206,748 --------------------- 28,666 14% 2602 ARRA FORESTRY GRANT 2602-436-460433-354 CONTRACT SERVICES 80,440 ----------- 93,500 ----------- 13,061 14% TOTAL ARRA FORESTRY GRANT 80,440 93,500 --------------------- 13,061 14% 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 15,000 15,000 0 0% TOTAL LOAN REVOLVING ----------- 40,787 ----------- 190,776 ----------- ---------- 149,989 79% 2886 UDAG FUND 2886-480-470210-110 SALARIES - UDAG 62,396 95,074 32,678 34% 2886-480-470210-153 HEALTH INSURANCE 6,742 11,769 5,027 43% 2886-480-470210-155 RETIREMENT 4,067 6,619 2,552 39% 2886-480-470210-210 OFFICE SUPPLIES 56 500 444 89% 2886-480-470210-211 GRANT ADMIN. EXPENSES 0 1,000 1,000 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 704 1,000 297 30% 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 191 300 109 36% 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 500 500 0 0% 2886-480-470210-335 MEMBERSHIP & DUES 649 700 51 7% 2886-480-470210-345 TELEPHONE & COMMUNICATION 215 750 535 71% 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 2,370 3,000 630 21% 2886-480-470210-379 MEETINGS 157 500 343 69% 2886-480-470210-381 TRAINING 483 1,500 1,017 68% 2886-480-470210-396 STUDIES/SURVEYS 7,969 25,000 17,031 68% 2886-480-470210-510 PROPERTY & LIABILITY INS. 2,660 4,200 1,540 37% 2886-480-470210-521 CENTRAL GARAGE TRANSFER 0 500 500 100% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 10,451 10,451 0 0% 2886-480-470210-528 DATA PROCESSING TRANSFER 8,359 8,359 0 0% 2886-480-470210-532 OFFICE RENT 4,703 4,703 0 0% 2886-480-470210-710 LAND TRUST DONATION 18,000 18,000 0 Ora 2886-480-470210-711 HISTORIC PRESERVATION PROJECT 17,884 19,000 1,116 6% 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 2,500 2,500 100% TOTAL UDAG FUND ----------- 151,890 ----------- 228,660 --------------------- 76,770 34% Page 14 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------- RURAL DEVELOPMENT REVOLVING 2887-480-470210-110 SALARIES 28,875 38,307 9,432 25% 2887-480-470210-153 HEALTH INSURANCE 3,788 6,060 2,273 38% 2887-480-470210-155 RETIREMENT 1,879 2,476 597 24% 2887-480-470210-610 DEBT SERVICE/PAIN-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 56,662 218,918 ---------- 162,256 74% 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 137 45,000 44,863 100% TOTAL 2888 RURAL DEV. #2 ---------------------- 2,712 ----------- 47,575 ---------- 44,863 94% 2944 CDBG-ED FVCC 2944-480-470242-355 ADMIN CHARGE 2944-480-470242-780 TRANING COSTS-FVCC GRT 2944-480-470242-790 MACHINERY/EQUIPMENT-FVCC GRT TOTAL 2944 CDBG-ED FVCC 2953 EPA BROWNSFIELD GRANT 2953-480-470210-780 SITE ASSESSMENT GRANT EXPENSE TOTAL EPA BROWNSFIELD GRANT 0 3,428 3,428 100% 0 72,000 72,000 100% 0 ----------- 6,090 ----------- 6,090 100% 0 81,518 --------------------- 81,518 100% 3,848 400,000 396,152 99% ---------------------- 3,848 400,000 --------------------- 396,152 99% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 39,091 49,387 10,296 21% 2916-413-420140-121 OVERTIME 6,150 11,000 4,850 44% 2916-413-420140-153 HEALTH INSURANCE 3,535 13,204 9,669 73% 2916-413-420140-155 RETIREMENT 5,191 6,655 1,464 22% 2916-413-420140-210 OFFICE SUPPLIES 0 400 400 100% 2916-413-420140-354 CONTRACT SERVICES 2,693 4,000 1,307 33% ----------- TOTAL 2916 DRUG ENFORCEMENT ----------- 56,660 84,646 --------------------- 27,986 33% 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 15,711 51,388 35,677 69% 2918-413-420140-153 HEALTH INSURANCE 1,515 13,204 11,689 89% 2918-413-420140-155 RETIREMENT 2,105 6,655 4,550 68% ----------- TOTAL 2918 COPS HIRING GRANT ----------- 19,331 ----------- 71,247 ---------- 51,916 73% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - DISPATCH 7,818 4,000 3,818- -95% 2919-413-420140-121 OVERTIME - DISPATCH 10,158 0 10,158- 0% 2919-413-420140-125 DUI TASK FORCE 3,809 10,000 6,191 62% 2919-413-420140-126 HOLIDAY OT REIMB. 51,222 40,000 11,222- -28% 2919-413-420140-127 SCHOOL DIST. OT 16,302 20,000 3,698 18% 2919-413-420140-155 RETIREMENT 1,614 4,000 2,386 60% 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 Bullet Proof Vests 13,092 5,600 7,492- -134% 2919-413-420140-944 VEHICLES ----------- 32,449 ----------- 35,500 ----------- 3,051 ---------- 9% Page 15 100.00% Yr Complete 07/30/10 FUND FUND ----------------------------------------- TOTAL LAW ENF. GRANT CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th ACTUAL YTD BUDGET ------------------------------------- 154,848 161,195 REMAINING % ---------------------- 6,347 4% 2921 DRUG COURT GRANT 2921-406-410360-354 DRUG COURT -contract services 22,196 348,473 326,277 94% ----------- TOTAL DRUG COURT GRANT 22,196 ----------- 348,473 --------------------- 326,277 94% 2950 DOM. VIOLENCE COMPLIANCE 2950-406-410360-354 DOMESTIC VIOLENCE GT-contract serv. 10,465 23,317 12,852 55% ----------- TOTAL DOM. VIOLENCE COMPLIANCE 10,465 ----------- 23,317 --------------------- 12,852 55% 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 94,212 105,000 10,788 10% ----------- TOTAL DUI COURT GRANT ----------- 138,065 ----------- 179,083 ---------- 41,018 23% 2957 FEMA GRANT 2957-416-420400-110 SALARIES 2957-416-420400-121 OVERTIME 2957-416-420400-153 HEALTH INSURANCE 2957-416-420400-155 RETIREMENT 2957-416-420400-218 EQUIPMENT (non capital) 2957-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2957-416-420400-229 HAZMAT REIMB.-MATERIALS 2957-416-420400-373 TRAVEL - REIMBURSABLE 2957-416-420410-125 PASS THRU HAZMAT OT 2957-416-420410-218 PASS THRU HAZMAT EQUIP 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 2957-416-420413-940 AFG REGIONAL CAD SYSTEM 2957-416-420414-218 AFG EQUIPMENT AND SAFETY($137,000) 2957-416-420415-940 HERITAGE PROGRAM GRANT (carryover) 2957-416-420420-126 WILDLAND FIRE OT 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 675 10,000 9,325 93% 0 15,000 15,000 100% 0 1,564 1,564 100% 1,431 1,436 5 0% 13,450 19,768 6,318 32% 4,669 6,000 1,331 22% 0 6,000 6,000 100% 0 20,000 20,000 100% 11,679 20,000 8,321 42% 4,297 31,125 26,828 86% 6,102 5,000 1,102- -22% 915,878 915,876 2- 0% 0 120,000 120,000 100% 8,265 8,207 58- -1% 0 130,000 130,000 100% ----------- 966,445 ---------------------- 1,309,976 ---------- 343,531 26% 98,334 299,000 200,666 67% --------------------------------------- 98,334 299,000 200,666 67% 0 342,000 342,000 100% ------------------------------------------- 0 342,000 342,000 100% 8,195 96,700 88,505 92% ------------------------------------------- 81195 96,700 88,505 92; Page 16 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th 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 TIE 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 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- ENTERPRISE FUNDS WATER REVENUE 5210-000-331158-000 STATE BYPASS RELOCATION REIMB. 134,263 230,154 95,891 42% 5210-000-343210-000 METERED WATER SALES 2,461,049 2,400,000 61,049- -3% 5210-000-343220-000 UNMETERED WATER SALES 19,593 4,000 15,593- -390% 5210-000-343225-000 IMPACT FEES 256,305 300,000 43,695 15% 5210-000-343230-000 METER REPLACEMENT FEE 94,952 90,000 4,952- -6% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 2O,048 25,000 4,952 20% 5210-000-343265-000 LATECOMER ADMIN FEES 5,110 4,000 1,110- -28% 5210-000-343270-000 WATER TURN ON FEES 3,405 3,000 405- -14% 5210-000-343275-000 TAG FEE 20,365 18,000 2,365- -13% 5210-000-371010-000 INVESTMENT EARNINGS 78,701 90,000 11,299 13% TOTAL WATER REVENUE ----------- 3,093,790 ----------- 3,164,154 ----------- 70,364 ---------- 2% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 684,980 717,372 32,392 5% 5210-447-430550-121 OVERTIME 17,695 20,500 2,805 14% 5210-447-430550-153 HEALTH INSURANCE 126,546 156,754 30,208 19% 5210-447-430550-155 RETIREMENT 43,619 45,079 1,460 3% 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 417 5,000 4,583 92% 5210-447-430550-215 COMPUTER SUPPLIES 4,162 3,000 1,162- -39% 5210-447-430550-216 COMPUTER EQUIPMEMT 4,782 5,000 218 4% 5210-447-430550-218 EQUIPMENT (NON CAPITAL) 6,401 8,475 2,074 24% 5210-447-430550-221 SAFETY EQUIP & SUPPLIES 939 2,500 1,561 62% 5210-447-430550-224 JANITORIAL SUPPLIES 892 800 92- -11% 5210-447-430550-226 CHLORINE & CHEMICALS 23,896 25,000 1,104 4% 5210-447-430550-229 OTHER SUPPLIES 1,187 1,500 313 21% 5210-447-430550-231 GAS & OIL 19,304 38,000 18,696 49% 5210-447-430550-241 CONSUMABLE TOOLS 2,720 2,500 220- -9% 5210-447-430550-312 POSTAGE 613 2,500 1,887 75% 5210-447-430550-320 PRINTING 3,912 2,000 1,912- -96% 5210-447-430550-335 MEMBERSHIP & DUES 1,110 1,200 90 8% 5210-447-430550-336 LICENSES & FEES 16,477 19,000 2,523 13% 5210-447-430550-341 ELECTRICITY 137,459 142,000 4,541 3% 5210-447-430550-342 WATER 348 500 152 30% 5210-447-430550-344 NATURAL GAS 9,644 16,000 6,356 40% 5210-447-430550-345 TELEPHONE & COMMUNICATION 8,003 8,000 3- 0% 5210-447-430550-349 LAB SERVICES 20,069 35,500 15,431 43% 5210-447-430550-353 AUDITING 3,000 3,000 0 0% 5210-447-430550-354 CONTRACT SERVICES 32,559 65,000 32,441 50% 5210-447-430550-355 CONTRACT SERV.-AERIAL MAPPING 302 3,000 2,698 90% 5210-447-430550-356 WTR RIGHTS UPDATE/WTR MODELING 10,754 35,000 24,246 69% 5210-447-430550-357 RATE STUDY 7,132 10,000 2,868 29% 5210-447-430550-358 IMPACT FEE REVIEW 2,268 5,000 2,732 55% 5210-447-430550-360 REPAIR & MAINT SERVICES 34 7,000 6,966 100% 5210-447-430550-362 EQUIPMENT MAINTENANCE 2,256 4,000 1,744 44% 5210-447-430550-363 OFFICE EQUIP MAINTENANCE 0 200 200 100% 5210-447-430550-366 BUILDING MAINTENANCE 5,486 20,000 14,515 73% 5210-447-430550-369 RADIO EQUIPMENT & MAINT. 0 2,450 2,450 100% 5210-447-430550-373 SCHOOL & TRAVEL 4,815 6,500 1,685 26% 5210-447-430550-380 TRAINING MATERIALS 0 500 500 100% 5210-447-430550-388 MEDICAL SERVICES 635 800 166 21% 5210-447-430550-395 RENTAL EQUIPMENT 0 1,500 1,500 100% 5210-447-430550-410 CONSTRUCTION MATERIALS 24,238 30,000 5,762 19% 5210-447-430550-422 HYDRANTS 2,560 34,000 31,440 92% 5210-447-430550-423 MATERIALS FOR MAINS 3,076 12,000 8,924 74% 5210-447-430550-424 MATERIALS -SERVICE LINES 6,163 8,000 1,837 23% 5210-447-430550-425 MATERIALS PUMPS/WELLS 28,029 36,000 7,971 22% 5210-447-430550-510 PROPERTY & LIABILITY INS. 37,905 38,000 95 0% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 11,933 4,000 7,933- -198% 5210-447-430550-513 UNINSURED LOSS -GOODWILL 0 7,500 7,500 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 8,500 8,500 0 0% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 90,156 90,156 0 0% Page 18 100.00% Yr Complete 07/30/10 FUND CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND ACTUAL YTD BUDGET REMAINING % 5210-447-430550-528 DATA PROCESSING TRANSFER 5210-447-430550-532 LEASE PAYMENTS 5210-447-430550-810 BAD DEBT EXPENSE 5210-447-430550-940 MACHINERY & EQUIPMENT 5210-447-430550-948 METERS (METER FUNDS) 5210-447-430550-950 WATER MAIN REPLACEMENT -GRAND VIEW 5210-447-430550-951 SECURITY SYSTEM UPGRADES 5210-447-430550-954 93S BYPASS -UTILITY RELOCATE -amended 5210-447-430550-956 UPPER/LOWER INTERCONNECTION 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 5210-447-430550-961 UPSIZE MAIN-E AZ & 1ST AVE EN 5210-447-430550-962 UPSIZE MAIN -1ST AVE E&IDAHO 5210-447-430555-930 CONTRACT MAIN UPSIZE 5210-447-430555-941 METERS (NEW SERVICES) 5210-447-430555-953 SECTION 36 WELL TOTAL WATER FACILITIES WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 5210-447-430560-153 HEALTH INSURANCE 5210-447-430560-155 RETIREMENT 5210-447-430560-210 OFFICE SUPPLIES 5210-447-430560-218 EQUIPMENT - NOT CAPITAL 5210-447-430560-335 MEMBERSHIP & DUES 5210-447-430560-353 AUDITING 5210-447-430560-354 CONTRACT SERVICES 5210-447-430560-355 BILLING COSTS 5210-447-430560-373 SCHOOL & TRAVEL 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5210-447-430560-528 DATA PROCESSING TRANSFER 5210-447-430560-532 RENT TOTAL WATER BILLING REVENUE BONDS 5210-447-490204-610 2004 BOND PRINCIPAL (HWY93) 5210-447-490204-620 2004 BOND INTEREST (HWY93) 5210-447-490204-630 2004 BOND FISCAL AGENT FEES 5210-447-490206-610 2007 BOND PRIN WRF 3.75% 5210-447-490206-620 2007 BOND INT WRF 3.75% 5210-447-490250-610 SRF 2001 PRINCIPAL 4% 5210-447-490250-620 SRF 2001 INTEREST 4% TOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE TOTAL DEPRECIATION TOTAL WATER FUND ----------------------------------------------- 20,897 20,897 0 0% 7,838 7,838 0 0% 0 1,500 1,500 100% 45,001 55,000 9,999 18% 72,542 105,000 32,458 31% 69,818 156,000 86,182 55% 0 32,000 32,000 100% 227,064 337,432 110,368 33% 31,402 40,000 8,598 22% 0 335,000 335,000 100% 0 195,000 195,000 100% 32,385 35,000 2,615 7% 0 100,000 100,000 100% 54,739 65,000 10,261 16% 0 75,000 75,000 100% ----------- 1,979,033 ----------- ----------- 3,252,353 ----------- --------------------- 1,273,320 --------------------- 39% 91,233 91,459 226 0% 17,934 23,486 5,552 24% 5,739 5,891 152 3% 124 500 376 75% 151 3,000 2,849 95% 238 350 113 32% 1,875 1,500 375- -25% 3,847 7,500 3,653 49% 28,373 25,000 3,373- -13% 675 1,200 525 44% 6,173 6,173 0 0% 22,897 22,897 0 0% 7,838 7,838 0 0% ----------- 187,097 ----------- ----------- 196,794 ----------- --------------------- 9,697 --------------------- 5% 0 140,000 140,000 100% 51,533 51,535 3 0% 300 1,050 750 71% 0 173,000 173,000 100% 89,963 89,970 8 0% 0 36,000 36,000 100% 20,320 ----------- 20,350 30 0% 162,115 ----------- ----------- 511,905 ----------- --------------------- 349,790 --------------------- 68% 0 ----------- 700,000 700,000 100% 0 ----------- ----------- 700,000 ----------- --------------------- 700,000 --------------------- 100% 2,328,245 4,661,052 2,332,807 50% Page 19 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Page 20 Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % SEWER REVENUE: 5310-000-331158-000 STATE BYPASS RELOCATION REIMB. 122,185 217,431 95,246 44% 5310-000-343310-000 SEWER SERVICE CHARGES 3,313,978 3,450,000 136,022 4% 5310-000-343330-000 IMPACT FEES (SANITARY) 128,492 175,000 46,508 27% 5310-000-343335-000 IMPACT FEES (WWTP) 167,505 246,000 78,495 32% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 1,453 1,000 453- -45% 5310-000-343365-000 LATECOMER ADMIN FEES 468 850 382 45% 5310-000-371010-000 INVESTMENT EARNINGS 99,236 165,000 65,764 40% TOTAL SEWER REVENUE ----------- 3,833,316 ----------- 4,255,281 --------------------- 421,965 10% EXPENDITURES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 65,223 75,236 10,013 13% 5310-454-430620-153 HEALTH INSURANCE 13,608 17,935 4,327 24% 5310-454-430620-155 RETIREMENT 4,328 4,792 464 10% 5310-454-430620-215 OFFICE SUPPLIES/FURNITURE 108 1,000 892 89% 5310-454-430620-218 COMPUTERS/SUPPLIES 231 1,500 1,269 85% 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,077 7,500 6,423 86% 5310-454-430620-355 BILLING COSTS 30,935 24,000 6,935- -29% 5310-454-430620-373 SCHOOL & TRAVEL 662 1,000 338 34% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 6,884 6,884 0 0% 5310-454-430620-528 DATA PROCESSING TRANSFER 22,897 22,897 0 0% 5310-454-430620-532 OFFICE RENT 7,838 7,838 0 0% TOTAL SEWER BILLING COSTS ----------- 155,982 ----------- ---------------------- 172,382 ---------------------- ---------- 16,400 ---------- 10% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 356,535 364,781 8,246 2% 5310-454-430630-121 OVERTIME 8,334 6,500 1,834- -28% 5310-454-430630-153 HEALTH INSURANCE 64,763 68,379 3,616 5% 5310-454-430630-155 RETIREMENT 22,780 22,597 183- -1% 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) 2,016 5,500 3,484 63% 5310-454-430630-221 SAFETY EQUIP & SUPPLIES 1,472 900 572- -64% 5310-454-430630-224 JANITORIAL SUPPLIES 673 600 73- -12% 5310-454-430630-229 OTHER SUPPLIES 608 800 192 24% 5310-454-430630-231 GAS & OIL 8,200 14,500 6,300 43% 5310-454-430630-241 CONSUMABLE TOOLS 1,039 1,200 161 13% 5310-454-430630-312 POSTAGE 148 750 602 80% 5310-454-430630-336 LICENSES & FEES 240 450 210 47% 5310-454-430630-341 ELECTRICITY 39,728 36,000 3,728- -10% 5310-454-430630-342 WATER 201 175 26- -15% 5310-454-430630-344 NATURAL GAS 12,984 12,500 484- -4% 5310-454-430630-345 TELEPHONE & COMMUNICATION 21,676 20,500 1,176- -6% 5310-454-430630-353 AUDITING 2,000 2,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 19,588 22,100 2,512 11% 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 8,930 12,500 3,570 29% 5310-454-430630-358 IMPACT FEE REVIEW 2,268 5,000 2,732 55% 5310-454-430630-362 EQUIPMENT MAINTENANCE 3,156 7,800 4,644 60% 5310-454-430630-366 BUILDING MAINTENANCE 1,677 1,000 677- -68% 5310-454-430630-369 RADIO EQUIPMENT & MAINT. 0 1,000 1,000 100% 5310-454-430630-373 SCHOOL & TRAVEL 2,274 3,000 726 24% 5310-454-430630-388 MEDICAL SERVICES 811 800 11- -1% 5310-454-430630-410 CONSTRUCTION MATERIALS 6,121 10,000 3,879 39% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 7,936 14,500 6,564 45% 5310-454-430630-510 PROPERTY & LIABILITY INS. 25,027 28,500 3,473 12% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 16,692 18,000 1,308 7% 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 5310-454-430630-521 CENTRAL GARAGE TRANSFER 3,000 3,000 0 0% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 54,771 54,771 0 0% 5310-454-430630-528 DATA PROCESSING TRANSFER 15,325 15,325 0 0% 5310-454-430630-532 OFFICE RENT 7,838 7,838 0 0% 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 21,261 25,000 3,739 15% 5310-454-430630-810 BAD DEBT EXPENSE 0 945 945 100% 5310-454-430630-954 93S BYPASS -UTILITY RELOCATE -amended 186,267 303,308 117,042 39% TOTAL SANITARY SEWER/COLLECTIO ----------- 931,564 ----------- ----------- 1,117,969 ----------- --------------------- 186,405 ----------- ---------- 17% 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 9,815 10,000 185 2% TOTAL REPLACEMENT $ ----------- 19,815 ----------- ----------- 40,000 ----------- --------------------- 20,185 --------------------- 50% 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% 553,710 500,000 53,710- -11% TOTAL SANITARY SEWER PLANT INV ----------- 553,710 ----------- ----------- 575,832 ----------- --------------------- 22,122 --------------------- 4% 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 Ors 5310-454-490204-630 FISCAL AGENT FEES 300 300 0 0% TOTAL REVENUE BONDS ----------- 44,700 ----------- ----------- 105,700 ----------- --------------------- 61,000 --------------------- 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,549,790 2,339,501 789,711 34% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 373,817 400,679 26,862 7% 5310-455-430640-121 OVERTIME 20,877 20,000 877- -4% 5310-455-430640-153 HEALTH INSURANCE 64,914 68,415 3,501 5% 5310-455-430640-155 RETIREMENT 24,784 24,751 33- 0% 5310-455-430640-210 OFFICE SUPPLIES 989 1,000 11 1% 5310-455-430640-213 SMALL OFFICE EQUIPMENT 828 500 328- -66% 5310-455-430640-215 COMPUTER SUPPLIES 807 500 307- -61% 5310-455-430640-216 COMPUTER EQUIPMENT 936 1,500 564 38% 5310-455-430640-221 SAFETY EQUIP & SUPPLIES 1,714 2,500 786 31% 5310-455-430640-224 JANITORIAL SUPPLIES 262 250 12- -5% 5310-455-430640-225 ALUM 20,156 70,000 49,844 71% 5310-455-430640-226 CHLORINE & CHEMICALS 7,738 12,500 4,762 38% 5310-455-430640-229 OTHER SUPPLIES 4,186 4,000 186- -5% 5310-455-430640-231 GAS & OIL 12,545 14,000 1,455 10% 5310-455-430640-241 CONSUMABLE TOOLS 1,010 1,000 10- -1% 5310-455-430640-312 POSTAGE 231 500 269 54% 5310-455-430640-335 MEMBERSHIP & DUES 401 1,200 799 67% 5310-455-430640-336 LICENSES & FEES 6,703 7,500 797 11% 5310-455-430640-341 ELECTRICITY 168,619 235,000 66,381 28% 5310-455-430640-342 WATER 5,344 8,500 3,156 37% 5310-455-430640-344 NATURAL GAS 50,002 65,000 14,998 23% 5310-455-430640-345 TELEPHONE & COMMUNICATION 5,179 6,000 821 14% 5310-455-430640-353 AUDITING 2,750 2,750 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 128,712 130,000 1,288 1% Page 21 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Page 22 Quarterly Finance Report June 30, 2010 as of July 30th 100.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 5310-455-430640-355 OTHER CONTRACT SERVICES 36,164 45,000 8,836 20% 5310-455-430640-356 CONSULTANTS 13,674 25,000 11,326 45% 5310-455-430640-357 WWTP RATE STUDY 8,930 12,500 3,570 29% 5310-455-430640-358 CONSULTANT-TMDL 1,075 25,000 23,925 96% 5310-455-430640-360 REPAIR & MAINT SERVICES 5,442 15,000 9,558 64% 5310-455-430640-361 MAINT.-DIGESTER CLEAN/INSPECT 1,600 0 1,600- 0% 5310-455-430640-366 BUILDING MAINTENANCE 2,246 2,500 254 10% 5310-455-430640-373 SCHOOL & TRAVEL 5,206 14,000 8,794 63% 5310-455-430640-380 TRAINING MATERIALS 82 500 419 84% 5310-455-430640-388 MEDICAL SERVICES 482 700 218 31% 5310-455-430640-395 RENTAL EQUIPMENT 75 1,000 925 93% 5310-455-430640-510 PROPERTY & LIABILITY INS. 46,941 56,500 9,559 17% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 4,000 4,000 0 0% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 95,228 95,228 0 0% 5310-455-430640-528 DATA PROCESSING TRANSFER 19,504 19,504 0 0% TOTAL WWTP OPERATIONS ----------- 1,144,153 ----------- 1,394,477 --------------------- 250,324 18% WWTP REPLACEMENT ----------- ----------- --------------------- 5310-455-430645-362 EQUIPMENT MAINTENANCE 57,901 60,000 2,099 4% 5310-455-430645-940 MACHINERY & EQUIPMENT 26,367 73,000 46,633 64% TOTAL WWTP REPLACEMENT ----------- 84,269 ----------- ----------- 133,000 ----------- --------------------- 48,731 --------------------- 37% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 127,328 126,206 1,122- -1% 5310-455-430646-121 OVERTIME 0 300 300 100% 5310-455-430646-153 HEALTH INSURANCE 17,702 21,295 3,593 17% 5310-455-430646-155 RETIREMENT 7,937 7,795 142- -2% 5310-455-430646-210 OFFICE SUPPLIES 0 100 100 100% 5310-455-430646-215 COMPUTER SUPPLIES & SUPPORT 0 50 50 100% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 7,597 5,400 2,197- -41% 5310-455-430646-222 LAB SUPPLIES 8,211 7,500 711- -9% 5310-455-430646-224 JANITORIAL SUPPLIES 0 50 50 100% 5310-455-430646-229 OTHER SUPPLIES 98 200 102 51% 5310-455-430646-312 POSTAGE & SHIPPING 0 1,200 1,200 100% 5310-455-430646-335 MEMBERSHIP & DUES 0 100 100 100% 5310-455-430646-336 LICENSES & FEES 80 200 120 60% 5310-455-430646-345 TELEPHONE & ALARMS 0 50 50 100% 5310-455-430646-349 LAB SERVICES 16,315 20,000 3,685 18% 5310-455-430646-362 EQUIPMENT MAINTENANCE 1,742 1,500 242- -16% 5310-455-430646-373 SCHOOL & TRAVEL 2,914 4,000 1,086 27% 5310-455-430646-380 TRAINING MATERIALS 0 200 200 100% TOTAL WWTP LAB OPERATIONS ----------- 189,924 ----------- 196,146 --------------------- 6,222 3% REVENUE BONDS/WWTP 5310-455-490210-610 DEBT-2002 ISSUE -PRINCIPAL 0 220,000 220,000 100% 5310-455-490210-620 DEBT-2002 INTEREST 18,230 18,230 0 0% 5310-455-490210-630 FISCAL AGENT FEES-2002 BONDS 0 300 300 100% TOTAL REVENUE BONDS/WWTP ----------- 18,230 ----------- ----------- 238,530 ----------- --------------------- 220,300 --------------------- 92% SRF LOAN/WWTP 5310-455-490215-610 DEBT SRF 92003-PRINCIPAL 0 250,000 250,000 100% 5310-455-490215-620 DEBT SRF 92003-INTEREST 34,400 34,400 0 0% TOTAL SRF LOAN/WWTP ----------- 34,400 ----------- ----------- 284,400 ----------- ----------- ---------- 250,000 ----------- 88% DEBT SERVICE SRF -new constr. ---------- 5310-455-490227-610 SRF 2007WWTP PRINCIPAL 0 207,000 207,000 100% 5310-455-490227-620 SRF 2007WWTP INTEREST 519,638 520,000 363 0% SUBTOTAL SRF 2007 ----------- 519,638 ----------- 727,000 --------------------- 207,363 29% TOTAL WWTP DEBT ----------- 572,268 ----------- 1,249,930 --------------------- 677,663 54% 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET ------------------------------------------------------------------------------------ ----------- ------ DEPRECIATION 5310-455-510400-831 DEPRECIATION EXPENSE TOTAL DEPRECIATION TOTAL WWTP TOTAL BILLING/SANITARY/WWTP REMAINING % ---------------------- --------------------- 0 ----------- 419,375 ----------- 419,375 ----------- 100% 0 ----------- 419,375 ----------- ---------- 419,375 --------------------- 100% 1,990,613 3,392,928 1,402,316 41% ----------- 3,696,385 --------------------- 2,208,426 37% ----------- 5,904,811 Page 23 100.00% Yr Complete 07/30/10 FUND ------------- 5349-000-331158-000 5349-000-334040-000 5349-000-334041-000 5349-000-343033-000 5349-000-343034-000 5349-000-343035-000 5349-000-343370-000 5349-000-363040-000 5349-000-365000-000 5349-000-371010-000 5349-453-430246-110 5349-453-430246-121 5349-453-430246-153 5349-453-430246-155 5349-453-430246-210 5349-453-430246-214 5349-453-430246-215 5349-453-430246-216 5349-453-430246-218 5349-453-430246-221 5349-453-430246-229 5349-453-430246-231 5349-453-430246-241 5349-453-430246-320 5349-453-430246-345 5349-453-430246-353 5349-453-430246-354 5349-453-430246-355 5349-453-430246-356 5349-453-430246-357 5349-453-430246-358 5349-453-430246-359 5349-453-430246-360 5349-453-430246-362 5349-453-430246-371 5349-453-430246-373 5349-453-430246-388 5349-453-430246-410 5349-453-430246-510 5349-453-430246-521 5349-453-430246-522 5349-453-430246-528 5349-453-430246-530 5349-453-430246-532 5349-453-430246-952 5349-453-430246-954 5349-453-430246-958 5349-453-430248-958 5349-453-430248-959 5349-453-430248-960 5349-453-510400-831 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND ------------------- STORM SEWER REVENUE STATE BYPASS RELOCATION REIMB. PETRO TANK RELEASE/MONITORING REIMB DEQ MINI GRT/SEEP IMPACT FEES PERMIT FEES STORM SEWER CHARGES STORM SEWER ASSESSMENTS PEN & INT ON SPEC ASSESS. DONATIONS INTEREST ON INVESTMENTS TOTAL STORM REVENUE STORM SEWER SALARIES -STORM SEWER OVERTIME HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES/EQUIPMENT GIS SUPPLIES COMPUTER SUPPLIES COMPUTER EQUIPMENT EQUIPMENT -NON CAPITAL SAFETY EQUIP & SUPPLIES OTHER SUPPLIES GAS & OIL CONSUMABLE TOOLS PRINTING TELEPHONE & COMMUNICATION AUDITING CONTRACT SERVICE CONTRACT SERV.-AERIAL MAPPING STORMWATER REG COMPLIANCE PROGRAM RATE STUDY IMPACT STUDY CONSULTANTS-TMDL REPAIR & MAINT SERVICES GROUNDWATER MONITORING CURB & GUTTER SCHOOL & TRAVEL MEDICAL SERVICES CONSTRUCTION MATERIALS PROPERTY & LIABILITY INS. CENTRAL GARAGE TRANSFER ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER BNSF LEASE PMT OFFICE RENT STORM DRAIN CORRECTION S MEADOWS SURVEY STILLWTR/WILLOW GLEN CONST STILLWATER/WILLOW GLEN CONST SE STORM DRAIN IMP. PH I STORMWATER FACILITY UPSIZE DEPRECIATION (FUND $40,000) TOTAL STORM ACTUAL YTD BUDGET REMAINING % 1,655 0 1, 655- 0% 87,401 5,000 82,401- -1648% 1,500 0 1,500- 0% 253,136 200,000 53,136- -27% 2,365 1,800 565- -31% 2,228 1,000 1,228- -123% 803,042 800,000 3,042- 0& 4,445 2,500 1,945- -78% 1,000 0 1,000- 0% 31,295 30,000 1,295- -4% ------------------------------------------- 1,188,066 1,040,300 147,766- -14% 325,179 342,098 16,919 5% 3,666 4,500 834 19% 56,978 65,457 8,479 13% 21,115 21,412 297 1& 390 1,200 810 68% 160 3,000 2,840 95% 4,736 4,000 736- -18% 2,999 3,000 1 0% 1,640 2,200 560 25% 1,730 1,000 730- -73% 930 1,200 270 23% 8,103 13,500 5,397 40% 0 1,000 1,000 100% 0 200 200 100% 832 700 132- -19% 600 600 0 0& 4,342 2,000 2,342- -117% 0 3,000 3,000 100% 17,672 12,500 5,172- -41% 16,034 22,500 6,466 29% 0 5,000 5,000 100% 0 25,000 25,000 100% 1,850 1,200 650- -54% 24,654 27,000 2,346 9% 7,504 5,000 2,504- -50% 2,560 4,500 1,940 43% 0 250 250 100% 105 10,000 9,895 99% 9,282 10,000 718 7% 2,500 2,500 0 0% 32,848 32,848 0 0% 5,573 5,573 0 0% 5,119 4,200 919- -22% 7,838 7,838 0 0% 15,000 132,518 117,518 89% 0 10,000 10,000 100% 73,611 80,000 6,389 8% 246,868 380,000 133,132 35% 162,414 170,000 7,586 4% 0 30,000 30,000 100% 0 ----------- 225,000 ----------- 225,000 100% 1,064,833 ----------- 1,673,494 ---------- 608,661 36% Page 24 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET -------------------------------------------------------------------------------------- SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION 761,522 750,000 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 5,882 3,500 5510-000-371010-000 INVESTMENT EARNINGS 2,983 3,500 --------------------- TOTAL SOLID WASTE REVENUE 770,387 757,000 SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 5510-460-430840-121 OVERTIME 5510-460-430840-153 HEALTH INSURANCE 5510-460-430840-155 RETIREMENT 5510-460-430840-213 SMALL OFFICE EQUIPMENT 5510-460-430840-216 COMPUTER EQUIPMEMT 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 5510-460-430840-221 SAFETY EQUIP & SUPPLIES 5510-460-430840-224 JANITORIAL SUPPLIES 5510-460-430840-229 OTHER SUPPLIES 5510-460-430840-231 GAS & OIL 5510-460-430840-241 CONSUMABLE TOOLS 5510-460-430840-341 ELECTRICITY 5510-460-430840-344 NATURAL GAS 5510-460-430840-345 TELEPHONE & COMMUNICATION 5510-460-430840-354 CONTRACT SERVICES 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 5510-460-430840-366 BUILDING MAINTENANCE 5510-460-430840-369 RADIO EQUIPMENT & MAINT. 5510-460-430840-373 SCHOOL & TRAVEL 5510-460-430840-388 MEDICAL SERVICES 5510-460-430840-510 PROPERTY & LIABILITY INS. 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 5510-460-430840-521 CENTRAL GARAGE TRANSFER 5510-460-430840-522 ADMINISTRATIVE TRANSFER 5510-460-430840-528 DATA PROCESSING TRANSFER 5510-460-430840-532 OFFICE RENT 5510-460-430845-224 JANITORIAL SUPPLIES 5510-460-430845-341 ELECTRICITY 5510-460-430845-342 WATER 5510-460-430845-344 NATURAL GAS 5510-460-430845-360 REPAIR & MAINT SERVICES 5510-460-430845-366 BUILDING MAINTENANCE 5510-460-510400-831 DEPRECIATION EXPENSE TOTAL SOLID WASTE EXPENSE REMAINING % 11,522- -2% 2,382- -68% 517 15% --------------------- 13,387- -2% 358,158 381,964 23,806 6% 3,686 9,500 5,814 61% 64,743 68,729 3,986 6% 22,379 23,609 1,230 5% 40 500 460 92% 421 2,500 2,079 83% 4,206 25,000 20,795 83% 970 1,500 530 35% 314 400 86 21% 1,098 2,000 902 45% 32,806 47,800 14,994 31% 88 1,500 1,412 94% 1,593 1,600 7 0% 1,477 8,000 6,523 82% 625 700 75 11% 10,758 12,000 1,242 10% 4,161 4,750 589 12% 1,667 2,500 833 33% 695 1,700 1,005 59% 777 3,500 2,723 78% 606 550 56- -10% 13,749 14,500 751 5% 0 6,500 6,500 100% 26,000 26,000 0 0% 30,683 30,683 0 0% 11,145 11,145 0 0% 7,838 7,838 0 0% 0 350 350 100% 3,139 2,500 639- -26% 439 350 89- -25% 3,627 9,500 5,873 62% 693 1,000 307 31% 978 1,000 22 2% 0 100,000 100,000 100% ---------------------- 609,557 ----------- 811,668 ---------- 202,111 25% Page 25 100.00% Yr Complete 07/30/10 CITY OF KALISPELL Page 26 Quarterly Finance Report June 30, 2010 as of July 30th FUND FUND ACTUAL YTD BUDGET REMAINING % 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 8,715 11,000 2,285 21% 5160-000-343063-000 TIE DOWN FEES 3,220 4,000 780 20% 5160-000-343069-000 HANGER LEASES 10,553 12,000 1,448 12% 5160-000-343071-000 HANGAR SITE LEASES 15,556 18,600 3,044 16% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 16,464 16,500 36 0% 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 5,455 6,000 545 9% 5160-000-371010-000 INVESTMENT EARNINGS 15,928 8,500 7,428- -87% TOTAL AIRPORT REVENUE ----------- 86,622 ----------- 90,050 --------------------- 3,428 4% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 34,523 33,797 726- -2% 5160-430-430310-111 SEASONAL SALARIES 376 3,267 2,891 88% 5160-430-430310-153 HEALTH INSURANCE 3,030 3,030 0 0% 5160-430-430310-155 RETIREMENT 1,884 2,406 522 22% 5160-430-430310-210 OFFICE SUPPLIES 445 300 145- -48% 5160-430-430310-218 NON -CAPITAL EQUIPMENT 468 1,000 532 53% 5160-430-430310-335 MEMBERSHIP & DUES 150 250 100 40% 5160-430-430310-341 ELECTRICITY 1,248 1,500 252 17% 5160-430-430310-345 TELEPHONE 871 1,000 129 13% 5160-430-430310-354 CONTRACT SERVICES 5,785 7,500 1,715 23% 5160-430-430310-355 CONTRACT SERVICES -MOWING 735 2,000 1,265 63% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 3,165 5,000 1,835 37% 5160-430-430310-360 REPAIRS & MAINTENANCE 2,495 4,000 1,505 38% 5160-430-430310-362 EQUIPMENT MAINTENANCE 400 1,000 600 60% 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 289 500 211 42% 5160-430-430310-390 EQUIPMENT RENTAL 1,200 1,500 300 20% 5160-430-430310-510 PROPERTY INSURANCE 6,167 6,870 703 10% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 8,130 8,130 0 0% 5160-430-430310-528 DATA PROCESSING TRANSFER 3,000 3,000 0 0% 5160-430-430310-820 DEPRECIATION 0 86,602 86,602 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 0 115,470 115,470 100% TOTAL AIRPORT OPERATIONS ---------------------- 75,870 ----------- 292,122 ---------- 216,252 74% 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 3,268 2,000 1,268- -63% 6030-000-393000-000 INTERNAL SERVICES -DATA 157,459 161,425 3,966 2% TOTAL DATA PROCESSING REVENUE ---------------------- 310,958 ----------- 313,925 ---------- 2,967 1% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 72,646 73,786 1,140 2% 6030-401-410580-153 HEALTH INSURANCE 9,095 9,702 607 6% 6030-401-410580-155 RETIREMENT 4,788 4,790 2 0% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 2,205 3,000 795 26% 6030-403-410580-215 COMPUTER SUPPLIES 3,025 3,700 675 18% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 12,632 11,000 1,632- -15% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 1,725 24,000 22,275 93% 6030-403-410580-346 SUMMIT NET Tl CONTRACT 3,153 5,000 1,847 37% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,160 3,500 340 10% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 8,800 7,000 1,800- -26% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 19,484 22,679 3,195 14% 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 10,441 12,000 1,559 13% 6030-403-410580-373 SCHOOL & TRAVEL 3,945 6,200 2,255 36% 6030-403-410580-510 INSURANCE 1,497 1,675 178 11% 6030-403-410585-229 COPIER,FAX, SUPPLIES 3,796 5,500 1,704 31% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 62,226 70,000 7,774 11% 6030-403-410585-532 COPIER LEASES 30,673 28,500 2,173- -8% 100.00% Yr Complete 07/30/10 FUND FUND CITY OF KALISPELL Quarterly Finance Report June 30, 2010 as of July 30th ACTUAL YTD BUDGET 6030-403-510400-831 DEPRECIATION EXPENSE 6030-404-410588-218 COMPUTERS - ATTORNEYS 6030-405-410588-940 COMPUTERS - 3 switches 6030-410-410588-218 COMPUTERS - DPW 6030-413-410588-218 COMPUTERS - POLICE DEPT 6030-416-410588-218 COMPUTERS - FIRE 6030-420-410588-218 COMPUTERS - PLANNING DEPT 6030-436-410588-218 COMPUTERS - PARKS 6030-480-410588-218 COMMUNITY DEVELOPMENT TOTAL DATA PROCESSING EXPENSE REMAINING % ----------------------------------------------- 0 10,000 10,000 100% 1,501 1,500 1- 0% 0 29,171 29,171 100% 3,523 3,300 223- -7% 8,668 5,000 3,668- -73% 3,105 5,500 2,395 44% 1,465 1,500 35 2% 2,015 2,000 15- -1% 500 500 0 0% ---------------------- 280,069 ----------- 363,503 ---------- 83,434 23% Page 27 100.00% Yr Complete