DCAA Model Generic Proposal.xls

XLS spreadsheet 121 KB Posted Oct 18, 2019

Attached to: Radioray Spotlight Federal contract opportunity
Solicitation number: SPE7LX20R0022
Issued by: Defense Logistics Agency Land and Maritime

About this file

From the source

DCAA Model Generic Proposal

View the file

Other files for this federal contract opportunity

Other files attached to Radioray Spotlight, newest first.
File	Type	Posted
cost-price data.pdf	PDF	Oct 18, 2019
PID-PACK20191015154120.TXT	TXT text file	Oct 18, 2019
Market_Research_Questionnaire.docx	DOCX document	Oct 18, 2019
DCAA Proposal Adequacy Checklist v 1.0	DOC document	Oct 18, 2019
Market_Research_Spreadsheet.xlsx	XLSX spreadsheet	Oct 18, 2019

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.

Cover Sheet

Summary

Advanced Tank Technologies
Washington, DC
Proposal Submitted In Response To RFP No. DAAH01-02-R-0001
Schedule of Unit Cost and Total Cost by Cost Element
Element of Cost		Unit Price	Total Amount	Reference
Engineering Labor		$ 9,043.02	$ 452,151	Schedule 1
Manufacturing Labor		$ 528.24	26,412	Schedule 1
Total Direct Labor		$ 9,571.26	478,563
Direct Labor Overhead	56.70%	$ 5,426.90	271,345	Schedules 1 & 3
Material		$ 2,263.50	113,175	Schedule 2
Material Handling Overhead	5.00%	$ 113.18	5,659	Schedules 2 & 5
Subtotal		$ 17,374.84	868,742
G&A	8.00%	$ 1,389.99	69,499	Schedule 4
Estimated Cost		$ 18,764.83	938,241
Profit	10.00%	$ 1,876.48	93,824	*
Total Price		$ 20,641.31	$ 1,032,065
Quantity		50
* Contractors can negotiate profit with the contracting officer. Typically, contracting
officers use criteria in FAR 15.404-4 for establishing a profit objective. DoD
contracting officers may use the weighted guidelines policy described in DFARS
215.404-4.

&L&"Arial,Bold"3-17 Figure 3-5-1&R&"Arial,Bold"January 2005&"Arial,Regular" &C&"Arial,Bold"__________________________ Information for Contractors

Schedule 1

											SCHEDULE 1
Advanced Tank Technologies
Washington, DC
Proposal Submitted In Response To RFP No. DAAH01-02-R-0001
Proposed Direct Labor and Direct Labor Overhead
	2002			2003			2004			Total
	Engineering Labor Cost			Engineering Labor Cost			Engineering Labor Cost			Engineering Labor Cost
	Rates/Hr.	Hours	Total	Rates/Hr.	Hours	Total	Rates/Hr.	Hours	Total	Hours	Total
Labor Category
Program Manager	$ 33.93	683	$ 23,174	$ 35.63	760	$ 27,079	$ 37.41	507	$ 18,967	1950	$ 69,220
Senior Engineer	$ 26.39	1200	31,668	$ 27.71	900	24,939	$ 29.10	700	20,370	2800	76,977
Junior Engineer	$ 22.12	1800	39,816	$ 23.23	1500	34,845	$ 24.39	900	21,951	4200	96,612
Engineering Aide	$ 14.50	1800	26,100	$ 15.23	550	8,377	$ 15.99	50	800	2400	35,277
Technical Writer	$ 16.00	0	- 0	$ 16.80	0	- 0	$ 17.64	900	15,876	900	15,876
Metallurgist	$ 18.85	1900	35,815	$ 19.79	1200	23,748	$ 20.78	700	14,546	3800	74,109
Draftsman	$ 18.95	2200	41,690	$ 19.90	1500	29,850	$ 20.90	600	12,540	4300	84,080
Total Direct Labor - Engineering		9583	$ 198,263		6410	$ 148,838		4357	$ 105,050	20350	$ 452,151
	2002			2003			2004			Total
	Manufacturing Labor Cost			Manufacturing Labor Cost			Manufacturing Labor Cost			Manufacturing Labor Cost
	Rates/Hr.	Hours	Total	Rates/Hr.	Hours	Total	Rates/Hr.	Hours	Total	Hours	Total
Labor Category
Fabrication	$ 10.85	400	$ 4,340	$ 11.39	600	$ 6,834	$ 11.96	600	$ 7,176	1600	$ 18,350
Assembly	$ 9.25	-	$ - 0	$ 9.71	200	$ 1,942	$ 10.20	600	$ 6,120	800	8,062
Total Direct Labor - Manufacturing		400	$ 4,340		800	$ 8,776		1200	$ 13,296	2400	$ 26,412
Total Direct Labor			$ 202,603			$ 157,614			$ 118,346		$ 478,563
Direct Labor Overhead	56.70%		$ 114,876			$ 89,367			$ 67,102		$ 271,345
	(Schedule 3)
