Highways Cost Estimating Using the ELEMENTAL PARAMETRIC METHOD Version 1.1

USER MANUAL DISCLAIMER: E. Wolski Consulting under contract to the Ministry of Transportation developed the Elemental Parametric Method of Estimating described in this manual. To the best of our knowledge, the methodology and information used in developing the estimating spreadsheet is as accurate and up-to-date as possible. E. Wolski Consulting assumes no responsibility for the accuracy or completeness of the results produced with it, or the consequences of their subsequent use.

ESTIMATING MANUAL

Page 2

Highway Cost Estimating Manual Using the Elemental Parametric Method Table of Contents Introduction ……………………………………………………………. System and Operator Requirements ………………………………… User Support …………………………………………………………… What is Elemental Parametric Estimating ?…………………………. The Steps of Estimating ………………………………………………. Define the Type of Estimate ………………………………….. Develop the Work Breakdown Structure for the Project …… Develop a Scope for each part of the project ………………. Develop an Estimate for each Section ……………………… Summarize the estimates……………………………………… Print, Bind, and Store the Estimate Information ……………. Updating Estimates and Retaining Old Estimates …………………. Overview of the Excel Workbook BlkEst 6.0 ……………………….. Preparing the Spreadsheet for Use ………………………………….. Overall Rules When Using the Spreadsheet ……………………….. Outline of Working Through the Estimate Sheets ………………….. Step 1 Page Header and Footer Step-up ………………….. Step 2 Estimate Sheet Header Description ……………….. Step 3 Save As “new estimate name”………………………. Step 4 Enter existing conditional (Optional)………………. Step 5 Grade Construction Element – Quick Review ……. Step 5 Grade Construction Element – Detailed Process … Quantities Not Available …………………………….. Quantities Are Available from Design ……………… Material Distribution and Costing …………………… Step 5 Pricing and Quantifying – Grade Construction ……. Step 6 Paving Construction Element ……………………….. Step 7 Structural Construction Element ……………………. Bridges ………………………………………………… Retaining Walls ………………………………………. Tunnels ……………………………………………….. Portals and Snowsheds …………………………….. Step 8 Operational Construction Element …………………. Step 9 Roadside Construction Element …………………….

EW

August 21, 2001

Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page

4 4 5 5 5 5 6 8 9 10 10 10 11 13 15 17 17 20 17 17 23 25 27 28 30 32 36 38 38 39 40 43 44 46

ESTIMATING MANUAL

Page 3

Highway Cost Estimating Manual Using the Elemental Parametric Method Table of Contents Step 10 Other Construction Element………………………….. Railroad/crossing ……………………………………. Marine Work …………………………………………. Environmental Mitigation …………………………… Step 11 Utility Element ……………………………………….. Hydro, Telephone, Pipelines, Telecommunication.. Step 12 Design and Supervision Element ………………….. Design ………………………………………………… Supervision ………………………………………….. Step 13 Land Element ………………………………………. Acquisition of Land …………………………………. Associated Costs …………………………………… Step 14 Planning and Preliminary Design Element ………. Step 15 Project Management Element …………………….. Project Management Cost to include Land ……… Step 16 Management Reserve ……………………………… Step 17 Escalation Element …………………………………. Step 18 Summary Page Review ……………………………. Step 19 Review of the first estimate ……………………….. Step 20 Start next estimate ……………………………… Step 21 Complete next estimate…………………………… Step 22 Linking all the estimate into the sum of estimates Difference Between SUMOFEST and SUMOFSUM Linking Summary Worksheets ……………………… Linking Estimates to Make Global Changes ……… Step 23 Saving time by using completed estimates ………. Step 24 Review Project and Save…………………………… Step 25 Print Estimates and summary, Store in Binder ….. Appendices Standard Estimate Worksheet…………………………………. Summary of Estimates Report………………………………… Summary of Summaries Report ……………………………… Difference Report ……………………………………………… Activity Item List ……………………………………………….. Activity item Description ……………………………………….

EW

August 21, 2001

Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page

47 48 48 48 49 49 51 53 54 55 55 56 58 60 60 62 63 65 19 19 19 67 68 69 70 19 24 19

A B C D E F

ESTIMATING MANUAL

Page 4

Highway Cost Estimating Manual Using the Elemental Parametric Method

Introduction This manual accompanies the spreadsheet file BlkEst 6.0.xls. Together, they provide a framework to rigourously estimate the cost of a highway construction project in Canada. BlkEst 6.0 can estimate projects of many sizes, from single intersections to multiyear projects worth many hundreds of millions of dollars. BlkEst 6.0 is a project estimating spreadsheet, and does not provide for cost tracking or project management. On the other hand, it uses a set of cost tracking categories and cost centers which can be carried forward to other software for project accounting and management purposes – all the way to the coding of contractors' invoices. System and Operator Requirements BlkEst 6.0 requires Microsoft Excel 97 or higher, running under Windows 95, 98, NT, or higher. The spreadsheet easily reaches a megabyte in size when used, so the computer on which it runs should be more robust than the minimum required to run the operating system and Excel. Since estimates can take many days to develop fully and thus represent a large investment of skilled labour, the computer must be subject to regular, secure data backups. To use this spreadsheet, one needs: ·

A modest working knowledge of highway construction and estimating terms.

·

Familiarity with basic Excel operations. Examples: how to edit a formula, how to use the Goal Seek tool, how to link spreadsheets.

·

Familiarity with what not to do in a spreadsheet, such as type over a formula when inserting text, or insert a column where it will affect a summarizing formula elsewhere.

·

The rudiments of Parametric Estimating, which the rest of this Introduction will teach.

·

The step-by-step instructions for filling in the parameter values, as explained in the body of this manual.

EW

August 21, 2001

ESTIMATING MANUAL

Page 5

User Support If you require help which this manual does not provide, contact the author: Ernest Wolski, A.Sc.T. at (250) 744-1107

What is Elemental Parametric Estimating? This spreadsheet builds up the estimate of a highway project from the expected cost of its elements and its parameters. The elements are the building blocks of the highway, such as, grade, structural, paving, operation construction, utilities, and so on. The parameters are the variables which need to be defined, such as, number of lanes, lane widths, depth of materials, number of culverts per kilometer for drainage, tunnel width and height, and so on. Element Parametric Estimating is the combination of elements, parameter and predefined activities within each element. It does not provide a breakdown of traditional labour and materials, but the breakdown it does provide is superior for decision-making as a project takes shape. It would appear from the foregoing that a parametric estimate has to wait until a project is being designed in detail, so all the parameters are known and can be priced. In fact, parametric estimating (and this spreadsheet) can be used for the earliest estimates; one simply enters the relatively few known parameters and uses assumptions for the rest. One still obtains a workable estimate for early planning and budgeting. Later, as assumptions are gradually replaced with known quantities, the parametric estimate becomes more defined and can be compared to the original estimate. The Steps of Estimating A. Define the type of estimate B.

Develop a Work Breakdown Structure for the project.

C.

Develop a scope for each part of the project.

D.

Develop a parametric estimate for each road type in that part of the project.

E.

Summarize the estimates.

F.

Print, bind and store the completed Project Estimate for ongoing reference.

A. Define the Type of Estimate The four types of estimate are Conceptual, Functional, Preliminary, and Detailed Design. If Elemental Parametric Estimating is used for each type, then the successive estimates will all have identical categories, and a welcome consistency from one type of estimate to the next.

EW

August 21, 2001

ESTIMATING MANUAL

Page 6

B. Develop the Work Breakdown Structure for the Project A consistent Work Breakdown Structure for the entire Project is a major ingredient for getting accurate estimates in an efficient time frame. We will first describe the WBS for a very large project, then suggest where smaller projects can employ a simpler one.

Figure 1.01 In Figure 1.01, a large project is divided into sub-projects: ·

The limits of a sub-project should be defined so that the sub-project is a deliverable. A deliverable means that each sub-project can be built and can operate without the others being completed.

·

Each project can have its own management.

Each sub-project can be divided into Divisions or Sites:

EW

·

This is a smaller geographic area, perhaps also a deliverable.

·

Having divisions within a sub-project allows for alternate alignments to be estimated during the earlier design phases (earlier estimate types).

August 21, 2001

ESTIMATING MANUAL

Page 7

Figure 1.02 Within a Division, each different type of road becomes a Section, and gets its own Estimate. Figure 1.02 explains the relation between division, road type, and estimate.

EW

·

Assume that Figure 1.02 represents one division within a sub-project. The "Main Road" in this division is the best place to start the work breakdown structure, and it could be broken into two sections: one is from the far left to a point between the bridge and the grade separation, and the second runs from there to the far right side of the division. Each of these two sections gets its own estimate. Note that if one section had two lanes and the other had four, then we would be faced with two distinct Road Types, and the two separate estimates would be really necessary. As it is, a reason for two sections is not clear (and one need not have a reason beyond estimating convenience), but it could have to do with each section being over different terrain and thus requiring different treatments in the sub-base.

·

Next in the WBS come the cross roads: each intersection and a certain length of its cross roads becomes another section with an estimate. One estimates the intersection's acceleration, deceleration, and left-turn lanes, its signals and signage as part of the cross road section, not the main road section in the same vicinity.

·

Note that one can provide an "A" estimate for a section that includes an interchange, and another "B" estimate that includes a signal-controlled intersection, and another "C" estimate with just a grade separation.

August 21, 2001

ESTIMATING MANUAL

Page 8

These become either-or options for arriving at the optimal solution if budget becomes a problem. The methodology then is to put the main piece of road in the WBS first; then add the second piece of road; then the third, etc., until all roads in the division are logically broken down.

C. Develop a Scope for each part of the project

Figure 1.03

EW

August 21, 2001

ESTIMATING MANUAL

Page 9

Figure 1.03, "Ladysmith", represents a Division that has been broken into eight sections numbered S1 through S8. Beneath the key plan is a summary of eight separate estimates, one for each section as expected. Below that is the division's scope. Again, there is a scope for each section. The scope normally conveys the main cost drivers of each section, either in words or via a representative cross section: number of lanes, lane widths, shoulder or median widths, gravel and asphalt thickness. Also included are special features that impact cost, like bridge length and width, multiplates, etc. So far we have used all the layers of the WBS that Figure 1.01 provides. Smaller projects can drop the Division level, so the Sub-projects are made up of sections only. (That would mean that "Ladysmith" is a Sub-project with eight Sections, being completed as a single deliverable.) If the overall project is a single deliverable, then the only levels required by the spreadsheet are one Project, broken into enough logical Sections for reasonable estimating.

D. Develop an Estimate for each Section. At this point, the BlkEst 6.0 spreadsheet comes into play. It becomes the estimator's workpad on which he or she builds the estimates, for one section after another. As Figure 1.04 shows, BlkEst 6.0 gives each estimate a further WBS— Elements, Components, and Activity Line Items.

Figure 1.04 There are 13 Elements to be treated in each estimate, and they form the major parts of each Excel estimate sheet. Examples are Grade Construction, Paving Construction, Structure Construction, and so on. A full list comes after this introduction. Each Element is broken into a few Components. The Grade Construction element is typical, having two components: Construction and Engineering. Some elements have more.

EW

August 21, 2001

ESTIMATING MANUAL

Page 10

The lowest level of detail in the estimate is the Activity Line Item. Across all thirteen components, there are 185 line items. A number of cells have been labelled to accept specific pieces of data from the highway cross-section. These predefined cells are the parameters. They will be explained one by one in the body of this manual. Another aid on the spreadsheet is the assembly. This is a predefined group of parameters that estimates one piece of work, such as the group of parameters that describes a tunnel. The total cost of the assembly becomes one line item in the estimate.

E. Summarize the Estimates. Once the individual estimates for a division or sub-project are completed, their separate sheets in the BlkEst 6.0 spreadsheet file are linked (added together) into a summary sheet. Depending on the levels of summary required, one could link all the estimates to one division; then link those division summaries into a subproject; finally, link those into a project summary.

F. Print, Bind, and Store the Estimate Information. Once the estimate for a project is completed, print all the estimates and attache them to their key plans and summaries. BlkEst 6.0 provides two sheets with editable labels for the necessary binders and divider tabs.

Updating Estimates and Retaining Old Estimates. For audit and comparison purposes later, one should define all the estimates created at one stage of the project as one series. A series designation (on a set of estimates) appears as a letter prefix to the name of each estimate and summary, usually for the purpose of comparing different options. For example, there might be an "A" series of estimates in which each estimate sheet has a name beginning with A, then a "B" series with different assumptions, and so on. A series designation might also identify the type of estimates: "A" series is the first conceptual estimate, "D" and "E" are two preliminary estimates, and so on. If an original parametric estimate requires updating (this applies especially to creating a whole new series, but could also apply to updating only a couple of estimates in one division), there are two possible approaches. 1. Put a revision date in each estimate header, make the necessary changes, and one has an immediate updated estimate. The problem is that the original basis estimate has disappeared, so any financial comparison must be done manually from the printed copies.

EW

August 21, 2001

ESTIMATING MANUAL

Page 11

2. A better approach is to prefix all the original estimate names (their sheet or tab names) with "A____". Then create a new directory or folder, copy all the estimates into this folder, and rename them all as "B____". Now update the "B" estimates as required, and on the Difference summary tab, link the "A" and "B" summaries to create a difference report. Updating estimates by this A-B method helps maintain an audit trail, and is very useful when a project extends over an extended time period.

Overview of the Excel Workbook BlkEst 6.0 Figure 1.05 shows the sheets, or tabs, that are provided in BlkEst 6.0. For the full description of how to use them, see the section "Outline of working through the estimate sheets". Briefer descriptions of the sheets follow Figure 1.05.

Figure 1.05 1. EST-1BLANK This is the standard estimating sheet that contains all the parameters, components, activity codes, etc. to estimate one section of road. Using it as a checklist, the estimator ensures that all activities either have a value or not, but none is overlooked. Appendix A in this manual shows the appearance of EST-1BLANK. 2. SUMOFEST Report This abbreviation means Summary of Estimates. Depending on the work breakdown structure of the project, either all estimates or some of the estimates are linked to SUMOFEST so that it shows their total estimated cost. As presented in BlkEst 6.0, only the first estimate (EST-1BLANK) is linked to SUMOFEST. It is necessary to manually link all the other estimate sheets as well; the process is described near the end of this manual. Appendix B shows a SUMOFEST report. 3. SUMOFSUMS Report This stands for Summary of Summaries, and is a sheet which links together a number of SUMOFEST reports. One could have a number of divisions which summarize to a sub-project, or several sub-project summaries linked to form a complete project estimate. SUMOFSUMS reports are made from links to summaries, not from links to individual estimate sheets. Appendix C shows an example. 4. DIFF100 Report When two alternatives (different costs for the same section or sections of road) have been estimated and a summary produced for each alternative, the DIFF100 Report will demonstrate the difference between them—both the "bottom line" difference and the cost difference for each activity line item in the

EW

August 21, 2001

ESTIMATING MANUAL

Page 12

summaries. One summary is already linked to the DIFF100 report, and the linking of a second summary (described later) produces the desired result. See Appendix D for a sample report. 5. NameSheet Depending on one's preferences for printing and storing all estimates, this sheet contains labels for all estimates, summaries, and other information. The printed sheet of labels can be cut and folded for a set of 8 clear-tab insertable index dividers. Each label allows 3 lines for input, then copies those lines onto the back of the tab for folding. Font and colours can be changed manually if desired. 6. Labels Again depending on preferences, the labels on this sheet fit the spines of many 1" and 2" binders. 7. Scope The Scope sheet is meant as a guide for estimators as to what information should describe the scope of different parts of an estimate or a project. This guide is probably more helpful for a concept type of estimate, less helpful for a detailed estimate. 8. Total This sheet is designed to show all alternative alignments in the project on one spreadsheet—a means to show what one figuratively calls "Plan A", "Plan B", "Plan C", and so on, side-by-side for cost comparison. Unlike the DIFF100 report, the Total sheet does not report differences between alternatives, so the one report complements the other. As usual, linking the appropriate alternative estimates is done manually and explained later. See Appendix E for a sample of the Total report.

EW

August 21, 2001

ESTIMATING MANUAL

Page 13

Preparing the Spreadsheet for Use 1. Organize your project into a Work Breakdown structure (Project, Sub-projects, Divisions, Estimates). At this point, you will need to know the type of estimate you are undertaking, how many sections you will have to estimate, the scope of each estimate, and the logical summary collections. 2. Retrieve the blank BlkEst 6.0 sheet from disk, and save it under the new project filename to the designated project folder or directory. These instructions assume that the new filename is "New Project Blank" with the usual .XLS extension. 3. Click on the tab EST-1BLANK. Then click on File/Page Setup.

Figure 1.06

EW

 

Alter the Headers and Footers for this sheet to appropriate titles for the new project estimate. (Do not change its sheet or tab name at this time.)

 

On the Sheet dialog box, ensure that comments are not being printed (see Figure 1.06). Then either print the sheet, or use File/Print Preview, to ensure that the printed EST-1BLANK appears in portrait mode on exactly 7 paper pages with the summary appearing on page 7. If the sheet requires more than seven pages, check the page margins, column widths, or View/Page Break Preview, and make adjustments so that it prints on seven pages.

August 21, 2001

ESTIMATING MANUAL

 

Page 14

Next, print or preview the sheet with the comments being printed at the end of the sheet. With comments, EST-1BLANK should require 12 plus paper pages. Comments are cell referenced, activate the rows and columns heading as shown in Figure 1.07

Figure 1.07

 

Choose either of the options, then click "OK" to save the print settings with your adjustments. Save the entire New Project Blank.XLS file.

4. Repeat the above step for the SUMOFEST, SUMOFSUMS, and DIFF100 sheets in New Project Blank. With new headers and footers in place, each of these sheets should print in landscape mode (not portrait) in exactly 10 pages. Again, adjust the margins and page breaks as needed to achieve a 10-page print. 5. Save the file as New Project Blank, and then save it again with a new name specific to the project, and type of estimate, before you. You now have a base blank estimate for future work, and a starting worksheet for the estimate that you are about to create.

EW

August 21, 2001

ESTIMATING MANUAL

Page 15

Overall Rules When Using the Spreadsheet 1. Never, never add a line to any sheet. And never add a column, except on the Summary sheets where these instructions say that you may. Adding a line, even a blank line, will break the links and calculations across sheets. Your totals will still appear correct, but some key costs may be missing in the summaries! 2. Observe the colour conventions: BLUE = BLACK =

values you insert manually computer calculations, or other fixed items like titles.

RED =

overrides; cells where you have altered the default calculation. (This becomes crucial when a new estimate is made from a completed one.)

3. Protect the spreadsheet while you work on it, to preserve the formulas from accidental changes. All the black cells in EST-1BLANK have been protected at shown in Figure 1.08.

Figure 1.08 To make this cell-protection active, click on Tools/Protection, and protect the sheet for Contents and Scenarios as shown in Figure 1.09. This protects the calculations, but permits you to add comments and add data values to blank cells while the sheet is still protected. For some other operations, like changing the colour of a cell, you will need to unprotect the sheet, make the change, then protect again. The shortcut Alt-T, P, P is useful for doing this with fewer mouse clicks.

EW

August 21, 2001

ESTIMATING MANUAL

Page 16

Figure 1.09

4. Insert comments to document what you do. This is valuable tool for keeping track of your thinking and assumptions as you build estimates. Remember that you can print the sheet "with comments at end" later, for a written record. 5. Review all the Unit Prices in the first six pages of EST-1BLANK. Unit prices are in Column E, and also often appear in columns M, N, and O. They are mostly Composite Unit Prices, not tender prices; this means that several tender work items are combined into one activity line item on the estimate sheet, and that line item has a composite price. Here is an example of a composite unit price that you might derive for rock, and use instead of the default sheet value of $18 in cell M73: Item

A. Quantity

B. Price

C. Total

Calc'n method

Type A Excavation

1000 m³

$8.50

$ 8,500

A×B=C

Shear Walling

200 m²

$28.00

$ 5,600

A×B=C

Blasting Mats

1 Ls

$2000.00

$ 2,000

A×B=C

Composite Rock Price

1000 m³

$ 16.10

$ 16,100

C÷A=B

Composite unit prices for use in the spreadsheet may come from previous project costs, tender records, personal experience, etc. Once all unit prices are checked and adjusted, they should remain constant for the project — at least until a work item demands a price change.

This completes the preliminary setup of the BlkEst 6.0 sheet, to make it specific for your project, type of estimate, computer, and printer. Now proceed to the section "Working Through the Estimate Sheets" to build you estimate.

EW

August 21, 2001

ESTIMATING MANUAL

Page 17

OUTLINE OF WORKING THROUGH THE ESTIMATE SHEETS Complete the estimating steps in order. Certain steps depend on others steps being completed, working out of order is not recommended.

STEP 1. Headers and footers in print setup must be corrected in the EST-1BLANK estimate sheet as well as in the summaries. (See “Preparing the Spreadsheet for Use” Step 3 Page 13) If the print setup is not completed, all copied estimates will require manual correction at a later time. That is time consuming and inefficient. 2.

Complete the information necessary in the working header of the estimate sheet between rows “3” and “11” and between columns “B” and “O”. For more details see Step 2, Pages 20-22.

3.

Rename the estimate sheet (tab) according to the WBS name of the first section of road, and save.

4.

The existing pavement conditions for this section of estimated road is defined in lines 424 between column “I” to “O”. This information can be entered after step 5.Optional

5.

Proceed to the Grade Construction Element to define the parameters between rows “72” and “111” and columns “K” and “O”. Be aware that segment length equals road length plus structure lengths. For more details see Step5, Pages 23-35

6.

Complete the Paving Construction Element now, because it relates to the grade construction element. For more details see Step 6, Pages 36-37.

7.

Structural Construction Element - Tunnels, Snow sheds, Bridges and Retaining Walls. For more details see Step 7, Pages 38-44.

8.

Operational Construction Element – Lighting, Signals, Signage, Barriers, and Pavement markings. For more details see Step 8, Pages 44-45.

9.

Roadside Construction Element – Weighscales, Safety Rest Areas, and Rest Stops. For more details see Step 9, Pages 46-47.

10.

Other Construction– New Railway Construction, Railroad Crossings, Marine work and Environmental Mitigation. For more details see Step 10, Pages 47-48.

EW

August 21, 2001

ESTIMATING MANUAL

Page 18

11.

Utility Element - Complete any Hydro, Telephone, Pipeline or Other Utility Costs necessary for this estimate. For more details see Step 11, Pages 49-50.

12.

Design and Supervision Elements. Review the percentages indicated in the Standard estimate spreadsheet. These percentages can be adjusted after the project is completed and the total engineering and supervision costs are reviewed. One can link all estimate sheets together and change one number and all estimates will be changed. BE CAREFULL: if you made a previous change, this command will over ride that value. For more details see Step 12, Pages 51-54.

13.

Land Element. Estimating residential, commercial and partial right-of-ways can be provided in each estimate. For more details see Step 13, Pages 55-57.

14.

Planning and Preliminary Elements. It is preferable to estimate Planning and Preliminary Design Costs with each estimate. However these elements can be prepared as a stand-alone estimate in conjunction with Project Management, Management Reserve and Escalation elements. For more details see Step 14, Pages 58-59.

15.

Project Management Element It is preferable to estimate Project Management Costs with each estimate. However this element can be prepared as a stand-alone estimate in conjunction with Planning and Preliminary Design, Management Reserve and Escalation elements. For more details see Step 15, Pages 60-61.

16.

Management Reserve Element It is preferable to estimate Management Reserve Costs with each estimate, but like the other two, this element can be prepared as a stand-alone estimate in conjunction with Planning and Preliminary Design, Project Management and Escalation elements. For more details see Step 16, Pages 62-63.

17.

Escalation Element Escalation element should be prepared as a stand-alone estimate or it can be in conjunction with Planning and Preliminary Design, Project Management and Management Reserve elements. For more details see Step 17, Pages 63-64.

18.

Summary Page. After completing the first estimate, save and print the estimate. For more details see Step 18, Pages 65-66.

EW

August 21, 2001

ESTIMATING MANUAL

Page 19

19.

Make the necessary corrections until everything is correct as to content. Format the Headers, Footers, and save the estimate. THE FIRST ESTIMATE TAKES THE LONGEST TIME BUT ONCE COMPLETE BECOMES THE BASIS FOR ALL OTHER ESTIMATES.

20.

Proceed to next estimate. Create a copy of completed estimate, rename the copied estimate as required and save the workbook.

21.

Click on the second estimate and proceed to complete steps 2 through to 13 or to step 16 depending when steps 14 to 16 are going to be estimated. Complete all the estimate sheets to complete a division or a sub-project or a small total project.

22.

To link and total the estimate worksheets, proceed to Sum of Estimate worksheet. Linking all the individual estimate worksheets together provides a total area cost. For more details see Step 22, Pages 67-69.

23.

If a division or a sub-project is completed and saved, it is possible to copy and resave the existing division as a new division or sub-project. Go into the new sub-project and rename worksheets that can be used for the next section, delete the others and proceed to estimate the new area. Complete all the estimates and save. There are now two completed areas that are estimated. This process can be repeated many, many times until all divisions or sub-projects are estimated.

24.

Review summary and save.

25.

Print estimate and summary, store in binder.

EW

August 21, 2001

ESTIMATING MANUAL

Page 20

STEP 2 Estimate Sheet Header Descriptions

Figure 2.1 Cell Reference

Header Description Per Column

C3

File name path of the estimate = CELL (“Filename”,C3)

C4

Company Name, (Defines where the estimate came from)

C 5

The values shown in the estimate represent the cost of doing the work in a certain year. (2001 Dollars)

C 8

This defines the estimate · Conceptual Estimate · Prelimenary Estimate · Functional Estimate · Detailed Estimate ( usually information is transposed from Schedule 7 information

B 9,10

Latest version of the spreadsheet.

D 4,5,6

Description of the project or description of the estimate or both.

D 7,8,9

Date when the estimate was made and Revision dates.

G 3

Percentage used for Management Reserve. This percentage can be modified in the Management Reserve Element.

G 4

All contingencies in the estimate are linked to this cell. However, the contingency in each element can be changed later if required. Highlight the change in other cells (not in G4) in red.

G 5

Estimate Number

EW

August 21, 2001

ESTIMATING MANUAL

G 6

Page 21

This number defines the type of road being estimated. These road types are defined in columns “K” and “M” Road Type 1. 2ln Frontage 2. 2ln Acc Rds 3. 4ln Acc Rds 4. R4L –4LEXP R/B

Description 2 lane Frontage Road 2 lane Access Roads 4 lane Access Roads Reconstruct existing 4 lane road to a new 4 lane expressway with raised median barrier.

5. R2/3L-4L EXP R/B

Reconstruct existing 2/3 lane road to a new 4 lane expressway with raised median barrier.

6. Retr.4L-4L EXP R/B

Retrofit existing 4 lane road to a new 4 lane Expressway with Raised median Barrier.

EW

7. R4L-4LEXP R/B E/S

Reconstruct existing 4 lane road to a new 4 lane Expressway with Raised median Barrier with existing side slopes.

8. New 4L EXP R/B

New 4 lane Expressway with Raise Median Barrier.

9. R-E4L-4L D/M

Reconstruct existing 4 lane road to a new 4 lane Expressway with Depressed Median.

10. N 4L EXP D/M

New 4 lane Expressway with Depressed Median.

11. N 4L EXP D/E/M

New 4 lane Expressway with Depressed Extended wide Median.

12. N 2L;F4LEXP D/M

New 2 lane road of a Future 4 lane Expressway with depressed Median.

13. INST. R/B-EX-RD

Installation of Raised Median Barrier on an Existing Road.

August 21, 2001

ESTIMATING MANUAL

Page 22

14. AS IS 15. MISC. 16. – 19

SPARES

20. I/C Str. & Ramps 21. Bridges

Interchange Structures and Ramps Bridges

22. Grade Sep.

Grade Separations

G7

The segment of road length being estimated. NOTE: For one road type one can combine several lengths together.

H4

A quick reference of the contingency used for the Land Element. This Contingency can be changed later in the element.

I(3-7)

An Abbreviated description of the estimate location or function or both. This description is transferred to the summary sheet.

I11

Each estimate must be classified as Main Road (MR) or Other Road (OR). This will show up in the summary report.

EW

August 21, 2001

ESTIMATING MANUAL

Page 23

STEP 5 GRADE CONSTRUCTION ELEMENT– Summary Quick Review

Figure 5.1

Quick Overview of Step 5 1. Define scope to see if you require Box 1only or Box 1 & 2 or Box 1,2 & 30. 2. Fill in the parameters in the boxes defined above as required. 3. Box 5 A defines the depth of SGSB and CBC for Boxes 1 & 2 and the total quantities are shown in Box 4. · Box 5A also works with net line and most probable quantities by adjusting the percentage in Cells N 94,95.

EW

August 21, 2001

ESTIMATING MANUAL

Page 24

4. Box 5 defines the total volume of material moved for Box 1A and Box 2A by adjusting the depth (d) in Box 1 or Box 2. · Box 5 also works with net line and most probable quantities by adjusting the percentage from 0% (neat line) to a ____% for most probable. · After you obtained neat line quantities change percentage to get most probable. 5. Box 3A shows the total volume of material that is shown in Boxes 1A or 2A. 6. As a check see Cell L,M 97 which shows the cross-sectional volumes per lineal meter of road. Adjust Depth (d) in cells L90 and/or M90 to achieve the quantity. 7. Box 6 shows the total property required (Property Line to Property Line – pl to pl) in Boxes 1 & 2. · Adjust each property requirements by adjusting Cells L,M 96 (use a positive or a negative number) · This is important because this calculates the stripping, hydroseeding and land areas. 8. Go to Box 3 and define what kind of material you have and adjust the percentage and unit prices for each of the materials. 9. Boxes 7, 7A and 7B define the highway drainage system. · Box 7 defines all transverse culverts by defining the number of culverts per kilometer and price per lineal meter of culvert and head walls. · Box 7A defines all longitudinal drainage necessary for a highway system based on a price per lineal meter of main road. · Box 7B defines special culverts of drainage necessary and not covered in the above two items. 10. Be careful: if you make a change in one parameter, it will change other quantities. Go back to step 1 and redo until you feel comfortable with the result. 11. Go into the Detailed Process for more help.

EW

August 21, 2001

ESTIMATING MANUAL

Page 25

STEP 5 GRADE CONSTRUCTION ELEMENT– Detailed Process

Figure 5.2 As part of your planning process determine how you can best estimate this piece of work by using Box 1, 1A, 1B; Box 2, 2A, 2B and Box 30 (Resurfacing roads only). Examples of using different Boxes 1. Same road with 2 different site conditions Estimate length L= 5000 lm G7 · Box 1 Rocky difficult terrain Road Length L= 3000 lm L91 · Box 2 Swampy flat terrain Road Length L= 1600 lm M91 · Say you had several bridges Bridge Lengths L= 400 lm

EW

August 21, 2001

ESTIMATING MANUAL

Page 26

2. One road with a passing lane · Box 1 Main Road · Box 2 Passing Lane

Estimate length Road Length Road Length

L= 3000 lm L= 3000 lm L= 1500 lm

G7 L91 M91

3. Divided 4 Ln Hwy with Depressed Median Estimate length · Box 1 2 Lane road (Half) Road Length · Box 2 2 Lane road (Half) Road Length

L= 4000 lm G7 L= 4000 lm L91 L= 4000 lm M91

4. Adding an Intersection to Existing Rd. · Box 1 Intersection Rd · Box 2 Accel/Decel./Left Turn Ln · Box 30 Resurfacing existing Road

L= 100 lm L= 100 lm L= 1650 lm L= 750 lm

Estimate length Road Length Road Length Road Length

Entering Parameters into a Road Cross-section Template.

EW

August 21, 2001

G7 L91 M91 P91

ESTIMATING MANUAL

Page 27

Figure 5.3 Entering parameters in the estimate sheet (cell reference) using the Road crosssection template Figure 5.3 as a reference. 1) 2) 3) 4)

EW

No of Lanes L,M 83 Lane Width L,M 84 Median L,M 85 Shoulder Width total L,M 86 · Watch out if you have barrier on one or both sides of the shoulder - this length will increase by .6 or 1.2 meters August 21, 2001

