Рет қаралды 15,621
If you need to find the breakeven point in Excel with one product, it is fairly easy. It gets tricky with multiple products. This is how to get the weighted average contribution margin and calculate the break-even in units with 2 or more products. This is used for Cost-Volume-Profit Analysis.
Cost-Volume-Profit Analysis with multiple products. The contribution margin is a company's sales less its variable expenses. Then, divide the company's fixed costs by the contribution margin. This will give you the company's break-even point in total dollars of sales.
To create a cost-volume-profit (CVP) Chart or Breakeven-Analysis Chart, see my video • Break-even analysis in...
I train the Executive MBA students from the University of Georgia in Excel. Feel free to visit my website or sign up for my free class on Excel Tables.
www.chrismenardtraining.com
chrismenardtrai...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ KZbin keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!