Consider M/U/1 queue spreadsheet simulation. Run it for 50 customers and five replications. Calculate the average time in the queue and the average time in the system along with half-width limits. Modify this system to have exponential service times with mean 1.28 minutes, rather than the original uniformservice times, resulting in the M/M/1 queue. Repeat the run and calculate the average time in the queue and the average time in the system along with half-width limits for this case. Compare the results for the two cases.

Newsvendor Problem - 30 Days QE 100 0 120 9 160 INPUT DATA Wholesale price $0.55 Retail price $1.00 Scrap prices $0.03 Demand parameter m=13570 Demand parameters 27.10 60 40 20 124 113 121 Day Demand Sold Scrap | Profit Sold Scrap Profit 1 131 100 0 45.00 120 0 54.00 21 127 100 0 45.00 120 0 54.00 3 90 90 10 35.30 90 30 24.90 4 94 94 6 39.18 94 26 28.78 S 81 81 19 26.57 81 39 16.17 6. 114 100 0 45.00 114 6 48.18 7 124 100 0 45.00 120 0 5400 8 163 100 0 45.00 120 0 54.00 9 174 100 0 45.00 120 0 54.00 10 152 100 0 45.00 120 0 54.00 11 151 100 0 45,00 120 0 54.00 12 125 100 0 45.00 120 0 54.00 13 153 100 0 45.00 120 0 5400 14 117 100 0 45.00 117 3 51.09 15 137 100 0 45.00 120 0 54.00 16 124 100 0 45,00 120 0 54.00 17 113 100 0 45,00 113 7 4721 18 121 100 0 45.00 120 0 54.00 19 200 100 0 45.00 120 0 5400 20 147 100 0 45.00 120 0 54.00 211 100 0 45.00 120 0 54.00 22 100 0 45.00 120 0 54.00 23 100 0 45.00 120 0 54.00 24 107 100 0.45.00 107 13 41.30 25 100 0 45.00 120 0 54.00 20 113 100 0 45.00 113 7 47.21 135 100 0 45.00 120 0 54.00 28 111 100 0 45.00 111 94527 20 158 100 0 45.00 120 0 54.00 30 98 98 2 43.06 98 22 32 66 EProf Dayl 43,80E(Profit Day) 48.76 144 3.74 Prob Loss) 0.00 ProbiLoss) 0.00 Bin Tops Cum, Frog Cum. Frog 40 0 0 0 -20 0 0 0 0 0 0 0 0 0 20 0 0 1 1 401 D 8 a 10 Q 140 180 Sold Scrap Profit Sold Scrap Profit Sold Scrap Profit 131 9 54 27 131 29 43.87 131 49 33 47 127 13 50.39 127 33 39.99 127 53 29.59 90 50 14.50 90 70 4.10 90 90 -630 94 46 18.38 94 66 798 94 86 2.42 81 59 5.77 81 79 4.63 81 99 -15.03 114 26 37.78 114 46 27.38 114 66 16.98 124 16 47 48 124 36 37.00 124 56 26.68 140 0 63.00 160 0 72.00 163 17 64,51 140 0 63.00 160 0 72.00 174 6 75.18 140 0 63.00 152 8 64.24 152 28 53.84 140 0 63.00 151 9 63.27 151 29 52.87 125 15 48.45 125 35 38.05 125 55 27.65 140 0 6300 153 7 65.21 153 27 54.81 117 23 40.69 117 43 30.29 117 63 19.89 137 3 60.09 137 23 49.69 137 43 39 29 124 16 47 48 36 37.08 124 56 26.68 113 27 36.81 47 26.41 113 67 16.01 121 19 44.57 39 34.17 121 59 23.77 140 0 63.00 160 0 72.00 180 0 81.00 140 0 83.00 13 59.39 33 48.99 140 0 63.00 17 55.51 37 45.11 130 10 53.30 130 30 42.90 130 50 32 50 127 13 50.39 33 39.99 1271 53 29.50 107 33 30.90 107 53 20.50 107 73 10.10 140 0 6300 76521 27 54.81 113 2736.01 113 47 26.41 67 16.01 135 5 58.15 25 47.75 45 3735 111 29 34 87 111 49 24.47 111 69 14.07 140 0 63.00 270.00 158 22 59.66 98 42 22 26 98 62 11.56 98 82 E(Prof/Day 47.45 E{Profit Day) 4148 E(Prot/Day 32.27 6.16 8.05 8.83 Prob Losa) 0.00 Prob{Loss) 0.03 Prob Loss) 0.10 Cum Freq Cum Frog Cum Free 0 0 0 0 0 0 0 0 O 0 0 0 0 1 1 3 3 3 4 3 10 7 16 12 20 10 143 143 167 140 127 127 153 153 113 135 135 156 -- E - LILL Newsvendor Problem - 30 Days QE 100 0 120 9 160 INPUT DATA Wholesale price $0.55 Retail price $1.00 Scrap prices $0.03 Demand parameter m=13570 Demand parameters 27.10 60 40 20 124 113 121 Day Demand Sold Scrap | Profit Sold Scrap Profit 1 131 100 0 45.00 120 0 54.00 21 127 100 0 45.00 120 0 54.00 3 90 90 10 35.30 90 30 24.90 4 94 94 6 39.18 94 26 28.78 S 81 81 19 26.57 81 39 16.17 6. 114 100 0 45.00 114 6 48.18 7 124 100 0 45.00 120 0 5400 8 163 100 0 45.00 120 0 54.00 9 174 100 0 45.00 120 0 54.00 10 152 100 0 45.00 120 0 54.00 11 151 100 0 45,00 120 0 54.00 12 125 100 0 45.00 120 0 54.00 13 153 100 0 45.00 120 0 5400 14 117 100 0 45.00 117 3 51.09 15 137 100 0 45.00 120 0 54.00 16 124 100 0 45,00 120 0 54.00 17 113 100 0 45,00 113 7 4721 18 121 100 0 45.00 120 0 54.00 19 200 100 0 45.00 120 0 5400 20 147 100 0 45.00 120 0 54.00 211 100 0 45.00 120 0 54.00 22 100 0 45.00 120 0 54.00 23 100 0 45.00 120 0 54.00 24 107 100 0.45.00 107 13 41.30 25 100 0 45.00 120 0 54.00 20 113 100 0 45.00 113 7 47.21 135 100 0 45.00 120 0 54.00 28 111 100 0 45.00 111 94527 20 158 100 0 45.00 120 0 54.00 30 98 98 2 43.06 98 22 32 66 EProf Dayl 43,80E(Profit Day) 48.76 144 3.74 Prob Loss) 0.00 ProbiLoss) 0.00 Bin Tops Cum, Frog Cum. Frog 40 0 0 0 -20 0 0 0 0 0 0 0 0 0 20 0 0 1 1 401 D 8 a 10 Q 140 180 Sold Scrap Profit Sold Scrap Profit Sold Scrap Profit 131 9 54 27 131 29 43.87 131 49 33 47 127 13 50.39 127 33 39.99 127 53 29.59 90 50 14.50 90 70 4.10 90 90 -630 94 46 18.38 94 66 798 94 86 2.42 81 59 5.77 81 79 4.63 81 99 -15.03 114 26 37.78 114 46 27.38 114 66 16.98 124 16 47 48 124 36 37.00 124 56 26.68 140 0 63.00 160 0 72.00 163 17 64,51 140 0 63.00 160 0 72.00 174 6 75.18 140 0 63.00 152 8 64.24 152 28 53.84 140 0 63.00 151 9 63.27 151 29 52.87 125 15 48.45 125 35 38.05 125 55 27.65 140 0 6300 153 7 65.21 153 27 54.81 117 23 40.69 117 43 30.29 117 63 19.89 137 3 60.09 137 23 49.69 137 43 39 29 124 16 47 48 36 37.08 124 56 26.68 113 27 36.81 47 26.41 113 67 16.01 121 19 44.57 39 34.17 121 59 23.77 140 0 63.00 160 0 72.00 180 0 81.00 140 0 83.00 13 59.39 33 48.99 140 0 63.00 17 55.51 37 45.11 130 10 53.30 130 30 42.90 130 50 32 50 127 13 50.39 33 39.99 1271 53 29.50 107 33 30.90 107 53 20.50 107 73 10.10 140 0 6300 76521 27 54.81 113 2736.01 113 47 26.41 67 16.01 135 5 58.15 25 47.75 45 3735 111 29 34 87 111 49 24.47 111 69 14.07 140 0 63.00 270.00 158 22 59.66 98 42 22 26 98 62 11.56 98 82 E(Prof/Day 47.45 E{Profit Day) 4148 E(Prot/Day 32.27 6.16 8.05 8.83 Prob Losa) 0.00 Prob{Loss) 0.03 Prob Loss) 0.10 Cum Freq Cum Frog Cum Free 0 0 0 0 0 0 0 0 O 0 0 0 0 1 1 3 3 3 4 3 10 7 16 12 20 10 143 143 167 140 127 127 153 153 113 135 135 156 -- E - LILL