DRAFT_Attachment_4_Cost_Price_Proposal_FIAR.xlsx

XLSX spreadsheet 63 KB Posted

Attached to
Financial Improvement & Audit Readiness (FIAR) Follow-on Support Federal contract opportunity
Solicitation number
FA7014-17-R-5002
Issued by
Department of the Air Force Headquarters District Washington

About this file

DRAFT Cost/Price Proposal Worksheet

View the file

Other files for this federal contract opportunity

Other files attached to Financial Improvement & Audit Readiness (FIAR) Follow-on Support, newest first.
File Type Posted
FA7014-17-R-5002_AMENDMENT_0005.pdf PDF
Attachment_4_-_IDIQ_Pricing_Sheet_20171002.xlsx XLSX spreadsheet
TO_Request_Form_Attachment_5f_SMC-AFSPC_(Task_Order_6).xlsx XLSX spreadsheet
TO_Request_Form_Attachment_5c_AFSPC_(Task_Order_3).xlsx XLSX spreadsheet
AF_FIAR__Follow-on_Proposal_Additional_Question_Response_FINAL.pdf PDF
TO_Request_Form_Attachment_5a_SAF-FM_(Task_Order_1).xlsx XLSX spreadsheet
PWS_ATTACHMENT_D_-_Feeder_Systems_-_Updated.doc.xlsx XLSX spreadsheet
Attachment_6_-_Past_Performance_Information_Form_(26_Sep_17).docx DOCX document
TO_Request_Form_Attachment_5b_AFMC_(Task_Order_2).xlsx XLSX spreadsheet
FA7014-17-R-5002_Solicitation.pdf PDF
Attachment_9_AF_FIAR_PWS_FINAL_20171004.pdf PDF
Attachment_4_-_IDIQ_Pricing_Sheet_20171002.xlsx XLSX spreadsheet
TO_Request_Form_Attachment_5d_AFMC_(Task_Order_4).xlsx XLSX spreadsheet
Attachment_3_Sample_Cross_Reference_Matrix_(Updated_7_Aug_17).docx DOCX document
FA7014-17-R-5002_-_USAF_FIAR_Follow_On_Support_QAs_FINAL_20171004.pdf PDF
Attachment_2_-_Addendum_to_52.212-2_FIAR_20171003.pdf PDF
TO_Request_Form_Attachment_5a_SAF-FM_(Task_Order_1).xlsx XLSX spreadsheet
Attachment_11_-_FIAR_ORDERING_GUIDE_FINAL.pdf PDF
Attachment_1_-_Addendum_to_52.212-1_FIAR_FINAL_(28_Sep_17).docx DOCX document
FA7014-17-R-5002.pdf PDF
Attachment_10_QASP_Appendix_A_-_Deliverables_SS_Table.docx DOCX document
PWS_ATTACHMENT_G1_-__SAF-FM_Assessable_Units.docx DOCX document
TO_Request_Form_Attachment_5f_SMC-AFSPC_(Task_Order_6).xlsx XLSX spreadsheet
Attachment_7_-_FIAR__Past_Perf_Questionnaire_Cover_Final.pdf PDF
Order_Guide_Attach_B_-_Labor_Categories_FINAL.doc DOC document
Attachment_4_-_IDIQ_Pricing_Sheet_(Updated_7_Aug_17).xlsx XLSX spreadsheet
FA7014-17-R-5002_Atch1_Item_13_Final.pdf PDF
Attachment_3_Sample_Cross_Reference_Matrix_(Updated_7_Aug_17).docx DOCX document
Attachment_6_-_Past_Performance_Information_Form_(Updated_7_Aug_17).docx DOCX document
Attachment_8_-_Client_Authorization_Letter_(Updated_7_Aug_17).docx DOCX document
Attachment_2_-_Addendum_to_52.212-2_FIAR_FINAL.pdf PDF
Attachment_11_-_FIAR_ORDERING_GUIDE_FINAL.pdf PDF
FA7014-17-R-5002_Atch_2_Item_10_FA7014-17-R-5002_Final.pdf PDF
TO_Request_Form_Attachment_5c_AFSPC_(Task_Order_3).xlsx XLSX spreadsheet
FA7014-17-R-5002.pdf PDF
TO_Request_Form_Attachment_5a_SAF-FM_(Task_Order_1).xlsx XLSX spreadsheet
TO_Request_Form_Attachment_5b_AFMC_(Task_Order_2).xlsx XLSX spreadsheet
PWS_ATTACHMENT_D_-_Feeder_Systems.doc.xlsx XLSX spreadsheet
FA7014-17-R-5002_DD254_Version_2.pdf PDF
DRAFT_Attachment_6_-_Past_Performance_Information_Form_(Updated_7_Aug_17).docx DOCX document
DRAFT_Attachment_8_-_Client_Authorization_Letter_(Updated_7_Aug_17).docx DOCX document
DRAFT_Attachment_1_-_Addendum_to_52_212-1_FIAR_(Updated_7_Aug_17).docx DOCX document
DRAFT_Attachment_3_Sample_Cross_Reference_Matrix_(Updated_7_Aug_17).docx DOCX document
DRAFT_FIAR_ORDERING_GUIDE.docx DOCX document
DRAFT_Addendum_to_52_212-1_FIAR.docx DOCX document
DRAFT_FIAR_-_OCI_Proivision_Clause.docx DOCX document
FIAR_Follow-On_RFI_-_22_Dec_16.pdf PDF
Labor_Categories_Descriptions_-_22_Dec_16.pdf PDF
Questions_to_Industry_-_22_Dec_16.pdf PDF
DRAFT_-_AF_FIAR_PWS_IDIQ_22_Dec_16.pdf PDF
Show all 50

