This project involved large dataset analytics of over 38,000 articles. We collected the 12-month historical values of sales, prices, and costs of all products. The pricing optimizing algorithm was built using VBA. The data was partitioned into several hundred categories for ease of analysis and price change modifications.
The result was a 4% increase in total gross margin and a 5% gain in sale volume.
Data Analytics, SQL Queries, Excel VBA Programming, Statistical Analysis
What you don’t measure, doesn’t get done the way you intend or need to. This is one of the greatest challenges in defining metrics for any business.
Projects in this arena seek to define the metrics that are aligned with the strategic goals of the client. Leading and lagging indicators are defined with a clear line-of-sight to each corporate objective. The work is complemented by a communication plan and rollout.
Learn More Here.
Management Mentoring, Process Engineering, Business Analysis, Communication Plan
In this project, we helped a client simplify the dashboard scheme they had developed organically over time. There was a lack of consistency in visualizations, no standard nomenclature and labeling, and no hierarchy of metrics.
Managers had decided to put all data up front simply because they could.
Simplicity and clear depiction of the most important indicators are what the front page of all dashboards strives for. Your dashboard ought to focus you on the important and urgent.
Power BI or Tableau, Process Engineering, Policy Deployment, Data Visualization
This project required extracting inventory, purchasing, sales, and accounting data to define the algorithm per product (38,000 SKUs) to ensure the most appropriate permanent inventory target per item while maintaining and ITR > 20
A high ITR ensures healthy cash flow for any business. New purchasing policies were implemented to allow for large purchases of inventory to improve the contribution margin on selected items. Significant profitability and cash flow improvements were delivered.
Data Analytics, Sales Demand, Inventory Process, Supply Chain Management, SQL Queries, Accounting
Onboarding is not an event.
Onboarding is a process whose objective is to guide new employees through all the administrative processes efficiently, instruct them on fundamental operational priorities, and show them how they fit into the culture of the corporation. It serves as a welcome into the business as much as “let’s get you going” approach.
We design experiences for onboarding processes that demonstrate your values and culture so that new employees can more rapidly become productive.
Learn More Here.
Human Resources, Communication Plan, Process Engineering.
Supervision and leadership are not the same things. It is best to prepare those on the front line of processes to manage resources effectively and the objectives of the company in mind.
There is a clear distinction between a non-supervisory role and a management role. Our approach goes beyond orientation.
Our approach is an onboarding process designed for each business for first-time supervisors and managers. It includes diagnostics, simulations, workshops, and dialogue. We offer an optional 1-on-1 debrief for each participant and follow-ups on a regular basis.
Learn More Here.
Human Resources, Curriculum Development, Onboarding, Personnel Assessments
Our experience spans over 15 years in food retailing. Our Category Analysis and Management are independent of any brand. However, we take into account market information about each player in the category, their appeal, and their product diversity when recommending settings.
But fundamentally, our goal is to optimize the category profit margin while balancing the need to support volume demand per article.
Our projects begin with the evaluation of how a client has defined a category. Once this is established, the analysis requires integrating sales volumes, pricing, contribution margin per article, profitability per brand, expected future demand, contractual obligations for space, and color scheme.
The objective is to balance the need to support large sales volume items and the high-profit items within the display.
Learn More Here.
Analytics, SQL Queries, Statistical Analysis, Demand Modeling, Margin Optimization, Retail Set-up
Web Applications or Process Workflows. What comes first?
In many situations, applications do not necessarily align perfectly with the way a process flows on the floor. The options are:
- Spend resources customizing the application to match the workflow
- Redefine the workflow to match the steps in the application
- Live with the mismatch
It is never a simple answer. Return on Technology (ROT) is the principle that guides us when recommending and helping customers align their applications with their workflows. The bottom line is that we want our client’s work to be efficient and effective.
Process Engineering, Applications Management, IT Solutions