Attachment_6-Price_Schedule.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- HVAC Replacement, HPTC Ops Facility, Frederick, MD Federal contract opportunity
- Solicitation number
- 140P2123Q0161
About this file
This document contains a price schedule template for modifications to an HVAC replacement project. The template includes lines for labor, material, equipment, and general comments. Prices and quantities are to be entered into the green cells. It provides instructions on using functions like insert, delete, and fill down to add or remove lines as needed for multiple cost items. A related federal contract opportunity is provided for HVAC replacement at the HPTC Operations Facility in Frederick, Maryland under Solicitation 140P2123Q0161 issued by the Department of the Interior National Park Service. The template requests general project information, an estimate date, and spaces for noting revisions with new dates.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment_8_-_RFI_Answer_Sheet_0001.pdf | ||
| Sol_140P2123Q0161_Amd_0001.pdf | ||
| Attachment_1_-_Revised_Statement_of_Work_(7-21-2023)_0001.pdf | ||
| Attachment_4_-_AAON_Ratings_data___drawings_with_HGBP.pdf | ||
| Attachment_1_-_Statement_of_Work_(6-28-2023).pdf | ||
| Attachment_2_-_Jenkins_Warehouse-Interior_Rehabilitation.pdf | ||
| Attachment_7_-_SCA_Wage_Determination__2015-4269__Frederick_County__MD.pdf | ||
| Attachment_5_-_Aaon_Pipe_drawing_-_isometric.pdf | ||
| Attachment_3_-_Lead_Abatement_Shop.pdf | ||
| Sol_140P2123Q0161.pdf |
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
Price Schedule Tasks cosgood: Insert "Construction Activities" into the lines below with the related labor, material, & equipment within the same line.
Insert any details into comment box on line item. If any written backup, PDF, reference in comment box and safe with estimate as "Backup"
| LABOR | MATERIAL | EQUIPMENT | ||||||||
| LINE | Quantity | Unit$ | Total | Quantity | Unit$ | Total | Quantity | Unit$ | Total |
| cosgood: If any work that is in the base contract is to be deleted in lieu of modification work, then the costs of that work goes in this section. Input in positive numbers and the totals are formulated to show negative. | 1 | AHU #1 Replacement | 0.00 | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | sf | $0.00 | $0 |
| 2 | Disassemble and remove existing unit | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | Item | $0.00 | $0 | ||
| 3 | Dispose of removed AHU, Condensing Unit and line sets | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | Item | $0.00 | $0 | ||
| 4 | Install new AHU, condensing unit, line set and controls | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | Item | $0.00 | $0 | ||
| 5 | Connect new AHU to ductwork and seal joints | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 6 | Perform start up to confirm system function | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 7 | Train facility staff in operation of new equipment | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 8 | Provide one-year parts and labor warranty | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 9 | AHU #3 Replacement | 0.00 | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | ||
| 10 | Disassemble and remove existing unit | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 11 | Dispose of removed AHU, Condensing Unit and line sets | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 12 | Install new AHU, condensing unit, line set and controls | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 13 | Connect new AHU to ductwork and seal joints | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 14 | Perform start up to confirm system function | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 15 | Train facility staff in operation of new equipment | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 | |||
| 16 | Provide one-year parts and labor warranty | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | $0.00 | $0 |
cosgood: Lines can be added or deleted by using the "Delete" or "Insert" function following by "Copy" or "Fill down" function to populate the new rows with the formulas.
Site Access cosgood: Any specific general conditions associated with this modifications to be specifically listed out in detail here.
| 17 | Crane services to remove and place condensing units | hr | $0.00 | $0 | 0.00 | $0.00 | $0 | 0.00 | ls | $0.00 | $0 |
| SUBTOTALS | Labor | $0 | Total Material Costs | $0 | Total Equipment Cost | $0 |
TOTAL COST
cosgood: General Comments
ENTER INTO THE LIGHT GREEN CELLS ONLY
For an explanation of how this spread sheet works, various cells have red comment triangles to describe the intent of the cell or that area of the spreadsheet.
For example:
This cell is for the Total Cost of this specific Modification Line Item. IN ADDITION, IF WHILE INPUTTING DATA INTO THIS SPREADSHEET A MAJOR FORMULA ERROR OCCURS, THIS CELL "A1 - G1", WILL IMMEDIATLY TURN RED, ALLOWING YOU TO IMMEDIATLY FIX THE IMPUTTING ERROR. ONCE THE ERROR IS FIXED, THE CELL WILL RETURN TO GREEN.
Note: Enter ALL data into INFORMATION & STATISTICS section first, then the ESTIMATING SECTION next.
For Modifications with multiple cost items, this spreadsheet has tabs at the bottom Labeled "Item". General Information that is the same for all "Items" on the tabs are linked so when you input on the "Item 1" tab it will show-up in the remaining tabs of this spreadsheet. Examples of this are Park Name, Labor Tax, GC Overhead, Profit, etc.
The "Item" tabs are tied to the "Mod Summary" tab which shows the total cost of a Modification that has multiple line items.
| TO REMOVE THIS AND OTHER COMMENTS, PLACE MOUSE IN CELL WITH RED TRIANGLE, RIGHT CLICK TO OPEN DROP DOWN MENU, RIGHT CLICK ON HIDE OR DELETE COMMENT. | LS | ||
| Estimate Date | 0 |
cosgood: After the initial estimate is completed, any revisons are to be numbered here with the new estimate date.
File details come from the government source that posted it. Updated .