1. Add a calculated field to this table that shows the net selling price after he has paid the commission to the consignors.

2. Create an Inventory Report. The Inventory Report summarizes the inventory by item type. This report will include the number of items and the total selling price for each item type, plus the total sales value of each inventory type. It will also include the total potential commission to be earned if all items are sold.

3. Create one other report that you think would be useful to the owner?

Data Udal Field1 Click to Add- Typel Typel #Typel Type 544 Typel ate External Data Database Tools Help Table Fields Table Tell me what you want to do til items x Item No Item Type - CommRate - Selling Price - DateConsign Customer IC - Commission- D34 Dress 0.25 $21.00 12/10/2010 W234 $5.25 543 Casual Shoes 0.15 $6.50 12/10/2010 W234 $0.98 Casual Shoes 0.15 $6.50 12/10/2010 W234 $0.98 B367 Blouse 0.25 $7.50 1/6/2011 W234 $1.88 SK235 Skirt 0.20 $16.00 1/6/2011 W234 $3.20 SK236 Skirt 0.20 $16.00 1/6/2011 W234 $3.20 D5256 Dress Shoes 0.30 $14.50 1/6/2011 W234 $4.35 SW1987 Sweater 0.20 $8.00 1/6/2011 W234 $1.60 SW1988 Sweater 0.20 $9.00 1/6/2011 W234 $1.80 SW 1989 Sweater 0.20 $8.00 1/6/2011 W234 $1.60 DS266 Dress Shoes 0.30 $14.50 1/6/2011 W234 $4.35 036 Dress 0.25 $21.00 9/23/2010 B032 $5.25 SU32 Suit 0.30 $36.00 9/23/2010 B032 $10.80 H104 Hat 0.15 $7.25 9/23/2010 8032 $1.09 H105 Hat 0.15 $7.25 9/23/2010 8032 $1.09 B324 Blouse 0.25 $7.50 9/23/2010 B032 $1.88 SW 232 Sweater 0.20 58.00 9/23/2010 B032 $1.60 DS155 Dress Shoes 0.30 $21.00 9/23/2010 1032 $6.30 SK189 Skirt 0.20 $16.00 9/23/2010 1032 $3.20 SW 1676 Sweater 0.20 $8.00 10/24/2010 1032 $1.60 541 Casual Shoes 0.15 $6.50 10/24/2010 3032 $0.98 SU27 Suit 0.30 $36.00 10/24/2010 B032 $10.80 536 Casual Shoes 0.15 $6.50 6/23/2010 S029 $0.98 Casual Shoes 538 0.15 $6.50 $0.95 6/23/2010 S029 econdo Search NetSelling - $15.75 $5.53 $5.53 $5.63 $12.80 $12.80 $10.15 $6.40 $7.20 $6.40 $10.15 $15.75 $25.20 $6.16 $6.16 $5.63 $6.40 $14.70 $12.80 $6.40 $5.53 $25.20 $5.53 55.53 Typel #Type! Type Type! #Type HType Typel #Type #Type Typel Typel Type Typel Typel #Type Typel Type Type! Type N 10 AM D 49'F G o e here to search C