ESTIMATING MANUAL

Page 28

5) 6) 7) 8) 9) 10) 11) 12)

Ditch Width total N,O 82 S.G.S.B. Depth L,M 94 C.B.C. Depth L,M 95 C.B.C. Slope N,O 87 S.G.S.B. Slope L,M 89 Asphalt Depth AC L,M166 Asphalt Depth ABC L,M167 Road Length L,M 91 · Note: if one Column is used (Box 1) Cell L91 is linked to cell G7 in the header. If you change the length in cell L-91 make in red. Road length should equal estimate length(G-7) less bridge and tunnel lengths 13) Depth (d) cell L, M 90. · To calculate the volume of material to be moved in this estimate we require a length, width, and a depth. · Length L,M 91 · Width (machine calculated – based on parameters- bottom of SGSB plus ditch width) · Depth L,M 90 – average depth over the estimate road length. · Now two possibilities will exist. A. QUANTITIES ARE NOT AVAILABLE B. QUANTITIES ARE AVAILABLE FROM DESIGN. A. QUANTITIES ARE NOT AVAILABLE · Go to cell N90. This is a Percentage cell that increases earth quantities from neat line to most probable. Make this 0% for now, you will change it later.

EW

·

Enter a suggested depth in cell L90 say 1.25 meters and see the results of this depth by checking: 1. The total volume shown in Box 2A N 84 2. The cross-sectional volume per lineal meter shown in cell L97 With these two values you can adjust the depth (d) cell L90 until you are satisfied with the results.

·

Go to cell N90 and increase percentage to suggested value of 15%.

·

Now you can go to defining the right-of-way item #14 (PL to PL Calculation Cell L82).

August 21, 2001

ESTIMATING MANUAL

Page 29

B. QUANTITIES ARE AVAILABLE FROM DESIGN · Since the formulas in the spreadsheet were developed from the top of asphalt to the bottom of SGSB, information must be entered in a logical sequence because each component is dependent on the next. 1) Asphalt volume cell G155. This volume is calculated from asphalt thickness in (mm) from the top layer AC asphalt cell (L166) and bottom layer ABC asphalt cell (L167) and cell M-168 (most probable percentage factor). Boxes 1B and 2B. Understand what your condition requires. Example: One layer of asphalt from shoulder to shoulder then use AC - L166.

Or is it one layer of asphalt to lane edge and gravel shoulders then use ABC - L167 and cell N167 to adjust the asphalt edge as required.

Cell N-167

Or it can be a combination of both conditions. You can make the cell M168 = 0 %, then adjust asphalt depth as required to balance to your design quantities, then adjust cell M168 to most probable quantities. Suggest 5%. ”Use Tools /Goal seek if desired” . 2) CBC quantities cell G92 and part of Box 5A Two factors can adjust CBC volume: Depth of CBC in cell L95, and the CBC slope cell N87. Part of Box 5A Effect of Changing slope or thickness or both will increase or decrease quantities in other line items like, earth volumes, property to property distance, clearing and grubbing, SGSB, landscaping, hydroseeding, drainage pipe lengths and all other line items that are percent related. As before, we have a most probable percentage cell N95. Make it 0%. (Neat line). An adjustment to the CBC depth L95 and to the slope N87 can be made to achieve the desired neat line quantity in G92, Use Tools / Goal Seek if desired. If OK, increase to most

EW

August 21, 2001

ESTIMATING MANUAL

Page 30

probable quantity by adding 15% to Cell N95 or whatever value you feel comfortable with. 3) SGSB quantities cell G91 and part of Box 5A Two factors can adjust SGSB volume: Depth of SGSB in cell L94, and the SGSB slope cell L89. Effect of Changing slope or thickness or both will increase or decrease quantities in other line items like, earth volumes, property to property distance, clearing and grubbing, landscaping, hydroseeding, drainage pipe lengths and all other line items that are percent related. As before, we have a most probable percentage cell N94. Make it 0%. (Neat line). An adjustment to the SGSB depth L94 and to the slope L89 can be made to achieve the desired neat line quantity in G91, Use Tools / Goal Seek if desired. If OK, increase volume to most probable quantity by inserting 15% into Cell N94 or what ever value you feel comfortable with. 4) Depth of excavation (d) L90 Box 5 Enter the total neat line volume of material moved into Box 31 cell P78. As before we have a most probable percentage cell N90. Make it 0%. Adjust depth in cell L90 so that volumes in cell N84 and cell P78 match, Use Tools / Goal Seek if desired. If OK, increase volume to most probable quantity by inserting 15% into Cell N90 or whatever value you feel comfortable with. Effect of Changing the depth L90 will increase or decrease quantities in other line items like, property to property distance, clearing and grubbing, landscaping, hydroseeding, drainage pipe lengths and all other line items that are percent related. 14) PL to PL Calculation Cell L82. Property Line to Property Line. As you can see this cell already has a length. This length has been calculated based on the parameters identified earlier. Is it the average ROW that is required for this estimate? Probably not. This length can be increased or decreased in cell L96 (Add ROW) to achieve the desired result. Changing pl to pl L82 will increase or decrease quantities in other line items like stripping, clearing and grubbing, landscaping, hydroseeding, and all other line items that are percent related.

EW

August 21, 2001

ESTIMATING MANUAL

Page 31

In summary, whether quantities were or were not available, the grading parameters have been completed for this estimate. Proceed to the next step. Material Distribution and Costing Box 3 NOTE All quantities shown in the spreadsheet work on the assumption neat line, or most probable quantities, without taking into consideration shrinkage or swell factors. The total volume of material moved for this estimate is shown in cell L78. This total comes for Box 1A Cell N84 and Box 2A Cell O84. This next process is to redistribute the total materials Cell L-78 into the following items. · Rock L73 Percentage of rock O73 · O M material L74 · Stripping L75 Stripping Depth O75 · Borrow L76 · Misc./LS L77 NOTE: These volumes are linked to the most probable percentage factor Cell N90. If you want to work with neat line quantities for the moment than make Cell N90 = 0% First, determine the stripping volume. The stripping volume is derived from multiplying the Stripping Depth O75 by the road length L, M 90 and PL to PL L, M82 in Boxes 1 & 2. Adjust Stripping Depth O75 to achieve the desired volume in L75, Use Tools / Goal Seek if desired. Next, determine the volume of rock required for this estimate. The volume of rock is determined as being the total volume of excavation less stripping to be equal to 100%. Enter the percent of rock into Cell O73 to achieve the desired volume in L73. Use Tools / Goal Seek if desired. Next, determine if you are in a borrow situation. Cell L76. Unless you have some quantities, you will not know if you are in a borrow situation. Be careful not to skip this detail, you can make an assumption that you are in a borrow situation. Example. If you were to build an interchange where the terrain is flat, all the material for the ramps and cross road would be on fill.(Borrow) DO NOT just enter your borrow value into the cell, go into the cell formula and delete the zero and put in the borrow value. (1+N90)*0 makes this formula tie in to the most probable percentage in Cell N90.

EW

August 21, 2001

ESTIMATING MANUAL

Page 32

The redistribution of materials between stripping, rock and borrow supplies the remaining balance of material to O.M. Cell L74. This is the amount of material required to be moved on site. CAUTION: If you are not comfortable with end result of the redistribution of materials you can not add more material to the line items, you must go back to depth parameter L,M90 and start over again adjusting the volumes to Cells N,O84 and then adjusting the PL to PL Cell L,M82 accordingly. Then you will re-adjust the stripping, rock, and borrow again. The next item is Misc./LS Cell L 77 This line item is to catch any item that are special to the area and that can be captured in the earthwork costs. DO NOT FORGET to go back to the most probable factor cell N90 and increase it back to the percentage you had before. We have now completed the redistribution of materials for earthworks. Pricing the above materials is next. Unit prices applied to the above materials are different than the unit prices in tenders. Composite unit prices are used for pricing rock, OM, stripping, and borrowed materials. A composite unit price means that several tender work items are combined together into one activity item. Example of a composite unit price for rock. ($16.10) Item

A. Quantity

B. Price

C. Total

Calc'n method

Type A Excavation

1000 m³

$8.50

$ 8,500

A×B=C

Shear Walling

200 m²

$28.00

$ 5,600

A×B=C

Blasting Mats

1 Ls

$2000.00

$ 2,000

A×B=C

Composite Rock Price

1000 m³

$ 16.10

$ 16,100

C÷A=B

A different composite unit price will be applied to Rock, O.M., Stripping, and Borrow in Box 3. (Activity line 5220) The material volume for Box 3A cell L78 is transposed to activity line 5220 cell G88 and the composite unit price of Box 3 M78 is transposed to cell E88. As a final check to the grading costs, look at cell J88. This cost in Figure 5.2 shows as being $335 per lineal meter or $335,000 dollars per kilometre. Is this reasonable. If Ok, than proceed to pricing and quantifying the Grading Construction Element. If not, than go back to Box 1 or 2 or 3 or all, and adjust as required until you are happy with the results. EW

August 21, 2001

ESTIMATING MANUAL

Page 33

Step 5 Pricing and Quantifying 5000 – GRADE CONSTRUCTION ELEMENT

Figure 5.4 1. General information about this element between rows 79 to 114 · Column B shows the activity code to each activity item. · Column C indicates which activities are construction, engineering or supervision · Column D describes the activity code · Column E shows a unit price or a percentage · Column F shows a unit of measure for each activity. · Column G shows a quantity or a value · Column H shows a lump-sum value · Column I is a calculated value from columns E, G, and H · Column J shows the cost per lineal meter for each activity 2. Important features to be aware in this Grade Construction Element. a) All mobilisation percentage throughout the spreadsheet are linked to Cell E100. Changing this percentage will change the mobilisation in all the other elements. EW

August 21, 2001

ESTIMATING MANUAL

Page 34

b) All contingencies throughout the spreadsheet are linked to Cell G4 in the header. c) All design percentages, except for structures and other construction are linked to Cell E106 in the grade element. This does not mean that you cannot change them, if you do, than make that cell RED. 3. Next review the Drainage. (Activity line 5030) Highway drainage in this element can be expressed in the following ways; · In Figure 5.2 Boxes 7, 7A and 7B define the highway drainage system. · Box 7 defines all transverse culverts by defining the number of culverts per kilometre and a price per lineal meter of culvert and a price per head wall for each culvert. The length of culverts is calculated in cell L,M94 by the parameters done earlier. · Box 7A defines all longitudinal drainage necessary for a highway system based on a price per lineal meter of main road. · Box 7B defines special culverts of drainage necessary, not covered in the above two items. You can add other items for drainage in Box 7B. d) Review the underground utilities · Activity line 5032 Water · Activity line 5033 Sanitary · Activity line 5034 Storm These underground utilities use a composite unit price and a specific length for each activity. If required a lump sum value can be added for each activity. ie. Pump / lift stations or special drainage outlets. 5. Site preparation / Clearing and Grubbing Activity line 5010 Use a composite unit price E87 for the above. Adjust the composite unit price to represent the job conditions because the area is fixed. The area (ha) hectares has been calculated based on previous defined parameters. A lump sum value may be added in H87 for special requirements. 6. Multiplates (Activity line 5040) There are two components to a multiplate: The culvert and the headwalls. 1. Note: Assumption, all multiplates are the same size. Add all the multiplates lengths (headwall to headwall) ie. 2 multiplates at 40 meters equal 80 lm entered into Cell G-90. The composite unit price E-90 should represent a specific intended size of multiplate. 2.Headwalls are manually priced and entered into the lump sum cell H90. To record different sizes of mutliplates and headwalls, use one of the SPARE BOXES to identify and price each multiplate. Go to the lump sum cell H90 and link the spare box total to it. Also add a comment field to the cell for reference and make the cell Red.

EW

August 21, 2001

ESTIMATING MANUAL

Page 35

7. Select Granular Sub Base (SGSB) (Activity line 5050) Quantity of material (m3) has been calculated from parameter entered before. Add a composite unit price E91 and a lump sum value in H91 if required. 8. Crushed Base Course (CBC) (Activity line 5051) Quantity of material (m3) has been calculated from parameter entered before. Add a composite unit price E92 and a lump sum value in H92 if required. 9. Grade Finishing /Landscaping (Activity line 5060) The area of landscaping (m2) is calculated by taking the property to property width and subtracting the pavement width times the length. A small unit cost per m2 (E-93) is applied for spreading the topsoil, however interchange landscaping can be very expensive and a lump sum value in H93 can be entered. If one requires to record in more detail landscaping items, use one of the SPARE BOXES to identify the line items. Go to the lump sum cell H-93 and link the spare box total to it. Also add a comment field to the cell for reference and make the cell Red. 10. Grade Finishing / Hydroseeding (Activity line 5061) The area of hydroseeding (m2) is calculated by taking the property to property width and subtracting the pavement width times the length. Add a composite unit price E94 and a lump sum value in H94 if required. 11. Fencing (Activity line 5062) Add a composite unit price E95 and a length (lm) G95 to the type of fence required and a lump sum value in H95 if required. Also add a comment field to the lump sum cell for reference. 12. Noise Barriers (Activity line 5063) Add a composite unit price E96 and an area (m2) G96 for the noise barrier required and a lump sum value in H-96 if required. Also add a comment field to the lump sum cell for reference. 13. Passing lanes (Activity line 5064) Add a composite unit price E97 and a length (lm) G97 to the passing lane and a lump sum value in H97 if required. Also add a comment field to the lump sum cell for reference. This line in normally estimated in activity line 5020 using parameters.

EW

August 21, 2001

ESTIMATING MANUAL

Page 36

14. Sidewalks / Curb and Gutters (Activity line 5090) The total price for this activity is made up of two components. 1. Sidewalks - A unit price in cell E98 and a sidewalk length (lm) in cell G98. 2. Curb and Gutter – A unit price in cell L98 and a curb/gutter length(lm) in cell H98. Remember If one has curb and gutter, one also has underground storm costs (Activity line 5034). 15. Detours / Traffic Management (Activity line 5005) This activity has two components: Detour cost and Traffic Management Costs. 1. Detours cost are priced by number of detours in Cell G99 and the price for each detour in Cell E99. 2. Traffic Management cost is shown in the lump sum Cell H99. The 16kilometre. This should be changed to site-specific conditions. 16. Mobilization (Activity line 5001) Cell E-100 is a percentage-calculated activity, based on the total cost of construction cost minus contingency in the grade construction element. All mobilisation unit percentages in the spreadsheet are linked to this Cell E100. They are Activity lines 5031, 5501, 6001, 6501, 5202, 5201, 5302, & 5301. Each of these activities can be changed and indicated in Red with a comment inserted for reference. 17. Contingency (Activity line 5099) Cell E-101 is a percentage-calculated activity, based on the total cost of construction cost in the grade construction element. All contingency percentages in the spreadsheet are linked to the Cell G- 4 in the header. They are: Activity lines 2599, 3099, 6799, 5039, 5099, 3519, 6819, 5599, 5529, 3529, 6829, 6099, 3569, 6869, 6599, 3549, 6849, 5209, 5299, 3559, 6859, 5309, 5399, 3579, 6879, 3539, & 2099. Each of these activities can be changed and indicated in Red with a comment inserted for reference. Finally, review the cost per lineal meter in cells J-79 to J104. Adjust composite unit prices or quantities if required. The Grade Construction Element estimate is complete, proceed to Step 6.

EW

August 21, 2001

ESTIMATING MANUAL

Page 37

STEP 6 PAVING CONSTRUCTION ELEMENT

Figure 6.1

1. Asphalt paving (Activity line 6020) This line item has four components. 1. Supply and install of the Asphalt 2. The oil required for surface bonding. 3. Pavement removal and 4. Milling. 1) Supply and Install of Asphalt The composite unit price is in Cell E155 The quantity has been calculated Cell G155 from parameter in Figure 5.2 Boxes 1,1A,1B, 2,2A, 2B, & 30. 2) Surface Bonding Asphalt (Primer and Tack Coat Oil) The unit price for oil per litre is in Cell L168 The application rate for oil is shown in Cells L169, M169, & P93 The quantity has been calculated in Cell H155 from parameters in Figure 5.2 Boxes 1, 2, & 30. 3) Pavement removal K172 is in m3 and the composite unit price is in cell L172. These are manual enters. 4) Milling K175 is in m3 and the composite unit price is in cell L175. These are manual enters.

EW

August 21, 2001

ESTIMATING MANUAL

Page 38

2. Concrete paving (Activity line 6030) Add a composite unit price E156 and an area (m2) G156 to the concrete required and a lump sum value in H156 if required. To record the concrete works in more detail, use one of the SPARE BOXES to identify the line items. Go to the lump sum cell H156 and link the spare box total to it. Also add a comment field to the cell for reference and make the cell Red. 3. Hot Reprofiling (Activity line 6040) Add a composite unit price in cell E157. The quantity has been calculated in Cell G157 from parameters in Figure 5.2 Boxes 1, 2, & 30 If required, add a lump sum value to H157. Also add a comment field to the cell for reference. 4. Shoulder Paving (Activity line 6050) Add a composite unit price in cell E158. The quantity has been calculated in Cell G158 from parameters in Figure 5.2 Boxes 1, 2, & 30 If required, add a lump sum value to H158. Also add a comment field to the cell for reference. 5. Pavement Finishing (Activity line 6060) Add a composite unit price in cell E159. The area m2 G159 is for all pavement finishing, referred to raised islands, raised median at intersections, and any handwork etc. If required, add a lump sum value to H159. Also add any costs for raised curbs for the above in the lump sum field. Also add a comment to the cell for reference. 6. Seal Coating (Activity line 6070) Add a composite unit price in cell E160. The area m2 G160 is a manual entry for the surface worked on. If required, add a lump sum value to H160. Also add a comment field to the cell for reference. 7. Pavement Mix Design (Activity line 6010) If Mix design is a pay item then apply a percent value in cell E161. If required add a lump sum value to H161. Also add a comment field to the cell for reference. Finally, review the cost per lineal meter in cells J155 to J165. Adjust composite unit prices or quantities if required. The Paving Element estimate is complete, proceed to Step 7.

EW

August 21, 2001

ESTIMATING MANUAL

Page 39

STEP 7 STRUCTURAL CONSTRUCTION ELEMENT

Figure 7.1 Five bridges, retaining walls, two D-type tunnels, 1 circular shaft or tunnel, a snowshed or a portal and associated underground utilities can be estimated in this element. Bridges 1. Figure 7.1 refers to Bridges only. Five Bridges can be estimated in one estimate spreadsheet. There are 4 elements to estimating a bridge. They are: Decks, Abutments, Piers and Site Works. Each element requires the input of some basic parameters. 1. Box 15 shows the 5 deck sizes, Deck #1 Width (lm) L130 out-to-out measurement of bridge and the length (lm) M130 abutment to abutment length and a Price per m2 of deck only in cell N130. Also the total net cost of the bridge #1 in shown in cell O130. Net cost means the total cost of a bridge less contingency. 2. Box 16 shows all information about the 5 bridge abutments. In bridge #1 the abutment is priced by Dollars per Horizontal Lineal Meter of Abutment. ($/HLM) Cell O124. Cell O118 provides information as to extra length of abutment due to a skew and extra length required for wing walls.

EW

August 21, 2001

ESTIMATING MANUAL

Page 40

Cell N124 provides the total cost for 2 abutments. Note: If one abutment is required, a modification to the formula is required in Cell N124 (Change 2 to 1) and then make that cell Red and add a comment to the cell for future reference. 3. Box 17 shows all information about the piers for the 5 bridges. In Bridge #1 the piers are priced by Dollars per Vertical Lineal Meter of Pier ($/VLM) Cell N124. Cell M124 indicates the number of piers, Cell L124 indicates the average pier height, top of bearings to underside of pier footing. Do not include piles as part of the pier length. Adjust the cost per vertical lineal meter to account for the pile costs. Cell M-118 shows the total cost for all the piers. 4. Box 18, 18A shows the cost and the percentage used for the 5 bridges. For Bridge #1 the percentage is shown in cell P118 and the total site cost is shown in cell L118. 5. In Box 19, identify each of the five bridges in L136 to L140. Based on the parameters indicated above, each of the corresponding bridges gross cost per meter square (N136,140) and the net cost per meter square (O136,140) is shown. Gross $/m2 includes contingency (E-138). Net $/m2 does not include contingency. All of the above bridge elements are summarised in the following activity codes; Activity Code 5514 Bridge Site Preparations Cell G131 Activity Code 5515 Bridge Piers Cell G132 Activity Code 5516 Bridge Abutments Cell G133 Activity Code 5517 Bridge Superstructure Cell G134 Any Demolition of existing bridges is manually entered in the lump sum cell H131. 2. Retaining Walls information is shown in Box 20 Activity code 5518 Retaining wall site preparation is only used under special conditions where one might do piling under a retaining wall. All other retaining walls are priced in Activity code 5519. The cost per m2 is entered in cell E136 and the area (m2) is entered in cell G136. If two different type of retaining walls are required in the same estimate, the second type can be priced in the lump sum column cell H136. To record more detail about the retaining walls, use one of the SPARE BOXES to identify the line items. Go to the lump sum cell H136 and link the spare box total to it. Also add a comment field to the cell for reference and make the cell Red.

EW

August 21, 2001

ESTIMATING MANUAL

Page 41

Proceed next to Tunnels and Portals.

EW

August 21, 2001

ESTIMATING MANUAL

Page 42

Tunnels

Figure 7.2

Figure 7.3

Figure 7.4 EW

August 21, 2001

ESTIMATING MANUAL

Page 43

A Tunnel Segment Length is made up of two sections, a Tunnel Section and a Portal Section at each end of the tunnel. The tunnel template is shown in Figure 7.2. The tunnel summary cost are shown in Figure 7.3. The tunnel elements and parameters are shown in Figure 7.4. The portal template and elements are shown in Figure 7.5 & 7.6. The Tunnel Section In Figure 7.4 there is provision to enter parameters to 2 different tunnels, one in Box 8, 8A, and the other in Box 9,9A. Parameters for a circular tunnel or shaft can be entered in Box 10,10A. Box 12 converts net line quantities to most probable quantities by a percent value. The quantities in Box 11 are directly linked to the percentages in box 12 and the quantities in Box 11A and 10A. The total excavation m3 (Box11 cell L154)= (Tunnel 1 quantity (Box 11A cell O150) + Tunnel 2 quantity (Box 11A cell P150) + Circular shaft quantity (Box 10A cell P154)) x Most probable percentage factor in Box 12 cell P160). The other two quantities that are affected by the percentage in a similar manner as described above are the Over-breakage quantity in Box 11 cell L155 (Percentage Box 12 cell P161) and the liner quantity Box 11 cell L158 (Percentage Box 12 cell P162). From the tunnel template Figure 7.2 and in Figure 7.4 the parameters for tunnels are: Box 8 Tunnel 1 Box 9 Tunnel 2 Name of tunnel Cell L141 Cell M141 Length of tunnel Cell L143 Cell M143 Outside wall face height Cell L144 Cell M144 Centre point of roof radius from top base slab. Cell L145 Cell M145 Tunnel Width Cell L146 Cell M146 Roof liner thickness Cell L147 Cell M147 Wall liner thickness Cell L148 Cell M148 Base slab thickness Cell L149 Cell M149 Roof over-breakage thickness Cell L150 Cell M150 Walls over-breakage thickness Cell L151 Cell M151 Base slab over-breakage thickness Cell L152 Cell M152 Box 8A Tunnel 1 Box 9A Tunnel 2 Surface area require per rock bolt Cell P144 Cell P148 Parameters for a Circular tunnel or shaft are: Box 10 Name of Shaft/Tunnel Cell N141 Shaft /Tunnel Length Cell N143 Radius of Shaft/Tunnel Cell N145

EW

August 21, 2001

ESTIMATING MANUAL

Page 44

Wall/ Liner Thickness Wall over-breakage thickness Surface area require per rock bolt

Cell N147 Cell N149 Cell P158

Box 10A

Based on the parameters provided above, additional information is provided about the tunnels. They are: Radius of each tunnel Tunnel 1 Box 8A Cell P142 Tunnel 2 Box 9A Cell P146 Surface area of walls and roof per lineal meter of tunnel. Tunnel 1 Box 8A Cell P143 Tunnel 2 Box 9A Cell P147 Tunnel inside height

Tunnel 1 Box 8A Cell P145

Tunnel 2 Box 9A Cell P149

