产品销售数据可视化看板(带表格图标公式).xlsx

单价已销售数量总计进货总数剩余成本价进货成本产品A36501,80010050202,000产品B243276810068121,200产品C156597510035990080.00%100.00%66.67%产品A产品B产品C5032651,800768975产品A产品B产品C0 500 1,000 1,500 2,000 010203040506070已销售数量总计2,0001,2009001,6001,200600产品A产品B产品C2,500 2,000 1,500 1,000 500 0 进货成本全部销售完获利金额已销产品数量及金额剩余产品数量及进货总数单价产品利润率对比单价产品利润率对比产品销售数据可视化看板单价利润单件利润率还差多少钱回收成本全部销售完获利金额1680.00%2001,60012100.00%4321,200666.67%已回收成本600产品A,1,800,51%产品B,768,22%产品C,975,27%已销产品金额占比2,0001,2009001,6001,200600产品A产品B产品C2,500 2,000 1,500 1,000 500 0 进货成本全部销售完获利金额剩余产品数量及进货总数单价产品利润率对比产品销售数据可视化看板