Sunday, April 01, 2007

Calculating Discounts Part 2

I solved the problem in my Calculating Discounts post. Here is how it is done.
Variables
ItemPrice = 50.00
Discount = 14.49%

Calculate Discount Value (DisValue)
DisValue = ItemPrice * (Discount/100)
DisValue = 50.00 * (14.49/100)
DisValue = 50.00 * 0.1449
DisValue = 7.245

Calculate NewPrice
NewPrice = ItemPrice - DisValue
NewPrice = 50.00 - 7.245
NewPrice = 42.755

Round Down Values
NewPrice = 42.75
DisValue = 7.24
PriceDown = 49.99

Calculate CheckTotal
CheckTotal = NewPrice + DisValue
CheckTotal = 42.75 + 7.24
CheckTotal = 49.99

Calculate Missing Value
MissValue = ItemPrice - CheckTotal
MissValue = 50.00 - CheckTotal
MissValue = 0.01

Add Missing Discount
DisValue = DisValue + MissValue
DisValue = 7.25
Now the both the new price and the discount value will add up to the original price.