what more information is needed?

An assembly line has six tasks with task times and predecessors as given in the following table. Number of assemblies to be produced per week of 40 working hours is 4600. Use Excel to carry out the line balancing tasks as detailed in steps a) through f) below. Task Predecessors Time (see) 20 A B 30 A 15 D 15 A E 12 B, C DE F 30 Points a) 2 Calculate the cycle time and theoretical # of workstations required. b) 3 Draw the precedence diagram of the operations (AON diagram) c) 2 Generate a precedence matrix and calculate ranked positional weight of eac task d) 5 Assign the tasks to workstations according to the ranked positional weight e) 2 Calculate the idle time and efficiency of each workstation. f) 1 Calculate the overall assembly efficiency and actual # of assemblies produced