Products Database

This post presents the process of creating a database in excel and graphs to illustrate the data.

The first basic step is to pull the data from the website and enter it in excel, in this case I do it manually.

Now I have added all the sales data. More, I am creating a simple formatting to display in red stock that is below 50 units. This is to make it easier to see what product needs a restock.

Further I added simple formulas between cells to calculate the data for us. At the end of the whole process I placed a picture of all the formulas used in the cells. What's more, in the picture below I've added another formula, which will display in green those products that have exceeded the purchase cost threshold and generate pure profit.

In the images below, you can see the finite database and the formulas that were used. 

The first graph shows the collision between money spent on supplies and current earnings. You can easily see which products have exceeded the cost of purchase.

The second graph shows what actual stock looks like, how much stock has been sold and how much is ready for sale.