With this free template for calculating minimum or security stock you will be able to carry out simulations to optimize the quantities to purchase in a month in order to reduce and optimize final stocks.
Still many companies have excess stocks due to a lack of planning. This tool may not solve all their problems, but it shows those parameters or basic configurations you may take into account in optimizing stocks.
With Stocks Planning Procurement Simulator you will be able to define the suppliers, the products, register the annual demand, calculate the daily average demand, assign the supplier’s delivery term in days, assign a security period in days, assign the supplier’s minimum purchase quantity, calculate the minimum security stock and the recommended purchase quantity.
Once the parameters have been defined, you will be able to carry out simulations of all the products defined with their respective suppliers, in the simulation the quantities to be purchased will be recommended based on demand and initial stock.
The initial stock, the quantities to be sold and the quantities to be purchased can be simulated, as a result the final stock calculated can be compared with the security stock.
Below you have the download link
Images Stocks Planning Procurement Simulator Free Excel Download
More information about Controlling Tools
- Employee Management Free Excel Download
- Budget Control Excel YTD & FYForecast M15
- Balanced Scorecard Excel Template Key Indicators (KPIs) Control
- Excel Budget BOM Manufacturing Costs and Margins M15
- KPI OEE Report Excel Free Template
- Home Budget M2 Excel Template
- Excel Manufacturing Standard Costs and Margins M10
- Budget Control for Events M1 Excel Template
- Wedding Budget Control M1 Free Excel Template
- Suppliers Prices Comparative Analysis Free Excel Download
- Direct Costing Free Excel Template
- Free Excel Template Break Even Point Calculation
- Marketing Plan Free Excel Template
- Decisions Sale Price Lists Calculation Free Excel Template
- Warehouse Inventory Control Free Excel spreadsheet
- New Investments Requests Form Free Excel spreadsheet
- Hotels Excel Cost Calculation
- Customer Invoices Free Excel Template
- Training Management Free Excel Spreadsheet
- Multiproducts Breakeven Simulator Free Excel Template
- FREE Excel Balanced Scorecard 2KM15
- Payments Forecast Control FREE Excel Template
ERP ODOO Functional Consultant and Controller (Management Control & Controlling)