purpose to storms proposal... · web viewinclusion of instructions and process flow diagrams for...

Guide to Proposal Price Reports (PPRs)

Version 2.0

15 Sep 2012

Notes about this version:ALL Updated Proposal Price Report file format (no Monthly Units or Monthly

Rates).

Inclusion of instructions and process flow diagrams for new submission method of transaction formats for Proposal Price Reports (PPRs)

Gov’t will notify once “Direct Upload” feature is ready. Currently, all proposing SITE vendors must continue to follow the same process as before: Submit the PPR as part of the cost proposal package directly to the Contract Specialist. The Contracting Specialist will advise you if your PPR did not process successfully in STORMS.

NOTE:

For all task orders previously awarded with proposed monthly rates, the Vendor may continue to charge at the monthly rates in their STORMS Expense Reports.

Primary Points of Contact

STORMS Project Manager: [email protected]

SITE Program Office: [email protected]

STORMS Access Requests: [email protected]

STORMS Technical Support: [email protected]

STORMS General Inquiries: [email protected]

STORMS Transaction Formats V1.0 Page ii

mailto:[email protected]





Table of ContentsPurpose..........................................................................................................................................1

Background....................................................................................................................................1

STORMS Transaction Files..............................................................................................................2

STORMS Proposal Price Report (PPR) File Specifications...............................................................3

STORMS Proposal Price Report File Naming Convention...........................................................3

Proposal Spreadsheets Naming Convention..............................................................................3

TO_Labor Spreadsheet (Labor Transaction Formats)....................................................................4

Proposal Labor Transaction Column Specifications...................................................................5

STORMS Processing Rules and Considerations..........................................................................9

STORMS Proposal Valid Labor Price Transactions......................................................................9

STORMS Proposal Labor Price Transaction Error Conditions...................................................11

TO_ODCs Spreadsheet.............................................................................................................13

Proposal ODC Transaction Column Specifications...................................................................13

Submission of Transaction files into STORMS..............................................................................15

Submitting Proposal Price Reports (PPR).................................................................................15

Appendix A: Abbreviations..........................................................................................................16

Appendix B: IDIQ Labor Categories.............................................................................................17

Appendix C: IDIQ Price Groups....................................................................................................19

Appendix D: Approved Country Codes for STORMS....................................................................21

STORMS Transaction Formats V1.1 Page i

Guide to Preparation and Submission of STORMS Transaction Formats

Purpose

This guide provides detailed information about the formatting, submission process, and automated processing of transactions used by the SITE Task Order and Requirements Management System (STORMS).

Background

STORMS is an automated system for managing the status and detailed expenses of SITE Task Orders. Based on regular Contractor-provided inputs, the STORMS database contains information about the Labor costs and Other Direct Costs (ODCS) expenditures for each task order. STORMS also stores the IDIQ “not-to-exceed” labor rates by labor category, period of performance (PoP), and geographical work location (Price Group) for each SITE Vendor. The IDIQ rates are used during the Task Order Request for Proposal (RFP) process to validate each line of a Vendor’s submitted proposal.

Upon Task Order award, STORMS is loaded with the winning vendor’s price submission, in the form of a formatted report called the Proposal Price Report (PPR). This data includes the proposed labor categories, specific Task Order not-to-exceed rates, proposed levels of effort, and ODCs, among other contract data. This information is then used during the operational life of the Task Order to validate the information submitted by Vendors in the STORMS Expense Reports (SER) (formerly called Monthly Expense Reports (MERs)).

The below process flow illustrates the timing of submission of the Proposal Price Report (PPR) and STORMS Expense Report (SER).

STORMS Transaction Formats V1.0 Page 1

STORMS Transaction Files

To facilitate the automated import of data from the SITE vendors, a set of structured file formats has been developed to support the processing of the proposal and expenditure information for Task Orders.

There are two types of structured transaction files used by STORMS:

1) The first is the Proposal Price Report (PPR) which is prepared by the vendors and is a required component of the proposal response submitted for all SITE Task Order RFPs.

2) The second is the STORMS Expense Report (SER) which is used by Vendors to submit all the expenses incurred during the life of the Task Order. The separate SER file is a required delivery for all SITE Task Orders. To provide the COR with matching detailed expense information to the invoice, the SER needs to be processed into STORMS the same day (or within 2 working days) of when the invoice is submitted to NSA (or payment processing office).


STORMS Proposal Price Report (PPR) File Specifications

The PPR is submitted directly to the SharePoint “Upload Price Proposal” tool in coordination with the proposal package for every Task Order RFP by each participating vendor. It consists of an MS Excel Workbook (no earlier than Excel version 2007) and must include two specifically named spreadsheets containing the transactions that will be processed by STORMS to validate the price data for the proposed Task Order.

STORMS Proposal Price Report File Naming Convention

The PPR is a MS Excel 2007 or 2010 structured file. The PPR file name is composed of three parts preceding the file extension: the Vendor’s IDIQ contract number, the Task Order Request for Proposal (RFP) number, and the STORMS file type “PPR”. Underscores (“_”) are used for separators between each part preceding the Excel file extension (either “.xlxs” or “.xls”). The format is defined as follows:

