Hannah Dashboard Mock

High level (Revenue, Profit, Cart Size)

Revenue

Last 7 days

#

#% vs previous 7

Last 30 days

#

#% vs previous 30

Revenue over time (last 10 weeks)

Profit

Last 7 days

#

#% vs previous 7

Last 30 days

#

#% vs previous 30

Profit over time (last 10 weeks)

Revenue & Profit by location (last 30 days)

Location	Revenue	Profit

Average cart size (last 30 days)

Items and Rand value per order (overall and by location).

Location	Avg items	Avg Rand

Weekly operational check

# - #

What's working

Best-selling product lines

Product line	Qty	Revenue	Profit

Best-selling product SKUs

Product	Qty	Revenue	Profit

Sales by category

	Category	Qty	Revenue	Profit

Best-sellers at each location

What's not working

Didn't sell

Showing 0 of 0 items. Download for full list.

Product line	Sold 7d	Sold 14d	Sold 30d

Returns

Returns number

#

#% of total sales

Returns value

#

#% of total revenue

Returns by location

Location	Qty	% of sales

Monthly strategic review (last 30 days)

# - #

What's working

Best-selling product lines

Product line	Qty	Revenue	Profit

Best-selling product SKUs

SKU	Product	Qty	Revenue	Profit

Sales by category

	Category	Qty	Revenue	Profit

Best-sellers at each location

What's not working

Didn't sell

Showing 0 of 0 items. Download for full list.

Product line	Sold 30d	Sold 60d	Sold 90d

Top returned (by qty)

Family	Returns qty

What's hurting margins

Average product margin

#

Lowest margin product lines (Hannah Lavery)

Product line	Margin	Profit

Lowest margin product lines (Non-HL)

Product line	Margin	Profit

Recommendations (Actions)

What should we CUT? ?

What should we PROMOTE? ?

What should we reorder? ?

Velocity = sales per day over last 60 days. Days to Zero = days of stock left at last month's sales rate.

Reorder these

Showing 0 of 0 items. Download Excel for full list.

SKU	Product	Product score	Stock available	Velocity	Days to Zero

Running out... but DON'T reorder these

Showing 0 of 0 items. Download Excel for full list.

Maybe reorder... low-scoring but new

Showing 0 of 0 items.

Maybe reorder... middling performance

Showing 0 of 0 items.

How cut/promote recommendations work: We score each product family based on sales, margin, revenue contribution, and cost to produce. A 5 is a perfect score, and a perfect score, and -1 would be the worst score. We then suggest you promote high scorers... and possibly cut low scorers. An exception is made for products introduced recently (last 90 days); we don't think you should cut these yet, as maybe they just need a bit more time on the shelves.

How reorder recommendations work: We compare current stock availability to recent sales speed (# sales per day, over last ~60 days). Then, if the stock will run out soon, we layer on the product score for our recommendation on what to do next (see "how cut/promote recs work"):

If the product score is strong, we recommend reordering.
If the score is middling, we flag it for review.
If the score is poor and the product has been around for a while, we suggest NOT reordering.
If the score is low but new stock, we flag it for review.