Blog

Focus on the big picture

I met with a department manager the other day who had very little excel experience, he was able to do simple data entry and knew that formulas existed, but not how to create them.  In October we had a talk about training and how long it took to manually do state mandated reporting – about 40-50 hours of summary statistics, all done by hand sorting and calculations.  Call me in January and we can set up some training and set up a spreadsheet that will automate the process, should take under 2 hours for the spreadsheet development and we can cut your total time on state reporting down to under 5 hours, probably under 2.  Most of the data was already entered into MS Word, not in a spreadsheet to enable data manipulation.  No biggie, I thought, copy here, paste there, couple of totals, averages and percentage calculations,  and a year to date summary sheet, wave my magic wand, and ZAP!  Required yearly reporting done in record time.

January rolls around and I called on the manager to see how things are going.  “Not good” replied the manager, “my budget got cut by 25% and it was tight last year.  This year is going to be awful.”

Perfect time to save 40-45 hours of your time, right?  Not according to this salaried manager – his time was already in the budget and all he could see is more money going out of the checkbook, not the time savings that would not translate into cash.  Now don’t get me wrong, I have been there where every single penny counts and there is not enough to pay all the bills.    But to ignore saving 40 hours for under a $200 investment?  Wow…. I am still shaking my head over that logic.  Since it was a REALLY small project, I did not want to get into a long sales pitch showing the benefits of the automation, I just walked away and wondered how much longer that manager would be around. – if your labor is paid minimum wage and you don’t believe the time savings, this is a logical conclusion.  At minimum wage, you must save more than 28 hours to pay off investment.

Is it worth monitoring?

I used to be over zealous about monitoring and tracking EVERYTHING. Now I am just zealous. It took me a while, but I have learned that if you are not using the information, why are you spending time to track it? For a numbers junkie like me, that is a very difficult conclusion to reach. However, after years of tracking everything under the sun, I have found the power of a simple and focused management metric system to be an incredibly effective management tool. It allows you to focus your management time on what you have identified as the most important variables in your business and effectively communicate that information to your people.

Don’t get me wrong; it is vitally important to track information in your business, and critical that you collect the correct building blocks of an information management system. It is much easier to enter a few pieces of data once a day than to try and recreate 6 months worth of data, just because you didn’t think it would be useful. But there needs to be a balance. I have seen accounting setups for small businesses with 150 expense account codes and setups with 4 expense codes. It doesn’t matter if you are drowning in information or starving for information, either scenario is ineffective.

So where do you start with figuring out what data to collect? With the goals for your business.

Lesson Learned: Analyze what you have and what you need, then strike a balance a to make it happen.

Do you know what you are measuring?

I worked with a restaurant owner on his food cost management system.  He was meticulous about keeping his food cost under 30% of sales and had worked out the cost for every item on his menu in a spreadsheet and could rapidly look at the impacts of price changes to his bottom line.  A very nice management system to say the least!  However, he would regularly add all of his food vendor bills and divide by total sales for the week and he was coming up with a food cost of closer to 40% of sales.

I was called in to help him figure out the error in his spreadsheet and he was suspecting he had a theft problem.  It didn’t take long to confirm that his calculations were correct, and he was starting to look through security tapes with a grim look on his face.  While he started down that path, I looked at the other half of his double check, the total of the food vendor bills.  Turns out that he was getting all of his paper products like take out containers, napkins, cleaning supplies, from the same vendors.  The consumables accounted for the difference in the food cost percentages.

Sometimes it’s the small things hiding in plain sight that trip you up.

Focus on the Numbers: Per Unit Cost of Production

What is a per unit cost of production and why should I care?  A per unit cost of production allows you to examine your business over time as the size of the business changes, giving you a much more objective way of measuring performance.  Think of it this way, if you add 5 employees to your payroll and your net income goes up, you won, right?  Maybe, maybe not.

