Case Study: CASCoM
Joint Confidence Level Analysis
The Cost and Schedule Confidence Model (CASCoM) is a software application designed to support joint confidence level (JCL) analysis of development projects. CASCoM is fundamentally a synthesis model; its purpose is to combine cost, schedule, and risk information and derive meaningful, actionable statistical outputs. Although originally motivated by the need to analyze NASA spacecraft development projects, CASCoM is generally applicable to any project that can be expressed as a collection of tasks with associated cost and duration.
- Visual Basic for Applications (VBA) in Excel
- Microsoft Excel spreadsheet with userforms and custom ribbon bar menu
- Compatible with Excel 2007 and 2010 on Windows and Excel for Mac 2011
Our client requested that CASCoM be developed as a Microsoft Excel workbook application with extensive custom functionality enabled through VBA. In response, we created a professional and user-friendly product complete with a custom ribbon bar menu, dynamic worksheet formatting and user aids, dozens of custom VBA functions, worksheet import/export capability, a comprehensive user manual, and more.
Analysis inputs to CASCoM include a project work breakdown structure (WBS), baseline cost and schedule estimates for each WBS element, and quantified project risks and problem impacts. Optionally, the user may also specify schedule dependencies between project elements, statistical correlations between cost and schedule growth, time-buying assumptions, and other advanced inputs.
Outputs of a CASCoM analysis include a scatter plot of simulated project total cost and schedule duration outcomes, a joint confidence level contour (at a specified confidence level), a summary of potential critical paths, a summary of active risks, and a project Gantt chart.