澳洋顺昌项目组阶段报告riceIndexfor

CreatingPriceIndex

forAucksunKevin

M.

VaydaBennieJonesZhongwenZhangDongaiWuZhenqingPan1Overviewofthepastweeks2ProblemStatementIndustryspecialty（行业特点）Corecompetency（核心竞争力）Enhanceperformance（提高绩效）Uniquenatureofproduct（产品的独特性）Fairlyrewardthesalesmen（销售人员的公平的奖励）3ProjectGoalsTocreateapriceindex（建立一个价格指数）TobuildupamechanismtofairlyrewardAucksun’ssalesmen（建立一种公平奖励销售人员的机制）4BasicinformationAucksunisestablishedunderthejointinvestmentofJiangsuAustraliaIndustryCorporationandtheHongKongChang-Zheng,Ltd.（澳洋顺昌是由江苏澳洋实业(集团)公司和香港昌正有限公司共同投资设立）Thelandareaisabout24,000m2withtheconstructionareaof9,600m2.（建筑面积是9,600m2，使用面积是24,000m2）Itsproductionandprocessingcapacityisattainably132,000tonsperyear,processingsteelproduction8,000to10,000tonspermonthandaluminum1,000tonspermonth.（年生产加工能力可达132,000吨：钢铁加工能力为每月8,000到10,000吨；铝加工能力为每月1000吨。）Theinventoryis30,000tonsofsteeland2,000tonsofaluminum.（库存量有3万吨钢和2千吨铝。）Thecurrentnumberofcustomersisabout300.（目前客户数量达300。）5OrganizationChartTheoldoneThenewoneCEOVPVPBusinessDept.SupportingDept.ManufactureDept.InformationDept.ServicesectionManagementDept.QualitymanagementsectionManufacturesectionRawmaterialsectionCustomClearanceDept.HumanResourcesDept.FinancialDept.6Operation---PurchasingModeRegularPurchasingInventoryanalysisanddemandforecastPlacementofconsolidatedordersAssessmentandofferfromthesuppliersOrderswithneededspecificationsfromAucksunBargainingMakecontractsEarnestmoneydepositandletterofcreditFinalpaymentInspection,CustomsclearanceandshippingBarcodeandStorage7Operation---ManufacturingMode8Operation---FunctionalModuleofERP9PreliminaryStudy10TheSteelIndustryCustomersneedamiddlemanOrdertimesaresmallNeedmorecooperationwithindepts.11RequirementsMake-to-orderOptimizemanufacturingprocessBudgetcontrolAcodemanagementsystemTakecustomsintoconsideration12TheBonusSystemPBTRewardingsalesdeptFluctuatingprofitsonsteel13PriceIndexSystemLondonMetalExchangeMysteelPriceIndicesofChinaIndicesandAucksun14LiteratureReview15LiteratureReviewEliminatedsomeliteratureoninventory.Reviewednewliteratureonpriceindices.Creatednewformat:RiskSupplyContractsPriceIndices16Methodology17MethodologyFirstObjective:Identifytheproblem.Method:ExamineAucksun’’smainrisks:InventorySupplyPriceCustomerSegmentationMethod:Communicatewithmanagement.18MethodologySecondObjective:Understandhowindicesarecreated.Method:StudyLMEIndex.Method:Studyexistingsteelindicesandtheirrelationshipwiththeindexwewanttocreate.Method:Examineriskfactorsthatmayinfluencetheindexwewanttocreate.Method:Determinewhichdatawillneedtobecollected.Method:Collectdata.19MethodologyThirdObjective:Developandimplementanindexforthecurrentproblem.Fourthobjective:Evaluatetheimplementedindex.20ResultsandFindings2122TheexistingbonussysteminAucksunTheresetpricereflectsthechangingrawmaterialprices.（重重置置价价格格反反映映了了原原材材料料价价格格的的波波动动。。））Althoughtherearemanyotherobjectfactorsinthisformula,buttheyarestableingeneral.（尽尽管管公公式式中中存存在在多多个个影影响响因因素素，，但但是是，，相相对对来来说说，，它它们们都都是是固固定定的的。。））The△standsfortheaddedvalueoftheproducts,andthisistheexactfactorthatcouldbeusedtoevaluatetheperformanceofthesalesemployees.（△代表产品品的附加价值值，也是可对对销售人员进进行绩效评价价的值。）Priceofproductions:23LMEindexisapriceindexforaluminum.(伦敦金属交易易指数是铝的的价格指数。。)ToAucksun,thepriceofaluminumproductionisPrice=LME+ProcessingFee+△△△isavaluetomeasurethesalesmen’sperformance.(对于澳洋顺昌昌，铝产品的的价格是价格=LME+加工费+△，其中△就就是衡量销售售人员绩效的的值)But,whataboutsteelproductions?Priceindexforaluminumproductions24TheexistingindexforsteelpriceindexProductsCodesProductsnamesPriceindexP0000SpecialmaterialsContactpricesP0001Domesticsteel/cold-rolledMyspic:cold-rolledP0002Domesticsteel/hot-rolledMyspic:hot-rolledP0003Domesticsteel/hot-galvanizeMyspic:zinc-platedP0004Domesticsteel/electro-galvanizeThepricefromBaosteelP0005Exportsteel/zinc-platedThepricefromBaosteel:electro-galvanizeP0006Exportsteel/Pohangelectro-galvanizeP0007DomesticaluminumSHFEP0008ExportaluminumLMEMyspicisshortforMysteelpriceindicesofChina.ThepriceinformationusedbyMyspicisthedailyconcludedpriceinthemarketfromsevenbigcitiesinChina,theyareShanghai,Guangzhou,Beijing,Wuhan,Chongqing,ShenyangandXian.（Myspic的信息来源于于中国七大市市场（上海、、广州、北京京、武汉、重重庆、沈阳和和西安）的当当日价格汇总总。）25TheexistingindexforsteelpriceindexPreset=MySpicIndex*MySpicIndexPriceMySpicIndexPriceisavaluethatAucksunsetdependingontheirexperience.（Myspic指数价是澳洋洋顺昌根据其其经验得出的的值。）26Otherindex——CRUResultsandFindingsIndexExistingindexCRUMyspic…CPIofHomeApplicantsSPSS27FuturePlan28PlanforNextWeekDateTaskPeopleinvolved7.2FindsomeinformationaboutSPSS,andseeifitcanhelpustoanalysisthedataandcreatetheindex.Aaron,Jobeky,JoJo7.3Doapresentation;DiscusswiththeprofessorsaboutthemethodologypartandfigureoutwhetherSPSSisasuitabletool,ifnot,fixanothertool.Thenfindwhatkindofhelpwecangetandwhoaregoingtohelpus.Aaron,Jobeky,JoJoKevin,BennieProfessors7.4Learnhowtousethetool;Figureoutthekindsandquantityoftheneededdata;Usethetooltoanalysisthedata;UsethetooltocreatetheindexbasedontheanalysisAaron,JobekyKevin,BennieSomeonehelpful7.87.9FinishwritingthemethodologychapterKevin,Bennie7.1029QuestionsforDiscussions301.IsSPSSasuitabletoolfortheproject?Orwhattoolswillbeuseful，exceptSPSS?2.Whatkindofhelpcanwegetfromthemasterstudents?AndWhoisgoingtohelpus?9、静夜四四无邻，，荒居旧旧业贫。。。12月-2212月-22Sunday,December25,202210、雨中黄叶树树，灯下白头头人。。05:16:0405:16:0405:1612/25/20225:16:04AM11、以我独沈久久，愧君相见见频。。12月-2205:16:0405:16Dec-2225-Dec-2212、故人江海别别，几度隔山山川。。05:16:0405:16:0405:16Sunday,December25,202213、乍见见翻疑疑梦，，相悲悲各问问年。。。12月月-2212月月-2205:16:0405:16:04December25,202214、他乡乡生白白发，，旧国国见青青山。。。25十十二二月20225:16:04上上午05:16:0412月月-2215、比不不了得得就不不比，，得不不到的的就不不要。。。。。十二月月225:16上上午午12月月-2205:16December25,202216、行行动动出出成成果果，，工工作作出出财财富富。。。。2022/12/255:16:0405:16:0425December202217、做做前前，，能能够够环环视视四四周周；；做做时时，，你你只只能能或或者者最最好好沿沿着着以以脚脚为为起起点点的的射射线线向向前前。。。。5:16:04上上午午5:16上上午午05:16:0412月月-229、没没有有失失败败，，只只有有暂暂时时停停止止成成功功！！。。12月月-2212月月-22Sunday,December25,202210、很多事事情努力力了未必必有结果果，但是是不努力力却什么么改变也也没有。。。05:16:0405:16:0405:1612/25/20225:16:04AM11、成功就就是日复复一日那那一点点点小小努努力的积积累。。。12月-2205:16:0405:16Dec-2225-Dec-2212、世间成事，，不求其绝对对圆满，留一一份不足，可可得无限完美美。。05:16:0405:16:0405:16Sunday,December25,202213、不知香积寺寺，数里入云云峰。。12月-2212月-2205:16:0405:16:04December25,202214、意志坚强强的人能把把世界放在在手中像泥泥块一样任任意揉捏。。25十二二月20225:16:04上上午05:16:0412月-2215、楚塞三湘湘接，荆门门九派通。。。。十二月225:16上上午12月-2205:16December25,202216、少年十五五二十时，，步行夺得得胡马骑。。。2022/12/255:16:0405:16:0425December202217、空空山山新新雨雨后后，，天天气气晚晚来来秋秋。。。。5:16:04上上午午5:16上上午午05:16:0412月月-229、杨杨柳柳散散和和风风，，青青山山澹澹吾吾虑虑。。。。12月月-2212月月-22Sunday,December25,202210、阅阅读读一一切切好好书书如如同同和和过过去