Return to GAWDA Home Page View the Current Issue

Sales Proofing The Financial Plan

GAWDA members have operating expenses that fall into two categories: payroll and everything else.

By Dr. Albert D. Bates

The current attitude of most GAWDA members could probably be summed up with one word—uncertainty. The economy may or may not be improving and sales may or may not grow over the next few months. In such an uncertain environment, there is a tendency to abandon the planning and controlling process. After all, why plan if you can't make any basic assumptions about the future? Instead of planning, firms often simply hope for the best.

In most instances, hoping for the best is not going to produce improved profit results. Instead, firms need to develop planning approaches that will improve results in virtually any economic environment. This process involves two components: Sales Proof Planning, or using a planning approach that will improve performance under almost any future sales volume level; and Contingency Planning, or identifying the specific actions that will be taken to support the plan under differing sales growth scenarios. The goal is to develop a planning mechanism that will produce positive results regardless of the firm's ability to foretell the economic future.


In the long run, the easy reductions may not be the right ones.

Sales Proof Planning
Improved financial performance derives from either increasing the gross margin percentage or decreasing the operating expense percentage. Both areas are legitimate opportunities for improvement. However, in uncertain times there is a natural tendency to place more emphasis on expenses. The reason is that expense reductions can be achieved entirely from internal actions, while gross margin enhancements require working with suppliers and/or customers.

Like firms in most industries, GAWDA members have operating expenses that fall into two categories: payroll and everything else. For planning purposes more detailed breakouts are useful, but not required.

Payroll Expense is the larger of the two categories, representing total salaries and all fringe benefits. Increasingly, analysts are examining payroll costs in relationship to gross margin rather than sales. At present, this number for the typical GAWDA member stands at 56.0%. That is, for every $1.00 of gross margin the firm produces, 56.0 cents must go toward total payroll expense. In planning parlance this is the Personnel Productivity Ratio or PPR.

All Other Expenses includes all of the expenses other than payroll and fringe benefits. Most commonly, this ratio is analyzed as a percent of sales. For the typical GAWDA member, the ratio is currently 15.8% of sales.

Making Improvements
For both of these expense categories, it is possible to set goals that should be achieved regardless of what happens to sales volume. Specifically, the following two objectives are suggested for the typical GAWDA member:

1. Percentage Point Reduction (PPR) — A reduction of 0.5 percentage points per year for at least three years. For the typical firm, next year the ratio would fall from 56.0% to 55.5%, then the following year to 55.0%, another 0.5 drop. Since every GAWDA member is somewhat different, the guideline is not absolute. However, every firm should use it as a starting point in planning.

2. Other Expense Percentage — A reduction of 0.2 percentage points per year. These expenses would then decline from their present 15.8% of sales to 15.6% next year. Again, this reduction is a good starting point for planning, but is not absolute for every firm.


The challenge of contingency is to ensure that improved results occur regardless of sales performance.

Reaching these goals will have a dramatic impact on the firm, regardless of sales growth. However, the exact impact will be influenced slightly by what happens to sales. Before considering the range of various sales results that might materialize, it is useful to look at one specific situation in detail.

In Exhibit 1, it is assumed that sales will grow by 5.0% per year over the course of the next three years. This might be a good assumption or it might be a terrible one. Ultimately, it doesn't make any difference how good the assumption is as the two goals detailed above (for PPR and other expenses) will improve profitability regardless of sales results. The 5.0% figure in Exhibit 1 simply represents one growth assumption out of many that could be made.

Exhibit 1
The Impact of a Reduction in the PPR
And the Other Expense Percentage
         
  Current Year One Year Two Year Three
Net Sales $8,000,000 $8,400,000 $8,820,000 $9,261,000
Costs of Goods Sold 4,416,000 4,636,800 4,868,640 5,112,072
Gross Margin 3,584,000 3,763,200 3,951,360 4,148,928
Payroll & Fringes 2,008,000 2,089,584 2,174,306 2,262,277
All Other Expenses 1,264,000 1,310,400 1,358,280 1,407,672
Total Expenses 3,272,000 3,399,984 3,532,586 3,669,949
Profit Before Taxes 312,000 363,216 418,774 478,979
  
Profit Margin % 3.9% 4.3% 4.7% 5.2%
PPR 56.0% 55.5% 55.0% 54.5%
Other Expense % 15.8% 15.6% 15.4% 15.2%

As can be seen in the exhibit, the two expense goals, combined with the 5.0% sales growth, produce an increase in dollar profits as well as an increase in profits as a percent of sales. The current bottom line figure of 3.9% increases to 5.2% over a three-year time period. Under this set of assumptions, the profit improvement is extremely positive. The challenge, of course, is to ensure that such improved results occur regardless of sales performance. That is the challenge associated with contingency planning.

