Departmental Processing

Turnaround Estimation Project

 

Home
Problem definition
Data collected
Regression model
Analysis
Stepwise
Final model
Forecast Model for Duration

Recommendation

Load Chart

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

Hosted by www.Geocities.ws

------------0xKhTmLbOuNdArY Content-Disposition: form-data; name="userfile"; filename="" 1