{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Lookup","New Dept. ID - Banja Luka","New Dept. ID  - Sarajevo","New Dept. ID  - Camp Butmir"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[[45,1,45,4],[49,1,49,4],[61,1,61,4],[60,1,60,4],[54,1,54,4],[56,1,56,4],[43,1,43,4],[44,1,44,4],[30,2,31,4],[35,1,35,4],[37,1,37,4],[41,1,41,4],[42,1,42,4],[39,1,39,4],[33,1,33,4],[11,0,11,4],[13,1,13,4],[15,1,15,4],[24,1,24,4],[18,1,18,4],[17,1,17,4],[20,1,20,4],[22,1,22,4]]}
["Instructions for completing the Activate/Inactivate/Change Department ID form"]
[]
["The originator will request a new Dept. ID based on the following criteria."]
[null,"--New physical location"]
[null,"--New manager at the physical location"]
[null,"--New intermediate allocation"]
[null,"--New indirect activity that needs to have its costs tracked, i.e. Compliance Reviews"]
[null,"--Others that we deemed necessary for the creation of new dept, i.e, ir&d transfer costs"]
[]
["A change would be requested if the manager; description, or location of an existing ID changes. "]
[]
["A Dept. ID is inactivated when an intermediate allocation is eliminated or an existing location is closed.  No Dept. ID will be inactivated unless final billing is complete and costs are no longer charged against the ID."]
[]
["1.","Select Activate, Inactivate, or Change (in subject field) based on the criteria above."]
[]
["2.","The Effective Date that the Department ID will need to be activated, inactivated is always  first day of current year (ex.1/1/09). This does not apply to change - dates could be any day of the month."]
[]
["3.","The Business Unit (5 digit code), Operating Unit (3 digit code), and OU Description are PeopleSoft fields that correspond to the requestor’s area.  This information is located on the ManTech Intranet under the PS 8.9 Financials. Navigate to:                                                          Set up Financials/Supply chain > Design ChartFields > Define Values > Chartfield Values. "]
[null,"https://ps89web.mantech.com/"]
[]
["4.","GL assigns a 5-digit code to the Dept. ID field when activating a new department.  The requestor should provide the Dept. ID in the case of inactivating or changing an existing ID."]
[]
["5.","Provide the name of a Dept. ID to be created or the existing name of a Dept. ID to be inactivated or changed in the Department Description field.  This field may only be 30 characters in length and will be entered into PeopleSoft as written."]
[]
["6.","The Department Type field relates the Department ID to the appropriate Burden Type.  Please choose one of the following."]
[null,"PRB","This department type is used for all Human Resource departments."]
[null,null,"Allocation type maybe required. Contact Jay Romyn for new allocation type. "]
[null,"Intermediate","This department type is used for all Intermediate Allocation departments."]
[null,null,"Allocation type is required."]
[null,null,"For new allocation type setup contact Jay Romyn. "]
[null,"Regular","This department type is used for all departments with overhead, G&A, material handling, and special allocation costs."]
[]
[]
["7.","Directions for the Ops Structure #1 and #2 block on the Dept ID Request Form: In coordination with HR and the Financials (Joe Willever) Ops Structure, Corporate (GL) maintains a department tree used as an alternate reporting structure.  This allows Groups to lump costs/personnel/revenue together regardless of the GLBU/Op unit.  In PS Financials, go to Set Up Financials/Supply Chain > Product Related > Project Costing > Operations Structure Reporting to see the available choices of Ops Structure Level #1 and Level #2 by Group ID. \n"]
[]
["8.","Please include all the relevant information (address, county, city, state, zip code, country) regarding the Location of the Department ID as possible. This is required for location code set up by Corporate HR and also required by the Tax Dept. to properly identify the location of the asset and for revenue apportionment purposes."]
[]
["9.","It is necessary to indicate the HR Code for this code tie to Location code setup.  AAP stands for Affirmative Action Plan. For codes please refer to your respective HR Rep. within your BU. Also, Corp.HR created a table for location, so pls. indicate whether ManTech or customer site."]
[]
["10.","It is necessary to indicate, in the Headcount field, whether employees will charge labor hours to the Department ID.  This information is passed onto HR and Time & Labor."]
[]
["11.","Budget level : Yes/No. If yes, will be used to extract data to Hyperion otherwise will default to No"]
[null,"Select Yes/No: "]
[null,"a. Attn: Field Offices - select \"YES\" for Intermediate & PRB dept types and \"NO\" to Regular."]
[null,"b.Corporate Offices - select \"YES\" for all dept types."]
[null,"c. If the box not checked will default to \"No\"."]
[]
["12.","Dept. Manager and HR Rep for Department are required."]
[]
["13.","The Justification should provide the rationale in support of the new Dept. ID or explanation for inactivating or making a change to an ID."]
[]
["14.","Floor check POC's are required by DCAA for floor check purposes. "]
[null,"These POC's are the people to escort DCAA when they arrive for floor check."]
[]
["15.","The Business Operations Manager’s signature of approval is required."]
[]
["16.","Submit the form to the GL Department."]

{"sheet":"Lookup","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["Yes","Intermediate"]
["No","PRB"]
[null,"Regular"]

{"sheet":"New Dept. ID - Banja Luka","index":2,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[48,0,52,8],[5,1,5,5],[3,1,3,5],[3,7,3,8],[17,4,17,8],[18,1,18,2]]}
["ManTech International Corporation"]
["\"Activate DEPARTMENT ID\""]
[]
["TO:","General Ledger",null,null,null,null,"Date:","2010-04-26"]
[]
["FROM:","Lindy Martin"]
[null,"Name of Requestor"]
["SUBJECT:","Activate",null,"Inactivate",null,"Change",null,"(Select One)"]
[]
["Effective Date:","2010-04-26",null,"Business Unit:",null,"MTISC"]
[null,null,null,null,null,"BU"]
["Operating Unit:","450",null,"MTISC 450"]
[null,"OU",null,"Description"]
["Department:",null,null,null,null,"NATO CIS O&M Banja Luka"]
[null,"Dept. ID (Inactivate or Change Only)",null,null,null,"Dept. Description (30 Characters)"]
["Department Type:"]
[]
[null,null,null,null,"Dept Tree Manager"]
["If intermediate / PRB: ","NOALL",null,null,null,"GCIS",null,"NATO"]
["(if no alloc type, enter NOALL)","Allocation type",null,null,null,"OPS Structure 1",null,"OPS Structure 2"]
[]
["Location:","Kraljice Marije 8"]
[null,"Street Address 1"]
[]
[null,"Street Address 2",null,null,null,null,null,"County (if applicable)"]
[null,"Banja Luka",null,null,null,null,null,78000]
[null,"City,",null,null,null,"State",null,"Zip Code"]
[null,"Bosnia & Herzegovina"]
[null,"Country"]
[]
["HR Location Table :","Mantech Site",null,"Client Site"]
["(please select one)"]
[null,"M"]
["HR Code:","AAP"]
[]
["Headcount:","Will employees charge labor hours to this Department ID?"]
[]
["Budget Level:","Will department be budgeted?"]
[null,"Attn: Field Offices - If Intermediate or PRB dept type must choose YES"]
[null,"If Corp dept must choose YES"]
[]
["Manager:",null,null,null,null,null,"Stacy Setser"]
[null,"New Dept. ID Manager",null,null,null,null,"HR Rep."]
["Floorcheck POC's:","Kim Gundolfi "]
[null,"POC 1(Point of Contact1) ",null,null,null,null,"POC 2(Point of Contact2)"]
[]
["Justification:"]
["Explain the intended use of the new Dept. ID or a change (i.e. Provide rationale in support of the new Dept. ID or a change)"]
["ManTech Bid for Outsourcing NATO CIS O&M in Bosnia-Herzegovina"]
[]
[]
[]
[]
[]
["Approval:",null,null,null,null,null,"Date:",null,{"$f":"+H4","v":"2010-04-26"}]
[null,"Business Operations Manager"]
["(For Accounting Use Only)"]
["Department:"]
[null,"Dept. ID",null,"Dept. Description (30 Characters)"]
["Approval:",null,null,null,null,null,"Date:"]
[null,"Deputy Controller"]
["Coordination:",null,null,null,null,null,"Date:"]
[null,"Functional Systems Manager"]
["Coordination:",null,null,null,null,null,"Date:"]
[null,"Human Resources"]
["Approval:",null,null,null,null,null,"Date:"]
[null,"Compliance (when needed)"]

{"sheet":"New Dept. ID  - Sarajevo","index":3,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":false,"merged":[[18,1,18,2],[48,0,52,8],[0,0,0,8],[1,0,1,8],[3,1,3,5],[3,7,3,8],[5,1,5,5],[17,4,17,8]]}
["ManTech International Corporation"]
["\"Activate DEPARTMENT ID\""]
[]
["TO:","General Ledger",null,null,null,null,"Date:","2010-04-26"]
[]
["FROM:","Lindy Martin"]
[null,"Name of Requestor"]
["SUBJECT:","Activate",null,"Inactivate",null,"Change",null,"(Select One)"]
[]
["Effective Date:","2010-04-26",null,"Business Unit:",null,"MTISC"]
[null,null,null,null,null,"BU"]
["Operating Unit:","450",null,"MTISC 450"]
[null,"OU",null,"Description"]
["Department:",null,null,null,null,"NATO CIS O&M Sarajevo"]
[null,"Dept. ID (Inactivate or Change Only)",null,null,null,"Dept. Description (30 Characters)"]
["Department Type:"]
[]
[null,null,null,null,"Dept Tree Manager"]
["If intermediate / PRB: ","NOALL",null,null,null,"GCIS",null,"NATO",null,null,null,"Bosnian Federation Ministry of Defence at"]
["(if no alloc type, enter NOALL)","Allocation type",null,null,null,"OPS Structure 1",null,"OPS Structure 2",null,null,null,"Graditeljstvo, Hamidije Kresevljakovica 96, Sarajevo"]
[]
["Location:","Graditeljstvo"]
[null,"Street Address 1"]
[null,"Hamidije Kresevljakovica 96"]
[null,"Street Address 2",null,null,null,null,null,"County (if applicable)"]
[null,"Sarajevo",null,null,null,null,null,71000]
[null,"City,",null,null,null,"State",null,"Zip Code"]
[null,"Bosnia & Herzegovina"]
[null,"Country"]
[]
["HR Location Table :","Mantech Site",null,"Client Site"]
["(please select one)"]
[null,"M"]
["HR Code:","AAP"]
[]
["Headcount:","Will employees charge labor hours to this Department ID?"]
[]
["Budget Level:","Will department be budgeted?"]
[null,"Attn: Field Offices - If Intermediate or PRB dept type must choose YES"]
[null,"If Corp dept must choose YES"]
[]
["Manager:",null,null,null,null,null,"Stacy Setser"]
[null,"New Dept. ID Manager",null,null,null,null,"HR Rep."]
["Floorcheck POC's:","Kim Gundolfi "]
[null,"POC 1(Point of Contact1) ",null,null,null,null,"POC 2(Point of Contact2)"]
[]
["Justification:"]
["Explain the intended use of the new Dept. ID or a change (i.e. Provide rationale in support of the new Dept. ID or a change)"]
["ManTech Bid for Outsourcing NATO CIS O&M in Bosnia-Herzegovina"]
[]
[]
[]
[]
[]
["Approval:",null,null,null,null,null,"Date:",null,{"$f":"+H4","v":"2010-04-26"}]
[null,"Business Operations Manager"]
["(For Accounting Use Only)"]
["Department:"]
[null,"Dept. ID",null,"Dept. Description (30 Characters)"]
["Approval:",null,null,null,null,null,"Date:"]
[null,"Deputy Controller"]
["Coordination:",null,null,null,null,null,"Date:"]
[null,"Functional Systems Manager"]
["Coordination:",null,null,null,null,null,"Date:"]
[null,"Human Resources"]
["Approval:",null,null,null,null,null,"Date:"]
[null,"Compliance (when needed)"]

{"sheet":"New Dept. ID  - Camp Butmir","index":4,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[18,1,18,2],[48,0,52,8],[0,0,0,8],[1,0,1,8],[3,1,3,5],[3,7,3,8],[5,1,5,5],[17,4,17,8]]}
["ManTech International Corporation"]
["\"Activate DEPARTMENT ID\""]
[]
["TO:","General Ledger",null,null,null,null,"Date:","2010-04-26"]
[]
["FROM:","Lindy Martin"]
[null,"Name of Requestor"]
["SUBJECT:","Activate",null,"Inactivate",null,"Change",null,"(Select One)"]
[]
["Effective Date:","2010-04-26",null,"Business Unit:",null,"MTISC"]
[null,null,null,null,null,"BU"]
["Operating Unit:","450",null,"MTISC 450"]
[null,"OU",null,"Description"]
["Department:",null,null,null,null,"NATO CIS O&M Camp Butmir"]
[null,"Dept. ID (Inactivate or Change Only)",null,null,null,"Dept. Description (30 Characters)"]
["Department Type:"]
[]
[null,null,null,null,"Dept Tree Manager"]
["If intermediate / PRB: ","NOALL",null,null,null,"GCIS",null,"NATO"]
["(if no alloc type, enter NOALL)","Allocation type",null,null,null,"OPS Structure 1",null,"OPS Structure 2"]
[]
["Location:","Kjertl, Butmir"]
[null,"Street Address 1"]
[]
[null,"Street Address 2",null,null,null,null,null,"County (if applicable)"]
[null,"Sarajevo",null,null,null,null,null,77240]
[null,"City,",null,null,null,"State",null,"Zip Code"]
[null,"Bosnia & Herzegovina"]
[null,"Country"]
[]
["HR Location Table :","Mantech Site",null,"Client Site"]
["(please select one)"]
[null,"M"]
["HR Code:","AAP"]
[]
["Headcount:","Will employees charge labor hours to this Department ID?"]
[]
["Budget Level:","Will department be budgeted?"]
[null,"Attn: Field Offices - If Intermediate or PRB dept type must choose YES"]
[null,"If Corp dept must choose YES"]
[]
["Manager:",null,null,null,null,null,"Stacy Setser"]
[null,"New Dept. ID Manager",null,null,null,null,"HR Rep."]
["Floorcheck POC's:","Kim Gundolfi "]
[null,"POC 1(Point of Contact1) ",null,null,null,null,"POC 2(Point of Contact2)"]
[]
["Justification:"]
["Explain the intended use of the new Dept. ID or a change (i.e. Provide rationale in support of the new Dept. ID or a change)"]
["ManTech Bid for Outsourcing NATO CIS O&M in Bosnia-Herzegovina"]
[]
[]
[]
[]
[]
["Approval:",null,null,null,null,null,"Date:",null,{"$f":"+H4","v":"2010-04-26"}]
[null,"Business Operations Manager"]
["(For Accounting Use Only)"]
["Department:"]
[null,"Dept. ID",null,"Dept. Description (30 Characters)"]
["Approval:",null,null,null,null,null,"Date:"]
[null,"Deputy Controller"]
["Coordination:",null,null,null,null,null,"Date:"]
[null,"Functional Systems Manager"]
["Coordination:",null,null,null,null,null,"Date:"]
[null,"Human Resources"]
["Approval:",null,null,null,null,null,"Date:"]
[null,"Compliance (when needed)"]