• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula to calculate month on hand

Rebeca Zepeda

New Member
Need your help with a Formula to calculate month on hand
as follows:
Current total November inventory is 1000
Demand remaining in Nov 500
Demand Dec 400
Demand Jan 300
So with 1000 we cover all Nov remain inventory 1000-500, remaining 500
With 500 we cover December demand 500-400, remaining 100
We don’t cover all January demand , a fraction is then calculated : 100/300= .3333
Therefore total Month on hand is 2.33
 
Hello can you help me with a formula when column A stars with pla And column b starts with t then show trailer as answer if A starts with pla and column b starts with c then warehouse
 
Back
Top