So basically to simplify all this (more for myself), looking at total cost column tells you all costs and all "revenue" (money received), but considering you're only partially selling your inventory the total summed cost column is skewed if you thought of it as profit, as it includes unsold inventory, and that's why you must use an inventory method such that you match exact quantity for buys and sells. Makes sense!