Inter-company material handling:

** This is all information that is included and the problem should be solved using Industrial Engineering methods, this is a material handling & logistics-based problem.

Please show all work, formulas, and calculations. Please setup the table and provide as text-based or work/excel file with table setup (the table below may be copied as a template for answer). This is a multiple-step/answer question so all answers are needed.

A 3^rd party company moves products or components among 7 companies. The following table contains moves among all companies per 8-hour shift. The inter-company flow rates are assumed constant through the shift.

(Text version below)

Inter-company flows
To From	1	2	3	4	5	6	7
1	-	10	34	0	0	19	24
2	10	-	3	0	42	12	21
3	28	12	-	54	0	0	0
4	0	24	0	-	53	4	21
5	34	12	0	21	-	34	18
6	3	12	45	27	0	-	6
7	12	18	12	0	24	24	-

A) Determine 2 most frequent cyclic routes (with the number of cyclic moves) for the 3^rd party agency to minimize wasted travel. Choose the first available destination if there is a tie.

B) What percent of the total moves are completed by each route?

C) What percent of the total moves are completed by the two frequent cyclic routes?

To From 1 2 3 4 5 6 7 10 0 3 10 28 0 0 20 0 42 0 19 OTOWO 2 3 4. 5 6 7 OTONDO 12 24 12 12 18 19 12 0 4 34 24 21 0 21 18 6 0 0 45 12 2 21 27 0 12 24 24 To From 1 2 3 4 5 6 7 10 0 3 10 28 0 0 20 0 42 0 19 OTOWO 2 3 4. 5 6 7 OTONDO 12 24 12 12 18 19 12 0 4 34 24 21 0 21 18 6 0 0 45 12 2 21 27 0 12 24 24