{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["BI功能清单","Sheet3"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"comments":1,"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":"BI功能清单","index":0,"n_rows":174,"n_cols":14,"rows_kept":174,"cut":false,"hidden":false,"merged":[[1,1,8,1],[9,1,73,1],[74,1,103,1],[104,1,120,1],[121,1,133,1],[1,2,8,2],[10,2,65,2],[66,2,69,2],[70,2,73,2],[74,2,75,2],[76,2,79,2],[80,2,85,2],[87,2,89,2],[90,2,101,2],[104,2,107,2],[108,2,111,2],[112,2,115,2],[116,2,117,2],[118,2,120,2],[121,2,126,2],[127,2,129,2],[130,2,133,2],[10,3,28,3],[29,3,35,3],[36,3,58,3],[59,3,65,3],[138,3,156,3],[158,3,162,3],[164,3,168,3],[158,5,159,5],[63,6,64,6],[150,6,155,6],[62,8,65,8],[58,13,62,19]]}
["序号",null,"模块","功能","功能点细分","是否保留","备注","时间（天）"]
[1,"数据资源整合及梳理","数据资源整合","财务系统现用版",null,"√"]
[2,null,null,"LFS系统",null,"√"]
[3,null,null,"仓库系统",null,"√"]
[4,null,null,"原货代系统",null,"√"]
[5,null,null,"财务系统（旧版cloud）",null,"√"]
[6,null,null,"财务系统（原版）",null,"√"]
[7,null,null,"oa系统",null,"√"]
[8,null,null,"自助联机分析模板",null,"√"]
[9,"经营分析","经营分析驾驶舱","公司经营分析驾驶舱",null,"√"]
[10,null,"经营规模","货代业务分析","各业务类型业务量分析","√"]
[11,null,null,null,"整箱订舱操作分析","√"]
[12,null,null,null,"作业环节货量结构分析","√",null,null,null,"结算时效表"]
[13,null,null,null,"流向货量分析","√"]
[14,null,null,null,"合同物流分析","√"]
[15,null,null,null,"各区域客户业务量情况分析","√"]
[16,null,null,null,"报关报检业务分析","√"]
[{"$nulls":4},"关联交易分析"]
{"$rows_empty":10}
[17,{"$nulls":4},"√"]
[18,null,null,"仓储业务分析","应收分析","√"]
[19,null,null,null,"成本分析","√"]
[20,null,null,null,"业务量完成情况分析","√"]
[21,null,null,null,"货类分析","√"]
[22,null,null,null,"客户分析","√"]
[23,null,null,null,"货物周转率分析","√"]
[24,null,null,null,"仓库利用率分析","√"]
[25,null,null,"运输业务","作业量统计\n-客户总作业量\n-各装卸货港作业量\n-按货类统计作业量","√"]
[26,null,null,null,"驳船使用率","√"]
[27,null,null,null,"各港口装、卸货效率","√"]
[28,null,null,null,"卸货港损耗率","√"]
[29,null,null,null,"装、卸货时长","√"]
[30,null,null,null,"按货类分各航线的运输时长","√"]
[31,null,null,null,"自有船油耗分析","√"]
[32,null,null,null,"自有船维修、备件采购分析","√"]
[33,null,null,null,"作业数据反馈时效","√"]
[34,null,null,null,"驳船运输动态轨迹展现","√"]
[35,null,null,null,"作业量统计\n-客户总作业量\n-集装箱作业量\n-散货作业量\n-按货类统计作业量","√"]
[36,null,null,null,"供应商数据反馈时效","√"]
[37,null,null,null,"车辆运输动态轨迹展现","√"]
[38,null,null,null,"运输时长","√"]
[39,null,null,null,"堆场各项指标分析\n-还柜时长\n-还柜数量\n-修柜费分析","√"]
[40,null,null,null,"货代自提柜的货量深挖","√"]
[41,null,null,null,"散货运输损耗率","√"]
[42,null,null,null,"结算效率\n-应收、应付计费\n-开票收款时效","√"]
[43,null,null,null,"陆运历史运价查询及分析","√"]
[44,null,null,null,"账龄分析\n-应收账龄\n-应付账龄","√"]
[45,null,null,null,"自有船盈亏利润分析","√"]
[46,null,null,null,"利润率分析\n-按客户\n-按货类","√"]
[47,null,null,null,"预算达成率\n-作业量（按货类、按客户、按业务板块）\n-收入\n-成本（主营业务成本、销售成本、管理成本）\n-毛利\n-净利","√",{"$nulls":7},"报表梳理，简化合并\n关键用户提前进入可行性"]
[48,null,null,"船代业务分析","汇兑损益情况","√","外币汇兑"]
[49,null,null,null,"应收账款分析","√","1、 分客户应收、未收、账龄分析 \n2、船舶备用金"]
[{"$nulls":4},"收入成本分析（业务收入成本）",null,"毛利润=单船收入-单船成本\n时间 年季月、客户、板块、货类"]
[50,null,null,null,"成本分析","√","1、毛利润=营收-营成本   曲线图\n期间费用、成本构成 柱状堆积图\n2、预算、实际成本对比 柱状图下钻  成本构成过滤\n3、成本构成、凭证项目占比\n人均成本、营业费用率","成本、收入 3年对比、同比、环比","应收账款超账龄、成本超预算、船舶备用金超时、\n付款大于收款"]
[51,null,null,null,"业务量完成情况分析(如代理艘次、净吨等)","√","货类统计表\n业务后跟财务数据\n\n货类板块、客户、艘次、中英船名、货量"]
[52,null,null,null,"货类分析","√"]
[53,null,null,null,"客户分析","√","毛利、收入、货量 排名前十\n新老客户（委托方、推荐方、）","推荐方：无合同关系\n委托方：大部分是结算方 有合同关系\n结算单位：大部分委托，有合同关系\n系统客户创建时间 分新老"]
[54,null,"市场分析","客户分布",null,"√"]
[55,null,null,"topN客户",null,"√"]
[56,null,null,"市场占比分析",null,"√"]
[57,null,null,"业务区域分布",null,"√"]
[58,null,"KPI分析","运营相关KPI完成情况",null,"√"]
[59,null,null,"财务KPI分析",null,"√"]
[60,null,null,"市场KPI分析",null,"√"]
[61,null,null,"客户相关KPI完成情况",null,"√"]
[62,"财务分析","财务驾驶舱","财务驾驶舱",null,"√"]
[63,null,null,"月度例会",null,"√"]
[64,null,"收入分析","分析企业及各机构收入及趋势",null,"√"]
[65,null,null,"按产品分析收取",null,"√"]
[66,null,null,"按销售区域分析收入",null,"√"]
[67,null,null,"按业务类型分析收入",null,"√"]
[68,null,"成本分析","企业成本费用分析",null,"√"]
[69,null,null,"各部门成本分析",null,"√"]
[70,null,null,"成本费用趋势分析",null,"√"]
[71,null,null,"按产品分析成本",null,"√"]
[72,null,null,"成本构成分析",null,"√"]
[73,null,null,"税费分析",null,"√"]
[74,null,"利润分析","利润分析","按业务类型、按业务板块、单体分析","√"]
[75,null,"盈利能力分析","杜邦分析",null,"√"]
[76,null,null,"EVA分析","按时间维度、组织维度、关键移速等分析","√"]
[77,null,null,"股东视角分析","每股盈利，每股净资产","√"]
[78,null,"资金分析","融资分析","按融资规模、融资结构、融资成本分析","√"]
[79,null,null,"偿债能力分析","按长期、短期偿债能力分析","√"]
[80,null,null,"资金收支结余分析","资金收支结余分析","√"]
[81,null,null,"资金存量分析","资金存量分析","√"]
[82,null,null,"资金计划执行分析","资金计划执行分析","√"]
[83,null,null,"资金结构分析","资金结构分析","√"]
[84,null,null,"三项费用总体情况",null,"√"]
[85,null,null,"三项费用分项变动情况",null,"√"]
[86,null,null,"费用控制指标",null,"√"]
[87,null,null,"重点费用情况",null,"√"]
[88,null,null,"费用投入产出效益指标",null,"√"]
[89,null,null,"主要板块费用效益指标",null,"√"]
[90,null,"资产管理分析","资产管理综合分析","资产规模、资产收益、资产使用系哦效率等分析","×"]
[91,null,"预算分析","预算进度分析","跟踪预算进度","√"]
[92,"客户分析","客户总览","核心运营指标分析",null,"√"]
[93,null,null,"业务区域分布分析",null,"√"]
[94,null,null,"应收多维总览",null,"√"]
[95,null,null,"总体应收监控",null,"√"]
[96,null,"画像概览","客户质量分析",null,"√"]
[97,null,null,"营收驱动力分析",null,"√"]
[98,null,null,"客户分布概况",null,"√"]
[99,null,null,"客户留存分析",null,"√"]
[100,null,"收益贡献","客户营收分析",null,"√"]
[101,null,null,"增值收益分析",null,"√"]
[102,null,null,"潜力收益分析",null,"√"]
[103,null,null,"客户贡献分析",null,"√"]
[104,null,"合作分析","业务矩阵图",null,"√"]
[105,null,null,"合作雷达图",null,"√"]
[106,null,"风险管理","营收账期分析",null,"√"]
[107,null,null,"高危客户分析",null,"√"]
[108,null,null,"客户信用分析",null,"√"]
[109,"资源分析","仓储资源分析","货物信息可视化",null,"×"]
[110,null,null,"货物明细分析",null,"×"]
[111,null,null,"货主分析",null,"×"]
[112,null,null,"货物流向分析",null,"×"]
[113,null,null,"货物来源分析",null,"×"]
[114,null,null,"库存库龄分析",null,"×"]
[115,null,"人力资源分析","人力资源看板",null,"×"]
[116,null,null,"个人综合能力看板",null,"×"]
[117,null,null,"员工稳定性分析",null,"×"]
[118,null,"船舶拖车资源分析","船舶动态分析",null,"×"]
[119,null,null,"船舶流向分析",null,"×"]
[120,null,null,"运输价格分析",null,"×"]
[121,null,null,"运输工具成本分析",null,"×"]
[122,"LFS系统接口","开放LFS系统接口","订单、作业、费用、发票、收付款等",null,"√"]
[123,"系统现有功能调整","涉及到LFS相关的系统调整、修改，数据不足的补充等。",null,null,"√"]
[]
[]
[null,null,null,"市场部","散船、\n广州港到货量  侨益到货量占比   别家企业船代到货量占比 \n纬度：货名、时间、内外贸、码头"]
[{"$nulls":4},"集装箱、\n每家船公司到货量、箱量 占比\n货名、时间、内外贸、码头"]
[{"$nulls":4},"业务量\n货代、船代、仓储、运输、东北  板块、账套、模式（分拨类型）\n到货量、入库量定义不同\n同比环比\n全体板块占比","追溯3年数据"]
[{"$nulls":4},"客户  货名\n营业收入（开票金额） 前30\n业务成本\n分摊成本\n毛利\n净利 前30  \n各板块业务量求和前30   \n\n同比环比    全体板块占比","追溯3年数据"]
[{"$nulls":4},"分仓出入库作业量统计\n-按客户统计作业量\n-按货类统计作业量\n时间 每天第二天显示上一天"]
[{"$nulls":4},"库存存量&仓容利用率统计表"]
[{"$nulls":4},"分仓工人作业成本分析","取oa"]
[{"$nulls":4},"分仓油耗分析","财务相通"]
[{"$nulls":4},"分仓五金配件、维修成本分析"]
[{"$nulls":4},"分仓固定、变动成本分析",null,"专门针对仓租收入成本分析"]
[{"$nulls":4},"CRM统计表\n频率一月"]
[{"$nulls":4},"业务量、收入、利润目标完成率\n板块、公司、货类、散船集装箱\n年度、月度"]
[{"$nulls":4},"北粮南运，南粮北运 整个货物流程，业务量",null,"kpi待完善、待解决方案"]
[{"$nulls":4},"生生与广西侨益协同量统计"]
[{"$nulls":4},"船代、货代、仓储、运输 协同量统计"]
[{"$nulls":4},"安全统计表"]
[{"$nulls":4},"客户满意度\n季度"]
[{"$nulls":4},"客户 业务数据侨益占比\n货类、散船集装箱\n年度"]
[{"$nulls":4},"不止广州港，东北港口、营口、鲅鱼圈、大连、上海、舟山、南通、湛江、茂名、钦州、防城港、深圳、麻涌、蛇口"]
[null,null,null,"人力资源看板"]
[{"$nulls":4},"人工程成本预算进度\n单位、岗位  类别（福利、社保公积金、工资等）下钻、占比","汇总对比"]
[{"$nulls":4},"薪酬\n人工成本汇总\n单位、岗位 、层级、 类别（福利、社保公积金、工资等）下钻\n各层级人均、占比\n季度\n",null,"excel导入","工资发放   是否可拆更小粒度"]
[{"$nulls":4},"人均利润率、部门利润率\n",null,null,"公积金"]
[{"$nulls":7},"社保"]
[]
[]
[null,null,null,"人力资源看板","人事报表\n入职人员离职人员\n人员流失率\n部门、岗位人员流失率\n工龄、学历、年龄、性别、户籍、职位\n\n入转调离人数\n月、季、半年、年\n","oa花名册取数据\n取员工变动明细记录","3年度   流失率预警值\n"]
[{"$nulls":4},"晋升年限、离职在司时长"]
[{"$nulls":4},"离职人员\n工龄、学历、年龄、性别、户籍、职位、核心岗位\n离职原因、层级占比\n","实习生、正式员工"]
[{"$nulls":4},"招聘计划 完成率  需求，已完成、招聘率\n岗位、时间变化趋势\n年、季度、半年\n","30天期限"]
[{"$nulls":4},"考勤\n加班时长\n部门、岗位、\n工作时长(小时)\n迟到(分钟)\n早退(分钟)\n加班(小时)\n旷工(天)\n外勤(次)\n出差\n请假\n时间层面对比\n","分部门人数","3年度对比"]
[]
[{"$nulls":4},"目标\n费用类  控制",null,"2017要不要治理\n"]
[{"$nulls":4},"业绩类  监控",null,"公司、账套权限分配"]
[{"$nulls":4},"毛利率  专题分析",null,"账户角色和公司同步"]
[{"$nulls":4},"单票核算"]

{"sheet":"Sheet3","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,0,6,6]]}
["序号","项目名称","描述","单位","数量","价格","备注"]
[1,"现场实施","用户现场需求调研、产品安装、调试、试运行跟踪","元",1,null,"提供3人月的现场实施"]
[2,"咨询培训","系统的安装、操作、管理培训及日常使用咨询"]
[3,"技术支持","提供7*24热线支持、远程接入的服务支持、故障诊断、性能调优、一般性功能修改","元",1,null,"正式上线后6个月内"]
[4,"客户化调整"," "]
[null,"小计"]
[" 其他服务部分"]
[1,"永洪BI套件","包含PC端，移动端，大屏展示功能，不限制用户授权，多维报表，联机自助分析","元",1,null,"岸基一级代理特权，无限用户"]