36A77619Q0091-018.xls

XLS spreadsheet 119 KB Posted Apr 16, 2019

Attached to: Phoenix OPC IOTA IDIQ CO: Heidi Gallaher
Solicitation number: 36A77619Q0091
Issued by: Department of Veterans Affairs Office of Information Service Center

About this file

From the source

36A77619Q0091 ATTACHMENT P - Activation TEP Calculation Workbook.xls

View the file

Other files

File	Type	Posted
36A77619Q0091-0001000.docx	DOCX document	May 17, 2019
36A77619Q0091-0001001.docx	DOCX document	May 17, 2019
36A77619Q0091-0001002.docx	DOCX document	May 17, 2019
36A77619Q0091-004.doc	DOC document	Apr 16, 2019
36A77619Q0091-012.docx	DOCX document	Apr 16, 2019
36A77619Q0091-005.xlsx	XLSX spreadsheet	Apr 16, 2019
36A77619Q0091-008.pdf	PDF	Apr 16, 2019
36A77619Q0091-009.docx	DOCX document	Apr 16, 2019
36A77619Q0091-010.docx	DOCX document	Apr 16, 2019
36A77619Q0091-006.pdf	PDF	Apr 16, 2019
36A77619Q0091-007.pdf	PDF	Apr 16, 2019
36A77619Q0091-003.docx	DOCX document	Apr 16, 2019
36A77619Q0091-015.pdf	PDF	Apr 16, 2019
36A77619Q0091-002.docx	DOCX document	Apr 16, 2019
36A77619Q0091-011.pdf	PDF	Apr 16, 2019
36A77619Q0091-017.docx	DOCX document	Apr 16, 2019
36A77619Q0091-016.docx	DOCX document	Apr 16, 2019
36A77619Q0091-014.pdf	PDF	Apr 16, 2019
36A77619Q0091-013.xlsx	XLSX spreadsheet	Apr 16, 2019
36A77619Q0091-000.docx	DOCX document	Feb 13, 2019
36A77619Q0091-001.docx	DOCX document	Feb 13, 2019

Show all 21

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

1-Instructions

Instructions for Activation TEP Calculation workbook:

a. Tab 2 “Labor Rate Table”

- Each offeror shall complete column B (ORANGE cells) to identify the title of the offeror’s labor category which matches the Government’s Functional Area.

- The offeror will then provide 5 years of fully burdened rates for each of their proposed labor categories in columns C, D, E, F, and G (YELLOW cells).

- Every Government Functional Area must have a proposed Contractor Provided Labor Category and 5 years of rates or the offeror will be considered nonresponsive.

- The same Contractor Provided Labor Category may be used for multiple Government Functional Areas (the rates must match).

These labor rates will be locked into the subsequent 5-year IDIQ for the awardee.

- This labor rate table will become part of the IDIQ contract for the awardee and will be used to price all future Task Orders under the IDIQ.

b. Tab 3 “TO 1 Price Proposal”

- Each offeror will quote the number of labor hours needed for each Contractor Provided Labor Category for each year in order to meet the requirements of the Task

Order 1 PWS in Columns D, G, and J (all BLUE cells).

- All labor categories from the Tab 1, “Labor Rate Table,” are available to use on the “TO 1 Price Proposal” Tab, but not all may be required.

- If the offeror does not require a labor category to complete Task Order 1, the respective hours cell should be left at “0”. Cell L30 will auto populate based

on the completion of the “4-TO 1 Travel” tab.

- Task Order 1 will be awarded as a Firm Fixed Price

c. Tab 4 “TO 1 Travel”

- Under the “TO 1 Travel” tab, the offeror will complete rows 3 to 30 (not all rows may be needed) to identify all trips needed to meet the requirements of Task Order 1.

- If the exact same trip will be made multiple times (same location, number of travelers, number rental cars, and number of days/nights) the column D “Total Trips Per

TO” should represent the total amount of times that trip is required.

- When location, number of travelers, number rental cars, and number of days/nights varies, a new row should be created.

- Travel will be awarded as a Firm Fixed Price

d. Tab 5 “All Other TO Price Estimate”

- There is no action required of the offeror under this tab.

- This tab takes the information provided on the previous tabs and applies it to a Government estimate of hours needed for each labor category for each year of the IDIQ

outside of Task Order 1.

- This will better help the Government forecast the potential price of the IDIQ Tasks that are not captured under Task Order 1.

- This information is FOR EVALUATION PURPOSES ONLY.

- The actual hours required and labor category mix for any future task outside of Task Order 1 is unknown at this time and will be proposed by the awardee, negotiated,

and awarded on a Task Order basis.

e. Tab 6 “TEP Rollup”

- There is no action required of the offeror under the “TEP Rollup” tab.

- This tab totals the amounts quoted by the offeror for Task Order 1 and the estimate calculated by the Government (based on the proposed labor rates) for all other

Task Orders to determine a total evaluated price (TEP). This will be the price used for evaluation purposes in awarding the IDIQ and Task Order 1.

2-Labor Rate Table

