Q$1.(30$ points$)$

A company produces two different products, Product $1$ & $2.$ Both the products have to go through Departments A$,$ B$,$ & C

The labor hours required per unit in each department for each product, the hours available and profit contribution per product is given in the table below.

Determine the optimum number of each product that should be produced to maximize profit

Set up the problem in excel and solve it using Solver. The Answer Report must be downloaded.

The solver dialog box should be populated when I open your submission and I should be able to execute solver.