formula to find categories ratio & numbers

[Bahareh]

Hello

Well.... of cource there is a manual timing way for my question but I
require a more smart way or a formula for it.

We have a Monthly Forcast which is broken to 4 category & in the other hand
we have a Total Master Plan Requirements. Based om Monthly Forcast we can
find ratio of each category to others & then multiply it with Total Master
Plan requirements to calculate "What should be each category to achieve Total
Master Plan requirements?"

Exp:
months Jan Forcast Feb Forcast Plan
Category 1 A C ?
Category 2 B D ?
Category 3 E F ?
Category 4 G H ?
Sum A+B+E+G C+D+E+F ?
Master Plan M K J

It is clear that with good job we can reach A+B+E+G= M otherwise we are
behind M and so on... again the question is "What should be each category to
achieve Total Master Plan requirements?"


I am not sure if I explan it clear. but this question is a chalenge for me?

Thanks in advance
Bahareh

 

[Ken Sheridan]

Bahareh:

For January Cat 1: A/(A+B+E+G)*M
For January Cat 2: B/(A+B+E+G)*M
For January Cat 3: E/(A+B+E+G)*M
For January Cat 4: G/(A+B+E+G)*M

For February Cat 1: C/(C+D+F+H)*K
For February Cat 2: D/(C+D+F+H)*K
For February Cat 3: F/(C+D+F+H)*K
For February Cat 4: H/(C+D+F+H)*K

Ken Sheridan
Stafford, England

 

[Bahareh]

Thanks Ken. I changed the layout of the info so I could use this simple
formula.
sometimes minds block!

Thanks
Bahareh

 

[Bahareh]

Thanks Ken. I changed the layout of info so I could use this simple formula.
sometimes mind blocks!

Thanks
Bahareh