The 2006 EPICS User Conference

1
The 2006 EPICS User Conference

• Stratosphere Hotel and Resort
• Las Vegas, Nevada
• April 30 May 3

2
Review of the Advanced Production Screen
What Is It?
3
Ends Limitations of Old Screen

• Allows more than three billet entries
• Allows more than three scrap entries
• Allows more that five downtime entries
• Allows more than one rack entry

4
New Benefits

• Enables rack tracking
• Allows more informative rack tag
• Enables MWO
• On-screen workorder
• On-screen press schedule (press)
• On-screen rack contents (downstream)
• Enables User Fields
• Enables multiple-item posting (downstream)

5
Additional Benefits

• Easier to use than old screen
• More information available on-screen
• None of the new features are required

6
Challenges

• Training. User must learn new screen.
• Update reports using new database tables

7
Advanced Production

• Demonstration

8
Deleting Old Records
9
Archiving and Viewing Archived Data

• Backup database
• View outside of EPICS
• Restore database with another name
• View with Access, Excel, and Crystal
• View within EPICS
• Restore as test database
• Requires a license
• Must apply update scripts

10
Delete Completed Orders screen
11
Consolidate Production Info screen
12
New Reports

• All standard reports have been updated
• Many take advantage of new Crystal XI features
• Dynamic and cascading parameters
• New report update tool
• Check to see if new reports are available

Download from www.foyic.com/Admin/Download_Items/
UserExchange/ReportUtility.zip
13
Sales Revenue and Wt Totals by Customer/Salesman
salesbyyear.rpt

• Sorted by top Customers or Salesmen
• Year summaries or Monthly detail
• Compares current year and the past two years

14
No Racks Posted

• Identifies metal that has been posted but not
  posted to a rack
• NoRack.rpt

15
Press Production

• Designed for use with the Advanced Production
  screen
• Billet, Scrap and Downtime summaries
• PressProduction.rpt

16
Department Production

• Designed for use with the Advanced Production
  screen
• Shows rack posting detail
• DeptProduction.rpt

17
Chemical Comp Cert

• Cert report showing Chemical Composition data
• CertChemComp.rpt

18
AEC Key Indicators Survey

• Completes the survey for you
• AEC Survey.rpt

19
Extrusions Shortage

• Shows only items that, even when completed in the
  extrude dept, will not meet the required quantity
  to ship
• Shortage.rpt

20
Fill from Stock

• Improved Fill-from-Stock report
• Highlights items that may be used but will
  require additional processing
• Fill.rpt

21
Department Schedule

• May be run for any downstream department
• Uses department plan dates
• Based on Metal Available for Production report
• Dept_Sched.rpt

22
Coming Soon

• Items on Hold
• Plant Hold and/or Credit Hold
• Grouped by hold type
• Sorted by Customer, Die or Hold Code
• Weight and Piece Totals
• A flexible department analysis report
• Group by die, part, customer, alloy, temper,
  machine, perhaps others
• Perhaps Week and/or Month subtotals

23
Department Totals
24
SQL Server 2005
25
What's New in SQL Server 2005?

• Improved Enterprise Manageability
• SQL Server Management Studio
• SQL Management Objects
• Database Mirroring
• Failover Clustering
• Read-only Database Snapshots
• Faster Recovery
• Improved Replication

26
SQL Server Management Studio
27
What's New in SQL Server 2005?

• Developer Productivity
• Expanded language support
• Improved development tools
• Extensibility
• Improved data access
• XML and Web services
• Application framework

28
But does it get along with EPICS?

• Yes
• At least 2 EPICS customers are already using SQL
  Server 2005
• EPICS Installation script available from Foy Inc.
• Download the Microsoft SQL Server 2005 Upgrade
  Advisor to check system compatibility

29
What will it cost me?

• Workgroup Edition
• 1 or 2 CPUs, 3GB max RAM
• Limited Replication, but no mirroring
• Backup log shipping supported
• 3,900 per processor or 739 (server 5 users)

30
What will it cost me?

• Standard Edition
• 1 to 4 CPUs, Unlimited RAM
• Database Mirroring and Full Replication
• Two-node Clustering
• Available in 32 and 64-bit editions
• 6,000 per processor or 2,799 (server 10 users)

31
What will it cost me?

• Enterprise Edition
• Unlimited Scale and Partitioning
• Advanced database mirroring, complete online and
  parallel operations, and database snapshots
