A07_W81XWH-20-R-0021_Attch-5_Cost-Proposal_Spreadsheet_draft1.xls

XLS spreadsheet 122 KB Posted

Attached to
Warfighter Health, Performance and Evacuation Project Management Office, Transport Telemedicine Systems Automated IV Pressure Infuser for MEDEVAC
Solicitation number
W81XWH20R0021
Issued by

About this file

This cost proposal spreadsheet template and related federal contract opportunity seek proposals for the development of an automated intravenous pressure infuser for military medical evacuation vehicles. The spreadsheet includes templates for offering labor rates and costs for prime and subcontractor direct labor for the base period and optional tasks, as well as other direct costs including travel, government property, and materials. It also includes sections for contractor manpower reporting and contract data requirement listings. The related opportunity describes the Army's goal of automating current manual intravenous bag pressure infusion and lists technical requirements. Offerors are requested to draft a statement of work for design, development, testing, approval, production, training and fielding of the automated IV pressure infuser with a technology readiness level of 8 by the end of the period of performance. Proposals are due to the Warfighter Health, Performance and Evacuation Project Management Office by the date listed in the solicitation number W81XWH20R0021.

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

Cover Page

Solicitation Number:W81XWH-20-R-0021
Offeror Name:
Offeror Mailing Address:
Point of Contact (POC) Name (First/Last):
POC Title:
POC Email Address:
POC Phone Number:
POC Fax Number:
POC Level of Authority:

Page &P of &N

SUMMARY

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Enter your totals for each of the costs below in the highlighted fields. The Offeror is responsible for ensuring mathematical calculations are correct.
SUMMARY OF PROPOSED COSTS
LABORBASE TASKOPTIONAL TASK 1OPTIONAL TASK 2OPTIONAL TASK 3BASE PERIOD (Totals for all tasks)
Period Dates (estimate)18 MONTHS12 MONTHS12 MONTHS12 MONTHS54 MONTHS
Direct Labor
Overhead Cost
G&A Cost
Subtotal
Fixed Fee Percentage
Fixed Fee Cost
Total (Labor Cost Plus Fixed Fee)
OTHER DIRECT COSTS
FFP Subcontractor Costs
Estimated Travel
CAP
Materials
Total Other Direct Costs
Contractor Manpower Reporting
CDRL A001
CDRL A002
CDRL A003
CDRL A004
CDRL A005
CDRL A006
CDRL A007
Total Proposed Cost

Page &P of &N

Labor--Base

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Fill in additional information for Direct Labor Costs in Columns E, F and G. Add columns to Include escalation if necessary. If subcontractor agreements are Firm Fixed Price they can be listed as ODCs. If subs are direct labor, include costs here. The subtotal column is intended to provide the rate without fee included so it can be identified as a separate amount in the award. The rates in the total column will be used to compare the proposed rates to the base contract maximum rates, which include fee. The Offeror is responsible for ensuring mathematical calculations are correct.
SUMMARY OF DIRECT LABOR COSTS (INCLUDING BUILDUP)
BASE TASK
Base/Direct Labor RateFringe Percentage Enter the % for each category in this column, not the dollar value.Overhead Percentage Enter the % for each category in this column, not the dollar value.G&A Percentage Enter the % for each category in this column, not the dollar value.Loaded Rate Without FeeHoursSubtotalFee Enter the fee percentage in the yellow block. Calculate the dollar value by summing at the bottom of this column.Fully Loaded RateTotal
Labor CategoryPrime/Subcontractor
%
1$0.00%%%$0.000.00$0.00$0.00$0.00$0.00
20.00%%%0.000.000.000.000.000.00
30.00%%%0.000.000.000.000.000.00
40.00%%%0.000.000.000.000.000.00
50.00%%%0.000.000.000.000.000.00
60.00%%%0.000.000.000.000.000.00
70.00%%%0.000.000.000.000.000.00
80.00%%%0.000.000.000.000.000.00
90.00%%%0.000.000.000.000.000.00
100.00%%%0.000.000.000.000.000.00
110.00%%%0.000.000.000.000.000.00
120.00%%%0.000.000.000.000.000.00
130.00%%%0.000.000.000.000.000.00
140.00%%%0.000.000.000.000.000.00
150.00%%%0.000.000.000.000.000.00
160.00%%%0.000.000.000.000.000.00
170.00%%%0.000.000.000.000.000.00
180.00%%%0.000.000.000.000.000.00
190.00%%%0.000.000.000.000.000.00
200.00%%%0.000.000.000.000.000.00
210.00%%%0.000.000.000.000.000.00
220.00%%%0.000.000.000.000.000.00
230.00%%%0.000.000.000.000.000.00
240.00%%%0.000.000.000.000.000.00
250.00%%%0.000.000.000.000.000.00
$0.00$0.000.00$0.00$0.00$0.00$0.00

