Attach_9_-_Amend_0002_MU_Pavilion_Meadowood_Bid_Schedule_REV_0002.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
MULTI-USE PAVILION AT MEADOWOOD
Solicitation number
140L0621R0017
Issued by

About this file

Written by GovTribe AI ·

This document contains a bid schedule and cost calculations spreadsheet for a federal contract solicitation to construct a multi-use pavilion. The solicitation was issued by the Bureau of Land Management seeking lump sum pricing for helical piles, a metal frame building, material delivery, crane rental, and geotechnical work. The spreadsheet includes materials calculations and costs for various fencing components including barbed wire, smooth wire, posts, gates, and installation labor rates. It provides installation calculations for constructing and removing 4-wire, 3-wire, buck and pole, and top pole fencing. Labor rates are included for tasks such as installing end panels, stress panels, corner panels, gates, and cattle guards. Removal calculations are also provided for different fencing types.

View the file

Other files

File Type Posted
Sol_140L0621R0017_Amd_0003.pdf PDF
Attach_8_-_Amend_0002_140L0621R0017_-_Cont__Pages_REV1_0002.pdf PDF
Sol_140L0621R0017_Amd_0002.pdf PDF
Attach_5_-_Amend_0001_Multiuse_Pavilion_Specifications_-_REV_0001.pdf PDF
Attach_6_-_Amend_0001_Questions_Answers_0001.pdf PDF
Attach_7_-_Amend_0001_Site_visit_sign_in_sheet_0001.pdf PDF
Attach_4_-_Amend_0001_140L0621R0017_-_Cont__Pages_REV_0001.pdf PDF
Sol_140L0621R0017_Amd_0001.pdf PDF
Attach_1_-_MU_Pavilion_Meadowood_Specifications.docx DOCX document
Attach_3_-_MU_Pavilion_Meadowood_Bid_Schedule.xlsx XLSX spreadsheet
Attach_2_-_MU_Pavilion_Meadowood_Wage_Determinations.pdf PDF
Sol_140L0621R0017.pdf PDF
Show all 12

On GovTribe

Work with this file

  • 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!

Bid Schedule

UNITED STATES DEPARTMENT OF THE INTERIOR
BUREAU OF LAND MANAGEMENT
Muti Use Pavilion at Meadowood
Solicitation No.: 140L0621R0017
Bid Schedule - REV

Item No. Description Payment Amount

10Helical Piles*Lump Sum
30Metal frame BuildingLump Sum
40Delivery cost of materialsLump Sum
50Crane rentalLump Sum
80Geo TechLump Sum

Cumulative TOTAL $ - 0

Overhead$ - 0
Profit
Bonds and Insurance$ - 0
*Total Project Cost$ - 0
*52.211-18 Variation in Estimated Quantity applies to this item. The price proposed shall be incorporated into the resultant contract and will be the basis for any adjustments. Total project cost includes all applicable Federal, State and Local taxes.

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 .