Gina matrix BKG cikin Microsoft Excel

Matakan BCG matrix yana daya daga cikin kayan aikin bincike na shahararrun mashahuri. Tare da taimakonsa, zaka iya zaɓar hanyoyin da aka fi dacewa wajen inganta kaya akan kasuwa. Bari mu gano abin da BCG matrix yake da yadda za a gina ta ta amfani da Excel.

BKG Matrix

Rubutun Ƙungiyar Consultation na Birnin Boston (BCG) shine tushen dalili na bunkasa kungiyoyi na kaya, wanda ya danganci karuwar kasuwannin da kuma rabonsu a wani yanki na kasuwa.

Bisa ga tsarin matrix, duk samfurori sun kasu kashi hudu:

• "Dogs";
• "Stars";
• "Yara masu wahala";
• "Cash shanu".

"Dogs" - Waɗannan su ne samfurori waɗanda suke da ƙananan kasuwa a cikin sashi da ƙananan girma. A matsayinka na mai mulki, an yi la'akari da ci gaban su ba tare da dadewa ba. Ba su da kullun, ba za a rage yawan su ba.

"Yara masu wahala" - kaya da ke da ƙananan kasuwa, amma a cikin ɓangaren hanzari. Wannan rukuni yana da wani suna - "dawakai duhu". Wannan shi ne saboda gaskiyar cewa suna da damar samun ci gaba, amma a lokaci guda suna buƙatar zuba jarurruka masu tsafta don ci gaban su.

"Cash shanu" - Wadannan kayayyaki ne wadanda suke da ragamar ɓangare na kasuwa mai girma. Suna kawo daidaitattun kuɗi wanda kamfanin zai iya kai tsaye zuwa ci gaba. "Yara masu wahala" kuma "Stars". Su kansu "Cash shanu" ba a buƙatar saka jari.

"Stars" - Wannan shi ne rukuni mai ci gaba tare da kasuwa mai mahimmanci kasuwa a kasuwa mai girma. Wadannan kayayyaki sun kawo karuwar kudaden shiga a yanzu, amma zuba jari a cikinsu zai ba da damar samun kudin shiga don ƙara karuwa.

Ayyukan BCG matrix shine don sanin wane daga cikin waɗannan kungiyoyi guda huɗu za a iya dangana da takamaiman nau'in samfurin don yin aiki da wata hanya don inganta ci gaba.

Samar da tebur don matakan BKG

Yanzu, ta yin amfani da misalin misalin, muna gina matakan BCG.

1. Don manufarmu, muna ɗaukar nau'ikan iri iri. Ga kowanensu zai buƙaci tattara wasu bayanai. Wannan shine ƙaramin tallace-tallace don halin yanzu da kuma lokacin da ya gabata don kowanne abu, kazalika da girman tallace-tallace na mai yin gasa. Duk bayanan da aka tattara an rubuta a cikin tebur.



2. Bayan haka muna buƙatar lissafin ƙimar kasuwancin kasuwa. Saboda wannan, wajibi ne a raba kowane abu na kaya da adadin tallace-tallace na wannan zamani ta wurin darajar tallace-tallace don lokacin da suka gabata.



3. Na gaba, muna lissafin kowane samfurin da kasuwar tallace-tallace. Don yin wannan, tallace-tallace don halin yanzu yana buƙatar raba ta tallace-tallace daga mai yin gasa.

Shafi

Bayan an cika teburin da farko da lissafin bayanai, zaka iya ci gaba da gina matrix. Ga waɗannan dalilai mafi dacewar ma'auni mai mahimmanci.

1. Matsa zuwa shafin "Saka". A rukuni "Sharuɗɗa" a kan tef danna maballin "Sauran". A cikin jerin da ya buɗe, zaɓi matsayi "Bubble".



2. Shirin zaiyi kokarin gina zane, bayan tattara bayanai kamar yadda ya dace, amma, mafi mahimmanci, wannan ƙoƙarin zai zama kuskure. Saboda haka, muna bukatar mu taimakawa aikace-aikacen. Don yin wannan, danna-dama a yankin tashar. Yanayin mahallin ya buɗe. Zaɓi abu a ciki "Zaɓi bayanai".



3. Maɓallin zaɓi na bayanan bayanai ya buɗe. A cikin filin "Abubuwa na labari (layuka)" danna maballin "Canji".



4. Gyara madadin gyara yana buɗewa. A cikin filin "Sunan Row" shigar da cikakken adireshin darajar farko daga shafi "Sunan". Don yin wannan, saita siginan kwamfuta a filin kuma zaɓi tantanin da ya dace akan takardar.

   A cikin filin X halaye Hakazalika shigar da adreshin farkon cell na shafi "Kasancewar Kasashen Gida".

   A cikin filin "Y daraja" mun shigar da daidaituwa na tantanin farko na shafi "Girman Tattalin Kasuwa".

   A cikin filin "Bubble masu girma" mun shigar da daidaituwa na tantanin farko na shafi "Yanayin Layi".

   Bayan duk an shigar da bayanan da aka sama, danna kan maballin "Ok".



