Production Order and Inventory Control
Originally published: 08/09/2020 20:25
Publication number: ELQ-48279-1
View all versions & Certificate

Production Order and Inventory Control

Create Production Orders and Control your Inventory!

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

With this spreadsheet you can create Production Orders and control your Production and inventory . Select the components of the Production Order and perform the Production Entry.

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 Value, Input and consumption of components and Finalized Orders.

Track monthly production with annual and monthly data available to you with just one click!

You can also select a Production Order, and view various details on the charts quickly and simply, including value added per production order, monthly production and returned components.

Component inventory, the table include search engine! Easy, objective and practical!

Indicators with status of Production Orders.

Graphs with entry demonstration and monthly component exit are also available.

* Material Needs Planning

Make the control by changing the 'Status' of the desired Production Order, select 'Separating Materials', enter the quantity and that quantity will be separated for this production and low on stock. At the end of production, inform the total produced and in case of leftovers, this balance returns to the stock.

Manage your production and inventory. Control the entry, separation and use of materials necessary for the production of your company. Track inventory reports and automatically generated indicators.

* Other features

Follow the main reports, graphs, indicators and Dashboards with essential information for management, monitoring and planning.
Production Order Printing: The form is ready and completely filled, just inform the number of the Production Order and print.

If you have any ideas or changes you want to make to the spreadsheet, get in touch!
I value your feedback, so let me know what you think!

** Make sure to test the free version of the spreadsheet!



1. REGISTRATION: In this area you will register the Components that will be used in the Production Orders. Fill in all fields carefully.

2. ENTRY: Check in the Components as your company receives them. Keep your inventory up to date.

3. PO REGISTRATION: Fill in the fields with the information that will be used in the Production Order and click on "Register PO" (Production Order), the information will be saved in a database but you can edit it later if you need to. Production orders are saved and can be viewed in a list in cell "D5".

4. PRODUCTION: View details of all PO's. Stock Output: number of separate components for this PO, select Separating Materials, Waiting for Production or In Production and the quantity informed will be reserved for this PO. After finished, select Finished and fill in the Finish Date.

5. PRINT PO: The Production Order assists the team with information and guidance needed for production. The form is ready and set up for printing.

6. REPORTS: General: reports with important information divided monthly. Component Stock: here you will see the real situation of your stock, income, division goods and component exit. Use the searches to find the desired component or lot.

8. DASHBOARDS: Visual presentations and control panels with the most important information. Here you will have access to graphs and indicators for analysis, management and decision making.

This Best Practice includes
1 Excel Spreadsheet

Acquire business license for $20.00

Add to cart

Add to bookmarks


Further information

Manage your stock, create and control production orders, full control of your components and products!

You like efficient tools to help you!

You don't use components in your company or you don't need to create production orders.


  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


Any questions on Production Order And Inventory Control?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...