Attachment_3_-_Cost_Model_SVED_FFP.xlsx

XLSX spreadsheet 38 KB Posted

Attached to
The Army Evaluation Center (AEC) Survivability Evaluation Directorate (SVED) Professional Support Services
Solicitation number
W91CRB-18-R-0037
Issued by

About this file

SVED Cost Model Template

View the file

Other files

Show all 16

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

SECTION B

SECTION B - SUPPLIES OR SERVICES & PRICES
Solicitation #

Section B Spreadsheet: The Section B worksheet imports data from the Summary, FFP Labor and the ODC-Cost Detail spreadsheets and is used as a basis for the proposed formal Section B.

CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0001Labor1Each$ - 0
FFPTotal Price =$ - 0From Summary worksheet
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0002Travel ODCs1Each$ - 0
CostTotal Price =$ 685,000.00From Summary worksheet
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0003Accounting for Contract Services (CMRA)1Each$ - 0
OPTIONNSPTotal Price =NSP
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0004CDRLs1Each$ - 0
OPTIONNSPTotal Price =NSP
TOTAL
Estimated cost=$ 685,000.00Total of all section B CLINS
$ 685,000.00Double check from Summary worksheet page
$ 685,000.00Double check from Labor-Cost Detail + ODC - Cost Detail pages

NOTE: It is incumbent upon the offeror to ensure the total proposed price has no calculation errors.

Summary - For Gov Use Only

COST SUMMARYNo Inputs On This TabNo Inputs On This Tab
Solicitation #

TOTAL SUMMARY

Labor HoursYear 1 - (10 Months)Year 2Year 3Year 4Year 5Total
Labor36,11035,31035,11534,63534,920176,090
Total Labor Hours36,11035,31035,11534,63534,920176,090
Labor Dollars
Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ODCs
Travel ODCs$ 685,000.00$ 685,000.00
Material Handling$ - 0$ - 0
Total ODC$ 685,000.00$ - 0$ - 0$ - 0$ - 0$ 685,000.00

TOTAL COST $ 685,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ 685,000.00

This spreadsheet is for Government analysis purposes. It is populated from the FFP Labor and ODC-Cost Detail spreadsheets.

FFP Labor

Labor Cost Detail Spreadsheet
Solicitation No.
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
ENTER DATA ONLY IN THE LIGHT BLUE CELLS
0.00%
CLIN 0001 Base Period (months 1-12)0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col b=S, Enter Name of Subcontractor & Goto Col fHourly Base Pay Rate (Note 2)Fringe Rate (Note 3)Total Employee Compensation (Direct Labor Rate plus Fringe) (Note 4)Fully Burdened T&M Labor Rate (Note 5)Total Price
abcdefghj=b X h
Administrative Support150Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst I500Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst II3,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst III2,600Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer I650Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer II4,000Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer III3,025Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer IV175Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer V100Enter P or S$ - 0$ - 0$ - 0$ - 0
Operations, Test & Evaluation Specialist700Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst I300Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst II4,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst III2,700Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer I150Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer II3,650Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer III2,510Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer I150Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer II3,000Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer III2,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor I750Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor II500Enter P or S$ - 0$ - 0$ - 0$ - 0

TOTAL BASE YEAR LABOR 36,110.00 $0.00 $0.00 $ - 0

0.00%
CLIN 0003 Option Period 1 (months 13-24)0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col b=S, Enter Name of Subcontractor & Goto Col fHourly Base Pay Rate (Note 2)Fringe Rate (Note 3)Total Employee Compensation (Direct Labor Rate plus Fringe) (Note 4)Fully Burdened T&M Labor Rate (Note 5)Total Price
abcdefghj=b X h
Administrative Support100Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst I350Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst II4,000Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst III2,500Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer I350Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer II4,600Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer III3,000Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer IV150Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer V150Enter P or S$ - 0$ - 0$ - 0$ - 0
Operations, Test & Evaluation Specialist400Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst I250Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst II3,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst III3,200Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer I200Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer II3,650Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer III2,510Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer I200Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer II2,700Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer III2,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor I700Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor II300Enter P or S$ - 0$ - 0$ - 0$ - 0

TOTAL OPTION YEAR 1 LABOR 35,310.00 $0.00 $0.00 $ - 0

0.00%
CLIN 0005 Option Period 2 (months 25-36)0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col b=S, Enter Name of Subcontractor & Goto Col fHourly Base Pay Rate (Note 2)Fringe Rate (Note 3)Total Employee Compensation (Direct Labor Rate plus Fringe) (Note 4)Fully Burdened T&M Labor Rate (Note 5)Total Price
abcdefghj=b X h
Administrative Support100Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst I200Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst II3,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst III2,550Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer I200Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer II3,500Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer III3,040Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer IV150Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer V100Enter P or S$ - 0$ - 0$ - 0$ - 0
Operations, Test & Evaluation Specialist400Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst I200Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst II4,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst III3,050Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer IEnter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer II3,650Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer III2,575Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer I200Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer II3,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer III2,600Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor I800Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor II300Enter P or S$ - 0$ - 0$ - 0$ - 0
0$ - 0

