Attch_5_-_Pricing_Worksheet.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
HYATTVILLE LOGGING ROAD Federal contract opportunity
Solicitation number
140L0621R0016
Issued by
Department of the Interior Bureau of Land Management National Office

About this file

Written by GovTribe AI ·

This document contains a pricing worksheet and bid schedule for solicitation number 140L0621R0016 issued by the Bureau of Land Management for road stabilization work on the Hyattville Logging Road. The bid schedule requests pricing for seven line items including mobilization, removing existing surfaces, installing geofabric and geocells, replacing aggregate, watering, and road stabilization activities. Labor and equipment rates are provided for fence installation and removal. The document appears to be a template for contractors to provide pricing for fence construction and removal services but contains errors and does not specify the required products or services.

View the file

Other files for this federal contract opportunity

Other files attached to HYATTVILLE LOGGING ROAD, newest first.
File Type Posted
Sol_140L0621R0016_Amd_0001.pdf PDF
Attch_7_-_Amend_0001_Pricing_Worksheet_REV_0001.xlsx XLSX spreadsheet
Attch_6_-_Amend_0001_Questions_Answers__Attendees_List_0001.pdf PDF
Attch_4_-_Wage_Determinations.pdf PDF
Sol_140L0621R0016.pdf PDF
Attch_1_-_Hyattville_Logging_Road_Specifications.pdf PDF
Attch_2_-_Hyattville_Seeding_and_Reclamation_Seeding_Requirements.pdf PDF
Attch_3_-_Hyattville_Logging_Project_Location_Maps.pdf 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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Materials Calculations

Cost of 4-Wire
Fence by itselfQuantityUnit CostUnitTotal Cost
Smooth WireERROR:#REF!$60.101320' rollsERROR:#REF!
Barbed WireERROR:#REF!$66.301320'rollsERROR:#REF!
Metal PostsERROR:#REF!$6.30EAERROR:#REF!
Wood PostsERROR:#REF!$14.00EAERROR:#REF!
Misc.ERROR:#REF!$25.00Per MileERROR:#REF!
Cost Per FootERROR:#REF!
TotalERROR:#REF!
Cost of 3-Wire
Fence by itselfQuantityUnit CostUnitTotal Cost
Smooth WireERROR:#REF!$60.101320' rollsERROR:#REF!
Barbed WireERROR:#REF!$66.301320'rollsERROR:#REF!
Metal PostsERROR:#REF!$6.30EAERROR:#REF!
Wood PostsERROR:#REF!$14.00EAERROR:#REF!
Misc.ERROR:#REF!$25.00Per MileERROR:#REF!
Cost Per FootERROR:#REF!
Cost of Wire Components
ComponentsQuantitySmooth Wire6" Post4"PostCost
Stress PanelERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Corner Panel (Three Post)QuantitySmooth Wire6" Post4"Post
ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
End Panel (Type II)QuantitySmooth Wire6" Post4"Post
ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Wire GateBarbed WireGate Openers4"Post
ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Cost of Buck and PoleQuantityUnit CostUnitTotal Cost
BucksERROR:#REF!$ 13.00EachERROR:#REF!
PolesERROR:#REF!$ 11.85EachERROR:#REF!
Smooth WireERROR:#REF!$ 60.101320' rollsERROR:#REF!
Misc (nails, lag screws, etc.)ERROR:#REF!$ 1,787.66per mileERROR:#REF!
Cost Per FootERROR:#REF!
Cost of Pole TopQuantityUnit CostUnitTotal Cost
Wood Post 6"ERROR:#REF!$ 16.40EachERROR:#REF!
Pole TopERROR:#REF!$ 18.0012 SticksERROR:#REF!
Barbed WireERROR:#REF!$ 66.301320' rollsERROR:#REF!
Smooth WireERROR:#REF!$ 60.101320' rollsERROR:#REF!
Misc.ERROR:#REF!$ 383.07per mileERROR:#REF!
Cost per FootERROR:#REF!
Final Totals
DescriptionFenceComponentsTotalUnitCost EATotal Cost
Barbed WireERROR:#REF!ERROR:#REF!ERROR:#REF!1320' rolls$ 66.30ERROR:#REF!Udated
Smooth WireERROR:#REF!ERROR:#REF!ERROR:#REF!1320' rolls$ 60.10ERROR:#REF!Udated
Steel Tublular Post 6"ERROR:#REF!ERROR:#REF!ERROR:#REF!each$ 16.40ERROR:#REF!Udated
Steel Tubular Post 4"ERROR:#REF!ERROR:#REF!each$ 14.52ERROR:#REF!Udated
Gate OpenerERROR:#REF!ERROR:#REF!each$ 16.35ERROR:#REF!
Metal GateERROR:#REF!ERROR:#REF!each$ 259.99ERROR:#REF!Udated
Misc. (nails, staples, stakes) (Wire)ERROR:#REF!per mile$ 25.00ERROR:#REF!Udated
Cattle GuardERROR:#REF!ERROR:#REF!each$ 4,500.00ERROR:#REF!
Metal Line Fence PostERROR:#REF!each$ 6.30ERROR:#REF!Udated
Steel Tubular Line Post 2 3/8" X 6.5'ERROR:#REF!each$ 14.00ERROR:#REF!
Bucks (for Buck & Pole)ERROR:#REF!Buck$ 13.00ERROR:#REF!
Poles (for Buck & Pole)ERROR:#REF!16' Poles$ 11.85ERROR:#REF!
Misc. (nails, lag screws, ect.) (B&P)ERROR:#REF!per mile$ 1,787.66ERROR:#REF!
Pole TopERROR:#REF!12 sticks$ 18.00ERROR:#REF!
Misc. (nails, staples, stakes) (Pole Top)ERROR:#REF!per mile$ 383.07ERROR:#REF!
Sub TotalERROR:#REF!
Multiplied by 10%ERROR:#REF!
Total CostERROR:#REF!

