Formula to spread one number over 2 or 3 or .....8 different areas
 

I have a situation here where I have overstock in one location but I have 2
or more locations that could take some of the product.

Example:

Whse 1 Product: XYZ 30 each This is all in overstock for this
warehouse.

Whse 2 Same Product has 10 each in inventory and Usage is 5 over the
past 3 months.

Whse 5 Same Product has 2 each in inventory and usage is 10 over the past
3 months.

I also have on the same spreadsheet:

Whse 1 Product ABC, with 200 in overstock.

Whse 3 Same Product has 300 in stock and usage of 100 over the past 3
months.

Whse 6 Same Product has 100 in stock and usage of 100 over the past 3
months.

and so on.

I need help on creating a formula that would do the bulk of the distribution
for me, taking into account the usage over the past few months, and the
quantity already on hand.

I am working with Excel 2003, and if anyone has any tips I would appreciate
it.

Thank you.