Page &P of &N

Labor--Option Task 1

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Fill in additional information for Direct Labor Costs in Columns E, F and G. Add columns to Include escalation if necessary. If subcontractor agreements are Firm Fixed Price they can be listed as ODCs. If subs are direct labor, include costs here. The subtotal column is intended to provide the rate without fee included so it can be identified as a separate amount in the award. The rates in the total column will be used to compare the proposed rates to the base contract maximum rates, which include fee. The Offeror is responsible for ensuring mathematical calculations are correct.
SUMMARY OF DIRECT LABOR COSTS (INCLUDING BUILDUP)
OPTIONAL TASK 1
Base/Direct Labor RateFringe Percentage Enter the % for each category in this column, not the dollar value.Overhead Percentage Enter the % for each category in this column, not the dollar value.G&A Percentage Enter the % for each category in this column, not the dollar value.Loaded Rate Without FeeHoursSubtotalFee Enter the fee percentage in the yellow block. Calculate the dollar value by summing at the bottom of this column.Fully Loaded RateTotal
Labor CategoryPrime/Subcontractor
%
1$0.00%%%$0.000.00$0.00$0.00$0.00$0.00
20.00%%%0.000.000.000.000.000.00
30.00%%%0.000.000.000.000.000.00
40.00%%%0.000.000.000.000.000.00
50.00%%%0.000.000.000.000.000.00
60.00%%%0.000.000.000.000.000.00
70.00%%%0.000.000.000.000.000.00
80.00%%%0.000.000.000.000.000.00
90.00%%%0.000.000.000.000.000.00
100.00%%%0.000.000.000.000.000.00
110.00%%%0.000.000.000.000.000.00
120.00%%%0.000.000.000.000.000.00
130.00%%%0.000.000.000.000.000.00
140.00%%%0.000.000.000.000.000.00
150.00%%%0.000.000.000.000.000.00
160.00%%%0.000.000.000.000.000.00
170.00%%%0.000.000.000.000.000.00
180.00%%%0.000.000.000.000.000.00
190.00%%%0.000.000.000.000.000.00
200.00%%%0.000.000.000.000.000.00
210.00%%%0.000.000.000.000.000.00
220.00%%%0.000.000.000.000.000.00
230.00%%%0.000.000.000.000.000.00
240.00%%%0.000.000.000.000.000.00
250.00%%%0.000.000.000.000.000.00
$0.00$0.000.00$0.00$0.00$0.00$0.00

Page &P of &N

