Analyze Phase

During the Analyze phase, you create a Microsoft Excel workbook that includes historical data on loan closing times. Then, you can capture the time and variation information for each step as a Crystal Ball assumption. Finally, you can define overall processing time as a Crystal Ball forecast. When the simulation runs, you can view capability metrics to gain insight into the degree of process variation, or inconsistency. You can also generate a sensitivity chart to learn more about the main sources of inconsistency.

Using the Loan Processing Model, shows how to use a Crystal Ball model in the Analyze and Improve phases to accomplish the quality goals.