Date
|
Employee
|
Purchased Item
|
Units
|
Unit Cost
|
Total Amount
|
Discount
|
Discount Amount
|
Final Total
|
12/15/2007
|
Jones
|
Pen Set
|
700
|
1.99
|
=E2*D2
|
3%
|
=F2*G2
|
=SUM(F2, -H2)
|
12/18/2007
|
Kivell
|
Binder
|
85
|
19.99
|
=E3*D3
|
5%
|
=F3*G3
|
=SUM(F3, -H3)
|
12/21/2007
|
Howard
|
Pen and Pencil
|
62
|
4.99
|
=E4*D4
|
4%
|
=F4*G4
|
=SUM(F4, -H4)
|
12/24/2007
|
Gill
|
Pen
|
58
|
19.99
|
=E5*D5
|
6%
|
=F5*G5
|
=SUM(F5, -H5)
|
12/27/2007
|
Anderson
|
Binder
|
10
|
4.99
|
=E6*D6
|
3%
|
=F6*G6
|
=SUM(F6, -H6)
|
12/30/2007
|
Anderson
|
Pen Set
|
19
|
2.99
|
=E7*D7
|
5%
|
=F7*G7
|
=SUM(F7, -H7)
|
1/2/2008
|
Anderson
|
Pen Set
|
6
|
1.99
|
=E8*D8
|
7%
|
=F8*G8
|
=SUM(F8, -H8)
|
1/5/2008
|
Howard
|
Pen and Pencil
|
10
|
4.99
|
=E9*D9
|
4%
|
=F9*G9
|
=SUM(F9, -H9)
|
1/8/2008
|
Wilson
|
Paper
|
39
|
1.99
|
=E10*D10
|
2%
|
=F10*G10
|
=SUM(F10, -H10)
|
1/11/2008
|
Wilson
|
Binder
|
1
|
8.99
|
=E11*D11
|
5%
|
=F11*G11
|
=SUM(F11, -H11)
|
1/14/2008
|
Wilson
|
Pen and Pencil
|
80
|
4.99
|
=E12*D12
|
7%
|
=F12*G12
|
=SUM(F12, -H12)
|
1/17/2008
|
Wilson
|
Binder
|
51
|
1.99
|
=E13*D13
|
6%
|
=F13*G13
|
=SUM(F13, -H13)
|
1/20/2008
|
Wilson
|
Binder
|
10
|
19.99
|
=E14*D14
|
8%
|
=F14*G14
|
=SUM(F14, -H14)
|
1/23/2008
|
Wilson
|
Pen Set
|
15
|
4.99
|
=E15*D15
|
3%
|
=F15*G15
|
=SUM(F15, -H15)
|
1/26/2008
|
Wilson
|
Desk
|
31
|
125.00
|
=E16*D16
|
5%
|
=F16*G16
|
=SUM(F16, -H16)
|
1/29/2008
|
Jones
|
Pen Set
|
46
|
15.99
|
=E17*D17
|
3%
|
=F17*G17
|
=SUM(F17, -H17)
|
2/1/2008
|
Kivell
|
Binder
|
61
|
8.99
|
=E18*D18
|
6%
|
=F18*G18
|
=SUM(F18, -H18)
|
2/4/2008
|
Jones
|
Pen
|
90
|
8.99
|
=E19*D19
|
4%
|
=F19*G19
|
=SUM(F19, -H19)
|
2/7/2008
|
Parent
|
Pen
|
43
|
19.99
|
=E20*D20
|
7%
|
=F20*G20
|
=SUM(F20, -H20)
|
2/10/2008
|
Kivell
|
Pen Set
|
32
|
4.99
|
=E21*D21
|
4%
|
=F21*G21
|
=SUM(F21, -H21)
|
2/13/2008
|
Smith
|
Pen Set
|
37
|
1.29
|
=E22*D22
|
8%
|
=F22*G22
|
=SUM(F22, -H22)
|
2/16/2008
|
Parent
|
Pen Set
|
26
|
15.99
|
=E23*D23
|
2%
|
=F23*G23
|
=SUM(F23, -H23)
|
2/19/2008
|
Gill
|
Binder
|
79
|
8.99
|
=E24*D24
|
3%
|
=F24*G24
|
=SUM(F24, -H24)
|
2/22/2008
|
Smith
|
Pen Set
|
72
|
15.00
|
=E25*D25
|
6%
|
=F25*G25
|
=SUM(F25, -H25)
|