• Advanced analysis (OLAP) and reporting
• Available in 32 and 64-bit editions
• 25,000 per processor or 13,500 (server 25
  users)

32
Real-Time Management Screen

• What is the Real-Time Mgmt screen?
• Excel spreadsheet
• Data automatically refreshes
• At an interval you determine
• Use as a dashboard to monitor plant activity

33
Real-Time Mgmt Screen

• gManagementXLSFile
• Path to the spreadsheet
• gManagementSheetNum
• Sheet number to display
• gManagementRefresh
• Refresh interval in minutes

34
(No Transcript)
35
Advanced Manufacturing Concepts

• Gerry Leonard

36
Scanners/Enhanced Shipping Module
37
Enhanced Shipping Module Features

• Supports wireless barcode scanners
• Group and track orders by truckload
• One click posting
• Use of PocketShip application

38
Maintain Picklist Tab
39
Scan for Orders Tab
40
Assigning Sales Orders to Picklists
41
Picklists in PocketShip
42
Assigned Tickets
43
Scanned Ticket
44
Show Ticket Data
45
Posting Picklists/Tickets
46
PSC Falcon Scanner Demo
47
Intermec 730
48
Traceability Report
49
Traceability Report
50
Traceability Report
51
Traceability Report
52
Billet Calculation
53
Calculate Starting Values

• Piece Wt (based on ActWt)
• Exact Wt Required
• Wt ordered, or
• Pcs ordered Piece Wt
• Top and Bottom Tolerance
• Weight
• Pieces

54
Calculate Practice

• Calculate for each possible billet size
• Each possible shear setting, or
• Each size in billet inventory

55
For Every Possible Billet Length

• Calculate Butt
• DieCopy.Butt (Fixed amount), or
• DieCopy.ButtPct (Percent of billet length)

56
For Every Possible Billet Length

• Calculate number of Multi-billets required
• For heavy shapes, might take 2 or 3 billets
  together to get one piece

57
For Every Possible Billet Length

• Determine Rough-cut length, if required
• As listed in Part table, or
• Based on StrLen in Machine table

58
For Every Possible Billet Length

• Calculate runout length
• If Cutback, calculate all possible multiples and
  pick the one with least scrap
• If longer than StrLen, double drag?
• Reset to StrLen if gAllowButtIncrease is set
• Else calculate number and length of drags

59
For Every Possible Billet Length

• Calculate pieces per runout
• Calculate good weight and recovery

60
Deduct Penalties from Recovery

• 10 points for each inch outside Min/Max billet
  length for DieCopy
• 2 points for each foot outside Min/Max runout for
  DieCopy
• X points for multi-billets (gMultibilletPenalty)
• X points for double drag ( gDoubleDragPenalty)
• ½ point for each inch shorter than best

61
Select best size

• Choose highest recovery after penalties
• Calculate billet count required
• Based on reaching top shipping tolerance
• See Calculating the Number of Billets in Foy
  Forum Knowledge Base

62
New PartDept tableStores costs and production
rates by part number
63
New Dept Specs tab on Part Maintenance Screen
64
PartDept table

• Usage is optional
• You may create 1 record for each department in
  the assigned routing for which you want to enter
  statistics.
• Data fields are copied to SOItemDept when new
  sales orders are posted.
• Changes made to stats for an existing part can be
  copied to all active sales orders using that part.

65
New fields on QBE Items Departments tab
66
Operating SystemsandDatabases Supported
67
Operating Systems Supported

• Windows XP
• Main development and testing platform
• Windows 2000
• MS Mainline ended, Extended through 2010
• Foy At least through 2007
• Windows NT Workstation
• MS No longer supported, even security fixes
• Foy now test major releases, but not for long
• Windows 98, Windows ME
• Foy No longer test on these platforms

68
Databases Supported

• SQL Server 2005
• Foy Fully support
• SQL Server 2000
• MS Mainstream through Dec 2007
• Foy At least through 2008
• SQL Server 7
• MS Mainstream ended, Extended through Dec 2010
• Foy Some new EPICS features will not work
• SQL Server 6.5
• Foy We do not test

69
Databases Supported

• Oracle
• Only 4 or 5 users
• We test on 8i and 10g
• Oracle does not support our scanner software

70
Major Points

• Foy Does Not Support Windows 98 ME
• Foy will soon drop support for NT Workstation
• Foy Does Not Test on SQL Server 7