Minuteman International Implements an Oracle Applications Data Warehouse in 4 Weeks

1. Minuteman International Implements an Oracle Applications Data Warehouse in 4 Weeks A Case Study Dean Theobold, VP Manufacturing Stan Choflet, Jaros Mike Spencer, Jaros

2. Agenda • Minuteman Company Overview • Oracle Applications Implementation • Minuteman’s Reporting Environment • Jaros Company Overview • Jaros Data Warehouse Implementation • Discoverer Demonstration

3. Minuteman Company Overview • HQ – Addision, IL (Chicago) • 2002 Revenue – $72M, 400 Employees • Four Companies: • Minuteman International (Addison, IL) • Powered Cleaning Equipment • Multi-Clean – (Shoreview, MI) • Cleaning Chemicals and Solutions • Parker Sweeper (Springfield, OH) • Grounds Maintenance Equipment • PowerBoss (Aberdeen, NC) • Industrial Sweepers and Scrubbers

4. Oracle Applications Implementation • Began in 2001 with Financials, 11.03 • Rolling out Manufacturing to last 2 plants now • GL, AP, AR, Purchasing, Order Management, Inventory, BOM, WIP, Master Scheduling/MRP • Legacy Unix system (Historical Sales Data) • Bolt-on, Internally Developed Procurement Rejection System • Hardware: Sunfire V880 (4-Way)

5. Standard Oracle Reports didn’t meet user requirements Difficult to make good decisions w/o data Many Custom Reports & Applications The Problem Complex Table Structures Multiple Data Sources Custom reports were resource intensive Extensive use of Excel for data manipulation No tools or time to do detailed analysis (Pre-Jaros)Oracle Reporting Environment

6. Initial Requirements • CEO Driven Initiatives • Business Dashboard • Revenue/Product/Customer Analysis • DARC Engagement • Reviewed Requirements and Alternatives • Oracle BIS, EDW, Discoverer, Noetix, Jaros • Recommended Jaros Sales Analysis & Discoverer • Jaros/DARC Engagement • Product Demonstration to Executive Management • Decision to Implement Full Jaros Product Suite • Jaros Modules: GL, AP, AR, Purchasing, Inventory, Orders • Oracle Discoverer, Jaros Dashboard • Manufacturing (MRP, BOM, WIP) planned for Phase 2

7. Jaros Technologies • Background / Experience • Oracle Applications, Database • Custom Data Warehouses • Product Suite • Jaros Analytics Modules (Packaged DW/ODS) • GL, AP, AR, Purchasing • Orders, Shipments, Inventory, Costing • Service, Contracts (Q2) • BOM, WIP, MRP (Q2) • Fixed Assets, Projects (Q3) • Value Proposition • Dramatically Lower Costs and Time • 2 day install, 4 week implementation • Risk Free Trial • Packaged Application Approach • 80-90% out of the box (Mfg, Distribution) • Highly Extensible DW/ODS Architecture • Account Segments, Flexfields, Hierarchies • Custom, Legacy Integration • High Performance Architecture • Near Real Time Reporting Custom Data Warehouses Jaros Analytics Customers

8. Data Warehouse Implementation • Scope: Sales, Financials, Procurement, Inventory • Project Plan: 4 weeks to Production • Week 1: Installation of product; Configure Hierarchies, Flexfields and Account Segments; Data Validation; POC including out of the box Discoverer EUL for Data Warehouse • Week 2-3: User Requirements Sessions, Build Custom Business Areas, Deliver Enhanced EUL and Discoverer Workbooks, Integrate Bolt-On Procurement Rejection System Data • Week 4: Training IT and Finance Users, Promote DW to Production • Post Jaros Engagement • All Reporting and Analysis to be Derived from DW/ODS • Rapid Report Development in IT (10x – 100x) • Integration of Legacy Sales Data (Unix System Flat Files) • Business User Ad Hoc Reporting/Analysis with Discoverer Desktop • Business User Dashboard Web Report Delivery with Drill-Down • Starting with Rollout to Sales, Finance

9. Customer Quotes “In the first week, Jaros advanced our ability to do reporting and analysis by at least a year” Paul Neumann, Director - IT “This is the first experience related to our Oracle Implementation where we got exactly what we wanted in the expected timeframe” “Reports that used to take IT weeks to deliver, I am doing myself in just a few minutes” Dean Theobold, VP - Manufacturing

10. New Business Visibility with DW • Manufacturing Visibility • Shop Floor and Shipping Productivity by Individual • Relationship Between Open Orders, Supplies, Resources for Improved Planning and Management • On Time Delivery by Customer, Product, Plant • Rejects: Reasons for Scrapping Parts, Rework, Return for Credit • Supplier Visibility • Supplier Performance: On-time delivery, quality • Top $ Components: Supplier Competition • Supplier Consolidation Opportunities

11. New Business Visibility with DW • Customer/Sales Related Information • AR by Customer/Sales Rep • Open AR total by time bucket, Drill by Cust/Rep • Customer Trends for DSO • Open Orders by Customer, Delivery Trends • Net Bookings Snapshot • Product Sales by Rep/Customer • Inventory Visibility • Current/Historical Carrying Cost • New Inventory $$ per New Orders (Projected Costs) • By Item Type (Finished Goods, Subassembly, Category Code)

12. New Business Visibility with DW • ISO 9002 Project • Goals by Department • Analyze, Clean Up Data, Set Goals, Measure • Ex: Reduce “Catch-All Bucket” for Rejects • Ex: Picking Lines by QTR (Wrong Shipments, etc) • 44,000 line items, 27K Orders • Ex: On-time Delivery Performance • Verify Implementation Assumptions • Cycle Times • Standard Costs

13. Legacy Oracle Applications Other ERP How it Works 9iAS, Any Reporting Tool, OLAP, Other Applications Discoverer EUL: ODS Discoverer EUL: DW Multidimensional, Star Schema Data Warehouse – Strategic Reporting Summary, Detail, Snapshot Data ETL Mappings (Complex Transformations) Operational Data Store (ODS) High Performance Staging Area, Point of Integration, Lowest Level of Detail, Near Real Time Tactical Reporting ETL Mappings: Extraction, Transformation, and Load(Near Real Time) Insulation Views Change Tracking