Ukwakha umthamo we-BKG ku-Microsoft Excel

I-matrix ye-BCG ingenye yamathuluzi wokuhlaziya okukhangisa kakhulu. Ngesizo salo, ungakhetha isu elizuzisa kakhulu lokukhuthaza izimpahla emakethe. Ake sithole ukuthi yini i-matrix ye-BCG nokuthi uyayakha kanjani usebenzisa i-Excel.

I-BKG Matrix

I-matrix yeBoston Consulting Group (BCG) yisisekelo sokuhlaziywa kokugqugquzelwa kwamaqembu ezimpahla, esekelwe izinga lokukhula emakethe kanye nesabelo sabo kwingxenye ethile yamakethe.

Ngokwecebo lamatrik, yonke imikhiqizo ihlukaniswe yaba izinhlobo ezine:

  • "Izinja";
  • "Izinkanyezi";
  • "Izingane Eziyinkimbinkimbi";
  • "Izinkomo zemali".

"Izinja" - Lezi yimikhiqizo enesabelo samakethe amancane esigabeni esinezinga eliphansi lokukhula. Njengomthetho, ukuthuthukiswa kwabo kubhekwa njengento engafanele. Azihambisani nokukhiqiza, ukukhiqizwa kwazo kufanele kupheliswe.

"Izingane Eziyinkimbinkimbi" - izimpahla ezithatha isabelo esincane semakethe, kodwa endaweni ekhulayo ngokushesha. Leli qembu linamanye amagama - "amahhashi amnyama". Lokhu kubangelwa ukuthi banethemba lokuthuthukiswa okungenzeka, kodwa ngesikhathi esifanayo badinga izimali eziqhubekayo zezimali zokuthuthukiswa kwazo.

"Izinkomo zemali" - Lezi yizimpahla ezithatha isabelo esibalulekile semakethe ekhulayo. Ziletha imali ehlala njalo, eqinile ukuthi inkampani ingaqondisa ekuthuthukiseni. "Izingane Eziyinkimbinkimbi" futhi "Izinkanyezi". Ngokwazo "Izinkomo zemali" ukutshala izimali akusadingeki.

"Izinkanyezi" - Leli yiqembu eliphumelele kakhulu elinengxenye enkulu yamakethe emakethe ekhula ngokushesha. Lezi zimpahla kakade ziletha imali engenayo manje, kepha ukutshala izimali kuzo kuzovumela le mali ukuba yande ngisho nangaphezulu.

Umsebenzi we-matrix we-BCG ukucacisa ukuthi yiliphi kula maqembu amane angafakwa kulohlobo oluthile lomkhiqizo ukuze enze uhlelo lokuthuthukiswa kwalo okuqhubekayo.

Ukudala ithebula le-matrix ye-BKG

Manje, usebenzisa isibonelo sokhonkolo, sakha i-matrix ye-BCG.

  1. Ngenhloso yethu, sithatha izinhlobo ezingu-6 zezimpahla. Ngamunye wabo uzodinga ukuqoqa ulwazi oluthile. Lona ivolumu yokuthengisa yesikhathi samanje nesingaphambilini kwento ngayinye, kanye nenani lokuthengisa lomncintiswano. Yonke idatha eqoqwe ibhaliwe etafuleni.

  2. Emva kwalokho sidinga ukubala izinga lokukhula lemakethe. Ngenxa yalokhu, kubalulekile ukuhlukanisa ngento ngayinye yezimpahla ukubaluleka kokuthengisa kwenkathi yamanje ngokubaluleka kokuthengisa esikhathini esedlule.

  3. Okulandelayo, sibala ngomkhiqizo ngamunye isabelo samakethe esihlobene. Ukuze wenze lokhu, ukuthengiswa kwenkathi yamanje kufanele kuhlukaniswe ngokuthengisa kusuka kumncintiswaneni.

I-Charting

Ngemuva kokuthi itafula ligcwele idatha yokuqala nokubalwa, ungaqhubeka nokwakhiwa okuqondile kwe-matrix. Kulezi zinhloso ishadi elifanele kakhulu lebhola lebhola.

  1. Hambisa kuthebhu "Faka". Eqenjini "Amashadi" kwi-tape chofoza inkinobho "Okunye". Kulolu hlu oluvula, khetha isikhundla "Ibhola".

  2. Lolu hlelo luzozama ukwakha umdwebo, ngokuqoqa idatha njengoba ibona kufanelekile, kodwa, cishe, lo mzamo ngeke walungile. Ngakho-ke, sidinga ukusiza uhlelo lokusebenza. Ukuze wenze lokhu, chofoza ngakwesokudla endaweni yeshadi. Imenyu yomongo ivulwa. Khetha into kuwo "Khetha idatha".

  3. Iwindi yokukhetha imithombo yedatha ivula. Ensimini "Elements of the legend (imigqa)" chofoza inkinobho "Shintsha".

  4. Iwindi yokuhlela irowu ivuleka. Ensimini "Igama lomzila" faka ikheli eliphelele lexabiso lokuqala kusukela kukholomu "Igama". Ukuze wenze lokhu, setha isikhangiso ensimini bese ukhetha iseli elifanele kushidi.

    Ensimini X Izimiso ngendlela efanayo faka ikheli leseli lokuqala lekholomu "Yabelana Ngezimakethe Ezihlobene".

    Ensimini "Amanani Y" sifaka izixhumanisi zeselula yokuqala yekholomu "Izinga lokukhula kwezimakethe".

    Ensimini "Ubukhulu be-bubble" sifaka izixhumanisi zeselula yokuqala yekholomu "Isikhathi samanje".

    Ngemuva kokuthi yonke idatha engenhla ifakiwe, chofoza inkinobho "Kulungile".

  5. Senza umsebenzi ofanayo nazo zonke ezinye izimpahla. Uma uhlu luphelile, chofoza inkinobho efasiteleni lokukhetha umthombo wedatha "Kulungile".

