| Lincoln Trail Libraries System | ||||||||||||||
| Income Statement General Fund | ||||||||||||||
| 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 | ||||||
| Other Revenue | 0.51 | 0.51 | 0.51 | 0.51 | 0.51 | 3.06 | 10.00 | 15.61 | ||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| TOTAL REVENUE | $72,095.39 | $0.51 | $376,413.99 | $0.51 | ($72,094.88) | $0.51 | $3.06 | $115,422.92 | $72,105.24 | $45,002.12 | $608,949.37 | $825,219.00 | ||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| EXPENDITURES | ||||||||||||||
| Personnel | ||||||||||||||
| Library Professionals | 9,095.18 | 18,190.36 | 27,285.54 | 18,190.36 | 18,365.10 | 18,539.84 | 18,539.84 | 18,539.84 | 27,809.76 | 18,773.61 | 193,329.43 | 243,229.00 | ||
| Support Services | 8,906.87 | 17,813.74 | 25,082.33 | 16,593.47 | 20,908.39 | 17,567.39 | 17,295.18 | 17,667.46 | 27,265.78 | 18,605.40 | 187,706.01 | 220,299.00 | ||
| Payroll Taxes/Fringe Benefits | ||||||||||||||
| Social Security Taxes | 1,377.16 | 2,754.32 | 4,224.65 | 2,660.98 | 3,208.88 | 3,099.77 | 2,961.12 | 2,823.26 | 4,213.29 | 2,859.46 | 30,182.89 | 36,985.00 | ||
| Unemployment Insurance | 182.36 | 1,102.35 | 1,284.71 | 2,526.00 | ||||||||||
| Workers Compensation | 575.61 | 575.61 | 575.61 | 575.61 | 575.61 | 575.61 | 575.61 | 1,258.16 | 667.92 | 1,406.52 | 7,361.87 | 10,298.00 | ||
| Retirement Benefits | 3,132.36 | 7,736.12 | 6,447.02 | 3,057.55 | 2,397.43 | 2,467.06 | 3,689.09 | 2,482.85 | 31,409.48 | 37,750.00 | ||||
| Health, Dental, Life Insurance | 6,363.89 | 6,363.89 | 5,324.73 | 5,966.06 | 6,334.12 | 4,990.93 | 5,547.86 | 7,570.18 | 5,888.84 | 6,353.92 | 60,704.42 | 76,414.00 | ||
| Temporary Help | 731.70 | 531.16 | 1,019.06 | 698.20 | 2,980.12 | 8,099.00 | ||||||||
| Recruiting | 646.65 | 194.75 | 174.00 | 194.75 | 174.00 | 1,384.15 | 1,000.00 | |||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Library Materials | ||||||||||||||
| Print Materials | 242.95 | 95.69 | 2,276.34 | 132.26 | (222.25) | 60.93 | 199.00 | 99.00 | 2,883.92 | 3,575.00 | ||||
| Non-Print Materials | 129.95 | 480.00 | 609.95 | |||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Building and Grounds | ||||||||||||||
| Utilities | 2,038.62 | 2,317.38 | 2,105.54 | 1,539.52 | 1,961.79 | 2,356.35 | 1,993.40 | 2,598.55 | 1,851.55 | 2,677.43 | 21,440.13 | 23,500.00 | ||
| Property Insurance | 335.69 | 335.69 | 335.69 | 335.69 | 335.69 | 335.69 | 335.69 | 335.69 | 335.69 | 335.69 | 3,356.90 | 4,380.00 | ||
| Repairs and Maintenance | 63.05 | 126.12 | 158.05 | 1,238.97 | 66.51 | 66.51 | 66.51 | 66.51 | 66.51 | 431.01 | 2,349.75 | 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,951.24 | 2,853.91 | 71.97 | 1,997.73 | 3,935.22 | 2,290.97 | 1,828.17 | 192.61 | 4,472.37 | 20,594.19 | 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 | 387.42 | 63.89 | 1,029.63 | 280.14 | 740.74 | 173.94 | 633.41 | (432.52) | 3,097.81 | 4,100.00 | |||
| Out of State Travel | 344.20 | 925.10 | 852.85 | 386.20 | 749.24 | 3,257.59 | 6,700.00 | |||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Cont Ed and Meetings | ||||||||||||||
| Registration and Meetings | 230.65 | 364.00 | 1,122.00 | 245.00 | 314.00 | 524.00 | 56.99 | 2,856.64 | 5,200.00 | |||||
| Meetings Expenses | 36.22 | 1.04 | (198.70) | 377.30 | 263.22 | 7.52 | 16.38 | 60.64 | 14.66 | 578.28 | 700.00 | |||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Public Relations | 27.10 | 297.50 | 324.60 | 450.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 | 4,335.89 | 611.69 | 477.92 | 478.02 | 201.24 | 127.13 | 2,366.35 | 70.88 | 9,468.12 | 14,907.00 | |||
| General Office Supplies | 20.99 | 529.37 | 729.68 | 6.61 | 2,070.01 | 425.11 | 328.53 | 2,862.80 | 249.89 | 7,222.99 | 6,325.00 | |||
| Internal Printing & Photocopy | 1,981.56 | 2,138.54 | 1,981.56 | 768.45 | 324.28 | 310.24 | (8.76) | 31.77 | 100.34 | 77.69 | 7,705.67 | 12,886.00 | ||
| Postage | 79.91 | 170.71 | 137.90 | 186.44 | 270.89 | 52.36 | 58.30 | 42.12 | 123.23 | 79.56 | 1,201.42 | 2,650.00 | ||
| Delivery Supplies | 1,900.00 | |||||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Telephone and Telecom | 254.84 | 373.10 | 427.61 | 103.38 | 509.72 | 473.99 | 434.81 | 770.63 | 493.85 | 513.85 | 4,355.78 | 4,965.00 | ||
| Telecommunications | 26.34 | 19.93 | 25.73 | 78.06 | 65.39 | 17.11 | 17.08 | 21.96 | 271.60 | 320.00 | ||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Equipment Repair & Maintenance | 410.00 | 70.00 | 276.25 | 756.25 | 3,636.00 | |||||||||
| Maintenance Agreements | 300.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 | 700.00 | |||||||||||||
| Accounting Services | 1,627.50 | 805.00 | 2,660.00 | 12,537.50 | 6,580.00 | 4,340.00 | (5,880.00) | 350.00 | 23,020.00 | 35,000.00 | ||||
| Outside Printing Services | 406.69 | 90.00 | 496.69 | 1,000.00 | ||||||||||
| Other Contractual Services | 88.95 | 338.63 | 1,164.24 | 151.01 | 24.00 | 48.00 | 5,099.00 | 6,279.00 | 13,192.83 | 235.00 | ||||
| Member Reimbursements | 2,500.00 | |||||||||||||
| Miscellaneous | (35.41) | 593.16 | 87.12 | 1,203.69 | (3.46) | 1,209.54 | 19.00 | 111.93 | 853.35 | 155.86 | 4,260.43 | 830.00 | ||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| Capital Outlays | ||||||||||||||
| Computers | 7,093.00 | 720.00 | 46.98 | 7,859.98 | 12,595.00 | |||||||||
| Hardware | 1,646.12 | 1,646.12 | ||||||||||||
| Software | 978.00 | 750.00 | 770.30 | 2,498.30 | 500.00 | |||||||||
| Building and Improvements | 2,560.00 | 7,929.84 | 909.16 | 11,399.00 | 11,349.00 | |||||||||
| Vehicles | 35,000.00 | |||||||||||||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |
| $36,623.99 | $77,787.00 | $83,800.51 | $71,436.83 | $81,440.27 | $72,650.94 | $62,547.23 | $70,962.46 | $81,954.56 | $62,406.15 | $701,675.59 | $899,601.00 | |||
| --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | |