I am working on a calculation:
If I give Lot 1 a Final cost of 7800.00 I can figure out the divisor of .435407 by (7800/5434)-1 = Divisor of .435407
Then I subtract 3% for Lot 5 to come up with 7800-3% = 7566.
To figure out Lot 1 divisor with pricing at 7800 I used the following calculation:
(7800/5434)-1
Then after that I just subtracted 3% from 7800, 5% from 7800, etc.
I figured out the 8041.24 just by typing in numbers randomly into my program until it showed Lot 5 at 7800.
PROBLEM: If I put in 7800 for Lot 5, then how do I calculate the divisor and work my way backwards and forwards. I WANT TO input 7800 for Lot 5, and then have it calculate 8041.24 for Lot 1 and the correct divisor of .479801.
If I put in 7800 for Lot 10, then again, how do I calculate the divisor and work my way backwards and forwards. I WANT TO input 7800 for Lot 10, and then have it calculate 8210.53 for Lot 1 and the correct divisor of .51095
5434*.479801 = 8041.24
(8041.24 - 3% = 7800)
Val
| Original Cost | Final Cost | Markup | Divisor (Markup) | |
| Lot 1 | 5434 | 7800.00 | 0% | .435407 |
| Lot 5 | 5434 | 7566.00 | -3% | .435407 |
| Lot 10 | 5434 | 7410.00 | -5% | .435407 |
| Lot 1 | 5434 | 8041.24 | 0% | .479801 |
| Lot 5 | 5434 | 7800.00 | -3% | .479801 |
| Lot 10 | 5434 | 7639.18 | -5% | .479801 |
| Lot 1 | 5434 | 8210.53 | 0% | 0.51095 |
| Lot 5 | 5434 | 7964.21 | -3% | 0.51095 |
| Lot 10 | 5434 | 7800.00 | -5% | 0.51095 |
If I give Lot 1 a Final cost of 7800.00 I can figure out the divisor of .435407 by (7800/5434)-1 = Divisor of .435407
Then I subtract 3% for Lot 5 to come up with 7800-3% = 7566.
To figure out Lot 1 divisor with pricing at 7800 I used the following calculation:
(7800/5434)-1
Then after that I just subtracted 3% from 7800, 5% from 7800, etc.
I figured out the 8041.24 just by typing in numbers randomly into my program until it showed Lot 5 at 7800.
PROBLEM: If I put in 7800 for Lot 5, then how do I calculate the divisor and work my way backwards and forwards. I WANT TO input 7800 for Lot 5, and then have it calculate 8041.24 for Lot 1 and the correct divisor of .479801.
If I put in 7800 for Lot 10, then again, how do I calculate the divisor and work my way backwards and forwards. I WANT TO input 7800 for Lot 10, and then have it calculate 8210.53 for Lot 1 and the correct divisor of .51095
5434*.479801 = 8041.24
(8041.24 - 3% = 7800)
Val
Last edited: