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