How to Calculate BO-GO for the Books and Returns

Buy on get one free promotions - calculating for the books...“Buy-one-get-one free of equal or lesser value” is a promotional tactic used by many retailers. I recently used it in a promotion and we had to develop a way to insert these transactions into the books and calculate returns if needed.

After coming up with the algorithm, I thought it might interest other business owners/ merchandisers running the same type of promotion:

To calculate the sale, you need to take into account the percentage off each pair of products bought. Make the total of each pair and then find the percentage off each of the items.

For example: a customer buys 6 products.

  1. Item 1:$69.50
  2. Item 2:$44.50
  3. Item 3:$129.00
  4. Item 4:$106.00
  5. Item 5:$178.00
  6. Item 6:$166.00

The total cost: $693.00
To calculate the discount you need to sort the Items by price:

  1. Item 2:$44.50
  2. Item 1:$69.50
  3. Item 4:$106.00
  4. Item 3:$129.00
  5. Item 6:$166.00
  6. Item 5:$178.00

Then you can see that the total discount would be the $44.50+$106.00+$166.00 = $316.50 So the total transaction would be: $376.50

However, what happens in the books? what would happen if the customer chooses to return item #3? What should he be reimbursed?

To calculate you should have your POS configured for such a promotion. If you have your own in house POS, then you need to insert the following algorithm:

You need to calculate the individual discount for each item in the list.
To do so, you need to pair up again and find the percentage off each items of the pairs.
Continue reading “How to Calculate BO-GO for the Books and Returns”