Answer in excel

Problem 2. A certain plant can manufacture five different products in any combination. Each product requires time on each of three machines in the following Each machine is available 128 hours per week. Products A, B, and C can only be made on machines 1, and 2, while C, and D can be made on any machines. Since all the products are very trendy, any amounts made may be sold at respective prices of $5,$4,$5,$3.5, and $3 each. Labor costs are $15, $16, and $14 each hour. Material costs are $2 for products A and C and $1 for products B, D, and E. [Please ignore that the units produced have to be whole numbers!] a) Formulate the problem to maximize profit for the firm. b) Market condition dictates that equal number of A,B, and C be available for sale, while the number of D and E are equal as well. What would then be the maximum profit. c) If management would like to increase their capacity by buying another machine, which one of the three machines should they buy that would increase their profit the most, assuming the market conditions to remain the same? Explain briefly. Problem 2. A certain plant can manufacture five different products in any combination. Each product requires time on each of three machines in the following Each machine is available 128 hours per week. Products A, B, and C can only be made on machines 1, and 2, while C, and D can be made on any machines. Since all the products are very trendy, any amounts made may be sold at respective prices of $5,$4,$5,$3.5, and $3 each. Labor costs are $15, $16, and $14 each hour. Material costs are $2 for products A and C and $1 for products B, D, and E. [Please ignore that the units produced have to be whole numbers!] a) Formulate the problem to maximize profit for the firm. b) Market condition dictates that equal number of A,B, and C be available for sale, while the number of D and E are equal as well. What would then be the maximum profit. c) If management would like to increase their capacity by buying another machine, which one of the three machines should they buy that would increase their profit the most, assuming the market conditions to remain the same? Explain briefly