TOTAL OPTION YEAR 2 LABOR 35,115.00 $0.00 $0.00 $ - 0

0.00%
CLIN 7 Option Period 3 (months 37-48)0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col b=S, Enter Name of Subcontractor & Goto Col fHourly Base Pay Rate (Note 2)Fringe Rate (Note 3)Total Employee Compensation (Direct Labor Rate plus Fringe) (Note 4)Fully Burdened T&M Labor Rate (Note 5)Total Price
abcdefghj=b X h
Administrative Support100Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst I200Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst II4,000Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst III2,500Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer I200Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer II3,700Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer III3,000Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer IV150Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer V100Enter P or S$ - 0$ - 0$ - 0$ - 0
Operations, Test & Evaluation Specialist300Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst I100Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst II4,000Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst III3,025Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer I100Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer II3,650Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer III2,510Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer I100Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer II3,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer III2,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor I600Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor II300Enter P or S$ - 0$ - 0$ - 0$ - 0

TOTAL OPTION YEAR 3 LABOR 34,635.00 $0.00 $0.00 $ - 0

0.00%
CLIN 0009 Option Period 4 (months 49-60)0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col b=S, Enter Name of Subcontractor & Goto Col fHourly Base Pay Rate (Note 2)Fringe Rate (Note 3)Total Employee Compensation (Direct Labor Rate plus Fringe) (Note 4)Fully Burdened T&M Labor Rate (Note 5)Total Price
abcdefghj=b X h
Administrative Support100Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst I100Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst II4,000Enter P or S$ - 0$ - 0$ - 0$ - 0
Cyber Security Analyst III2,500Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer I100Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer II4,500Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer III3,000Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer IV110Enter P or S$ - 0$ - 0$ - 0$ - 0
General Engineer VEnter P or S$ - 0$ - 0$ - 0$ - 0
Operations, Test & Evaluation Specialist300Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst I100Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst II4,000Enter P or S$ - 0$ - 0$ - 0$ - 0
Program/Systems Analyst III3,000Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer I100Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer II3,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Scientist Engineer III2,510Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer I100Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer II3,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Systems Engineer III2,500Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor I600Enter P or S$ - 0$ - 0$ - 0$ - 0
Technical Editor II300Enter P or S$ - 0$ - 0$ - 0$ - 0

TOTAL OPTION YEAR 4 LABOR 34,920.00 $0.00 $0.00 $ - 0

TOTAL PRICE 176,090.00 $0.00 $0.00 $ - 0 Labor

ENTER DATA IN THE LIGHT BLUE CELLS
NOTE 1: Column A of the Labor- Detail Spreadsheets contains labor categories. During contract performance these categories ostensibly may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a P in Col C if the effort is to be performed by the prime contractor, and an S if performed by another division or subcontractor. Enter the name of the division or contractor in Col D. If the particular individual category is to be performed jointly by more than one entity (i.e. the prime and a sub or subs), the offeror will be required to insert additional row(s) under the labor category and to allocate the Col I hours for the individual category to be performed among the prime and subs. After this allocation, the total of the original and inserted rows under the individual category in Col I shall total to the number of hours provided by the Govt for the respective labor category. Offerors may cross reference alternate position titles specific to its organization in column B.

NOTE 2: Please enter the base labor rate for the labor categories listed. The base labor rate is the average gross rate actually paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reason, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror.

NOTE 3: Additional entry cells at the top have been made available since different labor categories may have differing fringe rates applied to them. Apply fringe to prime offeror derived rates inclusive of statutory (i.e. FICA, FUTA, SUTA, Workman's Comp) and non-statutory (i.e. health insurance, 401K, etc, vacations, holidays, etc).

NOTE 4: Because 52.222-46 applies to this solicitation offerors are to provide total compensation (salaries + fringes). Column E + column F.
NOTE 5: Please enter the prime offeror T&M billing rate. Therefore, the rate entered for prime contractor performed rate categories is as follows: rate = prime base labor rate + prime fringe + prime overhead+prime G&A+prime profit. If the labor category is performed by a subcontractor, the rate entered in this column is as follows: Rate = sub base rate +sub fringe + sub overhead + sub G&A + sub fee+prime G&A and fee (i.e. subcontractor loaded rate PLUS prime G&A and fee).

ODC - Cost Detail

ODC Cost Detail Spreadsheet
Solicitation No.
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
- 0Travel/ODC COST DETAIL
0.000%
CLINDescriptionODC/TravelMaterial Handling and/or G&A RateMaterial Handling and/or G&ATotal ODC/Travel NTE $
abcdde
CLIN 0002Travel ODCs$ 685,000.000.000%$ - 0$ 685,000.00
0
Total$ 685,000.00$ - 0$ 685,000.00

ENTER DATA IN THE LIGHT BLUE CELLS ONLY.

CLINs with an ESTIMATED normalized amount for other direct cost (ODC) and travel has
been specified for quote purposes. Each Offeror is to include these amounts in their quotes. Any
materal handling and/or G&A is to be applied to ODCs as appropriate. Since ODCs are an
estimated amount that may or may not occur, no fixed fee/profit will be proposed or accepted.

File details come from the government source that posted it.