Attachment J.1.1 ITS.xls

XLS spreadsheet 36 KB Posted

Attached to
Total Information Processing Support Services Federal contract opportunity
Solicitation number
TIRNO-09-R-00012
Issued by
Department of the Treasury Internal Revenue Service

About this file

From the source

ATTACHMENT J.1.1

View the file

Other files for this federal contract opportunity

Other files attached to Total Information Processing Support Services, newest first.
File Type Posted
TIRNO-09-R-00012_A0015.doc DOC document
TIRNO-09-R-00012_Amendment 0014_SF-33.pdf PDF
TIRNO-09-R-00012_A0014_Addendum.doc DOC document
TIRNO-09-R-00012_A0013.doc DOC document
TIRNO-09-R-00012_A0013_SF-33.doc.pdf PDF
TIRNO-09-R-00012_Sect L_A0012.doc DOC document
TIRNO-09-R-00012_Questions and Answers_A0012.xls XLS spreadsheet
FedBizOpps Announcement_Solicitation TIRNO-09-R-00012_07.02.2010.doc DOC document
TIRNO-09-R-00012_Section B_A0011.doc DOC document
TIRNO-09-R-00012_Attachment J.5 ITS_A0011.xls XLS spreadsheet
TIRNO-09-R-00012_Section L_A0011.doc DOC document
Section M_TIPSS-4 ITS A0010.doc DOC document
Section C_TIPSS-4 ITS A0009.doc DOC document
Section B_A0008.doc DOC document
Section H_TIPSS-4 ITS A0007.doc DOC document
Section J_TIPSS-4 ITS A0007.DOC DOC document
TIRNO09R00012 SF-33 A0007.rtf RTF text file
Section L TIPSS-4 ITS A0007.doc DOC document
J.4 SB A0002.pdf PDF
Solicitation TIRNO-09-R-00013_Amendment 0002.doc DOC document
Solicitation TIRNO-09-R-00012_Amendment 0003.doc DOC document
J.5 ITS A0003.pdf PDF
TIRNO09R00012_A0002.rtf RTF text file
Attachment J.16 ITS A0001.xls XLS spreadsheet
Section C_A0001.doc DOC document
Section E_TIPSS-4 ITS A0001.DOC DOC document
Section L TIPSS-4 ITS A0001.doc DOC document
Solicitation TIRNO-09-R-00012_Amendment 0001.doc DOC document
Attachment J.1.1 ITS A0001.xls XLS spreadsheet
Attachment J.15 ITS A0001.xls XLS spreadsheet
J.5 ITS A0001.xls XLS spreadsheet
Section G_TIPSS-4 ITS A0001.DOC DOC document
Section M_TIPSS-4 ITS A0001.doc DOC document
Section I_TIPSS-4 ITS A0001.DOC DOC document
Section J_TIPSS-4 ITS A0001.DOC DOC document
J.6.5 ITS A0001 SEI-FERPA-Release.pdf PDF
TIRNO09R00012.rtf RTF text file
Section M_TIPSS-4 ITS.doc DOC document
Section L TIPSS-4 ITS.doc DOC document
Section K_TIPSS-4 ITS.doc DOC document
Attachment J.15 ITS.xls XLS spreadsheet
Section G_TIPSS-4 ITS.DOC DOC document
Attachment J.16.xls XLS spreadsheet
Section H_TIPSS-4 ITS.doc DOC document
Section I_TIPSS-4 ITS.DOC DOC document
Section I_TIPSS-4 ITS.rtf RTF text file
Section F_TIPSS-4 ITS.rtf RTF text file
Section G_TIPSS-4 ITS.rtf RTF text file
Section H_TIPSS-4 ITS.rtf RTF text file
Section K_TIPSS-4 ITS.rtf RTF text file
Show all 50

Total Information Processing Support Services 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
BaseOptionOptionOptionOptionOptionOptionOptionOptionOptionGRAND
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 1OPTION 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.5. 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"ITS Request For Proposal RFP No. TIRNO-0-R-00012

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

Sample-Contractor site

SAMPLE 1 - GRAND TOTAL SUMMARY
BaseOptionOptionOptionOptionOptionOptionOptionOptionOptionGRAND
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 1OPTION 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.5. 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"ITS Request For Proposal RFP No. TIRNO-0-R-00012

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
*These worksheets are 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"&12ITS - Request For Proposal RFP No. TIRNO-0-R-00012

Attachment J.1.1 - Sample Allocation Matrix*

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