| Lincoln Trail Libraries System | ||||||||||||||
| Income Statement Automation Fund | ||||||||||||||
| For the Ten Months Ending April 30, 2007 | ||||||||||||||
| July | August | September | October | November | December | January | February | March | April | May | June | Current | ||
| YTD | Budget | |||||||||||||
| REVENUE | ||||||||||||||
| Auto: Central Site Support | $57,797.50 | $57,797.50 | $57,797.50 | $57,797.50 | $231,190.00 | $224,949.00 | ||||||||
| Auto: Local Site Support | 306.01 | 306.01 | 184.06 | 184.06 | 980.14 | 2,300.00 | ||||||||
| Authority Control | 1,869.50 | 1,869.50 | 1,604.00 | 1,869.50 | 7,212.50 | 7,281.00 | ||||||||
| Auto: Cataloging Services | 37,568.75 | 37,568.75 | (12.00) | 37,834.25 | 37,568.75 | 150,528.50 | 150,275.00 | |||||||
| Auto: Retro Conversion | 16,000.00 | 16,000.00 | ||||||||||||
| Auto: Access Fee | 5,800.00 | 5,800.00 | 7,000.00 | |||||||||||
| Auto: Supplies | 250.00 | 250.00 | 2,000.00 | |||||||||||
| Auto: Equipment | 5,402.00 | 350.00 | 1,837.00 | 7,589.00 | ||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| TOTAL REVENUE | $108,993.76 | $97,891.76 | $15,988.00 | $97,419.81 | $99,256.81 | $419,550.14 | $393,805.00 | |||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| EXPENDITURES | ||||||||||||||
| Personnel | ||||||||||||||
| Library Professionals | 2,661.33 | 5,069.94 | 7,665.75 | 5,144.82 | 4,996.29 | 4,901.11 | 4,888.01 | 4,765.39 | 7,088.18 | 4,762.11 | 51,942.93 | 60,478.00 | ||
| Support Services | 4,180.99 | 8,361.98 | 13,640.97 | 9,261.98 | 9,702.44 | 9,947.96 | 9,955.22 | 9,947.96 | 14,892.51 | 10,061.83 | 99,953.84 | 117,922.00 | ||
| Payroll Taxes/Fringe Benefits | ||||||||||||||
| Social Security Taxes | 523.47 | 1,027.52 | 1,629.99 | 1,102.10 | 1,124.46 | 1,135.97 | 1,135.52 | 1,125.60 | 1,681.54 | 1,071.86 | 11,558.03 | 14,278.00 | ||
| Unemployment Insurance | 404.91 | 515.38 | 920.29 | 1,302.00 | ||||||||||
| Workers Compensation | 40.66 | 40.66 | 40.66 | 40.66 | 40.66 | 40.66 | 40.66 | 88.87 | 49.62 | 121.32 | 544.43 | 765.00 | ||
| Retirement Benefits | 1,063.29 | 2,808.22 | 2,385.59 | 1,173.55 | 978.23 | 1,012.28 | 1,512.27 | 1,019.54 | 11,952.97 | 14,540.00 | ||||
| Health, Dental, Life Insurance | 2,385.51 | 2,385.51 | 2,385.51 | 2,877.11 | 2,481.00 | 2,682.50 | 2,581.75 | 2,615.34 | 2,704.90 | 2,481.00 | 25,580.13 | 33,213.00 | ||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Library Materials | ||||||||||||||
| Print Materials | 1,800.00 | |||||||||||||
| Non-Print Materials | 18,000.00 | (18,000.00) | ||||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Building and Grounds | ||||||||||||||
| Repairs and Maintenance | 5.09 | 10.16 | 5.08 | 5.08 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 | 57.63 | |||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Vehicle Expenses | ||||||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Travel | ||||||||||||||
| In State Travel | 200.00 | |||||||||||||
| Out State Travel | 360.69 | 386.67 | 747.36 | 1,000.00 | ||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Cont Ed and Meetings | ||||||||||||||
| Registrations and Meetings | 295.00 | 295.00 | 500.00 | |||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Public Relations | 297.50 | 297.50 | 500.00 | |||||||||||
| Supplies/Postage/Printing | ||||||||||||||
| Computer Supplies | 241.00 | 539.41 | 169.00 | 131.98 | 168.00 | 1,669.00 | 593.64 | 3,512.03 | 4,660.00 | |||||
| General Office Supplies | 494.86 | 494.86 | ||||||||||||
| Internal Printing & Photocopy | 166.00 | |||||||||||||
| Postage | 0.39 | 0.63 | 1.02 | |||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Telephone and Telecom | 3.65 | 3.65 | ||||||||||||
| Telecommunications | 51.90 | 150.97 | 150.97 | 98.31 | 203.65 | 249.32 | 155.09 | 56.76 | 253.42 | 242.26 | 1,612.65 | 5,427.00 | ||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Equipment Rental | 4,650.00 | 4,650.00 | ||||||||||||
| Maintenance Agreements | 5,542.93 | 5,542.93 | 5,542.93 | 5,542.93 | 6,942.93 | 5,542.93 | 5,542.93 | 5,542.93 | 5,681.26 | 6,209.48 | 57,634.18 | 89,162.00 | ||
| Consulting | 800.00 | 800.00 | 400.00 | 385.00 | 800.00 | 400.00 | 3,585.00 | 4,800.00 | ||||||
| Centralized Data Processing | 8,200.37 | 6,969.77 | 8,862.97 | 2,000.00 | 6,969.77 | 33,002.88 | 35,090.00 | |||||||
| Contract. Agreements W/Systems | 18,000.00 | 18,000.00 | 18,000.00 | |||||||||||
| Other Contractual Services | 4,980.00 | 3,370.00 | 8,350.00 | 6,000.00 | ||||||||||
| Miscellaneous | 4.12 | 12.00 | 16.12 | |||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Capital Outlays | ||||||||||||||
| Equipment | 8,000.00 | |||||||||||||
| Computers | 982.50 | 982.50 | 3,000.00 | |||||||||||
| Software | 16,779.00 | 2,009.63 | 18,788.63 | |||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| $16,455.17 | $31,031.04 | $53,574.30 | $37,580.12 | $28,451.39 | $35,059.32 | $26,469.45 | $47,908.06 | $41,423.84 | $36,530.94 | $354,483.63 | $420,803.00 | |||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |