Summary of Framework Impact ‐ June 1, 2018

School Board
Calgary Roman Catholic Separate School District No. 1
Calgary School District No. 19
Edmonton Catholic Separate School District No. 7
Edmonton School District No. 7
Battle River Regional Division No. 31
Black Gold Regional Division No. 18
Chinook's Edge School Division No. 73
Christ the Redeemer Catholic Separate Regional Division No. 3
Elk Island Catholic Separate Regional Division No. 41
Elk Island Public Schools Regional Division No. 14
Foothills School Division No. 38
Fort McMurray Public School District No. 2833
Fort McMurray Roman Catholic Separate School District No. 32
Golden Hills School Division No. 75
Grande Prairie School District No. 2357
Greater St. Albert Roman Catholic Separate School District No. 734
Lethbridge School District No. 51
Medicine Hat School District No. 76
Northern Lights School Division No. 69
Palliser Regional Division No. 26
Parkland School Division No. 70
Peace Wapiti School Division No. 76
Red Deer Catholic Regional Division No. 39
Red Deer Public School District No. 104
Rocky View School Division No. 41
St. Albert Public School District No. 5565
Wolf Creek School Division No. 72
Buffalo Trail Public Schools Regional Division No. 28
Evergreen Catholic Separate Regional Division No. 2
Fort Vermilion School Division No. 52
Grande Prairie Roman Catholic Separate School District No. 28
Grande Yellowhead Public School Division No. 77
Grasslands Regional Division No. 6
Greater North Central Francophone Education Region No. 2
Holy Spirit Roman Catholic Separate Regional Division No. 4
Livingstone Range School Division No. 68
Northern Gateway Regional Division No. 10
Pembina Hills Regional Division No. 7

Annual Salary * Current FTE Level  Midpoint 
$262,405
$295,300
$362,125
$252,889
$195,840
$224,521
$216,824
$208,000
$231,000
$203,415
$214,503
$239,106
$204,000
$211,502
$199,022
$202,957
$215,859
$204,289
$199,500
$195,478
$234,060
$188,936
$215,741
$216,300
$230,416
$214,400
$205,000
$192,150
$201,176
$277,090
$205,385
$229,750
$177,735
$177,297
$197,895
$181,718
$226,142
$191,360

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

5
5
5
5
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
3
3
3
3
3
3
3
3
3
3
3

$260,000
$260,000
$260,000
$260,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000

Midpoint Adjusted 
for Current FTE 
$260,000
$260,000
$260,000
$260,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$203,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$188,000

Impact

Difference (%)

($2,405)
($35,300)
($102,125)
No impact
No impact
($21,521)
($13,824)
($5,000)
($28,000)
($415)
($11,503)
($36,106)
($1,000)
($8,502)
No impact
No impact
($12,859)
($1,289)
No impact
No impact
($31,060)
No impact
($12,741)
($13,300)
($27,416)
($11,400)
($2,000)
($4,150)
($13,176)
($89,090)
($17,385)
($41,750)
No impact
No impact
($9,895)
No impact
($38,142)
($3,360)

‐0.90%
‐12.00%
‐28.20%
No impact
No impact
‐9.60%
‐6.40%
‐2.40%
‐12.10%
‐0.20%
‐5.40%
‐15.10%
‐0.50%
‐4.00%
No impact
No impact
‐6.00%
‐0.60%
No impact
No impact
‐13.30%
No impact
‐5.90%
‐6.10%
‐11.90%
‐5.30%
‐1.00%
‐2.20%
‐6.50%
‐32.20%
‐8.50%
‐18.20%
No impact
No impact
‐5.00%
No impact
‐16.90%
‐1.80%

 Summary of Framework Impact ‐ June 1, 2018

