This Analysis is for Brick & Mortar Business Owners to Show the % Occupancy Level Where They Turn Profitable During Covid-19 Social Distancing


Visit our store to download a free copy of the CONTRIBUTION MARGIN spreadsheet.

VIDEO TRANSCRIPT

This is Neil Portus from Tailored Partners. I work as a freelance CFO for growth companies.

As government’s make plans to reopen businesses following Covid-19 closures, capacity levels at many brick-and-mortar businesses may be limited by law or by new consumer habits or both. Hotels, restaurants, coffee shops, retail stores and music venues may operate at limited capacity to allow for social distancing.

So, I want to show an analysis that can help brick-and-mortar business owners understand the percent capacity at which they can operate profitably. It’s a unit contribution margin analysis. Let’s go ahead and dive in.

Two points to start. First, this is a unit economics analysis because we want to know the number of units or in this case the number of customers that we need to be profitable. Second, we’ll need separate our variable costs from our fixed costs. Variable costs are those driven by volume while fixed cost will be incurred no matter how many people are in our store. Rent is a good example of a fixed cost. This is why I want to show a unit contribution margin analysis.

Contribution margin is simply revenues generated from a sale or order minus the variable cost of a fulfilling that order: materials, wages, etc. Here’s a simple, made up calculation shown on a per unit or per customer basis. This business makes $11 in revenue per customer on average with $5 of variable costs, leaving a $6 unit contribution margin.

Now, let’s put this into an analysis for a business owner to use. Pick a time period that you’re considering reopening – let’s say June. Now, I think you’ll want have an understanding of the number of customers that you serve when operating at full capacity. Perhaps we had 1,000 customers in June last year but this June we may only operate at 35% capacity. That means we’re only expecting 350 customers. If we use the $6 unit contribution margin that we calculated before times 350 expected customers our gross contribution margin is going to be $2,100. Next we need to subtract our fixed costs which we estimate to total $3,000. So, here we see that at 35% capacity we’ll operate at a loss of $(900). But if we move the percent occupancy up to 50% we see that means we are now expecting 500 customers and our gross contribution margin increases to $3,000 which equals our fixed cost and means that we’ll break even. Once we move the occupancy above 50%, we see that we start to turn a profit. So, at 50% capacity we break even and above that we start to turn a profit.

Now one final thing – even if you don’t have exact numbers on a per-unit basis, I think that even a rough picture will still be a helpful guide. Even with perfect numbers an analysis like this won’t be the only reason to reopen at a certain time. Just one of the many factors supporting a decision of when to open.

 

Copyright 2020 Neil Portus | Please see our disclaimers.

The Most Powerful Excel Formula for Startup Founders and Business Owners During Covid-19


Visit our store to download a free copy of the =CHOOSE formula spreadsheet.

VIDEO TRANSCRIPT

This is Neil Portus from Tailored Partners. I work as a freelance CFO for growth companies and I wanted to share what I think is the most powerful, most valuable Excel formula right now during Covid-19:

And that’s the =CHOOSE formula.

So, this video is for startup founders and business owners to show them how they can take their existing Excel budgets and models and by adding in the =CHOOSE formula to their key drivers & their key assumptions model out different revenue and expense scenarios in order to see the impact on the bottom line and make important planning decisions for their company. All in about a minute. Let’s dive in.

Ok, here’s a simple profit and loss statement down to operating income. I’m going to paste in the three scenarios I want to test. I’ll start entering my =CHOOSE formula. The first cell reference will be the one that we will use the toggle between the three scenarios. I’ll lock in that cell reference by hitting F4 which puts those two dollar signs there. You’ll see that I’m using the =CHOOSE formula for each key driver in this model: number of units sold, price per unit, cost per unit & each of the key operating expenses. No need to do every possible input; just focus on the important ones that drive the model. Also, you can have as few or as many scenarios as you want just separate each one with a comma in the formula. I’ll copy this formula down to the rest of the operating expenses and make all these fonts black now that they’re formulas.

Now, we are ready to toggle between our three scenarios to see the impact on operating income.

 

Copyright 2020 Neil Portus | Please see our disclaimers.

Applying Bacon’s Law (aka Six Degrees of Kevin Bacon) to #WFH Business Development in 2020


This article was featured on the Autonomy.Paris Urban Mobility Daily newsletter.

Covid-19 and the shelter-in-place orders that followed have forced many of us to work from home, popularizing the #WFH hashtag. Virtually every role at every company has been affected as a result.

