Silsiladda sahayda iyo bakhaarka

Waxa guddiyadu raadiyaan

• Diiwaanno lagu kalsoonaan karo: dhaqdhaqaaq kasta oo gala ama ka baxa wuxuu leeyahay dukumenti, kaarka ama nidaamkuna maalin kasta wuxuu la mid yahay waxa khaanadda saaran.
• Qaabilaad taxaddar leh: waad tirisaa, waxaad hubisaa xaaladda, batch-ka iyo taariikhda dhicitaanka adigoo dukumentiyada la barbar dhigaya, waxaadna qortaa yaraanta ama dhaawaca ka hor intaadan saxiixin.
• Bakhaar nadiif ah, ammaan ah oo habaysan: pallet-yo, calaamado (labels), FEFO khaanadaha, la-dagaallanka cayayaanka, xakamaynta heerkulka iyo albaabbo gurmad oo furan.
• Daacadnimo xagga khasaaraha: dhaawaca, dhicitaanka iyo farqiyada qoraal ayaa lagu soo sheegaa isla maalintaas, weligoodna lama qariyo, kaarkana laguma beddelo si uu u waafaqo.
• Hore u qorshayn: waxaad la socotaa isticmaalka iyo heerka kaydka, kooxdana waxaad uga digtaa toddobaadyo ka hor inta kaydku dhammaan, ee ma aha maalinta uu dhammaado.
• Xirfad dhab ah oo Excel ama software kayd ah: haraaga (balance), formulo fudud, digniinaha dhicitaanka iyo warbixin bille ah oo cad.

Su'aalaha ay weydiiyaan

1. 1“Noo sharax sida aad u qaabilayso alaab gaadhi ku timid.”

   Sababta ay u weydiiyaan: Qaabilaadda ayaa ah halka khasaaraha badankiisu ka bilaabmo. Waxay hubinayaan inaad xakamayso dukumentiyada, aad qof labaad la tiriso, oo aad dhibaatooyinka diiwaangeliso ka hor intaadan saxiixin.

   Sida looga jawaabo

   • Marka hore waybill-ka la barbar dhig PO-ga ama warqadda sii-deynta (release note), si aad u ogaato waxa ay tahay inay gaadhiga saaran yihiin.
   • Alaabta pallet-yo ku deji oo shay kasta qof labaad la tiri; hubi xaaladda, lambarrada batch-ka iyo taariikhaha dhicitaanka.
   • Yaraanta iyo dhaawaca waybill-ka ku qor ka hor inta darawalku bixin, sawirro qaad, labadiinuna saxiixa.
   • Buuxi GRN-ka waxa aad runtii aqbashay, kaarka kaydka isla maalintaas cusboonaysii, khaanadahana FEFO ku dhig.

   When a truck arrives, I first check the waybill against the purchase order, so I know what should be there. We offload onto pallets, and with a second colleague I count every carton and check batch numbers and expiry dates. Once a delivery of oral rehydration salts had several wet cartons. I wrote the damaged quantity on the waybill before the driver signed, took photos and informed procurement by email. The GRN showed only the good cartons we accepted, and I updated the stock card that afternoon. The damaged cartons stayed separate until the supplier replaced them.

