Excel Price Offer Sheet.xlsx
XLSX spreadsheet 106 KB Posted
- Solicitation number
- 47PH5226R0003
- Issued by
- Not on record
About this file
This is an Excel price offer sheet for a General Contractor bidding on a GSA Multiple Award Indefinite Delivery Indefinite Quantity (IDIQ) contract for construction services in the D.C. Metro Area (Solicitation Number 47PH5226R0003). The bid sheet template is designed for offerors to submit pricing for general construction, repair, alteration, and modernization services at federally owned and leased locations.
The pricing structure establishes a total direct cost of $1,288,151.95, comprised of $193,222.78 in general conditions and $1,094,929.17 in cost of work. Offerors must provide fully-loaded hourly rates for eight supervision labor categories: Project Manager, Superintendent, Project Engineer, Scheduler, Quality Control Manager, Field Engineer, Safety Manager/Officer, and Cost Estimator. The sheet requires input of home office overhead and profit percentages, bonds and insurance costs, and an annual escalation rate applicable to option periods. All markup rates established at contract award become the maximum allowable rates for future task order modifications, with specific constraints including a 10 percent combined ceiling on overhead and profit for tier 1 and 2 subcontractors at 50 percent of the prime contractor's negotiated rates. The template automatically calculates the total evaluated price across the base year and four option years, with escalation applied to labor categories for each exercised option period.
View the file
Other files
Show all 18
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
Bid Sheet
| CONTRACTOR BID SHEET | Allowable Task Order Modification Markup | ||
| General Conditions | $193,222.78 | Provided | IAW GSAR 552.243-71(h)(6) Overhead and profit shall be allowed on the direct costs of work performed by a subcontractor within two tiers of a firm at rates equal to only fifty percent of the overhead and profit rates negotiated pursuant to paragraphs (h)(1) and 552.243-71 Equitable Adjustments for that firm, but not in excess of ten percent when combined. The Maximum Task Order Modification Markup on Direct Costs of tier 1 & 2 subcontractors will be included as part of the IDIQ Contract, and will be the maximum Markup an awardee may apply to tier 1 and 2 subcontractor direct costs as part of any future modifications against Task Orders. |
| Cost of Work | $1,094,929.17 | Provided |
Total Direct Cost $1,288,151.95 Provided
| Home Office Overhead | 0.000% | $0.00 | Fill in Cell B7 | |||
| Profit | 0.000% | $0.00 | Fill in Cell B8 | Overhead | 0.000% | Auto Calc |
| Profit | 0.000% | Auto Calc | ||||
| Sub Total | $1,288,151.95 | Auto Calc | Total | 0.000% | Auto Calc | |
| 50% of Rates | 0.000% | Auto Calc | ||||
| Bonds and Insurance | 0.000% | $0.00 | Fill in Cell B12 | Maximum Task Order Modification Sub Markup | 0.000% | Auto Calc |
| Task Order Price | $1,288,151.95 | Auto Calc | ||||||||||
| Supervision Labor Categories | Hours | Base Year Rates | Extended Rate | OPT Year 1 Rate | OPT Year 1 Ext | OPT Year 2 Rate | OPT Year 2 Ext | OPT Year 3 Rate | OPT Year 3 Ext | OPT Year 4 Rate | OPT Year 4 Ext | |
| Project Manager | 520.00 | $0.00 | $0.00 | Fill in Cell C16 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Superintendent | 520.00 | $0.00 | $0.00 | Fill in Cell C17 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Project Engineer | 260.00 | $0.00 | $0.00 | Fill in Cell C18 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Scheduler | 260.00 | $0.00 | $0.00 | Fill in Cell C19 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Quality Control Manager | 260.00 | $0.00 | $0.00 | Fill in Cell C20 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Field Engineer | 260.00 | $0.00 | $0.00 | Fill in Cell C21 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Safety Manager/Officer | 260.00 | $0.00 | $0.00 | Fill in Cell C22 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Cost Estimator | 260.00 | $0.00 | $0.00 | Fill in Cell C23 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Salaries Price | $0.00 | Auto Calc | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total Annual Escalation Rate 0.00% $0.00 Fill in B27 Extended Escalation $ - 0 $ - 0 $ - 0 $ - 0
Total Evaluated Price $1,288,151.95 Auto Calc
Rate DefinitionsInstructions
| CONTRACT MARKUPS | ||||
| Description | Cell | Definition | Rate Instructions | Computation |
| Home Office Overhead | B7 | Costs that are incurred to support the work, but are not directly chargeable to a specific project. Ie, Home Office; Rent, support staff, office equipment and supplies, utilities, marketing, etc | Provide a % that represents all indirect costs that are not direclty charged to a project. This percent will be the maximum overhead that may be applied to all future task orders for the duration of the contract including all options | Proposed Rate (B7) multiplyed by the Total Direct Cost (C5) |
| Profit | B8 | Financial gain that is the positive margin between revenue minus expeses (indirect and direct) | Provide a % that represents the profit margin. This percent will be the maximum profit that may be applied to all future task orders for the duration of the contract including all options | Proposed Rate (B8) multiplyed by the Total Direct Cost (C5) + Extended OH Cost (C7) |
| Bonds and Insurance | B12 | Cost for performance and payment bonds as required by FAR 28.102 and Insurance Requirement defined in FAR 52.228-5 and the solicitation. | Provide a % that represents the cost for all bonds and insruance. This percent will be the maximum bonds and insurance mark-up that may be applied to all future task orders for the duration of the contract including all options. Offeror should assume Performance and Payment bonds are required | Proposed Rate (B12) multiplyed by the Subtotal (C10) |
| Annual Escalation Rate | B27 | Percent increase (inflation) that will be applied to all labor category hourly rates for each exercised option period. | Provide a % that represents the escalation rate for all labor categories. This percent will be escalation rate that will be utilized to increase each labor categorey for each option period that the government elects to exercise. | Sum of all option periods extended escalation increase (H27+J27+L27+N27) |
| SUPERVISION LABOR CATEGORIES | ||||
| Description | Cell | Definition | Rate Instructions | Computation |
| Project Manager | C16 | Typically responsible for the safe completion of the project within budget, on schedule, to the Company’s quality standards and to the customer’s satisfaction. It will be the responsibility of this individual to initiate required action to achieve the project objectives and to ensure all project activities are consistent with contract documents and the Company’s policies. | Provide a FFP hourly rate that includes all direct and indirect costs. This rate will be the maximum price that may be charged against all future task orders. Typically this rate will be utilized when negotiating modifications that effect general conditions/time extensions. GC's will typically be Lump Sum at time of award but the government may utlize this rate to negotiate GC's with offerors if it is in its best interest. Modification Markups shall not be applied to this rate on change orders/modifications to task orders. | Proposed Hourly Rate (C16) multiplied by Hours (B16) |
| Superintendent | C17 | Typically has the responsibility and authority for daily coordination and direction of the project. The Project Superintendent will generally concentrate on long-range planning, problem solving, and logistics. | Provide a FFP hourly rate that includes all direct and indirect costs. This rate will be the maximum price that may be charged against all future task orders. Typically this rate will be utilized when negotiating modifications that effect general conditions/time extensions. GC's will typically be Lump Sum at time of award but the government may utlize this rate to negotiate GC's with offerors if it is in its best interest. Modification Markups shall not be applied to this rate on change orders/modifications to task orders. | Proposed Hourly Rate (C17) multiplied by Hours (B17) |
| Project Engineer | C18 | Typicall work directly with the Project Engineer or Project Manager with the primary objective of supporting the field through effective materials management. Primary responsibilities include processing of submittals and shop drawings and tracking/expediting material deliveries. | Provide a FFP hourly rate that includes all direct and indirect costs. This rate will be the maximum price that may be charged against all future task orders. Typically this rate will be utilized when negotiating modifications that effect general conditions/time extensions. GC's will typically be Lump Sum at time of award but the government may utlize this rate to negotiate GC's with offerors if it is in its best interest. Modification Markups shall not be applied to this rate on change orders/modifications to task orders. | Proposed Hourly Rate (C18) multiplied by Hours (B18) |
| Scheduler | C19 | Typically responsible for the development, maintenance, updating, and reporting of the project construction schedule. The Project Scheduler will facilitate schedule communication between all internal stakeholders on the project as well as be the liaison to the Owner’s scheduler. | Provide a FFP hourly rate that includes all direct and indirect costs. This rate will be the maximum price that may be charged against all future task orders. Typically this rate will be utilized when negotiating modifications that effect general conditions/time extensions. GC's will typically be Lump Sum at time of award but the government may utlize this rate to negotiate GC's with offerors if it is in its best interest. Modification Markups shall not be applied to this rate on change orders/modifications to task orders. | Proposed Hourly Rate (C19) multiplied by Hours (B19) |
| Quality Control Manager | C20 | Typically responsible for establishing and maintaining the QC program on whichever project(s) he/she may be assigned. | Provide a FFP hourly rate that includes all direct and indirect costs. This rate will be the maximum price that may be charged against all future task orders. Typically this rate will be utilized when negotiating modifications that effect general conditions/time extensions. GC's will typically be Lump Sum at time of award but the government may utlize this rate to negotiate GC's with offerors if it is in its best interest. Modification Markups shall not be applied to this rate on change orders/modifications to task orders. | Proposed Hourly Rate (C20) multiplied by Hours (B20) |
| Field Engineer | C21 | Typically aid the Superintendent in field management. Typically Field Engineers are responsible for the majority of the layout on the project as well as lift drawings, safety, and quality control responsibilities. | Provide a FFP hourly rate that includes all direct and indirect costs. This rate will be the maximum price that may be charged against all future task orders. Typically this rate will be utilized when negotiating modifications that effect general conditions/time extensions. GC's will typically be Lump Sum at time of award but the government may utlize this rate to negotiate GC's with offerors if it is in its best interest. Modification Markups shall not be applied to this rate on change orders/modifications to task orders. | Proposed Hourly Rate (C21) multiplied by Hours (B21) |
| Safety Manager/Officer | C22 | Typicaly assist the project team in planning, monitoring work activities and gaining correction of unsafe acts or conditions. | Provide a FFP hourly rate that includes all direct and indirect costs. This rate will be the maximum price that may be charged against all future task orders. Typically this rate will be utilized when negotiating modifications that effect general conditions/time extensions. GC's will typically be Lump Sum at time of award but the government may utlize this rate to negotiate GC's with offerors if it is in its best interest. Modification Markups shall not be applied to this rate on change orders/modifications to task orders. | Proposed Hourly Rate (C22) multiplied by Hours (B22) |
| Cost Estimator | C23 | Typically responsible for reviewing the project documents and helping to develop cost estimates for task orders. They will help to manage the development of subcontractor costs and estimates as well as the estimates for all self-performed work, | Provide a FFP hourly rate that includes all direct and indirect costs. This rate will be the maximum price that may be charged against all future task orders. Typically this rate will be utilized when negotiating modifications that effect general conditions/time extensions. GC's will typically be Lump Sum at time of award but the government may utlize this rate to negotiate GC's with offerors if it is in its best interest. Modification Markups shall not be applied to this rate on change orders/modifications to task orders. | Proposed Hourly Rate (C23) multiplied by Hours (B23) |
Offer Sheet Definitions
| Contract Definitions | |
| Term | Definition |
| Genral Conditions/General Requirements | Direct costs for the oversight and supervision of the project. Typical costs include but are not limited to management, supervision, , engineering, quality control, safety, surveying, vehicles, equipment, temporary facilities, cleanup, hoistways, chutes, dumpsters, etc |
| Cost of Work | Sum of General Conditions/General Requirements, Self Performed work, Subcontracted work, and all other costs directly allocated to complete the construction of the project |
| Direct Costs | Any cost that are directly allocated to construct the project including but not limited to labor, materials, equipment, tools, utilities, supervision, temporary onsite facilities/offices, cleanup, vehicles, etc |
File details come from the government source that posted it. Updated .