5. In the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria in the range A14:F15. For example, if total sales in Quarter 1 are between $5900 and $5999, the Performance rating is Good. Enter the performance ratings as follows: a. In cell B12, start to enter a formula using the HLOOKUP function.

Aproperty title search firm is contemplating using online software to increase its search productivity. currently an average of 40 minutes is needed to do a title search. the researcher cost is $2 per minute. clients are charged a fee of $400. company a's software would reduce the average search time by 10 minutes, at a cost of $3.50 per search. company b's software would reduce the average search time by 12 minutes at a cost of $3.60 per search. which option would have the higher productivity in terms of revenue per dollar of input?