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.

How to install Solver add-in

  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 (Tab Data)

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 template file
cash drawer bill extractor
(Excel 97-2003 Workbook *.xls)