例6-9 宝洁公司洗衣粉随机需求延期交货模拟模型.xls

例6 9 在例6 8的基础上 考虑日需求是90 110之 间均匀分布的随机数 日需求量100固定需求延期交货模拟表年成本 84500 一次订货的订货成本500 单位年储存成本100期初开始结束订货 延期交订货 初始库存量100天到货库存量库存量标志 货天数成本 单位日储存成本0 280100 订货量20010100010500 年订货成本84500220020010010500 年储存成本14736 1113200300200000 年总成本99236 1114020010010500 5200300200000 最优订货量5006020010010500 年总成本极小值72169 97200300200000 8020010010500 9200300200000 10020010010500 11200300200000 12020010011500 1301000000 1420020010011500 查询时间 天 101501000000 当日平均库存量1501620020010012500 100天日平均库存量146170100011500 18000000 19400400300000 200300200000 21020010010500 22200300200000 23020010012500 240100011500 25000000 26400400300000 270300200000 28020010010500 29200300200000 30020010010500 31200300200000 32020010010500 33200300200000 34020010011500 3501000000 3620020010010500 37200300200000 38020010011500 3901000000 4020020010012500 410100010500 42200200100000 43200300200000 A BCDEFGHIJKLMNOP 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 44020010011500 4501000000 4620020010010500 47200300200000 48020010011500 4901000000 5020020010011500 5101000000 5220020010011500 5301000000 5420020010011500 5501000000 5620020010010500 57200300200000 58020010011500 5901000000 6020020010012500 610100010500 62200200100000 63200300200000 64020010010500 65200300200000 66020010010500 67200300200000 68020010011500 6901000000 7020020010012500 710100010500 72200200100000 73200300200000 74020010011500 7501000000 7620020010011500 7701000000 7820020010012500 790100012500 80000000 81200200100000 82200300200000 83020010011500 8401000000 8520020010012500 860100012500 87000000 88200200100000 89200300200000 90020010011500 9101000000 9220020010011500 A BCDEFGHIJKLMNOP 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 9301000000 9420020010010500 95200300200000 96020010010500 97200300200000 98020010011500 9901000000 10020020010011500 10101000000 10220020010012500 1030100010500 104200200100000 105200300200000 106020010012500 1070100011500 108000000 109400400300000 1100300200000 111020010012500 1120100010500 113200200100000 114200300200000 115020010011500 11601000000 11720020010012500 1180100011500 119000000 120400400300000 1210300200000 122020010010500 123200300200000 124020010010500 125200300200000 126020010011500 12701000000 12820020010011500 12901000000 13020020010012500 1310100010500 132200200100000 133200300200000 134020010010500 135200300200000 13602001001150013820020010010500 139200300200000 140020010010500 141200300200000 A BCDEFGHIJKLMNOP 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 1420200100115001442002001001150014620020010012500 1470100011500 148000000 149400400300000 1500300200000 151020010010500 152200300200000 15302001001150015520020010010500 156200300200000 157020010010500 158200300200000 159020010012500 1600100011500 161000000 162400400300000 1630300200000 164020010012500 1650100012500 166000000 167200200100000 168200300200000 169020010012500 1700100010500 171200200100000 172200300200000 1730200100115001752002001001150017720020010011500179200200100115001812002001001150018320020010010500 184200300200000 185020010010500 186200300200000 187020010010500 188200300200000 189020010010500 190200300200000 A BCDEFGHIJKLMNOP 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 191020010010500 192200300200000 193020010012500 1940100011500 195000000 196400400300000 1970300200000 198020010011500 19901000000 20020020010012500 2010100012500 202000000 203200200100000 204200300200000 205020010011500 20601000000 20720020010010500 208200300200000 209020010011500 21001000000 21120020010012500 2120100010500 213200200100000 214200300200000 215020010010500 216200300200000 217020010010500 218200300200000 219020010010500 220200300200000 221020010011500 22201000000 22320020010012500 2240100012500 225000000 226200200100000 227200300200000 228020010012500 2290100011500 230000000 231400400300000 2320300200000 233020010012500 2340100011500 235000000 236400400300000 2370300200000 238020010011500 23901000000 A BCDEFGHIJKLMNOP 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 24020020010012500 2410100012500 242000000 243200200100000 244200300200000 245020010011500 24601000000 24720020010010500 248200300200000 249020010010500 250200300200000 251020010010500 252200300200000 253020010010500 254200300200000 255020010012500 2560100011500 257000000 258400400300000 2590300200000 260020010012500 2610100012500 262000000 263200200100000 264200300200000 265020010012500 2660100011500 267000000 268400400300000 2690300200000 270020010010500 271200300200000 272020010010500 273200300200000 274020010010500 275200300200000 276020010011500 27701000000 27820020010012500 2790100012500 280000000 281200200100000 282200300200000 283020010010500 284200300200000 285020010011500 28601000000 28720020010012500 2880100012500 A BCDEFGHIJKLMNOP 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 289000000 290200200100000 291200300200000 292020010011500 29301000000 29420020010010500 295200300200000 296020010010500 297200300200000 298020010012500 2990100011500 300000000 301400400300000 3020300200000 303020010011500 30401000000 30520020010012500 3060100012500 307000000 308200200100000 309200300200000 310020010010500 311200300200000 312020010010500 313200300200000 314020010012500 3150100010500 316200200100000 317200300200000 318020010010500 319200300200000 320020010010500 321200300200000 322020010012500 3230100010500 324200200100000 325200300200000 326020010011500 32701000000 32820020010011500 32901000000 33020020010011500 33101000000 33220020010010500 333200300200000 334020010012500 3350100012500 336000000 337200200100000 A BCDEFGHIJKLMNOP 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 338200300200000 339020010011500 34001000000 34120020010012500 3420100011500 343000000 344400400300000 3450300200000 346020010010500 347200300200000 348020010012500 3490100010500 350200200100000 351200300200000 352020010011500 35301000000 35420020010010500 355200300200000 356020010011500 35701000000 35820020010012500 3590100011500 360000000 A BCDEFGHIJKLMNOP 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 84 50014 73699 23699236 11 14736992362008350014236 197736 120098555 6 2506950019993 189493 125089069 4 平均储存查询3005800020958 378958 330080291 7 库存成本库存3505000026847 276847 235076694 4 4004350028555 672055 640072277 8 5013 8904503900034722 273722 245075583 3 15041 6705003600035208 371208 350072291 7 25069 4405503200042069 474069 455073222 2 15041 6706002950042388 971888 960071666 7 25069 4406502750046354 273854 265078048 6 15041 6707002600053180 679180 670077500 0 25069 4407502400057180 681180 675081145 8 15041 6708002250057555 680055 680086180 6 25069 4408502150062770 884270 885088006 9 15041 67 1509002000069888 989888 990088083 3 25069 4409501900075138 994138 995091486 1 15041 67010001800073680 691680 6100099958 3 5013 89010501750083312 5100812 51050100972 2 15041 67011001650080013 996513 91100101958 3 5013 89011501600088118 1104118 11150110305 6 15041 67012001500091000 0106000 01200111180 6 5013 89012501450098652 8113152 81250109243 1 00 000130014000102388 9116388 91300107138 9 35097 22013501350093743 1107243 11350117229 2 25069 440140013000102569 4115569 41400114791 7 15041 670 25069 440 15041 67050050000 5013 89050072169 9 00 000500130000 35097 220 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 25069 440 QRSTUVWXYZAAAB 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 00 000 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 00 000 15041 670 25069 440 15041 670 5013 890 15041 670 QRSTUVWXYZAAAB 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 5013 890 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 25069 440 QRSTUVWXYZAAAB 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 5013 890 00 000 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 QRSTUVWXYZAAAB 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 15041 670 25069 440 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 5013 890 15041 670 5013 890 00 000 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 00 000 15041 670 25069 440 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 5013 890 QRSTUVWXYZAAAB 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 15041 670 5013 890 00 000 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 5013 890 00 000 15041 670 25069 440 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 00 000 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 QRSTUVWXYZAAAB 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 00 000 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 5013 890 15041 670 5013 890 00 000 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 00 000 15041 670 QRSTUVWXYZAAAB 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 25069 440 15041 670 5013 890 15041 670 5013 890 00 000 35097 220 25069 440 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 25069 440 15041 670 5013 890 15041 670 5013 890 00 000 QRSTUVWXYZAAAB 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 299100 统计平均 98166 798347 299958 397981 8 89298 689194 488208 388560 5 79472 279680 678972 279157 9 77284 777104 276965 377384 9 73458 372125 073944 473090 8 74076 473930 674340 374205 3 69819 471347 271736 172169 9 75819 473590 372923 674739 8 73722 276333 374791 773926 3 76423 679756 976986 177445 8 77027 877500 076569 477431 7 78562 585111 179479 281876 5 80500 081166 780680 681894 2 84069 491340 389590 386045 1 81375 087333 390375 086557 6 89416 789062 594395 890968 5 96777 891236 184013 992735 3 92083 399354 298159 796975 2 96152 8104194 489513 998961 1 103750 097395 8102687 5 103468 8 103513 9100888 9100666 7 105638 5 102118 1112097 298659 7 109207 2 117125 0116013 9120000 0 111972 5 114208 3117319 4118659 7 116293 8 116125 0113902 8120291 7 117101 3 ACDVDWDX 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 日需求量100固定需求延期交货模拟表年成本 85500 一次订货的订货成本500 单位年储存成本100期初开始结束订货 延期交订货 初始库存量100天到货库存量库存量标志 货天数成本 单位日储存成本0 280100 订货量20010100012500 年订货成本85500200010500 年储存成本17407 2223200200102000 年总成本102907 224200302202000 502029412500 最优订货量5006094312500 年总成本极小值76781 27030000 8200200103000 9200303212000 10021211310500 11200313217000 12021711211500 1301128000 1420020811411500 查询时间 天 101501145000 当日平均库存量1631620020511212500 100天日平均库存量1731701121512500 180150000 1920020095000 2020029518812500 2101889412500 220940000 2320020099000 2420029919212500 25019210111500 2601010000 27400400302000 280302210000 29021011711500 30011713000 3120021311510500 32200315209000 33020910712500 3401071411500 350140000 36400400309000 37030919910500 38200399293000 390293202000 4002029712500 41097010500 42200200105000 43200305202000 A BCDEFGHIJKLMNOP 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 44020210612500 4501061112500 460110000 4720020091000 4820029119112500 4901918710500 50200287193000 51200393302000 520302203000 5302039410500 5420029419110500 55200391295000 56029519011500 570190100000 58200300205000 59020510411500 6001048000 6120020811611500 62011625000 6320022512610500 64200326229000 65022912612500 6601262012500 670200000 68200200106000 69200306202000 7002029910500 71200299203000 72020310210500 73200302207000 74020710112500 750101011500 76000000 77400400301000 78030119810500 79200398290000 80029018710500 81200387283000 82028319212500 8301929711500 84097 5 000 85400395288000 86028819712500 87019710311500 8801030000 89400400310000 900310218000 91021811810500 92200318220000 A BCDEFGHIJKLMNOP 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 93022012612500 9401262810500 95200228131000 96200331233000 97023312410500 98200324216000 99021611611500 100011618000 10120021810910500 102200309209000 103020911211500 104011213000 10520021310710500 106200307202000 107020210112500 1080101 3 12500 1090 3 0000 110200200107000 111200307210000 112021011010500 113200310216000 114021611311500 115011320000 11620022012310500 117200323218000 118021811811500 119011822000 12020022212912500 12101293310500 122200233134000 123200334233000 124023313810500 125200338228000 126022813311500 127013338000 12820023812811500 129012833000 13020023313210500 131200332226000 132022612910500 133200329234000 134023413812500 13501384010500 136200240137000 137200337236000 138023614011500 139014048000 14020024815712500 14101576112500 A BCDEFGHIJKLMNOP 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 1420610000 143200200104000 144200304212000 145021211012500 14601101311500 1470130000 148400400307000 149030719911500 1500199106000 15120030619911500 152019989000 15320028918211500 154018278000 15520027817210500 156200372275000 157027517811500 158017876000 15920027617211500 160017272000 16120027217212500 16201728012500 1630800000 16420020096000 16520029618910500 166200389288000 167028818210500 168200382280000 169028018810500 170200388280000 171028018810500 172200388290000 173029019311500 174019386000 17520028619112500 176019110011500178400400301000 1790301201000 180020110612500 1810106211500 182020000 183400400310000 1840310217000 185021712111500 186012117000 18720021711910500 188200319220000 189022011911500 190011916000 A BCDEFGHIJKLMNOP 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 19120021611710500 192200317219000 193021911110500 194200311207000 195020710411500 19601047000 19720020710310500 198200303209000 199020911711500 20001177000 20120020711412500 20201141412500 2030140000 20420020097000 20520029719811500 206019891000 20720029119611500 208019697000 209200297205000 21002059611500 2110960000 21220020010510500 213200305200000 214020010310500 215200303202000 21602029511500 2170950000 21820020010312500 219010