On the circular tunnel/shaft, the only information produced is the surface area of shaft per lineal meter in Box 10A Cell P157. Box 11 identifies some basic elements (K154 to K162). These are support by quantities (L154 to K162) and a composite unit price (M154 to M162) providing a total cost for each element (N154 to N162). The total line cost form column “N” is divided by the sum of lengths for Tunnel 1 (Cell L143) + Tunnel 2 (Cell M143 and Circular shaft (Cell N143) to provide a average element line cost per lineal meter of tunnel. The cost of all the tunnels is shown in Box 11 Cell M163 with the cost per lineal meter shown in Cell N163. The net cost per lineal meter of tunnel including portals with mobilisation is shown in Figure 7.4 Cell P139. The gross cost per lineal meter of tunnel including portals with contingency is shown in Figure 7.4 Cell P141. In Figure 7.3 all of the above information is summarised into Activity Code 5511 Tunnel construction. The composite cost per lineal meter is shown in Cell E127; the combined tunnel lengths plus portals are shown in Cell G127. Any additional cost can be added into the lump sum Cell H127. The total cost for activity code 5511 is shown in Cell I127. Cell J127 represents the cost per lineal meter of activity 5511, relative to the estimate length shown in the header Cell G7. Special site requirements related to tunnel work are estimated in Activity Code 5510 in Cells E,G & H 126.

EW

August 21, 2001

ESTIMATING MANUAL

Page 45

The Portals or Showsheds

Figure 7.5

Figure 7.6 Either a portal or a snowshed can be estimated in Figure 7.6 Box 14. If both are required in the same estimate, it is recommended that one of the Spare Boxes be used to identify the line items for a snowshed. Go to the lump sum cell for snowsheds H129 and link the spare box total to it. Also add a comment field to the cell for reference and make the cell Red.

EW

August 21, 2001

ESTIMATING MANUAL

Page 46

In Figure 7.6 Cell P163 must contain one of the following words “Snowshed”or “Portal”. Portal costs go to Activity line 5511 in Figure 7.1 and Snowshed costs go to Activity line 5513 in Figure 7.1. For an example, enter a length in Cell P164 and change the words in Cell P163 See the different results in Activity line 5511 Cell G127 and Activity line 5513 Cell G129. The matrix chart of Figure 7.5 and input cells of Figure 7.6 show the elements and the parameters needed to estimate either a portal or a snowshed. The total cost of either portal or snowshed is shown in Cell P178 and the average cost per lineal meter is shown in cell O178. Any underground utilities that are directly affected by the structures above and have not been estimated in the grade utilities can be estimated under the following activity codes. Activity Code 5522 Water Activity Code 5523 Sanitary Activity Code 5524 Storm Review the cost per lineal meter in cells J118 to J141. Adjust composite unit prices or quantities or lump sum values if required. Reminder Estimate length (Header Cell G7) = Road lengths (Cell L91, M91) + Structure lengths of Main Tunnels, Bridges and Snowsheds. The Structural Construction Element estimate is complete, proceed to Step 8.

Step 8 Operational Construction Element

Signal Assembly Box

Figure 8.1

EW

August 21, 2001

ESTIMATING MANUAL

Page 47

Activity Code 6510 Lighting To determine the number of light standards required G180, three parameters must be entered: Length of road to be lit Figure 8.1 Cell M180 (Defaulted to G7) Change as required. Make cell Red if Changed. No. of rows Figure 8.1 Cell L180 Pole Spacing/row Figure 8.1 Cell K180 A composite unit price per pole is entered in Cell E180. If required a lump sum value is entered in H180.

EW

August 21, 2001

ESTIMATING MANUAL

Page 48

Activity Code 6520 Signals Enter the number of signals required in Cell G181. This initiates a similar amount in the signal assembly Figure 8.1 Btw Cell K181 to P188. This assembly contains elements and parameters for each element. For addition information, three additional elements may be added to the assembly. The existing elements and parameter can be adjusted as required. Additional costs can be entered into the lump sum cell H181. Activity Code 6530 Signage Signage is priced by a composite unit price in Cell E182, based on the estimate length G7 in the header. The cost is shown in cell G182. A lump sum value can be entered into cell H182. The total cost for signage is shown in I182. Activity Code 6540 Guard Rail Guard-rail and median barrier are grouped together and have a composite unit price in Cell E183 and a length (lm) in Cell G183. A lump sum value can be entered into cell H183. The total cost for guard-rail is shown in I183. Activity Code 6550 Pavement Markings The composite unit price in Cell E184 is made-up of three parameters; 1. Line painting Cost per lineal meter in Cell K189, 2. Cost of each pavement reflector in Cell N190, 3. The spacing of pavement reflectors in Cell N189 The quantity of line painting (lm) Cell G184 is determined by the parameters assigned to the grade construction element. This amount can be adjusted by adding extra lines to be painted in Cell L190. A lump sum value can be entered into cell H184. The total cost for line painting is shown in I184. Review the operational element total costs in column I180:186. The Operational Construction Element estimate is complete, proceed to Step 9.

EW

August 21, 2001

ESTIMATING MANUAL

Page 49

STEP 9 ROADSIDE CONSTRUCTION ELEMENT

Weighscale Assembly

Safety Rest Area Assembly

Figure 9.1

Activity Code 5210 Weighscales Enter the number of weighscales required in Cell G209. This initiates a similar amount in the weighscale assembly Figure 9.1 Btw Cell K191 to P199. This assembly contains some major elements in determining the cost of a weighscale. Adjust the parameters for each of the elements within the assembly to meet the scope and site conditions. A lump sum value can be entered into cell H209. The total cost for weighscales is shown in I209. Activity Code 5220 Safety Rest Areas Enter the number of Safety Rest Areas required in Cell G210. This initiates a similar amount in the Safety Rest Area assembly Figure 9.1 between Cell K200 to P212. Entering the number of Safety Rest Areas in G210 creates a Class A/B Building entry in Cell L203. If a Class C rest area is required, enter the number from G210 into L-205 and make L203 equal zero. Adjust the parameters to the other elements, parking lot, road construction to and from the highway, furnishings, landscaping, lighting and signals to meet the scope and site condition of a Class A, B or C safety rest area. A lump sum value can be entered into cell H210. The total cost for Safety Rest Areas is shown in I210.

EW

August 21, 2001

ESTIMATING MANUAL

Page 50

Activity Code 5230 Tourist Rest and View Areas In Figure 9.1 a composite unit price in Cell E211 multiplied by the number of sites Cell G211 and a lump sum value in Cell H211 produces the total cost for a view area in Cell I211. Any underground utilities that are directly affected by the roadside construction indicated above and have not been estimated in the grade utilities can be estimated under the following activity codes. Activity Code 5203 Water Activity Code 5204 Sanitary Activity Code 5205 Storm These items could be drilling for water (well) or a septic field for any of the Roadside Construction elements. Review the total Roadside Construction Element costs in column I 202:216 The Roadside Construction Element estimate is complete, proceed to Step 10. STEP 10 OTHER CONSTRUCTION ELEMENT

Railway Assembly

Railroad x-ing assembly Marine Assembly

Environmental Assembly

Figure 10.1

EW

August 21, 2001

ESTIMATING MANUAL

Page 51

In figure 10.1 four major activities have been identified for this element. They are: Activity Code 5310 Railroad Main and Spur Lines Enter the length of railway required in Cell G237. This initiates a similar amount in the Railroad assembly Figure 10.1 between Cell K219 to P230. Adjust the parameters for each of the elements within the assembly to meet the scope and site conditions. The composite unit price is developed from the total assembly cost (Cell P230) divided by the length in Cell G237. A lump sum value can be entered into cell H237. The total cost for railway work is shown in I237. Activity Code 5320 Railroad Crossings Enter the number of crossing required in Cell G238. This initiates a similar amount in the railroad crossing assembly Figure 10.1 between Cell K231 to P236. Adjust the parameters for each of the elements within the assembly to meet the scope and site conditions. Two additional elements can be added to the element if required. The composite unit price is developed from the total assembly cost (Cell P236) divided by the length in Cell G238. A lump sum value can be entered into cell H238. The total cost for railway work is shown in I238. Activity Code 5330 Marine Work A composite unit price in Cell E239 multiplied by the number of sites Cell G239, and a lump sum value in Cell H239 produces the total cost for a view area in Cell I239. Due to the complexity of this activity one of the Spare Boxes can be used to identify some of the elements and parameters. Activity Code 5340 Environmental Mitigation Enter the number of Environmental Sites required in Cell G240. This initiates a similar amount in the environmental assembly Figure 10.1 between Cell K247 to P255. Adjust the parameters for each of the elements within the assembly to meet the scope and site conditions. The composite unit price is developed from the total assembly cost (Cell P255) divided by the locations in Cell G240. Five additional elements can be added to the element if required. A lump sum value can be entered into cell H240. The total cost for environmental work is shown in I240. Any underground utilities that are directly affected by the other construction elements indicated above and have not been estimated in the grade utilities can be estimated under the following activity codes. Activity Code 5303 Water Activity Code 5304 Sanitary Activity Code 5305 Storm Review the Other Construction Element total costs in column I 230:245. The Other Construction Element estimate is complete, proceed to Step 11.

EW

August 21, 2001

ESTIMATING MANUAL

Page 52

STEP 11 UTILITY ELEMENT

Figure 11.1 Since the major construction elements were estimated, the need to supply, remove or relocate existing overhead or underground utilities are estimated in this element. These utilities (Power, Telephone, Pipelines, Telecommunication cables,etc) are not the same as the new utilities (water, sanitary and storm) described in the earlier elements. Activity Code 6710 Hydro (Power) Costs A composite unit price in Cell E60 multiplied by the length (Cell G60) and a lump sum value in Cell H60 produces the total Hydro Costs in Cell I60. For moving a transmission tower or moving a transmission line or putting a major transmission line underground, the cost is shown in cell H60. Activity Code 6711 Telephone Costs These could be overhead or underground requirements. A composite unit price in Cell E61 multiplied by the length (Cell G61) and a lump sum value in Cell H61 produces the total Telephone Costs in Cell I61. Activity Code 6712 Pipeline Costs These could be oil or gas pipelines. A composite unit price in Cell E64 multiplied by the length (Cell G64) and a lump sum value in Cell H64 produces the total Pipeline Costs in Cell I64. Activity Code 6713 Telecommunications Costs These could be overhead or underground requirements. A composite unit price in Cell E65 multiplied by the length (Cell G65) and a lump sum value in Cell H65 produces the total Telecommunication Costs in Cell I65.

EW

August 21, 2001

ESTIMATING MANUAL

Page 53

Activity Code 6714 Storm and Sewer Inspection Costs These cost are usually attributed to a project due to other agencies requiring their review of the storm and sewer installation. Cell E66 is a percent field, Cell G66 shows a value of the inspection costs, based on the estimated sanitary and storm construction costs, Cell H66 is a lump sum field and I66 shows the total cost for inspection. Activity Code 6715 Water Works Inspection Costs These cost are usually attributed to a project due to other agencies requiring their review of the waterworks installation. Cell E67 is a percent field, Cell G67 shows a value of the inspection costs, based on the estimated waterworks construction costs, Cell H67 is a lump sum field and I67 shows the total cost for inspection. Activity Code 6716 Engineering Services Costs These cost are usually attributed to a project due to other agencies requiring their review of the civil works. A composite unit price in Cell E68 produces a value in Cell G68 based on segment length of G7 (In the header). A lump sum may be added in Cell H68 and the total cost is shown in cell I68. Activity Code 6717 Parks/Recreation Costs These cost are usually attributed to a project due to other agencies requiring their review of the Park/Recreational construction. A composite unit price in Cell E69 produces a value in Cell G69 based on segment length of G7 (In the header). A lump sum may be added in Cell H-69 and the total cost is shown in cell I69. Activity Code 6718 Transit Costs Special transit requirements are sometimes necessary in constructing a highway. These costs are captured in this activity. A composite unit price in Cell E70 produces a value in Cell G70 based on segment length of G7 (In the header). A lump sum may be added in Cell H70 and the total cost is shown in cell I70. Activity Code 6719 Traffic Operations/Signs Costs These cost are usually attributed to a project due to other agencies requiring their review of the activity. A composite unit price in Cell E71 produces a value in Cell G71 based on segment length of G7 (In the header). A lump sum may be added in Cell H71 and the total cost is shown in cell I71. Review the Utility Element total costs in column I- (60:77). The Utility Element estimate is complete, proceed to Step 12.

EW

August 21, 2001

ESTIMATING MANUAL

Page 54

STEP 12 DESIGN AND SUPERVISION ELEMENT

Figure 12.1 EW

August 21, 2001

ESTIMATING MANUAL

Page 55

DESIGN AND SUPERVISION ELEMENT Design and Supervision costs are based on a percentage of construction. It is necessary to adjust these costs to meet this project’s requirements. These design and supervision costs vary depending on the approach defined by the project manager or client. Here are samples of different approaches. · A project designed by one group and supervised by another group. · A project designed and supervised by one group · A project designed and built by one group with client overview. · A project in partnership where costs are shared. · All of the above costs could vary, depending on whether the work is done by ministry or by the private sector. A percentage should be used to calculate all the activities in Figure 12.1 to establish a base cost. These percentages should remain constant for the remainder of the project. These percentages can be adjusted after the project is completed and total engineering and supervision costs are reviewed. Any of the activities in Figure 12.1 can be adjusted by linking the entire estimate sheets together and adjusting the activity percentage. Hold down the Ctrl or Shift key and click on each tab to link estimates. Click on the tabs that require adjustment only. Figure 12.1 shows all the design and supervision costs for each of the elements in the estimate sheet. Here is some general information about these elements in figure 12.1. · Column B shows the activity codes for each activity item. · Column C shows and describes each element. · Column D describes the activity code (Design, Contingency and Supervision Elements). · Column E shows the percentage used for each activity. · Column G shows the percentage value based on the different elemental construction cost. · Column H shows the lump sum value. · Column I shows the calculated value from columns G and H. · Column J shows the cost per lineal meter of each activity line in respect to the segment length G7.

EW

August 21, 2001

ESTIMATING MANUAL

Page 56

DESIGN AND CONTINGENCY All design and contingency activities are designated to Activity Code 3500 Cell B257. Total Detailed Design Costs are shown in Cell I262. In summary the following activities are associated with Detailed Design Costs. Activity Code Cell Element Sub-element 3510 B106 Grade Construction Design 3519 B107 Grade Construction Design Contingency 3520 B143 Structural Construction Design 3529 B144 Structural Construction Design Contingency 3560 B167 Paving Construction Design 3569 B168 Paving Construction Design Contingency 3540 B190 Operational Construction Design 3549 B191 Operational Construction Design Contingency 3550 B218 Road Side Construction Design 3559 B219 Road Side Construction Design Contingency 3570 B247 Other Construction Design 3579 B248 Other Construction Design Contingency 3530 B259 Geotechnical Design 3539 B260 Geotechnical Design Contingency Extra Geotechnical costs are shown in the lump sum Cell H259. These costs are normally greater than the general percentage allocated in cell E259. The parameters are defined as follows under: Bridges Cell K258 Number of Bridges Cell K257 Cost per Bridge Cell K259 Tunnels Cell L258 Number of Tunnels Cell L257 Cost per Tunnel Cell L259 Specials Cell M258 Number of Specials Cell M257 Cost per Special Cell M259 Due to cell linkage, a percentage change in the Grade Construction Design Cell B106, will result in a change in Paving Cell B167, Operational Cell B190 and Other Construction Cell B247. All contingencies are linked to the header percentage Cell G-4. Each of these activities can be change and indicated in RED with a comment inserted for reference.

EW

August 21, 2001

ESTIMATING MANUAL

Page 57

SUPERVISION AND CONTINGENCY All supervision and contingency costs are designated to Activity Code 6800 (Cell B264). Total Supervision Costs are shown in Cell I-266. The following activities are associated with Supervision Costs. Activity Code Cell Element Sub-element 6810 B108 Grade Construction General Supervision 6811 B109 Grade Construction Quality Assurance 6812 B110 Grade Construction Surveying 6819 B111 Grade Construction Supervision Contingency 6820 6821 6822 6829

B145 B146 B147 B148

Structural Construction Structural Construction Structural Construction Structural Construction

General Supervision Quality Assurance Surveying Supervision Contingency

6860 6861 6862 6869

B169 B170 B171 B172

Paving Construction Paving Construction Paving Construction Paving Construction

General Supervision Quality Assurance Surveying Supervision Contingency

6840 6841 6842 6849

B192 B193 B194 B195

Operational Construction Operational Construction Operational Construction Operational Construction

General Supervision Quality Assurance Surveying Supervision Contingency

6850 6851 6852 6859

B220 B221 B222 B223

Road Side Construction Road Side Construction Road Side Construction Road Side Construction

General Supervision Quality Assurance Surveying Supervision Contingency

6870 6871 6872 6879

B249 B250 B251 B252

Other Construction Other Construction Other Construction Other Construction

General Supervision Quality Assurance Surveying Supervision Contingency

No cells are linked, each cell is different in percentage. Review the Detailed Design and Supervision total costs in all the elements and in the summary. The Detail Design and Supervision estimated costs are complete, proceed to Step 13.

EW

August 21, 2001

ESTIMATING MANUAL

Page 58

STEP 13 LAND ELEMENT

Figure 13.1

Land is divided into three major components. 1. Acquisition of Land. 2. Associated Cost in purchasing the land. 3. Contingency. Acquisition of Land Activity Code 4010 Description of work (Cell D314). As market or income-appraised value, right-of-way value, severance value, improvement value, easement cost, timber costs, deduction/special benefits. The total purchase price of land Cell I314 is developed from the following elements. 1. Residential Property Cell E314 shows the average cost per residential property Cell G314 indicates the number of residential property required to be purchased. Cell H314 is the lump sum value for residential properties. 2. Commercial Property Cell E315 shows the average cost per commercial property Cell G315 indicates the number of commercial properties to be purchased. Cell H315 is the lump sum value for commercial properties.

EW

August 21, 2001

ESTIMATING MANUAL

Page 59

3. Right-of-way property for the highway. Cell M316 indicates the Planned Right-of-way in hectares (ha), based on the parameters defined in the grading element. Cell M317 indicates the required right-of-way for this estimate. This cell is defaulted to equal the Planned Right-of-way Cell M316. This cell can be changed and indicated in RED with a comment inserted for reference. Cell M318 shows the cost land per hectare. For information purposes, the entered cost per hectare in Cell M-318, automatically provides costs in different units: Cost per meter squared in Cell M319, Cost per Acre in Cell M320 and Cost per Square Foot in Cell M321. For information purposes only, an entered Cost per Square Ft. in Cell N321 provides equivalent cost for different unit of measures. Associated Costs The percentage for associated costs relative to the total acquisition costs is shown in Cell K322. This percentage can vary from 20% to 40%. See details below. Activity Code 4020 Description of work (Cell D317). Owner’s entitlements, 5% total take under one acre/3months rent, mortgage penalty, relocation costs, injurious affection, business disturbance, general disturbance, owner’s executive time, property purchase tax, tax adjustments on H12. A percentage in Cell E317 produces a value in Cell G317, based on acquisition cost in cell I315. A lump sum may be added in Cell H317 and the total cost is shown in cell I315. Cell J317 shows the cost per lineal meter for the segment length G7. Activity Code 4030 Description of work (Cell D318). Lump sum owners costs, owners appraisal, owner’s legal costs, interests (Sec,45E.A.) A percentage in Cell E318 produces a value in Cell G318, based on acquisition cost in cell I315. A lump sum may be added in Cell H318 and the total cost is shown in cell I318. Cell J318 shows the cost per lineal meter for the segment length G7. Activity Code 4040 Description of work (Cell D319). Demolition Costs. Clean up of certain sites could be very expensive based on Current Environmental Regulations. A percentage in Cell E319 produces a value in Cell G319, based on acquisition cost in cell I315. The lump sum value in Cell H319 is a product of the number of properties in Cell G314 and G315 and the demolition average unit price per

EW

August 21, 2001

ESTIMATING MANUAL

Page 60

property in Cell M323. The total cost is shown in cell I318. Cell J318 shows the cost per lineal meter for the segment length G7. Activity Code 4050 Description of work- Property Management, property taxes, utilities, security-Moth, acquisition fees. A percentage in Cell E320 produces a value in Cell G320, based on acquisition cost in cell I315. A lump sum may be added in Cell H320 and the total cost is shown in cell I320. Cell J320 shows the cost per lineal meter for the segment length G7. Activity Code 4080 Description of work- Moth staff salaries, travel voucher’s, other reports Moth, contractor’s salary, MOTH appraisals. A percentage in Cell E323 produces a value in Cell G323, based on acquisition cost in cell I315. A lump sum may be added in Cell H323 and the total cost is shown in cell I323. Cell J323 shows the cost per lineal meter for the segment length G7. Activity Code 4090 Description of work- Legal Survey A percentage in Cell E324 produces a value in Cell G324, based on acquisition cost in cell I315. The lump sum value in Cell H324 is a product of the number of properties in Cell G314 and G315 and the average survey unit price per property in Cell M324. The total cost is shown in cell I324. Cell J324 shows the cost per lineal meter for the segment length G7. Contingency Activity Code 4099 This percentage in Cell E-331 is linked to the land contingency in the header Cell H-4 A percentage in Cell E331 produces a value in Cell G331 based on acquisition cost in cell I-315 and the associated cost in cell I329. A lump sum may be added in Cell H331 and the total cost is shown in cell I331. Cell J331 shows the cost per lineal meter for the segment length G7. Review the Land Element total costs in column I- (313:333). The Land Element estimate is complete, proceed to Step 14.

EW

August 21, 2001

ESTIMATING MANUAL

Page 61

STEP 14 PLANNING AND PRELIMINARY DESIGN ELEMENTS

Figure 14.1 ·

It is preferable to estimate Planning and Preliminary Design Costs with each estimate; however these elements can be prepared as a stand-alone estimate in conjunction with Project Management, Management Reserve and Escalation elements.

·

In Figure 14.1 the Planning, Preliminary and Functional Design elements are not derived from a percentage based number. They are based on a composite unit price per lineal meter of the segment length. The total project Planning and Preliminary cost are summarised in the project summary sheets.

EW

August 21, 2001

ESTIMATING MANUAL

·

Page 62

Each of the elements in Figure 14.1 is separated into two components, Consultants and Ministry. It is important to find out from the client whether all costs, including past expenditures are part of the total project costs. A project could be have shared responsibilities and estimating in the two components may be advisable to establish funds for each group.

PLANNING ELEMENT Activity Code 2500 Activity Code 2521 A composite unit price in Cell E13 produces a value in Cell G13, based on segment length of G7 (In the header). A lump sum may be added in Cell H13 and the total cost is shown in cell I13. This is similar for Activity Code 2531,2541,2510,2520,2530, and 2540. Activity Code 2502 and 2501 are percentage calculated general items, that could carry any extra expenditures in the lump sum cell H16 and H23 if required. PRELIMINARY DESIGN Activity Code 3000 Activity Code 3013 A composite unit price in Cell E31 produces a value in Cell G31 based on segment length of G7 (In the header). A lump sum may be added in Cell H31 and the total cost is shown in cell I31. This is similar for Activity Code 3014,3015,3021,3061, & 3071 (in the Consultants component). This is similar for Activity Code 3010,3011,3012,3020,3060, & 3070 (in the Ministry’s component). Activity Code 3002 and 3001 are percentage calculated general item, that could carry any past expenditures in the lump sum cell H40 and H52 if required. Functional costs are also included in the Preliminary element. They are represented by Activity Codes 3031,3041 and 3051 in the Consultants component, and Activity Codes 3030, 3040 and 3050 in the Ministry’s Component. Exception to the above. A percentage parameter in Cell L37 provides a value in the lump sum cell H37, based on the total structural element cost. A unit price per property in Cell L39 provides a value in the lump sum cell H39, based on the number of purchased residential properties. Review the Planning Element total costs in column I- (13:28). Review the Preliminary Element total costs in column I- (31:57) The Planning and Preliminary estimates are complete, proceed to Step 15.

EW

August 21, 2001

ESTIMATING MANUAL

Page 63

STEP 15 PROJECT MANAGEMENT ELEMENT

Figure 15.1 General Information It is preferable to estimate Project Management Costs with each estimate; however, this element can be prepared as a stand-alone estimate in conjunction with Planning and Preliminary Design, Management Reserve and Escalation elements. In this methodology, Project Management Costs are only calculated based on construction and engineering cost shown in Cell I280. Exception Management of Land is not included in the total above. Including Land in Project Management Costs An adjustment to the formula is required in cell G283. Existing Formula = (E283*$I$280) New Formula = (E283*($I$280+$I$333)) Copy this formula to the following cells G284,285,289,290,291,295,296,297,301 and 305. Make these cells RED.

EW

August 21, 2001

ESTIMATING MANUAL

Page 64

There are six major components defined in Project Management Costs. 1. Consultant’s Project Management Costs. 2. Ministry of Transportation Project Management Costs. 3. Public Relations or Communication Costs. 4. Legal Costs. 5. Insurance Costs. 6. Contingency Project Management Activity Code 2000 Activity Code 2060 A percentage in Cell E283 produces a value in Cell G283, based on total construction costs in Cell I280. A lump sum may be added in Cell H283 and the total cost is shown in Cell I280. This is similar for Activity Code 2062,2063,2010,2012,2030,2070,2072,2073,2040 and 2080. Activity Code 2061 Each major component has a general activity. A percentage in Cell E286 produces a value in Cell G286 based on total component costs. A lump sum may be added in Cell H286 and the total cost is shown in Cell I286. This is similar for Activity Code 2011,2071,2041 and 2081. Activity Code 2099 Contingency A percentage in Cell E309 produces a value in Cell G309, based on the sum of total component costs. A lump sum may be added in Cell H309 and the total cost is shown in Cell I309. Review the Project Management Element total costs in column I- (282:311) The Project Management estimate is complete, proceed to Step 16.

EW

August 21, 2001

ESTIMATING MANUAL

Page 65

STEP 16 MANAGEMENT RESERVE ELEMENT

Figure 16.1 General Information · All of the management reserve costs are lumped into one Activity Code 9800. ·

It is preferred to estimate Management Reserve Costs with each estimate, however this element can be prepared as a stand-alone estimate in conjunction with Planning and Preliminary Design, Project Management and Escalation elements.

·

Management Reserve is NOT a contingency. It is an allocation of funds to manage scope changes, cost pressures, inflation cost, or any other political requests beyond the estimated scope of a project.

·

When reviewing the Risks associated with each element, a value can be entered into the lump sum cell adjacent to the element in Column H.

·

In Figure 16.1 the percentage indicated are linked to cell G3 in the header. Each of the elements can be modified based on information available when the estimate was prepared. Make that cell RED.

·

In the Planning Element a percentage in Cell E336 produces a value in Cell G336 based on total cost of that element. A lump sum may be added in Cell H336 and the total cost is shown in Cell I336. This typical for all the remaining elements.

EW

August 21, 2001

ESTIMATING MANUAL

Page 66

Review the Management Reserve Element total costs in column I- (336:351) The Management Reserve estimate is complete, proceed to Step 17. STEP 17 ESCALATION ELEMENT

Figure 17.1 General Information · All of the escalation values are lumped into Activity Code 9900. ·

Escalation element should be prepared as a stand-alone estimate or it can be in conjunction with Planning and Preliminary Design, Project Management and Management Reserve elements.

·

The current prepared estimate in based on a constant year dollars shown in the header Figure 2.1 Cell C5. If a project is scheduled over a number of years and a project end cost is required, it is important to define how much work will be completed in each year and what the escalation rate should be for each year.

EW

August 21, 2001

ESTIMATING MANUAL

Page 67

Escalation Calculation 1. The value of work is shown in Cell G353. Normally it is zero, link this cell to H353 to get the project costs. If this is a stand-alone estimate, this value must be acquired by summing all the values from the different estimates in Cell H353 and entering the sum in G353. 2. Define project duration in years. Figure 17.1 indicates a 5 year project. Column E. 3. Define the percentage of work to be completed in each year. The sum of all the percentages must equal to 100% in cell E367. Column E and the total project cost in cell G367 must equal cell G353. 4. Establish the escalation rate for each year in Column D. The total escalation for the project is shown in I367. Review the Escalation Element total costs in column I- (357:367) The Escalation estimate is complete, proceed to Step 18.

EW

August 21, 2001

ESTIMATING MANUAL

Page 68

Step 18 SUMMARY PAGE

FIgure 18.1

EW

August 21, 2001

ESTIMATING MANUAL

Page 69

The summary page in Figure 18.1 has three important pieces of information. First, the major activities are summarised between lines 377 and 409. Contingency has been stripped from these major activities and combined in the contingency activity item, line I400. The cost per lineal meter of road (Estimate Length G7) is shown in column J379 to J410. The percentage of the Total and the percentage of the Total Cost for each activity are shown in columns K and L. For information purposes only, Line 411 shows construction costs less supervision cost. Second, the estimate is reported into five major categories with the corresponding contingency allocated to them and that is shown between lines 413 to 418. Thirdly, some general information about the estimate is shown between lines 422 and the end of the sheet. If any specific information about the estimate requires to be documented, that information can be typed in the note field. After completing the first estimate, save and print the estimate. Review the costs of the estimate to see if the costs make sense. Adjust quantities or prices to make sure the estimate is reasonable. The estimate is complete, proceed to Step 19 See Page 19.

EW

August 21, 2001

ESTIMATING MANUAL

Page 70

STEP 22 LINKING ALL THE ESTIMATES INTO THE SUM OF ESTIMATE WORKSHEET.

Figure 22.1

Figure 22.2 General Information · In the File/Page Setup Correct the header and footer in the worksheet (if not done previously) and rename the summary as required. Keeping the tab names short will help in the linking process. · In Figure 22.1 correct Col’s. B,C,D and J Between rows 3 and10. Some of these cells are linked to the first estimate EST-1BLANK. If these cell require corrections, make them in the first estimate sheet instead, otherwise make a manual correction to the summary. Linking Estimates · In the summary sheet SUMOFEST (Figure 22.1) in column E, the first estimate EST-1BLANK is linked to the summary. Changing the estimate name in the worksheet tab automatically changes the name of the linked estimate in the SUMOFEST Column E. · Inserting a column in any summary must take place between Columns E and H. Column J sums all information between Columns E and H inclusive. DO NOT insert Columns before Column E or after Column H. This will result in the values in these columns not being added to the total in Column J.

EW

August 21, 2001

ESTIMATING MANUAL

· · · · ·

Page 71

Copy Column E to Column F and G. Place cursor on cell F4. Then go to Toolbar bar Edit/Replace and Figure 22.2 will appear. Go to Find what: and enter the sheet or tab name that is shown in Cell F4. Example ‘EST-1BLANK’ (Enter the information between the single quote marks only). Go to Replace with: and enter exactly the new tab name between the single quote marks. Make sure there are no extra spaces, it must be exact. Then close screen. Place cursor on grey box at top of Column F. This will highlight the column. Go to the Toolbar Edit/Replace all information previously entered should still be there. Hit the replace button and watch the cursor in Column F move from Cell 3 to Cell 4. If this is successful then hit the Replace All button and the second estimate is linked in the summary sheet. If an error occurred when the replace button was hit, hit the Close button and check the typing and spaces in the Find what and Replace lines.

DIFFERENCE BETWEEN THE SUMOFEST AND SUMOFSUM Both summaries are similar from row 1 to row 417. The differences are: SUMOFEST – The summary information between row 418 and 459 is linked to the detailed information within each estimate worksheet. SUMOFSUM – The summary information between row 418 and 459 is linked to the summary column similar to the information in rows 1 to 417.

EW

August 21, 2001

ESTIMATING MANUAL

Page 72

LINKING SUMMARY WORKSHEETS All summaries have different amount of estimates within them, therefore the total or sum column Column J in figure 22.1 will constantly be changing. The column that represents the total value, is the column that needs to be indicated in the link formula.

Figure 22.2 In SUMOFSUMS tab Figure 22.2 Column E shows that the first summary is linked. As indicated before in using the Edit/Replace command, the column reference must be modified. Example Find what: =SUMOFEST!$J Replace with: =NEWNAME!$M M is assumed to be the new column total.

EW

August 21, 2001

ESTIMATING MANUAL

Page 73

LINKING ESTIMATES TO MAKE GLOBAL CHANGES Linking estimates provides the estimator the ability to make adjustments to a unit price in a particular cell on a specific estimate sheet or in a group of estimate sheets, or to all the estimate sheets for the entire project. The changes can be made to the sheets that appear in one workbook (File) only. Go to the cell in the first worksheet that requires adjustment in the workbook and than: · To select a specific group of worksheets hold down the Crtl Button on the Key board and with the cursor click on the desired tabs at the bottom of the workbook. Each of these tabs will light up. Make the necessary adjustments to the required cell on one sheet and press enter. All worksheet have a new value in the adjusted cell. BE CAREFUL if you made a previous change in that cell on any sheet, this command will override that value. Click on a different tab and the linked tabs will unlink. Make sure the tabs are unlinked before making any changes to any worksheets otherwise all subsequent changes will take place in the linked worksheets as well. · To select all the worksheets for a project hold down the Shift Button on the Key board and with the cursor click on the last estimate tab of the project. All the tabs will light up. Make the necessary adjustments to the required cells and press enter. All worksheet have a new value in the adjusted cell. BE CAREFUL if you made a previous change in any cell, this command will over ride that value. Click on a different tab and the linked tabs will unlink. Make sure the tabs are unlinked before making any changes to any worksheets otherwise all changes will take place in all estimate sheets .

Appendices Standard Estimate Worksheet ………………………………… Summary of Estimates Report…………………………………. Summary of Summaries Report……………………………….. Difference Report ……………………………………………….. Activity Item List………………………………………………….. Activity Item Description …………………………………………

EW

August 21, 2001

A B C D E F

ESTIMATING MANUAL

Page 74

Appendix A Standard Estimating Worksheet

EW

August 21, 2001

APPENDIX A

PRINTING DATE: 12/18/02

B 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

C

D

E:\Data\Cost Estimating\CE System\CE Tools\Wolski\Version 6.1\[Appendices

E

F

G

H

5.0% Land Company Job 15.0% 15.0% (2001 Dollars) Job EST# 1 ACTIVITY Job 5 CODE EST.DATE May. 1, 2001 1000 L.M. Conceptual Est. R1 DATE: ======= Blk Est. # 6 R2 DATE: Unit Cost-Quant. Lump Sum Version May.2./01 DESCRIPTION Price Unit PerSection Values ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------2500 PLANNING 2521 Consultant - transport. planning study 0.00 LM 0 2531 Consultant - corridor study 0.00 LM 0 2541 Consultant - functional plan. study 0.00 LM 0 2502 Consultant - general 0.0% 0 File:

Man. Reserve Contingency Division/Site Road Type Length

Consultant sub-total ----------- --------------- ----------------------------------------- --------------- ----- ------------- ----------------2510 Ministry - project ident. 0.00 LM 0 2520 Ministry - transport. planning study 0.00 LM 0 2530 Ministry - corridor study 0.00 LM 0 2540 Ministry - functional study 0.00 LM 0 0 2501 Ministry - general 0.0% 0 Ministry Sub-total 0 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------2599 Planning Contingency 15.0% 0 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------====== 3000 3013 3014 3015 3021 3031 3041 3051 3061 3071 3002

TOTAL PLANNING ======= ======================= ======== === ======= ========= PRELIMINARY DESIGN Consultant - aerial base plan 0.00 LM 0 Consultant - mapping & prel. 10.00 LM 10000 Consultant - control survey 0.00 LM 0 Consultant - environmental impact 3.00 LM 3000 Consultant - funct.-road field survey 8.00 LM 8000 Consultant - functional design 5.00 LM 5000 0 Consultant - funct. des. structural 0.00 LM 0 28332 Consultant - geotechnical design 3.00 LM 3000 Consultant - right-of-way research 0.00 LM 0 0 Consultant - general 0.0% 0

Consultant sub-total ----------- --------------- ----------------------------------------- --------------- ----- ------------- ----------------3010 Ministry - aerial base plan 0.00 LM 0 3011 Ministry - mapping 0.00 LM 0 3012 Ministry - control survey 0.00 LM 0 3020 Ministry - environmental impact 0.00 LM 0 3030 Ministry - funct.-road field survey 0.00 LM 0 3040 Ministry - functional design 0.00 LM 0 3050 Ministry - funct. des. structural 0.00 LM 0 3060 Ministry - geotechnical design 0.00 LM 0 3070 Ministry - right-of-way research 0.00 LM 0 3001 Ministry - general 0.0% 0 Ministry Sub-total ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------3099 Preliminary design Contingency 15.0% 8600 ----------- -------------- ----------------------------------------- --------------- ----- ------------- -----------------

TOTAL PRELIMINARY DESIGN

====== ======= ======================= ======== === ======= =========

3:00 PM

Page 1

I

J

K

L

4 lane name description station limit station limit EST# 1

4 lane Road Types name 1. 2ln Frontage descriptio2. 2ln Acc Rds station lim3. 4ln Acc Rds SITE C/LM4.R4L-4L EXP R/B EST# 1 5.R2/3L-4L EXP R/B 5 5 6.Retr.4L-4LEX R/B 1000 1000 7.R4L-4LEX R/B E/S MR ----------- 8. New 4L EXP R/B

0 0 0 0 0 ----------------------0 0 0 0 0 0 ----------------------0 ----------------------0 =============

0 Description 0 0 0 0 ----------0 0 0 0 0 0 ----------- Description 0 ----------0 ======

0 10,000 0 3,000 8,000 5,000 28,332 3,000 0 0 57,332 ----------------------0 0 0 0 0 0 0 0 0 0 0 ----------------------8,600 ----------------------65,932 =============

0 10 0 3 8 5 28 Structural 0.50% 3 0 $/Prop. $ 150 0 Description No. 57 ----------0 0 0 0 0 0 0 0 0 0 0 ----------9 ----------66 ======

ESTIMATED BY :E.WOLSKI

No.

M

N

9. R-E4L-4L D/M 10.N 4L EXP D/M 11.N 4L EXP D/E/M 12.N2L;F4LEXP D/M 13.INST.R/B-EX.RD 14.AS IS 15. Misc. 20.I/C Str.&Ramps 21. Bridges 22. Grade Sep. Units

Quantity

O

P

9,988,520

Rate

Total -

Description

No.

Units

Quantity

Rate

Total -

Description

Units

Quantity

Description

Rate

Total -

APPENDIX A

PRINTING DATE: 12/18/02

B 3 4 5 6 7 8 9 10 11 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115

C

D

E:\Data\Cost Estimating\CE System\CE Tools\Wolski\Version 6.1\[Appendices

E

F

G

H

5.0% Land Company Job 15.0% 15.0% (2001 Dollars) Job EST# 1 ACTIVITY Job 5 CODE EST.DATE May. 1, 2001 1000 L.M. Conceptual Est. R1 DATE: ======= Blk Est. # 6 R2 DATE: Unit Cost-Quant. Lump Sum Version May.2./01 DESCRIPTION Price Unit PerSection Values ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------6700 UTILITIES 6710 Util. Prov. - Hydro 10.00 lm 1000 0 6711 Util. Prov. - Telephone 20.00 lm 1000 0 Util. Prov. sub-total ----------- --------------- ----------------------------------------- --------------- ----- ------------- ----------------6712 Util.Others - pipelines 0.00 lm 0 6713 Util.Others - telecommunication 0.00 lm 0 6714 Util.Others - storm & sewer inspect. 0.0% 0 6715 Util.Others - waterworks inspect. 0.0% 0 6716 Util.Others - engineering services 0.00 LM 0 6717 Util.Others - parks/recreation-prel. 0.00 LM 0 6718 Util.Others - transit 0.00 LM 0 6719 Util.Others - tr-ops/signs & detours 0.00 LM 0 6701 Util.Others - general 0.0% 0 Util.Others sub-total ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------6799 Util.Others Contingency 15.0% 4500 0 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------TOTAL UTILITIES ====== ======= ======================= ======== === ======= ========= 5000 GRADE CONSTRUCTION U. Price Unit Quantity Lump Sum 5032 Grade Cons- water 225.00 lm 0 0 5033 Grade Cons- sanitary 150.00 lm 0 0 5034 Grade Cons- storm 175.00 lm 0 5031 Grade Cons- mobilization 3.0% 0 5039 Grade Cons- utility contingency 15.0% 0 File:

Man. Reserve Contingency Division/Site Road Type Length

Grade Const. Utilities Sub-total 5010 5020 5030 5040 5050 5051 5060 5061 5062 5063 5064 5090 5005 5001 5099

Grade Cons- site prep./clear,grubbing Grade Cons- road grade/exc,placing,fill Grade Cons- drainage/pipe,cul. Grade Cons- muiltiplate Grade Cons-SGSB/produce,place,comp Grade Cons-CBC/produce,place,comp Grade Cons- grade finishing landscaping Grade Cons- grade finishing hydro seed. Grade Cons- grade finishing fencing Grade Cons- noise barriers Grade Cons- passing lanes Grade Cons- sidewalks,curb & gutter Grade Cons-detours c/w ex,bf,paving Grade Cons- mobilization Grade Cons- Contingency Grade Construction Sub-total

8,000 7.10 0.00 10000 18.00 20.00 0.00 0.40 60.00 110.00 0.00 60.00 40000 3.0% 15.0%

ha m3 LM lm m3 m3 m2 m2 lm m2 lm lm NO

4.00 47179 0 0 9693 6106 25200 25200 0 0 0 0 0.5 22691 116856

0 0 22661

0 40000

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

GRADE CONSTRUCTION COSTS ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------3510 Grade Eng. - detailed design 7.00% 62713 3519 Grade Eng. - detailed design/Contingency 15.0% 9407 6810 Grade Eng. - general const. supervision 4.60% 41211 6811 Grade Eng. - quality assurance 3.20% 28669 6812 Grade Eng. - surveying 2.00% 17918 6819 Grade Eng. - Residency Contingency 15.0% 13170 Grade Engineering Sub-total ----------- -------------- ----------------------------------------- --------------- ----- ------------- -----------------

Total Grade Const. & Eng. Costs

====== ======= ======================= ======== === ======= =========

3:00 PM

Page 2

I

J

K

L

M

N

O

4 lane Road Types 9. R-E4L-4L D/M name 1. 2ln Frontage 10.N 4L EXP D/M descriptio2. 2ln Acc Rds 11.N 4L EXP D/E/M station lim3. 4ln Acc Rds 12.N2L;F4LEXP D/M SITE C/LM4.R4L-4L EXP R/B 13.INST.R/B-EX.RD EST# 1 5.R2/3L-4L EXP R/B 14.AS IS 15. Misc. 9,988,520 5 5 6.Retr.4L-4LEX R/B 20.I/C Str.&Ramps 1000 1000 7.R4L-4LEX R/B E/S 21. Bridges MR ----------- 8. New 4L EXP R/B 22. Grade Sep. Description No. Units Quantity Rate 10,000 10 20,000 20 30,000 30 ----------------------- ----------0 0 0 0 0 0 0 0 0 0 0 0 0 0 Description 0 0 (m3) (unit $) ($) 0 0 Fill 0 0 0 Rock 852 18.00 15328 2% ----------------------- ----------O.M. 41727 7.00 292090 4,500 5 Strip. 4600 6.00 27600 0.100 ----------------------- ----------- Borrow 0 12.00 0 34,500 35 Misc./LS 0 4.00 0 Surplus Mtl ============= ====== Total 47179 7.10 335019 Spec Spec Pl/PL 0 0 4 lane 40.0 0 0 Road Road Ditch Width Ditch Width 0 0 pl to pl 40.00 0.00 2.0 0.0 0 0 *no./lane 4 0 Col L Vol. Col. M Vol. 0 0 *lane wid 3.7 0.0 47,179 0 0 *med 0.0 0.0 Pmt W= 14.8 ----------------------*shldrs tota 0.0 0.0 CBC. slope CBC. slope 32,000 32 c.b.c.(w) 16.1 0.0 3.0 0.0 335,019 335 sgsb (w) 18.7 0.0 22,661 23 SGSBslope :1 3.0 0.0 0 0 *depth(d) 1.606 0.000 15% 174,470 174 *road (l) 1000 0 122,123 122 *no.cul./kilo 5.0 0.0 $ 500 0 0 cul.(l) 23.55 0.00 $ 150 10,080 10 *sgsb (d) 0.45 0.00 15% 0 0 *cbc (d) 0.33 0.00 15% 0 0 *Add.ROW 0.00 0.00 0 0 X-m3/lm 47.18 0.00 0 0 C&G $/LM $40.00 Exp-100kmExp- 80km Coll-80kmp 60,000 60 Decel.(T-lm) 520 440 260 22,691 23 Accel.(T-lm) 950 630 80 116,856 117 Left T.(T-lm) 716 596 456 895,900 896 TOTAL 2186 1666 796 ----------------------- ----------- Gravel 2.0Tonnes/m3 895,900 896 Drainage No. Units Quantity Rate ----------------------- ----------- Box Cul. 0 lm 45 3500 62,713 63 Head Walls 0 ea. 2 5000 9,407 9 41,211 41 28,669 29 17,918 18 13,170 13 173,088 173 ----------------------- ----------1,068,987 1069 ============= ====== Drainage

P

4 lane name description station limit station limit EST# 1

ESTIMATED BY :E.WOLSKI

Total -

Neat vol.cal 0 Spec. Resurface

Road ONLY 0 0.0 0.0 0.0 A.C. (mm) 0 A.B.C. (mm) 0 0 Appl. rate 1.75

Total -

APPENDIX A

PRINTING DATE: 12/18/02

B 3 4 5 6 7 8 9 10 11 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178

C

D

E:\Data\Cost Estimating\CE System\CE Tools\Wolski\Version 6.1\[Appendices

E

F

G

H

I

5.0% Land Company Job 15.0% 15.0% (2001 Dollars) Job EST# 1 ACTIVITY Job 5 CODE EST.DATE May. 1, 2001 1000 L.M. Conceptual Est. R1 DATE: ======= Blk Est. # 6 R2 DATE: Unit Cost-Quant. Lump Sum Version May.2./01 DESCRIPTION Price Unit PerSection Values ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------File:

5500 5522 5523 5524 5521 5599

5510 5511 5512 5513

STRUCTURAL CONSTRUCTION Struct.Cons - water Struct.Cons - sanitary Struct.Cons - storm Struct.Cons - mobilization Struct.Cons - utility contingency Structural Const. Utilities Sub-total Struct.Cons Struct.Cons Struct.Cons Struct.Cons -

tunnel site preparation tunnel construction snow shed site prep. snow shed site const.

Man. Reserve Contingency Division/Site Road Type Length

Unit Price 225.00 150.00 175.00 3.0% 15.0%

Quantity Unit lm lm lm

0.00 lm 13,075 lm

0.00 lm lm

Page 3

J

K

4 lane Road Types name 1. 2ln Frontage descriptio2. 2ln Acc Rds station lim3. 4ln Acc Rds SITE C/LM4.R4L-4L EXP R/B EST# 1 5.R2/3L-4L EXP R/B 5 5 6.Retr.4L-4LEX R/B 1000 1000 7.R4L-4LEX R/B E/S MR ----------- 8. New 4L EXP R/B

Lump Sum

0 0 0 0 0

0 0 0 0 0 0 ----------------------0 0 2,615,022 0 0

0 200 0 0

0 0 0 0 0 0 0 2615 0 0

Demolition 5514 5515 5516 5517 5518 5519 5501 5529

Struct.Cons - bridge site preparation Struct.Cons - bridge piers Struct.Cons - bridge abutments Struct.Cons - bridge superstructure Struct.Cons - retain. wall site prep. Struct.Cons - retaining wall const. Struct.Cons - mobilization Struct.Cons - Contingency Structural Construction Sub-total

1 1 1 1 1 525 3.0% 15.0%

LS LS LS LS LS m2

197160 96000 237600 1638000

0

0 143513 739094

----------- -------------- ----------------------------------------- --------------- ----- ------------- --------------------------3520 3529 6820 6821 6822 6829

STRUCTURAL CONSTRUCTION COSTS -------------- ----------------------------------------- --------------- ----- ------------- ----------------Struct. Eng. - detailed design 7.50% 424979 Struct. Eng. - detailed design/Contingency 15.0% 63747 Struct. Eng. - general const. supervision 4.50% 254988 Struct. Eng. - quality assurance 3.00% 169992 Struct. Eng. - surveying 0.50% 28332 Struct. Eng. - Residency Contingency 15.0% 67997

Structural Engineering Sub-total ----------- -------------- ----------------------------------------- --------------- ----- ------------- -----------------

Total Structural & Eng. Costs ====== ======= ======================= ======== === ======= =========

197,160 96,000 237,600 1,638,000 0 0 143,513 739,094 5,666,390 ----------------------5,666,390 ----------------------424,979 63,747 254,988 169,992 28,332 67,997 1,010,034 ----------------------6,676,424 =============

197 96 238 1638 0 0 144 739 5666 ----------5666 ----------425 64 255 170 28 68 1010 ----------6676 ======

PAVING CONSTRUCTION SM./OIL machine paving asphalt 55.00 t 3730 25900 222,373 222 machine paving concrete 0.00 m2 0 0 hot reprofiling 0.00 m2 14800 0 0 shoulder paving 0.00 t 0 0 0 pavement finishing 75.00 m2 0 0 0 seal coating 0.00 0 0 mobilization 3.0% 6671 6,671 7 pavement design 0.0% 0 0 0 Contingency 15.0% 34357 34,357 34 -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------PAVING CONSTRUCTION COSTS 263,401 263 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------3560 Paving Eng - detailed design 7.00% 18438 18,438 18 3569 Paving Eng - detailed design/Contingency 15.0% 2766 2,766 3 6860 Paving Eng - general const. supervision 3.00% 7902 7,902 8 6861 Paving Eng - quality assurance 5.00% 13170 13,170 13 6862 Paving Eng - surveying 1.00% 2634 2,634 3 6869 Paving Eng - Residency Contingency 15.0% 3556 3,556 4 Paving Engineering Sub-total 48,466 48 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------Total Paving Const. & Eng. Costs 311,867 312 ====== ======= ======================= ======== === ======= ========= ============= ====== 6000 6020 6030 6040 6050 6060 6070 6001 6010 6099 -----------

L

4 lane name description station limit station limit EST# 1

Paving Con Paving Con Paving Con Paving Con Paving Con Paving Con Paving Con Paving Con Paving Con -

Brdge 1 2 3 4 5 1 2 3 4 5 DECK #1 DECK #2 DECK #3 DECK #4 DECK #5

Site $ 197,160 -

M

Piers $ 96,000 -

Pier/Ht Pier No. 8 1 0

(W) 22.40

N

9. R-E4L-4L D/M 10.N 4L EXP D/M 11.N 4L EXP D/E/M 12.N2L;F4LEXP D/M 13.INST.R/B-EX.RD 14.AS IS 15. Misc. 20.I/C Str.&Ramps 21. Bridges 22. Grade Sep.

(L) 75.00

O

9,988,520

abut. extra length (lm) 237,600 4

Abut. $

P/$/VLM Abut/$/HLM

12000

ESTIMATED BY :E.WOLSKI

10% 0% 0% 0% 0%

4500

($/m2) Net Cost 975.00 2233823 0 0 0 0

Gross/m2 Net/m2 1 Name 1529.10 1329.66 2 #DIV/0! #DIV/0! 3 #DIV/0! #DIV/0! Tnnl $/lm -Net 4 #DIV/0! #DIV/0! 13,467 5 #DIV/0! #DIV/0! Tnnl $/lm -Gross 2lnSt.w-x x-Pass.Tl shaft 15,487 1-D-Shape 2-D-Shape 1-Circle Radius-1-D 7.267 Tunnel L= 0 200 Per.S&Rf 24.32 Tun. H1 5.100 2.550 Radius m2/rkac 6.25 C.Pt. H4 1.00 1.00 1.00 Tnnl height 8.27 Tun.W 12.00 3.00 Wall Tk. Radius-2-D 2.157 RFLT. 0.250 0.250 0.250 Per.S&Rf 8.42 WLT. 0.250 0.250 SOBT m2/rkac 6.25 BST. 0.500 0.200 0.100 Tnnl height 3.16 TOBT 0.100 0.100 Exc.-m3 SOBT 0.100 0.100 Obk-m3 BOBT 0.100 0.100 Liner-m3 Items Quantity rate Total $ Avg.$/ tot-lm 1-Circle Exc.-m3 1251 100 125055 625 1191 Obk-m3 196 2625 513188 2566 170 Rk anch-Ea 126 1125 141750 709 393 Misc.-lm 200 2500 500000 2500 1257 Liner-m3 405 1050 425030 2125 10.00 Drainage-lm 200 550 110000 550 % Lighting-m 200 900 180000 900 5% Mech-m 200 2100 420000 2100 15% Misc.-lm 200 1000 200000 1000 3% 1Tonne=16.67m2/25mm 2615022 13075 snowshed 60kg=1m2/25mm 1.5L =1M2 (P) length (lm) 0.0 asphalt (T)=mm .25L =1M2 (T) Roof 1.0 A.C. 100 0 21.00 0.05 A.B.C. 0 0 0.80 $ 800.00 $Oil/Litre $0.55 5% Walls 2.0 8.00 Appl. rate 1.75 1.75 0.80 $ 1,100.00 Pavement Removal (See I155) Base 1.0 15.00 m3 $/m3 Total 0.60 $ 600.00 150 $20.00 3000 Exc.-m3 1.0 15.00 Milling 20.00 $ 60.00 m3 $/m3 Total Drainage $ 400.00 0 $80.00 0 Electrical $ 1,500.00 Mech. $ 950.00 Misc. $ 300.00 #DIV/0!

3:00 PM

P

-

APPENDIX A

PRINTING DATE: 12/18/02

B 3 4 5 6 7 8 9 10 11 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256

C

D

E:\Data\Cost Estimating\CE System\CE Tools\Wolski\Version 6.1\[Appendices

E

F

G

H

Page 4

I

J

K

L

M

N

O

5.0% Land 4 lane 4 lane Road Types 9. R-E4L-4L D/M Company Job 15.0% 15.0% name name 1. 2ln Frontage 10.N 4L EXP D/M (2001 Dollars) Job EST# 1 description descriptio2. 2ln Acc Rds 11.N 4L EXP D/E/M ACTIVITY Job 5 station limit station lim3. 4ln Acc Rds 12.N2L;F4LEXP D/M CODE EST.DATE May. 1, 2001 1000 L.M. station limit SITE C/LM4.R4L-4L EXP R/B 13.INST.R/B-EX.RD Conceptual Est. R1 DATE: ======= EST# 1 EST# 1 5.R2/3L-4L EXP R/B 14.AS IS 15. Misc. 9,988,520 Blk Est. # 6 R2 DATE: Unit Cost-Quant. Lump Sum 5 5 6.Retr.4L-4LEX R/B 20.I/C Str.&Ramps Version May.2./01 DESCRIPTION Price Unit PerSection Values 1000 1000 7.R4L-4LEX R/B E/S 21. Bridges ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------MR ----------- 8. New 4L EXP R/B 22. Grade Sep. 6500 OPERATIONAL CONSTRUCTION Pole Sp. (lm) No. of Sides Length 6510 Operat.Con - lighting 5500.00 Ea 0 0 0 55 0 1000 6520 Operat.Con - signals Ea 0 0 0 0 Signals No. Units Quantity Rate 6530 Operat.Con - signing 2.00 LM 2000 2,000 2 Controller 0 ea 1 25,000.00 6540 Operat.Con - guard rail 70.00 lm 0 0 0 0 Sig, pol,base 0 ea 4 15,000.00 6550 Operat.Con - pavement markings 1.75 lm 5000 0 8,750 9 Wiring U/G 0 ls 1 10,000.00 6501 Operat.Con - mobilization 3.0% 323 323 0 6599 Operat.Con - contingency 15.0% 1661 1,661 2 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------OPERATIONAL CONSTRUCTION COSTS 12,733 13 Signals ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------- LP $/lm $ 1.00 Refl. Sp. 20.00 3540 Operat. Eng- detailed design 7.00% 891 891 1 Ext. Lines 1.0 Refl.$/ea $ 15.00 3549 Operat. Eng- detailed design/Contingency 15.0% 134 134 0 Weighscale No. Units Quantity Rate 6840 Operat. Eng- general const. supervision 6.00% 764 764 1 Buildings 0 m2 60 2,800.00 6841 Operat. Eng- quality assurance 2.00% 255 255 0 Pit & Apron 0 m2 120 400.00 6842 Operat. Eng- surveying 1.00% 127 127 0 S&I W/S 0 ea 1 80,000.00 6849 Operat. Eng- Residency Contingency 15.0% 172 172 0 Parking Lot 0 m2 9000 40.00 Operational Enginering Sub-total 2,343 2 Road Const. 0 lm 1,500 400.00 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------light/signs 0 ls 1 50,000.00 Total Operational Const. & Eng. Costs 15,076 15 ====== ======= ======================= ======== === ======= ========= ============= ====== Weighscale Unit Quantity Lump Safety Rest 5200 ROAD SIDE CONSTRUCTION Price Unit Sum Area No. Units Quantity Rate 5203 RoadSide C- water 225.00 lm 0 0 0 Class A&B SAFETY REST AREAS 5204 RoadSide C- sanitary 150.00 lm 0 0 0 Buildings 0 m2 100 3,000.00 5205 RoadSide C- storm 175.00 lm 0 0 0 Class C 5202 RoadSide C- mobilization 3.0% 0 0 0 Site/toilets 0 ea 2 12,500.00 5209 RoadSide C- Utility Contingency 15.0% 0 0 0 Parking Lot 0 m2 2500 40.00 Road Side Const. Utilities Sub-total 0 0 Road Const. 0 lm 800 350.00 ----------------------Furnishings 0 ls 10,000.00 5210 RoadSide C- weighscales ea 0 0 0 0 Landscaping 0 ls 1 5,000.00 5220 RoadSide C- safety rest areas ea 0 0 0 0 light/signs 0 ls 50,000.00 5230 RoadSide C- tourist rest & view areas 40000 ea 0 0 0 0 5201 RoadSide C- mobilization 3.0% 0 0 0 SAFETY REST AREAS 5299 RoadSide C- Contingency 15.0% 0 0 0 Description No. Units Quantity Rate Road Side Construction Sub-total 0 0 0 0 0 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------0 0 ROAD SIDE CONSTRUCTION COSTS 0 0 0 0 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------0 0 3550 RoadSide E - detailed design 10.00% 0 0 0 Description 3559 RoadSide E - detailed design/Contingency 15.0% 0 0 0 Railway No. Units Quantity Rate 6850 RoadSide E - general const. supervision 6.00% 0 0 0 Removal 1000 tklm 1.00 21.00 6851 RoadSide E - quality assurance 2.00% 0 0 0 Track Cnst. 1000 tklm 1.00 320.00 6852 RoadSide E - surveying 1.00% 0 0 0 Ballast 1000 m3 1.13 35.00 6859 RoadSide E - Residency Contingency 15.0% 0 0 0 Sub-ballast 1000 m3 0.96 25.00 Road Side Engineering Sub-total 0 0 l Resurfacing 1000 tklm 1.00 10.00 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------Tie-ins 0 ea 1.00 2800.00 Total Road Side Const. & Eng. Costs 0 0 Turnout # 9 0 ea 1.00 35000.00 ====== ======= ======================= ======== === ======= ========= ============= ====== Others 0 ls 1.00 0.00 Unit Quantity Lump 0 5300 OTHER CONSTRUCTION Price Unit Sum Earthworks (see grading) 1000 lm 1 0.00 5303 Other Const- water 225.00 lm 0 0 0 Railway 5304 Other Const- sanitary 150.00 lm 0 0 0 R/rd X-ing No. Units Quantity Rate 5305 Other Const- storm 175.00 lm 0 0 0 Planks 0 tklm 45 1750.00 5302 Other Const- mobilization 3.0% 0 0 0 Sig./gates 0 each 1 200,000 5309 Other Const- utility contingency 15.0% 0 0 0 Other Const. Utilities Sub-total 0 0 ----------------------R/rd X-ing 5310 Other Const- railroads main & spur lines 414.55 lm 1000 414,550 415 Description No. Units Quantity Rate 5320 Other Const- railroad crossings ea 0 0 0 5330 Other Const- marine work ea 0 0 0 5340 Other Const- environmental mitigations ea 0 0 0 5301 Other Const- mobilization 3.0% 12436 12,436 12 5399 Other Const- Contingency 15.0% 64048 64,048 64 Other Construction Sub-total 491,034 491 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------OTHER CONSTRUCTION COSTS 491,034 491 Description ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------3570 Other Eng. - detailed design 7.00% 34372 0 34,372 34 Environmenta No. Units Quantity Rate 3579 Other Eng. - detailed design/Contingency 15.0% 5156 5,156 5 Mitigation 0 ls 1 50,000 6870 Other Eng. - general const. supervision 3.00% 14731 0 14,731 15 Ponds 0 ea 2 40,000 6871 Other Eng. - quality assurance 3.00% 14731 14,731 15 6872 Other Eng. - surveying 3.00% 14731 14,731 15 6879 Other Eng. - Residency Contingency 15.0% 6629 6,629 7 Other Engineering Sub-total 90,350 90 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------Total Other Const. & Eng. Costs 581,385 581 Environmental ====== ======= ======================= ======== === ======= ========= ============= ====== File:

3:00 PM

P

Man. Reserve Contingency Division/Site Road Type Length

ESTIMATED BY :E.WOLSKI

Total -

Total -

Total -

Total -

Total 21,000 320,000 39,550 24,000 10,000 414,550

Total -

Total -

Total -

APPENDIX A

PRINTING DATE: 12/18/02

B 3 4 5 6 7 8 9 10 11 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334

C

D

E:\Data\Cost Estimating\CE System\CE Tools\Wolski\Version 6.1\[Appendices

E

F

G

Man. Reserve Contingency Division/Site Road Type Length

H

5.0% Land Company Job 15.0% 15.0% (2001 Dollars) Job EST# 1 ACTIVITY Job 5 CODE EST.DATE May. 1, 2001 1000 L.M. Conceptual Est. R1 DATE: ======= Blk Est. # 6 R2 DATE: Unit Cost-Quant. Lump Sum Version May.2./01 DESCRIPTION Price Unit PerSection Values ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------3500 DETAILED DESIGN from 3510,3520,3540,3550,3570 3530 Geotech. En- detailed design 0.45% 32983 0 3539 Geotech. En- Contingency 15.0% 4947 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------TOTAL DETAILED DESIGN COSTS ====== ======= ======================= ======== === ======= ========= 6800 RESIDENT ENGINEERING from 6810,6820,6840,6850,6860,6870 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------TOTAL RESIDENT ENG. COSTS ====== ======= ======================= ======== === ======= ========= File:

Page 5

I

J

K

4 lane Road Types name 1. 2ln Frontage descriptio2. 2ln Acc Rds station lim3. 4ln Acc Rds SITE C/LM4.R4L-4L EXP R/B EST# 1 5.R2/3L-4L EXP R/B 5 5 6.Retr.4L-4LEX R/B 1000 1000 7.R4L-4LEX R/B E/S MR ----------- 8. New 4L EXP R/B 1 1 622,603 623 Bridge Tunnel 32,983 33 4,947 5 Description No. ----------------------- ----------660,533 661 ============= ====== 701,678 ----------------------- ----------701,678 702 ============= ====== Description

0 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------0 0 ====== =============================== ======== === ======= ========= ============= ====== PART 1 SUMMARY CONSTRUCTION 6,403,442 6403 ENGINEERING & SUPERVISION 1,241,863 1242 CONTRACTUAL CONTINGENCY 1,146,796 1147 0 0 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------CONSTRUCTION COST TOTAL DIVISION/SITE EST# 1 8,792,100 8792 ====== ======= ======================= ======== === ======= ========= ============= ====== 2000 PROJECT MANAGEMENT 2060 Project Man - office costs wages 1.50% 131882 131,882 132 2062 Project Man - office costs - expenses 0.50% 43961 43,961 44 2063 Project Man - printing costs 0.00% 0 0 0 2061 Project Man - general 0.00% 0 0 0 Project Manager Sub-total 175,842 176 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------2010 Ministry - office costs wages 1.50% 131882 131,882 132 2012 Ministry - office costs - expenses 0.50% 43961 43,961 44 2030 Ministry - printing costs 0.00% 0 0 0 2011 Ministry - general 0.00% 0 0 0 Ministry Sub-total 175,842 176 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------2070 Public Rel. - wages & expenses 0.55% 48357 48,357 48 2072 Public Rel. - adv., media, displays 0.55% 48357 48,357 48 2073 Public Rel. - opening ceremonies 0.01% 879 0 879 1 2071 Public Rel. - general 0.00% 0 0 0 Public Relations Sub-total 97,592 98 ----------- --------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------2040 Legal Costs - lawyers fees 0.20% 17584 17,584 18 2041 Legal Costs - general 0.00% 0 0 0 Legal Costs Sub-total 17,584 18 ----------- --------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------2080 Insurance - const./ liability, E&O 1.25% 109901 109,901 110 2081 Insurance - general 0.00% 0 0 0 Legal Costs Sub-total 109,901 110 ----------- --------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------2099 Project Management Contingency 15.0% 86514 86,514 87 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------TOTAL PROJECT MANAGEMENT COSTS 663,276 663 ====== ======= ======================= ======== === ======= ========= ============= ====== 4000 LAND $/Building # buildings LS 0 4010 Land(Code -Mrkt,ROW,Serv,Imp.V,Ease.C 250,000 Res 0 0 40,000 40 Acquisition Sub-total 2,000,000 Com 0 0 40,000 40 ----------- --------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------4020 Land(Code -Bus.,5%,Mrg.P,Rel$,P/Tax,Etc 10.00% 4000 0 4,000 4 4030 Land(Code -Owners(LS,Apprsl,Rprt,Lgl,In 7.00% 2800 0 2,800 3 4040 Land(Code -Demolition 0.00% 0 0 0 0 4050 Land(Code -Pro.Man,P.Tax,Util,Security 1.00% 400 0 400 0 4060 Land(Code -Not Used 4070 Land(Code -Not Used 4080 Land(Code -Acq.F,M/Sal,TrvlV,Cntr.S,Appr 7.00% 2800 0 2,800 3 4090 Land(Code -Surveys 0.00% 0 0 0 0

Associated costs-sub-total

10000

L

4 lane name description station limit station limit EST# 1

10,000

M

N

9. R-E4L-4L D/M 10.N 4L EXP D/M 11.N 4L EXP D/E/M 12.N2L;F4LEXP D/M 13.INST.R/B-EX.RD 14.AS IS 15. Misc. 20.I/C Str.&Ramps 21. Bridges 22. Grade Sep. 1 Special

TOTAL LAND COSTS

57,500

Quantity

3:00 PM

ESTIMATED BY :E.WOLSKI

9,988,520

Rate

Total -

-

Description

No.

Units

Quantity

Rate

Total -

-

Description

Description

No.

Units

Quantity

Rate

Total -

-

Description

Description

No.

Units

Quantity

Rate

Total -

-

Description

Description

No.

Units

Quantity

Rate

Total -

-

Description

6.56% 1 Hectare = 10,000 Square Meters 1 Hectare = 2.471 Acres 1 Acre = 43,560 square feet Planned ROW 4.0 10.00% Req. ROW 4.0 7.00% Cost/Ha 10,000 107,637 0.00% Cost/M2 1.00 10.76 1.00% Cost /Acre 4,047 43,560 Cost /Ft2 0.09 $ 1.00 25.00% 7.00% Demo./unit $ 10,000 0.00% Survey /unit $ 2,000 Description No. Units Quantity

Rate

Total -

10

58

P

-

Units

----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------4099 Land Contingency Sub-total 15.0% 7500 0 7,500 8 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------====== ======= ======================= ======== === ======= ========= ============= ======

O

Description

-

APPENDIX A

PRINTING DATE: 12/18/02

B 3 4 5 6 7 8 9 10 11 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376

C

D

E:\Data\Cost Estimating\CE System\CE Tools\Wolski\Version 6.1\[Appendices

E

F

3:00 PM

Man. Reserve Contingency Division/Site Road Type Length

G

H

5.0% Land Company Job 15.0% 15.0% (2001 Dollars) Job EST# 1 ACTIVITY Job 5 CODE EST.DATE May. 1, 2001 1000 L.M. Conceptual Est. R1 DATE: ======= Blk Est. # 6 R2 DATE: Unit Cost-Quant. Lump Sum Version May.2./01 DESCRIPTION Price Unit PerSection Values ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------9800 MANAGEMENT RESERVE MAN. RES. - planning 5.0% 0 MAN. RES. - preliminary design 5.0% 65932 MAN. RES. - utility construction 5.0% 34500 MAN. RES. - grade construction 5.0% 895900 MAN. RES. - structural construction 5.0% 5666390 MAN. RES. - paving construction 5.0% 263401 MAN. RES. - operation construction 5.0% 12733 MAN. RES. - roadside construction 5.0% 0 MAN. RES. - other construction 5.0% 491034 MAN. RES. - project management 5.0% 663276 MAN. RES. - land 5.0% 57500 MAN. RES. - detailed eng. 5.0% 660533 MAN. RES. - residency eng. 5.0% 701678 MAN. RES. - Contingency 0.0% 0 ----------- -------------- ----------------------------------------- --------------- ----- ----------------- ----------------TOTAL MANAGEMENT RESERVE 9512876 ====== ======= ======================= ======== === ======= ========= TOTAL LESS ESCALATION 0 9988520 FISCAL 9900 ESCALATION YEAR PROJECTED ESCALATION COMPLETE $ DONE 2002-2003 0.5750% 5.00% 0 2003 - 2004 0.6250% 10.00% 0 2004-2005 1.0000% 35.00% 0 2005-2006 1.0000% 45.00% 0 2006-2007 1.0000% 5.00% 0 2007-2008 1.0000% 0.00% 0 2008-2009 1.0000% 0.00% 0 2009-2010 1.0000% 0.00% 0 2010-2011 1.0000% 0.00% 0 ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------TOTAL ESCALATION 100.00% 0 ====== ======= ======================= ======== === ======= ========= PART 2 SUMMARY NON-CONSTRUCTION COSTS Non-Construction Non-Const. Contingency ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------TOTAL NON-CONSTRUCTION COSTS ====== ======= ======================= ======== === ======= ========= EST# 1 TOTAL FOR ROAD TYPE 5 ====== ======= ======================= ======== === ======= ========= File:

Page 6

I

J

4 lane name description station limit station limit EST# 1

K

L

4 lane Road Types name 1. 2ln Frontage descriptio2. 2ln Acc Rds station lim3. 4ln Acc Rds SITE C/LM4.R4L-4L EXP R/B EST# 1 5.R2/3L-4L EXP R/B 5 5 6.Retr.4L-4LEX R/B 1000 1000 7.R4L-4LEX R/B E/S MR ----------- 8. New 4L EXP R/B Description No. 0 0 3,297 3 1,725 2 44,795 45 283,319 283 13,170 13 637 1 0 0 24,552 25 33,164 33 2,875 3 33,027 33 35,084 35 0 0 ----------------------- ----------475,644 476 ============= ====== Description No.

M

N

9. R-E4L-4L D/M 10.N 4L EXP D/M 11.N 4L EXP D/E/M 12.N2L;F4LEXP D/M 13.INST.R/B-EX.RD 14.AS IS 15. Misc. 20.I/C Str.&Ramps 21. Bridges 22. Grade Sep. Units Quantity

ESTIMATED BY :E.WOLSKI

P

9,988,520

Rate

Total -

-

Description

Units

Quantity

Rate

Total -

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ----------------------- ----------0 0 ============= ====== 1,102,406 1102 94,014 94 ----------------------- ----------1,196,420 1196 ============= ====== 9,988,520 9989 ============= ======

O

Description

-

APPENDIX A

PRINTING DATE: 12/18/02

B 3 4 5 6 7 8 9 10 11 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454

C

D

E

E:\Data\Cost Estimating\CE System\CE Tools\Wolski\Version 6.1\[Appendices

F

G

Page 7

H

I

J

K

L

M

N

O

5.0% Land 4 lane 4 lane Road Types 9. R-E4L-4L D/M Company Job 15.0% 15.0% name name 1. 2ln Frontage 10.N 4L EXP D/M (2001 Dollars) Job EST# 1 description descriptio2. 2ln Acc Rds 11.N 4L EXP D/E/M ACTIVITY Job 5 station limit station lim3. 4ln Acc Rds 12.N2L;F4LEXP D/M CODE EST.DATE May. 1, 2001 1000 L.M. station limit SITE C/LM4.R4L-4L EXP R/B 13.INST.R/B-EX.RD Conceptual Est. R1 DATE: ======= EST# 1 EST# 1 5.R2/3L-4L EXP R/B 14.AS IS 15. Misc. Blk Est. # 6 R2 DATE: Unit Cost-Quant. Lump Sum 5 5 6.Retr.4L-4LEX R/B 20.I/C Str.&Ramps Version May.2./01 DESCRIPTION Price Unit PerSection Values 1000 1000 7.R4L-4LEX R/B E/S 21. Bridges ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------MR ----------- 8. New 4L EXP R/B 22. Grade Sep. SUMMARY BY ACTIVITY LEVEL Previous Cost/LM % of T % of TC Diff. Estimate 2000 PROJECT MANAGEMENT -576762 0 576,762 577 5.8% 5.8% ----------- -------------- ----------------------------------------- --------------- ----- ------------------- ----------------- ----------------------- ----------- -------------- -------------2500 PLANNING 0 0 0 0 0.0% 0.0% 3000 PRELIMINARY DESIGN -57332 0 57,332 57 0.6% 0.6% 3500 DETAILED DESIGN -574377 0 574,377 574 5.8% 5.8% File:

Man. Reserve Contingency Division/Site Road Type Length

Total Engineering

0

-631709

631,709

632

6.3%

9,988,520

6.3%

----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------- -------------- -------------4000 LAND ACQUISITION -50000 0 50,000 50 0.5% 0.5% ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------- -------------- -------------5000 GRADE CONSTRUCTION -779043 0 779,043 779 7.8% 7.8% 5200 ROAD SIDE CONSTRUCTION 0 0 0 0 0.0% 0.0% 5300 OTHER CONSTRUCTION -426986 0 426,986 427 4.3% 4.3% 5500 STRUCTURAL CONSTRUCTION -4927295 0 4,927,295 4927 49.3% 49.3% 6000 PAVING CONSTRUCTION -229044 0 229,044 229 2.3% 2.3% 6500 OPERATIONAL CONSTRUCTION -11073 0 11,073 11 0.1% 0.1% 6700 UTILITY CONSTRUCTION -30000 0 30,000 30 0.3% 0.3% 6800 RESIDENT ENGINEERING -610155 0 610,155 610 6.1% 6.1%

Total Construction

0

-7013596

7,013,596

7014

70.2%

70.2%

----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------- -------------- -------------9700 CONTINGENCY -1240810 0 1,240,810 1241 12.4% 12.4% ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------- -------------- --------------

SUB-TOTAL

0

-9512876

9,512,876

9513

95.2%

95.2%

9800 MANAGEMENT RESERVE -475644 0 475,644 476 4.8% 4.8% ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------- -------------- --------------

TOTAL

0

-9988520

9,988,520

9989

100.0%

100.0%

----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------- -------------- -------------9900 ESCALATION 0 0 0 0 0.0% ----------- -------------- ----------------------------------------- --------------- ----- ------------- ----------------- ----------------------- ----------- -------------- --------------

TOTAL COST

0

-9988520

9,988,520

9989

100.0%

====== ======= ======================= ======== === ======= ========= ============= ====== ======= =======

Constr. Less Resident Eng.

0

-6403442

ENG. & PM LAND CONST. MAN. RES. ESC. TOTAL

6,403,442

6403

1,389,741 57,500 8,065,636 475,644 0 9,988,520

1390 58 8066 476 0 9989

Assumptions

EST# 1

Shoulder 1 2

Existing Right-Of -Way

m

Existing Rd Pvmt Width

partial taking New Addition Right-Of -Way Yes m

0.0 Shoulder

New Rd. Pvmt Width

14.8 NOTES:

Bridges 3.1 Name 3.2 3.3 3.4 3.5 4 4.1 4.2 4.3 4.4

3:00 PM

Tunnels 2lnSt.w-x x-Pass.Tl shaft snowshedlength (lm)

Width(m) 22.4 0.0 0.0 0.0 0.0

0 0 0 0 Length(m) 0 0 200 0

Length(m) 75.0 0.0 0.0 0.0 0.0

Width(m) Height(m) 12.0 8.27 3.0 3.16 2.0 Diameter

ESTIMATED BY :E.WOLSKI

Lane -

Lane

Median -

Lane

Lane Lane Median 3.70 3.70 -

Lane

-

Lane -

Lane

3.70

3.70

Shoulder Shoulder -

P

ESTIMATING MANUAL

Page 75

Appendix B Summary of Estimates Report

EW

August 21, 2001

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

File:

C

APPENDIX B D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

E

F

G

H

Page 1 I

J

K

4 lane NAME OF STUDY Total Company Job name AREA Line (2001 Dollars) Job description Option Study Cost ACTIVITY Job station limit Option " D " CODE EST.DATE May. 1, 2001 station limit C/LM Conceptual Est. Divison\site EST# 1 MR 1000 Blk Est. # 6 Road Type 5 OR 0 Version May.2./01 DESCRIPTION \Length 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------MR ------------2500 PLANNING 2521 Consultant - transport. planning study 0 0 0 2531 Consultant - corridor study 0 0 0 2541 Consultant - functional plan. study 0 0 0 2502 Consultant - general 0 0 0 Consultant sub-total 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2510 Ministry - project ident. 0 0 0 2520 Ministry - transport. planning study 0 0 0 2530 Ministry - corridor study 0 0 0 2540 Ministry - functional plan. study 0 0 0 2501 Ministry - general 0 0 0 Ministry Sub-total 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2599 Planning Contingency 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL PLANNING 0 0 0 ==== ========= =========================== ================================================= ============== ======= 3000 PRELIMINARY DESIGN 3013 Consultant - aerial base plan 0 0 0 3014 Consultant - mapping 10,000 10,000 10 3015 Consultant - control survey 0 0 0 3021 Consultant - environmental impact 3,000 3,000 3 3031 Consultant - funct.-road field survey 8,000 8,000 8 3041 Consultant - functional design 5,000 5,000 5 3051 Consultant - funct. structural des. 28,332 28,332 28 3061 Consultant - geotechnical design 3,000 3,000 3 3071 Consultant - right-of-way research 0 0 0 3002 Consultant - general 0 0 0 Consultant sub-total 57,332 57,332 57 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------3010 Ministry - aerial base plan 0 0 0 3011 Ministry - mapping 0 0 0 3012 Ministry - control survey 0 0 0 3020 Ministry - environmental impact 0 0 0 3030 Ministry - funct.-road field survey 0 0 0 3040 Ministry - functional design 0 0 0 3050 Ministry - funct. structural des. 0 0 0 3060 Ministry - geotechnical design 0 0 0 3070 Ministry - right-of-way research 0 0 0 3001 Ministry - general 0 0 0 Ministry Sub-total 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------3099 Preliminary design Contingency 8,600 8,600 9 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL PRELIMINARY DESIGN 65,932 65,932 66 ==== ========= =========================== ================================================= ============== =======

L Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115

File:

C

APPENDIX B D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

E

F

G

H

Page 2 I

J

K

4 lane NAME OF STUDY Total Company Job name AREA Line (2001 Dollars) Job description Option Study Cost ACTIVITY Job station limit Option " D " CODE EST.DATE May. 1, 2001 station limit C/LM Conceptual Est. Divison\site EST# 1 MR 1000 Blk Est. # 6 Road Type 5 OR 0 Version May.2./01 DESCRIPTION \Length 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------MR ------------6700 UTILITIES 6710 Util. Prov. - Hydro 10,000 10,000 10 6711 Util. Prov. - Telephone 20,000 20,000 20 Util. Prov. sub-total 30,000 30,000 30 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------6712 Util.Others - pipelines 0 0 0 6713 Util.Others - telecommunication 0 0 0 6714 Util.Others - storm & sewer inspect. 0 0 0 6715 Util.Others - waterworks inspect. 0 0 0 6716 Util.Others - engineering services 0 0 0 6717 Util.Others - parks/recreation-prel. 0 0 0 6718 Util.Others - transit 0 0 0 6719 Util.Others - tr-ops/signs & detours 0 0 0 6701 Util.Others - general 0 0 0 Util.Others sub-total 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------6799 Util.Others Contingency 4,500 4,500 5 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL UTILITIES 34,500 34,500 35 ==== ========= =========================== ================================================= ============== ======= 5000 GRADE CONSTRUCTION 5032 Grade Const- water 0 0 0 5033 Grade Const- sanitary 0 0 0 5034 Grade Const- storm 0 0 0 5031 Grade Const- mobilization 0 0 0 5039 Grade Const- utility contingency 0 0 0 Grade Const. Utilities Sub-total 0 0 0 ------------------------------------------------------------------------------------------------------------- ------------5010 Grade Const- site prep./clear,grubbing 32,000 32,000 32 5020 Grade Const- road grade/exc,placing,fill 335,019 335,019 335 5030 Grade Const- drainage/pipe,cul. 22,661 22,661 23 5040 Grade Const- muiltiplate 0 0 0 5050 Grade Const-SGSB/produce,place,comp 174,470 174,470 174 5051 Grade Const-CBC/produce,place,comp 122,123 122,123 122 5060 Grade Const- grade finishing landscaping 0 0 0 5061 Grade Const- grade finishing hydro seed. 10,080 10,080 10 5062 Grade Const- grade finishing fencing 0 0 0 5063 Grade Const- noise barriers 0 0 0 5064 Grade Const- passing lanes 0 0 0 5090 Grade Const- sidewalks,curb & gutter 0 0 0 5005 Grade Const-detours c/w ex,bf,paving 60,000 60,000 60 5001 Grade Const- mobilization 22,691 22,691 23 5099 Grade Const- Contingency 116,856 116,856 117 Grade Construction Sub-total 895,900 895,900 896 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------GRADE CONSTRUCTION COSTS 895,900 895,900 896 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------3510 Grade Eng. - detailed design 62,713 62,713 63 3519 Grade Eng. - detailed design/Contingency 9,407 9,407 9 6810 Grade Eng. - general const. supervision 41,211 41,211 41 6811 Grade Eng. - quality assurance 28,669 28,669 29 6812 Grade Eng. - surveying 17,918 17,918 18 6819 Grade Eng. - Residency Contingency 13,170 13,170 13 Grade Engineering Sub-total 173,088 173,088 173 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------Total Grade Const. & Eng. Costs 1,068,987 1,068,987 1069 ==== ========= =========================== ================================================= ============== =======

L Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152

File:

C

APPENDIX B D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

Company (2001 Dollars) ACTIVITY CODE Conceptual Est. Blk Est. # 6 Version May.2./01 -------- ----------------

Job Job Job EST.DATE May. 1, 2001 Divison\site Road Type DESCRIPTION \Length -------------------------------------------------

5500 5522 5523 5524 5521 5599

STRUCTURAL CONSTRUCTION Struct.Const - water Struct.Const - sanitary Struct.Const - storm Struct.Const - mobilization Struct.Const - utility contingency Structural Const. Utilities Sub-total

E

F

G

H

4 lane name description station limit station limit EST# 1 5 1000 MR

Page 3 I

MR OR TR

J

K

NAME OF STUDY AREA Option Study Option " D "

Total Line Cost

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 1000 5.R2/3L-4L 0 6.Retr.4L-4 1000 1000 7.R4L-4LE ------------- 8. New 4L

5510 5511 5512 5513

Struct.Const - tunnel site preparation Struct.Const - tunnel construction Struct.Const - snow shed site prep. Struct.Const - snow shed site const.

0 0 0 0 0 0 -------------------------------------------------------------------------------------0 2,615,022 0 0

0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------0 0 2,615,022 2615 0 0 0 0

5514 5515 5516 5517 5518 5519 5501 5529

Struct.Const - bridge site preparation 197,160 Struct.Const - bridge piers 96,000 Struct.Const - bridge abutments 237,600 Struct.Const - bridge superstructure 1,638,000 Struct.Const - retain. wall site prep. 0 Struct.Const - retaining wall const. 0 Struct.Const - mobilization 143,513 Struct.Const - Contingency 739,094 Structural Construction Sub-total 5,666,390 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------STRUCTURAL CONSTRUCTION COSTS 5,666,390 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Struct. Eng. - detailed design 424,979 Struct. Eng. - detailed design/Contingency 63,747 Struct. Eng. - general const. supervision 254,988 Struct. Eng. - quality assurance 169,992 Struct. Eng. - surveying 28,332 Struct. Eng. - Residency Contingency 67,997 Structural Engineering Sub-total 1,010,034 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Structural & Eng. Costs 6,676,424 ========= =========================== =================================================

197,160 197 96,000 96 237,600 238 1,638,000 1638 0 0 0 0 143,513 144 739,094 739 5,666,390 5666 ------------------------ ------------5,666,390 5666 ------------------------ ------------424,979 425 63,747 64 254,988 255 169,992 170 28,332 28 67,997 68 1,010,034 1010 ------------------------ ------------6,676,424 6676 ============== =======

--------------3520 3529 6820 6821 6822 6829 -------====

L

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199

File:

C

-------3560 3569 6860 6861 6862 6869 -------==== 6500 6510 6520 6530 6540 6550 6501 6599 --------------3540 3549 6840 6841 6842 6849 -------====

D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

Company (2001 Dollars) ACTIVITY CODE Conceptual Est. Blk Est. # 6 Version May.2./01 -------- ---------------6000 6020 6030 6040 6050 6060 6070 6001 6010 6099 --------

APPENDIX B

Job Job Job EST.DATE May. 1, 2001 Divison\site Road Type DESCRIPTION \Length -------------------------------------------------

E

F

G

H

4 lane name description station limit station limit EST# 1 5 1000 MR

Page 4 I

MR OR TR

J

K

NAME OF STUDY AREA Option Study Option " D "

Total Line Cost

L

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 1000 5.R2/3L-4L 0 6.Retr.4L-4 1000 1000 7.R4L-4LE ------------- 8. New 4L

PAVING CONSTRUCTION Paving Cons- machine paving asphalt 222,373 Paving Cons- machine paving concrete 0 Paving Cons- hot reprofiling 0 Paving Cons- shoulder paving 0 Paving Cons- pavement finishing 0 Paving Cons- seal coating 0 Paving Cons- mobilization 6,671 Paving Cons- pavement design 0 Paving Cons- Contingency 34,357 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------PAVING CONSTRUCTION COSTS 263,401 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Paving Eng. - detailed design 18,438 Paving Eng. - detailed design/Contingency 2,766 Paving Eng. - general const. supervision 7,902 Paving Eng. - quality assurance 13,170 Paving Eng. - surveying 2,634 Paving Eng. - Residency Contingency 3,556 Paving Engineering Sub-total 48,466 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Paving Const. & Eng. Costs 311,867 ========= =========================== =================================================

222,373 222 0 0 0 0 0 0 0 0 0 0 6,671 7 0 0 34,357 34 ------------------------ ------------263,401 263 ------------------------ ------------18,438 18 2,766 3 7,902 8 13,170 13 2,634 3 3,556 4 48,466 48 ------------------------ ------------311,867 312 ============== =======

OPERATIONAL CONSTRUCTION Operat.Cons- lighting 0 Operat.Cons- signals 0 Operat.Cons- signing 2,000 Operat.Cons- guard rail 0 Operat.Cons- pavement markings 8,750 Operat.Cons- mobilization 323 Operat.Cons- contingency 1,661 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------OPERATIONAL CONSTRUCTION COSTS 12,733 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Operat. Eng.- detailed design 891 Operat. Eng.- detailed design/Contingency 134 Operat. Eng.- general const. supervision 764 Operat. Eng.- quality assurance 255 Operat. Eng.- surveying 127 Operat. Eng.- Residency Contingency 172 Operational Enginering Sub-total 2,343 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Operational Const.& Eng.Costs 15,076 ========= =========================== =================================================

0 0 0 0 2,000 2 0 0 8,750 9 323 0 1,661 2 ------------------------ ------------12,733 13 ------------------------ ------------891 1 134 0 764 1 255 0 127 0 172 0 2,343 2 ------------------------ ------------15,076 15 ============== =======

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256

File:

C

5210 5220 5230 5201 5299 --------------3550 3559 6850 6851 6852 6859 -------==== 5300 5303 5304 5305 5302 5309 5310 5320 5330 5340 5301 5399 --------------3570 3579 6870 6871 6872 6879 -------====

D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

Company (2001 Dollars) ACTIVITY CODE Conceptual Est. Blk Est. # 6 Version May.2./01 -------- ---------------5200 5203 5204 5205 5202 5209

APPENDIX B

Job Job Job EST.DATE May. 1, 2001 Divison\site Road Type DESCRIPTION \Length -------------------------------------------------

E

F

G

H

4 lane name description station limit station limit EST# 1 5 1000 MR

ROAD SIDE CONSTRUCTION RoadSide Co- water RoadSide Co- sanitary RoadSide Co- storm RoadSide Co- mobilization RoadSide Co- Utility Contingency Road Side Const. Utilities Sub-total

0 0 0 0 0 0 -------------------------------------------------------------------------------------RoadSide Co- weighscales 0 RoadSide Co- safety rest areas 0 RoadSide Co- tourist rest & view areas 0 RoadSide Co- mobilization 0 RoadSide Co- Contingency 0 Road Side Construction Sub-total 0 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------ROAD SIDE CONSTRUCTION COSTS 0 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------RoadSide En- detailed design 0 RoadSide En- detailed design/Contingency 0 RoadSide En- general const. supervision 0 RoadSide En- quality assurance 0 RoadSide En- surveying 0 RoadSide En- Residency Contingency 0 Road Side Engineering Sub-total 0 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Road Side Const.& Eng.Costs 0 ========= =========================== ================================================= OTHER CONSTRUCTION Other Const.- water Other Const.- sanitary Other Const.- storm Other Const.- mobilization Other Const.- utility contingency Other Const. Utilities Sub-total

0 0 0 0 0 0 -------------------------------------------------------------------------------------Other Const.- railroads main & spur lines 414,550 Other Const.- railroad crossings 0 Other Const.- marine work 0 Other Const.- environmental mitigations 0 Other Const.- mobilization 12,436 Other Const.- Contingency 64,048 Other Construction Sub-total 491,034 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------OTHER CONSTRUCTION COSTS 491,034 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Other Eng. - detailed design 34,372 Other Eng. - detailed design/Contingency 5,156 Other Eng. - general const. supervision 14,731 Other Eng. - quality assurance 14,731 Other Eng. - surveying 14,731 Other Eng. - Residency Contingency 6,629 Other Engineering Sub-total 90,350 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Other Const.& Eng.Costs 581,385 ========= =========================== =================================================

Page 5 I

MR OR TR

J

K

NAME OF STUDY AREA Option Study Option " D "

Total Line Cost

L

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 1000 5.R2/3L-4L 0 6.Retr.4L-4 1000 1000 7.R4L-4LE ------------- 8. New 4L

0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------0 0 ------------------------ ------------0 0 0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------0 0 ============== ======= 0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------414,550 415 0 0 0 0 0 0 12,436 12 64,048 64 491,034 491 ------------------------ ------------491,034 491 ------------------------ ------------34,372 34 5,156 5 14,731 15 14,731 15 14,731 15 6,629 7 90,350 90 ------------------------ ------------581,385 581 ============== =======

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281

File:

C

APPENDIX B D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

E

F

G

H

Page 6 I

J

K

4 lane NAME OF STUDY Total Company Job name AREA Line (2001 Dollars) Job description Option Study Cost ACTIVITY Job station limit Option " D " CODE EST.DATE May. 1, 2001 station limit C/LM Conceptual Est. Divison\site EST# 1 MR 1000 Blk Est. # 6 Road Type 5 OR 0 Version May.2./01 DESCRIPTION \Length 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------MR ------------3500 DETAILED DESIGN from 3510,3520,3540,3550,3570 622,603 622,603 623 3530 Geotech. En - detailed design 32,983 32,983 33 3539 Geotech. En - Contingency 4,947 4,947 5 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL DETAILED DESIGN COSTS 660,533 660,533 661 ==== ========= =========================== ================================================= ============== ======= 6800 RESIDENT ENGINEERING 0 from 6810,6820,6840,6850,6860,6870 701,678 701,678 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL RESIDENT ENG. COSTS 701,678 701,678 702 ==== ========= =========================== ================================================= ============== ======= 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------0 0 0 ==== ========= =========================== ================================================= ============== ======= PART 1 SUMMARY CONSTRUCTION 6,403,442 6,403,442 6403 ENGINEERING & SUPERVISION 1,241,863 1,241,863 1242 CONTRACTUAL CONTINGENCY 1,146,796 1,146,796 1147 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------CONSTRUCTION COST TOTAL 8,792,100 8,792,100 8792 ==== ========= =========================== ================================================= ============== =======

L Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334

File:

C

APPENDIX B D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

E

F

G

H

Page 7 I

J

K

4 lane NAME OF STUDY Total Company Job name AREA Line (2001 Dollars) Job description Option Study Cost ACTIVITY Job station limit Option " D " CODE EST.DATE May. 1, 2001 station limit C/LM Conceptual Est. Divison\site EST# 1 MR 1000 Blk Est. # 6 Road Type 5 OR 0 Version May.2./01 DESCRIPTION \Length 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------MR ------------2000 PROJECT MANAGEMENT 2060 Project Man. - office costs wages 131,882 131,882 132 2062 Project Man. - office costs - expenses 43,961 43,961 44 2063 Project Man. - printing costs 0 0 0 2061 Project Man. - general 0 0 0 Project Manager Sub-total 175,842 175,842 176 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2010 Ministry - office costs wages 131,882 131,882 132 2012 Ministry - office costs - expenses 43,961 43,961 44 2030 Ministry - printing costs 0 0 0 2011 Ministry - general 0 0 0 Ministry Sub-total 175,842 175,842 176 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2070 Public Rel. - wages & expenses 48,357 48,357 48 2072 Public Rel. - adv., media, displays 48,357 48,357 48 2073 Public Rel. - opening ceremonies 879 879 1 2071 Public Rel. - general 0 0 0 Public Relations Sub-total 97,592 97,592 98 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2040 Legal Costs - lawyers fees 17,584 17,584 18 2041 Legal Costs - general 0 0 0 Legal Costs Sub-total 17,584 17,584 18 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2080 Insurance - const./ liability, E&O 109,901 109,901 110 2081 Insurance - general 0 0 0 Legal Costs Sub-total 109,901 109,901 110 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2099 Project Management Contingency 86,514 86,514 87 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL PROJECT MANAGEMENT COSTS 663,276 663,276 663 ==== ========= =========================== ================================================= ============== ======= 4000 LAND 0 0 4010 Land(Code 4-Mrkt,ROW,Serv,Imp.V,Ease.C,T 40,000 40,000 40 Acquisition Sub-total 40,000 40,000 40 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------4020 Land(Code 4-Bus.,5%,Mrg.P,Rel$,P/Tax,Etc 4,000 4,000 4 4030 Land(Code 4-Owners(LS,Apprsl,Rprt,Lgl,In 2,800 2,800 3 4040 Land(Code 4-Demolition 0 0 0 4050 Land(Code 4-Pro.Man,P.Tax,Util,Security 400 400 0 4060 Land(Code 4-Not Used 0 0 0 4070 Land(Code 4-Not Used 0 0 0 4080 Land(Code 4-Acq.F,M/Sal,TrvlV,Cntr.S,Appr. 2,800 2,800 3 4090 Land(Code 4-Surveys 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Associated costs-sub-total 10,000 10,000 10 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------4099 Land Contingency Sub-total 7,500 7,500 8 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL LAND COSTS 57,500 57,500 58 ==== ========= =========================== ================================================= ============== =======

L Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376

File:

C

APPENDIX B D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

E

F

G

H

Page 8 I

J

K

4 lane NAME OF STUDY Total Company Job name AREA Line (2001 Dollars) Job description Option Study Cost ACTIVITY Job station limit Option " D " CODE EST.DATE May. 1, 2001 station limit C/LM Conceptual Est. Divison\site EST# 1 MR 1000 Blk Est. # 6 Road Type 5 OR 0 Version May.2./01 DESCRIPTION \Length 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------MR ------------9800 MANAGEMENT RESERVE 0 MAN. RES. - planning 0 0 0 MAN. RES. - preliminary design 3,297 3,297 3 MAN. RES. - utility construction 1,725 1,725 2 MAN. RES. - grade construction 44,795 44,795 45 MAN. RES. - structural construction 283,319 283,319 283 MAN. RES. - paving construction 13,170 13,170 13 MAN. RES. - operation construction 637 637 1 MAN. RES. - roadside construction 0 0 0 MAN. RES. - other construction 24,552 24,552 25 MAN. RES. - project management 33,164 33,164 33 MAN. RES. - land 2,875 2,875 3 MAN. RES. - detailed eng. 33,027 33,027 33 MAN. RES. - residency eng. 35,084 35,084 35 MAN. RES. - risk contingency 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL MANAGEMENT RESERVE 475,644 475,644 476 ==== ========= =========================== ================================================= ============== ======= TOTAL LESS ESCALATION FISCAL 9900 ESCALATION YEAR PROJECTED ESCALATION 2002-2003 0.5750% 0 0 0 2003 - 2004 0.6250% 0 0 0 2004-2005 1.0000% 0 0 0 2005-2006 1.0000% 0 0 0 2006-2007 1.0000% 0 0 0 2007-2008 1.0000% 0 0 0 2008-2009 1.0000% 0 0 0 2009-2010 1.0000% 0 0 0 2010-2011 1.0000% 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL ESCALATION 0 0 0 ==== ========= =========================== ================================================= ============== ======= PART 2 SUMMARY NON-CONSTRUCTION COS 0 Non-Construction 1,102,406 1,102,406 1102 Non-Const. Contingency 94,014 94,014 94 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL NON-CONSTRUCTION COS 1,196,420 1,196,420 1196 ==== ========= =========================== ================================================= ============== ======= DIVISION TOTAL FOR ROAD TYPE 9,988,520 9,988,520 9989 ==== ========= =========================== ================================================= ============== =======

L Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411

File:

C

APPENDIX B D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

Company Job (2001 Dollars) Job ACTIVITY Job CODE EST.DATE May. 1, 2001 Conceptual Est. Divison\site Blk Est. # 6 Road Type Version May.2./01 DESCRIPTION \Length -------- ---------------- ------------------------------------------------SUMMARY BY ACTIVITY LEVEL

E

F

G

H

4 lane name description station limit station limit EST# 1 5 1000 MR

Page 9 I

MR OR TR

J

K

NAME OF STUDY AREA Option Study Option " D "

Total Line Cost

L

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 1000 5.R2/3L-4L 0 6.Retr.4L-4 1000 1000 7.R4L-4LE ------------- 8. New 4L Cost/LM % of T

2000 PROJECT MANAGEMENT 576,762 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------2500 PLANNING 0 3000 PRELIMINARY DESIGN 57,332 3500 DETAILED DESIGN 574,377

576,762 577 5.8% ------------------------ ------------- ------------0 0 0.0% 57,332 57 0.6% 574,377 574 5.8%

Total Engineering 631,709 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------4000 LAND ACQUISITION 50,000 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------5000 GRADE CONSTRUCTION 779,043 5200 ROAD SIDE CONSTRUCTION 0 5300 OTHER CONSTRUCTION 426,986 5500 STRUCTURAL CONSTRUCTION 4,927,295 6000 PAVING CONSTRUCTION 229,044 6500 OPERATIONAL CONSTRUCTION 11,073 6700 UTILITY CONSTRUCTION 30,000 6800 RESIDENT ENGINEERING 610,155 0 Total Construction 7,013,596 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------9700 CONTINGENCY 1,240,810 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------SUB-TOTAL 9,512,876 9800 MANAGEMENT RESERVE 475,644 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------TOTAL 9,988,520 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------9900 ESCALATION 0 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------TOTAL COST 9,988,520 ==== ========= =========================== ================================================= Const. Less Resident Eng. 6,403,442

631,709 632 ------------------------ ------------50,000 50 ------------------------ ------------779,043 779 0 0 426,986 427 4,927,295 4927 229,044 229 11,073 11 30,000 30 610,155 610 0 0 7,013,596 7014 ------------------------ ------------1,240,810 1241 ------------------------ ------------9,512,876 9513 475,644 476 ------------------------ ------------9,988,520 9989 ------------------------ ------------0 0 ------------------------ ------------9,988,520 9989 ============== ======= 6,403,442 6403

6.3% ------------0.5% ------------7.8% 0.0% 4.3% 49.3% 2.3% 0.1% 0.3% 6.1% 70.2% ------------12.4% ------------95.2% 4.8% ------------100.0% ------------------------=======

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

B 3 4 5 6 7 8 9 10 11 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464

File:

C

APPENDIX B D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix B

Company (2001 Dollars) ACTIVITY CODE Conceptual Est. Blk Est. # 6 Version May.2./01 -------- ----------------

Job Job Job EST.DATE May. 1, 2001 Divison\site Road Type DESCRIPTION \Length -------------------------------------------------

E

F

G

H

4 lane name description station limit station limit EST# 1 5 1000 MR

Page 10 I

MR OR TR

J

K

NAME OF STUDY AREA Option Study Option " D "

Total Line Cost

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 1000 5.R2/3L-4L 0 6.Retr.4L-4 1000 1000 7.R4L-4LE ------------- 8. New 4L

Engineering 1,389,741 1,389,741 Land 57,500 57,500 Construction 8,065,636 8,065,636 Management Reserve 475,644 475,644 Escalation 0 0 Total 9,988,520 9,988,520 ------------------------------------------------- -------------------------------------------------------------------------------------- ---- -----------------------BASIC QUANTITY SUMMARY Construct.Cost ONLY Per L.M. 8,066 $/LM 8,066 Land Area 4.0 ha 4.0 Mobilization Land Cont. Construction Cont. Engineering Cont. Supervision Cont. Total Cont.

185,634 7,500 960,516 181,271 91,523 1,240,810

S.G.S.B. C.B.C. Asphalt Concrete Barrier Noise Attentuation Wall No. of Light Poles Sidewalk Curb and Gutter Signals

9,693 6,106 3,730 0 0 0 0 0 0

------------------------------------------------- -------------------------------------------------------------------------------------Total Rock 852 Total OM 41,727 Total Stripping 4,600 Total Borrow 0 Total Cut/Excavation 47,179 Total Fill 0 Surplus or Deficit 47,179 ENG & PM LAND CONST. BRIDGES-R/W MANAGEMENT RESERVE ESCALATION TOTAL (Millions)

185,634 7,500 960,516 181,271 91,523 1,240,810 m3 m3 t lm m2 ea lm lm ea m3

L

1390 58 8066 476 0 9989

1,052,039

9,693 6,106 3,730 0 0 0 0 0 0

---- -----------------------m3 852 m3 41,727 m3 4,600 m3 0 m3 47,179 m3 0 m3 47,179

ENG 0 0 0 0 0

-------------------------------------------------------------------------------------- ---- ------------------------ ------------1.390 1.390 1.39 0.058 0.058 0.06 2.400 2.400 2.40 5.666 5.666 5.67 0.476 0.476 0.48 0.000 0.000 0.00 9.990 9.990 9.99

DIF 852 41,727 4,600 0 47,179 0

ESTIMATING MANUAL

Page 76

Appendix C Summary of Summaries Report

EW

August 21, 2001

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY SUMMARY Total Company Job AREA OF Line (2001 DollarsJob Option Study SUMMARIES Cost ACTIVITY Job Option " D " ONLY CODE EST.DATE May. 1, 2001 0 C/LM Conceptual Est. MAIN RD 1000 MR 1000 Blk Est. # 6 OTHER ROADS 0 OR 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------------------- ------------2500 PLANNING 2521 Consultant - transport. planning study 0 0 0 2531 Consultant - corridor study 0 0 0 2541 Consultant - functional plan. study 0 0 0 2502 Consultant - general 0 0 0 Consultant sub-total 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2510 Ministry - project ident. 0 0 0 2520 Ministry - transport. planning study 0 0 0 2530 Ministry - corridor study 0 0 0 2540 Ministry - functional plan. study 0 0 0 2501 Ministry - general 0 0 0 Ministry Sub-total 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2599 Planning Contingency 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL PLANNING 0 0 0 ==== ========= =========================== ================================================= ============== ======= 3000 PRELIMINARY DESIGN 3013 Consultant - aerial base plan 0 0 0 3014 Consultant - mapping 10,000 10,000 10 3015 Consultant - control survey 0 0 0 3021 Consultant - environmental impact 3,000 3,000 3 3031 Consultant - funct.-road field survey 8,000 8,000 8 3041 Consultant - functional design 5,000 5,000 5 3051 Consultant - funct. structural des. 28,332 28,332 28 3061 Consultant - geotechnical design 3,000 3,000 3 3071 Consultant - right-of-way research 0 0 0 3002 Consultant - general 0 0 0 Consultant sub-total 57,332 57,332 57 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------3010 Ministry - aerial base plan 0 0 0 3011 Ministry - mapping 0 0 0 3012 Ministry - control survey 0 0 0 3020 Ministry - environmental impact 0 0 0 3030 Ministry - funct.-road field survey 0 0 0 3040 Ministry - functional design 0 0 0 3050 Ministry - funct. structural des. 0 0 0 3060 Ministry - geotechnical design 0 0 0 3070 Ministry - right-of-way research 0 0 0 3001 Ministry - general 0 0 0 Ministry Sub-total 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------3099 Preliminary design Contingency 8,600 8,600 9 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL PRELIMINARY DESIGN 65,932 65,932 66 ==== ========= =========================== ================================================= ============== =======

Page 1 Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY SUMMARY Total Company Job AREA OF Line (2001 DollarsJob Option Study SUMMARIES Cost ACTIVITY Job Option " D " ONLY CODE EST.DATE May. 1, 2001 0 C/LM Conceptual Est. MAIN RD 1000 MR 1000 Blk Est. # 6 OTHER ROADS 0 OR 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------------------- ------------6700 UTILITIES 6710 Util. Prov. - Hydro 10,000 10,000 10 6711 Util. Prov. - Telephone 20,000 20,000 20 Util. Prov. sub-total 30,000 30,000 30 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------6712 Util.Others - pipelines 0 0 0 6713 Util.Others - telecommunication 0 0 0 6714 Util.Others - storm & sewer inspect. 0 0 0 6715 Util.Others - waterworks inspect. 0 0 0 6716 Util.Others - engineering services 0 0 0 6717 Util.Others - parks/recreation-prel. 0 0 0 6718 Util.Others - transit 0 0 0 6719 Util.Others - tr-ops/signs & detours 0 0 0 6701 Util.Others - general 0 0 0 Util.Others sub-total 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------6799 Util.Others Contingency 4,500 4,500 5 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL UTILITIES 34,500 34,500 35 ==== ========= =========================== ================================================= ============== ======= 5000 GRADE CONSTRUCTION 5032 Grade Const- water 0 0 0 5033 Grade Const- sanitary 0 0 0 5034 Grade Const- storm 0 0 0 5031 Grade Const- mobilization 0 0 0 5039 Grade Const- utility contingency 0 0 0 Grade Const. Utilities Sub-total 0 0 0 ------------------------------------------------------------------------------------------------------------- ------------5010 Grade Const- site prep./clear,grubbing 32,000 32,000 32 5020 Grade Const- road grade/exc,placing,fill 335,019 335,019 335 5030 Grade Const- drainage/pipe,cul. 22,661 22,661 23 5040 Grade Const- muiltiplate 0 0 0 5050 Grade Const-SGSB/produce,place,comp 174,470 174,470 174 5051 Grade Const-CBC/produce,place,comp 122,123 122,123 122 5060 Grade Const- grade finishing landscaping 0 0 0 5061 Grade Const- grade finishing hydro seed. 10,080 10,080 10 5062 Grade Const- grade finishing fencing 0 0 0 5063 Grade Const- noise barriers 0 0 0 5064 Grade Const- passing lanes 0 0 0 5090 Grade Const- sidewalks,curb & gutter 0 0 0 5005 Grade Const-detours c/w ex,bf,paving 60,000 60,000 60 5001 Grade Const- mobilization 22,691 22,691 23 5099 Grade Const- Contingency 116,856 116,856 117 Grade Construction Sub-total 895,900 895,900 896 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------GRADE CONSTRUCTION COSTS 895,900 895,900 896 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------3510 Grade Eng. - detailed design 62,713 62,713 63 3519 Grade Eng. - detailed design/Contingency 9,407 9,407 9 6810 Grade Eng. - general const. supervision 41,211 41,211 41 6811 Grade Eng. - quality assurance 28,669 28,669 29 6812 Grade Eng. - surveying 17,918 17,918 18 6819 Grade Eng. - Residency Contingency 13,170 13,170 13 Grade Engineering Sub-total 173,088 173,088 173 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------Total Grade Const. & Eng. Costs 1,068,987 1,068,987 1069 ==== ========= =========================== ================================================= ============== =======

Page 2 Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY Company Job AREA (2001 DollarsJob Option Study ACTIVITY Job Option " D " CODE EST.DATE May. 1, 2001 0 Conceptual Est. MAIN RD 1000 Blk Est. # 6 OTHER ROADS 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 -------- ---------------- ------------------------------------------------- --------------------------------------------------------------------------5500 5522 5523 5524 5521 5599

STRUCTURAL CONSTRUCTION Struct.Const - water Struct.Const - sanitary Struct.Const - storm Struct.Const - mobilization Struct.Const - utility contingency Structural Const. Utilities Sub-total

Page 3 SUMMARY OF SUMMARIES ONLY

MR OR TR

1000 0 1000 ------------------------

Total Line Cost

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 1000 7.R4L-4LE ------------- 8. New 4L

5510 5511 5512 5513

Struct.Const - tunnel site preparation Struct.Const - tunnel construction Struct.Const - snow shed site prep. Struct.Const - snow shed site const.

0 0 0 0 0 0 -------------------------------------------------------------------------------------0 2,615,022 0 0

0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------0 0 2,615,022 2615 0 0 0 0

5514 5515 5516 5517 5518 5519 5501 5529

Struct.Const - bridge site preparation 197,160 Struct.Const - bridge piers 96,000 Struct.Const - bridge abutments 237,600 Struct.Const - bridge superstructure 1,638,000 Struct.Const - retain. wall site prep. 0 Struct.Const - retaining wall const. 0 Struct.Const - mobilization 143,513 Struct.Const - Contingency 739,094 Structural Construction Sub-total 5,666,390 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------STRUCTURAL CONSTRUCTION COSTS 5,666,390 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Struct. Eng. - detailed design 424,979 Struct. Eng. - detailed design/Contingency 63,747 Struct. Eng. - general const. supervision 254,988 Struct. Eng. - quality assurance 169,992 Struct. Eng. - surveying 28,332 Struct. Eng. - Residency Contingency 67,997 Structural Engineering Sub-total 1,010,034 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Structural & Eng. Costs 6,676,424 ========= =========================== =================================================

197,160 197 96,000 96 237,600 238 1,638,000 1638 0 0 0 0 143,513 144 739,094 739 5,666,390 5666 ------------------------ ------------5,666,390 5666 ------------------------ ------------424,979 425 63,747 64 254,988 255 169,992 170 28,332 28 67,997 68 1,010,034 1010 ------------------------ ------------6,676,424 6676 ============== =======

--------------3520 3529 6820 6821 6822 6829 -------====

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY Company Job AREA (2001 DollarsJob Option Study ACTIVITY Job Option " D " CODE EST.DATE May. 1, 2001 0 Conceptual Est. MAIN RD 1000 Blk Est. # 6 OTHER ROADS 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 -------- ---------------- ------------------------------------------------- --------------------------------------------------------------------------6000 6020 6030 6040 6050 6060 6070 6001 6010 6099 --------------3560 3569 6860 6861 6862 6869 -------==== 6500 6510 6520 6530 6540 6550 6501 6599 --------------3540 3549 6840 6841 6842 6849 -------====

Page 4 SUMMARY OF SUMMARIES ONLY

MR OR TR

1000 0 1000 ------------------------

Total Line Cost

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 1000 7.R4L-4LE ------------- 8. New 4L

PAVING CONSTRUCTION Paving Cons- machine paving asphalt 222,373 Paving Cons- machine paving concrete 0 Paving Cons- hot reprofiling 0 Paving Cons- shoulder paving 0 Paving Cons- pavement finishing 0 Paving Cons- seal coating 0 Paving Cons- mobilization 6,671 Paving Cons- pavement design 0 Paving Cons- Contingency 34,357 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------PAVING CONSTRUCTION COSTS 263,401 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Paving Eng. - detailed design 18,438 Paving Eng. - detailed design/Contingency 2,766 Paving Eng. - general const. supervision 7,902 Paving Eng. - quality assurance 13,170 Paving Eng. - surveying 2,634 Paving Eng. - Residency Contingency 3,556 Paving Engineering Sub-total 48,466 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Paving Const. & Eng. Costs 311,867 ========= =========================== =================================================

222,373 222 0 0 0 0 0 0 0 0 0 0 6,671 7 0 0 34,357 34 ------------------------ ------------263,401 263 ------------------------ ------------18,438 18 2,766 3 7,902 8 13,170 13 2,634 3 3,556 4 48,466 48 ------------------------ ------------311,867 312 ============== =======

OPERATIONAL CONSTRUCTION Operat.Cons- lighting 0 Operat.Cons- signals 0 Operat.Cons- signing 2,000 Operat.Cons- guard rail 0 Operat.Cons- pavement markings 8,750 Operat.Cons- mobilization 323 Operat.Cons- contingency 1,661 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------OPERATIONAL CONSTRUCTION COSTS 12,733 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Operat. Eng.- detailed design 891 Operat. Eng.- detailed design/Contingency 134 Operat. Eng.- general const. supervision 764 Operat. Eng.- quality assurance 255 Operat. Eng.- surveying 127 Operat. Eng.- Residency Contingency 172 Operational Enginering Sub-total 2,343 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Operational Const.& Eng.Costs 15,076 ========= =========================== =================================================

0 0 0 0 2,000 2 0 0 8,750 9 323 0 1,661 2 ------------------------ ------------12,733 13 ------------------------ ------------891 1 134 0 764 1 255 0 127 0 172 0 2,343 2 ------------------------ ------------15,076 15 ============== =======

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY Company Job AREA (2001 DollarsJob Option Study ACTIVITY Job Option " D " CODE EST.DATE May. 1, 2001 0 Conceptual Est. MAIN RD 1000 Blk Est. # 6 OTHER ROADS 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 -------- ---------------- ------------------------------------------------- --------------------------------------------------------------------------5200 5203 5204 5205 5202 5209 5210 5220 5230 5201 5299 --------------3550 3559 6850 6851 6852 6859 -------==== 5300 5303 5304 5305 5302 5309 5310 5320 5330 5340 5301 5399 --------------3570 3579 6870 6871 6872 6879 -------====

ROAD SIDE CONSTRUCTION RoadSide Co- water RoadSide Co- sanitary RoadSide Co- storm RoadSide Co- mobilization RoadSide Co- Utility Contingency Road Side Const. Utilities Sub-total

0 0 0 0 0 0 -------------------------------------------------------------------------------------RoadSide Co- weighscales 0 RoadSide Co- safety rest areas 0 RoadSide Co- tourist rest & view areas 0 RoadSide Co- mobilization 0 RoadSide Co- Contingency 0 Road Side Construction Sub-total 0 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------ROAD SIDE CONSTRUCTION COSTS 0 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------RoadSide En- detailed design 0 RoadSide En- detailed design/Contingency 0 RoadSide En- general const. supervision 0 RoadSide En- quality assurance 0 RoadSide En- surveying 0 RoadSide En- Residency Contingency 0 Road Side Engineering Sub-total 0 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Road Side Const.& Eng.Costs 0 ========= =========================== ================================================= OTHER CONSTRUCTION Other Const.- water Other Const.- sanitary Other Const.- storm Other Const.- mobilization Other Const.- utility contingency Other Const. Utilities Sub-total

0 0 0 0 0 0 -------------------------------------------------------------------------------------Other Const.- railroads main & spur lines 414,550 Other Const.- railroad crossings 0 Other Const.- marine work 0 Other Const.- environmental mitigations 0 Other Const.- mobilization 12,436 Other Const.- Contingency 64,048 Other Construction Sub-total 491,034 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------OTHER CONSTRUCTION COSTS 491,034 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Other Eng. - detailed design 34,372 Other Eng. - detailed design/Contingency 5,156 Other Eng. - general const. supervision 14,731 Other Eng. - quality assurance 14,731 Other Eng. - surveying 14,731 Other Eng. - Residency Contingency 6,629 Other Engineering Sub-total 90,350 ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------Total Other Const.& Eng.Costs 581,385 ========= =========================== =================================================

Page 5 SUMMARY OF SUMMARIES ONLY

MR OR TR

1000 0 1000 ------------------------

Total Line Cost

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 1000 7.R4L-4LE ------------- 8. New 4L

0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------0 0 ------------------------ ------------0 0 0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------0 0 ============== ======= 0 0 0 0 0 0 0 0 0 0 0 0 ------------------------ ------------414,550 415 0 0 0 0 0 0 12,436 12 64,048 64 491,034 491 ------------------------ ------------491,034 491 ------------------------ ------------34,372 34 5,156 5 14,731 15 14,731 15 14,731 15 6,629 7 90,350 90 ------------------------ ------------581,385 581 ============== =======

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY SUMMARY Total Company Job AREA OF Line (2001 DollarsJob Option Study SUMMARIES Cost ACTIVITY Job Option " D " ONLY CODE EST.DATE May. 1, 2001 0 C/LM Conceptual Est. MAIN RD 1000 MR 1000 Blk Est. # 6 OTHER ROADS 0 OR 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------------------- ------------3500 DETAILED DESIGN from 3510,3520,3540,3550,3570 622,603 622,603 623 3530 Geotech. En - detailed design 32,983 32,983 33 3539 Geotech. En - Contingency 4,947 4,947 5 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL DETAILED DESIGN COSTS 660,533 660,533 661 ==== ========= =========================== ================================================= ============== ======= 6800 RESIDENT ENGINEERING 0 from 6810,6820,6840,6850,6860,6870 701,678 701,678 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL RESIDENT ENG. COSTS 701,678 701,678 702 ==== ========= =========================== ================================================= ============== ======= 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------0 0 0 ==== ========= =========================== ================================================= ============== ======= PART 1 SUMMARY CONSTRUCTION 6,403,442 6,403,442 6403 ENGINEERING & SUPERVISION 1,241,863 1,241,863 1242 CONTRACTUAL CONTINGENCY 1,146,796 1,146,796 1147 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------CONSTRUCTION COST TOTAL 8,792,100 8,792,100 8792 ==== ========= =========================== ================================================= ============== =======

Page 6 Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY SUMMARY Total Company Job AREA OF Line (2001 DollarsJob Option Study SUMMARIES Cost ACTIVITY Job Option " D " ONLY CODE EST.DATE May. 1, 2001 0 C/LM Conceptual Est. MAIN RD 1000 MR 1000 Blk Est. # 6 OTHER ROADS 0 OR 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------------------- ------------2000 PROJECT MANAGEMENT 2060 Project Man. - office costs wages 131,882 131,882 132 2062 Project Man. - office costs - expenses 43,961 43,961 44 2063 Project Man. - printing costs 0 0 0 2061 Project Man. - general 0 0 0 Project Manager Sub-total 175,842 175,842 176 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2010 Ministry - office costs wages 131,882 131,882 132 2012 Ministry - office costs - expenses 43,961 43,961 44 2030 Ministry - printing costs 0 0 0 2011 Ministry - general 0 0 0 Ministry Sub-total 175,842 175,842 176 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2070 Public Rel. - wages & expenses 48,357 48,357 48 2072 Public Rel. - adv., media, displays 48,357 48,357 48 2073 Public Rel. - opening ceremonies 879 879 1 2071 Public Rel. - general 0 0 0 Public Relations Sub-total 97,592 97,592 98 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2040 Legal Costs - lawyers fees 17,584 17,584 18 2041 Legal Costs - general 0 0 0 Legal Costs Sub-total 17,584 17,584 18 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2080 Insurance - const./ liability, E&O 109,901 109,901 110 2081 Insurance - general 0 0 0 Legal Costs Sub-total 109,901 109,901 110 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------2099 Project Management Contingency 86,514 86,514 87 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL PROJECT MANAGEMENT COSTS 663,276 663,276 663 ==== ========= =========================== ================================================= ============== ======= 4000 LAND 0 0 4010 Land(Code 4-Mrkt,ROW,Serv,Imp.V,Ease.C,T 40,000 40,000 40 Acquisition Sub-total 40,000 40,000 40 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------4020 Land(Code 4-Bus.,5%,Mrg.P,Rel$,P/Tax,Etc 4,000 4,000 4 4030 Land(Code 4-Owners(LS,Apprsl,Rprt,Lgl,In 2,800 2,800 3 4040 Land(Code 4-Demolition 0 0 0 4050 Land(Code 4-Pro.Man,P.Tax,Util,Security 400 400 0 4060 Land(Code 4-Not Used 0 0 0 4070 Land(Code 4-Not Used 0 0 0 4080 Land(Code 4-Acq.F,M/Sal,TrvlV,Cntr.S,Appr. 2,800 2,800 3 4090 Land(Code 4-Surveys 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Associated costs-sub-total 10,000 10,000 10 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------4099 Land Contingency Sub-total 7,500 7,500 8 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL LAND COSTS 57,500 57,500 58 ==== ========= =========================== ================================================= ============== =======

Page 7 Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY SUMMARY Total Company Job AREA OF Line (2001 DollarsJob Option Study SUMMARIES Cost ACTIVITY Job Option " D " ONLY CODE EST.DATE May. 1, 2001 0 C/LM Conceptual Est. MAIN RD 1000 MR 1000 Blk Est. # 6 OTHER ROADS 0 OR 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 TR 1000 1000 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------------------- ------------9800 MANAGEMENT RESERVE 0 MAN. RES. - planning 0 0 0 MAN. RES. - preliminary design 3,297 3,297 3 MAN. RES. - utility construction 1,725 1,725 2 MAN. RES. - grade construction 44,795 44,795 45 MAN. RES. - structural construction 283,319 283,319 283 MAN. RES. - paving construction 13,170 13,170 13 MAN. RES. - operation construction 637 637 1 MAN. RES. - roadside construction 0 0 0 MAN. RES. - other construction 24,552 24,552 25 MAN. RES. - project management 33,164 33,164 33 MAN. RES. - land 2,875 2,875 3 MAN. RES. - detailed eng. 33,027 33,027 33 MAN. RES. - residency eng. 35,084 35,084 35 MAN. RES. - risk contingency 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL MANAGEMENT RESERVE 475,644 475,644 476 ==== ========= =========================== ================================================= ============== ======= TOTAL LESS ESCALATION FISCAL 9900 ESCALATION YEAR PROJECTED ESCALATION 2002-2003 0.5750% 0 0 0 2003 - 2004 0.6250% 0 0 0 2004-2005 1.0000% 0 0 0 2005-2006 1.0000% 0 0 0 2006-2007 1.0000% 0 0 0 2007-2008 1.0000% 0 0 0 2008-2009 1.0000% 0 0 0 2009-2010 1.0000% 0 0 0 2010-2011 1.0000% 0 0 0 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL ESCALATION 0 0 0 ==== ========= =========================== ================================================= ============== ======= PART 2 SUMMARY NON-CONSTRUCTION COS 0 Non-Construction 1,102,406 1,102,406 1102 Non-Const. Contingency 94,014 94,014 94 -------- ---------------- ------------------------------------------------- ------------------------------------------------------------------------------------------------------------- ------------TOTAL NON-CONSTRUCTION COS 1,196,420 1,196,420 1196 ==== ========= =========================== ================================================= ============== ======= DIVISION TOTAL FOR ROAD TYPE 9,988,520 9,988,520 9989 ==== ========= =========================== ================================================= ============== =======

Page 8 Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 7.R4L-4LE 8. New 4L

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY Company Job AREA (2001 DollarsJob Option Study ACTIVITY Job Option " D " CODE EST.DATE May. 1, 2001 0 Conceptual Est. MAIN RD 1000 Blk Est. # 6 OTHER ROADS 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 -------- ---------------- ------------------------------------------------- --------------------------------------------------------------------------SUMMARY BY ACTIVITY LEVEL 2000 PROJECT MANAGEMENT 576,762 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------2500 PLANNING 0 3000 PRELIMINARY DESIGN 57,332 3500 DETAILED DESIGN 574,377 0 Total Engineering 631,709 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------4000 LAND ACQUISITION 50,000 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------5000 GRADE CONSTRUCTION 779,043 5200 ROAD SIDE CONSTRUCTION 0 5300 OTHER CONSTRUCTION 426,986 5500 STRUCTURAL CONSTRUCTION 4,927,295 6000 PAVING CONSTRUCTION 229,044 6500 OPERATIONAL CONSTRUCTION 11,073 6700 UTILITY CONSTRUCTION 30,000 6800 RESIDENT ENGINEERING 610,155 0 Total Construction 7,013,596 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------9700 CONTINGENCY 1,240,810 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------SUB-TOTAL 9,512,876 9800 MANAGEMENT RESERVE 475,644 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------TOTAL 9,988,520 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------9900 ESCALATION 0 -------- ---------------- ------------------------------------------------- -------------------------------------------------------------------------------------TOTAL COST 9,988,520 ==== ========= =========================== ================================================= Const. Less Resident Eng. 6,403,442

Page 9 SUMMARY OF SUMMARIES ONLY

MR OR TR

1000 0 1000 ------------------------

Total Line Cost

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 1000 7.R4L-4LE ------------- 8. New 4L Cost/LM % of T

576,762 577 5.8% ------------------------ ------------- ------------0 0 0.0% 57,332 57 0.6% 574,377 574 5.8% 631,709 632 ------------------------ ------------50,000 50 ------------------------ ------------779,043 779 0 0 426,986 427 4,927,295 4927 229,044 229 11,073 11 30,000 30 610,155 610 0 0 7,013,596 7014 ------------------------ ------------1,240,810 1241 ------------------------ ------------9,512,876 9513 475,644 476 ------------------------ ------------9,988,520 9989 ------------------------ ------------0 0 ------------------------ ------------9,988,520 9989 ============== ======= 6,403,442 6403

6.3% ------------0.5% ------------7.8% 0.0% 4.3% 49.3% 2.3% 0.1% 0.3% 6.1% 70.2% ------------12.4% ------------95.2% 4.8% ------------100.0% ------------------------=======

File:

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix C

APPENDIX C

NAME OF STUDY Company Job AREA (2001 DollarsJob Option Study ACTIVITY Job Option " D " CODE EST.DATE May. 1, 2001 0 Conceptual Est. MAIN RD 1000 Blk Est. # 6 OTHER ROADS 0 Version May.2./01 DESCRIPTION \TOTAL ROADS 1000 -------- ---------------- ------------------------------------------------- ---------------------------------------------------------------------------

Page 10 SUMMARY OF SUMMARIES ONLY

MR OR TR

1000 0 1000 ------------------------

Engineering 1,389,741 1,389,741 Land 57,500 57,500 Construction 8,065,636 8,065,636 Management Reserve 475,644 475,644 Escalation 0 0 Total 9,988,520 9,988,520 ------------------------------------------------- -------------------------------------------------------------------------------------- ---- -----------------------BASIC QUANTITY SUMMARY Construct.Cost ONLY Per L.M. 8,066 $/LM 8,066 Land Area 4.0 ha 4.0 Mobilization Land Cont. Construction Cont. Engineering Cont. Supervision Cont. Total Cont.

185,634 7,500 960,516 181,271 91,523 1,240,810

S.G.S.B. C.B.C. Asphalt Concrete Barrier Noise Attentuation Wall No. of Light Poles Sidewalk Curb and Gutter Signals

9,693 6,106 3,730 0 0 0 0 0 0

------------------------------------------------- -------------------------------------------------------------------------------------Total Rock 852 Total OM 41,727 Total Stripping 4,600 Total Borrow 0 Total Cut/Excavation 47,179 Total Fill 0 Surplus or Deficit 47,179 ENG & PM LAND CONST. BRIDGES-R/W MANAGEMENT RESERVE ESCALATION TOTAL (Millions)

185,634 7,500 960,516 181,271 91,523 1,240,810 m3 m3 t lm m2 ea lm lm ea m3

Total Line Cost

Road Type 1. 2ln Fron 2. 2ln Acc 3. 4ln Acc C/LM 4.R4L-4L E 5.R2/3L-4L 6.Retr.4L-4 1000 7.R4L-4LE ------------- 8. New 4L 1390 58 8066 476 0 9989

1,052,039

9,693 6,106 3,730 0 0 0 0 0 0

---- -----------------------m3 852 m3 41,727 m3 4,600 m3 0 m3 47,179 m3 0 m3 47,179

ENG 0 0 0 0 0

-------------------------------------------------------------------------------------- ---- ------------------------ ------------1.390 1.390 1.39 0.058 0.058 0.06 2.400 2.400 2.40 5.666 5.666 5.67 0.476 0.476 0.48 0.000 0.000 0.00 9.990 9.990 9.99

DIF 852 41,727 4,600 0 47,179 0

ESTIMATING MANUAL

Page 77

Appendix D Difference Report

EW

August 21, 2001

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

Company Job (2001 Dollars) Job ACTIVITY CODE EST.DATE May. 1, 2001 Conceptual Est. Divison\site Blk Est. # 6 Road Type Version May.2./01 DESCRIPTION \Length -------- ---------------- --------------------------------------------------2500 PLANNING 2521 Consultant - transport. planning study 2531 Consultant - corridor study 2541 Consultant - functional plan. study 2502 Consultant - general Consultant sub-total -------- ---------------- --------------------------------------------------2510 Ministry - project ident. 2520 Ministry - transport. planning study 2530 Ministry - corridor study 2540 Ministry - functional plan. study 2501 Ministry - general Ministry Sub-total -------- ---------------- --------------------------------------------------2599 Planning Contingency -------- ---------------- --------------------------------------------------TOTAL PLANNING ==== ========= ============================= 3000 PRELIMINARY DESIGN 3013 Consultant - aerial base plan 3014 Consultant - mapping 3015 Consultant - control survey 3021 Consultant - environmental impact 3031 Consultant - funct.-road field survey 3041 Consultant - functional design 3051 Consultant - funct. structural des. 3061 Consultant - geotechnical design 3071 Consultant - right-of-way research 3002 Consultant - general Consultant sub-total -------- ---------------- --------------------------------------------------3010 Ministry - aerial base plan 3011 Ministry - mapping 3012 Ministry - control survey 3020 Ministry - environmental impact 3030 Ministry - funct.-road field survey 3040 Ministry - functional design 3050 Ministry - funct. structural des. 3060 Ministry - geotechnical design 3070 Ministry - right-of-way research 3001 Ministry - general Ministry Sub-total -------- ---------------- --------------------------------------------------3099 Preliminary design Contingency -------- ---------------- --------------------------------------------------TOTAL PRELIMINARY DESIGN ==== ========= =============================

APPENDIX D NAME OF STUDY AREA Option Study Option " D "

NAME OF STUDY AREA Option Study

Description

Option " D "

0

0 Series (B - A ) 1000 1000 MR 0 0 0 OR 0 1000 1000 TR 0 ----------- A --------------------- B ---------------------------------------------------0 0 0 0 0 -----------------------------0 0 0 0 0 0 -----------------------------0 -----------------------------0 =================

0 0 0 0 0 -----------------------------0 0 0 0 0 0 -----------------------------0 -----------------------------0 =================

0 0 0 0 0 -----------------------------------------0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 ========================

0 10,000 0 3,000 8,000 5,000 28,332 3,000 0 0 57,332 -----------------------------0 0 0 0 0 0 0 0 0 0 0 -----------------------------8,600 -----------------------------65,932 =================

0 10,000 0 3,000 8,000 5,000 28,332 3,000 0 0 57,332 -----------------------------0 0 0 0 0 0 0 0 0 0 0 -----------------------------8,600 -----------------------------65,932 =================

0 0 0 0 0 0 0 0 0 0 0 -----------------------------------------0 0 0 0 0 0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 ========================

Page 1

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

Company Job (2001 Dollars) Job ACTIVITY CODE EST.DATE May. 1, 2001 Conceptual Est. Divison\site Blk Est. # 6 Road Type Version May.2./01 DESCRIPTION \Length -------- ---------------- --------------------------------------------------6700 UTILITIES 6710 Util. Prov. - Hydro 6711 Util. Prov. - Telephone Util. Prov. sub-total -------- ---------------- --------------------------------------------------6712 Util.Others - pipelines 6713 Util.Others - telecommunication 6714 Util.Others - storm & sewer inspect. 6715 Util.Others - waterworks inspect. 6716 Util.Others - engineering services 6717 Util.Others - parks/recreation-prel. 6718 Util.Others - transit 6719 Util.Others - tr-ops/signs & detours 6701 Util.Others - general Util.Others sub-total -------- ---------------- --------------------------------------------------6799 Util.Others Contingency -------- ---------------- --------------------------------------------------TOTAL UTILITIES ==== ========= ============================= 5000 GRADE CONSTRUCTION 5032 Grade Const- water 5033 Grade Const- sanitary 5034 Grade Const- storm 5031 Grade Const- mobilization 5039 Grade Const- utility contingency Grade Const. Utilities Sub-total 5010 5020 5030 5040 5050 5051 5060 5061 5062 5063 5064 5090 5005 5001 5099 --------------3510 3519 6810 6811 6812 6819 -------====

Grade Const- site prep./clear,grubbing Grade Const- road grade/exc,placing,fill Grade Const- drainage/pipe,cul. Grade Const- muiltiplate Grade Const-SGSB/produce,place,comp Grade Const-CBC/produce,place,comp Grade Const- grade finishing landscaping Grade Const- grade finishing hydro seed. Grade Const- grade finishing fencing Grade Const- noise barriers Grade Const- passing lanes Grade Const- sidewalks,curb & gutter Grade Const-detours c/w ex,bf,paving Grade Const- mobilization Grade Const- Contingency Grade Construction Sub-total ---------------- --------------------------------------------------GRADE CONSTRUCTION COSTS ---------------- --------------------------------------------------Grade Eng. - detailed design Grade Eng. - detailed design/Contingency Grade Eng. - general const. supervision Grade Eng. - quality assurance Grade Eng. - surveying Grade Eng. - Residency Contingency Grade Engineering Sub-total ---------------- --------------------------------------------------Total Grade Const. & Eng. Costs ========= =============================

APPENDIX D NAME OF STUDY AREA Option Study Option " D "

NAME OF STUDY AREA Option Study

Description

Option " D "

0

0 Series (B - A ) 1000 1000 MR 0 0 0 OR 0 1000 1000 TR 0 ----------- A --------------------- B ---------------------------------------------------10,000 20,000 30,000 -----------------------------0 0 0 0 0 0 0 0 0 0 -----------------------------4,500 -----------------------------34,500 =================

10,000 20,000 30,000 -----------------------------0 0 0 0 0 0 0 0 0 0 -----------------------------4,500 -----------------------------34,500 =================

0 0 0 -----------------------------------------0 0 0 0 0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 ========================

0 0 0 0 0 0 -----------------------------32,000 335,019 22,661 0 174,470 122,123 0 10,080 0 0 0 0 60,000 22,691 116,856 895,900 -----------------------------895,900 -----------------------------62,713 9,407 41,211 28,669 17,918 13,170 173,088 -----------------------------1,068,987 =================

0 0 0 0 0 0 -----------------------------32,000 335,019 22,661 0 174,470 122,123 0 10,080 0 0 0 0 60,000 22,691 116,856 895,900 -----------------------------895,900 -----------------------------62,713 9,407 41,211 28,669 17,918 13,170 173,088 -----------------------------1,068,987 =================

0 0 0 0 0 0 -----------------------------------------0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 0 0 0 0 0 0 -----------------------------------------0 ========================

Page 2

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

Company (2001 Dollars) ACTIVITY CODE Conceptual Est. Blk Est. # 6 Version May.2./01 -------- ----------------

Job Job

5510 5511 5512 5513 5514 5515 5516 5517 5518 5519 5501 5529

-------====

NAME OF STUDY AREA Option Study

Description

Option " D "

0 Series (B - A ) Divison\site 1000 1000 MR 0 Road Type 0 0 OR 0 DESCRIPTION \Length 1000 1000 TR 0 --------------------------------------------------- ----------- A --------------------- B ----------------------------------------------------

STRUCTURAL CONSTRUCTION Struct.Const - water Struct.Const - sanitary Struct.Const - storm Struct.Const - mobilization Struct.Const - utility contingency Structural Const. Utilities Sub-total

-------3520 3529 6820 6821 6822 6829

NAME OF STUDY AREA Option Study Option " D "

EST.DATE May. 1, 2001

5500 5522 5523 5524 5521 5599

--------

APPENDIX D

0

Struct.Const - tunnel site preparation Struct.Const - tunnel construction Struct.Const - snow shed site prep. Struct.Const - snow shed site const.

0 0 0 0 0 0 0 0 0 0 0 0 ------------------------------ -----------------------------0 0 2,615,022 2,615,022 0 0 0 0

0 0 0 0 0 0 -----------------------------------------0 0 0 0

Struct.Const - bridge site preparation Struct.Const - bridge piers Struct.Const - bridge abutments Struct.Const - bridge superstructure Struct.Const - retain. wall site prep. Struct.Const - retaining wall const. Struct.Const - mobilization Struct.Const - Contingency Structural Construction Sub-total ---------------- --------------------------------------------------STRUCTURAL CONSTRUCTION COSTS ---------------- --------------------------------------------------Struct. Eng. - detailed design Struct. Eng. - detailed design/Contingency Struct. Eng. - general const. supervision Struct. Eng. - quality assurance Struct. Eng. - surveying Struct. Eng. - Residency Contingency Structural Engineering Sub-total ---------------- --------------------------------------------------Total Structural & Eng. Costs ========= =============================

197,160 96,000 237,600 1,638,000 0 0 143,513 739,094 5,666,390 -----------------------------5,666,390 -----------------------------424,979 63,747 254,988 169,992 28,332 67,997 1,010,034 -----------------------------6,676,424 =================

0 0 0 0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 0 0 0 0 0 0 -----------------------------------------0 ========================

197,160 96,000 237,600 1,638,000 0 0 143,513 739,094 5,666,390 -----------------------------5,666,390 -----------------------------424,979 63,747 254,988 169,992 28,332 67,997 1,010,034 -----------------------------6,676,424 =================

Page 3

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

Company (2001 Dollars) ACTIVITY CODE Conceptual Est. Blk Est. # 6 Version May.2./01 -------- ---------------6000 6020 6030 6040 6050 6060 6070 6001 6010 6099 --------------3560 3569 6860 6861 6862 6869 -------==== 6500 6510 6520 6530 6540 6550 6501 6599 --------------3540 3549 6840 6841 6842 6849 -------====

Job Job

APPENDIX D NAME OF STUDY AREA Option Study Option " D "

NAME OF STUDY AREA Option Study

Description

Option " D "

EST.DATE May. 1, 2001

0

0 Series (B - A ) Divison\site 1000 1000 MR 0 Road Type 0 0 OR 0 DESCRIPTION \Length 1000 1000 TR 0 --------------------------------------------------- ----------- A --------------------- B ----------------------------------------------------

PAVING CONSTRUCTION Paving Cons- machine paving asphalt Paving Cons- machine paving concrete Paving Cons- hot reprofiling Paving Cons- shoulder paving Paving Cons- pavement finishing Paving Cons- seal coating Paving Cons- mobilization Paving Cons- pavement design Paving Cons- Contingency ---------------- --------------------------------------------------PAVING CONSTRUCTION COSTS ---------------- --------------------------------------------------Paving Eng. - detailed design Paving Eng. - detailed design/Contingency Paving Eng. - general const. supervision Paving Eng. - quality assurance Paving Eng. - surveying Paving Eng. - Residency Contingency Paving Engineering Sub-total ---------------- --------------------------------------------------Total Paving Const. & Eng. Costs ========= =============================

222,373 0 0 0 0 0 6,671 0 34,357 -----------------------------263,401 -----------------------------18,438 2,766 7,902 13,170 2,634 3,556 48,466 -----------------------------311,867 =================

222,373 0 0 0 0 0 6,671 0 34,357 -----------------------------263,401 -----------------------------18,438 2,766 7,902 13,170 2,634 3,556 48,466 -----------------------------311,867 =================

0 0 0 0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 0 0 0 0 0 0 -----------------------------------------0 ========================

OPERATIONAL CONSTRUCTION Operat.Cons- lighting Operat.Cons- signals Operat.Cons- signing Operat.Cons- guard rail Operat.Cons- pavement markings Operat.Cons- mobilization Operat.Cons- contingency ---------------- --------------------------------------------------OPERATIONAL CONSTRUCTION COSTS ---------------- --------------------------------------------------Operat. Eng.- detailed design Operat. Eng.- detailed design/Contingency Operat. Eng.- general const. supervision Operat. Eng.- quality assurance Operat. Eng.- surveying Operat. Eng.- Residency Contingency Operational Enginering Sub-total ---------------- --------------------------------------------------Total Operational Const.& Eng.Costs ========= =============================

0 0 2,000 0 8,750 323 1,661 -----------------------------12,733 -----------------------------891 134 764 255 127 172 2,343 -----------------------------15,076 =================

0 0 2,000 0 8,750 323 1,661 -----------------------------12,733 -----------------------------891 134 764 255 127 172 2,343 -----------------------------15,076 =================

0 0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 0 0 0 0 0 0 -----------------------------------------0 ========================

Page 4

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

Company (2001 Dollars) ACTIVITY CODE Conceptual Est. Blk Est. # 6 Version May.2./01 -------- ----------------

Job Job

5210 5220 5230 5201 5299

RoadSide Co- weighscales RoadSide Co- safety rest areas RoadSide Co- tourist rest & view areas RoadSide Co- mobilization RoadSide Co- Contingency Road Side Construction Sub-total ---------------- --------------------------------------------------ROAD SIDE CONSTRUCTION COSTS ---------------- --------------------------------------------------RoadSide En- detailed design RoadSide En- detailed design/Contingency RoadSide En- general const. supervision RoadSide En- quality assurance RoadSide En- surveying RoadSide En- Residency Contingency Road Side Engineering Sub-total ---------------- --------------------------------------------------Total Road Side Const.& Eng.Costs ========= =============================

-------==== 5300 5303 5304 5305 5302 5309

OTHER CONSTRUCTION Other Const.- water Other Const.- sanitary Other Const.- storm Other Const.- mobilization Other Const.- utility contingency Other Const. Utilities Sub-total

5310 5320 5330 5340 5301 5399

Other Const.- railroads main & spur lines Other Const.- railroad crossings Other Const.- marine work Other Const.- environmental mitigations Other Const.- mobilization Other Const.- Contingency Other Construction Sub-total ---------------- --------------------------------------------------OTHER CONSTRUCTION COSTS ---------------- --------------------------------------------------Other Eng. - detailed design Other Eng. - detailed design/Contingency Other Eng. - general const. supervision Other Eng. - quality assurance Other Eng. - surveying Other Eng. - Residency Contingency Other Engineering Sub-total ---------------- --------------------------------------------------Total Other Const.& Eng.Costs ========= =============================

--------------3570 3579 6870 6871 6872 6879 -------====

NAME OF STUDY AREA Option Study

Description

Option " D "

0 Series (B - A ) Divison\site 1000 1000 MR 0 Road Type 0 0 OR 0 DESCRIPTION \Length 1000 1000 TR 0 --------------------------------------------------- ----------- A --------------------- B ----------------------------------------------------

ROAD SIDE CONSTRUCTION RoadSide Co- water RoadSide Co- sanitary RoadSide Co- storm RoadSide Co- mobilization RoadSide Co- Utility Contingency Road Side Const. Utilities Sub-total

-------3550 3559 6850 6851 6852 6859

NAME OF STUDY AREA Option Study Option " D "

EST.DATE May. 1, 2001

5200 5203 5204 5205 5202 5209

--------

APPENDIX D

0

0 0 0 0 0 0 -----------------------------0 0 0 0 0 0 -----------------------------0 -----------------------------0 0 0 0 0 0 0 -----------------------------0 =================

0 0 0 0 0 0 -----------------------------0 0 0 0 0 0 -----------------------------0 -----------------------------0 0 0 0 0 0 0 -----------------------------0 =================

0 0 0 0 0 0 -----------------------------------------0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 0 0 0 0 0 0 -----------------------------------------0 ========================

0 0 0 0 0 0 -----------------------------414,550 0 0 0 12,436 64,048 491,034 -----------------------------491,034 -----------------------------34,372 5,156 14,731 14,731 14,731 6,629 90,350 -----------------------------581,385 =================

0 0 0 0 0 0 -----------------------------414,550 0 0 0 12,436 64,048 491,034 -----------------------------491,034 -----------------------------34,372 5,156 14,731 14,731 14,731 6,629 90,350 -----------------------------581,385 =================

0 0 0 0 0 0 -----------------------------------------0 0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 0 0 0 0 0 0 -----------------------------------------0 ========================

Page 5

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

Company Job (2001 Dollars) Job ACTIVITY CODE EST.DATE May. 1, 2001 Conceptual Est. Divison\site Blk Est. # 6 Road Type Version May.2./01 DESCRIPTION \Length -------- ---------------- --------------------------------------------------3500 DETAILED DESIGN from 3510,3520,3540,3550,3570 3530 Geotech. En - detailed design 3539 Geotech. En - Contingency -------- ---------------- --------------------------------------------------TOTAL DETAILED DESIGN COSTS ==== ========= ============================= 6800 RESIDENT ENGINEERING from 6810,6820,6840,6850,6860,6870 -------- ---------------- --------------------------------------------------TOTAL RESIDENT ENG. COSTS ==== ========= ============================= -------====

-------====

APPENDIX D NAME OF STUDY AREA Option Study Option " D "

NAME OF STUDY AREA Option Study

Description

Option " D "

0

0 Series (B - A ) 1000 1000 MR 0 0 0 OR 0 1000 1000 TR 0 ----------- A --------------------- B ----------------------------------------------------

622,603 32,983 4,947 -----------------------------660,533 ================= 0 701,678 -----------------------------701,678 ================= 0 0 ---------------- --------------------------------------------------- -----------------------------0 ========= ============================= ================= PART 1 SUMMARY CONSTRUCTION 6,403,442 ENGINEERING & SUPERVISION 1,241,863 CONTRACTUAL CONTINGENCY 1,146,796 0 ---------------- --------------------------------------------------- -----------------------------CONSTRUCTION COST TOTAL 8,792,100 ========= ============================= =================

622,603 32,983 4,947 -----------------------------660,533 ================= 0 701,678 -----------------------------701,678 ================= 0 0 -----------------------------0 =================

0 0 0 -----------------------------------------0 ========================

6,403,442 1,241,863 1,146,796 0 -----------------------------8,792,100 =================

0 0 0 0 -----------------------------------------0 ========================

0 -----------------------------------------0 ======================== 0 0 -----------------------------------------0 ========================

Page 6

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

Company Job (2001 Dollars) Job ACTIVITY CODE EST.DATE May. 1, 2001 Conceptual Est. Divison\site Blk Est. # 6 Road Type Version May.2./01 DESCRIPTION \Length -------- ---------------- --------------------------------------------------2000 PROJECT MANAGEMENT 2060 Project Man. - office costs wages 2062 Project Man. - office costs - expenses 2063 Project Man. - printing costs 2061 Project Man. - general Project Manager Sub-total -------- ---------------- --------------------------------------------------2010 Ministry - office costs wages 2012 Ministry - office costs - expenses 2030 Ministry - printing costs 2011 Ministry - general Ministry Sub-total -------- ---------------- --------------------------------------------------2070 Public Rel. - wages & expenses 2072 Public Rel. - adv., media, displays 2073 Public Rel. - opening ceremonies 2071 Public Rel. - general Public Relations Sub-total -------- ---------------- --------------------------------------------------2040 Legal Costs - lawyers fees 2041 Legal Costs - general Legal Costs Sub-total -------- ---------------- --------------------------------------------------2080 Insurance - const./ liability, E&O 2081 Insurance - general Legal Costs Sub-total -------- ---------------- --------------------------------------------------2099 Project Management Contingency -------- ---------------- --------------------------------------------------TOTAL PROJECT MANAGEMENT COSTS ==== ========= ============================= 4000 LAND 4010 Land(Code 4-Mrkt,ROW,Serv,Imp.V,Ease.C,T Acquisition Sub-total -------- ---------------- --------------------------------------------------4020 Land(Code 4-Bus.,5%,Mrg.P,Rel$,P/Tax,Etc 4030 Land(Code 4-Owners(LS,Apprsl,Rprt,Lgl,In 4040 Land(Code 4-Demolition 4050 Land(Code 4-Pro.Man,P.Tax,Util,Security 4060 Land(Code 4-Not Used 4070 Land(Code 4-Not Used 4080 Land(Code 4-Acq.F,M/Sal,TrvlV,Cntr.S,Appr. 4090 Land(Code 4-Surveys

APPENDIX D NAME OF STUDY AREA Option Study Option " D "

NAME OF STUDY AREA Option Study

Description

Option " D "

0

0 Series (B - A ) 1000 1000 MR 0 0 0 OR 0 1000 1000 TR 0 ----------- A --------------------- B ----------------------------------------------------

131,882 43,961 0 0 175,842 -----------------------------131,882 43,961 0 0 175,842 -----------------------------48,357 48,357 879 0 97,592 -----------------------------17,584 0 17,584 -----------------------------109,901 0 109,901 -----------------------------86,514 -----------------------------663,276 ================= 0 40,000 40,000 -----------------------------4,000 2,800 0 400 0 0 2,800 0 0 0 0 0 Associated costs-sub-total 10,000 -------- ---------------- --------------------------------------------------- -----------------------------4099 Land Contingency Sub-total 7,500 -------- ---------------- --------------------------------------------------- -----------------------------TOTAL LAND COSTS 57,500 ==== ========= ============================= =================

131,882 43,961 0 0 175,842 -----------------------------131,882 43,961 0 0 175,842 -----------------------------48,357 48,357 879 0 97,592 -----------------------------17,584 0 17,584 -----------------------------109,901 0 109,901 -----------------------------86,514 -----------------------------663,276 ================= 0 40,000 40,000 -----------------------------4,000 2,800 0 400 0 0 2,800 0 0 0 0 0 10,000 -----------------------------7,500 -----------------------------57,500 =================

0 0 0 0 0 -----------------------------------------0 0 0 0 0 -----------------------------------------0 0 0 0 0 -----------------------------------------0 0 0 -----------------------------------------0 0 0 -----------------------------------------0 -----------------------------------------0 ======================== 0 0 0 -----------------------------------------0 0 0 0 0 0 0 0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 ========================

Page 7

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

NAME OF STUDY Company Job AREA (2001 Dollars) Job Option Study ACTIVITY Option " D " CODE EST.DATE May. 1, 2001 0 Conceptual Est. Divison\site 1000 Blk Est. # 6 Road Type 0 Version May.2./01 DESCRIPTION \Length 1000 -------- ---------------- --------------------------------------------------- ----------- A ----------9800 MANAGEMENT RESERVE 0 MAN. RES. - planning 0 MAN. RES. - preliminary design 3,297 MAN. RES. - utility construction 1,725 MAN. RES. - grade construction 44,795 MAN. RES. - structural construction 283,319 MAN. RES. - paving construction 13,170 MAN. RES. - operation construction 637 MAN. RES. - roadside construction 0 MAN. RES. - other construction 24,552 MAN. RES. - project management 33,164 MAN. RES. - land 2,875 MAN. RES. - detailed eng. 33,027 MAN. RES. - residency eng. 35,084 MAN. RES. - risk contingency 0 -------- ---------------- --------------------------------------------------- -----------------------------TOTAL MANAGEMENT RESERVE 475,644 ==== ========= ============================= ================= TOTAL LESS ESCALATION FISCAL 9900 ESCALATION YEAR PROJECTED ESCALATION 2002-2003 0.5750% 0 2003 - 2004 0.6250% 0 2004-2005 1.0000% 0 2005-2006 1.0000% 0 2006-2007 1.0000% 0 2007-2008 1.0000% 0 2008-2009 1.0000% 0 2009-2010 1.0000% 0 2010-2011 1.0000% 0 -------- ---------------- --------------------------------------------------- -----------------------------TOTAL ESCALATION 0 ==== ========= ============================= ================= PART 2 SUMMARY NON-CONSTRUCTION COST 0 Non-Construction 1,102,406 Non-Const. Contingency 94,014 -------- ---------------- --------------------------------------------------- -----------------------------TOTAL NON-CONSTRUCTION COST 1,196,420 ==== ========= ============================= ================= DIVISION TOTAL FOR ROAD TYPE 9,988,520 ==== ========= ============================= =================

APPENDIX D NAME OF STUDY AREA Option Study

Description

Option " D "

0

Series (B - A ) 1000 MR 0 0 OR 0 1000 TR 0 ----------- B ---------------------------------------------------0 0 0 0 3,297 0 1,725 0 44,795 0 283,319 0 13,170 0 637 0 0 0 24,552 0 33,164 0 2,875 0 33,027 0 35,084 0 0 0 ----------------------------------------------------------------------475,644 0 ================= ========================

0 0 0 0 0 0 0 0 0 -----------------------------0 ================= 0 1,102,406 94,014 -----------------------------1,196,420 ================= 9,988,520 =================

0 0 0 0 0 0 0 0 0 -----------------------------------------0 ======================== 0 0 0 -----------------------------------------0 ======================== 0 ========================

Page 8

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

APPENDIX D

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

NAME OF STUDY NAME OF STUDY Description Company Job AREA AREA (2001 Dollars) Job Option Study Option Study ACTIVITY Option " D " Option " D " CODE EST.DATE May. 1, 2001 0 0 Series (B - A ) Conceptual Est. Divison\site 1000 1000 MR 0 Blk Est. # 6 Road Type 0 0 OR 0 Version May.2./01 DESCRIPTION \Length 1000 1000 TR 0 -------- ---------------- --------------------------------------------------- ----------- A --------------------- B ---------------------------------------------------SUMMARY BY ACTIVITY LEVEL 2000 PROJECT MANAGEMENT 576,762 -------- ---------------- --------------------------------------------------- -----------------------------2500 PLANNING 0 3000 PRELIMINARY DESIGN 57,332 3500 DETAILED DESIGN 574,377 0 Total Engineering 631,709 -------- ---------------- --------------------------------------------------- -----------------------------4000 LAND ACQUISITION 50,000 -------- ---------------- --------------------------------------------------- -----------------------------5000 GRADE CONSTRUCTION 779,043 5200 ROAD SIDE CONSTRUCTION 0 5300 OTHER CONSTRUCTION 426,986 5500 STRUCTURAL CONSTRUCTION 4,927,295 6000 PAVING CONSTRUCTION 229,044 6500 OPERATIONAL CONSTRUCTION 11,073 6700 UTILITY CONSTRUCTION 30,000 6800 RESIDENT ENGINEERING 610,155 0 Total Construction 7,013,596 -------- ---------------- --------------------------------------------------- -----------------------------9700 CONTINGENCY 1,240,810 -------- ---------------- --------------------------------------------------- -----------------------------SUB-TOTAL 9,512,876 9800 MANAGEMENT RESERVE 475,644 -------- ---------------- --------------------------------------------------- -----------------------------TOTAL 9,988,520 -------- ---------------- --------------------------------------------------- -----------------------------9900 ESCALATION 0 -------- ---------------- --------------------------------------------------- -----------------------------TOTAL COST 9,988,520 ==== ========= ============================= ================= Const. Less Resident Eng. 6,403,442

576,762 -----------------------------0 57,332 574,377 0 631,709 -----------------------------50,000 -----------------------------779,043 0 426,986 4,927,295 229,044 11,073 30,000 610,155 0 7,013,596 -----------------------------1,240,810 -----------------------------9,512,876 475,644 -----------------------------9,988,520 -----------------------------0 -----------------------------9,988,520 ================= 6,403,442

0 -----------------------------------------0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 0 0 0 0 0 0 0 0 0 -----------------------------------------0 -----------------------------------------0 0 -----------------------------------------0 -----------------------------------------0 -----------------------------------------0 ======================== 0

Page 9

PRINTING DATE: 12/21/02 Estimated by Ernest Wolski

File:

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix D

Company (2001 Dollars) ACTIVITY CODE Conceptual Est. Blk Est. # 6 Version May.2./01 -------- ----------------

Job Job

APPENDIX D NAME OF STUDY AREA Option Study Option " D "

EST.DATE May. 1, 2001

NAME OF STUDY AREA Option Study

Description

Option " D "

0

0 Series (B - A ) Divison\site 1000 1000 MR 0 Road Type 0 0 OR 0 DESCRIPTION \Length 1000 1000 TR 0 --------------------------------------------------- ----------- A --------------------- B ---------------------------------------------------Engineering 1,389,741 1,389,741 0 Land 57,500 57,500 0 Construction 8,065,636 8,065,636 0 Management Reserve 475,644 475,644 0 Escalation 0 0 0 Total 9,988,520 9,988,520 0 --------------------------------------------------- ------------------------------ ------------------------------ ------ -------------------------BASIC QUANTITY SUMMARY Construct.Cost ONLY Per L.M. 8,066 8,066 $/LM 0 Land Area 4.0 4.0 ha 0.0 Mobilization Land Cont. Construction Cont. Engineering Cont. Supervision Cont. Total Cont.

185,634 7,500 960,516 181,271 91,523 1,240,810

185,634 7,500 960,516 181,271 91,523 1,240,810

S.G.S.B. C.B.C. Asphalt Concrete Barrier Noise Attentuation Wall No. of Light Poles Sidewalk Curb and Gutter Signals

9,693 6,106 3,730 0 0 0 0 0 0

9,693 6,106 3,730 0 0 0 0 0 0

0 0 0 0 0 0 m3 m3 t lm m2 ea lm lm ea

0 0 0 0 0 0 0 0 0

--------------------------------------------------- ------------------------------ ------------------------------ ------ -------------------------Total Rock 852 852 m3 0 Total OM 41,727 41,727 m3 0 Total Stripping 4,600 4,600 m3 0 Total Borrow 0 0 m3 0 Total Cut/Excavation 47,179 47,179 m3 0 Total Fill 0 0 m3 0 Surplus or Deficit 47,179 47,179 m3 0 ENG & PM LAND CONST. BRIDGES-R/W MANAGEMENT RESERVE ESCALATION TOTAL (Millions)

------------------------------ ------------------------------ ------ -----------------------------------------1.390 1.390 0.000 0.058 0.058 0.000 2.400 2.400 0.000 5.666 5.666 0.000 0.476 0.476 0.000 0.000 0.000 0.000 9.990 9.990 0.000

Page 10

ESTIMATING MANUAL

Page 78

Appendix E Activity Item List

EW

August 21, 2001

APPENDIX E

PRINTING DATE: 12/21/02

B 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81

File:

C

D

E

F

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix E

Company Job (2001 Dollars) Job ACTIVITY Job CODE EST.DATE May. 1, 2001 Conceptual Est. R1 DATE: Blk Est. # 6 R2 DATE: Number of Version May.2./01 DESCRIPTION Activities ----------- ----------------------- --------------------------------------------------

5:43 PM

Page 1

2000 2010 2011 2012 2030 2040 2041 2060 2061 2062 2063 2070 2071 2072 2073 2080 2081 2099

PROJECT MANAGEMENT Ministry - office costs wages Ministry - general Ministry - office costs - expenses Ministry - printing costs Legal Costs - lawyers fees Legal Costs - general Project Man. - office costs wages Project Man. - general Project Man. - office costs - expenses Project Man. - printing costs Public Rel. - wages & expenses Public Rel. - general Public Rel. - adv., media, displays Public Rel. - opening ceremonies Insurance - const./ liability, E&O Insurance - general Project Management Contingency

2500 2501 2502 2510 2520 2521 2530 2531 2540 2541 2599

PLANNING Ministry - general Consultant - general Ministry - project ident. Ministry - transport. planning study Consultant - transport. planning study Ministry - corridor study Consultant - corridor study Ministry - functional study Consultant - functional plan. study Planning Contingency

3000 3001 3002 3010 3011 3012 3013 3014 3015 3020 3021 3030 3031 3040 3041 3050 3051 3060 3061 3070 3071 3099

PRELIMINARY DESIGN Ministry - general Consultant - general Ministry - aerial base plan Ministry - mapping Ministry - control survey Consultant - aerial base plan Consultant - mapping & prel. Consultant - control survey Ministry - environmental impact Consultant - environmental impact Ministry - funct.-road field survey Consultant - funct.-road field survey Ministry - functional design Consultant - functional design Ministry - funct. des. structural Consultant - funct. des. structural Ministry - geotechnical design Consultant - geotechnical design Ministry - right-of-way research Consultant - right-of-way research Preliminary design Contingency

3500 3510 3519 3520 3529 3530 3539 3540 3549 3550 3559 3560 3569 3570 3579

DETAILED DESIGN Grade Eng. - detailed design Grade Eng. - detailed design/Contingency Struct. Eng. - detailed design Struct. Eng. - detailed design/Contingency Geotech. Eng. - detailed design Geotech. Eng. - Contingency Operat. Eng. - detailed design Operat. Eng. - detailed design/Contingency RoadSide Eng. - detailed design RoadSide Eng. - detailed design/Contingency Paving Eng. - detailed design Paving Eng. - detailed design/Contingency Other Eng. - detailed design Other Eng. - detailed design/Contingency

Number of Summmary Elements 1

17 1

11 1

21 1

14

ESTIMATED BY :E.WOLSKI

APPENDIX E

PRINTING DATE: 12/21/02

B 3 4 5 6 7 8 9 10 11 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159

File:

C

D

E

F

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix E

Company Job (2001 Dollars) Job ACTIVITY Job CODE EST.DATE May. 1, 2001 Conceptual Est. R1 DATE: Blk Est. # 6 R2 DATE: Number of Version May.2./01 DESCRIPTION Activities ----------- ----------------------- --------------------------------------------------

5:43 PM

Page 2

4000 4010 4020 4030 4040 4050 4060 4070 4080 4090 4099

LAND Land(Code 401) -Mrkt,ROW,Serv,Imp.V,Ease.C,T Land(Code 402) -Bus.,5%,Mrg.P,Rel$,P/Tax,Etc Land(Code 403) -Owners(LS,Apprsl,Rprt,Lgl,In Land(Code 404) -Demolition Land(Code 405) -Pro.Man,P.Tax,Util,Security Land(Code 406) -Not Used Land(Code 407) -Not Used Land(Code 408) -Acq.F,M/Sal,TrvlV,Cntr.S,Appr. Land(Code 409) -Surveys Land Contingency Sub-total

5000 5001 5005 5010 5020 5030 5031 5032 5033 5034 5039 5040 5050 5051 5060 5061 5062 5063 5064 5090 5099

GRADE CONSTRUCTION Grade Const. - mobilization Grade Const. -detours c/w ex,bf,paving Grade Const. - site prep./clear,grubbing Grade Const. - road grade/exc,placing,fill Grade Const. - drainage/pipe,cul. Grade Const. - mobilization Grade Const. - water Grade Const. - sanitary Grade Const. - storm Grade Const. - utility contingency Grade Const. - muiltiplate Grade Const. -SGSB/produce,place,comp Grade Const. -CBC/produce,place,comp Grade Const. - grade finishing landscaping Grade Const. - grade finishing hydro seed. Grade Const. - grade finishing fencing Grade Const. - noise barriers Grade Const. - passing lanes Grade Const. - sidewalks,curb & gutter Grade Const. - Contingency

5200 5201 5202 5203 5204 5205 5209 5210 5220 5230 5299

ROAD SIDE CONSTRUCTION RoadSide Const - mobilization RoadSide Const - mobilization RoadSide Const - water RoadSide Const - sanitary RoadSide Const - storm RoadSide Const - Utility Contingency RoadSide Const - weighscales RoadSide Const - safety rest areas RoadSide Const - tourist rest & view areas RoadSide Const - Contingency

5300 5301 5302 5303 5304 5305 5309 5310 5320 5330 5340 5399

OTHER CONSTRUCTION Other Const. - mobilization Other Const. - mobilization Other Const. - water Other Const. - sanitary Other Const. - storm Other Const. - utility contingency Other Const. - railroads main & spur lines Other Const. - railroad crossings Other Const. - marine work Other Const. - environmental mitigations Other Const. - Contingency

5500 5501 5510 5511 5512 5513 5514 5515 5516 5517 5518 5519 5521 5522 5523 5524 5529 5599

STRUCTURAL CONSTRUCTION Struct.Const. - mobilization Struct.Const. - tunnel site preparation Struct.Const. - tunnel construction Struct.Const. - snow shed site prep. Struct.Const. - snow shed site const. Struct.Const. - bridge site preparation Struct.Const. - bridge piers Struct.Const. - bridge abutments Struct.Const. - bridge superstructure Struct.Const. - retain. wall site prep. Struct.Const. - retaining wall const. Struct.Const. - mobilization Struct.Const. - water Struct.Const. - sanitary Struct.Const. - storm Struct.Const. - Contingency Struct.Const. - utility contingency

Number of Summmary Elements 1

10 1

20 1

10 1

11 1

17

ESTIMATED BY :E.WOLSKI

APPENDIX E

PRINTING DATE: 12/21/02

B 3 4 5 6 7 8 9 10 11 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223

File:

C

D

E

F

E:\Data\Cost Estimating\Tools\Wolski\Version 6.1\[Appendices A,B,C,D,E.xls]Appendix E

Company Job (2001 Dollars) Job ACTIVITY Job CODE EST.DATE May. 1, 2001 Conceptual Est. R1 DATE: Blk Est. # 6 R2 DATE: Number of Version May.2./01 DESCRIPTION Activities ----------- ----------------------- --------------------------------------------------

6000 6001 6010 6020 6030 6040 6050 6060 6070 6099

PAVING CONSTRUCTION Paving Const. - mobilization Paving Const. - pavement design Paving Const. - machine paving asphalt Paving Const. - machine paving concrete Paving Const. - hot reprofiling Paving Const. - shoulder paving Paving Const. - pavement finishing Paving Const. - seal coating Paving Const. - Contingency

6500 6501 6510 6520 6530 6540 6550 6599

OPERATIONAL CONSTRUCTION Operat.Const. - mobilization Operat.Const. - lighting Operat.Const. - signals Operat.Const. - signing Operat.Const. - guard rail Operat.Const. - pavement markings Operat.Const. - contingency

6700 6701 6710 6711 6712 6713 6714 6715 6716 6717 6718 6719 6799

UTILITIES Util.Others - general Util. Prov. - Hydro Util. Prov. - Telephone Util.Others - pipelines Util.Others - telecommunication Util.Others - storm & sewer inspect. Util.Others - waterworks inspect. Util.Others - engineering services Util.Others - parks/recreation-prel. Util.Others - transit Util.Others - tr-ops/signs & detours Util.Others Contingency

6800 6810 6811 6812 6819 6820 6821 6822 6829 6840 6841 6842 6849 6850 6851 6852 6859 6860 6861 6862 6869 6870 6871 6872 6879

RESIDENT ENGINEERING Grade Eng. - general const. supervision Grade Eng. - quality assurance Grade Eng. - surveying Grade Eng. - Residency Contingency Struct. Eng. - general const. supervision Struct. Eng. - quality assurance Struct. Eng. - surveying Struct. Eng. - Residency Contingency Operat. Eng. - general const. supervision Operat. Eng. - quality assurance Operat. Eng. - surveying Operat. Eng. - Residency Contingency RoadSide Eng. - general const. supervision RoadSide Eng. - quality assurance RoadSide Eng. - surveying RoadSide Eng. - Residency Contingency Paving Eng. - general const. supervision Paving Eng. - quality assurance Paving Eng. - surveying Paving Eng. - Residency Contingency Other Eng. - general const. supervision Other Eng. - quality assurance Other Eng. - surveying Other Eng. - Residency Contingency

9700 CONTINGENCY 9800 MANAGEMENT RESERVE 9900 ESCALATION ---------- ----------------------- --------------------------------------------------

5:43 PM

Page 3

Number of Summmary Elements 1

9 1

7 1

12 1

24

1 1 185

1 1 1 16

ESTIMATED BY :E.WOLSKI

ESTIMATING MANUAL

Page 79

Appendix F Activity Item Description

EW

August 21, 2001

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

Description

Description of Work

2500 2521

Consultant

PLANNING transportation planning study

2531

Consultant

corridor study

2541

Consultant

functional planning study · Present description requires redefining. · Route Study: Development of accurate plans for all feasible alignments and/or configuration of intersections/interchanges in any corridor.

2502

Consultant

general

· Present description requires redefining. · Needs Study: Identification of requirements for new or improved highway. · Reconnaissance Study: Qualitative identification of all possible corridors between two specified nodes and assessment of feasibility of each. Quantitative evaluation to select a preferred corridor

Miscellaneous costs

Consultant Sub-Total 2510

Ministry

project identity

Present description requires redefining.

2520

Ministry

transportation planning study

· Present description requires redefining. · Needs Study: Identification of requirements for new or improved highway. · Reconnaissance Study: Qualitative identification of all possible corridors between two specified nodes and assessment of feasibility of each.

2530

Ministry

corridor study

Quantitative evaluation to select a preferred corridor.

2540

Ministry

functional plan. study

· Present description requires redefining. · Route Study: Development of accurate plans for all feasible alignments and/or configuration of intersections/interchanges in any corridor.

2501

Ministry

general

Miscellaneous costs

Ministry Sub-Total 2599

Planning Contingency

Provision for work not identified.

Total Planning

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 1 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

3000

Description

Description of Work

PRELIMINARY DESIGN

3013

Consultant

aerial base plan

Present work item description is under review.

3014

Consultant

mapping & preliminary design

Preliminary Design: Determining the ability of selected locations and configurations to meet the needs and requirements established in previous stages and selecting the most appropriate for subsequent more detailed work.

3015

Consultant

control survey

Preliminary Design: Work item description is under review.

3021

Consultant

environmental impact

Preliminary Design: Work item description is under review.

3031

Consultant

functional-road field survey

Functional Design: Work item description is under review.

3041

Consultant

functional design

Functional Design: Geometric design of the horizontal and vertical alignment selected in the preliminary design, based on field survey data.

3051

Consultant

functional design structural

Functional Design: Preliminary design of structures is done before detailed design.

3061

Consultant

geotechnical design

Preliminary Design: Work item description is under review.

3071

Consultant

right-of-way research

Preliminary Design: Work item description is under review.

3002

Consultant

general

Miscellaneous costs

Consultant Sub-Total 3010

Ministry

aerial base plan

Present work item description is under review.

3011

Ministry

mapping

Preliminary Design: Determining the ability of selected locations and configurations to meet the needs and requirements established in previous stages and selecting the most appropriate for subsequent more detailed work.

3012

Ministry

control survey

Preliminary Design: Work item description is under review.

3020

Ministry

environmental impact

Preliminary Design: Work item description is under review.

3030

Ministry

functional - road field survey

Functional Design: Work item description is under review.

3040

Ministry

functional design

Functional Design: Geometric design of the horizontal and vertical alignment selected in the preliminary design, based on field survey data.

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 2 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items Activity Code

Activity

Description

Description of Work

3050

Ministry

functional design structural

Functional Design: Preliminary design of structures is done before detailed design.

3060

Ministry

geotechnical design

Preliminary Design: Work item description is under review.

3070

Ministry

right-of-way research

Preliminary Design: Work item description is under review.

3001

Ministry

general

Miscellaneous costs

Ministry Sub-Total 3099

Preliminary Design Contingency

Provision for work not identified.

Total Preliminary Design

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 3 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

6700 6710 6711

Activity

Utilities Provincial Utilities Provincial

Description

UTILITIES B.C. hydro B.C. telephone

Description of Work

Engineering and construction of new or temporary, overhead or underground transmission lines. Engineering and construction of new or temporary, overhead or underground telephone lines.

Utilities Provincial Sub-Total 6712

Utilities Others

pipelines

Engineering and construction of new or temporary oil or gas pipe lines. Centra Gas.

6713

Utilities Others

telecommunication, cable

Engineering and construction of new or temporary, overhead or underground communication transmission lines. Fiber optics, microwave, short-wave communications and satellite antennas.

6714

Utilities Others

storm & sewer inspect.

Inspection costs by third party interests, other agencies or municipalities.

6715

Utilities Others

waterworks inspect.

Inspection costs by third party interests, other agencies or municipalities.

6716

Utilities Others

engineering services

Inspection costs by third party interests, other agencies or municipalities.

6717

Utilities Others

parks/recreationpreliminary

Inspection costs by third party interests, other agencies or municipalities.

6718

Utilities Others

transit

Work required for bus shelters, benches.

6719

Utilities Others

traffic operations/signs and detours

Inspection costs by third party interests, other agencies or municipalities.

6701

Utilities Others

general

Miscellaneous utilities not covered above.

Utilities Others Sub-Total 6799

Utilities Others Contingency

Provision for work not identified.

Total Utilities

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 4 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

5000

Activity

Description

Description of Work

GRADE CONSTRUCTION

5032

Grade water Construction

Work required to do watermains including excavating, laying, jointing, commissioning and backfilling, pipe, fittings, fire hydrants, water connecting services, etc. Plug, remove or adjust any of the above items. Supply, install and removal of a temporary water supply.

5033

Grade sanitary Construction

Work required to do sanitary lines including excavating, laying and backfilling pipe, manholes, lift stations, etc. Plug, remove or adjust any of the above items.

5034

Grade storm Construction

Work required to do storm lines including excavating, laying and backfilling, pipe, manholes, catch basins, outfalls, etc. Plug, remove or adjust any of the above items.

5031

Grade utility general Construction

Mobilization costs required by a general contractor for water, sanitary and storm construction.

5039

Grade utility contingency Construction

Provision for work not identified.

Grade Construction Utilities Sub-Total 5010

Grade site preparation, clearing, Work required to do clearing and grubbing. Removal and disposal of standing and fallen trees, stumps, Construction grubbing logs, upturned roots, rotten wood and all other vegetation growth. Clearing, grubbing, clearing including logging, log hauling and cold decking merchantable timber, close-cut clearing, danger trees, etc..

5020

Grade road grade excavation, Construction placing fill, earthworks

Work required to construct a road bed. Excavate, supply or remove, haul, place, compact, water, fill, type A, B, C, D roadway material, organic stripping, surcharging, wick drains, lightweight fill, backfill, waste material, bridge end fills, dredging, additional topsoil, granular backfill, etc. Supply, process, haul, and place necessary topsoil for future work.

5020

Grade rock excavation Construction

Work required to excavate rock. Blasting, smooth wall blasting, drilling

5030

Grade drainage/pipe, culvert Construction

Work required to construct ditches, pipes, culverts, headwalls. Foundation type A,B,C,D excavation, corrugated steel pipe, asphalt coated corrugated steel pipe, catch basins, manholes, storm drain pipe, structural backfill, bedding and backfill material, riprap, inlet and outlet structures, spillways and channels, sandbags, filter cloth, etc. Plug, remove or adjust any of the above items.

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 5 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

Description

Description of Work

5040

Grade multiplate Construction

Structural Assembly required for crossing a creek or a crossing under a highway for wildlife and vehicles.The Assembly could be corrugated steel pipe or precast arch panels (NOT A BRIDGE) Work required to construct the assembly and headwalls, including excavation (Type A,B,C,D material), bedding and backfill material, structural backfill.

5050

Grade SGSB/produce, place, Construction compact

S.G.S.B. - Select Granular Sub-Base Material. Requires material to be supplied, hauled, placed and compacted. S.G.S.B material could come from existing R.O.W. or from off-site gravel pits

5051

Grade CBC/produce, place, Construction compact

C.B.C. - Crushed Granular Base Course. Requires material to be crushed, loaded, hauled, placed and compacted. Other surface aggregate materials come under this category (shoulder aggregate/work)

5060

Grade grade finishing Construction landscaping

Work required to do lawns, trees, shrubs, ground cover; including soil preparation and finish grading involving topsoil and landscaping accessories. Irrigation, maintenance, sidewalks, curbs, walls, etc. Preservation and relocation of existing vegetation. (Bark Mulching = area)

5061

Grade grade finishing Construction hydroseed.

Work required to do hydraulic seeding, mulching, fertilizing, maintenance, etc..

5062

Grade fencing Construction

Work required to do fences; chain link, type A,B,C, wood fences, standard wire fence(C,C1,C2), gates, ungulate, etc. Removal, disposal and modification to items above.

5063

Grade noise barriers Construction

Work required to do noise barriers. Barriers can be sound absorptive or sound reflective. Barrier walls can be dirt, masonry, precast panels, steel, etc..

5064

Grade passing lanes Construction

An elemental cost item that can be used in the estimate sheet if required. The element includes excavation, fill, SGSB, CBC, pavement, etc.

5090

Grade sidewalks, curb & gutter Work required to construct all types of curbs and sidewalks. Construction Curbs and sidewalks can be of asphalt, gravel, concrete, bollards, concrete steps, etc. Removal, disposal and modification to items above.

5005

Grade detours c/w excavation, Construction backfill, paving

An elemental cost item that can be used in the estimate sheet if required. Staging cost that is required to produce the ultimate alignment. Provision for traffic through the site The element includes excavation, fill, SGSB, CBC, pavement, etc.

5001

Grade general & urban design Construction

Mobilization costs; setting up and moving out, layout work, traffic control, layout for field design, etc.

5099

Grade contingency Construction

Provision for work not identified.

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 6 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items Activity Code

Activity

Description

Description of Work

Grade Construction Sub-Total GRADE CONSTRUCTION COSTS 3510

Grade detailed design Engineering

The development of construction (contract) drawings and technical specifications for construction, including the completed geometric and geotechnical design, special site considerations and construction details.

3519

Grade detailed Engineering design/Contingency

Provision for work not identified.

6810

Grade general construction Engineering supervision

Administration required on site; site office, analyzing, logging and record keeping of field data. Project security, removal of graffiti.

6811

Grade quality assurance Engineering

Work performed on site so that the product received meets the standards specified.

6812

Grade surveying Engineering

Work performed on site, to measure quantities for pay items.

6819

Grade residency contingency Engineering

Provision for work not identified.

Grade Engineering Sub-Total Total Grade Construction and Engineering Costs

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 7 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

5500

Description

Description of Work

STRUCTURAL CONSTRUCTION

5522

Structural water Construction

Work required to do watermains including excavating, laying, jointing, commissioning and backfilling, pipe, fittings, fire hydrants, water connecting services, etc. Plug, remove or adjust any of the above items. Supply, installation and removal of a temporary water supply.

5523

Structural sanitary Construction

Work required to do sanitary lines including excavating, laying and backfilling pipe, manholes, lift stations, etc. Plug, remove or adjust any of the above items.

5524

Structural storm Construction

Work required to do storm lines including excavating, laying and backfilling, pipe, manholes, catch basins, outfalls, etc. Plug, remove or adjust any of the above items.

5521

Structural utility general Construction

Mobilization costs required by a general contractor for water, sanitary and storm construction.

5599

Structural utility contingency Construction

Provision for work not identified.

Structural Construction Utilities Sub-Total 5510

Structural tunnel site preparation Construction

Work required to prepare the site for tunnel construction. Access road construction, clearing and grubbing, etc.

5511

Structural tunnel construction Construction

Work required to construct a tunnel. Foundation Type A,B,C,D excavation and backfill, cast-in-place or precast concrete, drainage, electrical, vent shafts, portals, boring, etc.

5512

Structural snow shed site Construction preparation

Work required to prepare the site for snow shed construction. Access road construction, clearing and grubbing, etc.

5513

Structural snow shed site Construction construction

Work required to construct a snow shed. Foundation Type A,B,C,D excavation and backfill, Cast-in-place or Precast concrete, drainage, electrical, signage, etc.

5514

Structural Bridge site preparation Construction

Work required to prepare the site for bridge construction. Access road construction, cofferdams, clearing and grubbing, temporary bridge crossings, fall protection, etc. Demolition of old bridges.

5515

Structural Bridge piers Construction

Work required to construct a pier. foundation Type A,B,C,D excavation and backfill, piling, cast-inplace footing and piers, etc.

5516

Structural Bridge abutments Construction

Work required to construct abutments. Foundation Type A,B,C,D excavation and backfill, piling, cast-inplace footing, walls, wing walls, approach slab, slope protection, etc.

Activity

Description of Work

Activity

Description

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 8 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items Code

5517

Structural Bridge superstructure Construction

Work required to construct the superstructure. Main supporting girders; Cast-in-place, Precast, Steel Diaphragms, deck, rail, bearings, expansion joints, deck surface treatments, site modifications, etc.

5518

Structural retain. wall site prep. Construction

Under special circumstances where the site requires special preparation, otherwise retaining wall cost would apply to the next item. Removal and disposal of old retaining walls.

5519

Structural retaining wall Construction construction

Work required to construct retaining walls. Foundation Type A,B,C,D excavation and backfill, piling, cast-inplace, precast, bin, gravity, rock, lock blocks, etc..

5501

Structural general & urban design Construction

Mobilization costs required by a general contractor for items above. Move in/Move out

5529

Structural contingency Construction

Provision for work not identified.

Structural Construction Sub-Total STRUCTURAL CONSTRUCTION COSTS 3520

Structural detailed design Engineering

The development of construction (contract) drawings and technical specifications for construction, including the completed geometric and geotechnical design, special site considerations and construction details.

3529

Structural detailed Engineering design/Contingency

Provision for work not identified.

6820

Structural general construction Engineering supervision

Administration required on site; site office, analyzing, logging and record keeping of field data. Project Security

6821

Structural quality assurance Engineering

Work performed on site so that the product received meets the standards specified.

6822

Structural surveying Engineering

Work performed on site, to measure quantities for pay items.

6829

Structural residency contingency Engineering

Provision for work not identified.

Structural Engineering Sub-Total Total Structural and Engineering Costs

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 9 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

6000

Description

Description of Work

PAVING CONSTRUCTION

6020

Paving machine paving asphalt Construction

Work required to do paving. Pavement element; spray primer and tack coat, asphalt binder course, asphalt concrete pavement, recycled asphalt material, etc. Removal, disposal and modification to items above.

6030

Paving machine paving concrete Work required to do portland cement roller-compacted concrete. Construction (not used on this project) Extruded concrete curb, concrete island paving, etc.

6040

Paving hot reprofiling Construction

Work required to do hot reprofiling of existing pavement by heater scarification. Supply, handle, store, heat and apply cyclogen "L".

6050

Paving shoulder paving Construction

Work required to do shoulder paving only, all other work is in activity 6020.

6060

Paving pavement finishing Construction

Work required to do extra machine or hand finishing. Driveways, intersection islands, median curb (concrete, asphalt), traffic islands, etc.

6070

Paving seal coating Construction

Work required to do chip sand aggregate seal to a road surface.

6001

Paving general Construction

Mobilization costs required by a general contractor for items above.

6010

Paving pavement design Construction

Costs associated with developing a pavement design mix.

6099

Paving contingency Construction

Provision for work not identified.

Paving Construction Sub-Total PAVING CONSTRUCTION COSTS 3580

Paving detailed design Engineering

The development of construction (contract) drawings and technical specifications for construction, including the completed geometric and geotechnical design, special site considerations and construction details.

3589

Paving detailed Engineering design/Contingency

Provision for work not identified.

6860

Paving general construction Engineering supervision

Administration required on site; site office, analyzing, logging and record keeping of field data.

6861

Paving quality assurance Engineering

Work performed on site so that the product received meets the standards specified.

Activity

Description of Work

Activity

Description

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 10 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items Code

6862

Paving surveying Engineering

Work performed on site, to measure quantities for pay items.

6869

Paving residency contingency Engineering Paving Engineering Sub-Total

Provision for work not identified.

Total Paving Construction and Engineering Costs

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 11 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

6500

Description

Description of Work

OPERATIONAL CONSTRUCTION

6510

Operational lighting Construction

Work required to do roadway, tunnel and highmast illumination for a roadway. (temporary and permanent) Excavation (Type A,B,C,D),Backfill, trenching, overhead, conduit, junction boxes, post flasher pedestal, etc. Removal, disposal and modification to items above.

6520

Operational signals Construction

Work required to do signals at a controlled location. (temporary and permanent). Excavation (Type A,B,C,D),Backfill, trenching, conduit, wiring, traffic signal heads, supports, controllers, traffic counters, detector loops, etc. Removal, disposal and modification to items noted.

6530

Operational signing Construction

Work required to install signs. (temporary and permanent) Warning, information, guide, regulator, message signs, overhead signs, breakaway sign structure, wood post sign structures, delineators, lighting for signs, detour, etc. Removal, disposal and modification to items above.

6540

Operational guard rail Construction

Work required to do median and roadside safety barrier; metal, concrete, attenuators, barrier reflectors, G.R.E.A.T., etc. Removal, disposal and relocation to items above.

6550

Operational pavement markings Construction

Work required to do road, island, x-hatch, walk, curb pavement markings.(Temporary, Permanent) reflectors, stimsonite reflectors, etc. Removal of items above.

6501

Operational general Construction

Mobilization costs required by a general contractor for items above.

6599

Operational contingency Construction

Provision for work not identified.

Operational Construction Sub-Total OPERATIONAL CONSTRUCTION COSTS 3540

Operational detailed design Engineering

The development of construction (contract) drawings and technical specifications for construction, including the completed geometric and geotechnical design, special site considerations and construction details.

3549

Operational detailed Engineering design/Contingency

Provision for work not identified.

6840

Operational general construction Engineering supervision

Administration required on site; site office, analyzing, logging and record keeping of field data.

6841

Operational quality assurance Engineering

Work performed on site so that the product received meets the standards specified.

Activity

Description of Work

Activity

Description

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 12 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items Code

6842

Operational surveying Engineering

Work performed on site, to measure quantities for pay items.

6849

Operational residency contingency Engineering

Provision for work not identified.

Operational Engineering Sub-Total Total Operational Construction and Engineering Costs

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 13 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

5200

Description

Description of Work

ROADSIDE CONSTRUCTION

5203

Roadside water Construction

Work required to do watermains including excavating, laying, jointing, commissioning and backfilling, pipe, fittings, fire hydrants, water connecting services, etc. Plug, remove or adjust any of the above items. Supply, install and removal of a temporary water supply.

5204

Roadside sanitary Construction

Work required to do sanitary lines including excavating, laying and backfilling pipe, manholes, lift stations, etc. Plug, remove or adjust any of the above items.

5205

Roadside storm Construction

Work required to do storm lines including excavating, laying and backfilling, pipe, manholes, catch basins, outfalls, etc. Plug, remove or adjust any of the above items.

5202

Roadside general Construction

Mobilization costs required by a general contractor for water, sanitary and storm construction.

5209

Roadside utility Contingency Construction

Provision for work not identified.

Roadside Construction Utilities Sub-Total 5210

Roadside weighscales Construction

Work required to do all types of weigh scales. Site construction, buildings, pits, storage areas, parking lots, access and exit roads, lighting, etc.

5220

Roadside tourist info centers Construction

Work required to do tourist information centers. Site construction, buildings, parking lots for cars and busses, landscaping, entrance and exit roads.

5230

Roadside tourist rest & view areas Work required to do rest and view areas. Site construction, buildings, parking lots for cars and busses, Construction landscaping, entrance and exit roads.

5201

Roadside general & urban design Construction

Mobilization costs required by a general contractor for items above.

5299

Roadside contingency Construction

Provision for work not identified.

Roadside Construction Sub-Total ROADSIDE CONSTRUCTION COSTS 3550

Activity

Roadside detailed design Engineering

The development of construction (contract) drawings and technical specifications for construction, including the completed geometric and geotechnical design, special site considerations and construction details.

Activity

Description of Work

Description

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 14 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items Code

3559

Roadside detailed Engineering design/Contingency

Provision for work not identified.

6850

Roadside general construction Engineering supervision

Administration required on site; site office, analyzing, logging and record keeping of field data.

6851

Roadside quality assurance Engineering

Work performed on site so that the product received meets the standards specified.

6852

Roadside surveying Engineering

Work performed on site, to measure quantities for pay items.

6859

Roadside residency contingency Engineering

Provision for work not identified.

Roadside Engineering Sub-Total Total Roadside Construction and Engineering Costs

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 15 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

5300

Activity

Description

Description of Work

OTHER CONSTRUCTION

5303

Other water Construction

Work required to do watermains including excavating, laying, jointing, commissioning and backfilling, pipe, fittings, fire hydrants, water connecting services, etc. Plug, remove or adjust any of the above items. Supply, install and removal of a temporary water supply.

5304

Other sanitary Construction

Work required to do sanitary lines including excavating, laying and backfilling pipe, manholes, lift stations, etc. Plug, remove or adjust any of the above items.

5305

Other storm Construction

Work required to do storm lines including excavating, laying and backfilling, pipe, manholes, catch basins, outfalls, etc. Plug, remove or adjust any of the above items.

5302

Other utility general Construction

Mobilization costs required by a general contractor for water, sanitary and storm construction.

5309

Other utility contingency Construction

Provision for work not identified.

Other Construction Utilities Sub-Total 5310

Other railroads main & spur Construction lines

Work required to do all elements of railroad work.(temporary, permanent). Bulk Excavation and backfill, drainage, ballast, ties, rail, turnouts, switches, etc. Removal, disposal and modification to items above.

5320

Other railroad crossings Construction

Work required to do a railroad crossing.(temporary, permanent). Excavation and backfill, drainage, ballast, ties, rail, crossing planks, signals, gates, flagperson, etc. Removal, disposal and modification to items above.

5330

Other marine work Construction

Work required to do marine work.(temporary, permanent). Dredging, caissons, piers, ramps, building, etc. Removal, disposal and modification to items above.

5340

Other environmental mitigation Work required to protect elements of the environment. Drainage Construction to lakes, marshes, creek, rivers, wildlife crossings, fish habitat, engineered/conversion wetlands, etc. Special clearing & grubbing, retention ponds, drainage pipes, rip rap protection, culverts, silt fences, etc.

5301

Other general Construction

Mobilization costs required by a general contractor for items above.

5399

Other contingency Construction

Provision for work not identified.

Other Construction Sub-Total

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 16 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

Description

Description of Work

OTHER CONSTRUCTION COSTS 3570

Other detailed design Engineering

The development of construction (contract) drawings and technical specifications for construction, including the completed geometric and geotechnical design, special site considerations and construction details.

3579

Other detailed Engineering design/Contingency

Provision for work not identified.

6870

Other general construction Engineering supervision

Administration required on site; site office, analyzing, logging and record keeping of field data.

6871

Other quality assurance Engineering

Work performed on site so that the product received meets the standards specified.

6872

Other surveying Engineering

Work performed on site, to measure quantities for pay items.

6879

Other residency contingency Engineering

Provision for work not identified.

Other Engineering Sub-Total Total Other Construction and Engineering Costs

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 17 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

3500 3530

Activity

Description

Description of Work

DETAILED DESIGN from 3510, 3520, 3540, 3550, 3570 Geotechnical detailed design Engineering

3539

Detailed design costs throughout the estimate including contingency. The development of construction (contract) drawings and technical specifications for construction, including the completed geometric and geotechnical design, special site considerations and construction details.

contingency

Provision for work not identified.

TOTAL DETAILED DESIGN COSTS

Total cost of detailed design throughout the estimate including contingency.

RESIDENT ENGINEERING from 6810, 6820, 6840, 6850, 6860, 6870

Total cost of supervision, quality assurance, surveying throughout the estimate including contingency.

Geotechnical Engineering

6800

As above. TOTAL RESIDENT ENGINEERING COSTS 9700

RISK CONTINGENCY general TOTAL RISK CONTINGENCY PART 1

SUMMARY

CONSTRUCTION Summary of all Construction Cost excluding contingency ENGINEERING Summary of all Design cost (planning, preliminary, functional, detailed) excluding contingency. CONTRACTUAL CONTINGENCY Summary of all provisions for work not identified. RISK CONTINGENCY CONSTRUCTION COST TOTAL

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 18 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

2000 2060 2062 2063 2061

Description

Description of Work

PROJECT MANAGEMENT Project Management Project Management Project Management Project Management

printing costs

Direct and indirect wage costs of individuals hired to manage the project. Office rental, purchase of office equipment and supplies, maintenance cost, etc. Printing costs of tenders specifications and drawings, etc..

general

Miscellaneous costs.

- office costs wages - office costs expenses

Project Management Sub-Total 2010

Ministry

- office costs wages

2012

Ministry

- office costs expenses

2030

Ministry

printing costs

Direct and indirect wage costs of individuals hired to manage the project. Office rental, purchase of office equipment and supplies, maintenance cost, etc. Printing costs of tenders specifications and drawings, etc..

2011

Ministry

general

Miscellaneous costs.

Ministry Sub-Total 2070 2072 2073 2071

Public Relations Public Relations Public Relations Public Relations

wages and expenses

Wages and expenses costs required to manage public relations.

advertising media, displays opening ceremonies

Tender advertising, open house costs, etc.

general

Miscellaneous costs.

Costs identified in opening the project.

Public Relations Sub-Total 2040

Legal Costs lawyers' fees

2041

Legal Costs general

Direct and indirect costs required for legal counsel for this project. Miscellaneous costs.

Legal Costs Sub-Total 2080

Insurance

2081

Insurance

construction/liability, E&O general

Insurance premiums, deductibles, claims, etc. Miscellaneous costs.

Insurance Sub-Total 2099

Project Management Contingency

Provision for work not identified.

TOTAL PROJECT MANAGEMENT COSTS

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 19 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

4000 4010

Description

Description of Work

LAND Land (Code 401)

Market, ROW, Sever, Market or income appraisal value, right-of-way, severance Improvement V, value, improvement value, easement costs, timber costs, Easement Costs, Timber deduction/special benefits.

Acquisition Sub-Total 4020

Land (Code 402)

Bus., 5%, Mrg.P, Rel$, P/Tax, Etc.

Owner's entitlements, 5% total take under one acre/3 month rent, mortgage penalty, relocation costs, injurious affection, business disturbance, general disturbance, owner's executive time, property purchase tax, tax adjustments on H12.

4030

Land (Code 403)

Owners (LS, Apprsl, Rprt, Lgl, In)

Lump sum owners costs, owners appraisal, owner's legal costs, interest(Sec,45E.A.)

4040

Land (Code 404)

Demolition

Demolition costs.

4050

Land (Code 405)

Pro.Man, P.Tax, Util, Security

Property management, property taxes, utilities, security-MOTH, acquisition fees.

4060

Land (Code 406) Land (Code 407)

Not Used

Not used

Not Used

Not used

4080

Land (Code 408)

Acq.F, M/Sal, TrvlV, Contr.S, Appr.

Staff salaries, travel voucher's, other reports MOTH, contractor's salary, MOTH appraisals.

4090

Land (Code 409)

Surveys

Legal surveys

4070

Associated Costs Sub-Total 4099

Land Contingency Sub-Total

Provision for work not identified

TOTAL LAND COSTS

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 20 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

9800 9800 9800 9800 9800 9800 9800 9800 9800 9800 9800 9800 9800 9800 9800

Description

Description of Work

UNALLOCATED CONTINGENCY Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency Unallocated Contingency

planning

Management reserve, risk analysis, redirected contingency.

preliminary design

Management reserve, risk analysis, redirected contingency.

utility construction

Management reserve, risk analysis, redirected contingency.

grade construction

Management reserve, risk analysis, redirected contingency.

structural construction

Management reserve, risk analysis, redirected contingency.

paving construction

Management reserve, risk analysis, redirected contingency.

operation construction

Management reserve, risk analysis, redirected contingency.

roadside construction

Management reserve, risk analysis, redirected contingency.

other construction

Management reserve, risk analysis, redirected contingency.

project management

Management reserve, risk analysis, redirected contingency.

land

Management reserve, risk analysis, redirected contingency.

detailed engineering

Management reserve, risk analysis, redirected contingency.

residency engineering

Management reserve, risk analysis, redirected contingency.

risk contingency

Management reserve, risk analysis, redirected contingency.

TOTAL UNALLOCATED CONTINGENCY TOTAL LESS ESCALATION 9900

ESCALATION YEAR

PROJECTED ESCALATION

9989

1989 - 1990

5.5000%

The annual inflation rate assigned to the VIHP project

9990

1990 - 1991

3.1250%

The annual inflation rate assigned to the VIHP project

9991

1991 - 1992

0.6975%

The annual inflation rate assigned to the VIHP project

9992

1992 - 1993

1.8950%

The annual inflation rate assigned to the VIHP project

9993

1993 - 1994

1.0104%

The annual inflation rate assigned to the VIHP project

9994

1994 - 1995

1.0146%

The annual inflation rate assigned to the VIHP project

9995

1995 - 1996

1.0124%

The annual inflation rate assigned to the VIHP project

Activity

Activity

Description

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

Description of Work page 21 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items Code

9996

1996 - 1997

1.4400%

The annual inflation rate assigned to the VIHP project

9997

1997 - 1998

1.1320%

The annual inflation rate assigned to the VIHP project

TOTAL ESCALATION PART 2 SUMMARY NON-Construction COSTS Non-Construction Non-Construction Contingency TOTAL NONCONSTRUCTION COSTS DIVISION TOTAL FOR ROAD TYPE

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 22 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

Activity

Description

Description of Work

SUMMARY BY ACTIVITY LEVEL 2000

PROJECT MANAGEMENT

Ministry, consultants, wages, office expenses, printing, public relations, legal, insurance, etc..

2500

PLANNING

Planning study, corridor study, etc.

3000

PRELIMINARY DESIGN Preliminary, functional designs, etc.

3500

DETAILED DESIGN

Detailed design.

Total Engineering 4000

LAND ACQUISITION

Land & improvements, entitlements, owners costs, demolition, property management, administration or MOTH costs, legal surveying.

5000

GRADE CONSTRUCTION

Water, sanitary, storm, clearing & grubbing, excavating and backfill, drainage, multiplate, SGSB, CBC, landscaping, fencing, noise barriers, sidewalks, curb & gutter, detours, and general.

5200

ROAD SIDE CONSTRUCTION

Utilities, weighscales, tourist info centers, tourist rest & view areas.

5300

OTHER CONSTRUCTION

Utilities, railroad line construction, spur line, railroad X-ing, marine, environmental mitigation.

5500

STRUCTURAL CONSTRUCTION

Utilities, tunnels, snow sheds, bridges, retaining walls.

6000

PAVING CONSTRUCTION

Machine paving asphalt, machine paving concrete, hot reprofiling, shoulder paving, pavement finishing, seal coating, pavement mix design.

6500

OPERATIONAL CONSTRUCTION

Lighting, signals, signing, barriers, pavement markings.

6700

UTILITY CONSTRUCTION

B.C. hydro, B.C. telephone, pipelines, telecommunication, third party inspections, transit.

6800

RESIDENT ENGINEERING

Site administration, quality assurance, surveying, environmental monitoring.

Total Construction 9700

RISK CONTINGENCY

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

Provision for work not identified.

page 23 prepared by: E. Wolski

Elemental Parametric Method of Estimating Description of Activity items

Activity Code

9800

9900

Activity

Description

Description of Work

SUB-TOTAL UNALLOCATED CONTINGENCY

Management reserve, risk analysis, redirected contingency.

TOTAL

Sub-total costs for items above.

ESCALATION

The annual inflation rate assigned to the VIHP project

TOTAL COST

Total cost for the estimate sheet.

NOTE: WORK is defined as the supply of all labour, equipment and materials including taxes and duties.

w:\data\ernie\word\manual\Activity Code Descr.doc printing date: 12/18/02

page 24 prepared by: E. Wolski