Load the solver add-in if it is not already loaded. click the budget worksheet and set the objective to calculate the highest balance possible. hint: on the file tab, click options, then click add-ins to install the add-in. solver will appear in the analysis group on the data tab.