New Amount is Calculated using an IF statement. If the Amount is Greater than or equal to 8500, New Amount is Amount times 6% else the New Amount is Amount times 3 %

B D E G . M N O R New Amount is Calculated using an IF statement. If the Amount is Greater than or equal 4 to 8500, New Amount is Amount times 6% else the New Amount is Amount times 3 % Toti Transaction 5. Number 6 2012-001 7 2012-002 8 2012-003 9 2012-004 10 2012-005 11 2012-006 12 2012-007 13 2012-008 14 2012-009 15 2012-010 16 2012-011 17 2012-012 18 2012-013 19 2012-014 20 2012-015 21 2012-015 22 2012-016 23 2012-017 24 2012-018 25 2012-019 26 2012-020 27 2012-021 28 2012-022 20 Date 1/1/2012 1/1/2012 1/2/2012 1/2/2012 1/2/2012 1/3/2012 1/3/2012 1/3/2012 1/3/2012 1/4/2012 1/4/2012 1/4/2012 1/4/2012 1/4/2012 1/4/2012 1/4/2012 1/4/2012 1/4/2012 1/5/2012 1/5/2012 1/6/2012 1/6/2012 1/6/2012 Data Sales Sales Entry Rep First Rep Last Payment Operator Name Name Manufacturer Type Transaction Amount New Amount KM Deanne Fairbanks Port-a-Spa Finance Promotion $15,000 KM Grant Fairbanks Port-a-Spa Finance Promotion $12,000 MH Deanne Fairbanks Port-a-Spa Finance Promotion $ 3,240 COK Oleta Fairbanks The Original Hot Tub Finance Promotion $ 4,080 MAP Seth Fairbanks The Original Hot Tub Finance Promotion $ 5,432 KRM Deanne Ingersoll Port-a-Spa Finance Standard $ 6,780 KM Oleta Ingersoll Serenity Spas Finance Standard $ 5,432 LH Deanne Ingersoll Serenity Spas Paid in Full Standard $ 6,780 MAP Deanne Ingersoll The Original Hot Tub Paid in Full Standard $27,000 LH Grant McGuire Port-a-Spa Finance Standard $10,000 LH Oleta McGuire Port-a-Spa Finance Standard $10,000 KM Deanne McGuire Port-a-Spa Paid in Full Standard $ 4,550 KM Deanne McGuire Port-a-Spa Paid in Full Promotion $ 8,490 KRM Deanne McGuire Port-a-Spa Paid in Full Standard $ 5,432 Grant McGuire Port-a-Spa Paid in Full Promotion $ 7,450 COK Grant McGuire Serenity Spas Paid in Full Promotion $ 7,450 KM Oleta McGuire Serenity Spas Paid in Full Standard $ 5,432 MAP Seth McGuire The Original Hot Tub Paid in Full Promotion $ 6,780 LH Deanne McGuire The Original Hot Tub Finance + Standard $ 7,450 MAP Deanne McGuire The Original Hot Tub Paid in Full Standard $ 8,560 Deanne Prescott Serenity Spas Finance Promotion $26,500 KM Oleta Prescott Serenity Spas Finance Standard $ 5,000 KM Seth Prescott Serenity Spas Finance Promotion $ 8,560 COK MAP