Product Profitability Analysis

Your Problem

You need to compare the profitability of various products in your portfolio. It is required that you consider important aspects related to the products your company sells, including the unit cost, price and marketing costs.

Our Solution

We created a Microsoft Excel Product Profitability Analysis tool to analyze each product your company sells. To use this tool, first list out each of the products your company commercializes, and then complete the remaining information that is requested. The information required includes the Product Name, Price, Unit Cost, Unit Sales, Revenues, Costs of Goods Sold, Gross Contribution, Marketing & Sales Costs, Product Profit/Loss, and Gross Margin. Once the information has been entered, you will be presented with a graphical representation of the data.

For background info, read our Executive Summary: Analyzing the Profitability of Product Lines. Download our free Product Development Strategy Methodology to see how this tool functions as part of a product development process.

Key Benefits

• identifies top performing products
• allows you to cut unprofitable product lines
• automatically creates charts
• save 3 hours on formatting
• easily customizabel to suit your needs

Microsoft Excel Spreadsheet

Estimated Time Required: 1 Hour

Skills Required: Analytical