Coil Inventory Dashboard

I work in a metal manufacturing facility and would like to track thru a dashboard with charts our inventory by size, gauge, cost, days in inventory and more.