中文版:我希望你能扮演一名财务分析师。请使用公式在这个数据表中计算每个产品的利润率。利润率的计算公式为:(销售收入 - 成本)/ 销售收入 * 100%。请将计算结果添加到数据表中,并按利润率从高到低进行排序。请分析哪些产品利润率最高,哪些最低,并给出优化建议。
英文版:I want you to act as a financial analyst. Please use formulas to calculate the profit margin for each product in this data table. The formula for profit margin is: (Sales Revenue - Cost) / Sales Revenue * 100%. Add the calculation results to the data table and sort them from highest to lowest profit margin. Analyze which products have the highest and lowest profit margins and provide optimization suggestions.
该提示词已在以下工具中验证有效:ChatGPT、Claude、Excel Copilot、Kimi

◯ 评论 0