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\mathrm{.}2$ year$)$ for $$200,$ when the gross margin on the drill averages $20$ 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.