The URL can be used to link to this page

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