(Solved): Excel Activity: VLC HVideo Excel Online Activity: VLC Assume that a customer in the small contracto ...

Excel Activity: VLC HVideo Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric drill on average every four years (or every 0.25 year) for $50, when the gross and perform the required analysis to answer the questions below. Open spreadsheet Questions 1. What is the value of a loyal customer (VLC) if the customer retention rate is 50 percent? Round your answer to the nearest cent. $ 2. What is the value of a loyal customer (VLC) if the customer retention rate increases to 75 percent? Round your answer to the nearest cent. S 3. What is a 1 percent change in market share worth to the manufacturer if it represents 100,000 customers? Round your answers to the nearest dollar. 50 percent customer retention rate case: $ 75 percent customer retention rate case: s 4. What do you conclude? If customer retention can be increased from 50 to 75 percent through better value chain performance, the economic payoff is ? C M Gmail YouTube Maps Objective-Based Qu... Excel template- Saved File 812 Chapter 2-SUMMER 2022-BU X 1 2 3 20 B Arial 4 5 6 7 a 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Value of a Loyal Customer 27 28 29 30 BE 32 33 34 about blank 35 36 37 Repurchase frequency (purchases/year) Customer retention rate Number of customers representing 1 percent market share 738 39 40 41 (42 44 Home Insert Draw Page Layout 30 A 45 40 47 MindTap-Cengage Learning X fr Revenue per unit Percent contribution margin to profit and overhead Buyer's life cycle VLC Value of a 1 percent change in market share Customer retention rate Buyer's life cycle VLC Value of a 1 percent change in market share Objective-Based Qu... Formulas Data Review View A B IU B $50.00 50% 0.25 0.5 100.000 Excel Online Student Work 2.00 $12.50 0.75 Formulas =1/(1-86) Connect 83 84 85 89 #N/A #N/A #N/A #N/A Help A ab