Financial Reports

GIS Consortium
FY2018 (01/01/2018-12/31/2018) Financial Report
Fund 850

This table contains the CCGISC revenue report.
REVENUEBudgetedActual YTD
10/31/2018
Actual %
of Budget
Unrealized
Balance
Budgeted Local Government
Champaign County$296,628.00$226,728.2576.44%$69,899.75
City of Champaign$69,383.00$69,382.00100.00%$1.00
City of Urbana$39,506.00$39,506.00100.00%$0.00
University of Illinois$35,159.00$0.000.00%$35,159.00
Village of Mahomet$14,588.00$14,341.2798.31%$246.73
Village of Rantoul$24,773.00$24,393.1998.47%$379.81
Village of Savoy$13,952.00$13,952.50100.00%- $0.50
Local Government Total$493,989.00$388,303.2178.61%$105,685.79
 
Local Government Reimbursement$15,700.00$15,700.00100.00%$0.00
Charges for Services$57,000.00$35,791.3462.79%$21,208.66
Investment Interest$750.00$2,981.74397.57%- $2,231.74
Maps & Data Sales$13,500.00$13,375.0099.07%$125.00
Miscellaneous Revenue$0.00$800.000.00%- $800.00
Interdepartment Transfers$84,500.00$84,500.00100.00%$0.00
REVENUE TOTAL$665,439.00$541,451.2981.37%$123,987.71


This table contains the CCGISC expenditure report.
EXPENDITUREBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
10/31/2018
Actual %
of Budget
Unencumbered
Balance
Personnel
Salaries & Wages$328,295.00$328,295.00$261,821.0279.75%$66,473.98
Fringe Benefits$118,755.00$118,755.00$74,495.7862.73%$44,259.22
Personnel Total$447,050.00$447,050.00$336,316.8075.23%$110,733.20
 
Commodities$20,275.00$22,140.00$15,940.7872.00%$6,199.22
 
Services
Audit$11,200.00$11,200.00$6,000.0053.57%$5,200.00
Professional Services$1,750.00$1,750.00$0.000.00%$1,750.00
Job Required Travel$500.00$500.00$492.1898.44%$7.82
Utilities$2,250.00$2,250.00$976.0543.38%$1,273.95
Computer/InfoTech Services$5,000.00$5,000.00$20.170.40%$4,979.83
Telephone Service$700.00$700.00$590.7484.39%$109.26
Equipment Maintenance$40,775.00$40,815.00$38,747.4894.93%$2,067.52
Conferences & Training$3,000.00$3,000.00$0.000.00%$3,000.00
All Other Services$8,210.00$8,210.00$683.478.32%$7,526.53
Services Total$73,385.00$73,425.00$47,510.0964.71%$25,914.91
 
Capital$28,975.00$28,975.00$0.000.00%$28,975.00
Transfer to General County Fund$4,500.00$2,595.00$0.000.00%$2,595.00
Interdepartment Transfers$84,500.00$84,500.00$84,500.00100.00%$0.00
EXPENDITURE TOTAL$658,685.00$658,685.00$484,267.6773.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