Attachment 12 - Post Award Allocation Form IRA .xlsx

119 KB Posted

Attached to
Sioux Falls Courthouse Window Replacement
Solicitation number
47PJ0025R0028
Issued by

About this file

Written by GovTribe AI ·

This is a post-award allocation form template for an IRA (Inflation Reduction Act) project, specifically formatted for design-build performance contracts. The Excel spreadsheet includes sections for general project information, owner/contractor details, and a detailed cost breakdown using MasterFormat CSI divisions with special emphasis on low embodied carbon materials.

The form contains two main sections: a cost allocation worksheet and a bid tabulation form. The allocation worksheet breaks down costs across 48 divisions, with specific line items for sustainable elements like low embodied carbon concrete, steel, glass, and asphalt. The bid tabulation section shows sample pricing comparing an Independent Government Estimate against multiple contractors, though most fields are unpopulated. The sample data shows minor price variations between the IGE ($4,185.00) and Contractor B ($4,310.00) for the few populated line items, primarily in Divisions 00-08.

View the file

Other files

File Type Posted
The Solicitation- 47PJ0025R0028 AM0004.pdf PDF
SF-30 47PJ0025R0028_AM0004.pdf PDF
SF-30 47PJ0025R0028_AM0002.pdf PDF
RFI Responses Dated 02 14 2025 (AM0002).pdf PDF
47PJ0025R0028 Solicitation (AM0002).pdf PDF
47PJ0025R0028 Solicitation AM0001.pdf PDF
SF-30 47PJ0025R0028_AM0001 2025 01 23.pdf PDF
WD 20250028 01 03 2025.pdf PDF
47PJ0025R0028 CONSTRUCTION SET DRAWINGS SD.pdf PDF
47PJ0025R0028 CONSTRUCTION SET SPECIFICATIONS SD.pdf PDF
47PJ0025R0028 CONSTRUCTION SET SPECIFICATIONS.pdf PDF
Attachment 15 - 2014 Asbestos Inspection.pdf PDF
Attachment 13 -IRA Project Submittal Form and Data Dictionary.pdf PDF
Attachment 8 - P100 2024 Final.pdf PDF
Attachment 7 - GSA Base Lead Management Requirements.pdf PDF
Attachment 2 - Vendor Manual September 2023.pdf PDF
25R0028 IRA Sustainability Factor Table.xlsx XLSX spreadsheet
Attachment 11 - 23535 Sioux Falls Courthouse IRA Window Replacement Submittal_ Reporting Form.xlsx XLSX spreadsheet
Attachment 10 - Glass - GSA IRA Low Embodied Carbon Requirements.pdf PDF
Attachment 6 - GSA SD 3rd Party Abatement Clearance Requirements.pdf PDF
Attachment 5 - GSA Rapid City USMS Asbestos Abatement Requirements.pdf PDF
Attachment 4 - GSA Lead Pre-Alteration Assessment SOW.pdf PDF
Offeror Representations and Certifications.pdf PDF
Agreement 47PJ0025R0028.pdf PDF
47PJ0025R0028 Form 1442.pdf PDF
47PJ0025R0028 CONSTRUCTION SET DRAWINGS.pdf PDF
Attachment 14 - Fire Protection MOP and Firewatch Log Example.pdf PDF
Attachment 9 - Supplemental Pricing and Invoicing Instructions IRA.pdf PDF
Attachment 3 - GSA SD Asbestos Pre-alt Inspection SOW.pdf PDF
Attachment 1 - USR_v4 - 3-1-2024 - SF Window Replacement.pdf PDF
SOW - Sioux Falls Courthouse IRA Window Replacement_15 Jan 25.pdf PDF
25R0028 Bid Sheet .xlsx XLSX spreadsheet
Solicitation 47PJ0025R0028.pdf PDF
Show all 33

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

General Information

POST AWARD ALLOCATION FORM IRA

PROJECT NAME
BUILDING NAME
BUILDING ADDRESSBUILDING NUMBER
ESTIMATED
START DATEPERIOD OF PERFORMANCE DAYS
SOLICITATION #DELIVERY METHODDesign Build - Performance
OWNER INFORMATIONCONTRACTOR INFORMATION
OWNER
COMPANY NAMECONTRACTOR COMPANY NAME
OWNER
CONTACT NAMECONTRACTOR CONTACT NAME
ADDRESSADDRESS
OWNER
PHONECONTRACTOR PHONE
OWNER
EMAILCONTRACTOR EMAIL
SCOPE OF WORK
TEXT
MATERIALS AND SERVICES NOT INCLUDED
TEXT
ASSUMPTIONS
TEXT
NET ZERO CONTRIBUTIONS
TEXT

Masterformat CSI

PBS MASTERFORMAT CSI

Masterformat
CSISystem Elements (Trade Work)Self Performed/
Subcontracted?Amount
Div. 00Design Services - for Design Build
Div. 00AHigh Performing Green Buildings
Div. 00BEmerging and Sustainable Technologies
Div. 01General Requirements (Please Include Jobsite Overhead)
Div. 02Existing Conditions
Div. 03Concrete0
Div. 03ALow Embodied Carbon Concrete
Div 03.BNon LEC Concrete
Div. 04Masonry
Div. 05Metals0
Div. 05ALow Embodied Carbon Steel
Div 05.BNon LEC Metals
Div. 06Wood, Plastics, Composites
Div. 07Thermal and Moisture Protection
Div. 08Openings0
Div. 08ALow Embodied Carbon Glass
Div 05.BNon LEC Openings
Div. 09Finishes
Div. 10Specialties
Div. 11Equipment
Div. 12Furnishings
Div. 13Special Construction
Div. 14Conveying Equipment
Div. 21Fire Suppression
Div. 22Plumbing
Div. 23Heating, Ventilating, and Air Conditioning (HVAC)
Div. 26.1Electrical
Div. 26.2Lighting
Div. 27Communications
Div. 28.1Electronic Safety
Div. 28.2Electronic Security (TI - Non-BSAC)
Div. 31Earthwork
Div. 32Exterior Improvements0
Div. 32.ALEC Asphalt
Div. 32.BRest of Exterior Improvements
Div. 33Utilities
Div. 34Transportation
Div. 35Waterway and Marine Construction
Div. 40Process Integration
Div. 41Material Processing and Handling Equipment
Div. 42Process Heating, Cooling and Drying Equipment
Div. 43Process Gas and Liquid Handling, Purification and Storage Equipment
Div. 44Pollution and Waste Control Equipment
Div. 45Industry Specific Manufacturing Equipment
Div. 46Water and Wastewater Equipment
Div. 48Electrical Power Generation
SubtotalTrade Cost$0.00
General Conditions
Insurances (General Liability, Subcontractor Performance, Builders Risk Program)
Payment and Performance Bond
SubtotalEstimated Cost of Work$0.00
Overhead
Profit
Design Build Bid Price$0.00

Bid Tabulation

PBS BID TABULATION FORM
Company Name:Project No.:
Project Name:
Location:
Architect:Independent Government Estimate (IGE)CONTRATOR BCONTRACTOR CCONTRACTOR D
Bid Date:
BID QUANTITIESUNIT AMOUNTBIDUNIT AMOUNTBIDUNIT AMOUNTBIDUNIT AMOUNTBIDUNIT AMOUNTBID
Ref #Item DescriptionQty.UNIT
Div. 00Design Services - for Design Build500$500.00500$500.00$ -$ -$ -
Div. 01General Requirements (Please Include Jobsite Overhead)900$900.001000$1,000.00$ -$ -$ -
Div. 02Existing Conditions600$600.00600$600.00$ -$ -$ -
Div. 03Concrete210$210.00200$200.00$ -$ -$ -
Div. 03ALow Embodied Carbon Concrete200$200.00200$200.00$ -$ -$ -
Div 03.BNon LEC Concrete4.5$45.005$50.00$ -$ -$ -
Div. 04Masonry5$50.006$60.00$ -$ -$ -
Div. 05Metals6$60.005$50.00$ -$ -$ -
Div. 05ALow Embodied Carbon Steel1.4$280.001.5$300.00$ -$ -$ -
Div 05.BNon LEC Metals500$500.00500$500.00$ -$ -$ -
Div. 06Wood, Plastics, Composites1.25$250.001.25$250.00$ -$ -$ -
Div. 07Thermal and Moisture Protection590$590.00600$600.00$ -$ -$ -
Div. 08Openings$ -$ -$ -$ -$ -
Div. 05ALow Embodied Carbon Glass$ -$ -$ -$ -$ -
Div 05.BNon LEC Openings$ -$ -$ -$ -$ -
Div. 09Finishes$ -$ -$ -$ -$ -
Div. 10Specialties$ -$ -$ -$ -$ -
Div. 11Equipment$ -$ -$ -$ -$ -
Div. 12Furnishings$ -$ -$ -$ -$ -
Div. 13Special Construction$ -$ -$ -$ -$ -
Div. 14Conveying Equipment$ -$ -$ -$ -$ -
Div. 21Fire Suppression$ -$ -$ -$ -$ -
Div. 22Plumbing$ -$ -$ -$ -$ -
Div. 23Heating, Ventilating, and Air Conditioning (HVAC)$ -$ -$ -$ -$ -
Div. 26.1Electrical$ -$ -$ -$ -$ -
Div. 26.2Lighting$ -$ -$ -$ -$ -
Div. 27Communications$ -$ -$ -$ -$ -
Div. 28.1Electronic Safety$ -$ -$ -$ -$ -
Div. 28.2Electronic Security (TI - Non-BSAC)$ -$ -$ -$ -$ -
Div. 31Earthwork$ -$ -$ -$ -$ -
Div. 32Exterior Improvements$ -$ -$ -$ -$ -
Div. 32.ALEC Asphalt$ -$ -$ -$ -$ -
Div. 32.BRest of Exterior Improvements$ -$ -$ -$ -$ -
Div. 33Utilities$ -$ -$ -$ -$ -
Div. 34Transportation$ -$ -$ -$ -$ -
Div. 35Waterway and Marine Construction$ -$ -$ -$ -$ -
Div. 40Process Integration$ -$ -$ -$ -$ -
Div. 41Material Processing and Handling Equipment$ -$ -
Div. 42Process Heating, Cooling and Drying Equipment$ -$ -$ -$ -$ -
Div. 43Process Gas and Liquid Handling, Purification and Storage Equipment$ -$ -
Div. 44Pollution and Waste Control Equipment$ -$ -
Div. 45Industry Specific Manufacturing Equipment$ -$ -
Div. 46Water and Wastewater Equipment$ -$ -
Div. 48Electrical Power Generation$ -$ -
$4,185.00$4,310.00
$426.69$426.69
$4,611.69$4,736.69

image1.png

File details come from the government source that posted it. Updated .