Attachment 0043 - TE F2 Report Format.xlsx

Tech Exhibit F2

2. Unless otherwise designated in the "Method and Distribution" column, the contractor will submit all reports to the following email address: usarmy.RIA.asc.mbx.logcap-pco@mail.mil

3. 'The contractor shall generate for, and submit to, the USG AIS generated reports in accordance with regulatory/policy guidance, and as requested by requiring activities.

- AAF/AHP Pre-Accident Plan

- Wildlife Hazard Management Plan

- Flight-line Driving Training Program

- Staffing & Management Plan

- Inspection Program

- Building manager/evacuation coordinator training

- Fire Prevention Inspection Program

- Master Schedule Of Work (MSOW)

- Scheduled Maintenance Plan

- O&M Service/Work Order Report (GFEBS data pull) X

M-01 Contractor Manpower Reporting X Automated Report

P-01 Performance Management Review (PMR):

Topics:

1. Set the Theater - ROM estimates and technical execution plans (Q1-4); Concepts of Support and Country/Region Books (Q2 &Q4)

2. Contractor Self-Assessment on: Setting the Theater, Performance, Cost Control, Measures to improve effectiveness and efficiencies, Status of Change Orders/Definitization.

3. Government Assessment based on CPARs criteria PWS Deliverables review

4. Change Orders

5. Integrated Master Schedule (IMS)

6. Contract Property Closeout, Replacement and/or Capital Rehabilitation Requirements

7. Quarterly Impact Study (QIS)

8. Sub-Contract Management Performance against Plan

9. GFP: Property Mgt, including Rehabilitation, FOI, LDD

10. Summary of contractor employee misconduct and actions taken

11. Safety initiatives and accident statistics with and actions taken

12. If necessary discuss areas of sub-optimal performance (i.e. NCRs, delays)

1. Discrepancy Report;

- Property Lost, Damaged, or Destroyed (LDD)

- Property Other Than LDD

2. Technical Inspection Results

1. Personnel

- Contractor Population

- Supported Population

2. Services (PWS Section IV Data not available in AIS):

- Facility Density

- Services Workload

- Camp Operations and facility maintenance Workload

3. Supply (PWS Section V Data not available in AIS):

- Supply Status and critical Shortfalls

4. Maintenance (PWS Section VI Data not available in AIS):

- Power Generation Status

- Material Handling Equipment (MHE) Status

- Material Condition Status Report

5. Transportation (PWS Section VII Data not available in AIS):

- NTV, Service Vehicle, MHE and Critical Ground Support Equipment Fleet Summary

- Facility Traffic Count

- Modal Movements

Attachment 11

S-01 Sub-Contract Management Plan X

Microsoft_Word_Document4.docx P-08 - Operations Security (OPSEC) Plan

The OPSEC process involves five steps: (1) identification of critical information, (2) analysis of threats, (3) analysis of vulnerabilities, (4) assessment of risk, and (5) application of appropriate countermeasures. The plan must address each process, how OPSEC will be integrated into sub-contracts at all tiers, and how OPSEC will be localized at the operational and tactical levels.

Use an analytic, systematic process to identify and control mission critical information.

Assess and analyze vulnerabilities in your systems; communication, electronic, human, information, and operations.

Identify access control, document control and disposal, procedures for public release, all modes of communication, and information sharing protocols. Assess risk and determine impact, particularly operational risk to your customer.

Identify countermeasures and mitigation strategies.

You are encouraged to also identify those voluntary (non-DoD developed for the well-being of the company) OPSEC priorities so Government can assist and educate to secure proprietary information and technology, disclosure of marketing plans, and legal liability.

The overarching OPSEC Plan is required within 60 days of award. Localized subordinate plans for each operations (operational level) and operating location (tactical level) are developed and updated as required to identify critical elements, analysis of localized threats, vulnerabilities, risk, and countermeasures. There is not a specified time for completion of localized plans, other than as addressed in the overarching plan.

Microsoft_Word_Document5.docx P-09 Safety and Health Plan

As a minimum, the overarching plan must address awareness, training, reporting, risk analysis and hazard identification, mitigation strategies and compliance assurance. Plans are localized at the operational and tactical levels (down to actual shops when warranted), and describe the integration of safety and health objectives to sub-contracts at all tiers. Include communication strategies that permit effective partnerships with Government for mutual assurance of safety and health objectives.

Microsoft_Word_Document6.docx P-10 - Quality Control Plan (QCP)

The overarching plan identifies the system (set of interrelated or interacting elements) in services and establishes the policy and objectives to achieve those objectives. The plan must establish how the organization will manage quality to assure quality objectives. Address audit processes, risk management, strategies to correct deficiencies. High risk services identified in technical exhibit F will be separately addressed in the quality plan. The plan will describe how the integration and assurance objectives of quality into sub-contracts will be achieved. Quality plans will be localized and updated at the operational and tactical levels as required to achieve objectives and assure that operational effects, intent, and viability are not adversely impacted by quality defects.

Microsoft_Word_Document7.docx P-11 - Emergency Response Plan

The overarching emergency response plan describes the process or processes that will be used at the tactical level to integrate contractor emergency response plans into the theater, operation, and tactical (camp) level emergency response plans and actions.

