How to determine the minimum or maximum value to change ranking

My question is regarding supplier scorecards in Excel. Example) There are three vendors, three factors (ie. Quality, Performance, Cost) and their respective weighting (ie. 30%, 40%, and 30%). The table contains the score (value x weighting) and provides a ranking of which supplier is considered “best”. Is there a macro or built in tool within Excel that would calculate how much a weighting would need to change or a change in the combination of weights that would need to change in order for the supplier rank to change from say 1 to 2?

By: Steve

Leave a Reply

Your email address will not be published. Required fields are marked *