Matenda a BCG ndi chimodzi mwa zida zowonetsera malonda. Ndi chithandizo chake, mungathe kusankha njira yopindulitsa kwambiri yopititsira patsogolo malonda pamsika. Tiyeni tipeze zomwe BCG matrix ili ndi momwe tingachigwiritsire ntchito pogwiritsa ntchito Excel.
Matenda a BKG
Mkwatibwi wa Boston Consulting Group (BCG) ndiwo maziko a kuyambitsidwa kwa magulu a katundu, omwe amachokera ku kukula kwa msika ndi gawo lawo ku gawo lina la msika.
Malinga ndi ndondomeko yamakono, zonsezi zagawidwa mu mitundu inayi:
- "Agalu";
- "Nyenyezi";
- "Zovuta Ana";
- "Ng'ombe za ndalama".
"Agalu" - Izi ndizo katundu omwe ali ndi gawo laling'ono la msika mu gawo limodzi ndi kukula kwachepa. Monga lamulo, chitukuko chawo chimaonedwa kuti ndi chopanda phindu. Iwo sakuwongolera, kupanga kwawo kuyenera kuchepetsedwa.
"Zovuta Ana" - katundu wogulitsa gawo laling'ono la msika, koma mu gawo lomwe likukula mofulumira. Gulu ili lilinso ndi dzina lina - "akavalo wakuda". Izi zili choncho chifukwa chakuti ali ndi chiyembekezo chokhala ndi chitukuko, koma panthawi imodzimodziyo amafuna ndalama zowonjezera ndalama za chitukuko chawo.
"Ng'ombe za ndalama" - Izi ndi katundu amene ali ndi gawo lalikulu la msika wosafooka. Amabweretsa ndalama zowonjezereka, zomwe kampani ikhoza kutsogolera chitukuko. "Zovuta Ana" ndi "Nyenyezi". Iwo enieni "Ng'ombe za ndalama" malonda sakufunikanso.
"Nyenyezi" - Iyi ndi gulu lopambana kwambiri lomwe liri ndi gawo lalikulu la msika mu msika wofulumira. Zogulitsa izi zakhala zikubweretsa ndalama zambiri panopo, koma ndalama zomwe zidzatengere zidzathandiza kuti ndalamazi ziwonjezereke.
Ntchito ya matenda a BCG ndi kudziwa kuti magulu anayi angapangidwe ndi mtundu wina wa mankhwala kuti akonze njira yowonjezera.
Kupanga tebulo pa matrix a BKG
Tsopano, pogwiritsa ntchito chitsanzo cha konkire, timapanga matrix a BCG.
- Kwa cholinga chathu, timatenga mitundu 6 ya katundu. Pa aliyense wa iwo adzafunika kupeza mfundo zina. Ili ndilo bukhu la malonda pa nthawi yamakono komanso yapitalo pa chinthu chilichonse, komanso ndi malonda a mpikisano. Deta yonse yosonkhanitsidwa idalembedwa patebulo.
- Pambuyo pake tiyenera kuwerengera kukula kwa msika. Pachifukwa ichi, m'pofunikira kugawikana ndi chinthu chilichonse cha malonda mtengo wa malonda kwa nthawi yomweyi ndi mtengo wa malonda kwa nthawi yapitayi.
- Kenaka, ife timawerengera mtengo uliwonse pa gawo la msika. Kuti tichite izi, malonda a nthawi yino ayenera kugawidwa ndi malonda kuchokera kwa mpikisano.
Charting
Pambuyo patebulo liri ndi deta yoyamba ndi yowerengedwa, mukhoza kupita kumalo osuntha a matrix. Pazinthu izi ndi tchati choyenera kwambiri chojambulira.
- Pitani ku tabu "Ikani". Mu gulu "Zolemba" pa tepicho dinani batani "Zina". M'ndandanda yomwe imatsegula, sankhani malo "Buluu".
- Pulogalamuyi idzayesa kupanga chithunzi, posonkhanitsa deta momwe ikuwonekera, koma, mwinamwake, kuyesera kumeneku sikulakwika. Choncho, tidzathandiza kuthandizira. Kuti muchite izi, dinani pomwepa pa tchati. Mndandanda wamakono umatsegulidwa. Sankhani chinthu mmenemo "Sankhani deta".
- Zithunzi zosankhidwa zosankha zosankha zimatsegula. Kumunda "Zithunzi za nthano (mizera)" dinani pa batani "Sinthani".
- Mawindo otseguka amatsegula. Kumunda "Dzina Loyamba" lowetsani mndandanda wamtheradi wa mtengo wapatali kuchokera ku chigawocho "Dzina". Kuti muchite izi, yikani mtolo mmunda ndikusankha selo yoyenera pa pepala.
Kumunda Makhalidwe a X mofananamo lowetsani adiresi ya selo yoyamba ya chigawocho "Msika Wolimbana".
Kumunda "Y" timalowa makonzedwe a selo yoyamba ya chigawocho "Kukula kwa Msika".
Kumunda "Kukula kwa bululu" timalowa makonzedwe a selo yoyamba ya chigawocho "Nthaŵi Yamakono".
Pambuyo pa deta yonseyi ilipo, dinani pa batani "Chabwino".
- Timachita ntchito yofanana ndi katundu wina aliyense. Pamene mndandandawo watsirizika, dinani batani muzenera zosankha zosankha "Chabwino".
Zitatha izi, chithunzichi chidzamangidwa.
Phunziro: Momwe mungapangire chithunzi mu Excel
Chikhazikitso chakhala
Tsopano tikufunika kuyika tchati molondola. Kuti muchite izi, muyenera kusintha masikiti.
- Pitani ku tabu "Kuyika" magulu a matabu "Kugwira Ntchito ndi Mphatso". Kenako, dinani pakani "Axis" ndi sitepe ndi sitepe "Msolo waukulu" ndi "Zowonjezerapo magawo a mzere waukulu wazitali".
- Fenje lazitali lazitali likuyambidwa. Kubwezeretsanso kusintha kwa machitidwe onse kuchokera pa malo "Odziwika" mu "Okhazikika". Kumunda "Mtengo wochepa" timayika chizindikiro "0,0", "Mtengo Wapatali" - "2,0", "Mtengo wa magawo akulu" - "1,0", "Mtengo wa magawano apakati" - "1,0".
Kenaka mu gulu la machitidwe "Mzere wodutsa wodutsa" sankhani batani ku malo "Kutenga mtengo" ndiwonetseni mtengo mu munda "1,0". Dinani pa batani "Yandikirani".
- Ndiye, pokhala onse omwe ali pa tabu imodzi "Kuyika"Bwerezerani batani kachiwiri "Axis". Koma tsopano tikuyenda pang'onopang'ono Mawindo Atsitsi Otchuka ndi "Zowonjezerapo magawo a chingwe chachikulu chowonekera".
- Filamu yowonongeka yowongoka imatsegula. Koma, ngati pazowunikira zogwirizana zonse zomwe tazilemba ndizowonjezereka ndipo sizidalira deta yowunikira, ndiye kuti zowonongeka zina ziyenera kuwerengedwa. Koma, pamwamba pa zonse, monga nthawi yotsiriza, timakonzanso zosintha kuchokera pa malo "Odziwika" mu malo "Okhazikika".
Kumunda "Mtengo wochepa" ikani chizindikiro "0,0".
Koma chizindikiro chakumunda "Mtengo Wapatali" tidzayenera kuwerengera. Zidzakhala zofanana ndi chiwerengero cha mgwirizano wa mgwirizano wowonjezeredwa ndi 2. Izi zikutanthauza kuti tidzakhala "2,18".
Pa mtengo wa chigawo chachikulu timagwiritsa ntchito gawo limodzi la msika. Kwa ife, izo ziri "1,09".
Chizindikiro chomwecho chiyenera kulowa mkati "Mtengo wa magawano apakati".
Kuwonjezera apo, tikufunika kusintha gawo lina. Mu gulu la machitidwe "Mzere wokhala ndizitsulo" Sinthani kusintha kwa malo "Kutenga mtengo". Mu malo oyeneranso mulowetsani gawo la msika wofanana, ndiko kuti, "1,09". Pambuyo pake, dinani pa batani "Yandikirani".
- Kenaka tikusindikiza ziphaso za matrix a BKG molingana ndi malamulo omwewo omwe amalembetsa zizindikiro pamadzinso wamba. Mzere wosakanizidwa udzatchulidwa. "Gawo la msika", ndi ofukula - "Chiwerengero cha Kukula".
Phunziro: Momwe mungasayire tchati chachitsulo mu Excel
Kusanthula matrix
Tsopano mungathe kufufuza zomwe zimayambitsa matrix. Malonda, malingana ndi malo awo pamakonzedwe a matrix, amagawidwa m'magulu motere:
- "Agalu" - kumunsi kotsika;
- "Zovuta Ana" - kumtunda kotsiriza;
- "Ng'ombe za ndalama" - kuchepetsa gawo labwino;
- "Nyenyezi" - kotsiriza kotsiriza.
Choncho, "Chinthu 2" ndi "Chinthu 5" tanthauzo "Agalu". Izi zikutanthauza kuti kupanga kwawo kuyenera kuchepetsedwa.
"Chinthu 1" akutanthauza "Ana ovuta" Chida ichi chiyenera kukonzedwa, kuikapo ndalama kumatanthawuza, koma mpaka pano sichipereka kubwerera komweko.
"Chinthu 3" ndi "Chinthu 4" - ndizo "Ng'ombe za ndalama". Gulu la katunduwa silifunanso ndalama zofunikira, ndipo ndalama zomwe zimachokera kumagwiritsidwe ntchito zitha kuyendetsedwa ndi magulu ena.
"Chinthu 6" ndi wa gulu "Nyenyezi". Ali kale kupanga phindu, koma ndalama zowonjezera zingawonjezere kuchuluka kwa ndalama.
Monga momwe mukuonera, kugwiritsa ntchito zida za Excel kupanga kachipangizo ka BCG sizowoneka ngati zovuta poyang'ana poyamba. Koma maziko a zomangamanga ayenera kukhala deta yolondola.
