Example Spreadsheets in Excel– A simple example spreadsheet in excel. Too simple but does its job. In the first column, we have the list of Products. In the second, the total amount you have of each product and in the third its price.
Now, the last column, Maxima Gain, this last column is automatic and calculates the values of Quantity and Price and multiplies it with each other and the row of the product. The maximum profit is the maximum you can earn and sell all quantities of X product.
The formula is fairly simple = (B2 * C2), and then dragging it down.