with solver in excel sheet

Power Drinks - Example A company manufactures 3 Power Drinks: Super, Max and Turbo, which sells for EGP 14, EGP 15 and EGP 22 per unit respectively. These prices are constant and independent of the market state they are addressed to, and it is also supposed that any produced quantity can be sold. For the manufacturing of these products four types "of ingredients are required. The prices of the ingredients, the ingredients units needed for each product type and the corresponding available quantities are included in the following table. The company's goal is to determine the quantities of each product which should be produced in order to achieve the highest profit. Power Drinks - Example A company manufactures 3 Power Drinks: Super, Max and Turbo, which sells for EGP 14, EGP 15 and EGP 22 per unit respectively. These prices are constant and independent of the market state they are addressed to, and it is also supposed that any produced quantity can be sold. For the manufacturing of these products four types "of ingredients are required. The prices of the ingredients, the ingredients units needed for each product type and the corresponding available quantities are included in the following table. The company's goal is to determine the quantities of each product which should be produced in order to achieve the highest profit