Equal to or less than formula
 

I have filter media that I need to order every week and some filter medias I
have too much of. I need a formula that can tell me the exact date I need to
order and how much. I have an example of what I have so far:

C9 is Weekly Usage 2,000
D9 is Actual Inventory Date 10/06/05 20,000
E9 Firm Future Receipts week ending 10/10/05 0
F9 Projected Inventory weeking ending 10/10/05 18,000
G9 Days on hand Projected 10 days
My lead time is 60 days

Can anyone please help me with a formula that can calculate the exact date
and quantity I need to order?

Thank you,
Angie

Do you have dates and a value in the same cell?

If the lead time is 60 days, and you have 10 days of stock you need to order
now.

To determine, you would just check if the days on hand is less than lead
time + a factor, and if so, order. So say you wanted to order with a week's
slack time, use something like

=IF(days_on_handlead_time+7,"no need to order", "ORDER NOW!!")

But how do you want to be notified, with a formula, some pop-up message when
you open the workbook, or what?

--
HTH

Bob Phillips

"Angie" wrote in message
...
I have filter media that I need to order every week and some filter medias
I
have too much of. I need a formula that can tell me the exact date I need
to
order and how much. I have an example of what I have so far:

C9 is Weekly Usage 2,000
D9 is Actual Inventory Date 10/06/05 20,000
E9 Firm Future Receipts week ending 10/10/05 0
F9 Projected Inventory weeking ending 10/10/05 18,000
G9 Days on hand Projected 10 days
My lead time is 60 days

Can anyone please help me with a formula that can calculate the exact date
and quantity I need to order?

Thank you,
Angie

Bob,

No, I do not have values and dates in the same cell.

I would like to be notified in the way of a formula.

Thank you in advance for your help.
Angie

"Bob Phillips" wrote:

Do you have dates and a value in the same cell?

If the lead time is 60 days, and you have 10 days of stock you need to order
now.

To determine, you would just check if the days on hand is less than lead
time + a factor, and if so, order. So say you wanted to order with a week's
slack time, use something like

=IF(days_on_handlead_time+7,"no need to order", "ORDER NOW!!")

But how do you want to be notified, with a formula, some pop-up message when
you open the workbook, or what?

--
HTH

Bob Phillips

"Angie" wrote in message
...
I have filter media that I need to order every week and some filter medias
I
have too much of. I need a formula that can tell me the exact date I need
to
order and how much. I have an example of what I have so far:

C9 is Weekly Usage 2,000
D9 is Actual Inventory Date 10/06/05 20,000
E9 Firm Future Receipts week ending 10/10/05 0
F9 Projected Inventory weeking ending 10/10/05 18,000
G9 Days on hand Projected 10 days
My lead time is 60 days

Can anyone please help me with a formula that can calculate the exact date
and quantity I need to order?

Thank you,
Angie

My pseudo-formula was an attempt to show you how to do it, which you should
be able to adapt to the data.

If you are still struggling, post some real example data with your expected
results, with cell details (column & row)..

--
HTH

Bob Phillips

"Angie" wrote in message
...
Bob,

No, I do not have values and dates in the same cell.

I would like to be notified in the way of a formula.

Thank you in advance for your help.
Angie

"Bob Phillips" wrote:

Do you have dates and a value in the same cell?

If the lead time is 60 days, and you have 10 days of stock you need to
order
now.

To determine, you would just check if the days on hand is less than lead
time + a factor, and if so, order. So say you wanted to order with a
week's
slack time, use something like

=IF(days_on_handlead_time+7,"no need to order", "ORDER NOW!!")

But how do you want to be notified, with a formula, some pop-up message
when
you open the workbook, or what?

--
HTH

Bob Phillips

"Angie" wrote in message
...
I have filter media that I need to order every week and some filter
medias
I
have too much of. I need a formula that can tell me the exact date I
need
to
order and how much. I have an example of what I have so far:

C9 is Weekly Usage 2,000
D9 is Actual Inventory Date 10/06/05 20,000
E9 Firm Future Receipts week ending 10/10/05 0
F9 Projected Inventory weeking ending 10/10/05 18,000
G9 Days on hand Projected 10 days
My lead time is 60 days

Can anyone please help me with a formula that can calculate the exact
date
and quantity I need to order?

Thank you,
Angie