Cash drawer bill extractor
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.
- Click Office button
- Click Excel Options
- Click add-ins
- Install Solver
- Click OK
How to use this template
- Select max quantities in cell range B3:B13
- Start excel solver, it is on tab "Data" on he ribbon.
Change constraint in excel solver
- Click $F$15 in "Subject to the constraints:" window
- Click Change button
- Change value to your specific sum
- Click OK
Click options button and enable "Assume Linear Model".
Click OK.
Click Solve button
Weekly Blog EMAIL
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Related articles
Identify numbers in sum using Excel solver
Here is a useful feature I recently found googling for Excel solver examples. I have summed some random values from […]
Optimize pick path in a warehouse
As you probably already are aware of I have shown you earlier a vba macro I made that finds the […]
Find positive and negative amounts that net to zero
I found this excel question: I am a Controller in a multinational company. We have many transactions (sales, credits, debits, […]
How to solve simultaneous linear equations in Excel
This article demonstrates how to solve simultaneous linear equations using formulas and Solver. The variables have the same value in […]
Using Excel Solver to schedule employees
This is a question I found at the bottom of this page Using Solver to schedule your workforce Bank 24 […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
