Variance, Weekly Variance and Cost
Taking all items on the price list and reporting on usages and sales of each item in the standard unit. In this case you cannot change the unit size. Click Calc on each sheet to run the report. This operation does take several minutes to run. The Variance sheet calculates variance for the week and Period Variance for the period to date. Note that there is a Calc button on each sheet. Each Calc button calculates only for the time period on its sheet and only that time period on the Cost sheet. I.e. you must click both buttons to get a complete cost summary.
SORT BY VARIANCE
Sorts report by variance amount from biggest loss to biggest gain
SORT BY NAME
Sorts report alphabetically by item name
PRINT TOP 50
Prints report with only items of variance greater than $50 lost or gained
On the Cost sheet you will see your actual usage, sales and percentage cost. Below that will be an ideal cost based on the sales mix and recipes. If the two percentages are not close you can start to analyse either the actual or the ideal pc.
For the actual pc, start by looking at your ending inventory. Look at your extensions which is the count times the price. Amounts that are too high are easy to spot but amounts that are too low can affect your cost just as much. Adjust any ending counts that are wrong. If the price is wrong take a look at the unit size. Note the spellings in price list discussion above. Any unit not recognized will be taken to be the same as a kilo, litre or each.
If the unit size is right but the price is wrong, do not change the price here, take a look at the item in the price list. (To go to the item in the price list, right click on the name of the item then select Goto This Item.) if the item code is highlighted in blue then the unit size and price were transferred in from an external database. You can make changes to this item but the changes will be wiped out on the next update. You should make a note of the item to correct the database. Any changes to non-highlighted items will be permanent. If you make any changes to the price list you will need to rerun Import Sales to update the ideal PC To analyse the ideal pc, run the Cost Contribution report. It will ask for a category and target PC. Item names highlighted in blue are item with zero cost (i.e. no recipe). If the PC for an item is higher than the target, the PC will be highlighted in yellow, if it is more than 10% higher than the target, it will be highlighted in red. Again it is easier to spot something that is too high than too low. Right click on this item and select Goto this item to take you to the item on the Squirrel sheet. Double click on the item name to bring up the recipe for the item. Refer to the Recipe sheet discussion on how to edit recipes.