Question: Using weighed method average we have plan 2 as the best plan ( lowest to greatest ) Organ Heart Spinal cord Kidney WA Weight 0.6

Using weighed method average we have plan 2 as the best plan ( lowest to greatest )

Organ Heart Spinal cord Kidney WA
Weight 0.6 0.3 0.1 1
Plan 1 100 40 50 77
Plan 2 80 50 30 66
Plan 3 110 30 10 75

What is the method to make Plan-1 the best ( lowest value ) by changing Weight of (Heart, Spinal and Kidney) and make sure total weight =1

77 : =SUMPRODUCT(B3:D3,$B$2:$D$2)/SUM($B$2:$D$2)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

multi-objective optimization problem in the following table. Rank the plans according to the weighted average dose to the healthy organs (lowest to greatest). Make sure to include your calculations....

Q:

answer problem 1 2 and 3 **UPDATED QUESTIONS*** 1) what discourses or information, if any, does the company include about their products in inventory. What key details are important to understanding...

Q:

Old MathJax webview please complete 1 2 and 3( there is no additional information) thanks **UPDATED QUESTIONS*** 1) what discourses or information, if any, does the company include about their...

Q:

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

Q:

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

Q:

PXT992 Research Project Plan Degradation Mechanisms in Quantum Dot on Silicon Lasers Author 1 Purpose (motivation) One of the most urgent issues in semiconductor technology is the direct development...

Q:

I need a Gantt chart or similar timetable briefly outlining what & when you will be doing, and more description on the process you will be following to complete these tasks. E.g. Pre-degradation...

Q:

Cleveland Clinic: Transformation and Growth 2015 Mat we are undertaking would in many ways transform the world of medicine. Dr. Delos Cosgrove, CEO Cleveland Clinic was a multispecialty health care...

Q:

read and analysis financial report, some strategy questions BACK COVER FRONT COVER OUTSIDE FLAP Contents Tesco PLC Annual Report and Financial Statements 2014 Strategic report IFC Tesco at a glance...

Q:

Prepare a summary of the auto industry by reviewing the attached report. Then compare these two companies, Group 1 Auto and Sonic Automotive. Base on a review of the two companies financial...

Q:

A survey of 20 major media markets was done to determine the number of advertising firms headquartered in each. The results of the study are given below: a. Show the stem-and-leaf diagram for the...

Q:

Man in the vat problem.11 Long ago, a workman at a dye factory fell into a vat containing hot, concentrated sulfuric and nitric acids. He dissolved completely! Because nobody witnessed the accident,...

Q:

Sam rented out his home for 7 days during the year for \ ( \ $ 6 , 8 0 0 \ ) . He resided in the home for the remainder of the year. Expenses associated with use of the home for the entire year were...

Q:

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...