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
Image of page 1
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
Image of page 2
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
Image of page 3
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
Image of page 4
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
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 97 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture