Question 2

You also wish to see how Throughput Time would change if the total process time variability is half of that in Question 1. Click on the tab labeled Questions 2. In this spreadsheet, a coefficient of variation of 0.5 is used to determine the total processing time (including setup) variance. The formulas to determine the Throughput Time have already been entered.

2a. (10 points) Plot the Throughput Time as a line graph (created using the scatter chart in Excel) for both CV = 1 and CV = .5. Put Utilization on the horizontal axis and Throughput Time on the vertical axis. Note: You will have one line for CV = 1 and another line for CV = .5.

>

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

Question 2 Spreadsheet CV 0.5 4,800.00 0.65 3.00 400.00 35.00 1,235.00 1,900.00 2.53 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) 4,800.00 0.60 3.00 400.00 35.00 1,235.00 2,058.33 2.33 3.89 1,554.66 2.33 932.79 1,157.81 2,392.81 0.017 0.56 225.00 1.16 465.00 3.89 1,554.66 2.53 1,010.53 1,433.48 2,668.48 0.017 0.75 301.79 1.75 701.79 4,800.00 0.70 3.00 400.00 35.00 1,235.00 1,764.29 2.72 3.89 1,554.66 2.72 1,088.26 1,801.04 3,036.04 0.017 1.02 408.33 2.02 808.33 4,800.00 0.75 3.00 400.00 35.00 1,235.00 1,646.67 2.91 3.89 1,554.66 2.91 1,165.99 2,315.63 3,550.63 0.017 1.41 562.50 2.41 962.50 4,800.00 0.80 3.00 400.00 35.00 1,235.00 1,543.75 3.11 3.89 1,554.66 3.11 1,243.72 3,087.50 4,322.50 0.017 2.00 800.00 3.00 1,200.00 4,800.00 0.85 3.00 400.00 35.00 1,235.00 1,452.94 3.30 3.89 1,554.66 3.30 1,321.46 4,373.96 5,608.96 0.017 3.01 1,204.17 4.01 1,604.17 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.88 8.181.88 0.017 5.06 2,025.00 6.06 2,425.00 4,800.00 0.95 3.00 400.00 35.00 1,235.00 1,300.00 3.69 3.89 1,554.66 3.69 1,476.92 14,665.63 15,900.63 0.017 11.28 4,512.50 12.28 4.912.50 Question 2 Spreadsheet CV 0.5 4,800.00 0.65 3.00 400.00 35.00 1,235.00 1,900.00 2.53 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) 4,800.00 0.60 3.00 400.00 35.00 1,235.00 2,058.33 2.33 3.89 1,554.66 2.33 932.79 1,157.81 2,392.81 0.017 0.56 225.00 1.16 465.00 3.89 1,554.66 2.53 1,010.53 1,433.48 2,668.48 0.017 0.75 301.79 1.75 701.79 4,800.00 0.70 3.00 400.00 35.00 1,235.00 1,764.29 2.72 3.89 1,554.66 2.72 1,088.26 1,801.04 3,036.04 0.017 1.02 408.33 2.02 808.33 4,800.00 0.75 3.00 400.00 35.00 1,235.00 1,646.67 2.91 3.89 1,554.66 2.91 1,165.99 2,315.63 3,550.63 0.017 1.41 562.50 2.41 962.50 4,800.00 0.80 3.00 400.00 35.00 1,235.00 1,543.75 3.11 3.89 1,554.66 3.11 1,243.72 3,087.50 4,322.50 0.017 2.00 800.00 3.00 1,200.00 4,800.00 0.85 3.00 400.00 35.00 1,235.00 1,452.94 3.30 3.89 1,554.66 3.30 1,321.46 4,373.96 5,608.96 0.017 3.01 1,204.17 4.01 1,604.17 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.88 8.181.88 0.017 5.06 2,025.00 6.06 2,425.00 4,800.00 0.95 3.00 400.00 35.00 1,235.00 1,300.00 3.69 3.89 1,554.66 3.69 1,476.92 14,665.63 15,900.63 0.017 11.28 4,512.50 12.28 4.912.50