TEP Worksheet.xls

XLS spreadsheet 453 KB Posted

Attached to
Hill AFB - Simplified Acquisition of Base Engineering Requirements (SABER)
Solicitation number
FA8201-10-R-0025
Issued by

About this file

TEP Worksheet

View the file

Other files

File Type Posted
Q A_Solicitation_7.xls XLS spreadsheet
Q A_Solicitation_6.xls XLS spreadsheet
Q A_Solicitation_5.xls XLS spreadsheet
Q A_Solicitation_4.xls XLS spreadsheet
Q A_Solicitation_2.xls XLS spreadsheet
AMEND_1_Solicitation.pdf PDF
REV_1_SABER_Section L.pdf PDF
REV_1_SAMPLE_TASK_SOW.pdf PDF
Q A_Solicitation.xls XLS spreadsheet
Request for Proposal_SABER.pdf PDF
Statement of Work.pdf PDF
Bldg 214 Old Tire Shop layout 1-Ansi.pdf PDF
SABER_SECTION M.pdf PDF
Tab K.pdf PDF
Section 1000.pdf PDF
214 Power Station.pdf PDF
Bldg 214 New Layout - People.pdf PDF
BASE FACILITY DESIGN STANDARD.pdf PDF
Lead Based Paint —
B 214 Floor plans-1st floor Existing.pdf PDF
CDRLs_SABER.pdf PDF
SAMPLE TASK SOW.pdf PDF
FIRE PREV GUIDE-HILL AFB.pdf PDF
B 214 Comm Layout.pdf PDF
SABER_Section L.pdf PDF
Wage Determinations.pdf PDF
Asebestos Inspection Report.pdf PDF
Bldg 214 - New Layout.pdf PDF
Existing Offices-South Hall.pdf PDF
Consolidated Tire-Bearing Shop As Built drawings.pdf PDF
QAs_Site_Visit_Final.xls XLS spreadsheet
Asbestos Inspection Report.pdf PDF
Lead Based Paint —
Site Walk Attendance Form.pdf PDF
DRAFT_SAMPLE TASK_SOW_2.doc DOC document
SABER Site Visit RSVP.doc DOC document
SABER_DRAFT_SAMPLE TASK_SOW.doc DOC document
DRAFT_SABER_SOW.doc DOC document
DRAFT_SABER_Section L.doc DOC document
DRAFT_SABER_SECTION M.doc DOC document
Industry Day_Slides.ppt PPT presentation
Industry Day_Answers.docx DOCX document
Attendance_Industry_Day.pdf PDF
Statement Of Work.SABER First Draft 2010.doc DOC document
Show all 44

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Summary

TEP WORKSHEET
PROJECT TITLE & BLDG NUMBER
WORKSHEET INSTRUCTIONS:
CONSTRUCTION DIVISIONTOTAL COST
Division 1 - General RequirementsConstruction divisions shall include all applicable direct and indirect costs (OH, G & A, etc) and profit. If a construction division is not applicable to a contractor's design, designate "N/A" within the Total Cost field. The TEP field will populate automatically and does not require an entry.
Division 2 - Existing Conditions
Division 3 - Concrete
Division 4 - Masonry
Division 5 - Metals
Division 6 - Wood, Plastics & Composites
Division 7 - Thermal and Moisture Protection
Division 8 - Openings
Division 9 - Finishes
Division 10 - Specialties
Division 11 - Equipment
Division 12 - Furnishings
Division 13 - Special Construction
Division 14 - Conveying Systems
Division 21 - Fire Suppression
Division 22 - Plumbing
Division 23 - HVAC
Division 26 - Electrical
Division 27 - Communications
Division 28 - Electronic Safety & Security
Division 31 - Earthwork
Division 32 - Exterior Improvements
Division 33 - Utilities
Division 34 - Transportation
Division 35 - Waterway & Marine Const.
Division 41 - Material Handling & Processing
Division 44 - Pollution Control Equipment
TOTAL EVALUATED PRICE (TEP)$0
OFFEROR'S SIGNATURE BLOCK
OFFEROR'S SIGNATUREDATE
OFFEROR'S TITLEFIRM'S NAME

&C* * * For Official Use Only * * * &LAF Form 3052 - &A&C* * * For Official Use Only * * *&RPage &P of &N

Line Items

