Being a manager, you often find yourself in a situation where you need to analyze multiple cases that can produce entire different results. Suppose you own a small Movie store that sells DVDs at a rate of $30 per DVD. For every 100 sales, you will be making $3000. If you were to change your charges to 25% or 35%, what would be the sales then? There can be multiple scenarios where a variable can change your outcome dramatically. The Scenario Manager helps investigate such scenarios by listing down the possible outcomes of such scenarios, so that you can make a better decision.
http://www.writeawriting.com/ms-office/use-scenario-manager-goal-seek-excel-2013/
No comments:
Post a Comment