PLANO INDEPENDENT SCHOOL DISTRICT
PROPOSED 2011 – 2012 BUDGET
LIST OF ATTACHMENTS
Attachment A
Proposed General Fund Budget
Attachment A2
General Fund Aggregate Spending
Per Student by Function Groups
Attachment B
Summary of Other Funds with
Annually Adopted Budget
Attachment C
Proposed Operating Budget by
Object
Attachment D
Proposed Operating Budget by
Function and Object
Attachment E
Proposed Budget Debt Service Fund
Attachment F
Key Indicators
Attachment G
Proposed Operating Fund Revenue
Summary for 2011-12
Attachment H
Proposed 2011-12 Budget
Comparison to Final Amended
2010-11 Budget
Attachment A
PROPOSED GENERAL FUND BUDGET
2011-2012
Operating
Fund 199
REVENUES:
Local Sources
State Sources
Federal Sources
Transfer In from PASAR
Transfer In from Off Campus PE
Transfer In from GED
Transfer in From Operating
Other Sources
$
$
APPROPRIATIONS:
11 Instruction
12 Instructional Resources and Media Services
13 Curriculum Development & Instructional Staff
18 Technology - District Wide Instructional Initiatives
19 Technology - Campus Based Instructional Initiatives
21 Instructional Leadership
23 School Leadership
31 Guidance, Counseling and Evaluation Services
32 Social Work Services
33 Health Services
34 Student Transportation
35 Food Services
36 Cocurricular/Extracurricular Activities
41 General Administration
51 Plant Maintenance and Operations
52 Security and Monitoring Services
53 Data Processing Services
61 Community Services
71 Debt Service
81 Facilities Acquisition and Construction
91 Purchase of WADA
92 Incremental Costs
93 Payments to Fiscal Agent of SSA
95 Juvenile Justice Alternative Ed Prg
97 Payments to Tax Increment Fund
99 Appraisal District Costs
$
$
OTHER USES:
Transfer out - Adventure Camp
Transfer out - Athletics
Transfer out - FANS
Transfer out - Employee Child Care
Transfer Out - eSchool
Transfer Out - Family Literacy
Transfer out - Head Start
Transfer out - Health Insurance
Transfer out - Night School
Transfer out - Special Events
Transfer out - Special Programs Center
Transfer out - Summer School
Transfer out - Other
Total Other Resources and (Uses)
Net Revenues and Other Sources over
Appropriations and Other Uses
G:\Finance\12 Budget\Budget Adoption Packet\FINAL Board Budget Adoption Packet.xls\A General Fund
Attachment A2
PROPOSED GENERAL FUND BUDGET
2011-2012
AGGREGATE SPENDING PER STUDENT BY FUNCTION GROUPS
Tuition
Reimbursement
Fund 166
Operating
Fund 199
Family
Literacy
Fund 480
Special
Programs
Fund 179
Athletics
Fund 169
General Fund
Total
Proposed
Budget/
Refined ADA
52,746
%
APPROPRIATIONS:
INSTRUCTION
11 Instruction
12 Instructional Resources and Media Services
13 Curriculum Development & Instructional Staff Development
18 Technology - District Wide Instructional Initiatives
19 Technology - Campus Based Instructional Initiatives
TOTAL INSTRUCTION
INSTRUCTIONAL SUPPORT
21 Instructional Leadership
23 School Leadership
31 Guidance, Counseling and Evaluation Services
32 Social Work Services
33 Health Services
36 Cocurricular/Extracurricular Activities
61 Community Services
93 Payments to Fiscal Agent of SSA
95 Juvenile Justice Alternative Ed Prg
TOTAL INSTUCTIONAL SUPPORT
CENTRAL ADMINISTRATION
41 General Administration
TOTAL CENTRAL ADMINISTRATION
DISTRICT OPERATIONS
34 Student Transportation
35 Food Services
51 Plant Maintenance and Operations
52 Security and Monitoring Services
53 Data Processing Services
81 Facilities Acquisition and Construction
TOTAL APPRTNS. BEFORE OTHER COSTS
OTHER COSTS
91 Purchase of WADA
92 Incremental Costs
97 Payments to Tax Increment Fund
99 Appraisal District Costs
PLANO INDEPENDENT SCHOOL DISTRICT
Summary of Other Funds
with Annually Adopted Budget
2011-2012 Budget
Budgeted
Revenues
Budgeted
Appropriations
Change to
Fund Balance
Other Funds:
Food and Nutritional Services
$ 22,384,502
$
22,795,086
$
(410,584)
Debt Service Fund
$ 111,541,977
$ 115,171,892
$
(3,629,915)
Budgeted
Revenues
Budgeted
Appropriations
Transfer To
(From) Operating
7,432,200
$
5,145,619
$
Other Funds w/Transfers to (from) Operating:
PASAR After School Care
$
2,286,581
Employee Child Care
$
762,980
$
768,110
$
(5,130)
Special Events
$
151,500
$
183,252
$
(31,752)
* Construction and Special Revenue Funds are budgeted on a project basis at the time of the bond
sale or grant award and are not required to be budgeted on an annual basis.
G:\Finance\12 Budget\Budget Adoption Packet\FINAL Board Budget Adoption Packet.xls\B Sum of Other Funds
6/8/2011
Proposed Operating Budget
FY 2011-2012
By Object
2010-2011
Adopted
Budget
REVENUES
5700 LOCAL REVENUES
5800 STATE REVENUES
5900 FEDERAL REVENUES
7900 TRANSFER IN
GRAND TOTAL REVENUES
APPROPRIATIONS/OTHER USES
TOTAL ALL FUNCTIONS:
6100 SALARY & BENEFITS
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6500 DEBT SERVICE
6600 CAPITAL OUTLAY
8900 OTHER USES
TOTAL
Attachment D
Proposed Operating Budget
FY 2011-2012
By Function and Object
2010-2011
Adopted
Budget
REVENUES
5700 LOCAL REVENUES
5800 STATE REVENUES
5900 FEDERAL REVENUES
7900 TRANSFER IN - PASAR
7900 TRANSFER IN - Off Campus PE
7900 TRANSFER IN - GED
7900 OTHER SOURCES
GRAND TOTAL REVENUES
APPROPRIATIONS/OTHER USES
FUNCTION 11 - INSTRUCTION
6100 SALARY & BENEFITS
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
FUNCTION 11 TOTAL
FUNCTION 12 - INSTRUCTIONAL RESOURCES & MEDIA SERVICES
6100 SALARY & BENEFITS
$
$
7,102,833
6200 CONTRACTED SERVICES
140,776
6300 SUPPLIES & MATERIALS
871,912
6400 OTHER OPERATING EXPENSES
28,535
6600 CAPITAL OUTLAY
FUNCTION 12 TOTAL
$
8,144,056
$
6,477,322
117,776
804,760
23,115
7,422,973
Change
$
$
$
6,599
1,761
44
43
8,447
$
4,850
$
123
2
15
-
$
(625,511)
(23,000)
(67,152)
(5,420)
(721,083)
$
140
FUNCTION 13 - CURRICULUM DEVELOPMENT & INSTRUCTIONAL STAFF DEVELOPMENT
6100 SALARY & BENEFITS
$
4,095,503
$
$
4,590,070
6200 CONTRACTED SERVICES
609,533
774,534
6300 SUPPLIES & MATERIALS
353,464
362,190
6400 OTHER OPERATING EXPENSES
371,286
448,786
6600 CAPITAL OUTLAY
FUNCTION 13 TOTAL
$
6,175,580
$
5,429,786
$
(494,567)
(165,001)
(8,726)
(77,500)
(745,794)
$
78
12
7
7
$
104
FUNCTION 18 - DISTRICT INSTRUCTIONAL COMPUTING INITIATIVES
6200 CONTRACTED SERVICES
$
260,500
$
6300 SUPPLIES & MATERIALS
649,320
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
7,000
$
FUNCTION 18 TOTAL
$
916,820
$
240,500
548,320
7,000
795,820
(20,000)
(101,000)
(121,000)
$
$
5
10
15
FUNCTION 19 - CAMPUS INSTRUCTIONAL COMPUTING INITIATIVES
6200 CONTRACTED SERVICES
$
$
6300 SUPPLIES & MATERIALS
422,375
6600 CAPITAL OUTLAY
FUNCTION 19 TOTAL
$
422,375
$
418,795
418,795
$
(3,580)
(3,580)
$
-
$
8
$
(168,144)
0
(6,376)
(174,520)
$
44
1
1
$
2,322,765
19,476
48,166
32,204
2,422,611
$
46
$
(682,672)
(24,790)
(96,944)
(14,131)
(818,537)
$
392
2
5
1
$
20,651,613
96,910
255,074
59,793
21,063,390
$
400
$
FUNCTION 21 - INSTRUCTIONAL LEADERSHIP
6100 SALARY & BENEFITS
$
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
FUNCTION 21 TOTAL
$
FUNCTION 23 - SCHOOL ADMINISTRATION
6100 SALARY & BENEFITS
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
FUNCTION 23 TOTAL
$
$
2,490,909
19,476
48,166
38,580
2,597,131
21,334,285
121,700
352,018
73,924
21,881,927
$
G:\Finance\12 Budget\Budget Adoption Packet\FINAL Board Budget Adoption Packet.xls\D Operating by Function
Attachment D
Proposed Operating Budget
FY 2011-2012
By Function and Object
2010-2011
Adopted
Budget
FUNCTION 31 - GUIDANCE, COUNSELING & EVALUATION SERVICES
6100 SALARY & BENEFITS
$
$
14,661,609
6200 CONTRACTED SERVICES
279,227
6300 SUPPLIES & MATERIALS
869,860
6400 OTHER OPERATING EXPENSES
77,950
6600 CAPITAL OUTLAY
12,000
FUNCTION 31 TOTAL
$
15,900,646
$
FUNCTION 32 - SOCIAL WORK SERVICES
6100 SALARY & BENEFITS
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
FUNCTION 32 TOTAL
FUNCTION 33 - HEALTH SERVICES
6100 SALARY & BENEFITS
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
FUNCTION 33 TOTAL
$
$
897,710
6,421
4,993
3,121
912,245
2011-2012
Proposed
Budget
$
$
$
$
4,127,597
12,360
78,324
12,854
4,231,135
FUNCTION 34 - STUDENT TRANSPORTATION
6100 SALARY & BENEFITS
$
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
FUNCTION 34 TOTAL
$
FUNCTION 36 - COCURRICULAR/EXTRACURRICULAR ACTIVITIES
6100 SALARY & BENEFITS
$
$
3,475,259
6200 CONTRACTED SERVICES
104,484
6300 SUPPLIES & MATERIALS
332,451
6400 OTHER OPERATING EXPENSES
1,011,796
6600 CAPITAL OUTLAY
FUNCTION 36 TOTAL
$
4,923,990
$
3,342,963
95,663
315,367
978,361
4,732,354
$
FUNCTION 41 - GENERAL ADMINISTRATION
6100 SALARY & BENEFITS
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
FUNCTION 41 TOTAL
6,011,413
1,095,424
444,888
545,003
8,096,728
$
6,826,058
31,508,227
2,594,087
748,024
41,676,396
$
FUNCTION 35 - FOOD SERVICE
6100 SALARY & BENEFITS
6300 SUPPLIES & MATERIALS
FUNCTION 35 - TOTAL
$
$
$
$
$
-
6,608,453
1,189,724
489,888
677,443
8,965,508
FUNCTION 51 - PLANT MAINTENANCE & OPERATIONS
6100 SALARY & BENEFITS
$
7,389,537
6200 CONTRACTED SERVICES
32,894,655
6300 SUPPLIES & MATERIALS
2,525,311
6400 OTHER OPERATING EXPENSES
722,159
6600 CAPITAL OUTLAY
182,500
FUNCTION 51 TOTAL
$
43,714,162
$
$
$
$
$
$
$
G:\Finance\12 Budget\Budget Adoption Packet\FINAL Board Budget Adoption Packet.xls\D Operating by Function
Attachment D
Proposed Operating Budget
FY 2011-2012
By Function and Object
2010-2011
Adopted
Budget
FUNCTION 52 - SECURITY & MONITORING SERVICES
6100 SALARY & BENEFITS
$
858,782
6200 CONTRACTED SERVICES
1,764,789
6300 SUPPLIES & MATERIALS
148,650
6400 OTHER OPERATING EXPENSES
129,286
6600 CAPITAL OUTLAY
FUNCTION 52 TOTAL
$
2,901,507
FUNCTION 53 - DATA PROCESSING SERVICES
6100 SALARY & BENEFITS
$
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
FUNCTION 53 TOTAL
$
FUNCTION 61 - COMMUNITY SERVICES
6100 SALARY & BENEFITS
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
FUNCTION 61 TOTAL
FUNCTION 71 - DEBT SERVICE
6500 DEBT SERVICE
FUNCTION 71 TOTAL
TOTAL ALL FUNCTIONS:
6100 SALARY & BENEFITS
6200 CONTRACTED SERVICES
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6500 DEBT SERVICE
6600 CAPITAL OUTLAY
8900 OTHER USES
TOTAL
$
Change
749,374
1,680,476
133,800
126,286
$
Proposed
Budget/
Refined ADA
52,746
$
$
FUNCTION 81 - FACILITIES ACQUISITION & CONSTRUCTION
6100 SALARY & BENEFITS
$
6300 SUPPLIES & MATERIALS
6400 OTHER OPERATING EXPENSES
6600 CAPITAL OUTLAY
FUNCTION 81 TOTAL
$
OTHER USES (transfers)
8911 ADVENTURE CAMP
8911 ATHLETICS
8911 EMPLOYEE CHILD CARE
8911 E-SCHOOL
8911 FAMILY LITERACY
8911 HEADSTART
8911 HEALTH INSURANCE
8911 NIGHT SCHOOL
8911 SPECIAL EVENTS
8911 SPECIAL PROGRAMS CENTER
8911 SUMMER SCHOOL
8911 OTHER
TOTAL OTHER USES (transfers)
Attachment D
Proposed Operating Budget
FY 2011-2012
By Function and Object
$
$
253,000
253,000
$
$
-
$
$
5
5
FUNCTION 97 - PAYMENTS TO TAX INCREMENT FUND
6400 OTHER OPERATING EXPENSES
$
4,900,000
FUNCTION 97 TOTAL
$
4,900,000
$
$
4,900,000
4,900,000
$
$
-
$
$
93
93
FUNCTION 99 - APPRAISAL DISTRICT COSTS
6200 CONTRACTED SERVICES
$
FUNCTION 97 TOTAL
$
2,450,000
2,450,000
$
$
2,450,000
2,450,000
$
$
-
$
$
46
46
457,725,737
$
422,407,818
$
(35,317,919)
$
8,008
$
23,131,747
$
30,158,348
$
439
GRAND TOTAL APPROPRIATIONS
$
REVENUES OVER (UNDER) APPROPRIATIONS$
(7,026,601)
2011-2012
Proposed
Budget
Proposed
Budget/
Refined ADA
52,746
2010-2011
Adopted
Budget
FUNCTION 93 - TUITION DEAF ED SHARED SERVICES
6400 OTHER OPERATING EXPENSES
$
253,000
FUNCTION 93 TOTAL
$
253,000
G:\Finance\12 Budget\Budget Adoption Packet\FINAL Board Budget Adoption Packet.xls\D Operating by Function
$
Change
Page 4 of 4
Attachment E
PLANO INDEPENDENT SCHOOL DISTRICT
PROPOSED BUDGET - DEBT SERVICE FUND
2011 - 2012
Estimated Revenue and Other Sources
Tax Revenue (Tax Rate $0.3334/$100 on Prelim Values)
Investment Earnings
Transfers from Construction Funds
Total Estimated Revenue and Other Sources
$
$
Proposed Debt Service Appropriations
Principal - February 15, 2012 payment
Interest - February 12 and August 2011 payments
Estimated Debt Service Fees
Total Proposed Appropriations
$
$
110,921,977
120,000
500,000
111,541,977
66,732,857
48,139,035
300,000
115,171,892
Excess Appropriations over Revenue and Other Sources
$
(3,629,915)
Estimated Beginning Fund Balance, 7-1-11
$
37,644,912
Estimated Ending Fund Balance, 6-30-12
August 2012 Payment - gross payment no BAB subsidy taken
Estimated Ending Fund Balance, 8-31-12
$
34,014,997
(21,747,624)
12,267,373
$
Estimated Ending Fund Balance, 6-30-11
$
37,644,912
August 15, 2011 Payment - gross payment no BAB subsidy taken
$
(24,440,631)
Estimated Ending Fund Balance, 8-31-11
$
13,204,281
Summary of Debt Requirements Fiscal Year 2012:
Payments August 15, 2011 & February 15, 2012
School Building Unlimited Tax Bonds - Series 2002
School Building Unlimited Tax Bonds - Series 2003
School Building Refunding Tax Bonds - Series 2004
School Building Unlimited Tax Bonds - Series 2004
School Building Refunding Tax Bonds - Series 2005
School Building Unlimited Tax Bonds - Series 2006
School Building Refunding Tax Bonds - Series 2006 CAB
School Building Refunding Tax Bonds - Series 2006 regular
School Building Unlimiited Tax Bonds - Series 2007
School Building Unlimiited Tax Bonds - Series 2008
School Building Refunding Tax Bonds - Series 2008
School Building Refunding Tax Bonds - Series 2008A
School Building Unlimiited Tax Bonds - Series 2009A- Tax Exempt
School Building Unlimiited Tax Bonds - Series 2009B- BAB's
School Building Unlimiited Tax QSCB - Series 2009C
School Building Unlimited Tax Refunding Bond - Series 2010
Total
Principal
7,935,000.00
8,515,000.00
12,620,000.00
2,140,000.00
1,855,000.00
2,857.50
3,090,000.00
2,810,000.00
2,335,000.00
4,110,000.00
3,130,000.00
1,330,000.00
16,860,000.00
66,732,857.50
G:\Finance\12 Budget\Budget Adoption Packet\FINAL Board Budget Adoption Packet.xlsE Debt Service
Attachment G
PLANO INDEPENDENT SCHOOL DISTRICT
PROPOSED 2011-2012 REVENUE SUMMARY
2010-2011
Adopted
Budget
2011-2012
PROPOSED
BUDGET
Increase
(Decrease)
in Revenue
REVENUES & OTHER SOURCES
LOCAL REVENUES
Tax Revenue
TIF Revenue
Investment Earnings
Revenue ECS
Tuition-Fare Busing
Other Tuition
Total Rental Revenue
Total Donations
Total Curriculum Sales
Total Miscellaneous
Total Local Revenue
STATE REVENUES
Per Capita (includes SFSF)
Foundation (includes SFSF)
Technology Allottment
State Indirect Costs
Shars - Medicaid
TRS On-Behalf
Total State Revenue
Attachment H
PROPOSED GENERAL FUND BUDGET
PROPOSED 2011-2012 BUDGET COMPARISION TO FINAL AMENDED 2010-2011 BUDGET
AGGREGATE SPENDING PER STUDENT BY FUNCTION GROUPS
FINAL AMENDED 2010-2011 BUDGET
General Fund
Total
Per
Refined ADA
52,415
PROPOSED 2011-2012 BUDGET
%
General Fund
Total
Per
Refined ADA
52,746
%
APPROPRIATIONS:
INSTRUCTION
11 Instruction
12 Instructional Resources and Media Services
13 Curriculum Development & Instructional Staff Development
18 Technology - District Wide Instructional Initiatives
19 Technology - Campus Based Instructional Initiatives
TOTAL INSTRUCTION
INSTRUCTIONAL SUPPORT
21 Instructional Leadership
23 School Leadership
31 Guidance, Counseling and Evaluation Services
32 Social Work Services
33 Health Services
36 Cocurricular/Extracurricular Activities
61 Community Services
93 Payments to Fiscal Agent of SSA
95 Juvenile Justice Alternative Ed Prg
TOTAL INSTUCTIONAL SUPPORT
CENTRAL ADMINISTRATION
41 General Administration
TOTAL CENTRAL ADMINISTRATION
DISTRICT OPERATIONS
34 Student Transportation
35 Food Services
51 Plant Maintenance and Operations
52 Security and Monitoring Services
53 Data Processing Services
71 Debt Service
81 Facilities Acquisition and Construction
TOTAL APPRTNS. BEFORE OTHER COSTS
OTHER COSTS
91 Purchase of WADA
92 Incremental Costs
97 Payments to Tax Increment Fund
99 Appraisal District Costs