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
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------