Write the managerial formulation and determine the optimum solution for the following problems. Verbally explain the optimum solution you obtain. Provide your answers$/$comments in a textbox or a comment on the Excel file. Don$$t forget to use color codes to organize your spreadsheet model.

Cubs

The Cubs are trying to determine which of the following free$-$agent pitchers should be signed: Rick Sutcliffe $($RS$),$ Bruce Sutter $($BS$),$ Dennis Eckersley $($DE$),$ Steve Trout $($ST$),$ or Tim Stoddard $($TS$).$ The cost of signing each pitcher and the predicted number of victories each pitcher will add to the Cubs are listed in the template. The Cubs want to sign the pitchers who will add the most victories to the team. Determine who the Cubs should sign based on the

following restrictions:

$$ At most, $$12$ million can be spent.

$$ At most, two right$-$handed pitchers can be signed.

$$ The Cubs cannot sign both BS and RS$.$

$$ The Cubs must sign at least three pitchers.

Capacitor Production

Eastinghouse ships $12,000$ capacitors per month to its customers. The

capacitors can be produced at three different plants. The production capacity, fixed monthly cost of operation, and variable cost of producing a capacitor at each plant are given in the HW template. The fixed cost of a plant is incurred only if the plant is used to make any capacitors. If a plant is used at all, at least $3000$ capacitors per month must be produced at the plant $($Hint: This will need to be formulated as a logical lower limit$).$ Determine how to minimize the company$$s monthly costs of meeting its customers$$ demand.