Q. Incline Electronics produces 3 different products in a plant which is open 40 hours per week. Every product needs the subsequent processing times (in hours) on every of 3 machines.
Product 1 Product 2 Product 3
Machine 1 2 2 1
Machine 2 3 4 6
Machine 3 4 6 5
Every machine must be run by one of 19 cross-trained workers who are every available 35 hours per week. The plant has 10 type 1 machines available, 6 type 2 machines available also 8 type 3 machines available. Products 1, 2 also 3 contribute $90, $120 also $150, respectively, in marginal profit per unit produced.
a. Formulate an LP model for this problem.
b. Implement your model in a spreadsheet also solve it.
c. Elucidate what is the optimal solution?
d. describe how many workers should be assigned to every type of machine?