Trade discount series
Download
1 / 16

Trade Discount Series - PowerPoint PPT Presentation


  • 127 Views
  • Updated On :

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Trade Discount Series' - faylinn


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Trade discount series2 l.jpg
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 l.jpg
Enter List Price and Discounts

Be sure and typethe % signs


Enter first discount formula use cell references l.jpg
Enter First Discount Formula(Use Cell References)

Don’t forget to hit Enter after entering


Results enter first discount formula use cell references l.jpg
RESULTS: Enter First Discount Formula(Use Cell References)

How much is saved for 1st discount


Find new list price original list price discount l.jpg
Find New List PriceOriginal List Price – Discount


Results find new list price original list price discount l.jpg
RESULTS: Find New List PriceOriginal List Price – Discount

After 1st discount, new price of item is $560



Result discount on new list price l.jpg
RESULT: Discount on “NEW” List Price

How much is saved for 2nd discount


New list price l.jpg
“New” List Price

Be sure and subtract previous new price






Results final price l.jpg
RESULTS: Final Price

This is the Final price the buyer has to pay after a 20/10/10 trade discount series


ad