P692 TELETEXT-TOOLS 692 Thu 12 Feb
00:00/00 PAGE ___
TELETEXT-TOOLS
BEST BUY
UNIT COST / BEST BUY
Compare price ÷ quantity to find the cheapest
Lowest unit cost winsNO SCROLL
DISPLAY AS
/100
For easy comparison
QTY LABEL
g
Same unit for all options
OPTION A
£1.20 / 300
PRICE £
£
QTY
g
OPTION B
£0.95 / 250
PRICE £
£
QTY
g
OPTION C
£1.70 / 500
PRICE £
£
QTY
g
ROUNDING
2DP
For unit cost
TIP
0
Set any QTY to 0 to ignore it
All quantities must be same unit
WORKING
BEST BUY
READY
PAGE 1/2
DISPLAY AS
/100
For easy comparison
QTY LABEL
g
Same unit for all options
OPTION A
£1.20 / 300
PRICE £
£
QTY
g
OPTION B
£0.95 / 250
PRICE £
£
QTY
g
OPTION C
£1.70 / 500
PRICE £
£
QTY
g
ROUNDING
2DP
For unit cost
TIP
0
Set any QTY to 0 to ignore it
All quantities must be same unit
WORKING
BEST BUY
READY
PAGE 1/2
HOW TO USE
1) Enter a unit label (e.g. g)
2) Enter price + qty for each option
3) Choose DISPLAY AS (e.g. /100)
4) Press SOLVE
FORMULA
unit cost = price ÷ qty
display = unit cost × basis
Lowest display cost wins
WORKED EXAMPLE
A: £1.20 ÷ 300 = £0.004
/100 → £0.40 per 100g
NOTES
All qty must use same unit
Use qty 0 to ignore an option
If all qty are 0 → ERROR
PAGE 2/2