O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Unit Contribution

The analysis of contribution margin in the case study of DVD production involved total variable costs and total revenues. You can also break the information down to a per unit and percent of sales basis. Doing so often gives you a different view of the relationship between your costs and revenues.

Calculating the Unit Contribution Margin

To continue the Discography case study, consider the information summarized in Figure 19.2 from the perspective that's provided in Figure 19.3.

Figure 19.3. You can derive a greater level of detail by breaking down the total cost information to a per unit and percent of sales basis.

The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required