Tabish Khan
I fix warehouse chaos SOPs, SAP & Excel system for ops team
- 5.00
- Rating
- 6
- Followers
5S is not a one-time project. It's a daily standard.
When I first got involved in 5S implementation, I thought of it as a launch event — clean the area, label the bins, take a few before/after photos, done.
I was wrong.
The real work starts after the launch. 5S only holds if it's checked, audited, and corrected every single day — not once a quarter, not when an audit is scheduled.
A few things that made the difference for us:
→ Daily housekeeping checks, not scheduled "clean-up days"
→ Making abnormalities visible immediately, not filed away for later
→ Treating 5S as a discipline the team owns, not a task assigned to one person
→ Tying it directly to safety — a disorganized warehouse is a safety risk before it's an efficiency one
The warehouses that sustain 5S long-term are the ones where it stops being "a project" and becomes muscle memory — something the team does without being told.
It's not glamorous. But it's one of the few things that quietly improves safety, accuracy, and efficiency all at once — every single day.
0
24
📦 Service Spotlight: Warehouse SOP Audit
Warehouse problems rarely start on the warehouse floor—they start with inconsistent processes.
Poorly documented or outdated SOPs can lead to inventory inaccuracies, production delays, audit findings, and unnecessary operational costs.
I help manufacturing and distribution businesses identify these gaps through a Warehouse SOP Audit.
What you'll get:
✔ Comprehensive warehouse process assessment
✔ SOP review and standardization
✔ Process gap & risk identification
✔ Actionable improvement roadmap
✔ SAP warehouse process optimization
✔ KPI recommendations for continuous improvement
Whether you're implementing SAP, scaling operations, or preparing for an audit, my goal is to help you build efficient, standardized warehouse processes that support long-term operational excellence.
With 8+ years of experience in Supply Chain & Warehouse Operations, I've worked extensively with warehouse management, inventory control, SAP, automation, and continuous improvement in a fast-paced manufacturing environment.
If you're looking to improve your warehouse operations, I'd be happy to help.
👉 Check out my Warehouse SOP Audit service on Contra or send me a message to discuss your requirements.
Helping manufacturers and distribution businesses build efficient, standardized warehouse operations through SOP audits and process improvement.
0
23
The most expensive warehouse problem usually isn't inventory.
It's repetitive work.
Recently, I analyzed a warehouse process where the team was manually creating SAP transactions every day. The process itself wasn't difficult—it was just repeated hundreds of times.
By building an Excel VBA automation integrated with SAP, I was able to:
✅ Reduce processing time by around 80%
✅ Cut manual effort by 70%
✅ Eliminate repetitive data entry
✅ Allow the team to focus on operational decisions instead of administrative work
The best part?
It required zero additional software investment. We improved the existing process instead of replacing it.
Many companies believe they need a new WMS or another expensive platform.
In reality, the biggest opportunities often come from improving the systems they already have.
I specialize in helping manufacturing and warehouse teams streamline operations through:
• SAP process optimization
• Excel VBA automation
• Warehouse SOP development
• Inventory management improvements
• Custom operational dashboards
• Power Apps solutions
If your warehouse team spends hours every week on repetitive tasks, there is probably a faster way.
Let's optimize the process before investing in new software.
0
74
In 15 minutes, I can usually find at least one thing that's costing a warehouse time or money.
Sometimes it's a layout issue. Sometimes it's a process that made sense two years ago but doesn't anymore. Sometimes it's a blind spot the team is too close to see.
I've done this across FMCG facilities — and this month, I'm offering free 15-minute virtual audits to a handful of operations.
Here's what you get:
→ A virtual walkthrough of your warehouse
→ A written summary of what I observe
→ Zero obligation, zero sales pitch
If you're running a warehouse and curious what an outside eye might catch — let's talk.
Comment below or send me a DM to claim a spot.
0
45
How I reduced a 10-minute SAP process to 1.5 minutes using Excel VBA — and saved 255 minutes every day
This isn't a theory post. This is something I built, tested, and deployed across 2 manufacturing plants in Pakistan.
If your team is running repetitive SAP transactions manually every day, this will show you exactly what's possible — and how I did it with nothing but Excel VBA.
The problem
In my last FMCG role we ran STOs (Stock Transfer Orders) daily. An STO is a stock movement between two plants or warehouses in SAP — and it requires 3 separate transactions to complete:
→ PO Creation — run NME21N, select PO type, enter shipping code, item codes, quantities, receiving plant, SLOC for each SKU
→ Delivery Creation — run NVL10B, go to purchase order, paste PO number, execute, click line item, save
→ Shipment Creation — run NVT01N, enter FK02, Z004, select P&G Interplant, click delivery tab, paste delivery number, execute, set shipping point, select date, click planning, check in, select date, click shipment start, save
50 manual steps per STO.
10 STOs per shift.
3 shifts per day.
That's 1,500 manual steps every 24 hours — and 2.5 hours of pure manual work daily across all shifts.
The errors
The process wasn't just slow — it was a trap.
The most common error: copying an 8-digit PO number and missing one digit. You wouldn't catch it until the next transaction failed — then you'd go back, find the correct PO, and restart.
SAP also disconnected occasionally mid-process. When it did, you started from scratch.
30 STOs a day meant 30 chances to make a mistake. And mistakes had real consequences — wrong stock movements, delayed shipments, production line stoppages.
The solution
I mapped every single step across all 3 transactions. Every click, every field, every copy-paste, every keyboard shortcut.
Then I built an Excel VBA tool that automated the entire flow.
The tool:
→ Opens SAP automatically
→ Copies all item codes across 6 SKUs in one action
→ Pastes all quantities across 6 SKUs in one action
→ Clicks create STO — completing all 3 transactions automatically
The new process:
Open tool
Open SAP
Copy item codes
Paste quantities
Click create
5 steps. That's it.
The results
Before After Steps per STO 50 Time per STO 10 min 1.5 min Steps per day 1,500 150 Time per day 150 min 45 min Steps saved daily 1,350 Minutes saved daily 255
The impact
It took me 3 months to build. Nights, weekends, failed scripts, late fixes.
When it worked — it really worked.
The tool was rolled out across 2 plants in Pakistan. I shared it with the regional council and they couldn't believe it was built in Excel — not by an SAP consultant, not with an IT budget, not through a formal project.
I received a company award for it.
What this means for your operation
If your team is running repetitive SAP transactions manually, you almost certainly have the same opportunity.
The tool doesn't require SAP customization. It doesn't require an IT team. It works alongside your existing SAP setup — not instead of it.
Every warehouse or production operation running SAP has at least one process like this. A task done 20, 30, 50 times a day that nobody has ever stopped to question.
That's where the biggest wins are hiding.
Want this built for your operation?
I offer SAP & Excel process consulting for warehouse and production teams. If you're running repetitive SAP transactions manually and want to explore what automation could look like for your specific setup, book a free discovery call below.
👉 [View my SAP Consulting Service]https://contra.com/s/7lbgEqRc-sap-and-erp-process-consulting-for-warehouse-operations
👉 [Schedule a Call]https://appointment.briskcloudware.com/book.html?r=lLixzwVO
0
53
5 Excel formulas every inventory planner must know
You don't need a fancy WMS to manage inventory well. You need Excel and the right formulas.
After years of managing inventory in FMCG operations, these are the 5 formulas I use constantly — and the ones I build into every custom Excel system I deliver for clients.
1. SUMIFS — your most powerful counting tool
Instead of filtering manually, SUMIFS lets you sum quantities based on multiple conditions at once.
=SUMIFS(quantity_column, SKU_column, "SKU001", warehouse_column, "WH-A")
Use it for: total stock by SKU and location, total dispatched by date range, production output by shift.
2. IFERROR — stop broken formulas from crashing your sheet
When a formula can't find a value it returns an error. IFERROR catches it and shows something cleaner.
=IFERROR(VLOOKUP(A2,data_range,2,0),"Not found")
Use it for: wrapping any VLOOKUP or INDEX/MATCH so your sheet doesn't fill with #N/A errors.
3. INDEX/MATCH — better than VLOOKUP
VLOOKUP breaks when you add columns. INDEX/MATCH never does.
=INDEX(return_column,MATCH(lookup_value,lookup_column,0))
Use it for: pulling SAP data into your planning sheet, matching SKU codes to descriptions, linking sheets without breaking.
4. COUNTIFS — find gaps instantly
COUNTIFS counts rows that meet multiple conditions. Use it to spot where data is missing or incomplete.
=COUNTIFS(status_column,"Pending",date_column,"<"&TODAY())
Use it for: overdue orders, pending GRs, items with zero stock, SKUs not yet received.
5. TODAY() and date logic — automate your daily planning
Stop manually updating dates. TODAY() always returns the current date — build your planning triggers around it.
=IF(reorder_date<=TODAY(),"Order Now","OK")
Use it for: reorder alerts, overdue shipment flags, days-since-last-receipt calculations.
These 5 formulas are the foundation of every inventory Excel system I build. Master them and you can automate 80% of your daily planning without spending a rupee on software.
Need a custom Excel system built around your operation? Check out my services below.
0
61
tentative and current planning Dashboard
0
25
Stop defending Excel. It's costing you more than SAP ever would.
I've seen it too many times.
A warehouse running 3 locations off a shared spreadsheet. 4 versions of the same file. Nobody knows which one is real.
That's not a tool problem. That's a liability.
SAP isn't for everyone — but if your Excel sheet has more than 10 tabs and 3 people editing it, you've already outgrown it.
Here's the honest breakdown:
Excel is fine until:
→ Two people overwrite each other's data
→ A formula breaks and nobody notices for 3 weeks
→ Your auditor asks for a trail and you have nothing
SAP makes sense when:
→ Your ops span multiple sites or entities
→ Finance, procurement, and warehouse need the same data
→ Mistakes have a real cost
The question isn't which is better. It's which one matches where you actually are.
Which one are you using — and are you being honest about whether it's still working?
0
70
This is what almost 7 years of warehouse experience looks like in a single Excel file.
Most businesses think they need expensive software to run a clean warehouse operation.
They don't.
They need the right system.
Over almost 7 years managing large-scale warehouse operations, I built a warehouse operations tool in Excel that significantly reduces manual work and brings everything into one place.
Here is what it does:
Production planning
Pulls SAP data and tracks planned vs delivered quantities. Calculates remaining balance automatically. Reduces the time your team spends chasing numbers.
Pack material ordering
Every label, bottle, and outer case is BOM-linked. When stock drops below the required quantity — the system flags it instantly so you can act before it's too late.
Raw material tracking
Tracks available stock against safety stock and MOQ for every material. Tells you exactly what needs attention and when.
Yes — some manual input is still required.
But that's the point.
This system is built around how real warehouses actually work — not how they look in a software demo.
It gives your team the structure, visibility, and control they need — without replacing their judgment.
If your warehouse is still running on scattered spreadsheets with no structure at all — this is your next step.
📩 DM me and let's build one for your business.
What part of your warehouse operation takes the most manual time right now? Comment below 👇
0
74
3 signs your warehouse is bleeding money — and you don't even realize it.
Most warehouse problems don't show up on your P&L statement.
They hide in plain sight. Quietly draining cash, time, and customers — until one day everything breaks at once.
After 8 years in warehouse and inventory management at P&G, I've seen the same 3 warning signs over and over again:
Sign #1 — Your stockouts are "unexpected"
If you're constantly surprised by empty shelves or unfulfilled orders, your demand forecasting is broken. Stockouts are never random. They are always a system failure. A missed reorder point. A forecast that wasn't updated. A supplier lead time that nobody tracked.
Every stockout is a customer you just handed to your competitor.
Sign #2 — You have "plenty of stock" but can't find what you need
Full warehouse. Zero visibility. This is the deadliest combination in logistics. If your team is spending more than 10 minutes locating an SKU, your WMS and physical layout are not aligned. You're paying for space, labor, and time — and getting chaos in return.
Sign #3 — Your ERP says one thing, your warehouse shows another
This is the most common one I see. When your system data and physical reality don't match, every decision you make is based on a lie. Procurement orders wrong quantities. Planning creates inaccurate forecasts. And the whole supply chain suffers.
The good news?
All 3 of these are fixable — with the right SOPs, proper ERP/WMS synchronization, and a clean inventory planning system.
That's exactly what I help businesses build.
📩 If any of these signs sound familiar, DM me. Let's fix it before it gets worse.
0
83
Raw and Pack material Ordering sheet
0
58
Forecasting and customer trend dashboard
0
62
Inbound creation Tool SAP transaction (NVL31N)
0
69
“Warehouse Transfer Automation Tool (SAP STO)”
0
73