sales management
yassine222
YACHTSStudentCustomerManagement_21101.xlsxCustomer Management
| CUSTOMER MANAGEMENT | |||||||||||
| CLIENT | REVENUE 2019 | POTENTIAL | VISITS / YEAR | HOURS / MONTH | ORDERS / YEAR | CLIENT CLASSIFICATION | FRECUENCY (VISITS / MONTH) | TIME / VISIT | ORDERS / MONTH | AVERAGE MONTH VALUE | |
| 1 | 106,800 € | 120,000 € | 10 | 5 | 8 | ||||||
| 2 | 115,700 € | 129,000 € | 15 | 3 | 6 | ||||||
| 3 | 71,200 € | 73,000 € | 30 | 15 | 7 | ||||||
| 4 | 213,600 € | 261,500 € | 20 | 3 | 5 | ||||||
| 5 | 267,000 € | 270,550 € | 24 | 7 | 9 | ||||||
| 6 | 44,500 € | 60,000 € | 20 | 7 | 8 | ||||||
| 7 | 133,500 € | 133,300 € | 10 | 7 | 6 | ||||||
| 8 | 62,300 € | 361,500 € | 20 | 2.5 | 5 | ||||||
| 9 | 231,400 € | 250,000 € | 25 | 9 | 12 | ||||||
| 10 | 44,500 € | 40,000 € | 5 | 1.5 | 8 | ||||||
| 1,290,500 € | 1,698,850 € | 179 | 60 | 74 | |||||||
Lifetime Value
| CUSTOMER PROFITABILITY | ||||||||||
| LIFETIME VALUE OF CUSTOMERS | ||||||||||
| CUSTOMER EQUITY | ||||||||||
| CLIENT | AVERAGE MONTH REVENUE | LIFE EXPECTANCY | GROSS PROFIT MARGIN | |||||||
| 1 | 6 | 35% | ||||||||
| 2 | 6 | 30% | Assume ACQUISITION COST = 1 average month revenue | |||||||
| 3 | 10 | 25% | ||||||||
| 4 | 2 | 20% | ||||||||
| 5 | 4 | 20% | ||||||||
| 6 | 15 | 30% | ||||||||
| 7 | 8 | 35% | ||||||||
| 8 | 6 | 25% | ||||||||
| 9 | 8 | 25% | ||||||||
| 10 | 4 | 25% | ||||||||
| - 0 € | ||||||||||
| CLIENT | AVERAGE MONTH REVENUE | LIFE EXPECTANCY | GROSS PROFIT MARGIN | ACQUISITION COST | AVERAGE YEARLY REVENUE | LIFETIME REVENUE | LIFETIME GROSS PROFIT | LIFETIME NET PROFIT | ||
| 1 | 6 | 35% | - 0 € | |||||||
| 2 | 6 | 30% | - 0 € | |||||||
| 3 | 10 | 25% | - 0 € | |||||||
| 4 | 2 | 20% | - 0 € | |||||||
| 5 | 4 | 20% | - 0 € | |||||||
| 6 | 15 | 30% | - 0 € | |||||||
| 7 | 8 | 35% | - 0 € | |||||||
| 8 | 6 | 25% | - 0 € | |||||||
| 9 | 8 | 25% | - 0 € | |||||||
| 10 | 4 | 25% | - 0 € | |||||||
| - 0 € | 7 | 27% | - 0 € |
