Attach 5 - Pricing Worksheet.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
NEIBER FIRE FENCES Federal contract opportunity
Solicitation number
140L0621R0007
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 installation cost calculations for a federal solicitation to construct and remove fencing. The solicitation is for the NEIBER FIRE FENCES project issued by the Bureau of Land Management within the Department of the Interior. The pricing worksheet includes line items and estimated quantities for constructing different types of barbed wire fencing, components, gates and cattle guards as well as their removal. It also includes calculations for labor and equipment costs to install and remove the fencing based on hourly wage rates. Specific line items include over 14 miles of 4-wire barbed wire fencing, fence components like end panels and stress panels, and items like gates, cattle guards and fence removal. Installation and removal rates are provided by fence type along with labor and equipment requirements and costs.

View the file

Other files for this federal contract opportunity

Other files attached to NEIBER FIRE FENCES, newest first.
File Type Posted
Sol_140L0621R0007_Amd_0004.pdf PDF
Attach_12_-_Amend_0004_Questions_Answers_0004.pdf PDF
Attach_9_-_Amend_0003_140L0621R0007_Cont__Pages_REV_0003.pdf PDF
Sol_140L0621R0007_Amd_0003.pdf PDF
Attach_11_-_Amend_0003_Questions_Answers_0003.pdf PDF
Attach_10_-_Amend_0003_Neiber_Fire_Fence_SOW_REV_0003.pdf PDF
Sol_140L0621R0007_Amd_0002.pdf PDF
Attach 7 - Amend 0002 140L0621R0007 Cont. Pages REV_0002.pdf PDF
Attach 8 - Amend 0002 Questions_Answers_0002.pdf PDF
Sol_140L0621R0007_Amd_0001.pdf PDF
Attach 6 - Amend 0001 Questions_Answers and Attendees List_0001.pdf PDF
Attach 3 - NeiberFencesSiteVisit.pdf PDF
Attach 2 - Neiber Fire Fences Plans.pdf PDF
Attach 4 - Wage Determinations.pdf PDF
Sol_140L0621R0007.pdf PDF
Attach 1 - Neiber Fire Fences SOW.pdf PDF
Show all 16

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
NEIBER FIRE FENCES PROJECTDate:
Solicitation No.: 140L0621R0007
Pricing Worksheet
UnitMaterialInstallation
Bid ItemDescriptionQuantityCostUnitCostsCostsTotal Cost
Mobilization/Demobilization1$ - 0ea$ - 0
Fence Construction
02824(1)Barbed Wire Fence (4-Wire)147840$ - 0ft$ - 0$ - 0$ - 0
02824(2)Barbed Wire End Panel132$ - 0ea$ - 0$ - 0$ - 0
02824(3)Barbed Wire Stress Panel250$ - 0ea$ - 0$ - 0$ - 0
02824(4)Three-Post Barbed Wire Corner Panel45$ - 0ea$ - 0$ - 0$ - 0
02824(5)Barbed Wire Gate60$ - 0ea$ - 0$ - 0$ - 0
Fence Removal
02827(1)Fence Removal (4-Wire)147840$ - 0ft$ - 0$ - 0
02827(2)End Panel Removal132$ - 0ea$ - 0$ - 0
02827(3)Stress Panel Removal100$ - 0ea$ - 0$ - 0
02827(4)Three-Post Corner Panel Removal45$ - 0ea$ - 0$ - 0
02827(5)Gate Removal60$ - 0ea$ - 0$ - 0

Construction Cost Subtotal $ - 0 $ - 0 $ - 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 .