Attach_11_L-7_DCGS_Cost_Model.xls

XLS spreadsheet 151 KB Posted

Attached to
25 AF DCGS IDIQ Federal contract opportunity
Solicitation number
FA7037-15-R-0001
Issued by
Department of the Air Force Air Combat Command

About this file

From the source

Attach 11 L-7 DCGS Cost Model

View the file

Other files for this federal contract opportunity

Other files attached to 25 AF DCGS IDIQ, newest first.
File Type Posted
Solicitation_Amend_06_Released.pdf PDF
Solicitation_Amend_06.pdf PDF
Attach_11_L-7_DCGS_Cost_Model_REV_02Apr15.xls XLS spreadsheet
Solicitation_Amendment_05.pdf PDF
Solicitation_Amendment_04.pdf PDF
Attach_11_L-7_DCGS_Cost_Model_REV_30Mar15B.xls XLS spreadsheet
Attach_11_L-7_DCGS_Cost_Model_REV_27Mar15.xls XLS spreadsheet
Solicitation_Amendment_03.pdf PDF
Solicitation_Amend_02.pdf PDF
Attach_11_L-7_DCGS_Cost_Model_REV_25Mar15.xls XLS spreadsheet
Attach_10_L-6b_Sample_TO_Pricing_Sheet_REV_25Mar15.xls XLS spreadsheet
Solicitation_Q As.pdf PDF
Attach_10_L-6b_Sample_TO_Pricing_Sheet_REV_11Mar15.xls XLS spreadsheet
Attach_9_L-6a_DCGS_Sample_TO_REV_11Mar15.pdf PDF
Attach_1-DCGS_PWS_REV_11Mar15.pdf PDF
Amendment_01.pdf PDF
Attach_12_L-8_Matrix_REV_11Mar15.pdf PDF
Attach_11_L-7_DCGS_Cost_Model_REV_11Mar15.xls XLS spreadsheet
Attach_2-PWS_Appendix_A_Job_Desc_REV_11Mar15.xls XLS spreadsheet
Attach_3-PWS_Appendix_B_Mission_Essential_Personnel_REV_11Mar15.pdf PDF
Attach_7_L-4_Consent_Form_REV_11Mar2015.pdf PDF
Attach_13_L-9_Risk_Assessment_Template.pdf PDF
Attach_6_L-3_PPQ_Cover_Sheet.docx DOCX document
Attach_1-PWS.pdf PDF
Exhibit_B-DD254.pdf PDF
Attach_7_L-4_Consent_Form.doc DOC document
Attach_2-PWS_Appendix_A_Job_Desc_9Dec14.xlsx XLSX spreadsheet
FA7037-15-R-0001_Solicitation.pdf PDF
Attach_9_L-6a_DCGS_Sample_TO.pdf PDF
Attach_8_L-5_Client_Author.docx DOCX document
Exhibit_A-CDRL.pdf PDF
Attach_4_L-1_PP_Info_Sheet.docx DOCX document
Attach_5_L-2_PPQ.docx DOCX document
Attach_12_L-8_Matrix_REV_7Jan15.docx DOCX document
Attach_10_L-6b_Sample_TO_Pricing_Sheet.xlsx.xls XLS spreadsheet
Attach_3-PWS_Appendix_B_Mission_Essential_Personnel.pdf PDF
Draft_Docs_Q A.pdf PDF
Attach_1-DCGS_PWS.pdf PDF
Attach_L-6b_DCGS_Sample_TO_Pricing_Sheet_219Sep14.xlsx.xls XLS spreadsheet
Attach_L-4_Consent_Form_26Mar2014.doc DOC document
Attach_L-7_DCGS_Cost_Model_REV_19Sep14.xls XLS spreadsheet
Attach_1b-PWS_Appendix_A_Job_Desc.pdf PDF
Attach_4-Sect_M.pdf PDF
Attach_L-3_PPQ_Cover_Sheet_07Oct14.docx DOCX document
Attach_L-2_PPQ_26Mar2014.docx DOCX document
Attach_L-8_Matrix.docx DOCX document
Attach_L-6a_DCGS_Sample_TO.pdf PDF
Attach_L-1_PP_Info_Sheet.pdf PDF
Attach_3-Sect_L.pdf PDF
Attach_L-5_Client_Author_26Mar2014.docx DOCX document
Show all 50

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

