Once you have improved your business gross profit at a macro level, it is time to look at the mix of products you offer and the gross profit of each. Bettering your gross profit at the product level requires you to look not only at the GP of each product, but also the volume of sales per product.
Consider the following business scenario:
| The WGP% is the weighted GP percentage. A weighted value is one that has been normalised or adjusted proportionally to allow an apples-to-apples comparison.
In this table, the GP% has been multiplied by the sales volume % to calculate the WGP%. The sum of the WGP% is the total business GP%. |
Product | GP % | Sales % | WGP% | |
|---|---|---|---|---|---|
| Widget A | 35.0 | 20.0 | 7.0 | ||
| Widget B | 65.0 | 8.0 | 5.2 | ||
| Widget C | 25.0 | 50.0 | 12.5 | ||
| Widget D | 40.0 | 22.0 | 8.8 | ||
| Total business gross profit % | 33.5 | ||||
If you looked only at the column listing the GP% per product you might conclude that Widget B is the highest contributor to gross profit, followed by widgets D, A and C. However, when you take into consideration the volume of sales and how that impacts on the WGP% we learn that:
- Widget B contributes the least to the business gross profit; although it has the highest percentage GP, it is the least sold product
- Widget C contributes the most to the business gross profit despite having the smallest GP% because it has the highest sales volume
So, how do you use this information to better your gross profit?
To have the greatest impact on GP through an increase in prices, increase the price of Widget C by only a small percentage to return a large GP increase. For example, if you increase the individual GP of Widget C by 3% to 28% the overall business GP% increases to 35%. However, if you increase the individual GP of Widget B by 3% to 68% the overall business GP% increases to only 33.7%.
The WGP% data can also provide guidance over where to assign your resources. If looking at product GP% only you might consider it more important to have team members assigned to manufacture Widget B, at the expense of resources for the other products. However, given that the business earns more GP from Widget C, ensuring the resources are assigned to meet the demand on the product creating the most GP would be a better management decision.
If a decision must be taken to drop a product from the product line i.e. because of a lack of resources, production lines or similar, ensure the WGP% is used to identify the lowest performing product, rather than relying of GP% in isolation of sales volume.
Want more?
Download the Systems Mentors Gross Profit Analysis workbook (Microsoft Excel 2007) and work through the GP exercises with your business data. Good luck!
![]() |
||
| If this article interested you then you may also like: | ||
![]() |
![]() |
![]() |