2. 2“Maxay ku kala duwan yihiin FIFO iyo FEFO, goormase mid kasta la isticmaalaa?”

   Sababta ay u weydiiyaan: Hubin farsamo oo aasaasi ah. Cuntada iyo dawooyinka, isticmaalka FIFO halkii FEFO wuxuu khaanadda ku reebi karaa batch dhicitaankiisu dhow yahay ilaa uu ka dhaco.

   Sida looga jawaabo

   • FIFO (first in, first out): kaydka marka hore yimid ayaa marka hore baxa. Wuxuu ku habboon yahay alaabta aan lahayn taariikh dhicitaan.
   • FEFO (first expired, first out): batch-ka taariikhdiisa dhicitaanku ugu dhow tahay ayaa marka hore baxa, xitaa haddii uu goor dambe yimid. U isticmaal cuntada, dawooyinka iyo wax kasta oo dhaca.
   • Sharax sida aad u fulisid: taariikhda dhicitaanka oo calaamad kasta ku qoran, batch-ka ugu horreeya oo hore yaal, iyo hubin bixin kasta.

   FIFO means the stock that arrived first leaves first. FEFO means the batch that expires first leaves first, even if it arrived later. In the pharmacy store where I worked, we used FEFO for all medicines and nutrition products. Every shelf label showed the batch and expiry date, the earliest batch was always at the front, and I checked the expiry on the issue voucher before anything left the store. For items without expiry, such as tarpaulins and jerrycans, we used FIFO so older stock did not stay at the back.

3. 3“Sidee baad u qorshaysaa oo u fulisaa tirin kayd oo dhammaystiran?”

   Sababta ay u weydiiyaan: Waxay rabaan inay ogaadaan in tirintaada lagu kalsoonaan karo: dhaqdhaqaaqa oo la joojiyey, dukumentiyada oo marka hore la geliyey, tiriyeyaal laba laba u shaqeeya, iyo farqiyada oo oggolaansho lagu waafajiyey.

   Sida looga jawaabo

   • Taariikhda la qorshee maareeyahaaga iyo maaliyadda; jooji qaabilaadda iyo bixinta, dukumenti kastana marka hore geli.
   • Isticmaal xaashiyo tirin oo aan haraaga nidaamka lahayn (blind count), si tiriyeyaashu u tiriyaan halkii ay koobiyeyn lahaayeen.
   • Laba laba u tiriya, mid tirinaya mid qorayana, qayb qayb, kadibna dib u tiri sadar kasta oo farqi leh.
   • Qor warbixin isu-waafajin (reconciliation), hagaajintana geli oo keliya oggolaansho qoraal ah ka dib.

   For the year-end count at a hospital store in Burao, we agreed a date with finance and stopped all issues for a day, except emergencies, which I recorded separately. I posted every open document the evening before. The count sheets had item names and locations but no balances. Two people counted each section, one counting and one writing. Then I compared the sheets with the stock cards, recounted every line with a difference and wrote a reconciliation report with the explanation for each one. The manager signed the adjustments before I entered them.

4. 4“Sidee baad si ammaan ah ugu kaydisaa dawooyinka, cuntada iyo shidaalka isla xarun?”

   Sababta ay u weydiiyaan: Waxay hubinayaan inaad taqaan xaaladaha kaydinta iyo xeerarka badbaadada, iyo inaad alaabta khatarta ah ka fogeyso cuntada iyo dawooyinka.

   Sida looga jawaabo

   • Raac xaaladaha kaydinta ee calaamadda ama warshadda: heerkulka, qoyaanka, iftiinka iyo dhererka isku-tuurka (stacking).
   • Alaabta pallet-yo ku hay, dhulka iyo derbiyada ka fog, marinnaduna ha banaanaadaan, dab-demiyeyaashuna ha la hubiyo.
   • Shidaalka iyo kiimikada ku kaydi meel gooni ah oo hawo leh, sigaar la'aan, ciid iyo dab-demiye agtooda yaal.
   • Ilaali silsiladda qabowga (cold chain) ee tallaalada iyo dawooyinka qaar, iyadoo diiwaanka heerkulka maalintii laba jeer la hubiyo.

