Attachment_4_-_Total_Evaluated_Price_Worksheet.xlsx
XLSX spreadsheet 37 KB Posted
- Attached to
- RFP for Aircrew Instruction Support Services Federal contract opportunity
- Solicitation number
- FA0021-16-R-0002
About this file
Attachment 4 draft
View the file
Other files for this federal contract opportunity
Show all 50
RFP for Aircrew Instruction Support Services has more files on GovTribe.
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
Sheet1
| AFSOAWC Instructors Support |
| AFICA/765 SCONF |
| TOTAL EVALUATED PRICE WORKSHEET |
Instruction(s): Fill-in table below with Offeror's proposed FBLR or Rate on the for the labor categories or other cost rates below.
This table is color coded as defined below
- Fill-in Field(s) - Pre-determined value.
- Auto-calculated Field(s) - Total Evaluated Price (Auto-calculated Field)
| # | PWS LABOR CATEGORY | Start Date | BASE YEAR (YEAR 1) | OPTION 1 (YEAR 2) | OPTION 2 (YEAR 3) | FAR 52.215-8 Option | % Subcontracted | ||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | Q | ||||
| HRS or QTY | # of CMEs | FBLR or Rate | Proposed Price | # of CMEs | FBLR or Rate | Proposed Price | # of CMEs | FBLR or Rate | Proposed Price | # of CMEs | FBLR or Rate | Proposed Price | TOTAL | ||||
| A*B*C | AX*E*F | AX*H*I | (AX/2)*K*L | Sum (D,G,J,M,P) | |||||||||||||
| X | FULL YEAR HOURS | 1,880 | |||||||||||||||
| 1 | AC-130U IP (HRT) | 1-Feb-16 | 1,727 | 4 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 2 | AC-130U IN (HRT) | 1-Feb-16 | 1,727 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| 3 | AC-130U FCO (HRT) | 1-Feb-16 | 1,727 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| 4 | AC-130U EWO (HRT) | 1-Feb-16 | 1,727 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 5 | AC-130U Sensor (HRT) | 1-Feb-16 | 1,727 | 6 | $ - 0 | 6 | $ - 0 | 6 | $ - 0 | 6 | $0.00 | $ - 0 | $ - 0 | ||||
| 6 | AC-130U FE (HRT) | 1-Feb-16 | 1,727 | 4 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 7 | AC-130U SMA Gunner (HRT) | 1-Feb-16 | 1,727 | 4 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 8 | MC-130H IP (HRT) | 1-Feb-16 | 1,727 | 2 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 9 | MC-130H IN (HRT) | 1-Feb-16 | 1,727 | 2 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 10 | MC-130H EW (HRT) | 1-Feb-16 | 1,727 | 2 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 11 | MC-130H FE (HRT) | 1-Feb-16 | 1,727 | 2 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 12 | MC-130H LM (HRT) | 1-Feb-16 | 1,727 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 13 | MC-130H IP (HRT) | 1-Apr-16 | 1,458 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 14 | MC-130H IN (HRT) | 1-Apr-16 | 1,458 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 15 | MC-130H EW (HRT) | 1-Apr-16 | 1,458 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 16 | MC-130H FE (HRT) | 1-Apr-16 | 1,458 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 17 | MC-130H IP (HRT) | 1-Mar-16 | 1,620 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 18 | MC-130H IN (HRT) | 1-Mar-16 | 1,620 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 19 | MC-130H EW (HRT) | 1-Mar-16 | 1,620 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 20 | MC-130H FE (HRT) | 1-Mar-16 | 1,620 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 21 | U-28A IP CFI (HRT) | 1-Feb-16 | 1,727 | 15 | $ - 0 | 15 | $ - 0 | 15 | $ - 0 | 15 | $0.00 | $ - 0 | $ - 0 | ||||
| 22 | U-28A ICSO (HRT) | 1-Feb-16 | 1,727 | 7 | $ - 0 | 7 | $ - 0 | 7 | $ - 0 | 7 | $0.00 | $ - 0 | $ - 0 | ||||
| 23 | RPA IP (CVS) | 1-Jan-16 | 1,880 | 7 | $ - 0 | 7 | $ - 0 | 7 | $ - 0 | 7 | $0.00 | $ - 0 | $ - 0 | ||||
| 24 | RPA SO (CVS) | 1-Jan-16 | 1,880 | 7 | $ - 0 | 7 | $ - 0 | 7 | $ - 0 | 7 | $0.00 | $ - 0 | $ - 0 | ||||
| 25 | AC-130W IP (CVS) | 1-Jan-16 | 1,880 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 26 | AC-130W CSO (CVS) | 1-Jan-16 | 1,880 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| 27 | AC-130W FE (CVS) | 1-Jan-16 | 1,880 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 28 | AC-130W LM /Gunner (CVS) | 1-Jan-16 | 1,880 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 29 | Radio Operation Instructor HRT | 1-Feb-16 | 1,727 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $0.00 | $ - 0 | $ - 0 | ||||
| 30 | AC-130J IP (HRT) | 1-Jan-17 | 1,880 | 0 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| 31 | AC-130J ICSO (HRT) | 1-Jan-17 | 1,880 | 0 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| 32 | AC-130J I FCO (HRT) | 1-Jan-17 | 1,880 | 0 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 33 | AC-130J I AG (HRT) | 1-Jan-17 | 1,880 | 0 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $0.00 | $ - 0 | $ - 0 | ||||
| 34 | C-146 IP (Duke) | 1-Jan-17 | 1,880 | 0 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $0.00 | $ - 0 | $ - 0 | ||||
| 35 | C-146 Inst LM (Duke) | 1-Jan-17 | 1,880 | 0 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| 36 | MDS / Training Integrators (HRT) (Non-CBA) | 1-Feb-16 | 1,727 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| 37 | MDS Training Integrators (CVS) (Non-CBA) | 1-Jan-16 | 1,880 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 38 | MC-130J IP (CVS) | Unkown | 1,880 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 39 | MC-130J ICSO (CVS) | Unkown | 1,880 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 40 | MC-130J I LM (CVS) | Unkown | 1,880 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 41 | Weapon System Lead (AC-130W) | 1-Jan-16 | 1,880 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $0.00 | $ - 0 | $ - 0 | ||||
| 42 | Weapon System Lead (AC-130U, MC-130H, U-28) | 1-Feb-16 | 1,727 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| X001 Labor Cost Firm Fixed Price | 95 | $ - 0 | 116 | $ - 0 | 116 | $ - 0 | 116 | $ - 0 | $ - 0 | 0.00% | |||||||
| X002 Labor Cost - Flight Operations | 1-Jan-16 | 41,360 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| X003 Labor Cost - Shift Two Pay Premium | 1-Jan-16 | 40,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| X004 Labor Cost - Shift Three Pay Premium | 1-Jan-16 | 40,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| X005 Overtime | 1-Jan-16 | NA | $ 5,000.00 | $ 5,000.00 | $ 5,000.00 | $ 2,500.00 | $ 17,500.00 | ||||||||||
| X006 Travel - Cost Reimbursable | 1-Jan-16 | NA | $ 75,000.00 | $ 75,000.00 | $ 75,000.00 | $ 37,500.00 | $ 262,500.00 | ||||||||||
| X007 Materials - Cost Reimbursable | 2-Jan-16 | NA | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 12,500.00 | $ 87,500.00 | ||||||||||
| X008 DATA (NSP) | 3-Jan-16 | NSP | NSP | NSP | NSP | NSP | NSP | ||||||||||
| X009 NMGRT (EST) | 1-Jan-16 | NA | |||||||||||||||
| TOTAL EVALUATED PRICE | $ 105,000.00 | $ 105,000.00 | $ 105,000.00 | $ 52,500.00 | $ 367,500.00 |
FA0021-16-R-0002
13 October 2015 Attachment 4
&P of &N
Sheet3 image1.png
File details come from the government source that posted it. Updated .