Untabulated_COST_EST_10-1096.xls

XLS spreadsheet 67 KB Posted Jun 20, 2014

Attached to: Roads and Grounds IDIQ Base Contract Federal contract opportunity
Solicitation number: FA5685-14-R-0012
Issued by: Department of the Air Force United States Air Forces in Europe - Air Forces Africa

About this file

From the source

INC Form 1101 Untabulated COST ESTIMATE FOR 13-1096

View the file

Other files for this federal contract opportunity

Other files attached to Roads and Grounds IDIQ Base Contract, newest first.
File	Type	Posted
Q_ _A_2__for_Amd_9.docx	DOCX document	Mar 30, 2015
Q_ _A_for_Amd_9.docx	DOCX document	Mar 27, 2015
FA5685-14-R-0012-0009.doc	DOC document	Mar 26, 2015
FA5685-14-R-0012-0007.doc	DOC document	Nov 26, 2014
R-G_Bid_Sched_qty_1.xls	XLS spreadsheet	Jul 30, 2014
FA5685-14-R-0012-0006.doc	DOC document	Jul 30, 2014
FA5685-14-R-0012-0005.doc	DOC document	Jul 24, 2014
FA5685-14-R-0012-0004.doc	DOC document	Jul 23, 2014
Updated_IDIQ_Specification_22_Jul_14.pdf	PDF	Jul 22, 2014
HANDHOLE_DETAIL.PDF	PDF	Jul 21, 2014
FENCE_-1.pdf	PDF	Jul 21, 2014
warning_sign_plan.pdf	PDF	Jul 21, 2014
FENCE_-2.pdf	PDF	Jul 21, 2014
Updated_IDIQ_Specification.pdf	PDF	Jul 11, 2014
Updated_Untabulated_RoadsGrounds_IDIQ__Bid_Schedule_-With_Quantity_(2).xls	XLS spreadsheet	Jul 11, 2014
FA5685-14-R-0012-0001.doc	DOC document	Jul 11, 2014
C2.pdf	PDF	Jul 2, 2014
TITLE.pdf	PDF	Jul 2, 2014
C3.pdf	PDF	Jul 2, 2014
C1.pdf	PDF	Jul 2, 2014
C4.pdf	PDF	Jul 2, 2014
PPL_Feb_2012.xls	XLS spreadsheet	Jun 20, 2014
Geospatial_Data_Requirements_Incirlik_AB.pdf	PDF	Jun 20, 2014
FA5685-14-R-0012.doc	DOC document	Jun 20, 2014
ufc_3_270_01.pdf	PDF	Jun 20, 2014
Site_Visit_Reservation_Form.docx	DOCX document	Jun 20, 2014
Untabulated_COST_EST_10-1095.xls	XLS spreadsheet	Jun 20, 2014
Untabulated_COST_ESTIMATE_FOR_10-1099.xls	XLS spreadsheet	Jun 20, 2014
PAVEMENT_ _GROUNDS_STANDARDS.pdf	PDF	Jun 20, 2014
C3.pdf	PDF	Jun 20, 2014
C1.pdf	PDF	Jun 20, 2014
PPL_Feb_2012.xls	XLS spreadsheet	Jun 20, 2014
LJYC_13-1096__FORM_INC-1106.xls	XLS spreadsheet	Jun 20, 2014
TITLE.pdf	PDF	Jun 20, 2014
C4.pdf	PDF	Jun 20, 2014
PPL_Feb_2012.xls	XLS spreadsheet	Jun 20, 2014
ufc_3_270_01.pdf	PDF	Jun 20, 2014
Untabulated_RoadsGrounds_IDIQ__Bid_Schedule_with_quantity-.xls	XLS spreadsheet	Jun 20, 2014
TITLE.pdf	PDF	Jun 20, 2014
C2.pdf	PDF	Jun 20, 2014
SOW_LJYC_13-1096.doc	DOC document	Jun 20, 2014
C1.pdf	PDF	Jun 20, 2014
13-1095_SOW_.doc	DOC document	Jun 20, 2014
Past_Performance_Questionnaire.docx	DOCX document	Jun 20, 2014
IDIQ_Specification.pdf	PDF	Jun 20, 2014
LJYC_13-1095__FORM_INC-1106.xls	XLS spreadsheet	Jun 20, 2014
C3.pdf	PDF	Jun 20, 2014
C4.pdf	PDF	Jun 20, 2014
Site_Visit_Reservation_Form.docx	DOCX document	Apr 14, 2014
Site_Visit_Reservation_Form.docx	DOCX document	Apr 7, 2014

Show all 50

Roads and Grounds IDIQ Base Contract has more files on GovTribe.

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.

IDIQ Price

100%

FOR OFFICIAL USE ONLY

This is NOT a comprehensive cost estimation macro. The User

CONSTRUCTION COST ESTIMATE BREAKDOWN

SH: 1 OF 3

is required to do many of the revisions manually. The User