DETAIL COST ESTIMATEBLDG NO.W.O. NO.PROJECT NO.CONTRACT NO.Division 1Division 2Division 3Division 4Division 5Division 6Division 7Division 8Division 9Division 10Division 11Division 12Division 13Division 14Division 15Division 16Dummy
000012345678910111213141516
PROJECT TITLE/SUBTITLECONTRACTORGOVERNMENT ESTIMATORDATE
00031-Dec-99
DIVISIONCSIUNIT VALUESUNITLINEMat TotalLabor Total
NumberLINE ITEM DESCRIPTIONQTYUNITSMAT'LLABOREQUIPOTHERTOTALTOTAL0000000000000000
1General Requirements000000000000000000.00
1$0.00$0$0$0.00$0.00000000000000000000.00
1$0.00$0$0$0.00$0.00000000000000000000.00
1$0.00$0$0$0.00$0.00000000000000000000.00
1$0.00$0$0$0.00$0.00000000000000000000.00
1$0.00$0$0$0.00$0.00000000000000000000.00
1$0.00$0$0$0.00$0.00000000000000000000.00
1$0.00$0$0$0.00$0.00000000000000000000.00
1$0.00$0$0$0.00$0.00000000000000000000.00
2Existing Conditions$0.00$0.00000000000000000000.00
2$0.00$0$0$0.00$0.00000000000000000000.00
2$0.00$0$0$0.00$0.00000000000000000000.00
2$0.00$0$0$0.00$0.00000000000000000000.00
2$0.00$0$0$0.00$0.00000000000000000000.00
2$0.00$0$0$0.00$0.00000000000000000000.00
2$0.00$0$0$0.00$0.00000000000000000000.00
2$0.00$0$0$0.00$0.00000000000000000000.00
2$0.00$0$0$0.00$0.00000000000000000000.00
3Concrete$0.00$0.00000000000000000000.00
3$0.00$0$0$0.00$0.00000000000000000000.00
3$0.00$0$0$0.00$0.00000000000000000000.00
3$0.00$0$0$0.00$0.00000000000000000000.00
3$0.00$0$0$0.00$0.00
3$0.00$0$0$0.00$0.00000000000000000000.00
3$0.00$0$0$0.00$0.00000000000000000000.00
3$0.00$0$0$0.00$0.00000000000000000000.00
3$0.00$0$0$0.00$0.00000000000000000000.00
4Masonry$0.00$0.00000000000000000000.00
4$0.00$0$0$0.00$0.00000000000000000000.00
4$0.00$0$0$0.00$0.00000000000000000000.00
4$0.00$0$0$0.00$0.00000000000000000000.00
4$0.00$0$0`$0.00$0.00000000000000000000.00
4$0.00$0$0$0.00$0.00000000000000000000.00
4$0.00$0$0$0.00$0.00000000000000000000.00
4$0.00$0$0$0.00$0.00000000000000000000.00
4$0.00$0$0$0.00$0.00000000000000000000.00
5Metals$0.00$0.00000000000000000000.00
5$0.00$0$0$0.00$0.00000000000000000000.00
5$0.00$0$0$0.00$0.00000000000000000000.00
5$0.00$0$0$0.00$0.00000000000000000000.00
5$0.00$0$0$0.00$0.00000000000000000000.00
5$0.00$0$0$0.00$0.00000000000000000000.00
5$0.00$0$0$0.00$0.00000000000000000000.00
5$0.00$0$0$0.00$0.00000000000000000000.00
5$0.00$0$0$0.00$0.00000000000000000000.00
6Wood, Plastics & Components$0.00$0.00000000000000000000.00
6$0.00$0$0$0.00$0.00000000000000000000.00
6$0.00$0$0$0.00$0.00000000000000000000.00
6$0.00$0$0$0.00$0.00000000000000000000.00
6$0.00$0$0$0.00$0.00000000000000000000.00
6$0.00$0$0$0.00$0.00000000000000000000.00
6$0.00$0$0$0.00$0.00000000000000000000.00
6$0.00$0$0$0.00$0.00000000000000000000.00
6$0.00$0$0$0.00$0.00000000000000000000.00
7Thermal and Moisture Protection$0.00$0.00000000000000000000.00
7$0.00$0$0$0.00$0.00000000000000000000.00
7$0.00$0$0$0.00$0.00000000000000000000.00
7$0.00$0$0$0.00$0.00000000000000000000.00
7$0.00$0$0$0.00$0.00000000000000000000.00
7$0.00$0$0$0.00$0.00000000000000000000.00
7$0.00$0$0$0.00$0.00000000000000000000.00
7$0.00$0$0$0.00$0.00000000000000000000.00
7$0.00$0$0$0.00$0.00000000000000000000.00
8Openings$0.00$0.00000000000000000000.00
8$0.00$0$0$0.00$0.00000000000000000000.00
8$0.00$0$0$0.00$0.00000000000000000000.00
8$0.00$0$0$0.00$0.00000000000000000000.00
8$0.00$0$0$0.00$0.00000000000000000000.00
8$0.00$0$0$0.00$0.00000000000000000000.00
8$0.00$0$0$0.00$0.00000000000000000000.00
8$0.00$0$0$0.00$0.00
8$0.00$0$0$0.00$0.00
8$0.00$0$0$0.00$0.00
8$0.00$0$0$0.00$0.00
8$0.00$0$0$0.00$0.00000000000000000000.00
8$0.00$0$0$0.00$0.00000000000000000000.00
9Finishes$0.00$0.00000000000000000000.00
9$0.00$0$0$0.00$0.00000000000000000000.00
9$0.00$0$0$0.00$0.00000000000000000000.00
9$0.00$0$0$0.00$0.00000000000000000000.00
9$0.00$0$0$0.00$0.00000000000000000000.00
9$0.00$0$0$0.00$0.00000000000000000000.00
9$0.00$0$0$0.00$0.00000000000000000000.00
9$0.00$0$0$0.00$0.00000000000000000000.00
9$0.00$0$0$0.00$0.00
9$0.00$0$0$0.00$0.00
9$0.00$0$0$0.00$0.00
9$0.00$0$0$0.00$0.00
9$0.00$0$0$0.00$0.00000000000000000000.00
10Specialties$0.00$0.00000000000000000000.00
10$0.00$0$0$0.00$0.00000000000000000000.00
10$0.00$0$0$0.00$0.00000000000000000000.00
10$0.00$0$0$0.00$0.00000000000000000000.00
10$0.00$0$0$0.00$0.00000000000000000000.00
10$0.00$0$0$0.00$0.00000000000000000000.00
10$0.00$0$0$0.00$0.00000000000000000000.00
10$0.00$0$0$0.00$0.00000000000000000000.00
10$0.00$0$0$0.00$0.00000000000000000000.00
11Equipment$0.00$0.00000000000000000000.00
11$0.00$0$0$0.00$0.00000000000000000000.00
11$0.00$0$0$0.00$0.00000000000000000000.00
11$0.00$0$0$0.00$0.00000000000000000000.00
11$0.00$0$0$0.00$0.00000000000000000000.00
11$0.00$0$0$0.00$0.00000000000000000000.00
11$0.00$0$0$0.00$0.00000000000000000000.00
11$0.00$0$0$0.00$0.00000000000000000000.00
11$0.00$0$0$0.00$0.00000000000000000000.00
12Furnishings$0.00$0.00000000000000000000.00
12$0.00$0$0$0.00$0.00000000000000000000.00
12$0.00$0$0$0.00$0.00000000000000000000.00
12$0.00$0$0$0.00$0.00000000000000000000.00
12$0.00$0$0$0.00$0.00000000000000000000.00
12$0.00$0$0$0.00$0.00000000000000000000.00
12$0.00$0$0$0.00$0.00000000000000000000.00
12$0.00$0$0$0.00$0.00000000000000000000.00
12$0.00$0$0$0.00$0.00000000000000000000.00
13Special Construction$0.00$0.00000000000000000000.00
13$0.00$0$0$0.00$0.00000000000000000000.00
13$0.00$0$0$0.00$0.00000000000000000000.00
13$0.00$0$0$0.00$0.00000000000000000000.00
13$0.00$0$0$0.00$0.00000000000000000000.00
13$0.00$0$0$0.00$0.00000000000000000000.00
13$0.00$0$0$0.00$0.00000000000000000000.00
13$0.00$0$0$0.00$0.00000000000000000000.00
13$0.00$0$0$0.00$0.00000000000000000000.00
14Conveying Systems$0.00$0.00000000000000000000.00
14$0.00$0$0$0.00$0.00000000000000000000.00
14$0.00$0$0$0.00$0.00000000000000000000.00
14$0.00$0$0$0.00$0.00000000000000000000.00
14$0.00$0$0$0.00$0.00000000000000000000.00
14$0.00$0$0$0.00$0.00000000000000000000.00
14$0.00$0$0$0.00$0.00000000000000000000.00
14$0.00$0$0$0.00$0.00000000000000000000.00
14$0.00$0$0$0.00$0.00000000000000000000.00
21Fire Suppression$0.00$0.00000000000000000000.00
21$0.00$0$0$0.00$0.00000000000000000000.00
21$0.00$0$0$0.00$0.00000000000000000000.00
21$0.00$0$0$0.00$0.00000000000000000000.00
21$0.00$0$0$0.00$0.00000000000000000000.00
21$0.00$0$0$0.00$0.00000000000000000000.00
21$0.00$0$0$0.00$0.00000000000000000000.00
21$0.00$0$0$0.00$0.00000000000000000000.00
21$0.00$0$0$0.00$0.00000000000000000000.00
22Plumbing$0.00$0.00000000000000000000.00
22$0.00$0$0$0.00$0.00000000000000000000.00
22$0.00$0$0$0.00$0.00000000000000000000.00
22$0.00$0$0$0.00$0.00000000000000000000.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00
22$0.00$0$0$0.00$0.00000000000000000000.00
22$0.00$0$0$0.00$0.00000000000000000000.00
22$0.00$0$0$0.00$0.00000000000000000000.00
22$0.00$0$0$0.00$0.00000000000000000000.00
22$0.00$0$0$0.00$0.00000000000000000000.00
23HVAC$0.00$0.00000000000000000000.00
23$0.00$0$0$0.00$0.00000000000000000000.00
23$0.00$0$0$0.00$0.00000000000000000000.00
23$0.00$0$0$0.00$0.00000000000000000000.00
23$0.00$0$0$0.00$0.00000000000000000000.00
23$0.00$0$0$0.00$0.00000000000000000000.00
23$0.00$0$0$0.00$0.00000000000000000000.00
23$0.00$0$0$0.00$0.00
23$0.00$0$0$0.00$0.00
23$0.00$0$0$0.00$0.00
23$0.00$0$0$0.00$0.00
23$0.00$0$0$0.00$0.00000000000000000000.00
23$0.00$0$0$0.00$0.00
23$0.00$0$0$0.00$0.00
23$0.00$0$0$0.00$0.00000000000000000000.00
26Electrical$0.00$0.00000000000000000000.00
26$0.00$0$0$0.00$0.00000000000000000000.00
26$0.00$0$0$0.00$0.00000000000000000000.00
26$0.00$0$0$0.00$0.00000000000000000000.00
26$0.00$0$0$0.00$0.00000000000000000000.00
26$0.00$0$0$0.00$0.00000000000000000000.00
26$0.00$0$0$0.00$0.00000000000000000000.00
26$0.00$0$0$0.00$0.00000000000000000000.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
26$0.00$0$0$0.00$0.00
27Communications$0.00$0.00000000000000000000.00
27$0.00$0$0$0.00$0.00000000000000000000.00
27$0.00$0$0$0.00$0.00000000000000000000.00
27$0.00$0$0$0.00$0.00000000000000000000.00
27$0.00$0$0$0.00$0.00000000000000000000.00
27$0.00$0$0$0.00$0.00000000000000000000.00
27$0.00$0$0$0.00$0.00000000000000000000.00
27$0.00$0$0$0.00$0.00000000000000000000.00
27$0.00$0$0$0.00$0.00000000000000000000.00
28Electronic Safety & Security$0.00$0.00000000000000000000.00
28$0.00$0$0$0.00$0.00000000000000000000.00
28$0.00$0$0$0.00$0.00000000000000000000.00
28$0.00$0$0$0.00$0.00000000000000000000.00
28$0.00$0$0$0.00$0.00000000000000000000.00
28$0.00$0$0$0.00$0.00000000000000000000.00
28$0.00$0$0$0.00$0.00000000000000000000.00
28$0.00$0$0$0.00$0.00000000000000000000.00
28$0.00$0$0$0.00$0.00000000000000000000.00
31Earthwork$0.00$0.00000000000000000000.00
311Pit Run Gravel25ton50.00$0.00$50$1,250$1,250.00$0.00000000000000000001,250.00
312Compacting25ton25.00$0.00$25$625$625.00$0.0000000000000000000625.00
31$0.00$0$0$0.00$0.00000000000000000000.00
31$0.00$0$0$0.00$0.00000000000000000000.00
31$0.00$0$0$0.00$0.00000000000000000000.00
31$0.00$0$0$0.00$0.00000000000000000000.00
31$0.00$0$0$0.00$0.00000000000000000000.00
31$0.00$0$0$0.00$0.00000000000000000000.00
32Exterior Improvements$0.00$0.00000000000000000000.00
32$0.00$0$0$0.00$0.00000000000000000000.00
32$0.00$0$0$0.00$0.00000000000000000000.00
32$0.00$0$0$0.00$0.00000000000000000000.00
32$0.00$0$0$0.00$0.00000000000000000000.00
32$0.00$0$0$0.00$0.00000000000000000000.00
32$0.00$0$0$0.00$0.00000000000000000000.00
32$0.00$0$0$0.00$0.00000000000000000000.00
32$0.00$0$0$0.00$0.00000000000000000000.00
33Utilities$0.00$0.00000000000000000000.00
33$0.00$0$0$0.00$0.00000000000000000000.00
33$0.00$0$0$0.00$0.00000000000000000000.00
33$0.00$0$0$0.00$0.00000000000000000000.00
33$0.00$0$0$0.00$0.00000000000000000000.00
33$0.00$0$0$0.00$0.00000000000000000000.00
33$0.00$0$0$0.00$0.00000000000000000000.00
33$0.00$0$0$0.00$0.00000000000000000000.00
33$0.00$0$0$0.00$0.00000000000000000000.00
34Transportation$0.00$0.00000000000000000000.00
34$0.00$0$0$0.00$0.00000000000000000000.00
34$0.00$0$0$0.00$0.00000000000000000000.00
34$0.00$0$0$0.00$0.00000000000000000000.00
34$0.00$0$0$0.00$0.00000000000000000000.00
34$0.00$0$0$0.00$0.00000000000000000000.00
34$0.00$0$0$0.00$0.00000000000000000000.00
34$0.00$0$0$0.00$0.00000000000000000000.00
34$0.00$0$0$0.00$0.00000000000000000000.00
35Waterway & Marine Construction$0.00$0.00000000000000000000.00
35$0.00$0$0$0.00$0.00000000000000000000.00
35$0.00$0$0$0.00$0.00000000000000000000.00
35$0.00$0$0$0.00$0.00000000000000000000.00
35$0.00$0$0$0.00$0.00000000000000000000.00
35$0.00$0$0$0.00$0.00000000000000000000.00
35$0.00$0$0$0.00$0.00000000000000000000.00
35$0.00$0$0$0.00$0.00000000000000000000.00
35$0.00$0$0$0.00$0.00000000000000000000.00
41Material Handling & Processing$0.00$0.00000000000000000000.00
41$0.00$0$0$0.00$0.00000000000000000000.00
41$0.00$0$0$0.00$0.00000000000000000000.00
41$0.00$0$0$0.00$0.00000000000000000000.00
41$0.00$0$0$0.00$0.00000000000000000000.00
41$0.00$0$0$0.00$0.00000000000000000000.00
41$0.00$0$0$0.00$0.00000000000000000000.00
41$0.00$0$0$0.00$0.00000000000000000000.00
41$0.00$0$0$0.00$0.00000000000000000000.00
44Pollution Control Equipment$0.00$0.00000000000000000000.00
44$0.00$0$0$0.00$0.00000000000000000000.00
44$0.00$0$0$0.00$0.00000000000000000000.00
44$0.00$0$0$0.00$0.00000000000000000000.00
44$0.00$0$0$0.00$0.00000000000000000000.00
44$0.00$0$0$0.00$0.00000000000000000000.00
44$0.00$0$0$0.00$0.00000000000000000000.00
44$0.00$0$0$0.00$0.00000000000000000000.00
44$0.00$0$0$0.00$0.00000000000000000000.00
GRAND TOTAL$75$1,875$1,875.00$0.00000000000000000001,875.00
000000000000000003750

Instructions

Re-Worked Cost Estimate Form
Instructions on using this spreadsheet
All costs are itemized on "Line Items" tab.
These costs are then summarized - by Division - on the "Summary" Tab.
The logic is set up like the RS Means Cost Estimating Books
That is: the "Unit Values" in columns E through H are added together and multiplied by the "Quantity" in column C
These costs are summarized based on the Division number in Column A
You can change the Division number anywhere on the sheet without affecting the summary logic.
The way to do this is to change the number shown in the Yellow portion10Cells Like This
The next 8 lines below this will change automatically10Cells Like This
You can also insert lines at anypoint on the page and not affect the summary logic.
Doing this will of course mess up the print setup and you will have to fix that to suit what you want.
*
*

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