J4_AFS_Cost_Model_Updated.xlsx

XLSX spreadsheet 39 KB Posted

Attached to
Army Audited Financial Statements Compilation and Publication
Solicitation number
W91CRB-18-R-0050
Issued by

About this file

J4 Updated Cost Model

View the file

Other files

File Type Posted
AFS_Feedback_Q&A_Compilation_UPDATED.xlsx XLSX spreadsheet
AFS_Feedback_Q&A_Compilation_UPDATED.xlsx XLSX spreadsheet
Solicitation_W91CRB-18-R-0050_02.pdf PDF
AFS_Feedback_Q&A_Compilation_UPDATED.xlsx XLSX spreadsheet
AFS_Feedback_Q&A_Compilation_UPDATED.xlsx XLSX spreadsheet
AFS_Feedback_Q&A_Compilation.xlsx XLSX spreadsheet
AFS_Solicitation_W91CRB18R0050_01.pdf PDF
J4_AFS_Cost_Model.xlsx XLSX spreadsheet
J1_AFS_CDRL_7.pdf PDF
J1_AFS_CDRL_2.pdf PDF
J2_AFS_DD254.pdf PDF
J1_AFS_CDRL_4.pdf PDF
J1_AFS_CDRL_6.pdf PDF
J1_AFS_CDRL_1.pdf PDF
AFS_Solicitation_W91CRB18R0050.pdf PDF
J1_AFS_CDRL_8.pdf PDF
J1_AFS_CDRL_3.pdf PDF
J6_AFS_Feedback_Template.xlsx XLSX spreadsheet
J5_AFS_Performance_Risk_Questionnaire.pdf PDF
J1_AFS_CDRL_5.pdf PDF
J3_AFS_Quality_Assurance_Surveillance_Plan.pdf PDF
Show all 21

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 #
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0006Labor - Transition In1Each$ - 0
T&MT & M$ - 0from Labor - Cost Detail Page
Total Price =$0.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0007Travel - Transition In1Each$ - 0
COSTEstimated cost=$ 10,000.00from ODC-Cost Detail sheet
G&A =0.00%$ - 0from ODC-Cost Detail sheet
Total Cost$ 10,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0001Labor - Year 11Each$ - 0
T&MT & M$ - 0from Labor - Cost Detail Page
Total Price =$0.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0003Travel - Year 11Each$ - 0
COSTEstimated cost=$ 50,000.00from ODC-Cost Detail sheet
G&A =0.00%$ - 0from ODC-Cost Detail sheet
Total Cost$ 50,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0002ODCs Publication - Year 11Each$ - 0
FFP
Total PriceFALSEfrom ODC-Cost Detail sheet
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1001Labor - Year 21Each$ - 0
T&MT & M$ - 0from Labor - Cost Detail Page
Total Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1003Travel - Year 21Each$ - 0
COSTEstimated cost=$ 50,000.00from ODC-Cost Detail sheet
G&A =0.00%$ - 0from ODC-Cost Detail sheet
Total Cost$ 50,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1002ODCs Publication - Year 21Each$ - 0
FFP
Total Price$ - 0from ODC-Cost Detail sheet
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2001Labor - Year 31Each$ - 0
T&MT & M$ - 0from Labor - Cost Detail Page
Total Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2003Travel - Year 31Each$ - 0
COSTEstimated cost=$ 50,000.00from ODC-Cost Detail sheet
G&A =0.00%$ - 0from ODC-Cost Detail sheet
Total Cost$ 50,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2002ODCs Publication - Year 31Each$ - 0
FFP
Total Price$ - 0from ODC-Cost Detail sheet
TOTAL
Estimated cost=$ 160,000.00
Total Price$ 160,000.00
$ 160,000.00double check
$ 160,000.00from Labor - Cost Detail Pageand ODC-Cost Detail sheet
Labor$0.00
ODC$ 160,000.00
$160,000.00

&F, &A

PAGE &P OF &N

LABOR - COST DETAIL

Labor Cost Detail Spreadsheet
Solicitation No.
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
ENTER DATA IN THE LIGHT BLUE CELLS
CLIN 0006 - Transition in 45 days
POSITON TITLESHoursFTETotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col e=S, Enter Name of SubcontractorFully Burdened Labor RateTotal Price
abcd=bXcefkj=d X k
Partner/Principal/Director151.015.00Enter P or S$ - 0
Project Manager (Supervisory Senior/ Senior Manager)2351.0235.00Enter P or S$ - 0
Supervisory Senior/Experienced Senior Accountant (SME)2352.0470.00Enter P or S$ - 0
Senior Staff Accountants2352.0470.00Enter P or S$ - 0
SAP Expert (Senior Accountant/EDP Consultant/IT Specialist)2351.0235.00Enter P or S$ - 0

