ASP & Margin

Selling price against plan, gross margin by customer, and this year against last.
Data as of Nov 21, 6:06 PM PT Page built
Loading data…
Year
Rep
Month
Plan line
Item
Account
i Hover the i for what a number is and where it comes from. Red is under plan or down; green is over plan or up.

ASP vs plan, by product line

Over/Under % and Over/Under $ can point different ways: the % is a plain average over rep, item and month rows, while the $ adds up each row's gap times units sold, so big-volume months weigh more. Both colors follow the %, as in Power BI.

ASP trend by rep and month

Gross margin % by customer and month

Gross profit by customer, biggest first

Profit month

Year over year, same closed months

Detail by metric, subcategory and item

Year
Cost-based rows only cover items that have a unit cost on file. A cell adds up the items that sell at $1 or more a unit in that month; items under $1 (samples, bulk trim) drop out one by one.