Inventory database

We have product A in stock in quantity of 100, the employee has assembled 15 pieces of product A by which 85 pieces remain to be assembled.

Starting data:

1. stock - 100

2. folded - 15

3. to be assembled - 85

The employee folded an additional 2 pcs. He increased Compounded to 17 and reduced item 85 to 83. The warehouse remained unchanged. (All changes occurred only after modification of "Submitted 17"). Adding +2

A customer arrived bought 2 pcs. When the 2 pcs went out of stock, the warehouse changed to 98 and to assembled remained unchanged. (All changes occurred only after the modification of "Compounded at 15"). Subtract -2

We need a sheet in which the employee changes only the value of "Compound" and the Magazine and To Compound columns will automatically calculate themselves. Final file in excel, working file attached.