Please help to solve below linear program using excel solver Question :Labor Planning at McCarthy's Everyday Glass Co$.$

McCarthy's is planning to produce $2$ styles of drinking glasses during the

next month. The glasses are produced in $4$ separate departments. Labor

requirements per case are as follows:

McCarthy's earns a profit of $$1\mathrm{.}00$ per case of Product $1$ and $$0\mathrm{.}90$ per case

of Product $2.$ Due to some cross$-$training of employees, the hours available in

each department are as follows:

Note that $870$ hours can be allocated with some management discretion. If

the firm can sell all it can produce, how many of each product should be

made and how should the labor be allocated among departments?