DRAFT_SAF-FMF_Pricing_Proposal_20170727.xlsx

XLSX spreadsheet 44 KB Posted Aug 1, 2017

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

From the source

DRAFT Cost/Pricing Template for SAF-FMF Support - provided as an example of the worksheet for pricing.

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	Oct 25, 2017
Attachment_4_-_IDIQ_Pricing_Sheet_20171002.xlsx	XLSX spreadsheet	Oct 25, 2017
TO_Request_Form_Attachment_5f_SMC-AFSPC_(Task_Order_6).xlsx	XLSX spreadsheet	Oct 25, 2017
TO_Request_Form_Attachment_5c_AFSPC_(Task_Order_3).xlsx	XLSX spreadsheet	Oct 25, 2017
Attachment_2_-_Addendum_to_52.212-2_FIAR_FINAL.pdf	PDF	Oct 25, 2017
Attachment_10_FIAR_IDIQ_QASP_Final_KR.pdf	PDF	Oct 25, 2017
TO_Request_Form_Attachment_5d_AFMC_(Task_Order_4).xlsx	XLSX spreadsheet	Oct 25, 2017
TO_Request_Form_Attachment_5e_AFLCMC__(Task_Order_5).xlsx	XLSX spreadsheet	Oct 25, 2017
TO_Request_Form_Attachment_5g_SAF-SG_(Task_Order_7).xlsx	XLSX spreadsheet	Oct 25, 2017
PWS_ATTACHMENT_D_-_Feeder_Systems_-_Updated.doc.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment_6_-_Past_Performance_Information_Form_(26_Sep_17).docx	DOCX document	Oct 4, 2017
TO_Request_Form_Attachment_5b_AFMC_(Task_Order_2).xlsx	XLSX spreadsheet	Oct 4, 2017
FA7014-17-R-5002_Solicitation.pdf	PDF	Oct 4, 2017
Attachment_9_AF_FIAR_PWS_FINAL_20171004.pdf	PDF	Oct 4, 2017
TO_Request_Form_Attachment_5c_AFSPC_(Task_Order_3).xlsx	XLSX spreadsheet	Oct 4, 2017
PWS_ATTACHMENT_E_-_Labor_Categories.Rev.pdf	PDF	Oct 4, 2017
TO_Request_Form_Attachment_5e_AFLCMC__(Task_Order_5).xlsx	XLSX spreadsheet	Oct 4, 2017
TO_Request_Form_Attachment_5h_SAF-FM_(Task_Order_8_PMO).xlsx	XLSX spreadsheet	Oct 4, 2017
PWS_ATTACHMENT_F_-_KEY_PERSONNEL_POSITIONS_-_updatedv4.pdf	PDF	Oct 4, 2017
Attachment_3_Sample_Cross_Reference_Matrix_(Updated_7_Aug_17).pdf	PDF	Oct 4, 2017
Attachment_4_-_IDIQ_Pricing_Sheet_20171002.xlsx	XLSX spreadsheet	Oct 4, 2017
TO_Request_Form_Attachment_5d_AFMC_(Task_Order_4).xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment_1_-_Addendum_to_52.212-1_FIAR_FINAL_(28_Sep_17).docx	DOCX document	Sep 28, 2017
FA7014-17-R-5002.pdf	PDF	Sep 12, 2017
FA7014-17-R-5002.pdf	PDF	Sep 12, 2017
Attachment_10_QASP_Appendix_A_-_Deliverables_SS_Table.docx	DOCX document	Sep 11, 2017
PWS_ATTACHMENT_G1_-__SAF-FM_Assessable_Units.docx	DOCX document	Sep 11, 2017
TO_Request_Form_Attachment_5f_SMC-AFSPC_(Task_Order_6).xlsx	XLSX spreadsheet	Sep 11, 2017
Attachment_7_-_FIAR__Past_Perf_Questionnaire_Cover_Final.pdf	PDF	Sep 11, 2017
Order_Guide_Attach_B_-_Labor_Categories_FINAL.doc	DOC document	Sep 11, 2017
Attachment_4_-_IDIQ_Pricing_Sheet_(Updated_7_Aug_17).xlsx	XLSX spreadsheet	Sep 11, 2017
FA7014-17-R-5002_Atch1_Item_13_Final.pdf	PDF	Sep 11, 2017
PWS_ATTACHMENT_G3_-_AFMCLMC.docx	DOCX document	Sep 11, 2017
TO_Request_Form_Attachment_5d_AFMC_(Task_Order_4).xlsx	XLSX spreadsheet	Sep 11, 2017
Order_Guide_Attach_A_-_TO_Request_Form_Attachment_FINAL.xlsx	XLSX spreadsheet	Sep 11, 2017
Attachment_1_-_Addendum_to_52_212-1_FIAR_FINAL.pdf	PDF	Sep 11, 2017
Attachment_9_AF_FIAR_PWS_FINAL.pdf	PDF	Sep 11, 2017
PWS_ATTACHMENT_F_-_KEY_PERSONNEL_POSITIONS.docx	DOCX document	Sep 11, 2017
PWS_ATTACHMENT_B_-_DELIVERABLES.docx	DOCX document	Sep 11, 2017
Draft_RFP_Q_and_A-_Final.pdf	PDF	Sep 11, 2017
Attachment_3_Sample_Cross_Reference_Matrix_(Updated_7_Aug_17).docx	DOCX document	Sep 11, 2017
Attachment_6_-_Past_Performance_Information_Form_(Updated_7_Aug_17).docx	DOCX document	Sep 11, 2017
DRAFT_Attachment_6_-_Past_Performance_Information_Form_(Updated_7_Aug_17).docx	DOCX document	Aug 7, 2017
DRAFT_Attachment_7_-_FIAR__Past_Perf_Questionnaire_Cover__(Updated_7_Aug_17).docx	DOCX document	Aug 7, 2017
DRAFT_FIAR_ORDERING_GUIDE.docx	DOCX document	Aug 1, 2017
DRAFT_Attachment_4_Cost_Price_Proposal_FIAR.xlsx	XLSX spreadsheet	Aug 1, 2017
DRAFT_Attachment_6_Tech_Cross_Reference_Matrix_FA7014-17-R-5002.docx	DOCX document	Aug 1, 2017
DRAFT_Addendum_to_52_212-1_FIAR.docx	DOCX document	Aug 1, 2017
FIAR_Follow-On_RFI_-_22_Dec_16.pdf	PDF	Dec 22, 2016
Labor_Categories_Descriptions_-_22_Dec_16.pdf	PDF	Dec 22, 2016

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Instructions: This format shall be used for all Price Proposals the FIAR Task Orders (TO), unless the Government provides a separate template with the TO solicitation. As a minimum, offerors shall fill in the items in yello highlighted areas 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 number assiged to Offeror

3. Insert PoPs Row (2nd Row): POP has been provided but may change depending on actual award.

4. Labor Category: Insert the titles of applicable labor categories. Colume D will be mapped to the specific tasks of the PWS per the proposed labor category. 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. Each FTE should add up to 1880 hours for each labor category, unless otherwise specified in the TO RFP.

6. Rate: Insert your proposed fully burdened LCAT Rate for each of the labor categories for the task order to be priced. The Total Cost columns will automatically calculate. Offerors may delete any additional rows not requiring rates for each labor category if necessary. Ensure that the LCAT rates used for pricing the task orders are the same as proposed on Attachment 4 - Cost/Price Proposal

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. Travel: Travel estimates are provided by the Government.

9. Travel Handling Rates: Insert percentages in cells highlighted for each TO performance year IF proposing a Travel Handling Fee.

10. Total Labor & Travel: Ensure the totals for each TO performance year calculate to include labor and Travel.

11. Total for Core FTEs and Hours: Ensure that total number of core FTEs as well as hours are calculated at the bottom section.

12. Total Pricing: This will represent the total evaluated price for the solicitation for FFP contracts.

DRAFT

Historical Hours

Column1

Column2

Column3

Column4

Column5

Column6

Column7

Column72

Column8

Column9

Column10

Column102

Column11

Column12

Column13

Column14

Column142

Column15

Column16

Column17

Task Level

Qty

FTE/Qty

Total FTE

Partner

SMS

SME

STM

JTM

Senior Staff Consultant

Staff Consultant

IT Manager

IT Senior

SharePoint

Technical Analysist (Limited)

Senior Acquisition Manager

Program Manager (PMO)

Analysist (PMO)

2.1

Admin/PMO

Program Management (Invoice, travel, CO, Sec Mgr)

Quality

2.2	Enduring Audit Readienss
2.2.1	Entity Level Controls
	OMB Circular A-123, Appendix A	20
	Payroll & Travel
	Contracts
	Fin Stmt Compilation, FBWT, Net Outlays
	RB&E & FRAD
	MILSTRIP
	Other Assets/Other Liabilities
	Weapon Systems EL
	Real Property
	Military Equipment
	General Equipment 2 (All Else)
	General Equipment 3 (IT, IUS, Medical Equipment
	Government Furnished Equipment
	Operating Materials and Supplies 1 CM, AT, SE, MM)
	OM&S 2 (Base Possessed, WCF Inventory Base Possessed)
	Munitions
	Contractor Managed Possed
2.2.2	Service Providers
2.2.3	Executive level Support/Metrics

2.3	Corrective Actions
2.3.1	Corrective Actions - Financial
	Payroll & Travel
	Contracts
	Fin Stmt Compilation, FBWT, Net Outlays
	RB&E & FRAD
	MILSTRIP
	Other Assets/Other Liabilities
	Corrective Actions - Mission Critical
	Weapon Systems EL
	Real Property
	Military Equipment
	General Equipment 2 (All Else)
	General Equipment 3 (IT, IUS, Medical Equipment
	Government Furnished Equipment
	Operating Materials and Supplies 1 CM, AT, SE, MM)
	OM&S 2 (Base Possessed, WCF Inventory Base Possessed)
	Munitions
	Contractor Managed Possed
2.3.2	Population Completeness/UOT
2.3.3	Mission Critical Asset Manual Reconciliations
	REMIS
	RAMPOD
	DPAS
	NexGen/ACES-RP
	AFEMS
	DPAS
	ILS-S/SBSS
	CAS/Item Master
	ALMSS
	IMDB
	CEMS
2.3.4	Valuation Baseline & Go Forward Valuation Sustainment	11
2.3.5	Accruals
2.3.6	Executive level Support/Metrics

2.4	IPA Audit Liasion Support
2.4.1	General Fund FS Audit
	Financial Statement Audit Support	20
	MCA Financial Statement Support	10
2.4.2	GF is a service provider
2.4.3	Audit Infrastructure Team Support
	SharePoint Developers
	Briefings/Metrics/Reporting
	IT Audit Support

2.5.1	IT Support
	A-123, Appendix D	50	0.3	15
	NFR, CAP tracking (including DEAMS SSAE)
	New Systems FISCAM & BlueBook	2
	Draft Policy/Guidance
	Risk Management Framework
	DEAMS SSAE Assertion Package Development & Audit Support (FY 20)

2.6 Change Management

1,880	# Hours for FTE Calculation
	Historical Hours for AFSPC - Range of historical hours:	1500	1800

NOTE: This historical information is per year.	This historical information is per year.
It is the Offeror's responsibility to propose the transition plan to address the tasks for this TO and to address continuity of support for the base year.

SAF-FMF Cost Proposal

AF FIAR FOLLOW ON SUPPORT

TASK ORDER - SAF/FMF

COST/PRICING

OFFEROR'S ASSIGNED NUMBER:			XXXXXX
Proposed Labor Category	# of Task Order FTEs	PWS Reference	Labor Rate	Transition Period		Labor Rates	Base Year		Labor Rates	Option Year 1		Labor Rates	Option Year 2		Labor Rates	Option Year 3		Labor Rates	Option Year 4		Labor Rates	Option Year X
				Start	7/27/18		Start	8/27/18		Start	8/27/19		Start	8/27/20		Start	8/27/21		Start	8/27/22		Start	8/27/23
				Stop	7/26/19		Stop	8/26/19		Stop	8/26/20		Stop	8/26/21		Stop	8/26/22		Stop	8/26/23		Stop	2/26/24
				Est Hours	Total Cost		Est Hours	Total Cost		Est Hours	Total Cost		Est Hours	Total Cost		Est Hours	Total Cost		Est Hours	Total Cost		Est Hours	Total Cost
	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				$ - 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			$ - 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			$ - 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			$ - 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.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			$ - 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			$ - 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			$ - 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
	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				$ - 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			$ - 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			$ - 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			$ - 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.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			$ - 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			$ - 0			$ - 0			$ - 0			$ - 0
	0.0				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
	0.0				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
Total FTEs	0.0		Total Hours	0		Total Hours	0		Total Hours	0		Total Hours	0		Total Hours	0		Total Hours	0		Total Hours	0
				$ - 0		$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
		Travel (Estimated)		$ - 0		$ 400,000.00			$ 400,000.00			$ 400,000.00			$ 400,000.00			$ 400,000.00			$ 200,000.00
		Travel Handling Fee			$ - 0	$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
				$ - 0		$400,000.00			$400,000.00			$400,000.00			$400,000.00			$400,000.00			$200,000.00

Total FTEs	0.0
Total Hours	0
Total Pricing	$ 2,200,000.00

PwC proprietary information Use or disclosure of data contained on this page is subject to the restrictions on the title page of this proposal. &D &T

File details come from the government source that posted it. Updated Nov 14, 2017.