excel 3
Golf Balls - 23FallB
| Pricing Information for Golf Balls | ||||||||||
| TheZone Equipment Division | ||||||||||
| Unit Pricing Golf Balls | Shipping Costs | Shipping Discount | ||||||||
| Qty | $/each | Method | $/each | Total Price | $0 | $500 | $1,000 | |||
| Rail | Shipping Discount A | 0% | 15% | 20% | ||||||
| Truck | Shipping Discount B | 0% | 10% | 15% | ||||||
| Ship | ||||||||||
| Customer | ||||||||||
| Order# | Cust ID | Shipping | Quantity | Unit Price | Total Price | Unit Shipping | Total Shipping | Shipping Discount | Grand Total | |
| 101 | RG339 | Truck | 354 | |||||||
| 102 | HM394 | Customer | 47 | |||||||
| 103 | XA843 | Boat | 1900 | |||||||
| 104 | PK423 | Truck | 103 | |||||||
| 105 | PK880 | Customer | 360 | |||||||
| 106 | EN737 | Rail | 135 |