Sensitivity analysis Excel Model with indifference curves
Review: 5 - "A masterpiece of literature" by , written on May 4, 2006
I really enjoyed this book. It captures the essential challenge people face as they try make sense of their lives and grow to adulthood.

# Sensitivity analysis Excel Model with indifference curves

Available: In Stock
\$0.00
Indifference curves depict sensitivity of an output to two inputs. Each curve corresponds to a fixed output amount and shows at which combination of the two inputs this output amount remains the same (or indifferent, hence the name of the chart type).

To a certain extent, this chart conveys the same information as two-dimensional data tables but provides a wider picture on the model results, a better understanding of it and looks better in clients and investors presentations.

As we go along the series lines we can, depending on the types of inputs and outputs, answer trade-off questions such as:

- if we lose a certain volume of one product, by how much shall we raise sales of another one to keep profits stable?

- if we reduce the price of a product, how much additional volume of this product do we need to sell to make this profit-neutral?

- what share of a country's market can we sacrifice if we increase our share in another country's market by x %?

- etc. etc.

We can also test our model for any weird trends or relationships against common sense and detect errors or misconceptions.

The program uses VBA, so make sure you enable macros on your computer when you open the file.

This file is fully functional but VBA code in it is locked.
Indifference curves depict sensitivity of an output to two inputs. Each curve corresponds to a fixed output amount and shows at which combination of the two inputs this output amount remains the same (or indifferent, hence the name of the chart type).

To a certain extent, this chart conveys the same information as two-dimensional data tables but provides a wider picture on the model results, a better understanding of it and looks better in clients and investors presentations.

As we go along the series lines we can, depending on the types of inputs and outputs, answer trade-off questions such as:

- if we lose a certain volume of one product, by how much shall we raise sales of another one to keep profits stable?

- if we reduce the price of a product, how much additional volume of this product do we need to sell to make this profit-neutral?

- what share of a country's market can we sacrifice if we increase our share in another country's market by x %?

- etc. etc.

We can also test our model for any weird trends or relationships against common sense and detect errors or misconceptions.

The program uses VBA, so make sure you enable macros on your computer when you open the file.

This file is fully functional but VBA code in it is locked.

No reviews yet
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)