The analytic hierarchy (AHP) and analytic network process (ANP) are two multi-criteria decision methods (MCDM), originally developed by Prof. Thomas L. Saaty.
ANP is a more general approach, based on the description of the problem by means of a network instead of a hierarchy as in AHP. On the other hand, ANP is also more complex in its application.
In my latest video presentation, pros and cons for both methods are shown, and a few tips for the practical application of AHP, and setting up a network for ANP are listed.
Link to video in Youtube
Feel free to
comment and feedback here!
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 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):
Slides (pdf) of my Youtube video: “ Conjoint Analysis in ten minutes“.
Conjoint analysis online – Conjoint.ly
Please feel free to leave a comment on my
You might download the slides of my video presentation in Youtube: “
Conjoint Analysis in ten minutes” here:
Download Slides (pdf)
You can find the Conjoint Analysis Example in Excel
NEW! BPMSG’s free AHP online software: For a quick evaluation of priorities use my AHP online calculator. If you need to handle a complete AHP hierarchy, try out my new AHP-OS System.
Download page of the AHP Excel Template:
Older Versions for tracking purpose: please contact the author.