The URL can be used to link to this page

09-16-16 City Manager Reportr�TYOF _ City of Kalispell OFFICE OF THE CITY MANAGER MONTANA Information Memorandum 9/16/2016 1. Parks Department Park crews have been working in partnership with Flathead Electric Company to prune trees away from light poles at Woodland Park. FEC is currently upgrading all light poles in the park to LED lights. Fresh Life Church continues to partner with Parks and Recreation, volunteering nearly on a monthly basis in our parks. On September 12, volunteers pulled a patch of knapweed from the Lawrence Park hill. A native grass mix will be applied before winter. Park staff are in the process of installing the 3' and final phase to the Lawrence Park playground. Engineered wood fib replace fall surfacing. The engineered wood fiber is free from sharp edges and compacts to allow ADA accessibility. Over time, all playgrounds in Kalispell will be replaced with engineered wood fiber. Staff are beginning to shut down irrigation in Kalispell's 28 parks. This process will take about a month to accomplish. The Street Tree Board is in the final stages of planning this year's Tree Cycle 2016, to be held October 2, from 2:00- 4:00pm. The event will start at the Central School Museum and will take participants on a guided tour of some of Kalispell's notable trees. This year the Street Tree Board has partnered with the County Health Department, Wheaton's, and the Central School Museum to help with this year's bike ride. Runnin' Rascals Football began on September 10. We have 57 participants (6 teams) that are playing in the 4-week league. We also have the NFL Punt, Pass, & Kick competition coming up on September 24. The Punt, Pass, & Kick is a free skills competition for children ages 6-15 in which participants compete in three events for a combined score. We have seven volunteers from the Flathead High School football team that will be assisting with the event. The competition will be held at the Kalispell Youth Sports Complex and winners have the ability to compete in a regional competition. Deadlines for our Little Squirts & Little Dribblers programs are coming soon. Both programs offer a non-competitive introduction to basketball for boys and girls. Basic dribbling, passing, and shooting skills will be practiced. Games are once a week and are played for fun and instructional purposes only. Each game day will have two parts: an instruction/practice period and a scrimmage period. Leagues will take place in October and early November. We currently have over 70 kids registered for these two programs. 2. City Clerk/Communications Manager The City Clerk's office is working on edits to a new video filmed by several employees in the Public Works Department featuring maintenance on the Buffalo Hill water tower. 3. Building Department Residential building permits have been issued for 8 units in the past 2 weeks, bringing the total to 110 single family and duplex units this year compared to 48 single family/duplex units and a 96-unit apartment complex for the same time period in 2015. A commercial building permit was issued for Fuel Fitness, a new health club located at 1305 Hwy 2 West; the valuation for the project is $1,700,000.00. A commercial building permit application was received for a tenant improvement for the Brass Tap Bar & Restaurant @ 85 Treeline Rd. valued at $300,000. The building department has 2 new hires. Jason Landis is our new full-time Inspector and Kari Hernandez our part-time Building Permit Technician. 4. Planning Department The planning office conducted a follow up survey of the West Side Parking District around Flathead High School. Letters and a survey were sent to 75 property owners. Responses are due back on Sept 19 at which time a first year report will be presented to the council for informational purposes. Staff began the first steps to initiate the new Core Area B-3 zone. The first neighborhood selected lies between Main Street and 3rd Avenue East with Idaho serving as the north boundary and Center Street as the south boundary. Letters were sent to all property owners inviting them to an open house at city hall this past Tuesday, September 13. This was in addition to a core area news letter sent to all property owners approximately 3 weeks ago. A work session on this topic was also held with the planning board at the September 13 meeting. No concerns have been voiced by property owners in the neighborhood to date and we are on track to hold a public hearing for adoption for the October 11 Planning Board meeting. Staff envisions using this process to gradually work across the core area between Idaho and Center Street. 2 5. Information Services IT staff updated the Online Payments webpage, http://www.kalispell.com/home/Online_Pa, m�php to include links to pay the following bills online. • Water bill • Ambulance bill • Court fee or fine Ambulance billing patients can now make payments online using a credit card or ACH payment. Instructions have been added to the online payments webpage with information about how to make the payment. The City offers online viewing of City Council and Planning board meetings. The streaming provider has been changed to AV Capture All. The City Council meeting on 9/19/16 will be the first non -test event streamed with AV Capture All. AV Capture All runs on the internet browser similar to Granicus in the past, but will play without having Microsoft Silver Light installed. Firefox, Chrome, or IE will play the streamed meetings. The City's website Meeting on Demand page has been updated. http://www.kalispell.com/maw and city council/Streaming-AV.php 6. Police Department Sergeant Sean McRae and Officer David Massie will be attending a three-day Crisis Negotiator Conference. The conference will expand their knowledge in dealing with high risk negotiations. Attached is the most recent monthly case and arrest report. 7. Human Resources Human Resources coordinated our annual Harassment/Discrimination Awareness Training and was able to get MMIA's new HR Manager Angela Simonson to be the guest speaker. This year, the presentation will be in two parts. Part one, which will be about 40 minutes long, is for all employees. Following that, supervision/management will be asked to remain for part two which is an additional 20-minute session. Human Resources is also finalizing the upcoming four-hour Supervisor Drug and Alcohol Detection/Awareness training for our supervisors and management by Chemnet Consortium. Chemnet Consortium is the company we use to oversee and perform all our employee Drug & Alcohol testing. Periodically, supervision is required to receive training on how to detect if an employee may be under the influence of drugs and/or alcohol and the procedures they are to follow. The annual city employee and dependent's flu clinic has been scheduled for Wednesday October 12, from 9:00 a.m. to 11:00 a.m. at the City Council Chambers. 8. Fire Department Since the last update, the Kalispell Fire Department have received 111 calls for service and have conducted 2 outreach trainings to the public. This time of year, fire department staff spend time coordinating the required inspection and testing of the equipment that we use on a daily basis. Included in this is the testing of our supply and fire attack hose. Approximately 10,000 feet of hose is tested for pressure failures and leaks. Along with that, the air compressors have received their annual maintenance and the air quality compliance testing has been completed. Next week we will be doing our annual pump testing of all of our apparatus. In the near future, we will be conducting the flow testing of our Self Contained Breathing Apparatus and associated equipment and also doing our ladder testing. 9. Finance Department The fiscal year 2017 final budget is being proofed and assembled for submittal to the State by September 30. It will also available for viewing or printing from the City's website. Please find attached a financial report for the first two months of fiscal year 2017. This printout reflects payroll through August 26; about 3.5 pay periods. All funds are included with the exception of the debt service funds, G. O. bonds, Sidewalk & Curb and SID's. REVENUES: General Fund revenue has little activity as taxes will not be received until December. The tax receivables have not been booked. Tan bills will go out the end of October and we will book the receivables/revenue at that time. This also applies to the assessed funds, garbage and storm, as well. Ambulance fees for services shows no activity. This revenue is normally booked quarterly, so fiscal year 2017 revenue will be posted September 30 for July, August and September. Building department revenues are 64% of the budgeted amount as of August 30. All types of impact fees are also outpacing the budget by a significant amount. Both of these are good indications of the growth being seen in the City. Metered water sales are at $722,801, and 75% remaining. It is normal for water sales to exceed the budget early in the fiscal year as consumers "sprinkle" lawns and gardens. Metered water sales thru August of 2016 were $752,034. This difference of slightly over $29,000 is the equivalent of about 12 million more "sprinkling" gallons consumed in July M and August of 2016 as compared to July and August of 2017. Sewer service charges are right where they should be after the first two months with 83% of budgeted revenues remaining. At this point last year sewer service charges were $744,144, about $11,000 more than the same period this fiscal year. EXPENDITURES/EXPENSES: at this point in the year the salary remaining should be about 86%. Some seasonal salaries would be the exception - parks and recreation. Health insurance reflects 1 month paid and should show about 9 1 % remaining. Retirement should be comparable to salaries as far as % remaining. 10. Public Works Development FY 2016 Capital Improvement Report The Annual Capital Improvement Report has been completed for FY 16. The report specifies infrastructure improvements with respective annual costs for water, sanitary sewer, stormwater collection, wastewater treatment, and streets. This information is provided to the Finance Department by the Public Works Department to satisfy the City's annual auditing requirement. The table below is a simplified summary of the report. A copy of the full report can be acquired from the Finance Department. FY 16 Capital Improvement Summarized Report Fire Hydrants # of Hydrants Costs WWTP Projects CIP/Repair Costs Replacement -City Project 7 $24,160 HVAC System in Digester Bld Repair $29,300 New -City Project 4 $16,894 Main Bld Floor Replacement Repair $15,750 New -Private Development 21 $39,696 Replace Fermenter Recirculation Piping Repair $35,026 Water Main Projects Lineal Foot Costs Sewer Main Projects Lineal Foot Costs Replacement -City Project 1,522 $372,032 Replacement -City Project 1,794 $445,104 New -Private Development 6,968 $427,164 New -Private Development 569 $34,153 Water System Projects -City CIP/Rcplace Costs Sewer System Projects -City CIP/Repair Westview Well VFD CIP-New $30,369 Lift Station Bld Enclosures CIP-New $3,309 SCADA System Upgrades CIP-Replace $10,307 Lift Station Communication Upgrades CIP- Replace $15,911 Sheepherder Reservoir Generator CIP-New $2,868 Main Break Repairs Repair $6,215 Old School Well Sand Separator CIP-Replace $15,392 Manhole Rehabilitation Repair $3,525 Water Meter Installation Total Installed os s Street Projects Lineal Foot Costs 3/4" 213 $38,340 City Project -sidewalk 1,589 $71,412 F, 11 $4,235 City Project -alley 6 alleys $28,374 1.5" 10 $6,750 City Project -chip Seal -10,000 $125,100 2" 16 $14,960 City Project-overlay/pavement maint. -9,700 $384,723 3" 1 $1,450 Street Lighting Flathead Electric has started replacing the street light heads throughout the City with an LED system. The LED conversion is anticipated to be completed by summer of next year. LED street lighting will become Flathead Electric's standard specified lighting for new and replacement lights. Public Works is working to update the City's Design and Construction Standard and incorporate the new Flathead LED Standards. Staff will be presenting the change to Council for a Resolution adoption to amend the City's Standards in the near future. 0 Q O OV co l0 rl o VN O.-DO In N cy f0 H c o OV 0Ml01 � mC M l0 O O lN0 Ol vl OC cN-I vl0l vNl vl0l ONl y lN0 N. O z 00 � Q 0 E N � U N 0 � o O O � � 4 Q O O Z c o � O O z N Q O 4 O u O � � Q I L O 01 � v 01 C O n O O � j 0 0 o m m Ol W m N 0 0 o N O O O O ti I� O m 0 I� ti ti co do J O �n .--i io ti rn ti N N N m .--i �p N .--i m .--i 0 0 m m �n .ti N 0 m •--� •--� ti m � N m O � Q O O O M O vl vl N O O N O O O O M N O O I O N 0 7 0 0 00 n m �n _T J � Q O t0 O h O h- t0 - - t0 O h V N N O N N O O� N� Ol O to- N N W V� m N � m O z N Q 0 0 0 0 0 0 N m O O N N NM N l0 O N N m ti 00 rl C J v Q O M O O 00 O C I� O O N 1O O N N l0 N l0 O ti C colft 0 m O T Q O m .--I -0 N V N 0 0 0 0 0 lft o 0 0 m N O�� c-I rl O N 0 lD lft O � N :14 Q O C N �tl O N N N m W 0 0 to 0 0 0 p�.� O l0 O N O N m ti �n ti l0 N m O 1.0 o O N . 0 0 0 0 0 0 0 C ---- 0 - C O m- o- c-I - O a Q -p � N Q O lD .ti ut o lD W m ol N O L U Q 000.0N. m O -.0-00 M O M O 00 Ol N l0 m A m QO C O M O M.- C 00 1p O O O N N O O N m O m 0 I� ti m O � T f0 Q O N O N O N 00 c-I O m N O N 0 0 0 o V O O O Ih 0 0 0 0 0 m 00 J ofO N N O 00 m r r c-I O. m N O N N O O O N N ti O ti O V ill t0 .-I O) O 0 v N m O � T m Q O O O O O 0 0 0 N O O ti ti 0 0 ti 00 O ti O C J C N 00O0 c 0. O Ol OOo m O z - O 0 > pXW O = om Q Y 0UE C N O _� m O 0 o vNOi O O o a Ol 0 > F O .o 3-0�vs v o _E m ovm�os .� o > 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 1 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 64,293 5,490,000 5,425,707 99% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 17,000 17,000 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 108,876 120,000 11,125 9% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 2,743 8,000 5,257 66% 1000-000-322101-000 LIQUOR LICENSES 27 30,000 29,973 100% 1000-000-322300-000 BUSINESS LICENSES 10 1,700 1,690 99% 1000-000-323012-000 PLANNING FEES 13,496 30,000 16,504 55% 1000-000-323109-000 SITE REVIEW 0 14,000 14,000 100% 1000-000-323200-000 PARADE PERMITS 150 1,000 850 85% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 2,000 2,000 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 0 60,000 60,000 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 2,000 2,000 100% 1000-000-335230-000 HB124 ENTITLEMENT 0 2,773,829 2,773,829 100% 1000-000-341020-000 ADMINISTRATIVE CHARGES 0 574,367 574,367 100% 1000-000-341021-000 GRANT ADMIN FEES 0 5,000 5,000 100% 1000-000-341025-000 CITY COLLECTIONS 211 5,000 4,789 96% 1000-000-342010-000 POLICE SERVICES 13,261 25,000 11,739 47% 1000-000-342014-000 RESOURCE OFFICERS 0 149,037 149,037 100% 1000-000-342016-000 KPD REGIONAL TRAINING 0 10,000 10,000 100% 1000-000-343018-000 PARKING PERMITS 23,553 95,000 71,447 75% 1000-000-351000-000 CITY COURT FINES & FEES 0 500,000 500,000 100% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 0 30,000 30,000 100% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 5,398 35,000 29,602 85% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 0 20,000 20,000 100% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 0 7,500 7,500 100% 1000-000-371010-000 INVESTMENT EARNINGS 2,390 15,000 12,610 84% 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 0 16,250 16,250 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 0 901,000 901,000 100% TOTAL GENERAL FUND REVENUE 234,407 10,937,683 10,703,276 98% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 2 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 0 2,935 2,935 100% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 0 14,250 14,250 100% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 199 4,000 3,801 95% 1000-400-410560-312 POSTAGE 810 16,000 15,190 95% 1000-400-410560-320 PRINTING & ENVELOPES 1,194 4,500 3,306 73% 1000-400-410560-354 CONTRACT SERVICES - DOC SHREDDING 123 500 378 76% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 178 4,000 3,822 96% 1000-400-420000-354 CONTRACT 911 CENTER 0 483,000 483,000 100% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 425 425 100% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-000 CONTINGENCY 882 30,000 29,118 97% 1000-400-510310-354 ICMA PLAN FEES 125 500 375 75% 1000-400-510330-513 LIABILITY INSURANCE 61,925 61,925 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 0 50,000 50,000 100% 1000-400-510330-517 PROPERTY INSURANCE 49,965 49,965 0 0% SUBTOTAL GEN.GOV'T. CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 1000-401-410210-153 HEALTH INSURANCE 1000-401-410210-155 RETIREMENT 1000-401-410210-210 COMPUTER SOFTWARE/SUPPLIES 1000-401-410210-312 NEWSLETTER/BOOKS 1000-401-410210-345 TELEPHONE & COMMUNICATION 1000-401-410210-373 DUES & TRAINING 1000-401-410210-379 MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 1000-401-410830-153 HEALTH INSURANCE 1000-401-410830-155 RETIREMENT 1000-401-410830-210 OFFICE SUPPLIES 1000-401-410830-338 RECRUITMENT/RELOCATION 1000-401-410830-354 CONTRACT SERVICES 1000-401-410830-373 DUES & TRAINING SUBTOTAL HUMAN RESOURCES 115,401 743,600 628,199 84% 18,121 137,795 119,674 87% 1,871 22,706 20,835 92% 1,965 14,569 12,604 87% 0 1,500 1,500 100% 0 400 400 100% 40 1,080 1,040 96% 0 8,300 8,300 100% 0 3,400 3,400 100% 21,997 189,750 167,753 88% 16,869 123,814 106,945 86% 1,608 19,565 17,957 92% 1,305 9,466 8,161 86% 0 600 600 100% 1,010 8,000 6,990 87% 40 1,000 960 96% 1,418 6,000 4,582 76% 22,251 168,445 146,194 87% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 3 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 8,906 63,107 54,201 86% 1000-402-410100-153 HEALTH INSURANCE 4,760 57,698 52,938 92% 1000-402-410100-155 RETIREMENT 353 2,445 2,092 86% 1000-402-410100-210 OFFICE SUPPLIES 0 100 100 100% 1000-402-410100-335 MT LEAGUE OF CITIES 0 5,760 5,760 100% 1000-402-410100-354 CONTRACT SERVICES 186 4,500 4,314 96% 1000-402-410100-373 DUES & TRAINING 6,576 6,000 576- -10% 1000-402-410100-379 MEETINGS 0 8,000 8,000 100% SUBTOTAL MAYOR/COUNCIL 20,782 147,610 126,828 86% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 12,073 88,953 76,880 86% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 1,659 20,261 18,602 92% 1000-402-410150-155 RETIREMENT 937 6,832 5,895 86% 1000-402-410150-210 OFFICE SUPPLIES 0 200 200 100% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 0 700 700 100% 1000-402-410150-345 TELEPHONE & COMMUNICATION 40 480 440 92% 1000-402-410150-352 RECODIFICATION 0 3,700 3,700 100% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 50 3,200 3,150 98% SUBTOTAL CITY CLERK 14,759 124,876 110,117 88% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 28,742 210,200 181,458 86% 1000-403-410550-153 HEALTH INSURANCE 3,211 38,445 35,234 92% 1000-403-410550-155 RETIREMENT 2,223 16,121 13,898 86% 1000-403-410550-210 SUPPLIES 0 300 300 100% 1000-403-410550-322 BOOKS 0 250 250 100% 1000-403-410550-353 CONTRACT SERVICES 0 2,000 2,000 100% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 638 2,000 1,362 68% 1000-403-410550-355 BANK CHARGES & FEES 540 3,500 2,960 85% 1000-403-410550-373 DUES & TRAINING 432 6,500 6,068 93% SUBTOTAL FINANCE 35,786 279,316 243,530 87% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 4 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 49,665 364,724 315,059 86% 1000-404-411110-153 HEALTH INSURANCE 4,322 52,592 48,270 92% 1000-404-411110-155 RETIREMENT 3,842 29,906 26,064 87% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 0 2,500 2,500 100% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 1,930 8,000 6,070 76% 1000-404-411110-345 TELEPHONE & COMMUNICATION 250 1,000 750 75% 1000-404-411110-354 CONTRACT SERVICES 0 5,000 5,000 100% 1000-404-411110-373 DUES & TRAINING 0 7,000 7,000 100% SUBTOTAL CITY ATTORNEY 60,010 470,722 410,712 87% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 30,872 226,938 196,066 86% 1000-406-410360-153 HEALTH INSURANCE 4,230 51,568 47,338 92% 1000-406-410360-155 RETIREMENT 2,386 17,373 14,987 86% 1000-406-410360-210 SUPPLIES 0 4,500 4,500 100% 1000-406-410360-320 PRINTING/BOOKS 0 1,500 1,500 100% 1000-406-410360-345 TELEPHONE & COMMUNICATION 0 1,400 1,400 100% 1000-406-410360-353 SECURITY & TECHNOLOGY 90 40,000 39,910 100% 1000-406-410360-354 CONTRACT SERVICES 574 5,750 5,176 90% 1000-406-410360-373 DUES & TRAINING 841 6,300 5,459 87% 1000-406-410360-394 JURY & WITNESS FEES 110 7,500 7,390 99% SUBTOTAL COURT 39,103 362,829 323,726 89% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 2,391 17,333 14,942 86% 1000-410-430100-153 HEALTH INSURANCE 261 3,278 3,017 92% 1000-410-430100-155 RETIREMENT 183 1,300 1,117 86% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 1,775 7,500 5,725 76% 1000-410-430100-231 GAS 103 2,500 2,397 96% 1000-410-430100-345 TELEPHONE & COMMUNICATION 24 300 276 92% 1000-410-430100-354 CONTRACT SERVICES 705 1,850 1,145 62% 1000-410-430100-373 DUES & TRAINING 61 2,500 2,439 98% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 0 3,459 3,459 100% SUBTOTAL PUBLIC WORKS ADMIN 5,502 40,020 34,518 86% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 9,091 67,873 58,782 87% 1000-412-411230-121 OVERTIME 180 0 180- 0% 1000-412-411230-153 HEALTH INSURANCE 1,099 15,847 14,748 93% 1000-412-411230-155 RETIREMENT 690 4,980 4,290 86% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 800 800 100% 1000-412-411230-224 JANITORIAL SUPPLIES 234 6,000 5,766 96% 1000-412-411230-241 TOOLS & SUPPLIES 52 1,500 1,448 97% 1000-412-411230-341 ELECTRICITY 4,432 47,500 43,068 91% 1000-412-411230-344 NATURAL GAS 1,114 40,000 38,886 97% 1000-412-411230-345 TELEPHONE & COMMUNICATION 13 250 237 95% 1000-412-411230-354 CONTRACT SERVICES 2,222 38,500 36,278 94% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 5 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 15,146 17,300 2,154 12% 1000-412-411230-361 ELEVATOR MAINT/ FIRE ALARM MAINT 488 4,500 4,012 89% 1000-412-411230-362 EQUIPMENT MAINTENANCE 140 8,500 8,360 98% 1000-412-411230-366 BUILDING MAINTENANCE 975 20,000 19,025 95% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 40 3,500 3,460 99% 1000-412-411230-920 Public Safety Bldg - painting 0 30,000 30,000 100% SUBTOTAL CITY HALL 35,917 307,050 271,133 88% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 37,648 274,862 237,214 86% 1000-420-411020-153 HEALTH INSURANCE 4,679 59,495 54,816 92% 1000-420-411020-155 RETIREMENT 2,916 21,071 18,155 86% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 0 5,000 5,000 100% 1000-420-411020-231 GAS 27 400 373 93% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 44 2,000 1,956 98% 1000-420-411020-345 TELEPHONE 118 750 632 84% 1000-420-411020-354 CONTRACT SERVICES 0 1,000 1,000 100% 1000-420-411020-373 DUES & TRAINING 0 5,500 5,500 100% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 0 1,295 1,295 100% SUBTOTAL PLANNING DEPT. 45,431 371,373 325,942 88% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 8,572 61,676 53,104 86% 1000-480-470210-153 HEALTH INSURANCE 680 8,243 7,563 92% 1000-480-470210-155 RETIREMENT 663 4,704 4,041 86% 1000-480-470210-210 OFFICE SUPPLIES 0 1,500 1,500 100% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 500 500 100% 1000-480-470210-312 POSTAGE & PRINTING 49 500 451 90% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 65 750 685 91% 1000-480-470210-354 CONTRACT SERVICES 0 1,500 1,500 100% 1000-480-470210-373 DUES & TRAINING 975 5,000 4,025 81% 1000-480-470210-379 MEETINGS 0 1,000 1,000 100% SUBTOTAL COMMUNITY DEVELOPMENT 11,004 85,873 74,869 87% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 6 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 307,412 2,114,612 1,807,201 85% 1000-413-420140-112 SALARIES -SEVERANCE 31,782 33,500 1,718 5% 1000-413-420140-114 SALARY -comptime buyout 4,237 4,350 113 3% 1000-413-420140-121 OVERTIME (REG & AET OT) 13,566 80,000 66,434 83% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 838 25,000 24,162 97% 1000-413-420140-153 HEALTH INSURANCE 35,131 413,628 378,497 92% 1000-413-420140-155 RETIREMENT 37,752 275,152 237,400 86% 1000-413-420140-210 OFFICE SUPPLIES 264 3,500 3,236 92% 1000-413-420140-215 COMPUTER SUPPLIES 60 5,500 5,440 99% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 3,539 48,500 44,961 93% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 361 4,000 3,639 91% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 192 7,000 6,808 97% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 0 2,000 2,000 100% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 108 5,000 4,892 98% 1000-413-420140-227 AMMO & RELATED SUPPLIES 129 19,000 18,871 99% 1000-413-420140-228 PATROL CAR SUPPLIES 468 13,000 12,532 96% 1000-413-420140-229 OTHER SUPPLIES 1,376 10,000 8,624 86% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 204 1,000 796 80% 1000-413-420140-231 GAS 5,197 95,000 89,803 95% 1000-413-420140-234 CRISIS NEGOTIATIONS 1,171 2,000 829 41% 1000-413-420140-235 BIKE PATROL 244 750 506 67% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 0 1,500 1,500 100% 1000-413-420140-320 PRINTING 250 5,500 5,250 95% 1000-413-420140-345 TELEPHONE & COMMUNICATION 1,928 15,500 13,572 88% 1000-413-420140-354 CONTRACT SERVICES 2,668 6,875 4,207 61% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 0 6,500 6,500 100% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 0 2,000 2,000 100% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 1,913 2,000 87 4% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 12,452 40,625 28,173 69% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 53 2,500 2,447 98% 1000-413-420140-373 DUES & TRAINING 5,150 30,000 24,850 83% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 0 10,000 10,000 100% 1000-413-420140-380 TRAINING MATERIALS 0 2,000 2,000 100% 1000-413-420140-388 MEDICAL SERVICES 483 2,500 2,017 81% 1000-413-420140-392 BOARDING/TREATING PRISONERS 333 2,500 2,167 87% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 0 73,718 73,718 100% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 0 67,500 67,500 100% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 0 155,000 155,000 100% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 0 3,500 3,500 100% 1000-413-420140-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 100% 1000-413-420140-944 VEHICLES 0 115,878 115,878 100% SUBTOTAL POLICE DEPT. 469,260 3,735,570 3,266,310 87% DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 1000-413-420141-121 DETECTIVE -OVERTIME 1000-413-420141-153 HEALTH INSURANCE 1000-413-420141-155 DETECTIVE -RETIREMENT TOTAL DETECTIVES RECORDS 47,174 365,552 318,378 87% 789 15,000 14,211 95% 5,398 66,611 61,213 92% 5,869 48,938 43,069 88% 59,230 496,101 436,871 88% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 7 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-110 SALARIES -RECORDS DIVISION 18,573 142,039 123,466 87% 1000-413-420142-121 OVERTIME 193 7,500 7,307 97% 1000-413-420142-153 HEALTH INSURANCE 2,421 32,970 30,549 93% 1000-413-420142-155 RETIREMENT 1,438 10,720 9,282 87% TOTAL RECORDS 22,625 193,229 170,604 88% RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 20,282 182,257 161,975 89% 1000-413-420144-153 HEALTH INSURANCE 2,397 46,773 44,376 95% 1000-413-420144-155 SRO RETIREMENT 2,224 24,447 22,223 91% TOTAL RESOURCE OFFICERS 24,904 253,477 228,573 90% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 6,063 38,723 32,660 84% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 680 8,243 7,563 92% 1000-413-420145-155 RETIREMENT 415 2,920 2,505 86% SUBTOTAL ANIMAL CONTROL 7,158 50,386 43,228 86% PARKING 1000-413-420147-110 PARKINGS -SALARIES 12,419 86,114 73,695 86% 1000-413-420147-153 HEALTH INSURANCE 2,115 30,585 28,470 93% 1000-413-420147-155 RETIREMENT 907 6,494 5,587 86% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 0 4,000 4,000 100% 1000-413-420147-354 CONTRACTED SERVICES 0 2,000 2,000 100% 1000-413-420147-362 LOT MAINT 91 10,000 9,909 99% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 100% 1000-413-420147-550 LOT LEASE PAYMENTS 148 1,500 1,352 90% SUBTOTAL PARKING 15,680 158,193 142,513 90% SUBTOTAL POLICE DEPT. 598,856 4,886,956 4,288,100 88% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 8 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 222,464 1,592,324 1,369,860 86% 1000-416-420400-114 COMPTIME BUYOUT 0 5,500 5,500 100% 1000-416-420400-115 OUT OF RANK PAY 2,674 12,000 9,326 78% 1000-416-420400-121 OVERTIME 19,131 40,000 20,869 52% 1000-416-420400-153 HEALTH INSURANCE 24,520 312,701 288,181 92% 1000-416-420400-155 RETIREMENT 30,276 212,650 182,374 86% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 0 2,000 2,000 100% 1000-416-420400-218 Equipment (Non Capital) 238 21,500 21,262 99% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 328 15,000 14,672 98% 1000-416-420400-224 JANITORIAL SUPPLIES 381 5,000 4,619 92% 1000-416-420400-231 GAS 648 17,325 16,677 96% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 1,128 15,000 13,872 92% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 0 1,000 1,000 100% 1000-416-420400-345 TELEPHONE & COMMUNICATION 862 6,000 5,138 86% 1000-416-420400-354 CONTRACT SERVICES 2,400 12,000 9,600 80% 1000-416-420400-362 EQUIPMENT MAINTENANCE 520 5,500 4,980 91% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 297 7,500 7,203 96% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 576 5,000 4,424 88% 1000-416-420400-373 DUES & TRAINING 539 10,000 9,461 95% 1000-416-420400-388 FIREFIGHTER PHYSICALS 0 25,875 25,875 100% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 0 43,938 43,938 100% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 0 40,000 40,000 100% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 0 150,000 150,000 100% 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 18,454 18,454 100% 1000-416-420400-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 100% 1000-416-420400-940 CAPITAL EQUIPMENT - COMMAND VEHICLE 0 35,000 35,000 100% 1000-416-420440-110 SALARIES -FIRE PREVENTION 6,757 51,287 44,530 87% 1000-416-420440-121 OVERTIME 1,065 0 1,065- 0% 1000-416-420440-153 HEALTH INSURANCE 701 7,826 7,125 91% 1000-416-420440-155 RETIREMENT 571 3,697 3,126 85% SUBTOTAL FIRE DEPT. 316,075 2,701,759 2,385,684 88% GRAND TOTAL GENERAL FUND 1,342,873 10,880,179 9,537,306 88% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 9 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 0 1,600 1,600 100% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 0 9,243 9,243 100% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 1,750,000 1,750,000 100% 2185-480-470240-110 SALARIES 2,670 20,256 17,586 87% 2185-480-470240-153 HEALTH INSURANCE 238 2,935 2,697 92% 2185-480-470240-155 RETIREMENT 206 1,526 1,320 87% 2185-480-470240-345 TELEPHONE & COMMUNICATION 8 48 40 83% TOTAL AIRPORT TIF 3,122 1,785,608 1,782,486 100% 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 5,723 43,983 38,260 87% 2188-480-470230-153 HEALTH INSURANCE 442 5,558 5,116 92% 2188-480-470230-155 RETIREMENT 443 3,337 2,894 87% 2188-480-470230-353 AUDIT 0 2,000 2,000 100% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 0 5,000 5,000 100% 2188-480-470230-356 TELEPHONE 32 0 32- 0% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 0 3,464 3,464 100% 2188-480-470230-840 TRANSFER TO DEBT SERVICE 0 32,340 32,340 100% 2188-480-470240-720 PRE AWARD TIGER 2,340 4,000,000 3,997,660 100% TOTAL WESTSIDE TIF 8,980 4,095,682 4,086,702 100% OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 11,500 11,500 100% 2310-480-470210-356 FED -EX REIMBURSEMENT 0 11,000 11,000 100% 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 0 35,000 35,000 100% 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 0 15,000 15,000 100% TOTAL OLD SCHOOL TIFS 0 72,500 72,500 100% PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND 0 992,000 992,000 100% TOTAL PERMISSIVE HEALTH LEVY 0 992,000 992,000 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 10 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 0 10,000 10,000 100% 2399-413-420140-940 POLICE EQUIPMENT 0 60,000 60,000 100% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 32,500 65,500 33,000 50% 2399-416-420400-620 INTEREST - FIRE TRUCK 2,672 4,651 1,979 43% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 500,000 500,000 100% TOTAL PUBLIC SAFETY IMPACT FEE 35,172 640,151 604,979 95% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 11 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 9,752 970,000 960,248 99% 2215-000-311200-000 PERSONAL PROPERTY TAXES 16,510 35,000 18,490 53% 2215-000-312000-000 PEN & INTEREST DEL TAXES 416 2,000 1,584 79% 2215-000-346030-000 SWIMMING POOL FEES 70,196 140,000 69,804 50% 2215-000-346040-000 CONCESSION STAND REVENUE 25,103 35,000 9,897 28% 2215-000-346050-000 PARKS USAGE FEES 5,973 21,000 15,027 72% 2215-000-346051-000 RECREATION FEES 918 8,000 7,082 89% 2215-000-346052-000 SPORTS PROGRAMS 4,736 45,000 40,264 89% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 102 2,500 2,398 96% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 4,801 70,000 65,199 93% 2215-000-346055-000 ICE RINK 0 25,000 25,000 100% 2215-000-346056-000 KIDSPORT USAGE 25 300 275 92% 2215-000-346057-000 YOUTH CAMPS 5,893 142,000 136,107 96% 2215-000-346059-000 PICNIC IN THE PARK 1,842 30,000 28,158 94% 2215-000-365010-000 FEC REFUNDS/DONATIONS 505 0 505- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-365016-000 FLATHEAD INDUSTRIES REIMBURSEMENT 4,000 0 4,000- 0% 2215-000-371010-000 INVESTMENTS 603 2,000 1,397 70% 2215-000-381050-000 INCEPTION OF LEASE 0 130,000 130,000 100% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 91,000 91,000 100% TOTAL PARKS & REC REVENUE 151,376 1,768,800 1,617,424 91% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 43,053 316,192 273,139 86% 2215-436-460430-111 SEASONAL SALARIES 18,403 65,276 46,873 72% 2215-436-460430-121 OVERTIME 0 500 500 100% 2215-436-460430-153 HEALTH INSURANCE 5,069 61,643 56,575 92% 2215-436-460430-155 RETIREMENT 3,993 26,136 22,143 85% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 37 1,000 963 96% 2215-436-460430-224 JANITORIAL SUPPLIES 1,106 5,000 3,894 78% 2215-436-460430-229 OTHER SUPPLIES 541 4,000 3,459 86% 2215-436-460430-231 GAS 1,857 18,000 16,143 90% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 26 2,500 2,474 99% 2215-436-460430-320 PRINTING & ADVERTISING 0 400 400 100% 2215-436-460430-341 ELECTRICITY 1,698 16,000 14,302 89% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 25,000 25,000 100% 2215-436-460430-344 NATURAL GAS 66 3,000 2,934 98% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 706 3,040 2,334 77% 2215-436-460430-351 TENNIS COURT REHABILITATION 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 0 5,000 5,000 100% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 2,680 2,680 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 404 5,000 4,596 92% 2215-436-460430-364 LANDSCAPING 0 5,500 5,500 100% 2215-436-460430-367 VANDALISM REPAIRS 100 4,000 3,900 98% 2215-436-460430-373 DUES & TRAINING 757 6,000 5,243 87% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 600 600 100% 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 3,000 3,000 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 12 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-440 IRRIGATION SUPPLIES 1,080 9,000 7,920 88% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 0 1,700 1,700 100% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 0 43,857 43,857 100% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 4,542 29,112 24,570 84% 2215-436-460430-620 DEBT SERVICE INTEREST 141 784 643 82% 2215-436-460430-941 CAPITAL OUTLAY: FLATBED, MOWER, WOO 0 130,000 130,000 100% 2215-436-460430-942 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% SUBTOTAL PARKS EXPENDITURES 83,579 805,420 721,841 90% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 7,538 89,153 81,615 92% 2215-436-460440-111 SEASONAL SALARIES 13,474 41,906 28,432 68% 2215-436-460440-153 HEALTH INSURANCE 1,046 25,922 24,876 96% 2215-436-460440-155 RETIREMENT 1,336 10,046 8,710 87% 2215-436-460440-221 SAFETY EQUIPMENT 0 350 350 100% 2215-436-460440-229 OTHER SUPPLIES 3,590 15,500 11,910 77% 2215-436-460440-231 GAS 576 10,500 9,924 95% 2215-436-460440-241 CONSUMABLE TOOLS 1,222 1,500 278 19% 2215-436-460440-341 ELECTRICITY 1,414 7,700 6,286 82% 2215-436-460440-345 TELEPHONE & COMMUNICATION 12 175 163 93% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-355 CONTRACT SERVICES - ASPHALT RESURFC 0 40,534 40,534 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 0 600 600 100% 2215-436-460440-364 LANDSCAPING 0 600 600 100% 2215-436-460440-367 VANDALISM REPAIRS 300 500 200 40% 2215-436-460440-373 DUES & TRAINING 0 500 500 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-420 METAL PRODUCTS 0 300 300 100% 2215-436-460440-440 IRRIGATION 1,627 4,000 2,373 59% 2215-436-460440-452 SAND & GRAVEL 0 1,000 1,000 100% 2215-436-460440-940 EQUIPMENT 0 24,000 24,000 100% SUBTOTAL ATHLETIC COMPLEX 32,135 275,936 243,801 88% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 10,986 81,678 70,692 87% 2215-436-460431-111 SEASONAL SALARIES 985 8,285 7,300 88% 2215-436-460431-153 HEALTH INSURANCE 1,635 23,906 22,271 93% 2215-436-460431-155 RETIREMENT 843 6,705 5,862 87% 2215-436-460431-229 MISC. SUPPLIES 879 9,435 8,556 91% 2215-436-460431-231 GAS 49 590 541 92% 2215-436-460431-320 PRINTING & ADVERTISING 0 10,800 10,800 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 0 1,661 1,661 100% 2215-436-460431-354 CONTRACT SERVICES 11,250 19,093 7,843 41% 2215-436-460431-357 MUSIC FRANCHISE FEES 0 1,100 1,100 100% 2215-436-460431-373 DUES & TRAINING 0 728 728 100% SUBTOTAL RECREATION 26,626 163,981 137,355 84% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 9,765 72,793 63,028 87% 2215-436-460448-111 SEASONAL SALARIES 50,769 136,855 86,086 63% 2215-436-460448-121 OVERTIME 0 300 300 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 13 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 2215-436-460448-153 HEALTH INSURANCE 1,539 22,953 21,414 93% 2215-436-460448-155 RETIREMENT 749 6,424 5,675 88% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 166 400 234 58% 2215-436-460448-229 MISC. SUPPLIES 487 3,600 3,113 86% 2215-436-460448-231 GAS 99 300 201 67% 2215-436-460448-320 PRINTING & ADVERTISING 0 100 100 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 26 765 739 97% 2215-436-460448-354 CONTRACT SERVICES 2,784 13,000 10,216 79% 2215-436-460448-355 AFTER SCHOOL PROGRAM 0 800 800 100% 2215-436-460448-356 BANK FEES/CC CHARGES 474 3,900 3,426 88% 2215-436-460448-373 DUES & TRAINING 0 800 800 100% SUBTOTAL YOUTH CAMPS 66,859 262,990 196,131 75% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 111,194 190,325 79,131 42% 2215-437-460445-112 SEVERANCE 0 2,535 2,535 100% 2215-437-460445-121 OVERTIME 187 500 313 63% 2215-437-460445-155 RETIREMENT 769 1,500 731 49% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 851 400 451- -113% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 947 2,200 1,253 57% 2215-437-460445-226 CHLORINE/CHEMICALS 17,136 25,000 7,864 31% 2215-437-460445-228 CONCESSION STAND SUPPLIES 8,540 21,000 12,460 59% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 749 4,500 3,751 83% 2215-437-460445-341 ELECTRICITY 1,866 9,500 7,634 80% 2215-437-460445-344 NATURAL GAS 7,017 25,000 17,983 72% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 239 1,620 1,381 85% 2215-437-460445-354 LICENSES & FEES 0 1,300 1,300 100% 2215-437-460445-356 BANK FEES/ CC CHARGES 0 1,200 1,200 100% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 1,868 14,600 12,732 87% 2215-437-460445-380 TRAINING MATERIALS 0 1,800 1,800 100% SUBTOTAL POOL EXPENDITURES 151,364 302,980 151,616 50% TOTAL PARKS & RECREATION/POOL 360,563 1,811,307 1,450,744 80% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 14 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING FORESTRY & DEVELOPER TREES 2600-436-460433-110 SALARIES -URBAN FORESTRY 13,453 107,421 93,968 87% 2600-436-460433-111 SEASONAL SERVICES 558 25,731 25,173 98% 2600-436-460433-121 OVERTIME 0 300 300 100% 2600-436-460433-153 HEALTH INSURANCE 1,722 24,764 23,042 93% 2600-436-460433-155 RETIREMENT 1,056 9,713 8,657 89% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 26 600 574 96% 2600-436-460433-231 GAS 58 4,500 4,442 99% 2600-436-460433-241 CONSUMABLE TOOLS 0 4,500 4,500 100% 2600-436-460433-354 CONTRACT SERVICES 0 35,000 35,000 100% 2600-436-460433-357 FORESTRY GRANT 0 11,880 11,880 100% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 1,650 6,750 5,100 76% 2600-436-460433-362 EQUIPMENT MAINTENANCE 0 4,000 4,000 100% 2600-436-460433-364 LANDSCAPING & TREES 0 8,000 8,000 100% 2600-436-460433-373 DUES & TRAINING 0 2,000 2,000 100% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 628 628 0 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 0 7,368 7,368 100% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 0 8,272 8,272 100% 2600-436-460433-528 DATA PROCESSING TRANSFER 0 4,171 4,171 100% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 5,419 15,000 9,581 64% 2600-436-460433-620 INTEREST EXPENSE 374 1,000 626 63% 2600-436-460433-940 MACHINERY & EQUIPMENT 0 40,000 40,000 100% TOTAL URBAN FORESTRY 24,945 321,598 296,653 92% 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-354 CONTRACT SERVICES 2601-436-460435-356 SINOPAH SUBD ($5,790) 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 2601-436-460435-358 WEST VIEW SUBD ($22,680) 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 2601-436-460435-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) 2601-436-460435-368 NORTHLAND SUBD PHASE 4 TOTAL DEVELOPER TREES 2210 PARKS IN LIEU 2210-436-460430-934 CAPITAL IMPROVEMENTS TOTAL PARKS IN LIEU 2975 TRAILS TOTAL TRAILS 0 8,653 8,653 100% 0 4,336 4,336 100% 0 366 366 100% 0 11,231 11,231 100% 0 667 667 100% 0 1,928 1,928 100% 0 16,236 16,236 100% 0 27,079 27,079 100% 0 2,219 2,219 100% 0 948 948 100% 0 1,390 1,390 100% 0 1,134 1,134 100% 0 2,797 2,797 100% 0 8,490 8,490 100% 0 2,716 2,716 100% 0 8,812 8,812 100% 0 99,002 99,002 100% 0 1,417 1,417 100% 0 1,417 1,417 100% 0 0 0 0% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 15 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 16 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 0 891,000 891,000 100% 2230-000-342070-000 COUNTY EMS LEVY 0 110,000 110,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 0 150,000 150,000 100% TOTAL AMBULANCE REVENUE 0 1,151,000 1,151,000 100% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 84,390 608,459 524,069 86% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 279 1,000 721 72% 2230-440-420730-121 OVERTIME 5,812 50,000 44,188 88% 2230-440-420730-153 HEALTH INSURANCE 12,027 159,142 147,115 92% 2230-440-420730-155 RETIREMENT 11,274 80,552 69,278 86% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 0 1,000 1,000 100% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 0 4,000 4,000 100% 2230-440-420730-231 GAS & OIL 485 7,560 7,075 94% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 0 4,000 4,000 100% 2230-440-420730-312 POSTAGE/PRINTING 0 1,500 1,500 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 246 1,200 954 80% 2230-440-420730-354 CONTRACT SERVICES 744 17,800 17,056 96% 2230-440-420730-355 911 CENTER CONTRIBUTION 0 34,000 34,000 100% 2230-440-420730-359 AUDIT/CC OTHER FEES 454 1,400 946 68% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 0 5,000 5,000 100% 2230-440-420730-373 DUES & TRAINING 115 5,000 4,885 98% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 1,630 46,000 44,370 96% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 7,614 7,614 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 0 16,229 16,229 100% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 0 42,099 42,099 100% 2230-440-420730-528 DATA PROCESSING TRANSFER 0 16,684 16,684 100% 2230-440-420730-940 EQUIPMENT 0 170,000 170,000 100% TOTAL AMBULANCE EXPENDITURES 125,071 1,286,239 1,161,168 90% FIRE & HAZMAT GRANTS 2956-416-420400-218 EQUIPMENT (NON CAPITAL) 0 2,200 2,200 100% 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 0 3,000 3,000 100% 2956-416-420415-940 AFG GRT (POWER COTS) EMW2014FOO5022 0 225,000 225,000 100% TOTAL FIRE GRANTS 0 230,200 230,200 100% 2957-416-420400-155 RETIREMENT 0 2,500 2,500 100% 2957-416-420410-125 PASS THRU HAZMAT OT 486 19,365 18,879 97% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 1,181 33,113 31,932 96% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 6,100 6,100 100% TOTAL HAZMAT GRANTS 1,667 61,078 59,411 97% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 17 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 214,175 350,000 135,825 39% 2394-000-323103-000 PLUMBING PERMITS 10,016 20,000 9,984 50% 2394-000-323104-000 MECHANICAL PERMITS 8,196 30,000 21,805 73% 2394-000-323105-000 ELECTRICAL PERMITS 13,062 30,000 16,938 56% 2394-000-323108-000 PLAN REVIEW FEES 96,646 100,000 3,354 3% 2394-000-371010-000 INVESTMENT EARNINGS 1,201 4,500 3,299 73% TOTAL REVENUE 343,295 534,500 191,205 36% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 41,311 374,578 333,267 89% 2394-420-420530-121 OVERTIME 1,635 5,000 3,365 67% 2394-420-420530-153 HEALTH INSURANCE 4,724 85,277 80,553 94% 2394-420-420530-155 RETIREMENT 3,195 27,529 24,334 88% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 2,365 20,000 17,635 88% 2394-420-420530-231 GAS & OIL 202 3,500 3,298 94% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 138 2,500 2,362 94% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 3,000 3,000 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 376 3,500 3,124 89% 2394-420-420530-354 CONTRACT SERVICES 3,305 43,500 40,195 92% 2394-420-420530-355 CITY WORKS LICENSING FEE 0 15,000 15,000 100% 2394-420-420530-373 DUES & TRAINING 195 9,000 8,805 98% 2394-420-420530-510 PROPERTY INSURANCE 2,585 2,585 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 0 1,454 1,454 100% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 0 16,282 16,282 100% 2394-420-420530-528 DATA PROCESSING TRANSFER 0 29,196 29,196 100% 2394-420-420530-944 VEHICLES 0 65,000 65,000 100% TOTAL BUILDING DEPT. 60,032 706,901 646,869 92% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 18 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 9,572 70,405 60,833 86% 2400-410-430263-153 HEALTH INSURANCE 944 13,628 12,684 93% 2400-410-430263-155 RETIREMENT 706 5,141 4,435 86% 2400-410-430263-244 STREET LIGHT SUPPLIES 0 18,000 18,000 100% 2400-410-430263-341 ELECTRICITY 13,382 173,000 159,618 92% 2400-410-430263-360 REPAIR & MAINT SERVICES 1,527 20,000 18,473 92% 2400-410-430263-510 INSURANCE 392 1,000 608 61% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 0 12,648 12,648 100% 2400-410-430263-920 NEW LUMINAIRES 0 30,000 30,000 100% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 10,905 21,862 10,957 50% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 339 681 342 50% TOTAL LIGHT MAINT. 37,766 366,365 328,599 90% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 984 56,485 55,501 98% 2420-421-430234-957 ALLEY PAVING 0 41,627 41,627 100% 2420-421-430240-231 GAS & OIL 1,800 43,000 41,200 96% 2420-421-430240-344 NATURAL GAS 28 5,500 5,473 100% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 1,500 1,500 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 0 225,562 225,562 100% 2420-421-430240-452 GRAVEL 0 3,500 3,500 100% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 3,753 40,000 36,247 91% 2420-421-430240-472 ASPHALT 8,643 53,000 44,357 84% 2420-421-430240-473 CRACK SEALING 0 14,500 14,500 100% 2420-421-430240-474 PAINT STRIPING MATERIALS 1,087 60,000 58,913 98% TOTAL GAS TAX 16,295 569,674 553,379 97% 2825 MACI GRANT 2825-421-430240-940 SANDER / SWEEPER 0 433,202 433,202 100% TOTAL MACI GRANT 0 433,202 433,202 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 19 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 90,965 709,550 618,585 87% 2500-421-430240-121 OVERTIME 472 25,000 24,528 98% 2500-421-430240-153 HEALTH INSURANCE 11,909 172,495 160,586 93% 2500-421-430240-155 RETIREMENT 6,734 51,452 44,718 87% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 0 9,000 9,000 100% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 262 6,500 6,238 96% 2500-421-430240-220 OTHER SUPPLIES 812 4,500 3,688 82% 2500-421-430240-231 GAS & OIL 1,975 40,000 38,025 95% 2500-421-430240-341 ELECTRICITY 193 3,300 3,107 94% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 122 1,500 1,378 92% 2500-421-430240-354 CONTRACT SERVICES 134 30,000 29,866 100% 2500-421-430240-356 CONSULTANT - TRANSPORTATION PLAN UP 0 62,892 62,892 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 1,098 32,500 31,402 97% 2500-421-430240-366 BUILDING MAINTENANCE 21 3,000 2,979 99% 2500-421-430240-373 DUES & TRAINING 25 5,500 5,475 100% 2500-421-430240-388 MEDICAL SERVICES 0 1,500 1,500 100% 2500-421-430240-510 LIABILITY INSURANCE 13,578 13,578 0 0% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 0 179,219 179,219 100% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 0 90,571 90,571 100% 2500-421-430240-528 DATA PROCESSING TRANSFER 0 12,513 12,513 100% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 55,882 111,946 56,064 50% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 1,716 3,447 1,731 50% 2500-421-430240-920 SALT BRINE TANK 0 20,000 20,000 100% 2500-421-430240-921 SAND/COLD MIX STORAGE SHED 0 25,771 25,771 100% 2500-421-430240-922 USFS PROPERTY ACQUISITION 0 54,964 54,964 100% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 2500-421-430240-969 4TH AVE E MAIN REPLC PHASE 1-4 0 1,114,018 1,114,018 100% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 88,740 762,359 673,619 88% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 2,044 300,544 298,500 99% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% 2500-421-430264-110 TSS - SALARIES 16,599 122,685 106,086 86% 2500-421-430264-121 OVERTIME 261 7,500 7,239 97% 2500-421-430264-153 HEALTH INSURANCE 1,360 17,485 16,125 92% 2500-421-430264-155 RETIREMENT 1,225 8,823 7,598 86% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 0 1,500 1,500 100% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 243 6,700 6,457 96% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 0 3,500 3,500 100% 2500-421-430264-242 STREET SIGNS 2,538 40,000 37,462 94% 2500-421-430264-243 TRAFFIC SIGNALS 0 19,000 19,000 100% 2500-421-430264-245 BARRICADE MATERIALS 0 5,000 5,000 100% 2500-421-430264-341 ELECTRICITY 120 3,000 2,880 96% 2500-421-430264-345 COMMUNICATIONS 73 750 677 90% 2500-421-430264-354 CONTRACT SERVICES 393 10,000 9,607 96% 2500-421-430264-362 EQUIPMENT MAINTENANCE 261 3,000 2,739 91% 2500-421-430264-366 BUILDING MAINTENANCE 90 2,000 1,910 96% 2500-421-430264-373 DUES & TRAINING 40 5,500 5,460 99% 2500-421-430264-428 PAINT MATERIALS 68 8,000 7,933 99% 2500-421-430264-510 LIABILITY INS.-TSS 1,604 1,604 0 0% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,500 2,500 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 0 7,934 7,934 100% 2500-421-430264-532 OFFICE RENT 0 6,422 6,422 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 20 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. TOTAL SPEC. ST. MAINT. 301,556 4, 195, 902 3.597,346 93� 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 21 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,000 1,000 100% 2880-480-470210-354 CONTRACT SERVICES 0 1,000 1,000 100% 2880-480-470210-711 REDEVELOPMENT 49,616 150,000 100,384 67% TOTAL LOAN REVOLVING 49,616 152,000 102,384 67% 2881 CD LOAN REV. #2 2881-480-470210-711 REDEVELOPMENT TOTAL 2881 CD REV. #2 2886 CD MISC. 2886-480-470210-210 OFFICE SUPPLIES 2886-480-470210-353 AUDITING 2886-480-470210-373 DUES & TRAINING 2886-480-470210-379 MEETINGS 2886-480-470210-396 GRANT SERVICES 2886-480-470210-522 ADMINISTRATIVE TRANSFER 2886-480-470210-528 DATA PROCESSING TRANSFER 2886-480-470210-532 OFFICE RENT 2886-480-470210-620 INTEREST - OLD SCHOOL LOAN - GENERA 2886-480-470210-790 COMM. DEV. ACTIVITIES 2886-480-470210-795 REDEVELOPMENT- OLD SCHOOL STATION TOTAL CD MISC. 2887 RURAL DEVELOPMENT #1 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 TOTAL RURAL DEVELOPMENT #1 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-03 2888-480-470210-750 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #2 2945 CDBG - ED (FVCC) TOTAL CDBG - ED (FVCC) 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 2955-480-470210-352 PERSONNEL -PETROLEUM 0 150,000 150,000 100% 0 150,000 150,000 100% 0 2,000 2,000 100% 0 1,000 1,000 100% 0 2,000 2,000 100% 0 1,000 1,000 100% 0 25,000 25,000 100% 0 2,000 2,000 100% 0 8,342 8,342 100% 0 1,175 1,175 100% 0 16,250 16,250 100% 1,705 100,000 98,295 98% 0 183,750 183,750 100% 1,705 342,517 340,812 100% 0 18,272 18,272 100% 0 3,803 3,803 100% 0 150,000 150,000 100% 0 172,075 172,075 100% 0 8,135 8,135 100% 0 1,890 1,890 100% 0 110,000 110,000 100% 0 120,025 120,025 100% 0 0 0 0% 0 908 908 100% 0 3,505 3,505 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 22 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. 2955-480-470210-353 FRINGES -PETROLEUM 0 493 493 100% 2955-480-470210-354 CONTRACTED SERVICES-PETROLUEM 0 1,488 1,488 100% 2955-480-470210-373 TRAVEL -PETROLEUM 290 35 255- -729% 2955-480-470210-720 CLEANUP LOANS -PETROLEUM 0 62,354 62,354 100% 2955-480-470210-721 CLEANUP SUBGRANTS-PETRO 0 100,000 100,000 100% 2955-480-470210-725 REVOLVED FUNDS -PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 0 1,158 1,158 100% 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 0 88 88 100% 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 0 3,778 3,778 100% 2955-480-470215-720 CLEANUP LOANS -HAZARDOUS 0 314,600 314,600 100% TOTAL BROWNFIELDS LOAN REV. 290 588,907 588,617 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 23 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD /2015 GRT 281 31,255 30,974 99% 2915-413-420140-218 SMALL EQUIP - 2015 STONEGARDEN 0 25,000 25,000 100% 2915-413-420140-354 CONT SERV-WPD/MHP/MFWPE-2015 GRT 0 38,815 38,815 100% TOTAL 2915 STONEGARDEN GRANT 281 95,070 94,789 100% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 8,751 60,926 52,175 86% 2916-413-420140-121 OVERTIME 2,025 7,500 5,475 73% 2916-413-420140-153 HEALTH INSURANCE 1,435 17,541 16,106 92% 2916-413-420140-155 RETIREMENT 1,201 8,167 6,966 85% 2916-413-420140-354 CONTRACT SERVICES 0 5,841 5,841 100% TOTAL 2916 DRUG ENFORCEMENT 13,411 99,975 86,564 87% 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 8,419 140,287 131,868 94% 2918-413-420140-153 HEALTH INSURANCE 680 32,606 31,926 98% 2918-413-420140-155 RETIREMENT 1,062 18,857 17,795 94% TOTAL CHRP GRANT 10,161 191,750 181,589 95% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 570 4,000 3,430 86% 2919-413-420140-125 DUI TASK FORCE 0 8,000 8,000 100% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 9,455 36,000 26,545 74% 2919-413-420140-127 SCHOOL DIST. OT 0 20,000 20,000 100% 2919-413-420140-218 SAG&MDOT GRTS-WATCHGUARD CAMERAS 0 12,000 12,000 100% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 87 2,500 2,414 97% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 0 7,000 7,000 100% TOTAL LAW ENF. GRANT 10,111 89,500 79,389 89% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 24 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CAPITAL PROJECT FUNDS 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 684 25,000 24,316 97% 684 25,000 24,316 97% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 25 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 225 0 225- 0% 5210-000-331158-000 STATE BYPASS RELOCATION REIMB. 1,876 0 1,876- 0% 5210-000-343210-000 METERED WATER SALES 722,801 2,850,000 2,127,199 75% 5210-000-343220-000 UNMETERED WATER SALES 1,003 0 1,003- 0% 5210-000-343225-000 IMPACT FEES 103,965 285,000 181,035 64% 5210-000-343230-000 METER REPLACEMENT FEE 17,257 98,000 80,743 82% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 1,620 74,000 72,380 98% 5210-000-343265-000 IMPACT ADMIN FEES 0 15,000 15,000 100% 5210-000-343270-000 WATER TURN ON FEES 750 0 750- 0% 5210-000-343275-000 TAG FEE 11,940 0 11,940- 0% 5210-000-371010-000 INVESTMENT EARNINGS 9,947 46,000 36,053 78% 5210-000-381050-000 INCEPTION OF LEASE 0 2,435,627 2,435,627 100% TOTAL WATER REVENUE 871,384 5,803,627 4,932,243 85% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 96,545 702,293 605,748 86% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 682 20,000 19,318 97% 5210-447-430550-153 HEALTH INSURANCE 12,856 168,225 155,369 92% 5210-447-430550-155 RETIREMENT 7,167 51,002 43,835 86% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 8 11,000 10,992 100% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 315 8,500 8,185 96% 5210-447-430550-226 CHLORINE & CHEMICALS 5,069 38,000 32,931 87% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 487 4,500 4,013 89% 5210-447-430550-231 GAS & OIL 1,661 38,000 36,339 96% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 0 4,000 4,000 100% 5210-447-430550-336 LICENSES & FEES 0 18,500 18,500 100% 5210-447-430550-341 ELECTRICITY 17,466 150,000 132,534 88% 5210-447-430550-344 NATURAL GAS 220 15,500 15,280 99% 5210-447-430550-345 TELEPHONE & COMMUNICATION 1,021 9,000 7,979 89% 5210-447-430550-349 LAB SERVICES 528 26,000 25,472 98% 5210-447-430550-353 AUDITING 0 5,000 5,000 100% 5210-447-430550-354 CONTRACT SERVICES 912 65,000 64,088 99% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 0 25,000 25,000 100% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 0 15,000 15,000 100% 5210-447-430550-366 BUILDING MAINTENANCE 576 12,000 11,424 95% 5210-447-430550-373 DUES & TRAINING 159 9,000 8,841 98% 5210-447-430550-388 MEDICAL SERVICES 0 800 800 100% 5210-447-430550-410 CONSTRUCTION MATERIALS 2,286 35,000 32,714 93% 5210-447-430550-422 HYDRANTS 0 8,000 8,000 100% 5210-447-430550-423 MATERIALS FOR MAINS 339 14,000 13,661 98% 5210-447-430550-424 MATERIALS -SERVICE LINES 764 14,000 13,236 95% 5210-447-430550-425 MATERIALS PUMPS/WELLS 1,115 45,000 43,885 98% 5210-447-430550-510 PROPERTY & LIABILITY INS. 15,468 15,468 0 0% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 0 23,855 23,855 100% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 0 103,473 103,473 100% 5210-447-430550-528 DATA PROCESSING TRANSFER 0 36,000 36,000 100% 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 0 9,500 9,500 100% 5210-447-430550-921 SAND/COLD MIX STORAGE SHED 0 25,771 25,771 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 26 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5210-447-430550-922 USFS PROPERTY ACQUISITION 0 32,978 32,978 100% 5210-447-430550-936 Noffsinger Spring Generator 0 90,000 90,000 100% 5210-447-430550-948 METERS (METER FUNDS) 010125 9,725 110,000 100,275 91% 5210-447-430550-951 SECURITY SCADA UPGRADES 0 15,000 15,000 100% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5210-447-430550-958 2ND AVE EAST MAIN REPLC & UPSIZE 0 45,147 45,147 100% 5210-447-430550-959 PARKS METERING PHASE I 0 30,000 30,000 100% 5210-447-430550-969 4TH AVE E MAIN REPL. PH. 1 0 2,435,627 2,435,627 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 150,000 150,000 100% 5210-447-430555-941 METERS (NEW SERVICES)010120 9,725 45,600 35,875 79% 5210-447-430555-953 SECTION 36 WELL 0 639,746 639,746 100% SUBTOTAL WATER FACILITIES 185,095 5,366,037 5,180,942 97% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 5210-447-430560-153 HEALTH INSURANCE 5210-447-430560-155 RETIREMENT 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 5210-447-430560-353 AUDITING 5210-447-430560-354 CONTRACT SERVICES 5210-447-430560-355 BILLING COSTS 5210-447-430560-373 DUES & TRAINING 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5210-447-430560-528 DATA PROCESSING TRANSFER 5210-447-430560-532 RENT SUBTOTAL WATER BILLING 14,813 108,823 94,010 86% 2,638 36,839 34,201 93% 1,137 8,225 7,088 86% 40 2,500 2,460 98% 0 2,000 2,000 100% 0 3,000 3,000 100% 6,732 70,000 63,268 90% 0 2,500 2,500 100% 0 7,950 7,950 100% 0 33,000 33,000 100% 0 6,422 6,422 100% 25,360 281,259 255,899 91% REVENUE BONDS 5210-447-490204-610 BOND PRIN-HWY 93 S WTR-2004 0 65,000 65,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 350 28,835 28,485 99% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 0 350 350 100% 5210-447-490206-610 PRIN-MTR&WELL WRF7104 1.25%;WRF8114 0 83,000 83,000 100% 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25%;WRF8114 0 22,601 22,601 100% 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2%/IDAHO&MAI 0 48,000 48,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 0 4,200 4,200 100% SUBTOTAL REVENUE BONDS 350 251,986 251,636 100% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 0 840,000 840,000 100% 0 840,000 840,000 100% 210,805 6,739,282 6,528,477 97% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 27 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 225 0 225- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 732,719 4,400,000 3,667,281 83% 5310-000-343330-000 IMPACT FEES (SANITARY) 150,756 220,000 69,244 31% 5310-000-343335-000 IMPACT FEES (WWTP) 105,847 300,000 194,153 65% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 516 15,000 14,484 97% 5310-000-371010-000 INVESTMENT EARNINGS 11,206 50,000 38,794 78% TOTAL SEWER REVENUE SANITARY SEWER EXPENSES: 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 1,001,268 4,985,000 3,983,732 80% 12,513 91,956 79,443 86% 2,102 29,868 27,766 93% 959 6,936 5,977 86% 40 2,500 2,460 98% 0 2,000 2,000 100% 6,732 70,000 63,268 90% 0 2,500 2,500 100% 0 7,055 7,055 100% 0 33,000 33,000 100% 0 6,422 6,422 100% SUBTOTAL SEWER BILLING COSTS 22,346 252,237 229,891 91% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 30,201 251,377 221,176 88% 5310-454-430630-121 OVERTIME 26 5,500 5,474 100% 5310-454-430630-153 HEALTH INSURANCE 4,651 66,327 61,676 93% 5310-454-430630-155 RETIREMENT 2,255 18,365 16,110 88% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 900 9,200 8,300 90% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 117 8,350 8,233 99% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 115 2,000 1,885 94% 5310-454-430630-231 GAS & OIL 462 13,500 13,038 97% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 400 400 100% 5310-454-430630-341 ELECTRICITY 3,338 54,500 51,162 94% 5310-454-430630-344 NATURAL GAS 1,022 16,500 15,478 94% 5310-454-430630-345 TELEPHONE & COMMUNICATION 1,331 23,000 21,669 94% 5310-454-430630-353 AUDITING 0 3,000 3,000 100% 5310-454-430630-354 CONTRACT SERVICES 2,479 24,000 21,521 90% 5310-454-430630-356 CONSULTANTS 0 8,000 8,000 100% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 694 5,000 4,306 86% 5310-454-430630-373 DUES & TRAINING 25 5,500 5,475 100% 5310-454-430630-388 MEDICAL SERVICES 0 500 500 100% 5310-454-430630-410 CONSTRUCTION MATERIALS 2,135 9,000 6,865 76% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 142 50,000 49,858 100% 5310-454-430630-510 PROPERTY & LIABILITY INS. 15,791 15,791 0 0% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 0 9,180 9,180 100% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 0 64,461 64,461 100% 5310-454-430630-528 DATA PROCESSING TRANSFER 0 19,000 19,000 100% 5310-454-430630-532 OFFICE RENT 0 6,422 6,422 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 28 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-921 SAND/COLD MIX STORAGE SHED 0 25,771 25,771 100% 5310-454-430630-922 USFS PROPERTY ACQUISITION 0 32,978 32,978 100% 5310-454-430630-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 0 20,528 20,528 100% 5310-454-430630-952 PETERSON SCHOOL ALLEY REPLACEMENT 0 284,000 284,000 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 5,071 20,000 14,929 75% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 0 50,000 50,000 100% 5310-454-430630-961 2ND ALLEY WN - MONT TO CALF 137,194 324,366 187,172 58% SUBTOTAL SEWER COLLECTION 207,947 1,502,068 1,294,121 86% IMPACT FEES 5310-454-430635-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 0 34,035 34,035 100% 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 0 100,000 100,000 100% 5310-454-430635-957 3 MILE DR INTERCEPTOR 0 867,087 867,087 100% 5310-454-430635-958 SPRING CREEK INTERCEPTOR DESIGN 5,794 0 5,794- 0% 5310-454-430635-961 2ND ALLEY WN - MONT TO CALF 70,589 167,110 96,521 58% SUBTOTAL IMPACT FEE EXPENSE 76,382 1,168,232 1,091,850 93% REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION -SANITARY SUBTOTAL SANITARY SEWER WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 5310-455-430640-111 SEASONAL SALARIES 5310-455-430640-112 SALARIES -RETIREMENT 5310-455-430640-121 OVERTIME 5310-455-430640-153 HEALTH INSURANCE 5310-455-430640-155 RETIREMENT 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 5310-455-430640-225 ALUM 5310-455-430640-226 CHLORINE & CHEMICALS 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 5310-455-430640-231 GAS & OIL 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 5310-455-430640-336 LICENSES & FEES 0 81,000 81,000 100% 0 15,346 15,346 100% 0 300 300 100% 0 96,646 96,646 100% 0 820,000 820,000 100% 0 820,000 820,000 100% 284,330 3,586,946 3,302,616 92% 58,881 448,865 389,984 87% 2,182 5,000 2,818 56% 14,457 0 14,457- 0% 3,773 22,500 18,727 83% 6,976 88,992 82,016 92% 4,642 32,463 27,821 86% 0 10,000 10,000 100% 137 2,700 2,563 95% 0 20,000 20,000 100% 2,857 19,000 16,143 85% 956 7,000 6,044 86% 727 18,500 17,773 96% 18 350 332 95% 0 10,000 10,000 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 29 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5310-455-430640-341 ELECTRICITY 13,134 178,500 165,366 93% 5310-455-430640-342 WATER 0 7,500 7,500 100% 5310-455-430640-344 NATURAL GAS 420 65,000 64,580 99% 5310-455-430640-345 TELEPHONE & COMMUNICATION 505 5,500 4,995 91% 5310-455-430640-353 AUDITING 0 4,000 4,000 100% 5310-455-430640-354 CONTRACT -GLACIER GOLD 11,283 124,000 112,717 91% 5310-455-430640-355 OTHER CONTRACT SERVICES 1,754 30,000 28,246 94% 5310-455-430640-356 CONSULTANTS 3,379 100,000 96,621 97% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 5310-455-430640-360 MISC. MAINT SERVICES 1,544 30,000 28,456 95% 5310-455-430640-366 BUILDING MAINTENANCE 51 36,000 35,949 100% 5310-455-430640-373 DUES & TRAINING 149 7,500 7,351 98% 5310-455-430640-388 MEDICAL SERVICES 0 500 500 100% 5310-455-430640-510 PROPERTY & LIABILITY INS. 34,985 34,985 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 0 13,212 13,212 100% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 0 112,237 112,237 100% 5310-455-430640-528 DATA PROCESSING TRANSFER 0 27,500 27,500 100% 5310-455-430640-921 EVERGREEN SEWER SAMPLING EQUIP & BL 0 40,000 40,000 100% SUBTOTAL WWTP OPERATIONS 162,812 1,516,804 1,353,992 89% WWTP BONDED PROJECT SUBTOTAL WWTP BONDED 0 0 0 0% WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 4,961 100,000 95,039 95% 5310-455-430645-920 R.A.S. BLD & STORAGE WAREHOUSE ROOF 0 40,000 40,000 100% 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 0 100,000 100,000 100% 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 0 531,500 531,500 100% 5310-455-430645-936 DIGESTED SLUDGET LINE REPLACEMENT 0 298,678 298,678 100% 5310-455-430645-937 SAND FILTER MAINT & REPLACMENT 0 200,000 200,000 100% 5310-455-430645-940 MACHINERY & EQUIPMENT 0 182,500 182,500 100% SUBTOTAL WWTP REPLACEMENT 4,961 1,452,678 1,447,717 100% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 11,961 106,284 94,323 89% 5310-455-430646-153 HEALTH INSURANCE 1,360 20,932 19,572 94% 5310-455-430646-155 RETIREMENT 884 7,630 6,746 88% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 0 4,500 4,500 100% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 0 2,500 2,500 100% 5310-455-430646-222 LAB SUPPLIES 1,483 9,500 8,017 84% 5310-455-430646-349 LAB SERVICES 1,612 29,000 27,388 94% 5310-455-430646-362 EQUIPMENT MAINTENANCE 981 5,500 4,519 82% 5310-455-430646-373 DUES & TRAINING 500 3,700 3,200 86% SUBTOTAL WWTP LAB OPERATIONS 18,781 189,546 170,765 90% DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 0 796,000 796,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 0 216,405 216,405 100% 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 44,000 44,000 100% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 30 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 0 28,650 28,650 100% SUBTOTAL DEBT SERVICE - WWTP 0 1,085,055 1,085,055 100% CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 0 450,000 450,000 100% 5310-455-510400-831 DEPRECIATION EXPENSE 0 1,425,000 1,425,000 100% SUTOTAL WWTP DEPRECIATION/REPL 0 1,875,000 1,875,000 100% SUBTOTAL WWTP 186,554 6,119,083 5,932,529 97% TOTAL BILLING/SANITARY/WWTP 493,230 9,958,266 9,465,036 95% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 31 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 225 0 225- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 2,500 2,500 100% 5349-000-343033-000 IMPACT FEES 36,861 150,000 113,139 75% 5349-000-343034-000 PERMIT FEES 465 0 465- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 0 850,000 850,000 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 863 1,000 137 14% 5349-000-371010-000 INTEREST ON INVESTMENTS 4,081 18,000 13,919 77% 5349-000-381050-000 INCEPTION OF LEASE 0 382,000 382,000 100% TOTAL STORM REVENUE 42,495 1,404,500 1,362,005 97% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 45,733 360,758 315,025 87% 5349-453-430246-121 OVERTIME 26 4,000 3,974 99% 5349-453-430246-153 HEALTH INSURANCE 5,846 81,030 75,184 93% 5349-453-430246-155 RETIREMENT 3,418 26,448 23,030 87% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 900 10,100 9,200 91% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 0 6,550 6,550 100% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 462 11,500 11,038 96% 5349-453-430246-345 TELEPHONE & COMMUNICATION 84 800 716 90% 5349-453-430246-353 AUDITING 0 2,340 2,340 100% 5349-453-430246-354 CONTRACT SERVICE 1,080 6,000 4,920 82% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 0 35,000 35,000 100% 5349-453-430246-357 IMPACT FEE UPDATE 0 50,000 50,000 100% 5349-453-430246-358 CONSULTANTS 0 7,000 7,000 100% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 15,000 15,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 0 2,500 2,500 100% 5349-453-430246-362 GROUNDWATER MONITORING 0 6,500 6,500 100% 5349-453-430246-371 CURB & GUTTER 0 7,000 7,000 100% 5349-453-430246-373 DUES & TRAINING 79 5,500 5,421 99% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 0 10,000 10,000 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 4,842 10,000 5,158 52% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 0 9,180 9,180 100% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 0 39,752 39,752 100% 5349-453-430246-528 DATA PROCESSING TRANSFER 0 13,000 13,000 100% 5349-453-430246-530 BNSF LEASE PMT 0 5,900 5,900 100% 5349-453-430246-532 OFFICE RENT 0 6,422 6,422 100% 5349-453-430246-840 MACI GRANT MATCH (SWEEPER) 0 43,000 43,000 100% 5349-453-430246-921 SAND/COLD MIX STORAGE SHED 0 25,771 25,771 100% 5349-453-430246-952 STORM DRAIN CORRECTION 0 100,000 100,000 100% 5349-453-430246-953 WILLOWS PRJ FY14/15; SHOP COMPLX PV 0 30,552 30,552 100% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 581,400 581,400 100% 5349-453-430246-969 4TH AVE E. REPLACE PHASE 1-4 0 382,000 382,000 100% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 130,000 130,000 100% 5349-453-510400-831 DEPRECIATION 0 285,000 285,000 100% TOTAL STORM 62,470 2,312,303 2,249,833 97% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 32 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 0 955,000 955,000 100% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 287 21,500 21,213 99% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,382 2,100 718 34% 5510-000-371010-000 INVESTMENT EARNINGS 1,110 6,000 4,890 82% TOTAL SOLID WASTE REVENUE 2,778 984,600 981,822 100% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 54,162 399,776 345,614 86% 5510-460-430840-112 SEVERANCE -RETIREMENT 0 60,455 60,455 100% 5510-460-430840-121 OVERTIME 847 5,500 4,653 85% 5510-460-430840-153 HEALTH INSURANCE 7,522 106,280 98,758 93% 5510-460-430840-155 RETIREMENT 4,052 28,993 24,941 86% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,250 9,500 8,250 87% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 0 35,000 35,000 100% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 143 5,500 5,357 97% 5510-460-430840-231 GAS & OIL 3,514 60,000 56,486 94% 5510-460-430840-341 ELECTRICITY 91 1,950 1,859 95% 5510-460-430840-344 NATURAL GAS 25 4,900 4,875 99% 5510-460-430840-345 TELEPHONE & COMMUNICATION 92 850 758 89% 5510-460-430840-354 CONTRACT SERVICES 321 9,000 8,679 96% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 492 5,700 5,208 91% 5510-460-430840-366 BUILDING MAINTENANCE 76 2,500 2,424 97% 5510-460-430840-373 DUES & TRAINING 294 3,500 3,206 92% 5510-460-430840-388 MEDICAL SERVICES 0 650 650 100% 5510-460-430840-510 PROPERTY & LIABILITY INS. 6,799 6,799 0 0% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 0 76,104 76,104 100% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 0 37,311 37,311 100% 5510-460-430840-528 DATA PROCESSING TRANSFER 0 12,513 12,513 100% 5510-460-430840-532 OFFICE RENT 0 6,422 6,422 100% 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 19,127 38,343 19,216 50% 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 898 1,801 903 50% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 0 35,000 35,000 100% 5510-460-430840-922 USFS PROPERTY ACQUISITION 0 43,971 43,971 100% 5510-460-430840-940 EQUIPMENT 0 48,000 48,000 100% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5510-460-430845-224 JANITORIAL SUPPLIES 0 250 250 100% 5510-460-430845-341 ELECTRICITY 129 3,500 3,371 96% 5510-460-430845-342 WATER 0 2,000 2,000 100% 5510-460-430845-344 NATURAL GAS 27 6,500 6,473 100% 5510-460-430845-360 REPAIR & MAINT SERVICES 0 3,500 3,500 100% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% TOTAL SOLID WASTE EXPENSE 99,863 1,246,620 1,146,757 92% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 33 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 1,650 10,000 8,350 84% 5160-000-343069-000 HANGER LEASES 2,000 11,000 9,000 82% 5160-000-343071-000 HANGAR SITE LEASES 18,001 17,510 491- -3% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 3,120 19,145 16,025 84% 5160-000-343102-000 GROUND LEASES 13,198 13,198 0- 0% 5160-000-343620-000 FUEL TAX 510 5,000 4,490 90% 5160-000-371010-000 INVESTMENT EARNINGS 232 1,000 768 77% TOTAL AIRPORT REVENUE 38,712 76,853 38,141 50% 5160 AIRPORT EXPENSES 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 0 1,000 1,000 100% 5160-430-430310-341 ELECTRICITY 123 1,500 1,377 92% 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 6,000 36,000 30,000 83% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 0 7,500 7,500 100% 5160-430-430310-362 REPAIR & MAINTENANCE 0 10,000 10,000 100% 5160-430-430310-390 EQUIPMENT RENTAL 0 1,000 1,000 100% 5160-430-430310-510 PROPERTY INSURANCE 423 6,500 6,077 93% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 0 2,562 2,562 100% 5160-430-430310-528 DATA PROCESSING TRANSFER 0 2,085 2,085 100% 5160-430-430310-820 DEPRECIATION 0 97,918 97,918 100% TOTAL AIRPORT EXPENSES 6,546 166,065 159,519 96% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 34 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 0 205,000 205,000 100% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 0 175,000 175,000 100% 6030-000-371010-000 INVESTMENT EARNINGS 127 1,000 873 87% 6030-000-393000-000 INTERNAL SERVICES -DATA 0 235,655 235,655 100% TOTAL INFORMATION TECH REVENUE 127 616,655 616,528 100% INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 22,859 167,379 144,520 86% 6030-401-410580-121 OVERTIME 72 1,000 928 93% 6030-401-410580-153 HEALTH INSURANCE 3,659 44,317 40,658 92% 6030-401-410580-155 RETIREMENT 1,789 12,653 10,864 86% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 0 500 500 100% 6030-403-410580-215 COMPUTER SUPPLIES 0 2,400 2,400 100% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 3,425 18,963 15,538 82% 6030-403-410580-325 WEBSITE 0 16,000 16,000 100% 6030-403-410580-345 PAGER/PHONE 361 2,500 2,139 86% 6030-403-410580-346 SUMMITNET & ISPS 200 8,468 8,268 98% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 3,500 68 2% 6030-403-410580-354 MAINTENANCE CONTRACTS 298 8,860 8,563 97% 6030-403-410580-355 LICENSES 235 21,110 20,875 99% 6030-403-410580-356 MAINTENANCE CONTRACTS 9,951 47,550 37,599 79% 6030-403-410580-357 GRANICUS 600 6,690 6,090 91% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 83 21,235 21,152 100% 6030-403-410580-373 DUES & TRAINING 0 8,000 8,000 100% 6030-403-410580-510 INSURANCE 819 1,778 959 54% 6030-403-410583-218 TV -Video Equipment & programming 0 12,900 12,900 100% 6030-403-410585-229 COPIER,FAX, SUPPLIES 609 19,552 18,943 97% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 6,209 76,000 69,791 92% 6030-403-410585-532 COPIER LEASES 1,234 16,182 14,948 92% 6030-403-410585-942 Servers - capital contingency 0 23,500 23,500 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 0 4,964 4,964 100% 6030-405-410588-940 NETWORK EQUIPMENT CAPITAL 0 49,200 49,200 100% 6030-410-410588-218 COMPUTERS - DPW 0 2,175 2,175 100% 6030-413-410588-218 COMPUTERS - POLICE DEPT 36 28,360 28,324 100% 6030-413-410588-354 POLICE - HOSTED SERVER 0 2,000 2,000 100% 6030-416-410588-218 COMPUTERS - FIRE 0 16,752 16,752 100% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 2,100 11,053 8,953 81% 6030-436-410588-218 COMPUTERS - PARKS 0 5,165 5,165 100% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 2,155 2,155 100% TOTAL INFORMATION TECH EXPENSE 57,971 667,861 609,890 91% 09.14.2016 15:38 THE CITY OF KALISPELL, MONTANA Page 35 of 35 gb8501_pg.php/Job No: 39826 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU AUGUST 31, 2016 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 0 510,000 510,000 100% 6010-000-371010-000 INVESTMENT EARNINGS 32 200 168 84% TOTAL CENTRAL GARAGE REVENUE 32 510,200 510,168 100% CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 23,447 160,046 136,599 85% 6010-410-431330-121 OVERTIME 220 2,500 2,280 91% 6010-410-431330-153 HEALTH INSURANCE 3,187 38,827 35,640 92% 6010-410-431330-155 RETIREMENT 1,604 11,505 9,902 86% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 15 10,000 9,985 100% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 244 12,700 12,456 98% 6010-410-431330-230 OIL 675 25,000 24,325 97% 6010-410-431330-231 GAS 0 3,000 3,000 100% 6010-410-431330-232 VEHICLE PARTS 11,830 108,000 96,170 89% 6010-410-431330-233 TIRES 7,430 38,000 30,570 80% 6010-410-431330-238 FILTERS 1,232 7,700 6,468 84% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 468 2,000 1,533 77% 6010-410-431330-341 ELECTRICITY 117 1,950 1,833 94% 6010-410-431330-344 NATURAL GAS 51 7,000 6,949 99% 6010-410-431330-354 CONTRACT SERVICES 3,467 30,000 26,533 88% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 21 2,000 1,979 99% 6010-410-431330-373 DUES & TRAINING 0 6,200 6,200 100% 6010-410-431330-388 MEDICAL SERVICES 0 300 300 100% 6010-410-431330-510 INSURANCE 1,286 2,750 1,464 53% 6010-410-431330-528 INFORMATION TECH TRANSFER 0 8,342 8,342 100% 6010-410-431330-921 4 POST SERVICE LIFT 0 26,000 26,000 100% TOTAL CENTRAL GARAGE EXPENSES 55,294 503,820 448,526 89%