A factory produces four products. Each product needs to be processed successively on two machines -...

 

Transcribed Image Text:

A factory produces four products. Each product needs to be processed successively on two machines - machine A and then machine B. The processing times in hours per unit of the products on the two machines are shown in the following table. Processing time (hours) per unit of Product 3 4 Machine Product 1 Product 2 Product 4 A 2 з в 3 2 1 2 The total cost of producing one unit of each product is based directly on the machine time. Assume that the costs per hour for machines A and B are $10 and $5, respectively. The total number of hours available each month is 500 for machine A and 380 for machine B. The unit sales prices for products 1, 2, 3, and 4 are $65, $70, S55, and $45, respectively. The factory wants to determine the monthly production quantity of each product so that the total profit can be maximized. Formulate the problem as a linear programming model and solve it using Excel solver. (10 points) A factory produces four products. Each product needs to be processed successively on two machines - machine A and then machine B. The processing times in hours per unit of the products on the two machines are shown in the following table. Processing time (hours) per unit of Product 3 4 Machine Product 1 Product 2 Product 4 A 2 з в 3 2 1 2 The total cost of producing one unit of each product is based directly on the machine time. Assume that the costs per hour for machines A and B are $10 and $5, respectively. The total number of hours available each month is 500 for machine A and 380 for machine B. The unit sales prices for products 1, 2, 3, and 4 are $65, $70, S55, and $45, respectively. The factory wants to determine the monthly production quantity of each product so that the total profit can be maximized. Formulate the problem as a linear programming model and solve it using Excel solver. (10 points)

Answer rating: 100% (QA)

First Calculate Profit per unit for each product Unit Profit of product Unit selling price unit cost ... View the full answer