Lincoln Trail Libraries System
Income Statement Automation Fund
For the Twelve Months Ending June 30, 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 ($2,180) $231,190 $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 ($2,180) $419,551 $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 7,234 64,009 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 15,696 125,794 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 1,639 14,286 14,278
   Unemployment Insurance 405 515 228 1,149 1,302
   Workers Compensation 41 41 41 41 41 41 41 89 50 121 50 50 644 765
   Retirement Benefits 1,063 2,808 2,386 1,174 978 1,012 1,512 1,020 1,030 1,043 14,026 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 2,593 30,766 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 5 68
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
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 319 2,640 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,961 69,277 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 2,570 13,018 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 $37,338 $426,296 $420,803
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------