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 510 units per day, and the demand for Component Y is 1,020 units per day. The minutes required per unit for each product are as follows: Product Component X Minutes Required per Unit of Product Molding 5 Grinding Finishing 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 418 grinding hours per shift. The Finishing Department is labor intensive and employs 73 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 $41, and for Component Y, it is $54. Selling prices for X and Y are $86 and $101, 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. Molding Grinding Finishing Net Time Required 12,750 minutes 20,400 minutes 28,050 minutes What is the major internal constraint facing Middleton Company? Molding 2. Identify the product mix that will maximize daily throughput. Component X Component Y Number of Units Produced X units X 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? Component X Component Y Number of Units Produced X units 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 descriptive because the calculation of the time needed is telling what is happening. For Requirement 2, the major data analytic type is prescriptive For Requirement 3, the major data analytic type is predictive . The analysis identifies the product mix that Middleton should . The analysis reveals what the new product mix and daily throughput will produce to maximize daily throughput. be if the new setup time is reduced as predicted.