Attachment 3 - Construction Cost Proposal Form 47PE0224R0012 - Savannah Customs House - Roof restoration.xlsx
XLSX spreadsheet 98 KB Posted
- Attached to
- Savannah Customs House - Roof restoration
- Solicitation number
- 47PE0224R0012
About this file
This solicitation is for roof restoration services at the U.S. Custom House in Savannah, Georgia. The General Services Administration seeks a design-build contractor to perform roof drainage improvements including chimney saddles, re-coating of the corrugated metal roof with an aluminum coating, improvements to roof penthouses, and limited interior plaster repairs. The 29,403 square foot historic landmark building constructed in 1852 requires upgrades to its original metal roof and repairs to waterproof the structure. Interested offerors should attend a mandatory site visit on March 6, 2024 at 9:00 am to inspect the building located at 1-3 East Bay Street in Savannah, Georgia prior to submitting a proposal in response to solicitation number 47PE0224R0012 by the anticipated award date.
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
Calc
| Non-Recurring RWA's - Overhead Rates | |
| Rev: | 9/5/96 |
| Worksheet protection enabled (no password) |
| ENTER RWA BASE ESTIMATE | ERROR:#REF! |
| TOTAL OVERHEAD | ERROR:#REF! |
| TOTAL RWA COST | ERROR:#REF! |
| Data & Calculation Table - Make NO Changes | ||||
| RATE | RANGE | SUBTOTAL | MAX/RNG | |
| 0.1 | 0 | 2499 | ERROR:#REF! | 250 |
| 0.09 | 2500 | 9999 | ERROR:#REF! | 675 |
| 0.08 | 10000 | 24999 | ERROR:#REF! | 1200 |
| 0.07 | 25000 | 49999 | ERROR:#REF! | 1750 |
| 0.05 | 50000 | 99999 | ERROR:#REF! | 2500 |
| 0.03 | 100000 | 299999 | ERROR:#REF! | 6000 |
| 0.015 | 300000 | 999999 | ERROR:#REF! | 10500 |
| 0.005 | 1000000 | 2425000 | ERROR:#REF! | 7125 |
Worksheet RWA Overhead Worksheet
| Instructions: |
| 1. Type in the estimated amount of the RWA w/o overhead in column 1. |
| The spreadsheet will automatically calculate the overhead amount in column 2 |
| and the total amount of the RWA in column 3. |
| Total Amount | ||
| Amount of RWA | Amount of | Of RWA |
| w/o Overhead | Overhead | including Overhead |
RWA's between $1 and $2,499
$ 1,234.00 $ 123.40 $ 1,357.40
RWA's between $2,500 and $9,999
$ 9,999.00 $ 925 $ 10,923.91
RWA's between $10,000 and $24,999
$ 24,999.00 $ 2,125 $ 27,123.92
RWA's between $25,000 and $49,999
$ 49,999.00 $ 3,875 $ 53,873.93
RWA's between $50,000 and $99,999
$ 50,000.00 $ 3,875 $ 53,875.00
RWA's between $100,000 and $299,999
$ 299,999.00 $ 12,375 $ 312,373.97
RWA's between $300,000 and $999,999
$ 345,678.00 $ 13,060 $ 358,738.17
RWA's between $1,000,000 but less than or equal to $2,425,000
$ 1,234,567.00 $ 24,048 1/ $ 1,258,614.84
RWA's over $2,425,000 $ 30,000 1/
1/ PBS policy caps the overhead charged to an RWA at $30,000.
Rates Non-Recurring RWA's - Overhead Rates
Line RWA Range Overhead Rate for each RWA Range
| 1 | $1 to 2,499 | 10.00% | |||||||
| 2 | $2,500 to 9,999 | 9.00% | |||||||
| 3 | $10,000 to 24,999 | 8.00% | |||||||
| 4 | $25,000 to 49,999 | 7.00% | |||||||
| 5 | $50,000 to 99,999 | 5.00% | |||||||
| 6 | $100,000 to 299,999 | 3.00% | |||||||
| 7 | $300,000 to 999,999 | 1.50% | |||||||
| 8 | $1,000,000+ | 0.50% |
| The overhead to be added to an RWA falling within the range in: |
| Line 1 equals 10% of the RWA Amount. |
| Line 2 equals 10% of the maximum range in Line 1 plus 9% of the amount over $2,499. |
| Line 3 equals 10% of the maximum range in Line 1 + 9% of the difference between the maximum ranges in lines 2 and 1 |
| plus 8% of the amount over $9,999. |
| Line 4 through Line 8 - See attached spreadsheet with computation formulas. |
Sheet1
| Cost Proposal (Break Down) | ||||||
| Location: U.S. Custom House, (GA0076ZZ) 1–3 E Bay St, Savannah, GA 31401 | Date | |||||
| Solicitation # 47PE0224R0012 | Prepared by | |||||
| RSMeans Book Edition/Version | ||||||
| Description of Work: Savannah Customs House - Roof restoration | ||||||
| Task Breakdown | ||||||
| Item # | RSMeans Line Number | RSMeans | ||||
| Task Description | RSMeans Unit | Quantity | RSMeans “Total Incl O&P” Unit Cost | Total Costs (including O&P) | ||
| 1 | $0.00 | |||||
| 2 | $0.00 | |||||
| 3 | $0.00 | |||||
| 4 | $0.00 | |||||
| 5 | $0.00 | |||||
| 6 | $0.00 | |||||
| 7 | $0.00 | |||||
| 8 | $0.00 | |||||
| 9 | $0.00 | |||||
| 10 | $0.00 | |||||
| 11 | $0.00 | |||||
| 12 | $0.00 | |||||
| 13 | $0.00 | |||||
| 14 | $0.00 | |||||
| 15 | $0.00 | |||||
| 16 | $0.00 | |||||
| 17 | $0.00 | |||||
| 18 | $0.00 | |||||
| 19 | $0.00 | |||||
| 20 | $0.00 | |||||
| Subtotal | $0.00 | |||||
| Standard Coefficient (from the contract) | ||||||
| Total Job Order Price | $0.00 |
File details come from the government source that posted it. Updated .