GIS Consortium
FY2018 (01/01/2018-12/31/2018) Financial Report
Fund 850
This table contains the CCGISC revenue report.
| REVENUE | Budgeted | Actual YTD
06/30/2018 | Actual %
of Budget | Unrealized
Balance |
| Budgeted Local Government | | | | |
| Champaign County | $296,628.00 | $86,930.25 | 29.31% | $209,697.75 |
| City of Champaign | $69,383.00 | $1,156.25 | 1.67% | $68,226.75 |
| City of Urbana | $39,506.00 | $1,156.25 | 2.93% | $38,349.75 |
| University of Illinois | $35,159.00 | $0.00 | 0.00% | $35,159.00 |
| Village of Mahomet | $14,588.00 | $1,560.02 | 10.69% | $13,027.98 |
| Village of Rantoul | $24,773.00 | $24,393.19 | 98.47% | $379.81 |
| Village of Savoy | $13,952.00 | $1,156.25 | 8.29% | $12,795.75 |
| Local Government Total | $493,989.00 | $116,352.21 | 23.55% | $377,636.79 |
| | | | | |
| Local Government Reimbursement | $15,700.00 | $5,300.00 | 33.76% | $10,400.00 |
| Charges for Services | $57,000.00 | $18,613.73 | 32.66% | $38,386.27 |
| Investment Interest | $750.00 | $1,365.62 | 182.08% | - $615.62 |
| Maps & Data Sales | $13,500.00 | $6,653.56 | 49.29% | $6,846.44 |
| Interdepartment Transfers | $84,500.00 | $0.00 | 0.00% | $84,500.00 |
| REVENUE TOTAL | $665,439.00 | $148,285.12 | 22.28% | $517,153.88 |
This table contains the CCGISC expenditure report.
| EXPENDITURE | Budgeted
(Original) | Budgeted
(Amended) | Actual YTD
06/30/2018 | Actual %
of Budget | Unencumbered
Balance |
| Personnel | | | | | |
| Salaries & Wages | $328,295.00 | $328,295.00 | $152,527.95 | 46.46% | $175,767.05 |
| Fringe Benefits | $118,755.00 | $118,755.00 | $43,435.87 | 36.58% | $75,319.13 |
| Personnel Total | $447,050.00 | $447,050.00 | $195,963.82 | 43.83% | $251,086.18 |
| | | | | | |
| Commodities | $20,275.00 | $20,275.00 | $9,633.84 | 47.52% | $10,641.16 |
| | | | | | |
| Services | | | | | |
| Audit | $11,200.00 | $11,200.00 | $6,000.00 | 53.57% | $5,200.00 |
| Professional Services | $1,750.00 | $1,750.00 | $0.00 | 0.00% | $1,750.00 |
| Job Required Travel | $500.00 | $500.00 | $343.07 | 68.61% | $156.93 |
| Utilities | $2,250.00 | $2,250.00 | $374.84 | 16.66% | $1,875.16 |
| Computer/InfoTech Services | $5,000.00 | $5,000.00 | $20.17 | 0.40% | $4,979.83 |
| Telephone Service | $700.00 | $700.00 | $360.02 | 51.43% | $339.98 |
| Equipment Maintenance | $40,775.00 | $40,775.00 | $29,205.66 | 71.63% | $11,569.34 |
| Conferences & Training | $3,000.00 | $3,000.00 | $0.00 | 0.00% | $3,000.00 |
| All Other Services | $8,210.00 | $8,210.00 | $289.73 | 3.53% | $7,920.27 |
| Services Total | $73,385.00 | $73,385.00 | $36,593.49 | 49.87% | $36,791.51 |
| | | | | | |
| Capital | $28,975.00 | $28,975.00 | $0.00 | 0.00% | $28,975.00 |
| Transfer to General County Fund | $4,500.00 | $4,500.00 | $0.00 | 0.00% | $4,500.00 |
| Interdepartment Transfers | $84,500.00 | $84,500.00 | $0.00 | 0.00% | $84,500.00 |
| EXPENDITURE TOTAL | $658,685.00 | $658,685.00 | $242,191.15 | 36.77% | $416,493.85 |
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 |