Exhibit #2
INDEPENDENCE LOCAL SCHOOLS Board Meeting 10-18-2016 September 2016 Financial Reports
1
Independence Local Schools Fiscal Year 2017 Revenue Collection by Fund
Fund Description General Bond Retirement Permanent Improvement Building Food Service Endowment Uniform School Supplies Public Sch. Support Other Grants District Agency Student Managed Activity District Managed Activity State Grants Federal Grants
2
Fund 001 002 003 004 006 008 009 018 019 022 200 300 400 500
Exhibit #2
FY‐17 Amount Budgeted
Fiscal To date
Month To Date
Available Balance
% of Projected % of Fiscal % of Projected % of Fiscal Revenue Year Revenue Year Collected Completed Outstanding Remaining
$ 16,777,619 1,127,500 720,000 ‐ 301,500 ‐ 876 59,605 ‐ 12,600 225,896 96,000 277,900 106,119
$ 6,859,993 518,880 254,140 ‐ 37,463 ‐ 550 12,057 ‐ ‐ 71,441 26,751 69,831 ‐
$ 145,750 ‐ ‐ ‐ 19,062 ‐ 550 11,210 ‐ ‐ 28,259 21,347 ‐ ‐
$ 9,917,626 608,620 465,860 ‐ 264,037 ‐ 326 47,548 ‐ 12,600 154,455 69,249 208,069 106,119
40.89% 46.02% 35.30% 0.00% 12.43% 0.00% 0.00% 20.23% 0.00% 0.00% 31.63% 27.87% 25.13% 0.00%
25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
59.11% 53.98% 64.70% 0.00% 87.57% 0.00% 0.00% 79.77% 0.00% 100.00% 68.37% 72.13% 74.87% 100.00%
75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00%
$ 19,705,615 $ 7,851,105 $ 226,178 $ 11,854,510
39.84%
25.00%
60.16%
75.00%
General Fund Revenue Collection
Real Estate TPP (PUPP only) Foundation Restricted Grants Home/Roll & TPP Reimb Other/Misc.
Month End 9‐30‐2016 Actual Budget/Estimate Variance $ ‐ $ ‐ $ ‐ ‐ ‐ ‐ 60,208 62,900 (2,692) ‐ ‐ ‐ ‐ ‐ ‐ 85,542 50,000 35,542
Actual $ 6,172,485 238,473 202,115 ‐ ‐ 246,919
Total Revenue:
$ 145,750 $ 112,900 $ 32,850
$ 6,859,992 $ 6,827,142 $ 32,850
3
Fiscal Year 2017 Budget/Estimate $ 6,172,485 238,473 204,807 ‐ ‐ 211,377
Exhibit # 2
Variance $ ‐ ‐ (2,692) ‐ ‐ 35,542
Independence Local Schools Fiscal Year 2017 Expenditure Projection by Fund
Fund Description General Bond Retirement Permanent Improvement Building Food Service Endowment Uniform School Supplies Public Sch. Support Other Grants District Agency Student Managed Activity District Managed Activity State Grants Federal Grants
4
Fy‐17 Amount Fund Expendable 001 002 003 004 006 008 009 018 019 022 200 300 400 500
Exhibit #2
w/o Encumb. % of Fiscal % of Fiscal % of Projected Year % of Budget Year Expended Completed Available Remaining
Fiscal To date
Month To Date
Current Encumbrances
Available Balance
$ 3,849,646 5,434 631,873 ‐ 48,380 250 ‐ 6,787 ‐ ‐ 86,078 38,273 45,130 14,554
$ 1,606,113 ‐ 70,942 ‐ 23,719 ‐ ‐ 6,547 ‐ ‐ 57,648 15,345 34,190 13,325
$ 1,913,137 1,038,990 123,576 ‐ 32,157 ‐ ‐ 23,746 ‐ ‐ 25,296 34,922 80,617 1,405
$ 10,779,424 $ 14,566 $ 308,006 $ ‐ $ 219,869 $ 3,618 $ 3,000 $ 26,642 $ ‐ $ 12,150 $ 119,902 $ 22,804 $ 216,673 $ 90,160
23.27% 0.51% 59.42% 0.00% 16.10% 6.46% 0.00% 11.87% 0.00% 0.00% 37.22% 39.87% 13.18% 13.71%
25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
76.73% 99.49% 40.58% 0.00% 83.90% 93.54% 100.00% 88.13% 0.00% 100.00% 62.78% 60.13% 86.82% 86.29%
75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00%
$ 19,817,061 $ 4,726,403 $ 1,827,829 $ 3,273,844 $ 11,816,814
23.85%
25.00%
76.15%
75.00%
$ 16,542,206 1,058,990 1,063,454 ‐ 300,405 3,868 3,000 57,175 ‐ 12,150 231,275 96,000 342,419 106,119
General Fund Expenditure Exhibit #2
Personnel/Salaries Benefits Purchased Services Supplies Equipment Debt Service Other/Misc. Transfers
5
Month End 9‐30‐2016 Budget/Estimate Variance Actual $ 1,012,841 $ 1,128,048 $ (115,207) 314,591 345,325 (30,734) 49,747 205,001 (155,254) 123,204 85,664 37,540 99,260 122,569 (23,309) ‐ ‐ ‐ 6,470 10,737 (4,267) ‐ ‐ ‐ $ 1,606,113
$ 1,897,344
$ (291,231)
Actual $ 2,277,574 773,261 368,224 182,189 150,482 ‐ 97,915 ‐
FYTD‐2017 Budget/Estimate $ 2,392,781 803,995 523,478 144,649 173,791 ‐ 102,182 ‐
Variance $ (115,207) (30,734) (155,254) 37,540 (23,309) ‐ (4,267) ‐
$ 3,849,645
$ 4,140,876
$ (291,231)
General Fund Monthly Expense Comparison Fiscal Year 2017 vs. Fiscal Year 2016 July‐16 Expenses
Fiscal Year 2017
August‐16 Expenses
September‐16 Expenses
Total FYTD‐17 Expenses
Exhibit #2
•
September 2016 three pay month.
•
October 2015 three pay month.
3 Pay Month
Salaries Benefits Purchase Services Supplies Capital Outlay Other Expenses
$ 623,172 $ 230,356 $ 132,921 $ 24,198 $ ‐ 998
Total Expenses
$ 641,561 $ 228,314 $ 185,556 $ 34,787 $ 51,222 90,447
$ 1,012,841 $ 314,591 $ 49,747 $ 123,204 $ 99,260 6,470
$ 2,277,574 $ 773,261 $ 368,224 $ 182,189 $ 150,482 $ 97,915
$ 1,011,645 $ 1,231,887 $ 1,606,113 $ 3,849,645 July‐15 Expenses
August‐15 Expenses
Salaries Benefits Purchase Services Supplies Capital Outlay Other Expenses
617,489 230,628 68,431 7,302 10,734 1,209
713,464 291,253 238,542 74,553 115,598 84,719
Total Expenses
$ 935,793 $ 1,518,129 $ 1,169,837 $ 3,623,759
Fiscal Year 2016
September‐15 Expenses
Total FYTD‐16 Expenses
646,268 244,701 201,445 61,529 6,341 9,553
1,977,221 766,582 508,418 143,384 132,673 95,481
Over/(Under) Previous Yr. $ 75,852 $ (286,242) $ 436,276 $ 225,886
Salaries 300,353
6
Benefits Purchase Services 6,679 (140,194)
Supplies 38,805
Capital Outlay 17,809
Other Expenses 2,434
Over/Under Previous Yr. $ 225,886
Independence Local Schools Fiscal Year 2017 Cash Flow by Fund
Fund Description General Bond Retirement Permanent Improvement Building Food Service Endowment Uniform School Supplies Public Sch. Support Other Grants District Agency Student Managed Activity District Managed Activity State Grants Federal Grants
7
Fund 001 002 003 004 006 008 009 018 019 022 200 300 400 500
Exhibit #2
7/1/2016 Cash Balance
Fiscal Yr. to Date Revenue
Fiscal Yr. to Date Expenditures
9/30/2016 Cash Balance
$8,781,730 3,080,153 508,872 ‐ 4,001 7,486 10,721 30,196 ‐ 5,797 266,194 4,609 64,436 ‐
$ 6,859,993 518,880 254,140 ‐ 37,463 ‐ 550 12,057 ‐ ‐ 71,441 26,751 69,831 ‐
$ 3,849,646 5,434 631,873 ‐ 48,380 250 ‐ 6,787 ‐ ‐ 86,078 38,273 45,130 14,554
$11,792,077 3,593,599 131,139 ‐ (6,916) 7,236 11,271 35,466 ‐ 5,797 251,558 (6,913) 89,137 (14,554)
$12,764,196
$7,851,105
$4,726,403
$15,888,898
Actual Month-End General Fund Cash Balance Exhibit #2
8
Investment/Reconciliation Report Fiscal year 2017 Sep‐16
Monthly Rate Interest cytd NFS 0.55% $ 804.64 $ 5,687.58 $ 65.00 0.40% $ 3,839.14 $ 26,982.74 $ 68.00 0.15% $ 6.37 $ 215.09 $ 215.00
Star Oho Star Plus Dollar Bank Dollar Bank Dollar Bank Independence Bk Savings Independence Bk Checking Independence Bk CD Independence Bk CD Total Balance Per Bank Statement
$ 1,316,222.22 11,013,970.43 51,803.94 519,147.52 99,505.14 884,515.56 0.20% 80.83 541.51 ‐ 285,856.42 n/a ‐ ‐ ‐ 500,000.00 0.30% ‐ 1,516.67 1,500,000.00
0.30% ‐
$ 16,171,021.23
E/Z Pay Dept. not recorded Deposits In Transit NFS Outstanding Checks Outstanding Payroll checks Adjusted Total Balance Per Bank Statement
15,888,897.69
Fund Balances
15,888,897.69
1,067.00 107.60 348.00 (184,141.00) (99,505.14)
9
$ ‐
2,275.00
$ 4,730.98 $ 37,218.59
Difference
Exhibit #3
In‐Trans. ‐ H/S Café 107.60 M/S Café ‐ P/S Café $ 107.60
$348.00
Check Register Informational Item Warrants over $1,500
Check 10263 10267 10311 10475 10262 10264 10363 10467 10468 10285 10476 10406 10350 10302 10505 10496 10424 10343 10330 10388 10348 10436 10405 10286 10441 10444 10269 10298 10469 10371 10443 10319 10507 10257
10
Amount 1,525 1,531 1,532 1,540 1,614 1,778 1,792 1,902 1,913 1,959 1,985 2,100 2,118 2,351 2,402 2,544 2,660 2,688 2,696 2,767 2,794 2,892 2,899 2,995 3,192 3,204 3,220 3,778 4,166 4,240 4,413 5,078 5,078 5,153
9‐1‐2016 to 9‐30‐2016 Vendor Arslanian Bros. CED Inc. Supplyworks Tele‐Solutions, Inc. A & A Hydraulic Repair Co. AT&T Really Good Stuff Redshift Technology Responsive Learning, LP Home Depot Turnitin, LLC Rogers Athletics Bright Ideas Press PSI Associates SERS Phonak hearing Systems n2y Supplyworks Friends Business Source Dawn Sign Press Macgill supplies William Sadler, Inc. Premier Agendas, Inc. IMEX, Inc. BrainPop Carolina Biological Supplest Cleveland Electric Ohio School Council Rettig Music, Inc. WILSON LANGUAGE TRAINING Buckeye International, Inc. STRS STRS STRS
Description Carpet cleaning Stadium lights Custodial supplies Additional phones Maintenance equipment Phone services Classroom supplies Locker room Technology Instructional materials Maint/Cust. Supplies Instructional supplies Football supplies Instructional materials Contracted services Retirement benefits Special Ed. Equipment Instructional materials Sloan Faucets H/S Classroom supplies Instructional materials Classroom supplies Instructional materials Student planners Medical Evaluation Instructional materials Instructional supplies Field House upgrade Membership fees Music supplies Classroom supplies Custodial supplies Retirement benefits Retirement benefits Retirement benefits
Check 800927 10487 800925 10442 10502 10268 800929 10290 10325 10440 10489 10280 10383 10307 10481 10495 10430 10486 10336 10318 10345 10506 10320 10508 10258 10305 10261 800926 800924 800928
Amount 5,297 5,334 5,422 5,473 5,523 5,550 5,695 6,052 6,199 7,640 8,722 8,858 9,288 9,350 9,536 18,347 19,766 23,833 24,725 32,210 35,687 36,026 37,356 37,750 37,831 91,164 134,069 342,658 350,179 355,575
Vendor Medicare/Fica CZ Landscaping LLC Medicare/Fica BSN Sports Taylor Consulting Group, LLC Chargrin Valley Conf. Medicare/Fica Jay H. Berk, Ph. D, Inc. Bright Ideas Barons Bus Embassy Suites Dulles Airport Enviro Chemical BSN Sports Sherwin Williams Co. Amazon.com Nowak Tour & Travel G & G, Inc Buckeye Surface Maintenance McGraw‐Hill Education SERS Tele‐Solutions, Inc. SERS STRS STRS STRS Royal Business Equipment Co. Orange City Schools Payroll Transfer Payroll Transfer Payroll Transfer
Description Payroll benefits P/S playground Payroll benefits Athletic appraisal Roof general cont. services Conference Fee Payroll benefits Student Services Instructional materials Class trip transportation class trip hotel Custodial supplies Athletic appraisal Field house Tech./Instructional materials Class trip Auxiliary Services Asphalt BOE Instructional materials Retirement benefits Phone system Retirement benefits Retirement benefits Retirement benefits Retirement benefits Chromebook Medical Premiums
Projected General Fund Monthly Cash Flow
11
Monthly Cafeteria Report – Fiscal Year 201
FY‐17
2016 July
2016 August
2016 September
FY‐2017 Total
‐ ‐ 175 ‐ 175
5,032 6,321 6,872 ‐ 18,226
166 6,289 6,319 6,289 19,062
5,199 12,610 13,366 6,289 37,463
2,416 3,189 2,867 7,380 Total Expenditures 15,852 FY‐2017 Balance to Date: 4,001 FY‐16 2015 July Receipts High Sch. ‐ Middle Sch. ‐ Primary Sch. 190 Other 209 Total Receipts 399
2,416 3,189 2,704 500 8,809
Receipts High Sch. Middle Sch. Primary Sch. Other Total Receipts Expenditures
Total 10,795 13,493 11,674 12,418 48,380 (6,916) 2015 FY‐2016 September Total 3 pay month
High Sch. Middle Sch. Primary Sch. Other
2015 August 5,464 7,358 7,264 64 20,151
1,142 3,089 3,522 9,369 Total Expenditures 17,121 FY‐2016 Balance to Date: 1,019
12
982 3,089 3,522 500 8,093
Inc./Dec. over Previous yr. (889) 2,620 1,068 (990)
46,571 48,380
1,808
5,963 7,116 6,102 4,538 23,719
6,318 6,650 7,457 21 20,446
11,783 14,008 14,911 294 40,996
2,838 6,759 4,346 7,415 21,357
Total 4,962 12,936 11,390 17,284 46,571 (4,556)
Expenditures High Sch. Middle Sch. Primary Sch. other
Expenditure Categories: FY‐2016 FY‐2017 Expenditure July ‐ July ‐ Categories: Sept. 30 Sept. 30 Salaries 30,613 29,724 Benefits 8,156 10,775 Purch. Serv. 6,812 7,880 Supplies 990 ‐
Revenue Categories: Sales Type A Misc., Vending State Subsidy Federal Subsidy Transfer
Revenue Categories: FY‐2016 FY‐2017 July ‐ July ‐ Sept. 30 Sept. 30 40,701 37,297 294 166 ‐ ‐ ‐ ‐ ‐ ‐
Inc./Dec. over Previous yr. (3,405) (128) ‐ ‐ ‐
40,996 37,463
(3,533)
Cafeteria Meals Served Comparison FY‐15 Meals Served/# Serving Days High Sch. Middle Sch. Primary Sch. Total Meals Served FY‐16 Meals Served/# Serving Days High Sch. Middle Sch. Primary Sch. Total Meals Served
2014 2014 2014 2014 2015 September October November December January
2015 March
2015 April
2015 May
2015 June
FY‐2015 Total
27
22
16
15
17
15
22
16
20
3
173
2,415 2,085 3,320 7,820 2015 September
1,988 1,794 2,901 6,683 2015 October
1,394 1,231 2,132 4,757 2015 November
1,048 1,042 1,999 4,089 2015 December
1,526 1,306 2,177 5,009 2016 January
1,309 1,147 1,986 4,442 2016 February
1,928 1,587 2,846 6,361 2016 March
1,404 1,093 2,171 4,668 2016 April
1,482 1,359 2,404 5,245 2016 May
60 119 354 533 2016 June
14,554 12,763 22,290 49,607 FY‐2016 Total
28
21
17
17
18
19
18
16
21
1
176
2,234 2,290 3,449 7,973
1,666 1,655 2,983 6,304
1,351 1,415 2,499 5,265
1,351 1,415 2,499 5,265
1,373 1,542 2,484 5,399
1,463 1,613 2,676 5,752
1,326 1,463 2,595 5,384
1,243 1,658 2,859 5,760
1,209 1,782 2,854 5,845
3 ‐ 162 165
13,219 14,833 25,060 53,112
Inc./Dec. over previous yr.
13
2015 February
Over/Under Previous Yr:
3,505
Café: Revenue/Expenditure Summary Expenditure Categories: FY‐2016 FY‐2015 July ‐ July ‐ Expenditure Categories: June 30 June 30 Salaries 138,955 134,707 Benefits 31,999 34,515 Purch. Serv. 11,319 11,956 Supplies 115,023 104,631
Inc./Dec. over Previous yr. 4,249 (2,516) (637) 10,392
297,296 285,808
11,488
Revenue Categories: FY‐2016 FY‐2015 July ‐ July ‐ Revenue June 30 June 30 Categories: Sales Type A 207,101 180,173 Misc., Vending 1,688 1,969 State Subsidy 789 861 Federal Subsidy 43,951 44,039 Transfer 46,750 59,000
Inc./Dec. over Previous yr. 26,928 (281) (72) (89) (12,250)
300,278 286,043
14,236
Cafeteria Summary of Expenditures Expenditure Categories: Salaries Benefits Purchase Services Supplies
FY‐2016 $ 138,955 31,999 11,319 115,023
FY‐2015 $ 134,707 34,515 11,956 104,630
FY‐2014 $ 142,212 36,346 4,236 113,684
FY‐2013 $ 131,725 35,804 4,917 115,175
FY‐2012 $ 128,471 35,686 1,460 131,785
FY‐2011 $ 129,648 41,761 1,009 137,508
$ 297,296 $ 285,808 $ 296,477 $ 287,621 $ 297,402 $ 309,925 Substitute Cost:
14
10,311
4,700
11,133
4,031
4,800
7,782
Athletic: Revenue/Expenditure Summary
FUND 300 300 300 300 300 300 300 300 300 300 300 300
FUND 300 300 300 300 300 300 300 300 300 300 300
15
Beginning Balance: Description DONATIONS & GIFTS‐BOB ZUBER FUND OTHER REVENUES ATHLETICS TRANSFER IN ADMISSIONS‐BASKETBALL/BOYS ADMISSIONS‐SOCCER/BOYS ADMISSIONS‐FOOTBALL ADMISSIONS‐WRESTLING ADMISSIONS‐GIRLS SPORTS ADMISSIONS‐BASKETBALL/GIRLS ADMISSIONS‐VOLLEYBALL/GIRLS ADMISSIONS‐MIXED SPORTS DONATIONS‐‐MICKEY ZUBER FUND
$ 1,346 $ 1,434 FY16 Actual FY15 Actual ‐ 18,428 21,565 37,000 45,000 11,148 8,817 4,513 1,368 13,770 19,001 312 430 1,860 1,968 3,028 6,406 4,950 3,454 ‐ 770 ‐ 250
$ 453 $ 3,104 $ 2,133 FY14 Actual FY‐13 Actual FY12 Actual 6,250 ‐ 3,970 19,296 17,800 13,167 18,500 45,000 43,000 9,129 7,278 6,024 1,392 2,650 2,016 18,678 12,722 19,202 240 294 5,140 2,184 2,170 2,342 3,214 2,708 4,037 4,765 3,178 3,354 855 1,313 1,253 78 363 ‐
Total Receipts including Transfers:
95,009
109,029
84,581
95,476
$ 103,505
Receipts minus Transfers:
$ 58,009
$ 64,029
$ 66,081
$ 50,476
$ 60,505
Description MILEAGE REIMBURSEMENT‐ COACHES MEETS/TOURNAMENTS ENTRY FEES PURCHASED SERVICES‐MIXED SPORTS‐HS COACHES‐MATERIALS/SUPPLIES REFEREES/OFFICIALS‐BOYS SPORTS‐HS REFEREES/OFFICIALS‐GIRLS SPORTS‐HS REFEREES/OFFICIALS‐BOYS SPORTS‐MS REFEREES/OFFICIALS‐GIRLS SPORTS‐MS SUPPLIES‐SOCCER/BOYS SUPPLIES‐WRESTLING Zuber Fund
FY‐16 Actual FY‐15 Actual FY‐14 Actual FY‐13 Actual FY12 Actual $ ‐ $ 893 $ ‐ $ 702 $ 1,471 9,089 11,666 9,256 8,527 9,338 1,500 3,684 1,360 6,377 65 45,741 64,556 35,359 53,767 60,530 16,095 14,688 15,390 16,365 18,405 8,745 11,150 10,320 9,465 11,110 3,935 1,357 2,000 1,875 585 1,940 1,025 1,855 1,050 1,030 ‐ 100 ‐ ‐ ‐ 4,700 ‐ ‐ ‐ ‐ ‐ ‐ 8,060 ‐ ‐
Total Athletic Expenditures
$ 91,746
$ 109,117
$ 83,599
$ 98,127
$ 102,534
Ending Balance:
$ 4,609
$ 1,346
$ 1,434
$ 453
$ 3,104
