Introduction:

Terminology:

• Unconstrained Sales In (Distributor Demand): Represents the total demand from distributors without considering any supply constraints. This reflects the ideal scenario where the supply fully meets the distributor's demand.

• Constrained Sales In: Reflects the projected sales to distributors after accounting for supply constraints such as production capacity, available stock, and product shelf-life.

• Supply Plan: The projected volume of products to be supplied from various sources during the planning period.

• Constrained Sales Out: Represents the sales to end customers, considering the available supply from distributors after accounting for constraints.

Logic Flow:

1. Supply Plan Integration:
• The simulation begins by uploading the planned shipment quantities. These quantities establish the inflow to the company's warehouse stock for the simulation period.

2. Initial Stock:
• The initial stock level for the simulation is calculated by using the closing stock of the previous period, either from actual data or from the previous plan if actual data hasn’t been uploaded yet. For example: the February 2024 plan would utilize the closing stock figures from January 2024 either from the actual closing stock if it was uploaded or from the January 2024 plan if actual data is not yet available.

3. Sales and Inventory Simulation:
• The simulation operates at the most detailed level, considering individual products and distributors
• Monthly Calculation: For each month, the tool adds the supply quantity to the beginning inventory.
• Demand Fulfillment: The resulting inventory level is compared with the Unconstrained Sales In.
• Constraint Application: If the inventory level meets or exceeds the unconstrained demand, the Constrained Sales In equals the Unconstrained Sales In. Otherwise, the Constrained Sales In is limited to the available stock.
• Warehouse Closing Stock: The closing stock for the month is calculated as (Opening stock + Supply quantity - Constrained Sales In).

4. Metrics Recalculation:
• With the new Constrained Sales In, the distributor’s constrained metrics are recalculated, including Closing Stock, Stock In Trade, and Sales Out.
• This ensures that all metrics accurately reflect the impact of supply constraints on distributor demand fulfillment.

Simulation Output in SIMCEL Saas

1. Simulation Sales In:
• Contains the Unconstrained Sales In data for each Product-Distributor per month.
• This data comes from the SIT calculations. In case the Sales In is negative (due to the SIT parameters) it will be considered as Null.

2. Demand Fulfillment Metric:
• Provides a breakdown of distributor demand into individual orders.
• Includes information on the company's warehouse serving capability, indicating which orders were fulfilled in full and which ones faced partial fulfillment or stock outs.

3. Detailed Inventory Metrics:
• Offers a comprehensive record of inventory levels within the company’s warehouse throughout the simulation period.
• Includes monitoring of opening and closing stock levels, including stock movements due to quantities received from suppliers, quantities shipped to distributors, and any adjustments made due to products exceeding their shelf life.

4. Atomic KPIs:
• This file encompass all the granular data used to compute the KPIs of the scenario. I would also includes some master information such as product details, distributor information, and location data.
• Allows for ad hoc analysis and the creation of custom reports to monitor specific aspects of supply chain performance.