In This Chapter
Understanding how profit-volume-cost analysis works
Calculating breakeven points
Using real QuickBooks data for profit-volume-cost analysis
Dealing with some minor conundrums
Using the Profit-Volume-Cost Analysis workbook
Dealing with vary-with-profit costs
Profit-volume-cost analysis is a powerful tool that estimates how a business's profits change as the sales volumes change as well as breakeven points. (A breakeven point is the sales revenue level that produces zero profits.)
Profit-volume-cost analysis often produces surprising results. Typically, the analysis shows that small changes in a business's sales volume produce big changes in profits.
Hotels and airlines are types of businesses that often see surprising fluctuations in their profits based on relatively modest changes in their sales revenue. Indeed, now that you know this, you'll probably notice that investment analysts often use small changes in hotel occupancy and in airline load factors (the percentage of seats filled on a plane) to explain big changes in profits.
The first part of this chapter talks about the theory of profit-volume-cost analysis. Understanding the theory may be all you need in order to apply this tool to your specific setting. At the end of the chapter, I describe an Excel workbook that you can use for more sophisticated profit-volume-cost analysis. That workbook is available to download from my Web site at
www.stephenlnelson.com/pvc.xls. (You can ...