1. Welcome to Tundras.com!

    You are currently viewing as a guest! To get full-access, you need to register for a FREE account.

    As a registered member, you’ll be able to:
    • Participate in all Tundra discussion topics
    • Transfer over your build thread from a different forum to this one
    • Communicate privately with other Tundra owners from around the world
    • Post your own photos in our Members Gallery
    • Access all special features of the site

hey smart people - break even analysis?

Discussion in 'Off-Topic Discussion' started by smslavin, Nov 8, 2018.

  1. Nov 8, 2018 at 2:46 PM
    #1
    smslavin

    smslavin [OP] Behind a lens...

    Joined:
    Jul 15, 2017
    Member:
    #8578
    Messages:
    7,208
    Gender:
    Male
    First Name:
    Sean
    Hudson Valley
    Vehicle:
    2016 Tundra CrewMax SR5
    Some stuff
    need some input from people smarter than i. trying to work out some numbers for a break even analysis but i'm struggling. given this equation...

    revenue per unit - variable expenses per unit = contribution margin per unit

    i know how to work it out for a single product but, what if i have multiple products and each product has it's own set of variable expenses? do i calculate one for each product? if yes, how does that go into this equation...

    fixed expenses per day ÷ contribution margin per unit = break-even point in units per day

    would i wind up with multiple break even points? if so, how do i reconcile them?

    once i have the break even point, i can put that into dollars.

    now, building on that, how do you build a cash flow projection where your unit sales are variable each month?
     
    Notachickmagnet likes this.
  2. Nov 8, 2018 at 2:48 PM
    #2
    T-Rex266

    T-Rex266 Elon approved Staff Member

    Joined:
    Jan 5, 2014
    Member:
    #6
    Messages:
    155,879
    Gender:
    Male
    My head hurts
     
    Rica25, Matty4wd, BTBAKER and 14 others like this.
  3. Nov 8, 2018 at 2:56 PM
    #3
    TXMiamiFan

    TXMiamiFan SSEM #3 and tractor extraordinaire

    Joined:
    Nov 26, 2015
    Member:
    #2160
    Messages:
    25,307
    Gender:
    Male
    First Name:
    Jose
    Houston, TX
    Vehicle:
    2016 White Crew Max TRD
    TRD Pro Grille, ESP Storage, Tailgate Inserts, Line-X Bedliner, Weathertech Floorliners, Wet Okole Seat Covers, 5" Shorty Antenna, Mickey Thompson MM-366 Wheels, ToyTec Boss, 35" BFG KO2 to name a few.
    Depends what the variable expenses are. For example, in our warehouse, we allocate variable expenses by item/customer based on the number of touches, labels, size and volume that moves thru the building. I built a microsoft access database that allocates the costs based on these variables. Once you are down to the lowest denominator, you can roll it up and calc break even point at a company level. If trying to do this by item, then you would have to allocated fixed expenses by item based on whatever metric you want: % of total volume, space used, weighted average, etc.

    They way we reconcile it is vs the actual expenses listed on the invoice (also helps validate invoices before payment). So my warehouse budgets are based on past history of my variable expenses x the forecast. If all things remain =, then it should balance.

    Once you know the variable expenses by item, you can use those # against sales projections to get your contribution margin. You already know your fixed expenses so it should be math at that point. The hardest part is determining how you want to allocate variable expense by item.
     
    Ike74, tinman10101, JC303 and 6 others like this.
  4. Nov 8, 2018 at 2:58 PM
    #4
    Marty McFly

    Marty McFly Nobody calls me chicken!! Except when off roading

    Joined:
    Oct 24, 2016
    Member:
    #4983
    Messages:
    6,125
    Gender:
    Male
    First Name:
    Morty McBoonJug
    McBoonJug = McDonald’s and Moonshine in a Jug
    Vehicle:
    2016 StormTrooper Tundra CrewMax TRD PRO













    Just what I suspected. Yep I’ve got nothing.
     
    Last edited: Nov 8, 2018
  5. Nov 8, 2018 at 3:03 PM
    #5
    smslavin

    smslavin [OP] Behind a lens...

    Joined:
    Jul 15, 2017
    Member:
    #8578
    Messages:
    7,208
    Gender:
    Male
    First Name:
    Sean
    Hudson Valley
    Vehicle:
    2016 Tundra CrewMax SR5
    Some stuff
    that just put me in the right direction. so, a little noodling and i'm going to use this...

    fixed expenses per day / weighted avg selling price - weighted avg variable expenses = break-even point in units per day

    now, i just need to take a random dart board guess at how many units of each product will sell...
     
    Watt maker and Marty McFly like this.
  6. Nov 8, 2018 at 3:05 PM
    #6
    TXMiamiFan

    TXMiamiFan SSEM #3 and tractor extraordinaire

    Joined:
    Nov 26, 2015
    Member:
    #2160
    Messages:
    25,307
    Gender:
    Male
    First Name:
    Jose
    Houston, TX
    Vehicle:
    2016 White Crew Max TRD
    TRD Pro Grille, ESP Storage, Tailgate Inserts, Line-X Bedliner, Weathertech Floorliners, Wet Okole Seat Covers, 5" Shorty Antenna, Mickey Thompson MM-366 Wheels, ToyTec Boss, 35" BFG KO2 to name a few.
    Magic eight ball is a better predictor of sales IMO
     
    Ike74, tinman10101, UNTMatt and 7 others like this.
  7. Nov 8, 2018 at 3:05 PM
    #7
    Blueknights75

    Blueknights75 040 IS THE FASTEST

    Joined:
    May 13, 2018
    Member:
    #15276
    Messages:
    4,431
    Gender:
    Male
    First Name:
    Ron
    Clayton, NC
    Vehicle:
    18’ TRD CM leveled with 295/70 Ridge Grapplers
    Pimpin ain’t easy obviously!
     
  8. Nov 8, 2018 at 3:06 PM
    #8
    TXMiamiFan

    TXMiamiFan SSEM #3 and tractor extraordinaire

    Joined:
    Nov 26, 2015
    Member:
    #2160
    Messages:
    25,307
    Gender:
    Male
    First Name:
    Jose
    Houston, TX
    Vehicle:
    2016 White Crew Max TRD
    TRD Pro Grille, ESP Storage, Tailgate Inserts, Line-X Bedliner, Weathertech Floorliners, Wet Okole Seat Covers, 5" Shorty Antenna, Mickey Thompson MM-366 Wheels, ToyTec Boss, 35" BFG KO2 to name a few.
    Nope. It's hard out here for a pimp.
     
    Rica25, Ike74, ColoradoTJ and 7 others like this.
  9. Nov 8, 2018 at 3:07 PM
    #9
    smslavin

    smslavin [OP] Behind a lens...

    Joined:
    Jul 15, 2017
    Member:
    #8578
    Messages:
    7,208
    Gender:
    Male
    First Name:
    Sean
    Hudson Valley
    Vehicle:
    2016 Tundra CrewMax SR5
    Some stuff
    well, i have a prediction of what i want for each product for the year plus a growth estimate for three years out. numbers are based on past history and slightly on the conservative side.
     
  10. Nov 8, 2018 at 3:32 PM
    #10
    mdavis

    mdavis I need a beer.

    Joined:
    Feb 13, 2015
    Member:
    #966
    Messages:
    3,345
    Gender:
    Male
    First Name:
    Michael
    Rock Hill, SC
    Jose dropping knowledge.
     
  11. Nov 8, 2018 at 3:35 PM
    #11
    ninjajay

    ninjajay Posting from the toilet

    Joined:
    Dec 28, 2017
    Member:
    #11787
    Messages:
    2,155
    Gender:
    Male
    First Name:
    Jason
    Spoolston, TX
    Vehicle:
    2018 MGM 1794 TRD 4x4
    Toytec/Radflo Lift, Ambit RS02 18x9+0, Bridgestone Revo 3 295/70/18
    You need to factor in cost of capital
     
    Black Wolf and TXMiamiFan like this.
  12. Nov 8, 2018 at 3:38 PM
    #12
    smslavin

    smslavin [OP] Behind a lens...

    Joined:
    Jul 15, 2017
    Member:
    #8578
    Messages:
    7,208
    Gender:
    Male
    First Name:
    Sean
    Hudson Valley
    Vehicle:
    2016 Tundra CrewMax SR5
    Some stuff
    i have a 5 year depreciation schedule for long term assets but i'm under the assumption that goes into a cash flow statement not a break even analysis. am i wrong?
     
  13. Nov 8, 2018 at 3:43 PM
    #13
    ninjajay

    ninjajay Posting from the toilet

    Joined:
    Dec 28, 2017
    Member:
    #11787
    Messages:
    2,155
    Gender:
    Male
    First Name:
    Jason
    Spoolston, TX
    Vehicle:
    2018 MGM 1794 TRD 4x4
    Toytec/Radflo Lift, Ambit RS02 18x9+0, Bridgestone Revo 3 295/70/18
    Cost of working capital. Without that information, you're assuming your "do nothing" scenario has a zero return.
     
    smslavin[QUOTED][OP] likes this.
  14. Nov 8, 2018 at 3:54 PM
    #14
    TXMiamiFan

    TXMiamiFan SSEM #3 and tractor extraordinaire

    Joined:
    Nov 26, 2015
    Member:
    #2160
    Messages:
    25,307
    Gender:
    Male
    First Name:
    Jose
    Houston, TX
    Vehicle:
    2016 White Crew Max TRD
    TRD Pro Grille, ESP Storage, Tailgate Inserts, Line-X Bedliner, Weathertech Floorliners, Wet Okole Seat Covers, 5" Shorty Antenna, Mickey Thompson MM-366 Wheels, ToyTec Boss, 35" BFG KO2 to name a few.
    Don’t recall. Has been years since I’ve done accounting and financial statements
     
  15. Nov 8, 2018 at 4:01 PM
    #15
    Darkness

    Darkness Allergic to white

    Joined:
    Jul 23, 2018
    Member:
    #17315
    Messages:
    9,976
    Gender:
    Male
    First Name:
    Luis
    All over SoCal
    Vehicle:
    The darkest
    It's really dark
    I need 3 beers before I can do this
     
  16. Nov 8, 2018 at 4:03 PM
    #16
    Professional Hand Model

    Professional Hand Model A.K.A ‘Golden Hands’

    Joined:
    Apr 29, 2018
    Member:
    #14878
    Messages:
    15,007
    Gender:
    Male
    First Name:
    Fred
    ‘Somewhere’... a State of Mind
    Vehicle:
    2002 Tundra SR5 4WD 4.7L AC Silver Metallica
    Hand Protectors
    Set a base cost of the widget for sale. Then adjust your variables ‘UP’ as the variable rises in cost. As a general rule, items alway ‘INCREASE’ in cost so move your base variable ‘UP’ each quarter.

    Assuming you have a history with you product, you will begin to develop ratios for each widget as time goes along. Each ratio is applied how you see fit depending on demand and supply.

    Business and sales, especially with variable cost products, are a combo of art and science that hopefully lets you make the proper ‘PROJECTION’.
     
    Watt maker, smslavin[OP] and Darkness like this.
  17. Nov 8, 2018 at 4:06 PM
    #17
    15whtrd

    15whtrd Mr. Blonde

    Joined:
    Sep 20, 2015
    Member:
    #1829
    Messages:
    9,387
    Gender:
    Male
    First Name:
    Sean
    SoCal
    Vehicle:
    White 2015 Tundra DC SR5 TRD 4x4 5.7L, White 2003 Sequoia 2WD
    TRD Pro suspension, +2 Coachbuilder shackles, 2015 TRD Pro headlights, 20% ceramic tinted windows, clear ceramic tinted front windshield, aFe drop in pro s dry air filter, TRD airflow accelerator, TRD oil fill cap, TRD 18 psi radiator cap, BDX Bullydog tuner, Weathertech floor mats front and rear, rear seat fold down mod, DNA hard trifold tonneau cover, Linex with uv protection, TRD rear swaybar, TRD center caps, TRD Pro grille insert with color matching surround and bulge, TRD PRO headlights, aluminum oil filter canister, Real truck tailgate seal, Pop-n-lock tailgate lock actuator, rear diff breather relocate, RCI front skid plate. 275/70 R18 BFG KO2s
    You lost me on the first post. My head hurts
     
  18. Nov 8, 2018 at 4:07 PM
    #18
    War Machine

    War Machine SSEM # 5 3MW

    Joined:
    Aug 7, 2017
    Member:
    #8939
    Messages:
    16,910
    Gender:
    Male
    First Name:
    Jason
    Texas
    My wife is really good at this stuff. Unfortunately, she’s not speaking to me, so good luck.

    Unfortunately for you I mean. It’s a pretty decent deal on my end.
     
  19. Nov 8, 2018 at 4:09 PM
    #19
    TXRailRoadBandit73

    TXRailRoadBandit73 YOTAS,RAILROADER,RÖKnRÖLLN',BEER,MAX/GEMMA

    Joined:
    May 30, 2016
    Member:
    #3487
    Messages:
    50,312
    Gender:
    Male
    First Name:
    Adam
    The 956, TEXAS
    None yet
    :rofl:
     
  20. Nov 8, 2018 at 4:10 PM
    #20
    TXRailRoadBandit73

    TXRailRoadBandit73 YOTAS,RAILROADER,RÖKnRÖLLN',BEER,MAX/GEMMA

    Joined:
    May 30, 2016
    Member:
    #3487
    Messages:
    50,312
    Gender:
    Male
    First Name:
    Adam
    The 956, TEXAS
    None yet
    Thought this was about Tundras and the missing 10mm socket and popping noise after start up
     
  21. Nov 8, 2018 at 4:15 PM
    #21
    Professional Hand Model

    Professional Hand Model A.K.A ‘Golden Hands’

    Joined:
    Apr 29, 2018
    Member:
    #14878
    Messages:
    15,007
    Gender:
    Male
    First Name:
    Fred
    ‘Somewhere’... a State of Mind
    Vehicle:
    2002 Tundra SR5 4WD 4.7L AC Silver Metallica
    Hand Protectors
    I’d be nice if your variable cost suppliers would send you their formulas. Ain’t gonna happen. Key is to try and figure out their ‘formula’ then you just do a multiplier on your end.

    What are we selling by the way?
     
    smslavin[OP] likes this.
  22. Nov 8, 2018 at 4:20 PM
    #22
    15whtrd

    15whtrd Mr. Blonde

    Joined:
    Sep 20, 2015
    Member:
    #1829
    Messages:
    9,387
    Gender:
    Male
    First Name:
    Sean
    SoCal
    Vehicle:
    White 2015 Tundra DC SR5 TRD 4x4 5.7L, White 2003 Sequoia 2WD
    TRD Pro suspension, +2 Coachbuilder shackles, 2015 TRD Pro headlights, 20% ceramic tinted windows, clear ceramic tinted front windshield, aFe drop in pro s dry air filter, TRD airflow accelerator, TRD oil fill cap, TRD 18 psi radiator cap, BDX Bullydog tuner, Weathertech floor mats front and rear, rear seat fold down mod, DNA hard trifold tonneau cover, Linex with uv protection, TRD rear swaybar, TRD center caps, TRD Pro grille insert with color matching surround and bulge, TRD PRO headlights, aluminum oil filter canister, Real truck tailgate seal, Pop-n-lock tailgate lock actuator, rear diff breather relocate, RCI front skid plate. 275/70 R18 BFG KO2s
    You’re killing me over here. I literally laughed out loud. My wife looked at me but I refused to tell her what I’m laughing at. Oh nothing honey!
     
  23. Nov 8, 2018 at 4:20 PM
    #23
    Darkness

    Darkness Allergic to white

    Joined:
    Jul 23, 2018
    Member:
    #17315
    Messages:
    9,976
    Gender:
    Male
    First Name:
    Luis
    All over SoCal
    Vehicle:
    The darkest
    It's really dark
    Get her a bread maker :D
     
  24. Nov 8, 2018 at 4:25 PM
    #24
    Viper

    Viper New Member

    Joined:
    Oct 28, 2018
    Member:
    #21068
    Messages:
    27
    Gender:
    Male
    First Name:
    C.
    Vehicle:
    2018 SR5 TRD Dbl cab cement
    The solution to this is so simple if you break it down to the basic formula of cost per x item multiplied by the total equation. Once this number is confirmed breakdown the final product as being A = .35 + 18 (A=D x .65= 9/57 + 19) :taco:
     
    Black Wolf likes this.
  25. Nov 8, 2018 at 4:37 PM
    #25
    smslavin

    smslavin [OP] Behind a lens...

    Joined:
    Jul 15, 2017
    Member:
    #8578
    Messages:
    7,208
    Gender:
    Male
    First Name:
    Sean
    Hudson Valley
    Vehicle:
    2016 Tundra CrewMax SR5
    Some stuff
    :thumbsup:

    my supplier costs are fixed. their prices increase but usually at an annual rate. some haven't gone up in years. it's the amount of things i bundle with my products that makes my costs variable.

    putting a plan together to get out of the day job and back to shooting full time.
     
    Watt maker and TXMiamiFan like this.
  26. Nov 8, 2018 at 4:39 PM
    #26
    Azblue

    Azblue Beer is Good Ban Moderator

    Joined:
    Nov 17, 2017
    Member:
    #11025
    Messages:
    6,226
    Gender:
    Male
    The Dirty T
    OK, let me give it a go in terms that I can understand.

    Increase in happiness (#of beers consumed) - sadness (watching beer supply drop as a result) + relief (realizing the wife bought more beer today) / quantity (how much beer did she buy) x temperature (did she put it in the fridge early enough) = The grand total +/- of the break even point.


    Of course there are variables that can be added to this equation such as ability to function (did she also purchase whiskey), but I don't want to over complicate things.
     
    Inquiringone, JMB, Black Wolf and 7 others like this.
  27. Nov 8, 2018 at 4:58 PM
    #27
    Professional Hand Model

    Professional Hand Model A.K.A ‘Golden Hands’

    Joined:
    Apr 29, 2018
    Member:
    #14878
    Messages:
    15,007
    Gender:
    Male
    First Name:
    Fred
    ‘Somewhere’... a State of Mind
    Vehicle:
    2002 Tundra SR5 4WD 4.7L AC Silver Metallica
    Hand Protectors
    In the spirt on keeping things simple, here is how I achieve my formula for making money. Feel free to use it. It works!

    Start with how much money do you want to make. For grins lets say $150k.

    Now, ask how many days do you want to work. For grins lets say 150.

    Now, you know you need to make $1000 a day.

    Now add your costs plus 30% and charge them on top of your $1000 a day.

    Break your labor days into half (minimum $500) or full ($1000).

    And always pay your taxes on time!
     
  28. Nov 8, 2018 at 5:29 PM
    #28
    joonbug

    joonbug °°°°°°°°°°

    Joined:
    Oct 13, 2015
    Member:
    #1948
    Messages:
    16,674
    Gender:
    Male
    First Name:
    Joon
    NorCal - Dublin
    Vehicle:
    2020 Long Travel DC
    4. That’s my final answer.
     
  29. Nov 8, 2018 at 5:44 PM
    #29
    Thegr8punkin

    Thegr8punkin A G.D.M/Sofa King Cool/COTJ's dreamboat

    Joined:
    Jan 18, 2017
    Member:
    #6015
    Messages:
    5,365
    Gender:
    Male
    First Name:
    Connor
    Northern Colorado
    Vehicle:
    08 blue sr5 2wd
    2 +5 hp stickers
    That doesn’t happen often, better take a picture
     
  30. Nov 9, 2018 at 5:43 AM
    #30
    Grumpy Uncle

    Grumpy Uncle Pushing string down the hall SSEM #10

    Joined:
    Jul 29, 2017
    Member:
    #8801
    Messages:
    12,888
    Gender:
    Male
    First Name:
    Pat
    CO
    Vehicle:
    2016 Black CM Tundra TRD Off Road
    4:88s and Auburn LSD, dealership faux Pro, 35" BFGs on XD wheels, OME Lift with Dakars
    I'll just sit here and continue licking the monitor.
     

Products Discussed in

To Top