Desert Sands Unified School District

___________________________________________ Fiscal Year 2013-2014

FIRST INTERIM FINANCIAL REPORT Conference Item Presented To: Board of Education December 17, 2013

___________________________________________

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements The District’s Budget is formed around a set of basic assumptions and formulas.

Enrollment Enrollment was projected to remain level in the assumptions used for adopted budget. The chart below represents the enrollment on CBEDS day. CBEDS is an annual collection of basic student and staff data by the California Department of Education. Data is collected based on a specific Information Day – designated as the first Wednesday in October. For 2013/2014, this date was October 2, 2013. CBEDS enrollment is used by the District to allocate clerical staffing and school site discretionary funds.

K-12 CBEDS ENROLLMENT Does NOT include Charter School Enrollment

27,150 27,100 27,050 27,132

27,095

26,986

26,981

27,000 26,950 26,900 2010/2011

2011/2012

2012/2013

2013/2014

2013/2014 CBEDS Enrollment has not been certified.

Enrollment by grade levels: Elementary Schools (TK-5) Middle Schools (6-8) High Schools (9-12) Continuation (9-12) Alternative Education (K-12) Non-Public Subtotal Charter Schools (K-8) Total K-12 Enrollment

12,036 5,399 8,573 677 295 1 26,981 2,175 29,156

41.3% 18.5% 29.4% 2.3% 1.0% 0% 92.5% 7.5% 100%

Page 1

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements Although enrollment projections are used to estimate the facilities and staffing needs, the state funding, Local Control Funding Formula, is now provided to the District based on average daily attendance per grade span.

K-12 Average Daily Attendance K-12 ADA HISTORY 26,000.00 25,625.10

25,605.92

94.6%

94.4%

25,428.21

25,438.47

25,500.00 94.2%

94.3%

25,000.00 2010/2011

2011/2012

2012/2013

2013/2014

Does NOT include Charter School ADA

K-12 ADA HISTORY BY GRADE SPAN YEAR 2013/14 2012/13 2011/12 2010/11

TK-3 7,587.32 7,622.81 7,702.64 7,668.80

4-6 5,576.57 5,716.00 5,684.69 5,772.70

7-8 3,526.88 3,410.46 3,526.19 3,564.60

9-12 8,747.70 8,678.94 8,692.40 8,619.00

TOTAL 25,438.47 25,428.21 25,605.92 25,625.10

Average Daily Attendance for K-12 is projected to be 94.3% of CBEDS enrollment. The Average Daily Attendance for current year is projected to be 27,548. This projection includes regular education, special education, and charter school ADA. Breakdown of ADA Projection: District K-12 ADA 25,438 Non-Public 1 County Spec Ed/Community School 35 Palm Desert Charter Middle 1,277 Washington Charter School 797 Total ADA Projection: 27,548

Page 2

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements Local Control Funding Formula The 2013/2014 state budget package, Chapter 47, Statutes of 2013, replaces the previous finance system for K-12 education with a new Local Control Funding Formula (LCFF). For school districts and charter schools, the LCFF creates base, supplemental, and concentration grants in place of most previously existing K-12 funding streams, including revenue limits and most state categorical programs. A list of those programs requiring adjustments are listed on page 5. Under the new formula, districts receive the bulk of their funding based on average daily attendance (ADA) in four grade spans. The grade span target base rates were linked to the differentials in 2012/2013 statewide average revenue limit rates. 2020/2021 ADJUSTED TARGET BASE RATES Grade Span TK – 3 4-6 7-8 9-12

Target Base Rate $7,675 $7,056 $7,266 $8,638

In addition to the target base rates, there are adjustments to TK-3 and high school base rates. The TK-3 adjustment is 10.4% of the base and intended to cover costs associated with class size reduction in this grade span. Under full implementation of LCFF, as a condition of receiving the TK-3 base rate adjustment, districts must maintain a TK-3 school-site average class size of 24 or fewer students, unless collectively bargained otherwise. The high school adjustment increases the base by 2.6% and is being provided to provide career technical education (CTE) in high school. The adjusted target base rates beginning in 2013/2014 are updated for cost of living adjustments. The LCFF provides supplemental funding for formula, each English learner (EL)/Low Income an additional 20% of the qualifying student’s Students who are both EL and LI are counted count).

particular student groups. Under the (LI) student and foster youth generates adjusted grade span target base rate. only once (known as an unduplicated

Districts whose EL/LI populations exceed 55% of their enrollment receive concentration funding. The formula for concentration funding adds an additional 50% of the adjusted target base grant for EL/LI student above the 55% threshold. The LCFF funds include two existing programs – Targeted Instructional Improvement Block Grant (TIIG) and Home-to-School (HTS) Transportation – as add-ons to the base rate funding. The add-on amount will be equivalent to the same amount received in 2012/2013. Starting in 2013/2014, districts receiving the HTS add-on will be required to spend the same amount of those funds for HTS as they spent in 2012/2013. Page 3

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements Fully implementing the LCFF would cost the state an additional $18 Billion. Given the cost, coupled with projected growth in Proposition 98 funding, fully implementing the new system is anticipated to take eight years. The LCFF implementation statute ensures that no district is to receive less in 2013/2014 under LCFF funding than it received last year for revenue limits (calculated on a per– ADA basis) and categorical programs (calculated based on the district’s total entitlement). This is referred to in the calculation as the Formula Floor. Over the course of implementation, districts will receive new funding based on the difference (or gap) between their prior–year funding level and their target LCFF funding level. Every district will see the same proportion of their gap closed, but the dollar amount they receive will vary depending on the size of their gap. Using the LCFF calculator provided by the Fiscal Crisis & Management Assistance Team (FCMAT), a state supported agency, the following factors were used to prepare the adjustments included in the First Interim Report. Components of LCFF Target (2020/2021) Entitlement $191,665,674 Base Grant 5,485,632 K-3 Grade Span Adjustment 1,922,531 9-12 Grade Span Adjustment 27,079,115 Supplemental Grant 12,946,384 Concentration Grant 2,539,269 Add-Ons (TIIG & HTS) Total $241,638,605

2013/2014 PROJECTED LCFF FUNDING LCFF Target Less – Formula Floor Difference or Gap

$241,638,605 (154,576,711) $ 87,061,894

11.7% Gap Funding Rate Increase Plus Formula Floor Projected LCFF

$ 10,210,094 $154,576,711 $164,786,805

In addition to adopting a new funding formula, Chapter 47 establishes a set of new rules relating to school district transparency and accountability. Specifically, under the new rules, districts are required to adopt Local Control and Accountability Plans (LCAPs) that disclose how funds will be spent to provide high–quality educational programs.

Page 4

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements LCFF revenues provide 73% of the funding received by our District within the General Fund. The First Interim Financial Report establishes and increases the current year LCFF funding in the amount of $29,781,320. Note the LCFF offset adjustment which decreases other state revenues. In addition to LCFF revenues, new or adjusted grant award letters have been received for the following federal, state and locally funded programs:

Federal Revenue Carl Perkins

Indian Education

Title II – Administrator Training

An increase of $22,817 to federal revenues and corresponding expenditure accounts is reflected in this financial statement.

Other State Revenue The LCFF funding model eliminates specific categorical revenues for the following programs and will require an adjustment for this report. Advanced Placement Fee Waiver Community Based English Tutoring Economic Impact Aid Gifted & Talented Education Home-to-School Transportation International Baccalaureate Diploma Program Oral Health Assessments Professional Development Block Grant School and Library Improvement Block Grant School Safety Competitive Grant Summer School Programs

California High School Exit Exam Deferred Maintenance Educational Technology Grade 7-12 Counseling Instructional Materials Block Grant K-3 CSR Principal Training Professional Development for Math & English School Safety & Violence Prevention Staff Development Teacher Credentialing Block Grant

Adjusted grant awards: Agriculutral Career Technical Education Incentive California Partnership Academy

Partnership Academy Mandated Costs

The decrease of ($19,184,001) to other state revenue includes the LCFF credit offset to account for LCFF revenue implementation and adjusted awards.

Page 5

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements

Local Revenue Advanced Placement Testing Coachella Valley Economic Partnership Transportation – Local Funding

City of Indian Wells Kaboom

An increase of $138,736 revenue and corresponding expenditure accounts is reflected in this financial statement.

General Fund Revenue Sources

Combined General Fund Revenues Other State Revenue 5%

Other Local Revenue 14% LCFF Funding 73%

Federal Revenue 8%

Page 6

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements

Lottery Funding Lottery revenue is conservatively budgeted at a total of $145.00 per prior-year annual Average Daily Attendance. This per-pupil rate reflects $121.00 per pupil for unrestricted lottery revenues and $24.00 per pupil for restricted lottery revenues (instructional materials). The State Lottery Commission has projected an increase in lottery funding. This will be watched closely for future budget adjustments. Lottery provides approximately 1.5% of the general fund total revenues.

District Lottery Designations: Testing Elementary School Counselors K-5 Staffing Ratio K-5 Prep Period Coverage 6-8 Staffing Ratio Student Assistance Program Curriculum Development International Baccalaureate Fees Student/Community Events Textbooks Curriculum/Instructional Materials Total:

391,777 959,894 92,153 912,123 228,877 9,646 16,000 51,724 602,500 198,540 $3,463,234

Textbooks The budget includes $821,184 towards the purchase of textbooks. This allocation is a combination of lottery funds, categorical grants and LCFF funding.

Page 7

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements Employees The certificated bargaining unit employees are represented by Desert Sands Teachers Association (DSTA). The classified bargaining unit employees are represented by California School Employees Association (CSEA).

Certificated Staffing Ratios Regular Classroom Teachers – Staffing goals for classroom teachers are listed below: Does not include QEIA School Sites (Eisenhower & Hoover).

TK - 3 4-5 6-8 9-12

One classroom teacher for each 33 students enrolled* One classroom teacher for each 34 students enrolled** One classroom teacher for each 33 students enrolled** One classroom teacher for each 32 students enrolled

*LCFF funding for TK-3 includes adjustments that require districts to reduce class size proportionate to target funding rate percentage by school site. Full implementation will result in 24:1 class size in a projected eight years. **Class size penalty waivers for 34:1 staffing in grades K-8 have been authorized from the California Department of Education through June, 2014.

Elementary School Prep Period In addition to the regular classroom teacher allocation, the elementary schools are provided full time equivalent (FTE) funding allocations for preparation period coverage. The General Fund cost associated with providing elementary school prep periods is estimated to be $2,077,788.

Classified Staffing Ratios Classified School Support – The clerical support staffing ratios for the full time equivalent (FTE) classified positions per child enrolled at CBEDS is as follows: Elementary School Ratio Middle School Ratio High School Ratio

-

.0035 FTE positions .0060 FTE positions .0065 FTE positions

Page 8

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements Custodial Allocation: 42,000 Square Feet = 1 Custodian Noon Yard Supervisor Allocation: Elementary Schools 2.75 hours per day per 100 students enrolled at CBEDS Middle Schools .60 hours per day per 100 students enrolled at CBEDS

Step/Column Increases The cost for step/column increases has not changed since the budget was adopted. The cost of step/column increases to all funds, including fixed charges is $2,191,529 or 1.14% of the total cost of budgeted salaries and benefits. Step/Column increases are salary increases afforded to employees based on years of service and/or credit for professional growth.

Growth/Restoration Positions The following positions have been added to the budget since budget adoption: Site Various Various Various Various Glenn Middle Special Ed Special Ed Educational Svcs Various Maintenance La Quinta High Various Transportation

Position Classroom Teachers – K-3 CSR (7) Secondary Classroom Teachers (5) Resource Teacher (2) Special Day Teacher (4) Counselor (1) Behavioral Specialist (2) Psychologist (.5) Career Technical Education Administrator Custodians (5) HVAC Mechanic (1) Security Agent (1) Para-Special Education SD (3) Vehicle Maintenance Supervisor (1)

Funding Source General Fund General Fund Special Education Special Education General Fund Mental Health Mental Health Local Grant General Fund Routine Maintenance Facilities Special Education Transportation

Page 9

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements School Site Formulas School site formulas for discretionary allocations were budgeted at 2010/11 levels of funding. Allocations are at the following rates per CBEDS enrollment: Elementary Schools Middle Schools Continuation/Alt Ed High Schools

$ 48.46 per CBEDS $ 60.58 per CBEDS $ 65.67 per CBEDS $ 106.85 per CBEDS* *Includes athletic field trip allocations

In addition to the discretionary allocations listed above, each comprehensive high school receives flat rate allocations for maintenance, operations and extra-duty security personnel as well as equipment replacement.

Discretionary Allocation Per CBEDS History Fiscal Year Elementary Middle Cont/Alt Ed High Schools

2013/2014 2011/2012 2009/2010 $48.46 $48.46 $60.00 $60.58 $60.58 $73.40 $65.67 $65.67 $77.26 $106.85 $106.85 $125.71

K-12 Summary Following is a brief overview of the number of school sites the District currently encompasses. As a comparison, 10 years ago – in 2003/2004; the District had a total of 28 school sites and student enrollment of 26,122. Elementary Schools (K-5)......................................19 Charter Schools (K-8) ..............................................2 Middle Schools (6-8) ...............................................6 High Schools (9-12) .................................................4 Continuation School (9-12)......................................2 Alternative Education School ..................................1 Total K-12 Schools ...............................................34 Over the past 10 years, the District has added 6 school sites and experienced a 11.6% enrollment growth, or 3,034 students. An enrollment history is provided on page 35 of this document.

Page 10

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements

General Fund Expenditure Summary Materials/ Supplies 6%

Services, Operating Capital Outlay 1% Expenses, Indirect Costs 8%

Certificated Salaries 47%

Benefits/Fixed Charges 23% Classified Salaries 15%

Salaries and employee benefits account for 85% of the general fund operating budget.

Expenditure Budget Summary Although the previous chart indicates that 85% of the general fund budget is allocated to salaries and benefits, the following data is provided to show the difference between the unrestricted general fund and the restricted general fund commitments. Description

Unrestricted

Restricted

Salaries, Benefits & Fixed Charges ............................... 90.0%......................... 74.2% Materials & Supplies........................................................ 3.5%......................... 11.9% Services, Operating Expenses, Indirect ........................... 5.7%......................... 12.7% Capital Outlay .............................................................. …0.4%........................... 1.2% Total First Interim Budget ...........................................100%..........................100%

Page 11

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Key Elements

Cash The greatest single revenue source in the general fund is the LCFF funding. At the current reporting, the LCFF calculation is $164,786,805. The amount received is dependent on Average Daily Attendance (ADA), but received by the District in three distinct revenue streams. Property taxes (secured and unsecured), supplemental taxes and community redevelopment taxes provide approximately $34.4 million after passing in lieu taxes to the charter schools or 21% of the LCFF funding. Property taxes are received in full by June 30th of each year. The second revenue stream is termed as “State Aid” and received from the state in timed increments. The third stream of revenue is the Education Protection Account (EPA). The EPA cash transfer is expected to post on a quarterly basis this year. The First Interim Cash Flow is included in the State documents.

Multi-Year Projections The Multi-Year Projections are developed based on the planning factors provided by Fiscal Crisis & Management Assistance Team, School Services of California and/or the recommendations by the Riverside County Superintendent of Schools. In previous years, under Revenue Limit funding, increases to revenues were attributed to growth funding and/or cost of living adjustments (COLA). Under LCFF funding, fluctuation in revenues can be additionally attributable to the variation in grade span enrollment and the unduplicated percentage for students eligible for the Free and Reduced Price Meal Program used to identify the Low Income count and EL identification. The Dartboard has been modified to include projected percentages of unduplicated counts for EL/LI as well as to identify District assumptions.

The Multi-Year Projections and General Fund Projection Dartboard begin on page 26.

Page 12

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Criteria & Standards  Based upon the current projections, the cash balance will be positive at the end of the current year.  Based upon current projections, the fund balance will be positive at the end of the current and subsequent two years.  The district’s required percentage reserve is 3%. The recommended minimum reserve amount is $6,941,415.  The certificated employee bargaining unit negotiations are ongoing. The cost of 1% is $1,049,610.  The classified employee bargaining unit negotiations are ongoing. The cost of 1% is $413,259.  Total FTE’s included in this report:

2,319.24

General Fund All Other Funds Administrative 4.00 Certificated 1,213.23 83.10 Classified 738.04 159.87 Confidential 10.00 Management 101.3 9.70 Totals 2,066.57 252.67

Multi-year Commitments Type of Commitment General Obligation Bonds Certificates of Participation Capital Leases Early Retirement Incentive

#Yrs 19 10 1 4

Balance

2013/2014

342,156,778 53,423,327 27,549 3,827,639

44,021,012 6,990,725 28,805 1,874,059

Page 13

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Washington Charter School The following is an overview of the finances for Washington Charter School. complete report is provided to their Charter Board and available upon request.

A

CBEDS Enrollment: The 2013/2014 unverified CBEDS enrollment is 835 students. Fiscal Year

2013/2014

2012/2013

2010/2011

2010/2011

Enrollment

835

835

768

768

Revenue Limit Funding Washington Charter School has adjustments to reflect the transition to LCFF funding in the First Interim Report. Calculated LCFF Target: Grade Level TK-3 4-5

Base $6,952 $7,056

CSR $723

Supplemental $522 $480

Washington Charter School Total Base Projections for the 2013/2014 school year is $4,729,225 (Included in this total is the Education Protection Account Funding in the amount of $735,343).

The following is funding utilized for the 2013/2014 school year at Washington Charter School.

Funding California Clean Energy Jobs Act Common Core State Standards Lottery Mandate Block Grant Title II Title III

Allocation Purpose $53,947 Reduce energy consumption $167,000 Technology, Common Core Instructional Materials & Staff Training $123,360 Counselor Salary and Core Curriculum Materials $10,999 Mandate Reimbursement $40,432 Teacher Professional Development $19,720 Support English Language Learners

The Washington Charter School reserve exceeds the 3% minimum reserve requirements.

Page 14

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Palm Desert Charter Middle School The following is an overview of the finances for Palm Desert Charter Middle School. A complete report is provided to their Charter Board and available upon request.

LCFF Funding Palm Desert Charter Middle School adjustments for the LCFF funding are included in the First Interim Report. Calculated LCFF Target: Grade Level 4-6 7-8

Base $7,056 $7,266

Supplemental $685 $705

Palm Desert Charter Middle School Total Base Projections for the 2013/2014 school year is $7,656,862 (Included in this total is the Education Protection Account Funding in the amount of $1,195,996). Unverified enrollment for the 2013/2014 school year is projected to be a total of 1,340 students. The following is funding utilized for the 2013/2014 school year at Palm Desert Charter Middle School.

Funding California Clean Energy Jobs Act Common Core State Standards Mandate Block Grant Title II Title III Lottery City of Palm Desert

Allocation Purpose $109,702 Reduce energy consumption $267,800 Technology, Common Core Instructional Materials & Staff Training $17,883 Mandate Reimbursement $64,837 Class Size & Professional Development $15,123 Support English Learners $287,668 School Counselor/Project Teacher and Core Curriculum Materials $75,000 BRIDGES After School Program

The Palm Desert Charter Middle School reserve exceeds the 3% minimum reserve requirements.

Page 15

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT

Capital Facilities Funds Prepared by: Patrick Cisneros, Director of Facilities Services and Yolanda Garcia, Budget Technician

Developer Fees The budgeted amount of $1,500,000 reflects a conservative estimate for 2013/2014 revenues. Total fees collected through October 31, 2013 are $578,943.

Measure K Projects Timeline of Modernization Projects • •

2011-2017 2012-2014

Indio High School La Quinta High Career Technical Education and Two Story Classroom Building (Portable Replacement)

Special Reserve Fund for Capital Outlay Projects • • •

$6.5 million in “pass-thru” revenue budgeted for fiscal year 2013/2014 $1.8 million in Certificates of Participation for Indio High School reconstruction project. $7.0 million budgeted for debt service payments

Page 16

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT

Fund Classifications General Fund – Unrestricted – This fund is used to account for the ordinary operations of the school district. Examples of expenditures reported in this account are direct classroom instruction, school administration, counseling, district administration, custodial, grounds and security. General Fund – Restricted – This fund is used to account for restricted projects or activities within the general fund that must be identified and reported separately from unrestricted projects or activities. Examples of programs accounted for in this fund are special education, plant maintenance, federal, state and local grants. Charter School Fund – This fund is used to account for the activities of Washington Charter School and Palm Desert Middle Charter School. Adult Education Fund – This fund is used to account specifically for educational programs that serve adults. Child Development Fund – This fund can only be used to account for expenditures of operating early childhood education programs. The district currently operates a State Preschool Program and a Child Development Program within this fund. Cafeteria Special Revenue Fund – This fund shall only be used to account for the revenues and expenditures of operating a food service program. Deferred Maintenance Fund – This fund is restricted to specific areas of major repair or replacement to the buildings and grounds area. The district required match has been suspended due to the economic crisis. Capital Project Funds – These funds are used to account for the financial resources and expenditures (as designated by Education Code) for the acquisition or construction of major capital facilities projects. Following is a summary of the district funds:    

Building Fund – Proceeds from the sale of bonds Capital Facilities Fund – Developer fee collections County School Facilities Fund - State apportionments for construction. Special Reserve Fund - Redevelopment Pass-thru

Bond Interest & Redemption Fund – This fund is used to accumulate property tax payments for the repayment of bonds issued for the district. Self-Insurance Fund – This fund is used to account for the activities involved with managing the districts self-insured workers’ compensation program and retiree benefits.

Page 17

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT Expenditure Classifications Certificated Personnel Salaries Certificated salaries are salaries that require a credential or permit issued by the Commission on Teacher Credentialing. Examples of certificated personnel: Teachers Nurses

Principals Psychologists

Librarians Coordinators

Counselors Superintendent

Classified Personnel Salaries Classified salaries are salaries that do not require a credential or permit. Examples of classified personnel: Para-educators Admin Assistants Electricians Bus Drivers

Accountants Clerks Custodians Mechanics

Supervisors Plumbers Security Agents Community Aides

Cafeteria Workers Carpenters Delivery Drivers Computer Techs

Employee Benefits This classification is used to account for contributions to employee retirement plans, health and welfare benefits, state unemployment insurance, social security, medicare and workers’ compensation associated with certificated and classified personnel salaries.

Books & Supplies Expenditures for the purchase of instructional materials, books, fuel, paper, pencils, Chrome books, and magazine subscriptions are recorded in this category. Site carryover funds are often placed in this category until they are allocated to their specific line item object code series.

Services & Other Operating Expenditures This classification is used to record expenditures for services, rents, leases, software licenses, contracts, dues, repairs by vendors, travel, insurance, utilities, and legal expenses.

Page 18

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 FIRST INTERIM FINANCIAL REPORT

Expenditure Classifications Capital Outlay Expenditures for the purchase of sites, buildings, and capitalized equipment, such as school buses are recorded in this classification.

Other Outgo This classification is used to account for tuition payments to non-public schools (severely handicapped students) as well as other transfers to outside educational agencies (County Community Schools).

Program/Fund Support This classification is used to account for the indirect cost that can be charged to categorical programs or other funds for the support provided by the General Fund. The indirect cost rate for 2013/2014 is 4.48%. Interfund Transfers Out This classification is used to account for any contribution from the General Fund (restricted or unrestricted) to another fund maintained by the district. One example of this classification is the transfer for the flow-through funds of the redevelopment agency agreements; funds are received in the restricted general fund and transferred out to the special reserve fund as required. Following is a table of the budgeted General Fund Interfund Transfers Out: Program Child Development Center Support Redevelopment Pass-thru Total Interfund Transfers Out

Amount 33,750.00 6,578,959.00 6,612,709.00

Page 19

Desert Sands Unified School District

Revenues, Expenditures & Changes in Fund Balance

General Fund Unrestricted General Fund First Interim Financial Report Beginning Balance Revenues LCFF Revenue Federal Revenue Other State Revenue Local Revenue Total Revenues

Adopted Budget

Operating Budget Oct 31, 2013

Projected Budget

Difference

9,426,687

10,331,035

10,331,035

130,293,793 269,344 18,141,652 1,446,906 150,151,695

130,293,793 269,344 18,141,652 1,455,926 150,160,715

164,786,805 269,344 4,248,855 2,389,321 171,694,325

34,493,012 0 -13,892,797 933,395 21,533,610

Expenditures Certificated Salaries Classified Salaries Employee Benefits Supplies Services Capital Outlay Other Outgo Program/Fund Support Total Expenditures

83,020,091 15,763,265 34,398,310 2,277,423 10,502,913 0 33,755 -1,496,431 144,499,326

82,589,149 15,778,362 34,348,784 3,383,943 10,686,911 0 33,755 -1,650,923 145,169,981

84,875,816 22,574,314 38,866,199 5,712,861 10,567,569 650,000 261,255 -1,556,491 161,951,523

2,286,667 6,795,952 4,517,415 2,328,918 -119,342 650,000 227,500 94,432 16,781,542

Other Financing Sources/Uses Interfund Transfers In Interfund Transfer Out Contributions Total Other

1,200,000 70,594 -10,529,719 -9,400,313

1,200,000 70,594 -10,529,719 -9,400,313

1,200,000 33,750 -12,354,123 -11,187,873

0 -36,844 -1,824,404 -1,787,560

5,678,743

5,921,456

8,885,964

2,964,508

25,000 325,000 -

25,000 325,000 -

Ending Fund Balance

Components of Ending Fund Balance NonSpendable Revolving Cash 25,000 Stores 325,000 Restricted Committed Assigned Reserves Other Assignments - LCAP Unassigned Economic Uncertanties 5,328,743 Unassigned/Unappropriated Ending Fund Balance 5,678,743

First Interim Excel 2013-2014.xlsx

-

5,571,456

6,941,415

1,594,549 1,369,959

5,921,456

8,885,964

2,964,508

1,594,549

Page 20

Desert Sands Unified School District

Revenues, Expenditures & Changes in Fund Balance

General Fund Restricted General Fund First Interim Financial Report Beginning Balance Revenues LCFF Revenue Federal Revenue Other State Revenue Local Revenue Total Revenues

Adopted Budget

Operating Budget Oct 31, 2013

Projected Budget

Difference

1,453,939

5,689,821

5,689,821

4,711,692 14,389,809 10,768,972 30,358,298 60,228,771

4,711,692 16,865,453 11,199,919 30,458,861 63,235,925

0 16,888,270 5,908,715 29,664,202 52,461,187

-4,711,692 22,817 -5,291,204 -794,659 -10,774,738

Expenditures Certificated Salaries Classified Salaries Employee Benefits Supplies Services Capital Outlay Other Outgo Program/Fund Support Total Expenditures

21,326,902 18,331,203 16,810,525 4,416,439 6,266,326 1,328,786 28,807 808,862 69,317,850

22,744,377 18,489,886 17,214,631 8,763,592 6,942,462 1,413,777 28,807 963,354 76,560,886

21,544,511 11,868,934 13,178,965 7,490,723 7,090,718 763,777 28,807 849,737 62,816,172

-1,199,866 -6,620,952 -4,035,666 -1,272,869 148,256 -650,000 0 -113,617 -13,744,714

Other Financing Sources/Uses Interfund Transfers In Interfund Transfer Out Contributions Total Other

0 1,784,579 10,529,719 8,745,140

0 1,784,579 10,529,719 8,745,140

0 6,578,959 12,354,123 5,775,164

0 4,794,380 1,824,404 -2,969,976

1,110,000

1,110,000

1,110,000

0

Ending Fund Balance

Components of Ending Fund Balance NonSpendable Revolving Cash Stores Restricted 1,110,000 Committed Assigned Reserves Other Assignments - LCAP Unassigned Economic Uncertanties Unassigned/Unappropriated Ending Fund Balance 1,110,000

First Interim Excel 2013-2014.xlsx

1,110,000

1,110,000

(0) -

1,110,000

1,110,000

(0)

Page 21

Desert Sands Unified School District

Revenues, Expenditures & Changes in Fund Balance

General Fund Restricted/Unrestricted Combined Operating Budget Oct 31, 2013

First Interim Financial Report

Adopted Budget

Beginning Balance Revenues LCFF Revenue Federal Revenue Other State Revenue Local Revenue Total Revenues

10,880,626

16,020,856

16,020,856

135,005,485 14,659,153 28,910,624 31,805,204 210,380,466

135,005,485 17,134,797 29,341,571 31,914,787 213,396,640

164,786,805 17,157,614 10,157,570 32,053,523 224,155,512

29,781,320 22,817 -19,184,001 138,736 10,758,872

104,346,993 34,094,468 51,208,835 6,693,862 16,769,239 1,328,786 62,562 -687,569 213,817,176

105,333,526 34,268,248 51,563,415 12,147,535 17,629,373 1,413,777 62,562 -687,569 221,730,867

106,420,327 34,443,248 52,045,164 13,203,584 17,658,287 1,413,777 290,062 -706,754 224,767,695

1,086,801 175,000 481,749 1,056,049 28,914 0 227,500 -19,185 3,036,828

1,200,000 1,855,173 0 -655,173

1,200,000 1,855,173 0 -655,173

1,200,000 6,612,709 0 -5,412,709

4,757,536 0 4,757,536

6,788,743

7,031,456

9,995,964

2,964,508

Expenditures Certificated Salaries Classified Salaries Employee Benefits Supplies Services Capital Outlay Other Outgo Program/Fund Support Total Expenditures Other Financing Sources/Uses Interfund Transfers In Interfund Transfer Out Contributions Total Other Ending Fund Balance

Components of Ending Fund Balance NonSpendable Revolving Cash 25,000 Stores 325,000 Restricted 1,110,000 Committed Assigned Reserves Other Assignments - LCAP Unassigned Economic Uncertanties 5,328,743 Unassigned/Unappropriated Ending Fund Balance 6,788,743

First Interim Excel 2013-2014.xlsx

25,000 325,000 1,110,000 5,571,456 7,031,456

Projected Budget

25,000 325,000 1,110,000 1,594,549 6,941,415 9,995,964

Difference

(0) 1,594,549 1,369,959 2,964,508

Page 22

Desert Sands Unified School District

First Interim Financial Report - 2013/2014 Adjustment Detail A. Revenue Adjustments Description

Unrestricted

Restricted

Total

LCFF Revenue Tier III Revenues

9,066,071

9,066,071

Economic Impact Aid

4,455,300

4,455,300

Transportation

1,811,661

1,811,661

K-3 CSR

4,583,291

4,583,291

Special Education RL Transfer

4,711,692

LCFF Projection

9,864,997

0

9,864,997

34,493,012

(4,711,692)

29,781,320

Carl Perkins

0

12,925

12,925

Title II - Administrator Training

0

9,900

9,900

Indian Education

0

Total LCFF Adjustment

(4,711,692)

0

Federal Revenue

Total Federal Revenue Adjustments

0

(8) 22,817

(8) 22,817

State Revenue LCFF Implementation Tier III Revenues

(9,066,071)

(9,066,071)

Economic Impact Aid

(3,787,239)

(3,787,239)

Transportation

(1,758,855)

(1,758,855)

K-3 CSR

(4,583,291)

(4,583,291)

Agricultural Career Technical Education Incentive

16,330

16,330

California Partnership Academy

98,340

98,340

Mandated Costs

(243,435)

Partnership Academy Total Other State Revenue Adjustments

(243,435)

0

140,220

140,220

(13,892,797)

(5,291,204)

(19,184,001)

Local Revenue Advanced Placement Testing

2,986

City of Indian Wells Coachella Valley Economic Partnership Kaboom Transportation - Adjustments Total Local Revenue Adjustments Total Increase of Funds:

First Interim Excel 2013-2014.xlsx

2,986 10,000

10,000

125,000

125,000

750

750

930,409

(930,409)

0

933,395

(794,659)

138,736

21,533,610

(10,774,738)

10,758,872

Page 23

Desert Sands Unified School District

First Interim Financial Report - 2013/2014 Adjustment Detail B. Expenditure Adjustments Unrestricted

Certificated Salaries Growth Positions Classroom Teacher (12 FTE)

639,000

Growth Positions - Special Education (6 FTE) Economic Impact Aid - Adjustments Total Certificated Salaries

Total 639,000

360,000 1,647,667

Categorical Grant Adjustments

Restricted

360,000

(1,647,667)

0

0

87,801

87,801

2,286,667

(1,199,866)

1,086,801

Classified Salaries Restoration Positions, Custodial Staffing (5 FTE)

175,000

175,000

Redevelopment (Budget) Shift - Custodians

2,981,385

(2,981,385)

0

Transporation Adjustments

2,980,561

(2,980,561)

0

659,006

(659,006)

0

6,795,952

(6,620,952)

175,000

Economic Impact Aid - Adjustments Total Classified Salaries Benefits/Fixed Charges Growth Positions Classroom Teacher (12 FTE)

247,119

Growth Positions - Special Education (6 FTE) Restoration Positions, Custodial Staffing (5 FTE)

247,119 128,460

84,813

128,460 84,813

Redevelopment (Budget) Shift - Custodians

1,812,995

(1,812,995)

0

Transportation Adjustments

1,718,454

(1,718,454)

0

654,034

(654,034)

0

Economic Impact Aid - Adjustments

0

21,357

21,357

4,517,415

(4,035,666)

481,749

Economic Impact Aid - Adjustments

1,171,320

(389,642)

781,678

Transportation Adjustments

1,155,284

(1,155,284)

0

Categorical Grant Adjustments Total Benefits/Fixed Charges Supplies Materials & Supplies

Unrestricted Adjustments

2,314

Categorical Grant Adjustments Total Supplies

First Interim Excel 2013-2014.xlsx

2,314

0

272,057

272,057

2,328,918

(1,272,869)

1,056,049

Page 24

Desert Sands Unified School District

First Interim Financial Report - 2013/2014 Adjustment Detail Services & Operating Expenditures

Unrestricted

Unrestricted Adjustments Categorical Grant Adjustments Transportation Adjustments Economic Impact Aid - Adjustments Interfund Transfers/Services - Unrestricted Total Services/Operating Expenses

Restricted

Total

672

0

672

0

32,242

32,242

(439,287)

439,287

0

323,273

(323,273)

0

(4,000)

0

(4,000)

(119,342)

148,256

650,000

(650,000)

0

650,000

(650,000)

0

227,500

0

227,500

227,500

0

227,500

28,914

Equipment & Capital Outlay Transportation Adjustments Total Equipment & Capital Outlay Other Outgo Other Outgo - Community Schools/Co Special Ed Total Other Outgo Indirect Costs Indirect Cost - Restricted

(113,617)

Indirect Cost - Unrestricted Total Indirect Total Expenditure Adjustments

(113,617)

94,432

0

94,432

94,432

(113,617)

(19,185)

16,781,542

(13,744,714)

3,036,828

Transfers In/Transfers Out WCS/PDCMS Revenue Pass-thru Contributions - Restricted Transportation

(36,844)

(36,844)

3,375,748

(3,375,748)

0

(5,200,152)

5,200,152

0

0

4,794,380

4,794,380

Total Other Financing/Interfund Transfers

1,787,560

2,969,976

4,757,536

Increased Revenues less Increased Expenditures

2,964,508

0

2,964,508

Contributions - Restricted Special Education Redevelopment Pass-Thru to Fund 40

First Interim Excel 2013-2014.xlsx

Page 25

DESERT SANDS UNIFIED SCHOOL DISTRICT

2013/2014 First Interim Financial Report Projection Dartboard Category

2012/2013

2013/2014

2014/2015

2015/2016

Enrollment Growth

-0.55%

0.00%

0.00%

0.00%

District K-12 Enrollment

26,986

26,981

26,981

26,981

94.2%

94.3%

94.3%

94.3%

25,424

25,439

25,439

25,439

2,079

2,074

2,074

2,074

46

35

35

35

K-3

34:1

33:1

31.5:1

30:1

4-5

34:1

34:1

32:1

32:1

6-8

33:1

33:1

33:1

33:1

9 - 12

32:1

32:1

32:1

32:1

School Site Formulas

0.00%

0.00%

0.00%

0.00%

Statutory COLA

3.24%

1.565%

1.80%

2.30%

ADA District K-12 ADA Charter Schools ADA County ADA

Classroom Staffing

Funded Revenue Limit

5,211.65

LCFF Identified Categorical Funding Per ADA

882.15

LCFF Target Funding Rate

11.78%

16.49%

18.69%

K-3

7,675.00

7,819.00

7,974.00

4-6

7,056.00

7,188.00

7,331.00

7-8

7,266.00

7,402.00

7,549.00

9 - 12

8,638.00

8,799.00

8,974.00

68%

68%

68%

68%

Certificated Salary Increases

0.00%

0.00%

0.00%

0.00%

Classified Salary Increases

0.00%

7.00%

0.00%

0.00%

California CPI

2.15%

2.00%

2.30%

2.50%

Interest Rate/Ten-Year Treasuries

1.89%

2.50%

2.70%

2.90%

$154/ADA

$154/ADA

$154/ADA

$154/ADA

-6.00

18.00

10.00

7.00

-37.00

10.00

0.00

0.00

18

10

10

10

2,005,761

2,191,529

2,300,000

2,400,000

1.10%

1.14%

1.19%

1.23%

LCFF Target Base Grant by Grade Span

EL/LI Unduplicated Factor

California Lottery Classroom Teacher Growth Classified Growth Projected Retirees Step and Column $ All Funds Step and Column % General Fund

* For subsequent years, 80% of funding rate difference has been added to the Multi-Year Projections.

First Interim Report 2013-2014 Page 26

DESERT SANDS UNIFIED SCHOOL DISTRICT GENERAL FUND BUDGET PROJECTIONS 2013/14 Budget

2014/15 Projection

2015/16 Projection

SUMMARY OF OPERATIONS Revenues LCFF Revenues Federal Revenues Other State Revenues Other Local Revenues

$164,786,805 $17,157,614 $10,157,570 $32,053,523

175,462,113 14,682,110 8,757,787 31,395,683

186,288,686 14,682,110 8,556,971 31,398,066

$224,155,512

$ 230,297,693

$ 240,925,833

192,908,739 13,203,584 17,658,287 1,413,777 290,062 -706,754

194,242,987 7,197,725 17,438,699 759,040 333,143 -1,032,056

195,866,924 7,032,287 17,585,693 759,040 338,891 -1,038,702

$224,767,695

$ 218,939,538

$ 220,544,133

-5,412,709

-7,967,085

-7,974,357

Increase (Decrease) in Fund Balance Beginning Fund Balance, July 1

-6,024,892 16,020,856

3,391,070 9,995,964

12,407,343 13,387,034

Ending Fund Balance, June 30

$9,995,964

$13,387,034

$25,794,379

25,000 325,000 1,110,000 0

25,000 325,000 904,654

25,000 325,000 780,248

1,594,549 0

5,269,134 0

17,702,571 0

6,941,415 0

6,863,246 0

6,961,559 0

9,995,964

13,387,034

25,794,378

Total Revenue Expenditures Salaries and Benefits Books and Supplies Contracts and Operating Expenses Capital Outlay Other Outgo Direct Support/Indirect Cost Total Expenditures Net Transfers Incoming (Outgoing)

Components of Ending Balance NonSpendable Revolving Cash Stores Restricted Committed Assigned Reserves Other Assignments - LCAP Unassigned Economic Uncertainties Unassigned/Unappropriated Total Ending Balance

First Interim Excel 2013-2014.xlsx

Page 27

GENERAL FUND MULTI-YEAR PROJECTIONS 2014/2015 Unrestricted

Restricted

2015/2016 Combined

Unrestricted

Restricted

Combined

SUMMARY OF OPERATIONS Revenues LCFF Revenues Federal Revenues Other State Revenues Other Local Revenues Total Revenue Expenditures CE Salaries CL Salaries Benefits Books and Supplies Contracts and Operating Expenses Capital Outlay Other Outgo Direct Support/Indirect Cost Total Expenditures Net Transfers Incoming (Outgoing) Increase (Decrease) in Fund Balance Beginning Fund Balance, July 1 Ending Fund Balance, June 30

$175,462,113 269,344 3,293,978 1,731,481

$0 14,412,766 5,463,809 29,664,202

$175,462,113 14,682,110 8,757,787 31,395,683

$186,288,686 269,344 3,293,978 1,733,864

$0 14,412,766 5,262,993 29,664,202

$186,288,686 14,682,110 8,556,971 31,398,066

180,756,916

49,540,777

$ 230,297,693

191,585,872

49,339,961

$ 240,925,833

86,979,770 23,579,744 39,814,642 4,582,930 10,725,545 0 304,336 -1,556,491

20,587,136 10,984,917 12,296,778 2,614,795 6,713,154 759,040 28,807 524,435

107,566,906 34,564,661 52,111,420 7,197,725 17,438,699 759,040 333,143 -1,032,056

89,126,855 23,744,802 38,624,522 4,697,503 10,952,250 0 310,084 -1,556,491

20,961,739 11,060,492 12,348,514 2,334,784 6,633,443 759,040 28,807 517,789

110,088,594 34,805,294 50,973,036 7,032,287 17,585,693 759,040 338,891 -1,038,702

164,430,476

54,509,062

$ 218,939,538

165,899,525

54,644,608

$ 220,544,133

-12,730,024

4,762,939

-7,967,085

-13,154,598

5,180,241

-7,974,357

8,885,964

1,110,000

3,391,070 9,995,964

12,482,380

904,654

12,407,343 13,387,034

12,482,380

904,654

$13,387,034

25,014,130

780,248

$25,794,378

25,000 325,000 904,654 0 0 5,269,134 0 0 6,863,246 0

25,000 325,000 0

Components of Ending Balance NonSpendable Revolving Cash Stores Restricted Committed Assigned Reserves Other Assignments - LCAP

5,269,134

Unassigned Economic Uncertainties Unassigned/Unappropriated

6,863,246 0

Total Ending Balance

First Interim Excel 2013-2014.xlsx

25,000 325,000 0

12,482,380

904,654

904,654

13,387,034

780,248

17,702,571

6,961,559 0 25,014,130

780,248

25,000 325,000 780,248 0 0 17,702,571 0 0 6,961,559 0 25,794,378

Page 28

Desert Sands Unified School District

CHARTER SCHOOL FUND SUMMARY Period Ending October 31, 2013

Washington Charter Adopted Budget Beginning Balance

Operating Budget Oct 31, 2013

Projected Budget

Difference

Comments

2,597,577

3,009,138

3,009,138

0

Revenues Revenue Limit Federal Revenue Other State Revenue Local Revenue

3,964,772 34,765 923,019 89,025

3,964,772 34,765 923,019 89,025

4,729,225 60,152 355,531 90,025

764,453 25,387 -567,488 1,000

Total Revenues

5,011,581

5,011,581

5,234,933

223,352

Expenditures Certificated Salaries Classified Salaries Employee Benefits Supplies Services Capital Outlay Other Outgo Program/Fund Support

2,598,385 412,029 1,074,584 251,008 730,878 0 0 150,715

2,598,385 415,340 1,074,584 246,643 731,932 0 0 150,715

2,614,046 408,603 1,065,021 472,384 819,767 0 0 157,048

15,661 -6,737 -9,563 225,741 87,835 0 0 6,333

Total Expenditures

5,217,599

5,217,599

5,536,869

319,270

12,244 0

12,244 0

0 0

-12,244 0

2,403,803

2,815,364

2,707,202

-108,162

Sources/Uses Interfund Transfers In Interfund Transfer Out Ending Fund Balance

Components of Ending Fund Balance NonSpendable Revolving Cash 50,000 Stores Restricted Committed Assigned Charter School Fund 2,353,803 Unassigned Ending Fund Balance 2,403,803

First Interim Excel 2013-2014.xlsx

50,000 -

70,000 -

2,765,364

2,637,202

(128,162)

2,815,364

2,707,202

(108,162)

LCFF Implementation Title II/III LCFF Implementation/Common Core/Prop 39

20,000

Page 29

Desert Sands Unified School District

CHARTER SCHOOL FUND SUMMARY Period Ending October 31, 2013

Palm Desert Charter Adopted Budget Beginning Balance

Operating Budget Oct 31, 2013

Projected Budget

Difference

Comments

3,087,392

3,792,636

3,792,636

0

Revenues Revenue Limit Federal Revenue Other State Revenue Local Revenue

6,707,068 45,480 864,714 212,255

6,707,068 45,480 864,714 212,255

7,656,862 79,960 587,554 374,000

949,794 34,480 -277,160 161,745

Total Revenues

7,829,517

7,829,517

8,698,376

868,859

Expenditures Certificated Salaries Classified Salaries Employee Benefits Supplies Services Capital Outlay Other Outgo Program/Fund Support

4,110,955 657,389 1,755,977 336,619 905,159 0 0 216,854

4,064,123 685,860 1,754,765 476,068 910,640 0 0 216,854

4,234,992 711,828 1,802,107 874,050 1,175,726 0 0 229,706

170,869 25,968 47,342 397,982 265,086 0 0 12,852

Total Expenditures

7,982,953

8,108,310

9,028,409

920,099

24,600 0

24,600 0

0 0

-24,600 0

2,958,556

3,538,443

3,462,603

-75,840

Sources/Uses Interfund Transfers In Interfund Transfer Out Ending Fund Balance

Components of Ending Fund Balance NonSpendable Revolving Cash 75,000 Stores Restricted Committed Assigned Charter School Fund 2,883,556 Unassigned Ending Fund Balance 2,958,556

First Interim Excel 2013-2014.xlsx

75,000 -

95,000 109,702

3,463,443

3,257,901

3,538,443

3,462,603

LCFF Implementation LCFF Implementation/Common Core/Prop 39 Local Revenue Increase

20,000 109,702 (205,542) (75,840)

Page 30

Desert Sands Unified School District

CHILD DEVELOPMENT FUND SUMMARY Period Ending October 31, 2013

Child Development Fund Operating Budget Oct 31, 2013 Beginning Balance

Projected Budget

Difference

Comments

13,852

13,852

0

Revenues Revenue Limit Federal Revenue Other State Revenue Local Revenue

0 98,899 778,342 48,793

0 102,594 891,035 49,472

0 3,695 112,693 679

Total Revenues

926,034

1,043,101

117,067

Expenditures Certificated Salaries Classified Salaries Employee Benefits Supplies Services Capital Outlay Other Outgo Program/Fund Support

294,451 330,924 277,277 47,382 9,750 0 0 0

294,451 330,924 277,277 170,264 9,750 8,037 0 0

0 0 0 122,882 0 8,037 0 0

Total Expenditures

959,784

1,090,703

130,919

33,750 0

33,750 0

0 0

13,852

0

-13,852

Sources/Uses Interfund Transfers In Interfund Transfer Out Ending Fund Balance

Components of Ending Fund Balance NonSpendable Revolving Cash Stores Restricted 13,327 Committed Assigned 525 Unassigned Ending Fund Balance 13,852

First Interim Excel 2013-2014.xlsx

-

Federal Child Care Center State Preschool

(13,327) (525) (13,852)

Page 31

Desert Sands Unified School District

BUILDING FUND SUMMARY Period Ending October 31, 2013

Building Fund Operating Budget

Projected Budget

Oct 31, 2013

Beginning Balance

Difference

Comments

82,357,413

82,357,413

0

Revenues Revenue Limit Federal Revenue Other State Revenue Local Revenue

0 0 0 650,000

0 0 0 650,000

0 0 0 0

Total Revenues

650,000

650,000

0

0 0 0 0 33,604 58,823,257 0

0 0 0 0 43,733 58,731,091 0

0 0 0 0 10,129 -92,166 0

Expenditures Certificated Salaries Classified Salaries Employee Benefits Supplies Services Capital Outlay Other Outgo Program/Fund Support Total Expenditures Sources/Uses Interfund Transfers In Interfund Transfers Out Other Sources Ending Fund Balance

0 58,856,861

58,774,824

-82,037

0 0 0

0 0 0

0 0 0

24,150,552

24,232,589

82,037

Components of Ending Fund Balance NonSpendable Revolving Cash Stores Restricted 24,150,552 Committed Assigned Unassigned Ending Fund Balance 24,150,552

24,232,589

82,037

24,232,589

82,037

Page 32

Desert Sands Unified School District

CAPITAL FACILITIES FUND SUMMARY Period Ending October 31, 2013

Capital Facilities Fund Operating Budget

Projected Budget

Oct 31, 2013

Beginning Balance Revenues Revenue Limit Federal Revenue Other State Revenue Local Revenue Total Revenues Expenditures Certificated Salaries Classified Salaries Employee Benefits Supplies Services Capital Outlay Other Outgo Program/Fund Support Total Expenditures Sources/Uses Interfund Transfers In Interfund Transfer Out Ending Fund Balance

Difference

Comments

20,570,851

20,570,851

0

0 0 0 1,540,000 1,540,000

0 0 0 1,540,000 1,540,000

0 0 0 0 0

0 443,034 211,581 1,021,703 605,000 7,520,146 0

0 443,034 211,581 2,054,645 630,845 7,306,381 0

9,801,464

10,646,486.00

0 0 0 1,032,942 25,845 -213,765 0 0 845,022

0 0

0 0

0 0

12,309,387

11,464,365

-845,022

Components of Ending Fund Balance NonSpendable Revolving Cash Stores Restricted 12,309,387 Committed Assigned Unassigned Ending Fund Balance 12,309,387

11,464,365

(845,022)

11,464,365

(845,022)

Amistad/LQ High F&E

Page 33

Desert Sands Unified School District

SPECIAL RESERVE FOR CAPITAL PROJECTS Period Ending October 31, 2013

Capital Facilities Fund Operating Budget Oct 31, 2013 Beginning Balance

Projected Budget

Difference

Comments

27,029,093

27,029,093

0

0 0 0 50,000 50,000

0 0 0 50,000 50,000

0 0 0 0 0

Expenditures Certificated Salaries Classified Salaries Employee Benefits Supplies Services Capital Outlay Other Outgo Program/Fund Support Total Expenditures

0 161,110 90,574 0 1,311,600 1,753,103 6,990,725 0 10,307,112

0 202,709 109,968 327,222 1,380,275 2,486,621 6,990,725 0 11,497,520.00

0 41,599 19,394 327,222 68,675 733,518 0 0 1,190,408

Sources/Uses Interfund Transfers In Interfund Transfer Out

2,185,402 1,000,000

8,414,717 1,000,000

6,229,315 0

17,957,383

22,996,290

5,038,907

Revenues Revenue Limit Federal Revenue Other State Revenue Local Revenue Total Revenues

Ending Fund Balance

Components of Ending Fund Balance NonSpendable Revolving Cash Stores Restricted 17,957,383 Committed Assigned Unassigned Ending Fund Balance 17,957,383

First Interim Excel 2013-2014.xlsx

22,996,290 22,996,290

Indio High School Modernization

RDA Pass Through/Sources

5,038,907 5,038,907

Page 34

DESERT SANDS UNIFIED SCHOOL DISTRICT

ENROLLMENT HISTORY SCHOOL

Unverified 2013-2014

2012-2013

2011-2012

2010-2011

2009-2010

Elementary Schools Adams

462

452

439

440

458

Carreon

684

699

773

775

807

Carrillo

719

757

707

663

628

Carter

684

668

648

631

641

Earhart

944

927

953

987

901

Eisenhower

471

477

486

505

512

Ford

811

776

793

790

801

Franklin

536

571

617

630

611

Hoover

503

496

494

466

489

Jackson

695

709

702

719

776

Johnson

540

522

560

572

625

Kennedy

563

553

546

560

529

Lincoln

688

737

720

738

724

Madison

546

544

564

626

660

Monroe

603

580

576

560

581

Reagan

895

877

870

819

779

Roosevelt

574

592

633

677

703

Truman

533

571

611

612

682

Van Buren

585

554

549

490

466

Washington

835

835

768

766

741

Desert Ridge

1127

1079

1068

926

741

Glenn

1443

1274

1294

1301

1273

Indio

844

867

854

906

961

Jefferson

600

629

612

707

785

La Quinta

507

580

614

677

777

Paige

878

1039

963

1001

1068

Palm Desert

1340

1339

1299

1262

1265

329

382

439

465

465

Middle Schools

High Schools Amistad Summit

348

352

338

258

313

Indio

1999

1989

2110

2297

2448

La Quinta

2858

2922

2999

2968

2985

Palm Desert

2003

1979

2003

2042

2103

Shadow Hills

1713

1491

1217

882

640

Horizon

295

334

376

396

381

1

4

4

9

9

29156

29157

29199

29123

29328

0.00% -1

-0.14% -42

0.26% 76

-0.70% -205

1.61% 465

Non Public TOTAL % Growth Growth

Page 35

DESERT SANDS UNIFIED SCHOOL DISTRICT 2013/2014 Grant Award Update - First Interim Award

Federal Programs 21st Century After School Grant Early Childhood Education Programs Pre-School - Federal

Prior Year Carryover

Current Year Award

Total Available Award

Grant End Date

7,500

0

7,500

12/31/13

0

98,899

98,899

6/30/14

160,945

1,813,359

1,974,304

8/31/14

0

17,722

17,722

6/30/14

168,938

0

168,938

9/30/13

14,734

0

14,734

1,099,658

6,021,110

7,120,768

6/30/14

30,462

13,500

43,962

6/30/14

Title II - Teacher Quality

596,577

855,503

1,452,080

6/30/14

Title III - LEP

403,595

621,910

1,025,505

6/30/14

10,289

196,020

206,309

6/30/14

Head Start Indian Education Magnet Schools Assistance Program FEMA Public Assistance Funds Title I Title II - Principal Training

Vocational Education (Carl D. Perkins)

Total Federal

Prepared by Joyce Pudis First Interim Excel 2013-2014.xlsx

$

12,130,721

Page 36

DESERT SANDS UNIFIED SCHOOL DISTRICT 2013/2014 Grant Award Update - First Interim

State Programs After School Education & Safety Program ASES California Partnership Academy - Health LQHS California Partnership Academy - Public Service Academy - LQHS California Partnership CTE Initiative Health - Indio High

Award Current Year Award

Prior Year Carryover

Total Available Award

Grant End Date

0

1,906,200

1,906,200

6/30/14

36,701

70,110

106,811

6/30/14

25,555

70,110

95,665

6/30/14

58,725

44,700

103,425

6/30/14

50,375

53,640

104,015

6/30/14

0

773,342

773,342

6/30/14

13,327

770

14,097

Economic Impact Aid - LEP

1,168,390

0

1,168,390

6/30/14

Economic Impact Aid - SCE

921,827

0

921,827

6/30/14

Lottery Instructional Materials

706,827

798,540

1,505,367

Medi-Cal PRE-K and Family Literacy Program Support

583,433

250,000

833,433

0

5,000

5,000

6/30/14

QEIA - Quality Education Investment Act

416,279

580,800

997,079

6/30/14

Tobacco Use Prevention 6-12

235,805

0

235,805

6/30/14

Vocational Agricultural Incentive Grant

0

16,330

16,330

6/30/14

WorkAbility I Site Grant

0

134,876

134,876

6/30/14

California Partnership CTE Initiative Technology - Shadow Hills High Early Childhood Education Programs Pre School - State Early Childhood Education Programs Reserve Account

Total State

Prepared by Joyce Pudis First Interim Excel 2013-2014.xlsx

$

8,921,662

Page 37

DESERT SANDS UNIFIED SCHOOL DISTRICT 2013/2014 Grant Award Update - First Interim Award

Local Awards Prior Year Carryover Anderson Grant

Current Year Award

Total Available Award

Grant End Date

11,319

68,563

79,882

6/30/14

750

0

750

6/30/14

City of Indian Wells

0

10,000

10,000

6/30/14

City of Palm Desert - ECE Programs Coachella Valley Economic Partnership CVEP

0

30,000

30,000

6/30/14

2,533

125,000

127,533

6/30/14

CV Women in Agriculture

2,451

0

2,451

6/30/14

21,918

0

21,918

3,782

0

3,782

6/30/14

0

750

750

6/30/14

2,217

0

2,217

6/30/14

382

2,000

2,382

6/30/14

3,900

0

3,900

6/30/14

California Table Grape

Desert Sands Educational Foundation Indio Youth Task Force KaBoom Lowe's Education Fund Target The Discover Brighter Futures

Total Local

Prepared by Joyce Pudis First Interim Excel 2013-2014.xlsx

$

285,565

Page 38