I'll try to type this out first, will provide a spreadsheet later if needed. I'll have to build it in a sharable format.
If I sell 100 items (100 line entries, multiple items per line) that have varying selling prices as well as costs and units sold I end up with varying gross profit per line...