Att._4_-_Pricing_Worksheet.xlsx

XLSX spreadsheet 158 KB Posted

Attached to
Capabilities Related Documents and Studies (CG-7)
Solicitation number
70Z02318RMDW00100
Issued by

About this file

This solicitation requests proposals for capabilities related documents and studies support services. The United States Coast Guard Office of Requirements and Analysis requires program management, technical support, and assistance developing Capability Analysis Reports, Mission Needs Statements, Concepts of Operations, Operational Requirements Documents, and Operational Policy Developments. The solicitation is a set-aside for Service Disabled Veteran Owned Small Businesses with average annual receipts under $15 million. The Coast Guard intends to award a single Indefinite Delivery Indefinite Quantity contract comprising a one-year base period and four one-year option periods. Offerors must submit Phase 1 proposals by April 30, 2018.

Pricing Worksheet

View the file

Other files

File Type Posted
RFP_70Z02318RMDW00100_QA_Amendment_0006.docx DOCX document
Att._1_-_LC_Matrix.rtf RTF text file
RFP_-_70Z02318RMDW00100_Amendment_0006.docx DOCX document
Amendment_0006.pdf PDF
RFP_-_70Z02318RMDW00100.pdf PDF
Att._1_-_LC_Matrix.pdf PDF
Att._2_-_Resume_Format.pdf PDF
Att._5_-_Task_Order_1_SOW.pdf PDF
Amendment_0005.pdf PDF
Att._3_-_Past_Performance_Questionnaire.pdf PDF
RFP_QA-Amendment_0005.pdf PDF
Amendment_form.pdf PDF
Amendment_form.pdf PDF
Amendment_form.pdf PDF
RFP_-_70Z02318RMDW00100_0001.pdf PDF
RFP_-_70Z02318RMDW00100.pdf PDF
Show all 16

On GovTribe

Work with this file

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

Text version

Base Period

Complete blue cells only. This form will auto calculate. Save as Excel 2007 (.xlsx)
J-4 Pricing Worksheet
Labor Category or Eqivalent TitleFully Loaded RateUnitQtyCost
Senior Program Manager (Key) (Government Site Rate)$ - 0Hour2,080$ - 0
Journeyman Project Manager (Contractor Site Rate)$ - 0Hour19,715$ - 0
Senior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Journeyman Management Analyst (Contractor Site Rate)$ - 0Hour9,463$ - 0
Junior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Senior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Journeyman Technical Writer / Editor (Contractor Site Rate)$ - 0Hour15,772$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Senior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Journeyman Data Scientist (Contractor Site Rate)$ - 0Hour14,195$ - 0
Junior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Senior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Cost Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Total Labor Qty & Cost:82,911$ - 0

Travel Dollar $ 90,000.00

