Customer 1 makes purchases in years 1, 2, and 3 at the rates 1.8, 2.5, and 3 times a year, respectively. They also purchase an average of $90, $95, and $100 per purchase, respectively. According the the chart as it is currently completed, what is the CLV of Customer 1 in Year 3?

Customer 2 purchases more often, but the average amount spent per purchase is the same as Customer 1. Without including the dollar sign ($), change the Avg Order Size (in row 9) to reflect an average purchase amount of 95, 105, and 120 in years 1, 2, and 3 respectively. What is the CLV of this customer?

Customer 3 purchases the same amounts as Customer 1 but purchases more frequently than both customers. Without including the dollar sign ($), change the Avg Order Size (in row 9) to reflect an average purchase amount of 90, 95, and 100 in years 1, 2, and 3 respectively. Then change the Orders Per Year (in row 8) to reflect 2, 3, and 4 times in years 1, 2, and 3 respectively. What is the CLV of this customer?

In one or two sentences, describe which customer you as the brand manager would spend money to cultivate as a customer advocate?

Transcribed Image Text:

Excel File Edit View View Insert Format Tools Data Window Help ●●● AutoSave OFF A B 2. CO... Page Layout * Α' Α' A Sunella Co. P APA-Newspaper- no-auth...wn-1.png SIMnet McGraw Hill SIMne tLogo.png download.jpg Air- with Untitle Home New Tabl Insert. Draw - LabelPrint Paste 7 8 9 10 11 12 13 3 14 15 16 17 pkg J16 5 6 18 19 How Ter 20 21 22 23 24 ac LB- UP A 21 V Ready T ? Sheet1 Calibri (Body) BI I U U x ✓ fx X B + V ✓11 Customers Retention Rate Orders per Year Avg Order Size Total Revenue 0 CLV_Calculator.....xlsx ^ C Formulas Costs Cost of Sales Acquisition/Mkt. Cost Marketing Costs Total Costs Gross Profit Discount Rate Net Present Val Cumulative NPV Profit Customer LTV Data === 三、 EE. CLV Calculator_Excel Worksheet (1) Review View Developer General $%9 D D 898 E Year 60,000 70% 100,000 60% 1.8 $90 2.5 $95 $16,200,000 $14,250,000 ($640,000) 70% 65% $11,340,000 $9,262,500 $55 $20 $5,500,000 $1,200,000 $16,840,000 $10,462,500 Tell me Conditional Formatting v Format as Table Cell Styles v 1 (in row 8) to reflect 2, 3, and 4 times in years 1, 2, and 3 A F Year ($640,000) $3,265,086 ($640,000) $2,625,086 ($6.40) $26.25 $3,787,500 1.16 Show All X cricut G Year Insert v Delete v Format v 42,000 80% 3 $100 $12,600,000 65% $8,190,000 $20 $840,000 $9,030,000 $3,570,000 1.35 $2,644,444 $5,269,531 $52.70 56% Σ' D H Sun 8:36 PM Q Search Sheet 28-0. Sort & Find & Select V Filter I Share IZD Q LCD)- LEAS Analyze Data J Comments E ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬+ E OP K 160% Y Excel File Edit View View Insert Format Tools Data Window Help ●●● AutoSave OFF A B 2. CO... Page Layout * Α' Α' A Sunella Co. P APA-Newspaper- no-auth...wn-1.png SIMnet McGraw Hill SIMne tLogo.png download.jpg Air- with Untitle Home New Tabl Insert. Draw - LabelPrint Paste 7 8 9 10 11 12 13 3 14 15 16 17 pkg J16 5 6 18 19 How Ter 20 21 22 23 24 ac LB- UP A 21 V Ready T ? Sheet1 Calibri (Body) BI I U U x ✓ fx X B + V ✓11 Customers Retention Rate Orders per Year Avg Order Size Total Revenue 0 CLV_Calculator.....xlsx ^ C Formulas Costs Cost of Sales Acquisition/Mkt. Cost Marketing Costs Total Costs Gross Profit Discount Rate Net Present Val Cumulative NPV Profit Customer LTV Data === 三、 EE. CLV Calculator_Excel Worksheet (1) Review View Developer General $%9 D D 898 E Year 60,000 70% 100,000 60% 1.8 $90 2.5 $95 $16,200,000 $14,250,000 ($640,000) 70% 65% $11,340,000 $9,262,500 $55 $20 $5,500,000 $1,200,000 $16,840,000 $10,462,500 Tell me Conditional Formatting v Format as Table Cell Styles v 1 (in row 8) to reflect 2, 3, and 4 times in years 1, 2, and 3 A F Year ($640,000) $3,265,086 ($640,000) $2,625,086 ($6.40) $26.25 $3,787,500 1.16 Show All X cricut G Year Insert v Delete v Format v 42,000 80% 3 $100 $12,600,000 65% $8,190,000 $20 $840,000 $9,030,000 $3,570,000 1.35 $2,644,444 $5,269,531 $52.70 56% Σ' D H Sun 8:36 PM Q Search Sheet 28-0. Sort & Find & Select V Filter I Share IZD Q LCD)- LEAS Analyze Data J Comments E ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬+ E OP K 160% Y