FMS (Flow Management System): Har Order ka Har Step Planned vs Actual Time se Track Karo
FMS flow management system samjho: steps, doer aur TAT tay karo, planned vs actual time compare karo, delay pakdo aur MIS dashboard pe report dekho.
FMS yaani flow management system us sawaal ka jawab hai jo badhte business ka owner din me das baar poochta hai: ye order abhi kahan hai, aur late to nahi? Indian SME practice me FMS ek sheet ya system hai jisme har order ya job ek fixed list ke steps se guzarta hai, har step ka ek naam wala doer aur ek allowed time hota hai, aur system har step ka planned time aur actual time record karta hai. Dono ka farak hi delay hai, aur wo usi waqt dikhta hai jab hota hai. Is guide me samjhenge FMS flow management system kaise kaam karta hai, apne process ke liye kaise design karein, Google Sheets me kaise banayein, aur MIS dashboard ise report me kaise badalta hai.
Business me FMS ka matlab
FMS kai cheezon ke liye use hota hai — facility management, flight management, kisi software module ka naam bhi. Par Indian chhoti aur medium companies ke business-system world me iska matlab aksar flow management system hota hai, kabhi flow monitoring sheet ya flowchart monitoring system bhi kehte hai. Idea har version me ek hi hai: kaam ke flow ko steps me likho, phir har order ko us flow ke against monitor karo.
Ye task list se alag hai. Task list ek-baar wale kaam track karti hai. FMS repeat hone wala process track karta hai — order se delivery, enquiry se quotation, purchase request se goods received, hiring request se joining — jahan har baar wahi steps usi order me hote hai.
Building blocks: steps, doer aur TAT
Har FMS har step ke liye chaar cheezon se banta hai:
- Step — kya hona hai, ek line me
- Doer — ek role jo use poora karne ka zimmedaar hai
- TAT (turnaround time) — step ko kitna time milta hai, ghante ya din me
- Trigger — clock kab se chalti hai, aksar pichhle step ke actual completion se
Example: order to delivery FMS
Trading ya manufacturing business ka ek simple order-to-delivery flow aisa dikh sakta hai. Aapke steps aur time alag honge; structure important hai.
| Step | Doer | TAT | Clock kab se |
|---|---|---|---|
| 1. Order aaya aur entry hui | Sales coordinator | 2 ghante | Customer confirmation |
| 2. Customer ko order confirmation bheja | Sales coordinator | 4 ghante | Step 1 actual |
| 3. Material availability check | Stores | 1 din | Step 2 actual |
| 4. Purchase ya production plan | Purchase / Production | 1 din | Step 3 actual |
| 5. Maal ready aur quality check | Production / QC | Order ke hisaab se | Step 4 actual |
| 6. Invoice aur dispatch documents | Accounts | 4 ghante | Step 5 actual |
| 7. Dispatch | Dispatch | 1 din | Step 6 actual |
| 8. Delivery confirm | Dispatch / Sales | Route ke hisaab se | Step 7 actual |
| 9. Payment follow-up | Accounts | Credit terms ke hisaab se | Step 8 actual |
Planned vs actual time: FMS delay kaise pakadta hai
Har order ke har step ke liye FMS do timestamp rakhta hai. Planned apne aap calculate hota hai: trigger wale step ka actual time plus TAT. Actual tab bharta hai jab doer step done mark karta hai. Actual planned se late hai to step delayed hai, aur kitne ghante ya din ka delay hua, wo us doer ke naam record hota hai.
Iski do taakat hai. Pehli, delay usi step pe dikhta hai jahan hua, teen step baad nahi jab customer call kare. Doosri, aage ke har step ka plan bhi saath me khisakta hai, to aage wale sab log asli date dekhte hai, purana promise nahi.
Pending, done aur delayed — teen state jo matter karti hai
- Pending — planned time aage hai aur step abhi hua nahi
- Overdue — planned time nikal gaya aur step ab bhi nahi hua; dhyaan yahin jaana chahiye
- Done late — ho gaya, par planned time ke baad; isi se doer ka delay score banta hai
Google Sheets me FMS kaise banayein
Kai team apna pehla FMS Google Sheets me chalati hai. Ek chalne wala structure:
- Har naye order ke liye Google Form ya input tab — date, customer aur main details
- Main FMS tab: har order ki ek row, aur har step ke liye columns ka group — Planned, Actual, Status aur Delay
- Formula jo Planned ko pichhle step ke Actual plus TAT se nikaale, aur Delay = Actual minus Planned
- Conditional formatting taaki overdue step laal ho jaaye
- Setup tab jisme har step, doer aur TAT likha ho, taaki formula chhede bina time badal sakein
- Har doer ka filter view jisme sirf uske paas pending steps dikhein
Do practical warning. Actual time tabhi record ho jab doer step done mark kare, baad me yaad se type na ho, warna poora system bekaar. Aur aaj ki date pe depend karne wale Sheets formula baar-baar recalculate hote hai, to badi sheet slow ho sakti hai — band order archive tab me daal do.
MIS dashboard: FMS ka reporting side
FMS me kaam track hota hai. MIS (management information system) dashboard pe owner use padhta hai. Ye FMS se data leta hai aur zaroori numbers ek screen pe dikhata hai:
| MIS view | Kis sawaal ka jawab |
|---|---|
| Step-wise pending order | Abhi kaam kahan atak raha hai? |
| Doer-wise overdue step | Aaj kisko madad ya reminder chahiye? |
| Step-wise on-time percentage | Process ka bottleneck kaunsa step hai? |
| Doer-wise average delay | Kaun lagataar late hai, aur kitna? |
| Order-to-delivery time trend | Mahine-dar-mahine tez ho rahe hai ya slow? |
Har hafte review karo to ye views behas ko facts me badal dete hai. Agar zyadaatar order pe step 3 late hai, to problem step ya uske TAT me hai, bande me nahi. Agar ek doer har step pe late hai, to workload ya training ka sawaal hai.
Rule jo FMS ko imaandaar rakhte hai
- Har step ka ek doer, role ke hisaab se, backup ke saath
- TAT doers ke saath tay karo, thopo mat; shuru me dheela rakho, ek mahine ke data ke baad tight karo
- Apna step sirf doer done mark kare; koi doosre ka actual na bhare
- Har hafte delay review ho, aur har baar-baar hone wale delay ka reason aur fix likha jaaye
- WhatsApp pe parallel tracking nahi — FMS me nahi hai to hua hi nahi
FMS ko Google Sheets se kab hatayein
Kai chhoti aur medium team ke liye Google Sheets aur Apps Script tez aur sasta padta hai. Dikkat tab aati hai jab order hazaaron me ho jaayein, bahut log ek saath edit karein, doer ko sirf apne step dikhne chahiye, ya kai flow (sales, purchase, production) ek MIS me aane chahiye. Tab web app zyada bharosemand hai.
Yuktantra ka FMS flow side — har order ya job apne steps me follow hota hai, har step ka owner aur planned date — ko MIS dashboard ke saath jodta hai: real-time dashboard, operational KPI, custom report, kuch atke to alert aur flag, aur role-based access. Jahan fit ho wahan Google Sheets pe banate hai, aur volume ya permission Sheet se bada ho to web app. Pehle scope likha jaata hai, phir usi scope ka fixed quote.
FMS flow management system khud kaam tez nahi karta. Ye har delay ko usi step pe dikhata hai jahan wo hota hai — aur theek bhi wahin ho sakta hai.
FAQ
Business me FMS ka full form kya hai?
Indian business-system practice me FMS aksar flow management system (ya flow monitoring sheet) hota hai: har order ya job tay steps se guzarta hai, aur har step ka doer, allowed time aur planned vs actual record hota hai.
FMS Google Sheet kaise kaam karti hai?
Har order ek row hai. Har step ke Planned, Actual, Status aur Delay columns hote hai. Planned = pichhle step ka actual time plus TAT; doer kaam hone par Actual bharta hai; formula delay nikaalte hai aur overdue step highlight karte hai.
FMS aur MIS me kya farak hai?
FMS har order ka flow uske steps me track karta hai. MIS us data ka reporting layer hai — step-wise pending, doer-wise overdue, on-time percentage aur trend — management ke liye dashboard pe.
FMS me TAT kya hota hai?
TAT matlab turnaround time: ek step ko kitna time milta hai. Kisi step ka planned time pichhle step ke actual completion plus uske TAT se nikalta hai.
FMS se kaunse process track ho sakte hai?
Koi bhi process jo har baar same steps me repeat hota hai: order to delivery, enquiry to quotation, purchase request to goods received, job work, service complaint, aur hiring se joining tak.
