Process analysis

Q 1.1. Draw a flow diagram corresponding to the above described process of plywood manufacturing. Make sure the provided flow diagram looks neat and is clearly readable.

Now the working of the process is clear, its performance needs to be analyzed. The provided excel le "Plywood data.xlsx", sheet "Extra info", information is provided on the duration, speed, etc., of activities that need to be undertaken and the resources involved to manufacture plywood. Furthermore, we assume that the panels produced by company X are 3-ply panels of width 1.2 m, length 2.4 m and thickness 15 mm, made of veneers of thickness 5 mm. The logs are peeled on a 1.5 m lathe machine, and sanded on both sides.

Q 1.2. Determine the yield yi of each resource i and the yield of the process Y . Determine the number of ow units Qi (kgs of wood) that need to be processed at each resource i to get one good ow unit (i.e. 1 kg of wood) out of the process.

Q 1.3. Determine the capacity Ci in kg/min, and implied utilization IUi of each resource i. Identify the bottleneck resource in the process?

Hint: For questions 1.1, 1.2 and 1.3, provide a table summarizing the results. The table basically shows yi, Qi, Ci and IUi for each resource i (explain the calculations)

How do I solve this question?

A B 1 This extra data holds in case of panels of width 1.2m, length 2.4m and thickness 15mm 2 3 Conditionig Time = 24 hrs Speed = 100m/min Peeling on a 1.5m lathe machine 4 Peeling on a 5 veneer slicer 6 Clipping 7 Joining 8 Drying Speed = 20m/min Speed = Speed = Speed = Composing 9 Rate = Gluing 10 11 Cold press 12 Hot press 13 Quality check 14 Sanding 15 Trimming 16 Packaging 17 18 Weight cut log 19 Dimensions veneer 22m/min 50m/min, 30% need to be joined 35m/min a machine can process 1 veneer in 10 sec 5 machine available 1 panel in 5-15 sec. it depends on whether it is 3-ply or 5-ply, and on thickness for a 3-ply panel 1.5m x 2.4m x 0.015m it takes 12 sec 30 panels at the same time in 20 minutes 35 panels in 5 minutes 1.2 min to check quality of one panel (doesn't include 1 minute in case of fixing) 1 machine sands 1 panel in 9 sec for only face, 10 seconds for back and face 1 machine trims 1 panel in 7 sec 1 worker can package 10 panels in 3 min Capacity Rate = Rate = Rate = Rate = Rate = Weight = 500 kg Dimensions Width x Length x Tickness = 1.5 x 2.4 x 0.005 m3 9 hours including 1 hour break Shift 20 21 22 Density raw wood 23 Density plywood Density = Density = 600 kg/m3 500 kg/m3 A B 1 This extra data holds in case of panels of width 1.2m, length 2.4m and thickness 15mm 2 3 Conditionig Time = 24 hrs Speed = 100m/min Peeling on a 1.5m lathe machine 4 Peeling on a 5 veneer slicer 6 Clipping 7 Joining 8 Drying Speed = 20m/min Speed = Speed = Speed = Composing 9 Rate = Gluing 10 11 Cold press 12 Hot press 13 Quality check 14 Sanding 15 Trimming 16 Packaging 17 18 Weight cut log 19 Dimensions veneer 22m/min 50m/min, 30% need to be joined 35m/min a machine can process 1 veneer in 10 sec 5 machine available 1 panel in 5-15 sec. it depends on whether it is 3-ply or 5-ply, and on thickness for a 3-ply panel 1.5m x 2.4m x 0.015m it takes 12 sec 30 panels at the same time in 20 minutes 35 panels in 5 minutes 1.2 min to check quality of one panel (doesn't include 1 minute in case of fixing) 1 machine sands 1 panel in 9 sec for only face, 10 seconds for back and face 1 machine trims 1 panel in 7 sec 1 worker can package 10 panels in 3 min Capacity Rate = Rate = Rate = Rate = Rate = Weight = 500 kg Dimensions Width x Length x Tickness = 1.5 x 2.4 x 0.005 m3 9 hours including 1 hour break Shift 20 21 22 Density raw wood 23 Density plywood Density = Density = 600 kg/m3 500 kg/m3