sign in · new user? sign up
 · feedback
 
Browse Other Models

Browse Other Models
  In Marketing and Sales

Spreadsheet Template: Product Profitability

Available Versions

These are not rigid spreadsheet templates. You can customize them in dozens of ways to get the features you want while reducing unneeded complexity.

VersionDescription Download
Price
LightThe Light version has the same features as the Standard version, only it is smaller. It lets you try the customization process and download a customized working template for free. Free
StandardIncludes methods for allocating cost of goods and operating expenses from product development, marketing and support to several products. $69 $49
AdvancedIncludes all the features in the Standard version plus royalties, fixed costs of goods, and larger models with more products, marketing programs, development teams, customer support issues, job levels, and time periods. $99 $69
Advanced Extra-LargeIncludes all the features in the Advanced version, plus larger models with more of everything. $149 $99
* Customization and preview is always free. If applicable, you'll be asked to buy before downloading a working spreadsheet.
  We offer a money-back guarantee.

Customizable Feature Comparison

These are not rigid spreadsheet templates. You can customize them in dozens of ways to get the features you want while reducing unneeded complexity.


Feature Standard & Light
Versions		 Advanced & Extra-Large
Versions		 Comments
Products
Product line Check Feature form ModelSheet Check Feature form ModelSheet Several products, optionally organized in product families
Summary worksheet for each product   Check Feature form ModelSheet Includes a separate worksheet for each product that summarizes results
Cost of Goods and Gross Margin
Cost of Goods Check Feature form ModelSheet Check Feature form ModelSheet Tracks cost of goods and Cogs per unit sold and as a percentage of revenue
  • COGS types
 Check Feature form ModelSheet Check Feature form ModelSheet Tracks Cogs types (material, labor, overhead) per unit sold
  • More COGS drivers
   Check Feature form ModelSheet Tracks Cogs as fixed cost (such as cost of fixed investments)
Royalties paid   Check Feature form ModelSheet Track royalties paid on revenue, units sold, and royalties not proportional to sales (such as progress payments)
Gross Margin Check Feature form ModelSheet Check Feature form ModelSheet Computes gross margin amount and percent
Operating Expense and Contribution Margin
Marketing expense Check Feature form ModelSheet Check Feature form ModelSheet
  • Marketing staff
 Check Feature form ModelSheet Check Feature form ModelSheet Tracks marketing headcount for each product
  • Marketing programs
 Check Feature form ModelSheet Check Feature form ModelSheet Tracks marketing program expenses associated with each product, for several programs whose names you specify
Product development expense Check Feature form ModelSheet Check Feature form ModelSheet  
  • Product development teams
 Check Feature form ModelSheet Check Feature form ModelSheet Track how much product development cost of a product comes from each team
  • Engineering programs
 Check Feature form ModelSheet Check Feature form ModelSheet Tracks engineering program expenses associated with each product, for several programs you specify.
  • Product development IT / technical overhead
 Check Feature form ModelSheet Check Feature form ModelSheet Product development overhead account for IT, equipment etc.
Customer support expense Check Feature form ModelSheet Check Feature form ModelSheet  
  • Support calls
 Check Feature form ModelSheet Check Feature form ModelSheet Allocates cost of customer support calls to products
  • Support hours
 Check Feature form ModelSheet Check Feature form ModelSheet Tracks distribution of support calls by staff time consumed. Tracking staff time yields better metrics than tracking calls.
  • Support staff
 Check Feature form ModelSheet Check Feature form ModelSheet Tracks support headcount and staff utilization rate
  • Support issues
 Check Feature form ModelSheet Check Feature form ModelSheet Tracks support calls by support issues (e.g. installation, maintenance), to helps zero in on problems for specific products
Job levels Check Feature form ModelSheet Check Feature form ModelSheet Tracks employees in each department by job/pay levels
Overhead expense Check Feature form ModelSheet Check Feature form ModelSheet Applies a labor overhead rate to all departments
Time Check Feature form ModelSheet Check Feature form ModelSheet You choose start date, time grain (such as quarters, years), and time range for the analysis. Start time can be changed in Excel.
Operating margin Check Feature form ModelSheet Computes operating margin amounts and percent for each product in each time period

Version Size Limits

Feature Standard Version Advanced Version Extra-Large Version
Time periods 24 40 60
Products 20 60 90
Marketing Programs 3 6 9
Engineering programs 3 6 9
Product development teams 3 6 9
Customer support issues 2 8 12
Job levels 2 3 4
 

Copyright © 2010 by ModelSheet Software LLC | All Rights Reserved | Corporate Home | Privacy

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.