Actual/Theoretical Cost

The Actual/Theoretical Cost report is used to review and compare a location’s actual and theoretical costs, for all products associated with the "Cost of Goods Sold" P&L Grouping. The "Actual" cost refers to the value of the inventory the location used over the post period(s) being viewed. The "Theoretical" cost of goods sold refers to the cost of the items and recipe components sold, according to the POS system or via Commissary/Customer Order. The report also shows the variance between actual and theoretical, and shows the total variance as a percentage of net sales.

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

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

Header Totals:

Total Net Sales = [ (Sum of Sales Totals – "Sales" Comps & Discounts) from the Enter 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" defined.
Total Cost of Goods Sold – Displays the Total Cost of Goods Sold value from the "Actual Value" column.
Cost % = [ Total Cost of Goods Sold ÷ Total Net Sales ]

Report Columns:

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

P&L Substructure – The substructure with which the GL Accounts in that section are associated.
GL Code/Description – The GL Accounts for the associated costs; “Drill Down” link; see below for details.
Actual Value = [ Beginning + Purchases + Production - Transfers Out – Production Consumption Reversal – Ending ]
Actual % = [ (Actual Value ÷ Sales for GL) x 100 ]
Theoretical Value – Total cost of recipe components and "A/T Cost Item" recipes sold via POS Depletion or Commissary/Customer Orders.
Theoretical % = [ (Theoretical Value ÷ Sales for GL) x 100 ]
Variance Value = [ Theoretical Value – Actual Value ]
Variance % = [ (Variance Value ÷ Sales for GL) 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 "Sales for GL" values used in the percentage calculations above are determined based on the "Sales" GL account linked to that account in the View/Edit Budget Data screen; uses P&L Subtotal if no Sales account is linked.

“Drill Down” Links:

Each of the following hyperlinks opens a Product Detail sub-report.

GL Code/Description – Opens a sub-report with costs for all products at the location that are associated with that GL account.
P&L Substructure Total – Opens a sub-report with costs for all products at the location that are associated with that P&L Substructure.
Total Cost of Goods Sold – Opens a sub-report with costs for all products at the location that are associated with the “Cost of Goods Sold” P&L Grouping.

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