中文版：请帮我制作一套库存管理Excel系统，用于管理商品、原材料或办公物资的库存。

建立“商品资料”“入库记录”“出库记录”“库存明细”“库存预警”和“库存分析”工作表。

商品资料包括商品编码、商品名称、规格、类别、供应商、单位、采购价格、安全库存和仓库。

通过入库和出库数据自动计算当前库存数量和库存金额。

当库存低于安全库存时自动标记为“库存预警”，当库存数量为零时标记为“缺货”。

请增加库存周转率、库存金额、月度出入库数量和库存变化趋势分析。

所有商品编码必须保持唯一，并使用数据验证减少人工录入错误。

英文版：Create an inventory management Excel system for products, raw materials, or office supplies.

Create worksheets for product master data, inbound records, outbound records, inventory details, inventory alerts, and inventory analysis.

The product master should include product code, product name, specification, category, supplier, unit, purchase price, safety stock, and warehouse.

Automatically calculate current inventory quantity and inventory value based on inbound and outbound transactions.

When inventory falls below the safety-stock level, automatically mark it as a low-stock alert. When inventory reaches zero, mark it as out of stock.

Add inventory turnover rate, inventory value, monthly inbound and outbound quantities, and inventory trend analysis.

Keep product codes unique and use data validation to reduce manual-entry errors.

该提示词已在以下工具中验证有效：ChatGPT、Claude、Gemini、Copilot、WPS AI