How to format spreadsheet to accommodate 1 item with multiple buyers

[petartist1]

Hello and Thank-you all for looking at my question.

I’m not sure how to word my question to get a proper answer.

I want to do some inventory “control”

I have a spreadsheet made out and have a formula that deducts everytime an item is sold.
My problem is, how do I deduct with multiple buyers for 1 product.
Apple buyer bought 10 apples out of 100…. Formula deducts 10 with a balance of 90.
Triangle buyer bought 5 apples, restaurant bought 22 etc.
How do I format my spread sheet to accommodate one item with multiple buyers that will deduct everytime the item is sold?

 

[Dendro]

create a table with buyers in the rows in the first column.The columns of the table would hold the amount of each product bought. At the bottom set a formula to sum the amounts of each product, and use this to deduct from your stock.
f.i.:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Buyers[/TD]
[TD]Apples[/TD]
[TD]Tomatoes[/TD]
[TD]Pineapple[/TD]
[/TR]
[TR]
[TD]Apple buyer[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Triangle buyer[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Restaurant buyer[/TD]
[TD]22[/TD]
[TD]30[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD="align: right"]SUM:[/TD]
[TD]65[/TD]
[TD]30[/TD]
[TD]14[/TD]
[/TR]
</tbody>[/TABLE]









[TABLE="width: 500"]
<tbody>[TR]
[TD]Stock of fruit
[/TD]
[TD]initial stock
[/TD]
[TD]sold
[/TD]
[TD]New stock
[/TD]
[/TR]
[TR]
[TD]Apples
[/TD]
[TD]100
[/TD]
[TD]65
[/TD]
[TD]=[@initial stock]-[@sold]
[/TD]
[/TR]
[TR]
[TD]Tomatoes
[/TD]
[TD]100
[/TD]
[TD]30
[/TD]
[TD]=[@initial stock]-[@sold]
[/TD]
[/TR]
[TR]
[TD]Pineapple
[/TD]
[TD]100
[/TD]
[TD]14
[/TD]
[TD]=[@initial stock]-[@sold]
[/TD]
[/TR]
</tbody>[/TABLE]