Homework Exercise 2- A Case Study: Customer Attraction or Retention? Submit Assignment Due Wednesday by 11:59pm Points 25 Submitting a file upload Aregional electrical distributor currently has 1,000 customers who buy an average of $5,000 per year, generating a 50% margin. From experience, the company knows that 20% of its customers will not return the next year and it takes an average of $500 to acquire each new customer. Given a choice of 1) investing $50,000 in a new customer acquisition program for 100 additional customers or 2) Investing $50,000 in a new retention program which would take the rate of retention from 80% to 85% what should the company do? To properly answer this question, you need to complete the Excel template for both scenarios (customer acquisition and customer retention) to show which option is the most profitable. Assume the new programs are in effect and you are calculating the impact for both beginning Year 1. Also, do not account for the cost of the programs since they are the same cost and it doesn't impact the overall conclusion. Restrict your analysis to a five-year period (see the template for an easy analysis: DB 435 - Module 5 Homework Exercise 2 - A Case Study. Customer Acquisition or Retention.xlsx) F G 1 NAME: 3 Five Year Payout 5 Scenario 1: New Customer Acquisition Year 1 Year 2 Year 3 Year 4 Year 5 100 7 Incremental Customers: 8 Purchases: 9 Additional Annual Profits: 10 Cumulative Additional Annual Profits: 13 Scenario 2: Customer Retention Year 1 Year 2 Year 3 Year 4 Year 5 14 800 850 15 Retained Customers @ 80% 16 Retained Customers 85%: 17 Additional Retained Customers: 18 Incremental Annual Purchases: 19 Additional Annual Profits: 20 Cumulative Additional Annual Profits: 24 Conclusion