Inventory analytics

Analyzing inventory analytics is crucial for efficient business operations and maintaining optimal stock levels. Our reports help you keep track of inventory, forecast sales, and make informed purchasing decisions.

Net Sales Forecast by Product Type

The "Net Sales Forecast by Product Type" report is generated using our advanced forecasting function, which analyses sales history from the past three years. For more information about our forecasting methodology, click here. This report includes:

•     Forecast: Predicted sales.

•     Week Ending: The end date of the week for which sales are forecast.

•     Product Type: The type of product being forecast.

Purchase Planner

The "Purchase Planner" report simplifies inventory purchasing by considering multiple factors such as sales data, inventory levels, items, and product types. Using our forecasting tool, we calculate demand for the next week, the needed amount, the optimal intake, and the cost of optimal intake. This report includes:

•     Product Title: The name of the item, ranked by sales.

•     Variant Title: The variant or option of the product.

•     SKU: Stock-keeping unit, a unique identifier depicted as a machine-readable barcode.

•     Product Type: The category of the product.

•     Vendor: The supplier of the product.

•     Sales Units: The number of units sold.

•     Orders: The number of orders for the product.

•     Current Stock: The current inventory level of the product.

•     Demand Forecast (1 Week): The predicted demand for the next week.

•     Need: The required quantity to meet the forecast demand.

•     Optimal Intake: The optimal quantity to be purchased.

•     Intake Budget: The cost associated with the optimal intake.

Product Profitability

The "Product Profitability" report identifies the items in your inventory that yield the highest profit. This report includes:

•     Product Title: The name of the item, ranked by average cost.

•     Average Cost: The cost of the inventory by product title and its age.

•     Net Sales: The total monetary value of sales.

•     Cost of Sales: The cost involved in selling the product.

•     Sales Profit: The net profit from sales.

•     Units Sold: The quantity of units sold.

•     Number of Orders Including This Item: The number of orders that include the product.

•     Inventory Turn: The rate at which inventory is sold and replaced.

•     Inventory Days: The number of days the inventory remains in stock.

•     GMROI: Gross Margin Return on Investment.

•     Last Sold: The date the product was last sold.

•     Variants: Different versions or options of the product.

Profitability by Product Type

The "Profitability by Product Type" report is similar to the Product Profitability report but groups items by their larger product type category. This report includes:

•     Product Type: The category of the product.

•     Line Item Net: The monetary value of product sales.

•     Cost of Sales: The cost involved in selling the product or service.

•     Sales Profit: The net profit from sales.

•     Units Sold: The quantity of units sold.

•     Number of Orders with Items of This Type: The number of orders that include products of this type.

•     Inventory Turn: The rate at which inventory is sold and replaced.

•     Inventory Days: The number of days the inventory remains in stock.

•     GMROI: Gross Margin Return on Investment.

•     Average Cost: The average cost of the inventory for this product type.

Profitability by Vendor

The "Profitability by Vendor" report ranks the profitability of your suppliers, providing essential insights into which vendors contribute most to your bottom line. This report includes:

•     Vendor: The name of the supplier.

•     Net Sales: The total monetary value of sales attributed to the vendor.

•     Sales Profit: The net profit from sales of products supplied by the vendor.

•     Cost of Sales: The cost involved in selling the products from the vendor.

•     Units Sold: The number of units sold from the vendor.

•     Number of Orders with Items from This Vendor: The total number of orders that include products from the vendor.

•     Inventory Turn: The rate at which inventory supplied by the vendor is sold and replaced.

•     Inventory Days: The number of days the inventory from the vendor remains in stock.

•     GMROI: Gross Margin Return on Investment, measuring the profitability of inventory supplied by the vendor.

•     Number of Products: The total number of different products supplied by the vendor.

•     Number of Variants: The total number of different variants or versions of products supplied by the vendor.