Atch 5-Pricing Sheet-Well Automation BLANK-NO FORMULA.xlsx
XLSX spreadsheet 36 KB Posted
- Attached to
- Repair Wells 3 SCADA Automation Federal contract opportunity
- Solicitation number
- FA480325B0002
About this file
This is a pricing spreadsheet template with three Contract Line Item Numbers (CLINs) for a well automation and marquee project at Shaw AFB. CLIN0001 and CLIN0002 are blank templates listing required items including chemical analyzers, eyewash stations, TVs, Studio 5000 software, Factory Talk software, Allen Bradley VFDs, stripper level systems, ultrasonic level sensors, flow meters, PLC programming/automation, chemical feed pumps, and sample tables.
CLIN0003 provides detailed pricing for an ARCENT Marquee project totaling $164,881.34, which includes specific line items for ductwork ($16,432), concrete ($8,686), 15kV cable ($42,924), transformers, sectionalizing cabinets, mobilization/demobilization, testing, boring, and design work. The pricing structure includes overhead (10%), profit (10%), and bond (2.5%) markups. Labor rates range from $50-60 per hour for various tasks, with project management at $58.13/hr and superintendent at $54.38/hr.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Atch 1-Statement of Work- VLSB 18-0010 Repair Well 3 with SCADA Upgrade.pdf | ||
| Atch 2- Shaw AFB Well Utility Controls Schematic.pdf | ||
| Atch 6-Air Force Form 66-Blank.xlsx | XLSX spreadsheet | |
| Atch 3-HMI Screen Reference.pdf | ||
| Atch 4-Site Pictures CLIN 0001.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
CLIN0001
| Project: | Well Automation | Project Engineer: | Christopher Smith | |
| Location: | Department: | 20 CES | ||
| Contractor: | Date: | 12/18/24 | ||
| Address: | Total | |||
| PR No.: |
Line No. Item Units Quantity Material Costs Labor Costs Direct Cost Line Total
| Unit Cost | Total | Labor Hours per Unit | Labor Hours | Avg. Rate ($/hr) | Total | |||
| 1 | Chem Analyzers | LS | ||||||
| 2 | Eye wash stations | EA | ||||||
| 3 | 65'' TV | EA | ||||||
| 4 | 55'' TV | EA | ||||||
| 5 | Studio 5000 Purchase and install | EA | ||||||
| 6 | Factory Talk Purchase and install | EA | ||||||
| 7 | Allen Bradley VFD | EA | ||||||
| 8 | Stripper level system upgrade | EA | ||||||
| 9 | Demo | LS | ||||||
| 10 | Ultrasonic Level sensors | EA | ||||||
| 11 | Flow Meters | EA | ||||||
| 12 | PLC Programing | EA | ||||||
| 13 | PLC Automation setup Testing | EA | ||||||
| 14 | Chemical Feed Pumps | EA | ||||||
| 15 | Sample table | Ea | ||||||
| 16 | Labeling | EA | ||||||
| 17 | ||||||||
| 18 | ||||||||
| 19 | ||||||||
| 20 | ||||||||
| 21 | Superintendent | WK | ||||||
| 22 | Project Manager | WK | ||||||
| 23 | Design | EA | ||||||
| Total: |
| Total Material Cost: |
| Total Labor Cost: |
| Direct Cost: |
| Total Line Item Cost: |
| Overhead: |
| Subtotal: |
| Profit: |
| Subtotal: |
| Bond: |
| Total Contract Price: |
CLIN0002
| Project: | Well Automation | Project Engineer: | Christopher Smith | |
| Location: | Department: | 20 CES | ||
| Contractor: | Date: | 12/18/24 | ||
| Address: | Total | |||
| PR No.: |
Line No. Item Units Quantity Material Costs Labor Costs Direct Cost Line Total
| Unit Cost | Total | Labor Hours per Unit | Labor Hours | Avg. Rate ($/hr) | Total | |||
| 1 | Chem Analyzers | LS | ||||||
| 2 | Eye wash stations | EA | ||||||
| 3 | Allen Bradley VFD | EA | ||||||
| 4 | Stripper level system upgrade | EA | ||||||
| 5 | Demo | LS | ||||||
| 6 | Ultrasonic Level sensor | EA | ||||||
| 7 | Flow Meters | EA | ||||||
| 8 | PLC Programing | EA | ||||||
| 9 | PLC Automation setup Testing | EA | ||||||
| 10 | Chemical Feed Pumps | EA | ||||||
| 11 | Sample table | Ea | ||||||
| 12 | Labeling | EA | ||||||
| 13 | ||||||||
| 14 | ||||||||
| 15 | ||||||||
| 16 | ||||||||
| 17 | Superintendent | WK | ||||||
| 18 | Project Manager | WK | ||||||
| 19 | Design | EA | ||||||
| Total: |
| Total Material Cost: |
| Total Labor Cost: |
| Direct Cost: |
| Total Line Item Cost: |
| Overhead: |
| Subtotal: |
| Profit: |
| Subtotal: |
| Bond: | 2.5% |
| Total Contract Price: |
Marquee CLIN3
| Project: | ARCENT Marquee | Project Engineer: | Tony Satcher | ||
| Location: | Department: | 20 CES | |||
| Contractor: | Date: | 6/3/21 | |||
| Address: | Total | $164,881.34 | |||
| PR No.: |
Line No. Item Units Quantity Material Costs Labor Costs Direct Cost Line Total
| Unit Cost | Total | Labor Hours per Unit | Labor Cost per Unit | Labor Hours | Avg. Rate ($/hr) | Total | ||||||
| 1 | Duct | LF | 1600 | $6.00 | $9,600.00 | 0.0378 | $2.27 | 60.5 | $60.05 | $3,632.00 | $3,200.00 | $16,432.00 |
| 2 | Concrete | CY | 35 | $155.00 | $5,425.00 | 0.55 | $33.00 | 19.3 | $60.00 | $1,155.00 | $2,106.00 | $8,686.00 |
| 3 | Cable(15 kV) | LF | 2400 | $15.88 | $38,100.00 | 0.0334 | $2.01 | 80.2 | $60.18 | $4,824.00 | $42,924.00 | |
| 4 | Transformer (1 phase) including all hardware | EA | 1 | $10,850.00 | $10,850.00 | 48 | $2,400.00 | 48.0 | $50.00 | $2,400.00 | $13,250.00 | |
| 5 | Sectionalizing Cabinets | EA | 1 | $5,000.00 | $5,000.00 | 35 | $1,750.00 | 35.0 | $50.00 | $1,750.00 | $6,750.00 | |
| 6 | Mobilization/Demobilization | LS | 1 | $5,000.00 | $5,000.00 | |||||||
| 7 | Testing | LS | 1 | $7,000.00 | $7,000.00 | |||||||
| 8 | Boring | LF | 100 | $92.00 | $9,200.00 | $5,000.00 | $14,200.00 | |||||
| 9 | Superintendent | WK | 3 | 40 | $2,175.00 | 120.0 | $54.38 | $6,525.00 | $6,525.00 | |||
| 10 | Project Manager | WK | 2 | 40 | $2,325.00 | 80.0 | $58.13 | $4,650.00 | $4,650.00 | |||
| 11 | Design | EA | 1 | $7,525.02 | $7,525.02 | |||||||
| Total: | $78,175.00 | $24,936.00 | $29,831.02 | $132,942.02 |
| Total Material Cost: | $78,175.00 |
| Total Labor Cost: | $24,936.00 |
| Direct Cost: | $29,831.02 |
| Total Line Item Cost: | $132,942.02 |
| Overhead: | 10% | $13,294.20 |
| Subtotal: | $146,236.22 |
| Profit: | 10% | $14,623.62 |
| Subtotal: | $160,859.84 |
| Bond: | 2.5% | $4,021.50 |
| Total Contract Price: | $164,881.34 |
File details come from the government source that posted it. Updated .