Attachment J.1.1 A0001.xls

XLS spreadsheet 35 KB Posted Aug 27, 2009

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

J.1.1 A0001

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_A0013_SF-33.pdf	PDF	Mar 7, 2011
TIRNO-09-R-00013_Questions and Answers_A0013.xls	XLS spreadsheet	Mar 7, 2011
TIRNO-09-R-00013_Attachment_J.1.1 Rev 1_A0011.xls	XLS spreadsheet	Mar 1, 2011
TIRNO-09-R-00013_Sect B - Attachment 1_A0011.doc	DOC document	Mar 1, 2011
TIRNO-09-R-00013_SF-33_A0011.pdf	PDF	Mar 1, 2011
TIRNO-09-R-00013_Sect B - Attachment 1_A0012.doc	DOC document	Feb 28, 2011
TIRNO-09-R-00013_Attachment_ J.14_Format to Submit Questions_A0012.xls	XLS spreadsheet	Feb 28, 2011
TIRNO-09-R-00013_Attachment_J.1.1 Rev 1_A0012.xls	XLS spreadsheet	Feb 28, 2011
TIRNO-09-R-00013_Amendment 0010_SF-33.pdf	PDF	Jul 28, 2010
TiRNO-09-R-00013_A0009_SF-33.doc.pdf	PDF	Jul 22, 2010
TIRNO-09-R-00013_A0009_Addendum.doc	DOC document	Jul 22, 2010
TIRNO-09-R-00013_Sect M_A0008.doc	DOC document	Jul 16, 2010
TIRNO-09-R-00013_Amendment 0008_SF-33.pdf	PDF	Jul 16, 2010
FedBizOpps Announcement_Solicitation TIRNO-09-R-00013_6.16.2010.doc	DOC document	Jun 16, 2010
TIRNO-09-R-00013_Attachment_J.4_A0007.xls	XLS spreadsheet	May 12, 2010
TIRNO-09-R-00013_Section M_A0007.doc	DOC document	May 12, 2010
TIRNO-09-R-00013_Attachment_ J.14_A0007.xls	XLS spreadsheet	May 12, 2010
TIRNO-09-R-00013_Amendment 0005.doc	DOC document	Sep 16, 2009
TIRNO-09-R-00013_Amendment 0004.doc	DOC document	Sep 10, 2009
Section F_TIPSS-4 SB A0004.doc	DOC document	Sep 10, 2009
Section L_TIPSS-4 SB A0003.doc	DOC document	Sep 3, 2009
Section H_TIPSS-4 SB A0003.doc	DOC document	Sep 3, 2009
TIRNO09R00013 SF-33 A0003.rtf	RTF text file	Sep 3, 2009
Additional Guidance for the SF-33.doc	DOC document	Sep 1, 2009
J.4 SB A0002.pdf	PDF	Sep 1, 2009
Section D_TIPSS-4 SB A0001.DOC	DOC document	Aug 27, 2009
J.4 SB A0001.xls	XLS spreadsheet	Aug 27, 2009
Section G_TIPSS-4 SB A0001.DOC	DOC document	Aug 27, 2009
TIRNO09R00013_A0001.rtf	RTF text file	Aug 27, 2009
Section J_TIPSS-4 SB A0001.DOC	DOC document	Aug 27, 2009
Section E_TIPSS-4 SB A0001.DOC	DOC document	Aug 27, 2009
Section M_TIPSS-4 SB A0001.doc	DOC document	Aug 27, 2009
Section C_TIPSS-4 SB A0001.doc	DOC document	Aug 27, 2009
Attachment J.11.1 A0001.xls	XLS spreadsheet	Aug 27, 2009
http //www.irs.gov/opportunities/procurement/article/0 id 179240 00.html	HTML file	Aug 18, 2009
Section K_TIPSS-4 SB.doc	DOC document	Jul 10, 2009
Attachment J.11.1.xls	XLS spreadsheet	Jul 10, 2009
TIRNO09R00013.rtf	RTF text file	Jul 10, 2009
Section M_TIPSS-4 SB.doc	DOC document	Jul 10, 2009
Section F_TIPSS-4 SB.doc	DOC document	Jul 10, 2009
Section E_TIPSS-4 SB.DOC	DOC document	Jul 10, 2009
Section L_TIPSS-4 SB.doc	DOC document	Jul 10, 2009
Section J_TIPSS-4 SB.DOC	DOC document	Jul 10, 2009
Section H_TIPSS-4 SB.doc	DOC document	Jul 10, 2009
Section F TIPSS-4 SB.rtf	RTF text file	Dec 18, 2008
Section B TIPSS-4 SB.rtf	RTF text file	Dec 18, 2008
Attachment J.14.1.xls	XLS spreadsheet	Dec 18, 2008
Section K TIPSS-4 SB.rtf	RTF text file	Dec 18, 2008
Section L TIPSS-4 SB.rtf	RTF text file	Dec 18, 2008
Section D TIPSS-4 SB.rtf	RTF text file	Dec 18, 2008

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
		Base	Base	Base	Base	Base	Option 1	Option 2	Option 3	Option 4	Option 5		GRAND
