What signifies that the product is "in overstock," or is that purely a
function of no/low sales for that product?

It would also help to know how your data is structure within the worksheet.
If it's in an external datasource, knowing about that would help.

How many months of supply does each warehouse need to have? In the second
example you state Whse 3 has 300 in stock and usage of 100 over 3 months, so
a 9 month supply. How much SHOULD they have and how much should be relocated?


"Barbara" wrote:

I asked this before and perhaps there was not enough information, so I will
try again.

We are a wholesale distributor with 8 branches across Canada. We also have
a large quantity of product sitting in the wrong locations. I need to know
how to take that product and distribute to locations that are selling the
product.

The example that I gave is as follows, if more information is required, or
further explanation is needed I would like to know. This situation is
critical, and I would like as much input as I can get. So anyone out there
that can assist me would be wonderful. Thank you.

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 would like to move the 30 from warehouse 1 to warehouse 2 and 5 with the
appropriate quantities according to their on hand and usage.

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 again.