The overarching plan must identify general concepts for permissive environments, troubled or semi-permissive environments, and non-permissive environments to frame and shape development of risk and threat identification and employee actions in response to those threats and risks at the execution level. General concepts for emergency reporting and employee actions must be incorporated to provide guidance to employees on developing, integrating, and validating localized emergency action plans.

Copies of localized plans will be provided as specified in Technical Exhibit F, reviewed at least annually, and updated as required by changing risks, threats, or the operational environment.

Microsoft_Word_Document8.docx P-12 -Trades Certificate and Validation Plan

Trades Certificate and Validation plan must incorporate the business approach for ensuring positions that require certificates or other competency validations are properly staffed and managed to ensure currency. The plan must provide for Government access and visibility of trades certification, how lapses or risks to currency will be managed to ensure only certified personnel are performing tasks requiring certifications.

Microsoft_Word_Document9.docx L-04 Energy Conservation Plan

The overarching energy conservation plan must demonstrate an understanding of the risks and benefits of energy conservation on operational effects. When energy conservation and operational energy efforts and initiatives are implemented, a GANTT chart displaying savings will be incorporated or attached to the daily SITREP representing baseline, projected, and actual savings in cost ($) and consumption (fuel, water).

Microsoft_Word_Document10.docx P-06 Government Furnished Equipment and Facilities Report

The contractor report must clearly identify discrepancies, levels of effort and the results of technical inspections. The contractor must identify any operational, cost, schedule, or performance impacts that result or may result, mitigation strategies, corrective actions, and any other information that will provide a clear picture of conditions, circumstances, and strategies to obtain best value solutions.

image4.emf

Microsoft_Word_Document11.docx P-15 Master Project Schedule Tracker

The contractor shall provide a Master Project Schedule Tracker that identifies all active planned, initiated and active engineering projects.

The contractor shall identify cost (planned, actual, projected, % expended), time/schedule (planned, actual, projected, % expended), and available capacity (if IOC) (planned capacity, available capacity).

The report shall identify the project name/number, priority/criticality (low, medium, high) based on customer priorities of effort, and provide a brief narrative explaining reasons for schedule or budget deviations. The report covers operational level when required for operational level requirements, and tactical (camp) level detail.

The report shall be organized to promote clarity of information and facilitate Government understanding of critical path information. Problem areas must be easily identifiable, and accompanying text must clearly state the precipitating problem(s), solutions, assistance requested, and impact on intended operational effects if known.

image5.emf

Microsoft_Word_Document12.docx P-16 Rough Order of Magnitude (ROM) in Support of Alpha Contracting

Rough Order of Magnitude project estimates in response to change management actions must provide sufficient detail to provide a baseline for further refinement of requirements concurrent with negotiation. As a minimum, the P-16 must contain a cost summary, a resource summary, a rates table (and sub-contractor rates table), separately tabbed CBOE broken into (labor, materiel, equipment, and other direct costs), mobilization and demobilization costs, fee rates, transportation and freight rates and other direct and indirect categories that together provide a complete accounting of costs. Provide all assumptions, broken out by WBS. Include a proposed schedule. Account for current resident capability (on the ground labor, materiel, and equipment) that will be leveraged to satisfy the requirement, and clearly identify additional labor hires, equipment leases, and other projected growth in the logistics footprint. Clearly identify which costs are sunk costs (retrospective) or changed costs (prospective that change the baseline).

Microsoft_Word_Document13.docx Certified Inventory of Evidence Report (Lost/Found Security Items, Laundry Service)

L-01

DATE of Discovered Loss/Damage:

Report #: (Last 4 numbers of contract/Task Order number/Site Code/dd/mm/yyyy/XXXX)

Location: (GCC/Task Order/Site Code/Camp Name/Laundry Facility)

Brief Description of loss/damage and actions taken:

Items Lost:

Value:

Owner Name:

Results of Investigation and Corrective Action Taken:

Attachments:

· DA Form 2886

· DA Form 3078 or written description (signed/validated by laundry manager) if property cannot be reissued or is not otherwise available in on-hand stock.

· Claim settlement documentation (may be a follow-up document)

· Memorandum for claims office (for Non-Military personal clothing/equipment)

· Claim settlement documentation (may be a follow-up document) image6.emf

Microsoft_Word_Document14.docx Airfield Safety Reports

L-02

Date:

Location:

Name of Senior Airfield Authority:

Incidents/Accidents

Date/type of incident

Description of event:

Operational impact:

Note: SAA has responsibility for the safe operation of the airfield. Contractor plans acknowledge the SAA intent (normally contained within an airfield Standard Operating Procedure) and provide detailed planning for execution. Plans are updated when the SOP is updated.

(Update as required)AAF/AHP pre-accident plan report shall contain:

· Contact information for key personnel

· Drills conducted

· Identify types of incidents accounted for in the plan (i.e., fire, fuel spill, employee accidents, damage to equipment, damage or work stoppage due to weather, security incursions, aircraft accidents, etc.).

· Date of plan:

Wildlife hazard management plan report:

· Date of plan

· Risk Assessment

· Risk mitigation

· Identified Hazards

Wildlife incidents:Date/type of incident

Description of event:

Operational impact:

Number of wildlife incidents to date:

Flight-line Driving Training Program

· Total number of employees certified:

· Number of personnel certified this month:

Foreign Object Damage (FOD) Prevention Program

