ࡱ> RS  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRoot Entry F+pl/WorkbookOOle ObjInfo @Oh+'0HP\p  Deri JonesMicrosoft Excel@Ζ@aߴ@$Ϲ՜.+,0( PX  T8\p Deri Jones Ba==KK-8X@"1Arial1Calibri1Calibri1Calibri1Arial1Arial1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,6Calibri16Calibri16Calibri1>141<Calibri1?Calibri1*h6 Calibri Light1Calibri1 Calibri1Calibri1Calibri1Calibri1Calibri10Calibri1Calibri1Calibri1Calibri1 Calibri1Calibri1Calibri1@Calibri""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-.)_-* #,##0_-;\-* #,##0_-;_-* "-"??_-;_-@_- ""#,##0 0.0%0.0                                                                      ff + ) + , *     P  P        `               a    @ @     @ @     @ @  @ @  @ @  !@ @  !@ @  "@ @  @ @   ! "@   @ @  "@   #  @ @  @ @   @ @  $ @ @  "@ @  @ @   @ @  " @ @  @ @  @ @  ?  @  @     @ @    @  %   &@ @  @   @   &@   @   & @           @@ @  &@ @ , , , @ @ , &@ @ , @ @ , & @ @ , @ @ , , ,  @ @ ,  @ @ ,  @ @ ,  @ @ ,  @ @ , &@ @ * * * &* * & @ @ * @ @ * *  @ @ * @ @ * * * * *  @ @ * *   *   *   *   *   *   *    * )  * )  * )  * )  * )  * )  * )  * * * *  @ @   @ @  @ @ * '@ @ * *  @ @ * @ @ *  @ @ *   "@ @  "@ @  "!@ @  ""@ @  @ @ , , @   @  (@ @  ( ( @ @  ||}A}  "-"??_-ef-@_- }A}  "-"??_-ef-@_- }A}  "-"??_-ef-@_- }A}  "-"??_-ef-@_- }A}  "-"??_-ef-@_- }A}  "-"??_-ef -@_- }A}  "-"??_-L-@_- }A}  "-"??_-L-@_- }A}  "-"??_-L-@_- }A}  "-"??_-L-@_- }A}  "-"??_-L-@_- }A}  "-"??_-L -@_- }A}  "-"??_-23-@_- }A}  "-"??_-23-@_- }A}  "-"??_-23-@_- }A}  "-"??_-23-@_- }A}   "-"??_-23-@_- }A}!  "-"??_-23 -@_- }A}"  "-"??_--@_- }A}#  "-"??_--@_- }A}$  "-"??_--@_- }A}%  "-"??_--@_- }A}&  "-"??_--@_- }A}'  "-"??_- -@_- }A}(  "-"??_--@_- }}) } "-"??_--@_-    }}*  "-"??_--@_- ??? ??? ??? ???}-}0  "-"??_-}A}1 a "-"??_--@_- }A}2  "-"??_--@_- }A}3  "-"??_-?-@_- }A}4  "-"??_-23-@_- }-}5  "-"??_-}}6 ??v "-"??_-̙-@_-    }A}7 } "-"??_--@_- }A}8 e "-"??_--@_- }x}; "-"??_--@_  }}< ??? "-"??_--@_??? ???  ??? ???}-}?  "-"??_-}U}@  "-"??_--@_ }-}A  "-"??_-}}B}-}C?_-}-}D?_-}-}E?_-}-}F?_-}-}G?_-}-}H?_-}-}I?_-}-}J?_-}-}K?_-}-}L?_-}-}M?_-}}N}-}O?_-}-}P?_-}-}Q?_-}}R}-}S?_-}}T}A}U ?_--@_}-}V?_-}-}W?_-}-}X?_-}A}Y ?_--@_}-}Z?_-}-}[?_-}-}\?_-}}]}-}^?_-}-}_?_-}-}`?_-}-}a?_-}-}b?_-}-}c?_-}-}d?_-}-}e?_-}}f}-}g?_-}-}h?_-}-}i?_-}-}j?_-}}k}-}l?_-}-}m?_-}-}n?_-}-}o?_-}-}p?_-}-}q?_-}-}r?_-}-}s?_-}}t}}u}}}v?_--@_    }-}w?_-}-}xL?_-}-}yL?_-}-}zL?_-}-}{L?_-}-}|L?_-}-}}L?_-}-}~L?_-}-}L?_-}-}L?_-}-}L?_-}-}L?_-}-}L?_-}-}L?_-}-}L?_-}-}L?_-}}}}}}}}}}}}}}}}}}}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_-}}}}}}}}}}}}}}}}}?_--@_    }}}?_--@_    }}}}}}}}}}}-}?_-}-}?_-}-}?_-}-}?_-}-}L?_-}-}L?_-}-}?_-}-}?_-}-}?_-}-}?_-}-}?_- 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L˭ % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  L % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23 % 60% - Accent3M( 60% - Accent3 23 % 60% - Accent4M, 60% - Accent4 23f % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23Ў % "Accent1AAccent1 [ % #Accent2A!Accent2 }1 % $Accent3A%Accent3  % %Accent4A)Accent4  % &Accent5A-Accent5 Dr % 'Accent6A1Accent6  pG %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]- Comma 3 2 2.&Currency/. Currency [0]0Explanatory TextG5Explanatory Text % 1Good;Good  a%2 Heading 1G Heading 1 DTj%[3 Heading 2G Heading 2 DTj%?4 Heading 3G Heading 3 DTj%235 Heading 49 Heading 4 DTj% 6InputuInput ̙ ??v% 7 Linked CellK Linked Cell }% 8NeutralANeutral  e%"Normal9 Normal 18:Normal_Daisy Chains ;Noteb Note   <OutputwOutput  ???%????????? ???=$Percent> Percent 3 2 2 ?Title1Title DTj% @TotalMTotal %[[A Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`wCost Allocation,d }UsersjasoncAppDataLocalMicrosoftWindowsTemporary Internet FilesContent.OutlookJCCSIVQTShoebury Agreed 2012-13.xlsxCost Allocation Expend Data Occupancy 2012-13Instructions for use AssumptionsCumulative BudgetBudget 2012-14Fees and other income 2012-13Staff costs 2012-13Consumables & catering 2012-13Other Expenses 2012-13Occupancy 2013-14Fees and other income 2013-14Staff costs 2013-14Consumables & catering 2013-14Other Expenses 2013-14Actual Occupancy 10-11Actual Occupancy 11-12Income calculator 2012-13Income calculator 2013-14Staff numbers 2012-13Staff numbers 2013-14Staff costs calculator 2012-13Staff costs calculator 2013-14Expenditure 2012-13Expenditure 2013-14Breakeven calculatorPay Scales 2012-13Pay Scales 2013-14ListsOccupancy Graph VariablesYYYYYYYYYY Y Y Y Y YYYYYYYYYYYYYYZ EasternZ MidlandsZ NEZ NWZ SEZ SWZ LondonYYBZ Q1Z ?Z l@Z Q2Z UUUUUU?Z p@Z Q3Z ?Z t@Z Q4Z ?Z x@Z OUUUUU?Z |@Z YesZ ?Z @Z NoZ ?Z OUUUUU?Z  "Z  ?Z  ?Z  OUUUUU?Z  ?Z  ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z  ?Z !?Z "OUUUUU?Z #?Z $?Z %OUUUUU?Z &?Z '?Z (OUUUUU?Z )?Z *?Z +FUUUUU?Z ,?Z -?Z .FUUUUU?Z /?Z 0?Z 1FUUUUU?Z 2?Z 3?Z 4FUUUUU?Z 5?YYZ ?Z ?BEFinal BudgetsEast DivisionEast BudgetsShoebury Template.xlsxInstructions for use AssumptionsCumulative BudgetBudget 2012-14Occupancy 2012-13Fees and other income 2012-13Staff costs 2012-13Consumables & catering 2012-13Other Expenses 2012-13Occupancy 2013-14Fees and other income 2013-14Staff costs 2013-14Consumables & catering 2013-14Other Expenses 2013-14Actual Occupancy 10-11Actual Occupancy 11-12Income calculator 2012-13Income calculator 2013-14Staff numbers 2012-13Staff numbers 2013-14Staff costs calculator 2012-13Staff costs calculator 2013-14Expenditure 2012-13Expenditure 2013-14Breakeven calculatorPay Scales 2012-13Pay Scales 2013-14ListsOccupancy Graph VariablesY5Z ?Z UUUUUU?Z ?Z ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z  ?Z  ?Z  OUUUUU?Z  ?Z  ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z ?Z ?Z OUUUUU?Z  ?Z !?Z "OUUUUU?Z #?Z $?Z %OUUUUU?Z &?Z '?Z (OUUUUU?Z )?Z *?Z +FUUUUU?Z ,?Z -?Z .FUUUUU?Z /?Z 0?Z 1FUUUUU?Z 2?Z 3?Z 4FUUUUU?Z 5?;zEFinal BudgetsEast DivisionA&FFinanceUsersJasonTools and CalculatorsNursery budget - full day care 2 yrs 2011.xlsInstructions for use AssumptionsCumulative BudgetCumulative Budget 2011-13Budget 2011-13Occupancy 2011-12Fees and other income 2011-12Staff costs 2011-12Consumables & catering 2011-12Other Expenses 2011-12Occupancy 2012-13Fees and other income 2012-13Staff costs 2012-13Consumables & catering 2012-13Other Expenses 2012-13Actual Occupancy 10-11Staff numbers 2011-12Staff numbers 2012-13Income calculator 2011-12Income calculator 2012-13Pay Scales 2011-12Pay Scales 2012-13Expenditure 2011-12Expenditure 2012-13Staff costs calculator 2011-12Staff costs calculator 2012-13 VariablesOccupancy GraphBreakeven calculatorYYYYYYYYYY Y Y Y Y YYYYYYYYYYYYYZ ?Y, Hours;5  ;= ! Quarter;scale<scale<  scales;  sd;5 sdf;5tick: VAT_Rate:" VAT_Rate_Yr1:" VAT_Rate_Yr2: year; yesno;S1*Total staff costs Total cost0-2 yrs2-3 yrs3-5 yrsReallocation of baby cost %:Reallocation of toddler cost %:Revised Total costs:Revised Unit cost:Total Staff Ratio %A. COSTS OF DELIVERY Annual Hours8C. COST PER HOUR OF CHILDCARE DELIVERED, BY AGE CATEGORYCost per hour Average3Average cost per hour of childcare for all children#Allocation of "in-ratio" staff costStaff cost co-efficient Occupancy HrsOccupancy proportionStaff Ratio, 1:D. COST CALCULATOR Allocated "in-ratio" staff costsAllocated other costs:Allocated total costs:YRe-allocation of loss on baby and/or toddler places (as a cost to older age catergories):4B. ANNUAL HOURS OF CHILDCARE DELIVERED (from PART B) Under-twos Two-year-oldsThree- and four-year-oldsIIn-ratio' staff salaries (as totalled in section 1 'Annual Staff Costs')  H JNon-ratio' staff salaries (as totalled in section 1 'Annual Staff Costs')  BAll other staff costs (as noted in section 1 'Annual Staff Costs') ETotal premises costs (all costs in section 2 'Annual Premises Costs') BTotal consumables & equipment costs (all costs noted in section 3)$ BTotal office & administration costs (all costs noted in section 4)#$ 2Total additional costs (costs noted in section 5a) Irrecoverable VAT (section 5b)=Profit / Return on Capital Employed - % of costs (section 5c)1$Early Years Alliance cost calculator2@e e{fGIgjh6jxcc@ VPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V{t  dMbP?_*+%&'()M\\nc-print-1\Comms Photocopier߀ od,,LetterSCDM$,SS0EComms Photocopier߀ od,,Letter4I # 22****d `ܑddo 22L _f/222222< $"],,&U} }  } }  }  }  } B} I B} B} B} B} B} B} B} IB} B} B} B} I B>  W@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @  @ @ ) CDEEEEEEDDF CGEEEEEEGGF CG H HHHEEEGF CGEEEEEE I  GF CG J KKKLMNGF CG O!PPPQQRGF CG S"PQQQQTGF CU VWQQQQ#X %! U0 DD F CYZZZZZZ[YF CU V# WWWW\]! UW D D F CYEEEEEE^YF CU _$ ``ZZa]! UZ D D F CYEEEEEE^YF CU _%``ZZZ]! UZ DD FCYHHHHEE^YF CU _&``ZZZ]! UZ DD FCYEEEEEE^YF CU b'ccddef! Ud DD FCYEHHHEE^YF CYEHHHEE^YF CU _(ZZZag>h(D$$ $ $$$B! U/ DD FCYEEEEEE^YF CUEHEEE HCh2-DD D DDDD! U2 DD F iDEEEEEEjDFkk lm nnnnop   mq CrEEEEDDrF CsEEE EEEtsF CsEEE EDEtsF CsEEE EDEusF CEEEEEE E #v, %  EF CwwwEEEEEwF DO l, 66666 a a a a a $L 666[ g@! @ " @# @$ @ % @ & @ ' @ ( `) `* `+ `, `- `. `/ `0 `1 `2 ` 3 `4 `5 `6 `7 `8 `9 `: `; `< `= ` xy z z{{|}  y~ !yy "y " "C";-D3DAD3DB " y #y # #C#$-D3DAD3DB # y $y $ $C$1-D3DAD3DB $ y %yy &y &&!&3 D3D & y ' ( (( ) * * * ** + ++@@ @ + + , , ?,?,)D+D+D+D+?,?,)D+D+D+D+?,?,)D+D+D+D+,?-,,2 -+ , - ---D-.D-.D-., - . .!... D-D-!../ D-D-!../ D-D-../, . / /B/,D.D,AD.D,BB/-,D.D,AD.D,BB/-,D.D,AD.D,B/ , / 0 0D02.D/D/AD/D/BD00.D/D/AD/D/BD00.D/D/AD/D/B01, 0 1 1T11>ZD0D0AZD0D0BT13>ZD0D0AZD0D0BT13>ZD0D0AZD0D0B13, 1 2 2f22PZZDDA$ZZDDBf2 PZZDDA$ZZDDBf2 PZZDDA$ZZDDB20, 2 3 3C3;-D1D2AD1D2BC3#-D1D2AD1D2BC31-D1D2AD1D2B!3& D1D2 3 4 5 55 6 7 7~ 77 8 8~ 88 9 : : : : : : ; ;';;"D3D7I;;<3D3DDDD3D7D8m;;<WD3DDDD3D7D3DDDD3D7D8#;;< %;; ; < < C<<-D;DAD;DBC<;-D;DAD;DBC<;-D;DAD;DB!<< D;D < = @DL c 6 NX1%U( 6 BB Z>(>@dI  ! ggD SummaryInformation(DocumentSummaryInformation8XCompObj k Pre-School Learning Allinace Cost Allocation'Cost Allocation'!Print_Area  Worksheets Named Ranges FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q