Linear Optimization, Excel, Data Analytics.
sumproduct(price column, sales column) formula(function) for revenue on the objective cell. List all the given inputs Step 2: Outline Constrains Table Now we make a constraint table and list down all the constrain values. Here, all the values on the left-hand side should be redirected to the Sales