How to forecast Purchase Orders with ODOO.
Recently one of the companies to which I provide ODOO Management and Financial Control & Functional Consulting services, requested me an interesting challenge, this company had about 300 uncontrolled products.
Products that they had no idea how much they needed to buy to optimize stock and safely cover forecast demand.
To perform the design of this type of tool, the first thing that must be taken into account is what type of information is going to be worked with, in this specific case, we are always going to work with future data, except for the current stock and the entries and reserved outputs in the warehouse, that is, those purchases or sales that are pending arrival or delivery, but are registered in the system.
If you already use ODOO, you will know that when you validate a purchase or sales order, the first thing the system does is prepare the entry or exit movement of the warehouse, that is, it generates the delivery note in preparation or reservation mode.
These movements not yet made, which affect the virtual or planned stock, are ideal for calculating purchasing needs.
Let’s guess that a product has a real stock of 100, reserved inputs of 20 and reserved outputs of 50 during the same month, this means that if we did nothing at the end of the month the final stock would be 70.
But the forecasts are not so simple since other elements come into play. Suppose that for that month the expected demand for the remainder of the month is 120, if this were fulfilled we would not be able to supply customers since the final stock would be negative, in this case -50.
Therefore, you have to buy, but to know how much you have to buy, you have to take into account the supplier’s lead time to ensure that we are going to receive the products on time to be able to supply customers within the commitment schedule, we should also provide of a minimum safety stock that would cover the expected daily demand multiplied by the supplier’s lead time.
In other words, if the forecast demand is 5 and the supplier’s lead time is 10 days, our safety stock for this product would be 50.
This means that the final stock should never be less than the minimum stock of 50, but since is also intended is to optimize the stock, then we will buy the necessary quantity not only to cover the forecast monthly demand but also the final stock is at least equal to safety stock.
In this way, taking into account all these variables, we can have a predicted amount with more or less accuracy of how much should be purchased each month.
The data can be updated with a certain frequency, either every week, every 15 days or every month to adjust the expected amounts of purchases.
Then there is the experience of the purchasing manager to be able to adjust the variables and finally decide what quantities to buy, but at least he already has a reference to base himself on.
As a result of the implementation of this tool, the company is optimizing its stock, it is not buying blindly, and therefore it is saving money, more space in the warehouse and obtaining more cash.
Images How to forecast Purchase Orders with ODOO
If you need advanced reports made with Excel for your ERP ODOO (ideal for reports that do not require control or planning in real time) just contact me.
Download Planning Purchase Orders
More information about Controlling Excel Tools
- Wedding Budget Control M1 Free Excel Template
- Bugs Tickets Resolutions Control Excel Template
- Training Management Free Excel Spreadsheet
- Does a company need to automate or optimize administrative tasks?
- Inventory Control and Dashboard Excel Template
- Employees Best Practices Improvements Requests M2 Free Excel Template
- Excel Spreadsheet for SWOT Analysis
- Excel Template Action Plan PRO
- What is Budgetary Control?
- Excel Budget BOM Manufacturing Costs and Margins M15
- Excel Template Financial KPIs Dashboard
- Projects Costs Calculation and Control M3 Excel Template
- Profitability and Treasury Problems, when the desired situation is different from the real situation
- Benefits of Using an Excel Dashboard Speedometer Template
- Excel Template Human Resources HR Management Control
- Excel Template Employee Training Control
- Employee Management Free Excel Download
- Decisions Sale Price Lists Calculation Free Excel Template
- Cash Flow Vs Treasury Foecasts
- How to Calculate Variable Costs and Identify Them
- Excel Financial Scorecard or Dashboard. What you need to know
- Hotels Excel Cost Calculation
More Videos about Management Accounting
Industrial company financial manager
Dani is helping us to use ODOO more efficiently, we are rapidly leveling up with the ERP. It is also preparing us very useful analysis and control reports and outstanding management tools. Always available by phone or email, willing to help and collaborate in everything that is proposed. Very professional and fast work. A key service for our company.
Controlling Consultant
Controller ODOO ERP
Email: dani@cashtrainers.com