Results 1 to 11 of 11

Thread: RESOLVED - Math Question (Discounts and such)

Threaded View

  1. #1

    Thread Starter
    PowerPoster BruceG's Avatar
    Join Date
    May 2000
    Location
    New Jersey (USA)
    Posts
    2,657

    Resolved RESOLVED - Math Question (Discounts and such)

    Hello all,
    This pertains to processing sales orders for a retailer.
    A dollar or percentage discount can be given to an individual item in an order.
    On top of that, a percentage discount can be given to the order as a whole (in which case, this percentage off is applied to each individual item in the order).

    Let's say an item costing $100 is discounted $20. So the price of the item at this point is now $80.
    At the end of the sale, a 30% overall discount is applied to the order. So now 30% off of the $80 (not $100) is taken for the item described above, thus discounting the item $24 more.
    So the total amount off of the item is $44, and the customer pays $56 for that item.

    Now - if at some later time, we wanted to look at data to reconstruct what happened on that sale, would it be possible to do so given only these three pieces of information:
    Regular Price of Item = $100
    Total Amount Off = $44
    Order Level Discount = 30%

    In other words, is there an equation that can be used to determine what portion of the $44 was a result of the 30% discount, and portion was the dollar discount?
    Last edited by BruceG; Apr 14th, 2014 at 10:19 AM. Reason: resolved
    "It's cold gin time again ..."

    Check out my website here.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width