Question

Bisbee Aeropsace Factor Rating Matrix (please use excel to complete this exercise)

Bisbee Aerospace has recently entered the market for commercial space flights. The executive team at Bisbee is considering proposals from its engineering group for five possible commercial space shuttle designs. The engineering group, in cooperation with the marketing division, has done a thorough job in preparing a business case for each design, and executive team members have carefully reviewed the documentation. Bisbee has a policy in place for weighting criteria used in new product development decisions. These are as follows: Potential to increase market share .40 Potential for financial gain .20 Bisbee’s technical capability for this project .20 Fit with company mission and strategy .20 Members of the Bisbee executive team have rated each shuttle project on the four criteria on scales of 1-10, where a 1 is a low score and a 10 is a high score. The results are as follows:

Rater                                                                                     Rating

Barry

PROJECT	MARKET	FINANCIAL	TECHNICAL	MISSION
A	10	5	9	9
B	7	7	6	4
C	4	5	4	3
D	7	4	4	6
E	2	3	9	5

Sandra

PROJECT	MARKET	FINANCIAL	TECHNICAL	MISSION
A	8	9	8	7
B	7	6	6	3
C	5	4	3	3
D	7	5	7	4
E	1	2	6	4

Moe

PROJECT	MARKET	FINANCIAL	TECHNICAL	MISSION
A	7	4	6	6
B	5	5	5	3
C	3	4	3	2
D	6	3	2	5
E	1	2	7	4

Janet

PROJECT	MARKET	FINANCIAL	TECHNICAL	MISSION
A	10	7	10	10
B	9	8	7	5
C	5	6	5	4
D	6	5	6	7
E	4	4	9	6

Prepare a factor-rating matrix using spreadsheet software, and interpret the results.IN EXCELL

Answer 1

Interpretation of results: Project A is rated the highest score, followed by project B, D, C and E. Therefore, Project A is the best