Spreadsheet: 069b94d7-0e5a-4337-a029-012e9d0783b4
Sheet: Sheet1

Birmingham Library Fund  Budget for FY2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
January Report
 | Revenue Category | FY2009 Actual | FY2010 Budget | July Actual | August Actual | September Actual | October Actual | November Actual | December Actual | January Actual | February Actual | March Actual | April Actual | May Actual | June Actual | Year To Date | Percent of Budget
 | Sales of Goods and Services | 194431 | 203344 | 16945 | 7508.69 | 11755.97 | 19051.57 | 3250.9 | 20332.06 | 13351.91 |  |  |  |  |  | 92196.1 | 0.4533996577228736
 | Gifts and Donations (non grant) | 48744 |  | 3584 | 25 | 331 | 5461.88 | 1837.17 | 1469.53 | 6461.4 |  |  |  |  |  | 19169.98 | 0
 | Community Development | 21599 | 13564 | 9264 |  |  |  | 4300 |  |  |  |  |  |  |  | 13564 | 1
 | Grants from Non Governmental Sources | 97629 | 11275 |  |  | 4000 |  |  | 7275 | 800 |  |  |  |  |  | 12075 | 1.070953436807095
 | Grants from Governmental Entities (LSTA, AHF, etc.) | 59950 | 20430 |  |  |  |  | 20430 |  |  |  |  |  |  |  | 20430 | 1
 | State Aid to Public Libraries | 199465 | 176408 |  | 45761.24 |  |  |  |  | 41992.26 |  |  |  |  |  | 87753.5 | 0.4974462609405469
 | Other income from State | 48910 | 1000 |  |  |  | 1000 |  |  | 1000 |  |  |  |  |  | 2000 | 2
 | Reimbursements/Payments from City and JCLC | 38087 | 35000 | 16880 |  |  |  | 16250 |  |  |  |  |  |  |  | 33130 | 0.9465714285714286
 | Circulation Fees and Services | 66742 | 65000 | 4823 | 3160.62 | 4287.89 | 4187.47 | 3289.63 | 5588.81 | 5281.08 |  |  |  |  |  | 30618.5 | 0.4710538461538462
 | Out of County Library Card Fees |  |  |  |  |  | 250 | 100 | 350 | 550 |  |  |  |  |  | 1250 | 0
 | Meeting Room Charges | 19185 | 19000 | 1790 | 1125 | 1900 | 1885 | 1040.35 | 2057.5 | 2345 |  |  |  |  |  | 12142.85 | 0.6390973684210527
 | E-Rate Reimbursement | 190120 | 160000 |  |  |  |  |  | 28721.22 |  |  |  |  |  |  | 28721.22 | 0.179507625
 | Bank Account Interest | 7427 | 1663 | 139 | 130.84 |  | 130 | 135.32 | 134.23 |  |  |  |  |  |  | 669.3900000000001 | 0.4025195429945881
 | Book sales | 35539 | 32187 | 2926 | 2789.75 | 5423.44 | 2725.8 | 2858.65 | 2819.45 | 2268.97 |  |  |  |  |  | 21812.06 | 0.6776667598719981
 | Total: | 1027828 | 738871 | 56351 | 60501.14 | 27698.3 | 34691.72 | 53492.02 | 68747.79999999999 | 74050.62000000001 | 0 | 0 | 0 | 0 | 0 | 375532.6 | 0.508251914068897
 |  | 46058
Expense Category | Account Name | FY2009 Actual | FY2010 Budget | July Actual | August Actual | September Actual | October Actual | November Actual | December Actual | January Actual | February Actual | March Actual | April Actual | May Actual | June Actual | Year To Date | Percent of Budget
Personnel Services
 | Personnel | 37475 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 37475 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Repairs & Maintenance
 | [NAME] | 6130.29 | 5000 | 1332 | 2001.59 | 122.69 | 444.14 | 76.76 |  |  |  |  |  |  |  | 3977.18 | 0.795436
 | Electrical Supplies *** | 2982.22 |  |  |  |  | 416.36 |  | 6.97 |  |  |  |  |  |  | 423.33 | 0
 | Horticulture |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Buildings and Facilities *** | 189.619.77 | 50000 | 10229 | 1476.45 | 6753.5 | 4382.5 | 6207.7 | 8575.02 | 556.95 |  |  |  |  |  | 38181.12 | 0.7636223999999999
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Janitorial Services | 744.16 | 1747 | 146 |  |  |  |  |  |  |  |  |  |  |  | 146 | 0.0835718374356039
 | Office Equipment Repairs | 11611.67 | 8104 | 675 |  | 3057 |  | 3556.98 | 90.51 | 561.94 |  |  |  |  |  | 7941.43 | 0.9799395360315893
 |  | 21468.34 | 64851 | 12382 | 3478.04 | 9933.189999999999 | 5243 | 9841.44 | 8672.5 | 1118.89 | 0 | 0 | 0 | 0 | 0 | 50669.06 | 0.781315014417665
Fleet Expense
 | Automotive Expense | 28646.3 | 30000 | 210 | 2081.72 | 2272.36 | 1377.55 |  |  | 3068.16 |  |  |  |  |  | 9009.79 | 0.3003263333333334
 | Gasoline | 85 | 250 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 28731.3 | 30250 | 210 | 2081.72 | 2272.36 | 1377.55 | 0 | 0 | 3068.16 | 0 | 0 | 0 | 0 | 0 | 9009.79 | 0.2978442975206612
Supplies
 | Small Equipment | 12260.14 | 5000 | 986 | 887.05 | 4232.63 | 943.19 | 356.62 | 5555.56 | 828.57 |  |  |  |  |  | 13789.62 | 2.757924
 | Copier Supplies and [NAME] | 8004.98 | 9550 | 796 | 776.48 | 1150.09 | 716.18 | 836.79 | 551.68 | 742.8100000000001 |  |  |  |  |  | 5570.03 | 0.5832492146596858
 | Photography Expenses | 5335.12 | 5000 | 1004 | 828.97 | 190 | 600 | 16.6 | 49.35 | 706.5 |  |  |  |  |  | 3395.42 | 0.679084
 | General Office Supplies | 80363.59 | 60000 | 5791 | 2023.38 | 3084.48 | 2233.4 | 4782.93 | 13099.75 | 5168.82 |  |  |  |  |  | 36183.76 | 0.6030626666666667
 | Computer Supplies | 20759.81 | 15000 |  |  | 1690.95 | 198.99 | 4895.22 | 95.97 | 188.39 |  |  |  |  |  | 7069.52 | 0.4713013333333333
 | Clothing | 3447.46 | 500 | 96 | 3710 |  |  | 37.9 |  |  |  |  |  |  |  | 3843.9 | 7.6878
 | Animal Feed |  |  |  |  |  |  | 16.62 | 8.99 |  |  |  |  |  |  | 25.61 | 0
 | Food for Programs |  | 12500 | 2459 | 1554.99 |  |  | 5492.39 | 809.58 | 1526.03 |  |  |  |  |  | 11841.99 | 0.9473592000000002
 | Food for Meetings |  |  |  |  |  |  | 720.54 | 390.12 | 2599.46 |  |  |  |  |  | 3710.12 | 0
 | Supplies for Programs |  |  |  |  |  |  |  |  | 2137.94 |  |  |  |  |  | 2137.94 | 0
 | Supplies for Meetings |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | [NAME], formerly books | 29923.59 | 30000 | 4445 | 2770.16 | 2698.46 | 3195.44 | 1840.52 | 3451 | 523.7 |  |  |  |  |  | 18924.28 | 0.6308093333333334
 |  | 160094.69 | 137550 | 15577 | 12551.03 | 13046.61 | 7887.200000000001 | 18996.13 | 24012 | 14422.22 | 0 | 0 | 0 | 0 | 0 | 106492.19 | 0.7742071246819339
Expense Category | Account Name | FY2009 Actual | FY2010 Budget | July Actual | August Actual | September Actual | October Actual | November Actual | December Actual | January Actual | February Actual | March Actual | April Actual | May Actual | June Actual | Year To Date | Percent of Budget
Professional Services
 | Data Processing | 13396.7 | 10000 | 1574 | 698 |  | 47.49 | 47.99 | 120 |  |  |  |  |  |  | 2487.48 | 0.248748
 | Garbage Collection | 5600.7 | 5000 | 2166 |  |  |  |  | 662.47 | 743.81 |  |  |  |  |  | 3572.28 | 0.7144560000000001
 | Printing | 15325.41 | 15000 | 1480 |  | 1982.01 | 217 | 1688.02 | 365.12 | 327.08 |  |  |  |  |  | 6059.23 | 0.4039486666666667
 | Consulting |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Other Professional Services (Speakers and Presenters for Programs) | 94918.32 |  | 12354 | 4115 | 7333.76 | 2890 | 5371.9 | 3734.57 | 3761.5 |  |  |  |  |  | 39560.73 | 0
 | Security ** | 140094.61 | 145000 | 10897 | 12186.82 | 6658.41 |  | 13282.82 | 13196.82 | 12366.82 |  |  |  |  |  | 68588.69 | 0.4730254482758621
 | Advertising | 65603 | 70000 | 100 | 125 |  |  | 495 | 225 |  |  |  |  |  |  | 945 | 0.0135
 |  | 334938.74 | 245000 | 28571 | 17124.82 | 15974.18 | 3154.49 | 20885.73 | 18303.98 | 17199.21 | 0 | 0 | 0 | 0 | 0 | 121213.41 | 0.494748612244898
