极地公司仿真模型.xls

极地公司excel仿真模型 羊绒衫成本50 冬季的售价150 冬季的需求量均值3000 冬季的需求量标准差1000 打折品需求量的均值250 打折品需求量的标准差83.33333333 订购量3000订购成本 冬季需求量3815冬季的销售收入 将要打折的羊绒衫数量-815打折品的销售收入 打折后的价格190.75捐赠的净利润 打折价下的需求量420纯利润 打折商品销量274 捐赠数量-1235 平均利润278686.2984 打折销售的羊绒衫平均数-8.262 利润的标准差62153.94452 捐赠的羊绒衫平均数-257.53 纯利润打折销售数量捐赠数量 327565.5-815-1235 264146.3501253 217606.1847758 193196.31001798 276789.6392-7 327585.7-961-1334 333664.7-231-530 320889-1970-2360 146927.113171071 336557.2-156-334 193957.81006877 335090.8-284-495 -4549026622348 331941.3-549-834 336720.6-38-245 334218.9-597-753 178735.21104918 74597.818061457 329598.4-1032-1282 325599.565-243 332536.4-172-546 328030-700-1133 332306.9-1237-1287 216120.8816430 333771.9-287-563 327698.5-905-1290 247580.8616366 330070.3-519-907 5077719901772 270498460235 141696.113471055 -10658.524052097 236279.6692423 333850.4-592-768 327432.3-979-1354 332518.3-759-949 330242-1060-1269 336420.3-19-247 333968.2-386-621 281698.436842 84891.617321366 309588.1187-45 12418414801268 319270.8116-142 330191.4-722-1040 141781.313511092 74909.718191579 327069.5-1335-1616 337975.9-7-161 145747.913331143 333726.79-295 332201.4-1022-1145 334515.6-388-595 245244.5615241 333823.6-428-657 333474.7-531-745 329172.3-979-1267 337353.3-309-399 332063.6-228-608 191134.8996654 334399.9-527-696 332137.4-502-792 224160.6762390 331980.2-346-693 331705.6-688-941 265347490223 193680.7989724 277633.4418248 331701-330-696 -3149025602283 319546.5-2145-2547 90254.517151495 97708.316411262 333334.7-331-615 314505150-102 145027.11317976 326510-1900-2031 242789.1657462 331710-100-538 202544.9923627 328971-1230-1449 211074.3861546 337415.1-23-200 331264.2-266-674 253571570289 334070.1-573-744 337347.1-183-313 334300.1-273-527 334289.9-427-633 332894.5-785-948 311660.718975 288850.8316-26 280387.4398222 328384.5-1085-1379 319950.8116-108 333658.3-759-892 85010.917431462 311678.3141-317 314502140-184 279677.8406252 294391.4278-60 32342.621021767 269878460204 334051-230-510 325297.8-1394-1745 232033.8726489 321579.7-2381-2607 70072.818561640 338487.9-167-245 321755.993-206 242300.9643323 331772.2-906-1087 289104.2334134 331102.5-425-791 192287.51025949 331256.9-1137-1271 332349.3-389-704 328959.7-981-1279 323884.896-75 42388.320411770 324022.7-2171-2341 320671.5105-162 150721.812861007 328931.9-887-1216 300618260104 322601.1-2003-2297 329246.2-726-1090 333075.1-823-965 330085.1-723-1046 332931.3-249-579 334095.1-223-503 303266220-91 331057.3-1029-1207 330044.7-1031-1259 332681.3-749-934 263254.4488102 336184.3-139-341 328162.1-1333-1560 71549.718191411 248939.2584172 327851.7-1141-1444 335397.1-283-479 302171.3251108 275425.3431244 330481.4-1022-1231 322288.6-2478-2638 314216.9163-10 305511.1197-167 331989.6-808-1009 332637.4-502-767 333370.4-192-518 27728040083 89967.817061407 265841.1497305 229334.6742485 332540.3-219-578 187277.91033764 328651.5-595-1030 332413.2-636-870 207078.2914780 334546.3-199-464 264171.5505287 333086.3-199-537 284950.93430 336539.4-362-476 330988.5-805-1057 325879.9-1327-1670 334814.6-58-354 298204.726957 330490.6-538-899 332892-560-794 264104.1507300 332236.8-464-761 337471.8-414-465 293621.8286-33 110451.715591228 279593.3391125 329825.2-1396-1520 333685.2-596-779 331379-1070-1219 327929.6-1008-1349 27510341056 229387.9733414 336243.4-282-436 204378.2914645 248231.9613374 306227.4198-123 280728.1387149 334396.8-264-516 237039.6692461 332243-390-710 328585.8-1034-1334 75310.418081509 327957.8-1194-1475 331622.2-406-752 187148.31041823 86575.417581663 232677.5725513 327470.3-1119-1448 331705.8-434-767 188782.31021741 245817.9633417 324336.3-1699-2002 331234-1020-1192 325735.5-1515-1806 334004.3-139-450 227468.7749449 -6222027892464 293592.9283-59 328372.6-1398-1594 331489.7-681-947 337751.8-214-314 333827.9-367-615 330797-810-1070 306210.5235179 216789.1857799 326821-1130-1488 256592.4548260 326703.6-1228-1561 324194.2-1766-2055 335806.6-18-277 335183.1-63-339 282445350-68 224565.9793664 329367.1-983-1260 328592.9-817-1185 1910231010763 326097.371-169 287946.5355248 147341.913131059 331138.1-1013-1192 328272.7-1271-1512 302053.524553 335093.6-728-799 333118.622-219 316366.2-3126-3378 327932.4-852-1242 134656.314011145 300112.825646 331644-520-829 181699.51065747 325333.5-1655-1922 326687.8-1494-1744 332814.4-512-765 335257.6-248-462 333852.1-233-522 334386.8-364-585 262531.5505205 336698.4-32-242 332497.86-381 332463.3-409-712 334832.6-198-449 326575.1-1423-1701 261338.2514219 327624.9-1177-1480 176116.71109828 332492.3-579-827 336682.7-171-338 294203.4318258 207475.9893628 325944.8-1504-1788 333476.4-172-499 337598.7-251-347 140459.213841296 295226.2274-51 329605-850-1157 326444.8-1504-1763 170765.71139806 204741.9913655 328871.5-995-1293 229401.2724341 333523.7-301-585 283742.1367136 337641.5-295-375 325527.8-1694-1939 331147.8-694-973 301665.3231-81 329964.5-685-1026 328990.1-773-1135 145849.413381189 331985.9-907-1077 164848.11187903 327155.9-807-1250 182896.51055725 218040.8816526 324685-2050-2225 30810321069 330342.2-206-679 324585.8-1834-2082 198422.8956691 331004.3-739-1011 60173.119371808 150344.812961070 329481.3-749-1094 1824611070826 176148.61122936 332891.4-522-768 296058.82767 329462.9-517-936 330441.6-568-922 329291.1-1103-1346 331680.9-657-921 315805.816694 328787.2-1056-1339 316497.615214 214386.1847597 240886.9663416 330763.137-214 322978.9103-63 214370.6862719 144650.81316949 325383.6-1628-1901 323470.789-153 335003.1-463-622 333736.9-537-736 247463.1637532 335879.3-89-322 281037390189 327856-680-1128 137927.313711063 250954580240 332327-510-788 196320.6962635 334658.622-142 333370.2-446-692 324294.2-1566-1913 241042.5675522 335902.1-133-351 268664480307 262011.5505179 266720.3481218 257799530173 259221.9513105 333823.8-174-483 244376.4628304 334038.4-432-649 338122.1-133-240 142799.113571192 318892.3121-120 270407.7479386 335588.6-78-329 317910.1127-120 140648.813761240 254287.3571333 307762.3221142 283954380253 331586.5-545-849 331096.428-271 339919.4-162-170 333977.3-629-787 325983.8-1374-1697 329508-1040-1292 333104.515-277 335831-230-421 336039.1-343-488 187924.61042870 291171.53050 33125240-165 127932.114671349 331302.2-1206-1316 331207.6-1148-1281 326742.5-825-1283 226928.8776643 330314.1-893-1151 329507.6-1148-1366 334730.3-119-400 -9706.624182251 263638.9503244 331369-370-740 323761.7-1641-1991 331359-670-946 168338.41168922 3184.223342208 221005.3831797 190045.31031886 332441.1-603-846 328949.4-1062-1335 159088.312411057 280139.238495 282002.9383180 333844.6-558-745 330487.3-329-756 325071.2-1376-1744 334137.3-429-642 254050.3581403 277933.4418263 279765.137719 328540-1000-1313 333956-80-412 315201.3-3149-3452 225530.3781614 -10228.124132184 332135.3-369-701 235759.6692397 179557.41098910 310895.4158-217 218606820587 316235.415850 228857.6752543 223563810753 334719.4-562-704 325845.585-67 263094.5515315 267800.3481272 173730.91143987 335277.5-375-548 331622.6-898-1089 330066-980-1223 327386.9-1237-1533 335946.7-91-320 334125.4-742-857 327163.4-1682-1849 275963.8426230 -6009027742458 314041.3151-117 102558.616221349 336703.5-555-600 315856.8136-149 212406.9863629 265277.4498285 323135.993-137 118827.815061213 328171.478-8 327026.9-1037-1414 221034.1807602 15204712901106 331857.5-975-1130 329172.98383 260596520231 203223.5945841 331006.2-526-865 224521.4778539 319959.7119-83 331722.6-298-673 323720.3-1819-2115 323965.585-161 127019.514651287 334983.2-736-810 330696.4-572-912 333838.7-451-672 313722.8156-92 327942-1260-1521 38486.920631755 332692.5-325-643 325194.9-2077-2218 249285.2604353 152274.412881101 179724.11107992 333045.7-761-924 333992.7-71-404 317210.1127-155