Building an Integrated APAC Supply Chain Foundation at Mayoly

Supply chain planning in pharmaceutical operations depends on accurate, timely data. Yet many teams still rely on fragmented spreadsheets and manual consolidation, limiting visibility and slowing decision making.

This was the reality for Mayoly’s APAC Supply & Demand Planning team. Managing monthly sales, inventory, and forecast data across 11 distributor markets became increasingly difficult as the region expanded. As planning cycles grew more complex, the team needed a more reliable way to consolidate information and support regional discussions.

Regional Planning Across Distributor Markets

Mayoly’s APAC team relied on standardized Excel templates submitted by multiple distributors across markets. This approach provided a common reporting structure, but the end-to-end process remained manual, from data uploads and processing to storage in a locally hosted database.

As the number of active markets increased, several constraints became more apparent:

• Heavy dependence on manual effort and individual users

• Delays in producing consolidated views for monthly reviews

• Increased risk of errors affecting forecasts and planning discussions

• Dashboards that were difficult to use during business reviews

Although Power BI reports were already in place, their usefulness was limited by how data was collected, processed, and maintained upstream.

The Need to Rethink the Planning Approach

As manual effort continued to grow, incremental adjustments were no longer sufficient. The APAC team needed a more dependable way to manage planning data across markets without adding burden for local teams.

At this stage, Mayoly engaged Kitameraki to support a broader rework of the planning approach. The focus was not on replacing familiar tools, but on establishing a foundation that could support current operations while remaining workable as the region expanded.

The teams aligned on a set of practical objectives:

• Reduce reliance on manual consolidation and individual users

• Ensure data was available in time for monthly reviews and forecasts

• Create a structure that could support additional distributor markets

• Make reporting easier to use during planning discussions

Meeting these objectives required changes to both the underlying data setup and the way planning information flowed across teams.

Building a Power Platform–Based Planning Foundation

Kitameraki worked with Mayoly’s APAC planners and global IT stakeholders to redesign the supply chain data flow, from distributor submissions through management reporting.

The work replaced a setup where data was stored on a single device with access limited to one user, creating high dependency and risk of data loss or human error. This was transitioned to a centralized, cloud-enabled data architecture, with dashboards designed around real monthly review workflows rather than static reporting outputs.

Governance and structure were introduced to support consistency as the region grew, with changes delivered through clear communication and coordination across regional and IT teams to allow adoption without disrupting ongoing operations.

“This milestone clearly helps us gain efficiency while better supporting teams in their day-to-day decisions and reporting. We were impressed by Kitameraki’s professionalism, patience, and proactive, solution-driven mindset, as well as their best-in-class project management.” — General Manager, APAC, Mayoly

Changes Observed After Implementation

With a more stable regional setup in place, teams spent less time preparing data and more time reviewing outcomes and next steps.

This led to observable changes in how planning work was carried out:

1. A reduction in manual effort, allowing planners to focus more on analysis rather than data preparation

2. More reliable and consistent data inputs for monthly reviews and forecasts

3. Improved visibility across markets, supporting cross-market comparisons and alignment

4. A measurable improvement in productivity compared to the previous manual process

5. A foundation that can support additional distributors and markets without reworking the process

The process moved away from manual consolidation toward a more consistent, repeatable regional setup.

Conclusion

By reducing reliance on manual reporting, Mayoly’s APAC team now operates with a more reliable regional supply chain setup. Teams can focus on reviews, forecasts, and operational decisions rather than data preparation.

This project shows how an integrated foundation, designed around real workflows, can support both day-to-day operations and regional growth.

Looking to Modernize Your Planning with Power Platform?

If your teams are still spending more time preparing reports than discussing them, or if dashboards exist but do not guide decisions, it may be time to revisit the foundation.

Kitameraki works with regional and global teams to turn complex, manual processes into scalable planning platforms. Talk to us to explore what that could look like for your organization.

Contact Us

---

Kitameraki (www.kitameraki.com) is the trusted partner for comprehensive IT Consulting and IT services in Indonesia. With strong focus on IT Solutions, Web Development, Mobile App Development, and Cloud Solutions, we help businesses navigate the ever-evolving digital landscape. Our expertise extends to Cloud Services, Cloud Migration, Data Analytics, Big Data, Business Intelligence, Data Science, and Cybersecurity.