I’ve set something like this up with basically two tables in a base.
The first table was items with locations (widget 1 in rack A, shelf 2, bin 2). This table also had values that were updated from the second table.
The second table had actions (remove/add). Anytime an item(s) was added or removed from inventory, it was logged along with quantity. There was a formula field that would make the value positive or negative. This allowed me to use a roll up in the first table that would keep track of all the removals or additions.