Yadda za a gina hutu-ma a cikin fice

Ofaya daga cikin ƙididdigar tattalin arziki da kuɗin tattalin arziki na kowane kamfani shine ma'anar hutu ta. Wannan mai nuna alama yana nuna hakan, tare da girman samarwa, ayyukan kungiyar za su zama masu tsada kuma ba zai sha wahala ba. Tsarin Exceloned ya ba masu amfani tare da kayan aikin da suka sauƙaƙa ayyana wannan mai nuna alama kuma yana nuna sakamakon da aka samu da fasaha. Bari mu ga yadda ake amfani da su lokacin da kuka sami matsala ta hanyar takamaiman misali.

Karya ko da

Asalin hatsar-har ma yana da ma'anar girma shine don nemo adadin yawan samarwa, wanda girman riba (asara) zai zama sifili. Wato, tare da karuwa cikin kunnen samarwa, kamfanin zai fara nuna riba na aiki, kuma tare da ragi - ba shi da izini.

Lokacin da ƙididdige karya-ko ya zama dole a fahimci cewa duk farashin za a iya raba farashin ta dindindin da masu canji. Groupungiyar farko ba ta dogara da girman samarwa kuma ba ta da kyau. Wannan na iya haɗawa da ƙarar albashi zuwa ma'aikatan gudanarwa, Kudin haya, rage abubuwan da aka kayyade dukiyar, da sauransu. Amma farashin mai canzawa ne kai tsaye akan yawan samfuran da aka samar. Wannan, da farko, ya kamata ya haɗa da farashi don sayen kayan abinci da kuma masu ɗaukar makamashi, saboda haka ana ɗaukar irin wannan farashi don nuna ɓangaren masana'antu.

Yana tare da rabo na akai-akai da kuma farashin mai canzawa wanda ake danganta da ma'anar hutu. Kafin nasarar wani adadin samarwa, farashi mai yawa sune adadi a cikin farashin kayayyaki, amma tare da karuwa a cikin yawan rabon da aka samar yana faduwa. A matakin hutu - ko da farashin samarwa da kudin shiga daga siyar da kaya ko sabis daidai yake. Tare da kara samun karuwa, kamfanin ya fara samun riba. Shi ya sa yake da mahimmanci don sanin yawan samarwa wanda ya faru har ma ana samun lokacin hutu.

Lissafin karya-ma

Lissafta wannan mai nuna alamar amfani da kayan aikin Excel shirin, da kuma gina jadawalin inda zaku ambaci hutu. Don aiwatar da lissafin, za mu yi amfani da tebur da irin wannan bayanan farko na kamfanin an nuna:

• Farashin farashi na yau da kullun;
• Farashin mai canzawa kowane yanki na samarwa;
• Tasanin aiwatar da kayayyaki.

Don haka, za mu lissafa bayanai dangane da dabi'un da aka ƙayyade a cikin tebur a hoton da ke ƙasa.

1. Gina sabon tebur dangane da teburin tushe. Shafi na farko na sabon tebur shine adadin kaya (ko kuma ƙungiyoyi) masana'antu masana'antu. Wato, lambar layin zai nuna adadin ƙayyadaddun kayan. A cikin shafi na biyu akwai girman farashin farashi mai sauƙi. Zai zama 25,000 a cikin layinmu a duk layuka. A shafi na uku - jimlar adadin farashi mai sauƙi. Wannan darajar ga kowane layi zai zama daidai da adadin kayan kayan, wato, abin da ke cikin sel mai dacewa na farkon shafi, na 2000 rubles.

   A shafi na huɗu akwai jimlar kuɗi. Asusun sel na layin da ya dace na shafi na biyu da na uku. A shafi na biyar akwai cikakken kudin shiga. Ana kirga farashin kayan aiki (4500 p.) Zuwa adadin tara, wanda aka nuna a cikin layin da suka dace. A cikin shafi na shida akwai mai nuna alamar riba. Ana kirga shi ta hanyar rage yawan kudin shiga na gaba ɗaya (shafi na 5) yana da adadin (shafi na 4).

   Wato, a cikin wadancan layin da ke cikin sel na ƙarshe na shafi na ƙarshe zai zama ƙimar ƙimar, a cikin waɗanda ke nuna alamar kasuwanci, kuma a cikin inda yake Zai zama tabbatacce - ribar alama a cikin ayyukan kungiyar.

   Don haske, cika layin 16. Tsarin farko na farko zai zama adadin kaya (ko kuma ƙungiyoyi) daga 1 zuwa 16. Hukakwa yana cike da abubuwan da aka lissafa a sama.



2. Kamar yadda kake gani, ana faruwa da lokacin hutu a kan samfurin 10. A wannan lokacin ne jimlar kudin shiga (45,000 rubles) daidai yake da kashe cumilatiative, da tarawar net shine 0. Tuni fara da sakin kayan sha ɗaya, kamfanin yana nuna ayyukan dauko. Don haka, a cikin lamarinmu, hutu-ko da mawuyacin alama shine raka'a 10, kuma a cikin kudi - 45,000 rubles.

Kirkirar hoto

