Question 3

In your analysis, you noticed that both variability and utilization had an impact on throughput time. You decide to continue your performance analysis by examining how variability alone affects throughput time for a given machine utilization level (i.e. 90%). Click on the tab labeled Question 3. For a given column, the stated coefficient of variation in that column is used to determine the total processing time (including setup) variance. The formulas to determine the Throughput Time have already been entered.

3a. (10 points) Plot the Throughput Time on a line graph (created using the scatter chart in Excel) that has Variability (as measured by coefficient of variation) on the horizontal axis and Throughput Time on the vertical axis.

>

3b. (4 points) Describe the relationship shown in the chart and explain in common everyday language why the relationship occurs.

Question 3 Spreadsheet 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) Arrival rate (batches/week) Capacity (batches/week) Capacity (parts/week) Throughput Rate (batches/week) Throughput Rate (parts/week) Queue Time (minutes) Throughput Time (minutes) Variance for Total Process Time (minutes/batch) WIP in Queue (batches) WIP in Queue (parts) Total WIP (batches) Total WIP (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 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. 700. 800. 901.00 4,800.00 4,800.00 4,800.00 4,800.00 0.90 0.90 0.90 0.90 3.00 3.00 3.00 3.00 400.00 400.00 400.00 400.00 35.00 35.00 35.00 35.00 1,235.00 1,235.00 1,235.00 1,235.00 1,372.22 1,372.22 1,372.22 1,372.22 3.50 3.50 3.50 3.50 3.89 3.89 3.89 3.89 1,554.66 1,554.66 1,554.66 1,554.66 3.50 3.50 3.50 1,399.19 1,399.19 1,399.19 1,399.19 8,280.7 9,114.3 10,059.1 11,115.0 9,515.7 10,349.3 11,294.1 12,350.0 0.032 0.042 0.054 0.066 6.03 6.64 7.33 8.10 2,413.80 2,656.80 2.932.20 3,240.00 6.93 7.54 8.23 9.00 2,773.80 3,016.80 3,292.20 3,600.00 3.50 3.50 1,399.19 6,057.7 7,292.7 0.006 4.41 1,765.80 5.31 2,125.80 1.04 Question 3 Spreadsheet 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) Arrival rate (batches/week) Capacity (batches/week) Capacity (parts/week) Throughput Rate (batches/week) Throughput Rate (parts/week) Queue Time (minutes) Throughput Time (minutes) Variance for Total Process Time (minutes/batch) WIP in Queue (batches) WIP in Queue (parts) Total WIP (batches) Total WIP (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 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. 700. 800. 901.00 4,800.00 4,800.00 4,800.00 4,800.00 0.90 0.90 0.90 0.90 3.00 3.00 3.00 3.00 400.00 400.00 400.00 400.00 35.00 35.00 35.00 35.00 1,235.00 1,235.00 1,235.00 1,235.00 1,372.22 1,372.22 1,372.22 1,372.22 3.50 3.50 3.50 3.50 3.89 3.89 3.89 3.89 1,554.66 1,554.66 1,554.66 1,554.66 3.50 3.50 3.50 1,399.19 1,399.19 1,399.19 1,399.19 8,280.7 9,114.3 10,059.1 11,115.0 9,515.7 10,349.3 11,294.1 12,350.0 0.032 0.042 0.054 0.066 6.03 6.64 7.33 8.10 2,413.80 2,656.80 2.932.20 3,240.00 6.93 7.54 8.23 9.00 2,773.80 3,016.80 3,292.20 3,600.00 3.50 3.50 1,399.19 6,057.7 7,292.7 0.006 4.41 1,765.80 5.31 2,125.80 1.04