Loading...
S-1304 - 03/08/2011 - BUDGET - Ordinances Supporting DocumentsITEM 6.G.4) F 0 t„1��':+i v q _OUNT AGENDA ITEM Regular Board of Trustees Meeting of March 8, 2011 SUBJECT: Transfers Among Budget Line Items FROM: Sharon Dangles, Finance Director BUDGET SOURCEBUDGET IMPACT: Effects Numerous Budget Programs RECOMMENDED MOTION: I move that the Village Board approve Ordinance S -1304, "An Ordinance Authorizing Transfers Among Budget Line Items" for the year ended December 31, 2010. Background/History: 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 2010 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: 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 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 #1. 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 total actual expenditures are under the budgeted expenditures by $.8 million for the year ending December 31, 2010. 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,565 due to ongoing litigation. The Legal Contingency budgeted amount of $100,000 was used to offset these legal expenses. Program 134 -Risk Management: Account 134 -50000 (Salaries -Full time) is over budget by $22,850 due to a cost allocation of one's time spent on risk management issues. Program 151- Information Services: Account 151 -91600 Computer Hardware & Software is over budget by $72,560 for various information technology related projects. The total IT budget was within their original budget request. Program 321 - Building and Grounds: Account 321 -77000 (Other Services) was over budget by $56,830 due to the unbudgeted recycling disposal program for residents. The Village did receive grant money for this, which offsets this expenditure in grant revenue. Program 335 - 17orestry Tree Services (account 335- 76800) is over budget by $60,560 due to the unanticipated storm damage. Program 611 - Police Services Management: Account 611 -50000 (Salaries — Full Time) is over budget by $100,785 due to the budgeted early retirement that did not occur in 2010. Account 611 -76300 (Outside Legal Services) is over budget by $57,225 due to ongoing legal proceedings. Program 621 - Police Field Services: Salaries Full time is over budget by $100,785 due to the budgeted early retirement that did not occur in 2010. Salaries — Overtime Special Detail is over budget by $96,055 due to a special detail at MB Financial Bank. This is offset by revenue the Village received in Special Services — Police of $145,000. Health Insurance was over budget by $18,345 due to budgeted cost savings in the police union contract. Program 631 - Police General Support: Account 631 -50000 (Salaries — Full Time) is over budget by $56,990 due to the budgeted early retirement that did not occur in 2010. Program 636 - Administrative Adiudication: Salaries Full -time and Part-time was over budget by 13,280 and 10,000 respectively. This was a newly created program in 2010 and most of these expenditures were budgeted for in program 634 (Police Records). It was determined to keep track of these expenditures in a separate program, which is the reason why program 636 was created. Program 700 -Fire, Rescue & EMS Operations: Firefighters' Pension Fund contributions are over budget by $70,960 due the actual contribution rate of 39.22% being above of the rate of 35.37% assumed in the budget. Program 731 - Emergency Medical Services: Account 731 -76700 (Contract Services) was over budget by $41,165 due to the budgeted amount based on the assumption that this was planned to be reduced. Program 361 - Street General Salaries: Account 361 -51500 (Health Insurance) is over budget by $50,000 due to the unbudgeted expense of certain employee(s). Program 351 -Water Operations: Account 351 -65000 (General Equipment) is over budget by $15,950 due to the purchase of water meters for replacements. Account 351 -71300 (Electric) is over budget by $13,200 due to the actual usage being higher than the budgeted amount. Account 351 -74400 (DWC Fixed Costs) is over budget by $29,925 due to a prior year adjustment billing the Village received from DuPage Water Commission. Program 811 -Sports Core General Operations: Salaries Full -time and IMRF are over budget by $21,625 and $11,475 respectively due to an employee who left and received final payout amounts from the value of their accumulated time on the books. Seasonal Salaries was over budget by $14,635 due to the need for additional assistance. Program 813 — Summer Tennis: Account 813 -50200 (Seasonal Salaries) was over budget by $13,515 due to the need for additional help needed to meet the demands of the tennis program. Program 821 — Clubhouse Food & Beverage Operations: Account 821 -54050 (Unemployment Compensation) is over budget by $30,385 due to the unbudgeted amount based on former employees gaining employment. Account 821 -72300 (Maint. Other Equipment) is over budget by $13,245 due to unexpected repairs. Program 823 — Golf Food & Beverage: Part-time salaries was over budget by $10,590 due to the need for additional assistance. Account 823 -54050 (Unemployment Compensation) is over budget by $13,810 due to the unbudgeted amount based on former employees gaining employment. Program 831 -Golf Club General Operations: Account 831 -54050 (Unemployment Compensation) is over budget by $14,725 due to the unbudgeted amount based on former employees gaining employment. Account 831 -50200 (Seasonal Salaries) was over budget by $12,570 due to the need for additional help needed to meet the demands of the operations. Program 834 — Golf Course Maintenance: Salaries — Overtime is over budget by $18,910 due to the unexpected storms that occurred, which resulted in overtime. Account 834 -61800 (Chemicals) was over budget by $24,825 due to maintaining the field from the unexpected storm. Program 844 — Golf Improvements — Surcharge: Account 844 -65000 (General Equipment) is over budget due to the purchase of sod replacement and rental of pumps to assist with the clean- up from the storms. Program 133 - Employee Benefits: Account 133 -70340 (HMO Premiums) is over budget by $28,380 due to more employees than expected moving from a PPO plan to a HMO Plan. Account 133 -70900 (Dental Claims) is over budget by $11,670 due to more claims. Program 341 - Garage Operations: Account line item 341 -60300 (Gas & Oil) is over budget by $27,785 due to the cost of gas and oil exceeding budget. Please feel free to contact me if you should have any comments or questions. ORDINANCE 2011- BU -EXI -S -1304 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, 2010 and ending December 31, 2010, 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: This ordinance shall be in full force and effect from and after its passage and approval as required by law. Section 4: 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 EP day of March, 2011. PASSED THIS 8'" day of March, 2011. Ayes: Nays: Absent: John W. Craig Village President ATTEST: Charlotte K. Pruss Village Clerk E47 t C W O E E -) o F ii 3 N F- c0 m O O O O O O N m o O0 O IO N N CL r r` W t0 O V N O ¢ E NN CD z O y � M� Y N � U O N 0 O U CD N O 9 Q Y C ON N N O N M F � m c w O M C N 0) N cV 0 m D 0 7 C 3 =_ CD N N g N d N Q CL C E m O E N Q a N 0 LL N c0 O O O O O O N m o O0 000 IO N N N N r r` W t0 O V N O NN 0 O 0't (0 V r- M w O N 0) 7 M� r N O t0 r` N � � � � N7 lO r- .-- (0 d' E N m O N M ca c c C 0 3 t0 N g E N Q O` LL Y E _ c N a N N u 9 m E a N U E E d cr W EE L) Eu 2- c .3 v m O 'g E 2 O m O. U Z N 4 N 6 C W E —r a��.ZUa� a aW t) N N U o N N c c LL d E W D c m U) U °� N . 0 o a) m c m cu °d L o. U T N N C a s O U� O N U O O N c c 'c E a o y a c o O m a cu a) EoEco E �cc_ m J J (A (Q U O � N� '2 N N co f-Z) F-2'UO U W J J J 0 M 0 o o o o o 0 0 o O o 000 LO M O O O O to 0 0 O )O O O O 0 0 0 t M c0 O M O LO M 0 O O N M V N 00 M r- r- N V N, N (0 r (D u N 000 r- r n r, f0 r• r` r; V 1 N N r r N r to N N N M .0- ems- * I Cl) M M M N CO co O 00 0) 0) N N N )O N n N U) co .c c N m _2 0 NN 0 E m n O ca N N E c C � O 3 t0 N g E Q O` LL Y E _ N N N u 9 c U E d cr W o 2- U m 'g E 2 � L 0 m W E ° W t) N N o N N CD O M Z V N rMi F- O O O O O O O EM0 O W O c t, O m co O CN N c m NN ca C C � O t0 E C d N N N u 9 c U E d cr W o 2- U N 'g E 2 m W a) W t) N N a L 3 N N CD O M O Z rMi F- O O O O W O t, O m co r 0) N � LO f0 N N M M M M ¢ 00 00(f)0010N00 0 0 0 O O O O o N N m It o 0,r O M N O a 0 0 0 0 0o r CA L C N O 0 0 (O I- M Cl) M V O O O) O O) O M O IT M O N O M, M N W M I� N j O O) m N N N E c c o ° a m m > N y EQ C 0 C C c = a) a u a (i ~ T o (u a) a) Z a�i 0 c a m E U U U E° E) 21 Lu C E - —° — NU C >O W 0 m �C n E 'm � E o a¢ E a o c� O m a O) LL N LL0 p m a) a) a) c ° => N cc M m E a Q c c c m CD o U m ( J �d� ( 2 D o c o m c w n ( n CL n � ¢ m E � a) Z O o 0 0 0 0 0 0 0 0 0 0 0 0 0 M N 000000000 N to 0 0 o O f`) Y C co O O N 0 0 0 N M m O O -41 N co O V o` 03 r (f1 LO (() (O N N (O N N r- n N r r r LO m co O` O O U CV N CV ('M M A M A M N .- CV A V m w CD ¢ N M M M M m M M M m { �-- M M^ th M M Y C (6 CO (o CO CO CO CO CO CO r I to O (O CO (O O O p E N m v- ~ N O N t0 ca N 3 C -_ m N N N (f1 N O O 0 0 0 0 LL') CD N r O M co a0 O O O co a) IE5 a r r o (o eo m (D � o vi (ri v m E LO a ¢ 0 0 LL c E c E ° (D N C a) U CO 0 a) W N > a) m d v _E t( a E E c E c1°i aNi E _E E F¢ aZi F- m a� F- c I- c U H F" c U N U) m LL >> o Z ? - r o a) v li 0 v U- LL E U) c li a c c Z c E IL d m t d U ¢ 0 CD LL c ai (o in 0 co N ti in 2 (MD in (MO U (MD U) U) CL a E Z o 0 C M 0 0 O O 0 0 0 00 O M O M N 0 O O O O ° co O O O N O O O co 0 r, n O (n C L9 N N N U — — Q N N N M M PO') M M M M O co (O to (o (D (o (O to (D ,, L W C J O E o F_ LL 15 N J C U N Q 0 O N E LLH 3 N m tV U 0 °o O N O O r o O O _ t0 M R r W a) E i- J LL N N R U 0 0 O O N O O M N N c J 0 0 U a) N CO U C N � U Ln ro a0 to O M M O C N a) ° 0 � O U CL L O U v a E M a� J Q z m x aZ _J c Y I-J O O 0 U O U m N O r '2 Q Y C �p O N W 0 ~ M O M O N p) N N W t ya) {p J = m C a) j a m N � I N N N to O m E M M M M co 0 0 Q U C i O U- 0 O N E LLH 3 N m tV U 0 °o O N O O r o O O _ t0 M R r W a) E i- J LL N N R U 0 0 O O N O O M N N c J 0 0 U a) N CO U C N � U Ln ro a0 to O M M N O go M LO a0 N M a0 K N t0 n m J E f!1 Q U J C Q m W C N � C N aJ N `2 CJ N 00 C14 LO ID to co m M M C) Opp Cl r M co to N y o O C N a) ° E � O U N O U v O M O m x aZ E R O N O go M LO a0 N M a0 K N t0 n m J E f!1 Q U J C Q m W C N � C N aJ N `2 CJ N 00 C14 LO ID to co m M M C) Opp Cl r M co to N y o O C N a) ° E � O U N O U v W m x aZ E R j E CD v ` a) m m c � U 3 H H W t ya) U W N U U) m � N N N to Y O M M M M co 0 F- U C LL J � 7 N 2 N O O C N a N C U LL n n U Y co co F N (n J N J d c E LL m c iT a w E v a7 r O n LL r C U 0 O a p c M = O J U u. E J Z O O y C J Yj O O a) J O O n N L? U O r 0 Q n n F C M co N O go M LO a0 N M a0 K N t0 n m J E f!1 Q U J C Q m W C N � C N aJ N `2 CJ N 00 C14 LO ID to co m M M C) Opp Cl r M co to N y o C N a) c 0 E � O U O U v W m x aZ E R j E CD v ` a) L N N L W O� m c � U 3 u Z O O O O O O O O t ya) u y W N U U) C � N N N to Y O M M M M co 0 F- U C LL O m i W 7 v 2 O O C M N c LL n n � Y co co F O N N N h O M 00 co V N O � c°) E rn a) Z C N_ ) N E Q 0 w I `c 2 0 0 0 0 oo0LO N r 1— V CO M r r r r Y] N m N 7 M M M N O O N N 1O W N O N f.. 1� O1 N m a0 cc N cM- W aD O N !� y C O C N a) N E o O U v W m x aZ j E CD v ` a) L N N L W O� 9 c 3 O O O O O O O O t ya) O O a0 Cl) O W N 9 9 r n N N N to Y O M M M M co 0 F- ri a L W m 0 CL a- 04 0 0 Y � O p M O O Y C N 0 0 o O Q F N m O M 'o N 01 a O 0'.0 II C — m 'p0 CL 0 01 [6 0 O LL C 3 O a wc � U 00 00 00 00 Oo 00 00 00 N 10 Y t0 0 0 0 0 O N V C M O N 0 0 co 0 c0 N 000 C O M N N O N O T N N N co a to O O V M N M-li M N (`7 N (D C6 N O O N E M M N O O 0 LO M a N N M A I c0 w w W w w w w w 00 OtQ M W W LL pp Q LO M r N (0 0 0 (O m N O ry t0 N Lo N N c0 (D d' w M (O CO m N U N N N (mII cl m e M M N O N 0.- m E m U o d ° N m w o g U m N U .` C n a E G 0 (p 'D a) ) m�xat0i�'o �� °� M o a c CL F -wrw a w v v w om � 0(D C 3 O a wc � U 00 00 00 00 Oo 00 00 00 N 0 0 00 00 O O O O u7 N M N M N N N O V � �0 0 CD O O M M N O O 0 LO O co r N N M A I c0 w w W w w w w w 00 OtQ M W W pp d) LO M r N (0 0 0 (O m N O ry t0 N Lo N N c0 (D d' w M (O CO V1 N M , N N � 1 (0 M M' N cl c0 M M -- N N C � OtQ c m E m a c U 3 LL c p °� M a aci E E 10 c tq c m o Q 0 00 a E m m F°_' o LL U E H 41 E 'S v Q d) m ? y W LL U) E O (7 N N O W o CO N E O y O O 0 L T L_ O N U) (n N no O U O —° c °� c U E C c ro U) M N m c 2 Q U) ao C7 � O a° m cli m ao (l) m 00 D W 7 LL O V 000 G N 0 O O O O O O O p p CD O 00 O LA O O ce) 0 1 1 r N n Q — N N N N n V% co aD D w w W 00 ty y'1 co m w m Q a O N N O N ^O O O O O (D (O N 0 0 0 0 L C ��v� � orn(°D_o rno(D 0 I (O (D O O X O O O , 00 (7 1� m C O) ' a0 V N 0 W � °o °o 1 N N 1 N Y O m y O Y G O N 0 ~ M O m p) N O) � c- a1 � O] m 0 C CL CL Q 0 h O F O m O m 9 c N C a) LL N O) a) O LL E o F- U- c C U (� Q H 0 E LL O a) 2 is U) N E U tL6 LL a) N m c CD o E m o m N U n ° E N O O O � ° LL c m E u) > m 0. m a) ns 6 W U' m -i (n c m N E aS 0 C O O 9 m 3 a 3 a° c U) c .60E C) CL ar 0 w 'E E v� c9 i— 0 LU ° C ° N ° O N° O to N N � N m CO NN O) N w M C O W CO O) 3 N (D C co co V V M N O N E Q N C O C U ° O C Ql O R N (6 N y N c ~ 0 a) C O a) C h N > a 0 R E m m a n o m ° o c. c m o c 0 E c m c V ° 0 E �`- Q aNi .o .0 m tL N c ro m r (� 0 0 m 0 a a) 0 C Z a°' 0 E 0 i 0 0 C Z 0 O > LL E C O n 'c a U nc U) 0 R O N > z m t4 m a o S m E M c aa) 0 .E m a c QO oNO U) COL i� (n�z W �Q0 m C0 U"x a� a E Z o 00000 i1 0 0 0 0 0 0 0 0 0 0 0 c 0 0 0 0 0 o N O O O O O o o N o M n O %, O m N NO N m N O O M a0 O) (O n r N N co (D � r M r � O � 0 O co ( N Q N N N M M Co co O O O O O M M 0 0 0 0 0 O O O O a E °o °o °o °° 0° 0 0 0 0 0 ° 0 0 0 0 0 0 0 0 0 0 0 0 0 0 j N O 0 0 0 O M O O M M O NO N O) N U W N N (O I� 01 r r N — (D (NO (D m O N M M M M M 4 4 4 Q co co CO 0 0 M M M M O co O co O M M M Cl) 0) O co O O O ° C ° N ° O N° O to N N � N m CO NN O) N w M C O W CO O) 3 N (D C co co V V M N O N E Q N C O C U ° O C Ql O R N (6 N y N c ~ 0 a) C O a) C h N > a 0 R E m m a n o m ° o c. c m o c 0 E c m c V ° 0 E �`- Q aNi .o .0 m tL N c ro m r (� 0 0 m 0 a a) 0 C Z a°' 0 E 0 i 0 0 C Z 0 O > LL E C O n 'c a U nc U) 0 R O N > z m t4 m a o S m E M c aa) 0 .E m a c QO oNO U) COL i� (n�z W �Q0 m C0 U"x a� a E Z o 00000 i1 0 0 0 0 0 0 0 0 0 0 0 c 0 0 0 0 0 o N O O O O O o o N o M n O %, O m N NO N m N O O M a0 O) (O n r N N co (D � r M r � O � 0 O co ( N Q N N N M M Co co O O O O O M M 0 0 0 0 0 O O O O ,, L W C _ O B F- F- O) C _ EQ r. O r N N V Oi N r M N C C 41 E > N Q N E CEc N = E U �- (4 W 0 0 39 rn m vv 0c0 co M O N r r N O O N �- M 00 0 m <ro 0 N a 0 0) E Z E rn d C U :F. U t=/� a0 U) U 0 0 o o co � r M M Cl) M P r O O O m r C LO M (p 00 r O O N 1 < LO t- r L4 N N C E d U t9 O. N C N E a w W 0 0 0 rn M t0 N m m r r r r: N N 0 LO 0 0 V N Lri U ai M M r C E U lQ 0. N C N E a W 0 0 0 rn N Cl) O O N ui vi m co M (n E LL w c c C F- m 0 n CL Q 0 0) m h r 0 00 ` O M y O "O Y C O N 0 O F m O M G N 0) N f6 O N = C — m V N CL 0) OCj m ns 0 O LL C _ O B F- F- O) C _ EQ r. O r N N V Oi N r M N C C 41 E > N Q N E CEc N = E U �- (4 W 0 0 39 rn m vv 0c0 co M O N r r N O O N �- M 00 0 m <ro 0 N a 0 0) E Z E rn d C U :F. U t=/� a0 U) U 0 0 o o co � r M M Cl) M P r O O O m r C LO M (p 00 r O O N 1 < LO t- r L4 N N C E d U t9 O. N C N E a w W 0 0 0 rn M t0 N m m r r r r: N N 0 LO 0 0 V N Lri U ai M M r C E U lQ 0. N C N E a W 0 0 0 rn N Cl) O O N ui vi m co M (n C 0) E m OCj w G � — . O) C 0) fa Q1 II m (L C Qa m Eh O E u=. E E 3 c 0 E 0 w `—° a m — LL '9 w E C7 a E w a O c O LL. C7 a w �° 0 v r, c ro C7 2 0 ca � C M 0 9 m U C' 0 O LL C p LL d C N Ir E C O 0 0 0 E z d 7 00 Q 7 7 0 = LL. p a 00 = LL m co C O o y D) 0 E o W n r oM O Q 4) m *6 m m M V O M F W M F- F-