Attachment_4_-_Total_Evaluated_Price_Worksheet_20_Oct_2015.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- RFP for Aircrew Instruction Support Services
- Solicitation number
- FA0021-16-R-0002
About this file
Attachment 4
View the file
Other files
Show 40 more
Latest 50 of 88 listed here. See the rest on GovTribe.
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
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 .