Attachment J-2-Pricing Spreadsheet for 70Z02324R77100001 V2.1.xlsx

XLSX spreadsheet 98 KB Posted May 3, 2024

Attached to: Joint Requirements Integration and Management System (JRIMS) Capabilities Documents for the United States Coast Guard
Solicitation number: 70Z02324R77100001
Issued by: Department of Homeland Security US Coast Guard

About this file

Written by GovTribe AI · May 3, 2024

This document is an attachment containing a pricing spreadsheet for a federal contract opportunity, Solicitation Number 70Z02324R77100001, for program management and technical support services to support all phases of the requirements generation process for the United States Coast Guard.

The pricing spreadsheet provides estimated labor hours and maximum prices for a one-year base period plus four one-year option periods and a six-month option. The labor categories include roles such as Program Manager, Project Manager, Data Scientist, and Systems Engineer. The total evaluated price for the base period and all option periods is $60,000. This solicitation is a total Service Disabled, Veteran Owned (SDVO) Small Business Set-Aside, and will be awarded as a single Indefinite Delivery, Indefinite Quantity (IDIQ), Firm-Fixed-Price contract.

View the file

Other files

File	Type	Posted
SF-30 for 70Z02324R771000010012 final.pdf	PDF	Apr 16, 2025
SF-30 for Amendment 70Z02324R771000010011 final.pdf	PDF	Jul 26, 2024
Questions and Answers for 70Z02324R77100001 as of 2024 07 23.xlsx	XLSX spreadsheet	Jul 26, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.9.pdf	PDF	Jul 12, 2024
SF-30 for 70Z02324R771000010010.pdf	PDF	Jul 12, 2024
70Z02324R77100001 Amendment 0010 Changes Summary 2024 07 11.pdf	PDF	Jul 12, 2024
SF-30 for Amendment 70Z02324R771000010009 V1.0.pdf	PDF	May 31, 2024
Questions and Answers for 70Z02324R77100001 as of 2024 05 31.xlsx	XLSX spreadsheet	May 31, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.7.pdf	PDF	May 30, 2024
70Z02324R77100001 Amendment 0008 Changes Summary 2024 05 30.pdf	PDF	May 30, 2024
SF-30 for Amendment 70Z02324R771000010008 V1.0.pdf	PDF	May 30, 2024
SF-30 for Amendment 70Z02324R771000010007 V1.0.pdf	PDF	May 8, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.6.pdf	PDF	May 8, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.5.pdf	PDF	May 3, 2024
Questions and Answers for 70Z02324R77100001 as of 2024 05 02.xlsx	XLSX spreadsheet	May 3, 2024
SF-30 for Amendment 70Z02324R771000010006 V1.0.pdf	PDF	May 3, 2024
70Z02324R77100001 Amendment 0006 Changes Summary 2024 TBD.pdf	PDF	May 3, 2024
SF-1449 for RFP 70Z02324R77100001 V1.2.pdf	PDF	May 3, 2024
Attachment J-1 - Labor Category Descriptions V2.0.pdf	PDF	Apr 26, 2024
70Z02324R77100001 Amendment 0005 Changes Summary 2024 04 26.pdf	PDF	Apr 26, 2024
SF-30 for Amendment 70Z02324R771000010005 V1.0.pdf	PDF	Apr 26, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.4.pdf	PDF	Apr 26, 2024
SF-1449 for RFP 70Z02324R77100001 V1.1.pdf	PDF	Apr 26, 2024
Questions and Answers for 70Z02324R77100001 as of 2024 04 26.xlsx	XLSX spreadsheet	Apr 26, 2024
70Z02324R77100001 Amendment 0004 Changes Summary 2024 04 15.pdf	PDF	Apr 17, 2024
Questions and Answers for 70Z02324R77100001 as of 2024 04 15.xlsx	XLSX spreadsheet	Apr 17, 2024
SF-30 for Amendment 70Z02324R771000010004 V1.0.pdf	PDF	Apr 17, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.3.pdf	PDF	Apr 17, 2024
SF-30 for Amendment 70Z02324R771000010003 V1.0.pdf	PDF	Apr 11, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.2.pdf	PDF	Apr 4, 2024
SF-30 for Amendment 70Z02324R771000010002 V1.0.pdf	PDF	Apr 4, 2024
Questions and Answers for 70Z02324R77100001 as of 2024 04 03.xlsx	XLSX spreadsheet	Apr 4, 2024
70Z02324R77100001 Amendment 0002 Changes Summary 2024 TBD.pdf	PDF	Apr 4, 2024
Attachment J-2-Pricing Spreadsheet for 70Z02324R77100001 V2.0.xlsx	XLSX spreadsheet	Apr 4, 2024
Questions and Answers for 70Z02324R77100001 as of 2024 03 19.xlsx	XLSX spreadsheet	Mar 20, 2024
70Z02324R77100001 Amendment 0001 Changes Summary 2024 03 20.pdf	PDF	Mar 20, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.1.docx	DOCX document	Mar 20, 2024
70Z02324R77100001 Amendment 0001 Changes Summary 2024 03 19.docx	DOCX document	Mar 20, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.1.pdf	PDF	Mar 20, 2024
SF-30 for Amendment 70Z02324R771000010001 final V1.0.pdf	PDF	Mar 20, 2024
Attachment 1 - Past Performance Questionnaire - 70Z02324R77100001.pdf	PDF	Mar 15, 2024
Attachment J-1 - Labor Category Descriptions V1.0.pdf	PDF	Mar 15, 2024
Attachment J-2-Pricing Spreadsheet for 70Z02324R77100001 draft V1.0.xlsx	XLSX spreadsheet	Mar 15, 2024
SF-1449 for 70Z02324R77100001 final V1.0.pdf	PDF	Mar 15, 2024
Addendum 1 - Section B to M for 70Z02324R77100001 V3.0.pdf	PDF	Mar 15, 2024

