\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Customers & Parts & Price & Quantity & Totals due & & & & \\ \hline Customer1 & Bearing & & 4 & & Price tab & & Discount ta & \\ \hline Customer2 & Gear & & 48 & & Parts & Unit Price & 1 & 0% \\ \hline Customer3 & Widget & & 56 & & Bearing & 17.34 & 10 & 1% \\ \hline Customer4 & COG & & 2 & & Gear & 23.56 & 25 & 2% \\ \hline Customer5 & Bolt & & 35 & & Widget & 14.76 & 100 & 3% \\ \hline Customer6 & Washer & & 21 & & COG & 20.21 & 500 & 4% \\ \hline Customer7 & Gear & & 635 & & Bolt & 1.54 & 1000 & 5% \\ \hline Customer8 & Gear & & 65 & & Washer & 1.43 & & \\ \hline Customer9 & Bearing & & 3 & & & & & \\ \hline Customer10 & Bolt & & 243 & & \multirow{5}{*}{\multicolumn{4}{|c|}{\begin{tabular}{l} Use this table to determine the correct price here. \\ Use the discount table to determine "Total due". \\ You must use the appropriate function(s) to \\ maximize your marks. \end{tabular}}} \\ \hline Customer11 & Washer & & 31 & & & & & \\ \hline Customer12 & Gear & & 32 & & & & & \\ \hline Customer13 & Bearing & & 11 & & & & & \\ \hline Customer14 & Widget & & 12 & & & & & \\ \hline Customer15 & Gear & & 31 & & & & & \\ \hline Customer16 & 5 Bolt & & 314 & & & & & \\ \hline Customer17 & Washer & & 4 & & & & & \\ \hline Customer18 & Widget & & 34 & & & & & \\ \hline Customer19 & Bearing & & 54 & & & & & \\ \hline Customer20 & Gear & & 65 & & & & & \\ \hline \end{tabular}