Question: i need help with question 1-4 please. Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric

i need help with question 1-4 please. i need help with question 1-4 please. Excel
Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric drill on average every five years (or every 0.2 year) for $100, when the gross margin on the drill averages 30 percent. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. HT 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. $ 7.5 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. 5 3.75 3. What is a 1 percent change in market share worth to the manufacturer if it represents 150,000 customers? Round your answers to the nearest dollar. 50 percent customer retention rate case: 5 75 percent customer retention rate case: 5 4. What do you rondde? Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric drill on average every five years (or every 0.2 year) for $100, when the gross margin on the drill averages 30 percent. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. HT 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. $ 7.5 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. 5 3.75 3. What is a 1 percent change in market share worth to the manufacturer if it represents 150,000 customers? Round your answers to the nearest dollar. 50 percent customer retention rate case: 5 75 percent customer retention rate case: 5 4. What do you rondde

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!