Business Analysis with Microsoft® Excel, Second Edition

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 ...