Ukuqonda ukubalwa kweRhafu yeNtengiso eNgemva
Hayi, ubugcisa bokutyhila amanani ukutyhila iimfihlo ezifihlakeleyo zamaxabiso! Kufana nokusombulula imfihlakalo apho umrhanelwa ehlala eyimali. Masingene kwihlabathi lokubalwa kwerhafu yentengiso ebuyela umva kunye, apho simisela ixabiso lokuqala phambi kokuba ezo rhafu zingenabuqhophololo zingene.
Ukufumana ixabiso lokuqala phambi kwerhafu, kufuneka ube ngumcuphi wezibalo. Nantsi ifomula yakho yomsebenzi ofihlakeleyo: – Inyathelo loku-1: Qala ngokuthabatha isaphulelo kwi-100%. Yicinge njengokususa isigqubuthelo sobuso ukuze uveze eyona nto uyiyo. – Inyathelo lesi-2: Phinda-phinda eli xabiso lithotyiweyo nge-100, ulijike libe yiglasi yokukhulisa amanani. - Inyathelo lesi-3: Okokugqibela, yahlula le totali ngepesenti efunyenwe kwinyathelo lokuqala. Kufana nokuhlanganisa kunye imikhondo ukuze uqhekeze ityala.
Ngoku ekubeni unezixhobo zakho zokucupha masiyicime le phazili yezibalo kunye nenyathelo ngalinye elisikhokelela ekutyhileni elo xabiso linzima lifihliweyo emva kwezaphulelo kunye neerhafu.
Masizigcine ziluncedo izixhobo zokubala kwaye siqhubeke nokuphonononga olu hambo luthatha amanani!
ISikhokelo seNyathelo ngeNyathelo sokuFumana iXabiso loqobo phambi kweRhafu
Ke, ungene kwihlabathi elixubeneyo lokufumana ixabiso loqobo ngaphambi kokuba ezo rhafu zinobuqhophololo zingene njengeearhente eziyimfihlo. Ngoku, masibambe iikhaltyhuleyitha zethu kwaye sichaze le mfihlelo yamanani inyathelo nenyathelo.
Nantsi ifomula yakho yobuqili ngqo ukusuka kwi-Excel: Inyathelo loku-1 - Yahlula ixabiso lilonke nge-1 kunye nesantya serhafu ukufumanisa imikhondo efihliweyo. Inyathelo lesi-2 - Phindaphinda isiphumo ngexabiso lerhafu ukuveza iidola zerhafu ezibandakanyekayo. Inyathelo lesi-3 -Thatha ezi dola zichongiweyo zerhafu kwixabiso lilonke ukuze uveze eyona mali yokwenyani phambi kokuba irhafu iqweqwedise itheko lakho.
Ukugrumba nzulu kolu hlaselo lwemathematika, khawufane ucinge ukuba uligqwirha lezibalo usebenzisa iipesenti njengentonga yakho yomlingo. Ukuba uyazi ukuba ixabiso elipheleleyo lemveliso liquka irhafu, yongeza ngokulula eli xabiso kwi-100. Umzekelo, ukuba udibana nomyinge werhafu oyi-15%, yiguqule ibe kwimo yayo yesishumi (1.15) kwaye wahlule inani loqobo ngolu hlobo lufihlakeleyo. ummeli ukutyhila ubuyena bokwenyani...ndithetha ixabiso!
Kwaye ukuba ujongene nezaphulelo zokucalula njengengcali, guqula loo pesenti ihendayo ibe yidesimali ukuze kube lula ukuyibhala (ingcebiso: yahlula nge-100). Emva koko tshangatshangisa iwand yakho kwaye usete i-equation P = (1 – d) x apho iP ilixabiso lakho lentengiso, d inesaphulelo senkohliso ngendlela yesishumi, kwaye x lelo xabiso linzima lokubuza elijikelezayo kuzo zonke ezi zicwangciso.
Ngoku, makhe sijongane nokuguqula i-HST ngasemva; kufana nokuba nguSherlock Holmes kodwa ngamanani endaweni yeemfihlakalo. Undoqo ulele ekucimeni irhafu yokuthengisa ukusuka kwisixa esipheleleyo: yahlula ngo (1 + irhafu yerhafu yokuthengisa) ukutyhila elo xabiso lingenatyala le-HST elizama ukufihla emva kwamanani anyusiweyo.
Kwaye okokugqibela, buyela umva ujongane ngokuchasene nokonyuka kwepesenti - yicinge njengokujongana namanani okutshintsha iimilo uzama ukukuqhatha! Ukuba udibana nokunyuka okufana ne-150%, qala ngokuseta umlinganiso weequations uSherlock angazingca ngako: Ipesenti nganye mayilingane nexabiso layo elihambelanayo (kule meko, 690 kwi-150%). Yahlula ngepesenti (150), emva koko phinda-phinda iziphumo zakho ngobuchule bezibalo ude uveze elona nani linzima loqobo elihluthwe ngeepesenti zokudlala imidlalo enenyani.
Ngezi zixhobo zamanani zingaqondakaliyo zikufuphi kunye nezixhobo zethu zokubala ezithembekileyo zikhazimle ngokuqaqambileyo kuzuko lokudibanisa, sikulungele ukuzulazula kule labyrinth yamaxabiso afihliweyo kunye ne-finesse kwaye mhlawumbi i-dash yomlingo womlingo!
Ukusebenzisa i-Excel kunye neeKhatyhuleyitha ukumisela amaxabiso angaphambi kweRhafu
Ukukrazula ikhowudi yokutyhila ixabiso lokuqala ngaphambi kokuba ezo rhafu zingenabuqhophololo zingene, i-Excel iza kuhlangula ngobungqina bayo bezibalo. Umlingo ulele kwifomula elula kodwa enamandla etyhila ixabiso langaphambi kwerhafu njengesileyi esikwigumbi lokubaleka lamanani. Nantsi indlela ongayenza ngayo ijelo lengcali yezibalo yangaphakathi:
- Inyathelo 1: Yahlula kwaye Woyise: Thatha ixabiso lilonke kwaye uyahlule ngesinye kunye nomlinganiselo werhafu. Kufana nokwahlula amanani ukuveza eyona nto iyinyani, ukwahlula abarhafiswayo kwirhafu engahlawulelwayo.
- INyathelo 2: Ukuphindaphinda Iimfihlelo: Nje ukuba unaso esi siphumo, phinda-phinda ngomlinganiselo werhafu - apha, amanani aphila njengamaqhekeza ephazili abeka endaweni yawo.
- Inyathelo 3: Ukuthabatha iiMfihlo: Ukutyhila ixabiso lokugqibela loqobo phambi kokuba iirhafu zijike yonke into, thabatha ezi dollar zichongiweyo zerhafu kwisixa sakho sisonke. Kufana nokutyhila ubuncwane obufihlwe ngaphantsi kwezibalo.
Xa usebenzisa i-Excel njengomdlali osecaleni othembekileyo kolu hambo lwamanani, khumbula ukufaka ezi fomula ngenkuthalo kwiiseli ezichongiweyo apho uguquko lomlingo lwenzeka ngesitshixo ngasinye:
- Ifomula yokufumana ixabiso phambi kwerhafu ichanekile: Ixabiso lilonke lahlulwe ngo (1 + Ixabiso leRhafu yokuthengisa). Yicinge njengokuvula iingcango ezifihlakeleyo ukuveza amaxabiso ngaphandle kobuqhetseba bokurhafisa.
- Ukuba ujongene nezaphulelo eziqhekekileyo kunye nokufutha izikimu ezikhohlisayo kumaxabiso okuqala afihlwe ngasemva kweempawu ezihendayo, ungoyiki! Faka ngokulula “=price_with_discount / (1 – isaphulelo)” kwi-Excel kwaye ubukele njengoko amaxabiso athotyiweyo esebeza iimfihlo malunga nemvelaphi yawo.
Kuko konke malunga nokubamba la manani ukuze aveze amaxabiso angakhange achukunyiswe kukuphazamiseka kwerhafu. Ke zixhobise nge-wizardry yakho-nokuba yi-Excel okanye i-calculator ethembekileyo-kwaye ujongane nezi mfihlakalo zezibalo njengepro!
Ulifumana njani ixabiso lokuqala phambi kwerhafu?
Ukufumana ixabiso lokuqala phambi kwerhafu, kufuneka uthabathe isaphulelo kwi-100% ukuze ufumane ipesenti yexabiso lokuqala, uze uphindaphinde ixabiso lokugqibela nge-100, kwaye ekugqibeleni ulahlule ngexabiso lepesenti elifunyenwe kwinyathelo lokuqala.
Ndiyibala njani irhafu yokuthengisa umva?
Ukubala irhafu yokuthengisa ngasemva ukusuka kwitotali, kufuneka uthabathe irhafu ehlawulwe kwitotali, uhlukanise irhafu ehlawulwe ngexabiso lerhafu yangaphambili, uguqule izinga lerhafu kwipesenti, udibanise i-100 ekhulwini kwixabiso lerhafu, uguqule ipesenti epheleleyo. ukuya kwifomu yesishumi, kwaye emva koko wahlule ixabiso langemva kwerhafu ngedesimali.
Ithini ifomula yexabiso lokuqala?
Ifomula yokubala ixabiso lokuqala lento ethotyiweyo ibandakanya ukwahlula ixabiso lentengiso nge-1 thabatha ipesenti yesaphulelo kwifomu yesishumi.
Ulifumana njani ixabiso lokuqala emva kokumakisha?
Ukufumana ixabiso lokuqala emva kokumakishwa, ukuba uyayazi ixabiso emva kokumakisha, uyahlula ngo-1.10. Ngokomzekelo, ukuba ixabiso emva kwe-markup yi-$ 27.50, ixabiso lokuqala liza kuba yi-$ 27.50 lihlulwe ngu-1.10, elilingana ne-$ 25.00.