I need some help on costings for sugar sachets, I'l be short and sweet. Sorry, that was bad, I know.
at our restaurant we serve tea, coffee etc with three types of sweeteners, brown sugar, white sugar and canderal, all being different prices. Our magic inventory / pos system does its thing and deducts from each sale, currently we have put all three on the cost for the drinks, eg
Coffee: 19g @ $9.20 per kg = $0.1748 per Drink
Milk: 9ml @ $1.40 per Ltr = $0.1260 per drink
Brown Sugar : 10g @ @3.51 per Kg = $0.035 per drink
White Sugar : 10g @ @2.46 per Kg = $0.024 per drink
Canderal : 1.3g @ @11.3 per Kg = $0.014 per drink
Total cost = $0.38 per serving
So it is deducting all 3 sweeteners from the system.
My boss does not like that, and has tasked me with finding a formula that works, and I am stumped!
I thought of turning them all into one stock item, as a sweetener combining and averaging, but it is not really working and the canderal is only 1.3g.
Any help would be much appreciated.