Inventory Tracking & Analytics System
Budget: ₹12,500 – ₹37,500 INR
I run a warehouse where every item sits on a clearly numbered rack and many products leave the floor as packed bales. I need a complete stock-control solution that can live either in a standalone application or an advanced, well-structured Excel workbook—whichever you feel delivers the cleanest workflow and fastest user adoption.
Core functions I must see working:
• Real-time rack-wise stock list that tells me exactly what is physically on hand.
• A packed-bale register that stores destination and handling instructions alongside each bale number.
• Daily report that flags any quality or SKU that sold out in the last 24 hours.
• Automated analytics highlighting top sellers, slow movers and the exact “age” of every item in days.
• Barcode generation and scanning links so staff can add, move, or dispatch stock with a handheld reader.
Because I am open on platform, please explain in your detailed project proposal why your chosen tech—whether VBA-driven Excel, Power BI integration, Python/Flask, Access, or a lightweight web app—best fits the brief, how it will scale, and what hardware or licences (if any) I should budget for.
Deliverables I will use to sign off the job:
1. Working inventory file/app populated with sample data for all above functions.
2. Clear user guide (screenshots or short screencast welcome).
3. One live hand-over session to make sure barcode scanners, dashboards and export routines run smoothly.
If your proposal maps each feature to a timeline and shows past work on similar warehouse or retail systems, you’ll stand out.
Core functions I must see working:
• Real-time rack-wise stock list that tells me exactly what is physically on hand.
• A packed-bale register that stores destination and handling instructions alongside each bale number.
• Daily report that flags any quality or SKU that sold out in the last 24 hours.
• Automated analytics highlighting top sellers, slow movers and the exact “age” of every item in days.
• Barcode generation and scanning links so staff can add, move, or dispatch stock with a handheld reader.
Because I am open on platform, please explain in your detailed project proposal why your chosen tech—whether VBA-driven Excel, Power BI integration, Python/Flask, Access, or a lightweight web app—best fits the brief, how it will scale, and what hardware or licences (if any) I should budget for.
Deliverables I will use to sign off the job:
1. Working inventory file/app populated with sample data for all above functions.
2. Clear user guide (screenshots or short screencast welcome).
3. One live hand-over session to make sure barcode scanners, dashboards and export routines run smoothly.
If your proposal maps each feature to a timeline and shows past work on similar warehouse or retail systems, you’ll stand out.