![]() The Display of Quantities options cover how sales quantities are shown on the reports : Selling Units - Tots or Pints - e.g. 28, for a full 70cl bottle of spirits Count Units - Bottles or Gallons - e.g. 1, for a full bottle Combination - Bottles and Tots - e.g. 2.14, for 1.5 70cl bottles of spirits Millilitres - Some bars doing cocktails have recipes measured out in millilitres
The Display Options box gives you : Blank Zeros - Any quantity with a value of zero will not be shown Use Colour - Some figures, e.g. variance, can be negative. These can be shown in red. Sub-Products - Multiple products on the same PLU number can be shown, or not. Use Av Price - The variance @ retail figure can be calculated using the average price or the selling price.
|
This simplified report lists all of the PLU Numbers that you have set up and shows the Sales, Allowances, Consumed and Variance figures in both quantity and retail values.
The quantity and retail variance figures are calculated independently of each other. On the main Till Check screen, you do not have to have both quantity and value figures entered, and the variance report allows for this.
If you are using multiple price bands or recipes, instead of the Variance by PLU report, you should use the Variance by Product report as that will take into account the varying prices of products.
The detailed variance report brings into play all sales of individual products and recipes, in all price bands.
The average sales price for each product has been calculated and is then multiplied by the Variance Quantity figure to give the Variance at Retail.
This report simply shows the sales quantities of each product in each band, allowing you to compare sales in different bands.
For a multi-bar outlet, this report shows the sales quantities in each bar, allowing a comparison.
This report will show the sales in the current audit and the sales in the last audit, for each band.
When more than one price band is used, it is essential that the difference in retail income is known. The columns for bands 2-6 show the amount of money that has been taken, more or less, than would have been taken had those sales been in band 1.
As the main Summary report is all calculated at the standard selling price (normally band 1), and these variances must be put in as an allowance.
Example : A pint of beer is priced at £4.00 in the bar, but at £4.50 in the function room. If there are sales of 20 pints in the function room, then £10.00 (20 x £0.50) extra money would have been taken. This would need to go in as an allowance of £-10.00.
The report calculates the figures for each product and adds them up for each section and overall. If you select an allowance in the drop-down box, the total figure will be automatically inserted into that figure on the allowances screen.
When recipes are used, it is essential that the variance in retail income is known. The columns for bands 2-6 show the amount of money that has been taken, more or less, than would have been taken had the ingredients of the recipes been sold as individual products, at the standard selling price.
As the main Summary report is all calculated at the standard selling price (normally band 1), these variances must be put in as an allowance.
Example : A pint of beer is priced at £4.00, a half pint of lemonade is £1.40 and a pint of shandy is £4.00. If there are sales of 20 pints, then £2.00 (20 x £0.10) extra money would have been taken.
Standard price of half pint of beer £2.00
Standard price of half pint of lemonade £1.40
Total £3.90
Variance to Pint of shandy (£4.00) £0.10
This would need to go in as an allowance of £-2.00.
The report calculates the figures for each recipe and adds them up for each section and overall. If you select an allowance in the drop-down box, the total figure will be automatically inserted into that figure on the allowances screen.
Sometimes, your client might want separate allowances to be used for different recipe types, e.g. cocktails, wine by the glass, etc. If this is the case, you will need to add up the different variances and apply them manually to each allowance.
Instead of using recipes and/or price bands, some tills will give you a total value for each product, irrespective of how that product has been sold, e.g. pints, halves, shandies. The till information should include both a quantity of sales and a value and this results in an average price per pint.
In a similar manner to price bands and recipes above, a variance must be applied as an allowance so that extra (or less) takings are included in the summary report.
Example : A pint of beer is priced at £4.00 in the bar, but at £4.20 in the function room, and is also used in shandies. The till roll shows that the total quantity sold is 50 pints for a total value of £218.30.
Had those 50 pints all been sold in the bar, the income would have been £150.00. So, there is a variance of £18.30 and this would go in as an allowance of £-18.30.
The report calculates the figures for each product and adds them up for each section and overall. If you select an allowance in the drop-down box, the total figure will be automatically inserted into that figure on the allowances screen.
An alternative to using this report is to select the products that are being 'averaged'. On the main Till Check window, you can tick the box to 'Use Till' for e.g. lemonade, beers, etc. For those products that are ticked, the average price (based on quantity and value of the till figures) will be used instead of the band price to calculate the variance at retail.