Hardware Inventory Optimization
about case
Laying the Groundwork for Product
At Wrkspot, hardware inventory was tracked inconsistently, leading to lost devices, audit issues, and operational inefficiencies. I led the creation of an automated workflow to manage the entire device lifecycle — from ordering to damage — which later became the foundation for Wrkspot’s client-facing Asset Management product.
Key Contributions:
01
Audited inventory workflows and diagnosed root causes
02
Built a Google Sheets tracker with change logs and approval flows
03
Worked with Finance to align physical inventory and PO history
04
Standardized processes across offshore and U.S. fulfillment teams
05
Proposed long-term vision for productizing the internal workflow
The Challenge
No system existed — only ad hoc spreadsheets and verbal updates. This meant:
Frequent device loss and miscounts
No real-time visibility or lifecycle tracking
Financial and logistical mismatches led to delays and reordering issues
Solution:
A centralized inventory management workflow that tracked the entire hardware lifecycle, automated inventory controls, and provided real-time visibility across Finance, Fulfillment, Customer Success, and Operations teams.
What We Set Out to Solve
Replace manual processes with structured, automated workflows
Eliminate inventory-related errors and improve traceability
Provide reliable data for Finance and Accounting teams
Design a scalable system with product potential
Discovery Highlights
1. Interviewed Finance, Fulfillment, and Customer Success teams
2. Identified root issues in ordering, labeling, and tracking
3. Audited previous quarter's inventory to locate recurring errors
4. Mapped inventory workflows from procurement through deployment
Workflow Creation
1. Built a centralized dashboard to track:
• Ordered stock
• Active deployment
• Damaged goods
• Reorder points
2. Implemented change logs and auto-alerts for reorder triggers
3. Added team-specific filters for Finance, Customer Success, and Fulfillment
Enablement & Adoption
01
Trained U.S. and offshore teams on using the new system
02
Delivered audit-ready, version-controlled templates
03
Aligned logic with QuickBooks and financial reporting standards
04
Established standardized inventory governance processes
Key Metrics
90% reduction in inventory-related issues
Inventory reconciliation time reduced from days to minutes
Internal workflow evolved into client-facing Asset Management product
What We Delivered
Inventory Errors
Reduced by 90%
Reconciliation Time
Reduced from days to minutes
Audit Readiness
Achieved full PO traceability
Team Adoption
U.S. and offshore teams onboarded
Product Foundation
Evolved into Asset Management feature
Supporting Artifacts
Google Sheets Inventory Tracker Template
Notion Workflow Diagram
Version Control Guide & Change Log Protocol
MVP Asset Management Product Proposal
Audit Sheet Format for Accounting Integration
What Worked
1. Converted an inefficient internal process into a scalable, adopted workflow
2. Cross-functional collaboration solved pain points across multiple departments
3. Internal innovation served as a springboard for a full-fledged product
4. Created operational visibility that improved decision-making
What Could Be Improved
1. Push for a lightweight backend application earlier
2. Integrate inventory tracking with invoicing and reporting tools
Personal Growth:
This project reinforced how operational excellence can drive product development. It taught me how to take messy systems, align stakeholders, and deliver tools that scale into customer-facing value.
Project Overview
The Problem & Objectives
Research & Execution Process
Results & Deliverables
Retrospective
