Lincoln Trail Libraries System
All Funds Income Statement with Detail
For the Eleven Months Ending May 31, 2007
July August September October November December January February March April May June Current
YTD Budget
REVENUE
Area and Per Capita $72,095 $376,413 ($72,095) $115,423 $72,095 $45,002 $144,190 $753,124 $825,219
State Grants 161,844 82,398 17,954 86,886 349,083 463,491
Auto Equity: Telcom Ports 4,000 32,000 4,000 4,000 44,000
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: Equipment 341 581 164 26 1,112
Continuing Education Services 284 251 1,250 5,423 7,822 390 410 70 247 70 16,216 20,250
Cooperative Purchase (Products) 70 128 43 10 59 311 2,500
Duplicating Services 13 63 200 190 54 519 500
Duplicating Services (LTLS) 2,151 2,313 2,151 799 262 74 37 32 296 334 343 8,793 19,449
Coop Services - Reimbursements 5,652 350 1,837 7,839 12,800
Facility & Equipment Rental 125 125 600
Interest Income 5,356 4,603 5,085 6,255 5,767 5,853 5,576 5,332 5,875 5,575 5,120 60,397 19,000
Other Revenue 1 1 1 1 1 2,589 533 718 75 437 4,354 19,678
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
TOTAL REVENUE $79,887 $278,090 $384,900 $114,840 $72,205 $103,738 $8,655 $139,544 $83,947 $150,598 $243,365 $1,659,765 $1,775,292
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
EXPENDITURES
Personnel
   Library Professionals 7,273 34,635 49,157 37,823 31,983 25,989 25,976 25,854 49,091 30,643 30,844 16,301 349,267 399,047
   Support Services 14,800 29,596 47,191 30,515 36,805 34,231 34,066 35,284 33,122 32,480 33,122 16,270 361,212 386,044
Payroll Taxes/Fringe Benefits
    Social Security Taxes 1,689 4,914 7,371 1,876 5,318 4,648 4,664 4,730 6,374 4,767 4,837 2,457 51,187 63,733
   Unemployment Insurance (35) 1,012 1,928 2,906 5,501
   Workers Compensation 701 759 759 759 759 759 759 1,659 756 820 764 764 9,254 11,527
   Retirement Benefits 5,045 13,709 11,426 5,121 4,088 4,206 5,838 4,277 4,305 58,015 65,144
   Health, Dental, Life Insurance 9,858 11,375 9,900 11,847 11,380 10,886 9,290 12,369 9,481 10,422 10,882 117,690 135,406
   Temporary Help 732 531 1,019 698 2,980 8,099
    Recruiting 780 195 174 673 174 1,995 1,500
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
Library Materials
   Print Materials 243 96 2,276 132 (222) 345 199 344 3,319 6,732 9,075
   Non-Print Materials 18,520 (17,495) 670 1,695 2,850
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
Building and Grounds
   Rent 1,000 (1,000) 1,000
   Utilities 2,124 2,404 2,188 1,604 2,040 2,455 2,073 2,707 1,925 2,789 2,435 24,742 24,500
   Property Insurance 373 373 373 373 373 373 373 373 373 373 373 373 4,106 4,870
   Repairs and Maintenance 68 136 163 1,244 72 72 72 72 72 436 72 2,479 4,400
   Snow Removal 450
   Supplies 47 16 6 68 550
   Custodial Service & Grounds 64 48 98 35 104 104 155 607 1,200
   Other Building & Grounds Exp 211 1,530 274 304 252 332 259 717 188 638 531 5,237 4,769
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
Gas & Oil 2,962 2,894 72 2,007 3,951 2,291 1,866 193 4,583 3,079 23,897 25,705
Repairs and Maintenance 575 11 190 33 2,897 951 3,419 697 8,773 11,165
Vehicle Insurance 762 762 762 762 762 762 762 762 762 762 762 762 8,381 9,812
Other (Vehicle Expense) 11 11
Travel
   In State Travel 221 407 64 1,663 316 741 140 179 858 (1,151) 1,827 5,264 6,679
   Out of State Travel 1,132 2,476 853 889 2,276 1,523 75 599 444 219 10,486 19,682
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
Cont Ed and Meetings
   Registration and Meetings 2,631 389 1,963 617 314 636 57 63 951 7,619 9,970
   Honorariums 75 2,200 900 250 3,425 1,500
   Supplies, Materials 13 51 31 27 85 207 1,500
   Meetings Expenses 699 631 394 1,165 338 530 594 887 74 190 5,502 3,900
   Travel 57 106 208 128 513 1,012 3,500
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
Public Relations 350 927 595 63 638 2,573 6,950
Liability Insurance 294 294 294 294 2,794 294 294 294 294 294 294 294 5,730 6,005
Supplies/Postage/Printing
   Computer Supplies 799 5,174 1,151 536 673 333 127 2,534 1,669 765 373 14,134 21,192
   General Office Supplies 21 529 1,390 7 2,102 479 399 2,863 379 67 8,235 8,911
   Internal Printing & Photocopy 2,151 2,336 3,196 1,743 1,174 340 6 357 433 348 359 12,444 24,116
   Postage 470 276 614 351 349 195 158 194 223 207 348 3,383 4,910
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
Telephone and Telecom 255 374 453 103 543 489 488 798 504 574 488 5,070 5,169
   Telecommunications 156 665 257 2,200 1,224 1,892 1,090 941 356 1,377 813 10,972 16,948
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
Equipment Rental 519 1,429 1,429 6,687 1,126 1,405 955 1,231 1,293 1,969 1,505 19,549 15,740
Equipment Repair & Maintenance 410 70 276 756 5,626
Maintenance Agreements 5,543 5,543 5,543 5,543 8,343 5,543 5,543 5,543 5,681 6,209 5,681 5,681 64,715 89,462
EDP Equipment Insurance 141 141 141 141 141 141 141 141 141 141 141 141 1,553 2,742
Professional Services-Legal 700
Accounting Services 1,628 805 2,660 12,538 6,580 4,340 (5,880) 735 23,405 46,000
Consulting 150 800 800 400 575 800 400 2,100 6,025 39,800
Centralized Data Processing 8,200 6,970 8,863 2,000 14,470 200 40,703 35,090
Contract. Agreements W/Systems 18,000 18,000 18,000
Outside Printing Services 131 10 407 90 637 1,750
Other Contractual Services 26,057 25,071 830 49,664 792 17,025 140 12,229 12,444 2,975 10,651 157,879 267,249
Member Reimbursements 2,500
Miscellaneous (35) 593 257 1,279 128 1,210 852 275 945 156 223 5,948 2,405
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
Capital Outlays
   Equipment 8,000
   Computers 8,106 720 1,029 4,132 13,988 15,595
   Hardware 1,646 1,646
   Software 978 16,779 7,315 2,780 10 27,861 7,300
   Other Buildings & Grounds 2,560 7,930 909 11,399 11,349
   Vehicles 35,000
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------
$80,790 $160,534 $173,652 $185,415 $139,030 $144,207 $106,510 $139,508 $146,890 $131,415 $123,347 $43,043 $1,531,354 $1,921,587
------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------