Download original attachment
(Excel spreadsheet)
This is an HTML version of an attachment to the Freedom of Information request 'Royal Mile Primary School Budget 2009/10.'.

Summary


        
        
2008/09       
Centre NameAnnual Revised BudgetRevised Budget to DateActual to DatePeriod VarianceFull Year ForecastForecast Variance 
11170: ROYAL MILE PRIMARY580,4050606,74621,46120,02626,341 
11173: ROYAL MILE PRIMARY SP.143,138096,360** -46,778999-46,778 
11171: ROYAL MILE NURSERY CLASS79,679082,5072,8281,5332,828 
Totals** 803,222** 0** 785,613** -22,489** 22,558** -17,609Carry forward to 2009/10
        
        
        
2009/10       
        
Centre NameAnnual Revised BudgetRevised Budget to DateActual to DatePeriod VarianceFull Year ForecastForecast Variance 
11170: ROYAL MILE PRIMARY607,200404,756497,26292,506605,728-1,472 
11173: ROYAL MILE PRIMARY SP.149,471124,560110,313-14,246132,376-17,095 
11171: ROYAL MILE NURSERY CLASS83,40569,50454,197-15,30770,993-12,412 
Totals** 840,076** 598,820** 661,772** 62,952** 809,097** -30,979Expected carry forward to 2010/11
        

