11. Bid_Price_Summary_and_Backup_Information_Template_4-27-17.xlsx
XLSX spreadsheet 100 KB Posted
- Attached to
- Building 10 E-Wing Renovation, Bethesda, MD Federal contract opportunity
- Solicitation number
- NIHOF2017154
About this file
Attachment 11 - Bid Price Summary and Backup Information Template
View the file
Other files for this federal contract opportunity
Show all 25
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
INSTRUCTIONS
| SECTION B - BID PRICING SHEETS INSTRUCTIONS: | |
| CSI DIVISION WORKSHEETS: | |
| 1 | CSI DIVISION WORKSHEETS ARE LINKED TO THE SUMMARY PAGE. |
| 2 | *USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS |
| 3 | CREATE A CSI DIVISION WORKSHEET FOR EACH DIVISION OF WORK REQUIRED TO COMPLETE THE PROJECT |
| 4 | ENTER DIVISION NUMBER IN YELLOW CELL (A8); ENTER DIVISION DESCRIPTION IN YELLOW CELL (B8). THIS INFORMATION WILL POPULATE THE SUMMARY PAGE DIVISION NUMBERS AND ITEM DESCRIPTIONS. |
| 5 | LIST EACH WORK ITEM TO BE PERFORMED BY THE PRIME AND ITS ASSOCIATED MATERIAL AND LABOR COSTS. (ADD ADDITIONAL ROWS AS NECESSARY). |
| 6 | IDENTIFY EACH SUBCONTRACTOR, ENTERING SUBCONTRACTOR'S TOTAL MATERIAL AND LABOR COSTS. |
BACKUP SHALL BE PROVIDED FOR EACH SUBCONTRACTOR. (PRIME CONTRACTOR MAY ELECT TO MODIFY THIS SPREADHSHEET TO PROIVDE SUBCONTRACTOR BACK-UP DETAIL SIMILAR TO PRIME CONTRACTOR'S DETAIL.)
| 7 | INSERT A PERCENTAGE (i.e. 5 FOR 5%) FOR OVERHEAD APPLIED TO SUBCONTRACTOR(S) |
| 8 | INSERT A PERCENTAGE (i.e. 5 FOR 5%) FOR PROFIT APPLIED TO SUBCONTRACTOR(S) |
| 9 | A TOTAL DIVISION COST WILL CALCULATE AS COST DATA IS ENTERED FOR PRIME COSTS, SUBCONTRACTOR(S) COSTS AND PERCENTAGE VAULES. |
| SUMMARY PAGE:. | |
| 10 | THE SUMMARY PAGE WORK ITEMS ARE LINKED TO THE CORRESPONDING INDIVIDUAL CSI DIVISION WORKSHEETS. |
FOR CONVENIENCE, THREE SAMPLE CSI DIVISION WORKSHEETS HAVE BEEN PROVIDED AND LINKED TO THE SUMMARY PAGE. THE OFFEROR SHALL ADD A NEW LINE ITEM TO THE SUMMARY PAGE FOR EACH ADDITIONAL CSI DIVISION WORKSHEET CREATED.
11 cGMP NTE ALLOWANCE - WORK INCLUDED IN THE cGMP ALLOWANCE AS DESCRIBED IN THE CONSTRUCTION DOCUMENTS
THE cGMP LAB REQUIREMENTS WILL BE ISSUED AFTER CONTRACT AWARD.
AN ALLOWANCE IS INCLUDED ON THE BID SHEETS SUMMARY PAGE FOR THE OFFEROR'S USE FOR PRICING PURPOSES. DO NOT CHANGE THIS ALLOWANCE VALUE.
THE AMOUNT OF THIS ALLOWANCE IS NOT THE FINAL PRICE FOR THIS WORK. THE FINAL PRICE WILL BE BASED ON THE SUCCESSFUL CONTRACTOR’S SUPPLEMENTAL COST PROPOSAL AND NEGOTIATED FINAL PRICE TO INCORPORATE THE WORK OF THE cGMP STAND-ALONE DESIGN PACKAGE INTO THE FULL PROJECT.
| 12 | INSERT A PERCENTAGE (i.e. 10 FOR 10%) FOR OVERHEAD APPLIED TO PRIME WORK |
| 13 | INSERT A PERCENTAGE (i.e. 10 FOR 10%) FOR PROFIT APPLIED TO PRIME WORK |
| 14 | INSERT PRICE OF PREFORMANCE / PAYMENT BOND |
| 15 | A TOTAL CONTRACT PRICE WILL CALCUALTE AS COST DATA IS POPULATED FROM LINKED CSI DIVISION WORKSHEETS. |
| MATERIAL UNIT PRICING WORKSHEET | |
| 16 | IN SPECIFICATION SECTION 01 21 00, SUBSECTION 3.3 THE A/E HAS PROVIDED ESTIMATED QUANTITIES FOR UNIT PRICING. THE OFFEROR SHALL PROVIDE A UNIT PRICE AND TOTAL PRICE BASED ON THESE QUANTITIES AND PRICE PER UNIT. THE PER UNIT PRICING WILL ALLOW FOR CALCULATION OF FAIR AND REASONABLE PRICING FOR FUTURE CHANGES/ADJUSTMENTS. |
THE TOTAL PRICE FOR THESE QUANTITIES IS NOT NECESSARILY THE FINAL PRICE FOR THIS WORK. THE FINAL PRICE WILL BE BASED ON ACTUAL FIELD VERIFIED QUANTITIES. SHOULD THE ACTUAL QUANTITIES DIFFER FROM THE PRICING, THE FINAL PRICE WILL ADJUSTED UPWARDS OR DOWNWARDS BY CONTRACT MODIFICATION BASED ON THE UNIT PRICES ESTABLISHED IN THE MATERIAL UNIT PRICING WORKSHEET.
SUMMARY PAGE
SOLICITATION NO.: NIHOF2017154 - - BUILDING 10 E-WING RENOVATION
TABLE B-1 -- BID PRICE SUMMARY *USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS
| DIV. #:* | ITEM DESCRIPTION | |
| (Use CSI Division Worksheet to back-up all pricing information for each Division listed in Table) | (A) | |
| MATERIALS | (B) | |
| LABOR | (C) = (A) + (B) | |
| SUBTOTAL COST | (D) | |
| SUBCONTRACTOR COSTS | (E) = (C) + (D) |
TOTAL COST
| Ex: 01 | EXAMPLE - GENERAL REQUIREMENTS | $ 400.00 | $ 9,120.00 | $ 9,520.00 | $ 14,222.25 | $ 23,742.25 |
| Ex: 23 | EXAMPLE - HVAC | $ 500.00 | $ 9,120.00 | $ 9,620.00 | $ 16,537.50 | $ 26,157.50 |
| Ex: 26 | EXAMPLE - ELECTRICAL | $ 100,000.00 | $ 2,000.00 | $ 102,000.00 | $ 33,075.00 | $ 135,075.00 |
| LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D | $ - 0 | $ - 0 | $ - 0 | |||
| LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D | $ - 0 | $ - 0 | $ - 0 | |||
| LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D | $ - 0 | $ - 0 | $ - 0 | |||
| LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D | $ - 0 | $ - 0 | $ - 0 | |||
| 5 | LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D | $ - 0 | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | $ - 0 | ||||
| cGMP NTE Allowance - Work included in the cGMP Allowance as described in the construction documents | $ 20,000,000.00 | $ - 0 | $ 20,000,000.00 | |||
| SUBTOTAL - 1: | $ 20,121,140.00 | $ 63,834.75 | $ 20,184,974.75 |
OVERHEAD (% * subtotal 1 (C)) : (INSERT %) 10% $ 2,012,114.00
SUBTOTAL- 2 (subtotal 1 (C ) + overhead): $ 22,133,254.00
PROFIT (% * subtotal 2): (INSERT %) 10% $ 2,213,325.40
SUBTOTAL - 3 (subtotal 2 + profit): $ 24,346,579.40
TOTAL SUBCONTRACTOR COSTS (subtotal 1 (D)): $ 63,834.75
SUBTOTAL - 4 (subtotal 3 + total subcontractor costs): $ 24,410,414.15
PERFORMANCE / PAYMENT BOND: $ 1,000.00
TOTAL CONTRACT PRICE (subtotal 4 + bond): $ 24,411,414.15
MATERIAL UNIT PRICING WORKSHEET
| Material Unit Pricing | |||||
| Item | Scope | Quanity | Unit of Measure | Per Unit Pricing | Total Price |
| 1 | Brick re-pointing of existng brick veneer and cast stone lintels on the E-Wing. The total area of brick masonry exterior wall is assumed to be 46,800 sf. | 46,800 | SF | $ - 0 | $ - 0 |
| 2 | Itemized masonry repairs: | ||||
| a. Tuck pointing of deteriorated mortar joints in brick masonry mortar joints for 3,000 lf of joints. | 3,000 | LF | $ - 0 | $ - 0 | |
| b. Tuck pointing of deteriorated mortar joints in cast stone lintels/sills for 2,400 lf of joints. | 2,400 | LF | $ - 0 | $ - 0 | |
| c. Repair of cast stone lintels/sills for 110 lf pf cast stone lintels/sills. | 110 | LF | $ - 0 | $ - 0 | |
| d. Replacement of 1,500 SF OF cracked brick. | 1,500 | LF | $ - 0 | $ - 0 | |
| e. Repair of flashing over steel lintels and shelf angles for 1,100 lf of existing steel lintels repair | 1,100 | LF | $ - 0 | $ - 0 | |
| f. Cleaning and painting of steel lintels and shelf angles for 930 lf of steel lintels and shelf angles | 930 | LF | $ - 0 | $ - 0 | |
| g. Installation of retrofit masonry ties/anchors, three courses above and below existing shelf angles, and along existing and new control and expansion joints for estimated installation of 100 retrofit wall ties/anchors. | 100 | EA | $ - 0 | $ - 0 |
3 Flash patching and patching of existing concrete floors with patch materials used to repair concrete substrate preparatory to installation of traffic bearing waterproofing system as indicated in section 096630, total floor area which is assumed to be 238,100 sf. 238,100 SF $ - 0 $ - 0
4 Leveling of existing concrete floors with polymer modified self-leveling hydraulic cement material (section 035416) preparatory to installation of traffic bearing waterproofing system for total floor area which is assumed to be 238,100 sf. 238,100 SF $ - 0 $ - 0
5 Infill of concrete topping slab from wall removal for 32,576 lf of existing interior partitions. 32,576 LF $ - 0 $ - 0
CSI DIVISION WORKSHEET #1
SOLICITATION NO.: NIHOF2017154 - - BUILDING 10 E-WING RENOVATION
| *USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS | |
| TABLE B-2 -- BID PRICING BACKUP INFORMATION | Repeat worksheet for each CSI Division of Construction as required |
DIV. #:* DIVISION DESCRIPTION: QUANTITY MATERIALS LABOR (G) = (D) + (F)
TOTAL ITEM COST
| Ex: 01 | EXAMPLE - GENERAL REQUIREMENTS | (A) | |
| No. Units | (B) | ||
| Unit Meas. | (C) | ||
| $ Per Unit | (D) = (A) *(C) | ||
| Subtotal | (E) | ||
| $ Per Unit | (F) = (A) * (E) |
Subtotal
| ITEM # | PRIME WORK ITEMS | ||||||||
| 1 | Ex - Project Manager | 4 | wks | $ - 0 | $ - 0 | $ 2,280.00 | $ 9,120.00 | $ 9,120.00 | |
| 2 | Ex - Telephone Service | 2 | mos. | $ 200.00 | $ 400.00 | $ - 0 | $ - 0 | $ 400.00 | |
| 3 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 4 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 5 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 6 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 7 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 8 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 9 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 10 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 11 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 12 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 13 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 14 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 15 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 16 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 17 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 18 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 19 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 20 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 21 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 22 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 23 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 24 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 25 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 1 - PRIME SUBTOTAL: | $ 400.00 | $ 9,120.00 | $ 9,520.00 | ||||||
| SUBCONTRACTOR(S) WORK ITEMS* | |||||||||
| (Provide separate back-up for each subcontractor listed) | QUANTITY | MATERIALS | LABOR | (G) = (D) + (F) |
TOTAL ITEM COST
| (A) | ||
| No. Units | (B) | |
| Unit Meas. | (C) | |
| $ Per Unit | (D) = (A) *(C) | |
| Subtotal | (E) | |
| $ Per Unit | (F) = (A) * (E) |
Subtotal
| 1 | Ex - Subcontractor #1 - ABC Mechanical Company | $ 200.00 | $ 5,000.00 | $ 5,200.00 |
| 2 | Ex - Subcontractor #2 - DEF Electrical Corporation | $ 500.00 | $ 6,000.00 | $ 6,500.00 |
| 3 | Ex - Subcontractor #3 - GHI Enterprise, Inc. | $ 200.00 | $ 1,000.00 | $ 1,200.00 |
| 4 | $ - 0 | $ - 0 | $ - 0 | |
| 5 | $ - 0 | $ - 0 | $ - 0 | |
| 2 - SUBCONTRACTOR SUBTOTAL: | $ 900.00 | $ 12,000.00 | $ 12,900.00 |
3 - PRIME OVERHEAD ON SUBCONTRACTOR (% * Subcontractor (G)): (INSERT)% 5% $ 645.00
4 - SUBTOTAL (SUM 2 + 3): $ 13,545.00
5 - PRIME PROFIT ON SUBCONTRACTOR (% * Subtotal 4): (INSERT)% 5% $ 677.25
6 - TOTAL SUBCONTRACTOR (SUM 4 +5): $ 14,222.25
TOTAL DIVISION (SUM 1 + 6): $ 23,742.25
CSI DIVISION WORKSHEET #2
SOLICITATION NO.: NIHOF2017154 - - BUILDING 10 E-WING RENOVATION
| *USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS | |
| TABLE B-2 -- BID PRICING BACKUP INFORMATION | Repeat worksheet for each CSI Division of Construction as required |
DIV. #:* DIVISION DESCRIPTION: QUANTITY MATERIALS LABOR (G) = (D) + (F)
TOTAL ITEM COST
| Ex: 23 | EXAMPLE - HVAC | (A) | |
| No. Units | (B) | ||
| Unit Meas. | (C) | ||
| $ Per Unit | (D) = (A) *(C) | ||
| Subtotal | (E) | ||
| $ Per Unit | (F) = (A) * (E) |
Subtotal
| ITEM # | PRIME WORK ITEMS | ||||||||
| 1 | EX- Dampers | 4 | ea. | $ 50.00 | $ 200.00 | $ 2,280.00 | $ 9,120.00 | $ 9,320.00 | |
| 2 | Ex - Hydronic piping | 12 | lf | $ 25.00 | $ 300.00 | $ - 0 | $ - 0 | $ 300.00 | |
| 3 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 4 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 5 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 6 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 7 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 8 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 9 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 10 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 11 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 12 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 13 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 14 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 15 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 16 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 17 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 18 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 19 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 20 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 21 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 22 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 23 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 24 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 25 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 1 - PRIME SUBTOTAL: | $ 500.00 | $ 9,120.00 | $ 9,620.00 | ||||||
| SUBCONTRACTOR(S) WORK ITEMS* | |||||||||
| (Provide separate back-up for each subcontractor listed) | QUANTITY | MATERIALS | LABOR | (G) = (D) + (F) |
TOTAL ITEM COST
| (A) | ||
| No. Units | (B) | |
| Unit Meas. | (C) | |
| $ Per Unit | (D) = (A) *(C) | |
| Subtotal | (E) | |
| $ Per Unit | (F) = (A) * (E) |
Subtotal
| 1 | Ex - Subcontractor #1 - ABC Mechanical Company | $ 5,000.00 | $ 10,000.00 | $ 15,000.00 |
| 2 | Ex - Subcontractor #2 - DEF Electrical Corporation | $ - 0 | $ - 0 | $ - 0 |
| 3 | Ex - Subcontractor #3 - GHI Enterprise, Inc. | $ - 0 | $ - 0 | $ - 0 |
| 4 | $ - 0 | $ - 0 | $ - 0 | |
| 5 | $ - 0 | $ - 0 | $ - 0 | |
| 2 - SUBCONTRACTOR SUBTOTAL: | $ 5,000.00 | $ 10,000.00 | $ 15,000.00 |
3 - PRIME OVERHEAD ON SUBCONTRACTOR (% * Subcontractor (G)): (INSERT)% 5% $ 750.00
4 - SUBTOTAL (SUM 2 + 3): $ 15,750.00
5 - PRIME PROFIT ON SUBCONTRACTOR (% * Subtotal 4): (INSERT)% 5% $ 787.50
6 - TOTAL SUBCONTRACTOR (SUM 4 +5): $ 16,537.50
TOTAL DIVISION (SUM 1 + 6): $ 26,157.50
CSI DIVISION WORKSHEET #3
SOLICITATION NO.: NIHOF2017154 - - BUILDING 10 E-WING RENOVATION
| *USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS | |
| TABLE B-2 -- BID PRICING BACKUP INFORMATION | Repeat worksheet for each CSI Division of Construction as required |
DIV. #:* DIVISION DESCRIPTION: QUANTITY MATERIALS LABOR (G) = (D) + (F)
TOTAL ITEM COST
| Ex: 26 | EXAMPLE - ELECTRICAL | (A) | |
| No. Units | (B) | ||
| Unit Meas. | (C) | ||
| $ Per Unit | (D) = (A) *(C) | ||
| Subtotal | (E) | ||
| $ Per Unit | (F) = (A) * (E) |
Subtotal
| ITEM # | PRIME WORK ITEMS | ||||||||
| 1 | Ex - Dry-type , medium voltage transformer | 1 | ea | $ 100,000.00 | $ 100,000.00 | $ 2,000.00 | $ 2,000.00 | $ 102,000.00 | |
| 2 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 3 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 4 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 5 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 6 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 7 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 8 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 9 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 10 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 11 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 12 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 13 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 14 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 15 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 16 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 17 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 18 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 19 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 20 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 21 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 22 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 23 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 24 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 25 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 1 - PRIME SUBTOTAL: | $ 100,000.00 | $ 2,000.00 | $ 102,000.00 | ||||||
| SUBCONTRACTOR(S) WORK ITEMS* | |||||||||
| (Provide separate back-up for each subcontractor listed) | QUANTITY | MATERIALS | LABOR | (G) = (D) + (F) |
TOTAL ITEM COST
| (A) | ||
| No. Units | (B) | |
| Unit Meas. | (C) | |
| $ Per Unit | (D) = (A) *(C) | |
| Subtotal | (E) | |
| $ Per Unit | (F) = (A) * (E) |
Subtotal
| 1 | Ex - Subcontractor #1 - ABC Mechanical Company | $ - 0 | $ - 0 | $ - 0 |
| 2 | Ex - Subcontractor #2 - DEF Electrical Corporation | $ 20,000.00 | $ 10,000.00 | $ 30,000.00 |
| 3 | Ex - Subcontractor #3 - GHI Enterprise, Inc. | $ - 0 | $ - 0 | $ - 0 |
| 4 | $ - 0 | $ - 0 | $ - 0 | |
| 5 | $ - 0 | $ - 0 | $ - 0 | |
| 2 - SUBCONTRACTOR SUBTOTAL: | $ 20,000.00 | $ 10,000.00 | $ 30,000.00 |
3 - PRIME OVERHEAD ON SUBCONTRACTOR (% * Subcontractor (G)): (INSERT)% 5% $ 1,500.00
4 - SUBTOTAL (SUM 2 + 3): $ 31,500.00
5 - PRIME PROFIT ON SUBCONTRACTOR (% * Subtotal 4): (INSERT)% 5% $ 1,575.00
6 - TOTAL SUBCONTRACTOR (SUM 4 +5): $ 33,075.00
TOTAL DIVISION (SUM 1 + 6): $ 135,075.00
image1.png image2.png
File details come from the government source that posted it. Updated .