Other Direct Costs (ODCs)RateUnitQty 1Cost 1
Mileage$ - 0Mile0$ - 0
Vehicle Rental$ - 0Daily0$ - 0
Airport Parking$ - 0Daily0$ - 0
Conference Facilities$ - 0Daily0$ - 0
USCG HQ Parking$ - 0Daily0$ - 0
Report Reproduction$ - 0Page0$ - 0
Total ODC Qty & Cost:0$ - 0
% of Total ODC0%0%
Travel/ TransportationRateUnitQty 1Cost 1
Per Diem-Washington, D.C.$ - 0Daily0$ - 0
Per Diem- City #2$ - 0Daily0$ - 0
Airfare (Vendor/ Washington, DC)$ - 0Round Trip0$ - 0
Airfare (Vendor/ City #2)$ - 0Round Trip0$ - 0
Rent Car Gas$ - 0Gallon0$ - 0
Total Travel & Transportation Qty & Cost:0$ - 0
% of Total Trav / Transportation0%0%
Subtotal ODCs & Travel/Transportation$ - 0
General & Administrative Surcharge
on ODC & Travel/Transportation10%$ - 0
Grand Total Project Qty & Cost82910.978703696$ - 0
% of Grand TotalERROR:#REF!0%

Maximum Price for Base Period $ 90,000.00

&"Times New Roman,Bold"&14PRICING WORKSHEET

70Z02318RMDW00100

&D

Period 1

Complete blue cells only. This form will auto calculate. Save as Excel 2007 (.xlsx)
Pricing Worksheet
Labor Category or Eqivalent TitleFully Loaded RateUnitQtyCost
Senior Program Manager (Key) (Government Site Rate)$ - 0Hour2,080$ - 0
Journeyman Project Manager (Contractor Site Rate)$ - 0Hour19,715$ - 0
Senior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Journeyman Management Analyst (Contractor Site Rate)$ - 0Hour9,463$ - 0
Junior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Senior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Journeyman Technical Writer / Editor (Contractor Site Rate)$ - 0Hour15,772$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Senior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Journeyman Data Scientist (Contractor Site Rate)$ - 0Hour14,195$ - 0
Junior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Senior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Cost Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Total Labor Qty & Cost:82,909$ - 0

Travel Dollar $ 90,000.00

Other Direct Costs (ODCs)RateUnitQty 1Cost 1
Mileage$ - 0Mile0$ - 0
Vehicle Rental$ - 0Daily0$ - 0
Airport Parking$ - 0Daily0$ - 0
Conference Facilities$ - 0Daily0$ - 0
USCG HQ Parking$ - 0Daily0$ - 0
Report Reproduction$ - 0Page0$ - 0
Total ODC Qty & Cost:0$ - 0
% of Total ODC0%0%
Travel/ TransportationRateUnitQty 1Cost 1
Per Diem-Washington, D.C.$ - 0Daily0$ - 0
Per Diem- City #2$ - 0Daily0$ - 0
Airfare (Vendor/ Washington, DC)$ - 0Round Trip0$ - 0
Airfare (Vendor/ City #2)$ - 0Round Trip0$ - 0
Rent Car Gas$ - 0Gallon0$ - 0
Total Travel & Transportation Qty & Cost:0$ - 0
% of Total Trav / Transportation0%0%
Subtotal ODCs & Travel/Transportation$ - 0
General & Administrative Surcharge
on ODC & Travel/Transportation10%$ - 0
Grand Total Project Qty & Cost82909$ - 0
% of Grand TotalERROR:#REF!0%

Maximum Price for Period One $ 90,000.00

70Z02318RMDW00100

Period 2

Complete blue cells only. This form will auto calculate. Save as Excel 2007 (.xlsx)
Pricing Worksheet
Labor Category or Eqivalent TitleFully Loaded RateUnitQtyCost
Senior Program Manager (Key) (Government Site Rate)$ - 0Hour2,080$ - 0
Journeyman Project Manager (Contractor Site Rate)$ - 0Hour19,715$ - 0
Senior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Journeyman Management Analyst (Contractor Site Rate)$ - 0Hour9,463$ - 0
Junior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Senior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Journeyman Technical Writer / Editor (Contractor Site Rate)$ - 0Hour15,772$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Senior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Journeyman Data Scientist (Contractor Site Rate)$ - 0Hour14,195$ - 0
Junior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Senior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Cost Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Total Labor Qty & Cost:82,909$ - 0

Travel Dollar $ 90,000.00

Other Direct Costs (ODCs)RateUnitQty 1Cost 1
Mileage$ - 0Mile0$ - 0
Vehicle Rental$ - 0Daily0$ - 0
Airport Parking$ - 0Daily0$ - 0
Conference Facilities$ - 0Daily0$ - 0
USCG HQ Parking$ - 0Daily0$ - 0
Report Reproduction$ - 0Page0$ - 0
Total ODC Qty & Cost:0$ - 0
% of Total ODC0%0%
Travel/ TransportationRateUnitQty 1Cost 1
Per Diem-Washington, D.C.$ - 0Daily0$ - 0
Per Diem- City #2$ - 0Daily0$ - 0
Airfare (Vendor/ Washington, DC)$ - 0Round Trip0$ - 0
Airfare (Vendor/ City #2)$ - 0Round Trip0$ - 0
Rent Car Gas$ - 0Gallon0$ - 0
Total Travel & Transportation Qty & Cost:0$ - 0
% of Total Trav / Transportation0%0%
Subtotal ODCs & Travel/Transportation$ - 0
General & Administrative Surcharge
on ODC & Travel/Transportation10%$ - 0
Grand Total Project Qty & Cost82909$ - 0
% of Grand TotalERROR:#REF!0%

Maximum Price for Period Two $ 90,000.00

70Z02318RMDW00100

Period 3

Complete blue cells only. This form will auto calculate. Save as Excel 2007 (.xlsx)
Pricing Worksheet
Labor Category or Eqivalent TitleFully Loaded RateUnitQtyCost
Senior Program Manager (Key) (Government Site Rate)$ - 0Hour2,080$ - 0
Journeyman Project Manager (Contractor Site Rate)$ - 0Hour19,715$ - 0
Senior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Journeyman Management Analyst (Contractor Site Rate)$ - 0Hour9,463$ - 0
Junior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Senior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Journeyman Technical Writer / Editor (Contractor Site Rate)$ - 0Hour15,772$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Senior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Journeyman Data Scientist (Contractor Site Rate)$ - 0Hour14,195$ - 0
Junior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Senior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Cost Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Total Labor Qty & Cost:82,909$ - 0

Travel Dollar $ 90,000.00

Other Direct Costs (ODCs)RateUnitQty 1Cost 1
Mileage$ - 0Mile0$ - 0
Vehicle Rental$ - 0Daily0$ - 0
Airport Parking$ - 0Daily0$ - 0
Conference Facilities$ - 0Daily0$ - 0
USCG HQ Parking$ - 0Daily0$ - 0
Report Reproduction$ - 0Page0$ - 0
Total ODC Qty & Cost:0$ - 0
% of Total ODC0%0%
Travel/ TransportationRateUnitQty 1Cost 1
Per Diem-Washington, D.C.$ - 0Daily0$ - 0
Per Diem- City #2$ - 0Daily0$ - 0
Airfare (Vendor/ Washington, DC)$ - 0Round Trip0$ - 0
Airfare (Vendor/ City #2)$ - 0Round Trip0$ - 0
Rent Car Gas$ - 0Gallon0$ - 0
Total Travel & Transportation Qty & Cost:0$ - 0
% of Total Trav / Transportation0%0%
Subtotal ODCs & Travel/Transportation$ - 0
General & Administrative Surcharge
on ODC & Travel/Transportation10%$ - 0
Grand Total Project Qty & Cost82909$ - 0
% of Grand TotalERROR:#REF!0%

Maximum Price for Period Three $ 90,000.00

70Z02318RMDW00100

Period 4

Complete blue cells only. This form will auto calculate. Save as Excel 2007 (.xlsx)
Pricing Worksheet
Labor Category or Eqivalent TitleFully Loaded RateUnitQtyCost
Senior Program Manager (Key) (Government Site Rate)$ - 0Hour2,080$ - 0
Journeyman Project Manager (Contractor Site Rate)$ - 0Hour19,715$ - 0
Senior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Journeyman Management Analyst (Contractor Site Rate)$ - 0Hour9,463$ - 0
Junior Management Analyst (Contractor Site Rate)$ - 0Hour1,183$ - 0
Senior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Journeyman Technical Writer / Editor (Contractor Site Rate)$ - 0Hour15,772$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour1,971$ - 0
Senior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Journeyman Data Scientist (Contractor Site Rate)$ - 0Hour14,195$ - 0
Junior Data Scientist (Contractor Site Rate)$ - 0Hour1,774$ - 0
Senior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Cost Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Cost Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Total Labor Qty & Cost:82,909$ - 0

Travel Dollar $ 90,000.00

Other Direct Costs (ODCs)RateUnitQty 1Cost 1
Mileage$ - 0Mile0$ - 0
Vehicle Rental$ - 0Daily0$ - 0
Airport Parking$ - 0Daily0$ - 0
Conference Facilities$ - 0Daily0$ - 0
USCG HQ Parking$ - 0Daily0$ - 0
Report Reproduction$ - 0Page0$ - 0
Total ODC Qty & Cost:0$ - 0
% of Total ODC0%0%
Travel/ TransportationRateUnitQty 1Cost 1
Per Diem-Washington, D.C.$ - 0Daily0$ - 0
Per Diem- City #2$ - 0Daily0$ - 0
Airfare (Vendor/ Washington, DC)$ - 0Round Trip0$ - 0
Airfare (Vendor/ City #2)$ - 0Round Trip0$ - 0
Rent Car Gas$ - 0Gallon0$ - 0
Total Travel & Transportation Qty & Cost:0$ - 0
% of Total Trav / Transportation0%0%
Subtotal ODCs & Travel/Transportation$ - 0
General & Administrative Surcharge
on ODC & Travel/Transportation10%$ - 0
Grand Total Project Qty & Cost82909$ - 0
% of Grand TotalERROR:#REF!0%

Maximum Price for Period Four $ 90,000.00

70Z02318RMDW00100

6 Month Option

Complete blue cells only. This form will auto calculate. Save as Excel 2007 (.xlsx)
Pricing Worksheet
Labor Category or Eqivalent TitleFully Loaded RateUnitQtyCost
Senior Program Manager (Key) (Government Site Rate)$ - 0Hour2,080$ - 0
Journeyman Project Manager (Contractor Site Rate)$ - 0Hour9,857$ - 0
Senior Management Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Journeyman Management Analyst (Contractor Site Rate)$ - 0Hour4,732$ - 0
Junior Management Analyst (Contractor Site Rate)$ - 0Hour591$ - 0
Senior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour296$ - 0
Journeyman Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour2,366$ - 0
Junior Operations Reserach Analyst (Contractor Site Rate)$ - 0Hour296$ - 0
Senior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour986$ - 0
Journeyman Technical Writer / Editor (Contractor Site Rate)$ - 0Hour7,886$ - 0
Junior Technical Writer / Editor (Contractor Site Rate)$ - 0Hour986$ - 0
Senior Data Scientist (Contractor Site Rate)$ - 0Hour887$ - 0
Journeyman Data Scientist (Contractor Site Rate)$ - 0Hour7,097$ - 0
Junior Data Scientist (Contractor Site Rate)$ - 0Hour887$ - 0
Senior Cost Analyst (Contractor Site Rate)$ - 0Hour296$ - 0
Journeyman Cost Analyst (Contractor Site Rate)$ - 0Hour2,366$ - 0
Junior Cost Analyst (Contractor Site Rate)$ - 0Hour296$ - 0
Total Labor Qty & Cost:42,496$ - 0

Travel Dollar $ 45,000.00

Other Direct Costs (ODCs)RateUnitQty 1Cost 1
Mileage$ - 0Mile0$ - 0
Vehicle Rental$ - 0Daily0$ - 0
Airport Parking$ - 0Daily0$ - 0
Conference Facilities$ - 0Daily0$ - 0
USCG HQ Parking$ - 0Daily0$ - 0
Report Reproduction$ - 0Page0$ - 0
Total ODC Qty & Cost:0$ - 0
% of Total ODC0%0%
Travel/ TransportationRateUnitQty 1Cost 1
Per Diem-Washington, D.C.$ - 0Daily0$ - 0
Per Diem- City #2$ - 0Daily0$ - 0
Airfare (Vendor/ Washington, DC)$ - 0Round Trip0$ - 0
Airfare (Vendor/ City #2)$ - 0Round Trip0$ - 0
Rent Car Gas$ - 0Gallon0$ - 0
Total Travel & Transportation Qty & Cost:0$ - 0
% of Total Trav / Transportation0%0%
Subtotal ODCs & Travel/Transportation$ - 0
General & Administrative Surcharge
on ODC & Travel/Transportation10%$ - 0
Grand Total Project Qty & Cost42496$ - 0
% of Grand TotalERROR:#REF!0%

Maximum Price for 6-month Option $ 45,000.00

70Z02318RMDW00100

Totals

Base Period$ 90,000.00
Period 1$ 90,000.00
Period 2$ 90,000.00
Period 3$ 90,000.00
Period 4$ 90,000.00
6-month Option$ 45,000.00
Total$ 495,000.00

Task Order 1

Complete blue cells only. This form will auto calculate. Save as Excel 2007 (.xlsx)
Pricing Worksheet
Base Year Labor Category or Eqivalent TitleFully Loaded RateUnitQtyCost
Senior Program Manager (Key) (Government Site Rate)$ - 0Hour2,080$ - 0
Total Labor Qty & Cost (Labor Hour):2,080$ - 0
Other Direct Costs (ODCs)RateUnitQty 1Cost 1
Mileage$ - 0Mile0$ - 0
Vehicle Rental$ - 0Daily0$ - 0
Airport Parking$ - 0Daily0$ - 0
Conference Facilities$ - 0Daily0$ - 0
USCG HQ Parking$ - 0Daily0$ - 0
Report Reproduction$ - 0Page0$ - 0
Total ODC Qty & Cost:0$ - 0
% of Total ODC0%0%
Travel/ TransportationRateUnitQty 1Cost 1
Per Diem-Washington, D.C.$ - 0Daily0$ - 0
Per Diem- City #2$ - 0Daily0$ - 0
Airfare (Vendor/ Washington, DC)$ - 0Round Trip0$ - 0
Airfare (Vendor/ City #2)$ - 0Round Trip0$ - 0
Rent Car Gas$ - 0Gallon0$ - 0
Total Travel & Transportation Qty & Cost:0$ - 0
% of Total Trav / Transportation0%0%
Subtotal ODCs & Travel/Transportation$ - 0
General & Administrative Surcharge
on ODC & Travel/Transportation10%$ - 0
Grand Total Project Qty & Cost2080$ - 0
% of Grand TotalERROR:#REF!0%

Ceiling Price Task Order 1: $ - 0

70Z02318RMDW00100

File details come from the government source that posted it. Updated .