{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["二级利润测算","三级利润测算","合并利润","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"二级利润测算","index":0,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,1,1,5],[2,0,2,5],[5,0,5,1],[6,0,6,5],[11,0,11,1],[12,0,12,5],[13,0,13,1],[14,0,14,1],[15,0,15,5],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,0,19,5],[20,0,20,1],[21,0,21,1],[22,0,22,5],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[36,0,36,1],[36,3,36,4],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,5],[35,0,35,1],[35,3,35,4]]}
["合同利润测算表"]
["合同名称","北京市顺义区农业农村局OA办公系统建设项目 "]
["合同收入"]
["客户名称","合同类型","合同含税金额","税率","合同不含税金额","销项税金",null,null,null,"合同收入",540000]
["顺义农业农村局","软件开发服务",400000,0.06,{"$f":"C5/(1+D5)","v":377358.49056603771},{"$f":"C5-E5","v":22641.509433962288},null,null,null,"自有人员成本预算","无"]
["收入小计",null,{"$f":"SUM(C5:C5)","v":400000},null,{"$f":"SUM(E5:E5)","v":377358.49056603771},{"$f":"SUM(F5:F5)","v":22641.509433962288},null,null,null,"外包外采成本预算",140000]
["分包成本（预算）",{"$nulls":8},"费用预算",0]
["供应商名称","合同类型","合同含税金额","税率","合同不含税金额","进项税金",null,null,null,"利润",247516.61]
["四维","售前服务",80000,0.06,{"$f":"C9/(1+D9)","v":75471.698113207545},{"$f":"C9-E9","v":4528.3018867924548},null,null,null,"利润率",0.65590000000000004]
[null,"软硬件购置",60000,0.13,{"$f":"C10/(1+D10)","v":53097.345132743365},{"$f":"C10-E10","v":6902.654867256635}]
[null,null,0,0,{"$f":"C11/(1+D11)","v":0},{"$f":"C11-E11","v":0}]
["直接成本小计",null,{"$f":"SUM(C9:C11)","v":140000},null,{"$f":"SUM(E9:E11)","v":128569.04324595092},{"$f":"SUM(F9:F11)","v":11430.95675404909}]
["增值税"]
["税金分类",{"$nulls":4},"应交增值税"]
["增值税",{"$nulls":4},{"$f":"F6-F12","v":11210.552679913199}]
["内部交付（预算）"]
["交付部门名称","交付内容",null,null,"金额"]
[{"$nulls":4},0]
[]
["资金占用费"]
["占用资金",null,"占用时间（月）","占用费率（月）","资金占用费金额"]
[null,null,null,0.01,{"$f":"A22*C22*D22","v":0}]
["管理费用"]
["费用分类",null,null,null,"预计费用金额"]
["城建税、附加税、地方税",null,null,null,{"$f":"F15*0.1","v":1121.0552679913199}]
["印花税",null,null,null,{"$f":"(E12+E6)*3/10000","v":151.77826014359658}]
["办公费"]
["差旅费"]
["招待费"]
["售前投入"]
["项目人员薪酬"]
["其他费用",null,null,null,0]
["项目费用小计",null,null,null,{"$f":"SUM(E25:E32)","v":1272.8335281349164}]
["项目成本费用合计",null,null,null,{"$f":"E33+E12+E22+E18+E19","v":129841.87677408583}]
["合同利润"]
["利润",null,{"$f":"E6-E34","v":247516.61379195188},"财务利润（不含售前）",null,{"$f":"E6-E34+E30","v":247516.61379195188}]
["利润率",null,{"$f":"C36/E6","v":0.65591902654867251},"利润率",null,{"$f":"F36/E6","v":0.65591902654867251}]

{"sheet":"三级利润测算","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,1,1,5],[2,0,2,5],[6,0,6,1],[7,0,7,5],[12,0,12,1],[13,0,13,5],[14,0,14,1],[15,0,15,1],[16,0,16,5],[17,0,17,1],[18,0,18,1],[19,0,19,5],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[32,0,32,1],[32,3,32,4],[33,0,33,1],[33,3,33,4],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,5]]}
["合同利润测算表（三级公司）"]
["合同名称","数字菜田项目信息化工程监理服务采购项目（信息化工程）"]
["合同收入"]
["客户名称","合同类型","合同含税金额","税率","合同不含税金额","销项税金"]
["福通互联","技术咨询",100000,0.06,{"$f":"C5/(1+D5)","v":94339.622641509428},{"$f":"C5-E5","v":5660.3773584905721}]
[{"$nulls":4},{"$f":"C6/(1+D6)","v":0},{"$f":"C6-E6","v":0}]
["收入小计",null,{"$f":"SUM(C5:C6)","v":100000},null,{"$f":"SUM(E5:E6)","v":94339.622641509428},{"$f":"SUM(F5:F6)","v":5660.3773584905721}]
["分包成本（预算）"]
["供应商名称","合同类型","合同含税金额","税率","合同不含税金额","进项税金"]
["---","服务",null,null,{"$f":"C10/(1+D10)","v":0},{"$f":"C10-E10","v":0}]
[{"$nulls":4},{"$f":"C11/(1+D11)","v":0},{"$f":"C11-E11","v":0}]
[{"$nulls":4},0,0]
["直接成本小计",null,{"$f":"SUM(C10:C12)","v":0},null,{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0}]
["增值税"]
["税金分类",{"$nulls":4},"应交增值税"]
["增值税",{"$nulls":4},{"$f":"F7-F13","v":5660.3773584905721}]
["资金占用费"]
["占用资金",null,"占用时间（月）","占用费率（月）","资金占用费金额"]
[null,null,null,0.01,{"$f":"A19*C19*D19","v":0}]
["管理费用"]
["费用分类",null,null,null,"预计费用金额"]
["城建税、附加税、地方税",null,null,null,{"$f":"F16*0.1","v":566.03773584905719}]
["印花税",null,null,null,{"$f":"(E13+E7)*3/10000","v":28.30188679245283}]
["办公费"]
["差旅费"]
["招待费"]
["售前投入"]
["项目人员薪酬"]
["其他费用"]
["项目费用小计",null,null,null,{"$f":"SUM(E22:E29)","v":594.33962264151}]
["项目成本费用合计",null,null,null,{"$f":"E30+E13+E19","v":594.33962264151}]
["合同利润"]
["利润",null,{"$f":"E7-E31","v":93745.283018867922},"财务利润（不含售前）",null,{"$f":"E7-E31+E27","v":93745.283018867922}]
["利润率",null,{"$f":"C33/E7","v":0.99370000000000003},"利润率",null,{"$f":"F33/E7","v":0.99370000000000003}]

{"sheet":"合并利润","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,1,1,5],[2,0,2,5],[4,0,4,1],[5,0,5,5],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[12,0,12,5],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[28,0,28,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,5],[27,0,27,1]]}
["合同利润二三级合并测算表"]
["合同名称","数字菜田项目信息化工程监理服务采购项目（信息化工程）"]
["合同收入"]
[null,null,"合同含税金额","税率","合同不含税金额"]
["收入小计",null,{"$f":"二级利润测算!C6","v":400000},null,{"$f":"二级利润测算!E6","v":377358.49056603771}]
["分包成本"]
[null,null,"合同含税金额","税率","合同不含税金额"]
["第三方分包",null,{"$f":"二级利润测算!C10","v":60000},{"$f":"二级利润测算!D10","v":0.13},{"$f":"SUM(C8/(1+D8))","v":53097.345132743365}]
["第三方分包",null,{"$f":"二级利润测算!C11","v":0},{"$f":"二级利润测算!D11","v":0},{"$f":"SUM(C9/(1+D9))","v":0}]
["第三方分包",null,{"$f":"二级利润测算!#REF!","v":{"$error":"#REF!"}},{"$f":"二级利润测算!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C10/(1+D10))","v":{"$error":"#REF!"}}]
["第三方分包",null,{"$f":"二级利润测算!#REF!","v":{"$error":"#REF!"}},{"$f":"二级利润测算!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C11/(1+D11))","v":{"$error":"#REF!"}}]
[]
["管理费用（二、三级合并）"]
["费用分类",null,"二级费用","三级费用","预计费用金额合计"]
["内部交付",null,{"$f":"二级利润测算!E18+二级利润测算!E19","v":0},null,{"$f":"SUM(C15:D15)","v":0}]
["城建税、附加税、地方税",null,{"$f":"二级利润测算!E25","v":1121.0552679913199},{"$f":"三级利润测算!E22","v":566.03773584905719},{"$f":"SUM(C16:D16)","v":1687.0930038403772}]
["印花税",null,{"$f":"二级利润测算!E26","v":151.77826014359658},{"$f":"三级利润测算!E23","v":28.30188679245283},{"$f":"SUM(C17:D17)","v":180.0801469360494}]
["办公费",null,{"$f":"二级利润测算!E27","v":0},{"$f":"三级利润测算!E24","v":0},0]
["差旅费",null,{"$f":"二级利润测算!E28","v":0},{"$f":"三级利润测算!E25","v":0},0]
["招待费",null,{"$f":"二级利润测算!E29","v":0},{"$f":"三级利润测算!E26","v":0},0]
["售前投入",null,{"$f":"二级利润测算!E30","v":0},{"$f":"三级利润测算!E27","v":0},{"$f":"SUM(C21:D21)","v":0}]
["项目人员薪酬",null,{"$f":"二级利润测算!E31","v":0},{"$f":"三级利润测算!E28","v":0},0]
["其他费用",null,{"$f":"二级利润测算!E32","v":0},{"$f":"三级利润测算!E29","v":0},0]
["项目费用小计",null,{"$f":"二级利润测算!E33","v":1272.8335281349164},{"$f":"三级利润测算!E30","v":594.33962264151},1867.1731507764264]
["资金占用费用",null,{"$f":"二级利润测算!E22","v":0},{"$f":"三级利润测算!E19","v":0},0]
["项目成本费用合计",null,null,null,{"$f":"E24+E25+E15+E8+E9+E10+E11","v":{"$error":"#REF!"}}]
["合同利润"]
["利润",null,{"$f":"E5-E26","v":{"$error":"#REF!"}},"利润（不含售前）",{"$f":"E5-E26+E21","v":{"$error":"#REF!"}}]
["利润率",null,{"$f":"E28/E5","v":{"$error":"#REF!"}},"利润率",{"$f":"E28/E5","v":{"$error":"#REF!"}}]

{"sheet":"Sheet1","index":3,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,7,3,7],[4,7,5,7],[19,1,19,5],[2,1,3,1],[4,1,5,1],[2,2,3,2],[4,2,5,2]]}
[]
[null,"序号","项目内容","分项内容","数量","单价（元）","总价（元）","备注"]
[null,null,null,"安装费",150,270,40500]
[null,null,null,"调试、试运行费",150,150,22500]
[null,null,null,"安装费",4100,76.7,314470]
[null,null,null,"调试、试运行费",4100,147.30000000000001,603930]
[null,6,"通信SIM卡",null,4250,52,221000]
[null,7,"接线盒",null,3100,27.95,86645]
[null,8,"插座",null,3100,15,46500]
[null,9,"空气开关",null,3100,38.369999999999997,118947]
[null,10,"开关",null,38,60.5,2299]
[null,15,"人工挖基坑（电线杆基础）",null,164.75,173,28501.75]
[null,16,"人工挖基坑（气象站基础）",null,37.5,173,6487.5]
[null,17,"独立基础",null,37.5,695.5,26081.25]
[null,18,"电源架设",null,4090,15.95,65235.5]
[null,19,"电源架设冷棚施工",null,7500,7.88,59100]
[null,20,"棚内电源架设施工",null,69000,4.3499999999999996,300150]
[null,21,"电杆架设",null,659,767,505453]
[null,22,"PVC线管",null,13500,32.4,437400]
[null,"合计",{"$nulls":4},{"$f":"SUM(G3:G19)","v":2885200}]

{"sheet":"Sheet2","index":4,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,1,20,5],[4,1,14,1],[4,2,14,2],[4,7,14,7]]}
[]
[null,"序号","项目内容","分项内容","数量","单价（元）","总价（元）","备注"]
[null,2,"自动化环境控制系统安装及调试",null,10,7665,76650,"一拖一"]
[null,3,"水肥一体化控制系统安装及调试",null,4,13800,55200,"一拖一"]
[null,4,"农田环境小型气象站安装及调试","立杆",150,786,117900,"含设备费1011000元；安装费40500元、调试、试运行费用22500元。"]
[null,null,null,"太阳能供电系统",150,980,147000]
[null,null,null,"温湿度监测传感器",150,561,84150]
[null,null,null,"光照检测传感器",150,562,84300]
[null,null,null,"200万摄像头",150,562,84300]
[null,null,null,"采集集控终端箱",150,45,6750]
[null,null,null,"采集集控终端-数据集中采集模块",150,700,105000]
[null,null,null,"采集集控终端-数据集中通讯模块",150,700,105000]
[null,null,null,"采集集控终端-数据集中存储模块",150,645,96750]
[null,null,null,"避雷针",150,225,33750]
[null,null,null,"开发、集成、组装费",150,974,146100]
[null,5,"大棚环境监测设备安装及调试","监测设备",4100,961,3940100,"其中含设备费3940100元，安装费314470元、调试、试运行费603930元。"]
[null,11,"磁盘阵列",null,1,147200,147200]
[null,12,"网络机柜",null,1,3800,3800]
[null,13,"操作台",null,1,3200,3200]
[null,14,"交换机",null,1,5250,5250]
[null,"合计",{"$nulls":4},{"$f":"SUM(G3:G20)","v":5242400}]