RSS

Budget Worksheet

07 May

This assignment required that I take Crawfordsville District Public Library’s 2014 budget data and create a budget for 2015 allowing for a 10% increase in the operating budget.

JConrad Budget worksheet2

Account # Description Annual Appropriation 2014
1. Personnel Services
1.11 SALARY OF LIBRARIAN 69000 69000 1 Librarian (Director?)
1.12 SALARY OF ASSISTANTS 582500 582500 20 assistants making lowest salary range
1.13 WAGES OF JANITORS 9000 9000 These salaries seem reasonable for current economy.
1.41 FICA 59000 59000
1.42 PERF 40000 40000
1.43 HEALTH 72000 72000
1.44 UNEMPLOYMENT 6500 6500
Sub Total 838000 838000
2. Supplies
2.11 OFFICIAL RECORDS 500 500
2.12 STATIONERY, PRINT 500 500
2.13  OFFICE SUPPLIES 3000 3000
2.21 CLEANING SUPPLIES 5800 5800
2.31 REPAIR & MAINT. SUPPLIES 2500 2500
2.41 BOOK REPAIR SUPL 1000 1000
2.42  GENERAL LIB.SUPL 29005 29005
Sub Total 42305 42305
3. Other Services and Charges
3.11 PROFESSIONAL SERVICES 21500 71500 Services related to bldg improvement
3.12 PROCESSING 3000 3000
3.145  DATABASE 5000 5000
3.146 E-FORMATS 10000 10000
3.21 TELECOM 39000 39000
3.22 POSTAGE 3000 3000
3.23 TRAVEUMEETINGS 5000 5000
3.24 TRASH SERVICE 3000 3000
3.31 PUBLIC NOTICES 500 500
3.32 OTHER ADVERTISING 500 500
3.41 OFFICIAL BONDS 200 200
3.42 INSURANCE 36400 36400
3.51 ELECTRICITY 95000 98000
3.53 SEWERAGE 500 520
3.54 WATER 5000 5200
3.61 BUILDING MAINTENANCE 53450 53450
3.62 EQUIPMENT REPAIR 18150 18150
3.7 RENTALS 3000 3000
3.81 DUES 1800 1800
3.83  TRANS.TO LIRF 30512 30512
Sub Total 334512 387732
4.  Capital Outlays
4.1 BLDG IMPROVEMENT 4000 79000 Library was built in 2005.  Program attendance has steadily increased.  Probably need more space, if not structural repairs.
4.2 FURNITURE & EQUIPMENT 28000 41351 Additional furniture & equip related to bldg improvement.
4.31 BOOKS 111000 111000 Circ has dropped significantly over the last two years.  But circ per total items is severely out of balance in some portions of the collection.  Need to rebalance individual collection budgets and weed, weed, weed.
4.32 PERIODICALS 12000 8000 Magazine use is up slightly from 2014, but 12,000 items had 2,000 total circs. Transferred to databases and e-formats
4.33  DVD’S & CD’S 6000 13000 Adult media circulation far exceeds item numbers – 30,000 circs on 8,000 items.
4.34 MICROFILM 3000 0 Transferred to dvds and cds.
4.36 SOFTWARE 37183 38183
Sub Total 201183 290534
Grand Total 1416000 1558571
883.00 is 10% budget increase Sources:
unaccounted for http://www.in.gov/library/5410.htm
2014 Salaries.xls
Library Facilities and Construction Status.xls
http://www.cdpl.lib.in.us/about/statistics
1416000 1558571 CDPL/CMMC Programs Five Year Comparison: 2011-2015
x.075 x.075 CDPL/CMMC Program Attendance Five-Year Comparison: 2011-2015
106200 116893 CDPL Item Circulation 2014-2015 Comparisons
2015 CDPL Item Count and Circulation
132000 132000 2015 CDPL Combined Programs Attendance
currently Maintained but could cut here. CDPL Circulation – Yearly Comparisons.
allocating about Non-Sponsored Meeting Room Usage – Yearly Comparisons
10% to collections
Advertisements
 
Leave a comment

Posted by on May 7, 2017 in Uncategorized

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: