Author: Oscar Cronquist Article last updated on January 11, 2019

Question:

I need to setup a template to remove the largest available (Qty and denomination)bills and leave exactly $150 back in the cash drawer in small bills, change and rolls of change. I need to remove exactly $ 1178.29 in large bills and leave the remaining $150 (from a total of $1328.29 in the register) in small bills and change.

Answer:

I am using excel solver to find a solution. Here is how to install the Solver add-in in Excel.

  1. Click Office button
  2. Click Excel Options
  3. Click add-ins
  4. Install Solver
  5. Click OK

How to use this template

  1. Select max quantities in cell range B3:B13
  2. Start excel solver, it is on tab "Data" on he ribbon.

Change constraint in excel solver

  1. Click $F$15 in "Subject to the constraints:" window
  2. Click Change button
  3. Change value to your specific sum
  4. Click OK

Click options button and enable "Assume Linear Model".

Click OK.

Click Solve button

Download Excel file through email

Enter your email address to receive the workbook. Note, an email will actually be sent to you.
* You will also get a weekly newsletter, unsubscribe anytime!