J4_AFS_Cost_Model.xlsx

XLSX spreadsheet 40 KB Posted

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

About this file

J4 AFS 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
J4_AFS_Cost_Model_Updated.xlsx XLSX spreadsheet
AFS_Feedback_Q&A_Compilation.xlsx XLSX spreadsheet
AFS_Solicitation_W91CRB18R0050_01.pdf PDF
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
Labor - Transition In1Each$ - 0
FFPT & M$ - 0from Labor - Cost Detail Page
Total Price =$0.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
Travel - 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
Labor - Year 11Each$ - 0
FFPT & M$ - 0from Labor - Cost Detail Page
Total Price =$0.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
Travel - 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
ODCs - Year 11Each$ - 0
COSTEstimated cost=$ 15,000.00from ODC-Cost Detail sheet
G&A =0.00%$ - 0from ODC-Cost Detail sheet
Total Cost$ 15,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
Labor - Year 21Each$ - 0
FFPT & M$ - 0from Labor - Cost Detail Page
Total Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
Travel - 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
ODCs - Year 21Each$ - 0
COSTEstimated cost=$ 15,000.00from ODC-Cost Detail sheet
G&A =0.00%$ - 0from ODC-Cost Detail sheet
Total Cost$ 15,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
Labor - Year 31Each$ - 0
FFPT & M$ - 0from Labor - Cost Detail Page
Total Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
Travel - 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
ODCs - Year 31Each$ - 0
COSTEstimated cost=$ 15,000.00from ODC-Cost Detail sheet
G&A =0.00%$ - 0from ODC-Cost Detail sheet
Total Cost$ 15,000.00
TOTAL
Estimated cost=$ 205,000.00
Total Price$ 205,000.00
$ 205,000.00double check
$ 205,000.00from Labor - Cost Detail Pageand ODC-Cost Detail sheet
Labor$0.00
ODC$ 195,000.00
$195,000.00
TOTAL
Estimated Price=ERROR:#REF!
Profit =ERROR:#REF!
Price + Profit =ERROR:#REF!

&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
Transition in 45 days
POSITON TITLESHoursFTETotal HoursFully Burdened Labor RateEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col b=S, Enter Name of Subcontractor & Goto Col fTotal Price
abcd=bXck= j + iefj=i X h
Partner/Principal/Director151.015.00$0.00Enter P or S$ - 0
Manager/Project Manager2351.0235.000.00Enter P or S$ - 0
Supervisory Senior/Experienced Senior2352.0470.000.00Enter P or S$ - 0
Senior (Associates)/Senior Accountants2352.0470.000.00Enter P or S$ - 0
SR IT Consultant (EDP Senior (for SAP©))2351.0235.000.00Enter P or S$ - 0
0.000.00Enter P or S$ - 0

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

Base year 2019
POSITON TITLESHoursFTETotal HoursFully Burdened Labor RateEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col b=S, Enter Name of Subcontractor & Goto Col fTotal Price
abcd=bXck= j + iefj=i X h
Partner/Principal/Director2501.0250.00$0.00Enter P or S$ - 0
Manager/Project Manager1,8801.01,880.000.00Enter P or S$ - 0
Supervisory Senior/Experienced Senior1,8802.03,760.000.00Enter P or S$ - 0
Senior (Associates)/Senior Accountants1,8802.03,760.000.00Enter P or S$ - 0
Staff (Staff Accountants/Analysts)1,8804.07,520.000.00Enter P or S$ - 0
Technical Writer (Sep thru Nov 15)5601.0560.000.00Enter P or S$ - 0
SR IT Consultant (EDP Senior (for SAP©))1,8801.01,880.000.00Enter P or S$ - 0
0.000.00Enter P or S$ - 0

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

Option year 1 2020
POSITON TITLESHoursFTETotal HoursFully Burdened Labor RateEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col b=S, Enter Name of Subcontractor & Goto Col fTotal Price
aih= f + gbcj=i X h
Partner/Principal/Director2501.0250.00$0.00Enter P or S$ - 0
Manager/Project Manager1,8801.01,880.000.00Enter P or S$ - 0
Supervisory Senior/Experienced Senior1,8802.03,760.000.00Enter P or S$ - 0
Senior (Associates)/Senior Accountants1,8802.03,760.000.00Enter P or S$ - 0
Staff (Staff Accountants/Analysts)1,8804.07,520.000.00Enter P or S$ - 0
Technical Writer (Sep thru Nov 15)5601.0560.000.00Enter P or S$ - 0
SR IT Consultant (EDP Senior (for SAP©))1,8801.01,880.000.00Enter P or S$ - 0
0.000.00Enter P or S$ - 0

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

Option Year two 2021
POSITON TITLESHoursFTETotal HoursFully Burdened Labor RateEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1)If Col b=S, Enter Name of Subcontractor & Goto Col fTotal Price
aih= f + gbcj=i X h
Partner/Principal/Director2501.0250.00$0.00Enter P or S$ - 0
Manager/Project Manager1,8801.01,880.000.00Enter P or S$ - 0
Supervisory Senior/Experienced Senior1,8802.03,760.000.00Enter P or S$ - 0
Senior (Associates)/Senior Accountants1,8802.03,760.000.00Enter P or S$ - 0
Staff (Staff Accountants/Analysts)1,8804.07,520.000.00Enter P or S$ - 0
Technical Writer (Sep thru Nov 15)5601.0560.000.00Enter P or S$ - 0
SR IT Consultant (EDP Senior (for SAP©))1,8801.01,880.000.00Enter P or S$ - 0
0.000.00Enter P or S$ - 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 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.

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
Transition in$ 10,000.000.00%$ - 0$ 10,000.00
YR 1 Travel$ 50,000.000.00%$ - 0$ 50,000.00
YR 2 Travel$ 50,000.000.00%$ - 0$ 50,000.00
YR 3 Travel$ 50,000.000.00%$ - 0$ 50,000.00
YR 1 ODC$ 15,000.000.00%$ - 0$ 15,000.00
YR 2 ODC$ 15,000.000.00%$ - 0$ 15,000.00
YR 1 ODC$ 15,000.000.00%$ - 0$ 15,000.00
Total$ 205,000.00$ - 0$ 205,000.00

Enter burden on ODCs and travel in column C

File details come from the government source that posted it.