Financial Improvement & Audit Readiness (FIAR) Follow-on Support 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

Instructions V2.0

DRAFT

Instructions: This format shall be used for all Price Proposals for OASIS Task Orders (TO), unless the Government provides a separate template with the TO solicitation. As a minimum, offerors shall fill in the items in blue (blue text or text box filled in blue), as applicable to the requirement.

1. General:

a. It is the offeror's responsibility to ensure all columns and rows with formulas calculate correctly and provide a true representation of the proposed effort.

b. The Core FTE sheet will only include proposed pricing for all FTEs required by the effort (i.e., those other than optional).

c. The Optional FTE sheet will only include proposed pricing for all optional FTEs.

2. 2nd Row: Complete areas in red font - Name of Offeror

3. Insert PoPs Row (2nd Row): Completed with POP

4. Labor Category: Insert the titles of applicable labor categories and, in parentheses, include the task(s) to which they apply and the number of FTEs in the labor category working on that task(s). For example: Program Manager (task 3.2 (2 FTEs), task 3.5 (1 FTE)) as an example. If there are more than four labor categories proposed, copy one of the previous grouping of rows (for example rows 31-39) and insert at the bottom. Repeat as many times as required. If less that four labor categories are required, offers may delete additional rows not required.

5. Est. Hrs (separate columns for each PoP): Insert estimated hours for each labor category for each TO performance year (blue boxes). Each FTE should add up to 1920 hours for each labor category, unless otherwise specified in the TO RFP. In the example PoP of 26 Sep 17 to 25 Sep 18, for the first TO performance year for one FTE, take 1920 hours divided by 12, which is 160 hours per month. The same would then apply for the following years, with Est. Hrs in the option year tabs identified..

6. Rate: Insert your proposed cost elements for each of the labor categories for the solicited effort (light blue). The Total Cost and Loaded Rate columns will automatically calculate. The resulting values in the Loaded Rate column shall be equal or less than rates proposed as part of the OASIS ID/IQ solicitation and included in the basic ID/IQ award, and will cover the entire PoP. Offerors may delete any additional rows not requiring rates for each labor category if necessary.

7. Total Labor (three separate columns): These columns will auto calculate. If additional labor categories are added, ensure the totals for Total Labor are updated to include totals for all labor categories.

8. Material and Travel: Insert costs provided in the TO RFP for each TO performance year. If not provided in the RFP but included as part of the requirement, insert proposed costs for each TO performance year (light blue).