[Vendor’s SITE IDIQ Contract #] + “_”+ [Task Order RFP #] + “_PPR” + [.File Type Extension]

This can be expressed simply as: IDIQ #_RFP #_PPR.xlsx (or .xls)

An example name is: HHM402-10-D-00XX_HHM402-11-R-XXXX_PPR.xlxs where HHM402-10-D-00XX represents a SITE IDIQ contract, HHM402-11-R-XXXX is the

Task Order RFP number, “PPR” defines the STORMS file format, and “.xlsx” is an Excel 2010 file type.

Note: A PPR file name MUST not contain and apostrophe (‘) or the file will not process within STORMS.

Proposal Spreadsheets Naming Convention

The names of the two spreadsheets contained within the proposal file are: “TO_Labor” and “TO_ODCs”. Both spreadsheets must be contained within the file and the names of the spreadsheets must be labeled exactly as defined (see figure below).


The “TO_Labor” spreadsheet is used to submit the transactions for the proposed Labor cost information (e.g., labor categories, rates, levels of effort, etc.). The “TO_ODCs” spreadsheet is used to submit the transactions that contain all the essential cost information for the proposed Other Direct Costs (ODCs).

Other spreadsheets can be created in the file to assist Vendors during proposal preparation. These spreadsheets are ignored by STORMS and have no adverse effect during processing. The order of spreadsheets within the file does not matter.

The specific transaction formats for the “TO_Labor” and “TO_ODCs” spreadsheets are defined in the next two sections.

TO_Labor Spreadsheet (Labor Transaction Formats)

The TO_Labor spreadsheet contains the set of data which describes the bidder’s proposed labor costs for each Task Order period, CLIN, geographical location, and work facility. Because most Task Order Periods of Performance (PoP) straddle two IDIQ periods of performance, there are actually two approved rates that are applicable within a given Task Order PoP (see example diagram below).

In the illustration above, the Base period for the planned Task Order begins during Option Year 2 of the SITE IDIQ and ends sometime in Option Year 3. The Base period for this Task Order therefore has two possible approved rates that apply during its delivery. “Blended” rates (usually based on weighted averages) are sometimes used to define new rates applicable for


each Task Order’s PoP. SITE Task Orders will generally not use blended rates. For SITE, Vendor’s have the option of submitting two rates per PoP. Each must comply with the individual not-to-exceed rates of the associated IDIQ PoP. If a second rate is not included, the first rate will be applied to the entire period of performance of the Task Order.

In the example above, the proposed Task Order rates (Rate 1 and Rate 2) must comply with the corresponding not-to-exceed rates of the corresponding PoP of the IDIQ. STORMS will verify that each proposed labor rate does not exceed the corresponding IDIQ rate.

The structure of the TO_Labor transactions therefore contains the information used to identify the corresponding Contract and Task Order data, the type of labor being proposed, and places to submit the two corresponding labor rates for this PoP. The logical structure of the proposal labor transaction format is shown in the next diagram.

CONTRACT TASK ORDER IDENTIFICATION

LABOR TYPE IDENTIFICATION

LABOR RATE - PoP Start Date until 13 May

LABOR RATE - 14 May until POP End Date

PRICE TOTALS DATA

Proposal Labor Transaction Column Specifications

The specific column names and data formats for the proposal Labor transaction submissions are as follows:


The definitions of each column in the TO_Labor spreadsheet are provided below. (Note: There are no embedded spaces in the column names)

Column Name Contents Field Type

Contract Contract Number - The SITE IDIQ contract number of the submitting vendor (NOT the RFP number). The bidding Vendor is responsible for entering their IDIQ contract number on all the Labor lines being proposed. Any lines on the spreadsheet with a blank Contract # will be ignored during processing—this allows the Vendor to enter other data for their use such as subtotals and not affect STORMS processing.

Text

TaskOrder Task Order name – This name will be provided by the SITE PMO and will be unique for every Task Order. It must not be changed in order for the file to process correctly. Note: This element will eventually be changed to the awarded Task Order number in order to submit STORMS expense reports (but that number is not defined until the actual award is made).

Text


Period Period of Performance (PoP) – Identifies the PoP within the Task Order to which the proposed labor on this line applies. The first period is always defined as “Base” and each succeeding PoP as “Option #” such as “Option 1”, “Option 2”, etc.

Text

CLIN Contract Line Item Number – The RFP will identify the CLINs to be proposed. Each PoP may contain multiple CLINs. Labor Category rates are managed and validated separately for each CLIN so a proposal can provide different rates on separate CLINS as long as they are within the IDIQ rate.

Text

PriceGroup IDIQ Price Group – This equates to the geographical locations where work is being performed. There were seven (7) price groups for the United States and 18 foreign locations (oversees) in the original IDIQ contracts—more may be added over time.

Text

Category Labor Category – This is the labor skill being proposed. There are 51 IDIQ approved labor skills. Any new labor skills applicable to the Task Order being proposed must be approved in advance of the submission or the labor category will not pass the STORMS proposal validation test.

The Category text must exactly match one of the IDIQ categories or an approved new labor category (see Appendix B for exact strings and/or alternative abbreviations that can be used).

Text

HourlyUnits Total Hours – The consolidated number of hours proposed for this labor category until the end of the Task Order PoP (or if applicable until HourlyRate2 applies based a change in allowable IDIQ rates).

Number

HourlyRate Hourly Rate of Labor – This is the proposed fully burdened labor rate for one (1) hour of work on the Task Order regardless of the type of contract (FP, LH, T&M, CP, etc.).

This specific rate applies from the start of the Task Order PoP and remains in effect for the duration of the PoP unless a second rate (HourelyRate2) is proposed as authorized by a change the IDIQ PoP rates.

Note: Regardless of the type of contract being proposed (FP, LH, T&M, CP, etc.), the proposed rate must be less than or equal to the Vendor’s not-to-exceed IDIQ rate for the corresponding period of the work being performed or an error will be produced by STORMS).