Contractors should overtype the existing rates with their own company rates. The rates that should be overtyped and/or entered have been highlighted in blue. All spreadsheets will automatically populate. Direct Labor Rates by labor category shall be entered on the Base Year Rate Develpoment Tab. The Indirect and Escalation Rates shall be entered on the Indirect Rates tab.
Worksheets "Indirect Rates". "Base Year Rate Development", "Option One Rate Development", and "Option Two Rate Development" can be modified to reflect Contractor's rate development. Add or delete columns if needed. The last two columns shall remain "Profit" and "Loaded Wage"
Worksheet "Hourly Rates" requires no contractor input. Rates are taken from the "Base Year Hourly Rates", "Option One Hourly Rates", and "Option Two Hourly Rates" worksheets.

Indirect Rates

Indirect CategoryBase YearOption OneOption TwoBasis
EscalationN/A2.00%3.00%
Fringe Rate35.00%36.00%37.00%Direct LaborAs Applicable, explain basis
Overhead5.00%6.00%7.00%Direct Labor and Fringe CostAs Applicable, explain basis
G&A8.00%9.00%10.00%Direct Labor, Fringe Cost, OverheadAs Applicable, explain basis
Profit5.00%6.00%7.00%Direct Labor, Fringe Cost, Overhead, G&AAs Applicable, explain basis
Wrap Rate1.60741.65031.6940

Base Year Rate Development

Base Hourly WageFringe RateSubtotalLabor OverheadSubtotalG&ASubtotalProfitLoaded Wage
Base Year FFP (Ceiling Rates)
35.00%5.00%8.00%5.00%
Configuration/Integration Manager10.003.5013.500.6814.181.1315.310.7716.08
Senior Programmer- 0- 0- 0- 0- 0- 0- 0- 0
Web Software Developer (Mid-Level)- 0- 0- 0- 0- 0- 0- 0- 0
Web Software Developer (Jr-Level)- 0- 0- 0- 0- 0- 0- 0- 0
Senior Software Tester/Integrateor- 0- 0- 0- 0- 0- 0- 0- 0
Software Tester/Integrator- 0- 0- 0- 0- 0- 0- 0- 0
Quality Assurance/Software Test Engineer- 0- 0- 0- 0- 0- 0- 0- 0
Database Administrator- 0- 0- 0- 0- 0- 0- 0- 0
System Administrator/Spt Engineer III- 0- 0- 0- 0- 0- 0- 0- 0
Network Technician- 0- 0- 0- 0- 0- 0- 0- 0
Project Manager- 0- 0- 0- 0- 0- 0- 0- 0
Senior Consultant- 0- 0- 0- 0- 0- 0- 0- 0- 0
Security Specialist- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst I-II- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst I-III- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst II-III- 0- 0- 0- 0- 0- 0- 0- 0
Senior Management Analyst- 0- 0- 0- 0- 0- 0- 0- 0
Senior Requirements Engineer- 0- 0- 0- 0- 0- 0- 0- 0
SIGINT Systems Engineer II- 0- 0- 0- 0- 0- 0- 0- 0
Senior Management Subject Matter Expert- 0- 0- 0- 0- 0- 0- 0- 0
Operations/Research Analysts- 0- 0- 0- 0- 0- 0- 0- 0
Base Year T&M
35.00%5.00%8.00%5.00%
Intelligence Analyst I-II- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst I-III- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst II-III- 0- 0- 0- 0- 0- 0- 0- 0
Senior Management Analyst- 0- 0- 0- 0- 0- 0- 0- 0

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

Option One Rate Development

