中文版：请帮我制作一套项目成本管理Excel表格。

建立“项目预算”“实际成本”“成本分类”“项目利润”和“成本分析”工作表。

预算表包含项目名称、成本类别、预算金额、负责人和预算日期。

实际成本表包含日期、项目、成本类别、供应商、金额、付款状态和备注。

自动计算每个项目的预算金额、实际成本、成本差异、成本偏差率、项目收入、项目利润和利润率。

当实际成本超过预算时自动进行预警。

按照人工、材料、采购、差旅、外包、管理费用等类别进行成本分析，并找出成本超支最大的项目和费用类别。

最终输出项目成本排名、预算执行率和项目利润分析。

英文版：Create a project cost management Excel workbook.

Create worksheets for project budgets, actual costs, cost categories, project profitability, and cost analysis.

The budget sheet should include project name, cost category, budget amount, owner, and budget date.

The actual cost sheet should include date, project, cost category, supplier, amount, payment status, and notes.

Automatically calculate budget amount, actual cost, cost variance, variance percentage, project revenue, project profit, and profit margin for each project.

Automatically flag projects where actual costs exceed the budget.

Analyze costs by labor, materials, procurement, travel, outsourcing, administrative expenses, and other relevant categories. Identify the projects and expense categories with the largest overruns.

Provide project cost rankings, budget utilization, and project profitability analysis.

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