Assume that a customer in the small contractor target market segment buys an electric drill on average every four years $($or every $0\mathrm{.}25$ year$)$ for $$200,$ when the gross margin on the drill averages $40$ 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.Open spreadsheetQuestions$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.$ fill in the blank. 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.$ $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$\mathrm{.}50$ percent customer retention rate case: $ fill in the blank $75$ percent customer retention rate case: $