210 likes | 657 Views
Trade Discount Series. Using Excel. Trade Discount Series. Also called “chain” discount Seller offers more than one discount one after the other Format: 20/10/10 which means 20%, 10% and 10% taken off in series. Set Up Labels. Enter List Price and Discounts. Be sure and type the % signs.
E N D
Trade Discount Series Using Excel
Trade Discount Series • Also called “chain” discount • Seller offers more than one discount one after the other • Format: 20/10/10 which means 20%, 10% and 10% taken off in series
Enter List Price and Discounts Be sure and typethe % signs
Enter First Discount Formula(Use Cell References) Don’t forget to hit Enter after entering
RESULTS: Enter First Discount Formula(Use Cell References) How much is saved for 1st discount
RESULTS: Find New List PriceOriginal List Price – Discount After 1st discount, new price of item is $560
RESULT: Discount on “NEW” List Price How much is saved for 2nd discount
“New” List Price Be sure and subtract previous new price
RESULTS: Final Price This is the Final price the buyer has to pay after a 20/10/10 trade discount series