Currency

Markup Offsite Markup Rate – This percentage markup is applied to the Percentage


proposed labor rate when the Vendor’s employee will work at a Contractor provided facilities (i.e., not working at a Government provided facility). No other form of markup is allowed since these costs should already be included as part of the fully loaded rate according to the IDIQ award.

Separate transactions are required for a labor Category when more than one Markup rate applies (i.e., work will be conducted at two or more Contractor provided facilities which have different associated Markup costs).

HourlyUnits2 Total Hours 2 – Similar to the HourlyUnits column except that it consists of the consolidated number of hours for this labor category based on the portion of the work performed after the change in IDIQ rates and ending with the Period defined on this line for the Task Order.

Number

HourlyRate2 Hourly Rate 2 for Labor – Similar to the HourlyRate column except that this proposed rate is effective upon the date when the IDIQ PoP rates change (for SITE that is always 14 May each year). HourlyRate2 remains in effect until the end of the Period (PoP) defined on this line.

Currency

Markup2 Offsite Markup Rate 2 – Similar to the Markup column except that it applies only to the portion of work defined by the HourlyRate2 submission.

Percentage

TotalHours Total Number of Hours – The sum of hours calculated as follows:

= HourlyUnits + HourlyUnits2

Number

Total of Hourly Cost (without off-site Markup)

Total of Hourly Costs before off-site Markup is applied – The total cost, excluding markup fee for off-site contractor facilities, based on the following formula:

= (HourlyUnits * HourlyRate) + (HourlyUnits2 * HourlyRate2)

Currency

Total of Hourly Cost (includes off-site Markup)

Total of Hourly Costs with off-site markup percentage applied – Total cost for this labor line calculated as follows:

