5. Family Tree has undergone some changes since you last saw them. Family Tree.com is a subscription-based website that allows consumers to conduct genealogical research. There are three levels of subscriptions, Basic, Premier and Ultra. The company still spends approximately $4 per customer on acquisition marketing. but they have raised their prices across all of the membership levels based on a prior CLV analysis. Their retention rates have also changed as they now spend approximately $2 per year, per customer, to retain their customers, and no longer offer customers receive their first month as a free trial. Monthly prices, variable costs and retention rates are provided below. Make sure to show all work and calculations or no partial credit can be awarded for wrong answers. Include an explanation for the CLV formula you used and why you used it. Membership Monthly price Variable cost Monthly Level retention rate Basic $5. 99 $1. 50 Premier $6. 99 $1.75 Ultra $7.99 $2 . 50 a. Calculate the customer lifetime value for a NEW customer at each level of membership, using a monthly discount rate of .01. (10 points) b. Based on these numbers, what are your recommendations regarding the marketing of the various membership levels? (10 points) Site Usage Goal Conversion Views: BE Visits Pages/Visit Avg Time on Site % New Visits Bounce Rate 1,641 2.75 00:01:45 81.60% 17.12% 6 of Site Tolat 180.00% Site Arg 2.75 (0.00%) Site Avg: 00:01:45 (0.00%) Site Arg: 81.60% (0.00%) Site Avg: 17.12%6 (0.00%) Uper Defined Voup Visits + An Time co.Ste 897 249 03.01 59 68,65% 34.20% 26 03:01:29 96.55% 0.80% 18 2 06 0300 01 100.00% 0.00% hthre/www.smashingmonarine.com/ 12 217 00:01 22 100.00% 0.00% atte Media com bott wore foodie Andbies Hack obtaining full 11 355 03:01 47 90.91% 0.00% http /wow fromstuff aprozune Howtonle.php11-28158 40 2.50 03:00 28 100.00% 0.00% http:wwwww.dzone comessinceloogie anshtos hack obtaink 2.25 10:00 05 100.00% 0.00% http:/fsearch man.comresults aspx 70:=hack+per+BUSFORM=DI 4.83 DO:02 35 100.00% 0.00% http:/www.digtelneciaminute cam 2:00 03:00 00 100.00% 0.009% hittwiiwwwww blogcatalog com biont reuben-veu-internet-marketi 240 03:00 03 100,00% 0,00%