Loading...
1st Quarter Finance ReportCity of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 MONTANA Date October 12, 2011 TO: Mayor Fisher & City Council Members Jane Howington, City Manager From: Amy Robertson Finance Director RE: l' Qtr Finance Report — FY2012 (July — Sept 2011) Please find attached the printouts reflecting the activity for the lst quarter of the fiscal year 2012. This printout reflects payroll paid thru Sept. 23'. All funds are included with the exception of the debt service funds; G. O. bonds, Walk & Curb and SID's. REVENUE: General Fund revenue has little activity as taxes will not be received until December. The tax receivables have not been booked. Tax bills will go out the end of the month and we will book the receivables/revenue at that time. EXPENDITURES: at this point in the year the salary remaining % is about 77%. Some seasonal salaries would be the exception- parks and recreation. Health insurance is paid in advance so 67% remaining is correct. General Government budget in the General Fund has less that 75% remaining due to paying liability and property insurance for the whole year in August. Council budget also has less that 75% remaining due to pay the League. Solid Waste budget reflects payment for the new side -arm loader this month. Please feel free to call with any questions. 758-7755. FUND QuarterlyvFi, ncerReport 1st Quarter Fiscal 2012 FUND ACTUAL YTD BUDGET REMAINING % rage i 25.00% Yr Complete 1000-000-311100-000 1000-000-311105-000 1000-000-311200-000 1000-000-312000-000 1000-000-322101-000 1000-000-322300-000 1000-000-322500-000 1000-000-323012-000 1000-000-323107-000 1000-000-323109-000 1000-000-323200-000 1000-000-323300-000 1000-000-335030-000 1000-000-335076-000 1000-000-335110-000 1000-000-335230-000 1000-000-341020-000 1000-000-341021-000 1000-000-341025-000 1000-000-341027-000 1000-000-342010-000 1000-000-342014-000 1000-000-342016-000 1000-000-343005-000 1000-000-351000-000 1000-000-351016-000 1000-000-351017-000 1000-000-362010-000 1000-000-362015-000 1000-000-362020-000 1000-000-364030-000 1000-000-365015-000 1000-000-371010-000 1000-000-371050-000 1000-000-381060-000 ------------------------------------ GENERAL FUND - REVENUE REAL PROPERTY TAXES PILT-GL MANOR & TRESURE ST PLAZA PERSONAL PROPERTY TAXES PEN & INTEREST DEL. TAXES BEER & LIQUOR LICENSES BUSINESS LICENSES AMUSEMENT LICENSES PLANNING FEES EXCAV/DEMO/AIR/HOUSE MOVING PERMITS SITE REVIEW PARADE PERMITS ANIMAL LICENSES M.V. TAX - AD VALOREM ST VIDEO -LIC FEE AND TAX DIST LIVE CARD TABLE PERMIT HB124 ENTITLEMENT ADMINISTRATIVE CHARGES Grant Admin Fees CITY COLLECTIONS BRESNAN FRANCHISE FEES POLICE SERVICES RESOURCE OFFICERS KPD REGIONAL TRAINING CENTRAL GARAGE CHARGE CITY COURT FINES & FEES DUI COURT FINE COURT SECURITY & TECHNOLOGY FEE CITY GOLF COURSE LEASE INSURANCE REIMBURSEMENTS MMIA GASB 54 REIMBURSEMENT SALE OF MISCELLANEOUS/AUCTION CONTRIBUTION FRM KIDSPORT INVESTMENT EARNINGS LOAN REPAY - KPC OPERATING TRANSFER- FUND 2372 TOTAL REVENUE 114,473 4,681,906 4,567,433 98% 0 15,520 15,520 100% 201,733 208,000 6,267 3% 6,019 35,000 28,981 83% 300 24,000 23,700 99% 0 1,100 1,100 100% 300 350 50 14% 3,461 40,000 36,539 91% 0 500 500 100% 2,377 9,500 7,123 75% 450 2,000 1,550 78% 246 900 655 73% 0 1,720 1,720 100% 0 61,075 61,075 100% 0 3,600 3,600 100% 499,584 2,272,379 1,772,795 78% 126,697 512,000 385,303 75% 0 43,000 43,000 100% 235 1,000 765 77% 106 157,000 156,894 100% 7,532 15,000 7,468 50% 86,000 86,000 0 0% 0 10,000 10,000 100% 30,450 121,800 91,350 75% 88,598 500,000 411,402 82% 85 3,500 3,415 98% 3,984 32,000 28,016 88% 0 25,000 25,000 100% 336 3,000 2,665 89% 0 3,000 3,000 100% 497 100 397- -397% 0 44,000 44,000 100% 7,574 35,000 27,426 78% 0 2,855 2,855 100% 50,000 ----------- 599,209 549,209 92% 1,231,036 ----------- 9,551,014 --------------------- 8,319,978 87% 11 i t It r111L1bet',LL Quarterly Finance Report lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING °s ---------------------------------------------------------------------------------------------------------------- GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 0 1,435 1,435 100% 1000-400-410530-353 AUDITING 0 10,500 10,500 100% 1000-400-410530-354 OPEB EXPENSE 0 6,000 6,000 100% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 718 3,000 2,282 76% 1000-400-410560-312 POSTAGE 2,795 16,000 13,205 83% 1000-400-410560-320 PRINTING 4,136 6,000 1,864 31% 1000-400-410600-354 ELECTIONS 0 10,000 10,000 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 574 3,500 2,926 84% 1000-400-420000-354 CONTRACT 911 CENTER 107,184 428,736 321,552 75% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 300 300 100% 1000-400-460446-354 KIDSPORT LEASE 0 44,000 44,000 100% 1000-400-460446-355 PARADE -SERVICE ORG. REIMB. 0 2,000 2,000 100% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 3,300 6,600 3,300 50% 1000-400-510300-000 CONTINGENCY 569 40,000 39,431 99% 1000-400-510310-354 ICMA PLAN FEES 500 500 0 0% 1000-400-510330-513 LIABILITY INSURANCE 213,145 215,455 2,310 1% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 1,777 30,000 28,223 94% 1000-400-510330-517 PROPERTY INSURANCE 41,812 50,000 8,188 16% SUBTOTAL GEN.GOV'T. ----------- 376,511 ----------- 889,026 --------------------- 512,515 58% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 28,660 123,832 95,172 77% 1000-401-410210-153 HEALTH INSURANCE 4,974 14,956 9,982 67% 1000-401-410210-155 RETIREMENT 3,046 12,985 9,939 77% 1000-401-410210-210 COMPUTER SOFTWARE/SUPPLIES 0 800 800 100% 1000-401-410210-312 NEWSLETTER/BOOKS 45 500 455 91% 1000-401-410210-345 TELEPHONE & COMMUNICATION 0 400 400 100% 1000-401-410210-373 DUES & TRAINING 200 2,500 2,300 92% 1000-401-410210-379 MEETINGS 91 500 409 82% SUBTOTAL CITY MANAGER ----------- 37,016 ----------- 156,473 --------------------- 119,457 76% HUMAN RESOURCES 1000-401-410830-110 SALARIES -PERSONNEL 24,027 103,539 79,512 77% 1000-401-410830-153 HEALTH INSURANCE 5,537 16,667 11,130 67% 1000-401-410830-155 RETIREMENT 1,570 6,725 5,155 77% 1000-401-410830-210 OFFICE SUPPLIES 90 400 310 78% 1000-401-410830-338 RECRUITMENT 68 3,500 3,432 98% 1000-401-410830-354 CONTRACT SERVICES 0 4,000 4,000 100% 1000-401-410830-373 DUES & TRAINING 1,225 3,900 2,675 69% SUBTOTAL HUMAN RESOURCES ----------- 32,518 ----------- 138,731 --------------------- 106,213 77% Page 2 25.00% Yr Complete yr riNLI J Yr. 1,L Quarterly Finance Report lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING Page 3 25.00% Yr Complete MEDIA SPECIALIST 1000-401-410900-110 MEDIA SPECIALIST -salary 4,500 20,080 15,580 78% 1000-401-410900-153 HEALTH INSURANCE 2,737 8,200 5,463 67% 1000-401-410900-155 RETIREMENT 304 1,299 995 77% 1000-401-410900-218 EQUIPMENT 0 1,000 1,000 100% 1000-401-410900-354 CONTRACT SERVICES 250 2,500 2,250 90% SUBTOTAL MEDIA SPECIALIST ----------- 7,791 ----------- 33,079 --------------------- 25,288 76% MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 14,619 63,056 48,437 77% 1000-402-410100-153 HEALTH INSURANCE 9,280 27,936 18,656 67% 1000-402-410100-155 RETIREMENT 675 2,432 1,757 72% 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 0 100 100 100% 1000-402-410100-373 DUES & TRAINING 200 3,000 2,800 93% 1000-402-410100-379 MEETINGS 0 300 300 100% SUBTOTAL MAYOR/COUNCIL ---------------------- 30,783 102,874 --------------------- 72,091 70% CITY CLERK 1000-402-410150-110 SALARIES/CITY CLERK 18,018 78,245 60,227 77% 1000-402-410150-121 OVERTIME 205 500 295 59% 1000-402-410150-153 HEALTH INSURANCE 3,292 10,357 7,065 68% 1000-402-410150-155 RETIREMENT 1,179 5,062 3,883 77% 1000-402-410150-210 OFFICE SUPPLIES 9 100 91 91% 1000-402-410150-345 TELEPHONE & COMMUNICATION 93 450 357 79% 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 375 1,275 900 71% SUBTOTAL CITY CLERK ---------------------- 25,306 ----------- 99,514 ---------- 74,208 75% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 44,510 191,804 147,294 77% 1000-403-410550-153 HEALTH INSURANCE 11,784 35,449 23,665 67% 1000-403-410550-155 RETIREMENT 2,910 12,453 9,543 77% 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 306 1,500 1,194 80% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 216 1,500 1,284 86% 1000-403-410550-355 BANK CHARGES & FEES 872 3,500 2,628 75% 1000-403-410550-373 DUES & TRAINING 593 3,500 2,908 83% SUBTOTAL FINANCE ---------------------- 61,190 ----------- 250,106 ---------- 188,916 76% Page 4 25.00% Yr Complete CITY OF KALISPELL Quarterly Finance Report 1st Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------- CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 71,525 307,471 235,946 77% 1000-404-411110-153 HEALTH INSURANCE 17,776 53,367 35,591 67% 1000-404-411110-155 RETIREMENT 4,675 19,972 15,297 77% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 145 3,200 3,055 95% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 4,245 7,000 2,755 39% 1000-404-411110-345 TELEPHONE & COMMUNICATION 122 1,200 1,078 90% 1000-404-411110-354 CONTRACT SERVICES 0 5,000 5,000 100% 1000-404-411110-373 DUES & TRAINING 134 4,500 4,366 97% SUBTOTAL CITY ATTORNEY ----------- 98,622 ----------- 401,710 --------------------- 303,088 75% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 46,019 198,727 152,708 77% 1000-406-410360-153 HEALTH INSURANCE 15,566 46,818 31,252 67% 1000-406-410360-155 RETIREMENT 3,010 12,884 9,874 77% 1000-406-410360-210 SUPPLIES 229 4,500 4,271 95% 1000-406-410360-320 PRINTING/BOOKS 443 500 57 11% 1000-406-410360-345 TELEPHONE & COMMUNICATION 181 1,400 1,219 87% 1000-406-410360-353 SECURITY & TECHNOLOGY 77- 55,000 55,077 100% 1000-406-410360-354 CONTRACT SERVICES 1,783 5,750 3,967 69% 1000-406-410360-373 DUES & TRAINING 800 6,300 5,500 87% 1000-406-410360-394 JURY & WITNESS FEES 711 5,750 5,039 88% 1000-406-410360-395 DRUG COURT 108 11,500 11,392 99% 1000-406-410360-396 DUI COURT INCENTIVES & MISC 367 1,500 1,133 76% SUBTOTAL COURT ---------------------- 69,141 350,629 --------------------- 281,489 80% DEPT. OF PUBLIC WORKS PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 3,757 17,430 13,673 78% 1000-410-430100-112 SEVERANCE 0 2,000 2,000 100% 1000-410-430100-153 HEALTH INSURANCE 1,051 3,755 2,704 72% 1000-410-430100-155 RETIREMENT 252 1,129 877 78% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 305 2,025 1,720 85% 1000-410-430100-345 TELEPHONE & COMMUNICATION 68 200 132 66% 1000-410-430100-354 CONTRACT SERVICES 31 750 719 96% 1000-410-430100-373 DUES & TRAINING 200 1,150 950 83% SUBTOTAL ADMINISTRATION ---------------------- 5,663 ----------- 28,439 ---------- 22,776 80% CENTRAL GARAGE 1000-410-431330-110 SALARIES -CENTRAL GARAGE 35,517 150,825 115,308 76% 1000-410-431330-121 OVERTIME 244 1,700 1,456 86% 1000-410-431330-153 HEALTH INSURANCE 9,703 31,170 21,467 69% 1000-410-431330-155 RETIREMENT 2,224 9,252 7,028 76% 1000-410-431330-210 OFFICE/COMPUTER SUPPLIES 200 1,200 1,000 83% 1000-410-431330-229 NON -CAPITAL & SAFETY EQUIPMENT 2,301 5,550 3,249 59% 1000-410-431330-231 GAS & OIL 29,372 135,500 106,128 78% 1000-410-431330-232 MOTOR VEHICLE PARTS. 27,750 79,000 51,250 65% 1000-410-431330-233 TIRES AND RELATED PARTS 8,408 27,000 18,592 69% 1000-410-431330-238 FILTERS & MISC. PARTS 1,097 3,700 2,603 70% 1000-410-431330-241 CONSUMABLE TOOLS/BOOKS 693 650 43- -7% 1000-410-431330-341 ELECTRICITY 245 1,700 1,455 86% 1000-410-431330-344 NATURAL GAS 212 7,600 7,388 97% 1000-410-431330-354 CONTRACT SERVICES 5,495 52,000 46,505 89% 1000-410-431330-355 CONTRACT SERVICES -FLEET SERVICES 0 25,000 25,000 100% 1000-410-431330-362 BUILDINGS & EQUIPMENT MAINTENANCE 956 1,250 294 23% 1000-410-431330-373 DUES & TRAINING 0 500 500 100% 1000-410-431330-388 MEDICAL SERVICES 0 250 250 100% SUBTOTAL CENTRAL GARAGE ---------------------- 124,418 ----------- 533,847 ---------- 409,429 77% TOTAL PUBLIC WORKS 130,081 562,286 432,205 77% CITY HALL MAINT. 1 l'1'Y OF KALiSPELL Page 5 Quarterly Finance Report lst Quarter Fiscal 2012 25.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- 1000-412-411230-110 SALARIES -CITY HALL 13,744 64,124 50,380 79% 1000-412-411230-121 OVERTIME 0 200 200 100% 1000-412-411230-153 HEALTH INSURANCE 4,081 13,130 9,049 69% 1000-412-411230-155 RETIREMENT 869 4,010 3,141 78% 1000-412-411230-218 EQUIPMENT (NON -CAPITAL) 3,570 7,500 3,930 52% 1000-412-411230-220 SECURITY CAMERA -CITY HALL 0 10,000 10,000 100% 1000-412-411230-224 JANITORIAL SUPPLIES 1,573 5,200 3,627 70% 1000-412-411230-241 TOOLS & SUPPLIES 0 1,450 1,450 100% 1000-412-411230-341 ELECTRICITY 8,460 45,000 36,540 81% 1000-412-411230-344 NATURAL GAS 2,498 50,000 47,502 95% 1000-412-411230-345 TELEPHONE & COMMUNICATION 65 250 185 74% 1000-412-411230-354 CONTRACT SERVICES 10,361 23,000 12,639 55% 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 0 4,500 4,500 100% 1000-412-411230-362 EQUIPMENT MAINTENANCE 2,500 5,000 2,500 50% 1000-412-411230-366 BUILDING MAINTENANCE 8,076 17,300 9,224 53% 1000-412-411230-545 COUNTY LANDFILL 59 2,000 1,942 97% 1000-412-411230-610 BOI 2004 DEBT (HVAC SYS) 7,944 15,985 8,041 50% 1000-412-411230-620 BOI 2004 INT. (HVAC SYS) 555 1,120 565 50% SUBTOTAL CITY HALL ----------- 64,356 ----------- 269,769 --------------------- 205,413 76% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 54,501 234,306 179,805 77% 1000-420-411020-153 HEALTH INSURANCE 16,562 53,669 37,107 69% 1000-420-411020-155 RETIREMENT 3,562 15,216 11,654 77% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 3,327 7,500 4,173 56% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 622 2,700 2,078 77% 1000-420-411020-345 TELEPHONE 142 900 758 84% 1000-420-411020-354 CONTRACT SERVICES 714 1,600 886 55% 1000-420-411020-373 DUES & TRAINING 1,659 3,300 1,641 50% TOTAL PLANNING DEPT. ----------- 81,088 ----------- 319,191 ----------- ---------- 238,103 75% ­. vC riHLI J YC, LL Quarterly Finance Report lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % Page 6 25.00% Yr Complete POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 1000-413-420140-112 SALARIES -SEVERANCE 1000-413-420140-114 SALARY -comptime buyout 1000-413-420140-121 OVERTIME 1000-413-420140-123 SPECIAL ASSIGNMENT OVERTIME 1000-413-420140-153 HEALTH INSURANCE 1000-413-420140-155 RETIREMENT 1000-413-420140-210 OFFICE SUPPLIES 1000-413-420140-215 COMPUTER SUPPLIES 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 1000-413-420140-220 INVESTIGATIVE SUPPLIES 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1000-413-420140-226 SRT SUPPORT/SUPPLIES 1000-413-420140-227 AMMO & RELATED SUPPLIES 1000-413-420140-228 PATROL CAR SUPPLIES 1000-413-420140-229 OTHER SUPPLIES 1000-413-420140-230 CRIME PREVENTION SUPPLIES 1000-413-420140-234 CRISIS NEGOTIATIONS 1000-413-420140-235 BIKE PATROL 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 1000-413-420140-320 PRINTING 1000-413-420140-345 TELEPHONE & COMMUNICATION 1000-413-420140-354 CONTRACT SERVICES 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1000-413-420140-373 DUES & TRAINING 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 1000-413-420140-380 TRAINING MATERIALS 1000-413-420140-388 MEDICAL SERVICES 1000-413-420140-392 BOARDING/TREATING PRISONERS 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 1000-413-420140-944 VEHICLES 1000-413-420141-110 DETECTIVE -SALARIES 1000-413-420141-121 DETECTIVE -OVERTIME 1000-413-420141-153 HEALTH INSURANCE 1000-413-420141-155 DETECTIVE -RETIREMENT 1000-413-420142-110 RECORDS -SALARIES 1000-413-420142-121 OVERTIME 1000-413-420142-153 HEALTH INSURANCE 1000-413-420142-155 RETIREMENT 1000-413-420144-110 SRO SALARIES 1000-413-420144-153 HEALTH INSURANCE 1000-413-420144-155 SRO RETIREMENT SUBTOTAL POLICE DEPT. 422,193 1,799,844 1,377,651 77% 0 5,000 5,000 100% 0 4,000 4,000 100% 22,135 70,000 47,865 68% 1,528 25,000 23,472 94% 112,262 341,956 229,694 67% 55,070 235,656 180,586 77% 870 3,500 2,630 75% 1,963 5,500 3,537 64% 82 10,500 10,418 99% 1,938 4,000 2,062 52 % 128 7,000 6,872 98% 0 2,000 2,000 100% 1,407 4,000 2,593 65% 10,409 17,000 6,591 39% 5,382 13,000 7,618 59% 323 3,500 3,177 91% 526 1,000 474 47% 6 1,500 1,494 100% 0 1,000 1,000 100% 40 1,000 960 96% 836 5,000 4,164 83% 3,241 15,500 12,259 79% 2,132 6,000 3,868 64% 1,412 4,500 3,088 69% 0 4,000 4,000 100°% 0 2,000 2,000 100% 3,121 20,000 16,879 84% 1,962 2,500 538 22% 6,802 27,250 20,448 75% 304 12,000 11,696 97% 0 2,000 2,000 100% 0 3,500 3,500 100% 260 1,500 1,241 83% 0 57,200 57,200 100% 0 20,000 20,000 100% 0 5,000 5,000 100% 14,500 75,000 60,500 81% 75,617 332,428 256,811 77% 4,067 15,000 10,933 73% 18,742 56,346 37,604 67% 10,482 44,902 34,420 77% 21,509 102,927 81,418 79% 189 7,500 7,311 97% 4,060 13,968 9,908 71% 1,199 5,615 4,416 79% 24,497 117,630 93,133 79% 5,213 21,940 16,727 76% 2,946 ----------- 15,759 ----------- 12,813 --------------------- 81% 839,348 3,552,921 2,713,573 76% Quarterly- FinancerReport lst Quarter Fiscal 2012 Page 7 25.00% Yr Complete FUND FUND ----------------------------------------------------------------- FIRE DEPARTMENT 1000-416-420400-110 FIRE SUPPRESSION -SALARIES 1000-416-420400-112 SALARY -SEVERANCE 1000-416-420400-114 COMPTIME BUYOUT 1000-416-420400-115 OUT OF RANK PAY 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-345 TELEPHONE & COMMUNICATION 1000-416-420400-354 CONTRACT SERVICES 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-121 OVERTIME 1000-416-420440-153 HEALTH INSURANCE 1000-416-420440-155 RETIREMENT SUBTOTAL FIRE DEPT. GRAND TOTAL GENERAL FUND ACTUAL YTD BUDGET REMAINING % ---------------- 315,401 1,369,945 1,054,544 77% 7,173 10,000 2,827 28% 0 5,000 5,000 100% 2,684 6, 978 4,294 62% 14,525 32,500 17,975 55% 85,613 270,825 185,212 68% 43,165 187,677 144,512 77% 391 2,700 2,309 86% 1,966 7,500 5,534 74% 14,430 15,000 570 4% 956 1,500 544 36% 2,561 15,000 12,439 83% 134 700 566 81% 0 1,250 1,250 100% 1,298 8,500 7,202 85% 2,374 8,000 5,626 70% 1,273 6,500 5,227 80% 1,347 2,500 1,153 46% 833 10,500 9,667 92% 1,034 16,650 15,616 94% 27,582 55,896 28,314 51% 5,667 10,875 5,208 48% 9,469 38,414 28,945 75% 275 0 275- 0% 1,477 7,238 5,761 80% 611 2,514 1,903 76% ----------- 542,240 ----------- 2,094,162 --------------------- 1,551,923 74% 2,395,990 9,220,471 6,824,481 74% QuarterlyvFinancerReport lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % Page 8 25.00% Yr Complete SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 2185-000-430300-356 REDEVELOPMENT / CONTRACT SERVICES 2185-000-430300-522 ADMINISTRATIVE TRANSFER 2185-000-430300-840 REDEVELOPMENT ACTIVITY 2185-480-470240-110 SALARIES 2185-480-470240-153 HEALTH INSURANCE 2185-480-470240-155 RETIREMENT TOTAL AIRPORT TIF 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 2188-480-470230-153 HEALTH INSURANCE 2188-480-470230-155 RETIREMENT 2188-480-470230-353 AUDIT 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 2188-480-470230-522 ADMINISTRATIVE TRANSFER 2188-480-470230-720 TIF DISTRIBUTION OR REDEVELOPMENT TOTAL WESTSIDE TIF 2210 PARKS IN LIEU 2210-436-460430-826 TRANSFER TO ISTEA FUND 2210-436-460430-934 CAPITAL IMPROVEMENTS 2210-436-460430-936 LAWRENCE PARK IMPROVEMENTS 2210-436-460430-937 WESTVIEW IMPROVEMENTS TOTAL PARKS IN LIEU 2215 NEW PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 2215-000-311200-000 PERSONAL PROPERTY TAXES 2215-000-312000-000 PEN & INTEREST DEL TAXES 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 2215-000-346030-000 SWIMMING POOL FEES 2215-000-346040-000 CONCESSION STAND REVENUE 2215-000-346050-000 Parks Usage Fees 2215-000-346051-000 RECREATION FEES 2215-000-346052-000 SPORTS PROGRAMS 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 2215-000-346054-000 AFTER SCHOOL PROGRAMS 2215-000-346055-000 ICE RINK 2215-000-346057-000 YOUTH CAMPS 2215-000-346059-000 PICNIC IN THE PARK 2215-000-365010-000 DONATION/FERTILIZER 2215-000-371010-000 INVESTMENTS/DONATIONS/MISC.SALES 2215-000-381060-000 HEALTH INSURANCE TRANSFER TOTAL PARKS & REC REVENUE PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 2215-436-460430-111 SEASONAL SALARIES 2215-436-460430-121 OVERTIME 2215-436-460430-153 HEALTH INSURANCE 2215-436-460430-155 RETIREMENT 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2215-436-460430-224 JANITORIAL SUPPLIES 2215-436-460430-229 OTHER SUPPLIES 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 2215-436-460430-320 PRINTING & ADVERTISING 0 1,200 1,200 100% 0 10,000 10,000 100% 2,948 11,792 8,844 75% 0 1,000,000 1,000,000 100% 4,242 18,218 13,976 77% 766 2,305 1,539 67% 277 1,185 908 77% ----------- 8,232 ----------- 1,044,700 --------------------- 1,036,468 99% 4,593 18,218 13,625 75% 1,014 2,305 1,291 56% 300 1,185 885 75% 0 1,250 1,250 100% 5,000 5,000 0 0% 4,274 17,094 12,821 75% 465,000 2,508,702 2,043,702 81% ----------- 480,180 ---------- ----------- ----------- 2,553,754 ---------- ----------- --------------------- 2,073,574 --------------------- -------------------- 81% 17,435 20,672 3,237 16% 0 5,000 5,000 100°% 0 12,000 12,000 100% 0 ----------- 15,000 ----------- 15,000 ----------- 100% 17,435 ----------- ---------- 52,672 ----------- ----------- ---------- 35,237 ------------------- -------------------- 67% 24,765 893,205 868,440 97% 37,941 39,200 1,259 3% 855 2,500 1,645 66% 0 5,000 5,000 100% 91,341 140,000 48,659 35% 26,691 32,500 5,809 18% 7,087 19,000 11,913 63% 2,493 10,000 7,507 75% 10,311 40,800 30,489 75% 84 3,500 3,416 98% 10,733 32,580 21,847 67% 0 21,000 21,000 100% 28,832 78,000 49,168 63% 4,608 26,000 21,392 82% 0 850 850 100% 409 1,000 591 59% 5,000 ----------- 65,000 ----------- 60,000 --------------------- 92% 251,151 1,410,135 1,158,984 82% 54,567 261,049 206,482 79% 24,863 36,855 11,992 33% 331 1,000 669 67% 21,131 63,399 42,268 67% 4,056 18,539 14,483 78% 219 2,100 1,881 90% 1,078 3,500 2,422 69% 1,672 4,500 2,828 63% 844 2,500 1,656 66% 213 506 293 58% ���•-�� U1'1'1 utKALiSPELL Quarterly Finance Report 1st Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2215-436-460430-341 ELECTRICITY 2,567 14,250 11,683 82% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 21,000 21,000 100% 2215-436-460430-344 NATURAL GAS 145 3,200 3,055 95% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 323 2,500 2,177 87% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 1,500 1,500 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 1,069 5,000 3,931 79% 2215-436-460430-356 CONSULTANTS 0 1,500 1,500 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 2,945 8,000 5,055 63% 2215-436-460430-364 LANDSCAPING 669 5,000 4,331 87% 2215-436-460430-367 VANDALISM REPAIRS 541 4,000 3,459 86% 2215-436-460430-373 DUES & TRAINING 310 2,700 2,390 89% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 50 600 551 92% 2215-436-460430-395 EQUIPMENT RENTAL 175 500 325 65% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 76 3,500 3,424 98% 2215-436-460430-440 IRRIGATION SUPPLIES 2,239 9,000 6,761 75% 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 6,022 17,000 10,978 65% TOTAL PARKS EXPENDITURES ----------- 126,364 ----------- 498,728 --------------------- 372,364 75% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 7,296 32,111 24,815 77% 2215-436-460440-111 SEASONAL SALARIES 17,108 52,045 34,937 67% 2215-436-460440-153 HEALTH INSURANCE 3,089 9,395 6,306 67% 2215-436-460440-155 RETIREMENT 840 4,158 3,318 80% 2215-436-460440-221 SAFETY EQUIPMENT 0 875 875 100% 2215-436-460440-229 OTHER SUPPLIES 3,350 17,500 14,150 81% 2215-436-460440-341 ELECTRICITY 3,251 5,600 2,349 42% 2215-436-460440-345 TELEPHONE & COMMUNICATION 97 300 203 68% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 179 700 521 74% 2215-436-460440-364 LANDSCAPING 0 1,000 1,000 100% 2215-436-460440-367 VANDALISM REPAIRS 646 300 346- -115% 2215-436-460440-373 DUES & TRAINING 60 135 75 56% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-420 METAL PRODUCTS 0 2,900 2,900 100% 2215-436-460440-440 IRRIGATION 1,362 3,400 2,038 60% 2215-436-460440-452 SAND & GRAVEL 464 1,000 536 54% 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% TOTAL ATHLETIC COMPLEX ----------- 46,034 ----------- 147,589 ----------- ---------- 101,555 69% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 19,573 89,823 70,250 78% 2215-436-460431-111 SEASONAL SALARIES 2,836 9,761 6,925 71% 2215-436-460431-153 HEALTH INSURANCE 6,503 19,659 13,156 67% 2215-436-460431-155 RETIREMENT 1,282 6,158 4,876 79% 2215-436-460431-218 DONATED SUPPLIES (donation FY11) 1,381 2,025 644 32% 2215-436-460431-229 MISC. SUPPLIES 1,975 9,625 7,650 79% 2215-436-460431-320 PRINTING & ADVERTISING 115 6,300 6,185 98% 2215-436-460431-345 TELEPHONE & COMMUNICATION 368 600 232 39% 2215-436-460431-354 CONTRACT SERVICES 12,157 19,450 7,293 38% 2215-436-460431-373 DUES & TRAINING 310 1,650 1,340 81% TOTAL RECREATION ---------------------- 46,500 ---------- ---------- -------------------- 165,051 --------------------- 118,551 --------------------- --------------------- 72% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 15,082 67,605 52,523 78°% 2215-436-460448-111 SEASONAL SALARIES 39,458 74,692 35,234 47% 2215-436-460448-121 OVERTIME 17 500 483 97% 2215-436-460448-153 HEALTH INSURANCE 6,134 18,548 12,414 67% 2215-436-460448-155 RETIREMENT 953 5,662 4,709 83% 2215-436-460448-229 MISC. SUPPLIES 988 3,850 2,862 74% 2215-436-460448-320 PRINTING & ADVERTISING 58 450 392 87% Page 9 25.00% Yr Complete Y\�, I Je"L Quarterly Finance Report lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % -------------------------------------------------------------------------------------------------------------- 2215-436-460448-345 TELEPHONE & COMMUNICATION 0 400 400 100% 2215-436-460448-354 CONTRACT SERVICES 5,127 12,600 7,473 59% 2215-436-460448-355 AFTER SCHOOL PROGRAM 495 2,500 2,005 80% 2215-436-460448-356 BANK FEES/CC CHARGES 807 2,500 1,693 68% 2215-436-460448-373 DUES & TRAINING 0 600 600 100% TOTAL YOUTH CAMPS ----------- 69,119 ----------- 189,907 --------------------- 120,788 64% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 123,585 197,479 73,894 37% 2215-437-460445-121 OVERTIME 949 900 49- -5% 2215-437-460445-155 RETIREMENT 603 2,058 1,455 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 7,908 19,000 11,092 58% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 3,295 4,400 1,105 25% 2215-437-460445-341 ELECTRICITY 3,461 12,500 9,039 72% 2215-437-460445-344 NATURAL GAS 17,907 24,000 6,093 25% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 336 1,500 1,164 78% 2215-437-460445-354 LICENSES & FEES 48 1,300 1,252 96% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 1,891 8,200 6,309 77% 2215-437-460445-380 TRAINING MATERIALS 0 250 250 ---------- 100% TOTAL POOL EXPENDITURES ----------- 176,535 ----------- 298,487 ----------- 121,952 41% TOTAL PARKS & RECREATION/POOL 464,551 1,299,762 835,211 64% Page 10 25.00% Yr Complete Quarterly vFinance rReport 1st Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 151,977 605,000 453,023 75% 2230-000-342070-000 COUNTY EMS LEVY 0 85,000 85,000 100% 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC ill 200 89 45% 2230-000-371010-000 INTEREST EARNINGS 278 800 522 65% TOTAL AMBULANCE REVENUE ----------- 152,367 ----------- 691,000 --------------------- 538,633 78% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 83,865 397,702 313,837 79% 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 636 12,000 11,364 95% 2230-440-420730-153 HEALTH INSURANCE 23,556 81,892 58,336 71% 2230-440-420730-155 RETIREMENT 11,725 56,373 44,648 79% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 405 3,500 3,095 88% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 336 2,500 2,164 87% 2230-440-420730-231 GAS AND OIL 1,307 7,000 5,693 81% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 242 7,500 7,258 97% 2230-440-420730-312 POSTAGE/PRINTING 0 3,500 3,500 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 268 700 432 62% 2230-440-420730-354 PARAMEDIC RECERTIFICATION 0 12,000 12,000 100% 2230-440-420730-355 911 CENTER CONTRIBUTION 7,500 30,000 22,500 75% 2230-440-420730-359 AUDIT/CC OTHER FEES 101 1,400 1,299 93% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 356 8,000 7,644 96% 2230-440-420730-373 DUES & TRAINI14G 421 8,000 7,579 95% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 1,714 22,500 20,786 92% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 10,240 35,000 24,760 71% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 9,785 16,100 6,315 39% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 2,375 9,500 7,125 75% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 5,765 23,060 17,295 75% 2230-440-420730-528 DATA PROCESSING TRANSFER 2,671 10,683 8,012 75% TOTAL AMBULANCE FUND ----------- 170,441 ----------- 761,057 --------------------- 590,616 78% 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 0 10,910 10,910 100% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 0 40,000 40,000 100% TOTAL 2310 OLD SCHOOL TECH TIF ----------- 0 ----------- 64,623 --------------------- 64,623 100% 2311 OLD SCHOLL TIF INDUSTRIAL 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 0 18,000 18,000 100% TOTAL 2311 OLD SCHOOL INDUSTR. ----------- 0 ----------- 18,000 ----------- ---------- 18,000 100% 2372 HEALTH PERMISIVE LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND 55,000 ----------- 648,147 593,147 92% TOTAL 2372 HEALTH LEVY 55,000 ----------- 648,147 ----------- ---------- 593,147 92% Page 11 25.00% Yr Complete lu/12/11 FUND FUND CITY OF KALISPELL Quarterly Finance Report lst Quarter Fiscal 2012 ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 46,770 190,000 143,230 75% 2394-000-323103-000 PLUMBING PERMITS 4,440 15,000 10,560 70% 2394-000-323104-000 MECHANICAL PERMITS 5,073 22,000 16,928 77% 2394-000-323107-000 HOUSE MOVING PERMITS 0 200 200 100°% 2394-000-323108-000 PLAN REVIEW FEES 17,734 60,000 42,266 70% 2394-000-371010-000 INVESTMENT EARNINGS 453 1,000 547 55% TOTAL REVENUE ----------- 74,470 ----------- 288,200 ----------- ---------- 213,730 74% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 51,361 215,510 164,149 76% 2394-420-420530-121 OVERTIME 69 3,000 2,931 98% 2394-420-420530-153 HEALTH INSURANCE 14,082 43,492 29,410 68% 2394-420-420530-155 RETIREMENT 3,497 13,409 9,912 74% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 312 4,750 4,438 93% 2394-420-420530-231 GAS & OIL 534 2,250 1,716 76% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 112 2,600 2,488 96% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 2,500 2,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 251 1,500 1,249 83% 2394-420-420530-353 AUDITING 3,500 3,500 0 0% 2394-420-420530-354 CONTRACT SERVICES 710 1,300 590 45% 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 75 300 225 75% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 2,558 10,324 7,766 75% 2394-420-420530-528 DATA PROCESSING TRANSFER 1,045 4,179 3,134 75% TOTAL BUILDING DEPT. ---------------------- 82,431 ---------- ----------- --------------------- ----------- 316,114 ----------- ----------- ---------- 233,683 ---------- ---------- 74% 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 8,264 38,477 30,213 79% 2400-410-430263-153 HEALTH INSURANCE 2,404 9,295 6,891 74% 2400-410-430263-155 RETIREMENT 525 2,372 1,847 78% 2400-410-430263-244 STREET LIGHT SUPPLIES 8,046 13,000 4,954 38% 2400-410-430263-341 ELECTRICITY 24,358 163,000 138,642 85% 2400-410-430263-360 REPAIR & MAINT SERVICES 3,737 28,000 24,263 87% 2400-410-430263-510 INSURANCE 872 975 103 11% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 1,901 7,603 5,702 75% TOTAL LIGHT MAINT. ---------------------- 50,107 --------------------- ----------- ---------- ----------- 262,722 ---------- ---------- ---------- 212,615 ---------- ---------- 81°% Page 12 25.00% Yr Complete 1,111 VN KAillbeELL Quarterly Finance Report 1st Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % Page 13 25.00% Yr Complete 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 21,792 35,000 13,208 38% 2420-421-430234-957 ALLEY PAVING 18,810 45,000 26,190 58% 2420-421-430240-231 GAS & OIL 6,589 35,000 28,411 81% 2420-421-430240-344 NATURAL GAS 0 3,500 3,500 100% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 46,931 247,575 200,644 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 278 3,000 2,722 91°% 2420-421-430240-453 MATERIALS; CONTRACT PREP. 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 0 45,000 45,000 100% 2420-421-430240-472 ASPHALT 11,925 30,000 18,075 60% 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 ---------- 137,191 ----------- 602,682 ----------- --------------------- 465,491 -------------------- 77% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 128,419 583,985 455,566 78% 2500-421-430240-112 RETIREMENT -severance 3,122 8,500 5,378 63% 2500-421-430240-121 OVERTIME 36 30,000 29,964 100% 2500-421-430240-153 HEALTH INSURANCE 47,562 155,620 108,058 69% 2500-421-430240-155 RETIREMENT 8,258 36,388 28,130 77% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 2,452 5,000 2,548 51% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,414 2,200 786 36% 2500-421-430240-220 OTHER SUPPLIES 342 3,900 3,558 91°% 2500-421-430240-231 GAS & OIL 6,655 40,000 33,345 83% 2500-421-430240-341 ELECTRICITY 173 1,400 1,227 88% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 336 1,000 664 66% 2500-421-430240-354 CONTRACT SERVICES 2,549 12,500 9,951 80% 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 1,957 28,000 26,043 93% 2500-421-430240-366 BUILDING MAINTENANCE 454 1,500 1,046 70% 2500-421-430240-373 DUES & TRAINING 370 2,500 2,130 85% 2500-421-430240-388 MEDICAL SERVICES 453 1,100 648 59% 2500-421-430240-510 LIABILITY INSURANCE 78,797 85,000 6,203 7% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 16,500 66,000 49,500 75% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 16,177 64,707 48,530 75% 2500-421-430240-528 DATA PROCESSING TRANSFER 2,672 10,689 8,017 75% 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 0 172,000 172,000 100% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 66,572 450,000 383,428 85% 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 30,056 140,306 110,250 79% 2500-421-430264-121 OVERTIME 3,441 8,500 5,059 60% 2500-421-430264-153 HEALTH INSURANCE 5,800 19,524 13,724 70% 2500-421-430264-155 RETIREMENT 2,080 8,862 6,782 77°% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 288 1,500 1,212 81% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 4,457 8,600 4,143 48% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 1,778 2,250 472 21% 2500-421-430264-242 STREET SIGNS 17,778 40,000 22,222 56% 2500-421-430264-243 TRAFFIC SIGNALS 4,845 10,000 5,155 52% 2500-421-430264-245 BARRICADE MATERIALS 100- 4,500 4,600 102% 2500-421-430264-341 ELECTRICITY 984 9,000 8,016 89% 2500-421-430264-345 COMMUNICATIONS 268 700 432 62% 2500-421-430264-354 CONTRACT SERVICES 12,918 10,000 2,918- -29% 2500-421-430264-362 EQUIPMENT MAINTENANCE 1,013 2,500 1,487 59% 2500-421-430264-366 BUILDING MAINTENANCE 569 1,500 931 62% 2500-421-430264-373 DUES & TRAINING 1,209 2,500 1,291 52% 2500-421-430264-428 PAINT MATERIALS 2,716 15,000 12,284 82% 1V/1G/11 CITY OF KALISPELL Page 14 Quarterly Finance Report lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % 25.00% Yr Complete 2500-421-430264-510 LIABILITY INS.-TSS 3,749 3,800 51 1% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,400 2,400 100% 2500-421-430264-532 OFFICE RENT 3,919 7,838 3,919 50% TOTAL SPEC. ST. MAINT. ----------- 483,037 ----------- 2,214,795 --------------------- 1,731,758 78% 2600 URBAN FORESTRY FUND 2600-436-460433-110 SALARIES -URBAN FORESTRY 31,317 149,472 118,155 79% 2600-436-460433-121 OVERTIME 84 750 666 89% 2600-436-460433-153 HEALTH INSURANCE 10,839 33,893 23,054 68% 2600-436-460433-155 RETIREMENT 1,995 9,258 7,263 78% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 124 550 426 78% 2600-436-460433-241 CONSUMABLE TOOLS 0 950 950 100% 2600-436-460433-354 CONTRACT SERVICES 0 500 500 100% 2600-436-460433-357 FORESTRY GRANT 0 1,500 1,500 100% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 3,850 14,000 10,150 73% 2600-436-460433-362 EQUIPMENT MAINTENANCE 134 1,800 1,666 93% 2600-436-460433-364 LANDSCAPING & TREES 4,555 7,500 2,945 39% 2600-436-460433-373 DUES & TRAINING 0 300 300 100% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 3,489 4,000 511 13% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 750 3,000 2,250 75% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 1,656 6,625 4,969 75% 2600-436-460433-528 DATA PROCESSING TRANSFER 334 1,336 1,002 75% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 2,086 4,136 2,050 50% 2600-436-460433-620 INTEREST EXPENSE 259 447 188 42% ----------- TOTAL URBAN FORESTRY ---------- 61,471 ----------- 240,017 ----------- --------------------- 178,546 ----------- ---------- 74% 2601 DEVELOPER TREES 2601-436-460435-351 EMPIRE ESTATES ($44,911) 0 8,948 8,948 100% 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 100% 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 566 2,112 1,546 73% 2601-436-460435-356 SINOPAH SUBD ($5,790) 0 667 667 100% 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 0 2,883 2,883 100% 2601-436-460435-358 WEST VIEW SUBD ($22,680) 0 17,831 17,831 100% 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 1,981 33,756 31,775 94% 2601-436-460435-360 RIVER GLEN SUBD ($3,240) 0 278 278 100% 2601-436-460435-361 VILLAGE GREENS ($3,540) 0 2,514 2,514 100% 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 0 1,538 1,538 100% 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 0 1,390 1,390 100% 2601-436-460435-364 MTN VISTA ESTATES III $17,278.25 0 3,679 3,679 100% 2601-436-460435-365 VILLAGE GREENS $3,540 0 2,797 2,797 100% 2601-436-460435-366 W VIEW ESTATES $20,060 0 10,850 10,850 100% 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 0 4,254 4,254 100% ----------- TOTAL 2602 DEVELOPER TREES ----------- ---------- 2,547 ----------- 97,833 ----------- ---------- --------------------- 95,286 ----------------- ------- ----------------- 97% FUND FUND CITY OF KALISPELL Quarterly Finance Report 1st Quarter Fiscal 2012 ACTUAL YTD BUDGET REMAINING % Page 15 25.00% Yr Complete --------------------------------------------- 2825 MACI GRANT -SWEEPER 2825-421-430240-940 STREET SWEEPER TOTAL 2825 MACI GRANT 2880 COM DEV REVOLVING FUND 2880-480-470240-711 IRP LOAN PROGRAM MATCH TOTAL LOAN REVOLVING 2886 UDAG FUND 2886-480-470210-110 SALARIES - UDAG 2886-480-470210-153 HEALTH INSURANCE 2886-480-470210-155 RETIREMENT 2886-480-470210-210 OFFICE SUPPLIES 2886-480-470210-211 GRANT ADMIN. & PROJ. EXPENSES 2886-480-470210-312 POSTAGE & PRINTING 2886-480-470210-334 MT WEST MEMBERSHIP 2886-480-470210-345 TELEPHONE & COMMUNICATION 2886-480-470210-353 AUDITING 2886-480-470210-354 CONTRACT SERVICES 2886-480-470210-355 PROSPECT DEVELOPMENT 2886-480-470210-373 DUES & TRAINING 2886-480-470210-379 MEETINGS 2886-480-470210-395 CDBG- GROWTH POLICY UPDATE 2886-480-470210-396 GRANT SERVICES 2886-480-470210-510 PROPERTY & LIABILITY INS. 2886-480-470210-522 ADMINISTRATIVE TRANSFER 2886-480-470210-528 DATA PROCESSING TRANSFER 2886-480-470210-532 OFFICE RENT 2886-480-470210-790 COMM. DEV. ACTIVITIES TOTAL UDAG FUND RURAL DEVELOPMENT REVOLVING 2887-480-470210-110 SALARIES 2887-480-470210-153 HEALTH INSURANCE 2887-480-470210-155 RETIREMENT 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 2887-480-470210-620 INTEREST EXPENSE/L#61-01 2887-480-470210-750 REDEVELOPMENT LOANS ZiYY7Iff.%f tvM11skuwilW40a1 ------------------------------------------------- 0 200,000 200,000 100% ----------- 0 ----------- ----------- ----------- 200,000 ----------- ----------- --------------------- 200,000 ------------------- --------------------- 100% 0 225,000 225,000 100% ----------- 0 ----------- ----------- ----------- 225,000 ----------- ---------- --------------------- 225,000 ------------------- --------------------- 100% 13,000 56,230 43,230 77% 2,320 6, 984 4, 664 67% 850 3,638 2,788 77% 213 2,500 2,287 91% 0 3,000 3,000 100% 825 1,150 325 28% 0 500 500 100% 78 250 172 69% 0 1,800 1,800 100% 0 1,000 1,000 100% 0 3,000 3,000 100% 216 3,800 3,584 94% 235 500 265 53% 0 20,000 20,000 100% 3,220 25,000 21,780 87% 2,896 3,000 104 3% 1,413 5,651 4,238 75% 1,670 6,680 5,010 75% 2,352 4,703 2,352 50% 0 2,500 2,500 100% ---------------------- 29,287 ---------------------- ----------- 151,886 ----------- ---------- 122,599 ---------- 81% 4,410 18,868 14,458 77% 789 2,675 1,886 71% 287 1,221 934 76% 0 17,386 17,386 100% 0 4,689 4,689 100% 0 200,000 200,000 100% ---------------------- 5,487 --------------------- ---------------------- ----------- 244,839 ----------- ----------- ---------- 239,352 ---------- ---------- 98% 2888 RURAL DEV. #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-02 0 7,731 7,731 100% 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-02 0 2,283 2,283 100% 2888-480-470210-750 REDEVELOPMENT LOANS 22 85,000 84,978 100% ----------- TOTAL 2888 RURAL DEV. #2 ----------- ----------- 22 ----------- 95,014 --------------------- ---------------------- --------------------- 94,992 --------- ---------- 100% 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 TOTAL EPA BROWNSFIELD GRANT 8,044 268,058 260,014 97% ------------------------------------------- 8,044 268,058 260,014 97% FUND FUND CITY OF KALISPELL Quarterly Finance Report lst Quarter Fiscal 2012 ACTUAL YTD BUDGET REMAINING % Page 16 25.00% Yr Complete --------------------------------------------------- 2954 EPA/BROWNFIELDS PLANNING 2954-480-470210-354 AREA -WIDE PILOT PROGRAM TOTAL 2954 EPA/BROWNFIELD PLAN 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN TOTAL 2915 STONEGARDEN GRANT 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 2916-413-420140-121 OVERTIME 2916-413-420140-153 HEALTH INSURANCE 2916-413-420140-155 RETIREMENT 2916-413-420140-210 OFFICE SUPPLIES 2916-413-420140-354 CONTRACT SERVICES TOTAL 2916 DRUG ENFORCEMENT 2917 COPS TECHNOLOGY GRANT 2917-413-420140-950 SHOOTING FACILITY TOTAL 2917 COPS TECHNOLOGY GT 2918 COPS HIRING RECOVERY GT 2918-413-420140-110 SALARIES & PAYROLL COSTS 2918-413-420140-153 HEALTH INSURANCE 2918-413-420140-155 RETIREMENT TOTAL 2918 COPS HIRING GRANT 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 2919-413-420140-125 DUI TASK FORCE 2919-413-420140-126 HOLIDAY OT REIMB. 2919-413-420140-127 SCHOOL DIST. OT 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 2919-413-420140-221 Bullet Proof Vests TOTAL LAW ENF. GRANT 2920 DOJ-IT UPGRADE SAFETY BLD 2920-480-470210-922 PUBLIC SAFETY BLDG -TECH UPGRADES TOTAL 2920 IT UPGRADE -SAFETY 2921 DRUG COURT GRANT 2921-406-410360-354 DRUG COURT -contract services TOTAL DRUG COURT GRANT 2951 DUI COURT GRANT 2951-406-410360-355 CS-EVAL,P0,LAC/42011-18-21-02 TOTAL DUI COURT GRANT 2930 PRESERVE AMERICA GRANT ----------------------------------------------- ---------- ----------- 1,978 -------------------- -------------------- 146,894 ---------- 99% ---------- ----------- 148,872 ----------- 1,978 ----------- 148,872 ----------- 146,894 99% 3,336 7,743 ----------- 4,407 --------------------- 57% ----------- 3,336 ----------- ----------- 7,743 ----------- ----------- 4,407 -------------------- --------------------- 57% 15,342 63,051 47,709 76% 2,131 9,000 6,869 76% 2,320 6,984 4,664 67% 2,006 8,530 6,524 76% 0 400 400 100% 0 3,000 3,000 100% ----------- 21,799 ----------- ---------- ----------- 90,965 ----------- ----------- --------------------- 69,166 --------------------- --------------------- 76% 0 750,000 750,000 100% ----------- 0 ----------- 750,000 --------------------- 750,000 100% 13,784 50,329 36,545 73% 4, 974 14,956 9,982 67% 1,800 ----------- 6,809 5,009 --------------------- 74% ----------- 20,558 ------------------- ----------- --------- 72,094 51,536 --------------------- --------------------- 71% 927 1,030 103 10% 0 8,000 8,000 100% 13,663 50,000 36,337 73% 2,114 20,000 17,886 89% 0 2,500 2,500 100% 4,045 10,000 ----------- 5,955 60% ---------------------- 20,749 -------------------- ---------------------- 91,530 ----------- ---------- 70,781 --------- --------- 77% ----------- 4,219 ----------- 216,257 ----------- 212,038 ---------- 98% ----------- 4,219 216,257 212,038 98% 14,246 265,993 251,747 95°% ---------------------- 14,246 ----------- 265,993 ---------- 251,747 95% 9,808 46,078 36,270 79% ---------------------- 9,808 ----------- 46,078 ---------- 36,270 79% FUND FUND OITY OF KALISPELL Quarterly Finance Report 1st Quarter Fiscal 2012 ACTUAL YTD BUDGET REMAINING % Page 17 25.00% Yr Complete --------------------------------------------------- 2930-480-470240-354 PRESERVE AMERICA EXPENSES TOTAL 2930 PRESERVE AMERICA 2927 CULTRUAL ARTS PASSTHRU GT 2927-400-460452-354 HOCKADAY 2927-400-460454-354 GLACIER ORCHESTRA 2927-400-460456-354 NW MT HISTORICAL SOCIETY TOTAL 2927 CULTURAL ARTS 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 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 TOTAL 2995 SAFER GRANT CAPITAL PROJECT FUNDS 4150 FIRE STATION #61 REMODEL 4150-416-420400-928 FIRE STATION 61 CONSTRUCTION TOTAL 4150 FIRE STATION REMODE ------------------------------------------------- 1,793 69,323 67,530 97% ----------- 1,793 ---------- ----------- 69,323 ----------- --------------------- 67,530 -------------------- --------------------- 97% ----------- ----------- 0 9,000 9,000 100% 0 13,000 13,000 100% 0 5,000 5,000 100% ----------- 0 ----------- ---------- ----------- 27,000 ----------- ----------- --------------------- 27,000 --------------------- ----------- ---------- 100% 0 10,000 10,000 100% 0 15,000 15,000 100% 0 1,564 1,564 100% 49 1,436 1,387 97% 655 8,350 7,695 92% 1,331 6,000 4,669 78% 0 6,000 6,000 100% 0 20,000 20,000 100% 378 20,000 19,622 98% 8,316 56,200 47,884 85% 0 5,000 5,000 100% 0 ----------- 6,380 ----------- 6,380 --------------------- 100% 10,729 155,930 145,201 93% 128,199 126,000 2,199- -2% 0 30,000 30,000 100% ---------------------- 128,199 ----------------- ---------------- ----------- 156,000 ---------------------- ----------- ---------- 27,801 ---------- ---------- 18% 34,403 64,656 30,253 47% ---------------------- 34,403 ---------------------- ----------- 64,656 ----------- ---------- 30,253 ---------- 47% 34,403 64,656 30,253 47% ---------------------- 34,403 ----------- 64,656 ---------- 30,253 47% 33,054 92,023 58,969 64% ---------------------- 33,054 --------------------- --------------------- ----------- 92,023 ---------- 58,969 ---------- ---------- 64% ----------- ----------- 24,532 153,942 129,410 84% 9,825 42,023 32,198 77% 3,262 ---------------------- 20,898 ----------- 17,636 ---------- 84% 37,619 --------------------- --------------------- 216,863 ----------- ----------- 179,244 ------- ----- 83% -- - ----- 19,626 10,608 9,018- -85% ---------------------- 19,626 ----------- 10,608 ---------- 9,018- -85% 1111 Ur t\t1L1JetLL Quarterly Finance Report lst Quarter Fiscal 2012 FUND -------------------------------------------------------------------------------------------------------------- FUND ACTUAL YTD BUDGET REMAINING % 4290 WALK & CURB ----------- ----------- --------------------- 4290-410-430234-937 CONSTRUCTION 4,223 25,000 20,777 83% TOTAL 4290 WALK & CURB ----------- 4,223 ----------- 25,000 --------------------- 20,777 83°% 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 0 65,975 65,975 100% TOTAL FAA PLANNING GRANT ----------- 0 ----------- ----------- 65,975 ----------- --------------------- 65,975 -------------------- 100% Page 18 25.00% Yr Complete 111t yr nH I1 eGLL Quarterly Finance Report lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING Page 19 25.00°% Yr Complete ENTERPRISE FUNDS WATER REVENUE 5210-000-343210-000 METERED WATER SALES 834,653 2,203,000 1,368,347 62% 5210-000-343220-000 UNMETERED WATER SALES 0 5,000 5,000 100°% 5210-000-343225-000 IMPACT FEES 69,435 225,000 155,565 69% 5210-000-343230-000 METER REPLACEMENT FEE 25,846 95,000 69,154 73% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 3,786 12,000 8,214 68% 5210-000-343265-000 IMPACT ADMIN FEES 0 13,000 13,000 100% 5210-000-343270-000 WATER TURN ON FEES 660 3,000 2,340 78% 5210-000-343275-000 TAG FEE 4,780 20,000 15,220 76% 5210-000-371010-000 INVESTMENT EARNINGS ----------- 11,628 55,000 ----------- 43,372 ----------- ---------- 79% TOTAL WATER REVENUE 950,788 2,631,000 1,680,212 64% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 149,285 662,555 513,270 77% 5210-447-430550-112 SALARIES -RETIREMENT 2,652 7,000 4,348 62% 5210-447-430550-121 OVERTIME 4,258 20,000 15,742 79% 5210-447-430550-153 HEALTH INSURANCE 44,551 146,924 102,373 70% 5210-447-430550-155 RETIREMENT 9,819 41,289 31,470 76% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 2,970 12,450 9,480 76% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 1,250 19,500 18,250 94% 5210-447-430550-226 CHLORINE & CHEMICALS 15,007 38,000 22,993 61% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 147 4,800 4,653 97% 5210-447-430550-231 GAS & OIL 5,034 29,000 23,966 83% 5210-447-430550-312 POSTAGE & PRINTING 161 4,500 4,339 96% 5210-447-430550-336 LICENSES & FEES 0 19,000 19,000 100% 5210-447-430550-341 ELECTRICITY 30,490 143,000 112,510 79% 5210-447-430550-344 NATURAL GAS 573 13,000 12,427 96% 5210-447-430550-345 TELEPHONE & COMMUNICATION 2,130 8,000 5,870 73% 5210-447-430550-349 LAB SERVICES 3,220 25,500 22,280 87% 5210-447-430550-353 AUDITING 0 3,000 3,000 100% 5210-447-430550-354 CONTRACT SERVICES 8,288 70,000 61,713 88% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 392 25,000 24,608 98% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 4,442 14,950 10,508 70% 5210-447-430550-366 BUILDING MAINTENANCE 275 17,000 16,725 98% 5210-447-430550-373 DUES & TRAINING 1,231 7,200 5,969 83% 5210-447-430550-388 MEDICAL SERVICES 183 700 517 74% 5210-447-430550-410 CONSTRUCTION MATERIALS 11,034 30,000 18,966 63% 5210-447-430550-422 HYDRANTS 5,887 15,000 9,113 61% 5210-447-430550-423 MATERIALS FOR MAINS 0 11,000 11,000 100% 5210-447-430550-424 MATERIALS -SERVICE LINES 2,310 9,000 6,690 74% 5210-447-430550-425 MATERIALS PUMPS/WELLS 1,196 36,000 34,804 97% 5210-447-430550-510 PROPERTY & LIABILITY INS. 33,193 34,500 1,307 4% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 4,400 11,500 7,101 62% 5210-447-430550-513 UNINSURED LOSS -GOODWILL 0 7,500 7,500 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 2,000 8,000 6,000 75% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 22,796 91,185 68,389 75% 5210-447-430550-528 DATA PROCESSING TRANSFER 5,010 20,041 15,031 75°% 5210-447-430550-532 LEASE PAYMENTS 3,919 7,838 3,919 50% 5210-447-430550-935 ARMORY WELL GENERATOR REPLACEMENT 0 90,000 90,000 100% 5210-447-430550-940 MACHINERY & EQUIPMENT 0 45,000 45,000 100% 5210-447-430550-944 METER MAINTENANCE VEHICLE 0 25,000 25,000 100% 5210-447-430550-948 METERS (METER FUNDS) 30,403 75,000 44,598 59% 5210-447-430550-951 SECURITY SYSTEM UPGRADES 0 40,000 40,000 100% 5210-447-430550-956 UPPER/LOWER INTERCONNECTION 28,756 30,000 1,244 4% 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 0 411,800 411,800 100% 5210-447-430550-963 ABANDON 2" H2O LINE 0 45,000 45,000 100% 5210-447-430550-964 2ND AVE WN H2O LINE REPLACE 0 248,000 248,000 100% 5210-447-430550-965 E AZ H2O LINE UPSIZE 0 195,000 195,000 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 50,000 50,000 100% 5210-447-430555-941 METERS (NEW SERVICES) 30,623 65,000 34,378 53% 5210-447-430555-953 SECTION 36 WELL 0 46,000 46,000 100% ----------- TOTAL WATER FACILITIES ----------- 467,881 ----------- 2,979,732 ----------- --------------------- 2,511,851 ----------- ---------- 84% Quarterly vFinance rReport 1st Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % ---------------------------------------------------------------------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 20,182 89,596 69,414 77% 5210-447-430560-153 HEALTH INSURANCE 7,924 25,283 17,359 690 5210-447-430560-155 RETIREMENT 1,307 5,823 4,516 78% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 1,224 3,225 2,001 62% 5210-447-430560-353 AUDITING 0 1,500 1,500 100% 5210-447-430560-354 CONTRACT SERVICES 230 5,000 4,771 95% 5210-447-430560-355 BILLING COSTS 7,433 27,775 20,342 73% 5210-447-430560-373 DUES & TRAINING 46 1,500 1,454 97% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 1,740 6,961 5,221 75% 5210-447-430560-528 DATA PROCESSING TRANSFER 5,510 22,041 16,531 75% 5210-447-430560-532 RENT 3,919 7,838 3,919 50% TOTAL WATER BILLING ----------- 49,517 ----------- ----------- 196,542 ----------- --------------------- 147,025 --------------------- 75% REVENUE BONDS 5210-447-490204-610 2004 BOND PRINCIPAL (HWY93) 0 55,000 55,000 100% 5210-447-490204-620 2004 BOND INTEREST (HWY93) 0 41,195 41,195 100% 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% 0 76,651 76,651 100% 5210-447-490250-610 SRF 2001 PRINCIPAL 4% 0 39,000 39,000 1000 5210-447-490250-620 SRF 2001 INTEREST 4% 0 17,340 17,340 100% TOTAL REVENUE BONDS ----------- 300 ----------- ----------- 415,486 ----------- ----------- ---------- 415,186 --------------------- 100% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 825,000 825,000 100% TOTAL DEPRECIATION ----------- 0 ----------- ----------- 825,000 ----------- --------------------- 825,000 ----------- ---------- 100% TOTAL WATER FUND 517,698 ----------- ---------- 4,416,760 ----------- ----------- 3,899,062 ------------------- -------------------- 88% Page 20 25.00% Yr Complete 1,11T Vt KALIS116LL Quarterly Finance Report lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING o Page 21 25.00% Yr Complete --------------------------------------------------------------- SEWER REVENUE: 5310-000-343310-000 SEWER SERVICE CHARGES 5310-000-343330-000 IMPACT FEES (SANITARY) 5310-000-343335-000 IMPACT FEES (WWTP) 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 5310-000-371010-000 INVESTMENT EARNINGS TOTAL SEWER REVENUE EXPENDITURES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 5310-454-430620-153 HEALTH INSURANCE 5310-454-430620-155 RETIREMENT 5310-454-430620-215 OFFICE SUPPLIES/computers 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 5310-454-430620-355 BILLING COSTS 5310-454-430620-373 DUES & TRAINING 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5310-454-430620-528 DATA PROCESSING TRANSFER 5310-454-430620-532 OFFICE RENT TOTAL SEWER BILLING COSTS SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 5310-454-430630-112 SALARIES-SEVERANCE/RETIREMENT 5310-454-430630-121 OVERTIME 5310-454-430630-153 HEALTH INSURANCE 5310-454-430630-155 RETIREMENT 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 5310-454-430630-231 GAS & OIL 5310-454-430630-312 POSTAGE 5310-454-430630-341 ELECTRICITY 5310-454-430630-342 WATER 5310-454-430630-344 NATURAL GAS 5310-454-430630-345 TELEPHONE & COMMUNICATION 5310-454-430630-353 AUDITING 5310-454-430630-354 CONTRACT SERVICES 5310-454-430630-356 CONSULTANTS 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 5310-454-430630-373 DUES & TRAINING 5310-454-430630-388 MEDICAL SERVICES 5310-454-430630-410 CONSTRUCTION MATERIALS 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 5310-454-430630-510 PROPERTY & LIABILITY INS. 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 5310-454-430630-521 CENTRAL GARAGE TRANSFER 5310-454-430630-522 ADMINISTRATIVE TRANSFER 5310-454-430630-528 DATA PROCESSING TRANSFER 5310-454-430630-532 OFFICE RENT 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK TOTAL SANITARY SEWER/COLLECTIO SANITARY SEWER PLANT INVEST $ 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE TOTAL SANITARY SEWER PLANT INV REVENUE BONDS/SANITARY 5310-454-490204-610 PRINCIPAL-2004 BONDS(HWY 93 S) 953,223 3,730,000 2,776,777 74% 25,585 118,497 92,912 78% 34,500 158,142 123,642 78% 0 2,000 2,000 100% 13,064 ----------- 65,000 51,936 80% 1,026,372 ----------- 4,073,639 --------------------- 3,047,267 75% 16,448 73,305 56,857 78% 5,487 16,805 11,318 67% 1,063 4,685 3,622 77% 1,224 2,225 1,001 45% 0 4,000 4,000 100% 7,663 30,775 23,112 75% 46 1,400 1,354 97% 1,451 5,803 4,352 75% 5,510 22,041 16,531 75% 3,919 7,838 3,919 50% ----------- 42,811 ----------- ----------- 168,877 ----------- --------------------- 126,066 --------------------- 75% 52,068 267,961 215,893 81% 1,078 5,000 3,922 78% 857 7,500 6,643 89% 17,780 62,496 44,716 72% 3,422 16,839 13,417 80% 948 6,200 5,252 85% 153 8,500 8,347 98% 33 2,300 2,267 99% 1,567 9,500 7,933 84% 0 300 300 100% 6,830 43,000 36,170 84% 0 175 175 100% 2,557 13,000 10,443 80% 5,298 21,700 16,402 76% 0 2,000 2,000 100% 2,992 26,000 23,008 88% 0 7,500 7,500 100% 250 6,800 6,550 96% 70 2,500 2,430 97% 63 850 787 93% 1,178 9,000 7,822 87% 4,425 15,000 10,575 71% 65,059 67,000 1,941 3% 1,001 18,000 17,000 94% 625 2,500 1,875 75% 15,893 63,571 47,678 75% 3,674 14,697 11,023 75% 3,919 7,838 3,919 50% 0 25,500 25,500 100% ----------- 191,740 ----------- ----------- 733,227 ----------- --------------------- 541,487 --------------------- 74% 0 ---------------------- 45,000 45,000 100% 0 ----------- 45,000 ----------- --------------------- 45,000 --------------------- 100% 0 66,000 66,000 100% 1111 uk KHLIJYY,LL Quarterly Finance Report 1st Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % Page 22 25.00% Yr Complete -------------------------------------------------------------------------------------------------------- 5310-454-490204-620 INTEREST-2004 BONDS 0 39,695 39,695 100% 5310-454-490204-630 FISCAL AGENT FEES 0 300 300 100% TOTAL REVENUE BONDS ----------- 0 ----------- ----------- 105,995 ----------- --------------------- 105,995 --------------------- 100% DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 815,000 815,000 100% TOTAL DEPRECIATION -SANITARY ----------- 0 ----------- ----------- 815,000 ----------- --------------------- 815,000 ----------- ---------- 100% TOTAL SANITARY SEWER 191,740 1,699,222 1,507,482 89% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 78,306 361,807 283,501 78% 5310-455-430640-112 SALARIES -RETIREMENT 1,078 0 1,078- 0% 5310-455-430640-121 OVERTIME 4,251 21,000 16,749 80% 5310-455-430640-153 HEALTH INSURANCE 19,597 65,761 46,164 70% 5310-455-430640-155 RETIREMENT 5,258 22,469 17,211 77% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 0 5,000 5,000 100% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 583 2,500 1,917 77% 5310-455-430640-225 ALUM 0 30,000 30,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 0 12,000 12,000 100% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 1,002 6,500 5,498 85% 5310-455-430640-231 GAS & OIL 2,048 11,000 8,952 81% 5310-455-430640-312 POSTAGE 88 300 212 71% 5310-455-430640-336 LICENSES & FEES 250 10,000 9,750 98% 5310-455-430640-341 ELECTRICITY 26,851 170,000 143,149 84% 5310-455-430640-342 WATER 1,148 6,500 5,352 82% 5310-455-430640-344 NATURAL GAS 6,688 55,000 48,312 88% 5310-455-430640-345 TELEPHONE & COMMUNICATION 964 5,500 4,536 82% 5310-455-430640-353 AUDITING 0 2,750 2,750 100% 5310-455-430640-354 CONTRACT -GLACIER GOLD 24,945 123,000 98,055 80% 5310-455-430640-355 OTHER CONTRACT SERVICES 7,467 38,000 30,533 80% 5310-455-430640-356 CONSULTANTS 941 25,000 24,059 96% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 5310-455-430640-360 MISC. MAINT SERVICES 1,018 18,000 16,982 94% 5310-455-430640-366 BUILDING MAINTENANCE 370 2,300 1,930 84% 5310-455-430640-373 DUES & TRAINING 1,458 9,100 7,642 84% 5310-455-430640-388 MEDICAL SERVICES 0 550 550 100% 5310-455-430640-510 PROPERTY & LIABILITY INS. 41,680 42,500 820 2% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 1,000 4,000 3,000 75% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 30,650 122,598 91,949 75% 5310-455-430640-528 DATA PROCESSING TRANSFER 4,676 18,705 14,029 75% 5310-455-430640-940 MACHINERY & EQUIPMENT 485 30,000 29,515 98% TOTAL WWTP OPERATIONS ----------- 262,800 ----------- 1,236,840 --------------------- 974,040 79% WWTP REPLACEMENT ----------- ----------- --------------------- 5310-455-430645-362 EQUIPMENT MAINTENANCE 9,746 80,000 70,254 88% 5310-455-430645-940 MACHINERY & EQUIPMENT 10,097 173,500 163,403 94% TOTAL WWTP REPLACEMENT ----------- 19,843 ----------- ----------- 253,500 ----------- --------------------- 233,657 ----------- ---------- 92% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 26,205 113,243 87,036 77% 5310-455-430646-153 HEALTH INSURANCE 6,012 18,095 12,083 67% 5310-455-430646-155 RETIREMENT 1,636 6,997 5,361 77% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 0 1,850 1,850 100% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 0 3,000 3,000 100% 5310-455-430646-222 LAB SUPPLIES 2,243 9,000 6,757 75% 5310-455-430646-312 POSTAGE & SHIPPING 0 500 500 100% 5310-455-430646-349 LAB SERVICES 3,428 20,000 16,572 83% 5310-455-430646-362 EQUIPMENT MAINTENANCE 289 4,500 4,211 94% 5310-455-430646-373 DUES & TRAINING 77 2,700 2,623 97% Quarterly Finance Report 1st Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % '------------------------------------------------------------------------------------------------------- TOTAL WWTP LAB OPERATIONS ----------- 39,890 ----------- 179,885 --------------------- 139,995 78% SRF LOAN/WWTP 5310-455-490215-610 DEBT SRF 92003-PRINCIPAL 0 271,000 271,000 100% 5310-455-490215-620 DEBT SRF 92003-INTEREST 0 13,760 13,760 100% TOTAL SRF LOAN/WWTP ----------- 0 ----------- 284,760 --------------------- 284,760 100% DEBT SERVICE SRF -new constr. ----------- ----------- --------------------- 5310-455-490227-610 SRF 2007WWTP PRINCIPAL 0 460,000 460,000 100% 5310-455-490227-620 SRF 2007WWTP INTEREST 0 501,975 501,975 100% SUBTOTAL SRF 2007 ----------- 0 ----------- 961,975 --------------------- 961,975 100% TOTAL WWTP DEBT ----------- 0 ----------- ----------- 1,246,735 ----------- ----------- ---------- 1,246,735 --------------------- 100% CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-831 CITY/EVERGREEN RESERVE TRANSFER 0 1,836,599 1,836,599 100% TOTAL DEPRECIATION ----------- 0 ----------- ----------- 1,836,599 ----------- --------------------- 1,836,599 ----------- ---------- 100% TOTAL WWTP 322,533 4,753,559 4,431,026 93% TOTAL BILLING/SANITARY/WWTP ----------- 6,621,658 -------------------- 6,064,573 920 --------- 557,085 25.00% Yr Complete Quarterly Finance Report lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING o -------------------------------------------------------------------------------------------------------- STORM SEWER REVENUE 5349-000-343033-000 IMPACT FEES 23,877 105,000 81,123 77% 5349-000-343034-000 PERMIT FEES 200 1,200 1,000 83% 5349-000-343035-000 STORM SEWER CHARGES 0 300 300 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 172- 820,000 820,172 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,396 7,500 6,104 81% 5349-000-371010-000 INTEREST ON INVESTMENTS 7,479 22,000 14,521 66% TOTAL STORM REVENUE ----------- 32,780 ---------- ---------- ----------- 956,000 ---------- ----------- --------------------- 923,220 -------------------- --------------------- 97°% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 67,638 333,163 265,525 80% 5349-453-430246-112 SEVERANCE 1,078 7,000 5,922 85% 5349-453-430246-121 OVERTIME 609 5,000 4,391 88% 5349-453-430246-153 HEALTH INSURANCE 20,260 75,239 54,980 73% 5349-453-430246-155 RETIREMENT 4,415 21,041 16,626 79% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 2,146 9,100 6,954 76% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 1,902 3,500 1,598 46% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 1,567 10,500 8,933 85% 5349-453-430246-345 TELEPHONE & COMMUNICATION 211 850 639 75% 5349-453-430246-353 AUDITING 0 600 600 100% 5349-453-430246-354 CONTRACT SERVICE 1,148 6,200 5,052 81% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 582 20,000 19,418 97% 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 169 15,000 14,831 99% 5349-453-430246-360 REPAIR & MAINT SERVICES 72 1,500 1,428 95% 5349-453-430246-362 GROUNDWATER MONITORING 3,577 25,000 21,423 86% 5349-453-430246-371 CURB & GUTTER 510 5,000 4,490 90% 5349-453-430246-373 DUES & TRAINING 552 3,500 2,948 84% 5349-453-430246-388 MEDICAL SERVICES 0 250 250 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 1,568 10,000 8,432 84% 5349-453-430246-510 PROPERTY & LIABILITY INS. 6,969 8,500 1,531 18% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 625 2,500 1,875 75% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 7,594 30,376 22,782 75% 5349-453-430246-528 DATA PROCESSING TRANSFER 1,336 5,344 4,008 75°% 5349-453-430246-530 BNSF LEASE PMT 3,133 5,200 2,067 40% 5349-453-430246-532 OFFICE RENT 3,919 7,838 3,919 50% 5349-453-430246-952 STORM DRAIN CORRECTION 1,315 100,000 98,685 99% 5349-453-430246-954 S MEADOWS SURVEY 0 304,700 304,700 100% 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 ----------- 132,895 1,369,101 1,236,206 90% Page 24 25.00% Yr Complete Quarterly Finance Report lst Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % Page ZS 25.00% Yr Complete ---------------------------------------------------------------- SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 5510-000-343420-000 GARBAGE COLLECTION -BILLED 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 5510-000-371010-000 INVESTMENT EARNINGS TOTAL SOLID WASTE REVENUE SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 5510-460-430840-112 SEVERANCE -RETIREMENT 5510-460-430840-121 OVERTIME 5510-460-430840-153 HEALTH INSURANCE 5510-460-430840-155 RETIREMENT 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 5510-460-430840-231 GAS & OIL 5510-460-430840-341 ELECTRICITY 5510-460-430840-344 NATURAL GAS 5510-460-430840-345 TELEPHONE & COMMUNICATION 5510-460-430840-354 CONTRACT SERVICES 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 5510-460-430840-366 BUILDING MAINTENANCE 5510-460-430840-373 DUES & TRAINING 5510-460-430840-388 MEDICAL SERVICES 5510-460-430840-510 PROPERTY & LIABILITY INS. 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 5510-460-430840-521 CENTRAL GARAGE TRANSFER 5510-460-430840-522 ADMINISTRATIVE TRANSFER 5510-460-430840-528 DATA PROCESSING TRANSFER 5510-460-430840-532 OFFICE RENT 5510-460-430840-944 VEHICLES (Replacement $) 5510-460-430845-224 JANITORIAL SUPPLIES 5510-460-430845-341 ELECTRICITY 5510-460-430845-342 WATER 5510-460-430845-344 NATURAL GAS 5510-460-430845-360 REPAIR & MAINT SERVICES 5510-460-510400-831 DEPRECIATION EXPENSE TOTAL SOLID WASTE EXPENSE ----------------------------------------------- 4,212- 800,000 804,212 101% 336 8,000 7,665 96% 1,571 3,500 1,929 55% 1,772 3,500 1,728 49% ----------- 534- ----------- 815,000 ----------- ---------- 815,534 100% 68,686 351,409 282,723 80% 0 5,500 5,500 100% 272 7,500 7,228 96% 16,777 74,749 57,972 78% 4,331 21,804 17,473 80% 436 3,500 3,064 88% S3 20,000 19,947 100% 122 5,500 5,378 98% 7,884 50,000 42,116 84% 192 1,700 1,508 89% 183 4,000 3,817 95% 140 700 560 80% 1,099 12,000 10,901 91% 0 5,700 5,700 100% 0 2,500 2,500 100% 70 2,500 2,430 97% 80 500 420 84% 10,036 12,500 2,464 20% 0 6,500 6,500 100% 6,500 26,000 19,500 75% 7,459 29,835 22,376 75% 2,338 9,353 7,015 75% 3,919 7,838 3,919 50% 229,134 260,000 30,866 12% 0 350 350 100% 359 3,200 2,841 89% 135 350 215 61% 404 8,500 8,096 95°% 11 2,500 2,489 100% 0 125,000 125,000 100% ----------- 360,621 ---------------------- 1,061,488 ---------- 700,867 66% L111 UN nHLiJehjLL Quarterly Finance Report 1st Quarter Fiscal 2012 FUND FUND ACTUAL YTD BUDGET REMAINING % Page 26 25.00% Yr Complete 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 2,415 7,200 4,785 66% 5160-000-343063-000 TIE DOWN FEES 1,120 3,500 2,380 68% 5160-000-343069-000 HANGER LEASES 4,060 12,000 7,940 66% 5160-000-343071-000 HANGAR SITE LEASES 16,503 15,600 903- -6% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 4,198 17,000 12,802 75% 5160-000-343102-000 GROUND LEASES 11,385 11,385 0 0% 5160-000-343620-000 FUEL TAX 1,968 5,500 3,532 64% 5160-000-371010-000 INVESTMENT EARNINGS ----------- 5,544 16,500 10,956 66% TOTAL AIRPORT REVENUE 47,194 ----------- 88,685 --------------------- 41,491 47% 5160 AIRPORT OPERATIONS -exp. 5160-430-430310-110 SALARIES 7,965 33,744 25,779 76% 5160-430-430310-111 SEASONAL SALARIES 1,261 3,262 2,002 61% 5160-430-430310-153 HEALTH INSURANCE 1,624 4,586 2,962 65% 5160-430-430310-155 RETIREMENT 596 2,406 1,810 7S% 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 68 1,150 1,082 94% 5160-430-430310-341 ELECTRICITY 231 1,500 1,269 85% 5160-430-430310-345 TELEPHONE 184 1,000 816 82% 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 673 5,800 5,127 88% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 0 6,000 6,000 100% 5160-430-430310-357 CONTRACT SERVICES - legal 3,320 10,000 6,680 67% 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,100 2,000 900 45% 5160-430-430310-510 PROPERTY INSURANCE 1,046 5,000 3,954 79% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 706 2,823 2,117 75% 5160-430-430310-528 DATA PROCESSING TRANSFER 668 2,672 2,004 75% 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 ----------- 20,513 ----------- 253,685 ---------- 233,172 92% 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 272 1,500 1,228 82% 6030-000-393000-000 INTERNAL SERVICES -DATA 37,115 148,461 111,346 75% ----------- TOTAL DATA PROCESSING REVENUE ----------- 124,876 ----------- 325,098 ---------- 200,222 62% DATA PROCESSING EXPENSES 6030-401-410580-110 SALARIES 18,101 96,524 78,423 81% 6030-401-410580-153 HEALTH INSURANCE 5,090 21,940 16,850 77% 6030-401-410580-155 RETIREMENT 1,184 6,267 5,083 81% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 0 3,777 3,777 100% 6030-403-410580-215 COMPUTER SUPPLIES 291 2,850 2,559 90% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 4,206 12,060 7,854 65% 6030-403-410580-325 WEB HOSTING, E-MAIL, ETC. 1,266 12,550 11,284 90% 6030-403-410580-346 SUMMIT NET T1 CONTRACT 28 5,196 5,168 99°% 6030-403-410580-353 LASER FICHE MAINTENANCE 1,485 1,600 115 7% 6030-403-410580-354 MAINTENANCE-Jordahl & Sliter 2,200 4,400 2,200 50% 6030-403-410580-355 LICENSES-PROGRESS,ADG,UST 4,738 28,759 24,021 84% 6030-403-410580-357 GRANICUS 3,000 6,000 3,000 50% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 2,576 16,440 13,864 84% 6030-403-410580-373 SCHOOL & TRAVEL 30 5,200 5,170 99% 6030-403-410580-510 INSURANCE 1,163 1,350 187 14% 6030-403-410585-229 COPIER,FAX, SUPPLIES 0 5,000 5,000 100% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 17,446 70,000 52,554 75% 6030-403-410585-532 COPIER LEASES 6,816 32,000 25,184 79% 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% -- -1 -- l- rage z 1 Quarterly Finance Report lst Quarter Fiscal 2012 25.00% Yr Complete FUND FUND ACTUAL YTD BUDGET REMAINING % ----- -- ----- ------ 6030-413-410588-218 ------- COMPUTERS -- -- - POLICE DEPT --- 0 --- ----- 9,355 --- 9,355 -- 100% 6030-416-410588-218 COMPUTERS - FIRE 0 4,005 4,005 100% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 0 2,135 2,135 100% 6030-436-410588-218 COMPUTERS - PARKS 109 3,052 2,944 96% TOTAL DATA PROCESSING EXPENSE ----------- 72,437 ----------- 387,132 --------------------- 314,695 81%