Production Order and Inventory Control DEMO

Description
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: https://www.eloquens.com/tool/Mdy0S8Zb/marcus-servatti/production-and-inventory-control-by-batch-in-excel-demo

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: https://www.eloquens.com/tool/Zv3pTbE7/finance/inventory-management-excel-templates/production-order-and-inventory-control