5. 5“Sidee baad ku ogaataa goorta dib loo dalbanayo, sidee baadna uga hortagtaa in kaydku dhammaado?”

   Sababta ay u weydiiyaan: Waxay hubinayaan xirfadda qorshaynta: isticmaalka, lead time-ka iyo kaydka badbaadada (safety stock), iyo inaad kooxda goor hore u sheegto si ay wax uga qabtaan.

   Sida looga jawaabo

   • Ka xisaabi celceliska isticmaalka bishii (AMC) diiwaannada bixinta, bilaha kaydkana waa kaydka jira oo loo qaybiyo tiradaas.
   • Bilaha kaydka la barbar dhig lead time-ka oo lagu daray xad badbaado; taasi waxay ku siinaysaa heerka dib-u-dalbashada (reorder point).
   • La wadaag warbixin kayd ama pipeline oo bille ah oo gaaban: kaydka, isticmaalka, dalabyada jidka ku jira, goorta la filayo inay yimaadaan, iyo alaabta khatarta ku jirta.

   Every month I calculate average monthly consumption for each item from the issue vouchers. Stock on hand divided by that figure gives months of stock. For items with a long lead time, such as supplies coming by sea through Berbera, I compare months of stock with the lead time plus a safety margin agreed with the programme. Anything close to that line goes in red in my monthly pipeline report to programme and procurement, with the quantity I suggest ordering. That way the order is placed while there is still stock on the shelf.

6. 6“Waxaad bakhaarka gadaashiisa ka heshay pallet dawo ah oo dhacday. Maxaad samaynaysaa?”

   Sababta ay u weydiiyaan: Waxay hubinayaan daacadnimada iyo hannaanka: kala-saarista kaydka, soo-sheegid xaqiiqooyin leh, tuurid oggolaansho keliya ku dhacda, iyo hagaajinta sababta ay u dhacday.

   Sida looga jawaabo

   • U rar meel gooni ah (quarantine area), ku qor 'ha la bixin', dhaqdhaqaaqana kaarka kaydka ku diiwaangeli.
   • Isla maalintaas qoraal ku soo sheeg: shayga, batch-ka, tirada, taariikhda dhicitaanka, qiimaha la qiyaasay iyo sawirro.
   • Tuur oo keliya oggolaansho qoraal ah ka dib, adigoo raacaya hannaanka hay'addaada iyo waxa ay hay'adda caafimaadku dalbato, kaydina diiwaanka tuuridda.
   • Hel sababta, sida FEFO oo aan la raacin ama dalab xad-dhaaf ah, sheegna waxaad beddeshay.

7. 7“Sidee baad alaab ugu dirtaa xafiis ama goob gobol kale ku taal, sidee baadna u hubisaa inay gaadhay?”

   Sababta ay u weydiiyaan: Dirista ayaa ah meesha kale ee alaabtu ka lunto. Waxay hubinayaan oggolaanshaha, waybill-ka, iyo inaad la socoto ilaa nuqulka la saxiixay kuu soo noqdo.

   Sida looga jawaabo

   • Wax dir oo keliya marka uu jiro codsi la oggolaaday ama release note; FEFO ku soo qaad, kadibna si cad u xidh oo calaamadee.
   • Buuxi waybill lambar leh: alaabta, tirada, batch-yada, taarikada gaadhiga, darawalka, taariikhda iyo saxiixyada marka la rarayo.
   • Qaabiluhu wuu tiriyaa, saxiixaa oo nuqul soo celiyaa; waad la socotaa ilaa uu soo noqdo, kadibna waybill-ka ku xidh diiwaankaaga la-socodka (tracker).

   Nothing leaves my store without an approved release note. We pick the items by FEFO, pack them and label each carton with the destination. I fill a numbered waybill with the items, quantities, batch numbers, the truck plate and the driver's name, and the driver signs at loading. At the other end, the storekeeper counts, writes any shortage or damage on the waybill, signs and sends a copy back with the driver or as a scan by email. I keep a waybill tracker in Excel, and any waybill not returned after a week gets a phone call.

8. 8“Software kayd ah ama shaqooyinka Excel keebaad isticmaashay?”

   Sababta ay u weydiiyaan: Waxay hubinayaan heerkaaga dhabta ah, maxaa yeelay xilalkan badankood waxay leeyihiin imtixaan Excel. Jawaabaha daacadda ah ee gaarka ah ayaa ka dhibco badan liis dheer oo qalab ah.

   Sida looga jawaabo

   • Sharax waxa aad dhistay ama isticmaashay: xaashi qaabilaad, xaashi bixin iyo haraag lagu xisaabiyo SUMIFS, iyo digniin dhicitaan oo conditional formatting ah.
   • Haddii aad isticmaashay ERP ama nidaam kayd, magacaw oo sheeg qaybta aad isticmaashay; haddii kale, sidaas dheh.
   • Muuji inaad fahantay macnaha: dhaqdhaqaaq kasta wuxuu ka yimaadaa dukumenti, haraaguna waa inuu la mid noqdaa waxa khaanadda saaran.

   I have kept stock in Excel for three years. My workbook has one sheet for receipts, one for issues and a balance sheet that uses SUMIFS by item code, so the balance changes as soon as I enter a document. Conditional formatting turns items red when they are within three months of expiry. I have not used an ERP system at work, only seen one in a training session, but I understand the logic is the same: every movement comes from a document, and the balance must match the shelf.

Tusaalooyinka jawaabaha waa English, luqadda guddiyada badankoodu isticmaalaan. Adigu erayadaada ku sheeg.

Mawduucyada dib u eeg

• GRN (goods received note)Dukumentiga diiwaangeliya waxa runtii yimid iyo xaaladdiisa, oo uu saxiixo qaabiluhu iyo markhaati. Maaliyaddu waxay isticmaashaa ka hor lacag-bixinta. Diyaar u ahow inaad sharaxdo sababta aadan weligaa u saxiixin ka hor tirinta.
• Stock card vs bin cardBin card-ku wuxuu la yaallaa shayga khaanadda, wuxuuna muujiyaa dhaqdhaqaaq kasta iyo haraaga; stock card-ka ama buugga kaydka (ledger) waxaa lagu hayaa xafiiska ama nidaamka. Labaduba waa inay is waafaqaan, waana inay la mid noqdaan waxa khaanadda saaran.
• FIFO and FEFOFirst in first out, iyo first expired first out. FEFO ayaa la raacaa wax kasta oo taariikh dhicitaan leh. Waxaa laga yaabaa inay ku tusaan saddex batch oo leh taariikho imaansho iyo dhicitaan kala duwan, kuna weydiiyaan kee marka hore baxaya.
• Physical count vs cycle countTirinta dhammaystiran (physical count) waxay hubisaa shay kasta hal mar, badanaa dhammaadka sannadka. Cycle count-ku wuxuu toddobaad kasta hubiyaa alaab yar, iyadoo alaabta qiimaha sare leh iyo tan dhakhsaha u baxda inta badan la tiriyo. Bakhaarro badan labadaba way isticmaalaan.
• Stock reconciliationIsbarbardhigga tirinta iyo diiwaannada, iyo sharxidda farqi kasta dukumentiyo: qaabilaad aan la gelin, summado qaldan, dhaawac, amaah. Farqiga aan la sharxin oo keliya ayaa khasaare ahaan loo soo sheegaa, hagaajintuna waxay u baahan tahay oggolaansho.
• AMC and months of stockCelceliska isticmaalka bishii (AMC) waa waxa bil caadi ah baxa, badanaa saddexdii ilaa lixdii bilood ee u dambeeyey. Bilaha kaydka (months of stock) waa kaydka jira oo loo qaybiyo AMC. Imtixaanka ku filo xisaab degdeg ah.
• Lead time, safety stock and reorder pointLead time waa inta dalab qaato inta uu imanayo. Safety stock waa kayd dheeraad ah oo loogu talagalay dib-u-dhac ama isticmaal kordhay. Reorder point waa heerka aad dalbato: qiyaastii isticmaalka inta lead time-ku socdo oo lagu daray safety stock-ga.
• WaybillDukumentiga lambarka leh ee alaabta la socda: waxa la raray, gaadhiga, cidda, iyo waxa qaabiluhu u saxiixay. Waybill aan soo noqon waa khatar furan ilaa uu soo noqdo.
• Cold chainIlaalinta tallaalada iyo dawooyinka qaar heerkulka loo baahan yahay laga bilaabo alaab-qeybiyaha ilaa bukaanka: qaboojiyeyaal, sanduuqyo qabow, baraf iyo diiwaan heerkul. Ogow waxaad samayn lahayd haddii qaboojiyuhu xumaado ama diiwaanku muujiyo jebin.
• Quarantine and disposalAlaabta dhaawacantay, dhacday ama dib loo yeedhay waxay aadaan meel calaamadaysan, waa la diiwaangeliyaa, weligoodna lama bixiyo. Tuuriddu waxay u baahan tahay oggolaansho qoraal ah, markhaati ama guddi, iyo diiwaan, iyadoo la raacayo xeerarka caafimaadka iyo deegaanka.
• SUMIFS and pivot tablesSUMIFS waxay isku daraysaa qaabilaadda ama bixinta hal summad alaab, taasoo ku siinaysa haraag socda. Pivot table-ku wuxuu ilbiriqsiyo gudahood soo koobaa bixinta shay kasta, bil kasta ama goob kasta. Labaduba badanaa waxay ku jiraan imtixaannada Excel ee bakhaarka.

