Inventory Efficiency and Inactivity

The Inventory Efficiency and Inactivity report will identify which products are the slowest to be used. The report will display the list of products currently in inventory and show when each product was last received and issued by the location, and the number of days since it was last received. It will also show the product's projected number of days on hand (which refers to how many days the current amount will last based on historical consumption), the daily consumption rate, and each product's unit price, and on hand and ending value.

Menu Paths: Net-Chef > Inventory: Reports > Inventory Efficiency and Inactivity
Menu Paths: Net-Chef > Reports: Inventory > Inventory Efficiency and Inactivity

Transactions Included: Vendor Orders, Final Reconciled Commissary or Warehouse Orders, Customer Orders to non-Internal Customers, Inventory, Production Depletion, POS Depletion, Buffet Consumption

Report Controls

Location: (Cruise, Corporate only) – Select the desired location from the drop-down

Group By: N/A (default), Bid Sheet, Category, GL, Market Master Status, Microcategory, Product, Product Type, Storage Group (if applicable), Storage Location, Storage Type, Subcategory

Summarize: N/A, Product (default)

Period: Current Month, Current Week, Day, Period, Post

Date widget(s): Selector varies based on the chosen Period

Include Inventory Data in Report Range Based on: Begin Date, Post Date, Cruise End Date (Cruise only)

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. {Note}: Values in this report are expressed in the Location’s base currency.

Product Number – The company product number.
Product Name – The company product name.
Inv. Unit – The company product inventory unit.
Storage Location – The storage location for this location/product/lot combination.
Unit Price – The location product’s Issue Cost OR Inventory Cost, depending on whether the retrieval End Date includes the current date; see note below.
Qty On Hand/Ending – The On Hand OR Ending quantity for the location/product/storage combination; see note below.
Value On Hand/Ending = [ Qty On Hand OR Ending x Unit Price ]; see note below.
Daily Consumption Rate = [ Qty On Hand OR Ending ÷ Days to Consume On Hand ]; see note below.
Days to Consume On Hand = [ Product Consumption ÷ Number of Days in the Retrieval Range ]

Product Consumption = [ Reconciled Customer Orders to non-internal customers + POS Depletion + Production Depletion + Final Reconciled Outgoing Commissary or Warehouse Orders ] during all applicable periods.

Beginning – The quantity on hand at the beginning of the first post period in selected date range.
Received – Includes all reconciled incoming orders, finalized daily prep, incoming location transfers, vendor returns (which reduce incoming vendor orders).
Issued – Includes reconciled outgoing customer, warehouse, and commissary orders.
Inventory Adjusted – Includes inventory adjustments, buffet consumption & waste, mid-period variances, production depletion, outgoing location transfers, incoming/outgoing storage transfers.
Issues Adjusted – The quantity or value "received" by internal customers. These issues are removed from central storage but remain in the location’s inventory; they are added to and counted in the internal customer’s storage location.
(Qty) On Vendor Order – The sum of the quantities on vendor orders with a status of Submitted or Invoiced during all applicable periods.
(Qty) In Transit – The sum of the quantities on warehouse and commissary orders with a status of Invoiced or Physical Reconciled.
Last Issue Date – The date the product was last issued via customer order, warehouse order, or commissary order.
Last Received Date – The date the product was last received at the location.
Days Since Received = ["Date To" Retrieval Date – Last Received Date ]

Note: When the selected dates include the current date, the columns noted above will display/use the "On Hand" amounts and the current Issue Cost; when the selected dates are prior to the current date, these columns will display/use the "Ending" amounts and the Inventory Cost for the last posted period in the range.

Additional Columns:

Visible only if at least one location included in the retrieval set has these features enabled.

Storage Group (if applicable) – The storage group to which the product's storage location belongs.
Lot # (if applicable) – The lot number for this product/storage/lot combination.

Note: The "Storage Group" and "Lot #" columns will be visible only if the location has these features enabled.