The Seventh Annual EPICS User Conference

1
The Seventh Annual EPICS User Conference

• April 20-22, 2005
• Gaylord Texan Resort Conference Center
• Grapevine, Texas

2
Eleven New EPICS CustomersSince Last Conference
3
Eleven New EPICS Customers Since Last Conference

• Pries Enterprises
• Crown Extrusions
• American Alum. Ext. of Wisconsin
• MI Metals Prescott Valley
• BRT Extrusions
• Zarbana Ind.

• ALDECA
• Jalex Mfg.
• TAI-AO Al.
• Aluminio de Baja California
• Crane Al. Extrusions

4
Thursday Sessions

• 900 1130
• EPICS V8 Overview
• Scheduling with Preactor 1
• Features added since last year
• Order Entry with Spreadsheets
• Master Workorders

• 130 400
• Scheduling with Preactor 2
• New Die Fields
• Production Posting
• Rack Tracking
• Wishlist Session II

5
Thursday Evening

• 530 1030
• BBQ Dinner
• At
• Billy Bobs Texas
• Evening at the
• Ft. Worth Stockyards

6
Friday Sessions

• 900 1130
• Application Hosting
• Data Entry using Spreadsheets
• Warehousing
• Packing Ticket Improvements
• Master Packing Ticket
• Scanning with a Pocket PC
• Tax Handling

• 130 400
• Crystal Reports 11
• Other new EPICS V8 Features
• Really Interesting Software
• Browser-based Support for EPICS
• Wishlist II
• Drawing for IPOD Shuffle

7
Conference Theme What Should It Be???

• 2002
• Maximizing Your Investment in EPICS 2000

8
Conference Theme What Should It Be???

• 2003
• EPICS
• Unleash the Power!!

9
Conference Theme What Should It Be???

• 2004
• EPICS Conference in the Keys
• Unlocking the Future

10
Conference Theme What Should It Be???
2005 Over 25 years maybe go with history
maybe Foy family history
11
Foy Family History

• Frank Foy and Sons

Poultry For Profit
12
Foy Family History

• Charles Foy

Pigeons for Pleasure and Profit
13
Foy Family History

• Foy Cigarette Paper Company

Foy Brings Joy
14
Proposed Conference Themes

• Poultry for Profit
• Pigeons for Pleasure and Profit
• Foy Brings Joy

15
Just imagine a paperless plant powered by EPICS
V8!!
16
Final Theme

• EPICS V8
• Powering the Paperless Plant

17
Overview of EPICS V8Powering the Paperless Plant

• Jim Foy

18
Introducing
19
Introducing EPICS V8
20
EPICS V8

• Evolutionary, not Revolutionary
• Most differences are additions, not changes

21
EPICS V8Powering the Paperless Plant

• Electronic Order Entry
• Email Acknowledgements
• On-screen scheduling
• On-screen backlogs, status reports
• Press display schedule, workorder
• Realtime production posting
• Scan for items ready for production
• Electronic picklists
• Email manifest and invoices

22
EPICS V8Powering the Paperless Plant

• And finally.

Rack Tracking
AutoTag!!!
23
Scheduling with PreactorSession I

• Mike Novels
• General Manager
• Preactor International

24
Coffee Break

25
Features added to EPICS since last year(Versions
2000.17.1 2000.18.3)

• John Stenger

26
Top 2004 Wishlist Items

• Tracking by Rack
• Improved Tax Handling
• Create a Billet PO Module. For entering or
  importing and maintaining billet PO data.
• Provide additional Die Maintenance and Correction
  features. More accurately track die maintenance
  history.
• Create additional fields on the Customer
  Maintenance screen for shipping and receiving
  hours and load/unload capability.
• Record the date that items were placed on Plant
  Hold.
• Create a machine-specific production calendar
• Add a Quotation Module, allowing creation and
  printing of a quotation, saving it, and later
  activating it as a Sales Order.
• Create additional fields on the Customer
  Maintenance screen for cell phone, multiple fax
  numbers, etc.
• Calculate Plan Dates at Order Entry based upon
  any department in the routing, not Extrude or
  Ship only.
• Automatically close orders (set status to 'H')
  with a routing ending with 'STOCK'.
• Allow a one-time or manual method for selecting a
  Ship-to customer (shipping to a customer who does
  not have a record on the Customer Maintenance
  screen).
• Provide a method to automatically be notified of
  available stock inventory and to Fill-From-Stock
  from the Order Entry screen.
• Track Die Box contents. Maintain die box
  inventory, planning, history.
• When a user changes the extrusion date for an
  item on the QBE Items screen, use this date and
  the department lead times to recalculate the
  other plan dates.
• Save the Extrusion runout for each billet size
  used by each press production posting.
• Receive billets by cast number with chemical
  composition.
• Store manual adjustments to on-hand billet
  inventory as logged positive/negative usage
  transactions.
• Separate the SOItemNum field in the SOChangeLog.
  This would allow easier identification of changes
  to individual items.

27
Order Tracking Improvements

• SOItem.PlantHoldDt records date an item was
  placed on plant hold
• Mark stock items complete (Status H) once you
  have stocked the ordered qty
• Allow posting scrap on packing screen for items
  that include STOCK but not PACK

28
User Interface Improvements

• Show only Bill-To customers in right-click list
  on CS Inquiry and Part screens
• Ask user if they want to immediately add a copy
  to a newly created Die
• Automatically set StdCopyNum to the first DieCopy
  added to a Die
• Add ToolTips to Advanced Order Entry

29
New Configuration Settings

• gPackWtAutoCalculate allows automatic bundle
  weight calculations
• gMaxShift sets the highest allowable production
  shift number
• gPressRateMaxPct and gPressRateMinPct define of
  lifetime wt/hr that triggers a warning at the
  press

30
Miscellaneous Changes

• Import CSV file data into EPICS database
• Save button on Show All screen exports data to
  a CSV file
• Record manual changes made to billet inventory in
  Billet History table
• New pricing units Price/Theoretical
  Lb _at_ Price/Theoretical Kg

31
Miscellaneous Changes (continued)

• Allow scrapping of some or all of an inventory
  bundle from Maintain Stock screen
• One-click creation of offsetting Invoices or
  Credits
• Adjust Part Prices screen
• Permit percentage price changes on Adjust
  Selected Prices screen

32
New EPICS Features

• Questions/Demonstration

33
Order Entry using Spreadsheets

• Chris Delzell

34
CSV file

• Comma Separated Values
• Can be created by Excel, Access, and many other
  applications.

35
Creating the CSV file.

• First line contains field names.
• Field names in CSV match field names in the
  SOEntry table.
• No particular order.
• Data lines follow header format.
• Only Five required fields.
• CustBill
• Part
• CustPO
• OrdQty
• OrdUnit

36
Example of a CSV file
37
Import New Sales Order from CSV file Screen
38
Highlights Bad Orders

• EPICS highlights bad CustBill or Part numbers.

39
Modify with Order Entry
40
Other Features

• Apply system base price to non-extrusion orders -
  parts with a non-extrusion routing will be
  charged the standard base price.
• Save grid data to file - used if some items
  cannot be created due to incomplete information.

41
Master Workorders

• John Stenger

42
Master Workorders

• Combines many small-quantity workorders into a
  single Master Workorder (MWO) that can be viewed
  or printed
• All components of an MWO are automatically tied
  together on the press schedule
• Production is posted against an MWO as a single
  entry
• EPICS allocates the individual item quantities
  automatically

43
EPICS V8 Production Flow using Master Workorders

• Enter and post new sales orders.
• Scan for small lots and Create MWOs
• Calculate (and print) workorders
• Schedule the press
• Post press production

44
Creating Master Workorders
45
Scan for small lots and create Master Workorders

• Lots can be combined if they share the same Die,
  Alloy, Temper, and Extrude length
• Selected lots are assigned the same MWONum (using
  NextNum table)
• When scanning for workorders to print, all
  components of an MWO will be selected any time a
  single lot is selected
• Ditto for the Press Schedule screen

46
Creating Master Workorders in EPICS V8

• Questions/Demonstration

47
Lunch 1130 130