Element of Cost		Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10		TOTAL
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 1				BASE PERIOD - Year 2			GRAND TOTAL: Years 1 - 10
				Base				Base			Total
CLIN	Labor Categories		Hours	Rate	Amount		Hours	Rate	Amount		Hours		Amount
CLIN 5	Project Managers		0	$ - 0	$ - 0		0	$ - 0	$ - 0		0		$ - 0
CLIN 6	Subject Matter Experts		0	$ - 0	$ - 0		0	$ - 0	$ - 0		0		$ - 0
CLIN 7	Senior IT Specialists		0	$ - 0	$ - 0		0	$ - 0	$ - 0		0		$ - 0
etc.
Total Direct Labor			0		$ - 0		0		$ - 0		0		$ - 0
Fringe/Overhead		0.00%			$ - 0	0.00%			$ - 0				$ - 0
Subtotal					$ - 0				$ - 0				$ - 0
Subcontract Cost			0		$ - 0		0		$ - 0		0		$ - 0
Other Direct Cost					$ - 0				$ - 0				$ - 0
Subtotal					$ - 0				$ - 0				$ - 0
G&A		0.00%			$ - 0	0.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
		Base									Fully Loaded
		Labor			Fringe/					Fee/	Hourly		Total
CLIN	Labor Categories	Rate	Esc.	Subtotal	Overhead	Subtotal	G&A	Subtotal	FCCM	Profit	Labor Rate	Hours	Cost/Price
CLIN 5	Project Managers	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0	$ - 0
CLIN 6	Subject Matter Experts	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0	$ - 0
CLIN 7	Senior IT Specialists	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0	$ - 0
etc.
Grand Total												0	$ - 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
		Base	Base	Base	Base	Base	Option 1	Option 2	Option 3	Option 4	Option 5		GRAND
Element of Cost		Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10		TOTAL
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 1				BASE PERIOD - Year 2			GRAND TOTAL: Years 1 - 10
				Base				Base			Total
CLIN	Labor Categories		Hours	Rate	Amount		Hours	Rate	Amount		Hours		Amount
CLIN 5	Project Managers		0	$ - 0	$ - 0		0	$ - 0	$ - 0		0		$ - 0
CLIN 6	Subject Matter Experts		0	$ - 0	$ - 0		0	$ - 0	$ - 0		0		$ - 0
CLIN 7	Senior IT Specialists		0	$ - 0	$ - 0		0	$ - 0	$ - 0		0		$ - 0
etc.
Total Direct Labor			0		$ - 0		0		$ - 0		0		$ - 0
Fringe/Overhead		0.00%			$ - 0	0.00%			$ - 0				$ - 0
Subtotal					$ - 0				$ - 0				$ - 0
Subcontract Cost			0		$ - 0		0		$ - 0		0		$ - 0
Other Direct Cost					$ - 0				$ - 0				$ - 0
Subtotal					$ - 0				$ - 0				$ - 0
G&A		0.00%			$ - 0	0.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
		Base									Fully Loaded
		Labor			Fringe/					Fee/	Hourly		Total
CLIN	Labor Categories	Rate	Esc.	Subtotal	Overhead	Subtotal	G&A	Subtotal	FCCM	Profit	Labor Rate	Hours	Cost/Price
CLIN 5	Project Managers	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0	$ - 0
CLIN 6	Subject Matter Experts	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0	$ - 0
CLIN 7	Senior IT Specialists	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0	$ - 0
etc.
Grand Total												0	$ - 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
		RFP					TOTAL
CLIN	Labor Categories	HOURS	PRIME	SUB #1	SUB#2	SUB #3	HOURS
CLIN 5	Project Managers	0	0	0	0	0	0
CLIN 6	Subject Matter Experts	0	0	0	0	0	0
CLIN 7	Senior IT Specialists	0	0	0	0	0	0
	GRAND TOTAL	0	0	0	0	0	0
SAMPLE MATRIX - TOTAL COSTS PROPOSED BY SUBCONTRACTORS
		YEAR 1		YEAR 2		GRAND TOTAL: YEAR 1 - 10
		TOTAL	TOTAL	TOTAL	TOTAL	TOTAL	TOTAL
	SUBCONTRACTOR NAME	HOURS	COST	HOURS	COST	HOURS	COST
	SUBCONTRACTOR #1	0	$ - 0	0	$ - 0	0	$ - 0
	SUBCONTRACTOR #2	0	$ - 0	0	$ - 0	0	$ - 0
	SUBCONTRACTOR #3	0	$ - 0	0	$ - 0	0	$ - 0
	SUBCONTRACTOR #4	0	$ - 0	0	$ - 0	0	$ - 0
	GRAND TOTAL**	0	$ - 0	0	$ - 0	0	$ - 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.12
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 Nov 14, 2017.