Press Alt + R to read the document text or Alt + P to download or print.
This document contains no pages.
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