Base Hourly WageLabor OverheadSubtotalG&ASubtotalProfitLoaded Wage
Option Year One FFP (Ceiling Rates)
Escalation2.00%36.00%6.00%9.00%6.00%
Configuration/Integration Manager10.203.6713.870.8314.701.3216.020.9616.98
Senior Programmer- 0- 0- 0- 0- 0- 0- 0- 0- 0
Web Software Developer (Mid-Level)- 0- 0- 0- 0- 0- 0- 0- 0- 0
Web Software Developer (Jr-Level)- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Software Tester/Integrateor- 0- 0- 0- 0- 0- 0- 0- 0- 0
Software Tester/Integrator- 0- 0- 0- 0- 0- 0- 0- 0- 0
Quality Assurance/Software Test Engineer- 0- 0- 0- 0- 0- 0- 0- 0- 0
Database Administrator- 0- 0- 0- 0- 0- 0- 0- 0- 0
System Administrator/Spt Engineer III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Network Technician- 0- 0- 0- 0- 0- 0- 0- 0- 0
Project Manager- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Consultant- 0- 0- 0- 0- 0- 0- 0- 0- 0
Security Specialist- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst I-II- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst I-III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst II-III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Management Analyst- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Requirements Engineer- 0- 0- 0- 0- 0- 0- 0- 0- 0
SIGINT Systems Engineer II- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Management Subject Matter Expert- 0- 0- 0- 0- 0- 0- 0- 0- 0
Operations/Research Analysts- 0- 0- 0- 0- 0- 0- 0- 0- 0
Option Year One T&M
Escalation2.00%36.00%6.00%9.00%6.00%
Intelligence Analyst I-II- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst I-III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst II-III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Management Analyst- 0- 0- 0- 0- 0- 0- 0- 0- 0

&LFA7037-15-R-0001

Attachment l-7&CContractor Name&R&A Page &P of &N

Option Two Rate Development

Base Hourly WageLabor OverheadSubtotalG&ASubtotalProfitLoaded Wage
Option Year Two FFP (Ceiling Rates)
Escalation3.00%37.00%7.00%10.00%7.00%
Configuration/Integration Manager10.513.8914.401.0115.411.5416.951.1918.14
Senior Programmer- 0- 0- 0- 0- 0- 0- 0- 0- 0
Web Software Developer (Mid-Level)- 0- 0- 0- 0- 0- 0- 0- 0- 0
Web Software Developer (Jr-Level)- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Software Tester/Integrateor- 0- 0- 0- 0- 0- 0- 0- 0- 0
Software Tester/Integrator- 0- 0- 0- 0- 0- 0- 0- 0- 0
Quality Assurance/Software Test Engineer- 0- 0- 0- 0- 0- 0- 0- 0- 0
Database Administrator- 0- 0- 0- 0- 0- 0- 0- 0- 0
System Administrator/Spt Engineer III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Network Technician- 0- 0- 0- 0- 0- 0- 0- 0- 0
Project Manager- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Consultant- 0- 0- 0- 0- 0- 0- 0- 0- 0
Security Specialist- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst I-II- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst I-III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst II-III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Management Analyst- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Requirements Engineer- 0- 0- 0- 0- 0- 0- 0- 0- 0
SIGINT Systems Engineer II- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Management Subject Matter Expert- 0- 0- 0- 0- 0- 0- 0- 0- 0
Operations/Research Analysts- 0- 0- 0- 0- 0- 0- 0- 0- 0
Option Year Two T&M
Escalation3.00%37.00%7.00%10.00%7.00%
Intelligence Analyst I-II- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst I-III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Intelligence Analyst II-III- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Management Analyst- 0- 0- 0- 0- 0- 0- 0- 0- 0

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

Hourly Rates

FFP (Ceiling Rates)
ClassificationBase YearOption Year OneOption Year Two
Configuration/Integration Manager$ 16.08$ 16.98$ 18.14
Senior Programmer$ - 0$ - 0$ - 0
Web Software Developer (Mid-Level)$ - 0$ - 0$ - 0
Web Software Developer (Jr-Level)$ - 0$ - 0$ - 0
Senior Software Tester/Integrateor$ - 0$ - 0$ - 0
Software Tester/Integrator$ - 0$ - 0$ - 0
Quality Assurance/Software Test Engineer$ - 0$ - 0$ - 0
Database Administrator$ - 0$ - 0$ - 0
System Administrator/Spt Engineer III$ - 0$ - 0$ - 0
Network Technician$ - 0$ - 0$ - 0
Project Manager$ - 0$ - 0$ - 0
Senior Consultant$ - 0$ - 0$ - 0
Security Specialist$ - 0$ - 0$ - 0
Intelligence Analyst I-II$ - 0$ - 0$ - 0
Intelligence Analyst I-III$ - 0$ - 0$ - 0
Intelligence Analyst II-III$ - 0$ - 0$ - 0
Senior Management Analyst$ - 0$ - 0$ - 0
Senior Requirements Engineer$ - 0$ - 0$ - 0
SIGINT Systems Engineer II$ - 0$ - 0$ - 0
Senior Management Subject Matter Expert$ - 0$ - 0$ - 0
Operations/Research Analysts$ - 0$ - 0$ - 0
T&M
ClassificationBase YearOption Year OneOption Year Two
Intelligence Analyst I-II$ - 0$ - 0$ - 0
Intelligence Analyst I-III$ - 0$ - 0$ - 0
Intelligence Analyst II-III$ - 0$ - 0$ - 0
Senior Management Analyst$ - 0$ - 0$ - 0

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

