Linear Programming using Excel to for two products in two lines

A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Product 1 requires 10 hours of processing time on line 1 and product 2 requires 14 hours of processing on line 1. , On line 2, product 1 requires 7 hours and product 2 requires 3 hours. The profit for product 1 is $6 per unit, and the profit for product 2 is $4 per unit.

a. Formulate a linear programming model for this problem.
b. Solve the model by using graphical analysis.

© SolutionLibrary Inc. solutionlibary.com November 15, 2019, 4:42 am 9836dcf9d7 https://solutionlibrary.com/math/consumer-mathematics/linear-programming-using-excel-to-for-two-products-in-two-lines-jl25