The loan processing spreadsheet models a process improvement effort with two basic goals: meeting the cycle time target as closely as possible and maximizing the sigma level. The model has these parts:
The flowchart at the top of the model illustrates the process with approximate measured mean times for each step.
The blue box beneath the flowchart highlights the cycle time target.
The green boxes in the Simulated Cycle Time column are Crystal Ball assumptions that represent each step of the loan processing effort.
The assumption parameters beside each assumption show the distribution and the parameters entered for each assumption. They are entered in each assumption as cell references relative to cells in column C.
The blue box at the bottom of the Simulated Cycle Time column is a Crystal Ball forecast that represents the total cycle time.