Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could you double check my work and answer the missing questions? Plz show work Suppose you are assessing the merits of multiple designs of pillows

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedCould you double check my work and answer the missing questions? Plz show work

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 12672 32 100 8 C 17000 0 29 D 8000 17 30 E 17972 35 46 11000 80 0 12758 32 11 34 94 TI F G Weight 87 22 59 62 100 92 > Question 1 What would the the normalized weights for each benefit. Report your response to 2 decimal places. 0.15 Durability = Shape= 0.43 Comfort = 0.42 3 pts Question 2 Use the normalized weights to find the aggregate benefit for each design. Report your response to one decimal place A= 13.8 B= 51.2 C= 49 D= 24.7 E= 49.8 F= 38,0 G= 51.5 7 pts Question 3 If the design has the worst Shape (only), it's benefit score would be Report your answer to one decimal place 1 pts > Question 4 If the design has the best Durability and the worst Shape and Comfort, We would be willing to pay points for the extra benefit 2 pts Question 5 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 1 pts 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 12672 32 100 8 C 17000 0 29 D 8000 17 30 E 17972 35 46 11000 80 0 12758 32 11 34 94 TI F G Weight 87 22 59 62 100 92 > Question 1 What would the the normalized weights for each benefit. Report your response to 2 decimal places. 0.15 Durability = Shape= 0.43 Comfort = 0.42 3 pts Question 2 Use the normalized weights to find the aggregate benefit for each design. Report your response to one decimal place A= 13.8 B= 51.2 C= 49 D= 24.7 E= 49.8 F= 38,0 G= 51.5 7 pts Question 3 If the design has the worst Shape (only), it's benefit score would be Report your answer to one decimal place 1 pts > Question 4 If the design has the best Durability and the worst Shape and Comfort, We would be willing to pay points for the extra benefit 2 pts Question 5 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 1 pts

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Risk Sharing Finance

Authors: Bakkali Mirakhor, Saad Abbas

1st Edition

3110590468, 978-3110590463

More Books

Students also viewed these Finance questions

Question

8. Explain the contact hypothesis.

Answered: 1 week ago

Question

7. Identify four antecedents that influence intercultural contact.

Answered: 1 week ago