ODOO Purchase Orders forecast.
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.
More information about Controlling Excel Tools
- Advantage cost calculation with Excel in companies
- Inventory Control and Dashboard Excel Template
- Budgetary control System with Projections example
- Does a company need to automate or optimize administrative tasks?
- Excel Template Financial KPIs Dashboard
- Wedding Budget Control M1 Free Excel Template
- 3 Methods Selling Price Calculation Free Excel Template
- Working Hours Timesheet Free Excel Template
- Excel Template Cash Flow Forecast M15
- Plan, Do, Check and Act (PDCA) Excel Template
- Download Example of Excel thermometer chart
- Retail Commerce Profit Analysis Free Excel Template
- Project Management Excel Templates
- Pickleball and Paddle Sport Club Profit Analysis Free Excel spreadsheet
- Decisions Sale Price Lists Calculation Free Excel Template
- Employee Management Free Excel Download
- Balanced Scorecard M1 Excel Template
- Marketing Budget Excel Spreadsheet
- Human Resources Excel Templates
- Employee Absences Free Excel Template
- Tracking Shipments Excel Template
- KPI Sales and Commissions Control Excel Template
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.
Controller ODOO ERP