Ravi Sir's Cards › Excel
Inventory and Warehouse Management System in Excel (card 2 of 2)
Revision card 2 for Inventory and Warehouse Management System in Excel: Closing stock: =C5+D5-E5 gives 60; Average daily use: =E5/Setup!$B$5 gives 7.1; Days of cover: =IFERROR(F5/H5,999) gives 8.5. Includes an example data table.
Read card text
What this card says
2 for Inventory and Warehouse Management System in Excel: Closing stock: =C5+D5-E5 gives 60
Average daily use: =E5/Setup!$B$5 gives 7.1
Days of cover: =IFERROR(F5/H5,999) gives 8.5. Includes an
Example
data table
Learn this in the lesson: Inventory and Warehouse Management System in Excel: Stock In, Stock Out, Days of Cover, Reorder, ABC and Challan