how to solve this question by excel

2. PRODUCT LAYOUT The Basic Block Company needs to produce 4000 boxes of blocks per 40-hour week to meet upcoming holiday demand. The process of making blocks can be broken down into six work ele- ments. The precedence and time requirements for each element are as follows. Draw and label a precedence diagram for the pro- duction process. Set up a balanced assembly line and calculate the efficiency of the line . F 50 200 PRECEDENCE - 30 100 WORK ELEMENT A B D E F A A PERFORMANCE TIME (MIN) 0.10 0.40 0.50 0.20 0.60 0.40 CD BE as follows: SOLUTION 0.1 0.4 0.4 0.2 0.5 E 0.6 Start at the beginning of the network and group, elements into workstations until cycle time has been