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.

Croy inc. has the following projected sales for the next five months: month sales in units april 3,850 may 3,875 june 4,260 july 4,135 august 3,590 croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. direct material costs $2.50 per pound, and each unit requires 2 pounds. raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. raw materials on hand at march 31 totaled 3,741 pounds. 1. determine budgeted production for april, may, and june. 2. determine the budgeted cost of materials purchased for april, may, and june. (round your answers to 2 decimal places.)