G
Guest
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.
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.