Pricing Worksheet

UNITED STATES DEPARTMENT OF THE INTERIOR
BUREAU OF LAND MANAGEMENTBLM - WY WORLAND FIELD OFFICE
Hyattville Logging Road Grinding Out CropDate:
Solicitation No.: 140L0621R0016
Pricing Worksheet/Bid Schedule
Est.Unit
Bid Item No.DescriptionQuantityUnitCostTotal Cost
1Mobilization/Demobilization1LS$ - 0$ - 0
$ - 0
2Restablish Native Surface w/ six (6) inch depth, maximum size 1-1/2 inches, width 24 feet5MI$ - 0$ - 0
3Remove existing Sandy Soil Surface504CY$ - 0$ - 0
4Installation of Geo-Fabric20400SY$ - 0$ - 0
5Installation of Geo-Cell20400SF$ - 0$ - 0
6Replace Aggregate over Geo-Cell504SY$ - 0$ - 0
7Watering400MGAL$ - 0
$ - 0
8Road Stabilization$ - 0
Reshaping5MI$ - 0$ - 0
Compacting5MI$ - 0$ - 0
Rolling5MI$ - 0$ - 0
Chemical Permazyme5MI$ - 0$ - 0

Construction Cost Subtotal $ - 0

Overhead$ - 0
Profit$ - 0

Contractor Fees Subtotal $ - 0

Bonds and Insurance $ - 0

Total Project Cost $ - 0

Install Cost Calculations

Construct Fence
Labor for 4-Wire FenceAssumptions
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal132 ft/hrto build 4-wire fence
Labor5Fence Erectors$ 22.62$ 180.96$ 113.10ERROR:#REF!ERROR:#REF!139 ft/hrto build 3-wire fence
Cost Per FootERROR:#REF!77ft/hrto build buck and pole
Total CostERROR:#REF!96ft/hrto build pole top
1.5 hrto build end panel
Labor for 3-Wire1 hrto build stress panel
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal1.5 hrto build corner panel
Labor5Fence Erectors$ 22.62$ 180.96$ 113.10ERROR:#REF!ERROR:#REF!1 hrto build wire gate
Cost Per FootERROR:#REF!3 hrto install metal gate
Total CostERROR:#REF!8 hrto install cattle guard
Labor for Buck and Pole140 ft/hrto remove 4-wire
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal145 ft/hrto remove 3-wire
Labor5Fence Erectors$ 22.62$ 180.96$ 113.10ERROR:#REF!ERROR:#REF!86 ft/hrto remove buck and pole
Cost Per FootERROR:#REF!100 ft/hrto remove pole top
Total CostERROR:#REF!.75 hrto remove end panel
.75 hrto remove stress panel
Labor for Top Pole.75 hrto remove corner panel
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal.75 hrto remove wire gate
Labor5Fence Erectors$ 22.62$ 180.96$ 113.10ERROR:#REF!ERROR:#REF!
1Equip. Oper.$ 34.78$ 278.24$ 34.78ERROR:#REF!ERROR:#REF!
Equipment1Skidsteer$ 37.00$ 296.00$ 37.00ERROR:#REF!ERROR:#REF!DescriptionHr Rate
Cost Per FootERROR:#REF!LaborFence Erectors$ 22.62bls.gov
Total CostERROR:#REF!Laborer (Gen)$ 28.00bls.gov
Foreman$ 45.28bls.gov
Labor for End PanelEquip. Oper.$ 34.78bls.gov
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotalTruck Driver$ 28.10bls.gov
Labor3Fence Erectors$ 22.62$ 180.96$ 67.86ERROR:#REF!ERROR:#REF!EquipmentForklift$ 38.29
Total CostERROR:#REF!Backhoe$ 43.00
Skidsteer$ 37.00
Labor for Stress Panel
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotalSuperintendent Costs
Labor3Fence Erectors$ 22.62$ 180.96$ 67.86ERROR:#REF!ERROR:#REF!RateHoursTotal
Total CostERROR:#REF!$ 45.28ERROR:#REF!

