G-9_Space_Data_Collection_Requirements_Template_-_28_Oct_15.xlsx

Program

UOM is N/A for this sheet. Column included only for shape consistency.

Est/Act is N/A for this sheet. Column included only for shape consistency.

Enter text for each parameter.

Copy additional rows as needed for multiple subprograms and models.

Milestone

Enter parameter values as a single date value in this column.

Identify if the parameter value is an actual value or an estimated value.

Enter parameter values as a single date value in this column.

Identify if the parameter value is an actual value (A) or an estimated value (E).

If these columns are expanded and used to convey a second subprogram or model, take care to each case in the first column heading cell.

When any parameter calls for additional detail, insert rows underneath and indent sub-names as needed.

For additional columns to express alternative designs, hit Ungroup button above.

When parameter varies by subprogram, enter subprogram name in this column.

If no subprograms, then leave this column empty.

Acquisition (CEM)

The column headings shown are an example only. Modify headings and insert additional columns as needed to fully describe the acquisition plan.

Describe each Phase, Contract, and/or Lot.

Consider using a time-phased Table to fully describe annual quantities. See adjacent sheet "Quantities and O&S Time Phased" Copy the Model and Quantity rows and repeat for each Model or Configured End Item as needed

Acquisition (CARD)

Provide quantitiy information on the Acquisition and O&S Time Phased Table.

Describe each Phase and Production Lot.

The column headings shown are an example only. Modify headings and insert additional columns as needed to fully describe the program model.

List all planned lots in sequence. Insert additional columns as needed.

Quantities and O&S Time Phase

Enter name of item.

Use headings in bold and indent wherever it is useful to do so.

All entries below are examples only.

Enter annual values here.

Note early years may be know and future years forecasted. Designate in row 6.

For procurement quantities, enter text describing long-lead requirements. Could be expressed as a percent of funds or names of specific items that must be purchased early.

Otherwise leave blank.

Unit of Measure is Aircraft, Engines, AURs, Radars, Silos, Sites, etc.

Enter annual quantities here. For prototypes convey the year delivered.

Include non-PME as well as PME.

Enter annual quantity installed or delivered here.

This is pertinent for modeling fielding event costs.

Enter the cumulative quantities delivered and supported here.

This is pertinent for modeling O&S costs.

Show ramp-down of items leaving service at end of useful life.

Enter quantity of sites activated here.

Entries often will simply be 1 if each site is explicitly named in column C..

This is pertinent for modeling base activation costs and to begin O&S of location costs.

Enter annual quantity of kits purchased for modification events here.

This is pertinent for modeling Mods costs.

Enter annual quantity of items leaving service at end of useful life.

This is pertinent for modeling disposal costs as well as density ramp-down.

Begin at earliest year quantity data is applicable.

List all program years. Avoid using Prior and To-complete columns - be explicit.

Enter the cumulative quantities delivered and supported by location here.

This is pertinent for modeling O&S costs.

Show ramp-down of items leaving service at end of useful life.

Enter annual quantities here. For procurement convey the year funded.

Include non-PME as well as PME.

Enter annual quantity of overhauls or any other scheduled Depot activity here.

This is pertinent for modeling Depot costs.

Enter annual quantity of NDA refresh events here.

This is pertinent for modeling refresh cycle costs.

Other potential usage measures. Enter annual activity. Expand by Location or End Item as needed.

Enter annual quantity of modification installs here.

This is pertinent for modeling Mods costs.

Enter annual concurrent production quantities here. Concurrent production represents units produced by the contractor for other parties such as Foreign Military Sales or any other customer.

For each Operational Activity row, expand by Location or or operational state. Then further expand by End Item/Variant as needed. Enter annual activity in columns.

Roles

Specify Government's Role by WBS Element (e.g. GFE, Test, Depot Activation).

Specify Prime Contractor Name by WBS Element.

Specify Subcontractor/Supplier/3rd Party by name. Elaborate on specific role or contracting arrangement in Notes if needed.

HW Tech Table