CERTIFIED COST DATA -MultiYear Model Proposal.xls
XLS spreadsheet 105 KB Posted
- Attached to
- 1560 REPAIR KIT, LATCH EIA:F18
- Solicitation number
- SPM4A7-10-R-0950
- Issued by
-
Defense Logistics Agency Aviation
About this file
COST OR PRICING DATA SHOULD BE SUBMITTED IN AN EXCEL FILE FORMATTED LIKE THE ATTACHED SAMPLE. DO NOT SUBMIT HARD COPY. FILE COPY REQUIRED.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| IQC10057009018.pdf | ||
| https //www.dibbs.bsm.dla.mil/rfp/RfpRec.asp SolNum SPM4A710R0950 | — |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Cover Page
Double click on WORD icon to open the Cover Page template.
Summary
| Vandelay Industries | |||||||||||||||||
| SPM4A6-08-R-XXXX | |||||||||||||||||
| Summary - Total Proposed Costs | |||||||||||||||||
| Base Period - FY 2009 | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | All Years | ||||||||||||
| Element of Cost | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Total | Reference |
| Material | $ 3,360.00 | $ 1,491,840.00 | $ 3,528.00 | $ 1,566,432.00 | $ 3,704.40 | $ 1,644,753.60 | $ 3,889.63 | $ 1,726,995.72 | $ 4,084.11 | $ 1,813,344.84 | $ 8,243,366.16 | Schedule A | |||||
| Material Overhead | 5.60% | 188.16 | 83,543.04 | 5.60% | 197.57 | 87,720.19 | 5.60% | 207.45 | 92,106.00 | 5.60% | 217.82 | 96,711.76 | 5.60% | 228.71 | 101,547.31 | 461,628.30 | Schedule B |
| Direct Labor | 63.20 | 28,060.80 | 65.42 | 29,046.48 | 67.70 | 30,058.80 | 70.07 | 31,111.08 | 72.53 | 32,203.32 | 150,480.48 | Schedule C | |||||
| Mfg Overhead | 18.00% | 11.38 | 5,052.72 | 18.00% | 11.78 | 5,230.32 | 20.15% | 13.64 | 6,056.16 | 18.00% | 12.61 | 5,598.84 | 17.37% | 12.60 | 5,594.00 | 27,532.04 | Schedule D |
| Subtotal | 3,622.74 | 1,608,496.56 | 3,802.77 | 1,688,428.99 | 3,993.19 | 1,772,974.56 | 4,190.13 | 1,860,417.40 | 4,397.95 | 1,952,689.47 | 8,883,006.98 | ||||||
| G&A | 15.00% | 543.41 | 241,274.04 | 15.86% | 603.07 | 267,763.08 | 16.15% | 644.90 | 286,335.60 | 15.99% | 670.01 | 297,484.44 | 15.98% | 702.80 | 312,043.20 | 1,404,900.36 | Schedule E |
| Total Cost | 4,166.15 | 1,849,770.60 | 4,405.84 | 1,956,192.96 | 4,638.09 | 2,059,311.96 | 4,860.14 | 2,157,902.16 | 5,100.75 | 2,264,733.00 | 10,287,910.68 | ||||||
| Profit | 10.00% | 416.62 | 184,979.28 | 10.00% | 440.58 | 195,617.52 | 10.00% | 463.81 | 205,931.64 | 10.00% | 486.01 | 215,788.44 | 10.00% | 510.08 | 226,476.00 | 1,028,792.88 | |
| Total Price | $ 4,582.77 | $ 2,034,749.88 | $ 4,846.42 | $ 2,151,810.48 | $ 5,101.90 | $ 2,265,243.60 | $ 5,346.15 | $ 2,373,690.60 | $ 5,610.83 | $ 2,491,209.00 | $ 11,316,703.56 | ||||||
| Quantity (EAD) | 444 | 444 | 444 | 444 | 444 | 2,220 | |||||||||||
| 1. The projected manufacturing overhead expenses are based on budgetary estimates (YTD actual costs, prior FY acutal costs, etc) for the period of (200U). | |||||||||||||||||
| SURGE | |||||||||||||||||
| Base Period - FY 2009 | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | All Years | ||||||||||||
| Element of Cost | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Total | Reference |
| located (description of location, file, etc) and is available immediately upon request. | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Schedule A | ||||||||||
| Material Overhead | 5.60% | $ - 0 | $ - 0 | 5.60% | $ - 0 | $ - 0 | 5.60% | $ - 0 | $ - 0 | 5.60% | $ - 0 | $ - 0 | 5.60% | $ - 0 | $ - 0 | $ - 0 | Schedules A & B |
| Direct Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Schedule C | ||||||||||
| Mfg Overhead | 18.00% | $ - 0 | $ - 0 | 18.00% | $ - 0 | $ - 0 | 20.15% | $ - 0 | $ - 0 | 18.00% | $ - 0 | $ - 0 | 17.37% | $ - 0 | $ - 0 | $ - 0 | Schedules C & D |
| Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| G&A | 15.00% | $ - 0 | $ - 0 | 15.86% | $ - 0 | $ - 0 | 16.15% | $ - 0 | $ - 0 | 15.99% | $ - 0 | $ - 0 | 15.98% | $ - 0 | $ - 0 | $ - 0 | Schedule E |
| Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Profit | 10.00% | $ - 0 | $ - 0 | 10.00% | $ - 0 | $ - 0 | 10.00% | $ - 0 | $ - 0 | 10.00% | $ - 0 | $ - 0 | 10.00% | $ - 0 | $ - 0 | $ - 0 | |
| Total Price | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
&R&12&F&A
Schedule A - Material
| Vandelay Industries | Schedule A | ||||||||||||||
| SPM4A6-08-R-XXXX | |||||||||||||||
| Material | |||||||||||||||
| Bill of Material: | |||||||||||||||
| Base Year | Option Yr 1 | Option Yr 2 | Option Yr 3 | Option Yr 4 | Total | ||||||||||
| Quantity | Extended | ||||||||||||||
| Per Unit | Price / | Total | Total | Total | Total | Total | |||||||||
| Description | Units | Unit Price | (Note 5) | Unit Price | Material | Unit Price | Material | Unit Price | Material | Unit Price | Material | Unit Price | Material | Notes | |
| MMMMMMM | sq. yd. | $ 1,000.00 | 2 | $ 2,000.00 | $ 888,000.0 | $ 2,100.00 | $ 932,400.0 | $ 2,205.00 | $ 979,020.0 | $ 2,315.25 | $ 1,027,971.0 | $ 2,431.01 | $ 1,079,368.4 | $ 4,906,759.44 | 1 |
| MMMMMMM | pcs | $ 500.00 | 2 | $ 1,000.00 | $ 444,000.0 | $ 1,050.00 | $ 466,200.0 | $ 1,102.50 | $ 489,510.0 | $ 1,157.63 | $ 513,987.7 | $ 1,215.51 | $ 539,686.4 | $ 2,453,384.16 | 2 |
| MMMMMMM | pcs | $ 40.00 | 1 | $ 40.00 | $ 17,760.0 | $ 42.00 | $ 18,648.0 | $ 44.10 | $ 19,580.4 | $ 46.31 | $ 20,561.6 | $ 48.63 | $ 21,591.7 | $ 98,141.76 | 1 |
| MMMMMMM | pcs | $ 300.00 | 1 | $ 300.00 | $ 133,200.0 | $ 315.00 | $ 139,860.0 | $ 330.75 | $ 146,853.0 | $ 347.29 | $ 154,196.8 | $ 364.65 | $ 161,904.6 | $ 736,014.36 | 2 |
| MMMMMMM | pcs | $ 20.00 | 1 | $ 20.00 | $ 8,880.0 | $ 21.00 | $ 9,324.0 | $ 22.05 | $ 9,790.2 | $ 23.15 | $ 10,278.6 | $ 24.31 | $ 10,793.6 | $ 49,066.44 | 2 |
| Total Material | $ 3,360.00 | $ 1,491,840.0 | $ 3,528.00 | $ 1,566,432.0 | $ 3,704.40 | $ 1,644,753.6 | $ 3,889.63 | $ 1,726,995.7 | $ 4,084.11 | $ 1,813,344.8 | $ 8,243,366.16 | ||||
| EAD Quantity | 444 | 444 | 444 | 444 | 444 | 2,220 | |||||||||
| Cost Escalation | 5.00% | 5.00% | 5.00% | 5.00% | 3 | ||||||||||
| Material Overhead | 5.60% | $ 188.16 | $ 83,543.04 | $ 197.57 | $ 87,720.19 | $ 207.45 | $ 92,106.00 | $ 217.82 | $ 96,711.76 | $ 228.71 | $ 101,547.31 | $ 461,628.30 | 4 | ||
| 1. The projected manufacturing overhead expenses are based on budgetary estimates (YTD actual costs, prior FY acutal costs, etc) for the period of (200U). | (Schedule B) | ||||||||||||||
| 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, 2007. The quotations are included in file "SPM4AD-08-R-XXXX, 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. The proposed escalation is based on (PPI, Global Insight recommendations, other reliable forecast index recommendations, etc) | |||||||||||||||
| 4. See Schedule B | |||||||||||||||
| 5. 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. |
&R&F&A
Schedule B - Material OH
| Vandelay Industries | Schedule B | |
| SPM4A6-08-R-XXXX | ||
| Material Overhead | ||
| Material Overhead Expenses | 200U | |
| Total Expense Pool | $2,000,000 | |
| Less Unallowable Costs | 40,000 | |
| Net Allowable Expenses | $1,960,000 | |
| Allocation Base | ||
| Total Materials | 35,000,000 | |
| Materials Overhead Rate | 5.60% | |
| Explanatory Notes | ||
| 1. The projected manufacturing overhead expenses are based on budgetary estimates (or YTD actual costs, prior FY acutal costs, etc) | ||
| for the period of 200U. The supporting data is available immediately upon request. | ||
| 2. The same rate is estimated for fiscal years 200U through 200Z. We anticipate minimal | ||
| inflation and a stable business base. The data and analysis supporting this assertion is | ||
| located in file "DAAH01-07-R-0001, Operating Material OH Budget" and is available immediately upon request. | ||
| (Of course it is preferred that Ktr prepare budgetary forecasts to project their expected indirect/overhead | ||
| rates for out years, and to present that information as part of the submission.) |
&R&F&A
Schedule C - Labor
| Vandelay Industries | Schedule C | ||||||||||||||||||
| SPM4A6-08-R-XXXX | |||||||||||||||||||
| Labor | |||||||||||||||||||
| Unit | Base Year | Option 1 | Option 2 | Option 3 | Option 4 | Total | |||||||||||||
| Labor | Labor | Unit | Total | Labor | Unit | Total | Labor | Unit | Total | Labor | Unit | Total | Labor | Unit | Total | ||||
| Labor Category or Mfg Process | Hours | Rate | Labor | Labor | Rate | Labor | Labor | Rate | Labor | Labor | Rate | Labor | Labor | Rate | Labor | Labor | |||
| (Note 1) | (Note 2) | ||||||||||||||||||
| Engineering | 1.2 | $ 48.00 | $ 57.60 | $ 25,574.40 | $ 49.68 | $ 59.62 | $ 26,471.28 | $ 51.42 | $ 61.70 | $ 27,394.80 | $ 53.22 | $ 63.86 | $ 28,353.84 | $ 55.08 | $ 66.10 | $ 29,348.40 | $ 137,142.72 | ||
| Assembly | 0.4 | $ 14.00 | $ 5.60 | $ 2,486.40 | $ 14.49 | $ 5.80 | $ 2,575.20 | $ 15.00 | $ 6.00 | $ 2,664.00 | $ 15.53 | $ 6.21 | $ 2,757.24 | $ 16.07 | $ 6.43 | $ 2,854.92 | $ 13,337.76 | ||
| Total | 1.6 | $ 63.20 | $ 28,060.80 | $ 65.42 | $ 29,046.48 | $ 67.70 | $ 30,058.80 | $ 70.07 | $ 31,111.08 | $ 72.53 | $ 32,203.32 | $ 150,480.48 | |||||||
| Labor Rate Escalation (Note 2) | 3.5% | 3.5% | 3.5% | 3.5% | |||||||||||||||
| EAD Quantities | 444 | 444 | 444 | 444 | 444 | 2,220 | |||||||||||||
| Mfg. Overhead | (Schedule D) | 18.00% | $ 11.38 | $ 5,052.72 | 18.00% | $ 11.78 | $ 5,230.32 | 20.15% | $ 13.64 | $ 6,056.16 | 18.00% | $ 12.61 | 5598.84 | 17.37% | $ 12.60 | $ 5,594.40 | $ 27,532.44 | ||
| SURGE | |||||||||||||||||||
| 1. The projected manufacturing overhead expenses are based on budgetary estimates (YTD actual costs, prior FY acutal costs, etc) for the period of (200U). | |||||||||||||||||||
| Unit | |||||||||||||||||||
| Labor | Labor | Total | Base | ||||||||||||||||
| Labor Category or Mfg Process | Hours | Rate | Labor | Year | Option 1 | Option 2 | Option 3 | Option 4 | Total | ||||||||||
| located (description of location, file, etc) and is available immediately upon request. | $ - 0 | $ - 0 | |||||||||||||||||
| Assembly | $ - 0 | $ - 0 | |||||||||||||||||
| Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||
| EAD Quantities | 0 | ||||||||||||||||||
| Explanatory Notes | |||||||||||||||||||
| 1. All hours proposed are based on ( historical actuals for the period of ,,,,,,,,,,,,,,, FY 2008 standards, engineering estimates, etc.) | |||||||||||||||||||
| The supporting data showing the historical hours and the development of the proposed hours are in the (description of where data is located) and is available immediately | |||||||||||||||||||
| upon request. | |||||||||||||||||||
| 2. The direct labor rates are based on (actual average rates, standard rates, actual labor rates of specified individuals, etc.) as of | |||||||||||||||||||
| (date) and escalated 3.50% percent each year based on (historical pay raises, BLS, PPI, etc.) . The supporting data and | |||||||||||||||||||
| rate calculations are located ,,,,,,,,,,,,,,,.and is available immediately upon request. |
&R&F&A
Schedule D - Mfg OH
| Vandelay Industries | Schedule D | |||||
| SPM4A6-08-R-XXXX | ||||||
| Mfg Overhead | ||||||
| Manufacturing Overhead Expenses | 200U | 200V | 200X | 200Y | 200Z | |
| Total Expense Pool | $2,000,000 | $2,100,000 | $2,200,000 | $1,900,000 | $1,850,000 | |
| Less Unallowable Costs | 200,000 | 210,000 | 185,000 | 190,000 | 200,000 | |
| Net Allowable Expenses | $1,800,000 | $1,890,000 | $2,015,000 | $1,710,000 | $1,650,000 | |
| Allocation Base | ||||||
| Total Labor Dollars | 10,000,000 | 10,500,000 | 10,000,000 | 9,500,000 | 9,500,000 | |
| Manufacturing Overhead Rate | 18.00% | 18.00% | 20.15% | 18.00% | 17.37% | |
| Explanatory Notes | ||||||
| 1. The projected manufacturing overhead expenses are based on (budgetary estimates, YTD actual costs, prior FY actual costs, etc) | ||||||
| for the period of 200U to 200Z. | ||||||
| 2. Expense pools and allocation bases are based on projected budgetary forecasts and expected business | ||||||
| volume. Supporting details are available immediately upon request from the Comptroller and | ||||||
| are located in file "DAAH01-07-R-0001, Operation Mfg Overhead Budget" and is | ||||||
| immediately available upon request. |
&R&F&A
Schedule E - G&A
| Vandelay Industries | Schedule E | |||||
| SPM4A6-08-R-XXXX | ||||||
| G&A | ||||||
| G&A Expenses | ||||||
| 200U | 200V | 200X | 200Y | 200Z | ||
| Total Expense Pool | $7,500,000 | $8,000,000 | $8,250,000 | $8,280,000 | $8,200,000 | |
| Less Unallowable Costs | 150,000 | 150000 | 175000 | 125000 | 130000 | |
| Net Allowable Expenses | $7,350,000 | $7,850,000 | $8,075,000 | $8,155,000 | $8,070,000 | |
| Allocation Base | ||||||
| Total Cost Input | $49,000,000 | $49,500,000 | $50,000,000 | $51,000,000 | $50,500,000 | |
| G&A Rate | 15.00% | 15.86% | 16.15% | 15.99% | 15.98% | |
| Explanatory Notes | ||||||
| 1. The projected manufacturing overhead expenses are based on budgetary estimates (YTD actual costs, prior FY acutal costs, etc) | ||||||
| for the period of 200U to 200Z. | ||||||
| The supporting data is available immediately upon request. | ||||||
| 2. Expense pools and allocation bases are based on projected budgetary forecasts and expected business | ||||||
| volume. Supporting details are available immediately upon request from the Comptroller | ||||||
| and are located in file"DAAH01-07-R-0001, Operating G&A Budget". |
&R&F&A
MBD014E4A5C.doc 3-16
January 2005
Figure 3-5-1
Figure 3-5-1 Model Proposal
PROPOSAL COVER SHEET
(Cost or Pricing Data Required)
1.
Solicitation/Contract/Modification No.: SPM4A6-08-R-XXXX
Vandelay Industries
500 East Highway
Washington, DC 20001
3.
Point of Contact
George Costanza
Contracts Manager
(202) 555-1212
4.
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
5.
Type of Contract Action: New Contract – FFP IQC
6.
Proposed Cost + Profit or Fee = Total:
$10,287,910.68+ $1,028,792.88 = $11,316,703.56
7.
Government Property:
We will not require the use of any Government property in the performance of this work.
8.
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.
9.
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 ___________________________________
Art Vandelay, President
Information for Contractors
File details come from the government source that posted it. Updated .