RFP_Attachment_6_Pricing_Tables_31Jul13-POSTED.xls

XLS spreadsheet 109 KB Posted Aug 1, 2013

Attached to: Software as a Server (SaaS) for Reorting Incidents of Work Related Accidents, Injuries, Illnesses and Safety Stories and for Performing Workers' Compensation (WC) Case Management
Solicitation number: AG-7604-S-13-0033
Issued by: Department of Agriculture Forest Service Washington Office Acquisitions

About this file

From the source

RFP Attachment 6

View the file

Other files

File	Type	Posted
Amend_4_Questions_and_AnswersAugust_30.docx	DOCX document	Aug 30, 2013
Amend_3_Questions_and_AnswersAugust_27.docx	DOCX document	Aug 27, 2013
QuestionsPosted15Aug13.docx	DOCX document	Aug 15, 2013
Amendment001SOOPageChange.pdf	PDF	Aug 15, 2013
SOO_Attachment_K_-_FSM_6600_Systems_Management_6680_Security_of_Info-InfoSystemsandInfoTechnology.doc	DOC document	Aug 15, 2013
Amendment001RFPPageChanges.pdf	PDF	Aug 15, 2013
SOO_Attachment_L_-_USDA_Web_Standards_and_Style_Guide.pdf	PDF	Aug 15, 2013
Amendment_000002.pdf	PDF	Aug 15, 2013
Amendment_001.pdf	PDF	Aug 8, 2013
QuestionsPosted7Aug2013_(2).docx	DOCX document	Aug 7, 2013
USDA_Web_Standards_and_Style_Guide_v1_1.pdf	PDF	Aug 7, 2013
USDA_Incident_Mgmt_Policy.doc	DOC document	Aug 7, 2013
FS_OSOH_WC_PreproposalConference_v01_20130802_PMO.pptx	PPTX presentation	Aug 6, 2013
SOO_Attachment_G_FS_WC_OSOH_VendorDemoScenarios-27Jul13-POSTED.docx	DOCX document	Aug 1, 2013
SOO_Attachment_F_Commonly_Used_Forms-27Jul13-POSTED.zip	ZIP file	Aug 1, 2013
SOO_Attachment_E_Current_Database_Field_Descriptions-27Jul13-POSTED.docx	DOCX document	Aug 1, 2013
SOO_Attachment_D_SSO_API_specification-27Jul13-POSTED.docx	DOCX document	Aug 1, 2013
SOO_Attachment_J_USDA_DemographicsbyMission_Area_Agency_31Jul13-POSTED.docx	DOCX document	Aug 1, 2013
RFP_Attachment_3_Past_Performance_Questionnaire-27Jul-POSTED.docx	DOCX document	Aug 1, 2013
SOO_Attachment_I_OSOH_DepartmentRegulation(DR)4410-004_OHRM_DR30Jul13-POSTED.pdf	PDF	Aug 1, 2013
RFP_Attachment_1_FS_WC_OSOH_SOO-31Jul13-POSTED.docx	DOCX document	Aug 1, 2013
RFP_Attachment_2_QASP-30Jul13-POSTED.docx	DOCX document	Aug 1, 2013
RFP_AG-7604-S-13-0033_SaaS_Reporting_Incidents-1August2013-POSTED.docx	DOCX document	Aug 1, 2013
SOO_Attachment_H_WC_DepartmentRegulation(DR)4430-003_OPPM_DR30Jul13-POSTED.pdf	PDF	Aug 1, 2013
RFP_Attachment_5_VPAT_Checklist-27Jul13-POSTED.doc	DOC document	Aug 1, 2013
SOO_Attachment_B_FS_OSOH_WC_Business_Process_Standardization-27Jul13-POSTED.docx	DOCX document	Aug 1, 2013
SOO_Attachment_C_FS_OSOH_WC_IntegratedProjectRequirements-31Jul13-POSTED.xlsx	XLSX spreadsheet	Aug 1, 2013
RFP_Attachment_4_Client__Authorization_Letter_for_Past_Performance_Questionnaires-27Jul13-POSTED.doc	DOC document	Aug 1, 2013
SOO_Attachment_A_Acronymns_used_in_Document-27Jul13-POSTED.docx	DOCX document	Aug 1, 2013

Show all 29

On GovTribe

Work with this file

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.

TABLE 1

	SOLICITATION: AG-7604-S-13-0033
	Attachment 6 -
	OFFEROR NAME:
	PROPOSAL NUMBER:
	TABLE 1	ALL CLINS
	TOTAL PRICE SUMMARY (Enter dollar amounts only)
CLIN Number	BASE PERIOD INCLUSIVE OF TRANSITION (September 27, 2013 - September 26, 2014)	DISCOUNT PERCENTAGE	QUANTITY	UNIT OF ISSUE	UNIT PRICE	TOTAL AMOUNT
0001	Transition		4	MO
0002	Licenses		4	MO
0003	Operations and Maintenance
	Based on 45,000-65,000 Users *		4	MO
	Based on 65,006-85,000 Users		4	MO
	Based on 85,001-105,000 Users		4	MO
	Based on 105,000-125,000 Users		4	MO
0004	Travel		1	NTE	N/A	$ 75,000
	Total Base Period				N/A	$ 75,000
CLIN Number	OPTION YEAR 1 (September 27, 2014 - September 26, 2015)	DISCOUNT PERCENTAGE	QUANTITY	UNIT OF ISSUE	UNIT PRICE	TOTAL AMOUNT
1001	Transition		12	MO	TBD	TBD
1002	Licenses		12	MO
1003	Operations and Maintenance
	Based on 45,000-65,000 Users *		12	MO
	Based on 65,006-85,000 Users		12	MO
	Based on 85,001-105,000 Users		12	MO
	Based on 105,000-125,000 Users		12	MO
1004	Travel		1	NTE	N/A	$ 75,000
	Total Option Period 1				N/A	$ 75,000
CLIN Number	OPTION YEAR 2 (September 27, 2015 - September 26, 2016)	DISCOUNT PERCENTAGE	QUANTITY	UNIT OF ISSUE	UNIT PRICE	TOTAL AMOUNT
2001	Transition		12	MO	TBD	TBD
2002	Licenses		12	MO
2003	Operations and Maintenance
	Based on 45,000-65,000 Users *		12	MO
	Based on 65,006-85,000 Users		12	MO
	Based on 85,001-105,000 Users		12	MO
	Based on 105,000-125,000 Users		12	MO
2004	Travel		1	NTE	N/A	$ 75,000
	Total Option Period 2				N/A	$ 75,000
CLIN Number	OPTION YEAR 3 (September 27, 2016 - September 26, 2017)	DISCOUNT PERCENTAGE	QUANTITY	UNIT OF ISSUE	UNIT PRICE	TOTAL AMOUNT
3001	Transition		12	MO	TBD	TBD
3002	Licenses		12	MO
3003	Operations and Maintenance
	Based on 45,000-65,000 Users *		12	MO
	Based on 65,006-85,000 Users		12	MO
	Based on 85,001-105,000 Users		12	MO
	Based on 105,000-125,000 Users		12	MO
3004	Travel		1	NTE	N/A	$ 75,000
	Total Option Period 3				N/A	$ 75,000
CLIN Number	OPTION YEAR 4 (September 27, 2017 - September 26, 2018)	DISCOUNT PERCENTAGE	QUANTITY	UNIT OF ISSUE	UNIT PRICE	TOTAL AMOUNT
3001	Transition		12	MO	TBD	TBD
3002	Licenses		12	MO
3003	Operations and Maintenance
	Based on 45,000-65,000 Users *		12	MO
	Based on 65,006-85,000 Users		12	MO
	Based on 85,001-105,000 Users		12	MO
	Based on 105,000-125,000 Users		12	MO
3004	Travel		1	NTE	N/A	$ 75,000
	Total Option Period 4				N/A	$ 75,000
	GRAND TOTAL for BASE and all OPTIONS					$ 375,000
* Operations & Maintenance for all periods (Base/Options). The pricing tables for the base and option periods will establish the rate for pricing based on 45,000-65,000 Users. The contractor will identify the discount percentage applied for each subsequent pay band on Attachment 6, Table 1

TABLE 2

SOLICITATION: AG-7604-S-13-0033
Attachment 6 -
OFFEROR NAME:
PROPOSAL NUMBER:
TABLE 2	CLIN:
TOTAL CLIN PRICE SUMMARY (Enter dollar amounts only)
TOTAL PROGRAM Price	BASE HOURS	RATE	AMOUNT
PRICE ELEMENT
Labor
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Subtotal	0		$ - 0
Fringe	$ - 0		$ - 0
Overhead	$ - 0		$ - 0
Subtotal Indirects			$ - 0
Total Labor Total			$ - 0
Other Direct Costs
Material			$ - 0
ODCs
Travel
Subtotal ODCs			$ - 0
Subcontractors
Subcontractor 1:
Subcontractor 2:
Consultant 1:
Subtotal Subcontracts			$ - 0
SUBTOTAL PRICES (LABOR - ODC- SUBCONTRACTS)			$ - 0
G&A	$ - 0		$ - 0
TOTAL PRICE			$ - 0
PROFIT
Profit	$ - 0		$ - 0
FEE SUBTOTAL			$ - 0
NMGRT
NMGRT	$ - 0		$ - 0
NMGRT SUBTOTAL			$ - 0
TOTAL PROPOSED PRICE			$ - 0

TABLE 3

SOLICITATION: AG-7604-S-13-0033
Attachment 6 -
OFFEROR NAME:
PROPOSAL NUMBER:
TABLE 3
LABOR SUMMARY by CLIN (Prepare one table for each CLIN as appropriate)
	a	b	c	d	e	f
