S02 - Attachment 8 Coefficient Calculations Worksheet.xlsx

XLSX spreadsheet 20 KB Posted

Attached to
36C24822R0057 VISN-8 – Miami, Tampa, Bay Pines, West Palm Beach, North Florida, Orlando, Florida and San Juan, Puerto Rico - IDIQ
Solicitation number
Not on record
Issued by

View the file

Other files

Show all 15

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

Pre-Priced Coefficient Solicitation N66001-22-R-0003

COEFFICIENT SPREADSHEET

(Profit & Bonds Included)

DESCRIPTIONFACTOR
Base Coefficient from RS Means0.0000
Subcontractor Overhead and Profit0.0000
Project Manager0.0000
Superintendent/Safety0.0000
QC Manager0.0000
Incidental Engineering0.0000
Vehicle Operations0.0000
Office Expense and G&A0.0000
General Liability Insurance0.0000
General Requirements0.0000
Subtotal - -0.0000
Profit - 0%0.0000
Bond premium - 0%0.0000
TOTAL COEFFICIENT- -0.0000
PROJECT MANAGER / ESTIMATORAMOUNT
Annual Salary$0.00
Annual Labor Fringe & Burden
(WC - , Labor Overhead - )0%$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
SUPERINTENDENT / SAFETYAMOUNT
Annual Salary$0.00
Annual Labor Fringe & Burden
(WC - , Labor Overhead - )0%$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
QC MANAGERAMOUNT
Annual Salary$0.00
Annual Labor Fringe & Burden
(WC - , Labor Overhead - )0%$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
INCIDENTAL ENGINEERINGAMOUNT
Annual Engineering CostsLump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
VEHICLE OPERATIONSAMOUNT
Annual Costs (gas/maintenance)Lump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
HOME OFFICE OVERHEAD (G&A)AMOUNT
Overhead Raterate0.00%
Subtotal - -
Base Amount x number of contract years5
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
GENERAL LIABILITY INSURANCEAMOUNT
Insurance Premium costLump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
GENERAL REQUIREMENTSAMOUNT
TrailerLump Sum$0.00
SuppliesLump Sum$0.00
Tools and equipment usageLump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
BOND PREMIUMAMOUNT
Bond costs (bond rate: 0%)Lump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years$0.00
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
PROFITAMOUNT
Profit - 5%0%$0.00
Subtotal - -$0.00
Base Amount x number of contract years$0.00
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
NOTES:
1. The amounts and percentages listed herein are fictitious. These figures should not
be construed to be the minimum or maximum or even normal amounts.

2. Supervisory labor categories may be added/deleted as needed.

3. City Cost Index is not included herein, but will be added with each task order proposal.
4. Directions: starting at cell E20, fill in "orange blocks" using instructions in "comments."

Non-Pre-Priced Coefficient Solicitation N66001-22-R-0003

COEFFICIENT SPREADSHEET

(Profit & Bonds Included)

DESCRIPTIONFACTOR
Base Coefficient from RS Means0.0000
Subcontractor Overhead and Profit0.0000
Project Manager0.0000
Superintendent/Safety0.0000
QC Manager0.0000
Incidental Engineering0.0000
Vehicle Operations0.0000
Office Expense and G&A0.0000
General Liability Insurance0.0000
General Requirements0.0000
Subtotal - -0.0000
Profit - 0%0.0000
Bond premium - 0%0.0000
TOTAL COEFFICIENT- -0.0000
PROJECT MANAGER / ESTIMATORAMOUNT
Annual Salary$0.00
Annual Labor Fringe & Burden
(WC - , Labor Overhead - )0%$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
SUPERINTENDENT / SAFETYAMOUNT
Annual Salary$0.00
Annual Labor Fringe & Burden
(WC - , Labor Overhead - )0%$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
QC MANAGERAMOUNT
Annual Salary$0.00
Annual Labor Fringe & Burden
(WC - , Labor Overhead - )0%$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
INCIDENTAL ENGINEERINGAMOUNT
Annual Engineering CostsLump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
VEHICLE OPERATIONSAMOUNT
Annual Costs (gas/maintenance)Lump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Percentage of time spent on this contract0%
Subtotal - -$0.00
Factor - -0.0000
HOME OFFICE OVERHEAD (G&A)AMOUNT
Overhead Raterate0.00%
Subtotal - -
Base Amount x number of contract years5
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
GENERAL LIABILITY INSURANCEAMOUNT
Insurance Premium costLump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
GENERAL REQUIREMENTSAMOUNT
TrailerLump Sum$0.00
SuppliesLump Sum$0.00
Tools and equipment usageLump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years5$0.00
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
BOND PREMIUMAMOUNT
Bond costs (bond rate: 0%)Lump Sum$0.00
Subtotal - -$0.00
Base Amount x number of contract years$0.00
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
PROFITAMOUNT
Profit - 5%0%$0.00
Subtotal - -$0.00
Base Amount x number of contract years$0.00
Total Contract Value$50,000,000.00
Subtotal - -$0.00
Factor - -0.0000
NOTES:
1. The amounts and percentages listed herein are fictitious. These figures should not
be construed to be the minimum or maximum or even normal amounts.

2. Supervisory labor categories may be added/deleted as needed.

3. City Cost Index is not included herein, but will be added with each task order proposal.
4. Directions: starting at cell E20, fill in "orange blocks" using instructions in "comments."

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