Production Order and Inventory Control DEMO
Originally published: 09/09/2020 07:29
Last version published: 01/10/2020 07:19
Publication number: ELQ-80602-2
View all versions & Certificate

Production Order and Inventory Control DEMO

Demo version of Production Orders and Inventory Control Spreadsheet!

Production and Inventory Control by Batch in Excel

** Note: There's a free demo of this spreadsheet for you to test! You can find it in my page or go to:

With Batch Production and Inventory Control, you will have full Production and inventory control including batch division. Select the components of the Production Order and perform the Production Entry.

Select the batches to be consumed in the system and keep the History and Traceability of all transactions carried out.

The System also allows you to return to production if necessary, and the respective amount will be returned to the Inventory!

The Consumption Report shows a list with the components consumed, batch, date and time of consumption separated by Production Order!

Create, control and print Production Orders in a practical and organized way. The spreadsheet simulates an MRP system - Material Requirements Planning, with entry of goods,control and use of materials. Choose the materials to be used in the Production Order, click on 'Register PO' and let the macro do the work for you.

A history with all Production Orders will be available to facilitate the creation of new orders with just one click.
At any minute you can check the 'PRODUCTION' panel that contains all the information and history of all the Production Orders created and finalized.

* Reports, Charts, Indicators, Dashboards and more!

Select the year and see reports prepared with data separated by month with the main indicators of your company, including: Total production, Production

Note: This is a demo spreadsheet. To buy this spreadsheet go to:

This Best Practice includes
1 Excel Spreadsheet

Marcus Servatti offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Create Production Orders, manage and control your stock with batch segregation, perform production entry selecting the batch to be consumed and the entire transaction history is maintained in the Consumption Report.

You like efficient tools to help you!

You don't like to use spreadsheets with VBA code.

4.9 / 5 (7 votes)

please wait...