Walton Book Store-basic-Shell-simplified.xls - Simulation of Walton's bookstore Cost data Unit cost Unit price Unit refund \$7.50 \$10.00 \$2.50 Critical

# Walton Book Store-basic-Shell-simplified.xls - Simulation...

This preview shows page 1 - 6 out of 97 pages.

Simulation of Walton's bookstore Cost data Demand -normal distribution Unit cost \$7.50 Mean 175 Unit price \$10.00 Standard Deviation 50 Unit refund \$2.50 Critical ratio Optimal Q for normal demand
Simulation of Walton's bookstore Cost data Demand -normal distribution Unit cost \$7.50 Mean 175 Unit price \$10.00 Standard Deviati 50 Unit refund \$2.50 Decision variable Possible Q Order quantity 200 120 130 Summary measures for simulation below 140 Average profit 150 Stdev of profit 160 Minimum profit 170 Maximum profit 180 Prob(profit<200) 190 Prob(profit<0) 200 210 Simulation Iteration Random # Demand Revenue Cost Refund Profit 1 0.4235 165 \$1,650 \$1,500 \$88 \$238 2 0.1150 115 \$1,150 \$1,500 \$213 -\$138 3 0.9787 276 \$2,000 \$1,500 \$0 \$500 4 0.4116 164 \$1,640 \$1,500 \$90 \$230 5 0.6297 192 \$1,920 \$1,500 \$20 \$440 6 0.7252 205 \$2,000 \$1,500 \$0 \$500 7 0.8735 232 \$2,000 \$1,500 \$0 \$500 8 0.5624 183 \$1,830 \$1,500 \$43 \$373 9 0.9469 256 \$2,000 \$1,500 \$0 \$500 10 0.1170 116 \$1,160 \$1,500 \$210 -\$130 11 0.1734 128 \$1,280 \$1,500 \$180 -\$40 12 0.6145 190 \$1,900 \$1,500 \$25 \$425 13 0.5107 176 \$1,760 \$1,500 \$60 \$320 14 0.1426 122 \$1,220 \$1,500 \$195 -\$85 15 0.3697 158 \$1,580 \$1,500 \$105 \$185 16 0.6896 200 \$2,000 \$1,500 \$0 \$500 17 0.6897 200 \$2,000 \$1,500 \$0 \$500 18 0.3433 155 \$1,550 \$1,500 \$113 \$163 19 0.5293 179 \$1,790 \$1,500 \$53 \$343 20 0.2179 136 \$1,360 \$1,500 \$160 \$20 21 0.4523 169 \$1,690 \$1,500 \$78 \$268 22 0.4872 173 \$1,730 \$1,500 \$68 \$298 23 0.8633 230 \$2,000 \$1,500 \$0 \$500 24 0.2228 137 \$1,370 \$1,500 \$158 \$28 25 0.3260 152 \$1,520 \$1,500 \$120 \$140 26 0.9126 243 \$2,000 \$1,500 \$0 \$500 27 0.5569 182 \$1,820 \$1,500 \$45 \$365 28 0.5975 187 \$1,870 \$1,500 \$33 \$403 29 0.4210 165 \$1,650 \$1,500 \$88 \$238 30 0.4049 163 \$1,630 \$1,500 \$93 \$223 31 0.8000 217 \$2,000 \$1,500 \$0 \$500 32 0.0315 82 \$820 \$1,500 \$295 -\$385 33 0.1744 128 \$1,280 \$1,500 \$180 -\$40
34 0.2099 135 \$1,350 \$1,500 \$163 \$13 35 0.8875 236 \$2,000 \$1,500 \$0 \$500 36 0.5998 188 \$1,880 \$1,500 \$30 \$410 37 0.2823 146 \$1,460 \$1,500 \$135 \$95 38 0.2441 140 \$1,400 \$1,500 \$150 \$50 39 0.1612 126 \$1,260 \$1,500 \$185 -\$55 40 0.9577 261 \$2,000 \$1,500 \$0 \$500 41 0.3821 160 \$1,600 \$1,500 \$100 \$200 42 0.1062 113 \$1,130 \$1,500 \$218 -\$153 43 0.9680 268 \$2,000 \$1,500 \$0 \$500 44 0.0611 98 \$980 \$1,500 \$255 -\$265 45 0.8652 230 \$2,000 \$1,500 \$0 \$500 46 0.9681 268 \$2,000 \$1,500 \$0 \$500 47 0.3944 162 \$1,620 \$1,500 \$95 \$215 48 0.5428 180 \$1,800 \$1,500 \$50 \$350 49 0.7300 206 \$2,000 \$1,500 \$0 \$500 50 0.8832 235 \$2,000 \$1,500 \$0 \$500 51 0.5396 180 \$1,800 \$1,500 \$50 \$350 52 0.0560 96 \$960 \$1,500 \$260 -\$280 53 0.5013 175 \$1,750 \$1,500 \$63 \$313 54 0.6439 193 \$1,930 \$1,500 \$18 \$448 55 0.7259 205 \$2,000 \$1,500 \$0 \$500 56 0.4783 172 \$1,720 \$1,500 \$70 \$290 57 0.5896 186 \$1,860 \$1,500 \$35 \$395 58 0.9895 290 \$2,000 \$1,500 \$0 \$500 59 0.6598 196 \$1,960 \$1,500 \$10 \$470 60 0.3518 156 \$1,560 \$1,500 \$110 \$170 61 0.0804 105 \$1,050 \$1,500 \$238 -\$213 62 0.3712 159 \$1,590 \$1,500 \$103 \$193 63 0.4046 163 \$1,630 \$1,500 \$93 \$223 64 0.2675 144 \$1,440 \$1,500 \$140 \$80 65 0.0477 92 \$920 \$1,500 \$270 -\$310 66 0.9965 310 \$2,000 \$1,500 \$0 \$500 67 0.0967 110 \$1,100 \$1,500 \$225 -\$175 68 0.3599 157 \$1,570 \$1,500 \$108 \$178 69 0.1150 115 \$1,150 \$1,500 \$213 -\$138 70 0.5911 187 \$1,870 \$1,500 \$33 \$403 71 0.7386 207 \$2,000 \$1,500 \$0 \$500 72 0.4519 169 \$1,690 \$1,500 \$78 \$268 73 0.2482 141 \$1,410 \$1,500 \$148 \$58 74 0.8293 223 \$2,000 \$1,500 \$0 \$500 75 0.3480 155 \$1,550 \$1,500 \$113 \$163 76 0.3494 156 \$1,560 \$1,500 \$110 \$170 77 0.9298 249 \$2,000 \$1,500 \$0 \$500 78 0.6114 189 \$1,890 \$1,500 \$28 \$418 79 0.2488 141 \$1,410 \$1,500 \$148 \$58 80 0.7332 206 \$2,000 \$1,500 \$0 \$500 81 0.4257 166 \$1,660 \$1,500 \$85 \$245 82 0.3222 152 \$1,520 \$1,500 \$120 \$140 83 0.3768 159 \$1,590 \$1,500 \$103 \$193 84 0.0605 97 \$970 \$1,500 \$258 -\$273 85 0.0325 83 \$830 \$1,500 \$293 -\$378 86 0.2565 142 \$1,420 \$1,500 \$145 \$65
87 0.5174 177 \$1,770 \$1,500 \$58 \$328 88 0.4222 165 \$1,650 \$1,500 \$88 \$238 89 0.7178 204 \$2,000 \$1,500 \$0 \$500 90 0.2454 141 \$1,410 \$1,500 \$148 \$58 91 0.6675 197 \$1,970 \$1,500 \$8 \$478 92 0.8993 239 \$2,000 \$1,500 \$0 \$500 93 0.8081 219 \$2,000 \$1,500 \$0 \$500 94 0.9447 255 \$2,000 \$1,500 \$0 \$500 95 0.6797 198 \$1,980 \$1,500 \$5 \$485 96 0.0934 109 \$1,090 \$1,500 \$228 -\$183 97 0.8270 222 \$2,000 \$1,500 \$0 \$500 98 0.5397 180 \$1,800 \$1,500 \$50 \$350 99 0.0686 101 \$1,010 \$1,500 \$248 -\$243 100 0.5108 176 \$1,760 \$1,500 \$60 \$320 101 0.7490 209 \$2,000 \$1,500 \$0 \$500 102 0.5885 186 \$1,860 \$1,500 \$35 \$395 103 0.1772 129 \$1,290 \$1,500 \$178 -\$33 104 0.3149 151 \$1,510 \$1,500 \$123 \$133 105 0.1142 115 \$1,150 \$1,500 \$213 -\$138 106 0.3607 157 \$1,570 \$1,500 \$108 \$178 107 0.2969 148 \$1,480 \$1,500 \$130 \$110 108 0.9669 267 \$2,000 \$1,500 \$0 \$500 109 0.6722 197 \$1,970 \$1,500 \$8 \$478 110 0.4554 169 \$1,690 \$1,500 \$78 \$268 111 0.5690 184 \$1,840 \$1,500 \$40 \$380 112 0.0457 91 \$910 \$1,500 \$273 -\$318 113 0.1671 127 \$1,270 \$1,500 \$183 -\$48 114 0.1430 122 \$1,220 \$1,500 \$195 -\$85 115 0.3166 151 \$1,510 \$1,500 \$123 \$133 116 0.1266 118 \$1,180 \$1,500 \$205 -\$115 117 0.8903 236 \$2,000 \$1,500 \$0 \$500 118 0.8935 237 \$2,000 \$1,500 \$0 \$500 119 0.2668 144 \$1,440 \$1,500 \$140 \$80 120 0.9955 305 \$2,000 \$1,500 \$0 \$500 121 0.3083 150 \$1,500 \$1,500 \$125 \$125 122 0.9029 240 \$2,000 \$1,500 \$0 \$500 123 0.5871 186 \$1,860 \$1,500 \$35 \$395 124 0.2716 145 \$1,450 \$1,500 \$138 \$88 125 0.4672 171 \$1,710 \$1,500 \$73 \$283 126 0.8041 218 \$2,000 \$1,500 \$0 \$500 127 0.5157 177 \$1,770 \$1,500 \$58 \$328 128 0.8270 222 \$2,000 \$1,500 \$0 \$500 129 0.8619 229 \$2,000 \$1,500 \$0 \$500 130 0.0790 104 \$1,040 \$1,500 \$240 -\$220 131 0.8876 236 \$2,000 \$1,500 \$0 \$500 132 0.5620 183 \$1,830 \$1,500 \$43 \$373 133 0.5106 176 \$1,760 \$1,500 \$60 \$320 134 0.2487 141 \$1,410 \$1,500 \$148 \$58 135 0.0241 76 \$760 \$1,500 \$310 -\$430 136 0.2813 146 \$1,460 \$1,500 \$135 \$95 137 0.9530 259 \$2,000 \$1,500 \$0 \$500 138 0.9168 244 \$2,000 \$1,500 \$0 \$500 139 0.2203 136 \$1,360 \$1,500 \$160 \$20
140 0.3283 153 \$1,530 \$1,500 \$118 \$148 141 0.2762 145 \$1,450 \$1,500 \$138 \$88 142 0.0432 89 \$890 \$1,500 \$278 -\$333 143 0.3026 149 \$1,490 \$1,500 \$128 \$118 144 0.0862 107 \$1,070 \$1,500 \$233 -\$198 145 0.7810 214 \$2,000 \$1,500 \$0 \$500 146 0.4939 174 \$1,740 \$1,500 \$65 \$305 147 0.8277 222 \$2,000 \$1,500 \$0 \$500 148 0.2708 144 \$1,440 \$1,500 \$140 \$80 149 0.7464 208 \$2,000 \$1,500 \$0 \$500 150 0.5688 184 \$1,840 \$1,500 \$40 \$380 151 0.5316 179 \$1,790 \$1,500 \$53 \$343 152 0.5829 185 \$1,850 \$1,500 \$38 \$388 153 0.3441 155 \$1,550 \$1,500 \$113 \$163 154 0.6465 194 \$1,940 \$1,500 \$15 \$455 155 0.6028 188 \$1,880 \$1,500 \$30 \$410 156 0.6596 196 \$1,960 \$1,500 \$10 \$470 157 0.3082 150 \$1,500 \$1,500 \$125 \$125 158 0.5921 187 \$1,870 \$1,500 \$33 \$403 159 0.3526 156 \$1,560 \$1,500 \$110 \$170 160 0.3780 159 \$1,590 \$1,500 \$103 \$193 161 0.3870 161 \$1,610 \$1,500 \$98 \$208 162 0.3977 162 \$1,620 \$1,500 \$95 \$215 163 0.3171 151 \$1,510 \$1,500 \$123 \$133 164 0.8341 224 \$2,000 \$1,500 \$0 \$500 165 0.1568 125 \$1,250 \$1,500 \$188 -\$63 166 0.0263 78 \$780 \$1,500 \$305 -\$415 167 0.7369 207 \$2,000 \$1,500 \$0 \$500 168 0.2742 145 \$1,450 \$1,500 \$138 \$88 169 0.0138 65 \$650 \$1,500 \$338 -\$513 170 0.5671 183 \$1,830 \$1,500 \$43 \$373 171 0.9995 341 \$2,000 \$1,500 \$0 \$500 172 0.7216 204 \$2,000 \$1,500 \$0 \$500 173 0.0069 52 \$520 \$1,500 \$370 -\$610 174 0.3435 155 \$1,550

#### You've reached the end of your free preview.

Want to read all 97 pages?