= (HourlyUnits * [(HourlyRate * (1 + Markup))] + (HourlyUnits2 * [(HourlyRate2 * (1 + Markup2))]

Currency


STORMS Processing Rules and Considerations

The following situations apply when processing transactions in STORMS:

Only one (1) consolidated transaction is submitted for each Labor Category where the Period, CLIN, Group, and Markup are the same. STORMS will identify a duplicate transaction error when more than one line has the exact same Labor Category, Period, CLIN, Group, and Markup.

In the situation where a Labor Category will be hosted at multiple Vendor provided facilities within the same Period, CLIN, and Price Group—only one combined transaction is submitted if the Markup rates are all the same; otherwise, a separate transaction line must be submitted for each different Markup rate showing the correct level of effort applicable to each Markup.

Excel workbook spreadsheet names and the Column names within the transaction cannot be altered or STORMS will reject the entire spreadsheet.

Any row in which the Contract column is blank is ignored. This allows comments and subtotals to be included (if desired) as long as this column is blank.

Additional columns can be added at the Vendor’s discretion when constructing the proposal labor spreadsheet to allow for subtotals, totals and other related information. These columns are ignored by STORMS. Additional columns cannot use any of the reserved STORMS column names.

The order of the spreadsheet columns does not matter. No new Labor Category can be submitted in a transaction unless approved in advance of

submission and in writing by the Contracting Officer. Any unrecognized Labor Category will be rejected by STORMS. To avoid this, submit a copy of the approved new Labor Category name (exactly as it will be submitted in the proposal) to the SITE PMO mail box.

STORMS Proposal Valid Labor Price Transactions

The table below provides examples of properly formatted transactions or transactions treated as non-proposal submissions (a blank in the “Contract” column causes the entire row to be ignored).


STORMS Proposal Labor Price Transaction Error Conditions

The set of error conditions identified by STORMS includes (but is not limited to) the example transactions below. (Due to its width, the spreadsheet columns are shown stretched over the next two pages. The first column in blue is not part of the spreadsheet. It is only used to provide cross reference lines to the associated description error conditions on the next page.)

Test

Line Contract

Task

Ord

er

Period CLIN

Pric

eGro

up

Category

Hour

lyRa

te

Hour

lyU

nits

Mon

thly

Rate

Mon

thly

Uni

ts

Mar

kup

Hour

lyRa

te2

Hour

lyU

nits

2

Mon

thly

Rate

2

Mon

thly

Uni

ts2

Mar

kup2

LP-B-01 HHM402-10-D-XXXX T001 Base 0001 Group 1 32. Graphics Specialist $43.00 25 1.0% $43.00 22 1.0%LP-B-02 HHM402-10-D-TEST T001 Base 0001 Group 2 32. Graphics Specialist 10LP-B-03 HHM402-10-D-TEST T001 Base 0001 Group 3 32. Graphics Specialist 100LP-B-04 HHM402-10-D-TEST T001 Base 0001 Group 4 32. Graphics Specialist 100LP-B-05 HHM402-10-D-TEST T001 Base 0001 Group 5 32. Graphics Specialist 100LP-B-06 HHM402-10-D-TEST 9999 Base 0001 Group 6 32. Graphics Specialist $43.00 25 1.0% $43.00 25 1.0%LP-B-07 HHM402-10-D-TEST T001 XXX 0001 Group 6 32. Graphics Specialist $43.00 36 1.0% $43.00 26 1.0%LP-B-08 HHM402-10-D-TEST T001 Base 9999 Group 6 32. Graphics Specialist $43.00 25 1.0% $43.00 27 1.0%LP-B-09 HHM402-10-D-TEST T001 Base 0001 XXXX 32. Graphics Specialist $43.00 58 1.0% $43.00 54 1.0%LP-B-10 HHM402-10-D-TEST T001 Base 0001 Group 6 XXXX $43.00 14 1.0% $43.00 23 1.0%LP-B-11 HHM402-10-D-TEST T001 Base 0001 Group 1 33. VTC Operator $500.00 25 1.0% $43.00 55 1.0%LP-B-12 HHM402-10-D-TEST T001 Base 0001 Group 2 33. VTC Operator -$20.00 67 1.0% $43.00 23 1.0%LP-B-13 HHM402-10-D-TEST T001 Base 0001 Group 3 33. VTC Operator $20.00 -20 1.0% $43.00 34 1.0%LP-B-14 HHM402-10-D-TEST T001 Base 0001 Group 4 33. VTC Operator -$1.00 1 0.0% $43.00 23 0.0%LP-B-15 HHM402-10-D-TEST T001 Base 0001 Group 5 33. VTC Operator $1,000.00 -1 0.0% $43.00 56 0.0%LP-B-16 HHM402-10-D-TEST T001 Base 0001 Group 6 33. VTC Operator $43.00 25 -1.0% $43.00 23 1.0%LP-B-17 HHM402-10-D-TEST T001 Option 1 1001 Group 1 33. VTC Operator $43.00 34 1.0% $500.00 43 1.0%LP-B-18 HHM402-10-D-TEST T001 Option 1 1001 Group 2 33. VTC Operator $43.00 43 1.0% -$20.00 22 1.0%LP-B-19 HHM402-10-D-TEST T001 Option 1 1001 Group 3 33. VTC Operator $43.00 46 1.0% $43.00 -20 1.0%LP-B-20 HHM402-10-D-TEST T001 Option 1 1001 Group 4 33. VTC Operator 0.0% $43.00 43 -$1.00 1 0.0%LP-B-21 HHM402-10-D-TEST T001 Option 1 1001 Group 5 33. VTC Operator 0.0% $43.00 23 $1,000.00 -1 0.0%LP-B-22 HHM402-10-D-TEST T001 Option 1 1001 Group 6 33. VTC Operator $43.00 50 1.0% $43.00 56 -1.0%LP-B-23 HHM402-10-D-TEST T001 Option 1 1001 Group 6 33. VTC Operator $43.00 50 1.0% $43.00 43 1.0%LP-B-24 HHM402-10-D- T001 Base 2001 Group 7 33. VTC Operator $43.00 50 1.0% $43.00 12 1.0%LP-B-25 HHM402-10-D-TEST T002 Base 2001 Group 7 33. VTC Operator $43.00 50 1.0% $43.00 23 1.0%LP-B-26 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $40.00 50 3.0% $40.00 45 3.0%LP-B-27 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $1,000.00 1 3.0% $43.00 34 $1,000.00 1 6.0%LP-B-28 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $1,000.00 1 6.0% $43.00 32 $1,000.00 1 3.0%LP-B-29 HHM402-10-D-TEST T001 Base 0001 Group 2 07. Network Engineer $40.00 50LP-B-30 HHM402-10-D-TEST T001 Base 0001 Group 2 07. Network Engineer $45.00 45 1.0%LP-B-31 HHM402-10-D-TEST T001 Base 0001 Group 2 07. Network Engineer $45.00 56LP-B-32 HHM402-10-D-TEST T001 Base 0001 Group 3 07. Network Engineer $40.00 67LP-B-33 HHM402-10-D-TEST T001 Base 0001 Group 3 07. Network Engineer $43.00 50LP-B-34 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network EngineerLP-B-35 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $25.00LP-B-36 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $25.00LP-B-37 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $25.00 $25.00LP-B-38 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $100.00LP-B-39 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $100.00LP-B-40 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $100.00 $100.00LP-B-41 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer 1.0%LP-B-42 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer 1.0%LP-B-43 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer 1.0% 1.0%LP-B-44 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $25.00 1.0%LP-B-45 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $25.00 1.0%LP-B-46 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $25.00 1.0% $25.00 1.0%LP-B-47 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $100.00 1.0%LP-B-48 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $100.00 1.0%LP-B-49 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $100.00 1.0% $100.00 1.0%LP-B-50 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $25.00 $100.00 1.0% $25.00 $100.00 1.0%LP-B-51 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $25.00 $100.00 $25.00 $100.00 1.0%LP-B-52 HHM402-10-D-TEST T001 Base 0001 Group 1 07. Network Engineer $25.00 $25.00 1.0%


(Proposal Price Report continued from previous page)

Tota

lHou

se

Hour

lyCo

st

Tota

lMon

ths

Mon

thly

Cost

Tota

lCos

t

Test

Line Error Condition

47 $2,021.00 0 $0.00 $2,021.00 LP-B-01 ERROR - Invalid Contract #10 $0.00 0 $0.00 $0.00 LP-B-02 ERROR - HourlyUnits bid without a rate

100 $0.00 0 $0.00 $0.00 LP-B-03 ERROR - HourlyUnits2 bid without a rate0 $0.00 100 $0.00 $0.00 LP-B-04 ERROR - MonthlyUnits bid without a rate0 $0.00 100 $0.00 $0.00 LP-B-05 ERROR - MonthlyUnits2 bid without a rate50 $2,150.00 0 $0.00 $2,150.00 LP-B-06 ERROR - Invalide Task Order62 $2,666.00 0 $0.00 $2,666.00 LP-B-07 ERROR - Invalid Period52 $2,236.00 0 $0.00 $2,236.00 LP-B-08 ERROR - Invalid CLIN

112 $4,816.00 0 $0.00 $4,816.00 LP-B-09 ERROR - Invalid Price Group37 $1,591.00 0 $0.00 $1,591.00 LP-B-10 ERROR - Invalid Category80 $14,865.00 0 $0.00 $14,865.00 LP-B-11 ERROR - HourlyRate1 exceeds IDIQ rate90 -$351.00 0 $0.00 -$351.00 LP-B-12 ERROR - Invalid Hourly Rate1 14 $1,062.00 0 $0.00 $1,062.00 LP-B-13 ERROR - Invalid HourlyUnits1 23 $989.00 1 -$1.00 $988.00 LP-B-14 ERROR - Invalid MonthlyRate156 $2,408.00 -1 -$1,000.00 $1,408.00 LP-B-15 ERROR - Invalid MonthlyUnits148 $2,064.00 0 $0.00 $2,064.00 LP-B-16 ERROR - Inalid Markup177 $22,962.00 0 $0.00 $22,962.00 LP-B-17 ERROR - HourlyRate2 exceeds IDIQ rate65 $1,409.00 0 $0.00 $1,409.00 LP-B-18 ERROR - Invalid Hourly Rate226 $1,118.00 0 $0.00 $1,118.00 LP-B-19 ERROR - Invalid HourlyUnits2 43 $1,849.00 1 -$1.00 $1,848.00 LP-B-20 ERROR - Invalid MonthlyRate2 23 $989.00 -1 -$1,000.00 -$11.00 LP-B-21 ERROR - Invalid MonthlyUnits2

106 $4,558.00 0 $0.00 $4,558.00 LP-B-22 ERROR - Invalid Markup2 93 $3,999.00 0 $0.00 $3,999.00 LP-B-23 ERROR - Duplicate Labor Category above62 $2,666.00 0 $0.00 $2,666.00 LP-B-24 ERROR - Mutiple Contracts in same file 73 $3,139.00 0 $0.00 $3,139.00 LP-B-25 ERROR - Mutiple Task Orders in same file 95 $3,800.00 0 $0.00 $3,800.00 LP-B-26 OK - Used to test next 2 error lines34 $1,462.00 2 $2,000.00 $3,462.00 LP-B-27 ERROR - Duplicate Record L-Bad-2632 $1,376.00 2 $2,000.00 $3,376.00 LP-B-28 ERROR - Duplicate Record L-Bad-2650 $2,000.00 0 $0.00 $2,000.00 LP-B-29 OK - Used to test next 2 error lines45 $2,025.00 0 $0.00 $2,025.00 LP-B-30 ERROR - Duplicate Record L-Bad-2956 $2,520.00 0 $0.00 $2,520.00 LP-B-31 ERROR - Duplicate Record L-Bad-2967 $2,680.00 0 $0.00 $2,680.00 LP-B-32 OK - Used to test next error line50 $2,150.00 0 $0.00 $2,150.00 LP-B-33 ERROR - Duplicate Record L-Bad-320 $0.00 0 $0.00 $0.00 LP-B-34 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-35 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-36 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-37 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-38 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-39 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-40 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-41 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-42 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-43 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-44 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-45 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-46 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-47 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-48 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-49 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-50 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-51 Non bid - Line Ignored (No hourly or monthly units)0 $0.00 0 $0.00 $0.00 LP-B-52 Non bid - Line Ignored (No hourly or monthly units)


TO_ODCs Spreadsheet

The TO_ODCs spreadsheet contains the set of data which describes the vendor’s proposed ODC costs for each Task Order period and CLIN.

The specific column names and data formats for the proposal ODC transaction submissions are as follows:

Contract TaskOrder CLIN TrackingID Type Item Count Each Markup G&A Total

HHM402-10-D-XXXX Sample 0001 A01 Material Hardware 1 2 $100.00 1.00% 4.00% $210.08

The definitions of each column in the TO_ODCs spreadsheet are provided below.

Proposal ODC Transaction Column Specifications

The specific column names and data formats for the ODC transaction submissions are provided below. (Note: There are no embedded spaces in the column names)

Column Name Contents Field Type

Contract Contract Number - The SITE IDIQ contract number of the submitting Vendor (NOT the RFP number). The bidding Vendor is responsible for entering their IDIQ contract number on all the ODC lines being proposed. Any lines on the spreadsheet with a blank Contract # will be ignored during processing—this allows the Vendor to enter extraneous data such as subtotals and not affect STORMS processing.

Text

TaskOrder Task Order name – This name will be provided by the SITE PMO and will be unique for every Task Order. It must not be changed in order for the file to process correctly. Note: This text item will eventually become a standard Task Order number in order to submit STORMS expense reports, but that number is not defined until the actual award is made.

Text

CLIN Contract Line Item Number – The RFP will identify the CLINs to be used for ODCs. The ODC transaction formats are validated and stored in the database based on the CLIN.

Text

TrackingID Unique Vendor ODC Tracking Identifier –This is a unique tracking identifier provided by the Vendor and is used as a reference to the ODC submitted on this transaction. When the winning Vendor’s proposal file is loaded into STORMS, this ID is stored and used for correlating ODC expenses as they are submitted.

Text


Type ODC Type – This is the type of ODC being proposed. The SITE IDIQ contract identifies the types of ODCs which may be proposed. The text in this column must exactly match one of the IDIQ approved ODC types as follows:

HousingFacilitiesMaterialsOEM Payments (Relocation and other)OTSS (Outside Technical Support Services)RelocationSpecial VehiclesTravel (and Per Diem)Transportation (of Equipment) Tuition

Storms will reject any line which does not have one of these ODC types in this column.

Text

Item Item Description – This is a description of the ODC. It should be detailed enough for the Contracting Office and COR to understand what is proposed.

Text

Count Item Count – This is the total number of units proposed for this item.

Integer Number

Each Cost Each – This is the single unit cost of the item defined on this line. The total cost is not required since it will be computed by STORMS as follows: Count * Each * (1 + Markup percentage)

Currency

Markup Material Handling Markup Percentage – This is the percent of markup applied to this ODC and cannot exceed the rate quoted in the IDIQ for the associated Period. Contracting has identified the following ODC Types as eligible for markup:

Material(s)OEM Payments (Relocation and other)Special VehiclesTransportation (of Equipment)

STORMS will produce and error if a markup is applied to non-approved ODC types.

Percentage

G&A G&A Markup Percentage – This is percentage allowed according to corporate accounting rules for General and & Administrative expenses.

Percentage

Total Total Cost of Item – Calculated as follows:

= Count * Each * (1+ Markup) * (1+ G&A)

Currency


Submission of Transaction files into STORMS

Submitting Proposal Price Reports (PPR)

The PPR is to be submitted directly to the SharePoint “Upload Price Proposal” tool (see below illustration) in coordination with the proposal package for every Task Order RFP by each participating vendor. The PPR is automatically processed securely through the STORMS validation tool.

An error report (by line number) will be returned via email to the submitting vendor. If no errors are found, a “Valid” confirmation email will be sent to the submitted that the file is ready to be included with the vendor’s response to the RFP to the contracting office. Upon award, STORMS will only maintain the Task Order price data from the winning Vendor.


Appendix A: Abbreviations

Abbreviation DefinitionCLIN Contract Line Item NumberIDIQ Indefinite Delivery/Indefinite QuantitySER STORMS Expense ReportODC Other Direct CostOTSS Outside Technical Support ServicesPoP Period of PerformanceRFP Request for ProposalSLIN Sub Line Item Number (also known as SCLIN – Sub-Contract Line Item Number)SITE Solutions for the Information Technology EnterprisePPR Proposal Cost ReportSTORMS SITE Task Order and Requirements Management System


Appendix B: IDIQ Labor Categories

01. Hardware Maintenance Technician02. Hardware Support Assistant03. Senior Hardware Technician04. Installation Specialist05. Senior Installation Specialist06. Network Administrator07. Network Engineer08. Senior Network Engineer09. Systems Administrator10. Senior Systems Administrator11. Service Desk Specialist12. Senior Service Desk Specialist13. Field Service Technician14. Satellite Field Service Technician15. Storage Technician16. Senior Storage Technician17. Database Administrator18. Senior Database Administrator19. Systems Engineer20. Senior Systems Engineer21. Software Engineer22. Senior Software Engineer23. Project Manager24. Information Technology Analyst25. Senior Information Technology Analyst26. Information Technology Data Analyst27. IT Logistics Technician28. Senior IT Logistics Technician29. Program Manager30. Junior Program Manager31. Technical Writer32. Graphics Specialist33. VTC Operator34. Senior CND Systems Engineer35. Intermediate CND Systems Engineer


36. Junior CND Systems Engineer37. Senior CND-SP Auditor/Inspector38. Intermediate CND-SP Auditor/Inspector39. Junior CND-SP Auditor40. Senior CND-SP Infrastructure Support41. Intermediate CND-SP Infrastructure Support42. Junior CND-SP Infrastructure Support43. Senior CND-SP Analyst/Certification & Accreditation Specialist44. Intermediate CND-SP Analyst/Certification & Accreditation Specialist45. Junior CND-SP Analyst46. Senior CND-SP Incident Responder47. Intermediate CND-SP Incident Responder48. Junior CND-SP Incident Responder49. Senior Process Improvement/Process Re-Engineering Consultant50. Process Improvement Consultant51. Junior Process Improvement Analyst52. Senior Architect53. Junior Architect54. Subject Matter/Functional Expert55. Quality Assurance Manager/Specialist56. Configuration Manager/Specialist57. Senior Information Assurance/Security Assessor58. Junior Information Assurance/Security Assessor59. Senior Software Developer60. Junior Software Developer61. Senior Program Manager62. Principal System Engineer


Appendix C: IDIQ Price Groups

The 25 negotiated SITE IDIQ Price Groups are shown in the table below. Groups 1 thru 7 are for US locations.

Price GroupGroup 1Group 2Group 3Group 4Group 5Group 6Group 7BAHRAINBELGIUMCOLOMBIADJIBOUTIGERMANYIRAQ/AFGHANISTANITALYJAPAN, TokyoJAPAN, YokosukaKOREA, Camp HumphreyKOREA, Camp Red CloudKOREA, SeoulKOSOVOOKINAWAQATARTHAILANDTURKEYUNITED KINGDOM

Descriptions of the locations defined for Groups 1 thru 7 are shown on the next page. Any US location not already assigned to Price Groups 1 thru 6 will be priced at Group 7 rates.



State County Price Group* US Site/City/Metro AreaCA Los Angeles Gp 1 Los AngelesCA San Bernardino Gp 1 Fort Irwin, National Training CenterNJ Monmouth Gp 1 Fort MonmouthCO Denver Gp 2 DenverHI Honolulu Gp 2 Pearl Harbor, Camp Smith, Hickam AB, Ft. Shafter (Oahu)AK Anchorage Gp 3 Fort RichardsonAK Fairbanks North Star Gp 3 Fort WainwrightAK SE Fairbanks Gp 3 Fort GreelyAL Jefferson Gp 3 117th Intelligence Squadron, BirminghamAR Pulaski Gp 3 Little Rock AFB, North Little RockCA San Diego Gp 3 San Diego, Camp Pendleton, OceansideDC Washington Gp 3 Washington DC Metro AreaMD Anne Arundel Gp 3 Ft. MeadeMD Calvert Gp 3 Washington DC Metro AreaMD Charles Gp 3 Washington DC Metro AreaMD Frederick Gp 3 Washington DC Metro AreaMD Harford Gp 3 US Army Aberdeen Test CenterMD Montgomery Gp 3 Washington DC Metro AreaMD Prince George's Gp 3 Washington DC Metro AreaMD St Mary's Gp 3 Washington DC Metro AreaVA Alexandria Gp 3 Washington DC Metro AreaVA Arlington Gp 3 Washington DC Metro AreaVA Fairfax Gp 3 Washington DC Metro Area, Fort BelvoirVA Falls Church Gp 3 Washington DC Metro AreaVA Fauquier Gp 3 Washington DC Metro AreaVA King George Gp 3 Washington DC Metro AreaVA Loudoun Gp 3 Washington DC Metro AreaVA Stafford Gp 3 Washington DC Metro AreaWA Island Gp 3 Whidbey Island, RIPO-1, Oak HarborCA Alameda Gp 4 Camp Parks, W ARISC, DublinFL Dade Gp 4 Miami, SOUTHCOM HQFL Duval Gp 5 JacksonvilleGA Fulton Gp 5 Fort McPhersonNC Cumberland Gp 5 Ft. BraggAL Madison Gp 6 Redstone Arsenal, HuntsvilleFL Orange Gp 6 OrlandoOH Montgomery Gp 6 Wright Paterson Air Force Base, DaytonAL Calhoun Gp 7 Fort McClellanAZ Cochise Gp 7 Fort HuachucaAZ Pima Gp 7 Davis Monthan, TucsonCO El Paso Gp 7 Colorado SpringsFL Hillsborough Gp 7 Madill Air Force Base, TampaGA Clayton Gp 7 Fort Gillem, SE ARISC, Forest ParkGA Liberty Gp 7 Fort StewartGA Richmond Gp 7 Fort GordonIL Edgar Gp 7 Scott AFBIL Lake Gp 7 FT Sheridan, NC ARISCIL Rock Island Gp 7 Rock Island Arsenal

KS Geary Gp 7 Fort RileyKS Leavenworth Gp 7 Fort LeavenworthKY Christian Gp 7 Fort CampbellMA Middlesex Gp 7 Ft. Devens, Natick Soldier Center RIP-18MI Wayne Gp 7 Detroit, Naval Air Reserve Center Selfridge, Mt. ClemensMN Montgomery Gp 7 Minneapolis, RIPO-10NC Onslow Gp 7 Camp LeJeuneNE Sarpy Gp 7 Offut AFBNY Jefferson Gp 7 Fort DrumNY Oneida Gp 7 Rome Labs, ONI/DIA, RomeOK Comanche Gp 7 Fort SillPA Franklin Gp 7 Letterkenny Army Depot, Strategic Studies InstituteSC Charleston Gp 7 Charleston AFBSC Richland Gp 7 Fort JacksonTN Shelby Gp 7 Memphis, RIPO-Memphis, MillingtonTX Bell Gp 7 Fort HoodTX Bexar Gp 7 Lackland AFB, San AntonioTX El Paso Gp 7 Fort BlissUT Salt Lake Gp 7 Draper, Army National Guard, Salt Lake CityVA Albemarle Gp 7 CharlottesvilleVA Caroline Gp 7 Fort A. P. HillVA Norfolk Gp 7 NorfolkVA Prince William Gp 7 QuanticoVA Suffolk City Gp 7 SuffolkVA Virginia Beach Gp 7 Virginia Beach, NSWC, DamneckWA Pierce Gp 7 Fort Lewis

*Note: If not listed herein, the rate will be based on a Group 7 pay rate.

*Note: If not listed herein, the rate will be based on a Group 7 pay rate.

Appendix D: Approved Country Codes for STORMS

The following three-character country code abbreviations are used by STORMS for processing all transactions which include a “Country” column.

These country codes are based on ISS 3166-1 alpha-3. (Note: The only exception is Kosovo which is a two-character country code).

Country Trigraph

CodeCountry Name

ABW ArubaAFG AfghanistanAGO AngolaAIA AnguillaALA Åland IslandsALB AlbaniaAND AndorraANT Netherlands AntillesARE United Arab EmiratesARG ArgentinaARM ArmeniaASM American SamoaATA AntarcticaATF French Southern TerritoriesATG Antigua and BarbudaAUS AustraliaAUT AustriaAZE AzerbaijanBDI BurundiBEL BelgiumBEN BeninBFA Burkina FasoBGD BangladeshBGR BulgariaBHR BahrainBHS BahamasBIH Bosnia and HerzegovinaBLM Saint BarthélemyBLR BelarusBLZ Belize


BMU BermudaBOL BoliviaBRA BrazilBRB BarbadosBRN Brunei DarussalamBTN BhutanBVT Bouvet IslandBWA BotswanaCAF Central African RepublicCAN CanadaCCK Cocos (Keeling) IslandsCHE SwitzerlandCHL ChileCHN ChinaCIV Côte D'IvoireCMR CameroonCOD Congo, The Democratic Republic Of TheCOG CongoCOK Cook IslandsCOL ColombiaCOM ComorosCPV Cape VerdeCRI Costa RicaCUB CubaCXR Christmas IslandCYM Cayman IslandsCYP CyprusCZE Czech RepublicDEU GermanyDJI DjiboutiDMA DominicaDNK DenmarkDOM Dominican RepublicDZA AlgeriaECU EcuadorEGY EgyptERI EritreaESH Western SaharaESP SpainEST EstoniaETH EthiopiaFIN Finland


FJI FijiFLK Falkland Islands (Malvinas)FRA FranceFRO Faroe IslandsFSM Micronesia, Federated States OfGAB GabonGBR United KingdomGEO GeorgiaGGY GuernseyGHA GhanaGIB GibraltarGIN GuineaGLP GuadeloupeGMB GambiaGNB Guinea-BissauGNQ Equatorial GuineaGRC GreeceGRD GrenadaGRL GreenlandGTM GuatemalaGUF French GuianaGUM GuamGUY GuyanaHKG Hong KongHMD Heard and McDonald IslandsHND HondurasHRV CroatiaHTI HaitiHUN HungaryIDN IndonesiaIMN Isle of ManIND IndiaIOT British Indian Ocean TerritoryIRL IrelandIRN Iran (Islamic Republic Of)IRQ IraqISL IcelandISR IsraelITA ItalyJAM JamaicaJEY JerseyJOR Jordan


JPN JapanKAZ KazakhstanKEN KenyaKGZ KyrgyzstanKHM CambodiaKIR KiribatiKNA Saint Kitts And NevisKOR Korea, Republic ofKV KosovoKWT KuwaitLAO Lao People's Democratic RepublicLBN LebanonLBR LiberiaLBY Libyan Arab JamahiriyaLCA Saint LuciaLIE LiechtensteinLKA Sri LankaLSO LesothoLTU LithuaniaLUX LuxembourgLVA LatviaMAC MacaoMAF Saint MartinMAR MoroccoMCO MonacoMDA Moldova (the Republic of)MDG MadagascarMDV MaldivesMEX MexicoMHL Marshall IslandsMKD Macedonia, the Former Yugoslav Republic OfMLI MaliMLT MaltaMMR MyanmarMNE MontenegroMNG MongoliaMNP Northern Mariana IslandsMOZ MozambiqueMRT MauritaniaMSR MontserratMTQ MartiniqueMUS Mauritius


MWI MalawiMYS MalaysiaMYT MayotteNAM NamibiaNCL New CaledoniaNER NigerNFK Norfolk IslandNGA NigeriaNIC NicaraguaNIU NiueNLD NetherlandsNOR NorwayNPL The Federal Democratic Republic of NepalNRU NauruNZL New ZealandOMN OmanPAK PakistanPAN PanamaPCN PitcairnPER PeruPHL PhilippinesPLW PalauPNG Papua New GuineaPOL PolandPRI Puerto RicoPRK Korea, Democratic People's Republic OfPRT PortugalPRY ParaguayPSE Palestinian Territory, OccupiedPYF French PolynesiaQAT QatarREU RéunionROU RomaniaRUS Russian FederationRWA RwandaSAU Saudi ArabiaSDN SudanSEN SenegalSGP SingaporeSGS South Georgia and the South Sandwich IslandsSHN Saint HelenaSJM Svalbard And Jan Mayen


SLB Solomon IslandsSLE Sierra LeoneSLV El SalvadorSMR San MarinoSOM SomaliaSPM Saint Pierre And MiquelonSRB SerbiaSTP Sao Tome and PrincipeSUR SurinameSVK SlovakiaSVN SloveniaSWE SwedenSWZ SwazilandSYC SeychellesSYR Syrian Arab RepublicTCA Turks and Caicos IslandsTCD ChadTGO TogoTHA ThailandTJK TajikistanTKL TokelauTKM TurkmenistanTLS Timor-LesteTON TongaTTO Trinidad and TobagoTUN TunisiaTUR TurkeyTUV TuvaluTWN Taiwan, Province Of ChinaTZA Tanzania, United Republic ofUGA UgandaUKR UkraineUMI United States Minor Outlying IslandsURY UruguayUSA United StatesUZB UzbekistanVAT Holy See (Vatican City State)VCT Saint Vincent And The GrenedinesVEN VenezuelaVGB Virgin Islands, BritishVIR Virgin Islands, U.S.VNM Viet Nam


VUT VanuatuWLF Wallis and FutunaWSM SamoaYEM YemenZAF South AfricaZMB ZambiaZWE Zimbabwe


purpose to storms proposal... · web viewinclusion of instructions and process flow diagrams for...

Documents