QC Sheets with Issues:

Min Max

Slide to update →

Yearly Customer Value ($$):

Min Max

Slide to update →

Annual Churn Rate (%):

Min Max

180 x 0.4 x 15 =

$1247

C

%

÷

×

7

8

9

+

4

5

6

−

1

2

3

0

.

=

Potential money lost is calculated by multiplying the number of vehicles with issues times the annual customer value, then multiplying that times your annual churn rate of customers.