How to Build an Inventory Tracker with Automatic Reorder Alerts in Google Sheets

When I worked in the production area of a packaging plant, stock was counted by hand and we usually found out an item was missing when the line stopped. This is the spreadsheet I wish we had. It works