In cell D17 of orders worksheet, calculate handling cost. be certain to account for the maximum handling charge. handling fees are based on total order value excluding shipping and discounts

Golf Products Order Form Shipping weight Region number Shipping method Customer type Item# 1 7 4 15 5 Quantity 175 1 3 2 Description 10 Titanium Driver - Men 2 Stainless Steel Fairway - Women 8 Fairway Woods - Men 2 Package - Men 20 Hybrid Woods - Men Total Order Shipping Handling Discount Grand Total $ $ $ $ $ Total 3,250.00 400.00 1,592.00 1,350.00 1,199.00 $ 7,791.00 $ 236.25 $ (125.00) Pricing Information for Golf Equipment TheZone Equipment Division Item# Description 1 Titanium Driver - Men 2 Fusion Driver - Women 3 Titanium Driver - Women 4 Fairway Woods - Men 5 Hybrid Woods - Men 6 Fusion Fairway - Women 7 Stainless Steel Fairway - Women 8 Irons w/Steel Shafts - Men 9 Hybrid Irons - Men 10 Irons w/Steel Shafts - Women 11 Hybrid Irons - Women 12 Steel Putter - Men 13 Steel Putter - Women 14 Forged Wedges - Men 15 Package - Men 16 Package - Women Price/item $ 325.00 $ 545.00 $ 300.00 $ 199.00 $ 59.95 $ 500.00 $ 200.00 $ 525.00 $ 399.00 $ 375.00 $ 399.00 $ 119.99 $ 119.99 $ 105.00 $ 675.00 $ 675.00 Handling charges: Total order value Handling charge (% of order value) $ Maximum Handling Fee $ 30.00 $ 2,500 $ 5,000 $ 7,500 $ 0.007 0.006 0.005 0.004 10,000 $ 12,500 0.003 0.002 Discount Total Order Value $ - $ $ 125 $ 5,000 $ 500 $ 10,000 $ 1,000 $ 50,000 Description Less than $5,000, no discount At least $5,000 but less than $10,000, $150 discount At least $10,000 but less than $50,000, $400 discount $50,000 or more, $1000 discount $ $ $ $ $ Shipping Method - Standard 1 2 3 0.11 $ 0.12 $ 1.50 0.19 $ 0.13 $ 2.00 0.25 $ 0.14 $ 2.10 $ 0.29 $ 0.17 $ 2.25 $ 0.46 $ 0.41 $ 3.50 $ $ $ $ $ $ Shipping Method - Preferred 1 2 3 4 0.10 $ 0.11 $ 1.35 NA 0.17 $ 0.12 $ 1.80 NA 0.23 $ 0.14 $ 1.89 $ 0.18 0.26 $ 0.15 $ 2.03 $ 0.18 0.42 $ 0.37 $ 3.15 $ 0.32 $ $ $ $ $ Shipping Method - Most Preferred 1 2 3 4 0.09 $ 0.10 $ 1.22 NA 0.16 $ 0.11 $ 1.62 NA 0.20 $ 0.12 $ 1.70 $ 0.16 0.24 $ 0.14 $ 1.82 $ 0.16 0.37 $ 0.33 $ 2.84 $ 0.28 Region 1 2 3 4 5 Region 1 2 3 4 5 Region 1 2 3 4 5 4 NA NA 0.20 0.20 0.35