Labor Totals

Base YearOption Yr 1Option Yr 2
CLIN X001, Labor FFPHours - Base YrLoaded WageTotal PriceHours - 1st OptLoaded WageTotal PriceHours -2nd OptLoaded WageTotal Price
Configuration/Integration Manager7,680$ 16.08$ 123,494.407,680$ 16.98$ 130,406.407,680$ 18.14$ 139,315.20
Senior Programmer5,760$ - 0$ - 05,760$ - 0$ - 05,760$ - 0$ - 0
Web Software Developer (Mid-Level)3,840$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0
Web Software Developer (Jr-Level)1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0
Senior Software Tester/Integrateor1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0
Software Tester/Integrator3,840$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0
Quality Assurance/Software Test Engineer1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0
Database Administrator1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0
System Administrator/Spt Engineer III13,440$ - 0$ - 013,440$ - 0$ - 09,600$ - 0$ - 0
Network Technician3,840$ - 0$ - 03,840$ - 0$ - 01,920$ - 0$ - 0
Project Manager9,600$ - 0$ - 09,600$ - 0$ - 09,600$ - 0$ - 0
Senior Consultant3,840$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0
Security Specialist5,760$ - 0$ - 05,760$ - 0$ - 05,760$ - 0$ - 0
Intelligence Analyst I-II9,600$ - 0$ - 05,760$ - 0$ - 0-$ - 0$ - 0
Intelligence Analyst I-III38,400$ - 0$ - 030,720$ - 0$ - 030,720$ - 0$ - 0
Intelligence Analyst II-III15,360$ - 0$ - 09,600$ - 0$ - 09,600$ - 0$ - 0
Senior Management Analyst23,040$ - 0$ - 023,040$ - 0$ - 023,040$ - 0$ - 0
Senior Requirements Engineer1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0
SIGINT Systems Engineer II6,720$ - 0$ - 06,720$ - 0$ - 06,720$ - 0$ - 0
Senior Management Subject Matter Expert5,760$ - 0$ - 05,760$ - 0$ - 05,760$ - 0$ - 0
Operations/Research Analysts7,680$ - 0$ - 07,680$ - 0$ - 07,680$ - 0$ - 0
Total:$ 123,494.40Total:$ 130,406.40Total:$ 139,315.20
Classification CLIN X002, Surge, CPFFHours - Base YrLoaded WageTotal PriceHours - 1st OptLoaded WageTotal PriceHours -2nd OptLoaded WageTotal Price
Intelligence Analyst I-II2,000$ - 0$ - 01,500$ - 0$ - 0-$ - 0$ - 0
Intelligence Analyst I-III8,000$ - 0$ - 08,000$ - 0$ - 08,725$ - 0$ - 0
Intelligence Analyst II-III3,200$ - 0$ - 02,500$ - 0$ - 02,730$ - 0$ - 0
Senior Management Analyst4,800$ - 0$ - 06,000$ - 0$ - 06,545$ - 0$ - 0
Total:$ - 0Total:$ - 0Total:$ - 0

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

Total Evaluated Price

Base YearOption Yr 1Option Yr 2
CLIN X001, Labor FFP Total$ 123,494.40$ 130,406.40$ 139,315.20
CLIN X002, Surge T&M Total$ - 0$ - 0$ - 0
CLIN X003, Materials, Cost$ 300,000.00$ 309,000.00$ 318,270.00
CLIN X004, Travel, Cost$ 550,000.00$ 566,500.00$ 583,495.00
CLIN X005, Data, NSP$ - 0$ - 0$ - 0
CLIN X006, TO 0001$ 3,000.00$ - 0$ - 0
Yearly Total:$ 976,494.40$ 1,005,906.40$ 1,041,080.20
Total Evaluated Price:$3,023,481.00
Do NOT change the cells in orange. These will be the same for everyone.

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

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