15 Alfred's organic dog food was formulated to provide for the nutritional needs of older pets. The company did not sell through retailers, but shipped directly to consumers. Consumers ordered through the company's web site or called the 1-800 number. An analysis of the company's records showed the patterns for a typical cohort of 50 customers in the table below. The company's contribution margin on this product was 33% of sales after shipping, order processing and other variable non-marketing costs. Each order included a brochure and reorder forms that cost $0.71 per shipment. Because the time between orders averaged 3 months, the company organized their analysis into period of 3 month duration. Almost no customers ordered after two years from their initial order. Alfred has historically used an annual discount rate of 11% to determine CLV. 3 Month Period 0 2 3 4 5 6 Customer Orders 50 18 16 12 8 A 2 CALCULATED VARIABLES: Avg $/Order $28 $40 $32 $35 $25 $20 $20 discount = 0.0264 (2.64%) margin = $8.53 What is the average customer lifetime value of a customer acquired in period 0? Answer and Explanation: (50 * $8.53 + (18 * (40 * 33% - $0.71)) / (1 + 0.0264) + (16 * ($32 * 33% - $0.71)) / (() + 0.0264) ^ 2) + (12 * (35 * 33% - $0.71)) / ((1 + 0.0264) ^ 3) + (8 * (25 * 33% - $0.71)) / ((1 + 0.0264) ^ 4) + (4* (20 * 33% - $0.71)) / ((1 + 0.0264) ^ 5) + (2 * (20 * 33% - $0.71)) / ((1 + 0.0264) ^ 6)) / 50 = $20.01 [+/- $0.60] Take the NPV of the expect future flow of contributions and divide by the cohort (in this case, 50)Alfred's organic dog food was formulated to provide for the nutritional needs of older pets. The company did not sell through retailers, but shipped directly to consumers. Consumers ordered through the company's web site or called the 1-800 number. An analysis of the company's records showed the patterns for a typical cohort of 50 customers in the table below. The company's contribution margin on this product was 31% of sales after shipping, order processing and other variable non-marketing costs. Each order included a brochure and reorder forms that cost $0.71 per shipment. Because the time between orders averaged 3 months, the company organized their analysis into period of 3 month duration. Almost no customers ordered after two years from their initial order. Alfred has historically used an annual discount rate of 8% to determine CLV. 3 Month Period 0 2 3 4 5 6 Customer Orders 50 27 16 12 8 4 2 CALCULATED VARIABLES: Avg $/Order $32 $40 $32 $35 $25 $20 $20 discount = 0.0194 (1.94%) margin = $9.21 What is the average customer lifetime value of a customer acquired in period 0? TUTORIAL 0.00 dollars ($)