1 / 7

Cost Estimate data management

Managing cost estimates and data for the Global Design Effort, including consolidation of information, roll-ups, and managing changes to estimates and technical scope. Practical approach for cost analysis and tools. EDMS and document management used.

cecilt
Download Presentation

Cost Estimate data management

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. Cost Estimate data management John Carwardine Feb 8, 2008 Global Design Effort

  2. RDR costing roll-up Global Design Effort

  3. Managing costing information • Cost estimates are consolidation of a lot of information • Cost estimates from each technical group • Presentation material (technical, cost) • Roll-ups by accelerator area • Roll-up to entire machine cost • Cost bases of estimates • Manage changes to cost estimates, technical scope, etc • Manage data for easy “drill down” to the lowest level of the RDR cost estimate and correlate with the bases of estimates. • Parametric cost analyses, different cost ‘slices’, changes in scope, eg • Price of copper, different inflation rates, effort rates, etc. • Make cost roll-up of all magnets across all accelerators. • Lattice changes, magnet/ps configurations, space usage, etc EDMS RDB Global Design Effort

  4. Costing roll-up Global Design Effort

  5. Practical • Costing spreadsheets are not always provided in the same format (despite attempts by Cost Engineers) • Individual groups approached cost estimating differently. • Partial breakdown of TS  AS  Roll-up • What capabilities are most important? • List of parametric analyses: • It will take some effort to convert existing information… • It could take a lot of effort to build ‘enterprise’ tools… • Could we describe to a software developer exactly what we want…? • Start with simpler tools and narrower scope, then migrate…? Global Design Effort

  6. Mechanics • Cost estimates are contained in excel spreadsheets. • Costing / data analysis tools.. • Project Management tools, eg Primavera, PPT/EVM,… • Linked Excel spreadsheets using standard template. • EDMS + data mining from ‘self-describing’ Excel spreadsheets. • Custom relational database. • Document management using EDMS. • Document management • Different EDMS systems at CERN, DESY,.. • Ad hoc • Combined EDMS and costing information Global Design Effort

  7. To answer… • Best approach from now… Global Design Effort

More Related