This report is found on the Inventory tab of the FOOD-TRAK Reports menu. It will include items for any single Stand and comes in a detailed format, a summary, or both. The summary report can be broken down by Inventory Location, item, as well as by Profit Center and Report Group.
The report wizard gives you the option of selecting a single Stand to include on the report.
Next, you have the option of including data from either the most recent Stand Sheets entered into FOOD-TRAK, or you can select a range of Stand Sheets (entered by date).
The wizard then allows you to select any or all of the following formats:
a fully detailed report,
a summary by Inventory Location,
a summary by Profit Center and Report Group, and
a summary by item.
The detailed report includes items in a particular Inventory Location if the item is included in the beginning inventory of the Stand Sheet and included in its ending inventory, or has a non-zero value in any transaction column. It lists the Item Name, Report Group, Inventory Unit, the Beginning Inventory (based on the first inventory or Stand Sheet selected), and the Inventory Cost. The detail then lists all purchases occurring within the selected range, transfers in and out of the Stand, waste, last cost (i.e. price at last purchase), the ending Inventory and Cost, usage data, Selling ) Price and Sales.
The Sales column is calculated from the Usage Quantity (which is in turn the sum of the beginning inventory, transfers in and out, and waste minus the ending inventory) times the Selling Price. It represents the ideal cash taken in by the Stand during the business event.
The summary reports available are sorted by Inventory Location, Profit Center and Report Group, and by Item. They all display the Beginning and Ending Inventory Cost, Usage Cost, and Sales.