same question posted and answered incorrectly. please help me to get correct answer asap.
10. In Figure 3.27, you are given the routing sheet for three types of widgets manufactured by Weedjets Manufacturing International. (a) Make a list of the product types and their codes. (b) Make a list of the equipment types and their codes. (c) Assign a numeric code for each widget type-1, 2, 3. Assign an alphabetic code for each equipment type-A, B, C, etc. (d) Write a spreadsheet software code which will (i) Remove all the information contained in the route sheets except the equipment types on which the widgets are processed and the sequence in which the equipment types are visited by the widget for processing. (ii) Write the retained information in another spreadsheet file. (e) Write another spreadsheet code that will use the information stored in the spreadsheet file created in Equation 3.4 to create a from-to frequency of trips matrix. Store this matrix in another spreadsheet file. For this question, use the demand and batch size information shown in Table 3.5 . (f) Using the spreadsheet file created in Equation 3.5 and another appropriate spreadsheet code, develop a frequency of trips between departments matrix. Store this information in a third spreadsheet file. (g) Assume there are two units of machine type 01204 and that 30% of all part types that require machine type 01204 are processed on the first copy and the remaining 70% on the other. Determine the new frequency of trips matrix. (h) Using your answer to the machine coordinate information in Exercise 11, determine the length and width of each machine. Concatenate all of the data generated in aforementioned questions (a) through (f) and prepare a data input file. 11. Weedjets Manufacturing International has currently arranged the five equipment types mentioned in Exercise 10 as shown in Figure 3.28. Coordinates of the five machines A, B, C, D, and E are (10,7.5),(20,20),(60,12.5),(35,7.5), and (5,20), respectively. (a) Determine the dimensions of each equipment type. (b) Using a spreadsheet software, determine the following distance measures for each equipment pair: (i) Euclidean (ii) Squared Euclidean (iii) Rectilinear (iv) Tchebychev (c) Using the distances calculated in part (b) and frequency of trips between matrix calculated in Exercise 10, part (f), determine the sum of flow times distance for the equipment pairs for each distance metric. FIGURE 3.27 Routing sheet for three types of widgets manufactured by Weedjets Manufacturing International. (Continued) FIGURE 3.27 (Continued) Routing sheet for three types of widgets manafactured by Weedjets Manufacturing International. 10. In Figure 3.27, you are given the routing sheet for three types of widgets manufactured by Weedjets Manufacturing International. (a) Make a list of the product types and their codes. (b) Make a list of the equipment types and their codes. (c) Assign a numeric code for each widget type-1, 2, 3. Assign an alphabetic code for each equipment type-A, B, C, etc. (d) Write a spreadsheet software code which will (i) Remove all the information contained in the route sheets except the equipment types on which the widgets are processed and the sequence in which the equipment types are visited by the widget for processing. (ii) Write the retained information in another spreadsheet file. (e) Write another spreadsheet code that will use the information stored in the spreadsheet file created in Equation 3.4 to create a from-to frequency of trips matrix. Store this matrix in another spreadsheet file. For this question, use the demand and batch size information shown in Table 3.5 . (f) Using the spreadsheet file created in Equation 3.5 and another appropriate spreadsheet code, develop a frequency of trips between departments matrix. Store this information in a third spreadsheet file. (g) Assume there are two units of machine type 01204 and that 30% of all part types that require machine type 01204 are processed on the first copy and the remaining 70% on the other. Determine the new frequency of trips matrix. (h) Using your answer to the machine coordinate information in Exercise 11, determine the length and width of each machine. Concatenate all of the data generated in aforementioned questions (a) through (f) and prepare a data input file. 11. Weedjets Manufacturing International has currently arranged the five equipment types mentioned in Exercise 10 as shown in Figure 3.28. Coordinates of the five machines A, B, C, D, and E are (10,7.5),(20,20),(60,12.5),(35,7.5), and (5,20), respectively. (a) Determine the dimensions of each equipment type. (b) Using a spreadsheet software, determine the following distance measures for each equipment pair: (i) Euclidean (ii) Squared Euclidean (iii) Rectilinear (iv) Tchebychev (c) Using the distances calculated in part (b) and frequency of trips between matrix calculated in Exercise 10, part (f), determine the sum of flow times distance for the equipment pairs for each distance metric. FIGURE 3.27 Routing sheet for three types of widgets manufactured by Weedjets Manufacturing International. (Continued) FIGURE 3.27 (Continued) Routing sheet for three types of widgets manafactured by Weedjets Manufacturing International
