opportunity prior it ization

Input Data

JobImportance
Administrator: Importance is a function of the percentage of respondents who rated a job as very important (4) or extremely important (5). If 95% rated the importance at 4 or 5, then the Importance number is 9.5.Satisfaction
Administrator: Satisfaction is a function of the percentage of respondents who rated a job as very satisfied (4) or extremely satisfied (5). If 20% rated the satisfaction at 4 or 5, then the Satisfaction number is 2.0.Opportunity
Administrator: Opportunity = Importance + max [(Importance - Satisfaction),0]Job 11.07.01.0Job 21.06.01.0Job 31.57.01.5Job 41.56.51.5Job 52.08.02.0Job 62.06.52.0Job 72.06.02.0Job 82.58.02.5Job 92.56.02.5Job 102.55.02.5Job 113.05.03.0Job 123.04.03.0Job 133.51.06.0Job 144.06.54.0Job 154.05.54.0Job 164.05.04.0Job 174.03.05.0Job 184.57.04.5Job 194.51.08.0Job 204.55.04.5Job 214.53.55.5Job 225.04.06.0Job 235.03.07.0Job 245.55.06.0Job 255.53.57.5Job 265.52.09.0Job 275.83.08.6Job 288.07.98.1Job 296.25.07.4Job 306.24.67.8Job 317.06.08.0Job 327.06.57.5Job 338.07.09.0Job 348.57.89.2Job 359.09.59.0Job 366.52.011.0Job 377.01.912.1Job 388.03.013.0Job 398.03.812.2Job 408.23.512.9Job 418.32.014.6Job 428.73.014.4Job 438.82.115.5Job 449.21.017.4Job 459.22.915.5Job 469.13.015.2Job 479.24.813.6Job 489.54.814.2Job 499.46.012.8

Opportunity Grid