Show all 45

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.

Base Period

Follow instruction in "Labor Categories" Tab. DO NOT EDIT THE ESTIMATED HOURS.
Pricing Worksheet
Category	Fully Loaded Rate	Unit	Qty	Cost

IDIQ Program Manager (Government Site)	$0.00	Hour	2080	$ - 0
Senior Program Manager	$0.00	Hour	2000	$ - 0
Journeyman Program Manager	$0.00	Hour	2500	$ - 0
Junior Program Manager	$0.00	Hour	3000	$ - 0
Senior Project Manager	$0.00	Hour	2000	$ - 0
Journeyman Project Manager	$0.00	Hour	3000	$ - 0
Junior Project Manager	$0.00	Hour	3000	$ - 0
Senior Management Analyst	$0.00	Hour	900	$ - 0
Journeyman Management Analyst	$0.00	Hour	3000	$ - 0
Junior Management Analyst	$0.00	Hour	3000	$ - 0
Senior Data Scientist	$0.00	Hour	900	$ - 0
Journeyman Data Scientist	$0.00	Hour	2500	$ - 0
Junior Data Scientist	$0.00	Hour	2500	$ - 0
Senior Technical Writer / Editor	$0.00	Hour	2000	$ - 0
Journeyman Technical Writer / Editor	$0.00	Hour	2500	$ - 0
Junior Technical Writer / Editor	$0.00	Hour	3000	$ - 0
Senior Data Analyst	$0.00	Hour	800	$ - 0
Journeyman Data Analyst	$0.00	Hour	1040	$ - 0
Junior Data Analyst	$0.00	Hour	1040	$ - 0
Senior Cost Analyst	$0.00	Hour	800	$ - 0
Journeyman Cost Analyst	$0.00	Hour	900	$ - 0
Junior Cost Analyst	$0.00	Hour	1000	$ - 0
Subject Matter Expert Functional / Technical	$0.00	Hour	1000	$ - 0
Senior Systems Engineer	$0.00	Hour	800	$ - 0
Journeyman Systems Engineer	$0.00	Hour	1040	$ - 0
Junior Systems Engineer	$0.00	Hour	1040	$ - 0
Total Labor Qty & Cost:			47340	$ - 0

