LinkBack URL
About LinkBacks
I need a formula for to help determine what I can ship out. It needs to give me a number that is only skid quantites based on what needs to ship but I need it to not exceed what is on hand.
Attached is an example workbook.
I need a formula for to help determine what I can ship out. It needs to give me a number that is only skid quantites based on what needs to ship but I need it to not exceed what is on hand.
Attached is an example workbook.
Try this:
=ROUND((H8/F8),0)*F8
Thank you M1234.
No problem.Originally Posted by Rlong1818
Do you have an example of any more than just the 48 and 96 records so we can check if it works for more?
Th frmual does not work for all scenarios.....for examle if i have 47 in stock it tells me I can ship 48 (skid quantity). If it's not in stock, I can't ship it.
Hi,
Just to be clear then: you'll always err on the side of over-shipping if you've got enough in stock?
So if your Need to ship was 97, for example, with a Skid Amount of 48, and assuming you had enough in stock, you'd have to ship out 3 x 48 = 144 (and couldn't get away with being short by 1 with a delivery of 96)?
Regards
Good point. Is there a suggested formula to prevent shipping 47 extra rolls?
"Good point. Is there a suggested formula to prevent shipping 47 extra rolls?"
But that's my question - what's your company policy on this issue? You say they have to go out in Skids of a certain quantity (e.g. 48), but there may arise cases where you have a choice between a delivery with an extra 47 or 1 less.
I presume you have to go with the extra 47, since the alternative will not leave the customer happy. Or perhaps you have a restriction on the actual order quantity, i.e. orders cannot be places which are not a multiple (whole, half, quarter, etc.) of the given skid for that product?
Either way, for this to be written into the formula, you need to decide what should happen in these cases.
Regards
We do have to go with the extra 47 to keep the customer happy. I look forward to seeing your suggested formula.
Agreed. I don't fully understand what your policy is
we must ship the maximum amount of inventory we can in skid quantities. However we can not exceed what is on hand.
I think this may be the way to go, unless you think of something better.....
=ROUNDDOWN((H8/F8),0)*F8
"I think this may be the way to go, unless you think of something better.....
=ROUNDDOWN((H8/F8),0)*F8"
That doesn't work. Check it with a Skid of 48, Need to ship of 90 and In Stock of 95.
Regards
And what's your policy if you don't have enough in stock? Do you just ship out what you've got (even if it's way less than what the customer ordered), or not ship anything?
Regards
Is the skid amount a fixed quantity? Will it always remain at 48?
***And what's your policy if you don't have enough in stock? Do you just ship out what you've got (even if it's way less than what the customer ordered), or not ship anything?***
We ship what we have, only if it is a full skid quantity. There are some exceptions but that does not need to be into the formula. Skid wquantities will fluctuate, they will not always be 48
Presuming that, in cases where you don't have enough stock to meet the order, you ship the highest multiple of the Skid value possible which is less than or equal to that which you have in stock:
=MIN(ROUNDUP(G8/F8,0)*F8,ROUNDDOWN(H8/F8,0)*F8)
Regards
Did you try my last formula?
skid qty can fluctuate.
"skid qty can fluctuate."
My formula doesn't use a fixed Skid Quantity. It references the cell in which the Skid Quantity is held, so it adjusts to whatever value you put into that cell.
Have you tried the formula I posted? What results did you get that didn't meet your expectations?
Regards
Your last formula works. THANK YOU VERY MUCH!!!!
Ah, it seems our last posts crossed!
Anyway, you're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks