Inventory data sheet excel

I need dashboard of inventory analysis daily basis include all locations data inventory for Resturent detial include item
consumption.purchase in and out transfer in and out minimum stock daily wastage daily consumption stock in hand value daily reconcile production and consumption