Question

1 Approved Answer

Posted on Jul 30, 2024

Using excel simulation file loaded to lecture homepage, you have to do two simulations: Monte Carlo and Barbershop. For Monte Carlo, working time is normally

Using excel simulation file loaded to lecture homepage, you have to do two simulations: Monte Carlo and Barbershop.

For Monte Carlo, working time is normally distributed with the mean of 6 and the standard deviation of 2.5.

For Barbershop, the average of exponential distribution inter-arrival time is 10 minute and the average of exponential distribution service time is 9 minute.

image text in transcribed

16 17 18 RND 0.529 0.027 0.124 0.938 0.864 0.118 0.234 0.852 0.817 0.936 0.027 0.858 0.580 0.398 0.734 0.688 0.907 0.346 0.769 0.458 0.000 0.350 0.354 0.173 0.027 0.411 0.184 0.129 0.702 0.235 0.595 0.835 0.233 0.834 0.446 0.992 0.680 0.736 0.344 0.397 Work hour Profit 8.145 277.687 4.139 136.314 5.691 187.280 11.081 401.659 10.197 362.502 5.634 185.314 6.551 217.586 10.093 358.023 9.811345.921 11.041 399.853 4.154 136.799 10.144 360.203 8.406 288.011 7.482 252.058 9.248 322.235 8.979 311.156 10.648 382.268 7.209 241.790 9.472 331.565 7.787 263.731 0.888 45.217 7.232 242.638 7.251 243.364 6.118 202.153 4 145 136.509 7.550 254.656 6.202 205.123 5.742 189.032 9.062 314.529 6.554 217.711 8.479 290.893 9.950 351.852 6.540 217.183 9.941 351.460 7.727 261.432 12.829 483.645 8.935 309.333 9.261 322.762 7.199 241.420 7480 251.984 36 37 38 39 No 1 interarrival interarrival arrival RND time time 0 .3980 7.614 7.614 0.4128 7.985 15.599 3 0.7338 19.851 35.449 4 0.2679 4 .677 40.126 0.6494 15.722 55.849 0.2142 3.616 59.465 0.0147 0.222 59.686 0.5923 13.459 73.145 0.7887 23.314 96.460 0.8997 34.492 130.952 0.9902 69.416 200.368 0.4436 8.793 209.161 0.5312 11.365 220.526 0.1280 2.055 222.581 0.8045 24.482 247.062 0.9477 44.268 291.330 0.4863 9.992 301.322 0.8461 28.073 329.395 19 0.0085 0.128 329.523 20 0.7558 2 1.149 350.673 service RND 0.8733 0.9086 0.1591 0.9572 0.9781 0.4447 0.3567 0.2772 0.4345 0.8651 0.9550 0.0130 0.3698 0.0448 0.7936 0.6819 0.5405 0.7782 0.5155 0.5503 service time 14.367 14.543 10.795 14.786 14.890 12.223 1 1.784 11.386 12.172 14.326 14.775 10.065 11.849 10.224 1 3.968 13.409 12.703 13.891 12.578 12.752 257.485 departure Wa Ws time 21.980 0.000 14.367 36.523 6.382 20.925 47.319 1.074 11.869 62.105 7.192 21.978 76.995 6.256 21.146 89.219 17.531 29.754 101.002 29.532 41.316 112.388 27.857 39.243 124.560 15.928 28.101 145.277 0.000 14.326 215.143 0.000 14.775 225.208 5.982 16.047 237.057 4.682 16.531 247.281 14.476 24.700 261.249 0.218 14.186 304.739 (0.000) 13.409 317.442 3.417 16.120 343.286 (0.000) 13.891 355.864 13.763 26.340 368.615 5.191 17.943 159.481 416.966 Sum utilization a Wa 0.69852 0.432648 7.974042 20.8483 Monte Carlo Discrete event 16 17 18 RND 0.529 0.027 0.124 0.938 0.864 0.118 0.234 0.852 0.817 0.936 0.027 0.858 0.580 0.398 0.734 0.688 0.907 0.346 0.769 0.458 0.000 0.350 0.354 0.173 0.027 0.411 0.184 0.129 0.702 0.235 0.595 0.835 0.233 0.834 0.446 0.992 0.680 0.736 0.344 0.397 Work hour Profit 8.145 277.687 4.139 136.314 5.691 187.280 11.081 401.659 10.197 362.502 5.634 185.314 6.551 217.586 10.093 358.023 9.811345.921 11.041 399.853 4.154 136.799 10.144 360.203 8.406 288.011 7.482 252.058 9.248 322.235 8.979 311.156 10.648 382.268 7.209 241.790 9.472 331.565 7.787 263.731 0.888 45.217 7.232 242.638 7.251 243.364 6.118 202.153 4 145 136.509 7.550 254.656 6.202 205.123 5.742 189.032 9.062 314.529 6.554 217.711 8.479 290.893 9.950 351.852 6.540 217.183 9.941 351.460 7.727 261.432 12.829 483.645 8.935 309.333 9.261 322.762 7.199 241.420 7480 251.984 36 37 38 39 No 1 interarrival interarrival arrival RND time time 0 .3980 7.614 7.614 0.4128 7.985 15.599 3 0.7338 19.851 35.449 4 0.2679 4 .677 40.126 0.6494 15.722 55.849 0.2142 3.616 59.465 0.0147 0.222 59.686 0.5923 13.459 73.145 0.7887 23.314 96.460 0.8997 34.492 130.952 0.9902 69.416 200.368 0.4436 8.793 209.161 0.5312 11.365 220.526 0.1280 2.055 222.581 0.8045 24.482 247.062 0.9477 44.268 291.330 0.4863 9.992 301.322 0.8461 28.073 329.395 19 0.0085 0.128 329.523 20 0.7558 2 1.149 350.673 service RND 0.8733 0.9086 0.1591 0.9572 0.9781 0.4447 0.3567 0.2772 0.4345 0.8651 0.9550 0.0130 0.3698 0.0448 0.7936 0.6819 0.5405 0.7782 0.5155 0.5503 service time 14.367 14.543 10.795 14.786 14.890 12.223 1 1.784 11.386 12.172 14.326 14.775 10.065 11.849 10.224 1 3.968 13.409 12.703 13.891 12.578 12.752 257.485 departure Wa Ws time 21.980 0.000 14.367 36.523 6.382 20.925 47.319 1.074 11.869 62.105 7.192 21.978 76.995 6.256 21.146 89.219 17.531 29.754 101.002 29.532 41.316 112.388 27.857 39.243 124.560 15.928 28.101 145.277 0.000 14.326 215.143 0.000 14.775 225.208 5.982 16.047 237.057 4.682 16.531 247.281 14.476 24.700 261.249 0.218 14.186 304.739 (0.000) 13.409 317.442 3.417 16.120 343.286 (0.000) 13.891 355.864 13.763 26.340 368.615 5.191 17.943 159.481 416.966 Sum utilization a Wa 0.69852 0.432648 7.974042 20.8483 Monte Carlo Discrete event