Question 2
- You decide to continue your performance analysis by examining how variability alone affects the station throughput time for a given machine utilization level.
Stated coefficient of variation in that column is used to determine the total processing time (including setup) variance. Plot the station throughput time determined in Q2A on a line graph (created using the insert chart in Excel) that has variability (as measured by coefficient of variation) on the horizontal axis and station throughput time on the vertical axis.
- (8 points) Describe the relationship shown in the chart and explain in common everyday language why the relationship occurs. Provide examples.
Single Machine Variability CV Available time per machine (minutes/week) Required Utilization Processing Time per Part (minutes) Batch Size (parts) Setup Time per Batch (minutes) Total Process Time (minutes/batch) Interarrival Time (minutes/batch) Interarrival rate (batches/week) Capacity (batches/week) Capacity (parts/week) Throughput (batches/week) Throughput (parts/week) Station Queue Time (minutes) Station Throughput Time (minutes) Variance for Total Process Time (minutes/batch) WIP in Queue at Station (batches) WIP in Queue at Station (parts) Total WIP at Station (batches) Total WIP at Station (parts) 0.30 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 6,057.7 7,292.7 0.006 4.41 1,765.80 5.31 2,125.80 0.40 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 6,446.7 7,681.7 0.011 4.70 1,879.20 5.60 2,239.20 0.50 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 6,946.9 8,181.9 0.017 5.06 2,025.00 5.96 2.385.00 0.60 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 7,558.2 8,793.2 0.024 5.51 2,203.20 6.41 2,563.20 0.70 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 8,280.7 9,515.7 0.032 6.03 2,413.80 6.93 2,773.80 0.80| 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 9,114.3 10,349.3 0.042 6.64 2,656.80 7.54 3,016.80 0.90 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 1.00 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 11,115.0 12,350.0 0.066 8.10 3,240.00 9.00 3,600.00 3.50 1,399.19 10,059.1 11,294.1 0.054 7.33 2,932.20 8.23 3,292.20 Single Machine Variability CV Available time per machine (minutes/week) Required Utilization Processing Time per Part (minutes) Batch Size (parts) Setup Time per Batch (minutes) Total Process Time (minutes/batch) Interarrival Time (minutes/batch) Interarrival rate (batches/week) Capacity (batches/week) Capacity (parts/week) Throughput (batches/week) Throughput (parts/week) Station Queue Time (minutes) Station Throughput Time (minutes) Variance for Total Process Time (minutes/batch) WIP in Queue at Station (batches) WIP in Queue at Station (parts) Total WIP at Station (batches) Total WIP at Station (parts) 0.30 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 6,057.7 7,292.7 0.006 4.41 1,765.80 5.31 2,125.80 0.40 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 6,446.7 7,681.7 0.011 4.70 1,879.20 5.60 2,239.20 0.50 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 6,946.9 8,181.9 0.017 5.06 2,025.00 5.96 2.385.00 0.60 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 7,558.2 8,793.2 0.024 5.51 2,203.20 6.41 2,563.20 0.70 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 8,280.7 9,515.7 0.032 6.03 2,413.80 6.93 2,773.80 0.80| 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 9,114.3 10,349.3 0.042 6.64 2,656.80 7.54 3,016.80 0.90 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 1.00 4,800.00 0.90 3.00 400.00 35.00 1,235.00 1,372.22 3.50 3.89 1,554.66 3.50 1,399.19 11,115.0 12,350.0 0.066 8.10 3,240.00 9.00 3,600.00 3.50 1,399.19 10,059.1 11,294.1 0.054 7.33 2,932.20 8.23 3,292.20
