CES Implementation Cost Sheets and Formulas

1
CES Implementation Cost Sheets and Formulas
Jennie Carlson Todd R.Bergland Minnesota DOT
2
CES Implementation Cost Sheets and Formulas

• Implementation
• Cost Sheets
• Formulas

3
CES Implementation

• Job Creation PES checked out proposal to CES

4
CES Implementation
Regression Libraries Import Data from LAS

• Backup Data File
• Fix all import errors before beginning the
  historical regression
• Rebuild SAS Formats

5
CES Implementation
Regression Libraries Create View

• Create View Based on Three Years of Data
• Run Quarterly

6
CES Implementation
Perform Statistical Analysis - Regression
Libraries
7
CES Implementation
Import File to CES Create Library
8
CES Implementation
Item rank analysis
9
CES Implementation

• Eliminated Summer,Spring,Fall,Winter
• Added all seasons
• Prices do not vary by seasons.

10
Happy Birthday Mike
Mike Fowler Chocolate Chunky Monkey
11
CES Implementation and Cost Sheets

• Labor List

12
CES Implementation and Cost Sheets

• Equipment List

13
CES Implementation and Cost Sheets

• Crew List

14
CES Implementation and Cost Sheets

• Material List

15
CES Implementation and Cost Sheets

• Cost Sheets

16
CES Implementation and Cost Sheets

• Cost Sheets 2053 English Spec Year 00

17
CES Implementation and Cost Sheets
18
CES Implementation and Cost Sheets
19
CES Formulas
Consider formulas Before Creating Sheets
20
CES Formulas

• Item

8 Task Groups with 36 Cost sheets. One Task
Group with 6 cost sheets
12 Task Groups with 100 Cost Sheets. To 4 Task
Groups and 17 cost sheets
21
CES Formulas Expression Builder
22
ONE QUESTION