TO_Request_Form_Attachment_5b_AFMC_(Task_Order_2).xlsx

XLSX spreadsheet 54 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

From the source

TO REQUEST FORM ATTACHMENT 5b

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
AF_FIAR__Follow-on_Proposal_Additional_Question_Response_FINAL.pdf PDF
TO_Request_Form_Attachment_5a_SAF-FM_(Task_Order_1).xlsx XLSX spreadsheet
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
Attachment_2_-_Addendum_to_52.212-2_FIAR_FINAL.pdf PDF
Attachment_10_FIAR_IDIQ_QASP_Final_KR.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
PWS_ATTACHMENT_D_-_Feeder_Systems_-_Updated.doc.xlsx XLSX spreadsheet
Attachment_6_-_Past_Performance_Information_Form_(26_Sep_17).docx DOCX document
FA7014-17-R-5002_Solicitation.pdf PDF
Attachment_9_AF_FIAR_PWS_FINAL_20171004.pdf PDF
TO_Request_Form_Attachment_5c_AFSPC_(Task_Order_3).xlsx XLSX spreadsheet
PWS_ATTACHMENT_E_-_Labor_Categories.Rev.pdf PDF
Attachment_1_-_Addendum_to_52.212-1_FIAR_FINAL_(28_Sep_17).docx DOCX document
FA7014-17-R-5002.pdf PDF
FA7014-17-R-5002.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
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
PWS_ATTACHMENT_G3_-_AFMCLMC.docx DOCX document
TO_Request_Form_Attachment_5d_AFMC_(Task_Order_4).xlsx XLSX spreadsheet
Order_Guide_Attach_A_-_TO_Request_Form_Attachment_FINAL.xlsx XLSX spreadsheet
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_Attachment_6_-_Past_Performance_Information_Form_(Updated_7_Aug_17).docx DOCX document
DRAFT_Addendum_to_52_212-1_FIAR.docx DOCX document
DRAFT_FIAR_-_OCI_Proivision_Clause.docx DOCX document
DRAFT_FIAR_ORDERING_GUIDE.docx DOCX document
DRAFT_Attachment_4_Cost_Price_Proposal_FIAR.xlsx XLSX spreadsheet
DRAFT_Attachment_6_Tech_Cross_Reference_Matrix_FA7014-17-R-5002.docx DOCX document
FIAR_Follow-On_RFI_-_22_Dec_16.pdf PDF
Labor_Categories_Descriptions_-_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
Try for free Login

Text version

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

Instructions

RFP Attachment 5b

Instructions: This format shall be used for all Price Proposals the FIAR Task Orders (TO). As a minimum, offerors shall fill in the items in yellow highlighted areas as applicable to the requirement in the Rates and Hours Tab.

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 Proposed Hrs Est by Task Tab will only include proposed FTEs required by the effort.

Work Location & Desks Tab - Provides offerors with available spaces provided by the Government. Any FTEs proposed over the available desk spaces will require work at the offerors cleared facility.

Provided by the Government

Historical Hrs Est by Task - Used to assist offerors by providing historical FTEs per tasks based on 1880 hours per year, Provided by the Government

Proposed Hrs Est by Task Tab

1. Insert number of proposed FTEs by Labor Category to complete each PWS tasks. Number of hours for FTE calculation is 1880 per full FTE. Example provided in red.

Rate and Hours Tab - Each required TO has a base year plus four option years. Fill in yellow cells only. Example provided in red.

1. Per LCAT (Column A), enter the proposed number for FTE(s) (Column B) for each year (Column C).

2. Insert proposed fully burdened LCAT Rate for each of the labor categories in Column E (Labor Rate) for each Pop Year (Column C). Ensure the fully burdened hourly rate for each period of performance for each category is entered and matches what was provided in the IDIQ Pricing Sheet (RFP Attachment 4).

3. In the Est hours (Columns G,J,M,P,S) enter the amount of hours for each period of performance

4. The rest of the columns will autopopulate.

Cost Calculations Tab Will autopopulate based on the information form the Rates and Hours Tab.

Work Location & Desks

Task and/or Assessable UnitPrimiary Location of WorkNumber of Workstations
AFMCWright Patterson AFB, OH20

Historical Data Est by Task

Column1Column2Column3
CLIN / PWS Paragraph Task LevelAFMC

Estimated FTE CLIN 0001/2.1 Admin/PMO

CLIN 0002/2.2Enduring Audit Readienss3.75
Entity Level Controls
OMB Circular A-123, Appendix A
Prep of the Statment of Assurance
Service Providers
Executive level Support/Metrics
CLIN 0003/2.3Corrective Actions8.25
Corrective Actions - Financial
Corrective Actions - Mission Critical
Population Completeness/UOT
Mission Critical Asset Manual Reconciliations
Valuation Baseline & Go Forward Valuation Sustainment
Executive level Support/Metrics

CLIN 0004/2.4 IPA Audit Liasion Support 6

CLIN 0005/2.5 FIAR IT Systems/Integration/Support 2

CLIN 0006/2.6 Change Management/Communictions

CLIN 0007/2.7 Acquisition Program Office Valuation Sustainment

CLIN 0008/2.8 Annual Agency Financial Statement Book

Totals20
1,880# Hours for FTE Calculation37,600

Proposed FTEs Est by Task

Column1Column2Column6Column7Column72Column8Column9Column10Column102Column11Column12Column13Column14Column142Column15Column16Column17
CLIN / PWS Paragraph Task LevelPartnerSMSSMESTMJTMSenior Staff ConsultantStaff ConsultantIT ManagerIT SeniorSharePoint DesignerTechnical Analysist (not for wide use)Senior Acquisition Manager (not for wide use)Program Manager (not for wide use)Analysist (not for wide use)
CLIN 0001/2.1Admin/PMO0.511
CLIN 0002/2.2Enduring Audit Readienss
Entity Level Controls
OMB Circular A-123, Appendix A
Prep of the Statment of Assurance
Service Providers
Executive level Support/Metrics
CLIN 0003/2.3Corrective Actions
Corrective Actions - Financial
Corrective Actions - Mission Critical
Population Completeness/UOT
Mission Critical Asset Manual Reconciliations
Valuation Baseline & Go Forward Valuation Sustainment
Executive level Support/Metrics

CLIN 0004/2.4 IPA Audit Liasion Support

CLIN 0005/2.5 FIAR IT Systems/Integration/Support

CLIN 0006/2.6 Change Management/Communictions

CLIN 0007/2.7 Existence and Completeness and Valuation

CLIN 0008/2.8 Annual Agency Financial Statement Book

Totals0.500000000100102.5
1,880# Hours for FTE Calculation940-0-0-0-0-0-0-0-01,880-0-01,880-04,700

Rates and Hours

AF FIAR FOLLOW ON SUPPORT

TASK ORDER 0002 - AFMC

Labor Category# of Task Order FTEsAF FIAR Support ID/IQ YearAF FIAR Support ID/IQ
Period of PerformanceLabor RateBaseOption Year 1Option Year 2Option Year 3Option Year 4
Start7/23/18Start7/23/19Start7/23/20Start7/23/21Start7/23/22
Stop7/22/19Stop7/22/20Stop7/22/21Stop7/22/22Stop7/22/23
Est HoursTotal CostEst HoursTotal CostEst HoursTotal CostEst HoursTotal CostEst HoursTotal Cost
Partner0.5Base23 Jul 18 - 22 Jul 19$ 20.00100$ 2,000.00
1.0OY123 Jul 19 - 22 Jul 20$ 21.00100$ 2,100.00
1.0OY223 Jul 20 - 22 Jul 21$ 22.00100$ 2,200.00
0.5OY323 Jul 21 - 22 Jul 22$ 23.00100$ 2,300.00
0.5OY423 Jul 22 - 22 Jul 23$ 24.00100$ 2,400.00
Subject Matter Specialist0.1Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.1OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.1OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.1OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Subject Matter Expert (SME)0.0Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.0OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.0OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.0OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Senior Task Manager0.1Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.1OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.1OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.1OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Junior Task Manager0.1Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.1OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.1OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.1OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Senior Staff Consultant0.1Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.1OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.1OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.1OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Staff Consultant0.0Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.0OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.0OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.0OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
IT Manager2.0Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
2.0OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
2.0OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
2.0OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
2.0OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
IT Senior0.1Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.1OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.1OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.1OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
SharePoint Designer0.1Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.1OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.1OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.1OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Technical Analysist
(not for wide use)0.1Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.1OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.1OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.1OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Senior Acquisition Manager0.0Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.0OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.0OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.0OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Program Manager
(not for wide use)0.1Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.1OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.1OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.1OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Analysist
(not for wide use)0.1Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.1OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.1OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.1OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
0.0Base23 Jul 18 - 22 Jul 19$ - 0100$ - 0
0.0OY123 Jul 19 - 22 Jul 20$ - 0100$ - 0
0.0OY223 Jul 20 - 22 Jul 21$ - 0100$ - 0
0.0OY323 Jul 21 - 22 Jul 22$ - 0100$ - 0
0.1OY423 Jul 22 - 22 Jul 23$ - 0100$ - 0
Total Labor by Performance Year$ 2,000.00$ 2,100.00$ 2,200.00$ 2,300.00$ 2,400.00
TOTAL TASK ORDER LABOR$11,000.00
Total Hours1,5001,5001,5001,5001,500
FTEs1
2/29/16leap year
1/3/2011holiday12/31/99
1/17/2011holiday12/31/99
2/4/2011Personal12/31/99
2/21/2011holiday12/31/99
3/14/2011Personal12/31/99
4/18/2011Personal12/31/99
5/23/2011Personal12/31/99
5/30/2011holiday12/31/99
6/28/2011Personal12/31/99
7/4/2011holiday12/31/99
8/3/2011Personal12/31/99
9/5/2011holiday12/31/99
9/8/2011Personal
10/1/2011holiday
10/14/2011Personal
11/11/2011holiday
11/18/2011Personal
11/24/2011holiday
12/26/2011holiday
12/27/2011Personal
1/2/2012holiday
1/16/2012holiday
2/6/2012Personal
2/20/2012holiday
3/12/2012Personal
4/17/2012Personal
5/23/2012Personal
5/28/2012holiday
6/28/2012Personal
7/4/2012holiday
8/3/2012Personal
9/3/2012holiday
9/7/2012Personal
10/8/2012holiday
10/15/2012Personal
11/12/2012holiday
11/19/2012Personal
11/22/2012holiday
12/25/2012holiday
12/26/2012Personal
1/1/13holiday
1/21/13holiday
2/5/13Personal
2/18/13holiday
3/12/13Personal
4/17/13Personal
5/23/13Personal
5/27/13holiday
6/28/13Personal
7/4/13holiday
8/2/13Personal
9/2/13holiday
9/9/13Personal
10/14/13holiday
10/15/13Personal
11/19/13Personal
11/24/13holiday
11/28/13holiday
11/28/13holiday
12/25/13holiday
12/26/13Personal
1/1/14holiday
1/20/14holiday
2/5/14Personal
2/17/14holiday
3/12/14Personal
4/17/14Personal
5/23/14Personal
5/26/14holiday
6/27/14Personal
7/4/14holiday
8/4/14Personal
9/1/14holiday
9/9/14Personal
10/13/14holiday
10/15/14Personal
11/11/14holiday
11/19/14Personal
11/27/14holiday
12/25/14holiday
12/26/14Personal
1/1/15holiday
1/19/15holiday
2/5/15Personal
2/16/15holiday
3/12/15Personal
4/17/15Personal
5/21/15Personal
5/25/15holiday
6/26/15Personal
7/3/15holiday
8/4/15Personal
9/7/15holiday
9/9/15Personal
10/12/15holiday
10/15/15Personal
11/11/15holiday
11/19/15Personal
11/26/15holiday
12/25/15holiday
12/28/15Personal
1/1/16holiday
1/18/16holiday
2/5/16Personal
2/15/16holiday
3/11/16Personal
4/18/16Personal
5/23/16Personal
5/30/16holiday
6/27/16Personal
7/4/16holiday
8/4/16Personal
9/5/16holiday
9/9/16Personal
10/10/16holiday
10/14/16Personal
11/11/16holiday
11/18/16Personal
12/26/16holiday
12/26/16Personal
1/2/17holiday
1/16/17holiday
2/6/17Personal
2/20/17holiday
3/13/17Personal
4/17/17Personal
5/23/17Personal
5/29/17holiday
6/27/17Personal
7/4/17holiday
8/4/17Personal
9/4/17holiday
9/11/17Personal
10/9/17holiday
10/16/17Personal
11/10/17holiday
11/20/17Personal
11/23/17holiday
12/25/17holiday
12/26/17Personal
1/1/18holiday
1/15/18holiday
2/5/18Personal
2/19/18holiday
3/12/18Personal
4/17/18Personal
5/23/18Personal
5/28/18holiday
6/27/18Personal
7/4/18holiday
8/7/18Personal
9/3/18holiday
9/10/18Personal
10/8/18holiday
10/15/18Personal
11/12/18holiday
11/19/18Personal
11/22/18holiday
12/25/18holiday
12/26/18Personal
1/1/19holiday
1/21/19holiday
2/5/19Personal
2/18/19holiday
3/12/19Personal
4/17/19Personal
5/23/19Personal
5/27/19holiday
6/27/19Personal
7/4/19holiday
8/5/19Personal
9/2/19holiday
9/9/19Personal
10/14/19holiday
10/15/19Personal
11/11/19holiday
11/19/19Personal
11/28/19holiday
12/25/19holiday
12/26/19Personal

12/14/11

&D &T

Cost Caluations

AF FIAR SUPPORT

TOTAL PRICING

TASK ORDERITEMPERFORMANCE YEARTOTAL
BaseOpt 1Opt 2Opt 3Opt 4
Task Order 0002
AFMCLabor$2,000.00$2,100.00$2,200.00$2,300.00$2,400.00$11,000.00
Travel$100,000.00$101,000.00$102,010.00$103,030.10$104,060.40$510,100.50
Total by Performance YearLABOR TOTAL$2,000.00$2,100.00$2,200.00$2,300.00$2,400.00$11,000.00
Travel$100,000.00$101,000.00$102,010.00$103,030.10$104,060.40$510,100.50
Travel G&A
TRAVEL TOTAL$100,000.00$101,000.00$102,010.00$103,030.10$104,060.40$510,100.50
TOTAL$102,000.00$103,100.00$104,210.00$105,330.10$106,460.40$521,100.50
TOTAL PRICE$521,100.50

&D &T

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