Attachment 8 CSTA_Price_Workbook rev2 19 Apr 24.xlsx
XLSX spreadsheet 44 KB Posted
- Attached to
- ARNORTH CSTA Training Support Services
- Solicitation number
- W900KK24R0023
About this file
This document is a pricing workbook template for a federal contract opportunity related to the ARNORTH Civil Support Training Activity (CSTA) Training Support Services. The workbook provides instructions for offerors to populate unit prices and amounts for various contract line items (CLINs), including program management, labor, travel, materials/ODCs, and other items. The workbook includes a total evaluated price (TEP) that sums the proposed firm-fixed-price CLINs and pre-populated cost-reimbursable CLINs. The opportunity is for a base year with four option years, and includes a six-month extension option. The solicitation number is W900KK24R0023, and the opportunity type is a pre-solicitation. The primary contracting point of contact is Will Bass, and the secondary is Phil Davis.
View the file
Other files
Show all 39
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
Instructions
| Instructions - CSTA Pricing Workbook |
| Offerors are to populate the unit price when applicable or the amount cells within the TEP Tab except for the CLINs where NTE amounts have already been provided, or if the CLIN has been identified as Not Seperately priced (NSP). |
The prepopulated dollar values are derived from Government estimates of cost-reimbursable type effort. These estimates will be included within the Total Evaluated Price, but are only estimates and are not to be edited by the offeror. The optional 6 month extension will be automatically calculated by multiplying the previous ordering period by one half.
The Total Evaluated Price (TEP) will be automatically calculated and includes the sum of all of the proposed FFP CLINs and the pre-populated values provided by the Government.
Offerors may make adjustments to the tabs to accomodate subcontractor rates, or their unique business structure, please note that the Offeror is responsible for maintaining the accuracy of the model, errors found in the workbook determined to be the fault of the offeror may make them subject to elimination.
TEP
CSTA
ITEM NO SUPPLIES/SERVICES CLIN TYPE QUANTITY UNIT UNIT PRICE AMOUNT
| Base Year | ||||||
| 0001 | Program Management | FFP | 12 | Months | $ - 0 | |
| 0002 | Labor (Full-time effort) | FFP | 12 | Months | $ - 0 | |
| 0003 | Labor ( Part-time effort) | CPFF | 12 | Months | $ - 0 | |
| 0004 | Travel | Cost | 12 | Months | $ 3,128,948 | |
| 0005 | Material/ODC | Cost | 12 | Months | $ 1,714,241 | |
| 0006 | Service Contract Reporting | NSP | 1 | Lot | $ - 0 | |
| 0007 | CDRLs | NSP | 1 | Lot | $ - 0 | |
| 0008 | CAP ADMIN | NSP | 1 | Lot | $ - 0 | |
| Total | $ 4,843,189 | |||||
| Option Year 1 | ||||||
| 1001 | Program Management | FFP | 12 | Months | $ - 0 | |
| 1002 | Labor (Full-time effort) | FFP | 12 | Months | $ - 0 | |
| 1003 | Labor ( Part-time effort) | CPFF | 12 | Months | $ - 0 | |
| 1004 | Travel | Cost | 12 | Months | $ 3,191,527 | |
| 1005 | Material/ODC | Cost | 12 | Months | $ 1,748,526 | |
| 1006 | Service Contract Reporting | NSP | 1 | Lot | $ - 0 | |
| 1007 | CDRLs | NSP | 1 | Lot | ||
| 1008 | CAP ADMIN | NSP | 1 | Lot | ||
| Total | $ 4,940,053 | |||||
| Option Year2 | ||||||
| 2001 | Program Management | FFP | 12 | Months | ||
| 2002 | Labor (Full-time effort) | FFP | 12 | Months | ||
| 2003 | Labor ( Part-time effort) | CPFF | 12 | Months | ||
| 2004 | Travel | Cost | 12 | Months | $ 3,255,357 | |
| 2005 | Material/ODC | Cost | 12 | Months | $ 1,783,496 | |
| 2006 | Service Contract Reporting | NSP | 1 | Lot | ||
| 2007 | CDRLs | NSP | 1 | Lot | ||
| 2008 | CAP ADMIN | NSP | 1 | Lot | ||
| Total | $ 5,038,853 | |||||
| Option Year3 | ||||||
| 3001 | Program Management | FFP | 12 | Months | ||
| 3002 | Labor (Full-time effort) | FFP | 12 | Months | ||
| 3003 | Labor ( Part-time effort) | CPFF | 12 | Months | ||
| 3004 | Travel | Cost | 12 | Months | $ 3,320,465 | |
| 3005 | Material/ODC | Cost | 12 | Months | $ 1,819,166 | |
| 3006 | Service Contract Reporting | NSP | 1 | Lot | ||
| 3007 | CDRLs | NSP | 1 | Lot | ||
| 3008 | CAP ADMIN | NSP | 1 | Lot | ||
| Total | $ 5,139,631 | |||||
| Option Year 4 | ||||||
| 4001 | Program Management | FFP | 12 | Months | ||
| 4002 | Labor (Full-time effort) | FFP | 12 | Months | ||
| 4003 | Labor ( Part-time effort) | CPFF | 12 | Months | ||
| 4004 | Travel | Cost | 12 | Months | $ 3,386,874 | |
| 4005 | Material/ODC | Cost | 12 | Months | $ 1,855,549 | |
| 4006 | Service Contract Reporting | NSP | 1 | Lot | ||
| 4007 | CDRLs | NSP | 1 | Lot | ||
| 4008 | CAP ADMIN | NSP | 1 | Lot | ||
| Total | $ 5,242,423 |
| Base and Option Years Grand Total | $ 25,204,149 | |||||
| Six (6) Month Extension (FAR 52.217-8) | $ 2,621,212 | |||||
| TEP | CSTA | |||||
| Total Evaluated Price | TEP Total | $ 27,825,361 | ||||
| *NSP= Not Separately Priced |
Indirect Rates Offeror's Name:
| Rates | Base Period (2 Year Period of Performance) | Option 1 Period (2 Year Period of Performance) | Option 2 Period (2 Year Period of Performance) | Option 3 Period (1 Year Period of Performance) | Option 4 Period (1 Year Period of Performance) | Option 5 Period (1 Year Period of Performance) | Option 6 Period (1 Year Period of Performance) | Definition and Allocation Base | |
| Example | 5.00% | 5.10% | 5.20% | 5.30% | 5.40% | 5.40% | 5.30% | 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 - Customer Facility | |||||||||
| Material Handing | |||||||||
| Subcontractor Handling | |||||||||
| G&A | |||||||||
| Proposed Fee (CPFF) | |||||||||
| Proposed Profit (FFP) | |||||||||
| 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 all 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 … ). Overhead may be direct labor or direct labor plus fringe. | |||||||||
| 4. If you have additional rates/factors as part of your indirect rate structure as defined in your accounting policies and procedures, you can add rows as needed. |
Labor Rates - FFP Bulidup
In the first section (Columns B-N) the offeror will input their base rate for the Base Period each labor category proposed and then apply indirect rates to demonstrate the development of the fully burdened rate through profit for the Base Period. The offeror can adjust this worksheet as needed to complete the calculation. In the second section (Columns Q-T) input the fully burdened rate for each category, for each base and option period. The Offeror will identify the labor categories subject to Wage Determination Rates based on the Service Contract Act (ECA). IF APPLICABLE, INSERT ANY OVERTIME PREMIUM INTO COLUMN P and the calculated overtime hourly rate in column Q.
| Offeror's Name: | ||||||||||||||||||||||||
| Base Period Fully Burdened Rate Build-up | Fully Burdened Straight Rates | Fully Burdened Overtime Rates | ||||||||||||||||||||||
| Offeror Description | Description | SOW / PWS Reference | Base Labor Rate | Fringe Rate | Fringe Dollars | Sub-Total | Overhead Rate | Overhead Dollars | Sub-Total | G&A Rate | G&A Dollars | Sub-Total | Profit | Total | Applicable Overtime Premium | Overtime Hourly Rate | Year 2 (1 Year Period of Performance) | Year 3 (1 Year Period of Performance) | Year 4 (1 Year Period of Performance) | Year 5 (1 Year Period of Performance) | Year 2 (1 Year Period of Performance) | Year 3 (1 Year Period of Performance) | Year 4 (1 Year Period of Performance) | Year 5 (1 Year Period of Performance) |
| Full Time | ||||||||||||||||||||||||
| Tech Decon | 5.2.2.1 - 5.2.2.1.3 | |||||||||||||||||||||||
| Bn Mission Command | 5.2.2.2 - 5.2.2.2.3 | |||||||||||||||||||||||
| Exercise Analyst | 5.2.2.2 - 5.2.2.2.3 | |||||||||||||||||||||||
| CBRN Decon | 5.2.2.2 - 5.2.2.2.3, 5.2.2.3 - 5.2.2.3.3, 5.2.2.5 & 5.2.2.5.9, 5.2.2.4 - 5.2.2.4.3 | |||||||||||||||||||||||
| Medical SME | 5.2.2.2 - 5.2.2.2.3, 5.2.2.3 - 5.2.2.3.3 | |||||||||||||||||||||||
| US&R Analyst | 5.2.2.5 & 5.2.2.5.9 | |||||||||||||||||||||||
| CBRN Sr. Survey Eval Analyst | 5.2.2.4 - 5.2.2.4.3 | |||||||||||||||||||||||
| Information Tech Spec | 5.2.2.6. - 5.2.2.6.1 | |||||||||||||||||||||||
| CBRN Exercise Spc/Planner | 5.2.2.6. - 5.2.2.6.1 | |||||||||||||||||||||||
| Project Manager | 5.2.1.1 |
Labor Rates - CPFF Bulidup
In the first section (Columns B-N) the offeror will input their base rate for the Base Period each labor category proposed and then apply indirect rates to demonstrate the development of the fully burdened rate through fee for the Base Period. The offeror can adjust this worksheet as needed to complete the calculation. In the second section (Columns Q-T) input the fully burdened rate for each category, for each base and option period. The Offeror will identify the labor categories subject to Wage Determination Rates based on the Service Contract Act (ECA). IF APPLICABLE, INSERT ANY OVERTIME PREMIUM INTO COLUMN P and the calculated overtime hourly rate in column Q.
| Offeror's Name: | ||||||||||||||||||||||||
| Base Period Fully Burdened Rate Build-up | Fully Burdened Straight Rates | Fully Burdened Overtime Rates | ||||||||||||||||||||||
| Offeror Description | Description | SOW / PWS Reference | Base Labor Rate | Fringe Rate | Fringe Dollars | Sub-Total | Overhead Rate | Overhead Dollars | Sub-Total | G&A Rate | G&A Dollars | Sub-Total | Fee | Total | Applicable Overtime Premium | Overtime Hourly Rate | Year 2 (1 Year Period of Performance) | Year 3 (1 Year Period of Performance) | Year 4 (1 Year Period of Performance) | Year 5 (1 Year Period of Performance) | Year 2 (1 Year Period of Performance) | Year 3 (1 Year Period of Performance) | Year 4 (1 Year Period of Performance) | Year 5 (1 Year Period of Performance) |
| Full Time | ||||||||||||||||||||||||
| Tech Decon | 5.2.2.1 - 5.2.2.1.3 | |||||||||||||||||||||||
| Bn Mission Command | 5.2.2.2 - 5.2.2.2.3 | |||||||||||||||||||||||
| Exercise Analyst | 5.2.2.2 - 5.2.2.2.3 | |||||||||||||||||||||||
| CBRN Decon | 5.2.2.2 - 5.2.2.2.3, 5.2.2.3 - 5.2.2.3.3, 5.2.2.5 & 5.2.2.5.9, 5.2.2.4 - 5.2.2.4.3 | |||||||||||||||||||||||
| Medical SME | 5.2.2.2 - 5.2.2.2.3, 5.2.2.3 - 5.2.2.3.3 | |||||||||||||||||||||||
| US&R Analyst | 5.2.2.5 & 5.2.2.5.9 | |||||||||||||||||||||||
| CBRN Sr. Survey Eval Analyst | 5.2.2.4 - 5.2.2.4.3 | |||||||||||||||||||||||
| Information Tech Spec | 5.2.2.6. - 5.2.2.6.1 | |||||||||||||||||||||||
| CBRN Exercise Spc/Planner | 5.2.2.6. - 5.2.2.6.1 | |||||||||||||||||||||||
| Project Manager | 5.2.1.1 |
| Part Time | |
| Information Tech Spec | 5.2.2.2.4 -5.2.2.2.5, 5.2.2.3.4, 5.2.2.4.4 |
| US&R Analyst | 5.2.2.2.4 -5.2.2.2.5 |
| CBRN Decon | 5.2.2.2.4 -5.2.2.2.5 |
| Bn Mission Command SUPV | 5.2.2.2.4 -5.2.2.2.5 |
| Group SPV (MCD) | 5.2.2.3.4, 5.2.2.4.4 |
| Safety (MCD) | 5.2.2.3.4, 5.2.2.4.4 |
| Role Player MGR | 5.2.2.3.4, 5.2.2.4.4 |
| CCP MED SME | 5.2.2.3.4, 5.2.2.4.4 |
| MCD MED SME | 5.2.2.3.4, 5.2.2.4.4 |
| MCD Power/Water | 5.2.2.3.4, 5.2.2.4.4 |
| CBRN Decon | 5.2.2.3.4, 5.2.2.4.4 |
| MCD Ops SME | 5.2.2.3.4, 5.2.2.4.4 |
| Group SPV (RECON) | 5.2.2.3.4, 5.2.2.4.4 |
| Safety (RECON) | 5.2.2.3.4, 5.2.2.4.4 |
| MED SME | 5.2.2.3.4, 5.2.2.4.4 |
| RECON SME | 5.2.2.3.4, 5.2.2.4.4 |
| Role Players | 5.2.2.3.4, 5.2.2.4.4 |
| Group SPV | 5.2.2.5.10 |
| CBRN RECON Safety | 5.2.2.5.10 |
| Tech Rescue SME | 5.2.2.5.10, 5.2.2.5.10 |
| CBRN Exercise Spc/Planner | 5.2.2.6.2 |
File details come from the government source that posted it. Updated .