Attach_2_-_Breakout_Sheet.xlsm

XLSM spreadsheet 130 KB Posted

Attached to
RED HORSE BOM Federal contract opportunity
Solicitation number
FA4661-18-Q-0007
Issued by
Department of the Air Force Air Combat Command

About this file

From the source

Breakout Sheet. Please fully fill out the sheet to include the total. Please ask if you have any questions.

View the file

Other files for this federal contract opportunity

Other files attached to RED HORSE BOM, newest first.
File Type Posted
1._FA4661-18-Q-0007_-_Combo.docx DOCX document
Attach_3_-_Flexible_Base_Requirements.pdf PDF
Attach_1_-_Specifications.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.

Breakout Project Construction Materials Register

MaterialEstimate
#ShopTask IDItemQty RequiredU/IReferencePart #Estimated Unit PriceTotal Estimated Price
1AirfieldsConcrete 5000 psi, fiber reinforced - Deliver between the dates of 08 Jan 18 and 05 Feb 181250cy$ - 0
2AirfieldsFlexible base, TxDOT Grade 1/Grade 2 mix - Delivery btween the dates of 08 Jan 18 and 05 Feb 18 - Please provide gradation and proctor value reports15800ton$ - 0
3AirfieldsDowels, 1" dia x 16"1700ea$ - 0
4AirfieldsDeformed Rebar (connect to drives), No 8" x 16"80ea$ - 0
5AirfieldsWide concrete saw blades 14" x .5"5ea$ - 0
All items besides concrete, base course, and sub-base have a desired delivery of 30 Days ADC$ - 0
$ - 0
Please read attached specifications for delivery$ - 0
schedule$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Total$ - 0

Labor Rates Sheet

GradeRankLabor Rate
E-1AB$ 15.00
E-2Amn$ 15.00
E-3A1C$ 15.00
E-4SrA$ 15.00
E-5SSgt$ 15.00
E-6TSgt$ 15.00
E-7MSgt$ 15.00
E-8SMSgt$ 15.00
E-9CMSgt$ 15.00
O-12Lt$ 15.00
O-21Lt$ 15.00
O-3Capt$ 15.00
O-4Maj$ 15.00
O-5Lt Col$ 15.00
O-6Col$ 15.00
O-7Brig Gen$ 15.00
O-8Maj Gen$ 15.00
O-9Lt Gen$ 15.00
O-10Gen$ 15.00

Equip Depreciation Sheet

EQUIPMENT ITEMDEPRECIATIONFUEL COMSUMPTIONTYPE FUEL
Air Compressor, Davey$ 1.806DSL
Air Compressor, Ingersol Rand$ 2.002DSL
Air Compressor, Sullair$ 6.494DSL
Ambulance$ 7.575DSL
Asphalt Distributor$ 10.3920DSL
Backhoe$ 14.1715DSL
Backhoe, 4WD
Blazer$ 4.895DSL
Bobcat$ 6.7610Gas
Bus$ 9.668DSL
Compactor
Concrete Mobile$ 28.9915DSL
Concrete Pump$ 1.998Gas
Concrete Saw$ 2.833Gas
Concrete Screed$ 1.002Gas
Concrete Truck
Cooks Trailer (MKT)$ 3.840N/A
Crane$ 35.9920DSL
Crane, 15 Ton
Dolley$ 0.870N/A
Dozer$ 22.7220DSL
Dozer, Cat$ 47.3020DSL
Dozer, T4
Dozer, TD-15
Dozer, TD-20
Dump Truck, 10 Ton$ 11.918DSL
Dump Truck, 20 Ton$ 21.2410DSL
Excavator$ 26.3020DSL
Excavator, Rubber Tire
Forklift, 10K ATDSL
Forklift, 10K JD$ 24.1615DSL
Forklift, 13K ATDSL
Forklift, 6K Warehouse$ 6.634DSL
Forklift, Electric
Fuel Truck$ 8.665DSL
Fuel Truck, Diesel
Fuel Truck, Gas
Generator, 5KW$ 1.502Gas
Gradall$ 29.6410DSL
Grader$ 17.3915DSL
Grader, Cat
Grader, Champion$ 18.6515DSL
Grader, JD
HUMVEE
Joint Sealer$ 3.0710Gas
K-Span Machine$ 40.5515DSL
Line Truck
Loader, 2.5 CY$ 20.4815DSL
Loader, 4 CY
Loader, 5 CY
Loader, Track$ 37.6020DSL
Lube Unit, ELL$ 5.653Gas
Lube Unit, MCG$ 8.173Gas
M-35, Deuce$ 13.538DSL
Machine Shop Van$ 9.7110DSL
Maintenance Truck, M-87$ 4.488Gas
Manlift$ 17.818DSL
Milling MachineDSL
Mixer, Cement$ 2.395Gas
Mixer/Tiller$ 21.9610DSL
MKT$ 1.5010Gas
Mud Pump$ 16.958Gas
Mud Pump, MCM/PUM$ 2.628Gas
Paint Striping Machine$ 8.002Gas
Paver, Asphalt$ 32.1325DSL
Paver, Cat.$ 26.0025DSL
Pickup Truck, 3 PAX$ 4.765Gas
Pickup Truck, 6 PAX$ 7.065DSL
Pole Truck$ 40.8425DSL
Roller, Pneumatic Tire$ 11.7615DSL
Roller, Steel Wheel$ 7.5015DSL
Roller, Steel Wheel, 4 Ton
Roller, Steel Wheel, 8 Ton
Roller, Steel Wheel, 8-12 Ton
Roller, Vibratory$ 11.3315DSL
Rototiller
Scraper$ 53.9420DSL
Sweeper Truck$ 17.593DSL
Sweeper, `88 Towed$ 1.982DSL
Sweeper, Eglin
Sweeper, Farm Tractor
Sweeper, Tymco
Tar Distributor$ 11.573DSL
Tractor$ 19.479DSL
Tractor, 10 Ton
Tractor, 15 Ton
Tractor, 20 Ton
Tractor, 35 Ton$ 3.803Gas
Tractor, 50 Ton$ 5.703Gas
Tractor, 60 Ton$ 3.250Gas
Tractor, Farm$ 6.7610DSL
Trailer, 32 ft Van
Trailer, 35 Ton
Trailer, 40 ft$ 2.120N/A
Trailer, 400 Gallon Water Buffalo$ 1.160N/A
Trailer, 5 Ton Trench$ 0.610N/A
Trailer, 50 Ton
Trailer, 5000 Gallon$ 7.063DSL
Trailer, 60 Ton
Trailer, Generator$ 0.480N/A
Trailer, M-101
Trailer, M-105$ 0.510N/A
Trailer, M-200
Trailer, M-416$ 0.090N/A
Trailer, Spool (K-Span)$ 2.000N/A
Trailer, Support (K-Span)$ 1.500N/A
Trailer, Trencher
Trailer, Van$ 1.640N/A
Trailer, Welding$ 0.854DSL
Trencher$ 21.448DSL
Van, 15 Pax$ 9.715Gas
Water Pump, 90K$ 3.1315Gas
Water Truck, 1500 Gal$ 9.993DSL
Welder$ 2.895DSL
Welder, M35
Well Driller$ 169.8530DSL
Wrecker, 5 Ton (M-series)$ 44.4815DSL

BB

DAILY INSPECTION RECORDPROJECT#ERROR:#REF!
DATETIME OF INSPECTOR'S VISITS TO SITE
ARRIVALDEPARTUREARRIVALDEPARTUREARRIVALDEPARTUREARRIVALDEPARTURE

WEATHER CONDITIONS SATISFACTORY FOR WORK

WORK FORCE - CONTRACTOR AND SUB-CONTRACTOR
TRADENUMBERTRADENUMBERTRADENUMBER
MATERIALS DELIVERED TO JOB SITE
ITEMQUANTITYITEMQUANTITY
EQUIPMENT ON HAND
TYPENUMBERTYPENUMBERTYPENUMBER

WORK ACCOMPLISHED OR IN PROGRESS - TESTS PERFORMED

(Continue report on reverse)
NOTE: WRITE ALL ENTRIES LEGIBLY IN INK, LINE OUT ALL UNUSED PORTIONS, INSPECTOR SIGNS FIRST NAME, MIDDLE INITIAL AND LAST NAME ON EACH COMPLETED DAILY INSPECTION RECORDREPORT NO

YES

NO

Close and return to Blue Book Index

Gantt Calc

1ERROR:#REF!ERROR:#REF!
2ERROR:#REF!ERROR:#REF!
3ERROR:#REF!ERROR:#REF!
4ERROR:#REF!ERROR:#REF!
5ERROR:#REF!ERROR:#REF!
6ERROR:#REF!ERROR:#REF!
7ERROR:#REF!ERROR:#REF!
8ERROR:#REF!ERROR:#REF!
9ERROR:#REF!ERROR:#REF!
10ERROR:#REF!ERROR:#REF!
11ERROR:#REF!ERROR:#REF!
12ERROR:#REF!ERROR:#REF!
13ERROR:#REF!ERROR:#REF!
14ERROR:#REF!ERROR:#REF!
15ERROR:#REF!ERROR:#REF!
16ERROR:#REF!ERROR:#REF!
17ERROR:#REF!ERROR:#REF!
18ERROR:#REF!ERROR:#REF!
19ERROR:#REF!ERROR:#REF!
20ERROR:#REF!ERROR:#REF!
21ERROR:#REF!ERROR:#REF!
22ERROR:#REF!ERROR:#REF!
23ERROR:#REF!ERROR:#REF!
24ERROR:#REF!ERROR:#REF!
25ERROR:#REF!ERROR:#REF!
26ERROR:#REF!ERROR:#REF!
27ERROR:#REF!ERROR:#REF!
28ERROR:#REF!ERROR:#REF!
29ERROR:#REF!ERROR:#REF!
30ERROR:#REF!ERROR:#REF!
31ERROR:#REF!ERROR:#REF!
32ERROR:#REF!ERROR:#REF!
33ERROR:#REF!ERROR:#REF!
34ERROR:#REF!ERROR:#REF!
35ERROR:#REF!ERROR:#REF!
36ERROR:#REF!ERROR:#REF!
37ERROR:#REF!ERROR:#REF!
38ERROR:#REF!ERROR:#REF!
39ERROR:#REF!ERROR:#REF!
40ERROR:#REF!ERROR:#REF!
ERROR:#REF!

File details come from the government source that posted it.