Tips

These Reports answer the following questions: "How many chicken breasts did I use last week?", "I sold 200 side salads, how much lettuce should I have gone through?" and "Have my cooks and servers been serving the correct amounts?"

Inventory Reports: Usage

Usage Reports show what Inventory and Prep Recipes were used and should have been used over a certain time period.  The Reports will show the difference or variance between those two numbers.  Fixing the variances delivers dollars that flow directly to your bottom line.  CostGuard’s Usage Reports shows you where the problem areas are, so you can investigate them and fix the issues.

 

Actual Reports also show your costs of running your operation over time.  You can use this report to explain your Income Statement.

 

Use Usage Reports to watch for such problems as theft, incorrect portioning sizes, or incorrect recipe amounts.  The Usage Variance Report details areas that you need to investigate. 

 

Any Inventory Items highlighted on the Variance Report are discrepancies.  Print out the Report, and then start investigating.  You need to double check adherence to recipes, especially quantities used, and serving sizes.  You may also want to check spoilage and waste on perishable items.  If one of those four areas cannot explain them, you will need to check for theft.

 

You can choose how you want the information sorted on these reports. For the top half, unchecking the box and click select will allow you to choose specific Inventory items.  For the lower box, click one of the buttons to sort alphabetically, by SuperGroup or by Group.  This option allows you to customize reports to focus on your high-volume, high-profit, or high-cost items.

 

 

Because Usage Reports are generated for a time period, you need to select the dates.  You can click one of the preset buttons for the reporting period.  The default setting is the Custom button, which will activate the bottom Date Range fields.  CostGuard uses the chosen dates as brackets to calculate usage.  CostGuard will search forward starting with the day before your “from” date and backwards from your “to” date.  It uses Counts and Transactions that you created during that time to generate the reports.   To enter in the dates, you can type in the date or click the at the end of the date line.  The date popup will appear.  Today’s date is blue with a red circle around it.  If you want today, then click the circle to enter it.  To choose another date in this month, then move your cursor to that date and click on it.  To go to a previous month, click  button.  Keep clicking this button until you get to the month that you want. Today’s date, or if you highlighted another date will still be blue in that previous month.  Because of the nature of this report, you should not enter in a date that is in the future.  The reports will not work.

 

 

 

Actual Usage

This Report details each Inventory Item and Prep Recipe.  The simple formula is:

 

Opening Inventory + Purchases – Closing Inventory = Actual Usage.  It starts with the day before your “from” date (that is, the previous period’s closing count).  When CostGuard finds a count, it automatically becomes the opening count.  Then it adds purchases, transfers received, positive adjustments, and prep builds.  It then subtracts negative adjustments and the count closest to your “to” date.  The last two columns detail the Food Cost Percentage for the Group and Overall for this item.  You can select and sort for specific Inventory items. Use this report to determine how much product went through your establishment; it is the actual cost of running your operation for the period of time you specify.  The final number or usage, should match the ideal usage shown in the next report.

 

 

What if the numbers do not look right? Then check the following:

1.       Printout the corresponding Journals: the Actual Inventory Journal and the Inventory Directory.  Check the incoming transfers, adjustments, and receipts.  Double check the Journal report against original documentation such as invoices to make sure you entered them.  If you are missing a transaction, you can enter it with the correct date; just make sure that you date your usage report one day later.

2.       Check the Actual Inventory Journal to confirm that there are two counts (opening and closing) during the reporting period.  Remember to pick the day before your last count as the “from” date, since that what the Usage Report does.  The Usage calculation MUST find two counts, otherwise usage can’t be calculated.

3.       If you are comparing reports with different sort criteria, for example alphabetical against group totals, then the information may not match exactly.  Check to see that all inventory items have group, vendor, and location information to make the totals match.

4.       If the purchase totals don’t look right, that may be because only purchases that occur within the period between the opening and closing counts are included. This report may therefore not show you all your purchases in the reporting period specified.

5.       If a count is wrong, you can change or delete the count (link). If other transactions are wrong, there are ways to offset the errors with correcting transactions. Please see explanations with the specific transactions.

After making any corrections, you can simply reprint a report to see the updated results.

Ideal Usage

Ideal Usage Reports show your outgoing Inventory Transactions.  It calculates all depletions from Inventory including Sales, Requisitions, Outgoing Transfers, and the individual components of a Build Recipe.  For further details on this report, use the Ideal Inventory Journal report.  Use this report to check recipe quantities and serving sizes.  You can also use it to justify or reconcile physical counts of Inventory Items.  The final two columns, % of Group and Food Cost %, compare that items food cost percentage to the overall actual Food Cost Percentage.

 

 

What if the numbers do not look right? Then check the following:

1.       Printout the corresponding Journals: the Ideal Inventory Journal and the Inventory Directory.  Double check the Journal report against original documentation to make sure you enter them.  If you are missing a transaction, you can enter it with the correct date; just make sure that you date your usage report one day later.

2.       If you are comparing reports with different sort criteria, for example alphabetical against group totals, then the information may not match exactly.  Check to see that all inventory items have group, vendor, and location information to make the totals match.

 

Usage Variance Report

This Report shows the discrepancies between Actual Usage and Ideal Usage.  This report shows your problem Inventory Items which you need to investigate.  It picks up the numbers from the first two reports, and generates the difference or variance.  You can run this report at any time: you do not need to run the Actual and Ideal first for it to generate.  You can find a similar report in the Alert Report Section.

The report below was sorted by group.  This makes it easier for you to find issues with inventory items.  Look at the rolls.  This is a negative variance where something should have been used, but was not.  The restaurant did not use 5 cases that they should have.  In this instance, some one is either not following recipes, or using the correct portions.

Diced Tomatoes had a positive variance of 28 cases. This means that someone used 28 case more than what they should have.  If you have a positive variance, look for adherence to recipes, portion controls, spoilage, or lack of rotation.  You should also check that the cooks are using diced tomatoes in lieu of another tomato product. This is another variance that needs investigation.

While the examples below may be exaggerated, they show how you can use this report.  Remember that variances are differences from Ideal, and the more that you can find and rectify, the more money is in your pocket.

 

Click here to return to the Inventory Report overview.

Continue regular path