DRAFT_Attachment_L-1_Pricing_Model.xlsx
XLSX spreadsheet 62 KB Posted
- Attached to
- Air Force Cyber Operational Testing, Engineering and Range Support (AFCOTERS) Federal contract opportunity
- Solicitation number
- FA255015R8005
About this file
DRAFT Attachment L-1 Pricing Model
View the file
Other files for this federal contract opportunity
Show all 42
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
INSTRUCTIONS
| INSTRUCTIONS FOR FILLING IN THE LABOR RATE TABLES AND PRICING MODEL WORKSHEETS |
| **Fill in only the blue highlighted areas.** |
All proposed labor categories must be IAW the Government Labor Categories listed in the Labor Rate Tables at Attachment L-2. No other labor categories are allowed.
| Note: All labor categories identified in the Labor Rate Table shall be covered and proposed by either the Prime or a Teaming Partner or both. |
| The Offeror shall ensure that all labor categories are covered but NOT all labor categories must be covered by any one business entity. |
| If Offeror is successful, rates in the Labor Rate Tables for the Prime and each Teaming Partner will be incorporated into the Basic Contract as ceiling rates, at award. |
| Profit is not applicable to Cost Plus Fixed Fee (CPFF) Task Orders. The rates for the current fiscal year at time of award of the task order will be utilized. |
| The rates will not change during the life of the task order. |
| Labor Rate Tables, Attachment L-2, |
| (Unless proposing only one set of rates for the entire team, each contractor proposing on the team must have an Attachment L-2 in the proposal in order for L-1 to be completed correctly.) |
| 1. Input base labor rates for each labor category (as applicable) per Fiscal Year (Column C, Rate Build up Tab, Page 1) |
| 2. Input percentage values required on the Rate Build Up tab (row 5, pages 1-7). |
| 2. Offerors may use Column B to identify any labor category nomenclatures that differ from the Government nomenclatures. |
| 3. Summary FFP Tab: Input Contractor's Name (Row 1). Review data for accuracy only. All values are automatically calculated from data entered into Rate Build Up Tab. |
| Pricing Model, Attachment L-1, Prime only |
| 1. Tabs: Prime -TP7: Fill in column B of these worksheets using the Labor Rate Table (Summary FFP tab, column J "Average") in Attachment L-2, for the Prime Contractor and each Teaming Partner |
1a. Cell A3 - Enter the corresponding Contractor's Name
| 2. Field Average Tab. Review for accurance only. All values are automatically calculated from data entered into the Prime-TP7 tabs. |
| The Government will input the hours in column K which will calculate the total evaluated price for the pricing model. |
The data you enter into Column B of the Prime - TP7 worksheets will automatically calculate a Combined Average (Weighted 50% for the Prime and 50% for combined Teaming Partners) in the Field Average tab.
ALL LOADED LABOR RATES SHALL BE ROUNDED TO THE NEAREST PENNY
&14FA2550-15-R-8005 &"Arial,Bold"&9
&18ATTACHMENT L-1
PRICING MODEL
FIELD AVERAGE
| FIELD AVERAGE | |||||||||||
| FIRM FIXED PRICE LABOR RATES | Enter Contractor Name | Enter Teaming Partner Name | Enter Teaming Partner Name | Enter Teaming Partner Name | Enter Teaming Partner Name | Enter Teaming Partner Name | Enter Teaming Partner Name | Enter Teaming Partner Name | |||
| Proposed Labor | Proposed Labor | Proposed Labor | Proposed Labor | Proposed Labor | Proposed Labor | Proposed Labor | Proposed Labor | Average | Extended | ||
| Rate | Rate | Rate | Rate | Rate | Rate | Rate | Rate | Rate | *Hours | Amount | |
| Government Labor Classification | |||||||||||
| Engineer/Contract Program Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Test Engineer/Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Test Engineer/Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Range Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Range Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Training Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| EMSEC Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Technical Editing Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Data Flow Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Security Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Program Management | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Administrative Support | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Total Evaluated Price | 0 | $0.00 | |||||||||
| * Hours to be input by the Government Evaluation Team | |||||||||||
| Offeror does not input any data into this worksheet |
FA2550-15-R-8005 &"Arial,Bold"&9
ATTACHMENT L-1
PRICING MODEL
Field Average Attachment L-1 Pricing Model, Page 2 of 10
PRIME
| FIRM FIXED PRICE LABOR RATES |
| Enter Contractor Name |
| Government Labor Classification | RATE |
| Engineer/Contract Program Manager | $0.00 |
| Senior Test Engineer/Coordinator | $0.00 |
| Test Engineer/Coordinator | $0.00 |
| Senior Range Engineer | $0.00 |
| Range Technician | $0.00 |
| Training Specialist | $0.00 |
| EMSEC Technician | $0.00 |
| Technical Editing Specialist | $0.00 |
| Data Flow Specialist | $0.00 |
| Security Specialist | $0.00 |
| Program Management | $0.00 |
| Administrative Support | $0.00 |
FA2550-15-R-8005 &9
&"Arial,Bold"ATTACHMENT L-1
PRICING MODEL
Prime Contractor
Pricing Model, Page 3 of 10
TP1
| FIRM FIXED PRICE LABOR RATES |
| Enter Teaming Partner Name |
| Government Labor Classification | RATE |
| Engineer/Contract Program Manager | $0.00 |
| Senior Test Engineer/Coordinator | $0.00 |
| Test Engineer/Coordinator | $0.00 |
| Senior Range Engineer | $0.00 |
| Range Technician | $0.00 |
| Training Specialist | $0.00 |
| EMSEC Technician | $0.00 |
| Technical Editing Specialist | $0.00 |
| Data Flow Specialist | $0.00 |
| Security Specialist | $0.00 |
| Program Management | $0.00 |
| Administrative Support | $0.00 |
W911RZ-15-R-8005 &9
&"Arial,Bold"ATTACHMENT L-1
PRICING MODEL
Teaming Partner #1
Pricing Model, Page 4 of 10
TP2
| FIRM FIXED PRICE LABOR RATES |
| Enter Teaming Partner Name |
| Government Labor Classification | RATE |
| Engineer/Contract Program Manager | $0.00 |
| Senior Test Engineer/Coordinator | $0.00 |
| Test Engineer/Coordinator | $0.00 |
| Senior Range Engineer | $0.00 |
| Range Technician | $0.00 |
| Training Specialist | $0.00 |
| EMSEC Technician | $0.00 |
| Technical Editing Specialist | $0.00 |
| Data Flow Specialist | $0.00 |
| Security Specialist | $0.00 |
| Program Management | $0.00 |
| Administrative Support | $0.00 |
FA2550-15-R-8005 &9
&"Arial,Bold"ATTACHMENT L-1
PRICING MODEL
Teaming Partner #2
Pricing Model, Page 5 of 10
TP3
| FIRM FIXED PRICE LABOR RATES |
| Enter Teaming Partner Name |
| Government Labor Classification | RATE |
| Engineer/Contract Program Manager | $0.00 |
| Senior Test Engineer/Coordinator | $0.00 |
| Test Engineer/Coordinator | $0.00 |
| Senior Range Engineer | $0.00 |
| Range Technician | $0.00 |
| Training Specialist | $0.00 |
| EMSEC Technician | $0.00 |
| Technical Editing Specialist | $0.00 |
| Data Flow Specialist | $0.00 |
| Security Specialist | $0.00 |
| Program Management | $0.00 |
| Administrative Support | $0.00 |
FA2550-15-R-8005 &9
&"Arial,Bold"ATTACHMENT L-1
PRICING MODEL
Teaming Partner #3
Pricing Model, Page 6 of 10
TP4
| FIRM FIXED PRICE LABOR RATES |
| Enter Teaming Partner Name |
| Government Labor Classification | RATE |
| Engineer/Contract Program Manager | $0.00 |
| Senior Test Engineer/Coordinator | $0.00 |
| Test Engineer/Coordinator | $0.00 |
| Senior Range Engineer | $0.00 |
| Range Technician | $0.00 |
| Training Specialist | $0.00 |
| EMSEC Technician | $0.00 |
| Technical Editing Specialist | $0.00 |
| Data Flow Specialist | $0.00 |
| Security Specialist | $0.00 |
| Program Management | $0.00 |
| Administrative Support | $0.00 |
FA2550-15-R-8005 &9
&"Arial,Bold"ATTACHMENT L-1
PRICING MODEL
Teaming Partner #4
Pricing Model, Page 7 of 10
TP5
| FIRM FIXED PRICE LABOR RATES |
| Enter Teaming Partner Name |
| Government Labor Classification | RATE |
| Engineer/Contract Program Manager | $0.00 |
| Senior Test Engineer/Coordinator | $0.00 |
| Test Engineer/Coordinator | $0.00 |
| Senior Range Engineer | $0.00 |
| Range Technician | $0.00 |
| Training Specialist | $0.00 |
| EMSEC Technician | $0.00 |
| Technical Editing Specialist | $0.00 |
| Data Flow Specialist | $0.00 |
| Security Specialist | $0.00 |
| Program Management | $0.00 |
| Administrative Support | $0.00 |
FA2550-15-R-8005 &9
&"Arial,Bold"ATTACHMENT L-1
PRICING MODEL
Teaming Partner #5
Pricing Model, Page 8 of 10
TP6
| FIRM FIXED PRICE LABOR RATES |
| Enter Teaming Partner Name |
| Government Labor Classification | RATE |
| Engineer/Contract Program Manager | $0.00 |
| Senior Test Engineer/Coordinator | $0.00 |
| Test Engineer/Coordinator | $0.00 |
| Senior Range Engineer | $0.00 |
| Range Technician | $0.00 |
| Training Specialist | $0.00 |
| EMSEC Technician | $0.00 |
| Technical Editing Specialist | $0.00 |
| Data Flow Specialist | $0.00 |
| Security Specialist | $0.00 |
| Program Management | $0.00 |
| Administrative Support | $0.00 |
FA2550-15-R-8005 &9
&"Arial,Bold"ATTACHMENT L-1
PRICING MODEL
Teaming Partner #6
Pricing Model, Page 9 of 10
TP7
| FIRM FIXED PRICE LABOR RATES |
| Enter Teaming Partner Name |
| Government Labor Classification | RATE |
| Engineer/Contract Program Manager | $0.00 |
| Senior Test Engineer/Coordinator | $0.00 |
| Test Engineer/Coordinator | $0.00 |
| Senior Range Engineer | $0.00 |
| Range Technician | $0.00 |
| Training Specialist | $0.00 |
| EMSEC Technician | $0.00 |
| Technical Editing Specialist | $0.00 |
| Data Flow Specialist | $0.00 |
| Security Specialist | $0.00 |
| Program Management | $0.00 |
| Administrative Support | $0.00 |
FA2550-15-R-8005 &9
&"Arial,Bold"ATTACHMENT L-1
PRICING MODEL
Teaming Partner #7
Pricing Model, Page 10 of 10
File details come from the government source that posted it. Updated .