Attachment A - Pricing Page.xls

XLS spreadsheet 166 KB Posted

Attached to
Vertical Brine Storage Tanks and Pumps
Solicitation number
CRFQ 0803 DOT2700000003 2
Issued by
Kanawha County, West Virginia

About this file

This is a pricing page attachment for a West Virginia state and local contract opportunity for Vertical Brine Storage Tanks and Pumps. The contract involves the procurement of four main product categories: Polyethylene Vertical Brine Storage Tanks (Single Wall 6,100 gallons with an estimated quantity of 13 units), Polyethylene Vertical Brine Storage Tanks (Single Wall 10,000 gallons with an estimated quantity of 4 units), Polyethylene Vertical Brine Storage Tanks (Double Wall 6,100 gallons with an estimated quantity of 26 units), and Peristaltic Pumps (estimated quantity of 43 units). This is designated as a multiple vendor award contract, meaning qualified responsible vendors meeting all mandatory requirements will be awarded contracts for the lowest bid price per contract item. Vendors may choose to bid on any or all contract items, and the estimated purchase volumes represent approximate anticipated volumes only with no guarantee of future contract use implied.

The pricing page requires vendors to complete bid pricing for each contract item they choose to bid, with pricing submitted on a per-unit basis. The document also contains additional pricing information for large crane rental and lease services with operators, including weekly and monthly rental rate options from multiple vendors (Vendor Red, Vendor Green, and Vendor Blue) with varying hourly rates for regular hours, idle machinery rental hours, and overtime hours, along with assembly, disassembly, and mileage fees. The estimated purchase volumes for brine storage tanks and pumps are approximate only, with no future use guaranteed.

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

Att A

Vendor Instructions: Vendor shall complete the Pricing Pages by providing a bid price for each Contract Item bid. Vendor may bid any or all Contract items. This is a multiple vendor award Contract. Qualified responsible vendors shall be awarded a Contract for the lowest bid price, per Contract item, which meet all mandatory requirements of this Contract. The estimated purchase volume for each item represents the approximate volume of anticipated purchases only. No future use of the Contract or any individual item is guaranteed or implied.
Vendor Name:
#Est. Qty.Contract Item DiscriptionDescription in Vendors Billing SystemUnit of MeasureBid Price (Each)Extended Total
113Polyethylene Vertical Brine Storage Tank, Single Wall 6,100 GallonsEA$$
24Polyethylene Vertical Brine Storage Tank, Single Wall 10,000 GallonsEA$$
326Polyethylene Vertical Brine Storage Tank, Double Wall 6,100 GallonsEA$$
443Peristaltic PumpEA$$

&C&"Arial,Bold"Vertical Brine Storage Tanks and Pumps Pricing Pages, Attachment A, (ATT A) &L&"Arial,Bold"Pricing Pages, Attachment A, ("ATT A")&C&"Arial,Bold"Page 1 of 1 &R&"Arial,Bold"6627C005

Fig 6.2-1 Incomplete

ARQM DOT----------------
Lease/Rental PeriodIdle Machinery Rental PeriodMileageTotal
(based on 10 hr day)(based on 7 hr day)(To & From)Cost Per Vendor
FeeFee
Crane DescriptionManufacturer's NameModel/Serial #$ /Day x 6 days$ /Day x 6 days$/ Mile (10 miles)
ALL-TERRAIN CRANE 170 - 200 T
ALL-TERRAIN CRANE 200 - 250 T
ALL-TERRAIN CRANE 250 - 300 T
ALL-TERRAIN CRANE 300-350 T
ALL-TERRAIN CRANE 350 - 400 T
ALL-TERRAIN CRANE 400 - 450 T
ALL-TERRAIN CRANE 450 T or Greater
CONVENTIONAL TRUCK CRANE 170-200 T
CONVENTIONAL TRUCK CRANE 200 T or Greater
CRAWLER CRANE 170 - 200 T
CRAWLER CRANE 200 - 250 T
CRAWLER CRANE 250 - 300 T
CRAWLER CRANE 300-350 T
CRAWLER CRANE 350 - 400 T
CRAWLER CRANE 400 - 450 T
CRAWLER CRANE 450 T or Greater
ALL-TERRAIN CRANE 200 - 250 TVendor Red$12,500.00$5,000.00$0.00$200.00$17,700.00
Vendor Green$12,650.00$3,200.00$3,200.00$240.00$19,290.00
Vendor Blue$16,250.00$1,800.00$1,800.00$400.00$20,250.00
GANTRY CRANE SYSTEM 200 - 500 T
Hydraulic
GANTRY CRANE SYSTEM 500 T or Greater
Hydraulic
Specialized RiggingLarge Crane Offered for Lease/RentalMaximumBoom Type:Main BoomMax Tip HeightLift WeightLift RadiusLease/Rental Rate ofLarge CraneLarge CraneMilage
EquipmentWith OperatorCapacityTelescopic (T) /LengthLarge Crane with OperatorAssemblyDisassembly(To & From)
in TonsLattice (L)FeeFee
Specify EquipmentManufacturer's NameModel/Serial #$ /Day$/ Mile
Special Site Preparation for Large Crane Assembly
Specify Type of Prep Work$ /Hour
Lease/Rental Rate of
Large Crane With Operator

