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

XLSX spreadsheet 95 KB Posted Apr 4, 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 · Apr 4, 2024

This document is a pricing spreadsheet for a federal contract opportunity, Solicitation Number 70Z02324R77100001. The opportunity is for program management and technical support services to support all phases of the requirements generation process for the United States Coast Guard's Joint Requirements Integration and Management System (JRIMS).

The contract is a single Indefinite Delivery, Indefinite Quantity (IDIQ), Firm-Fixed-Price (FFP) contract with a base ordering period of one year and four one-year ordering periods. The Government is soliciting this requirement as a total Service Disabled, Veteran Owned (SDVO) Small Business Set-Aside. The pricing spreadsheet provides a breakdown of various labor categories, estimated hours, and not-to-exceed amounts for other direct costs and travel for the base period and each option period. The total evaluated price is $60,000.00.

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
Attachment J-2-Pricing Spreadsheet for 70Z02324R77100001 V2.1.xlsx	XLSX spreadsheet	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
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

Program Manager (Government Site Rate)	$0.00	Hour	2080	$ - 0
Project Manager (Contractor Site Rate)	$0.00	Hour	10400	$ - 0
Senior Management Analyst (Contractor Site Rate)	$0.00	Hour	624	$ - 0
Management Analyst (Contractor Site Rate)	$0.00	Hour	4160	$ - 0
Junior Management Analyst (Contractor Site Rate)	$0.00	Hour	832	$ - 0
Senior Acquisition Analyst (Contractor Site Rate)	$0.00	Hour	416	$ - 0
Acquisition Analyst (Contractor Site Rate)	$0.00	Hour	4000	$ - 0
Junior Acquisition Analyst (Contractor Site Rate)	$0.00	Hour	520	$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)	$0.00	Hour	1040	$ - 0
Technical Writer / Editor (Contractor Site Rate)	$0.00	Hour	12480	$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)	$0.00	Hour	1590	$ - 0
Senior Data Analyst (Contractor Site Rate)	$0.00	Hour	1040	$ - 0
Data Analyst (Contractor Site Rate)	$0.00	Hour	10400	$ - 0
Junior Data Analyst (Contractor Site Rate)	$0.00	Hour	1590	$ - 0
Senior Cost Analyst (Contractor Site Rate)	$0.00	Hour	416	$ - 0
Cost Analyst (Contractor Site Rate)	$0.00	Hour	4032	$ - 0
Junior Cost Analyst (Contractor Site Rate)	$0.00	Hour	520	$ - 0
Systems Engineer (Contractor Site Rate)	$0.00	Hour	1040	$ - 0
Total Labor Qty & Cost:			57180	$ - 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	57180	$ - 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

