File:(Google Sheet) Master Sheet Van Wingerden
[url removed, login to view]
Create a formula in the google sheet "Inventory" for each column named (week #). The formula will move inventory from one column to the next based on the time (Sunday evening at 12:00AM PST.) It will also look up the week# according to SKU in the "production" sheet as well as "sales" sheet to add (production) and minus (sales). Additionally, it will remove the number appearing in the production sheet "waste#" column.
The number in the current week then should give us the total inventory we have available
1.) Sheet: Inventory: COL M-BL = The formula in each column will look in previous week# column and move all existing inventory to the current week.
2.) The formula will look up the same SKU and add the number appearing in sheet "Production" in the current week.
3.) The formula will look up the same SKU and minus the number appearing in sheet "Sales" in the current week.
4.) The formula will look up the same SKU and minus the number appearing in the Sheet "Production" in the current week "waste"