http://planetpov.com/?attachment_id=20577

This is the eighth in a series of articles that will hopefully educate readers and illuminate the process of doing business in a simple to understand, nuts-and-bolts way.

To read all the articles in this series, click on any of the following:

In the last article, we established a method to predict sales and established a concept of how to look at Cost of Goods Sold (COGS) as a percentage of sales.  Now let’s expand on that a bit to get to a useful Financial Plan.  As you recall, our sales history looked like this:

Now, in going back over your records looking at COGS information, you can fill in another line listing COGS expenses by month in the same way.  This isn’t rocket science, but slogging, hard work. 

Now, go back and do the same thing for your General & Administrative (G&A) Expenses for the same periods that you have done for Sales and COGS.

Normalizing G&A

If you have properly separated out your COGS expenses, the G&A expenses should be fairly stable month-to-month.  Rent stays the same, insurance, mailing, office supplies, phone bills, etc., all average out to be pretty much the same every month.  It’s that average we want to consider.  Find out what that average is per month and make a note of it.

You are now ready to do a few simple calculations, so haul out your calculator.  Here are the formulae:

Perform this operation on each month you have data for, and for the yearly totals.  It should look something like this:

There is a ton of information here.  What you have just accomplished is a historically accurate and rational picture of how your business operates month by month, quarter by quarter, and for the year.  There’s lots to think about as well.  You can see in the model above that the last two fiscal quarters of the year carry the first 6 months.  You can see that you will likely have cash flow problems to overcome.  And you can also see that you can expect to have a tidy 10% Net Profit at the end of it if you operate according to historical norms.

Many bad business decisions are made because of panic over not understanding how a business operates from this perspective.  If you are sitting in March with a HUGE negative Net Margin, it is easy to think you are in trouble.  If you, instead, KNOW that this is how your business ordinarily cycles, and you are on track according to this map, there is literally nothing to be concerned about.

By the way, you have just created a Financial Plan, or at least the base of one.  If you take this map of how your business operates, and plan to, say increase Sales by 5% in the next fiscal year, take all this information and do the following:

  • Increase each month’s sales numbers by 5%
  • Maintain the overall COGS percentage in each month
  • Maintain the G&A actual dollars
  • Observe what happens to the Net Profit dollars and Net Profit Margin

Or, you may have a plan to decrease COGS by 2% in the next fiscal year as well.  Plug in the proper numbers and see how that affects your bottom line.

THIS IS A VERY VALUABLE PLANNING TECHNIQUE!  You must master it in order to understand how all the moving parts of your business interact!  And, by the way, whatever you decide to do with your business in this regard, once you have made a plan for the coming fiscal year, a summary of that plan, with real numbers that mean something and are based in reality, belong in…. The Business Plan.

———-

Please contact me offline at microconsulting@aol.com with anycomments, suggestions or ideas for future articles that you may not want to share here.

———-

Previous articleWisconsin, what does it really mean?
Next articleInvite For Collaboration Part 2:
I am a small town boy from northern Wisconsin, who grew up in the quintessential American family. Dad was a carpenter, mom stayed home, two brothers and a sister. Our politics, and we were political, was always Democrat. My dad always said all you had to do was to look at what each side was fighting for, and it was easy to see, even as a kid, that Republicans were all about big money and rich businessmen, whereas the Democrats were more about social solutions. I spent 6 years in the US Army in the VietNam era as an electronic instructor for NSA, worked as a Field Engineer for a computer firm based in Massachusetts, spent another few years building paper mills around the world for a firm from Washington state, drove long haul truck for a while, did 10 years of servitude in NYC for a large multinational market research company as the Business Manager, spent some more time on the road as a Business Consultant, and the last bit as the Business Manager for a manufacturing firm here north of Houston. I am trying to start up my own consulting firm using all my experience to help small and medium sized businesses stay out of trouble versus waiting until they get into trouble. No one teaches people how to properly run a business. Business schools and MBA programs really don't. There are very basic nuts and bolts that are either assumed or are ignored, and like the house built on sand, businessmen and entrepreneurs ignore these solid foundations at their peril. (Now retired and doing some substitute teaching at a couple of small K-12 schools here in northern Wisconsin. Living in a small hamlet of 340 people, quiet, peaceful, serene.)

11
Leave a Comment

Please Login to comment
1 Comment threads
10 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
3 Comment authors
snoskierPocketWatchKB723 Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
KB723
Guest
KB723

PW, Holy Makerel. That’s a lot of info. Thanks for sharing. 😎