· Number of sweeper vehicles

· Average daily sweeps with vehicle

· FOD walks per week

FOD recovered:

Date/type of foreign object

How found:

FOD Incident:

Date/type of incident:

Damage description:

Corrective action to prevention program:

Microsoft_Word_Document15.docx P-02 Country/Region Data Files

Analysis of the Operational Environment (aOE)

This document assembles information to assist in development of the analysis of the Operational Environment from an executing contractor perspective.

Market Survey Information.

1) General market information on commonly purchased commodities and services

2) Major contracts in place

3) Contracting efforts currently supporting in operational or in-transit areas

4) Vendor lists (vendors with and without current relationships with LOGCAP), by commodity or service sector.

Business Environment Information.

1) General business capability

2) Banking structure to include electronic commerce capabilities

3) Currency (shadow economy, secondary currency)

4) Corruption index to include customary business practices (e.g. bribes, baksheesh, etc.)

5) Local laws and regulations impact and barriers to the conduct of business

6) Business law enforcement

7) Language and cultural challenges

8) Theater Logistics Analysis (TLA) (the LOGCAP TLA is the contractor’s assessment of LOGCAP execution enablers, constraints, risks, and capabilities).

9) Theater Posture Plan (TPP) (NOTE: the contractor does NOT develop the TPP, but provides enabling information to describe LOGCAP can support the employment of the force).

ATCH (flat-file data reports)

P-02a General Information

P-02b Seaport Detail

P-02c Airfield Detail

P-02d Road and Rail Networks

P-02e Vendor List

P-02f Supply Chain

P-02g Contract List image1.emf

Setting The Theater General P-02a_g.xlsx

P-02a General Information

P-02a Setting the Theater - General Requirements

Date Location Information DoS Differentials and Per Diems Agreements and Treaties Country Entry Requirements for Contractors Labor Laws KTR Current Operations Medical Transportation - Seaports (also see RR001A) Ground Transportation

(y/n) Tax on KTR LOGCAP Operations Other Commercial Fees Availability of Western or International Standard Medical Care Major Disease Risks and Required Immunizations Medical Risk Rating VR - Rapidly developing variable risk L - Low medical risk M - Medium medical risk H - High medical risk VH - Very high medical risk

