Is there a Variable formula

[DwightM]

Hello All,

I am doing a Capacity analysis sheet and I am trying to create
forumula that takes
Open inventory (B10)
Production from Supplier (C10)
Consumption (D10)
then 14 days of Supply (G10)
21 days of Supply (H10).

Currently (B10) is a Formula (B9+C9-D9) This repeats down the colum

Now Currently I am manually inputing data Cusmption (D10) & Productio
(C10).


What I am looking to do is write a formula that would be in tha
Production (C10). This formula would come up with any number tha
would make (B11 an avervage of G10 and H10)

I just don't know how to write it. Is there a variant character?? An
assistance would be greatly appreciated.

Thank you
-Dwigh

 

[Guest]

If I understand you correctly you just need to back into the formula.

if NewOI = OldOI + Prod - Cons
and you want
NewOI = Average(14Days:21Days)
then
OldOI + Prod - Cons = Averge(14Days:21Days)
so
Prod = Average(14Days:21Days) - OldOI + Cons
therefore the formula in C10 shoud be
=AVERAGE(E10:F10)-B10+D10

 

[DwightM]

I have tried that formula it is not the result that I am looking for.
want Prod to equal what ever it takes to for OI to be the average D&F
I am stumped

 

[Guest]

I just realized that in my answer I had the 14day and 21day supplies in E and
F while your explanation had them in G and H so I would think that you'd be
able to switch AVERAGE(G10:H10) for AVERAGE(E10:F10). However in your reply
you state that you want the average of D and F. What's in F?

Is this statement what you are looking for?
OldOI + Prod - Cons = Averge(14Days:21Days) so that the NewOI =
Averge(14Days:21Days)

If so and the colomns are as follows

Open inventory (B10)
Production from Supplier (C10)
Consumption (D10)
14 days of Supply (G10)
21 days of Supply (H10)

then this should work.

=AVERAGE(G10:H10)-B10+D10

 

[DwightM]

I did revise those cells to the correct cell prior to sending out th
last. The tough part on this formula I am attempting to do is, I nee
the cell C10 to be a product that the outcome of B11 would be th
average of G10 and H10. I am beating my head against the keyboar
because I know what I want the out come to be but I can not figure ou
to write this formula. For example I need a character like (x) would b
any number