Cost_Proposal_Sample.xls
XLS spreadsheet 144 KB Posted
- Attached to
- Broad Agency Announcement Federal contract opportunity
- Solicitation number
- W91CRB-16-R-0005
About this file
Cost Proposal Sample Spreadsheet
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| B01_W91CRB-16-R-0005_Amendment 0003.pdf | ||
| A07_W91CRB-16-R-0005-0002.pdf | ||
| A01_BAA_W91CRB-16-R-0005_changes_dated_12132018.pdf | ||
| A01_W91CRB-16-R-0005_BAA_FY16-20_PWS_Amendment_0001.pdf | ||
| A07_BAA_W91CRB-16-R-0005_Solicitation_Amendment_0001.pdf | ||
| A07_BAA_W91CRB-16-R-0005_Solicitation_Final.pdf | ||
| BAA_W91CRB-16-R-0005_Solicitation.pdf |
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
Text version
PROPOSAL COVER SHEET
PROPOSAL SUMMARY
| PROPOSAL SUMMARY | |||
| Proposal Submitted In Response to RFP W91CRB-16-R-0005 (ATTACHMENT D) | |||
| Proposed | Proposed | ||
| Elements Of Cost: | Rate | Amount | Reference |
| Direct Material | $ 113,175.00 | Schedule 1 | |
| Material Handling Overhead | 5.00% | $ 5,658.75 | Schedules 1&2 |
| Engineering Labor | $ 452,165.06 | Schedule 3 | |
| Manufacturing Labor | $ 26,412.00 | Schedule 3 | |
| Direct Labor Overhead | 56.70% | $ 271,353.19 | Schedules 3&4 |
| Subcontracts | - 0 | ||
| Other Direct Costs (ODCs) | - 0 | ||
| SUBTOTAL | $ 868,764.00 | ||
| General & Administrative (G&A) Expense | 7.98% | $ 69,357.85 | Schedule 5 |
| TOTAL COST | $ 938,121.85 | ||
| Profit/Fee* | 8.00% | $ 75,049.75 | |
| FCCOM** | - 0 | ||
| TOTAL PRICE | $ 1,013,171.60 | ||
| * DFARS 215.404-4 provides guidelines on proposed profit/fee. | |||
| ** Only if Applicable - Facilities Capital Cost Of Money (FCCOM) | |||
| To be allowable FCCOM must be prepared in accordance with | |||
| FAR Appendix 1, FAR part 9904.414. | |||
| Name: _______________________________ | |||
| Title: ________________________________ | |||
| Signature:_____________________________ | |||
| THIS IS A SAMPLE SPREADSHEET FOR PROPOSALS SUBMITTED IN RESPONSE TO RFP W91CRB-16-R-0005 |
SCHED 1
| SCHEDULE 1 - DIRECT MATERIAL | |||||
| Proposal Submitted In Response to RFP W91CRB-16-R-0005 | |||||
| BILL OF MATERIAL | |||||
| Category | QTY (Note 4) | Unit Of Measure | Unit Price | Total | Notes |
| Sheet Metal | 1,600.00 | sq yd | $ 25.00 | $ 40,000.00 | 1 |
| Casings | 750.00 | piece | $ 8.50 | $ 6,375.00 | 2 |
| Plastic | 7,500.00 | piece | $ 5.75 | $ 43,125.00 | 1 |
| Springs | 1,700.00 | piece | $ 4.00 | $ 6,800.00 | 2 |
| Bolts | 7,500.00 | piece | $ 2.25 | $ 16,875.00 | 2 |
| Subtotal | $ 113,175.00 | ||||
| Material OH | 5.00% | $ 5,658.75 | 3 | ||
| Total | $ 118,833.75 | ||||
| Explanatory Notes: | |||||
| 1. These prices are supported by multiple vendor quotes. Quotations are available upon request. | |||||
| 2. Unit prices are contained in XXXXXX Catalog 00-0000. Catalog is available upon request. | |||||
| 3. See Schedule 2 for OH rate computation. | |||||
| 4. The proposed quantities are from engineering drawings. The drawings are availble for review upon request. | |||||
| THIS IS A SAMPLE SPREADSHEET FOR PROPOSALS SUBMITTED IN RESPONSE TO RFP W91CRB-16-R-0005 |
SCHED 2
| SCHEDULE 2 - MATERIAL OVERHEAD RATE | |||||
| Proposal Submitted In Response to RFP W91CRB-16-R-0005 | |||||
| MATERIAL OVERHEAD | |||||
| Budget | Actual Expenses (Note 1) | ||||
| Material Handling Expenses (Note 2) | FY 20XX | FY 20xx | FY 20xx | FY 20xx | |
| Purchasing Dept. | $ 10,000.00 | ||||
| Receiving Dept. | $ 2,500.00 | ||||
| Total Expenses | $ 12,500.00 | ||||
| Less: FAR 31 Unallowable Expense | $ - 0 | ||||
| Net Allowable Expenses | $ 12,500.00 | ||||
| Allocation Base | |||||
| Materials (Total For Year) | $ 250,000.00 | ||||
| Material Overhead Rate | 5.00% | Note 3 | |||
| Expanatory Notes: | |||||
| 1. Provide the prior three years actual amounts . | |||||
| 2. The projected material OH expenses are based on the operating budget for FY 20XX. | |||||
| 3. The same rate is estimated for the FY 20XX & 20XX outyears. | |||||
| THIS IS A SAMPLE SPREADSHEET FOR PROPOSALS SUBMITTED IN RESPONSE TO RFP W91CRB-16-R-0005 |
SCHED 3
| SCHEDULE 3 - DIRECT LABOR | |||||||||||
| Proposal Submitted In Response to RFP W91CRB-16-R-0005 | |||||||||||
| DIRECT LABOR | |||||||||||
| FY 20xx | FY 20xx | FY 20xx | TOTAL | ||||||||
| ENGINEERING DIRECT LABOR | Rate/Hr | Hours | $ | Rate/Hr | Hours | $ | Rate/Hr | Hours | $ | Hours | $ |
| Program Manager | $ 33.93 | 683.00 | $ 23,174.19 | $ 35.65 | 760.00 | $ 27,094.00 | $ 37.41 | 507.00 | $ 18,966.87 | 1,950.00 | $ 69,235.06 |
| Senior engineer | $ 26.39 | 1,200.00 | $ 31,668.00 | $ 27.71 | 900.00 | $ 24,939.00 | $ 29.10 | 700.00 | $ 20,370.00 | 2,800.00 | $ 76,977.00 |
| Junior engineer | $ 22.12 | 1,800.00 | $ 39,816.00 | $ 23.23 | 1,500.00 | $ 34,845.00 | $ 24.39 | 900.00 | $ 21,951.00 | 4,200.00 | $ 96,612.00 |
| Engineering Aide | $ 14.50 | 1,800.00 | $ 26,100.00 | $ 15.23 | 550.00 | $ 8,376.50 | $ 15.99 | 50.00 | $ 799.50 | 2,400.00 | $ 35,276.00 |
| Technical Writer | $ 16.00 | - 0 | $ - 0 | $ 16.80 | - 0 | $ - 0 | $ 17.64 | 900.00 | $ 15,876.00 | 900.00 | $ 15,876.00 |
| Metallurgist | $ 18.85 | 1,900.00 | $ 35,815.00 | $ 19.79 | 1,200.00 | $ 23,748.00 | $ 20.78 | 700.00 | $ 14,546.00 | 3,800.00 | $ 74,109.00 |
| Draftsman | $ 18.95 | 2,200.00 | $ 41,690.00 | $ 19.90 | 1,500.00 | $ 29,850.00 | $ 20.90 | 600.00 | $ 12,540.00 | 4,300.00 | $ 84,080.00 |
| TOTAL | 9,583.00 | $ 198,263.19 | 6,410.00 | $ 148,852.50 | 4,357.00 | $ 105,049.37 | 20,350.00 | $ 452,165.06 | |||
| FY 20xx | FY 20xx | FY 20xx | TOTAL | ||||||||
| MANUFACTURING DIRECT LABOR | Rate/Hr | Hours | $ | Rate/Hr | Hours | $ | Rate/Hr | Hours | $ | Hours | $ |
| Fabrication | $ 10.85 | 400.00 | $ 4,340.00 | $ 11.39 | 600.00 | $ 6,834.00 | $ 11.96 | 600.00 | $ 7,176.00 | 1,600.00 | $ 18,350.00 |
| Assembly | $ 9.25 | - 0 | $ - 0 | $ 9.71 | 200.00 | $ 1,942.00 | $ 10.20 | 600.00 | $ 6,120.00 | 800.00 | $ 8,062.00 |
| TOTAL | 400.00 | $ 4,340.00 | 800.00 | $ 8,776.00 | 1,200.00 | $ 13,296.00 | 2,400.00 | $ 26,412.00 | |||
| TOTAL DIRECT LABOR | $ 202,603.19 | $ 157,628.50 | $ 118,345.37 | $ 478,577.06 | |||||||
| DIRECT LABOR OVERHEAD | 56.70% | $ 114,876.01 | 56.70% | $ 89,375.36 | 56.70% | $ 67,101.82 | $ 271,353.19 | ||||
| All labor hours proposed were estimated based on historical hours on a similar prior contract. | |||||||||||
| The support for the proposed hours is available upon request. | |||||||||||
| The direct labor rates are based on actual historical average rates as of 12/31/xx. | |||||||||||
| THIS IS A SAMPLE SPREADSHEET FOR PROPOSALS SUBMITTED IN RESPONSE TO RFP W91CRB-16-R-0005 |
SCHED 4
| SCHEDULE 4 - DIRECT LABOR OVERHEAD RATE | |||||
| Proposal Submitted In Response to RFP W91CRB-16-R-0005 | |||||
| DIRECT LABOR OVERHEAD RATE | |||||
| Budget (Note 2) | Actual Expenses (Note 1) | ||||
| Overhead Expenses: | FY 20xx | FY 20xx | FY 20xx | FY 20xx | |
| Indirect payroll | $ 260,000.00 | ||||
| Payroll taxes (FICA, FUTA, SUTA, Workmans Comp) | $ 228,000.00 | ||||
| Vacation | $ 120,000.00 | ||||
| Holiday | $ 110,000.00 | ||||
| Sick Leave | $ 50,000.00 | ||||
| Pensions | $ 171,000.00 | ||||
| Employee Morale | $ 5,000.00 | ||||
| Entertainment | $ 50,000.00 | ||||
| Office Equipment | $ 7,000.00 | ||||
| Depreciation | $ 5,000.00 | ||||
| Subscriptions | $ 1,500.00 | ||||
| Travel | $ 22,000.00 | ||||
| Miscellaneous | $ 2,000.00 | ||||
| Stationery | $ 6,000.00 | ||||
| Reproduction | $ 17,000.00 | ||||
| Maintenance | $ 5,000.00 | ||||
| Rent | $ 202,000.00 | ||||
| Telephone | $ 11,000.00 | ||||
| Insurance | $ 102,000.00 | ||||
| Total Pool | $ 1,374,500.00 | $ - 0 | $ - 0 | $ - 0 | |
| Less: FAR 31 Unallowable Cost | |||||
| Entertainment | $ (50,000.00) | $ - 0 | $ - 0 | $ - 0 | |
| Net Allowable cost | $ 1,324,500.00 | $ - 0 | $ - 0 | $ - 0 | |
| Allocation Base | |||||
| Direct Labor | $ 2,336,000.00 | $ - 0 | $ - 0 | $ - 0 | |
| Rate | 56.70% | 0.00% | 0.00% | 0.00% | Note 3 |
| Explanatory Notes: | |||||
| 1. Provide the prior three years actual overhead expense and allocation base. | |||||
| 2. The proposed overhead expenses & allocation base are based on the opertaing budget for FY 20xx which is based on | |||||
| prior years actual historical experience. | |||||
| 3. The same rate is estimated for FY 20xx & 20xx. | |||||
| THIS IS A SAMPLE SPREADSHEET FOR PROPOSALS SUBMITTED IN RESPONSE TO RFP W91CRB-16-R-0005 |
SCHED 5
| SCHEDULE 5 - GENERAL & ADMINISTRATIVE (G&A) EXPENSE | |||||
| Proposal Submitted In Response to RFP W91CRB-16-R-0005 | |||||
| G&A EXPENSE RATE | |||||
| Budget (Note 2) | Actual Expenses (Note 1) | ||||
| G&A Expenses: | FY 20xx | FY 20xx | FY 20xx | FY20xx | |
| Payroll taxes (FICA, FUTA, SUTA, Workmans Comp) | $ 16,000.00 | ||||
| Officer's Salaries | $ 165,000.00 | ||||
| Administrative Salaries | $ 21,000.00 | ||||
| Interest | $ 14,000.00 | ||||
| Vacation | $ 11,000.00 | ||||
| Holiday | $ 9,000.00 | ||||
| Sick Leave | $ 5,000.00 | ||||
| Contributions | $ 8,000.00 | ||||
| Pensions | $ 12,000.00 | ||||
| Office Equipment | $ 1,000.00 | ||||
| Depreciation | $ 2,500.00 | ||||
| Travel | $ 10,000.00 | ||||
| Miscellaneous | $ 2,000.00 | ||||
| Legal Fees | $ 7,000.00 | ||||
| Accounting Fees | $ 7,000.00 | ||||
| Computer Cost | $ 17,500.00 | ||||
| Rent | $ 15,000.00 | ||||
| Advertising | $ 8,500.00 | ||||
| Telephone | $ 3,000.00 | ||||
| Insurance | $ 7,000.00 | ||||
| Total Pool | $ 341,500.00 | $ - 0 | $ - 0 | $ - 0 | |
| Bid & Proposal (B&P) Cost | $ 8,500.00 | $ - 0 | $ - 0 | $ - 0 | |
| Total G&A & B&P Cost | $ 350,000.00 | $ - 0 | $ - 0 | $ - 0 | |
| Less: FAR 31 Unallowable Costs | |||||
| Interest | $ (14,000.00) | $ - 0 | $ - 0 | $ - 0 | |
| Contributions | $ (8,000.00) | $ - 0 | $ - 0 | $ - 0 | |
| Advertising | $ (8,500.00) | $ - 0 | $ - 0 | $ - 0 | |
| Total Unallowable Costs | $ (30,500.00) | $ - 0 | $ - 0 | $ - 0 | |
| G&A Pool After Deducting Unallowable Cost | $ 319,500.00 | $ - 0 | $ - 0 | $ - 0 | |
| Allocation Base (Note 3) | |||||
| Direct Labor (From Sched 4) | $ 2,336,000.00 | ||||
| Overhead (From Sched 4-Must Include Unallowables Too) | $ 1,374,500.00 | ||||
| Direct Materials (From Sched 2) | $ 250,000.00 | ||||
| Material Overhead (From Sched 2) | $ 12,500.00 | ||||
| Subcontracts (If Included In Total Cost Base-CAS 410) | $ - 0 | ||||
| Other Direct Costs (Total ODCs From Ledger) | $ 29,000.00 | ||||
| Total G&A Allocation Base | $ 4,002,000.00 | $ - 0 | $ - 0 | $ - 0 | |
| Rate | 7.98% | 0.00% | 0.00% | 0.00% | Note 4 |
| Explanatory Notes: | |||||
| 1. Provide the prior three years actual overhead expense and allocation base. | |||||
| 2. The proposed overhead expenses & allocation base are based on the opertaing budget for FY 20xx which is based on | |||||
| prior years actual historical experience. | |||||
| 3. Base should include all elements of allowable and unallowable cost NOT included in G&A and B&P pool. | |||||
| 4. The same rate is estimated for FY 20xx and FY 20xx. | |||||
| THIS IS A SAMPLE SPREADSHEET FOR PROPOSALS SUBMITTED IN RESPONSE TO RFP W91CRB-16-R-0005 |
ODCs
| OTHER DIRECT COST (ODC) LEDGER | ||||||||||
| Proposal Submitted In Response to RFP W91CRB-10-R-0073 | Proposal Submitted In Response to RFP W91CRB-16-R-0005 | |||||||||
| OTHER DIRECT COSTS | ||||||||||
| FY 20xx | FY 20xx | FY 20xx | ||||||||
| DESCRIPTION | Unit Of Measure | QTY | Unit Price | Unit Of Measure | QTY | Unit Price | Unit Of Measure | QTY | Unit Price | TOTAL |
| eg. Materials, Supplies, and Consumables: | ||||||||||
| a.) | ||||||||||
| b.) | ||||||||||
| c.) | ||||||||||
| THIS IS A SAMPLE SPREADSHEET FOR PROPOSALS SUBMITTED IN RESPONSE TO RFP W91CRB-16-R-0005 |
MBD00134F44.doc
PROPOSAL COVER SHEET
1.
Solicitation/Contract/Modification No.: W91CRB-16-R-005
2.
XYZ Inc
500 East Highway
Baltimore, MD 21204
3.
Point of Contact
John Doe
Contracts manager
(410) 555-1212
4.
Contract Administration Office
Audit Office
DCMA Baltimore
DCAA Baltimore Branch Office
201 Redwood St
6141 BelAir Rd
Baltimore, MD 21204-5299
Baltimore, MD 21204
(410) 339-4800
(410) 962-3857
5.
Type Of Contract Action: New CPFF Contract, 5 Years
Task 1
Proposed Cost + Profit/fee = Total
$938,121.85 + $93,812.18 = $1,031,934.03
Task 2
Proposed Cost + Profit/fee = Total
$938,121.85 + $93,812.18 = $1,031,934.03
6.
Government Property?
We will not require the use of any government property/GFE during the performance of this contract.
7.
Cost Accounting Standards (CAS) and Estimating & Accounting Compliance a.
Does the company have any contracts covered by the Cost Accounting Standards (CAS - Public law 91-379 – FAR Appendix 1, Part 9900)? No, we currently have no CAS covered contracts. Furthermore, we claim a small business exemption to CAS per FAR Part 9903.201-1(b)(3).
b.
If the answer to (a) above was yes, has your company ever submitted a FAR 9903.202 CAS Disclosure Statement? And when was it approved? N/A, no disclosure statement is necessary because of the small business exemption above.
c.
Was this proposal prepared consistent with the company’s current accounting and estimating practices/system. Or was the proposal prepared on a different basis? The proposal was prepared using our current estimating and accounting systems. The adequacy of our accounting system was found to be acceptable in DCAA Audit Report 06141-2009K17710001.
d.
Does the proposal contain any unallowable costs as outlined in FAR Part 31? No, all FAR 31 unallowable costs were identified and removed from the proposed amounts in this proposal.
8.
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 5.408, Table 15-2. By submitting this proposal, we grant the Contracting Officer and authorized representatives the right to examine, at any time before award, those records which include hard-copy and electronic books, documents, accounting records & procedures and practices, and other data regardless of type and or or whether such supporting information is specifically referenced or included in the proposal as the basis for pricing that will permit adequate evaluation of the proposed cost/price.
10.
Date:
11.
Signature of Company Officer:
12.
Printed/Typed Name of Company Officer:
THIS IS A SAMPLE SPREADSHEET FOR PROPOSALS SUBMITTED IN RESPONSE TO RFP W91CRB-16-R-0005
File details come from the government source that posted it. Updated .