How to formulate a linear equation followed with constraints to minimize the production costs incurred by the company? you can solve it manually or by the solver in excel or Lingo The current analysis aims to optimize the production process in a chemical manufacturing company. The main raw materials which are used have an availability and cost per unit. Every finished good has a minimum capacity required, maximum sellable quantity, set selling price and the size of the batches. There are also specific quality measurements for the finished products. The main chemical raw materials used were butane, methane and hydrochloric acid (HC). The quantities and the costs of the raw materials are outlined as follows; Availabilit Cost Butane 1,000 11.3 Methane 3,000 13.2 HCl 7,000 10.5 The limits and price of finished goods are outlined as follows; Minimum Required Maximum Sold Price Product 1 4.000 8,000 18.4 Product 2 2,000 6,000 How to formulate a linear equation followed with constraints to minimize the production costs incurred by the company? you can solve it manually or by the solver in excel or Lingo The current analysis aims to optimize the production process in a chemical manufacturing company. The main raw materials which are used have an availability and cost per unit. Every finished good has a minimum capacity required, maximum sellable quantity, set selling price and the size of the batches. There are also specific quality measurements for the finished products. The main chemical raw materials used were butane, methane and hydrochloric acid (HC). The quantities and the costs of the raw materials are outlined as follows; Availabilit Cost Butane 1,000 11.3 Methane 3,000 13.2 HCl 7,000 10.5 The limits and price of finished goods are outlined as follows; Minimum Required Maximum Sold Price Product 1 4.000 8,000 18.4 Product 2 2,000 6,000