Show Product database

 Product Database (Data+Graph+Chart)

Gathering data of TOP 10 seller products 

Product Database

10 Different items with different stock quantities and different unit/sale prices

To calculate the "Total Cost" we do require to add each cost of products. The same way is shown below.

=(£500+£350+£450+£575+£600+£350+£450+£440+£360+£700) Which gives us £4,775 (Total Cost)

To calculate the "Total Sales" this time we do require to find the total of sales by using the method as before.

=(£560+£270+£540+£675+£580+£480+£600+£560+£490+£800) Which is equal to £5,555 (Total Sales)

To calculate the "Profit" we do have two different ways to calculate it. The first way is to add each product's profit together to see the total profit. Second and the way I followed is simply extracting "Total Costs" from "Total Sales".

=(£5,555-£4,775) That gives us the "£780" (Profit)

On the other hand, before calculating the total, we have to calculate each total cost and total sales.

To calculate the "Each Total Cost", we need to multiply "Stock Quantity" with "Unit Price".

=(10*£50) is equal to "£500" which gives us  the (Total Cost)

Now, that we have "Total Cost", we need to calculate "Total Sales" to be able to move forward.

To calculate the "Total Sales" we use the same path we used for "Total Cost" but instead of multiplying "Stock Quantity" and "Unit Price", we multiply "Stock Sold" and "Sale Price" which is:

=(8*£70) which as expected gives us a total of "£560" (Total Sales)