Samir Saci

Samir Saci

Business Optimization

1 story

Illustration showing the relationship between inventory, working capital, and payment collection in cash flow management. The image depicts inventory in a warehouse connected to working capital, which is then linked to the collection of customer payments. It highlights the flow of money and goods, essential for managing inventory and liquidity in small businesses.
Samir Saci

Samir Saci

Supply Chain Optimization

15 stories

Illustration showing the relationship between inventory, working capital, and payment collection in cash flow management. The image depicts inventory in a warehouse connected to working capital, which is then linked to the collection of customer payments. It highlights the flow of money and goods, essential for managing inventory and liquidity in small businesses.
A large central icon of a data warehouse is placed in the center, representing a storage system. It is connected to various systems on the left, including ERP, Warehouse System, and Transportation System, which flow data into the warehouse. On the right, analysis processes and visualized reports (a pie chart and icons for harmonization and data insights) represent how data is processed and transformed into actionable intelligence. This main component of business intelligence for supply chain.
A visual flowchart representing a sustainable supply chain optimization process. On the left, “Import Data” shows three factories labeled Factory 1, 2, and 3. The middle section, “Select Objective,” highlights options to minimize waste, cost, or CO2 emissions. On the right, “Visualize Results” displays a map and a pie chart to illustrate the optimal solution. This emphasizes balancing sustainability and cost-efficiency.
Samir Saci

Samir Saci

Sustainability

13 stories

Three factories compared on three environmental factors: water usage, waste management, and CO2 emissions. Each factory is rated with stars on each factor, with one to five stars used for evaluation. The visual represents sustainable sourcing considerations for supply chain optimization, highlighting differences in supplier environmental performance used for sustainable sourcing with Python.
A visual representation of a circular economy model, showing the production, delivery, collection, and recycling process. Clothing is produced in a factory, transported to a warehouse, delivered to retail stores, and after customer use, collected for recycling. The collected clothes are returned to the factory for reuse and recycling, completing the circular loop of production and recycling.
Samir Saci

Samir Saci

Generative AI

2 stories

A diagram showing the relationship between Excel file input, data analysis, and communication processes. It depicts a workflow automated with a custom GPT where an Excel file leads to the automation of decision-making processes for supply chain optimization. The output involves a GPT called Supply Chain nalyst performing classification tasks, with the final result displayed in an understandable format for communication.
This diagram depicts a supply chain control tower with five major elements boosted by LLMs using LangChain with Python. Starting from the top, we have factories, a warehouse, delivery trucks, and a store. Below that, a question flow appears, transitioning through machine learning systems and SQL databases before reaching an AI agent. This image represents the data pipeline and decision-making process from raw supply chain data to AI-driven analytics for optimized operations.
Samir Saci

Samir Saci

Productivity

5 stories

Diagram illustrating how to connect to an API using Google Sheets without coding. On the left, an icon representing Google Sheets connects via a red line to an API icon in the center. Another red line connects the API icon to a JSON response icon on the right. This flow shows how Google Sheets can retrieve data from an API and return it in JSON format, demonstrating a no-code method for API integration.
Diagram showing the automation process for creating warehouse labels using Python Pillow. It starts with an Excel file containing location and product data. A Python script reads the data to create barcodes and adds a location number and stickers. The labels include different arrows and color-coded information, designed for warehouse signage of various storage locations.
A flowchart illustrating the automation of PowerPoint slide creation for supply chain operations using Python. The process starts with 5 weeks of operational activity data from a warehouse database. SQL queries extract prepared order lines, which are processed by Python scripts to calculate KPIs. The output is a PowerPoint report showing warehouse workload and order profiles per week.
Samir Saci

Samir Saci

Automation (RPA)

12 stories

Flowchart showing the process of automating video editing with Python. The raw video is processed by muting the background music and cutting the video into shorter clips. Each short video is then paired with text-to-speech comments, creating three distinct clips, ‘Short 1’, ‘Short 2’, and ‘Short 3’, each with its corresponding comment.
SAP Automation for Retail
SAP Automation of Product Listing for Retail
Samir Saci

Samir Saci

Warehouse Operations

11 stories

A warehouse floor layout is shown with aisles and a path marked for an order picker. The diagram illustrates a strategy for optimizing order batching by reducing the distance walked during the picking process. There are multiple aisles labeled A1 through A20, and the picker’s start point is highlighted along with a path that traverses various aisles to retrieve items. The image aims to show how different strategies can improve productivity by minimizing walking distance between picking locations
Improve Warehouse Productivity using Spatial Clustering with Python. A visual representation of a warehouse layout with aisles labeled A01 to A19. The image demonstrates the concept of spatial clustering for warehouse productivity. Red dotted clusters group picking locations, marked with coordinates (xi, yi), indicating proximity within a defined distance threshold. The goal is to reduce the walking distance of warehouse operators by clustering orders with nearby picking locations.
Improve Warehouse Productivity using Pathfinding Algorithm with Python
Samir Saci

Samir Saci

Demand Forecasting

3 stories

A grocery store shelf filled with various dairy products, including milk, yogurt, and beverages.
This infographic illustrates the key features for improving retail unit sales forecasting using machine learning. In the center, “Retail Sales” is highlighted, connected by arrows to several features. To the left, a stock-out sign asks if the store faced stock-out recently. A sales quantity chart asks for the maximum sales in the last “n” days. A price tag icon prompts for recent pricing changes, and a closed sign queries if the store was closed. Lastly, a sales trend chart asks for the sales.
Samir Saci

Samir Saci

Visualization & Business Intelligence

7 stories

A geographic map displaying a road transportation network in China with nodes connected by lines representing Full Truck Load (FTL) routes. The visualization includes route paths with metrics like delivery count, cost per ton, and truck size generated with Python. The map helps assess performance across different routes and locations. This visualization is useful for optimizing transportation efficiency and cost.
A flow diagram titled “Build Interactive Charts using Flask and D3.js.” It illustrates the process of creating dynamic, interactive visuals for e-commerce sales analytics. The left side shows an icon labeled “Datasets” with a chart and an arrow pointing to a central box that contains the “JS” and “Python Flask” logos, representing the use of JavaScript for datasets and Python Flask for backend support. The diagram highlights the process of converting raw datasets into interactive visualizations
The image shows a supply chain sustainability report illustrating CO2 emissions from different transportation methods. A distribution center supplies goods to customers through three routes: (1) via road (120 km), air (1450 km), and road again (700 km); (2) directly by road for 200 km; and (3) through road, sea, and road again. Each mode of transportation highlights the distances, representing the CO2 emissions linked to the transportation network’s sustainability calculated with Python.
Samir Saci

Samir Saci

Transportation Operations

7 stories

A geographic map displaying a road transportation network in China with nodes connected by lines representing Full Truck Load (FTL) routes. The visualization includes route paths with metrics like delivery count, cost per ton, and truck size generated with Python. The map helps assess performance across different routes and locations. This visualization is useful for optimizing transportation efficiency and cost.
A diagram illustrating the process of building a shipment tracking tool using a Telegram bot with Python. The image shows a truck driver icon on the left, a Telegram logo in the center, and a smartphone on the right displaying a Telegram chat. Red arrows indicate the communication flow from the driver to the Telegram bot and then to the user’s smartphone. This visual represents how a Telegram bot can be used to track shipments and provide real-time transportation visibility.
Build a GPS Routing API with Python Flask
Samir Saci

Samir Saci

Linear Programming

12 stories

A diagram showing different aspects of the workforce planning problem, including time constraints, tasks planning, schedule constraints, workload forecasting, and workforce planning. The diagram outlines how these factors interact to optimize workforce management with Python.
A graphic showing how to maximize bakery profitability by selecting the right items to sell. Three bakery items are listed: Cake (profit: 6€, preparation: 95 min), Croissant (profit: 0.9€, preparation: 55 min), and Sandwich (profit: 4.4€, preparation: 12 min). The graphic highlights the differences in profit margins and preparation times, helping business owners prioritize higher-margin, less time-intensive products to improve overall business profitability with Python.
A diagram illustrating the last-mile delivery process for e-commerce optimization using Python. A truck is shown delivering parcels to a warehouse, from which a delivery person on a scooter distributes packages to multiple locations. Dotted lines connect the scooter to several drop-off points marked with question marks, representing unknown delivery destinations. The graphic emphasizes the process of organizing delivery routes to minimize the number of drivers needed for parcel delivery.
Samir Saci