Government	Contractor Provided	Year	Year	Year	Year	Year
Labor Category	Labor Category	1	2	3	4	5
*Project Manager
*Senior Transition Planner
*Senior Designer
*Medical Equipment Planner
*Project Director
Assistant Project Manager
Clerical Assistant
Designer
Data Management
Quality Control
Planner
Biomedical Equipment Technician
Training Coordinator
Scheduler
IT Planner
Stratcom Coordinator
Auto CAD/Revit Operator
Senior Acquisition Specialist
Acquisition Specialist
Low Voltage Communications
Warehouse Manager
Laborer
Installer
Mover
*Key Personnel

3-TO 1 Price Proposal

Contractor Provided Labor Category	Year 1 Rate	Year 1 Hours	Year 1 Total	Year 2 Rate	Year 2 Hours	Year 2 Total	Year 3 Rate	Year 3 Hours (6 Months)	Year 3 Total (6 Months)
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0
0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	TO 1 LABOR TOTAL
			$ - 0			$ - 0			$ - 0	$ - 0
										$ - 0
										$ - 0

4-TO 1 Travel

Starting Location	Trip Location	Total Trips Per TO	Total Travelers Per Trip	Total Rental Cars Per Trip	Total Days Per Trip	Total Nights Per Trip	Estimated Airfare	Lodging Rate Per Day	Estimated Rental Car Rate Per Day	Per Diem Rate Per Day	Additional Costs	Total Cost
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
												$ - 0
										TOTAL TO 0001		$ - 0

5-All Other TO Price Estimate

FOR EVALUATION PURPOSES ONLY								FOR EVALUATION PURPOSES ONLY
Contractor Provided Labor Category	Year 1 Rate	Year 1 Est Hours	Year 1 Total	Year 2 Rate	Year 2 Est Hours	Year 2 Total	Year 3 Rate	Year 3 Est Hours	Year 3 Total	Year 4 Rate	Year 4 Est Hours	Year 4 Total	Year 5 Rate	Year 5 Est Hours	Year 5 Total
0	$ - 0	700	$ - 0	$ - 0	700	$ - 0	$ - 0	700	$ - 0	$ - 0	700	$ - 0	$ - 0	700	$ - 0
0	$ - 0	75	$ - 0	$ - 0	75	$ - 0	$ - 0	75	$ - 0	$ - 0	75	$ - 0	$ - 0	75	$ - 0
0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0
0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0
0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0
0	$ - 0	300	$ - 0	$ - 0	300	$ - 0	$ - 0	300	$ - 0	$ - 0	300	$ - 0	$ - 0	300	$ - 0
0	$ - 0	325	$ - 0	$ - 0	325	$ - 0	$ - 0	325	$ - 0	$ - 0	325	$ - 0	$ - 0	325	$ - 0
0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0
0	$ - 0	80	$ - 0	$ - 0	80	$ - 0	$ - 0	80	$ - 0	$ - 0	80	$ - 0	$ - 0	80	$ - 0
0	$ - 0	350	$ - 0	$ - 0	350	$ - 0	$ - 0	350	$ - 0	$ - 0	350	$ - 0	$ - 0	350	$ - 0
0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0
0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0
0	$ - 0	80	$ - 0	$ - 0	80	$ - 0	$ - 0	80	$ - 0	$ - 0	80	$ - 0	$ - 0	80	$ - 0
0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0	$ - 0	200	$ - 0
0	$ - 0	25	$ - 0	$ - 0	25	$ - 0	$ - 0	25	$ - 0	$ - 0	25	$ - 0	$ - 0	25	$ - 0
0	$ - 0	25	$ - 0	$ - 0	25	$ - 0	$ - 0	25	$ - 0	$ - 0	25	$ - 0	$ - 0	25	$ - 0
0	$ - 0	50	$ - 0	$ - 0	50	$ - 0	$ - 0	50	$ - 0	$ - 0	50	$ - 0	$ - 0	50	$ - 0
0	$ - 0	250	$ - 0	$ - 0	250	$ - 0	$ - 0	250	$ - 0	$ - 0	250	$ - 0	$ - 0	250	$ - 0
0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0
0	$ - 0	100	$ - 0	$ - 0	100	$ - 0	$ - 0	100	$ - 0	$ - 0	100	$ - 0	$ - 0	100	$ - 0
0	$ - 0	250	$ - 0	$ - 0	250	$ - 0	$ - 0	250	$ - 0	$ - 0	250	$ - 0	$ - 0	250	$ - 0
0	$ - 0	100	$ - 0	$ - 0	100	$ - 0	$ - 0	100	$ - 0	$ - 0	100	$ - 0	$ - 0	100	$ - 0
0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0	$ - 0	150	$ - 0
0	$ - 0	100	$ - 0	$ - 0	100	$ - 0	$ - 0	100	$ - 0	$ - 0	100	$ - 0	$ - 0	100	$ - 0
			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0

6-TEP Rollup

TO 1 Total	$ - 0
Other TO Estimate	$ - 0
Total Evaluated Price	$ - 0

File details come from the government source that posted it.