9. Material and Travel Handling Rates: Insert percentages in cells highlighted in blue for each TO performance year. These shall be equal to or less than the rates proposed as part of the ID/IQ RFP and subsequent award. The associated dollar value will automatically calculate and become part of the Total Other Direct Costs row in light purple/gray.

10. TOTAL LABOR & ODC: Ensure the totals for each TO performance year calculate to include labor and ODC, particularly if additional performance years were added.

11. Total for Core FTEs: Insert total number of core FTEs in the blue column to the right of the column with 'No.' for number, then ensure the dollar value cell equals the sum of the total labor for the base and all option years for the TO proposal.

12. Total for Optional FTEs: This column will pull from the total numbers (number of FTEs and $ value) on the Optional FTEs Spreadsheet. Ensure the data pulls from the total column in blue on the Optional spreadsheet (when there are optional FTEs for the solicited TO).

13. Total Award Value: Ensure the total includes the total funded and total optional for the TO. This will represent the total evaluated price for the solicitation for FFP contracts.

Note: The information provided on this spreadsheet to include the Unburdened Labor and addiitonal costs to include Fringe, OH, G&A and Profit as updated in the tabs. This information will be used to review and evaluate the Employee Compensation Plan (ECP).

DRAFT

Core FTEs BASE

DRAFT
FIAR
FTEs TotalTBD
LABOR CATEGORY (Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATYrEst. HrsUnburdened Labor Rate (Labor Price)Additonal Costs (Fringe, OH, G&A and Profit)FFP Discount AppliedProposed RateTotal Proposed
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:20181,920.0$ 50.00$ 78.00$ (2.00)$ 126.00$ 241,920.00
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Optional FTEs Value (Total FTEs and Hours)20181,920.0$ - 0
Travel Cost:
TravelEstimated amount provided by the Gov't.$178,000.00
Travel Handling Rate4%

HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:

To be provided by the Offeror if applicable.$ 7,120.00
Total Travel Cost with Material and Travel rate (Fee percentage)$185,120.00
TOTAL LABOR & TRAVELNo.$187,040.00
Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017)00.0$ - 0
Optional FTEs Total00.0$ - 0
Subtotal before applying CAFNo. of Hours0.0$ 187,040.00
OASIS CAF$ 187.04
Total Award ValueNo. of Hours0.0$ 187,227.04

Core FTEs OY1

DRAFT
FIAR
FTEs TotalTBD
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATYrEst. HrsUnburdened Labor Rate (Labor Price)Additonal Costs (Fringe, OH, G&A and Profit)FFP Discount AppliedProposed RateTotal Proposed
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:20181,920.0$ 50.00$ 78.00$ (2.00)$ 126.00$ 241,920.00
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Optional FTEs Value (Total FTEs and Hours)20181,920.0$ - 0
Travel Cost:
TravelEstimated amount provided by the Gov't.$178,000.00
Travel Handling Rate4%

HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:

To be provided by the Offeror if applicable.$ 7,120.00
Total Travel Cost with Material and Travel rate (Fee percentage)$185,120.00
TOTAL LABOR & TRAVELNo.$187,040.00
Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017)00.0$ - 0
Optional FTEs Total00.0$ - 0
Subtotal before applying CAFNo. of Hours0.0$ 187,040.00
OASIS CAF$ 187.04
Total Award ValueNo. of Hours0.0$ 187,227.04

Core FTEs OY2

DRAFT
FIAR
FTEs TotalTBD
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATYrEst. HrsUnburdened Labor Rate (Labor Price)Additonal Costs (Fringe, OH, G&A and Profit)FFP Discount AppliedProposed RateTotal Proposed
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:20181,920.0$ 50.00$ 78.00$ (2.00)$ 126.00$ 241,920.00
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Optional FTEs Value (Total FTEs and Hours)20181,920.0$ - 0
Travel Cost:
TravelEstimated amount provided by the Gov't.$178,000.00
Travel Handling Rate4%

HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:

To be provided by the Offeror if applicable.$ 7,120.00
Total Travel Cost with Material and Travel rate (Fee percentage)$185,120.00
TOTAL LABOR & TRAVELNo.$187,040.00
Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017)00.0$ - 0
Optional FTEs Total00.0$ - 0
Subtotal before applying CAFNo. of Hours0.0$ 187,040.00
OASIS CAF$ 187.04
Total Award ValueNo. of Hours0.0$ 187,227.04

Core FTEs OY3

DRAFT
FIAR
FTEs TotalTBD
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATYrEst. HrsUnburdened Labor Rate (Labor Price)Additonal Costs (Fringe, OH, G&A and Profit)FFP Discount AppliedProposed RateTotal Proposed
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:20181,920.0$ 50.00$ 78.00$ (2.00)$ 126.00$ 241,920.00
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Optional FTEs Value (Total FTEs and Hours)20181,920.0$ - 0
Travel Cost:
TravelEstimated amount provided by the Gov't.$178,000.00
Travel Handling Rate4%

HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:

To be provided by the Offeror if applicable.$ 7,120.00
Total Travel Cost with Material and Travel rate (Fee percentage)$185,120.00
TOTAL LABOR & TRAVELNo.$187,040.00
Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017)00.0$ - 0
Optional FTEs Total00.0$ - 0
Subtotal before applying CAFNo. of Hours0.0$ 187,040.00
OASIS CAF$ 187.04
Total Award ValueNo. of Hours0.0$ 187,227.04

Core FTEs OY4

DRAFT
FIAR
FTEs TotalTBD
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATYrEst. HrsUnburdened Labor Rate (Labor Price)Additonal Costs (Fringe, OH, G&A and Profit)FFP Discount AppliedProposed RateTotal Proposed
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:20181,920.0$ 50.00$ 78.00$ (2.00)$ 126.00$ 241,920.00
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Optional FTEs Value (Total FTEs and Hours)20181,920.0$ - 0
Travel Cost:
TravelEstimated amount provided by the Gov't.$178,000.00
Travel Handling Rate4%

HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:

To be provided by the Offeror if applicable.$ 7,120.00
Total Travel Cost with Material and Travel rate (Fee percentage)$185,120.00
TOTAL LABOR & TRAVELNo.$187,040.00
Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017)00.0$ - 0
Optional FTEs Total00.0$ - 0
Subtotal before applying CAFNo. of Hours0.0$ 187,040.00
OASIS CAF$ 187.04
Total Award ValueNo. of Hours0.0$ 187,227.04

Transition FTEs_Pricing

Cost/Price Proposal for OASIS Task Order Security Cooperation Support Services (SCSS) (Firm Fixed Price/Unrestricted) - Core FTEs - Attachment 4
Transition Phase-In PlanOASIS11 September 17 - 25 Septemeber 17 Transition Phase-In Plan
LABOR CATEGORYYrEst. HrsUnburdened LaborFringe CostOH CostG&A CostTotal Cost
Proposed Labor Category (Task number and number of FTEs in this labor category working on that task)$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Total Transition FTEs (Total FTEs and Hours)00.0$ - 0
DRAFT
FIAR
Transition Phase-In Plan
LABOR CATEGORY (Offeror's Proposed Labor Category)YrEst. HrsUnburdened Labor Rate (Labor Price)Additonal Costs (Fringe, OH, G&A and Profit)FFP Discount AppliedProposed RateTotal Proposed
Proposed Labor Category (Task number and number of FTEs in this labor category working on that task)$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Total Transition FTEs (Total FTEs and Hours)00.0$ - 0

6 Months of Support

DRAFT
FIAR
OPTIONAL FTEs TotalTBD
LABOR CATEGORYYrEst. HrsUnburdened Labor Rate (Labor Price)Additonal Costs (Fringe, OH, G&A and Profit)FFP Discount AppliedProposed RateTotal Proposed Cost
Proposed Labor Category (Task number and number of FTEs in this labor category working on that task)$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Total Optional FTEs Value (Total FTEs and Hours)0.0$ - 0

File details come from the government source that posted it. Updated .