they need us to solve with our ids: 36598 & 36418

Labwork-1 is a group work. Please, read the problem carefully and complete the tasks. The company produces three different products (A, B, and C) each from two different raw materials by utilizing 7 different types of machines. According to sales forecast each week they need to produce 900, 1800, and 700 of products A, B, and C, respectively. The company is operating in three shifts (each shift is 6 hours) 5 days a week. Data related to operations and resources is given in the tables below. Table 1: Machine types and Operation Times Products A C Operations Machine Name M1 01 Machine Name M1 M2 M3 Oper. Time (Min) 4 12 Machine Name M1 M2 M4 M5 M6 M7 B Oper. Time* (Min) Sum of 1st ID digits Sum of 2nd ID digits Sum of 3d ID digits Sum of 4th ID digits Sum of 5th ID digits Oper. Time (Min) 6 1 5 2 2 7 02 03 04 05 06 M3 M4 M5 5 13 M4 M5 *Op. Time of product B is the summation of your ID digits. For example, if your ID is 41461, and your group member's ID is 40872, then Sum of 1st ID digits = 8, Sum of 2nd ID digits = 1, Sum of 3d ID digits = 12, Sum of 4th ID digits = 13, Sum of 5th ID digits =3. Table 2: Sequence of the operations Product A Immediate Operation Predecessor 1 Product B Immediate Operation Predecessor 1 2 2 3 5,1 4 5 4 Product C Immediate Operation Predecessor 1 2 2 3 4 1,3 2 3 1 4 5 6 5 3,2 4 Table 3: Machine Characteristics Machine Name Scrap rate M1 M2 M3 M4 M5 M6 M7 0.07 0.03 0.03 0.01 0.01 0.03 0.05 Reliability (%Avail.) 97% 89% 88 % 92 % 85 % 89 % 85 % Task Instructions 1) (20%) Using the information given above, define the processes in process flow add-in correctly. 2) (78%) Open a new worksheet in the same Excel file and answer the following questions: a) (8%) What is the throughput time of each product? Please explain why throughput time is different from the total processing time. b) (8%) Identify the product with the lowest WIP. Explain what it means and how we can use it. c) (8%) Find the inputs and the outputs of each operation (using Flow out and Unit Flow). Comment on where you can use this information and how to use it. d) (8%) Find the total amount of raw material to be purchased for each product. e) (6%) Find machine fractions (the minimum number of machines) required to fulfill the sales within the given time interval. f) (6%) Identify machine utilization for each machine. g) (8%) What is the total processing time required in each machine for the given sales forecasts. h) (6%) Identify the department pair with the least flow. i) (6%) Identify the department pair with the most flow. j) (8%) Construct From-To Matrix and comment on where you can use this information. k) (6%) How many more M1 machines the company will need if the sales of the second product increase by 25%. Labwork-1 is a group work. Please, read the problem carefully and complete the tasks. The company produces three different products (A, B, and C) each from two different raw materials by utilizing 7 different types of machines. According to sales forecast each week they need to produce 900, 1800, and 700 of products A, B, and C, respectively. The company is operating in three shifts (each shift is 6 hours) 5 days a week. Data related to operations and resources is given in the tables below. Table 1: Machine types and Operation Times Products A C Operations Machine Name M1 01 Machine Name M1 M2 M3 Oper. Time (Min) 4 12 Machine Name M1 M2 M4 M5 M6 M7 B Oper. Time* (Min) Sum of 1st ID digits Sum of 2nd ID digits Sum of 3d ID digits Sum of 4th ID digits Sum of 5th ID digits Oper. Time (Min) 6 1 5 2 2 7 02 03 04 05 06 M3 M4 M5 5 13 M4 M5 *Op. Time of product B is the summation of your ID digits. For example, if your ID is 41461, and your group member's ID is 40872, then Sum of 1st ID digits = 8, Sum of 2nd ID digits = 1, Sum of 3d ID digits = 12, Sum of 4th ID digits = 13, Sum of 5th ID digits =3. Table 2: Sequence of the operations Product A Immediate Operation Predecessor 1 Product B Immediate Operation Predecessor 1 2 2 3 5,1 4 5 4 Product C Immediate Operation Predecessor 1 2 2 3 4 1,3 2 3 1 4 5 6 5 3,2 4 Table 3: Machine Characteristics Machine Name Scrap rate M1 M2 M3 M4 M5 M6 M7 0.07 0.03 0.03 0.01 0.01 0.03 0.05 Reliability (%Avail.) 97% 89% 88 % 92 % 85 % 89 % 85 % Task Instructions 1) (20%) Using the information given above, define the processes in process flow add-in correctly. 2) (78%) Open a new worksheet in the same Excel file and answer the following questions: a) (8%) What is the throughput time of each product? Please explain why throughput time is different from the total processing time. b) (8%) Identify the product with the lowest WIP. Explain what it means and how we can use it. c) (8%) Find the inputs and the outputs of each operation (using Flow out and Unit Flow). Comment on where you can use this information and how to use it. d) (8%) Find the total amount of raw material to be purchased for each product. e) (6%) Find machine fractions (the minimum number of machines) required to fulfill the sales within the given time interval. f) (6%) Identify machine utilization for each machine. g) (8%) What is the total processing time required in each machine for the given sales forecasts. h) (6%) Identify the department pair with the least flow. i) (6%) Identify the department pair with the most flow. j) (8%) Construct From-To Matrix and comment on where you can use this information. k) (6%) How many more M1 machines the company will need if the sales of the second product increase by 25%