Cost Summary by Ops Group compares your cost versus your sales for specific periods of time dictated by audits, based on your Ops Group mappings.
The Cost Summary by Ops Group report calculates the Cost % for an audit period based on the Cost vs Sales data received.
Cost is calculated by taking the starting value and adding the purchases value in. Then, either adding or subtracting the transfer value (depending on if the value is positive or negative) and finally, subtracting the end value.
Sales is calculated based on the sales data received from the POS system integrated with your account.
All of the columns and their values are displayed based on you Ops Group Mappings.
Ops Group: The Ops Group associated with the data displayed based on your Ops Group Mapping section.
Category: All Categories mapped to the Ops Group based off of the Ops Group Mapping section.
Subcategory: The Subcategory associated with the Category.
Start: Value for your starting inventory for the audit period being run.
Purchases: Cost of inventory received (theoretically) within invoices during the audit period.
Transfers: Value of inventory transferred in/out during the period.
End: Value of your ending inventory for the audit period selected.
Cost: Start + Purchase +/- Transfers - End
Sales: Selling value of the inventory sold during the period based on data received from the POS system
Cost %: Cost / Sales