Question completion Status Vahe QUESTION 7 Consider the Problem Ch 7 15 for the following questions. Use the Excel: 07 - Problem Color 5. Keul Studies does custom metal sculptures of horses and other animals. A horse sculpture is composed of numerous parts. They use a late to construct two types of parts. The "Body part is used to support the torso of the horse and the "Leg part is used to support the legs. Each horse sculpture needs 1 Body part and 4 Leg parts. Switching between tither of the types of parts requires 25 minutes. Once ready to produce the lathe produces a Body part in 4 minutes and a single Les part in 2 minutes. The lathe only makes horse parts. For parts(a)-(d) assume Keuka operates a cyclic schedule in which they make 100 Body parts and then 400 Les parts. Furthermore, assume the lathe is the bottleneck What is the maximum number of horse sculptures Keuka can make per hour? QUESTION 8 What is the utilization (%) of the lathe (assume flow rate equal capacity of lathe)? (you number should look like this: 4455 for 44.55%) QUESTION 9 Suppose Keuka is demand-constrained and they have I worker who is able to assemble a horse sculpture in 16 minutes. What is the average inventory of Body parts? 100/11-2009 Process Time (min) 02 0.4 06 Batch Size for Part 429 88 Max Ave Inventory Inventory 308.88 154.44 377.52 1876 Set-Up Op Time 36 Presss Details (min) Rod/ Set (min) 37 Part A 0.20 38 Part 8 25 2 0.20 39 Total 50 40 41 Batch Size SOO Boxes 42 Target Batch Size 438 Boxes 43 44 45 46 Process Step Press Resources 1 Machine Process Timel 06 min Flow Units Boxes Assembly 14 Workers 10 min BONES Capacity 143 Boxes min 1.40 Boxes min Flow 140 Bones Rate Minimum of Deundor Battle Capacity they 85.71 Boxes Hr 14 BONES Hr Cycle Time 49 50 51 52 06 min Boses 0.714 min Boxes Cyde Time Boxes Ulation 845 100%