&C&"Arial,Bold"&22 Large Crane Rental/Lease WITH Operator

Fig 6.2-3 Weekly

Vendor REDVendor GREENVendor BLUE
Assembly$5,000.00$3,200.00$1,800.00
Week 1 Rental/Lease Rate
Regular hours36 Weekly Rental Hours

Weekly Hourly Rate: $10,000/week ÷ 50 hrs = $200/HR $200/HR x 36 hrs = $7200.00 36 Weekly Rental Hours Weekly Hourly Rate: $9,900/week ÷ 50 hrs = $198/HR $198/HR x 36 hrs = $7,128.00 36 Weekly Rental Hours Weekly Hourly Rate: $13,000/week ÷ 50 hrs = $260/HR $260/HR x 36 hrs = $9,360.00 Week 1 Idle Machiner Rental Rate 14 Idle Machinery Rental Hours Weekly Idle Hourly Rate: $3,500/week ÷ 49 hrs (in one idle week) = $71.43/HR $71.43/HR x 14 hrs = $1,000.02 14 Idle Machinery Rental Hours Weekly Idle Hourly Rate: $3,465/week ÷ 49 hrs (in one idle week) = $70.71/HR $70.71/HR x 14 hrs = $989.94 14 Idle Machinery Rental Hours Weekly Idle Hourly Rate: $5,200/week ÷ 49 hrs (in one idle week) = $106.12/HR $106.12/HR x 14 hrs = $1,485.68

Week 1 Rental/Lease Rate
Overtime Hours18 Weekly Overtime Hours

Weekly Hourly Rate: $10,000/week ÷ 50 hrs = $200/HR Overtime Hourly Rate: $200/hr x 30% OT rate = $260/HR $260/HR x 18 HRS = $4,680.00 18 Weekly Overtime Hours Weekly Hourly Rate: $9,900/week ÷ 50 hrs = $198/HR Overtime Hourly Rate: $198/hr x 30% OT rate = $257.40/HR $257.40/HR x 18/HRS = $4,633.20 18 Weekly Overtime Hours Weekly Hourly Rate: $13,000/week ÷ 50 hrs = $260 HR Overtime Hourly Rate: $260/hr x 30% OT rate = $338/HR $338 HR x 18 HRS = $6,084.00

Week 2 Rental/Lease Rate
Regular hours29 Weekly Rental Hours

Weekly Hourly Rate: $10,000/week ÷ 50 hrs = $200/HR $200/HR x 29 hrs = $5,800.00 29 Weekly Rental Hours Weekly Hourly Rate: $9,900/week ÷ 50 hrs = $198/HR $198/HR x 29 hrs = $5,742.00 29 Weekly Rental Hours Weekly Hourly Rate: $13,000/week ÷ 50 hrs = $260/HR $260/HR x 29 hrs = $7,540.00 Week 2 Idle Machiner Rental Rate 21 Idle Rental Hours Weekly Idle Hourly Rate: $3,500/week ÷ 49 hrs (in one idle week) = $71.43/HR $71.42/HR x 21 hrs = 1,499.82 21 Idle Machinery Rental Hours Weekly Idle Hourly Rate: $3,465/week ÷ 49 hrs (in one idle week) = $70.71/HR $70.71/HR x 21 hrs = $1,484.91 21 Idle Machinery Rental Hours Weekly Idle Hourly Rate: $5,200/week ÷ 49 hrs (in one idle week) = $106.12/HR $106.12/HR x 21 hrs = $2,228.52

Week 2 Rental/Lease Rate
Overtime Hours11 Weekly Overtime Hours

Weekly Hourly Rate: $10,000/week ÷ 50 hrs = $200/HR Overtime Hourly Rate: $200/hr x 30% OT rate = $260/HR $260/HR x 11 HRS = $2,860.00 11 Weekly Overtime Hours Weekly Hourly Rate: $9,900/week ÷ 50 hrs = $198/HR Overtime Hourly Rate: $198/hr x 30% OT rate = $257.40/HR $257.40/HR x 11/HRS = $2,831.40 11 Weekly Overtime Hours Weekly Hourly Rate: $13,000/week ÷ 50 hrs = $260 HR Overtime Hourly Rate: $260/hr x 30% OT rate = $338/HR $338/HR x 11/HRS = $3,718.00

Mileage (roundtrip)$200.00$240.00$400.00
Disassembly$500.00$3,200.00$1,800.00
TOTALS:$28,739.84$29,449.45$34,416.20

&C&"Arial,Bold"&22 Large Crane Rental/Lease WITH Operator Low Bidder

Fig 6.2-4 Monthly

