澳洋顺昌项目组阶段报告

CreatingPriceIndex

forAucksunKevin

M.

VaydaBennieJonesZhongwenZhangDongaiWuZhenqingPan1第一页，共三十一页。Overviewofthepastweeks2第二页，共三十一页。ProblemStatementIndustryspecialty（行业特点）Corecompetency（核心竞争力）Enhanceperformance（提高绩效）Uniquenatureofproduct（产品的独特性）Fairlyrewardthesalesmen（销售人员的公平的奖励）3第三页，共三十一页。ProjectGoalsTocreateapriceindex（建立一个价格指数）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。）5第五页，共三十一页。OrganizationChartTheoldoneThenewoneCEOVPVPBusinessDept.SupportingDept.ManufactureDept.InformationDept.ServicesectionManagementDept.QualitymanagementsectionManufacturesectionRawmaterialsectionCustomClearanceDept.HumanResourcesDept.FinancialDept.6第六页，共三十一页。Operation---PurchasingModeRegularPurchasingInventoryanalysisanddemandforecastPlacementofconsolidatedordersAssessmentandofferfromthesuppliersOrderswithneededspecificationsfromAucksunBargainingMakecontractsEarnestmoneydepositandletterofcreditFinalpaymentInspection,CustomsclearanceandshippingBarcodeandStorage7第七页，共三十一页。Operation---ManufacturingMode8第八页，共三十一页。Operation---FunctionalModuleofERP9第九页，共三十一页。PreliminaryStudy10第十页，共三十一页。TheSteelIndustryCustomersneedamiddlemanOrdertimesaresmallNeedmorecooperationwithindepts.11第十一页，共三十一页。RequirementsMake-to-orderOptimizemanufacturingprocessBudgetcontrolAcodemanagementsystemTakecustomsintoconsideration12第十二页，共三十一页。TheBonusSystemPBTRewardingsalesdeptFluctuatingprofitsonsteel13第十三页，共三十一页。PriceIndexSystemLondonMetalExchangeMysteelPriceIndicesofChinaIndicesandAucksun14第十四页，共三十一页。LiteratureReview15第十五页，共三十一页。LiteratureReviewEliminatedsomeliteratureoninventory.Reviewednewliteratureonpriceindices.Creatednewformat:RiskSupplyContractsPriceIndices16第十六页，共三十一页。Methodology17第十七页，共三十一页。MethodologyFirstObjective:Identifytheproblem.Method:ExamineAucksun’smainrisks:InventorySupplyPriceCustomerSegmentationMethod:Communicatewithmanagement.18第十八页，共三十一页。MethodologySecondObjective:Understandhowindicesarecreated.Method:StudyLMEIndex.Method:Studyexistingsteelindicesandtheirrelationshipwiththeindexwewanttocreate.Method:Examineriskfactorsthatmayinfluencetheindexwewanttocreate.Method:Determinewhichdatawillneedtobecollected.Method:Collectdata.19第十九页，共三十一页。MethodologyThirdObjective:Developandimplementanindexforthecurrentproblem.Fourthobjective:Evaluatetheimplementedindex.20第二十页，共三十一页。ResultsandFindings21第二十一页，共三十一页。22TheexistingbonussysteminAucksunTheresetpricereflectsthechangingrawmaterialprices.（重置价格反映了原材料价格的波动。）Althoughtherearemanyotherobjectfactorsinthisformula,buttheyarestableingeneral.（尽管公式中存在多个影响因素，但是，相对来说，它们都是固定的。）The△standsfortheaddedvalueoftheproducts,andthisistheexactfactorthatcouldbeusedtoevaluatetheperformanceofthesalesemployees.（△代表产品的附加价值，也是可对销售人员进行绩效评价的值。）Priceofproductions:第二十二页，共三十一页。23LMEindexisapriceindexforaluminum.(伦敦金属交易指数是铝的价格指数。)ToAucksun,thepriceofaluminumproductionisPrice=LME+ProcessingFee+△△isavaluetomeasurethesalesmen’sperformance.(对于澳洋顺昌，铝产品的价格是

价格=LME+加工费+△，其中△就是衡量销售人员绩效的值)But,whataboutsteelproductions?Priceindexforaluminumproductions第二十三页，共三十一页。24TheexistingindexforsteelpriceindexProductsCodesProductsnamesPriceindexP0000SpecialmaterialsContactpricesP0001Domesticsteel/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*MySpicIndexPriceMySpicIndexPrice

isavaluethatAucksunsetdependingontheirexperience.（Myspic指数价是澳洋顺昌根据其经验得出的值。）第二十五页，共三十一页。26Otherindex——CRU第二十六页，共三十一页。ResultsandFindingsIndexExistingindexCRUMyspic…CPIofHomeApplicantsSPSS27第二十七页，共三十一页。FuturePlan28第二十八页，共三十一页。PlanforNextWeekDateTaskPeopleinvolved7.2FindsomeinformationaboutSPSS,andseeifitcanhelpustoanalysisthedataandcreatetheindex.Aaron,Jobeky,JoJo7.3Doapresentation;DiscusswiththeprofessorsaboutthemethodologypartandfigureoutwhetherSPSSisasuitabletool,ifnot,fixanothertool.Thenfindwhatkindofhelpwecangetandwhoaregoingtohelpus.Aaron,Jobeky,JoJoKevin,BennieProfessors7.4Learnhowtousethetool;Figureoutthekindsandquantityoftheneededdata;Usethetooltoanalysisthedata;Usethetooltocreatetheindexbasedonthea