Loading...
HomeMy Public PortalAboutPKT-CC-2011-05-03City of Moab 217 East Center Street Moab, Utah 84532-2534 Main Number (435) 259-5121 Fax Number (435) 259-4135 Memorandum To: Councilmembers and Media From: Mayor David L. Sakrison Date: 05/02/11 Re: Special Meeting Mayor: Council: David L. Sakrison Kyle Bailey Sarah C. Bauman Jeffrey A. Davis Kirstin Peterson Gregg W. Stucki The City of Moab will hold a Special Workshop Meeting on Tuesday, May 3, 2011 at 6:00 PM. The purpose of this meeting will be: 1-1 1-2 Approval of a Non -Motorized Trail Agreement by and between the City of Moab and Club Utah Resort Group L.L.C. Budget Workshop between the Governing Body and City Department Heads for Fiscal Year 2011-2012 The meeting will be held at the Moab City Offices in the Council Chambers at 217 East Center Street, Moab, Utah. David L. Sakrison Mayor In compliance with the Americans with Disabilities Act, individuals needing special accommodations during this meeting should notify the Recorder's Office at 217 East Center Street, Moab, Utah 84532; or phone (435) 259-5121 at least three (3) working days prior to the meeting. First EPA Green Power Community in the Nation CITY OF MOAB ENGINEERING DEPARTMENT CORRESPONDENCE April 29, 2011 Memo To: Honorable Mayor and Members of Council From: Rebecca W. Andrus, City Engineer Subject: Non -Motorized Trail Easement Agreement between the City of Moab and Club Utah Resort Group L.L.C. As part of the Bicycle Path from 500 West to the Transit Hub that is proposed to be constructed with the US 191 Moab to Potash Project, the plan is to utilize the existing 900-foot long trail section that was constructed by Club Utah as part of the Moab Springs Ranch Resort PUD. A portion of this path is in UDOT Right -of -Way while the remainder is on Club Utah Property. Utilizing this section provides cost savings to the construction project and a trail that is set back from the roadway allowing for a better trail experience. Club Utah has agreed to donate an easement to the City for the section of trail that is not in the Right -of -Way. In order to connect the existing trail to the proposed Bicycle Path, UDOT will need to construct a tie-in on the north side of CU property between the existing trail and the Trail within the HWY 191 Right -of -Way. This easement contains the language for the UDOT contractor to construct that portion. Once the construction is completed, the City of Moab will take over maintenance for this trail section. Sincerely, Rebecca W. Andrus, PE Moab City Engineer NON -MOTORIZED TRAIL EASEMENT AGREEMENT THIS NON -MOTORIZED TRAIL EASEMENT AGREEMENT ("Agreement") is entered into as of this day of , 2011 ("Effective Date), by and between CLUB UTAH RESORT GROUP, L.L.C., a Utah limited liability company, ("CU"), and MOAB CITY ("THE CITY" OR "CITY"). RECITALS A. CU owns lands in the City of Moab in Grand County, Utah located along the existing Right -of —Way of US Highway 191, which is owned by the Utah Department of Transportation ("UDOT"). B. CU and City wish to cooperate in the planning and construction of an eight to ten foot wide paved pedestrian bicycle trail along the northeasterly side of US Highway 191 from approximately 500 West Street to the intersection of Highway 128 (the "Trail"). The Trail is believed to be a mutually beneficial public improvement. C. CU has previously, at its expense, constructed an approximately 900-foot long by eight - foot wide section of trail along the highway frontage of its property. Portions of this trail are within the UDOT right-of-way and portions are on CU lands. This section of trail is planned to be incorporated into and made a portion of the Trail. D. CU wishes to donate, and the City wishes to accept, a ten -foot wide non-exclusive easement containing the portion of Trail where it crosses CU lands (the Easement). E. The CU lands are a portion of Moab Springs Ranch Resort PUD (the Resort), which has previously been annexed into Moab City subject to the terms of an Annexation agreement and Amended Annexation Agreement between CU and the City ("Existing Agreements"). CU and the City wish to ensure that the donation of the Trail easement does not adversely affect the objectives of the Existing Agreements. AGREEMENT NOW, THEREFORE, in consideration of the mutual covenants hereafter set forth and other good and valuable consideration, the receipt and sufficiency of which are hereby acknowledged, CU and the City agree as follows: 1. Donation. Subject to the terms of this Agreement, CU hereby agrees to Donate to the City a Non -Exclusive Easement as described on Exhibit A to this Agreement. The Easement, as described on Exhibit A, shall be explicitly restricted by and subject to the specific terms of this Agreement. 2. Purpose: The parties agree and understand that the purpose of the Easement is for the construction, maintenance and use of an eight to ten foot wide non -motorized pedestrian and bicycle trail. The Trail will be a portion of the City's trail network, open to the public and managed and maintained by the City. After donation, the City will assume all responsibility for the adequacy, safety and maintenance of the Trail. 1 3. Existing Agreements: CU and the City reasonably believe that the donation of the Easement is consistent with the intent of the Existing Agreements. CU and the City agree to work together in good faith to make such reasonable accommodations and amendments as may be necessary to preserve the intent of the Existing Agreements should unforeseen consequences of the easement donation come to be at variance with the Existing Agreements. 4. Limitations: The City may not, without the prior written consent of CU and/or its successors, expand the use of the Easement or trail beyond that agreed herein. Specifically, and without limitation, the Easement may not be used to enlarge, expand or widen the Highway 191 Right -of - Way, may not be used to allow motorized use or access, may not be granted to third parties, and may not be used to limit CU's right to develop the Resort. 5. Non -Exclusivity. The Easement is non-exclusive. CU retains all rights to the surface and subsurface which do not interfere with the intended use of the Easement for a non -motorized trail. Specifically, and without limitation, CU retains the right to co -locate new and maintain existing subsurface utilities and to grant other non-exclusive easements across the Easement. CU agrees that any additional use will be subject to an obligation to notify the City prior to any disturbance, temporary closure for construction or other interference with the use of the Easement for its intended purpose, and to restore any portions of the Trail disturbed by construction or other activity to its pre - disturbed condition. 6. Existing Utilities and Easements: The granting of the Easement will not affect existing easements and subsurface utilities within the Easement. Utilities known to the parties include, without limitation, a Moab City water pipeline and irrigation water pipelines owned by CU and others. The City agrees that it will restore, repair or replace any utilities damaged during construction or maintenance. 7. Width, Construction, Maintenance and Encroachment: The Easement is ten feet wide, and is intended to allow a trail of up to ten feet in width to be constructed and maintained. CU acknowledges and agrees that construction and maintenance may require temporary encroachment outside of the easement width, and agrees to accommodate such reasonable encroachment from time to time so long as it is tied to construction or maintenance of the Trail and is prosecuted expeditiously. Excavation and base materials may exceed the ten -foot width by up to two feet each side. Reasonable care will be exercised to keep the ten foot trail pavement section within the ten foot easement. Occasional encroachment for construction and maintenance will not require special permission or additional easements. The City agrees that it will not store construction materials or equipment outside of the easement without permission from CU, nor will it damage any improvements, such as landscaping, fences or signage. The City will be responsible for repair, restoration or replacement of existing facilities damaged by maintenance or construction operations. 8. Construction Access for the UDOT Contractor: In order to complete the construction of the Trail as part of the US 191; MP 126 to MP 129.8 Pavement Preservation & Widen North of SR-128 F-0191(86)126 PIN: 8931 (US 191 Moab to Potash Project) and to provide a connection to the existing trail on CU property, UDOT will need to construct a tie-in on the north side of CU property 2 between the existing trail and the Trail within the HWY 191 Right -of -Way. The UDOT contractor will be allowed access to this easement limited to the area necessary to construct this piece as shown on the UDOT plans for the US 191 Moab to Potash Project. UDOT will follow the same procedures and will be granted the same access rights as specified for the City in the previous item. UDOT will be responsible for repair, restoration or replacement of existing facilities damaged by maintenance or construction operations. Once construction of this section is complete, UDOT will have no further right to access the property and maintenance of the trail within this easement will be the responsibility of the City per the specific terms of this Agreement. 9. Resort Roads and Right to Relocate Easement. The Trail, as constructed and the Easement as granted herein may come to be in conflict with a portion of the private resort road called Icehouse Place as depicted on the attached Exhibit B. The parties agree that CU may, at its expense and subject to the conditions herein, relocate the trail and Easement to the west of the current location. In such event the City agrees to cooperate in replacing the Easement with the new easement. The conditions to such relocation are: a. Prior to moving the trail CU will submit to the City the proposed plans for the new location. The City, through its Engineer, will review the proposed re -alignment for conformance to accepted trail standards for grade, width, curvature, line -of -site and other safety issues. The City will approve the proposed plans, approve the plans with reasonable conditions or ask that revised plans be submitted, stating the reasons for such response. After approval, the City will issue permits and temporary closure permissions as necessary for the trail relocation. b. Upon approval, CU will expeditiously close the Trail or provide temporary bypass facilities, all as approved by the City, and will complete the relocation as quickly as possible. c. Upon relocation of the Trail, CU will prepare a revised legal description for the new easement location. The City will cooperate in releasing the Easement and will accept the new easement. 10. Crossing: The attached Exhibit B shows a location where a road is planned to cross the trail from US Highway 191 to Icehouse Place. The City agrees that this road may be constructed, subject only to the reasonable review and approval of the trail crossing design. The trail crossing will be at the same grade as the existing or redesigned trail, will be signed for the safety of trail users and will not interfere with the function of the Trail. 11. Notice: If to CU: Club Utah Resort Group L.L.C. Attn. McKay Edwards 150 South 600 East #9-B Salt Lake City, Utah, 84102 Phone: 801.588.0911 Fax: 801.588.0913 3 If to the City: Moab City Attention Rebecca Andrus, City Engineer 217 East Center Street Moab, Utah 84532 Phone: 435.259.5121 10. Entire Agreement. This Agreement (together with its Exhibits) represents the entire agreement between the parties with respect to the subject matter hereof and shall be construed without reference to any prior or other agreement between the parties. This Agreement may not be amended or supplemented except by an instrument in writing signed by both parties. Date. IN WITNESS WHEREOF, the parties have executed this Agreement as of the Effective 4 CLUB UTAH RESORT GROUP, L.L.C. By McKay Edwards Manager CITY OF MOAB Date By: David L. Sakrison Date Mayor EXHIBIT "A" MOAB SPRINGS RANCH PROPERTY A 10-foot perpetual non-exclusive easement for a paved pedestrian/bicycle pathway, within the Northeast'/4 of Section 35, Township 25 South, Range 21 East, Salt Lake Base and Meridian. More particularly described as follows: BEGINNING at a point which is North 88°43'03" East 1187.32 feet along the section line and South 1.30 feet from the North Quarter Corner of Section 35, Township 25 South, Range 21 East, Salt Lake Meridian, and running thence South 79°32'09" East 45.92 feet to a point on an 80.00-foot radius curve to the right (concave southwest) the radius point of which bears South 10°27'51" West; thence easterly, along the arc of said curve, a distance of 37.00 feet, through a central angle of 26°30'08"; thence South 53°02'01" East 43.23 feet; thence South 49°24'10" East 117.86 feet; thence South 44°13'09" East 66.60 feet; thence South 39°47'03" East 60.81 feet to a point on a 110.00-foot radius curve to the left (concave northeast) the radius point of which bears North 50°12'57" East; thence southeasterly, along the arc of said curve, a distance of 19.63 feet, through a central angle of 10°13'20"; thence South 50°00'23" East 9.03 feet to a point on a 75.00-foot radius curve to the right (concave southwest) the radius point of which bears South 39°59'37" West; thence southeasterly, along the arc of said curve, a distance of 14.71 feet, through a central angle of 11 °14'24"; thence South 38°46'00" East 89.28 feet; thence South 36°58'08" East 59.35 feet to a point on the northerly right-of-way boundary of US-191, said point also being on a non -tangent 3869.80-foot radius curve to the left (concave southwest) the radius point of which bears South 43°56'09" West; thence northwesterly, along the arc of said curve and said right-of-way, a distance of 60.39 feet, through a central angle of 0°53'39"; thence, leaving said right-of-way, North 38°46"00" West 88.76 feet to a point on a 65.00-foot radius curve to the left (concave southwest) the radius point of which bears South 51 °14'00" West; thence northwesterly, along the arc of said curve, a distance of 12.75 feet, through a central angle of 11 °14'24"; thence North 50°00'23" West 9.03 feet to a point on a 120.00-foot radius curve to the right (concave northeast) the radius point of which bears North 39°59'37" East; thence northwesterly, along the arc of said curve, a distance of 21.41 feet, through a central angle of 10°13'20"; thence North 39°47"03" West 60.42 feet; thence North 44°13'09" West 65.76 feet; thence North 49°24'10" West 117.09 feet; thence North 53°02'01" West 42.92 feet to a point on a 70.00-foot radius curve to the left (concave southwest) the radius point of which bears South 36°57'59" West; thence Northwesterly along the arc of said curve, a distance of 32.38 feet, through a central angle of 26°30'08"; thence North 79°32'09" West 29.26' to a point on the northerly right-of-way boundary of US-191; thence along said right-of-way, North 48°34'06" West 19.43' to the POINT OF BEGINNING. EXHIBIT B Moab Springs Ranch Development Plan per Existing Agreements TO COLORADO RIVER, RCHES NATIONAL PARK mos momoompre simmommiW,‘ user ____Townhome Condominiums Road Crosses Trail- MOAB SPRINGS RANCH "BASECAMP RESORT" 1266 NORTH MAIN STREET MOAB, UTAH, 84532 CONCEPT MASTER PLAN LAND USE ELEMENTS: RANCH HOUSE COMPLEX: RESTAURANT, DELI, SPA, OFFICES & RETAIL THE LODGE AT MOAB SPRINGS: APPROX. 42 SUITES, OFFICE, SUPPORT & CONFERENCE FACILITIES RESORT CONDOMINIUMS: APPROX. 42 LUXURY TOWNHOME CONDOMINIUMS, PROPERTY MANAGEMENT FACILITIES DISPERSED RESORT SUPPORT & COMMERCIAL: SPA, CONFERENCE, FOOD SERVICE & MUSIC FACILITIES, TRAILS, PICNIC, FIRESIDE & MISCELLANEOUS RECREATION AMENITIES. • 1,41.1•••14. CD. 11 II t- f 1-111.1EL 1. fEWROINT / . qoactii 40 o / 1111/MMINIIIWI = Roadways, Existing and Planned Icehouse ..._RANCH HOUSE; MOAB SPRINGS RANCH 31. N / COR SEC 35 O 1.30' S00°00'00"E N88°43'03" E 19.43' N48°34'06"W N79°3. CURVE DATA CURVE # RADIUS DELTA LENGTH RADIAL DIRECTION 1 80.00 26°30'08" 37.00 S10°27'51"W 2 110.00 10°13'20" 19.63 N50°12'57"E 3 75.00 11°14'24" 14.71 S39°59'37"W 4 3869.80 0°53'39" 60.39 S43°56'09"W 5 65.00 11°14'24" 12.75 S51°14'00"W 6 120.00 10°13'20" 21.41 N39°59'37"E 7 70.00 26°30'08" 32.38 S36°57'59"W 2640.10' BASIS OF BEARING 1452.78' 9.03' N50°00'23"W 9.03' S50°00'23"E T.25 S. S.L.B. NE COR SEC 35 R.21 E. & M. m 0 W Z 1- EZ aW cn2 m W Q Q OW 2J 1 SHEET NO u6p.z0-,48 \Rom Jo 4y6t...\gz[ dN gzi oribi-sn-ibEg qeoHib/-sn-cis-gLbp, ”sero.,,d \106,ssi 110Zievp MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 Revenue: Taxes 31300 - SALES & USE TAXES 31400 - FRANCHISE TAXES 31500 - HIGHWAY TAXES 31600 - TRANSIENT ROOM TAXES 31700 - RESORT COMMUNITY TAXES 31800 - ENERGY TAXES 38722 - ANIMAL SHELTER SALES TAX Total Taxes Licenses and permits 32110 - BEER LICENSES 32160 - FLAT BUSINESS LICENSES 32210 - BUILDING PERMITS - CITY 32211 - BUILDING PERMITS - COMMERCIAL 32212 - 1% BLDG PERMIT CHARGE 32213 - PLAN CHECK FEES 32290 - OTHER LICENSES & PERMITS Total Licenses and permits Intergovernmental revenue 33580 - STATE LIQUOR FUND ALLOTMENT 36972 - HOMELAND SECURITY GRANT 36973 - MISC STATE GRANTS 36974 - SAN JUAN CO. CONTRIBUTION 37100 - GRAND COUNTY CONTRIBUTION 37110 - GCRSSD RECREATION CTR CONTRIBUTION Total Intergovernmental revenue Charges for services 34001 - SPECIAL SERVICES BY CITY DEPTS 34020 - RESTITUTION PAID 34200 - GARBAGE BILLING / COLLECTION 34430 - REFUSE COLLECTION CHARGES 34510 - FILM COMM - SPECIAL EVENT FEES 34720 - MRAC - ADMISSIONS/AQUATIC 34721 - MRAC - ADMISSIONS/AQUAT & FITNESS 34722 - MRAC - RETAIL 34723 - MRAC - PROGRAM FEES/ AQUATIC 34724 - MRAC - PROGRAM FEES/FITNESS 34725 - MRAC - CHILD CARE FEES Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved 1,454,430.44 1,303,088.78 778,986.79 1,240,000.00 62.82 $ 1,375,000.00 $ 1,375,000.00 264,197.77 212,213.22 97,020.93 220,000.00 44.10 $ 212,000.00 $ 212,000.00 461,788.86 456,210.74 307,667.46 417,000.00 73.78 $ 500,000.00 $ 500,000.00 531,835.95 568,748.21 443,300.63 535,000.00 82.86 $ 620,000.00 $ 620,000.00 2,356,125.96 2,329,219.54 1,551,835.19 2,157,000.00 71.94 $ 2,555,000.00 $ 2,555,000.00 69,698.14 113,079.44 81,670.89 72,000.00 113.43 $ 125,000.00 $ 125,000.00 (1.01) 85.99 0.00 0.00 0.00 $ $ 5,138,076.11 4,982,645.92 3,260,481.89 4,641,000.00 70.25 $ 5,387,000.00 $ 5,387,000.00 $ 6,980.00 8,410.00 7,660.00 7,500.00 102.13 $ 8,400.00 $ 8,400.00 56,828.25 54,808.00 1,063.00 54,000.00 1.97 $ 55,000.00 $ 55,000.00 36,645.94 56,473.00 21,385.91 35,000.00 61.10 $ 35,000.00 $ 35,000.00 10,134.23 5,133.99 5,225.50 7,000.00 74.65 $ 7,000.00 $ 7,000.00 59.19 161.80 293.12 0.00 0.00 $ $ 3,284.75 2,820.00 1,505.88 2,600.00 57.92 $ 2,600.00 $ 2,600.00 1,058.00 906.00 77.00 1,000.00 7.70 $ 1,000.00 $ 1,000.00 114,990.36 128,712.79 37,210.41 107,100.00 34.74 $ 109,000.00 $ 109,000.00 $ 14,979.85 16,309.01 15,357.70 16,000.00 95.99 $ 16,000.00 $ 16,000.00 0.00 0.00 0.00 0.00 0.00 $ $ 52,291.00 0.00 0.00 0.00 0.00 $ $ 15,000.00 0.00 0.00 0.00 5,000.00 0.00 $ 5,000.00 $ 5,000.00 0.00 15,000.00 15,000.00 15,000.00 100.00 $ 15,000.00 $ 15,000.00 0.00 0.00 25,000.00 25,000.00 100.00 $ 25,000.00 $ 25,000.00 67,270.85 31,309.01 55,357.70 61,000.00 90.75 $ 61,000.00 $ 76,000.00 $ 58,585.41 75,941.20 10,137.78 67,000.00 15.13 $ 67,000.00 $ 67,000.00 371.71 969.02 1,154.84 0.00 0.00 $ $ 39,554.89 39,833.02 23,387.43 39,650.00 58.98 $ 40,050.00 $ 40,050.00 791,278.36 796,833.72 467,748.66 793,000.00 58.98 $ 801,000.00 $ 801,000.00 532.00 0.00 10.00 500.00 2.00 $ 500.00 $ 500.00 43,155.60 14,970.21 17,025.00 82,000.00 20.76 $ 85,000.00 $ 85,000.00 748.64 0.00 0.00 0.00 0.00 $ 10,000.00 $ 10,000.00 0.00 813.00 0.00 0.00 0.00 $ 2,000.00 $ 2,800.00 1,673.00 40.00 0.00 0.00 0.00 $ 14,000.00 $ 17,500.00 0.00 0.00 0.00 0.00 0.00 $ 7,500.00 $ 7,500.00 5,960.00 (100.00) 0.00 0.00 0.00 $ 12,000.00 $ 12,000.00 4/1/2011 1:\2011V011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 1 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 34726 - MRAC - MEMBERSHIPS/AQUATIC 34727 - MRAC - MEMBERSHIPS/AQUAT & FITNESS 34728 - MRAC - RENTAL FEES 34729 - MRAC - SPECIAL EVENT FEES 34730 - ANIMAL SHELTER FEES 34740 - ANIMAL SHELTER INTERLOCAL Total Charges for services Fines and forfeitures 35010 - FINES, FORFEITURES & PENALTIES 35050 - A/R 30-DAY PENALTIES 37200 - FORFEITURES Total Fines and forfeitures Interest 36110 - INTEREST INCOME Total Interest Miscellaneous revenue 36160 - PROCEEDS FROM LT DEBT 36200 - RENTS & CONCESSIONS 36220 - FILM COMM - SPONSOR/DONATION 36226 - FILM COM. - EQUIP RENTAL FEES 36400 - SALE OF REAL/PERS. PROPERTY 36401 - INSURANCE REBATE 36420 - EMPLOYEE MEDICAL CAFE RESIDUAL 36450 - SIDEWALK PERMITS 36500 - SALE OF MATERIALS & SUPPLIES 36900 - OTHER 36901 - DONATIONS 36940 - REAL ESTATE TRANSFER ASSESSMNT 36970- INSURANCE INCOME 38260 - ANIMAL DEPOSITS NON -OPERATING 38721 - ANIMAL SHELTER - SUNDRY RESALE Total Miscellaneous revenue Contributions and transfers 39920 - OVERHEAD PAID FROM SWD ENT FND 39930 - OVERHEAD PAID FROM ENT. FUND 39940 - GENERAL FUND BEG. BALANCE 39950 -TRANSFER FROM OTHER FUNDS Total Contributions and transfers Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved 0.00 0.00 0.00 0.00 0.00 $ 35,000.00 $ 35,000.00 0.00 0.00 0.00 0.00 0.00 $ 55,000.00 $ 55,000.00 0.00 0.00 0.00 0.00 0.00 $ 9,500.00 $ 9,500.00 0.00 0.00 0.00 0.00 0.00 $ 1,500.00 $ 1,500.00 8,457.00 8,539.00 6,165.00 9,500.00 64.89 $ 9,500.00 $ 9,500.00 3,960.00 3,240.00 4,140.00 3,000.00 138.00 $ 6,200.00 $ 6,200.00 954,276.61 941,079.17 529,768.71 994,650.00 53.26 $ 1,155,750.00 $ 1,160,050.00 $ 48,355.12 40,310.09 23,169.05 45,000.00 51.49 $ 42,000.00 $ 42,000.00 3,319.74 0.00 0.00 3,400.00 0.00 $ 3,400.00 $ 3,400.00 0.00 8,090.00 0.00 3,000.00 0.00 $ 3,000.00 $ 3,000.00 51,674.86 48,400.09 23,169.05 51,400.00 45.08 $ 48,400.00 $ 48,400.00 $ 47,410.10 47,410.10 9,948.98 9,948.98 24,619.04 24,619.04 33,000.00 33,000.00 74.60 74.60 $ 34,000.00 I $ $ 34,000.00 $ 34,000.00 34,000.00 $ 270,500.00 301,879.92 (27,709.34) 0.00 0.00 $ $ 6,360.00 6,535.00 2,430.00 5,500.00 44.18 $ 6,500.00 $ 6,500.00 175.00 1,200.00 0.00 0.00 0.00 $ $ 833.00 543.00 413.00 400.00 103.25 $ 500.00 $ 500.00 0.00 2,875.00 0.00 15,000.00 0.00 $ 15,000.00 $ 15,000.00 7,171.45 4,543.12 11,386.00 13,000.00 87.58 $ 12,000.00 $ 12,000.00 29,556.68 102,109.96 0.00 18,000.00 0.00 $ 20,000.00 $ 20,000.00 125.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 8,209.55 1,590.56 43.23 2,000.00 2.16 $ 2,000.00 $ 2,000.00 1,030.00 1,000.00 0.00 1,000.00 0.00 $ $ 0.00 0.00 1,287.50 0.00 0.00 $ $ 999.60 0.00 0.00 0.00 0.00 $ $ 2,675.00 1,850.00 1,485.00 0.00 0.00 $ $ 565.90 25.90 0.00 0.00 0.00 $ $ 328,201.18 424,152.46 (10,664.61) 54,900.00 (19.43) $ 56,000.00 $ 56,000.00 $ 19,500.00 19,500.00 0.00 25,000.00 0.00 $ 45,000.00 $ 45,000.00 325,000.00 325,000.00 0.00 365,000.00 0.00 $ 365,000.00 $ 365,000.00 0.00 0.00 0.00 503,500.00 0.00 $ 50,000.00 $ 145,978.00 0.00 0.00 0.00 0.00 0.00 $ $ 344,500.00 344,500.00 0.00 893,500.00 0.00 $ 460,000.00 $ 555,978.00 $ 4/1/2011 .IA2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 2 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 Total Revenue: Expenditures: General government Executive and Central Staff 41310 - Exec SALARIES & WAGES 41313 - Exec EMPLOYEE BENEFITS 41321 - Exec SUBSCRIPTIONS & MEMBERSHIPS 41323 - Exec TRAVEL 41324 - Exec OFFICE EXPENSE & SUPPLIES 41325 - Exec EQUIP/SUPPLIES & MAINTENANCE 41328 - Exec TELEPHONE 41331 - Exec PROFESSIONAL/TECHNICAL SERVICE 41333 - Exec EDUCATION 41335 - Exec OTHER 41346 - Exec SPECIAL DEPARTMENTAL SUPPLIES Total Executive and Central Staff Recorder 41510 - Recorder SALARIES & WAGES 41513 - Recorder EMPLOYEE BENEFITS 41515 - Recorder OVERTIME 41521 - Recorder SUBSCRIPTIONS/MEMBERSHIPS 41522 - Recorder PUBLIC NOTICES 41523 - Recorder TRAVEL 41524 - Recorder OFFICE EXPENSE & SUPPLIES 41525 - Recorder EQUIP./SUPPLIES & MAINTENANCE 41528 - Recorder TELEPHONE 41531 - Recorder PROFESSIONAL & TECH. SERVICES 41533 - Recorder EDUCATION 41535 - Recorder OTHER 41546 - Recorder SPECIAL DEPARTMENTAL SUPPLIES 41550 - Recorder COPIER SUPPLIES 41574 - Recorder MACHINERY & EQUIPMENT 415810 - LEASE PRINCIPAL 415820-LEASE INTEREST Total Recorder Administrative 41410 - Admin SALARIES & WAGES 41413 - Admin EMPLOYEE BENEFITS Year End Actual YTD Annual Budget % Used Dept. Request 7,046,400.07 6,910,748.42 3,919,942.19 6,836,550.00 57.34 Recommended Council Approved $ 7,277,150.00 $ 7,392,428.00 $ (41,142.83) (42,428.65) (25,477.63) (42,000.00) 60.66 $ (42,000.00) $ (42,000.00) (87,779.75) (88,594.67) (44,561.91) (97,250.00) 45.82 $ (97,250.00) $ (96,158.00) (5,981.80) (3,654.06) 44.73 (3,300.00) (1.36) $ (3,500.00) $ (3,500.00) (1,988.98) (1,572.93) (1,357.10) (3,900.00) 34.80 $ (3,900.00) $ (3,900.00) (2,874.42) (4,031.35) (1,473.45) (3,800.00) 38.78 $ (3,900.00) $ (3,900.00) (66.00) 0.00 0.00 (100.00) 0.00 $ (100.00) $ (100.00) (3,742.42) (3,818.84) (1,669.07) (3,600.00) 46.36 $ (3,800.00) $ (3,800.00) (50.00) 0.00 0.00 0.00 0.00 $ $ (415.00) (90.00) (150.00) (1,000.00) 15.00 $ (1,600.00) $ (1,600.00) (299.01) (367.64) (249.61) (300.00) 83.20 $ (300.00) $ (300.00) (98.08) (68.27) (151.68) (200.00) 75.84 $ (150.00) $ (150.00) (144,438.29) (144,626.41) (75,045.72) (155,450.00) 48.28 $ (156,500.00) $ (155,408.00) $ (129,038.64) (139,650.24) (89,157.12) (155,250.00) 57.43 $ (162,005.00) $ (162,000.00) (83,842.32) (77,640.74) (53,761.60) (96,545.00) 55.69 $ (96,976.00) $ (96,000.00) (1,574.90) (865.80) (914.52) (1,500.00) 60.97 $ (2,000.00) $ (1,600.00) (2,837.02) (3,092.35) (1,530.60) (4,560.00) 33.57 $ (4,564.00) $ (4,500.00) (5,799.25) (2,988.30) (3,597.30) (5,000.00) 71.95 $ (5,000.00) $ (5,000.00) (4,744.72) (2,104.02) (1,408.72) (4,000.00) 35.22 $ (5,100.00) $ (3,900.00) (6,684.56) (7,601.41) (3,254.84) (6,500.00) 50.07 $ (6,700.00) $ (6,700.00) (1,918.51) 0.00 0.00 0.00 0.00 $ (7,571.50) (7,332.15) (4,303.11) (7,200.00) 59.77 $ (8,500.00) $ (8,000.00) (23,531.08) (11,043.65) (14,418.11) (24,600.00) 58.61 $ (26,648.00) $ (26,600.00) (3,568.27) (2,426.22) (376.85) (4,500.00) 8.37 $ (6,650.00) $ (4,000.00) (1,733.01) (1,144.62) (515.35) (1,100.00) 46.85 $ (1,150.00) $ (1,000.00) (16,431.88) (1,408.03) (1,559.57) (3,000.00) 51.99 $ (3,100.00) $ (3,100.00) (5,368.63) 5,018.94 (3,308.89) (4,350.00) 76.07 $ (6,350.00) $ (5,700.00) (15,656.48) 0.00 0.00 0.00 0.00 $ 0.00 0.00 0.00 0.00 0.00 $ 0.00 0.00 0.00 0.00 0.00 $ (310,300.77) (252,278.59) (178,106.58) (318,105.00) 55.99 $ (334,743.00) $ (328,100.00) $ (155,272.59) (155,775.96) (99,810.52) (160,000.00) 62.38 $ (179,100.00) $ (177,000.00) (83,060.35) (81,478.00) (54,111.24) (87,000.00) 62.20 $ (96,000.00) $ (95,000.00) 4/1/2011 JAN11\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 3 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 41415-Admin OVERTIME 41421-Admin SUBSCRIPTIONS & MEMBERSHIPS 41422-Admin PUBLIC NOTICES 41423 - Admin TRAVEL 41424-Admin OFFICE EXPENSE & SUPPLIES 41425 - Admin EQUIP/SUPPLIES & MAINTENANCE 41428-Admin TELEPHONE 41430 - Admin MONTHLY FUEL - GASCARD 41431- Admin PROFESSIONAL/TECH. SERVICE 41433 - Admin EDUCATION 41435 -Admin OTHER 41446 - Admin SPECIAL DEPARTMENTAL SUPPLIES 41474-Admin MACHINERY& EQUIPMENT 41475 - Admin GRANT EXPENSES Total Administrative General 41610 - General SALARIES & WAGES 41613 - General EMPLOYEE BENEFITS 41621- General SUBSCRIPTIONS & MEMBERSHIPS 41622 - General PUBLIC NOTICES 41623 - General TRAVEL 41624 - General OFFICE EXPENSE & SUPPLIES 41625 - General EQUIP./SUPPLIES & MAINTENANCE 41626 - General BLDG/GRDS- SUPPL & MAINTENANCE 41627 - General UTILITIES 41629 - General RENT OF PROPERTY OR EQUIPMENT 41630 - General MONTHLY FUEL - GASCARD 41635 - General OTHER 41646 - General SPECIAL DEPARTMENTAL SUPPLIES 41651- General INSURANCE 41674 - General MACHINERY & EQUIPMENT Total General Elections 41722 - Election PUBLIC NOTICES 41723 - Election TRAVEL 41729 - Election RENTAL - VOTING POLLS/PAGER 41731- Election PROFESSIONAL/TECH - PRIMARY 41732 - Election PROFESSIONAL/TECH - GENERAL 41733 - Election EDUCATION - INITIATIVE 41734 - Election EDUCATION - PRIMARY/GENERAL Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved 0.00 0.00 0.00 (100.00) 0.00 $ (100.00) $ (100.00) (1,012.02) (660.19) (741.00) (900.00) 82.33 $ (900.00) $ (900.00) (4.00) 0.00 0.00 0.00 0.00 $ $ (634.72) 894.32 179.69 (900.00) (19.97) $ (1,100.00) $ (2,000.00) (2,077.13) (1,861.07) (1,575.59) (1,800.00) 87.53 $ (2,900.00) $ (2,900.00) (63.00) 0.00 (80.04) (50.00) 160.08 $ (100.00) $ (100.00) (5,244.61) (4,883.18) (2,335.94) (3,800.00) 61.47 $ (4,900.00) $ (4,500.00) 0.00 0.00 0.00 0.00 0.00 $ - $ - (11,150.00) (12,050.00) (12,050.00) (12,900.00) 93.41 $ (14,200.00) $ (19,750.00) (590.00) (60.00) 0.00 (600.00) 0.00 $ (600.00) $ (600.00) (155.58) (168.57) (90.00) (150.00) 60.00 $ (200.00) $ (200.00) 0.00 (20.94) (2.39) (50.00) 4.78 $ (50.00) $ (50.00) 0.00 0.00 0.00 0.00 0.00 $ - $ 0.00 0.00 0.00 0.00 0.00 $ - $ (500.00) (259,264.00) (256,063.59) (170,617.03) (268,250.00) 63.60 $ (300,150.00) $ (303,600.00) $ 220.00 0.00 0.00 0.00 0.00 $ - $ 0.00 0.00 0.00 0.00 0.00 $ - $ (982.21) (992.53) (955.89) (1,200.00) 79.66 $ (200.00) $ (200.00) 0.00 0.00 0.00 0.00 0.00 $ - $ 0.00 (250.49) 0.00 0.00 0.00 $ - $ (248.98) 0.00 (7.04) (200.00) 3.52 $ (300.00) $ (300.00) (74.14) (491.27) (314.19) (700.00) 44.88 $ (2,000.00) $ (2,000.00) 0.00 0.00 0.00 0.00 0.00 $ - $ (33,106.49) (36,285.33) (18,725.42) (36,700.00) 51.02 $ (37,000.00) $ (37,000.00) (1,658.31) (59.59) (544.61) (1,700.00) 32.04 $ (1,700.00) $ (1,700.00) (385.83) (978.27) (853.70) (300.00) 284.57 $ (1,300.00) $ (1,400.00) (7,636.09) (3,340.03) (3,896.43) (4,200.00) 92.77 $ (4,750.00) $ (4,000.00) 0.00 (22.26) 0.00 (250.00) 0.00 $ (200.00) $ (200.00) (139,479.90) (148,329.78) (107,347.04) (141,000.00) 76.13 $ (155,000.00) $ (168,000.00) (22,876.00) 0.00 0.00 0.00 0.00 (206,227.95) (190,749.55) (132,644.32) (186,250.00) 71.22 $ (202,450.00) $ (214,800.00) $ - 0.00 (1,109.35) (92.30) 0.00 0.00 $ (1,000.00) $ (1,000.00) 0.00 0.00 0.00 0.00 0.00 $ (500.00) $ (500.00) 0.00 (150.00) 0.00 0.00 0.00 $ (1,000.00) $ (1,000.00) 0.00 0.00 0.00 0.00 0.00 $ (2,000.00) $ (2,000.00) 0.00 (3,421.00) 0.00 0.00 0.00 $ (2,000.00) $ (2,000.00) 0.00 0.00 0.00 0.00 0.00 $ (300.00) $ (300.00) 0.00 (417.85) 0.00 0.00 0.00 $ (500.00) $ (500.00) 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 4 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 41735 - Election CARR PRINTING EXPENSES 41736 - Election ELECTION DINNERS - PRIMARY 41737 - Election ELECTION DINNERS -GENERAL 41746 - Election SPECIAL DEPT'L - PRIMARY 41747 - Election SPECIAL DEPT'L - GENERAL 41774- Election MACHINERY & EQUIPMENT Total Elections Planning 41810 - Planning 41813 - Planning 41815 - Planning 41821- Planning 41822 - Planning 41823 - Planning 41824 - Planning 41825 - Planning 41828 - Planning 41830 - Planning 41831- Planning 41833 - Planning 41835 - Planning 41846 - Planning 41874 - Planning Total Planning Engineering 41910 - Engineer 41913 - Engineer 41915 - Engineer 41921- Engineer 41922 - Engineer 41923 - Engineer 41924 - Engineer 41925 - Engineer 41928 - Engineer 41930 - Engineer 41931- Engineer 41933 - Engineer 41935 - Engineer 41946 - Engineer 41974 - Engineer SALARIES & WAGES EMPLOYEE BENEFITS OVERTIME SUBSCRIPTIONS & MEMBERSHIPS PUBLIC NOTICES TRAVEL OFFICE EXPENSE & SUPPLIES EQUIPMENT-SUPPL. & MAINTENANCE TELEPHONE MONTHLY FUEL - GASCARD PROFESSIONAL & TECH. SERVICES EDUCATION OTHER SPECIAL DEPARTMENTAL SUPPLIES MACHINERY & EQUIPMENT SALARIES & WAGES BENEFITS OVERTIME SUBSCRIPTIONS & MEMBERSHIPS PUBLIC NOTICES TRAVEL OFFICE EXPENSE & SUPPLIES EQUIP/SUPPLIES & MAINTENANCE TELEPHONE MONTHLY FUEL - GASCARD PROFESSIONAL & TECH. SERVICES EDUCATION OTHER MACHINERY & EQUIPMENT Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved 0.00 (1,953.54) 0.00 0.00 0.00 $ (2,000.00) $ (2,000.00) 0.00 0.00 0.00 0.00 0.00 $ (750.00) $ (750.00) 0.00 (1,220.29) 0.00 0.00 0.00 $ (750.00) $ (750.00) 0.00 0.00 0.00 0.00 0.00 $ (250.00) $ (250.00) 0.00 (565.57) 0.00 0.00 0.00 $ (250.00) $ (250.00) 0.00 0.00 0.00 0.00 0.00 0.00 (8,837.60) (92.30) 0.00 0.00 $ (11,300.00) $ (11,300.00) $ - (169,989.31) (182,705.65) (120,680.45) (185,000.00) 65.23 $ (205,000.00) $ (205,000.00) (86,543.43) (87,995.60) (59,301.39) (93,500.00) 63.42 $ (106,600.00) $ (105,000.00) (7,673.61) (2,528.11) (4,602.53) (5,600.00) 82.19 $ (6,500.00) $ (6,500.00) (1,631.12) (1,777.60) (1,714.37) (1,800.00) 95.24 $ (1,800.00) $ (1,800.00) (699.05) (1,013.55) (701.60) (900.00) 77.96 $ (1,200.00) $ (1,200.00) (2,846.19) (735.70) (1,293.84) (1,500.00) 86.26 $ (2,000.00) $ (1,800.00) (5,760.27) (6,616.28) (2,518.62) (3,800.00) 66.28 $ (3,800.00) $ (4,300.00) (48.47) (131.71) 0.00 0.00 0.00 $ (1,800.00) $ (1,800.00) (6,298.76) (5,230.61) (2,810.91) (5,100.00) 55.12 $ (5,100.00) $ (5,300.00) (454.88) (503.38) (263.66) (600.00) 43.94 $ (1,000.00) $ (700.00) (12,410.16) (6,000.00) (205.38) (57,600.00) 0.36 $ (60,000.00) $ (60,000.00) (2,798.45) (3,397.79) (1,911.07) (2,600.00) 73.50 $ (2,900.00) $ (2,900.00) (140.89) (376.48) (223.64) (300.00) 74.55 $ (300.00) $ (300.00) (284.66) (145.79) (231.22) (700.00) 33.03 $ (1,000.00) $ (1,000.00) (7,447.50) 0.00 0.00 0.00 0.00 $ (2,000.00) $ (2,000.00) (305,026.75) (299,158.25) (196,458.68) (359,000.00) 54.72 $ (401,000.00) $ (399,600.00) $ - (101,192.74) (96,990.02) (67,998.37) (107,000.00) 63.55 $ (122,430.00) $ (125,000.00) (42,345.68) (40,356.63) (33,952.78) (46,800.00) 72.55 $ (60,260.05) $ (60,000.00) 0.00 0.00 0.00 (400.00) 0.00 $ (400.00) $ (400.00) (8,010.77) (6,351.73) (4,292.15) (5,000.00) 85.84 $ (5,835.00) $ (5,800.00) 0.00 0.00 0.00 0.00 0.00 $ $ (170.19) (617.57) (51.67) (600.00) 8.61 $ (1,000.00) $ (900.00) (1,691.01) (1,904.44) (241.09) (1,800.00) 13.39 $ (1,500.00) $ (1,600.00) (138.03) (12.15) 0.00 (200.00) 0.00 $ (2,000.00) $ (2,000.00) (2,905.40) (2,973.72) (1,983.03) (3,950.00) 50.20 $ (3,660.00) $ (3,660.00) (95.39) 0.00 0.00 0.00 0.00 $ - $ (3,044.62) (4,272.50) (105.00) (3,000.00) 3.50 $ (10,000.00) $ (8,000.00) (594.20) (1,446.50) 0.00 (1,500.00) 0.00 $ (1,500.00) $ (1,500.00) 0.00 (104.95) (104.68) (200.00) 52.34 $ (200.00) $ (200.00) (1,878.93) (6,030.52) (31.56) (1,000.00) 3.16 $ (1,000.00) $ (1,000.00) (7,447.50) 0.00 0.00 0.00 0.00 $ - 4/1/2011 J:\2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 5 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 Total Engineering Treasurer 42010 - Treasurer 42013 - Treasurer 42015 - Treasurer 42021 - Treasurer 42023 - Treasurer 42024 - Treasurer 42025 - Treasurer 42028 - Treasurer 42031 - Treasurer 42033 - Treasurer 42035 - Treasurer 42036 - Treasurer 42046 - Treasurer 42051 - Treasurer 42063 - Treasurer 42074 - Treasurer Total Treasurer SALARIES & WAGES EMPLOYEE BENEFITS OVERTIME SUBSCRIPTIONS & MEMBERSHIPS TRAVEL OFFICE EXPENSE & SUPPLIES EQUIPMENT SUPPL. & MAINTENANCE TELEPHONE PROFESSIONAL & TECH. SERVICES EDUCATION OTHER BANK HANDLING CHARGES SPECIAL DEPARTMENTAL SUPPLIES INSURANCE CASH OVER & SHORT MACHINERY & EQUIPMENT Total General government Public safety Police 42110 - Police 42113 - Police 42114 - Police 42115 - Police 42121 - Police 42123 - Police 42124 - Police 42125 - Police 42126 - Police 42128 - Police 42129 - Police 42130 - Police 42131 - Police 42133 - Police 42135 - Police 42146 - Police 42169 - Police SALARIES & WAGES EMPLOYEE BENEFITS OTHER BENEFITS- U/ALLOWANCES OVERTIME SUBSCRIPTIONS & MEMBERSHIPS TRAVEL OFFICE EXPENSE & SUPPLIES EQUIPMENT-SUPPL. & MAINTENANCE TELEPHONE RENT OF PROPERTY OR EQUIPMENT MONTHLY FUEL - GASCARD PROFESSIONAL & TECH. SERVICES EDUCATION OTHER SPECIAL DEPARTMENTAL SUPPLIES Lease payments Year End Actual (169,514.46)L (161,060.73) YTD Annual Budget % Used Dept. Request (108,760.33) (171,450.00) 63.44 Recommended Council Approved $ (209,785.05) $ (210,060.00) $ (74,932.04) (77,114.82) (49,928.74) (80,400.00) 62.10 $ (84,500.00) $ (86,000.00) (38,876.64) (38,805.69) (28,375.65) (44,075.00) 64.38 $ (53,725.00) $ (53,725.00) 0.00 (236.18) 0.00 (250.00) 0.00 $ (250.00) $ (250.00) (574.82) (195.00) (23.00) (415.00) 5.54 $ (420.00) $ (420.00) (339.91) (360.25) 0.00 (1,000.00) 0.00 $ (1,000.00) $ (1,000.00) (12,133.80) (10,786.19) (5,507.09) (10,925.00) 50.41 $ (11,635.00) $ (11,000.00) (300.00) 0.00 0.00 (300.00) 0.00 $ (300.00) $ (200.00) (3,899.41) (3,640.37) (1,822.56) (3,400.00) 53.60 $ (3,400.00) $ (3,500.00) (3,196.50) (5,230.00) (100.00) (5,600.00) 1.79 $ (5,600.00) $ (5,600.00) (180.00) (150.00) 0.00 (690.00) 0.00 $ (690.00) $ (600.00) (5.00) (106.00) (60.00) (100.00) 60.00 $ (100.00) $ (100.00) (13,177.81) (21,425.91) (9,443.06) (20,000.00) 47.22 $ (23,500.00) $ (20,000.00) (14,725.00) 4,650.00 (905.00) (2,300.00) 39.35 $ (2,300.00) $ (2,300.00) (1,555.00) (1,638.00) (1,713.00) (1,725.00) 99.30 $ (1,750.00) $ (1,800.00) (40.00) 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ (163,935.93) (155,038.41) (97,878.10) (171,180.00) 57.18 $ (189,170.00) $ (186,495.00) (1,558,708.15) (1,467,813.13) (959,603.06) (1,629,685.00) 58.88 $ (378,340.00) $ (372,990.00) $ (744,745.08) (714,871.01) (443,016.27) (725,970.00) 61.02 $ (792,790.00) $ (792,790.00) (448,224.27) (410,787.63) (261,285.39) (505,085.00) 51.73 $ (574,958.00) $ (570,000.00) (8,745.98) (3,759.90) (7,920.00) (12,860.00) 61.59 $ (14,760.00) $ (14,760.00) (20,849.30) (18,643.19) (22,504.37) (20,000.00) 112.52 $ (40,000.00) $ (21,000.00) (1,761.14) (2,143.20) (554.35) (2,100.00) 26.40 $ (2,100.00) $ (2,100.00) (11,374.53) (13,265.04) (5,629.33) (9,000.00) 62.55 $ (9,000.00) $ (9,000.00) (7,156.11) (5,337.73) (3,100.36) (5,400.00) 57.41 $ (6,700.00) $ (5,900.00) (29,062.90) (20,192.30) (11,942.78) (23,000.00) 51.93 $ (31,700.00) $ (31,700.00) (8.00) (149.00) 0.00 0.00 0.00 $ (23,602.46) (21,660.20) (10,432.16) (21,000.00) 49.68 $ (21,960.00) $ (22,000.00) (2,734.00) (2,758.00) (2,908.00) (3,200.00) 90.88 $ (3,200.00) $ (3,200.00) (27,457.13) (27,335.39) (18,429.30) (26,000.00) 70.88 $ (35,000.00) $ (35,000.00) (1,989.18) (4,766.97) (1,717.45) (4,000.00) 42.94 $ (4,000.00) $ (3,000.00) (1,545.00) (2,548.35) (760.00) (3,500.00) 21.71 $ (3,500.00) $ (3,000.00) (62,212.02) (38,153.30) (64,062.01) (72,000.00) 88.98 $ (75,000.00) $ (75,000.00) (33,940.06) (13,361.87) (16,088.56) (78,000.00) 20.63 $ (15,000.00) $ (14,000.00) (41,117.62) (150.00) 0.00 0.00 0.00 $ $ 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 6 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 42172 - Police SPECIAL EVENTS 42173 - Police D.A.R.E. - EQUIP. & SUPPLIES 42174- Police MACHINERY & EQUIPMENT 421810 - LEASE PRINCIPAL 421820-LEASE INTEREST Total Police Attorney 42231- Attorney PROFESSIONAL & TECH. SERVICES Total Attorney Narcotics Task Force 42310 - Narcotics SALARIES & WAGES 42313 - Narcotics EMPLOYEE BENEFITS 42314- Narcotics OTHER BENEFITS- U/ALLOWANCES 42315 - Narcotics OVERTIME 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 OTHER 42346 - Narcotics SPECIAL DEPARTMENTAL SUPPLIES 42369 - Narcotics Lease payment 42370 - Narcotics FORFEITURES 42374- Narcotics MACHINERY & EQUIPMENT Total Narcotics Task Force Inspections 42431- Inspection 42475 - Inspection Total Inspections Animal control 42610 - Animal Ctl 42613 - Animal Ctl 42614 - Animal Ctl 42615 - Animal Ctl 42623 - Animal Ctl 42624-Animal Ctl PROFESSIONAL & TECH. SERVICES SPECIAL PROJECTS SALARIES & WAGES EMPLOYEE BENEFITS OTHER BENEFIT- U/ALLOWANCES OVERTIME TRAVEL OFFICE EXPENSE & SUPPLIES Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved (44,245.85) 0.00 0.00 0.00 0.00 $ - $ - (1,306.33) (1,222.01) 0.00 (1,500.00) 0.00 $ (1,500.00) $ (1,500.00) (48,892.54) (48,582.82) 0.00 (10,000.00) 0.00 $ (89,125.00) $ (70,000.00) 0.00 0.00 0.00 0.00 0.00 $ - 0.00 0.00 0.00 0.00 0.00 $ - (1,560,969.50) (1,349,687.91) (870,350.33) (1,522,615.00) 57.16 $ (1,720,293.00) $ (1,673,950.00) $ (77,986.16) (77,986.16) (83,829.17) (83,829.17) (37,478.36) (37,478.36) (80,000.00) (80,000.00) 46.85 46.85 $ (90,000.00)1 $ (90,000.00) $ (90,000.00) $ (90,000.00) $ (51,223.83) (54,426.85) (36,502.85) (54,238.00) 67.30 $ (58,960.00) $ (58,960.00) (32,005.93) (31,728.77) (22,898.63) (37,330.00) 61.34 $ (42,155.00) $ (42,000.00) (240.00) 0.00 0.00 (960.00) 0.00 $ (960.00) $ (960.00) (3,420.47) (3,214.58) (4,961.25) (6,500.00) 76.33 $ (6,500.00) $ (5,000.00) (1,214.79) (931.71) (454.95) (1,500.00) 30.33 $ (1,500.00) $ (1,300.00) (166.83) (20.26) (14.78) (200.00) 7.39 $ (200.00) $ (100.00) (8,304.72) (2,611.98) (1,758.09) (1,800.00) 97.67 $ (3,000.00) $ (2,000.00) (1,593.47) (1,292.39) (487.73) (1,300.00) 37.52 $ (1,900.00) $ (1,900.00) (3,268.95) (2,650.36) (1,416.24) (2,800.00) 50.58 $ (3,800.00) $ (3,800.00) 0.00 0.00 0.00 (600.00) 0.00 $ (600.00) $ (250.00) (500.00) (347.93) (275.00) (600.00) 45.83 $ (600.00) $ (600.00) (4,110.00) (1,836.00) (30.00) (3,500.00) 0.86 $ (4,000.00) $ (3,000.00) (435.86) (223.91) (88.95) (1,000.00) 8.90 $ (1,000.00) $ (500.00) (7,906.12) 0.00 0.00 0.00 0.00 $ $ - 0.00 (9,103.00) 0.00 (3,000.00) 0.00 $ (3,000.00) $ (3,000.00) 0.00 0.00 0.00 (1,500.00) 0.00 $ (4,900.00) $ (4,900.00) (114,390.97) (108,387.74) (68,888.47) (116,828.00) 58.97 $ (133,075.00) $ (128,270.00) $ (67,645.39) 0.00 (77,655.26) 0.00 (85,368.05) 0.00 (79,000.00) 0.00 108.06 0.00 $ (87,000.00) $ (87,000.00) (67,645.39) (77,655.26) (85,368.05) (79,000.00) 108.06 $ (87,000.00) $ (87,000.00) $ (73,026.88) (72,442.22) (48,081.91) (74,782.00) 64.30 $ (77,765.00) $ (78,000.00) (34,522.84) (32,561.82) (22,134.09) (35,605.00) 62.17 $ (37,872.00) $ (37,000.00) (880.00) (1,360.00) (480.00) (1,920.00) 25.00 $ (1,920.00) $ (1,920.00) (3,166.95) (5,698.16) (3,412.84) (4,500.00) 75.84 $ (6,000.00) $ (4,500.00) (659.68) (468.22) (157.52) (900.00) 17.50 $ (900.00) $ (800.00) (59.54) (32.47) (121.81) (100.00) 121.81 $ (200.00) $ (200.00) 4/1/2011 JA2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 7 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 42625 - Animal Ctl EQUIPMENT-SUPPL. & MAINTENANCE 42628 - Animal Ctl TELEPHONE 42630 - Animal Ctl MONTHLY FUEL - GASCARD 42631 - Animal Ctl PROFESSIONAL & TECH. SERVICES 42633 - Animal Ctl EDUCATION 42646 - Animal Ctl SPECIAL DEPARTMENTAL SUPPLIES 42669 - Animal Ctl Lease payments 42674 - Animal Ctl MACHINERY & EQUIPMENT Total Animal control Animal Shelter 42710 - Animal Shltr 42713 - Animal Shltr 42714 - Animal Shltr 42715 - Animal Shltr 42722 - Animal Shltr 42724 - Animal Shltr 42725 - Animal Shltr 42726 - Animal Shltr 42727 - Animal Shltr 42728 - Animal Shltr 42730 - Animal Shltr 42731 - Animal Shltr 42733 - Animal Shltr 42735 - Animal Shltr 42746 - Animal Shltr 42769 - Animal Shltr 42774 - Animal Shltr Total Animal Shelter Total Public safety SALARIES & WAGES EMPLOYEE BENEFITS OTHER BENEFITS- U/ALLOWANCES OVERTIME PUBLIC NOTICES OFFICE EXPENSE & SUPPLIES EQUIP/SUPPLIES & MAINTENANCE BLDG/GRDS-SUPPLIES & MAINT. UTILITIES TELEPHONE MONTHLY FUEL - GASCARD PROFESSIONAL/TECHNICAL SERVICE EDUCATION OTHER SPECIAL DEPARTMENTAL SUPPLIES Lease payments MACHINERY & EQUIPMENT Highways and public improvements Highways 44010 - Highways SALARIES & WAGES 44013 - Highways EMPLOYEE BENEFITS 44015 - Highways OVERTIME 44021 - Highways SUBSCRIPTIONS & MEMBERSHIPS 44023 - Highways TRAVEL 44024 - Highways OFFICE EXPENSE & SUPPLIES 44025 - Highways EQUIPMENT-SUPPL. & MAINTENANCE 44026 - Highways BLDG/GRDS-SUPPL. & MAINTENANCE Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved (2,804.19) (2,099.70) (3,072.76) (3,200.00) 96.02 $ (5,000.00) $ (4,500.00) (1,075.31) (923.11) (437.17) (1,100.00) 39.74 $ (2,275.00) $ (2,275.00) (4,040.06) (4,507.64) (3,376.45) (5,900.00) 57.23 $ (8,000.00) $ (7,000.00) (558.00) (420.00) (435.00) (1,000.00) 43.50 $ (1,000.00) $ (1,000.00) (510.00) (395.00) (360.00) (600.00) 60.00 $ (600.00) $ (600.00) (793.05) (301.07) (71.31) (300.00) 23.77 $ (5,400.00) $ (5,000.00) (14,735.66) 0.00 0.00 0.00 0.00 $ (1,750.00) 0.00 0.00 0.00 0.00 $ (138,582.16) (121,209.41) (82,140.86) (129,907.00) 63.23 $ (146,932.00) $ (142,795.00) $ (33,599.50) (32,568.90) (20,504.80) (33,300.00) 61.58 (13,114.04) (12,858.46) (8,624.91) (14,100.00) 61.17 (240.00) (960.00) (560.00) (960.00) 58.33 0.00 (203.31) (475.60) (550.00) 86.47 (603.00) (315.00) (752.70) (1,000.00) 75.27 (53.00) (103.98) (74.48) (200.00) 37.24 (1,224.34) (1,042.06) (370.83) (1,200.00) 30.90 (1,205.88) (3,491.83) (1,046.05) (2,750.00) 38.04 (8,184.60) (9,859.44) (5,296.23) (10,000.00) 52.96 (738.34) (759.21) (463.58) (800.00) 57.95 0.00 0.00 0.00 (300.00) 0.00 (1,075.90) 0.00 (180.00) (700.00) 25.71 0.00 (190.00) (90.00) (400.00) 22.50 (35.00) (93.79) (76.00) (100.00) 76.00 (1,358.28) (2,757.00) (1,612.20) (2,800.00) 57.58 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (61,431.88) (65,202.98) (40,127.38) (69,160.00) 58.02 (2,021,006.06) (1,805,972.47) (1,184,353.45) (1,997,510.00) 59.29 (36,490.00) (36,500.00) (15,485.00) $ (960.00) $ (750.00) $ (1,200.00) $ (200.00) $ (1,100.00) $ (2,750.00) $ (10,000.00) $ (800.00) $ (300.00) $ (700.00) $ (400.00) $ (150.00) $ (2,800.00) (15,400.00) (960.00) (500.00) (1,000.00) (100.00) (1,000.00) (2,000.00) (10,000.00) (800.00) (300.00) (400.00) (400.00) (150.00 ) (2,800.00) (25,000.00) $ (99,085.00) $ (72,310.00) $ (486,894.59) (464,502.88) (261,041.89) (491,600.00) 53.10 $ (493,698.00) $ (493,698.00) (279,181.97) (243,170.69) (147,888.77) (293,600.00) 50.37 $ (301,551.00) $ (299,000.00) (3,068.04) (3,321.66) (1,797.15) (3,500.00) 51.35 $ (6,175.00) $ (6,200.00) (858.50) (650.85) (708.40) (1,400.00) 50.60 $ (1,400.00) $ (1,000.00) (2,656.84) (710.05) (306.40) (1,500.00) 20.43 $ (1,500.00) $ (1,200.00) (2,141.61) (3,418.20) (1,857.43) (3,500.00) 53.07 $ (3,500.00) $ (3,500.00) (20,869.55) (27,504.22) (11,156.52) (22,721.00) 49.10 $ (22,000.00) $ (22,000.00) (25,877.68) (37,713.86) (11,201.38) (31,000.00) 36.13 $ (197,200.00) $ (36,000.00) 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 8 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 44027 - Highways UTILITIES 44028 - Highways TELEPHONE 44029 - Highways RENT OF PROPERTY OR EQUIPMENT 44030 - Highways MONTHLY FUEL - GASCARD 44031 - Highways PROFESSIONAL & TECH. SERVICES 44033 - Highways EDUCATION 44035 - Highways OTHER 44042 - Highways STREET LIGHTS 44046 - Highways SPECIAL DEPARTMENTAL SUPPLIES 44069 - Highways Lease payments 44074 - Highways MACHINERY & EQUIPMENT 44077 - SPECIAL PROJECTS 440810- LEASE PRINCIPAL 440820-LEASE INTEREST Total Highways Storm Drainage 42531 - PROFESSIONAL & TECH. SERVICES 42546 - SPECIAL DEPARTMENTAL SUPPLIES Total Storm Drainage Sanitation 44231 - Sanitation PROFESSIONAL & TECH. SERVICES Total Sanitation Safety 44121 - Safety SUBSCRIPTIONS & MEMBERSHIPS 44123 - Safety TRAVEL 44125 - Safety EQUIP/SUPPLIES & MAINTENANCE 44128 - Safety TELEPHONE 44131 - Safety PROFESSIONAL & TECH. SERVICES 44133 - Safety EDUCATION 44135 - Safety OTHER 44146 - Safety SPECIAL DEPARTMENTAL SUPPLIES 44174 - Safety MACHINERY & EQUIPMENT 44175 - Safety SAFETY EQUIPMENT Total Safety Total Highways and public improvements Parks, recreation, and public property Parks Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved (12,003.72) (11,747.85) (7,656.76) (14,500.00) 52.81 $ (14,500.00) $ (14,500.00) (2,815.14) (3,267.70) (1,819.75) (3,100.00) 58.70 $ (3,100.00) $ (3,200.00) (2,400.00) (2,400.25) (1,895.00) (3,400.00) 55.74 $ (3,400.00) $ (2,600.00) (26,088.79) (23,985.02) (14,008.40) (28,000.00) 50.03 $ (28,000.00) $ (30,000.00) (17,838.22) (29,518.86) (26,837.74) (34,000.00) 78.93 $ (11,000.00) $ (11,000.00) (1,455.00) (57.00) 0.00 (600.00) 0.00 $ (600.00) $ (600.00) (531.83) (7,314.24) (4,387.87) (6,000.00) 73.13 $ (6,000.00) $ (6,000.00) (90,969.08) (94,415.04) (45,764.57) (91,000.00) 50.29 $ (91,000.00) $ (95,000.00) (29,048.81) (12,245.27) (10,865.51) (21,000.00) 51.74 $ (19,600.00) $ (18,000.00) (90,161.12) 0.00 0.00 0.00 0.00 $ $ (191,496.63) 0.00 0.00 0.00 0.00 $ (191,000.00) $ 0.00 0.00 (6,597.36) 0.00 0.00 $ (50,000.00) $ 0.00 0.00 0.00 0.00 0.00 $ 0.00 0.00 0.00 0.00 0.00 $ (1,286,357.12) (965,943.64) (555,790.90) (1,050,421.00) 52.91 $ (1,445,224.00) $ (1,043,498.00) $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ 0.00 0.00 0.00 0.00 0.00 $ $ $ (791,115.98)L (796,663.41) (791,115.98) (796,663.41) (467,751.36) (467,751.36) (793,000.00) (793,000.00) 58.99 58.99 $ (801,000.00)1$ (801,000.00) 1 $ (801,000.00) $ (801,000.00) $ (909.00) (989.30) (720.00) (1,460.00) 49.32 0.00 0.00 0.00 0.00 0.00 (16,290.59) (556.08) (1,398.31) (2,800.00) 49.94 (538.34) (393.95) (193.80) (400.00) 48.45 0.00 0.00 0.00 (500.00) 0.00 (480.00) 0.00 (285.00) (800.00) 35.63 (503.30) (340.25) (136.33) (300.00) 45.44 (15,798.57) (10,304.29) (5,432.48) (9,700.00) 56.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (34,519.80) (12,583.87) (8,165.92) (15,960.00) 51.16 (2,111,992.90) (1,775,190.92) (1,031,708.18) (1,859,381.00) 55.49 (1,220.00) $ (1,220.00) $ (500.00) $ (2,195.00) $ (500.00) $ (1,000.00) $ (1,000.00) $ (400.00) $ (15,500.00) $ $ (500.00) $ (2,195.00) $ (600.00) $ (500.00) $ (800.00) $ (400.00) $ (10,000.00) (22,315.00) $ (16,215.00) $ 4/1/2011 JAN11\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 9 of 35 MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 45110 - Parks SALARIES & WAGES 45113 - Parks EMPLOYEE BENEFITS 45115 - Parks OVERTIME 45121- Parks SUBSCRIPTIONS & MEMBERSHIPS 45123 - Parks TRAVEL 45124 - Parks OFFICE EXPENSE & SUPPLIES 45125 - Parks EQUIPMENT-SUPPL. & MAINTENANCE 45126 - Parks BLDG/GRDS-SUPPL. & MAINTENANCE 45127 - Parks UTILITIES 45128 - Parks TELEPHONE 45129 - Parks RENTALS 45130 - Parks MONTHLY FUEL - GASCARD 45131- Parks PROFESSIONAL & TECH. SERVICES 45133 - Parks EDUCATION 45135 - Parks OTHER 45146 - Parks SPECIAL DEPARTMENTAL SUPPLIES 45169 - Parks Lease payments 45173 - Parks PARK IMPROVEMENTS 45174- Parks MACHINERY & EQUIPMENT Total Parks Swimming Pool 45210 - MRAC SALARIES & WAGES 45213 - MRAC EMPLOYEE BENEFITS 45215 - MRAC OVERTIME 45221- MRAC SUBSCRIPTIONS & MEMBERSHIPS 45222 - MRAC LEGAL NOTICES/ADVERTISING 45223 - MRAC TRAVEL 45224 - MRAC OFFICE EXPENSE & SUPPLIES 45225 - MRAC EQUIPMENT-SUPPL. & MAINTENANCE 45226 - MRAC BLDG/GRDS-SUPPL. & MAINTENANCE 45227 - MRAC UTILITIES 45228 - MRAC TELEPHONE 45229 - MRAC RENT OF PROPERTY OR EQUIPMENT 45231- MRAC PROFESSIONAL & TECH. SERVICES 45233 - MRAC EDUCATION 45234 - MRAC INSTRUCTIONAL MATERIALS/SUPP. 45235 - MRAC OTHER 45246 - MRAC SPECIAL DEPARTMENTAL SUPPLIES 45261- MRAC SUNDRY EXPENSES -MISCELLANEOUS 45273 - MRAC SWIM PROGRAMS Total Swimming Pool Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved (152,052.28) (147,487.08) (104,190.87) (168,400.00) 61.87 $ (179,754.00) $ (179,754.00) (123,482.83) (140,959.56) (89,369.22) (138,700.00) 64.43 $ (155,739.00) $ (155,000.00) 0.00 0.00 (39.42) (250.00) 15.77 $ (2,685.00) $ (300.00) 0.00 (169.20) (349.95) (450.00) 77.77 $ (450.00) $ (450.00) (487.33) 0.00 0.00 (900.00) 0.00 $ (750.00) $ (600.00) (328.35) (162.85) 0.00 0.00 0.00 $ $ (11,018.41) (9,380.96) (6,421.87) (9,500.00) 67.60 $ (9,500.00) $ (9,500.00) (20,364.36) (16,273.94) (4,245.25) (12,200.00) 34.80 $ (12,200.00) $ (12,200.00) (36,121.15) (34,374.28) (26,231.96) (41,000.00) 63.98 $ (45,000.00) $ (40,000.00) (27.82) (505.26) (257.52) (500.00) 51.50 $ (500.00) $ (600.00) (45.00) (433.13) 85.00 (1,000.00) (8.50) $ (1,000.00) $ (500.00) (12,202.63) (11,122.46) (7,776.13) (12,500.00) 62.21 $ (13,500.00) $ (14,000.00) (1,227.25) (1,945.38) (1,009.75) (3,000.00) 33.66 $ (2,500.00) $ (2,000.00) (899.00) 0.00 (150.00) (1,000.00) 15.00 $ (1,000.00) $ (900.00) (129.41) (582.65) (293.85) (700.00) 41.98 $ (600.00) $ (600.00) (14,672.48) (7,723.34) (4,966.08) (12,000.00) 41.38 $ (12,000.00) $ (11,000.00) (9,514.44) 0.00 0.00 0.00 0.00 $ $ (6,651.00) (4,636.00) 0.00 0.00 0.00 $ $ (4,800.00) 0.00 0.00 0.00 0.00 $ (125,000.00) $ (394,023.74) (375,756.09) (245,216.87) (402,100.00) 60.98 $ (562,178.00) $ (427,404.00) $ - (68,597.28) (26,931.16) (8,704.66) (95,000.00) 9.16 $ (272,244.00) $ (285,000.00) (21,401.71) (2,824.94) (6,480.44) (25,300.00) 25.61 $ (61,457.00) $ (64,000.00) (506.25) (258.33) 0.00 (500.00) 0.00 $ (500.00) $ (500.00) 0.00 0.00 0.00 (200.00) 0.00 $ (300.00) $ (300.00) (738.30) (14.40) (1,401.00) (3,500.00) 40.03 $ (4,000.00) $ (3,000.00) 0.00 0.00 0.00 (250.00) 0.00 $ (1,340.00) $ (1,000.00) (78.72) (0.01) 0.00 (2,500.00) 0.00 $ (2,500.00) $ (2,000.00) (1,556.01) 0.00 (2,058.77) (3,800.00) 54.18 $ (5,500.00) $ (5,500.00) (1,959.52) (249.35) 0.00 (5,000.00) 0.00 $ (6,000.00) $ (12,500.00) (26,941.87) (2,105.47) 0.00 (37,000.00) 0.00 $ (92,000.00) $ (100,000.00) (1,801.22) (693.65) 21.29 (800.00) (2.66) $ (3,200.00) $ (3,200.00) 0.00 (4.90) 0.00 (200.00) 0.00 $ (23,000.00) $ (256.17) (180.00) (140.00) (2,500.00) 5.60 $ (2,000.00) $ (3,000.00) 0.00 0.00 0.00 (500.00) 0.00 $ (700.00) $ (700.00) 0.00 0.00 (65.00) (900.00) 7.22 $ (500.00) $ (500.00) 0.00 (1,187.14) (136.71) (1,200.00) 11.39 $ (1,500.00) $ (1,600.00) (19,345.18) (5,276.06) 0.00 (16,000.00) 0.00 $ (35,000.00) $ (35,000.00) (670.86) (168.95) 0.00 (1,500.00) 0.00 $ (750.00) $ (1,600.00) (2,040.23) (100.00) 0.00 (500.00) 0.00 $ (500.00) $ (500.00) (145,893.32) (39,994.36) (18,965.29) (197,150.00) 9.62 $ (512,991.00) $ (519,900.00) $ 4/1/2011 M2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 10 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 Total Parks, recreation, and public property Community and economic development Film Commission 42810 - Film Comm SALARIES & WAGES 42813 - Film Comm EMPLOYEE BENEFITS 42815 - Film Comm OVERTIME 42821- Film Comm SUBSCRIPTIONS & MEMBERSHIPS 42822 - Film Comm PUBLIC NOTICES 42823 - Film Comm TRAVEL 42824 - Film Comm OFFICE EXPENSE & SUPPLIES 42825 - Film Comm EQUIP./SUPPLIES & MAINTENANCE 42828 - Film Comm TELEPHONE 42830 - Film Comm MONTHLY FUEL - GASCARD 42831- Film Comm PROFESSIONAL & TECH. SERVICES 42833 - Film Comm EDUCATION 42835 - Film Comm OTHER 42846 - Film Comm SPECIAL DEPARTMENTAL SUPPLIES 42874- Film Comm MACHINERY & EQUIPMENT 42875 - Film Comm SPECIAL PROJECTS 42876 - Film Comm GRANT EXPENSES Total Film Commission Community Development 46024 - Econ Dev RECYCLING SERVICES 46026 - Econ Dev ARTS PROMOTION 46075 - Econ Dev SHELTER SERVICES 46076 - MOAB INFORMATION CENTER 46082 - Econ Dev SOUTHEASTERN ASSO. OF GOV. 46084- Econ Dev GRAND COUNTY/4TH JULY FIREWORK Total Community Development Total Community and economic development Debt service 47111- Capital lease - principal 47112 - Capital lease - interest 47121- Capital lease offset - charges to departments Total Debt service Transfers and contributions out Year End Actual YTD Annual Budget % Used Dept. Request (539,917.06) (415,750.45) (264,182.16) (599,250.00) 44.09 Recommended Council Approved (38,213.59) (39,637.18) (24,293.66) (42,600.00) 57.03 $ (43,290.00) $ (43,000.00) (12,601.98) (14,267.92) (12,712.69) (22,100.00) 57.52 $ (22,100.00) $ (27,500.00) 0.00 (464.80) 0.00 (200.00) 0.00 $ (200.00) $ (200.00) (750.00) (1,367.46) (899.20) (1,000.00) 89.92 $ (1,000.00) $ (1,000.00) (1,296.62) (648.20) (264.05) (1,600.00) 16.50 $ (1,900.00) $ (1,600.00) (5,326.32) (4,200.38) (4,511.36) (7,600.00) 59.36 $ (8,500.00) $ (6,500.00) (993.12) (2,789.70) (648.40) (1,800.00) 36.02 $ (1,500.00) $ (1,300.00) (5,837.71) (104.47) 0.00 (500.00) 0.00 $ (500.00) $ (500.00) (693.27) (1,247.58) (718.41) (1,300.00) 55.26 $ (1,300.00) $ (1,300.00) (1,070.16) (588.04) (70.73) (400.00) 17.68 $ (400.00) $ (400.00) 0.00 (2,331.71) 0.00 (500.00) 0.00 $ (500.00) $ (400.00) (438.45) (1,174.00) (700.00) (1,275.00) 54.90 $ (1,000.00) $ (1,000.00) (5.00) (170.77) (33.84) (200.00) 16.92 $ (200.00) $ (100.00) (273.10) (161.64) 0.00 (200.00) 0.00 $ (200.00) $ (100.00) (27,307.00) 0.00 0.00 0.00 0.00 $ $ 0.00 (2,706.84) (1,752.89) (4,550.00) 38.53 $ (4,150.00) $ (3,500.00) 0.00 (4,275.96) (1,065.01) (13,243.00) 8.04 $ (13,243.00) $ (13,243.00) (94,806.32) (76,136.65) (47,670.24) (99,068.00) 48.12 $ (99,983.00) $ (101,643.00) $ (2,000.00) 0.00 0.00 0.00 0.00 (7,000.00) 0.00 (7,000.00) (7,000.00) 100.00 (5,000.00) (5,000.00) (5,000.00) (5,000.00) 100.00 0.00 0.00 0.00 0.00 0.00 (2,500.00) (2,500.00) (2,500.00) (2,500.00) 100.00 (5,000.00) (5,000.00) 0.00 (5,000.00) 0.00 (21,500.00) (12,500.00) (14,500.00) (19,500.00) 74.36 (116,306.32) (88,636.65) (62,170.24) (118,568.00) 52.43 $ - $ S (7,000.00) $ (7,000.00) $ (5,000.00) $ (2,500.00) $ (5,000.00) $ (5,000.00) $ (2,500.00) $ (5,000.00) $ (19,500.00) $ (19,500.00) $ (4,235.43) (404,736.43) 0.00 (105,922.00) 0.00 $ (132,596.00) $ (132,596.00) (17,167.73) (24,467.38) 0.00 (21,262.00) 0.00 $ (17,253.00) $ (17,253.00) 0.00 0.00 0.00 0.00 0.00 (21,403.16) (429,203.81) 0.00 (127,184.00) 0.00 $ (149,849.00) $ (149,849.00) $ 4/1/2011 1:\2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 11 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 48061-TRANS. TO CAPITAL PROJ. FUND 48071 - TRANSFER TO MILLCREEK FUND 48086 - CONTRIBUTION - RECREATION FUND 48090 - TRANSFER TO STORM WATER UTIL 48097 - TRANSFER TO CAPITAL PROJECTS 48098 - CONTRIBUTION TO COMM DEV FUND Total Transfers and contributions out Total Expenditures: Total Change In Net Position Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved (883,000.00) 0.00 0.00 (200,000.00) 0.00 $ - $ - (198,000.00) (92,000.00) 0.00 0.00 0.00 $ (64,900.00) $ (3,500.00) (135,848.00) (136,735.00) 0.00 (134,972.00) 0.00 $ (146,465.00) $ (139,236.00) (800,000.00) 0.00 0.00 0.00 0.00 $ - $ 0.00 0.00 0.00 0.00 0.00 $ - $ (55,000.00) (35,000.00) 0.00 (170,000.00) 0.00 $ (420,000.00) $ (2,071,848.00) (263,735.00) 0.00 (504,972.00) 0.00 $ (631,365.00) $ (142,736.00) $ $ (8,495,558.05) $ (7,392,428.00) $ (8,441,181.65) (6,246,302.43) (3,502,017.09) (6,836,550.00) 51.22 $ (1,218,408.05) $ $ (1,394,781.58) 664,445.99 417,925.10 0.00 0.00 4/1/2011 J:\2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 12 of 35 MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 21 - 21 Class C Road Fund year to date as of June 2010 100.00% of the fiscal year has expired Change In Net Position Revenue: Intergovernmental revenue 33560 - Class C CLASS C ROAD FUND Total Intergovernmental revenue Interest 36100 - Class C INTEREST INCOME 36160 - PROCEEDS FROM LT DEBT Total Interest Contributions and transfers 3650 - Proceeds on sale or trade of fixed assets 39561 - Class C TRANS. FROM EQUITY-B.O.Y. RESV Total Contributions and transfers Total Revenue: Expenditures: Highways and public improvements Highways 40041 - Class C SPECIAL DEPARTMENTAL SUPPLIES 40058 - Class C ROADBASE - PATCHING 40070 - Class C COLD MIX 40071 - Class C CHIP SEAL 40072 - Class C CRACK SEALING 40073 - Class C SPECIAL PROJECTS 40074 - Class C MACHINERY & EQUIPMENT 400810 - LEASE PRINCIPAL 400820-LEASE INTEREST 40169.1 - Class C Equipment capital lease 40169.2 - Class C Capital lease interest Total Highways Total Highways and public improvements Total Expenditures: Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved Prior YTD Current YTD Current YTD Annual Budget Percent Used 177,693.44 177,693.44 177,624.46 177,624.46 92,463.24 92,463.24 180,000.00 180,000.00 51.37 51.37 $ 177,000.00 I $ $ 177,000.00 $ 177,000.00 177,000.00 $ 3,203.36 0.00 2,475.52 0.00 0.00 0.00 3,000.00 0.00 0.00 0.00 $ 3,000.00 $ 3,000.00 3,203.36 2,475.52 0.00 3,000.00 0.00 $ 3,000.00 $ 3,000.00 $ 24,818.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 125,000.00 0.00 $ 20,000.00 $ 20,000.00 24,818.00 0.00 0.00 125,000.00 0.00 $ 20,000.00 $ 20,000.00 $ $ 200,000.00 $ 200,000.00 $ 205,714.80 180,099.98 92,463.24 308,000.00 30.02 (40,532.50) (23,841.37) (8,835.41) (18,000.00) 49.09 (584.62) (1,324.28) (8,728.36) (12,000.00) 72.74 (18,601.50) (9,945.80) (1,377.60) (16,000.00) 8.61 (82,576.40) (119,670.00) 0.00 (157,000.00) 0.00 (39,500.00) (32,688.00) 0.00 (40,000.00) 0.00 (24,814.29) (1,050.00) (54,615.54) (65,000.00) 84.02 (45,166.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (7,803.82) 0.00 0.00 0.00 0.00 (943.03) 0.00 0.00 0.00 0.00 (260,522.16) (188,519.45) (73,556.91) (308,000.00) 23.88 (260,522.16) (188,519.45) (73,556.91) (308,000.00) 23.88 (260,522.16) (188,519.45) (73,556.91) (308,000.00) 23.88 $ (18,000.00) $ (18,000.00) $ (12,000.00) $ (11,000.00) $ (16,000.00) $ (16,000.00) $ (175,231.00) $ (125,000.00) $ (30,000.00) $ (30,000.00) $ (202,000.00) $ (453,231.00) $ (200,000.00) $ $ (453,231.00) $ (200,000.00) $ 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 13 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 1 2008-2009 2009-2010 2010-2011 2011-2012 Total Change In Net Position Year End Actual (54,807.36) (8,419.47) YTD Annual Budget % Used Dept. Request 18,906.33 0.00 0.00 Recommended Council Approved $ (253,231.00) $ $ 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 14 of 35 MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 23 - 23 Recreation Fund year to date as of June 2010 100.00% of the fiscal year has expired Change In Net Position Revenue: Intergovernmental revenue 33561 - GRAND COUNTY - RSSD 33563 - SCHOOL DISTRICT Total Intergovernmental revenue Charges for services 34537 - TOURNAMENT SOFTBALL - MEN'S 34538- TOURNAMENT SOFTBALL -YOUTH 34539 - ADULT SOCCER 34540 - VOLLEYBALL - ADULT COED 34545 - VOLLEYBALL - WOMEN'S 34546 - VOLLEYBALL - YOUTH SPRING 34563 - ADULT COED SOFTBALL 34564 - MENS SOFTBALL 34566-YOUTH/BASEBALL/SOFTBALL 34567-SKI PROGRAM 34568-YOUTH FOOTBALL 34569 - SPRING YOUTH SOCCER 34570 - FALL YOUTH SOCCER 34571 - SOCCER CAMPS 34572-TURKEY TROT 34573 - SMART START 34574-INDOOR SOCCER - YOUTH 34576-JRJAll BASKETBALL 34577 - FLAG FOOTBALL 34578 - MIDDLE SCHOOL FOOTBALL 34579 - FLAG FOOTBALL - ADULT 34580 - YOUTH VOLLEYBALL 34581 - MIDDLE SCHOOL VOLLEYBALL 34583 - YOUTH SPONSOR/BASEBALL 34599 - MIDDLE SCHOOL TRVL BASEBALL 34600- ULTIMATE FRISBEE Total Charges for services Moab arts & recreation 66150- MEMBERSHIP FEES Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved Prior YTD Current YTD Current YTD Annual Budget Percent Used 59,998.00 65,410.00 0.00 58,273.00 0.00 $ 68,295.00 $ 64,052.00 0.00 0.00 0.00 0.00 0.00 59,998.00 65,410.00 0.00 58,273.00 0.00 $ 68,295.00 $ 64,052.00 $ 4,880.00 4,700.00 0.00 5,250.00 0.00 $ 4,875.00 $ 4,875.00 0.00 0.00 0.00 0.00 0.00 $ 661.00 4,212.00 785.00 2,300.00 34.13 $ 2,300.00 $ 2,300.00 1,185.00 460.00 0.00 600.00 0.00 $ 600.00 $ 600.00 845.00 1,190.00 1,050.00 1,080.00 97.22 $ 1,080.00 $ 1,080.00 3,238.00 2,983.00 0.00 2,590.00 0.00 $ $ 1,600.00 700.00 210.00 1,650.00 12.73 $ 1,200.00 $ 1,200.00 0.00 100.00 0.00 300.00 0.00 $ $ 13,719.00 18,889.68 307.51 14,650.00 2.10 $ 14,650.00 $ 14,650.00 0.00 0.00 0.00 0.00 0.00 $ $ 4,123.00 4,093.00 4,022.60 4,370.00 92.05 $ 4,140.00 $ 4,140.00 11,841.00 11,070.00 3,645.00 11,700.00 31.15 $ 11,220.00 $ 11,700.00 2,020.00 2,005.00 2,663.00 2,025.00 131.51 $ 2,392.00 $ 2,390.00 0.00 0.00 0.00 0.00 0.00 $ $ 1,353.00 1,756.00 2,083.65 1,780.00 117.06 $ 2,250.00 $ 2,250.00 0.00 135.00 0.00 0.00 0.00 $ 100.00 $ 100.00 1,595.00 1,245.00 1,049.00 1,380.00 76.01 $ 1,104.00 $ 1,100.00 3,243.00 3,715.50 3,725.00 3,565.00 104.49 $ 3,565.00 $ 3,565.00 970.00 1,025.00 1,185.00 1,010.00 117.33 $ 1,104.00 $ 1,104.00 1,120.00 1,185.00 1,245.00 1,150.00 108.26 $ 1,150.00 $ 1,150.00 240.00 585.00 445.00 480.00 92.71 $ 480.00 $ 480.00 1,990.00 1,905.00 1,618.00 1,930.00 83.83 $ 1,932.00 $ 1,930.00 1,354.45 1,065.00 715.00 1,125.00 63.56 $ 966.00 $ 970.00 8,550.00 9,650.00 550.00 8,800.00 6.25 $ 8,800.00 $ 8,800.00 0.00 0.00 0.00 0.00 0.00 $ 100.00 50.00 0.00 0.00 0.00 $ 64,627.45 72,719.18 25,298.76 67,735.00 37.35 $ 63,908.00 $ 64,384.00 $ 565.00 175.00 125.00 1,000.00 12.50 $ 1,250.00 $ 800.00 4/1/2011 1:\2011V011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 15 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 66160 - PROGRAM FEES 66180 - MATERIALS - TAXABLE 66210 - GRANTS AND DONATIONS 66250 - WORKSHOP FEES 66271 - RENTAL FEES 66372 - SPECIAL EVENTS FEES Total Moab arts & recreation Interest 36100 - INTEREST INCOME Total Interest Miscellaneous revenue 36210-TEEN CENTER DONATIONS/GRANTS 36220-TEEN CENTER PROGRAM FEES 36230 -TEEN CENTER WORKSHOP FEES 36560 - OTHER INCOME 36570 - GRANTS AND DONATIONS 36757 - SAFE PASSAGE GRANT Total Miscellaneous revenue Contributions and transfers 33562 - CITY OF MOAB 39535 - RECREATION FUND BEG. BALANCE 39537 - LOAN FROM GENERAL FUND 39540 - TRANSFER FROM AFTER SCHOOL Total Contributions and transfers Total Revenue: Expenditures: Parks, recreation, and public property Recreation 64010 - Recreation SALARIES - DIRECTOR/ASST. 64013 - Recreation EMPLOYEE BENEFITS 64015 - Recreation OVERTIME 64021 - Recreation SUBSCRIPTIONS & MEMBERSHIPS 64022 - Recreation ADVERTISING 64024 - Recreation OFFICE EXPENSE & SUPPLIES 64028 - Recreation TELEPHONE 64030 - Recreation MONTHLY FUEL- GASCARD 64031 - Recreation PROFESSIONAL & TECHNICAL Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved 7,145.00 3,585.22 381.60 6,400.00 5.96 $ 4,400.00 $ 4,400.00 609.66 139.15 80.72 0.00 0.00 $ $ 100.00 10,450.00 12,043.35 17,518.00 18,000.00 97.32 $ 2,000.00 $ 0.00 0.00 75.00 0.00 0.00 $ $ 21,522.60 19,847.00 16,658.95 21,000.00 79.33 $ 31,000.00 $ 28,000.00 25,384.00 33,465.25 24,836.69 34,950.00 71.06 $ 56,150.00 $ 48,150.00 65,676.26 69,254.97 59,675.96 81,350.00 73.36 $ 94,800.00 $ 81,450.00 $ 885.36 (38.91) 0.00 500.00 0.00 $ 500.00 $ 300.00 885.36 (38.91) 0.00 500.00 0.00 $ 500.00 $ 300.00 $ 31,867.50 23,128.86 9,560.75 24,870.00 38.44 $ 26,047.00 $ 30,551.00 (125.00) 0.00 0.00 0.00 0.00 $ $ 225.00 0.00 30.00 1,000.00 3.00 $ $ 1,789.00 1,342.50 480.00 1,350.00 35.56 $ 1,350.00 $ 1,350.00 5,844.70 2,662.48 0.00 1,000.00 0.00 $ 1,000.00 $ 1,000.00 0.00 12,915.68 23,404.70 33,000.00 70.92 $ 30,587.00 $ 30,587.00 39,601.20 40,049.52 33,475.45 61,220.00 54.68 $ 58,984.00 $ 63,488.00 $ 135,848.00 136,735.00 0.00 136,972.00 0.00 $ 146,465.00 $ 139,236.00 0.00 0.00 0.00 32,000.00 0.00 $ 0.00 0.00 0.00 0.00 0.00 $ 0.00 0.00 0.00 0.00 0.00 $ 135,848.00 136,735.00 0.00 168,972.00 0.00 $ 146,465.00 $ 139,236.00 $ $ 432,952.00 $ 412,910.00 $ 366,636.27 384,129.76 118,450.17 438,050.00 27.04 (65,989.03) (65,176.00) (45,930.23) (74,000.00) 62.07 $ (76,497.00) $ (77,000.00) (45,495.68) (48,160.59) (32,356.03) (53,400.00) 60.59 $ (54,305.00) $ (54,300.00) 0.00 (373.90) 0.00 (200.00) 0.00 $ (200.00) $ (200.00) (224.16) (569.15) (352.41) (355.00) 99.27 $ (340.00) $ (340.00) (2,293.59) (3,006.55) (3,055.90) (3,900.00) 78.36 $ (3,600.00) $ (3,600.00) (2,701.08) (2,418.71) (1,197.99) (1,840.00) 65.11 $ (1,900.00) $ (2,200.00) (2,670.41) (3,495.74) (2,117.61) (3,200.00) 66.18 $ (3,200.00) $ (3,200.00) (44.62) 0.00 0.00 (100.00) 0.00 $ (100.00) $ (100.00) (704.14) (685.00) (210.00) (500.00) 42.00 $ (500.00) $ (500.00) 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 16 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 64033 - Recreation EDUCATION 64035 - Recreation OTHER 64036 - Recreation DIRECTOR - TRAVEL 64037 - Recreation DIRECTOR/EDUCATION 64046 - Recreation SPECIAL DEPARTMENTAL SUPPLIES 64065 - Recreation FINGER -PRINTING 64092 - Recreation TURKEY TROT/EASTER EGG HUNT Total Recreation Ski Program 64102 - SMART START Total Ski Program Soccer 64201-Soccer YOUTH SOCCER 64202 - Soccer FALL SOCCER 64205 - Soccer ADULT 64209 - Soccer INDOOR - YOUTH 64210 - Soccer WAGES 64213 - Soccer SOCCER REFEREE - WAGES 64215 - Soccer INDOOR - YOUTH DIRECTOR Total Soccer Adult Softball 64427 - COED SOFTBALL 64435 - MEN'S SOFTBALL 64436 - MEN'S SOFTBALL TOURN/DIRECTOR 64437 - MEN'S SOFTBALL TOURNAMENT 64438 - MEN'S SOFTBALL TOURN.-UMPIRES Total Adult Softball Adult Volleyball 64601- CO-ED VOLLEYBALL 64602 - VOLLEYBALL 64613 - CO-ED VOLLEYBALL - DIRECTOR 64614 - WOMEN'S VOLLEYBALL - DIRECTOR Total Adult Volleyball Basketball 64804-JRJAZZ BASKETBALL 64805 - JR. JAZZ REFEREE SERVICES 64807 - MS BASKETBALL REFEREES Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved 0.00 (171.32) 0.00 (600.00) 0.00 $ (1,400.00) $ (1,400.00) (71.00) (428.72) (594.79) (595.00) 99.96 $ (550.00) $ (550.00) 0.00 (413.80) (144.43) (400.00) 36.11 $ (300.00) $ (300.00) (215.00) (357.00) 0.00 (450.00) 0.00 $ (550.00) $ (500.00) (533.24) (207.05) 0.00 (450.00) 0.00 $ (300.00) $ (300.00) (1,158.00) (98.00) (399.00) (420.00) 95.00 $ (840.00) $ (840.00) (1,372.39) (1,678.26) (729.17) (1,650.00) 44.19 $ (1,600.00) $ (1,600.00) (123,472.34) (127,239.79) (87,087.56) (142,060.00) 61.30 $ (146,182.00) $ (146,930.00) $ 0.00 0.00 (38.86) (38.86) 0.00 0.00 (50.00) (50.00) 0.00 $ 0.00 (50.00)1 $ (50.00) $ (50.00) (50.00) $ (7,291.52) (6,214.41) (4,092.79) (6,565.00) 62.34 $ (6,565.00) $ (6,565.00) (1,167.80) (1,314.45) (1,001.36) (1,185.00) 84.50 $ (1,180.00) $ (1,180.00) 0.00 (1,048.44) 0.00 (700.00) 0.00 $ (700.00) $ (700.00) (682.30) (392.25) (303.20) (620.00) 48.90 $ (507.00) $ (500.00) (2,363.75) (982.33) (283.64) (3,250.00) 8.73 $ (3,564.00) $ (3,570.00) (204.54) (82.49) 0.00 0.00 0.00 $ - $ (380.00) 0.00 0.00 0.00 0.00 $ $ (12,089.91) (10,034.37) (5,680.99) (12,320.00) 46.11 $ (12,516.00) $ (12,515.00) $ - (203.67) (136.45) (111.00) (830.00) 13.37 $ (630.00) $ (630.00) 0.00 0.00 0.00 (120.00) 0.00 $ (120.00) $ (120.00) 0.00 0.00 0.00 (200.00) 0.00 $ (200.00) $ (200.00) (630.14) (1,047.65) (227.50) (1,530.00) 14.87 $ (1,530.00) $ (1,530.00) (5,452.95) (19.90) 0.00 (2,800.00) 0.00 $ (2,800.00) $ (2,800.00) (6,286.76) (1,204.00) (338.50) (5,480.00) 6.18 $ (5,280.00) $ (5,280.00) $ - (402.94) 0.00 0.00 0.00 0.00 $ (200.00) $ (200.00) 0.00 (206.94) (632.55) (635.00) 99.61 $ (200.00) $ (200.00) (30.43) (269.12) 0.00 (250.00) 0.00 $ (250.00) $ (250.00) (250.00) (275.30) 0.00 (275.00) 0.00 $ (250.00) $ (250.00) (683.37) (751.36) (632.55) (1,160.00) 54.53 $ (900.00) $ (900.00) $ (2,031.38) (2,196.81) (4,859.58) (5,500.00) 88.36 $ (2,555.00) $ (2,555.00) (1,261.53) (1,507.19) (1,448.40) (1,730.00) 83.72 $ (1,728.00) $ (1,730.00) (444.78) 0.00 0.00 0.00 0.00 4/1/2011 J:\2011\2011-12 Budget \Budget Worksheet Detail Working Copy.xlsx Page 17 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 64813 - Basketball EMPLOYEE BENEFITS Total Basketball Youth Volleyball 64901- YOUTH VOLLEYBALL 64902 - MIDDLE SCHOOL VOLLEYBALL 64903 - MIDDLE SCHOOL VOLLEYBALL 64904 - YOUTH SPRING VOLLEYBALL - WAGES 64905 - YOUTH SPRING VOLLEYBALL Total Youth Volleyball Youth Baseball/Softball 65111-Youth BB/SB WAGES- MAINTENANCE WORKERS 65112 -Youth BB/SB WAGES- UMPIRES & SCOREKEEPERS 65113 -Youth BB/SB EMPLOYEE BENEFITS 65123 - Youth BB/SB BASEBALL STATE TOURN. EXPENSES 65125-Youth BB/SB EQUIPMENT -SUPPLIES & MAINT. 65126 - Youth BB/SB BASEBALL FIELD MAINTENANCE 65158 - MIDDLE SCHOOL TRVL BASEBALL 65173 - FIELD MAINTENANCE EQUIPMENT 65174-YOUTH BASEBALL/SOFTBALL 65177 - UTAH GIRLS SOFTBALL ASSOC 65178 - UTAH BOYS BASEBALL ASSOCIATION Total Youth Baseball/Softball Youth Football 65213-Youth Football BENEFITS 65275-YOUTH FOOTBALL 65280 - FLAG FOOTBALL 65281- FLAG FOOTBALL - ADULT 65285 - MIDDLE SCHOOL FOOTBALL 65286 - YOUTH FOOTBALL REFEREES 65295 - MS FOOTBALL REFEREES Total Youth Football BMX 65410 - BMX WAGES 65424 - BMX MATERIALS & SUPPLIES Total BMX Special Projects 66046 - SPECIAL PROJECTS Year End Actual (133.59) (3,871.28) (152.84) (3,856.84) YTD Annual Budget % Used Dept. Request (146.57) (6,454.55) (135.00) (7,365.00) 108.57 87.64 Recommended Council Approved $ (150.00)1 $ $ (4,433.00) $ (150.00) (4,435.00) $ (1,176.02) (1,396.47) (1,121.24) (1,270.00) 88.29 $ (1,650.00) $ (1,650.00) (1,491.34) (768.05) (1,678.60) (1,680.00) 99.92 $ (1,631.00) $ (1,630.00) (50.00) 0.00 0.00 0.00 0.00 $ - $ (1,247.51) (2,025.24) 0.00 (1,129.00) 0.00 $ - $ 0.00 0.00 (400.53) (401.00) 99.88 $ - $ (3,964.87) (4,189.76) (3,200.37) (4,480.00) 71.44 $ (3,281.00) $ (3,280.00) $ (2,610.81) (1,846.42) (341.25) (3,900.00) 8.75 $ (3,600.00) $ (3,600.00) (6,640.53) (8,228.38) (1,716.92) (6,400.00) 26.83 $ (6,850.00) $ (6,850.00) (968.50) (954.18) (208.35) (800.00) 26.04 $ (900.00) $ (900.00) (2,248.92) (223.14) (2,498.51) (2,500.00) 99.94 $ (2,500.00) $ (2,500.00) 0.00 (173.38) 0.00 (150.00) 0.00 $ (150.00) $ (150.00) (274.81) (111.44) (50.00) (300.00) 16.67 $ (300.00) $ (300.00) 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ (14,646.49) (17,879.63) (728.13) (14,000.00) 5.20 $ (14,000.00) $ (14,000.00) 0.00 0.00 0.00 (540.00) 0.00 $ (540.00) $ (540.00) (935.00) (920.00) 0.00 (600.00) 0.00 $ (600.00) $ (600.00) (28,325.06) (30,336.57) (5,543.16) (29,190.00) 18.99 $ (29,440.00) $ (29,440.00) $ - (61.47) (356.85) (72.67) (350.00) 20.76 $ (350.00) $ (350.00) (2,916.78) (2,224.08) (7,851.43) (7,852.00) 99.99 $ (3,198.00) $ (3,200.00) (737.48) (631.97) (967.25) (968.00) 99.92 $ (830.00) $ (830.00) 0.00 0.00 0.00 (75.00) 0.00 $ (75.00) $ (75.00) (983.97) (805.65) (1,688.85) (1,760.00) 95.96 $ (995.00) $ (1,000.00) (235.14) (624.80) (772.29) (775.00) 99.65 $ (720.00) $ (720.00) (270.09) (581.30) (177.80) (250.00) 71.12 $ (288.00) $ (290.00) (5,204.93) (5,224.65) (11,530.29) (12,030.00) 95.85 $ (6,456.00) $ (6,465.00) $ (250.00) 0.00 0.00 (150.00) 0.00 $ (150.00) $ (150.00) 0.00 (250.00) 0.00 0.00 0.00 0.00 (75.00) (225.00) 0.00 0.00 $ (75.00) $ (75.00) (225.00) $ (225.00) $ (2,972.83) (824.04) (24,881.80) (33,400.00) 74.50 $ (21,395.00)1 $ (1,400.00) 4/1/2011 JA2011\2011-12 Budget \Budget Worksheet Detail Working Copy.xlsx Page 18 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 Total Special Projects Teen Center 70010 - Teen Center 70013 - Teen Center 70021 - Teen Center 70022 - Teen Center 70023 - Teen Center 70025 - Teen Center 70028 - Teen Center 70031 - Teen Center 70033 - Teen Center 70035 - Teen Center 70046 - Teen Center 70078 - Teen Center 70079 - Teen Center Total Teen Center SALARIES & WAGES EMPLOYEE BENEFITS SUBSCRIPTIONS & MEMBERSHIPS PUBLIC NOTICES TRAVEL EQUIP/SUPPLIES & MAINTENANCE TELEPHONE PROFESSIONAL/TECHNICAL SERVICE EDUCATION OTHER SPECIAL DEPARTMENTAL SUPPLIES SPECIAL PROJECTS PROGRAMS Moab Arts & Recreation Center 80010 - MARC SALARIES & WAGES 80013 - MARC EMPLOYEE BENEFITS 80014 - MARC SALARIES & WAGES - INSTRUCTORS 80015 - MARC SALARIES & WAGES OT 80021 - MARC SUBSCRIPTIONS & MEMBERSHIPS 80022 - MARC PUBLIC NOTICES 80023 - MARC TRAVEL 80024 - MARC OFFICE EXPENSE & SUPPLIES 80025 - MARC EQUIP/SUPPLIES & MAINTENANCE 80027 - MARC UTILITIES 80028 - MARC TELEPHONE 80031 - MARC PROFESSIONAL/TECHNICAL SERVICE 80033 - MARC EDUCATION 80035 - MARC OTHER 80046 - MARC SPECIAL DEPARTMENTAL SUPPLIES 80077 - MARC SPECIAL EVENTS 80078 - MARC SPECIAL PROJECTS Total Moab Arts & Recreation Center Communities That Care (CTC) 75010 - SALARIES & WAGES 75013 - EMPLOYEE BENEFITS 75023-TRAVEL Year End Actual (2,972.83)1 (824.04) YTD Annual Budget % Used Dept. Request (24,881.80) (33,400.00) 74.50 $ (21,395.00) $ Recommended (1,400.00) $ Council Approved (20,846.33) (30,466.66) (19,481.09) (32,660.00) 59.65 $ (34,372.00) $ (34,380.00) (2,563.95) (3,119.87) (1,971.52) (3,030.00) 65.07 $ (2,702.00) $ (2,700.00) 0.00 0.00 (27.75) 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 (1,502.20) (22.93) (1,450.00) 1.58 $ (1,700.00) $ (1,700.00) 0.00 0.00 0.00 (500.00) 0.00 $ (200.00) $ (200.00) (2,416.48) (2,811.91) (1,543.62) (2,600.00) 59.37 $ (3,060.00) $ (3,050.00) (8,442.24) (8,400.00) 0.00 (8,500.00) 0.00 $ (8,500.00) $ (8,500.00) 0.00 (810.00) 0.00 (700.00) 0.00 $ (900.00) $ (900.00) 0.00 (45.55) (541.68) (200.00) 270.84 $ (200.00) $ (200.00) (1,515.54) (6,645.13) (1,546.59) (3,900.00) 39.66 $ (5,000.00) $ (5,000.00) (8,474.00) (1,050.00) 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ (44,258.54) (54,851.32) (25,135.18) (53,540.00) 46.95 $ (56,634.00) $ (56,630.00) $ (45,032.05) (50,545.14) (23,034.98) (46,150.00) 49.91 $ (57,383.00) $ (51,000.00) (26,993.68) (27,426.51) (10,793.30) (20,200.00) 53.43 $ (31,277.00) $ (21,600.00) (3,475.08) (2,142.29) (157.70) (4,900.00) 3.22 $ (3,400.00) $ (3,400.00) 0.00 (1,163.97) 0.00 0.00 0.00 $ $ 0.00 0.00 (200.00) (500.00) 40.00 $ (400.00) $ (400.00) (3,373.47) (4,521.66) (144.00) (2,900.00) 4.97 $ (2,800.00) $ (2,800.00) (599.76) 10.00 (260.42) 0.00 0.00 $ $ (1,566.28) (1,371.29) (1,432.35) (3,000.00) 47.75 $ (2,000.00) $ (2,000.00) (3,189.00) (4,093.92) (2,675.02) (3,900.00) 68.59 $ (4,100.00) $ (4,100.00) (7,326.78) (7,380.59) (3,084.07) (6,300.00) 48.95 $ (6,300.00) $ (6,500.00) (2,329.88) (3,183.17) (1,727.73) (2,600.00) 66.45 $ (2,712.00) $ (2,800.00) (682.85) (226.43) (1,149.85) (1,500.00) 76.66 $ (1,500.00) $ (1,300.00) (280.00) (50.00) 0.00 0.00 0.00 $ $ 0.00 (224.27) (350.62) 0.00 0.00 $ (500.00) $ (400.00) (4,408.61) (1,092.49) (611.43) (2,000.00) 30.57 $ (2,000.00) $ (2,000.00) (37,812.89) (44,240.27) (33,753.52) (33,800.00) 99.86 $ (44,200.00) $ (37,000.00) 0.00 0.00 0.00 0.00 0.00 $ $ (137,070.33) (147,652.00) (79,374.99) (127,750.00) 62.13 $ (158,572.00) $ (135,300.00) $ 0.00 0.00 0.00 (3,400.00) 0.00 $ (3,300.00) $ (3,300.00) 0.00 0.00 0.00 (250.00) 0.00 $ (260.00) $ (260.00) 0.00 0.00 0.00 (300.00) 0.00 $ (4,000.00) $ (4,000.00) 4/1/2011 1:\2011V011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 19 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 75025 - EQUIP/SUPPLIES & MAINTENANCE 75031 - PROFESSIONAL & TECHNICAL SERVICES 75033 - EDUCATION 75035 - OTHER 75046 - SPECIAL DEPARTMENTAL SUPPLIES 75078 - SPECIAL PROJECTS Total Communities That Care (CTC) Total Parks, recreation, and public property Total Expenditures: Total Change In Net Position Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved 0.00 0.00 0.00 (100.00) 0.00 $ (800.00) $ (800.00) 0.00 0.00 0.00 (500.00) 0.00 $ (1,500.00) $ (1,500.00) 0.00 0.00 0.00 (350.00) 0.00 $ $ 0.00 0.00 0.00 (350.00) 0.00 $ $ 0.00 0.00 0.00 (750.00) 0.00 $ (200.00) $ (200.00) 0.00 0.00 0.00 (3,000.00) 0.00 $ $ 0.00 0.00 0.00 (9,000.00) 0.00 $ (10,060.00) $ (10,060.00) $ $ (455,424.00) $ (412,910.00) $ (368,450.22) (386,203.56) (249,859.94) (438,050.00) 57.04 (368,450.22) (386,203.56) (249,859.94) (438,050.00) 57.04 $ (22,472.00) $ $ (1,813.95) (2,073.80) (131,409.77) 0.00 0.00 4/1/2011 1:\2011V011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 20 of 35 MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 24 - 24 Community Development year to date as of June 2010 100.00% of the fiscal year has expired Change In Net Position Revenue: Contributions and transfers 39209 - COMMUNITY DEV. FUND/BEG. BAL. 39210 - CONTRIBUTION FROM GENERAL FUND 39223 - GRANTS 39224 - CDGB '05 MOONSTONE GALLERY 39226 - UTAH POWER GRANT 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 Total Revenue: Expenditures: Community Development Community development 40002 - TEA-21 UDOT N. CORRIDOR PATHS 40003 - CDBG 09 VIRGINIAN APARTMENTS 40004 - ROTARY PARK 40005 - LIONS PARK TE 2011 40006 - NORTH CORRIDOR PATH 40007 - LIONS PARK DESIGN 40008 - LIONS PARK LAND & WATER CONSERV FUND GRANT 40009 - LIONS PARK SCENIC BYWAYS GRANT 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 Year End Actual YTD Annual Budget % Used Dept. Request Prior YTD Current YTD Current YTD Annual Budget Percent Used Recommended Council Approved 0.00 0.00 0.00 20,000.00 0.00 $ 162,450.00 $ 505,000.00 55,000.00 35,000.00 0.00 170,000.00 0.00 $ 420,000.00 $ $ 1,026,000.00 $ 1,180,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 28,348.00 0.00 0.00 0.00 0.00 39,274.23 47,037.00 0.00 0.00 0.00 0.00 0.00 0.00 233,627.00 0.00 0.00 0.00 0.00 500,000.00 0.00 $ 500,000.00 $ 0.00 0.00 0.00 0.00 0.00 0.00 0.00 24,240.00 100,000.00 24.24 122,622.23 82,037.00 24,240.00 1,023,627.00 2.37 $ 2,108,450.00 $ 1,685,000.00 $ 122,622.23 82,037.00 24,240.00 1,023,627.00 2.37 $ 2,108,450.00 $ 1,685,000.00 $ 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (233,627.00) 0.00 0.00 0.00 (2,375.00) (25,000.00) 9.50 $ (215,000.00) $ (190,000.00) 0.00 0.00 0.00 (620,000.00) 0.00 $ (620,000.00) $ (120,000.00) 0.00 0.00 0.00 0.00 0.00 0.00 (27,876.00) (52,560.00) (100,000.00) 52.56 $ (346,000.00) $ (350,000.00) $ (900,000.00) $ (1,000,000.00) (9,402.69) 0.00 0.00 0.00 0.00 (93,105.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (5,000.00) 0.00 $ (5,000.00) $ (5,000.00) (5,372.18) 0.00 0.00 (10,000.00) 0.00 $ (10,000.00) $ (10,000.00) (31,747.85) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4/1/2011 1:\2011V011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 21 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 1 2008-2009 2009-2010 2010-2011 2011-2012 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 Total Community Development Total Expenditures: Total Change In Net Position Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (17,550.00) (20,000.00) 87.75 $ (2,450.00) $ 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (10,000.00) 0.00 $ (10,000.00) $ (10,000.00) 0.00 (11,616.55) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (139,627.72) (39,492.55) (72,485.00) (1,023,627.00) 7.08 $ (2,108,450.00) $ (1,685,000.00) $ $ (2,108,450.00) $ (1,685,000.00) $ (139,627.72) (39,492.55) (72,485.00) (1,023,627.00) 7.08 (139,627.72) (39,492.55) (72,485.00) (1,023,627.00) 7.08 $ $ $ (17,005.49) 42,544.45 (48,245.00) 0.00 0.00 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 22 of 35 MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 28 - 28 Millcreek Project Fund year to date as of June 2010 100.00% of the fiscal year has expired 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 Total Intergovernmental revenue Contributions and transfers 33210 - CONTRIBUTION FROM GENERAL FUND 39210- MILLCREEK PROD. 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/FUEL/REDUCTION/REVEG 40003 - MILLCREEK/MAIN STREET - WEIR 40004 - UTAH TRAILS 500 W. UNDERPASS 40005 - UTAH TRAILS PIPE DREAM 40010 - SALARIES 40013 - BENEFITS 40031 - PROFESSIONAL/TECHNICAL 40035 - OTHER 40041 - ACQUISITIONS 40048 - BMX TRACK 40050 - BROWNING ROTARY MUSICAL PLAYGROUND GRANT 40051 - BROWNING TRAILS GRANT 40074 - SPECIAL PROD. -FENCING & IMPROV 40076 - TREE EDUCATION/ADVERTISING Year End Actual YTD Annual Budget % Used Dept. Request Prior YTD Current YTD Current YTD Annual Budget Percent Used Recommended Council Approved 2,552.12 6,473.94 30,528.93 3,000.00 1,017.63 $ 63,000.00 $ 40,000.00 0.00 131,835.00 (131,835.00) 0.00 0.00 0.00 50,000.00 196,835.00 0.00 0.00 0.00 0.00 0.00 50,400.00 0.00 0.00 0.00 0.00 26,500.00 0.00 2,552.12 188,308.94 95,528.93 79,900.00 119.56 $ 63,000.00 $ 40,000.00 $ 198,000.00 92,000.00 0.00 0.00 0.00 $ 64,900.00 $ 3,500.00 0.00 0.00 0.00 112,900.00 0.00 $ 20,000.00 198,000.00 92,000.00 0.00 112,900.00 0.00 $ 64,900.00 $ 23,500.00 $ $ 127,900.00 $ 63,500.00 $ 200,552.12 280,308.94 95,528.93 192,800.00 49.55 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (1,845.00) (5,000.00) 0.00 (5,000.00) 0.00 $ (35,000.00) $ (31,000.00) (12,543.50) (16,623.00) 0.00 0.00 0.00 $ (1,350.00) (35,800.00) (4,307.00) (52,400.00) 8.22 $ 0.00 (2,812.50) 0.00 (6,500.00) 0.00 $ (2,000.00) $ (1,000.00) 0.00 (6,138.15) (23,380.49) (37,000.00) 63.19 $ (10,000.00) $ (4,500.00) 0.00 (621.20) (2,366.11) (3,000.00) 78.87 $ (2,000.00) $ (500.00) (1,100.00) 0.00 (3,013.92) (900.00) 334.88 $ (900.00) $ (500.00) 0.00 0.00 0.00 0.00 0.00 $ (104,907.00) 0.00 0.00 (25,000.00) 0.00 $ (25,000.00) $ (3,098.12) 0.00 0.00 0.00 0.00 $ (5,000.00) $ (1,000.00) 0.00 0.00 0.00 0.00 0.00 $ (5,000.00) $ (5,000.00) 0.00 0.00 0.00 0.00 0.00 $ (10,000.00) $ (15,000.00) (10,998.13) (8,457.47) (2,141.62) (57,000.00) 3.76 $ (10,000.00) $ (2,000.00) 0.00 0.00 (1,000.00) (1,000.00) 100.00 $ 4/1/2011 1:\2011V011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 23 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 40086 - TREES/IRRIGATION 40088 - UTAH TRAILS MILLCREEK DR PATH Total Millcreek Total Millcreek Projects Total Expenditures: Total Change In Net Position Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved (7,560.73) (618.50) 0.00 (5,000.00) 0.00 $ (8,000.00) $ (3,000.00) (420.00) (285,106.57) (29,500.00) 0.00 0.00 (143,822.48) (361,177.39) (65,709.14) (192,800.00) 34.08 $ (112,900.00) $ (63,500.00) $ $ (112,900.00) $ (63,500.00) $ - (143,822.48) (361,177.39) (65,709.14) (192,800.00) 34.08 (143,822.48) (361,177.39) (65,709.14) (192,800.00) 34.08 $ 15,000.00 $ $ - 56,729.64 (80,868.45) 29,819.79 0.00 0.00 4/1/2011 J:\2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 24 of 35 MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 41 - 41 Capital Projects Fund year to date as of June 2010 100.00% of the fiscal year has expired Change In Net Position Revenue: Intergovernmental revenue 36124 - GRANTS AND DONATIONS 36125 - DOG PARK DONATIONS Total Intergovernmental revenue Interest 36100 - INTEREST INCOME Total Interest Miscellaneous revenue 36160 - CIB LOAN 36165 - PROCEEDS FROM LONG TERM DEBT 36200 - ANIMAL SHELTER DONATIONS 36201- TRANS ENHANCE GRANT 36210 - CIB GRANT 36220 - LEASE REVENUE CITY CENTER 36225 - MORTGAGE PRNCPAL OLD CITY HALL 36226 - MORTGAGE INTEREST OLD CITY HL 36227 - UTAH STATE ENERGY PROGRAM GRANT 36228 - UTAH POWER GRANT 36229 - Federal Highway gramt 36230 - LIBRARY CITY CENTER CONTR 36235 - CIB LOAN AQUATIC CENTER 36236 - CONTRIBUTION FROM REC DISTRICT 36237 - DEVELOPER FEES Total Miscellaneous revenue Contributions and transfers 39222 -TRANSFER FROM GENERAL FUND 39561 - CAPITAL PROJECTS FUND BEG. BAL Total Contributions and transfers Total Revenue: Expenditures: Public safety Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved Prior YTD Current YTD Current YTD Annual Budget Percent Used 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25,000.00 0.00 0.00 0.00 0.00 25,000.00 0.00 $ $ $ 13,160.31 37,814.70 10,680.26 13,000.00 82.16 13,160.31 37,814.70 10,680.26 13,000.00 82.16 $ $ $ 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $ 125,000.00 1,452.80 1,856.00 50.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 42,374.60 46,726.33 39,578.58 42,300.00 93.57 $ 46,800.00 $ 46,800.00 14,940.79 16,100.68 9,963.22 17,360.00 57.39 $ 18,000.00 $ 18,000.00 38,470.01 37,310.12 21,193.08 36,056.00 58.78 $ 35,000.00 $ 35,000.00 0.00 0.00 0.00 225,000.00 0.00 $ 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $ 120,000.00 0.00 0.00 0.00 0.00 0.00 0.00 4,764,000.00 0.00 0.00 0.00 0.00 1,615,000.00 190,000.00 191,000.00 99.48 $ 191,000.00 $ 191,000.00 0.00 135,389.49 0.00 0.00 0.00 97,238.20 6,616,382.62 260,784.88 511,716.00 50.96 $ 290,800.00 $ 535,800.00 $ 883,000.00 0.00 0.00 200,000.00 0.00 0.00 0.00 0.00 5,726,284.00 0.00 $ 418,200.00 883,000.00 0.00 0.00 5,926,284.00 0.00 $ $ 418,200.00 $ 993,398.51 6,654,197.32 271,465.14 6,476,000.00 4.19 $ 290,800.00 $ 954,000.00 $ 4/5/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 25 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 Animal Shelter 79140 - ANIMAL SHELTER PROJECT 79141-ANIMAL SHELTER EQUIPMENT 79142- ANIMAL SHELTER FF&E Total Animal Shelter Total Public safety Highways and public improvements Highways 42577 - STRMWTR DETENTION BASIN PROJ 44072 - STREETS/SPECIAL PROD./CONCRETE 44076 - MAIN STREET IMPROVEMENTS 44077 - 500 WEST/KANE CREEK IMPROVE 44078 -TFER TO ROAD IMPROVE SETASIDE 44079 -100 NORTH STREET IMPROVEMENTS 44080 - TRANSPORTATION MASTER PLAN EQUIPMENT Bartlett Street Improvements 400 North from Main to 100 West Improvements Total Highways Total Highways and public improvements Parks, recreation, and public property Parks 44082 - WILLIAMS WAY ROAD RECONSTRUCTION 78043 - SWANNY PARK RESTROOMS 78045 - PLAYGROUND EQUIPMENT/IMPROVEMENTS Total Parks Recreation 45070 - ADA IMPROVEMENTS Total Recreation Swimming Pool 47070 - AQUATIC CENTER PROJECT 47071- AQUATIC CENTER SET ASIDE 47098 - CONTRIBUTION TO CIB ESCROW Total Swimming Pool Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved (10,928.28) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $ (25,000.00) $ (25,000.00) 0.00 0.00 0.00 0.00 0.00 (10,928.28) 0.00 0.00 0.00 0.00 $ (25,000.00) $ (25,000.00) $ (10,928.28) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (19,273.00) 0.00 0.00 0.00 $ (50,000.00) $ (50,000.00) 0.00 0.00 0.00 0.00 0.00 $ $ (2,840.50) (493,923.20) (8,455.20) (15,000.00) 56.37 $ (35,000.00) 0.00 0.00 0.00 0.00 0.00 $ $ (388,464.79) 0.00 0.00 0.00 0.00 $ $ - 0.00 0.00 0.00 (45,000.00) 0.00 $ $ $ (191,000.00) $ (316,000.00) $ - $ (52,000.00) $ (55,000.00) $ (100,000.00) $ (110,000.00) (391,305.29) (513,196.20) (8,455.20) (60,000.00) 14.09 $ (393,000.00) $ (566,000.00) (391,305.29) (513,196.20) (8,455.20) (60,000.00) 14.09 0.00 0.00 (285,000.00) (285,000.00) 100.00 $ $ - $ - 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 (55,000.00) 0.00 $ $ - 0.00 0.00 (285,000.00) (340,000.00) 83.82 $ $ - (6,726.00) 0.00 0.00 0.00 0.00 (6,726.00) 0.00 0.00 0.00 0.00 (43,521.71) (2,517,472.53) (2,739,208.64) (5,498,000.00) 49.82 $ - $ (25,000.00) $ 0.00 0.00 0.00 (191,000.00) 0.00 $ - $ - 0.00 0.00 0.00 0.00 0.00 $ - $ - (43,521.71) (2,517,472.53) (2,739,208.64) (5,689,000.00) 48.15 $ - $ (25,000.00) 4/5/2011 J:\2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 26 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 Special Projects 79044- PERFORMANCE GURANTEE DEFAULT IMPROVEMENTS Total Special Projects Moab Arts & Recreation Center 46070 - ROOF PROJECT 46071- SOLAR PROJECT 46072 - MARC BUILDING IMPROVEMENTS Total Moab Arts & Recreation Center Total Parks, recreation, and public property Community and economic development Senior Assisted Living 79042 - MAPS - ASSISTED LIVING PROJECT 79043 - IMPACT FEE OFFSET Total Senior Assisted Living Total Community and economic development 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 77042 - PUBLIC BLDG BOND RESERVE 77045 - MUNICIPAL BLDG FF&E 77046.1- MUNICIPAL BLDG BOND PMT 77046.2 - Municipal Bldg bond interest 77047.1- 2009 Aquatic Bond Payment 77050- TENANT IMPROVEMENTS 77055 - CITY HALL SOLAR PHOTO VOLTAIC 77056 - DOG PARK Total Municipal Building Total Municipal Building Authority Total Expenditures: Year End Actual YTD Annual Budget % Used Dept. Request 0.00 0.00 0.00 0.00 (84,634.55) (84,634.55) 0.00 0.00 0.00 0.00 Recommended Council Approved $ (15,000.00)1 $ (15,000.00) $ (15,000.00) $ (15,000.00) (38,521.65) 0.00 0.00 0.00 0.00 $ $ - $ (46,620.30) 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ (155,000.00) $ (20,000.00) (85,141.95) 0.00 0.00 0.00 0.00 $ (155,000.00) $ (20,000.00) (135,389.66) (2,517,472.53) (3,108,843.19) (6,029,000.00) 51.56 S 0.00 0.00 0.00 0.00 0.00 $ - $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ (1,580.55) (10,641.50) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (65,000.00) (66,000.00) (68,000.00) (68,000.00) 100.00 (46,625.00) (45,000.00) (43,350.00) (44,000.00) 98.52 0.00 0.00 0.00 0.00 0.00 (24,409.74) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (250,000.00) 0.00 0.00 0.00 0.00 (25,000.00) 0.00 (137,615.29) (121,641.50) (111,350.00) (387,000.00) 28.77 (137,615.29) (121,641.50) (111,350.00) (387,000.00) 28.77 (675,238.52) (3,152,310.23) (3,228,648.39) (6,476,000.00) 49.86 $ (69,000.00) $ (43,000.00) $ (191,000.00) $ (69,000.00) $ (43,000.00) $ (191,000.00) (303,000.00) $ (303,000.00) (891,000.00) $ (954,000.00) 4/5/2011 J:\2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 27 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 Total Change In Net Position Year End Actual 318,159.99 3,501,887.09 YTD Annual Budget % Used Dept. Request (2,957,183.25) 0.00 0.00 Recommended Council Approved $ (600,200.00) $ $ 4/5/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 28 of 35 MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 51 - 51 Water & Sewer Fund year to date as of June 2010 100.00% of the fiscal year has expired Income or Expense Income From Operations: Water Operating Income 36300 - WATER PENALTIES 36500 - SALE OF MATERIALS & SUPPLIES 36900 - Water SUNDRY REVENUES 37100 - WATER SALES 37120 - TAX ON SHOP WATER SALES 37260 - WATER CONNECTION 38600 - ALLOWANCE ON DOUBTFUL ACCOUNTS Total Water Operating Income Sewer Operating Income 56900 - Sewer SUNDRY REVENUE 57300 - SEWER SERVICES CHARGES 57325 - Sewer SPECIAL SERVICES BY CITY DEPTS 57350 - Sewer SPANISH VALLEY SEWER 57440 - SEWER CONNECTION Total Sewer Operating Income Water Operating expense 37325 - Water SPECIAL SERVICES BY CITY DEPATMENTS 50009 - Water GENERAL FUND O/H 50010 - Water SALARIES & WAGES 50013 - Water EMPLOYEE BENEFITS 50015 - Water OVERTIME 50021 - Water SUBSCRIPTIONS & MEMBERSHIPS 50023 - Water TRAVEL 50024 - Water OFFICE EXPENSE & SUPPLIES 50025 - Water EQUIPMENT-SUPPL. & MAINTENANCE 50026 - Water BUILDING SUPPL. & MAINTENANCE 50027 - Water UTILITIES 50028 - Water TELEPHONE 50029.1 - Water RENT OF PROPERTY & EQUIPMENT 50029.2 - Water capital lease expense 50030 - Water MONTHLY FUEL- GASCARD 50031 - Water PROFESSIONAL & TECH. SERVICES 50033 - Water WATER/EDUCATION Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved Prior YTD Current YTD Current YTD Annual Budget Percent Used 1,421.70 2,947.77 2,204.04 500.00 440.81 $ $ 2,000.00 0.00 0.00 0.00 0.00 0.00 $ $ 4,014.47 2,704.62 925.72 2,000.00 46.29 $ $ 2,000.00 505,406.06 512,380.93 335,370.29 520,000.00 64.49 $ $ 530,000.00 (971.09) 382.22 48.91 200.00 24.46 $ $ 200.00 9,573.60 3,038.43 2,187.98 5,000.00 43.76 $ $ 5,000.00 0.00 (2,088.01) (273.08) 0.00 0.00 $ $ 519,444.74 519,365.96 340,463.86 527,700.00 64.52 $ $ 539,200.00 $ 63,086.03 36,676.61 29,797.34 50,000.00 59.59 $ $ 50,000.00 518,633.51 521,430.64 315,889.80 520,000.00 60.75 $ $ 520,000.00 6,200.08 10,760.93 1,226.92 5,000.00 24.54 $ $ 5,000.00 147,632.80 149,253.00 88,597.96 145,000.00 61.10 $ $ 149,000.00 4,020.00 1,836.70 0.00 4,000.00 0.00 $ $ 4,000.00 739,572.42 719,957.88 435,512.02 724,000.00 60.15 $ $ 728,000.00 $ 0.00 0.00 161.04 0.00 0.00 $ (150,000.00) (150,000.00) 0.00 (173,000.00) 0.00 $ $ (175,000.00) (152,931.36) (174,426.38) (117,410.46) (187,000.00) 62.79 $ (204,737.00) $ (205,000.00) (96,177.17) (113,726.94) (72,176.29) (114,000.00) 63.31 $ (134,533.00) $ (134,000.00) (3,854.26) (6,489.94) (3,118.82) (5,000.00) 62.38 $ (9,175.00) $ (6,000.00) (2,124.18) (2,407.85) (1,769.12) (2,600.00) 68.04 $ (4,000.00) $ (3,800.00) (1,988.98) (2,232.28) (1,625.80) (1,500.00) 108.39 $ (4,000.00) $ (3,000.00) (180.50) (585.35) 0.00 (800.00) 0.00 $ $ (9,773.40) (7,723.95) (5,841.50) (11,000.00) 53.10 $ (12,500.00) $ (12,500.00) (727.35) (450.87) (927.55) (3,000.00) 30.92 $ (13,000.00) $ (13,000.00) (28,136.63) (31,521.98) (19,978.68) (33,000.00) 60.54 $ (31,500.00) $ (33,000.00) (1,820.29) (1,853.39) (1,154.73) (2,000.00) 57.74 $ (2,500.00) $ (2,500.00) (2,107.00) (2,202.00) (2,107.00) (4,100.00) 51.39 $ (4,100.00) $ (4,100.00) (4,235.43) 0.00 0.00 0.00 0.00 $ $ (10,679.03) (11,452.32) (6,851.68) (12,000.00) 57.10 $ (13,500.00) $ (13,500.00) (7,177.09) (11,083.23) (6,744.91) (13,500.00) 49.96 $ (16,500.00) $ (12,500.00) (1,630.00) (1,775.00) (1,795.00) (2,800.00) 64.11 $ (2,800.00) $ (2,800.00) 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 29 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 50035 - Water OTHER 50046 - Water SPECIAL DEPARTMENTAL SUPPLIES 50051 - Water INSURANCE 50069 - Water DEPRECIATION Total Water Operating expense Sewer Operating expense 60009 - Sewer GENERAL FUND O/H 60010 - Sewer SALARIES & WAGES 60013 - Sewer EMPLOYEE BENEFITS 60015 - Sewer OVERTIME 60021 - Sewer SUBSCRIPTIONS & MEMBERSHIPS 60023-Sewer TRAVEL 60024 - Sewer OFFICE EXPENSE & SUPPLIES 60025 - Sewer EQUIPMENT SUPPL. & MAINTENANCE 60026 - Sewer BUILDING SUPPL. & MAINTENANCE 60027 - Sewer UTILITIES 60028 - Sewer TELEPHONE 60029 - Sewer RENT OF PROPERTY & EQUIPMENT 60030 - Sewer MONTHLY FUEL - GAS CARD 60031 - Sewer PROFESSIONAL & TECH. SERVICES 60033 - Sewer EDUCATION 60035 - Sewer OTHER 60046 - Sewer SPECIAL DEPARTMENTAL SUPPLIES 60069 - Sewer DEPRECIATION Total Sewer Operating expense Total Income From Operations: Non -Operating Items: Water Non -operating income 36100 - INTEREST INCOME 36110 - WATER IMPACT FEE INTEREST INCOME 36111 - WATER IMPACT FEES 36112 - WATER IMPACT FEE BEG F.B. 39535 - W/5 - BEG. FUND BALANCE 5630 - Gain (loss) on asset retirement 5651 - Water CONTRIBUTIONS OF ASSETS Total Water Non -operating income Sewer Non -operating income Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved (455.96) (711.80) (385.23) (1,000.00) 38.52 $ (1,250.00) $ (1,250.00) (53,768.82) (27,050.77) (18,975.86) (50,700.00) 37.43 $ (50,700.00) $ (50,700.00) (1,560.00) (1,560.00) (1,560.00) (1,560.00) 100.00 $ $ (1,560.00) (178,423.38) (187,986.47) 0.00 (179,000.00) 0.00 $ (187,000.00) $ (187,000.00) (707,750.83) (735,240.52) (262,261.59) (797,560.00) 32.88 $ (691,795.00) $ (861,210.00) $ (175,000.00) (175,000.00) 0.00 (192,000.00) 0.00 $ (190,000.00) (75,751.85) (78,310.65) (52,074.25) (80,550.00) 64.65 $ (83,874.00) $ (84,000.00) (46,694.46) (46,067.23) (32,059.47) (51,400.00) 62.37 $ (53,981.00) $ (53,500.00) (385.08) (973.26) (1,106.30) (1,500.00) 73.75 $ (1,500.00) $ (1,500.00) (405.91) (635.92) (1,270.09) (1,200.00) 105.84 $ (1,000.00) $ (1,200.00) (21.00) 0.00 0.00 (750.00) 0.00 $ (750.00) $ (750.00) (704.35) (674.92) (129.70) (750.00) 17.29 $ (1,000.00) $ (1,000.00) (14,835.85) (13,831.39) (19,773.28) (29,000.00) 68.18 $ (26,000.00) $ (26,000.00) (5,465.53) (3,813.27) (462.13) (3,000.00) 15.40 $ (2,500.00) $ (2,500.00) (40,376.39) (41,927.09) (22,649.23) (38,000.00) 59.60 $ (40,000.00) $ (41,000.00) (1,874.24) (1,720.75) (1,060.99) (1,700.00) 62.41 $ (2,240.00) $ (2,240.00) 0.00 0.00 (105.00) (500.00) 21.00 $ (1,000.00) $ (1,000.00) (2,203.60) (1,973.67) (1,359.71) (2,100.00) 64.75 $ (2,500.00) $ (2,500.00) (41,941.19) (32,326.77) (16,543.26) (83,500.00) 19.81 $ (78,500.00) $ (38,500.00) 0.00 (725.00) 0.00 (750.00) 0.00 $ (500.00) $ (500.00) (3,486.04) 1,352.46 (1,465.39) (3,600.00) 40.71 $ (3,500.00) $ (3,500.00) (13,407.44) (44,087.06) (16,476.50) (24,000.00) 68.65 $ (29,500.00) $ (30,000.00) (152,281.44) (158,372.45) 0.00 (164,000.00) 0.00 $ (172,000.00) $ (172,000.00) (574,834.37) (599,086.97) (166,535.30) (678,300.00) 24.55 $ (500,345.00) $ (651,690.00) $ (23,568.04) (95,003.65) 347,178.99 (224,160.00) (154.88) $ (1,192,140.00) $ (245,700.00) 14,964.21 12,097.90 1,516.82 13,000.00 11.67 $ $ 13,000.00 5,094.50 2,718.63 0.00 4,000.00 0.00 $ $ 4,000.00 18,213.00 46,242.42 8,958.98 5,000.00 179.18 $ $ 5,000.00 0.00 0.00 0.00 1,000.00 0.00 $ 380,000.00 0.00 0.00 0.00 100,000.00 0.00 $ 7,500.00 0.00 0.00 0.00 0.00 0.00 93,105.00 0.00 0.00 0.00 0.00 131,376.71 61,058.95 10,475.80 123,000.00 8.52 $ $ 409,500.00 $ 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 30 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 56100 - Sewer INTEREST INCOME 56110 - SEWER IMPACT FEE INTEREST 56111 - SEWER IMPACT FEES 56112 - SEWER IMPACT FEE BEG F.B. 56113-SEWER IMPACT FEE FINANCE INTEREST 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 Total Water Non -operating expense Sewer Non -operating expense 60082 - Sewer INTEREST ON SEWER BONDS 60085 - CONTRIBUTION TO EXTENDED CARE FACIL Total Sewer Non -operating expense Total Non -Operating Items: Total Income or Expense Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved 13,583.74 0.00 0.00 13,000.00 0.00 $ $ 13,000.00 13,286.47 8,157.00 1,642.02 8,000.00 20.53 $ $ 8,000.00 39,466.00 318,417.64 16,410.32 5,000.00 328.21 $ $ 5,000.00 0.00 0.00 0.00 0.00 0.00 $ 8,288.26 14,827.76 6,797.59 5,000.00 135.95 $ $ 5,000.00 0.00 0.00 0.00 0.00 0.00 74,624.47 341,402.40 24,849.93 31,000.00 80.16 $ $ 31,000.00 $ (427.87) 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ (427.87) 0.00 0.00 0.00 0.00 $ $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 (100,000.00) 0.00 $ $ 0.00 0.00 0.00 (100,000.00) 0.00 $ $ $ $ $ 440,500.00 $ 205,573.31 402,461.35 35,325.73 54,000.00 65.42 $ (1,192,140.00) $ 194,800.00 $ 182,005.27 307,457.70 382,504.72 (170,160.00) (224.79) 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 31 of 35 MOAB CITY CORPORATION Run Date: Friday, March 04, 2011 Capital Budget 51- 51 Water & Sewer Fund as of 03/31/2011 2011 2012 Description Budget Actual Dept. Request Recommended Council Approved Projects: Impact Expenditures - Sewer $ 10,000.00 $ 8,421.62 $ - $ 365,000.00 Impact Expenditures - Water $ 10,000.00 $ - $ 15,000.00 $ 15,000.00 Total Projects: $ 20,000.00 $ 8,421.62 $ 15,000.00 $ 380,000.00 $ - Direct Purchase: 1611-Land $ - $ - $ - $ - 1615 - Water shares $ - $ - $ - $ - 1631- Water wells $ - $ - $ - $ - 1641- Water tanks $ 3,600.00 $ - $ - $ - 1642 - Water lines $ 45,000.00 $ - $ 5,000.00 $ 5,000.00 1643 - Meters $ 40,000.00 $ 32,327.03 $ 40,000.00 $ 40,000.00 1651- Sewage treatment facilities $ - $ - 1652 - Sewer lines $ - $ - $ 60,000.00 $ 75,000.00 1661.1- Equipment - general $ - $ - 1661.2 - Equipment - water $ 62,900.00 $ 50,200.00 $ 53,800.00 $ 53,800.00 1661.3 - Equipment - sewer $ 239,000.00 $ - $ - $ - 1665 - Office furniture and equipment $ - $ - $ - $ - 1671- Autos and trucks $ - $ - $ - $ - Total Direct Purchase: $ 390,500.00 $ 82,527.03 $ 158,800.00 $ 173,800.00 $ - Total Capital Requirement: $ 410,500.00 $ 90,948.65 $ 173,800.00 $ 553,800.00 Long Term Debt Repayment: 1993A BWR Water Revenue $ - $ - Total Long Term Debt Repayment: $ - $ - $ - $ - $ - Total Capital and Long Term Debt Requirement: $ 410,500.00 $ 90,948.65 $ 173,800.00 $ 553,800.00 $ - Resources to be Provided: Net Income $ (170,160.00) $ 446,949.71 $ (1,192,140.00) $ 194,800.00 $ - Add Depreciation $ 343,000.00 $ - $ 359,000.00 $ 359,000.00 $ - Provided/Required from Operation: $ 172,840.00 $ 446,949.71 $ (833,140.00) $ 553,800.00 $ - Project Borrowing $ - $ - Total Resources to be Provided: $ 172,840.00 $ 446,949.71 $ (833,140.00) $ 553,800.00 $ - Resource Remaining or to be Provided: $ (237,660.00) $ 356,001.06 Beginning Capital Asset Reserve: $ 154,540.66 $ 154,540.66 Ending Capital Asset Reserve: $ (83,119.34) $ 510,541.72 4/1/2011 J:\2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 32 of 35 MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED 2008-2009 2009-2010 2010-2011 2011-2012 53 - 53 Storm Water Utility fund year to date as of June 2010 100.00% of the fiscal year has expired Income or Expense Income From Operations: Water Operating Income 36450 - STORM WATER DRAINAGE FEE Total Water Operating Income Water Operating expense 40009 - Storm wtr GENERAL FUND O/H 40010 - Storm wtr SALARIES & WAGES 40013 - Storm wtr EMPLOYEE BENEFITS 40031 - Storm wtr PROFESSIONAL & TECH. SERVICES 40046 - Storm wtr SPECIAL DEPARTMENTAL SUPPLIES 40069 - Storm wtr DEPRECIATION 40075 - Storm wtr SPECIAL PROJECTS Total Water Operating expense Total Income From Operations: Non -Operating Items: Water Non -operating income 36110 - INTEREST INCOME 36112-TFER FROM BEG F.B. 36210 -TRANSFER FROM GENERAL FUND Total Water Non -operating income Water Non -operating expense 40090 - Storm wtr TRANSFER TO SURPLUS FUND BAL. Total Water Non -operating expense Total Non -Operating Items: Total Income or Expense Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved Prior YTD Current YTD Current YTD Annual Budget Percent Used 127,462.92 127,506.09 78,007.00 128,000.00 60.94 $ $ 132,000.00 127,462.92 127,506.09 78,007.00 128,000.00 60.94 $ $ 132,000.00 $ (19,500.00) (19,500.00) 0.00 (25,000.00) 0.00 $ (45,000.00) $ (45,000.00) 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ (630.00) 0.00 0.00 0.00 0.00 $ $ (10.95) 0.00 (274.17) (3,000.00) 9.14 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 (261,812.71) (6,999.00) (7,000.00) 99.99 $ $ (10,000.00) (20,140.95) (281,312.71) (7,273.17) (35,000.00) 20.78 $ (45,000.00) $ (55,000.00) $ 107,321.97 (153,806.62) 70,733.83 93,000.00 76.06 $ (45,000.00) $ 77,000.00 $ 0.00 0.00 0.00 4,000.00 0.00 $ $ 4,000.00 0.00 0.00 0.00 0.00 0.00 $ $ 294,000.00 800,000.00 0.00 0.00 0.00 0.00 $ $ 800,000.00 0.00 0.00 4,000.00 0.00 $ $ 298,000.00 $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ $ 800,000.00 0.00 0.00 4,000.00 0.00 $ $ 298,000.00 $ 907,321.97 (153,806.62) 70,733.83 97,000.00 72.92 $ (45,000.00) $ 375,000.00 $ 4/1/2011 1:V011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 33 of 35 Moab City Recorder's Office MOAB CITY CORPORATION Run Date: Thursday, March 10, 2011 Capital Budget 53 - 53 Storm Water Utility fund as of 02/28/2011 2011 2012 Description Budget Actual Dept. Request Recommended Council Approved Projects: STEWART CANYON DESIGN $ 375,000.00 $ - $ - $ 375,000.00 Total Projects: $ 375,000.00 $ - $ - $ 375,000.00 $ - Direct Purchase: Total Direct Purchase: $ - $ - $ - $ 375,000.00 $ - Total Capital Requirement: $ 375,000.00 $ - $ - $ 375,000.00 $ - Long Term Debt Repayment: Total Long Term Debt Repayment: $ - $ - $ - $ - $ - Total Capital and Long Term Debt Requirement: $ 375,000.00 $ - $ - $ 375,000.00 $ - Resources to be Provided: Net Income $ 97,000.00 $ 82,344.89 $ (45,000.00) $ 375,000.00 $ - Add Depreciation $ - $ - $ - $ - $ - Provided/Required from Operation: $ 97,000.00 $ 82,344.89 $ (45,000.00) $ 375,000.00 $ - Project Borrowing $ - $ - Total Resources to be Provided: $ 97,000.00 $ 82,344.89 $ (45,000.00) $ 375,000.00 $ - Resource Remaining or to be Provided: $ (278,000.00) $ 82,344.89 $ (45,000.00) $ 375,000.00 $ - Beginning Capital Asset Reserve: $ 253,282.00 $ 253,282.00 Ending Capital Asset Reserve: $ (24,718.00) $ 335,626.89 4/1/2011 J:\2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Moab City Recorder's Office Page 34 of 35 MOAB CITY CORPORATION Budget Worksheet Detail As of January 31, 2011 58.33% OF THE FISCAL YEAR HAS EXPIRED Account # / Description 2008-2009 2009-2010 2010-2011 2011-2012 73 - 73 Youth City Council fund year to date as of June 2010 100.00% 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 Total Revenue: 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 Year End Actual YTD Annual Budget % Used Dept. Request Recommended Council Approved Prior YTD Current YTD Current YTD Annual Budget Percent Used 48.85 26.36 0.00 25.00 0.00 $ $ 25.00 48.85 26.36 0.00 25.00 0.00 $ $ 25.00 $ - 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ $ 48.85 26.36 0.00 25.00 0.00 $ $ 25.00 $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ 0.00 0.00 0.00 0.00 0.00 $ $ $ 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (25.00) 0.00 $ (25.00) 0.00 0.00 0.00 (25.00) 0.00 $ $ (25.00) $ - 0.00 0.00 0.00 (25.00) 0.00 $ $ (25.00) $ A 48.85 26.36 0.00 0.00 0.00 $ $ 4/1/2011 J:\2011\2011-12 Budget\Budget Worksheet Detail Working Copy.xlsx Page 35 of 35 Moab City Recorder's Office