Reference no: EM132858303

A company makes numerous lines of furniture. Throughout the pandemic the company has had to reduce lines and conserve materials.

Consider the following:

Line A takes 2 hours to manufacture a chair.
Line B takes 4 hours to manufacture a chair.
There are only 68 hours per week that can be allotted to the making of these chairs.
It takes 6 minutes to complete quality checks on Line A.
It takes 7 minutes to complete quality checks on line B.
There are only 16 hours per week available for quality checks
There are only enough raw materials in stock to make 30 chairs on Line A
There are only enough raw materials in stock to make 28 chairs on Line B.
The profit contributions of line A is $18,000
The profit contribution of Line B is $16,800

1. Identify the decision variables.

2. Identify the coefficients.

3. Identify the binding constraints.

4. Present the linear program using general linear programming notation.

5. Solve for the optimal solution AND maximization of profit contribution. Use Excel Solver