Explanatory Notes
1. All hours proposed are based on historical costs, reference contract No. DAAH01-99-C-0001, account 9271.
2. The supporting data showing the historical hours and the development of the proposed hours are in the "DAAH01-02-R-0001, Hours" and is available
immediately upon request.
3. The direct labor rates are based on actual average rates as of October 31, 2001, and escalated 5.00% percent each year based on BLS history. The
supporing data and rate calculations are located in file "DAAH01-02-R-0001, Direct Labor Rates" and is available immediately upon request.

&L&"Arial,Bold"3-18 Figure 3-5-1&R&"Arial,Bold"January 2005 &C&"Arial,Bold"Information for Contractors

Schedule 2

					SCHEDULE 2
Advanced Tank Technologies
Washington, DC
Proposal Submitted in Response to RFP DAAH01-02-R0001
Proposed Materials Costs
Shock Absorber
Bill of Material
	Quantity
Description	(Note 4)	Units	Unit Price	Total	Notes
Sheet Metal	1600	sq. yd.	$ 25.00	$ 40,000	1
Casings	750	pcs	$ 8.50	6,375	2
Plastic	7500	pcs	$ 5.75	43,125	1
Springs	1700	pcs	$ 4.00	6,800	2
Bolts	7500	pcs	$ 2.25	16,875	2
Total Material				$ 113,175
Material Overhead	5.00%			$ 5,659	3
	(Schedule 5)
Explanatory Notes
1. These prices are supported by multiple vendor quotes. The proposed prices are those
provided by the low bidder who was the ACME Corporation in their quotation dated October
21, 2001. The quotations are included in file "DAAH01-02-R-0001, Vendor Quotations" that
are available immediately upon request.
2. These prices are supported by the Halloween edition of the Springs R Us Catalog. This
catalog is available for audit in the pricing office.
3. See Schedule 5
4. The proposed quantities are from the engineering drawings for the shock absorber. This
drawing is located in file "DAAH01-02-R-0001, Engineering Drawing" and is immediately
available upon request.

&L&"Arial,Bold"January 2005 SCHEDULE 2&R&"Arial,Bold"3-19 Figure 3-5-1 &C&"Arial,Bold"Information for Contractors

Schedule 3

				SCHEDULE 3
Advanced Tank Technologies
Washington, DC
Budget for Fiscal Year 2002 Labor Overhead
Actual Overhead Expenses for Fiscal Years 1999 through 2001
	Budget	Actual Expenses (Note 1)
Overhead Expenses (Note 2)	2002	2001	2000	1999
Indirect Payroll	$ 260,000
Payroll taxes	228,000
Vacation	120,000
Holiday	110,000
Sick Leave	50,000
Pensions	171,000
Employee Morale	5,000
Entertainment	50,000
Office Equipment	7,000
Depreciation	5,000
Subscriptions	1,500
Travel	22,000
Miscellaneous	2,000
Stationery	6,000
Reproduction	17,000
Maintenance	5,000
Rent	202,000
Telephone	11,000
Insurance	102,000
Total Expense Pool	$ 1,374,500
Less Unallowable Costs:
Entertainment	50,000
Net Allowable Expenses	$ 1,324,500
Allocation Base
Direct Labor	$2,336,000		(Note 3)
Rate	56.70%		(Note 4)
Explanatory Notes
1. Provide the prior three years' actual overhead expense and allocation base in the
same format as the budget for 2002. For the year 2001, actuals to date are provided.
2. The projected overhead expenses are based on the company's operating budget
for 2002. The operating budget supporting data is located in file
"DAAH01-02-R-0001, Overhead Operating Budget" and is immediately available
upon request.
3. Includes Bid and Proposal Labor of $5,000.
4. The same rate is estimated for fiscal years 2003 and 2004. We anticipate
minimal inflation and a stable business base. The data and analysis supporting this
assertion is located in file "DAAH01-02-R-0001, Overhead Forecast" and is
immediately available upon request.

&L&"Arial,Bold"3-20 Figure 3-5-1&R&"Arial,Bold"January 2005 &C&"Arial,Bold"Information for Contractors

Schedule 4

						SCHEDULE 4
Advanced Tank Technologies
Washington, DC
Budget for Fiscal year 2002 G&A
Actual G&A Expenses for Fiscal Years 1999 through 2001
	G&A	Less	Net Allowable	Actual Expenses (Note 1)
2002 Projected G&A Expenses (Note 2)	Expenses	Unallowables	Expenses	2001	2000	1999
Payroll taxes	$ 16,000	-	$ 16,000
Officer's salaries	165,000	-	165,000
Indirect Salaries	21,000	-	21,000
Interest	14,000	14,000	-
Vacation	11,000	-	11,000
Holiday	9,000	-	9,000
Sick Leave	5,000	-	5,000
Contributions	8,000	8,000	-
Pensions	12,000	-	12,000
Office Equipment	1,000	-	1,000
Depreciation	2,500	-	2,500
Travel	10,000	-	10,000
Miscellaneous	2,000	-	2,000
Legal fees	7,000	-	7,000
Accounting Fees	7,000	-	7,000
Computer	17,500	-	17,500
Rent	15,000	-	15,000
Advertising	8,500	8,500	-
Telephone	3,000	-	3,000
Insurance	7,000	-	7,000
Total Pool	341,500	30,500	311,000
B&P	8,500	-	8,500	(Note 3)
Total G&A and B&P	$ 350,000	$ 30,500	$ 319,500
Allocation Base
Labor			$2,331,000
Overhead			1,371,665	(Note 4)
Other Direct Costs			29,000
Materials			250,000
Material Overhead			12,500
Total Base			$3,994,165
G&A Rate			8.00%	(Note 5)
Explanatory Notes
1. Provide the prior three years' actual G&A expenses and the allocation base in the same
format as the 2002 budget. For the year 2001, actuals are provided to date.
2. The projected G&A expenses are based on the company's operating budget for 2002. The operating budget
supporting data is located in file "DAAH01-02-R-0001, G&A Operating Budget" and is available immediately upon
request.
3. Includes $665 B&P Travel ($5,000 + $2,835 + $665).
4. Total Pool, excluded $2,835 allocated to B&P Labor ($5,000 x .567) [$1,374,500 - $2,835].
5. The same rate is estimated for fiscal years 2003 and 2004. We anticipate minimal inflation and a stable business
base. The data and analysis supporting this assertion is included in file "DAAH01-02-R-0001, G&A " and is
available immediately upon request.

&L&"Arial,Bold"January 2005&R&"Arial,Bold"3-21 Figure 3-5-1&"Arial,Regular" &C&"Arial,Bold"Information for Contractors

Schedule 5

					SCHEDULE 5
Advanced Tank Technologies
Washington, DC
Budget for Fiscal year 2002 Labor Overhead
Actual Overhead Expenses for Fiscal Years 1999 through 2001
	Budget		Actual Expenses (Note 1)
Material Handling Expenses (Note 2)	2002	2001	2000	1999
Purchasing Department	$10,000
Receiving Department	2,500
Total Expenses	$12,500
Less Unallowable Costs	-
Net Allowable Expenses	$12,500
Allocation Base
Total Materials	250,000
Materials Overhead Rate (Note 3)	5.00%
Explanatory Notes
1. Provide the prior three years' actual material overhead expenses and allocation base in
the same format as the budget for 2002. For the year 2001, actuals are provided to date.
2. The projected material overhead expenses are based on the company's operating
budget for 2002. The operating budget supported data is located in file
"DAAH01-02-R-0001, Material Overhead-Operating Budget" and is immediately available
upon request.
3. The same rate is estimated for fiscal years 2003 and 2004. We anticipate minimal
inflation and a stable business base. The data and analysis supporting this assertion is
located in file "DAAH01- 02-R-0001, Material Overhead-Forecast" and is available
immediately upon request.

&L&"Arial,Bold"January 2005&R&"Arial,Bold"3-21 Figure 3-5-1 &C&"Arial,Bold"Information for Contractors

MBD04043181.doc

PROPOSAL COVER SHEET

(Cost or Pricing Data Required)

Solicitation/Contract/Modification No.: DAAH01-02-R-0001

Advanced Tank Technologies

500 East Highway

Washington, DC 20001

Point of Contact

Jane Doe

Contracts Manager

(202) 555-1212

Contract Administration Office

Audit Office

DCMA Baltimore

DCAA

District Branch Office

200 Townsontown Blvd., West

8181 Professional Place

Towson, MD 21204-5299

Landover, MD 20785-2218

(301) 339-4800

(301) 436-2090

Type of Contract Action: New Contract – FFP IQC

Proposed Cost + Profit or Fee = Total:

$938,241 + $93,824 = $1,032,065

Government Property:

We will not require the use of any Government property in the performance of this work.

Cost Accounting Standards (CAS) and Estimating & Accounting Compliance:

a. Our organization is NOT subject to the Cost Accounting Standards Board (CASB) Regulations (Public Law 91-379) as amended and FAR Part 30. We have a Small Business Exemption.

b. This contract action is NOT subject to CAS. We have a Small Business Exemption.

c. NO, we have not submitted a CASB Disclosure Statement (CASB DS-1 or 2).

d. We have NOT been notified that we are or may be in noncompliance with our Disclosure Statement or CAS.

e. NO aspect of this proposal is inconsistent with our disclosed practices or applicable CAS.

f. YES, this proposal is consistent with our established estimating and accounting practices and procedures and FAR Part 31, Cost Principles.

This proposal reflects our estimates and/or actual costs as of this date and conforms with the instructions in FAR 15.403-5(b)(1) and FAR 15.408, Table 15-2. By submitting this proposal, we grant the Contracting Officer and authorized representative(s) the right to examine, at any time before award, those records, which include books, documents, accounting procedures and practices, and other data, regardless of type and form or whether such supporting information is specifically referenced or included in the proposal as the basis for pricing, that will permit an adequate evaluation of the proposed price.

10.

Date.

11.

Signature of authorized representative.

File details come from the government source that posted it.