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 "SIT" icon on the left-hand side of the screen to open the "Stock In Trade Planning" 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 scenarios:
SIT chart
In the SIT chart, you can compare:
- SIT (Bar - In days)
- Sales In (Dotted line - In either Value of Unit)
- Sales Out (Solid line - In either Value of Unit)
- Closing stock (Dashed line - In either Value of Unit)
SIT table
The SIT table allows the user to edit the scenario's SIT, Closing stock, and Sales In by segment.
Like the Demand Table, the SIT Table also can 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 Closing Stock (CLS), Sales Out (S.Out), and Sales In (S.In). Sales Out 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 Sales Out: Planned downstream sales from distributor to market, prior to any restriction from stock availability.
- Unconstrained Sales In: 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 Sales Out 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 Sales In: Actual feasible supply to distributor based on inventory and replenishment limits.
- Constrained Sales Out: 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 bolded and highlighted in blue indicate they can be edited. You're able to adjust the following:
- SIT (Days)
- Closing Stock (Unit/Value)
- Sales In (Unit/Value)
To edit a number, simply click on it. An edit box will appear for you to make changes.
- Sales out 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 are able to configure the SIT metrics (SIT, Closing Stock, Sales In) across a continuous range of months by entering a single value in a selected month and applying that value 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 (SIT values, Closing Stock, Sales In) is being quickly set. For example, “SIT values”
- The edited month. For example, “2025-04-01”
- The ending month of the plan. For example, “2026-12-31”
- Click “Ok” to confirm your choice and let the system recalculate everything to align with your new settings