| Lincoln Trail Libraries System | ||||||||||||||
| All Funds Income Statement with Detail | ||||||||||||||
| For the Twelve Months Ending June 30, 2007 | ||||||||||||||
| July | August | September | October | November | December | January | February | March | April | May | June | Current | ||
| YTD | Budget | |||||||||||||
| REVENUE | ||||||||||||||
| Area and Per Capita | $72,094.88 | $376,413.48 | ($72,094.88) | $115,422.92 | $72,095.24 | $45,002.12 | $144,190.48 | $72,094.88 | $825,219.12 | $825,219.00 | ||||
| State Grants | 161,844.33 | 82,398.00 | 17,954.46 | 86,885.73 | 148,659.74 | 497,742.26 | 463,490.74 | |||||||
| Auto Equity: Telcom Ports | 4,000.00 | 32,000.00 | 4,000.00 | 4,000.00 | 44,000.00 | |||||||||
| Auto: Central Site Support | 57,797.50 | 57,797.50 | 57,797.50 | 57,797.50 | 2,180.25 | (2,180.25) | 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 | 899.00 | 151,427.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: Equipment | 341.11 | 580.82 | 163.65 | 26.35 | 1,192.13 | 2,304.06 | ||||||||
| Continuing Education Services | 283.50 | 251.25 | 1,250.00 | 5,422.67 | 7,822.00 | 390.00 | 409.93 | 70.00 | 246.89 | 70.00 | 310.00 | 16,526.24 | 20,250.00 | |
| Cooperative Purchase (Products) | 69.98 | 128.30 | 43.28 | 10.00 | 58.98 | 47.28 | 357.82 | 2,500.00 | ||||||
| Duplicating Services | 12.50 | 63.08 | 200.00 | 190.00 | 53.75 | 519.33 | 500.00 | |||||||
| Duplicating Services (LTLS) | 2,151.32 | 2,313.33 | 2,151.32 | 798.54 | 262.36 | 74.20 | 36.84 | 32.25 | 295.91 | 333.95 | 343.33 | 791.69 | 9,585.04 | 19,449.00 |
| Coop Services - Reimbursements | 5,652.00 | 350.00 | 1,837.00 | 7,839.00 | 12,800.00 | |||||||||
| Facility & Equipment Rental | 125.00 | 125.00 | 600.00 | |||||||||||
| Interest Income | 5,356.10 | 4,602.87 | 5,085.31 | 6,255.39 | 5,767.08 | 5,853.01 | 5,575.75 | 5,332.14 | 5,874.66 | 5,575.00 | 5,119.69 | 6,261.38 | 66,658.38 | 19,000.00 |
| Other Revenue | 0.51 | 0.51 | 0.51 | 0.51 | 0.51 | 2,589.01 | 532.80 | 718.00 | 75.00 | 436.51 | 12,109.65 | 16,463.52 | 19,678.00 | |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| TOTAL REVENUE | $79,886.31 | $278,088.53 | $384,900.62 | $114,838.28 | $72,205.64 | $103,737.53 | $8,654.81 | $139,544.57 | $83,946.52 | $150,596.53 | $243,365.07 | $240,185.50 | $1,899,949.91 | $1,775,291.74 |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| EXPENDITURES | ||||||||||||||
| Personnel | ||||||||||||||
| Library Professionals | 7,272.71 | 34,634.74 | 49,156.63 | 37,823.08 | 31,983.19 | 25,989.29 | 25,976.19 | 25,853.57 | 49,090.85 | 30,643.11 | 30,843.84 | 46,155.14 | 395,422.34 | 399,047.00 |
| Support Services | 14,799.50 | 29,596.35 | 47,190.63 | 30,514.81 | 36,805.17 | 34,231.42 | 34,065.57 | 35,283.82 | 33,122.30 | 32,480.48 | 33,122.39 | 48,967.29 | 410,179.73 | 386,044.10 |
| Payroll Taxes/Fringe Benefits | ||||||||||||||
| Social Security Taxes | 1,688.54 | 4,913.68 | 7,370.57 | 1,876.17 | 5,318.30 | 4,647.54 | 4,664.49 | 4,730.43 | 6,374.25 | 4,766.74 | 4,836.53 | 6,059.45 | 57,246.69 | 63,732.77 |
| Unemployment Insurance | (34.58) | 1,012.21 | 1,928.41 | 673.92 | 3,579.96 | 5,500.75 | ||||||||
| Workers Compensation | 700.61 | 758.99 | 758.99 | 758.99 | 758.99 | 758.99 | 758.99 | 1,658.99 | 755.66 | 820.37 | 764.18 | 772.43 | 10,026.18 | 11,527.24 |
| Retirement Benefits | 5,044.83 | 13,708.52 | 11,425.90 | 5,120.88 | 4,088.01 | 4,206.29 | 5,838.20 | 4,277.38 | 4,305.31 | 3,657.11 | 61,672.43 | 65,144.41 | ||
| Health, Dental, Life Insurance | 9,857.90 | 11,374.53 | 9,899.67 | 11,847.45 | 11,380.38 | 10,886.33 | 9,289.74 | 12,369.11 | 9,480.78 | 10,422.04 | 10,882.04 | 9,580.33 | 127,270.30 | 135,406.07 |
| Temporary Help | 731.70 | 531.16 | 1,019.06 | 698.20 | 2,980.12 | 8,099.00 | ||||||||
| Recruiting | 780.15 | 194.75 | 174.00 | 672.54 | 174.00 | 1,995.44 | 1,500.00 | |||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Library Materials | ||||||||||||||
| Print Materials | 242.95 | 95.69 | 2,276.34 | 132.26 | (222.25) | 345.13 | 199.00 | 343.85 | 3,319.00 | 6,731.97 | 9,075.00 | |||
| Non-Print Materials | 18,519.95 | (17,495.05) | 670.00 | 1,694.90 | 2,850.00 | |||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Building and Grounds | ||||||||||||||
| Rent | 1,000.00 | (1,000.00) | 1,000.00 | 1,000.00 | 1,000.00 | |||||||||
| Utilities | 2,123.56 | 2,403.55 | 2,188.26 | 1,603.67 | 2,039.90 | 2,454.55 | 2,072.76 | 2,706.83 | 1,925.03 | 2,788.99 | 2,434.97 | 2,390.70 | 27,132.77 | 24,500.00 |
| Property Insurance | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 4,478.88 | 4,870.00 |
| Repairs and Maintenance | 68.14 | 136.28 | 163.13 | 1,244.05 | 71.88 | 71.88 | 71.88 | 71.88 | 71.88 | 436.38 | 71.88 | 126.83 | 2,606.09 | 4,400.00 |
| Snow Removal | 450.00 | |||||||||||||
| Supplies | 46.68 | 15.75 | 5.99 | 68.42 | 550.00 | |||||||||
| Custodial Service & Grounds | 63.53 | 47.62 | 97.95 | 35.00 | 103.76 | 103.76 | 155.29 | 147.64 | 754.55 | 1,200.00 | ||||
| Other Building & Grounds Exp | 211.40 | 1,530.26 | 274.13 | 304.23 | 252.04 | 332.10 | 259.08 | 717.06 | 187.95 | 637.73 | 530.97 | 238.83 | 5,475.78 | 4,769.00 |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Gas & Oil | 2,962.29 | 2,893.53 | 71.97 | 2,006.77 | 3,951.22 | 2,290.97 | 1,865.97 | 192.61 | 4,582.70 | 3,079.06 | 705.44 | 24,602.53 | 25,705.00 | |
| Repairs and Maintenance | 575.02 | 10.75 | 190.00 | 32.69 | 2,896.94 | 951.42 | 3,419.44 | 697.01 | 374.92 | 9,148.19 | 11,165.00 | |||
| Vehicle Insurance | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 9,142.92 | 9,812.00 |
| Other (Vehicle Expense) | 11.38 | 11.38 | ||||||||||||
| Travel | ||||||||||||||
| In State Travel | 221.16 | 406.63 | 63.89 | 1,662.78 | 316.14 | 740.74 | 140.06 | 178.74 | 857.78 | (1,151.45) | 1,827.46 | 607.19 | 5,871.12 | 6,679.20 |
| Out of State Travel | 1,132.11 | 2,475.79 | 852.85 | 888.77 | 2,275.59 | 1,522.58 | 75.26 | 599.40 | 443.93 | 219.40 | 987.76 | 11,473.44 | 19,682.00 | |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Cont Ed and Meetings | ||||||||||||||
| Registration and Meetings | 2,630.65 | 389.00 | 1,963.00 | 616.76 | 314.00 | 635.77 | 56.99 | 62.50 | 950.58 | 1,589.58 | 9,208.83 | 9,970.00 | ||
| Honorariums | 75.00 | 2,200.00 | 900.00 | 250.00 | 3,425.00 | 1,500.00 | ||||||||
| Supplies, Materials | 12.85 | 51.09 | 31.36 | 27.02 | 85.00 | 207.32 | 1,500.00 | |||||||
| Meetings Expenses | 698.87 | 630.50 | 394.23 | 1,165.37 | 338.31 | 530.16 | 594.04 | 886.87 | 73.66 | 190.43 | 639.16 | 6,141.60 | 3,900.00 | |
| Travel | 56.88 | 105.73 | 207.58 | 128.42 | 513.00 | 1,228.14 | 2,239.75 | 3,500.00 | ||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Public Relations | 350.00 | 927.10 | 595.00 | 62.80 | 638.00 | 405.40 | 2,978.30 | 6,950.00 | ||||||
| Liability Insurance | 293.68 | 293.68 | 293.68 | 293.68 | 2,793.68 | 293.68 | 293.68 | 293.68 | 293.68 | 293.68 | 293.68 | 293.68 | 6,024.16 | 6,005.00 |
| Supplies/Postage/Printing | ||||||||||||||
| Computer Supplies | 799.00 | 5,173.72 | 1,151.10 | 535.73 | 672.98 | 333.22 | 127.13 | 2,534.35 | 1,669.00 | 764.51 | 373.09 | 144.80 | 14,278.63 | 21,192.00 |
| General Office Supplies | 20.99 | 529.37 | 1,390.37 | 6.61 | 2,101.75 | 479.26 | 398.52 | 2,862.80 | 378.59 | 66.84 | 333.35 | 8,568.45 | 8,911.00 | |
| Internal Printing & Photocopy | 2,151.32 | 2,336.03 | 3,196.01 | 1,742.63 | 1,174.14 | 339.98 | 6.11 | 357.25 | 433.20 | 348.48 | 359.13 | 3,189.76 | 15,634.04 | 24,116.00 |
| Postage | 469.53 | 276.04 | 614.12 | 350.83 | 348.89 | 195.25 | 157.51 | 193.61 | 222.65 | 206.55 | 348.12 | 285.08 | 3,668.18 | 4,910.00 |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Telephone and Telecom | 254.84 | 373.96 | 453.17 | 103.38 | 543.00 | 489.28 | 488.40 | 798.30 | 503.78 | 574.01 | 488.00 | 399.45 | 5,469.57 | 5,169.00 |
| Telecommunications | 156.09 | 664.85 | 257.22 | 2,199.91 | 1,224.40 | 1,892.38 | 1,089.89 | 940.91 | 356.14 | 1,376.77 | 813.17 | 432.98 | 11,404.71 | 16,948.00 |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Equipment Rental | 519.01 | 1,429.45 | 1,429.45 | 6,686.65 | 1,126.21 | 1,404.93 | 955.18 | 1,230.56 | 1,293.19 | 1,969.15 | 1,505.40 | 1,431.48 | 20,980.66 | 15,740.00 |
| Equipment Repair & Maintenance | 410.00 | 70.00 | 276.25 | 70.00 | 826.25 | 5,626.00 | ||||||||
| Maintenance Agreements | 5,542.93 | 5,542.93 | 5,542.93 | 5,542.93 | 8,342.93 | 5,542.93 | 5,542.93 | 5,542.93 | 5,681.26 | 6,209.48 | 5,681.26 | 5,961.26 | 70,676.70 | 89,462.00 |
| EDP Equipment Insurance | 141.17 | 141.17 | 141.17 | 141.17 | 141.17 | 141.17 | 141.17 | 141.17 | 141.17 | 141.17 | 141.17 | 141.17 | 1,694.04 | 2,742.00 |
| Professional Services-Legal | 700.00 | |||||||||||||
| Accounting Services | 1,627.50 | 805.00 | 2,660.00 | 12,537.50 | 6,580.00 | 4,340.00 | (5,880.00) | 735.00 | 770.00 | 24,175.00 | 46,000.00 | |||
| Consulting | 150.00 | 800.00 | 800.00 | 400.00 | 575.00 | 800.00 | 400.00 | 2,100.00 | 6,025.00 | 39,800.00 | ||||
| Centralized Data Processing | 8,200.37 | 6,969.77 | 8,862.97 | 2,000.00 | 14,469.77 | 200.00 | 40,702.88 | 35,090.00 | ||||||
| Contract. Agreements W/Systems | 18,000.00 | 18,000.00 | 18,000.00 | |||||||||||
| Outside Printing Services | 131.00 | 9.80 | 406.69 | 90.00 | 637.49 | 1,750.00 | ||||||||
| Other Contractual Services | 26,057.25 | 25,070.91 | 830.29 | 49,664.24 | 792.01 | 17,025.10 | 140.40 | 12,229.00 | 12,444.44 | 2,975.25 | 10,650.60 | 68,466.31 | 226,345.80 | 276,539.20 |
| Member Reimbursements | 2,500.00 | |||||||||||||
| Miscellaneous | (35.41) | 593.16 | 257.37 | 1,278.56 | 127.88 | 1,209.54 | 852.06 | 274.93 | 945.04 | 155.86 | 223.40 | 1,092.66 | 7,040.70 | 2,405.00 |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Capital Outlays | ||||||||||||||
| Equipment | 8,000.00 | |||||||||||||
| Computers | 8,106.00 | 720.00 | 1,029.48 | 4,132.46 | 13,987.94 | 15,595.00 | ||||||||
| Hardware | 1,646.12 | 1,646.12 | ||||||||||||
| Software | 978.00 | 16,779.00 | 7,314.64 | 2,779.93 | 9.77 | 27,861.34 | 7,300.00 | |||||||
| Other Buildings & Grounds | 2,560.00 | 7,929.84 | 909.16 | 11,399.00 | 11,349.00 | |||||||||
| Vehicles | 35,000.00 | |||||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| $80,788.33 | $160,532.56 | $173,650.12 | $185,414.57 | $139,029.14 | $144,206.85 | $106,510.36 | $139,507.93 | $146,889.32 | $131,415.10 | $123,349.27 | $210,454.39 | $1,741,813.59 | $1,930,877.74 | |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |