Timeline Re-cap

•

Mar 20, 2007 – FY 2007-08 Informational

Budget Update

•

Apr 17, 2007 – FY 2007-08 Preliminary

Budgets Presented

•

May 15, 2007 – FY 2007-08 Proposed

Budgets Presented

•

Approval & Adoption of All Funds FY

2007-08 Budgets

•

Budget Resolution FY 2007-08

•

Appropriation Resolution FY 2007-08

•

Resolution Authorizing Use of

Beginning Fund Balance FY

2007-08

•

Resolution Authorizing Inter - Fund

Borrowing FY 2007-08

June 19, 2007 Agenda

District Information

SCHOOLS IN OPERATION FOR FY 2007-08

41 Elementary Schools

7 Charter Schools

7 Middle Schools

2 Magnet Schools

8 High Schools

3 Alternative Schools

30 Preschool Sites

1 University Center

OTHER FACILITIES FY 2007-08

2 Stadiums

15 Support Facilities

FY 2007-08 Calendars

25 Schools are

on year-round

track

schedules

7 Schools are

on modified

schedules

33 Schools are

on conventional

schedules

Student Enrollment PreK-12

10,000

20,000

30,000

40,000

50,000

60,000

70,000

1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012

Douglas County School District Enrollment

Total Pupil Count

Funded Pupil Count

•

New School Openings FY 2007-2008

Lone Tree Elem – A Magnet School (Aug 2007)

Mammoth Heights Elem (Jan 2008)

Stone Mountain Elem (Jan 2008)

Roxborough Intermediate (Jan 2008)

•

Projected FY 2008-2009

Elem School #44 in Parker

Elem School #45 in Castle Rock

Middle School #8 in Castle Rock

High School #9 in Parker

New Schools

History of AV by Year

500,000,000

1,000,000,000

1,500,000,000

2,000,000,000

2,500,000,000

3,000,000,000

3,500,000,000

4,000,000,000

4,500,000,000

98-99 99-00 00-01 01-02 02-03 03-04 04-05 05-06 06-07 07-08

School Mill Levy History

56.28

55.87

51.07

49.36

47.00

43.58

46.50

53.36

59.75

56.28

30.00

50.00

70.00

1991

1992

1993

1994

1995

1996

1997

Assessment Years

Total Mill Levy

Mill Levy and Assessed Valuation

District Mill Levy

(Per $1,000 of AV)

2007 Budget

2008 Budget

Mill Certified, December:

2006

2007

Property Taxes Collected:

2007

2008

Program Funding

Abatements & Omitted Property

25.440

0.215

25.440

0.215

Overrides (‘89,‘97, ’03 & ‘06)

8.319

7.641

Bond Redemption

12.526

13.204

Total Mill Levy

46.500

Total Assessed Value

$4,051,481,720

$4,412,063,598

Estimated for December 2007 Mill Levy

$1,000

$2,000

$3,000

$4,000

$5,000

$6,000

$7,000

$8,000

Boulder Valley Aurora Cherry Creek Littleton Douglas County

Funding Per Pupil

Override Revenue Per Pupil

Hold Harmless Revenue Per Pupil

District Revenue Comparisons

1,220

245

670

718 944

6,606 6,910 6,596 6,429 6,412

141 152

TOTALS $7,826 $7,155 $7,455 $7,525 $7,082

General Fund Assumptions

•

Per-Pupil Revenue: $6,412

•

Inflation Rate Remains

3.6% for FY08

•

Total Student Count increase to 53,235

from 50,385 in FY06-07 = 5% incr

•

Funded Pupil Count increase to 50,063

from 47,363 in FY06-07 = 5% incr

Job Class Type FY 06-07 Budget % Incr Amount of Incr FY 07-08 Budget

100 Administrative $16,749,313 4.35% $728,595 $17,477,908

200 Certified $151,712,729 6.35% $9,633,758 $161,346,487

300 Pro/Tech $4,757,739 4.35% $206,962 $4,964,701

400 Classified-Para/Prof $15,273,021 6.35% $969,837 $16,242,858

500 Classified-Office $13,025,819 6.35% $827,140 $13,852,959

600 Classified-Cust/Trades $18,398,489 6.35% $1,168,304 $19,566,793

TOTALS $219,917,110 $13,534,595 $233,451,705

Salary Increases *

FY 2007-08 over FY 2006-07

* Salary only, benefits not included in figures

Recommended Staffing Ratio

Grades K-3: 23

Grades 4-6: 26

Grades 7-8: 19.5

Grades 9-12: 20.5

General Fund

Personnel Summary

June

Budgeted Budgeted Budgeted Budgeted Budgeted % of

FTE FTE FTE FTE FTE Total

Employee Group

2003-04

2004-05

2005-06

2006-07

2007-08

100-ADMINISTRATIVE STAFF

Total Administrative Staff

164.56 167.36 176.36 186.80 205.47 4.08%

200-CERTIFIED STAFF

Total Certified Staff

2,493.67 2,602.42 2,705.07 2,934.44 3,144.43 62.46%

300-PROFESSIONAL/TECHNICAL STAFF

Total Professionl/Technical Staff 69.17 82.72 87.72 70.23 68.93 1.37%

400-600 CLASSIFIED STAFF

Total 400 - Clerical Staff 521.21 528.96 532.96 556.61 646.98 12.85%

Total 500 - School Office/Instr Support 292.20 302.50 304.10 370.54 413.25 8.21%

Total 600 - Support Services 462.17 495.42 540.92 566.94 555.25 11.03%

GRAND TOTAL

4,002.98 4,179.38 4,347.13 4,685.56 5,034.31 100.00%

Salary / Benefit

Adjustment Summary

•

Certified Increase:

•

Schedule Increase 4.35%

•

Step Increase 2.00%

•

Classified Increase 6.35%

•

Admin/Pro Tech Increase 4.35%

•

Health Benefits .33%

•

(As Equated to Salary)

•

PERA Increase .25%

PERA

16.15%

3.00

10.15%

JAN 2013

15.65%

2.50

3.00

10.15%

JAN 2012

14.75%

2.00

2.60

10.15%

JAN 2011

13.85%

1.50

2.20

10.15%

JAN 2010

12.95%

1.00

1.80

10.15%

JAN 2009

12.05%

.50

1.40

10.15%

JAN 2008

11.15%

.00

1.00

10.15%

JAN 2007

10.65%

.00

.50

10.15%

JAN 2006

TOTAL

DEDUCTION %

FOR YEAR

SAED

AED

PERA

PERA - Past, Present, Future

$5,000,000

$10,000,000

$15,000,000

$20,000,000

$25,000,000

$30,000,000

$35,000,000

$40,000,000

$45,000,000

$50,000,000

FY 2003-04

FY 2004-05

FY 2005-06

FY 2006-07

FY 2007-08

FY 2008-09

FY 2009-10

FY 2010-11

FY 2011-12

$28,849,234

General Fund Revenue

State Aid,

$176,120,100

50%

Local

Property

Tax,

$130,773,113

37%

Specific

Ownership

Tax,

$20,350,898

Other Local

Revenue

$14,938,580

Other State

Revenue

$10,443,762

Breakdown of New

Expenditures

New FTE Costs

$15.1

Existing Staff

Raises

$15.3

Cost of Business &

Operating

$3.4

Transfers to

Charters and Other

Funds

$7.5

Additional

Salary & Benefits

$4.1

$15.3

$15.1

$4.1

$7.5

$3.4

Total $45.4

Additional Salary & Benefits Costs

Transfers to Charters & Other Budgets

Cost of Doing Business & Oper Costs

Existing Staff Raises w/PERA & Med

New FTE Costs

FY 2007-08 General Fund Expenses

•

Telephone increase $243,500

•

Fuel increase $571,860

•

Utilities increase $551,418

•

Custodial Costs for New Facilities

increase $149,287

TOTAL SALARIES INCREASE $27.8M *

TOTAL BENEFITS INCREASE $ 6.7M

* With New FTE

FY 2007-2008 New Projects

•

Liberal Arts Education

–

Math, Science, Social Studies, Reading

and Writing

•

Addressing Achievement Gaps

•

Development of Career and Technical

Education Programming

•

Online Learning System

•

Data Center

•

Identity Management

•

World Language Programs

General Fund Overview ( in millions)

6.1%

$24.0

$405.2

$393.3

$35.9

Budget

2007-08

(27%)

12.6%

9.9%

3.1%

Incr over

Prior Yr

9.2%

Ending Fund Balance as %

Of Revenue

$32.9

Ending Fund Balance

$359.9

Total Expenditures

$357.9

Total Revenue

$34.8

Beginning Fund Balance

Budget

2006-07

General Fund Percent of

Total Budget

FY 06-07 % of

FY 07-08 % of

Object (in millions) Budget Total Budget Total

Salaries $231.74 64.4% $259.56 64.0%

Benefits 51.33 14.3% 58.00 14.3%

Subtotal 283.07 78.7% 317.56 78.4%

Operating 40.26 11.2% 43.50 10.7%

Transfers 34.69 9.6% 42.22 10.4%

Contingency 1.83 0.5% 2.00 0.5%

Subtotal 76.78 21.3% 87.72 21.6%

TOTAL EXPENDITURES $359.85 100.0% $405.28 100.0%

General Fund

REVENUE & EXPENSES (IN MILLIONS)

Adopted Proposed Budget Percentage

Budget Budget Inc / Decr Change

2006-07 2007-08 Over 2006-07 Over 2006-07

DCSD FPC 47,363 50,063

BEGINNING FUND BALANCE $34.89 $35.93 $1.04 3.0%

REVENUES

Subtotal - Local Tax Revenues 156.45 165.47 9.02 5.8%

Subtotal - Intergovernmental Revenues 186.56 208.54 21.98 11.8%

Subtotal - Other Local Revenue 14.92 19.37 4.45 29.8%

TOTAL REVENUES $357.93 $393.38 $35.45 9.9%

Total Program Funding $290.77 $321.04 $30.27 10.4%

EXPENDITURES

Salaries 231.74 259.56 27.82 12.0%

Benefits 51.33 58.00 6.67 13.0%

Operating 40.26 43.50 3.24 8.0%

Charter School Transfer (based upon Charter's FPC x PPR) 17.57 19.61 2.04 11.6%

Charter Schools' Share of '03 Override (@ $251/FPC) 0.56 0.57 0.01 1.8%

Capital Reserve Fund Transfer 9.29 9.52 0.23 2.5%

Insurance Reserve Transfer 5% increase per year 3.15 3.31 0.16 5.1%

Student Athletic Fund Transfer 4.12 4.21 0.09 2.2%

Fund 29 Transfer: Mill Levy Override Fund -

5.00 5.00 0.0%

Contingency ~ Reserve for Schools 0.73 0.90 0.17 23.3%

Contingency ~ Reserve for Options 0.10 -

(0.10)

-100.0%

Contingency ~ General Operating (@ .3% Total Exp) 1.00 1.10 0.10 10.0%

TOTAL EXPENDITURES $359.85 $405.28 $45.43 12.6%

CHANGE IN FUND BALANCE

($1.92) ($11.90) ($9.98)

519.8%

BEGINNING FUND BALANCE $34.89 $35.93 $1.04 3.0%

ENDING FUND BALANCE $32.97 $24.03

($8.94)

-27.1%

9.2% 6.1%

Ending Fund Balance - as % of Total Revenues

General Fund Five Year

Financial Projections

Proposed

Budget Projected Projected Projected Projected

2007-08 2008-09 2009-10 2010-11 2011-12

DCSD FPC 50,063 52,763 55,463 58,163 60,863

BEGINNING FUND BALANCE $ 35,930,535 $ 24,024,984 $ 21,365,237 $ 23,116,822 $ 38,588,391

REVENUES

Subtotal - Local Tax Revenues 165,469,366

171,354,479

181,638,752

196,732,507

207,702,589

Subtotal - Intergovernmental Revenues 208,539,875

234,325,573

260,023,575

291,380,452

314,294,429

Subtotal - Other Local Revenue 19,369,945

19,422,585

20,604,816

21,812,195

23,046,415

TOTAL REVENUES $ 393,379,185 $ 425,095,660 $ 462,274,552 $ 509,946,962 $ 545,212,590

Total Program Funding $ 321,040,781 $ 352,335,694 $ 387,474,563 $ 425,100,625 $ 458,249,672

EXPENDITURES

Salaries 259,560,512

274,837,282

291,966,841

311,290,597

331,614,740

Benefits 58,002,787

64,796,147

72,448,160

82,994,411

92,308,446

Operating 43,498,824

45,064,782

46,416,725

47,809,227

49,243,504

At Risk Student Grant -

125,000

Charter School Transfer 19,607,135

20,494,961

21,437,747

22,423,898

23,096,614

Charter Schools' Share of '03 Override 568,515

573,535

578,555

584,830

Capital Reserve Fund Transfer 9,527,237 11,631,742 12,915,593 14,283,193 15,739,173

Insurance Reserve Transfer 3,307,500 3,472,875 3,646,519 3,828,845 4,020,287

Student Athletic Fund Transfer 4,212,226

4,926,269

5,148,522

5,381,616

5,596,881

Fund 29 Transfer: Mill Levy Override Fund 5,000,000

5,000,000

LTE COP Payment -

888,713

902,513

944,513

Contingency ~ Reserve for Schools 900,000

Contingency ~ General Operating 1,100,000

Total Annual Reductions -

(4,000,000)

TOTAL EXPENDITURES $ 405,284,736 $ 427,750,529 $ 460,522,966 $ 494,475,393 $ 528,080,622

CHANGE IN FUND BALANCE

($ 11,905,551) ($ 2,654,869)

$ 1,751,586 $ 15,471,569 $ 17,131,968

BEGINNING FUND BALANCE $ 35,930,535 $ 24,024,984 $ 21,365,237 $ 23,116,822 $ 38,588,391

ENDING FUND BALANCE $ 24,024,984 $ 21,365,237 $ 23,116,822 $ 38,588,391 $ 55,720,359

6.1% 5.0% 5.0% 7.6% 10.2%

Ending Fund Balance - as % of Total Revenues

What is Student-Based Budgeting?

•

A process that moves authority and

resources closest to where teaching and

learning take place – the local school

•

Makes a direct link between a school’s

actual enrollment and funding

•

At full implementation, SBB allows a higher

level of PPOR dollars to be allocated at the

site level on a per pupil basis

Goals of Student-Based Budgeting

•

To establish greater equity between sites on a

per pupil basis

•

To empower sites with greater discretion and

flexibility

•

To synergize the student-based budget planning

process to bring all revenue sources into play

•

To heighten accountability at the local/school

community level

Student Based Budgeting

Per Pupil Allocations

$3,561

$3,437

HIGH SCHOOLS

$3,668

$3,541

MIDDLE SCHOOLS

$3,400

$3,239

ELEMENTARY

SCHOOLS

FY 07-08

FY 06-07

How the Per Pupil

Allocation is Spent

•

These are some of the things the

schools spend their per pupil allocation

on:

–

All Regular Classroom Teachers

–

Specials and Electives Teachers

–

Classified Staff

–

Operating Expenses

Implementation of

Student Based Budgeting

•

Multi-year Phase-in

–

First year 2005-06 – Voluntary

•

One Feeder and One Additional High School

–

Second year 2006-07 – Increase Pilot Group

•

Three Feeder Areas

–

Third year 2007-08 – All School Participation

•

Three Feeder Areas

–

Fourth year 2008-09 – Further Evaluation

of Student Weighted-factors for Funding

General Fund and Other Funds

Budgets FY 2007-08 Revenues

2008 Alloc Percent of

Fund Budget Per Pupil Budget

General Fund 393.38

$ 7,858

$ 64.1%

Debt Service/Bond Redemption Fund 58.73 1,173 9.6%

Building Fund 59.00 1,179 9.6%

Capital Reserve Fund 13.32 266 2.2%

Govtl Designated Purpose Grant Fund 10.58 211 1.7%

School Discretionary Fund 2.50 50 0.4%

Nutrition Services Fund 11.06 221 1.8%

Child Care Fund 7.52 150 1.2%

Private Purpose Trusts 0.08 2 0.0%

Pupil Activity Fund 3.30 66 0.5%

Medical Self-Insurance Fund 34.45 688 5.6%

Insurance Reserve Fund 3.33 66 0.5%

Athletics and Activities Fund 11.23 224 1.8%

Mill Levy Override Fund 5.00 100 0.8%

TOTAL 613.48

$ 12,254

$ 100.0%

REVENUES BY FUND (in millions)

FY'08

General Fund and Other Funds’

Budgets FY 2007-08 Expenses

2008 Alloc Percent of

Fund Budget Per Pupil Budget

General Fund 405.28

$ 8,095

$ 58.1%

Debt Service/Bond Redemption Fund 55.85 1,116

8.0%

Building Fund 125.65 2,510

18.0%

Capital Reserve Fund 20.48 409

2.9%

Govtl Designated Purpose Grant Fund 10.77 215

1.5%

School Discretionary Fund 2.02 40

0.3%

Nutrition Services Fund 10.90 218

1.6%

Child Care Fund 7.52 150

1.1%

Private Purpose Trusts 0.08 2

0.0%

Pupil Activity Fund 3.08 61

0.4%

Medical Self-Insurance Fund 35.91 717

5.1%

Insurance Reserve Fund 3.88 78

0.6%

Athletics and Activities Fund 11.23 224

1.6%

Mill Levy Override Fund 5.00 100

0.7%

TOTAL 697.65

$ 13,935

$ 100.0%

EXPENDITURES BY FUND (in millions)

FY'08

Other Funds FY 2007-08

Changes

PROPOSED ADOPTED

BUDGET CHANGES BUDGET

FUNDS 2007-2008 2007-2008

BUILDING FUND 125.57

$ 0.08

$ 125.65

CAPITAL RESERVE FUND 22.20

$ (1.72)

$ 20.48

GRANTS FUND 10.52

$ 0.24

$ 10.76

SCHOOL DISCRETIONARY FUND 2.35

$ (0.33)

$ 2.02

NUTRITION SERVICES FUND 10.29

$ 0.61

$ 10.90

PUPIL ACTIVITY FUND 4.88

$ (1.81)

$ 3.07

INSURANCE RESERVE FUND 3.96

$ (0.08)

$ 3.88

Future Agenda

•

Revise enrollment numbers as needed

per October count

•

Report on Actual Numbers for 4

Quarter FY2006-07 and Impact on

FY2007-08 Budget

•

The Effect and Future of Student Based

Budgeting

•

Presentation of Amended Budget Prior

to October 15, 2007 as needed

Supplemental

Budget and

Appropriation

Resolution

Fiscal Year

2006-2007

Presented to the

Board of Education

June 19, 2007

Douglas County

School District RE 1

Castle Rock, Colorado

Supplemental Budget and Appropriation

Resolution for FY 2006-07

–

Govtl Designated Purpose Grant Fund

–

Nutrition Services Fund

–

Athletics and Activities Fund

–

Debt Service Fund

–

Building Fund