Transcript SPC Proposal - Sunday Business Systems, LLC

Sunday
Business
Systems
SPC Keeper
Features and Benefits
Sunday
Business
Systems
SPC Data Collection




Identify Out of Control / Spec parts
Generate real time SPC charts
Track parameters and SPC limits
Generate simple reports
Data Entry
Enter basic
information
www.SundayBizSys.com
Part Number is the
key parameter
Enter Work Order
/ Job Number,
measurement
step or operation,
and Part Serial#
Sunday Business Systems
Data Entry
Data collection parameters
correspond to the Part Number
Enter the required
attribute data
www.SundayBizSys.com
Sunday Business Systems
SPC Charts
 After each entry, real-time SPC charts pop up
 Review the data and close the chart
 Take action if values are out of control
 Create a Non-Conformance Alert
 Hold the material
 Contact your Supervisor
 Correct data entry errors
 Etc.
www.SundayBizSys.com
Sunday Business Systems
Take Action!
www.SundayBizSys.com
Sunday Business Systems
Sunday
Business
Systems
Software Set-up
Enter Employee information
Enter Parameters
Enter control limits
Enter spec limits
Review and export data
Enter Employee Information
www.SundayBizSys.com
Sunday Business Systems
Part Based Parameter Set-up
Enter
Parameter
name and
Description
Value#
determines the
order displayed
on data entry
form
www.SundayBizSys.com
 if you want a
SPC chart to
show after data
entry
Enter SPC
limits to
validate
data
Sunday Business Systems
Data collection parameters
 Either text or numbers may be collected
 Text up to 50 characters long
 Use “Display Chart”
  to activate SPC validation
 Un-check to accept text values
 Value Number
 Determines which values will have which labels
 Avoid changing the sort order after data collection has started
www.SundayBizSys.com
Sunday Business Systems
Objectives
 To collect meaningful process data
 To immediately identify OOS / OOC parts
 To review measurement trends
 Detect and respond to trends within the control limits
 Create an archive
 Data is available to be extracted and analyzed
 More sophisticated SPC software may be used
www.SundayBizSys.com
Sunday Business Systems
Export Data
Select a part number and
date range
Select to send
the data to
Excel, Word,
etc.
Data may be copied and
pasted directly into Excel
www.SundayBizSys.com
Sunday Business Systems
Data Transfer / Connectivity
The data resides in a Microsoft Access Database
Other Statistical Software tools can connect
 Directly using an ODBC connection
 Indirectly
 Data exported saved in Excel files
 Copy and paste data directly from SPC keeper
www.SundayBizSys.com
Sunday Business Systems
About SBS
 Sunday Business Systems is engaged in software sales and consulting services.
 Applies Lean Manufacturing principles to Quality Management Systems
 Sells software solutions to small businesses which help them implement
ISO9001:2000 compliant systems for
 Corrective and Preventive Actions
 Employee Training
 Control of calibrated equipment
 Customer Satisfaction Surveys
 Communication / Continual improvement
 Shop Floor Control
 Will customize the software for a particular Customer
 Offers full Training services customized to individual needs
www.SundayBizSys.com
Sunday Business Systems
About SBS – Consulting Services
Custom Database Solutions
 solutions for shop floor control/order processing and bar code solutions.
 Database programming
 MS Access
 SQL
 Delphi
Contact SBS for additional details
 [email protected]
www.SundayBizSys.com
Sunday Business Systems
Sunday
Business
Systems
Fueling Small Business Efficiency
Visit www.SundayBizSys.com for:
•Additional information
•Free product demos
•Pricing
•Links to purchase software
© 2006 Sunday Business Systems. All rights reserved. This presentation is for informational purposes only. Sunday
Business Systems MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY. Microsoft is a
registered trademark of Microsoft Corporation in the United States and/or other countries.