TOTAL YEAR ONE LABOR 7.0 1,425.00 $0.00 $ - 0

CLIN 0001 - Base year 2019
POSITON TITLESHoursFTETotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col e=S, Enter Name of SubcontractorFully Burdened Labor RateTotal Price
abcd=bXcefkj=d X k
Partner/Principal/Director2501.0250.00Enter P or S$ - 0
Project Manager (Supervisory Senior/ Senior Manager)1,8801.01,880.00Enter P or S$ - 0
Supervisory Senior/Experienced Senior Accountant (SME)1,8802.03,760.00Enter P or S$ - 0
Senior Staff Accountants1,8802.03,760.00Enter P or S$ - 0
Staff (Staff Accountants/Analysts)1,8804.07,520.00Enter P or S$ - 0
Technical Writer (Sep thru Nov 15)5601.0560.00Enter P or S$ - 0
SAP Expert (Senior Accountant/EDP Consultant/IT Specialist)1,8801.01,880.00Enter P or S$ - 0

TOTAL YEAR ONE LABOR 12.0 19,610.00 $0.00 $ - 0

CLIN 1001 - Option year 1 2020
POSITON TITLESHoursFTETotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col e=S, Enter Name of SubcontractorFully Burdened Labor RateTotal Price
abcd=bXcefkj=d X k
Partner/Principal/Director2501.0250.00Enter P or S$ - 0
Project Manager (Supervisory Senior/ Senior Manager)1,8801.01,880.00Enter P or S$ - 0
Supervisory Senior/Experienced Senior Accountant (SME)1,8802.03,760.00Enter P or S$ - 0
Senior Staff Accountants1,8802.03,760.00Enter P or S$ - 0
Staff (Staff Accountants/Analysts)1,8804.07,520.00Enter P or S$ - 0
Technical Writer (Sep thru Nov 15)5601.0560.00Enter P or S$ - 0
SAP Expert (Senior Accountant/EDP Consultant/IT Specialist)1,8801.01,880.00Enter P or S$ - 0

TOTAL YEAR TWO LABOR 12.0 19,610.00 $0.00 $ - 0

CLIN 2001 - Option Year two 2021
POSITON TITLESHoursFTETotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col e=S, Enter Name of SubcontractorFully Burdened Labor RateTotal Price
abcd=bXcefkj=d X k
Partner/Principal/Director2501.0250.00Enter P or S$0.00$ - 0
Project Manager (Supervisory Senior/ Senior Manager)1,8801.01,880.00Enter P or S0.00$ - 0
Supervisory Senior/Experienced Senior Accountant (SME)1,8802.03,760.00Enter P or S0.00$ - 0
Senior Staff Accountants1,8802.03,760.00Enter P or S0.00$ - 0
Staff (Staff Accountants/Analysts)1,8804.07,520.00Enter P or S0.00$ - 0
Technical Writer (Sep thru Nov 15)5601.0560.00Enter P or S0.00$ - 0
SAP Expert (Senior Accountant/EDP Consultant/IT Specialist)1,8801.01,880.00Enter P or S0.00$ - 0

TOTAL YEAR THREE LABOR 12 19,610.00 $0.00 $ - 0

TOTAL FFP LABOR PRICE $ - 0

INSTRUCTIONS:
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 B 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 C. 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 l 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 or to the Govt for the respective labor category.

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 e 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 f. 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 d 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 d 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 their accompanying price narrative.

ODC - Cost Detail

ODC Cost Detail Spreadsheet
Solicitation No.
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
ODC/Travel COST DETAIL
CLINODCs/Travel (Note 6)Burden/G&A RateBurden/G&A $Total NTE ODC Cost
abcd = b X c
CLIN 0007 - Transition-in Travel$ 10,000.000.00%$ - 0$ 10,000.00
CLIN 0003 - YR 1 Travel$ 50,000.000.00%$ - 0$ 50,000.00
CLIN 1003 - YR 2 Travel$ 50,000.000.00%$ - 0$ 50,000.00
CLIN 2003 - YR 3 Travel$ 50,000.000.00%$ - 0$ 50,000.00
CLIN 0002 - YR 1 ODCs (NTE $15K)0.00%$ - 0FALSE
CLIN 1002 - YR 2 ODCs (NTE $15K)0.00%$ - 0$ - 0
CLIN 2002 - YR 3 ODCs (NTE $15K)0.00%$ - 0$ - 0
Total$ 160,000.00$ - 0$ 160,000.00

Enter burden on ODCs and travel in column C

File details come from the government source that posted it.