Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric drill on average every two years (or every 0.5 year) for $100, when the gross margin on the drill averages 40 percent. The data has been collected in the Microsoft Excel Online e below. Open the spreadsheet and perform the required analysis to answer the questions below, Jinni Open spreadsheet Questions 1. What is the value of a loyal customer (VLC) if the customer retention rate is 20 percent Round your answer to the nearest cent $ 2. What is the value of a loyal customer (VLC) ir the customer retention rate increases to 80 percent? Round your answer to the nearest cent. $ 3. What is a percent change in market Ahare worth to the manufacturer in represents 150,000 customers? Round your answers to the nearest dollar 20 percent customer retention rate cate: $ BO percent customer retention rate Cases 1. What do you conclude? If customer retention can be increased from 20 to Ho percent through better value chain performance, the economic payoffs Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric drill on average every two years (or every 0.5 year) for $100, when the gross margin on the drill averages 40 percent. The data has been collected in the Microsoft Excel Online e below. Open the spreadsheet and perform the required analysis to answer the questions below, Jinni Open spreadsheet Questions 1. What is the value of a loyal customer (VLC) if the customer retention rate is 20 percent Round your answer to the nearest cent $ 2. What is the value of a loyal customer (VLC) ir the customer retention rate increases to 80 percent? Round your answer to the nearest cent. $ 3. What is a percent change in market Ahare worth to the manufacturer in represents 150,000 customers? Round your answers to the nearest dollar 20 percent customer retention rate cate: $ BO percent customer retention rate Cases 1. What do you conclude? If customer retention can be increased from 20 to Ho percent through better value chain performance, the economic payoffs