Nearest Available Seaports (Port Name, LPR Code, Geoloc code, types of Cargo supported, Port Authority) Travel Risk within Country Port Towage Availability (y/n) Total Port Container Facilities (#)

Instructions: The report is generated or updated when changes occur. Place the date of the change in the appropriate block and enter the change update(s) in red in the appropriate block(s). Ensure you follow the indicated formats consistently.

Codes and Definitions: Medical Risk (VR) - Rapidly developing variable risk countries - Countries where there is a wide difference between the high quality medical care available in the major cities and what is generally available throughout the rest of the country.

• In major cities: a high or international standard of medical care is available from several selected providers.

• Elsewhere: medical care, emergency services and dental care may be basic. Access to prescription drugs may be limited and counterfeiting and/or improper storage may be an issue. Serious illnesses such as dengue, malaria, typhoid, and cholera may pose a threat in some regions or throughout the country.

(L) - Low medical risk countries - International standard of care throughout the country. Most specialist care widely available. High-quality emergency and dental services and a wide range of quality prescription drugs available. Low risk of infectious diseases.

(M) - Medium medical risk countries - High or international standard of care available from selected providers. Reliable emergency services and dental care usually available. Some risk of food or water-borne diseases. Infectious diseases such as malaria and dengue fever may be present.

(H) - High medical risk countries - Basic emergency services and dental care may be available. Specialist care is limited. Access to quality prescription drugs may be limited and, in some cases, counterfeiting and/or improper storage of drugs is an issue. Serious infectious diseases such as typhoid, cholera, dengue fever and malaria may pose a threat.

(VH) - Very high medical risk countries - Countries where healthcare is almost non-existent or severely overtaxed. There may be very limited or no primary care, emergency care or dental services. Quality prescription drugs are usually not available. There is a high risk for food or water-borne infections. Serious infectious diseases such as dengue, malaria, typhoid, and cholera may pose a threat.

Codes and Definitions: In Country Travel Risk

(I) - Insignificant travel risk - Rates of violent crime are very low. There is no significant political violence or civil unrest and no sectarian, communal, racial or targeted violence against foreigners. Security and emergency services are effective and infrastructure is sound. Transport services are of a high standard with good safety records and only occasional travel disruption. Industrial action affecting essential services is rare.

(L) - Low travel risk - Violent crime rates are low and racial, sectarian or political violence or civil unrest is uncommon. If terrorism is a threat, groups have limited operational capabilities, and acts of terrorism are rare. Security and emergency services are adequate and infrastructure is sound. Industrial action and transport disruption are infrequent.

(M) - Medium travel risk - Periodic political unrest, violent protests, insurgency and/or sporadic acts of terrorism occur. Travellers and expatriates may face risk from communal, sectarian or racial violence and violent crime. Capacity of security and emergency services and infrastructure varies. Industrial action can disrupt travel.

(H) - High travel risk - Protests are frequently violent and may target or disrupt foreigners; they may be exacerbated by governance issues, including security or law and order capacity. Violent crime or terrorism pose significant direct or incidental risks to travellers and expatriates. Communal, sectarian or racial violence is common and foreigners may be directly targeted. Certain parts of the country are inaccessible or off-limits to the traveller.

(VH) - Very High travel risk - Government control and law and order may be minimal or non-existent across large areas. Serious threat of violent attacks by armed groups targeting travellers and expatriates. Government and transport services are barely functional. Large parts of the country are inaccessible to foreigners.

P-02b Seaport Detail

P-02b Seaport Details

Country Port Name Geoloc Code Lat/Long Port Authority Anchorage (number/class) Controlling Depth Port Towage Availability (y/n) Total Port Container Facilities (#) Total Port RO/RO Facilities (#) Ship Repair Facilities (Major, Minor, None) Bunker Availability Covered Storage Space (sq ft) Open Storage Space (acres) Refrigerated Storage Space (cu ft) Anchorage (Number/Class) Traffic (tons cargo in/out per year) in tons or Bbls Throughput Rate (Avg per normal work day (daily rate)) Bulk POL Storage Space (barrels) Materiel Handling Equipment (Number/type/capacity/ restrictions)

Anchorage Classes Berth Class in ft - length/draft MHE Codes MHE Codes

Class I - Min. 800yd diameter, 38 ft depth Class A 500/30 Code Type Code Type

Class II- Min. 500yd diameter, 30 ft depth Class B 460/24-28 1 Bridge container crane 27 Coal unloader tower

Class III - Min. 300 yd diameter, 20 ft. depth Class C 350/17-21 2 Bridge crane 28 Container handler

RO/RO and Container Facility types Class D 250/16 3 Container crane (AKA Portainer or traveling) 29 Container transporter

0 None Class F 100/6-11 4 Crawler crane (AKA Caterpiller crane) 30 Conveyor system

2 crane 6 Gantry crane (or hoist) 32 Front-end loader

3 ground storage T-A 600/33 7 Hydraulic crane 33 Grain hopper

4 rail truck T-B 525/30 8 Lift crane 34 Hose handling tower

5 RoRo platform T-C 450/25 9 Locomotive (rail) crane 35 Loading/unloading arm

6 shed T-D 250/13 10 Mobile crane (AKA portable, truck, wagon, or mobile) 36 Lumber straddle carrier

7 warehouse T-E 175/8 11 Pedestal crane (AKA revolving or rotating) 37 Marine legs

Terminal Type Type of Vessel Served 12 Floating derrick 38 Mobile stacker

1 All cargo 1 Tanker 13 Hose handling derrick/crane 39 Ore unloader

2 Container 2 Container 14 Mast and boom derrick 40 Shovel truck

3 POL 3 General cargo 15 Sheer leg derrick 41 Tractor

4 General cargo 4 OBO (Ore, Bulk, Oil) 16 Stiff leg derrick 42 Traveling coal loader

5 Ammunition 5 LASH or SEABEE 17 Bale clamp lift 43 Traveling loading tower

6 Ro/Ro cargo 6 Ro/Ro 18 Container lift truck 44 Vacuum pump

7 Military 7 Passenger 19 Fork lift 45 Winch

8 Dry bulk 8 Dry bulk 20 Lift truck 46 Straight line crane

9 Liquid bulk 9 Liquified gas/propane 21 Pallet lift 47 A frame derrick

Cargo Type 10 Refrigerated 22 Paper roll clamp lift 48 Pipeline

1 General cargo 11 Barges 23 Top lift truck 49 Hose

2 Passenger 12 Other (specify) 24 Barge unloader 50 Vacuum clamp truck

3 POL 25 Boom (Cargo mast) 51 Coal loading tower

4 Grain 26 Bridge tower 52 Trailer

5 Refrigerated

6 Natural resources

7 Other (specify)

P-02c Airfield Details

P-02c Operationally Significant Airfields, Details

Location and Identification Aircraft Supported Runway Capabilities and Restrictions

Date of Last Change GCC Country Airfield Name LAT/LONG Elevation Operational Control Tower Facility? Y/N Distance (miles) and one way travel time to nearest available airfield Maximum on Ground (MOG) by type Largest Class Aircraft Safely Usable Cargo and PAX Length in ft. Width in ft. Surface Type Load Classification Number (LCN) Aircraft Classification Number (CAN) Pavement Classification Number (PCN) Pavement Condition Index Cargo Restrictions, Type Cargo Restrictions, Weight Other restrictions

P-02d RoadRail Networks

P-02d Road and Rail Networks

Date of last update GCC Country Total rail in miles, by gauge Predominant track gauge in commercial transportation Bordering Countries connected by rail Rail Capacity/Availability/frequency Competition for Rail Modal availability and access to rail End to end intermodal

Ground Transportation Network

P-02eVendor List

P-02e Vendor List

Source of Services or Both Source of what classes of supply? Service Sectors Countries authorized or licensed to work in General Responsiveness (velocity) Intended Use

Service Sectors

GL = General Labor

Eng(M) = Minor Engineering

Eng(G) = General Engineering

AirS = Air Services

Waste(S) = Solid waste disposal

Auto(L) Automotive lease

Professional = Describe

Security = Describe

Other = Describe

P-02f Supply Chain

P-02f Setting the Theater Supply Chain

Plan Supply Chain Check and date when complete or updated Plan Source Check and date when complete or updated Plan Make Check and date when complete or updated Primary Source Determination (FSS or Commercial) Check and date when complete or updated

Identify, Prioritize, and Aggregate Supply Chain Requirements Identify, Prioritize, and Aggregate Product Requirements Identify, Prioritize, and Aggregate Production Requirements Evaluate comparative risk for cost

Identify, Assess, & Aggregate Supply Chain Resources Identify, Assess, % Aggregate Product Resources Identify, Assess, % Aggregate Production Resources Evaluate comparative risk to schedule

Balance resources with requirements Balance Resources and Requirements Balance Resources and Requirements Evaluate comparative risk to performance

Establish and communicate Supply Chain Plans Establish Sourcing Plans Establish Production Plans Evaluate comparative risk to supportability*

Evaluate overall risk

Enable Plan Check and date when complete or updated

Manage Business Rules for Plan Processes Supportability includes interoperability, maintainability and provisioning, open architecture, and lease vs. buy considerations

Manage performance of Supply Chain

Manage Plan Data Collection

Manage Integrated Supply Chain Transportation

Manage Planning Configuration

Manage Plan Regulatory Requirements & Compliance

Diagrammed Level 1 SCOR model Consider:

Insert KTR Level 1 SCOR model here for areas within the GCC that do not currently have a LOGCAP presence Consider both FSS and Commercial Sources Schedule Requirements

Identified sources of supply

Transportation challenges and enablers

Requirements instablility (rapidly changing)

Time required to implement

Potential inflationary pressures of LOGCAP or US presence

Capacity and reliability of source

Plan

P-02g Contact List

P-02g Contact List

Name Area of Responsibility (strategic, operational, or tactical) Physical Location (city/camp, nation) NIPR email address SIPR email address (if available) Landline Phone # Mobile Phone # Title Area of Responsibility CCAS POC (ACO)

Primary

Secondary

Primary

Secondary

Primary

Secondary

Primary

Secondary

Strategic Strategic refers to those personnel whose responsibility encompasses corporate level, contract level, or task order level

Operational Operational refers to those personnel whose responsibility is at a named operation level, or responsible for an operational level service such as transportation

Tactical Tactical refers to those personnel whose responsibility is at a camp or point of service level

Areas of Responsibility

Code Responsibility

S - Supply

T - Transportation

M - Management

L - Law/Legal

Sa - Safety

Q - Quality, Compliance

P - Property

O - Operations

E - Engineering

A - Administration

Per - Personnel image7.emf

Microsoft_PowerPoint_Slide16.sldx

Microsoft_Excel_Worksheet1.xlsx

Sheet1

L-10 Equipment Deadline Report

image8.emf

Microsoft_Word_Document17.docx Concept of Support

P-03

1. Concept of Support development is an iterative and interactive process with Government, particularly theater planners of the requiring activity, the LOGCAP Program Office planners forward, the associated Army Field Support Brigade, and the various staff agencies involved in operational planning.

2. Contractor shall evaluate planners identified capability gaps (Government must provide requirements/gaps) and assist with development of the Contract Statement of Requirement Tool (CSOR) modified to reflect LOGCAP WBS structure and capabilities.

3. Contractor will assist LOGCAP planners with converting CSOR requirements into a LOGCAP requirements package with associated Rough Order of Magnitude cost estimate.

4. Contractor will provide contractor manpower estimates and assist in developing TPFDD inserts to facilitate and integrate movement into theater. Personnel estimates include anticipated changes through each operational phase for insertion into Annex W of the plan.

5. When applicable, available trade space should be identified to inform the commander’s decision making, and areas of concern quantified through risk analysis and consideration of mitigation strategies.

image3.emf

Copy of CSOR_Tool_Vsn 95_06Sep16.xls

Cover Sheet

Crisis Action & CPX Plans (CAP)

Contingency Plans (OPLANS)

Contractor Support Operational Requirement Tool CSOR (Vsn 0.95)

INPUT

OUTPUT

Inputs

Assumptions

Contingency Plans (OPLANS)

Export OPLAN | CAP Worksheet

OPLAN

CAP

CSV worksheet to new file in computer directory

Process

1 ... n

1 ... n

Header Sheet 1 Sheet 2 Sheet n in workbook

Header Sheet 1 data Sheet 2 data Sheet n data to worksheet in new workbook

Instructions

Hidden Worksheets

Category Worksheet

CJCSM 3130.03 Table of Contents

Reference Tables

UofM Analysis

Pivot Table of CJCSM 3130.03

CJCSI 3126 Digraph Codes

PSC->JCA

TUCHA _TONS

Category Force Structure

Crisis Action & CPX Plans (CAP)

NSG Georegion Directory

UTC Output

Worksheets

Worksheet Name Worksheet Status Worksheet Tab Purpose

Cover Sheet Active The Cover Sheet tab displays the contents of the workbook and allows the user to "jump" to the respective worksheet by clicking on the figure.It also indicates, in general terms, the source information for the content of the respective worksheets.

Instructions Active The Instructions tab identifies the information that allows the user to complete either the OPLAN or CAP worksheets. The numbers in the blue or green box, take the user to the respective worksheet.

Worksheets Active The Worksheets tab rovides the names of the worksheets in the CSOR model tool. Each worksheet tab contains a description of what the worksheet contains and how it is used in the CSOR tool.

Assumptions Active The Assumptions tab allows the user to document any assumptions used to develop the requirements identified in the workbook. The user can enter information for the OPLAN or CAP in two separate color coded areas. Up to 100 cells are available. At this time, this information DOES NOT link to any other worksheets.

Inputs Active The Inputs tab provides the user with the ability to enter multiple information on the OPLAN or CAP worksheets. The primary inputs on this worksheet includes defining the operational phase start and end dates; setting the overall classification of the workbook output; choosing the type of plan for which requirements are being developed; entering the Combatant Command (CCMD) that the plan will support; generating a plan base number that will be unique; allow the user to enter plan numbers; and allow the user to set the plan annex plus the appendix and/or tab associated with the requirements. The user is able to have unique global parameters so that both OPLAN and CAP inputs can be developed at the same time.

UTC Output Active The UTC Output worksheet displays a filtered list of UTCs that are aligned to the CSOR Category codes. The user enters the CSOR category code in Inputs (Cell E27). This is automatically moved to the UTC Output worksheet. The user must then perform an Advanced Filter using the instructions found on the UTC Output worksheet. The data which is returned, is a subset of the data on the TUCHA Tons worksheet (hidden worksheet).

Reference Tables Hidden The Reference Tables tab is a hidden worksheet that contains the data needed to complete many of the choices the user can invoke on the Inputs worksheet and on the OPLAN and CAP worksheets. This worksheet contains the plan types (Deliberate, Crisis, Exercise); yes/no choices for those contract items that can be either a lease or service (59 of these); world countries and associated codes (JOPES short name, long name, Logistics Planning and Reporting (LPR) code; classification code (Unclassified, Unclas/FOUO, Confidential, Secret); phase day calculations (defines the operational phase in which a associated with a specific day (based on a D-day scheme); allows for the entering operational locations by defining the country, a nearby city, a location name, a standardized location code (based on the country's digraph code (using ANSI 3166 standard) plus appropriate region code within the country. Ultimately, a user will be able to choose from a drop-down list of 'approved' locations names and codes.

Contingency Plans (OPLAN) Active The Contingency Plans (OPLAN) tab (also the Crisis Action & CPX Plans (CAP)) contains the essence of formalize OPLAN requirements. This worksheet reflects the details of the by phase needs identified by the user. The unit of measure is a key parameter. The user identifies the magnitude of the requirement as well as the day within the phase the requirement is needed. The user has the abiltity to filter the view of the most commonly contracted needs. By inserting a number in the quantity field for any phase, the entire record is selected to be exported for further processing outside of the current workbook. The user has the abiltiy to choose when to export the data and to reset the input values associated with identified requirements.

Pivot of OPLAN Sheet Hidden The Pivot of OPLAN Sheet tab summarizes the 377 contractable entries found on both the OPLAN and CAP worksheets. It is a hiddent sheet but available to validate the list of contractable items.

Crisis Action & CPX Plans (CAP) Active The Crisis Action & CPX Plans (CAP) (also the Contingency Plans (OPLAN)) tab contains the essence of formalize OPLAN requirements. This worksheet reflects the details of the by phase needs identified by the user. The unit of measure is a key parameter. The user identifies the magnitude of the requirement as well as the day within the phase the requirement is needed. The user has the abiltity to filter the view of the most commonly contracted needs. By inserting a number in the quantity field for any phase, the entire record is selected to be exported for further processing outside of the current workbook. The user has the abiltiy to choose when to export the data and to reset the input values associated with identified requirements.

Export OPLAN | CAP Worksheet Active The Export OPLAN | CAP Worksheet contains a standardized header that allows transfer of the content of either the OPLAN or CAP worksheet for export. The user is able to determine which worksheet 'active content' (those records that have a number > 0 in the Quantity column for any of the operational phases. The user can export these records in CSV format to another workbook within the same file folder.

Category Worksheet Active The Category Worksheet tab aligns the standard contract category names with the Joint Capability Area (JCA), Staff Office of Primary Responsibility (OPR), Office of Secondary Responsibility (OSR), Product and Service Code (PSC), and Unit of Issue (or Unit of Measure). This table is used to validate those entries on the OPLAN and CAP worksheets.

UofM Analysis Hidden The UofM Analysis tab controls the Unit of Issue (Col O) on the OPLAN, CAP, and Export OPLAN | CAP Worksheet content.

CJCSM 3103.03 TOC Hidden The CJCSM 3103.03 TOC tab contains the current version of the manual's OPLAN Annexes, Appendices, and Tabs. This worksheet holds the data for the drop-down menus on the Inputs worksheet. By choosing an Annex title on the Inputs worksheet in either the OPLAN or CAP sections, the title data for either the Annex or Appendix is transferred to appropriate worksheet where the single character Annex letter is populated and/or the three character Appendix letters returned. The user can also select a Tab based on the Appendix. The content of the drop-down box arrays (for Annexes, Appendixes, and Tabs) are contained on this worksheet.

Pivot of 3103.03 TOC Hidden The Pivot of 3103.03 TOC tab summarizes the content contained in cells A1:G166 of the CJCSM 3103.03 TOC worksheet.

CJCSI 3126 Digraph Codes Hidden The CJCSI 3126 Digraph Codes tab contains the languages that were once enumerated in the CJSCI. The most current version of the CJCSI DOES not contain these language codes. These codes are provided to allow the user to choose languages for Interpreters or Translators. Although the CJCSI 3126 contained 383 languages, many are obscure and could not be readily aligned to a CCMD. As a consequence, the list was reviewed and easily recognized languages that were aligned to CCMDs were selected for display to the user. The final list includes 105 languages. Initially, these languages will ALL be available for selection. With time, the ability to focus on the CCMD the OPLAN or CAP supports will be provided.

PSC-> JCA Hidden The PSC-> JCA tab contains the alignment of a Product and Services (PSC) code to a Joint Capabilitiy Area (JCA). This alignment IS NOT authoritative. It should be validated over time with the contracting community and users.

Category Force Structure Hidden The Category Force Structure tab aligns the contract capabilities to a JCA. This IS NOT authoritative. It should be validated over time with the contracting community and users.

TUCHA_Tons Hidden The TUCHA_Tons tab includes unclassified unit type codes (UTCs) for the types of military capability that could be provided by a contractor. The intent is that the military unit UTC provides a "placeholder" in a force list where the source code for the capability would be contractor rather than a military service. This list is not all inclusive. It should be refined and validated over time.

NSG GeoRegions Directory Hidden The NSG GeoRegions Directory tab contains just over 5100 country regions with their codes from throughout the world. The NSG Directory uses the two character ISO digraph as the first two positions of the country's code. This is followed by a second set of coding that reflects the region code that is not standard...it can contain one to three characters...either all alphabetic or all numeric. The tab also indicates whether the coding is an ISO standard code. Planners, should consult this tab when developing country specific location codes. These entries are taken from ISO 3166-2 Subdivision Codes.

To End of Workboo

Instructions

NOTE: THIS IS A PLANNING TOOL RESULTING IN AN ESTIMATE. IT IS NOT A SUBSTITUTE FOR A PWS/SOW AND FUNDING NEEDED FOR EXECUTING CONTRACTS FOR THE SUPPLIES/SERVICES.

Contingency Planning CSOR (Deliberate Planning / OPLANS) Crises Action Planning CSOR (OPORDS/EXERCISES)

Use this Sheet for OPLANs Use this sheet for crises action planning (CAP) or CPXs

INSTRUCTIONS FOR COMPLETING THE CSOR SPREADSHEET

GENERAL COMMENTS: Both the Contingency Planning and Crisis Action Planning CSOR worksheets contain identical columns. Both use the same instructions for completing the worksheet. The major difference is that the Contingency Planning CSOR worksheet contains cells that do not require entries (red hashed cell background). These cells include columns for "when" (in the operation's phase), the supply/service that is needed, and a "Who" section for POC information for the Supply/Service. If a Contingency Planning CSOR was already produced, simply insert the "when" and "who" columns as well as adding the "when" dates needed.

1. Develop a separate worksheet (tab) for each operational location and/or operation 1. Develop a separate worksheet (tab) for each operational location and/or operation

1.a Locations that typically require support include:

Logistics Support (or Staging) Areas (LSAs), Ports (APOD/E, SPOD/E), Airfields, Intermediate Staging Bases (ISBs), Combat Support Hospitals (list separately even if in a larger area such as a LSA to maintain visibility), Detainee Holding Areas (list separately even if in a larger area such as a LSA to maintain visibility), Displaced Persons Camps, NEO processing stations (list separately even if in a larger area such as a LSA to maintain visibility) Forward Operating Bases (FOBs), Transportation Hubs Same

1.b Types of operations that typically require OCS (list these as separate locations to maintain visibility of the specialty mission:

RSOI, Port Operations, NEO perations, HA/DR & Displaced Persons Operations, Internment/EPW Oerations, Fuel Terminal Operations (DLA-E), DRMO Operations, Retrograde Operations, Reconstitution Operations, FSR Maintenance Operations, Redistribution Property Asstance Teams (RPAT).

This list is not all inclusive.

2. Insert Location - at the Top of the sheet (black area): 2. Insert Location - at the Top of the sheet (black area):

2.a. Country, City Same

2.b.City

2.c. Operational Area Name (e.g. Area XXX)

2.d. LSA Name (e.g., LSA XXX)

2.e. 4 Digit Grid (or approximate coordinates, e.g., 41.5, -99.5 which is 41.5 N, 99.5 W)

3. Insert spreadsheet POC information at the top right section of the sheet (black area) 3. Insert spreadsheet POC information at the top right section of the sheet (black area)

3.a. Name Same

3.b. Unit / Position (e.g., Unit number / Engineer planner)

3.c. Tel # / email address

4. Insert Planning Assumptions by phase at the top left section of the sheet: 4. Insert Planning Assumptions by phase at the top left section of the sheet:

4.a Total estimated population of the location. Sum estimated total of soldiers, civilians, and contractors Same

4.b. Estimated length of each phase (# of days). This will be the assumption for the length of service requirements (e.g. the duration of a truck lease for the phase)

5. Insert CJCSM 3130.03 Annex and Appendix this CSOR worksheet supports 5. Insert CJCSM 3130.03 Annex this CSOR input supports

5.a. Select the OPLAN annex this CSOR worksheet supports Same

5.b. Identify the Appendix/Tab combination associated with the line entry

6. Determine the applicable items/services required to support the location/population: 6. Determine the applicable items/services required to support the location/population:

6.a. Delete rows that are not applicable

6.b Add rows if the supply or service is not listed

6.c For equipment, specify if lease (contractor owned/ government operated) or service (with driver/operator). Put an "X" in the applicable block identifying the requirement. If both lease and service is required, then add a row and enter each as a separate row.

The reason this is important is that a service will generate contractors on the battlefield. In many cases, this requires accountability, force protection, and sustainment requirements for those contractors.

"#" in the quantity column indicates the requirement to specify the number required. Replace the "#" symbol with the number required

6.d. If Multiple sizes are needed of a certain commodity - then add a row for each size. Ensure that the Unit of Issue / Unit of Measure are accurately entered.

JS, J4:

Many of these inputs can be entered on the Inputs sheet. Data entered via the Input sheet will populate both the OPLAN and Crisis Action & CPX Plans worksheets.

Go to OPLAN

Go to CAP

Go to Inputs Worksheet

Return to cover

Assumptions

Contingency Plans (OPLANS) Assumptions Crisis Action & CPX Plans (CAP) Assumptions

Return to cover

Inputs

Plan Number Plan Title

Combatant Command Plan ID Begins with 0 Plan # AFRICOM Countries Classification A123 AFRICOM Neo-Namibia

AFRICOM A OR 7 A123 1 Niger UNCLASSIFIED ABC1 AFRICOM Country Protection

A 7 7123 AFRICOM Humanitarian Response

Plan Type Plan Type Code Plan Title 7ABC AFRICOM Niger JTF-TS Support

Crisis 0 C AFRICOM Neo-Namibia 0 Iraq C123 CENTCOM Neo-Lebanon

CABC CENTOCM Missile Defense

OPLAN CAP/Exercise OPLAN 4EFG EUCOM Baltic Response

Phases based on D-day Phases based on D-day 0 Belgium Annex ANNEX D--LOGISTICS 1123 CENTCOM Israel Air Defense

PLAN Phases Phase Start Phase End Phase Start Phase End Appendix D-7 Appendix 7--Nonnuclear Ammunition 1ABC CENTCOM Exercise Support

Phase 0 -90 5 -75 -15 Tab D-7-A Tab A--Munitions Matrix S456 SOUTHCOM Theater Cooperation

Phase I 6 9 -14 -8 0 6A72 SOUTHCOM Olympic Support

Phase II 10 15 -7 1 E789 EUCOM Migrant Support

Phase III 16 25 2 25 CAP/Exercise 4ABC EUCOM Maritime Operations

Phase IV 26 40 26 40 0 Australia Annex ANNEX C--OPERATIONS 1A30 CENTCOM Test Plan

Phase V 41 90 41 90 Appendix C-5 Appendix 5--Personnel Recovery (PR) PABC PACOM Typhoon Response

Opn Length 181 days Opn Length 166 days Tab C-5-E Tab E--Accounting 55XX PACOM Maritime Security

0 Argentina N33V NORTHCOM New Madrid

3DCA NORTHCOM NCR Support

PLAN ID Z66A Test Operation

A123-C-C-XXXXX Plan # Plan Type Annex Sequence 0 Armenia

A123 C C XXXXX

PLAN Base

A123-C-C

Use C-day or D-day? Item > UTC

D P06

Enter the start and end date (using D-day) as a reference for Phase I. Enter the end date for subsequent phases (tool calculates the start of the next phase by adding 1 day to the end date of the previous phase.

Choiice of Combatant Command returns these characters for the first position of the Plan ID.

Enter the start and end date (using D-day) as a reference for Phase I. Enter the end date for subsequent phases (tool calculates the start of the next phase by adding 1 day to the end date of the previous phase.

This drop down box provides the User with the list of plans where the first letter or number appears in the Plan List (Reference Tables Worksheet). If there is no plan number that matches user guidance, then a plan number must be added to the plan number table. After addition, then the user can select the applicable plan. The first position of the plan number is aligned to a CCMD, the subsequent three characters are a user/planner choice.

Alternately, user can choose from a list of Plan # already in the CSOR.

This sequence is determined by the final number of entries from the CSOR worksheet.

Enter the start and end date (using D-day) as a reference for Phase I. Enter the end date for subsequent phases (tool calculates the start of the next phase by adding 1 day to the end date of the previous phase.

Select the Annex from the dropdown list. Chosen Annex will appear on Contingency Plans (OPLAN) worksheet in Cell C4.

JS,J4:

Select the Appendix from the drop down list using the first character to determine the applicable Annex. If an Appendix is not associated with the Annex, the Annex will indicate "None". If there are Appendices AND the user does not want to enter this, choose the "None" associated with the chosen Annex.

Choose the Tab associated with the selected Appendix. If the user does not want to enter a Tab, select "None" from the Tab dropdown for the respective appendix.

Select the Annex from the dropdown list. Chosen Annex will appear on Contingency Plans (OPLAN) worksheet in Cell C4.

Select the Appendix from the drop down list using the first character to determine the applicable Annex. If an Appendix is not associated with the Annex, the Annex will indicate "None". If there are Appendices AND the user does not want to enter this, choose the "None" associated with the chosen Annex.

Choose the Tab associated with the selected Appendix.