Alison Hunt
813116532
Assignment #4
C:\Docstoc\Working\pdf\a4ec5145-3d23-48e0-bf65-e66ece7ca0cf.xlsx
Alison Hunt
Customer ID 813116532 Order Date January 5, 2012
Customer Name Alison Hunt
Product ID Description Quantity OrderedUnit Cost Extended Price
1001 Gold Bracelet 2 $22.95 $45.90
1003 Gold Necklace 4 $19.95 $79.80
1004 Silver Necklace 1 $19.95 $19.95
1007 Gold Ring 1 $19.95 $19.95
1009 Gold Chain 3 $22.95 $68.85
Subtotal $234.45
Tax $20.51
Discount $23.45
Total $231.52
Product Name Product ID Unit Cost
Gold Bracelet 1001 $ 22.95
Silver Bracelet 1002 $ 19.95
Gold Necklace 1003 $ 19.95
Silver Necklace 1004 $ 27.95
Gold Earrings 1005 $ 35.95
Silver Earrings 1006 $ 15.95
Gold Ring 1007 $ 12.95
Silver Ring 1008 $ 15.95
Gold Chain 1009 $ 9.95
Silver Chain 1010 $ 19.95
Tax Rate 8.75%
Discount Rate 10.00%