Please show all formulas and explanations, if excell is used please show formulas in cell

5. Consider the manned manufacturing cell capable of manufacturing family parts. The information related to the cell is provided below: Work Operation Walking time Manual time Machine time sequence (sec) (sec) (sec) 1 Mill ends (HM1) 5 10 30 2 Drill hole (DP) 5 12 20 3 Turn & bore (L1) 6 14 40 4 Mill flat (HM2) 6 14 20 5 Mill steps (VM) 6 14 30 6 Final inspection 5 10 20 a) What is the cell cycle time of this cell with one worker? b) Suppose the daily demand is 400 parts, and the cell works for 2 shifts of 8 hrs/day. Will the cell with one worker meet the demand? c) If you add a 2nd worker to the cell, determine the best cell cycle time that can be achieved if the worker paths are not allowed to cross? What would be the allocation of the machines to each worker? d) Suppose the daily demand doubled, would this cell meet the demand? If not what potential course of action would you recommend? Show that this would meet the demand. 6. 7 machines are used to process eight products. The PFA matrix is given below. To improve continuous flow, the plant would like to build cells for these parts. Using the Rank Order Clustering method to form product families and to construct the cells (Please show all steps). List the machines and parts assigned to each cell. Are the product families you formed mutually exclusive? If not, what choices do you have to ensure that the parts stay within the cells for processing? Parts Machine A . D E F G H H