CreatingPriceIndexforAucksunKevinM.VaydaBennieJonesZhongwenZhangDongaiWuZhenqingPan1Overviewofthepastweeks2ProblemStatementIndustryspecialty(行业特点)Corecompetency(核心竞争力)Enhanceperformance(提高绩效)Uniquenatureofproduct(产品的独特性)Fairlyrewardthesalesmen(销售人员的公平的奖励)3ProjectGoalsTocreateapriceindex(建立一个价格指数)TobuildupamechanismtofairlyrewardAucksun’ssalesmen(建立一种公平奖励销售人员的机制)4•BasicinformationAucksunisestablishedunderthejointinvestmentofJiangsuAustraliaIndustryCorporationandtheHongKongChang-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.20ResultsandFindings2122TheexistingbonussysteminAucksun•Theresetpricereflectsthechangingrawmaterialprices.(重置价格反映了原材料价格的波动。)•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——CRUTheCRUSteelPriceIndexisa“leadingindicatorofsteelpricetrends.”Thereareeightindicesareweightedandcompiledtoformthe“CRUspi”indices.(CRU钢材价格指数是“领先的钢材价格趋势的指标”,权衡综合了八个指标因素。)OntheCRUwebsitethereisa“MarketAnalysis”pageinwhichthemonitorslistedabovecanbeexamined.Theanalysisofthesemonitorsalsoprovideshistoricalandstatisticaldataonsteelindices,alongwithwrittenanalysisbyCRU’sfull-timesteelanalystswithrespecttomarketfundamentalsandotherimportantaspects.ThereisanewCRUspi“Futures”serviceat(在CRU网站上有一个列有多个监测器的“市场分析”页面。这些监测器的分析还提供钢材价格的历史统计数据,以及CRU的实时钢材价格分析。这是CRU的“未来”服务,用于预测18~24个月后的钢材价格。)ResultsandFindingsIndexExistingindexCRUMyspic…CPIofHomeApplicantsSPSS27FuturePl