The URL can be used to link to this page

Home My WebLink About06.11.12 Work Session Packet City of Farmington Mission Statement 430 Third Street Through teamwork and cooperation, Farmington,MN 55024 the City of Farmington provides quality services that preserve our proud past and foster a promising future. AGENDA CITY COUNCIL WORKSHOP June 11, 2012 6:40 p.m. 1. CALL TO ORDER 2. APPROVE AGENDA 3. LIQUOR OPERATIONS 4. 2013/2014 BUDGET DISCUSSION 5. CITY ADMINISTRATOR UPDATE 6. ADJOURN PUBLIC INFORMATION STATEMENT Council workshops are conducted as an informal work session.All discussions shall be considered fact finding,hypothetical and unofficial critical thinking exercises,which do not reflect an official public position. Council work session outcomes should not be construed by the attending public and/or reporting media as the articulation of a formal City policy positron. Only official Council action normally taken at a regularly scheduled Council meeting should be considered as a formal expression of the Ciry's position on any given matter. o``i��i��► City of Farmington 'z 430 Third Street Farmington, Minnesota 651.280.6800•Fax 651.280.6899 6 �~4 www.cilarmington.mn.us TO: Mayor,Council Members and City Administrator FROM: Randy Distad,Parks and Recreation Director SUBJECT: Downtown Liquor Store Lease Proposals and Relocation Expenses DATE: June 11,2012 INTRODUCTIONBACKGROUND, Direction was given by the City Council at a work session held on Tuesday,May 29,2012 to request proposals to lease space either in the Tamarack Ridge Retail Center or the City Center Development(current site of the Downtown Liquor Store). DISCUSSION Staff has received two proposals from the Tamarack Ridge Retail Center: one for leasing 5,058 square feet of space (Exhibit A)and a second to lease 3,508 square feet of space(Exhibit B). Staff has also received a proposal from the City Center Development Owner and the proposal is attached as Exhibit C. Before the City Council makes a decision on whether or not it wishes to relocate the Downtown Liquor Store from its current location in the City Center Development,it must also factor in what the relocation expenses will be. Exhibit D shows estimated relocation expenses that staff members have identified will most likely occur should relocation to the Tamarack Ridge Retail Center take place. If the City Council is interested in relocating the Downtown Liquor Store to the Tamarack Ridge Retail Center it will also want to consider the length of the lease.Given the cost to relocate the Downtown Liquor Store,the City Council may want to consider the seven year lease proposal rather than the five year lease proposal because it offers a lower beginning lease rate as well as a lower annual rate over the first five years of the lease. Additionally given the estimated relocation expenses,it would provide the City with an opportunity to spread the relocation expenses over two additional years. Staff has completed a fmancial analysis comparing the proposals and estimated relocation expenses and the analysis is shown in Exhibit E. As you can see,when relocation expenses are factored in for the first year of the lease,the savings is greater by remaining in the current location. Exhibit F shows the estimated costs to relocate to the Tamarack Ridge Retail Center and is based on an estimate received from Larry White who has experience with moving the two City liquor stores previously.Exhibit G is an email from Mr.White that explains the costs covered and not covered in his relocation cost estimate. ACTION REOUESTED Staff members are requesting the City Council review the attached Exhibits and discuss the two options on the location of the Downtown Liquor Store and then provide direction at the Work Session to staff on the following items: • Identify which property owner it wishes to negotiate a lease agreement with • Identify the length(number of years)of the lease agreement Once direction is given, staff members will begin the process of negotiating a lease agreement for the Downtown Liquor Store and will bring the lease agreement back to the City Council for approval. Respectfully Submitted, Randy Distad, Parks and Recreation Director • Minneapolis-St Paul 4360 Baker Road,Sulte 400 MAIN+1 952 897 7700 Minnetonka,MN 55343 FAX+1 952 897 7704 www.collers.com C O I.II C 1 S rr a ,A1lu NAl Eu-J1b--t- A May 16,2012 Randy Distad Parks and Recreation Director Farmington City Hall 430 Third Street Farmington,MN 55024 Re: PROPOSAL TO LEASE SPACE AT TAMARACK RIDGE Property Name: Tamarack Ridge,Farmington,MN Landlord Name: Northland Commercial Dear Randy: Pursuant to our recent conversations, this letter is intended to serve as a proposal for the Farmington City Liquor Store to lease space at the above shopping center under the following terms and conditions. This proposal is subject to Landlord's review and approval of its terms and conditions. This proposal should not be construed to be a binding commitment by either party. 1. Premises: Consisting of approximately 5,058 SF(In-line bays 10, 11& 12) 2. Tenant: City of Farmington 3. Term: July 1,2012-August 31,2017(5 Years,2 months) 4. Renewal Options: Tenant shall be offered(1)one(5)five year renewal option at market rates. 5. Use: Liquor Store 6. Base Rent: Month 1-2 $0.00 psf(pay CAM and Tax only) Year 1 $9.50 psf $4,004.25/month Year 2 $10.00 psf $4,215.00/month Year 3 $10.50 psf $4,425.00/month Year 4 $11.00 psf $4,636.50/month Year 5 $11.50 psf $4,847.25/month *(Base)Rent shall commence September 1,2012. si igmiam 'j IAL X TEAM tjr-, INresianu@N4t 4350 Baker Road,Suite 400,MtnnetonkaMN55343 Tel 952.89Z7700 Fax 952.897.7704 www.welshco.coni Farmington City Liquor Store May 18,2012 Paget Colliers • 7. Operating Est.CAM for 2012 $2.22 per square foot or$939.13/month Expenses: Est.Taxes for 2012 $3.77 per square foot or$1,589.23/month Total monthly rent,year 1:$6,532.61 Gas&Electric are separately metered. 8. Percentage Rent: Percentage Rent Clause to be removed from Lease 9. Security Deposit: One month's gross rent,to be held for the first term of the Lease.At the end of the first term,as long as the tenant is in good standing the security deposit shall be applied to month 59.If the tenant is not in good standing then the security deposit shall not be applied. 10. Landlords Work: Landlord to provide space in"as is"condition to Tenant. *Landlord to provide $7.50 per square foot for tenant improvement allowance. In addition to the standard Vanilla shell,Landlord has provided the following improvements: *Vanilla Shell demised: *Drywall paint on ceiling • *Lighting allowance package of$6,500.00 *One(1)ADA compliant finished bathroom,standard Landlord Spec (tiled floor&walls, 1 sink&1 toilet) *(3)200 amp electrical ready for commercial use *New HVAC rooftop units Bay 10(1)5 ton unit,Bay 11(1)3 ton unit, Bay 12(1)4 ton unit. *HVAC trunk lines. 4350 Baker Road,Suite 400,Minnetonka,MN 55343 Tel 952.897.7700 Fax 952.897.7704 www.welshco.cam Farmington City Liquor Store May 18,2012 Colliers Page 3 rr rini :r ni 11. Tenant Work: All other work shall be considered Tenant Work and shall include,but not be limited to: *Tenant to provide space plan to Landlord and city *Any additional construction required as a result of Tenant's specific use *All trade fixtures and decorating. *Exterior building signage *My additional HVAC if necessary for Tenant's own use *Any additional SAC/WAC if necessary for Tenant's own use *Tenant shall present invoices and lien waivers evidencing payment of all Tenant Work,including allowance for reimbursement.Tenant shall also provide a copy of their insurance to Landlord(minimum 1 million dollar policy)prior to or upon occupancy and on an annual basis thereafter. *Tenant is responsible for obtaining all permits,and any liquor license required by the City of Farmington 12. Option(Seven Another option is for Tenant to add two years to this lease proposal with Year Lease): the first full year minimum rent at $9.00 psf and the last full year minimum rent at$12.00 psf. Also,there would be a$10.00 psf tenant improvement allowance attached to the seven-year option. 13. Delivery July 1,2012 or upon substantial completion of Landlord Work. Date: 14. Lease/Rent September 1,2012 Commencement: 15. Signage: It is agreed that the Tenant will have the right to incorporate signing on its storefront at the Tenant's expense. All signing shall conform to the Landlord's sign criteria and shall be subject to both Landlord and City approval. 16. Assignment& Tenant shall not assign the Lease or sublet the Premises without prior Subletting: written consent of the Landlord. No assignment shall release Tenant or Tenant Guarantor of any obligations under the Lease. 17. Repairs Landlord shall maintain and repair the common areas of the building, Maintenance& roof,exterior walls and foundations of the building per the lease.Tenant Utilities: will maintain the premises and the portions thereof not the responsibility of Landlord per the lease. sum XIEAM C/fY Nl QNNAf1HW. 4350 Baker Road,Suite 400,Minnetonka,MN 55343 Te1952897.7700 Fax 952 897.7704 www.weishco.cont • Farmington City Liquor Store May 18,2012 Colliers Page I .TIRN,a,i()r:E:i 18. Utilities: Tenant shall pay all utility expenses related to the Premises as of Delivery Date. Electricity and natural gas will be separately metered, and Tenant will have full responsibility for direct payment of utility bills. All SAC/WAC charges shall be Tenant's responsibility. 19. Documentation: Landlord will prepare lease form. 20. Brokerage: Tenant and Landlord agree that no other broker is involved in this transaction other than Colliers International who represents the Landlord. Any commissions due shall be paid by the Landlord pursuant to a separate written agreement between Landlord and the Listing Broker. We look forward to working with you to consummate a Lease.We will prepare a Lease document for your review once we are in agreement on the basic terms and conditions. If you would like to proceed,please sign a copy of this proposal and return it to my attention at your earliest convenience.This letter is not a binding agreement and is intended as a mutual expression of Landlord and Tenant to negotiate in good faith with the intent of entering into a mutually satisfactory,written lease agreement. Landlord's obligation to lease the Premises to Tenant and Tenant's obligation to lease the Premises from Landlord are expressly conditioned upon the Landlord and Tenant entering into a mutually satisfactory written lease agreement(the"Lease"). In the event of any conflict between this proposal and the Lease,the Lease shall control.This proposal is intended to be kept confidential to any outside parties. If you have any questions or comments,please contact me. Sincerely, Agreed and Accepted: 717rd Zachary Stensland Colliers International Minneapolis-St.Paul By: 952-837-3078 Date: ?V��r t4IgenaeArrnr4c 4350 BakerRoary Suite 400,Minnetonka,MN 55343 Te1952.897.7700 Fax 952.897.7704 www.weishco.com . . . • : • Farmington City Liquor Store May 18,2012 C o I lier s Page 5 INTI,RNAI IONIA' EXHIBIT A t ZP V _A o ... I 0 it--...-• 0 i,..-• ,.. 1 •r • • 5 ..7 . iNt 'I : al a) III 4 ' . 'r 0-. C) irl 9 Ai. A.h.. \• 171 71 14gZa% ',.. . .• AW .P.M-. I °.v..°<‘..e:t° I rri w. CA:t c fp. jr "1 hi Fil • I 21 r) .1' fle I I:: CD .....) - • :::: j 4111 6=X T.:11r iii. (1) T• :t. ,II i•:, , ....... 2. .. , . q 8 1 - 7 I ,- ntar . gir.r i. •c.: I .. 2 s I • u. -I-1 , FA , rwr.i:Amer r 6 0 0 1 41 -1 - . , 2 TrANC.747 P -0 FulAriorst 17'itg.I'-;-- ' ••.:711 4 \-57'•.4%,.%■.k' i; I 1.. %,•••$, :Sp\ ,;'i "••N'\\. :;ig11. . 0.) 7.1 . ),„ . .„ 1 70,., I,., ci.:41'): %••• :., , , .-..i . ,...p._:„. ... .., ....., 1 ' ni..AVAILAKV .1. A !%,,, ••,,:.:.!rr\s‘.. i ';6•+:1•6•14•.14140. : ! • I • • ( • zittiktP • fo.4 .• A'41;1 M ig 4 .• f,-t pouingER ,/'ilk XMAIM -q,11,1'NI feWilAfteSt4C, 4350 Baker Road,Salle 400,Minnetonka,MN 55343 Tel 952.897.7700 Fax 952.897.7704 www.welshco.com Minneapolis-St.Paul 4350 Baker Road,Suite 400 MAIN+1 952 897 7700 Minnetonka,MN 55343 FAX+1 952 897 7704 www.colilers.com Co •ers INTERNATIONAL Exhibit B June 4,2012 Randy Distad Parks and Recreation Director Farmington City Hall 430 Third Street Farmington,MN 55024 Re: PROPOSAL TO LEASE SPACE AT TAMARACK RIDGE Property Name: Tamarack Ridge,Farmington,MN Landlord Name: Northland Commercial Dear Randy: Pursuant to our recent conversations, this letter is intended to serve as a proposal for the Farmington City Liquor Store to lease space at the above shopping center under the following terms and conditions. This proposal is subject to Landlord's review and approval of its terms and conditions. This proposal should not be construed to be a binding commitment by either party. 1. Premises: Consisting of approximately 3,508 SF(In-line bays 10& 11) 2. Tenant: City of Farmington 3. Term: September 1,2012-October 31,2017(5 Years,2 months) 4. Renewal Options: Tenant shall be offered(1)one(5)five year renewal option at market rates. 5. Use: Liquor Store 6. Base Rent: Month 1-2 $0.00 psf(pay CAM and Tax only) Year 1 $11.50 psf $3,361.83/month Year 2 $12.00 psf $3,508.00/month Year 3 $12.50 psf $3,654.17/month Year 4 $13.00 psf $3,800.33/month Year 5 $13.50 psf $3,946.50/month *(Base)Rent shall commence November 1,2012. PARTNER E==: TEAM \\C INTERNATIONAL 4350 Baker Road,Suite 400,Minnetonka,MN 55343 Tel 952.897.7700 Fax 952.897.7704 www.welshco.com Farmington City Liquor Store June 6,2012 Colliers Page 2 INTERNATIONAL 7. Operating Est. CAM for 2012 $2.22 per square foot or$939.13/month Expenses: Est.Taxes for 2012 $3.77 per square foot or$1,589.23/month Total monthly rent,year 1: $5,112.91 Gas&Electric are separately metered. 8. Percentage Rent: Percentage Rent Clause to be removed from Lease 9. Security Deposit: One month's gross rent,to be held for the first term of the Lease.At the end of the first term,as long as the tenant is in good standing the security deposit shall be applied to month 59.If the tenant is not in good standing then the security deposit shall not be applied. 10. Landlords Work: Landlord to provide space in"as is"condition to Tenant. *Landlord to provide $7.50 per square foot for tenant improvement allowance. In addition to the standard Vanilla shell,Landlord has provided the following improvements: *Vanilla Shell demised: *One ADA compliant finished bathrooms, standard Landlord spec (tiled floor&walls, 1 sink,& 1 toilet) *(2)200 amp electrical ready for commercial use *New HVAC rooftop units Bay 10(1)5 ton unit and Bay 11 (1)3 ton unit. *HVAC trunk lines 11. Tenant Work: All other work shall be considered Tenant Work and shall include,but not be limited to: *Tenant to provide space plan to Landlord and city *My additional construction required as a result of Tenant's specific use *All trade fixtures and decorating. *Exterior building signage *Any additional HVAC if necessary for Tenant's own use *My additional SAC/WAC if necessary for Tenant's own use *Tenant shall present invoices and lien waivers evidencing payment of all Tenant Work,including allowance for reimbursement.Tenant shall also provide a copy of their insurance to Landlord(minimum 1 million dollar policy)prior to or upon occupancy and on an annual basis thereafter. *Tenant is responsible for obtaining all permits,and any liquor license • required by the City of Farmington PARTNER TFJ�M �,� INTERNATIONAL 4350 Baker Roan Suite 400,Minnetonka,MN 55343 Tel 952.897.7700 Fax 952.897.7704 www.welshco.com Farmington City Liquor Store June 6,2012 Colliers Page 3 INTERNATIONAL 12. Option(Seven Another option is for Tenant to add two years to this lease proposal with Year Lease): the first full year minimum rent at $11.00 psf and the last full year minimum rent at $14.00 psf. Also, there would be a $10.00 psf tenant improvement allowance attached to the seven-year option. 13. Delivery Landlord contemplates being able to deliver the space to Tenant for Date: Tenant Work upon full execution of a lease documents by both parties. 14. Lease/Rent Lease shall commence on Lease execution by both parties. Commencement: 15. Signage: It is agreed that the Tenant will have the right to incorporate signing on its storefront at the Tenant's expense. All signing shall conform to the Landlord's sign criteria and shall be subject to both Landlord and City approval. 16. Assignment& Tenant shall not assign the Lease or sublet the Premises without prior Subletting: written consent of the Landlord. No assignment shall release Tenant or Tenant Guarantor of any obligations under the Lease. 17. Repairs Landlord shall maintain and repair the common areas of the building, Maintenance& roof,exterior walls and foundations of the building per the lease.Tenant Utilities: will maintain the premises and the portions thereof not the responsibility of Landlord per the lease. 18. Utilities: Tenant shall pay all utility expenses related to the Premises as of Delivery Date. Electricity and natural gas will be separately metered, and Tenant will have full responsibility for direct payment of utility bills. All SAC/WAC charges shall be Tenant's responsibility. 19. Documentation: Landlord will prepare lease form. 20. Brokerage: Tenant and Landlord agree that no other broker is involved in this transaction other than Colliers International who represents the Landlord. Any commissions due shall be paid by the Landlord pursuant to a separate written agreement between Landlord and the Listing Broker. r'"'�7C TEAM PARTNER c\,`w" mow" 4350 Baker Road Suite 400,Minnetonka,MN 55343 Tel 952.897.7700 Fax 952.897.7704 www.welshco.com Farmington City Liquor Store Junpe 6,2012 Comers Page 4 INTERNATIONAL We look forward to working with you to consummate a Lease.We will prepare a Lease document for your review once we are in agreement on the basic terms and conditions. If you would like to proceed,please sign a copy of this proposal and return it to my attention at your earliest convenience.This letter is not a binding agreement and is intended as a mutual expression of Landlord and Tenant to negotiate in good faith with the intent of entering into a mutually satisfactory,written lease agreement. Landlord's obligation to lease the Premises to Tenant and Tenant's obligation to lease the Premises from Landlord are expressly conditioned upon the Landlord and Tenant entering into a mutually satisfactory written lease agreement(the"Lease"). In the event of any conflict between this proposal and the Lease,the Lease shall control.This proposal is intended to be kept confidential to any outside parties. If you have any questions or comments,please contact me. Sincerely, Agreed and Accepted: S Zachary Stensland Colliers International Minneapolis-St.Paul By: 952-837-3078 Date: EXHIBIT A • PARTNER "'',=:=X TEAM INTERNATIONAL 4350 Baker Road,Suite 400,Minnetonka,MN 55343 Tel 952.897.7700 Fax 952.897.7704 www.welshco.com David McKnight oif c From: Thomas B.Wartman <thomas.wartman @gmail.com> Sent: Wednesday,June 06,2012 10:45 AM To: David McKnight Subject: Re:Proposal David, Please find my proposal below which we would consolidate into a second amendment to our existing lease. After considering the goals the City has for the Downtown Liquor Store with future City growth and with the intent to keep City Center a strong Downtown retail/service Business District with the soon to be completed Family Fresh Market,I would offer the following: Term:August 1,2012--July 31,2017 (5 year term) Renewal Options: (2)two(5)five year renewal options at market rates. Monthly Base Rent: Year 1 $13.50 psf $7,031.25 Year 2 $14.00 psf $7,291.67 Year 3 $14.50 psf $7,552.00 Year 4 $15.00 psf $7,812.50 Year 5 $15.50 psf $8,072.92 Operating Expenses: CAM 2012 Monthly Budget $3,008.00 $5.78 psf All other terms and conditions of the lease shall remain in full force and effect. Respectfully Submitted, City Center Development LLC Thomas B.Wartman Chief Manager On Fri,Jun 1,2012 at 9:54 AM,David McKnight<DMcKnight @ci.farmington.mn.us>wrote: Tom- 1 C ,0 0 0 0 ^ 0 0 0 0 0 0 0 0 0 0 0 C 0000N 0000N 0 0 0 N 0 0 0 0 N N N > o co O 2 at O ° O o ' o 0 0 o at d;, • CO N r CO CO N P 'd' N to C4 c.2 N. N co cn __ NON � - O U) `. N S d P 0 J 'a co al e co > 7 E a:. N W O O 0 ^ 10 O O O ^ 0 0 0 0 O O 0 0 0 0 CO 0 0 0 0 0) 0 0 0 0 CO W 0 O co O 2 Cp O LO 0 e7 0 0 0 0 CA e' CO N r CO N M N CO co et to LL ( O ch P co Co N N N ' N CO 0 OD ++ d m Pa CU o V E >- 3 W d a• re COV 0 o 0 C ii! a m a O Y u) C.) m CZ V a) c u) CO o a) o c O c > co > H C N C U) c Y co 0 aa+ a m O- 0 E O 6 0 E E W C co 3 ON C E C IS 0 0 CO I- c. E ° c. a E ° ° $ a) RS .2 '� > co C 0) E E ,A Y f!) 7+• - E N w+ '- E c .a :Oo a.. I. 0 CO y C2 N U co Q- CU d l9 lv d W o m a. o f 'o. u) d E .c Q m c w m d I-- w m 0.In' € � O .J a ` 0 c n -0 -0• g o O op op o = c co am o 0 co > v 0 0 > c C O 0 N a) ,O 0. N a) ,0 C Q.t.• m C C N CO C C CA ,.0 l9 = 0 0 O E O l0 o d o N ON w Q N 2 w w N to 2 2 U) Lo C N C W 0 0 ,i.i 'p C CO a.0 -O C ta � Z C9 J E E 0 0 - = 0 N V = 0 O O U. rn m a U. co N v c -0 c W co ` c c E c c O coo •+ i+ CO N U 7 N :°a m O C7 t0 V V .� Cr -c _ _ �_ COm c agora m ac' c, c o o U o ,°o o 0 o o v 'a I-o I- LL!W � `" C 0a 03 (63 cc aQ � m a) en we e X00 c S00 coaco CO CO la WI > N MI TO > N 22 V o U o 0 � cA � 0 2 m O 2 u- m aDa. CLCt c 0 0 0 0 0 COO - CO COO < O CO COO < 0 0 M CO ON) CO 0 O tit I` I` O z C 0 CO Z O W N N. 0 NOr r r NCOA O a) O. ti r ti CO co-r ti ti CO d C') co 0) 0) 0) M g N CO N d' V' CO N v O EA EA. EA. EA. EH EA EA r r r r LN a. II II II II II II d'e o +, V :K Cg V Cg V N • U) U) N U) U)O U) U) A Li- ° CO O O O CO LC)) N- O • Ch 'd. -4. O C,p to 0. U) O co Cl co r O 0) CO CO 0) M CD CO ti r M CO -a O CO 0 M CO 0) r C) CO 0) N r r N- ti 0 r CO N N O O •r CO r N 003 CO� g OC) r U) (h OC'7 O Cq O 07 O COO O to O op CO O I` O Cd)gt O C 'd' EA O O co a t7o d �t CO ao CO d H a. II II II II II II 69. d • N U) . U)_ c ` 1c to 0 �° ca. U)), rn C ' ai o o P P vi .— a' N U) co cca 0. J10 CO O 'd' co co M co CO co O) C) co r O a N 0) O 0 O r NO C° ON NI CO N. OW MM W g O COO CO M E) A M N. M a1 N r r O N CO. O N CV) to N r CO ti W CO CA- Cn Is N. tZ COO T co CO CO COT M CO O Ca v- Eft > 0. II II II II II II ER IL cg V V V V V d o g g g g W 0 0 0 0 V 7 v- N N CA M O P r r r r O' CO) 0 CO CD C0 rt CO a —S H _—; N 7 N O N O N U 0 0 COQ) O O 0 C _. c c N c +m .. c VlO tv 0"64121= 1- A N L° 02. 1) 0 Z d ✓ ) d d N NCI N N 's '3 a.° ` 40 JJ U >. U C O >,G E ' C2 mUm 0o} oUmo c >- C H COO m -� fa o v L, 0 - E a -a C° ° a- v0 � NWi tn0 � 8 w ) o � Ca 1_� " ate a°H } d U =- N � N m W V U O Cc) O L_ VC co c.) B O U d ce O O C r C 0 0 v W H N CO � 03 In re E O U O O CU0 0 J J O` N CA J U '. c w w e d C J C N O Bm m >- c c a U -0 Ce t u. U v) x CU CU I` W CO O ` .5 d E CU O I-- 1- 1i LL w E co m cc ea ea ca W >- >. >- >- >- c CO Co 0 < 0 CO Co 0 < 0 CO CO o < o o 0 0 CC') cco ZCNDa N. 'a CO ZO - Z rCOO„N aa)i CO N co 0 co' O F- co. CO C CO C d' '40 CO CO CO CO CO CO N N O N P a) c 7 CO CO N CO CO CO LO CO 0 CO V d' CO r 'd' CO N. 0 ti r- 10 N C) m• r- co ti CO ' r- O CA O H r- v ti O) CO - CA N CA Cl. s- d_ ht. CO CO N CO CO C) eF O M CO CO N O CO CD CO C7 CO CA f) CO CO CO 'I- tt CO CO CO d d CO CO N. d M N N I-. CO C CO C_ LL d CA Cu ev J CO N CO CO CO CO CO N CO d' CO 0 CO CO 0 CO ti N- CO v CO N. N- r- CO M N ti N. 0 CO N. CO N. CO C'7 N O — CO It! N M .- co) CO N CA M O OO co) 1- CO CD CO 1` d CO CO W 1- N 0 CO CO 8 0 co CO CO CO 0 M CO CO CO CA CO CO Co) CO 4) !- r- l- P CO a U- C tv C.) S d W 3 o , ,n o �? o y 8 o � 8 a) a o N 8 o � S : u oco 13 c o N c 7 N c c N c c c 0a) c r7 u) c d d 2 O N 8 a) ` V c O N 8 a) c O N 8 a 0 F- 1- U O e O d G e- O CU V Qe O z V CU 0 .se z. E co 4" o c3P IN = = `° co co v U8 ap >,G UU .p >,aG U0 >,C co o Ca J CO r 4) L. +.. a +., B a) 1- J+. O O O `� �O d - O �CU 0 0 ° � = d Ac . O . � V d d 1.E 'E0a c > > a0 -0 c >,} .O 0c c >,>- > > Cu c O _. .a c gg a O .o c Co a) O .c 0 0.0 N 0 I— v LL c c N v Ut u 'c °v m U 0 CO 0 0 0 a) N H 0 11 N co H ,p co a) c O 'a co a) co co m D D • y } xax °o CO ate) n o co m } o 2 la 0 °f d IF W N t� W a d co IL a R d co) J :. 0 0 �. 0 0 CO CO J :� O — E > C =�Q v C ^2 =�pQ .Cl) J C LE N.' a L. a) " No tO N 0 `' No ` O U p V 7 W U N U �- U N U )-CO U N O C O ��- J C 0 J co C u- a) ccC ~ N Q W CC - CO Q A W } co co co E L :2 :7 LL : H u_ W W W 0 0 0 0 0 Q < CO Co CO 0 Q 0 CO 00 0 Q 0 ad. CO N CO N Z Z N a00 N N- N- 0 Z 0 N M CD Z M N ER. N CO r �d � tt e! Tm N II II II II II II ER. COO N O CT 0 CS CT CT CS a) ui U )U) U) U) U) co) Q. 0• `O O O O O LO C) N N d IL ei V d' ui u) u) 0 V d C) V > • N r- 0 O) CO ti CO CC) 00 N- r CO CO O M d N u) CO O CO CO CA O N O CO O O d M r- r !L LO 0 u) r- CO r- CO N N LO CNO N- N M et at 00 "O O 0 Q fa co co O W r: COO ti CO 0 N CD 411 O {d II II II II II II II II E} C 1 CL V V V V V V V O O 0 N U) N U) U) U) N N E, ° In O 00 ° 00 ° °o, u0). 00 O) vo O) O) O 0 c- e- Cal LO a d C E � ,N 1`-° CO N CO 0 Nr CO N M ti u) N CO u N u) ti C CD Q. ` O ‘I" O Cp O CO e— 0 0 CO r 0 N- 0 go N - CO CO c d.. ✓ C' O, COO N CO M CO O r N CO r O N II II II II II II II II be' V N O u) N N CD U)U) N CD CO UU)) O M o 0 0 0 0 0 0 0 0 = V 0 O. 0 N • CM CO ":1" u) CS C co m L O E LC) .1-1 Go F C v yy yy CD 0 0 I > < UH N —C d d 0) aiS 0) C d U �' N -p O) CD c ` D re al c� >> U c o >, G J J U O C - To h O Lt _ii O O U uJ u- *O U U N v cr.0 _ 'a Y 0 } d .c LL O C 0 p N V d v- f0 co E r+ o U N '0 N CU a O L �_ C C co N C N u. CO 0 E W +3 N Q N N C13 o ... V c Ca U N e0 C O N o J A3 N 0 y(O W C >, Cl) 0 a) au W J C R L N 0 C s. t 40 c .a U - 0. I. a) R �- m • U c U o lei To 0 06 o + c U) o cx J To .0 CO N C X d C E >-) .: . LLI 0 o Ls 'S d 0 tm a) O I- 1L— Li ii N N W as E 0 0 0 0 0 0 0 w >- >- >- >- )- >- >- - - CO CO 0 < 0 CO CO 0 < 0 CO-CO 0 < 0 CO O N e' 'd CO C) C) CC) COO C) P P P P P P C O e Z Z Z Z Z N v- 0 N P a) 7 CO I- r I. CO CO CO N N- U) CO CO ) N. CO CO d d N- N I- P N. 0 I` 0 N P 11) N- C) P N I- CO r P CA • CO M Tr CO P N. �t C) P 0) C r 00 P S I. d; N CO O C- I, CA CO c7 I, h CO CCU N I� CO CO co I- N CO CO CO N 10 CO 00 CO N 10 CO CO CO N in CO CO N- N to P P P P C w E 0. 0 CD d C O y L •L CI) RI 4-11 O CO 0 CO O 00 N CO CO r N CO N CO ti CO O CO LO M N- O ti N ti O r IN ti P CO r 1` I� O V CD L. Q. P P O C" N:. P CO M c 0 P CO CA c) N r CO C CO Cr) in CO) 0) CO v. co CO 1` CO CO r CO CO CO CO 0) LO 'd' 0 E CO N.0 N N CO CO 0 N N. CO CO 0 N N CO CO 0) N N- C) o P r P r P r 14 9. O C V RI C N. 0 }1 co iUHH a) N V Ui: I. 1U a 0 0 U O N n 0 0 0 0 0 o a) a ` 0 e.C U a• ao >, a U ° 0o yp >, 5 U cc' o >, C U � Co >, D U. al " O U c +' p t� c m +-' p 0 c 1- +' p C) c co CM y gU co aa)i >. U ca*� a>i lam- 0.gU o a�i U a>i 0.d a oE o .fl cn .` 0 Q o c 'C Q E o 11 g z E 0. o .c v J • (� U N �_. 'C U 8 0 0 U U 0 w U V N co .�C l0 ° R ° a .c -p ` at '0 V C W d c qO To C cc O . 0 0 '° To ti 46 CC N co N c N ccoo N c U) co co o c 0 co C R3 s co o 2 ce = o 2 ce = o 2 Ix = 0 E 0 N 0 V voi Q co a voi Q a�i al U m a U 1 U m U m 0 ai U co C J - C J .0 a J a_ C J i. C !d C a) co d C co V) co C a) co 0 C 0 V) a) a) >- co y o >- N o o >- N 0 a) >- w cC d = E C t04 C A ` C co U f (7) x- —1 U = ox- 0 O F Q. J U I CZ iv `' O >- Q O CV Q O > Q O U :� •NI ~ CO co CCOO c w CO CO IX a) a) a) a) ,Q —I To J N - IO -J N .0 CO C N C N C N c X >- >- < Cl) < >- < W . so - 0 t a) I- E o E w E 0 E . Cl) u' co U) w w w w O O O N 00 O et N C .O Z Z Z Z Z N N- o N P c C 7 CO CO r pti. 4 c co o) ti N V' 0 LO is C a) E Q. O d d C y •L d CO d' co O CO O C CO. s- e- O in 45r ti ti O G+ CCOO - ° N ti E ti 0 Q • N O C V Co C O cp 70 HU y C N C .O N c d 0 U o > N E ▪�{ 2 �. m d d �; C 5 a ° N g, c m m Ia. +-� o c0i C I- J J CO.0 CO U 0- = u) } 0 0 cti .5 In O o >, c d d luL J .R U U N > C C C -o d ��. V v N i d1 c d N w O ` P E < IX = o 'am V N CO 01 co CV -a co N C{1 E c O V c d CO J 8 G a • 4+ co N I C >" m Q c J I- N C U F °- ea c co Cc• " L 0 >- O c 06 8 LL. > O co U) a) _ CO N re • J N I- C Y W 6 a) C co • CO N L1.1 EXHIBIT G From: Larry White [lwhite @grandprojectsinc.com] _ Sent: Wednesday,June 06,2012 4:50 PM To: Randy Distad; Randy Petrofske Subject: Cost budgets for Liquor Store at Tamarack Ridge Gentlemen: We have reviewed the construction improvement costs for your existing two liquor store locations and applied them to the current space under consideration in the Tamarack Ridge Center on Highway 3. These budgets are based on the scope of work we completed at the existing stores and recognize that certain work items and allowances will be provided by the Landlord. Concept A: Bays 10—12 (consisting of approximately 5,058 gross square feet) The space will be finished consistent with your existing stores with epoxy floors in the retail area and clear sealer as required by the Department of Health in the coolers and back room. Due to the size of this space we anticipate you will be required to have two restrooms. Our budget includes the cost of one and the Landlord has indicated they will provide the initial restroom. Again,consistent with your existing stores,we include painted walls,gypsum wall board on the faces of the coolers as well as extending to the ceiling. A small office with a closet for locking records and small inventory is included. We will relocate the existing checkout counter units and install new PLM countertops. A trench will be cut into the existing concrete floor from the back of the space to the front for installing conduits to carry the glass fiber line as well as telephone/data and electrical wiring for the check-out equipment. This concept includes taking down,transporting and reinstalling both the reach-in cooler and the Beer Cave. The budget includes two trips with a crane for removing and hoisting cooler equipment so that one cooler can be installed in the new location prior to the move and the other cooler will then be brought over after the new location is opened. We have also budgeted for installing roof skids to accommodate the rooftop refrigeration units. Fire sprinkler heads will be turned down into the coolers, restrooms and office areas. Plumbing work consists of the additional restroom,one mop sink and floor drains for the cooler condensate lines. Electrical work includes wiring for the cooler mechanical equipment and lighting,general purpose outlets,wiring to the checkout equipment and doorbells for the rear loading area. The budget includes supervision of the work,dumpster service,general liability insurance,final cleanup and an architectural plan for obtaining bids and permits. The Landlord's proposal indicates that they will provide painting the ceiling area,installing trunk ductwork,demising walls,one restroom complete with finishes,and a lighting allowance so we do not include any of those costs in our budget. However,if this site is selected we encourage discussion on consolidating all of this work into our bid package. Concept B:Bays 10—11(consisting of approximately 3,508 gross square feet) This budget is base on the same scope of work as listed above with the exception that it does not include the Beer Cave and related costs for electrical,floor sealer,drywall work,fire sprinklers,etc. The Beer Cave and refrigeration equipment will be disassembled at the present location and trucked/unloaded at a site in Farmington of your choice for storage. Also,since the total space is reduced we anticipate that only one restroom will be required so we have deducted the cost of the second restroom. Work Not Included in Budgets • Disassembly or relocation of store fixtures • Window blinds or shades • Security or camera work • Entry area floor mats or recessed floor for same • Budget does not include any SAC/WAC or building permit fees—the building should have some SAC credits in place for typical retail use • Conduit and/or trenching at exterior of building for glass fiber • Circuits or wiring for building or monument signs • Overhead door at rear wall and related cutting/patching • Interior lighting except for connecting relocated cooler lights • Consolidation of utility meters to create a single account for natural gas and electric services Summary For budgeting purposes you should use the costs the Landlord has proposed for installing a new overhead loading door,the auto entrance door at the front,and upgrades such as an air curtain at the front entrance to minimize cold air intrusion. If the City selects this location we suggest that this work be included in our scope of work and we will obtain competitive bids from several subcontractors for cutting, patching and the door work,etc. These are"budgets" based on a quick review of the existing space and without having developed actual plans to measure final quantities. Our budgets are: • Option A-$126,000 • Option B-$ 96,000 As we understand the Landlord's proposal they will contribute$7.50 per square foot towards these improvements which will reduce the City's out of pocket costs. Since it appears that the construction schedule will be very tight to due to your current lease expiration date it will be advantageous to combine all of the improvements into one package for bidding and coordination. We can clearly identify on the plans which work items to separate into Landlord costs vs.Tenant costs. Thank you for contacting us to assist in your decision process. I plan to attend the City Council meeting on June 11. Larry L.White, President Grand Projects,Inc. PO Box 29 Northfield,MN 55057 Cell 612 644-9023 Email: lwhite@grandprojectsinc.com Office 507-744-4582 Fax 507 744-4583 Website:www.grandprojectsinc.com o��p►�iiyc City of Farmington % 430 Third Street Farmington, Minnesota o 651.280.6800•Fax 651.280.6899 ROlf: • A P www.ci.farmington.mn.us DATE: June 11, 2012 TO: Mayor and City Council Members FROM: David J. McKnight, City Administrator SUBJECT: 2013/2014 Budget Included with this memo is the first draft of the 2013/2014 budget for your review. This memo will summarize what I consider the major issues associated with the first draft of the budget. There are two important factors to remember with this budget process. The first issue is that we are moving to a two-year budget process for the first time. A two year budget process will allow us to take a look a year into the future on what the 2014 budget would look like at this point. The second point to remember is that this will be the first budget where I will be leading the process from start to finish at the staff level. My approach to the City of Farmington budget uses our general fund balance history as the basis for many decisions. As you recall our general fund balance does not meet the recommended level at the end of each year and actually drops below$0 twice a year. Both of these issues are a major concern to me. A copy of the most recent general fund balance history from 2008 through present is included with this memo. This chart caused me to review both the 2011 and 2012 budgets to see what issues were causing our fund balance issues. I shared with you during your work session on March 12, 2012 that I discovered approximately$120,000 in unbudgeted human resources expenses in both budgets that we are contractually obligated to pay. These expenses have been in place for many years, but not accounted for in the budget. I also have concerns about some of the anticipated revenue line items in the 2012 budget that I do not see coming to fruition. Significant revenue adjustments are included in the draft budget and will be discussed as a part of the budget work sessions. 2013/2014 Budget First Draft The first draft of the budget is included with this memo for your review. While the budget and tax levy numbers are high at this time I fully understand that they will not be approved at these amounts. I think it is important for you to see initial requests and budget adjustments before they start to change. This budget process will include discussion on a number of issues that you may or may not have been aware of in the past that are having an impact on the financial health of our city. The most significant change you will see in the drafts of the budget will come after this initial work session and be reflected in draft two. I did make some changes to the budgets that were submitted by department heads, but not many. The budgets you will review are primarily those submitted by department heads. The first draft of the general fund includes a budget of$10,341,694 which represents a 3.27% increase over 2012. The first draft of the 2013 budget includes a tax levy of $9,533,480 which represents an 11.29% increase over 2012. I am fully aware that these numbers will change significantly by the time you set the preliminary budget and tax levy in September. There are a number of issues that are causing these numbers and this memo will summarize them so they can be discussed as a part of the budget process. Significant Issues There are a number of significant issues that you should be aware of for this budget cycle. They are all having an impact on the draft budgets that you will see this summer. The issues are summarized below for your review. 1. Human Resource Costs We have only two of our four union contracts settled for 2013. The two LELS groups are settled through next year and the two AFSCME groups are settled through the end of 2012. We also have the non-union employees who are included in the budget. I have made some assumptions on potential, but not guaranteed, increases to both wages and benefits. My approach to budgeting for HR costs before the costs are known is to include the maximum costs I think would be included and reduce the budgeted amounts as we move through the budget and negotiation process to more realistic numbers. It is much easier to take costs out of the budget than it is to put them in later. We will discuss specifics on 2013 and 2014 labor costs in future closed sessions on labor negotiations. The current increased cost in this area for 2013 is $221,639. These increases include corrections to human resources costs detailed below, negotiated increases for the two LELS union, possible increases for the two AFSCME unions/non-union group, step increases for eligible employees and possible benefit increases. 2. Past Unbudgeted Human Resources Costs I shared already about the unbudgeted human resources costs that I discovered while going through the 2011 and 2012 budgets. These costs are for the payment of comp time during the year, health care savings plans and other pay (pager pay) issues that have been a part of our union contracts and personnel policies for many years. I estimate these costs to be very close to $120,000 in 2 2012 and 2013. This issue affects a few departments more than others. The departments impacted the most include all of the Police Department budgets, Municipal Services and Parks and Recreation. I have included all of the previously unbudgeted expenses in the 2013 budget. To not include costs that we know we will expend at this point would not be appropriate. 3. Revenue Expectations I have been watching the revenue line items in the 2012 budget and have some significant concerns about a number of areas. The proposed budget includes revenue reductions of$296,000 compared to 2012. Not achieving our revenues has just as big of an impact on our financial health as overspending our budget. The significant revenues that I proposed lowering for 2013 are detailed below. ✓ Animal Licenses-Reduced to the off year estimate amount. We issue two year licenses starting with the even numbered years but have had a constant amount in the revenue line item. This is a proposed reduction of $8,555. ✓ Building Permits-Reduced to a realistic estimate based on 2012 permit activity to date. The 2011 revenue number was achieved in large part because of the Dakota County CDA Vermillion River Crossings senior housing project construction. This line item should have been reduced in the 2012 budget. This is a proposed reduction of$90,000. ✓ Sewer Permits-Reduced to a realistic number based on 2011 and 2012 to date numbers. This is a proposed reduction of$6,000. ✓ Fire Township Fees-Reduced to reflect new agreements with Castle Rock and Eureka townships and Farmington's share of fire calls. This is a proposed reduction of$15,000. ✓ ISD 192 SRO Fees-Reduced to reflect the school district's request to have only one school resources officer in the schools effective January 1, 2013. This means that from the 2012 to the 2013 budget we will be going from three SRO's to one SRO. This is a proposed reduction of$96,148. ✓ Donations-Reduced to move away from depending on donations to cover operating costs. This is a proposed reduction of$20,000. ✓ Miscellaneous-Reduced to move away from depending on unknown items for operating costs. This is a proposed reduction of$28,507. ✓ Liquor Transfers-Reduced to better reflect the actual costs for liquor store support. This is a proposed reduction of$20,007. 3 There are other minor revenue reductions included in the budget. All of the revenue line items can be viewed in the actual budget document. 4. Delinquent Tax Levy I have included for discussion purposes a delinquent tax levy line item in the proposed budget of$75,000. I included this number in the draft to cause discussion about potentially including a line in the budget to cover some of the anticipated revenue in our budget that we do not receive in the year anticipated due to the non-payment of property taxes. 5. Ice Arena Tax Levy I have included for discussion purposes an ice arena tax levy to help cover the $250,000 negative fund balance that exists in the ice arena fund. I would propose that this tax levy be in place for the next ten years to help eliminate this deficit. The 2013/2014 ice arena budget that you will see soon will include a positive year end result. 6. Building Fund I have included the creation of a building fund in the transfers section of the budget in the amount of.$15,000. I propose to set up this account to start to set aside dollars for building maintenance and repairs over the years for all of our facilities. There is nothing significant about the $15,000 amount; the more important issue is that we actually consider starting a fund like this that will carry over from year to year. 7. Fire Truck Debt The debt line item includes the addition of$130,000 to account for the first payment on the fire truck purchase approved in 2012. 8. Fiscal Disparities I have lowered the anticipated fiscal disparities line item to $1,900,000 as a conservative approach to this issue for 2013. I will adjust the number to the actual number once we receive this in late August. By taking the conservative approach in this line item it has a negative impact on our net tax levy. If our history stays consistent, the actual number will be higher and the effect will be to reduce our net tax levy. 9. IT Costs When the IT internal service fund was first created, each department was charged a percentage of the total cost of IT. At that time, a higher percentage of 4 the cost of technology and support was allocated to the enterprise funds and the police department due to the complexity of the systems and advanced features needed in those areas. Over time, it has become necessary for other departments and divisions to have increased functionality, more support and greater computing power (faster speeds, more memory, specialized software, etc.). Additionally, some technologies have expanded so the costs of those can now be spread out over more departments. Examples of this are the card access and the video camera security systems. One of the departments experiencing a substantial increase in technology charges is the Fire Department. In the last few years, technology in the Fire Department has grown to include items such as mobile computers in fire trucks, specialized software for managing and maintaining fire department data and adding card access to Station 2. Due to these items, the fire department's cost of IT has increased dramatically. This is just one example of how costs for IT have shifted between departments that I wanted you to be aware of. Departmental Budgets The draft budget includes detailed information on each of the department budget requests. There are some issues with some of the budgets that will cause questions. have detailed some of the issues that you should be aware of below. 1. Legislative-I have included $3,000 for the potential purchase of new (pads if needed in 2013. 2. Administration-The reserve line item created in 2012 was reduced by$31,192 to help resolve the use of one-time dollars in 2012 to maintain the tax levy. The reserve line item still includes $110,000. 3. Elections-We have included $21,050 to pay our share of the new election equipment being purchased by the county. My plan was to try and get away from the rollercoaster type budgeting in elections of doing it one year and not the next. The required equipment purchase in 2013 achieves that goal. 4. City Hall-Professional services are proposed to increase by$24,400. This is due primarily to inclusion of actual costs we incur in the maintenance of city hall. We have spent dollars in a number of areas in the first three years of operating this building that have not been budgeted. We are trying to correct issues like this in future budgets. 5. Police Administration-The addition of unbudgeted human resources cost in the past impacts this budget by approximately$7,000. In addition, legal costs are anticipated to increase by$20,000 next year. Staff is researching this with the 5 city attorney's office. We are also currently looking at some early retirement opportunities for the city that may impact this department. More information on this issue will be brought to the City Council for discussion/input. 6. Police Patrol-The addition of unbudgeted human resources costs in the past impact this budget by approximately$45,000. The issue of the reduction of an SRO position by the school district will need to be discussed by the city council. While the school district revenue for this position is not included in the budget, the cost of the officer is still included in the draft budget. This budget also includes the purchase of three vehicles for the department in 2013 compared to two vehicles in 2012. 7. Police Investigations-This budget includes the addition of$8,200 in overtime. Most of the overtime is associated with the drug task force and some of these costs are reimbursed. This budget also is impacted by the inclusion of previously unbudgeted human resource costs. The current budget reflects the transfer of one SRO to the patrol budget (2012 decision) and still includes the SRO position that the school district has informed us that they will not need in 2013. 8. Fire Department-This budget includes an increase in the city contribution to the firefighter pension in the amount of$10,000 since that number is unknown at this point. In addition the budget includes $9,100 for increased supplies, $35,000 for building repairs (floor repairs and lighting upgrades at Station One), $130,000 for vehicles (two chiefs vehicles and a brush truck) and $81,000 for equipment (brush skid unit and a generator for Station One). 9. Engineering-The addition of unbudgeted human resources cost impact this budget by $2,000. 10.Building Inspections-The addition of unbudgeted human resources cost impact this budget by$2,200. 11.Streets-The addition of unbudgeted human resources costs impact this budget by $24,000. 12.Parks Maintenance-The addition of unbudgeted human resources costs impact this budget by$5,000. In addition there are increases in supplies in the amount of$9,000 (banners, garbage cans) and other repair in the amount of$15,000. The other repair increases is associated with increasing our trail maintenance line item from $15,000 to $30,000 in 2013. 13.Parks Pool-This budget includes the transfer of human resources costs that have added almost$10,000 to the budget. There are also proposed cost increases in the equipment/supplies area, building supplies and professional services line items. Some of the increases are for a new funbrella cover, a new chemical controller, reroofing the building, and pool bus cost increases among other items. 6 Other Discussion Items During the past few months a number of requests have been made about issues that need to be discussed during the budget process. At this point I have the following items on the list but obviously any and all items are up for discussion. ✓ Clean Up Day ✓ Rambling River Center Subsidy ✓ Waiving of Fees Summary I realize that the general fund budget document is a lot of information to comprehend in a short time. I wanted to remind you that you can review the budget in three different levels. The first level is simply the first page that shows you the summary of expenditures, revenues and the resulting tax levy. The second approach is to review the first four pages which start to break down the information by department and revenue area. The third approach gets to the department level of detail in expenditures and the line item level detail in revenues. You can select the level of information you would like to review. My goal for the work session is to present an overview of the budget document and answer questions you have at this point. There are a number of points I want you to be aware of and have some discussion on so you provide me with some direction. These include at this point: ✓ Revenue Reductions ($296,000) ✓ Fiscal Disparities Approach ($116,261) ✓ HR Costs for 2013 ✓ Inclusion of Missing HR Costs ($120,000) ✓ Delinquent Tax Levy ($75,000) ✓ Ice Arena Levy ($25,000) ✓ Building Fund Inclusion ($15,000) ✓ Fire Truck Payment ($130,000) ✓ Fire Equipment/Building Repairs ($246,000) ✓ School Resource Officer Position ✓ Tax Levy Target ✓ City Council Discussion Items I do not anticipate getting through all of the information included in this packet in our first work session. The more information we do review, the more direction I will have to make changes to the budget to meet your goals. Throughout the summer you will see all of the other funds/budgets presented to you for discussion and consideration as well. If you have questions on this information please let me know. Thank you for your time on this important matter. • 8 N 00 d' m N 00 00 1 f1 U I- n 06 Oi w CO Lf1 c-1 00 0 01 .--I N c-1 c-1 N N N V. V? V? V? Q^1 O N N > tll to 0 00 0 co 0 M d. N 01 trf t!1 I� L} t/} yr� VI elli o in to Tr U 00 00 W Q0.1 W Cr) N M 0 CO Cl. Ln N N N tiJ M tf1 c1 (/) LSD' N N M LO N VI t/? V? V} up 00 Cr) LO C7 dr n 01 M D 00 LD O lD Q LO c-I M ci N s-i e-+' c-I' V} ih V)- ` N M O N C /�` - O 01 LD I� O O -, CO 1^ 00 � N 11)-11)- V? V> V)- 4w iIUE -13c Ca M 1111 .. ..._11%1111111111111111111111b1„..LL — •... O ci ci tf1 N. O >- dY CO O al V W r1: ! ! H ! N r}tD tD lD 1� N O ON CO 11 r tr1 / V) V� V? V? V}LO/ N N 00 CO 0 / CO <-1 0 N c<-1 0 CPI O ci al r1' c-I c-r V} V} V} V)• V)• c-i <-1 O O 0l al d' CO d' (.D i Q N m N ri H H H V). in- tn. V1- V). CO O 0 - N 0 0 0 trl. 0 0 0 0 0 0 0 O N 0 0 O O O 0 0 O 0 0 O O O 6 11111 0 O O O Ln 0 ) Ln N N H. ci VI- c-1 <4 VI- Vl- V} t} V} a14l1 s!XV CITY OF FARMINGTON 2013 BUDGET BREAKDOWN BUDGET AND TAX LEVY SUMMARY EXPENDITURES 2012 2013 %CHANGE 2014 %CHANGE ADMINISTRATION $1,037,848 $989,277 -4.68% $990,112 0.08% HR/IT $248,329 $272,686 9.81% $199,905 -26.69% FINANCE $425,357 $438,148 3.01% $446,718 1.96% POLICE $3,877,398 $4,036,034 4.09% $4,130,112 2.33% FIRE $836,930 $1,116,692 33.43% $1,033,272 -7.47% ENGINEERING $890,922 $925,659 3.90% $927,007 0.15% MUNICIPAL SERVICES $800,891 $860,075 7.39% $870,667 1.23% PARKS/RECREATION $1,201,890 $1,288,123 7.17% $1,317,349 2.27% TRANSFERS $695,000 $415,000 -40.29% $440,000 6.02% TOTAL EXPENDITURES $10,014,565 $10,341,694 3.27% $10,355,142 0.13% REVENUES 2012 2013 %CHANGE 2014 %CHANGE LICENSES/PERMITS $431,455 $350,300 -18.81% $349,800 -0.14% FINES/FORFEITURES $70,000 $70,000 0.00% $70,000 0.00% INTEREST $80,000 $80,000 0.00% $75,000 -6.25% INTERGOVERNMENTAL $405,590 $407,600 0.50% $407,600 0.00% CHARGES FOR SERVICES $617,649 $471,700 -23.63% $477,200 1.17% MISCELLANEOUS $79,007 $30,000 -62.03% $30,000 0.00% TOTAL REVENUES $1,683,701 $1,409,600 -16.28% $1,409,600 0.00% TRANSFER REVENUES FUND REVENUES $350,035 $330,028 -5.72% $310,021 -6.06% GENERAL FUND BUDGET $10,014,565 $10,341,694 3.27% $10,355,142 0.13% GENERAL FUND REVENUES - $1,683,701 - $1,409,600 -16.28% $1,409,600 0.00% TRANSFERS OUT - $350,035 - $330,028 -5.72% $310,021 -6.06% FISCAL DISPARITIES - $2,016,261 - $1,900,000 -5.77% $1,900,000 0.00% SUB TOTAL $5,964,568 $6,702,066 12.36% $6,735,521 0.50% DEBT j $2,598,414 $2,728,414 5.00% + $2,728,414 0.00% AG CREDIT + $3,000 + $3,000 0.00% + $3,000 0.00% RESERVE + $0 + $0 #DIV/0! + $0 #DIV/0! DELINQUENT TAX LEVY + $0 + $75,000 #DIV/0! $75,000 0.00% ICE ARENA LEVY + + $25,000 UDIV/0! $25,000 0.00% NET TAX LEVY $8,565,982 $9,533,480 $9,566,935 11.29% 0.35% $967,498 $33,455 1 6/4/2012 CITY OF FARMINGTON 2013 BUDGET BREAKDOWN EXPENDITURES SUMMARY ADMINISTRATION 2012 2013 2014 LEGISLATIVE CONTROL $76,802 $81,279 5.83% $80,779 -0.62% HISTORICAL PRESERVATION $7,480 $7,500 0.27% $7,500 0.00% ADMINISTRATION $611,761 $598,451 -2.18% $607,569 1.52% ELECTIONS $22,123 $24,450 10.52% $24,062 -1.59% COMMUNICATIONS $83,080 $93,050 12.00% $85,492 -8.12% CITY HALL $140,714 $167,426 18.98% $175,136 4.61% COMMUNITY DEVELOPMENT $95,888 $17,121 -82.14% $9,574 -44.08% TOTAL ADMINISTRATION $1,037,848 $989,277 -4.68% $990,112 0.08% HUMAN RESOURCES/IT 2012 2013 2014 HUMAN RESOURCES $248,329 $272,686 9.81% $199,905 -26.69% TOTAL HR/IT $248,329 $272,686 9.81% $199,905 -26.69% FINANCE 2012 2013 2014 ACCOUNTING $298,107 $305,898 2.61% $309,468 1.17% RISK MANAGEMENT $127,250 $132,250 3.93% $137,250 3.78% TOTAL FINANCE $425,357 $438,148 3.01% $446,718 1.96% POLICE 2012 2013 2014 ADMINISTRATION $795,355 $815,949 2.59% $850,644 4.25% PATROL $2,308,911 $2,515,226 8.94% $2,560,653 1.81% INVESTIGATIONS $761,157 $699,459 -8.11% $713,415 2.00% EMERGENCY MANAGEMENT $11,975 $5,400 -54.91% $5,400 0.00% TOTAL POLICE $3,877,398 $4,036,034 4.09% $4,130,112 2.33% FIRE 2012 2013 2014 FIRE $790,259 $1,067,491 35.08% $985,032 -7.72% RESCUE $46,671 $49,201 5.42% $48,240 -1.95% TOTAL FIRE $836,930 $1,116,692 33.43% $1,033,272 -7.47% ENGINEERING 2012 2013 2014 ENGINEERING $248,097 $258,716 4.28% $258,266 -0.17% PLANNING $247,412 $248,870 0.59% $258,534 3.88% BUILDING INSPECTIONS $298,365 $312,895 4.87% $312,596 -0.10% NATURAL RESOURCES $97,048 $105,178 8.38% $97,611 -7.19% TOTAL ENGINEERING $890,922 $925,659 3.90% $927,007 0.15% 2 MUNICIPAL SERVICES 2012 2013 2014 STREETS $576,036 $630,387 9.44% $638,113 1.23% SNOW REMOVAL $224,855 $229,688 2.15% $232,554 1.25% TOTAL MUNICIPAL SERVICES $800,891 $860,075 7.39% $870,667 1.23% PARKS AND RECREATION 2012 2013 PARK MAINTENANCE $553,396 $608,433 9.95% $638,648 4.97% RAMBLING RIVER CENTER $159,420 $166,964 4.73% $167,261 0.18% ADMINISTRATION $249,686 $242,779 -2.77% $250,446 3.16% RECREATION PROGRAMS $116,850 $118,110 1.08% $122,034 3.32% POOL $122,538 $151,837 23.91% $138,960 -8.48% TOTAL PARKS AND RECREATION $1,201,890 $1,288,123 7.17% $1,317,349 2.27% TOTAL EXEPENDITURES $9,319,565 $9,926,694 6.51% $9,915,142 -0.12% TRANSFERS 2012 2013 2014 RECREATION $120,000 $0 -100.00% $0 #DIV/0! SEAL COATING $350,000 $350,000 0.00% $375,000 7.14% EDA DEFICIT $175,000 $0 -100.00% $0 #DIV/0! EDA OPERATIONS $50,000 $50,000 0.00% $50,000 0.00% BUILDING FUND $0 $15,000 #DIV/0! $15,000 0.00% TOTAL TRANSFERS $695,000 $415,000 -40.29% $440,000 6.02% GRAND TOTAL EXPENDITURES $10,014,565 $10,341,694 3.27% $10,355,142 0.13% 3 CITY OF FARMINGTON 2013 BUDGET BREAKDOWN REVENUE SUMMARY REVENUES 2012 2013 2014 LICENSES/PERMITS $431,455 $350,300 -18.81% $349,800 -0.14% FINES/FORFEITURES $70,000 $70,000 0.00% $70,000 0.00% INTEREST $80,000 $80,000 0.00% $75,000 -6.25% INTERGOVERNMENTAL $405,590 $407,600 0.50% $407,600 0.00% CHARGES FOR SERVICES $617,649 $471,700 -23.63% $477,200 1.17% MISCELLANEOUS $79,007 $30,000 -62.03% $30,000 0.00% TOTAL OPERATING REVENUE $1,683,701 $1,409,600 -16.28% $1,409,600 0.00% TRANSFERS 2012 2013 2014 LIQOUR OPERATIONS $70,007 $50,000 71.42% $50,000 0.00% SEWER $70,007 $70,007 100.00% $50,000 -28.58% STORM WATER $70,007 $70,007 100.00% $70,007 0.00% REFUSE $70,007 $70,007 100.00% $70,007 0.00% WATER $70,007 $70,007 100.00% $70,007 0.00% TOTAL TRANSFERS IN $350,035 $330,028 -5.72% $310,021 -6.06% TOTAL REVENUES $2,033,736 $1,739,628 -14.46% $1,719,621 -1.15% 4 CITY OF FARMINGTON 2013 BUDGET BREAKDOWN REVENUES SUMMARY ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED LICENSES/PERMITS 2011 12/2011 2012 4/2012 2013 2014 LIQUOR LICENSES $16,000 $24,850 155.31% $16,000 $13,150 82.19% $20,000 $20,000 BEER LICENSES $2,000 $3,075 153.75% $2,000 $1,800 90.00% $3,000 $3,000 CLUB LICENSES $900 $300 33.33% $900 $300 33.33% $300 $300 ANIMAL LICENSES $9,755 $1,178 12.08% $9,755 $6,210 63.66% $1,200 $1,200 ARCADE LICENSES $0 $690 #DIV/0! $0 $760 #DIV/0! $500 $0 MASSAGE LICENSES $1,000 $550 55.00% $1,000 $250 25.00% $500 $500 GAMBLING LICENSES/PERMITS $1,000 $300 30.00% $1,000 $150 15.00% $300 $300 OTHER LICENSES $1,500 $1,400 93.33% $1,500 $2,675 178.33% $2,000 $2,000 TOTAL LICENSES/PERMITS $32,155 $32,343 100.58% $32,155 $25,295 78.67% $27,800 $27,300 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERMITS 2011 12/2011 2012 4/2012 2013 2014 BUILDING PERMITS $340,000 $345,880 101.73% $340,000 $84,701 24.91% $250,000 $250,000 REINSPECTION FEES $300 $465 155.00% $300 $63 21.00% $300 $300 PLUMBING/HEATING PERMITS $35,000 $44,920 128.34% $35,000 $7,677 21.93% $39,000 $39,000 SEWER PERMITS $10,000 $4,560 45.60% $10,000 $1,425 14.25% $4,000 $4,000 ELECTRIC PERMITS $0 $20,646 #DIV/0! $0 $3,149 #DIV/0! $15,000 $15,000 ISTS PERMIT $0 $700 #DIV/0! $0 $90 #DIV/0! $500 $500 COUNTY SEPTIC FEE PERMIT $0 $40 #DIV/0! $0 -$40 #DIV/0! $0 $0 UTILITY PERMITS $3,000 $5,835 194.50% $3,000 $3,360 112.00% $4,000 $4,000 STREET BREAKING PERMITS $0 $210 #DIV/0! $0 $0 #DIV/0! $200 $200 SIGN PERMITS $1,000 $570 57.00% $1,000 $320 32.00% $500 $500 BURNING PERMITS $5,000 $4,330 86.60% $5,000 $1,610 32.20% $4,000 $4,000 OTHER PERMITS $5,000 $9,565 191.30% $5,000 $1,505 30.10% $5,000 $5,000 TOTAL PERMITS $399,300 $437,721 109.62% $399,300 $103,860 26.01% $322,500 $322,500 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED FINES AND FORFEITURES 2011 12/2011 2012 4/2012 2013 2014 FINES $70,000 $78,460 112.09% $70,000 $16,162 23.09% $70,000 $70,000 CODE VIOLATIONS/FINE $0 $0 #DIV/0! $0 $825 #DIV/0! $0 $0 TOTAL FINES/FORFEITURES $70,000 $78,460 112.09% $70,000 I $16,987 24.27% $70,000 $70,000 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED INTERGOVERNMENTAL 2011 12/2011 2012 4/2012 2013 2014 STATE AID-MAINTENANCE $163,140 $173,857 106.57% $163,140 $96,503 59.15% $163,150 $163,150 STATE AID-POLICE $154,000 $165,749 107.63% $154,000 $0 0.00% $155,000 $155,000 STATE AID-POST TRAINING $9,000 $23,493 261.03% $9,000 $1,730 19.22% $10,000 $10,000 STATE AID-FIRE $73,000 $87,709 120.15% $73,000 $0 0.00% $73,000 $73,000 5 OTHER-STATE GRANT $0 $13,350 #DIV/0! $0 $0 #DIV/0! $0 $0 OTHER-DAKOTA COUNTY $5,250 $16,038 305.49% $5,250 $0 0.00% $5,250 $5,250 OTHER $1,200 $2,209 184.08% $1,200 $0 0.00% $1,200 $1,200 TOTAL INTERGOVERNMENTAL $405,590 $482,405 118.94% $405,590 $98,233 24.22% $407,600 $407,600 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED CHARGES FOR SERVICES 2011 12/2011 2012 4/2012 2013 2014 CUSTOMER SERVICE FEES $1,000 $559 55.90% $1,000 $176 17.60% $500 $500 ZONING/SUBDIVISION FEES $3,000 $3,825 127.50% $3,000 $600 20.00% $3,500 $3,500 PRE PLATADMIN FEES $5,000 $750 15.00% $5,000 $0 0.00% $1,000 $1,000 FIRE TOWNSHIP FEES $170,000 $187,077 110.05% $145,000 $20,529 14.16% $130,000 $130,000 ISD 192 SRO FEES $205,377 $232,269 113.09% $171,148 $56,320 32.91% $75,000 $75,000 EROSION/SEDIMENT CONTROL $12,000 $10,400 86.67% $12,000 $3,600 30.00% $9,000 $9,000 GIS FEES $2,000 $220 11.00% $2,000 $0 0.00% $200 $200 PUBLIC WORKS CHARGES $0 $3,434 #DIV/0! $0 $0 #DIV/0! $3,000 $3,000 RECREATION PROGRAM FEES $103,675 $96,036 92.63% $103,675 $24,944 24.06% $100,000 $100,000 POOL ADMISSIONS $38,000 $36,520 96.11% $39,000 $750 1.92% $37,000 $39,000 SWIM LESSON FEES $18,000 $16,885 93.81% $18,500 $225 1.22% $17,000 $18,500 POOL CONCESSIONS $11,000 $9,208 83.71% $11,000 $0 0.00% $9,000 $11,000 RRC FEES RRC $0 $0 #DIV/0! $19,000 $3,222 16.96% $0 $0 RRC MEMBERSHIP FEES $8,500 $0 0.00% $8,500 $14,957 175.96% $9,000 $9,000 ADVERTISING $0 $0 #DIV/0! $0 $400 #DIV/0! $0 $0 RECREATION ADVERTISING $2,200 $1,950 88.64% $2,200 $1,650 75.00% $1,500 $1,500 SALE OF ASSETTS $1,626 $0 0.00% $1,626 $3,260 200.49% $1,000 $1,000 FRANCHISE FEES $75,000 $75,000 100.00% $75,000 $0 0.00% $75,000 $75,000 TOTAL CHARGES FOR SERVICE $656,378 $674,133 102.70% $617,649 $130,633 21.15% $471,700 $477,200 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED MISCELLANEOUS 2011 12/2011 2012 4/2012 2013 2014 INVESTMENT INCOME $200,000 $135,600 67.80% $80,000 $18,171 22.71% $80,000 $75,000 DONATIONS $0 $5,520 #DIV/0! $26,000 $7,804 30.02% $6,000 $6,000 RENTALS $7,000 $18,225 260.36% $18,500 $8,378 45.29% $18,000 $18,000 MISCELLANEOUS $62,000 $7,058 11.38% $34,507 $3,472 10.06% $6,000 $6,000 TOTAL MISCELLANEOUS $269,000 $166,403 61.86% $159,007 $37,825 23.79% $110,000 $105,000 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED TRANSFERS 2011 12/2011 2012 4/2012 2013 2014 LIQUOR OPERATIONS $70,007 $70,007 100.00% $70,007 $116,680 166.67% $50,000 $50,000 SEWER $70,007 $70,007 100.00% $70,007 $0 0.00% $70,007 $50,000 STORM WATER $70,007 $70,007 100.00% $70,007 $0 0.00% $70,007 $70,007 REFUSE $70,007 $70,007 100.00% $70,007 $0 0.00% $70,007 $70,007 WATER $70,007 $70,007 100.00% $70,007 $0 0.00% $70,007 $70,007 TOTAL TRANSFERS $350,035 $350,035 100.00% $350,035 $116,680 33.33% $330,028 $310,021 6 TOTAL REVENUES $2,182,458 $2,221,500 101.79% $2,033,736 $529,513 26.04% $1,739,628 $1,719,621 7 CITY OF FARMINGTON 2013 BUDGET ADMINISTRATION-LEGISLATIVE CONTROL ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6120 SALARIES-PT $36,120 $36,120 100.00% $36,120 $13,093 36.25% $36,120 $36,120 6152 FICA/MEDICARE $2,763 $2,763 100.00% $2,763 $1,002 36.26% $2,763 $2,763 6154 PERA $0 $0 #DIV/01 $0 $0 #DIV/01 $0 $0 6158 EMPLOYEE BENEFITS $69 $69 100.00% $69 $23 33.33% $146 $146 TOTAL PERSONNEL $38,952 $38,952 100.00% $38,952 $14,118 36.24% $39,029 $39,029 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/01 $3,000 $2,000 TOTAL OFFICE SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/0I $3,000 $2,000 OTHER SERVICES 6403 LEGAL $25,000 $15,185 60.74% $22,000 $3,720 16.91% $22,000 $22,500 6250 OTHER SUPPLIES $0 $0 #DIV/01 $0 $42 #DIV/0I $0 $0 6460 DUES/SUBSCRIPTIONS $12,515 $14,757 117.91% $14,665 $75 0.51% $15,000 $15,000 6470 TRAINING/SUBSISTANCE $985 $1,408 142.94% $985 $319 32.39% $2,000 $2,000 6485 MILEAGE $200 $265 132.50% $200 $42 21.00% $250 $250 TOTAL OTHER SERVICES $38,700 $31,615 81.69% $37,850 $4,198 11.09% $39,250 $39,750 TOTAL BUDGET $77,652 $70,567 90.88% $76,802 $18,316 23.85% $81,279 $80,779 6/4/2012 8 Legislative Control CITY OF FARMINGTON - 2013 BUDGET REVIEW ADMINISTRATION-HPC ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6120 SALARIES-PT $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6152 FICA/MEDICARE $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6154 PERA $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6158 EMPLOYEE BENEFITS $69 $0 0.00% $0 $0 -100.00% $0 $0 TOTAL PERSONNEL $69 $0 0.00% $0 $0 -100.00% $0 $0 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/01 $0 $0 #DIV/0I $20 $20 TOTAL SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/0I $20 $20 OTHER SERVICES 6401 PROFESSIONAL SERVICES $7,100 $6,000 84.51% $7,100 $3,000 42.25% $7,100 $7,100 6460 DUES/SUBSCRIPTIONS $220 $30 13.64% $220 $0 0.00% $220 $220 6470 TRAINING/SUBSISTANCE $100 $100 100.00% $100 $0 0.00% $100 $100 6485 MILEAGE $60 $0 0.00% $60 $0 0.00% $60 $60 TOTAL OTHER SERVICES $7,480 $6,130 81.95% $7,480 $3,000 40.11% $7,480 $7,480 TOTAL BUDGET $7,549 $6,130 81.20% $7,480 $3,000 40.11% $7,500 $7,500 6/4/2012 9 Administration-HPC CITY OF FARMINGTON 2013 BUDGET ADMINISTRATION-CITY ADMINISTRATOR ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $266,677 $298,008 111.75% $251,564 $82,099 32.64% $260,910 $260,325 6112 SALARIES-OT $1,375 $0 I 0.00% $0 $0 _#DIV/0! $0 $0 6120 SALARIES-PT $0 J $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $86 #DIV/0! $0 $0 6152 FICA/MEDICARE $20,506 $22,481 109.63% $19,245 $6,435 33.44% $19,960 $19,915 6154 PERA $19,434 $19,615 100.93% $18,238 $5,959 32.67% $18,916 $18,874 6156 HCSP $0 $35 #DIV/0! $0 $149 #DIV/0! $465 $465 6158 EMPLOYEE BENEFITS $95,762 $47,789 49.90% $76,326 $26,099 34.19% $76,017 $90,635 6159 WORKERS COMPENSATION $0 $0 #DIV/0! $0 $574 #DIV/0! $0 $0 TOTAL PERSONNEL $403,754 $387,928 96.08% $365,373 $121,401 33.23% $376,268 $390,214 SUPPLIES 6210 OFFICE SUPPLIES $27,000 $15,784 58.46% $20,000 $4,165 20.83% $20,000 $20,000 6220 EQUIPMENT SUPPLIES $3,000 $0 0.00% $2,500 $0 0.00% $2,500 $2,500 TOTAL SUPPLIES $30,000 $15,784 52.61% $22,500 $4,165 18.51% $22,500 $22,500 OTHER SERVICES 6401 PROFESSIONAL SERVICES $5,700 I $3,623 I 63.56% $5,700 $2,194 38.49% $6,700 $6,700 6403 LEGAL $11,250 $20,375 181.11% $11,000 $3,280 29.82% $11,000 $11,500 6404 IT SERVICES $7,185 $7,185 100.00% $8,156 $2,718 33.33% $12,823 $7,445 6412 CELLULAR TELEPHONES $840 $405 48.21% $540 $180 33.33% $540 $540 6455 LEGAL PUBLICATION $1,500 $498 33.20% $1,000 $0 0.00% $1,000 $1,050 6460 DUES/SUBSCRIPTIONS $2,755 $289 10.49% $1,500 $68 4.53% $2,050 $2,050 6470 TRAINING/SUBSISTANCE $3,160 $1,139 36.04% $2,000 $0 0.00% $2,100 $2,100 6480 MEETING EXPENSE $0 $35 #DIV/0! $0 $0 #DIV/0! $0 $0 6485 MILEAGE $2,500 $737 29.48% $1,600 $134 8.38% $1,500 $1,500 6492 ADVERTISING $0 $84 #DIV/0! $0 $0 I #DIV/01 $0 $0 6505 EQUIPMENT REPAIR $20,920 $18,283 87.39% $18,500 $4,684 Il 25.32% $19,070 $19,070 6555 EQUIPMENT RENTAL $32,700 $33,120 101.28% $32,700 $8,839 27.03% $32,900 $32,900 7420 MISCELLANEOUS $0 $0 #DIV/0! $141,192 $0 0.00% $110,000 $110,000 TOTAL OTHER SERVICES $88,510 $85,773 96.91% $223,888 $22,097 9.87% $199,683 $194,855 TOTAL BUDGET I $522,264 $489,485 93.72% I $611,761 $147,663 I 24.14% $598,451 I $607,569 6/4/2012 City Administrator 10 CITY OF FARMINGTON 2013 BUDGET ADMINISTRATION-ELECTIONS ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $0 $0 #DIV/0! $0 $0 #DIV/0I $0 $0 6112 SALARIES-OT $0 $0 #DIV/0I $950 $0 0.00% $0 $1,000 6120 SALARIES-PT $0 $0 #DIV/OI $0 $0 #DIV/01 $0 $15,000 6152 FICA/MEDICARE $0 $0 #DIV/01 $73 $0 0.00% $0 $1,224 6154 PERA $0 $0 #DIV/0I $69 $0 0.00% $0 $73 6156 HCSP $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6158 EMPLOYEE BENEFITS $0 $0 #DIV/0I $6 $2 33.33% $0 $65 TOTAL PERSONNEL $0 $0 #DIV/0I $1,098 $2 0.18% $0 $17,362 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $300 $0 0.00% $300 $300 6220 EQUIPMENT SUPPLIES $1,925 $1,925 100.00% $1,925 $1,925 100.00% $21,050 $2,100 6250 OTHER SUPPLIES $0 $0 #DIV/0! $2,000 $0 0.00% $2,000 $2,000 TOTAL SUPPLIES $1,925 $1,925 100.00% $4,225 $1,925 45.56% $23,350 $4,400 OTHER SERVICES 6401 PROFESSIONAL SERVICES $0 $0 #DIV/0I $14,500 $1,111 7.66% $0 $0 6403 LEGAL $0 $0 #DIV/oI $0 $0 #DIV/01 $0 $0 6404 IT SERVICES $0 $0 #DIV/0I $0 $0 #DIV/0! $0 $0 6445 POSTAGE $0 $0 #DIV/0I $400 $0 0.00% $400 $400 6450 OUTSIDE PRINTING $0 $397 #DIV/OI $700 $0 0.00% $700 $700 6455 LEGAL PUBLICATION $0 $0 #DIV/01 $375 $0 0.00% $0 $375 6460 DUES/SUBSCRIPTIONS $0 $0 #DIV/0I $0 $0 #DIV/OI $0 $0 6470 TRAINING/SUBSISTANCE $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6480 MEETING EXPENSE $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6485 MILEAGE $0 $0 #DIV/0I $425 $0 0.00% $0 $425 6492 ADVERTISING $0 $0 #DIV/0! $0 $0 #DIV/0I $0 $0 6505 EQUIPMENT REPAIR $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0I $400 $0 0.00% $0 $400 7420 MISCELLANEOUS $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $0 $397 #DIV/0I $16,800 $1,111 6.61% $1,100 $2,300 TOTAL BUDGET $1,925 $2,322 120.62% $22,123 $3,038 13.73% $24,450 $24,062 Elections 11 CITY OF FARMINGTON 2013 BUDGET 1014 I ADMINISTRATION-COMMUNICATIONS ADOPTED THROUGH APPROVED THROUGH I REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $49,088 $49,234 100.30% $49,579 $16,186 32.65% $50,336 $51,091 6112 SALARIES-OT $0 $0 #DIV/0! $0 $214 #DIV/0! $500 $500 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $35 #DIV/0! $0 $18 #DIV/0! $0 $0 6152 FICA/MEDICARE $3,755 $3,662 97.52% $3,793 $1,278 33.69% $3,889 $3,947 6154 PERA $3,559 $3,572 100.37% $3,594 $1,190 33.11% $3,649 $3,704 6156 HCSP $0 $0 #DIV/0! $0 $66 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $12,084 $12,927 106.98% $10,359 $3,706 35.78% $10,206 $10,609 6159 WORKERS COMPENSATION $0 I $0 #DIV/0! $0 $113 #DIV/0! $0 $0 TOTAL PERSONNEL $68,486 $69,430 101.38% $67,325 $22,771 33.82% $68,580 $69,851 SUPPLIES I 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 I #DIV/0! $0 $0 TOTAL SUPPLIES $0 $0 #DIV/0! $0 $0 , #DIV/0! $0 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES $300 $0 0.00% $300 $0 0.00% $300 $300 6403 LEGAL $0 $0 #DIV/0! $0 $0 I #DIV/0! $0 $0 6404 IT SERVICES $1,150 L $1,150 100.00% $1,305 $1,522 I 116.63% $10,020 _ $1,191 6412 CELLULAR TELEPHONES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6445 POSTAGE $14,000 $8,322 59.44% $13,500 $4,212 31.20% $13,500 $13,500 6460 DUES/SUBSCRIPTIONS $0 $60 #DIV/0! $0 $0 #DIV/01 $0 $0 6470 TRAINING/SUBSISTANCE $300 $249 83.00% $450 $0 0.00% $450 $450 6480 MEETING EXPENSE $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6485 MILEAGE $200 $173 86.50% $200 $40 20.00% $200 $200 6492 ADVERTISING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 7420 MISCELLANEOUS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $15,950 $9,954 62.41% $15,755 $5,774 36.65% $24,470 $15,641 TOTAL BUDGET $84,436 $79,384 94.02% I $83,080 $28,545 34.36% $93,050 $85,492 6/4/2012 1 2 Administration-Communications CITY OF FARMINGTON 2013 BUDGET 1015 ADMINISTRATION-CITY HALL ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $12,272 $9,213 75.07% $14,238 $4,911 34.49% $11,832 $12,010 6112 SALARIES-OT $0 $15 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $0 $103 #DIV/01 $0 $0 #DIV/01 $0 $0 6130 COMP TIME PAY $0 $838 #DIV/0! $0 $0 #DIV/0! $800 $800 6135 OTHER PAY $0 $205 #DIV/0! $0 $383 #DIV/0! $600 $600 6152 FICA/MEDICARE $939 $800 85.20% $1,089 $407 37.37% $1,012 $1,026 6154 PERA $890 $752 84.49% $1,032 $384 37.21% $1,114 $1,131 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $10,476 $10,651 101.67% $10,117 $3,714 36.71% $10,068 $10,469 6159 WORKERS COMPENSATION $0 $0 #DIV/0! $0 $33 #DIV/0! $0 $0 TOTAL PERSONNEL $24,577 $22,577 91.86% $26,476 $9,832 37.14% $25,426 $26,036 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/01 $0 $0 #DIV/0! $3,500 $3,600 6220 EQUIPMENT SUPPLIES $750 $3,213 428.40% $1,700 $2,100 123.53% $3,550 $3,950 6240 BUILDING SUPPLIES $2,250 $7,483 332.58% $2,900 $1,318 45.45% $0 $0 6242 CLEANING SUPPLIES $2,500 $0 0.00% $1,500 $0 0.00% $500 $600 6250 OTHER SUPPLIES $500 $212 42.40% $1,000 $0 0.00% $500 $600 6255 LANDSCAPING SUPPLIES $60 $0 0.00% $60 $0 0.00% $200 $150 6272 FUEL I $0 $2,386 #DIV/0! $0 $130 #DIV/0! $2,700 $2,900 TOTAL SUPPLIES $6,060 $13,294 219.37% $7,160 $3,548 49.55% $10,950 $11,800 OTHER SERVICES 6401 PROFESSIONAL SERVICES $61,145 $60,681 99.24% $36,700 $19,651 53.54% $61,100 $64,150 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6421 MUNICIPAL SERVICES $0 $3,570 #DIV/0! $3,800 $1,839 48.39% $3,800 $3,900 6422 ELECTRIC $28,750 $39,714 138.14% $38,000 $10,580 27.84% $40,000 $41,000 6423 NATURAL GAS $22,750 $21,323 93.73% $21,578 $7,704 35.70% $22,000 $23,000 6460 DUES/SUBSCRIPTIONS $0 $145 #DIV/0! $0 $50 #DIV/0! $150 $175 6470 TRAINING/SUBSISTANCE $0 $0 #DIV/01 $0 $300 #DIV/0! $500 $525 6480 MEETING EXPENSE $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6492 ADVERTISING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 _ $0 6505 EQUIPMENT REPAIR $1,860 $674 36.24% $1,000 $739 _ 73.90% _$1,000 $1,450 6515 BUILDING MAINTENANCE $0 $4,240 #DIV/0! $6,000 $60 1.00% $2,500 $3,100 TOTAL OTHER SERVICES $114,505 $130,347 113.84% $107,078 $40,923 38.22% $131,050 $137,300 6/4/2012 13 Administration-City Hall TOTAL BUDGET $145,142 $166,218 114.52% $140,714 $54,303 38.59% $167,426 $175,136 6/44/2012 1 4 Administration-City Hall CITY OF FARMINGTON 2013 BUDGET 1035 ADMINISTRATION-COMMUNITY DEVELOPMENT ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $65,062 $67,872 104.32% $65,713 $10,669 16.24% $0 $0 6112 SALARIES-OT $0 $24 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $0 I $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $162 #DIV/0! $0 $0 #DIV/01 $0 $0 6152 FICA/MEDICARE $4,977 $4,805 96.54% $5,027 $763 15.18% $0 $0 6154 PERA $4,717 $4,934 104.60% $4,764 $773 16.23% $0 $0 6156 HCSP $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $12,193 $12,561 103.02% $10,469 $3,342 31.92% $0 $0 6159 WORKERS COMP $0 $0 #DIV/0! $0 $149 #DIV/oI $0 $0 TOTAL PERSONNEL $86,949 $90,358 103.92% $85,973 $15,696 18.26% $0 $0 SUPPLIES 6210 OFFICE SUPPLIES $0 $73 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $0 $73 #DIV/0! $0 $0 #DIV/0! $0 $0 OTHER SERVICES _ 6401 PROFESSIONAL SERVICES $1,700 $0 0.00% $1,000 $1,343 134.30% $1,000 $1,000 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $3,499 $3,449 98.57% $3,915 $1,305 33.33% $11,121 $3,574 6412 CELLULAR TELEPHONES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6455 LEGAL PUBLICATION $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $500 $0 0.00% $1,000 $1,250 125.00% $1,000 $1,000 6470 TRAINING/SUBSISTANCE $300 $263 87.67% $500 $225 45.00% $500 $500 6480 MEETING EXPENSE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6485 MILEAGE $400 I $85 21.25% $200 $0 0.00% $200 $200 6492 ADVERTISING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6570 PROGRAM EXPENSE $0 $0 #DIV/0! $3,300 $1,061 32.15% $3,300 $3,300 7420 MISCELLANEOUS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $6,399 $3,797 59.34% $9,915 $5,184 52.28% _ $17,121 _ $9,574 TOTAL BUDGET $93,348 $94,228 100.94% $95,888 j $20,880 21.78% $17,121 $9,574 6/4/2012 15 Administration-Community Development CITY OF FARMINGTON 1 2013 BUDGET L _ _ 1011 HUMAN RESOURCES ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $155,954 $161,961 103.85% $159,159 $54,219 34.07% $161,570 $115,846 6112 SALARIES-OT $0 I $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $11,930 $12,576 105.41% $12,176 $4,216 34.63% $12,360 $8,862 6154 PERA $11,307 $11,742 103.85% $11,539 $3,930 34.06% $11,729 $7,433 6156 HCSP $0 $1,231 #DIV/0! $0 $404 #DIV/0! $1,249 $1,300 6158 EMPLOYEE BENEFITS $21,851 $22,466 102.81% $17,985 $6,374 35.44% $20,655 $10,815 6159 WORKERS COMP $0 $0 #DIV/0! $0 $363 #DIV/0! $0 $0 TOTAL PERSONNEL I $201,042 $209,976 104.44% $200,859 $69,506 34.60% $207,563 $144,256 SUPPLIES 6210 OFFICE SUPPLIES $0 $321 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $0 $321 #DIV/0! $0 $0 #DIV/0! $0 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES I $3,700 $8,905 240.68% $7,200 $1,802 25.03% $14,000 $14,000 6402 DATA PROCESSING $20,000 $20,561 102.81% $27,159 $9,794 36.06% $27,840 $27,840 6403 LEGAL $2,000 $3,930 196.50% I $2,000 $615 30.75% $2,000 $2,000 6404 IT SERVICES $4,024 $4,024 100.00% $4,568 $435 9.52% $12,693 _ $4,169 6412 CELLULAR TELEPHONES $503 $1,126 223.86% $503 $50 9.94% $220 $220 6455 LEGAL PUBLICATION $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $950 $690 72.63% $950 $369 38.84% $855 $855 6470 TRAINING/SUBSISTANCE $1,890 $125 6.61% $1,890 $0 0.00% $1,465 $1,465 6480 MEETING EXPENSE $0 $704 #DIV/0! $0 $0 #DIV/0! $0 $0 6485 MILEAGE $1,000 $0 0.00% $700 $242 34.57% $800 $800 6494 EMPLOYMENT ADVERTISE $1,000 $1,942 194.20% $1,500 $585 39.00% $2,000 $2,000 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 7420 MISCELLANEOUS $2,050 $909 44.34% $1,000 $600 60.00% $3,250 $2,300 TOTAL OTHER SERVICES $37,117 $42,916 115.62% $47,470 I $14,492 30.53% $65,123 $55,649 TOTAL BUDGET I $238,159 I $253,213 106.32% $248,329 $83,998 33.83% $272,686 I $199,905 6/4/201 Z 16 Human Resources CITY OF FARMINGTON 2013 BUDGET 1021 FINANCE-ACCOUNTING ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $170,015 $176,586 103.86% $161,067 $54,371 33.76% $163,488 $165,940 6112 SALARIES-OT $2,000 $180 9.00% $0 $273 #DIV/0! $1,000 $1,000 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $20 #DIV/0! $0 $0 #DIV/0! $50 $50 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $13,006 $12,673 97.44% $12,322 $3,993 32.41% $12,587 $12,775 6154 PERA $12,326 $12,817 103.98% $11,677 $3,962 33.93% $13,268 $13,466 6156 HCSP $0 $526 #DIV/0! $0 $171 #DIV/0! $539 $560 6158 EMPLOYEE BENEFITS $35,462 $35,462 100.00% I $28,018 $10,366 37.00% $30,741 $31,952 6159 WORKERS COMP $0 $0 #DIV/0! $0 $367 #DIV/0! $0 $0 TOTAL PERSONNEL $232,809 $238,264 102.34% $213,084 $73,503 34.49% $221,673 $225,743 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $500 $0 6220 EQUIPMENT SUPPLIES $0 ' $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6240 BUILDING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6250 OTHER SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6255 LANDSCAPING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6272 FUEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $500 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES $21,600 $14,264 66.04% $34,100 $22,912 67.19% $27,180 $27,180 6402 DATA PROCESSING $38,000 $38,353 100.93% $39,905 $17,705 44.37% $39,905 $39,905 6403 LEGAL $400 $215 53.75% $400 $315 78.75% $400 $400 6404 IT SERVICES $5,174 $5,174 100.00% $5,873 $1,958 33.34% $11,645 $11,645 6412 CELLULAR TELEPHONES $300 $300 100.00% $300 $100 33.33% $300 $300 6440 POSTAGE/PRINTING $750 $0 0.00% $0 $0 #DIV/01 $0 $0 6450 OUTSIDE PRINTING $350 $0 0.00% $350 $0 0.00% $350 $350 6455 LEGAL PUBLICATION $400 $262 65.50% $400 $0 0.00% $400 $400 6460 DUES/SUBSCRIPTIONS $1,170 $915 78.21% $1,195 $305 25.52% $995 $995 6470 TRAINING/SUBSISTANCE $1,100 $1,439 130.82% $1,600 $140 8.75% $1,650 $1,650 6485 MILEAGE $1,000 $959 95.90% $900 $313 34.78% $900 $900 7420 MISCELLANEOUS $240 $0 0.00% $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $70,484 $61,881 87.79% $85,023 $43,748 51.45% $83,725 $83,725 6/4/2012 1 7 Finance ITOTAL BUDGET $303,293 I $300,145 I 98.96% I $298,107 I $117,251 I 39.33% I $305,898 I $309, I • • • Finance 6/4/2012 1 8 CITY OF FARMINGTON 2013 BUDGET 1022 FINANCE-RISK MANAGEMENT ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6112 SALARIES-OT $0 $0 #DIV/OI $0 $0 #DIV/O! $0 $0 6120 SALARIES-PT $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6135 OTHER PAY $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6152 FICA/MEDICARE $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6154 PERA $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6156 HCSP $0 $0 #DIV/O! $0 $0 #DIV/O! $0 $0 6158 EMPLOYEE BENEFITS $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 TOTAL PERSONNEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/O1 $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/01 $0 $0 #DIV/01 $0 $0 6240 BUILDING SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6250 OTHER SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/OI $0 $0 6255 LANDSCAPING SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6272 FUEL $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 TOTAL SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES $0 $0 #DIV/01 $0 $0 #DIV/OI $0 $0 - 6402 DATA PROCESSING $0 $0 #DIV/O! $0 $0 #DIV/O! $0 $0 6403 LEGAL $0 $0 #DIV/Ol $0 $0 #DIV/0I $0 $0 6404 IT SERVICES $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6426 INSURANCE PREMIUMS $127,115 $127,115 100.00% $127,250 $42,416 33.33% $132,250 $137,250 6440 POSTAGE/PRINTING $0 $0 #DIV/01 $0 $0 #DIV/01 $0 $0 6450 OUTSIDE PRINTING $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6455 LEGAL PUBLICATION $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6460 DUES/SUBSCRIPTIONS $0 $0 #DIV/01 $0 $0 #DIV/01 $0 $0 6470 TRAINING/SUBSISTANCE $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6485 MILEAGE $0 $0 #DIV/01 $0 $0 #DIV/OI $0 $0 7420 MISCELLANEOUS $0 $0 #DIV/OI $0 $0 #DIV/O! $0 $0 TOTAL OTHER SERVICES $127,115 $127,115 100.00% $127,250 $42,416 33.33% $132,250 $137,250 TOTAL BUDGET $127,115 $127,115 100.00% $127,250 $42,416 33.33% $132,250 $137,250 6/4/2012 1 9 Risk Management CITY OF FARMINGTON 2013 BUDGET 1050 POLICE-ADMINISTRATION ADOPTED THROUGH I APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % I 2012 4/2012 % 2013 2014 6110 SALARIES-FT $346,012 $343,094 99.16% $351,991 $114,798 32.61% $357,625 $363,009 6112 SALARIES-OT $0 $0 #DIV/0! $0 $0 #DIV/0! $1,000 $1,000 6120 SALARIES-PT $57,990 $52,931 91.28% $59,704 $16,444 27.54% $61,360 $62,280 6130 COMP TIME PAY $0 $5,451 #DIV/0! $0 $538 #DIV/0! $5,500 $5,500 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $25,530 $18,781 73.56% I $19,655 $6,092 30.99% $20,413 $26,470 6154 PERA $35,490 $42,956 121.04% I $43,501 $14,076 32.36% $47,444 $64,250 6156 HCSP $0 $1,186 #DIV/0! $0 $388 #DIV/0! $1,203 $1,300 6158 EMPLOYEE BENEFITS $72,842 $74,114 101.75% $63,451 $20,132 31.73% $73,426 $75,861 6159 WORKERS COMP $0 $0 #DIV/0! $0 $2,846 #DIV/0! $0 $0 TOTAL PERSONNEL $537,864 $538,513 100.12% $538,302 $175,314 32.57% $567,971 $599,670 SUPPLIES 6210 OFFICE SUPPLIES $0 $130 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $2,300 $141 6.13% $3,500 $15 0.43% $3,500 $3,500 6240 BUILDING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6250 OTHER SUPPLIES $4,000 $7,560 189.00% $4,000 $769 19.23% $7,500 $7,500 6272 FUEL $0 $1,251 #DIV/0! $0 $6,400 #DIV/0! $0 $0 6290 UNIFORMS $3,600 $2,632 73.11% $3,600 $1,991 55.31% $3,600 $3,600 TOTAL SUPPLIES $9,900 $11,714 118.32% $11,100 $9,175 82.66% $14,600 $14,600 OTHER SERVICES I 6401 PROFESSIONAL SERVICES $10,850 $8,289 76.40% $7,930 $6,274 79.12% _$3,350 _ $3,350 6402 DATA PROCESSING $59,925 $55,084 91.92% $53,684 $29,353 54.68% $37,400 $38,141 6403 LEGAL $78,280 $97,949 125.13% $80,000 $27,582 34.48% $100,000 $100,000 6404 IT SERVICES $37,655 $37,655 100.00% $42,739 $14,246 33.33% $24,469 $24,469 6411 TELEPHONE $0 $1,008 #DIV/01 $1,600 $720 45.00% $1,600 $1,600 6421 MUNICIPAL SERVICES $6,800 $6,160 90.59% $6,800 $2,703 39.75% $6,800 $6,800 6422 ELECTRIC $25,000 $26,833 107.33% $25,000 $8,713 34.85% $27,000 $28,000 6423 NATURAL GAS $19,600 $7,369 37.60% $9,000 $4,580 50.89% $8,000 $8,000 6445 POSTAGE $400 $35 8.75% $400 $15 3.75% $400 _ $400 6455 OUTSIDE PRINTING $400 $339 84.75% $400 I $62 15.50% $400 $400 6460 DUES/SUBSCRIPTIONS $10,400 $689 6.63% $10,000 I $15,275 152.75% $15,559 $17,014 6470 TRAINING/SUBSISTANCE $3,000 $631 21.03% $3,000 $425 14.17% $3,200 $3,000 6485 MILEAGE $1,000 $572 57.20% $900 $41 4.56% $700 $700 6505 EQUIPMENT REPAIR $4,500 $1,336 29.69% $4,500 $2,408 53.51% $4,500 _$4,500 6515 BUILDING REPAIR $0 $620 #DIV/0! $0 $16 #DIV/0! $0 $0 6/N2012 20 Police-Administration 7420 MISCELLANEOUS $0 $18 #DIV/01 $0 $0 #DIV/0I $0 $0 TOTAL OTHER SERVICES $257,810 $244,587 94.874 $245,953 $112,413 45.71% $233,378 $236,374 TOTAL BUDGET $805,574 $794,814 98.66% $795,355 $296,902 37.33% $815,949 $850,644 Police-Administration 6/4/2012 21 CITY OF FARMINGTON 2013 BUDGET 1051 POLICE-PATROL ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $1,239,503 $1,219,727 98.40% $1,278,409 $407,416 31.87% $1,394,062 $1,415,050 6112 SALARIES-OT $88,312 $85,050 96.31% $79,475 $15,296 19.25% $82,000 $84,000 6120 SALARIES-PT $0 $0 #DIV/0! $0 I $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $38,962 #DIV/0! $0 $6,651 #DIV/0! $40,000 $41,000 6135 OTHER PAY $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $19,253 $19,273 100.10% $19,689 $5,874 29.83% $21,983 $22,331 6154 PERA $191,206 $193,498 101.20% $195,535 $59,359 30.36% $218,313 $221,767 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $236,845 $243,199 102.68% $199,360 $58,742 29.47% $174,705 $181,576 6159 WORKERS COMP $0 $0 #DIV/01 $0 $16,661 #DIV/0! $0 $0 TOTAL PERSONNEL $1,775,119 $1,799,709 101.39% $1,772,468 $569,999 32.16% $1,931,063 $1,965,724 SUPPLIES 6210 OFFICE SUPPLIES $1,000 $576 57.60% $500 $0 0.00% $600 $600 6220 EQUIPMENT SUPPLIES $5,300 $5,786 109.17% $6,800 $2,606 38.32% $11,300 $11,300 6230 VEHICLE SUPPLIES/PARTS $13,500 $19,120 141.63% $13,500 $10,893 80.69% $19,120 $20,000 6234 VEHICLE LICENSES $1,000 $56 5.60% $1,000 $75 7.50% $1,000 $1,000 6250 OTHER SUPPLIES $12,300 $8,199 66.66% $14,300 $2,346 16.41% $14,300 $14,300 6272 FUEL $70,000 $75,365 107.66% $73,000 $19,088 26.15% $80,000 $83,000 6290 UNIFORMS $13,000 $22,836 175.66% $13,000 $11,358 87.37% $13,000 $13,000 TOTAL SUPPLIES $116,100 $131,938 113.64% $122,100 $46,366 37.97% $139,320 $143,200 OTHER SERVICES 6401 PROFESSIONAL SERVICES $1,650 $160 9.70% $1,650 $0 0.00% $1,650 $1,650 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $34,493 $34,493 100.00% $45,023 $15,008 33.33% $39,228 $39,228 6406 K9 EXPENSES $0 $1,153 #DIV/0! $500 $120 24.00% $500 $500 6411 TELEPHONE $2,900 $1,080 37.24% $2,900 $270 9.31% $2,000 $2,000 6412 CELLULAR TELEPHONES $15,200 $15,031 98.89% $15,200 $4,838 31.83% $15,200 $15,500 6421 MUNICIPAL SERVICES $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/0! $0 $0 #DIV/0! $0 _ $0 6423 NATURAL GAS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6455 OUTSIDE PRINTING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $5,200 $4,085 78.56% $7,200 $6,555 _91.04% $7,700 $7,700 6470 TRAINING/SUBSISTANCE $15,000 I $11,205 74.70% $18,000 $3,289 18.27% $18,500 $18,500 6/4/2012 22 Police-Patrol 6485 MILEAGE $750 $468 62.40% $750 $179 23.87% $750 $750 6505 EQUIPMENT REPAIR $1,000 $95 9.50% $1,000 $198 19.80% $1,000 $1,000 6510 VEHICLE MAINTANANCE $56,650 $60,096 106.08% $55,000 $13,750 25.00% $53,802 $53,802 6515 BUILDING REPAIR $0 $95 #DIV/0I $0 $0 #DIV/01 $0 $0 6560 CONTRACTED SERVICES $212,550 $196,660 92.52% $213,120 $39,209 18.40% $219,513 $226,099 TOTAL OTHER SERVICES $345,393 $324,621 93.99% $360,343 $83,416 23.15% $359,843 $366,729 CAPITAL OUTLAY 6940 VEHICLES $54,000 $49,801 92.22% $54,000 $0 0.00% $85,000 $85,000 TOTAL CAPITAL OUTLAY $54,000 $49,801 92.22% $54,000 $0 0.00% $85,000 $85,000 TOTAL BUDGET $2,290,612 $2,306,069 100.67/ $2,308,911 $699,781 30.31% $2,515,226 $2,560,653 6/4/2012 23 Police-Patrol CITY OF FARMINGTON I -- 2013 BUDGET -1052 POLICE-INVESTIGATIONS - ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED _ PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $537,717 $559,225 104.00% $546,048 $189,386 34.68% $498,819 $506,427 6112 SALARIES OT $10,810 $18,249 168.82% $10,814 _ $9,120 84.34% $19,000 _ $19,000 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $8,278 #DIV/0! $0 $1,474 #DIV/0! $8,500 $8,600 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $7,954 $8,425 105.92% $8,075 $2,714 33.61% $7,632 $7,743 6154 PERA $78,988 $84,352 106.79% $80,188 $27,635 34.46% $75,790 $76,900 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $102,427 $104,057 101.59% $85,850 $24,994 29.11% $61,786 $64,213 6159 WORKERS COMP $0 $0 #DIV/0! $0 $6,832 #DIV/0! $0 $0 TOTAL PERSONNEL $737,896 $782,586 106.06% $730,975 $262,155 35.86% $671,527 $682,883 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $3,830 -$181 -4.73% $5,000 $0 0.00% $6,500 $6,500 6230 VEHICLE SUPPLIES/PARTS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6234 VEHICLE LICENSES $0 $22 #DIV/0! $0 $0 #DIV/0! $0 $0 6250 OTHER SUPPLIES $2,400 $812 33.83% $2,400 $222 9.25% $0 $2,400 6272 FUEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6290 UNIFORMS $5,750 $9,121 158.63% $5,750 $4,900 85.22% $4,800 $4,800 TOTAL SUPPLIES $11,980 $9,774 81.59% $13,150 $5,122 38.95% $11,300 $13,700 OTHER SERVICES 6401 PROFESSIONAL SERVICES $4,832 $1,684 34.85% $4,832 $534 11.05% $5,432 _ $5,432 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6450 OUTSIDE PRINTING $2,000 $0 0.00% $1,000 $0 0.00% $1,000 $1,000 6460 DUES/SUBSCRIPTIONS $300 $130 43.33% $300 $0 0.00% $300 $300 6470 TRAINING/SUBSISTANCE $10,700 $4,013 37.50% $10,700 $1,214 11.35% $9,700 $9,900 6485 MILEAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6505 EQUIPMENT REPAIR $200 $0 0.00% $200 $0 0.00% $200 $200 6510 VEHICLE MAINTANANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6515 BUILDING REPAIR $0 $96 #DIV/0! r $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $18,032 $5,923 32.85% $17,032 _ $1,748. 10.26% $16,632 $16,832 TOTAL BUDGET I $767,908 $798,283 103.96% $761,157 $269,025 35.34% I $699,459 $713,415 !'olice-Investigations 6/4/2012 24 CITY OF FARMINGTON 2013 BUDGET 1054 POLICE-EMERGENCY MANAGEMENT ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6112 SALARIES-OT $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6120 SALARIES-PT $0 $0 #DIV/01 $0 $0 #DIV/oI $0 $0 6130 COMP TIME PAY $0 $0 #DIV/0I $0 $0 #DIV/O! $0 $0 6135 OTHER PAY $0 $0 #DIV/0l $0 $0 #DIV/0l $0 $0 6152 FICA/MEDICARE $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6154 PERA $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6156 HCSP $0 $0 #DIV/01 $0 $0 #DIV/0l $0 $0 6158 EMPLOYEE BENEFITS $0 $0 #DIV/OI $0 $0 #DIV/0! $0 $0 TOTAL PERSONNEL $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6230 VEHICLE SUPPLIES/PARTS $0 $0 #DIV/0I $0 $0 #DIV/oI $0 $0 6234 VEHICLE LICENSES $0 $0 #DIV/01 $0 $0 #DIV/0l $0 $0 6250 OTHER SUPPLIES $0 $0 #DIV/OI $0 $0 #DIV/0I $0 $0 6272 FUEL $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6290 UNIFORMS $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 TOTAL SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES $0 $0 #DIV/0I $0 $0 #DIV/0! $0 $0 6402 DATA PROCESSING $0 $0 #DIV/01 $0 $0 #DIV/OI $0 $0 6403 LEGAL $0 $0 #DIV/01 $0 $0 #DIV/Ol $0 $0 6404 IT SERVICES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6411 TELEPHONE $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6412 CELLULAR TELEPHONES $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6421 MUNICIPAL SERVICES $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6422 ELECTRIC $400 $217 54.25% $400 $73 18.25% $400 $400 6423 NATURAL GAS $0 $0 #DIV/OI $0 $0 #DIV/0I $0 $0 6445 POSTAGE $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6450 OUTSIDE PRINTING $0 $0 #DIV/01 $0 $0 #DIV/OI $0 $0 6460 DUES/SUBSCRIPTIONS $0 $0 #DIV/01 $0 $0 #DIV/01 $0 $0 6470 TRAINING/SUBSISTANCE $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6485 MILEAGE $0 $0 #DIV/0I $0 $0 #DIV/Ol $0 $0 6505 EQUIPMENT REPAIR $4,500 $1,034 22.98% $11,575 $0 0.00% $5,000 $5,000 6/4/2012 25 Police-Emergency Management 6510 VEHICLE MAINTANANCE $0 $0 #DIV/0I $0 $0 #DIV/Ol $0 $0 6515 BUILDING REPAIR $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6560 CONTRACTED SERVICES $0 $0 #DIV/0l $0 $0 #DIV/0I $0 $0 TOTAL OTHER SERVICES $4,900 $1,251 25.53% $11,975 $73 0.61% $5,400 $5,400 TOTAL BUDGET $4,900 $1,251 25.53% $11,975 $73 0.61% $5,400 $5,400 6/4/2012 26 Police-Emergency Management CITY OF FARMINGTON 2013 BUDGET 1060 FIRE ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $84,226 $79,407 94.28% $87,451 $27,626 31.59% $95,193 $97,385 6112 SALARIES-OT $0 $343 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $76,812 $91,144 118.66% $96,477 $30,972 32.10% $101,480 $118,003 6130 COMP TIME PAY $0 $932 #DIV/0! $0 $1,457 #DIV/0! $1,000 $1,000 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $12,319 $13,478 109.41% $14,071 $4,640 32.98% $15,122 $16,554 6154 PERA $6,106 $5,921 96.97% $6,934 $2,109 30.42% $6,974 $7,133 6156 HCSP $0 $836 #DIV/01 $0 $262 #DIV/0! $893 $906 6158 EMPLOYEE BENEFITS $220,154 $291,519 132.42% $14,102 $2,987 21.18% $10,620 $11,026 6158 FIRE PENSION AID $0 $0 #DIV/0! $253,000 $0 0.00% $263,000 $263,000 6159 WORKERS COMP $0 $0 #DIV/0! $0 $1,884 #DIV/0! $0 $0 TOTAL PERSONNEL $399,617 $483,580 121.01% $472,035 $71,937 15.24% $494,282 $515,007 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $6,708 $5,025 74.91% $7,500 $3,918 52.24% $10,660 $5,660 6230 VEHICLE SUPPLIES/PARTS $1,000 $4,543 454.30% $3,000 $2,408 80.27% $3,000 $3,000 6240 BUILDING SUPPLIES $2,000 $2,158 107.90% $2,000 $934 46.70% $11,100 $2,000 6250 OTHER SUPPLIES $7,000 $2,510 35.86% $7,000 $0 0.00% $12,000 $8,500 6272 FUEL $7,000 $13,260 189.43% $10,000 $4,231 42.31% $12,000 $12,000 6290 UNIFORMS $13,100 $3,377 25.78% $52,000 $6,952 13.37% $28,500 $26,300 TOTAL SUPPLIES $36,808 $30,873 83.88% $81,500 $18,443 22.63% $77,260 $57,460 OTHER SERVICES 6401 PROFESSIONAL SERVICES $22,935 $22,037 96.08% $27,665 $7,557 27.32% $28,050 _$28,050 6402 DATA PROCESSING $0 $1,560 #DIV/0! $2,213 $740 33.44% $2,313 $2,313 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $12,935 $12,935 100.00% $14,681 $4,894 33.34% $28,701 $13,402 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $6,500 $4,651 71.55% $5,500 $1,257 22.85% $5,500 $5,500 6421 MUNICIPAL SERVICES $6,000 $7,150 119.17% $6,000 $3,412 56.87% $6,000 $6,000 6422 ELECTRIC $11,000 $14,355 130.50% $12,500 $4,402 35.22% $12,500 $13,000 6423 NATURAL GAS $19,000 $12,415 65.34% $14,800 $6,050 40.88% $18,000 $19,000 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6450 OUTSIDE PRINTING $500 $42 8.40% $500 $43 8.60% $500 $500 6460 DUES/SUBSCRIPTIONS $3,050 $2,640 86.56% $3,050 $1,845 60.49% $2,920 $3,700 6470 TRAINING/SUBSISTANCE $16,409 $17,340 105.67% I $16,415 $725 I 4.42% $12,495 $14,630 6/4/2012 27 Fire 6485 MILEAGE $1,000 $275 27.50% $400 $89 22.25% $400 $400 6505 EQUIPMENT REPAIR $4,735 $2,927 61.82% $5,000 $1,570 31.40% $5,000 $5,000 6510 VEHICLE MAINTANANCE $20,000 $34,466 172.33% $19,750 $9,595 48.58% $19,320 $19,320 6515 BUILDING REPAIR $1,750 $1,268 72.46% $2,000 $22 1.10% $37,000 $40,500 6560 CONTRACTED SERVICES $106,025 $101,055 95.31% $106,250 $24,328 22.90% $106,250 $106,250 TOTAL OTHER SERVICES $231,839 $235,116 101.41% $236,724 $66,529 28.10% $284,949 $277,565 CAPITAL OUTLAY 6940 VEHICLES $0 $0 #DIV/01 $0 $0 #DIV/0I $130,000 $130,000 6950 MACHINERY/EQUIPMENT $0 $0 #DIV/0I $0 $0 #DIV/0I $81,000 $5,000 TOTAL CAPITAL OUTLAY $0 $0 #DIV/0I $0 $o #DIV/oI $211,000 $135,000 TOTAL BUDGET $668,264 $749,569 112.17•/ $790,259 $156,909 19.86% $1,067,491 $985,032 6/4/2012 Fire 28 CITY OF FARMINGTON _ 2013 BUDGET 1061 FIRE-RESCUE ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $0 $0 #DIV/O! $0 $0 #DIV/OI $0 $0 6112 SALARIES-OT $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6120 SALARIES-PT $32,486 $27,874 85.80% $32,811 $10,645 32A4% $33,303 $33,804 6130 COMP TIME PAY $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/OI $0 $0 6152 FICA/MEDICARE $2,485 $2,132 85.79% $2,510 $814 32.43% $2,548 $2,586 6154 PERA $0 $0 #DIV/0I $0 $0 #DIV/0! $0 $0 6156 HCSP $0 $0 #DIV/0I $0 $0 #DIV/OI $0 $0 6158 EMPLOYEE BENEFITS $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6158 FIRE PENSION AID $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 TOTAL PERSONNEL $34,971 $30,006 85.80% $35,321 $11,459 32.44% $35,851 $36,390 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6220 EQUIPMENT SUPPLIES $2,500 $1,295 51.80% $3,000 $1,282 42.73% $4,500 $3,000 6230 VEHICLE SUPPLES/PARTS $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6240 BUILDING SUPPLIES $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6250 OTHER SUPPLIES $1,500 $731 48.73% $2,000 $493 24.65% $2,000 $2,000 6272 FUEL $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6290 UNIFORMS $2,000 $1,309 65.45% $2,000 $0 0.00% $2,000 $2,000 TOTAL SUPPLIES $6,000 $3,335 55.58% $7,000 $1,775 25.36% $8,500 $7,000 OTHER SERVICES 6401 PROFESSIONAL SERVICES $500 $0 0.00% $500 $0 0.00% $500 $500 6402 DATA PROCESSING $0 $0 #DIV/OI $0 $0 #DIV/0I $0 $0 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6404 IT SERVICES $0 $0 #DIV/OI $0 $0 #DIV/0I $0 $0 6411 TELEPHONE $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6412 CELLULAR TELEPHONES $0 $0 #DIV/0! $0 $0 #DIV/OI $0 $0 6421 MUNICIPAL SERVICES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6422 ELECTRIC $0 $0 #DIV/O! $0 $0 #DIV/01 $0 $0 6423 NATURAL GAS $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6445 POSTAGE $0 $0 #DIV/OI $0 $0 #DIV/0I $0 $0 6450 OUTSIDE PRINTING $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 6460 DUES/SUBSCRIPTIONS $100 $0 0.00% $100 $20 20.00% $100 $100 6470 TRAINING/SUBSISTANCE $4,000 $3,082 77.05% $3,500 $53 1.51% $4,000 $4,000 6485 MILEAGE $250 $0 0.00% $250 $0 0.00% $250 $250 Budget and Levy Summary 29 Fire-Rescue 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6510 VEHICLE MAINTANANCE $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6515 BUILDING REPAIR $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 6560 CONTRACTED SERVICES $0 $0 #DIV/01 $0 $0 #DIV/0I $0 $0 TOTAL OTHER SERVICES $4,850 $3,082 63.55% $4,350 $73 1.68% $4,850 $4,850 TOTAL BUDGET $45,821 $36,423 79.49% I $46,671 $13,307 28.51% $49,201 $48,240 Budget and Levy Summary 30 Fire-Rescue CITY OF FARMINGTON I ( 2013 BUDGET I— — 1070 ENGINEERING ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 _ % 2013 2014 6110 SALARIES-FT $138,085 $152,107 110.15% $134,352 $52,644 39.18% $138,149 $140,014 6112 SALARIES-OT $1,618 $141 8.71% $1,999 $0 0.00% $1,200 $1,200 6120 SALARIES-PT $15,000 -$369 -2.46% $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $10,687 $10,883 101.83% $10,431 $3,848 36.89% $10,660 $10,803 6154 PERA $10,128 $11,112 109.72% $9,885 $3,816 38.60% $10,103 $10,238 6156 HCSP $0 $2,416 #DIV/0! $0 $806 #DIV/0! $2,279 $2,313 6158 EMPLOYEE BENEFITS $46,479 $48,125 103.54% $48,827 $19,216 39.36% $52,889 $54,955 6159 WORKERS COMP $0 $0 #DIV/0! $0 $1,148 #DIV/0! $0 $0 TOTAL PERSONNEL $221,997 $224,415 101.09% $205,494 $81,478 39.65% $215,280 $219,523 SUPPLIES 6210 OFFICE SUPPLIES $150 $179 119.33% $150 $34 22.67% $200 $200 6220 EQUIPMENT SUPPLIES $0 $1,356 #DIV/0! $0 $70 #DIV/0! $0 $0 6230 VEHICLE SUPPLIES/PARTS $500 $310 62.00% $500 $112 22.40% $500 $500 6234 VEHICLE LICENSES $120 $0 0.00% $120 $32 26.67% $50 $50 6250 OTHER SUPPLIES $900 $556 61.78% $5,200 $116 2.23% $1,200 $1,750 6272 FUEL $2,000 $1,795 89.75% $2,000 $260 13.00% $2,200 $2,300 6290 UNIFORMS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $3,670 $4,196 114.33% $7,970 $624 7.83% $4,150 $4,800 OTHER SERVICES 6401 PROFESSIONAL SERVICES $10,000 $21,730 217.30% $10,000 $1,157 11.57% _ $10,000 $10,000 6402 DATA PROCESSING $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6403 LEGAL $7,500 $2,585 34.47% $5,000 $1,167 23.34% $5,000 $5,000 6404 IT SERVICES $10,923 $10,923 100.00% $12,398 $4,132 33.33% $16,550 $11,317 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $1,800 $1,652 91.78% $1,800 $503 27.94% $1,800 $1,800 6421 MUNICIPAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6423 NATURAL GAS $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/0! _ $0 _ $0 6450 OUTSIDE PRINTING $100 $0 0.00% $100 $0 0.00% $100 $100 6460 DUES/SUBSCRIPTIONS $655 $323 49.31% $655 $60 9.16% $535 $675 6470 TRAINING/SUBSISTANCE $930 $275 29.57% $930 ( $435 46.77% $1,350 $1,350 6485 MILEAGE r $500 $0 0.00% $500 $0 0.00% $250 $250 Budget and Levy Summary 31 Engineering 6505 EQUIPMENT REPAIR $1,000 $0 0.00% $1,000 $0 0.00% $1,500 $1,250 6510 VEHICLE MAINTANANCE $3,000 $3,000 100.00% $2,250 $563 25.02% $2,201 $2,201 6515 BUILDING REPAIR $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6560 CONTRACTED SERVICES $0 $0 #DIV/0I $0 $0 #DIV/0I $0 $0 TOTAL OTHER SERVICES $36,408 $40,488 111.21% $34,633 $8,017 23.15% $39,286 $33,943 TOTAL BUDGET $262,075 $269,099 102.68% $248,097 $90,119 36.32% $258,716 $258,266 Budget and Levy Summary 32 Engineering CITY OF FARMINGTON 2013 BUDGET 1030 ENGINEERING-PLANNING ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $154,286 $147,551 95.63% $155,829 $51,892 33.30% $161,117 $163,534 6112 SALARIES-OT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 (SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $11,803 $11,197 94.87% $11,921 $3,834 32.16% $12,325 $12,510 6154 PERA $11,186 $10,697 95.63% $11,298 $3,763 33.31% $11,681 $11,856 6156 HCSP $0 $835 #DIV/0! $0 $275 #DIV/0! $851 $877 6158 EMPLOYEE BENEFITS $21,409 $21,927 102.42% $17,527 $6,330 36.12% $20,580 $21,380 6159 WORKERS COMP $0 $0 #DIV/0! $0 $210 #DIV/0! $0 $0 TOTAL PERSONNEL $198,684 $192,207 96.74% $196,575 $66,304 33.73% $206,554 $210,157 SUPPLIES 6210 OFFICE SUPPLIES $0 $166 #DIV/0! $0 $34 #DIV/0! $200 $200 6220 EQUIPMENT SUPPLIES $0 $110 #DIV/0! $0 $0 #DIV/01 $200 $200 6230 VEHICLE SUPPLIES/PARTS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6234 VEHICLE LICENSES $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6250 OTHER SUPPLIES $0 $65 #DIV/0! $0 $0 #DIV/0! $100 $100 6272 FUEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6290 UNIFORMS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $0 $341 #DIV/0! $0 $34 #DIV/0! $500 $500 OTHER SERVICES 6401 PROFESSIONAL SERVICES $3,500 $19,735 563.86% $20,700 $0 0.00% _$20,700 $21,000 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6403 LEGAL $9,000 $3,115 34.61% $6,000 $810 13.50% $5,000 $5,000 6404 IT SERVICES $17,534 $17,534 100.00% $19,902 $6,634 33.33% $12,406 $18,167 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6421 MUNICIPAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6423 NATURAL GAS $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6455 LEGAL PUBLICATIONS $1,800-1 $959 53.28% $1,800 $116 6.44% _$1,800 _ $1,800 6460 DUES/SUBSCRIPTIONS $685 $750 109.49% $810 $0 0.00% $810 $810 6470 TRAINING/SUBSISTANCE $900 $401 44.56% $1,400 $250 17.86% $900 $900 6485 MILEAGE $250 $101 I 40.40% $225 $225 100.00% $200 $200 Budget and Levy Summary 33 Engineering-Planning 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6510 VEHICLE MAINTANANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6515 BUILDING REPAIR $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6560 CONTRACTED SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $33,669 $42,595 126.51% $50,837 $8,035 15.81% $41,816 $47,877 TOTAL BUDGET $232,353 I $235,143 101.20% $247,412 $74,373 30.06% $248,870 $258,534 Budget and Levy Summary 34 Engineering-Planning CITY OF FARMINGTON _ 2013 BUDGET 1031 _ ENGINEERING-BUILDING INSPECTIONS ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $200,970 $191,123 95.10% $198,883 $62,667 31.51% $201,877 $204,905 6112 SALARIES-OT $1,205 $0 0.00% $425 $0 0.00% $425 $425 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $146 #DIV/01 $0 $74 #DIV/0! $200 $200 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/OI $0 $0 6152 FICA/MEDICARE $15,466 $14,568 94.19% $15,247 $4,781 31.36% $15,491 $15,723 6154 PERA $14,658 $13,867 94.60% $14,450 $4,548 31.47% $14,681 $14,901 6156 HCSP $0 $1,348 #DIV/0! $0 $443 #DIV/0! $2,003 $2,063 6158 EMPLOYEE BENEFITS $35,271 $36,121 102.41% $29,851 $10,659 35.71% $32,390 $33,590 6159 WORKERS COMP $0 $0 #DIV/01 $0 $454 #DIV/0! $0 $0 TOTAL PERSONNEL $267,570 $257,173 96.11% $258,856 $83,626 32.31% I $267,067 $271,807 SUPPLIES 6210 OFFICE SUPPLIES $350 $75 21.43% $350 $0 0.00% $300 $300 6220 EQUIPMENT SUPPLIES $300 $110 36.67% $300 $13 4.33% $300 $300 6230 VEHICLE SUPPLIES/PARTS $400 $619 154.75% $400 $0 0.00% $400 $400 6234 VEHICLE LICENSES $0 $0 #DIV/0! $0 $32 #DIV/0! $0 $0 6250 OTHER SUPPLIES $1,100 $0 0.00% $500 $0 0.00% $1,100 $1,100 6272 FUEL $4,000 $3,330 83.25% $3,800 $1,180 31.05% $3,800 $4,000 6290 UNIFORMS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $6,150 $4,134 67.22% $5,350 $1,225 22.90% $5,900 $6,100 OTHER SERVICES 6401 PROFESSIONAL SERVICES $1,550 $0 0.00% $1,550 $0 0.00% $1,500 $1,500 6402 DATA PROCESSING $23,350 $22,613 96.84% $22,314 $8,490 38.05% $23,000 $23,000 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $5,749 $5,749 100.00% $6,525 $2,175 33.33% $11,195 $5,956 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $800 $781 97.63% $800 $252 31.50% $800 $800 6421 MUNICIPAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/0! $0 $0 #DIV/0I $0 _ $0 6423 NATURAL GAS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6450 OUTSIDE PRINTING $300 $113 37.67% $300 $281 93.67% $500 $500 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $470 $430 91.49% $470 $405 86.17% $455 $455 6470 TRAINING/SUBSISTANCE $1,000 $176 17.60% $900 $0 0.00% $1,200 $1,200 6485 MILEAGE $300 $18 6.00% $300 $0 0.00% $300 $300 6/4/2012 35 Engineering-Building Inspections 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6510 VEHICLE MAINTANANCE $1,000 $1,000 100.00% $1,000 $250 25.00% $978 $978 6515 BUILDING REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6560 CONTRACTED SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $34,519 $30,880 89.46% $34,159 $11,853 34.70% $39,928 $34,689 TOTAL BUDGET $308,239 $292,187 94.79% $298,365 $96,704 32.41% $312,895 $312,596 6/4/2012 36 Engineering-Building Inspections CITY OF FARMINGTON 2013 BUDGET 1076 ENGINEERING-NATURAL RESOURCES ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $60,981 $42,699 70.02% $61,666 $25,429 41.24% $60,488 $61,392 6112 SALARIES-OT $1,589 $0 0.00% $244 $0 0.00% $245 $245 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $4,787 $3,108 64.93% $4,736 $1,870 39.48% $4,646 $4,715 6154 PERA $4,536 $3,095 68.23% $4,489 $1,843 41.06% $4,403 $4,469 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $217 $221 6158 EMPLOYEE BENEFITS $4,606 $4,605 99.98% $4,558 $1,519 33.33% $4,650 $4,650 TOTAL PERSONNEL $76,499 $53,507 69.94% $75,693 $30,661 40.51% $74,649 $75,692 SUPPLIES F 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $2,000 $324 16.20% $2,000 $142 7.10% $2,000 $2,000 6230 VEHICLE SUPPLIES/PARTS $750 $501 66.80% $750 $251 33.47% $750 $750 6234 VEHICLE LICENSES $0 $0 #DIV/0! $0 $16 #DIV/0! $0 $0 6250 OTHER SUPPLIES $1,000 $189 18.90% $800 $26 3.25% $800 $800 6272 FUEL $3,000 $1,624 54.13% $2,500 $1,764 70.56% $3,000 $3,200 6290 UNIFORMS $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $6,750 $2,638 39.08% $6,050 $2,199 36.35% $6,550 $6,750 OTHER SERVICES 6401 PROFESSIONAL SERVICES $7,000 $6,943 99.19% $11,000 $1,275 11.59% $11,000 $11,000 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $1,150 $1,150 100.00% $1,305 $435 33.33% $10,001 $1,191 6411 TELEPHONE $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6421 MUNICIPAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6423 NATURAL GAS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6450 OUTSIDE PRINTING $100 $0 0.00% $100 $0 0.00% $100 $100 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $50 $40 80.00% $50 $40 80.00% $50 $50 6470 TRAINING/SUBSISTANCE $600 $295 49.17% $800 $623 77.88% $800 $800 6485 MILEAGE $50 $0 0.00% $50 $0 0.00% $50 $50 6505 EQUIPMENT REPAIR $1,000 $367 36.70% $1,000 $350 35.00% $1,000 $1,000 6/4/2012 37 Engineering-Natural Resources 6510 VEHICLE MAINTANANCE $1,000 $1,000 100.00% $1,000 $250 25.00% $978 $978 6515 BUILDING REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6560 CONTRACTED SERVICES $0 $0 #DIV/0I $0 $0 I #DIV/0! $0 $0 TOTAL OTHER SERVICES $10,950 $9,795 89.45% $15,305 $2,973 19.43% $23,979 $15,169 TOTAL BUDGET $94,199 $65,940 70.00% $97,048 $35,833 36.92% $105,178 $97,611 6/4/2012 38 Engineering-Natural Resources CITY OF FARMINGTON 2013 BUDGET 1072 MUNUCIPAL SERVICES-STREETS ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $287,394 $231,427 80.53% $279,917 $54,920 19.62% $296,227 $300,670 6112 SALARIES-OT $1,460 $1,441 98.70% $1,371 $0 0.00% $1,500 $1,500 6120 SALARIES-PT $0 $144 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $10,010 #DIV/0! $0 $1,837 #DIV/0! $10,000 $10,150 6135 OTHER PAY $0 $9,173 #DIV/0! $0 $3,108 #DIV/0! $10,000 $9,500 6152 FICA/MEDICARE $22,097 $18,089 81.86% $21,519 $4,252 19.76% $24,306 $24,619 6154 PERA $20,942 $14,084 67.25% $20,349 $4,382 21.53% $23,035 $23,332 6156 HCSP $0 $2,554 #DIV/0! $0 $905 #DIV/0! $1,538 $1,561 6158 EMPLOYEE BENEFITS $119,020 $121,921 102.44% $102,467 $31,778 31.01% $114,000 $118,000 6159 WORKERS COMP $0 $0 #DIV/0! $0 $6,715 #DIV/0! $0 $0 TOTAL PERSONNEL $450,913 $408,843 90.67% $425,623 $107,897 25.35% $480,606 $489,332 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $530 $86 16.23% $500 $64 12.80% $500 $500 6230 VEHICLE SUPPLIES/PARTS $8,000 $12,765 159.56% $10,000 $1,317 13.17% $10,000 $10,000 6234 VEHICLE LICENSES $400 $29 7.25% $400 $288 72.00% $300 $300 6240 BUILDING SUPPLIES $0 $609 #DIV/0! $500 $106 21.20% $700 $700 6250 OTHER SUPPLIES $1,500 $806 53.73% $1,200 $290 24.17% $1,200 $1,200 6253 STREET MATERIALS $32,500 $28,376 87.31% $36,500 $95 0.26% $32,500 $32,500 6254 STREET/STRIPING MATER. $6,500 $2,508 38.58% $7,500 $1,805 24.07% $12,500 $11,000 6272 FUEL $18,500 $18,830 101.78% $16,200 $4,844 29.90% $19,000 $19,500 6290 UNIFORMS $3,100 $2,290 73.87% $3,000 $547 18.23% $2,000 $2,000 TOTAL SUPPLIES $71,030 $66,299 93.34% $75,800 $9,356 12.34% $78,700 $77,700 OTHER SERVICES 6401 PROFESSIONAL SERVICES $24,155 $19,038 78.82% $21,113 $860 4.07% $20,000 $20,000 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $0 $0 #DIV/0! $0 $0 _#DIV/0! - $0 - $0 6404 IT SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6421 MUNICIPAL SERVICES $1,000 $991 99.10% $1,200 $687 _57.25% - $1,200 $1,200 6422 ELECTRIC $3,000 $5,581 186.03% $6,000 $1,235 20.58% _ $6,000 _ $6,000 6423 NATURAL GAS $4,500 $3,147 69.93% $4,500 $1,533 34.07% $3,700 $3,700 6450 OUTSIDE PRINTING $100 $0 0.00% $0 $0 #DIV/0! $0 __$0 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6/4/2012 39 Municipal Services-Streets 6460 DUES/SUBSCRIPTIONS $200 $10 5.00% $200 I $0 0.00% $100 $100 6470 TRAINING/SUBSISTANCE $400 $180 45.00% $400 $135 33.75% $300 $300 6485 MILEAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6505 EQUIPMENT REPAIR $2,000 $11 0.55% $2,000 $322 16.10% $1,000 $1,000 6510 VEHICLE MAINTANANCE $34,000 $36,713 107.98% $33,000 $8,250 25.00% $32,281 $32,281 6515 BUILDING REPAIR $450 $632 140.44% $700 $193 27.57% $1,000 $1,000 6555 EQUIPMENT RENTAL $5,500 $18,023 327.69% $5,500 $285 5.18% $5,500 $5,500 6560 CONTRACTED SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $75,305 $84,326 111.98% $74,613 $13,500 18.09% $71,081 $71,081 TOTAL BUDGET $597,248 $559,468 93.67% $576,036 $130,753 I 22.70% $630,387 $638,113 6/°/20 40 Municipal Services-Streets CITY OF FARMINGTON 2013 BUDGET 1073 MUNICIPAL SERVICES-SNOW REMOVAL ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $25,592 $44,527 173.99% $25,425 $8,904 35.02% $29,701 $30,147 6112 SALARIES-OT $22,995 $18,945 82.39% $20,710 $22 0.11% $20,000 $22,000 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $212 #DIV/0! $0 $0 6152 FICA/MEDICARE $3,717 $4,562 122.73% $3,529 $658 18.65% $3,802 $3,989 6154 PERA $3,523 $4,601 130.60% $3,345 $662 19.79% $3,603 $3,781 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $3,577 $3,576 99.97% $3,396 $1,132 33.33% $4,600 $4,655 TOTAL PERSONNEL $59,404 $76,211 128.29% $56,405 $11,590 20.55% $61,706 $64,572 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6230 VEHICLE SUPPLIES/PARTS $15,000 $10,807 72.05% $20,000 $3,485 17.43% $20,000 $20,000 6234 VEHICLE LICENSES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6240 BUILDING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6250 OTHER SUPPLIES $0 $540 #DIV/0! $0 $0 #DIV/0! $0 $0 6253 STREET MATERIALS $90,000 $61,903 68.78% $100,000 $39,795 39.80% $100,000 $100,000 6254 STREET/STRIPING MATER. $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6272 FUEL $15,000 $18,210 121.40% $22,000 $4,104 18.65% $22,000 $22,000 6290 UNIFORMS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $120,000 $91,460 76.22% $142,000 $47,384 33.37% $142,000 $142,000 OTHER SERVICES 6401 PROFESSIONAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6421 MUNICIPAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/0! $0 $0 _#DIV/0! $0 $0 6423 NATURAL GAS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 _ $0 6450 OUTSIDE PRINTING $0 $0 #DIV/0! $0 $0 #DIV/0! _ $0 _ $0 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 I #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $0 $0 #DIV/0! I $0 $0 I #DIV/0! $0 $0 6/4/2012 41 MUNICIPAL SERVICES-SNOW REMOVAL 6470 TRAINING/SUBSISTANCE $200 $0 0.00% $200 $0 0.00% $200 $200 6485 MILEAGE $0 $0 #DIV/0! $0 _ $0 #DIV/0! $0 _ $0 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6510 VEHICLE MAINTANANCE $21,500 $23,133 107.60% $21,500 $5,376 25.00% $21,032 $21,032 6515 BUILDING REPAIR $0 $0 #DIV/O! ; $0 $0 #DIV/0! $0 $0 6535 OTHER REPAIR $4,000 $4,789 119.73% $4,750 $0 0.00% $4,750 $4,750 6560 CONTRACTED SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $25,700 $27,922 108.65% $26,450 $5,376 20.33% $25,982 $25,982 TOTAL BUDGET $205,104 $195,593 95.36% $224,855 $64,350 28.62% $229,688 $232,554 6/4/201.2 42 MUNICIPAL SERVICES-SNOW REMOVAL CITY OF FARMINGTON _ 2013 BUDGET _ 1090 PARKS-MAINTENANCE ADOPTED THROUGH APPROVED THROUGH I REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 I % 2013 2014 6110 SALARIES-FT $226,049 $278,334 123.13% $236,143 $94,466 I 40.00% $238,487 $242,803 6112 SALARIES-OT $4,482 I $4,173 93.11% $4,858 $68 1.40% $5,000 $5,000 6120 SALARIES-PT $42,084 $27,756 65.95% $31,617 $2,240 7.08% $32,430 $32,916 6130 COMP TIME PAY $0 $2,222 #DIV/0! $0 $0 #DIV/0! $2,300 $2,300 6135 OTHER PAY $0 $2,708 #DIV/0! $0 $910 #DIV/01 $2,900 $2,944 6152 FICA/MEDICARE $24,096 $23,561 97.78% $20,855 $7,084 33.97% $21,505 $21,876 6154 PERA $21,934 $20,835 94.99% $18,853 $6,920 36.71% $19,404 $19,740 6156 HCSP $0 $517 #DIV/0! $0 $177 #DIV/0! $557 $574 6158 EMPLOYEE BENEFITS $31,139 $34,354 110.32% $43,039 $13,925 32.35% $46,900 $48,500 6159 WORKERS COM $0 $0 #DIV/0! $0 $2,559 #DIV/0! $0 $0 TOTAL PERSONNEL $349,784 $394,460 112.77% $355,365 $128,349 36.12% $369,483 $376,653 SUPPLIES I 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $8,430 $2,594 30.77% $6,000 $717 11.95% $6,000 $7,025 6230 VEHICLE SUPPLIES/PARTS $2,450 $7,383 301.35% $5,000 $1,421 28.42% $7,000 $7,100 6234 VEHICLE LICENSES $150 $0 0.00% $150 $256 170.67% $150 $175 6240 BUILDING SUPPLIES $1,500 $730 48.67% $2,100 $928 44.19% $2,100 $2,500 6250 OTHER SUPPLIES $34,947 $41,232 117.98% $39,200 $9,984 25.47% $48,200 $62,000 6255 LANDSCAPING MATERIAL $4,625 $2,286 49.43% $3,000 $353 11.77% $2,500 $2,700 6260 CHEMICALS $2,950 $2,921 99.02% $5,900 $0 _ 0.00% $6,500 _ $6,700 6272 FUEL $20,000 $25,079 125.40% $22,000 $5,018 22.81% $25,000 $27,000 6290 UNIFORMS $4,150 $2,216 53.40% $3,600 $1,139 31.64% $2,825 $2,925 TOTAL SUPPLIES $79,202 $84,441 106.61% $86,950 $19,816 22.79% $100,275 $118,125 OTHER SERVICES 6401 PROFESSIONAL SERVICES $14,911 $14,392 96.52% $16,281 $1,161 7.13% _ $18,900 $20,100 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $0 $487 #DIV/0! $0 $1,740 #DIV/0! $0 $0 6404 IT SERVICES $1,150 $1,150 100.00% $1,305 $435 33.33% $11,655 $11,655 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $3,555 $3,339 93.92% $3,500 $1,042 29.77% $3,500 $3,500 6421 MUNICIPAL SERVICES $1,700 $1,373 80.76% $1,700 $847 49.82% $1,700 $1,850 6422 ELECTRIC $9,600 $10,590 110.31% $10,750 $2,208 20.54% $10,750 $11,100 6423 NATURAL GAS $8,000 $4,318 53.98% $6,500 $2,085 32.08% $5,500 $5,700 6450 OUTSIDE PRINTING $0 $0 r #DIV/0! $0 $0 #DIV/0! $335 $370 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6/4/2012 43 Parks-Maintenance 6460 DUES/SUBSCRIPTIONS $505 $120 23.76% $335 $345 102.99% $0 $0 6470 TRAINING/SUBSISTANCE $2,760 $2,022 73.26% $1,900 $175 9.21% $2,080 $2,300 6485 MILEAGE $0 $0 #DIV/0! $600 $0 0.00% $600 $600 6505 EQUIPMENT REPAIR $8,060 $1,632 20.25% $9,260 $3,760 40.60% $9,760 $12,100 6510 VEHICLE MAINTANANCE $25,500 $31,799 124.70% $25,500 $6,375 25.00% $24,945 $24,945 6515 BUILDING REPAIR $450 $637 141.56% $450 $126 _ 28.00% $450 _ $550 6535 OTHER REPAIR $0 $0 #DIV/0! $15,000 $0 0.00% $30,000 $30,000 6555 EQUIPMENT RENTAL $14,400 $20,168 140.06% $18,000 $406 2.26% $18,500 $19,100 6570 PROGRAM EXPENSES $0 $29 #DIV/0! $0 $0 #DIV/O! $0 $0 TOTAL OTHER SERVICES $90,591 $92,056 101.62% $111,081 $20,705 18.64% $138,675 $143,870 TOTAL BUDGET $519,577 $570,957 109.89% $553,396 $168,870 30.52% $608,433 $638,648 6/4/2012 44 Parks-Maintenance CITY OF FARMINGTON 2013 BUDGET _ 1093 PARKS-RAMBLING RIVER CENTER ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $39,416 $39,955 101.37% $40,547 $12,008 29.62% $40,404 $41,010 6112 SALARIES-OT $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $21,239 $19,377 91.23% $21,451 $6,961 32.45% $21,850 $22,178 6130 COMP TIME PAY $0 $3,130 #DIV/0! $0 $0 #DIV/0! $200 $400 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $4,640 $4,288 92.41% $4,743 $1,311 27.64% $4,778 $4,864 6154 PERA $4,398 $4,528 102.96% $4,263 $1,375 32.25% $4,528 $4,610 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $12,512 $12,994 103.85% $10,761 $4,003 37.20% $11,050 $11,450 6159 WORKERS COMP $0 $0 #DIV/0! $0 $247 #DIV/0! $0 $0 TOTAL PERSONNEL $82,205 $84,272 102.51% $81,765 $25,905 31.68% $82,810 $84,512 SUPPLIES 6210 OFFICE SUPPLIES $450 $565 125.56% $850 $52 6.12% $850 $1,000 6220 EQUIPMENT SUPPLIES $500 $311 62.20% $1,650 $163 9.88% $1,750 $1,000 6230 VEHICLE SUPPLIES/PARTS $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6234 VEHICLE LICENSES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6240 BUILDING SUPPLIES $600 $3,592 598.67% _ $600 _ $123 20.50% $1,100 $1,350 6242 CLEANING SUPPLIES $200 $0 0.00% $200 $12 6.00% $200 $250 6250 OTHER SUPPLIES $50 $153 306.00% $50 $628 1256.00% $500 $500 6255 LANDSCAPING MATERIAL $0 $0 #DIV/0! $0 $0 #DIV/0! $100 $0 6260 CHEMICALS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6272 FUEL $0 $931 #DIV/0! $0 $306 #DIV/01 $1,000 $1,100 6290 UNIFORMS $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 TOTAL SUPPLIES $1,800 $5,552 308.44% $3,350 $1,284 38.33% $5,500 $5,200 OTHER SERVICES 6401 PROFESSIONAL SERVICES $17,000 $18,818 110.69% $15,010 $7,186 47.87% _ $18,970 _$18,970 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $200 $75 37.50% $200 $0 0.00% $200 $220 6404 IT SERVICES $5,174 $5,174 100.00% $6,525 $2,175 33.33% $11,914 $11,914 6411 TELEPHONE $600 $1,337 222.83% $1,400 _ $305 21.79% $1,400 _ $1,500 6412 CELLULAR TELEPHONES $252 $0 0.00% $250 $0 0.00% $250 $250 6421 MUNICIPAL SERVICES $4,000 $2,373 59.33% $4,000 $839 20.98% $4,000 $4,100 6422 ELECTRIC $7,000 $8,133 116.19% $7,300 $2,342 32.08% $7,300 $7,400 6423 NATURAL GAS $12,800 $8,078 63.11% $12,800 $3,512 _27.44% _ $13,000 $13,200 6426 1INSURANCE $3,010 $3,010 100.00% $3,020 $1,066 35.30% $3,020 $0 6/4/2012 45 Parks-Rambling River Center 6445 POSTAGE $900 $0 0.00% $900 $18 2.00% $700 $850 6450 OUTSIDE PRINTING $200 $42 21.00% $0 $12 #DIV/0! $0 $0 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $700 $967 138.14% $750 $702 93.60% $1,100 $1,095 6470 TRAINING/SUBSISTANCE $1,550 $850 54.84% $1,550 $50 3.23% $1,100 $1,350 6485 MILEAGE $100 $0 0.00% $100 $0 0.00% $100 $100 6492 ADVERTISING $500 $100 20.00% $1,000 $0 0.00% $1,000 $1,150 6505 EQUIPMENT REPAIR $500 $555 111.00% $500 $27 5.40% $500 $650 6510 VEHICLE MAINTANANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6515 BUILDING REPAIR $1,000 $188 18.80% $1,000 $16 1.60% $1,100 $1,800 6535 OTHER REPAIR $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $31 #DIV/0! $0 $0 6570 PROGRAM EXPENSES $18,000 $8,672 48.18% $18,000 $2,806 15.59% $13,000 $13,000 TOTAL OTHER SERVICES $73,486 $58,372 79.43% $74,305 $21,087 28.38% $78,654 $77,549 TOTAL BUDGET $157,491 $148,196 94.10% $159,420 $48,276 30.28% $166,964 $167,261 6/4/2012 4 6 Parks-Rambling River Censer CITY OF FARMINGTON 2013 BUDGET 1094 j PARKS-ADMINISTRATION ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 _ 2014 6110 SALARIES-FT $154,418 $99,519 64.45% $155,708 $40,990 26.32% $158,038 $160,409 6112 SALARIES-OT $2,002 $0 0.00% $1,427 $0 0.00% $1,427 $1,427 6120 SALARIES-PT $0 $79 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $3,401 #DIV/0! $0 $0 #DIV/0! _ $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $11,966 $7,745 64.73% $12,021 $3,053 25.40% $12,199 $12,380 6154 PERA $11,340 $7,465 65.83% $11,392 $2,972 26.09% $11,561 $11,733 6156 HCSP $0 $1,956 #DIV/0! $0 $650 #DIV/0! $1,808 $1,846 6158 EMPLOYEE BENEFITS $21,854 $22,316 102.11% $17,971 $6,365 35.42% $21,250 $22,050 6159 WORKERS COMP $0 $0 #DIV/0! $0 $358 #DIV/0! $0 $0 TOTAL PERSONNEL $201,580 $142,481 70.68% $198,519 $54,388 27.40% $206,283 $209,845 SUPPLIES 6210 OFFICE SUPPLIES $200 $73 36.50% $200 $0 0.00% $200 $200 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 .$0 6230 VEHICLE SUPPLIES/PARTS $50 $55 110.00% $50 $0 0.00% $50 $100 6234 VEHICLE LICENSES $125 $0 0.00% $125 $64 51.20% $125 $150 6240 BUILDING SUPPLIES $0 $0 _#DIV/0! _ $0 - $0 #DIV/0! $0 $0 6242 CLEANING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6250 OTHER SUPPLIES $100 $40 40.00% $800 $68 8.50% $800 $800 6255 LANDSCAPING MATERIAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6260 CHEMICALS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6272 FUEL $1,500 $1,510 100.67% $1,500 $87 5.80% $2,000 $2,200 6290 UNIFORMS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $1,975 $1,678 84.96% $2,675 $219 8.19% $3,175 $3,450 OTHER SERVICES 6401 PROFESSIONAL SERVICES $0 $100 #DIV/0! $0 $0 #DIV/0! $0 $0 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $1,000 $195 19.50% $500 $0 0.00% $500 $500 6404 IT SERVICES $22,995 $22,995 100.00% $26,100 $8,700 33.33% $10,482 $10,482 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! - $0 _ $0 6412 CELLULAR TELEPHONES $1,680 $1,234 _ 73.45% $1,680 $394 23.45% $1,680 $1,680 6421 MUNICIPAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/0! $0 _ $0 #DIV/0! $0 $0 6423 NATURAL GAS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6426 INSURANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6/4/2012 47 Parks-Administration 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/01 $4,100 $4,800 6450 OUTSIDE PRINTING $17,500 $14,681 83.89% $16,542 $7,595 45.91% $12,500 $15,000 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $1,152 $438 38.02% $1,270 $848 66.77% $1,270 $1,400 6470 TRAINING/SUBSISTANCE $1,000 $912 91.20% $1,000 $0 0.00% $1,400 $1,800 6485 MILEAGE $1,200 $962 80.17% $600 $270 45.00% $600 $600 6492 ADVERTISING $300 $0 0.00% $300 $0 0.00% $300 $400 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6510 VEHICLE MAINTANANCE $500 $500 100.00% $500 _ $125 25.00% $489 _ $489 6515 BUILDING REPAIR $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6535 OTHER REPAIR $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6570 PROGRAM EXPENSES $0 $0 #DIV/0! $0 _ $0 _#DIV/0! $0 _ $0 TOTAL OTHER SERVICES $47,327 $42,017 88.78% $48,492 $17,932 36.98% $33,321 $37,151 TOTAL BUDGET $250,882 1 $186,176 74.21% $249,686 , $72,539 29.05% $242,779 $250,446 6/4/2012 48 Parks-Aa m i n istra ao n CITY OF FARMINGTON 2013 BUDGET 1095 PARKS-RECREATION PROGRAMS _ _ _ _ ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6112 SALARIES-OT $1,999 $0 0.00% $1,426 $0 0.00% $1,430 $1,430 6120 SALARIES-PT $36,858 $22,984 62.36% $37,749 $410 1.09% $37,935 $38,504 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $3,012 $1,748 58.03% $3,038 $32 1.05% $3,011 $3,055 6154 PERA $2,855 $0 0.00% $2,878 $0 0.00% $2,854 $2,895 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $1,230 $1,230 100.00% $1,239 $407 32.85% $2,360 $2,950 TOTAL PERSONNEL $45,954 $25,962 56.50% $46,330 $849 1.83% $47,590 $48,834 SUPPLIES 6210 OFFICE SUPPLIES $0 $44 #DIV/0! $0 $145 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6230 VEHICLE SUPPLIES/PARTS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6234 VEHICLE LICENSES $0 $0 #DIV/0i $0 $0 #DIV/0! $0 $0 6240 BUILDING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6242 CLEANING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6250 OTHER SUPPLIES $300 $85 28.33% $700 $0 0.00% $700 $1,150 6255 LANDSCAPING MATERIAL $0 $0 #DIV/0! $0 $0 _ #DIV/0! $0 $0 6260 CHEMICALS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6272 FUEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6290 UNIFORMS $400 $0 0.00% $400 $0 0.00% $400 $500 TOTAL SUPPLIES $700 $129 18.43% $1,100 $145 13.18% $1,100 $1,650 OTHER SERVICES 6401 PROFESSIONAL SERVICES $35,000 $26,562 75.89% $35,000 $2,444 6.98% _ $35,000 _$36,000 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $0 $150 #DIV/0! $0 _ $0 #DIV/01 $0 $0 6404 IT SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $420 $348 82.86% $420 $0 0.00% $420 $450 6421 MUNICIPAL SERVICES $0 $0 #DIV/0! _ $0 _ $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6423 NATURAL GAS $0 I $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6426 INSURANCE $0 $0 #DIV/0! $0 $0 1 #DIV/0! $0 $0 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 r $0 6/4/2012 49 Parks-Recreation 6450 OUTSIDE PRINTING I $500 $0 0.00% $500 $417 83.40% $500 $600 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $0 $103 #DIV/0! $0 $0 #DIV/0! $0 $0 6470 TRAINING/SUBSISTANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6485 MILEAGE $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6492 ADVERTISING $200 $0 0.00% $200 $0 0.00% $200 $300 6505 EQUIPMENT REPAIR $100 $0 0.00% $100 $0 0.00% _ $100 $100 6510 VEHICLE MAINTANANCE $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6515 BUILDING REPAIR $0 $0 #DIV/0! $0 $0 #DIV/OI $0 $0 6535 OTHER REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0I $0 $0 #DIV/01 $0 $0 6570 PROGRAM EXPENSES $33,148 $23,935 72.21% $33,200 $2,775 8.36% $33,200 $34,100 TOTAL OTHER SERVICES $69,368 $51,098 73.66% $69,420 $5,636 8.12% $69,420 $71,550 TOTAL BUDGET $116,022 $77,189 66.53% $116,850 $6,630 5.67% $118,110 $122,034 6/4/2012 50 Parks-Recreation CITY OF FARMINGTON 2013 BUDGET 1097 PARKS-POOL ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 4/2012 % 2013 2014 6110 SALARIES-FT $12,200 $5,357 43.91% $10,726 $1,144 10.67% $20,134 $11,240 6112 SALARIES-OT $0 $130 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $53,067 $43,476 81.93% $53,597 $0 0.00% $53,875 $54,683 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $4,993 $3,752 75.15% $4,921 $87 1.77% $5,662 $5,043 6154 PERA $0 $543 #DIV/0! $778 $83 10.67% $5,366 $4,779 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $2,908 $2,907 99.97% $2,866 $955 33.32% $4,375 $4,375 TOTAL PERSONNEL $73,168 $56,165 76.76% $72,888 $2,269 3.11% $89,412 $80,120 SUPPLIES 5502 COST OF GOOD SOLD $7,000 $6,597 94.24% $7,000 $0 0.00% $7,000 $7,000 6210 OFFICE SUPPLIES $0 $12 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $2,500 $2,567 102.68% $2,500 $2,583 103.32% $7,200 $3,200 6230 VEHICLE SUPPLIES/PARTS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6234 VEHICLE LICENSES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6240 BUILDING SUPPLIES $2,500 $4,145 165.80% $2,500 $41 1.64% $5,500 $3,000 6242 CLEANING SUPPLIES $200 $3 1.50% $200 $0 0.00% $200 $200 6250 OTHER SUPPLIES $500 $1,578 315.60% $500 $20 4.00% $1,500 $1,500 6255 LANDSCAPING MATERIAL 1 $0 $0 #DIV/0! $0 $0 #DIV/0! $100 $0 6260 CHEMICALS $6,500 $5,561 85.55% $7,500 $0 0.00% $7,500 $8,000 6272 FUEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6290 UNIFORMS $1,350 $1,039 76.96% $1,000 $0 0.00% $1,100 $1,250 TOTAL SUPPLIES $20,550 $21,502 104.63% $21,200 $2,644 12.47% $30,100 $24,150 OTHER SERVICES 6401 PROFESSIONAL SERVICES $2,500 $4,145 165.80% $2,500 $400 16.00% _ $3,750 $4,050 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 _#DIV/0! $0 $0 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0I $0 $0 6404 IT SERVICES $0 $0 #DIV/0! $0 _ $0 #DIV/01 _ $0 $0 6411 TELEPHONE $0 $579 #DIV/01 $0 $63 #DIV/0I $350 $400 6412 CELLULAR TELEPHONES $375 $620 165.33% $625 $93 14.88% $300 $300 6421 MUNICIPAL SERVICES $1,300 $1,483 114.08% $1,500 $167 11.13% $1,500 $1,600 6422 ELECTRIC $4,000 $3,807 95.18% $3,750 $401 10.69% $4,000 $4,200 6423 NATURAL GAS $9,500 $3,774 39.73% $9,000 $135 1.50% $9,000 $9,200 6426 INSURANCE $3,100 $3,100 100.00% $3,100 $1,033 [ 33.32% $3,100 $3,200 6/4/2012 51 Parks-Pool 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6450 OUTSIDE PRINTING $0 $352 #DIV/0! $400 $0 0.00% $400 $450 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $1,500 $816 54.40% $1,325 $929 70.11% $1,350 $1,450 6470 TRAINING/SUBSISTANCE $900 $651 72.33% $900 $251 27.89% $1,100 $1,100 6485 MILEAGE $150 $140 93.33% $150 $0 0.00% $150 $150 6492 ADVERTISING $100 $0 0.00% $100 $0 0.00% $100 $150 6505 EQUIPMENT REPAIR $2,000 $4,810 240.50% $2,000 $211 10.55% $3,000 $3,500 6510 VEHICLE MAINTANANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6515 BUILDING REPAIR $0 $0 #DIV/01 $2,500 $0 0.00% $2,500 $3,000 6535 OTHER REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6570 PROGRAM EXPENSES $650 $1,645 253.08%. $600 $0 0.00% $1,725 $1,940 TOTAL OTHER SERVICES $26,075 $25,922 99.41% $28,450 $3,683 12.95% $32,325 $34,690 TOTAL BUDGET $119,793 $103,589 86.47% $122,538 $8,596 7.01% $151,837 $138,960 6/4/2012 5 2 Parks-Pool