Loading...
2nd Quarter Finance ReportCity of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 Date January 18, 2012 TO: Mayor Fisher & City Council Members From: Amy Robertson Finance Director RE: 2nd Qtr Finance Report — FY2012 (July totals thru Dec 2011) Please find attached the printouts reflecting the activity for the V half of the fiscal year 2012. This printout reflects payroll earned thru Dec. 30, 2011. All funds are included with the exception of the debt service funds. REVENUE: General Fund revenue reflects taxes collected dim January 17'. Taxes received by the County November 30' are booked in December by the County and received by the City in January which is why I hold this report until the taxes are posted in January. It gives us a better representation of the first half collections — currently 55% collected. The County is holding $146,000 in protested city taxes. Most of the protested taxes are centrally assessed properties — utility companies. EXPENDITURES: General Fund expenditures reflect 52% spent —some expenditures such as liability and property insurance are paid during the first quarter for the entire year. A change in reporting requirements for health insurance premiums requires that the city paid portion be reflected on the W-2s for calendar year 2012. This change will force us to recognize the expenditure thru the payroll program in advance. Come June 30' we will have posted 13 months in the fiscal year which will require a journal entry to record a prepaid expense in each fund. Currently, budget printouts reflect health premiums thru February. Parking expenditures are now being recorded in the General Fund police budget - Council will need to amend the General Fund budget for appropriation authority before year end for these expenditures. I would recommend waiting until later this spring to determine if other amendments are needed in regards to recruitment of the city manager or other contingencies. CASH REPORT: included at the end of the budget printout is the December 31' cash report and detail for your information. Grant funds are generally reimbursements and will reflect negative balances until reimbursed. Please feel free to call with any questions. 758-7755. O1/19/12 CITY OF KALISPELL Page 1 Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,553,519 4,681,906 2,128,387 450 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 8,068 15,520 7,452 48% 1000-000-311200-000 PERSONAL PROPERTY TAXES 204,378 208,000 3,622 2% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 17,859 35,000 17,141 49% 1000-000-322101-000 BEER & LIQUOR LICENSES 300 24,000 23,700 99% 1000-000-322300-000 BUSINESS LICENSES 0 1,100 1,100 100% 1000-000-322500-000 AMUSEMENT LICENSES 300 350 50 14% 1000-000-323012-000 PLANNING FEES 6,887 40,000 33,113 83% 1000-000-323107-000 EXCAV/DEMO/AIR/HOUSE MOVING PERMITS 0 500 500 100% 1000-000-323109-000 SITE REVIEW 4,487 9,500 5,013 53% 1000-000-323200-000 PARADE PERMITS 450 2,000 1,550 78% 1000-000-323300-000 ANIMAL LICENSES 531 900 369 41% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,720 1,720 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 53,600 61,075 7,475 12% 1000-000-335110-000 LIVE CARD TABLE PERMIT 3,200 3,600 400 11% 1000-000-335230-000 HB124 ENTITLEMENT 1,135,229 2,272,379 1,137,150 50% 1000-000-341020-000 ADMINISTRATIVE CHARGES 310,217 512,000 201,783 39% 1000-000-341021-000 Grant Admin Fees 0 43,000 43,000 100% 1000-000-341025-000 CITY COLLECTIONS 17,268 1,000 16,268- -1627% 1000-000-341027-000 BRESNAN FRANCHISE FEES 38,513 157,000 118,487 750 1000-000-342010-000 POLICE SERVICES 14,278 15,000 722 5% 1000-000-342014-000 RESOURCE OFFICERS 86,000 86,000 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 0 10,000 10,000 100% 1000-000-343005-000 CENTRAL GARAGE CHARGE 71,050 121,800 50,750 42% 1000-000-343018-000 PARKING PERMITS METERS, BOOT REMOVE 585 0 585- 0% 1000-000-351000-000 CITY COURT FINES & FEES 254,588 500,000 245,412 49% 1000-000-351016-000 DUI COURT FINE 135 3,500 3,365 96% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 11,905 32,000 20,095 63% 1000-000-351035-000 PARKING FINES 1,795 0 1,795- 0% 1000-000-362010-000 CITY GOLF COURSE LEASE 0 25,000 25,000 100% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 5,865 3,000 2,865- -95% 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 3,000 3,000 0 0% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 518 100 418- -418% 1000-000-365001-000 KMTC NON-PROFIT DONATIONS 50 0 50- 0% 1000-000-365015-000 CONTRIBUTION FRM KIDSPORT 0 44,000 44,000 100% 1000-000-371010-000 INVESTMENT EARNINGS 14,094 35,000 20,907 60% 1000-000-371050-000 LOAN REPAY - KPC 0 2,855 2,855 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 342,150 599,209 257,059 43% TOTAL REVENUE ----------- 5,160,818 ----------- 9,551,014 --------------------- 4,390,196 46% 58.33% Yr Complete O1/19/12 FUND FUND CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 ACTUAL YTD BUDGET ------------------------------------------------------- GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 1000-400-410530-353 AUDITING 1000-400-410530-354 OPEB EXPENSE 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1000-400-410560-312 POSTAGE 1000-400-410560-320 PRINTING 1000-400-410600-354 ELECTIONS 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1000-400-420000-354 CONTRACT 911 CENTER 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 1000-400-460446-354 KIDSPORT LEASE 1000-400-460446-355 PARADE -SERVICE ORG. REIMB. 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 1000-400-460452-366 HOCKADAY MAINTENANCE 1000-400-510300-000 CONTINGENCY 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-338 RECRUITMENT 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-HR DEPT. 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 REMAINING % 965 1,435 470 33% 10,000 10,500 500 5% 6,000 6,000 0 0% 1,703 3,000 1,297 43% 4,774 16,000 11,226 70% 4,345 6,000 1,655 28% 0 10,000 10,000 100% 829 3,500 2,671 76% 214,368 428,736 214,368 50% 308 300 8- -3% 0 44,000 44,000 100% 0 2,000 2,000 100% 15,000 15,000 0 0% 6,600 6,600 0 0% 569 40,000 39,431 99% 500 500 0 0% 213,145 215,455 2,310 1% 11,549 30,000 18,451 62% 41,812 ----------- 50,000 8,188 16% 532,466 ---------------------- 889,026 ---------- 356,560 40% 61,326 123,832 62,506 50% 8,704 14,956 6,252 42% 6,534 12,985 6,451 50% 0 800 800 100% 124 500 376 75% 1,500 0 1,500- 0% 100 400 300 75% 1,007 2,500 1,493 60% 474 ----------- 500 26 5% ----------- 79,770 ----------- 156,473 ---------- 76,703 49% 52,773 103,539 50,766 49% 11,075 16,667 5,592 34% 3,443 6,725 3,282 49% 126 400 274 68% 284 3,500 3,216 92% 115 4,000 3,885 97% 1,702 ----------- 3,900 2,198 56% ----------- 69,518 ----------- 138,731 ---------- 69,213 50% Page 2 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- MEDIA SPECIALIST 1000-401-410900-110 SALARIES -MEDIA SPECIALIST 10,650 20,080 9,430 47% 1000-401-410900-153 HEALTH INSURANCE 5,543 8,200 2,657 32% 1000-401-410900-155 RETIREMENT 718 1,299 581 45% 1000-401-410900-218 EQUIPMENT 0 1,000 1,000 100% 1000-401-410900-354 CONTRACT SERVICES 1,100 2,500 1,400 56% SUBTOTAL MEDIA SPECIALIST ----------- 18,010 ----------- 33,079 --------------------- 15,069 46% MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 31,069 63,056 31,987 51% 1000-402-410100-153 HEALTH INSURANCE 17,400 27,936 10,536 38% 1000-402-410100-155 RETIREMENT 1,434 2,432 998 41% 1000-402-410100-210 OFFICE SUPPLIES 32 50 18 37% 1000-402-410100-335 MT LEAGUE OF CITIES 5,978 6,000 22 0% 1000-402-410100-354 CONTRACT SERVICES 25 100 75 75% 1000-402-410100-373 DUES & TRAINING 120 3,000 2,880 96% 1000-402-410100-379 MEETINGS 248 300 53 18% SUBTOTAL MAYOR/COUNCIL ----------- 56,306 ----------- 102,874 ----------- ---------- 46,568 45% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 40,631 78,245 37,614 48% 1000-402-410150-121 OVERTIME 383 500 117 23% 1000-402-410150-153 HEALTH INSURANCE 6,585 10,357 3,772 36% 1000-402-410150-155 RETIREMENT 2,664 5,062 2,398 47% 1000-402-410150-210 OFFICE SUPPLIES 34 100 66 66% 1000-402-410150-345 TELEPHONE & COMMUNICATION 207 450 243 54% 1000-402-410150-352 RECODIFICATION 2,135 3,500 1,365 39% 1000-402-410150-354 CONTRACT SERVICES 0 25 25 100% 1000-402-410150-373 DUES & TRAINING 1,068 1,275 207 16% SUBTOTAL CITY CLERK ----------- 53,706 ----------- 99,514 --------------------- 45,808 46% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 98,990 191,804 92,814 48% 1000-403-410550-153 HEALTH INSURANCE 23,567 35,449 11,882 34% 1000-403-410550-155 RETIREMENT 6,471 12,453 5,982 48% 1000-403-410550-322 BOOKS 0 300 300 100% 1000-403-410550-345 TELEPHONE & COMMUNICATION 0 100 100 100% 1000-403-410550-353 CONTRACT SERVICES 493 1,500 1,007 67% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 541 1,500 959 64% 1000-403-410550-355 BANK CHARGES & FEES 1,596 3,500 1,904 54% 1000-403-410550-373 DUES & TRAINING 1,452 3,500 2,048 59% SUBTOTAL FINANCE 133,110 250,106 116,996 47% Page 3 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Page 4 Quarterly Finance Report JANUARY 19, 2012 58.33% Yr Complete FUND 1000-404-411110-110 1000-404-411110-153 1000-404-411110-155 1000-404-411110-210 1000-404-411110-322 1000-404-411110-345 1000-404-411110-354 1000-404-411110-373 1000-406-410360-110 1000-406-410360-153 1000-406-410360-155 1000-406-410360-210 1000-406-410360-229 1000-406-410360-320 1000-406-410360-345 1000-406-410360-353 1000-406-410360-354 1000-406-410360-373 1000-406-410360-394 1000-406-410360-395 1000-406-410360-396 1000-406-410360-826 1000-410-430100-110 1000-410-430100-112 1000-410-430100-153 1000-410-430100-155 1000-410-430100-210 1000-410-430100-345 1000-410-430100-354 1000-410-430100-373 1000-410-431330-110 1000-410-431330-121 1000-410-431330-153 1000-410-431330-155 1000-410-431330-210 1000-410-431330-229 1000-410-431330-231 1000-410-431330-232 1000-410-431330-233 1000-410-431330-238 1000-410-431330-241 1000-410-431330-341 1000-410-431330-344 1000-410-431330-354 1000-410-431330-355 1000-410-431330-362 1000-410-431330-373 1000-410-431330-388 FUND CITY ATTORNEY SALARIES -CITY ATTORNEY'S HEALTH INSURANCE RETIREMENT OFFICE/COMPUTER SUPPLIES LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS TELEPHONE & COMMUNICATION CONTRACT SERVICES DUES & TRAINING SUBTOTAL CITY ATTORNEY MUNICIPAL COURT SALARIES -COURT HEALTH INSURANCE RETIREMENT SUPPLIES KM TREATMENT COURT INCENTIVES PRINTING/BOOKS TELEPHONE & COMMUNICATION SECURITY & TECHNOLOGY CONTRACT SERVICES DUES & TRAINING JURY & WITNESS FEES DRUG COURT DUI COURT INCENTIVES & MISC TFR TO 2951/DUI COURT GRT SUBTOTAL COURT DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION SALARIES -PUBLIC WORKS SEVERANCE HEALTH INSURANCE RETIREMENT COMPUTER/OFFICE SUPPLIES TELEPHONE & COMMUNICATION CONTRACT SERVICES DUES & TRAINING SUBTOTAL ADMINISTRATION CENTRAL GARAGE SALARIES -CENTRAL GARAGE OVERTIME HEALTH INSURANCE RETIREMENT OFFICE/COMPUTER SUPPLIES NON -CAPITAL & SAFETY EQUIPMENT GAS & OIL MOTOR VEHICLE PARTS. TIRES AND RELATED PARTS FILTERS & MISC. PARTS CONSUMABLE TOOLS/BOOKS ELECTRICITY NATURAL GAS CONTRACT SERVICES CONTRACT SERVICES -FLEET SERVICES BUILDINGS & EQUIPMENT MAINTENANCE DUES & TRAINING MEDICAL SERVICES SUBTOTAL CENTRAL GARAGE TOTAL PUBLIC WORKS ACTUAL YTD BUDGET REMAINING % 156,236 307,471 151,235 49% 35,551 53,367 17,816 33% 10,210 19,972 9,762 49% 417 3,200 2,783 87% 5,558 7,000 1,442 21% 299 1,200 901 75% 130 5,000 4,870 97% 1,962 4,500 2,538 56% --------- 210,364 ----------- 401,710 --------------------- 191,346 48% 99,119 198,727 99,608 50% 31,132 46,818 15,686 34% 6,483 12,884 6,401 50% 939 4,500 3,561 79% 50 0 50- 0% 443 500 57 11% 399 1,400 1,001 72% 4,645 55,000 50,355 92% 2,352 5,750 3,398 59% 875 6,300 5,425 86% 3,213 5,750 2,537 44% 358 11,500 11,142 97% 454 500 46 9% 853 --------- 1,000 147 15% 151,314 ---------------------- 350,629 ---------- 199,315 57% 8,328 17,430 9,102 52% 0 2,000 2,000 100% 2,102 3,755 1,653 44% 547 1,129 582 52% 359 2,025 1,666 82% 136 200 64 32% 398 750 352 47% 457 -------- 1,150 693 60% ----------- 12,327 ----------- 28,439 ---------- 16,112 57% 74,284 150,825 76,541 51% 479 1,700 1,221 72% 19,407 31,170 11,763 38% 4,650 9,252 4,602 50% 367 1,200 833 69% 6,098 5,550 548- -10% 75,210 135,500 60,290 44% 57,883 79,000 21,117 27% 23,567 27,000 3,433 13% 3,526 3,700 174 5% 705 650 55- -8% 771 1,700 929 55% 2,197 7,600 5,403 71% 13,803 52,000 38,197 73% 0 25,000 25,000 100% 1,243 1,250 7 1% 100 500 400 80% 99 250 151 60% ------------------- 284,390 ----------- 533,847 ---------- 249,457 47% 296,717 562,286 265,569 47% 01/19/12 FUND FUND CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 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-218 EQUIPMENT/FURNACE 1000-412-411230-220 SECURITY CAMERA -CITY HALL 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 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 % 30,649 64,124 33,475 52% 51 200 149 75% 8,446 13,130 4,684 36% 1,942 4,010 2,068 52% 7,500 7,500 0 0% 7,955 10,000 2,045 20% 2,721 5,200 2,479 48% 14 1,450 1,436 99% 23,402 45,000 21,598 48% 11,526 50,000 38,474 77% 94 250 156 62% 22,638 23,000 362 2% 0 4,500 4,500 100% 2,600 5,000 2,400 48% 15,922 17,300 1,378 8% 2,870 2,000 870- -44% 7,944 15,985 8,041 50% 555 1,120 565 50% ----------- 146,829 ----------- 269,769 --------------------- 122,940 46% 118,894 234,306 115,412 49% 33,123 53,669 20,546 38% 7,770 15,216 7,446 49% 3,592 7,500 3,908 52% 870 2,700 1,830 68% 334 900 566 63% 916 1,600 684 43% 1,780 3,300 1,520 46% ---------------------- 167,277 ----------- 319,191 ---------- 151,914 48% Page 5 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Page 6 Quarterly Finance Report JANUARY 19, 2012 58.33% Yr Complete FUND ---------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % POLICE DEPARTMENT ----------- --------------------- ----------- 1000-413-420140-110 SALARIES -POLICE 902,073 1,769,544 867,471 49% 1000-413-420140-112 SALARIES -SEVERANCE 0 5,000 5,000 100% 1000-413-420140-114 SALARY -comptime buyout 6,604 4,000 2,604- -65% 1000-413-420140-121 OVERTIME (REG & AET OT) 38,274 70,000 31,726 45% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 1,528 25,000 23,472 94% 1000-413-420140-153 HEALTH INSURANCE 224,426 335,006 110,580 33% 1000-413-420140-155 RETIREMENT 117,134 233,749 116,615 50% 1000-413-420140-210 OFFICE SUPPLIES 1,996 3,500 1,504 43% 1000-413-420140-215 COMPUTER SUPPLIES 2,926 5,500 2,574 47% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 4,332 10,500 6,168 59% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,690 4,000 1,310 33% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 1,197 7,000 5,803 83% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 0 2,000 2,000 100% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 2,445 4,000 1,555 39% 1000-413-420140-227 AMMO & RELATED SUPPLIES 10,409 17,000 6,591 39% 1000-413-420140-228 PATROL CAR SUPPLIES 6,829 13,000 6,171 47% 1000-413-420140-229 OTHER SUPPLIES 872 3,500 2,628 75% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 589 1,000 411 41% 1000-413-420140-234 CRISIS NEGOTIATIONS 6 1,500 1,494 100% 1000-413-420140-235 BIKE PATROL 0 1,000 1,000 100% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 132 1,000 868 87% 1000-413-420140-320 PRINTING 1,645 5,000 3,355 67% 1000-413-420140-345 TELEPHONE & COMMUNICATION 7,951 15,500 7,549 49% 1000-413-420140-354 CONTRACT SERVICES 3,800 6,000 2,200 37% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 4,879 4,500 379- -8% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 0 4,000 4,000 100% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 143 2,000 1,857 93% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 5,435 20,000 14,565 73% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 2,950 2,500 450- -18% 1000-413-420140-373 DUES & TRAINING 10,595 27,250 16,655 61% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 304 12,000 11,696 97% 1000-413-420140-380 TRAINING MATERIALS 269 2,000 1,731 87% 1000-413-420140-388 MEDICAL SERVICES 0 3,500 3,500 100% 1000-413-420140-392 BOARDING/TREATING PRISONERS 606 1,500 895 60% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 28,600 57,200 28,600 50% 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-944 VEHICLES 74,913 75,000 87 0% 1000-413-420141-110 SALARIES -DETECTIVES 165,471 332,428 166,957 50% 1000-413-420141-121 DETECTIVE -OVERTIME 9,718 15,000 5,282 35% 1000-413-420141-153 HEALTH INSURANCE 37,484 56,346 18,862 33% 1000-413-420141-155 DETECTIVE -RETIREMENT 22,319 44,902 22,583 50% 1000-413-420142-110 SALARIES -RECORDS DIVISION 48,681 102,927 54,246 53% 1000-413-420142-121 OVERTIME 189 7,500 7,311 97% 1000-413-420142-153 HEALTH INSURANCE 7,540 13,968 6,428 46% 1000-413-420142-155 RETIREMENT 2,825 5,615 2,790 50% 1000-413-420144-110 SALARIES -SRO 56,364 117,630 61,266 52% 1000-413-420144-153 HEALTH INSURANCE 12,506 21,940 9,434 43% 1000-413-420144-155 SRO RETIREMENT 6,865 15,759 8,894 56% 1000-413-420145-110 ANIMAL CONTROL -SALARIES 6,708 30,000 23,292 78% 1000-413-420145-121 OVERTIME 42 300 258 86% 1000-413-420145-153 HEALTH INSURANCE 1,649 6,950 5,301 76% 1000-413-420145-155 RETIREMENT 420 1,900 1,480 78% 1000-413-420147-153 HEALTH INSURANCE 1,856 0 1,856- 0% SUBTOTAL POLICE DEPT. ----------- 1,872,188 ----------- 3,552,914 --------------------- 1,680,726 47% O1/19/12 CITY OF KALISPELL Page 7 Quarterly Finance Report JANUARY 19, 2012 58.33% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 629,239 1,369,945 740,706 54% 1000-416-420400-112 SALARY -SEVERANCE 7,173 10,000 2,827 28% 1000-416-420400-114 COMPTIME BUYOUT 2,442 5,000 2,558 51% 1000-416-420400-115 OUT OF RANK PAY 5,274 6,978 1,704 24% 1000-416-420400-121 OVERTIME 24,539 32,000 7,461 23% 1000-416-420400-153 HEALTH INSURANCE 151,260 270,825 119,565 44% 1000-416-420400-155 RETIREMENT 85,598 187,677 102,079 54% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 618 2,700 2,082 77% 1000-416-420400-218 Equipment (Non Capital) 5,010 7,500 2,490 33% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 15,118 15,000 118- -1% 1000-416-420400-224 JANITORIAL SUPPLIES 1,485 1,500 15 1% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 9,070 15,000 5,930 40% 1000-416-420400-320 PRINTING 134 700 566 81% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 80 1,250 1,170 94% 1000-416-420400-345 TELEPHONE & COMMUNICATION 2,563 8,500 5,937 70% 1000-416-420400-354 CONTRACT SERVICES 4,110 8,000 3,890 49% 1000-416-420400-362 EQUIPMENT MAINTENANCE 2,852 6,500 3,649 56% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 7,005 2,500 4,505- -180% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 5,858 10,500 4,642 44% 1000-416-420400-373 DUES & TRAINING 3,239 16,650 13,411 81% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 27,582 55,896 28,314 51% 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 5,667 10,875 5,208 48% 1000-416-420440-110 SALARIES -FIRE PREVENTION 20,298 38,414 18,116 47% 1000-416-420440-121 OVERTIME 323 500 177 35% 1000-416-420440-153 HEALTH INSURANCE 3,186 7,238 4,052 56% 1000-416-420440-155 RETIREMENT 1,291 2,514 1,223 490 SUBTOTAL FIRE DEPT. ----------- 1,021,016 ----------- 2,094,162 --------------------- 1,073,146 51% GRAND TOTAL GENERAL FUND 4,808,591 ----------- ----------- 9,220,464 ----------- ----------- 4,411,873 ----------- ---------- -------------------- 48% 2185-000-430300-353 2185-000-430300-356 2185-000-430300-522 2185-000-430300-840 2185-480-470240-110 2185-480-470240-153 2185-480-470240-155 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-720 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND ---------------------------- SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF AUDITING REDEVELOPMENT / CONTRACT SERVICES ADMINISTRATIVE TRANSFER REDEVELOPMENT ACTIVITY SALARIES HEALTH INSURANCE RETIREMENT TOTAL AIRPORT TIF 2188 WESTSIDE TIF SALARIES HEALTH INSURANCE RETIREMENT AUDIT TO PORT/GATEWAY W. BLDG MAINT. REDEVELOPMENT / CONTRACT SERVICES ADMINISTRATIVE TRANSFER TIF DISTRIBUTION TOTAL WESTSIDE TIF ACTUAL YTD BUDGET REMAINING % 0 1,200 1,200 100% 1,200 10,000 8,800 88% 6,879 11,792 4,913 42% 0 1,000,000 1,000,000 100% 9,237 18,218 8,981 49% 1,531 2,305 774 34% 602 1,185 583 49% ----------- 19,449 ----------- 1,044,700 --------------------- 1,025,251 98% 10,016 18,218 8,202 45% 2,029 2,305 276 12% 653 1,185 532 45% 1,200 1,250 50 4% 5,000 5,000 0 0% 4,659 8,702 4,043 46% 9,972 17,094 7,123 42% 465,000 ----------- 2,500,000 2,035,000 81% 498,528 ----------- 2,553,754 --------------------- 2,055,226 80% 2210 PARKS IN LIEU 2210-436-460430-826 TRANSFER TO ISTEA FUND 17,435 20,672 3,237 16% 2210-436-460430-934 CAPITAL IMPROVEMENTS 0 5,000 5,000 100% 2210-436-460430-936 LAWRENCE PARK IMPROVEMENTS 0 12,000 12,000 100% 2210-436-460430-937 WESTVIEW IMPROVEMENTS 0 15,000 15,000 100% ----------- TOTAL PARKS IN LIEU 17,435 ----------- 52,672 --------------------- 35,237 67% 2215 NEW PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 466,166 893,205 427,039 48% 2215-000-311200-000 PERSONAL PROPERTY TAXES 38,468 39,200 732 2% 2215-000-312000-000 PEN & INTEREST DEL TAXES 2,318 2,500 182 7% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 1,500 5,000 3,500 70% 2215-000-346030-000 SWIMMING POOL FEES 92,017 140,000 47,983 34% 2215-000-346040-000 CONCESSION STAND REVENUE 26,691 32,500 5,809 18% 2215-000-346050-000 Parks Usage Fees 7,797 19,000 11,204 59% 2215-000-346051-000 RECREATION FEES 4,792 10,000 5,208 52% 2215-000-346052-000 SPORTS PROGRAMS 12,948 40,800 27,853 68% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 531 3,500 2,969 85% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 27,343 32,580 5,237 16% 2215-000-346055-000 ICE RINK 5,560 21,000 15,440 74% 2215-000-346057-000 YOUTH CAMPS 33,519 78,000 44,481 57% 2215-000-346059-000 PICNIC IN THE PARK 4,543 26,000 21,457 83% 2215-000-365010-000 ROUND UP FOR SAFETY GRANT 0 1,740 1,740 100% 2215-000-371010-000 INVESTMENTS/DONATIONS/MISC.SALES 1,611 1,850 239 13% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 40,850 65,000 24,150 37% ----------- TOTAL PARKS & REC REVENUE 766,654 ---------------------- 1,411,875 ---------- 645,221 46% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 122,937 261,049 138,112 53% 2215-436-460430-111 SEASONAL SALARIES 28,393 36,855 8,462 23% 2215-436-460430-121 OVERTIME 354 1,000 646 65% 2215-436-460430-153 HEALTH INSURANCE 41,404 63,399 21,995 35% 2215-436-460430-155 RETIREMENT 8,550 18,539 9,989 54% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 328 2,100 1,772 84% 2215-436-460430-224 JANITORIAL SUPPLIES 1,770 3,500 1,730 49% 2215-436-460430-229 OTHER SUPPLIES 2,170 4,500 2,330 52% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,247 2,500 1,253 50% Page 8 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Page 9 Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % 2215-436-460430-320 PRINTING & ADVERTISING 213 506 293 58°% 2215-436-460430-341 ELECTRICITY 5,972 14,250 8,278 58% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 8,432 21,000 12,568 60% 2215-436-460430-344 NATURAL GAS 849 3,200 2,351 73% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 927 2,500 1,573 63% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 1,500 1,500 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 2,373 5,000 2,627 53% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 3,690 8,000 4,310 54% 2215-436-460430-364 LANDSCAPING 739 5,000 4,261 85% 2215-436-460430-367 VANDALISM REPAIRS 1,596 4,000 2,404 60% 2215-436-460430-373 DUES & TRAINING 900 2,700 1,800 67% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 380 600 220 37% 2215-436-460430-395 EQUIPMENT RENTAL 175 500 325 65% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 76 1,050 974 93% 2215-436-460430-440 IRRIGATION SUPPLIES 2,401 9,000 6,599 73% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 260 4,000 3,740 94% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 0 1,380 1,380 100% 2215-436-460430-620 DEBT SERVICE INTEREST 0 150 150 100% 2215-436-460430-920 EQUIPMENT 16,098 17,000 902 5% ----------- TOTAL PARKS EXPENDITURES 252,234 ---------------------- 496,278 ---------- 244,044 49% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 15,648 32,111 16,463 51% 2215-436-460440-111 SEASONAL SALARIES 22,006 52,045 30,039 58% 2215-436-460440-153 HEALTH INSURANCE 6,179 9,395 3,216 34% 2215-436-460440-155 RETIREMENT 1,575 4,158 2,583 62% 2215-436-460440-221 SAFETY EQUIPMENT 0 875 875 100% 2215-436-460440-229 OTHER SUPPLIES 3,947 17,500 13,553 77% 2215-436-460440-341 ELECTRICITY 5,291 5,600 309 6% 2215-436-460440-345 TELEPHONE & COMMUNICATION 122 300 178 59% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 221 700 479 68% 2215-436-460440-367 VANDALISM REPAIRS 770 300 470- -157% 2215-436-460440-373 DUES & TRAINING 60 135 75 56% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-440 IRRIGATION 1,546 3,400 1,854 55% 2215-436-460440-452 SAND & GRAVEL 676 1,000 324 32% 2215-436-460440-610 DEBT SERVICE -PRINCIPAL 7,581 13,763 6,182 45% 2215-436-460440-620 DEBT SERVICE -INTEREST 710 1,257 547 44% 2215-436-460440-920 CAPITAL IMPROVEMENTS (fencing) ----------- 6,350 ----------- 6,350 ----------- 0 ---------- 0% TOTAL ATHLETIC COMPLEX 72,680 150,039 77,359 52% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 42,477 89,823 47,346 53% 2215-436-460431-111 SEASONAL SALARIES 4,116 9,761 5,645 58% 2215-436-460431-153 HEALTH INSURANCE 13,006 19,659 6,653 34% 2215-436-460431-155 RETIREMENT 2,782 6,158 3,376 55% 2215-436-460431-218 DONATED SUPPLIES (donation FY11) 2,011 2,025 14 1% 2215-436-460431-229 MISC. SUPPLIES 3,816 9,625 5,809 60% 2215-436-460431-320 PRINTING & ADVERTISING 115 6,300 6,185 98% 2215-436-460431-345 TELEPHONE & COMMUNICATION 476 600 124 21% 2215-436-460431-354 CONTRACT SERVICES 12,781 19,450 6,669 34% 2215-436-460431-373 DUES & TRAINING 672 1,650 978 59% ----------- TOTAL RECREATION ---------- ----------- ----------- 82,251 ----------- ---------- ----------- 165,051 ---------- ---------- ---------- 82,800 --------- --------- 50% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 32,404 67,605 35,201 52% 2215-436-460448-111 SEASONAL SALARIES 52,289 74,692 22,403 30% 2215-436-460448-121 OVERTIME 17 500 483 97% 2215-436-460448-153 HEALTH INSURANCE 12,268 18,548 6,280 34% 2215-436-460448-155 RETIREMENT 2,046 5,662 3,616 64% 2215-436-460448-229 MISC. SUPPLIES 1,295 3,850 2,555 66% 2215-436-460448-320 PRINTING & ADVERTISING 58 450 392 87% 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2215-436-460448-345 TELEPHONE & COMMUNICATION 0 400 400 100% 2215-436-460448-354 CONTRACT SERVICES 6,324 12,600 6,276 50% 2215-436-460448-355 AFTER SCHOOL PROGRAM 542 2,500 1,958 78% 2215-436-460448-356 BANK FEES/CC CHARGES 1,418 2,500 1,082 43% 2215-436-460448-366 BLDG IMPROVEMENTS(Roundup 4 Safety) 0 1,740 1,740 100% 2215-436-460448-373 DUES & TRAINING 0 600 600 100% TOTAL YOUTH CAMPS ----------- 108,661 ----------- 191,647 ----------- ---------- 82,986 43% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 124,961 197,479 72,518 37% 2215-437-460445-121 OVERTIME 949 900 49- -5% 2215-437-460445-155 RETIREMENT 604 2,058 1,454 71% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 202 700 498 71% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,043 3,200 2,157 67% 2215-437-460445-226 CHLORINE/CHEMICALS 15,307 23,000 7,693 33% 2215-437-460445-228 CONCESSION STAND SUPPLIES 9,422 19,000 9,578 50% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 3,431 4,400 969 22% 2215-437-460445-341 ELECTRICITY 4,770 12,500 7,730 62% 2215-437-460445-344 NATURAL GAS 18,094 24,000 5,906 25% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 476 1,500 1,024 68% 2215-437-460445-354 LICENSES & FEES 731 1,300 569 44% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 2,281 8,200 5,919 72% 2215-437-460445-380 TRAINING MATERIALS 0 250 250 100% TOTAL POOL EXPENDITURES ----------- 182,270 ----------- 298,487 --------------------- 116,217 39% TOTAL PARKS & RECREATION/POOL 698,096 1,301,502 603,406 46% Page 10 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 291,108 605,000 313,892 52% 2230-000-342070-000 COUNTY EMS LEVY 43,510 85,000 41,490 49% 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC ill 200 89 45% 2230-000-371010-000 INTEREST EARNINGS 447 800 353 44% TOTAL AMBULANCE REVENUE ----------- 335,176 ----------- 691,000 --------------------- 355,824 51% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 172,675 397,702 225,027 57% 2230-440-420730-112 SEVERANCE 7,173 7,500 327 4% 2230-440-420730-114 COMPTIME BUYBACK 0 3,000 3,000 100% 2230-440-420730-115 OUT OF RANK PAY 0 1,647 1,647 100% 2230-440-420730-121 OVERTIME 1,204 12,000 10,796 90% 2230-440-420730-153 HEALTH INSURANCE 44,170 81,892 37,722 46% 2230-440-420730-155 RETIREMENT 23,420 56,373 32,953 58% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 726 3,500 2,774 79% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 1,697 2,500 803 32% 2230-440-420730-231 GAS & OIL 3,067 7,000 3,933 56% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 2,613 7,500 4,887 65% 2230-440-420730-312 POSTAGE/PRINTING 779 3,500 2,721 78% 2230-440-420730-345 TELEPHONE & COMMUNICATION 503 700 197 28% 2230-440-420730-354 PARAMEDIC RECERTIFICATION 4,799 12,000 7,201 60% 2230-440-420730-355 911 CENTER CONTRIBUTION 15,000 30,000 15,000 50% 2230-440-420730-359 AUDIT/CC OTHER FEES 767 1,400 633 45% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 7,507 8,000 493 6% 2230-440-420730-373 DUES & TRAINING 1,188 8,000 6,812 85% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 4,241 22,500 18,259 81% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 18,308 35,000 16,692 48% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 9,785 16,100 6,315 39% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 5,542 9,500 3,958 42% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 13,452 23,060 9,608 42% 2230-440-420730-528 DATA PROCESSING TRANSFER 6,232 10,683 4,451 42% TOTAL AMBULANCE FUND ----------- 344,845 ----------- 761,057 --------------------- 416,212 55% 2310 OLD SCHOOL TIF - TECH 2310-480-470210-354 CONTRACT SERVICES - BOND COUNSEL 0 1,000 1,000 100% 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 12,713 12,713 100% 2310-480-470210-356 FED -EX REIMBURSEMENT 10,908 10,910 2 0% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 25,000 40,000 15,000 38% TOTAL 2310 OLD SCHOOL TECH TIF ----------- 35,908 ----------- 64,623 --------------------- 28,715 44% 2311 OLD SCHOOL TIF INDUSTRIAL 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 7,000 18,000 11,000 61% TOTAL 2311 OLD SCHOOL INDUSTR. ----------- 7,000 ----------- 18,000 --------------------- 11,000 61% 2372 HEALTH PERMISIVE LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND 383,000 648,147 265,147 41% TOTAL 2372 HEALTH LEVY ----------- 383,000 ----------- 648,147 ----------- ---------- 265,147 41% Page 11 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 75,663 190,000 114,337 60% 2394-000-323103-000 PLUMBING PERMITS 7,790 15,000 7,210 48% 2394-000-323104-000 MECHANICAL PERMITS 11,504 22,000 10,497 48% 2394-000-323107-000 HOUSE MOVING PERMITS 0 200 200 100% 2394-000-323108-000 PLAN REVIEW FEES 26,571 60,000 33,429 56% 2394-000-371010-000 INVESTMENT EARNINGS 808 1,000 192 19% TOTAL REVENUE ----------- 122,336 ----------- 288,200 --------------------- 165,864 58% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 108,236 215,510 107,274 50% 2394-420-420530-121 OVERTIME 141 3,000 2,859 95% 2394-420-420530-153 HEALTH INSURANCE 28,164 43,492 15,328 35% 2394-420-420530-155 RETIREMENT 7,094 13,409 6,315 47% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 543 4,750 4,207 89% 2394-420-420530-231 GAS & OIL 1,138 2,250 1,112 49% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 170 2,600 2,430 93% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 2,500 2,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 598 1,500 902 60% 2394-420-420530-353 AUDITING 3,500 3,500 0 0% 2394-420-420530-354 CONTRACT SERVICES 837 1,300 463 36% 2394-420-420530-373 DUES & TRAINING 235 3,400 3,165 93% 2394-420-420530-510 PROPERTY INSURANCE 4,090 4,100 10 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 175 300 125 42% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 5,970 10,324 4,354 42% 2394-420-420530-528 DATA PROCESSING TRANSFER 2,438 4,179 1,741 42% TOTAL BUILDING DEPT. ----------- 163,328 ----------- 316,114 ----------- ---------- 152,786 48% 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 0 4,375 4,375 100% 2399-413-420140-354 IMPACT FEE REVIEW 0 500 500 100% 2399-413-420140-940 POLICE EQUIPMENT 0 40,000 40,000 100% 2399-416-420400-354 IMPACT FEE REVIEW 0 500 500 100% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 13,250 27,000 13,750 51% 2399-416-420400-620 INTEREST - FIRE TRUCK 4,322 8,162 3,840 47% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 200,000 200,000 100% TOTAL 2399 IMPACT FEE FUND ----------- 17,572 ----------- 280,537 --------------------- 262,965 94% 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 17,950 38,477 20,527 53% 2400-410-430263-153 HEALTH INSURANCE 4,794 9,295 4,501 48% 2400-410-430263-155 RETIREMENT 1,140 2,372 1,232 52% 2400-410-430263-244 STREET LIGHT SUPPLIES 9,198 13,000 3,802 29% 2400-410-430263-341 ELECTRICITY 75,541 163,000 87,459 54% 2400-410-430263-360 REPAIR & MAINT SERVICES 4,976 28,000 23,024 82% 2400-410-430263-510 INSURANCE 872 975 103 11% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 4,435 7,603 3,168 42% TOTAL LIGHT MAINT. ----------- 118,907 ----------- 262,722 --------------------- 143,815 55% Page 12 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % -- -------------------------------------------------------------------- 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 33,279 35,000 1,721 5% 2420-421-430234-957 ALLEY PAVING 30,742 45,000 14,258 32% 2420-421-430240-231 GAS & OIL 17,763 35,000 17,237 49% 2420-421-430240-344 NATURAL GAS 0 3,500 3,500 100% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 47,156 247,575 200,419 81% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 10,000 10,000 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 30,865 132,407 101,542 77% 2420-421-430240-369 RADIO EQUIPMENT & MAINT. 0 700 700 100% 2420-421-430240-452 GRAVEL 381 3,000 2,619 87% 2420-421-430240-453 MATERIALS; CONTRACT PREP. 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 14,172 45,000 30,828 69% 2420-421-430240-472 ASPHALT 15,191 30,000 14,809 49% 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 ----------- 189,548 ----------- 602,682 ----------- ---------- 413,134 69% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 271,022 583,985 312,963 54% 2500-421-430240-112 RETIREMENT -severance 6,663 8,500 1,837 22% 2500-421-430240-121 OVERTIME 2,423 30,000 27,577 92% 2500-421-430240-153 HEALTH INSURANCE 96,396 155,620 59,224 38% 2500-421-430240-155 RETIREMENT 17,531 36,388 18,857 52% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 2,992 5,000 2,008 40% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,639 2,200 561 26% 2500-421-430240-220 OTHER SUPPLIES 4,139 3,900 239- -6% 2500-421-430240-231 GAS & OIL 17,861 40,000 22,139 55% 2500-421-430240-341 ELECTRICITY 458 1,400 942 67% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 576 1,000 424 42% 2500-421-430240-354 CONTRACT SERVICES 5,762 12,500 6,738 54% 2500-421-430240-355 CONTRACT SERV.-AERIAL MAPPING 0 5,000 5,000 100% 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 13,550 28,000 14,450 52% 2500-421-430240-366 BUILDING MAINTENANCE 3,761 1,500 2,261- -151% 2500-421-430240-373 DUES & TRAINING 1,798 2,500 702 28% 2500-421-430240-388 MEDICAL SERVICES 852 1,100 249 23% 2500-421-430240-510 LIABILITY INSURANCE 78,797 85,000 6,203 7% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 36 10,000 9,964 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 38,500 66,000 27,500 42% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 37,746 64,707 26,961 42% 2500-421-430240-528 DATA PROCESSING TRANSFER 6,235 10,689 4,454 42% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 0 33,200 33,200 100% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 0 2,285 2,285 100% 2500-421-430240-840 MACI GRANT MATCH 0 40,000 40,000 100% 2500-421-430240-940 MACHINERY & EQUIPMENT 46,058 172,000 125,942 73% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 99,023 450,000 350,977 78% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 0 10,000 10,000 100% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 31,041 31,041 100% 2500-421-430264-110 TSS - SALARIES 64,353 140,306 75,953 54% 2500-421-430264-121 OVERTIME 4,983 8,500 3,517 41% 2500-421-430264-153 HEALTH INSURANCE 11,613 19,524 7,911 41% 2500-421-430264-155 RETIREMENT 4,302 8,862 4,560 51% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 355 1,500 1,145 76% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 7,203 8,600 1,397 16% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 2,187 2,250 63 3% 2500-421-430264-242 STREET SIGNS 26,632 40,000 13,368 33% 2500-421-430264-243 TRAFFIC SIGNALS 6,520 10,000 3,480 35% 2500-421-430264-245 BARRICADE MATERIALS 100- 4,500 4,600 102% 2500-421-430264-341 ELECTRICITY 3,429 9,000 5,571 62% 2500-421-430264-345 COMMUNICATIONS 423 700 277 40% 2500-421-430264-354 CONTRACT SERVICES 18,320 10,000 8,320- -83% 2500-421-430264-362 EQUIPMENT MAINTENANCE 1,795 2,500 705 28% 2500-421-430264-366 BUILDING MAINTENANCE 1,328 1,500 172 11% 2500-421-430264-373 DUES & TRAINING 1,650 2,500 850 34% 2500-421-430264-428 PAINT MATERIALS 4,445 15,000 10,555 70% Page 13 58.33% Yr Complete 01/19/12 CITY OF KALISPELL Page 14 Quarterly Finance Report JANUARY 19, 2012 58.33% 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-357 FORESTRY GRANT 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 TOTAL URBAN FORESTRY 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 SUED ($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,749 3,800 51 1% 0 2,400 2,400 100% 3,919 7,838 3,919 50% ----------- 920,923 ----------- 2,214,795 --------------------- 1,293,872 58% 68,632 149,472 80,840 54% 153 750 597 80% 21,939 33,893 11,954 35% 4,370 9,258 4,888 53% 162 550 388 71% 238 950 712 75% 0 500 500 100% 0 5,390 5,390 100% 6,270 14,000 7,730 55% 180 1,800 1,620 90% 4,735 7,500 2,765 37% 250 300 50 17% 3,489 4,000 511 13% 1,750 3,000 1,250 42% 3,865 6,625 2,760 42% 779 1,336 557 42% 2,086 4,136 2,050 50% 259 ----------- 447 188 42% 119,156 ----------- 243,907 --------------------- 124,751 51% 0 8,948 8,948 100% 0 4,336 4,336 100% 566 2,112 1,546 73% 0 667 667 100% 0 2,883 2,883 100% 0 17,831 17,831 100% 2,547 33,756 31,209 92% 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,113 ----------- 97,833 --------------------- 94,720 97% 01/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 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 28,215 56,230 28,015 50% 2886-480-470210-153 HEALTH INSURANCE 4,640 6,984 2,344 34% 2886-480-470210-155 RETIREMENT 1,844 3,638 1,794 49% 2886-480-470210-210 OFFICE SUPPLIES 245 2,500 2,255 90% 2886-480-470210-211 GRANT ADMIN. & PROJ. EXPENSES 35 3,000 2,965 99% 2886-480-470210-312 POSTAGE & PRINTING 825 1,150 325 28% 2886-480-470210-334 MT WEST MEMBERSHIP 0 500 500 100% 2886-480-470210-345 TELEPHONE & COMMUNICATION 166 250 84 34% 2886-480-470210-353 AUDITING 1,200 1,800 600 33% 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 661 3,800 3,139 83% 2886-480-470210-379 MEETINGS 445 500 55 11% 2886-480-470210-395 CDBG- GROWTH POLICY UPDATE 0 20,000 20,000 100% 2886-480-470210-396 GRANT SERVICES 3,220 25,000 21,780 87% 2886-480-470210-510 PROPERTY & LIABILITY INS. 2,896 3,000 104 3% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 3,296 5,651 2,355 42% 2886-480-470210-528 DATA PROCESSING TRANSFER 3,897 6,680 2,783 42% 2886-480-470210-532 OFFICE RENT 2,352 4,703 2,352 50% 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 2,500 2,500 100% TOTAL UDAG FUND ----------- 53,987 ----------- 151,886 ----------- ---------- 97,899 64% RURAL DEVELOPMENT REVOLVING 2887-480-470210-110 SALARIES 9,557 18,868 9,311 49% 2887-480-470210-153 HEALTH INSURANCE 1,578 2,675 1,097 41% 2887-480-470210-155 RETIREMENT 623 1,221 598 49% 2887-480-470210-610 DEBT SERVICE/PAIN-L#61-01 17,385 17,386 1 0% 2887-480-470210-620 INTEREST EXPENSE/1,461-01 4,689 4,689 0 0% 2887-480-470210-750 REDEVELOPMENT LOANS 85,000 200,000 115,000 58% TOTAL RURAL DEVELOPMENT ----------- 118,831 ----------- 244,839 --------------------- 126,008 51% 2888 RURAL DEV. #2 2888-480-470210-610 DEBT SERVICE/PAIN-L#61-02 7,990 7,731 259- -3% 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-02 2,035 2,283 248 11% 2888-480-470210-750 REDEVELOPMENT LOANS 27 85,000 84,973 100% TOTAL 2888 RURAL DEV. #2 ----------- 10,052 ----------- 95,014 --------------------- 84,962 89% 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 BRWNSFLD ASSESS/PETROLEUM 10,304 134,029 123,725 92% 2953-480-470210-781 BRWNSFLD ASSESS/HAZARDOUS SUBSTANCE 45,751 ----------- 134,029 ----------- 88,278 --------------------- 66% Page 15 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- TOTAL EPA BROWNSFIELD GRANT 56,055 268,058 212,003 79% 2954 EPA/BROWNFIELDS PLANNING ----------- ----------- ----------- ------------------- 2954-480-470210-354 AREA -WIDE PILOT PROGRAM 19,088 148,872 129,784 87% TOTAL 2954 EPA/BROWNFIELD PLAN ----------- 19,088 ----------- 148,872 --------------------- 129,784 87% 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN 6,245 ----------- 7,743 ----------- 1,498 19% TOTAL 2915 STONEGARDEN GRANT 6,245 7,743 ----------- ---------- 1,498 19% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 32,789 63,051 30,262 48% 2916-413-420140-121 OVERTIME 4,510 9,000 4,490 50% 2916-413-420140-153 HEALTH INSURANCE 4,640 6,984 2,344 34% 2916-413-420140-155 RETIREMENT 4,294 8,530 4,236 50% 2916-413-420140-210 OFFICE SUPPLIES 0 400 400 100% 2916-413-420140-354 CONTRACT SERVICES 2,224 3,000 776 26% TOTAL 2916 DRUG ENFORCEMENT ----------- 48,458 ----------- 90,965 --------------------- 42,507 47% 2917 COPS TECHNOLOGY GRANT 2917-413-420140-950 SHOOTING FACILITY/2009CKWX0478 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 27,510 50,329 22,819 45% 2918-413-420140-153 HEALTH INSURANCE 9,948 14,956 5,008 33% 2918-413-420140-155 RETIREMENT 3,593 6,809 3,216 47% TOTAL 2918 COPS HIRING GRANT ----------- 41,051 ----------- 72,094 --------------------- 31,043 43% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 104 1,030 926 90% 2919-413-420140-125 DUI TASK FORCE 1,226 8,000 6,774 85% 2919-413-420140-126 HOLIDAY OT REIMB. 17,871 50,000 32,129 64% 2919-413-420140-127 SCHOOL DIST. OT 6,744 20,000 13,256 66% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 0 2,500 2,500 100% 2919-413-420140-221 Bullet Proof Vests 4,995 ----------- 10,000 ----------- 5,005 50% TOTAL LAW ENF. GRANT 30,940 91,530 --------------------- 60,590 66% 2920 DOJ-IT UPGRADE SAFETY BLD 2920-480-470210-922 PUBLIC SAFETY BLDG -TECH UPGRADES 12,828 216,257 203,429 94% TOTAL 2920 IT UPGRADE -SAFETY ----------- 12,828 ----------- 216,257 ----------- ---------- 203,429 94% 2921 DRUG COURT GRANT 2921-406-410360-354 DRUG COURT -contract services 35,879 265,993 230,114 87% TOTAL DRUG COURT GRANT ----------- 35,879 ----------- 265,993 --------------------- 230,114 87% 2951 DUI COURT GRANT 2951-406-410360-355 CS-EVAL,P0,LAC/#2011-02-03-02 16,983 46,078 29,095 63% 2951-406-410360-396 DUI CRT INCENTIVES 430 0 430- 0% 2951-406-410361-354 CS-EVAL,PO,LAC CTS-106006 16,515 97,000 80,486 83% TOTAL DUI COURT GRANT ----------- 33,928 ----------- 143,078 --------------------- 109,150 76% Page 16 58.33% Yr Complete 01/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2930 PRESERVE AMERICA GRANT 2930-480-470240-354 PRESERVE AMERICA EXPENSES 6,172 69,323 63,151 91% ------------------------------------------- TOTAL 2930 PRESERVE AMERICA 6,172 69,323 63,151 91% 2927 CULTRUAL ARTS PASSTHRU GT 2927-400-460452-354 HOCKADAY 3,132 9,000 5,868 65% 2927-400-460454-354 GLACIER ORCHESTRA 0 13,000 13,000 100% 2927-400-460456-354 NW MT HISTORICAL SOCIETY 0 5,000 5,000 100% TOTAL 2927 CULTURAL ARTS 3,132 27,000 23,868 88% 2957 FEMA GRANT 2957-416-420400-110 SALARIES 2957-416-420400-121 OT-RESPONSE HAZMAT 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 RESPONSE HAZMAT-MATERIALS 2957-416-420400-373 RESPONSE HAZMAT-TRAVEL 2957-416-420410-125 PASS THRU HAZMAT OT 2957-416-420410-218 PASS THRU HAZMAT EQUIP 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 2957-416-420414-218 AFG-FIRE PREV MAT-EMW2010FP00286 TOTAL FEMA GRANT 2958 FEMA -GOLF COURSE PROD. 2958-420-431200-354 CONTRACT SERVICES TOTAL 2958 FEMA - GOLF PROD. 2975 ISTEA 2975-436-460457-950 WOODLAND CONNECTOR 2975-436-460457-951 HWY93 NORTH TRAIL TOTAL ISTEA 2991 NEIGHBORHOOD STABILIZATIO 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS TOTAL 2992 NEIGHBORHOOD STABIL 2992 ENERGY BLOCK GRANT 2992-412-411230-925 BUILDING ENERGY IMPROVEMENTS TOTAL 2992 ENERGY BLOCK GRANT 2993 STIMULUS ENERGY #2 2993-412-411230-925 ENERGY IMPROVEMENTS TOTAL 2993 STIMULUS ENERGY #2 2995 SAFER GRANT 2995-416-420400-110 SALARIES 2995-416-420400-153 HEALTH INSURANCE 2995-416-420400-155 RETIREMENT 0 10,000 10,000 100% 0 15,000 15,000 100% 0 1,564 1,564 100% 166 1,436 1,270 88% 8,806 8,350 456- -5% 1,331 6,000 4,669 78% 0 6,000 6,000 100% 0 20,000 20,000 100% 1,293 20,000 18,707 94% 13,972 56,200 42,228 75% 961 5,000 4,039 81% 6,388 ----------- 6,380 8- 0% 32,917 ----------- 155,930 --------------------- 123,013 79% 8,556 424,970 416,414 98% ----------- 8,556 ---------------------- 424,970 ---------- 416,414 98% 137,557 126,000 11,557- -9% 0 ----------- 30,000 30,000 100% ----------- 137,557 ----------- 156,000 ---------- 18,443 12% 64,656 ----------- 64,656 0 0% ----------- 64, 656 ---------------------- ----------- 64,656 ----------- ---------- 0 ---------- 0% 64, 656 ---------------------- 64,656 0 0% 64, 656 ----------- 64,656 ---------- 0 0% 61,896 ----------- ----------- 92,023 30,127 33% 61,896 ----------- 92,023 ---------- 30,127 33% 51,889 153,942 102,053 66% 18,812 42,023 23,211 55% 6,993 20,898 13,905 67% Page 17 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Page 18 Quarterly Finance Report JANUARY 19, 2012 58.33o Yr Complete FUND ---------------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % TOTAL 2995 SAFER GRANT ----------- 77,694 ----------- 216,863 ----------- ---------- 139,169 64% CAPITAL PROJECT FUNDS ----------- ----------- ----------- ---------- 4150 FIRE STATION ##61 REMODEL 4150-416-420400-928 FIRE STATION 61 CONSTRUCTION 3,109 10,608 7,500 71% TOTAL 4150 FIRE STATION REMODE ----------- 3,109 ----------- ----------- 10,608 ----------- --------------------- 7,500 --------------------- 71% 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 5,218 25,000 19,782 79% TOTAL 4290 WALK & CURB ----------- 5,218 ----------- 25,000 ----------- ---------- 19,782 79% 4300 FAA NON -PRIMARY ENTITLMNT 4300-430-430310-354 TOWER MITIGATION 0 600,000 600,000 1000 TOTAL FAA NP ENTITLEMENT ----------- 0 ----------- 600,000 --------------------- 600,000 100% 4312 FAA PLANNING GRANT 4312-430-430310-940 CAPITAL IMPROVEMENTS 20,563 65,975 45,412 69% TOTAL FAA PLANNING GRANT ----------- 20,563 ----------- 65,975 --------------------- 45,412 69% O1/19/12 FUND 5210-000-343210-000 5210-000-343220-000 5210-000-343225-000 5210-000-343230-000 5210-000-343260-000 5210-000-343265-000 5210-000-343270-000 5210-000-343275-000 5210-000-371010-000 5210-447-430550-110 5210-447-430550-112 5210-447-430550-121 5210-447-430550-153 5210-447-430550-155 5210-447-430550-210 5210-447-430550-218 5210-447-430550-226 5210-447-430550-229 5210-447-430550-231 5210-447-430550-312 5210-447-430550-336 5210-447-430550-341 5210-447-430550-344 5210-447-430550-345 5210-447-430550-349 5210-447-430550-353 5210-447-430550-354 5210-447-430550-355 5210-447-430550-356 5210-447-430550-362 5210-447-430550-366 5210-447-430550-373 5210-447-430550-388 5210-447-430550-410 5210-447-430550-422 5210-447-430550-423 5210-447-430550-424 5210-447-430550-425 5210-447-430550-510 5210-447-430550-512 5210-447-430550-513 5210-447-430550-521 5210-447-430550-522 5210-447-430550-528 5210-447-430550-532 5210-447-430550-935 5210-447-430550-940 5210-447-430550-944 5210-447-430550-948 5210-447-430550-951 5210-447-430550-956 5210-447-430550-958 5210-447-430550-963 5210-447-430550-964 5210-447-430550-965 5210-447-430555-930 5210-447-430555-941 5210-447-430555-953 FUND CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 ACTUAL YTD BUDGET ------------------------------------ ENTERPRISE FUNDS WATER REVENUE METERED WATER SALES UNMETERED WATER SALES IMPACT FEES METER REPLACEMENT FEE INSTALL/SALE OF MAT./TOWER RENT/OTH IMPACT ADMIN FEES WATER TURN ON FEES TAG FEE INVESTMENT EARNINGS TOTAL WATER REVENUE WATER FACILITIES SALARIES -WATER SALARIES -RETIREMENT OVERTIME HEALTH INSURANCE RETIREMENT OFFICE & COMPUTER SUPPLIES NON CAP & SAFETY EQUIP/SUPPLIES CHLORINE & CHEMICALS JANITORIAL/OTHER SUPPLIES GAS & OIL POSTAGE & PRINTING LICENSES & FEES ELECTRICITY NATURAL GAS TELEPHONE & COMMUNICATION LAB SERVICES AUDITING CONTRACT SERVICES CONTRACT SERV.-AERIAL MAPPING CONSULTANTS-WTR RIGHTS/MODELING EQUIP REPAIRS/MAINT/RENTAL BUILDING MAINTENANCE DUES & TRAINING MEDICAL SERVICES CONSTRUCTION MATERIALS HYDRANTS MATERIALS FOR MAINS MATERIALS -SERVICE LINES MATERIALS PUMPS/WELLS PROPERTY & LIABILITY INS. UNINSURED LOSS -DEDUCTIBLE UNINSURED LOSS -GOODWILL CENTRAL GARAGE TRANSFER ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER LEASE PAYMENTS ARMORY WELL GENERATOR REPLACEMENT MACHINERY & EQUIPMENT METER MAINTENANCE VEHICLE METERS (METER FUNDS) 010125 SECURITY SYSTEM UPGRADES UPPER/LOWER INTERCONNECTION FOUR (4) LOOPED PROJECTS ABANDON 2" H2O LINE 2ND AVE WN H2O LINE REPLACE E AZ H2O LINE UPSIZE CONTRACT MAIN UPSIZE METERS (NEW SERVICES)010120 SECTION 36 WELL TOTAL WATER FACILITIES 1,455,667 2,203,OOC 2,676 S,OOC 95,553 225,000 50,872 95,OOC 11,219 12,OOC 0 13,000 1,445 3,000 9,360 20,000 23,343 55,000 1,650,134 2,631,000 REMAINING % 747,333 34% 2,324 46% 129,447 58% 44,128 46% 781 7% 13,000 100% 1,555 52% 10,640 53% 31,657 58% ---------------------- 980,866 37°% 308,127 662,555 354,428 53% 6,192 7,000 808 12% 9,145 20,000 10,855 54% 86,146 146,924 60,778 41% 20,332 41,289 20,957 51% 3,305 12,450 9,145 73% 5,546 19,500 13,954 72% 20,389 38,000 17,611 46% 1,146 4,800 3,654 76% 13,027 29,000 15,973 55% 172 4,500 4,328 96% 0 19,000 19,000 100% 71,248 143,000 71,752 50% 4,587 13,000 8,413 65% 4,146 8,000 3,854 48% 5,726 25,500 19,774 78% 2,500 3,000 500 17% 23,868 70,000 46,132 66% 137 0 137- 0% 903 25,000 24,097 96% 9,952 14,950 4, 998 33% 5,801 17,000 11,199 66% 2,023 7,200 5,177 72% 357 700 343 49% 17,502 30,000 12,498 42% 8,666 15,000 6,334 42% 3,212 11,000 7,788 71% 6,295 9,000 2,705 30% 2,434 36,000 33,566 93% 33,193 34,500 1,307 4% 4,818 11,500 6,682 58% 0 7,500 7,500 100% 4,667 8,000 3,333 42% 53,191 91,185 37,994 42% 11,691 20,041 8,350 42% 4,670 7,838 3,168 40% 0 90,000 90,000 100% 0 45,000 45,000 100% 0 25,000 25,000 100% 30,623 75,000 44,378 59% 0 40,000 40,000 100% 29,515 30,000 485 2% 0 411,800 411,800 100% 0 45,000 45,000 100% 0 248,000 248,000 100% 0 195,000 195,000 100% 0 50,000 50,000 100% 30,403 65,000 34,598 53% 2,157 -------- 46,000 43,844 95% 847,810 ----------- 2,979,732 --------------------- 2,131,922 72% Page 19 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUA.RY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ---------- WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 43,584 89,596 46,012 51% 5210-447-430560-153 HEALTH INSURANCE 15,855 25,283 9,428 37% 5210-447-430560-155 RETIREMENT 2,824 5,823 2,999 52% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 1,409 3,225 1,816 56% 5210-447-430560-353 AUDITING 1,500 1,500 0 0% 5210-447-430560-354 CONTRACT SERVICES 731 5,000 4,269 85% 5210-447-430560-355 BILLING COSTS 16,310 27,775 11,465 41% 5210-447-430560-373 DUES & TRAINING 514 1,500 986 66% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 4,061 6,961 2,900 42% 5210-447-430560-528 DATA PROCESSING TRANSFER 12,857 22,041 9,184 42% 5210-447-430560-532 RENT 3,919 7,838 3,919 50% TOTAL WATER BILLING ----------- 103,564 ----------- ----------- 196,542 ----------- --------------------- 92,978 ----------- ---------- 47% REVENUE BONDS 5210-447-490204-610 2004 BOND PRINCIPAL (HWY93) 0 55,000 55,000 100% 5210-447-490204-620 2004 BOND INTEREST (HWY93) 41,195 41,195 0 0% 5210-447-490204-630 2004 BOND FISCAL AGENT FEES 300 300 0 0% 5210-447-490206-610 2007 BOND PRIN WRF 3.75% 0 186,000 186,000 100% 5210-447-490206-620 2007 BOND INT WRF 3.75% 76,651 76,651 0 0% 5210-447-490250-610 SRF 2001 PRINCIPAL 4% 0 39,000 39,000 100% 5210-447-490250-620 2001 SRF INTEREST 4% 17,340 17,340 0 0% TOTAL REVENUE BONDS ----------- 135,486 ----------- ----------- 415,486 ----------- --------------------- 280,000 --------------------- 67% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 825,000 825,000 100% TOTAL DEPRECIATION ----------- 0 ----------- ----------- 825,000 ----------- --------------------- 825,000 --------------------- 100% TOTAL WATER FUND 1,086,860 4,416,760 3,329,900 75% Page 20 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- SEWER REVENUE: 5310-000-343310-000 SEWER SERVICE CHARGES 1,962,002 3,730,000 1,767,998 47% 5310-000-343330-000 IMPACT FEES (SANITARY) 39,283 118,497 79,214 67% 5310-000-343335-000 IMPACT FEES (WWTP) 52,972 158,142 105,170 67% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 12,502 2,000 10,502- -525% 5310-000-371010-000 INVESTMENT EARNINGS 25,852 ----------- 65,000 39,148 60% TOTAL SEWER REVENUE 2,092,611 ----------- 4,073,639 --------------------- 1,981,028 49% EXPENDITURES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 35,562 73,305 37,743 51% 5310-454-430620-153 HEALTH INSURANCE 10,968 16,805 5,837 35% 5310-454-430620-155 RETIREMENT 2,299 4,685 2,386 51% 5310-454-430620-215 OFFICE SUPPLIES/computers 1,357 2,225 868 39% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 1,550 4,000 2,450 61% 5310-454-430620-355 BILLING COSTS 16,769 30,775 14,006 46% 5310-454-430620-373 DUES & TRAINING 403 1,400 997 71% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 3,385 5,803 2,418 42% 5310-454-430620-528 DATA PROCESSING TRANSFER 12,857 22,041 9,184 42% 5310-454-430620-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SEWER BILLING COSTS ----------- 89,070 ----------- ----------- 168,877 ----------- --------------------- 79,807 ----------- ---------- 47% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 99,978 267,961 167,983 63% 5310-454-430630-112 SALARIES-SEVERANCE/RETIREMENT 4,618 5,000 382 8% 5310-454-430630-121 OVERTIME 1,402 7,500 6,098 81% 5310-454-430630-153 HEALTH INSURANCE 30,949 62,496 31,547 50% 5310-454-430630-155 RETIREMENT 6,707 16,839 10,132 60% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2,356 6,200 3,844 62% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 1,349 8,500 7,151 84% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 631 2,300 1,669 73% 5310-454-430630-231 GAS & OIL 4,413 9,500 5,087 54% 5310-454-430630-312 POSTAGE 0 300 300 100% 5310-454-430630-341 ELECTRICITY 21,125 43,000 21,875 51% 5310-454-430630-342 WATER 0 175 175 100% 5310-454-430630-344 NATURAL GAS 6,003 13,000 6,997 54% 5310-454-430630-345 TELEPHONE & COMMUNICATION 10,612 21,700 11,088 51% 5310-454-430630-353 AUDITING 2,000 2,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 9,609 26,000 16,391 63% 5310-454-430630-356 CONSULTANTS 0 7,500 7,500 100% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 1,352 6,800 5,448 80% 5310-454-430630-373 DUES & TRAINING 987 2,500 1,513 61% 5310-454-430630-388 MEDICAL SERVICES 63 850 787 93% 5310-454-430630-410 CONSTRUCTION MATERIALS 1,280 9,000 7,720 86% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 8,327 15,000 6,673 44% 5310-454-430630-510 PROPERTY & LIABILITY INS. 65,059 67,000 1,941 3% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 2,788 18,000 15,212 85% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 1,458 2,500 1,042 42% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 37,083 63,571 26,488 42% 5310-454-430630-528 DATA PROCESSING TRANSFER 8,573 14,697 6,124 42% 5310-454-430630-532 OFFICE RENT 3,919 7,838 3,919 50% 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 0 25,500 25,500 100% TOTAL SANITARY SEWER/COLLECTIO ----------- 332,641 ----------- ----------- 733,227 ----------- --------------------- 400,586 ----------- ---------- 55% SANITARY SEWER PLANT INVEST $ 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 0 45,000 45,000 100% TOTAL SANITARY SEWER PLANT INV ----------- 0 ----------- ----------- 45,000 ----------- --------------------- 45,000 ----------- ---------- 100% REVENUE BONDS/SANITARY 5310-454-490204-610 PRINCIPAL-2004 BONDS(HWY 93 S) 0 66,000 66,000 100% Page 21 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 5310-454-490204-620 INTEREST-2004 BONDS 39,694 39,695 1 0% 5310-454-490204-630 FISCAL AGENT FEES 0 300 300 100% TOTAL REVENUE BONDS ----------- 39,694 ----------- ---------------------- 105,995 ---------------------- ---------- 66,301 ---------- 63% DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE TOTAL DEPRECIATION -SANITARY 0 815,000 815,000 100% ------------------------------------------- 0 815,000 815,000 100% ------------------------------------------- TOTAL SANITARY SEWER 372,335 1,699,222 1,326,887 78% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 165,652 361,807 196,155 54% 5310-455-430640-112 SALARIES -RETIREMENT 1,078 0 1,078- 0% 5310-455-430640-121 OVERTIME 9,728 21,000 11,272 54% 5310-455-430640-153 HEALTH INSURANCE 38,447 65,761 27,314 42% 5310-455-430640-155 RETIREMENT 11,080 22,469 11,389 51% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 166 5,000 4,834 97% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 1,070 2,500 1,430 57% 5310-455-430640-225 ALUM 0 30,000 30,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 328 12,000 11,673 97% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 2,574 6,500 3,926 60% 5310-455-430640-231 GAS & OIL 7,473 11,000 3,527 32% 5310-455-430640-312 POSTAGE 88 300 212 71% 5310-455-430640-336 LICENSES & FEES 343 10,000 9,657 97% 5310-455-430640-341 ELECTRICITY 78,139 170,000 91,861 54% 5310-455-430640-342 WATER 2,978 6,500 3,522 54% 5310-455-430640-344 NATURAL GAS 20,676 55,000 34,324 62% 5310-455-430640-345 TELEPHONE & COMMUNICATION 2,147 5,500 3,353 61% 5310-455-430640-353 AUDITING 2,750 2,750 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 57,527 123,000 65,473 53% 5310-455-430640-355 OTHER CONTRACT SERVICES 16,997 38,000 21,003 55% 5310-455-430640-356 CONSULTANTS 1,445 25,000 23,555 94% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 5310-455-430640-360 MISC. MAINT SERVICES 2,634 18,000 15,366 85% 5310-455-430640-366 BUILDING MAINTENANCE 1,048 2,300 1,252 54% 5310-455-430640-373 DUES & TRAINING 2,047 9,100 7,053 78% 5310-455-430640-388 MEDICAL SERVICES 99 550 451 82% 5310-455-430640-510 PROPERTY & LIABILITY INS. 41,680 42,500 820 2% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 2,333 4,000 1,667 42% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 71,516 122,598 51,083 42% 5310-455-430640-528 DATA PROCESSING TRANSFER 10,911 18,705 7,794 42% 5310-455-430640-940 MACHINERY & EQUIPMENT 0 30,000 30,000 100% TOTAL WWTP OPERATIONS ----------- 552,954 ----------- 1,236,840 --------------------- 683,886 55% WWTP REPLACEMENT ----------- ----------- --------------------- 5310-455-430645-362 EQUIPMENT MAINTENANCE 28,248 80,000 51,752 65% 5310-455-430645-940 MACHINERY & EQUIPMENT 17,595 173,500 155,905 90% TOTAL WWTP REPLACEMENT ----------- 45,843 ----------- ----------- 253,500 ----------- --------------------- 207,657 ----------- ---------- 82% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 57,014 113,243 56,229 50% 5310-455-430646-153 HEALTH INSURANCE 12,023 18,095 6,072 34% 5310-455-430646-155 RETIREMENT 3,558 6,997 3,439 49% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 0 1,850 1,850 100% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 616 3,000 2,384 79% 5310-455-430646-222 LAB SUPPLIES 4,243 9,000 4,758 53% 5310-455-430646-312 POSTAGE & SHIPPING 0 500 500 100% 5310-455-430646-349 LAB SERVICES 5,847 20,000 14,153 71% 5310-455-430646-362 EQUIPMENT MAINTENANCE 589 4,500 3,912 87% 5310-455-430646-373 DUES & TRAINING 277 2,700 2,423 90% Page 22 58.33% Yr Complete O1/19/12 FUND CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND ACTUAL YTD BUDGET REMAINING % ------------------------------ TOTAL WWTP LAB OPERATIONS SRF LOAN/WWTP 5310-455-490215-610 DEBT SRF 92003-PRINCIPAL 5310-455-490215-620 DEBT SRF 92003-INTEREST TOTAL SRF LOAN/WWTP DEBT SERVICE SRF -new constr. 5310-455-490227-610 SRF 2007WWTP PRINCIPAL 5310-455-490227-620 SRF 2007WWTP INTEREST SUBTOTAL SRF 2007 TOTAL WWTP DEBT CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-831 CITY/EVERGREEN RESERVE TRANSFER TOTAL DEPRECIATION TOTAL WWTP TOTAL BILLING/SANITARY/WWTP ----------------------------------------------- ----------- 84,167 ----------- 179,885 --------------------- 95,718 53% 0 271,000 271,000 100% 13,760 13,760 0 0% ----------- 13,760 ----------- ----------- 284,760 ----------- --------------------- 271,000 --------------------- 95% 0 460,000 460,000 100% 501,975 501,975 0 0% ----------- 501,975 ----------- ----------- 961,975 --------------------- 460,000 48% 515,735 ----------- ----------- 1,246,735 ----------- --------------------- 731,000 --------------------- 59% 0 ----------- 1,836,599 1,836,599 100% 0 ----------- ----------- 1,836,599 ----------- --------------------- 1,836,599 --------------------- 100% 1,198,699 4,753,559 3,554,860 75% ----------- 1, 660, 103 ----------- 6,621,658 --------------------- 4,961,555 75% Page 23 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Page 24 Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % STORM SEWER REVENUE 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 2,416 0 2,416- 0% 5349-000-343033-000 IMPACT FEES 33,966 105,000 71,034 68% 5349-000-343034-000 PERMIT FEES 345 1,200 855 71% 5349-000-343035-000 STORM SEWER CHARGES 0 300 300 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 821,130 820,000 1,130- 0% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,889 7,500 4,611 61% 5349-000-371010-000 INTEREST ON INVESTMENTS 14,547 22,000 7,453 34% ----------- TOTAL STORM REVENUE 875,293 ----------- 956,000 ----------- ---------- 80,707 8% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 141,642 333,163 191,521 57% 5349-453-430246-112 SEVERANCE 4,619 7,000 2,381 34% 5349-453-430246-121 OVERTIME 1,116 5,000 3,884 78% 5349-453-430246-153 HEALTH INSURANCE 39,304 75,239 35,935 48% 5349-453-430246-155 RETIREMENT 9,375 21,041 11,666 55% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 3,924 9,100 5,176 57% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 1,902 3,500 1,598 46% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 44 2,200 2,156 98% 5349-453-430246-231 GAS & OIL 4,413 10,500 6,087 58% 5349-453-430246-345 TELEPHONE & COMMUNICATION 499 850 351 41% 5349-453-430246-353 AUDITING 550 600 50 8% 5349-453-430246-354 CONTRACT SERVICE 1,532 6,200 4,668 75% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 1,693 20,000 18,307 92% 5349-453-430246-357 RATE STUDY 0 8,000 8,000 100% 5349-453-430246-358 IMPACT STUDY 0 7,000 7,000 100% 5349-453-430246-359 CONSULTANTS-TMDL 5,169 15,000 9,831 66% 5349-453-430246-360 REPAIR & MAINT SERVICES 174 1,500 1,326 88% 5349-453-430246-362 GROUNDWATER MONITORING 6,095 25,000 18,905 76% 5349-453-430246-371 CURB & GUTTER 510 5,000 4,490 90% 5349-453-430246-373 DUES & TRAINING 1,080 3,500 2,420 69% 5349-453-430246-388 MEDICAL SERVICES 0 250 250 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 1,933 10,000 8,067 81% 5349-453-430246-510 PROPERTY & LIABILITY INS. 6,969 8,500 1,531 18% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 1,458 2,500 1,042 42% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 17,719 30,376 12,657 42% 5349-453-430246-528 DATA PROCESSING TRANSFER 3,117 5,344 2,227 42% 5349-453-430246-530 BNSF LEASE PMT 4,902 5,200 298 6% 5349-453-430246-532 OFFICE RENT 3,919 7,838 3,919 50% 5349-453-430246-952 STORM DRAIN CORRECTION 2,563 100,000 97,437 97% 5349-453-430246-954 S MEADOWS SURVEY 13,409 304,700 291,291 96% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 30,000 30,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 45,000 45,000 100% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 260,000 260,000 100% ----------- TOTAL STORM 279,631 ----------- 1,369,101 --------------------- 1,089,470 80% 58.33% Yr Complete O1/19/12 FUND 5510-000-343410-000 5510-000-343420-000 5510-000-363040-000 5510-000-365000-000 5510-000-371010-000 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND ------------------------------ SOLID WASTE REVENUE: GARBAGE COLLECTION -ASSESSED GARBAGE COLLECTION -BILLED PEN & INT ON SPEC ASSESS. FEC- LIGHTING REBATE INVESTMENT EARNINGS TOTAL SOLID WASTE REVENUE ACTUAL YTD BUDGET REMAINING % ----------------------------------------------- 807,389 800,000 7,389- -1% 17,769 8,000 9,769- -122% 4,086 3,500 586- -17% 2,390 0 2,390- 0% 2,836 ----------- 3,500 664 19% 834,470 ----------- 815,000 --------------------- 19,470- -2% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 147,144 351,409 204,265 58% 5510-460-430840-112 SEVERANCE -RETIREMENT 0 5,500 5,500 100% 5510-460-430840-121 OVERTIME 827 7,500 6,673 89% 5510-460-430840-153 HEALTH INSURANCE 33,899 74,749 40,850 55% 5510-460-430840-155 RETIREMENT 9,294 21,804 12,510 57% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,054 3,500 2,446 70% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 20,533 20,000 533- -3% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 764 5,500 4,736 86% 5510-460-430840-231 GAS & OIL 23,600 50,000 26,400 53% 5510-460-430840-341 ELECTRICITY 659 1,700 1,041 61% 5510-460-430840-344 NATURAL GAS 1,523 4,000 2,477 62% 5510-460-430840-345 TELEPHONE & COMMUNICATION 299 700 401 57% 5510-460-430840-354 CONTRACT SERVICES 2,590 12,000 9,410 78% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 560 5,700 5,140 90% 5510-460-430840-366 BUILDING MAINTENANCE 3,099 2,500 599- -24% 5510-460-430840-373 DUES & TRAINING 614 2,500 1,886 75% 5510-460-430840-388 MEDICAL SERVICES 228 500 273 55% 5510-460-430840-510 PROPERTY & LIABILITY INS. 10,036 12,500 2,464 20% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 230 6,500 6,270 96% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 15,167 26,000 10,833 42% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 17,404 29,835 12,431 42% 5510-460-430840-528 DATA PROCESSING TRANSFER 5,456 9,353 3,897 42% 5510-460-430840-532 OFFICE RENT 3,919 7,838 3,919 50% 5510-460-430840-944 VEHICLES (Replacement $) 230,384 260,000 29,616 11% 5510-460-430845-224 JANITORIAL SUPPLIES 0 350 350 100% 5510-460-430845-341 ELECTRICITY 1,502 3,200 1,698 53% 5510-460-430845-342 WATER 344 350 6 2% 5510-460-430845-344 NATURAL GAS 3,319 8,500 5,181 61% 5510-460-430845-360 REPAIR & MAINT SERVICES 403 2,500 2,097 84% 5510-460-510400-831 DEPRECIATION EXPENSE 0 125,000 125,000 100% TOTAL SOLID WASTE EXPENSE ----------- 534,851 ---------------------- 1,061,488 ---------- 526,637 50% Page 25 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Quarterly Finance Report JANUARY 19, 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ------------------------------------------------------------ 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 5,565 7,200 1,635 23% 5160-000-343063-000 TIE DOWN FEES 1,420 3,500 2,080 59% 5160-000-343069-000 HANGER LEASES 9,450 12,000 2,550 21% 5160-000-343071-000 HANGAR SITE LEASES 16,503 15,600 903- -6% 5160-000-343101-000 F80 LEASE -RED EAGLE AVIATION 9,908 17,000 7,092 42% 5160-000-343102-000 GROUND LEASES 11,385 11,385 0 0% 5160-000-343620-000 FUEL TAX 2,999 5,500 2,501 45% 5160-000-371010-000 INVESTMENT EARNINGS 11,010 16,500 5,490 33% TOTAL AIRPORT REVENUE ----------- 68,240 ----------- 88,685 --------------------- 20,445 23% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 17,506 33,744 16,238 48% 5160-430-430310-111 SEASONAL SALARIES 1,261 3,262 2,002 61% 5160-430-430310-153 HEALTH INSURANCE 2,842 4,586 1,744 38% 5160-430-430310-155 RETIREMENT 1,193 2,406 1,213 50% 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 284 1,150 866 75% 5160-430-430310-341 ELECTRICITY 782 1,500 718 48% 5160-430-430310-345 TELEPHONE 385 1,000 615 62% 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 1,581 5,800 4,219 73% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 700 6,000 5,300 88% 5160-430-430310-357 CONTRACT SERVICES - legal 3,548 10,000 6,452 65% 5160-430-430310-362 REPAIR & MAINTENANCE 451 4,000 3,549 89% 5160-430-430310-367 MAINTENANCE BY PUBLIC WORKS 0 2,000 2,000 100% 5160-430-430310-373 DUES & TRAINING 621 1,900 1,279 67% 5160-430-430310-390 EQUIPMENT RENTAL 1,295 2,000 705 35% 5160-430-430310-510 PROPERTY INSURANCE 1,046 5,000 3,954 79% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 1,647 2,823 1,176 42% 5160-430-430310-528 DATA PROCESSING TRANSFER 1,559 2,672 1,113 42% 5160-430-430310-820 DEPRECIATION 0 100,832 100,832 100% 5160-430-430310-950 CONSTRUCTION IN PROGRESS 0 63,010 63,010 100% TOTAL AIRPORT OPERATIONS ----------- 36,700 ----------- 253,685 --------------------- 216,985 86% DATA PROCESSING REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 87,469 174,937 87,469 50% 6030-000-364030-000 SALE OF MISCELLANEOUS 21 200 179 90% 6030-000-371010-000 INVESTMENT EARNINGS 669 1,500 831 55% 6030-000-393000-000 INTERNAL SERVICES -DATA 86,602 148,461 61,859 42% TOTAL DATA PROCESSING REVENUE ----------- 174,760 ----------- 325,098 --------------------- 150,338 46% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 40,397 96,524 56,127 58% 6030-401-410580-153 HEALTH INSURANCE 9,790 21,940 12,150 55% 6030-401-410580-155 RETIREMENT 2,639 6,267 3,628 58% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 0 3,777 3,777 100% 6030-403-410580-215 COMPUTER SUPPLIES 894 2,850 1,956 69% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 4,724 12,060 7,336 61% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 1,782 12,550 10,768 86% 6030-403-410580-346 SUMMIT NET T1 CONTRACT 28 5,196 5,168 99% 6030-403-410580-353 LASER FICHE MAINTENANCE 1,558 1,600 42 3% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 4,425 4,400 25- -1% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 12,315 28,759 16,444 57% 6030-403-410580-357 GRANICUS 5,940 6,000 60 1% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 9,918 16,440 6,522 40% 6030-403-410580-373 DUES & TRAINING 471 5,200 4,729 91% 6030-403-410580-510 INSURANCE 1,163 1,350 187 14% 6030-403-410585-229 COPIER,FAX, SUPPLIES 503 5,000 4,497 90% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 30,819 70,000 39,181 56% 6030-403-410585-532 COPIER LEASES 13,905 32,000 18,095 57% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 1,209 3,162 1,953 62% 6030-405-410588-218 COMPUTERS - FIBER AND INSTALLATION 0 6,500 6,500 100% 6030-405-410588-940 COMPUTERS - SWITCHES 0 7,500 7,500 100% 6030-405-410588-942 COMPUTERS - CAPITAL OR CONTINGENCY 0 10,000 10,000 100% 6030-410-410588-218 COMPUTERS - DPW 1,500 4,510 3,010 67% Page 26 58.33% Yr Complete O1/19/12 CITY OF KALISPELL Page 27 Quarterly Finance Report JANUARY 19, 2012 58.33% Yr Complete FUND FUND ----------------------------- 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 ACTUAL YTD BUDGET REMAINING % 0 9,355 9,355 100% 204 4,005 3,801 95% 0 2,135 2,135 1000 516 3,052 2,536 83% TOTAL DATA PROCESSING EXPENSE 144,700 387,132 242,432 63% CITY OF KALISPELL FINANCE DEPARTMENT REPORT December 31, 2011 CASH RECONCILEMENT AT THE CLOSE OF BUSINESS ON PETTY CASH GLACIER BANK: GLACIER BANK CHECKING GLACIER BANK BOND RESERVE (2007 - WATER PROJ) GLACIER BANK BOND RESERVE (2007 - W WTP) RURAL DEV GRANT ACCT GLACIER BANK NOW ACCOUNT TOTAL GLACIER BANK ►IIIIIa;i: ell]] ."M MULTI -BANK SECURITIES, INC 3133735L2 3134G2LY6 3134G2US9 3135GODJ9 3136FRX65 3134G2Z39 3136FTDD8 3136FTRQ4 TOTAL MULTI -BANK SECURITIES SIDEWALK & CURB WARRANTS December 31, 2011 $ 2,330.00 $ 13,789,57 0.35% $ 255,348.53 0.35% $ 740,902.00 0,35% $ 301,133.26 0.35% $ 12,432,084.93 0.35% $ 13,743,258.29 $ 1,509.33 0.27% $ 300,000.00 3.25% $ 1,000,000.00 2.00% $ 1,000,000.00 1.75% $ 1,000,000.00 1.45% $ 1,000,000.00 1.50% $ 1,000,000.00 1.50% $ 1,000,000.00 1.50% $ 2,000,000.00 1.50% TOTAL TO BE ACCOUNTED FOR: $ 8,300,000.00 $ 42,194.17 S 22,089,291.79 Respectfully Submitted, .`Jura'Z 1` l City Treasurer Note: Multibank Securities are step ups with rates that increase periodically or are called when rates increase. THE CITY OF KALISPELL, MONTANA FINANCE DEPARTMENT REPORT December 31, 2011 ANALYSIS OF PLEDGED SECURITIES AT THE CLOSE OF BUSINESS BANK ACCOUNTS: GLACIER BANK DEMAND DEPOSITS CHECKING BOND RESERVE (Water) BOND RESERVE (WWTP) RURAL DEVELOPMENT GRANT A/C GLACIER BANK NOW ACCT TOTAL GLACIER BANK: STATE INV. POOL: GENERAL MULTI -BANK SECURITIES 3133735L2 3134G2LY6 3134G2US9 3135GODJ9 3136FRX65 3134G2Z39 3136FTDD8 3136FTRQ4 TOTAL MULTIBANK SIDEWALK & CURB WARRANTS PETTY CASH TOTAL DEPOSITS: Respectfully Submitted, City Treasurer December 31, 2011 BALANCE PLEDGE AMT.,', $ 13,789.57 $ 250,000.00 FDIC $ 255,348.53 $ 740,902.00 $ 301,133.26 $ 12,432,084.93 $ 14,867,859.57 FHLMC+MUNIBONDS $ 13,743,258.29 $ 15,117,859.57 $ 1,509.33 $1,509.33 $ 300,000.00 $ 300,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 2,000,000.00 $ 2,000,000.00 $ 8,300,000.00 S 8,300,000.00 $ 42,194.17 CITY $ 2,330.00 CITY $ 22,089,291.79 $ 23,419,368.90 01/19/12 CITY OF KALISPELL DECEMBER 31, 2011 CASH ACCT # CASH ACCT LABEL M/E CASH -------------------------------------------------------------------- 1000-000-010100-000 CASH, GENERAL FUND OPERATIONS 749,498.94 1000-000-010102-000 CASH, PETTY CASH 1,280.00 1000-000-010105-000 CASH, DESIGNATED PARKING SPACE 23,541.98 1000-000-010107-000 CASH, DESIGNATED:CAPITAL EQUIP 101,905.92 1000-000-010109-000 CASH, DESIGNATED BANDSHELL 12,525.94 2185-000-010100-000 CASH, AIRPORT TAX INCREMENT 1,538,478.59 2188-000-010100-000 CASH, WESTSIDE TAX INCREMENT 1,941,193.69 2210-000-010100-000 CASH, PARKS IN LIEU OF 37,319.95 2215-000-010100-000 CASH, PARKS & RECREATION 157,870.89 2215-000-010103-000 CASH, PETTY CASH 2O0.00 2215-000-010107-000 CASH, DESIGNATED CAPITAL 15,404.64 2230-000-010100-000 CASH, AMBULANCE 52,496.74 2310-000-010100-000 CASH, OLD SCHOOL TIF/TECH 6,614.53 2311-000-010100-000 CASH, OLD SCHOOL TIF/INDUSTRIA 463.38 2372-000-010100-000 CASH, HEALTH INS. 854.71 2394-000-010100-000 CASH, BUILDING DEPT. 111,999.65 2399-000-010100-000 CASH, ADMIN FEES 3,017.88 2399-000-010172-000 CASH, POLICE IMPACT FEES 35,607.89 2399-000-010173-000 CASH, FIRE IMPACT FEES 166,563.49 2400-000-010100-000 CASH, LIGHT MAINTENANCE 149,742.74 2420-000-010100-000 CASH, GAS TAX STREET DEPT. 340,115.03 2500-000-010100-000 CASH, SPECIAL STREET MAINTENAN 677,925.00 2500-000-010107-000 CASH, STREET DESIGNATED EQUIPM 15,473.94 2500-000-010108-000 CASH, S & C REPAIR ACCOUNT 47,517.87 2500-000-010109-000 CASH, STREET FOR PAVEMENT REPL 170,752.58 2500-000-010120-000 CASH, TRANSPORTATION IMPACT FE 135,440.27 2600-000-010100-000 CASH, URBAN FORESTRY 42,620.85 2601-000-010100-000 CASH, DEVELOPER TREES 94,720.68 2700-000-010100-000 CASH, BUSINESS IMPROVMENT DIST 126,154.91 2880-000-010100-000 CASH, COMMUNITY DEV.LOAN REVOL 318,330.77 2880-000-010162-000 CASH, INVESTMENT S & C 42,194.13 2886-000-010100-000 CASH, UDAG OPERATING 316,839.18 2887-000-010100-000 CASH, RURAL DEV. LOAN REVOLVIN 161,418.74 2887-000-010140-000 CASH, 61-01 LOAN LOSS RESERVE 14,292.26 2888-000-010100-000 CASH, RURAL DEV LOAN REVOLVING 115,606.94 2888-000-010140-000 CASH, LOAN LOSS RESERVE 9,339.90 2915-000-010100-000 CASH, STONEGARDEN GRANT 3,052.15- 2916-000-010100-000 CASH, DRUG ENFORCEMENT GRANT 13,844.36- 2918-000-010100-000 CASH, COPS CHRP HIRING GRT 18,871.52- 2918-000-010130-000 CASH, COPS designated for 4th 45,000.00 2919-000-010100-000 CASH, LAW ENF. GRANTS 8,325.93- 2920-000-010100-000 CASH, BUR OF JUSTICE -IT UPGRA 6,989.87- 2921-000-010100-000 CASH, DRUG COURT GRANT 9,915.82- 2930-000-010100-000 CASH, PRESERVE AMERICA GRANT 6,172.32- 2951-000-010100-000 CASH, KAL DUI COURT GRANT 18,197.90- 2953-000-010100-000 CASH, EPA BROWNFIELDS GRANT 39,048.24- 2954-000-010100-000 CASH, BROWNFIELDS AREAWIDE PLA 5,067.97- 2955-000-010100-000 CASH, BROWNFIELDS REVOLVING LO 7,474.95- 2957-000-010100-000 CASH, FIRE GRANTS 58,635.03 2958-000-010100-000 CASH, FEMA GOLF COURSE GRANT 154,890.33 2975-000-010100-000 CASH, CTEP (ISTEA) 2,179.03 2992-000-010100-000 CASH, ENERGY EFFICIENCY BLOCK .11 2993-000-010100-000 CASH, ENERGY E & C BLOCK GRANT 6,486.00- 2995-000-010100-000 CASH, SAFER GRANT 40,074.73- 3010-000-010100-000 CASH, G.O.BOND 2002-POOL 87,504.44 3162-000-010100-000 CASH, G.O.BOND FIRE HALL 111,172.48 3170-000-010100-000 CASH, CITY HALL DEBT SERVICE 317.85 3185-000-010100-000 CASH, AIRPORT TIF BONDS 152,808.37 3185-000-010130-000 CASH, AIRPORT TIF BOND RESERVE 184,875.00 3500-000-010100-000 CASH, SID REVOLVING FUND 260,180.25 3603-000-010100-000 CASH, 2003 SIDEWALK & CURB 34.40- 3604-000-010100-000 CASH, 2004 SIDEWALK & CURB 3,370.44 3605-000-010100-000 CASH, 2005 SIDEWALK & CURB 934.49 3607-000-010100-000 CASH, 2007 SIDEWALK & CURB 1,227.78 3608-000-010100-000 CASH, 2008 SIDEWALK & CURB 561.20 3609-000-010100-000 CASH, 2009 SIDEWALK & CURB 180.82 3610-000-010100-000 CASH, 2010 SIDEWALK & CURB 53.59 3643-000-010100-000 CASH, SID 343 9,900.44- Page 1 O1/19/12 CITY OF KALISPELL DECEMBER 31, 2011 CASH ACCT # CASH ACCT LABEL M/E CASH -------------------------------------------------------------------- 3643-000-010130-000 CASH, SID 343 BOND RESERVE 79,075.00 3644-000-010100-000 CASH, SID 344 78,500.53 3644-000-010130-000 CASH, SID 344 BOND RESERVE 226,000.00 4290-000-010100-000 CASH, SIDEWALK & CURB CONSTRUC 5,217.63- 4312-000-010100-000 CASH, FAA PLANNING GRT 2,498.00 5160-000-010100-000 CASH, AIRPORT OPERATIONS 111,114.71 5160-000-010120-000 CASH, DESIGNATED CAPITAL IMPRO 40,000.00 5160-000-010130-000 CASH, AIRPORT LAND SALE FUNDS 69,945.96 5210-000-010100-000 CASH, WATER OPERATIONS 2,746,563.86 5210-000-010102-000 CASH, WATER PETTY CASH 400.00 5210-000-010120-000 CASH, WATER IMPACT FEES 506,154.39 5210-000-010125-000 CASH, WATER METER REPLACEMENT 286,084.01 5210-000-010127-000 CASH, CAPITAL & EMERGENCY($400 340,000.00 5210-000-010130-000 CASH, BOND RESERVE (10% orig b 260,100.00 5210-000-010131-000 CASH, BOND RESERVE (2007) 255,348.53 5210-000-010194-000 CASH, 2004 HWY 93 S 4% S & I 27,500.00 5210-000-010195-000 CASH, 2007B 3.75% WTR TANK S & 396.85 5210-000-010196-000 CASH, 2007A 3.75% METERS/HYD S 259.35- 5210-000-010199-000 CASH, 2001 SRF LOAN 4% S & I 310.00 5310-000-010100-000 CASH, SEWER & WWTP OPERATIONS 161,902.69 5310-000-010103-000 CASH, PETTY CASH-WWTP 150.00 5310-000-010123-000 CASH, IMPACT FEES -SANITARY SEW 1,799,786.40 5310-000-010124-000 CASH, IMPACT FEES - WWTP 451,252.01 5310-000-010125-000 CASH, CITY/EVERGREEN-WWTP 830,791.93 5310-000-010130-000 CASH, BOND RESERVE 630,260.00 5310-000-010131-000 CASH, BOND RESERVE WWTP 740,902.00 5310-000-010135-000 CASH, OPERATING RESERVE 190,000.00 5310-000-010192-000 CASH, 1992 SRF S & I 4.0% WWT 160.00 5310-000-010197-000 CASH, 2007 SRF WWTP S & I 3.75 28,124.98 5349-000-010100-000 CASH, STORM SEWER OPERATING 1,314,369.45 5349-000-010120-000 CASH, STORM IMPACT FEES 604,021.42 5349-000-010122-000 CASH, CAPITAL RESERVE ($140,00 140,000.00 5349-000-010127-000 CASH, EMERGENCY RESERVE ($25,0 25,000.00 5349-000-010190-000 CASH, STORM EQUIPMENT REPLACEM 200,000.00 5349-000-010193-000 CASH, STORM DESIGNATED CAPITAL 365,842.91 5510-000-010100-000 CASH, SOLID WASTE OPERATING 394,625.19 5510-000-010120-000 CASH, SOLID WASTE REPLACEMENT 103,547.75 5720-000-010100-000 CASH, PARKING COMMISSION 15,254.06 5720-000-010102-000 CASH, PETTY CASH PARKING 300.00 6030-000-010100-000 CASH, DATA PROCESSING OPERATIO 98,878.85 6030-000-010120-000 CASH, DATA EQUIP REPLACEMENT 28,586.65 7855-000-010100-000 CASH, TBID 1,370.00 7910-000-010100-000 CASH, PAYROLL CLEARING 317,266.43 7940-000-010100-000 CASH, PERFORMANCE BONDS 16,625.00 -------------- GRAND TOTAL CASH 22,089,291.79 Page 2