Control Stock Excel. So to reduce the errors and increase efficiency you can start to control your inventory with the help of an excel. Arrive category wise current month sales and stocks available.
Create a sheet and name it as dashboard. Now we need to create an excel dashboard for our inventory control template. Daily inventory is equal to initial stock plus daily production minus daily sales.
Initial stock is equal to the previous day s inventory.
Whenever you decided to create an inventory control sheet in excel first of all you have to select. In the inventory tab the template auto generates initial stock and daily inventory. Create a sheet and name it as dashboard. Draw text box and type available stock level.
