Pricing Information for Golf Balls Fox Lake Country Club - Equipment Division Product Unit Weight Unit Price ID (Pounds) Unit Shipping Price Tier 1 Tier 2 1 $ 11.75 2 $ 0.75 2 $ 12.05 1 $ 0.50 Shipping Discount 1 Region 1 8.0% Region 2 10.0% Region 1 Region 2 Shipping Discount 1 5.5% 15.0% 3 $ 12.50 3 $ 0.20 Shipping Discount 2 6.5% 8.0% Shipping Discount 2 12.0% 12.0% 4 $ 12.27 $ 0.25 Shipping Discount 3 9.5% 5.0% Shipping Discount 3 9.5% 10.0% 5 $ 24.00 4 $ 1.00 Shipping Discount 4 6.0% 2.5% Shipping Discount 4 6.5% 8.0% Shipping Discount Order # Cust ID Product ID Quantity Tier Region Type Total Price Total Shipping Shipping Discount Grand Total Instructions: 1 NP339 1 228 2 2 2 $ 24.00 2 MH394 3 48 2 2 1 3 AX843 5 137 1 1 2 4 BR423 1 102 2 1 1 5 PK880 5 550 1 2 4 6 EQ737 5 2 1 3 7 DN00 1 250 1 1 3 8 DS00 3 75 1 1 2 9 UWOO 3 185 1 1 1 10 KJ00 5 200 2 1 1 11 LP00 3 125 1 2 4 ND00 2 45 1 2 2 13 AB00 2 75 2 1 3 Use the appropriate lookup and/or index function to fill out the spreadsheet. Total Price is based on Quantity ordered multiplied by the Unit Price for the Product ID ordered. Total Shipping is based on each Product's Unit Shipping Price multiplied by the Quantity ordered. Shipping Discount is based on an order's Tier, Shipping Discount Type and Region, which is deducted from the Total Shipping amount. Grand total is based on the Total Price + Total Shipping - Shipping Discount Questions to be answered What is the grand total for all orders shipped? What is the dollar amount for the shipping discount for order #5? What is the total price for order #13? What is the SUM for all shipping discounts combined? What is the Total Shipping amount if the Unit Price to ship Product 5 increased to $1.25 per item? 14 TC00 1 225 2 2 4 15 DL10 1 42 2 1 1 16 WE00 2 115 2 2 3 17 AZ10 2 220 1 2 1 18 ZZ89 4 353 1 2 2 19 LL34 4 405 1 1 3 20 BN08 5 23 1 2 4 Totals