Labor--Option Task 2

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Fill in additional information for Direct Labor Costs in Columns E, F and G. Add columns to Include escalation if necessary. If subcontractor agreements are Firm Fixed Price they can be listed as ODCs. If subs are direct labor, include costs here. The subtotal column is intended to provide the rate without fee included so it can be identified as a separate amount in the award. The rates in the total column will be used to compare the proposed rates to the base contract maximum rates, which include fee. The Offeror is responsible for ensuring mathematical calculations are correct.
SUMMARY OF DIRECT LABOR COSTS (INCLUDING BUILDUP)
OPTIONAL TASK 2
Base/Direct Labor RateFringe Percentage Enter the % for each category in this column, not the dollar value.Overhead Percentage Enter the % for each category in this column, not the dollar value.G&A Percentage Enter the % for each category in this column, not the dollar value.Loaded Rate Without FeeHoursSubtotalFee Enter the fee percentage in the yellow block. Calculate the dollar value by summing at the bottom of this column.Fully Loaded RateTotal
Labor CategoryPrime/Subcontractor
%
1$0.00%%%$0.000.00$0.00$0.00$0.00$0.00
20.00%%%0.000.000.000.000.000.00
30.00%%%0.000.000.000.000.000.00
40.00%%%0.000.000.000.000.000.00
50.00%%%0.000.000.000.000.000.00
60.00%%%0.000.000.000.000.000.00
70.00%%%0.000.000.000.000.000.00
80.00%%%0.000.000.000.000.000.00
90.00%%%0.000.000.000.000.000.00
100.00%%%0.000.000.000.000.000.00
110.00%%%0.000.000.000.000.000.00
120.00%%%0.000.000.000.000.000.00
130.00%%%0.000.000.000.000.000.00
140.00%%%0.000.000.000.000.000.00
150.00%%%0.000.000.000.000.000.00
160.00%%%0.000.000.000.000.000.00
170.00%%%0.000.000.000.000.000.00
180.00%%%0.000.000.000.000.000.00
190.00%%%0.000.000.000.000.000.00
200.00%%%0.000.000.000.000.000.00
210.00%%%0.000.000.000.000.000.00
220.00%%%0.000.000.000.000.000.00
230.00%%%0.000.000.000.000.000.00
240.00%%%0.000.000.000.000.000.00
250.00%%%0.000.000.000.000.000.00
$0.00$0.000.00$0.00$0.00$0.00$0.00

Page &P of &N

Labor--Option Task 3

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Fill in additional information for Direct Labor Costs in Columns E, F and G. Add columns to Include escalation if necessary. If subcontractor agreements are Firm Fixed Price they can be listed as ODCs. If subs are direct labor, include costs here. The subtotal column is intended to provide the rate without fee included so it can be identified as a separate amount in the award. The rates in the total column will be used to compare the proposed rates to the base contract maximum rates, which include fee. The Offeror is responsible for ensuring mathematical calculations are correct.
SUMMARY OF DIRECT LABOR COSTS (INCLUDING BUILDUP)
OPTIONAL TASK 3
Base/Direct Labor RateFringe Percentage Enter the % for each category in this column, not the dollar value.Overhead Percentage Enter the % for each category in this column, not the dollar value.G&A Percentage Enter the % for each category in this column, not the dollar value.Loaded Rate Without FeeHoursSubtotalFee Enter the fee percentage in the yellow block. Calculate the dollar value by summing at the bottom of this column.Fully Loaded RateTotal
Labor CategoryPrime/Subcontractor
%
1$0.00%%%$0.000.00$0.00$0.00$0.00$0.00
20.00%%%0.000.000.000.000.000.00
30.00%%%0.000.000.000.000.000.00
40.00%%%0.000.000.000.000.000.00
50.00%%%0.000.000.000.000.000.00
60.00%%%0.000.000.000.000.000.00
70.00%%%0.000.000.000.000.000.00
80.00%%%0.000.000.000.000.000.00
90.00%%%0.000.000.000.000.000.00
100.00%%%0.000.000.000.000.000.00
110.00%%%0.000.000.000.000.000.00
120.00%%%0.000.000.000.000.000.00
130.00%%%0.000.000.000.000.000.00
140.00%%%0.000.000.000.000.000.00
150.00%%%0.000.000.000.000.000.00
160.00%%%0.000.000.000.000.000.00
170.00%%%0.000.000.000.000.000.00
180.00%%%0.000.000.000.000.000.00
190.00%%%0.000.000.000.000.000.00
200.00%%%0.000.000.000.000.000.00
210.00%%%0.000.000.000.000.000.00
220.00%%%0.000.000.000.000.000.00
230.00%%%0.000.000.000.000.000.00
240.00%%%0.000.000.000.000.000.00
250.00%%%0.000.000.000.000.000.00
$0.00$0.000.00$0.00$0.00$0.00$0.00

