Attachment J.1.1.xls

XLS spreadsheet 36 KB Posted

Attached to
TIPSS-4 Small Business (SB) RFP Federal contract opportunity
Solicitation number
TIRNO-09-R-00013
Issued by
Department of the Treasury Internal Revenue Service

About this file

From the source

ATTACHMENT J.1.1 (EXCELL FILE)

View the file

Other files for this federal contract opportunity

Other files attached to TIPSS-4 Small Business (SB) RFP, newest first.
File Type Posted
TIRNO-09-R-00013_A0012.doc DOC document
TIRNO-09-R-00013_SF-33_A0012.pdf PDF
TIRNO-09-R-00013_A0011.doc DOC document
TIRNO-09-R-00013_Attachment_J.4_A0011.xls XLS spreadsheet
TIRNO-09-R-00013_Attachment_ J.14_Format to Submit Questions_A0011.xls XLS spreadsheet
TIRNO-09-R-00013_A0012.doc DOC document
TIRNO-09-R-00013_A0012.doc DOC document
TIRNO-09-R-00013_Attachment_J.4_A0012.xls XLS spreadsheet
TIRNO-09-00013_SF-33_A0012.rtf RTF text file
TIRNO-09-R-00013_Sect B - Attachment 1_A0012.doc DOC document
TIRNO-09-R-00013_A0009.doc DOC document
TIRNO-09-R-00013_Questions and Answers_A008.xls XLS spreadsheet
TIRNO-09-R-00013_Sect J_Attachment_J.1.1 Rev 1_A0008.xls XLS spreadsheet
TIRNO-09-R-00013_Sect B_A0008.doc DOC document
TIRNO-09-R-00013_Sect L_A0008.doc DOC document
TIRNO-09-R-00013_Sect J_Attachment_J.4_A0008.xls XLS spreadsheet
TIRNO-09-R-00013_Amendment 0008.doc DOC document
FedBizOpps Announcement_Solicitation TIRNO-09-R-00013_07.02.2010.doc DOC document
TIRNO-09-R-00013_Section B_A0007.doc DOC document
TIRNO-09-R-00013_Attachment_J.1.1 Rev 1_A0007.xls XLS spreadsheet
TIRNO-09-R-00013_Section L_A0007.doc DOC document
TIRNO-09-R-00013_Amendment 0007_SF-33.pdf PDF
TIRNO-09-R-00013_Amendment 0006.doc DOC document
Section C_TIPSS-4 SB A0004.doc DOC document
Section B_TIPSS-4 SB A0004.doc DOC document
Section L_TIPSS-4 SB A0002.doc DOC document
Solicitation TIRNO-09-R-00013_Amendment 0002.doc DOC document
Section L_TIPSS-4 SB A0001.doc DOC document
Section F_TIPSS-4 SB A0001.doc DOC document
Section K_TIPSS-4 SB A0001.doc DOC document
J.13 SB A0001 EVMS_IntentGuide_Nov06_Appendix.pdf PDF
J.5.1 SB A0001 SEI-FERPA-Release.pdf PDF
Section H_TIPSS-4 SB A0001.doc DOC document
Solicitation TIRNO-09-R-00013_Amendment 0001.doc DOC document
Attachment J.1.1 A0001.xls XLS spreadsheet
Attachment J.14 A0001.xls XLS spreadsheet
SB Questions Answers.xls XLS spreadsheet
Section B_TIPSS-4 SB A0001.doc DOC document
Section I_TIPSS-4 SB.DOC DOC document
Section G_TIPSS-4 SB.DOC DOC document
Section B_TIPSS-4 SB.doc DOC document
Attachment J.14.xls XLS spreadsheet
Section D_TIPSS-4 SB.DOC DOC document
Section M TIPSS-4 SB.rtf RTF text file
Section G TIPSS-4 SB.rtf RTF text file
Section J TIPSS-4 SB.rtf RTF text file
Section C TIPSS-4 SB.rtf RTF text file
Section E TIPSS-4 SB.rtf RTF text file
Section I TIPSS-4 SB.rtf RTF text file
TIRNO09R00013.rtf RTF text file
Show all 50

TIPSS-4 Small Business (SB) RFP 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.

Sample-Govt site

SAMPLE 1 - GRAND TOTAL SUMMARY
BaseBaseBaseBaseBaseOption 1Option 2Option 3Option 4Option 5GRAND
Element of CostYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10TOTAL
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe/Overhead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontract Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost Plus Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SAMPLE 2 - SUMMARY SCHEDULE - COST BREAKDOWN BY CONTRACT YEAR
BASE PERIOD - Year 1BASE PERIOD - Year 2GRAND TOTAL: Years 1 - 10
BaseBaseTotal
CLINLabor CategoriesHoursRateAmountHoursRateAmountHoursAmount
CLIN 5Project Managers0$ - 0$ - 00$ - 0$ - 00$ - 0
CLIN 6Subject Matter Experts0$ - 0$ - 00$ - 0$ - 00$ - 0
CLIN 7Senior IT Specialists0$ - 0$ - 00$ - 0$ - 00$ - 0
etc.
Total Direct Labor0$ - 00$ - 00$ - 0
Fringe/Overhead0.00%$ - 00.00%$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0
Subcontract Cost0$ - 00$ - 00$ - 0
Other Direct Cost$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0
G&A0.00%$ - 00.00%$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0
Fee$ - 0$ - 0$ - 0
Total Cost Plus Fee$ - 0$ - 0$ - 0
SAMPLE 3 - HOURLY LABOR RATES BY CONTRACT YEAR
BaseFully Loaded
LaborFringe/Fee/HourlyTotal
CLINLabor CategoriesRateEsc.SubtotalOverheadSubtotalG&ASubtotalFCCMProfitLabor RateHoursCost/Price
CLIN 5Project Managers$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
CLIN 6Subject Matter Experts$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
CLIN 7Senior IT Specialists$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
etc.
Grand Total0$ - 0
This worksheet is intended to provide an illustrative example of how to develop spreadsheets for Tab B/ Volume III of the Cost/Price Proposal.
The offeror shall include all Labor Categories and Hours as specified in Section J Attachment J.4. In accordance with the instructions in Section L,
the offeror shall propose costs and rates for the Government site and the Contractor site for each year of the contract performance period in accordance
with their normal accounting practices.
As noted in Section B.2, fee and profit will be negotiated at the task order level. However, for evaluation purposes, offerors are requested to propose
the same fee/profit in the Sample 2 and Sample 3 spreadsheets.