Hawlaha la sameeyo ee laga yaabo in lagu siiyo

1. 1Imtixaan Excel (45–60 daqiiqo): liis qaabilaad iyo bixin ah oo loo beddelo haraag, bilo kayd iyo liis dhicitaan, badanaa waxaa ku jira hal gelin qaldan oo la raadiyo. Ku tababaro SUMIFS, kala-soocidda, filter-yada iyo pivot table fudud.
2. 2Gacanta ku buuxi kaar kayd adigoo ka shaqaynaya ilaa toban dukumenti: qaabilaad, bixin, soo-celin iyo warbixin dhaawac. Sheeg haraaga dhammaadka oo muuji meesha sadar kastaa ka yimid. Warqad ku tababaro si tiirarkaagu u nadiif ahaadaan.
3. 3Socod bakhaar ama sawir: 'Maxaa halkan qaldan?' Raadi kartoonno dhulka saaran, albaabbo gurmad oo xidhan, shidaal cunto u dhow, calaamado maqan, alaab dhacday oo kayd fiican ku dhex jirta, pallet-yo jabay. Mid kasta sheeg khatarta iyo xalka.
4. 4Kiis qoraal ah oo gaaban: gaadiid kooban iyo goobo dhowr ah oo isla shay dalbanaya. Muuji sida aad ugu kala horreysiin lahayd degdegga iyo dhicitaanka, iyo waxa aad u sheegi lahayd goobaha aadan toddobaadkan gaadhsiin karin.

Khaladaadka ka fogow

• Inaad sheegto inaad marka hore saxiixdo waybill-ka ama GRN-ka oo aad goor dambe tiriso sababtoo ah darawalku wuu degdegayaa.
• Inaad sheegto inaad dawooyinka u isticmaasho FIFO, ama aad isku qasto FIFO iyo FEFO.
• Inaad ka hadasho 'saxidda' kaarka kaydka adigoon sheegin oggolaansho qoraal ah.
• Inaad taxdo xirfado Excel oo sare oo aadan imtixaanka ku muujin karin; imtixaanku daqiiqado gudahood ayuu ogaadaa.
• Inaad sharaxdo tirinta iyo khaanadaynta oo keliya, adigoon waxba ka sheegin qorshaynta, heerarka dib-u-dalbashada ama warbixinta barnaamijka.
• Inaad illowdo badbaadada: albaabbada gurmadka, dab-demiyeyaasha, kaydinta shidaalka iyo isku-tuurka ammaanka ah waa qayb ka mid ah shaqada, ee ma aha wax dheeraad ah.

Hubin degdeg ah

5 su'aalood. Mid kasta ka jawaab si aad u aragto sharaxaadda.