Loading...
HomeMy Public PortalAboutRES-CC-2017-06RESOLUTION # 06-2017 A RESOLUTION AMENDING THE FISCAL YEAR 2016/2017 BUDGET WHEREAS, the City of Moab has proposed to amend the 2016/2017 fiscal year budget for the various funds; NOW, THEREFORE BE IT RESOLVED THAT THE 2016/2017 FISCAL YEAR BUDGET SHALL BE AMENDED AS FOLLOWS: Amended Fiscal Year 2016/2017 Budget 1. General Fund 2. Recreation Fund 3. Millcreek Fund 4. Capital Projects Fund 5. Enterprise Water & Sewer Operating 6. Enterprise Water & Sewer Non -Operating 7. Enterprise Water & Sewer Capital FUNDS Amended Revenue ($10,531,341) ($ 590,928) ( $7,195) ($2,596,159) ($1,757,996) ($12,112,400) 201.6/2017 Fiscal Year Budget Amendments Amended Expenditures $ 10,531,341 $ 590,928 $ 7,195 $ 2,596,159 $ 2,160,132 $ 14,270,455 r+tt(milt Namt. AdiLhlment Amount General Fund Revenue 10-31-300 10-31-400 10-31-500 10-31-600 10-31-700 10-31-800 10-3 2-210 10-32-211 10-32-213 10-34-711 10-34-717 10-34-721 General Fund Genera! Government 10-416-11 10-416-29 Administrative 10-414-10 Sales & Use Taxes Franchise Taxes Highway Taxes Transient Room Taxes Resort Community Taxes Energy Taxes Building Permits - City Building Permits - Commercial Plan check fees MRAC Fitness Admissions MRAC - Showers MRAC Admissions Aquat/Fitn Total Revenue Salary Differential Rent of Property or Equipment Salaries and Wages (121,000.00) 36,804.00 (61, 800.00) (107,000.00) (371,800.00) 62,682.00 (10,000.00) (25,000.00) (2,300.00) (2,200.00) (7,000.00) (500.00) {609,114.00) (189,781.00) 1,800.00 107,000.00 Resolution #06-2017 ['age l or 5 10-414-10 Salaries and Wages $ 1,000.00 10-414-10 Salaries and Wages $ 50,750.00 10-414-13 Employee Benefits $ 19,440.00 10-414-13 Employee Benefits $ 18,500.00 10-414-16 Unemployment $ 4,000.00 10-414-22 Public Notices $ 8,000.00 Recorder 10-415-10 Salaries and Wages $ 13,508.00 10-415-13 Employee Benefits $ 2,702.00 10-415-15 Overtime $ 2,000.00 10-415-22 Public Notices $ 3,000.00 10-415-31 Professional & Technical $ 20,000.00 Engineering 10-419-31 Professional & Technical $ 10,000.00 10-419-31.1 Plan Review Services $ 20,000.00 Treasurer 10-420-10 Salaries and Wages $ 7,370.00 10-420-13 Employee Benefits $ 1,480.00 Police 10-421-10 Salaries and Wages $ 48,500.00 10-421-13 Employee Benefits $ 9,700.00 Attorney Services 10-422-31 Professional & Technical $ 60,000.00 Animal Control 10-426-10 Salaries and Wages $ 6,570.00 10-426-13 Employee Benefits $ 1,314.00 Streets 10-440-10 Salaries and Wages $ 21,745.00 10-440-13 Employee Benefits $ 4,349.00 10-440-46 Special Departmental Supplies $ 6,000.00 Facilities 10-443-10 Salaries and Wages $ 12,000.00 10-443-13 Employee Benefits $ 2,400.00 Parks 10-451-10 Salaries and Wages $ 28,000.00 10-451-13 Employee Benefits $ 5,600.00 Aquatic Center 10-452-08 Maintenance Salaries $ 17,000.00 10-452-09 Lifeguard Salaries $ 20,000.00 10-452-10 Salaries and Wages $ 9,700.00 10-452-13 Employee Benefits $ 5,000.00 Planning 10-418-10 Salaries and Wages $ 2,500.00 10-418-13 Employee Benefits $ 500.00 Transfers Resolution #06-2017 Page 2 of 5 10-480-61 10-480-86 Recreation Fund Revenue 23-33-562 Expenses 23-640-10 23-640-10 23-640-11 23-640-13 23-640-13 23-800-10 23-800-10 23-800-13 23-800-13 Millcreek Project Fund Transfer to Capital Projects Fund Contribution to Recreation Fund Total Expenses City of Moab Contribution $ Total Revenue $ Salaries and Wages Salaries and Wages Salary Differential Employee Benefits Employee Benefits Salaries and Wages Salaries and Wages Employee Benefits Employee Benefits Total Expenses Revenue 28-33-579 28-39-210 t:xponse , 28-400-89 Capital Projects Fund Future Grants Beginning Fund Balance Total Revenue Trails ($3,597) ($3,598) ($7,195) $7,195 Total Expenses $7,195 209,949.00 37,518.00 609,114.00 (37,518.00) (37,518.00) 4,438.00 11,034.00 (14,148.00) 888.00 10,756.00 2,300.00 11,034.00 460.00 10,756.00 37,518.00 Revenue 41-36-124 41-36-224 41-39-222 41-39-561 1xpttts ti 41-791-50 41-440-83 41-750-46 41-780-25 41-770-31 Resolution #06-21117 Grants and Donations UDOT Aid Project Transfer from General Fund Cap Projects Beg Fund Balance Total Revenue Police Equipment Streets Equipment Recreation/Parks Equip Trail & Bridge Improvements Muni Bldg Project $ (10,000.00) $ 180,000.00 $ (209,949.00) $ (295,051.00) $ (335,000.00) Pag 3 0l'5 10,000.00 (32,000.00) 32,000.00 175,000.00 150,000.00 Water & Sewer Fund Operating Revenue 51-37-260 51-56-900 51-57-440 Non -operating Revenue 51-39-535 51-39-535 51-56-250 51-56-200 Operating Expenses 51-500-10 51-500-11 51-500-13 51-500-46 51-600-10 51-600-13 51-600-31 51-600-46 51-610-10 51-610-13 51-610-31 Capital Expenses Projects: Impact Fee Project Impact Fee Impact Fee Impact Fee Impact Fee Impact Fee Impact Fee Impact Fee Impact Fee Project Project Project Project Project Project Project Project Sewer Project Direct Purchases: Total Expenses $ 335,000.00 Water connections Sundry Revenue Sewer Connections Total Operating Revenue W/S Beg Fund Balance W/S Beg Fund Balance WWTP Agency ILA Contribution Sewer WRF Financing Total Non -Operating Revenue Salaries and Wages Salary Differential Employee Benefits Special Departmental Sup Salaries and Wages Employee Benefits Professional & Technical Special Departmental Sup Salaries and Wages Employee Benefits Professional & Technical Total Operating Impact Fee/Rate Study (25,000.00) (60,000.00) (12,636.00) (97,636.00) $ (60,500.00) $ (129,500.00) $ (800,000.00) $ (6,650,000.00) $ (7,640,000.00) $ 5,300.00 $ (23,360.00) $ 1,060.00 $ 5,500.00 $ 8,000.00 $ 1,600.00 $ 80,000.00 $ 60,000.00 $ 6,165.00 $ 1,235.00 $ 12,636.00 Expenses $ 176,196.00 South Trunk Line Planning & Design WRF Design & Permitting WRF Construction WRF Construction Administration WRF Site Prep Sanitary Sewer Master Plan Water Tank Design & Construction Water Storage & dist Master Plan WWTP Effluent Pipe Replacement Total Capital Projects $ 20,000.00 $ (200,000.00) $ (3,400,000.00) $ 9,250,000.00 $ 660,000.00 $ 1,150,000.00 $ 20,000.00 $ (1,030,000.00) $ 30,000.00 $ (50,000.00) $ 6,450,000.00 Resolution 006-2017 Iltute4or5 1643 - Meters Water Meters $ 40,000.00 1653 - Manhole Replacement Project Sewer Manhole Replacement $ 30,000.00 1661.2 - Equipment - water Compressors $ 40,000.00 Total Direct Purchases $ 110,000.00 Storm Water Utility Fund Capital Expenses Projects: Minor Storm Water Projects Storm Water Master Plan Minor Storm Water Projects Storm Water Master Plan Total Capital Projects {25,000.00) 25,000.00 PASSED AND ADOPTED in open Council by a majority vote of the Governing Body of the City of Moab this 28th day of February, 2017. David L. Sakrison Mayor EST: Rachel E. Stenta City of Moab Resolution fiO(-2O17 Page 5 or5 MOAB CITY CORPORATION Mld-Year Budget Opening 10 10 General Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used Change In Net Position Revenue: Taxes 31300 SALES & USE TAXES (1,223,395) (1,820,467) 67.20% 31400 FRANCHISE TAXES (81,192) (153,351) 52.95% 31500 HIGHWAY TAXES (496,042) (701,696) 70.69% 31600 TRANSIENT ROOM TAXES (883,620) (1,082,140) 81.65% 31700 RESORT COMMUNITY TAXES (2,543,265) (3,474,676) 73.19% 31800 ENERGY TAXES (110,196) (168,552) 65.38% 38722 ANIMAL SHELTER SALES TAX - Total Taxes (5,337,710) (7,400,882) 72.12% Licenses and permits 32110 BEER LICENSES (760) (8,700) 8.74% 32160 FLAT BUSINESS LICENSES (30,281) (48,000) 63.09% 32209 SIGN PERMITS (1,057) (1,200) 88.08% 32210 BUILDING PERMITS - CITY (59,563) (53,000) 112.38% 32211 BUILDING PERMITS - COMMERCIAL (66,229) (42,000) 157.69% 32212 1% BLDG PERMIT CHARGE 693 (950)-72.95% 32213 PLAN CHECK FEES (8,057) (5,000) 161.14% 32290 OTHER LICENSES & PERMITS (50) (500) 10.00% Total Licenses and permits (165,304) (159,350) 103.74% Intergovernmental revenue 33580 STATE LIQUOR FUND ALLOTMENT (27,209) (28,000) 97.18% 36972 HOMELAND SECURITY GRANT - - - 36973 MISC STATE GRANTS (2,396) (25,000) 9.58% 36974 SAN JUAN CO. CONTRIBUTION - (5,000) 37100 GRAND COUNTY CONTRIBUTION (59,585) (72,301) 82.41% 37110 GCRSSD RECREATION CTR CONTRIBUTION - (25,000) - Total Intergovernmental revenue (89,190) (155,301) 57.43% Charges for services 34001 SPECIAL SERVICES BY CITY DEPTS (8,134) (22,699) 35.83% 34005 POLICE SERVICES/SHIFTS (30,000) - 34020 RESTITUTION PAID (100) - - 34200 GARBAGE BILLING 1 COLLECTION (27,345) (45,000) 60.77% 34430 REFUSE COLLECTION CHARGES (544,693) (900,000) 60.52% 34510 FILM COMM - SPECIAL EVENT FEES - - 34730 ANIMAL SHELTER FEES (4,090) (8,500) 48.12% 34740 ANIMAL SHELTER INTERLOCAL (9,334) (14,500) 64.37% Total Charges for services (593,696) (1,020,699) 58.17% MRAC 34711 MRAC - FITNESS ADMISSIONS (4,492) (4,000) 112.30% 34712 MRAC - FITNESS MEMBERSHIPS (19,579) (23,000) 85.13% 34713 MRAC - CITY EMPLOYEES (224) (700) 32.00% 34714 MRAC - SILVER SNEAKERS MEMBERSHIPS (2,993) (10,000) 29.93% 34715 MRAC - SWIM TEAM (1,215) (3,000) 40.50% 34716 MRAC - AQUATIC SPORTS - - - 34717 MRAC - SHOWERS (20,480) (35,000) 58.51% 34718 MRAC - CASH OVER/SHORT 44 - 34719 MRAC - EMPLOYEE WELLNESS DISCOUNT - - - 34720 MRAC - ADMISSIONS/AQUATIC (33,749) (90,000) 37.50% 34721 MRAC - ADMISSIONS/AQUAT & FITNESS (1,774) (1,500) 118.27% 34722 MRAC - RETAIL (4,204) (7,500) 56.05% 34723 MRAC - PROGRAM FEES/ AQUATIC (5,725) (15,000) 38.17% 34723.1 MRAC PRIVATE SWIM LESSONS - 34724 MRAC - PROGRAM FEES/FITNESS (7,034) (7,500) 93.79% 34725 MRAC - CHILD CARE FEES (550) (2,000) 27.50% 34726 MRAC - MEMBERSHIPS/AQUATIC (16,755) (37,500) 44.68% 34727 MRAC - MEMBERSHIPS/AQUAT & FITNESS (48,599) (70,000) 69.43% 34728 MRAC - RENTAL FEES (2,620) (5,000) 52.40% 34729 MRAC - SPECIAL EVENT FEES - (1,000) - Total MRAC (169,949) (312,700) 54.35% Fines and forfeitures 35010 FINES, FORFEITURES & PENALTIES (43,668) (80,000) 54.59% INTENDED FOR MANAGEMENT USE ONLY Page 1 Page 6 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 10 10 General Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 35050 A/R 30-DAY PENALTIES 37200 FORFEITURES (3,000) Total Fines and forfeitures (43,668) (83,000) 52.61% Interest 36110 INTEREST INCOME (11,141) (30,000) 37.14% 36111 INTEREST PTIF (9,052) Total interest (20,193) (30,000) 67.31% Miscellaneous revenue 36160 PROCEEDS FROM LT DEBT - - - 36200 PARK RENTALS (4,401) (10,000) 44.01% 36220 FILM COMM - SPONSOR/DONATION 36226 FILM COM. - EQUIP RENTAL FEES (90) - 36400 SALE OF REAUPERS. PROPERTY (8) (5,000) 0.16% 36401 INSURANCE REBATE (14,983) (10,000) 149.83% 36420 EMPLOYEE MEDICAL CAFE RESIDUAL (50,136) 36450 SIDEWALK PERMITS 36500 SALE OF MATERIALS & SUPPLIES 36900 OTHER (5) (500) 1.00% 36901 DONATIONS (1,500) - 36902 REBATES - (500) 36940 REAL ESTATE TRANSFER ASSESSMNT 36950 Unrealized gain/loss on bonds 36970 INSURANCE INCOME (9,268) 36975 SAFETY GRANT - (2,513) - 38260 ANIMAL DEPOSITS NON -OPERATING (175) (1,500) 11.67% 38721 ANIMAL SHELTER - SUNDRY RESALE - - Total Miscellaneous revenue (30,430) (80,149) 37.97% Contributions and transfers 39920 OVERHEAD PAID FROM SWD ENT FND (4,000) 39930 OVERHEAD PAID FROM ENT. FUND (369,146) 39940 GENERAL FUND BEG. BALANCE (307,000) 39950 TRANSFER FROM OTHER FUNDS - Total Contributions and transfers (680,146) Total Revenue: (6,450,140) (9,922,227) 65.01% Expenditures: General government General 41610 General SALARIES & WAGES 41611 General SALARY DIFFERENTIAL (SURVEY) 189,781 41613 General EMPLOYEE BENEFITS - 41621 General SUBSCRIPTIONS & MEMBERSHIPS 41622 General PUBLIC NOTICES - 41623 General TRAVEL/FOOD 165 5,300 3.11% 41624 General OFFICE EXPENSE & SUPPLIES 12 100 12.00% 41625 General EQUIP./SUPPLIES & MAINTENANCE 400 41626 General BLOG/GRDS- SUPPL & MAINTENANCE 41627 General UTILITIES 21,860 40,000 54.65% 41628 General TELEPHONE/INTERNET 12,835 38,735 33.14% 41629 General RENT OF PROPERTY OR EQUIPMENT 1,212 2,000 60.60% 41630 General MONTHLY FUEL - GASCARD 312 1,300 24.00% 41631 General PROFESSIONAL & TECHNICAL 14,000 41635 General SHIPPING/FREIGHT 2,715 - - 41646 General SPECIAL DEPARTMENTAL SUPPLIES 346 400 86.50% 41651 General INSURANCE 23 127,000 0.02% 41674 General MACHINERY & EQUIPMENT - - Total General 39 480 419,016 9.42% Executive and Central Staff 41310 Exec SALARIES & WAGES 32,383 54,300 59.64% 41313 Exec EMPLOYEE BENEFITS 12,249 25,488 48.06% 41321 Exec SUBSCRIPTIONS & MEMBERSHIPS - 6,200 41323 Exec TRAVELTOOD 6,015 7,500 80.20% 41324 Exec OFFICE EXPENSE & SUPPLIES 14 800 1.75% 41325 Exec EQUIP/SUPPLIES & MAINTENANCE 500 - INTENDED FOR MANAGEMENT USE ONLY Page 2 Page 7 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 10 10 General Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 41328 Exec TELEPHONE (119) 2,000 -5.95% 41331 Exec PROFESSIONAL/TECHNICAL SERVICE 2,000 5,000 40.00°k 41333 Exec EDUCATION 385 5,000 7.70% 41335 Exec SHIPPINGIFREIGHT 5 - 41346 Exec SPECIAL DEPARTMENTAL SUPPLIES 56 2,000 2.80% 41374 Exec MACHINERY & EQUIPMENT - - Total Executive and Central Staff 52,988 108,788 48.71 % Administrative 41410 Admin SALARIES & WAGES 197,709 171,851 115.05% 41413 Admin EMPLOYEE BENEFITS 42,453 77,916 54.49% 41415 Admin OVERTIME 27 300 9.00% 41416 Admin UNEMPLOYMENT 3,968 4,000 99.20% 41417 Admin EMPLOYEE BONUS PROGRAM 999 6,000 16.65% 1 41421 Admin SUBSCRIPTIONS & MEMBERSHIPS 1,500 1,300 115.38% 41422 Admin PUBLIC NOTICES 5,167 41423 Admin TRAVELWOOD 3,230 7,700 41.95% 41424 Admin OFFICE EXPENSE & SUPPLIES 282 2,000 14.10% 41425 Admin EQUIP/SUPPLIES & MAINTENANCE 300 - 41428 Admin TELEPHONE 567 - 41430 Admin MONTHLY FUEL - GASCARD - - - 41431 Admin PROFESSIONAL/TECH. SERVICE 23,433 94,416 24.82% 41433 Admin EDUCATION 990 2,000 49.50% 41435 Admin SHIPPINGIFREIGHT 171 - - 41446 Admin SPECIAL DEPARTMENTAL SUPPLIES 735 400 183.75% 41474 Admin MACHINERY & EQUIPMENT 2,000 41475 Admin GRANT EXPENSES 500 Total Administrative 281 231 370 683 75.87% Recorder 41510 Recorder SALARIES & WAGES 156,368 290,577 53.81% I 41513 Recorder EMPLOYEE BENEFITS 76,573 145,565 52.60% 41515 Recorder OVERTIME 2,681 2,000 134.05% 41521 Recorder SUBSCRIPTIONS/MEMBERSHIPS 229 7,022 3.26% 41522 Recorder PUBLIC NOTICES 5,067 5,500 92.13% 41523 Recorder TRAVELIFOOD 3,803 5,672 67.05% 41524 Recorder OFFICE EXPENSE & SUPPLIES 3,272 5,500 59.49% 41525 Recorder EQUIP./SUPPLIES & MAINTENANCE - - 41528 Recorder TELEPHONE 135 - 41531 Recorder PROFESSIONAL & TECH. SERVICES 24,297 56,302 43.15% 41533 Recorder EDUCATION 3,904 6,700 58.27% 41535 Recorder SHIPPINGIFREIGHT 184 - 41546 Recorder SPECIAL DEPARTMENTAL SUPPLIES 3,452 4,250 81.22% 41550 Recorder COPIER SUPPLIES 6,499 13,486 48.19% 41574 Recorder MACHINERY & EQUIPMENT - 415810 LEASE PRINCIPAL 415820 LEASE INTEREST Total Recorder 286,464 542,574 52.80% Information Technology 43010 Info Tech SALARIES & WAGES 43013 Info Tech EMPLOYEE BENEFITS - - 43024 Info Tech OFFICE EXPENSE & SUPPLIES 1,332 4,000 33.30% 43031 Info Tech PROF & TECH SERVICES 41,503 103,295 40.18% 43031.1 Info Tech WEBSITE 540 25,000 2.16% 43031.2 Info Tech GOOGLE FOR GOVERNMENT 3,294 15,000 21.96% 43031.3 Info Tech SECURITY APPLIANCE 4,323 5,000 86.46% 43031.4 Info Tech WIFI - ACCESS LICENSES 1,855 2,000 92.75% 43031.5 Info Tech ANTIVIRUS 1,592 5,000 31.84% 43046 Info Tech SPECIAL DEPT SUPPLIES 2,159 5,000 43.18% 43074 Info Tech MACHINERY & EQUIPMENT 18,655 21,000 88.83% Total Information Technology 75 253 185,295 40.61% Elections 41722 Election PUBLIC NOTICES 41723 Election TRAVEL 41729 Election RENTAL - VOTING POLLS/PAGER 41731 Election PROFESSIONAL/TECH - PRIMARY INTENDED FOR MANAGEMENT USE ONLY Page 3 Page 8 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 10 10 General Fund - 07/01/2016 to 02103/2017 66.67% of the fiscal year has expired 41732 Election 41733 Election 41734 Election 41735 Election 41736 Election 41737 Election 41746 Election 41747 Election 41774 Election Total Elections PROFESSIONAUTECH- GENERAL EDUCATION - INITIATIVE EDUCATION - PRIMARY/GENERAL CARR PRINTING EXPENSES ELECTION DINNERS - PRIMARY ELECTION DINNERS - GENERAL SPECIAL DEPT'L - PRIMARY SPECIAL DEPT'L - GENERAL MACHINERY & EQUIPMENT Engineering 41910 Engineer SALARIES & WAGES 41913 Engineer BENEFITS 41915 Engineer OVERTIME 41921 Engineer SUBSCRIPTIONS & MEMBERSHIPS 41922 Engineer PUBLIC NOTICES 41923 Engineer TRAVEL 41924 Engineer OFFICE EXPENSE & SUPPLIES 41925 Engineer EQUIP/SUPPLIES & MAINTENANCE 41928 Engineer TELEPHONE 41930 Engineer MONTHLY FUEL - GASCARD 41931 Engineer PROFESSIONAL & TECH. SERVICES 41931.1 Engineer PLAN REVIEW SERVICES 41933 Engineer EDUCATION 41935 Engineer SHIPPINGIFREIGHT 41946 Engineer SPECIAL DEPTARTMENTAL SUPPLIES 41974 Engineer MACHINERY & EQUIPMENT Total Engineering Treasurer 42010 Treasurer SALARIES & WAGES 42013 Treasurer EMPLOYEE BENEFITS 42015 Treasurer OVERTIME 42021 Treasurer SUBSCRIPTIONS & MEMBERSHIPS 42023 Treasurer TRAVEL 42024 Treasurer OFFICE EXPENSE & SUPPLIES 42025 Treasurer EQUIPMENT SUPPL. & MAINTENANCE 42028 Treasurer TELEPHONE 42031 Treasurer PROFESSIONAL & TECH. SERVICES 42033 Treasurer EDUCATION 42035 Treasurer SHIPPINGIFREIGHT 42036 Treasurer BANK HANDLING CHARGES 42046 Treasurer SPECIAL DEPARTMENTAL SUPPLIES 42051 Treasurer INSURANCE 42063 Treasurer CASH OVER & SHORT 42074 Treasurer MACHINERY & EQUIPMENT Total Treasurer Total General government Public safety Police 42110 Police 42111 Police 42113 Police 42114 Police 42115 Police 42116 Police 42118 Police 42121 Police 42123 Police 42124 Police 42125 Police 42126 Police 42128 Police 42129 Police 42130 Police SALARIES & WAGES MOVIE\SECURITY WAGES EMPLOYEE BENEFITS OTHER BENEFITS- U/ALLOWANCES OVERTIME UNEMPLOYMENT OFFICER EQUIP/PAYROLL DEDUCT SUBSCRIPTIONS & MEMBERSHIPS TRAVELWOOD OFFICE EXPENSE & SUPPLIES EQUIPMENT-SUPPL. & MAINTENANCE BLDG/GRDS-SUPPL. & MAINTENANCE TELEPHONE RENT OF PROPERTY OR EQUIPMENT MONTHLY FUEL - GASCARD INTENDED FOR MANAGEMENT USE ONLY Page 4 Page 9 of 32 2017 YTD Actual 2017 Approved Budget 123,190 266,455 62,564 140,170 5,000 4,405 14,500 1,923 6,200 198 4,500 589 44 17,867 50,000 19,559 40,000 405 5,500 13 207 5,000 230,964 537,325 61,421 113,192 36,990 62,577 206 250 1,785 700 100 1,500 4,696 12,425 200 (143) - 1,775 7,000 1,000 - 200 11,158 26,000 1,090 2,700 1,376 1,750 Percent Used 46.23% 44.63% 30.38% 31.02% 4.40% 35.73% 48.90% 7.36% 4.14% 42.98% 54.26% 59.11% 82.40% 255.00% 6.67% 37.79% 25.36% 42.92% 40.37% 78.63% 120 454 229 494 1,086,834 2 393 175 591,087 371,240 7,560 42,090 5,635 7,054 4,185 10,155 3,064 29,620 11 8,665 2,690 22,809 52.49% 45.41 % 928,589 30,000 674,716 16,680 76,500 15,406 25,363 11,992 58,605 10,000 18,000 6,666 64,500 63.65% 55.02% 45.32% 55.02% 27.16% 40.04% 25.55% 50.54% 0.11% 48.14% 40.35% 35.36% 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 10 10 General Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 42131 Police PROFESSIONAL & TECH. SERVICES 36,690 5,275 42133 Police EDUCATION 5,379 19,710 42135 Police SHIPPINGIFREIGHT 347 - 42136 Police DISPATCH SERVICES 40,358 76,000 42137 Police DRUG ENFORCEMENT - 42146 Police SPECIAL DEPARTMENTAL SUPPLIES 12,669 29,227 43.35% 42169 Police Lease payments - - 42172 Police SPECIAL EVENTS - 42173 Police D.A.R.E. - EQUIP. & SUPPLIES - 2,000 - 42174 Police MACHINERY & EQUIPMENT 147 - 421810 LEASE PRINCIPAL - 421820 LEASE INTEREST Total Police 1,201,455 2,069,229 58.06% 695.55% 27.29% 53.10% Attorney 42231 Attomey PROFESSIONAL & TECH. SERVICES 88,261 85,000 103.84% 42231.1 Attomey PUBLIC DEFENDER 12,000 24,000 50.00% 42231.2 Attomey PROSECUTION SERVICES 15,000 36,000 41.67% Total Attorney 115,261 145,000 79.49% Narcotics Task Force 42310 Narcotics SALARIES & WAGES 42313 Narcotics EMPLOYEE BENEFITS 42314 Narcotics OTHER BENEFITS- U/ALLOWANCES - 42315 Narcotics OVERTIME - 42321 Narcotics SUBSCRIPTIONS/MEMBERSHIPS 42323 Narcotics TRAVEL 42324 Narcotics OFFICE SUPPLIES 42325 Narcotics EQUIP/SUPPLIES & MAINTENANCE 42328 Narcotics TELEPHONE 42330 Narcotics MONTHLY FUEL - GASCARD 42331 Narcotics PROFESSIONAL/TECHNICAL SERVICE 42333 Narcotics EDUCATION 42335 Narcotics SHIPPINGIFREIGHT 42346 Narcotics SPECIAL DEPARTMENTAL SUPPLIES 42369 Narcotics LEASE PAYMENT 42370 Narcotics FORFEITURES 42374 Narcotics MACHINERY & EQUIPMENT Total Narcotics Task Force Beer Tax Funds Eligible Expenses 42510 Beer Tax SALARIES & WAGES 1,273 5,300 24.02% 42513 Beer Tax EMPLOYEE BENEFITS 1,040 5,700 18.25% 42531 Beer Tax PROFESSIONAL & TECH. SERVICES 8,000 - 42546 Beer Tax SPECIAL DEPARTMENTAL SUPPLIES - 42574 Beer Tax EQUIPMENT 9,000 Total Beer Tax Funds Eligible Expenses 2 313 28 000 8.26% Inspections 42431 Inspection PROFESSIONAL & TECH. SERVICES 62,500 125,000 50.00% 42475 Inspection SPECIAL PROJECTS - - Total Inspections 62,500 125 000 50.00% Animal control 42610 Animal Ctl SALARIES & WAGES 64,571 109,527 58.95% 42613 Animal Ctl EMPLOYEE BENEFITS 47,158 80,795 58.37% 42614 Animal Ctl OTHER BENEFIT - U/ALLOWANCES 1,600 2,880 55.56% 42615 Animal Ctl OVERTIME 5,696 11,500 49.53% 42621 Animal Ctl SUBSCRIPTIONS & MEMBERSHIPS 253 1,660 15.24% 42623 Animal Ctl TRAVELIFOOD 50 1,770 2.82% 42624 Animal Ctl OFFICE EXPENSE & SUPPLIES (66) 1,500 -4.40% 42625 Animal Ctl EQUIPMENT-SUPPL. & MAINTENANCE 4,076 15,500 26.30% 42628 Animal Ctl TELEPHONE 1,957 4,275 45.78% 42630 Animal Ctl MONTHLY FUEL - GASCARD 2,659 9,100 29.22% 42631 Animal Ctl PROFESSIONAL & TECH. SERVICES 374 5,900 6.34% 42633 Animal Ctl EDUCATION 250 1,600 15.63% 42635 Animal Ctl SHIPPINGIFREIGHT 7 - 42646 Animal Ctl SPECIAL DEPARTMENTAL SUPPLIES 3,800 INTENDED FOR MANAGEMENT USE ONLY Page 5 Page 10 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 10 10 General Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 42669 Animal Ctl Lease payments 42674 Animal Ctl MACHINERY & EQUIPMENT 1,700 Total Animal control 128,585 251 507 51.13% Animal Shelter 42710 Animal Shltr SALARIES & WAGES 42713 Animal Shltr EMPLOYEE BENEFITS 42714 Animal Shltr OTHER BENEFITS- U/ALLOWANCES 42715 Animal Shltr OVERTIME 42722 Animal Shltr PUBLIC NOTICES 42724 Animal Shltr OFFICE EXPENSE & SUPPLIES 42725 Animal Shltr EQUIP/SUPPLIES & MAINTENANCE 42726 Animal Shltr BLDG/GRDS-SUPPLIES & MAINT. - 42727 Animal Shltr UTILITIES 187 42728 Animal Shltr TELEPHONE - 42730 Animal Shltr MONTHLY FUEL - GASCARD 42731 Animal Shltr PROFESSIONAUTECHNICAL SERVICE 42733 Animal Shltr EDUCATION 42735 Animal Shltr SHIPPINGIFREIGHT 42746 Animal Shltr SPECIAL DEPARTMENTAL SUPPLIES 42769 Animal Shltr Lease payments 42774 Animal Shltr MACHINERY & EQUIPMENT Total Animal Shelter 187 Total Public safety 1,510,301 2,618,736 57.67% Facilities Streets 44010 Streets SALARIES & WAGES 159,690 351,769 45.40% 44013 Streets EMPLOYEE BENEFITS 122,993 260,947 47.13% 44015 Streets OVERTIME 3,635 8,200 44.33% 44016 Streets UNEMPLOYMENT - 390 - 44021 Streets SUBSCRIPTIONS & MEMBERSHIPS (55) 2,030 -2.71% 44022 Streets PUBLIC NOTICES - - - 44023 Streets TRAVEL 2,595 6,300 41.19% 44024 Streets OFFICE EXPENSE & SUPPLIES 2,178 5,500 39.60% 44025 Streets EQUIPMENT-SUPPL. & MAINTENANCE 15,380 25,000 61.52% 44026 Streets BLDG/GRDS-SUPPL. & MAINTENANCE 19,276 28,700 67.16% 44027 Streets UTILITIES 8,633 18,100 47.70% 44028 Streets TELEPHONE 2,182 4,700 46.43% 44029 Streets RENT OF PROPERTY OR EQUIPMENT 1,200 2,900 41.38% 44030 Streets MONTHLY FUEL - GASCARD 11,959 35,250 33.93% 44031 Streets PROFESSIONAL & TECH. SERVICES 6,014 11,500 52.30% 44033 Streets EDUCATION 820 3,250 25.23% 44035 Streets SHIPPINGIFREIGHT 124 500 24.80% 44042 Streets STREET LIGHTS 46,238 99,500 46.47% 44046 Streets SPECIAL DEPARTMENTAL SUPPLIES 14,923 28,200 52.92% 44069 Streets Lease payments - - - 44074 Streets MACHINERY & EQUIPMENT 1,625 4,000 40.63% 44077 Street SPECIAL PROJECTS - - 440810 Street LEASE PRINCIPAL 440820 Streets LEASE INTEREST Total Streets 419,410 896 736 46.77% Facilities 44310 Facilities SALARIES & WAGES 64,706 159,829 40.48% 44313 Facilities EMPLOYEE BENEFITS 37,533 125,330 29.95% 44315 Facilities OVERTIME 1,804 - 44326 Facilities BLDG/GRDS-SUPPL & MAINT 2,948 9,500 31.03% 44326.1 Facilities - CITY CENTER - 44326.2 Facilities - MARC 44326.3 Facilities - CENTER STREET GYM 44327 Facilities UTILITIES Total Facilities 106,991 294659 36.31% Safety 44121 Safety SUBSCRIPTIONS & MEMBERSHIPS 440 3,895 11.30% 44123 Safety TRAVEL - 2,195 - INTENDED FOR MANAGEMENT USE ONLY Page 6 Page 11 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid Year Budget Opening 10 10 General Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 44125 Safety EQUIP/SUPPLIES & MAINTENANCE 734 8,405 8.73% 44128 Safety TELEPHONE 32 500 6.40% 44131 Safety PROFESSIONAL & TECH. SERVICES 9,937 1,500 662.47% 44133 Safety EDUCATION - 4,485 - 44135 Safety SHIPPINGIFREIGHT 51 600 8.50% 44146 Safety SPECIAL DEPARTMENTAL SUPPLIES 11,296 28,400 39.77% 1 44174 Safety MACHINERY & EQUIPMENT - - - 44175 Safety SAFETY EQUIPMENT Total Safety 22 490 49 980 45.00% Vehicle Maintenance 44410 Vehicle Maintenance SALARIES & WAGES 50,174 85,876 58.43% 44413 Vehicle Maintenance - EMPLOYEE BENEFITS 39,733 70,751 56.16% 44415 Vehicle Maintenance OVERTIME 75 - 44425 Vehicle Maintenance EQUIP/SUPPL & MAINT 210 Total Vehicle Maintenance 90,192 156,627 57.58% Sanitation 44231 Sanitation PROFESSIONAL & TECH. SERVICES 621,512 900,000 69.06% Total Sanitation 621,512 900 000 69.06% Total Facilities 1,260,595 2,298,002 54.86% Parks, recreation, and public property Parks Parks O&M 45110 Parks O&M SALARIES & WAGES 155,662 286,185 54.39% 45113 Parks O&M EMPLOYEE BENEFITS 96,543 209,350 46.12% 45115 Parks O&M OVERTIME 1,073 3,700 29.00% 45121 Parks O&M SUBSCRIPTIONS & MEMBERSHIPS 95 750 12.67% 45123 Parks O&M TRAVEL 150 1,500 10.00% 45124 Parks O&M OFFICE EXPENSE & SUPPLIES 45125 Parks O&M EQUIPMENT-SUPPL. & MAINTENANCE 6,561 13,000 50.47% 45126 Parks O&M BLDG/GRDS-SUPPL. & MAINTENANCE 4,508 21,000 21.47% 45127 Parks O&M UTILITIES 28,868 57,184 50.48% 45128 Parks O&M TELEPHONE 328 2,350 13.96% 45129 Parks O&M RENTALS - 750 - 45130 Parks O&M MONTHLY FUEL - GASCARD 7,659 20,000 38.30% 45131 Parks O&M PROFESSIONAL & TECH. SERVICES 816 14,500 5.63% 45133 Parks O&M EDUCATION 710 2,000 35.50% 45135 Parks O&M SHIPPING/FREIGHT 750 45146 Parks 0&M SPECIAL DEPARTMENTAL SUPPLIES 6,476 14,500 44.66% 45168 Parks O&M TRAIL MAINTENANCE - 45169 Parks O&M Lease payments - - - 45173 Parks O&M PARK IMPROVEMENTS 886 3,500 25.31% 45174 Parks O&M MACHINERY & EQUIPMENT - 1,500 Total Parks O&M 310335 652 519 47.56% Parks MGMT 45010 Parks MGMT SALARIES & WAGES 10,000 45013 Parks MGMT EMPLOYEE BENEFITS 765 45015 Parks MGMT OVERTIME 45021 Parks MGMT SUBSCRIPTIONS & MEMBERSHIPS 45023 Parks MGMT TRAVEL 250 45024 Parks MGMT OFFICE EXPENSE & SUPPLIES - 45031 Parks MGMT PROFESSIONAL & TECH 10,000 Total Parks MGMT 250 20 765 1.20% Total Parks 310,585 673,284 46.13% Swimming Pool 45208 MRAC MAINTENANCE SALARIES 44,660 60,387 73.96% 45209 MRAC LIFEGUARD SALARIES 92,036 134,457 68.45% 45210 MRAC SALARIES & WAGES 108,975 204,243 53.36% 45211 MRAC AQUATIC PROGRAM SALARIES 8,719 12,726 68.51% 45212 MRAC FITNESS PROGRAM SALARIES 6,615 11,338 58.34% 45213 MRAC EMPLOYEE BENEFITS 58,497 109,760 53.30% 45215 MRAC OVERTIME 238 750 31.73% 45216 MRAC UNEMPLOYMENT - - INTENDED FOR MANAGEMENT USE ONLY Page 7 Page 12 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid Year Budget Opening 10 10 General Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 45221 MRAC SUBSCRIPTIONS & MEMBERSHIPS (29) 340 -8.53% 45222 MRAC LEGAL NOTICES/ADVERTISING 7,050 10,000 70.50% 45223 MRAC TRAVEL 530 2,520 21.03% 45224 MRAC OFFICE EXPENSE & SUPPLIES 1,305 4,500 29.00% 45225 MRAC EQUIPMENTSUPPL. & MAINTENANCE 4,867 15,000 32.45% 45226 MRAC BLDG/GRDS-SUPPL. & MAINTENANCE 10,585 30,500 34.70% 45227 MRAC UTILITIES 41,449 101,000 41.04% 45228 MRAC TELEPHONE 3,240 6,000 54.00% 45229 MRAC RENT OF PROPERTY OR EQUIPMENT 29 2,000 1.45% 45231 MRAC PROFESSIONAL & TECH. SERVICES 3,671 17,350 21.16% 45233 MRAC EDUCATION 433 5,000 8.66% 45234 MRAC INSTRUCTIONAL MATERIALS/SUPP. - 600 - 45235 MRAC SHIPPINGSFREIGHT 202 3,500 5.77% 45246 MRAC SPECIAL DEPARTMENTAL SUPPLIES 11,145 38,300 29.10% 45261 MRAC SUNDRY EXPENSES -MISCELLANEOUS 2,081 6,500 32.02% 45270 MRAC SWIM TEAM 469 3,000 15.63% 45271 MRAC FITNESS PROGRAMS - 45273 MRAC AQUATIC PROGRAMS 370 1,500 24.67% 45274 MRAC - MACHINERY & EQUIPMENT - - 45275 MRAC SPECIAL EVENTS 1,000 Total Swimming Pool 407,137 782,271 52.05% Total Parks, recreation, and public property 717,722 1,455,555 49.31% Community Services Community Services 45310 Community Services SALARIES & WAGES 50,470 88,828 56.82% 45313 Community Services EMPLOYEE BENEFITS 22,137 41,295 53.61% 45323 Community Services TRAVEL 105 2,000 5.25% 45324 Community Services OFFICE EXPENSE & SUPPLIES 261 500 52.20% 45328 Community Services TELEPHONE 362 - 45331 Community Services PROF & TECHNICAL SERVICES - 233,500 Total Community Services 73 335 366,123 20.03% Planning 41810 Planning SALARIES & WAGES 107,137 153,664 69.72% 41813 Planning EMPLOYEE BENEFITS 54,770 84,434 64.87% 41815 Planning OVERTIME 894 4,000 22.35% 41821 Planning SUBSCRIPTIONS & MEMBERSHIPS 3,024 3,830 78.96% 41822 Planning PUBLIC NOTICES 90 1,200 7.50% 41823 Planning TRAVEL 1,594 6,200 25.71% 41824 Planning OFFICE EXPENSE & SUPPLIES 685 6,050 11.32% 41825 Planning EQUIPMENT-SUPPL. & MAINTENANCE 350 - 41828 Planning TELEPHONE (146) 41830 Planning MONTHLY FUEL - GASCARD - 1,000 - 41831 Planning PROFESSIONAL & TECH. SERVICES 3,600 95,850 3.76% 41833 Planning EDUCATION 631 4,500 14.02% 41835 Planning SHIPPING/FREIGHT 400 41846 Planning SPECIAL DEPARTMENTAL SUPPLIES 261 1,000 26.10% 41874 Planning MACHINERY & EQUIPMENT - - Total Planning 172,890 362,128 47.74% Film Commission 42810 Film Comm SALARIES & WAGES 15,907 54,529 29.17% 42813 Film Comm EMPLOYEE BENEFITS 3,025 30,577 9.89% 42815 Film Comm OVERTIME - _ _ 42821 Film Comm SUBSCRIPTIONS & MEMBERSHIPS 1,074 3,982 26.97% 42822 Film Comm PUBLIC NOTICES 1,786 4,100 43.56% 42823 Film Comm TRAVEL 2,030 8,000 25.38% 42824 Film Comm OFFICE EXPENSE & SUPPLIES 133 480 27.71% 42825 Film Comm EQUIP./SUPPLIES & MAINTENANCE - 774 42828 Film Comm TELEPHONE 543 1,350 40.22% 42830 Film Comm MONTHLY FUEL - GASCARD 188 700 26.86% 42831 Film Comm PROFESSIONAL & TECH. SERVICES - 6,234 - 42833 Film Comm EDUCATION 207 1,500 13.80% 42835 Film Comm SHIPPINGIFREIGHT 55 580 9.48% 42846 Film Comm SPECIAL DEPARTMENTAL SUPPLIES 124 314 39.49% 42874 Film Comm MACHINERY & EQUIPMENT - 1,050 INTENDED FOR MANAGEMENT USE ONLY Page 8 Page 13 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 10 10 General Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 42875 Film Comm SPECIAL PROJECTS 5,000 42876 Film Comm GRANT EXPENSES Total Film Commission 25,072 119 170 21.04% Community Contributions 46024 Econ Dev RECYCLING SERVICES - - 46026 Econ Dev ARTS PROMOTION 7,000 7,000 100.00% 46027 Econ Dev AFFORDABLE HOUSING - - 46075 Econ Dev SHELTER SERVICES 7,500 7,500 100.00% 46076 MOAB INFORMATION CENTER - - 46077 Econ Dev MAYORS GRANTS - - - 46082 Econ Dev SOUTHEASTERN ASSO. OF GOV. 2,500 2,500 100.00% 46084 Econ Dev GRAND COUNTY/4TH JULY FIREWORK - 5,000 - Total Community Contributions 17,000 22,000 77.27% Total Community Services 288,297 869 421 33.16% Debt service 47111 CAPITAL LEASE PRINCIPAL 47112 CAPITAL LEASE INTEREST 47121 CAPITAL LEASE OFFSET CHARGES TO DEPTS Total Debt service Transfers and contributions out 48061 TRANS. TO CAPITAL PROJ. FUND 48071 TRANSFER TO MILLCREEK FUND 48086 CONTRIBUTION - RECREATION FUND 261,338 48090 TRANSFER TO STORM WATER UTIL - 48097 TRANSFER TO CAPITAL PROJECTS 48098 CONTRIBUTION TO COMM DEV FUND 26,000 Total Transfers and contributions out 287 338 Total Expenditures: 4,863,749 9,922,227 49.02% Total Change In Net Position (1,586,391) 2/3/2017 05:33 PM INTENDED FOR MANAGEMENT USE ONLY Page 9 Page 14 of 32 MOAB CITY CORPORATION Mid -Year Budget Opening 21 21 Class C Road Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used Change In Net Position Revenue: Taxes 33570 Class C TRANSPORTATION TAX (103,312) (150,000) 68.87% Total Taxes (103,312) (150,000) 68.87% Intergovernmental revenue 33560 Class C CLASS C ROAD FUND (155,861) (180,000) 86.59% Total Intergovernmental revenue (155,861) (180,000) 86.59% Interest 36100 Class C INTEREST INCOME (2,058) (1,355) 151.88% 36160 PROCEEDS FROM LT DEBT - Total Interest (2,058) (1,355) 151.88% Miscellaneous revenue 36200 PROPERTY OWNER CONTRIBUTIONS 36325 SPECIAL SERVICES BY DEPT Total Miscellaneous revenue Contributions and transfers 3650 Proceeds on sale or trade of fixed assets 39561 Class C TRANS. FROM EQUITY-B.O.Y. RESV (268,745) Total Contributions and transfers (268,745) Total Revenue: (261,231) (600,100) 43.53% Expenditures: Facilities Streets 40041 Class C SPECIAL DEPARTMENTAL SUPPLIES 4,142 68,000 6.09% 40058 Class C ROADBASE - PATCHING 2,970 5,000 59.40% 40070 Class C ASPHALT 8 - 40071 Class C OVERLAY 285,000 40072 Class C CRACK SEALING - 32,500 - 40073 Class C - CONCRETE 45,072 100,000 45.07% 40073.1 Class C CONCRETE ADA Transition Plan 50,000 40073.2 Class C CONCRETE Sidewalk/Ped Ramp Repair 50,000 40074 Class C MACHINERY & EQUIPMENT - 400810 LEASE PRINCIPAL 400820 LEASE INTEREST 40169.1 Class C Equipment capital lease 9,600 40169.2 Class C Capital lease interest - Total Streets 52,192 600 100 8.70% Total Facilities 52,192 600 100 8.70% Total Expenditures: 52,192 600,100 8.70% Total Change In Net Position (209,039) INTENDED FOR MANAGEMENT USE ONLY Page 10 Page 15 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 23 23 Recreation Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used Change In Net Position Revenue: Intergovernmental revenue 33561 GRAND COUNTY - RSSD (92,479) - 33563 SCHOOL DISTRICT (23,028) (23,028) 100.00% Total Intergovernmental revenue (23,028) (115,507) 19.94% Charges for services 34537 TOURNAMENT SOFTBALL - MEN'S 34538 TOURNAMENT SOFTBALL - YOUTH 34539 ADULT SOCCER (701) (2,300) 34540 VOLLEYBALL - ADULT COED (180) (1,440) 34545 VOLLEYBALL - WOMEN'S - 34546 VOLLEYBALL - YOUTH SPRING (1,628) (650) 34563 ADULT COED SOFTBALL 80 (2,250) 34564 MENS SOFTBALL - 34566 YOUTH/BASEBALUSOFTBALL 70 34567 RECURRING TEAM MEMBERSHIPS - 34568 YOUTH FOOTBALL (2,808) 34569 SPRING YOUTH SOCCER (2,788) 34570 FALL YOUTH SOCCER (3,472) 34571 SOCCER CAMPS (105) 34572 FOOT RACES (1,753) 34573 SMART START - 34574 INDOOR SOCCER - YOUTH (1,252) 34575 ADULT BASKETBALL 34576 JR JAZZ BASKETBALL (3,346) 34577 FLAG FOOTBALL (1,627) 34578 MIDDLE SCHOOL FOOTBALL (1,551) 34579 FLAG FOOTBALL - ADULT 34580 YOUTH VOLLEYBALL (2,797) 34581 MIDDLE SCHOOL VOLLEYBALL (885) 34583 YOUTH SPONSOR/BASEBALL 34585 PICKLEBALL 34586 DODGE BALL 34587 INDOOR SOCCER - ADULT (600) 34599 MIDDLE SCHOOL TRVL BASEBALL - 34600 CENTER ST. GYM FITNESS (400) 66373 DODGEBALL Total Charges for services (25,343) (76,721) 33.03% Moab arts & recreation 66150 MEMBERSHIP FEES - 66160 PROGRAM FEES (7,482) (6,500) 115.11 % 66180 MATERIALS - TAXABLE - - 66210 GRANTS AND DONATIONS (5,167) (13,344) 38.72% 66250 WORKSHOP FEES - - 66271 RENTAL FEES (16,459) (34,000) 48.41% 66372 SPECIAL EVENTS FEES (40,755) (46,000) 88.60% Total Moab arts $ recreation (69,863) (99,844) 69.97% Interest 36100 INTEREST INCOME (322) Total Interest (322) Miscellaneous revenue 36560 OTHER INCOME 36570 GRANTS AND DONATIONS Total Miscellaneous revenue Contributions and transfers 33562 CITY OF MOAB 39535 RECREATION FUND BEG. BALANCE 39536 BEG FUND BAL MARC SETASIDE 39537 LOAN FROM GENERAL FUND 39540 TRANSFER FROM AFTER SCHOOL Total Contributions and transfers Teen Center (17,428) (3,000) (2,325) 120.77% (8,650) 32.23% (2,835) 122.47% (150) 70.00% (12,950) 13.54% (200) (1,500) 83.47% i (450) (3,670) 91.17% (1,183) 137.53% (1,750) 88.63% (600) (2,005) 139.50% (875) 101.14% (9,750) (360) (2,420) (2,420) 30.48% 12.50% 250.46% -3.56% -0.40% (261,338) (261,338) INTENDED FOR MANAGEMENT USE ONLY Page 11 Page 16 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid Year Budget Opening 23 23 Recreation Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 36210 TEEN CENTER DONATIONS/GRANTS 36220 TEEN CENTER PROGRAM FEES 36230 TEEN CENTER WORKSHOP FEES 36231 PREP PROGRAM GRANT 36571 CTC GRANT 36757 SAFE PASSAGE GRANT Total Teen Center - Total Revenue: (120,976) (553,410) 21.86% Expenditures: Parks, recreation, and public property Recreation 64010 Recreation SALARIES - DIRECTOR/ASST. 90,702 146,863 61.76% 64011 Recreation SALARY DIFFERENTIAL (SURVEY) 14,148 64013 Recreation EMPLOYEE BENEFITS 51,226 81,032 63.22% 64015 Recreation OVERTIME 200 - 64016 Recreation UNEMPLOYMENT - 64021 Recreation SUBSCRIPTIONS & MEMBERSHIPS 236 800 29.50% 64022 Recreation ADVERTISING 2,594 4,500 57.64% 64023 Recreation TRAVEL 185 - 64024 Recreation OFFICE EXPENSE & SUPPLIES 523 2,000 26.15% 64025 Recreation - EQUIP SUPPLIES & MAINT 149 500 29.80% 64028 Recreation TELEPHONE 1,428 2,200 64.91% 64030 Recreation MONTHLY FUEL - GASCARD - 650 64031 Recreation PROFESSIONAL & TECHNICAL 2,105 3,850 54.68% 64033 Recreation EDUCATION 75 2,165 3.46% 64035 Recreation SHIPPING/FREIGHT 137 1,075 12.74% 64036Recreation DIRECTOR -TRAVEL 50 1,165 4.29% 64037 Recreation DIRECTOR/EDUCATION 51 2,934 1.74% 64046 Recreation SPECIAL DEPARTMENTAL SUPPLIES 177 200 88.50% 64065 Recreation FINGER -PRINTING - 820 - 64092 Recreation TURKEY TROT/EASTER EGG HUNT 1,696 2,700 62.81% 95051 Recreation TRANSFER TO CAP PROJECTS - - - Total Recreation 151,334 267 802 56.51% Ski Program 64102 SMART START 64103 CENTER ST. GYM FITNESS Total Ski Program Soccer 64201 Soccer YOUTH SOCCER 2,575 5,510 46.73% 64202 Soccer FALL SOCCER 542 1,100 49.27% 64205 Soccer ADULT SOCCER 550 64209 Soccer INDOOR - YOUTH SOCCER 280 450 62.22% 64210 Soccer WAGES SOCCER - 1,052 64213 Soccer SOCCER REFEREE - WAGES 1,700 - 64215 Soccer INDOOR - YOUTH DIRECTOR SOCCER Total Soccer 3 397 10 362 32.78% Adult Softball 64427 COED SOFTBALL 322 900 35.78% 64435 MEN'S SOFTBALL 64436 MEN'S SOFTBALL TOURN/DIRECTOR 64437 MEN'S SOFTBALL TOURNAMENT 64438 MEN'S SOFTBALL TOURN.-UMPIRES Total Adult Softball 322 900 35.78% Adult Volleyball 64601 CO-ED VOLLEYBALL 910 64602 VOLLEYBALL 64613 CO-ED VOLLEYBALL - DIRECTOR 64614 WOMEN'S VOLLEYBALL - DIRECTOR Total Adult Volleyball 910 Basketball 64803 ADULT BASKETBALL - 350 64804 JR JAZZ BASKETBALL 1,487 3,000 49.57% INTENDED FOR MANAGEMENT USE ONLY Page 12 Page 17 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mld-Year Budget Opening 23 23 Recreation Fund - 07/01/2016 to 02103/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 64805 JR. JAZZ REFEREE SERVICES 2,235 1,740 128.45% 64807 MS BASKETBALL REFEREES - 64813 Basketball EMPLOYEE BENEFITS 226 200 113.00% Total Basketball 3 948 5 290 74.63% Youth Volleyball 64901 YOUTH VOLLEYBALL 738 1,230 60.00% 64902 MIDDLE SCHOOL VOLLEYBALL 787 1,470 53.54% 64903 MIDDLE SCHOOL VOLLEYBALL - - 64904 YOUTH SPRING VOLLEYBALL - WAGES 300 - 1 64905 YOUTH SPRING VOLLEYBALL (330) 225-146.67% Total Youth Volleyball 1,195 3 225 37.05% Youth Baseball/Softball 65111 Youth BB/SB WAGES- MAINTENANCE WORKERS 886 3,000 29.53% 65112 Youth BB/SB WAGES- UMPIRES & SCOREKEEPERS 455 5,800 7.84% 65113 Youth BB/SB EMPLOYEE BENEFITS - 900 - 65123 Youth BB/SB BASEBALL STATE TOURN. EXPENSES 2,000 65125 Youth BB/SB EQUIPMENT -SUPPLIES & MAINT. 200 65126 Youth BB/SB BASEBALL FIELD MAINTENANCE 300 65158 MIDDLE SCHOOL TRVL BASEBALL - 65173 FIELD MAINTENANCE EQUIPMENT - 65174 YOUTH BASEBALUSOFTBALL 17,000 65177 UTAH GIRLS SOFTBALL ASSOC 225 65178 UTAH BOYS BASEBALL ASSOCIATION - 250 - 65180 PICKLEBALL 25 600 4.17% Total Youth Baseball/Softball 1,366 30,275 4.51% Youth Football 65213 Youth Football BENEFITS 70 90 77.78% I 65275 YOUTH FOOTBALL 5,294 5,310 99.70% 65280 FLAG FOOTBALL 1,350 1,350 100.00% 65281 FLAG FOOTBALL - ADULT - - - 65285 MIDDLE SCHOOL FOOTBALL 527 533 98.87% 65286 YOUTH FOOTBALL REFEREES 690 690 100.00% 65295 MS FOOTBALL REFEREES 1,078 1,080 99.81% Total Youth Football 9 009 9,053 99.51% BMX 65410 BMX WAGES 65424 BMX MATERIALS & SUPPLIES Total BMX Special Projects 66046 SPECIAL PROJECTS/EQUIPMENT 15,947 19,000 83.93% Total Special Projects 15,947 19,000 83.93% Teen Center 70010 Teen Center SALARIES & WAGES 70013 Teen Center EMPLOYEE BENEFITS 70015 Teen Center OVERTIME 70021 Teen Center SUBSCRIPTIONS & MEMBERSHIPS 70022 Teen Center PUBLIC NOTICES 70023 Teen Center TRAVEL 70024 Teen Center OFFICE EXPENSE & SUPPLIES 70025 Teen Center EQUIP/SUPPLIES & MAINTENANCE - 70028 Teen Center TELEPHONE (24) 70031 Teen Center PROFESSIONAUTECHNICAL SERVICE 70033 Teen Center EDUCATION 70035 Teen Center SHIPPING/FREIGHT 70046 Teen Center SPECIAL DEPARTMENTAL SUPPLIES 70078 Teen Center SPECIAL PROJECTS 70079 Teen Center PROGRAMS 70080 DODGEBALL Total Teen Center (24) Moab Arts & Recreation Center 80010 MARC SALARIES & WAGES 46,329 90,277 51.32% 80013 MARC EMPLOYEE BENEFITS 14,869 22,618 65.74% INTENDED FOR MANAGEMENT USE ONLY Page 13 Page 18 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 23 23 Recreation Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 80014 MARC SALARIES & WAGES - INSTRUCTORS 2,540 4,000 63.50% 80015 MARC SALARIES & WAGES OT 1,272 680 187.06% 80016 MARC UNEMPLOYMENT 96 80021 MARC SUBSCRIPTIONS & MEMBERSHIPS (140) 940-14.89% 80022 MARC PUBLIC NOTICES 3,392 6,500 52.18% 80023 MARC TRAVEL 613 780 78.59% 80024 MARC OFFICE EXPENSE & SUPPLIES 1,460 3,800 38.42% 80025 MARC EQUIP/SUPPLIES & MAINTENANCE 2,204 2,000 110.20% 80026 MARC BLDG GROUNDS SUPPL & MAINT 1,500 - - 80027 MARC UTILITIES 3,288 7,300 45.04% 80028 MARC TELEPHONE 1,206 1,698 71.02% 80031 MARC PROFESSIONAUTECHNICAL SERVICE 30 1,000 3.00% 80033 MARC EDUCATION - 600 - 80035 MARC SHIPPING/FREIGHT - 500 - 80046 MARC SPECIAL DEPARTMENTAL SUPPLIES 3,876 5,800 66.83% 80074 MARC MACHINERY & EQUIPMENT 15 5,000 0.30% 80077 MARC SPECIAL EVENTS 20,583 14,300 143.94% 80077.1 MARC SPECIAL EVENTS - PLEIN AIR MOAB 16,578 38,800 42.73% 80078 MARC SPECIAL PROJECTS - - Total Moab Arts & Recreation Center 119 711 206 593 57.95% Communities That Care (CTC) 75010 SALARIES & WAGES 75013 EMPLOYEE BENEFITS 75023 TRAVEL 75025 EQUIP/SUPPLIES & MAINTENANCE 75031 PROFESSIONAL & TECHNICAL SERVICES 75033 EDUCATION 75035 OTHER 75046 SPECIAL DEPARTMENTAL SUPPLIES 75078 SPECIAL PROJECTS Total Communities That Care (CTC) Prep 90010 PREP - SALARIES & WAGES 90013 PREP - EMPLOYEE BENEFITS 90022 PREP - PUBLIC NOTICES 90023 PREP - TRAVEL 90024 PREP - OFFICE EXPENSE & SUPPLIES 90028 PREP - TELEPHONE 90031 PREP - PROFESSIONAUTECHNICAL SERVICE 90033 PREP - EDUCATION 90046 PREP - SPECIAL DEPARTMENTAL SUPPLIES Total Prep Total Parks, recreation, and public property 306,205 553,410 55.33% Total Expenditures: 306 205 553 410 55.33% Total Change In Net Position 185,229 INTENDED FOR MANAGEMENT USE ONLY Page 14 Page 19 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mld-Year Budget Opening 24 24 Community Development - 07/01/2016 to 02J03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used Change In Net Position Revenue: Contributions and transfers 39209 COMMUNITY DEV_ FUND/BEG. BAL. (23,356) 39210 CONTRIBUTION FROM GENERAL FUND (26,000) 39223 GRANTS 39224 CDGB (277,000) - 39225 SAFE ROUTE TO SCHOOL GRANT 39226 UTAH POWER GRANT 39250 CDBG WILLOWS - 39351 CDBG CINEMA COURT PROJECT 39352 CDBG 05-06 BALLPARK FENCE 39353 CDBG 06-07 BALLPARK LIGHTS 39354 CDBG 07 BALLPARK BLEACHERS 39355 CDBG 08 WATER LINE 39356 CDBG 09 VIRGINIAN APARTMENTS 39357 LIONS PARK TE GRANT - 39358 NORTH CORRIDOR PATH TE GRANT 39359 NPS RTCA GRANT LIONS PARK Total Contributions and transfers (326,356) Total Revenue: (326,356) Expenditures: Transfers and contributions out 40090 INCREASE IN FUND BALANCE Total Transfers and contributions out Community Development Community development 40002 TEA-21 UDOT N. CORRIDOR PATHS 40003 CDBG 09 VIRGINIAN APARTMENTS 40004 ROTARY PARK 40005 LIONS PARK TE 2011 (32,197) 40006 NORTH CORRIDOR PATH 40007 LIONS PARK DESIGN 40008 LIONS PARK LAND & WATER CONSERV FUND GRANT - 40009 LIONS PARK SCENIC BYWAYS GRANT 903 23,356 3.87% 40010 SAFE ROUTE TO SCHOOLS GRANT 536 26,000 2.06% 40018 CDBG WILLOWS 40019 CDBG PROJECT 277,000 40020 CDBG 07 BALLPARK BLEACHERS - 40021 CDBG 08 WATER LINE 40022 PUBLIC ART 40023 SIGNAGE 40049 CORNER PARK 300 S 400 E 40076 PAYMENT-IN-LIEU/100 W.-P. LOT 40078 SKATE PARK 40084 CDBG'05 MOONSTONE GALLERY 40086 CDBG 02 SUN COURT BBALL 40089 E. CENTER MEDIAN & PARKING 40095 Recreation Center/Playground Equipment 40096 CDBG 05-06 BALLPARK FENCE 40097 CDBG 06-07 BALLPARK LIGHTS 40098 BALLPARK LIGHTING & IMPRVMNTS 40099 200 EAST STREET IMPROVEMENT Total Community development (30,758) 326,356 -9.42% Total Community Development (30,758) 326,356 -9.42% Total Expenditures: (30,758) 326 356 -9.42% Total Change In Net Position (30,758) INTENDED FOR MANAGEMENT USE ONLY Page 15 Page 20 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 28 28 Millcreek Project Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has explred Change In Net Position Revenue: Intergovernmental revenue 33579 FUTURE GRANTS 33581 UTAH TRAILS/MILCREEK DR PATH - STATE FUNDS 33582 UTAH TRAILS/MILLCREEK DR PATH - LOCAL FUNDS 33583 UTAH TRAILS 500 W. UNDERPASS 33584 UTAH TRAILS PIPE DREAM TRAIL 33585 FIRE/FUEUREDUCT/REVEG Total Intergovernmental revenue Contributions and transfers 33210 CONTRIBUTION FROM GENERAL FUND 39210 MILLCREEK PROJ. FUND/BEG. BAL. Total Contributions and transfers Total Revenue: Expenditures: Transfers and contributions out 40090 INCREASE IN FUND BALANCE Total Transfers and contributions out Millcreek Projects Millcreek 40002 FIRE/FUEUREDUCTION/REVEG 40003 MILLCREEK/MAIN STREET - WEIR 40004 UTAH TRAILS 500 W. UNDERPASS 40005 UTAH TRAILS PIPE DREAM 40010 SALARIES 40013 BENEFITS 40031 PROFESSIONAUTECHNICAL 40035 OTHER 40041 ACQUISITIONS 40048 BMX TRACK 40050 BROWNING ROTARY MUSICAL PLAYGROUND GRANT 40051 BROWNING TRAILS GRANT 40074 SPECIAL PROJ. - GRANT MATCH ONLY 40076 TREE EDUCATION/ADVERTISING 40086 TREES/IRRIGATION 40088 UTAH TRAILS MILLCREEK DR PATH 40089 TRAILS Total Millcreek Total Millcreek Projects Total Expenditures: Total Change In Net Position INTENDED FOR MANAGEMENT USE ONLY Page 16 Page 21 of 32 2017 2017 YTD Approved Percent Actual Budget Used • O. • • 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 41 41 Capital Projects Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used Change In Net Position Revenue: Intergovernmental revenue 36124 GRANTS AND DONATIONS 36125 DOG PARK DONATIONS Total Intergovernmental revenue Interest 36100 INTEREST INCOME (19,296) (7,000) 275.66% Total Interest (19,296) (7,000) 275.66% Miscellaneous revenue 36160 CIB LOAN 36165 PROCEEDS FROM LONG TERM DEBT 36200 ANIMAL SHELTER DONATIONS (1,325) 36201 TRANS ENHANCE GRANT 36210 CIB GRANT - 36220 LEASE REVENUE CITY CENTER (37,654) (38,825) 96.98% 36224 UDOT AID PROJECT (180,000) - 36225 MORTGAGE PRNCPAL OLD CITY HALL 36226 MORTGAGE INTEREST OLD CITY HL - 36227 UTAH STATE ENERGY PROGRAM GRANT - 36228 UTAH POWER GRANT (60,000) 36229 FEDERAL HIGHWAY GRANT - 36230 LIBRARY CITY CENTER CONTR - 36235 CIB LOAN AQUATIC CENTER 36236 CONTRIBUTION FROM REC DISTRICT (190,000) 36237 DEVELOPER FEES - 36238 CLAIM SETTLEMENT PROCEEDS 36245 PROCEEDS FROM LT DEBT Total Miscellaneous revenue (38,979) (468,825) 8.31% Contributions and transfers 39222 TRANSFER FROM GENERAL FUND 39225 TRANSFER FROM RECREATION FUND - 39561 CAPITAL PROJECTS FUND BEG. BAL (1,785,334) 39562 TRANSFER IN FROM MUNICIPAL BLDG SETASIDE - 39563 TRANSFER IN FROM USU SET -ASIDE Total Contributions and transfers (1,785,334) Total Revenue: Expenditures: Public safety Police (58,275) (2,261,159) 2.58% 79150 POLICE EQUIPMENT 129,224 Total Police 129,224 Animal Shelter 79140 ANIMAL SHELTER PROJECT 90,000 79141 ANIMAL SHELTER EQUIPMENT 79142 ANIMAL SHELTER FF&E Total Animal Shelter 90 000 Total Public safety 219,224 Facilities Streets 44070 ROAD IMPROVEMENTS - 500,000 44071 MILLCREEK INTERSECTION 1,000 50,000 44072 STREETS/SPECIAL PROJ./CONCRETE - 44073 NORTH CORRIDOR FRONTAGE ROAD 25,000 44074 POWERHOUSE LANE 12,000 44075 SEALCOAT 44075.1 Sealcoat non -capital 44076 MAIN STREET IMPROVEMENTS 44077 500 W EST/KANE CREEK IMPROVE 44077.1 500 W non -capital 44078 TFER TO ROAD IMPROVE SETASIDE 44079 100 NORTH STREET IMPROVEMENTS 2.00% 2/3/2017 05:33 PM INTENDED FOR MANAGEMENT USE ONLY Page 17 Page 22 of 32 MOAB CITY CORPORATION Mid -Year Budget Opening 41 41 Capital Projects Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 44080 TRANSPORTATION MASTER PLAN 4,746 100,000 4.75% 44081 100 WEST DESIGN - - 44082 WILLIAMS WAY ROAD RECONSTRUCTION 44083 EQUIPMENT 123,600 44084 BARTLETT STREET IMPROVEMENTS 44085 100 NO FROM MAIN TO 100 W IMPROVE 44086 400 EAST ROAD IMPROVEMENTS 44087 TRANSPORTATION STUDY - UDOT COST SHARE Total Streets 5,746 810,600 0.71% Storm Drainage 42577 STRMWTR DETENTION BASIN PROJ Total Storm Drainage Total Facilities 5,746 810 600 0.71% Parks, recreation, and public property Recreation 45070 ADA IMPROVEMENTS 77051 CENTER STREET GYM MECHANICAL - 40,000 - 77056 BALLFIELD 5,900 30,000 19.67% 78025 TRAIL & BRIDGE IMPROVEMENTS 2,212 150,000 1.47% 78030 ART IN PUBLIC PLACES 1% 4,659 22,685 20.54% 78043 SWANNY PARK RESTROOMS - - 78044 PARK IMPROVEMENTS 40,000 - 78045 PLAYGROUND EQUIPMENT/BUILDING IMPROVEMENTS 30,000 30,000 100.00% 78046 EQUIPMENT - 54,150 - Total Recreation 42,771 366,835 11.66% Swimming Pool 47070 AQUATIC CENTER PROJECT 40,000 47071 AQUATIC CENTER SET ASIDE 47,000 47072 AQUATIC CENTER EQUIPMENT REPLACEMENT 20,000 47098 CONTRIBUTION TO CIB ESCROW - Total Swimming Pool 107,000 Special Projects 79044 PERFORMANCE GURANTEE DEFAULT IMPROVEMENTS Total Special Projects Moab Arts & Recreation Center 46070 ROOF PROJECT 46071 SOLAR PROJECT 46072 MARC BUILDING IMPROVEMENTS 270,000 Total Moab Arts & Recreation Center 270,000 Total Parks, recreation, and public property 42 771 743 835 5.75% Community Services Community Contributions 79045 USU SETASIDE 79046 Contribution to CHCSSD 79047 USU BUILDING PROJECT Total Community Contributions Total Community Services Transfers and contributions out 40090 INCREASE IN FUND BALANCE 81001 TRANSFER TO GENERAL FUND Total Transfers and contributions out Municipal Building Authority Municipal Building 77031 MUNI BLDG PROJECT 10,716 85,000 12.61% 77042 PUBLIC BLDG BOND RESERVE - - - 77045 MUNICIPAL BLDG FF&E - - - 77046.1 MUNICIPAL BLDG BOND PMT 79,000 79,000 100.00% 77046.2 MUNI BLDG BOND INTEREST 32,500 32,500 100.00% 77047.1 2009 AQUATIC BOND PMT 191,000 191,000 100.00% 77050 TENANT IMPROVEMENTS - - INTENDED FOR MANAGEMENT USE ONLY Page 18 Page 23 of 32 2/3l2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 41 41 Capital Projects Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 77055 CITY HALL SOLAR PHOTO VOLTAIC 5,617 100,000 5.62% Total Municipal Building 318,833 487,500 65.40% Total Municipal Building Authority 318 833 487 500 Total Expenditures: 367,350 2,261,159 16.25% Total Change In Net Position 309,075 65.40% 2/3/2017 05:33 PM INTENDED FOR MANAGEMENT USE ONLY Page 19 Page 24 of 32 MOAB CITY CORPORATION Mid -Year Budget Opening 51 51 Water & Sewer Fund - 07/0112016 to 02/03/2017 66.67% of the flscal year has expired Change In Net Position Expenditures: Miscellaneous 60084 Sewer IMPACT FEE WAIVERS Total Miscellaneous 2017 2017 YTD Approved Percent Actual Budget Used Total Expenditures: Total Change In Net Position Income or Expense Income From Operations: Operating Income Water Operating Income 36300 WATER PENALTIES (4,497) (4,500) 99.93% 36500 SALE OF MATERIALS & SUPPLIES (1,500) 36900 Water SUNDRY REVENUES (7,120) (20,000) 35.60% 37100 WATER SALES (353,567) (550,000) 64.28% 37120 TAX ON SHOP WATER SALES 265 - 37260 WATER CONNECTION (33,371) (15,000) 222.47% 37325 Water SPECIAL SERVICES BY CITY DEPATMENTS (12,000) - 38600 ALLOWANCE ON DOUBTFUL ACCOUNTS (271) - Total Water Operating Income (398,561) (603,000) 66.10% Sewer Operating Income 56900 Sewer SUNDRY REVENUE (59,768) - 57300 SEWER SERVICES CHARGES (568,529) (855,360) 66.47% 57325 Sewer SPECIAL SERVICES BY CITY DEPTS (474) (1,500) 31.60% 57350 Sewer SPANISH VALLEY SEWER (176,246) (192,500) 91.56% 57440 SEWER CONNECTION (13,235) (8,000) 165.44% Total Sewer Operating Income (818,252) (1,057,360) 77.39% Total Operating income (1,216,813) (1,660,360) 73.29% Operating expense Water Operating expense 50009 Water GENERAL FUND 0/H - 177,073 - 50010 Water SALARIES & WAGES 84,824 128,084 66.23% 50011 Water SALARY DIFFERENTIAL (SURVEY) - 23,907 50013 Water EMPLOYEE BENEFITS 65,086 101,031 64.42% 50015 Water OVERTIME 8,100 18,000 45.00% 50021 Water SUBSCRIPTIONS & MEMBERSHIPS 2,038 5,040 40.44% 50023 Water TRAVEL 1,676 4,650 36.04% 50024 Water OFFICE EXPENSE & SUPPLIES - - 50025 Water EQUIPMENT-SUPPL. & MAINTENANCE 2,807 20,500 13.69% 50026 Water BUILDING SUPPL. & MAINTENANCE 680 12,000 5.67% 50027 Water UTILITIES 28,507 48,500 58.78% 50028 Water TELEPHONE 678 3,100 21.87% 50029.1 Water RENT OF PROPERTY & EQUIPMENT 2,107 4,100 51.39% 50029.2 Water capital lease expense - 12,000 50030 Water MONTHLY FUEL - GASCARD 6,994 17,325 40.37% 50031 Water PROFESSIONAL & TECH. SERVICES 8,101 20,927 38.71% 50033 Water WATER/EDUCATION 2,540 5,800 43.79% 50035 Water OTHER 195 1,500 13.00% 50046 Water SPECIAL DEPARTMENTAL SUPPLIES 35,268 59,700 59.08% 50051 Water INSURANCE 1,560 1,600 97.50% 50069 Water DEPRECIATION - 185,000 - Total Water Operating expense 251,161 849 837 29.55% Sewer Operating expense WWTP 60009 Sewer GENERAL FUND O/H - 192,073 - 60010 Sewer WWTP SALARIES & WAGES 77,109 138,579 55.64% 60013 Sewer WWTP EMPLOYEE BENEFITS 44,775 104,702 42.76% 60015 Sewer WWTP OVERTIME 3,506 8,000 43.83% 60021 Sewer WWTP SUBSCRIPTIONS & MEMBERSHIPS 743 3,100 23.97% 60023 Sewer WWTP TRAVEL 539 2,500 21.56% 60024 Sewer WWTP OFFICE EXPENSE & SUPPLIES 430 2,000 21.50% 60025 Sewer WWTP EQUIPMENT SUPPL. & MAINTENANCE 3,721 20,500 18.15% INTENDED FOR MANAGEMENT USE ONLY Page 20 Page 25 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid Year Budget Opening 51 51 Water & Sewer Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used 60026 Sewer WWTP BUILDING SUPPL. & MAINTENANCE 213 5,000 4.26% 60027 Sewer WWTP UTILITIES 56,094 55,000 101.99% 60028 Sewer WWTP TELEPHONE 893 2,700 33.07%' 60029 Sewer WWTP RENT OF PROPERTY & EQUIPMENT 4,016 2,500 160.64% 60030 Sewer WWTP MONTHLY FUEL - GAS CARD 3,151 9,927 31.74% 60031 Sewer WWTP PROFESSIONAL & TECH. SERVICES 51,022 30,000 170.07% 60033 Sewer WWTP EDUCATION - - 60035 Sewer WWTP SHIPPINGIFREIGHT 3,357 6,500 51.65% 60046 Sewer WWTP SPECIAL DEPARTMENTAL SUPPLIES 20,932 - 60069 Sewer DEPRECIATION - 150,000 Total WWTP 270,501 733,081 36.90% Sewer Collection System 60029.1 Sewer COLLECTIONS Captial Lease Expense 21,600 61010 Sewer COLLECTION SALARIES & WAGES 48,035 139,798 34.36% 61013 Sewer COLLECTION EMPLOYEE BENEFITS 24,699 95,910 25.75% 61015 Sewer COLLECTION OVERTIME 1,267 6,000 21.12% 61021 Sewer COLLECTION SUBSCRIP & MEMBER - 1,560 61023 Sewer COLLECTION TRAVEL 1,940 2,700 71.85% 61024 Sewer COLLECTION OFFICE EXP & SUPPLIES 48 1,500 3.20% 61025 Sewer COLLECTION EQUIP SUPPLIES & MAINT 14,043 30,000 46.81% 61026 Sewer COLLECTION BLDG/GRDS SUPPLIES & MAINT 1,844 2,000 92.20% 61027 Sewer COLLECTION UTILITIES - 3,000 61028 Sewer COLLECTION TELEPHONE 349 3,100 11.26% 61029 Sewer COLLECTION RENTALS 23 5,000 0.46% 61030 Sewer COLLECTION MONTLY FUEL 1,837 8,000 22.96% 61031 Sewer COLLECTION PROFESSIONAL & TECH 18,106 33,500 54.05% 61033 Sewer COLLECTION EDUCATION 3,967 6,350 62.47% 61035 Sewer COLLECTION FREIGHT 127 1,500 8.47% 61046 Sewer COLLECTION SPEC DEPT SUPPLIES 15,252 39,500 38.61% Total Sewer Collection System 131,537 401,018 32.80% Total Sewer Operating expense 402,038 1,134,099 35.45% Total Operating expense 653,199 1,983,936 32.92% Total Income From Operations: (563,614) 323 576-174.18% Non -Operating Items: Water Non -operating income 36100 INTEREST INCOME (3,599) (7,000) 51.41% 36110 WATER IMPACT FEE INTEREST INCOME (5,650) (9,000) 62.78% 36111 WATER IMPACT FEES (97,214) (20,000) 486.07% 36112 WATER IMPACT FEE BEG F.B. (224,682) - 36200 WATER TANK FINANCING (1,000,000) - 39535 W/S - BEG. FUND BALANCE (1,965,949) - 5630 Gain (loss) on asset retirement 5651 Water CONTRIBUTIONS OF ASSETS 60091 Benefit expense -change in NPUNPA (GASB 68) Total Water Non -operating Income (106,463) (3,226,631) 3.30% Sewer Non -operating income 56100 Sewer INTEREST INCOME - (5,000) - 56110 SEWER IMPACT FEE INTEREST (8,130) (4,000) 203.25% 56111 SEWER IMPACT FEES (469,404) (50,000) 938.81% 56112 SEWER IMPACT FEE BEG F.B. - (684,000) - 56113 SEWER IMPACT FEE FINANCE INTEREST (6,563) (13,400) 48.98% 56200 SEWER WWTP FINANCING (3,716,000) - 56250 WWTP AGENCY ILA CONTRIBUTION (800,000) - 56860 Sewer Contribution from capital projects Total Sewer Non -operating income Water Non -operating expense 50082 Water INTEREST ON BONDS/DEBT SERVICE 50084 Water TRANSFER TO CAPITAL FACILITIES 60092 Pension expense (GASB 68) Total Water Non -operating expense Sewer Non -operating expense 60082 Sewer INTEREST ON SEWER BONDS (1,284,097) (4,472,400) 28.71% INTENDED FOR MANAGEMENT USE ONLY Page 21 Page 26 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 51 51 Water & Sewer Fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 60085 IMPACT FEE WAIVERS Total Sewer Non -operating expense Total Non -Operating Items: Total Income or Expense INTENDED FOR MANAGEMENT USE ONLY 2017 2017 YTD Approved Percent Actual Budget Used (1,390,560) (7,699,031) 18.06% (1,954,174) (7,375,455) 26.50% Page 22 Page 27 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Capital Budget 51 - 51 Water 8 Sewer Fund as of 02/28/2017 it 2/3/2017 Description 2017 Budget 2017 Actual Projects: Impact Project/Sewer - Impact Fee Study 6,834 0 Impact Project/Sewer - South Trunk Line Master Plan 300,000 1,526 Impact Project/Sewer- WWTP Upgrade 3,900,000 7,330 Impact Project/Sewer Sanitary Sewer Master Plan 70,000 0 Impact ProjectNVater - Tank Assessment 8 System Constructi 1,700,000 269 Impact Project/Water Storage & Dist Master Plan 70,000 0 Sewer Building Project 100,000 1,509 Sewer Lift Pump 8,000 0 Sewer Line Replacements 852,621 521,328 Sewer SCADA Upgrades 40,000 0 Sewer WWTP Effluent Pipe Replacement 75,000 0 Water Lines - Pressure Reducing Valves 182,000 0 Water Tank Maintenance 40,000 0 Total Projects: 7,344,455 531,961 Direct Purchase: 1611 - Land 0 0 1615 - Water shares 0 0 1631 - Water wells 0 0 1641 - Water tanks 0 0 1642 - Water lines 0 0 1643 - Meters 12,000 14,697 1644 - Fire Hydrants 42,000 7,733 1651 - Sewage treatment facilities 0 0 1652 - Sewer lines 0 0 1653 - Manhole Replacement Project 15,000 0 1661.1 - Equipment - general 0 0 1661.2 - Equipment - water 60,000 19,950 1661.3 - Equipment - sewer 237,000 9,987 1665 - Office furniture and equipment 0 0 1671 - Autos and trucks 0 0 Total Direct Purchase: 366,000 52,367 Total Capital Requirement: 7,710,455 584,328 Long Term Debt Repayment: Total Long Term Debt Repayment: Total Capital and Long Term Debt Requirement: 0 0 7,710,455 584,328 Resources to be Provided: Net Income 7,375,455 1,964,302 Add Depreciation 335,000 0 Provided/Required from Operation: 7,710,455 1,964,302 Project Borrowing 0 0 Total Resources to be Provided: 7,710,455 1,964,302 Resource Remaining or to be Provided: 0 1,379,974 Beginning Capital Asset Resources: 0 0 Ending Capital Asset Resources: 0 1,379,974 Page 1 Page 28 of 32 MOAB CITY CORPORATION Mid -Year Budget Opening 53 53 Storm Water Utility fund - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired 2017 2017 YTD Approved Percent Actual Budget Used Income or Expense Income From Operations: Operating income Water Operating Income 36450 STORM WATER DRAINAGE FEE (82,886) (142,000) 58.37% 36460 NON -POINT SOURCE FINANCIAL ASSISTANCE - - - Total Water Operating Income (82,886) (142,000) 58.37% Total Operating Income (82,886) (142,000) 58.37% Operating expense Water Operating expense 40009 Storm wtr GENERAL FUND O/H 4,000 40010 Storm wtr SALARIES & WAGES 28,387 40013 Storm wtr EMPLOYEE BENEFITS - 31,708 40031 Storm wtr PROFESSIONAL 8 TECH. SERVICES 40046 Storm wtr SPECIAL DEPARTMENTAL SUPPLIES 40069 Storm wtr DEPRECIATION 40075 Storm wtr SPECIAL PROJECTS Total Water Operating expense 64 095 Total Operating expense 64,095 Total Income From Operations: (82,886) (77,905) 106.39% Non -Operating Items: Water Non -operating income 3340 STATE GRANT 36110 INTEREST INCOME - 36112 TFER FROM BEG F.B. (1,173,954) 36210 TRANSFER FROM GENERAL FUND Total Water Non -operating income (1,173,954) Water Non -operating expense 40090 Storm wtr TRANSFER TO SURPLUS FUND BAL. Total Water Non -operating expense Total Non -Operating Items: (1,173,954) - Total Income or Expense (82,886) (1,251,859) 6.62% INTENDED FOR MANAGEMENT USE ONLY Page 23 Page 29 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Capital Budget 53 - 53 Storm Water Utility fund as of 02/28/2017 2l312017 Description 2017 Budget 2017 Actual Projects: 100 SOUTH STORM WATER IMPROVEMENTS 309,700 867 MINOR STORM WATER PROJECTS 100,000 0 RIPARIAN HABITAT STUDY 60,000 0 STEWART CANYON SETASIDE 730,300 0 STORM WATER MASTER PLAN 51,859 999 Total Projects: 1,251,859 1,867 Direct Purchase: Total Direct Purchase: Total Capital Requirement: Long Term Debt Repayment: Total Long Term Debt Repayment: Total Capital and Long Term Debt Requirement: 0 0 1,251,859 1,867 0 0 1,251,859 1,867 Resources to be Provided: Net Income 1,251,859 82,886 Add Depreciation 0 0 Provided/Required from Operation: 1,251,859 82,886 Project Borrowing 0 0 Total Resources to be Provided: 1,251,859 82,886 Resource Remaining or to be Provided: 0 81,019 Beginning Capital Asset Resources: 0 0 Ending Capital Asset Resources: 0 81,019 Page 1 Page 30 of 32 MOAB CITY CORPORATION Mid Year Budget Opening 73 73 Youth City Council fund - 07101/2016 to 02/03/2017 66.67% of the fiscal year has expired Change In Net Position Revenue: Interest 36100 INTEREST INCOME Total Interest Contributions and transfers 39200 CONTRIBUTIONS FROM STUDENTS 39201 FUND TRANSFERS FROM MOAB CITY 39210 FUND DONATIONS / CASTLE VALLEY 39220 FUND RAISING PROJECTS 39230 DONATIONS 39550 TRANSFER FROM BEG FUND BALANCE Total Contributions and transfers 2017 2017 YTD Approved Percent Actual Budget Used (15) (15) Total Revenue: (15) Expenditures: General government Administrative 40023 TRAVEL 40024 OFFICE EXPENSES & SUPPLIES 40033 EDUCATION 40035 OTHER 40046 FUND RAISING SUPPLIES 40073 SPECIAL PROJECTS Total Administrative Total General government Transfers and contributions out 40090 TRANSFER TO EQUITY RESERVE Total Transfers and contributions out Total Expenditures: Total Change In Net Position (15) INTENDED FOR MANAGEMENT USE ONLY Page 24 Page 31 of 32 2/3/2017 05:33 PM MOAB CITY CORPORATION Mid -Year Budget Opening 91 91 General Fixed Assets - 07/01/2016 to 02/03/2017 66.67% of the fiscal year has expired Change In Net Position Expenditures: Miscellaneous 4100 Depn expense general govemment 4101 Admin GASB 68 4300 Depn expense public safety 4301 Public Safety GASB 68 4400 Depn expense streets & highways 4401 Streets GASB 68 4500 Depn expense parks & recreation 4501 Parks GASB 68 Total Miscellaneous Total Expenditures: Total Change In Net Position 2017 2017 YTD Approved Percent Actual Budget Used -I I I I I I� I I I I II INTENDED FOR MANAGEMENT USE ONLY Page 25 Page 32 of 32 2/3/2017 05:33 PM