Attachment_L3_-_Cost_Price_Workbook(v3).xlsx

XLSX spreadsheet 61 KB Posted

Attached to
One Semi-Automated Forces - Award Notice Federal contract opportunity
Solicitation number
W900KK-18-R-0010
Issued by
Department of the Army Materiel Command Contracting Command Orlando Contracting Center

About this file

Cost Price Workbook (v3)

View the file

Other files for this federal contract opportunity

Other files attached to One Semi-Automated Forces - Award Notice, newest first.
File Type Posted
W900KK-18-R-0010.amendment0004.mod.pdf PDF
W900KK-18-R-0010.amendment0004.conformed.pdf PDF
1_RFP_Question_Comment_Form_OneSAF_Amendment0004.pdf PDF
W900KK-18-R-0010.conformed_amend.0003.docx.pdf PDF
W900KK-18-R-0010.modification_amend.0003.pdf PDF
L1_RFP_Question_Comment_Form_OneSAF_Amendment0003.pdf PDF
W900KK-18-R-0010.conform(amend2).pdf PDF
L1_RFP_Question_Comment_Form_OneSAF_Amendment_0002.pdf PDF
Attachment_L3_-_Cost_Price_Workbook(update).xlsx XLSX spreadsheet
W900KK-18-R-0010.modification(amend2).pdf PDF
L1_RFP_Question_Answer_OneSAF.pdf PDF
Attachment_L3_-_Cost_Price_Workbook.xlsx XLSX spreadsheet
Amendment_01_Letter.pdf PDF
L1_Amendment.01_Question_Answer_OneSAF.pdf PDF
W900KK-18-R-0010_Amendment.01_Modification.pdf PDF
W900KK-18-R-0010_Amendment.01_Conformed.pdf PDF
2_OneSAF_PWS_4Dec2017_TO_0001.pdf PDF
Exhibit_A_CDRLs-Corrected.pdf PDF
9_Key_Personnel.pdf PDF
5_W900KK-18-R-0010_OneSAF_DD254.pdf PDF
L4_Pre_award_Survey_of_Prospective_Offeror_Accounting_System.pdf PDF
L7_Past_Performance_POC_List.xlsx XLSX spreadsheet
2_OneSAF_PWS_TO_0001.pdf PDF
1_OneSAF_PWS_IDIQ.pdf PDF
Exhibit_A_CDRLs_.pdf PDF
3_OneSAF_PWS_TO_0002.pdf PDF
L5_OneSAF_WBS_Recompete.xlsx XLSX spreadsheet
8_OneSAF_GFE_Listing.xlsx XLSX spreadsheet
L1_RFP_Question_Comment_Form.xlsx XLSX spreadsheet
4_OneSAF_QASP.pdf PDF
7_OneSAF_V9.0_UseCases.pdf PDF
L2_OneSAF_DISTRIBUTION_AGREEMENT_for_USG_and_DOD_Cntr_only_-_20170927.pdf PDF
Exhibit_B_DSL.pdf PDF
L3_OneSAF_Contract_Price_Workbook.xlsx XLSX spreadsheet
6_OneSAF_9__Memo.pdf PDF
W900KK-18-R-0010.Final.pdf PDF
L8_Proposal_Receipt_Form.pdf PDF
L6_PastPerformance_Questionnaire.pdf PDF
OneSAF_DISTRIBUTION_AGREEMENT_for_USG_and_DOD_Cntr_only_-_20170927.pdf PDF
Draft_OneSAF_WBS_Recompete_25Sep2017.pdf PDF
Draft_OneSAF_V9.0_UseCases.pdf PDF
OneSAF_Access_Request.pdf PDF
Draft_OneSAF_9__Memo.pdf PDF
Draft_OneSAF_PWS_21June2017_TO_0001.pdf PDF
Draft_OneSAF_PWS_21June2017_TO_0002.pdf PDF
Draft_OneSAF_PWS_21June2017_IDIQ.pdf PDF
Show all 46

On GovTribe

Work with this file on GovTribe

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

Text version

Attachment 3

ATTACHMENT 3
Base Year, TO 01
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT

Author:

Instructions:

Input Quantities in column D and Unit Pricing in column F, the extended Amounts in column G will automatically be updated. The amounts in column G will then be input into the corresponding fields in the Attachment 3a tab.

101 Software Product Baseline Management and Support CPFF Lot $ -

CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
102Program ManagementFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
103Development & Customer SupportCPFF1Lot$ 3,500,000$ 3,500,000
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
104Training (1 week)FFP3Each$ -
Cost for Three (3) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
105Training (2 weeks)FFP2Each$ -
Cost for Two (2) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
106Travel & ODCCost1Lot$ 614,077$ 614,077
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
107Manpower ReportingFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
108Technical Data & InformationFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
109Transition-InFFPEach$ -

Subtotal $ 4,114,077

