Shop Productivity & OB SKU Activity Incentive Calculation Using SUMIF and VLOOKUP - EXCEL Trick

Assalam-o-Alaikum dosto, Is video mein main dikhata hoon ke KPO kis tarah Order Booker (OB), ASM aur TSO ki madad kar sakta hai shop productivity aur SKU activity track karne mein. Agar software cumulative shop-wise SKU sales deta hai to hum VLOOKUP/XLOOKUP use karke productive shops identify kar sakte hain. Aur agar data date-wise ya invoice-wise available ho to hum SUMIF/SUMIFS ki madad se har shop ki total SKU quantity calculate karte hain. Is example mein target 6 PCS per shop hai. Jo shops target achieve kar leti hain unhein Rs. 5 per shop incentive milta hai. Video mein practical Excel formulas aur reporting logic step-by-step explain ki gayi hai jo FMCG distribution, sales operations aur MIS reporting mein bohat useful hai. ✅ Shop Productivity Tracking ✅ OB by SKU Activity Analysis ✅ SUMIF / SUMIFS Formula Use ✅ VLOOKUP / XLOOKUP Lookup Methods ✅ Incentive Calculation Logic ✅ FMCG Sales Reporting #Excel #MISReporting #OrderBooker #ASM #TSO #FMCG #VLOOKUP #XLOOKUP #SUMIF #SalesAnalysis #ShopProductivity #ExcelTutorial #DataAnalysis #IncentiveCalculation #KPO #DistributionReporting