极地公司仿真模型.xls

《极地公司仿真模型.xls》由会员分享，可在线阅读，更多相关《极地公司仿真模型.xls（24页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、极地公司excel仿真模型羊绒衫成本50冬季的售价150冬季的需求量均值3000冬季的需求量标准差1000打折品需求量的均值250打折品需求量的标准差83.33333333订购量3000冬季需求量3815将要打折的羊绒衫数量-815打折后的价格190.75打折价下的需求量420打折商品销量274捐赠数量-1235平均利润278686.2984 打折销售的羊绒衫平均数利润的标准差62153.94452 捐赠的羊绒衫平均数纯利润打折销售数量327565.5-815264146.3501217606.1847193196.31001276789.6392327585.7-961333664.7-23

2、1320889-1970146927.11317336557.2-156193957.81006335090.8-284-454902662331941.3-549336720.6-38334218.9-597178735.2110474597.81806329598.4-1032325599.565332536.4-172328030-700332306.9-1237216120.8816333771.9-287327698.5-905247580.8616330070.3-519507771990270498460141696.11347-10658.52405236279.6692333

3、850.4-592327432.3-979332518.3-759330242-1060336420.3-19333968.2-386281698.436884891.61732309588.11871241841480319270.8116330191.4-722141781.3135174909.71819327069.5-1335337975.9-7145747.91333333726.79332201.4-1022334515.6-388245244.5615333823.6-428333474.7-531329172.3-979337353.3-309332063.6-2281911

4、34.8996334399.9-527332137.4-502224160.6762331980.2-346331705.6-688265347490193680.7989277633.4418331701-330-314902560319546.5-214590254.5171597708.31641333334.7-331314505150145027.11317326510-1900242789.1657331710-100202544.9923328971-1230211074.3861337415.1-23331264.2-266253571570334070.1-573337347

5、.1-183334300.1-273334289.9-427332894.5-785311660.7189288850.8316280387.4398328384.5-1085319950.8116333658.3-75985010.91743311678.3141314502140279677.8406294391.427832342.62102269878460334051-230325297.8-1394232033.8726321579.7-238170072.81856338487.9-167321755.993242300.9643331772.2-906289104.233433

6、1102.5-425192287.51025331256.9-1137332349.3-389328959.7-981323884.89642388.32041324022.7-2171320671.5105150721.81286328931.9-887300618260322601.1-2003329246.2-726333075.1-823330085.1-723332931.3-249334095.1-223303266220331057.3-1029330044.7-1031332681.3-749263254.4488336184.3-139328162.1-133371549.7

7、1819248939.2584327851.7-1141335397.1-283302171.3251275425.3431330481.4-1022322288.6-2478314216.9163305511.1197331989.6-808332637.4-502333370.4-19227728040089967.81706265841.1497229334.6742332540.3-219187277.91033328651.5-595332413.2-636207078.2914334546.3-199264171.5505333086.3-199284950.9343336539.

8、4-362330988.5-805325879.9-1327334814.6-58298204.7269330490.6-538332892-560264104.1507332236.8-464337471.8-414293621.8286110451.71559279593.3391329825.2-1396333685.2-596331379-1070327929.6-1008275103410229387.9733336243.4-282204378.2914248231.9613306227.4198280728.1387334396.8-264237039.6692332243-39

9、0328585.8-103475310.41808327957.8-1194331622.2-406187148.3104186575.41758232677.5725327470.3-1119331705.8-434188782.31021245817.9633324336.3-1699331234-1020325735.5-1515334004.3-139227468.7749-622202789293592.9283328372.6-1398331489.7-681337751.8-214333827.9-367330797-810306210.5235216789.1857326821

10、-1130256592.4548326703.6-1228324194.2-1766335806.6-18335183.1-63282445350224565.9793329367.1-983328592.9-8171910231010326097.371287946.5355147341.91313331138.1-1013328272.7-1271302053.5245335093.6-728333118.622316366.2-3126327932.4-852134656.31401300112.8256331644-520181699.51065325333.5-1655326687.

11、8-1494332814.4-512335257.6-248333852.1-233334386.8-364262531.5505336698.4-32332497.86332463.3-409334832.6-198326575.1-1423261338.2514327624.9-1177176116.71109332492.3-579336682.7-171294203.4318207475.9893325944.8-1504333476.4-172337598.7-251140459.21384295226.2274329605-850326444.8-1504170765.711392

12、04741.9913328871.5-995229401.2724333523.7-301283742.1367337641.5-295325527.8-1694331147.8-694301665.3231329964.5-685328990.1-773145849.41338331985.9-907164848.11187327155.9-807182896.51055218040.8816324685-2050308103210330342.2-206324585.8-1834198422.8956331004.3-73960173.11937150344.81296329481.3-7

13、491824611070176148.61122332891.4-522296058.8276329462.9-517330441.6-568329291.1-1103331680.9-657315805.8166328787.2-1056316497.6152214386.1847240886.9663330763.137322978.9103214370.6862144650.81316325383.6-1628323470.789335003.1-463333736.9-537247463.1637335879.3-89281037390327856-680137927.31371250

