Optimizing Production and Material Planning…
User friendly WO What-if Excel tool transforms the way you manage production data in QAD ERP. In these turbulent times, where conflicting restrains are the norm (reduced material inventory, urgent order spikes, etc), this tool helps schedulers utilizing the production resources wisely and efficiently, without much effort, contributing to your company success.
More often than not, companies do not want to stock surplus of component/material inventory. This adds complexity to production planners, specifically when company receive urgent/important orders. Customer expectations have changed and these situations are not rare.
What happens in production floor? Materials are allocated to other less important work orders are pulled out towards more important work orders. Less important orders are placed on-hold, until new components arrive. It’s not simple process to manage this situation QAD functionality. Specifically, for production planner it’s impossible to know, which orders, if placed on-hold, they can pull the components from? Do they have enough components on all levels of BOM to build, so many such and such products on specific dates?
WO What-if has been designed to help you solving these problems. And not only that, watch the demo below.
You download existing Firm, Released and Plan work orders into easy-to-use spreadsheet, change the sequence of orders, add any Simulated orders or place any on-hold. Then run shortages check to see if you have enough materials to complete the orders. WO What-if tool provides the summary and detail reports showing the result of shortage check. If shortages are found, the tool tells part numbers, quantities, dates and supplier info to prepare purchase orders.
Once you like the scenario, then convert massively SIM or Plan Orders into Firm and then you can massively release Firm orders to the floor, printing WO tickets from the spreadsheet.
Features
- Ability to perform What-if scenarios in the spreadsheet by adding non existent in QAD Simulated Work Orders, placing existing Work Orders on hold, changing orders details on the spreadsheet only (not in QAD), changing order priorities. Perform immediate component shortage check according to order priorities in the scenario.
- Generate Detailed Shortage Report throughout the entire BOM, with supplier, buyer ID’s and other info required for immediate PO creation.
- Ability to identify sub assembly shortages and massively create/release Work Orders for them.
- Massively convert SIM Work Orders and selected Planned orders into Firm Orders in QAD, when you like the scenario.
- Massively Release Work Orders to the floor, printing batch of WO tickets.
- Convenient drill downs for decision support.
- Customizable design to fit your needs.
More Information about Excel Loaders