Please solve for customer lifetime value and CAC and provide clear steps on where #s and calculations are coming from.

Travel Bags:

1. CLV

Average revenue per customer per period _____

Average customer relationship length ____

2. CAC

All costs spent to acquire customers in a period ____

Number of customers acquired in the period _____

3. RATIO

CLV ____ / CAC ____ = _____

Clear Bags:

1. CLV

Average revenue per customer per period _____

Average customer relationship length ____

2. CAC

All costs spent to acquire customers in a period ____

Number of customers acquired in the period _____

3. RATIO

CLV ____ / CAC ____ = _____

Standard Baggage

1. CLV

Average revenue per customer per period _____

Average customer relationship length ____

2. CAC

All costs spent to acquire customers in a period ____

Number of customers acquired in the period _____

3. RATIO

CLV ____ / CAC ____ = _____

Travel Bags			Clear Bags			Standard Baggage
Customer Segment Profile - 20-30 years old - Part-time employee - Interests: photography, outdoors, sustainability - Values simplicity			Customer Segment Profile - 15-23 years old - Full-time student - Interests: exploring, travel, friends - Values spontenaity			Customer Segment Profile - 25-35 years old - Full-time employee - Interests: travel, rock climbing, hiking - Values sustainability
Customer ID	Months as customer	Revenue last 12 months	Customer ID	Months as customer	Revenue last 12 months	Customer ID	Months as customer	Revenue last 12 months
10000	25	115	13007	18	136	33304	16	83
10001	22	112	11470	11	91	37843	22	52
10002	13	92	13998	17	154	28255	20	111
10003	27	130	12324	11	142	26267	42	119
10004	52	124	12203	22	150	29418	18	71
10005	25	159	11144	24	92	33586	31	88
10006	9	95	11330	15	130	38243	13	86
10007	10	144	13967	7	138	30556	25	92
10008	15	119	13957	9	146	36148	36	43
10009	41	129	11384	7	127	26435	39	110
10010	10	61	13327	0	92	26626	42	78

Income		$2,501,215
Sales	$2,501,215
Expenses
COGS	$750,365	$ (1,721,765)
Salaries	$250,122
Marketing Costs	$500,243
Water and Electricity	$12,225
Property Rates and Taxes	$1,200
Insurance	$8,500
Taxes	$187,591
Other	$11,520
Net Profit		$779,450
Total new customers in the last 12 months: 4,852