Please Solve using Excel!!!

At an assembly workstation, the job of an operator is to sort six different parts coming on an

incoming conveyor into six bins. Each part, as numbered, should go to each designed bin, as

numbered. There are two existing layouts, and the following tables provide the performance

data of a well$-$trained operator for each layout. Using information processing theory,

determine which layout is better. Rationalize your answer based on both redundancy and

transmitted information measures. $[$Note: you can use MS Excel sheet to answer this

question, however, you need to copy all tables into your solution.$]$

Layout #$1$

Layout #$2$