Sheet 1: INSTRUCTIONS

	
	

		
Offeror Name:
	
	

		
Solicitation #: DCRB-14-028
	
	

		


	
	

		


	
	

		


	
	

		


	
	

		
Summary Page
	
	

		
Please insert your organization's name in cell A2 and the RFP No. in cell A3.  
	
	

		
The totals from each cost element page are automatically carried forward to the Summary worksheet.
	
	

		
This Excel file is set up for five (5) periods.
	
	

		


	
	

		
Direct Labor
	
	

		
Use the Labor - Hourly worksheet to input your assigned labor categories and hours.
	
	

		
The proposed amounts must be based on current payroll information which shows hourly, monthly, or annual rate/salary for each proposed (named) individuals.  Acceptable documentation includes any one of the following:  1) personnel action forms, or 2) most recent payroll register showing name, pay rate, and percent of effort if applicable, or 3) copy of pay stub. Supporting documentation may be requested at a later date. 
	
	

		
If the proposed positions have not been filled or are to be named or hired, then acceptable documentation includes the following:  1) letter of intent to hire including salary rate and title, or 2) position descriptions and salary scales or organizational wage table showing salary range and a copy of hiring policy, or 3) a comparable employee's payroll document.  Supporting documentation may be requested at a later date.  Increases for the to be named or hired are not eligible for increases in the first period.
	
	

		


	
	

		
Insert Escalation Rate in identified yellow cell.
	
	

		


	
	

		
Additional Notes
	
	

		
Productive work hours are 1,880
	
	

		
Direct Labor Hours used to calculate Direct Labor Rate are 2,080.
	
	

		


	
	

		


	
	

		


	
	

		


	
	

		
Points of Contact
	
	

		
If you have any questions regarding this Excel file, please contact Yolanda Smith
	



Sheet 2: SUMMARY

	
	
	
	
	
	
	
	
	
	
	
	
	

		
SUMMARY OF PROPOSED COSTS
		


		


		


		


		


		


		


		


		


		


		


	
	

		
Contractor's Name**
		


		
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Request For Proposal 
		


		


		


		


		


		


		


		


		


		


		


	
	

		
DCRB-
		


		
PERIOD I
		


		
PERIOD II
		


		
PERIOD III
		


		
PERIOD IV
		


		


		
TOTAL
	
	

		


		


		
7/1/2014
		


		
7/1/2015
		


		
7/1/2016
		


		
7/1/2017
		


		


		


	
	

		


		


		
Through
		


		
Through
		


		
Through
		


		
Through
		


		


		


	
	

		


		


		
6/30/2015
		


		
6/30/2016
		


		
6/30/2017
		


		
6/30/2018
		


		


		


	
	

		
Direct Labor - Hourly
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Fringe Benefits - Hourly
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Total Direct Labor & Fringe Benefits
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
       Overhead  (Note 1)
		
0%
		
$0 
		
0%
		
$0 
		
0%
		
$0 
		
0%
		
$0 
		
0%
		
0%
		
$0.00 
	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Materials and Supplies
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Professional Travel
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Equipment
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Consultants
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Other Direct Costs
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Subcontracts
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Total Other Direct Costs
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Subtotal: Direct Labor, Fringe Benefits, Overhead , & Other Directs
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Exclusion(s) From Base For G&A
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Adjusted Base for G&A
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
         G&A (Note 2)
		
0%
		
 $-   
		
0%
		
 $-   
		
0%
		
 $-   
		
0%
		
 $-   
		
0%
		
0%
		
 $-   
	
	

		
Total Proposed Cost Excluding Fee
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Proposed Fee/Profit
		
0%
		
 $-   
		
0%
		
 $-   
		
0%
		
 $-   
		
0%
		
 $-   
		
0%
		
0%
		
 $-   
	
	

		
Total Proposed Cost Plus Fee/Profit
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Firm Fixed Price 
		
Purchase 
		
Year 1 Maintenance
		


		
Year 2 Maintenance 
		


		
Year 3 Maintenance 
		


		
Year 4 Maintenance 
		


		


		
Total 
	
	

		
Enterprise Service BUS 
		


		


		


		


		


		


		


		


		


		


		


	
	

		
Software 
		
 $-   
		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Hardware 
		
 $-   
		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Enterprise Data Quality 
		


		


		


		


		


		


		


		


		


		


		


	
	

		
Software 
		
 $-   
		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Hardware 
		
 $-   
		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Master Data Management 
		


		


		


		


		


		


		


		


		


		


		


	
	

		
Software 
		
 $-   
		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		
Hardware 
		
 $-   
		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		


		
 $-   
		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Total Proposed Firm Fixed Price 
		
 $-   
		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Total Proposal Price
		
 $-   
		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		


		
 $-   
	
	

		


		


		
 $-   
		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
1.
		
Not all organizations allocate indirect cost in the same way.  It is important that you use the indirect rate structure applicable to your organization.  
		
	

		


		


		
For example, if you have a two tier indirect rate structure, then you will use a two tier structure when proposing indirect costs. 
		
	

		


		


		
For-Profit Companies can have  various indirect rates such as fringe benefits, overhead, G&A, etc.       
		
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
2.
		
The base for overhead costs includes direct labor and fringe benefits.  Please modify if your base is different.
		
	

		


		


		
If applicable, insert exclusions to the G&A base in row 26.
		
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
    
		


		


		


		


		


		


		


		


		


		


		


	



Sheet 3: Software, Hardware, Support

	
	
	
	
	
	
	
	
	
	

		
Firm Fixed Price Components 
		


		


		


		


	
	

		


		


		


		


		


	
	

		


		


		


		


		


	
	

		
Contractor's Name**
		


		


		


		


	
	

		
Request For Proposal 
		


		


		


		


	
	

		


		


		
Period 1 
		
Period 2
		
Period 3 
		
Period 4
		


	
	

		


		
Purchase 
		
License 
		
Support 
		
License 
		
Support
		
License 
		
Support 
		
License 
		
Support 
		
Total
	
	

		
Enterprise Service BUS 
		
	

		
Software 
		


		


		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


		
 $-   
	
	

		
Hardware 
		


		


		


		


		


		


		


		


		


		
 $-   
	
	

		
Total 
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
	
	

		
Enterprise Data Quality 
		
	

		
Software 
		


		


		


		


		


		


		


		


		


		
 $-   
	
	

		
Hardware 
		


		


		


		


		


		


		


		


		


		
 $-   
	
	

		
Total 
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
	
	

		
Master Data Management 
		
	

		
Software 
		


		


		


		


		


		


		


		


		


		
 $-   
	
	

		
Hardware 
		


		


		


		


		


		


		


		


		


		
 $-   
	
	

		
Total 
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Total 
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
	
	

		


		


		


		
 $-   
		


		
 $-   
		


		
 $-   
		


		
 $-