Program Manager (Government Site Rate)	$ - 0	Hour	2080	$ - 0
Project Manager (Contractor Site Rate)	$ - 0	Hour	10400	$ - 0
Senior Management Analyst (Contractor Site Rate)	$ - 0	Hour	624	$ - 0
Management Analyst (Contractor Site Rate)	$ - 0	Hour	4160	$ - 0
Junior Management Analyst (Contractor Site Rate)	$ - 0	Hour	832	$ - 0
Senior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	416	$ - 0
Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	4000	$ - 0
Junior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	520	$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	12480	$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	1590	$ - 0
Senior Data Analyst (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Data Analyst (Contractor Site Rate)	$ - 0	Hour	10400	$ - 0
Junior Data Analyst (Contractor Site Rate)	$ - 0	Hour	1590	$ - 0
Senior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	416	$ - 0
Cost Analyst (Contractor Site Rate)	$ - 0	Hour	4032	$ - 0
Junior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	520	$ - 0
Systems Engineer (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Total Labor Qty & Cost:			57180	$ - 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	57180	$ - 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

Program Manager (Government Site Rate)	$ - 0	Hour	2080	$ - 0
Project Manager (Contractor Site Rate)	$ - 0	Hour	10400	$ - 0
Senior Management Analyst (Contractor Site Rate)	$ - 0	Hour	624	$ - 0
Management Analyst (Contractor Site Rate)	$ - 0	Hour	4160	$ - 0
Junior Management Analyst (Contractor Site Rate)	$ - 0	Hour	832	$ - 0
Senior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	416	$ - 0
Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	4000	$ - 0
Junior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	520	$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	12480	$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	1590	$ - 0
Senior Data Analyst (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Data Analyst (Contractor Site Rate)	$ - 0	Hour	10400	$ - 0
Junior Data Analyst (Contractor Site Rate)	$ - 0	Hour	1590	$ - 0
Senior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	416	$ - 0
Cost Analyst (Contractor Site Rate)	$ - 0	Hour	4032	$ - 0
Junior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	520	$ - 0
Systems Engineer (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Total Labor Qty & Cost:			57180	$ - 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	57180	$ - 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

Program Manager (Government Site Rate)	$ - 0	Hour	2080	$ - 0
Project Manager (Contractor Site Rate)	$ - 0	Hour	10400	$ - 0
Senior Management Analyst (Contractor Site Rate)	$ - 0	Hour	624	$ - 0
Management Analyst (Contractor Site Rate)	$ - 0	Hour	4160	$ - 0
Junior Management Analyst (Contractor Site Rate)	$ - 0	Hour	832	$ - 0
Senior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	416	$ - 0
Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	4000	$ - 0
Junior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	520	$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	12480	$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	1590	$ - 0
Senior Data Analyst (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Data Analyst (Contractor Site Rate)	$ - 0	Hour	10400	$ - 0
Junior Data Analyst (Contractor Site Rate)	$ - 0	Hour	1590	$ - 0
Senior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	416	$ - 0
Cost Analyst (Contractor Site Rate)	$ - 0	Hour	4032	$ - 0
Junior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	520	$ - 0
Systems Engineer (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Total Labor Qty & Cost:			57180	$ - 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	57180	$ - 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

Program Manager (Government Site Rate)	$ - 0	Hour	2080	$ - 0	1040
Project Manager (Contractor Site Rate)	$ - 0	Hour	10400	$ - 0	5200
Senior Management Analyst (Contractor Site Rate)	$ - 0	Hour	624	$ - 0	312
Management Analyst (Contractor Site Rate)	$ - 0	Hour	4160	$ - 0	2080
Junior Management Analyst (Contractor Site Rate)	$ - 0	Hour	832	$ - 0	416
Senior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	416	$ - 0	208
Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	4000	$ - 0	2000
Junior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	520	$ - 0	260
Senior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0	520
Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	12480	$ - 0	6240
Junior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	1590	$ - 0	795
Senior Data Analyst (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0	520
Data Analyst (Contractor Site Rate)	$ - 0	Hour	10400	$ - 0	5200
Junior Data Analyst (Contractor Site Rate)	$ - 0	Hour	1590	$ - 0	795
Senior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	416	$ - 0	208
Cost Analyst (Contractor Site Rate)	$ - 0	Hour	4032	$ - 0	2016
Junior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	520	$ - 0	260
Systems Engineer (Contractor Site Rate)	$ - 0	Hour	1040	$ - 0
Total Labor Qty & Cost:			57180	$ - 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	57180	$ - 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

Program Manager (Government Site Rate)	$ - 0	Hour	1040	$ - 0
Project Manager (Contractor Site Rate)	$ - 0	Hour	5200	$ - 0
Senior Management Analyst (Contractor Site Rate)	$ - 0	Hour	312	$ - 0
Management Analyst (Contractor Site Rate)	$ - 0	Hour	2080	$ - 0
Junior Management Analyst (Contractor Site Rate)	$ - 0	Hour	416	$ - 0
Senior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	208	$ - 0
Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	2000	$ - 0
Junior Acquisition Analyst (Contractor Site Rate)	$ - 0	Hour	260	$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	520	$ - 0
Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	6240	$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)	$ - 0	Hour	795	$ - 0
Senior Data Analyst (Contractor Site Rate)	$ - 0	Hour	520	$ - 0
Data Analyst (Contractor Site Rate)	$ - 0	Hour	5200	$ - 0
Junior Data Analyst (Contractor Site Rate)	$ - 0	Hour	795	$ - 0
Senior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	208	$ - 0
Cost Analyst (Contractor Site Rate)	$ - 0	Hour	2016	$ - 0
Junior Cost Analyst (Contractor Site Rate)	$ - 0	Hour	260	$ - 0
Systems Engineer (Contractor Site Rate)	$ - 0	Hour	520	$ - 0
Total Labor Qty & Cost:			28590	$ - 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	28590	$ - 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%
	Base Rate	Fringe	SS/MC	Subtotal	Overhead Rate	Overhead	Subtotal	Profit Rate	Profit	Billable Rate	Bonus	401K	Disability	Health	Pension	Weekly Rates
Program Manager (Government Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Project Manager (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Senior Management Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Management Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Junior Management Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Senior Acquisition Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Acquisition Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Junior Acquisition Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Technical Writer / Editor (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Senior Data Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Data Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Junior Data Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Senior Cost Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Cost Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Junior Cost Analyst (Contractor Site Rate)	$ - 0	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	0%	$ - 0	$ - 0	0.0%	0.0%	0.0%	0.0%	0.0%	$ - 0	$ - 0
Systems Engineer (Contractor Site Rate)	$ - 0	$ - 0	$ - 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 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 the 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 Apr 4, 2024.