Decision Maker Tool (DEMO)
Originally published: 16/07/2019 13:20
Last version published: 31/10/2019 09:52
Publication number: ELQ-51598-5
View all versions & Certificate
certified

Decision Maker Tool (DEMO)

Excel tool to help make difficult decisions, when faced with a number of similar or competing options.

Description
NOTE: An UNLOCKED version of this model can be purchased at: https://www.eloquens.com/tool/rGYKh70G/excelmodels/decision-maker-tool-unlocked


● Objective inputs = surprising results
● Alternatives scored in a single chart
● Abide the Decision!

This model contains the following elements:
● Let Excel help make an important decision for you, by quantifying the qualitative
● Specify the various Options and Key Factors involved in Decision
● Model calculates a numerical Score for each Option, and compares them in a single graph
● Objective inputs can yield surprising answers!

This highly customized Excel tool takes subjective input from the user, prompting them to score and weigh simple decision criteria in order to produce an objective decision.

Seeing the different possible outcomes graphed and scored against each other can produce surprising reactions, or help underscore how well the user's gut instincts measure up when honestly compared with competing alternatives.

As with all models at ExcelModels, this workbook contains separate tabs containing integrated financial statements: Income Statement, Balance Sheet, and Cash Flow Statement. All checks and balances are in-place, highlighting areas (such as a negative cash balance) where the user needs to adjust assumptions elsewhere.

This template contains clearly-labeled input cells. All other cells are locked for calculation, labeling, or other use. This focuses the user on the Key Assumptions they have control over, and prompts an accurate forecast.

We also provide model customization and build-out on an hourly or project basis. Please contact us for more information. Thanks.

This Best Practice includes
1 Excel file

ExcelModels offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.7 / 5 (3 votes)

please wait...