Page &P of &N

Other Direct Costs--Base

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Use this tab to propose Other Direct Costs (ODCs). The Offeror is responsible for ensuring mathematical calculations are correct.
BASE TASK
FFP Subcontractor Costs
SubcontractorTaskPriceBasis for Fair and Reasonable Determination (see FAR 15.404)
Estimated Travel
Add additional trips if necessary. If no travel is proposed, delete this information and state 'no travel is proposed.'
Trip 1Trip 2Trip 3
City of Trip Origin
City of Trip Destination
Justification
Traveler (prime or sub)
Airfare Class
Airline
Airfare Cost$0.00$0.00$0.00
Lodging Cost0.000.000.00
Meal Cost0.000.000.00
Incidentals0.000.000.00
No. of days
Total Tip Cost0.000.000.00
No. Trips per Period
No. of Persons
Total Trip Cost0.000.000.00
Total Travel Cost$0.00
Government Furnished Contractor Acquired Property
Add and delete rows as necessary. If none is proposed, delete this information and state 'none is proposed.'
ItemItem Description (including part numbers)Need DateQuantityCost (rent-free basis)Rental CostsResidual/ Scrap ValueEstimated Equipment Life
Materials
Add or delete rows below as necessary. If no materials are proposed, delete this information and state 'no materials are proposed.'
ItemItem DescriptionQuantityCost per UnitNo. of UnitsTotal Cost
$0.00$0.00
0.000.00
0.000.00
0.000.00
0.000.00
Total Material Cost0.00

&L&20&USUMMARY OF MATERIALS AND SUPPLIES

Page &P of &N

Other Direct Costs--OPT Task 1

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Use this tab to propose Other Direct Costs (ODCs). The Offeror is responsible for ensuring mathematical calculations are correct.
BASE TASK
FFP Subcontractor Costs
SubcontractorTaskPriceBasis for Fair and Reasonable Determination (see FAR 15.404)
Estimated Travel
Add additional trips if necessary. If no travel is proposed, delete this information and state 'no travel is proposed.'
Trip 1Trip 2Trip 3
City of Trip Origin
City of Trip Destination
Justification
Traveler (prime or sub)
Airfare Class
Airline
Airfare Cost$0.00$0.00$0.00
Lodging Cost0.000.000.00
Meal Cost0.000.000.00
Incidentals0.000.000.00
No. of days
Total Tip Cost0.000.000.00
No. Trips per Period
No. of Persons
Total Trip Cost0.000.000.00
Total Travel Cost$0.00
Government Furnished Contractor Acquired Property
Add and delete rows as necessary. If none is proposed, delete this information and state 'none is proposed.'
ItemItem Description (including part numbers)Need DateQuantityCost (rent-free basis)Rental CostsResidual/ Scrap ValueEstimated Equipment Life
Materials
Add or delete rows below as necessary. If no materials are proposed, delete this information and state 'no materials are proposed.'
ItemItem DescriptionQuantityCost per UnitNo. of UnitsTotal Cost
$0.00$0.00
0.000.00
0.000.00
0.000.00
0.000.00
Total Material Cost0.00

&L&20&USUMMARY OF MATERIALS AND SUPPLIES

Page &P of &N

