1 / 22

CES Implementation Cost Sheets and Formulas

This comprehensive guide by Jennie Carlson and Todd R. Bergland details the methodologies of CES (Cost Estimation System) Implementation. It covers the critical components of cost sheets and formulas essential for effective project management, including job creation proposals, statistical analysis using regression libraries, and various essential lists—labor, equipment, crew, and materials. The guide emphasizes the importance of data integrity and format rebuilding, providing invaluable insights for those involved in cost estimation and analysis in the Minnesota Department of Transportation.

korene
Télécharger la présentation

CES Implementation Cost Sheets and Formulas

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related