Communications
 | Telecommunications | 45801.83 | 45801.83 | 862 |  | 12.18 |  | 108.97 | 3576.44 |  |  |  |  |  |  | 4559.59 | 0.09955038914383989
 |  | 45801.83 | 45801.83 | 862 | 0 | 12.18 | 0 | 108.97 | 3576.44 | 0 | 0 | 0 | 0 | 0 | 0 | 4559.59 | 0.09955038914383989
Rental Expenses
 | [NAME] | 9551.23 | 9000 | 3844 |  |  |  |  |  |  |  |  |  |  |  | 3844 | 0.4271111111111111
 | Equipment Rental/Leases |  |  | 472 | 30.99 |  |  | 73.82 | 76.5 |  |  |  |  |  |  | 653.31 | 0
 |  | 9551.23 | 9000 | 4316 | 30.99 | 0 | 0 | 73.82 | 76.5 |  | 0 | 0 | 0 | 0 | 0 | 4497.309999999999 | 0.499701111111111
General & Administrative
 | Mileage | 1274.89 | 937 | 78 | 67.1 | 52.8 | 51.92 | 254.31 |  | 52.8 |  |  |  |  |  | 556.93 | 0.5943756670224118
 | Dues and Subscriptions | 13821.19 | 12000 | 400 | 1245 | 964 | 1005 | 636 | 2680 | 6345 |  |  |  |  |  | 13275 | 1.10625
 | Freight Charges | 1042.13 | 1000 | 472 |  | 20 | 714 |  |  |  |  |  |  |  |  | 1206 | 1.206
 | Training and Registration | 24028.15 | 24000 | 2520 | 152.73 | 1080 | 3435 | 1335 | 2644 | 3773.44 |  |  |  |  |  | 14940.17 | 0.6225070833333334
 | Insurance | 7419.09 | 7500 |  |  |  |  |  | 981 | 3275.36 |  |  |  |  |  | 4256.360000000001 | 0.5675146666666667
 | Property Rental |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Other G&A Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Postage and Shipping | 9099.14 | 8000 | 2060 | 2060 | 1060.55 | 1049.26 | 1030 |  |  |  |  |  |  |  | 7259.81 | 0.9074762500000001
 | Travel | 69490.13 | 65000 | 18154 | 8426.49 | 2108.17 |  | 1712.24 | 1584.59 | 5442.04 |  |  |  |  |  | 37427.53 | 0.5758081538461538
 |  | 126174.72 | 118437 | 23684 | 11951.32 | 5285.52 | 6255.18 | 4967.55 | 7889.59 | 18888.64 | 0 | 0 | 0 | 0 | 0 | 78921.79999999999 | 0.6663610189383384
Expense Category | Account Name | FY2009 Actual | FY2010 Budget | July Actual | August Actual | September Actual | October Actual | November Actual | December Actual | January Actual | February Actual | March Actual | April Actual | May Actual | June Actual | Year To Date | Percent of Budget
Capital Outlay
 | PC Lease - Capitalized Leases | 65603 | 85000 | 351 | 18264.11 |  | 898.63 |  |  | 16218.94 |  |  |  |  |  | 35732.68 | 0.4203844705882353
 | Furnishing/Furniture | 37457.65 | 10000 | 1247 | 2275.04 |  | 1105.81 | 5662.08 | 1414.33 |  |  |  |  |  |  | 11704.26 | 1.170426
 | [NAME] | 6130.29 | 5000 | 1332 | 2001.59 | 122.69 | 444.14 |  |  |  |  |  |  |  |  | 3900.42 | 0.780084
 | Equipment (Cost Over $500) | 186491.94 | 50000 | 3932 | 1742.62 | 163 | 10051.34 | 3187.39 |  | 1320.42 |  |  |  |  |  | 20396.77 | 0.4079353999999999
 |  | 295682.88 | 150000 | 6862 | 24283.36 | 285.69 | 12499.92 | 8849.47 | 1414.33 | 17539.36 | 0 | 0 | 0 | 0 | 0 | 71734.13 | 0.4782275333333333
Computer Expenses
 | Computer Software |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Computers Purchased |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Computer Peripherals (printers, scanners, etc.) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Miscellaneous
 | Fines to the City of Birmingham |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 6 | 0
 | Bookstore Allotment to Friends |  | 15000 |  |  | 8046.44 |  |  |  |  |  |  |  |  |  | 8046.44 | 0.5364293333333333
 |  | 0 | 15000 | 0 | 0 | 8046.44 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 8052.44 | 0.5368293333333333
 | Total: | 1059918.73 | 815889.8300000001 | 92464 | 71501.28 | 54856.17 | 36417.34 | 63723.11000000001 | 63951.34000000001 | 72236.48 | 0 | 0 | 0 | 0 | 0 | 455149.72 | 0.5578568371173348
**The Security Account covers payments to police officers and is reimbursed in full by the City Budget.
*These accounts have been merged into Library Materials.
**For food and supplies for staff and/or board meetings that must be paid from Hospitality Staff funds (15HS).
***These accounts were removed from [NAME] budget and moved to City's Public Works Department.