cost breakout_Spreadsheet - Railcar Modification 12172025.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- Aberdeen Test Center Railcar Modification
- Solicitation number
- W91CRB-Q-A004
About this file
The provided file is a cost breakout spreadsheet for a Railcar Modification project, associated with the Aberdeen Test Center Railcar Modification solicitation (W91CRB-Q-A004) issued by the Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground. The solicitation is for a non-personal services contract to update the cushioned draft gear on two specific Department of Defense Railcars (DODX 40061 and DODX 40020) to a standard draft gear configuration.
The quotation submission deadline is 17 February 2026 at 2:00 PM, with potential vendors able to submit questions via email to the listed points of contact. While the specific cost details are not visible in the provided context, the associated spreadsheet (cost breakout_Spreadsheet) suggests a detailed financial breakdown of the railcar modification project exists. Interested contractors should refer to the full solicitation on SAM.gov for comprehensive requirements and submission guidelines.
View the file
Other files
Show all 17
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
Total Cost
| This section oof the cost breakout sheet will present the total cost of the quotation. | ||||||
| CLIN | CLIN Type | Description | Quantity | Unit of Measure | Rate | Cost |
| 0001 | FFP | Complete requirements stated in Performance Work Statement section 1.4 Objectives and 3.0 Technical Requirements | 1 | Job | $ - 0 |
Total Cost: $ - 0
In tab labor category please provide a breakout of RMSS labor categories with hours per labor category and the corresponding labor rates. In Tab Materials please breakout any materials required.
Labor Categories
| Direct Labor | Indirect Labor | |
| CLIN 0001: FFP Fume Hoods | 30.00% |
Lane, Noah R CIV: Lane, Noah R CIV:
Please Fill out 25.00% Lane, Noah R CIV: Lane, Noah R CIV:
Please fill out 8.00% Lane, Noah R CIV: Lane, Noah R CIV:
Please fill out 10.00% Lane, Noah R CIV: Lane, Noah R CIV:
Please fill out
| (Note 1) | Labor Type | Labor Categories (Note 2) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2) | If Col e=S, Enter Name of Subcontractor(s) (Note 2) | Total Productive Hours | Hourly Base Pay Rate (Note 5) | Fringe (Note 6a) | Overhead (Note 6b) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 8) | Total Price Before Profit | Profit | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | h | i | j | k | l = i + j+ k | m = h x l | n | o = m + n | p | q = o + p | r = q/h | s = r/i |
| Government Site | ||||||||||||||||
| 1.00 |
tc={3E7050BE-4B87-4879-84E5-57F945016108}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Change as needed. Current values are to ensure formulas work properly. Please remove this comment in your quote.
Lane, Noah R CIV: Lane, Noah R CIV:
Please fill out Lane, Noah R CIV: Lane, Noah R CIV:
| Please fill out | $ 1.00 | $ 0.30 | $ 0.25 | $ 1.55 | $ 1.55 | $ 0.12 | $ 1.67 | $ 0.17 | $ 1.84 | $ 1.84 | 84.00% | ||||||
| 2.00 | $ 2.00 | $ 0.60 | $ 0.50 | $ 3.10 | $ 6.20 | $ 0.50 | $ 6.70 | $ 0.67 | $ 7.37 | $ 3.69 | 84.25% | ||||||
| 3.00 | $ 3.00 | $ 0.90 | $ 0.75 | $ 4.65 | $ 13.95 | $ 1.12 | $ 15.07 | $ 1.51 | $ 16.58 | $ 5.53 | 84.22% | ||||||
| 4.00 | $ 4.00 | $ 1.20 | $ 1.00 | $ 6.20 | $ 24.80 | $ 1.98 | $ 26.78 | $ 2.68 | $ 29.46 | $ 7.37 | 84.13% | ||||||
| 5.00 | $ 5.00 | $ 1.50 | $ 1.25 | $ 7.75 | $ 38.75 | $ 3.10 | $ 41.85 | $ 4.19 | $ 46.04 | $ 9.21 | 84.16% | ||||||
| 6.00 | $ 6.00 | $ 1.80 | $ 1.50 | $ 9.30 | $ 55.80 | $ 4.46 | $ 60.26 | $ 6.03 | $ 66.29 | $ 11.05 | 84.14% | ||||||
| 7.00 | $ 7.00 | $ 2.10 | $ 1.75 | $ 10.85 | $ 75.95 | $ 6.08 | $ 82.03 | $ 8.20 | $ 90.23 | $ 12.89 | 84.14% | ||||||
| 8.00 | $ 8.00 | $ 2.40 | $ 2.00 | $ 12.40 | $ 99.20 | $ 7.94 | $ 107.14 | $ 10.71 | $ 117.85 | $ 14.73 | 84.14% | ||||||
| 9.00 | $ 9.00 | $ 2.70 | $ 2.25 | $ 13.95 | $ 125.55 | $ 10.04 | $ 135.59 | $ 13.56 | $ 149.15 | $ 16.57 | 84.14% | ||||||
| 10.00 | $ 10.00 | $ 3.00 | $ 2.50 | $ 15.50 | $ 155.00 | $ 12.40 | $ 167.40 | $ 16.74 | $ 184.14 | $ 18.41 | 84.14% | ||||||
| 11.00 | $ 11.00 | $ 3.30 | $ 2.75 | $ 17.05 | $ 187.55 | $ 15.00 | $ 202.55 | $ 20.26 | $ 222.81 | $ 20.26 | 84.14% | ||||||
| 12.00 | $ 12.00 | $ 3.60 | $ 3.00 | $ 18.60 | $ 223.20 | $ 17.86 | $ 241.06 | $ 24.11 | $ 265.17 | $ 22.10 | 84.15% | ||||||
| 13.00 | $ 13.00 | $ 3.90 | $ 3.25 | $ 20.15 | $ 261.95 | $ 20.96 | $ 282.91 | $ 28.29 | $ 311.20 | $ 23.94 | 84.14% | ||||||
| 14.00 | $ 14.00 | $ 4.20 | $ 3.50 | $ 21.70 | $ 303.80 | $ 24.30 | $ 328.10 | $ 32.81 | $ 360.91 | $ 25.78 | 84.14% | ||||||
| 15.00 | $ 15.00 | $ 4.50 | $ 3.75 | $ 23.25 | $ 348.75 | $ 27.90 | $ 376.65 | $ 37.67 | $ 414.32 | $ 27.62 | 84.14% | ||||||
| Total: | 120 | $ 1,240.00 | $ 372.00 | $ 310.00 | $ 1,922.00 | $ 1,922.00 | $ 153.76 | $ 2,075.76 | $ 207.60 | $ 2,283.36 | $ 2,283.36 | ||||||
| Weighted Average: | 1 | $ 10.33 | $ 3.10 | $ 2.58 | $ 16.02 | $ 16.02 | $ 1.28 | $ 17.30 | $ 1.73 | $ 19.03 | $ 19.03 | 84.14% |
Change as needed. Current values are to ensure formulas work properly. Please remove this comment in your quote.
Materials
| In this section provide a list of materials with the associated cost. | |
| Material | Cost |
File details come from the government source that posted it. Updated .