Consolidated Cost Analysis

The Consolidated Cost Analysis report provides a detailed record of sales, cost of goods and other costs for all locations within the selected hierarchy. The main report summarizes Net Sales, Guest Counts, and costs associated with the "Cost Of Goods Sold" P&L Grouping. It shows costs as a percentage of sales, and calculates profits over the selected time frame.

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

Transactions Included: Vendor Orders, Vendor Returns, Commissary/Customer Orders, Purchases By Invoice, Location Transfers, Production/Daily Prep, Inventory, Total Sales, Sales Paid Outs, Sales Comps and Discounts

Report Controls

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

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

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 controls will be disabled.

Report Columns:

Click any column header to sort by the data in that column. {Note}: Values in this report are expressed in the location's base currency.

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" defined.
Total Guest Count = The "Ending Guest Count" from the Sales Transactions screen.
Beginning Inventory – Total value on hand at the beginning of the period.
Purchases – Reconciled vendor orders, purchases by invoice, incoming commissary orders and incoming location transfers, sales paid-outs.
Production – Total value of Production for recipes flagged as an "A/T Cost Item".
Transfers Out – Total cost of outgoing location transfers.
Prod. Cons. Reversal – Total value of Production Consumption reversed for components of recipes flagged as an "A/T Cost Item".
Ending Inventory – Total book value on hand at the end of the period; this includes any In Transit (outgoing) products.
COGS (Cost of Goods Sold) = [ Beginning Inventory + Purchases + Production – Transfers Out – Prod. Cons. Reversal – Ending Inventory ]
% of Sales = [ (COGS ÷ Net Sales) x 100 ]
Cost Per Guest = [ COGS ÷ Total Guest Count ]

“Drill Down” Links:

Location Name – Opens a report with sales and cost details for the selected location; equivalent of the Cost Analysis report for that location.
Totals label – Opens a report with sales and cost details for all locations within the selected hierarchy.