Required information Marketing Analytics: Measuring and Assessing Customer Lifetime Value (CLV) You are the owner of a smoothie shop in California. After hearing a podcast about customer relationship management (CRM), you decide to gather more information regarding customer behavior in your store to better understand the relationships that exist between your business and your customers. CRM is a comprehensive business model for increasing revenues and profits by focusing on customers. Customer Lifetime Value (CLV) is particularly important when it comes to CRM and is often considered one of the most crucial metrics associated with a CRM system. Collecting data on customers and their relationships with a company (and commonly storing it within a CRM system) helps make it possible to calculate CLV, or the total amount a customer will spend throughout their relationship with a company. After a review and analysis of your customer data you are able to determine the following information: Average Value of Sales per Year per Customer: $120 Average Customer Retention Cost: \$75 Customer Acquisition-oriented Marketing Expenses per Month: $1,000 Average Customer Retention Rate: 80% You acquire an average of 25 new customers a month. Use the following equations to help determine the CLV: Average Customer Acquisition Cost = Customer Acquisition-oriented Marketing Expenses per Month/Number of New Customers Acquired per Month Customer Lifetime Value =[1/(1AverageCustomer Retention Rate)] x (Average Value of Sales per Year per Customer)(Average customer Acquisition Cost + Average Customer Retention Cost) This activity is important because marketing managers need to understand and know how to culculate customer lifetime value as a part of customer relationship management. Knowledge of CLV can inform a number of critical marketing decisions related to such factors as the development of strategies designed to aid in the acquisition, nurturing, and retention of customers. The goal of this activity is to test your understanding of CLV by considering this example. You must (1) complete the spreadsheet and (2) answer the questions that follow to receive full credit for this exercise. 2. Complete the mini-spreadsheet shown and use it to answer the following question: How many new customers per month would yo need to have an average customer acquisition cost of $20 (assuming that Monthly Customer Acquisition-oriented Marketing Expense