Formatting Workbook Text and Data
Om20
Popcorn8-1.xlsxDocumentation
| Ricky's Popcorn | |
| Author | |
| Date | |
| Purpose | To create an invoice for customer sales |
Customer Invoice
| Ricky's Popcorn | |||||||||
| 1024 South Main | |||||||||
| Hawthorne, Nevada 89145 | |||||||||
| (775) 555-1212 | |||||||||
| Date Sold: | |||||||||
| Sold to: | |||||||||
|
Carol DesJardins: Ricky Nolan: Please enter the state for the shipment for sales tax purposes. | Item | Flavor | Qty | Price | Total | ||||
| Notes: | Subtotal | ||||||||
| Sales Tax | |||||||||
| Shipping | |||||||||
| Total Due | |||||||||
| Standard Popcorns | Gourmet Popcorns | ||||||||
| Natural | Too Hot to Handle | ||||||||
| Buttered | Chipotle BBQ | ||||||||
| White Cheddar | Nacho Cheese | ||||||||
| Cheesy Cheddar | Cinnamon & Brown Sugar | ||||||||
| Kettlecorn | Grape | ||||||||
| Cajun | Orange | ||||||||
| Sour Cream 'n Chive | Key Lime | ||||||||
| Salt 'n Vinegar | Island Coconut | ||||||||
| Caramel | Cookies & Cream |
Pricing and Shipping
| Product Pricing | Shipping Cost Table | ||||||||
| Item | Price | Order Amount | Shipping Cost | ||||||
| Standard (1) 1 g | $ 15.00 | 5 | $ 4.00 | Adjustable Home Bed Rail | 89.95 | ||||
| Gourmet (1 ) 1 g | $ 20.00 | 15 | $ 8.50 | Bed Cane | 81.95 | ||||
| Standard (2 ) 1 g | $ 20.00 | 25 | $ 12.50 | Doorknob Gripper | 4.95 | ||||
| Gourmet (2 ) 1 g | $ 25.00 | 50 | $ 16.00 | Easy Grip Utensils | 32.95 | ||||
| Standard (3 ) 1 g | $ 25.00 | 100 | $ - 0 | Economy Patient Gowns | 6.95 | ||||
| Gourmet (3 ) 1 g | $ 30.00 | Full-Page Magnifier | 4.99 | ||||||
| Standard (1 ) 2 g | $ 20.00 | Giant TV Remote | 34.95 | ||||||
| Gourmet (1 ) 2 g | $ 25.00 | Inflatable Shampoo Basin | 39.95 | ||||||
| Standard (2 ) 2 g | $ 25.00 | Jar Opener | 5.95 | ||||||
| Gourmet (2 ) 2 g | $ 30.00 | Lamp Switch Enlarger | 4.95 | ||||||
| Standard (3 ) 2 g | $ 30.00 | Medication Dispenser | 135.95 | ||||||
| Gourmet (3 ) 2 g | $ 35.00 | No Rinse Shampoo | 34.95 | ||||||
| Standard (1 ) 3 g | $ 25.00 | Tilting Overbed Table | 114.95 | ||||||
| Gourmet (1 ) 3 g | $ 30.00 | Trolley Walker | 139.95 | ||||||
| Standard (2 ) 3 g | $ 30.00 | Wheelchair Poncho | 51.95 | ||||||
| Gourmet (2 ) 3 g | $ 35.00 | ||||||||
| Standard (3 ) 3 g | $ 35.00 | ||||||||
| Gourmet (3 ) 3 g | $ 40.00 | ||||||||
| Plain tin 1 g | $ 5.00 | ||||||||
| Fancy tin 1 g | $ 7.00 | ||||||||
| Plain tin 2 g | $ 8.00 | ||||||||
| Fancy tin 2 g | $ 10.00 | ||||||||
| Plain tin 3 g | $ 11.00 | ||||||||
| Fancy tin 3 g | $ 13.00 | ||||||||
