Skip to main content
The Stock-In-Trade (SIT) page provides a comprehensive view of your inventory planning, helping you balance service levels with inventory costs.

​
What is Stock-In-Trade?

Stock-In-Trade represents the inventory held across your distribution network, measured in days of sales. SIMCEL provides two perspectives:
ViewDescription
Unconstrained SITTarget inventory levels without supply constraints
Constrained SITRealistic inventory levels accounting for supply limitations
Toggle between these views using the switch at the top of the page.

​
What you’ll see

​
SIT chart

A visual representation of inventory levels over time. Select your preferred UOM (units, value, etc.) to view the data in the most meaningful way.
Line or bar chart displaying inventory levels (days of sales) over monthly time periods. A UOM selector dropdown is visible for switching between units and value. A toggle at the top switches between Unconstrained and Constrained views.

​
SIT table

A detailed table showing inventory levels grouped by your organizational hierarchy. Expand rows to drill down to individual product and distributor combinations.
Hierarchical table with expand/collapse row controls. Rows group inventory data by organizational hierarchy (Brand, SKU, Distributor). Columns display inventory values per time period. Editable cells are visually highlighted to indicate they can be modified.

​
Calculation logic

​
Actual SIT

For historical periods, SIT is calculated from uploaded data: 
Actual SIT (Days) = Closing Stock Value / (Sum of Sales Out Volume x Product Value per month) x Number of months x 30
Where:
  • Closing Stock Value = from distributor inventory upload
  • Sales Out = from actual sales out upload
  • Product Value = Listed Price or Distributor GSV (per workspace setting)

​
Unconstrained (Future) SIT

For future periods without supply constraints: 
Future Sales In = (Sum of Future Sales Out / (N x 30)) x Future SIT Target
                  - Previous Closing Stock + Future Sales Out

Future Closing Stock = Previous Closing Stock - Future Sales Out + Future Sales In

Future SIT (Days) = Closing Stock Value / (Sum of Future Sales Out x Product Value per month) x N x 30
Where:
  • Future SIT Target = from the distributor SIT target file (editable)
  • N = number of months in the calculation window

​
Constrained (Simulated) SIT

After running a simulation: 
Constrained Sales In = from simulation Demand Fulfillment Metrics

Constrained Closing Stock = Previous Closing Stock - Constrained Sales Out + Constrained Sales In

Constrained SIT (Days) = Closing Stock Value / (Sum of Constrained Sales Out x Product Value per month) x N x 30
  • If sales out for 3 consecutive periods is null, SIT will not be calculated and displays “NAN”
  • Constrained Sales Out is limited to available stock when inventory is insufficient to meet demand
  • SIT values are calculated at month-end only
Top of the SIT page showing a toggle switch with two states: Unconstrained and Constrained. Below the toggle, the SIT chart visually reflects the selected mode, demonstrating the difference in inventory levels between the supply-unlimited and supply-limited perspectives.

​
Editable fields

In the unconstrained view, you can manually adjust:
FieldWhat you can edit
Future Sales InAdjust inbound volumes (boxes or value)
Future Closing StockAdjust target inventory levels
Future SIT TargetSet days of stock targets per distributor-product
If an editable value is “0” at an aggregated level, it cannot redistribute to lower levels (based on child ratio). In this case, edit at the atomic level (Distributor-Product) directly.
If adjustments result in negative numbers, the table displays a warning icon. Address discrepancies before simulating, as negatives are treated as “0” during simulation.

​
Key inventory KPIs

KPIDescription
Unconstrained SITTarget inventory without supply constraints (month-end, days)
Constrained SITExpected inventory with supply constraints (month-end, days)
Average Inventory ValueAverage monetary value of inventory held
Average Inventory VolumeAverage physical quantity of inventory held
DIO (Days Inventory Outstanding)Number of days of sales covered by current inventory
Closing Stock (Gross Value)End-of-period inventory in monetary terms
Closing Stock (Volume)End-of-period inventory in physical units

​
How to use it

  1. Compare constrained vs. unconstrained - Toggle between views to understand where supply constraints impact your inventory
  2. Identify gaps - Large differences highlight areas needing additional supply
  3. Adjust SIT targets - Edit future SIT targets per distributor-product to optimize inventory levels
  4. Monitor trends - Watch inventory over time to prevent stockouts or excess
  5. Check pending tasks - The page shows if pending DRP tasks need to complete before data is fully available