CONTRACTOR

ADDRESS:

INCIRLIK HAVA ALANI-ADANA/TURKEY

must be capable of using a spreadsheet with minimum help.

WORK LOCATION:

INCIRLIK HAVA ALANI-ADANA

CONTRACT FOR (Work to be performed)

PROPOSED TOTAL CONTRACT PRICE

The cost form is prepared for Quattro Pro version 4.0. The printer

REPAIR VARIOUS BASE ROADS

0.00

selected is Canon Laser Printer LPB-4. Hovewer, as the program's

PURCHASE REQUEST NUMBER:

PROJECT NUMBER

soft fonts are used, changing a printer should not present problems.

LJYC 13-1096

UNIT OF

TOTAL COST

It is possible that, at the first trials, problems with page fitting may

LINE

MEASURE

QUANTITY

arise. The User should experiment with the size of the first

UNIT

TOTAL

font on the font table.

ITEMS

(2)

(3)

(4)

(5)

The User is recommended to work in protected mode initially to avoid

erasing any formulas.

R E C A P I T U L A T I O N

RECAP sheet formulas and the discipline totals at the end of each

discipline need to be manually revised with every new estimate.

There are three utility macros that can be started by pressing

simultaneously, the <Alt> key and one letter (See below).

CIVIL WORKS TOTAL

$0.00

<Alt>C ....... Erases the contents of one page of cost estimate

<Alt>Z ....... Inserts a new cost estimate page

<Alt>X ....... Adds a new cost estimate page at the very end

Macros <Alt>C and <Alt>Z must be started with the cursor parked

in column A, and right below the cell containing page break, just

before the page the contents of which are to be erased, or

before the location of the new page to be inserted.

To insert new items in a page use and empty page as a holding tank

and rearrange items by copying ("copy special, contents", to avoid

disturbing the cell formats) to and from it. Do not use "move"

untill you feel comfortable with the spreadsheet.

TOTAL

$0.00

0.00

Demolish asphalt road, asphalt only

$0.00

Excavation by hand

$0.00

The form is designed using for A4 size, for 8.5"x11" minor

Unclassified excavation (Bulk), including concrete, hauling, loading and disposal w/machine

$0.00

adjusments may be required. To print on A4, set page break

options in the printer page layout to "NO".

Compaction by hand with plate or rammer compactor

$0.00

Provide & Install Graded Crush Aggregate Base Course, including loading, hauling, spread

$0.00

Provide & Install Type II Asphalt Binder Course

$0.00

The discipline totals must be centered, written in uppercase,

Provide & Install Primer Coat (MC30)

TON

$0.00

The discipline totals must be centered, written in uppercase,

Saw cut construction joints

$0.00

221

Conduct Compaction Test

$0.00

119

Provide and Apply one reactive comp.paint (KANAT PAINT , KANTEX 64710 or equal) c/w type 1glass beads, by machine

$0.00

225

Provide & Install Temporary Construction Fencing

$0.00

TOTAL

$0.00

feet - SF, linear feet - LF, board feet - BF, each - EA, pound -LB).

Col 3 Quantity. Contractor's estimate of quantity required in terms of unit of measure (column 2). Items and units of measure will be

funished by the Government. Quantity estimates will be furnished by the Government only when it is anticipated that a unit price contract will

be issued. Otherwise, the contractor is responsible for determining quantity estimates.

Col 4 and 5 Material Costs. Enter unit cost (Col 4) of material to be supplied and total cost (Col 5) for item listed in column 1.

Col 6, 7 and 8 Labor Costs. Enter in Col 6 the estimated number of manhours or mandays needed to perform the work listed in column 1.

Enter in Col 7 the average rate per manhour (manday) and in Col 8 the total labor cost.

Col 9 Other Direct Costs. Enter estimated costs of special equipment and other items (listed in column 1) which are special to the contract

and of significant dollar value.

Col 10 Line Total. Self-explanatory.

NOTE: In addition to the other totals entered on various pages, the grand total of column 10, plus overhead and profit will be shown on the last

page as follows.

TOTAL MATERIAL COSTS

N/A

-------

TOTAL LABOR COSTS

N/A

-------

TOTAL OTHER DIRECT COSTS

N/A

-------

TOTAL DIRECT COSTS

0.00

Included

-------

OVERHEAD

In Unit Price

N/A

-------

SUBTOTAL

0.00

Included

-------

PROFIT

In Unit Price

N/A

-------

TOTAL PRICE

0.00

--------

DATE :

FIRM NAME :

-------------------------------------

---------------------------------------------------

TITLE :

BY :

-----------------------------------

-------------------------------------------------------------------

REPAIR VARIOUS BASE ROADS

INSTRUCTIONS TO OFFERORS

1. The purpose of this form is to provide a standard format by which the offeror submits to the Government a summary of incurred and

estimated costs (and attached supporting information) suitable for detaied review and analysis. Prior to the award of a contract resulting from

