Inventory Control Dashboard

Centralized dashboard tracking inventory availability, document status, yard distribution, turnover, and operational blocks to give sales, operations and management a single source of truth.

Project Overview

This dashboard unifies inventory data from NetSuite, yard sheets, title records, inspections, and deal pipelines. It eliminates conflicting spreadsheets and manual reconciliations by providing real-time visibility of availability, blocks, aging, and documentation issues.

Main Features

  • Real‑time inventory availability synced across sales, operations, and funding.
  • Status logic eliminating duplicates and incorrect "available" units.
  • Automated blocks for missing titles, inspections, paperwork, or deal conflicts.
  • Drill‑through pages for VIN‑level documentation and history.
  • Filters by yard, entity, status, model year, price range, and documentation status.
  • Aging analysis to surface slow‑moving units and financial exposure.
  • Export‑ready structured tables for sales and compliance teams.

Key Components

Status Matrix

Defines unit status (available, sold, in deal, blocked, missing docs, in transit) using automated business rules.

Title & Documentation Tracker

Identifies missing titles, inspections, registrations, or compliance paperwork and tracks aging.

Yard & Location View

Shows distribution of units across yards, highlighting overcrowding, bottlenecks and transit delays.

Operational Impact

This dashboard removed conflicting spreadsheets and manual inventory checks. It exposed hidden blocks, corrected dozens of incorrect availability statuses, and reduced sales delays caused by missing titles, expired inspections, or units stuck off‑yard. Managers gained accurate yard distribution, real turnover rates, and visibility over financial bottlenecks. Operations now make decisions with validated, clean, real‑time data.

Sample Pictures