6/23/05 /05 Lincoln Trail Libraries System Page: 1
Income Statement
For the Month Ending 5/31/05
For Gen'l & Internal Service Funds
For All Programs
Current Current FY2005Budget Budget %
Period YTD Total Variance Remaining
Revenue
Area & Per Capita $0.00 $681,029.00 $825,219.00 144,190.00 17.47%
Auto: Central Site Support 0.00 205,872.78 205,824.00 (48.78) (0.02)
Auto: Local Site Support 0.00 1,762.77 2,300.00 537.23 23.36
Authority Control 0.00 7,281.00 7,281.00 0.00 0.00
Auto: Cataloging Services 0.00 131,616.00 131,615.00 (1.00) 0.00
Auto: Retro Conversion 0.00 3,000.00 0.00 (3,000.00) 0.00
Auto: Other Cataloging Services 0.00 12,949.68 12,000.00 (949.68) (7.91)
Continuing Education Services 1,629.30 19,743.70 20,250.00 506.30 2.50
Cooperative Purchases (Products) 0.00 1,959.14 2,500.00 540.86 21.63
Duplicating Services 2,061.93 33,959.59 19,949.00 (14,010.59) (70.23)
Auto: Supplies & Equipment 2,935.00 5,262.00 2,000.00 (3,262.00) (163.10)
Coop Serv: Reimbursements 0.00 2,812.88 11,545.00 8,732.12 75.64
Facility & Equipment Rental 180.00 180.00 600.00 420.00 70.00
Interest Income 2,950.38 25,683.92 19,000.00 (6,683.92) (35.18)
Other Revenue 617.51 8,707.24 19,678.00 10,970.76 55.75
Total Revenue $10,374.12 $1,141,819.70 $1,279,761.00 137,941.30 10.78%
Date: 6/23/05 Lincoln Trail Libraries System Page: 2
Income Statement
For the Month Ending 5/31/05
For Gen'l & Internal Service Funds
For All Programs
Current Current FY2005Budget Budget %
Period YTD Total Variance Remaining
Expenditures
Personnel
Library Professionals $25,971.75 $299,492.62 $337,830.00 38,337.38 11.35%
Supports Services 27,177.67 323,685.25 360,867.00 37,181.75 10.30
Payroll Taxes/Fringe Benefits
Social Security Taxes 4,065.89 49,847.25 53,451.00 3,603.75 6.74
Unemployment Insurance 493.77 7,043.50 5,277.00 (1,766.50) (33.48)
Workers Compensation 787.51 7,982.89 10,402.00 2,419.11 23.26
Retirement Benefits 1,325.32 17,197.07 18,759.00 1,561.93 8.33
Health, Dental, Life Insurance 7,455.22 79,890.15 91,141.00 11,250.85 12.34
Recruiting 0.00 1,209.59 300.00 (909.59) (303.20)
Library Materials
Print Materials 116.35 3,263.21 6,085.00 2,821.79 46.37
Nonprint Materials 0.00 1,895.00 550.00 (1,345.00) (244.55)
Building and Grounds
Utilities 1,788.35 18,118.01 24,500.00 6,381.99 26.05
Property Insurance 373.00 4,103.00 4,870.00 767.00 15.75
Repairs and Maintenance 68.78 6,778.74 4,400.00 (2,378.74) (54.06)
Snow Removal 0.00 220.00 450.00 230.00 51.11
Supplies 254.44 532.95 550.00 17.05 3.10
Custodial Service/Supplies 0.00 747.52 1,200.00 452.48 37.71
Building and Grounds, Other 225.74 3,908.37 4,000.00 91.63 2.29
Vehicle Expenses
Gas and Oil 463.74 16,998.23 25,710.00 8,711.77 33.89
Repairs and Maintenance 598.18 7,542.38 10,665.00 3,122.62 29.28
Vehicle Insurance 772.17 8,644.84 9,812.00 1,167.16 11.90
Travel/Cont Ed.-Staff and Board
In State Travel $595.45 $6,100.16 $6,700.00 599.84 8.95%
Out of State Travel 0.00 2,652.84 3,400.00 747.16 21.98
Registrations and Other Fees 1,274.62 6,307.39 5,450.00 (857.39) (15.73)
CE & Meeting, Non Staff/Board
Honorariums $200.00 $2,170.00 $2,500.00 330.00 13.20%
Supplies, Materials-CE & Meetings 475.40 1,151.66 1,500.00 348.34 23.22
Meeting Expenses 94.71 1,107.78 3,900.00 2,792.22 71.60
Travel-CE & Meetings 1,071.34 1,525.94 1,000.00 (525.94) (52.59)
Public Relations
Public Relations $0.00 $429.20 $1,050.00 620.80 59.12%
Liability Insurance
Liability Insurance $443.83 $4,882.13 $5,405.00 522.87 9.67%
Supplies, Postage, Printing
Computer Supplies $2,585.50 $19,565.64 $25,121.00 5,555.36 22.11%
General Office Supplies/Equip 568.47 2,876.09 6,975.00 4,098.91 58.77
Internal Printing/Photocopying 2,033.77 32,989.11 30,764.00 (2,225.11) (7.23)
Postage 627.32 2,862.57 3,110.00 247.43 7.96
Binding 0.00 35.67 0.00 (35.67) 0.00
Date: 6/23/05 Lincoln Trail Libraries System Page: 3
Income Statement
For the Month Ending 5/31/05
For Gen'l & Internal Service Funds
For All Programs
Current Current FY2005Budget Budget %
Period YTD Total Variance Remaining
Telephone & Telcom
Local & Long Distance $239.97 $3,865.23 $5,175.00 1,309.77 25.31%
Telecommunications Data/Fax 174.48 8,322.77 13,640.00 5,317.23 38.98
Equipment Rental
Equipment Rental $1,387.40 $13,874.00 $16,740.00 2,866.00 17.12%
Equipment Repair & Maintenance 13.05 630.05 5,190.00 4,559.95 87.86
Maintenance Agreements 3,668.94 28,363.76 46,877.00 18,513.24 39.49
EDP Equipment Insurance 199.33 2,192.66 2,742.00 549.34 20.03
Professional Services
Legal $0.00 $0.00 $700.00 700.00 100.00%
Accounting 0.00 8,000.00 8,000.00 0.00 0.00
Consulting 1,200.00 3,600.00 15,650.00 12,050.00 77.00
Contractual Services
Information Services Costs $200.00 $28,540.06 $33,766.00 5,225.94 15.48%
Outside Printing 6.20 4,956.70 5,402.00 445.30 8.24
Other Contractual Services 163.95 22,571.37 11,788.00 (10,783.37) (91.48)
Member Reimbursements
Miscellaneous
Miscellaneous $129.46 $3,654.86 $4,480.00 825.14 18.42%
Capital Outlays (Over $750)
Equipment $0.00 $0.00 $2,500.00 2,500.00 100.00%
Computers 0.00 22,114.00 17,291.00 (4,823.00) (27.89)
Software 0.00 0.00 76,911.00 76,911.00 100.00
Furniture & Fixtures 0.00 0.00 900.00 900.00 100.00
Building and Improvements 0.00 0.00 16,800.00 16,800.00 100.00
Vehicles 0.00 240.00 240.00 0.00 0.00
Total Expenditures $89,291.07 $1,094,682.21 $1,352,486.00 257,803.79 19.06%
Reserves
Debt Service
Other Sources
Other Sources 0.00 (94,185.00) 0.00 94,185.00 0.00
Other Uses
Total Expenses, Reserves and Sources $89,291.07 $1,000,497.21 $1,352,486.00 351,988.79 26.03%
Net Income ($78,916.95) $141,322.49 ($72,725.00) (214,047.49) 294.32%