B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Unit Pricing Golf Balls Qty 30 31 32 33 $/each 0 $ 10.00 100 $ 9.00 250 $8.50 1000 $8.00 Cust ID 101 RG339 102 HM394 103 XA843 Truck Customer Boat Truck 105 PK880 Customer EN737 Rail 104 PK423 106 Order# 23 24 25 26 27 28 29 Example of correct values Order# Shipping Costs $/each $ 0.10 $ 0.50 $ 0.05 Method Shipping Quantity 101 RG339 Truck Rail Truck Ship Customer $ Pricing Information for Golf Balls TheZone Equipment Division Cust ID Shipping Quantity Unit Price 354 $8.50 Unit Total Shipping Shipping $3,009.00 $0.50 $ 177.00 47 $ 10.00 $ 470.00 $ #N/A 1900 $8.00 $15,200.00 103 $9.00 927.00 $ 0.50 $ 360 $ 8.50 $3,060.00 $ 135 $ 9.00 $1,215.00 $ 0.10 $ $ 354 $ Total Price Unit Price $ $ Shipping Discount $0 Total Price Shipping Discount A Shipping Discount B Total Price #N/A 51.50 Unit Total Shipping Shipping 8.50 $3,009.00 $0.50 $ 177.00 13.50 0% 0% Shipping Discount #N/A Shipping Discount $500 15% 10% Grand Total Grand Total 15% $3,159.45 $1,000 20% 15%

Please calculate the discount rate using Hlookup formula.

Pricing Information for Golf Balls TheZone Equipment Division \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & & & & & & & & & & \\ \hline 1 & & & & & & & & & & & \\ \hline 12. & \begin{tabular}{l} Unit Pr \\ Golf E \end{tabular} & \begin{tabular}{l} ricing \\ Balls \end{tabular} & & Shipping & Costs & & & & ipping Disco & count & \\ \hline 13 & Qty & Sieach & & Method & \$leach & & Total Price & & $0 & $500 & $1,000 \\ \hline 14 & 0 & $1000 & & Rall & $010 & & Shipping D & Discount A & 0% & 15% & 20% \\ \hline 15 & 100 & $900 & & Truck & $0.50 & & Shipping D & Discount 8 & 0% & 10% & 15% \\ \hline 16 & 250 & 58.50 & & Ship & $005 & & & - & & & \\ \hline 17 & 1000 & 5800 & & Cusstomer & $ & & & & & & \\ \hline 18 & & & & & & & & & & & \\ \hline 19 & & & & & & & & & & & \\ \hline 20 & Order" & Cust iD & Shipping & Quantity & \begin{tabular}{l} Unit \\ Price \end{tabular} & Total Price & \begin{tabular}{l} Unit \\ Shipping \end{tabular} & \begin{tabular}{c} Total \\ Shippine \end{tabular} & \begin{tabular}{l} Shipping \\ Discount \end{tabular} & Grand Total & \\ \hline 21 & 101 & RG339 & Truck & 354 & $850 & $3,00000 & $050 & $17700 & ANVA & & \\ \hline 22 & 102 & HMM394 & Customer & 47 & $10.00 & s 47000 & 5 & 5 & & & . \\ \hline 231 & 103 & XAB43 & Boat & 1900 & 5800 & $15,20000 & INA & C HNA & & & \\ \hline 24 & 104 & PK423 & Truck & 103 & $900 & s 92100 & $$0.50 & s 51.50 & & & \\ \hline 25 & 105 & PKo80 & Customer & 300 & $850 & $3,06000 & s= & $ & & & \\ \hline 26 & 100 & EN/37 & Rail & 135 & $900 & $1,215.00 & $0.10 & s 13.50 & & & \\ \hline 27 & & & & & & & & & & & \\ \hline 28 & & & & & & 5 & & & & & \\ \hline 29 & Example of & of correct & values & & & & & & & & \\ \hline 30 & Orderi & Cust iD & Shipping & Quantity & \begin{tabular}{l} Unit \\ Price \end{tabular} & Total Price & \begin{tabular}{c} Unit \\ Shipping \end{tabular} & \begin{tabular}{l} Total \\ Shipping \end{tabular} & \begin{tabular}{l} Shipping \\ Discount \end{tabular} & Grand Total & \\ \hline 31 & 101 & RG339 & Iruck & 354 & $850 & $3.00900 & $050 & $17700 & 15% & $3,15945 & \\ \hline 32 & & & & & & & & & & & \\ \hline 31 & & & & & & & & & & & \\ \hline \end{tabular}