Data Collection:
The data that has been collected consists of 13 elements, but the data set has been modified to include only the 6 that are pertinent to our investigation:
1. Form Type (only care about forms that are the direct responsibility of OE
2. Duration (calendar days … including weekend days)
3. Category/Difficulty (Basic, Moderate, Complex)
4. Number of Department Engineers
5. Number of Department Designers
6th variable not collected but manually calculated based on date and duration data:
6. Number of Forms (total number of forms already in dept at time new form was received)
The data set is real data collected over the last 2+ years
Has been cleansed of faulted observations created by reopening an already closed observation … the database system cannot handle when a form is reopened and then saved after it has been closed (i.e. the open date is later than closed date)
Consists of the following general “statistics”:
• 997 Total observations (taken from approximately 6000 total recorded observations)
• Observation dates ranging from 07/23/2002 to 11/04/2004
• 622 ER forms, 339 RFQ forms and 36 RFD forms
• 754 Base Category, 214 Moderate Category and 29 Complex Category
• Form durations ranging from 3 minutes up to 107 days