Loading...
S-1330 - 03/13/2012 - BUDGET - Ordinances Supporting DocumentsIT13M 6.G.2) OF .. #jk� 1�0 I own== 1i Y% yr i r� k� t s � { � � - ; d J� G� 3 i �i i� j, � a % 1 i i 7i F �� t � i i €'..'i.,: t }pia �t ;;f ".i,g I _. AGENDA ITEM Regular Board of Trustees Meeting of March 13, 2012 SUBJECT: Transfers Among Budget Line Items FROM: Sharon Dangles, Finance Director BUDGET SOURCE/BUDGET IMPACT: Effects Numerous Budget Programs RECOMMENDED MOTION: I move that the Village Board approve Ordinance 5 -1330, "An Ordinance Authorizing Transfers Among Budget Line Items" for the year ended December 31, 2011. Backeround/Historv: During the course of a year, there are numerous situations that may arise that cause an account, program, or even a fund to exceed its budget. When this occurs, State statutes provide that the corporate authorities may make transfers from "one corporate object or purpose to another corporate object or purpose ". Additionally, statutes provide that the corporate authorities may delegate authority to heads of municipal departments to "delete, add to, change, or create sub- classes within object classes budgeted previously to the department with the approval of the budget officer or executive officer of the municipality ". The Village has defined a corporate object or purpose to be an individual program or fund. Sub - classes within object classes have been defined as accounts and categories within a budget program. Now that all of the year -end accounting adjustments have been made, several budget accounts, categories, and programs have been determined to have ended 2011 over budget. The Village Board's policy on Finance, Taxation, and Budget, prepared based on the previously mentioned statutes, outlines the following procedures for budget administration and how these variances are to be addressed: ctl � 1. That the Budget Officer, with the approval of the Village Manager, may authorize transfers of budgeted funds between accounts or between account categories within a single budget program. 2. That any transfer of budgeted funds from one budget program to another shall be subject to approval by the Board of Trustees upon the recommendation of the Village Manager. 3. That any transfer from contingency ncy shall be subject to approval by the Board of Trustees upon the recommendation of the Village Manager. 4. That any increase in the total appropriation within any fund shall be subject to approval by the Board of Trustees upon the recommendation of the Village Manager. In order to make as few changes to the originally adopted budget as possible, formal budgetary control has been established at the category level, i.e. personnel, materials and supplies, operation and contractual, and capital. For example, if staff turnover created a need for overtime, this may lead to the overtime account going over budget. However, this would likely be offset by an underbudget salary account. By not doing budget transfers for these types of situations we preserve the original budget as the basis for evaluating our actual performance versus expected performance. Through Budget Year 2002, staff approved an extensive listing of budget transfers administratively due to budget variances in account categories within a single budget program as provided for under Procedure #1. In practice, these transfers were only reflected in the Village's audit report-our accounting records were never adjusted for any budget transfers in order to maintain proper original budget/actual comparison data. With the new reporting requirements associated with GASB Statement #34, the Village is now required to publish original budget amounts in addition to revised budget amounts in its audit report. This new requirement reduces the value of these administrative transfers required under option 41. After consultation with the Village's auditors, in Budget Year 2003 and thereafter only program -to- program transfers and additional fund appropriations are recorded. These transfers are required since this is the level of legal control where budget compliance is measured. In addition to the budget transfers required under the Village's Financial Policy ordinance, during 2004 the Village Board began requiring budget transfers during the year when an individual line item account exceeded budget by more than 10 %. This policy was revised in October, 2006 by eliminating the 10% threshold and instead requiring line item transfers when an account exceeds its budget by $2,500 in a material and supply, operation and contractual or capital account (6000 to 9000 account series) or $10,000 in a personnel series account (5000 account series). Many of these transfers have already been approved by the Village Board and have been posted to the accounting system; thus, these transfers are not reflected here. Please note that all transfers are only for the amounts necessary to offset the individual program budget variances, and in most cases the transfer is done only to the individual line item that has the largest variance. In most cases it is several accounts that would cause a program to exceed its budget. Also, in some cases the variance in a particular line item may be greater than the amount of the transfer, with offsets found in other line items within the budget program. After these transfers are made, numerous line -items and categories will remain over budget; however, each program in total will be within budget. Program Transfers The General Corporate Fund total actual expenditures are under the budgeted expenditures by $2.2 million for the year ending December 31, 2011. Please note that "over budget" does not mean that money was over spent. There are numerous situations that occur during the year that may cause a particular line item to go over the annual budget. The following is a brief explanation of the causes of program transfers that exceed $10,000: Program 121 - Legal: Account 121 -76320 (Village Prosecutor) is over budget in total by $14,400 due to ongoing litigation. The Legal Contingency budgeted amount of $50,000 was used to offset these legal expenses. Program 131 - General Management: Salaries Full Time is over budget by $13,000 due to an employee bonus of $5,000 and the budgeted allocation of payroll differed to the actual allocation, as a person's time can be spent in different programs. Program 134 -Risk Management: Account 134 -70100 (Liability Insurance) is over budget by $25,000 due to claims being higher than budgeted. Liability Insurance is broken out into numerous programs, therefore on a whole Liability Insurance exceeded the budget by $33,573. Program 221 - Accounting & Reporting Account 221 -73150 Ambulance Billing is over budget by $11,605 due to higher volume this year. Program 335 - Forestry: Tree Services (account 335- 76800) is over budget by $30,000 due to the unanticipated storm damage. Proaxam 611 - Police Services Management: Account 611 -50000 (Salaries — Full Time) is over budget by $20,200 due to the resignation of the Police Chief with final benefit payouts and staff early retirement payments. Program 633 - Communications Center: Account 633 -50000 (Salaries — Full Time) is over budget by $14,000 due to the early retirement that occurred in 2011 with the payment of final benefits. Program 461 - Roadway Improvements: Account 461 -76200 (Engineering Services) is over budget by $15,200 due to professional services performed. Program 351 -Water Operations: Account 351 -50000 (Salaries — Full Time) is over budget by $24,000 and Salaries — Overtime by $13,000 due to actual payroll expenses exceeding budget. The Public Works union contract was signed in April, 2011 and an estimate was used for the 2011 Budget. Account 351-65000 (General Equipment) is over budget by $34,100 due to the cost of water meters. Account 351 -70100 (Liability Insurance) is over budget by $33,000 due to deductible payments being higher than budgeted. Program 451 -Water System Improvements: General Equipment is over budget by $12,500 due to the expenses being budgeted in a different account. Program 811 -Sports Core General Operations: Salaries Full -time is over budget by $20,000 due to an employee who left and received final payout amounts from the value of their accumulated time on the books. Program 812 — Swimming Operations: Maintenance services is over budget by $15,000 due to repairs needed at the Pool for the dive stand and pump room clean up. Program 813 — Summer Tennis: Account 813 -50200 (Seasonal Salaries) was over budget by $14,100 due to the need for additional help needed to meet the demands of the tennis program. Program 816 — Open Field: Taste of Oak Brook expenses were over budget by $10,500, however the revenues covered these expenses for the event. Program 821 — Clubhouse Food & Beverage Operations: Account 821 -50200 (Salaries - Seasonal) is over budget by $20,500 because the original budget for this employee was accounted for in Sports Core Administration. We are just moving the budgeted dollars from one program to another. Account 821 -72200 ( Maint. Buildings) is over budget by $11,100 due to roofing repairs and stair replacement. Program 823 — Golf Food & Beverage: Part-time salaries is over budget by $54,300 and overtime by $10,500 due to the employee working off season to assist with the transition from Calihan's to preferred catering. In addition, the employee also assisted with the Poolside Grill operations. Other accounts were under budget, therefore this expense was covered. Account 823 -54050 (Unemployment Compensation) is over budget by $14,000 due to the unbudgeted amount based on former employees gaining employment. Food Cost in this program of $14,000 was not allocated to the Poolside Grill during the year, therefore a budget transfer is needed at year end. Maint. Other Equipment is over budget by $12,000 due to emergency air conditioning repairs and compressor replacement. Other accounts were under budget, therefore this expense was covered. Program 831 -Golf Club General Operations: Account 831 -50000 (Salaries —Full Time) is over budget by $12,000 due to the expense being budgeted for in contract services. Originally, maintenance work was going to be contracted out and it was decided during the year to utilize a public works employee. We are moving the budgeted dollars in contract services to full -time salaries to cover the variance. Account 831 -72200 ( Maint. Buildings) was over budget by $13,800 due to the emergency heating and cooling repairs. Program 133 - Employee Benefits: Account 133 -70300 (Specific Premiums) is over budget by $10,200 due to higher claims. Specific Premiums are stop -loss reinsurance for the Village's insured Health and Dental Plan. Please feel free to contact me if you should have any comments or questions. ORDINANCE 2012- BU -EX1 -S -1330 An Ordinance Authorizing Transfers Among Budget Line Items WHEREAS, the Village Manager has recommended certain transfers among budget line items in the Annual Budget Ordinance passed for the fiscal year beginning January 1, 2011 and ending December 31, 2011, and certain transfers of sums of money in said Budget Ordinance from one object or purpose to another object or purpose; and WHEREAS, the Village President and Board of Trustees concur with and approve of the Village Manager's recommendations. NOW, THEREFORE, BE IT ORDAINED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF OAK BROOK, DU PAGE AND COOK COUNTIES, ILLINOIS that the following transfers are hereby authorized: Section 1: The recitals above are hereby incorporated into and made a part of this ordinance. Section 2: In the attached schedule, attached as "Exhibit A ", the amounts shown in the column titled "Transferred From" represent unexpended balances. The total of said amounts are hereby transferred to the various items specified in the "Transferred To" column immediately opposite the items specified in the "Transferred From" column. Section 3: The Garage Fund budget is amended by increasing the amount budgeted in account 341 - 60300, "Gas & Oil ", by $46,000 and account 341 - 71600, "Maintenance Vehicles ", by $5,000, which increase shall be funded by this Fund's fund balance. Section 4: This ordinance shall be in full force and effect from and after its passage and approval as required by law. Section 5: All ordinances or parts thereof in conflict with the provisions of this ordinance be and the same are hereby repealed to the extent of such conflict. APPROVED THIS 13'h day of March, 2012. PASSED THIS 13th day of March, 2012. Ayes: Nays: Absent: Gopal G. Lalmalani Village President ATTEST: Charlotte K. Pruss Village Clerk ro L x W i 0 Q Q w w 0 O 0 0 N m F- r O w N 0 N N 0 = r m w N Q` w O) (0 O LL E O F LL w Imp c � m< t— H f (D c N < F 0 O O O 00 LO 0 0 0 0 0 (n O O O O 00 00 O O O O O LL7 r 0 V O O O M (n O O O O co co V V V M in 0 r In (1 M W M N 1� r r N c C 0 w w O � C C U C N 0 C � E a w d w E Z w ' w U E U U U U_ E a_ U w N c w w Z 'g e w ( w 2 w Z E c Z LL U 2 m U C c E C O N C. w 41 w Z w E — m .0 Q W m w w N C V c U_ w TZ(n N j f0 U M w w rn= Q (D m (p w w rn- 'O > m Q m c (O U c > V) O U w C U L cc O C C N O w ` - U u ° U DcQU a w N w 0L (ia r w 00 0 0 00 0 0O 000 0 O LO Cl) in 0 LO 0 0 O Vn (n o In 0 01 m 0) O V V N m 0) O I- co Cl) (D co to (n O o N (D Cl) r� r _@ cc o rr V N co (D r r r N Cl) M Cl) (`7 M (O (n N r N r r r r r r r r r r N N N co O O O O O Un In O O VO o 0 O O O O O O O O O 0 LO r C C O O OD C 0 O (D 1� V? V M LO O M M c7 r M-�i r r N Q r C C U N O C C U N 0 C E w d w E Z w ' w E U E a_ c w w Z 'g (n w ( ad c CM (J c r O l0 E Z U C c w Q (n W C O N C. w C w E — of .0 Q W O w N C V N N j f0 N w M Q U C � m (p w w 'O C� NO LL N N L_ . E V) O U w C U L cc (0 C C O O (n W °� '0 O Q w a w N w w �. r U G Q m p. J w (D w a' z, 0 C (D C ¢ 7 Ut i �.0 ' E ' C L j C _@ cc o N M M LO c,4 J w r Q' O (n r J Gr r U C N 0¢ (`N') Y R 0 D Q U0 0 0 0 0 0 0 0 0 0 0 00 O O N O O O O In (D In O O a) CD MO N N LO , N (D ^ co O N M w Il� 17 1� u7 n 1� (Q Il� 14 fl� 1i I c I N N M M a r r r r r Q c 00 00 000 000 0 O 0 0 O 0 H r, 0 O O O O O O N O O l0 L() O) V N x O N M r- M co V N n V W c 0 co w c a n c o ff o t o U w c d d E LL U c L @ E rn FE w O _ H C C .O C N C U @@ C "O N w @ Q 0 Q. @ = E @ CL U 2 a ~ CL N m O E fq N O LL a 06 N U) (n N N C N @ C N ID M 0 J fA In � O a N a Qa E w Z U °0 0 0 0 LO CD 0 0 w 00 00 2 H miLO C. LO V i m o LO 2 12 U r r �_ m r .0 Q (Cl)M co M (D co O (D n I 0) (ND M (D -It O @ N N OF, m w O M C @ m'0 `" @ = c - 00 a 00 O O In O 0 V N LL O M N Cl) V N D) r Ld O m E @ Q O LL N C C EC C N @ cu C (D p C y F-F 0 aEi D U 0 E O N O N N a (D U @ p F- Q F N d F ~ F d C .0 @ (n y V U E N Q W C '� 1 J U. UJ 4) LL C O N O LL O LL N C (0 U O) u7 (D in O in P 0 a N w m F (o ((DD � (� rn to M v w` 0 a U LL E a > > Z o 0 00 °O °O CD c ° 0 0 (D 2 C OD O Cl) O O O N O (^D (^D LL') O N (D ° i0 (O (Q @ 0 M •- m N N O w C N co V Cl) (D (D (D n D) F LO W) (DOOOO O O 0000 Oo Q 00 00000 O O OONO Lo N O O O Cl) LO m N OD O O 0 LO x G cr V M M I- N cl (h O V N L - w O N N , M M N E Q c O N �p E O C o E E i d E LL (D a; V) m E U c c w TC)m� N � v d N 12 O Q V) '�. U (n C _U C N m N U c" O. E 02f E Z ° Z E J m a) C a w N H a) O CL V) O_ O O C V !0 O)o a) N (D n N 'M C C C .- .- J 01 m 0 a C m a) a m m m c m c m o m L O O W 2m20 w (n 7 JU (AU a (D Qa E m «? J Z 0 0 0 0 O o O 0 0 00 0 0 m O 0 0 0)n0 o O(n00 0o ` C co M 1� co 't M (D _ _ O )D N co Y I— J O Cl) V O O O V) O ° o rn ��� � n v)�nn Lncq ° ° r r N N m Q (ND (O LO U7 U') Lo LO �- N V Cl) M Cl) M M V co co O co co 00 O m TO O m ° M C 0) a) 0) N m (M'O m a) LO N O O O O O O O 0 0 0 0 O O co 00 0 0 0 0 0 O O O O N O O O N M Iq O O M �- O (O O 0 0 0 0 ( 0 0 a M N N M n M M � N r� L O M O N CD E m O LL N N C C a) N O E C N a) d o E N E > c O . c_ F — C m, EE OL "io EEnacid d d °'vEa�'i O�� c(0)a3 co N N (n O d w F¢> > (n N (� 0 c N E O Q J> a) = JJ LL O o m y J a) a1 V LL E a) U c c d a w e v w r �' E Z c m 0) (D d d in � (n (� am) m U aci to C C.0 C N C C C C N 0) LL n m m a) C N mm (D V c w M mmm(Dm N w J U) d' Ci 00 mmmm U) m 00 22 7 c J E Y J LL LL J N C Z O = 000 00 Cl ad+ O 000 O 00 7 O O O O O O m (� O O O O O O C N C LL O M N O O 3 O N N M (rte° N N ° m d nv)(9(4� (4 m i0 Lo �n UN Q +. )O N u7 (° LO i0 ++ O a r' N CV C F M M M M M LO 1- V1 M ap a0 co 00 co C) 00 0 00 0 ooOOOOOOo O 00 O OLn O 000000000 �O (DLO U) corn Mo(no(00000 x O M O 10 O 1- O V O n (Ni V rn O rn LL O Cl r N N N M I E Q C 0 O O c Y a) d m (D N 0) o f am E (D E CL aEi o f LL � U > U c w U a) m w w 0 a) _ C N O` N O n�W O C m c o c �o_ E d � E aM i � K � � W o a`�i FQ C7 O j y .� O C O� TOD U) N N (n�� d�6o�0 w E O 0 a) Cu as Ec w�c'9n >daD 3 0t > UH z Z) O in U(n0LuCLMD0-iC7 0 CL Q E m n Z 0)0 0 00 O 000000000 w o 00 0 0 0 O O O O O u) 0 0I� O C) V 00 V ON O V F (O O to 0 V O M(Dwo M V O M O C I� O rn I r- 0) T (O I i m (Q T N I� O L p U 0 U C7 M (O N r M M M r r 07 L) Q OD I r 00 OD I OD N N 00 00 N Co M N M M N N M M M 00 00 00 OD 00 OD 00 O 00 N cc (` (� O Co 0 F M a a o N N CO (D > :2 0 0 0 oOOOOO O 000000 m (n O O 00000(0 O OOOOOO �0 in LO I,- (D CV) (n0(000 LL OLf V O O Co (O �z N M O V N V N 0 r r N .- (O .- r rn E A Q O LL N O] v > Ca O y N F N C 0 2 C O d 0 n d a0i a) j LL C 0] n C E LL w O > 0 E c v c a�i c m LL c� 'O ' p = U m E E 0 O Q N CD _ C O r W F a) a) CD N LL U J a) a) C 'O Q O > 0 n la > N rn E (n C C O .0 (n la U W N J a 0 E N Cu E m a) m N C 0 O 0 0) w i OT 0 L Co U) w m O al O 57 a) (i �� 0_ v O O a) d n� (0J 0 U C C. C> ' V@ O M O O O N > Cl) (a (a O 07 C a1 O Q) a) V M 00 (n Co 00 (n Co (Oi Q R W Co m (A U) LL d a E 2 0 O o 0 0 0 0 0 0 0 0 o O o 0 0 o O o 000000) uD 00(0000 C N V NCi NN C) 0) N MOV �-NM =O Cl) V ^ (OOi W L9 19 n r� 19 L? (Of) (4 19 P7 UN CO (p r N m Cl) M MMCl) <" Q Co Co Co N N N N N N 00 00 Co 00 OD OD N 00 N N N N N N Co Co 00 OD Co 00 ¢ 0 0 0 0 0 m 0 0 0 0 h 0 0 $ c 0 0 0 o N 0 ON OW V O O O O 000 00 N O N 0 L C O W N V M Cf N r- 'Q M (O O O W r E aD c 0 N d ` N a U m off E a) c'o E LL O (D @ ? U� =od °- om E a?o �r CL ma v vUZ Ea m a) U L a mmctn corn dm H O U Co Co m EN¢ 0 (D t) N C C w a7 N > c a7 — o o (a O O �a an 0) D �(n LL: U) ¢-i O a CL E o Z 0000000 000 00 , OOO 00 ` C O Ig0000 0 O ,° r O N N( O O Cl) N - 19r (O 19 00 0 U f r 19 D m M m � m Q Co M Co Cl) Co Cl) Co a0 W OD W aD W W OD GO OD Y C (D O 12 N O m F-� 16 — V Cl) p) N N D] a) O O O,° O O O (f 7 O O O O h (� O O O N O O O O O O O O N O O 00 N 0 0 0 N O O N r CL V7 cro v r-: v ci Co of (+i m rn ° E N It (O m ¢ 0 LL N C O N m c C a) O C a� N C a) w C tn0_,n C CA (a E E a) 0 c o 5 C c m E d v ° 'CL m E a(D ) Q F- J LL F a °-m W a) O d U LL U e U N — .? U m .2 W m c w .� ° —_ t O a O E a o a (n c m a) r N C U 9 W ' !c C U N 7 a) C C LL M - r OMO (n i7 �Q 000 (72' m C (n ¢O C i LL Lo U v o) v E N c c c Z O O O O 0 0 0 C 0 0 0 . LL 0 0 0 0 O O O CL O O O N C O O N O M( O M (n y M O O U) Q 3 o O N M O N N rr R c o O r r- rr m m m U - 'Q V V Y O � a) M M M �+ O O ¢ Co M Cl) Cl) M Cl) M N Cl) M m H Co Co W OD Co aD W F I F