11170 School


           
Year :2008/09          
           
           
Centre NameGrp 2 NameAccount NameSub NameAnnual Revised BudgetRevised Budget to DateActual to DatePeriod VarianceFull Year ForecastForecast Variance 
11170: ROYAL MILE PRIMARYV100: Employee Costs1031: APTC Basic Pay101: Devolved30,552027,957-2,5950** -2,595 
11170: ROYAL MILE PRIMARYV100: Employee Costs1211: Teachers - Basic Pay101: Devolved361,6600304,590-57,0700** -57,070 
11170: ROYAL MILE PRIMARYV100: Employee Costs1251: Teachers Absence Cov Basic Pay101: Devolved10,858027,68616,8280** 16,828 
11170: ROYAL MILE PRIMARYV100: Employee Costs1261: Teachers Learn Supp Basic Pay101: Devolved12,78407,767-5,0170** -5,017 
11170: ROYAL MILE PRIMARYV100: Employee Costs1271: Teachers Visit Spec Basic Pay101: Devolved2,247026,70624,4590** 24,459 
11170: ROYAL MILE PRIMARYV100: Employee Costs1631: Learning Asst Basic Pay101: Devolved52,373057,0951,6390** 4,722 
11170: ROYAL MILE PRIMARYV100: Employee Costs1661: Auxiliary Staff Basic Pay101: Devolved4,32803,654** -6740** -674 
11170: ROYAL MILE PRIMARYV100: Employee Costs1711: Service Support Off. Basic Pay101: Devolved19,483019,032-4510** -451 
11170: ROYAL MILE PRIMARYV100: Employee Costs1731: Probationer Teachers Basic Pay101: Devolved66,594066,59400** 0 
11170: ROYAL MILE PRIMARYV200: Premises Costs2001: R & M - General101: Devolved004494490** 449 
11170: ROYAL MILE PRIMARYV200: Premises Costs2011: R & M - Day To Day101: Devolved003883880** 388 
11170: ROYAL MILE PRIMARYV200: Premises Costs2021: R & M - Controlled Day To Day101: Devolved5,56303,837-1,7265,563** -1,726 
11170: ROYAL MILE PRIMARYV200: Premises Costs2031: R & M - Planned Work101: Devolved001,1521,1520** 1,152 
11170: ROYAL MILE PRIMARYV200: Premises Costs2061: R & M - Security101: Devolved0022220** 22 
11170: ROYAL MILE PRIMARYV200: Premises Costs2151: Electricity101: Devolved9,36706,487-2,8809,367** -2,880 
11170: ROYAL MILE PRIMARYV200: Premises Costs2161: Gas101: Devolved11,639011,377-26211,639** -262 
11170: ROYAL MILE PRIMARYV250: Transport Costs2751: External Transport Hire101: Devolved001,0111,0110** 1,011 
11170: ROYAL MILE PRIMARYV250: Transport Costs2761: Operating Leases101: Devolved002002000** 200 
11170: ROYAL MILE PRIMARYV250: Transport Costs2771: Curricular Travel101: Devolved50402,3931,889504** 1,889 
11170: ROYAL MILE PRIMARYV250: Transport Costs2801: Staff Travel - Edinburgh101: Devolved1140383269114** 269 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3001: Operational Equipment101: Devolved001691690** 169 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3041: Office Equipment101: Devolved001311310** 131 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3061: Operational Materials101: Devolved001,3231,3230** 1,323 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3141: Per Capita Text Books101: Devolved10,584011-10,57311,084** -10,573 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other101: Devolved0010,47310,4730** 10,473 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other134: Discipline Task Group3,35300-3,3533,353** -3,353 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other138: Enterprise in Education2,31200-2,3122,312** -2,312 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other148: Miscellaneous-20,2650020,265-20,265** 20,265 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other174: National Priorities Action Fund - Devolved3,33700-3,3373,337** -3,337 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3301: Food & Drink101: Devolved001011010** 101 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3351: Clothing & Uniforms101: Devolved0014140** 14 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3421: Stationery101: Devolved003,9843,9840** 3,984 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3431: Photocopying101: Devolved001,2761,2760** 1,276 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3451: Advertising Posts101: Devolved5001,0931,04450** 1,044 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3461: Computer Consumables101: Devolved001901900** 190 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3511: Licences & Royalties101: Devolved3380299-39338** -39 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3601: Telephone & Fax Charges101: Devolved009379370** 937 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3611: Computer Equipment101: Devolved0013,26413,2640** 13,264 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3631: Postages - External101: Devolved0056560** 56 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3701: Training101: Devolved2,64002,534-2,2032,640** -106 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3701: Training174: National Priorities Action Fund - Devolved1,12700-1,1271,127** -1,127 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3995: Other Expenses101: Devolved8701,3821,29587** 1,295 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3997: Efficiency Savings101: Devolved-12,1750012,175-12,175** 12,175 
11170: ROYAL MILE PRIMARYV400: Third Party Payments4929: Grants Excursion Allowances101: Devolved95201,03280952** 80 
11170: ROYAL MILE PRIMARYV400: Third Party Payments6809: Rents101: Devolved00-300 0** -300 
11170: ROYAL MILE PRIMARY11170: ROYAL MILE PRIMARY  ** 580,405** 0** 606,746** 21,461** 20,026** 26,341 
           
           
           
           
Year :2009/10          
           
           
Centre NameGrp 2 NameAccount NameSub NameAnnual Revised BudgetRevised Budget to DateActual to DatePeriod VarianceFull Year ForecastForecast Variance 
11170: ROYAL MILE PRIMARYV100: Employee Costs1031: APTC Basic Pay101: Devolved32,37121,49523,6292,13428,355** -4,016 
11170: ROYAL MILE PRIMARYV100: Employee Costs1211: Teachers - Basic Pay101: Devolved363,233246,797251,2874,490301,544** -61,689 
11170: ROYAL MILE PRIMARYV100: Employee Costs1251: Teachers Absence Cov Basic Pay101: Devolved10,8317,34212,1854,84314,302** 3,471 
11170: ROYAL MILE PRIMARYV100: Employee Costs1261: Teachers Learn Supp Basic Pay101: Devolved12,5648,55510,2121,65712,255** -309 
11170: ROYAL MILE PRIMARYV100: Employee Costs1271: Teachers Visit Spec Basic Pay101: Devolved1,4991,02123,25522,23427,906** 26,407 
11170: ROYAL MILE PRIMARYV100: Employee Costs1631: Learning Asst Basic Pay101: Devolved45,04814,31853,15238,83463,783** 18,735 
11170: ROYAL MILE PRIMARYV100: Employee Costs1661: Auxiliary Staff Basic Pay101: Devolved4,4533,4572,219-1,2382,663** -1,790 
11170: ROYAL MILE PRIMARYV100: Employee Costs1711: Service Support Off. Basic Pay101: Devolved20,58713,14216,3543,21219,625** -962 
11170: ROYAL MILE PRIMARYV100: Employee Costs1731: Probationer Teachers Basic Pay101: Devolved57,93039,72748,2728,54557,926** -4 
11170: ROYAL MILE PRIMARYV200: Premises Costs2001: R & M - General101: Devolved00165165165** 165 
11170: ROYAL MILE PRIMARYV200: Premises Costs2021: R & M - Controlled Day To Day101: Devolved5,6144,6784,68236,000** 386 
11170: ROYAL MILE PRIMARYV200: Premises Costs2031: R & M - Planned Work000: General001191190** 0 
11170: ROYAL MILE PRIMARYV200: Premises Costs2031: R & M - Planned Work101: Devolved0092923,500** 3,500 
11170: ROYAL MILE PRIMARYV200: Premises Costs2151: Electricity101: Devolved8,5097,0906,582-5099,000** 491 
11170: ROYAL MILE PRIMARYV200: Premises Costs2161: Gas101: Devolved10,6098,8415,144-3,69712,000** 1,391 
11170: ROYAL MILE PRIMARYV200: Premises Costs2261: Water101: Devolved2,8052,3372,372353,000** 195 
11170: ROYAL MILE PRIMARYV200: Premises Costs2311: Refuse Disposal - External101: Devolved1,2421,0352,1551,1202,000** 758 
11170: ROYAL MILE PRIMARYV200: Premises Costs2321: Pest Control - External101: Devolved0025625625** 25 
11170: ROYAL MILE PRIMARYV250: Transport Costs2771: Curricular Travel101: Devolved001,4001,4001,400** 1,400 
11170: ROYAL MILE PRIMARYV250: Transport Costs2801: Staff Travel - Edinburgh101: Devolved10587325238400** 295 
11170: ROYAL MILE PRIMARYV250: Transport Costs2871: Taxis000: General0012120** 0 
11170: ROYAL MILE PRIMARYV250: Transport Costs2871: Taxis101: Devolved00454580** 80 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3001: Operational Equipment101: Devolved00323250** 50 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3011: Aids & Adaptations101: Devolved00343434** 34 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3051: Furniture101: Devolved00688688900** 900 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3061: Operational Materials101: Devolved008388383,700** 3,700 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3141: Per Capita Text Books101: Devolved10,6848,903144-8,759144** -10,540 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other101: Devolved009,9679,9676,198** 6,198 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other134: Discipline Task Group3,2952,7460-2,7463,295** 0 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other138: Enterprise in Education2,5152,0960-2,0960** -2,515 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other148: Miscellaneous17,60914,6740-14,6740** -17,609 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3181: Per Capita Other174: National Priorities Action Fund - Devolved2,5072,0900-2,0902,507** 0 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3301: Food & Drink101: Devolved005858100** 100 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3421: Stationery101: Devolved00598598700** 700 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3431: Photocopying101: Devolved006196191,000** 1,000 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3451: Advertising Posts101: Devolved443730-630** -13 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3461: Computer Consumables101: Devolved00142142200** 200 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3511: Licences & Royalties101: Devolved31226032767327** 15 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3563: Security - Internal Recharges101: Devolved00395395395** 395 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3601: Telephone & Fax Charges101: Devolved0041410** 0 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3611: Computer Equipment101: Devolved0017,11017,11017,110** 17,110 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3631: Postages - External101: Devolved008181180** 180 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3701: Training101: Devolved2,4722,06032-2,028500** -1,972 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3701: Training174: National Priorities Action Fund - Devolved1,3031,0860-1,0860** -1,303 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3995: Other Expenses101: Devolved87729829101,200** 1,113 
11170: ROYAL MILE PRIMARYV300: Supplies & Services3997: Efficiency Savings101: Devolved-12,175-10,146010,1460** 12,175 
11170: ROYAL MILE PRIMARYV400: Third Party Payments4929: Grants Excursion Allowances101: Devolved1,1489571,2282711,228** 80 
11170: ROYAL MILE PRIMARY11170: ROYAL MILE PRIMARY  ** 607,200** 404,756** 497,262** 92,506** 605,728** -1,472 

