Improved Scheduling Efficiency with QAD’s New Component Availability Check

1. Improved Scheduling Efficiency with QAD’s New Component Availability Check Carianne Nieuwstraten/Brent ShooltzMMUG - March 22-24, 2009

2. Agenda • Introduction • Business issues and solution • How it works • Planning/Scheduling cycle fit • Demo

3. Introduction Component Availability Check

4. Business Drivers • Production Schedulers need ability to quickly view component availability and release jobs to the floor without material shortages • Reduce large WIP quantities • Reduce late shipments • Material Planners need to verify that there are enough materials on hand to support the production plan • Prevent expedites by taking action in advance

5. Component Availability Check (CAC) • Perform real-time component shortages checks • Perform check across multiple work orders and status • Check current or future components projected quantity on hand • Ability to check for root cause of shortage and possible solutions • Take action

6. CAC Overview • Three new Component Availability Check functions introduced in QAD 2008.1 SE and EE: • Component Check By Item/Work Order • Component Check By WO/Production Line • Component Check By WO/Work Center • All three functions are part of the standard product

7. Business Issues &Solution Component Availability Check

8. Business Issues Component Availability Of Production Schedule Print Dispatch List Work Order Component Check Component Inquiries & Reports Component Spreadsheet Summary the impact of which is • Limited visibility of material shortages beyond a day results in inability of both production scheduler and materials planner to respond to material shortages • Increased inventory buffers to offset above issues Component Detail Analysis Run MRP Detail Inquiry Run Inventory Detail Report Run WO Bill Report The Problem of • Drill down into the component shortage information for route cause analysis is highly time consuming • No ability to perform component shortage checks across a selected range of work orders in various work order status’s

9. CAC performs the analysis for you Takes component checking from a difficult & time consuming task to an automated process CAC consolidates critical decision information & actionable applications Business Solution WO/Production Line WO/Work Center Item/WO

11. First shortage appears tomorrow

12. Which components are causing the shortage?

13. Displays the BOM and the component status’s

14. Why do these components have shortages?

15. Displays global visibility to component supply/demand

16. Take Action Links to Schedule/Order Maintenance Screens

17. How It Works Component Availability Check

18. Overview • Production Schedulers developing the production schedule • Can I execute against my production schedule – are there any component shortages? validate material top-down Single Level Check Work Order & BOM Must Exist Parent Sub-Assy (Phantom) Sub-Assy Purchased Explodes through phantoms Sub-Assy Purchased Purchased Purchased Sub-Assy Purchased validate material bottom-up • Material Planners expediting shortages • For the components I manage, are there any shortages that will impact production?

19. Component Checking (Prior to CAC) I have enough for one work order, but do I have enough for all work orders? Work Orders Component Supply On-Hand Inventory Component Demand

20. Component Check Engine (CAC) Future Supply Planned Receipts Planned Scheduled Receipts Expiring Inventory Component Supply Firm ASN Scheduled Receipts On-Hand Inventory Released Expired Inventory Component Demand WED Component Demand FRI Component Demand THUR

21. Planning/Scheduling Cycle Fit Component Availability Check

22. Planning/Scheduling Cycle Months-Weeks-Days Days Day-Shift-Intervals Master Scheduling Production Scheduling Release To shop Floor Execution QPS Master Schedule Workbench CAC By WO/Production Line CAC By WO/Work Center CAC By Item/Work Order Materials Planning Materials Monitoring & Expediting

23. Demo Component Availability Check

24. Questions?