If you take your profit and loss statement and divide each line item by the number of employees for that same time period, you can come up with a per unit (in this case, per employee) cost.  Now when you want to look at two time periods and ask are we doing better or worse, you can reliably answer by each line item.  So if in 2016 first Quarter, you employed 10 people and made 10,000 widgets, you would expect 2016 Second Quarter with 15 people to be able to produce 15,000 widgets.  If you actually produced 12,000 widgets, you better start digging into the numbers more.  If you increased production to more than 15,000 widgets, you may deserve a pat on the back!

Now there are a ton of variables that can affect the per unit cost of production – economy, new equipment, training programs, input cost increases – all will affect the per unit costs.  But at least now you have a tool to help you objectively monitor your business by line item on your P&L.  The fun part is in asking the question why.

Per employee is not the only way to look at your production facility – I have seen managers look at per unit cost by total production, employee, per thousand dollars of investment, and many other ways, searching for the best way of describing their individual business.

Here is a  really cool trick for you to play with:  export a report from QuickBooks into Excel.  Now it is just a matter of adding a column to the spreadsheet, figuring out what per unit you want to look at, and creating a formula to do all the work for you.

Piece of cake… I know!  But that’s another day’s blog post…

The curse of being of too busy

Small business owners are notoriously busy.  I grew up on a commercial farm with 800 acres of crops and 300 cows to milk and I have managed multiple businesses at the same time.  I know busy.  I know long hours.  I know what it takes to make things run.

All of my clients are busy – from the online sales-based businesses to the farms and machine shops.  Not to mention the inevitable curve balls that crunch your schedule even more, tiny windows of opportunity that force 24 hour days, tax season for CPAs,  the death of a key employee.

The response of just about every business owner to a curve ball is put their head down, pull harder, and work longer.  These are managers who are already too busy to read, too busy to hire new person, too busy to keep up with the never-ending stream of deadlines.  But that’s the coveted work ethic that is hard wired into entrepreneurs.  We make things happen.  Somehow, we find a way to push through and get it done.

When I meet with a client I will often say “Perhaps you are spending too much time working in your business and not enough time working on making the business stand by itself.  What if there is an easier way that you don’t notice because you have your head down and are so focused on the work?”

Here are three changes I made to break the “too busy” cycle and transition to balance in my life.

#1 – I walked away from low margin customers.  After telling a brand new BIG customer three times that I could not meet with them when they wanted because a low margin customer already had something scheduled, I stopped and said you know what, I will make it work to fit your needs.  That move made me more in 2 weeks with the new customer than I did in 2 months with the low margin customer.

#2 – I set aside time to work on MY business and MYSELF.  Not my clients, but me.  Time thinking about what I want the business to give me in return for my time.  Time spent in deliberate learning and expansion of my knowledge base.  I set goals, develop new products, and plan how to reach those goals.

#3 – Focus.  I keep my values, mission, goals, and task list aligned and focused.  I know that 80% of the output of my business is controlled by 20% of the input.  I find that 20% and leverage that knowledge by sharing it with everyone in my business.  I say no to things that are outside of the mission.

You have heard about my journey.  What is yours?

 

 

Why do we have managers who can’t manage finance?

The failure rate of startups has always dismayed me. In my consulting, I see two main reasons for business failure. First, people don’t have a firm grasp of their financials. They just don’t know their numbers. Second, people underestimate the toll on their physical and mental health. Depression, divorce, heart attacks and strokes from stress are all too common and dismantle many companies that have everything else going for them.

Let’s look at the first reason for failure – Managers who can’t manage finances. The bulk of our entrepreneur class consists of people who start a business out of passion – I love to bake, to farm, to fix computers – but they don’t have any business background. How do they get their start? They are disgruntled employees who are so fed up with the way their boss does things that they quit and start their own business, with the barest of plans.

If you think about it, the entire restaurant industry has managers who do nothing but sooth irate customers and make sure people show up for work. Manufacturing is no different. From line managers to shift managers, financials are hidden from people. The focus is make your production numbers, or we will find someone who can. Anyone who has had a sales job knows it is all about hitting the sales quota. Just sell more, more, more. Rarely does anyone get to see the whole financial picture.

