Python 毛利率同业对标分析（行业基准导入与偏离预警）

{"type":"doc","content":[{"type":"paragraph","attrs":{"id":"dd5a1d3d-001e-4ed3-bab2-c5a94377359a","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"问题"},{"type":"hardBreak","attrs":{"id":"c6b6c938-3e9b-4ce8-ad8d-5f049382880c"}},{"type":"text","text":"被审计单位毛利率 35%，看着正常，但同行平均才 18%。这种偏离可能是竞争力强，也可能是收入成本错配。用 Python 导入行业基准，自动算偏离度并预警。"}]},{"type":"paragraph","attrs":{"id":"477f48c5-f13f-4b46-83de-16f503a50966","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"示例代码"}]},{"type":"paragraph","attrs":{"id":"a2711a86-3ac6-4fc5-81a7-af98cd196383","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","marks":[{"type":"textStyle","attrs":{"color":"","background":""}}],"text":"plaintext"}]},{"type":"codeBlock","attrs":{"id":"d3bfdb28-c90b-4e65-bb70-eb6c531dadb1","language":"javascript","theme":"atom-one-dark","runtimes":0,"isHoverDragHandle":false,"key":"","languageByAi":"javascript"},"content":[{"type":"text","text":"import pandas as pd\n\ndef gm_benchmark(gm, bench, warn=0.2):\n dev = (gm - bench) / bench\n flag = \"偏离预警\" if abs(dev) > warn else \"正常\"\n return dev, flag\n\nbench = {\"制造业\": 0.18, \"零售业\": 0.12, \"软件业\": 0.65}\ndf = pd.DataFrame({\n \"industry\": [\"制造业\", \"零售业\", \"软件业\"],\n \"gm\": [0.35, 0.13, 0.62],\n})\ndf[\"deviation\"] = df.apply(lambda r: gm_benchmark(r[\"gm\"], bench[r[\"industry\"]])[0], axis=1)\ndf[\"flag\"] = df.apply(lambda r: gm_benchmark(r[\"gm\"], bench[r[\"industry\"]])[1], axis=1)\nprint(df)\n"}]},{"type":"paragraph","attrs":{"id":"8fb0bfce-3f2e-4509-a873-d5ff89a3073a","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"关键点"}]},{"type":"bulletList","attrs":{"id":"75e67a5c-6b17-491c-a916-09ba4b18d274","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"6b406e45-86bb-419c-8451-63c91ce98117"},"content":[{"type":"paragraph","attrs":{"id":"51424a96-6cdd-4f33-892e-9b68b731d2b4","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"偏离度 = (单位毛利率 - 行业基准) / 行业基准；|偏离|>20% 触发预警，阈值可按所内标准调。"}]}]},{"type":"listItem","attrs":{"id":"451fdd9a-1cdb-44eb-8a3c-2bfb6a96ca87"},"content":[{"type":"paragraph","attrs":{"id":"b8d6a675-b6f6-41e0-a80d-af8062a53cf9","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"正向偏离（毛利率过高）和负向偏离都危险：过高看收入虚增或成本少计，过低看减值或费用资本化。"}]}]},{"type":"listItem","attrs":{"id":"48ff57b7-73f6-4ede-805c-8a26c3067679"},"content":[{"type":"paragraph","attrs":{"id":"99fe4877-cb9a-4f8f-a1f1-103b5cb292a8","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"基准来源要可靠（行业协会、上市公司年报均值），自己拍的数没说服力。"}]}]}]},{"type":"paragraph","attrs":{"id":"8dd9cbf6-4233-4d1f-867d-34349caa4e8c","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"小结"},{"type":"hardBreak","attrs":{"id":"5f749fb8-9a4f-4f2a-8224-ee9a3b8394fe"}},{"type":"text","text":"毛利率不能只看绝对值，要放进行业坐标系。偏离超阈值即亮灯，给分析程序一个量化抓手。"}]},{"type":"horizontalRule","attrs":{"id":"ad8cac71-6df8-4b8c-b6d6-4e2bf58fa721","isHoverDragHandle":false}},{"type":"paragraph","attrs":{"id":"5abe3eee-d24c-494d-a22e-aa27bf658960","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"你做对标时基准数据从哪来？遇到过“高毛利是合理的”被误判吗？评论区说。"}]},{"type":"paragraph","attrs":{"id":"00112d7d-ebc4-468d-9401-285bf3960e12","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"如果有用，点赞收藏关注，留下审计难题。下期预告：截止性测试自动化（收入费用跨期抽凭）。"}]},{"type":"paragraph","attrs":{"id":"f6823a42-e39f-4685-94d8-8296b64db5c7","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"会计师事务所的一名注册会计师"}]}]}