Attachment 4 - Blank IGE.xlsx
XLSX spreadsheet 88 KB Posted
- Attached to
- Replace Chapel Windows B912
- Solicitation number
- FA480326Q0040
About this file
This is a blank Independent Government Estimate (IGE) template for a construction project to repair and replace windows in Chapel Building B912 at Shaw Air Force Base, South Carolina, under solicitation FA480326Q0040. The template is structured as an Excel worksheet with line items for various construction tasks including window demolition, frame removal, standard and curtain wall window installation, stained glass window installation, flashing installation, masonry repointing, wall repair and painting, dumpster rental, lift rental, and supervision costs. Each line item requires inputs for quantity, unit of measure, material costs, labor costs, and direct costs, with automatic calculation of line totals and project subtotals including overhead, profit, and bonding percentages.
The solicitation is a 100% Small Business Concern set-aside under NAICS code 236220 (construction of buildings and structures) with a mandatory site visit scheduled for Wednesday, April 15, 2026, at 10:00 A.M. EST at Building 912, 433 Shaw Drive, Shaw AFB, South Carolina 29152. Base access requests must be submitted by Tuesday, April 7, 2026, at 10:00 P.M. EST. Questions are due by Monday, April 20, 2026, at 10:00 A.M. EST, with answers provided by Friday, April 24, 2026. Quotes utilizing this blank IGE template are due by Friday, May 8, 2026, at 10:00 A.M. EST, submitted to SSgt Motaz Irshid or Ms. Sarah Nieves. The period of performance is 60 calendar days after receipt of Notice to Proceed. An example completed IGE is provided showing a total contract price of $504,000.72 including material costs ($314,858.15), labor costs ($71,278.47), 12% overhead, 12% profit, and 2.5% bonding.
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
Sheet1 (NEW)
| CUI | ||||||||
| Project: | Repair Windows Chapel B912 | James Sawyer | ||||||
| Location: | Shaw AFB | 20 CES | ||||||
| Contractor: | ||||||||
| Address: | ||||||||
| PR No.: | VLSB 25-0023 | |||||||
| CUI | ||||||||
| Reference | Line No. | Item | Unit of Measure | Quantity | Material Costs | Labor Costs | Direct Cost | Line Total |
| VLSB 24-0062 | 1 | Demo Standard Window | SF | ||||
| VLSB 24-0077 | 2 | Demo Frame of Stained Glass Windows | SF | ||||
| VLSB 24-0062 | 3 | Replace Standard Window | SF | ||||
| VLSB 24-0077 | 4 | Install Curtain Wall and Stained Glass | SF | ||||
| VLSB 24-0062 | 5 | Install flashing | Ea | ||||
| RSMeans 040120200320 | 6 | Repoint Masonry | SF | ||||
| RSMeans 099123721240 | 7 | Repair / Paint Wall | SF | ||||
| RSMeans 024119190725 | 8 | Dumpster Rental | Wk | ||||
| United Rentals Website | 9 | Lift Rental | Mo | ||||
| SUPERVISION | |||||||
| 22-0063 plus 20% | 10 | Project Manager | days | ||||
| 22-0063 plus 20% | 11 | Project Superintendant | days | ||||
| Totals: | $0.00 | $0.00 | $0.00 | $0.00 |
| Material Cost: | $0.00 |
| Labor Cost: | $0.00 |
| Direct Cost: | $0.00 |
| Total Line Item Cost: | $0.00 |
| Overhead: | % | |
| Subtotal: | $0.00 |
| Profit: | % |
| Subtotal: |
| Bond: | % |
| Total Contract Price: |
Sheet1
| FOR OFFICE USE ONLY | |||||||||||||
| Project: | Repair Windows B216 | Project Engineer: | James Sawyer | ||||||||||
| Location: | Shaw AFB | Department: | 20 CES | ||||||||||
| Contractor: | 22-Jul-24 | ||||||||||||
| Address: | |||||||||||||
| PR No.: | VLSB 24-0026 | ||||||||||||
| For Official Use Only | |||||||||||||
| Reference | Line No. | Item | Unit of Measure | Quantity | Material Costs | Labor Costs | Direct Cost | Line Total | |||||
| Unit Cost (Means) | Total | Labor Hours per Unit (Means) | Labor Cost per Unit (Means) | Labor-Hours | Avg. Rate ($/hr) | Total |
| RSMeans 028213438260 | 1 | Abate Window Caulk | SF | 81 | $25.65 | $2,077.65 | 0.027 | $95.85 | 2.2 | $3,550.00 | $7,763.85 | $9,841.50 | |
| RSMeans 028213473000 | 2 | Asbestos Handling & Disposal | Ea | 10 | $25.65 | $256.50 | 0.4 | $12.90 | 4.0 | $32.25 | $129.00 | $1,350.00 | $1,735.50 |
| 22-0063 plus 20% | 3 | Demo and Replace Windows | Ea | 26 | $11,455.00 | $297,830.00 | 13 | $755.00 | 338.0 | $58.08 | $19,630.00 | $4,000.00 | $321,460.00 |
| Frame up Window RSMeans 05411305140 | 4 | Remove Window, Frame and Install Standing Seam Metal Panels | Ea | 1 | $880.00 | $880.00 | 12 | $600.00 | 12.0 | $50.00 | $600.00 | $500.00 | $1,980.00 |
| RSMeans 076210100100 | 5 | Cover Window with Flashing | Ea | 1 | $630.00 | $630.00 | 0.044 | $1.62 | 0.0 | $36.82 | $1.62 | $631.62 | |
| RSMeans 099123721240 | 6 | Repair / Paint Wall | SF | 2600 | $0.64 | $1,664.00 | 0.012 | $0.43 | 31.2 | $35.83 | $1,118.00 | $2,782.00 | |
| RSMeans 024119190725 | 7 | Dumpster Rental | Wk | 8 | $565.00 | $4,520.00 | $4,520.00 | ||||||
| United Rentals Website | 8 | Lift Rental | Mo | 2 | $3,500.00 | $7,000.00 | $7,000.00 | ||||||
| SUPERVISION | |||||||||||||
| 22-0063 plus 20% | 9 | Project Manager | days | 30 | $0.00 | 8 | $440.00 | 240.0 | $55.00 | $13,200.00 | $13,200.00 | ||
| 22-0063 plus 20% | 10 | Project Superintendant | days | 90 | $0.00 | 8 | $320.40 | 720.0 | $40.05 | $28,836.00 | $28,836.00 | ||
| Totals: | $314,858.15 | $71,278.47 | $5,850.00 | $391,986.62 |
| Total Material Cost: | $314,858.15 |
| Total Labor Cost: | $71,278.47 |
| Direct Cost: | $5,850.00 |
| Total Line Item Cost: | $391,986.62 |
| Overhead: | 12% | $47,038.39 |
| Subtotal: | $439,025.01 |
| Profit: | 12% | $52,683.00 |
| Subtotal: | $491,708.02 |
| Bond: | 2.50% | $12,292.70 |
| Total Contract Price: | $504,000.72 |
Sheet2
Sheet3
File details come from the government source that posted it. Updated .