Product Profitability: Examples and Screenshots

Allocation of Support Headcount to Products by Number of Support Calls and Call Lengths

This illustration shows the editor for the variable “Support_Labor_Alloc” in ModelSheet. A single formula, seen towards the bottom, determines all of the values in the table. The pink cells contain independent formulas or data. The values in the white cells are determined by information in the pink cells.

Variable editor

Summary Report of Product Contribution Margins

This illustration shows a web worksheet in ModelSheet. Generated Excel workbooks have the same layout as the web worksheets in ModelSheet.

Web worksheet

Allocation of Engineering Manpower to Products by Teams

This table of input data, expressed in full-time equivalent engineers, specifies how engineering time is applied to products.

Table of data