{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Project Plan"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Project Plan","index":0,"n_rows":136,"n_cols":9,"rows_kept":136,"cut":false,"hidden":false,"merged":[[2,0,2,8],[0,0,0,8],[4,0,4,8],[3,0,3,8],[45,0,45,1],[6,0,6,1],[7,0,7,8],[37,0,37,1],[41,0,41,1],[5,0,5,8],[8,0,8,1],[19,0,19,1],[26,0,26,1],[51,0,51,1],[56,0,56,1],[59,0,59,1],[62,0,62,1],[65,0,65,1],[69,0,69,1],[74,0,74,1],[78,0,78,1],[82,0,82,1],[87,0,87,1],[89,0,89,8],[90,0,90,1],[98,0,98,1],[102,0,102,1],[105,0,105,1],[107,0,107,1],[126,0,126,1],[131,0,131,1],[110,0,110,8],[111,0,111,1],[115,0,115,1],[125,0,125,8]],"flags":["formulas_cached_only"]}
["OMB Control Number: 1660-NEW"]
[{"$nulls":8},"FEMA Form Number: 089-26"]
["Expiration Date: XX/XX/XXXX"]
["Paperwork Burden Disclosure Notice"]
["Public reporting burden for this form is estimated to average 40 hours per response. The burden estimate includes the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and submitting the form. You are not required to respond to this collection of information unless it displays a valid OMB control number.  Send comments regarding the accuracy of the burden estimate and any suggestions for reducing the burden to: Information Collections Management, Department of Homeland Security, Federal Emergency Management Agency, 500 C Street, SW, Washington, DC 20472, Paperwork Reduction Project (1660-NEW) NOTE: Do not send your completed form to this address."]
["Regional Logistics Program Project Plan (EXAMPLE)"]
["Tasks",null,"% Complete","Labor/ Work","Duration","Start Date","End Date","Dependencies","Resources"]
["Logistics Planning"]
["Develop CONOPS and Supporting Manuals",null,null,"307 hours","218 days","2008-09-01","2009-07-01"]
[1,"Collect and review existing plans, agreements, and MOUs, using Synch Matrix (sources should include national, regional, and local documents)",null,"70 hours","45 days","2008-09-01","2008-10-31T17:00:00","N/A"]
[2,"Generate draft of CONOPS to address capability gaps and optimize resource deployment",null,"40 hours","45 days","2008-11-03T08:00:00","2009-01-02T17:00:00",1]
[3,"Generate draft of Supporting Manuals",null,"40 hours","45 days","2008-11-03T08:00:00","2009-01-02T17:00:00",1]
[4,"Review of drafts by regional partners",null,"50 hours","15 days","2009-01-05T08:00:00","2009-01-23T17:00:00","2,3"]
[5,"Incorporate edits from regional partners ",null,"10 hours","7 days","2009-01-26T08:00:00","2009-02-03T17:00:00",4]
[6,"Request independent peer review of document (either by consultants or another jurisdiction)",null,"40 hours","43 days","2009-02-04T08:00:00","2009-04-03T17:00:00",5]
[7,"Incorporate peer review comments and generate final draft of CONOPS",null,"20 hours","32 days","2009-04-06T08:00:00","2009-05-19T17:00:00",6]
[8,"Incorporate peer review comments and generate final draft of Supporting Manuals",null,"20 hours","32 days","2009-04-06T08:00:00","2009-05-19T17:00:00",6]
[9,"Coordinate final drafts through regional partners",null,"15 hours","18 days","2009-05-20T08:00:00","2009-06-12T17:00:00","7,8"]
[10,"Issue final plans/manuals",null,"2 hours","13 days","2009-06-15T08:00:00","2009-07-01T17:00:00",9]
["Establish Support System",null,null,"1048 hours","478 days","2008-10-01","2010-07-30"]
[11,"Site local logistics centers (LLC) in local jurisdictions",null,"240 hours","108 days","2008-10-01T08:00:00","2009-02-27T17:00:00","N/A"]
[12,"Begin to meet with federal, state and local logistics professionals, procurement officers, vendors, and transporters",null,"500 hours","133 days","2009-03-02T08:00:00","2009-09-02T17:00:00","N/A"]
[13,"Plan Regional Logistics Council (RLC) meeting",null,"10 hours","10 days","2009-08-20T08:00:00","2009-09-02T17:00:00","N/A"]
[14,"Convene Regional Logistics Council (RLC) and coordinate planning and capacity building",null,"8 hours","1 day","2009-09-03","2009-09-03",13]
[15,"Begin to establish blanket purchase agreements with vendors throughout the country",null,"240 hours","129 days","2009-09-04T08:00:00","2010-03-03T17:00:00",14]
[16,"Meet with non-profit groups to plan and build event capacity",null,"60 hours","107 days","2010-03-04T08:00:00","2010-07-30T17:00:00",15]
["Determine Staff, Supply, and Equipment Sources",null,null,"430 hours","152 days","2008-10-01","2009-04-30"]
[17,"Establish requirements for staff, supplies and equipment",null,"30 hours","33 days","2008-10-01T08:00:00","2008-11-14T17:00:00","N/A"]
[18,"Assess local, state, and other regional partners for capability to meet requirements and determine needs",null,"120 hours","44 days","2008-11-17T08:00:00","2009-01-15T17:00:00",17]
[19,"Develop a work plan for closing shortfalls (mix of contracts, MOUs, EMAC requests and federal mission assignments)",null,"15 hours","21 days","2009-01-02T08:00:00","2009-01-30T17:00:00","N/A"]
[20,"For contracts and MOUs, assess local, state, and federal (GSA) contracts for applicable vendors",null,"40 hours","20 days","2009-02-02T08:00:00","2009-02-27T17:00:00",19]
[21,"For contracts and MOUs, assess vendors' capability to deliver good or service",null,"30 hours","10 days","2009-03-02T08:00:00","2009-03-13T17:00:00",20]
[22,"For contracts and MOUs, determine and list any items that are required and not on contract",null,"10 hours","10 days","2009-02-02T08:00:00","2009-02-13T17:00:00","N/A"]
[23,"Determine if items required and not on contract are stockpile requirements or if there is an acceptable level of risk to allow \"just in time\" delivery",null,"20 hours","20 days","2009-02-16T08:00:00","2009-03-13T17:00:00",22]
[24,"For contracts and MOUs, draft specifications and scopes of work for each good or service",null,"40 hours","20 days","2009-02-02T08:00:00","2009-02-27T17:00:00","N/A"]
[25,"Release specifications and scopes of work for bidding purposes",null,"5 hours","10 days","2009-03-02T08:00:00","2009-03-13T17:00:00",24]
[26,"Develop plan to address post-disaster donations management",null,"120 hours","34 days","2009-03-16T08:00:00","2009-04-30T17:00:00","N/A"]
["Solicit Feedback from all Regional Stakeholders",null,null,"600 hours","195 days","2008-09-01","2009-05-29"]
[27,"Solicit comments from regional stakeholders on all plan components",null,"120 hours","65 days","2008-09-01T08:00:00","2008-11-28T17:00:00","N/A"]
[28,"Coordinate interim drafts of manuals with regions",null,"80 hours","45 days","2008-12-01T08:00:00","2009-01-30T17:00:00",27]
[29,"Beta test site assessment materials with each regional stakeholder",null,"400 hours","85 days","2009-02-02T08:00:00","2009-05-29T17:00:00",28]
["Pre-Script Mission Assignments for State, EMAC, and Federal Assets",null,null,"340 hours","196 days","2008-09-01","2009-06-01"]
[30,"Identify external pre-packaged assets",null,"180 hours","65 days","2008-09-01T08:00:00","2008-11-28T17:00:00","N/A"]
[31,"Map how, where and when external support assets support overall response",null,"60 hours","65 days","2008-12-01T08:00:00","2009-02-27T17:00:00",30]
[32,"For EMAC and federal mission assignments, pre-script and pre-coordinate the requests with NEMA and FEMA",null,"100 hours","66 days","2009-03-02T08:00:00","2009-06-01T17:00:00",31]
["Establish Commodity Distribution Sites",null,null,"615 hours","174 days","2009-01-01","2009-09-01"]
[33,"Determine operational model (type, location, layout)",null,"300 hours","65 days","2009-01-01T08:00:00","2009-04-01T17:00:00","N/A"]
[34,"Identify and map large open areas (1-2 acres)",null,"180 hours","44 days","2009-04-02T08:00:00","2009-06-02T17:00:00","N/A"]
[35,"Assess locations for usability (site visits)",null,"15 hours","22 days","2009-05-04T08:00:00","2009-06-02T17:00:00","N/A"]
[36,"Develop site-specific layout for each location",null,"60 hours","31 days","2009-06-03T08:00:00","2009-07-15T17:00:00",35]
[37,"Develop prepared public information messages about distribution centers",null,"60 hours","21 days","2009-08-04T08:00:00","2009-09-01T17:00:00",36]
["Establish Staging Areas",null,null,"555 hours","174 days","2009-01-01","2009-09-01"]
[38,"Identify and map large open areas (5+ acres)",null,"180 hours","42 days","2009-01-01T08:00:00","2009-02-27T17:00:00","N/A"]
[39,"Assess locations for usability (site visits)",null,"15 hours","20 days","2009-02-02T08:00:00","2009-02-27T17:00:00","N/A"]
[40,"Develop site-specific layout for each location",null,"60 hours","33 days","2009-03-02T08:00:00","2009-04-15T17:00:00",39]
[41,"Work with FEMA/States to operationalize staging areas",null,"300 hours","99 days","2009-04-16T08:00:00","2009-09-01T17:00:00",40]
["Identify Fleet Assets (Local, State, Federal)",null,null,"270 hours","88 days","2008-10-01","2009-01-30"]
[42,"Coordinate with local, state, federal agency fleet managers to include their assets in the supply chain, as appropriate",null,"250 hours","88 days","2008-10-01T08:00:00","2009-01-30T17:00:00","N/A"]
[43,"Create central tracker to maintain data and agency managers' contact information",null,"20 hours","88 days","2008-10-01T08:00:00","2009-01-30T17:00:00","N/A"]
["Develop Delivery Routes",null,null,"100 hours","129 days","2009-09-02","2010-03-01"]
[44,"Establish delivery routes from staging areas to commodity distribution areas",null,"80 hours","87 days","2009-09-02T08:00:00","2009-12-31T17:00:00","37,41"]
[45,"Prioritize debris removal operations to align with priority supply routes",null,"20 hours","41 days","2010-01-04T08:00:00","2010-03-01T17:00:00",44]
["Establish Strategic Communications Plan and Backup Plan to Link all Logistics Elements",null,null,"380 hours","174 days","2009-02-02","2009-10-01"]
[46,"Identify all major decision points for purchasing, requesting and mobilizing assets (e.g. local/state/federal disaster declarations, hazards projected to hinder logistics support operations, etc.)",null,"300 hours","174 days","2009-02-02T08:00:00","2009-10-01T17:00:00","N/A"]
[47,"Track decision points through a process map or flow chart",null,"80 hours","174 days","2009-02-02T08:00:00","2009-10-01T17:00:00","N/A"]
["Develop Master Time-Phased Force Deployment List",null,null,"185 hours","132 days","2009-06-01","2009-12-01"]
[48,"Identify all major decision points for purchasing, requesting and mobilizing assets (e.g. local/state/federal disaster declarations, hazards projected to hinder logistics support operations, etc.)",null,"20 hours","45 days","2009-06-01T08:00:00","2009-07-31T17:00:00","N/A"]
[49,"Set timeline goals for mobilizing support assets",null,"15 hours","23 days","2009-08-03T08:00:00","2009-09-02T17:00:00",48]
[50,"Develop a time-phased matrix based on decision points, timing goals and expected asset availability over time",null,"150 hours","64 days","2009-09-03T08:00:00","2009-12-01T17:00:00",49]
["Plan Security for all Logistics Elements",null,null,"480 hours","110 days","2009-04-01","2009-09-01"]
[51,"Develop plan to address post-disaster regional credentialing",null,"300 hours","43 days","2009-04-01T08:00:00","2009-05-29T17:00:00","N/A"]
[52,"Test the plan, as developed, through RCPGP activities via a HSEEP compliant drill or exercise",null,"100 hours","11 days","2009-06-01T08:00:00","2009-06-15T17:00:00",51]
[53,"Determine availability of local, state, and federal assets",null,"40 hours","34 days","2009-06-16T08:00:00","2009-07-31T17:00:00",52]
[54,"Pre-determine EMAC and Federal requests for security assistance (pre-locate teams)",null,"40 hours","22 days","2009-08-03T08:00:00","2009-09-01T17:00:00",53]
["Examine Impact of Hazards to Regional Food Suppliers",null,null,"215 hours","108 days","2009-02-02","2009-07-01"]
[55,"Complete risk assessment (hazard impact to food commerce)",null,"120 hours","43 days","2009-02-02T08:00:00","2009-04-01T17:00:00","N/A"]
[56,"Meet with key representatives from the retail food industry",null,"15 hours","32 days","2009-04-02T08:00:00","2009-05-15T17:00:00",55]
[57,"Develop framework for regional food supply recovery plan",null,"80 hours","33 days","2009-05-18T08:00:00","2009-07-01T17:00:00",56]
["Demobilization",null,null,"190 hours","66 days","2009-04-01","2009-07-01"]
[58,"Develop plan for facility consolidation as event de-escalates",null,"80 hours","33 days","2009-04-01T08:00:00","2009-05-15T17:00:00","N/A"]
[59,"Develop process for coordinating redistribution of excess supplies",null,"80 hours","32 days","2009-05-01T08:00:00","2009-06-15T17:00:00","N/A"]
[60,"Coordinate deactivation of staff",null,"30 hours","23 days","2009-06-01T08:00:00","2009-07-01T17:00:00","N/A"]
["Rollout Meetings with Regional Stakeholder",null,null,"124 hours","66 days","2009-09-01","2009-12-01"]
[61,"Develop project plan for rolling out plan templates to stakeholders",null,"90 hours","22 days","2009-09-01T08:00:00","2009-09-30T17:00:00","N/A"]
[62,"Assign planners as \"consultants\" to groups of stakeholders",null,"6 hours","8 days","2009-09-21T08:00:00","2009-09-30T17:00:00","N/A"]
[63,"Conduct rollout planning meetings with stakeholders",null,"8 hours","10 days","2009-10-01T08:00:00","2009-10-14T17:00:00",62]
[64,"Meetings and support to stakeholders as they roll out the program",null,"20 hours","34 days","2009-10-15T08:00:00","2009-12-01T17:00:00",63]
["Developing HSEEP Plan",null,null,"400 hours","217 days","2009-05-01","2010-03-01"]
[65,"Following development of each plan or manual, it will be tested using one or more Homeland Security Exercise and Evaluation Program (HSEEP) compliant exercise method, ranging from decision-making tabletops to functional exercises",null,"400 hours","217 days","2009-05-01T08:00:00","2010-03-01T17:00:00","N/A"]
["Establish ALERT Teams"]
["Develop Training Curricula",null,null,"300 hours","88 days","2008-07-31","2008-12-01"]
[66,"Contract with vendor to develop classroom-based training program",null,"20 hours","22 days","2008-07-31T08:00:00","2008-08-29T17:00:00","N/A"]
[67,"Develop curriculum",null,"80 hours","32 days","2008-09-02T08:00:00","2008-10-15T17:00:00",66]
[68,"Determine field training requirements",null,"40 hours","32 days","2008-09-02T08:00:00","2008-10-15T17:00:00","N/A"]
[69,"Establish activation and notification protocols for staff",null,"40 hours","32 days","2008-09-02T08:00:00","2008-10-15T17:00:00","N/A"]
[70,"Meet with jurisdictions to solicit feedback on training curriculum",null,"60 hours","12 days","2008-10-16T08:00:00","2008-10-31T17:00:00","67-69"]
[71,"Incorporate comments from regional jurisdictions into training program",null,"20 hours","10 days","2008-11-03T08:00:00","2008-11-14T17:00:00",70]
[72,"Pilot training curriculum",null,"40 hours","11 days","2008-11-17T08:00:00","2008-12-01T17:00:00",71]
["Recruit Team",null,null,"480 hours","197 days","2008-07-31","2009-05-01"]
[73,"Identify team leadership",null,"80 hours","67 days","2008-07-31T08:00:00","2008-10-31T17:00:00","N/A"]
[74,"Recruit team members from UASI jurisdictions",null,"320 hours","107 days","2008-11-03T08:00:00","2009-03-31T17:00:00",73]
[75,"Conduct staff training",null,"80 hours","23 days","2009-04-01T08:00:00","2009-05-01T17:00:00",74]
["Train Team",null,null,"3000  hours","412 days","2009-01-01","2010-07-30"]
[76,"Schedule training for teams throughout the site",null,"200 hours","108 days","2009-01-01T08:00:00","2009-06-01T17:00:00","N/A"]
[77,"Complete training according to schedule",null,"2800 hours","412 days","2009-01-01T08:00:00","2010-07-30T17:00:00","N/A"]
["Develop Notification and Deployment Protocol",null,null,"150 hours","131 days","2009-05-01","2009-10-30"]
[78,"Establish activation protocol",null,"150 hours","131 days","2009-05-01T08:00:00","2009-10-30T17:00:00","N/A"]
["Procure Equipment and Supplies",null,null,"310 hours","261 days","2009-05-01","2010-04-30"]
[79,"Identify standard clothing and supply package for a team member",null,"60 hours","44 days","2009-05-01T08:00:00","2009-07-01T17:00:00","N/A"]
[80,"Procure and distribute equipment",null,"250 hours","217 days","2009-07-02T08:00:00","2010-04-30T17:00:00",79]
["Technology Support"]
["Incorporate Data into CALMS (or like database)",null,null,"750 hours","348 days","2008-10-01","2010-01-29"]
[81,"Organize data for CALMS program upload",null,"250 hours","131 days","2008-10-01T08:00:00","2009-04-01T17:00:00","N/A"]
[82,"Prepare data for upload and to de-conflict potential issues",null,"250 hours","132 days","2009-04-02T08:00:00","2009-10-02T17:00:00",81]
[83,"Upload data into system",null,"250 hours","85 days","2009-10-05T08:00:00","2010-01-29T17:00:00",82]
["Develop Software Program to Link Mission Requests across all Jurisdictions",null,null,"1150 hours","347 days","2009-02-02","2010-06-01"]
[84,"Conduct analysis of existing federal, state, and local systems",null,"120 hours","43 days","2009-02-02T08:00:00","2009-04-01T17:00:00","N/A"]
[85,"Develop programming language that can convert local and state mission requests from existing formatting into a system accessible by federal officials and vendors",null,"240 hours","22 days","2009-04-02T08:00:00","2009-05-01T17:00:00",84]
[86,"Review COTS solutions for resource tracking",null,"30 hours","23 days","2009-05-04T08:00:00","2009-06-03T17:00:00","N/A"]
[87,"Develop work plan for procuring these solutions and determine how they will support existing plans",null,"60 hours","42 days","2009-06-04T08:00:00","2009-07-31T17:00:00",86]
[88,"Identify funding streams to support procurement and sustainment",null,"40 hours","43 days","2009-08-03T08:00:00","2009-09-30T17:00:00",87]
[89,"Beta test systems",null,"480 hours","87 days","2009-10-01T08:00:00","2010-01-29T17:00:00",88]
[90,"Develop a project plan for rolling out the system to the jurisdictions",null,"30 hours","21 days","2010-02-01T08:00:00","2010-03-01T17:00:00",89]
[91,"Roll out the system to the jurisdictions",null,"30 hours","22 days","2010-03-02T08:00:00","2010-03-31T17:00:00",90]
[92,"Conduct analysis of existing federal, state, and local systems",null,"120 hours","44 days","2010-04-01T08:00:00","2010-06-01T17:00:00",91]
["Information Sharing"]
["Establish Website",null,null,"750 hours","108 days","2009-02-02","2009-07-01"]
[93,"Determine layout of website",null,"180 hours","20 days","2009-02-02T08:00:00","2009-02-27T17:00:00","N/A"]
[94,"Develop content areas",null,"480 hours","45 days","2009-03-02T08:00:00","2009-05-01T17:00:00",93]
[95,"Initiate and promote website via strategic communications",null,"60 hours","22 days","2009-05-04T08:00:00","2009-06-02T17:00:00",94]
[96,"Manage and update website",null,"30 hours","43 days","2009-05-04T08:00:00","2009-07-01T17:00:00","N/A"]
["Emergency Logistics Conference",null,null,"540 hours","65 days each year","2/2/2009 and 2/1/2010","5/1/2009 and 4/30/2010"]
[97,"Plan and organize annual logistics conference",null,"300 hours","52 days","2/2/2009 and 2/1/2010","4/14/2009 and 4/14/2010","N/A"]
[98,"Hold logistics conference",null,"240* hours","13 days","4/15/2009 and 4/15/2010","5/1/2009 and 4/30/2010",97]
[]
[null,"*Could fluctuate dramatically depending upon the number of attendees    "]