Identifying and Exploiting Constraints, Constraint Elevation Middleton Company produces two different metal components used in medical equipment (Component X and Component Y). The company has three processes: molding, grinding, and finishing. In molding, molds are created, and molten metal is poured into the shell. Grinding removes the gates that allowed the molten metal to flow into the mold's cavities. In finishing, rough edges caused by the grinders are removed by small, handheld pneumatic tools. In molding, the setup time is one hour. The other two processes have no setup time required. The demand for Component X is 590 units per day, and the demand for Component Y is 1,110 units per day. The minutes required per unit for each product are as follows: Minutes Required per Unit of Product Product Molding Grinding Finishing Component x 5 10 15 Component Y 10 15 20 The company operates one eight-hour shift. The molding process employs 26 workers (who each work eight hours). Two hours of their time, however, are used for setups (assuming both products are produced). The grinding process has sufficient equipment and workers to provide 410 grinding hours per shift. The Finishing Department is labor intensive and employs 72 workers, who each work eight hours per day. The only significant unit-level variable costs are materials and power. For Component x, the variable cost per unit is $39, and for Component Y, it is $52. Selling prices for X and Yare $94 and $109, respectively. Middleton's policy is to use two setups per day: an initial setup to produce all that is scheduled for Component X and a second setup (changeover) to produce all that is scheduled for Component Y. The amount scheduled does not necessarily correspond to each product's daily demand. Required: 1. Calculate the time (in minutes) needed each day to meet the daily market demand for Component X and Component Y. Net Time Required Molding minutes Grinding minutes Finishing minutes What is the major internal constraint facing Middleton Company? 2. Identify the product mix that will maximize daily throughput. Number of Units Produced Component x units Component Y units 3. Assume that manufacturing engineering has found a way that will reduce the molding setup time from one hour to 10 minutes. How many units of Component X and Component Y would be produced? Number of Units Produced Component x units Componenty units 4. For Requirements 1 to 3, identify the data analytic model used and select and justify the data analytic type(s) used. See Exhibits 2.5 and 2.6, for a review of data analytic types (descriptive, diagnostic, predictive, and prescriptive). The major data analytic type used for Requirement 1 is calculation of the time needed is telling what is happening. because the For Requirement 2, the major data analytic type is the product mix that Middleton The analysis identifies produce to maximize daily throughput. For Requirement 3, the major data analytic type is what the new product mix and daily throughput reduced as predicted. The analysis reveals be if the new setup time is