Job description
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.