14、954580332327-510196320.6962334658.622333370.2-446324294.2-1566241042.5675335902.1-133268664480262011.5505266720.3481257799530259221.9513333823.8-174244376.4628334038.4-432338122.1-133142799.11357318892.3121270407.7479335588.6-78317910.1127140648.81376254287.3571307762.3221283954380331586.5-545331096

15、.428339919.4-162333977.3-629325983.8-1374329508-1040333104.515335831-230336039.1-343187924.61042291171.530533125240127932.11467331302.2-1206331207.6-1148326742.5-825226928.8776330314.1-893329507.6-1148334730.3-119-9706.62418263638.9503331369-370323761.7-1641331359-670168338.411683184.22334221005.383

16、1190045.31031332441.1-603328949.4-1062159088.31241280139.2384282002.9383333844.6-558330487.3-329325071.2-1376334137.3-429254050.3581277933.4418279765.1377328540-1000333956-80315201.3-3149225530.3781-10228.12413332135.3-369235759.6692179557.41098310895.4158218606820316235.4158228857.67522235638103347

17、19.4-562325845.585263094.5515267800.3481173730.91143335277.5-375331622.6-898330066-980327386.9-1237335946.7-91334125.4-742327163.4-1682275963.8426-600902774314041.3151102558.61622336703.5-555315856.8136212406.9863265277.4498323135.993118827.81506328171.478327026.9-1037221034.18071520471290331857.5-9

18、75329172.983260596520203223.5945331006.2-526224521.4778319959.7119331722.6-298323720.3-1819323965.585127019.51465334983.2-736330696.4-572333838.7-451313722.8156327942-126038486.92063332692.5-325325194.9-2077249285.2604152274.41288179724.11107333045.7-761333992.7-71317210.1127140121.41378336697.3-629

19、329953.3-1109286047.2344216439.4838334108.1-713-7589.62408332055.7-661329163.8-774248112.6602246470.5635313801.8-2714323549.9-1827311831.7159247347.5625170940.61162327143.5-955333742.4-152325752.7-1471328165.5-1415314339.8146254577.7579312231170325550.1-1773202503.5945336898.9-197334456.3-99332686.5

20、-145332784.7-631328594.9-877249517.1617334100.4-492323517.4-2102267726.2474329270.4-792219910.4808335584.9-577205023.389133792.22094244611.2624312006.5155330832.4-652333486.9-37331879-1070277618.5395331990.5-865243909.1657324478.187333490.8-484订购成本150000冬季的销售收入450000打折品的销售收入52265.5捐赠的净利润-24700纯利润327

21、565.5-8.262-257.53捐赠数量-1235253758798-7-1334-530-23601071-334877-4952348-834-245-7539181457-1282-243-546-1133-1287430-563-1290366-907177223510552097423-768-1354-949-1269-247-621421366-451268-142-104010921579-1616-1611143-295-1145-595241-657-745-1267-399-608654-696-792390-693-941223724248-6962283-2547

22、14951262-615-102976-2031462-538627-1449546-200-674289-744-313-527-633-94875-26222-1379-108-8921462-317-184252-601767204-510-1745489-26071640-245-206323-1087134-791949-1271-704-1279-751770-2341-1621007-1216104-2297-1090-965-1046-579-503-91-1207-1259-934102-341-15601411172-1444-479108244-1231-2638-10-

23、167-1009-767-518831407305485-578764-1030-870780-464287-5370-476-1057-1670-35457-899-794300-761-465-331228125-1520-779-1219-134956414-436645374-123149-516461-710-13341509-1475-7528231663513-1448-767741417-2002-1192-1806-4504492464-59-1594-947-314-615-1070179799-1488260-1561-2055-277-339-68664-1260-11

24、85763-1692481059-1192-151253-799-219-3378-1242114546-829747-1922-1744-765-462-522-585205-242-381-712-449-1701219-1480828-827-338258628-1788-499-3471296-51-1157-1763806655-1293341-585136-375-1939-973-81-1026-11351189-1077903-1250725526-222569-679-2082691-101118081070-1094826936-7687-936-922-1346-9219

25、4-133914597416-214-63719949-1901-153-622-736532-322189-11281063240-788635-142-692-1913522-351307179218173105-483304-649-2401192-120386-329-1201240333142253-849-271-170-787-1697-1292-277-421-4888700-1651349-1316-1281-1283643-1151-1366-4002251244-740-1991-9469222208797886-846-1335105795180-745-756-174

26、4-64240326319-1313-412-34526142184-701397910-21758750543753-704-67315272987-548-1089-1223-1533-320-857-18492302458-1171349-600-149629285-1371213-8-14146021106-113083231841-865539-83-673-2115-1611287-810-912-672-92-15211755-643-22183531101992-924-404-1551230-651-131763626-8382275-905-1127278466-3224-2129-1624281003-1352-472-1775-1616-143413-52-1992805-345-400-520-848-1226471-687-2319211-1134554-6714891774283-186-960-406-119459-1048518-119-712