Other Direct Costs--OPT Task 2

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Use this tab to propose Other Direct Costs (ODCs). The Offeror is responsible for ensuring mathematical calculations are correct.
BASE TASK
FFP Subcontractor Costs
SubcontractorTaskPriceBasis for Fair and Reasonable Determination (see FAR 15.404)
Estimated Travel
Add additional trips if necessary. If no travel is proposed, delete this information and state 'no travel is proposed.'
Trip 1Trip 2Trip 3
City of Trip Origin
City of Trip Destination
Justification
Traveler (prime or sub)
Airfare Class
Airline
Airfare Cost$0.00$0.00$0.00
Lodging Cost0.000.000.00
Meal Cost0.000.000.00
Incidentals0.000.000.00
No. of days
Total Tip Cost0.000.000.00
No. Trips per Period
No. of Persons
Total Trip Cost0.000.000.00
Total Travel Cost$0.00
Government Furnished Contractor Acquired Property
Add and delete rows as necessary. If none is proposed, delete this information and state 'none is proposed.'
ItemItem Description (including part numbers)Need DateQuantityCost (rent-free basis)Rental CostsResidual/ Scrap ValueEstimated Equipment Life
Materials
Add or delete rows below as necessary. If no materials are proposed, delete this information and state 'no materials are proposed.'
ItemItem DescriptionQuantityCost per UnitNo. of UnitsTotal Cost
$0.00$0.00
0.000.00
0.000.00
0.000.00
0.000.00
Total Material Cost0.00

&L&20&USUMMARY OF MATERIALS AND SUPPLIES

Page &P of &N

Other Direct Costs--OPT Task 3

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Use this tab to propose Other Direct Costs (ODCs). The Offeror is responsible for ensuring mathematical calculations are correct.
BASE TASK
FFP Subcontractor Costs
SubcontractorTaskPriceBasis for Fair and Reasonable Determination (see FAR 15.404)
Estimated Travel
Add additional trips if necessary. If no travel is proposed, delete this information and state 'no travel is proposed.'
Trip 1Trip 2Trip 3
City of Trip Origin
City of Trip Destination
Justification
Traveler (prime or sub)
Airfare Class
Airline
Airfare Cost$0.00$0.00$0.00
Lodging Cost0.000.000.00
Meal Cost0.000.000.00
Incidentals0.000.000.00
No. of days
Total Tip Cost0.000.000.00
No. Trips per Period
No. of Persons
Total Trip Cost0.000.000.00
Total Travel Cost$0.00
Government Furnished Contractor Acquired Property
Add and delete rows as necessary. If none is proposed, delete this information and state 'none is proposed.'
ItemItem Description (including part numbers)Need DateQuantityCost (rent-free basis)Rental CostsResidual/ Scrap ValueEstimated Equipment Life
Materials
Add or delete rows below as necessary. If no materials are proposed, delete this information and state 'no materials are proposed.'
ItemItem DescriptionQuantityCost per UnitNo. of UnitsTotal Cost
$0.00$0.00
0.000.00
0.000.00
0.000.00
0.000.00
Total Material Cost0.00

&L&20&USUMMARY OF MATERIALS AND SUPPLIES

Page &P of &N

Contractor Manpower Reporting

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Propose any costs for Contractor Manpower Reporting here. If you are proposing as 'Not Separately Priced,' enter $0.00 as the cost.
CONTRACTOR MANPOWER REPORTING
BASE TASK and All Optional TasksEntire Award
FY20FY21FY24FY23Fy 24TOTAL
1Contractor Manpower Reporting$0.00$0.00$0.00$0.00$0.00$0.00
Reporting inputs will be for the labor executed during the period of performance during each Government fiscal year (FY), which runs October 1 through September 30. While inputs may be reported any time during the FY, all data shall be reported no later than October 31 of each calendar year. Additional information can be accessed at the following URL: https://www.ecmra.mil/help/help.html

Page &P of &N

CDRLs

Solicitation Attachment 5 - Cost Proposal Spreadsheet
Solicitation#: W81XWH-20-R-0021
Offeror:
Date:
INSTRUCTIONS: Propose any costs for CDRLs here. If you are proposing as 'Not Separately Priced,' enter 'NSP' as the cost.
CONTRACT DATA REQUIREMENTS LIST PRICING
BASE TASKOPTIONAL TASK 1OPTIONAL TASK 2OPTIONAL TASK 3Total Award
1CDRL A001
2CDRL A002
3CDRL A003
4CDRL A004
5CDRL A005
6CDRL A006
7CDRL A007
N/ATOTAL (all CDRLs)$0.00$0.00$0.00$0.00$0.00

Page &P of &N

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