Spreadsheet: 26c413b3-2f5b-43ac-87f8-9d75c789e099
Sheet: Sheet1

Children Young People & Families | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
School Funding Reforms
Guidance and Explanation for Appendix 1 using a sample  School 'X'
①
2013/14  School Budget Share (See note A Below) | Column A |  |  |  | Column B |  |  | Column C |  |  |  | Column D |  |  |  | Column E |  |  |  | Column F |  |  | Column G
School 'X' | 21774.02583126863 | 21774.02583126863 | 21774.02583126863 |  | -3072.99216122739 | -3072.99216122739 |  | 21156.35996236 | 21156.35996236 | 21156.35996236 |  | 22736.24221631465 | 22736.24221631465 | 22736.24221631465 |  | 24811.59682837944 |  |  |  | 1450.379566823132 | 1450.379566823132 |  | 7366.263891155133 | 7366.263891155133
 | This is the variation of the 2014/15 SBS based on No formula changes and the 2013/14 notified SBS |  |  |  | See Note B Below |  |  | This is the impact of implementing the DfE national formula changes relating to KS2 & pupil mobility data after MFG |  |  |  | This would be the impact of implementing a local decision to reduce the lump sum by £20k for each school and redistributing the funding to Basic entitlement and deprivation formula factors after MFG |  |  |  | This would be the impact of implementing a local decision to reduce the lump sum by £20k for each school and redistributing the funding to the Low Prior Attainment factor after MFg |  |  |  | See Note B Below |  |  | See Note B Below
 | Schools may still experience a variance, even though there are no forumla changes or unit rate changes. This is as a result of the on-going impact of the 2013/14 national school funding reforms and be due to the MFG/CAP
School Budget Share for 2014/15 = | ① + Col A |  |  |  |  |  |  | ① + Col C |  |  |  | ① + Col D |  |  |  | ① + Col E
 | (A figure in brackets in Appendix 1 represents a reduction) |  |  |  |  |  |  | (A figure in brackets in appendix 1 represents a reduction) |  |  |  | (A figure in brackets in appendix 1 represents a reduction) |  |  |  | (A figure in brackets in appendix 1  represents a reduction)
Example Of SBS for 2014/15 for School X
2013/14 SBS for School X | Result for Col A |  |  |  |  |  |  | Result for Col C |  |  |  | Result for Col D |  |  |  | Result for Col A
1971654 | 1993428.025831269 |  |  |  |  |  |  | 1992810.35996236 |  |  |  | 1994390.242216315 |  |  |  | 1996465.596828379
Notes:
Note A
Schools budgets for 2013/14 were issued to schools on the 15 March 2013. These variations specified in appendix 1 relate to these notifications
Note B
The amount shown in columns B,F and G are  before MFG and represents the true gains or losses that a school would face if there was no MFG in 2014/15. As it stands MFG is in place for 2014/15 and the DfE have confirmed it will continue into 2015/16 but details have bnot been provided. None the less schools need to be aware of the protection they are currently receiving through MFG or in the case of gaining schools how much is being scaled back to pay for MFG