“Real-Time Inventory and Production Dashboard for Effective Planning and Analysis”

Am looking to dashboard either using excel or power BI. The dashboard purpose is to show following using charts, trends .. :
1- live daily inventory level with minimum and maximum constraints.
2- the planned sales figures for coming month. 3- the planned production daily rate for coming month. 4- figures to present the actual sales compared with planned
5- the dashboard shall be easy to be updated daily