Attachment A - Pricing Page.xls

XLS spreadsheet 166 KB Posted

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

About this file

This is a pricing page attachment for a West Virginia state contract opportunity for Vertical Brine Storage Tanks and Pumps, functioning as a multiple vendor award contract. The solicitation seeks bids for four primary contract items: 13 units of polyethylene vertical brine storage tanks with single wall construction and 6,100-gallon capacity; 4 units of polyethylene vertical brine storage tanks with single wall construction and 10,000-gallon capacity; 26 units of polyethylene vertical brine storage tanks with double wall construction and 6,100-gallon capacity; and 43 peristaltic pumps. Vendors may bid on any or all contract items and are required to complete the pricing pages by providing a bid price for each item they elect to bid. The estimated purchase volumes represent approximate anticipated quantities only, with no guarantee of future contract utilization implied.

The contract utilizes a lowest bid award methodology on a per-item basis for vendors meeting all mandatory requirements, with qualified responsible vendors receiving contract awards. Vendors must provide unit prices and extended totals for each contract item in their billing system's specified description. The document does not explicitly state response deadlines, due dates, site visit requirements, bidders' conferences, or contract term details. No specific information regarding pricing terms, set-asides, incumbent vendors, funding sources, or other financial requirements is provided in this pricing attachment, which functions solely as the bid submission template for interested vendors.

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 .