I'm working on some retail software, for trade use. It lists a catalogue of items and the prices that the retailer should be selling them for.
Occasionally, however, the retail price in the system turns out to be lower than the cost price for an item. So if the retailer used that price, they'd be making a loss. In this situation the price needs to be replaced with another (higher) one.
e.g.
Apples 53p
Oranges 61p
Bananas 20p <- This is too low, so gets replaced by the cost value plus 5%
So my question is, how should I succinctly but clearly denote that a price has been "replaced".
Here are my ideas:
- Use a strikethrough. e.g. bananas
20p32p - Use a plus symbol e.g. bananas +32p
- Use an asterisk, with an explanation below e.g. bananas 32p* *This price has been replaced with cost price + 5%
- Use a triangle in the corner of the cell, like excel does.
I'd favour No1, except that it gets a bit political if both prices get shown, so management don't like it.
Which of these ideas is preferable, or is there a better way?