St. Paul Education Regional Division No. 1
St. Thomas Aquinas Roman Catholic Separate Regional Division No. 38
Sturgeon School Division No. 24
Westwind Regional Division No. 74
Wetaskiwin Regional Division No. 11
Wild Rose School Division No. 66
Aspen View Public School Division No. 78
Canadian Rockies Regional Division No. 12
Clearview School Division No. 71
East Central Alberta Catholic Separate Schools Regional Division No. 16
East Central Francophone Education Region No. 3
High Prairie School Division No. 48
Holy Family Catholic Separate Regional Division No. 37
Horizon School Division No. 67
Lakeland Roman Catholic Separate School District No. 150
Living Waters Catholic Regional Division No. 42
Medicine Hat Catholic Separate Regional Division No. 20
Northland School Division No. 61
Northwest Francophone Education Region No. 1
Peace River School Division No. 10
Prairie Land Regional Division No. 25
Prairie Rose School Division No. 8
The Southern Francophone Education Region No. 4
Almadina School Society
Aurora School Ltd.
Boyle Street Educaton Centre
Calgary Arts Academy Society
Calgary Girls' School Society
CAPE‐Centre for Academic and Personal Excellence Institute
Connect Charter School Society
Foundations for the Future Charter School Society
Mother Earth's Children's Charter School Society
New Horizons Charter School Society
Suzuki Charter School Society
Valhalla School Foundation
Westmount Charter School Society
Total

$202,000
$193,257
$199,750
$193,307
$195,000
$191,167
$184,941
$220,063
$190,078
$191,785
$210,049
$205,289
$177,684
$184,866
$204,148
$183,731
$165,750
$180,000
$145,000
$188,475
$170,000
$195,452
$173,500
$50,394
$169,117
$75,474
$124,152
$132,794
$30,000
$113,390
$289,399
$72,210
$84,718
$78,125
$40,500
$140,594
$14,047,246

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0.26
1
0.2
0.6
0.6
0.5
0.6
1
1
0.48
0.4
0.22
0.6

3
3
3
3
3
3
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
1
1
2
1
1
1
1
1

$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$110,000
$110,000
$110,000
$110,000
$110,000
$110,000
$110,000
$174,000
$110,000
$110,000
$110,000
$110,000
$110,000

$188,000
$188,000
$188,000
$188,000
$188,000
$188,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$174,000
$28,600
$110,000
$22,000
$66,000
$66,000
$55,000
$66,000
$174,000
$110,000
$52,800
$44,000
$24,200
$66,000

($14,000)
($5,257)
($11,750)
($5,307)
($7,000)
($3,167)
($10,941)
($46,063)
($16,078)
($17,785)
($36,049)
($31,289)
($3,684)
($10,866)
($30,148)
($9,731)
No impact
($6,000)
No impact
($14,475)
No impact
($21,452)
No impact
($21,794)
($59,117)
($53,474)
($58,152)
($66,794)
No impact
($47,390)
($115,399)
No impact
($31,918)
($34,125)
($16,300)
($74,594)
($1,474,813)

*   These salary figures were taken from the publicly avaialble, 2016/17 Audited Financial Statement as reported by each of the identified school boards.

Expiry Window
June 1, 2018 to June 1, 2019 (12 months)
June 1, 2019 to June 1, 2020 (24 months)
June 1, 2020 to June 1, 2021 (36 months)
June 1, 2021 to June 1, 2022 (48 months)
June 1, 2022 to August 31, 2023 (63 months to final expiring contract)

Number of 
Expired 
Contracts
12
19
13
12
18

Cumulative
12
31
44
56
74

‐6.90%
‐2.70%
‐5.90%
‐2.70%
‐3.60%
‐1.70%
‐5.90%
‐20.90%
‐8.50%
‐9.30%
‐17.20%
‐15.20%
‐2.10%
‐5.90%
‐14.80%
‐5.30%
No impact
‐3.30%
No impact
‐7.70%
No impact
‐11.00%
No impact
‐43.20%
‐35.00%
‐70.90%
‐46.80%
‐50.30%
No impact
‐41.80%
‐39.88%
No impact
‐37.70%
‐43.70%
‐40.20%
‐53.10%
‐10.50%