# Excel Modelling Consultant - Skincare Product NPD/EPD Process

> Activate Talent · Philippines (Remote) · Full-time · Posted 2026-01-07

**Workplace:** remote

**Department:** AT1C

## Description

**NPD / EPD Commercial Gate Tool Developer (Excel-Based)**

**REMOTE**

**FULL-TIME**

### About the Role

We are redesigning our **New Product Development (NPD) and Existing Product Development (EPD) operating system** and are seeking an experienced specialist to build a **robust, Excel-based Commercial Gate Tool** to support consistent, high-quality decision-making across **Gate 1, Gate 2, and Gate 3**.

The **process architecture and governance model are already defined**. This role exists to close the tooling gap by designing and delivering a **practical, user-friendly Excel framework** that enables commercial evaluation, scenario analysis, and cross-functional alignment.

This is a **long-term, high-impact role** focused on delivering a tangible, business-critical tool — not ongoing operational ownership.

### What You’ll Do

### Tool Design & Build

-   Design and build an **Excel-based Commercial Gate Tool** covering:

-   Kick-off
-   Gate 1
-   Gate 2
-   Gate 3

-   Create a clear, logical structure that aligns with existing NPD / EPD governance.

### Commercial Modeling & Automation

-   Integrate **automated calculations**, including:

-   Target COGS derived from RRP and margin targets
-   Volume, pricing, and margin scenarios

-   Build **scenario-handling logic** to support:

-   Different sourcing routes
-   Project types
-   COGS and cost structure assumptions

### Supply Chain Handover & Outputs

-   Design **clean, usable Gate 3 outputs** for Supply Chain, including:

-   Shopping lists / component requirements
-   PO spend timing
-   Cash flow forecasts

### Usability & Governance

-   Apply formulas and macros where appropriate — creating a tool that is **robust but not over-engineered**.
-   Focus on:

-   Usability and clarity
-   Version control
-   Ease of adoption across functions (Commercial, Supply Chain, Finance, Marketing).

-   Ensure the tool reflects **how real commercial decisions are made** — pragmatic, transparent, and actionable.

### Collaboration & Iteration

-   Work closely with business and operations leads to:

-   Gather feedback
-   Iterate quickly
-   Align the tool to real-world use cases

## Requirements

### Ideal Profile

-   **Expert-level Excel modeller** with strong command of:

-   Advanced formulas
-   Scenario logic
-   Macros / automation

-   Proven experience building:

-   Commercial decision-making tools
-   Governance or stage-gate frameworks

-   Strong commercial acumen:

-   Margin targets
-   Cost trade-offs
-   Operational decision-making

-   Comfortable working independently in an **ambiguous, build-from-scratch environment**.
-   Experience in **FMCG, retail, or product development** environments strongly preferred.

## Apply

[Apply at Activate Talent](https://apply.workable.com/careersactivatetalent/j/75EB087EBF/apply)

---
Powered by [Workable](https://www.workable.com)