Formula for category ratio & numbers
 

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 explain it clear. but this question is a chalenge for me?

Thanks in advance
Bahareh