this proposal the offeror shall, under the conditions stated in ASPR 3-807.3, be required to submit a certificate of current cost or pricing data

(see ASPR 3-807.3(e) and 3-807.4)

2. In addition to the specific information required by this form, the offeror is expected, in good faith, to incorporate in and submit with this

form any additional data, supporting schedules, or substantiation which are reasonably required for the conduct of an appropriate review and

analysis in the light of the specific facts of this procurement. For effective negotiations, it is essential that there be a clear understanding of

a. The existing, verifiable data.

b. The judgmental factors applied in projecting from known data to the estimate, and

c. The contingencies used by the offeror in his proposed price.

In short, the offeror's estimating process itself needs to be disclosed.

3. When attachment of supporting cost or pricing data to this form is impracticable, the data will be described (with schedules as appropriate),

and made available to the contracting officer or his authorized representative upon request.

4. By submission of this proposal the offeror grants to the contracting officer, or his authorized representative, the right to examine, for the

purpose of verifying the cost or pricing data submitted, those books, records, documents and other supporting data which will permit adequate

evaluation of such cost or pricing data, along with the computations and projections used herein. This right may be exercised in connection

with any negotiations prior to contract award.

(Reverse of Computer Generated AF Form 3052., AUG 93)

back

	INSTRUCTIONS FOR COMPLETING AF FORM 3052					SH: 3 OF 3
Col 1 Item. Description of materials required, work to be done, special equipment needed, etc. Breakdown should be in sufficient detail to
permit itemizing of all direct costs.
Col 2 Unit of Measure. Description of the unit in which each item is to be estimated (examples : square yards - SY, cubic yards - CY, square
feet - SF, linear feet - LF, board feet - BF, each - EA, pound -LB).
Col 3 Quantity. Contractor's estimate of quantity required in terms of unit of measure (column 2). Items and units of measure will be
funished by the Government. Quantity estimates will be furnished by the Government only when it is anticipated that a unit price contract will
be issued. Otherwise, the contractor is responsible for determining quantity estimates.
Col 4 and 5 Material Costs. Enter unit cost (Col 4) of material to be supplied and total cost (Col 5) for item listed in column 1.
Col 6, 7 and 8 Labor Costs. Enter in Col 6 the estimated number of manhours or mandays needed to perform the work listed in column 1.
Enter in Col 7 the average rate per manhour (manday) and in Col 8 the total labor cost.
Col 9 Other Direct Costs. Enter estimated costs of special equipment and other items (listed in column 1) which are special to the contract
and of significant dollar value.
Col 10 Line Total. Self-explanatory.
NOTE: In addition to the other totals entered on various pages, the grand total of column 10, plus overhead and profit will be shown on the last
page as follows.
TOTAL MATERIAL COSTS				$	N/A
					-------
TOTAL LABOR COSTS				$	N/A
					-------
TOTAL OTHER DIRECT COSTS				$	N/A
					-------
TOTAL DIRECT COSTS				$	$0.00
		Included			-------
OVERHEAD		In Unit Price		$	N/A
					-------
SUBTOTAL				$	$0.00
		Included			-------
PROFIT		In Unit Price		$	N/A
					-------
TOTAL PRICE				$	0.00
					--------
DATE :					FIRM NAME :
-------------------------------------
TITLE :					BY :
-----------------------------------
	REPAIR VARIOUS BASE ROADS
			INSTRUCTIONS TO OFFERORS
1. The purpose of this form is to provide a standard format by which the offeror submits to the Government a summary of incurred and
estimated costs (and attached supporting information) suitable for detaied review and analysis. Prior to the award of a contract resulting from
this proposal the offeror shall, under the conditions stated in ASPR 3-807.3, be required to submit a certificate of current cost or pricing data
(see ASPR 3-807.3(e) and 3-807.4)
2. In addition to the specific information required by this form, the offeror is expected, in good faith, to incorporate in and submit with this
form any additional data, supporting schedules, or substantiation which are reasonably required for the conduct of an appropriate review and
analysis in the light of the specific facts of this procurement. For effective negotiations, it is essential that there be a clear understanding of
a. The existing, verifiable data.
b. The judgmental factors applied in projecting from known data to the estimate, and
c. The contingencies used by the offeror in his proposed price.
In short, the offeror's estimating process itself needs to be disclosed.
3. When attachment of supporting cost or pricing data to this form is impracticable, the data will be described (with schedules as appropriate),
and made available to the contracting officer or his authorized representative upon request.
4. By submission of this proposal the offeror grants to the contracting officer, or his authorized representative, the right to examine, for the
purpose of verifying the cost or pricing data submitted, those books, records, documents and other supporting data which will permit adequate
evaluation of such cost or pricing data, along with the computations and projections used herein. This right may be exercised in connection
with any negotiations prior to contract award.
(Reverse of Computer Generated AF Form 3052., AUG 93)

File details come from the government source that posted it. Updated Nov 14, 2017.