Carpinteria Unified School District 2017-18 October Budget Update
Governing Board Meeting October 24, 2017
1
Carpinteria Unified School District 2017-18 October Revised Budget-Total General Fund 2017
REVENUES: State Aid Federal Revenue Other State Revenues Local Revenues Total Revenues EXPENSES: Certificated Salaries Classified Salaries Benefits Materials & Supplies Services & Other Operating Capital Outlay Debt Expense Indirect Costs Transfer Total Expenses
Revised Budget 9-12-17
Revised Budget 10-24-17
Variance
A
B
B-A
$
23,362,040 1,142,768 2,115,753 525,867 27,146,428
$
23,480,845 1,114,724 2,355,516 612,938 27,564,023 $
118,805 (28,044) 239,763 87,071 417,595
$
11,266,291 5,046,989 7,926,849 1,270,117 2,810,748 59,166 28,380,160 $
390,979 158,699 (37,418) 167,954 229,988 910,202
(187,500) (187,500) $
56,447 (56,447)
10,875,312 4,888,290 7,964,267 1,102,163 2,580,760 59,166 -
$
27,469,958
$
(243,947) (243,947)
$
Increase (Decrease) to Fund Balance $
(567,477)
$
OTHER SOURCES/USES Transfers In Transfers Out Other Sources Other Uses Total Sources/Uses
(1,003,637) $ (436,160)
Beginning Fund Balance
$
3,721,588
$
3,721,588 $
Ending Fund Balance
$
3,154,112
$
2,717,952 $ (436,160)
Net Change to Fund Balance
-
Components of Fund Balance Revolving Cash
500
Stores Inventory
500
-
-
Restricted Resource Balances
638,571
644,163
3% Required Reserve
831,417
857,030
Unappropriated Fund Balance
$
1,683,624
$
1,216,259
2
Carpinteria Unified School District 2017-18 Summary of Changes: July – October 2017 • Changes in Revenue include: • Property Tax Increase • Reduce Local Revenue not to be received
• Changes in Expenditure include: • Salary and Benefits costs related to CAUSE Settlement Agreement • •
$ (10,491) $ (225,262)
Staffing increases Legal Costs ERA-Ed Additional Profession Assessments SBUSD TLC Program Costs
• Required Increase to Restricted Routine Maintenance Account •
$ (283,654)
Increase due to Property Tax Increase $127,633 Adjustment to 17-18 salaries due to 16-17 increase $159,621
• Miscellaneous Program Adjustments • Required Increases to Special Education including: • • • • •
$ 118,805 $ (24,000) $ 94,805
$ (11,557)
Education Code Requirement
$ (530,964)
• NET Change to Fund Balance:
$ (436,158) 3
Carpinteria Unified School District 2017-18 October Revised Budget– No Reductions
Revenues Expenditures Transfers/Other Financing Contributions to Restricted Programs
2017-18
2018-19
2019-20
2020-21
$ 27,564,023 (28,380,160) (187,500) -
$ 28,330,364 (28,987,168) (187,500) -
$ 29,471,252 (29,914,103) (187,500) -
$ 30,730,692 (30,800,473) (187,500) -
(1,003,637)
(844,304)
(630,351)
(257,281)
Excess (Deficit) of Revenues over Expenditures Beginning Fund Balance
$
3,721,588
$
2,717,951
$
1,873,647
$
1,243,296
Ending Fund Balance
$
2,717,951
$
1,873,647
$
1,243,296
$
986,015
Components of Ending Balance Reserved/assigned Minimum 3% Reserve
$
644,663 857,030
$
714,263 875,240
$
864,456 903,048
$
939,456 929,639
Unrestricted Undesignated Fund Balance Ending Fund Balance Reserve Balance %
1,216,258 $
2,717,951 7.26%
284,144 $
1,873,647 3.99%
(524,208) $
1,243,296 1.30%
(883,080) $
986,015 0.19%
4
Carpinteria Unified School District 2017-18 October Revised Budget– WITH Reductions
Revenues Expenditures Transfers/Other Financing Contributions to Restricted Programs
2017-18
2018-19
2019-20
2020-21
$ 27,564,023 (28,380,160) (187,500) -
$ 28,330,364 (28,646,205) (187,500) -
$ 29,471,252 (29,565,890) (187,500) -
$ 30,730,692 (30,444,011) (187,500) -
(1,003,637)
(503,341)
(282,138)
Excess (Deficit) of Revenues over Expenditures
99,181
Beginning Fund Balance
$
3,721,588
$
2,717,951
$
2,214,610
$
1,932,472
Ending Fund Balance
$
2,717,951
$
2,214,610
$
1,932,472
$
2,031,653
Components of Ending Balance Reserved/assigned Minimum 3% Reserve
$
644,663 857,030
$
714,263 865,011
$
864,456 892,602
$
939,456 918,945
Unrestricted Undesignated Fund Balance Ending Fund Balance
1,216,258 $
2,717,951
Reserve Balance %
Includes On-going Reductions beginning 2018-19:
7.26%
635,336 $
2,214,610 5.20%
175,414 $
1,932,472 3.59%
173,252 $
2,031,653 3.57%
(333,038)
5