We are a distributor company that have been struggling to be able to use the requisition worksheet to facilitate the creation of POs.
Although we have watched multiple videos, we have not yet found the correct reorder policy for the item card that meets our needs. And it is
because we are having trouble identifying the calculations made by the requisition worksheet, depending of the reorder policy, due to duplicated
lines in several orders with the same item. This can make an extra charge in our orders for broken case, as example, by our vendor
(must of our items we sell by each and purchase by case).
Our needs have to match the following requirements:
1) We need the reorder point to be a 1 month of supply.
2) Our maximum stock needs to be between 2 or 3 months depending on how often we purchase per month.
3) The result on the requisition worksheet needs to show the difference between what we have in stock and the maximum inventory considering
if there is a requirement from our vendor to buy in such amount (case, dozen, bag, etc..)