ch01ex021.xlsx
Consignors
| Consignor ID | Consignor | Address | Phone |
| W234 | Shirley Crawford | 2445 Cooper | 555-3454 |
| B032 | Judith Brown | 234 Locust | 454-4545 |
| S029 | Emily Owens | 3200 Hwy 167 | 345-9809 |
Items
| Item No | Item Type | Commmission Rate | Selling Price | Date Consigned | Consignor ID |
| D34 | Dress | 0.25 | $ 21.00 | 12/10/2010 | W234 |
| S43 | Casual Shoes | 0.15 | $ 6.50 | 12/10/2010 | W234 |
| S44 | Casual Shoes | 0.15 | $ 6.50 | 12/10/2010 | W234 |
| B367 | Blouse | 0.25 | $ 7.50 | 01/06/2011 | W234 |
| SK235 | Skirt | 0.20 | $ 16.00 | 01/06/2011 | W234 |
| SK236 | Skirt | 0.20 | $ 16.00 | 01/06/2011 | W234 |
| DS256 | Dress Shoes | 0.30 | $ 14.50 | 01/06/2011 | W234 |
| SW1987 | Sweater | 0.20 | $ 8.00 | 01/06/2011 | W234 |
| SW1988 | Sweater | 0.20 | $ 9.00 | 01/06/2011 | W234 |
| SW1989 | Sweater | 0.20 | $ 8.00 | 01/06/2011 | W234 |
| DS266 | Dress Shoes | 0.30 | $ 14.50 | 01/06/2011 | W234 |
| D36 | Dress | 0.25 | $ 21.00 | 9/23/2010 | B032 |
| SU32 | Suit | 0.30 | $ 36.00 | 9/23/2010 | B032 |
| H104 | Hat | 0.15 | $ 7.25 | 9/23/2010 | B032 |
| H105 | Hat | 0.15 | $ 7.25 | 9/23/2010 | B032 |
| B324 | Blouse | 0.25 | $ 7.50 | 9/23/2010 | B032 |
| SW232 | Sweater | 0.20 | $ 8.00 | 9/23/2010 | B032 |
| DS155 | Dress Shoes | 0.30 | $ 21.00 | 9/23/2010 | B032 |
| SK189 | Skirt | 0.20 | $ 16.00 | 9/23/2010 | B032 |
| SW1676 | Sweater | 0.20 | $ 8.00 | 10/24/2010 | B032 |
| S41 | Casual Shoes | 0.15 | $ 6.50 | 10/24/2010 | B032 |
| SU27 | Suit | 0.30 | $ 36.00 | 10/24/2010 | B032 |
| S36 | Casual Shoes | 0.15 | $ 6.50 | 6/23/2010 | S029 |
| S38 | Casual Shoes | 0.15 | $ 6.50 | 6/23/2010 | S029 |
| H98 | Hat | 0.15 | $ 7.25 | 6/23/2010 | S029 |
| H94 | Hat | 0.15 | $ 7.25 | 6/23/2010 | S029 |
| S40 | Casual Shoes | 0.15 | $ 6.50 | 6/23/2010 | S029 |
| SW209 | Sweater | 0.20 | $ 8.00 | 6/23/2010 | S029 |
| D23 | Dress | 0.25 | $ 21.00 | 6/23/2010 | S029 |
| D22 | Dress | 0.25 | $ 21.00 | 6/23/2010 | S029 |
| SK217 | Skirt | 0.20 | $ 16.00 | 4/1/2010 | S029 |
| SU18 | Suit | 0.30 | $ 36.00 | 4/1/2010 | S029 |
| SW210 | Sweater | 0.20 | $ 8.00 | 2/23/2010 | S029 |
| H23 | Hat | 0.15 | $ 7.25 | 2/23/2010 | S029 |
qkiii123