One role in particular that has seen tremendous impact is that of business development. The familiar ways of developing and closing on new business have vanished: in-person meetings, networking events, trade shows and conferences. A phone or video call used to only be the initial set up to an in-person meeting.

With so many businesses retrenching and cutting costs, for those of us working from home who are fortunate enough to be safe and healthy, taking this time of self-isolation to actively plan for the future and new ways of generating income is very top of mind.

However, the old playbook will not work. In fact, striking the wrong chord may cause more harm than good. Personally, I’ve seen more #Fails than #Wins from the outreach emails I’ve received during this time from communication that ignores our current state or pushes a product that’s currently irrelevant. Business development in this time can be daunting.

That said, new opportunities will emerge. There may be a new normal but there will be opportunities to do good work and build and sell good products. Mobility, as much as any other industry, is facing massive disruption which will lead to new innovation.

So, with all of this opportunity ahead, how does one thoughtfully think about business development in 2020?

I wanted to share my personal framework which is based on “Bacon’s Law” stemming from folklore surrounding the American actor, Kevin Bacon. The basic idea is that you are connected to any other person on Earth through six or fewer people. It’s this concept that I think applies to business development during and emerging from Covid-19 (and I think can also apply to anyone job searching in this time). Here’s how I see it:

0 Degrees of Seperation: Start with Who You Know

These are the people you already know simply put. The people you have met or, better yet, worked with before. These connections are formed and you can pick things up with a phone or video call. Even better, many of them probably want to hear from you during these isolating times! This group is your best bet to form something new and move forward. I would be reaching out and checking in with this group and exhausting all possibilities before moving forward anywhere else.

1 to 2 Degrees of Separation: Showcasing the Urban Mobility Challenge

Looking beyond your “0 Degree” contacts has potential but it’s worth proceeding cautiously.

My first thought is to approach your closest “0 Degree” connections for referrals and introductions. For my own CFO-services consulting business, Tailored Partners, referrals have been my greatest source of new clients. I expect that to continue in 2020.

However, there may come a time when you’ve exhausted your “0 Degree” connections and their potential for introductions and referrals. This is where I believe something innovative like the Urban Mobility Challenge comes into play and is worth showcasing as a prototype.

Just launched by the Urban Mobility Company and inaugurated by the Nissan Innovation Lab, the all-digital Urban Mobility Challenge is an example of an offering well suited for any time – but certainly uniquely well positioned for business development in 2020.

Briefly, the Urban Mobility Challenge is a 3-step program designed to allow companies to quickly discover, meet and select the most innovative startups with which to develop a proof of concept. It’s a digital funnel which provides exclusive access to Autonomy’s community of +10,000 startups from around the world. The Urban Mobility Company takes care of everything from beginning to the end and all pitch sessions and meetings are done virtually. Further, corporate partners and winning startups will be promoted through content pieces distributed to the Urban Mobility Company’s audience of more than 10,000 professionals via its digital content platforms the Urban Mobility Daily and the Urban Mobility Weekly and showcased at Autonomy 2020’s Startup District this November 4-5, 2020.

I think the value proposition is compelling. You can access and leverage Autonomy’s entire ecosystem, which has taken years and millions of Euros to build, in a span of weeks and for a relatively lower cost. For many companies, I think that will be a valuable trade (and perhaps covered not through new spend but by repurposing existing budget that may be underutilized or not used).

Further, the startups you meet may be more eager than you to connect as they too are seeking new partnerships in this time. You know Autonomy, they know Autonomy and you can both leverage the trust in that relationship to build something new together. It seems like the ingredients for a win-win outcome.

3-6 Degrees of Separation: Content is King

Looking out to contacts that are 3-6 degrees of separation away, personally, I think the best way to reach and engage this group will be through creating and distributing valuable content.

In-bound communication from a person or company you don’t know is a quick delete and unsubscribe for me right now.

However, new content that solves a problem or addresses something of interest is king. Cash is king they say. That certainly is still true today but perhaps we can also say that content is king too.

The most valuable content to me right now is that which I’ve sought out and solves a problem for me. I think that content which meets an interest or need is going to win new attention which can translate into new business. People are looking for solutions and, if you can provide that, you will be winning new customers.

It’s worth noting that the Urban Mobility Challenge’s value proposition extends here to 3-6 degrees of separation through its co-creation of relevant content and distribution through the Urban Mobility Daily & Weekly channels, vastly expanding the reach of your group of 3-6 degree contacts.

 

Copyright 2020 Neil Portus | Please see our disclaimers.