Spreadsheet: 87586d1287479259-planning-and-forecasting-tool-748272_darren_chapman_v4
Sheet: After

 | BEAUTY | SLN | NFR | PW | ACU | DU | Funding | Total [NAME] | Achievement | [NAME] "On-Programme" POT | Month 1 Payment | Subsequent months |  | SLN | NFR | PW | ACU | DU | Funding | Total [NAME] | Achievement | [NAME] "On-Programme" POT | Month 1 Payment | Subsequent months |  | SLN | NFR | PW | ACU | DU | Funding | Total [NAME] | Achievement | [NAME] "On-Programme" POT | Month 1 Payment | Subsequent months |  | SLN | NFR | PW | ACU | DU | Funding | Total [NAME] | Achievement | [NAME] "On-Programme" POT | Month 1 Payment | Subsequent months |  | rounded per matrix
 | NVQ | 1.321 | 2500 | 1.25 | 1.2 | 1.13 |  |  |  |  |  |  |  | 1.321 | 2920 | 1.25 | 1.2 | 1.13 |  |  |  |  |  |  |  | 1.4 | 3400 | 1.25 | 1.2 | 1.13 |  |  |  |  |  |  |  | 1.5 | 3500 | 1.25 | 1.2 | 1.13
 | TC
 | Key/Func Skill Maths | 0.08 | 2500 | 1 | 1.2 | 1.13 |  |  |  |  |  |  |  | 0.08 | 2920 | 1 | 1.2 | 1.13 |  |  |  |  |  |  |  | 0.1 | 3400 | 1 | 1.2 | 1.13 |  |  |  |  |  |  |  | 0.1 | 3500 | 1 | 1.2 | 1.13
 | Key/Func Skill English | 0.08 | 2500 | 1 | 1.2 | 1.13 |  |  |  |  |  |  |  | 0.08 | 2920 | 1 | 1.2 | 1.13 |  |  |  |  |  |  |  | 0.1 | 3400 | 1 | 1.2 | 1.13 |  |  |  |  |  |  |  | 0.1 | 3500 | 1 | 1.2 | 1.13
 | ACADEMIC YEAR #
 |  | PRIOR YEAR - revenue streams (may) affect YR1
 | ACADEMIC YEAR
 | PLAN | 2009-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duration (Months)
 | NUMBER OF STARTS |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REVENUE SUMMARY BY YEAR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLANNED REVENUE | 2010/11 | 2011/12 | 2012/13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | of which CARRY INS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | of which STARTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PLANNED REVENUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL REVENUE | 2010/11 | 2011/12 | 2012/13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | of which CARRY INS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | of which STARTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL ACTUAL REVENUE
 | TOTALS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010/11 | 2011/12 | 2012/13
 | carry in total
 | start total
 | ACADEMIC YEAR
 | ACTUAL
 | NUMBER OF STARTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan | Actual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAR | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL
 | TOTALS
 | DIFFERENCE
 | cont total
 | start total
 | HEADCOUNT GRID:  STARTERS (row 51) - LEAVERS (row 52 :  listed by enrollment month denoted as total_leavers.early_completion
 | ACADEMIC YEAR
 | ACTUAL
 | [NAME] (LEAVES below) | 4 | 5 | 6 | 3 | 4 | 8 | 8 | 4 | 5 | 5 | 8 | 9 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  | 1 |  |  |  |  |  |  | 1.01 |  |  |  |  | 1 |  |  |  |  |  |  | 1.01
 |  |  |  | 1 | 1 |  |  |  |  |  |  |  | 2.02 |  | 1 |  | 1 |  |  |  |  | 1.01
 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.01
 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 1.01 | 1.01
 | TOTALS
 | ACADEMIC YEAR
 | INSTALMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O/S
 | based on Academic Year | used for "current" headcount contribution - see PLAN & ACTUAL
 | TOTALS
 | ACADEMIC YEAR
 | INSTALMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O/S
 | based on Revenue Year | used for "leaver" headcount contributions - see DEP. FEES (in turn used by ACTUAL)
 | TOTALS
 | ACADEMIC YEAR
 | RED. FEES
 | TOTALS