GIS Consortium
FY2018 (01/01/2018-12/31/2018) Financial Report
Fund 850
This table contains the CCGISC revenue report.
| REVENUE | Budgeted | Actual YTD
12/31/2018 | Actual %
of Budget | Unrealized
Balance |
| Budgeted Local Government | | | | |
| Champaign County | $296,628.00 | $226,728.25 | 76.44% | $69,899.75 |
| City of Champaign | $69,383.00 | $69,382.00 | 100.00% | $1.00 |
| City of Urbana | $39,506.00 | $39,506.00 | 100.00% | $0.00 |
| University of Illinois | $35,159.00 | $35,159.25 | 100.00% | - $0.25 |
| Village of Mahomet | $14,588.00 | $14,341.27 | 98.31% | $246.73 |
| Village of Rantoul | $24,773.00 | $24,393.19 | 98.47% | $379.81 |
| Village of Savoy | $13,952.00 | $13,952.50 | 100.00% | - $0.50 |
| Local Government Total | $493,989.00 | $423,462.46 | 85.72% | $70,526.54 |
| | | | | |
| Local Government Reimbursement | $15,700.00 | $15,700.00 | 100.00% | $0.00 |
| Charges for Services | $57,000.00 | $41,780.43 | 73.30% | $15,219.57 |
| Investment Interest | $750.00 | $4,199.22 | 559.90% | - $3,449.22 |
| Maps & Data Sales | $13,500.00 | $14,188.10 | 105.10% | - $688.10 |
| Miscellaneous Revenue | $0.00 | $800.00 | 0.00% | - $800.00 |
| Interdepartment Transfers | $84,500.00 | $84,500.00 | 100.00% | $0.00 |
| REVENUE TOTAL | $665,439.00 | $584,630.21 | 87.86% | $80,808.79 |
This table contains the CCGISC expenditure report.
| EXPENDITURE | Budgeted
(Original) | Budgeted
(Amended) | Actual YTD
12/31/2018 | Actual %
of Budget | Unencumbered
Balance |
| Personnel | | | | | |
| Salaries & Wages | $328,295.00 | $328,295.00 | $312,233.25 | 95.11% | $16,061.75 |
| Fringe Benefits | $118,755.00 | $118,755.00 | $88,293.94 | 74.35% | $30,461.06 |
| Personnel Total | $447,050.00 | $447,050.00 | $400,527.19 | 89.59% | $46,522.81 |
| | | | | | |
| Commodities | $20,275.00 | $33,115.00 | $16,582.02 | 50.07% | $8,258.18 |
| | | | | | |
| Services | | | | | |
| Audit | $11,200.00 | $11,200.00 | $7,340.00 | 65.54% | $3,860.00 |
| Professional Services | $1,750.00 | $1,750.00 | $0.00 | 0.00% | $1,750.00 |
| Job Required Travel | $500.00 | $600.00 | $498.28 | 83.05% | $101.72 |
| Utilities | $2,250.00 | $2,250.00 | $1,213.17 | 53.92% | $1,036.83 |
| Computer/InfoTech Services | $5,000.00 | $5,000.00 | $20.17 | 0.40% | $4,979.83 |
| Telephone Service | $700.00 | $700.00 | $717.76 | 102.54% | - $17.76 |
| Equipment Maintenance | $40,775.00 | $40,815.00 | $38,747.48 | 94.93% | $2,067.52 |
| Conferences & Training | $3,000.00 | $3,000.00 | $564.59 | 18.82% | $2,435.41 |
| All Other Services | $8,210.00 | $8,210.00 | $693.47 | 8.45% | $7,516.53 |
| Services Total | $73,385.00 | $73,525.00 | $49,794.92 | 67.73% | $23,730.08 |
| | | | | | |
| Capital | $28,975.00 | $17,900.00 | $0.00 | 0.00% | $17,900.00 |
| Transfer to General County Fund | $4,500.00 | $2,595.00 | $0.00 | 0.00% | $2,595.00 |
| Interdepartment Transfers | $84,500.00 | $84,500.00 | $84,500.00 | 100.00% | $0.00 |
| EXPENDITURE TOTAL | $658,685.00 | $658,685.00 | $551,404.13 | 83.71% | $99,006.07 |
This table contains the CCGISC 850 fund balance report.
| 850 FUND BALANCE - 01/01/2018 |
| Balance |
| FY2018 Beginning Fund Balance (unaudited) | | $367,304.64 |
| Reserve for Aerial Photography | | - $31,196.04 |
| 10% Restricted Reserve | | - $52,690.70 |
| FY2018 Remaining Unreserved Fund Balance (unaudited) | | $283,417.90 |