Profit per Cost (PPC)

The basic equation – financial performance indicators: Profit per Cost (PPC)

With Profit per Cost (PPC) we introduce another important financial key ratio. Cost per order (CPO) together with profit per cost (PPC) let you calculate the required gross margin percentage (GMP) and the profitability (PR).

Vice versa, with a given gross margin and a targeted profitability, you can estimate the CPO and PPC.

Conjoint Analysis – Example in Excel

Conjoint analysis or stated preference analysis is used in many of the social sciences and applied sciences including marketing, product management, and operations research.

Here you find an simple example, how you can calculate part-worth utilities and relative preferences in Excel using multi-variable linear regression. (4 attributes, 2 level, fractional design)

PLEASE READ before DOWNLOAD
The template is free. So I would really appreciate, if you could – at least – rate the template at the bottom of this post. Thank you!

Download Conjoint Analysis Example in Excel (zip):  download

Download Slides (pdf) of my Youtube video: “Conjoint Analysis in ten minutes“.

Conjoint analysis onlineConjoint.ly

Please feel free to leave a comment on my feedback page.
Contact

Incoming search terms:

  • conjoint analysis example
  • conjoint analysis excel
  • conjoint analysis in excel
  • conjoint analysis excel template
  • conjoint analysis example excel
  • conjoint analysis excel example

Video Collection Business Performance KPIs

Here you find information and links to my collection of  videos about business performance management and other topics.

Episodes published (June 2013):

Some additional videos are available on my Youtube Channel:  https://www.youtube.com/bpmsg

I appreciate your comments and feedback.