GIS Consortium
FY2018 (01/01/2018-12/31/2018) Financial Report
Fund 850
This table contains the CCGISC revenue report.
| REVENUE | Budgeted | Actual YTD
10/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 | $0.00 | 0.00% | $35,159.00 |
| 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 | $388,303.21 | 78.61% | $105,685.79 |
| | | | | |
| Local Government Reimbursement | $15,700.00 | $15,700.00 | 100.00% | $0.00 |
| Charges for Services | $57,000.00 | $35,791.34 | 62.79% | $21,208.66 |
| Investment Interest | $750.00 | $2,981.74 | 397.57% | - $2,231.74 |
| Maps & Data Sales | $13,500.00 | $13,375.00 | 99.07% | $125.00 |
| 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 | $541,451.29 | 81.37% | $123,987.71 |
This table contains the CCGISC expenditure report.
| EXPENDITURE | Budgeted
(Original) | Budgeted
(Amended) | Actual YTD
10/31/2018 | Actual %
of Budget | Unencumbered
Balance |
| Personnel | | | | | |
| Salaries & Wages | $328,295.00 | $328,295.00 | $261,821.02 | 79.75% | $66,473.98 |
| Fringe Benefits | $118,755.00 | $118,755.00 | $74,495.78 | 62.73% | $44,259.22 |
| Personnel Total | $447,050.00 | $447,050.00 | $336,316.80 | 75.23% | $110,733.20 |
| | | | | | |
| Commodities | $20,275.00 | $22,140.00 | $15,940.78 | 72.00% | $6,199.22 |
| | | | | | |
| 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 | $492.18 | 98.44% | $7.82 |
| Utilities | $2,250.00 | $2,250.00 | $976.05 | 43.38% | $1,273.95 |
| Computer/InfoTech Services | $5,000.00 | $5,000.00 | $20.17 | 0.40% | $4,979.83 |
| Telephone Service | $700.00 | $700.00 | $590.74 | 84.39% | $109.26 |
| Equipment Maintenance | $40,775.00 | $40,815.00 | $38,747.48 | 94.93% | $2,067.52 |
| Conferences & Training | $3,000.00 | $3,000.00 | $0.00 | 0.00% | $3,000.00 |
| All Other Services | $8,210.00 | $8,210.00 | $683.47 | 8.32% | $7,526.53 |
| Services Total | $73,385.00 | $73,425.00 | $47,510.09 | 64.71% | $25,914.91 |
| | | | | | |
| Capital | $28,975.00 | $28,975.00 | $0.00 | 0.00% | $28,975.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 | $484,267.67 | 73.52% | $174,417.33 |
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 |