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, and then click add-ins to install the add-in. The solver will appear in the analysis group on the data tab. And this process is applicable to Excel software that is a spreadsheet which analyzes and pictures the data that was inputted.
