|
-
Apr 14th, 2014, 08:51 AM
#1
Thread Starter
PowerPoster
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|