B Spreadsheet Use the Excel template VLC to find the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $75 per visit, the frequency of repurchase is six times per year, the contribution margin is 5 percent, and the average customer defection rate is 20 percent? Round your answer to the nearest dollar. $ 1 Value of a Loyal Customer 2 Enter data only in yellow cells. 3 4 5 6 7 00 8 9 10 OCengage Learning Not for commercial use. Revenue per unit $100.00 Percent contribution margin to profit and overhead 50.0% Repurchase frequency (purchases/year) 0.25 Defection rate 0.4 Buyer's life cycle 2.50 VLC $31.25