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 $700$ units per day, and the demand for Component Y is $1,140$ 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 $51015$

Component Y $101520$

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 $420$ grinding hours per shift.

The Finishing Department is labor intensive and employs $71$ 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 $$44,$ and for Component Y$,$ it is $$52.$ Selling prices for X and Y are $$99$ and $$104,$ 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 fill in the blank $1$

minutes

Grinding fill in the blank $2$

minutes

Finishing fill in the blank $3$

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 fill in the blank $5$

units

Component Y fill in the blank $6$

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 fill in the blank $7$

units

Component Y fill in the blank $8$

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\mathrm{.}5$ and $2\mathrm{.}6,$ for a review of data analytic types $($descriptive$,$ diagnostic, predictive, and prescriptive$).$

The major data analytic type used for Requirement $1$ is

because the calculation of the time needed is telling what is happening.

For Requirement $2,$ the major data analytic type is

$.$ The analysis identifies the product mix that Middleton

produce to maximize daily throughput.

For Requirement $3,$ the major data analytic type is

$.$ The analysis reveals what the new product mix and daily throughput

be if the new setup time is reduced as predicted.