Factory Delivery and Material Planning Report - Excel Project
This project is designed as a comprehensive reporting system for an organization's delivery and material planning from raw source data file.
This report has been meticulously crafted with the incorporation of powerful data analysis tools, such as Power Query, along with fundamental VBA techniques. It serves as an indispensable resource for organizations equipped with ERP software, enabling precise and efficient scheduling of product deliveries and material procurement.
View project details video:
Project Screenshots:
 |
| Source File Selection |
 |
| Day Plan |
 |
| Short List Generator |
 |
| Month Plan |
 |
| PM Plan |
 |
| FG Stock |
 |
| Detail View |
 |
| Pipeline List |
 |
| Forecast |
 |
| PG List |
 |
| PM List |
 |
| Schedule List |
 |
| Power Query Window 1 |
 |
| Power Query Window 2 |
 |
| Source File 1 |
 |
| Source File 2 |
 |
| Source File 3 |
 |
| Source File 4 |
 |
| Source File 5 |
 |
| Source File 6 |
 |
| Source File 7 |
 |
| Source File 8 |