&L&"Arial,Bold Italic"SB - Request For Proposal RFP No. TIRNO-0-R-00013

Attachment J.1.1 - Sample Pricing Schedules&R&"Arial,Bold Italic"Government Site

Sample-Contractor site

SAMPLE 1 - GRAND TOTAL SUMMARY
BaseBaseBaseBaseBaseOption 1Option 2Option 3Option 4Option 5GRAND
Element of CostYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10TOTAL
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe/Overhead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontract Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost Plus Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SAMPLE 2 - SUMMARY SCHEDULE - COST BREAKDOWN BY CONTRACT YEAR
BASE PERIOD - Year 1BASE PERIOD - Year 2GRAND TOTAL: Years 1 - 10
BaseBaseTotal
CLINLabor CategoriesHoursRateAmountHoursRateAmountHoursAmount
CLIN 5Project Managers0$ - 0$ - 00$ - 0$ - 00$ - 0
CLIN 6Subject Matter Experts0$ - 0$ - 00$ - 0$ - 00$ - 0
CLIN 7Senior IT Specialists0$ - 0$ - 00$ - 0$ - 00$ - 0
etc.
Total Direct Labor0$ - 00$ - 00$ - 0
Fringe/Overhead0.00%$ - 00.00%$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0
Subcontract Cost0$ - 00$ - 00$ - 0
Other Direct Cost$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0
G&A0.00%$ - 00.00%$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0
Fee$ - 0$ - 0$ - 0
Total Cost Plus Fee$ - 0$ - 0$ - 0
SAMPLE 3 - HOURLY LABOR RATES BY CONTRACT YEAR
BaseFully Loaded
LaborFringe/Fee/HourlyTotal
CLINLabor CategoriesRateEsc.SubtotalOverheadSubtotalG&ASubtotalFCCMProfitLabor RateHoursCost/Price
CLIN 5Project Managers$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
CLIN 6Subject Matter Experts$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
CLIN 7Senior IT Specialists$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0
etc.
Grand Total0$ - 0
This worksheet is intended to provide an illustrative example of how to develop spreadsheets for Tab B/ Volume III of the Cost/Price Proposal.
The offeror shall include all Labor Categories and Hours as specified in Section J Attachment J.4. In accordance with the instructions in Section L,
the offeror shall propose costs and rates for the Government site and the Contractor site for each year of the contract performance period in accordance
with their normal accounting practices.
As noted in Section B.2, fee and profit will be negotiated at the task order level. However, for evaluation purposes, offerors are requested to propose
the same fee/profit in the Sample 2 and Sample 3 spreadsheets.

&L&"Arial,Bold Italic"SB - Request For Proposal RFP No. TIRNO-0-R-00013

Attachment J.1.1 - Sample Pricing Schedules&R&"Arial,Bold Italic"Contractor Site

Matrix

SAMPLE MATRIX - ALLOCATION OF HOURS TO SUBCONTRACTORS BY LABOR CATEGORY
BASE YEAR 1
RFPTOTAL
CLINLabor CategoriesHOURSPRIMESUB #1SUB#2SUB #3HOURS
CLIN 5Project Managers000000
CLIN 6Subject Matter Experts000000
CLIN 7Senior IT Specialists000000
GRAND TOTAL000000
SAMPLE MATRIX - TOTAL COSTS PROPOSED BY SUBCONTRACTORS
YEAR 1YEAR 2GRAND TOTAL: YEAR 1 - 10
TOTALTOTALTOTALTOTALTOTALTOTAL
SUBCONTRACTOR NAMEHOURSCOSTHOURSCOSTHOURSCOST
SUBCONTRACTOR #10$ - 00$ - 00$ - 0
SUBCONTRACTOR #20$ - 00$ - 00$ - 0
SUBCONTRACTOR #30$ - 00$ - 00$ - 0
SUBCONTRACTOR #40$ - 00$ - 00$ - 0
GRAND TOTAL**0$ - 00$ - 00$ - 0
*This worksheet is intended to provide illustrative examples of how to develop a matrix showing the hours allocated
among the subcontractors and the costs proposed by the subcontractors as required by the instructions in Section L.13
of the RFP. The offerors shall provide the subcontract hours and costs for each year of contract performance.
**The grand total cost should tie into the subcontract cost included in the summary schedule (Sample Pricing Schedule
#2) by contract year. The hours and cost for each subcontractor should also tie into the hours and amounts included in
the individual subcontractor's proposal.

&L&"Arial,Bold Italic"&12SB - Request For Proposal RFP No. TIRNO-0-R-00013

Attachment J.1.1 - Sample Allocation Matrix*

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