Loading ...

Inventory | CLEARIFY


Inventory Overview

Retail Value, Profit Margin
Gross Margin Return on Investment
Inventory Turnover, Average Days to Sell

(QQube with Power BI example)

Inventory Specific Item Analysis

Daily Valuation, Write-Offs, Fill Rate,
Days out of Stock, Average Days to Sell,
Profit Margin, Inventory Turnover

(QQube with Power BI example)

Inventory Forecast Excel

Combine Qty on Hand with Pending Builds, Sales Order BOM,
Last and First Purchase Dates, Lots and Serial Numbers.
Various Sales Date Ranges, Days on Hand, Need to Order
(QQube with Excel example)

Inventory Forecast Power BI

Compare Daily Sales vs Daily Inventory Balance
Price, Current Avg Cost, Profit Margin, Retail Value
Need to Order based upon Reorder Status
(QQube with Power BI example)

Inventory Margin Analysis

Compare Cost Average vs Selling Average
Excel PowerPivot KPI for Margin/Markup expectations

(QQube with Excel example)

Bill of Materials

BOM Explosion by Assembly or by Item
(QQube with Excel example)


Inventory Management and Bill of Materials