Travel NA Dollar NTE $ 10,000.00

Other Direct Costs (ODCs)	Rate	Unit	Qty 1	Cost 1
Mileage	$ - 0	Mile	0	$ - 0
Vehicle Rental	$ - 0	Daily	0	$ - 0
Airport Parking	$ - 0	Daily	0	$ - 0
Conference Facilities	$ - 0	Daily	0	$ - 0
USCG HQ Parking	$ - 0	Daily	0	$ - 0
Report Reproduction	$ - 0	Page	0	$ - 0
Total ODC Qty & Cost:			0	$ - 0
% of Total ODC			0%	0%

Travel/ Transportation	Rate	Unit	Qty 1	Cost 1
Per Diem-Washington, D.C.	$ - 0	Daily	0	$ - 0
Per Diem- City #2	$ - 0	Daily	0	$ - 0
Airfare (Vendor/ Washington, DC)	$ - 0	Round Trip	0	$ - 0
Airfare (Vendor/ City #2)	$ - 0	Round Trip	0	$ - 0
Rent Car Gas	$ - 0	Gallon	0	$ - 0
Total Travel & Transportation Qty & Cost:			0	$ - 0
% of Total Trav / Transportation			0%	0%

	Subtotal ODCs & Travel/Transportation		$ - 0
	General & Administrative Surcharge
on ODC & Travel/Transportation	10%	$ - 0
	Grand Total Project Qty & Cost	47340	$ - 0
	% of Grand Total	ERROR:#REF!	0%

Maximum Price for Base Period $ 10,000.00

&"Times New Roman,Bold"&14Draft Independent Government Estimate for (Specify Program Office) (Specify Project)

COTR Name COTR Office Page &P of &N &D

Period 1

Follow instruction in "Labor Categories" Tab. DO NOT EDIT THE ESTIMATED HOURS.
Pricing Worksheet
Category	Fully Loaded Rate	Unit	Qty	Cost

IDIQ Program Manager (Government Site)	$ - 0	Hour	2080	$ - 0
Senior Program Manager	$ - 0	Hour	2000	$ - 0
Journeyman Program Manager	$ - 0	Hour	2500	$ - 0
Junior Program Manager	$ - 0	Hour	3000	$ - 0
Senior Project Manager	$ - 0	Hour	2000	$ - 0
Journeyman Project Manager	$ - 0	Hour	3000	$ - 0
Junior Project Manager	$ - 0	Hour	3000	$ - 0
Senior Management Analyst	$ - 0	Hour	900	$ - 0
Journeyman Management Analyst	$ - 0	Hour	3000	$ - 0
Junior Management Analyst	$ - 0	Hour	3000	$ - 0
Senior Data Scientist	$ - 0	Hour	900	$ - 0
Journeyman Data Scientist	$ - 0	Hour	2500	$ - 0
Junior Data Scientist	$ - 0	Hour	2500	$ - 0
Senior Technical Writer / Editor	$ - 0	Hour	2000	$ - 0
Journeyman Technical Writer / Editor	$ - 0	Hour	2500	$ - 0
Junior Technical Writer / Editor	$ - 0	Hour	3000	$ - 0
Senior Data Analyst	$ - 0	Hour	800	$ - 0
Journeyman Data Analyst	$ - 0	Hour	1040	$ - 0
Junior Data Analyst	$ - 0	Hour	1040	$ - 0
Senior Cost Analyst	$ - 0	Hour	800	$ - 0
Journeyman Cost Analyst	$ - 0	Hour	900	$ - 0
Junior Cost Analyst	$ - 0	Hour	1000	$ - 0
Subject Matter Expert Functional / Technical	$ - 0	Hour	1000	$ - 0
Senior Systems Engineer	$ - 0	Hour	800	$ - 0
Journeyman Systems Engineer	$ - 0	Hour	1040	$ - 0
Junior Systems Engineer	$ - 0	Hour	1040	$ - 0
Total Labor Qty & Cost:			47340	$ - 0

Travel NA Dollar NTE $ 10,000.00

Other Direct Costs (ODCs)	Rate	Unit	Qty 1	Cost 1
Mileage	$ - 0	Mile	0	$ - 0
Vehicle Rental	$ - 0	Daily	0	$ - 0
Airport Parking	$ - 0	Daily	0	$ - 0
Conference Facilities	$ - 0	Daily	0	$ - 0
USCG HQ Parking	$ - 0	Daily	0	$ - 0
Report Reproduction	$ - 0	Page	0	$ - 0
Total ODC Qty & Cost:			0	$ - 0
% of Total ODC			0%	0%

Travel/ Transportation	Rate	Unit	Qty 1	Cost 1
Per Diem-Washington, D.C.	$ - 0	Daily	0	$ - 0
Per Diem- City #2	$ - 0	Daily	0	$ - 0
Airfare (Vendor/ Washington, DC)	$ - 0	Round Trip	0	$ - 0
Airfare (Vendor/ City #2)	$ - 0	Round Trip	0	$ - 0
Rent Car Gas	$ - 0	Gallon	0	$ - 0
Total Travel & Transportation Qty & Cost:			0	$ - 0
% of Total Trav / Transportation			0%	0%

	Subtotal ODCs & Travel/Transportation		$ - 0
	General & Administrative Surcharge
on ODC & Travel/Transportation	10%	$ - 0
	Grand Total Project Qty & Cost	47340	$ - 0
	% of Grand Total	ERROR:#REF!	0%

Maximum Price for Period One $ 10,000.00

(Specify Project)

COTR Office Page &P of &N &D

Period 2

Follow instruction in "Labor Categories" Tab. DO NOT EDIT THE ESTIMATED HOURS.
Pricing Worksheet
Category	Fully Loaded Rate	Unit	Qty	Cost

IDIQ Program Manager (Government Site)	$ - 0	Hour	2080	$ - 0
Senior Program Manager	$ - 0	Hour	2000	$ - 0
Journeyman Program Manager	$ - 0	Hour	2500	$ - 0
Junior Program Manager	$ - 0	Hour	3000	$ - 0
Senior Project Manager	$ - 0	Hour	2000	$ - 0
Journeyman Project Manager	$ - 0	Hour	3000	$ - 0
Junior Project Manager	$ - 0	Hour	3000	$ - 0
Senior Management Analyst	$ - 0	Hour	900	$ - 0
Journeyman Management Analyst	$ - 0	Hour	3000	$ - 0
Junior Management Analyst	$ - 0	Hour	3000	$ - 0
Senior Data Scientist	$ - 0	Hour	900	$ - 0
Journeyman Data Scientist	$ - 0	Hour	2500	$ - 0
Junior Data Scientist	$ - 0	Hour	2500	$ - 0
Senior Technical Writer / Editor	$ - 0	Hour	2000	$ - 0
Journeyman Technical Writer / Editor	$ - 0	Hour	2500	$ - 0
Junior Technical Writer / Editor	$ - 0	Hour	3000	$ - 0
Senior Data Analyst	$ - 0	Hour	800	$ - 0
Journeyman Data Analyst	$ - 0	Hour	1040	$ - 0
Junior Data Analyst	$ - 0	Hour	1040	$ - 0
Senior Cost Analyst	$ - 0	Hour	800	$ - 0
Journeyman Cost Analyst	$ - 0	Hour	900	$ - 0
Junior Cost Analyst	$ - 0	Hour	1000	$ - 0
Subject Matter Expert Functional / Technical	$ - 0	Hour	1000	$ - 0
Senior Systems Engineer	$ - 0	Hour	800	$ - 0
Journeyman Systems Engineer	$ - 0	Hour	1040	$ - 0
Junior Systems Engineer	$ - 0	Hour	1040	$ - 0
Total Labor Qty & Cost:			47340	$ - 0

Travel NA Dollar NTE $ 10,000.00

Other Direct Costs (ODCs)	Rate	Unit	Qty 1	Cost 1
Mileage	$ - 0	Mile	0	$ - 0
Vehicle Rental	$ - 0	Daily	0	$ - 0
Airport Parking	$ - 0	Daily	0	$ - 0
Conference Facilities	$ - 0	Daily	0	$ - 0
USCG HQ Parking	$ - 0	Daily	0	$ - 0
Report Reproduction	$ - 0	Page	0	$ - 0
Total ODC Qty & Cost:			0	$ - 0
% of Total ODC			0%	0%

Travel/ Transportation	Rate	Unit	Qty 1	Cost 1
Per Diem-Washington, D.C.	$ - 0	Daily	0	$ - 0
Per Diem- City #2	$ - 0	Daily	0	$ - 0
Airfare (Vendor/ Washington, DC)	$ - 0	Round Trip	0	$ - 0
Airfare (Vendor/ City #2)	$ - 0	Round Trip	0	$ - 0
Rent Car Gas	$ - 0	Gallon	0	$ - 0
Total Travel & Transportation Qty & Cost:			0	$ - 0
% of Total Trav / Transportation			0%	0%

	Subtotal ODCs & Travel/Transportation		$ - 0
	General & Administrative Surcharge
on ODC & Travel/Transportation	10%	$ - 0
	Grand Total Project Qty & Cost	47340	$ - 0
	% of Grand Total	ERROR:#REF!	0%

Maximum Price for Period Two $ 10,000.00

(Specify Project)

COTR Office Page &P of &N &D

Period 3

Follow instruction in "Labor Categories" Tab. DO NOT EDIT THE ESTIMATED HOURS.
Pricing Worksheet
Category	Fully Loaded Rate	Unit	Qty	Cost

IDIQ Program Manager (Government Site)	$ - 0	Hour	2080	$ - 0
Senior Program Manager	$ - 0	Hour	2000	$ - 0
Journeyman Program Manager	$ - 0	Hour	2500	$ - 0
Junior Program Manager	$ - 0	Hour	3000	$ - 0
Senior Project Manager	$ - 0	Hour	2000	$ - 0
Journeyman Project Manager	$ - 0	Hour	3000	$ - 0
Junior Project Manager	$ - 0	Hour	3000	$ - 0
Senior Management Analyst	$ - 0	Hour	900	$ - 0
Journeyman Management Analyst	$ - 0	Hour	3000	$ - 0
Junior Management Analyst	$ - 0	Hour	3000	$ - 0
Senior Data Scientist	$ - 0	Hour	900	$ - 0
Journeyman Data Scientist	$ - 0	Hour	2500	$ - 0
Junior Data Scientist	$ - 0	Hour	2500	$ - 0
Senior Technical Writer / Editor	$ - 0	Hour	2000	$ - 0
Journeyman Technical Writer / Editor	$ - 0	Hour	2500	$ - 0
Junior Technical Writer / Editor	$ - 0	Hour	3000	$ - 0
Senior Data Analyst	$ - 0	Hour	800	$ - 0
Journeyman Data Analyst	$ - 0	Hour	1040	$ - 0
Junior Data Analyst	$ - 0	Hour	1040	$ - 0
Senior Cost Analyst	$ - 0	Hour	800	$ - 0
Journeyman Cost Analyst	$ - 0	Hour	900	$ - 0
Junior Cost Analyst	$ - 0	Hour	1000	$ - 0
Subject Matter Expert Functional / Technical	$ - 0	Hour	1000	$ - 0
Senior Systems Engineer	$ - 0	Hour	800	$ - 0
Journeyman Systems Engineer	$ - 0	Hour	1040	$ - 0
Junior Systems Engineer	$ - 0	Hour	1040	$ - 0
Total Labor Qty & Cost:			47340	$ - 0

Travel 0.00% Dollar NTE $ 10,000.00

Other Direct Costs (ODCs)	Rate	Unit	Qty 1	Cost 1
Mileage	$ - 0	Mile	0	$ - 0
Vehicle Rental	$ - 0	Daily	0	$ - 0
Airport Parking	$ - 0	Daily	0	$ - 0
Conference Facilities	$ - 0	Daily	0	$ - 0
USCG HQ Parking	$ - 0	Daily	0	$ - 0
Report Reproduction	$ - 0	Page	0	$ - 0
Total ODC Qty & Cost:			0	$ - 0
% of Total ODC			0%	0%

Travel/ Transportation	Rate	Unit	Qty 1	Cost 1
Per Diem-Washington, D.C.	$ - 0	Daily	0	$ - 0
Per Diem- City #2	$ - 0	Daily	0	$ - 0
Airfare (Vendor/ Washington, DC)	$ - 0	Round Trip	0	$ - 0
Airfare (Vendor/ City #2)	$ - 0	Round Trip	0	$ - 0
Rent Car Gas	$ - 0	Gallon	0	$ - 0
Total Travel & Transportation Qty & Cost:			0	$ - 0
% of Total Trav / Transportation			0%	0%

	Subtotal ODCs & Travel/Transportation		$ - 0
	General & Administrative Surcharge
on ODC & Travel/Transportation	10%	$ - 0
	Grand Total Project Qty & Cost	47340	$ - 0
	% of Grand Total	ERROR:#REF!	0%

Maximum Price for Period Three $ 10,000.00

(Specify Project)

COTR Office Page &P of &N &D

Period 4

Follow instruction in "Labor Categories" Tab. DO NOT EDIT THE ESTIMATED HOURS.
Pricing Worksheet
Category	Fully Loaded Rate	Unit	Qty	Cost

IDIQ Program Manager (Government Site)	$ - 0	Hour	2080	$ - 0
Senior Program Manager	$ - 0	Hour	2000	$ - 0
Journeyman Program Manager	$ - 0	Hour	2500	$ - 0
Junior Program Manager	$ - 0	Hour	3000	$ - 0
Senior Project Manager	$ - 0	Hour	2000	$ - 0
Journeyman Project Manager	$ - 0	Hour	3000	$ - 0
Junior Project Manager	$ - 0	Hour	3000	$ - 0
Senior Management Analyst	$ - 0	Hour	900	$ - 0
Journeyman Management Analyst	$ - 0	Hour	3000	$ - 0
Junior Management Analyst	$ - 0	Hour	3000	$ - 0
Senior Data Scientist	$ - 0	Hour	900	$ - 0
Journeyman Data Scientist	$ - 0	Hour	2500	$ - 0
Junior Data Scientist	$ - 0	Hour	2500	$ - 0
Senior Technical Writer / Editor	$ - 0	Hour	2000	$ - 0
Journeyman Technical Writer / Editor	$ - 0	Hour	2500	$ - 0
Junior Technical Writer / Editor	$ - 0	Hour	3000	$ - 0
Senior Data Analyst	$ - 0	Hour	800	$ - 0
Journeyman Data Analyst	$ - 0	Hour	1040	$ - 0
Junior Data Analyst	$ - 0	Hour	1040	$ - 0
Senior Cost Analyst	$ - 0	Hour	800	$ - 0
Journeyman Cost Analyst	$ - 0	Hour	900	$ - 0
Junior Cost Analyst	$ - 0	Hour	1000	$ - 0
Subject Matter Expert Functional / Technical	$ - 0	Hour	1000	$ - 0
Senior Systems Engineer	$ - 0	Hour	800	$ - 0
Journeyman Systems Engineer	$ - 0	Hour	1040	$ - 0
Junior Systems Engineer	$ - 0	Hour	1040	$ - 0
Total Labor Qty & Cost:			47340	$ - 0

Travel 0.00% Dollar NTE $ 10,000.00

Other Direct Costs (ODCs)	Rate	Unit	Qty 1	Cost 1
Mileage	$ - 0	Mile	0	$ - 0
Vehicle Rental	$ - 0	Daily	0	$ - 0
Airport Parking	$ - 0	Daily	0	$ - 0
Conference Facilities	$ - 0	Daily	0	$ - 0
USCG HQ Parking	$ - 0	Daily	0	$ - 0
Report Reproduction	$ - 0	Page	0	$ - 0
Total ODC Qty & Cost:			0	$ - 0
% of Total ODC			0%	0%

Travel/ Transportation	Rate	Unit	Qty 1	Cost 1
Per Diem-Washington, D.C.	$ - 0	Daily	0	$ - 0
Per Diem- City #2	$ - 0	Daily	0	$ - 0
Airfare (Vendor/ Washington, DC)	$ - 0	Round Trip	0	$ - 0
Airfare (Vendor/ City #2)	$ - 0	Round Trip	0	$ - 0
Rent Car Gas	$ - 0	Gallon	0	$ - 0
Total Travel & Transportation Qty & Cost:			0	$ - 0
% of Total Trav / Transportation			0%	0%

	Subtotal ODCs & Travel/Transportation		$ - 0
	General & Administrative Surcharge
on ODC & Travel/Transportation	10%	$ - 0
	Grand Total Project Qty & Cost	47340	$ - 0
	% of Grand Total	ERROR:#REF!	0%

Maximum Price for Period Four $ 10,000.00

(Specify Project)

COTR Office Page &P of &N &D

6-month Option

Follow instruction in "Labor Categories" Tab. DO NOT EDIT THE ESTIMATED HOURS.
Pricing Worksheet
Category	Fully Loaded Rate	Unit	Qty	Cost

IDIQ Program Manager (Government Site)	$ - 0	Hour	1040	$ - 0
Senior Program Manager	$ - 0	Hour	1000	$ - 0
Journeyman Program Manager	$ - 0	Hour	1250	$ - 0
Junior Program Manager	$ - 0	Hour	1500	$ - 0
Senior Project Manager	$ - 0	Hour	1000	$ - 0
Journeyman Project Manager	$ - 0	Hour	1500	$ - 0
Junior Project Manager	$ - 0	Hour	1500	$ - 0
Senior Management Analyst	$ - 0	Hour	450	$ - 0
Journeyman Management Analyst	$ - 0	Hour	1500	$ - 0
Junior Management Analyst	$ - 0	Hour	1500	$ - 0
Senior Data Scientist	$ - 0	Hour	450	$ - 0
Journeyman Data Scientist	$ - 0	Hour	1250	$ - 0
Junior Data Scientist	$ - 0	Hour	1250	$ - 0
Senior Technical Writer / Editor	$ - 0	Hour	1000	$ - 0
Journeyman Technical Writer / Editor	$ - 0	Hour	1250	$ - 0
Junior Technical Writer / Editor	$ - 0	Hour	1500	$ - 0
Senior Data Analyst	$ - 0	Hour	400	$ - 0
Journeyman Data Analyst	$ - 0	Hour	520	$ - 0
Junior Data Analyst	$ - 0	Hour	520	$ - 0
Senior Cost Analyst	$ - 0	Hour	400	$ - 0
Journeyman Cost Analyst	$ - 0	Hour	450	$ - 0
Junior Cost Analyst	$ - 0	Hour	500	$ - 0
Subject Matter Expert Functional / Technical	$ - 0	Hour	500	$ - 0
Senior Systems Engineer	$ - 0	Hour	400	$ - 0
Journeyman Systems Engineer	$ - 0	Hour	520	$ - 0
Junior Systems Engineer	$ - 0	Hour	520	$ - 0
Total Labor Qty & Cost:			23670	$ - 0

Travel NA Dollar NTE $ 10,000.00

Other Direct Costs (ODCs)	Rate	Unit	Qty 1	Cost 1
Mileage	$ - 0	Mile	0	$ - 0
Vehicle Rental	$ - 0	Daily	0	$ - 0
Airport Parking	$ - 0	Daily	0	$ - 0
Conference Facilities	$ - 0	Daily	0	$ - 0
USCG HQ Parking	$ - 0	Daily	0	$ - 0
Report Reproduction	$ - 0	Page	0	$ - 0
Total ODC Qty & Cost:			0	$ - 0
% of Total ODC			0%	0%

Travel/ Transportation	Rate	Unit	Qty 1	Cost 1
Per Diem-Washington, D.C.	$ - 0	Daily	0	$ - 0
Per Diem- City #2	$ - 0	Daily	0	$ - 0
Airfare (Vendor/ Washington, DC)	$ - 0	Round Trip	0	$ - 0
Airfare (Vendor/ City #2)	$ - 0	Round Trip	0	$ - 0
Rent Car Gas	$ - 0	Gallon	0	$ - 0
Total Travel & Transportation Qty & Cost:			0	$ - 0
% of Total Trav / Transportation			0%	0%

	Subtotal ODCs & Travel/Transportation		$ - 0
	General & Administrative Surcharge
on ODC & Travel/Transportation	10%	$ - 0
	Grand Total Project Qty & Cost	23670	$ - 0
	% of Grand Total	ERROR:#REF!	0%

Maximum Price for 6-month Option $ 10,000.00

(Specify Project)

COTR Office Page &P of &N &D

Labor Categories

		Overhead Rate =		0%
		Profit Rate =		0%
Government's LCAT	Offeror's LCAT	Base Rate	Fringe	Subtotal	Overhead Rate	Overhead	Subtotal	Profit Rate	Profit	Billable Rate	Bonus	401K	Disability	Health	Pension	Weekly Rates
IDIQ Program Manager (Government Site)		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Senior Program Manager		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Journeyman Program Manager		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Junior Program Manager		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Senior Project Manager		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Journeyman Project Manager		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Junior Project Manager		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Senior Management Analyst		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Journeyman Management Analyst		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Junior Management Analyst		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Senior Data Scientist		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Journeyman Data Scientist		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Junior Data Scientist		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Senior Technical Writer / Editor		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Journeyman Technical Writer / Editor		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Junior Technical Writer / Editor		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Senior Data Analyst		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Journeyman Data Analyst		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Junior Data Analyst		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Senior Cost Analyst		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Journeyman Cost Analyst		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Junior Cost Analyst		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Subject Matter Expert Functional / Technical		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Senior Systems Engineer		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Journeyman Systems Engineer		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Junior Systems Engineer		$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0
Instructions:
DO NOT EDIT THE ESTIMATED HOURS.
Fill in Offer's LCAT if different from Government's LCAT.
Fill in the base rate under Column C for each labor category.
Fill in the Overhead Rate in Block E2 and the Profit Rate in Block E3.
Fill in the percentages on Columns N though S for Fringe Benefits. The rest of the document will fill in.
If you do not want to provide all the requested information, you may fill in the Billable Rates in Column L only.
The Option Periods build in a 2% increase from year to year. If you want to change that, you will have to edit the formulas on your own.
Save as Excel Workbook (*.xlsx)

Totals

Pricing Summary
Period	Price
Base Period	$ 10,000.00
Period 1	$ 10,000.00
Period 2	$ 10,000.00
Period 3	$ 10,000.00
Period 4	$ 10,000.00
6-month Option	$ 10,000.00
Total Evaluated Price	$ 60,000.00

File details come from the government source that posted it. Updated May 3, 2024.