In the Excel Web App, the Solver Parameters dialog should be visible on the worksheet. To keep the final values in the decision variable cells, click Keep Solver Solution. Select the Return to Solver Parameters Dialog check box if you want to modify the Solver model or re-solve as your next step.

In order to maximize total profit, Company has some constraints: • The combined production capacity is 200 total units per day. • The company needs 50 units of Product A to fill an existing order. • The company needs 40 units of Product B to fill an anticipated order. • Because the market for Product C is relatively limited, the company doesn't want to produce more than 40 units of this product.

To solve this task, do the following: 1. Set up the worksheet with values and formulas. Make sure that you format cells logically; for example, if you cannot produce partial units of your products, format those cells to contain numbers with no decimal values. On the Data tab, in the Analysis group, click Solver. ( Solver is an add-in, if you can't found it, see ).