Consolidated Actual Cost

The Consolidated Actual Cost report is used to review actual cost details for all products at all locations in the selected hierarchy that are associated with the "Cost of Goods Sold" P&L Grouping and that have "Actual" costs and/or a Beginning or Ending Inventory value that is represented in any of the transactions used to calculate Actual or Theoretical Costs. The “Actual” cost refers to the value of the inventory that the locations used over the post period(s) being viewed.

Menu Paths: Net-Chef > Inventory: Reports > Consolidated Actual Cost
Menu Paths: Net-Chef > Reports: Inventory > Consolidated Actual Cost

Transactions Included: Vendor Orders, Vendor Returns, Commissary/Customer Orders, Purchases by Invoice, Location Transfers, Inventory Adjustments, Recipe Adjustments, Production, Daily Prep, POS Depletion, Buffet Consumption, Inventory Variances

Report Controls

From/To: Drop-downs; can select Post Period dates

Hierarchy: Select the desired hierarchy level from the drop-down

View By: Value (in Location currency), Quantity (in inventory units), Custom (user-selected columns; default)

Group By: Category, Subcategory, Microcategory, GL Code/Description, P&L Substructure

Funnel (Filters): Any report column; P&L Substructure, GL Code/Description, Category/Subcategory/Microcategory

Printer (Export): PDF, Excel, CSV formats

Report Columns (default view):

Click any column header to sort by the data in that column

Product Number – To the left of each number is an expander control [>]. When clicked, this control will display location-specific details for the selected product just below the product line; these values will appear in italics.
Product Name – The company product name.
Inventory Unit – The company product inventory unit.
Value/Qty Beginning – The inventory of the product on the Begin Date.
Value/Qty Purchase – The total of all Purchases for the product within the dates retrieved.
Value/Qty Production – The total of Production for recipes flagged as an "A/T Cost Item".
Value/Qty Transfers Out – The total of all outgoing Location Transfers for the product .
Value/Qty Prod. Cons. Reversal – For the components of recipes flagged as an "A/T Cost Item", the component costs/quantities that are backed out of the Actual (since they are part of the "Value/Qty Production" for the recipe item).
Value/Qty Ending – The inventory for the product on the End Date.
Actual Cost/Qty Used = [ Beginning + Purchase + Production - Transfers Out – Prod. Cons. Reversal – Ending ]
Value/Qty Inv. Adj. – The total of all Inventory Adjustments for the product.
Value/Qty Inv. Variance – The total of all Inventory Variances for the product.

Additional Columns (hidden by default):

Value/Qty Sales – The total cost/quantity of the product directly sold based on sales-related depletion.
Value/Qty Net Inventory – The total Ending Inventory amount based on sales-related depletion.