Complete the following steps for selecting target customer segments to which Buhi should cross-sell Soft-Ts shirts.

• 1

Analyze Data

Analyze the Customer Product Purchase Data'' and Expense Report'' files provided below. Pay special attention to the profiles for Buhis customer segments.

• 2

Calculate CLV and CAC

Enter the appropriate data into the provided fields to calculate CLV and CAC. The Customer Product Purchase Data file will help you calculate CLV, and the Expense Report file will help you calculate CAC.

• 3

Select Three Customer Segments

Select three customer segments to which Buhi should cross-sell Soft-Ts shirts based on your calculations and the segments profiles. Click on a segment to select it, and click it again to deselect it.

	Income		$2,501,215			New customers by segment
	Sales	$2,501,215			Messenger Bags	716
					Duffel Bags	762
	Expenses				Luggage	496
	COGS	$750,365	$ (1,721,765)		Sport Duffel Bags	678
	Salaries	$250,122			Backpacks	688
	Marketing Costs	$500,243			Smart Luggage	736
	Messenger Bags	$72,269			Hip Packs	384
	Duffel Bags	$80,697			Totes	395
	Luggage	$50,746
	Sport Duffel Bags	$65,539			Total	4855
	Backpacks	$71,818
	Smart Luggage	$77,700
	Hip Packs	$40,735
	Totes	$40,740
	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,855

Customer Segments

Messenger Bags

CLV

Average revenue per customer per period

Average customer relationship length

CAC

All costs spent to acquire customers in a period

Number of customers acquired in the period

Ratio

CLV

CAC

Duffel Bags

CLV

Average revenue per customer per period

Average customer relationship length

CAC

All costs spent to acquire customers in a period

Number of customers acquired in the period

Ratio

CLV

CAC

Luggage

CLV

Average revenue per customer per period

Average customer relationship length

CAC

All costs spent to acquire customers in a period

Number of customers acquired in the period

Ratio

CLV

CAC

Sport Duffel Bags

CLV

Average revenue per customer per period

Average customer relationship length

CAC

All costs spent to acquire customers in a period

Number of customers acquired in the period

Ratio

CLV

CAC

Backpacks

CLV

Average revenue per customer per period

Average customer relationship length

CAC

All costs spent to acquire customers in a period

Number of customers acquired in the period

Ratio

CLV

CAC

Smart Luggage

CLV

Average revenue per customer per period

Average customer relationship length

CAC

All costs spent to acquire customers in a period

Number of customers acquired in the period

Ratio

CLV

CAC

Hip Packs

CLV

Average revenue per customer per period

Average customer relationship length

CAC

All costs spent to acquire customers in a period

Number of customers acquired in the period

Ratio

CLV

CAC

Totes

CLV

Average revenue per customer per period

Average customer relationship length

CAC

All costs spent to acquire customers in a period

Number of customers acquired in the period

Ratio

CLV

CAC