Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for best fit
I'm looking for a formula to find the 'best fit' for inventory turns. For
example: A B C D 1 10 100 50 5 The formula in D1 is: =(b1-c1)/a1 and that gives me 5. I could change a, b, or c numbers in such a way that it still results in 5 (or close to it). My question is, if I was asked to make D1 7, what is the best fit to make the formula equal 7? In the inventory world average inventory (A1) is what I can manage, B1 represents Sales, and C1 represents Returns. I don't even know if it is possible, but I'm thinking if I could show a few additional rows with alternatives that might be the best bet. Any help would be appreciated. Thx, Greg |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for best fit
You might try looking at Tools GoalSeek feature.............
Vaya con Dios, Chuck, CABGx3 "Greg" wrote: I'm looking for a formula to find the 'best fit' for inventory turns. For example: A B C D 1 10 100 50 5 The formula in D1 is: =(b1-c1)/a1 and that gives me 5. I could change a, b, or c numbers in such a way that it still results in 5 (or close to it). My question is, if I was asked to make D1 7, what is the best fit to make the formula equal 7? In the inventory world average inventory (A1) is what I can manage, B1 represents Sales, and C1 represents Returns. I don't even know if it is possible, but I'm thinking if I could show a few additional rows with alternatives that might be the best bet. Any help would be appreciated. Thx, Greg |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for best fit
You'll have to state what the relations between the figures are. If we
change a, b and c proportionally, you'll never get 7. If you only change a, it is simple. What happens to b and c if you change a? Once you state that, you can indeed use goal seek. In more complex situations (no easily expressed relation) you might need Solver -- Kind regards, Niek Otten "Greg" wrote in message ... I'm looking for a formula to find the 'best fit' for inventory turns. For example: A B C D 1 10 100 50 5 The formula in D1 is: =(b1-c1)/a1 and that gives me 5. I could change a, b, or c numbers in such a way that it still results in 5 (or close to it). My question is, if I was asked to make D1 7, what is the best fit to make the formula equal 7? In the inventory world average inventory (A1) is what I can manage, B1 represents Sales, and C1 represents Returns. I don't even know if it is possible, but I'm thinking if I could show a few additional rows with alternatives that might be the best bet. Any help would be appreciated. Thx, Greg |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for best fit
I was kinda hoping someone could provide a formula to get D by adding 3 rows:
row 1 would be the number for A, row 2 for B, and row 3 for C....or something like that. Goal seeker worked, but I'd have to run it 3 times. Greg "Greg" wrote: I'm looking for a formula to find the 'best fit' for inventory turns. For example: A B C D 1 10 100 50 5 The formula in D1 is: =(b1-c1)/a1 and that gives me 5. I could change a, b, or c numbers in such a way that it still results in 5 (or close to it). My question is, if I was asked to make D1 7, what is the best fit to make the formula equal 7? In the inventory world average inventory (A1) is what I can manage, B1 represents Sales, and C1 represents Returns. I don't even know if it is possible, but I'm thinking if I could show a few additional rows with alternatives that might be the best bet. Any help would be appreciated. Thx, Greg |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for best fit
I repeat: it depends on what your rules are. Changing just one cell is easy.
Two also, if one of them just increase by 1. etc. What did you finally get? -- Kind regards, Niek Otten "Greg" wrote in message ... I was kinda hoping someone could provide a formula to get D by adding 3 rows: row 1 would be the number for A, row 2 for B, and row 3 for C....or something like that. Goal seeker worked, but I'd have to run it 3 times. Greg "Greg" wrote: I'm looking for a formula to find the 'best fit' for inventory turns. For example: A B C D 1 10 100 50 5 The formula in D1 is: =(b1-c1)/a1 and that gives me 5. I could change a, b, or c numbers in such a way that it still results in 5 (or close to it). My question is, if I was asked to make D1 7, what is the best fit to make the formula equal 7? In the inventory world average inventory (A1) is what I can manage, B1 represents Sales, and C1 represents Returns. I don't even know if it is possible, but I'm thinking if I could show a few additional rows with alternatives that might be the best bet. Any help would be appreciated. Thx, Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|