Ascend HQ RPM Accuracy metrics

The RPM Accuracy report on Ascend HQ lets you see how well your store adheres to Ascend’s key best practices, which will keep your Retail Profit Machine running smoothly and help you get the most of your system. Following best practices means your processes will be as efficient as possible and frees up your time to focus on selling.

Green cards indicate your store meets or exceeds the minimum benchmark value, while orange cards indicate work is needed. Values are based on the 30 days prior to running the report and refresh overnight.
Sherpa tip: This report CANNOT be run for a custom date range, but (multi-store retailers) CAN be run for individual locations.

All values are based on finished (closed) transactions.

Access this report from either the Reports section or just click the target icon on the Analytics Retail Profit Machine metric.

Overall Score

Total point score for all metrics, out of a maximum of 100.

% of Bikes w/Accurate SNs

Products in stock and assigned to a serialized category (e.g. Bikes) on which the total number of unsold serial numbers associated matches its Quantity, divided by total products assigned to a Bikes category, multiplied by 100.Sherpa tip: Products which have a negative Quantity are NOT included.

In Ascend, use Reports > Inventory > Serial Numbers Not Matching Quantity on Hand to determine products to investigate.

15 points are awarded for 95% or more.

Bikes w/Inaccurate SN

Total number of products assigned to a Bikes category (i.e. top parent category contains Bikes or Bicycles) where the total number of unsold serial numbers does not match the product’s Quantity.

Total Variance SN to QoH

Total difference between the count of (unsold) serial numbers associated with a product and its Quantity.
Sherpa tip: This metric uses an “absolute” value – this is strictly the total difference in values and indicates neither positive or negative variances (whether bike Quantity to serial number is higher or lower).Products which have a negative Quantity are NOT included.

% of Products Sold w/Category

Total value (sales dollars - Quantity times Price) for sale items which are assigned to a category divided by total value of all sales items, multiplied by 100.

In Ascend, use Reports > In-Store Products > Products Sold with No Category to determine products to investigate.

10 points are awarded for 95% or more.

# of Units Sold w/o Category

Total Quantity of sales items which are NOT assigned to a category.

Combined Sales $ of Items

Total value (sales dollars - Quantity times Price) for sale items which are NOT assigned to a category.

% of Labor Charges on WOs

Total value (sales dollars - Quantity times Price) for sale items which are assigned to a Labor category (i.e. top parent category contains Labor or Labour) and were added to the Work Order Details screen divided by total value of all sales items assigned to a Labor category, multiplied by 100.

20 points are awarded for 90% or more.

Labor $ Not Associated to a WO

Total value (sales dollars - Quantity times Price) for sale items which are assigned to a Labor category (i.e. top parent category contains Labor or Labour) and are NOT assigned to a Work Order Detail (repair).

Labor $ Associated to a WO

Total value (sales dollars - Quantity times Price) for sale items which are assigned to a Labor category (i.e. top parent category contains Labor or Labour) and are assigned to a Work Order Detail (repair).

NPS Sample Size

Customers assigned to transactions who have an email address entered divided by total transactions, multiplied by 100.

In Ascend, use the Customer Query utility to determine customers without an email address entered.

10 points are awarded for 75% or more.

# of Emails Addresses Collected

Total number of customers assigned to transactions who have an Email Address entered.

Emails Needed to Reach 75%

Number of transactions assigned to a customer with an Email Address entered needed to meet the goal value.

% of Uncommitted Negative Inventory

Total cost value (Quantity times Average Cost – or Estimated Cost, if Average is $0.00) for products with a negative Quantity which are NOT marked as a special order divided by total cost value for all products with a Quantity (positive OR negative), multiplied by 100.

In Ascend, use Reports > Inventory > Negative Inventory to determine products to investigate.

15 points are awarded for 1% or less.

Potential Shrink Dollars

Total cost value (Quantity times Average Cost – or Estimated Cost, if Average is $0.00) for products with a negative Quantity which are NOT marked as a special order.

Likely Days in Stock

Av. DIS (from the Analytics Retail Profit Machine metric) reduced by the % of Uncommitted Negative Inventory value.
Sherpa tip: For example, if Av. DIS is 180 days and 5% is uncommitted negative inventory, this value is 171 (180 minus 9).

% of Sales w/Time Clock Records

Total value (sales dollars - Quantity times Price) for sales items on a transaction where the Sales Person (selected in the Sales Person dropdown menu) is associated with Time Clock records divided by total value of all sales items, multiplied by 100.

30 points are awarded for 90% or more.

Sales $ w/o Time Clock Records

Total value (sales dollars - Quantity times Price) for sales items on a transaction where the Sales Person (selected in the Sales Person dropdown menu) does not have any Time Clock records.

Adjusted Sales/Hour

Sales/Hour (from the Analytics Retail Profit Machine metric) adjusted to include the estimated hours unaccounted for in the Time Clock.

  • Adjusted Hours: Sales $ without Time-Clock Records divided by Sales/Hour
  • Estimated Hours: Total hours logged in the Time Clock plus Adjusted Hours.
  • Final value: Total sales dollars divided by Estimated Hours

Sherpa tip: For example, if Sales/Hour is $74, total Sales is $31,282, Time Clock hours is 422, and Sales $ w/o Time Clock Records is $7,525, this value is $60 (Adjusted Hours 102 and Estimated Hours 524).

Feedback and Knowledge Base