Creative Information Tech

challenge

Our developers worked as the sub on rolling-out enterprise level SharePoint Infrastructure to a multi-international organization. We developed search based solutions to access data. We built a scale out version of electronic document management system to support an up to 4TB content database on SharePoint 2013.

  • Improve sales and operations and production planning:

    The teams focused their efforts on a few of the highest-value S&OP levers in order to review the current planning process, identify gaps in the planning infrastructure and analytically understand demand and supply variability.

  • Determine the right inventory level:

    With hundreds of medications in the market, Pharm Ltd. needed a proper method to predict and manage their inventory. Using a mean absolute percentage analysis (MAPE), the teams defined appropriate levels for raw materials and finished products by mapping actual versus forecasted sales on the most important SKUs.

  • Optimize the supply chain for perfect order planning:

    The diagnostic determined the stressors that affected sales and service levels. The teams focused on resolving issues related to higher-than-normal back-orders and lead times, which stressed the entire supply chain and led to delays in medications reaching consumers.

solution

The solution WP consulting came up with combined cutting edge technology with real world practicality. Everyone knew that the systems had to be updated, the real challenge was updating them without disrupting the whole organization in a negative way. The solution was to introduce proper workload management done through computers, while providing mobile platforms to the stakeholders.

This allowed the workers to be involved in the job instead of feeling like they had been made redundant by technology.

results

Arguzo employees are now more empowered; Arguzo also has the benefit of generating reports instantaneously whenever needed. They can now make decisions on the fly based on the latest real time data.

The effort vastly improved the company’s planning and execution functions, created and implemented a new stock policy that accounted for specific SKUs and key variables, streamlined the order preparation process and reduced distribution transport times.

By the numbers, the effort:

  • Reduced lead time by 43%
  • Decreased variability by 50%
  • Lowered the risk of back-order by 95%
  • Increased stock for finished goods by 10%