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)