Joshua Trickey: Joshua Trickey:

Also equal to the total project time

ERROR:#REF!
Labor for Corner Panel
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor3Fence Erectors$ 22.62$ 180.96$ 67.86ERROR:#REF!ERROR:#REF!
Total CostERROR:#REF!
Labor for Wire Gate
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor3Fence Erectors$ 22.62$ 180.96$ 67.86ERROR:#REF!ERROR:#REF!
Total CostERROR:#REF!
Labor for Metal Gate
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor3Fence Erectors$ 22.62$ 180.96$ 67.86ERROR:#REF!ERROR:#REF!
Total CostERROR:#REF!
Labor for Cattle Guard
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor2Laborer (Gen)$ 28.00$ 224.00$ 56.00ERROR:#REF!ERROR:#REF!
1Equip. Oper.$ 34.78$ 278.24$ 34.78ERROR:#REF!ERROR:#REF!
Equipment1Backhoe$ 43.00$ 344.00$ 43.00ERROR:#REF!ERROR:#REF!
Total CostERROR:#REF!
Other
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor0Fence Erectors$ 22.62$ 180.96$ - 0ERROR:#REF!ERROR:#REF!
0Laborer (Gen)$ 28.00$ 224.00$ - 00.00$ - 0
0Foreman$ 45.28$ 362.24$ - 00.00$ - 0
0Equip. Oper.$ 34.78$ 278.24$ - 00.00$ - 0
0Truck Driver$ 28.10$ 224.80$ - 00.00$ - 0
Equipment0Forklift$ 38.29$ 306.32$ - 00.00$ - 0
0Backhoe$ 43.00$ 344.00$ - 00.00$ - 0
0Skidsteer$ 37.00$ 296.00$ - 00.00$ - 0
Total CostERROR:#REF!
Removal
Labor for 4-Wire Fence
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor5Fence Erectors$ 22.62$ 180.96$ 113.10ERROR:#REF!ERROR:#REF!
Cost Per FootERROR:#REF!
Total CostERROR:#REF!
Labor for 3-Wire
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor5Fence Erectors$ 22.62$ 180.96$ 113.10ERROR:#REF!ERROR:#REF!
Cost Per FootERROR:#REF!
Total CostERROR:#REF!
Labor for Buck and Pole
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor5Fence Erectors$ 22.62$ 180.96$ 113.10ERROR:#REF!ERROR:#REF!
Cost Per FootERROR:#REF!
Total CostERROR:#REF!
Labor for Top Pole
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor5Fence Erectors$ 22.62$ 180.96$ 113.10ERROR:#REF!ERROR:#REF!
1Equip. Oper.$ 34.78$ 278.24$ 34.78ERROR:#REF!ERROR:#REF!
Equipment1Skidsteer$ 37.00$ 296.00$ 37.00ERROR:#REF!ERROR:#REF!
Cost Per FootERROR:#REF!
Total CostERROR:#REF!
Labor for End Panel
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor3Fence Erectors$ 22.62$ 180.96$ 67.86ERROR:#REF!ERROR:#REF!
Total CostERROR:#REF!
Labor for Stress Panel
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor3Fence Erectors$ 22.62$ 180.96$ 67.86ERROR:#REF!ERROR:#REF!
Total CostERROR:#REF!
Labor for Corner Panel
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor3Fence Erectors$ 22.62$ 180.96$ 67.86ERROR:#REF!ERROR:#REF!
Total CostERROR:#REF!
Labor for Wire Gate
Qty.DescriptionHourly RateDaily RateCost/Labor Hr.Hours of LaborTotal
Labor3Fence Erectors$ 22.62$ 180.96$ 67.86ERROR:#REF!ERROR:#REF!
Total CostERROR:#REF!

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