Embedded Files
Improving Operations & Visibility for a Growing Snacking Business
Improving Operations & Visibility for a Growing Snacking Business
Designed a lightweight order and inventory workflow system to improve operational visibility and sales tracking.
The Challenge
The Challenge
A growing snack business entering the Mumbai market had:
one field sales person
multiple products
no structured operational system
Orders were managed verbally, inventory tracking was inconsistent, and the business owner lacked daily visibility into sales activity and stock movement.
The Solution
Designed a Google Sheets-based order and inventory management system including:
Mobile-friendly order entry form for field sales operations
Automated inventory and order calculations
Daily dashboard for sales and stock visibility
Structured operational tracking workflow
Result
✓ Improved operational visibility for daily sales activity
✓ Simplified order and inventory tracking
✓ Reduced dependency on manual coordination
✓ System running successfully for 30+ days
Tools Used
Google Sheets
Mobile Order Forms
Spreadsheet Automation Formulas
Page updated
Report abuse