Samir Saci

Logistic Performance Management

4 stories

A flowchart titled “Import Data, Select Objective, Visualize Results” shows a three-step process for supply chain optimization. The process begins with “Import Data” featuring a table icon, followed by “Select Objective” with a target icon. Below, three objectives are listed: minimize waste (factory icon), minimize cost (warehouse icon), and minimize CO2 emissions (truck icon). The final step is “Visualize Results” with icons representing a world map and data charts.
A diagram showing four icons representing the workflow for creating an operational dashboard. The first icon is the Excel logo, representing the input data source. The second is the Python logo, indicating data processing with Python. The third is the DataPane logo, a tool for deploying dashboards. The fourth is a sample bar chart showing a visualized output. The image represents a simplified architecture of reporting and dashboarding for e-commerce logistics using Python and DataPane.
A comparison timeline showing both the actual and target timelines for logistic performance. The “Actual Timeline” is at the top, with white dots marking key events like picking, packing, shipping, and delivery. Below, the “Target Timeline” aligns these events with the expected timeline. This chart visually contrasts actual performance against target performance, highlighting gaps between expected and real operational timings.
Samir Saci

Samir Saci

Logistics Continuous Improvement

3 stories

A visual representation of supply chain process optimization, featuring two red forklifts unloading a large red shipping container marked ‘TEX’ on a warehouse floor. The title reads ‘Supply Chain Process Optimization,’ with a subtitle describing how linear programming can be a powerful tool for a supply chain continuous improvement engineer. The image emphasizes the importance of optimizing warehouse and logistics operations in the supply chain.
Samir Saci

Samir Saci

Lean Six Sigma

5 stories

A diagram showing the process to evaluate the impact of warehouse operator training on productivity using Kruskal Wallis Test with Python. Two groups of operators are randomly selected: one group consists of trained operators, and the other group consists of untrained operators. The productivity of both groups is measured using stopwatches, aiming to determine whether training has a significant impact on operator productivity.
An infographic explaining the application of the Central Limit Theorem for process improvement in returns management. The image has three sections: (1) Assumption of a normal distribution (N(σ, μ)) for the number of items per return carton, (2) Calculation of the probability of receiving between n1 and n2 items per carton, and (3) Estimation of the workforce needed for returns management. The graphic includes icons for data distribution, a work desk for processing returned items, and workers for
A diagram illustrating the “Minimum Bonus Problem.” The title asks, “What is the minimum bonus level needed to reach 75% of your productivity target?” Three rows show warehouse operators being randomly selected, each row with a worker icon holding a money bag. Arrows point from these workers toward stopwatch icons labeled “Productivity Target?”. Use of Kruskal Wallis Test with Python to evaluate how different bonus levels impact operator productivity, specifically aiming to achieve the target.
Samir Saci

Samir Saci

Inventory Management

5 stories

A matrix for statistical product segmentation, which categorizes products based on demand variability (vertical axis) and economic value classification (horizontal axis). Products are classified into three groups: “High Importance” with high demand variability and high economic value (A category), “Stable Demand” with low demand variability (B category), and Low Importance with low economic value and low demand variability (C category). It highlights the need to focus on high-importance products
Inventory Management for Retail — Deterministic Demand
A three-panel chart showing inventory management with stochastic demand with Python. The top chart (red) displays demand fluctuations following a normal distribution over time. The middle chart (blue) depicts replenishment activity occurring when inventory falls below a certain threshold. The bottom chart (green) shows inventory levels decreasing and replenishing in cycles. The right side highlights key concepts: normal demand distribution, (s,Q) order policy, and replenishment with lead time.
Samir Saci

Samir Saci

Top Supply Chain Analytics Writer — Follow my journey using Data Science for Supply Chain Sustainability 🌳 and Productivity ⌛ https://samirsaci.com/about