Contingency Planning
The concept of contingency planning has two components. The first component is what is sometimes called sales ranging. This involves identifying the range of sales performance that reasonably could be predicted. The second component involves pre-planning expense actions. This means determining ahead of time how specific expenses will be increased or reduced if actual sales growth is higher or lower than initially anticipated.

Sales ranging accepts the fact that the plan will not be truly beneficial to the firm unless it can produce improved performance under a variety of actual sales growth rates. The expense planning process will not cover every possible outcome, but will cover the range of likely results.

Exhibit 2
The Impact of Expense Reductions
Under Various Sales Assumptions
         
  Current 5% Growth No Growth 5% Decline
Net Sales $8,000,000 $8,400,000 $8,000,000 $7,600,000
Costs of Goods Sold 4,416,000 4,636,800 4,416,000 4,195,200
Gross Margin 3,584,000 3,763,200 3,584,000 3,404,800
Payroll & Fringes 2,008,000 2,089,584 1,990,080 1,890,576
All Other Expenses 1,264,000 1,310,400 1,248,000 1,185,600
Total Expenses 3,272,000 3,399,984 3,238,080 3,076,176
Profit Before Taxes 312,000 363,216 345,920 328,624
  
Profit Margin % 3.9% 4.3% 4.3% 4.3%
PPR 56.0% 55.5% 55.5% 55.5%
Other Expense % 15.8% 15.6% 15.6% 15.6%

Exhibit 2 looks at the impact of the same two improvement efforts (reducing the PPR and reducing the other expense percentage) under three very different sales growth scenarios for next year: a) 5.0% growth, b) no growth, and c) a 5.0% decline. With the two specific goals identified, profit will increase under all three scenarios, although not at the same rate. In addition, profit will be almost exactly the same percent of sales in all cases:

  • Sales Growth — Profit increases from 3.9% of sales to 4.3% just as it did in Exhibit 1 and dollar profit increases to $363,216, just as before.
  • No Growth — Under this assumption, the dollar profit only increases to $345,920. However, this is still a significant increase and was achieved in the absence of sales growth.
  • Sales Decline — The beauty of planning in the mode indicated is that profits actually can be increased in a down year. While the increase is modest, it is an increase, with dollar profits reaching $328,624.

These three assumptions might not be the only ones that should be considered. However, taken collectively they represent the range of performance that would likely be expected.

Preplanning Expense Actions
Preplanning expense actions is at the heart of contingency planning. Exhibit 2 suggests that one specific set of expense goals can produce increased profits under a wide range of sales assumptions. However, those sales assumptions require that very different expense actions be taken in each of the different sales levels.


Expense reductions can be achieved entirely from internal actions, while gross margin enhancements require working with suppliers and/or customers.

For example, the sales growth assumption allows payroll expense to grow from $2,008,000 to $2,089,584, an increase of 4.1%. In sharp contrast, the sales decline assumption requires that payroll expense be cut to $1,890,576, a reduction of 5.8%. In the first instance, the firm is relatively relaxed about payroll expenses. In the second instance, the firm is making a significant reduction. Clearly, these are different strategies.

Preplanning expense actions involves nothing more than thinking about expense control issues before sales results are known rather than after. From a negative sales growth view, which is the one that is most difficult to deal with, it suggests knowing where cuts will have to be made well ahead of actually making them. Unfortunately, it cannot determine when during the year the firm should take the actions. It can merely identify what the actions will be.

Most GAWDA members run what are still relatively small businesses. Making reductions in payroll is an excruciatingly difficult undertaking. Employees are not merely numbers as they are in gigantic corporations. They are real people with real families and real histories with the firm.

In an uncertain environment, though, it is necessary to identify which functions and which services will not be provided in the case that sales prove inadequate. Such planning is actually beneficial in and of itself as it forces the firm to think about the priorities it should have. It identifies truly essential services.

Of greater consequence, thinking about expense reductions ahead of time provides for a much more orderly perspective on the issue. Waiting until expense cuts become imperative may result in quick, off-the-cuff reductions. In the long run, the easy reductions may not be the right ones.

None of this makes any of the decisions any easier. However, if contingency planning is used properly, with realistic goals such as the ones identified here, the process should allow firms to produce the profits they require.

Moving Forward
If GAWDA members can focus their planning on expense control in relationship to sales rather than merely on sales itself, they can develop plans that will improve results regardless of sales growth rates. However, ensuring that higher profits are generated requires the firm to think seriously about the specific actions that will be taken under a range of different sales realities. Firms that can make that commitment can guarantee profits regardless of the economic uncertainty.

Meet the Author
Dr. Albert D. Bates is founder and president of Profit Planning Group, a distribution research firm headquartered in Boulder, Colorado and on the Web at www.profitplanninggroup.com.

 Back to Previous Page

Welding & Gases Today • Winter 2003 • Volume 2, No. 1 • Entire contents are Copyright © Data Key Communications, Inc. • All rights reserved. • Nothing may be reproduced in whole or part without written permission of the publisher.