Attachment_4_-_Total_Evaluated_Price_Worksheet_20_Oct_2015.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- RFP for Aircrew Instruction Support Services Federal contract opportunity
- Solicitation number
- FA0021-16-R-0002
About this file
Attachment 4
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 IFCO (HRT) | 1-Feb-16 | 1,727 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| 4 | AC-130U IEWO (HRT) | 1-Feb-16 | 1,727 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 5 | AC-130U ISO (HRT) | 1-Feb-16 | 1,727 | 6 | $ - 0 | 6 | $ - 0 | 6 | $ - 0 | 6 | $0.00 | $ - 0 | $ - 0 | ||||
| 6 | AC-130U IFE (HRT) | 1-Feb-16 | 1,727 | 4 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 7 | AC-130U SMA IAG (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 IEWO (HRT) | 1-Feb-16 | 1,727 | 2 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 11 | MC-130H IFE (HRT) | 1-Feb-16 | 1,727 | 2 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $0.00 | $ - 0 | $ - 0 | ||||
| 12 | MC-130H ILM (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 IEWO (HRT) | 1-Apr-16 | 1,458 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 16 | MC-130H IFE (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 IEWO (HRT) | 1-Mar-16 | 1,620 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 20 | MC-130H IFE (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 ISO (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 ICSO (CVS) | 1-Jan-16 | 1,880 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $0.00 | $ - 0 | $ - 0 | ||||
| 27 | AC-130W IFE (CVS) | 1-Jan-16 | 1,880 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 28 | AC-130W ILM/IAG (CVS) | 1-Jan-16 | 1,880 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 29 | IRO (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 IFCO (HRT) | 1-Jan-17 | 1,880 | 0 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 33 | AC-130J IAG (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 ILM (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 ILM (CVS) | Unkown | 1,880 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | ||||
| 41 | Subtotal Labor Cost Firm Fixed Price | 95 | $ - 0 | 116 | $ - 0 | 116 | $ - 0 | 116 | $ - 0 | $ - 0 | 0.00% | ||||||
| Additional Duties with Differential Pay (Per PWS paragraph 2.1.6, Contractor must designate weapon system leads for AC-130U, MC-130H, U-28, RPA, and AC-130W of the 95 CMEs for Base year or of the 116 CMEs for Option 1 and 2) | |||||||||||||||||
| 42 | Weapon System Lead (AC-130W and RPA) | 1-Jan-16 | 1,880 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | ||||
| 43 | 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 | ||||
| 44 | Subtotal Weapon Leads Add' Duty Differential Pay | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | $ - 0 | |||||||
| 45 | X001 Labor Cost Firm Fixed Price | 95 | $ - 0 | 116 | $ - 0 | 116 | $ - 0 | 116 | $ - 0 | $ - 0 | 0.00% | ||||||
| 46 | X002 Labor Cost - Flight Operations | 1-Jan-16 | 41,360 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| 47 | X003 Labor Cost - Shift Two Pay Premium | 1-Jan-16 | 40,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| 48 | X004 Labor Cost - Shift Three Pay Premium | 1-Jan-16 | 40,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| 49 | X005 Labor Cost - Altered Workweek | 1-Jan-16 | |||||||||||||||
| 50 | X006 Overtime, Callback, and Observer Pay | 1-Jan-16 | NA | TBD | TBD | TBD | TBD | $ - 0 | |||||||||
| 51 | X007 Travel - Cost Reimbursable | 1-Jan-16 | NA | $ 75,000.00 | $ 75,000.00 | $ 75,000.00 | $ 37,500.00 | $ 262,500.00 | |||||||||
| 52 | X008 Materials - Cost Reimbursable | 1-Jan-16 | NA | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 12,500.00 | $ 87,500.00 | |||||||||
| 53 | X009 DATA (NSP) | 1-Jan-16 | NSP | NSP | NSP | NSP | NSP | NSP | |||||||||
| 54 | X010 NMGRT (EST) | 1-Jan-16 | NA | ||||||||||||||
| 55 | TOTAL EVALUATED PRICE | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 50,000.00 | $ 350,000.00 |
FA0021-16-R-0002
23 October 2015 Attachment 4
&P of &N
Sheet3
File details come from the government source that posted it. Updated .