Optimization Problem #$3(35$ Points$)$: The Maryland Company has $4$ departments $($A$,$ B$,$ C & D$)$ and is

trying to determine how many of each of two products $($Product $1$ and Product $2)$ to produce by each

department over the coming planning period. Company uses cost strategy to make their decisions.

Labor availability, labor utilization, cost per and sales price for each product are given below.

On this worksheet, develop a linear programming model of the Maryland company problem. Use Solver

to determine the optimal production quantities of product $1$ and product $2$ to minimize the total cost.

Designate cell K$12$:L$15$ for decision variables, use cells M$12$:M$15$ for the capacity constraints, and K$17$

for the objective function. Based on your output:

Use the results from the solver to determine if all the departments needed.

Which departments have unused labor capacity, and how much?