Vendor REDVendor GREENVendor BLUE
Assembly$5,000.00$3,200.00$1,800.00
Rental/Lease Rate Combined Regular hours
Week 1 (36) + Week 2 (29)65 Monthly Rental Hours (Weeks 1 & 2 combined)

Monthly Hourly Rate: $36,080/Month ÷ 212 hrs = $170.19/HR $170.19/HR x 65 hrs = $11,062.35 65 Monthly Rental Hours (Weeks 1 & 2 combined) Monthly Hourly Rate: $36,000/Month ÷ 212 hrs = $169.81/HR $169.81/HR x 65 hrs = $11,037.65 65 Monthly Rental Hours (Weeks 1 & 2 combined) Monthly Hourly Rate: $41,700/Month ÷ 212 hrs = $196.70/HR $196.70/HR x 65 hrs = $12,785.50

Idle Machiner Rental Rate Combined
Week 1 (14) + Week 2 (21)35 Idle Machinery Rental Hours (Combined)

Monthly Idle Hourly Rate: $21,648 Month ÷ 212 hrs = $102.11/HR $102.11/HR x 35 hrs = $3,573.85 35 Idle Machinery Rental Hours (Combined) Monthly Idle Hourly Rate: $21,600/Month ÷ 212 hrs = $101.89/HR $101.89/HR x 35 hrs = $3,566.15 35 Idle Machinery Rental Hours (Combined) Monthly Idle Hourly Rate: $22,935/Month ÷ 212 hrs = $108.18/HR $108.18/HR x 35 hrs = $3,786.30

Overtime Rate Combined
Week1 (18) + Week 2 (11)29 Monthly Overtime Hours (Combined/Each @ Weekly Rate)

Monthly Hourly Rate: $36,080/Month ÷ 212 hrs = $170.19/HR Overtime Hourly Rate: $170.19/hr x 30% OT rate = $221.25/HR $221.25/HR x 29 HRS = $6,416.25 29 Monthly Overtime Hours (Combined/Each @ Weekly Rate) Monthly Hourly Rate: $36,000/Month ÷ 212 hrs = $169.81/HR Overtime Hourly Rate: $169.81/hr x 30% OT rate = $220.75/HR $220.75/HR x 29/HRS = $6,401.75 29 Monthly Overtime Hours (Combined/Each @ Weekly Rate) Monthly Hourly Rate: $41,700/Month ÷ 212 hrs = $196.70/HR Overtime Hourly Rate: $196.70/hr x 30% OT rate = $255.71 HR $255.71 HR x 29 HRS = $7,415.59

Week 2 Rental/Lease Rate
Regular hours (50)29 Monthly Rental Hours

Monthly Hourly Rate: $10,000/Month ÷ 50 hrs = $200/HR $200/HR x 29 hrs = $5,800.00 29 Monthly Rental Hours Monthly Hourly Rate: $9,900/Month ÷ 50 hrs = $198/HR $198/HR x 29 hrs = $5,742.00 29 Monthly Rental Hours Monthly Hourly Rate: $13,000/Month ÷ 50 hrs = $260/HR $260/HR x 29 hrs = $7,540.00 Week 2 Idle Machiner Rental Rate 21 Idle Rental Hours Monthly Idle Hourly Rate: $3,500/Month ÷ 49 hrs (in one idle Month) = $71.43/HR $71.42/HR x 21 hrs = 1,499.82 21 Idle Machinery Rental Hours Monthly Idle Hourly Rate: $3,465/Month ÷ 49 hrs (in one idle Month) = $70.71/HR $70.71/HR x 21 hrs = $1,484.91 21 Idle Machinery Rental Hours Monthly Idle Hourly Rate: $5,200/Month ÷ 49 hrs (in one idle Month) = $106.12/HR $106.12/HR x 21 hrs = $2,228.52

Week 2 Rental/Lease Rate
Overtime Hours (18)11 Monthly Overtime Hours

Monthly Hourly Rate: $10,000/Month ÷ 50 hrs = $200/HR Overtime Hourly Rate: $200/hr x 30% OT rate = $260/HR $260/HR x 11 HRS = $2,860.00 29 Monthly Overtime Hours Monthly Hourly Rate: $9,900/Month ÷ 50 hrs = $198/HR Overtime Hourly Rate: $198/hr x 30% OT rate = $257.40/HR $257.40/HR x 29/HRS = $2,831.40 29 Monthly Overtime Hours Monthly Hourly Rate: $13,000/Month ÷ 50 hrs = $260 HR Overtime Hourly Rate: $260/hr x 30% OT rate = $338/HR $338/HR x 29/HRS = $3,718.00

Mileage (roundtrip)$200.00$240.00$400.00
Disassembly$500.00$3,200.00$1,800.00
TOTALS:$26,752.45$27,645.55$27,987.39

&C&"Arial,Bold"&22 Large Crane Rental/Lease WITH Operator Low Bidder

Fig 6.2-3 Schedule

File details come from the government source that posted it. Updated .