Daily Stock Check
Run every morning on a scheduled cadence. Pull current on-hand quantities from Airtable, compare against reorder points, and post a full stock-health digest to Slack so the team starts the day with a clear picture.
- Pull the full active-SKU list from Airtable, including on-hand quantity, reorder point, safety-stock floor, preferred supplier, and unit cost for each record.
- For each SKU, compare on-hand quantity to the reorder point.
- Pull the average daily demand for each SKU from the Google Sheets demand history tab (rolling 30-day average).