8. The following table lists the sequence of machine types required for 12 part types and also shows the annual volume of production for each.

a) Set up a part machine matrix for this data. (3 pts)

b) Assuming the transfer batch size for part types 1, 4, and 5 is 60, part types 2, 3, 6, and 10-12 is 20, and part types 7-9 is 50, determine the frequency of trips matrix using the matrix you set up in (a). (4 pts)

c) Determine machine groups and part families for the data using Similarity Coefficient (SC) algorithm and draw a dendogram. (13 pts)

Table. Part Routing and Volume Information Part Type Number 1 2 3 4 5 6 7 8 9 Sequence of Machine Types Visited 2,5,6 1,4 4, 1,3 5,6 6,2 1, 3, 4 2,5,3 5,2 2,5 1,3 4,3 3, 1,4 Production Volume 13,000 4,000 2,500 6,700 1,000 5,000 9,000 13,000 13,000 13,000 13,000 15,000 10 11 12