Emva kwalezi zenzo, umdwebo uzokwakhiwa.

Isifundo: Indlela yokwenza umdwebo ku-Excel

Ukusetha kwe-Axis

Manje sidinga ukufaka ishadi ngendlela efanele. Ukuze wenze lokhu, kuzodingeka ulungise izinkomba.

  1. Iya kuthebhu "Ukuhlelwa" amaqembu amathebhu "Ukusebenza ngamashadi". Okulandelayo, chofoza inkinobho "I-Axis" futhi isinyathelo ngesinyathelo "I-axis ephezulu enezingqimba" futhi "Imingcele eyengeziwe ye-axis eyinhloko".

  2. Iwindi yepharamitha ye-axis ivuliwe. Ukuhlela kabusha ukushintshwa kwazo zonke izindinganiso kusuka kusikhundla "Ngokuzenzekelayo" ku "Fixed". Ensimini "Inani elincane" sabeka uphawu "0,0", "Inani eliphezulu" - "2,0", "Intengo yezigaba eziyinhloko" - "1,0", "Intengo yezigaba eziphakathi" - "1,0".

    Okulandelayo esigabeni sezilungiselelo "I-axis ephakathi" shintsha inkinobho endaweni "I-Axis ibaluleka" futhi ukhombise inani ensimini "1,0". Chofoza inkinobho "Vala".

  3. Khona-ke, konke kuthebhu elifanayo "Ukuhlelwa"futhi cindezela inkinobho "I-Axis". Kodwa manje sihamba ngesinyathelo I-Axis e-Vertical Main futhi "Imingcele eyengeziwe ye-axis eyinhloko".

  4. Ifasitela yezilungiselelo ze-axis ezivulekile zivula. Kodwa, uma i-axis enezingqimba zonke izilinganiso esizifakile zihlala njalo futhi azixhomeki emininingweni yokufakwayo, khona-ke i-axis eqondile ezinye zazo zizobalwa. Kodwa, ngaphezu kwakho konke, njengesikhathi sokugcina, silungiselela ukushintshwa esikhundleni "Ngokuzenzekelayo" esimweni "Fixed".

    Ensimini "Inani elincane" setha inkomba "0,0".

    Kodwa isibonakaliso ensimini "Inani eliphezulu" Kuzodingeka sibale. Kuzolingana nesabelo samakethe esihlobo esilinganisiwe esandiswe yi 2. Okusho ukuthi, esimweni sethu, kuyoba khona "2,18".

    Ngomthamo wesigaba esiyinhloko sithatha isilinganiso sesilinganiso samakethe esihlobene. Esimweni sethu, kunjalo "1,09".

    Isikhombisa esifanayo kufanele sifakwe ensimini "Intengo yezigaba eziphakathi".

    Ngaphezu kwalokho, sidinga ukushintsha elinye ipharamitha. Kuqoqo lezinhlelo "I-axis ene-horizontal intersects" shintshela inkinobho ukuma "I-Axis ibaluleka". Emkhakheni ofanelekile futhi faka isabelo samakethe esihlobo esilinganisiwe, okungukuthi, "1,09". Emva kwalokho, chofoza inkinobho "Vala".

  5. Khona-ke sibhalisa imigqa ye-matrix ye-BKG ngokuvumelana nemithetho efanayo ebonisa izikhala emidlalweni evamile. I-axis enezingqimba izobizwa ngegama. "I-Market share", futhi ngokuqondile - "Izinga lokukhula".

Isifundo: Indlela yokusayina i-axis eshadi ku-Excel

Ukuhlaziywa kwamatriki

Manje ungakwazi ukuhlaziya umthamo we-matrix. Imikhiqizo, ngokusho kwesimo sabo kwizixhumanisi zomthamo, ihlukaniswe ngezigaba kanje:

  • "Izinja" - ikota eliphansi kwesokunxele;
  • "Izingane Eziyinkimbinkimbi" - ikota eliphezulu elingakwesokunxele;
  • "Izinkomo zemali" - ikota elingaphansi kwesokudla;
  • "Izinkanyezi" - ikota langakwesokudla eliphezulu.

Ngakho, "Into yesi-2" futhi "Into yesi-5" bhekani "Izinja". Lokhu kusho ukuthi ukukhiqizwa kwabo kumele kuncishiswe.

"Into 1" ibhekisela kuwo "Izingane ezinzima" Lo mkhiqizo udinga ukwakhiwa, ukutshala izimali kukho kusho ukuthi, kodwa kuze kube manje awukoni ukubuyisela okufanele.

"Into yesi-3" futhi "Into 4" - kunjalo "Izinkomo zemali". Leli qembu lezimpahla alisadingi izimali ezibonakalayo, futhi imali evela ekusetshenzisweni kwayo ingaqondiswa ekuthuthukiseni kwamanye amaqembu.

"Into 6" kungokwaqembu "Izinkanyezi". Usevele enza inzuzo, kodwa izimali ezengeziwe zingandisa inani lemali engenayo.

Njengoba ubona, ukusebenzisa amathuluzi we-Excel wokwakha i-matrix ye-BCG akunzima kangako njengoba kungabonakala ekuqaleni. Kodwa isisekelo sokwakhiwa kufanele sibe yimininingwane yomthombo onokwethenjelwa.

Okuthunyelwe Popular

https://termotools.com zu.termotools.com © I-Excel 2024