Jump to content

Someone check my work, my brain hurts...

Recommended Posts

Ok, it's been a long weekend and there may have been much whiskey last night. I'm just a bit frayed around the edges and need someone to check the logic here.


Situation - Store demand from warehouse stock



DU - Total Demand

AV - Available units in stock

IB - Available units in warehouse, not stocked





Subtract AV from DU and only return demand remaining greater than 0 units = Unfullfillable Demand



Return DU unit quantity if the AV quantity is greater = Available Demand


if(Unfullfillable Demand>IB,IB)

Return all inbound units with demand if Unfullfillable Demand is greater than the inbound units = IB1


if(Unfullfillable Demand<IB,DU-AV)

Return only the inbound unit quantity with demand = IB2


IB1+IB2 = Inbound Demand


Final projection:

Inbound Demand + Available Demand = Estimated Fullfillable Demand


Simple process I think, just fielding this for some feedback before I continue to blow brain cells.






Link to comment
  • Replies 11
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.