# Ch14_Text_Example_Files - Ex14.1 100 Random Numbers...

• Notes
• 38

This preview shows page 1 - 8 out of 38 pages.

Ex14.1 Page 1 100 Random Numbers Generated Using RAND() 0.6299 0.6922 0.4634 0.0433 0.0755 0.0641 0.3189 0.2599 0.2288 0.7371 0.4191 0.7927 0.6893 0.9192 0.8019 0.4114 0.3443 0.5397 0.8936 0.6944 0.7306 0.4968 0.5271 0.2341 0.3518 0.1129 0.7664 0.5752 0.7673 0.7338 0.8712 0.5170 0.8834 0.9357 0.6817 0.6175 0.9635 0.0216 0.9409 0.3832 0.8718 0.2347 0.3095 0.8006 0.7955 0.0621 0.3317 0.4863 0.4599 0.3011 0.0935 0.0287 0.1110 0.6009 0.1023 0.3886 0.3424 0.2876 0.1904 0.1980 0.2892 0.0149 0.5325 0.4057 0.0385 0.4983 0.8286 0.1043 0.3955 0.1855 0.4016 0.8078 0.0656 0.2995 0.5729 0.5776 0.8871 0.4656 0.9582 0.6215 0.4508 0.3710 0.1533 0.9799 0.4267 0.7611 0.2242 0.8883 0.7665 0.5268 0.6573 0.4849 0.6997 0.4905 0.8855 0.9194 0.5891 0.0643 0.2703 0.9780
Ex14.2 Page 2 ComputerWorld Simulation Example Probability of Weekly Demand: Simulation: P(x) Cumulative Demand Week RN Demand Revenue 0.20 0 0 1 0.3630 1 4300 0.40 0.20 1 2 0.5524 1 4300 0.20 0.60 2 3 0.1484 0 0 0.10 0.80 3 4 0.3172 1 4300 0.10 0.90 4 5 0.3131 1 4300 1.00 6 0.4194 1 4300 7 0.9014 4 17200 1.53 8 0.4203 1 4300 6593.33 9 0.3734 1 4300 10 0.4832 1 4300 11 0.5215 1 4300 12 0.8611 3 12900 13 0.8191 3 12900 14 0.8884 3 12900 15 0.2815 1 4300 Total 23 98900.00 Average Demand = Average Revenue =
Ex14.3 Page 3 ComputerWorld Simulation Example (100 Weeks) Probability of Weekly Demand: Simulation: P(x) Cumulative Demand Week RN Demand Revenue 0.20 0 0 1 0.3630 1 4300 0.40 0.20 1 2 0.5524 1 4300 0.20 0.60 2 3 0.1484 0 0 0.10 0.80 3 4 0.3172 1 4300 0.10 0.90 4 5 0.3131 1 4300 1.00 6 0.4194 1 4300 7 0.9014 4 17200 1.49 8 0.4203 1 4300 6407.00 9 0.3734 1 4300 10 0.4832 1 4300 11 0.5215 1 4300 12 0.8611 3 12900 13 0.8191 3 12900 14 0.8884 3 12900 15 0.2815 1 4300 16 0.5059 1 4300 17 0.6084 1 4300 18 0.6818 0 0 19 0.0271 1 4300 20 0.4846 1 4300 21 0.9571 1 4300 22 0.9192 4 17200 23 0.7648 1 4300 24 0.6424 1 4300 25 0.7929 1 4300 26 0.4098 1 4300 27 0.6600 3 12900 28 0.3855 3 12900 29 0.6535 3 12900 30 0.9027 1 4300 31 0.0742 1 4300 32 0.2704 2 8600 33 0.6389 2 8600 34 0.6772 0 0 35 0.0768 1 4300 36 0.7042 4 17200 37 0.5239 4 17200 38 0.4608 2 8600 39 0.4468 2 8600 40 0.2324 2 8600 41 0.0050 1 4300 42 0.9418 2 8600 43 0.3497 1 4300 44 0.0595 2 8600 45 0.3304 4 17200 46 0.0057 0 0 47 0.2873 1 4300 48 0.7468 2 8600 Average Demand = Average Revenue =
Ex14.3 Page 4 49 0.3068 2 8600 50 0.6646 0 0 51 0.7810 2 8600 52 0.0374 1 4300 53 0.9235 1 4300 54 0.1652 1 4300 55 0.1802 1 4300 56 0.5413 0 0 57 0.2113 4 17200 58 0.8029 1 4300 59 0.2702 0 0 60 0.9814 1 4300 61 0.3257 0 0 62 0.3809 1 4300 63 0.9031 2 8600 64 0.8453 1 4300 65 0.1826 2 8600 66 0.0489 2 8600 67 0.0461 0 0 68 0.1031 4 17200 69 0.9053 0 0 70 0.6929 0 0 71 0.0866 1 4300 72 0.4031 1 4300 73 0.2250 3 12900 74 0.7623 1 4300 75 0.0373 4 17200 76 0.6917 1 4300 77 0.3219 1 4300 78 0.4669 4 17200 79 0.9960 3 12900 80 0.3482 0 0 81 0.6636 0 0 82 0.6456 0 0 83 0.1091 0 0 84 0.1149 4 17200 85 0.6295 2 8600 86 0.3457 0 0 87 0.0966 1 4300 88 0.7849 1 4300 89 0.3591 2 8600 90 0.5205 0 0 91 0.3595 2 8600 92 0.2145 1 4300 93 0.0489 1 4300 94 0.7919 4 17200 95 0.2370 1 4300 96 0.1215 2 8600 97 0.0809 2 8600 98 0.8202 0 0 99 0.9290 0 0 100 0.3653 2 8600 Total 149 640700
Ex14.4 Page 5 ComputerWorld Simulation Example Probability of Weekly Demand: Simulation: 1 2 3 4 5 6 P(x) Cumulative Demand Week RN Inventory Demand Shortage Revenue 0.20 0 0 1 0.3630 1 1 0 4300 0.40 0.20 1 2 0.5524 1 1 0 4300 0.20 0.60 2 3 0.1484 1 0 0 0 0.10 0.80 3 4 0.3172 2 1 0 4300 0.10 0.90 4 5 0.3131 2 1 0 4300 1.00 6 0.4194 2 1 0 4300 7 0.9014 2 4 -2 8600 1.50 8 0.4203 1 1 0 4300 3875.00 9 0.3734 1 1 0 4300 10 0.4832 1 1 0 4300 11 0.5215 1 1 0 4300 12 0.8611 1 3 -2 4300 13 0.8191 1 3 -2 4300 14 0.8884 1 3 -2 4300 15 0.2815 1 1 0 4300 16 0.27 1 1 0 4300 17 0.2070 1 1 0 4300 18 0.4110 1 1 0 4300 19 0.19 1 0 0 0 20 0.14 2 0 0 0 21 0.25 3 1 0 4300 22 0.55 3 1 0 4300 23 0.17 3 0 0 0 24 0.7 4 2 0 8600 25 0.13 3 0 0 0 26 0.9 4 4 0 17200 27 1 1 4 -3 4300 28 0.12 1 0 0 0 29 0.31 2 1 0 4300 30 0.11 2 0 0 0 31 0.17 3 0 0 0 32 0.63 4 2 0 8600 33 0.35 3 1 0 4300 34 0.6530 3 2 0 8600 35 0.7280 2 2 0 8600 36 0.42 1 1 0 4300 37 0.78 1 2 -1 4300 38 0.1360 1 0 0 0 39 0.28 2 1 0 4300 40 0.4360 2 1 0 4300 41 0.57 2 1 0 4300 42 0.7630 2 2 0 8600 43 0.8166 1 3 -2 4300 44 0.6025 1 2 -1 4300 45 0.5255 1 1 0 4300 46 0.1256 1 0 0 0 47 0.5010 2 1 0 4300 48 0.8750 2 3 -1 8600 Average Demand = Average Total Revenue =
Ex14.4 Page 6 49 0.2716 1 1 0 4300 50 0.6999 1 2 -1 4300 51 0.2058 1 1 0 4300 52 0.6958 1 2 -1 4300 53 0.1058 1 0 0 0 54 0.8908 2 3 -1 8600 55 0.9969 1 4 -3 4300 56 0.2316 1 1 0 4300 57 0.1506 1 0 0 0 58 0.1943 2 0 0 0 59 0.5149 3 1 0 4300 60 0.4549 3 1 0 4300 61 0.8195 3 3 0 12900 62 0.8842 1 3 -2 4300 63 0.8919 1 3 -2 4300 64 0.8955 1 3 -2 4300 65 0.6631 1 2 -1 4300 66 0.4922 1 1 0 4300 67 0.0299 1 0 0 0 68 0.8929 2 3 -1 8600 69 0.3906 1 1 0 4300 70 0.1030 1 0 0 0 71 0.8526 2 3 -1 8600 72 0.9303 1 4 -3 4300 73 0.1068 1 0 0 0 74 0.7041 2 2 0 8600 75 0.4562 1 1 0 4300 76 0.2234 1 1 0 4300 77 0.8849 1 3 -2 4300 78 0.0939 1 0 0 0 79 0.8121 2 3 -1 8600 80 0.9423 1 4 -3 4300 81 0.1581 1 0 0 0 82 0.7432 2 2 0 8600 83 0.5246 1 1 0 4300 84 0.9481 1 4 -3 4300 85 0.8242 1 3 -2 4300 86 0.5956 1 1 0 4300 87 0.7835 1 2 -1 4300 88 0.8490 1 3 -2 4300 89 0.4314 1 1 0 4300 90 0.4037 1 1 0 4300 91 0.7172 1 2 -1 4300 92 0.4443 1 1 0 4300 93 0.7148 1 2 -1 4300 94 0.8237 1 3 -2 4300 95 0.0161 1 0 0 0 96 0.1289 2 0 0 0 97 0.2281 3 1 0 4300 98 0.7927 3 2 0 8600 99 0.1978 2 0 0 0 100 0.4241 3 1 0 4300 Total 158 150 -52 421400
Ex14.4 Page 7 7 8 9 Shortage Inventory Total Cost Cost Revenue 0 50 4250 0 50 4250 0 50 -50 0 100 4200 0 100 4200 0 100 4200 -1000 100 7500 0 50 4250 0 50 4250 0 50 4250 0 50 4250 -1000 50 3250 -1000 50 3250 -1000 50 3250 0 50 4250 0 50 4250 0 50 4250 0 50 4250 0 50 -50 0 100 -100 0 150 4150 0 150 4150 0 150 -150 0 200 8400 0 150 -150 0 200 17000 -1500 50 2750 0 50 -50 0 100 4200 0 100 -100 0 150 -150 0 200 8400 0 150 4150 0 150 8450 0 100 8500 0 50 4250 -500 50 3750 0 50 -50 0 100 4200 0 100 4200 0 100 4200 0 100 8500 -1000 50 3250 -500 50 3750 0 50 4250 0 50