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.
- Press with left mouse button on Office button
- Press with left mouse button on Excel Options
- Press with left mouse button on add-ins
- Install Solver
- Press with left mouse button on 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
- Press with left mouse button on $F$15 in "Subject to the constraints:" window
- Press with left mouse button on Change button
- Change value to your specific sum
- Press with left mouse button on OK
Press with left mouse button on options button and enable "Assume Linear Model".
Press with left mouse button on OK.
Press with left mouse button on Solve button
Solver category
I found this excel question: I am a Controller in a multinational company. We have many transactions (sales, credits, debits, […]
This article demonstrates how to solve simultaneous linear equations using formulas and Solver. The variables have the same value in […]
The COMBIN function returns the number of combinations for a specific number of elements out of a larger number of […]
Excel categories
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.
