No preview available
HomeMy WebLinkAbout2012-09-17 - Agendas - FinalFAYETTEVILLE PUBLIC LIBRARY Suzanne Clark, President Elizabeth Jordan, Vice President Maylon Rice, Treasurer Board of Trustees September 17, 2012 4 pm AGENDA Special Meeting Ann Henry Board Room Kim Agee, Secretary Brenda Boudreaux We inspire imagination and foster learning. I. Call to order II. Library Growth and Space Requirements — page 2-3 111. Health Insurance Rate Increases — United Health Care — page 4-6 IV. Draft 2013 Budget — page 7-19 V. Gala Update VI. Adjournment Dan Ferritor Susan Graham FAYETTEVILLE PUBLIC LIBRARY Memo To: Board of Trustees, Fayetteville Public Library Through: David Johnson, Executive Director From: David Johnson, Executive Director Date: September 17, 2012 Re: Library Growth & Space Requirements Summary Observation Prior to February 2012 when I accepted the position as Executive Director, my experience with the Library for the past 10 years had been as a patron and volunteer. I watched as the shelves, which appeared about half filled on opening day, began to crowd with materials. I offered assistance to patrons in the computer lab that was sometimes full on Wednesday evenings. I attended programs in the Media/Magazine and Reading Room areas where the furniture had been moved to accommodate the large crowds. It wasn't until I was in the Library on a daily basis that I began to fully experience what I refer to as being "victims of our own success." We are currently adding shelf space in the teen area to accommodate more materials, the computer lab appears at capacity during long periods of the day, the meeting and study rooms frequently seem full, and all summer long we experienced programming attendance pressure on the Walker Room and the Youth Services area. Overall, these are all great problems to have. Our community uses its library. Background In 1998 The Library contracted with Meyer, Scherer & Rockcastle, LTD to conduct a citizen based, 20 year master plan for the library. Using a variety of data points and 36 public input sessions the "Final Master Plan for Library Service & Facilities: 1998 — 2020"determined the need for a 90,000 square foot facility. At that time, population projections for the City of Fayetteville indicated a future city population of 85,000 by the year 2020. Our earliest statistics show that as of 2001 approximately 45% of the city population was active card holders. More recent population projections by the Northwest Arkansas Regional Planning Commission indicate the city's population in 2020 to be 89,535 and to exceed 104,000 by 2030 and 112,000 by 2035. The current percent of active cardholders in the city is 88%. The Library is looking at a future active card holder population in the range of 78,790 by 2020 and increasing to 98,560 by 2035. 2 A 5 -Year Facility Assessment was conducted by Meyer, et.al., in December of 2009. The report was based on three constructs: correct deficiencies, enhance services, and changes to support the future. In assessing the space needs of the library, this study utilized, among other sources, current and projected population data. In a section titled, "Pressure of Success" it was noted that since the Blair Library's opening in 2004, the library has experienced a marked increase (60% gain) in circulation and a "flattened" program attendance number as result of inadequate room capacity. The program attendance constraints were emphasized this summer during our Summer Reading program where on nine separate occasions program attendance exceeded 250 (with a maximum number of 532) For six of those events the performer was paid twice for two separate performances in order to accommodate the numbers in attendance. On page 7, the 5 -Year Facility Assessment notes that "What cannot be tracked is the number of people who choose not to attend, nor the number of programs that were not held because of insufficient room capacity and choice." A similar "plateau" or "flattening" of the number of computer sessions and meeting room utilization could be attributed to there being a limited number of computers and meeting rooms available to the public. Recommendation In order for the Library to continue deliver the level of service the community has come to expect in the future, it is my recommendation that the Board approve or commission a team to assess the Library's Service Goals utilizing the new population projections, identify the physical implications of these goals, provide an evaluation of the existing facility, and develop a series of action plans for the library. Cost of Previous Space Needs Assessment 1998/99 Development study = $40,422 Site Plan, Floor Plan, and 2 site evaluations = $34,465 2007 Univ. of Arkansas Branch & Book Mailing Study = cost not available 2009 Updated Space Study = $7,624.52 ® Page 2 3 FAYETTEVILLE PUBLIC LIBRARY Memo To: Board of Trustees, Fayetteville Public Library Through: David Johnson, Executive Director From: David Johnson, Executive Director Date: September 17, 2012 Re: Health Insurance Rate Increases—United Healthcare Background In the four months for which United Healthcare has data (Jan -Apr 2012), the loss ratio is 114.39% meaning United Healthcare has paid out more in claims than it has received in premiums. Therefore, 2013 premiums are going up. The question then becomes how does the Library share the cost with the employees. How we currently compare — PPO premiums paid by small firms, city of Fayetteville, FPL Average small firm $ / %total City $ / % total Library $ / % total Single (full-time) $63.50 /18% $18.42 /7% $9.91 /4% Single (3/4 time) NA NA $68.57/ 27% Family (full-time) $412.17 /24% $93.18 /14% $70.66 / 10.6% Family (3/4 time) NA NA $214.36 / 32% The Increase • United Healthcare's initial increase for 2013 was 49.8%. Our broker got this reduced to 22.75% for traditional coverage and 24.74% for HSA coverage. • To further reduce the PPO increase, the city opted to: 4 o Increase the deductible from $500 to $1000 for individuals and from $1000 to $2000 for families. o Increase the out of pocket maximum for individuals from $2500 to $3000 and from $4000 to $6000 for families. • These two steps reduced the increase to 14.27% • To further reduce the HSA increase, the city negotiated to: o Remove the embedded deductible so that the deductible for individuals is $3000 and the deductible for families is $6000. For families, this means that all the family members' claims have to add up to $6000 before the co-insurance begins. (The out- of-pocket maximum remains at $4000 for an individual and $8000 for a family.) o Decrease the amount paid after meeting the deductible to 80% ® These two steps actually reduced the premium for single coverage by $3.61 and for family coverage by $9.57. PPACA As part of its planning for 2013, the library is also preparing for 2014 when provisions of the Patient Protection and Affordable Care Act take effect. Primarily, we have focused on three major factors: 1. FPL, with more than 50 FTEs is subject to certain requirements. 2. All employees working 30 hours per week or more must be offered insurance. 3. The insurance must be affordable defined as a premium that costs no more than 9.5% of an employee's W2 income. Using FPL's lowest paid eligible employee, that number is calculated to be $131.55/month. FPL's Proposed Insurance Rate Structure for 2013 distributes responsibility for the rate increase between the employee and FPL. You will note that the gap between rates for full time and 3/4 time employees is closed or almost closed. You will also note the differences between the city's plan and the library's plan. City $ / % total Library $ / % total Single (full-time) $33.68 /12% $33.68 /12% Single (3/4 time) NA $37.72/ 13% Family (full-time) $133.64/18% $131.55/18% Family (3/4 time) NA $131.55 / 18% The library will have to "find" approximately $26,000 in its budget to fund this tiered system. The tables on the following page reflect staff analysis under 3 options: 1. Approximate 2012 employee cost for 2013 and comply with affordability standards in PPACA; 2. Approximate 2012 FPL cost for 2013 and comply with affordability standards in PPACA; and, ® Page 2 5 3. Approximate city cost -share and comply with affordability requirements in PPACA. 2013 (91.00053.000 deductible) (52,000/$8,000 deductible without embedded deductible) Pppro»mate 2012 emplo ee cost for 2013 and mow toward affordlbllityslandards for 2014 Preliminary • Employee Employee Preliminary Cost/ Month City of Cost/Month Total HSA Employer before Fayetteville Affordability after Library Library Draft 2013 Coverage Premium/ Contribution/ Cost Afrodability Contribution Test for Affordability Cost/ Cost % Paid Library Plan Options Type • Participants Month Month Month Test Amounts 2014 - 9.5%. Test Month 'Annualized by FPL Budget PPO - Traditional _. 40 hour Single 9 281.40. 256.07 9.91- 33,68 131,55 9.91 271,49 29,321 9614 40 hour Family 9 .' 74570 630,12. 70.66 133.64. 131.55. 70.66 675.04 72904 91% 30 Mur Single 2 281.40 256.07 68,57 NA 131.55 68.57 212.83 5,108 76% 30 hour Family 1 745.70 630.12 214.36 NA 131.55 131.55 614.15 7,370 82% High Deductible 40 hour Single 7 150,07 70.80. 220.87 0.00. 8.28 131.55 0 220.87 18,553 100% 40 hour Family2 ••••397.67 166.66 554.33. 0,00- 21.80- 131.55 0 554.33 13,304 10014 30 hour Single 1 150.07 70.80. 220.87 60.26 NA 131.55 60.26. 160.61 1,927 73% 30 hour Family 1 397.67 156.66 554.33 152.87 NA 131.55 152.87 401.46 4,818 7214. Add probable expense exposure for employees who currently opt out based on PPO participation with family coverage. Nonparticipating 5 1 745.70 0.00 630.12 70.66 133.64 131.55 70.66 675.04 8,100 9114 Total 33 161,405 127,000 2013 (51.000/$3.000 deductible) (52000/56,000 deductible without embedded deductible) Ppprozmate 2012 FPL cost for2013 and complywith affordibility standard Employee Preliminary 2013 City of Cosi/Month Total HSA Employer Preliminary Fayeltedlle Affordability after Library Library Draft 2013 Coverage Premium/ Contnbulion/ Cost/ Employee Contdbut-on Test for Affordability Cost/ Cost % Paid Library Plan Options Type Participants Month Month Month Cost Amounts 2014-9514 Test Month Annualized by FPL Budget PPO - Traditional 40 hour Single 9 281.40 240.95 4045 33.68 131.55. 40,45 240.95 28,023 86sa 40 hour Family 9 ' 745.70 594.11 151.59 133.64 131.55 131.55 614.15 66,328 82% 30 hour Single 2 281.40 182.29 9911 NA 131.55 9911 182.29 4,375 6514' 30 hour family 1 745.70 450.41 29529 NA 131.55 131.55 614.15 7.370 82% High Deductible 40 hour Single 7 150.07 70.80. 220.87 0.00 8,28' 131.55 220.87 18,553 100% 40 hour Family 2 ' 397.67 156.58 554.33 0.00 21,80 131,55 - 554.33 13,304 100% 30 hour Single 1 150.07 70.80 164.22 56.65 NA 131.55 56.65 164.22 1,971 . 74% 30 hour Family 1 397.67 15666 411.03 143.30 NA 131.55 131.55 422.78 5,073 76% Add probable expense exposure for employees who curtenlly opt out based on PPO participation with family towrope. Nonparticipating 5 1 745.70 000 594.11 151.59 133.64 131.55 131.55 614.15 7,370 8214 Total 33 150.366 127,000 2013 (51,00053,000 deduclible) (5200056,000 deOuctble without embedded deductible) Ppprobmale cilycost-share and complywith allordibilityslandards Employee l Preliminary 2013 City Of COst/Month Total HSA Employer Preliminary Fayettedlle Affordability after Library library Draft 2013 Coverage Premium/ Contribution/ Cost/ Employee Contdbulion Test for Affordability Cost Cost % Paid Library Plan Options Type Participants Month Month Month Cost Amounts 2014 - 9.5% Test Month Annualized by FPL Budget PPO - Traditional 40 hour Single 9 281,40 240,95 40.45 33.68 131.55 33.68 247.72 26,754 88% 40 hour Family 9 ' 745.70 594.11 151.59 133.64 131.55 131.55 614.15 66,328 82% 30 hour Single 2 281.40 182.29 99.11 NA 131.55 37.72 243.68 5,848 87% 30 hour Family 1 745.70 450.41 295.29 NA 131.55 131.55 614.15 7,370 82% High Deductible 40 hour Single 7 150.07 70.80 220.87 0.00 8.28 131.55 0 220.87 18,553 100% 40 hour Family 2 ' 397.67 156.66 554.33 0.00 21.80 131.55 0 554.33 13,304 100% 30 hour Single 1 150.07 70.80 210.33 10.54 NA 131,55 10.54 210,33 2,524 95% 30 hour Family 1 397.67 156.66- 401.46 152.87 NA 131.55 131.55 422.78 5.073 76% Add probable expense exposure for employees tato currently opt out based On PPO participation with family towrope. Nonparticipating 5 1 745.70 0.00 594.11 151.59 133.64 131.55 131.55 614.15 7,370 82% Total 33 153,124 127,000 The 3rd option was selected because it more closely matches the city, complies with affordability standards in PPACA and does not add significant cost to FPL's budget. • Page 3 FAYE'I°I'EVILLE PUBLIC LIBRARY Memo To: Fayetteville Public Library Board of Trustees Through: David Johnson, Executive Director From: Stephen Davis, Accounting & HR Manager CC: Fayetteville Public Library Management Staff Date: 9/13/2012 Re: 2013 Preliminary Draft Budget Summary Fayetteville Public Library's (FPL) draft budget is attached for Board review. This draft is presented to initiate the discussion of services and funding for the 2013 budget year and has been prepared with Staff examining the services provided and the related funding required to provide those services. 2013 represents a transition year in at least four (4) areas: e Library services & overall programming e NEH humanities programming e Health insurance e Categorization of expenses This memo includes a discussion of the FPL's funding sources and discussion of each of the major classifications of expenditures for 2013. The 2013 budget has a more structured cost center approach than has been used by FPL in prior reporting periods. Because of this change in cost center approach, comparative expenditure data from 2011 and 2012 to 2013 may present more need for explanations than would be expected in future years. 7 Funding Sources Fayetteville Public Library's funding sources primarily fall into three (3) areas: transfers, state aid to public libraries, and fines & fees. Additional funding is derived from grants, space rental and copier income. Total predicted funding for the FPL for 2013 is $3,863,000. Of this amount $3,221,000 can be used for any purpose. The remaining funding is generally related to specific programs or purposes. Additionally, the FPL has an operating investment account and four (4) restricted investment accounts that can be accessed if needed. The four restricted investment accounts are: Long Term, Facilities, Furniture & Equipment and Technology Replacements. The following table provides the principal balance in each restricted investment account as of July 31, 2012. Investment Account Description Balance at 7/31/12 Long Term $908,957 Facilities $535,250 Furniture & Equipment $237,459 Technology Replacements $406,828 Investment eaming for each of these restricted accounts is reinvested into the account so that each account can better keep pace with replacement cost and/or inflation. Combined, these restricted accounts are predicted to generate $43,091 for calendar 2012. Because these investment accounts are restricted to specific purposes, investment earnings are not included as a revenue source for the Library's operating budget. The 2013 budget proposal does ask that the Board consider using $30,000 of the Fumiture & Equipment account to fund planned furniture replacements and $13,000 of the Technology Replacements account to fund planned IT replacements. Funding for humanities is included in the 2013 budget even though no revenue from the NEH Endowment is included in the revenue sources. Once all of the NEH pledges are collected it is predicted that this Endowment will generate approximately $70,000 on an annual basis for humanities programming. This budget contains approximately $25,000 in humanities e resources that could be funded by the Endowment. Library Services & Overall Programming Total library services for 2013 are $720,970 or an increase of $98,000 over 2012. $57,000 of this increase is due to additional funding for materials and increased cost for e resource data bases popular with FPL patrons. The increase in material purchases is funded primarily by the increase in book transfer from the City of Fayetteville. In past years, FPL funded some significant e resource databases from year-end money and the cost was not reflected in an operating budget. Because year-end leftover money is not predicable, Staff is including the full cost of the e resource databases in the operating budget to be more transparent on the cost of operating the Library. Staff expects to submit grant applications to various funding agencies to obtain supplemental funding for some of these e resources. This budget does not recognize any potential funding from these grant applications. • Page 2 8 As mentioned above, this budget proposal contains funding that meets the requirements of the NEH Endowment. Health Insurance FPL's 2013 budget contains an additional $26,100 to fund health insurance premiums for staff. This additional cost is due primarily to overall health insurance claims exceeding premium dollars and secondarily to the impact of PPACA (Patient Protection and Affordable Care Act). United Healthcare computed actual claims compared to premium dollar revenue and developed an overall calculated premium increase for health care insurance of 49%±. Gallagher initiated negotiations with United Healthcare to reduce the overall increase to 14%. After negotiations concluded, the benefits offered were changed to increase employee cost participation in the form of higher deductibles, out-of-pocket increases and premium increases. The next cost driver (PPACA) caused FPL to change the cost sharing of health insurance premiums between the FPL and FPL employees. Under PPACA employers can be penalized if the employee health insurance cost exceeds an affordability standard of no -more -than 9.5% of household income. The IRS has issued preliminary guidance that this affordability standard is linked to the employee's W-2 eaming, not household income. Because FPL has a number of 30 hour employees the affordability test is based on the lowest paid 30 hour employee. Based on this test, the maximum FPL can assess an employee for health insurance coverage is approximately $132/month. Currently, in 2012, 30 hour employees pay $214.36/month for family coverage. This proposed budget addresses the change in cost sharing between FPL and FPL employees. The combination of the two (2) elements listed above result in a cost increase for 2013 of $26,100. Health insurance for 2014 and beyond cannot be reasonably predicted at this time because the healthcare exchanges have not yet been established. Conclusion This proposed budget is submitted for Board consideration and discussion. FPL's budget does not have to be adopted until December so there is time for discussion. 0 Page 3 9 0 o 0 0 0 0 0 O y 04 m ( m OI C_ 0 J Eam a) m a _ m N .+ NO G • U J C N N• C Q y X a re W m Da a E N 0) 00 O J 01 Q 0 44 y c E 0 in tr▪ iv C N N • T a w coC C • m Q N m N Operating Revenue 4000.00 • Revenue & Support 4300.00 • State & Federal Revenues O O 0 m O N CS 0 0 0 co CO 0) 0) M m N oi 4302.00 - State Grant co 01 CO 4306.00 • State Aid to Public Libraries 0 0 0 0 0 0 0 0 O O O O O N` oi O O co M 01 N V N m O O N. N. 0 0 0 0 0 0 0 CO 0 O 0 M h 0 M 0 0 0 0 0 O O O cc oo O M tri. '0 co CO 0 0 O m 0 0 0 N O O O (0 M 1.6 O Total 4300.00 • State & Federal Revenues 4400.00 - Grants & Program Fees 4400.20 - Not for Profit Center 4400.40 - Summer Reading Grant 4400.46 - P&G Reading Road Show 4400.00 - Grants & Program Fees - Other O 0 0 0 0 0 0 0 0 0 0 O W O 0) 0 N 0 N N 0 CO tO 0 N 0 (0 O V 0) O V 0 W N O N 0 N Y' r 0 0) 0) 0 0 (0 W N k r 0 Y) Y) N. 0 0 ▪ o n O m N (0 to Total 4400.00 • Grants & Program Fees 10 0 0 0 0 0 d0 ON CV N N (O N 4501.00 • Cafe Rental 4501.02 • Meeting Room Receipts 4501.05 • Copier and Printer income 4520.00 • Merchandise Sales 0 0 0 0 0 0 0 0 0)LO (0 C CO 0 0 0 0 N N 0 (0 O (0 0) (0 a 0 (0 co W co co N V CO. LO 0 03 0 0 (0 0 NO N CO O 0 C Total 4500.00 • Rental, Copier & Merchan 4600.00 • Fine & Fees Library Cards N 0 d 0 0 Lost and Paid Damaged and Paid Refund of Lost & Paid Fine & Fees - Other O O O) O O O O) O O O O O O O O O 0 0 0 O ? V Y V V '1 0 0 (0 O V (0 tO Total 4600.00 • Fine & Fees ,nts and Settings\sdaniel\Local Settings\Temporary Internet Files' --ntent.Outlook\OTQDS9YS\2013_Base Budget_Staff Review_Sept "' xlsx 1 U 0 0 0 o M 0 0 O o oo a 0 N a NO 0 of c C ❑ G NC C a) C 0 X d O. m 0 a • E N CD 0 0 Q O 17) E N 0 in O C N y, • 0. y x W N C d Q r CO N v c O 00 00 0 0 O M v0t r 0 v 0' n v rn m IC r 0) 0 O co M co CO .- Y) (() N Dividends on Miliage monies o O 0 M M N 4701.01 • Interest-miliage a) E 0 0 O C E G ' •• C0 C 0 O C N 0) ' m y LL C a v a Q O 0 N 0ir; p a d U) N • 0 J OP N o o ✓ .44 0 (0 Total Interest 0 0 0 O 00 0 0 0 00 100 0 0 0 0 O 0 O O O N co 0 m a En o o M 0 M w (0O (- co M V co O M 0 M r CO ( N 0 M r N O 0) 090 (0 c') 8 LO co In rn rn co o O rn 0) co N d N O rn (o N M r N 4770.00 • Realized Gain/Loss Investments 4770.01 • Unrealized Gain/Loss On Invest. O I co N N M M 4770.99 • Garrison Management fees 4770.01 • Unrealized Gain/Loss On Invest. - Other 11 Total 4770.00 • Realized/Unrealized Gain/Loss On Invest. 4820.00 • Designated Gifts 4820.20 • Adult Designated gifts O O Ogr 00 N O N n M Total 4820.00 • Designated Gifts 4881.00 • Gain/Loss on sale of assets 4990.00 • Miscellaneous Income 0 0 0 0 0 O • 0 9os C C y O 0 O N 0 0 0 0 co o rn o Cc40 0 v O V O M Total Other Revenue 0 O O (0 O N ce▪ r N M Total 4000.00 • Revenue & Support N N N N 0. v v cc u NI N a) ao -0 0 a) EnCOm m 0 0 N T O▪ ) 0 0 1- 0 0 0 0 0 0 a) v c O En v a) a) lD Q En On ra a) CO EnOD y a) to c a) O 'o N w A s ccu 0 N E Q y K O. w 0 SE.N 0) 0 0 O N 0 ?` M v c r N N L. L O o w o .0 N = 0 N T J 0 w = V 0 N x w = MC O 3 3 N To d CO ..3v N m C 0 Y G !. 0 l6 a— u. 0. u.a 2 V- o 0 m 0 0 to 0 a W Personnel Services 5100.00 • Personnel Services N d' 0 0 04 N O O co O N- 0) N t00 M <00 N 0 M V r t0 r <0 0 N N r N d' m V 0 N. COrm 0) 0 O CO N M (0 N N 40 . N <O O 0 r O O r- N 0) V t0 N r N V <0 t0 t0 0 0 <0 0 0 0 <O Nom O N N CO 00) r r O V W t9r N O N N r N in N r V 0) 0 O co 0 r 0 M V N 0 N O) M M d 0 ' <O V' oi CO 0 (O N N V N CO W N N N W V V CO 01 0 N N- CO N V V 1.0 C O O r O Cr). O0 N CO M <h M 6 N O <0 0 0 of CO d' 0 N M Administration Adult Services Tech Services Youth Services Circulation N 0 .:12 N 3 0 N co LI- CO Post Employment Disbursement Vacation Time Used Sick Time Used 0 0 0 0 0 0 0 o o w N M V <c r N. 00 0 0) O O O O O O O O O O O O O O O O O O co co (4) N N N tD in N N U) (4) 12 0 0 0 0 0 0 0 N O O O O co O N O M m N V O M M V m 0 o O co 0 co C V co CO M co CO CO 0 N M V M O O O O o O 00 '4 O O O 0 N 1 to r isi M N W N to 0 V M r r r r N 0o r ci <0 0 0 o OI 0 0 0 0 0 0 LO 0 0 0 0 0) 00 0) CO CO CO N CO 0 r 0 N CO' r N M N M N co co co O 0 N M <<0 N CO0co O (0 CO 4) r M N r M 10 r N r O t0 v 0 0 0 0 0 0 a o 0 M O r M 0 Total 5100.01 Salaries & Wages 5101.00 - Salary Contingency 5102.00 - Extra Services/ Work Study 5102.01 • Payments to UA for Work Study 5102.30 • Contract Labor Expenses 5102.50 • Contract Cleaning Service Total 5102.00 Extra Services/ Work Study 5105.00 - Employee Benefit Expenses 5105.10 • Health & Dental Insurance 5105.11 • Health Savings Account Expense Additional Funding 5105.30 • Voluntary AD & D 5105.40 - Long Term Disability 5105.50 - Life Insurance stent.Outlook\OTQDS9YS\2013_Base Budget_Staff Review_Sept xlsx 3 nts and Settings\sdaniel\Local Settings\Temporary Internet File 0 0 0 ri oN U d0 T- -▪ 13 G .r.. a) CO L LL Gs M O y 01 CO r. Ca tpj CO O = E • 0) m -I, Q3 3 a v _ y '. 00co 0 C N v c c o•c W N N N Q N X a. DC W • ra a • E ni O 0 o N N Q o o 0 0 0 0 0 LO 0) r CO 0 0 O O 3 0 O R ` r co 0 CO 0 d 0 0 O r 0 r M N 0 N C- O o O co oo O O (0 (N r O 5105.80 Retirement Contributions 5105.81 - Retirement Plan Expenses 5105.90 . Workers Compensation O 0 0 0 0 0 w o) ro N co a 05 6 r 0 M ((7 N co in M N W r co V W N CO 04OD N IC ai r C W OciN 00 N LO 0 CD CO 0)o CD O N t N to N In w 0) op r Cir O V co co o m W N O O O O 'it in 6 M 0) M 0 pN M Total 5105.00 • Employee Benefit Expenses 5150.00 • Payroll Related Taxes 5150.10 • FICA/Medicare Expense 5150.30 - Unemployment Insurance Expense Total 5150.00 • Payroll Related Taxes N Total 5100.00 • Personnel Services Library Services & Programming Library Programming & Processing Supplies 13 0 0 0 0 0 O 0 0 O N N O (O CO O (D CO (0 (0 Or N M O) O c o ca O Vco d d M N M U) 0) i0 O 0) N W 00 O 0 0 0 M d' 0 O N- o 0 6 r 1. 5201.20 • Adult Programming 5201.40 • Youth Programs N a N 05 w `w s 2 a O 0. • fn N 'o m .c 00 0 a 0) 0. .c } • h } a- N O d' d• -. 0 0 0 N N 04 (i) N N 0 N 0 d M r 0 0 r (0 N N- 9 0 O co coN d )O 0) 0 N 0 CO 0! 0 0 d' O 0 0 tlI d CO 0 0) 0 N M 0 N N (NO indr N 0 CO N r 0710 N V O N N O o O O N N (m0 N d000 ' 0, m 0 VO' N N 0) r N 0 r 04 dN' 0) N (0O N 04 O OMN ( N N If) to to cz, d' (0 Total 5201.40 - Youth Programs 5202.30 - Processing Supplies Total Library Programming & Processing Supplies 5220.00 - On-line Databases 5224.00 • Circulating Equipment 5225.00 • Library Materials Total Library Materials, Databases, Circulating Equipment X X N H 0• . .) N ' v N Inc (O N +. 0 0 CO 01 0 O N N >- m 0 a 0 0 0 0 27.O O c 0) 0 0 0 0) v C O) Y c T (0 O O. E N tw N N O N tO N a m AA a C N 0 a o .- 0n 0b O E 0 w 0 m} c `o 0 0• U M - N CO 111 M M OI C y 'O E v m' = o M Ct. v r.4200• 0 0 O G C N d C > a m % 0 0 0 O 0 0 o g) to 0 N 0 N N 0 N o o 0 0 0 0 CO 0) N N O O] M O N V V OO CO d CO 13- 01 r O O M N N U) 0 r CO 0 0 0 0 M N 0 0 O L N N O N O In p D N M E N M j v N cn▪ o • c E o o C • N j N N 3 G U 3 C SE U N N N a 0 N a lY w O 3 C N <• •0 N • m N Administrative costs 5200.01 • Office & Cleaning Supplies O 0 V 0 0 0 0 0 V O 0 0 V M O O ti co M N N 01 N- V CO N` co V 0 W COOM1 N r N N (o 10 O O co d' co W M - N O 1.5 a- (O V M (o (0 V (0 (O N M (o N V o (O 0 0 N 0 N 5200.10 • Administration Supplies Marketing & Community Relations Supplies for FPL Foundation Office Supplies - Youth Service 0 0 0 0 • W Office Supplies - Cir .�- °° a to a 0 0 0 0 0' N N N N N N N0 Nn (0 In LO X VI N c-1 O. (1) ri)I V (0 0 o 0 0 0 in 0 0 0 0 0 0 0 0 0 V o to O o o O o 0 0 0 0 0 O o > r O N 0 O O o o co o V V co O N 0) rR r M O m Nr O N V r r M N NV N ce N 0) 4-/ (0 IDA 0 M N S)E▪ N0 0 0 N (n 0 M CO 0 0 V CO O CO M 0 0 M r N` M N 0 n tO r 04 N- r V CO N (0 N M 0 N 00 CO r M O) (n V W O a- V W o) M (o N co N Vil (9 a3 I no ra 0 N N CO (O r 0 N 0 O CO 0 0) N V V CO (--4 N 'C CO CO N (O 0 0 N 0 N N N 0) V ----- et V r P- 01 M N 0 (0 CO (n (n S. 0) N- 0) (1) W co' Qi N N M O V N 0) N 01 V) 0 Cf 0 M CO M (V O W CO 0 0 C1' (0 r O) CO ti CO V 0 (n V 0 0 0 V V N 0 N 0 N N V CO 0) N r d' 0 N 0) 0 O , N Q7 M N V 0) N N` W 0) O V (4 (o ' O 0 c 01 4-) 0 0 0 0 0 0 0 0 0 0 0 0 C ti 0 0 o 0 0 0 0 0 0 0 0 O N 0 M 0 (0 0 10 O 0 W 0 0) v M NV'O O W t` M N M co 0 M ( (0 r coN y) n N CD II itaN C L. 4) 0 Total 5200.01 Office & Cleaning Supplies Public Notification Marketing & Public Relations >ense (0 co 0 Q E N 00 C i - N V) (0 U 0 N C m a N C f E m q w 0) a` E rn rn w 1 0.▪ 0._ a w . O • O, O N 3 v 0 C N 3 O N a w o E C -1 O 2 M(4.) m o Mc o c O o o O o 0 o O o 0 0.' O O O O O O O O co co > O N N c ▪ N co I(1 O yy N(yyi•• 0) O O N r O 1V M M M M M M M M M M M M O M 4IA .) h (0 N N UI N Nn N N (n N N 1- N 0 0) E u 0 0 0 Jar 310 15 N a o a (0 0 O 0 - N 0 7 C U C O N N Q y M C K W 0 d • E o 0 N Q CI 0 E 0 N 00 C T • " w 0 < N 0 N o o 0 0 O W O o 0 o N sr - m o o o o 0 0 0 5310.12 Electricity tri 5310.14 • Municipal Water 5310.00 Utilities - Other o N CO O 04 N 0 co Total 5310.00 • Utilities o ro O N 04 (0 00 m 0 Ln O O O 0 o o O o eri o; 0 0 O N 0 0 0 � O co o m Si. L O o a` O 0U m L_ > L 0 o O• tri N (0to co O m N 0 N Total Training 5400.00 Maintenance 5401.00 Building & Grounds 0 0 0 N (0 N V V N M N 1 co co O a o co (0 CO 0) V 04 CO 04 O m o O o o o N O O V N N 5401.01 Building Maintenance 16 O 0 0 L C m m L C O 0 C 0 • 2 0 0. 0 O E N Q. L c J 0 o o CO to▪ N O O O N CO 0 m 0) 0 m Total 5401.00 Building & Grounds 0 V M co 0 CO N o O 5430.00 • Office Machine Maintenance M O 0 M co 0 O o o 0 0 O O 0 O l() O O O O N M O O V 0 O V V o rm of N 04 O 0 V 0 N V 0) V N O 0 6 2.v."") o p 0 0 "(Cr 00 o (4' 0 N ` 1.0 O N Total Software, Computer & Office Machine Maintenance Total Administrative Costs 0 m O Q a a) x � Q o 0 0 0 0 O O o1() o o 06 00 CO YCO ) ▪ N R a+ Q R V Building Improvements Furniture & Equipment (sm. $) Furniture & Equipment M N O Capital & Depreciation Total 5800.00 C:\Docs ants and Settings\sdaniel\Local Settings\Temporary Internet Files`"-'ntent.Outlook\OTQDS9YS\2013_Base Budget_Staff Review_Sept xlsx 7 f+8 L C4 J � U 0 • ▪ N $ O Z CO W fai- 9 C co 2 VO G sAa) •— >, CO a- u- a D N U ❑ ▪ C C • 00 C > 0. a G ce w 0 • a • E (" j 0 N 0 CO cO 7650.02 Transfer to Friends Total Expense (3,534,771) (1,869,528) (1,523,628) (3,393,156) Net Operating Revenue Inter -Agency Transfers/ Other Expense Inter -Agency Transfers 0 0 N W M N H H O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 M N r M n (D N CO 0 0) CO 0 0) 0 O N 0 O O 0) M N dO \ A N CO N m N 0 0 0 N M 0 O (NO r M N (0 Co 0 0 0 0 0 O O v o n (°4 N- 0) N 0 m (0 N COCOW CO00) 0 O N 0 O 0 m V M N O LtaN M N 0 0. 0 Transfer For Books Transfer from City CIP Transfer from FPL Foundation 0 0 0 0 0 Cl N N N O O O O O 0) CO (0 (O CO (O O CO O CO (0 6650.02 • Transfer from Friends 17 Total Inter -Agency Transfers/ Other Expense 00 0) N c 00 00 Surplus or (Use of Reserves) 00 X N H 0. N �I N N K N 0) 01 00 00 m a) 00 M O N N >- 0') 0 0 ci 0 0 0 0 O 0 0) 0 0 U 0) Q1 N 0 N a-+ 0 N L 0 Q E 0) N 00 A-� f0 N a h0 N N M O N M m 0 CO O) C _ o t E p Ol = 3m a _ N d 0 p • G C y y o O a N 0X a Q K w (315,298) Balance to Find 00 00 00 00 00 00 00 00 00 CO 00 CImCl<710,0101C)C) N N N N N N N N N N N O o ch oo roo M an o 0 00 Ln N 0 00 (0 N M N to M N N N N a-1 a-1 .-1 r-1 o o 0 0 0 0 0 0 0 0 0 O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ui O tD M' m .-i 01 Vi V Oi a M M M <-1 N N N r. H • `m m a 5 5 0 04 E Q d w O Is. J 0. C LL N E -O+0 0 N0 o -0 0el 0 C c D m 0) CO 0 0. ' c $ 0 T WC 0) O o � Ti; E L- C • d c • m E C 0) O Q LL N 0 o m a ` v N r 0) C 0 0 w O O E 0" E C' _ E E w R $ a0 C E o c 0 ,`o C o o LL0. 0' N a 0 a 11- c o 0 LL C c 3 3 0 w LL O O aO 0 To' TO N O O 9 O"ESV a a 04 a m 0.N m '6 0 E a a 0 a N O 0 0 u O m m 1 m Of Q C C Z t 73 y 'm 'R .0 'm a C a .c a a 0 m O O Q O K V Budget Shortfall Options to Balance Budget: 0 0 al of C 7 O a tn 0) 9 O 0 a N C O 0 X 0 o .a urs" subsc Reduce Volunteer Expenditures Reduce Program Supplies/Performances Reduce Admin Salary due to reorganization Recognize WalMart/Sams Grant for Brainfuze Database 18 Request COF assist in funding health insurance increase x 0 C:\Docur ,nts and Settings\sdaniel\Local Settings\Temporary Internet Files,tent.Outlook\OTQDS9YS\2013_Base Budget_Staff Review_Sept Fayetteville Public Library 2013 Budget Volunteer Valuation based on Actual 2011 Year Task 2011 7UP 2011 AV Shelving 2011 Book Repair 2011 Books for Borrowing 2011 Calling Patron Holds 2011 Cash Counter 2011 Children's Assistant 2011 Click Stitch 2011 Community Service 2011 Computer Lab Monitor 2011 Covering & Processing Materials 2011 Development Office Assistant 2011 Disc Repair 2011 Facilities 2011 FHS Service Learning 2011 Filing 2011 Friends Bookstore 2011 Gardening 2011 Genealogy Assistant 2011 Greeter 2011 Inter Library Loans 2011 Intern 2011 Lending Hands 2011 Letter of the Week 2011 Patrol 2011 Program Host 2011.. Pulling Damaged Discs 2011 Pulling Patron Holds 2011 Reading Roadshow 2011 Sit, Stay, Read! 2011 Speaker or Performer 2011 Special Event/Project - Adult 2011 Special Event/Project - Youth 2011 Teen Advisory Board 2011 Tour Guide - Adult 2011 Tour Guide - Youth Services 2011 Young Adult Assistant Total 435.37 8.50 3,700.62 255.47. 8.00 2,043.73 561.55 11.00 6,177.05 6.33 11.08 70.17 100.10. 8.50 850.85 211.95 15.60 3,306.42 455.77 14.15 6,449.10 1.02 14.15 14.39 149.52 9.12 1,363.59 136.83. 14.15 1,936.19 386.07 11.08 4,277.62 79.37 15.60 1,238.12 929.93 11.08 10,303.66 436.53 9.12 3,981.18 65.88 14.15 932.25 76.37 15.60 1,191.32 3,055.25 10.56 32,263.44 53.77 9.12 490.35 750.95 14.85 11,151.61 174.55 10.56 1,843.25 173.08 15.60 2,700.10 52.07 14.15 736.74 181.50 14.85 2,695.28 317.87 14.15 4,497.81 526.50 10.56 5,559.84 11.32 14.85 168.05 82.17 10.56 867.68 606.92 14.50 8,800.29 193.65 14.15 2,740.15 233.35 14.15 3,301.90 7.68 14.15 108.72 194.50 14.15 2,752.18 207.32 14.15 2,933.53 31.13 8.50 264.63 1.00 14.85 14.85 42.17 14.15 596.66 171.08 14.15 2,420.83 11,355.87 134,744.15 Benefits & Employer Match 25% 33,686.04 168,430.19 19