Product Inventory Management Sheet
Product Inventory Management Sheet
— Prompt —
Develop an Excel spreadsheet to manage inventory for a business with [insert number] of products. Track product name, SKU, current stock, reorder level, and supplier. Highlight items below reorder threshold. Include a restock log sheet and summary dashboard with low-stock alerts.
Why It Works
Real-time alerts and supplier linkage ensure streamlined stock control and reduce out-of-stock risk.
Example Output
A shop sees 'Coffee Beans' highlighted for reorder and instantly finds the supplier contact in the same sheet.