please use excel ( process flow add in ) to solve this and use the example ID number for oper. time of product B.

use the ID example 41461

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. Operations Table 1: Machine types and Operation Times Products A B Machine Oper. Time Machine Oper. Time Name (Min) Name (Min) Mi 6 M1 Sum of 1 ID digits M2 1 M2 Sum of 2nd ID digits M4 5 M3 Sum of 34 ID digits MS 2 M4 Sum of 4th ID digits M6 2 MS Sum of 5th ID digits M7 7 01 02 03 04 05 06 Machine Name M1 M3 M4 M5 Oper. Time (Min) 4 12 5 13 *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. Product A Immediate Operation Predecessor 1 2 3 1 4 5 5 3,2 6 4 Table 2: Sequence of the operations Product B Operation Immediate Predecessor 1 2 2 3 5,1 4 5 4 Product C Immediate Operation Predecessor 1 2 2 3 4 1,3 - Table 3: Machine Characteristics Reliability Machine Name Scrap rate (%Avail.) M1 0.07 97 % M2 0.03 89 % M3 0.03 88 % M4 0.01 92% MS 0.01 85 % M6 0.03 89 % M7 0.05 85 % Task Instructions 1) (20%) Using the information given above, define the processes in process flow add-in correctly. 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. Operations Table 1: Machine types and Operation Times Products A B Machine Oper. Time Machine Oper. Time Name (Min) Name (Min) Mi 6 M1 Sum of 1 ID digits M2 1 M2 Sum of 2nd ID digits M4 5 M3 Sum of 34 ID digits MS 2 M4 Sum of 4th ID digits M6 2 MS Sum of 5th ID digits M7 7 01 02 03 04 05 06 Machine Name M1 M3 M4 M5 Oper. Time (Min) 4 12 5 13 *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. Product A Immediate Operation Predecessor 1 2 3 1 4 5 5 3,2 6 4 Table 2: Sequence of the operations Product B Operation Immediate Predecessor 1 2 2 3 5,1 4 5 4 Product C Immediate Operation Predecessor 1 2 2 3 4 1,3 - Table 3: Machine Characteristics Reliability Machine Name Scrap rate (%Avail.) M1 0.07 97 % M2 0.03 89 % M3 0.03 88 % M4 0.01 92% MS 0.01 85 % M6 0.03 89 % M7 0.05 85 % Task Instructions 1) (20%) Using the information given above, define the processes in process flow add-in correctly