Bayan an ƙirƙiri teburin a cikin abin da hutu ana lissafta shi, zaku iya ƙirƙirar jadawalin inda za a nuna wannan tsarin gani. Don yin wannan, dole ne mu gina zane tare da layin biyu da ke nuna farashi da samun kudin shiga na masana'antar. A ƙarshen waɗannan layin guda biyu kuma za a sami hutu. A kan wannan zane na wannan zane, yawan kayayyaki za su kasance, kuma a cikin y axis y zaren.

1. Je zuwa shafin "Saka" shafin. Danna maballin "tabo" wanda aka sanya a kan tef a cikin "kayan Toolbar" toshe. Muna da zabi na nau'ikan zane-zane. Don magance matsalarmu, nau'in "hange tare da kyawawan wurare da alamomi" sun dace sosai, don haka danna wannan sashin jerin. Kodayake, idan kuna so, zaku iya amfani da wasu nau'ikan zane-zane.



2. Kafin Amurka ta buɗe wani yanki na ginshiƙi. Ya kamata ku cika shi da bayanai. Don yin wannan, danna maɓallin linzamin kwamfuta na dama a kewayen yankin. A menu na aiki, zaɓi bayanan "Zaɓi data ..." matsayi.



3. An ƙaddamar da taga taga. A cikin hagu na hagu akwai toshe "abubuwa na almara (sahu)". Danna maɓallin "Additi", wanda aka sanya shi a cikin katangar da aka ƙayyade.



4. Muna da taga da ake kira "Canza jere". A ciki, dole ne mu ƙayyade abubuwan da ke daidaita wuraren da bayanan da za'a gina su. Da farko, za mu gina jadawalin da za'a nuna jimlar farashin. Saboda haka, a cikin "sunan suna" filin, ka shigar da "babban farashi" daga maballin.

   A cikin filin "X darajar", saka daidaiton bayanan da ke ciki a cikin "yawan kayayyaki". Don yin wannan, saita siginan kwamfuta, sannan kuma ta hanyar samar da shirin maɓallin linzamin kwamfuta, zaɓi shafi da ya dace na tebur a kan takardar. Kamar yadda muke gani, bayan wadannan ayyukan, za a nuna su a cikin taga canza jere.

   A cikin filin nan mai zuwa "V dabi'u", nuna "jimlar farashin" Lambobi, wanda bayanan da muke buƙata suke. Muna aiki a kan algorithm na sama: mun sanya siginan kwamfuta a cikin filin kuma mun haskaka sel na shafi muna buƙatar tare da hagu na linzamin kwamfuta. Za'a nuna bayanai a fagen.

   Bayan da aka ƙayyade ƙayyadaddun magidano, an aiwatar da maɓallin "Ok", sanya shi a cikin ƙananan taga.



5. Bayan wannan, yana dawowa ta atomatik zuwa taga hanyar zaɓi ta hanyar. Hakanan yana buƙatar danna maɓallin "Ok".



6. Kamar yadda kake gani, bin wannan, jadawalin jimlar farashin kamfanin zai bayyana akan takardar.



7. Yanzu dole ne mu gina layin samun kudin shiga na gaba daya na kamfanin. Don waɗannan dalilai, tare da maɓallin linzamin kwamfuta na dama akan yankin zane mai dacewa, wanda ya riga ya ƙunshi layin jimlar ƙungiyar. A cikin menu na mahallin, zaɓi Bayanai "Zaɓi Data ..." matsayi.



8. Tagane don zaɓin tushen bayanai wanda kuma sake kuke so ku danna maɓallin ƙara ƙara.



9. Karamin taga na canza jerin abubuwan buɗewa. A cikin "sunan suna" filin wannan lokacin muna rubuta "kudin shiga".

   A cikin filin "darajar x" filin, da daidaitawar shafi "adadin kayayyaki" ya kamata a yi. Muna yin hakan ta wannan hanyar da muka ɗauka lokacin gina layin jimlar.

   A cikin filin "V VIMES", daidai nuna jerin abubuwan "Tasirin samun kudin shiga".

   Bayan aiwatar da waɗannan ayyukan, danna maɓallin "Ok".



10. Ganon zaɓi na zaɓi taga ta latsa maɓallin "Ok".



11. Bayan haka, layin samun kudin shiga zai bayyana akan jirgin saman takarda. Wannan shine batun shiga cikin layin samun kudin shiga gaba ɗaya kuma jimillar farashi zai zama hutu - ko da ma'anar.

Don haka, mun cimma manufofin kirkirar wannan jadawalin.

Darasi: Yadda ake yin ginshiƙi a cikin hijira

Kamar yadda kake gani, gano wani lamari ya dogara ne da tabbacin adadin kayayyaki da aka samar, wanda jimlar zata kasance daidai da kudin shiga gaba daya. Wannan ana nuna wannan zane a cikin ginin farashi da layin samun kudin shiga, kuma a cikin neman hanyar shiga cikin, wanda zai zama hutu-ma ya zama hutu. Gudanarwa irin waɗannan lissafin shine ainihin tsari da kuma tsara ayyukan wani kamfani.