Gina matattarar BCG a Microsoft Excel

Matrix ɗin BCG shine ɗayan shahararrun kayan aikin binciken kayan kasuwanci. Tare da taimakonsa, zaku iya zaɓar dabarun da za su ci riba don inganta kaya a kasuwa. Bari mu bincika menene matattarar ta BCG da yadda ake gina ta ta amfani da Excel.

BCG matrix

Matrix na kungiyar tuntuba ta Boston (BKG) shine tushen bincike game da haɓaka ƙungiyoyin kayayyaki, wanda ya danganta da darajar haɓakar kasuwar da rabonsu a wani yanki na kasuwa.

Dangane da dabarun matrix, dukkanin samfuran sun kasu kashi hudu:

• "Karnuka";
• "Taurari";
• "Yara masu wahala";
• "Cows Cash".

"Karnuka" - Waɗannan samfurori ne waɗanda ke da ƙananan rabon kasuwa a cikin ƙananan girma. A matsayinka na mai mulkin, ana ganin ci gaban su bai dace ba. Ba su yanke jiki ba, ya kamata a magance abubuwan da suke samarwa.

"Yara masu wahala" - kayan da suka mamaye karamin rabo na kasuwa, amma a cikin sashi mai haɓaka. Wannan rukunin kuma yana da wani suna - "dawakai masu duhu". Wannan shi ne saboda gaskiyar cewa suna da begen samun ci gaba, amma a lokaci guda suna buƙatar saka hannun jari na dindindin don ci gaban su.

"Cows Cash" - Waɗannan sune kayayyaki waɗanda ke mamaye babban rabo daga kasuwa mai rauni. Suna kawo tsayayyen kudin shiga, wanda kamfanin zai iya jagorantar ci gaba. "Yara masu wahala" da "Taurari". Kansu "Cows Cash" ba a bukatar saka hannun jari.

"Taurari" - Wannan shine rukuni mafi nasara tare da babban rabo a kasuwar haɓaka mai sauri. Waɗannan samfuran tuni suna samar da mahimmancin kudaden shiga, amma saka hannun jari a cikinsu zai ƙara samun wannan kudin shiga.

Aikin BCG matrix shine a tantance wanne daga cikin rukunnan rukunoni hudu wani nau'in samfurin za'a iya sanya shi don aiwatar da dabarun cigaba.

Irƙira tebur don matrix na BCG

Yanzu, dangane da wani takamaiman misali, muna gina matattarar BCG.

1. Don manufarmu, muna ɗaukar nau'ikan kaya 6. Ga kowane ɗayansu zai zama dole a tattara wasu bayanai. Wannan shine girman siyarwa don lokacin da yake ciki da wanda ya gabata ga kowane kaya, haka kuma gwargwadon siyarwar mai gasa. Duk bayanan da aka tattara an shigar dasu a cikin tebur.



2. Bayan haka, muna buƙatar lissafa ƙimar haɓakar kasuwa. Don yin wannan, kuna buƙatar rarraba tallace-tallace don lokacin na yanzu ta ƙimar tallace-tallace don lokacin da ya gabata ga kowane samfurin.



3. Bayan haka, muna yin lissafi ga kowane samfurin rabo na kasuwar dangi. A saboda wannan, ƙimar siyarwa don lokacin ta yanzu dole ne ya raba ta hanyar siyewar siyarwar mai gasa.

Yarjejeniya

Bayan teburin ya cika da fara da bayanan da aka ƙididdige, zaku iya ci gaba zuwa aikin kai tsaye na matrix. Don waɗannan dalilai, alamar kumfa ta fi dacewa.

1. Matsa zuwa shafin Saka bayanai. A cikin rukunin Charts a kan kintinkiri, danna maballin "Wasu". Cikin jeri dake buɗe, zaɓi matsayin "Bubble".



2. Shirin zai yi ƙoƙarin gina ginshiƙi ta ɗaukar bayanan kamar yadda ya ga ya dace, amma da alama wannan yunƙurin ba daidai bane. Sabili da haka, muna buƙatar taimakon aikace-aikacen. Don yin wannan, danna sauƙin dama akan yankin ginshiƙi. Tushen mahallin yana buɗewa. Zaɓi abu a ciki "Zaɓi bayanai".



3. Window ɗin zaɓi na tushen data buɗe. A fagen "Abubuwa na almara (layuka)" danna maballin "Canza".



4. Ana buɗe taga canza layi. A fagen "Suna na jere" shigar da cikakken adireshin farkon darajar daga shafi "Suna". Don yin wannan, saita siginan kwamfuta a cikin filin kuma zaɓi tantanin da ya dace a kan takardar.

   A fagen "Ka'idodin X" kamar yadda muke shigar da adireshin sel na farko na shafi "Kasuwar dangi kasuwa".

   A fagen "Y dabi'u" saka abubuwan tsarawa na sel na farko "Yawan Kasuwar Kasuwa".

   A fagen "Girma masu girman jiki" saka abubuwan tsarawa na sel na farko "Lokaci na yanzu".

   Bayan an shigar da duk bayanan da ke sama, danna maɓallin "Ok".



5. Mun gudanar da irin wannan aiki ga duk sauran kaya. Lokacin da aka kammala jerin shirye-shiryen gaba daya, sannan a cikin taga abinda aka zaba a data, danna maballin "Ok".

Bayan waɗannan matakan, za a gina ginshiƙi.

Darasi: Yadda ake yin zane a Excel

Saitunan Axis

Yanzu muna buƙatar daidaita tsakiyar ginshiƙi. Don yin wannan, kuna buƙatar sake saita iska.

1. Je zuwa shafin "Layout" shafin rukuni "Aiki tare da ginshiƙi". Bayan haka, danna maballin Axara kuma tafi ta abubuwa kai tsaye "Babban madaidaiciyar giciye" da "Aramarin sigogi na babban tudun kwance".



2. Ana kunna sigogi na axis. Mun sake sauya yanayin dabi'u daga matsayin "Kai" a ciki "Kafaffen". A fagen "Mafi qarancin darajar" saita mai nuna alama "0,0", "Matsakaicin darajar" - "2,0", "Farashin manyan rarrabuwa" - "1,0", "Farashin tsaka-tsakin rarrabuwa" - "1,0".

   Na gaba a rukunin saiti "A kwance axis ya tsallaka" kunna maɓallin zuwa wuri Darajar Axis kuma a cikin filin yana nuna ƙimar "1,0". Latsa maballin Rufe.



3. To, kasancewa a cikin wannan shafin "Layout"danna maɓallin sake Axara. Amma yanzu muna tafiya mataki-mataki "Babban madaidaicin axis" da "Aramarin sigogi na ƙasan madaidaiciya".



4. Wurin saita taga madaidaiciya yana buɗewa. Amma, idan ga tsattsauran tsinkayen duk sigogin da muka shigar suna tsayayye kuma basa dogaro da shigarwar, to don layin tsaye a tsaye wasu daga cikin su dole sai a lissafa. Amma, da farko, kamar lokacin ƙarshe, muna sake sauya juyawa daga matsayin "Kai" a matsayi "Kafaffen".

   A fagen "Mafi qarancin darajar" saita mai nuna alama "0,0".

   Kuma anan shine alamar a fagen "Matsakaicin darajar" za mu yi lissafi. Zai zama daidai da matsakaiciyar rakiyar kasuwar da aka ninka ta hanyar 2. Wannan shine, a cikin yanayinmu zai kasance "2,18".

   Don farashin babban rabo muna ɗaukar matsakaicin mai nuna ɗan kasuwar sikelin. A cikin lamarinmu, daidai yake da "1,09".

   Alamar guda ɗaya yakamata a shigar a filin "Farashin tsaka-tsakin rarrabuwa".

   Bugu da kari, ya kamata mu canza siga guda daya. A cikin rukunin saiti "A kwance yake a kwance" matsar da canji zuwa wuri Darajar Axis. A cikin filin daidaitawa kuma mun sake shiga matsakaicin mai nuna alamar kasuwar kasuwar dangi, watau, "1,09". Bayan haka, danna maɓallin Rufe.



5. Sannan muna sa hannu a cikin tsarin ta na BCG bisa ga ka'idodi iri ɗaya wanda muke sanya hannu a cikin bututun hanyoyin al'ada. Za'a kira bututun kwance "Rarraba Kasuwa"kuma a tsaye - Matsakaicin Girma.

Darasi: Yadda za a sa hannu a ginshiƙi ginshiƙi a cikin Excel

Nazarin Matrix

Yanzu zaku iya bincika sakamakon matrix. Kayan, gwargwadon matsayinsu akan daidaitawar matrix, sun kasu kashi biyu kamar haka:

• "Karnuka" - ƙananan kwata na hagu;
• "Yara masu wahala" - kwata na hagu na sama;
• "Cows Cash" - ƙananan kwata na dama;
• "Taurari" - kwata na dama

Ta wannan hanyar "Samfurin 2" da "Samfura 5" dangantaka da Ga karnukan. Wannan yana nufin cewa dole ne a dakatar da aikin da suke yi.

"Samfurin 1" yana nufin "Yara masu wahala" Dole ne a haɓaka wannan samfurin ta hanyar saka hannun jari a ciki, amma har ya zuwa yanzu ba ya ba da dawowar da ta dace.

"Samfura 3" da "Samfura 4" hakane "Cows Cash". Wannan rukunin kayayyaki ba ya buƙatar manyan masu saka jari, kuma abin da aka samu daga sayarwar su ana iya zuwa ga haɓaka wasu rukunoni.

"Samfura 6" na kungiya ne "Taurari". Ya rigaya ya sami riba, amma ƙarin saka hannun jari na iya haɓaka adadin kuɗin shiga.

Kamar yadda kake gani, yin amfani da kayan aikin kayan aikin Excel don gina matattarar ta BCG ba ta da wahala kamar yadda ake tsammani da farko. Amma tushen ginin ya zama ingantaccen bayanan tushe.