Setting Up a Model

Click Insert Example at the bottom of the Solver pane to enter the problem described above into the spreadsheet.

Solver Add-on Pane

The example appears in spreadsheet cells A1:G13. 

Example Optimization Model