Explaining the Theoretical Margin report

The Theoretical Margin report is to be used to show you a variance between your theoretical margin and your actual margin.

The Net sales is the total value of your sales that have been passed from your epos to IndiCater.

The Theoretical Cost of Sales is a calculation based on those sales and the cost per portion of each dish in Recipe Manager.

The Actual Cost of Sales is your opening stock, plus purchases, plus/minus stock transfers and minus your closing stock.

The date picker gives you the option to either use your last 2 stocktakes as the opening and closing counts, or to pick an earlier stocktake as the opening count and look at a longer period.

The assumption is made that the stocktake is recorded at the end of the day so if the opening stocktake is dated the 1st January, the purchases, sales etc are included from the 2nd. If the stocktake is started on the 1st and runs past midnight, the user should ensure they are amending the date to be the 1st to ensure transactions from the 2nd are included in the reports.

Stocktakes in an outlet should be recorded on the same day. If a product is in multiple stock takes all counted on different days we can’t provide any useful data as there is no one start date.

The report should be run in line with your stocktakes, so if you record a monthly stocktake, you can’t get data for a week as we need to look at the stock movement between 2 stocktakes.

Purchases are only counted in the period the user has booked off the order. If the order was due for delivery on the 1st, the closing stock recorded on the 5th and the order booked off on the 10th, it won’t be included as a purchase. It will be included in the following period.

The categorisation is dependant on the KPI category setting in the income and purchasing categories.

The Variance % calculation is = Variance Value as a % of the Theoretical GP