Linear Optimization, Excel, Data Analytics.
objective box and input the objective cell. On the second line, check Max since this is a maximization function. Based on the input we made for constraints, we will add the constraints as well. The first constraints will look like this- Step 5: Finding the value. After all the input is inserted,