Is it any wonder todays entrepreneurs are missing critical skill sets? Budgeting. Reading financials. Financial controls. Cash flow. Profit and loss. Balance Sheet. Net Worth. Top that off with the misconception that having a CPA do their taxes once a year is more than enough and you have a small business at a disadvantage.

Here is a news flash. If you can’t put your hands on rock solid financial numbers to back up a decision and plan for the future, you are not managing. You are working hard and hoping for the best. Maybe it’s time to start working smarter, not harder. Focus on your financials.

Focus, but on the right thing.

Last week I met with a sales professional who was pretty darn good. At sales. She told me “last year I made 88 thousand. But in November, things got slow, and now in February, I have nothing left. I have been eating off of credit cards, and I don’t know where all that money went. I have over $12,000 in credit card debt.”

It’s not an uncommon scenario among people who make a living off of sales commissions. Real estate agents, car sales people, insurance agents – all of them are able to “sell” their way out of a financial hole. So how did she get in this financial hole? For starters, she was focused on one goal. Sell as much as possible. Generate lots of income. Period. Strong sales compensates for weak financial management skills, and when the sales dry up for whatever reason, the crash is hard and fast.

The solution?

First step: Change your focus. From sales, to net worth. Choosing the right metric makes all the difference in the world. Set realistic financial, sales, and personal goals.

Second step: Find out where you spent all the money. Download your check book register to QuickBooks, Excel, or any other program that lets you sift through the data easily and find out where you spent your money.

Third step: Create a budget. Replenish your cash reserves, plan not only your income and expense, but also your assets and liabilities. Make the budget robust enough to handle the variability in your income stream while adding to your net worth.

Fourth step: Develop processes that support your goals. Formalize your sales process to fill your sales funnel from prospects to sales. By keeping your sales funnel filled at the top and following your process, sales droughts are leveled out and financial stresses are reduced. Follow the sales processes religiously! Develop financial processes that alert you well before any financial issue becomes a business threatening disaster. Build in automation to make sales and finance functions efficient.

Fifth step: Breath. Control your thoughts and don’t panic. Decisions made in the heat of the moment are rarely good decisions. Gather data, develop a solid plan, and implement.

That’s the path out.

 

The Hidden Cost of Debt

Debt is a topic that gets people fired up.  It can make you money.  It should be avoided like the plague.  Classic good vs. evil arguments.  To me, it is just another tool that you can use.  From a business standpoint, it is very important to understand the impacts of debt and why it is called leverage.

Look at the table below.  It represents two scenarios – one where a company is making money, and another where the company is losing money.  I want to focus on ROA – Return on Assets, and ROE – Return on Equity.  If there is no debt, they are both the same.  But with debt, someone else owns a part of your company, and the amount of equity you have invested is less.  When you borrow money and have a good year, your ROE grows substantially more than the ROA.  In the example below, the difference is 20% ROA and 100% ROE.    Borrowing money allows you to make a substantially higher return on your portion of the money invested in the business.

Now for the other side of the coin.  What happens if you have a bad year?  In the second column, you see a company with 1 million in sales lost $50,000.  That’s a shortfall of 5% of total sales, and I have seen folks argue that is not much in the grand scheme of things.  But look at the ROA.  That $50,000 loss translates to a 10% loss in total assets.  And when you look at equity, that amounts to 50% of your equity in the business.

Leverage works both ways.  With debt, if you are making money, your equity grows much faster than without debt.  If you are losing money, your equity disappears much faster too.

The bottom line is, debt is an accelerator.  Make sure you know the direction you are traveling before stepping on the gas.

 

  Making Money Losing Money
Sales  $      1,000,000  $  1,000,000
COGS  $         400,000  $     600,000
Gross Sales  $         600,000  $     400,000
     
Total Expenses  $         500,000  $     450,000
Net Income  $         100,000  $      (50,000)
     
Assets  $         500,000  $     500,000
Liabilities  $         400,000  $     400,000
Equity  $         100,000  $     100,000
     
ROA 20% -10%
ROE 100% -50%
     
Equity AFTER Net Income or loss  $         200,000  $       50,000

Marketing Math

Everybody loves math! I know, people always tell me so! Hmm, now that I think about it, perhaps they were being sarcastic. What do you think?

Seriously, it is important to make decisions based upon solid numbers. Today, I want to talk a bit about marketing math. Anyone who has listened to a sales pitch for advertising should consider a few calculations before spending any money. How much does it cost you to acquire one customer? How much does one customer spend over their lifetime with you? How much do you spend to purchase the product you are selling – which is called Cost of Goods Sold (COGS)?

Here are the math formulas for you to follow along with:

Cost to acquire 1 new customer = Marketing campaign $ divided by number of NEW customers.

Lifetime spending = Average sale times average times per year a customer buys times average years a customer buys.

COGS = how much you paid for your product. If you are making or assembling a product, add up the component costs plus the labor to assemble or produce. If you know what your sales margins are, you can use that percentage to come up with an average COGS.

Now for the number crunching. I have seen people say it costs me $100 to acquire a new customer, they buy about $500 worth of product over their lifetime with us. Good deal, right? Maybe… Depends on how much your COGS is. If you spend $100 for COGS, you have 300 to go to overhead and marketing. More than $400 COGS, and you have a real problem. You have not covered the COGS and additional marketing costs might be pushing you into a rising sales and falling profits scenario, a very dangerous place to be. There are other cost factors to consider, but this simplification is a good starting point.

This is why so many businesses go under during a sales growth period. Perplexing to the folks who don’t understand the numbers and it is hard to catch in time. But if you have rising sales and yet cash flow is getting tighter, that’s your sign to delve into the numbers. Ignore the euphoria when sales are growing fast and focus on the bottom line. That’s what is important.

If you find yourself in a low margin business – businesses like grocery stores, farm markets, and gas stations, what can you do? Lower the cost to acquire a new customer, develop loyalty programs to get your customers to buy more frequently and keep them longer, and add symbiotic products to raise the average a customer spends with you.

For many, this kind of math is as boring as watching paint dry, but if you want to play the entrepreneur game for a long time, you had better get used to it. Because if you wait until tax time to figure out you had a year of costs rising faster than sales, you won’t be around for long. Don’t like doing the math? That’s fine, we do.

Do you know what you don’t know?

I met with a plant manager a while ago about training his line managers to become proficient at Excel. You know, that fun number crunching spreadsheet program that people love to hate? So we sat down and I started asking questions. What skills do your line managers currently have? How many people? What do you want them to know how to do? So after about 10 minutes, I have a pretty decent idea of the skill level they were at, and where he wanted them to be.

I asked if he was going to be in the classes, and he quickly said, no, I know more about Excel than all of the line managers. I responded no problem, just checking.

Then I asked him to pull up a spreadsheet that he wanted the line mangers to be able to use so I could tailor the training to something they would use every day. He loved the ideas, and quickly pulled up a spreadsheet the mangers would need to use daily and a calculator, punched some numbers on the calculator and said “We take the daily production numbers, divide by hours of operations and plug the hourly rate in this cell right here”.

I stopped.

I stared.

I shut my mouth and tried very hard to be diplomatic. Because this self-proclaimed Excel expert that didn’t need training had missed an easy one. For those of you who don’t know anything about Excel, it is basically a giant glorified calculator with a monster memory. If you have Excel open, you don’t need a calculator, it is the calculator. On top of that, every time you reenter data, you double the chance for data entry error. I responded, “Is there a reason you don’t use Excel for the calculations?” He looked at me blankly and said “What do you mean?” So I showed him how to enter a formula in Excel to do the calculations automatically. He looked at me sheepishly, and said thank you. That was it. Never mentioned it again, never showed up for class.

Here is my question to you: Do you know what you don’t know? Because that’s what can hurt your business.

And if you don’t know what you don’t know, that’s ok. Call us. We can help fill in the gaps.