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 20 percent. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis with excel formulas to fill in the blanks.