McGlone Academy_5 year budget_80percent enrollment scenario.xlsm.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Step 1 - Build your school
3
School Name:
McGlone K-8
Enter student and school demographics in the white cells.
4
← Enter School Name and School Type in the data box on the left.
5
School Type:
2
↓ Below, it's important to be as thorough as possible to ensure
6
Student Based Budget (SBB) Revenue is calculated appropriately.
7
(Scroll above and Select School Type)
Note that ECE funding is provided separately by the Early Ed Dept.
8
Multiple Pathways Center:
no
ECE funding is NOT included in this SBB planning template.
9
(Select from Drop-down Box above)
- Enter in White Cells Only to the Left and Below -
10
11
YEAR 0YEAR 1YEAR 2YEAR 3YEAR 4YEAR 5
12
13
Salary Growth
0%0%0%0%0%0%
14
15
Free and Reduced Lunch Percentage
NA94.00%94.00%94.00%94.00%94.00%
16
17
Spanish Speaking Students
NA606.84644.28681.72681.72681.72
18
If a 6-12 school, # of grades 6-8
NA00000
19
If a 6-12 school, # of grades 9-12
NA00000
20
ACCESS 1, 2 and 3 Students
NA412.34437.78463.22463.22463.22
21
22
ECE Enrollment
NA6464646464
23
Grades K - 5 Enrollment
NA666666666666666
24
Grades 6 - 8 Enrollment
NA4896144144144
Contingency - if enrollment is at 80% of projection
25
Grades 9 - 12 Enrollment
NA00000
26
Total Enrollment
NA778826874874874
27
28
Number of Center Programs
NA11111
29
30
GT Enrollment (input only grades K-8)
NA182.687.487.487.4
31
32
Mild Moderate Enrollment
NA77.882.687.487.487.4
33
34
ECE Slots/Classroom*
NA00000
35
Kinder Slots/Classrooms*
NA00000
36
*You can use Rows 34 and 35 for ECE and Kinder Slots/Classroom data at your option if it helps you plan. Be sure to include your Kinder projection in Row 23 regardless.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Start Here - Data Entry
Step 2 - Review Revenue
Calculations - HIDE
Arts Vlookup
Step 3 - Staffing Tool
Step 4 - Non-Salary
Step 5 - Summary Review
NOTES
School's FTE list