Improve Supply Chain Features - Calculate Desired Stock Level and Reorder Levels
This playlist will enlighten you on supply chain management. https://www.youtube.com/playlist?list=PLzxiTolMU91ViHWtxhfQxZkH3ZWDEGecp
As I understand RepairShopr is trying to be more attractive to Wholesalers. There are several things wholesalers would love to see in RepairShopr.
New section in Admin - Supply Chain Management
This would be a calculation of caring costs of inventory on an approximate basis. This would be a basic calculator, working out the total valuation of their inventory (at cost), and would provide input for cost of finance (as a percent), electricity, insurance, and the RMA data from breakages.
In items we would have two bits of data, one would be a manual input fixed costs of ordering - this is things like approvals, bank fees, ect.
Also in items it would offer an daily average demand (sell rate), based on the quarter to date. This would be VERY HANDY in itself, currently this data is near impossibly to work out.
In vendors we would put an average lead time, this would prefil the expected date of arrival in ReapirShopr but still allow it to be changed.
Then there would be an option to set automatically Desired Stock levels which would be worked out using a simple Economic Order Quantity calculator. This would take daily average demand annualized, cost of holding inventory as a percent, and fixed order costs into account.
The reorder point would be the daily demand, multiplied by the average lead time in days.