Comprehensive Community College: Budget Analysis Presentation
XWBusinessmail
SanJoaquinDeltaBudget1.pdf
San Joaquin Delta
Community College District
Office of Fiscal Services
5151 Pacific Avenue
Stockton, CA 95207
TO: Board of Trustees
Jeff Marsee Ph.D, Superintendent/President
District Leadership
FROM: Michael Hill, Administrative Consultant
Raquel Puentes-Griffith, Controller
SUBJECT: 2011-12 Adoption Budget
The budget development process has been much smoother this year than last. As you will see from the
presentation materials the changes from tentative to adoption are smaller in number and less dramatic
than 2010-2011. This is a more typical pattern for the unrestricted general fund portion of the budget.
The heavy lifting is normally done in preparation for the tentative budget. We do place added emphasis
on the restricted funds moving from the tentative to adoption budgets.
For the restricted funds there are no major surprises and with the effort made during this last year by the
fiscal services staff and program managers the restricted funds budgets are cleaner and reflect more
clearly the true status of programs.
Regarding the unrestricted general fund we are pleased to report that there is some revenue improvement
as a result of the state budget that was adopted but at the same time our estimate of the beginning fund
balance turned out to be higher than the actual results. We will expand on these points in this
memorandum.
We also want to provide you with a sense of what the current circumstance means for the 2012-2013
fiscal year. It has been the district strategy to approach the state funding loss in a multi-year plan and the
2011-12 budget represents the first year of the plan.
State Budget
The state budget had to confront a shortfall of $26 billion. About $13 billion was addressed back in
March through reduced funding of programs, the community colleges included. This became the best
case scenario in the evaluative process. Facing more cuts to close the gap for the remaining $13 billion,
extending taxes or a combination of both, the legislature and governor could not reach agreement on how
to proceed. The process bogged down in the usual political way.
The “May Revise” is that point where the state measures revenue flows and makes adjustments to the
revenue estimates for the next year. When that measurement occurred it was determined that the revenue
estimates could be increased which covered a portion of the $13 billion gap. In the final days of June to
get the budget out the door the revenue estimates were increased further but because there was a sense the
numbers were soft and unlikely to materialize, triggers were incorporated which would impose mid-year
cuts. The trigger date for making the determination is December 15, 2011. The triggers are as follows:
Tier 0
If between $3 and $4 billion of the new revenue materializes, no additional cuts beyond the best case will
be needed.
Tier 1
If the state only generates between $2 and $3 billion of the new revenue, then community colleges will
lose $30 million of revenue and student fees will increase from $36 to $46 a unit.
Tier 2
If less than $2 billion of the new revenue is received, then community colleges (in addition to Tier 1
actions) will lose $72 million more in revenue.
District’s Approach
While at the time we prepared the tentative budget we did not have these details the District did adopt a
strategy which is still consistent with the outcome of the final state budget. We assumed a revenue loss
greater than the best case but targeted our FTES to achieve the best case in the event funding did come
through at that level.
Given the uncertainty of the state budget and the fact that we will not truly know what the budget is until
the year is half over the present strategy is further affirmed. While this is good to know it still clouds our
ability to have clear direction on what to do about the 2012-2013 year. It appears we will need to make
budget reductions for 2012-2013 but the ultimate dollar amount is in question. Further as we look at on-
going expenses for step/column and health benefit cost increases the intense local budget pressure
remains, absent any new revenues. The District is also mindful of potential items that have budget
implications that are not included in 2011-12, but will have future budget planning implications and affect
decisions on reduction levels. These are items such as implementing recommendations of a classification
study, settlement of pending union salary issues and a possible STRS rate increase.
The Change from Tentative to Adoption Budgets
On the revenue side of the equation the state funding went up by about $1.3 million from the earlier
estimates. Please note that the District is anticipating state apportionment at the Tier 2 level. If the final
outcome is better, then clearly that will improve our revenue position. Based on the assessment from the
Chancellor’s Office, we have also incorporated a .5% one-time deficit due to the anticipated shortfall in
student fees. Apart from these items, several smaller adjustments to local revenue were made based on
end-of-year final numbers for 2010-2011. Lottery revenue was also reduced due to the lower FTES levels
in 2011-12.
We did see a net increase in the expenditure budget due to the unrestricted Lottery funding decrease
related to positions contained in the budget. There were some minor operational increases that had not
been picked up when the tentative budget was completed. The administration has been working with the
SERP results to establish what key operational positions needed to be replaced, which departments
needed to be re-worked and those results are anticipated in the budget.
One final piece of the expenditure budget has to do with incorporating carryovers. These are items that
add to the expense budget but cannot be determined until the books are closed. The prime example is
faculty travel which is governed by the CTA union contract. There are some other carryovers as well but
this one is the most significant. Up until a year ago, carryovers were a major problem for managing and
controlling the District budget. They totaled as much as $1.7 million in a recent fiscal year. This made
budget management and projections extremely difficult. Today automatic carryovers are no longer the
expectation and approved carryovers are more in line with what they should be.
The estimate of the beginning balance at the time of the tentative budget was $15.4 million. This
estimate seemed to be solid and on target for a number of months. Even as the District moved toward the
end of the year the data supported that number. Because this is the first year the District is using new
tools to manage and evaluate the budget, there was no history on what to expect at year end. June is the
catch up month for transactions since it closes out the year. There was much greater activity than was
expected and some costs came in higher than anticipated. As a result instead of a fund balance of $15.4
million, the fund balance is $13.2 million. For next year, the District will have a better understanding of
the “June dynamic” and anticipate these costs in the modeling. Further, some of the costs categories
contributing to the affect on fund balance are not expected to do so next year.
Looking Forward
The state’s financial situation is not as dire as it was but still contains substantial structural problems. The
national economic circumstance suggests that California will not see a rapid return to prosperity. This
larger picture makes planning for the next couple of years more difficult. Add to that our own internal
cost pressures and we see tough budget times at least in the short term.
The District’s fund balance while not at the level we had anticipated is still very strong and needs to be as
we wrestle with the financial issues confronting us. We need to begin now planning for the 2012-2013
year even though we lack detailed information about our funding. The greater control we exercise over
our fate, the better the outcome. As you will see from the multi-year model, there may still be some
tough decisions ahead.
The Half-full Perspective
The Delta College community worked together to put in place a reasonable, yet very lean budget for the
2011-12 fiscal year. The District will continue to provide educational opportunity to more students than
the state will support, in spite of the fiscal downturn. This budget demonstrated compassion in the way
staff reduction goals were achieved. The District has a strong financial position to take on the next
battering wave of the financial storm and there is still continuity and integrity in the educational programs
of the District. The strong financial position must be protected through constant monitoring, exercising
financial prudence and with support of the collective college community. The District in its approach to
building this budget avoided hysteria and demonstrated a quiet strength and resolve which goes a very
long way in producing confidence and support for the needed operational actions.
Attachments Included:
Attachment #
1 Impact of State Triggers on Delta
2 Major Budget Assumptions
3 Changes in Revenues 2011-12 Tentative Budget to 2011-12 Adoption Budget
4 Changes in Expenditures 2011-12 Tentative Budget to 2011-12 Adoption Budget
5 Impact on Fund Balance
6 All Funds Summary
7 All Funds Description
8 Table of Budgeted Inter-fund Transfers
9 Multi-year Analysis Based on 2011-12 State Approved Budget
Attachment 1
1
2
3
4
5
6
The State will defund the community college system by $517 million. This represents the “Tier 2”
scenario. Impact on the District – a loss of $6M million which is an estimated 1,240 FTES reduction.
The District will develop an FTES target for 2011-12 closer to the “Best Case” to protect potential
revenue enhancement. The target will be 15,000 funded FTES.
The budget anticipates mitigation of the deficit created by the state action over a three year period.
Funding reductions to categorical programs will result in reduced expenditures in those programs.
The budget reflects SERP savings net of backfill costs for key positions in District operations.
San Joaquin Delta Community College District
2011-12 Adopted Budget
September 13, 2011
General Fund Unrestricted
Major Budget Assumptions
A one-time deficit of .5% of $367k has been included in anticipation of a System shortfall in student
fees of $25M.
Attachment 2
Funded FTES Revenues
2011-12 Base 16,233 79,458,176$
Funding Reductions enacted March 2011 (1,008) (4,592,698)
Best Case Funding Level for 2011-12 15,225 74,865,478$
Tier 1 Impact - $30 million system loss* - (440,000)
Tier 2 Impact - $72 million system loss (232) (1,056,000)
District's Funding at the Tier 2 Level 14,993 73,369,478$
One-time student fee deficit .5% (367,000)
Anticipated 2011-12 Apportionment Funding 73,002,478$
*The Chancellor’s Office has indicated that Tier 1 reductions will be treated through the deficit
mechanism since it is one-time. This will not reduce the required level of FTES the district must
generate. It is expected that this will be made up through the increase of student fees from $36 to
$46 per unit in 2012-13.
Impact of State Triggers on District
September 13, 2011
2011-12 Adopted Budget
San Joaquin Delta Community College District
Attachment 3
2011-12 Tentative Budget Revenues 77,251,900$
Increases to Revenue
Tier 2 Apportionment Increase 878,000$
Facilities Event Use 146,000
Community Education 125,000
Worknet Lease, Public Surplus, Ticket Sales 132,300
1,281,300$
Decreases to Revenue
Lottery (156,600)$
Program Customer Service (42,000)
(198,600)$
Net Change from 2011-12 Tentative to 2011-12 Adopted 1,082,700$ 1,082,700
2011-12 Adopted Budget Revenues 78,334,600$
San Joaquin Delta Community College District
2011-12 Adopted Budget
September 13, 2011
General Fund Unrestricted
Changes in Revenue
Attachment 4
2011-12 Tentative Budget Expenditures 80,937,700$
Increases to Expenditures
Lottery Salaries/Benefits 156,600$
Facilities Event Use 100,000
Misc Operations 27,000
Faculty Travel Base 16,200
299,800$
Decreases to Expenditures
Salaries/Benefits Adjmts (105,400)
Community Education, Program Customer Service (84,300)
(189,700)$
Net Change from 2011-12 Tentative to 2011-12 Adopted 110,100 110,100
2011-12 Adopted Budget Expenditures Ongoing 81,047,800$
Faculty Travel Carryover (one-time) 232,000$
Student Material Carryover (one-time) 106,600
2011-12 Adopted Budget Expenditures Ongoing and One-Time 81,386,400$
San Joaquin Delta Community College District
2011-12 Adopted Budget
September 13, 2011
General Fund Unrestricted
Changes in Expenditures
Attachment 5
Fund Balance June 30, 2011 13,202,583$
Adopted Budget Revenues 78,334,600
Adopted Budget Expenditures (81,047,800)
(2,713,200)$ (2,713,200)$
2011-12 Carryovers (one-time) (338,600)$
Projected Ending Fund Balance June 30, 2012 10,150,783$
Net Operating Results for 2011-12 Adopted Budget (denotes deficit)
San Joaquin Delta Community College District
2011-12 Adopted Budget
September 13, 2011
General Fund Unrestricted
Impact on Fund Balance
Attachment 6
Fund Fund Description
Beginning Fund
Balance
Budgeted
Revenues
Budgeted
Expenditures
Projected
Ending Fund
Balance
1100 Unrestricted General 13,202,600$ 78,334,600$ 81,386,400$ 10,150,800$
1200 Restricted General 139,700 10,337,000 10,337,000 139,700
2100 Debt Service 17,529,500 3,033,300
3300 Child Development - 1,435,900 1,435,900 -
3400 Farm 97,400 190,000 190,000 97,400
3900 Redevelopment 3,207,800 316,000 2,700,000 823,800
4100 Capital Projects 1,322,600 3,138,100 4,460,700 -
4200 Measure L Bond 57,496,300 67,999,400 125,495,700 -
5100 Bookstore 1,027,500 5,901,500 6,064,000 865,000
5200 Food Service - 1,353,100 1,353,100 -
6100 Self Insurance 1,600 1,719,000 1,719,000 1,600
7100 Associated Student Trust 309,000 329,100
7200 Student Rep Fee Trust 59,700 63,100
7400 Student Financial Aid 144,800 157,200
7500 Scholarship and Loan 2,241,300 2,292,400
7900 Other Trust Funds 596,100 621,600
OPEB (Other Post
Employment Benefits) 4,619,100 4,682,400
Totals 101,995,000$ 170,724,600$ 235,141,800$ 23,257,400$
All Funds Summary
2011-12 Adopted Budget
San Joaquin Delta Community College District
September 13, 2011
Attachment 7
General Fund (11)
General Fund – Restricted (12)
San Joaquin Delta Community College District
2011-12 Adopted Budget
September 13, 2011
All Funds Description
The following fund description overview is based on the California Community College
Budget and Accounting Manual that prescribes the accounting practices and uniform coding
for all colleges in the California Community College System.
The General Fund is the primary operating fund of the district. It is used to account for those
transactions that, in general, cover the full scope of operations of the district (instruction,
administration, student services, maintenance and operations, etc.). All transactions shall be
accounted for in the General Fund unless there is a compelling reason (e.g., legal or
contractual requirement) to report them in another fund. Revenues received by or for a
community college district from State apportionments or county or local taxes (other than
moneys required to be placed in another fund) shall be deposited in the General Fund of the
district.
For purposes of flexibility, the district may establish any number of subfunds or accounts to
constitute its General Fund; however, for financial reporting, these must be consolidated into
either the Unrestricted Subfund (11) or Restricted Subfund (12). Division of the General
Fund into two subfunds reflects the need to differentiate truly discretionary revenue from
restricted revenue, while preserving a complete accounting of the financial operation and
support of educational programs. Accordingly, restricted revenues (such as those for
categorically-funded programs) are accounted separately from other general purpose
moneys, but classified as a component of the total fund that provides instructional and
support services. The General Fund is held in the treasury of the county having jurisdiction
over the community college district.
The Restricted Subfund is used to account for resources available for the operation and
support of the educational programs that are specifically restricted by laws, regulations,
donors, or other outside agencies as to their expenditure. Such externally imposed
restrictions are to be contrasted with internally created designations imposed by the
governing board on unrestricted moneys. In general, unrestricted moneys can be used for
any legal purpose deemed necessary. Restricted moneys are from an external source that
requires the moneys be used for specific purpose(s).
Moneys such as matching contributions for categorical programs are unrestricted, but may
be designated by the governing board for those purposes. Moneys designated as matching
contributions should be maintained in the General Fund, Unrestricted Subfund.
Circumstances and evidence relative to restrictions may not always be clear. The district
should seek Chancellor’s Office, legal, and/or contracted auditor consultation as needed.
Attachment 7
Bond Interest and Redemption Fund (21)
Child Development Fund (33)
Redevelopment Fund (39)
Capital Projects Fund (41)
Measure L Bond Fund (42)
Bookstore Fund (51)
This fund is to be used only to record transactions related to the receipt and expenditure of
local revenues derived from the property tax levied for the payment of the principal and
interest on outstanding bonds of the district. The fund shall be established and maintained in
the appropriate county treasury.
The Child Development Fund is the fund designated to account for all revenues for, or from
the operation of, child care and development services, including student fees for child
development services. Costs incurred in the operation and maintenance of the child care
and development services are paid from this fund. This fund is established and maintained
in the appropriate county treasury.
This fund is used to account for all other specific revenue sources that are legally restricted
to expenditures for specified purposes that are not an integral part of the district’s
instructional or administrative and support operation (e.g., dormitory replacement). This fund
may be established and maintained in the county treasury or, as an alternative, the
governing board may establish a bank account with a financial institution for each such fund
established.
The Capital Outlay Projects Fund is used to account for the accumulation and expenditure
of moneys for the acquisition or construction of significant capital outlay items, and
Scheduled Maintenance and Special Repairs (SMSR) projects. The Capital Outlay Projects
Fund is used to account for the receipt and expenditure of proceeds from the sale of district
bonds authorized pursuant to Education Code Section 15100 et seq. In general, this fund
shall be established and maintained in the appropriate county treasury and moneys shall be
used only for capital outlay purposes.
The Revenue Bond Construction Fund is used for acquisition or construction. The Revenue
Bond Construction Fund is the fund designated in Education Code Section 81961 for the
deposit of proceeds from the sale of all community college revenue bonds authorized under
the provisions of Education Code Section 81901. Such deposits are used to meet the costs
of acquisition or construction and all expenses of authorized projects (i.e., dormitories or
other housing facilities, boarding facilities, student union or student activity facilities, vehicle
parking facilities, or any other auxiliary or supplementary facilities as authorized). Proceeds
from the sale of such bonds are deposited with the county treasurer and, upon order of the
county auditor, credited to the district’s Revenue Bond Construction Fund.
The Bookstore Fund is the fund designated to receive the proceeds derived from the
district’s operation of a community college bookstore pursuant to Education Code Section
81676 when it is the intent of the governing board to recover, in whole or in part, the costs of
providing the services. All necessary expenses, including salaries, wages, and cost of
capital improvement for the bookstore may be paid from generated revenue.
Attachment 7
Food Service Fund (52)
Self Insurance Fund (61)
Associated Students Trust Fund (71)
Student Representation Fee Trust Fund (72)
Student Financial Aid Trust Fund (74)
Scholarship and Loan Trust Fund (75)
Other Trust Funds (79)
The Scholarship and Loan Trust Fund is used to account for such gifts, donations,
bequests, and devises (subject to donor restrictions) which are to be used for scholarships
or for grants in aid and loans to students. The Scholarship and Loan Trust Fund may be
established and maintained in the country treasury.
Other Trust Funds are used to account for all other moneys held in a trustee capacity by the
college or district for individuals, organizations, or clubs. Such funds may be established and
maintained in the appropriate country treasury, or as an alternative, the governing board
may establish a bank account for each trust.
The Cafeteria Fund is the fund designated to receive all moneys from the sale of food or for
any other services performed by the cafeteria when it is the intent of the governing board to
recover, in whole or in part, the costs of providing the services. Costs incurred in the
operation and maintenance of such cafeteria are paid from this fund. The term “cafeteria” as
used in this section is considered synonymous with the term “food service.”
The Self-Insurance Fund is the fund designated by Education Code Section 81602 to
account for income and expenditures of self-insurance programs authorized by Education
Code Section 72506(d). This fund is maintained in the county treasury and used to provide
for payments on deductible types of insurance policies, losses or payments arising from self-
insurance programs, and losses or payments due to noninsured perils.
The Associated Students Trust Fund is used to account for moneys held in trust by the
district for organized student body associations (excluding clubs) established pursuant to
Education Code Section 76060. The governing board must provide for the supervision of all
moneys raised by any student body or student organization using the name of the college.
The Student Representation Fee Trust Fund is used to account for moneys collected
pursuant to Education Code Section 76060.5 that provides for a student representation fee
of one dollar per semester if approved by two-thirds of the students voting in the election.
The fee is to be expended to provide for the support of governmental affairs
representatives who may be stating their positions and viewpoints before city, county, and
district governments and before offices and agencies of the State government. A student
may, for religious, political, financial or moral issues, refuse to pay the student
representation fee. Fees collected shall be under the custody of the district's chief fiscal
officer.
The Student Financial Aid Trust Fund is used to account for the deposit and direct payment
of government-funded student financial aid, including grants and loans or other moneys
intended for similar purposes and the required district matching share of payments to
students. The Student Financial Aid Trust Fund may be established and maintained in the
county treasury.
Attachment 8
Transfers Out from Unrestricted General Fund Totaling $220,000
1 Transfer of $220,000 to Child Development Fund for operational support costs.
Increase to Fund 33 Child Development Fund 220,000$
Decrease to Fund 11 General Unrestricted Fund (220,000)$
Transfers Out from Bookstore Fund Totaling $412,803.
2
Increase to Fund 52 Food Service Fund 102,142$
Decrease to Fund 51 Bookstore Fund (102,142)$
3
Increase to Fund 11 General Unrestricted Fund 310,661$
Decrease to Fund 51 Bookstore (310,661)$
San Joaquin Delta Community College District
2011-12 Adopted Budget
September 13, 2011
Table of Inter-Fund Budgeted Transfers
Transfer of $310,661 to General Fund for support salaries and
benefits.
Transfer of $102,142 to Food Service Fund for operational support
costs.
Attachment 9
State Legislated Version
FTES loss of 1,240
Unrestricted General Fund
Reflects Tier 2 of Enacted State Budget
FY 11-12 FY 12-13 FY 13-14 FY 14-15
Budgeted Revenue 84,653,000$ 78,334,600$ 79,141,600$
Adjustments 136,600
Anticipated deficit in 11-12 .5% (367,000) 367,000
Restore Tier 1 440,000
State take away $517 million, Tier 1 and 2 (6,088,000)
Revised Revenue 78,334,600$ 79,141,600$ 79,141,600$
Budgeted On going Expenses 81,047,800$ 81,047,800$ 79,928,800$
Step/Column Increases 655,000 655,000
Health Benefits Cost Increases 1,200,000 1,200,000
2nd half year of Pershing Lease (174,000)
Balance of SERP savings (300,000)
Revised expenditures 81,047,800$ 82,428,800$ 81,783,800$
Carryovers One Time 338,600$
Revenue less Expense (3,051,800)$ (3,287,200)$ (2,642,200)$ 257,800$
Planned Expenditure Reductions* 2,500,000 2,700,000
Beginning fund balance 13,202,583$ 10,150,783$ 9,363,583$ 9,421,383$
Estimated Ending Balance 10,150,783 9,363,583 9,421,383
Amount of Fund Balance Spent (3,051,800)$ (787,200)$ 57,800$
District General Reserve 5% 4,052,390 4,121,440 4,089,190
Difference 6,098,393$ 5,242,143$ 5,332,193$
* 2011-12 budget totals include reductions of $2.75 million
San Joaquin Delta Community College District
Budget Planning Scenarios
September 13, 2011
2011-12 Fiscal Year and Beyond
Please note the figures used are estimates based on current information and subject to change. Potential and significant costs
such as recommendations of a districtwide classification study, pending CTA salary issue, CalSTRS increase and other increases
will affect fund balance and could increase planned expenditure reductions.
Actual Adopted Adopted
2010-11 2010-11 2011-12
Federal 44,873$ 69,629$ 69,629$ 0.0%
State 55,794,560 50,777,712 48,591,478 -4.5%
Local 29,119,697 31,317,302 29,342,849 -6.7%
Transfers In 650,413 310,661 330,661 6.0%
Total Revenue 85,609,543$ 82,475,304$ 78,334,617$ -5.3%
Certificated Salaries 30,831,719$ 31,529,514$ 30,793,405$ -2.4%
Classified Salaries 17,973,485 19,446,646 19,069,175 -2.0%
Benefits 20,202,957 21,542,745 20,150,795 -6.9%
Supplies 1,176,276 1,739,482 1,441,297 -20.7%
Other Operating Expense 10,284,007 10,589,443 9,154,315 -15.7%
Capital Outlay 774,810 682,812 557,391 -22.5%
Transfers/Other Outgo 1,786,729 707,307 220,105 -221.3%
Total Expenditures 83,029,983$ 86,237,949$ 81,386,483$ -6.0%
Net Operating Results Revenue - Expenditures
( ) denotes a deficit 2,579,560$ (3,762,645)$ (3,051,866)$
Beginning Fund Balance 10,623,023$ 10,623,023$ 13,202,583$
Ending Fund Balance After operating results
( ) denotes a deficit 13,202,583$ 6,860,378$ 10,150,717$
Variance Adopted 2011 to
2012
San Joaquin Delta Community College District Adopted Budget - General Fund Unrestricted
2011-12
Actual Adopted Adopted
2010-11 2010-11 2011-12
Federal 2,728,442$ 3,462,707$ 2,124,233$ -63.0%
State 6,919,935 7,769,914 7,174,331 -8.3%
Local 1,054,988 989,589 1,038,427 4.7%
Transfers In 166,821 100,000 - 0.0%
Total Revenue 10,870,186$ 12,322,210$ 10,336,991$ -19.2%
Certificated Salaries 1,368,781$ 1,286,718$ 1,162,499$ -10.7%
Classified Salaries 2,959,116 3,486,714 3,134,292 -11.2%
Benefits 1,243,116 1,425,977 1,453,310 1.9%
Supplies 446,597 340,718 255,513 -33.3%
Other Operating Expense 1,561,460 3,027,287 2,533,561 -19.5%
Capital Outlay 2,279,812 1,950,409 1,145,721 -70.2%
Transfers/Other Outgo 871,597 804,387 652,095 -23.4%
Total Expenditures 10,730,479$ 12,322,210$ 10,336,991$ -19.2%
Net Operating Results Revenue - Expenditures
( ) denotes a deficit 139,707$ -$ -$
Beginning Fund Balance -$ -$ 139,707$
Ending Fund Balance After operating results
( ) denotes a deficit 139,707$ -$ 139,707$
Variance Adopted 2011 to
2012
San Joaquin Delta Community College District Adopted Budget - General Fund Restricted
2011-12
Actual Adopted Adopted
2010-11 2010-11 2011-12
Federal Food Program 93,079$ 105,803$ 109,992$ 3.8%
Federal Child Care Access - - - 0.0%
Federal/State Other Grants 912 4,189 50,000 0.0%
State Meal Reimbursement 4,932 5,885 5,885 0.0%
General Childcare 341,381 511,620 366,313 -39.7%
State Preschool 626,515 650,000 640,000 -1.6%
State Other - 3,506 3,506 0.0%
Interest 2,213 500 154 -224.7%
Parent Fees 20,795 40,000 40,000 0.0%
Other Revenue 950 - - 0.0%
Transfer From General Fund* 398,119 600,000 220,000 -172.7%
Total Revenue 1,488,896$ 1,921,503$ 1,435,850$ -33.8%
Salaries 991,911$ 1,165,129$ 821,476$ -41.8%
Benefits 445,825 519,255 472,326 -9.9%
Supplies 4,507 10,795 4,006 -169.5%
Food Supplies 44,154 99,978 80,000 -25.0%
Operating Expenses 2,226 3,042 3,042 0.0%
Indirect - 120,904 - 0.0%
New Equipment 273 2,400 5,000 52.0%
Building Improvements 50,000 100.0%
Transfers Out - - - 0.0%
Total Expenditures 1,488,896$ 1,921,503$ 1,435,850$ -33.8%
Net Operating Results Revenue - Expenditures
( ) denotes a deficit -$ -$ -$
Beginning Fund Balance -$ -$ -$
Ending Fund Balance After operating results
( ) denotes a deficit -$ -$ -$
Variance Adopted 2011 to
2012
San Joaquin Delta Community College District Adopted Budget - Child Development Center Fund
2011-12
Actual Adopted Adopted
2010-11 2010-11 2011-12
Crop Sales 194,256$ 190,000$ 190,000$ 0.0%
Total Revenue 194,256$ 190,000$ 190,000$ 0.0%
Supplies 3,007$ 2,000$ 8,500$ 76.5%
Fuel 390 5,500 3,000 -83.3%
Tools 1,814 500 - 0.0%
Utilities 14,912 18,050 16,800 -7.4%
Contract Services 18,768 23,000 23,700 3.0%
Repairs 3,796 7,500 2,500 -200.0%
Other - - - 0.0%
Crop Costs 134,134 133,450 130,500 -2.3%
New Equipment 302 - 5,000 100.0%
Total Expenditures 177,123$ 190,000$ 190,000$ 0.0%
Net Operating Results Revenue - Expenditures
( ) denotes a deficit 17,133$ -$ -$
Beginning Fund Balance 80,316$ 80,316$ 97,449$
Ending Fund Balance After operating results
( ) denotes a deficit 97,449$ 80,316$ 97,449$
Variance Adopted 2011 to
2012
San Joaquin Delta Community College District Adopted Budget - Farm Fund
2011-12
Actual Adopted Adopted
2010-11 2010-11 2011-12
Local 301,496$ 450,200$ 300,000$ -50.1%
Interest 15,828 - 16,000
Total Revenue 317,324 450,200 316,000 -42.5%
Health & Safety Improvement -$ 3,290,525$ 1,000,000$ -229.1%
Stockton Restroom Renovations - - 1,700,000 100.0%
Total Expenditures -$ 3,290,525$ 2,700,000$ -21.9%
Net Operating Results Revenue -
Expenditures ( ) denotes a deficit 317,324$ (2,840,325)$ (2,384,000)$
Beginning Fund Balance 2,890,525$ 2,890,525$ 3,207,849$
Ending Fund Balance After operating results
( ) denotes a deficit 3,207,849$ 50,200$ 823,849$
Adopted Budget - Redevelopment District Agency (RDA) Fund 2011-12
San Joaquin Delta Community College District
Variance Adopted 2011
to 2012
Actual Adopted Adopted
2010-11 2010-11 2011-12
State Construction Grant 14,046,587$ 17,115,903$ 3,080,447$ -455.6%
Scheduled Maintenance - 52,643 52,643 0.0%
Interest 4,474 12,000 5,000 -140.0%
Local Revenue 308,193 0.0%
Interfund Transfer - - - 0.0%
Total Revenue 14,359,254$ 17,180,546$ 3,138,090$ -447.5%
Capital Outlay 14,893,093$ 19,037,020$ 4,460,725$ -326.8%
Total Expenditures 14,893,093$ 19,037,020$ 4,460,725$ -326.8%
Net Operating Results Revenue - Expenditures
( ) denotes a deficit (533,839)$ (1,856,474)$ (1,322,635)$
Beginning Fund Balance 1,856,474$ 1,856,474$ 1,322,635$
Ending Fund Balance After operating results
( ) denotes a deficit 1,322,635$ -$ -$
San Joaquin Delta Community College District Adopted Budget - Capital Projects Fund
2011-12
Variance Adopted 2011
to 2012
Actual Adopted Adopted
2010-11 2010-11 2011-12
Measure L Bond - Series A, B and Refunding -$ 67,999,418$ 67,999,418$ 0.0%
Interest 374,199
Total Revenue 374,199$ 67,999,418$ 67,999,418$ 0.0%
Capital Outlay 11,086,173$ 136,207,690$ 125,495,716$ -8.5%
Total Expenditures 11,086,173$ 136,207,690$ 125,495,716$ -8.5%
Net Operating Results Revenue - Expenditures
( ) denotes a deficit (10,711,974)$ (68,208,272)$ (57,496,298)$
Beginning Fund Balance 68,208,272$ 68,208,272$ 57,496,298$
Ending Fund Balance After operating results
( ) denotes a deficit 57,496,298$ -$ -$
San Joaquin Delta Community College District Adopted Budget - Measure L Bond Fund
2011-12
Variance Adopted 2011 to
2012
San Joaquin Delta College Measure L Bond Program Financial Report as of 06/30/11
2005 Series A Release 90,000,000$ Series A Premium 1,809,984 Series A Interest 10,006,332
2006 Series A Refunded 15,500,000 Series A Refunded Premium 1,162,080 Series A Refunded Interest 1,872,409
2008 Series B Release 92,000,582 Series B Premium 2,405,257 Series B Interest 2,416,093
Budget to Date 217,172,737$ Future Releases 67,999,418
285,172,155$
Total Bond Program Expenditures
Total Bond Program Budget Reconciliation
Total Bond Program Budget FY
0 4-
05
FY 0
5- 06
FY 0
6- 07
FY 0
7- 08
FY 0
8- 09
FY 0
9- 10
FY 1
0- 11
P ro
gr am
to
D at
e
2005 Measure L Series A 17,935,370$ $ 8,033,955 13,869,194$ 30,362,081$ 31,608,781$ 6,607$ 101,815,988$ 2006 Measure L Refunded - 1,162,080 117,324 577,169 1,786,567 5,849,812 3,816,635 13,309,587 2008 Measure L Series B - - - - 16,460,586 20,820,740 7,269,538 44,550,864
17,935,370$ $ 9,196,035 13,986,518$ 30,939,250$ 49,855,934$ 26,677,159$ 11,086,173$ 159,676,439$ Total Bond Program Expenditures
Program to Date Budget
Project Expenditures by Category
Projects B oa
rd
A pp
ro ve
d
Si te
A cq
, D ev
&
P la
nn in
g
Pr og
ra m
&
Pr oj
ec t M
gm t
D es
ig n
C on
st ru
ct io
n -
In di
re ct
C on
st ru
ct io
n -
D ire
ct
G rp
II E
qu ip
O th
er *
To ta
l Ex
pe nd
ed
Closed Stkn Refurbishments 26,500 26,500 26,500 Budd Remediation (Title IX) 869,000 2,298 135,965 99,718 369,442 41,503 648,926 Central Plant Upgrade 4,100,000 73,973 198,002 573,212 3,234,006 4,079,193 Danner Safety 600,000 2,443 2,443 DeRicco Student Services 29,465,000 118,908 1,276,394 1,017,081 2,654,579 22,951,927 826,375 28,845,264 District Data Center 11,589,000 18,000 203,060 575,799 1,155,509 7,497,032 638,184 10,087,584 Facilities Master Plan 300,000 270,543 270,543 Football Track PG 5,016,000 80,718 164,524 424,554 140,502 4,181,647 11,000 5,002,945 Forum Renovations 3,890,623 - Goleman LRC 12,081,500 14,241 561,858 1,060,997 2,123,828 6,894,559 827,709 11,483,192 Holt/Budd Shop Renovations 46,000,000 10,000 10,000 Infra - Energy Mgmt System 1,000,000 112 829,401 62,476 891,989 Infra - Low Voltage 3,607,000 43,380 95,322 332,337 311,150 221,199 164,546 1,167,934 Math & Science Reserve 3,042,676 *Lodi Outreach Facility 12,257,324 15,300,000 16,515 16,515 Manteca Barn/Shade/Fence 720,000 10,637 24,129 34,766 Math & Science 46,874,311 292,949 1,239,806 3,786,495 1,721,340 5,342,763 12,383,353 Phelps Police Building Services 1,265,000 (71) 31,557 130,870 546,103 202,054 910,513 Shima CAT Program 13,300,000 6,721 624,150 414,254 152,543 3,101 1,200,769 Softball Field - Parking PT 4,247,000 66,054 156,392 372,485 152,402 3,473,224 9,000 4,229,557 South Campus MH On-Site 13,138,991 673,556 385,024 650,262 1,127,140 6,590,414 11,135 9,437,531 Valley Springs 30,000 21,855 21,855
Reserve for Arbitrage Interest Rebate 989,769 842,866 842,866 Program Contingency 2,676,535 (3,725) (3,725)
Cost of Issuance 5,377,321 5,377,321 5,377,321 Debt Reduction 11,941,892 11,941,892 11,941,892
- Total Current Projects 234,378,942$ 1,307,806$ 4,205,008$ 9,233,813$ 11,704,448$ 61,539,190$ 2,734,607$ 18,158,354$ 108,883,226$ Total Closed Out Projects 50,793,213$ 13,096,268$ 5,646,613$ 6,716,587$ 2,465,802$ 18,397,602$ 4,470,341$ -$ 50,793,213$
Measure L Bond Program 285,172,155$ 14,404,074$ 9,851,621$ 15,950,400$ 14,170,250$ 79,936,792$ 7,204,948$ 18,158,354$ 159,676,439$ * FMP Approved Project(s) listed above are comprised of multiple current budget amounts.
A ct
iv e
San Joaquin Delta College
Bond Budget Reconciliation
Measure L Bond, Refunded and State Funds
as of 06/30/11
Projects
Bond
Budget
State
Budget Total Budget
Budd Remediation (Title IX) 869,000 - 869,000
Central Plant Upgrade 4,100,000 - 4,100,000
Danner Safety Issues 600,000 - 600,000
DeRicco Student Services 29,465,000 - 29,465,000
District Data Center 11,589,000 - 11,589,000
Facilities Master Plan 300,000 - 300,000
Football Track PG 5,016,000 - 5,016,000
Forum Renovations 3,890,623 3,890,623
Goleman LRC 12,081,500 8,504,000 20,585,500
Holt/Budd Shop Renovations 46,000,000 46,000,000
Infra - Energy Mgmt System 1,000,000 - 1,000,000
Infra - Low Voltage 3,607,000 - 3,607,000
Lodi Outreach Facility 12,257,324 - 12,257,324
Manteca Barn/Shade 720,000 - 720,000
Math & Science 46,874,311 22,277,963 69,152,274
Math & Science Reserve 3,042,676 3,042,676
Phelps Police Building Services 1,265,000 - 1,265,000
Shima CAT Program 13,300,000 - 13,300,000
Softball Field - Parking PT 4,247,000 - 4,247,000
South Campus MH On-Site 13,138,991 - 13,138,991
Stockton Refurbishments 26,500 - 26,500
Stkn Restroom Renovations - -
Valley Springs 30,000 30,000
Program Contingency 2,676,535 - 2,676,535
Reserve for Arbitrage Interest Rebate 989,769 - 989,769
Cost of Issuance 5,377,321 - 5,377,321
Debt Reduction 11,941,892 - 11,941,892
Total Active Projects 234,405,442$ 30,781,963$ 265,187,405$
Total Closed Out Projects 50,766,713 17,119 50,783,832
Total Budget 285,172,155$ 30,799,082$ 315,971,237$
A c ti v e
San Joaquin Delta College
Measure L Bond Program
Program Contingency Summary
as of 06/30/11
Closed Project Name
Board Approved
Budget
Total
Expenditures
Excess Budget
to Contingency
Stkn Refurbishments 2,000,000$ (26,500) 1,973,500$
2,000,000$ (26,500)$ 1,973,500$
Beginning Contingency Balance from Q3-11 328,836$
Stkn Refurbishments 1,973,500
Interest Revenue Refunding Series A 57,707
Interest Revenue Series B 316,492
Ending Contingency Balance as of 06/30/11 2,676,535$
San Joaquin Delta College
Measure L Bond Program
Active Project Reference to Ballot Language
as of 06/30/11
1 2 3 4 5
Ref Active Projects Budget / Actual Other
Repair leaky
roofs, decaying
walls, electrical
wiring
Improve fire
safety
Remove
asbestos
Expanding/establishing
Stockton, Manteca,
Tracy, Lodi/Galt, Foothill
area
campuses/education
centers
Upgrading,
acquiring,
constructing,
equipping
buildings, sites,
classrooms
5 Budd Remediation (Title IX) 869,000.00$ -$ -$ -$ -$ -$ 648,926.00$
5 Central Plant Upgrade 4,100,000 4,079,193
5,2 Danner Safety 600,000 2,443
5 DeRicco Student Services 29,465,000 28,845,264
5 District Data Center 11,589,000 10,087,584
2,1,5,4 Facilities Master Plan 300,000 270,543
5 Football Track PG 5,016,000 5,002,945
5 Forum Renovations 3,890,623
5 Goleman LRC 12,081,500 11,483,192
5,3 Holt/Budd Shop Renovations 46,000,000 10,000
5 Infra - Energy Mgmt System 1,000,000 891,989
5 Infra - Low Voltage 3,607,000 1,167,934
4 Lofi Outreach Facility 12,257,324 16,515
4 Manteca Barn/Shade 720,000 34,766
5 Math & Science 46,874,311 12,383,353
5 Math & Science Reserve 3,042,676
5 Phelps Police Building Services 1,265,000 910,513
5 Shima CAT Program 13,300,000 1,200,769
5 Softball Field - Parking PT 4,247,000 4,229,557
4 South Campus MH On-Site 13,138,991 9,437,531
4 Valley Springs 30,000 21,855
Reserve for Arbitrage Interest
Rebate 989,769 842,866
Program Contingency 2,676,535 (3,725)
Cost of Issuance 5,377,321 5,377,321
Debt Reduction 11,941,892 11,941,892
Closed Projects 50,793,213 398,858 1,665,270 805,471 27,484,582 20,439,032
Measure L Bond Program 285,172,155$ 18,158,354$ 398,858$ 1,665,270$ 805,471$ 37,265,792$ 101,382,694$
Measure L Bond Total Expenditures 159,676,439$
Measure L Ballot Language
San Joaquin Delta Community College District College
Capital Projects, Measure L Bond, and Redevelopment Funds
Project List
6/30/2011
Beginning Fund Budgeted Budgeted
Projected
Ending Fund
Balance Other Total Balance
Measure L Bond - Series A, B and Refunding 57,496,298$ 67,999,418$ 125,495,716$ -$
-
Stkn Restroom Renovations (RDA Funds) 1,700,000 1,700,000 -
Health & Safety Improvements (RDA Funds) 1,000,000 1,000,000 -
RDA Unallocated 507,849 316,000 823,849
-
09 Pool Replaster & Repair Phase II 52,643 52,643 105,286 -
Goleman LRC - Construction 37,772 37,772 -
Cunningham Math & Sci - Construction 3,042,675 3,042,675 -
Student Services System 721,376 721,376 -
Timekeeping System 126,180 126,180 -
Artificial Turf 65,000 65,000 -
Energy Savings 285,595 285,595 -
Loading Dock Repair 1,200 1,200 -
Upgrade Mailboxes 35,139 35,139 -
Capital Projects Unallocated 35,502 5,000 40,502 -
Total Projects 62,026,782$ 71,453,508$ 132,656,441$ 823,849$
Actual Adopted Adopted
2010-11 2010-11 2011-12
Book Sales 5,287,810$ 6,828,201$ 4,775,655$ -43.0%
Merchandise Sales 1,189,405 1,287,288 1,085,909 -18.5%
Other Revenue 29,030 10,700 40,000 73.3%
Total Revenue 6,506,245$ 8,126,189$ 5,901,564$ -37.7%
Cost of Goods Sold 4,477,009$ 5,496,000$ 3,997,801$ -37.5%
Salaries 747,840 890,186 734,793 -21.1%
Employee Benefits 243,131 311,867 269,115 -15.9%
Supplies 22,802 4,700 4,700 0.0%
Freight Out 101,163 23,500 40,000 41.3%
Banking, Travel, Dues 2,345 7,500 - 0.0%
Credit Card Fees 77,703 100,000 95,802 -4.4%
Equipment - - - 0.0%
Rental Expense 200,000 200,000 200,000 0.0%
Other Expense 165,748 169,500 42,500 -298.8%
Depreciation Expense 9,534 20,000 17,000 -17.6%
Total Operating Expenditures 6,047,275$ 7,223,253$ 5,401,711$ -33.7%
Other Expenditures: Student Handbook (4,315)$ 15,000$ 63,000$ 76.2%
Transfers Out:
Food Service 457,452$ 245,960$ 102,142$ -140.8%
Nonresident Tutors - - - 0.0%
Student Associations - - - 0.0%
Drama - - - 0.0%
Support Salaries 310,661 310,661 310,661 0.0%
Promotion 150,000 150,000 150,000 0.0%
Intramurals 900 900 900 0.0%
Competitions 35,600 35,600 35,600 0.0%
Total Bookstore Transfers 954,613$ 743,121$ 599,303$ -24.0%
Total Expenditures 6,997,573$ 7,981,374$ 6,064,014$ -31.6%
Net Operating Results Revenue - Expenditures
( ) denotes a deficit (491,328)$ 144,815$ (162,450)$
Beginning Fund Balance 1,518,871$ 1,518,871$ 1,027,543$
Ending Fund Balance After operating results
( ) denotes a deficit 1,027,543$ 1,663,686$ 865,093$
San Joaquin Delta Community College District Adopted Budget - Bookstore Fund
2011-12
Variance Adopted 2011 to
2012
Actual Adopted Adopted
2010-11 2010-11 2011-12
Food Sales 1,021,908$ 1,363,606$ 1,041,000$ -31.0%
Catering Sales -$ -$ 200,000$ 100.0%
Other Revenue 101,264 86,000 10,000 -760.0%
Total Revenue 1,123,172$ 1,449,606$ 1,251,000$ -15.9%
Cost of Sales 519,417$ 561,550$ 457,500$ -22.7%
Salaries 646,679 612,450 503,259 -21.7%
Employee Benefits 205,178 268,982 180,649 -48.9%
Supplies 76,775 70,200 71,100 1.3%
Sales Tax 10,090 21,000 15,000 -40.0%
Laundry 23,659 18,000 - 0.0%
Repairs 659 2,200 1,200 -83.3%
Uniforms 2,356 2,400 2,500 0.0%
Rental Expense 79,184 79,184 79,184 0.0%
Other Expense 8,932 52,300 37,950 -37.8%
Non-Consumable Supplies - 3,500 - 0.0%
New Equipment 4,043 1,000 100.0%
Depreciation 3,652 3,800 3,800 0.0%
Total Expenditures 1,580,624$ 1,695,566$ 1,353,142$ -25.3%
Net Operating Results Revenue - Expenditures
( ) denotes a deficit (457,452)$ (245,960)$ (102,142)$
Trfr From Bookstore 457,452 245,960 102,142 -140.8%
Beginning Fund Balance -$ -$ -$
Ending Fund Balance After operating results
( ) denotes a deficit -$ -$ -$
San Joaquin Delta Community College District Adopted Budget - Food Service Fund
2011-12
Variance Adopted 2011 to
2012
Actual Adopted Adopted
2010-11 2010-11 2011-12
Interest 12,779$ 17,840$ 13,000$ -37.2% Contributions from Other
Funds 1,982,666 1,714,250 1,706,000 -0.5%
Transfers In 975,000 - - 0.0%
Total Revenue 2,970,445$ 1,732,090$ 1,719,000$ -0.8%
Insurance Premiums 610,123$ 651,638$ 694,400$ 6.2%
Other Operating Expense 2,778,970 1,209,665 979,600 -23.5%
Equipment 29,293 28,083 45,000 37.6%
Transfers Out 250,000 - - 0.0%
Total Expenditures 3,668,386$ 1,889,386$ 1,719,000$ -9.9%
Net Operating Results Revenue - Expenditures
( ) denotes a deficit (697,941)$ (157,296)$ -$
Beginning Fund Balance 699,585$ 699,585$ 1,644$
Audit Adjustment -$
Ending Fund Balance After operating results
( ) denotes a deficit 1,644$ 542,289$ 1,644$
Variance Adopted 2011 to
2012
San Joaquin Delta Community College District Adopted Budget - Self Insurance Fund
2011-12
