Please include formulas and clear step by step instructions on completing the assignment.
1 ion for Golf B 2 lipment Divisi \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 3 & . & & & & & & & & & & \\ \hline 4 & & & & & & & & & & & \\ \hline 5 & \begin{tabular}{l} Unit Pr \\ Golf \end{tabular} & \begin{tabular}{l} ricing \\ Balls \end{tabular} & & \begin{tabular}{l} Shippin \\ Costs \end{tabular} & & & & Ship & ipping Disc & count & \\ \hline 6 & Qty & \$leach & & Method & \$/each & & Total Pric & & $0 & $500 & $1,000 \\ \hline 7 & 0 & $5.85 & & Rail & $0.22 & & Shipping & Discount & 0% & 15% & 20% \\ \hline 8 & 50 & $5.73 & & Truck & $0.28 & & Shipping & Discount & 0% & 10% & 15% \\ \hline 9 & 100 & $5.60 & & Ship & $0.18 & & & & & & \\ \hline 10 & 190 & $5.40 & & Custome & $.0 & & & & & & \\ \hline 11 & & & & & & & & & & & \\ \hline 12 & & & & & & & & & & & \\ \hline 13 & Orderit & Cust ID & Shippin & Quantity & \begin{tabular}{l} Unit \\ Price \end{tabular} & \begin{tabular}{l} Total \\ Price \end{tabular} & \begin{tabular}{c} Unit \\ Shippinc \end{tabular} & \begin{tabular}{l} Total \\ Shippinc \end{tabular} & \begin{tabular}{l} Shipping \\ Discount \end{tabular} & \begin{tabular}{c} Grand \\ Total \end{tabular} & \\ \hline 14 & 101 & \begin{tabular}{|l|} RG339 \\ \end{tabular} & Truck & 354 & & & & & & & \\ \hline 15 & 102 & HM394 & Zustome & 47 & & & & & & & \\ \hline 16 & 103 & \begin{tabular}{|c|} XA843 \\ \end{tabular} & Boat & 1900 & & & & & & & \\ \hline 17 & 104 & PK423 & Truck & 103 & & & & & & & \\ \hline 18 & 105 & PK880 & Justomei & 360 & & & & & & & \\ \hline 19 & 106 & EN737 & Rail & 135 & & & & & & & \\ \hline 20 & & & & & & & & & & & \\ \hline 21 & & & & & & & & & & & \\ \hline 22 & 1 & & & & & & & & & & \\ \hline 23 & & & & & & & & & & & \\ \hline \end{tabular} 1. Open the workbook named Golf.xlsx located in the Chapter 5 folder, and then save Chopler the file as Golf Orders 1.xlsx. 2. In the Golf Balls worksheet, complete the Unit Pricing lookup table to include the units and corresponding prices that TheZone charges for golf balls. 3. Complete the Shipping Costs table to list the appropriate unit shipping charges. 4. In cell E14, use the appropriate lookup function to calculate the unit price for this order based on the quantity ordered. Write the formula so that it can be copied down the column, and then copy the formula into cells E15:E19. 5. In cell F14, calculate the total price for the order (excluding shipping). Write the formula so that it can be copied down the column, and then copy the formula into cells F15:F19. 6. In cell G14, calculate the unit shipping charge for the order based on the shipping method. Write the formula so that it can be copied down the column, and then copy the formula into cells G15:G19. Correct data entry errors, as necessary. 7. In cell H14, calculate the total shipping cost for the order. Write the formula so that it can be copied down the column, and then copy the formula into cells H15:H19. 8. In cell 114 , calculate the shipping discount for the order, using Shipping Discount B, based on the total price (column F). The discounted value will be the corresponding percentage times the total shipping cost previously calculated. Write the formula so that it can be copied down the column, and then copy the formula into cells I15:I19. 9. In cell 114 , calculate the grand total for the order. Write the formula so that it can be copied down the column, and then copy the formula into cells J15:J19. 10. Save and close the Golf Ordersl .xlsx workbook
