BCG Matrix: muenzaniso kuvakwa uye ongororo "Eksele" uye "Shoko"

Enterprises kuti pave nezvinhu kana kupa basa guru-siyana, kumanikidzwa kuita kuenzaniswa kuongorora nekambani zvebhizimisi zviumbu kusarudza pamusoro hurumende ichiisa inivhesitimendi mari. Maximum Investments zvemari anowana pokutanga nzvimbo boka, iyo Anowisira kunonyanyisa purofiti. Kuderedza chigadzirwa Portfolio anoshumira BCG chizvaro, muenzaniso uri kuvakwa uye ongororo kunobatsira telemarketers zvisarudzo pamusoro pokumuka kana liquidation wekambani mabhizimisi dzakabatana.

Pfungwa uye bhuku rinotsanangura kuti BCG Matrix

Paumbwe-refu Kurangarira boka, yakarurama kuparadzirwa mari pakati zvakamisa hurongwa nekambani inokosha Portfolio kunoitika kuburikidza kushandisa mudziyo akasikwa pachishandiswa Boston Consulting Group. Saka zita chiridzwa - kukura-mugove chizvaro. Muenzaniso rokuvaka hurongwa inobva kutsamira ari hama musika mugove waro kukura unodiwa.

Makwikwi pakati nenhumbi vakaratidza inoratidza hama mugove kumusika uye kunonoka chakarurama runoonekwa H. High akabatana, kukosha rinopfuura rimwe.

Kukwezva, kukura mumusika kunoratidzwa kukosha mwero kukura kwayo. Data nokuti parameter ichi vari rakachengetedzwa pamusoro chizvaro pakati akabatana Y.

Mushure pakuverenga ari hama inorwara uye mwero kuwedzera mumusika nerimwe zvakanaka, izvo zvinoita boka, mashoko ari kune nehurongwa inonzi BCG chizvaro (muenzaniso hurongwa ichakurukurwa pazasi).

quadrants of chizvaro

Apo zvinhu mitengo akaparadzirwa ne BKG womuenzaniso, SKUs mumwe inowira rimwe quadrants mana chizvaro. Mumwe quadrant ane zita yayo uye kurumbidza zvinogadzirisa. Pasi tafura, kureva zvakafanana Mapato sezvo BCG chizvaro, muenzaniso kuvakwa uye ongororo usina kuitwa pasina ruzivo zvinoitwa nomumwe mapazi.

zvinhu ongororo

MUENZANISO kuvaka uye ongororo BCG chizvaro hazviiti pasina kutsunga kwenhumbi anogona munyaya fungidziro wegadziriro.

1. Mitsetse Bhizimisi dzisina chokuita nepedyo. Izvi zvinogona kusanganisira: Hairdressing uye kugadzirwa dzemagetsi kettles.
2. Assortment of boka kambani, yaitengeswa pamusika chete. Somuenzaniso, Apartments kutengeswa, Apartments nokuda rendi, dzimba kutengeswa uye zvakafanana. Zvokuti chaiye wemunda pamusika.
3. Goods Classified iyoyo boka. Somuenzaniso, kugadzirwa posudohozyaystvennyh zvigadzirwa regirazi, simbi kana zvedongo.

BCG Matrix: muenzaniso zvakagadzirwa uye ongororo iri Excel

Kuti tizive chigadzirwa upenyu kutenderera uye inokosha kuronga kuti yokutengesa mabasa ebhizimusi ichakurukurwa muenzaniso zvekunyepera Data kuti kunzwisisa nyaya nyaya.

Danho rokutanga kuunganidza muunganidzwa mashoko ari tafura vakaongorora zvigadzirwa. oparesheni Izvi nyore, unofanira tafura asike "Eksele" uye kupinda Data mariri nokuda kambani.

Danho rechipiri - dzemaitirwe zviri pamusika zviratidzi: mwero kukura uye hama mugove. Kuti aite izvi, masero vanofanira kumisa tafura kunyora zvokuimba nokuda otomatiki kukarukureta:

• Muchitokisi E3, inova kukosha mwero musika kukura, kuti nzira anotarira seizvi: = C3 / B3. Kana zvashanduka chaizvo grade nzvimbo, saka zvakakosha kuti kuderedza ikakuruma kudzika maviri.
• The nzira akafanana nechimwe chigadzirwa.
• In F9 Sero mutoro hama mugove pamusika, ari nzira anotarira seizvi: = C3 / D3.

Mugumisiro izere saka tafura.

Maererano tafura, kuti kutengeswa zvinhu zvokutanga ikaurawa 37% muna 2015 uye 3 chigadzirwa yakawedzera 49%. Makwikwi uye hama musika mugove muchikwata kwenhumbi rokutanga dzakaderera pane makwikwi ne 47%, asi wechitatu uye chechina chigadzirwa pamusoro 33% uye 26% azvaitwa.

graphical kuratidzwa

Zvichienderana patafura data, mumwe chizvaro pakati BCG, imwe kuvakwa muenzaniso umo Eksele kunobva kusarudza dhayagiramu ari mhando "sefuro".

Mushure paunosarudza mhando chati sokuti chinhu munda, zvakarurama-tinya kuti uchida kuvhura hwindo kuti kusarudza mashoko vazadze chizvaro munguva yemberi.

Achiwedzera nhamba, muzadze paro mashoko. Mumwe dzakatevedzana - chibereko zvavakanga vachida kuita. date wokutanga chigadzirwa achava zvinotevera:

1. Name musara - A3 muchitokisi.
2. X akabatana - muchitokisi F3.
3. Y akabatana - E3 muchitokisi.
4. Bubble Kukura - muchitokisi C3.

Izvi zvinoita (nokuda kwezvose mana) kukura-mugove chizvaro, muenzaniso pakuvaka vamwe zvigadzirwa yakafanana wokutanga.

Change namasanhu urongwa

Kana chati yakanyatsotsanangura anokwidziridza zvigadzirwa zvose, Uchaiputsa akakwidzwa quadrants. delimitation ichi vamire X-akabatana, US vanoda chete kuchinja otomatiki muzviruva namasanhu. By nekudzvanya negonzo musi hunyambiri scale, kusarudza "Format" Tab kuruboshwe uye pamusoro emadziro akadana hwindo "Format Selection".

Changing hunyambiri akabatana:

• Shoma ukoshi anoendeswa "0".
• Kunonyanyisa ukoshi - avhareji SDT zvikawanda ne 2: (0,53 + 0,56 + 1,33 + 1,26) / 4 = 0,92; 0,92 * 2 = 1,84.
• Basic uye zvenguva kupesana - ndiwo avhareji SDT.
• The mharadzano pamwe akabatana X - avhareji SDT.

Kuchinja chinjikira akabatana:

• Shoma ukoshi anoendeswa "0".
• The kunonyanyisa ukoshi chinobviswa "2".
• The nzira yasara - a "1".

The zvichiguma dhayagiramu - iri kukura-mugove chizvaro. Muenzaniso zvakagadzirwa uye kuongorora muenzaniso akadaro achapindura Zvinokosha kuvandudzika musanganiswa wekambani dzakabatana.

vakasaina

Kuti kupedzisa kuvaka BCG kwava kuti pave siginicha namasanhu uye quadrants. Unofanira kusarudza chati uye anoshanda Muchikamu "marongerwo" chepurogiramu. Kushandisa icon "rakanyorwa", cursor angasvikira wokutanga quadrant, uye kuperetera zita rake. nzira iyi inodzokororwa pazvinhu zvinotevera zvitatu chizvaro.

Kuti vagadzire chati rokuremekedza, riri mu nechepakati BCG muenzaniso anosarudzwa chete zita Icon anotevera kubva "Labels."

Anotevera kubva kuruboshwe kuenda kurudyi pasi "there» Excel Toolbar 2010 sezvo muzvirevo akanyorwa akasika akabatana zvisiri. Somugumisiro, BCG chizvaro, muenzaniso kuvakwa muna Excel kuti zvakurukurwa riri sezvinotevera:

Analysis SKUs

Kuvaka chati kwakavakirwa musika mugove waro kukura exchange - iri hafu mhinduro dambudziko nzira dzinokosha yokutengesa. Yakaoma Kududzirwa zvakarurama zvokudya nenhumbi pamisika uye kusarudza kwohumwe zviito (nzira) kuti kukura kwavo kana liquidation. BCG chizvaro ongororo muenzaniso:

Goods №1, iri mapazi yakaderera dziine musika kukura uye hama mugove. Izvi kutengeserana chinhu akatotanga akapfuura ayo upenyu kutenderera uye purofiti kambani kana vabhabhatidzwa. In chaicho mamiriro ezvinhu, zvingava zvakakodzera kuti vaite rimwe hwakadzama kuongorora zvinhu zvakadaro uye kuona zvinhu zvavo nokusunungurwa pasina zvavo Implementation kwemubairo. Tichingotarisa, boka iri chigadzirwa nani siya uye akasunungura pfuma kutungamirirwa kukura vaizotibata zvikomborero.

Goods №2 ndiwo musika inokura asi kunoda upfumi kuwedzera makwikwi. Zviri aizobudirira chigadzirwa.

Product №3 riri yepamusoro hwavo upenyu kutenderera. Izvi mhando SKUs ane mukuru SDT uye musika kukura. Anodei yakawedzera mari kune mamwe mabhizimisi chairema wekambani inobereka chigadzirwa ichi, zvakaunza vachiwana mari.

Goods №4 - batsiro jenareta. Cash kwakaitwa kambani kubva kutengeswa muchikwata ichi musanganiswa dzakabatana vanokurudzirwa kupa kuti kukura №2 nenhumbi 3.

nzira

Muenzaniso zvakagadzirwa uye kuongorora BCG chizvaro inosimudzira kusunungurwa nzira idzi ina.

1. Kuwedzera musika mugove. Ichi budiriro ronga unogamuchirwa zvinhu zviri mapazi ose "Wild Cat" nechinangwa Kutama dzavo quadrant "Stars."
2. Ndichengetedze musika mugove. Kuwana mudanga mari kubva "mari yemombe" inokurudzirwa kushandisa nzira iyi.
3. Kurasikirwa musika mugove. Tikashandisa zano kuti simba "mari yemombe", "Imbwa" uye unpromising "Wild Cat".
4. Liquidation - nzira kuti "Imbwa" uye unpromising "nekatsi dzemusango".

BCG Matrix: muenzaniso kuvakwa muShoko

The nzira rokuvaka yokutevedzera mu "Shoko" ndiyo nguva yakawanda uye kwete zvakajeka. muenzaniso ichakurukurwa maererano zvaishandiswa kuvaka chizvaro "Eksele".

Pane mbiru "Rate kuti musika kukura", vane tsika dzaona sezvinotevera: (1 date kukura prices) * 100%.

Anovaka tafura mitsara mina neshongwe. Chokutanga Mbiru unobatanidzwa musero rimwe chete uye wakasainwa se "The kumhanya musika kukura." Ari mbiru dzasara unofanira chokubatanidza paInternet vaviri vaviri kuitira kuti vagamuchire sero guru miviri pamusoro petafura uye nechepasi misara miviri vasara. Sezvaratidzwa.

Pakudzika mutsetse kuchaita batanidza "rushomanana musika mugove", pamusoro payo - anokoshesa zvishoma pane kana kupfuura 1. Achitaura umboo tafura (okupedzisira maviri mbiru nezvazvo), anotanga tsanangudzo quadrants vezvinhu. Somuenzaniso, chigadzirwa wokutanga, SDT = 0.53, inova shoma pane mumwe, zvichireva nzvimbo yayo ichava kana wokutanga kana chechina quadrant. Kumhanya ikure pamusika - akaipa ukoshi -37%. Sezvo mwero kuwedzera kukosha chizvaro inokamukana muna 10%, asi inonanga kuverengwa zvinhu 1 anopinda quadrant wechina. The chete kunoitika pamwe vasara kuparadzirwa SKUs. Mugumisiro vanofanira uwirirane dhayagiramu "Excel".

BCG Matrix: muenzaniso zvakagadzirwa uye kuongorora anosarudza kuti panzvimbo wekambani chigadzirwa mitsetse uye zviyero zvinobatanidzwa pakuita zvisarudzo pamusoro hurumende ichiisa pfuma zvavakanga vachida kuita.