Hello,
I need a small program to be designed to cut down 8-9 step manual calculation process
to just a press of a button.
Here is the process that I go through to calculate a single price:
1. Multiply Gr. x $/Gr. = Base price
2. Add Shipping to the Base price - ($1-$100= $10 shipping; $100-$200=$11 shipping;
$200-$300=$12 shipping...etc, for every $100 add $1.
3. Calculate 3% from the product of (1) and (2), then add it to that product.
4. Add Profit ---- $0-$100 = $10; $100-$200 = $15; $200-$300 = $20; $300-$400 = $30;
$400-$500 = $40, and anything above $500 stays at $50 profit.
5. Calculate 3% from the amount so far.
6. Add the 3% to the amount from (4) == FINAL PRICE.
I imagine that there will be 2 input boxes, followed by a button to perform the calculation, and a third RESULT box, from which I can copy the result(s).
Then I will need another box after the RESULT box where I can input a number, and that number can be subtracted from the RESULT, which will give another value in box on the same row as the PRICE value. I would need the same row to repeat for 20 times so multiple calculations can be performed at once.
* See attached image file for design layout.
Thanks