CLIN Number			NUMBER	Unburdened Direct Labor Amount	Burdened Rate
	LABOR	Labor Rate	OF			BURDENED
	CATEGORY*		HOURS			DIRECT LABOR
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
	TOTAL		0	$ - 0		$ - 0
	* Fore each labor category identified, provide position descriptions that identify minimum job qualifications, to include a minimum number of years of experience, functional requirements, degrees, and certification. This may be provided as an attachment to this table.

TABLE 4

SOLICITATION: AG-7604-S-13-0033
Attachment 4 -
OFFEROR NAME:
PROPOSAL NUMBER:
OFFEROR FISCAL YEAR:
TABLE 4
INDIRECT RATE SUMMARY *
	OFY 13	OFY 14	OFY 15	OFY 16	OFY 17	Base of Application
FRINGE BENEFITS
LABOR OVERHEAD
G&A
*	Enter your company's indirect rates used/projected for use on
	federal government contracts for the OFYs shown.
	If your company has additional indirect rates, enter the
	name, rates, and application base by OFY in the extra boxes.
	Have these rates been reviewed by your cognizant DCAA office?
	DCAA Office Location:
	Date reviewed:
	Report Number:

Table 2 Sample

SOLICITATION: AG-7604-S-13-0033
Attachment 6 -
OFFEROR NAME:	XYZ Company
PROPOSAL NUMBER:	PROP123
THIS IS A SAMPLE ONLY AND IS NOT MEANT TO DEMONSTRATE REASONABLE PRICES OR HOURS.
TABLE 2	CLIN: 0001
TOTAL CLIN PRICE SUMMARY (Enter dollar amounts only)
TOTAL PROGRAM Price	BASE HOURS	RATE	AMOUNT
COST ELEMENT
Labor
Category 1: Program Manager	10	$ 200.00	$ 2,000
Category 1: Systems Analyst	15	$ 75.00	$ 1,125
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Category 1:			$ - 0
Subtotal	25		$ 3,125
Fringe	$ 3,125	25.00%	$ 781
Overhead	$ 3,125	15.00%	$ 469
Subtotal Indirects			$ 1,250
Total Labor Total			$ 4,375
Other Direct Costs
Material			$ 1,000
ODCs			$ - 0
Travel			$ 5,000.00
Subtotal ODCs			$ 6,000
Subcontractors
Subcontractor 1:			$ 2,000
Subcontractor 2:			$ - 0
Consultant 1:			$ 2,500
Subtotal Subcontracts			$ 4,500
SUBTOTAL PRICES (LABOR - ODC- SUBCONTRACTS)			$ 14,875
G&A	$ 14,875		$ - 0
TOTAL PRICE			$ 14,875
PROFIT
Profit	$ 14,875	5.00%	$ 744
FEE SUBTOTAL			$ 15,619
NMGRT
NMGRT	$ 15,619	5.68%	$ 886
NMGRT SUBTOTAL			$ 16,505
TOTAL PROPOSED PRICE			$ 16,505

SAMPLE

Table 3 Sample + Instructions

SOLICITATION: AG-7604-S-13-0033
Attachment 6 -
OFFEROR NAME:	XYZ Company
PROPOSAL NUMBER:	PROP123
	THIS IS A SAMPLE ONLY AND IS NOT MEANT TO DEMONSTRATE REASONABLE PRICES OR HOURS.
TABLE 3
LABOR SUMMARY by CLIN (Prepare one table for each CLIN as appropriate)
	a	b	c	d	e	f
			NUMBER	Unburdened Direct Labor Amount	Burdened Rate
CLIN number	LABOR	Labor Rate	OF			BURDENED
	CATEGORY*		HOURS			DIRECT LABOR
0001	Program Manager	$ 200.00	10	$ 2,000.00	40%	$ 2,800.00
	Sytem Analyst	$ 75.00	15	$ 1,125.00	40%	$ 1,575.00
				$ - 0		$ - 0
				$ - 0		$ - 0
				$ - 0		$ - 0
	TOTAL DIRECT LABOR		25	$ 3,125.00		$ 4,375.00
g	* For each labor category identified, provide position descriptions that identify minimum job qualifications, to include a minimum number of years of experience, functional requirements, degrees, and certifications. This may be provided as an attachment to this table.
	INSTRUCTIONS
a	Identify the name of the labor category being proposed
b	Enter the unburdened labor rate
c	Multiply Column b with c and enter sum amount into column d
d	Enter Sum Burden Rate (Fringe- Overhead and any other applicable Burdens) DO NOT ENTER G&A, PROFIT & NMGRT
e	Multiply column d times column e and add sum about to column d enter the product inot column f
f	“Burdened direct labor” means direct labor cost burdened with Fringe Benefits, Overhead, and
	any other applicable burdens, exclusive of G&A, Profit, and NMGRT (if applicable). Enter your burdened
	direct labor amount for each line item of labor.
g	Attach position descriptions for each labor category

SAMPLE

File details come from the government source that posted it. Updated Nov 14, 2017.