- Original Poster
- #1
I'm having a few problems calculating my profit/loss per unit when adding P&P into the mix.
From doing my own research I can see that P&P is a bit of a nightmare for any new e-commerce business, so I was hoping to find out if anyone knew any tricks of the trade or could offer some advice...
The items I will be selling range in weight and size from 80g up to 15kg, so it's quite difficult to find a one-size-fits-all solution.
I've created a spreadsheet on excel that allows me to see how much profit I would make on each unit through various scenarios. However, when it comes to the awkward heavier items, I seem to face a bit of a dilemma. To give you an example...
I have decided upon a set charge of £3.95 regardless of size etc to keep up with competitors.
One item has a weight of 6kg, a profit of 0.50p per individual unit sold and a P&P cost of £5.28. However, if a customer then decides to purchase 2 of this item, my profit then drops down to 0.16p per unit because of the change in P&P costs.
The total weight of the order then goes up to 12kg, which in turn raises the P&P cost to £7.28.
Obviously because I have a set P&P charge this extra cost isn't covered, so that extra £2 change takes a hit on my profit per unit and I end up losing 0.33p.
Is this type of thing normal? Or should I be looking for a better solution? The worrying thing is, I have played around with various figures and actually found that I end up making a loss on some combinations of items within one order, despite ensuring that I make a minimum of 0.50p profit on each individual unit...
I think it's bothering me because I always see promotions by competitors encouraging customers to purchase 2 of the same item. Yet in the above example, I would end up losing more money than if they just purchased one... So I feel like I must be going wrong somewhere...
Any advice would be greatly appreciated!
From doing my own research I can see that P&P is a bit of a nightmare for any new e-commerce business, so I was hoping to find out if anyone knew any tricks of the trade or could offer some advice...
The items I will be selling range in weight and size from 80g up to 15kg, so it's quite difficult to find a one-size-fits-all solution.
I've created a spreadsheet on excel that allows me to see how much profit I would make on each unit through various scenarios. However, when it comes to the awkward heavier items, I seem to face a bit of a dilemma. To give you an example...
I have decided upon a set charge of £3.95 regardless of size etc to keep up with competitors.
One item has a weight of 6kg, a profit of 0.50p per individual unit sold and a P&P cost of £5.28. However, if a customer then decides to purchase 2 of this item, my profit then drops down to 0.16p per unit because of the change in P&P costs.
The total weight of the order then goes up to 12kg, which in turn raises the P&P cost to £7.28.
Obviously because I have a set P&P charge this extra cost isn't covered, so that extra £2 change takes a hit on my profit per unit and I end up losing 0.33p.
Is this type of thing normal? Or should I be looking for a better solution? The worrying thing is, I have played around with various figures and actually found that I end up making a loss on some combinations of items within one order, despite ensuring that I make a minimum of 0.50p profit on each individual unit...
I think it's bothering me because I always see promotions by competitors encouraging customers to purchase 2 of the same item. Yet in the above example, I would end up losing more money than if they just purchased one... So I feel like I must be going wrong somewhere...
Any advice would be greatly appreciated!