Quantity deviation-Excess quantity
Continuing our previous discussion on quantity in the last blog, let’s discuss the excess quantity tolerance for objective bidding in this blog.
What do you think will happen if the supplier provides excess quantity?
1. The organization may have to rearrange logistic arrangement
2. For shelf life applicable items, less shelf life span availability before use.
3. Blockage of excess money for the unused inventory
4. Storage cost
Case 1 is applicable only for the companies who arrange transportation themselves. The organization must review and adjust logistic arrangement based on excess quantity from the supplier.
The second issue can be resolved by considering the consumption pattern of the item. If there is a higher probability that the item will be consumed within balanced shelf life, no problem in accepting excess quantity.
The third issue is vital. Blocking excess money for the unused inventory erodes operating profit margin. The organization should conduct a brainstorming session to discuss the impact of blocked finance on operating margin. For the 1% tolerance on excess quantity, the organization has to bear a burden of $12000 for the spending of $1200000. As the spending rises, this figure will go up. So, calculate it wisely along with a CFT of the supply chain, finance and top management. After deciding tolerance, convert it into the quantity for each SKU based on the cost of SKU. Calculation of allowance will have a known-effect on financial fitness of the organization and clear excess quantity limit can be provided to the supplier during objective bidding.
The last parameter, storage cost is comparatively easy to calculate and most of the organizations are aware of their warehouse cost. So, we will not discuss it here in detail. But consider the storage cost and fine-tune excess quantity allowance.
Though we have informed objectively about excess quantity allowance, sometimes supplier may insist for excess quantity. In such a case, notify the supplier of the financial impact which the supplier may have to bear. Also, instead of paying the excess component cost upfront, consider it as an accrued liability. Pay it to the supplier when MRP calls for the excess components.
Till now we have finished only two factors –Quantity and price for the objective bidding. We shall discuss the Quality factor in the next blog.