5. Muna gudanar da irin wannan aikin don duk kayan kaya. Lokacin da jerin suka kammala, danna maɓallin a cikin maɓallin zaɓi na bayanan bayanai "Ok".

Bayan wadannan ayyukan, za a gina zane.

Darasi: Yadda za a yi zane a Excel

Saiti aiki

A yanzu muna buƙatar ci gaba da zane daidai. Don yin wannan, za ku buƙaci daidaita matakan.

1. Jeka shafin "Layout" kungiyoyin kungiyoyi "Yin aiki tare da Sharuɗan". Kusa, danna maballin "Axis" da kuma mataki zuwa mataki "Main axis axis" kuma "Ƙarin sigogi na babban maɓalli na kwance".



2. An kunna maɓallin saiti axis. Sake dawo da canje-canjen duk dabi'u daga matsayi "Auto" in "Tabbatacce". A cikin filin "Ƙananan darajar" mun sanya alama "0,0", "Ƙimar Darajar" - "2,0", "Farashin babban rarraba" - "1,0", "Farashin matakan tsaka-tsaki" - "1,0".

   Gaba a cikin ƙungiyar saitunan "Tsakanin tsaye yana tsaye" canza maɓallin zuwa matsayi "Axis darajar" kuma nuna darajar a cikin filin "1,0". Danna maballin "Kusa".



3. Sa'an nan, kasancewa a cikin wannan shafin "Layout"sake danna maɓallin "Axis". Amma yanzu muna tafiya zuwa mataki Babban Ainihin Aiki kuma "Ƙarin sigogi na babban wuri na tsaye".



4. Tsarin saiti na tsaye yana tsaye. Amma, idan a kan iyaka da aka kwance dukan sigogi da muka shigar sun kasance masu tsayi kuma ba su dogara ne akan bayanan shigarwa ba, to, saboda ɗakin da yake tsaye akwai wasu da za a lasafta su. Amma, a sama da duka, kamar lokaci na ƙarshe, muna sake gyara sauyawa daga matsayi "Auto" a matsayi "Tabbatacce".

   A cikin filin "Ƙananan darajar" saita alama "0,0".

   Amma mai nuna alama a fagen "Ƙimar Darajar" za mu yi lissafi. Zai zama daidai da matsakaicin kasuwar dangin da aka haɓaka ta 2. Wato, a cikin yanayinmu, zai kasance "2,18".

   Don farashin babban bangare mun dauki matsakaicin kasuwar dangi. A yanayinmu, shi ne "1,09".

   Dole ne a shigar da wannan alamar a filin "Farashin matakan tsaka-tsaki".

   Bugu da kari, muna buƙatar canza wani matsayi. A cikin ƙungiyar saitunan "Tsakanin zane-zane a fili" Swap da canza zuwa matsayi "Axis darajar". A cikin filin da ya dace ya sake shiga kasuwar kasuwar dangi, wato, "1,09". Bayan haka, danna maballin "Kusa".



5. Sa'an nan kuma mu sanya alamomi na rubutun BKG bisa ka'idoji guda daya da ke nuna alamomi a kan zane-zane. Za a ambaci asalin da ke cikin kwance. "Kasashen kasuwar", kuma a tsaye - "Girman Juyayi".

Darasi: Yadda za a sa hannu a hasashen chart a Excel

Matrix bincike

Yanzu zaka iya nazarin matrix sakamakon. Kasuwanci, bisa ga matsayinsu a kan halayen matrix, an raba su cikin kungiyoyi kamar haka:

• "Dogs" - ƙananan hagu na hagu;
• "Yara masu wahala" - hagu na hagu na sama;
• "Cash shanu" - ƙananan hamsin kwata;
• "Stars" - kwata na hagu na sama.

Ta haka ne, "Mataki na 2" kuma "Mataki na 5" koma zuwa "Dogs". Wannan yana nufin cewa dole ne a rage girman su.

"Mataki na 1" yana nufin "Yara masu wahala" Wannan samfurin yana buƙatar ci gaba, zuba jari a cikin ma'anar, amma har ya zuwa yanzu ba shi da dawowa.

"Mataki na 3" kuma "Mataki na 4" - yana da "Cash shanu". Wannan rukuni na kaya ba ta buƙatar zuba jari mai mahimmanci, kuma kudaden shiga daga aiwatarwarsu za a iya tsarawa ga ci gaba da wasu kungiyoyi.

"Mataki na 6" yana da ƙungiyar "Stars". Ya riga yana samun riba, amma ƙarin zuba jarurruka na iya kara yawan adadin kuɗi.

Kamar yadda kake gani, yin amfani da kayan aikin Excel don gina matakan BCG ba matsala ba kamar yadda zai iya gani a kallo. Amma dalilin ginawa ya kamata ya zama tushen bayanan tushen asali.