Inventory Sheets Automation with Alerts

I need to turn my existing stock spreadsheet into a robust, self-maintaining inventory management tool. Everything will live in Google Sheets (with the option to port to Excel if you think VBA brings extra value), and the priority is an automated restocking alert that fires whenever any SKU dips below a threshold quantity I can define per item.

The current file already holds SKU, description, on-hand, and reorder point columns, but the formulas are basic and the layout is clunky. I’d like you to:

• Refactor sheets so data entry is fool-proof, separating raw transactions from calculated summaries.
• Build the trigger logic—when on-hand ≤ threshold, the sheet should highlight the row and send an email or popup alert (Apps Script or equivalent macro).
• Create a clean dashboard that shows low-stock items, recent movements, and a simple chart of inventory status at a glance.
• Document the workflow so I can adjust thresholds or add SKUs without breaking anything.

Strong Google Apps Script, advanced formulas (ARRAYFORMULA, QUERY, INDEX/MATCH), and a good eye for visual dashboards are essential. If you prefer to demo first in Excel with macros, that’s fine as long as the final deliverable runs smoothly in Sheets.

Once the sheet can alert me reliably at the threshold level and the dashboard reads clearly, I’ll consider the project complete.