Assignment #$7$

Fisher Company offers discounts for customers who order larger quantities of product in a single order. Each customer must order units in multiples of $50$ units.

The following table shows the discount for each product

each product sold by Fisher and the minimum quantity required to be ordered for the customer to receive the discount.

$\backslash$table$[[$Minimum$,,,,,],[$Purchase$,,$Prod,,,$],[$Requirement$,1,2,3,4,$Customer$],[150,1\mathrm{.}00\%,2\%,1\%,2\%,$Higgins$],[300,1\mathrm{.}50\%,4\%,2\%,2\mathrm{.}50\%,$Lark$],[450,2\mathrm{.}00\%,6\%,3\%,3\%,$Jones$],[600,2\mathrm{.}50\%,8\%,4\%,3\mathrm{.}50\%,$Cameron$],[750,3\mathrm{.}00\%,10\%,5\%,5\%,$Dell$],[900,3\mathrm{.}50\%,12\%,6\%,5\mathrm{.}50\%,$Ferber$],[1,050,4\mathrm{.}00\%,14\%,7\%,6\%,],[1,200,4\mathrm{.}50\%,16\%,8\%,9\%,],[1,350,5\mathrm{.}00\%,18\%,9\%,9\mathrm{.}50\%,],[1,500,7\mathrm{.}50\%,20\%,10\%,10\%,]]$

Instructions:

Task A

For each customer, indicate the discount that the customer qualifies for $($if any$).$

Use the IF and a nested HLOOKUP function.

Task B

For each customer, compute the net purchase cost, subtracting the appropriate discount $($if any$)$ from the gross purchase cost. Use the IF and a nested VLOOKUP function.

Hints:

Don't forget the data range should be named.

For the LOOKUP functions, remember that the final argument of the function is which row or