Harness the power of Lido and create an inventory dashboard in minutes. Enter your details below to get started!
Some of the KPIs you can use to monitor your inventory are the following:
Stock to Sales Ratio: the ratio of stock available for sale versus the stock that has been sold
Sell-through rate: compares the inventory that enters your store and the inventory that you sell within a period of time
Inventory turnover ratio: how fast the inventory is “turned” or sold over a time period
On-time orders: the percentage of the time that customers receive their orders on time
Rate of returns: the percentage of shipped items that are returned to you
Cost of Carrying Inventory: the percentage representing cents per dollar that is spent on inventory overhead each year
Here are the steps in setting up a dashboard in Lido:
Step 1: Create Lido Account
Sign up through either Google authorization or by specifying a username and a password.
Step 2: Connect data sources to Lido
This could be a database where your inventory is tracked or through an integration for your warehousing company or 3PL.
Clicking Data on the upper-left corner of Lido to select the source.
Follow the instructions on entering access info and selecting the data columns to import in the Dataset Editor. Once you have finished selecting your data, click Save dataset & edit view in the top right corner. The data is now loaded to your Lido spreadsheet.
First set up the formulas for the inventory-related KPIs. Lido functions are similar to that of Google Sheets, so you can apply to Lido what you have learned in the tutorials in this site.
After loading the data, click the Dashboard on the top of the Lido spreadsheet, then click the Components tab on the right side. Drag-and-drop components and add data to them.
Once you have finished constructing your report, click Preview on the upper-right corner to see how it will look once deployed.
Share your dashboard with team members and company executives so you stay on top of your inventory.