Loading...
06-12-15 City Manager ReportCITYOF� � � .. a�� . City of Kalispell KVOFFICE OF THE CITY MANAGER MONTANA Information Memorandum 6/12/2015 1. Finance Department Please find attached the budget to actual printouts reflecting the financial activity for the period July 1, 2014 thru May 31, 2015. This printout reflects 24 of the 26 payrolls for fiscal year 2015. All funds are included with the exception of the debt service funds. IholWA001a10 General Fund revenue reflects taxes collected thru May 31. This brings the City's actual general fund real property taxes for the period to $3,326,079, or 66% of the budgeted annual amount. This is normal as the General Fund, like other tax supported funds, receives the majority of its tax revenue in December and June. Last June's tax collections were over $2,000,000. A similar collection amount this June would put general fund property tax collections well over 100% for this fiscal year. Ambulance fees for services are recorded quarterly and exceed the same period last fiscal year by about 11 % ($45,000). Metered water sales thru May were $2,671,435. This is 95% of the budgeted annual amount. Last year's metered Water sales for the same period Were $2,664,723. Sewer service charges thru May were $3,971,950, or 95% of the budgeted annual amount. Last year's sewer service charges for the same period Were $3,814,492. This increase is due to the increased base fee implemented on July 1, 2014. EXPENDITURES, General Fund expenditures reflect 88% spent. Expenditures include the payroll period ending May 30th. Most departments have at least 8% remaining in the salaries (110) line which should be adequate. Health insurance is paid monthly, so 8% remaining should be adequate there, also. Due to the payment to Flathead County for old School Station property taxes, the Community Development Miscellaneous fund exceeded the original budget amount of $2611933 by $1,011,890 and will require an amendment for fiscal year 2015. Similarly, the two old School TIF funds exceeded their original budgets by $250,765 (Technology) and $57,360 (Industrial) due to operating transfers to the Community Development Miscellaneous fund necessary to complete the old School Station property purchase. The budget print out provided reflects these transactions as well as the amended budget amounts. 2. City Clerk/Communications Manager The City Clerk facilitated three ethics trainings for employees on Thursday as part of the cities ongoing training provided by Human Resources. Participants worked through several case studies as a group and generated thoughtful discussion. The social media campaign is underway with 85 page likes on Facebook and between two and three thousand people `reached' each week. So far, the Warrant Wednesday posts are the most popular with 83 post shares and 3,300 people reached this last week. While Twitter followers are much fewer with 14 followers, many are media contacts who are picking up on stories. The third employee newsletter was released June 5. 3. Parks Department Summer Day Camp will start June 15 and run Monday thru Friday from 7 :3 oam - 5 :3 opm for the next 10 weeks. We are holding camp orientation for staff on Thursday, June 11. Day Camp's first fieldtrip will be to Lone Pine State Park for a tour and lunch, then to the roller skating rink for some fun! Picnic in the Park will start the season on Tuesday, June 30. Randy McAllister will be playing a mixture of country, tex-mex, rock and zydeco music from 7:00pm — 9:00pm. On Wednesday, July 1, Montana Midnight Guitar Trio will be playing classical, contemporary, j azz, rock and pop music from 11:3 oam — 1:3 opm. KPR's Recreational Soccer program, for ages 16 and over has registered six teams with games starting June 15. This is a brand new program developed at the request of local players, with games held at the Kalispell Middle School Practice Field. The Kalispell Youth Athletic Complex is in full swing, hosting tournaments the last two weekends. The last weekend in May, the KYAC and Kalispell Middle School both hosted Three Blind Ref s soccer games With over 150 teams in attendance and over 300 games played. This past weekend, the KYAC hosted tournaments for baseball, soccer, and softball. Flathead Audubon in partnership with KPR hosted a bird watching outing in Lawrence Park on June 7, from 8 — 10 am. Approximately twenty five people participated. Birders enthusiastically identified thirty three species of birds. Woodland Water Park will open for the season on June 13 with the first session of swim lessons starting on June 22. Woodland Water Park has passed the boiler inspections and 2 fire sprinkler inspections for the year. Currently, one of the three recirculating pumps that runs the lazy river is inoperable. Staff is having it rebuilt in hopes of getting the pool 100% open by opening day. On May 29, 2015, Parks and Recreation had a group of middle school students from Bigfork lend a hand helping to improve the aesthetics of the island between the pool and the skate park. Students pulled weeds and filled in the area with new mulch. The formal garden at Woodland Park is almost completely planted. It is estimated that 5,040 flowers are planted in the garden each season. The 53 planters located downtown were planted as well. 4. Fire Department Since the last update, the Kalispell Fire Department has received 127 calls for service and has conducted 4 outreach trainings with 45 individuals in attendance. Recently, staff from the fire department attended a program in Colorado providing the first responder with basic knowledge, skills, and abilities to respond to incidents involving Crude by Rail (CBR). The program was delivered over 3 days (24 hours) with over 60% of the program in field exercises, including a demonstration of Crude oil fires, boil overs, and foam applications as applied to Crude oil incidents by rail and a full-scale derailment exercise. This was sponsored as a no -cost training by BNSF railway. 5. Building Department Building permits for 3 single family homes were approved in the past 2 weeks bringing the year's total to 20 single family homes and 2 townhomes compared to 39 single-family and 8 townhome residences issued for the same period in 2014. On the commercial side, a building permit has been issued for a $1 million remodel of the old Sizzler building at Hutton Ranch Plaza which will be Buffalo Wild Wings, and for a $2.7 million remodel of the MRIIC T Department of the Kalispell Regional Hospital. Several other commercial projects are currently under review. 6. Planning Department The planning board met on June 9 and heard 3 applications. The board recommended approval of a one lot subdivision on the northwest corner of the Gateway West Property. This vacant 2 acre site is zoned B-2 general commercial and abuts Financial Drive. The board also recommended approval of a request from Kalispell Regional Medical Center for a Growth Policy Amendment and zone change from RA-1 Multi -Family to H-1 Health Care for a 9.5 acre tract of land located at 100 Grandview Drive. The site is a former gravel pit that abuts hospital property. KRMC has acquired the site and has short term plans to extend parking into a small portion of this area. Both projects will be 3 presented to council at the July 6 meeting. The planning board also held a second work session on casinos. The board asked for additional information about casino regulations within the state and the potential for future casino development in the city. This will be presented at the July planning board work session. 7. Police Department T .Pardo, nn T .inP In February of this year, the Kalispell City Council adopted a new Pawn Shop/ Second Hand Store ordinance. The ordinance requires Pawn Shop/ Second Hand stores to upload items to a web based program called Leads on Line which allows officers to quickly and efficiently search for stolen items. The Kalispell Police Department started enforcing the ordinance in April. The first two months of uploading to Leads on Line has proven to be beneficial. We have recovered six stolen items worth over four thousand dollars. With the recovery of these items we have been able to develop suspects in multiple burglary and theft cases. Since April, the Kalispell Police Department has conducted 437 Leads on Line inquiries searching for stolen items. In one case, a victim came to the Kalispell Police Department to report the theft. While the victim was at the station, an officer searched Leads on Line and located the stolen items before the victim left the station. In another case, KPD responded to a local retail business for a theft report. Prior to the officer arriving on scene, the stolen item worth $1100.00 had already been located using Leads on Line. The stolen item was recovered and warrants were issued for three individuals, one for the theft, and two for possession of stolen property. Additionally, the adoption of the new Pawn Shop ordinance has assisted multiple other law enforcement agencies in locating stolen items from as far away as Minnesota, and as close as Flathead County. The Kalispell Police Department appreciates the impacted Pawn Shops and Second Hand Dealers for their cooperation with this very important program. ()> > tree rah On May 30, 2015, the Kalispell Police Department participated in the Peterson School Run off and Kid's Fun Day. officer Peterson and Sergeant overman attended the event with KPD's new patrol pick up and one of the new police motor units. Kids of all ages were allowed to interact and ask questions of the officers. The Kids were given demonstrations on the operational functions of the light bars and sirens as well as complexities of the modern police patrol vehicle. Also in attendance at the event were two of Kalispell Police Departments support staff, Brook Bassett and Jerie Betschart, with an informational table and fingerprinting. They handed out numerous child safety flyers and fingerprinted approximately 30 children for inclusion in a child safety packet. n The event was well attended and provided an opportunity to interact with a wide spectrum of community members. Bike Safety On June 22, officer Bain Will be presenting a Bike Safety talk at the KRMC Kids' Care Center. He will discuss safety tips on wearing a helmet, adjusting your bike to proper height, crossing streets, using hand signals, following traffic signs/signals, etc. He will also talk about his duties as a Bike Patrol officer. KPD will conduct two more of these safety talks at Trinity School in July. 8. Public Works Water Production Communications The water communication system has been exhibiting multiple communication issues. The Water Production operators diagnosed radio failures between the wells and the central control unit. New radios and software updates were installed at several wells resolving these failures. 2nd Ave WN Water Main Replacement from Montana Street to Washington St This project replaces 750 ft. of deteriorating and aged water infrastructure in 2nd Ave WN from Montana to Washington. The contractors are scheduled to start construction this week and substantially complete the two blocks of water main, service lines, and hydrant replacements by June 30, 2015. 2nd Alley E Sewer Main Replacement from 5 St E to 7 St E This project replaces 700 feet of 193 o's era S" clay sewer With S" PVC gravity sewer main and improves services to approximately 30 residences. The sewer main and services are installed and surface restoration is scheduled to be complete by the third week of June. 9. Community Development The City of Kalispell submitted its request for $10 million in funding to the US Department of Transportation (USDOT) TIGER 2015 grant program last week. This community and its partners have pledged $ ll million in matching funds to construct the Glacier Rail Park/Kalispell Core Area Development and Trail project. This application will be one of hundreds considered by the USDOT. Funding announcements are expected this fall. k 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Pagel of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 3,326,079 5,036,907 1,710,828 340 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 24,090 23,500 590- -30 1000-000-311200-000 PERSONAL PROPERTY TAXES 111,357 88,093 23,264- -260 1000-000-312000-000 PEN INTEREST DEL. TAXES 15,568 10,5oo 5,068- -480 1000-000-322101-000 BEER LIQUOR LICENSES 15,363 30,coo 14,638 490 1000-000-322300-000 BUSINESS LICENSES 1,465 1,300 165- -130 1000-000-323012-000 PLANNING FEES 36,958 20,000 16,958- -850 1000-000-323109-000 SITE REVIEW 9,050 12,000 2,950 250 1000-000-323200-000 PARADE PERMITS 1,500 Soo 1,000- -2000 1000-000-323300-000 ANIMAL LICENSES 1,782 1,5oo 282- -190 M.V. TAX - AD VALOREM 1,153 750 403- -540 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 57,350 60,000 2,650 40 LIVE CARD TABLE PERMIT 2,650 3,coo 350 120 1000-000-335230-000 HE124 ENTITLEMENT 1,993,998 2,630,289 636,291 240 1000-000-341020-000 ADMINISTRATIVE CHARGES 485,278 538,5O5 53,227 100 1000-000-341021-000 GRANT ADMIN FEES 4,586 10,coo 5,414 540 1000-000-341025-000 CITY COLLECTIONS 6,391 7,500 1,109 150 1000-000-342010-000 POLICE SERVICES 22,577 30,coo 7,423 250 1000-000-342014-000 RESOURCE OFFICERS 95,500 95,5oo 0 00-. 1000-000-342016-000 KPD REGIONAL TRAINING 12,915 10,coo 2,915- -290 1000-000-343018-000 PARKING PERMITS METERS, BOOT REMOVE 88,286 104,000 15,714 150 CITY COURT FINES & FEES 399,554 535,coo 135,446 250 1000-000-351016-000 DUI COURT FINE 280 0 280- 00-. 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 24,280 30,coo 5,720 190 PARKING FINES 31,403 40,000 8,597 210 1000-000-362010-000 CITY GOLF COURSE LEASE 0 16,500 16,500 1000 1000-000-362015-000 INSURANCE REIMBURSEMENTS 24,714 10,coo 14,714- -1470 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 14,444 11,000 3,444- -310 1000-000-365015-000 CONTRIBUTION FRM KIDSPORT 0 4,100 4,100 1000 1000-000-365018-000 BANDSHELL CONTRIBUTIONS 250 Soo 250 500 1000-000-371010-000 INVESTMENT EARNINGS 11,049 10,coo 1,049- -100 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 432,500 665,000 232,500 350 TOTAL GENERAL FUND REVENUE 7,252,369 10,035,944 2,783,575 280 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 2 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 1,400 1,400 0 00-. 1000-400-410530-353 CONTRACT SERVICES - AUDIT 10,750 14,250 3,500 250 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,972 4,000 1,028 260 1000-400-410560-312 POSTAGE 13,640 20,000 6,360 320 1000-400-410560-320 PRINTING & ENVELOPES 4,731 4,500 231- -5. 1000-400-410600-354 ELECTIONS 0 6,000 6,000 1000 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,660 2,500 160- -60 1000-400-420000-354 CONTRACT 911 CENTER 349,649 466,200 116,551 250 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 352 350 2- -10 1000-400-460446-354 KIDSPORT LEASE 0 4,100 4,100 1000 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 is, coo 0 00-. 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 00-. 1000-400-510300-000 CONTINGENCY 2,197 30,coo 27,803 930 1000-400-510310-354 ICMA PLAN FEES Soo Soo 0 00-. 1000-400-510330-513 LIABILITY INSURANCE 110,035 107,525 2,510- -20 1000-400-510330-516 UNINSURED LOSS-PROPERTY/LIABILITY 52,637 30,coo 22,637- -750 1000-400-510330-517 PROPERTY INSURANCE 46,218 46,500 282 10 SUBTOTAL GEN.GOV'T. ------------ 619,340 ------------- 759,425 ------------ 140,085 ------------ 180 CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 1000-401-410210-121 OTHER - MOVING REIMBURSEMENT 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 117,006 130,592 13,586 10% 5,755 5, 755 0 0 o 13,986 19,701 5,715 29 0 12,389 13,733 1,344 10% 44 300 256 85 0 0 Soo Soo 100 o 782 880 98 110 5,383 7, 500 2,117 28 0 1,428 3,300 1,872 570 ------------------------- 156,773 ------------ 182,261 ------------ 25,488 140 106,949 118,076 11,127 90 15,599 17,028 1,429 80 8,053 8,820 767 90 666 600 66- -110 5,653 7,200 1,547 210 540 1,coo 460 460 2,449 3,500 1,051 30% ------------------------- 139,909 ------------ 156,224 ------------ 16,315 10% 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 3 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 56,740 63,054 6,314 100 1000-402-410100-153 HEALTH INSURANCE 38,675 35,700 2,975- -80 1000-402-410100-155 RETIREMENT 2,158 1,928 230- -120 1000-402-410100-210 OFFICE SUPPLIES 33 100 67 670 1000-402-410100-335 MT LEAGUE OF CITIES 2,810 5,coo 2,190 440 1000-402-410100-354 CONTRACT SERVICES 1,681 2,260 579 260 1000-402-410100-373 DUES & TRAINING 12,355 6,000 6,355- -1060 1000-402-410100-379 MEETINGS 281 8,100 7,819 970 SUBTOTAL MAYOR/COUNCIL ------------------------- 114,733 ------------ 122,142 ------------ 7,409 60 CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 78,259 98,340 20,081 200 1000-402-410150-112 SEVERANCE 9,528 8,5oo 1,028- -120 1000-402-410150-121 OVERTIME 109 Soo 391 780 1000-402-410150-153 HEALTH INSURANCE 13,610 17,374 3,764 220 1000-402-410150-155 RETIREMENT 6,258 7,423 1,165 160 1000-402-410150-210 OFFICE SUPPLIES 33 100 67 670 1000-402-410150-345 TELEPHONE & COMMUNICATION 399 300 99- -330 1000-402-410150-352 CODIFICATION 3,542 3,700 158 40 1000-402-410150-354 CONTRACT SERVICES 0 25 25 1000 1000-402-410150-373 DUES & TRAINING 1,772 2,500 728 290 SUBTOTAL CITY CLERK ------------------------- 113,511 ------------ 138,762 ------------ 25,251 180 FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 179,628 201,362 21,734 110 1000-403-410550-153 HEALTH INSURANCE 30,444 33,630 3,186 90 1000-403-410550-155 RETIREMENT 13,504 15,058 1,554 100 1000-403-410550-213 SMALL OFFICE EQUIP 305 0 305- 00-. 1000-403-410550-322 BOOKS 0 Soo Soo 1000 1000-403-410550-353 CONTRACT SERVICES 0 5,coo 5,000 1000 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 605 1,5oo 895 600 1000-403-410550-355 BANK CHARGES & FEES 2,595 3,5oo 905 260 1000-403-410550-373 DUES & TRAINING 3,103 6,000 2,897 480 SUBTOTAL FINANCE ------------------------- 230,184 ------------ 266,550 ------------ 36,366 140 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 4 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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&439;S 315,548 341,132 25,584 80 1000-404-411110-153 HEALTH INSURANCE 43,874 52,110 8,236 160 1000-404-411110-155 RETIREMENT 23,747 25,600 1,853 70 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 2,046 2,500 454 180 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 8,361 8,coo 361- -5. 1000-404-411110-345 TELEPHONE & COMMUNICATION 679 1,coo 321 320 1000-404-411110-354 CONTRACT SERVICES 6,353 1,5oo 4,853- -3240 1000-404-411110-373 DUES & TRAINING 5,331 4,700 631- -130 SUBTOTAL CITY ATTORNEY ------------------------- 405,938 ------------ 436,542 ------------ 30,604 70 MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 198,915 221,257 22,342 100 1000-406-410360-121 OVERTIME 350 0 350- 00-. 1000-406-410360-153 HEALTH INSURANCE 36,371 39,696 3,325 80 1000-406-410360-155 RETIREMENT 14,983 16,430 1,447 90 1000-406-410360-210 SUPPLIES 2,620 4,500 1,880 420 1000-406-410360-320 PRINTING/BOOKS 572 1,5oo 928 620 1000-406-410360-345 TELEPHONE & COMMUNICATION 141 1,400 1,259 900 1000-406-410360-353 SECURITY & TECHNOLOGY 1,768 40,000 38,232 960 1000-406-410360-354 CONTRACT SERVICES 2,595 5,750 3,155 550 1000-406-410360-373 DUES & TRAINING 4,507 6,300 1,793 280 1000-406-410360-394 JURY & WITNESS FEES 1,941 5,750 3,809 660 SUBTOTAL COURT ------------------------- 264,761 ------------ 342,583 ------------ 77,822 230 PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 14,920 17,604 2,684 150 1000-410-430100-153 HEALTH INSURANCE 2,332 3,263 931 290 1000-410-430100-155 RETIREMENT 1,106 1,292 186 140 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 3,149 6,500 3,351 520 1000-410-430100-231 GAS 1,153 2,500 1,347 540 1000-410-430100-345 TELEPHONE & COMMUNICATION 241 285 44 150 1000-410-430100-354 CONTRACT SERVICES 289 850 561 660 1000-410-430100-373 DUES & TRAINING 1,323 1,300 23- -20 1000-410-430100-521 CENTRAL GARAGE TRANSFER 5,434 5,928 494 80 SUBTOTAL PUBLIC WORKS ADMIN ------------------------- 29,948 ------------ 39,522 ------------ 9,574 240 CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 56,962 64,735 7,773 120 1000-412-411230-121 OVERTIME 15 0 15- 00-. 1000-412-411230-153 HEALTH INSURANCE 13,166 15,084 1,918 130 1000-412-411230-155 RETIREMENT 4,130 4,645 515 110 1000-412-411230-220 SECURITY CAMERA -CITY HALL 0 800 800 1000 1000-412-411230-224 JANITORIAL SUPPLIES 3,137 5,5oo 2,363 430 1000-412-411230-241 TOOLS & SUPPLIES 489 1,5oo 1,011 670 1000-412-411230-341 ELECTRICITY 38,065 45,000 6,935 150 1000-412-411230-344 NATURAL GAS 24,738 35,coo 10,263 290 1000-412-411230-345 TELEPHONE & COMMUNICATION 170 250 80 320 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 6 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-354 CONTRACT SERVICES 8,074 8,5oo 426 50 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 14,343 17,300 2,957 170 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 3,269 4,500 1,231 270 1000-412-411230-362 EQUIPMENT MAINTENANCE 3,775 5,coo 1,225 250 1000-412-411230-366 BUILDING MAINTENANCE 36,766 38,coo 1,234 30 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 2,943 3,900 957 250 1000-412-411230-610 BOI 2004 DEBT (HVAC SYS) 8,175 8,175 0 00-. 1000-412-411230-620 BOI 2004 INT. (HVAC SYS) 41 102 61 600 SUBTOTAL CITY HALL ------ - - - - --- 218,257 ------ - - - - --- 257,991 ----- - - - - -------- - - - - - - 39,734 150 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 230,588 263,106 32,518 120 1000-420-411020-153 HEALTH INSURANCE 44,958 54,792 9,834 180 1000-420-411020-155 RETIREMENT 17,368 19,654 2,286 120 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 3,337 7,000 3,663 520 1000-420-411020-231 GAS 203 400 197 490 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,054 2,700 1,646 610 1000-420-411020-345 TELEPHONE 745 900 155 170 1000-420-411020-354 CONTRACT SERVICES 0 1,coo 1,000 1000 1000-420-411020-373 DUES & TRAINING 2,582 4,400 1,818 410 1000-420-411020-521 CENTRAL GARAGE TRANSFER 1,198 1,294 96 70 SUBTOTAL PLANNING DEPT. ------------------------- 302,033 ------------ 355,246 ------------ 53,213 150 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 37,346 44,693 7,347 160 1000-480-470210-153 HEALTH INSURANCE 4,760 7,636 2,876 380 1000-480-470210-155 RETIREMENT 2,813 3,414 601 180 1000-480-470210-210 OFFICE SUPPLIES 1,356 2,000 644 320 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 293 2,000 1,707 850 1000-480-470210-312 POSTAGE &: PRINTING 51 2,200 2,149 980 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP Soo Soo 0 00-. 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 457 750 293 390 1000-480-470210-354 CONTRACT SERVICES 1,340 2,000 660 330 1000-480-470210-373 DUES & TRAINING 1,509 3,coo 1,491 500 1000-480-470210-379 MEETINGS 448 Soo 52 100 SUBTOTAL COMMUNITY DEVELOPMENT ------------------------- 50,873 ------------ 68,693 ------------ 17,820 260 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 6 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 1,809,639 1,968,945 159,306 80 1000-413-420140-112 SALARIES -SEVERANCE 9,528 10,coo 472 50 1000-413-420140-114 SALARY -comptime buyout 11,743 5,coo 6,743- -1350 1000-413-420140-121 OVERTIME (REG & AET OT) 71,634 75,000 3,366 40 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 3,823 25,000 21,177 850 1000-413-420140-153 HEALTH INSURANCE 320,300 362,940 42,640 120 1000-413-420140-155 RETIREMENT 232,510 256,952 24,442 100 1000-413-420140-210 OFFICE SUPPLIES 2,346 3,5oo 1,154 330 1000-413-420140-215 COMPUTER SUPPLIES 4,571 5,5oo 929 170 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 16,730 20,500 3,770 180 1000-413-420140-220 INVESTIGATIVE SUPPLIES 3,517 4,000 483 120 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 4,680 7,000 2,320 330 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,197 2,000 803 400 1000-413-420140-226 SRT SUPPORT/SUPPLIES 3,911 4,000 89 20 1000-413-420140-227 AMMO & RELATED SUPPLIES 17,373 19,coo 1,627 90 1000-413-420140-228 PATROL CAR SUPPLIES 13,050 13,000 5O- -00-. 1000-413-420140-229 OTHER SUPPLIES 3,360 3,5oo 140 40 1000-413-420140-230 CRIME PREVENTION SUPPLIES 275 1,coo 725 730 1000-413-420140-231 GAS 61,200 95,coo 33,800 360 1000-413-420140-234 CRISIS NEGOTIATIONS 0 1,5oo 1,500 1000 1000-413-420140-235 BIKE PATROL 232 1,coo 768 770 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 175 1,5oo 1,325 880 1000-413-420140-320 PRINTING 5,498 5,coo 498- -100 1000-413-420140-345 TELEPHONE & COMMUNICATION 12,114 is, Soo 3,386 220 1000-413-420140-354 CONTRACT SERVICES 3,790 6,000 2,210 370 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 4,151 9,coo 4,850 540 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 323 3,coo 2,677 890 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,061 2,000 61- -30 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 10,388 12,000 1,612 130 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 954 2,500 1,546 620 1000-413-420140-373 DUES & TRAINING 26,370 30,coo 3,630 120 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 8,901 5,coo 3,901- -780 1000-413-420140-380 TRAINING MATERIALS 1,085 2,000 915 460 1000-413-420140-388 MEDICAL SERVICES 1,321 2,500 1,179 470 1000-413-420140-392 BOARDING/TREATING PRISONERS 2,220 2,500 281 110 1000-413-420140-521 CENTRAL GARAGE TRANSFER 83,043 90,592 7,549 80 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 44,726 45,000 274 10 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 2,625 3,5oo 875 250 1000-413-420140-944 VEHICLES 120,269 118,202 2,067- -20 SUBTOTAL POLICE DEPT. 2,921,629 3,240,131 318,502 100 DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 278,600 341,633 63,033 180 1000-413-420141-121 DETECTIVE -OVERTIME 10,579 is, coo 4,421 290 1000-413-420141-153 HEALTH INSURANCE 41,783 61,572 19,789 320 1000-413-420141-155 DETECTIVE -RETIREMENT 36,505 45,892 9,387 200 TOTAL DETECTIVES ------------ 367,467 ------------- 464,097 ------------------------ 96,630 210 RECORDS 1000-413-420142-110 SALARIES -RECORDS DIVISION 104,106 104,751 645 10 1000-413-420142-121 OVERTIME 3,340 7,500 4,160 550 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 7 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-153 HEALTH INSURANCE 19,635 22,420 2,785 120 1000-413-420142-155 RETIREMENT 7,978 7,189 789- -110 TOTAL RECORDS ------------ 135,059 ------------- 141,860 ------------ 6,801 ------------ 50 RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 107,201 121,605 14,404 120 1000-413-420144-153 HEALTH INSURANCE 21,039 18,292 2,747- -150 1000-413-420144-155 SRO RETIREMENT 13,299 16,337 3,038 190 TOTAL RESOURCE OFFICERS ------------ 141,538 ------------- 156,234 ------------------------ 14,696 90 ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 37,925 46,555 8,630 190 1000-413-420145-121 OVERTIME 12 Soo 488 980 1000-413-420145-153 HEALTH INSURANCE 7,390 15,264 7,874 520 1000-413-420145-155 RETIREMENT 2,689 3,472 783 230 SUBTOTAL ANIMAL CONTROL ------------ 48,017 ------------- 65,791 ------------------------ 17,774 270 PARKING 1000-413-420147-110 PARKINGS -SALARIES 76,528 82,351 5,823 70 1000-413-420147-153 HEALTH INSURANCE 24,386 26,616 2,230 80 1000-413-420147-155 RETIREMENT 5,612 6,139 527 90 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,728 4,000 2,272 570 1000-413-420147-354 CONTRACTED SERVICES 1,820 2,000 180 90 1000-413-420147-362 LOT MAINT 1,646 10,coo 8,354 840 1000-413-420147-365 SNOW REMOVAL -Parking Lots 18,021 17,500 521- -30 1000-413-420147-550 LOT LEASE PAYMENTS 1,751 1,5oo 251- -170 SUBTOTAL PARKING ------------ 131,491 ------------- 150,106 ------------------------ 18,615 120 SUBTOTAL POLICE DEPT. ------------ 3,745,201 ------------- 4,218,219 ------------------------ 473,018 110 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 8 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 1,390,431 1,509,530 119,099 80 1000-416-420400-114 COMPTIME BUYOUT 5,304 5,coo 304- -60 1000-416-420400-115 OUT OF RANK PAY 9,133 11,978 2,845 240 1000-416-420400-121 OVERTIME 68,046 40,000 28,046- -700 1000-416-420400-153 HEALTH INSURANCE 249,586 268,422 18,836 70 1000-416-420400-155 RETIREMENT 186,212 202,694 16,482 80 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 809 2,700 1,891 700 1000-416-420400-218 Equipment (Non Capital) 14,703 21,500 6,797 320 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 11,401 is, coo 3,599 240 1000-416-420400-224 JANITORIAL SUPPLIES 2,886 2,500 386- -150 1000-416-420400-231 GAS 9,945 17,325 7,380 430 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 9,709 is, coo 5,291 350 1000-416-420400-320 PRINTING 75 700 625 890 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 654 1,250 596 480 1000-416-420400-345 TELEPHONE & COMMUNICATION 4,564 8,5oo 3,936 460 1000-416-420400-354 CONTRACT SERVICES 4,261 7,500 3,239 430 1000-416-420400-362 EQUIPMENT MAINTENANCE 4,607 5,5oo 893 160 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 2,084 5,coo 2,916 580 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 4,429 6,000 1,571 260 1000-416-420400-373 DUES & TRAINING 9,211 10,coo 789 80 1000-416-420400-388 FIREFIGHTER PHYSICALS 18,067 22,500 4,434 200 1000-416-420400-521 CENTRAL GARAGE TRANSFER 29,020 31,658 2,638 80 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 62,600 62,600 0- 00-. 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 5,240 5,402 162 30 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 232,500 310,coo 77,500 250 1000-416-420400-940 CAPITAL EQUIPMENT - VEHICLES 32,504 32,000 504- -20 1000-416-420440-110 SALARIES -FIRE PREVENTION 42,238 44,993 2,755 60 1000-416-420440-114 COMPTIME BUYOUT 314 0 314- 00-. 1000-416-420440-121 OVERTIME 3,786 0 3,786- 00-. 1000-416-420440-153 HEALTH INSURANCE 6,782 6,811 29 00-. 1000-416-420440-155 RETIREMENT 3,311 3,243 68- -20 SUBTOTAL FIRE DEPT. 2,424,411 2,675,306 250,895 90 GRAND TOTAL GENERAL FUND 8,815,870 10,019,466 1,203,596 120 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 9 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete GAL ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 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 2185-480-470240-345 TELEPHONE & COMMUNICATION 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-356 CONTRACT SERVICES/BOND ISSUE COSTS 2188-480-470230-522 ADMINISTRATIVE TRANSFER 2188-480-470230-710 LOAN REVOLVING FUNDS 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 2188-480-470230-840 TRANSFER TO DEBT SERVICE TOTAL WESTSIDE TIF OLD SCHOOL TIFS 2310-480-470210-354 CONTRACT SERVICES - BOND COUNSEL 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 2310-480-470210-356 FED -EX REIMBURSEMENT 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT Itell V-11we] Mb�Y4M.(0 ]M**OR 2927 ARTS GRANTS 2927-400-460454-354 GLACIER ORCHESTRA 2927-400-460456-354 NW MT HISTORICAL SOCIETY TOTAL ARTS GRANTS PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND TOTAL PERMISSIVE HEALTH LEVY 1,600 1,600 0 o 7,926 8,646 720 80 78,810 750,000 671,190 890 14,508 19,719 5,211 26 0 2,142 4,579 2,437 530 1,092 1,474 382 26 0 40 48 8 170 ------------ 106,118 ------------- 786,066 ------------------------ 679,948 870 31,280 38,544 7,264 190 4,106 6,871 2,766 400 2,356 2,869 513 180 2,000 2,000 0 00-. 173 0 173 - o 2,860 3, 120 260 8 0 0 1,Soo, coo 1,500,000 1000 122,506 1,coo, coo 877,494 880 24,000 32,000 8,000 250 ------------ 189,281 ------------- 2,585,404 ------------------------ 2,396,123 930 0 1,coo 1,000 1000-. 11,589 12,500 911 70 16,886 10,5oo 6,386- -610 276,289 280,765 4,476 20 59,360 59,360 0 o ------------ 364, 125 ------------- 364, 125 ------------------------ 0 o 0 10,634 10,634 1000 0 12,263 12,263 1000 ------------ 0 ------------- 22,897 ------------------------ 22,897 1000 485,000 735,000 250,000 340 ------------ 485,000 ------------- 735,000 ------------------------ 250,000 340 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 10 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2399-400-420100-522 2399-413-420140-354 2399-413-420140-940 2399-416-420400-354 2399-416-420400-610 2399-416-420400-620 2399-416-420400-940 2399 PUBLIC SAFETY IMPACT FEES ADMIN CHARGE - IMPACT FEES 50 IMPACT FEE REVIEW POLICE EQUIPMENT IMPACT FEE REVIEW PRINCIPAL - FIRE TRUCK INTEREST - FIRE TRUCK FIRE DEPT. EQUIPMENT TOTAL PUBLIC SAFETY IMPACT FEE 4,500 4,500 0 00-. 0 Soo Soo 100 o 0 so, coo 50,000 1000 0 Soo Soo 100 o 30,250 30,250 0 00-. 4,830 4,789 41- -10 0 400,000 400,000 1000 ------------------------- 39,580 490,539 ------------------------ 450,959 920 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 11 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 504,712 860,000 355,288 410 2215-000-311200-000 PERSONAL PROPERTY TAXES 34,663 25,000 9,663- -390 2215-000-312000-000 PEN & INTEREST DEL TAXES 2,744 2,000 744- -370 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 8,000 10,coo 2,000 200 2215-000-346030-000 SWIMMING POOL FEES 100,308 140,000 39,692 280 2215-000-346040-000 CONCESSION STAND REVENUE 27,545 34,000 6,455 190 2215-000-346050-000 PARKS USAGE FEES 21,855 18,5oo 3,355- -180 2215-000-346051-000 RECREATION FEES 6,977 10,coo 3,023 300 2215-000-346052-000 SPORTS PROGRAMS 42,493 42,000 493- -10 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 960 3,coo 2,040 680 2215-000-346054-000 AFTER SCHOOL PROGRAMS 62,862 59,coo 3,862- -70 2215-000-346055-000 ICE RINK 24,202 21,000 3,202- -150 2215-000-346056-000 KIDSPORT USAGE 1,582 1,coo 582- -580 2215-000-346057-000 YOUTH CAMPS 112,101 140,000 27,899 200 2215-000-346059-000 PICNIC IN THE PARK 23,703 36,000 12,297 340 2215-000-365010-000 FEC REFUNDS/DONATIONS 839 0 839- 00-. 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 1000 2215-000-371010-000 INVESTMENTS/DONATIONS/MISC.SALES 2,209 1,5oo 709- -470 2215-000-381060-000 HEALTH INSURANCE TRANSFER 52,500 70,000 17,500 250 TOTAL PARKS & REC REVENUE 1,030,253 1,493,000 462,747 310 PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 264,596 293,884 29,288 100 2215-436-460430-111 SEASONAL SALARIES 45,045 62,696 17,651 280 2215-436-460430-121 OVERTIME 70 750 680 910 2215-436-460430-153 HEALTH INSURANCE 53,905 65,610 11,705 180 2215-436-460430-155 RETIREMENT 22,550 25,784 3,234 130 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 545 1,700 1,155 680 2215-436-460430-224 JANITORIAL SUPPLIES 2,714 4,100 1,386 340 2215-436-460430-229 OTHER SUPPLIES 2,714 5,coo 2,286 460 2215-436-460430-231 GAS 11,356 17,000 5,644 330 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 2,371 4,000 1,629 410 2215-436-460430-320 PRINTING & ADVERTISING 0 Soo Soo 1000 2215-436-460430-341 ELECTRICITY 10,014 15,700 5,686 360 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 25,473 21,000 4,473- -210 2215-436-460430-344 NATURAL GAS 1,813 3,coo 1,187 400 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,435 2,500 1,065 430 2215-436-460430-351 TENNIS COURT REHABILITATION 0 2,000 2,000 1000 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 1000 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 6,740 10,coo 3,260 330 2215-436-460430-356 CONSULTANTS 0 700 700 1000 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 538 3,coo 2,462 820 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 2,623 8,coo 5,377 670 2215-436-460430-364 LANDSCAPING 363 5,400 5,037 930 2215-436-460430-367 VANDALISM REPAIRS 2,131 4,500 2,369 530 2215-436-460430-373 DUES & TRAINING 4,774 6,000 1,226 200 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 235 700 465 660 2215-436-460430-395 EQUIPMENT RENTAL 0 200 200 1000 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 1,000 3,coo 2,000 670 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 12 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-440 IRRIGATION SUPPLIES 2,774 8,5oo 5,726 670 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 1,385 3,coo 1,615 540 2215-436-460430-521 CENTRAL GARAGE TRANSFER 41,572 45,351 3,779 80 2215-436-460430-610 DEBT SERVICE PRINCIPAL 10,330 10,377 47 00-. 2215-436-460430-620 DEBT SERVICE INTEREST 365 469 104 220 2215-436-460430-941 PLAYGROUND EQUIP - (LAWRENCE PARK) 12,000 12,000 0 00-. 2215-436-460430-942 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 1000 SUBTOTAL PARKS EXPENDITURES ------------ 531,431 ------------- 655,421 ------------ 123,990 ------------ 190 ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 54,181 60,382 6,201 100 2215-436-460440-111 SEASONAL SALARIES 32,578 47,184 14,606 310 2215-436-460440-153 HEALTH INSURANCE 11,750 18,382 6,633 360 2215-436-460440-155 RETIREMENT 5,708 6,168 460 70 2215-436-460440-221 SAFETY EQUIPMENT 0 Soo Soo 1000 2215-436-460440-229 OTHER SUPPLIES 11,514 17,500 5,986 340 2215-436-460440-231 GAS 9,142 9,700 558 60 2215-436-460440-241 CONSUMABLE TOOLS 1,612 2,000 388 190 2215-436-460440-341 ELECTRICITY 5,262 8,200 2,938 360 2215-436-460440-345 TELEPHONE & COMMUNICATION 109 200 91 450 2215-436-460440-354 CONTRACT SERVICES 0 1,coo 1,000 1000 2215-436-460440-362 EQUIPMENT MAINTENANCE 13 700 687 980 2215-436-460440-364 LANDSCAPING 0 400 400 1000 2215-436-460440-367 VANDALISM REPAIRS 35 Soo 465 930 2215-436-460440-373 DUES & TRAINING 60 Soo 440 880 2215-436-460440-395 RENTAL EQUIPMENT 142 150 8 50 2215-436-460440-420 METAL PRODUCTS 0 400 400 1000 2215-436-460440-440 IRRIGATION 2,274 4,100 1,826 450 2215-436-460440-452 SAND & GRAVEL 0 2,700 2,700 1000 2215-436-460440-610 DEBT SERVICE -PRINCIPAL 14,520 14,241 279- -20 2215-436-460440-620 DEBT SERVICE -INTEREST 256 645 389 600 SUBTOTAL ATHLETIC COMPLEX ------------------------- 149,154 ------------ 195,552 ------------ 46,398 240 RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 83,140 92,455 9,315 100 2215-436-460431-111 SEASONAL SALARIES 9,736 11,593 1,857 160 2215-436-460431-153 HEALTH INSURANCE 20,584 22,961 2,377 100 2215-436-460431-155 RETIREMENT 6,280 7,719 1,440 190 2215-436-460431-218 DONATED SUPPLIES 0 1,5oo 1,500 1000 2215-436-460431-229 MISC. SUPPLIES 7,631 11,465 3,834 330 2215-436-460431-231 GAS 624 750 126 170 2215-436-460431-320 PRINTING ADVERTISING 0 10,5oo 10,500 1000 2215-436-460431-345 TELEPHONE COMMUNICATION 220 240 20 80 2215-436-460431-354 CONTRACT SERVICES 18,993 20,360 1,367 70 2215-436-460431-355 On Line Registration 330 0 330- 00-. 2215-436-460431-357 MUSIC FRANCHISE FEES 994 1,coo 6 10 2215-436-460431-373 DUES & TRAINING 523 600 77 130 SUBTOTAL RECREATION ------------------------- 149,053 ------------ 181,143 ------------ 32,090 180 YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 65,655 70,515 4,860 70 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 13 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460448-111 SEASONAL SALARIES 109,927 119,950 10,023 80 2215-436-460448-121 OVERTIME 159 Soo 341 680 2215-436-460448-153 HEALTH INSURANCE 11,960 21,435 9,475 440 2215-436-460448-155 RETIREMENT 4,788 7,089 2,301 320 2215-436-460448-224 JANITORIAL SUPPLIES {DAYCAMP FACILI 20 600 580 970 2215-436-460448-229 MISC. SUPPLIES 2,965 3,800 835 220 2215-436-460448-231 GAS 0 750 750 1000 2215-436-460448-320 PRINTING ADVERTISING 98 150 52 350 2215-436-460448-345 TELEPHONE COMMUNICATION 326 350 24 70 2215-436-460448-354 CONTRACT SERVICES 12,741 18,700 5,959 320 2215-436-460448-355 AFTER SCHOOL PROGRAM 2,269 5,coo 2,731 550 2215-436-460448-356 BANK FEES/CC CHARGES 2,867 3,200 333 100 2215-436-460448-357 OUT OF SCHOOL TIMES PROGRAM GRANT 0 6,200 6,200 1000 2215-436-460448-373 DUES & TRAINING 86 600 514 860 SUBTOTAL YOUTH CAMPS ------ - - - - -- 213,861 ------- - - - - -- 258,839 ------ - - - - -------- - - - - - - 44,978 170 POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 125,654 199,979 74,325 370 2215-437-460445-121 OVERTIME 0 1,200 1,200 1000 2215-437-460445-155 RETIREMENT 694 1,5oo 806 540 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 242 600 358 600 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,185 3,coo 1,815 610 2215-437-460445-226 CHLORINE/CHEMICALS 17,092 27,700 10,608 380 2215-437-460445-228 CONCESSION STAND SUPPLIES 12,582 19,coo 6,418 340 2215-437-460445-229 TOOLS/OTHER SUPPLIES 2,359 5,5oo 3,141 570 2215-437-460445-341 ELECTRICITY 6,867 10,coo 3,133 310 2215-437-460445-344 NATURAL GAS 20,714 25,000 4,286 170 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,488 1,5oo 12 10 2215-437-460445-354 LICENSES & FEES 818 1,300 482 370 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 5,323 8,700 3,377 390 2215-437-460445-380 TRAINING MATERIALS 245 800 555 690 SUBTOTAL POOL EXPENDITURES ------------ 195,263 ------------ ------------- 305,779 ------------- ------------------------ 110,516 360 ------------------------ TOTAL PARKS & RECREATION/POOL 1,238,762 1,596,734 357,972 220 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 14 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 84,865 95,648 10,783 110 2600-436-460433-111 SEASONAL SERVICES 5,757 8,013 2,256 280 2600-436-460433-121 OVERTIME 0 300 300 1000 2600-436-460433-153 HEALTH INSURANCE 17,192 21,118 3,926 190 2600-436-460433-155 RETIREMENT 6,618 6,940 322 50 2600-436-460433-229 OFFICE/OTHER SUPPLIES 46 550 504 920 2600-436-460433-231 GAS 1,296 2,500 1,204 480 2600-436-460433-241 CONSUMABLE TOOLS 1,157 2,000 843 420 2600-436-460433-354 CONTRACT SERVICES 18,000 26,500 8,500 320 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 1,442 2,500 1,058 420 2600-436-460433-362 EQUIPMENT MAINTENANCE 497 650 153 230 2600-436-460433-364 LANDSCAPING & TREES 1,481 12,500 11,019 880 2600-436-460433-373 DUES & TRAINING 357 800 443 550 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 1,924 2,344 420 180 2600-436-460433-521 CENTRAL GARAGE TRANSFER 6,658 7,264 606 80 2600-436-460433-522 ADMINISTRATIVE TRANSFER 8,619 9,403 784 80 2600-436-460433-528 DATA PROCESSING TRANSFER 2,620 2,858 238 80 2600-436-460433-610 DEBT SERVICE PRINCIPAL 8,278 8,172 106- -10 2600-436-460433-620 INTEREST EXPENSE 227 309 82 270 TOTAL URBAN FORESTRY 2601-436-460430-350 ADMIN 50 2601-436-460435-351 EMPIRE ESTATES ($44,911) 2601-436-460435-352 APPLEWAY ($4,564) 2601-436-460435-353 LEISURE HEIGHTS {$9,990} 2601-436-460435-356 SINOPAH SUED {$5,790} 2601-436-460435-357 COTTONWOOD SUED {$13,100} 2601-436-460435-358 WEST VIEW SUED ($22,680) 2601-436-460435-359 MTN VISTA ESTATES {$35,903+34,660} 2601-436-460435-360 RIVER GLEN SUED {$3,240} 2601-436-460435-361 VILLAGE GREENS {$3,540} 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 2601-436-460435-364 MTN VISTA ESTATES III $17,278.25 2601-436-460435-365 VILLAGE GREENS $3,540 2601-436-460435-366 w VIEW ESTATES $20,060 2601-436-460435-367 ABIGAIL SUBDIVISION {$4,253.90} 2601-436-460435-368 NORTHLAND SUED PHASE 4 TOTAL DEVELOPER TREES 2210 PARKS IN LIEU 2210-436-460430-826 TRANSFER TO TRAILS FUND- 93 N / 3 M TOTAL PARKS IN LIEU 2975 TRAILS 2975-436-460457-951 HWY93 NORTH TRAIL TOTAL TRAILS ------------------------- 167,035 210,369 ------------------------ 43,334 210 � 185 185 1��0 8,653 8,653 1000 0 4,336 4,336 1000 295 661 366 550 0 667 667 1000 0 2,253 2,253 1000 0 17, 536 17,536 100 o 590 27,669 27,079 98 0 295 278 17- -60 0 2,219 2,219 1000 0 948 948 100 o 0 1, 390 1,390 100 o 295 1,429 1,134 79 0 0 2,797 2,797 1000 885 9,375 8,490 91 0 0 3,074 3,074 1000 0 ------------------------- 8,812 8,812 ------------------------ 1000 2,360 92,282 89,922 970 8,181 9, 388 1,207 13 0 ------------------------- 8, 181 9, 388 ------------------------ 1,207 13 0 3,750 127,920 124,170 97 0 ------------------------- 3, 750 127,920 ------------------------ 124,170 97 0 06.05.2015 16:51 THE CITY OF KALISPELL, MONTANA Page 15 of 36 gb860'I_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 1, 2014 TH RU MAY 313 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 16 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 467,836 605,000 137,164 230 2230-000-342070-000 COUNTY EMS LEVY 63,592 100,coo 36,408 360 2230-000-383010-000 TRANSFER FROM GENERAL FUND 232,500 310,coo 77,500 250 TOTAL AMBULANCE REVENUE ------------ 763,928 ------------- 1,cis, coo ------------ 251,072 ------------ 250 AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 512,772 572,610 59,838 100 2230-440-420730-114 COMPTIME BUYBACK 1,547 3,coo 1,453 480 2230-440-420730-115 OUT OF RANK PAY 926 1,coo 74 70 2230-440-420730-121 OVERTIME 24,501 22,147 2,354- -110 2230-440-420730-153 HEALTH INSURANCE 114,827 135,834 21,007 150 2230-440-420730-155 RETIREMENT 67,454 75,963 8,509 110 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 1,001 1,coo 1- -00-. 2230-440-420730-218 NON -CAPITAL EQUIPMENT 537 19,5oo 18,963 970 2230-440-420730-231 GAS & OIL 6,320 7,560 1,240 160 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 884 6,000 5,116 850 2230-440-420730-312 POSTAGE/PRINTING 921 2,000 1,079 540 2230-440-420730-345 TELEPHONE & COMMUNICATION 1,515 700 815- -1160 2230-440-420730-354 PARAMEDIC RECERTIFICATION 12,937 11,800 1,137- -100 2230-440-420730-355 911 CENTER CONTRIBUTION 24,468 32,623 8,155 250 2230-440-420730-359 AUDIT/CC OTHER FEES 1,311 1,400 89 60 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 131 7,000 6,869 980 2230-440-420730-373 DUES & TRAINING 1,621 5,coo 3,379 680 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 1000 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 35,437 39,300 3,863 100 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 5,737 7,000 1,263 180 2230-440-420730-521 CENTRAL GARAGE TRANSFER 13,507 14,735 1,228 80 2230-440-420730-522 ADMINISTRATIVE TRANSFER 27,811 30,340 2,529 80 2230-440-420730-528 DATA PROCESSING TRANSFER 10,480 11,432 952 80 TOTAL AMBULANCE EXPENDITURES ------------ 866,647 ------------- 1,010,444 ------------------------ 143,797 140 FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 0 6,000 6,000 1000 2956-416-420414-219 FIRE PREVENTION GRT FY15 0 8,113 8,113 1000 2956-416-420415-940 HEART MONITOR DONATION 24,887 24,887 0 00-. TOTAL FIRE GRANTS ------------ 24,887 ------------- 39,coo ------------ ------------ 14,113 360 2957-416-420400-155 RETIREMENT 1,887 2,500 613 250 2957-416-420410-125 PASS THRU HAZMAT OT 15,901 19,365 3,464 180 2957-416-420410-218 PASS THRU HAZMAT EQUIP 19,044 27,345 8,301 300 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 638 ------------ 6,100 ------------- 5,462 900 ------------------------ TOTAL HAZMAT GRANTS 37,470 55,310 17,840 320 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 17 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete GAL ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 226,823 250,000 23,177 90 2394-000-323103-000 PLUMBING PERMITS 15,359 13,000 2,359- -180 2394-000-323104-000 MECHANICAL PERMITS 27,346 54,000 26,654 490 2394-000-323107-000 HOUSE MOVING PERMITS 0 100 100 1000 2394-000-323108-000 PLAN REVIEW FEES 84,523 so, coo 34,523- -690 2394-000-364030-000 SALE OF MISCELLANEOUS 31 0 31- 00-. 2394-000-371010-000 INVESTMENT EARNINGS 2,867 2,000 867- -430 TOTAL REVENUE ------------------------- 356,950 369,100 ------------------------ 12,150 30 BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 224,465 283,870 59,405 210 2394-420-420530-121 OVERTIME 7,724 3,5oo 4,224- -1210 2394-420-420530-153 HEALTH INSURANCE 37,858 58,264 20,406 350 2394-420-420530-155 RETIREMENT 16,810 20,314 3,504 170 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 4,195 25,000 20,805 830 2394-420-420530-231 GAS & OIL 1,975 3,coo 1,025 340 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 646 1,750 1,104 630 2394-420-420530-323 ST. ED. ASSESSMENTS 896 2,500 1,604 640 2394-420-420530-345 TELEPHONE & COMMUNICATION 2,042 2,500 458 180 2394-420-420530-353 AUDITING 3,500 3,5oo 0 00-. 2394-420-420530-354 CONTRACT SERVICES 656 1,300 644 500 2394-420-420530-373 DUES &: TRAINING 6,524 4,000 2,524- -630 2394-420-420530-510 PROPERTY INSURANCE 4,755 6,000 1,245 210 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,455 1,587 132 80 2394-420-420530-522 ADMINISTRATIVE TRANSFER 11,643 12,701 1,058 80 2394-420-420530-528 DATA PROCESSING TRANSFER 4,497 4,790 293 60 2394-420-420530-930 WEB BASED SOFTWARE PACKAGE 29,073 35,coo 5,928 170 TOTAL BUILDING DEPT. ------------------------- 358,712 469,576 ------------------------ 110,864 240 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 18 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 67,752 73,796 6,044 80 2400-410-430263-153 HEALTH INSURANCE 9,103 11,455 2,352 210 2400-410-430263-155 RETIREMENT 4,846 5,264 418 80 2400-410-430263-244 STREET LIGHT SUPPLIES 12,109 is, coo 2,891 190 2400-410-430263-341 ELECTRICITY 138,229 165,000 26,771 160 2400-410-430263-360 REPAIR &: MAINT SERVICES 8,325 12,000 3,675 310 2400-410-430263-510 INSURANCE 891 1,085 194 180 2400-410-430263-522 ADMINISTRATIVE TRANSFER 9,875 10,773 898 80 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 21,430 21,430 0- 00-. 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 816 816 0- 00-. TOTAL LIGHT MAINT. ------------ ------------- 273,377 316,619 ------------ ------------ 43,242 140 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 26,545 40,000 13,455 340 2420-421-430234-957 ALLEY PAVING 24,112 25,000 888 40 2420-421-430240-231 GAS & OIL 27,634 40,000 12,366 310 2420-421-430240-344 NATURAL GAS 3,381 4,000 619 150 2420-421-430240-354 CONTRACT SERVICES - STRIPING 103,919 120,000 16,081 130 2420-421-430240-360 REPAIR &: MAINT SERVICES 1,477 1,5oo 23 20 2420-421-430240-368 OVERLAY/CHIPSEALS 169,339 200,000 30,661 150 2420-421-430240-452 GRAVEL 2,898 2,500 398- -160 2420-421-430240-453 EQUIPMENT RENTAL 10,500 21,750 11,250 520 2420-421-430240-471 DE-ICER/ROAD OIL 22,598 40,000 17,402 440 2420-421-430240-472 ASPHALT 32,553 31,500 1,053- -30 2420-421-430240-473 CRACK SEALING 9,420 14,500 5,080 350 TOTAL GAS TAX ------------------------- 434,375 540,750 ------------------------ 106,375 200 2825 MACI GRANT 2825-421-430240-940 FLUSH TRUCK / SWEEPER 161 376,000 375,839 1000 TOTAL MACI GRANT ------------------------- 161 376,000 ------------------------ 375,839 1000 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 19 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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. 576,753 636,776 60,023 90 2500-421-430240-121 OVERTIME 14,539 25,000 10,461 420 2500-421-430240-153 HEALTH INSURANCE 113,144 148,088 34,944 240 2500-421-430240-155 RETIREMENT 42,148 45,235 3,087 70 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 6,654 9,coo 2,346 260 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 5,609 6,000 391 70 2500-421-430240-220 OTHER SUPPLIES 2,765 4,100 1,335 330 2500-421-430240-231 GAS & OIL 28,586 42,000 13,414 320 2500-421-430240-341 ELECTRICITY 2,534 1,450 1,084- -750 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,304 1,5oo 196 130 2500-421-430240-354 CONTRACT SERVICES 7,130 is, coo 7,870 520 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 32,111 28,000 4,111- -150 2500-421-430240-366 BUILDING MAINTENANCE 282 3,coo 2,718 910 2500-421-430240-373 DUES & TRAINING 3,202 5,5oo 2,298 420 2500-421-430240-388 MEDICAL SERVICES 694 1,5oo 806 540 2500-421-430240-510 LIABILITY INSURANCE 20,011 23,051 3,040 130 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 10,282 10,coo 282- -30 2500-421-430240-521 CENTRAL GARAGE TRANSFER 161,829 176,541 14,712 80 2500-421-430240-522 ADMINISTRATIVE TRANSFER 72,535 79,129 6,594 80 2500-421-430240-528 DATA PROCESSING TRANSFER 7,860 8,574 714 80 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 97,165 115,182 18,017 160 2500-421-430240-620 INT.EKP-PU/PLOW TRK/BLDG CONST 3,298 5,846 2,548 440 2500-421-430240-941 DUMP TRUCKS - INCEPTION OF LOAN 4,795 5,coo 205 40 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 246,689 383,729 137,040 360 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 253,777 296,070 42,293 140 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 518 38,328 37,810 990 2500-421-430264-110 TSS - SALARIES 105,641 115,213 9,572 80 2500-421-430264-121 OVERTIME 1,721 9,5oo 7,779 820 2500-421-430264-153 HEALTH INSURANCE 13,090 15,280 2,190 140 2500-421-430264-155 RETIREMENT 7,573 8,119 546 70 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 666 1,5oo 834 560 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 6,538 6,700 162 20 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 3,294 3,5oo 206 60 2500-421-430264-242 STREET SIGNS 32,126 40,000 7,874 200 2500-421-430264-243 TRAFFIC SIGNALS 1,718 19,coo 17,282 910 2500-421-430264-245 BARRICADE MATERIALS 4,879 5,coo 121 20 2500-421-430264-341 ELECTRICITY 1,578 3,5oo 1,922 550 2500-421-430264-345 COMMUNICATIONS 702 750 48 60 2500-421-430264-354 CONTRACT SERVICES 1,562 10,coo 8,438 840 2500-421-430264-362 EQUIPMENT MAINTENANCE 782 3,coo 2,218 740 2500-421-430264-366 BUILDING MAINTENANCE 285 2,000 1,715 860 2500-421-430264-373 DUES & TRAINING 2,852 5,5oo 2,648 480 2500-421-430264-428 PAINT MATERIALS 5,037 8,coo 2,963 370 2500-421-430264-510 LIABILITY INS.-TSS 2,450 2,736 286 100 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,500 2,500 1000 2500-421-430264-521 CENTRAL GARAGE TRANSFER 7,955 8,679 724 80 2500-421-430264-532 OFFICE RENT 7,838 7,838 0 00-. TOTAL SPEC. ST. MAINT. 1,924,501 2,391,914 467,413 200 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 20 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 2880-480-470210-711 REDEVELOPMENT TOTAL LOAN REVOLVING 2881 CD LOAN REV. 42 2881-480-470210-353 AUDITING 2881-480-470210-711 REDEVELOPMENT TOTAL 2881 CD REV. 42 2886 CD MISC. 2886-480-470210-210 OFFICE SUPPLIES 2886-480-470210-355 CDBG SENIOR CENTER 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-790 COMM. DEV. ACTIVITIES 2886-480-470210-795 REDEVELOPMENT - OLD SCHOOL STATION TOTAL CD MISC. 2887 RURAL DEVELOPMENT 41 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 41 2888 RURAL DEVELOPMENT 42 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 42 2930 PRESERVE AMERICA GRANT 2930-480-470240-354 CONT SERV-NPS PRESERVE AMERICA TOTAL PRESERVE AMERICA GRNT 2945 CDBG-ED FVCC 42 2945-480-470242-790 MACHINERY/EQUIPMENT-CDBG-ED-13-01 2945-480-470242-820 ADMIN TRANSFER -to Com. Development TOTAL 2945 CDBG-ED FVCC 42 1,370 1,370 0 o 27,101 350,coo 322,899 920 ------------ 28,471 ------------- 351,370 ------------------------ 322,899 920 1,000 1,coo 0 o 0 100,coo 100,000 1000 ------------ 1,000 ------------- 101,coo ------------------------ 100,000 990 0 900 900 100 0 0 30,coo 30,000 1000 9,634 25,000 15,366 610 2,000 2,000 0 00-. 2,620 2,858 238 80 1,175 1,175 0 o 0 200,000 200,000 1000 1,258,394 1,300,coo 41,606 30 ------------ 1, 273, 823 ------------- 1, 561, 933 ------------------------ 288,110 18 0 17,912 18,coo 88 00-. 4,162 5,coo 838 170 10 75,000 74,990 1000 ------------ 22,084 ------------- 98,coo ------------------------ 75,916 770 7,977 8,050 73 10 2,048 2,200 152 70 0 so, coo 50,000 1000 ------------ 10,025 ------------- 60,250 ------------------------ 50,225 830 7,251 ------------ 7,251 ------------- 0- ------------------------ 00-. 7,251 7,251 0- 00-. 0 92,687 92,687 1000 86 8,658 8,572 990 ------------ 86 ------------- 101,345 ------------------------ 101,259 1000 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 21 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete GAL ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 0 908 908 1000 2955-480-470210-352 PERSONNEL -PETROLEUM 0 3,5O5 3,505 1000 2955-480-470210-353 FRINGES -PETROLEUM 0 493 493 1000 2955-480-470210-354 CONTRACTED SERVICES-PETROLUUM 3,612 5,218 1,606 310 2955-480-470210-373 TRAVEL -PETROLEUM 0 37 37 1000 2955-480-470210-720 LOANS -PETROLEUM 3,436 65,790 62,354 950 2955-480-470210-721 SUBGRANTS - PETROLEUM 0 100,coo 100,000 1000 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 0 2,458 2,458 1000 2955-480-470215-352 PERSONNEL -HAZARDOUS SUBSTANCES 0 41,601 41,601 1000 2955-480-470215-353 FRINGES -HAZARDOUS SUBSTANCES 0 13,781 13,781 1000 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 3,807 14,874 11,067 740 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 175 6,249 6,074 970 2955-480-470215-720 LOANS -HAZARDOUS SUBSTANCES 66,459 414,600 348,141 840 2955-480-470215-721 CLEANUP SUBGRANTS - HAZARDOUS 21,426 199,076 177,650 890 TOTAL BROWNFIELDS LOAN REV. ------------------------- 98,915 868,590 ------------------------ 769,675 890 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 22 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN 923 25,339 24,416 960 2915-413-420140-155 RETIREMENT 0 1,095 1,095 1000 2915-413-420140-218 SMALL EQUIP - STONEGARDEN 34,836 46,433 11,597 250 2915-413-420140-354 CONTRACT SERVICES 31,519 70,149 38,630 550 ------------ TOTAL 2915 STONEGARDEN GRANT ------------- 67,278 ------------ 143,016 ------------ 75,738 530 2916 DRUG ENFORCCMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 56,509 62,519 6,010 100 2916-413-420140-121 OVERTIME 6,606 6,000 606- -100 2916-413-420140-153 HEALTH INSURANCE 14,247 15,264 1,017 70 2916-413-420140-155 RETIREMENT 7,295 8,399 1,104 130 2916-413-420140-354 CONTRACT SERVICES 5,448 5,200 248- -5. 2916-413-420140-820 TRANSFER OUT 10,976 10,976 0- 00-. ------------ TOTAL 2916 DRUG ENFORCEMENT ------------- 101,082 ------------ 1c8,358 ------------ 7,276 70 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 3,421 41,602 38,181 920 2919-413-420140-125 DUI TASK FORCE 0 8,coo 8,000 1000 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 29,160 38,800 9,640 250 2919-413-420140-127 SCHOOL DIST. OT 20,421 20,000 421- -20 2919-413-420140-218 JAG GRT/RADIOS/2013-DJ-BX-0803 23,663 25,562 1,899 70 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 3,483 2,500 983- -390 2919-413-420140-221 Bullet Proof Vests 33,081 43,600 10,519 240 2919-413-420140-940 EQUIPMENT (SRT CAMERA) 0 14,000 14,000 1000 2919-413-420140-941 IN CAR CAMERA SYSTEM - FORFEITURE F 10,976 10,976 0- 00-. ------------ TOTAL LAW ENF. GRANT ------------- 124,206 ------------ 205,040 ------------ 80,834 390 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 23 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete GAL 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 7,845 25,000 17,155 690 ------------------------------------------------- 7,845 25,000 17,155 690 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 24 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 270 0 270- 00-. 5210-000-343210-000 METERED WATER SALES 2,671,435 2,800,000 128,565 50 5210-000-343220-000 UNMETERED WATER SALES 8,357 0 8,357- 00-. 5210-000-343225-000 IMPACT FEES 218,922 266,000 47,078 180 5210-000-343230-000 METER REPLACEMENT FEE 93,407 95,coo 1,593 20 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 36,629 30,coo 6,629- -220 5210-000-343270-000 WATER TURN ON FEES 2,715 2,500 215- -90 5210-000-343275-000 TAG FEE 17,580 7,500 10,080- -1340 5210-000-343365-000 LATECOMER ADMIN FEE 774 14,000 13,226 940 5210-000-371010-000 INVESTMENT EARNINGS 35,023 25,000 10,023- -400 TOTAL WATER REVENUE 3,085,111 3,240,000 154,889 50 WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 574,957 692,001 117,044 170 5210-447-430550-111 SEASONAL SALARIES 687 5,coo 4,313 860 5210-447-430550-121 OVERTIME 14,895 20,000 5,105 260 5210-447-430550-153 HEALTH INSURANCE 101,264 143,485 42,221 290 5210-447-430550-155 RETIREMENT 42,234 49,146 6,912 140 5210-447-430550-210 OFFICE COMPUTER SUPPLIES 9,153 11,000 1,847 170 5210-447-430550-218 NON CAP SAFETY EQUIP/SUPPLIES 4,738 8,5oo 3,762 440 5210-447-430550-226 CHLORINE CHEMICALS 29,932 38,coo 8,068 210 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 3,059 4,500 1,441 320 5210-447-430550-231 GAS & OIL 24,010 36,000 11,990 330 5210-447-430550-312 POSTAGE PRINTING/ADVERTISING 487 4,000 3,513 880 5210-447-430550-336 LICENSES FEES 16,451 18,coo 1,550 90 5210-447-430550-341 ELECTRICITY 107,268 139,coo 31,732 230 5210-447-430550-344 NATURAL GAS 10,043 13,000 2,957 230 5210-447-430550-345 TELEPHONE & COMMUNICATION 7,719 9,coo 1,281 140 5210-447-430550-349 LAB SERVICES 10,450 22,000 11,550 530 5210-447-430550-353 AUDITING 5,000 5,coo 0 00-. 5210-447-430550-354 CONTRACT SERVICES 35,247 55,coo 19,753 360 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 9,714 25,000 15,286 610 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 7,640 is, coo 7,360 490 5210-447-430550-366 BUILDING MAINTENANCE 1,235 12,000 10,765 900 5210-447-430550-373 DUES & TRAINING 7,129 9,coo 1,871 210 5210-447-430550-388 MEDICAL SERVICES 285 800 515 640 5210-447-430550-410 CONSTRUCTION MATERIALS 26,667 35,coo 8,333 240 5210-447-430550-422 HYDRANTS 9,696 6,000 3,696- -620 5210-447-430550-423 MATERIALS FOR MAINS 8,559 10,coo 1,441 140 5210-447-430550-424 MATERIALS -SERVICE LINES 12,236 14,000 1,764 130 5210-447-430550-425 MATERIALS PUMPS/WELLS 3,921 45,000 41,079 910 5210-447-430550-510 PROPERTY & LIABILITY INS. 23,144 30,coo 6,856 230 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 145 is, coo 14,855 990 5210-447-430550-521 CENTRAL GARAGE TRANSFER 13,060 14,248 1,188 80 5210-447-430550-522 ADMINISTRATIVE TRANSFER 95,848 104,561 8,713 80 5210-447-430550-528 DATA PROCESSING TRANSFER 20,960 22,864 1,904 80 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 9,145 9,coo 145- -20 5210-447-430550-935 ARMORY WELL SHEEPHERDERS TANK MIXER 139 20,000 19,861 990 5210-447-430550-936 Noffsinger Spring Generator 0 90,coo 90,000 1000 5210-447-430550-937 Sheepherder Res. SCADA Backup PWR 1,310 15,851 14,541 920 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 26 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-938 Lower Zone Reservoir Improvements 0 60,000 60,000 1000 5210-447-430550-947 US 93N. UTILITY RELOCATE 15,709 27,343 11,634 430 5210-447-430550-948 METERS (METER FUNDS) 010125 6,760 120,000 113,240 940 5210-447-430550-950 4TH AVE EN MAIN REPLACEMENT 665,115 798,620 133,505 170 5210-447-430550-951 SECURITY SCADA UPGRADES 5,283 is, coo 9,717 650 5210-447-430550-958 FOUR (4) LOOPED PROJECTS 0 174,000 174,000 1000 5210-447-430550-967 2ND AVE WN MAIN REPLC FROM MT TO WA 469 275,000 274,531 1000 5210-447-430550-968 DEPOT WELL REVITALIZATION 4,930 is, coo 10,070 670 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 75,000 75,000 1000 5210-447-430555-941 METERS (NEW SERVICES)010120 3,177 35,600 32,423 910 SUBTOTAL WATER FACILITIES ------------ 1,949,871 ------------ ------------- 3,361,519 ------------- ------------ 1,411,648 ------------ ------------ 420 ------------ 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 REVENUE BONDS 5210-447-490204-610 BOND PRIN-HWY 93 S WTR-2004 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 5210-447-490206-610 PRIN-MTR&WELL WRF7104 1.25o;WRF8114 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25o;WRF8114 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2 /IDAHO&MAI 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2 /IDAHO&MAIN SUBTOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 77,760 88,558 10,798 120 13,838 24,590 10,752 440 5,778 6,527 749 110 211 2,000 1,789 890 2,020 2,020 0 00-. 0 1, Soo 1,500 100 o 26,375 35,coo 8,625 250 386 1, Soo 1,114 74 0 6,885 7, 511 626 8 0 20,960 22,864 1,904 80 7,838 7, 838 0 o ------------ 162,051 ------------ ------------- 199,908 ------------- ------------------------ 37,857 ------------------------ 190 0 60,000 60,000 1000 34,275 34,275 0 00-. 350 300 50- -170 o 258,000 258,000 1000 27,904 27, 905 1 o 0 46,000 46,000 1000 6,070 6,070 0 00-. ------------ 68,599 ------------ ------------- 432,550 ------------- ------------------------ 363,951 ------------------------ 840 0 840,000 840,000 1000 ------------ 0 ------------ ------------- 840,000 ------------- ------------------------ 840,000 ------------------------ 1000 2,180,521 4,833,977 2,653,456 550 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 26 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 270 0 270- 00-. 5310-000-343310-000 SEWER SERVICE CHARGES 3,971,950 4,200,000 228,050 50 5310-000-343330-000 IMPACT FEES (SANITARY) 196,896 160,000 36,896- -230 5310-000-343335-000 IMPACT FEES (WWTP) 263,037 220,000 43,037- -200 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 20,684 5,coo 15,684- -3140 5310-000-343365-000 LATECOMER ADMIN FEES 7 0 7- 00-. 5310-000-371010-000 INVESTMENT EARNINGS 46,133 33,500 12,633- -380 TOTAL SEWER REVENUE ------------ 4,498,976 ------------- 4,618,500 ------------ 119,524 ------------ 30 SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 64,195 72,402 8,207 110 5310-454-430620-153 HEALTH INSURANCE 10,863 18,916 8,053 430 5310-454-430620-155 RETIREMENT 4,766 5,324 558 100 5310-454-430620-215 OFFICE SUPPLIES/computers 214 2,000 1,786 890 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 2,920 4,850 1,930 400 5310-454-430620-355 BILLING COSTS 26,412 35,coo 8,588 250 5310-454-430620-373 DUES & TRAINING 386 1,5oo 1,114 740 5310-454-430620-522 ADMINISTRATIVE TRANSFER 6,120 6,677 557 80 5310-454-430620-528 DATA PROCESSING TRANSFER 20,960 22,864 1,904 80 5310-454-430620-532 OFFICE RENT 7,838 7,838 0 00-. SUBTOTAL SEWER BILLING COSTS ------------ ------------- 144,675 ------------------------- ------------ 177,371 ------------ ------------ 32,696 180 ------------ SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 219,319 267,495 48,176 180 5310-454-430630-121 OVERTIME 1,028 5,5oo 4,472 810 5310-454-430630-153 HEALTH INSURANCE 46,418 56,777 10,359 180 5310-454-430630-155 RETIREMENT 15,824 17,852 2,028 110 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 7,312 9,200 1,888 210 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 6,754 6,500 254- -40 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,658 2,000 342 170 5310-454-430630-231 GAS & OIL 9,267 11,500 2,233 190 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 21 400 379 950 5310-454-430630-341 ELECTRICITY 42,192 54,500 12,309 230 5310-454-430630-344 NATURAL GAS 11,882 14,500 2,618 180 5310-454-430630-345 TELEPHONE & COMMUNICATION 19,050 23,000 3,950 170 5310-454-430630-353 AUDITING 3,000 3,coo 0 00-. 5310-454-430630-354 CONTRACT SERVICES 5,762 24,000 18,238 760 5310-454-430630-356 CONSULTANTS 0 8,coo 8,000 1000 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 4,270 5,coo 730 150 5310-454-430630-373 DUES & TRAINING 278 3,coo 2,722 910 5310-454-430630-388 MEDICAL SERVICES 208 800 592 740 5310-454-430630-410 CONSTRUCTION MATERIALS 5,546 9,coo 3,454 380 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 19,964 so, coo 30,036 600 5310-454-430630-510 PROPERTY & LIABILITY INS. 58,359 67,891 9,532 140 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 18,308 20,000 1,692 80 5310-454-430630-521 CENTRAL GARAGE TRANSFER 6,680 7,288 608 80 5310-454-430630-522 ADMINISTRATIVE TRANSFER 54,271 29,205 25,066- -860 5310-454-430630-528 DATA PROCESSING TRANSFER 10,480 11,432 952 80 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 27 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-532 OFFICE RENT 7,838 7,838 0 00-. 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 15,804 30,coo 14,196 470 5310-454-430630-920 Install Lift Station Enclosure 10,688 23,000 12,312 540 5310-454-430630-947 HWY 93 N BYPASS UTILITY RELOCATE DE 1,997 2,067 70 30 5310-454-430630-950 BACKUP GENERATOR FOR LS # 11 5,765 22,259 16,494 740 5310-454-430630-951 1ST ALLEY EN PIPE UPSIZE (34o RATE 87,192 107,000 19,808 190 5310-454-430630-952 PETERSON SCHOOL ALLEY REPLACEMENT 0 119,coo 119,000 1000 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 16,315 20,000 3,685 180 5310-454-430630-959 2ND ALLEY E REPLACEMENT 57,080 202,500 145,420 720 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 7,060 so, coo 42,940 860 SUBTOTAL SEWER COLLECTION ------------ 777,590 ------------ ------------- 1,291,504 ------------- ------------ 513,914 ------------ ------------ 400 ------------ IMPACT FEES 5310-454-430635-951 1ST ALLEY EN PIPE UPSIZE (34o RATE 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 5310-454-430635-957 GRANDVIEW PUMP STA/GRAVITY MAIN 520 5310-454-430635-958 SPRING CREEK INTERCEPTOR DESIGN SUBTOTAL IMPACT FEE EXPENSE REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.250 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.250 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.250 SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 5310-455-430640-110 5310-455-430640-111 5310-455-430640-121 5310-455-430640-153 5310-455-430640-155 5310-455-430640-210 5310-455-430640-218 5310-455-430640-225 5310-455-430640-226 5310-455-430640-229 5310-455-430640-231 5310-455-430640-312 5310-455-430640-336 SUBTOTAL DEPRECIATION -SANITARY SUBTOTAL SANITARY SEWER 173,965 208,000 34,035 160 1,569 247,640 246,071 990 96,019 145,000 48,981 340 269,874 405,000 135,126 330 ------------ 541,426 ------------ ------------- 1,005,640 ------------- ------------------------ 464,214 460 ------------------------ 0 78,000 78,000 1000 18,889 18,889 0 00-. 0 300 300 1000-. ------------ 18,889 ------------ ------------- 97,189 ------------- ------------------------ 78,300 810 ------------------------ 0 ------------ 820,000 ------------- 820,000 1000 ------------------------ 0 ------------ 820,000 ------------- 820,000 1000 ------------------------ 1,337,905 ------------ 3,214,333 ------------- 1,876,428 580 ------------------------ WWTP/OPERATIONS SALARIES-WWTP 317,188 384,625 67,437 180 SEASONAL SALARIES 687 5,coo 4,313 860 OVERTIME 19,531 21,500 1,969 90 HEALTH INSURANCE 54,221 65,237 11,016 170 RETIREMENT 24,365 26,065 1,700 70 OFFICE/COMPUTER SUPPLIES/EQUIP 6,201 10,coo 3,799 380 SAFETY EQUIP & SUPPLIES 1,340 2,700 1,360 500 ALUM 11,324 20,000 8,676 430 CHLORINE & CHEMICALS 10,802 16,000 5,198 320 JANITORIAL/OTHER SUPPLIES/RENTAL 3,204 7,000 3,796 540 GAS & OIL 10,553 18,5oo 7,947 430 POSTAGE, PRINTING & ADVERTISING 102 350 248 710 LICENSES & FEES 6,457 11,000 4,543 410 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 28 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-341 ELECTRICITY 141,403 172,000 30,597 180 5310-455-430640-342 WATER 6,488 6,150 338- -60 5310-455-430640-344 NATURAL GAS 45,041 55,coo 9,959 180 5310-455-430640-345 TELEPHONE & COMMUNICATION 4,607 5,coo 393 80 5310-455-430640-353 AUDITING 4,000 4,000 0 00-. 5310-455-430640-354 CONTRACT -GLACIER GOLD 107,592 124,000 16,408 130 5310-455-430640-355 OTHER CONTRACT SERVICES 25,289 30,coo 4,711 160 5310-455-430640-356 CONSULTANTS 16,003 95,coo 78,997 830 5310-455-430640-358 CONSULTANT-TMDL 4,161 is, coo 10,839 720 5310-455-430640-360 MISC. MAINT SERVICES 17,150 30,coo 12,850 430 5310-455-430640-366 BUILDING MAINTENANCE 1,810 30,coo 28,190 940 5310-455-430640-373 DUES & TRAINING 2,389 7,500 5,111 680 5310-455-430640-388 MEDICAL SERVICES 5o 600 550 920 5310-455-430640-510 PROPERTY & LIABILITY INS. 37,695 38,320 625 20 5310-455-430640-521 CENTRAL GARAGE TRANSFER 16,059 17,519 1,460 80 5310-455-430640-522 ADMINISTRATIVE TRANSFER 106,918 116,638 9,720 80 5310-455-430640-528 DATA PROCESSING TRANSFER 15,720 17,148 1,428 80 5310-455-430640-920 BUILDINGS 11,618 59,coo 47,382 800 5310-455-430640-940 MACHINERY & EQUIPMENT 0 60,000 60,000 1000 SUBTOTAL inWTP OPERATIONS 1,029,968 1,470,852 440,884 300-. in WTP BONDED PROJECT ------------ ------------- ------------ ------------ 5310-455-430644-935 inWTP- REPLACEMENT (10125) 7,823 ------------ 45,000 ------------- 37,177 830 ------------------------ SUBTOTAL inWTP BONDED 7,823 ------------ 45,000 ------------- 37,177 830 ------------------------ in WTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 40,558 100,coo 59,442 590 5310-455-430645-933 SOLIDS DEWATERING DESIGN CONST. 499,434 615,610 116,176 190 5310-455-430645-940 MACHINERY & EQUIPMENT 134,284 238,000 103,716 440 SUBTOTAL inWTP REPLACEMENT ------------ 674,276 ------------ ------------- 953,610 ------------- ------------------------ 279,334 290 ------------------------ in WTP LAB OPERATIONS 5310-455-430646-110 SALARIES-inWTP LAB 111,256 134,177 22,921 170 5310-455-430646-153 HEALTH INSURANCE 24,386 28,108 3,722 130 5310-455-430646-155 RETIREMENT 8,017 8,891 874 100 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,724 4,500 2,776 620 5310-455-430646-218 NON -CAPITAL EQUIPMENT 1,769 2,500 731 290 5310-455-430646-222 LAB SUPPLIES 8,058 7,500 558- -70 5310-455-430646-349 LAB SERVICES 12,540 20,000 7,460 370 5310-455-430646-362 EQUIPMENT MAINTENANCE 2,141 4,000 1,859 460 5310-455-430646-373 DUES & TRAINING 1,422 2,700 1,278 470 SUBTOTAL TnWTP LAB OPERATIONS ------------ 171,314 ------------- 212,376 ------------------------ 41,062 190 DEBT SERVICE - in WTP 5310-455-490227-610 PRIN-inWTP IMP/SRF8164R/2.250 0 761,000 761,000 1000-. 5310-455-490227-620 INT-inWTP IMP/SRF8164R/2.250 251,235 251,235 0 o 5310-455-490228-610 PRIN/inWTP DIGESTER LID/SRF13326/3.0 0 48,000 48,000 1000 5310-455-490228-620 INT-inWTP DIGESTER LID/SRF13326/3.0% 36,330 ------------ 36,330 ------------- 0 00-. ------------------------ 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 29 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete GAL ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. SUBTOTAL DEBT SERVICE - WWTP 287,565 1,096,565 809,000 740 ------------------------------------------------- CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 5310-455-510400-831 DEPRECIATION EXPENSE SUTOTAL WWTP DEPRECIATION/REPL SUBTOTAL WWTP TOTAL BILLING/SANITARY/WWTP 0 411,599 411,599 1000 0 1/425,000 1,425,000 1000 ------------------------------------------------- 0 1,836,599 1,836,599 1000 ------------------------------------------------- 2,170,945 5,615,002 3,444,057 610 ------------------------------------------------- 3,653,525 9,006,706 5,353,181 590 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 30 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 270 0 270- 00-. 5349-000-334040-000 PETRC TANK RELEASE/MONITORING REIMB 2,765 2,500 265- -110 5349-000-343033-000 IMPACT FEES 94,330 150,coo 55,670 370 5349-000-343034-000 PERMIT FEES 1,095 0 1,095- 00-. 5349-000-343035-000 STORM SEWER CHARGES 0 1,coo 1,000 1000 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 838,961 830,coo 8,961- -10 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,464 2,000 536 270 5349-000-365000-000 DONATIONS & STRM SWR CLASS 11,075 0 11,075- 00-. 5349-000-371010-000 INTEREST ON INVESTMENTS 15,804 8,coo 7,804- -980 TOTAL STORM REVENUE 965,764 993,5oo 27,736 30 STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 297,185 350,378 53,193 150 5349-453-430246-121 OVERTIME 906 4,000 3,094 770 5349-453-430246-153 HEALTH INSURANCE 58,189 71,561 13,372 190 5349-453-430246-155 RETIREMENT 21,581 25,139 3,558 140 5349-453-430246-210 ❑FFICE/COMPUTER SUPPLIES 8,038 10,100 2,062 200 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 4,151 3,5oo 651- -190 5349-453-430246-229 OTHER SUPPLIES/TOOLS 550 2,200 1,650 750 5349-453-430246-231 GAS & OIL 9,106 11,500 2,394 210 5349-453-430246-345 TELEPHONE & COMMUNICATION 472 800 328 410 5349-453-430246-353 AUDITING 2,340 2,340 0 00-. 5349-453-430246-354 CONTRACT SERVICE 1,133 6,000 4,867 810 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 11,708 25,000 13,292 530 5349-453-430246-357 IMPACT FEE UPDATE 0 7,500 7,500 1000 5349-453-430246-358 CONSULTANTS 0 7,000 7,000 1000 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 4,161 is, coo 10,839 720 5349-453-430246-360 REPAIR & MAINT SERVICES 1,912 2,500 588 240 5349-453-430246-362 GROUNDWATER MONITORING 2,181 10,coo 7,819 780 5349-453-430246-371 CURB & GUTTER 3,810 7,000 3,191 460 5349-453-430246-373 DUES & TRAINING 627 3,5oo 2,873 820 5349-453-430246-388 MEDICAL SERVICES 0 100 100 1000 5349-453-430246-410 CONSTRUCTION MATERIALS 3,047 10,coo 6,953 700 5349-453-430246-510 PROPERTY & LIABILITY INS. 4,918 7,982 3,064 380 5349-453-430246-521 CENTRAL GARAGE TRANSFER 6,680 7,287 607 80 5349-453-430246-522 ADMINISTRATIVE TRANSFER 31,489 34,352 2,863 80 5349-453-430246-528 DATA PROCESSING TRANSFER 7,860 8,574 714 80 5349-453-430246-530 BNSF LEASE PMT 5,541 5,700 159 30 5349-453-430246-532 OFFICE RENT 7,838 7,838 0 00-. 5349-453-430246-840 MACI GRANT MATCH (SWEEPER) 0 42,264 42,264 1000 5349-453-430246-951 9TH ST E STORMWATER IMPRV 204,127 200,000 4,127- -20 5349-453-430246-952 STORM DRAIN CORRECTION 35,834 100, coo 64,166 640 5349-453-430246-953 WILLOWS CORRECTION 5,067 82,977 77,910 940 5349-453-430246-954 S MEADOWS PHASE 3 76,580 300,coo 223,420 740 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 186,000 186,000 1000 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 130,coo 130,000 1000 5349-453-430249-940 MACHINERY FROM REPLACEMENT 3,796 5,5oo 1,704 310 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 1000 ------------ TOTAL STORM 820,827 ------------- 1,978,592 ------------------------ 1,157,765 590 06.05.2015 16:51 THE CITY OF KALISPELL, MONTANA Page 31 of 36 gb860'I_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 1, 2014 TH RU MAY 313 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 32 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343360-000 SALE OF MAT/AUCTION 92 0 92- 00-. 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 944,910 920,000 24,910- -30 5510-000-343420-000 GARBAGE COLLECTION -BILLED 25,608 20,000 5,608- -280 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,963 2,500 537 210 5510-000-371010-000 INVESTMENT EARNINGS 4,892 3,coo 1,892- -630 TOTAL SOLID WASTE REVENUE ------------ 977,465 ------------- 945,500 ------------ 31,965- ------------ -30 SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 340,982 401,583 60,601 150 5510-460-430840-121 OVERTIME 4,863 5,5oo 637 120 5510-460-430840-153 HEALTH INSURANCE 73,332 85,694 12,362 140 5510-460-430840-155 RETIREMENT 24,664 28,541 3,877 140 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 3,054 9,5oo 6,446 680 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 28,143 35,coo 6,858 200 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 2,862 5,5oo 2,638 480 5510-460-430840-231 GAS & OIL 40,776 59,coo 18,224 310 5510-460-430840-341 ELECTRICITY 1,184 1,900 716 380 5510-460-430840-344 NATURAL GAS 3,154 4,200 1,046 250 5510-460-430840-345 TELEPHONE & COMMUNICATION 623 850 228 270 5510-460-430840-354 CONTRACT SERVICES 4,744 9,coo 4,256 470 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 2,206 5,700 3,494 610 5510-460-430840-366 BUILDING MAINTENANCE 119 2,500 2,381 950 5510-460-430840-373 DUES & TRAINING 345 3,5oo 3,155 900 5510-460-430840-388 MEDICAL SERVICES 785 650 135- -210 5510-460-430840-510 PROPERTY & LIABILITY INS. 9,218 10,600 1,382 130 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 700 6,500 5,800 890 5510-460-430840-521 CENTRAL GARAGE TRANSFER 54,804 59,786 4,982 80 5510-460-430840-522 ADMINISTRATIVE TRANSFER 30,694 33,484 2,790 80 5510-460-430840-528 DATA PROCESSING TRANSFER 7,860 8,574 714 80 5510-460-430840-532 OFFICE RENT 7,838 7,838 0 00-. 5510-460-430840-610 DEBT SERVICE PRINCIPAL 18,833 20,000 1,167 60 5510-460-430840-620 DEBT SERVICE INTEREST 1,171 2,000 829 410 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 18,750 25,000 6,250 250 5510-460-430840-944 VEHICLES (Replacement $) 80,598 123,381 42,783 350 5510-460-430845-224 JANITORIAL SUPPLIES 0 250 250 1000 5510-460-430845-341 ELECTRICITY 1,839 4,000 2,161 540 5510-460-430845-342 WATER 206 Soo 294 590 5510-460-430845-344 NATURAL GAS 3,381 6,500 3,119 480 5510-460-430845-360 REPAIR & MAINT SERVICES 65 3,5oo 3,435 980 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,coo 150,000 1000 TOTAL SOLID WASTE EXPENSE ------------ 767,790 ------------- 1,120,531 ------------------------ 352,741 310 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 33 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 11,325 10,coo 1,325- -130 5160-000-343069-000 HANGER LEASES 11,000 11,000 0 00-. 5160-000-343071-000 HANGAR SITE LEASES 18,034 17,510 524- -30 5160-000-343101-000 FPO LEASE -RED EAGLE AVIATION 14,851 17,734 2,883 160 5160-000-343102-000 GROUND LEASES 12,441 12,078 363- -30 5160-000-343620-000 FUEL TAX 4,192 5,coo 808 160 5160-000-365010-000 MISC REVENUE 2,101 0 2,101- 00-. 5160-000-371010-000 INVESTMENT EARNINGS 816 Soo 316- -630 TOTAL AIRPORT REVENUE 74,760 73,822 938- -10 5160 AIRPORT EXPENSES 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 0 1,coo 1,000 1000 5160-430-430310-341 ELECTRICITY 1,351 1,5oo 149 100 5160-430-430310-345 TELEPHONE 0 180 180 1000 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 33,000 36,000 3,000 80 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 5,395 5,coo 395- -80 5160-430-430310-362 REPAIR & MAINTENANCE 1,096 2,000 904 450 5160-430-430310-390 EQUIPMENT RENTAL 695 2,500 1,805 720 5160-430-430310-510 PROPERTY INSURANCE 6,418 13,000 6,582 510 5160-430-430310-522 ADMINISTRATIVE TRANSFER 5,014 5,469 455 80 5160-430-430310-528 DATA PROCESSING TRANSFER 1,310 1,429 119 80 5160-430-430310-820 DEPRECIATION 0 97,918 97,918 1000 ------------ TOTAL AIRPORT EXPENSES ------------- 54,278 165,996 ------------------------ 111,718 670 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 34 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 HE 124 ENTITLEMENT 70,000 70,000 0 00-. 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 129,553 170,000 40,447 240 6030-000-364030-000 SALE OF MISCELLANEOUS 98 100 3 30 6030-000-371010-000 INVESTMENT EARNINGS 877 1,coo 123 120 6030-000-393000-000 INTERNAL SERVICES -DATA 139,429 155,763 16,334 100 TOTAL INFORMATION TECH REVENUE ------------ 339,956 ------------- 396,863 ------------ 56,907 ------------ 140 INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 125,995 140,566 14,571 100 6030-401-410580-121 OVERTIME 460 2,500 2,040 820 6030-401-410580-153 HEALTH INSURANCE 27,493 32,454 4,961 150 6030-401-410580-155 RETIREMENT 9,580 10,538 958 90 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 62 0 62- 00-. 6030-403-410580-215 COMPUTER SUPPLIES 2,211 2,400 189 80 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 8,280 16,907 8,627 510 6030-403-410580-325 WEBSITE 2,263 3,coo 737 250 6030-403-410580-345 PAGER/PHONE 2,203 2,245 42 20 6030-403-410580-346 SUMMITNET &: ISPS 4,520 6,638 2,118 320 6030-403-410580-353 LASER FICHE MAINTENANCE 4,749 4,200 549- -130 6030-403-410580-354 MAINTENANCE CONTRACTS 20,017 30,435 10,418 340 6030-403-410580-355 LICENSES 16,232 15,300 932- -60 6030-403-410580-357 GRANICUS 7,200 7,200 0 00-. 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 6,487 10,coo 3,513 350 6030-403-410580-373 DUES & TRAINING 1,485 5,950 4,465 750 6030-403-410580-510 INSURANCE 1,817 1,778 39- -20 6030-403-410583-218 TV -Video Equipment & programming 542 3,950 3,408 860 6030-403-410583-354 TV -Video Contract Services 2,100 2,500 400 160 6030-403-410585-229 COPIER,FAX, SUPPLIES 11,301 23,000 11,699 510 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 58,511 80,coo 21,489 270 6030-403-410585-532 COPIER LEASES 15,540 20,000 4,460 220 6030-403-410585-942 Servers - capital contingency 34,475 38,5oo 4,025 100 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,coo 5,000 1000 6030-405-410588-940 COMPUTERS - SWITCHES 12,244 27,244 15,000 550 6030-410-410588-218 COMPUTERS - DPW 1,737 2,725 988 360 6030-413-410588-218 COMPUTERS - POLICE DEPT 22,522 15,755 6,767- -430 6030-416-410588-218 COMPUTERS - FIRE 5,145 5,065 80- -20 6030-436-410588-218 COMPUTERS - PARKS 4,157 5,310 1,153 220 6030-480-410588-218 COMMUNITY DEVELOPMENT 808 900 92 100 TOTAL INFORMATION TECH EXPENSE ------------------------- 410,137 522,060 ------------------------ 111,923 210 06.05.2015 16:51 THE CITY OF KALISPELL, MGNTANA Page 36 of 36 gb8601_pg.php/Job No: 6443 USER: RGW FY16 FINANCIAL REPORT J U LY 'I , 2014 TH RU MAY 31, 2016 91.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 449,238 489,770 40,532 80 6010-000-371010-000 INVESTMENT EARNINGS 1c8 200 92 460 TOTAL CENTRAL GARAGE REVENUE ------------ ------------- 449,346 ------------ 489,970 ------------ 40,624 80 CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 143,486 161,690 18,204 110 6010-410-431330-121 OVERTIME 2,061 2,000 61- -30 6010-410-431330-153 HEALTH INSURANCE 23,490 27,132 3,642 130 6010-410-431330-155 RETIREMENT 10,102 11,383 1,281 110 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 5,318 7,250 1,932 270 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 4,884 7,500 2,616 350 6010-410-431330-230 OIL 15,757 25,000 9,243 370 6010-410-431330-231 GAS 801 3,coo 2,199 730 6010-410-431330-232 VEHICLE PARTS 86,809 91,coo 4,191 50 6010-410-431330-233 TIRES 27,976 35,coo 7,024 200 6010-410-431330-238 FILTERS 4,933 7,700 2,767 360 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 984 2,000 1,016 510 6010-410-431330-341 ELECTRICITY 1,399 1,900 5o1 260 6010-410-431330-344 NATURAL GAS 4,615 7,400 2,785 380 6010-410-431330-354 CONTRACT SERVICES 25,950 31,000 5,050 160 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 1,093 2,000 907 450 6010-410-431330-373 DUES & TRAINING 4,603 6,200 1,597 260 6010-410-431330-388 MEDICAL SERVICES 5o 300 250 830 6010-410-431330-510 INSURANCE 2,347 3,coo 653 220 6010-410-431330-528 INFORMATION TECH TRANSFER 5,240 5,716 476 80 6010-410-431330-944 VEHICLE -SERVICE TRUCK 42,364 45,000 2,636 60 TOTAL CENTRAL GARAGE EXPENSES ------------------------- 414,262 ------------ 483,171 ------------ 68,909 140