| Lincoln Trail Libraries System | |||||||||||
| All Funds Income Statement with Detail | |||||||||||
| For the Nine Months Ending March 31, 2007 | |||||||||||
| July | August | September | October | November | December | January | February | March | Current | ||
| YTD | Budget | ||||||||||
| REVENUE | |||||||||||
| Area and Per Capita | $72,094.88 | $376,413.48 | ($72,094.88) | $115,422.92 | $72,095.24 | $563,931.64 | $825,219.00 | ||||
| State Grants | 161,844.33 | 82,398.00 | 17,954.46 | 262,196.79 | 406,166.00 | ||||||
| Auto Equity: Telcom Ports | 4,000.00 | 32,000.00 | 4,000.00 | 40,000.00 | |||||||
| Auto: Central Site Support | 57,797.50 | 57,797.50 | 57,797.50 | 173,392.50 | 224,949.00 | ||||||
| Auto: Local Site Support | 306.01 | 306.01 | 184.06 | 796.08 | 2,300.00 | ||||||
| Authority Control | 1,869.50 | 1,869.50 | 1,604.00 | 5,343.00 | 7,281.00 | ||||||
| Auto: Cataloging Services | 37,568.75 | 37,568.75 | (12.00) | 37,834.25 | 112,959.75 | 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 | 921.93 | ||||||||
| Continuing Education Services | 283.50 | 251.25 | 1,250.00 | 5,422.67 | 7,822.00 | 390.00 | 409.93 | 70.00 | 246.89 | 16,146.24 | 20,250.00 |
| Cooperative Purchase (Products) | 69.98 | 128.30 | 43.28 | 10.00 | 251.56 | 2,500.00 | |||||
| Duplicating Services | 12.50 | 63.08 | 200.00 | 275.58 | 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 | 8,116.07 | 19,449.00 |
| Coop Services - Reimbursements | 5,652.00 | 350.00 | 6,002.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 | 49,702.31 | 19,000.00 |
| Other Revenue | 0.51 | 0.51 | 0.51 | 0.51 | 0.51 | 2,589.01 | 532.80 | 718.00 | 3,842.36 | 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 | $1,265,802.81 | $1,717,967.00 |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| 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 | 287,780.25 | 458,595.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 | 295,609.57 | 387,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 | 41,583.97 | 67,213.54 |
| Unemployment Insurance | (34.58) | 1,012.21 | 1,928.41 | 2,906.04 | 7,630.75 | ||||||
| Workers Compensation | 700.61 | 758.99 | 758.99 | 758.99 | 758.99 | 758.99 | 758.99 | 1,658.99 | 755.66 | 7,669.20 | 11,508.64 |
| Retirement Benefits | 5,044.83 | 13,708.52 | 11,425.90 | 5,120.88 | 4,088.01 | 4,206.29 | 5,838.20 | 49,432.63 | 67,672.42 | ||
| 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 | 96,385.89 | 143,662.85 |
| 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,412.97 | 5,375.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 | ||||||||
| 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 | 19,518.11 | 24,500.00 |
| Property Insurance | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 373.24 | 3,359.16 | 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 | 1,971.00 | 4,400.00 |
| Snow Removal | 450.00 | ||||||||||
| Supplies | 46.68 | 15.75 | 62.43 | 550.00 | |||||||
| Custodial Service & Grounds | 63.53 | 47.62 | 97.95 | 35.00 | 103.76 | 103.76 | 451.62 | 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 | 4,068.25 | 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 | 16,235.33 | 25,705.00 | |
| Repairs and Maintenance | 575.02 | 10.75 | 190.00 | 32.69 | 2,896.94 | 951.42 | 3,419.44 | 697.01 | 8,773.27 | 11,165.00 | |
| Vehicle Insurance | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 761.91 | 6,857.19 | 9,812.00 |
| Travel | |||||||||||
| In State Travel | 221.16 | 406.63 | 63.89 | 1,662.78 | 316.14 | 740.74 | 140.06 | 178.74 | 857.78 | 4,587.92 | 9,689.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 | 9,822.35 | 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 | 6,606.17 | 10,470.00 | ||
| Honorariums | 75.00 | 2,200.00 | 2,275.00 | 1,500.00 | |||||||
| Supplies, Materials | 12.85 | 51.09 | 31.36 | 27.02 | 122.32 | 2,000.00 | |||||
| Meetings Expenses | 698.87 | 630.50 | 394.23 | 1,165.37 | 338.31 | 530.16 | 594.04 | 886.87 | 5,238.35 | 3,900.00 | |
| Travel | 56.88 | 105.73 | 207.58 | 370.19 | 3,500.00 | ||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Public Relations | 350.00 | 927.10 | 595.00 | 62.80 | 638.00 | 2,572.90 | 5,950.00 | ||||
| Liability Insurance | 293.68 | 293.68 | 293.68 | 293.68 | 2,793.68 | 293.68 | 293.68 | 293.68 | 293.68 | 5,143.12 | 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 | 12,996.23 | 20,102.00 |
| General Office Supplies | 20.99 | 529.37 | 1,390.37 | 6.61 | 2,101.75 | 479.26 | 398.52 | 2,862.80 | 7,789.67 | 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 | 11,736.67 | 24,116.00 |
| Postage | 469.53 | 276.04 | 614.12 | 350.83 | 348.89 | 195.25 | 157.51 | 193.61 | 222.65 | 2,828.43 | 5,010.00 |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Telephone and Telecom | 254.84 | 373.96 | 453.17 | 103.38 | 543.00 | 489.28 | 488.40 | 798.30 | 503.78 | 4,008.11 | 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 | 8,781.79 | 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 | 16,074.63 | 15,740.00 |
| Equipment Repair & Maintenance | 410.00 | 70.00 | 276.25 | 756.25 | 6,716.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 | 52,824.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 | 1,270.53 | 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) | 22,670.00 | 39,000.00 | ||
| Consulting | 150.00 | 800.00 | 800.00 | 400.00 | 575.00 | 800.00 | 400.00 | 3,925.00 | 39,800.00 | ||
| Centralized Data Processing | 8,200.37 | 6,969.77 | 8,862.97 | 2,000.00 | 26,033.11 | 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 | 144,253.64 | 240,139.25 |
| 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 | 5,568.78 | 2,405.00 |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Capital Outlays | |||||||||||
| Equipment | 8,000.00 | ||||||||||
| Computers | 8,106.00 | 720.00 | 8,826.00 | 15,595.00 | |||||||
| Hardware | 1,646.12 | 1,646.12 | |||||||||
| Software | 978.00 | 16,779.00 | 7,314.64 | 25,071.64 | 500.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,195.47 | $106,510.36 | $139,507.93 | $146,889.32 | $1,276,583.45 | $1,957,012.75 | |
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |