Hi All -
I'm not sure I'm doing the CTE() portion of Task 2 right...wanted to hear your ideas.
To assess what the price would be at a given profit level, and a given CTE level, say profit of 10% and CTE(95), I was doing a Goal-Seek on cell H11 of the Summary Statistics section. H11 is calculating the % of scenarios below the target profit threshold (10%), so to calculate CTE(95), I'd do a goal seek, where I'm setting H11 to 5% (because CTE(95) indicates that 5% of scenarios would be below the target level), by changing the Price cell...
Is that overcomplicating things? Should we simply be setting the goal-seek on the profit column, in column I, setting equal to the profit level we want to achieve, next to the related CTE options?
Any help is appreciated!
Ezzy
I'm not sure I'm doing the CTE() portion of Task 2 right...wanted to hear your ideas.
To assess what the price would be at a given profit level, and a given CTE level, say profit of 10% and CTE(95), I was doing a Goal-Seek on cell H11 of the Summary Statistics section. H11 is calculating the % of scenarios below the target profit threshold (10%), so to calculate CTE(95), I'd do a goal seek, where I'm setting H11 to 5% (because CTE(95) indicates that 5% of scenarios would be below the target level), by changing the Price cell...
Is that overcomplicating things? Should we simply be setting the goal-seek on the profit column, in column I, setting equal to the profit level we want to achieve, next to the related CTE options?
Any help is appreciated!
Ezzy
BBA Task 2
0 commentaires:
Enregistrer un commentaire