Four people are to be assigned to four different tasks (A B, c. andD). The table

Question

Four people are to be assigned to four different tasks (A B, c. andD). The table below provides the individuals and how long it takes to complete each uestion 4 ot yet answered task in hours. A B C D oints out of Chris 20.3 hrs26.1 hrs 17.4 hrs 14.5 hrs Dana 8,7 hrs 11,6 hrs 23.2 hrs5.8 hrs Flag question Taylor 11.6 hrs23.2 hrs 116 hrs 14.5 hrs Sam 5.8 hrs 11.8 hrs 174 hrs 14.5 hrs use a spreadsheet to assign the individuals to the tasks in a way that minimized the time Enter the minimum time in the answer block below. Round to one decimal place if necessary. Next page Previous page

Explanation / Answer

Enter all the values as it is in the excel sheet.

Select min function in excel and select each coloumn corresponding to the four different tasks. This will give the minimum time required for each task. Now add the individual hours using sum function.

5.8+11.6+11.6+5.8= 34.8Hrs

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.