1. Suppose you are assessing the merits of multiple designs of pillows based on durability, shape, and comfort.

Use the table below to answer the following questions. You should set up and solve this question using excel

			Benefits
Design	Cost	Durability	Shape	Comfort
A	10000	92	0	0
B	12553	60	100	26
C	17000	0	7	18
D	8000	17	30	22
E	11561	77	15	70
F	11000	15	0	81
G	13619	85	53	100
Weight		78	24	79

1a. What would the normalized weights for each benefit? Report your response to 2 decimal places.

Durability =

Shape =

Comfort =

1b. Use the normalized weights to find the aggregate benefit for each design. Report your response to one decimal place

A=

B=

C=

D=

E=

F=

G=

1c. If the design has the worst Shape (only), it's benefit score would be? Report your answer to one decimal place

1d. If the design has the best Durability and the worst Shape and Comfort, We would be willing to pay ______________ for the extra _____________ benefit points

1e. Suppose you are willing to pay $8000 more to move from the least desirable to the most desirable design.

The best design would be design_____________________

Solve with normalized weights.