Consolidated Actual/Theoretical Cost

The Consolidated Actual/Theoretical Cost report compares actual and theoretical costs at each physical location within the selected hierarchy, for all products associated with the “Cost of Goods Sold” P&L Grouping. The “Actual” cost refers to the value of the inventory that the locations used over the post period(s) being viewed; The “Theoretical” cost of goods sold refers to the cost of the products and recipes (based on the component products) that were sold according to the point-of-sale system.

The report will also notify the user if data could not be retrieved for certain locations within the selected hierarchy and date range. Any location that is not eligible for display will be listed beneath the “Grand Total” row and will include the reason for the exclusion in parentheses following the location name.

Menu Paths: Net-Chef > Inventory: Reports > Consolidated Actual/Theoretical Cost
Menu Paths: Net-Chef > Reports: Inventory > Consolidated Actual/Theoretical 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

Search field: Enter the P&L Substructure or GL Code/Description you want to locate

Funnel (Filters): Any report column

Printer (Export): PDF, Excel, CSV formats

Note: Locations within the selected Hierarchy that have no relevant data (even if it is all of them), will be listed in the "Exceptions" section at the bottom of the screen. When there are no physical locations associated with the selected Hierarchy, the report will display a "No Data" message and the Export control will be disabled.

Report Columns:

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

Location Code – The code for the location.
Location Name – The name of the location; “Drill Down” link; see below for details.
Net Sales = [ (Sum of Sales Totals – "Sales" Comps & Discounts) from the Sales Transactions screen + total value of reconciled outgoing Commissary/Customer orders ]. Sales from Commissary/Customer orders include products linked to both "Sales" GL accounts and accounts with "GL for Sales" set up.
Total Cost of Goods Sold = [ Beginning + Purchases + Production - Transfers Out – Production Consumption Reversal – Ending ]
CGS % = [ (Total CGS ÷ Net Sales) x 100 ]
Theoretical Value – Total cost of recipe components and "A/T Cost Item" recipes sold through the POS interface or via Commissary/Customer Order.
Theoretical % = [ (Theoretical Value ÷ Net Sales) x 100 ]
Variance Value = [ Theoretical Value – Total Cost of Goods Sold ]
Variance % = [ (Variance Value ÷ Net Sales) x 100 ]
Logged Waste Value – Total cost of inventory and recipe adjustment transactions.
Logged Waste % = [ (Adjustment Value ÷ Sales for GL) x 100 ]
A vs T % (hidden by default) = [ (Variance Value ÷ Theoretical Value) x 100 ]

Note: The values in this report are expressed in the location’s base currency.

“Drill Down” Links:

Location Name – Opens a sub-report with totals by GL Account and subtotals by P&L Substructure for costs at the selected location; equivalent of the Actual/Theoretical Cost report for that location.
Grand Total – Opens a sub-report with totals by GL Account and subtotals by P&L Substructure for costs at all locations within the selected hierarchy.