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 $90 per visit, the frequency of repurchase is seven times per year, the contribution margin is 10 percent, and the average customer defection rate is 20 percent? Round your answer to the nearest dollar. X $ What is the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $60 per visit, the frequency of repurchase is every month, the contribution margin is 27%, and the average customer defection rate is 22%? If a continuous improvement goal is set of a 20% defection rate next year and 17% two years from now, what are the revised VLCs over their average buying life? Do not round intermediate calculations. Round your answers to the nearest dollar. 151.6 For defection rate = 22%, VLC = $ 156 For defection rate = 20%, VLC = $ 161 For defection rate = 17%, VLC = $