SECOND EXPERIENCE IN INDEPENDENT CONSULTING
November 6, 2026
4 min read
English
85 views
Professional space
#independentconsulting
Less info
More info
Although I had already done some independent consulting work earlier in my career, 2015 gave me the chance to launch my second formal project. My first had been right after graduating, when I worked with a facilities management team to build a balanced scorecard using best practices in information management.
This time around, I learned that the owner of a medium-sized retail chain in Peru, operating several shops across Lima, was struggling with inventory control and urgently needed a reliable way to track stock movement. To strengthen our approach and move beyond a basic freelance role, I brought in a former MBA classmate who specialised in project management and supply chain operations.
We started by running scope definition meetings with the owner and key managers. Together, we set our main goal: creating automated alerts whenever stock discrepancies popped up in stores. The business operated a central warehouse alongside small retail shops that kept fast-moving items in tiny, dedicated storage areas.
On paper, the process seemed straightforward:
Stock was bought abroad and imported into Peru.
Shipments arrived at a transit warehouse, were logged into the logistics system by product code, and moved to the central warehouse.
Items were dispatched to shops based on sales demand, with every outbound movement logged in the system.
However, because the shops lacked proper storage rooms, deliveries were handled informally. Once stock was logged as received, sales staff could request items for display or sale, and logistics supervisors would record the dispatch. But because actual retail sales were never entered into any system, it was impossible to tell whether an item had been sold, was still on display, or had been thrown away due to damage.
We identified two major issues behind these stock discrepancies:
Delays in logging delivered stock: Logistics staff were frequently pulled away from inventory duties to help sales teams during busy hours.
No way to track actual sales: Sales transactions were captured on paper, making it impossible to reconcile sold items against available stock.
The first issue came down to workload. Looking closely, we saw that logistics supervisors, who should have been managing stock, were regularly stepping in to help sales assistants. We ran a quick queueing analysis and found that while customers waited two to three minutes to be served, actual service times took between 11 and 13 minutes.
Sharing this with management, we agreed to audit the sales process itself. We looked at manual tasks, including paper orders sent to the central warehouse and handwritten receipts. When handling large orders for wholesale buyers, the heavy workload led to frequent recording errors. This caused rework, lengthened wait times, and created mistakes on receipts that scrambled the inventory system.
To tackle the second issue, my partner and I sat down to break down how stock actually moved. We started with a basic inventory rule:
Final inventory = Initial inventory + Inflows - Outflows
This only works if there are no errors or losses. Since discrepancies were happening constantly, we adapted the formula to account for variances, breaking outflows down into sales, damages, and routine dispatches:
Final inventory = Initial inventory + Merchandise receipts - Sales - Damages - Merchandise outflows +/- Variances
Isolating the variance gave us:
Variances = Initial inventory - Final inventory + Merchandise receipts - Sales - Damages - Merchandise outflows
To make this formula work in practice, we needed to digitise sales and damages between stock counts, while keeping tight control over deliveries and dispatches. We looked at having sales staff partially log sales and stock levels, but decided it added too much friction to their day-to-day work. Instead, we considered two options: replacing paper logs with a mobile app used directly by cashiers, or hiring a dedicated operator to handle data entry and stock counts.
The company liked our analysis and agreed to test a pilot Visual Basic application connected to their existing logistics system. The app would track movements, sales, and shrinkage for a specific group of high-risk products, supported by a newly hired team member dedicated to data entry. We built a cloud-hosted MySQL database to continuously run the variance equation. Whenever a calculation didn't balance out to zero, the system automatically generated an alert that managers could view immediately.
Just as we finished building the pilot and moved into testing, my partner accepted a new job opportunity that meant he could not stay on full-time. We continued working together until testing was wrapped up and the final report was delivered. The client was delighted with the results and the progress made in controlling their inventory.
Reflecting on the project later, my partner and I agreed that independent consulting holds enormous potential, especially for small and medium businesses. We decided that when the right moment comes, we'd love to team up again and take the concept further by launching our own consulting start-up.