11173 Spec class


           
Year :2008/09          
           
           
Centre NameGrp 2 NameAccount NameSub NameAnnual Revised BudgetRevised Budget to DateActual to DatePeriod VarianceFull Year ForecastForecast Variance 
11173: ROYAL MILE PRIMARY SP.V100: Employee Costs1211: Teachers101: Devolved93,235051,087-42,1480-42,148 
11173: ROYAL MILE PRIMARY SP.V100: Employee Costs1251: Teachers Absence Cov 101: Devolved2,24800-2,2480-2,248 
11173: ROYAL MILE PRIMARY SP.V100: Employee Costs1291: Nursery Education - Basic Pay101: Devolved46,156045,240-9160-916 
11173: ROYAL MILE PRIMARY SP.V300: Supplies & Services3141: Per Capita Text Books101: Devolved1,28000-1,280780-1,280 
11173: ROYAL MILE PRIMARY SP.V300: Supplies & Services3995: Other Expenses101: Devolved179033-146179-146 
11173: ROYAL MILE PRIMARY SP.V400: Third Party Payments4929: Grants Excursion Allowances101: Devolved4000-4040-40 
11173: ROYAL MILE PRIMARY SP.11173: ROYAL MILE PRIMARY SP.  ** 143,138** 0** 96,360** -46,778** 999** -46,778 
           
