Attachment 6 SP470626R0001 ATG GLOBAL CLIN 5 CM Pricing Spreadsheet.xlsx
XLSX spreadsheet 37 KB Posted
- Attached to
- ATG GLOBAL Engineering Services
- Solicitation number
- SP470626R0001
- Issued by
-
Defense Logistics Agency
About this file
This is a pricing spreadsheet template (Attachment 6) for CLIN 0005 Corrective Maintenance (CM) under solicitation SP4706-26-R-0001 for the Hydrant Fueling Automation Maintenance (HFAM) program. The template is designed for contractors to submit time-and-materials pricing proposals covering a five-year performance period (FY26/27 through FY30/31).
The spreadsheet contains four primary cost categories: Direct Labor, Material Costs, Travel Costs, and Other Direct Costs with G&A and Profit. The Direct Labor section lists 25 predefined labor categories including Program Manager, Project Manager, Engineers/Scientists at multiple levels, Logisticians, Management Analysts, Technical Analysts, Administrative personnel, and SCA-covered positions such as Computer Programmers, Electronics Technicians, and Drafters/CAD Operators, with provisions for contractors to add additional labor categories. The Material section itemizes 77 specific equipment and installation materials required for HFAM systems, including server stacks, client workstations, NEMA enclosures, Remote Interface Units (RIU), junction boxes, fiber optic components, flow computers, network switches, PLCs, UPS units, conduit types, cables, grounding equipment, and spare parts, with contractors able to propose zero quantities or add items as needed. The Travel section accommodates up to 18 trips with fields for destination, number of travelers, days, and nights. All labor rates are to be burdened, while material costs should be quoted at cost without burden. Profit and Other Direct Costs can only be applied to the labor line. The template uses formulas in shaded cells that contractors must not overwrite.
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
CLIN 0005 Cumulative Price
| Contractor Name: |
| Proposal Dated: |
| Item # | Item | Price |
| 1 | Direct Labor | $ - 0 |
| 2 | Material Costs | $ - 0 |
| 3 | Travel Costs | $ - 0 |
| 4 | *Other Direct Cost - All Others | $ - 0 |
| 5 | *G&A, Profit, All Other Indirect Burdens | $ - 0 |
| Total Time & Material Estimate | $ - 0 | |
| Note: Gray Shaded boxes are formulas, please do not overwrite | ||
| *Profit and ODC can only be built in the labor line, | ||
| not the material and travel line |
&"Times New Roman,Regular"&12Hydrant Fueling Automation Maintenance (HFAM) &"Times New Roman,Regular"&12CLIN 0005: Corrective Maintenance (CM) Solicitation SP4706-25-R-0006 &"Times New Roman,Regular"&12Attachment 3
Source Selection Information, See FAR 2.101 & 3.104 &"Times New Roman,Regular"&12Page &P of &N &"Times New Roman,Regular"&12Version Date: 21Jan20
Direct Labor Contractor Name: Proposal Dated:
| Year 1 (FY26/27) | Year 2 (FY27/28) | Year 3 (FY28/29) | Year 4 (FY29/30) | Year 5 (FY30/31) | |||||||||||||
| Line # | Labor Category | Hourly Rate | Labor Hours | Sub-Total | Hourly Rate | Labor Hours | Sub-Total | Hourly Rate | Labor Hours | Sub-Total | Hourly Rate | Labor Hours | Sub-Total | Hourly Rate | Labor Hours | Sub-Total | Total |
| 1 | Program Manager | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 2 | Project Manager | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 3 | Engineer/Scientist 3 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 4 | Engineer/Scientist 2 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 5 | Engineer/Scientist 1 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 6 | Junior Engineer/Scientist | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 7 | Logistician 3 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 8 | Logistician 2 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 9 | Management Analyst 2 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 10 | Management Analyst 1 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 11 | Technical Analyst 3 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 12 | Management and Program Technician 3 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 13 | Accounting Clerk II (SCA 01012) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 14 | Administrative Assistant (SCA 01020) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 15 | Supply Technician (SCA 01410) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 16 | Computer Programmer III (SCA 14073) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 17 | Computer Programmer IV (SCA 14074) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 18 | Computer System Analyst III (SCA 14103) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 19 | Electronics Technician II (SCA 23182) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 20 | Electronics Technician III (SCA 23183) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 21 | Laborer (SCA 23470) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 22 | Drafter/CAD Operator II (SCA 300062) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 23 | Drafter/CAD Operator III (SCA 300063) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 24 | Drafter/CAD Operator IV (SCA 300064) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 25 | Engineering Technician III (SCA 30083) | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||
| 26* | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||
| 27* | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||
| 28* | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||
| 29* | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||
| Total Labor | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0 | ||||||
| Note: Labor Rates used on this table should be burdened. | |||||||||||||||||
| Note: Gray Shaded boxes are formulas, please do not overwrite | |||||||||||||||||
| Note: Offerors may propose alternate Labor Categories or propose zero hours against the categories listed on lines 1-25. | |||||||||||||||||
| * Add additonal lines starting at Row 26 for any direct labor category not listed above. Insert as many lines as required. |
&"Times New Roman,Regular"&12Hydrant Fueling Automation Maintenance (HFAM) &"Times New Roman,Regular"&12CLIN 0005 CM - Direct Labor &"Times New Roman,Regular"&12Attachment 3
Source Selection Information, See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Page &P of &N &"Times New Roman,Regular"&12Version Date: 26Aug25
Material Contractor Name: Proposal Dated:
| Year 1 FY26/27 | Year 2 FY27/28 | Year 3 FY28/29 | Year 4 FY29/30 | Year 5 FY30/31 | ||||||||||||||
| Line # | Item | U/I | QTY | Price/UI | Sub-Total | QTY | Price/UI | Sub-Total | QTY | Price/UI | Sub-Total | QTY | Price/UI | Sub-Total | QTY | Price/UI | Sub-Total | Total |
| 1 | Server Stack (4.0) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 2 | Server Stack (4.0) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 3 | Client Workstation (4.0) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 4 | Client Workstation (4.0) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 5 | OCC Printer | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 6 | OCC Printer Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 7 | NEMA 4x Enclosure (Small) 24 x 24 x 12 (316 Stainless) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 8 | NEMA 4x Enclosure (Small) 30 x 24 x 12 (316 Stainless) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 9 | NEMA 4x Enclosure (Medium) 36 x 36 x 12 (316 Stainless) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 10 | NEMA 4x Enclosure (Large) 48 x 36 x 12 (316 Stainless) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 11 | RIU | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 12 | RIU Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 13 | JB | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 14 | JB Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 15 | FOP (Fiber Breakout) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 16 | FOP (Fiber Breakout) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 17 | Ground Reader (GIS for Enraf) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 18 | Ground Reader (GIS for Enraf) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 19 | Flow Computer (Pipeline) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 20 | Flow Computer (Truck Rack) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 21 | Flow Computer Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 22 | Flow Transmitter | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 23 | Flow Transmitter Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 24 | MOV | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 25 | MOV Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 26 | MOV Power Switch Local | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 27 | MOV Power Switch Local Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 28 | Network Switch (Small) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 29 | Network Switch (Medium) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 30 | Network Switch (Large) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 31 | Serial/Ethernet Bridge | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 32 | PLC (Small) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 33 | PLC (Medium) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 34 | PLC (Large) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 35 | UPS (Small - .75 KVA) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 36 | UPS (Small - .75 KVA) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 37 | UPS (Large - 5.3 KVA) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 38 | UPS (Large - 5.3 KVA) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 39 | Surge Suppressor | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 40 | Power Panel | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 41 | Power Panel Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 42 | Power Breaker | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 43 | Power Supply | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 44 | Pipeline Differential Pressure Transmitter (PDIT) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 45 | Pipeline Differential Pressure Transmitter (PDIT) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 46 | Pipeline Pressure Indicating Transmitter (PIT) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 47 | Pipeline Pressure Indicating Transmitter (PIT) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 48 | Tank Gauge Interface (Ground Reader) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 49 | Tank Gauge Interface (Ground Reader) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 50 | Remote Annunciator (Horn/Light) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 51 | Remote Annunciator (Horn/Light) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 52 | Conduit (2" HDPE) /1' - with UG Boring | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 53 | Conduit (1" Galvanized) /10' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 54 | Conduit (1" PVC-Coated Galvanized) /10' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 55 | Conduit (Liquid Tight Flex) /10' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 56 | Conduit (Explosion Proof Flex) /10' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 57 | Conduit Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 58 | Conduit Seals (EYS) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 59 | MI Cable (Seal) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 60 | MI Cable (Seal) Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 61 | Conduit (PVC Underground/Concrete) /10' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 62 | Conduit Fittings - GAU | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 63 | Conduit Fittings - GAU Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 64 | Mounting structures (enclosures, conduit) | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 65 | Fiber cable (48, single mode) /1' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 66 | Aerial Fiber cable /1' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 67 | Underground Boring | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 68 | 12/3 AWG Power cable /1' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 69 | 10/3 AWG Power Cable /1' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 70 | 2-Pair 22 AWG Twisted Pair signal cable /1' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 71 | 3-Pair 18 AWG Twisted Pair Signal Cable /1' | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 72 | Grounding Rods/Plates | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 73 | Grounding Rods/Plates Installation Material | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 74 | Application & License Costs | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 75 | Spare Equipment | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 76 | Demolition Expense | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 77 | Freight/Shipping | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 78* | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 79* | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 80* | EA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 81 | EA | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | ||||||
| Total Material | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||
| Note: Material should be quoted at Cost (not burdened). | ||||||||||||||||||
| Note: Gray Shaded boxes are formulas, please do not overwrite. | ||||||||||||||||||
| Note: Offerors may propose zero quantity against the items listed on lines 1-77 if not required for this Task Order/installation. | ||||||||||||||||||
| * Add additonal lines starting at Row 78 for any material item not listed above. Insert as many lines as required. |
&"Times New Roman,Regular"&12Hydrant Fueling Automation Maintenance (HFAM) &"Times New Roman,Regular"&12CLIN 0005 CM - Material &"Times New Roman,Regular"&12Attachment 3
Source Selection Information, See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Page &P of &N &"Times New Roman,Regular"&12Version Date: 26Aug25
Travel
Contractor Name: Proposal Dated:
Line # Description of Trip with Estimated Date per Proposed Schedule Destination Sarah Fudela: Enter the Location of Travel
| # of Trips | # of Travelers | # of Days | # of Nights | Total Cost | |
| 1 | 1 | ||||
| 2 | 1 | ||||
| 3 | 1 | ||||
| 4 | 1 | ||||
| 5 | 1 | ||||
| 6 | 1 | ||||
| 7 | 1 | ||||
| 8 | 1 | ||||
| 9 | 1 | ||||
| 10 | 1 | ||||
| 11 | 1 | ||||
| 12 | 1 | ||||
| 13* | |||||
| 14* | |||||
| 15* | |||||
| 16* | |||||
| 17* | |||||
| 18* | |||||
| Total Travel | $0.00 | ||||
| Note: Costs are not burdened | |||||
| Note: Gray Shaded boxes are formulas, please do not overwrite | |||||
| *Add additional lines starting at row 18 and insert as many lines as required. |
&"Times New Roman,Regular"&12Hydrant Fueling Automation Maintenance (HFAM) &"Times New Roman,Regular"&12CLIN 0005 CM - Travel &"Times New Roman,Regular"&12Attachment 3
Source Selection Information, See FAR 2.101 and 3.104 Version Date: 26Aug25
File details come from the government source that posted it. Updated .