ࡱ> RQ g2ɀ\p Ba== @8X@"1Calibri1Calibri1Calibri1Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>Calibri14Calibri1<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1hCalibri1Arial1Arial1Arial""#,##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_-;_-* "-"??_-;_-@_-                                                                       ff + ) , *     P  P        `            a>   ( P 0@ @  (0@ @  (p@ @ + p@ @ , x@ @ , )t@ @ + )0@ @  x@ @ + x@ @ +  |@ @ +  h@ @    l@ @   <@ @  8@ @   (@ @    ,@ @  x@ @ , ||R"}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-}  _-;_-* "}-}  _-;_-* "}-}  _-;_-* "}-}  _-;_-* "}-}  _-;_-* "}-} _-;_-* "}-} _-;_-* "}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}( _-;_-* "-@_- }}) }_-;_-* "-@_-    }}* _-;_-* "-@_- ??? ??? ??? ???}-}+ _-;_-* "}-}, _-;_-* "}-}- _-;_-* "}-}. _-;_-* "}-}/ _-;_-* "}A}0 a_-;_-* "-@_- }A}1 _-;_-* "-@_- }A}2 _-;_-* "?-@_- }A}3 _-;_-* "23-@_- }-}4 _-;_-* "}}5 ??v_-;_-* "̙-@_-    }A}6 }_-;_-* "-@_- }A}7 e_-;_-* "-@_- }}8 _-;_-* "-@_-    }}9 ???_-;_-* "-@_- ??? ??? ??? ???}-}: _-;_-* "}-}; _-;_-* "}U}< _-;_-* "-@_-  }-}= _-;_-* "}-}> _-;_-* "}-}? _-;_-* "}-}@ _-;_-* "}-}A _-;_-* "}-}B _-;_-* "}A}C _-;_-* "-@_- }A}D _-;_-* "L-@_- }A}E _-;_-* "L-@_- }A}F _-;_-* "-@_- }-}G _-;_-* "}<}H _-;_-* "-@_}<}I _-;_-* "-@_}<}J _-;_-* "-@_}(}K _-;_-* "}(}L _-;_-* "}(}M _-;_-* "}(}N _-;_-* "}(}O _-;_-* "}(}P _-;_-* "}<}Q _-;_-* "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 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%3Normal % 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium2PivotStyleMedium9`!IOrganisation Information .RStaffing DetailSheet1,  ;  ;c' Organisation NameFinance3Are Estates and Facilities two distict departments?YesDo you have any other teams managed through the facilities/estates department? (eg. Health and Safety, Capital Projects team, other - please list)qIs the separation of duties Facilities manages Soft FM, and Estates manages Hard FM? (If dirrernt please explain)Which Division/Department does Faciltiies/Estates report into? (eg. Estates specific Directorate, Finance, Patient Safety, Nursing, other - please list)>Does your organisation have only one internal facilities team? Job TitleAFC Band$Number Employed by Your Organisation2016/17 turnover percentage+Facilities Specific Qualification Required?Yes BIFM Level 4Example Role 1Example Role 28aDomestic AssistantCatering Assistant%If Yes, What Body and Level required? Any Comments?"Director of Estates and FacilitiesSwitchboard SupervisorEstates OfficerIMSc In Facilities Management, Level 4 Food Hygiene, IOSH Managing SafelyExample NHS Foundation TrustInsert Your Organisation NameMAre Facilities and Estates two distinct Departments within your organisation?mWhat Director/Division do Facilities and Estates report into? (eg. Estates, Finance, Patient Safety, Nursing)ANo, there are three, one for each Division who work independently|If Yes, Is this as part of a national initiative (eg. Vanguard Site, Manchester Devolution, Joint Venture etc please detail)GDoes your organisation have only one centrally managed Faciltiies team?+If applicable please detail the job roles/sFNo, it is a locally agreed between two NHS Mental Health OrganisationsNo @If Yes, to what extent? What services? What cost? Please outline)Do you have outsourced Soft FM provision?"No all Soft FM managed internally +Yes all managed through an outside provider,Do you have an outsourced Hard FM provision?jDo you use NHS Property Services as a Facilities Service Provider (please detail any service they provide)HIs Health and Safety Managed as part of the Facilities and Estates Team??Is Security Managed as part of the Facilities and Estates Team?CDo you have a dedicated Trust Environmental/Sustainability Manager?CIf yes are they managed as part of the Faciltiies and Estates Team?BIf yes, what was the value of this for the 2016/17 financial year?]Does your organisation employ an external deep clean company (in addition to any Soft FM SLA)N/A7Do Facilities and Estates fall under the same Director?5What Services do Estates manage in your organisation?All SLA's and Services relating to Cleaning, Catering, Linen, Transport, Site Management, PLACE, Waste, Cleanliness Monitoring, SecurityvDo you have a separate department for new build programmes (eg. A Capital Planning Team?) If Yes what are they called?Yes, Strategic Planning TeamAll SLA's and Services relating to Planned and Reactive Estates works, Health and Safety, Utility Management, Leasing and Property Management, Surveying and estates building auditingeDoes your Organisation have a strategic plan for the outsourcing of Facilities and Estates Services? ,Were any leavers repalced like for like WTE?No8What Services do Facilities manage in your organisation?-One leaver was not replaced as a cost saving@Do you share a facilities manager with another NHS Organisation?Accommodation AdministratorBand 4Admin Assistant/Cashier AdministratorAssistant Head CookBand 3,Associate Director of Estates and FacilitiesBand 9CashierBand 1Catering Clerk SupervisorCatering ManagerBand 5Band 6Catering SupervisorClerical AssistantBand 2Clerical OfficerContract Services Manager CookDeputy Hotel Service ManagerDeputy Hotel Services ManagerDomestic Services ManagerDomestic SupervisorDriver E&F ManagerBand 7Band 8aE&F Maintanance CraftspersonE&F Maintenance Craftsperson ElectricianEquipment Loan Store AssistantEstates Admin SupervisorEstates ManagerFitterGardenerGovernance and Risk FacilitatorGrounds & Gardens Officer#Head of Capital & Property ServicesBand 8bHead of Operational EstatesHotel Services ManagerHotel Services Officer,Hotel Services Training & Audit Co-ordinatorKitchen ManagerLinen Room AssistantLinen Services AssistantLinen Services SupervisorMaintenance AssistantMaintenance OperativeMaintenance SupervisorMedical Electronics ClerkMedical Engineering Technician#Medical Equipment Loan Store Co-ordMedical Equipment Manager!Medical Technical Officer Grade 1!Personal Assistant/Office ManagerPersonal SecretaryPorterPorter/Domestic HelperPortering SupervisorReceptionist/Post Room Clerk SecretarySenior Domestic SupervisorSenior Fire Safety Advisor Senior Linen Services SupervisorSenior Switchboard SupervisorSpecialist Medical EngineerStorekeeper/PorterSwitchboard Operator Team LeaderTransport Clerk"Waste Control/Minimisation OfficerBNot readily available and would take more than 18 hours to create.4 7L7l8:<\o> +Ar NB B+mCDLD{ESF8GHWccB g2ɀ KpQ  dMbP?_*+%,&jZ?'jZ?(~?)~?MC 4dXXA4%" FXX BP(? BP(?&\(U} (?} ?} $ ?` @q>X@@t@XX X ,   @@@@@@9@(@@@ @ @ @ @ @ @A D E B CB B: C3B B2 C6B B4 C5B B1 CB B CB B CB B< C  B B! C B B C" B B) C# B B$ C0 B B% C&B B( C'B B* CB B+ CB B, CB B- CB B/ CB B.~ F@G B7 C#B2dT&&&&&&&&&&&&&&&&&&&&&> @db(b(2PggD g2ɀ \@Tdu  dMbP?_*+%,.&jZ?'jZ?(~?)~?MC 4dXXA4%" AXX BP(? BP(?&\(U} ?} m?} ?} ?} $#?} $?} (?} !?} $ ?\>>>>>>X>X>X> X> X> X> X> X>X>X>X>X>X>X>X>X>X>X>X>X>X>X>X>X>X>X> Q Q Q Q Q8 Q Q Q HI@I$@J$@ J9 I I I; H II?J J0 I II K= K>K?L M M M N0 O? O>O?P M M M N0 O@ O>O?P M M M N0 OA OBO4@P M M M N0 OC ODO?P M M M N0 OE OBO@P M M M N0 O OF~ OX@ P5!({_? M M M N0 OG OB O?P M M M N0 OH OI O@P M M M N0 OH OJ O?P M M M N0 OK OB O?P? M M M N0 OL OMO?P M M M N0 ON OM~ O&@PF]tE? M M M N0 KN KBK?L M M M N0 OO OJO?P M M M N0 OP OM~ O3@Pqq? M M M N0 OQ O>O?P M M M N0 OR OIO@P M M M N0 OR OJO?P M M M N0 O OF~ Oq@PL? M M M N0 O OM~ O1@PAA? M M M N0 OS OIO@P M M M N0 OT OBO4@P@ M M M N0 OU OF~ O6@P? M M M N0 OV OWO@P M M M N0 OV OXO@P M M M N0 OY OIO@PT@ M M M N0 OZ O>O@@P M M M N0 O[ OIO@PT@ M M M N0Dlpbfjjjjjjtjjjjjtjjtjjjttjjtjjjj X>!X>"X>#X>$X>%X>&X>'X>(X>)X>*X>+X>,X>-X>.X>/X>0X>1X>2X>3>4X>5X>6X>7X>8X>9X>:X>;X><X>=X>>X>?X> O\ OM O@P M M M N0 !O] !O>!O?P !M !M !M !N0 "O^ "OW"O?P "M "M "M "N0 #O #OW#O@PD@ #M #M #M #N0 $O_ $O>$O@P $M $M $M $N0 %O` %OM%O@P %M %M %M %N0 &O` &OB&O?P &M &M &M &N0 'Oa 'OI'O?P 'M 'M 'M 'N0 (Ob (OI(O?P (M (M (M (N0 )Oc )Od)O?P )M )M )M )N0 *Oe *Od*O?P *M *M *M *N0 +Of +OW+O@P +M +M +M +N0 ,Og ,OJ,O?P ,M ,M ,M ,N0 -Oh -O>-O?P -M -M -M -N0 .Oi .O>.O@P .M .M .M .N0 /Oj /OF~ /O"@/Pqq? /M /M /M /N0 0Ok 0OM0O@P 0M 0M 0M 0N0 1Ol 1OB1OP? 1M 1M 1M 1N0 2Om 2OB~ 2O @2P? 2M 2M 2M 2N0 3On 3OB3O@P 3M 3M 3M 3N0 4Oo 4OI4O@P 4M 4M 4M 4N0 5Op 5OM5O?P 5M 5M 5M 5N0 6Oq 6OI6O?P 6M 6M 6M 6N0 7Or 7O>7O@P 7M 7M 7M 7N0 8Os 8OX8O?P 8M 8M 8M 8N0 9Ot 9O>9O@P 9M 9M 9M 9N0 :Ou :OI:O?P :M :M :M :N0 ;Ov ;OB;O@P ;M ;M ;M ;N0 <Ov <O>~ <O@<PUUUUUU? <M <M <M <N0 =Ow =OM=OS@P =M =M =M =N0 >Ox >OF>O@P >M >M >M >N0 ?Oy ?OB?O @P ?M ?M ?M ?N0Dljjjjjjjjjjjjjjjtjjtjjjjjjjjjtjj@X>AX>BX>CX>DX>EX>FX>GX>HX>IX>JX@KX@LX@MX@NX@OX@PX@QX@RX@SX@TX@UX@VX@WX@XX@YX@ZX@[X@ @Oz @OM@O@P @M @M @M @N0 AO{ AOBAO@P AM AM AM AN0 BO| BO>BO?P BM BM BM BN0 CO} COJCO?P CM CM CM CN0 DK~ DK>DK?L DM DM DM DN0 EK EK>EKL EM EM EM EN0 FO FOIFO?P FM FM FM FN0 GO GOJGO@P GM GM GM GN0 HO HOBHO?P HM HM HM HN0 IO IOMIO0@P IM IM IM IN0 JO JOBJO?P JM JM JM JN0 KO KOIKO?P KM KM KM KN0 LO LOWLO?P? LM LM LM LN0 MO MOMMO@P MM MM MM MN0 NO NOJNO?P NM NM NM NN0OBBBBBBBBPBBBBBBBBQBBBBBBBBRBBBBBBBBSBBBBBBBBTBBBBBBBBUBBBBBBBBVBBBBBBBBWBBBBBBBBXBBBBBBBBYBBBBBBBBZBBBBBBBB[BBBBBBBB< jjjjjjjjjjjjjjj>@(<BBA ; ;; b(b(6p0ggD g2ɀ   dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3U>@ggD Oh+'0@HT` x Microsoft Excel@| #@\k,՜.+,0PHP X`hp x  Organisation Information Staffing DetailSheet1)'Organisation Information '!Print_Titles'Staffing Detail'!Print_Titles  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@BCDEFGHJKLMNOPRoot Entry FWorkbook{SummaryInformation(ADocumentSummaryInformation8I