business question and need support to help me learn.
⦁ Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
⦁ All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).
Requirements: 1200 words
College of Administrative and Financial Sciences
Assignment-2
MGT425-Spreadsheet Decision Modeling
Due Date: 11/11/2023 (End of Week-11) @ 23:59
For Instructor’s Use only
Instructions – PLEASE READ THEM CAREFULLY
The Assignment must be submitted on Blackboard (WORD format only) via allocated folder.
Assignments submitted through email will not be accepted.
Students are advised to make their work clear and well presented; marks may be reduced for poor presentation. This includes filling your information on the cover page.
Students must mention question number clearly in their answer.
Late submission will NOT be accepted.
Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).
Submissions without this cover page will NOT be accepted.
Course Learning Outcomes-Covered
Assignment Instructions:
Log in to Saudi Digital Library (SDL) via University’s website
On first page of SDL, choose “English Databases”
From the list find and click on EBSCO database.
In the Search Bar of EBSCO find the following article:
Title: A Rough Multi-Criteria Decision-Making Approach for Sustainable Supplier Selection under Vague Environment: A Case Study.
Author: Huiyun Lu , Shaojun Jiang , Wenyan Song, Xinguo Ming
Date: 26 July 2018
Assignment Questions: (Marks 15)
Read the above case study and answer the following Questions:
Question 1: Explain the decision-making approach discussed in this case study (250-300 words) (2.5-Marks).
Question 2: Why supplier selection is a typical multi-criteria decision-making process involving subjectivity and vagueness? (250-300 words) (2.5-Marks).
Question 3: Discuss the Sustainable supplier selection that is required for manufacturing companies. (250-300 words) (2.5-Marks).
Question 4: What is your opinion about this study and how it is connected to course and beneficial for you? (250-300 words) (2.5-Marks).
Answers:
1
2
3
4
ArticleARoughMulti-CriteriaDecision-MakingApproachforSustainableSupplierSelectionunderVagueEnvironmentHuiyunLu1,ShaojunJiang2,WenyanSong1,3,*andXinguoMing41SchoolofEconomicsandManagement,BeihangUniversity,Beijing100191,China;lhybuaa@163.com2SchoolofInformationEngineering,HandanUniversity,Handan056005,China;hh8582@163.com3BeijingKeyLaboratoryofEmergencySupportSimulationTechnologiesforCityOperations,BeihangUniversity,Beijing100191,China4SchoolofMechanicalEngineering,ShanghaiJiaoTongUniversity,Shanghai200240,China;xgming@sjtu.edu.cn*Correspondence:songwenyan@buaa.edu.cn;Tel.:+86-010-8231-3693Received:13June2018;Accepted:23July2018;Published:26July2018Abstract:Withthegrowingawarenessofenvironmentalandsocialissues,sustainablesupplychainmanagement(SSCM)hasreceivedconsiderableattentionbothinacademiaandindustry.Supplierselectionplaysanimportantroleinthesuccessfulimplementationofsustainablesupplychainmanagement,becauseitcaninfluencetheperformanceofSSCM.Sustainablesupplierselectionisatypicalmulti-criteriadecision-makingprobleminvolvingsubjectivityandvagueness.Althoughsomepreviousresearchesofsupplierselectionusefuzzyapproachestodealwithvagueinformation,ithasbeencriticizedforrequiringmuchprioriinformationandinflexibilityinmanipulatingvagueness.Moreover,thepreviousmethodsoftenomittheenvironmentalandsocialevaluationcriteriainthesupplierselection.Tomanipulatetheseproblems,anewapproachbasedontheroughsettheoryandELECTRE(ELiminationEtChoixTraduisantlaREalité)isdevelopedinthispaper.ThenovelapproachintegratesthestrengthofroughsettheoryinhandlingvaguenesswithoutmuchprioriinformationandthemeritofELECTREinmodelingmulti-criteriadecision-makingproblem.Finally,acasestudyofsustainablesupplierselectionforsolarair-conditionermanufacturerisprovidedtodemonstratetheapplicationandpotentialoftheapproach.Keywords:sustainability;supplierselection;vagueinformation;roughsettheory;ELECTRE1.IntroductionManufacturingcompaniestodaycannotignoresustainabilityconcernsintheirbusinessbecauseofincreasedenvironmentalawarenessandecologicalpressuresfrommarketsandvariousstakeholders[1–3].Sustainablesupplierselectioniscriticaltoenhancesupplychainperformanceandcompetitiveadvantage[4].Thisisbecausesuppliersplayanimportantroleinimplementingsustainablesupplychainmanagement(SSCM)practicesandinachievingsocial,environmentalandeconomicgoals[5].Inthisrespect,sustainablesupplierselectionbasedonthesustainabilitycriteria(economic,environmentalandsocial)isacriticalstrategicdecisionforSSCM[6,7]anditrequirestobefurtherexploredmethodicallytohelpachievesustainabilityofthewholesupplychain.Althoughmanyresearchersexplorethetopicofsupplierselection,thestudyonthesustainablesupplierselectionisstillintheearlystage.Moststudiesofsustainablesupplierselectionhaveonlyfocusedontheeconomicandenvironmentalaspectsofsustainability.Thesocialaspectofsustainabilityisoftenomittedinthedecision–makingforsupplierselection.Besides,theproblemofsupplierselectionisatypicalmulti-criteriadecision-making(MCDM)problem.ThedecisionmakersalwaysSustainability2018,10,2622;doi:10.3390/su10082622www.mdpi.com/journal/sustainability
Sustainability2018,10,26222of20needtomaketrade-offsbetweenconflictingcriteriatoselectthemostsuitablesupplier.Itisdifficulttoobtainaccuratejudgmentsofdecisionmakersintheprocessofsupplierevaluation,becausesupplierselectioninvolveslargeamountoflinguisticinformationandsubjectiveexpertknowledgethatareusuallyimprecise,vagueoreveninconsistent.Todealwiththisproblem,fuzzymethodsareoftenusedtoselectsuppliers.However,thefuzzymethodsneedmuchprioriinformation(e.g.,pre-setfuzzymembershipfunction)whichmayincreasetheworkloadofdecisionmakers[8,9].Thepreviousapproachesalsolackaflexiblemechanismtodealwiththesubjectiveevaluationsofexperts[10,11].Therefore,tomanipulatetheaboveproblemsinsustainablesupplierselection,thispaperproposesanovelintegratedgroupdecisionmethodbasedontheELECTRE(ELiminationEtChoixTraduisantlaREalité)approachandroughsettheoryinvagueenvironments.Differentwithmethodsbasedonthecompensatingaccumulationprinciple(e.g.,TOPSIS(TechniqueforOrderPreferencebySimilaritytoanIdealSolution)),theELECTREmethodisbasedonaprecedencerelationanditcanmeetdifferentevaluationrequirementsbydefiningundifferentiatedthreshold,strictsuperiorthresholdandrejectionthresholdandthus,ithasstrongerflexibilityindecision–makingofsupplierselection.Furthermore,theroughnumberoriginatedfromtheroughsettheorycanflexiblyreflecttheuncertaintyindecision–makingprocessofsupplierselectionanditdoesnotrequiremuchprioriinformation.Inthisrespect,theproposednovelapproachintegratesthemeritofELECTREinmodelingmulti-criteriadecision-makingproblemandthestrengthofroughsettheoryinhandlingvaguenesswithoutmuchprioriinformation.Thepaperisorganizedasfollows:Section2presentsaliteraturereviewofsupplierselection,ELECTREmethodandroughset.Section3developsanintegratedroughELECTREmethodforsustainablesupplierselection.IntheSection4,acasestudyofsustainablesupplierselectionforsolarair-conditionermanufacturerisusedtovalidatethefeasibilityandeffectivenessofthemethodandacomparativeanalysisisalsoconductedinthissection.InSection5,conclusionsandfutureresearchdirectionsarepresented.2.LiteratureReview2.1.EvaluationCriteriaforSustainableSupplierSelectionSupplierselectiondecisionsareimportantformostofmanufacturingfirms,becausearightsuppliercaneffectivelyimprovetheeconomicbenefitofthemanufacturingfirm[12,13].Inthepast,economiccriteriaareusuallyusedforsupplierselection.Theenvironmentandsocialcriteriaareoftenoverlooked.However,withthedevelopmentofsustainablesupplychainmanagement(SSCM),boththeresearchersandpractitionersarepayingmoreattentiontoenvironmentcriteriaandsocialcriteriainsupplierselection[14].Theyfinditisimportanttoincorporatingthesocialandenvironmentcriteriaintothesupplierselectionprocess[15,16].Thispapersummarizesthesustainablesupplierselectioncriteriafromtheeconomic,environmentandsocialaspects.ThedetailsoftherecognizedsustainablesupplierselectioncriteriawiththeirsourcesanddescriptionsaresummarizedinTable1.Table1.Sustainablesupplierselectioncriteria.SustainableSupplierSelectionCriteriaDescriptionsEconomiccriteriaQuality[17,18]Productqualityandreliabilitylevelguaranteedbysupplier.Response[5]Theabilityfortimelyresponse,completingordersontimeandreliabledelivery.Cost[19]Purchasingcost,holdingcost,orderingcostandsupplier’sbiddingpriceoftheproduct.
Sustainability2018,10,26223of20Table1.Cont.SustainableSupplierSelectionCriteriaDescriptionsEnvironmentalcriteriaEnvironmentalmanagementsystem(EMS)[20,21]Asetofsystematicprocessesandpracticesreducingenvironmentalimpacts.Carbonemission&resourceconsumption[22,23]Greenhousegasemissionsinproducing,transporting,usingandrecyclingtheproductandtheresource(e.g.,energy,powerandwater)consumptionofthecompany.Designfortheenvironment[14,24]Designreducingtheoverallimpactofaproduct,processorserviceonhumanhealthandenvironment.Greenimage[17]Theimageofcompanyinthegreenaspect,whichcanbeimprovedbyadoptingenvironmentalfriendlyproductsorimplementing‘green’program.Itcanaffectthepurchasingtrendofcustomers,marketshareandtherelationshipwithstakeholders.SocialcriteriaProductliability[25]Beingresponsibleforcustomerhealthandsafety,providingproductsandserviceswithhighqualityandadvertisingbasedonrealinformation.Employeerightandwelfare[26,27]Treatingemployeewithdignityandrespectandmaintainingacultureofsecurity,nondiscriminationandequality.Payingtoemployeeshallcomplywithallapplicablewagelaws.Socialcommitment[27]Involvinginlocalcommunity,education,jobcreation,healthcareandsocialinvestment.2.2.TheMethodsofSustainableSupplierSelectionSelectingtherightsupplierstosetupoptimalsuppliernetworkscanhelptoreducepurchasingcostsandincreasetheefficiencyoftheprocurementlogisticsprocess[28].Supplierselectionisamulti-criteriadecision-makingproblem.Therearesomepapersconcerningsustainable(orgreen)suppliers.DaiandBlackhurst(2012)integrateAnalyticalHierarchyProcess(AHP)withQualityFunctionDeployment(QFD)forsustainablesupplierselection[18].Theapproachconsistsoffourstages,thatis,linkingcustomerrequirementswiththefirm’ssustainabilitystrategy,determiningthesustainablepurchasingcompetitivepriority,determiningevaluationcriteriaofsustainablesupplierandevaluatingthesustainablesuppliers.HsuandHu(2009)developamethodforselectingsupplierswithemphasisonissuesofhazardoussubstancemanagementbasedonAnalyticNetworkProcess(ANP)[29].LiuandHai(2005)provideamethodcalledvotinganalytichierarchyprocessforsupplierselection[30].AlthoughAHP/ANPmethodsaremorepopularinthefieldofthesupplierselection,theyarealwaysusedtodeterminetherelativeimportanceweightingsofcriteriaandsub-factorsmerely.Theyneedtobeintegratedwithotherdecision–makingtechniques.Besides,duetothenumberofpairwisecomparisonsthatneedtobemade,thenumberofsupplierselectionsispracticallylimitedintheAHP/ANP-basedsupplierselectionmethods.Moreover,theconventionalAHP/ANPmethodsdonotconsiderthevaguenessofdecision–makinginformation.Tomanipulatetheincreasingnumberofthesuppliers,dataenvelopmentanalysis(DEA)isaprevalentapproachusedinsupplierselection.ThisisbecauseDEAcaneasilyhandlehugenumberofsupplierswithlittlemanagerialinputandoutputrequired.Kuoetal.(2012)presentagreensupplierselectionmethodusingananalysisnetworkprocessaswellasdataenvelopmentanalysis(DEA)[31].ANPwhichisabletoconsidertheinterdependencybetweencriteriareleasestheconstraintofDEAthattheuserscannotsetupcriteriaweightpreferences.WuandBlackhurst(2009)proposeanaugmentedDEAapproachforsupplierevaluationandselection[32].Sevklietal.(2007)developanewsupplierselectionmethodbyembeddingtheDEAapproachintoAHPmethodology[33].Theyconcludethat
Sustainability2018,10,26224of20theintegratedmethodoutperformstheconventionalAHPmethodforsupplierselection.However,DEA-basedsupplierselectionmethodshavesomedrawbacks.Thepractitionersmaybeconfusedwithinputandoutputcriteria.Besides,DEAisalinearprogrammingtomeasuretherelativeefficienciesofhomogenousdecision–makingunits(DMUs).Anefficientsuppliergeneratingmoreoutputswhilerequiringlessinputmaybenotaneffectivesupplier.Furthermore,theconventionalDEAalsodoesnotconsiderthesubjectivityandvaguenessinthedecision–makingprocess.Besidethemulti-criteriadecision–makingmethod,someresearchersuseheuristicoptimizationapproachestoselectpropersuppliers.BasnetandLeung(2005)developanincapacitatedmixedlinearintegerprogrammingwhichminimizestheaggregatepurchasing,orderingandholdingcostssubjecttodemandsatisfaction[34].Theysolvetheproblemwithanenumerativesearchalgorithmandaheuristicprocedure.Veresetal.(2017)proposeaheuristicmethodforoptimizingsupplychainincludingintelligenttransportationsystems(ITS)basedvehiclesfortransportationoperationsproblems[35].Tosolvethemulti-productmulti-periodinventorylotsizingwithsupplierselectionproblem,Cárdenas-Barrónetal.(2015)proposeaheuristicalgorithmbasedonreduceandoptimizeapproach(ROA)andanewvalidinequality[36].Unfortunately,theheuristicoptimizationapproachesomitthevaguenessandsubjectivityinthedecision–making,whichmayleadtoinaccurateresultsofsupplierselection.Inordertodealwiththeimpreciseorvaguenatureoflinguisticassessmentinevaluationandselectionofsuppliers,fuzzysettheoryisintroducedintotheconventionalapproaches.Consideringtimepressureandlackofexpertiseinsustainablesupplierselection,BüyüközkanandÇifçi(2011)developedamethodbasedonfuzzyanalyticnetworkprocesswithingroupdecision-makingschemaunderincompletepreferencerelations[37].Tomanipulatethesubjectivityofdecisionmakers’evaluations,Amindoustetal.(2012)developanewrankingmethodonthebasisoffuzzyinferencesystem(FIS)forsustainablesupplierselectionproblem[6].Azadniaetal.(2015)developedanintegratedmethodbasedonrule-basedweightedfuzzyapproach[38],fuzzyanalyticalhierarchyprocessandmulti-objectivemathematicalprogrammingforsustainablesupplierselectionandorderallocation.Grisietal.(2010)proposeafuzzyAHPmethodforgreensupplierselectionusingaseven-stepapproach[39].Fuzzylogicisusedtoovercomeuncertaintycausedbyhumanqualitativejudgments.ELECTRE(ELiminationEtChoixTraduisantlaREalité)methodsareabletomakeasuccessfulassessmentofeachalternativebasedonknowledgeoftheconcordanceanddiscordancesetsforallpairsofalternatives.Theyareoftenusedtoselectrightsuppliers[40].Thus,Sevkli(2010)proposesafuzzyELECTREforsupplierselection[41].Althoughthefuzzymethodscandealwiththeimpreciseorvaguenatureoflinguisticassessment,itrequiresprioriinformation(e.g.,pre-setmembershipfunction).Moreover,thefuzzymethodsalwaysconvertlinguisticvariablesintofuzzynumberswithfixedintervals.Therefore,computationresultsusuallydonotexactlymatchinitiallinguisticterms,whicheasilycauselossofinformationandlackofprecisioninthefinalresults.Althoughthesemethodshavebroughtgreatinsightstosupplierselectionliterature,mostofthemlackflexiblemechanismstohandlethesubjectivityandthevaguenessofdecisionmakers’assessments.Althoughsomefuzzymethodsofsupplierselection(e.g.,fuzzyELECTRE)considerthevaguenessindecision–makinginformation,theyrequiremuchprioriinformation(e.g.,pre-setfuzzymembershipfunction)whichconsumesmuchtimeandeffortofmanagers.Moreover,thepreviousfuzzyapproachesusefuzzynumberwithfixedintervaltoindicatetheuncertainty,whichcannotidentifythechangesindecisionmakers’judgments.Forthosereasons,thereisaclearneedforanewformaldecisionsupportmethodologyforthesustainablesupplierselectionundervagueenvironment.3.TheProposedMethodThemainobjectiveofthispaperistoproposeanintegratedmethodforsustainablesupplierselectionbasedonroughsettheoryandELECTRE.Besides,vaguenessmanipulationisalsoconsideredintheproposedapproach.AflowchartoftheproposedapproachisshowninFigure1.
Sustainability2018,10,26225of20Figure1.TheframeworkofroughELiminationEtChoixTraduisantlaREalité(ELECTRE).3.1.DeterminetheSupplierEvaluationCriteriaandTheirWeightsStep1:determinetheevaluationcriteriaofsustainablesuppliersFirstofall,apanelofexpertwhoareknowledgeableaboutsupplierselectionisestablished.Thegrouphaskdecision-makers(i.e.,D1,D2,…,Dk)whoareresponsiblefordeterminingandtherankingeachcriterion(i.e.,C1,C2,…,Ck).Forthesustainablesupplierselection,threeaspectsweshouldtakeintoconsideration.Theyareeconomiccriteria,environmentalcriteriaandsocialcriteria.Step2:determinetheweightsfortheevaluationcriteriaofsustainablesuppliersExpertshavetheirownindividualexperienceandknowledge.Therefore,theymayhavedifferentcognitivevaguenessforalternativesandcriteria.LetusassumeajudgmentsetP=fp1,p2,,phgwithhorderedjudgments,inthemannerofp1p2ph.LetpibearandomjudgmentinthesetPanddisdefinedasthedistanceofP,whered=ph p1.ThelowerapproximationApr(pi)andtheupperapproximationApr(pi)ofthejudgmentpicanbeidentifiedasfollows.Lowerapproximationset:Apr(pi)=[pj2Ppjpi, pi pjd (1)Upperapproximationset:Apr(pi)=[pj2Ppjpi, pj pid (2)RN(pi)=hpLi,pUii(3)
Sustainability2018,10,26226of20WherepLi=mq Õxij(4)pUi=nq Õyij(5)wherexijandyijaretheelementsofthelowerapproximationsetApr(pi)andtheupperapproximationsetApr(pi)ofpirespectivelyandmandnarethenumberofelementsinthetwosetsrespectively.Fordifferentcriteria,expertsmightgivedifferentweights.Usewkjindicatetheweightofjthcriterionwithkthexpert.WiththeFormulas(1)–(5)dj=MAXnwmj wnjo(6)Aprwmj=[nwnj2Pwnjwmj,wmj wnjdjo(7)Aprwmj=[nwnj2Pwnjwmj,wnj wmjdjo(8)Limwkj=mq Õxj(9)Limwkj=nq Õyj(10)wherexjandyjaretheelementsofthelowerapproximationsetApr(wkj)andtheupperapproximationsetApr(wkj)ofwkjrespectivelyandmandnarethenumberofelementsinthetwosetsrespectively.RNwkj=hLimwkj,Limwkji=hwkLj,wkUji(11)wLj=sssÕk=1wkLj(12)wUj=sssÕk=1wkUj(13)Wecouldgettheweightofeachcriterionwj=hwLj,wUji.3.2.EvaluatetheSustainableSupplierswiththeProposedRoughELECTREStep1:ConstructtheroughdecisionmatrixApartfromthedecisionfortheweightofcriteria,theexpertsshouldgivetheassessmentofthealternativeswithconsiderationofallthecriteria.Let’suserkijtorepresentthekthexpertscoresonjthcriterioninithalternative.Thefollowingisthescoringmatrix.Aggregateallthescoringmatrix.Rk=0BBBB@rk11rk12rk1nrk21rk22rk2n…………rkm1rkm2rkmn1CCCCA(14)eR=0BBBB@fr11fr12fr1nfr21fr22fr2n…………frm1frm2grnm1CCCCA(15)erij=nr1ij,r2ij,,rhijo(16)
Sustainability2018,10,26227of20Determinetheroughmatrixwithexpertratings.d=maxrmij rnij(17)Aprrmij=[nrnij2Prnijrmij,rmij rnijdo(18)Aprrmij=[nrnij2Prnijrmij,rnij rmijdo(19)Limrkij=mq Õxij(20)Limrkij=nq Õyij(21)wherexijandyijaretheelementsofthelowerapproximationsetApr(rkij)andtheupperapproximationsetApr(rkij)ofrkijrespectivelyandmandnarethenumberofelementsinthetwosetsrespectively.RNrkij=Lim,Lim=hrkLij,rkUiji(22)RN erij=nhr1Lij,r1Uiji,hr2Lij,r2Uiji,,hrsLij,rsUijio(23)RN erij=hrLij,rUiji(24)rLij=sssÕk=1rkLij,rUij=sssÕk=1rkUij(25)R=0BBBBBB@rL11,rU11rL12,rU12rL1n,rU1nrL21,rU21rL22,rU22rL2n,rU2n…………rLm1,rUm1rLm2,rUm2rLmn,rUmn1CCCCCCA(26)Then,wenormalizetheroughdecisionmatrixwiththeweightofcriteria.sij=rijwj=hrLijwLj,rUijwUiji=hsLij,sUiji(27)tij=”sLijCj,sUijCj#=htLij,tUiji(28)WhereCj=MAXnsUijo(29)T=0BBBBBB@tL11,tU11tL12,tU12tL1n,tU1ntL21,tU21tL22,tU22tL2n,tU2n…………tLm1,tUm1tLm2,tUm2tLmn,tUmn1CCCCCCA(30)
Sustainability2018,10,26228of20Step2:ConstructtheroughconcordancematrixanddiscordancematrixInthisstep,weconstructsomefieldforthecomparisonamongallthealternatives.Wecomparedifferentalternativesintwoaspects.Oneistheconcordanceandtheotheristhediscordance.Constructtheconcordanceanddiscordancematrices.CSpq=Fjtpjtqj (31)DSpq=Fjtpj