TO_Request_Form_Attachment_5a_SAF-FM_(Task_Order_1).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

Attachment 5a

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
Attachment_2_-_Addendum_to_52.212-2_FIAR_FINAL.pdf PDF
Attachment_10_FIAR_IDIQ_QASP_Final_KR.pdf PDF
TO_Request_Form_Attachment_5d_AFMC_(Task_Order_4).xlsx XLSX spreadsheet
TO_Request_Form_Attachment_5e_AFLCMC__(Task_Order_5).xlsx XLSX spreadsheet
TO_Request_Form_Attachment_5g_SAF-SG_(Task_Order_7).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
TO_Request_Form_Attachment_5c_AFSPC_(Task_Order_3).xlsx XLSX spreadsheet
PWS_ATTACHMENT_E_-_Labor_Categories.Rev.pdf PDF
TO_Request_Form_Attachment_5e_AFLCMC__(Task_Order_5).xlsx XLSX spreadsheet
TO_Request_Form_Attachment_5h_SAF-FM_(Task_Order_8_PMO).xlsx XLSX spreadsheet
PWS_ATTACHMENT_F_-_KEY_PERSONNEL_POSITIONS_-_updatedv4.pdf PDF
Attachment_3_Sample_Cross_Reference_Matrix_(Updated_7_Aug_17).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
FA7014-17-R-5002.pdf PDF
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
Attachment_1_-_Addendum_to_52_212-1_FIAR_FINAL.pdf PDF
Attachment_9_AF_FIAR_PWS_FINAL.pdf PDF
PWS_ATTACHMENT_F_-_KEY_PERSONNEL_POSITIONS.docx DOCX document
PWS_ATTACHMENT_B_-_DELIVERABLES.docx DOCX document
Draft_RFP_Q_and_A-_Final.pdf PDF
TO_Request_Form_Attachment_5b_AFMC_(Task_Order_2).xlsx XLSX spreadsheet
PWS_ATTACHMENT_D_-_Feeder_Systems.doc.xlsx XLSX spreadsheet
DRAFT_Attachment_6_-_Past_Performance_Information_Form_(Updated_7_Aug_17).docx DOCX document
DRAFT_Attachment_7_-_FIAR__Past_Perf_Questionnaire_Cover__(Updated_7_Aug_17).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
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
Try for free Login

Text version

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

Instructions

RFP Attachment 5a

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
SAF/FMNational Capital Region50
Financial Reporting/Fund Balance with Treasury (FBwT) ReconciliationColumbus, OH5
FIAR IT Systems/Integration/SupportWright Patterson AFB, OH5
Mission Critical AssetsWright Patterson AFB, OH1

Historical Hrs Est by Task

Column1Column2Column3
CLIN / PWS Paragraph Task LevelEstimated FTE
CLIN 0001/2.1Admin/PMO9
CLIN 0002/2.2Enduring Audit Readienss0.25
Entity Level Controls4
OMB Circular A-123, Appendix A37.75
Prep of the Statment of Assurance0.5
Service Providers3
Executive level Support/Metrics3.5
CLIN 0003/2.3Corrective Actions0.5
Corrective Actions - Financial26
Corrective Actions - Mission Critical17
Population Completeness/UOT4
Mission Critical Asset Manual Reconciliations9
Valuation Baseline & Go Forward Valuation Sustainment23
Executive level Support/Metrics3.5

CLIN 0004/2.4 IPA Audit Liasion Support 48.25

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

CLIN 0006/2.6 Change Management/Communictions 3

CLIN 0007/2.7 Acquisition Program Office Valuation Sustainment

CLIN 0008/2.8 Annual Agency Financial Statement Book 0.5

Totals218
1,880# Hours for FTE Calculation409,840

Proposed Hrs 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 0001 - SAF/FMF

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 0001
SAF/FMFLabor$2,000.00$2,100.00$2,200.00$2,300.00$2,400.00$11,000.00
Travel$400,000.00$404,000.00$408,040.00$412,120.40$416,241.60$2,040,402.00
Total by Performance YearLABOR TOTAL$2,000.00$2,100.00$2,200.00$2,300.00$2,400.00$11,000.00
Travel$400,000.00$404,000.00$408,040.00$412,120.40$416,241.60$2,040,402.00
Travel G&A
TRAVEL TOTAL$400,000.00$404,000.00$408,040.00$412,120.40$416,241.60$2,040,402.00
TOTAL$402,000.00$406,100.00$410,240.00$414,420.40$418,641.60$2,051,402.00
TOTAL PRICE$2,051,402.00

&D &T

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