| Lincoln Trail Libraries System | ||||||||||||||
| Income Statement Automation Fund | ||||||||||||||
| For the Eleven Months Ending May 31, 2007 | ||||||||||||||
| July | August | September | October | November | December | January | February | March | April | May | June | Current | ||
| YTD | Budget | |||||||||||||
| REVENUE | ||||||||||||||
| Auto: Central Site Support | $57,798 | $57,798 | $57,798 | $57,798 | $2,180 | $233,370 | $224,949 | |||||||
| Auto: Local Site Support | 306 | 306 | 184 | 184 | 980 | 2,300 | ||||||||
| Authority Control | 1,870 | 1,870 | 1,604 | 1,870 | 7,213 | 7,281 | ||||||||
| Auto: Cataloging Services | 37,569 | 37,569 | (12) | 37,834 | 37,569 | 150,529 | 150,275 | |||||||
| Auto: Retro Conversion | 16,000 | 16,000 | ||||||||||||
| Auto: Access Fee | 5,800 | 5,800 | 7,000 | |||||||||||
| Auto: Supplies | 250 | 250 | 2,000 | |||||||||||
| Auto: Equipment | 5,402 | 350 | 1,837 | 7,589 | ||||||||||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| TOTAL REVENUE | $108,995 | $97,893 | $15,988 | $97,420 | $99,258 | $2,180 | $421,731 | $393,805 | ||||||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| EXPENDITURES | ||||||||||||||
| Personnel | ||||||||||||||
| Library Professionals | 2,661 | 5,070 | 7,666 | 5,145 | 4,996 | 4,901 | 4,888 | 4,765 | 7,088 | 4,762 | 4,832 | 2,450 | 56,775 | 60,478 |
| Support Services | 4,181 | 8,362 | 13,641 | 9,262 | 9,702 | 9,948 | 9,955 | 9,948 | 14,893 | 10,062 | 10,144 | 5,173 | 110,098 | 117,922 |
| Payroll Taxes/Fringe Benefits | ||||||||||||||
| Social Security Taxes | 523 | 1,028 | 1,630 | 1,102 | 1,124 | 1,136 | 1,136 | 1,126 | 1,682 | 1,072 | 1,089 | 548 | 12,647 | 14,278 |
| Unemployment Insurance | 405 | 515 | 920 | 1,302 | ||||||||||
| Workers Compensation | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 89 | 50 | 121 | 50 | 50 | 594 | 765 |
| Retirement Benefits | 1,063 | 2,808 | 2,386 | 1,174 | 978 | 1,012 | 1,512 | 1,020 | 1,030 | 12,983 | 14,540 | |||
| Health, Dental, Life Insurance | 2,386 | 2,386 | 2,386 | 2,877 | 2,481 | 2,683 | 2,582 | 2,615 | 2,705 | 2,481 | 2,593 | 28,173 | 33,213 | |
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| Library Materials | ||||||||||||||
| Print Materials | 1,800 | |||||||||||||
| Non-Print Materials | 18,000 | (18,000) | ||||||||||||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| Building and Grounds | ||||||||||||||
| Repairs and Maintenance | 5 | 10 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 63 | ||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| Vehicle Expenses | ||||||||||||||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| Travel | ||||||||||||||
| In State Travel | 200 | |||||||||||||
| Out State Travel | 361 | 387 | 747 | 1,000 | ||||||||||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| Cont Ed and Meetings | ||||||||||||||
| Registrations and Meetings | 295 | 295 | 500 | |||||||||||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| Public Relations | 298 | 298 | 500 | |||||||||||
| Supplies/Postage/Printing | ||||||||||||||
| Computer Supplies | 241 | 539 | 169 | 132 | 168 | 1,669 | 594 | 3,512 | 4,660 | |||||
| General Office Supplies | 495 | 495 | ||||||||||||
| Internal Printing & Photocopy | 166 | |||||||||||||
| Postage | 1 | 1 | ||||||||||||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| Telephone and Telecom | 4 | 4 | ||||||||||||
| Telecommunications | 52 | 151 | 151 | 98 | 204 | 249 | 155 | 57 | 253 | 242 | 709 | 2,321 | 5,427 | |
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| Equipment Rental | 4,650 | 4,650 | ||||||||||||
| Maintenance Agreements | 5,543 | 5,543 | 5,543 | 5,543 | 6,943 | 5,543 | 5,543 | 5,543 | 5,681 | 6,209 | 5,681 | 5,681 | 63,315 | 89,162 |
| Consulting | 800 | 800 | 400 | 385 | 800 | 400 | 2,100 | 5,685 | 4,800 | |||||
| Centralized Data Processing | 8,200 | 6,970 | 8,863 | 2,000 | 6,970 | 33,003 | 35,090 | |||||||
| Contract. Agreements W/Systems | 18,000 | 18,000 | 18,000 | |||||||||||
| Other Contractual Services | 4,980 | 3,370 | 2,098 | 10,448 | 6,000 | |||||||||
| Miscellaneous | 4 | 12 | 16 | |||||||||||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| Capital Outlays | ||||||||||||||
| Equipment | 8,000 | |||||||||||||
| Computers | 983 | 4,132 | 5,115 | 3,000 | ||||||||||
| Software | 16,779 | 2,010 | 10 | 18,798 | ||||||||||
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |
| $16,455 | $31,032 | $53,575 | $37,581 | $28,451 | $35,060 | $26,470 | $47,908 | $41,423 | $36,532 | $34,473 | $13,902 | $388,956 | $420,803 | |
| ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | |