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

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 #ItemPrice
1Direct Labor$ - 0
2Material Costs$ - 0
3Travel 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 CategoryHourly RateLabor HoursSub-TotalHourly RateLabor HoursSub-TotalHourly RateLabor HoursSub-TotalHourly RateLabor HoursSub-TotalHourly RateLabor HoursSub-TotalTotal
1Program Manager$0$0$0$0$0$0
2Project Manager$0$0$0$0$0$0
3Engineer/Scientist 3$0$0$0$0$0$0
4Engineer/Scientist 2$0$0$0$0$0$0
5Engineer/Scientist 1$0$0$0$0$0$0
6Junior Engineer/Scientist$0$0$0$0$0$0
7Logistician 3$0$0$0$0$0$0
8Logistician 2$0$0$0$0$0$0
9Management Analyst 2$0$0$0$0$0$0
10Management Analyst 1$0$0$0$0$0$0
11Technical Analyst 3$0$0$0$0$0$0
12Management and Program Technician 3$0$0$0$0$0$0
13Accounting Clerk II (SCA 01012)$0$0$0$0$0$0
14Administrative Assistant (SCA 01020)$0$0$0$0$0$0
15Supply Technician (SCA 01410)$0$0$0$0$0$0
16Computer Programmer III (SCA 14073)$0$0$0$0$0$0
17Computer Programmer IV (SCA 14074)$0$0$0$0$0$0
18Computer System Analyst III (SCA 14103)$0$0$0$0$0$0
19Electronics Technician II (SCA 23182)$0$0$0$0$0$0
20Electronics Technician III (SCA 23183)$0$0$0$0$0$0
21Laborer (SCA 23470)$0$0$0$0$0$0
22Drafter/CAD Operator II (SCA 300062)$0$0$0$0$0$0
23Drafter/CAD Operator III (SCA 300063)$0$0$0$0$0$0
24Drafter/CAD Operator IV (SCA 300064)$0$0$0$0$0$0
25Engineering 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/27Year 2 FY27/28Year 3 FY28/29Year 4 FY29/30Year 5 FY30/31
Line #ItemU/IQTYPrice/UISub-TotalQTYPrice/UISub-TotalQTYPrice/UISub-TotalQTYPrice/UISub-TotalQTYPrice/UISub-TotalTotal
1Server Stack (4.0)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2Server Stack (4.0) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3Client Workstation (4.0)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4Client Workstation (4.0) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5OCC PrinterEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6OCC Printer Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7NEMA 4x Enclosure (Small) 24 x 24 x 12 (316 Stainless)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8NEMA 4x Enclosure (Small) 30 x 24 x 12 (316 Stainless)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9NEMA 4x Enclosure (Medium) 36 x 36 x 12 (316 Stainless)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10NEMA 4x Enclosure (Large) 48 x 36 x 12 (316 Stainless)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
11RIUEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
12RIU Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
13JBEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
14JB Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
15FOP (Fiber Breakout)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
16FOP (Fiber Breakout) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
17Ground Reader (GIS for Enraf)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
18Ground Reader (GIS for Enraf) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
19Flow Computer (Pipeline)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
20Flow Computer (Truck Rack)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
21Flow Computer Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
22Flow TransmitterEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
23Flow Transmitter Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
24MOVEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
25MOV Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
26MOV Power Switch LocalEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
27MOV Power Switch Local Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
28Network Switch (Small)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
29Network Switch (Medium)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
30Network Switch (Large)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
31Serial/Ethernet BridgeEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
32PLC (Small)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
33PLC (Medium)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
34PLC (Large)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
35UPS (Small - .75 KVA)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
36UPS (Small - .75 KVA) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
37UPS (Large - 5.3 KVA)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
38UPS (Large - 5.3 KVA) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
39Surge SuppressorEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
40Power PanelEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
41Power Panel Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
42Power BreakerEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
43Power SupplyEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
44Pipeline Differential Pressure Transmitter (PDIT)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
45Pipeline Differential Pressure Transmitter (PDIT) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
46Pipeline Pressure Indicating Transmitter (PIT)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
47Pipeline Pressure Indicating Transmitter (PIT) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
48Tank Gauge Interface (Ground Reader)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
49Tank Gauge Interface (Ground Reader) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
50Remote Annunciator (Horn/Light)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
51Remote Annunciator (Horn/Light) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
52Conduit (2" HDPE) /1' - with UG BoringEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
53Conduit (1" Galvanized) /10'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
54Conduit (1" PVC-Coated Galvanized) /10'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
55Conduit (Liquid Tight Flex) /10'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
56Conduit (Explosion Proof Flex) /10'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
57Conduit Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
58Conduit Seals (EYS)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
59MI Cable (Seal)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
60MI Cable (Seal) Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
61Conduit (PVC Underground/Concrete) /10'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
62Conduit Fittings - GAUEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
63Conduit Fittings - GAU Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
64Mounting structures (enclosures, conduit)EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
65Fiber cable (48, single mode) /1'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
66Aerial Fiber cable /1'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
67Underground BoringEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6812/3 AWG Power cable /1'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6910/3 AWG Power Cable /1'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
702-Pair 22 AWG Twisted Pair signal cable /1'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
713-Pair 18 AWG Twisted Pair Signal Cable /1'EA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
72Grounding Rods/PlatesEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
73Grounding Rods/Plates Installation MaterialEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
74Application & License CostsEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
75Spare EquipmentEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
76Demolition ExpenseEA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
77Freight/ShippingEA$ - 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
81EA- 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 NightsTotal Cost
11
21
31
41
51
61
71
81
91
101
111
121
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 .