Please fill all required fields
[This is to test whether you are a human visitor and to prevent automated spam submissions.]
Enter the Number as displayed below
Contact us for More Information.
Copyright © 2011 J.Hunter & Associates. All Rights Reserved.
Back to Tools Page
This Gross Profit Worksheet shows the effects of reducing cost verses increasing sales.
Current Sales Amount
Enter Current Sales Amount IE 10,000.
Current Gross Profit %
Enter Current GP Percentage IE 25%
Projected % Cost
Enter Projected Cost Reduction IE 5%
Projected % Sales Increase
Enter Projected Sales Increase IE 10%
Reduce Cost Only
Increase Sales Only
Effect of Both
Change in Gross Profit $
New Gross Profit %
Increase in Gross Profit Dollars
New Projected Gross Profit $
This exercise is designed to demonstrate where management can get the best returns.
Obviously it is best to expend time and effort where you will achieve the best return .
This in no way means that efforts shouldn't be expended in both reducing costs and in increasing sales, it merely attempts to depict what the results could be with each method of effecting profits.
With a starting gross profit of 35% An increase in sales of 6.5 % is equivalent of a cost reduction of 10%.
With a starting gross profit of 45% An increase in sales of 5.5 % is equivalent of a cost reduction of 10%.
With a starting gross profit of505% An increase in sales of 5.0 % is equivalent of a cost reduction of 10%.
will not work. Please access the web page using another browser.