Year :2009/10          
           
           
Centre NameGrp 2 NameAccount NameSub NameAnnual Revised BudgetRevised Budget to DateActual to DatePeriod VarianceFull Year ForecastForecast Variance 
11173: ROYAL MILE PRIMARY SP.V100: Employee Costs1211: Teachers 101: Devolved97,06180,88469,797-11,08883,756-13,305 
11173: ROYAL MILE PRIMARY SP.V100: Employee Costs1251: Teachers Absence Cov 101: Devolved2,3481,9570-1,9570-2,348 
11173: ROYAL MILE PRIMARY SP.V100: Employee Costs1291: Nursery Education - Basic Pay101: Devolved48,62040,51740,517048,6200 
11173: ROYAL MILE PRIMARY SP.V300: Supplies & Services3141: Per Capita Text Books101: Devolved1,2801,0670-1,0670-1,280 
11173: ROYAL MILE PRIMARY SP.V300: Supplies & Services3995: Other Expenses101: Devolved1221020-1020-122 
11173: ROYAL MILE PRIMARY SP.V400: Third Party Payments4929: Grants Excursion Allowances101: Devolved40330-330-40 
11173: ROYAL MILE PRIMARY SP.11173: ROYAL MILE PRIMARY SP.  ** 149,471** 124,560** 110,313** -14,246** 132,376** -17,095 

11171 Nursery


Year :2008/09         
Centre NameGrp 2 NameAccount NameSub NameAnnual Revised BudgetRevised Budget to DateActual to DatePeriod VarianceFull Year ForecastForecast Variance
11171: ROYAL MILE NURSERY CLASSV100: Employee Costs1211: Teachers 101: Devolved41,566037,445-4,1210-4,121
11171: ROYAL MILE NURSERY CLASSV100: Employee Costs1251: Teachers Absence Cov 101: Devolved1,1230569-5540-554
11171: ROYAL MILE NURSERY CLASSV100: Employee Costs1291: Nursery Education 101: Devolved32,374043,16610,792010,792
11171: ROYAL MILE NURSERY CLASSV100: Employee Costs1631: Learning Asst101: Devolved3,08300-3,0830-3,083
11171: ROYAL MILE NURSERY CLASSV200: Premises Costs2021: R & M - Controlled Day To Day101: Devolved003353350335
11171: ROYAL MILE NURSERY CLASSV300: Supplies & Services3001: Operational Equipment101: Devolved001271270127
11171: ROYAL MILE NURSERY CLASSV300: Supplies & Services3141: Per Capita Text Books101: Devolved1,26000-1,2601,260-1,260
11171: ROYAL MILE NURSERY CLASSV300: Supplies & Services3181: Per Capita Other101: Devolved007177170717
11171: ROYAL MILE NURSERY CLASSV300: Supplies & Services3301: Food & Drink101: Devolved001481480148
11171: ROYAL MILE NURSERY CLASSV300: Supplies & Services3995: Other Expenses101: Devolved23300-233233-233
11171: ROYAL MILE NURSERY CLASSV400: Third Party Payments4929: Grants Excursion Allowances101: Devolved4000-4040-40
11171: ROYAL MILE NURSERY CLASS11171: ROYAL MILE NURSERY CLASS  ** 79,679** 0** 82,507** 2,828** 1,533** 2,828
          
          
Year :2009/10         
Centre NameGrp 2 NameAccount NameSub NameAnnual Revised BudgetRevised Budget to DateActual to DatePeriod VarianceFull Year ForecastForecast Variance
11171: ROYAL MILE NURSERY CLASSV100: Employee Costs1211: Teachers 101: Devolved43,43236,19327,653-8,54039,128-4,304
11171: ROYAL MILE NURSERY CLASSV100: Employee Costs1251: Teachers Absence Cov101: Devolved1,1749780-9780-1,174
11171: ROYAL MILE NURSERY CLASSV100: Employee Costs1291: Nursery Education 101: Devolved34,09428,41226,154-2,25831,385-2,709
11171: ROYAL MILE NURSERY CLASSV100: Employee Costs1631: Learning Asst 101: Devolved3,2432,7020-2,7020-3,243
11171: ROYAL MILE NURSERY CLASSV300: Supplies & Services3141: Per Capita Text Books101: Devolved1,2601,0500-1,0500-1,260
11171: ROYAL MILE NURSERY CLASSV300: Supplies & Services3181: Per Capita Other101: Devolved00332332400400
11171: ROYAL MILE NURSERY CLASSV300: Supplies & Services3301: Food & Drink101: Devolved0057578080
11171: ROYAL MILE NURSERY CLASSV300: Supplies & Services3995: Other Expenses101: Devolved1621350-1350-162
11171: ROYAL MILE NURSERY CLASSV400: Third Party Payments4929: Grants Excursion Allowances101: Devolved40330-330-40
11171: ROYAL MILE NURSERY CLASS11171: ROYAL MILE NURSERY CLASS  ** 83,405** 69,504** 54,197** -15,307** 70,993** -12,412
Spreadsheet's Author: 9035659
Last Updated with Excel 97

** This cell's data may not be accurate.
 
Created with xlhtml 0.5.1