Base Year, TO 02
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
201v9.0 - Capability P3ICPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
202Tailored Product Baseline ReleaseCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
203Capability ConcurrencyCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
204Intergration, Test and ReleaseCPFFLot$ -

Subtotal $ -

Option Year 1 TO 01
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1101Software Product Baseline Management and SupportCPFFLot
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1102Program ManagementFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1103Development & Customer SupportCPFF1Lot$ 4,135,000$ 4,135,000
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1104Training (1 week)FFP3Each$ -
Cost for Three (3) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1105Training (2 weeks)FFP2Each$ -
Cost for Two (2) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1106Travel & ODCCost1Lot$ 614,077$ 614,077
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1107Manpower ReportingFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1108Technical Data & InformationFFPEach$ -

Subtotal $ 4,749,077

Option Year 1, TO 03
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1301V9.0 - Capability P3ICPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1302Tailored Product Baseline ReleaseCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1303Capability ConcurrencyCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
1304Integration, Test, ReleaseCPFFLot$ -

Subtotal $ -

Option Year 2 TO 01
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2101Software Product Baseline Management and SupportCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2102Program ManagementFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2103Development & Customer SupportCPFF1Lot$ 7,960,000$ 7,960,000
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
21041 Week Training SessionsFFP3Each$ -
Cost for Three (3) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
21052 Week Training SessionsFFP2Each$ -
Cost for Two (2) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2106Travel & ODCCost1Lot$ 614,077$ 614,077
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2107Manpower ReportingFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2108Technical Data & InformationFFPEach$ -

Subtotal $ 8,574,077

Option Year 2 TO 04
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2401V9.0 - Capability P3ICPIFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2402Tailored Product Baseline ReleaseCPIFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2403Capability ConcurrencyCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
2404Integration, Test, ReleaseCPIFLot$ -

Subtotal $ -

Option Year 3 TO 05
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3501Software Product Baseline Management and SupportCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3502Program ManagementFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3503Development & Customer SupportCPFF1Lot$ 7,545,000$ 7,545,000
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
35041 Week TrainingFFP3Each$ -
Cost for Three (3) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
35052 Week TrainingFFP2Each$ -
Cost for Two (2) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3506Travel & ODCCost1Lot$ 614,077$ 614,077
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3507Manpower ReportingFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3508Technical Data & InformationFFPEach$ -

Subtotal $ 8,159,077

Option Year 3 TO 06
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3601V9.0 - Capability P3ICPIFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3602Tailored Product Baseline ReleaseCPIFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3603Capability ConcurrencyCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
3604Integration, Test, ReleaseCPIFLot$ -

Subtotal $ -

Option Year 4 TO 05
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4501Software Product Baseline Management and SupportCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4502Program ManagementFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4503Development & Customer SupportCPFF1Lot$ 7,545,000$ 7,545,000
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
45041 Week TrainingFFP3Each$ -
Cost for Three (3) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
45052 Week TrainingFFP2Each$ -
Cost for Two (2) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4506Travel & ODCCost1Lot$ 614,077$ 614,077
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4507Manpower ReportingFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4508Technical Data & InformationFFPEach$ -

Subtotal $ 8,159,077

Option Year 4 TO 07
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4701V9.0 - Capability P3ICPIFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4702Tailored Product Baseline ReleaseCPIFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4703Capability ConcurrencyCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
4704Integration, Test, ReleaseCPIFLot$ -

Subtotal $ -

Option Year 5 TO 05
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5501Software Product Baseline Management and SupportCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5502Program ManagementFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5503Development & Customer SupportCPFF1Lot$ 7,320,000$ 7,320,000
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
55041 Week TrainingFFP3Each$ -
Cost for Three (3) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
55052 Week TrainingFFP2Each$ -
Cost for Two (2) Sessions
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5506Travel & ODCCost1Lot$ 614,077$ 614,077
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5507Manpower ReportingFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5508Technical Data & InformationFFPEach$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5509Transition OutFFPEach$ -

Subtotal $ 7,934,077

Option Year 5 TO 08
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5801V9.0 - Capability P3ICPIFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5802Tailored Product Baseline ReleaseCPIFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5803Capability ConcurrencyCPFFLot$ -
CLINDESCRIPTIONC TYPEQUANTITYUNITUNIT PRICEAMOUNT
5804Integration, Test, ReleaseCPIFLot$ -

Subtotal $ -

Attachment 3a

BASE PRICING WORKBOOK
Base YR, Task Order 01Base YR, Task Order 02
TypeCLINPriceTypeCLINPrice

Author:

