Consolidated Inventory Efficiency

The Consolidated Inventory Efficiency report displays inventory data per location, adding up the information from each location within the selected hierarchy. This report shows a 30-day summary of product consumption value for each location product, as well as the current on-hand value, the estimated days the current on-hand should last, and the sum of all inventory value variances.

Menu Paths: Net-Chef > Inventory: Reports > Consolidated Inventory Efficiency
Menu Paths: Net-Chef > Reports: Inventory > Consolidated Inventory Efficiency

Transactions Included: Posted Inventory

Report Controls

Post Date: Drop-down; can select Post Period dates or the current date.

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

Funnel (Filters): Any report column

Printer (Export): PDF, Excel, CSV formats

-><- , <-->: Click to minimize/maximize the report header

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.
Total On Hand Value – the sum of On Hand Values for all locations included in the report.
Total 30 Day Consumption Value – the sum of the 30 Day Consumption Values for all locations included in the report where:

30 Day Consumption Value = [ Beginning Inventory Value + Receiving Value – Ending Inventory Value – Reconciled Outgoing Transfers Value - Picklisted Values for Posted Production ]

Days On Hand = [ (Total On Hand Value ÷ Total 30 Day Consumption Value) x (# of Days in 30 Day Consumption period) ] where:

The number of days in the 30 Day Consumption period includes the beginning and ending date. This period must be calculated for each product, as it may be different based on how long each product has been in inventory.

Accumulated Inventory Variance Value – The sum of all variance values for all posted periods in the 30 Day Consumption period.
Variance % = [ (Accumulated Inv. Variance Value ÷ Total 30 Day Consumption Value) x 100 ]

“Drill Down” Links:

Location Name – Opens a report with subtotals by product for the selected location; equivalent of the Inventory Efficiency report for that location.
Grand Total label – Opens a report with subtotals by product for all locations.