Compare gross profit percent over the last year (12M GP % Grid)

The 12M GP% Grid compares monthly gross profit percent year over year. This information is updated daily.

1. Open this Dashboard as described in Review Sales dashboard KPIs

   

2. Review gross profit %. In this example, assume you are viewing the dashboard on June 15, 2019.
   • TY GP %: This Year's Gross Profit % . The gross profit % for each month this year, from yesterday to that same day last year (June 14 2018-June 14-2019).
   • TY GP % Var: This Year's Gross Profit % Variance. The difference between TY Gross Profit % and LY Gross Profit %. In the chart above for Total:
     [(24.96%) - (24.42%)] = .54%
     This means the organization earned .54% more gross profit year over year.
   • TY GP % Var %: This Year's Gross Profit % Variance Percent, calculated as (TYGP%Var/LYGP%)100
   • LY GP %: Last Year Gross Profit % . The gross profit percentage earned from a year ago yesterday and the prior year: in this example, the gross profit earned between June 14, 2017 and June 14, 2018.
   • LY GP %Var: Last Year's Gross Profit % Variance. The difference between LY Gross Profit % and the prior year's Gross Profit % (3^rdY GP% not shown). In the chart above for Total:
     [(24.42%) - (ThirdYearGP%)] = -.90%
     From this equation, you can calculate the Third Year Gross Profit % (2017-2018) as 25.32%.
   • LY GP %Var %: Last Year's Gross Profit % Variance Percent, calculated as
     (LYGP%Var/ThirdYearGP%)100
3. To filter the Gross Profit % by salesperson, vendor, or location, click View Detail.

   

   From the Filter list, choose one of the filters below, and then select/clear the check boxes to define the specifics. Click Search.

   Available filters

   • Salesperson
   • Territory
   • Branch
   • Division
   • Customer
   • Primary Vendor
   • Order Writer

See also

• Review Sales dashboard KPIs
• Print a Dashboard KPI
• Export data from a dashboard KPI