International Business Growth Radio Network
  • HOME
    • YOU >
      • Grow with Us
      • Themes
      • FAQ
    • US >
      • North American Partners >
        • North American Hosts
        • North American Directory
      • Australasia Partners >
        • Australasia Hosts
        • Australasia Directory
      • South Asia Partners >
        • South Asia Hosts
        • South Asia Directory
      • Prime Meridian Partners >
        • Prime Hosts
        • Prime Directory
      • Exec Team
    • LISTEN NOW >
      • OnAir TODAY
      • Show Notes
      • Podcasts
  • News
  • Blog
  • NETWORK
    • OnAir Talent >
      • William Eastman
      • David Wilson
      • Ellen McIlhenny
      • Angela Chaney
      • Richard Miller
      • Ravin S. Papiah
      • Steve Sweeney
      • Kasfia Rashid
      • Bob DiGiacomo
      • Lisa Askwith
      • Ally Nitschke
      • Russell Colbourne
      • Jeremy Gray
      • Raj Kapur
      • Crystal Y. Davis
      • Sarita Johan
      • Brandon Souba
      • Kevin Beers
      • Londina Cruz
      • Bert Robinson
      • Jonathan Kennedy Jr
      • Damian Johnson
      • Rick Carter
    • Agilerad.io
    • Sponsor Network
    • Special Preferences
    • Privacy
  • NOTES
  • Community
  • APP
  • SHOP

show notes

Stages of Development

Episode B.024 Operational Budget

12/6/2020

0 Comments

 
Introduction
This week we continue our focus on the post pandemic re-opening of business. Other than dealing with customer and employee fears, there is nothing different or special about today's show except urgency. Unlike other expansions at the end of a contraction, this was not a structural - it was imposed. Normally a contraction (recession) is a result of over supply and decreasing demand awaiting a unplanned event to prick the bubble. In this case the demand still exists with diminished supply and we have sufficient information to predict the beginning of an expansion. The purpose of IBGR programming this month is to prepare the entrepreneur for the turnaround. it will require acting with urgency over the next 4 months.
​

Show Objectives
Building on the A.024 Show - Cash Budget, lets contribute to the accuracy of those numbers by looking at what you contribute with this approach. The previous show analyzed what would happen if you received no more sales or additional revenue - what would happen to cash flow and how much of a line credit you need to survive - exactly the scenario most of us just lived withe pandemic forced shutdown.

What You Need to Know
The following a is an example of a spreadsheet you can build. It captures your operational focus for creating a budget and you can work forward from beginning to end or backwards end to beginning.

Forward: start with one account, you would this for every customer you have, and fill in the suspected sales numbers for the next four months. That assumes you know what the customer will buy or has on order. The math is simple and you can see how Total Revenue, Total Variable Costs, and Marin Contribution is calculated. The challenge for businesses coming out of the pandemic - I have no sales. Then let's work backwards.

Backwards: if possible for the selected customer, create another column for June of last year. Then starting on the bottom with last years margin, establish what your sales targets must be to match last years sales. This will give you an idea of how to budget for Marketing & Sales.
​
What You Need to Do
Building your Operational Budget

Sample Operational Budget Spreadsheet

June 2020
July 2020
Aug 2020
Sept 2020
Account
IBGR
Volume
P/S1
10,000
P/S2
5,000
Price Per Unit
P/S1
1.00
P/S2
2.00
Revenue
P/S1
$10,000
P/S2
$10,000
Total Revenue
$20,000
Less Variable Costs
P/S1 - Labor & Materials
3,000
P/S2 - Labor & Matwerials
4,000
Total Variable Costs
$7,000
Total Margin Contribution
$13,000
Account Margin
39.5%
As we did in the A.024 Show, our recommendation is build a multiple page (sheet or tab) spreadsheet and have this separate from the other budgets. The use a master sheet to bring all of the items forward to build a composite. The advantage - you can scenario plan by changing numners to look at the potential impact on the business.

​The best scenario is where you build the 4 Month Plan.
0 Comments



Leave a Reply.

    new choice for BUSINESS SEARCH

    ​All IBGR Shows Notes are available for download

    Authors

    - (NA) North American Radio Hosts
    ​- (AA) Australasian Radio Hosts
    - (SA) South Asian Radio Hosts
    - (PM) Prime Meridian Radio Hosts

    Archives

    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020

    Categories

    All
    Season 1 - A. Strategy
    Season 1 - B. Operations
    Season 1 - C. Sales
    Season 1 - D. People
    Season 1 - E. Ownership
    Season 1 - F. Coaching & Consulting
    Season 2 - A. Financial Results
    Season 2 - B. Operational Productivity
    Season 2 - C. Sales Effectiveness
    Season 2 - D. People Performance
    Season 2 - E. Owner As Executive
    Season 3 - C. Customers
    Season 3 - E. Executive
    Season 3 - F. Finances
    Season 3 - IBGR Specials
    Season 3 - O. Operations
    Season 3 - P. People
    Season 3 - Special Series
    Season 4 - Customers
    Season 4 - Executive
    Season 4 - Finance
    Season 4 IBGR Specials
    Season 4 - Market Domination
    Season 4 - Operations
    Season 4 - People
    Season 4 - SPECIAL SHOW
    Season 5 Customers
    Season 5 Finance
    Season 5 People
    SPECIAL EPISODE

    RSS Feed

Site powered by Weebly. Managed by Radio.co, Designed by gWORX Media
Photo used under Creative Commons from magerleagues
  • HOME
    • YOU >
      • Grow with Us
      • Themes
      • FAQ
    • US >
      • North American Partners >
        • North American Hosts
        • North American Directory
      • Australasia Partners >
        • Australasia Hosts
        • Australasia Directory
      • South Asia Partners >
        • South Asia Hosts
        • South Asia Directory
      • Prime Meridian Partners >
        • Prime Hosts
        • Prime Directory
      • Exec Team
    • LISTEN NOW >
      • OnAir TODAY
      • Show Notes
      • Podcasts
  • News
  • Blog
  • NETWORK
    • OnAir Talent >
      • William Eastman
      • David Wilson
      • Ellen McIlhenny
      • Angela Chaney
      • Richard Miller
      • Ravin S. Papiah
      • Steve Sweeney
      • Kasfia Rashid
      • Bob DiGiacomo
      • Lisa Askwith
      • Ally Nitschke
      • Russell Colbourne
      • Jeremy Gray
      • Raj Kapur
      • Crystal Y. Davis
      • Sarita Johan
      • Brandon Souba
      • Kevin Beers
      • Londina Cruz
      • Bert Robinson
      • Jonathan Kennedy Jr
      • Damian Johnson
      • Rick Carter
    • Agilerad.io
    • Sponsor Network
    • Special Preferences
    • Privacy
  • NOTES
  • Community
  • APP
  • SHOP