Term definitions
- SIT (Stock In Trade): The stock level (in days) for the specified distributor and product in the given period end.
- Closing Stock: refers to the distributor’s inventory records at the period's end (Either in Unit or Value).
- Sales-Out: Sales from the Distributors to their customers (Pharmacies, Hospitals…) - can also be referred to as Secondary Sales (Either in Unit or Value).
- Sales In: Sales to the distributors - can also be referred to as Primary Sales (Either in Unit or Value).
- Distributor GSV: This is the price at which the company sells the product to its distributors.
- Customer GSV: The price at which the distributor sells the product to its customers.
Navigation
Click on the Stock-In-Trade option under the IBP section on the left side panel to navigate the SIT page.
On this page, there are 3 main widgets:
- Page Filter: Replicates the functionality of the Demand Planning Page. However, the Customer filter is replaced by the Distributor filter.
- SIT Chart
- SIT Table
Similar to the Demand Planning page, the SIT page offers the same functionalities for interacting with scenarios:
SIT chart
In the SIT chart, you can compare:
- Stock Days (Bar - In days)
- Primary Sales (Dashed line - In either Value of Unit)
- Secondary Sales (Dashed + Dotted line - In either Value of Unit)
- Stock Value (Solid line - In either Value of Unit)
SIT table
The SIT table allows the user to edit the scenario's Stock Days, Stock Value, and Primary Sales by segment.
Like the Demand Table, the SIT Table can also drill down for detailed data on finer segments.
By default, you can only see and edit the SIT Target.
When you click on the drop-down button, you can also see the value of the Stock Value, Secondary Sales, and Primary Sales. However, Secondary Sales is not an editable value in this screen as it is coming from the demand planning page.
SIT Modes: Unconstrained vs Constrained
SIMCEL operates in two distinct SIT planning modes, each reflecting a different stage of the scenario lifecycle and the nature of data used in the calculations:
1. Unconstrained Mode
This is the default mode when a scenario is created but before simulation is triggered. All KPIs in the SIT page are calculated based on:
- Unconstrained Secondary Sales: Planned downstream sales from distributor to market, prior to any restriction from stock availability.
- Unconstrained Primary Sales: Planned inbound supply from upstream (e.g. corporate to distributor), without taking into account supply constraints.
- Gross Value basis for financials — discounts, rebates, and other trade terms are not applied yet.
In the Unconstrained Mode all metrics are editable except the Secondary Sales that is populated from the Demand Plan.
2. Constrained Mode
This mode becomes available after a simulation is run. The simulation aligns product availability (based on inventory and supply plan) with demand, resulting in constrained flows. KPIs are recalculated based on:
- Constrained Primary Sales: Actual feasible supply to distributor based on inventory and replenishment limits.
- Constrained Secondary Sales: Expected downstream sales based on Sales In and available inventory at distributor.
- Still computed on a Gross Value basis in the SIT module (even if trade terms are simulated elsewhere).
In the Constrained Mode none of the metrics are editable.
Unconstrained Mode - Adjusting Metrics for a specific scenario (SIT Table)
In the SIT Table, numbers are highlighed with a subtle grey background indicating they can be edited. You're able to adjust the following:
- Stock Days (Days)
- Stock Value (Unit/Value)
- Primary Sales (Unit/Value)
To edit a number, simply click on it. An edit box will appear for you to make changes.
- Secondary Sales is configured on the Demand Planning Page using events. Thus, editing these figures directly on this page is not permitted.
- Adjustments made by the user cannot be undone.
Editing SIT target / Closing Stock
When you create a scenario, SIMCEL will use the standard SIT targets (defined per Product-Distributor) and compute the other metrics accordingly.
When you edit the SIT target / Closing Stock for a specific segment, the system will carry out these steps:
- Calculate the related Closing Stock / SIT target, and Sales In at that level using the new SIT value.
- Update the Closing Stock, Sales In, and SIT at that level for the following months.
- Re-calculate the Closing Stock values for the child levels based on the % increase/decrease of the direct parent
- Re-calculate the impact on Sales In and SIT for the child level, including the following months
- Adjust the Closing Stock and Sales In values for the parent levels to ensure they are equal to the total of their direct children.
- Re-calculate the SIT for the parent level.
Example
Editing Sales In
When you edit the Sales In for a specific segment, the system will carry out these steps:
- Calculate the related Closing Stock and SIT at that level using the new Sales In value.
- Update the Closing Stock, Sales In, and SIT at that level for the following months.
- Re-allocate the Sales In values for the child levels based on the % increase/decrease of the direct parent
- Re-calculate the impact on Closing Stock and SIT for the child level.
- Adjust the Sales In and Closing Stock values for the parent levels to ensure they are equal to the total of the child levels.
- Re-calculate the SIT for the parent level.
Example
Quick SIT Metrics setting
In the SIT table, you can configure SIT metrics (Stock Days, Stock Value, Primary Sales) across a continuous range of months by entering a single value in a selected month and applying it forward through the remaining Plan timeline.
In order to do a quick SIT metrics setting for a scenario:
- Select the starting month and the metric for quick editing
- Click on the number within that month and metric. An edit box will appear for you to make changes.
- After you have entered the new number, look to the left of the edit box to find a checkmark with a right arrow. Click on it
- A dialogue will appear, with:
- The SIT metric (Stock Days, Stock Value, Primary Sales) is being quickly set. For example, “Stock Days”
- The edited month. For example, “2026-04-01”
- The ending month of the plan. For example, “2027-03-31”
- Click “Apply” to confirm your choice and let the system recalculate everything to align with your new settings