Attachment 7 - B.2 Price Cost Schedule.xlsx
XLSX spreadsheet 23 KB Posted
- Solicitation number
- 36C24825Q1212-0003
About this file
This is a pricing template that serves as Attachment 7 (B.2 Price Cost Schedule) for the solicitation titled "Bid-Build (BB) Install Alternate Connections for Steam and Chilled Water at Lake Nona," issued by the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 8 under solicitation number 36C24825Q1212-0003.
The template is a cost breakdown spreadsheet designed for offerors to submit their base offer pricing organized by the 16 CSI Divisions (General Requirements, Concrete, Masonry, Metals, Wood and Plastic, Thermal & Moisture Protection, Doors and Windows, Finishes, Specialties, Equipment, Furnishings, Special Construction, Conveying Equipment, Fire Suppression, Plumbing, HVAC, Electrical, Communications, Electronic Safety & Security, Earthwork, Exterior Improvements, Utilities, and Transportation). For each division, offerors must separately enter labor costs and material costs, with the template automatically calculating total division costs. The template then applies overhead percentage, profit percentage, and bond percentage calculations to the subtotals to arrive at the final Total Base Offer Cost. Instructions embedded throughout the spreadsheet direct offerors to avoid lump sum pricing and provide detailed price breakdowns for government price analysis purposes. All cost fields are currently unpopulated with zero values as this is a blank template awaiting offeror input.
View the file
Other files
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
Base Offer Base Offer Cost Breakdown
Project Number:
Edward L Roy: VA assigned project #
| Date: | |
| Project Title |
| Edward L Roy: VA assigned Project Title | Project Location | ||
| Offeror Name | |||
| Offeror Street | |||
| Offeror City | State | Zip |
Item Description Labor Cost Edward L Roy: Enter all Labor Costs by Division
| Material Cost | |
| Edward L Roy: Enter all Material Costs by Division | Total Cost |
Edward L Roy: This Column is the sum of the Division's Labor and Material Costs
| Division 1 | General Requirements | $ - 0 | $ - 0 | $ - 0 |
| Division 2 | Existing Conditions | - 0 | - 0 | - 0 |
| Division 3 | Concrete | - 0 | - 0 | - 0 |
| Division 4 | Masonry | - 0 | - 0 | - 0 |
| Division 5 | Metals | - 0 | - 0 | - 0 |
| Division 6 | Wood and Plastic | - 0 | - 0 | - 0 |
| Division 7 | Thermal & Moisture Protect | - 0 | - 0 | - 0 |
| Division 8 | Doors and Windows | - 0 | - 0 | - 0 |
| Division 9 | Finishes | - 0 | - 0 | - 0 |
| Division 10 | Specialties | - 0 | - 0 | - 0 |
| Division 11 | Equipment | - 0 | - 0 | - 0 |
| Division 12 | Furnishings | - 0 | - 0 | - 0 |
| Division 13 | Special Construction | - 0 | - 0 | - 0 |
| Division 14 | Conveying Equipment | - 0 | - 0 | - 0 |
| Division 21 | Fire Suppression | - 0 | - 0 | - 0 |
| Division 22 | Plumbing | - 0 | - 0 | - 0 |
| Division 23 | HVAC | - 0 | - 0 | - 0 |
| Division 26 | Electrical | - 0 | - 0 | - 0 |
| Division 27 | Communications | - 0 | - 0 | - 0 |
| Division 28 | Electronic Safety & Security | - 0 | - 0 | - 0 |
| Division 31 | Earthwork | - 0 | - 0 | - 0 |
| Division 32 | Exterior Improvements | - 0 | - 0 | - 0 |
| Division 33 | Utilities | - 0 | - 0 | - 0 |
| Division 34 | Transportation Subtotal | - 0 | - 0 | - 0 |
| Division Subtotals : | $ - 0 | $ - 0 | $ - 0 |
Overhead % 0.00% Edward L Roy: Enter Overhead % here. This % will be multiplied by the Division Total Cost Subtotal (cell F36).
Edward L Roy: Date Offer Prepared/Submitted
| - 0 | |||
| Profit % | 0.00% | ||
| Edward L Roy: Enter Profit % here.This % will be multiplied by the sum of the Division Total Cost subtotal (cell F36) plus the calculated Overhead (cell F38). | - 0 | ||
| Bond % | 0.00% |
Edward L Roy: Enter Bond % here. This % will be multiplied by the sum of the Division Total Cost Subtotal (cell F36), the amount of calculated Overhead (cell F38) and the amount of calculated Profit (cell F39).
Edward L Roy: Enter all Labor Costs by Division
| - 0 | ||
| Overhead/Profit Subtotals : | $ - 0 |
Edward L Roy: Sum of Overhead, Profit and Bond %.
Edward L Roy: Enter all Material Costs by Division Edward L Roy: This Column is the sum of the Division's Labor and Material Costs Total Base Offer Cost $ - 0 $ - 0 $ - 0
Offerors shall provide additional price breakdown to avoiding lump sum, etc. This price offer breakdown is the overall base offer price for Government price analysis
File details come from the government source that posted it. Updated .