The amounts in this tab will be used to calculate the Total Evaluated Price (TEP). Please note that the costs for the six (6) month extension period will be computed by dividing the proposed costs in the final option year by two (2) and then adding the result to the totals for all CLINs to compute the TEP.CPFF101$0CPFF201$0
FFP102$0CPFF202$0
CPFF103$3,500,000CPFF203$0
FFP104$0CPFF204$0
FFP105$0Total$0
COST106$614,077
FFP107$0
FFP108$0
FFP109$0
Total$4,114,077
Option YR 1, Task Order 01Option YR 1, Task Order 03
TypeCLINPriceTypeCLINPrice
CPFF1101$0CPFF1301$0
FFP1102$0CPFF1302$0
CPFF1103$4,135,000CPFF1303$0
FFP1104$0CPFF1304$0
FFP1105$0Total$0
Cost1106$614,077
FFP1107$0
FFP1108$0
Total$4,749,077
Option YR 2, Task Order 01Option YR 2, Task Order 04
TypeCLINPriceTypeCLINPrice
CPFF2101$0CPIF2401$0
FFP2102$0CPIF2402$0
CPFF2103$7,960,000CPFF2403$0
FFP2104$0CPIF2404$0
FFP2105$0Total$0
Cost2106$614,077
FFP2107$0
FFP2108$0
Total$8,574,077
Option YR 3, Task Order 05Option YR 3, Task Order 06
TypeCLINPriceTypeCLINPrice
CPFF3501$0CPIF3601$0
FFP3502$0CPIF3602$0
CPFF3503$7,545,000CPFF3603$0
FFP3504$0CPIF3604$0
FFP3505$0Total$0
Cost3506$614,077
FFP3507$0
FFP3508$0
Total$8,159,077
Option YR 4, Task Order 05Option YR 4, Task Order 07
TypeCLINPriceTypeCLINPrice
CPFF4501$0CPIF4701$0
FFP4502$0CPIF4702$0
CPFF4503$7,545,000CPFF4703$0
FFP4504$0CPIF4704$0
FFP4505$0Total$0
Cost4506$614,077
FFP4507$0
FFP4508$0
Total$8,159,077
Option YR 5, Task Order 05Option YR 5, Task Order 08
TypeCLINPriceTypeCLINPrice
CPFF5501$0CPIF5801$0
FFP5502$0CPIF5802$0
CPFF5503$7,320,000CPFF5803$0
FFP5504$0CPIF5804$0
FFP5505$0Total$0
Cost5506$614,077
FFP5507$0
FFP5508$0
FFP5509$0
Total$7,934,077

Attachment 3b Offeror's Name: "Offeror"

Rates (and FCCM Factors)Base yearOption
Year 01Option
Year 02Option
Year 03Option
Year 04Option
Year 05Definition and Allocation Base
5.00%5.10%5.20%5.30%5.40%5.35%These rates are samples to show formula breakout.*Identify Where in the Proposal the Basis of Estimate for Each Rate is Located.
Base Labor Rate Escalation
Labor Fringe
Overhead
Material Handing
Subcontractor Handling
G&A
Proposed Fee (Cost CLINs)
Proposed Profit (FFP CLINs)
Instructions:
1. If any of the rates/factors are not used in your indirect rate structures in your accounting system, leave the blocks empty and enter "Not Applicable" in the column titled "Definition and Allocation Base".
2. Each Offeror shall supply their applicable rates for Base and all Seven Option Years and a description and/or calculation of how their rates/factors were developed. That information can be included either below or elsewhere in your Cost/Price Volume.
3. In the " Definition and Allocation Base" column, as a minimum, include a brief comment describing the base used for application of each indirect rate: For example, G&A would be, Total Cost Input, Single Element (Direct Labor Cost) or Value Added (excludes …. and … ).
4. If you have additional rates/factors as part of your indirect rtae structure as defined in your accounting policies and procedures, you can add rows as needed.

Attachment 3c

The offeror will input their base rate for each labor category proposed and then apply indirect rates to demonstrate the development of a fully burdened rate through profit for each category. The offeror can adjust this worksheet as needed to complete the calculation. In the second schedule input the fully burdened rate for each category, for each base and option year. For labor categories proposed by sub-contractors, the prime contractor will identify the labor category as such and input the fully burdened rate in the total column. The sub-contractor will provide their information in a seperate CD.
Offeror's Name:"Offeror"
Fully Burdened Rate Build-upFully Burdened Rate by Category and by Year
Labor CategoryBase Labor RateFringe RateFringe DollarsSub-TotalOverhead RateOverhead DollarsSub-TotalG&A RateG&A DollarsSub-TotalProfitTotalLabor Category (Fully Burdened)Base YearOption
Year 01Option
Year 02Option
Year 03Option
Year 04Option

Year 05

Attachment 3d

Identify the labor categories that will be required, provide description, eduction level and number of years experience.
Labor Traceability Matrix
LABOR CATEGORYDEFINITIONOFFEROR'S LABOR CATEGORYWD LABOR CATEGORY
Program ManagerManages the information systems design, development, and analysis encompassing one or more of the following areas of technical expertise: computer programming, systems analysis, computer programming/analysis, systems analysis, applications programming, software development, systems integration, and related disciplines. Requires xx number of years of experience and x level of education.

File details come from the government source that posted it.