Hyperion Dashboard
Monthly trend
Selected year vs. the prior year, by month
By channel
Full-year total, by channel
Margin %
Monthly margin as a % of revenue, selected year vs. prior year
Revenue trend
Click a group row to collapse it. Δ% compares each period to the same period one year earlier.
Backlog status
Fulfilment state, by units reserved, distinct SKUs, or list-price revenue — where the demand and the money are currently sitting
Reservations opened, by month
Units reserved, based on line creation date · click a bar to drill in
Open backlog by age
How long each open line has been sitting unfulfilled · click a slice to drill in
Top vendors
Split by backlog status · click a bar to drill in
Top customers
Split by backlog status · click a bar to drill in
Ready to ship — immediate revenue opportunities
Fully allocated units, by SKU and customer — already secured, nothing left blocking the shipment
| Item | Customer | Units | Revenue |
|---|
Customer reservations
Every individual reservation line for the selected customer(s)
Select a customer above to see their individual reservation lines.
Largest supply gaps
Items where total backorder outstrips stock and incoming PO cover — biggest negative spare, i.e. the most exposed lines
| Item | Stock | On backorder | Spare |
|---|
Slow-moving new arrivals
Restocks that arrived in the last 30 days but have barely sold since — needs Purchase History and a Sales (1.csv) upload
| Item | Brand | Arrived (30d) | Sold (30d) | % sold | Stock Colby | Stock ET |
|---|
Underperforming new releases
Video game releases with poor sell-through — needs Purchase History and a Sales (1.csv) upload
| Item | Brand | Released | Launch qty | Sold | % sold | Stock Colby | Stock ET |
|---|
Top vendors
Stacked by true stock age (same coloring as Stock age) — click a segment to see those SKUs
Top customers
Needs the order-level report (1.csv) — gives per-customer detail
Bestsellers
Top SKUs YTD, ranked by units sold or revenue
| Item | Vendor | Units sold | Revenue | Our stock | Stock cover | Trend |
|---|
Stock age
SKUs in stock, grouped by true stock age — click a bar to see those SKUs
Revenue concentration
Cumulative share of YTD revenue held by the top N SKUs — click a point to see those SKUs
Worst sellers & overstock
SKUs with the most stock tied up relative to how little (or nothing) sold YTD — liquidation/discount candidates
| Item | Vendor | Our stock | Units sold YTD | Last sale | Stock value |
|---|
Reorder soon
Strong YTD sellers with the least stock cover left (units sold ÷ daily sale rate) — the opposite risk to overstock
| Item | Vendor | Units sold YTD | Our stock | On PO | Stock cover (days) | Supplier stock | Trend |
|---|
Supplier stock opportunities
SKUs that are selling but low/out of our own stock, where the supplier is showing stock we could pull in — from the by-SKU (EAN) report only
| Item | Vendor | Our stock | Supplier stock | Units sold YTD | Revenue YTD | Trend |
|---|
Units sold, by month
Needs the order-level report (1.csv) — gives per-line order dates
All SKUs
Search, or click a column to sort — organise by SKU or by vendor
Margin opportunities
Realised YTD margin (sell price − Colby buy price) on SKUs that are actually selling — needs a Sales tab upload
| Item | Brand | Units sold YTD | Margin / unit | Margin % | Total margin YTD |
|---|
Dead & stagnant stock
Colby stock with the most capital tied up and little or no recent sale
| Item | Brand | Stock (Colby) | Units sold YTD | Capital tied up |
|---|
Stock by brand
Colby stock only · click a bar to filter the stock table below to that brand
Stock value by true age
Colby stock cost value, grouped by true stock age
All stock
Search, or click a column to sort — organise by SKU or by brand
Colby vs ET stock, by brand
Click a bar to filter the stock table below to that brand
ET opportunities
SKUs Colby has sold well but ET is showing little/no stock of — candidates for ET to bring in
| Item | Brand | Colby units sold YTD | Stock Colby | Stock ET |
|---|
ET restock candidates
Items ET has bought from Colby that are now running low in ET's own stock — check whether Colby or Colby's supplier can replenish
| Item | Brand | Sold to ET (YTD) | Stock ET | Stock Colby | Supplier stock |
|---|