| Lincoln Trail Libraries System | ||||||||||||||
| All Funds Income Statement with Detail | ||||||||||||||
| For the Ten Months Ending April 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 | $608,933.76 | $825,219.00 | ||||||
| State Grants | 161,844.33 | 82,398.00 | 17,954.46 | 262,196.79 | 359,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 | 57,797.50 | 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 | 150,528.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 | 1,085.58 | ||||||||||
| 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 | 190.00 | 465.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 | 333.95 | 8,450.02 | 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 | 55,277.31 | 19,000.00 | ||
| Other Revenue | 0.51 | 0.51 | 0.51 | 0.51 | 0.51 | 2,589.01 | 532.80 | 718.00 | 75.00 | 3,917.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 | $150,596.53 | $1,416,399.34 | $1,670,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 | 30,643.11 | 318,423.36 | 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 | 32,480.48 | 328,090.05 | 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 | 4,766.74 | 46,350.71 | 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 | 820.37 | 8,489.57 | 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 | 4,277.38 | 53,710.01 | 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 | 10,422.04 | 106,807.93 | 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,319.00 | 6,731.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 | 2,788.99 | 22,307.10 | 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 | 3,732.40 | 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 | 2,407.38 | 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 | 155.29 | 606.91 | 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 | 4,705.98 | 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 | 20,818.03 | 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 | 761.91 | 7,619.10 | 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,054.45) | 3,533.47 | 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 | 443.93 | 10,266.28 | 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 | 6,668.67 | 10,470.00 | ||||
| Honorariums | 75.00 | 2,200.00 | 900.00 | 3,175.00 | 1,500.00 | |||||||||
| Supplies, Materials | 12.85 | 51.09 | 31.36 | 27.02 | 85.00 | 207.32 | 2,000.00 | |||||||
| Meetings Expenses | 698.87 | 630.50 | 394.23 | 1,165.37 | 338.31 | 530.16 | 594.04 | 886.87 | 73.66 | 5,312.01 | 3,900.00 | |||
| Travel | 56.88 | 105.73 | 207.58 | 128.42 | 498.61 | 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 | 293.68 | 5,436.80 | 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 | 13,760.74 | 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 | 378.59 | 8,168.26 | 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 | 12,085.15 | 24,116.00 | ||
| Postage | 469.53 | 276.04 | 614.12 | 350.83 | 348.89 | 195.25 | 157.51 | 193.61 | 222.65 | 206.55 | 3,034.98 | 5,010.00 | ||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Telephone and Telecom | 254.84 | 373.96 | 453.17 | 103.38 | 543.00 | 489.28 | 488.40 | 798.30 | 503.78 | 574.01 | 4,582.12 | 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 | 10,158.56 | 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 | 18,043.78 | 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 | 6,209.48 | 59,034.18 | 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 | 1,411.70 | 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 | 23,405.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 | 14,469.77 | 40,502.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 | 147,228.89 | 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 | 155.86 | 5,724.64 | 2,405.00 | ||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Capital Outlays | ||||||||||||||
| Equipment | 8,000.00 | |||||||||||||
| Computers | 8,106.00 | 720.00 | 1,029.48 | 9,855.48 | 15,595.00 | |||||||||
| Hardware | 1,646.12 | 1,646.12 | ||||||||||||
| Software | 978.00 | 16,779.00 | 7,314.64 | 2,779.93 | 27,851.57 | 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,206.85 | $106,510.36 | $139,507.93 | $146,889.32 | $131,512.10 | $1,408,106.93 | $1,957,012.75 | |||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |